protected function loadTickets($login)
{
$login = mysql_real_escape_string($login);
$query = "SELECT `id`,`date`,`status`,`text` from `ticketing` WHERE `to` IS NULL AND `replyid` IS NULL AND `from`='" . $login . "' ORDER BY `date` DESC";
$result = simple_queryall($query);
return $result;
}
/**
* Returns array of keys in ubstorage if they contains search pattern
*
* @param string $keypattern
* @return array
*/
function zb_StorageFindKeys($keypattern)
{
$keypattern = mysql_real_escape_string($keypattern);
$query = "SELECT `key` from `ubstorage` WHERE `key` LIKE '%" . $keypattern . "%'";
$result = simple_queryall($query);
return $result;
}
function web_MessagesShowPrevious($login)
{
$login = mysql_real_escape_string($login);
$query = "SELECT * from `ticketing` WHERE `to`='" . $login . "' AND `from`='NULL' AND `status`='1' ORDER BY `date` DESC";
$allmessages = simple_queryall($query);
$result = '<table width="100%" class="sortable">';
$result .= '
<tr class="row1">
<td>' . __('Date') . '</td>
<td>' . __('Text') . '</td>
</tr>
';
if (!empty($allmessages)) {
foreach ($allmessages as $io => $eachmessage) {
$result .= '
<tr class="row3">
<td>' . $eachmessage['date'] . '</td>
<td>' . $eachmessage['text'] . '</td>
</tr>
';
}
}
$result .= '</table>';
show_window(__('Previous messages'), $result);
}
/**
* Returns available time rules grid
*
* @return string
*/
public function renderList()
{
$messages = new UbillingMessageHelper();
$allTariffs = zb_TariffGetPricesAll();
$query = "SELECT * from `dshape_time` ORDER BY `id` ASC";
$allrules = simple_queryall($query);
$cells = wf_TableCell(__('ID'));
$cells .= wf_TableCell(__('Tariff'));
$cells .= wf_TableCell(__('Time from'));
$cells .= wf_TableCell(__('Time to'));
$cells .= wf_TableCell(__('Speed'));
$cells .= wf_TableCell(__('Actions'));
$rows = wf_TableRow($cells, 'row1');
if (!empty($allrules)) {
foreach ($allrules as $io => $eachrule) {
$rowClass = isset($allTariffs[$eachrule['tariff']]) ? 'row3' : 'sigdeleteduser';
$tariffControl = cfr('TARIFFSPEED') ? wf_Link('?module=tariffspeeds&tariff=' . $eachrule['tariff'], $eachrule['tariff'], false) : $eachrule['tariff'];
$cells = wf_TableCell($eachrule['id']);
$cells .= wf_TableCell($tariffControl);
$cells .= wf_TableCell($eachrule['threshold1']);
$cells .= wf_TableCell($eachrule['threshold2']);
$cells .= wf_TableCell($eachrule['speed']);
$actions = wf_JSAlert('?module=dshaper&delete=' . $eachrule['id'], web_delete_icon(), $messages->getDeleteAlert());
$actions .= wf_JSAlert('?module=dshaper&edit=' . $eachrule['id'], web_edit_icon(), $messages->getEditAlert());
$cells .= wf_TableCell($actions);
$rows .= wf_TableRow($cells, $rowClass);
}
}
$result = wf_TableBody($rows, '100%', '0', 'sortable');
return $result;
}
function zbs_AnnouncementsShow()
{
$query = "SELECT * from `zbsannouncements` WHERE `public`='1' ORDER by `id` DESC";
$all = simple_queryall($query);
$result = '';
if (!empty($all)) {
foreach ($all as $io => $each) {
if (!isset($_COOKIE['zbsanread_' . $each['id']])) {
$readControl = la_Link('?module=announcements&anmarkasread=' . $each['id'], la_img('iconz/anunread.gif', __('Mark as read'))) . ' ';
} else {
$readControl = la_Link('?module=announcements&anmarkasunread=' . $each['id'], la_img('iconz/anread.gif', __('Mark as unread'))) . ' ';
}
$result .= la_tag('h3', false, 'row1', '') . $readControl . $each['title'] . ' ' . la_tag('h3', true);
$result .= la_delimiter();
if ($each['type'] == 'text') {
$eachtext = strip_tags($each['text']);
$result .= nl2br($eachtext);
}
if ($each['type'] == 'html') {
$result .= $each['text'];
}
$result .= la_delimiter();
}
} else {
show_window(__('Sorry'), __('There are not any announcements.'));
}
show_window('', $result);
}
function paymaster_form($customer_id, $debug, $method, $action_url, $merchant_id, $lang, $good_url, $bad_url, $merchant_currency, $db, $tariff)
{
$tariff_cost = '';
$form_tariffs = '';
$form = '<p> <form action="' . $action_url . '" method="' . $method . '">';
$arr = simple_queryall("SELECT name,Fee FROM tariffs ORDER BY Fee");
if ($arr) {
foreach ($arr as $k => $v) {
if ($tariff == $v['name']) {
$tariff_cost = $v['Fee'];
}
//не забываем что суммы в копейках
$form_tariffs .= "<input type='radio' name='amount' value='{$v['Fee']}'><span id='tariff_{$v['Fee']}'>{$v['Fee']} {$merchant_currency} ({$v['name']})</span><br>";
}
}
/* else {
$form.='<input type="text" name="LMI_PAYMENT_AMOUNT"> '.$merchant_currency;
} */
$form .= "<input type='radio' name='amount' value='0' CHECKED><input type='number' name='amount_val' min='1' max='3000' value='{$tariff_cost}'> {$merchant_currency}<br>";
$form .= $form_tariffs;
//передаем прочие нужные параметры
$form .= '<input type="hidden" name="LMI_PAYMENT_NO" value="' . $customer_id . '">';
$form .= '<input type="hidden" name="LMI_PAYMENT_AMOUNT" value="' . $tariff_cost . '">';
// $form.='<input type="hidden" name="good" value="'.$good_url.'">';
// $form.='<input type="hidden" name="bad" value="'.$bad_url.'">';
$form .= '<input type="hidden" name="LMI_PAYMENT_DESC">';
$form .= '<input type="hidden" name="LMI_MERCHANT_ID" value="' . $merchant_id . '">';
if ($debug) {
$form .= '<input type="hidden" name="LMI_PAYMENT_SYSTEM" value="18">';
}
$form .= '<br> <input type="submit" value="Оплатить">';
$form .= '</form> </p>';
return $form;
}
/**
* Returns array of all replies available for ticket
*
* @param int $ticketid
* @return array
*/
function zbs_TicketGetReplies($ticketid)
{
$ticketid = vf($ticketid, 3);
$query = "SELECT * from `ticketing` WHERE `replyid`='" . $ticketid . "' ORDER by `id` ASC";
$result = simple_queryall($query);
return $result;
}
protected function loadForeverCredits()
{
$query = "SELECT `login`,`Tariff`,`Cash`,`Credit`,`CreditExpire` from `users` WHERE `CreditExpire`='0' AND `Credit`!='0'";
$all = simple_queryall($query);
if (!empty($all)) {
$this->forever = $all;
}
}
/**
* gets all user payments by current month and stores it into payments prop
*
* @return void
*/
protected function loadPayments()
{
$query = "SELECT * from `payments` WHERE `date` LIKE '" . $this->year . '-' . $this->month . "-%' AND `summ`>0;";
$all = simple_queryall($query);
if (!empty($all)) {
$this->payments = $all;
}
}
function zb_plchecknethost($login)
{
$login = vf($login);
$ip = zb_UserGetIP($login);
$query = "SELECT `id` from `nethosts` where `ip`='" . $ip . "'";
$result = simple_queryall($query);
$return = !empty($result);
return $return;
}
/**
* Loads existing subscribers data
*
* @return void
*/
protected function loadHistory()
{
$query = "SELECT * from `mg_history`";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->allHistory[$each['id']] = $each;
}
}
}
/**
* Loads all of multinet networks for further usage
*
* @return void
*/
protected function loadMultinetNets()
{
$query = "SELECT * from `networks` ORDER BY `id` ASC";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->allMultinetNets[$each['id']] = $each;
}
}
}
/**
* loads user bindings from database and store it into private prop users
*
* @return void
*/
protected function loadUsers()
{
$query = "SELECT * from `corp_users`";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->users[$each['login']] = $each['corpid'];
}
}
}
protected function loadData()
{
$query = "SELECT * from `zbsannouncements` ORDER by `id` DESC;";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->data[$each['id']] = $each;
}
}
}
private function loadFrozen()
{
$query = "SELECT `login` from `users` WHERE `Passive`='1'";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->frozen[$each['login']] = $each['login'];
}
}
}
protected function loadAllUsers()
{
$query = "SELECT `login` from `users`;";
$alldata = simple_queryall($query);
if (!empty($alldata)) {
foreach ($alldata as $io => $each) {
$this->allusers[$each['login']] = $each['login'];
}
}
}
protected function loadApts()
{
$query = "SELECT * from `apt`";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->apts[$each['id']]['apt'] = $each['apt'];
$this->apts[$each['id']]['buildid'] = $each['buildid'];
}
}
}
function ds_GetDayStats($login, $day, $page = 0)
{
global $tablename;
$pagelimit = 100;
$page = vf($page);
$login = mysql_real_escape_string($login);
$dey = vf($day);
$query = "SELECT * from `" . $tablename . "` WHERE `login`='" . $login . "' AND `day`='" . $day . "' ORDER by `starttime` DESC";
$daystats = simple_queryall($query);
return $daystats;
}
/**
* Loads active/remind notes from database into private property
*
* @return void
*/
protected function loadActiveNotes()
{
$query = "SELECT * from `stickynotes` WHERE `owner`= '" . $this->myLogin . "' AND `active`='1' ORDER BY `id` ASC";
$tmpArr = simple_queryall($query);
//map id=>id
if (!empty($tmpArr)) {
foreach ($tmpArr as $io => $each) {
$this->activenotes[$each['id']] = $each;
}
}
}
/**
* Returns filtered events by some pattern
*
* @param string $searchpattern
* @param string $admin
* @param int $limit
* @return array
*/
function zb_GetAllEventsByPattern($searchpattern, $admin, $limit)
{
if (!empty($admin)) {
$adminFilter = "AND `admin`='" . $admin . "'";
} else {
$adminFilter = '';
}
$query = "SELECT * from `weblogs` WHERE `event` LIKE '%" . $searchpattern . "%' " . $adminFilter . " ORDER BY `id` DESC LIMIT " . $limit;
$allevents = simple_queryall($query);
return $allevents;
}
function zbs_CatvGetUserPayments($catv_userid)
{
$catv_userid = vf($catv_userid, 3);
$query = "SELECT * from `catv_payments` WHERE `userid`='" . $catv_userid . "'";
$allpayments = simple_queryall($query);
if (!empty($allpayments)) {
return $allpayments;
} else {
return false;
}
}
function zbs_AgentAssignStrictGetAllData()
{
$result = array();
$query = "SELECT * from `ahenassignstrict`";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$result[$each['login']] = $each['agentid'];
}
}
return $result;
}
/**
* Check if user already has tag
* @param type $login string
* @param type $tagid int
* @return type boolean
*/
function stg_check_user_tag($login, $tagid)
{
$login = mysql_real_escape_string($login);
$tagid = vf($tagid, 3);
$query = "SELECT `id` FROM `tags` WHERE `login`= '" . $login . "' AND `tagid`= '" . $tagid . "'";
$check = simple_queryall($query);
if (!empty($check)) {
return true;
} else {
return false;
}
}
function ep_UserGetAllRealnames()
{
$query_fio = "SELECT * from `realname`";
$allfioz = simple_queryall($query_fio);
$fioz = array();
if (!empty($allfioz)) {
foreach ($allfioz as $ia => $eachfio) {
$fioz[$eachfio['login']] = $eachfio['realname'];
}
}
return $fioz;
}
/**
* Loads available builpassport contact data from database
* and do some preprocessing magic
*
* @return void
*/
protected function loadBuildPassports()
{
if ($this->altCfg['BUILD_EXTENDED']) {
$query = "SELECT DISTINCT `ownerphone`,`ownername` FROM `buildpassport` WHERE `ownerphone` !=''";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$this->allBuildContacts[] = array('phone' => $each['ownerphone'], 'name' => $each['ownername']);
}
}
}
}
/**
* Fetch all Payment IDs from database as virtualid=>login
*
* @return array
*/
function zb_TemplateGetAllOPCustomers()
{
$result = array();
$query = "SELECT * from `op_customers`";
$all = simple_queryall($query);
if (!empty($all)) {
foreach ($all as $io => $each) {
$result[$each['realid']] = $each['virtualid'];
}
}
return $result;
}
function ms_GetAllusers()
{
$query = "SELECT `login` from `users`";
$result = array();
$allusers = simple_queryall($query);
if (!empty($allusers)) {
foreach ($allusers as $io => $eachuser) {
$result[] = $eachuser['login'];
}
}
return $result;
}
function zb_SpeedControlGetOverrideUsers()
{
$query = "SELECT `login` from `userspeeds` WHERE `speed` NOT LIKE '0'";
$alloverrides = simple_queryall($query);
$result = array();
if (!empty($alloverrides)) {
foreach ($alloverrides as $io => $eachoverride) {
$result[] = $eachoverride;
}
}
return $result;
}
/**
* Returns full list of tariffs marked as lousy
* @return array
*/
function zb_LousyTariffGetAll()
{
$query = "SELECT `id`,`tariff` from `lousytariffs`";
$result = array();
$alldata = simple_queryall($query);
if (!empty($alldata)) {
foreach ($alldata as $io => $eachtariff) {
$result[$eachtariff['tariff']] = $eachtariff['id'];
}
}
return $result;
}
private function loadData()
{
$query = "SELECT `login`,`Tariff`,`IP`, (`D0`+`D1`+`D2`+`D3`+`D4`+`D5`+`D6`+`D7`+`D8`+`D9`+`U0`+`U1`+`U2`+`U3`+`U4`+`U5`+`U6`+`U7`+`U8`+`U9`) AS `traffic` from `users` WHERE `DisabledDetailStat`!='1'";
$alldata = simple_queryall($query);
if (!empty($alldata)) {
foreach ($alldata as $io => $each) {
$this->data[$each['login']]['login'] = $each['login'];
$this->data[$each['login']]['Tariff'] = $each['Tariff'];
$this->data[$each['login']]['IP'] = $each['IP'];
$this->data[$each['login']]['traffic'] = $each['traffic'];
}
}
}
