public function updateorderstatus()
{
//$from = 'Robin'; // sender
//$subject = 'ABCD';
$message = 'Cron Job Running123456';
// message lines should not exceed 70 characters (PHP rule), so wrap it
//$message = wordwrap($message, 70);
// send mail
$from = 'Arun';
// sender
$subject = 'ABCD12345';
$wsdlUrl = Mage::getStoreConfig('unicom_options/unigroup/uniurl');
$wsdllUrl = Mage::getStoreConfig('unicom_options/unigroup/unilurl');
$username = Mage::getStoreConfig('unicom_options/unigroup/uniusername');
$password = Mage::getStoreConfig('unicom_options/unigroup/unipass');
/*$wsdlUrl = "https://demo.unicommerce.com/services/soap/uniware15.wsdl";
$wsdllUrl = "http://demo.unicommerce.com/services/soap/?version=1.5&facility=01";
$username = "******";
$password = "******"; */
$soapClient = new SoapClient($wsdlUrl, array('trace' => 1, 'exception' => 0));
$soapClient->__setLocation($wsdllUrl);
$strWSSENS = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd";
$objSoapVarUser = new SoapVar($username, XSD_STRING, NULL, $strWSSENS, "UserName", $strWSSENS);
$objSoapVarPass = new SoapVar($password, XSD_STRING, NULL, $strWSSENS, "Password", $strWSSENS);
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
//Mage::app('default');
$model = Mage::getModel('rcredit/rcredit');
$order = new Mage_Sales_Model_Order();
$order_details = $model->orderids();
//print_r($order_details);
$i = 0;
$check = array();
$msg = array();
foreach ($order_details as $details) {
$msg[] = $details[order_id];
$shipping = $soapClient->GetSaleOrder(array('SaleOrder' => array('Code' => $details[order_id])));
//echo '<pre>';
//print_r($shipping);
$delivcnt = count($shipping->SaleOrder->ShippingPackages->ShippingPackage);
foreach ($shipping->SaleOrder->ShippingPackages as $v) {
$order->loadByIncrementId($details[order_id]);
$payment = $order->getPayment()->getMethodInstance()->getCode();
$customer_status = $model->customerstatus($order->getCustomerEmail());
if ($delivcnt > 1) {
$deliverDate = $v[$delivcnt - 1]->DeliveredOn;
$vstatus = $v[$delivcnt - 1]->StatusCode;
} else {
$deliverDate = $v->DeliveredOn;
$vstatus = $v->StatusCode;
}
if ($vstatus == 'DELIVERED') {
$day = explode('T', $deliverDate);
if ($day[0] >= $customer_status['credit_start_date']) {
//echo 'In Second Cycle'.$details[cycle].'-->'.$details[order_id].'-->'.$details[order_value].'-->'.$order->getCustomerEmail().'-->'.$customer_status[credit_cycle].'-->'.$customer_status[utlized_amt];
//echo '<br/>';
$model->updateordercycle($details[order_id], $customer_status[credit_cycle]);
}
$model->updateorderdate($details[order_id], $day[0]);
}
$i++;
}
//mail("*****@*****.**",$subject,$details[order_id],"From: $from\n");
$order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('increment_id', $details[order_id])->getFirstItem();
if ($order->getStatus() == 'Canceled' || $order->getStatus() == 'canceled') {
$order->loadByIncrementId($details[order_id]);
$payment = $order->getPayment()->getMethodInstance()->getCode();
if ($payment == 'rcredit') {
$payment_status = 'Refund';
$order_cycle_value = $model->ordercyclehistory($details[order_id]);
//Getting the cycle using the order_id.
$cycle = $order_cycle_value['cycle'];
$customer_email = $order->getCustomerEmail();
$grandtotal = round($details[order_value], 2);
$customer_status = $model->customerstatus($customer_email);
// Getting the customer status from the Shopper Credit Module
$customer_credit_limit = $customer_status['credit_limit'];
// Getting customer's credit limit.
$customer_current_bal = $customer_status['bal_amt'];
// Getting customer's current balance
$balance_amount = $customer_status['bal_amt'] + $grandtotal;
// Calculating the updated balance after sucessful purchase.
$utlized_amt = $customer_status['utlized_amt'];
// Getting customer's current balance
$total_used_amt = $utlized_amt - $grandtotal;
// Getting the total utlized amt.
$pay_interval = $customer_status['pay_interval'];
// Getting customer's payinterval date
$expiry_date = $customer_status['enddate'];
// Getting expiry date for the customer
$action = 'Refund due to cancellation';
$todate = date("Y-m-d");
$order_status = "Cancel";
if ($order_cycle_value['action'] != 'Cancel') {
$model->cancelledorderdetails($details[order_id], $total_used_amt, $balance_amount, $action, $order_status);
$model->updateoncancel($grandtotal, $customer_email, $cycle);
}
}
}
}
}
public function unishipimport()
{
$wsdlUrl = Mage::getStoreConfig('unicom_options/unigroup/uniurl');
$wsdllUrl = Mage::getStoreConfig('unicom_options/unigroup/unilurl');
$username = Mage::getStoreConfig('unicom_options/unigroup/uniusername');
$password = Mage::getStoreConfig('unicom_options/unigroup/unipass');
$soapClient = new SoapClient($wsdlUrl, array('trace' => 1, 'exception' => 0));
$soapClient->__setLocation($wsdllUrl);
$strWSSENS = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd";
$objSoapVarUser = new SoapVar($username, XSD_STRING, NULL, $strWSSENS, "UserName", $strWSSENS);
$objSoapVarPass = new SoapVar($password, XSD_STRING, NULL, $strWSSENS, "Password", $strWSSENS);
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$writeConnection = $resource->getConnection('core_write');
$query = 'SELECT a.*,b.* FROM `sales_flat_order` as a,`unicom_invoice` as b WHERE a.increment_id = b.order_id and b.pdf_complete = "No" and a.state NOT IN ("canceled","pending")';
$orders = $readConnection->fetchAll($query);
foreach ($orders as $order) {
$shipping = $soapClient->GetSaleOrder(array('SaleOrder' => array('Code' => $order['increment_id'])));
if ($shipping->Successful == 1) {
$chkshippackages = count(get_object_vars($shipping->SaleOrder->ShippingPackages));
if ($chkshippackages > 0) {
$shippackages = $shipping->SaleOrder->ShippingPackages->ShippingPackage;
if (is_array($shippackages)) {
foreach ($shippackages as $shippackage) {
if ($shippackage->ShipmentCode) {
if ($order['ship_code'] == '' && $order['state'] == 'complete') {
$shipSelect = "SELECT ship_code FROM `unicom_invoice` WHERE ship_code != '' and order_id = '" . $order['increment_id'] . "'";
$shipcodes = $readConnection->fetchAll($shipSelect);
if (count($shipcodes) > 0) {
$insertquery = "INSERT INTO `unicom_invoice` (`order_id`, `ship_code`, `state_complete`, `pdf_complete`) VALUES ('" . $order['increment_id'] . "', '" . $shippackage->ShipmentCode . "', 'Yes', 'No')";
$writeConnection->query($insertquery);
} else {
$insertquery = "UPDATE `unicom_invoice` SET state_complete = 'Yes',ship_code = '" . $shippackage->ShipmentCode . "' WHERE order_id = '" . $order['increment_id'] . "'";
$writeConnection->query($insertquery);
}
} elseif ($order['ship_code'] == '') {
$shipSelect = "SELECT ship_code FROM `unicom_invoice` WHERE ship_code != '' and order_id = '" . $order['increment_id'] . "'";
$shipcodes = $readConnection->fetchAll($shipSelect);
if (count($shipcodes) > 0) {
$insertquery = "INSERT INTO `unicom_invoice` (`order_id`, `ship_code`, `state_complete`, `pdf_complete`) VALUES ('" . $order['increment_id'] . "', '" . $shippackage->ShipmentCode . "', 'No', 'No')";
$writeConnection->query($insertquery);
} else {
$insertquery = "UPDATE `unicom_invoice` SET ship_code = '" . $shippackage->ShipmentCode . "' WHERE order_id = '" . $order['increment_id'] . "'";
$writeConnection->query($insertquery);
}
} elseif ($order['ship_code'] != '' && $order['state'] == 'complete') {
$shipSelect = "SELECT ship_code FROM `unicom_invoice` WHERE ship_code ='" . $shippackage->ShipmentCode . "'";
$shipcodes = $readConnection->fetchAll($shipSelect);
if (count($shipcodes) > 0) {
$insertquery = "UPDATE `unicom_invoice` SET state_complete = 'Yes' WHERE ship_code = '" . $order['ship_code'] . "'";
$writeConnection->query($insertquery);
} else {
$insertquery = "INSERT INTO `unicom_invoice` (`order_id`, `ship_code`, `state_complete`, `pdf_complete`) VALUES ('" . $order['increment_id'] . "', '" . $shippackage->ShipmentCode . "', 'Yes', 'No')";
$writeConnection->query($insertquery);
}
} else {
$shipSelect = "SELECT ship_code FROM `unicom_invoice` WHERE ship_code ='" . $shippackage->ShipmentCode . "'";
$shipcodes = $readConnection->fetchAll($shipSelect);
if (count($shipcodes) < 1) {
$insertquery = "INSERT INTO `unicom_invoice` (`order_id`, `ship_code`, `state_complete`, `pdf_complete`) VALUES ('" . $order['increment_id'] . "', '" . $shippackage->ShipmentCode . "', 'Yes', 'No')";
$writeConnection->query($insertquery);
}
}
}
}
} else {
if ($shippackages->ShipmentCode) {
if ($order['ship_code'] == '' && $order['state'] == 'complete') {
$insertquery = "UPDATE `unicom_invoice` SET state_complete = 'Yes',ship_code = '" . $shippackages->ShipmentCode . "' WHERE order_id = '" . $order['increment_id'] . "'";
$writeConnection->query($insertquery);
} elseif ($order['ship_code'] == '') {
$insertquery = "UPDATE `unicom_invoice` SET ship_code = '" . $shippackages->ShipmentCode . "' WHERE order_id = '" . $order['increment_id'] . "'";
$writeConnection->query($insertquery);
} elseif ($order['ship_code'] != '' && $order['state'] == 'complete') {
$insertquery = "UPDATE `unicom_invoice` SET state_complete = 'Yes' WHERE order_id = '" . $order['increment_id'] . "'";
$writeConnection->query($insertquery);
}
}
}
}
}
}
}
$objSoapVarPass = new SoapVar($password, XSD_STRING, NULL, $strWSSENS, "Password", $strWSSENS);
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
$write->query("truncate `mw_partial_ship`");
$results = $read->fetchAll("select `DisplayOrderCode` from mw_loyalty_invoice_uniware where invoice_done=0");
//$results = $read->fetchAll("select `DisplayOrderCode` from mw_loyalty_invoice_uniware where DisplayOrderCode='150516C-528516'");
if (count($results) > 0) {
foreach ($results as $rs) {
$orderIncrementId = $rs['DisplayOrderCode'];
echo $orderIncrementId;
$orderDetails = $soapClient->GetSaleOrder(array('SaleOrder' => array('Code' => $orderIncrementId)));
if (count($orderDetails->SaleOrder->SaleOrderItems->SaleOrderItem) > 0) {
if (count($orderDetails->SaleOrder->SaleOrderItems->SaleOrderItem) == 1) {
$temporderDetails = $orderDetails->SaleOrder->SaleOrderItems;
} else {
$temporderDetails = $orderDetails->SaleOrder->SaleOrderItems->SaleOrderItem;
}
foreach ($temporderDetails as $tm) {
echo $tm->ItemSKU . " >>> " . $tm->ShippingPackageCode . "<br>";
$resultqty = $read->fetchRow("select `qty` from `mw_partial_ship` where ItemSKU='" . $tm->ItemSKU . "' and ShippingPackageCode='" . $tm->ShippingPackageCode . "'");
if ($resultqty['qty'] > 0) {
$qty = $resultqty['qty'] + 1;
$write->query("update `mw_partial_ship` SET qty={$qty} where ItemSKU='" . $tm->ItemSKU . "' and ShippingPackageCode='" . $tm->ShippingPackageCode . "'");
} else {
$write->query("insert into `mw_partial_ship` (order_id, ItemSKU, ShippingPackageCode, qty) values('" . $orderIncrementId . "', '" . $tm->ItemSKU . "', '" . $tm->ShippingPackageCode . "', 1)");
}
public function runbabyrun()
{
$from = 'Robin';
// sender
$subject = 'RunbabyRun';
$message = 'RunbabyRun';
// message lines should not exceed 70 characters (PHP rule), so wrap it
$message = wordwrap($message, 70);
// send mail
mail("*****@*****.**", $subject, $message, "From: {$from}\n");
$wsdlUrl = Mage::getStoreConfig('unicom_options/unigroup/uniurl');
$wsdllUrl = Mage::getStoreConfig('unicom_options/unigroup/unilurl');
$username = Mage::getStoreConfig('unicom_options/unigroup/uniusername');
$password = Mage::getStoreConfig('unicom_options/unigroup/unipass');
/*$wsdlUrl = "https://demo.unicommerce.com/services/soap/uniware15.wsdl";
$wsdllUrl = "http://demo.unicommerce.com/services/soap/?version=1.5&facility=01";
$username = "******";
$password = "******"; */
$soapClient = new SoapClient($wsdlUrl, array('trace' => 1, 'exception' => 0));
$soapClient->__setLocation($wsdllUrl);
$strWSSENS = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd";
$objSoapVarUser = new SoapVar($username, XSD_STRING, NULL, $strWSSENS, "UserName", $strWSSENS);
$objSoapVarPass = new SoapVar($password, XSD_STRING, NULL, $strWSSENS, "Password", $strWSSENS);
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
$count = "";
$flag = 0;
umask(0);
Mage::app('default');
$model = Mage::getModel('rcredit/rcredit');
$todate = date("Y-m-d");
$start_date_month = date('Y-m-02', strtotime($todate));
$j = 0;
$customer_details = $model->customerdetails();
//echo '<pre>';
//print_r($customer_details);
$date = new DateTime($start_date_month);
//if($todate == $start_date_month)
//{
for ($j = 0; $j < count($customer_details); $j++) {
$order_details = $model->orderhistory($customer_details[$j]['email'], $customer_details[$j]['credit_cycle'] - 1);
//print_r($order_details);die;
$new_cycle = $customer_details[$j]['credit_cycle'] + 1;
$month = $date->format("m");
$year = $date->format("Y");
$days_in_month = date('t');
$payment_days = $days_in_month + 0 + $customer_details[$j]['pay_interval'];
//days in current month + 2 days + pay interval days
$expiry_date = date('Y-m-d', strtotime('+' . $days_in_month . ' days', strtotime($start_date_month)));
// Getting the credit expiry date
$payment_date = date('Y-m-d', strtotime('+' . $payment_days . ' days', strtotime($start_date_month)));
// Getting the payment expiry date
$sub_total_final = array();
$order_ids = array();
$subtotal = 0;
$i = 0;
if ($order_details != NULL) {
foreach ($order_details as $details) {
$order = Mage::getModel('sales/order')->load($details['order_id'], 'increment_id');
$items = $order->getAllItems();
foreach ($items as $item) {
$itemcount = $item->getQtyOrdered();
$item_count = $item_count + $itemcount;
}
$deliverydate = $model->deliverydate($details['order_id']);
foreach ($deliverydate as $delivery) {
if (($order->getStatus() == 'Complete' || $order->getStatus() == 'complete') && $delivery[order_complete_date] < $start_date_month) {
$order_ids[$i] = trim($details['order_id']);
$shipping = $soapClient->GetSaleOrder(array('SaleOrder' => array('Code' => $order_ids[$i])));
if ($item_count == 1) {
foreach ($shipping->SaleOrder->SaleOrderItems as $SaleOrderItem) {
if (trim($SaleOrderItem->StatusCode) == 'DELIVERED' || $SaleOrderItem->StatusCode == 'DELIVERED') {
$total = $SaleOrderItem->SellingPrice;
$subtotal = $subtotal + $total;
}
}
} elseif ($item_count > 1) {
foreach ($shipping->SaleOrder->SaleOrderItems->SaleOrderItem as $v) {
if (trim($v->StatusCode) == 'DELIVERED' || $v->StatusCode == 'DELIVERED') {
$total = $v->SellingPrice;
$subtotal = $subtotal + $total;
}
}
}
round($subtotal, 2);
$deciaml_pos = explode('.', $subtotal);
if ($deciaml_pos[1] >= 5) {
$subtotal = ceil($subtotal);
} elseif ($deciaml_pos[1] < 5) {
$subtotal = floor($subtotal);
}
$sub_total_final[$i] = $subtotal;
$i++;
$subtotal = 0;
}
if (($order->getStatus() == 'Complete' || $order->getStatus() == 'complete') && $delivery[order_complete_date] > $start_date_month) {
$customer_total = 0;
}
}
$item_count = 0;
}
$lasy_key = key(array_slice($order_ids, -1, 1, TRUE));
for ($k = 0; $k <= $lasy_key; $k++) {
if ($order_ids[$k] != NULL && $sub_total_final[$k] != NULL) {
//$model->unicomupdate($order_ids[$k],$sub_total_final[$k]); //Update against each order
}
$customer_total = $customer_total + $sub_total_final[$k];
}
round($customer_total, 2);
$deciaml_no = explode('.', $customer_total);
if ($deciaml_no[1] >= 5) {
$customer_total = ceil($customer_total);
} elseif ($deciaml_no[1] < 5) {
$customer_total = floor($customer_total);
}
$bal_amount = $customer_details[$j]['credit_limit'] - $customer_total;
//echo $customer_details[$j]['email'].$customer_total.'---'.$customer_details[$j]['credit_limit'].'Balance '.$bal_amount;
//echo '<br/>';
//$model->finalupadte($customer_details[$j]['email'],$customer_total,$bal_amount,2);
$freeSubTotal = Mage::getStoreConfig('carriers/freeshipping/free_shipping_subtotal');
if ($customer_total > $freeSubTotal) {
$customer_total = $customer_total;
} else {
if ($customer_total < $freeSubTotal && $customer_total != 0) {
$shipping_rate = Mage::getStoreConfig('carriers/flatrate/price');
$shipping_rate = number_format($shipping_rate, 2);
$customer_total = $customer_total + $shipping_rate;
}
}
//Sending mail
$pdf = new FPDF('P', 'pt', array(500, 233));
$pdf->AddPage();
$pdf->SetFont('arial', '', 16);
$pdf = new FPDF();
$pdf->AddPage();
// email stuff (change data below)
//$to = $customer_details[$j]['email'];
$to = '*****@*****.**';
$from = "*****@*****.**";
$subject = 'Invoice';
$message = "<p>Please see the attachment.</p>";
$img_path = Mage::getBaseUrl() . 'skin/frontend/default/zoffio/images/logo_print.gif';
$store_address = Mage::getStoreConfig('general/store_information/address');
$end_date = $model->enddate($customer_details[$j]['email'], $customer_details[$j]['credit_cycle'] - 1);
// Getting the customer payment date
$pay_date = new DateTime($end_date[pay_date]);
$customer_pay_date = $pay_date->format('d-m-Y');
//Formatting the payment date.
$start_date = new DateTime($end_date[start_date]);
$customer_start_date = $start_date->format('d-m-Y');
$end_date = new DateTime($end_date[end_date]);
$customer_end_date = $end_date->format('d-m-Y');
$customer_info = $model->customercycledetails($customer_details[$j]['email']);
$split_store_address = explode(',', $store_address);
$linestyle = array('width' => 0.1, 'cap' => 'butt', 'join' => 'miter', 'dash' => '', 'phase' => 10, 'color' => array(255, 0, 0));
$pdf->Image($img_path, 10, 10, 31, 20, 'PNG', '', '', false, 300, '', false, false, 0, false, false, false);
$pdf->SetY(20);
$pdf->SetFont('Times', 'B', 11);
$pdf->Cell(180, 0, 'Corporate Credit Invoice', 2, 2, 'C');
$pdf->Line(80, 22, 120, 22, $linestyle);
$pdf->SetX(100);
$pdf->SetFont('Times', 'B', 11);
$pdf->Cell(0, 0, $split_store_address[0], 0, 0, 'R');
$pdf->SetFont('Times', '', 9);
$pdf->Cell(0, 10, $split_store_address[1] . ',' . $split_store_address[2], 0, 0, 'R');
$pdf->Cell(0, 20, $split_store_address[3] . ',' . $split_store_address[4] . ',' . $split_store_address[5], 0, 0, 'R');
$pdf->SetFont('Times', '', 8);
$pdf->Line(5, 40, 200, 40, $linestyle);
$pdf->SetX(20);
$pdf->SetY(30);
$pdf->Cell(0, 30, 'Customer: ' . $customer_info[fname] . '.' . $customer_info[lname], 0, 0, 'L');
$pdf->SetX(75);
$pdf->Cell(0, 30, 'Company: ' . $customer_info[company_name], 0, 0, 'L');
$pdf->SetX(150);
$pdf->Cell(0, 30, 'Email: ' . $customer_details[$j]['email'], 0, 0, 'L');
$pdf->Line(5, 50, 200, 50, $linestyle);
$pdf->SetX(20);
$pdf->SetY(40);
$pdf->Cell(0, 30, 'Credit Period: ' . $customer_start_date . ' to ' . $customer_end_date, 0, 0, 'L');
$pdf->SetX(75);
$pdf->Cell(0, 30, 'Amount Need to Pay: ' . $customer_total, 0, 0, 'L');
$pdf->SetX(150);
$pdf->Cell(0, 30, 'Payment Due Date: ' . $customer_pay_date, 0, 0, 'L');
$pdf->Line(5, 60, 200, 60, $linestyle);
$i = 10;
$pdf->SetFont('Times', '', 6);
$pdf->SetX(20);
$pdf->SetY(70);
$pdf->SetX(20);
$pdf->Cell(20, 10, 'Order Number', 1, 0, 'C');
$pdf->Cell(20, 10, 'Order Amount', 1, 0, 'C');
$pdf->Cell(25, 10, 'Order Date', 1, 0, 'C');
$pdf->Cell(30, 10, 'Order Delivery Date', 1, 1, 'C');
$pdf->SetX(20);
$pdf->SetY(80);
$pdf->SetX(20);
foreach ($order_details as $details) {
$order = Mage::getModel('sales/order')->load($details['order_id'], 'increment_id');
if ($order->getStatus() == 'Complete' || $order->getStatus() == 'complete') {
echo $details['order_id'];
echo '<br/>';
$i = $i + 1;
$pdf->SetX(20);
$pdf->Cell(20, $i, $details['order_id'], 1, 0, 'C');
$pdf->Cell(20, $i, $details['order_value'], 1, 0, 'C');
$pdf->Cell(25, $i, $details['order_date'], 1, 0, 'C');
$pdf->Cell(30, $i, $details['order_complete_date'], 1, 1, 'C');
//$pdf->SetX(20);
}
}
$pdf->SetFont('Times', 'B', 8);
$pdf->SetX(80);
//$pdf->Cell(100,20,'Total : Rs.'.$details['utlized_amt'].'/-', 0,0,'R');
// a random hash will be necessary to send mixed content
$separator = md5(time());
// carriage return type (we use a PHP end of line constant)
$eol = PHP_EOL;
// attachment name
$filename = "Invoice.pdf";
// encode data (puts attachment in proper format)
$pdfdoc = $pdf->Output("", "S");
$attachment = chunk_split(base64_encode($pdfdoc));
// main header
$headers = "From: " . $from . $eol;
$headers .= "MIME-Version: 1.0" . $eol;
$headers .= "Content-Type: multipart/mixed; boundary=\"" . $separator . "\"";
// no more headers after this, we start the body! //
$body = "--" . $separator . $eol;
$body .= "Content-Transfer-Encoding: 7bit" . $eol . $eol;
//$body .= "This is a MIME encoded message.".$eol;
// message
$body .= "--" . $separator . $eol;
$body .= "Content-Type: text/html; charset=\"iso-8859-1\"" . $eol;
$body .= "Content-Transfer-Encoding: 8bit" . $eol . $eol;
$body .= $message . $eol;
// attachment
$body .= "--" . $separator . $eol;
$body .= "Content-Type: application/octet-stream; name=\"" . $filename . "\"" . $eol;
$body .= "Content-Transfer-Encoding: base64" . $eol;
$body .= "Content-Disposition: attachment" . $eol . $eol;
$body .= $attachment . $eol;
$body .= "--" . $separator . "--";
// send message
if ($customer_total != 0) {
mail($to, $subject, $body, $headers);
}
$customer_total = 0;
}
//$model->updatecycle($todate,$expiry_date,$new_cycle,$customer_details[$j]['email'],$payment_date);
}
//}
}
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
Mage::app('default');
$model = Mage::getModel('rcredit/rcredit');
$order = new Mage_Sales_Model_Order();
$order_details = $model->orderids();
//print_r($order_details);
$i = 0;
$check = array();
foreach ($order_details as $details) {
$shipping = $soapClient->GetSaleOrder(array('SaleOrder' => array('Code' => $details[order_id])));
//echo '<pre>';
//print_r($shipping);
foreach ($shipping->SaleOrder->ShippingPackages as $v) {
$order->loadByIncrementId($details[order_id]);
$payment = $order->getPayment()->getMethodInstance()->getCode();
$customer_status = $model->customerstatus($order->getCustomerEmail());
if ($v->StatusCode == 'DELIVERED') {
$day = explode('T', $v->DeliveredOn);
if ($day[0] >= $customer_status['credit_start_date']) {
//echo 'In Second Cycle'.$details[cycle].'-->'.$details[order_id].'-->'.$details[order_value].'-->'.$order->getCustomerEmail().'-->'.$customer_status[credit_cycle].'-->'.$customer_status[utlized_amt];
//echo '<br/>';
$model->updateordercycle($details[order_id], $customer_status[credit_cycle]);
}
$model->updateorderdate($details[order_id], $day[0]);
}
