<?php require '..' . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'bootstrap.config.php'; $Product_Name = "HeadPhones"; $Product_Info = "This is a Fake product."; $Product_price = 2000; /* * Enter the quantity of product available to give to thee user */ $quantity = 300; Redeem::addProduct($Product_Name, $Product_Info, $Product_price, $quantity);
<?php
require_once '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'includes' . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'bootstrap.config.php';
if ($session->is_logged_in()) {
$user = $_SESSION['user_id'];
$user = new User($user);
$sh_id = (int) $session->sh_id;
} else {
$session->logout();
header('Location: ../redeem.php');
}
if (isset($_GET['product']) && !empty($_GET['product'])) {
$product_id = (int) $_GET['product'];
if (!empty($product_id)) {
$product = new Redeem($product_id);
if ($product->found) {
if ($product->redeem($sh_id)) {
$session->message("Product {$product->name} Redeemed Successfully, A request of this Product is raised with us. We will contact you shortly");
header('Location: ../redeem.php');
} else {
$session->message("Product {$product->name} was not Redeemed. Please Check whether you have enough Money to redeem this product.");
header('Location: ../redeem.php');
}
} else {
header('Location: ../redeem.php');
}
} else {
header('Location: ../redeem.php');
}
} else {
header('Location: ../redeem.php');
public function actionSave()
{
if ($_POST) {
$trans = Yii::app()->db->beginTransaction();
try {
$redeem = new Redeem();
$autonumber = $redeem->autonumber();
$table_length = $_POST['table_length'];
$point = 0;
$member_name = '';
$voucher_list = array();
if ($table_length < 1) {
throw new Exception('Rollback Table Length');
}
if (empty($_POST['id_member'])) {
throw new Exception('Rollback ID Member');
}
$redeem->id_redeem = $autonumber;
$redeem->redeem_point = $_POST['redeem_point'];
$redeem->username = Yii::app()->user->getId();
$redeem->redeem_date = date('Y-m-d');
$redeem->id_member = $_POST['id_member'];
if (!$redeem->validate() or !$redeem->save()) {
throw new Exception('Rollback Redeem');
}
for ($i = 0; $i < $table_length; $i++) {
$detail_redeem = new DetailRedeem();
$detail_redeem->id_redeem = $autonumber;
$detail_redeem->id_voucher = $_POST['id_voucher_list'][$i];
$detail_redeem->voucher_number = $_POST['number_voucher_list'][$i];
// mendapatkan nama voucher dan jumlah voucher yang diredeem untuk dicetak distruk
$voucher = Voucher::model()->findByPk($_POST['id_voucher_list'][$i]);
$voucher_list[] = array($voucher->voucher_name, $_POST['number_voucher_list'][$i]);
if ($detail_redeem->validate() and $detail_redeem->save()) {
$member = Member::model()->findByPk($_POST['id_member']);
$member_name = $member->first_name . ' ' . $member->family_name;
$member->point -= $_POST['total_redeem_list'][$i];
if (!$member->update()) {
throw new Exception('Rollback Update Point Member');
}
$point = $member->point;
} else {
throw new Exception('Rollback Detail Redeem');
}
}
$trans->commit();
$get_name = User::model()->findByPk(Yii::app()->user->getId());
$dataRedeem = $this->renderPartial('_receipt', array('id_member' => $_POST['id_member'], 'member_name' => $member_name, 'point' => $point + $redeem->redeem_point, 'redeem_point' => $redeem->redeem_point, 'remaining' => $point, 'vouchers' => $voucher_list, 'name' => $get_name->name), true, false);
echo CJSON::encode(array('message' => 'Transaction redeem point has been saved Successfully!', 'receipt' => $dataRedeem));
} catch (CDbException $e) {
$trans->rollback();
}
}
}
<?php
require '..' . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'bootstrap.config.php';
$product = new redeem(1);
$product->redeem(1);
$products = Redeem::getProducts();
foreach ($products as $product) {
print_r($product);
}
$pdf->Text(230 / 2 - $pdf->GetStringWidth('Lippo Mall Kemang') / 2, 26, 'Lippo Mall Kemang');
$pdf->SetFont('Times', '', 12);
$pdf->Text(230 / 2 - $pdf->GetStringWidth('Jl. Pangeran Antasari 36 Jakarta Selatan - 12150') / 2, 33, 'Jl. Pangeran Antasari 36 Jakarta Selatan - 12150');
//$pdf->setDrawColor(105,102,102);
$pdf->Line(10, 36, 210 - 5, 36);
$pdf->SetFont('Arial', '', 22);
$pdf->Text(230 / 2 - $pdf->GetStringWidth('Report Redeem Point') / 2, 45, 'Report Redeem Point');
$awal = date('d F Y', strtotime($tgl1));
$akhir = date('d F Y', strtotime($tgl2));
$periode = "{$awal} to {$akhir}";
$pdf->SetFont('Arial', '', 14);
$pdf->Text(230 / 2 - $pdf->GetStringWidth($periode) / 2, 54, $periode);
//$pdf->Line(10, 10, 210-10, 10);
$pdf->SetXY(10, 60);
$pdf->SetFont('Helvetica', '', 12);
$content = Redeem::model()->with(array('member', 'user', 'detail_redeem'))->findAll(array('condition' => 'redeem_date BETWEEN :date1 AND :date2', 'order' => 't.id_member DESC', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2)));
if (is_null($content)) {
$pdf->SetFont('Helvetica', '', 48);
$pdf->Text(290 / 2 - $pdf->GetStringWidth("No Data Found") / 2, 84, "No Data Found");
$pdf->Output();
Yii::app()->end();
}
$sql = "SELECT voucher.voucher_name,SUM(detail_redeem.voucher_number) as jumlah FROM\r\n\t redeem JOIN detail_redeem ON redeem.id_redeem = detail_redeem.id_redeem\r\n\t JOIN voucher ON voucher.id_voucher = detail_redeem.id_voucher WHERE redeem_date BETWEEN '" . $tgl1 . "' AND '" . $tgl2 . "'\r\n\t GROUP BY voucher.id_voucher ORDER BY jumlah DESC ";
$results = Yii::app()->db->createCommand($sql)->queryAll();
$pdf->SetFont('Arial', '', 16);
$text_color = '0,0,0';
$back_color = '255,255,255';
$pdf->Text(10, 70, 'Summary');
$pdf->Line(10, 72, 100, 72);
$pdf->SetXY(10, 75);
$columns = array();
