public function showSMSqueue()
{
$smsPath = 'content/tsms/';
$tsms_host = $this->settings['WATCHDOG_TSMS_GATEWAY'];
$tsms_db = 'users';
$tsms_login = $this->settings['WATCHDOG_TSMS_LOGIN'];
$tsms_password = $this->settings['WATCHDOG_TSMS_PASSWORD'];
$tsms_table = $this->settings['WATCHDOG_TSMS_LOGIN'];
$smsArray = array();
$TsmsDB = new DbConnect($tsms_host, $tsms_login, $tsms_password, $tsms_db, $error_reporting = true, $persistent = false);
$TsmsDB->open() or die($TsmsDB->error());
$TsmsDB->query('SET NAMES utf8;');
if (wf_CheckPost(array('showdate'))) {
$date = mysql_real_escape_string($_POST['showdate']);
} else {
$date = '';
}
if (!empty($date)) {
$where = " WHERE `send_time` LIKE '" . $date . "%' ORDER BY `id` DESC;";
} else {
$where = ' ORDER BY `id` DESC LIMIT 50;';
}
$query = "SELECT * from `" . $tsms_table . "`" . $where;
$TsmsDB->query($query);
while ($row = $TsmsDB->fetchassoc()) {
$smsArray[] = $row;
}
//close old datalink
$TsmsDB->close();
//rendering result
$inputs = wf_DatePickerPreset('showdate', curdate());
$inputs .= wf_Submit(__('Show'));
$dateform = wf_Form("", 'POST', $inputs, 'glamour');
$lighter = 'onmouseover="this.className = \'row2\';" onmouseout="this.className = \'row3\';" ';
$cells = wf_TableCell(__('ID'));
$cells .= wf_TableCell(__('Msg ID'));
$cells .= wf_TableCell(__('Mobile'));
$cells .= wf_TableCell(__('Sign'));
$cells .= wf_TableCell(__('Message'));
$cells .= wf_TableCell(__('WAP'));
$cells .= wf_TableCell(__('Cost'));
$cells .= wf_TableCell(__('Send time'));
$cells .= wf_TableCell(__('Sended'));
$cells .= wf_TableCell(__('Status'));
$rows = wf_TableRow($cells, 'row1');
if (!empty($smsArray)) {
foreach ($smsArray as $io => $each) {
$cells = wf_TableCell($each['id']);
$cells .= wf_TableCell($each['msg_id']);
$cells .= wf_TableCell($each['number']);
$cells .= wf_TableCell($each['sign']);
$msg = wf_modal(__('Show'), __('SMS'), $each['message'], '', '300', '200');
$cells .= wf_TableCell($msg);
$cells .= wf_TableCell($each['wappush']);
$cells .= wf_TableCell($each['cost']);
$cells .= wf_TableCell($each['send_time']);
$cells .= wf_TableCell($each['sended']);
$cells .= wf_TableCell($each['status']);
$rows .= wf_tag('tr', false, 'row3', $lighter);
$rows .= $cells;
$rows .= wf_tag('tr', true);
}
}
$result = $dateform;
$result .= wf_TableBody($rows, '100%', '0', 'sortable');
return $result;
}
function zb_AsteriskQuery($query)
{
global $asteriskHost, $asteriskDb, $asteriskTable, $asteriskLogin, $asteriskPassword, $asteriskCacheTime;
$asteriskDB = new DbConnect($asteriskHost, $asteriskLogin, $asteriskPassword, $asteriskDb, $error_reporting = true, $persistent = false);
$asteriskDB->open() or die($asteriskDB->error());
$result = array();
$asteriskDB->query('SET NAMES utf8;');
$asteriskDB->query($query);
while ($row = $asteriskDB->fetchassoc()) {
$result[] = $row;
}
$asteriskDB->close();
return $result;
}
/**
* Sends all sms storage via TurboSMS service
*
* @return void
*/
protected function turbosmsPushMessages()
{
$sign = $this->safeEscapeString($this->settings['TSMS_SIGN']);
//time shift settings
$timezone = '2';
$tz_offset = (2 - $timezone) * 3600;
$date = date("Y-m-d H:i:s", time() + $tz_offset);
$allSmsQueue = $this->smsQueue->getQueueData();
if (!empty($allSmsQueue)) {
//open new database connection
$TsmsDB = new DbConnect($this->settings['TSMS_GATEWAY'], $this->settings['TSMS_LOGIN'], $this->settings['TSMS_PASSWORD'], 'users', $error_reporting = true, $persistent = false);
$TsmsDB->open() or die($TsmsDB->error());
$TsmsDB->query('SET NAMES utf8;');
foreach ($allSmsQueue as $eachsms) {
if (isset($eachsms['number']) and isset($eachsms['message'])) {
$query = "INSERT INTO `" . $this->settings['TSMS_LOGIN'] . "` ( `number`, `sign`, `message`, `wappush`, `send_time`) VALUES\n ('" . $eachsms['number'] . "', '" . $sign . "', '" . $eachsms['message'] . "', '', '" . $date . "');\n ";
//push new sms to database
$TsmsDB->query($query);
}
//remove old sent message
$this->smsQueue->deleteSms($eachsms['filename']);
}
//close old datalink
$TsmsDB->close();
}
}
function tsms_query($query)
{
global $tsms_host, $tsms_db, $tsms_login, $tsms_password, $tsms_table;
$TsmsDB = new DbConnect($tsms_host, $tsms_login, $tsms_password, $tsms_db, $error_reporting = true, $persistent = false);
$TsmsDB->open() or die($TsmsDB->error());
$result = array();
$TsmsDB->query('SET NAMES utf8;');
$TsmsDB->query($query);
while ($row = $TsmsDB->fetchassoc()) {
$result[] = $row;
}
$TsmsDB->close();
return $result;
}
