if ($impoExpo == "E") {
$PREONC_CC = $PRE_CC;
} elseif ($impoExpo == "I") {
$PREONC_CC = $ONC_CC;
}
if ($impoExpo == "E") {
$PREONC_EE = $PRE_EE;
} elseif ($impoExpo == "I") {
$PREONC_EE = $ONC_EE;
}
// Otros cargos PP
$OC_PP = updateChargesUsd($bl, $eta, 'P', 'OCPPx', 1);
$OC_CC = updateChargesUsd($bl, $eta, 'C', 'OCPPx', 1);
$OC_EE = updateChargesUsd($bl, $eta, 'E', 'OCPPx', 1);
// DOC.FEE PP
$DOCFEE_PP = updateChargesUsd($bl, $eta, 'P', 'DOC');
// MANIFEST CORRECTOR
$MC_PP_Local = updateChargesLocalUsd($bl, $eta, 'P', 'MANIFEST CORRECTOR');
// Comision
$comision = $FRT_PP + $FRT_CC + $FRT_EE;
// ToPrepaid
if ($impoExpo == "E") {
// Suma de todoo lo Prepaid
$toPPCC = $FRT_PP + $THC_PP + $PRE_PP + $ONC_PP + $OC_PP + $DOCFEE_PP + $MC_PP_Local;
} elseif ($impoExpo == "I") {
// Suma de todoo lo Prepaid
$toPPCC = $FRT_CC + $THC_CC + $PRE_CC + $ONC_CC + $OC_CC;
}
// Actualizar en SION los montos
$sql2 = "\n update EXPO set\n Id_barco='{$idBarco}',\n Loading='{$pol}',\n Discharge='{$pod}',\n Prepaid='{$FRT_PP}',\n Collect='{$FRT_CC}',\n Eelse='{$FRT_EE}',\n Thc_pp='{$THC_PP}',\n Thc_cc='{$THC_CC}',\n Thc_else='{$THC_EE}',\n Precarr_pp='{$PREONC_PP}',\n Precarr_cc='{$PREONC_CC}',\n Precarr_else='{$PREONC_EE}',\n Charge_pp='{$OC_PP}',\n Charge_cc='{$OC_CC}',\n Charge_else='{$OC_EE}',\n Comission='{$comision}',\n To_prepaid='{$toPPCC}',\n Doc_fee='{$DOCFEE_PP}',\n Manifest_corrector='{$MC_PP_Local}',\n bl_status_msclink='{$blStatus}'\n\n where Id_expo='{$idBl}'\n ";
$db2->query($sql2);
$PREONC_PP = $ONC_PP;
}
if ($impoExpo == "E") {
$PREONC_CC = $PRE_CC;
} elseif ($impoExpo == "I") {
$PREONC_CC = $ONC_CC;
}
if ($impoExpo == "E") {
$PREONC_EE = $PRE_EE;
} elseif ($impoExpo == "I") {
$PREONC_EE = $ONC_EE;
}
// Otros cargos PP
$OC_PP = updateChargesUsd($bl, $eta, 'P', 'OCPP', 1);
$OC_CC = updateChargesUsd($bl, $eta, 'C', 'OCPP', 1);
$OC_EE = updateChargesUsd($bl, $eta, 'E', 'OCPP', 1);
// Comision
$comision = $FRT_PP + $FRT_CC + $FRT_EE;
// ToPrepaid
if ($impoExpo == "E") {
// Suma de todoo lo Prepaid
$toPPCC = $FRT_PP + $THC_PP + $PRE_PP + $ONC_PP + $OC_PP;
} elseif ($impoExpo == "I") {
// Suma de todoo lo Prepaid
$toPPCC = $FRT_CC + $THC_CC + $PRE_CC + $ONC_CC + $OC_CC;
}
// Actualizar en SION los montos
$sql2 = "\n update EXPO set\n Prepaid='{$FRT_PP}',\n Collect='{$FRT_CC}',\n Eelse='{$FRT_EE}',\n Thc_pp='{$THC_PP}',\n Thc_cc='{$THC_CC}',\n Thc_else='{$THC_EE}',\n Precarr_pp='{$PREONC_PP}',\n Precarr_cc='{$PREONC_CC}',\n Precarr_else='{$PREONC_EE}',\n Charge_pp='{$OC_PP}',\n Charge_cc='{$OC_CC}',\n Charge_else='{$OC_EE}',\n Comission='{$comision}',\n To_prepaid='{$toPPCC}'\n where Id_expo='{$idBl}'\n ";
$db2->query($sql2);
update2040($bl);
echo "[Actualizado] {$bl} <br>";
