public function log(Orders $order, User $user, PayType $paytype, $amount = null, $act = null) { $ope = new Ope(); $ope->setOrder($order)->setUser($user)->setPayType($paytype)->setAmount($amount)->setAct($act)->setDatetime(new \DateTime()); $this->setOpe($ope); return $this; }
public function create(array $options = array()) { $act; foreach ($options['orders'] as $order) { switch ($order->getKind()->getId()) { case Avenue::OK_IN: $act = '成立進貨訂單'; break; case Avenue::OK_CONSIGN_IN: $act = '成立寄賣訂單'; break; case Avenue::OK_FEEDBACK: $act = '成立寄賣回扣訂單'; break; default: break; } $ope = new Ope(); $ope->setUser($options['user'])->setOrder($order)->setAct($act)->setDatetime(new \DateTime())->setAmount($options['cost'])->setPayType($options['paytype']); $this->addStorage($ope); } return $this; }
/** * 調出貨請求確認 * * @Route("/backOrder/{id}/confirm", name="order_backOrder_confirm", options={"expose"=true}) * @ParamConverter("move", class="WoojinGoodsBundle:Move") * @Method("GET") */ public function backOrderConfirmAction(Request $request, Move $move) { if (!$move->isModifyble()) { return new \Exception("請求已經為終止狀態,不可更改!"); } $user = $this->get('security.token_storage')->getToken()->getUser(); $session = $this->get('session'); $em = $this->getDoctrine()->getManager(); $qb = $em->createQueryBuilder(); $em->getConnection()->beginTransaction(); try { $oGoodsStatus = $em->find('WoojinGoodsBundle:GoodsStatus', Avenue::GS_OTHERSTORE); $oGoodsStatusIn = $em->find('WoojinGoodsBundle:GoodsStatus', Avenue::GS_ONSALE); // 從調貨請求出抓出被調出的商品 $product = $move->getOrgGoods(); // 將商品狀態設定為他店 $product->setStatus($oGoodsStatus); // 尋找是否已經存在屬於該店的護照(產編字首和商品指紋) $qb->select('gd')->from('WoojinGoodsBundle:GoodsPassport', 'gd')->where($qb->expr()->andX($qb->expr()->eq('SUBSTRING(gd.sn, 1, 1)', $qb->expr()->literal($user->getStore()->getSn())), $qb->expr()->eq('gd.parent', $product->getParent()->getId()))); // Query 結果為調進貨的商品,若不存在該商品則反為 NULL $newProducts = $qb->getQuery()->getResult(); // 如果為空則建立新護照, 直接將原本護照的內容copy到新護照上 if (empty($newProducts)) { $productFactory = $this->get('factory.product'); // 複製調出商品實體 $productFactory->_clone($product); // 從工廠提取複製品 $newProduct = $productFactory->getProduct(); // 改變複製品的產編和狀態(上架) $newProduct->setSn($newProduct->genSn($user->getStore()->getSn()))->setStatus($oGoodsStatusIn); $em->persist($newProduct); $em->flush(); } else { // 若不為空則直接使用取得的舊護照 /* * 商品回國將狀態改為國內( 上架 ), * 寄賣金額改為0 表示不用做二段通知 */ // 取得護照 $newProduct = $newProducts[0]; // 將商品狀態改為上架 $newProduct->setStatus($oGoodsStatusIn); $em->persist($newProduct); // 取得該護照的所有訂單記錄 $newOrders = $newProduct->getOrders(); // 依照訂單記錄進行迭代 foreach ($newOrders as $key => $order) { if (Avenue::OK_FEEDBACK === $order->getId()) { // 將寄賣金額從 -1 改為 0 $order->setPaid(0); $em->persist($order); break; } } } $move->setStatus($em->find('WoojinGoodsBundle:MoveStatus', Avenue::MV_COMPLETE))->setNewGoods($newProduct)->setCatcher($user); $em->persist($move); $complete = $em->find('WoojinOrderBundle:OrdersStatus', Avenue::OS_COMPLETE); $cashType = $em->find('WoojinOrderBundle:PayType', Avenue::PT_CASH); $ordersMoveOut = new Orders(); $ordersMoveOut->setStatus($complete)->setPaid($product->getCost())->setRequired($product->getCost())->setPayType($cashType)->setKind($em->find('WoojinOrderBundle:OrdersKind', Avenue::OK_MOVE_OUT))->setGoodsPassport($product); $ordersMoveIn = new Orders(); $ordersMoveIn->setStatus($complete)->setPaid($product->getCost())->setRequired($product->getCost())->setPayType($cashType)->setKind($em->find('WoojinOrderBundle:OrdersKind', Avenue::OK_MOVE_IN))->setGoodsPassport($newProduct); $ordersMoveIn->addRelate($ordersMoveOut); $ordersMoveOut->setParent($ordersMoveIn); $em->persist($ordersMoveIn); $em->persist($ordersMoveOut); // 記錄調貨進操作記錄 $opeIn = new Ope(); $opeOut = new Ope(); $opeIn->setUser($move->getCatcher())->setDatetime(new \DateTime(date('Y-m-d H:i:s')))->setOrders($ordersMoveIn)->setAct('成立調進貨訂單'); $opeOut->setUser($move->getThrower())->setDatetime(new \DateTime(date('Y-m-d H:i:s')))->setOrders($ordersMoveOut)->setAct('成立調出貨訂單'); $newProduct->setSn($newProduct->genSn($user->getStore()->getSn())); $em->persist($opeIn); $em->persist($opeOut); $em->persist($newProduct); $em->flush(); $em->getConnection()->commit(); $session->getFlashBag()->add('success', $product->getSn() . ' -> ' . $newProduct->getSn()); } catch (Exception $e) { $em->getConnection()->rollback(); throw $e; } // 若已經上傳至yahoo, if ($newProduct->getYahooId()) { $apiClient = $this->get('yahoo.api.client'); $apiClient->updateMain($apiClient->getProvider()->genR($newProduct)->getR()); $session->getFlashBag()->add('success', 'Yahoo商城同步更新完成'); $product->setYahooId(NULL); $em->persist($product); $em->flush(); } else { $session->getFlashBag()->add('error', 'Yahoo商城同步未進行'); } return $this->redirect($this->generateUrl('move')); }
protected function batchAddEachProcess($rData) { $em = $this->em; $oOrders = new Orders(); $oOpe = new Ope(); $oGoodsPassport = new GoodsPassport(); $oGoodsPassport->setBrand($this->brand)->setModel($rData['model'])->setColor($this->color)->setPattern($this->pattern)->setColorSn(array_key_exists('colorSn', $rData) ? $rData['colorSn'] : '')->setLevel($this->oGoodsLevel)->setGoodsStatus($this->oGoodsStatus)->setName($rData['sGoodsName'])->setCost($rData['nGoodsCost'])->setPrice($rData['nGoodsPrice'])->setOrgSn(array_key_exists('sGoodsOrgSn', $rData) ? $rData['sGoodsOrgSn'] : '')->setMemo(array_key_exists('sGoodsMemo', $rData) ? $rData['sGoodsMemo'] : ''); $em->persist($oGoodsPassport); $em->flush(); $sym = $this->get('base_method')->getSymbol(); $theRate = $sym == 'NT' ? self::SN_RATE : 10; $nGoodsId = $oGoodsPassport->getId(); $sGoodsSn = $oGoodsPassport->genSn($rData['sStoreSn']); $oGoodsPassport->setSn($sGoodsSn)->setParent($em->find('WoojinGoodsBundle:GoodsPassport', $nGoodsId)); $em->persist($oGoodsPassport); $em->flush(); $oOrders->setGoodsPassport($oGoodsPassport)->setPayType($this->oPayType)->setOrdersKind($this->oOrdersKind)->setOrdersStatus($this->oOrdersStatus)->setRequired($rData['nGoodsCost'])->setPaid($rData['nGoodsCost']); $em->persist($oOrders); $em->flush(); $nOrdersId = $oOrders->getId(); //Ope實體新增 $oOpe->setOrders($oOrders)->setUser($this->oUser)->setAct('批次成立進貨訂單')->setDatetime(new \DateTime($rData['time'])); $em->persist($oOpe); $em->flush(); }
protected function pick($product) { // 更新商品狀態 $product->setStatus($this->saleStatus); $per = (100 - $this->invoice->getInvoiceSurcharge()) / 100; $order = new Orders(); $order->setPaid(0)->setRequired(round($product->getPromotionPrice(true) * $per))->setOrgPaid(0)->setOrgRequired($product->getPromotionPrice(true))->setPayType($this->paytype)->setKind($this->kind)->setStatus($this->completeStatus)->setGoodsPassport($product)->setInvoice($this->invoice)->setCustom($this->custom); $ope = new Ope(); $ope->setOrders($order)->setUser($this->user)->setAct('官網售出')->setDatetime(new \DateTime()); $this->em->persist($product); $this->em->persist($order); $this->em->persist($ope); }