function getShiftsByStartDateAndEndDate($start_date, $end_date)
{
//Make sure timezone isn't in the time format. Because recurring schedules
//are timezone agnostic. 7:00AM in PST is also 7:00AM in EST.
//This causes an issue where the previous users timezone carries over to the next
//users timezone, causing errors.
//TTDate::setTimeFormat('g:i A');
if ($start_date == '') {
return FALSE;
}
if ($end_date == '') {
return FALSE;
}
if ($start_date < $this->getStartDate()) {
$start_date = $this->getStartDate();
}
if ($this->getEndDate(TRUE) != NULL and $end_date > $this->getEndDate()) {
$end_date = $this->getEndDate();
}
Debug::text('Start Date: ' . TTDate::getDate('DATE+TIME', $start_date) . ' End Date: ' . TTDate::getDate('DATE+TIME', $end_date), __FILE__, __LINE__, __METHOD__, 10);
//Get week data
$rstlf = new RecurringScheduleTemplateListFactory();
$rstlf->getByRecurringScheduleTemplateControlId($this->getRecurringScheduleTemplateControl())->getCurrent();
$max_week = 1;
$weeks = array();
if ($rstlf->getRecordCount() > 0) {
foreach ($rstlf as $rst_obj) {
Debug::text('Week: ' . $rst_obj->getWeek(), __FILE__, __LINE__, __METHOD__, 10);
$template_week_rows[$rst_obj->getWeek()][] = $rst_obj->getObjectAsArray();
$weeks[$rst_obj->getWeek()] = $rst_obj->getWeek();
if ($rst_obj->getWeek() > $max_week) {
$max_week = $rst_obj->getWeek();
}
}
}
$weeks = $this->ReMapWeeks($weeks);
//Get week of start_date
$start_date_week = TTDate::getWeek($this->getStartDate(), 0);
//Start week on Sunday to match Recurring Schedule.
Debug::text('Week of Start Date: ' . $start_date_week, __FILE__, __LINE__, __METHOD__, 10);
for ($i = $start_date; $i <= $end_date; $i += 86400) {
$current_week = TTDate::getWeek($i, 0);
//Start week on Sunday to match Recurring Schedule.
//Debug::text('Current Date: '. TTDate::getDate('DATE+TIME', $i) .' Current Week: '. $current_week,__FILE__, __LINE__, __METHOD__, 10);
$template_week = abs($current_week - $start_date_week) % $max_week + 1;
//Debug::text('Template Week: '. $template_week .' Max Week: '. $max_week,__FILE__, __LINE__, __METHOD__, 10);
$day_of_week = strtolower(date('D', $i));
//Debug::text('Day Of Week: '. $day_of_week,__FILE__, __LINE__, __METHOD__, 10);
if (isset($weeks[$template_week])) {
$mapped_template_week = $weeks[$template_week];
//Debug::text(' Mapped Template Week: '. $mapped_template_week,__FILE__, __LINE__, __METHOD__, 10);
if (isset($template_week_rows[$mapped_template_week])) {
//Debug::text(' Starting Looping...!',__FILE__, __LINE__, __METHOD__, 10);
foreach ($template_week_rows[$mapped_template_week] as $template_week_arr) {
if ($template_week_arr['days'][$day_of_week] == TRUE) {
//Debug::text(' Found Scheduled Time: Start Time: '. TTDate::getDate('DATE+TIME', TTDate::getTimeLockedDate( $template_week_arr['start_time'], $i ) ),__FILE__, __LINE__, __METHOD__, 10);
$start_time = TTDate::getTimeLockedDate($template_week_arr['start_time'], $i);
$end_time = TTDate::getTimeLockedDate($template_week_arr['end_time'], $i);
if ($end_time < $start_time) {
//Spans the day boundary, add 86400 to end_time
$end_time = $end_time + 86400;
//Debug::text(' Schedule spans day boundary, bumping endtime to next day: ',__FILE__, __LINE__, __METHOD__, 10);
}
//Debug::text(' Start Date: '. TTDate::getDate('DATE+TIME', $start_time) .' End Date: '. TTDate::getDate('DATE+TIME', $end_time),__FILE__, __LINE__, __METHOD__, 10);
//$shifts[TTDate::getBeginDayEpoch($i)][] = array(
$shifts[TTDate::getISODateStamp($i)][] = array('status_id' => $template_week_arr['status_id'], 'start_time' => $start_time, 'raw_start_time' => TTDate::getDate('DATE+TIME', $start_time), 'end_time' => $end_time, 'raw_end_time' => TTDate::getDate('DATE+TIME', $end_time), 'total_time' => $template_week_arr['total_time'], 'schedule_policy_id' => $template_week_arr['schedule_policy_id'], 'branch_id' => $template_week_arr['branch_id'], 'department_id' => $template_week_arr['department_id'], 'job_id' => $template_week_arr['job_id'], 'job_item_id' => $template_week_arr['job_item_id']);
unset($start_time, $end_time);
} else {
//Debug::text(' aSkipping!',__FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
//Debug::text(' bSkipping!',__FILE__, __LINE__, __METHOD__, 10);
}
} else {
//Debug::text(' cSkipping!',__FILE__, __LINE__, __METHOD__, 10);
}
}
//var_dump($shifts);
if (isset($shifts)) {
return $shifts;
}
return FALSE;
}
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()));
if ($rstc_obj->isValid()) {
$rstc_id = $rstc_obj->Save();
if (count($week_rows) > 0) {
foreach ($week_rows as $week_row_id => $week_row) {
Debug::Text('Row ID: ' . $week_row_id . ' Week: ' . $week_row['week'], __FILE__, __LINE__, __METHOD__, 10);
if ($week_row['week'] != '' and $week_row['week'] > 0) {
$rstf->setRecurringScheduleTemplateControl($rstc_id);
$rstf->setWeek($week_row['week']);
