AppGini Community Forums

Code: Select all

function TABLENAME_after_update($data, $memberInfo, &$args) {
	if ($data['status'] == 'COMPLETED') {
    		// your code to send the report/email etc.
	};
	return TRUE;
}

Code: Select all

	function incident_after_insert($data, $memberInfo, &$args){
	    

        foreach($data as $field => $value){
        $messageData .= "$field: $value \n";
    }
    $authName = sqlValue("select custom1 from membership_users where memberID='{$memberInfo['username']}'");
    
    $projectname = sqlValue("select name from project where project_id='{$data['project']}'");
    
    //***************************************************************************    
	// This code selects email addresses from the contacts table for a project where
	//the recipient is marked yes for notifications
	
        $response =sql("SELECT email_address FROM contacts WHERE notify = 'Yes' AND project = '{$data['project']}'",$eo);
        	while ($row = db_fetch_assoc($response)) {
	            $receipt[] = $row['email_address'];
	}
	//****************************************************************************	   
     
    $msgTEXT = "The following Incident Report was submitted by $authName.<br> This is a preliminary report, details may change."."

<p><strong>Project: </strong>$projectname
<p><strong>Date of incident: </strong>{$data['date']}
<p><strong>Time of incident: </strong>{$data['time']}
<p><strong>Type of Incident: </strong>{$data['type']}
<p><strong>Incident Summary: </strong>{$data['summary']}
<p><strong>How did it happen: </strong>{$data['how']}
<p><strong>Objects involved: </strong>{$data['object']}
<p><strong>What were people doing: </strong>{$data['activity']}
<p><strong>Behavior Based Safety Factor: </strong>{$data['bbs']}
<p><strong>BBS Comments: </strong>{$data['bbs_comments']}
<p><strong>Additional Comments: </strong>{$data['add_comments']}
<p><strong>Witnesses: </strong>{$data['witness']}
";
    
    
  	foreach ($receipt as $address){
    
    sendmail(array(
	
		// mail recipient
		'to' => $address,
		
		'name' => "",

		// subject
		'subject' => "An incident report has been submitted for " . sqlValue("select name from project where project_id='{$data['project']}'"),
		
		// message
		'message' => nl2br (stripcslashes($msgTEXT)),
        
    // sender address
        "From: [email protected]"
    ));
	}
    
    //end email code

		return TRUE;
	}