/**
* @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;
}
