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();
}
