$foodOrder->setEmail($email); $foodOrder->setProductId($product_id); //set default status $foodOrder->setStatus('PENDING'); //$foodOrder -> setPickupTime($pickup_time); $foodOrder->setDate(date("Y-m-d H:i:s")); $status = ''; if (isset($_POST['food_order']['status'])) { $status = filter_var($_POST['food_order']['status'], FILTER_SANITIZE_STRING); } else { $status = 'PENDING'; } $data = array('product_id' => $_POST['food_order']['order_list'], 'user_id' => 1, 'full_name' => 'Bob Smith', 'email' => '*****@*****.**', 'phone_number' => '0278839406', 'date' => date("Y-m-d H:i:s"), 'status' => $status); // var_dump($_POST); // die(); // map FoodOrderMapper::map($foodOrder, $data); // validate // $errors = FoodOrderValidator::validate($foodOrder); // if (empty($errors)) { // save $dao = new FoodOrderDao(); $foodOrder = $dao->save($foodOrder); Flash::addFlash('Thank you for ordering with us.'); // redirect Utils::redirect('home'); // } } $productDao = new ProductDao(); $product_id = Utils::getUrlParam('product_id'); $products = $productDao->find();
/** *table joint - product & foodOrder */ public function find() { $result = array(); // $sql = 'SELECT order_id, user_id, full_name, email, phone_number, product_id, date FROM food_orders WHERE ' // . 'status = "'.$status.'";'; $sql = 'SELECT f.order_id, f.user_id, f.full_name, f.email, f.product_id,f.date, f.phone_number, p.product_name FROM food_orders f, products p WHERE ' . 'f.product_id = p.product_id AND f.status != "voided";'; foreach ($this->query($sql) as $row) { $foodOrder = new ProductOrder(); FoodOrderMapper::map($foodOrder, $row); $result[$foodOrder->getUserId()] = $foodOrder; } return $result; }