public function findById($id)
{
$row = $this->query('SELECT * FROM orders_tb WHERE id = ' . (int) $id)->fetch();
if (!$row) {
return null;
}
$order = new Order();
OrderMapper::map($order, $row);
return $order;
}
public function find($status = null)
{
$result = array();
$sql = 'SELECT id, user_id, business_id, order_date, status, assigned_to,order_details FROM orders_tb WHERE ' . 'status = "' . $status . '";';
foreach ($this->query($sql) as $row) {
$order = new Order();
OrderMapper::map($order, $row);
$result[$order->getId()] = $order;
}
return $result;
}
<?php
$errors = array();
$userObj = new User();
$addressObj = new Address();
$orderObj = new Order();
if (array_key_exists('submit', $_POST)) {
$userData = array('id' => (int) $_SESSION['user_id'], 'first_name' => $_POST['user']['first_name'], 'last_name' => $_POST['user']['last_name']);
$addressData = array('street_no' => $_POST['address']['street_no'], 'street' => $_POST['address']['street'], 'suburb' => $_POST['address']['suburb'], 'city' => $_POST['address']['city'], 'post_code' => $_POST['address']['post_code']);
UserMapper::map($userObj, $userData);
AddressMapper::map($addressObj, $addressData);
//$errors = Validator::validate($userObj);
//if (empty($errors)) {
$userDao = new UserDao();
$addressDao = new AddressDao();
// $_SESSION['address_id'] = ($addressDao->create($addressObj)->getId());
$userDao->completeRegistration($userObj, $addressDao->createAddress($addressObj)->getId());
//}
}
if (array_key_exists('order', $_POST)) {
$orderData = array('order_details' => $_POST['orders']['order_details'], 'order_date' => $_POST['orders']['order_date'] . '00:00:00');
OrderMapper::map($orderObj, $orderData);
$orderDao = new OrderDao();
$orderDao->createOrder($orderObj);
}
