03-13-2021, 12:53 PM
I would like to perform webservice calls, but run the system validations when doing so. I remember we had special way of running the validations when performing webservices, but couldn't find it in the docs.
03-13-2021, 12:53 PM
03-13-2021, 02:40 PM
03-13-2021, 02:50 PM
Nice, couldn't find that through the search method in the wiki
03-15-2021, 08:23 AM
So this is not working for me. I refactored my webservice call from:
to
But that just created the asset, while I was using a duplicate serial no., which I prohibit in my custom validation function:
PHP Code:
$client->doCreate('Assets', $params);
PHP Code:
$client->doInvoke('CreateWithValidation', array('elementType' => 'Assets', 'element' => json_encode($params)));
PHP Code:
function isUniqueSerial($fieldname, $fieldvalue, $params, $entity) {
global $adb;
$recordid = $entity['record'] == '' ? 0 : $entity['record'];
$r = $adb->query("SELECT vtiger_assets.serialnumber
FROM vtiger_assets
INNER JOIN vtiger_crmentity ON vtiger_assets.assetsid = vtiger_crmentity.crmid
WHERE vtiger_assets.product = {$entity['product']}
AND vtiger_assets.serialnumber = '{$entity['serialnumber']}'
AND vtiger_assets.assetsid != {$recordid}
AND vtiger_crmentity.deleted = 0");
return $adb->num_rows($r) > 0 ? false : true;
}
03-15-2021, 12:04 PM
check if your function is being called and dump the parameters to see if the query is correct
03-15-2021, 05:12 PM
What query? Ah you mean the validation query. I already spot the issue. The validation receives webservice ID's, where when inside the application, it receives non-webservice regular ID's.
03-15-2021, 07:04 PM
great. adapt your code accordingly
03-15-2021, 08:20 PM
Done, works like a charm now, thanks for the help
03-16-2021, 09:44 AM
great!