PHP CmsFormatter::formatDate Examples

Example #1

File: view.php Project: jasonhai/onehome

<?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>

Example #2

File: ViewReceipt.php Project: jasonhai/onehome

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

Example #3

File: CmsFormatter.php Project: jasonhai/onehome

 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])) {

Example #4

File: ExportExcel.php Project: jasonhai/onehome

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

Example #5

File: _form.php Project: jasonhai/onehome

    ?>
            </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 

Example #6

File: TenantFormView.php Project: jasonhai/onehome

            <?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 

Example #7

File: print_invoice.php Project: jasonhai/onehome

    $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 = '';