public function insert($data) { $hydrator = new ObjectProperty(); //Hidrate StdClass to array $data->user_id = $this->usersRepository->getAuthenticated()->getId(); $data->created_at = (new \DateTime())->format('Y-m-d'); $data->total = 0; $items = $data->item; unset($data->item); $orderData = $hydrator->extract($data); $tableGateway = $this->repository->getTableGateway(); try { $tableGateway->getAdapter()->getDriver()->getConnection()->beginTransaction(); $order_id = $this->repository->insert($orderData); foreach ($items as $key => $item) { $product = $this->productsRepository->find($item['product_id']); $item['order_id'] = $order_id; $item['price'] = $product->getPrice(); $item['total'] = $items[$key]['total'] = $item['quantity'] * $item['price']; $total += $item['total']; $this->repository->insertItem($item); } $this->repository->update(['total' => $total], $order_id); $tableGateway->getAdapter()->getDriver()->getConnection()->commit(); return ['order_id' => $order_id]; } catch (\Exception $e) { $tableGateway->getAdapter()->getDriver()->getConnection()->rollback(); return 'error'; } }
public function insert($data) { $data->user_id = $this->userRepository->getAuthenticated()->getId(); $data->created_at = (new \DateTime())->format('Y-m-d'); $data->total = 0; $items = $data->item; unset($data->item); $hydrator = new ObjectProperty(); $orderData = $hydrator->extract($data); try { $this->repository->beginTransaction(); $orderId = $this->repository->insert($orderData); $total = 0; foreach ($items as $key => $item) { $product = $this->productRepository->find($item["product_id"]); $item['order_id'] = $orderId; $item['price'] = $product->getPrice(); $item['total'] = $items[$key]["total"] = $item['quantity'] * $product->getPrice(); $total += $item['total']; $this->repository->insertItem($item); } $this->repository->update(['total' => $total], $orderId); $this->repository->commitTransaction(); } catch (Exception $e) { error_log($e->getCode()); error_log($e->getFile()); error_log($e->getLine()); error_log($e->getMessage()); $this->repository->rollbackTransaction(); return false; } return $orderId; }
public function insert($data) { $total = 0; $items = $data->items; unset($data->items); $orderTable = $this->ordersRepository->getTableGateway(); try { // Begin Transaction $orderTable->getAdapter()->getDriver()->getConnection()->beginTransaction(); foreach ($items as $key => $item) { $item['total'] = $item['quantity'] * $item['price']; $items[$key]['total'] = $item['total']; $total += $item['total']; } $data->total = $total; $data->status = 0; $data->created_at = \date('Y-m-d H:i:s'); $order = $this->ordersRepository->insert($data); foreach ($items as $item) { $item['order_id'] = $order->getId(); $this->ordersRepository->insertItem($item); } // Commit $orderTable->getAdapter()->getDriver()->getConnection()->commit(); return $this->find($order->getId()); } catch (\Exception $e) { // Rollback $orderTable->getAdapter()->getDriver()->getConnection()->rollback(); throw new \Exception('Error processing order.'); } }
public function insert($data) { $hydrator = new ObjectProperty(); $data = $hydrator->extract($data); $orderData = $data; unset($orderData['item']); $items = $data['item']; $tableGateway = $this->repository->getTableGateway(); try { $tableGateway->getAdapter()->getDriver()->getConnection()->beginTransaction(); $orderId = $this->repository->insert($orderData); foreach ($items as $item) { $item['order_id'] = $orderId; $this->repository->insertItem($item); } $tableGateway->getAdapter()->getDriver()->getConnection()->commit(); return ['order_id' => $orderId]; } catch (\Exception $e) { $tableGateway->getAdapter()->getDriver()->getConnection()->rollback(); return 'error'; } }