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');
