/**
* Updates a particular model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id the ID of the model to be updated
*/
public function actionUpdate($id)
{
try {
$model = ProAirconService::model()->findByPk($id);
if (is_null($model)) {
throw new Exception('id not valid');
}
$old_upload_service_documents = $model->upload_service_documents;
$model->scenario = 'updateTelemarketer';
$model->schedule_date = MyFormat::dateConverYmdToDmy($model->schedule_date, "d/m/Y");
$this->layout = 'ajax';
if (isset($_POST['ProAirconService'])) {
$model->attributes = $_POST['ProAirconService'];
$model->upload_service_documents = CUploadedFile::getInstance($model, 'upload_service_documents');
if (is_null($model->upload_service_documents)) {
$model->upload_service_documents = $old_upload_service_documents;
} else {
$model->validate();
if (!$model->hasErrors()) {
$mOld = ProAirconService::model()->findByPk($model->id);
ProAirconService::removeFile($mOld, 'upload_service_documents', ProAirconService::$folderUpload);
$model->upload_service_documents = ProAirconService::save_photo($model);
}
}
if ($model->save()) {
die('<script type="text/javascript">parent.$.fn.colorbox.close(); parent.$.fn.yiiGridView.update("pro-defect-grid");</script>');
}
}
$this->render('update', array('model' => $model, 'actions' => $this->listActionsCanAccess));
} catch (Exception $e) {
Yii::log("Exception " . print_r($e, true), 'error');
throw new CHttpException("Exception " . print_r($e, true));
}
}
/**
* @Author: ANH DUNG Feb 10, 2015
* @Todo: format ListedDate of listing
* Re-listed on OR Listed on
* Re-listed on Feb 08, 2015
* @Param: $model model listing
*/
public static function FormatListedDate($model)
{
$date = $model->date_listed;
$text = "Listed on ";
if ($model->re_listed_count) {
$date = $model->re_listed_date;
$text = "Re-listed on ";
}
$res = $text . MyFormat::dateConverYmdToDmy($date, MyFormat::$sDateIndexListing);
return $res;
}
<h3><a href="<?php
echo Yii::app()->createAbsoluteUrl('site/listingdetail', array('slug' => $data->slug));
?>
">
<?php
echo $data->property_name_or_address;
?>
</a>
</h3>
<p><?php
echo $data->rPropertyType ? $data->rPropertyType->name : '';
?>
</p>
<!--<p>376 Thomson Road</p>-->
<p class="type">Listed on <?php
echo MyFormat::dateConverYmdToDmy($data->date_listed, MyFormat::$sDateIndexListing);
?>
</p>
<p class="price"><?php
echo $cmsFormater->formatPrice($data->price);
?>
</p>
<p><?php
echo $cmsFormater->formatPrice($data->office_bkank_valuation);
?>
</p>
<p><?php
echo $data->floor_area;
?>
sqft</p>
<div class="ico-group clearfix">
public function actionUpdate($id)
{
try {
$model = $this->loadModel($id);
$model->scenario = 'update_tenant';
$old_image = $model->avatar;
$oldFile = $model->upload_employment_pass_passport;
$oldScannedPassport = $model->scanned_passport;
$oldPass = $model->password_hash;
$model->pass_expiry_date = MyFormat::dateConverYmdToDmy($model->pass_expiry_date, 'd/m/Y');
$model->expiration_date = MyFormat::dateConverYmdToDmy($model->expiration_date, 'd/m/Y');
if (isset($_POST['Users'])) {
$model->attributes = $_POST['Users'];
$model->upload_employment_pass_passport = CUploadedFile::getInstance($model, 'upload_employment_pass_passport');
$model->scanned_passport = CUploadedFile::getInstance($model, 'scanned_passport');
$model->avatar = CUploadedFile::getInstance($model, 'avatar');
$model->validate();
if (!$model->hasErrors()) {
$model->role_id = ROLE_TENANT;
if (!empty($model->password_hash)) {
$model->temp_password = $model->password_hash;
$model->password_hash = md5($model->password_hash);
} else {
$model->password_hash = $oldPass;
}
if (!is_null($model->upload_employment_pass_passport)) {
Users::deleteOldFile($model, 'upload_employment_pass_passport', Users::$folderUpload);
$model->upload_employment_pass_passport = Users::save_upload_employment_pass_passport($model);
} else {
$model->upload_employment_pass_passport = $oldFile;
}
if (!is_null($model->scanned_passport)) {
Users::deleteOldFile($model, 'scanned_passport', Users::$folderUpload);
$model->scanned_passport = Users::save_scanned_passport($model);
} else {
$model->scanned_passport = $oldScannedPassport;
}
if (!is_null($model->avatar)) {
Users::deleteImage($model);
$model->avatar = Users::saveImage($model, 'avatar');
Users::resizeImage($model, 'avatar', Users::$aSize);
} else {
$model->avatar = $old_image;
}
if (isset($_POST['delete_current_image']) && $_POST['delete_current_image']) {
Users::deleteImage($model, 'avatar', Users::$aSize);
$model->avatar = '';
}
if (isset($_POST['delete_current_pass_passport']) && $_POST['delete_current_pass_passport']) {
Users::deleteOldFile($model, 'upload_employment_pass_passport', Users::$folderUpload);
$model->upload_employment_pass_passport = '';
}
if (isset($_POST['delete_scanned_passport']) && $_POST['delete_scanned_passport']) {
Users::deleteOldFile($model, 'scanned_passport', Users::$folderUpload);
$model->scanned_passport = '';
}
$model->update();
$this->redirect(array('view', 'id' => $model->id));
}
}
$model->upload_employment_pass_passport = $oldFile;
$model->scanned_passport = $oldScannedPassport;
$this->render('update', array('model' => $model, 'actions' => $this->listActionsCanAccess));
} catch (Exception $e) {
Yii::log("Exception " . print_r($e, true), 'error');
throw new CHttpException("Exception " . print_r($e, true));
}
}
} else {
$model->scanned_employment_pass = $oldscanned_employment_pass;
}
if (!is_null($model->scanned_passport)) {
ProTransactionsVendorPurchaserDetail::deleteOldFile($model, 'scanned_passport');
$model->scanned_passport = ProTransactionsVendorPurchaserDetail::saveSomeFile($model, 'scanned_passport');
} else {
$model->scanned_passport = $oldscanned_passport;
}
$model->pass_expiry_date = MyFormat::dateConverDmyToYmd($model->pass_expiry_date);
$link = Yii::app()->createAbsoluteUrl('member/landlord/tenancies_detail', array('transaction_id' => $mTransaction->id));
if ($item->type == ProTransactions::CLIENT_TYPE_TENANT) {
$link = Yii::app()->createAbsoluteUrl('member/tenant/tenancies_detail', array('transaction_id' => $mTransaction->id));
}
$href = "<a href='{$link}' target='_blank'>Tenancy link</a>";
$FullName = $item->name;
$aBody = array('{FULL_NAME}' => $FullName, '{PROPERTY_NAME}' => $PropertyName, '{EXPIRING_DATE}' => $ExpiringDate, '{TENANCY_LINK}' => $href);
$aSubject = array('{PROPERTY_NAME}' => $PropertyName);
CmsEmail::sendmail(MAIL_TENANCY_EXPIRING, $aSubject, $aBody, $item->email);
}
}
public static function ReportTrans()
{
Yii::import('application.extensions.vendors.PHPExcel', true);
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("ANHDUNG")->setLastModifiedBy("ANHDUNG")->setTitle('Report Financial')->setSubject("Office 2007 XLSX Document")->setDescription("Report Transaction")->setKeywords("office 2007 openxml php")->setCategory("Report Transaction");
$row = 1;
$i = 1;
// $dataAll = $_SESSION['data-excel']->data;
$HeadTitle = 'Report Transaction';
$TOTAL_AMOUNT_INVOICE = isset($_SESSION['REPORT_TRANSACTION']['TOTAL_AMOUNT_INVOICE']) ? $_SESSION['REPORT_TRANSACTION']['TOTAL_AMOUNT_INVOICE'] : array();
$TOTAL_AMOUNT_VOUCHER = isset($_SESSION['REPORT_TRANSACTION']['TOTAL_AMOUNT_VOUCHER']) ? $_SESSION['REPORT_TRANSACTION']['TOTAL_AMOUNT_VOUCHER'] : array();
$COUNT_TRANS = isset($_SESSION['REPORT_TRANSACTION']['COUNT_TRANS']) ? $_SESSION['REPORT_TRANSACTION']['COUNT_TRANS'] : array();
$LOOP_VAR = isset($_SESSION['REPORT_TRANSACTION']['LOOP_VAR']) ? $_SESSION['REPORT_TRANSACTION']['LOOP_VAR'] : array();
$total_trans = 0;
$total_revenue = 0;
$cmsFormater = new CmsFormatter();
$REPORT_TYPE = $_SESSION['REPORT_TYPE'];
// 1.sheet 1
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Times New Roman');
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->setTitle($HeadTitle);
$objPHPExcel->getActiveSheet()->setCellValue("A{$row}", FiInvoice::$STA_REPORT_TYPE[$REPORT_TYPE]);
$objPHPExcel->getActiveSheet()->getStyle("A{$row}")->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->mergeCells("A{$row}:c{$row}");
$row++;
$index = 1;
$beginBorder = $row;
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Date');
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Number of Transactions');
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Revenue');
$index--;
$objPHPExcel->getActiveSheet()->getStyle("A{$row}:" . MyFormat::columnName($index) . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle("A{$row}:" . MyFormat::columnName($index) . $row)->getFont()->setBold(true);
$row++;
if ($REPORT_TYPE == FiInvoice::REPORT_DAILY) {
foreach ($LOOP_VAR as $value) {
$amount_invoice = isset($TOTAL_AMOUNT_INVOICE[$value]) ? $TOTAL_AMOUNT_INVOICE[$value] : 0;
$amount_voucher = isset($TOTAL_AMOUNT_VOUCHER[$value]) ? $TOTAL_AMOUNT_VOUCHER[$value] : 0;
$revenue = $amount_invoice - $amount_voucher;
$total_trans += isset($COUNT_TRANS[$value]) ? $COUNT_TRANS[$value] : 0;
$total_revenue += $revenue;
if ($revenue != 0 || $amount_invoice != 0 || $amount_voucher != 0) {
$index = 1;
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", MyFormat::dateConverYmdToDmy($value, "d/m/Y"));
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $COUNT_TRANS[$value]);
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", MyFormat::formatPrice($revenue));
$row++;
$i++;
}
}
// end foreach($LOOP_VAR
} elseif ($REPORT_TYPE == FiInvoice::REPORT_MONTHLY) {
foreach ($LOOP_VAR as $year => $arrMonth) {
foreach ($arrMonth as $month => $temp) {
$amount_invoice = isset($TOTAL_AMOUNT_INVOICE[$year][$month]) ? $TOTAL_AMOUNT_INVOICE[$year][$month] : 0;
$amount_voucher = isset($TOTAL_AMOUNT_VOUCHER[$year][$month]) ? $TOTAL_AMOUNT_VOUCHER[$year][$month] : 0;
$revenue = $amount_invoice - $amount_voucher;
$total_trans += isset($COUNT_TRANS[$year][$month]) ? $COUNT_TRANS[$year][$month] : 0;
$total_revenue += $revenue;
if ($revenue != 0 || $amount_invoice != 0 || $amount_voucher != 0) {
$index = 1;
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", "{$month}/{$year}");
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $COUNT_TRANS[$year][$month]);
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", MyFormat::formatPrice($revenue));
$row++;
$i++;
}
}
// foreach($arrMonth as $month=>$temp):
}
// end foreach($LOOP_VAR
} elseif ($REPORT_TYPE == FiInvoice::REPORT_YEARLY) {
foreach ($LOOP_VAR as $year => $tmp) {
$amount_invoice = isset($TOTAL_AMOUNT_INVOICE[$year]) ? $TOTAL_AMOUNT_INVOICE[$year] : 0;
$amount_voucher = isset($TOTAL_AMOUNT_VOUCHER[$year]) ? $TOTAL_AMOUNT_VOUCHER[$year] : 0;
$revenue = $amount_invoice - $amount_voucher;
$total_trans += isset($COUNT_TRANS[$year]) ? $COUNT_TRANS[$year] : 0;
$total_revenue += $revenue;
if ($revenue != 0 || $amount_invoice != 0 || $amount_voucher != 0) {
$index = 1;
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $year);
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $COUNT_TRANS[$year]);
$objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", MyFormat::formatPrice($revenue));
$row++;
$i++;
}
}
// end foreach($LOOP_VAR
}
// $objPHPExcel->getActiveSheet()->getStyle("B$beginBorder:".MyFormat::columnName($index).($row))
// ->getAlignment()->setWrapText(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$row--;
$index--;
$objPHPExcel->getActiveSheet()->getStyle("A{$beginBorder}:A" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle("B{$beginBorder}:B" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle("C{$beginBorder}:C" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle("A{$beginBorder}" . ':' . MyFormat::columnName($index) . $row)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle("A{$beginBorder}:" . MyFormat::columnName($index) . $row)->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//save file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
for ($level = ob_get_level(); $level > 0; --$level) {
@ob_end_clean();
}
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
header('Content-type: ' . 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="' . 'Report Transaction.' . 'xlsx' . '"');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
Yii::app()->end();
}
/**
* @Author: ANH DUNG Apr 01, 2014
* @Todo: convert some field db date to user interface date
* @Param: $model model transaction
*/
public static function convertToUserDate($model)
{
if (is_null($model)) {
return;
}
$model->otp_contract_date = MyFormat::dateConverYmdToDmy($model->otp_contract_date, 'd/m/Y');
$model->commencement_date = MyFormat::dateConverYmdToDmy($model->commencement_date, 'd/m/Y');
$model->expiring_date = MyFormat::dateConverYmdToDmy($model->expiring_date, 'd/m/Y');
$model->appointment_date_hdb_only = MyFormat::dateConverYmdToDmy($model->appointment_date_hdb_only, 'd/m/Y');
$model->tenancy_agreement_date = MyFormat::dateConverYmdToDmy($model->tenancy_agreement_date, 'd/m/Y');
}
{
$this->pageTitle = "Engage Us - " . Yii::app()->params['title'];
$this->layout = 'application.views.layouts.layout_user';
$this->render('Engageus');
}
/**
* @Author: ANH DUNG Nov 28, 2014
* @Todo: On the Salesperson’s list of tenancy page,
* there is a new button called “ Record existing tenancy ” for
* creating a tenancy that does not require creating a transaction before it:
* @param: $add_property: 1: ADD_EXISTING, 2: ADD_UNLISTED
*/
public function actionRecord_existing_tenancy($add_property)
{
/** 1. get thông tin user login
* 2. createnew tạo mới 1 transaction với status tạm =0, sau đó get thông tin liên quan
* 3. get thông tin của listing đưa vào model của $mTransactionsPropertyDetail
* 4. get thông tin của 3: Landlord, 4: Tenant Purchaser’s Details
*/
MyFormat::validateUserAccess(ROLE_AGENT);
$this->pageTitle = "Record existing tenancy - " . Yii::app()->params['title'];
try {
$mUser = Users::model()->findByPk(Yii::app()->user->id);
$type = ProTransactions::FOR_RENT;
$listing_id = 0;
if (isset($_GET['listing_id'])) {
$listing_id = $_GET['listing_id'];
}
// handle create new
if (!isset($_GET['id'])) {
$mTransactions = ProTransactions::CreateNewRecordTransaction($type, $listing_id);
?>
<?php
$amount_invoice = isset($TOTAL_AMOUNT_INVOICE[$value]) ? $TOTAL_AMOUNT_INVOICE[$value] : 0;
$amount_voucher = isset($TOTAL_AMOUNT_VOUCHER[$value]) ? $TOTAL_AMOUNT_VOUCHER[$value] : 0;
// $revenue = ($amount_invoice-$amount_voucher>0) ? $amount_invoice-$amount_voucher : 0;
$revenue = $amount_invoice - $amount_voucher;
$total_trans += isset($COUNT_TRANS[$value]) ? $COUNT_TRANS[$value] : 0;
$total_revenue += $revenue;
?>
<?php
if ($revenue != 0 || $amount_invoice != 0 || $amount_voucher != 0) {
?>
<tr class="materials_row ">
<td class="item_c">
<?php
echo MyFormat::dateConverYmdToDmy($value, "d/m/Y");
?>
</td>
<td class="item_r">
<?php
echo $COUNT_TRANS[$value];
?>
</td>
<td class=" item_r">
<?php
echo MyFormat::formatPrice($revenue);
?>
</td>
</tr>
<?php
}
