function vtws_addDefaultActorTypeEntity($actorName, $actorNameDetails, $withName = true) { $actorHandler = array('file' => 'include/Webservices/VtigerActorOperation.php', 'class' => 'VtigerActorOperation'); if ($withName == true) { vtws_addActorTypeWebserviceEntityWithName($actorName, $actorHandler['file'], $actorHandler['class'], $actorNameDetails); } else { vtws_addActorTypeWebserviceEntityWithoutName($actorName, $actorHandler['file'], $actorHandler['class'], $actorNameDetails); } }
Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (?,?)", array($fieldTypeId, 'PurchaseOrder')); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (?,?)", array($fieldTypeId, 'Quotes')); $fieldTypeId = $adb->getUniqueID("vtiger_ws_entity_fieldtype"); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype) VALUES (?,?,?,?);", array($fieldTypeId, 'vtiger_inventoryproductrel', 'incrementondel', "autogenerated")); $adb->getUniqueID("vtiger_inventoryproductrel"); Migration_Index_View::ExecuteQuery("UPDATE vtiger_inventoryproductrel_seq SET id=(select max(lineitem_id) from vtiger_inventoryproductrel);", array()); Migration_Index_View::ExecuteQuery("UPDATE vtiger_ws_entity SET handler_path='include/Webservices/LineItem/VtigerInventoryOperation.php',handler_class='VtigerInventoryOperation' where name in ('Invoice','Quotes','PurchaseOrder','SalesOrder');", array()); $purchaseOrderTabId = getTabid("PurchaseOrder"); $purchaseOrderAddressInformationBlockId = getBlockId($purchaseOrderTabId, "LBL_ADDRESS_INFORMATION"); $invoiceTabId = getTabid("Invoice"); $invoiceTabIdAddressInformationBlockId = getBlockId($invoiceTabId, "LBL_ADDRESS_INFORMATION"); Migration_Index_View::ExecuteQuery('UPDATE vtiger_field SET block=? where tabid=? and block=?;', array($invoiceTabIdAddressInformationBlockId, $invoiceTabId, $purchaseOrderAddressInformationBlockId)); vtws_addActorTypeWebserviceEntityWithName('Tax', 'include/Webservices/LineItem/VtigerTaxOperation.php', 'VtigerTaxOperation', array('fieldNames' => 'taxlabel', 'indexField' => 'taxid', 'tableName' => 'vtiger_inventorytaxinfo'), true); $webserviceObject = VtigerWebserviceObject::fromName($adb, 'Tax'); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_tables(webservice_entity_id,table_name) VALUES (?,?)", array($webserviceObject->getEntityId(), 'vtiger_inventorytaxinfo')); vtws_addActorTypeWebserviceEntityWithoutName('ProductTaxes', 'include/Webservices/LineItem/VtigerProductTaxesOperation.php', 'VtigerProductTaxesOperation', array()); $webserviceObject = VtigerWebserviceObject::fromName($adb, 'ProductTaxes'); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_tables(webservice_entity_id,table_name) VALUES (?,?)", array($webserviceObject->getEntityId(), 'vtiger_producttaxrel')); $fieldTypeId = $adb->getUniqueID("vtiger_ws_entity_fieldtype"); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype) VALUES (?,?,?,?);", array($fieldTypeId, 'vtiger_producttaxrel', 'productid', "reference")); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (?,?)", array($fieldTypeId, 'Products')); $fieldTypeId = $adb->getUniqueID("vtiger_ws_entity_fieldtype"); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype) VALUES (?,?,?,?);", array($fieldTypeId, 'vtiger_producttaxrel', 'taxid', "reference")); Migration_Index_View::ExecuteQuery("INSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (?,?)", array($fieldTypeId, 'Tax')); //-- //Changed Columns Display in List view of Leads $leadsFirstName = 'vtiger_leaddetails:firstname:firstname:Leads_First_Name:V'; $leadsLastName = 'vtiger_leaddetails:lastname:lastname:Leads_Last_Name:V'; Migration_Index_View::ExecuteQuery("UPDATE vtiger_cvcolumnlist SET columnname=? WHERE cvid=? AND columnindex=?", array($leadsFirstName, '1', '1')); Migration_Index_View::ExecuteQuery("UPDATE vtiger_cvcolumnlist SET columnname=? WHERE cvid=? AND columnindex=?", array($leadsLastName, '1', '2')); //Changed the Currency Symbol of Moroccan, Dirham to DH