80 lines
2.6 KiB
PHP
80 lines
2.6 KiB
PHP
|
<?php
|
||
|
|
/*+********************************************************************************
|
||
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
||
|
|
* ("License"); You may not use this file except in compliance with the License
|
||
|
|
* The Original Code is: vtiger CRM Open Source
|
||
|
|
* The Initial Developer of the Original Code is vtiger.
|
||
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
||
|
|
* All Rights Reserved.
|
||
|
|
*********************************************************************************/
|
||
|
|
|
||
|
|
require_once('include/logging.php');
|
||
|
|
require_once('include/database/PearDatabase.php');
|
||
|
|
global $adb,$mod_strings;
|
||
|
|
|
||
|
|
$local_log =& LoggerManager::getLogger('AccountsAjax');
|
||
|
|
global $currentModule;
|
||
|
|
$modObj = CRMEntity::getInstance($currentModule);
|
||
|
|
|
||
|
|
$ajaxaction = $_REQUEST["ajxaction"];
|
||
|
|
if($ajaxaction == "DETAILVIEW")
|
||
|
|
{
|
||
|
|
$crmid = $_REQUEST["recordid"];
|
||
|
|
$tablename = $_REQUEST["tableName"];
|
||
|
|
$fieldname = $_REQUEST["fldName"];
|
||
|
|
$fieldvalue = utf8RawUrlDecode($_REQUEST["fieldValue"]);
|
||
|
|
if($crmid != "")
|
||
|
|
{
|
||
|
|
$modObj->retrieve_entity_info($crmid,"Accounts");
|
||
|
|
$modObj->column_fields[$fieldname] = $fieldvalue;
|
||
|
|
if($fieldname=='accountname'){
|
||
|
|
$value = $fieldvalue;
|
||
|
|
$query = "SELECT accountname FROM vtiger_account,vtiger_crmentity WHERE accountname =? and vtiger_account.accountid = vtiger_crmentity.crmid and vtiger_crmentity.deleted != 1";
|
||
|
|
$params = array($value);
|
||
|
|
if(isset($crmid) && $crmid !='') {
|
||
|
|
$query .= " and vtiger_account.accountid != ?";
|
||
|
|
array_push($params, $crmid);
|
||
|
|
}
|
||
|
|
$result = $adb->pquery($query, $params);
|
||
|
|
if($adb->num_rows($result) > 0)
|
||
|
|
{
|
||
|
|
echo ":#:ERR".$mod_strings['LBL_ACCOUNT_EXIST'];
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if($fieldname=='accountname'){
|
||
|
|
$value = $fieldvalue;
|
||
|
|
$query = "SELECT accountname FROM vtiger_account,vtiger_crmentity WHERE accountname =? and vtiger_account.accountid = vtiger_crmentity.crmid and vtiger_crmentity.deleted != 1";
|
||
|
|
$params = array($value);
|
||
|
|
if(isset($crmid) && $crmid !='') {
|
||
|
|
$query .= " and vtiger_account.accountid != ?";
|
||
|
|
array_push($params, $crmid);
|
||
|
|
}
|
||
|
|
$result = $adb->pquery($query, $params);
|
||
|
|
if($adb->num_rows($result) > 0)
|
||
|
|
{
|
||
|
|
echo ":#:ERR".$mod_strings['LBL_ACCOUNT_EXIST'];
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$modObj->id = $crmid;
|
||
|
|
$modObj->mode = "edit";
|
||
|
|
$modObj->save("Accounts");
|
||
|
|
|
||
|
|
if($modObj->id != "")
|
||
|
|
{
|
||
|
|
echo ":#:SUCCESS";
|
||
|
|
}else
|
||
|
|
{
|
||
|
|
echo ":#:FAILURE";
|
||
|
|
}
|
||
|
|
}else
|
||
|
|
{
|
||
|
|
echo ":#:FAILURE";
|
||
|
|
}
|
||
|
|
}elseif($ajaxaction == "LOADRELATEDLIST" || $ajaxaction == "DISABLEMODULE"){
|
||
|
|
require_once 'include/ListView/RelatedListViewContents.php';
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|