public function indexAction() { $dateSelected = ""; $sqlWithDate = ""; if ($this->request->getPost()) { $dateSelected = $this->request->getPost('date'); $sqlWithDate = " AND date_created = '{$dateSelected}'"; $today = Carbon::now()->toDateString(); } $hours = ['09' => ['hours' => '09', 'desc' => '09:00 - 10:00'], '10' => ['hours' => '10', 'desc' => '10:00 - 11:00'], '11' => ['hours' => '11', 'desc' => '11:00 - 12:00'], '12' => ['hours' => '12', 'desc' => '12:00 - 13:00'], '13' => ['hours' => '13', 'desc' => '13:00 - 14:00'], '14' => ['hours' => '14', 'desc' => '14:00 - 15:00'], '15' => ['hours' => '15', 'desc' => '15:00 - 16:00'], '16' => ['hours' => '16', 'desc' => '16:00 - 17:00'], '17' => ['hours' => '17', 'desc' => '17:00 - 18:00'], '18' => ['hours' => '18', 'desc' => '18:00 - 19:00'], '19' => ['hours' => '19', 'desc' => '19:00 - 20:00'], '20' => ['hours' => '20', 'desc' => '20:00 - 21:00'], '21' => ['hours' => '21', 'desc' => '21:00 - 22:00']]; $stadium = []; $userID = ""; for ($i = 1; $i <= 8; $i++) { foreach ($hours as $key => $value) { $order = Orders::findFirst("stadium = '{$i}' AND start_hour = '{$key}' {$sqlWithDate}"); $link = "<a href=\"/process/add/{$i}/{$key}/{$this->session->get('user_id')}\" class=\"btn-xs btn-success\">Book Now</a>"; $name = $link; if (isset($order->user_id)) { $name = "<a class=\"btn-xs btn-default\">{$order->Userss->name}</a>"; if ($order->user_id == $this->session->get('user_id')) { $name = "<a class=\"btn-xs btn-warning\">Yours</a>"; } $userID = isset($order->user_id) ? $order->user_id : ""; } if ($dateSelected < $today) { $name = "<a class=\"btn-xs btn-danger\">Expired Book</a>"; } $stadium[$key][$i] = ['desc' => $value['desc'], 'userId' => $userID, 'name' => $name]; } } $this->view->setVar('data', $stadium); $this->view->setVar('dateSelected', $dateSelected . " (yy-mm-dd)"); }
public function updateAction($oid) { $auth = $this->session->get('auth'); $cid = $auth[cid]; if ($cid == false) { $this->response->redirect("404"); } else { $order = Orders::findFirst(array("(o_id = :oid:)", 'bind' => array('oid' => $oid))); $order->o_delivery = 1; if ($order->save() != false) { return $this->response->redirect('orders'); } } }