/** * @Route("/product/createProduct") */ public function createProductAction(Request $request) { $json = json_encode(array("ok")); $asd = $this->getArticlesSearchByIds($request->request->get("ref")); $asd = $asd[0]; $json = json_encode($asd); $em = $this->getDoctrine(); $SoftoneSupplier = $this->getDoctrine()->getRepository("SoftoneBundle:SoftoneSupplier")->findOneBy(array('title' => $asd->brandName)); //echo $asd->brandName . " " . @(int) $SoftoneSupplier->id; if (@$SoftoneSupplier->id == 0) { $TecdocSupplier = $em->getRepository("SoftoneBundle:TecdocSupplier")->findOneBy(array('supplier' => $asd->brandName)); if (@$TecdocSupplier->id == 0) { $SoftoneSupplier = new \SoftoneBundle\Entity\SoftoneSupplier(); $SoftoneSupplier->setTitle($asd->brandName); $SoftoneSupplier->setCode(' '); @$this->flushpersist($SoftoneSupplier); $SoftoneSupplier->setCode("S" . $SoftoneSupplier->getId()); @$this->flushpersist($SoftoneSupplier); $SoftoneSupplier->toSoftone(); } else { $SoftoneSupplier = new \SoftoneBundle\Entity\SoftoneSupplier(); $SoftoneSupplier->setTitle($TecdocSupplier->getSupplier()); $SoftoneSupplier->setCode("T" . $TecdocSupplier->id); @$this->flushpersist($SoftoneSupplier); $SoftoneSupplier->toSoftone(); } } else { } $TecdocSupplier = $em->getRepository("SoftoneBundle:TecdocSupplier")->findOneBy(array('supplier' => $asd->brandName)); $erpCode = $this->clearstring($asd->articleNo) . "-" . $SoftoneSupplier->getCode(); $product = $em->getRepository("SoftoneBundle:Product")->findOneBy(array('erpCode' => $erpCode)); $json = array("error" => 1); if (@$product->id > 0) { $json = json_encode(array("error" => 0, "id" => (int) $product->id, 'returnurl' => '/product/view/' . (int) $product->id)); return new Response($json, 200, array('Content-Type' => 'application/json')); } $dt = new \DateTime("now"); $product = new \SoftoneBundle\Entity\Product(); $product->setSupplierCode($asd->articleNo); $product->setTitle($asd->genericArticleName); $product->setTecdocCode($asd->articleNo); $product->setItemMtrmark($TecdocSupplier->getId()); $product->setTecdocSupplierId($TecdocSupplier); $product->setSupplierId($SoftoneSupplier); $product->setItemName($asd->genericArticleName); $product->setTecdocArticleId($asd->articleId); //$product->setItemCode($this->partno); $product->setItemApvcode($asd->articleNo); $product->setErpSupplier($asd->brand); $product->setItemMtrmanfctr($SoftoneSupplier->getId()); $product->setErpCode($erpCode); $product->setItemCode($product->getErpCode()); $product->setItemV5($dt); $product->setTs($dt); $product->setItemInsdate($dt); $product->setItemUpddate($dt); $product->setCreated($dt); $product->setModified($dt); @$this->flushpersist($product); $product->updatetecdoc(); $product->setProductFreesearch(); $product->toSoftone(); $json = json_encode(array("error" => 0, "id" => (int) $product->id, 'returnurl' => '/product/view/' . (int) $product->id)); return new Response($json, 200, array('Content-Type' => 'application/json')); }
public function toErp() { global $kernel; if ('AppCache' == get_class($kernel)) { $kernel = $kernel->getKernel(); } $em = $kernel->getContainer()->get('doctrine.orm.entity_manager'); $this->updatetecdoc(); //$TecdocSupplier = new \SoftoneBundle\Entity\TecdocSupplier; //$TecdocSupplier->updateToSoftone(); $this->brand = $this->fixsuppliers($this->brand); $SoftoneSupplier = $em->getRepository("SoftoneBundle:SoftoneSupplier")->findOneBy(array('title' => $this->brand)); //echo $SoftoneSupplier->id; //exit; if (@$SoftoneSupplier->id == 0) { $TecdocSupplier = $em->getRepository("SoftoneBundle:TecdocSupplier")->findOneBy(array('supplier' => $this->brand)); if (@$TecdocSupplier->id == 0) { $SoftoneSupplier = new \SoftoneBundle\Entity\SoftoneSupplier(); $SoftoneSupplier->setTitle($this->brand); $SoftoneSupplier->setCode(' '); $em->persist($SoftoneSupplier); $em->flush(); $SoftoneSupplier->setCode("S" . $SoftoneSupplier->getId()); $em->persist($SoftoneSupplier); $em->flush(); $SoftoneSupplier->toSoftone(); } else { $SoftoneSupplier = new \SoftoneBundle\Entity\SoftoneSupplier(); $SoftoneSupplier->setTitle($TecdocSupplier->getSupplier()); $SoftoneSupplier->setCode("T" . $TecdocSupplier->id); $em->persist($SoftoneSupplier); $em->flush(); $SoftoneSupplier->toSoftone(); } } else { $SoftoneSupplier->toSoftone(); } /* $TecdocSuppliers = $em->getRepository("SoftoneBundle:TecdocSupplier")->findAll(); foreach($TecdocSuppliers as $TecdocSupplier) { $TecdocSupplier->toSoftone(); } */ $TecdocSupplier = $em->getRepository("SoftoneBundle:TecdocSupplier")->find($this->dlnr); $TecdocSupplier->toSoftone(); $erpCode = $this->clearCode($this->partno) . "-" . $SoftoneSupplier->getCode(); $product = $em->getRepository("SoftoneBundle:Product")->findOneBy(array("erpCode" => $erpCode)); if (@$product->id > 0) { //$product = $em->getRepository("SoftoneBundle:Product")->find($this->getProduct()); //if ($product->getReference() == 0) { $product->setItemMtrmanfctr($SoftoneSupplier->getId()); $product->setErpCode($this->clearCode($this->partno) . "-" . $SoftoneSupplier->getCode()); $product->setItemCode($product->getErpCode()); $product->setCars($this->getCars()); $product->setCats($this->getCats()); $em->persist($product); $em->flush(); if ($TecdocSupplier) { $product->setTecdocSupplierId($TecdocSupplier); } $product->toSoftone(); echo $this->clearCode($this->partno) . "-" . $SoftoneSupplier->getCode(); return; } /* if ($this->getProduct() > 0) { if (!$product->getEdiId()) { $product->setEdi($this->getEdi()->getId()); $product->setEdiId($this->id); $em->persist($product); $em->flush(); $product->toSoftone(); return; } else { if (!$product->getEdis()) { $edis = array(); } else { $edis = unserialize($product->getEdis()); } $edis[] = $this->id; $edis[] = $product->getEdiId(); $edis = array_filter(array_unique($edis)); $product->setEdis(serialize($edis)); $em->persist($product); $em->flush(); $product->toSoftone(); return; } return; } * */ $dt = new \DateTime("now"); $product = new \SoftoneBundle\Entity\Product(); $product->setSupplierCode($this->partno); $product->setTitle($this->description); $product->setTecdocCode($this->artNr); $product->setItemMtrmark($this->dlnr); $product->setTecdocSupplierId($TecdocSupplier); $product->setSupplierId($SoftoneSupplier); $product->setTecdocCode($this->artNr); $product->setItemName($this->description); $product->setTecdocArticleId($this->tecdocArticleId); //$product->setItemCode($this->partno); $product->setItemApvcode($this->artNr); $product->setErpSupplier($this->brand); $product->setItemMtrmanfctr($SoftoneSupplier->getId()); $product->setErpCode($erpCode); $product->setItemCode($product->getErpCode()); $product->setEdi($this->getEdi()->getId()); $product->setEdiId($this->id); $product->setCars($this->getCars()); $product->setCats($this->getCats()); $product->setItemV5($dt); $product->setTs($dt); $product->setItemInsdate($dt); $product->setItemUpddate($dt); $product->setCreated($dt); $product->setModified($dt); $em->persist($product); $em->flush(); $product->updatetecdoc(); $product->toSoftone(); $this->updatetecdoc(); $this->setProduct($product->getId()); $em->persist($this); $em->flush(); return; }