protected function onConsign(array $options, GoodsPassport $product)
{
$order = new Orders();
$order->setCustom($options['custom'])->setGoodsPassport($product)->setPayType($options['paytype'])->setKind($options['orderKindConsign'])->setStatus($options['orderStatusComplete'])->setRequired($product->getCost())->setPaid($product->getCost());
$orderFeedBack = new Orders();
$orderFeedBack->setKind($options['orderKindFeedback'])->setStatus($options['orderStatusHandling'])->setCustom($order->getCustom())->setGoodsPassport($order->getProduct())->setPayType($order->getPayType())->setRequired($order->getProduct()->getCost())->setPaid(0)->setParent($order);
$this->addStorage($order)->addStorage($orderFeedBack);
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'));
}
/**
* 從訂單取得負責人的mail
*
* @param \Woojin\OrderBundle\Entity\Orders $order
*/
protected function getMailFromOrder(Orders $order)
{
$product = $order->getGoodsPassport();
$store = $this->em->getRepository('WoojinStoreBundle:Store')->findOneBy(array('sn' => substr($product->getSn(), 0, 1)));
return $store->getMail();
}
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);
}
/**
* 代購商品出貨 (訂單狀態: 已出貨)
*
* 1. 修改代購實體狀態
* 2. 通知客戶已出貨
*
* @param array $options
* @return this
*/
public function productOut(array $options = array())
{
$options = $this->resolver->resolve($options);
$this->behalf = $options['behalf'];
$this->behalf->setStatus($this->statusFacade->findPurOut())->setSendAt(new \DateTime())->setDeliverySn($options['deliverySn']);
$this->em->getConnection()->beginTransaction();
try {
$custom = $this->behalf->getCustom();
$got = $this->behalf->getGot();
$required = $this->behalf->getWant()->getPromotionPrice(true);
$invoice = new Invoice();
$invoice->setCustom($custom)->setStore($this->behalf->getUser()->getStore())->setHasPrint(0)->setSn(uniqid());
$this->em->persist($invoice);
$order = new Orders();
$order->setGoodsPassport($got)->setCustom($custom)->setPayType($this->em->find('WoojinOrderBundle:PayType', Avenue::PT_ATM))->setKind($this->em->find('WoojinOrderBundle:OrdersKind', Avenue::OK_OUT))->setStatus($this->em->find('WoojinOrderBundle:OrdersStatus', Avenue::OS_COMPLETE))->setRequired($required)->setOrgRequired($required)->setOrgPaid($required)->setPaid($required)->setInvoice($invoice);
$this->em->persist($order);
$got->setStatus($this->em->find('WoojinGoodsBundle:GoodsStatus', Avenue::GS_SOLDOUT));
$this->em->persist($got);
$this->em->flush();
$this->container->get('logger.ope')->recordOpe($order, '成立銷貨訂單(代購)', $this->container->get('authority.judger')->getUser());
$this->em->getConnection()->commit();
} catch (\Exception $e) {
$this->em->getConnection()->rollback();
throw $e;
}
$this->notifier->behalfForCustom($this->behalf);
return $this;
}
/**
* @Route("/v2/getback/{id}", requirements={"id" = "\d+"}, name="orders_v2_getback", options={"expose"=true})
* @ParamConverter("order", class="WoojinOrderBundle:Orders")
* @Method("PUT")
*/
public function v2GetBackAction(Request $request, Orders $order)
{
$user = $this->get('security.token_storage')->getToken()->getUser();
$em = $this->getDoctrine()->getManager();
$em->getConnection()->beginTransaction();
try {
$redirectUrl = $this->generateUrl('goods_edit_v2', array('id' => $order->getProduct()->getId()));
$session = $this->get('session');
$cancel = $em->find('WoojinOrderBundle:OrdersStatus', Avenue::OS_CANCEL);
$getback = $em->find('WoojinGoodsBundle:GoodsStatus', Avenue::GS_GETBACK);
if (Avenue::OK_CONSIGN_IN !== $order->getKind()->getId()) {
$session->getFlashBag()->add('error', '此訂單非寄賣訂單!');
return $this->redirect($redirectUrl);
}
$product = $order->getProduct();
if (in_array($product->getStatus()->getId(), array(Avenue::GS_SOLDOUT, Avenue::GS_OFFSALE, Avenue::GS_BEHALF, Avenue::GS_GETBACK))) {
$session->getFlashBag()->add('error', $product->getSn() . '商品不在店內!');
return $this->redirect($redirectUrl);
}
// 根據商品id和訂單種類找到其關連訂單
$relate = $this->getDoctrine()->getRepository('WoojinOrderBundle:Orders')->findOneBy(array('goods_passport' => $product->getId(), 'kind' => Avenue::OK_FEEDBACK));
// 若沒找到則回應錯誤訊息
if (!$relate) {
$session->getFlashBag()->add('error', $product->getSn() . '未找到寄賣請款訂單!');
return $this->redirect($redirectUrl);
}
$order->setStatus($cancel);
$em->persist($order);
// 改變關連訂單狀態
$relate->setStatus($cancel);
$em->persist($relate);
$product->setStatus($getback);
$em->persist($product);
$em->flush();
$sculper = $this->get('sculper.clue');
$sculper->initCustomGetBack();
$sculper->setAfter($order);
$clue = new AvenueClue();
$clue->setUser($user)->setContent($sculper->getContent());
$em->persist($clue);
$session->getFlashBag()->add('success', $product->getSn() . '客戶寄賣取回!');
if ($product->getYahooId()) {
$apiClient = $this->get('yahoo.api.client');
$apiClient->delete($product);
$session->getFlashBag()->add('success', 'Yahoo商城同步下架刪除完成!');
}
$opeLogger = $this->get('logger.ope');
$opeLogger->recordOpe($relate, '客寄取回');
$em->getConnection()->commit();
} catch (\Exception $e) {
$em->getConnection()->rollback();
throw $e;
}
return $this->redirect($redirectUrl);
}
/**
* @Route("/multisale/sell", name="order_multisale_sell", options={"expose"=true})
*/
public function orderMultieSell(Request $request)
{
foreach ($request->request->keys() as $key) {
${$key} = $request->request->get($key);
}
$successProducts = array();
$user = $this->get('security.token_storage')->getToken()->getUser();
$opeLogger = $this->get('logger.ope');
$dc = $this->getDoctrine();
$em = $dc->getManager();
$em->getConnection()->beginTransaction();
try {
// 訂單id陣列
$rRollback = array();
// 金額總計
$nTotal = 0;
// 回傳產編字串
$returnSn = '';
// 取得付款方式
$paytype = $em->find('WoojinOrderBundle:PayType', $nPayTypeId);
// 根據付款方式取得折扣
$nDisRate = $paytype->getDiscount();
// 取得訂單狀態
$orderKind = $em->find('WoojinOrderBundle:OrdersKind', $nOrdersKindId);
// 取得商品狀態
$productStatus = $em->find('WoojinGoodsBundle:GoodsStatus', Avenue::GS_SOLDOUT);
// 取得客戶
$oCustom = $dc->getRepository('WoojinOrderBundle:Custom')->findOneBy(array('mobil' => $mobil == '' ? '00000' : $mobil, 'store' => $user->getStore()->getId()));
// 若找尋的客戶不存在, 回覆錯誤訊息
if (!is_object($oCustom)) {
return new Response('<div class="alert alert-block alert-danger fade in">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4 class="alert-heading">手機號碼不存在</h4>
</div>');
}
// 檢查有無傳入資料
if (!isset($rId)) {
return new Response('<div class="alert alert-block alert-danger fade in">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4 class="alert-heading">無傳入資料</h4>
</div>');
}
if (!is_array($rId)) {
return new Response('<div class="alert alert-block alert-danger fade in">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4 class="alert-heading">無傳入資料</h4>
</div>');
}
// 移除重複的id
$rId = array_unique($rId);
/**
* 新增一張發票
*
* @var Invoice
*/
$invoice = new Invoice();
$invoice->setHasPrint(false)->setSn(md5(time()));
$em->persist($invoice);
// 根據傳入的 rId 迭代
foreach ($rId as $key => $id) {
// 取得商品
$product = $dc->getRepository('WoojinGoodsBundle:GoodsPassport')->find($id);
if ($product->getStatus()->getId() != Avenue::GS_ONSALE) {
continue;
}
// 更新商品狀態
$product->setStatus($productStatus);
$em->persist($product);
// 計算折扣後的應付金額
$nOrdersRequired = $rOrdersRequired[$key] * $nDisRate;
// 根據應付金額與實付金額決定訂單狀態
$nOrdersStatusId = $nOrdersRequired - $rOrdersRequired[$key] != 0 ? Avenue::OS_HANDLING : Avenue::OS_COMPLETE;
$orderStatus = $em->find('WoojinOrderBundle:OrdersStatus', $nOrdersStatusId);
// 成立新的訂單
$order = new Orders();
// 設定新的訂單資料
$order->setGoodsPassport($product)->setCustom($oCustom)->setPayType($paytype)->setKind($orderKind)->setStatus($orderStatus)->setRequired($nOrdersRequired)->setPaid($nOrdersRequired)->setOrgRequired($nOrdersRequired)->setOrgPaid($nOrdersRequired)->setInvoice($invoice);
$em->persist($order);
$nTotal += $nOrdersRequired;
$opeLogger->log($order, $user, $paytype, $nOrdersRequired, '成立' . $orderKind->getName() . '訂單[' . $rOrdersRequired[$key] . '元][' . $paytype->getName() . ']');
$em->persist($opeLogger->getOpe());
$sculper->setAfter($opeLogger->getOpe());
$clue = new AvenueClue();
$clue->setUser($user)->setContent($sculper->getContent());
$em->persist($clue);
$em->flush();
// 存入rollback陣列
array_push($rRollback, $order->getId());
if ($product->getYahooId()) {
$successProducts[] = $product;
}
$returnSn .= "<a href=\"" . $this->get('router')->generate('goods_edit_v2', array('id' => $product->getId())) . "?iframe=true&width=100%&height=100%\" rel=\"prettyPhoto[iframes]\">" . $rGoodsSn[$key] . ($product->getColor() ? $product->getColor()->getName() : '') . '</a>,';
}
// Yahoo同步刪除
if (!empty($successProducts)) {
$adapter = $this->get('yahoo.syncer');
$adapter->delete($successProducts);
}
$em->getConnection()->commit();
} catch (Exception $e) {
$em->getConnection()->rollback();
throw $e;
}
if (empty($returnSn)) {
return new Response('<div class="alert alert-block alert-warning fade in">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4 class="alert-heading">此次操作無任何商品結帳完成</h4></div>');
} else {
return new Response('<div class="alert alert-block alert-success fade in">
<button type="button" class="close" data-dismiss="alert">×</button>
<h4 class="alert-heading">' . substr($returnSn, 0, -1) . '結帳完成, 合計' . $nTotal . '元</h4>
<a class="btn btn-primary" href="' . $this->get('router')->generate('invoice_print', array('id' => $invoice->getId(), 'page' => 1)) . '" target="_blank">銷貨單列印</a><button type="button" class="rollback btn btn-inverse" data-roll="' . json_encode($rRollback) . '">取消販售</button></div>');
}
}
/**
* 可累計的折扣購物金金額
*
* @return integer
*/
protected function stockPredict(Orders $order, BenefitRule $rule)
{
$turnLength = floor($order->getRequired() / $rule->getCeiling());
return $turnLength * $rule->getGift();
}
