New Message Alert for All Department Members in osTicket v1.6 RC5

This following modification is being intended to answer the question on osTicket Discussion Forum that asking about the title of this article. If you want your osTicket also send an alert to all department members when new message comes to the system, then you may use this following modification I created.

1. First of all, you have to alter the ost_config table by adding a new field named message_alert_dept_members. You may use this SQL script from phpMyAdmin or your another MySQL tool:

   ALTER TABLE ost_config 
   ADD COLUMN `message_alert_dept_members` tinyint(1) default 0 NOT NULL;

2. Open your \include\staff\preference.inc.php file, and find this code:

   425	<input type="checkbox" name="message_alert_dept_manager" <?=$config['message_alert_dept_manager']?'checked':''?>> Department Manager (spammy)

   after that line, please insert this following code:

   426	<input type="checkbox" name="message_alert_dept_members" <?=$config['message_alert_dept_members']?'checked':''?>> Department Members (spammy)

3. Open your \include\class.config.php file, and find this code:

   306 307 308

   function alertDeptManagerONNewMessage() { return $this->config['message_alert_dept_manager']?true:false; }

   after the last line of that code above, please insert this following code:

   310 311 312 313

   // MOD Alert Dept Members on New Message, added by Masino Sinaga, October 23, 2009 function alertDeptMembersONNewMessage() { return $this->config['message_alert_dept_members']?true:false; }

   Find again this code:

   469 470 471 472

   if($var['message_alert_active'] && (!isset($var['message_alert_laststaff']) && !isset($var['message_alert_assigned']) && !isset($var['message_alert_dept_manager']))){

   then replace with this following code:

   469 470 471 472 473

   if($var['message_alert_active'] && (!isset($var['message_alert_laststaff']) && !isset($var['message_alert_assigned']) && !isset($var['message_alert_dept_manager']) && !isset($var['message_alert_dept_members']))){ // added by Masino Sinaga, Oct 23, 2009

   Find again this code:

   532	',message_alert_dept_manager='.db_input(isset($var['message_alert_dept_manager'])?1:0).

   then replace with this following code:

   532 533

   ',message_alert_dept_manager='.db_input(isset($var['message_alert_dept_manager'])?1:0). ',message_alert_dept_members='.db_input(isset($var['message_alert_dept_members'])?1:0). // added by Masino Sinaga, Oct 23, 2009

4. Open your \include\class.ticket.php file, and find this code:

   659 660 661

   //Dept manager if($cfg->alertDeptManagerONNewMessage() && $dept) $recipients[]=$dept->getManager();

   after the last line of that code, please insert this following code:

   662 663 664 665 666 667 668 669

   //Dept members, added by Masino Sinaga, Oct 23, 2009 if($cfg->alertDeptMembersONNewMessage() && $dept) { $sql='SELECT staff_id FROM '.STAFF_TABLE.' WHERE onvacation=0 AND dept_id='.db_input($dept->getId()); if(($users=db_query($sql)) && db_num_rows($users)) { while(list($id)=db_fetch_row($users)) $recipients[]= new Staff($id); } }

That’s all. Let me know your feedback. Hope it helps you and good luck!