<?php $this->breadcrumbs = array('Invoice Management' => array('index'), $model->invoice_no); $menus = array(array('label' => 'Invoice Management', 'url' => array('index')), array('label' => 'Create Invoice', 'url' => array('create')), array('label' => 'Update Invoice', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete Invoice', 'url' => array('delete'), 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?'))); $this->menu = ControllerActionsName::createMenusRoles($menus, $actions); $model->aModelDetail = $model->rDetail; $cmsFormater = new CmsFormatter(); $InvoiceNumber = $model->invoice_no; $InvoiceDate = $cmsFormater->formatDate($model->created_date); // invoice normal //$BillTo = FiInvoice::$STA_BILL_TO[$model->bill_to]; $CommissionAmount = $model->total_amount_due_gst; $BillTo = $model->user_name; $BillingAddress = $model->user_billing_address; $PostalCode = $model->user_postal_code; $CommissionAmountInText = NumberToText::convertNumber($CommissionAmount); $CommissionAmountFormat = $cmsFormater->formatPrice($CommissionAmount); // //$CreatedDate = $cmsFormater->formatDate($model->created_date); //$ReceiptDatePaid = $cmsFormater->formatDate($model->receipt_date_paid); //$ReceiptInvoice = ProTransactionsInvoice::getReceiptInvoiceNo($model); ?> <div class="sprint l_padding_140"> <a class="button_print" href="javascript:void(0);" title="Print"> <img src="<?php echo Yii::app()->theme->baseUrl; ?> /img/print.png"> </a> </div>
<?php $headText = 'Invoices Management'; $headLink = array('index'); $headLinkBreck = array('index'); $headTitle = "View Receipt {$model->receipt_no}"; $this->breadcrumbs = array($headText => $headLink, $headTitle); $this->menu = array(array('label' => $headText, 'url' => $headLinkBreck)); $cmsFormater = new CmsFormatter(); // for receipt $ReceiptDatePaid = $cmsFormater->formatDate($model->receipt_date_paid); $mInvoice = $model->rInvoice; $aModelInvoiceDetail = $mInvoice->rDetail; $CommissionAmount = $cmsFormater->formatPriceSign($mInvoice->total_amount_due); ?> <div class="sprint l_padding_140"> <a class="button_print" href="javascript:void(0);" title="Print"> <img src="<?php echo Yii::app()->theme->baseUrl; ?> /img/print.png"> </a> </div> <script src="<?php echo Yii::app()->theme->baseUrl; ?> /js/jquery.printElement.min.js"></script> <link rel="stylesheet" href="<?php echo Yii::app()->theme->baseUrl; ?>
public function formatTransOverridingAmount($model) { if (!$model->admin_approved) { return ProTransactions::$WAIT_APPROVE_TEXT; } $cmsFormater = new CmsFormatter(); return $cmsFormater->formatPrice($model->overriding_amount); } public function formatListingCompanyStatus($model) { if (isset(Listing::$STATUS_COMPANY_[$model->company_listing_status])) {
public static function ListingCompany() { Yii::import('application.extensions.vendors.PHPExcel', true); $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("ANHDUNG")->setLastModifiedBy("ANHDUNG")->setTitle('Company Listing')->setSubject("Office 2007 XLSX Document")->setDescription("Company Listing")->setKeywords("office 2007 openxml php")->setCategory("Company Listing"); $row = 1; $i = 1; $dataAll = $_SESSION['data-excel']->data; $company_listing_type = $_SESSION['data_excel_company_listing_type']; $HeadTitle = 'Immediate Listing'; if ($company_listing_type == Listing::COMPANY_FOLLOW_UP) { $HeadTitle = 'Follow Up Listing'; } $cmsFormatter = new CmsFormatter(); // 1.sheet 1 $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Times New Roman'); $objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->setTitle('Company ' . $HeadTitle); // $objPHPExcel->getActiveSheet()->setCellValue("A$row", 'Client List'); // $objPHPExcel->getActiveSheet()->getStyle("A$row")->getFont() // ->setBold(true); // $objPHPExcel->getActiveSheet()->mergeCells("A$row:H$row"); // $row++; $index = 1; $beginBorder = $row; $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'SN'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Property Name Or Address'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Postal Code'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'District – location '); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Property Type'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Unit #'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'House/Blk No'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Building Name'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Listing Type'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Owner Name'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Contact No'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Email'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Dnc Expiry Date'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Floor Area'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", '# Of Bedrooms'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Storey'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Utility Room'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Price (S$)'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Built Up'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Tenure'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Availability'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Created By'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Last Modified Date'); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", 'Remark'); $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++; foreach ($dataAll as $data) { $index = 1; $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $i); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->property_name_or_address); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->postal_code); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatListingDistrict($data)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", Listing::getViewDetailPropertyType($data)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->unit_from . " - {$data->unit_to}"); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->house_blk_no); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->building_name); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatPropertyType($data->listing_type)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_owner_name); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->contact_name_no); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_email); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatDate($data->dnc_expiry_date)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatPrice($data->floor_area)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatPrice($data->of_bedroom)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_storey); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_utility_room); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatPrice($data->price)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_built_up); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->tenure); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->company_availability); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatNameForAll($data->rUser)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $cmsFormatter->formatDate($data->last_update_time)); $objPHPExcel->getActiveSheet()->setCellValue(MyFormat::columnName($index++) . "{$row}", $data->remark); $row++; $i++; } // end body $objPHPExcel->getActiveSheet()->getStyle("B{$beginBorder}:" . MyFormat::columnName($index) . $row)->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20); $row--; $index--; $objPHPExcel->getActiveSheet()->getStyle("A{$beginBorder}:A" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle("H{$beginBorder}:H" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle("J{$beginBorder}:J" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $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="' . 'Company ' . $HeadTitle . '.' . 'xlsx' . '"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); Yii::app()->end(); }
?> </div> <div class="mycol1"> <?php echo Yii::t('translation', $form->labelEx($model, 'transactions_no')); ?> <?php echo $model->transactions_no; ?> </div> <div class="mycol1"> <?php echo Yii::t('translation', $form->labelEx($model, 'created_date')); ?> <?php echo $cmsFormater->formatDate($model->created_date); ?> </div> </div> <?php } ?> <div class="row"> <?php echo Yii::t('translation', $form->labelEx($model, 'bill_to')); ?> <?php echo $form->dropDownList($model, 'bill_to', FiInvoice::getListOptionBillTo(), array("class" => "w-350", 'empty' => 'Select')); ?> <?php
<?php echo $form->label($model, 'id_type', array('class' => 'lb')); ?> <div class="group top_5"> <?php echo Users::$aIdType[$model->id_type]; ?> </div> </div> <div class="in-row clearfix"> <?php echo $form->label($model, 'pass_expiry_date', array('class' => 'lb')); ?> <div class="group top_5"> <?php echo $cmsFormater->formatDate($model->pass_expiry_date); ?> </div> </div> <div class="in-row clearfix"> <?php echo $form->label($model, 'scanned_employment_pass', array('class' => 'lb')); ?> <div class="group top_5"> <?php echo $model->scanned_employment_pass; ?> </div> </div> <div class="in-row clearfix"> <?php
$headText = 'Transactions Invoice'; $headLink = array('fiInvoice/transactionInvoice'); $headLinkBreck = array('fiInvoice/transactionInvoice'); $headTitle = "View Invoice"; } $this->breadcrumbs = array($headText => $headLink, $headTitle); //$menus = array( // array('label'=>$headText, 'url'=>array($headLink)), //); $this->menu = array(array('label' => $headText, 'url' => $headLinkBreck)); $cmsFormater = new CmsFormatter(); $mBillTo = $mTransactions->rBillTo; $mTransPropertyDetail = $mTransactions->rPropertyDetail; $text1 = "Being co-broke commission due to us for services rendered in connection with the lease of the above-mentioned property."; $InvoiceNumber = $model->invoice_number; $InvoiceDate = $cmsFormater->formatDate($mTransactions->created_date); //$Property = Listing::getViewDetailPropertyType($mTransactions->rListing); // 9 //$PropertyName = $mTransactions->rPropertyDetail->rPropertyType?$mTransactions->rPropertyDetail->rPropertyType->name:''; // hình như ko dùng cái $PropertyName bên trên $PropertyName = ProTransactionsInvoice::getPropertyName($model) . " " . $mTransPropertyDetail->unit_no; $LanlordName = ProTransactions::getInvoiceLanlordName($mTransactions); $TenantName = ProTransactions::getInvoiceTenantName($mTransactions); $TransactionNo = $mTransactions->transactions_no; // 8 $ClientType = ProTransactions::$aClientSaleDetail[$mTransactions->client_type_id]; // 10 /** Oct 02, 2014 xu ly cho bill to solicitor is selected - hien tai moi lam invoice normal template 1 */ $VendorsName = ''; $SolicitorName = ""; $SolicitorAddress = '';