function isOrderPaid($orderId)
{
$tblOrder = new Kutu_Core_Orm_Table_Order();
$rowOrder = $tblOrder->find($orderId)->current();
if (!empty($rowOrder)) {
if ($rowOrder->orderStatus == 3) {
return true;
} else {
return false;
}
} else {
return false;
}
}
public function sendReceiptToUser($orderId, $paymentMethod = '', $statusText = '')
{
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/mail.ini', 'general');
$siteOwner = "Hukumonline";
$siteName = $config->mail->sender->support->name;
$contactEmail = $config->mail->sender->support->email;
$tblOrder = new Kutu_Core_Orm_Table_Order();
$rowOrder = $tblOrder->find($orderId)->current();
$userId = $rowOrder->userId;
//first check if orderId status is PAID, then send the email.
switch ($rowOrder->orderStatus) {
case 1:
die('ORDER STATUS IS NOT YET PAID. CAN NOT SEND RECEIPT!.');
break;
case 3:
$orderStatus = "PAID";
break;
case 5:
$orderStatus = "POSTPAID PENDING";
break;
case 6:
$orderStatus = "PAYMENT REJECTED";
break;
case 7:
$orderStatus = "PAYMENT ERROR";
break;
default:
$orderStatus = "PAYMENT ERROR";
break;
}
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($userId)->current();
$userEmail = $rowUser->email;
$userFullname = $rowUser->fullName;
switch (strtolower($paymentMethod)) {
case 'paypal':
case 'manual':
case 'bank':
case 'postpaid':
default:
$message = "\t\t\t\t\t\r\nDear {$userFullname},\r\n\r\nThis is a payment receipt for Invoice # {$rowOrder->invoiceNumber}\r\n\r\nTotal Amount: USD {$rowOrder->orderTotal}\r\nTransaction #:\r\nTotal Paid: USD {$rowOrder->orderTotal}\r\nStatus: {$orderStatus}\r\nYour payment method is: {$paymentMethod}\r\n\r\nYou may review your invoice history at any time by logging in to your account " . KUTU_ROOT_URL . "/store/payment/list\r\n\r\nNote: This email will serve as an official receipt for this payment.\r\n\r\nSalam,\r\n\r\nHukumonline\r\n\r\n==============================";
}
$this->send($config->mail->sender->support->email, $config->mail->sender->support->name, $userEmail, '', "Hukumonline Receipt Invoice# " . $rowOrder->invoiceNumber, $message);
}
public function instructionAction()
{
$orderId = $this->_request->getParam('orderId');
$tblOrder = new Kutu_Core_Orm_Table_Order();
$row = $tblOrder->find($orderId)->current();
if (empty($row)) {
die('NO ORDER DATA AVAILABLE');
}
//var_dump($rowset);
$this->view->row = $row;
$_SESSION['jCart'] = null;
}
public function deleteAction()
{
$model = new Kutu_Core_Orm_Table_Order();
$row = $model->find(5);
$row->delete();
}
protected function updateInvoiceMethod($payMethod, $status, $notify, $note)
{
$tblOrder = new Kutu_Core_Orm_Table_Order();
$orderId = $this->_orderIdNumber;
$rows = $tblOrder->find($orderId)->current();
$row = array();
$ivnum = $rows->invoiceNumber;
if (empty($ivnum)) {
if ($status == 3 || $status == 5 || !empty($_SESSION['_method']) && $_SESSION['_method'] == 'paypal') {
$ivnum = $this->getInvoiceNumber();
}
//$row=array ('invoiceNumber' => $ivnum);
}
//if( )$ivnum = $this->getInvoiceNumber();
$row = array('invoiceNumber' => $ivnum, 'orderStatus' => $status);
$_SESSION['_method'] = '';
/*$this->_paymentMethod=$payMethod;//set payment method on table
$row->paymentMethod=$this->_paymentMethod;*/
$tblOrder->update($row, 'orderId = ' . $orderId);
$tblHistory = new Kutu_Core_Orm_Table_OrderHistory();
$rowHistory = $tblHistory->fetchNew();
$rowHistory->orderId = $orderId;
$rowHistory->orderStatusId = $status;
$rowHistory->dateCreated = date('YmdHis');
$rowHistory->userNotified = $notify;
$rowHistory->note = $note;
$rowHistory->save();
return $ivnum;
}
private function saveOrder($cart, $method)
{
//[TODO] this value should be put into table KutuPaymentSetting
$defaultCurrency = 'USD';
$tblPaymentSetting = new Kutu_Core_Orm_Table_PaymentSetting();
$usdIdrEx = $tblPaymentSetting->fetchRow(" settingKey= 'USDIDR'");
$currencyValue = $usdIdrEx->settingValue;
$rowTaxRate = $tblPaymentSetting->fetchRow("settingKey='taxRate'");
$taxRate = $rowTaxRate->settingValue;
//die($currencyValue);
$auth = Zend_Auth::getInstance();
$userId = $auth->getIdentity()->guid;
$tblOrder = new Kutu_Core_Orm_Table_Order();
$row = $tblOrder->fetchNew();
$row->userId = $userId;
//get value from post var (store/checkout.phtml)
if ($this->getRequest()->getPost()) {
$value = $this->getRequest()->getPost();
// get posted value
$row->taxNumber = $value['taxNumber'];
$row->taxCompany = $value['taxCompany'];
$row->taxAddress = $value['taxAddress'];
$row->taxCity = $value['taxCity'];
$row->taxZip = $value['taxZip'];
$row->taxProvince = $value['taxProvince'];
$row->taxCountryId = $value['taxCountry'];
$row->paymentMethod = $method;
}
$row->datePurchased = date('YmdHis');
$row->orderStatus = 1;
//pending
$row->currency = $defaultCurrency;
$row->currencyValue = $currencyValue;
$row->orderTotal = $cart['grandTotal'];
$row->orderTax = $cart['taxAmount'];
$row->ipAddress = $this->getRealIpAddress();
/*echo '<pre>';
//print_r($row);
echo '</pre>';*/
$orderId = $row->save();
//$orderId = $tblOrder->getLastInsertId();
$rowJustInserted = $tblOrder->find($orderId)->current();
$rowJustInserted->invoiceNumber = date('Ymd') . '.' . $orderId;
$rowJustInserted->save();
$this->view->invoiceNumber = $rowJustInserted->invoiceNumber;
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
for ($iCart = 0; $iCart < count($cart['items']); $iCart++) {
$rowDetail = $tblOrderDetail->fetchNew();
$itemId = $cart['items'][$iCart]['itemId'];
$rowDetail->orderId = $orderId;
$rowDetail->itemId = $itemId;
$rowDetail->documentName = $cart['items'][$iCart]['item_name'];
$rowDetail->price = $cart['items'][$iCart]['itemPrice'];
$itemPrice = $rowDetail->price;
@($rowDetail->tax = ($cart['grandTotal'] - $cart['subTotal']) / $cart['subTotal'] * 100);
$rowDetail->qty = $cart['items'][$iCart]['qty'];
$rowDetail->finalPrice = $itemPrice + $itemPrice * $taxRate / 100;
$rowDetail->save();
}
//[TODO] MUST ALSO INSERT/UPDATE KutuUserFinance
return $orderId;
}
public function sendPaypalCompleteNotificationToUser($orderId)
{
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/mail.ini', 'general');
$sOrderId = '';
$tblUser = new Kutu_Core_Orm_Table_User();
$tblOrder = new Kutu_Core_Orm_Table_Order();
$rowOrder = $tblOrder->find($orderId)->current();
$userId = $rowOrder->userId;
$rowUser = $tblUser->find($userId)->current();
$userEmail = $rowUser->email;
$userFullname = $rowUser->firstname . ' ' . $rowUser->lastname;
$message = "\t\t\t\t\t\nYour Paypal payment for item(s) with Order ID {$sOrderId} has been completely proceed.\n\nnow you can continue to <a href=\"" . KUTU_ROOT_URL . "/site/store_payment/document\">download the document(s)</a> or just continue <a href=\"" . KUTU_ROOT_URL . "/dms\">browsing our database</a>..\n\n==============================";
$sFile = "sendPaypalCompleteNotificationToUser.log";
$content = "SENDER : " . $config->mail->sender->support->email . "\n";
$content .= "NAME : " . $config->mail->sender->support->name . "\n";
$content .= "RECIPIENT : " . $userEmail;
$content .= "MESSAGE : [LGS ONLINE] Receipt Invoice# " . $rowOrder->invoiceNumber . $message . "\n";
$this->logThisMail($sFile, $content);
$this->send($config->mail->sender->support->email, $config->mail->sender->support->name, $userEmail, '', "[LGS ONLINE] Paypal Payment Complete ", $message);
}
