<div id="data_entry_left_right_wrapper">
<div id="data_entry_left">
<?php if ($num_pages > 0) {?>
<?php $form=$this->beginWidget('CActiveForm', array (
'id'=>'je_data_entry_form',
'htmlOptions'=>array(
'class'=>'data_entry_form',
),
)); ?>
<fieldset>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $je->JE_Date)) {
$je->JE_Date = Helper::convertDateSimple($je->JE_Date);
}
?>
<label for="Journals_JE_Date"><span class="red">*</span> Journal Date</label>
<?php echo $form->textField($je,'JE_Date'); ?>
<?php echo $form->error($je,'JE_Date'); ?>
<?php
if (!isset($je['_errors']["JE_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<?php
if ($je->JE_Number == '0') {
$je->JE_Number = '';
<div id="data_entry_left_right_wrapper">
<div id="data_entry_left">
<?php if ($num_pages > 0) {?>
<?php $form=$this->beginWidget('CActiveForm', array (
'id'=>'payroll_data_entry_form',
'htmlOptions'=>array(
'class'=>'data_entry_form',
),
)); ?>
<fieldset>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $payroll->Week_Ending)) {
$payroll->Week_Ending = Helper::convertDateSimple($payroll->Week_Ending);
}
?>
<label for="Payrolls_Week_Ending"><span class="red">*</span> Week Ending</label>
<?php echo $form->textField($payroll,'Week_Ending'); ?>
<?php echo $form->error($payroll,'Week_Ending'); ?>
<?php
if (!isset($payroll['_errors']["Week_Ending"])) {
echo '<div class="errorMessage grey">Correct format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<label for="Payrolls_Payroll_Type_ID"><span class="red">*</span> Type</label>
<?php echo $form->dropDownList($payroll,'Payroll_Type_ID', array('0' => 'Unknown Payroll Type') + $payrollTypes); ?>
<?php echo $form->error($payroll,'Payroll_Type_ID'); ?>
</div>
<div class="group">
<label for="Pos_Vendor_ID"><span class="red">*</span> Vendor</label>
<?php echo $form->dropDownList($po,'Vendor_ID', array('0' => 'Unknown Vendor') + $vendorsCP); ?>
<?php echo $form->error($po,'Vendor_ID'); ?>
</div>
<div class="group">
<label for="Pos_PO_Account_Number">Account Num</label>
<?php echo $form->textField($po,'PO_Account_Number'); ?>
<?php echo $form->error($po,'PO_Account_Number'); ?>
</div>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $po->PO_Date)) {
$po->PO_Date = Helper::convertDateSimple($po->PO_Date);
}
?>
<label for="Pos_PO_Date"><span class="red">*</span> Date</label>
<?php echo $form->textField($po,'PO_Date'); ?>
<?php echo $form->error($po,'PO_Date'); ?>
<?php
if (!isset($ap['_errors']["PO_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<label for="Pos_PO_Subtotal"><span class="red">*</span> Subtotal</label>
<?php echo $form->textField($po,'PO_Subtotal', array('class' => 'dollar_fields base_fields')); ?>
<?php echo $form->error($po,'PO_Subtotal'); ?>
}
?>
<label for="Aps_Invoice_Date"><span class="red">*</span> Inv. Date</label>
<?php echo $form->textField($ap,'Invoice_Date'); ?>
<?php echo $form->error($ap,'Invoice_Date'); ?>
<?php
if (!isset($ap['_errors']["Invoice_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $ap->Invoice_Due_Date)) {
$ap->Invoice_Due_Date = Helper::convertDateSimple($ap->Invoice_Due_Date);
}
?>
<label for="Aps_Invoice_Due_Date">Inv. Due Date</label>
<?php echo $form->textField($ap,'Invoice_Due_Date',array('data-term'=>$due_date_term)); ?>
<?php echo $form->error($ap,'Invoice_Due_Date'); ?>
<?php
if (!isset($ap['_errors']["Invoice_Due_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<label for="Aps_Invoice_Amount"><span class="red">*</span> Inv. Amount</label>
<?php echo $form->textField($ap,'Invoice_Amount'); ?>
<?php echo $form->error($ap,'Invoice_Amount'); ?>
<div style="margin-left: 230px;position: relative; top:-10px;"> <a href="#" class="add_new_vendor"> Add new vendor </a> </div>
<input id="fileupload_add_block" type="file" name="files[]" style="display: none;">
<script src="<?php echo Yii::app()->request->baseUrl.'/js/jupload/vendor/jquery.ui.widget.js'?>" > </script>
<script src="<?php echo Yii::app()->request->baseUrl.'/js/jupload/jquery.fileupload.js'?>" > </script>
</div>
<div class="right po_creating_top_right">
<fieldset>
<div class="group">
<label>Number:</label>
<span class="limited_width"><?php echo $po->PO_Number; ?></span>
</div>
<div class="group">
<label>Date:</label>
<span class="limited_width"><?php echo Helper::convertDateSimple($po->PO_Date); ?></span>
</div>
<div class="group">
<label>Job Name:</label>
<span class="limited_width"><?php echo isset($poFormatting->PO_Format_Job_Name) ? CHtml::encode($poFormatting->PO_Format_Job_Name) : ''; ?></span>
</div>
<div class="group">
<?php echo $form->label($po,'PO_Account_Number'); ?>
<?php echo $form->textField($po,'PO_Account_Number'); ?>
<?php echo $form->error($po,'PO_Account_Number'); ?>
</div>
<div class="group">
<?php echo $form->label($po,'Payment_Type'); ?>
<?php echo $form->dropDownList($po,'Payment_Type', array('0' => 'Unknown Payment Type') + $this->paymentTypes); ?>
<?php echo $form->error($po,'Payment_Type'); ?>
</div>
'readonly'=> $payment->Void,
'class'=>'dollar_fields'
)); ?>
<?php echo $form->error($payment,'Payment_Amount'); ?>
<?php echo '<div class="warningMessage"></div>';?>
</div>
<div class="group">
<label for="Void">Void payment</label>
<?php echo $form->checkBox($payment,'Void'); ?>
<?php echo $form->error($payment,'Void'); ?>
</div>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $payment->Payment_Check_Date)) {
$payment->Payment_Check_Date = Helper::convertDateSimple($payment->Payment_Check_Date);
}
?>
<label for="Payments_Payment_Check_Date"><span class="red">*</span> Pmt. Date</label>
<?php echo $form->textField($payment,'Payment_Check_Date'); ?>
<?php echo $form->error($payment,'Payment_Check_Date'); ?>
<?php
if (!isset($payment['_errors']["Payment_Check_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<div class="group">
<label for="Acct_Number">Acct. Number</label>
<?php echo $form->dropDownList($payment,'Account_Num_ID', array('0' => 'Unknown Acct. Number') + $acctNumbs); ?>
<?php echo $form->error($payment,'Account_Num_ID'); ?>
</div>
<div class="group">
<?php
if ($pc->Envelope_Total == '0.00') {
$pc->Envelope_Total = '';
}
?>
<label for="Pcs_Envelope_Total"><span class="red">*</span> Envelope Total</label>
<?php echo $form->textField($pc,'Envelope_Total'); ?>
<?php echo $form->error($pc,'Envelope_Total'); ?>
</div>
<div class="group">
<?php
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $pc->Envelope_Date)) {
$pc->Envelope_Date = Helper::convertDateSimple($pc->Envelope_Date);
}
?>
<label for="Pcs_Envelope_Date"><span class="red">*</span> Envelope Date</label>
<?php echo $form->textField($pc,'Envelope_Date'); ?>
<?php echo $form->error($pc,'Envelope_Date'); ?>
<?php
if (!isset($pc['_errors']["Envelope_Date"])) {
echo '<div class="errorMessage grey">Correct date format: mm/dd/yyyy!</div>';
}
?>
</div>
<?php echo $form->hiddenField($pc,'PC_ID'); ?>
<?php echo $form->hiddenField($pc,'Document_ID'); ?>
<input type="hidden" value="true" name="pc_data_entry_form_values">
<div class="center">
?>
<label for="W9_Signed"><span class="red">*</span> Signed</label>
<?php echo $form->checkBox($w9,'Signed', $htmlOptions); ?>
<?php echo $form->error($w9,'Signed'); ?>
</div>
<div class="group">
<?php
$htmlOptions = array();
if ($w9->Verified == 1 && Yii::app()->user->userType != Users::DB_ADMIN) {
$htmlOptions = array('disabled'=>'disabled');
}
// convert date string to view format
if (preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $w9->Signature_Date)) {
$w9->Signature_Date = Helper::convertDateSimple($w9->Signature_Date);
}
/* echo "Date time explanation<br> ";
echo "<br>Row w9 signature date<br> ".$w9->Signature_Date."<br>";
//$date = date("Y-m-d H:i:s", strtotime($w9->Signature_Date) - date('Z') + Yii::app()->user->userTimezoneOffset);
$date = date("Y-m-d H:i:s", strtotime($w9->Signature_Date));
echo "<br>Full format signature date full format <br> ".$date."<br>";
$date = date('Z');
echo "<br>Timezone offset offset from GMT ".$date."<br>";
$date = Yii::app()->user->userTimezoneOffset;
echo "<br>User Timezone offset app()->user->userTimezoneOffset ".$date."<br>";
$date = date("Y-m-d H:i:s", strtotime($w9->Signature_Date) + date('Z') - Yii::app()->user->userTimezoneOffset);
/**
* Generate batch in Excel format
* @param $exportRows
* @param $batchFormat
* @return string
*/
public static function generateBatchExcel($exportRows, $batchFormat)
{
$phpExcelPath = Yii::getPathOfAlias('ext.phpexcel.Classes');
new Helper();
spl_autoload_unregister(array('YiiBase','autoload')); //needed for correct usage of PHPExcel
include($phpExcelPath . DIRECTORY_SEPARATOR . 'PHPExcel.php');
$phpexcel = new PHPExcel();
if ($batchFormat == self::MAS90) {
$page = $phpexcel->setActiveSheetIndex(0);
$page->setCellValue("A1", "VendorID:");
$page->setCellValue("B1", "InvNum:");
$page->setCellValue("C1", "InvDate");
$page->setCellValue("D1", "InvAmt");
$page->setCellValue("E1", "InvDesc");
$page->setCellValue("F1", "GLCode");
$page->setCellValue("G1", "GLAmt");
$page->setCellValue("H1", "GLDesc");
$page->getStyle('A1')->getFont()->setBold(true);
$page->getStyle('B1')->getFont()->setBold(true);
$page->getStyle('C1')->getFont()->setBold(true);
$page->getStyle('D1')->getFont()->setBold(true);
$page->getStyle('E1')->getFont()->setBold(true);
$page->getStyle('F1')->getFont()->setBold(true);
$page->getStyle('G1')->getFont()->setBold(true);
$page->getStyle('H1')->getFont()->setBold(true);
$page->getColumnDimension('A')->setAutoSize(true);
$page->getColumnDimension('B')->setAutoSize(true);
$page->getColumnDimension('C')->setAutoSize(true);
$page->getColumnDimension('D')->setAutoSize(true);
$page->getColumnDimension('E')->setAutoSize(true);
$page->getColumnDimension('F')->setAutoSize(true);
$page->getColumnDimension('G')->setAutoSize(true);
$page->getColumnDimension('H')->setAutoSize(true);
$x=2;
foreach($exportRows as $row) {
$page->setCellValue("A".$x,$row['VendorID']);
$page->setCellValue("B".$x,$row['InvNum']);
$page->setCellValue("C".$x,Helper::convertDateSimple($row['InvDate']));
$page->setCellValue("D".$x,$row['InvAmt']);
$page->setCellValue("E".$x,$row['InvDesc']);
$page->setCellValue("F".$x,$row['GLCode']);
$page->setCellValue("G".$x,$row['GLAmt']);
$page->setCellValue("H".$x,$row['GLDesc']);
$x++;
}
}
$objWriter = PHPExcel_IOFactory::createWriter($phpexcel, 'Excel2007');
spl_autoload_register(array('YiiBase','autoload'));
$path=Helper::createDirectory('batches');// creates directory "protected/data/batches" if not exists
$filename = $path.'/'."Batch_Excel". date('Y_m_d_H_i_s') . ".xlsx";
$objWriter->save($filename);
return $filename;
}
