/**
* @Route("/product/{id}", requirements={"id" = "\d+"}, name="front_product_show", options={"expose"=true})
* @ParamConverter("goods", class="WoojinGoodsBundle:GoodsPassport")
* @Template()
*/
public function productAction(Request $request, GoodsPassport $goods)
{
// if (!$goods->getIsAllowWeb() || !in_array($goods->getStatus()->getId(), array(Avenue::GS_ONSALE, Avenue::GS_SOLDOUT, Avenue::GS_ACTIVITY, Avenue::GS_BEHALF) )) {
// throw $this->createNotFoundException('The product does not exist');
// }
if (!$goods->getIsAllowWeb()) {
throw $this->createNotFoundException('The product does not exist');
}
$mobileDetector = $this->get('resolver.device');
$mobileDetector->setForce($request);
if ($mobileDetector->isM()) {
return $this->redirect($this->generateUrl('mobile_front_product', array('id' => $goods->getId())));
}
$historys = array();
$relatives = array();
$em = $this->getDoctrine()->getManager();
$relatives = $em->getRepository('WoojinGoodsBundle:GoodsPassport')->getRandOnSale(10);
$historyIds = json_decode($request->cookies->get('avenueHistory', '[]'), true);
$historyIds = array_unique($historyIds);
$historyIds = array_values($historyIds);
if (!empty($historyIds)) {
$qb = $em->createQueryBuilder();
$historys = $qb->select('g')->from('WoojinGoodsBundle:GoodsPassport', 'g')->where($qb->expr()->andX($qb->expr()->in('g.id', $historyIds), $qb->expr()->eq('g.isAllowWeb', true)))->groupBy('g.id')->getQuery()->getResult();
$returns = array();
for ($i = 0; $i < count($historys); $i++) {
$returns[$i] = null;
}
foreach ($historys as $key => $history) {
$pos = array_search($history->getId(), $historyIds);
if ($pos !== false) {
$returns[$pos] = $history;
}
}
$historys = $returns;
}
return array('goods' => $goods, 'relatives' => $relatives, 'historys' => $historys);
}
public function getYahooFormAction(GoodsPassport $product)
{
$router = $this->container->get('router');
return $product->getYahooId() ? $router->generate('admin_yahoo_update', array('id' => $product->getId())) : $router->generate('admin_yahoo_create', array('id' => $product->getId()));
}
protected function genArr(GoodsPassport $product)
{
$arr = array();
$arr['auth_key'] = 'jasodijQQ3Eoinaaoidll';
// GoodsPassport (分類???)
$arr['GoodsPassport']['id'] = $product->getId();
$arr['GoodsPassport']['status_id'] = $product->getStatus()->getId();
$arr['GoodsPassport']['source_id'] = $product->getSource() ? $product->getSource()->getId() : 0;
$arr['GoodsPassport']['img_id'] = $product->getImg() ? $product->getImg()->getId() : 0;
$arr['GoodsPassport']['level_id'] = $product->getLevel() ? $product->getLevel()->getId() : 0;
$arr['GoodsPassport']['inherit_id'] = $product->getParent()->getId();
$arr['GoodsPassport']['sn'] = $product->getSn();
$arr['GoodsPassport']['name'] = $product->getName();
$arr['GoodsPassport']['cost'] = $product->getCost();
$arr['GoodsPassport']['price'] = $product->getPrice();
$arr['GoodsPassport']['org_sn'] = $product->getOrgSn();
$arr['GoodsPassport']['memo'] = $product->getMemo();
$arr['GoodsPassport']['created_at'] = $product->getCreatedAt()->format('Y-m-d H:i:s');
$arr['GoodsPassport']['mt_id'] = $product->getMt() ? $product->getMt()->getId() : 0;
$arr['GoodsPassport']['activity_id'] = $product->getActivity() ? $product->getActivity()->getId() : 0;
$arr['GoodsPassport']['custom_id'] = $product->getCustom() ? $product->getCustom()->getId() : 0;
$arr['GoodsPassport']['brand_id'] = $product->getBrand() ? $product->getBrand()->getId() : 0;
//$arr['GoodsPassport']['color_id'] = $product->;
$arr['GoodsPassport']['pattern_id'] = $product->getPattern() ? $product->getPattern()->getId() : 0;
$arr['GoodsPassport']['colorSn'] = $product->getColorSn();
$arr['GoodsPassport']['model'] = $product->getModel();
$arr['GoodsPassport']['customSn'] = $product->getCustomSn();
$arr['GoodsPassport']['desimg_id'] = $product->getDesimg() ? $product->getDesimg()->getId() : 0;
$arr['GoodsPassport']['description_id'] = $product->getDescription() ? $product->getDescription()->getId() : 0;
$arr['GoodsPassport']['brief_id'] = $product->getBrief() ? $product->getBrief()->getId() : 0;
$arr['GoodsPassport']['store_id'] = $product->getStore() ? $product->getStore()->getId() : 0;
$arr['GoodsPassport']['promotion_id'] = $product->getPromotion() ? $product->getPromotion()->getId() : 0;
$arr['GoodsPassport']['is_allow_web'] = $product->getIsAllowWeb();
$arr['GoodsPassport']['update_at'] = $product->getUpdateAt() ? $product->getUpdateAt()->format('Y-m-d H:i:s') : null;
$arr['GoodsPassport']['web_price'] = $product->getWebPrice();
$arr['GoodsPassport']['categorys'] = array(0);
foreach ($product->getCategorys() as $category) {
$arr['GoodsPassport']['categorys'][] = $category->getId();
}
$i = 0;
// Orders
foreach ($product->getOrders() as $order) {
$arr['Orders'][$i]['id'] = $order->getId();
$arr['Orders'][$i]['goods_passport_id'] = $product->getId();
$arr['Orders'][$i]['pay_type_id'] = $order->getPayType() ? $order->getPayType()->getId() : 0;
$arr['Orders'][$i]['status_id'] = $order->getStatus()->getId();
$arr['Orders'][$i]['kind_id'] = $order->getKind()->getId();
$arr['Orders'][$i]['custom_id'] = $order->getCustom() ? $order->getCustom()->getId() : 0;
$arr['Orders'][$i]['memo'] = $order->getMemo();
$arr['Orders'][$i]['required'] = $order->getRequired();
$arr['Orders'][$i]['paid'] = $order->getPaid();
$arr['Orders'][$i]['relate_id'] = $order->getParent() ? $order->getParent()->getId() : 0;
$arr['Orders'][$i]['invoice_id'] = $order->getInvoice() ? $order->getInvoice()->getId() : 0;
$arr['Orders'][$i]['org_required'] = $order->getOrgRequired();
$arr['Orders'][$i]['org_paid'] = $order->getOrgPaid();
// Ope
$j = 0;
foreach ($order->getOpes() as $ope) {
//$arr['Ope'][]['orders_id'] = $order->get;
$arr['Ope'][$order->getId()][$j]['user_id'] = $ope->getUser() ? $ope->getUser()->getId() : 0;
$arr['Ope'][$order->getId()][$j]['act'] = $ope->getAct();
$arr['Ope'][$order->getId()][$j]['datetime'] = $ope->getDatetime()->format('Y-m-d H:i:s');
$arr['Ope'][$order->getId()][$j]['memo'] = $ope->getMemo();
$j++;
}
$i++;
}
return $arr;
}
protected function createGoodsUpdateMsg(GoodsPassport $goods, $sn, $cost, $price, $model, $createAt)
{
$msgArr = array('title' => 'update-goods', 'id' => $goods->getId(), 'sn' => array($goods->getSn(), $sn), 'cost' => array($goods->getCost(), $cost), 'price' => array($goods->getPrice(), $price), 'model' => array($goods->getModel(), $model));
return json_encode($msgArr);
}
public function fetchAuctionsByProduct(GoodsPassport $product)
{
$qb = $this->getEntityManager()->createQueryBuilder();
return $qb->select('auction')->from('WoojinStoreBundle:Auction', 'auction')->where($qb->expr()->eq('auction.product', $product->getId()))->orderBy('auction.id', 'DESC')->getQuery()->getResult();
}
