}
$page = $page - 1;
//$results = $read->fetchAll("select * from `manifestdata` GROUP BY manifest_code");
//foreach($results as $rs){
/*$manifest_code = 'SM7443';
$shippingManifest = $soapClient->GetShippingManifest(array('ShippingManifestCode'=>$manifest_code));
//print_r($shippingManifest);
if(count($shippingManifest->ManifestItems->ManifestItem) == 1){
$all_shippingManifest = $shippingManifest->ManifestItems;
}else{
$all_shippingManifest = $shippingManifest->ManifestItems->ManifestItem;
}
foreach($all_shippingManifest as $sm){ */
//echo "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."', '".$shippingManifest->Status."')";
//echo $sm->ShippingPackageCode; exit;
$shippack = $soapClient->SearchShippingPackage(array('ShippingPackageCode' => 'BLR083641', 'SearchOptions' => array('DisplayStart' => '0')));
//print_r($shippack); exit;
echo $shippack->ShippingPackages->ShippingPackage->Status;
exit;
/*
//$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."', '".$sm->Status."')");
}
/*}
$todate = Mage::getModel('core/date')->date('Y-m-d');
$todate = $todate."T00:00:00";
$body = "TEST Manifestdata.php";
$subject = $todate." - Manifestdata.php";
$fromEmail = "*****@*****.**";
$toEmail = "*****@*****.**";
$mail = new Zend_Mail();
$mail->setBodyHtml($body);
$destination = "/home2/html/zofya/public_html/mw_invoice_loyalty/downloads/manifest_" . $cur_date . ".csv";
$handle = fopen($destination, "r");
if ($export->Status == "COMPLETE") {
while (($data = fgetcsv($handle, 0, ",")) !== FALSE) {
if ($data[1] == "CLOSED") {
$write->query("insert into `mw_loyalty_manifestdata` (manifest_code, manifest_status, manifest_date) values('" . $data[0] . "', '" . $data[1] . "', '" . $fromdate . "')");
}
}
}
echo "<br>manifest code done..<br>";
//manifest code end
//************
$resultss = $read->fetchAll("select * from mw_loyalty_invoice_uniware where order_status!='DELIVERED'");
if (count($resultss) > 0) {
foreach ($resultss as $rs) {
$shippack = $soapClient->SearchShippingPackage(array('ShippingPackageCode' => $rs[ShippingPackageCode], 'SearchOptions' => array('DisplayStart' => '0')));
$status = $shippack->ShippingPackages->ShippingPackage->Status;
//echo $rs['DisplayOrderCode']." ".$status."<br>";
if ($status != "") {
$write->query("update `mw_loyalty_invoice_uniware` SET `order_status`='" . $status . "' where `DisplayOrderCode`='" . $rs[DisplayOrderCode] . "'");
}
}
}
//manifestdata code start
$results = $read->fetchAll("select * from `mw_loyalty_manifestdata` GROUP BY manifest_code");
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 {
