function toSoftone() { //if ($this->reference) global $kernel; if ('AppCache' == get_class($kernel)) { $kernel = $kernel->getKernel(); } $em = $kernel->getContainer()->get('doctrine.orm.entity_manager'); $object = "ITEM"; $softone = new Softone(); //$fields = $softone->retrieveFields($object, $params["list"]); echo $softone->appId; $fields[] = "item_code"; $fields[] = "item_name"; $fields[] = "item_code1"; $fields[] = "item_code2"; $fields[] = "item_name1"; $fields[] = "item_mtrunit1"; $fields[] = "item_pricew"; $fields[] = "item_pricer"; $fields[] = "item_pricew01"; $fields[] = "item_pricer01"; $fields[] = "item_pricew02"; $fields[] = "item_pricew03"; $fields[] = "item_pricer02"; $fields[] = "item_vat"; $fields[] = "item_mtrmanfctr"; $fields[] = "item_mtrplace"; $fields[] = "item_apvcode"; $fields[] = "item_isactive"; //$fields[] = "item_mtrsup"; $fields[] = "item_mtrcategory"; $fields[] = "item_markupw"; $fields[] = "item_isactive"; $fields[] = "item_mtrmark"; $fields[] = "item_cccfxreltdcode"; $fields[] = "item_cccfxrelbrand"; //print_r($fields); //return; $objectArr = array(); $objectArr2 = array(); if ($this->reference > 0) { $data = $softone->getData($object, $this->reference); $objectArr = $data->data->{$object}; $objectArr2 = (array) $objectArr[0]; } else { $filters = $object . ".CODE=" . $this->itemCode . "&" . $object . ".CODE_TO=" . $this->itemCode; $datas = $softone->retrieveData($object, "partsbox", $filters); foreach ($datas as $data) { $data = (array) $data; $zoominfo = $data["zoominfo"]; $info = explode(";", $zoominfo); $this->reference = $info[1]; break; } $data = $softone->getData($object, $this->reference); $objectArr = $data->data->{$object}; $objectArr2 = (array) $objectArr[0]; } foreach ($fields as $field) { $field1 = strtoupper(str_replace(strtolower($object) . "_", "", $field)); $field2 = lcfirst($this->createName($field)); //echo $field2 . "<BR>"; @($objectArr2[$field1] = $this->{$field2}); //} } $objectArr2["MTRUNIT1"] = 101; $objectArr2["VAT"] = 1310; $objectArr2["CODE2"] = $this->supplierCode; $objectArr2["ISACTIVE"] = $this->itemIsactive; $objectArr2["MTRMANFCTR"] = $this->itemMtrmanfctr > 0 ? $this->itemMtrmanfctr : 1000; $objectArr[0] = $objectArr2; $dataOut[$object] = (array) $objectArr; //@$dataOut["ITEEXTRA"][0] = array("NUM02" => $this->item_mtrl_iteextra_num02); //print_r(@$dataOut); $out = $softone->setData((array) $dataOut, $object, (int) $this->reference); //print_r($out); if (@$out->id > 0) { $this->reference = $out->id; $em->persist($this); $em->flush(); $this->itemMtrmark = $this->itemMtrmark > 0 ? $this->itemMtrmark : 1000; $this->itemMtrmanfctr = $this->itemMtrmanfctr > 0 ? $this->itemMtrmanfctr : 1000; $params["fSQL"] = "UPDATE MTRL SET MTRMANFCTR=" . $this->itemMtrmanfctr . " , MTRMARK=" . $this->itemMtrmark . " WHERE MTRL = " . $this->reference; print_r($softone->createSql($params)); } }
function saveProductSoftone($model) { $object = "ITEM"; $softone = new Softone(); //$fields = $softone->retrieveFields($object, $params["list"]); $fields[] = "item_code"; $fields[] = "item_name"; $fields[] = "item_code1"; $fields[] = "item_code2"; $fields[] = "item_name1"; $fields[] = "item_mtrunit1"; $fields[] = "item_pricew"; $fields[] = "item_pricer"; $fields[] = "item_pricew01"; $fields[] = "item_pricer01"; $fields[] = "item_pricew02"; $fields[] = "item_pricew03"; $fields[] = "item_pricer02"; $fields[] = "item_vat"; $fields[] = "item_mtrmanfctr"; $fields[] = "item_mtrplace"; $fields[] = "item_isactive"; //$fields[] = "item_mtrsup"; $fields[] = "item_mtrcategory"; $fields[] = "item_markupw"; $fields[] = "item_isactive"; $fields[] = "item_cccfxreltdcode"; $fields[] = "item_cccfxrelbrand"; //print_r($fields); //return; //echo 'sss'; if ($model->reference) { $data = $softone->getData($object, $model->reference); $objectArr = $data->data->{$object}; $objectArr2 = (array) $objectArr[0]; foreach ($fields as $field) { $field1 = strtoupper(str_replace(strtolower($object) . "_", "", $field)); $objectArr2[$field1] = $model->getField($field); //} } $objectArr2["CODE2"] = $model->supplier_code; $objectArr2["ISACTIVE"] = $model->item_isactive; $objectArr2["PRICER01"] = $objectArr2["PRICEW01"] * 1.23; $objectArr2["PRICER02"] = $objectArr2["PRICEW02"] * 1.23; $objectArr[0] = $objectArr2; $dataOut[$object] = (array) $objectArr; $dataOut["ITEEXTRA"][0] = array("NUM02" => $model->item_mtrl_iteextra_num02); //print_r($dataOut); $out = $softone->setData((array) $dataOut, $object, $model->reference); //print_r($out); } else { $objectArr = array(); foreach ($fields as $field) { $field1 = strtoupper(str_replace(strtolower($object) . "_", "", $field)); $as = explode("_", $field); $asf = $as[0] . ucfirst($as[1]); $objectArr2[$field1] = $model->getField($asf); } $objectArr2["MTRUNIT1"] = 101; //$model->supplierCode; //$objectArr2["ISACTIVE"] = $model->item_isactive; $objectArr2["PRICER01"] = $objectArr2["PRICEW01"] * 1.23; $objectArr2["PRICER02"] = $objectArr2["PRICEW02"] * 1.23; $objectArr[0] = $objectArr2; $dataOut[$object] = (array) $objectArr; //$dataOut["ITEEXTRA"][0] = array("NUM02" => $model->item_mtrl_iteextra_num02); //print_r($dataOut); $out = $softone->setData((array) $dataOut, $object, (int) $model->reference); if ($out->id > 0) { $model->setField("reference", $out->id); @$this->flushpersist($model); } //print_r($out); } return $model; }
function toSoftone() { //if ($this->reference) global $kernel; if ('AppCache' == get_class($kernel)) { $kernel = $kernel->getKernel(); } $em = $kernel->getContainer()->get('doctrine.orm.entity_manager'); $object = "CUSTOMER"; $softone = new Softone(); $fields = $softone->retrieveFields($object, "partsbox"); //echo $this->reference . "\n"; //print_r($fields); $objectArr = array(); $objectArr2 = array(); if ((int) $this->reference > 0) { $data = $softone->getData($object, $this->reference); //print_r($data); $objectArr = $data->data->{$object}; //print_r($objectArr); $objectArr2 = (array) $objectArr[0]; } else { $filters = "CUSTOMER.CODE=" . $this->customerCode . "&CUSTOMER.CODE_TO=" . $this->customerCode; $datas = $softone->retrieveData($object, "partsbox", $filters); foreach ($datas as $data) { $data = (array) $data; $zoominfo = $data["zoominfo"]; $info = explode(";", $zoominfo); $this->reference = $info[1]; break; } $data = $softone->getData($object, $this->reference); $objectArr = $data->data->{$object}; $objectArr2 = (array) $objectArr[0]; } foreach ($fields as $field) { $field1 = strtoupper(str_replace(strtolower($object) . "_", "", $field)); $field2 = lcfirst($this->createName($field)); //echo $field2 . "<BR>"; @($objectArr2[$field1] = $this->{$field2}); //} } $objectArr[0] = $objectArr2; $dataOut[$object] = (array) $objectArr; //@$dataOut["ITEEXTRA"][0] = array("NUM02" => $this->item_mtrl_iteextra_num02); //print_r(@$dataOut); $out = $softone->setData((array) $dataOut, $object, (int) $this->reference); //print_r($out); if (@$out->id > 0) { $filters = "CUSTOMER.CODE=" . $this->customerCode . "&CUSTOMER.CODE_TO=" . $this->customerCode; $datas = $softone->retrieveData($object, "partsbox", $filters); foreach ($datas as $data) { $data = (array) $data; $zoominfo = $data["zoominfo"]; $info = explode(";", $zoominfo); $this->reference = $info[1]; break; } if ($this->reference > 0) { $em->persist($this); $em->flush(); } } }