public function paypalsave($status, $dataPaypal = array())
{
$tblOrder = new Kutu_Core_Orm_Table_Order();
$orderId = $dataPaypal['custom'];
//$_SESSION['_orderIdNumber'];//$this->_orderIdNumber;//$data['custom'];
//echo $orderId;
//var_dump($dataPaypal);
//print_r($data['custom']);
$dataPrice = $tblOrder->fetchAll($tblOrder->select()->where('orderId = ' . $orderId));
if ($dataPrice[0]->orderTotal == $dataPaypal['mc_gross']) {
$payStatus = 3;
//paid - completed
} else {
$payStatus = 7;
//payment error
}
$tblPaypal = new Kutu_Core_Orm_Table_Paypal();
$data = $tblPaypal->fetchNew();
$data->orderId = $orderId;
$data->mcGross = $dataPaypal['mc_gross'];
$data->addressStatus = $dataPaypal['address_status'];
$data->payerId = $dataPaypal['payer_id'];
$data->addressStreet = $dataPaypal['address_street'];
$data->paymentDate = date('Y-m-d H:i:s', strtotime($dataPaypal['payment_date']));
$data->paymentStatus = $status;
$data->addressZip = $dataPaypal['address_zip'];
$data->firstName = $dataPaypal['first_name'];
$data->mcFee = $dataPaypal['mc_fee'];
$data->addressName = $dataPaypal['address_name'];
$data->notifyVersion = $dataPaypal['notify_version'];
$data->payerStatus = $dataPaypal['payer_status'];
$data->addressCountry = $dataPaypal['address_country'];
$data->addresCity = $dataPaypal['address_city'];
$data->payerEmail = $dataPaypal['payer_email'];
$data->verifySign = $dataPaypal['verify_sign'];
$data->paymentType = $dataPaypal['payment_type'];
$data->txnId = $dataPaypal['txn_id'];
$data->lastName = $dataPaypal['last_name'];
$data->receiverEmail = $dataPaypal['receiver_email'];
$data->addressState = $dataPaypal['address_state'];
$data->receiverId = $dataPaypal['receiver_id'];
$data->txnType = $dataPaypal['txn_type'];
$data->mcCurrency = $dataPaypal['mc_currency'];
$data->paymentGross = $dataPaypal['payment_gross'];
$data->paymentFee = $dataPaypal['payment_fee'];
$data->numCartItems = isset($dataPaypal['num_cart_items']) ? $dataPaypal['num_cart_items'] : '1';
$data->business = $dataPaypal['business'];
$data->parentTxnId = $dataPaypal['txn_id'];
$data->lastModified = date('Y-m-d');
$data->dateAdded = date('Y-m-d');
try {
$paypalIpnId = $data->save();
} catch (Exception $e) {
$writer = new Zend_Log_Writer_Stream(ROOT_PATH . '/app_log.txt');
$logger = new Zend_Log($writer);
$logger->info($e->getMessage());
}
//echo($tblPaypal->getLastInsertId());
$paypalHistory = new Kutu_Core_Orm_Table_PaypalPaymentHistory();
$row = $paypalHistory->fetchNew();
$row->paypalIpnId = $paypalIpnId;
$row->orderId = $orderId;
$row->txnId = $this->_request->getParam('txn_id');
$row->parentTxnId = $this->_request->getParam('txn_id');
$row->paymentStatus = $this->_request->getParam('payment_status');
$row->dateAdded = date('Y-m-d');
$row->save();
$this->updateInvoiceMethod($orderId, 'paypal', $payStatus, 0, 'paid with paypal method');
}
public function trdetailAction()
{
$orderId = $this->_request->getParam('id');
$tblOrder = new Kutu_Core_Orm_Table_Order();
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
$tblOrderHistory = new Kutu_Core_Orm_Table_OrderHistory();
$tblOrderPaypalHistory = new Kutu_Core_Orm_Table_PaypalPaymentHistory();
$rowset = $tblOrder->fetchAll($tblOrder->select()->where("orderID ='" . $orderId . "'"));
$rowsetDetail = $tblOrderDetail->fetchAll($tblOrderDetail->select()->where("orderId='" . $orderId . "'"));
$rowsetHistory = $tblOrderHistory->getUserHistory($orderId);
$rowsetPaypalHistory = $tblOrderPaypalHistory->fetchAll($tblOrderPaypalHistory->select()->where("orderId='" . $orderId . "'"));
//print_r($rowsetHistory);
$this->view->listOrder = $rowset;
$this->view->listOrderDetail = $rowsetDetail;
$this->view->rowsetHistory = $rowsetHistory;
$this->view->rowsetPaypalHistory = $rowsetPaypalHistory;
}
