AppGini Community Forums

Code: Select all

	function Appointments_before_insert(&$data, $memberInfo, &$args){
		// Check if the Name and Surname exist in the WatchList. If yes insert an ALERT message to the Comments field
		// and show a warning alert message to the user
		$name=$data['Name'];
		$surname=$data['Surname'];
		$res=sql(
			"SELECT firstname, lastname " .
			"FROM WatchList WHERE " .
			"UPPER(FirstName) = UPPER('$name') and " .
			"UPPER(LastName) = UPPER('$surname')"
		, $eo);
		
		//Check if query brings up any results then show alert message and put a color coded message in the Comments field of the appointment and bring up the ALERT
		if(mysql_num_rows($res)){
			$data['Comments'] = '<b><font color="#E56717">***ALERT. Check Watch List for details!***.</font></b>' . $data['Comments'];
			do_alert("CAUTION:A person with the same Name and Surname was found in Watch List...");
		}
		return TRUE;
	}

Code: Select all

function do_alert($msg) 
    {
        echo '<script type="text/javascript">alert("' . $msg . '"); </script>';
    }

Code: Select all

function do_alert($msg)
{
        echo '<script>Modalbox.show("<div>' . addslashes($msg) . '</div>"); </script>';
}