public function create($elementType, $element) { $element = $this->restrictFields($element); $taxName = $this->getNewTaxName(); $element['taxname'] = $taxName; $element['deleted'] = 0; $createdElement = parent::create($elementType, $element); $sql = "alter table vtiger_inventoryproductrel add column {$taxName} decimal(7,3)"; $result = $this->pearDB->pquery($sql, array()); if (!is_object($result)) { list($typeId, $id) = vtws_getIdComponents($element['id']); $this->dropRow($id); throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while adding tax column({$taxName}) for inventory lineitem table"); } return $createdElement; }
public function create($elementType, $element) { $db = PearDatabase::getInstance(); $sql = 'select * from vtiger_organizationdetails'; $result = $db->pquery($sql, $params); $rowCount = $db->num_rows($result); if ($rowCount > 0) { $id = $db->query_result($result, 0, 'organization_id'); $meta = $this->getMeta(); $element['id'] = vtws_getId($meta->getEntityId(), $id); return $this->revise($element); } else { $element = $this->handleFileUpload($element); return parent::create($elementType, $element); } }
public function create($elementType, $element) { $db = PearDatabase::getInstance(); $sql = 'SELECT * FROM vtiger_producttaxrel WHERE productid =? AND taxid=?'; list($typeId, $productId) = vtws_getIdComponents($element['productid']); list($typeId, $taxId) = vtws_getIdComponents($element['taxid']); $params = array($productId, $taxId); $result = $db->pquery($sql, $params); $rowCount = $db->num_rows($result); if ($rowCount > 0) { $id = $db->query_result($result, 0, $this->meta->getObectIndexColumn()); $meta = $this->getMeta(); $element['id'] = vtws_getId($meta->getEntityId(), $id); return $this->update($element); } else { unset($element['id']); return parent::create($elementType, $element); } }
public function _create($elementType, $element) { $createdElement = parent::create($elementType, $element); $productId = vtws_getIdComponents($element['productid']); $productId = $productId[1]; $parentTypeHandler = vtws_getModuleHandlerFromId($element['parent_id'], $this->user); $parentTypeMeta = $parentTypeHandler->getMeta(); $parentType = $parentTypeMeta->getEntityName(); $parent = $this->getParentById($element['parent_id']); if ($parentType != 'PurchaseOrder') { //update the stock with existing details updateStk($productId, $element['quantity'], '', array(), $parentType); } $this->initTax($element, $parent); $this->updateTaxes($createdElement); $createdElement['incrementondel'] = '1'; if (strcasecmp($parent['hdnTaxType'], $this->Individual) === 0) { $createdElement = $this->appendTaxInfo($createdElement); } return $createdElement; }