public function actionSave() { if ($_POST) { $trans = Yii::app()->db->beginTransaction(); try { $id_member = $_POST['id_member']; $new_id_member = $_POST['new_id_member']; $member = Member::model()->findByPk($id_member); $member->id_member = $new_id_member; $member->type_card = 'Diamond'; if ($member->validate() && $member->update()) { $upgrade = new UpgradeMembership(); $upgrade->old_idmember = $_POST['id_member']; $upgrade->new_idmember = $_POST['new_id_member']; $upgrade->username = Yii::app()->user->getId(); $upgrade->upgrade_date = date('Y-m-d'); $upgrade->old_point = $member->point; if ($upgrade->validate() && $upgrade->save()) { $trans->commit(); echo CJSON::encode(array('message' => 'Membership has been upgrade successfully to Diamond')); } else { throw new Exception('Rollback on Upgrade Table'); } } else { throw new Exception('Rollback on Member Table'); } } catch (CDbException $e) { $trans->rollback(); } } }
public function actionIndex() { $model = new Receipt('Search'); if (!empty($_GET['ajax']) and $_GET['ajax'] === 'receipt-grid') { // cari apakah id_member yang dikirim ada ditabel member $member = Member::model()->findByPk($_GET['id_member']); // Jika tidak ada di table member coba cari di table upgrade membership if ($member !== null) { // cari old_idmember ditabel upgrade_membership apakah ada, jika // ada ambil old_idmember tersebut dan ambil data transactionnya ditabel receipt berdasarkan old_idmember $upgrade_membership = new UpgradeMembership(); $model->id_member = $member->id_member; $upgrade_idmember = $upgrade_membership->GetOldIdMember($member->id_member); if ($upgrade_idmember !== null) { $model->old_idmember = $upgrade_idmember->old_idmember; } } } $this->render('index', array('model' => $model)); }
$periode = "{$awal} to {$akhir}"; $pdf->SetFont('Arial', '', 14); $pdf->Text(290 / 2 - $pdf->GetStringWidth($periode) / 2, 54, $periode); //$pdf->Line(10, 10, 210-10, 10); $pdf->SetXY(10, 60); $pdf->SetFont('Helvetica', '', 12); $content = UpgradeMembership::model()->with(array('member', 'user'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2))); if ($content == null) { $pdf->SetFont('Helvetica', '', 48); $pdf->Text(290 / 2 - $pdf->GetStringWidth("No Data Found") / 2, 84, "No Data Found"); $pdf->Output(); Yii::app()->end(); } $total = count($content); $total_upgradeed_member_male = count(UpgradeMembership::model()->with(array('member'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2 AND member.gender = :gender', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2, ':gender' => '0')))); $total_upgradeed_member_female = count(UpgradeMembership::model()->with(array('member'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2 AND member.gender = :gender', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2, ':gender' => '1')))); $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(); $cols = array(); $cols[] = array('text' => 'Total Upgraded Member', 'width' => '140', 'height' => '15', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '14', 'font_style' => 'B', 'fillcolor' => '145,145,145', 'textcolor' => '255,255,255', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => 'LTBR'); $cols[] = array('text' => $total, 'width' => '135', 'height' => '15', 'align' => 'R', 'font_name' => 'Arial', 'font_size' => '14', 'font_style' => '', 'fillcolor' => $back_color, 'textcolor' => $text_color, 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => 'LTBR'); $columns[] = $cols; $pdf->WriteTable($columns); $pdf->SetXY(10, 95); // Total Upgrade Member by gender $columns = array();
$pdf->x1 = ''; foreach ($content as $redeem) { $columns_head = array(); $cols_head = array(); $cols_head[] = array('text' => 'ID Member : ', 'width' => '50', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => 'B', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $cols_head[] = array('text' => $redeem->id_member, 'width' => '55', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => '', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $cols_head[] = array('text' => 'Redeem Date : ', 'width' => '45', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => 'B', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $cols_head[] = array('text' => date('d F Y', strtotime($redeem->redeem_date)), 'width' => '55', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => '', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $columns_head[] = $cols_head; $pdf->WriteTable($columns_head); $columns_head2 = array(); $cols_head2 = array(); $cols_head2[] = array('text' => 'Member Name : ', 'width' => '50', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => 'B', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); if (empty($redeem->member->fullname)) { // current id_member adalah bertipe regular $up = new UpgradeMembership(); $get_new_id_member = $up->getNewIdMember($redeem->id_member); if (!is_null($get_new_id_member)) { $cols_head2[] = array('text' => $get_new_id_member->member->fullname, 'width' => '55', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => '', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); } } else { $cols_head2[] = array('text' => $redeem->member->fullname, 'width' => '55', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => '', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); } $cols_head2[] = array('text' => 'CS : ', 'width' => '45', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => 'B', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $cols_head2[] = array('text' => $redeem->user->name, 'width' => '55', 'height' => '7', 'align' => 'L', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => '', 'fillcolor' => '255,255,255', 'textcolor' => '0,0,0', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => ''); $columns_head2[] = $cols_head2; $pdf->WriteTable($columns_head2); $pdf->Ln(); $columns = array(); $cols = array(); $cols[] = array('text' => 'No', 'width' => '12', 'height' => '7', 'align' => 'C', 'font_name' => 'Arial', 'font_size' => '12', 'font_style' => 'B', 'fillcolor' => '145,145,145', 'textcolor' => '255,255,255', 'drawcolor' => '110,110,110', 'linewidth' => '0.4', 'linearea' => 'LTBR');