static function addPresets($company_id)
{
if ($company_id == '') {
Debug::text('Company ID: ' . $company_id, __FILE__, __LINE__, __METHOD__, 10);
return FALSE;
}
$clf = new CompanyListFactory();
$clf->getById($company_id);
if ($clf->getRecordCount() > 0) {
$company_obj = $clf->getCurrent();
$country = $company_obj->getCountry();
$province = $company_obj->getProvince();
} else {
Debug::text('bCompany ID: ' . $company_id, __FILE__, __LINE__, __METHOD__, 10);
return FALSE;
}
//Get PayStub Link accounts
$pseallf = new PayStubEntryAccountLinkListFactory();
$pseallf->getByCompanyId($company_id);
if ($pseallf->getRecordCount() > 0) {
$psea_obj = $pseallf->getCurrent();
} else {
Debug::text('cCompany ID: ' . $company_id, __FILE__, __LINE__, __METHOD__, 10);
return FALSE;
}
require_once Environment::getBasePath() . '/classes/payroll_deduction/PayrollDeduction.class.php';
$cdf = new CompanyDeductionFactory();
$cdf->StartTransaction();
/*
10 => 'Percent',
15 => 'Advanced Percent',
20 => 'Fixed Amount',
//Federal
100 => 'Federal Income Tax Formula',
//Province/State
200 => 'Province/State Income Tax Formula',
210 => 'Province/State UI Formula',
*/
Debug::text('Country: ' . $country, __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($country)) {
case 'ca':
$pd_obj = new PayrollDeduction($country, 'BC');
//Pick default province for now.
$pd_obj->setDate(time());
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Federal Income Tax');
$cdf->setCalculation(100);
$cdf->setCalculationOrder(100);
$cdf->setCountry('CA');
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Federal Income%'));
$cdf->setUserValue1($pd_obj->getBasicFederalClaimCodeAmount());
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$exclude_ids = array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Union'));
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
//var_dump($exclude_ids);
$cdf->setExcludePayStubEntryAccount($exclude_ids);
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Additional Income Tax');
$cdf->setCalculation(20);
$cdf->setCalculationOrder(105);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Additional Income Tax%'));
$cdf->setUserValue1(0);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('CPP - Employee');
$cdf->setCalculation(90);
// CPP Formula
$cdf->setCalculationOrder(80);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'CPP'));
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('CPP - Employer');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(85);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, '%CPP - Employer%'));
$cdf->setUserValue1(100);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'CPP')));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('EI - Employee');
$cdf->setCalculation(91);
//EI Formula
$cdf->setCalculationOrder(90);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'EI'));
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('EI - Employer');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(95);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, '%EI - Employer%'));
$cdf->setUserValue1(140);
//2006
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'EI')));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('WCB - Employer');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(95);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, '%WCB%'));
$cdf->setUserValue1(0.0);
//Default
$cdf->setUserValue2(0);
//Annual Wage Base: WCB has this, but can differ between rates/classifications.
$cdf->setUserValue3(0);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(20);
//Deduction
$cdf->setName('Vacation Accrual');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(50);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 50, 'Vacation Accrual'));
$cdf->setUserValue1(4);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
$exclude_ids = array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 10, 'Vacation Accrual Release'), self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 10, 'Vacation Time'));
$cdf->setExcludePayStubEntryAccount($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(20);
//Deduction
$cdf->setName('Vacation Release');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(51);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 10, 'Vacation Accrual Release'));
$cdf->setUserValue1(4);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
$exclude_ids = array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 10, 'Vacation Accrual Release'), self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 10, 'Vacation Time'));
$cdf->setExcludePayStubEntryAccount($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'us':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Federal Income Tax');
$cdf->setCalculation(100);
$cdf->setCalculationOrder(100);
$cdf->setCountry('US');
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Federal Income%'));
$cdf->setUserValue1(10);
//Single
$cdf->setUserValue2(1);
//0 Allowances
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Advance Earned Income Credit (EIC)');
$cdf->setCalculation(80);
$cdf->setCalculationOrder(105);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Advance EIC%'));
$cdf->setUserValue1(10);
//Single
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Federal Unemployment Insurance - Employer');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(80);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'Fed. Unemployment Ins.'));
$cdf->setUserValue1(0.8);
//2009
$cdf->setUserValue2(7000);
$cdf->setUserValue3(0);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Social Security - Employee');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(80);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Social Security (FICA)'));
$cdf->setUserValue1(6.2);
//2009
$cdf->setUserValue2(106800);
$cdf->setUserValue3(0);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Social Security - Employer');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(85);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'Social Security%'));
$cdf->setUserValue1(100);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Social Security (FICA)')));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Medicare - Employee');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(90);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Medicare'));
$cdf->setUserValue1(1.45);
//2009
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('Medicare - Employer');
$cdf->setCalculation(10);
$cdf->setCalculationOrder(95);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'Medicare'));
$cdf->setUserValue1(100);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
//$cdf->setIncludePayStubEntryAccount( array( $psea_obj->getTotalGross() ));
$cdf->setIncludePayStubEntryAccount(array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Medicare')));
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'cr':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(TTi18n::gettext('Income Tax'));
$cdf->setCalculation(100);
$cdf->setCalculationOrder(100);
$cdf->setCountry('CR');
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Federal Income%'));
$cdf->setUserValue1(10);
//Single
$cdf->setUserValue2(0);
//0 Allowances
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
}
$pd_obj = new PayrollDeduction($country, $province);
$pd_obj->setDate(time());
Debug::text('Province/State: ' . $province, __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($province)) {
//Canada
case 'ab':
case 'bc':
case 'sk':
case 'mb':
case 'qc':
case 'on':
case 'nl':
case 'nb':
case 'ns':
case 'pe':
case 'nt':
case 'yt':
case 'nu':
$provincial_claim_amount = $pd_obj->getBasicProvinceClaimCodeAmount();
break;
//US
//US
case 'al':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ak':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance - Employer');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(32700);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance - Employee');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(32700);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ar':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(10000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'az':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Job Training');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Employee Training'));
$cdf->setUserValue1(0.1);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ca':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Disability Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(180);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'State Disability Ins.'));
$cdf->setUserValue1(1.1);
//2009
$cdf->setUserValue2(90669);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Employee Training');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Employee Training'));
$cdf->setUserValue1(0.1);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'co':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(10000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ct':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(15000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'dc':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'de':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(10500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'fl':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ga':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'hi':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(13000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ia':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(23700);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'id':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(33200);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'il':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins. - Employer'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(12300);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'in':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ks':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ky':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'la':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ma':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(14000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'md':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'me':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(12000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'mi':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'mn':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(26000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'mo':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(12500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ms':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'mt':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(25100);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nc':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(19300);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nd':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(23700);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nh':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ne':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nj':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(28900);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(28900);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nm':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(20900);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'nv':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(26600);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ny':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0);
//2009
$cdf->setUserValue2(8500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Reemployment Service Fund');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Reemployment'));
$cdf->setUserValue1(0.075);
//2009
$cdf->setUserValue2(8500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Disability Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(180);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'State Disability Ins.'));
$cdf->setUserValue1(0.5);
//2009
$cdf->setUserValue2(0);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'oh':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ok':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(14200);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'or':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Insurance'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(31300);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'pa':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ri':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Employment Security');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(18000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'sc':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'sd':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(9500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'tn':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(7000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'tx':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0);
//2009
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Employee Training');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Employee Training'));
$cdf->setUserValue1(0.0);
//2006
$cdf->setUserValue2(9000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'ut':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(27800);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'va':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'vt':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'wa':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(37500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'wi':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(12000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'wv':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(8000);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
case 'wy':
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Unemployment Insurance');
$cdf->setCalculation(15);
$cdf->setCalculationOrder(185);
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 30, 'State Unemployment Ins.'));
$cdf->setUserValue1(0.0);
//2009
$cdf->setUserValue2(21500);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
break;
}
if ($country == 'CA') {
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName(strtoupper($province) . ' - Provincial Income Tax');
$cdf->setCalculation(200);
$cdf->setCalculationOrder(110);
$cdf->setCountry('CA');
$cdf->setProvince(strtoupper($province));
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%Provincial Income%'));
$cdf->setUserValue1($provincial_claim_amount);
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$exclude_ids = array(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, 'Union'));
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
$cdf->setExcludePayStubEntryAccount($exclude_ids);
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
} elseif ($country = 'US') {
$cdf = new CompanyDeductionFactory();
$cdf->setCompany($company_id);
$cdf->setStatus(10);
//Enabled
$cdf->setType(10);
//Tax
$cdf->setName('State Income Tax');
$cdf->setCalculation(200);
$cdf->setCalculationOrder(200);
$cdf->setCountry('US');
$cdf->setProvince(strtoupper($province));
$cdf->setPayStubEntryAccount(self::getPayStubEntryAccountByCompanyIDAndTypeAndFuzzyName($company_id, 20, '%State Income%'));
$cdf->setUserValue1(10);
//Single
$cdf->setUserValue2(1);
//0 Allowances
if ($cdf->isValid()) {
$cdf->Save(FALSE);
$cdf->setIncludePayStubEntryAccount(array($psea_obj->getTotalGross()));
unset($exclude_ids);
if ($cdf->isValid()) {
$cdf->Save();
}
}
}
$cdf->CommitTransaction();
//$cdf->FailTransaction();
return TRUE;
}
if (!is_array($import_arr)) {
echo "Parsing CSV file failed!\n";
} else {
echo "Importing Users...\n";
$uf = new UserFactory();
$uf->StartTransaction();
$commit_trans = TRUE;
$i = 1;
$e = 0;
foreach ($import_arr as $tmp_import_arr) {
$mapped_row = Misc::importApplyColumnMap($filtered_import_map, $tmp_import_arr);
if ($i == 1 and $mapped_row['company_id'] > 0) {
$clf = new CompanyListFactory();
$clf->getById($mapped_row['company_id']);
if ($clf->getRecordCount() > 0) {
echo 'Company: ' . $clf->getCurrent()->getName() . "\n";
ob_flush();
flush();
sleep(2);
}
unset($clf);
}
$uf = new UserFactory();
//Start with user default values.
$udlf = new UserDefaultListFactory();
$udlf->getByCompanyId($mapped_row['company_id']);
if ($udlf->getRecordCount() > 0) {
Debug::Text('Using User Defaults', __FILE__, __LINE__, __METHOD__, 10);
$udf_obj = $udlf->getCurrent();
$uf->setTitle($udf_obj->getTitle());
$uf->setCity($udf_obj->getCity());
function generateData()
{
global $current_company, $current_user;
TTDate::setTimeZone('PST8PDT');
$current_epoch = time();
$cf = new CompanyFactory();
$cf->StartTransaction();
$company_id = $this->createCompany();
$clf = new CompanyListFactory();
$clf->getById($company_id);
$current_company = $clf->getCurrent();
if ($company_id !== FALSE) {
Debug::Text('Company Created Successfully!', __FILE__, __LINE__, __METHOD__, 10);
$this->createPermissionGroups($company_id);
//Create currency
$currency_ids[] = $this->createCurrency($company_id, 10);
//USD
$currency_ids[] = $this->createCurrency($company_id, 20);
//CAD
//Create branch
$branch_ids[] = $this->createBranch($company_id, 10);
//NY
$branch_ids[] = $this->createBranch($company_id, 20);
//WA
//Create departments
$department_ids[] = $this->createDepartment($company_id, 10);
$department_ids[] = $this->createDepartment($company_id, 20);
//Create stations
$station_id = $this->createStation($company_id);
//Create pay stub accounts.
$this->createPayStubAccount($company_id);
//Link pay stub accounts.
$this->createPayStubAccountLink($company_id);
//Company Deductions
$this->createCompanyDeduction($company_id);
//Wage Groups
$wage_group_ids[] = $this->createUserWageGroups($company_id);
//User Groups
$user_group_ids[] = $this->createUserGroup($company_id, 10, 0);
$user_group_ids[] = $this->createUserGroup($company_id, 20, $user_group_ids[0]);
$user_group_ids[] = $this->createUserGroup($company_id, 30, $user_group_ids[0]);
$user_group_ids[] = $this->createUserGroup($company_id, 40, 0);
$user_group_ids[] = $this->createUserGroup($company_id, 50, $user_group_ids[3]);
//Users
$user_ids[] = $this->createUser($company_id, 10, 0, $branch_ids[0], $department_ids[0], $currency_ids[0], $user_group_ids[0]);
$user_ids[] = $this->createUser($company_id, 11, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[0]);
$user_ids[] = $this->createUser($company_id, 12, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[0]);
$user_ids[] = $this->createUser($company_id, 13, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[0]);
$user_ids[] = $this->createUser($company_id, 14, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[1]);
$user_ids[] = $this->createUser($company_id, 15, 0, $branch_ids[0], $department_ids[0], $currency_ids[0], $user_group_ids[1]);
$user_ids[] = $this->createUser($company_id, 16, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[1]);
$user_ids[] = $this->createUser($company_id, 17, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[1]);
$user_ids[] = $this->createUser($company_id, 18, 0, $branch_ids[0], $department_ids[0], $currency_ids[0], $user_group_ids[2]);
$user_ids[] = $this->createUser($company_id, 19, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[2]);
$user_ids[] = $this->createUser($company_id, 20, 0, $branch_ids[0], $department_ids[1], $currency_ids[0], $user_group_ids[2]);
$user_ids[] = $this->createUser($company_id, 21, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[3]);
$user_ids[] = $this->createUser($company_id, 22, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[3]);
$user_ids[] = $this->createUser($company_id, 23, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[3]);
$user_ids[] = $this->createUser($company_id, 24, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[3]);
$user_ids[] = $this->createUser($company_id, 25, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 26, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 27, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 28, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 29, 0, $branch_ids[1], $department_ids[1], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 30, 0, $branch_ids[1], $department_ids[0], $currency_ids[0], $user_group_ids[4]);
$user_ids[] = $this->createUser($company_id, 40, 0, $branch_ids[1], $department_ids[0], $currency_ids[0], $user_group_ids[4]);
$current_user_id = $user_ids[] = $this->createUser($company_id, 100, 0, $branch_ids[0], $department_ids[0], $currency_ids[0], $user_group_ids[1]);
//Create random users.
for ($i = 0; $i <= $this->getMaxRandomUsers(); $i++) {
$tmp_user_id = $this->createUser($company_id, 999, 0, $branch_ids[$i % 2], $department_ids[$i % 2], $currency_ids[0], $user_group_ids[$i % 5]);
if ($tmp_user_id != FALSE) {
$user_ids[] = $tmp_user_id;
}
}
Debug::Arr($user_ids, 'All User IDs:', __FILE__, __LINE__, __METHOD__, 10);
$ulf = new UserListFactory();
$ulf->getById($current_user_id);
$current_user = $ulf->getCurrent();
unset($current_user_id);
//Create policies
$policy_ids['round'][] = $this->createRoundingPolicy($company_id, 10);
//In
$policy_ids['round'][] = $this->createRoundingPolicy($company_id, 20);
//Out
$policy_ids['accrual'][] = $this->createAccrualPolicy($company_id, 10);
//Bank Time
$policy_ids['accrual'][] = $this->createAccrualPolicy($company_id, 20);
//Vacaction
$policy_ids['accrual'][] = $this->createAccrualPolicy($company_id, 30);
//Sick
$policy_ids['overtime'][] = $this->createOverTimePolicy($company_id, 10);
$policy_ids['overtime'][] = $this->createOverTimePolicy($company_id, 20, $policy_ids['accrual'][0]);
$policy_ids['premium'][] = $this->createPremiumPolicy($company_id, 10);
$policy_ids['absence'][] = $this->createAbsencePolicy($company_id, 10, $policy_ids['accrual'][1]);
$policy_ids['absence'][] = $this->createAbsencePolicy($company_id, 20, $policy_ids['accrual'][0]);
$policy_ids['absence'][] = $this->createAbsencePolicy($company_id, 30, $policy_ids['accrual'][2]);
$policy_ids['meal_1'] = $this->createMealPolicy($company_id);
$policy_ids['schedule_1'] = $this->createSchedulePolicy($company_id, $policy_ids['meal_1']);
$policy_ids['exception_1'] = $this->createExceptionPolicy($company_id);
$hierarchy_user_ids = $user_ids;
$root_user_id = array_pop($hierarchy_user_ids);
unset($hierarchy_user_ids[0], $hierarchy_user_ids[1]);
//Create authorization hierarchy
$hierarchy_control_id = $this->createAuthorizationHierarchyControl($company_id, $hierarchy_user_ids);
if ($root_user_id == FALSE) {
Debug::Text('Administrator wasn\'t created! Duplicate username perhaps? Are we appending a random number?', __FILE__, __LINE__, __METHOD__, 10);
}
//Admin user at the top
$this->createAuthorizationHierarchyLevel($company_id, $hierarchy_control_id, $root_user_id, 1);
$this->createAuthorizationHierarchyLevel($company_id, $hierarchy_control_id, $user_ids[0], 2);
$this->createAuthorizationHierarchyLevel($company_id, $hierarchy_control_id, $user_ids[1], 3);
unset($hierarchy_user_ids, $root_user_id);
//Pay Period Schedule
$this->createPayPeriodSchedule($company_id, $user_ids);
//Create Policy Group
$this->createPolicyGroup($company_id, $policy_ids['meal_1'], $policy_ids['exception_1'], NULL, $policy_ids['overtime'], $policy_ids['premium'], $policy_ids['round'], $user_ids);
if (getTTProductEdition() == TT_PRODUCT_PROFESSIONAL) {
//Task Groups
$task_group_ids[] = $this->createTaskGroup($company_id, 10, 0);
$task_group_ids[] = $this->createTaskGroup($company_id, 20, $task_group_ids[0]);
$task_group_ids[] = $this->createTaskGroup($company_id, 30, $task_group_ids[0]);
$task_group_ids[] = $this->createTaskGroup($company_id, 40, 0);
$task_group_ids[] = $this->createTaskGroup($company_id, 50, $task_group_ids[3]);
$task_group_ids[] = $this->createTaskGroup($company_id, 60, $task_group_ids[3]);
//Job Tasks
$default_task_id = $this->createTask($company_id, 10, $task_group_ids[2]);
$task_ids[] = $this->createTask($company_id, 20, $task_group_ids[1]);
$task_ids[] = $this->createTask($company_id, 30, $task_group_ids[1]);
$task_ids[] = $this->createTask($company_id, 40, $task_group_ids[2]);
$task_ids[] = $this->createTask($company_id, 50, $task_group_ids[4]);
$task_ids[] = $this->createTask($company_id, 60, $task_group_ids[4]);
$task_ids[] = $this->createTask($company_id, 70, $task_group_ids[5]);
//Job Groups
$job_group_ids[] = $this->createJobGroup($company_id, 10, 0);
$job_group_ids[] = $this->createJobGroup($company_id, 20, $job_group_ids[0]);
$job_group_ids[] = $this->createJobGroup($company_id, 30, $job_group_ids[0]);
$job_group_ids[] = $this->createJobGroup($company_id, 40, 0);
$job_group_ids[] = $this->createJobGroup($company_id, 50, $job_group_ids[3]);
$job_group_ids[] = $this->createJobGroup($company_id, 60, $job_group_ids[3]);
//Jobs
$job_ids[] = $this->createJob($company_id, 10, $default_task_id, $job_group_ids[1], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 11, $default_task_id, $job_group_ids[1], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 12, $default_task_id, $job_group_ids[1], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 13, $default_task_id, $job_group_ids[1], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 14, $default_task_id, $job_group_ids[1], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 15, $default_task_id, $job_group_ids[2], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 16, $default_task_id, $job_group_ids[2], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 17, $default_task_id, $job_group_ids[2], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 18, $default_task_id, $job_group_ids[2], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 19, $default_task_id, $job_group_ids[2], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 20, $default_task_id, $job_group_ids[4], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 21, $default_task_id, $job_group_ids[4], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 22, $default_task_id, $job_group_ids[4], $branch_ids[0], $department_ids[0]);
$job_ids[] = $this->createJob($company_id, 23, $default_task_id, $job_group_ids[5], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 24, $default_task_id, $job_group_ids[5], $branch_ids[1], $department_ids[1]);
$job_ids[] = $this->createJob($company_id, 25, $default_task_id, $job_group_ids[5], $branch_ids[1], $department_ids[1]);
} else {
$task_ids[] = 0;
$job_ids[] = 0;
}
//Create Accrual balances
foreach ($user_ids as $user_id) {
foreach ($policy_ids['accrual'] as $accrual_policy_id) {
$this->createAccrualBalance($user_id, $accrual_policy_id);
}
unset($accrual_policy_id);
}
//Create recurring schedule templates
$recurring_schedule_ids[] = $this->createRecurringScheduleTemplate($company_id, 10, $policy_ids['schedule_1']);
//Morning shift
$recurring_schedule_ids[] = $this->createRecurringScheduleTemplate($company_id, 20, $policy_ids['schedule_1']);
//Afternoon shift
$recurring_schedule_ids[] = $this->createRecurringScheduleTemplate($company_id, 30, $policy_ids['schedule_1']);
//Evening shift
$recurring_schedule_ids[] = $this->createRecurringScheduleTemplate($company_id, 40);
//Split Shift
$recurring_schedule_ids[] = $this->createRecurringScheduleTemplate($company_id, 50, $policy_ids['schedule_1']);
//Full rotation
$recurring_schedule_start_date = TTDate::getBeginWeekEpoch($current_epoch + 86400 * 7.5);
$this->createRecurringSchedule($company_id, $recurring_schedule_ids[0], $recurring_schedule_start_date, '', array($user_ids[0], $user_ids[1], $user_ids[2], $user_ids[3], $user_ids[4]));
$this->createRecurringSchedule($company_id, $recurring_schedule_ids[1], $recurring_schedule_start_date, '', array($user_ids[5], $user_ids[6], $user_ids[7], $user_ids[8], $user_ids[9]));
$this->createRecurringSchedule($company_id, $recurring_schedule_ids[2], $recurring_schedule_start_date, '', array($user_ids[10], $user_ids[11], $user_ids[12], $user_ids[13], $user_ids[14]));
//Create schedule for each employee.
foreach ($user_ids as $user_id) {
//Create schedule starting 6 weeks ago, up to the end of the week.
$schedule_options_arr = array('status_id' => 10, 'start_time' => '08:00AM', 'end_time' => '05:00PM', 'schedule_policy_id' => $policy_ids['schedule_1']);
//$schedule_date = ($current_epoch-(86400*42));
$schedule_date = $current_epoch - 86400 * 14;
$schedule_end_date = TTDate::getEndWeekEpoch($current_epoch);
//$schedule_date = ($current_epoch-(86400*14));
//$schedule_end_date = ($current_epoch+(86400*28));
while ($schedule_date <= $schedule_end_date) {
//Random departments/branches
$schedule_options_arr['branch_id'] = $branch_ids[rand(0, count($branch_ids) - 1)];
$schedule_options_arr['department_id'] = $department_ids[rand(0, count($department_ids) - 1)];
//Skip weekends.
if (date('w', $schedule_date) != 0 and date('w', $schedule_date) != 6) {
$this->createSchedule($user_id, $schedule_date, $schedule_options_arr);
}
$schedule_date += 86400;
}
//break;
unset($schedule_options_arr, $schedule_date, $schedule_end_date, $user_id);
}
//Punch users in/out randomly.
foreach ($user_ids as $user_id) {
//Pick random jobs/tasks that are used for the entire date range.
//So one employee isn't punching into 15 jobs.
$user_random_job_ids = array_rand($job_ids, 2);
$user_random_task_ids = array_rand($job_ids, 3);
//Create punches starting 6 weeks ago, up to the end of the week.
//$start_date = $punch_date = ($current_epoch-(86400*42));
$start_date = $punch_date = $current_epoch - 86400 * 14;
$end_date = TTDate::getEndWeekEpoch($current_epoch);
//$start_date = $punch_date = ($current_epoch-(86400*14));
//$end_date = ($current_epoch+(86400*28));
$i = 0;
while ($punch_date <= $end_date) {
$date_stamp = TTDate::getDate('DATE', $punch_date);
//$punch_full_time_stamp = strtotime($pc_data['date_stamp'].' '.$pc_data['time_stamp']);
$exception_cutoff_date = $current_epoch - 86400 * 14;
if (date('w', $punch_date) != 0 and date('w', $punch_date) != 6) {
if ($punch_date >= $exception_cutoff_date and $i % 4 == 0) {
$first_punch_in = rand(7, 8) . ':' . str_pad(rand(0, 30), 2, '0', STR_PAD_LEFT) . 'AM';
$last_punch_out = strtotime($date_stamp . ' ' . rand(4, 5) . ':' . str_pad(rand(0, 30), 2, '0', STR_PAD_LEFT) . 'PM');
if ($punch_date >= $exception_cutoff_date and rand(0, 20) == 0) {
//Create request
$this->createRequest(20, $user_id, $date_stamp);
}
if ($punch_date >= $exception_cutoff_date and rand(0, 16) == 0) {
//Create request
$this->createRequest(20, $user_id, $date_stamp);
}
} else {
$first_punch_in = '08:00AM';
if ($punch_date >= $exception_cutoff_date and $i % 10 == 0) {
//Don't punch out to generate exception.
$last_punch_out = NULL;
//Forgot to punch out request
$this->createRequest(30, $user_id, $date_stamp);
} else {
$last_punch_out = strtotime($date_stamp . ' 5:00PM');
}
}
//Weekdays
$this->createPunchPair($user_id, strtotime($date_stamp . ' ' . $first_punch_in), strtotime($date_stamp . ' 11:00AM'), array('in_type_id' => 10, 'out_type_id' => 10, 'branch_id' => $branch_ids[rand(0, count($branch_ids) - 1)], 'department_id' => $department_ids[rand(0, count($department_ids) - 1)], 'job_id' => $job_ids[array_rand($user_random_job_ids)], 'job_item_id' => $task_ids[array_rand($user_random_task_ids)]), TRUE);
$this->createPunchPair($user_id, strtotime($date_stamp . ' 11:00AM'), strtotime($date_stamp . ' 1:00PM'), array('in_type_id' => 10, 'out_type_id' => 20, 'branch_id' => $branch_ids[rand(0, count($branch_ids) - 1)], 'department_id' => $department_ids[rand(0, count($department_ids) - 1)], 'job_id' => $job_ids[array_rand($user_random_job_ids)], 'job_item_id' => $task_ids[array_rand($user_random_task_ids)]), TRUE);
//Calc total time on last punch pair only.
$this->createPunchPair($user_id, strtotime($date_stamp . ' 2:00PM'), $last_punch_out, array('in_type_id' => 20, 'out_type_id' => 10, 'branch_id' => $branch_ids[rand(0, count($branch_ids) - 1)], 'department_id' => $department_ids[rand(0, count($department_ids) - 1)], 'job_id' => $job_ids[array_rand($user_random_job_ids)], 'job_item_id' => $task_ids[array_rand($user_random_task_ids)]), TRUE);
} elseif ($punch_date > $exception_cutoff_date and date('w', $punch_date) == 6 and $i % 10 == 0) {
//Sat.
$this->createPunchPair($user_id, strtotime($date_stamp . ' 10:00AM'), strtotime($date_stamp . ' 2:30PM'), array('in_type_id' => 10, 'out_type_id' => 10, 'branch_id' => $branch_ids[rand(0, count($branch_ids) - 1)], 'department_id' => $department_ids[rand(0, count($department_ids) - 1)], 'job_id' => $job_ids[array_rand($user_random_job_ids)], 'job_item_id' => $task_ids[array_rand($user_random_task_ids)]), TRUE);
}
//Recalculate entire day. Performance optimization.
//UserDateTotalFactory::reCalculateRange( $user_id, $start_date, $end_date );
$punch_date += 86400;
$i++;
}
unset($punch_options_arr, $punch_date, $user_id);
}
//Generate pay stubs for each pay period
$pplf = new PayPeriodListFactory();
$pplf->getByCompanyId($company_id);
if ($pplf->getRecordCount() > 0) {
foreach ($pplf as $pp_obj) {
foreach ($user_ids as $user_id) {
$cps = new CalculatePayStub();
$cps->setUser($user_id);
$cps->setPayPeriod($pp_obj->getId());
$cps->calculate();
}
}
}
unset($pplf, $pp_obj, $user_id);
}
//$cf->FailTransaction();
$cf->CommitTransaction();
return FALSE;
}
function checkCompanyStatus($user_name)
{
$ulf = new UserListFactory();
$ulf->getByUserName(strtolower($user_name));
if ($ulf->getRecordCount() == 1) {
$u_obj = $ulf->getCurrent();
if (is_object($u_obj)) {
$clf = new CompanyListFactory();
$clf->getById($u_obj->getCompany());
if ($clf->getRecordCount() == 1) {
if ($clf->getCurrent()->getStatus() == 10) {
return TRUE;
}
}
}
}
return FALSE;
}
$sslf->getByName('license');
if ($sslf->getRecordCount() == 1) {
$obj = $sslf->getCurrent();
} else {
$obj = new SystemSettingListFactory();
}
$obj->setName('license');
$obj->setValue($license_data);
if ($obj->isValid()) {
Debug::text('Setting License Data...', __FILE__, __LINE__, __METHOD__, 9);
$obj->Save();
//Save company name from license file.
$clf = new CompanyListFactory();
$clf->getById($license->getPrimaryCompanyID());
if ($clf->getRecordCount() > 0) {
$c_obj = $clf->getCurrent();
} else {
$c_obj = $current_company;
}
$c_obj->setName($license->getOrganizationName(), TRUE);
if ($c_obj->isValid()) {
$c_obj->Save();
}
//Save registration key
$sslf = new SystemSettingListFactory();
$sslf->getByName('registration_key');
if ($sslf->getRecordCount() == 1) {
$obj = $sslf->getCurrent();
} else {
$obj = new SystemSettingListFactory();
}
static function addPresets($company_id)
{
if ($company_id == '') {
return FALSE;
}
$clf = new CompanyListFactory();
$clf->getById($company_id);
if ($clf->getRecordCount() > 0) {
$company_obj = $clf->getCurrent();
$country = $company_obj->getCountry();
$province = $company_obj->getProvince();
} else {
return FALSE;
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->StartTransaction();
/*
10 => 'Earning',
20 => 'Employee Deduction',
30 => 'Employer Deduction',
40 => 'Total',
50 => 'Accrual',
60 => 'Advance Earning',
65 => 'Advance Deduction',
*/
//See if accounts are already linked
$pseallf = new PayStubEntryAccountLinkListFactory();
$pseallf->getByCompanyId($company_id);
if ($pseallf->getRecordCount() > 0) {
$psealf = $pseallf->getCurrent();
} else {
$psealf = new PayStubEntryAccountLinkFactory();
$psealf->setCompany($company_id);
}
Debug::text('Country: ' . $country, __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($country)) {
case 'ca':
Debug::text('Saving.... Federal Taxes', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Federal Income Tax');
$pseaf->setOrder(210);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Provincial Income Tax');
$pseaf->setOrder(220);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Additional Income Tax');
$pseaf->setOrder(230);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('CPP');
$pseaf->setOrder(240);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setEmployeeCPP($psea_id);
unset($psea_id);
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('EI');
$pseaf->setOrder(250);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setEmployeeEI($psea_id);
unset($psea_id);
}
//Employer Contributions
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('CPP - Employer');
$pseaf->setOrder(300);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('EI - Employer');
$pseaf->setOrder(310);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('WCB - Employer');
$pseaf->setOrder(320);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Vacation Accrual', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(50);
$pseaf->setName('Vacation Accrual');
$pseaf->setOrder(400);
if ($pseaf->isValid()) {
$vacation_accrual_id = $pseaf->Save();
Debug::text('Saving.... Earnings - Vacation Accrual Release', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Vacation Accrual Release');
$pseaf->setOrder(180);
$pseaf->setAccrual($vacation_accrual_id);
if ($pseaf->isValid()) {
$pseaf->Save();
}
unset($vaction_accrual_id);
}
break;
case 'us':
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Federal Income Tax');
$pseaf->setOrder(210);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Advance EIC');
$pseaf->setOrder(215);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('State Income Tax');
$pseaf->setOrder(220);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('District Income Tax');
$pseaf->setOrder(225);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Federal Add. Income Tax');
$pseaf->setOrder(230);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('State Add. Income Tax');
$pseaf->setOrder(235);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Social Security (FICA)');
$pseaf->setOrder(240);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('Social Security (FICA)');
$pseaf->setOrder(340);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('Fed. Unemployment Ins.');
$pseaf->setOrder(342);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('State Unemployment Ins.');
$pseaf->setOrder(240);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Medicare');
$pseaf->setOrder(245);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('Medicare');
$pseaf->setOrder(346);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('State Disability Ins.');
$pseaf->setOrder(250);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('State Unemployment Ins.');
$pseaf->setOrder(350);
if ($pseaf->isValid()) {
$pseaf->Save();
}
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('State Employee Training');
$pseaf->setOrder(352);
if ($pseaf->isValid()) {
$pseaf->Save();
}
break;
}
Debug::text('Province: ' . $province, __FILE__, __LINE__, __METHOD__, 10);
switch (strtolower($province)) {
case 'ny':
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('State Reemployment');
$pseaf->setOrder(354);
if ($pseaf->isValid()) {
$pseaf->Save();
}
break;
}
Debug::text('Saving.... Earnings - Regular Time', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Regular Time');
$pseaf->setOrder(100);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setRegularTime($psea_id);
unset($psea_id);
}
Debug::text('Saving.... Earnings - Over Time 1', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Over Time 1');
$pseaf->setOrder(150);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Earnings - Over Time 2', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Over Time 2');
$pseaf->setOrder(151);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Earnings - Premium Time 1', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Premium 1');
$pseaf->setOrder(170);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Earnings - Premium Time 2', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Premium 2');
$pseaf->setOrder(171);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Earnings - Bonus', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Bonus');
$pseaf->setOrder(185);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Earnings - Other', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(10);
$pseaf->setName('Other');
$pseaf->setOrder(189);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Union Dues', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Union Dues');
$pseaf->setOrder(285);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Employee Benefits Plan', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(20);
$pseaf->setName('Benefits Plan');
$pseaf->setOrder(225);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Employer Benefits Plan', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(30);
$pseaf->setName('Benefits Plan');
$pseaf->setOrder(330);
if ($pseaf->isValid()) {
$pseaf->Save();
}
Debug::text('Saving.... Total Earnings', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(40);
$pseaf->setName('Total Gross');
$pseaf->setOrder(199);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setTotalGross($psea_id);
unset($psea_id);
}
Debug::text('Saving.... Total Deductions', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(40);
$pseaf->setName('Total Deductions');
$pseaf->setOrder(298);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setTotalEmployeeDeduction($psea_id);
unset($psea_id);
}
Debug::text('Saving.... Net Pay', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(40);
$pseaf->setName('Net Pay');
$pseaf->setOrder(299);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setTotalNetPay($psea_id);
unset($psea_id);
}
Debug::text('Saving.... Employer Total Cont', __FILE__, __LINE__, __METHOD__, 10);
$pseaf = new PayStubEntryAccountFactory();
$pseaf->setCompany($company_id);
$pseaf->setStatus(10);
$pseaf->setType(40);
$pseaf->setName('Employer Total Contributions');
$pseaf->setOrder(399);
if ($pseaf->isValid()) {
$psea_id = $pseaf->Save();
$psealf->setTotalEmployerDeduction($psea_id);
unset($psea_id);
}
if ($psealf->isValid() == TRUE) {
Debug::text('Saving.... PSA Linking', __FILE__, __LINE__, __METHOD__, 10);
$psealf->Save();
} else {
Debug::text('Saving.... PSA Linking FAILED!', __FILE__, __LINE__, __METHOD__, 10);
}
$pseaf->CommitTransaction();
//$pseaf->FailTransaction();
return TRUE;
}
/**
* Get about data .
*
*/
function getAboutData($ytd = 0, $all_companies = FALSE)
{
global $config_vars;
$clf = new CompanyListFactory();
$sslf = new SystemSettingListFactory();
$system_settings = $sslf->getAllArray();
$clf->getByID(PRIMARY_COMPANY_ID);
if ($clf->getRecordCount() == 1) {
$primary_company = $clf->getCurrent();
}
$current_user = $this->getCurrentUserObject();
if (isset($primary_company) and PRIMARY_COMPANY_ID == $current_user->getCompany()) {
$current_company = $primary_company;
} else {
$current_company = $clf->getByID($current_user->getCompany())->getCurrent();
}
//$current_user_prefs = $current_user->getUserPreferenceObject();
$data = $system_settings;
if (isset($data['new_version']) and $data['new_version'] == TRUE) {
$data['new_version'] = TRUE;
} else {
$data['new_version'] = FALSE;
}
$data['product_edition'] = Option::getByKey(DEPLOYMENT_ON_DEMAND == TRUE ? $current_company->getProductEdition() : getTTProductEdition(), $current_company->getOptions('product_edition'));
$data['application_name'] = APPLICATION_NAME;
$data['organization_url'] = ORGANIZATION_URL;
//Get Employee counts for this month, and last month
$month_of_year_arr = TTDate::getMonthOfYearArray();
//This month
if (isset($ytd) and $ytd == 1) {
$begin_month_epoch = strtotime('-2 years');
} else {
$begin_month_epoch = TTDate::getBeginMonthEpoch(TTDate::getBeginMonthEpoch(time()) - 86400);
}
$cuclf = TTnew('CompanyUserCountListFactory');
if (isset($config_vars['other']['primary_company_id']) and $current_company->getId() == $config_vars['other']['primary_company_id'] and $all_companies == TRUE) {
$cuclf->getTotalMonthlyMinAvgMaxByCompanyStatusAndStartDateAndEndDate(10, $begin_month_epoch, TTDate::getEndMonthEpoch(time()), NULL, NULL, NULL, array('date_stamp' => 'desc'));
} else {
$cuclf->getMonthlyMinAvgMaxByCompanyIdAndStartDateAndEndDate($current_company->getId(), $begin_month_epoch, TTDate::getEndMonthEpoch(time()), NULL, NULL, NULL, array('date_stamp' => 'desc'));
}
Debug::Text('Company User Count Rows: ' . $cuclf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($cuclf->getRecordCount() > 0) {
foreach ($cuclf as $cuc_obj) {
$data['user_counts'][] = array('label' => $month_of_year_arr[TTDate::getMonth(TTDate::strtotime($cuc_obj->getColumn('date_stamp')))] . ' ' . TTDate::getYear(TTDate::strtotime($cuc_obj->getColumn('date_stamp'))), 'max_active_users' => $cuc_obj->getColumn('max_active_users'), 'max_inactive_users' => $cuc_obj->getColumn('max_inactive_users'), 'max_deleted_users' => $cuc_obj->getColumn('max_deleted_users'));
}
}
if (isset($data['user_counts']) == FALSE) {
$data['user_counts'] = array();
}
$cjlf = TTnew('CronJobListFactory');
$cjlf->getMostRecentlyRun();
if ($cjlf->getRecordCount() > 0) {
$cj_obj = $cjlf->getCurrent();
$data['cron'] = array('last_run_date' => $cj_obj->getLastRunDate() == FALSE ? TTi18n::getText('Never') : TTDate::getDate('DATE+TIME', $cj_obj->getLastRunDate()));
}
$data['show_license_data'] = FALSE;
if ((DEPLOYMENT_ON_DEMAND == FALSE and $current_company->getId() == 1 or isset($config_vars['other']['primary_company_id']) and $current_company->getId() == $config_vars['other']['primary_company_id']) and getTTProductEdition() > 10) {
if (!isset($system_settings['license'])) {
$system_settings['license'] = NULL;
}
$data['show_license_data'] = TRUE;
//Set this so the license upload area at least shows up regardles of edition.
$data['license_data'] = array();
$license = new TTLicense();
$retval = $license->validateLicense($system_settings['license']);
if ($retval == TRUE) {
$data['license_data'] = array('organization_name' => $license->getOrganizationName(), 'major_version' => $license->getMajorVersion(), 'minor_version' => $license->getMinorVersion(), 'product_name' => $license->getProductName(), 'active_employee_licenses' => $license->getActiveEmployeeLicenses(), 'issue_date' => TTDate::getDate('DATE', $license->getIssueDate()), 'expire_date' => $license->getExpireDate(), 'expire_date_display' => TTDate::getDate('DATE', $license->getExpireDate()), 'registration_key' => $license->getRegistrationKey(), 'message' => $license->getFullErrorMessage($retval), 'retval' => $retval);
}
}
//Debug::Arr($data, 'Data: ', __FILE__, __LINE__, __METHOD__,10);
return $this->returnHandler($data);
}
//Do not overwrite a previously sent content-type header, this breaks WAP.
if (!isset($enable_wap)) {
header('Content-Type: text/html; charset=UTF-8');
}
//Skip this step if disable_database_connection is enabled or the user is going through the installer still
$clf = new CompanyListFactory();
if ((!isset($disable_database_connection) or isset($disable_database_connection) and $disable_database_connection != TRUE) and (!isset($config_vars['other']['installer_enabled']) or isset($config_vars['other']['installer_enabled']) and $config_vars['other']['installer_enabled'] != TRUE)) {
//Get all system settings, so they can be used even if the user isn't logged in, such as the login page.
try {
$sslf = new SystemSettingListFactory();
$system_settings = $sslf->getAllArray();
unset($sslf);
//Get primary company data needs to be used when user isn't logged in as well.
$clf->getByID(PRIMARY_COMPANY_ID);
if ($clf->getRecordCount() == 1) {
$primary_company = $clf->getCurrent();
}
} catch (Exception $e) {
//Database not initialized, or some error, redirect to Install page.
throw new DBError($e, 'DBInitialize');
}
}
$permission = new Permission();
$authentication = new Authentication();
if (isset($authenticate) and $authenticate === FALSE) {
Debug::text('Bypassing Authentication', __FILE__, __LINE__, __METHOD__, 10);
TTi18n::chooseBestLocale();
} else {
//Increase timeout on WAP devices, so they don't have to login as often.
if (isset($enable_wap) and $enable_wap == TRUE) {
$authentication->setIdle(32400);
