<?php
/*********************************************************************************
*
* TimeTrex is a Workforce Management program developed by
* TimeTrex Software Inc. Copyright (C) 2003 - 2021 TimeTrex Software Inc.
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU Affero General Public License version 3 as published by
* the Free Software Foundation with the addition of the following permission
* added to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED
* WORK IN WHICH THE COPYRIGHT IS OWNED BY TIMETREX, TIMETREX DISCLAIMS THE
* WARRANTY OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
*
* You should have received a copy of the GNU Affero General Public License along
* with this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
*
* You can contact TimeTrex headquarters at Unit 22 - 2475 Dobbin Rd. Suite
* #292 West Kelowna, BC V4T 2E9, Canada or at email address info@timetrex.com.
*
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
*
* In accordance with Section 7(b) of the GNU Affero General Public License
* version 3, these Appropriate Legal Notices must retain the display of the
* "Powered by TimeTrex" logo. If the display of the logo is not reasonably
* feasible for technical reasons, the Appropriate Legal Notices must display
* the words "Powered by TimeTrex".
*
********************************************************************************/
/**
* @package Module_Install
*/
class InstallSchema_1064A extends InstallSchema_Base {
/**
* @return bool
*/
function preInstall() {
Debug::text( 'preInstall: ' . $this->getVersion(), __FILE__, __LINE__, __METHOD__, 9 );
return true;
}
/**
* @param string $pay_code_id UUID
* @param string $contributing_pay_code_policy_id UUID
* @return bool
*/
function addPayCodeIdToContributingPayCodePolicy( $pay_code_id, $contributing_pay_code_policy_id ) {
$cpcplf = TTnew( 'ContributingPayCodePolicyListFactory' ); /** @var ContributingPayCodePolicyListFactory $cpcplf */
$cpcplf->getById( $contributing_pay_code_policy_id );
if ( $cpcplf->getRecordCount() == 1 ) {
foreach ( $cpcplf as $cpcp_obj ) {
$pay_code_ids = $cpcp_obj->getPayCode();
if ( !is_array( $pay_code_ids ) ) {
Debug::Arr( $pay_code_ids, 'No Pay Codes assigned yet, starting from scratch...', __FILE__, __LINE__, __METHOD__, 9 );
$pay_code_ids = [];
}
$pay_code_ids[] = $pay_code_id;
$cpcp_obj->setPayCode( $pay_code_ids );
if ( $cpcp_obj->isValid() ) {
$cpcp_obj->Save();
Debug::Text( 'Assigning Pay Code: ' . $pay_code_id . ' To Contributing Pay Code Policy: ' . $contributing_pay_code_policy_id, __FILE__, __LINE__, __METHOD__, 9 );
return true;
}
}
}
Debug::text( 'ERROR: Unable to assign Pay Code to Contributing Pay Code... Pay Code: ' . $pay_code_id . ' Contributing Pay Code Policy: ' . $contributing_pay_code_policy_id . ' Record Count: ' . $cpcplf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 9 );
return false;
}
/**
* @return bool
*/
function postInstall() {
Debug::text( 'postInstall: ' . $this->getVersion(), __FILE__, __LINE__, __METHOD__, 9 );
$clf = TTNew( 'CompanyListFactory' ); /** @var CompanyListFactory $clf */
$clf->getAll();
if ( $clf->getRecordCount() > 0 ) {
$x = 0;
foreach ( $clf as $company_obj ) {
//Go through each permission group, and enable schedule, view_open for for anyone who has schedule, view
Debug::text( 'Company: ' . $company_obj->getName() . ' X: ' . $x . ' of :' . $clf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 9 );
$pclf = TTnew( 'PermissionControlListFactory' ); /** @var PermissionControlListFactory $pclf */
$pclf->getByCompanyId( $company_obj->getId(), null, null, null, [ 'name' => 'asc' ] ); //Force order to prevent references to columns that haven't been created yet.
if ( $pclf->getRecordCount() > 0 ) {
foreach ( $pclf as $pc_obj ) {
Debug::text( 'Permission Group: ' . $pc_obj->getName(), __FILE__, __LINE__, __METHOD__, 9 );
$plf = TTnew( 'PermissionListFactory' ); /** @var PermissionListFactory $plf */
$plf->getByCompanyIdAndPermissionControlIdAndSectionAndNameAndValue( $company_obj->getId(), $pc_obj->getId(), 'over_time_policy', 'add', 1 ); //Only return records where permission is ALLOWED.
if ( $plf->getRecordCount() > 0 ) {
Debug::text( 'Found permission group with over_time_policy, add enabled: ' . $plf->getCurrent()->getValue(), __FILE__, __LINE__, __METHOD__, 9 );
$pc_obj->setPermission(
[
'pay_code' => [
'enabled' => true,
'view' => true,
'add' => true,
'edit' => true,
'delete' => true,
],
'pay_formula_policy' => [
'enabled' => true,
'view' => true,
'add' => true,
'edit' => true,
'delete' => true,
],
'contributing_pay_code_policy' => [
'enabled' => true,
'view' => true,
'add' => true,
'edit' => true,
'delete' => true,
],
'contributing_shift_policy' => [
'enabled' => true,
'view' => true,
'add' => true,
'edit' => true,
'delete' => true,
],
'regular_time_policy' => [
'enabled' => true,
'view' => true,
'add' => true,
'edit' => true,
'delete' => true,
],
]
);
} else {
Debug::text( 'Permission group does NOT have over_time_policy, add enabled...', __FILE__, __LINE__, __METHOD__, 9 );
}
}
}
unset( $pclf, $plf, $pc_obj );
//Get list of valid pay stub accounts for this company, so we can make sure we don't get a validation error when creating pay codes.
$pay_stub_accounts = [];
$psealf = TTNew( 'PayStubEntryAccountListFactory' ); /** @var PayStubEntryAccountListFactory $psealf */
$psealf->getByCompanyId( $company_obj->getId() );
if ( $psealf->getRecordCount() > 0 ) {
foreach ( $psealf as $psea_obj ) {
$pay_stub_accounts[$psea_obj->getId()] = true;
}
}
unset( $psealf );
//Dummy pay code.
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $company_obj->getId() );
$pcf->setName( 'DUMMY (DELETE ME)' ); //Can't change name, as we need to delete this in 1065A schema upgrade.
$pcf->setCode( 'DUMMY' ); //Can't change code, as we need to delete this in 1065A schema upgrade.
$pcf->setType( 10 ); //Paid
$pcf->setPayFormulaPolicy( TTUUID::getZeroID() );
$pcf->setPayStubEntryAccountId( (int)CompanyDeductionFactory::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName( $company_obj->getId(), 10, TTi18n::gettext( 'Regular Time' ) ) );
if ( $pcf->isValid() ) {
$dummy_pay_code_id = $pcf->Save();
Debug::text( ' Created Dummy Pay Code ID: ' . $dummy_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
}
//Create dummy pay code/contributing shift policies, then assign actual pay codes to them later.
//Contributing Pay Code Policy for just Regular Time
//Required to calculate Overtime Policies
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time' );
$cpcpf->setPayCode( $dummy_pay_code_id );
$contributing_pay_code_policy_insert_id = [];
$contributing_shift_policy_insert_id = [];
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time'], __FILE__, __LINE__, __METHOD__, 10 );
}
} else {
Debug::Arr( $cpcpf->Validator->getErrors(), 'ERROR: Invalid ContributingPayCodePolicy, unable to continue with upgrade...', __FILE__, __LINE__, __METHOD__, 10 );
return false;
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Meal + Break' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
//Contributing Pay Code Policy for just Regular Time & Overtime
//Required to calculate Premium Policies
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime + Meal' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime + Break' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time_and_break_policy'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime + Meal + Break' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
//Contributing Pay Code Policy for just Regular Time & OverTime & Paid Absences
//Required to calculate Holiday Policies
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Paid Absence' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_paid_absence'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_paid_absence'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_paid_absence'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Meal + Break + Paid Absence' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime + Paid Absence' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time_and_paid_absence'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
$cpcpf = TTnew( 'ContributingPayCodePolicyFactory' ); /** @var ContributingPayCodePolicyFactory $cpcpf */
$cpcpf->setId( $cpcpf->getNextInsertId() );
$cpcpf->setCompany( $company_obj->getId() );
$cpcpf->setName( 'Regular Time + Overtime + Meal + Break + Paid Absence' );
$cpcpf->setPayCode( $dummy_pay_code_id );
if ( $cpcpf->isValid() ) {
$contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] = $cpcpf->Save( false, true );
Debug::Text( 'Contributing Pay Code Policy ID: ' . $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
$cspf = TTnew( 'ContributingShiftPolicyFactory' ); /** @var ContributingShiftPolicyFactory $cspf */
$cspf->setCompany( $company_obj->getId() );
$cspf->setName( $cpcpf->getName() );
$cspf->setContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$cspf->setMon( true );
$cspf->setTue( true );
$cspf->setWed( true );
$cspf->setThu( true );
$cspf->setFri( true );
$cspf->setSat( true );
$cspf->setSun( true );
if ( $cspf->isValid() ) {
$contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] = $cspf->Save();
Debug::Text( 'Contributing Shift Policy ID: ' . $contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'], __FILE__, __LINE__, __METHOD__, 10 );
}
}
unset( $cpcpf, $cspf );
//This must go before PayFormulaPolicies are created.
$aplf = TTNew( 'AccrualPolicyListFactory' ); /** @var AccrualPolicyListFactory $aplf */
$aplf->getByCompanyId( $company_obj->getId() );
if ( $aplf->getRecordCount() > 0 ) {
foreach ( $aplf as $ap_obj ) {
//Create Accrual Policy Account with matching ID so we don't have to migrate Accrual/Pay Formula Policy rows.
$apa_obj = TTNew( 'AccrualPolicyAccountFactory' ); /** @var AccrualPolicyAccountFactory $apa_obj */
$apa_obj->setId( $ap_obj->getID() );
$apa_obj->setCompany( $ap_obj->getCompany() );
$apa_obj->setName( $ap_obj->getName() );
$apa_obj->setEnablePayStubBalanceDisplay( $ap_obj->getEnablePayStubBalanceDisplay() );
if ( $apa_obj->isValid() ) {
$insert_accrual_policy_account_id = $apa_obj->Save( true, true ); //Force lookup
$ap_obj->setContributingShiftPolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time'] );
$ap_obj->setLengthOfServiceContributingPayCodePolicy( $contributing_pay_code_policy_insert_id['regular_time_and_over_time'] );
$ap_obj->setAccrualPolicyAccount( $insert_accrual_policy_account_id );
if ( $ap_obj->isValid() ) {
$ap_obj->Save();
}
}
}
}
//Create pay formulas.
$pfpf = TTnew( 'PayFormulaPolicyFactory' ); /** @var PayFormulaPolicyFactory $pfpf */
$pfpf->setCompany( $company_obj->getId() );
$pfpf->setName( 'UnPaid (0.0x)' );
$pfpf->setPayType( 10 ); //Pay Multiplied By Factor
$pfpf->setRate( 0.0 );
$pfpf->setWageGroup( TTUUID::getZeroID() );
$pfpf->setAccrualRate( 1.0 );
$pfpf->setAccrualPolicyAccount( TTUUID::getZeroID() );
if ( $pfpf->isValid() ) {
$unpaid_pay_formula_policy_id = $pfpf->Save();
}
unset( $pfpf );
$pfpf = TTnew( 'PayFormulaPolicyFactory' ); /** @var PayFormulaPolicyFactory $pfpf */
$pfpf->setCompany( $company_obj->getId() );
$pfpf->setName( 'Regular (1.0x)' );
$pfpf->setPayType( 10 ); //Pay Multiplied By Factor
$pfpf->setRate( 1.0 );
$pfpf->setWageGroup( TTUUID::getZeroID() );
$pfpf->setAccrualRate( 1.0 );
$pfpf->setAccrualPolicyAccount( TTUUID::getZeroID() );
if ( $pfpf->isValid() ) {
$regular_pay_formula_policy_id = $pfpf->Save();
}
unset( $pfpf );
$pay_code_map = [];
//Regular time pay code.
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $company_obj->getId() );
$pcf->setName( 'Regular Time' );
$pcf->setCode( 'REG' );
$pcf->setType( 10 ); //Paid
$pcf->setPayFormulaPolicy( $regular_pay_formula_policy_id );
$pcf->setPayStubEntryAccountId( (int)CompanyDeductionFactory::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName( $company_obj->getId(), 10, TTi18n::gettext( 'Regular Time' ) ) );
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
//Need to convert all wage/wage_with_burden/hourly_rate/hourly_rate_with_burden columns.
$pay_code_map['/"regular_time"/'] = '"pay_code-' . $insert_pay_code_id . '_time"';
$pay_code_map['/"regular_time_wage"/'] = '"pay_code-' . $insert_pay_code_id . '_wage"';
$pay_code_map['/"regular_time_wage_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_wage_with_burden"';
$pay_code_map['/"regular_time_hourly_rate"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate"';
$pay_code_map['/"regular_time_hourly_rate_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate_with_burden"';
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$rtpf = TTnew( 'RegularTimePolicyFactory' ); /** @var RegularTimePolicyFactory $rtpf */
$rtpf->setCompany( $company_obj->getId() );
$rtpf->setName( 'Regular Time' );
$rtpf->setCalculationOrder( 9999 );
//Meal/Break time is included in Regular Time in v7.3 and lower, so we need to do that here too.
//However this makes its so it has to always be included in premium time as well.
$rtpf->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
$rtpf->setPayCode( $insert_pay_code_id );
if ( $rtpf->isValid() ) {
$regular_time_policy_id = $rtpf->Save();
//Add regular time policy to Policy Groups.
$pglf = TTNew( 'PolicyGroupListFactory' ); /** @var PolicyGroupListFactory $pglf */
$pglf->getByCompanyId( $company_obj->getId() );
if ( $pglf->getRecordCount() > 0 ) {
foreach ( $pglf as $pg_obj ) {
Debug::text( ' Adding Regular Time Policy ID: ' . $regular_time_policy_id . ' to Policy Group: ' . $pg_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$pg_obj->setRegularTimePolicy( $regular_time_policy_id );
if ( $pg_obj->isValid() ) {
$pg_obj->Save();
}
}
}
unset( $pglf, $pg_obj );
}
}
unset( $pcf, $rtpf, $insert_pay_code_id, $regular_time_policy_id );
//Loop over all overtime/premium/absence/meal/break policies and create pay codes based on them.
//Update pay_code_id on each policy as we go, so we can use that as the mapping later when user_date_total as modified.
$otplf = TTNew( 'OverTimePolicyListFactory' ); /** @var OverTimePolicyListFactory $otplf */
$otplf->getByCompanyId( $company_obj->getId() );
if ( $otplf->getRecordCount() > 0 ) {
foreach ( $otplf as $otp_obj ) {
Debug::text( ' Converting OverTime Policy ID: ' . $otp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$pfpf = TTnew( 'PayFormulaPolicyFactory' ); /** @var PayFormulaPolicyFactory $pfpf */
$pfpf->setCompany( $company_obj->getId() );
$pfpf->setName( 'OverTime - ' . $otp_obj->getName() . ' (' . (float)$otp_obj->getColumn( 'rate' ) . 'x) [' . $otp_obj->getID() . ']' );
$pfpf->setPayType( 10 ); //Pay Multiplied By Factor
$pfpf->setRate( (float)$otp_obj->getColumn( 'rate' ) );
$pfpf->setWageGroup( (int)$otp_obj->getColumn( 'wage_group_id' ) );
$pfpf->setAccrualRate( (float)$otp_obj->getColumn( 'accrual_rate' ) );
$pfpf->setAccrualPolicyAccount( (int)$otp_obj->getColumn( 'accrual_policy_id' ) );
if ( $pfpf->isValid() ) {
$pay_formula_policy_id = $pfpf->Save();
}
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $otp_obj->getCompany() );
$pcf->setName( 'OverTime - ' . $otp_obj->getName() . ' [' . $otp_obj->getID() . ']' );
$pcf->setCode( 'OT' . $otp_obj->getID() );
$pcf->setType( 12 ); //Paid Above Salary
$pcf->setPayFormulaPolicy( $pay_formula_policy_id );
if ( isset( $pay_stub_accounts[(int)$otp_obj->getColumn( 'pay_stub_entry_account_id' )] ) ) {
$pcf->setPayStubEntryAccountId( (int)$otp_obj->getColumn( 'pay_stub_entry_account_id' ) );
} else {
Debug::text( ' Invalid PayStub Account ID: ' . (int)$otp_obj->getColumn( 'pay_stub_entry_account_id' ), __FILE__, __LINE__, __METHOD__, 9 );
$pcf->setPayStubEntryAccountId( TTUUID::getZeroID() );
}
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
$pay_code_map['/"over_time_policy-' . $otp_obj->getID() . '"/'] = '"pay_code-' . $insert_pay_code_id . '_time"';
$pay_code_map['/"over_time_policy-' . $otp_obj->getID() . '_wage"/'] = '"pay_code-' . $insert_pay_code_id . '_wage"';
$pay_code_map['/"over_time_policy-' . $otp_obj->getID() . '_wage_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_wage_with_burden"';
$pay_code_map['/"over_time_policy-' . $otp_obj->getID() . '_hourly_rate"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate"';
$pay_code_map['/"over_time_policy-' . $otp_obj->getID() . '_hourly_rate_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate_with_burden"';
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$otp_obj->setPayCode( $insert_pay_code_id );
//Regular time already includes Meal/Break policy time as defined above, so don't include it twice by using Reg+Meal+Break here.
$otp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time'] );
//$otp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
if ( $otp_obj->isValid() ) {
$otp_obj->Save();
}
}
}
}
unset( $otplf, $otp_obj, $pcf, $insert_pay_code_id );
$pplf = TTNew( 'PremiumPolicyListFactory' ); /** @var PremiumPolicyListFactory $pplf */
$pplf->getByCompanyId( $company_obj->getId() );
if ( $pplf->getRecordCount() > 0 ) {
foreach ( $pplf as $pp_obj ) {
Debug::text( ' Converting Premium Policy ID: ' . $pp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$tmp_rate = $pp_obj->getColumn( 'rate' );
if ( $pp_obj->getColumn( 'pay_type_id' ) == 10 ) {
//Reduce rate by -1.0 as the pay codes handle the rates now and it doesn't make sense to automatically account for this in premium policies anymore.
//$tmp_rate = ( $pp_obj->getColumn('rate') >= 1 ) ? ( (float)$pp_obj->getColumn('rate') - 1.0 ) : (float)$pp_obj->getColumn('rate');
$tmp_rate = ( (float)$pp_obj->getColumn( 'rate' ) - 1.0 );
}
$pfpf = TTnew( 'PayFormulaPolicyFactory' ); /** @var PayFormulaPolicyFactory $pfpf */
$pfpf->setCompany( $company_obj->getId() );
$pfpf->setName( 'Premium - ' . $pp_obj->getName() . ' (' . $tmp_rate . 'x) [' . $pp_obj->getID() . ']' );
if ( $pp_obj->getColumn( 'pay_type_id' ) == 20 ) {
//Convert Pay + Premium (#20) to Flat Hourly Rate (#32), as thats really what it was when considering premium policies.
$pfpf->setPayType( 32 ); //Flat Hourly Rate
$pfpf->setRate( $tmp_rate );
} else if ( $pp_obj->getColumn( 'pay_type_id' ) == 32 ) {
//In v7 Pay Type #32 (Flat Hourly Rate) wasn't actually using the flat hourly rate
//specified in the premium policy, but the rate specified by the wage group wage instead.
//Since we need to keep the historical data the same, keep the policies calculating the same values too.
//Therefore convert it to Pay Multiplied By Factor of 1.0 using the same wage group.
$pfpf->setPayType( 10 );
$pfpf->setRate( 1.0 );
} else {
$pfpf->setPayType( $pp_obj->getColumn( 'pay_type_id' ) );
$pfpf->setRate( $tmp_rate );
}
$pfpf->setWageGroup( (int)$pp_obj->getColumn( 'wage_group_id' ) );
$pfpf->setAccrualRate( (float)$pp_obj->getColumn( 'accrual_rate' ) );
$pfpf->setAccrualPolicyAccount( (int)$pp_obj->getColumn( 'accrual_policy_id' ) );
if ( $pfpf->isValid() ) {
$pay_formula_policy_id = $pfpf->Save();
}
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $pp_obj->getCompany() );
$pcf->setName( 'Premium - ' . $pp_obj->getName() . ' [' . $pp_obj->getID() . ']' );
$pcf->setCode( 'PRE' . $pp_obj->getID() );
$pcf->setType( 12 ); //Paid Above Salary
$pcf->setPayFormulaPolicy( $pay_formula_policy_id );
if ( isset( $pay_stub_accounts[(int)$pp_obj->getColumn( 'pay_stub_entry_account_id' )] ) ) {
$pcf->setPayStubEntryAccountId( (int)$pp_obj->getColumn( 'pay_stub_entry_account_id' ) );
} else {
Debug::text( ' Invalid PayStub Account ID: ' . (int)$pp_obj->getColumn( 'pay_stub_entry_account_id' ), __FILE__, __LINE__, __METHOD__, 9 );
$pcf->setPayStubEntryAccountId( TTUUID::getZeroID() );
}
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
$pay_code_map['/"premium_policy-' . $pp_obj->getID() . '"/'] = '"pay_code-' . $insert_pay_code_id . '_time"';
$pay_code_map['/"premium_policy-' . $pp_obj->getID() . '_wage"/'] = '"pay_code-' . $insert_pay_code_id . '_wage"';
$pay_code_map['/"premium_policy-' . $pp_obj->getID() . '_wage_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_wage_with_burden"';
$pay_code_map['/"premium_policy-' . $pp_obj->getID() . '_hourly_rate"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate"';
$pay_code_map['/"premium_policy-' . $pp_obj->getID() . '_hourly_rate_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate_with_burden"';
$pp_obj->setPayCode( $insert_pay_code_id );
//Regular time already includes Meal/Break policy time as defined above.
//So we can't exclude Meal/Break from premium policies, we have to just use Regular time by itself always.
$pp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time'] );
/*
if ( $pp_obj->getIncludeMealPolicy() == TRUE AND $pp_obj->getIncludeBreakPolicy() == TRUE ) {
$pp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
} elseif( $pp_obj->getIncludeMealPolicy() == TRUE ) {
$pp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
} elseif( $pp_obj->getIncludeBreakPolicy() == TRUE ) {
$pp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
} else {
$pp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time'] );
}
*/
if ( $pp_obj->isValid() ) {
$pp_obj->Save();
}
}
}
}
unset( $pplf, $pp_obj, $pcf, $insert_pay_code_id );
$aplf = TTNew( 'AbsencePolicyListFactory' ); /** @var AbsencePolicyListFactory $aplf */
$aplf->getByCompanyId( $company_obj->getId() );
if ( $aplf->getRecordCount() > 0 ) {
foreach ( $aplf as $ap_obj ) {
Debug::text( ' Converting Absence Policy ID: ' . $ap_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$pfpf = TTnew( 'PayFormulaPolicyFactory' ); /** @var PayFormulaPolicyFactory $pfpf */
$pfpf->setCompany( $company_obj->getId() );
$pfpf->setName( 'Absence - ' . $ap_obj->getName() . ' (' . (float)$ap_obj->getColumn( 'rate' ) . 'x) [' . $ap_obj->getID() . ']' );
$pfpf->setPayType( 10 ); //Multiplied by factor
$pfpf->setRate( (float)$ap_obj->getColumn( 'rate' ) );
$pfpf->setWageGroup( (int)$ap_obj->getColumn( 'wage_group_id' ) );
$pfpf->setAccrualRate( ( (float)$ap_obj->getColumn( 'accrual_rate' ) * -1 ) ); //Absence time should withdrawl from accrual.
$pfpf->setAccrualPolicyAccount( (int)$ap_obj->getColumn( 'accrual_policy_id' ) );
if ( $pfpf->isValid() ) {
$pay_formula_policy_id = $pfpf->Save();
}
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $ap_obj->getCompany() );
$pcf->setName( 'Absence - ' . $ap_obj->getName() . ' [' . $ap_obj->getID() . ']' );
$pcf->setCode( 'ABS' . $ap_obj->getID() );
$pcf->setType( $ap_obj->getColumn( 'type_id' ) );
$pcf->setPayFormulaPolicy( $pay_formula_policy_id );
if ( isset( $pay_stub_accounts[(int)$ap_obj->getColumn( 'pay_stub_entry_account_id' )] ) ) {
$pcf->setPayStubEntryAccountId( (int)$ap_obj->getColumn( 'pay_stub_entry_account_id' ) );
} else {
Debug::text( ' Invalid PayStub Account ID: ' . (int)$ap_obj->getColumn( 'pay_stub_entry_account_id' ), __FILE__, __LINE__, __METHOD__, 9 );
$pcf->setPayStubEntryAccountId( TTUUID::getZeroID() );
}
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
$pay_code_map['/"absence_policy-' . $ap_obj->getID() . '"/'] = '"pay_code-' . $insert_pay_code_id . '_time"';
$pay_code_map['/"absence_policy-' . $ap_obj->getID() . '_wage"/'] = '"pay_code-' . $insert_pay_code_id . '_wage"';
$pay_code_map['/"absence_policy-' . $ap_obj->getID() . '_wage_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_wage_with_burden"';
$pay_code_map['/"absence_policy-' . $ap_obj->getID() . '_hourly_rate"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate"';
$pay_code_map['/"absence_policy-' . $ap_obj->getID() . '_hourly_rate_with_burden"/'] = '"pay_code-' . $insert_pay_code_id . '_hourly_rate_with_burden"';
if ( $ap_obj->getColumn( 'type_id' ) == 10 || $ap_obj->getColumn( 'type_id' ) == 12 ) { //Paid absences only.
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
}
$ap_obj->setPayCode( $insert_pay_code_id );
if ( $ap_obj->isValid() ) {
$ap_obj->Save();
}
}
}
}
unset( $pplf, $pp_obj, $pcf, $insert_pay_code_id );
$mplf = TTNew( 'MealPolicyListFactory' ); /** @var MealPolicyListFactory $mplf */
$mplf->getByCompanyId( $company_obj->getId() );
if ( $mplf->getRecordCount() > 0 ) {
foreach ( $mplf as $mp_obj ) {
Debug::text( ' Converting Meal Policy ID: ' . $mp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $mp_obj->getCompany() );
$pcf->setName( 'Meal - ' . $mp_obj->getName() . ' [' . $mp_obj->getID() . ']' );
$pcf->setCode( 'MEAL' . $mp_obj->getID() );
$pcf->setType( 10 ); //Paid
$pcf->setPayStubEntryAccountId( (int)CompanyDeductionFactory::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName( $mp_obj->getCompany(), 10, TTi18n::gettext( 'Regular Time' ) ) );
//Since Auto-Add lunch time is included in Regular Time prior to TT v8, the pay formula should always be at a 0 rate since its already paid.
$pcf->setPayFormulaPolicy( $unpaid_pay_formula_policy_id );
//if ( $mp_obj->getType() == 15 ) { //Auto-Add
// $pcf->setPayFormulaPolicy( $regular_pay_formula_policy_id );
//} else {
// $pcf->setPayFormulaPolicy( TTUUID::getZeroID() );
//}
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$mp_obj->setPayCode( $insert_pay_code_id );
if ( $mp_obj->isValid() ) {
$mp_obj->Save();
}
}
}
}
unset( $mplf, $mp_obj, $pcf, $insert_pay_code_id );
$bplf = TTNew( 'BreakPolicyListFactory' ); /** @var BreakPolicyListFactory $bplf */
$bplf->getByCompanyId( $company_obj->getId() );
if ( $bplf->getRecordCount() > 0 ) {
foreach ( $bplf as $bp_obj ) {
Debug::text( ' Converting Break Policy ID: ' . $bp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$pcf = TTNew( 'PayCodeFactory' ); /** @var PayCodeFactory $pcf */
$pcf->setCompany( $bp_obj->getCompany() );
$pcf->setName( 'Break - ' . $bp_obj->getName() . ' [' . $bp_obj->getID() . ']' );
$pcf->setCode( 'BRK' . $bp_obj->getID() );
$pcf->setType( 10 ); //Paid
$pcf->setPayStubEntryAccountId( (int)CompanyDeductionFactory::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName( $bp_obj->getCompany(), 10, TTi18n::gettext( 'Regular Time' ) ) );
//Since Auto-Add break time is included in Regular Time prior to TT v8, the pay formula should always be at a 0 rate since its already paid.
$pcf->setPayFormulaPolicy( $unpaid_pay_formula_policy_id );
//if ( $bp_obj->getType() == 15 ) { //Auto-Add
// $pcf->setPayFormulaPolicy( $regular_pay_formula_policy_id );
//} else {
// $pcf->setPayFormulaPolicy( TTUUID::getZeroID() );
//}
if ( $pcf->isValid() ) {
$insert_pay_code_id = $pcf->Save();
Debug::text( ' Created Pay Code ID: ' . $insert_pay_code_id, __FILE__, __LINE__, __METHOD__, 9 );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_over_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$this->addPayCodeIdToContributingPayCodePolicy( $insert_pay_code_id, $contributing_pay_code_policy_insert_id['regular_time_and_meal_policy_and_break_policy_and_paid_absence'] );
$bp_obj->setPayCode( $insert_pay_code_id );
if ( $bp_obj->isValid() ) {
$bp_obj->Save();
}
}
}
}
unset( $bplf, $bp_obj, $pcf, $insert_pay_code_id );
$hplf = TTNew( 'HolidayPolicyListFactory' ); /** @var HolidayPolicyListFactory $hplf */
$hplf->getByCompanyId( $company_obj->getId() );
if ( $hplf->getRecordCount() > 0 ) {
foreach ( $hplf as $hp_obj ) {
if ( $hp_obj->getIncludeOverTime() == true && $hp_obj->getIncludePaidAbsenceTime() == true ) {
//Meal/Break time is already included in Regular Time by default.
$hp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
$hp_obj->setEligibleContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time_and_paid_absence'] );
} else if ( $hp_obj->getIncludeOverTime() == true ) {
$hp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time'] );
$hp_obj->setEligibleContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_over_time'] );
} else if ( $hp_obj->getIncludePaidAbsenceTime() == true ) {
$hp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_paid_absence'] );
$hp_obj->setEligibleContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time_and_paid_absence'] );
} else {
$hp_obj->setContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time'] );
$hp_obj->setEligibleContributingShiftPolicy( $contributing_shift_policy_insert_id['regular_time'] );
}
if ( $hp_obj->isValid() ) {
Debug::text( ' Assigned Contributing Shift Policy to Holiday Policy: ' . $hp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$hp_obj->Save();
}
}
}
//Remove addUserDate() from cron
//However calcExceptions calculates dates retroactively using UserDate table, so they will always have 0 hour totals.
//Can we change this to calculate dates that don't technically exist yet? We just need to loop through the specific dates and recalculate the days.
// - Also check to see if the pay period is closed and skip those dates to save processing?
$cjlf = TTnew( 'CronJobListFactory' ); /** @var CronJobListFactory $cjlf */
$cjlf->getByName( 'AddUserDate' );
if ( $cjlf->getRecordCount() > 0 ) {
foreach ( $cjlf as $cj_obj ) {
$cj_obj->setDeleted( true );
if ( $cj_obj->isValid() ) {
$cj_obj->Save();
}
}
unset( $cjlf, $cj_obj );
}
Debug::Arr( $pay_code_map, ' Pay Code Map: ', __FILE__, __LINE__, __METHOD__, 9 );
//Migrate saved reports to the new pay codes
//This handles PayrollExport settings too as those are saved as UserReportData as well.
if ( is_array( $pay_code_map ) && count( $pay_code_map ) > 0 ) {
$urdlf = TTnew( 'UserReportDataListFactory' ); /** @var UserReportDataListFactory $urdlf */
$urdlf->getAPISearchByCompanyIdAndArrayCriteria( $company_obj->getID(), [] );
Debug::text( ' Found Saved Reports: ' . $urdlf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 9 );
if ( $urdlf->getRecordCount() > 0 ) {
foreach ( $urdlf as $urd_obj ) {
Debug::text( ' Migrating Saved Report: ' . $urd_obj->getName() . ' (' . $urd_obj->getID() . ') Script: ' . $urd_obj->getScript(), __FILE__, __LINE__, __METHOD__, 9 );
$report_data = $urd_obj->getData();
if ( is_array( $report_data ) ) {
//Debug::Arr( $report_data, ' Report Data: ', __FILE__, __LINE__, __METHOD__, 9);
//Recursively search & replace all keys/values in an array, json encode it to text, search&replace, then decode.
if ( $urd_obj->getUser() == '' && isset( $report_data['export_columns'] ) ) {
Debug::text( ' Found Export Setup data, converting separately...', __FILE__, __LINE__, __METHOD__, 9 );
//This is a company wide saved report, like Payroll Export setup data. Need to handle it slightly differently.
$report_data['export_columns'] = json_decode( preg_replace( array_keys( $pay_code_map ), str_replace( '_time', '', array_values( $pay_code_map ) ), json_encode( $report_data['export_columns'] ) ), true );
}
$tmp_report_data = json_decode( preg_replace( array_keys( $pay_code_map ), array_values( $pay_code_map ), json_encode( $report_data ) ), true );
Debug::Arr( $tmp_report_data, ' Converted Report: ', __FILE__, __LINE__, __METHOD__, 9 );
$urd_obj->setData( $tmp_report_data );
if ( $urd_obj->isValid() ) {
$urd_obj->Save();
}
unset( $tmp_report_data, $report_data );
}
}
}
unset( $urdlf, $urd_obj );
if ( getTTProductEdition() >= TT_PRODUCT_PROFESSIONAL ) {
//Custom Columns selections and formulas need to be converted as well.
$rcclf = TTnew( 'ReportCustomColumnListFactory' ); /** @var ReportCustomColumnListFactory $rcclf */
$rcclf->getByCompanyId( $company_obj->getID() );
Debug::text( ' Found Custom Columns: ' . $rcclf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 9 );
if ( $rcclf->getRecordCount() > 0 ) {
foreach ( $rcclf as $rcc_obj ) {
Debug::text( ' Migrating Custom Column: ' . $rcc_obj->getName() . ' (' . $rcc_obj->getID() . ') Script: ' . $rcc_obj->getScript() . ' Type: ' . $rcc_obj->getType(), __FILE__, __LINE__, __METHOD__, 9 );
$include_columns = $rcc_obj->getIncludeColumns();
if ( is_array( $include_columns ) && count( $include_columns ) > 0 ) {
$tmp_include_columns = json_decode( preg_replace( array_keys( $pay_code_map ), array_values( $pay_code_map ), json_encode( $include_columns ) ), true );
Debug::Arr( $tmp_include_columns, ' Converted Include Columns: ', __FILE__, __LINE__, __METHOD__, 9 );
$rcc_obj->setIncludeColumns( $tmp_include_columns );
}
unset( $include_columns, $tmp_include_columns );
$exclude_columns = $rcc_obj->getExcludeColumns();
if ( is_array( $exclude_columns ) && count( $exclude_columns ) > 0 ) {
$tmp_exclude_columns = json_decode( preg_replace( array_keys( $pay_code_map ), array_values( $pay_code_map ), json_encode( $exclude_columns ) ), true );
Debug::Arr( $tmp_exclude_columns, ' Converted Exclude Columns: ', __FILE__, __LINE__, __METHOD__, 9 );
$rcc_obj->setExcludeColumns( $tmp_exclude_columns );
}
unset( $exclude_columns, $tmp_exclude_columns );
$formula = $rcc_obj->getFormula();
if ( $formula != '' ) {
//Make sure to remove double quotes from pay_code_map as they aren't used in the formula.
$tmp_formula = json_decode( preg_replace( str_replace( '"', '', array_keys( $pay_code_map ) ), str_replace( '"', '', array_values( $pay_code_map ) ), json_encode( $formula ) ), true );
Debug::Arr( $tmp_formula, ' Converted Formula: ', __FILE__, __LINE__, __METHOD__, 9 );
$rcc_obj->setFormula( $tmp_formula );
}
unset( $formula, $tmp_formula );
if ( $rcc_obj->isValid() ) {
$rcc_obj->Save();
}
}
}
unset( $rcclf, $rcc_obj );
}
}
//Convert schedule policies to Include/Exclude format.
$splf = TTNew( 'SchedulePolicyListFactory' ); /** @var SchedulePolicyListFactory $splf */
$splf->getByCompanyId( $company_obj->getId() );
if ( $splf->getRecordCount() > 0 ) {
foreach ( $splf as $sp_obj ) {
Debug::text( ' Converting Schedule Policy ID: ' . $sp_obj->getID(), __FILE__, __LINE__, __METHOD__, 9 );
$sp_obj->getIncludeOverTimePolicy( (int)$sp_obj->getColumn( 'over_time_policy_id' ) );
$sp_obj->setMealPolicy( (int)$sp_obj->getColumn( 'meal_policy_id' ) );
if ( $sp_obj->isValid() ) {
$sp_obj->Save();
}
}
}
//
//Delete dummy pay code in 1065A postInstall, as the DB still needs to be fully updated.
//
unset( $pay_stub_accounts, $pay_code_map, $contributing_pay_code_policy_insert_id, $contributing_shift_policy_insert_id, $company_obj );
$x++;
}
}
return true;
}
}
?>