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