function getByCompanyId($company_id, $where = NULL, $order = NULL)
{
if ($company_id == '') {
return FALSE;
}
$udf = new UserDefaultFactory();
$ph = array('company_id' => $company_id);
$query = '
select a.*
from ' . $this->getTable() . ' as a
LEFT JOIN ' . $udf->getTable() . ' as udf ON a.user_default_id = udf.id
where udf.company_id = ?
AND ( udf.deleted = 0 )';
$query .= $this->getWhereSQL($where);
$query .= $this->getSortSQL($order);
$this->ExecuteSQL($query, $ph);
return $this;
}
function postSave()
{
if ($this->getDeleted() == TRUE) {
Debug::Text('UnAssign title from employees: ' . $this->getId(), __FILE__, __LINE__, __METHOD__, 10);
//Unassign hours from this job.
$uf = new UserFactory();
$udf = new UserDefaultFactory();
$query = 'update ' . $uf->getTable() . ' set title_id = 0 where company_id = ' . $this->getCompany() . ' AND title_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $udf->getTable() . ' set title_id = 0 where company_id = ' . $this->getCompany() . ' AND title_id = ' . $this->getId();
$this->db->Execute($query);
}
}
function postSave()
{
if ($this->getDeleted() == TRUE) {
Debug::Text('UnAssign Policy Group from User Defaults...' . $this->getId(), __FILE__, __LINE__, __METHOD__, 10);
$udf = new UserDefaultFactory();
$query = 'update ' . $udf->getTable() . ' set policy_group_id = 0 where company_id = ' . $this->getCompany() . ' AND policy_group_id = ' . $this->getId();
$this->db->Execute($query);
}
return TRUE;
}
function postSave()
{
$this->removeCache($this->getId());
if ($this->getDeleted() == TRUE) {
Debug::Text('UnAssign Hours from Branch: ' . $this->getId(), __FILE__, __LINE__, __METHOD__, 10);
//Unassign hours from this branch.
$pcf = new PunchControlFactory();
$udtf = new UserDateTotalFactory();
$uf = new UserFactory();
$sf = new StationFactory();
$sf_b = new ScheduleFactory();
$udf = new UserDefaultFactory();
$rstf = new RecurringScheduleTemplateFactory();
$query = 'update ' . $pcf->getTable() . ' set branch_id = 0 where branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $udtf->getTable() . ' set branch_id = 0 where branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $sf_b->getTable() . ' set branch_id = 0 where branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $uf->getTable() . ' set default_branch_id = 0 where company_id = ' . $this->getCompany() . ' AND default_branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $udf->getTable() . ' set default_branch_id = 0 where company_id = ' . $this->getCompany() . ' AND default_branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $sf->getTable() . ' set branch_id = 0 where company_id = ' . $this->getCompany() . ' AND branch_id = ' . $this->getId();
$this->db->Execute($query);
$query = 'update ' . $rstf->getTable() . ' set branch_id = 0 where branch_id = ' . $this->getId();
$this->db->Execute($query);
}
return TRUE;
}
}
$smarty->assign('title', TTi18n::gettext($title = 'New Hire Defaults'));
// See index.php
/*
* Get FORM variables
*/
extract(FormVariables::GetVariables(array('action', 'id', 'user_data', 'data_saved')));
if (isset($user_data)) {
if (isset($user_data['hire_date']) and $user_data['hire_date'] != '') {
$user_data['hire_date'] = TTDate::parseDateTime($user_data['hire_date']);
}
}
$uf = new UserFactory();
$upf = new UserPreferenceFactory();
$udlf = new UserDefaultListFactory();
$udf = new UserDefaultFactory();
$action = Misc::findSubmitButton();
switch ($action) {
case 'submit':
Debug::Text('Submit!', __FILE__, __LINE__, __METHOD__, 10);
//Debug::setVerbosity(11);
if (isset($user_data['id']) and $user_data['id'] != '') {
$udf->setId($user_data['id']);
}
$udf->setCompany($current_company->getId());
$udf->setTitle($user_data['title_id']);
$udf->setCity($user_data['city']);
$udf->setCountry($user_data['country']);
$udf->setProvince($user_data['province']);
$udf->setWorkPhone($user_data['work_phone']);
$udf->setWorkPhoneExt($user_data['work_phone_ext']);
