Here is my logic hook; called before save
PHP Code:
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class chkEnquiryNumber {
function enquiryNumber(&$focus, $event, $arguments) {
global $current_user;
if($focus->enquiry_number_c!="" && $_POST['record']=="")
{ //your code: chk for enquiry number
$query = "SELECT id_c FROM leads_cstm WHERE enquiry_number_c = '{$focus->enquiry_number_c}'";
$result = $focus->db->query($query, true);
if($focus->db->getRowCount($result) != 0)
{
//record is alrady present.
$obj = loadBean('Leads');
$obj->retrieve($focus->id);
//if($obj->name != '') {
$_REQUEST['return_action'] = 'EditView';
$_REQUEST['return_record'] = $focus->id;
//}
//return false;
}
}
else {die('in else');}
}//function
}//class
Bookmarks