function getROE($rlf = NULL, $show_background = TRUE)
{
if (!is_object($rlf) and $this->getId() != '') {
$rlf = TTnew('ROEListFactory');
$rlf->getById($this->getId());
}
if (get_class($rlf) !== 'ROEListFactory') {
return FALSE;
}
$border = 0;
if ($rlf->getRecordCount() > 0) {
$ppsf = TTnew('PayPeriodScheduleListFactory');
$pay_period_type_options = $ppsf->getOptions('type');
$pdf = new TTPDF();
$pdf->setMargins(0, 0, 0, 0);
$pdf->SetAutoPageBreak(FALSE);
foreach ($rlf as $r_obj) {
$pdf->SetFont('freesans', '', 12);
//Get User information
$ulf = TTnew('UserListFactory');
$user_obj = $ulf->getById($r_obj->getUser())->getCurrent();
$ulf = TTnew('UserListFactory');
$created_user_obj = $ulf->getById($r_obj->getCreatedBy())->getCurrent();
//Get company information
$clf = TTnew('CompanyListFactory');
$company_obj = $clf->getById($user_obj->getCompany())->getCurrent();
$pdf->AddPage();
if ($show_background == TRUE) {
//Use this command to convert PDF to images: convert -density 600x600 -quality 00 $file
$pdf->Image(Environment::getImagesPath() . 'roe-template.jpg', 0, 0, 210, 300);
}
//Serial
$pdf->setXY(10, 17);
$pdf->Cell(55, 10, $r_obj->getSerial(), $border, 0, 'L');
//Employer Info
$pdf->setXY(10, 30);
$pdf->Cell(120, 10, $company_obj->getName(), $border, 0, 'L');
$pdf->setXY(10, 40);
$pdf->Cell(120, 10, $company_obj->getAddress1() . ' ' . $company_obj->getAddress2(), $border, 0, 'L');
$pdf->setXY(10, 50);
$pdf->Cell(90, 10, $company_obj->getCity() . ', ' . $company_obj->getProvince(), $border, 0, 'L');
$postal_code_a = substr($company_obj->getPostalCode(), 0, 3);
$postal_code_b = substr($company_obj->getPostalCode(), 3, 6);
$pdf->setXY(110, 50);
$pdf->Cell(10, 10, $postal_code_a, $border, 0, 'L');
$pdf->setXY(122, 50);
$pdf->Cell(10, 10, $postal_code_b, $border, 0, 'L');
//Business Number
$pdf->setXY(138, 28);
$pdf->Cell(120, 10, $company_obj->getBusinessNumber(), $border, 0, 'L');
//Pay Period Type
$pdf->setXY(138, 40);
$pdf->Cell(50, 10, $pay_period_type_options[$r_obj->getPayPeriodType()], $border, 0, 'L');
//SIN
$pdf->setXY(138, 50);
$pdf->Cell(50, 10, $user_obj->getSIN(), $border, 0, 'L');
//Employee info
$pdf->SetFontSize(10);
$pdf->setXY(10, 75);
$pdf->Cell(90, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(10, 80);
$pdf->Cell(90, 5, $user_obj->getAddress1() . ' ' . $user_obj->getAddress2(), $border, 0, 'L');
$pdf->setXY(10, 85);
$pdf->Cell(90, 5, $user_obj->getCity() . ', ' . $user_obj->getProvince() . ' ' . $user_obj->getPostalCode(), $border, 0, 'L');
$pdf->SetFontSize(12);
//Employee Title
if (is_object($user_obj->getTitleObject())) {
$title = $user_obj->getTitleObject()->getName();
} else {
$title = NULL;
}
$pdf->setXY(10, 100);
$pdf->Cell(90, 10, $title, $border, 0, 'L');
//First Day Worked
$pdf->SetFontSize(10);
$first_date = getdate($r_obj->getFirstDate());
$pdf->setXY(175, 64);
$pdf->Cell(8, 10, $first_date['mday'], $border, 0, 'C');
$pdf->setXY(185, 64);
$pdf->Cell(8, 10, $first_date['mon'], $border, 0, 'C');
$pdf->setXY(196, 64);
$pdf->Cell(10, 10, $first_date['year'], $border, 0, 'C');
//Last day paid
$last_date = getdate($r_obj->getLastDate());
$pdf->setXY(175, 75);
$pdf->Cell(8, 10, $last_date['mday'], $border, 0, 'C');
$pdf->setXY(185, 75);
$pdf->Cell(8, 10, $last_date['mon'], $border, 0, 'C');
$pdf->setXY(196, 75);
$pdf->Cell(10, 10, $last_date['year'], $border, 0, 'C');
//Pay Period End Date
$pay_period_end_date = getdate($r_obj->getPayPeriodEndDate());
$pdf->setXY(175, 86);
$pdf->Cell(8, 10, $pay_period_end_date['mday'], $border, 0, 'C');
$pdf->setXY(185, 86);
$pdf->Cell(8, 10, $pay_period_end_date['mon'], $border, 0, 'C');
$pdf->setXY(196, 86);
$pdf->Cell(10, 10, $pay_period_end_date['year'], $border, 0, 'C');
//Insurable Hours
$pdf->SetFontSize(10);
$pdf->setXY(75, 113);
$pdf->Cell(25, 10, Misc::getBeforeDecimal($r_obj->getInsurableHours()), $border, 0, 'R');
$pdf->setXY(101, 113);
$pdf->Cell(10, 10, Misc::getAfterDecimal(Misc::MoneyFormat($r_obj->getInsurableHours(), FALSE)), $border, 0, 'L');
//Enter Code
$pdf->setXY(185, 113);
$pdf->Cell(10, 10, $r_obj->getCode(), $border, 0, 'C');
//Further Information Contact Name
$pdf->setXY(130, 126);
$pdf->Cell(75, 5, $created_user_obj->getFullName(), $border, 0, 'R');
$pdf->setXY(130, 132);
$pdf->Cell(75, 10, $created_user_obj->getWorkPhone(), $border, 0, 'R');
//Insurable Earnings
$pdf->setXY(75, 131);
$pdf->Cell(25, 10, Misc::getBeforeDecimal($r_obj->getInsurableEarnings()), $border, 0, 'R');
$pdf->setXY(101, 131);
$pdf->Cell(10, 10, Misc::getAfterDecimal(Misc::MoneyFormat($r_obj->getInsurableEarnings(), FALSE)), $border, 0, 'L');
//Check to see if a pay period didn't have earnings.
if ($r_obj->isPayPeriodWithNoEarnings() == TRUE) {
$pay_period_earnings = $r_obj->getInsurableEarningsByPayPeriod();
if (is_array($pay_period_earnings)) {
//Add additional entries for testing alignment purposes.
/*
for( $y=0; $y < 14; $y++ ) {
$pay_period_earnings[] = array('amount' => rand(1,10) );
}
*/
$top_left_x = $x = Misc::AdjustXY(30, 0);
$top_left_y = $y = Misc::AdjustXY(157, 0);
$col = 1;
$i = 1;
foreach ($pay_period_earnings as $pay_period_earning) {
Debug::Text('I: ' . $i . ' X: ' . $x . ' Y: ' . $y . ' Col: ' . $col . ' Amount: ' . (double) $pay_period_earning['amount'], __FILE__, __LINE__, __METHOD__, 10);
$pdf->setXY($x, $y);
$pdf->Cell(6, 6, Misc::MoneyFormat((double) $pay_period_earning['amount'], FALSE), $border, 0, 'R');
if ($i > 0 and $i % 3 == 0) {
$x = $top_left_x;
$y += 7;
} else {
$x += 35;
}
$i++;
}
}
}
//Box 17A, Vacation pay in last pay period.
$vacation_pay = $r_obj->getLastPayPeriodVacationEarnings();
if ($vacation_pay > 0) {
$pdf->setXY(132, 155);
$pdf->Cell(10, 10, Misc::getBeforeDecimal(Misc::MoneyFormat($vacation_pay, FALSE)), $border, 0, 'R');
$pdf->Cell(10, 10, Misc::getAfterDecimal(Misc::MoneyFormat($vacation_pay, FALSE)), $border, 0, 'L');
}
//Comments
$pdf->setXY(115, 212);
$pdf->MultiCell(85, 5, $r_obj->getComments(), $border, 'L');
//English
$pdf->setXY(8.5, 256.5);
$pdf->Cell(10, 10, 'X', $border, 0, 'L');
//ROE creator phone number
$pdf->setXY(75, 258);
$pdf->Cell(25, 10, $created_user_obj->getWorkPhone(), $border, 0, 'L');
//ROE create name.
$pdf->SetFontSize(12);
$pdf->setXY(87, 273);
$pdf->Cell(75, 10, $created_user_obj->getFullName(), $border, 0, 'C');
//Create Date
$created_date = getdate($r_obj->getCreatedDate());
$pdf->SetFontSize(10);
$pdf->setXY(175, 273);
$pdf->Cell(8, 10, $created_date['mday'], $border, 0, 'C');
$pdf->setXY(185, 273);
$pdf->Cell(8, 10, $created_date['mon'], $border, 0, 'C');
$pdf->setXY(195, 273);
$pdf->Cell(10, 10, $created_date['year'], $border, 0, 'C');
}
$output = $pdf->Output('', 'S');
}
if (isset($output)) {
return $output;
}
return FALSE;
}
if (isset($ein[0]) and isset($ein[1])) {
$pdf->setXY(15, 236);
$pdf->Cell(13, 6, $ein[0], $border, 0, 'R');
$pdf->setXY(29, 236);
$pdf->Cell(40, 6, $ein[1], $border, 0, 'L');
}
$pdf->setXY(82, 244);
$pdf->Cell(75, 6, $current_company->getName(), $border, 0, 'L');
$pdf->setXY(82, 253);
$pdf->Cell(45, 6, $current_company->getAddress1() . ' ' . $current_company->getAddress2(), $border, 0, 'L');
$pdf->setXY(82, 261);
$pdf->Cell(45, 6, $current_company->getCity() . ', ' . $current_company->getProvince() . ' ' . $current_company->getPostalCode(), $border, 0, 'L');
$pdf->setXY(157, 234);
$pdf->Cell(35, 6, Misc::getBeforeDecimal(Misc::MoneyFormat($lines_arr['total']['p1_6'], FALSE)), $border, 0, 'R');
$pdf->setXY(193, 234);
$pdf->Cell(6, 6, Misc::getAfterDecimal(Misc::MoneyFormat($lines_arr['total']['p1_6'], FALSE)), $border, 0, 'L');
}
$output = $pdf->Output('', 'S');
if (Debug::getVerbosity() == 11) {
Debug::Display();
} else {
Misc::FileDownloadHeader('f940ez.pdf', 'application/pdf', strlen($output));
echo $output;
}
exit;
}
}
break;
case 'delete':
case 'save':
Debug::Text('Action: ' . $action, __FILE__, __LINE__, __METHOD__, 10);
public static function formatNumber($number, $auto_format_decimals = FALSE, $max_decimals = 4)
{
if ($auto_format_decimals == TRUE) {
$number = Misc::removeTrailingZeros($number);
$decimal_places = strlen(Misc::getAfterDecimal($number, FALSE));
if ($decimal_places > $max_decimals) {
$decimal_places = $max_decimals;
}
$custom_format = self::getLocaleHandler()->numberFormats[I18Nv2_NUMBER_FLOAT];
$custom_format[0] = $decimal_places;
self::getLocaleHandler()->numberFormats['long_float'] = $custom_format;
return self::getLocaleHandler()->formatNumber($number, 'long_float');
} else {
return self::getLocaleHandler()->formatNumber($number);
}
}
function filterAmountCents($value)
{
if (isset($this->amount)) {
$value = Misc::getAfterDecimal($this->amount) . '/100';
}
return $value;
}
function isLengthAfterDecimal($label, $value, $msg = NULL, $min = 1, $max = 255)
{
$len = strlen(Misc::getAfterDecimal($value, FALSE));
//Debug::text('Value: '. $value .' Length: '. $len .' Min: '. $min .' Max: '. $max, __FILE__, __LINE__, __METHOD__, $this->verbosity);
if ($len < $min or $len > $max) {
$this->Error($label, $msg, $value);
return FALSE;
}
return TRUE;
}
function drawCell($data, $field_layout_data, $additional_x_offset = 0, $additional_y_offset = 0)
{
if (isset($data) and $data !== NULL or $this->getShowBorder() == TRUE) {
Debug::Text(' Data: ' . $data, __FILE__, __LINE__, __METHOD__, 10);
if (isset($field_layout_data['x']) and $field_layout_data['y']) {
$this->getPDFObject()->setXY(Misc::AdjustXY($field_layout_data['x'], $this->getXOffset() + $additional_x_offset), Misc::AdjustXY($field_layout_data['y'], $this->getYOffset() + $additional_y_offset));
}
if (!isset($field_layout_data['ln'])) {
$field_layout_data['ln'] = 0;
}
if (isset($field_layout_data['fontsize'])) {
if (!isset($field_layout_data['fontstyle'])) {
$field_layout_data['fontstyle'] = $this->getDefaultFontStyle();
}
$this->getPDFObject()->SetFont($this->getDefaultFont(), $field_layout_data['fontstyle'], $field_layout_data['fontsize']);
}
if (isset($field_layout_data['w']) and isset($field_layout_data['h']) and isset($field_layout_data['align'])) {
if (isset($field_layout_data['multicell'])) {
$this->getPDFObject()->MultiCell($field_layout_data['w'], $field_layout_data['h'], $data, $this->getShowBorder(), $field_layout_data['align']);
} else {
if (isset($field_layout_data['split_decimal'])) {
$this->getPDFObject()->Cell($field_layout_data['w'] - $this->getDecimalFieldSize(), $field_layout_data['h'], Misc::getBeforeDecimal($data), $this->getShowBorder(), 0, $field_layout_data['align']);
$this->getPDFObject()->Cell($this->getDecimalFieldSize(), $field_layout_data['h'], Misc::getAfterDecimal($data), $this->getShowBorder(), $field_layout_data['ln'], $field_layout_data['align']);
} else {
$this->getPDFObject()->Cell($field_layout_data['w'], $field_layout_data['h'], $data, $this->getShowBorder(), $field_layout_data['ln'], $field_layout_data['align']);
}
}
}
if (isset($field_layout_data['fontsize'])) {
$this->SetFont();
//Return to default font
}
}
return TRUE;
}
function exportPayStub($pslf = NULL, $export_type = NULL)
{
global $current_company;
if (!is_object($pslf) and $this->getId() != '') {
$pslf = new PayStubListFactory();
$pslf->getById($this->getId());
}
if (get_class($pslf) !== 'PayStubListFactory') {
return FALSE;
}
if ($export_type == '') {
return FALSE;
}
if ($pslf->getRecordCount() > 0) {
Debug::Text('aExporting...', __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($export_type)) {
case 'hsbc':
case '1464':
case '105':
case 'ach':
//Get file creation number
$ugdlf = new UserGenericDataListFactory();
$ugdlf->getByCompanyIdAndScriptAndDefault($current_company->getId(), 'PayStubFactory', TRUE);
if ($ugdlf->getRecordCount() > 0) {
Debug::Text('Found Script Setup Data!', __FILE__, __LINE__, __METHOD__, 10);
$ugd_obj = $ugdlf->getCurrent();
$setup_data = $ugd_obj->getData();
} else {
$ugd_obj = new UserGenericDataFactory();
}
Debug::Text('bExporting...', __FILE__, __LINE__, __METHOD__, 10);
//get User Bank account info
$balf = new BankAccountListFactory();
$balf->getCompanyAccountByCompanyId($current_company->getID());
if ($balf->getRecordCount() > 0) {
$company_bank_obj = $balf->getCurrent();
//Debug::Arr($company_bank_obj,'Company Bank Object', __FILE__, __LINE__, __METHOD__,10);
}
if (isset($setup_data['file_creation_number'])) {
$setup_data['file_creation_number']++;
} else {
//Start at a high number, in attempt to eliminate conflicts.
$setup_data['file_creation_number'] = 500;
}
Debug::Text('bFile Creation Number: ' . $setup_data['file_creation_number'], __FILE__, __LINE__, __METHOD__, 10);
//Increment file creation number in DB
if ($ugd_obj->getId() == '') {
$ugd_obj->setID($ugd_obj->getId());
}
$ugd_obj->setCompany($current_company->getId());
$ugd_obj->setName('PayStubFactory');
$ugd_obj->setScript('PayStubFactory');
$ugd_obj->setData($setup_data);
$ugd_obj->setDefault(TRUE);
if ($ugd_obj->isValid()) {
$ugd_obj->Save();
}
$eft = new EFT();
$eft->setFileFormat($export_type);
$eft->setOriginatorID($current_company->getOriginatorID());
$eft->setFileCreationNumber($setup_data['file_creation_number']);
$eft->setDataCenter($current_company->getDataCenterID());
$eft->setOriginatorShortName($current_company->getShortName());
$psealf = new PayStubEntryAccountListFactory();
foreach ($pslf as $pay_stub_obj) {
Debug::Text('Looping over Pay Stub... ID: ' . $pay_stub_obj->getId(), __FILE__, __LINE__, __METHOD__, 10);
//Get pay stub entries.
$pself = new PayStubEntryListFactory();
$pself->getByPayStubId($pay_stub_obj->getId());
$prev_type = NULL;
$description_subscript_counter = 1;
foreach ($pself as $pay_stub_entry) {
$description_subscript = NULL;
//$pay_stub_entry_name_obj = $psenlf->getById( $pay_stub_entry->getPayStubEntryNameId() ) ->getCurrent();
$pay_stub_entry_name_obj = $psealf->getById($pay_stub_entry->getPayStubEntryNameId())->getCurrent();
if ($prev_type == 40 or $pay_stub_entry_name_obj->getType() != 40) {
$type = $pay_stub_entry_name_obj->getType();
}
//var_dump( $pay_stub_entry->getDescription() );
if ($pay_stub_entry->getDescription() !== NULL and $pay_stub_entry->getDescription() !== FALSE and strlen($pay_stub_entry->getDescription()) > 0) {
$pay_stub_entry_descriptions[] = array('subscript' => $description_subscript_counter, 'description' => $pay_stub_entry->getDescription());
$description_subscript = $description_subscript_counter;
$description_subscript_counter++;
}
if ($type != 40 or $type == 40 and $pay_stub_entry->getAmount() != 0) {
$pay_stub_entries[$type][] = array('id' => $pay_stub_entry->getId(), 'pay_stub_entry_name_id' => $pay_stub_entry->getPayStubEntryNameId(), 'type' => $pay_stub_entry_name_obj->getType(), 'name' => $pay_stub_entry_name_obj->getName(), 'display_name' => $pay_stub_entry_name_obj->getName(), 'rate' => $pay_stub_entry->getRate(), 'units' => $pay_stub_entry->getUnits(), 'ytd_units' => $pay_stub_entry->getYTDUnits(), 'amount' => $pay_stub_entry->getAmount(), 'ytd_amount' => $pay_stub_entry->getYTDAmount(), 'description' => $pay_stub_entry->getDescription(), 'description_subscript' => $description_subscript, 'created_date' => $pay_stub_entry->getCreatedDate(), 'created_by' => $pay_stub_entry->getCreatedBy(), 'updated_date' => $pay_stub_entry->getUpdatedDate(), 'updated_by' => $pay_stub_entry->getUpdatedBy(), 'deleted_date' => $pay_stub_entry->getDeletedDate(), 'deleted_by' => $pay_stub_entry->getDeletedBy());
}
$prev_type = $pay_stub_entry_name_obj->getType();
}
if (isset($pay_stub_entries)) {
$pay_stub = array('id' => $pay_stub_obj->getId(), 'display_id' => str_pad($pay_stub_obj->getId(), 12, 0, STR_PAD_LEFT), 'user_id' => $pay_stub_obj->getUser(), 'pay_period_id' => $pay_stub_obj->getPayPeriod(), 'start_date' => $pay_stub_obj->getStartDate(), 'end_date' => $pay_stub_obj->getEndDate(), 'transaction_date' => $pay_stub_obj->getTransactionDate(), 'status' => $pay_stub_obj->getStatus(), 'entries' => $pay_stub_entries, 'created_date' => $pay_stub_obj->getCreatedDate(), 'created_by' => $pay_stub_obj->getCreatedBy(), 'updated_date' => $pay_stub_obj->getUpdatedDate(), 'updated_by' => $pay_stub_obj->getUpdatedBy(), 'deleted_date' => $pay_stub_obj->getDeletedDate(), 'deleted_by' => $pay_stub_obj->getDeletedBy());
unset($pay_stub_entries);
//Get User information
$ulf = new UserListFactory();
$user_obj = $ulf->getById($pay_stub_obj->getUser())->getCurrent();
//Get company information
$clf = new CompanyListFactory();
$company_obj = $clf->getById($user_obj->getCompany())->getCurrent();
//get User Bank account info
$balf = new BankAccountListFactory();
$user_bank_obj = $balf->getUserAccountByCompanyIdAndUserId($user_obj->getCompany(), $user_obj->getId());
if ($user_bank_obj->getRecordCount() > 0) {
$user_bank_obj = $user_bank_obj->getCurrent();
} else {
continue;
}
$record = new EFT_Record();
$record->setType('C');
$amount = $pay_stub['entries'][40][0]['amount'];
$record->setCPACode(200);
$record->setAmount($amount);
unset($amount);
$record->setDueDate(TTDate::getBeginDayEpoch($pay_stub_obj->getTransactionDate()));
//$record->setDueDate( strtotime("24-Sep-99") );
$record->setInstitution($user_bank_obj->getInstitution());
$record->setTransit($user_bank_obj->getTransit());
$record->setAccount($user_bank_obj->getAccount());
$record->setName($user_obj->getFullName());
$record->setOriginatorShortName($company_obj->getShortName());
$record->setOriginatorLongName(substr($company_obj->getName(), 0, 30));
$record->setOriginatorReferenceNumber('TT' . $pay_stub_obj->getId());
if (isset($company_bank_obj) and is_object($company_bank_obj)) {
$record->setReturnInstitution($company_bank_obj->getInstitution());
$record->setReturnTransit($company_bank_obj->getTransit());
$record->setReturnAccount($company_bank_obj->getAccount());
}
$eft->setRecord($record);
}
}
$eft->compile();
$output = $eft->getCompiledData();
break;
case 'cheque_9085':
case 'cheque_9209p':
case 'cheque_dlt103':
case 'cheque_dlt104':
case 'cheque_cr_standard_form_1':
case 'cheque_cr_standard_form_2':
$border = 0;
$show_background = 0;
$pdf = new TTPDF();
$pdf->setMargins(0, 0, 0, 0);
$pdf->SetAutoPageBreak(FALSE);
$pdf->SetFont('freeserif', '', 10);
$psealf = new PayStubEntryAccountListFactory();
$i = 0;
foreach ($pslf as $pay_stub_obj) {
//Get pay stub entries.
$pself = new PayStubEntryListFactory();
$pself->getByPayStubId($pay_stub_obj->getId());
$pay_stub_entries = NULL;
$prev_type = NULL;
$description_subscript_counter = 1;
foreach ($pself as $pay_stub_entry) {
$description_subscript = NULL;
//$pay_stub_entry_name_obj = $psenlf->getById( $pay_stub_entry->getPayStubEntryNameId() ) ->getCurrent();
$pay_stub_entry_name_obj = $psealf->getById($pay_stub_entry->getPayStubEntryNameId())->getCurrent();
//Use this to put the total for each type at the end of the array.
if ($prev_type == 40 or $pay_stub_entry_name_obj->getType() != 40) {
$type = $pay_stub_entry_name_obj->getType();
}
//Debug::text('Pay Stub Entry Name ID: '. $pay_stub_entry_name_obj->getId() .' Type ID: '. $pay_stub_entry_name_obj->getType() .' Type: '. $type, __FILE__, __LINE__, __METHOD__,10);
//var_dump( $pay_stub_entry->getDescription() );
if ($pay_stub_entry->getDescription() !== NULL and $pay_stub_entry->getDescription() !== FALSE and strlen($pay_stub_entry->getDescription()) > 0) {
$pay_stub_entry_descriptions[] = array('subscript' => $description_subscript_counter, 'description' => $pay_stub_entry->getDescription());
$description_subscript = $description_subscript_counter;
$description_subscript_counter++;
}
$amount_words = str_pad(ucwords(Numbers_Words::toWords(floor($pay_stub_entry->getAmount()), "en_US")) . ' ', 65, "-", STR_PAD_RIGHT);
//echo "Amount: ". floor($pay_stub_entry->getAmount()) ." - Words: ". $amount_words ."<br>\n";
//var_dump($amount_words);
if ($type != 40 or $type == 40 and $pay_stub_entry->getAmount() != 0) {
$pay_stub_entries[$type][] = array('id' => $pay_stub_entry->getId(), 'pay_stub_entry_name_id' => $pay_stub_entry->getPayStubEntryNameId(), 'type' => $pay_stub_entry_name_obj->getType(), 'name' => $pay_stub_entry_name_obj->getName(), 'display_name' => $pay_stub_entry_name_obj->getName(), 'rate' => $pay_stub_entry->getRate(), 'units' => $pay_stub_entry->getUnits(), 'ytd_units' => $pay_stub_entry->getYTDUnits(), 'amount' => $pay_stub_entry->getAmount(), 'amount_padded' => str_pad($pay_stub_entry->getAmount(), 12, '*', STR_PAD_LEFT), 'amount_words' => $amount_words, 'amount_cents' => Misc::getAfterDecimal($pay_stub_entry->getAmount()), 'ytd_amount' => $pay_stub_entry->getYTDAmount(), 'description' => $pay_stub_entry->getDescription(), 'description_subscript' => $description_subscript, 'created_date' => $pay_stub_entry->getCreatedDate(), 'created_by' => $pay_stub_entry->getCreatedBy(), 'updated_date' => $pay_stub_entry->getUpdatedDate(), 'updated_by' => $pay_stub_entry->getUpdatedBy(), 'deleted_date' => $pay_stub_entry->getDeletedDate(), 'deleted_by' => $pay_stub_entry->getDeletedBy());
}
unset($amount_words);
//Only for net pay, make a total YTD of Advance plus Net.
/*
if ( $type == 40 ) {
$pay_stub_entries[$type][0]['ytd_net_plus_advance'] =
}
*/
$prev_type = $pay_stub_entry_name_obj->getType();
}
//Get User information
$ulf = new UserListFactory();
$user_obj = $ulf->getById($pay_stub_obj->getUser())->getCurrent();
//Get company information
$clf = new CompanyListFactory();
$company_obj = $clf->getById($user_obj->getCompany())->getCurrent();
if ($user_obj->getCountry() == 'CA') {
$date_format = 'd/m/Y';
} else {
$date_format = 'm/d/Y';
}
$pay_stub = array('id' => $pay_stub_obj->getId(), 'display_id' => str_pad($pay_stub_obj->getId(), 15, 0, STR_PAD_LEFT), 'user_id' => $pay_stub_obj->getUser(), 'pay_period_id' => $pay_stub_obj->getPayPeriod(), 'start_date' => $pay_stub_obj->getStartDate(), 'end_date' => $pay_stub_obj->getEndDate(), 'transaction_date' => $pay_stub_obj->getTransactionDate(), 'transaction_date_display' => date($date_format, $pay_stub_obj->getTransactionDate()), 'status' => $pay_stub_obj->getStatus(), 'entries' => $pay_stub_entries, 'tainted' => $pay_stub_obj->getTainted(), 'created_date' => $pay_stub_obj->getCreatedDate(), 'created_by' => $pay_stub_obj->getCreatedBy(), 'updated_date' => $pay_stub_obj->getUpdatedDate(), 'updated_by' => $pay_stub_obj->getUpdatedBy(), 'deleted_date' => $pay_stub_obj->getDeletedDate(), 'deleted_by' => $pay_stub_obj->getDeletedBy());
unset($pay_stub_entries);
Debug::text($i . '. Pay Stub Transaction Date: ' . $pay_stub_obj->getTransactionDate(), __FILE__, __LINE__, __METHOD__, 10);
//Get Pay Period information
$pplf = new PayPeriodListFactory();
$pay_period_obj = $pplf->getById($pay_stub_obj->getPayPeriod())->getCurrent();
$pp_start_date = $pay_period_obj->getStartDate();
$pp_end_date = $pay_period_obj->getEndDate();
$pp_transaction_date = $pay_period_obj->getTransactionDate();
//Get pay period numbers
$ppslf = new PayPeriodScheduleListFactory();
$pay_period_schedule_obj = $ppslf->getById($pay_period_obj->getPayPeriodSchedule())->getCurrent();
$pay_period_data = array('start_date' => TTDate::getDate('DATE', $pp_start_date), 'end_date' => TTDate::getDate('DATE', $pp_end_date), 'transaction_date' => TTDate::getDate('DATE', $pp_transaction_date), 'annual_pay_periods' => $pay_period_schedule_obj->getAnnualPayPeriods());
$pdf->AddPage();
switch ($export_type) {
case 'cheque_9085':
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_9085.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(17, $adjust_x), Misc::AdjustXY(42, $adjust_y));
$pdf->Cell(100, 5, $pay_stub['entries'][40][0]['amount_words'], $border, 0, 'L');
$pdf->Cell(15, 5, $pay_stub['entries'][40][0]['amount_cents'] . '/100', $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(130, $adjust_x), Misc::AdjustXY(50, $adjust_y));
$pdf->Cell(38, 5, $pay_stub['transaction_date_display'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(175, $adjust_x), Misc::AdjustXY(50, $adjust_y));
$pdf->Cell(23, 5, ' ' . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(17, $adjust_x), Misc::AdjustXY(55, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(17, $adjust_x), Misc::AdjustXY(60, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getAddress1() . ' ' . $user_obj->getAddress2(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(17, $adjust_x), Misc::AdjustXY(65, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getCity() . ', ' . $user_obj->getProvince() . ' ' . $user_obj->getPostalCode(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 95;
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
//Earnings
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
break;
case 'cheque_9209p':
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_9209P.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(42, $adjust_y));
$pdf->Cell(100, 10, $pay_stub['entries'][40][0]['amount_words'], $border, 0, 'L');
$pdf->Cell(15, 10, $pay_stub['entries'][40][0]['amount_cents'] . '/100', $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(25, $adjust_y));
$pdf->Cell(10, 10, TTi18n::gettext('Date:') . ' ', $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(182, $adjust_x), Misc::AdjustXY(25, $adjust_y));
$pdf->Cell(25, 10, $pay_stub['transaction_date_display'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(42, $adjust_y));
$pdf->Cell(35, 10, $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(57, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(62, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getAddress1() . ' ' . $user_obj->getAddress2(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(67, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getCity() . ', ' . $user_obj->getProvince() . ' ' . $user_obj->getPostalCode(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 100;
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
//Earnings
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
break;
case 'cheque_dlt103':
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_dlt103.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(54, $adjust_y));
$pdf->Cell(100, 10, $pay_stub['entries'][40][0]['amount_words'], $border, 0, 'L');
$pdf->Cell(15, 10, $pay_stub['entries'][40][0]['amount_cents'] . '/100', $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(10, 10, TTi18n::gettext('Date:') . ' ', $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(182, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(25, 10, $pay_stub['transaction_date_display'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(46, $adjust_y));
$pdf->Cell(35, 10, $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(46, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 100;
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
//Earnings
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
break;
case 'cheque_dlt104':
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_dlt104.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(52, $adjust_y));
$pdf->Cell(100, 10, $pay_stub['entries'][40][0]['amount_words'], $border, 0, 'L');
$pdf->Cell(15, 10, $pay_stub['entries'][40][0]['amount_cents'] . '/100', $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(10, 10, TTi18n::gettext('Date:') . ' ', $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(182, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(25, 10, $pay_stub['transaction_date_display'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(172, $adjust_x), Misc::AdjustXY(43, $adjust_y));
$pdf->Cell(35, 10, $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(25, $adjust_x), Misc::AdjustXY(48, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 100;
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
//Earnings
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: ') . $pay_stub_obj->getCurrencyObject()->getSymbol() . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
break;
case 'cheque_cr_standard_form_1':
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_9085.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(20, $adjust_x), Misc::AdjustXY(41, $adjust_y));
$pdf->Cell(100, 5, $pay_stub['entries'][40][0]['amount_words'] . TTi18n::gettext(' and ') . $pay_stub['entries'][40][0]['amount_cents'] . '/100 *****', $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(100, $adjust_x), Misc::AdjustXY(23, $adjust_y));
$pdf->Cell(38, 5, $pay_stub['transaction_date_display'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(136, $adjust_x), Misc::AdjustXY(32, $adjust_y));
$pdf->Cell(24, 5, ' $' . $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(20, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 95;
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, $user_obj->getFullName(), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Identification #:') . ' ' . $pay_stub['display_id'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay Start Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(115 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Pay End Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(160, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(50, 5, TTi18n::gettext('Payment Date:') . ' ' . TTDate::getDate('DATE', $pay_stub['transaction_date']), $border, 0, 'L');
//Earnings
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: $') . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(15, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->Cell(40, 5, TTi18n::gettext('Net Pay: $') . $pay_stub['entries'][40][0]['amount'], $border, 0, 'L');
//Signature lines
$pdf->setXY(Misc::AdjustXY(7, $adjust_x), Misc::AdjustXY(250, $adjust_y));
$border = 0;
$pdf->Cell(40, 5, TTi18n::gettext('Employee Signature:'), $border, 0, 'L');
$pdf->Cell(60, 5, '_____________________________', $border, 0, 'L');
$pdf->Cell(40, 5, TTi18n::gettext('Supervisor Signature:'), $border, 0, 'R');
$pdf->Cell(60, 5, '_____________________________', $border, 0, 'L');
$pdf->Ln();
$pdf->Cell(40, 5, '', $border, 0, 'R');
$pdf->Cell(60, 5, $user_obj->getFullName(), $border, 0, 'C');
$pdf->Ln();
$pdf->Cell(147, 5, '', $border, 0, 'R');
$pdf->Cell(60, 5, '_____________________________', $border, 0, 'C');
$pdf->Ln();
$pdf->Cell(140, 5, '', $border, 0, 'R');
$pdf->Cell(60, 5, TTi18n::gettext('(print name)'), $border, 0, 'C');
break;
case 'cheque_cr_standard_form_2':
$pdf_created_date = time();
$adjust_x = 0;
$adjust_y = -5;
if ($show_background == 1) {
$pdf->Image(Environment::getBasePath() . 'interface/images/nebs_cheque_9085.jpg', 0, 0, 210, 300);
}
$pdf->setXY(Misc::AdjustXY(20, $adjust_x), Misc::AdjustXY(41, $adjust_y));
$pdf->Cell(100, 5, $pay_stub['entries'][40][0]['amount_words'] . TTi18n::gettext(' and ') . $pay_stub['entries'][40][0]['amount_cents'] . '/100 *****', $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(100, $adjust_x), Misc::AdjustXY(23, $adjust_y));
$pdf->Cell(38, 5, $pay_stub['transaction_date_display'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(136, $adjust_x), Misc::AdjustXY(32, $adjust_y));
$pdf->Cell(24, 5, '$ ' . $pay_stub['entries'][40][0]['amount_padded'], $border, 0, 'L');
$pdf->setXY(Misc::AdjustXY(20, $adjust_x), Misc::AdjustXY(33, $adjust_y));
$pdf->Cell(100, 5, $user_obj->getFullName(), $border, 0, 'L');
//Cheque Stub
$stub_2_offset = 110;
$pdf->SetFont('', 'U', 14);
$pdf->setXY(Misc::AdjustXY(65, $adjust_x), Misc::AdjustXY(100, $adjust_y));
$pdf->Cell(75, 5, TTi18n::gettext('Recipient Copy:'), $border, 0, 'C');
$pdf->SetFont('', '', 10);
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(110, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Date of Issue:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(130, 5, TTDate::getDate('DATE+TIME', $pdf_created_date), $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(110 + $stub_2_offset, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Date of Issue:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(130, 5, TTDate::getDate('DATE+TIME', $pdf_created_date), $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(120, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Recipient:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(110, 5, $user_obj->getFullName(), $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(120 + $stub_2_offset, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Recipient:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(130, 5, $user_obj->getFullName(), $border, 0, 'J');
//Earnings
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(130, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Amount:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(100, 5, ' $' . $pay_stub['entries'][40][0]['amount'], $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(130 + $stub_2_offset, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Amount:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(100, 5, ' $' . $pay_stub['entries'][40][0]['amount'], $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(140, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Regarding:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(100, 5, TTi18n::gettext('Payment from') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']) . ' ' . TTi18n::gettext('to') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'J');
$pdf->setXY(Misc::AdjustXY(75, $adjust_x), Misc::AdjustXY(140 + $stub_2_offset, $adjust_y));
$pdf->SetFont('', 'B', 10);
$pdf->Cell(30, 5, TTi18n::gettext('Regarding:'), $border, 0, 'J');
$pdf->SetFont('', '', 10);
$pdf->Cell(100, 5, TTi18n::gettext('Payment from') . ' ' . TTDate::getDate('DATE', $pay_stub['start_date']) . ' ' . TTi18n::gettext('to') . ' ' . TTDate::getDate('DATE', $pay_stub['end_date']), $border, 0, 'J');
$pdf->SetFont('', 'U', 14);
$pdf->setXY(Misc::AdjustXY(65, $adjust_x), Misc::AdjustXY(210, $adjust_y));
$pdf->Cell(75, 5, $company_obj->getName() . ' ' . TTi18n::gettext('Copy:'), $border, 0, 'C');
$pdf->setXY(Misc::AdjustXY(30, $adjust_x), Misc::AdjustXY(260, $adjust_y));
$column_widths = array('generated_by' => 25, 'signed_by' => 25, 'received_by' => 35, 'date' => 35, 'sin_ssn' => 35);
$line_h = 4;
$cell_h_min = $cell_h_max = $line_h * 4;
$pdf->SetFont('', '', 8);
$pdf->setFillColor(255, 255, 255);
$pdf->MultiCell($column_widths['generated_by'], $line_h, TTi18n::gettext('Generated By') . "\n\n\n ", 1, 'C', 1, 0);
$pdf->MultiCell($column_widths['signed_by'], $line_h, TTi18n::gettext('Signed By') . "\n\n\n ", 1, 'C', 1, 0);
$pdf->MultiCell($column_widths['received_by'], $line_h, TTi18n::gettext('Received By') . "\n\n\n ", 'T,L,B', 'C', 1, 0);
$pdf->MultiCell($column_widths['date'], $line_h, TTi18n::gettext('Date') . "\n\n\n ", 'T,B', 'C', 1, 0);
$pdf->MultiCell($column_widths['sin_ssn'], $line_h, TTi18n::gettext('SIN / SSN') . "\n\n\n ", 'T,R,B', 'C', 1, 0);
$pdf->Ln();
$pdf->SetFont('', '', 10);
break;
}
$i++;
}
$output = $pdf->Output('', 'S');
break;
}
}
if (isset($output)) {
return $output;
}
return FALSE;
}
function exportPayStub($pslf = NULL, $export_type = NULL, $company_obj = NULL)
{
if (is_object($company_obj)) {
$current_company = $company_obj;
} else {
global $current_company;
}
if (!is_object($pslf) and $this->getId() != '') {
$pslf = TTnew('PayStubListFactory');
$pslf->getById($this->getId());
}
if (get_class($pslf) !== 'PayStubListFactory') {
return FALSE;
}
if ($export_type == '') {
return FALSE;
}
if ($pslf->getRecordCount() > 0) {
Debug::Text('aExporting...', __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($export_type)) {
case 'eft_hsbc':
case 'eft_1464':
case 'eft_105':
case 'eft_ach':
case 'eft_beanstream':
//Get file creation number
$ugdlf = TTnew('UserGenericDataListFactory');
$ugdlf->getByCompanyIdAndScriptAndDefault($current_company->getId(), 'PayStubFactory', TRUE);
if ($ugdlf->getRecordCount() > 0) {
$ugd_obj = $ugdlf->getCurrent();
$setup_data = $ugd_obj->getData();
} else {
$ugd_obj = TTnew('UserGenericDataFactory');
}
Debug::Text('bExporting...', __FILE__, __LINE__, __METHOD__, 10);
//get User Bank account info
$balf = TTnew('BankAccountListFactory');
$balf->getCompanyAccountByCompanyId($current_company->getID());
if ($balf->getRecordCount() > 0) {
$company_bank_obj = $balf->getCurrent();
//Debug::Arr($company_bank_obj,'Company Bank Object', __FILE__, __LINE__, __METHOD__,10);
}
if (isset($setup_data['file_creation_number'])) {
$setup_data['file_creation_number']++;
} else {
//Start at a high number, in attempt to eliminate conflicts.
$setup_data['file_creation_number'] = 500;
}
Debug::Text('bFile Creation Number: ' . $setup_data['file_creation_number'], __FILE__, __LINE__, __METHOD__, 10);
//Increment file creation number in DB
if ($ugd_obj->getId() == '') {
$ugd_obj->setID($ugd_obj->getId());
}
$ugd_obj->setCompany($current_company->getId());
$ugd_obj->setScript('PayStubFactory');
$ugd_obj->setName('PayStubFactory');
$ugd_obj->setData($setup_data);
$ugd_obj->setDefault(TRUE);
if ($ugd_obj->isValid()) {
$ugd_obj->Save();
}
$eft = new EFT();
$eft->setFileFormat(str_replace('eft_', '', $export_type));
$eft->setBusinessNumber($current_company->getBusinessNumber());
//ACH
$eft->setOriginatorID($current_company->getOriginatorID());
$eft->setFileCreationNumber($setup_data['file_creation_number']);
$eft->setInitialEntryNumber($current_company->getOtherID5());
//ACH
$eft->setDataCenter($current_company->getDataCenterID());
$eft->setDataCenterName($current_company->getOtherID4());
//ACH
$eft->setOriginatorShortName($current_company->getShortName());
$psealf = TTnew('PayStubEntryAccountListFactory');
foreach ($pslf as $key => $pay_stub_obj) {
Debug::Text('Looping over Pay Stub... ID: ' . $pay_stub_obj->getId(), __FILE__, __LINE__, __METHOD__, 10);
//Get pay stub entries.
$pself = TTnew('PayStubEntryListFactory');
$pself->getByPayStubId($pay_stub_obj->getId());
$prev_type = NULL;
$description_subscript_counter = 1;
foreach ($pself as $pay_stub_entry) {
$description_subscript = NULL;
//$pay_stub_entry_name_obj = $psenlf->getById( $pay_stub_entry->getPayStubEntryNameId() ) ->getCurrent();
$pay_stub_entry_name_obj = $psealf->getById($pay_stub_entry->getPayStubEntryNameId())->getCurrent();
if ($prev_type == 40 or $pay_stub_entry_name_obj->getType() != 40) {
$type = $pay_stub_entry_name_obj->getType();
}
//var_dump( $pay_stub_entry->getDescription() );
if ($pay_stub_entry->getDescription() !== NULL and $pay_stub_entry->getDescription() !== FALSE and strlen($pay_stub_entry->getDescription()) > 0) {
$pay_stub_entry_descriptions[] = array('subscript' => $description_subscript_counter, 'description' => $pay_stub_entry->getDescription());
$description_subscript = $description_subscript_counter;
$description_subscript_counter++;
}
if ($type != 40 or $type == 40 and $pay_stub_entry->getAmount() != 0) {
$pay_stub_entries[$type][] = array('id' => $pay_stub_entry->getId(), 'pay_stub_entry_name_id' => $pay_stub_entry->getPayStubEntryNameId(), 'type' => $pay_stub_entry_name_obj->getType(), 'name' => $pay_stub_entry_name_obj->getName(), 'display_name' => $pay_stub_entry_name_obj->getName(), 'rate' => $pay_stub_entry->getRate(), 'units' => $pay_stub_entry->getUnits(), 'ytd_units' => $pay_stub_entry->getYTDUnits(), 'amount' => $pay_stub_entry->getAmount(), 'ytd_amount' => $pay_stub_entry->getYTDAmount(), 'description' => $pay_stub_entry->getDescription(), 'description_subscript' => $description_subscript, 'created_date' => $pay_stub_entry->getCreatedDate(), 'created_by' => $pay_stub_entry->getCreatedBy(), 'updated_date' => $pay_stub_entry->getUpdatedDate(), 'updated_by' => $pay_stub_entry->getUpdatedBy(), 'deleted_date' => $pay_stub_entry->getDeletedDate(), 'deleted_by' => $pay_stub_entry->getDeletedBy());
}
$prev_type = $pay_stub_entry_name_obj->getType();
}
if (isset($pay_stub_entries)) {
$pay_stub = array('id' => $pay_stub_obj->getId(), 'display_id' => str_pad($pay_stub_obj->getId(), 12, 0, STR_PAD_LEFT), 'user_id' => $pay_stub_obj->getUser(), 'pay_period_id' => $pay_stub_obj->getPayPeriod(), 'start_date' => $pay_stub_obj->getStartDate(), 'end_date' => $pay_stub_obj->getEndDate(), 'transaction_date' => $pay_stub_obj->getTransactionDate(), 'status' => $pay_stub_obj->getStatus(), 'entries' => $pay_stub_entries, 'created_date' => $pay_stub_obj->getCreatedDate(), 'created_by' => $pay_stub_obj->getCreatedBy(), 'updated_date' => $pay_stub_obj->getUpdatedDate(), 'updated_by' => $pay_stub_obj->getUpdatedBy(), 'deleted_date' => $pay_stub_obj->getDeletedDate(), 'deleted_by' => $pay_stub_obj->getDeletedBy());
unset($pay_stub_entries);
//Get User information
$ulf = TTnew('UserListFactory');
$user_obj = $ulf->getById($pay_stub_obj->getUser())->getCurrent();
//Get company information
$clf = TTnew('CompanyListFactory');
$company_obj = $clf->getById($user_obj->getCompany())->getCurrent();
//get User Bank account info
$balf = TTnew('BankAccountListFactory');
$user_bank_obj = $balf->getUserAccountByCompanyIdAndUserId($user_obj->getCompany(), $user_obj->getId());
if ($user_bank_obj->getRecordCount() > 0) {
$user_bank_obj = $user_bank_obj->getCurrent();
} else {
continue;
}
if (isset($pay_stub['entries'][40][0]['amount'])) {
$amount = $pay_stub['entries'][40][0]['amount'];
} else {
$amount = 0;
}
if ($amount > 0) {
$record = new EFT_Record();
$record->setType('C');
$record->setCPACode(200);
$record->setAmount($amount);
$record->setDueDate(TTDate::getBeginDayEpoch($pay_stub_obj->getTransactionDate()));
$record->setInstitution($user_bank_obj->getInstitution());
$record->setTransit($user_bank_obj->getTransit());
$record->setAccount($user_bank_obj->getAccount());
$record->setName($user_obj->getFullName());
$record->setOriginatorShortName($company_obj->getShortName());
$record->setOriginatorLongName(substr($company_obj->getName(), 0, 30));
$record->setOriginatorReferenceNumber('TT' . $pay_stub_obj->getId());
if (isset($company_bank_obj) and is_object($company_bank_obj)) {
$record->setReturnInstitution($company_bank_obj->getInstitution());
$record->setReturnTransit($company_bank_obj->getTransit());
$record->setReturnAccount($company_bank_obj->getAccount());
}
$eft->setRecord($record);
}
unset($amount);
$this->getProgressBarObject()->set(NULL, $key);
}
}
$eft->compile();
$output = $eft->getCompiledData();
break;
case 'cheque_9085':
case 'cheque_9209p':
case 'cheque_dlt103':
case 'cheque_dlt104':
case 'cheque_cr_standard_form_1':
case 'cheque_cr_standard_form_2':
$cheque_form_obj = $this->getChequeFormsObject(str_replace('cheque_', '', $export_type));
$psealf = TTnew('PayStubEntryAccountListFactory');
$numbers_words = new Numbers_Words();
$i = 0;
foreach ($pslf as $pay_stub_obj) {
//Get pay stub entries.
$pself = TTnew('PayStubEntryListFactory');
$pself->getByPayStubId($pay_stub_obj->getId());
$pay_stub_entries = NULL;
$prev_type = NULL;
$description_subscript_counter = 1;
foreach ($pself as $pay_stub_entry) {
$description_subscript = NULL;
//$pay_stub_entry_name_obj = $psenlf->getById( $pay_stub_entry->getPayStubEntryNameId() ) ->getCurrent();
$pay_stub_entry_name_obj = $psealf->getById($pay_stub_entry->getPayStubEntryNameId())->getCurrent();
//Use this to put the total for each type at the end of the array.
if ($prev_type == 40 or $pay_stub_entry_name_obj->getType() != 40) {
$type = $pay_stub_entry_name_obj->getType();
}
//Debug::text('Pay Stub Entry Name ID: '. $pay_stub_entry_name_obj->getId() .' Type ID: '. $pay_stub_entry_name_obj->getType() .' Type: '. $type, __FILE__, __LINE__, __METHOD__,10);
//var_dump( $pay_stub_entry->getDescription() );
if ($pay_stub_entry->getDescription() !== NULL and $pay_stub_entry->getDescription() !== FALSE and strlen($pay_stub_entry->getDescription()) > 0) {
$pay_stub_entry_descriptions[] = array('subscript' => $description_subscript_counter, 'description' => $pay_stub_entry->getDescription());
$description_subscript = $description_subscript_counter;
$description_subscript_counter++;
}
$amount_words = str_pad(ucwords($numbers_words->toWords(floor($pay_stub_entry->getAmount()), "en_US")) . ' ', 65, "-", STR_PAD_RIGHT);
//echo "Amount: ". floor($pay_stub_entry->getAmount()) ." - Words: ". $amount_words ."<br>\n";
//var_dump($amount_words);
if ($type != 40 or $type == 40 and $pay_stub_entry->getAmount() != 0) {
$pay_stub_entries[$type][] = array('id' => $pay_stub_entry->getId(), 'pay_stub_entry_name_id' => $pay_stub_entry->getPayStubEntryNameId(), 'type' => $pay_stub_entry_name_obj->getType(), 'name' => $pay_stub_entry_name_obj->getName(), 'display_name' => $pay_stub_entry_name_obj->getName(), 'rate' => $pay_stub_entry->getRate(), 'units' => $pay_stub_entry->getUnits(), 'ytd_units' => $pay_stub_entry->getYTDUnits(), 'amount' => $pay_stub_entry->getAmount(), 'amount_padded' => str_pad(TTi18n::formatNumber($pay_stub_entry->getAmount(), TRUE, $pay_stub_obj->getCurrencyObject()->getRoundDecimalPlaces()), 12, '*', STR_PAD_LEFT), 'amount_words' => $amount_words, 'amount_cents' => Misc::getAfterDecimal($pay_stub_entry->getAmount()), 'ytd_amount' => $pay_stub_entry->getYTDAmount(), 'description' => $pay_stub_entry->getDescription(), 'description_subscript' => $description_subscript, 'created_date' => $pay_stub_entry->getCreatedDate(), 'created_by' => $pay_stub_entry->getCreatedBy(), 'updated_date' => $pay_stub_entry->getUpdatedDate(), 'updated_by' => $pay_stub_entry->getUpdatedBy(), 'deleted_date' => $pay_stub_entry->getDeletedDate(), 'deleted_by' => $pay_stub_entry->getDeletedBy());
}
unset($amount_words);
//Only for net pay, make a total YTD of Advance plus Net.
/*
if ( $type == 40 ) {
$pay_stub_entries[$type][0]['ytd_net_plus_advance'] =
}
*/
$prev_type = $pay_stub_entry_name_obj->getType();
}
//Get User information
$ulf = TTnew('UserListFactory');
$user_obj = $ulf->getById($pay_stub_obj->getUser())->getCurrent();
//Get company information
$clf = TTnew('CompanyListFactory');
$company_obj = $clf->getById($user_obj->getCompany())->getCurrent();
if ($user_obj->getCountry() == 'CA') {
$date_format = 'd/m/Y';
} else {
$date_format = 'm/d/Y';
}
$pay_stub = array('id' => $pay_stub_obj->getId(), 'display_id' => str_pad($pay_stub_obj->getId(), 15, 0, STR_PAD_LEFT), 'user_id' => $pay_stub_obj->getUser(), 'pay_period_id' => $pay_stub_obj->getPayPeriod(), 'start_date' => $pay_stub_obj->getStartDate(), 'end_date' => $pay_stub_obj->getEndDate(), 'transaction_date' => $pay_stub_obj->getTransactionDate(), 'transaction_date_display' => date($date_format, $pay_stub_obj->getTransactionDate()), 'status' => $pay_stub_obj->getStatus(), 'entries' => $pay_stub_entries, 'tainted' => $pay_stub_obj->getTainted(), 'created_date' => $pay_stub_obj->getCreatedDate(), 'created_by' => $pay_stub_obj->getCreatedBy(), 'updated_date' => $pay_stub_obj->getUpdatedDate(), 'updated_by' => $pay_stub_obj->getUpdatedBy(), 'deleted_date' => $pay_stub_obj->getDeletedDate(), 'deleted_by' => $pay_stub_obj->getDeletedBy());
unset($pay_stub_entries);
if (isset($pay_stub['entries'][40][0]['amount']) and $pay_stub['entries'][40][0]['amount'] > 0) {
//Debug::text($i .'. Pay Stub Transaction Date: '. $pay_stub_obj->getTransactionDate(), __FILE__, __LINE__, __METHOD__,10);
//Get Pay Period information
$pplf = TTnew('PayPeriodListFactory');
$pay_period_obj = $pplf->getById($pay_stub_obj->getPayPeriod())->getCurrent();
$pp_start_date = $pay_period_obj->getStartDate();
$pp_end_date = $pay_period_obj->getEndDate();
$pp_transaction_date = $pay_period_obj->getTransactionDate();
//Get pay period numbers
$ppslf = TTnew('PayPeriodScheduleListFactory');
$pay_period_schedule_obj = $ppslf->getById($pay_period_obj->getPayPeriodSchedule())->getCurrent();
$pay_period_data = array('start_date' => TTDate::getDate('DATE', $pp_start_date), 'end_date' => TTDate::getDate('DATE', $pp_end_date), 'transaction_date' => TTDate::getDate('DATE', $pp_transaction_date), 'annual_pay_periods' => $pay_period_schedule_obj->getAnnualPayPeriods());
$ps_data = array('date' => $pay_stub_obj->getTransactionDate(), 'amount' => $pay_stub['entries'][40][0]['amount'], 'stub_left_column' => $user_obj->getFullName() . "\n" . TTi18n::gettext("Identification #: ") . $pay_stub['display_id'] . "\n" . TTi18n::gettext("Net Pay: ") . $pay_stub_obj->getCurrencyObject()->getSymbol() . TTi18n::formatNumber($pay_stub['entries'][40][0]['amount'], TRUE, $pay_stub_obj->getCurrencyObject()->getRoundDecimalPlaces()), 'stub_right_column' => TTi18n::gettext('Pay Start Date: ') . TTDate::getDate('DATE', $pay_stub['start_date']) . "\n" . TTi18n::gettext('Pay End Date: ') . TTDate::getDate('DATE', $pay_stub['end_date']) . "\n" . TTi18n::gettext('Payment Date: ') . TTDate::getDate('DATE', $pay_stub['transaction_date']), 'start_date' => $pay_stub['start_date'], 'end_date' => $pay_stub['end_date'], 'full_name' => $user_obj->getFullName(), 'address1' => $user_obj->getAddress1(), 'address2' => $user_obj->getAddress2(), 'city' => $user_obj->getCity(), 'province' => $user_obj->getProvince(), 'postal_code' => $user_obj->getPostalCode(), 'country' => $user_obj->getCountry(), 'company_name' => $company_obj->getName(), 'symbol' => $pay_stub_obj->getCurrencyObject()->getSymbol());
$cheque_form_obj->addRecord($ps_data);
$this->getFormObject()->addForm($cheque_form_obj);
}
$this->getProgressBarObject()->set(NULL, $i);
$i++;
}
if (stristr($export_type, 'cheque')) {
$output_format = 'PDF';
}
$output = $this->getFormObject()->output($output_format);
break;
}
}
if (isset($output)) {
return $output;
}
return FALSE;
}
