<?php 
class Notification{ 

  const LEAD_MAIL = "[from] email [target]."; //clarence email juan cruz
  const LEAD_CALL = "[from] call [target]."; //clarence call juan cruz
  const LEAD_SMS = "[from] send sms to [target]."; //clarence send sms to juan cruz
  const LEAD_INACTIVE = "[from] tag [target] as inactive."; //clarence tag juan cruz as inactive
  const LEAD_NOTE = "[from] added a note to [target].";  //clarence added a note to juan cruz
  const LEAD_PROGRESS = "[from] change status of [target] to %s."; //clarence change status os juan cruz to cold

    function add($type_id,$from_id,$to_id,$target_id,$description,$utility_class,$db){
        $query = "INSERT INTO `lms2_notification_list`(`notification_type_id`, `from_user`, `to_user`, `target_id`, `description`, `date_added`, `is_read`, `status`) 
        VALUES ($type_id,$from_id,$to_id,$target_id,'$description',NOW(),0,1)";

      return $db->sql_query_affected_rows($query);
    }

}
?>