public function find_staff() { /* should have date, start, end set */ $um = new User_Model(); $all_staff = $um->get_staff(); $return = array(); foreach ($all_staff as $u) { $u->warning = array(); $return[$u->id] = $u; } /* find users with shifts that fully overlap this one */ $um->clear(); $bad_staff = $um->distinct()->select('id')->where_in('id', array_keys($return))->where_related('shift', 'date', $this->date)->where_related('shift', 'start <=', $this->start)->where_related('shift', 'end >=', $this->end)->get()->all; foreach ($bad_staff as $u) { unset($return[$u->id]); } /* find overlapping timeoffs */ $tm = new Timeoff_Model(); $timeoffs = $tm->where_related('user', 'id', array_keys($return))->include_related('user', 'id')->where('date <=', $this->date)->where('date_end >=', $this->date)->where('start <', $this->end)->where('end >', $this->start)->get()->all; foreach ($timeoffs as $to) { $return[$to->user_id]->warning = $to; } return $return; }
function index() { $args = $this->parse_args(func_get_args()); $args = array_merge($this->default_params, $args); $display = 'all'; $location_id = array(); $supplied_location_id = isset($args['location']) ? $args['location'] : ''; if (strlen($supplied_location_id)) { if (strpos($supplied_location_id, ',') !== FALSE) { $location_id = explode(',', $supplied_location_id); array_walk($location_id, 'intval'); } else { if ($location_id) { $location_id = array($supplied_location_id); } else { $location_id = $supplied_location_id; } // 0 for all } } $staff_id = array(); $supplied_staff_id = isset($args['staff']) ? $args['staff'] : ''; if ($supplied_staff_id) { if (strpos($supplied_staff_id, ',') !== FALSE) { $staff_id = explode(',', $supplied_staff_id); array_walk($staff_id, 'intval'); } elseif ($supplied_staff_id == '_current_user_id_') { if ($this->auth && $this->auth->user()) { $staff_id = array($this->auth->user()->id); } } else { $staff_id = array($supplied_staff_id); } } $within = FALSE; /* whithin now */ if (isset($args['within'])) { $within = $args['within']; if (strlen($within)) { $within = urldecode($within); } $this->hc_time->setNow(); $start_date = $this->hc_time->formatDate_Db(); $within_from = $this->hc_time->getTimestamp(); if ($within) { $this->hc_time->modify($within); } $end_date = $this->hc_time->formatDate_Db(); $within_to = $this->hc_time->getTimestamp(); $this->data['within_from'] = $within_from; $this->data['within_to'] = $within_to; } else { if (isset($args['start'])) { $start_date = $args['start']; } else { $start_date = $this->hc_time->setNow()->formatDate_Db(); } if (isset($args['end'])) { $end_date = $args['end']; } else { $end_date = ''; } $this->hc_time->setDateDb($start_date); $range = isset($args['range']) ? $args['range'] : ''; if ($range) { switch ($range) { case 'week': $this->hc_time->setStartWeek(); $start_date = $this->hc_time->formatDate_Db(); $this->hc_time->setEndWeek(); $end_date = $this->hc_time->formatDate_Db(); break; case 'month': $this->hc_time->setStartMonth(); $start_date = $this->hc_time->formatDate_Db(); $this->hc_time->setEndMonth(); $end_date = $this->hc_time->formatDate_Db(); break; default: $this->hc_time->modify('+' . $range); $this->hc_time->modify('-1 day'); $end_date = $this->hc_time->formatDate_Db(); break; } } } /* find dates that we have shifts */ $shift_model = new Shift_Model(); $shift_model->select('date'); $shift_model->where('date >=', $start_date); if ($end_date) { $shift_model->where('date <=', $end_date); } $shift_model->group_start(); $shift_model->where('status', SHIFT_MODEL::STATUS_ACTIVE); if ($this->auth->check() && $this->app_conf->get('staff_pick_shifts')) { // $shift_model->or_where('user_id IS ', 'NULL', FALSE); } else { $shift_model->where('user_id IS NOT ', 'NULL', FALSE); } $shift_model->group_end(); if ($location_id) { $shift_model->where_related('location', 'id', $location_id); } if ($staff_id) { $shift_model->where_related('user', 'id', $staff_id); } $shift_model->distinct(); // $shift_model->limit( 3 ); $shift_model->order_by('date', 'ASC'); $shift_model->order_by('start', 'ASC'); $shift_model->get(); // $shift_model->check_last_query(); // exit; $dates = array(); foreach ($shift_model as $s) { $dates[] = $s->date; } $this->data['dates'] = $dates; /* preload staff information */ $um = new User_Model(); $staffs = $um->get_staff(); $this->data['staffs'] = array(); foreach ($staffs as $sta) { $this->data['staffs'][$sta->id] = $sta; } /* preload location information */ $lm = new Location_Model(); $locations = $lm->get()->all; $this->data['locations'] = array(); foreach ($locations as $loc) { $this->data['locations'][$loc->id] = $loc; } $this->data['location_id'] = $location_id; $this->data['display'] = $display; $this->data['within'] = $within; /* load shifts so that they can be reused in module displays to save queries */ $this->_load_shifts($dates, $staff_id, $location_id, $within); $view = 'index'; $this->set_include($view); $this->load->view($this->template, $this->data); return; }
function index() { $args = $this->parse_args(func_get_args()); $display = isset($args['display']) ? $args['display'] : 'calendar'; $filter = isset($args['filter']) ? $args['filter'] : 'all'; $range = isset($args['range']) ? $args['range'] : 'week'; // or month $date = isset($args['start']) ? $args['start'] : ''; $end_date = isset($args['end']) ? $args['end'] : ''; $this->data['id'] = isset($args['id']) ? $args['id'] : 0; /* check if schedule for this date exists */ if ($end_date) { $start_date = $date; if ($end_date < $start_date) { $end_date = $start_date; } } else { if ($date) { $this->hc_time->setDateDb($date); } else { $this->hc_time->setNow(); } switch ($range) { case 'week': $this->hc_time->setStartWeek(); $start_date = $this->hc_time->formatDate_Db(); $this->hc_time->setEndWeek(); $end_date = $this->hc_time->formatDate_Db(); break; case 'month': $this->hc_time->setStartMonth(); $start_date = $this->hc_time->formatDate_Db(); $this->hc_time->setEndMonth(); $end_date = $this->hc_time->formatDate_Db(); break; } } $this->data['start_date'] = $start_date; $this->data['end_date'] = $end_date; $this->data['range'] = $range; /* working staff */ $um = new User_Model(); $this->data['working_staff'] = $um->get_staff(); $lm = new Location_Model(); $locations = $lm->get()->all; $this->data['locations'] = array(); foreach ($locations as $loc) { $this->data['locations'][$loc->id] = $loc; } $this->data['display'] = $display; $this->data['filter'] = $filter; /* load shifts so that they can be reused in module displays to save queries */ $filter_staff_id = $filter == 'staff' ? $this->data['id'] : 0; $this->_load_shifts(array($start_date, $end_date), $filter_staff_id); /* save view */ $this->session->set_userdata(array('schedule_view' => $args)); switch ($filter) { case 'location': if (isset($args['id']) && $args['id']) { $location_id = $args['id']; } else { $ids = array_keys($this->data['locations']); $location_id = $ids[0]; } $this->data['current_location'] = $this->data['locations'][$location_id]; break; case 'staff': if (isset($args['id']) && $args['id']) { $staff_id = $args['id']; } else { $ids = array_keys($this->data['staffs']); $staff_id = $ids[0]; } $this->data['current_staff'] = $this->data['staffs'][$staff_id]; break; } /* decide which view */ switch ($display) { case 'calendar': switch ($filter) { case 'location': $view = 'index_location'; break; case 'staff': $view = 'index_staff'; break; default: $view = 'index'; break; } $view = 'index_calendar'; break; case 'browse': $view = 'index_browse'; break; case 'exportbrowse': return $this->export_browse(); break; case 'exportstats': case 'stats': $stats_shifts = array(); $stats_drafts = array(); reset($this->data['staffs']); foreach ($this->data['staffs'] as $sta) { if ($filter == 'staff') { if ($sta->id != $this->data['current_staff']->id) { continue; } } $stats_shifts[$sta->id] = array(0, 0); $stats_drafts[$sta->id] = array(0, 0); } reset($this->data['shifts']); foreach ($this->data['shifts'] as $sh) { if (!$sh->user_id) { continue; } if ($sh->date < $this->data['start_date']) { continue; } if ($sh->date > $this->data['end_date']) { continue; } if ($filter == 'location') { if ($sh->location_id != $this->data['current_location']->id) { continue; } } if ($filter == 'staff') { if ($sh->user_id != $this->data['current_staff']->id) { continue; } } if (!isset($stats_shifts[$sh->user_id])) { continue; // $stats_shifts[$sh->user_id] = array( 0, 0 ); // $stats_drafts[$sh->user_id] = array( 0, 0 ); } if ($sh->status == SHIFT_MODEL::STATUS_ACTIVE) { $stats_shifts[$sh->user_id][0] += 1; $stats_shifts[$sh->user_id][1] += $sh->get_duration(); } else { $stats_drafts[$sh->user_id][0] += 1; $stats_drafts[$sh->user_id][1] += $sh->get_duration(); } } /* filter archived staff if they have no shifts */ $archived_users = array(); $um = new User_Model(); $um->select('id')->where('active', USER_MODEL::STATUS_ARCHIVE)->get(); foreach ($um as $u) { $archived_users[] = $u->id; } if ($archived_users) { $all_users = array_keys($stats_shifts); foreach ($all_users as $uid) { if (in_array($uid, $archived_users) && $stats_shifts[$uid][0] == 0 && $stats_drafts[$uid][0] == 0) { unset($stats_shifts[$uid]); unset($stats_drafts[$uid]); } } } $this->data['stats_shifts'] = $stats_shifts; $this->data['stats_drafts'] = $stats_drafts; /* sort by duration */ uasort($this->data['stats_shifts'], create_function('$a, $b', 'return ($b[1] - $a[1]);')); if ($display == 'exportstats') { return $this->export_stats(); } else { $view = 'index_stats'; } break; default: $view = 'index_calendar'; break; } $this->set_include($view); $this->load->view($this->template, $this->data); return; }