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