function shifts() { if ($this->staff_id) { $um = new User_Model(); $um->get_by_id($this->staff_id); $sm = $um->shift; } elseif ($this->location_id) { $lm = new Location_Model(); $lm->get_by_id($this->location_id); $sm = $lm->shift; } else { $sm = new Shift_Model(); } if ($this->start) { $sm->where('date >=', $this->start); } if ($this->end) { $sm->where('date <=', $this->end); } $sm->order_by('date', 'ASC')->order_by('start', 'ASC')->include_related('user', 'id'); return $sm->get(); }
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; }