public static function map(FoodOrder $foodOrder, array $properties) { // var_dump($properties); // die(); if (array_key_exists('order_id', $properties)) { $foodOrder->setOrderId($properties['order_id']); } if (array_key_exists('user_id', $properties)) { $foodOrder->setUserId($properties['user_id']); } if (array_key_exists('full_name', $properties)) { $foodOrder->setFullName($properties['full_name']); } if (array_key_exists('email', $properties)) { $foodOrder->setEmail($properties['email']); } if (array_key_exists('product_id', $properties)) { $foodOrder->setProductId($properties['product_id']); } if (array_key_exists('phone_number', $properties)) { $foodOrder->setPhoneNumber($properties['phone_number']); } if (array_key_exists('product_name', $properties)) { $foodOrder->setProductName($properties['product_name']); } if (array_key_exists('date', $properties)) { $formattedDate = $properties['date']; $date = self::createDateTime($formattedDate); if ($date) { $foodOrder->setDate($date); } } }
public function insert(FoodOrder $foodOrder) { //needs changing //$now = new DateTime(); $foodOrder->setOrderId(null); //$flightBooking->setCreatedOn($now); //$flightBooking->setLastModifiedOn($now); $foodOrder->setStatus(FoodOrder::PENDING); // $sql = 'INSERT INTO food_order (order_id, user_id, full_name, email, phone_number, product_id, status) // VALUES (:order_id, :user_id, :full_name, :email, :phone_number, :product_id, :status)'; $sql = ' INSERT INTO food_orders (order_id, user_id, full_name, phone_number, email, product_id, status) VALUES (:order_id, :user_id, :full_name, :phone_number, :email, :product_id, :status)'; return $this->execute($sql, $foodOrder); }