public function payTransaction($transaction_id, $data) { $sql = "insert into Payments values ('" . $transaction_id . "', '" . $data['PaymentDate'] . "','" . $data['PaymentAmount'] . "', '" . strip_tags($data['PaymentDetails']) . "'," . $this->db->quote($data['receiptFile']) . ")"; $this->oldSkul($sql, false); $sqlPaymentAmount = ''; if ($data['PaymentMethod'] == 5) { if (is_numeric($data['PaymentAmount'])) { $sqlPaymentAmount = " , StoreCreditsUsed = StoreCreditsUsed + " . str_replace(',', '', $data['PaymentAmount']); $this->oldSkul("update SiteUsers set StoreCredits = StoreCredits - " . str_replace(',', '', $data['PaymentAmount']) . " where ID = " . $data['UserID'], false); $AdvanceDepositUsageHistoryData = array(); $AdvanceDepositUsageHistoryData['EventDate'] = date('Y-m-d H:i:s'); $AdvanceDepositUsageHistoryData['Event'] = 'Payment Transaction'; $AdvanceDepositUsageHistoryData['Amount'] = str_replace(',', '', $data['PaymentAmount']) * -1; $AdvanceDepositUsageHistoryData['TransactionID'] = $transaction_id; $AdvanceDepositUsageHistoryData['SiteUserID'] = $data['UserID']; $this->insertData('AdvanceDepositUsageHistory', $AdvanceDepositUsageHistoryData); } } $sql = "update Transactions set PaymentMethod = '" . $data['PaymentMethod'] . "' {$sqlPaymentAmount} where ID = '" . $transaction_id . "'"; #$sql = "update Transactions set PaymentMethod = '".$data['PaymentMethod']."' where ID = '".$transaction_id."'"; $this->oldSkul($sql, false); $data = array('TransactionID' => $transaction_id, 'Status' => 2, 'PaymentStatus' => 1); // 2 = in process, 1 = marked as payment sent $this->updateStatus($data); $PaymentMethod = ''; switch ($data['PaymentMethod']) { case 1: $PaymentMethod = 'GCASH'; break; case 2: $PaymentMethod = 'BDO'; break; case 3: $PaymentMethod = 'BPI'; break; case 4: $PaymentMethod = 'LBC'; break; case 5: $PaymentMethod = 'AD'; break; default: $PaymentMethod = ''; break; } $mailer = new Model_Mailer(); $subject = strtoupper($transaction_id) . ' has been Marked As Paid'; $message = '<h3>Transaction ' . strtoupper($transaction_id) . ' has been Marked as Paid.</h3>'; $message .= '<table>'; $message .= '<tr>'; $message .= '<td>Payment Method</td>'; $message .= '<td>' . $PaymentMethod . '</td>'; $message .= '</tr>'; $message .= '<tr>'; $message .= '<td>Payment Date</td>'; $message .= '<td>' . $data['PaymentDate'] . '</td>'; $message .= '</tr>'; $message .= '<tr>'; $message .= '<td>Amount</td>'; $message .= '<td>' . $data['PaymentAmount'] . '</td>'; $message .= '</tr>'; $message .= '<tr>'; $message .= '<td>Payment Details</td>'; $message .= '<td>' . $data['PaymentDetails'] . '</td>'; $message .= '</tr>'; $message .= '</table>'; $mailer->Mailer('*****@*****.**', $subject, $message, $headers = null); }