$write->query("insert into `manifestdata` (manifest_code, manifest_status, manifest_date) values('".$data[0]."', '".$data[1]."', '".$fromdate."')");
//echo $qu1."<br>";
}
}
}*/
//die;
echo "<br>manifest code done..<br>";
//manifest code end
//************
//manifestdata code start
$results = $read->fetchAll("select * from `manifestdata` GROUP BY manifest_code");
$write->query("truncate `invoice_uniware_data_credit`");
foreach ($results as $rs) {
$manifest_code = $rs['manifest_code'];
$shippingManifest = $soapClient->GetShippingManifest(array('ShippingManifestCode' => $manifest_code));
if (count($shippingManifest->ManifestItems->ManifestItem) == 1) {
$all_shippingManifest = $shippingManifest->ManifestItems;
} else {
$all_shippingManifest = $shippingManifest->ManifestItems->ManifestItem;
}
foreach ($all_shippingManifest as $sm) {
//$shippack =$soapClient->SearchShippingPackage(array('ShippingPackageCode'=>'BLR104084','SearchOptions'=>array('DisplayStart'=>'0')));
//echo "<pre>"; print_r($shippack); die;
$shippack = $soapClient->SearchShippingPackage(array('ShippingPackageCode' => $sm->ShippingPackageCode, 'SearchOptions' => array('DisplayStart' => '0')));
//print_r($sm); die;
//echo "test<br>";
$status = $shippack->ShippingPackages->ShippingPackage->Status;
$write->query("insert into `invoice_uniware_data_credit` (ManifestCode, AirWayBillNumber, ShippingPackageCode, DisplayOrderCode, InvoiceCode, Quantity, DeclaredValue, ShippingCharges, CollectableAmount, ShippingMethodCode, order_status) values('" . $manifest_code . "', '" . $sm->AirWayBillNumber . "', '" . $sm->ShippingPackageCode . "', '" . $sm->DisplayOrderCode . "', '" . $sm->InvoiceCode . "', '" . $sm->Quantity . "', '" . $sm->DeclaredValue . "', '" . $sm->ShippingCharges . "', '" . $sm->CollectableAmount . "', '" . $sm->ShippingMethodCode . "', '" . $status . "')");
}
}
