require_once 'include/database/PearDatabase.php'; global $adb; $local_log =& LoggerManager::getLogger('AccountsAjax'); global $currentModule; $acntObj = CRMEntity::getInstance($currentModule); $ajaxaction = $_REQUEST["ajxaction"]; if ($ajaxaction == "DETAILVIEW") { $crmid = $_REQUEST["recordid"]; $tablename = $_REQUEST["tableName"]; $fieldname = $_REQUEST["fldName"]; $fieldvalue = utf8RawUrlDecode($_REQUEST["fieldValue"]); if ($crmid != "") { $acntObj->retrieve_entity_info($crmid, "Accounts"); $acntObj->column_fields[$fieldname] = $fieldvalue; if ($fieldname == 'annual_revenue') { $acntObj->column_fields[$fieldname] = getConvertedPrice($fieldvalue); } $acntObj->id = $crmid; $acntObj->mode = "edit"; $acntObj->save("Accounts"); if ($acntObj->column_fields['notify_owner'] == 1) { sendNotificationToOwner('Accounts', &$acntObj); } if ($acntObj->id != "") { echo ":#:SUCCESS"; } else { echo ":#:FAILURE"; } } else { echo ":#:FAILURE"; }
/** Function used to save the Inventory product details for the passed entity * @param object reference $this - object reference to which we want to save the product details from REQUEST values where as the entity will be Purchase Order, Sales Order, Quotes or Invoice * @param string $module - module name * @param $update_prod_stock - true or false (default), if true we have to update the stock for PO only * @return void */ function saveInventoryProductDetails() { global $log; $log->debug("Entering into function saveInventoryProductDetails()."); global $app_strings; if ($this->mode == 'edit') { $inventarr = $this->getInventProInfo($this->id); // $update_productsql2 = "update ec_products set num = num +".$inventarr['quantity']." where productid =".$inventarr['productid']; // $this->db->query($update_productsql2); deleteInventoryProductDetails($this->id, ''); } $tot_no_prod = $_REQUEST['totalProductCount']; $prod_seq = 1; for ($i = 1; $i <= $tot_no_prod; $i++) { $prod_id = $_REQUEST['hdnProductId' . $i]; $qty = $_REQUEST['qty' . $i]; $listprice = $_REQUEST['listPrice' . $i]; $listprice = getConvertedPrice($listprice); //convert the listPrice into $ $comment = addslashes($_REQUEST['comment' . $i]); //if the product is deleted then we should avoid saving the deleted products if ($_REQUEST["deleted" . $i] == 1) { continue; } $query = "insert into ec_inventoryproductrel(id, productid, sequence_no, quantity, listprice, comment) values({$this->id}, {$prod_id} , {$prod_seq}, {$qty}, {$listprice}, '{$comment}')"; $prod_seq++; $this->db->query($query); } //we should update the netprice (subtotal), taxtype, group discount, S&H charge, S&H taxes, adjustment and total //netprice, group discount, taxtype, S&H amount, adjustment and total to entity table $updatequery = " update {$this->table_name} set "; $total = getConvertedPrice($_REQUEST['total']); //convert total to $ $updatequery .= " total='" . $total . "'"; $updatequery .= " where salesorderid={$this->id}"; $this->db->query($updatequery); $log->debug("Exit from function saveInventoryProductDetails()."); }