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); }
public function resetAction() { $this->_helper->layout()->setLayout('page'); $email = $this->_getParam('UserName'); if ($_POST) { $reset = $this->_getParam('ResetCode'); if ($reset && $email) { $generic = new Model_Generic(); $check = $generic->oldSkul("select * from SiteUsers where SiteEmail = '" . $email . "' and ResetCode= '" . $reset . "' "); if ($check) { $new_password = Model_Transaction::randomizer(); $generic->oldSkul("update SiteUsers set SitePassword = md5('" . $new_password . "'), ResetCode = '' where SiteEmail='" . $email . "' ", false); $this->view->new_password = $new_password; } } $this->view->msg = 'A confirmation link has been sent to your email address before you can reset your password.'; $reset_code = base64_encode(Model_Transaction::randomizer()); $mailer = new Model_Mailer(); $mailer->sendResetPasswordCode($email, $reset_code); } if ($this->_getParam('msg')) { $this->view->msg = 'Enter your reset code below'; } //echo Model_Transaction::randomizer(); }