function createRecurringScheduleTemplate($company_id, $type, $schedule_policy_id = NULL) { $rstcf = new RecurringScheduleTemplateControlFactory(); $rstcf->setCompany($company_id); switch ($type) { case 10: //Morning Shift $rstcf->setName('Morning Shift'); $rstcf->setDescription('6:00AM - 3:00PM'); if ($rstcf->isValid()) { $rstc_id = $rstcf->Save(); Debug::Text('bRecurring Schedule Template Control ID: ' . $rstc_id, __FILE__, __LINE__, __METHOD__, 10); //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('06:00 AM')); $rstf->setEndTime(strtotime('03:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } return $rstc_id; } break; case 20: //Afternoon Shift $rstcf->setName('Afternoon Shift'); $rstcf->setDescription('10:00AM - 7:00PM'); if ($rstcf->isValid()) { $rstc_id = $rstcf->Save(); Debug::Text('bRecurring Schedule Template Control ID: ' . $rstc_id, __FILE__, __LINE__, __METHOD__, 10); //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('10:00 AM')); $rstf->setEndTime(strtotime('07:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } return $rstc_id; } break; case 30: //Evening Shift $rstcf->setName('Evening Shift'); $rstcf->setDescription('2:00PM - 11:00PM'); if ($rstcf->isValid()) { $rstc_id = $rstcf->Save(); Debug::Text('bRecurring Schedule Template Control ID: ' . $rstc_id, __FILE__, __LINE__, __METHOD__, 10); //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('02:00 PM')); $rstf->setEndTime(strtotime('11:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } return $rstc_id; } break; case 40: //Split Shift $rstcf->setName('Split Shift'); $rstcf->setDescription('8:00AM-12:00PM, 5:00PM-9:00PM '); if ($rstcf->isValid()) { $rstc_id = $rstcf->Save(); Debug::Text('bRecurring Schedule Template Control ID: ' . $rstc_id, __FILE__, __LINE__, __METHOD__, 10); //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('08:00 AM')); $rstf->setEndTime(strtotime('12:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('05:00 PM')); $rstf->setEndTime(strtotime('9:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } return $rstc_id; } break; case 50: //Full Rotation $rstcf->setName('Full Rotation'); $rstcf->setDescription('1wk-Morning, 1wk-Afternoon, 1wk-Evening'); if ($rstcf->isValid()) { $rstc_id = $rstcf->Save(); Debug::Text('bRecurring Schedule Template Control ID: ' . $rstc_id, __FILE__, __LINE__, __METHOD__, 10); //Week 1 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(1); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('06:00 AM')); $rstf->setEndTime(strtotime('03:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } //Week 2 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(2); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('10:00 AM')); $rstf->setEndTime(strtotime('07:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } //Week 3 $rstf = new RecurringScheduleTemplateFactory(); $rstf->setRecurringScheduleTemplateControl($rstc_id); $rstf->setWeek(3); $rstf->setSun(FALSE); $rstf->setMon(TRUE); $rstf->setTue(TRUE); $rstf->setWed(TRUE); $rstf->setThu(TRUE); $rstf->setFri(TRUE); $rstf->setSat(FALSE); $rstf->setStartTime(strtotime('02:00 PM')); $rstf->setEndTime(strtotime('11:00 PM')); if ($schedule_policy_id > 0) { $rstf->setSchedulePolicyID($schedule_policy_id); } $rstf->setBranch('-1'); //Default $rstf->setDepartment('-1'); //Default if ($rstf->isValid()) { Debug::Text('Saving Recurring Schedule Week...', __FILE__, __LINE__, __METHOD__, 10); $rstf->Save(); } return $rstc_id; } break; } Debug::Text('ERROR Saving schedule template!', __FILE__, __LINE__, __METHOD__, 10); return FALSE; }
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; }
* Get FORM variables */ extract(FormVariables::GetVariables(array('action', 'page', 'sort_column', 'sort_order', 'ids'))); URLBuilder::setURL($_SERVER['SCRIPT_NAME'], array('sort_column' => $sort_column, 'sort_order' => $sort_order, 'page' => $page)); $sort_array = NULL; if ($sort_column != '') { $sort_array = array($sort_column => $sort_order); } Debug::Arr($ids, 'Selected Objects', __FILE__, __LINE__, __METHOD__, 10); $action = Misc::findSubmitButton(); switch ($action) { case 'add': Redirect::Page(URLBuilder::getURL(NULL, 'EditRecurringScheduleTemplate.php', FALSE)); break; case 'copy': $rstf = new RecurringScheduleTemplateFactory(); $rstlf = new RecurringScheduleTemplateListFactory(); $rstclf = new RecurringScheduleTemplateControlListFactory(); foreach ($ids as $id) { $rstclf->getByIdAndCompanyId($id, $current_company->getId()); foreach ($rstclf as $rstc_obj) { $rstc_obj->StartTransaction(); //Get week data $rstlf->getByRecurringScheduleTemplateControlId($rstc_obj->getId()); if ($rstlf->getRecordCount() > 0) { foreach ($rstlf as $rst_obj) { $week_rows[$rst_obj->getId()] = array('id' => $rst_obj->getId(), 'week' => $rst_obj->getWeek(), 'sun' => $rst_obj->getSun(), 'mon' => $rst_obj->getMon(), 'tue' => $rst_obj->getTue(), 'wed' => $rst_obj->getWed(), 'thu' => $rst_obj->getThu(), 'fri' => $rst_obj->getFri(), 'sat' => $rst_obj->getSat(), 'start_time' => $rst_obj->getStartTime(), 'end_time' => $rst_obj->getEndTime(), 'total_time' => $rst_obj->getTotalTime(), 'schedule_policy_id' => $rst_obj->getSchedulePolicyID(), 'branch_id' => $rst_obj->getBranch(), 'department_id' => $rst_obj->getDepartment(), 'job_id' => $rst_obj->getJob(), 'job_item_id' => $rst_obj->getJobItem()); } } $rstc_obj->setId(FALSE); $rstc_obj->setName(Misc::generateCopyName($rstc_obj->getName()));
function postSave() { if ($this->getDeleted() == TRUE) { Debug::Text('UnAssign Schedule Policy from Schedule/Recurring Schedules...' . $this->getId(), __FILE__, __LINE__, __METHOD__, 10); $sf = new ScheduleFactory(); $rstf = new RecurringScheduleTemplateFactory(); $query = 'update ' . $sf->getTable() . ' set schedule_policy_id = 0 where schedule_policy_id = ' . $this->getId(); $this->db->Execute($query); $query = 'update ' . $rstf->getTable() . ' set schedule_policy_id = 0 where schedule_policy_id = ' . $this->getId(); $this->db->Execute($query); } $this->removeCache($this->getId()); return TRUE; }
//Find next week $last_new_week = $week_rows[$row_keys[0]]['week']; $last_saved_week = $week_rows[array_pop($row_keys)]['week']; Debug::Text('Last New Week: ' . $last_new_week . ' Last Saved Week: ' . $last_saved_week, __FILE__, __LINE__, __METHOD__, 10); if ($last_new_week > $last_saved_week) { $last_week = $last_new_week; } else { $last_week = $last_saved_week; } Debug::Text('Last Week: ' . $last_week, __FILE__, __LINE__, __METHOD__, 10); $next_total_time = 0; if (count($week_rows) > 0) { foreach ($week_rows as $week_row_id => $week_row) { if ($week_row['week'] != '' and $week_row['week'] > 0) { Debug::Text('Row ID: ' . $week_row_id . ' Week: ' . $week_row['week'] . ' Schedule Policy ID: ' . $week_row['schedule_policy_id'], __FILE__, __LINE__, __METHOD__, 10); $rstf = new RecurringScheduleTemplateFactory(); $rstf->setStartTime($week_row['start_time']); $rstf->setEndTime($week_row['end_time']); $rstf->setSchedulePolicyID($week_row['schedule_policy_id']); $rstf->preSave(); $week_rows[$week_row_id]['total_time'] = $rstf->getTotalTime(); if ($week_row_id == $lowest_id) { $next_total_time = $week_rows[$week_row_id]['total_time']; } } } } $week_rows[$next_blank_id] = array('id' => $next_blank_id, 'week' => $last_week + 1, 'start_time' => $week_rows[$lowest_id]['start_time'], 'end_time' => $week_rows[$lowest_id]['end_time'], 'total_time' => $next_total_time, 'schedule_policy_id' => $week_rows[$lowest_id]['schedule_policy_id'], 'branch_id' => $week_rows[$lowest_id]['branch_id'], 'department_id' => $week_rows[$lowest_id]['department_id'], 'mon' => @$week_rows[$lowest_id]['mon'], 'tue' => @$week_rows[$lowest_id]['tue'], 'wed' => @$week_rows[$lowest_id]['wed'], 'thu' => @$week_rows[$lowest_id]['thu'], 'fri' => @$week_rows[$lowest_id]['fri'], 'sat' => @$week_rows[$lowest_id]['sat'], 'sun' => @$week_rows[$lowest_id]['sun']); } elseif ($action != 'submit' and $action != 'delete') { $week_rows[-1] = array('id' => -1, 'week' => 1, 'mon' => TRUE, 'tue' => TRUE, 'wed' => TRUE, 'thu' => TRUE, 'fri' => TRUE, 'start_time' => strtotime('08:00'), 'end_time' => strtotime('17:00'), 'total_time' => 9 * 3600, 'branch_id' => -1, 'department_id' => -1, 'schedule_policy_id' => 0); }
function getMaximumStartStopWindowByCompanyIdAndRecurringScheduleControlID($company_id, $id, $where = NULL, $order = NULL) { if ($company_id == '') { return FALSE; } if ($id == '') { return FALSE; } if ($order == NULL) { $order = array('a.name' => 'asc'); $strict = FALSE; } else { $strict = TRUE; } $rstf = new RecurringScheduleTemplateFactory(); $ph = array('company' => $company_id, 'id' => $id); $query = ' select max(start_stop_window) from ' . $this->getTable() . ' as spf LEFT JOIN ' . $rstf->getTable() . ' as rstf ON ( spf.id = rstf.schedule_policy_id ) where spf.company_id = ? AND rstf.recurring_schedule_template_control_id = ? AND ( spf.deleted = 0 AND rstf.deleted = 0 )'; $window = $this->db->GetOne($query, $ph); if ($window === FALSE) { $window = 0; } Debug::text('Max Start/Stop Window: ' . $window, __FILE__, __LINE__, __METHOD__, 10); return $window; }