if($Opcion==11) //Tranferir SLAM 28-Enero-2021 
{ 
 
	 if(isset($_POST['varelemento'])){$Usuarioid=$_POST['varelemento'];}else{$Usuarioid=false;} 
	 if(isset($_POST['elemento'])){$prmtxtnumPrefactura=$_POST['elemento'];}else{$prmtxtnumPrefactura=false;} 	
	 
	$sqlPedimento="select v353pedimento from sic353prefactura where i353idprefactura=$prmtxtnumPrefactura";                       
	$paramsPedimento = array();  
	$optionsPedimento =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );    
	$stmtPedimento = sqlsrv_query( $conn, $sqlPedimento , $paramsPedimento, $optionsPedimento);      
	$row_countPedimento = sqlsrv_num_rows($stmtPedimento);   
	//echo '</br>';  
 
	if($row_countPedimento > 0){                               
	  
		while($rowPedimento = sqlsrv_fetch_array($stmtPedimento, SQLSRV_FETCH_ASSOC))    
		{          
			$v353pedimento= $rowPedimento["v353pedimento"];
		
	 
	$d354costo= 0;
	$v353referencia= false;	 
	$sqlConceptoCruce="select d354costo, v353referencia from sic353prefactura
	join sic354prefacturadetalle on i353idprefactura=n354idprefactura
	where n354idconcepto in (  select i004idconcepto from sic004conceptos where v004nomconcepto like '%Cruce / Transfer%')
	and v353pedimento=$v353pedimento";                       
	$paramsConceptoCruce = array();  
	$optionsConceptoCruce =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );    
	$stmtConceptoCruce = sqlsrv_query( $conn, $sqlConceptoCruce , $paramsConceptoCruce, $optionsConceptoCruce);      
	$row_countConceptoCruce = sqlsrv_num_rows($stmtConceptoCruce);   
	//echo '</br>';  
 
	if($row_countConceptoCruce > 0){                               
	  
		while($rowConceptoCruce = sqlsrv_fetch_array($stmtConceptoCruce, SQLSRV_FETCH_ASSOC))    
		{          
			$d354costo= $rowConceptoCruce["d354costo"];
			//echo '</br>';
			$v353referencia= $rowConceptoCruce["v353referencia"]; 
			 
			if($v353referencia!='') 
			{
				$sqlSLAMCruce = "UPDATE [Aduana].[dbo].[tblNotaRevGen] SET ADICFLETESINCDLLS = ? WHERE Referencia= ? ";                   
				$paramsSLAMCruce = array($d354costo,$v353referencia);   
				$stmtSLAMCruce = sqlsrv_query( $conn, $sqlSLAMCruce, $paramsSLAMCruce); 
			}
		}
	}
	
	$d354costoOtros= 0; 
	$v353referenciaOtros= false;    
	$sqlConceptoOtros="select sum(d354costo) as sumd354costo, v353referencia from sic353prefactura
	join sic354prefacturadetalle on i353idprefactura=n354idprefactura
	where n354idconcepto not in (  select i004idconcepto from sic004conceptos where v004nomconcepto like '%Cruce / Transfer%')
	and v353pedimento=$v353pedimento group by v353referencia";                       
	$paramsConceptoOtros = array();  
	$optionsConceptoOtros =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );    
	$stmtConceptoOtros = sqlsrv_query( $conn, $sqlConceptoOtros , $paramsConceptoOtros, $optionsConceptoOtros);      
	$row_countConceptoOtros = sqlsrv_num_rows($stmtConceptoOtros); 
	
	if($row_countConceptoOtros > 0){                               
	    
		while($rowConceptoOtros = sqlsrv_fetch_array($stmtConceptoOtros, SQLSRV_FETCH_ASSOC))    
		{          
			
			$d354costoOtros= $rowConceptoOtros["sumd354costo"];
			$v353referenciaOtros= $rowConceptoOtros["v353referencia"];
			   
			if($v353referenciaOtros!='')  
			{ 	 
		        //echo '</br>'; 
				$sqlSLAMOtros = "UPDATE [Aduana].[dbo].[tblNotaRevGen] SET ADICOTROSINCDLLS = ? WHERE Referencia= ? ";                   
				$paramsSLAMOtros = array($d354costoOtros,$v353referenciaOtros);   
				$stmtSLAMOtros = sqlsrv_query( $conn, $sqlSLAMOtros, $paramsSLAMOtros);  
				
				$TotalIncDlls=$d354costo+$d354costoOtros;
				
				$sqlSLAMOtros = "UPDATE [Aduana].[dbo].[tblNotaRevGen] SET OtrosAmDlls = ? WHERE Referencia= ? ";                       
				$paramsSLAMOtros = array($TotalIncDlls,$v353referenciaOtros);   
				$stmtSLAMOtros = sqlsrv_query( $conn, $sqlSLAMOtros, $paramsSLAMOtros);  
			}
			//TotalIncDlls= ?,TotalCAmDlls = ?
			
			$sqlUpdatePF = "UPDATE sic353prefactura SET v353usuarioUPSLAM = ?, f353fechaUPSLAM = ? WHERE i353idprefactura = ?";                   
			$paramsUpdatePF = array($Usuarioid,$fechaActual,$prmtxtnumPrefactura);   
			$stmtUpdatePF = sqlsrv_query( $conn, $sqlUpdatePF, $paramsUpdatePF);
			
		}
	} 
	 
	 }
	}
	 
	 
	 
	 if($stmtUpdatePF != false ) {  
	 echo '{"d":'.json_encode($paramsUpdatePF).'}';  	    	
	 }    	
	   
}