} $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 {