Staff control their own sms email settings.
I did not add it to the admin panel or admin add staff.
Add a column to the ost_staff table called smsemail of type varchar(60)
I just used mysql workbench to do it.
or sql:
alter table ost_osticket.ost_staff add column smsemail varchar (60) ;
The code below to send the email can be adapted to any notice/alert to make it send an sms just paste it to the appropriate position and edit as needed.
My changes are between the //storm tags.
include\class.ticket.php
//Send the alerts.
$sentlist=array();
foreach( $recipients as $k=>$staff) {
if(!is_object($staff) || !$staff->isAvailable() || in_array($staff->getEmail(), $sentlist)) continue;
$alert = str_replace('%{recipient}', $staff->getFirstName(), $msg);
$email->sendAlert($staff->getEmail(), $msg, $alert);
//storm start send the sms
$sql='SELECT smsemail FROM '.STAFF_TABLE.
' WHERE staff_id=' .db_input($staff->getId());
if(($hmmm=db_query($sql)) && list($eaddy)=db_fetch_row($hmmm)){
$email->sendAlert($eaddy,"sms",$msg);
}
//storm end
support\include\class.staff.php
line ~ 450
$sql='UPDATE '.STAFF_TABLE.' SET updated=NOW() '
.' ,firstname='.db_input($vars)
.' ,lastname='.db_input($vars)
.' ,email='.db_input($vars)
.' ,phone="'.db_input(Format:($vars),false).'"'
.' ,phone_ext='.db_input($vars)
.' ,mobile="'.db_input(Format:($vars),false).'"'
.' ,signature='.db_input($vars)
.' ,timezone_id='.db_input($vars)
.' ,daylight_saving='.db_input(isset($vars)?1)
.' ,show_assigned_tickets='.db_input(isset($vars)?1)
.' ,max_page_size='.db_input($vars)
.' ,auto_refresh_rate='.db_input($vars)
.' ,default_signature_type='.db_input($vars)
.' ,default_paper_size='.db_input($vars)
//storm start
.' ,smsemail='.db_input($vars);
//storm end
include\staff\profile.inc.php
<td width="180">
Mobile Number:
</td>
<td>
<input type="text" size="22" name="mobile" value="<?php echo $info; ?>">
<span class="error"> <?php echo $errors; ?></span>
</td>
</tr>
// storm start
<tr>
<td valign="top">SMS Email:</td>
<td><textarea name="smsemail" cols="21" rows="1" style="width: 60%;"><?=$info?></textarea></td>
</tr>
// storm end