/** * @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 gettabs($id) { $entity = $this->getDoctrine()->getRepository('SoftoneBundle:Product')->find($id); if ($id == 0 and @$entity->id == 0) { $entity = new Product(); } $customer = $this->getDoctrine()->getRepository('SoftoneBundle:Customer')->find(1); echo $entity->getGroupedDiscount($customer); $entity->updatetecdoc(); $fields["title"] = array("label" => "Title", "required" => true, "className" => "col-md-6 col-sm-6"); $fields["erpCode"] = array("label" => "Erp Code", "required" => true, "className" => "col-md-6 col-sm-6"); $fields["tecdocSupplierId"] = array("label" => "Tecdoc Supplier", "required" => true, "className" => "col-md-6", 'type' => "select", 'datasource' => array('repository' => 'SoftoneBundle:TecdocSupplier', 'name' => 'supplier', 'value' => 'id')); $fields["tecdocCode"] = array("label" => "Tecdoc Code", "required" => true, "className" => "col-md-6"); $fields["supplierId"] = array("label" => "Supplier", "className" => "col-md-6", 'type' => "select", "required" => true, 'datasource' => array('repository' => 'SoftoneBundle:SoftoneSupplier', 'name' => 'title', 'value' => 'id')); $fields["supplierCode"] = array("label" => "Supplier Code", "className" => "col-md-6", "required" => true); $fields["itemPricew"] = array("label" => "Wholesale Price", "className" => "col-md-3", "required" => true); $fields["itemPricer"] = array("label" => "Retail Price", "className" => "col-md-3", "required" => true); $fields["itemMarkupw"] = array("label" => "Wholesale Markup", "className" => "col-md-3", "required" => true); $fields["itemMarkupr"] = array("label" => "Retail Markup", "className" => "col-md-3", "required" => true); $forms = $this->getFormLyFields($entity, $fields); if ($id > 0 and count($entity) > 0) { $entity2 = $this->getDoctrine()->getRepository('SoftoneBundle:Product')->find($id); $entity2->setReference(""); $fields2["reference"] = array("label" => "Erp Code", "className" => "synafiacode col-md-12"); $forms2 = $this->getFormLyFields($entity2, $fields2); $dtparams[] = array("name" => "ID", "index" => 'id', "active" => "active"); $dtparams[] = array("name" => "Title", "index" => 'title'); $dtparams[] = array("name" => "Code", "index" => 'erpCode'); $dtparams[] = array("name" => "Price", "index" => 'itemPricew01'); $params['dtparams'] = $dtparams; $params['id'] = $dtparams; $params['url'] = '/product/getrelation/' . $id; $params['key'] = 'gettabs_' . $id; $params["ctrl"] = 'ctrlgettabs'; $params["app"] = 'appgettabs'; $datatables[] = $this->contentDatatable($params); } $tabs[] = array("title" => "General", "datatables" => array(), "form" => $forms, "content" => '', "index" => $this->generateRandomString(), 'search' => 'text', "active" => true); if ($id > 0 and count($entity) > 0) { $tabs[] = array("title" => "Retaltions", "datatables" => $datatables, "form" => $forms2, "content" => '', "index" => $this->generateRandomString(), 'search' => 'text', "active" => true); } foreach ($tabs as $tab) { $this->addTab($tab); } $json = $this->tabs(); return $json; }