public function index() { $this->authenticateAdmin(); $all = $this->input->get('unassigned'); $routes = array(); if (!isset($all)) { $query = $this->db->get('routes'); } else { $this->db->select('routes.* '); $query = $this->db->join('timings', 'timings.route_id = routes.id', 'LEFT OUTER')->join('driver_timings', 'driver_timings.timing_id = timings.id', 'LEFT OUTER')->group_by('routes.id')->where('driver_timings.timing_id', NULL)->get('routes'); } foreach ($query->result() as $route_row) { $route = Route_model::initialize($route_row); array_push($routes, $route->asJson()); } $this->output->set_status_header(200)->set_output(json_encode($routes)); }
public function studentRoute() { $row = $this->db->select('routes.*')->join('timings', 'timings.route_id = routes.id', 'INNER')->join('student_timings', 'student_timings.timing_id = timings.id', 'INNER')->where('student_timings.student_id', $this->id)->get('routes')->row(); if (isset($row)) { return [Route_model::initialize($row)->asJson($this)]; } else { return array(); } }