$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;
 }