Esempio n. 1
0
 public function flushCredit($login)
 {
     global $billing;
     $login = mysql_real_escape_string($login);
     $credit = 0;
     $curdate = curdate();
     $billing->setcredit($login, $credit);
     log_register('CHANGE FIX Credit (' . $login . ') ON ' . $credit);
     $billing->setcreditexpire($login, $curdate);
     log_register('CHANGE FIX CreditExpire (' . $login . ') ON ' . $curdate);
 }
Esempio n. 2
0
 public static function init()
 {
     self::$prefix = HOST . ':hash:';
     @(self::$hash = $_COOKIE['hash']);
     if (self::$hash and R::EXISTS(self::$prefix . self::$hash)) {
         $pipeline = R::pipeline();
         $pipeline->HSET(self::$prefix . self::$hash, 'LAST', now());
         $pipeline->EXPIRE(self::$prefix . self::$hash, USER_SESSION_TIMEOUT);
         $pipeline->execute();
         self::setCookie();
         self::$me = R::toHash(R::HGETALL(self::$prefix . self::$hash));
     } else {
         self::login();
     }
     if (USER_STAT) {
         $IP = IP();
         $STAMP = curdate();
         $HOST = HOST;
         $HASH = self::$hash;
         $METHOD = IS_AJAX ? 'AJAX' : (IS_POST ? 'POST' : 'GET');
         R::RPUSH("{$HOST}:stat:{$STAMP}:{$IP}:{$HASH}", implode(chr(10), array(now(), $METHOD, REF(), SITE . URI())));
     }
 }
Esempio n. 3
0
 /**
  * Render TurboSMS server-side queue
  * 
  * @return string
  */
 public function renderTurboSMSQueue()
 {
     $result = '';
     $tsms_host = $this->settings['TSMS_GATEWAY'];
     $tsms_db = 'users';
     $tsms_login = $this->settings['TSMS_LOGIN'];
     $tsms_password = $this->settings['TSMS_PASSWORD'];
     $tsms_table = $this->settings['TSMS_LOGIN'];
     $smsArray = array();
     $total = 0;
     $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');
     $cells = wf_TableCell(__('ID'));
     $cells .= wf_TableCell(__('Msg ID'));
     $cells .= wf_TableCell(__('Mobile'));
     $cells .= wf_TableCell(__('Sign'));
     $cells .= wf_TableCell(__('Message'));
     $cells .= wf_TableCell(__('Balance'));
     $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['balance']);
             $cells .= wf_TableCell($each['cost']);
             $cells .= wf_TableCell($each['send_time']);
             $cells .= wf_TableCell($each['sended']);
             $cells .= wf_TableCell($each['status']);
             $rows .= wf_TableRow($cells, 'row5');
             $total++;
         }
     }
     $result .= wf_Link(self::URL_ME, __('Back'), true, 'ubButton');
     $result .= $dateform;
     $result .= wf_TableBody($rows, '100%', '0', 'sortable');
     $result .= __('Total') . ': ' . $total;
     return $result;
 }
Esempio n. 4
0
 public function testCurdate()
 {
     $this->assertEquals(intval(curdate()) > 2010, true);
 }
Esempio n. 5
0
 /**
  * show calendar contol form
  * 
  * @return string
  */
 public function dateControl()
 {
     if (wf_CheckPost(array('showdate'))) {
         $curdate = $_POST['showdate'];
     } else {
         $curdate = curdate();
     }
     $inputs = wf_DatePickerPreset('showdate', $curdate);
     $inputs .= wf_Submit(__('Show'));
     $result = wf_Form('', 'POST', $inputs, 'glamour');
     return $result;
 }
Esempio n. 6
0
 function web_TsmsDateForm()
 {
     $inputs = __('By date') . ' ' . wf_DatePickerPreset('showqueuedate', curdate());
     $inputs .= wf_Submit(__('Show'));
     $result = wf_Form("", "POST", $inputs, 'glamour');
     return $result;
 }
Esempio n. 7
0
 function web_PayFindForm()
 {
     //try to save calendar states
     if (wf_CheckPost(array('datefrom', 'dateto'))) {
         $curdate = $_POST['dateto'];
         $yesterday = $_POST['datefrom'];
     } else {
         $curdate = date("Y-m-d", time() + 60 * 60 * 24);
         $yesterday = curdate();
     }
     $inputs = __('Date');
     $inputs .= wf_DatePickerPreset('datefrom', $yesterday) . ' ' . __('From');
     $inputs .= wf_DatePickerPreset('dateto', $curdate) . ' ' . __('To');
     $inputs .= wf_delimiter();
     $inputs .= wf_CheckInput('type_payid', '', false, false);
     $inputs .= wf_TextInput('payid', __('Search by payment ID'), '', true, '10');
     $inputs .= wf_CheckInput('type_contract', '', false, false);
     $inputs .= wf_TextInput('contract', __('Search by users contract'), '', true, '10');
     $inputs .= wf_CheckInput('type_login', '', false, false);
     $inputs .= wf_TextInput('login', __('Search by users login'), '', true, '10');
     $inputs .= wf_CheckInput('type_summ', '', false, false);
     $inputs .= wf_TextInput('summ', __('Search by payment sum'), '', true, '10');
     $inputs .= wf_CheckInput('type_cashtype', '', false, false);
     $inputs .= web_CashTypeSelector() . wf_tag('label', false, '', 'for="cashtype"') . __('Search by cash type') . wf_tag('label', true) . wf_tag('br');
     $inputs .= wf_CheckInput('type_cashier', '', false, false);
     $inputs .= web_PayFindCashierSelector();
     $inputs .= wf_CheckInput('type_tagid', '', false, false);
     $inputs .= web_PayFindTagidSelector();
     $inputs .= wf_CheckInput('type_paysys', '', false, false);
     $inputs .= web_PaySysPercentSelector();
     $inputs .= wf_Link("?module=payfind&confpaysys=true", __('Settings')) . wf_tag('br');
     $inputs .= wf_CheckInput('only_positive', __('Show only positive payments'), true, false);
     $inputs .= wf_CheckInput('numeric_notes', __('Show payments with numeric notes'), true, false);
     $inputs .= wf_CheckInput('numericonly_notes', __('Show payments with only numeric notes'), true, false);
     //ugly spacing hack
     $inputs .= '        ' . web_PayFindTableSelect() . wf_delimiter();
     $inputs .= wf_HiddenInput('dosearch', 'true');
     $inputs .= wf_Submit(__('Search'));
     $result = wf_Form('', 'POST', $inputs, 'glamour');
     $result .= wf_Link("?module=report_finance", __('Back'), true, 'ubButton');
     return $result;
 }
<?php

include 'config.inc.php';
require_once 'functions.php';
if (isset($_POST['submit']) == 'Submit') {
    $fname = mysql_real_escape_string($_POST['fname']);
    $lname = mysql_real_escape_string($_POST['lname']);
    $email = mysql_real_escape_string($_POST['email']);
    $pass = mysql_real_escape_string($_POST['pass']);
    $utype = mysql_real_escape_string($_POST['utype']);
    $data = array('firstname' => $fname, 'lastname' => $lname, 'email' => $email, 'password' => $pass, 'user_type' => $utype, 'status' => 1, 'date' => curdate());
    InsertPDO('library_user', $data);
    header("Location: index.php");
}
include 'header.php';
?>
<script language="javascript">
function validform(){
var y=document.forms["myForm"]["fname"].value;
if(y==null || y=="" || y.length<3)
{
alert('please enter your First name which is more than 3 character');
document.forms["myForm"]["fname"].focus();
return false;
}
var p=document.forms["myForm"]["lname"].value;
if(p==null || p=="" || p.length<2)
{
alert('please enter your Last name which is more than 2 character');
document.forms["myForm"]["lname"].focus();
return false;
Esempio n. 9
0
 /**
  * Performs available tasks processing
  * 
  * @return void
  */
 public function tasksProcessing()
 {
     global $billing;
     $curdate = curdate();
     $rawUsers = zb_UserGetAllStargazerData();
     $allUsers = array();
     if (!empty($rawUsers)) {
         foreach ($rawUsers as $io => $each) {
             $allUsers[$each['login']] = $each;
         }
     }
     if (!empty($this->allTasks)) {
         foreach ($this->allTasks as $io => $each) {
             if ($each['date'] == $curdate) {
                 if (isset($allUsers[$each['login']])) {
                     $login = $each['login'];
                     $param = $each['param'];
                     switch ($each['action']) {
                         case 'addcash':
                             zb_CashAdd($login, $param, 'add', 1, 'SCHEDULED');
                             break;
                         case 'corrcash':
                             zb_CashAdd($login, $param, 'correct', 1, 'SCHEDULED');
                             break;
                         case 'setcash':
                             zb_CashAdd($login, $param, 'set', 1, 'SCHEDULED');
                             break;
                         case 'credit':
                             $billing->setcredit($login, $param);
                             log_register('CHANGE Credit (' . $login . ') ON ' . $param);
                             break;
                         case 'creditexpire':
                             $billing->setcreditexpire($login, $param);
                             log_register('CHANGE CreditExpire (' . $login . ') ON ' . $param);
                             break;
                         case 'tariffchange':
                             $billing->settariff($login, $param);
                             log_register('CHANGE Tariff (' . $login . ') ON `' . $param . '`');
                             //optional user reset
                             if ($this->altCfg['TARIFFCHGRESET']) {
                                 $billing->resetuser($login);
                                 log_register('RESET User (' . $login . ')');
                             }
                             break;
                         case 'tagadd':
                             stg_add_user_tag($login, $param);
                             break;
                         case 'tagdel':
                             stg_del_user_tagid($login, $param);
                             break;
                         case 'freeze':
                             $billing->setpassive($login, 1);
                             log_register('CHANGE Passive (' . $login . ') ON 1');
                             break;
                         case 'unfreeze':
                             $billing->setpassive($login, 0);
                             log_register('CHANGE Passive (' . $login . ') ON 0');
                             break;
                         case 'reset':
                             $billing->resetuser($login);
                             log_register('RESET User (' . $login . ')');
                             break;
                         case 'setspeed':
                             zb_UserDeleteSpeedOverride($login);
                             zb_UserCreateSpeedOverride($login, $param);
                             $billing->resetuser($login);
                             log_register("RESET User (" . $login . ")");
                             break;
                         case 'down':
                             $billing->setdown($login, 1);
                             log_register('CHANGE Down (' . $login . ') ON 1');
                             break;
                         case 'undown':
                             $billing->setdown($login, 0);
                             log_register('CHANGE Down (' . $login . ') ON 0');
                             break;
                         case 'ao':
                             $billing->setao($login, 1);
                             log_register('CHANGE AlwaysOnline (' . $login . ') ON 1');
                             break;
                         case 'unao':
                             $billing->setao($login, 0);
                             log_register('CHANGE AlwaysOnline (' . $login . ') ON 0');
                             break;
                     }
                     //flush task from database
                     $this->setTaskIsDone($each['id']);
                 } else {
                     log_register('SCHEDULER FAIL ID [' . $taskId . '] USER (' . $each['login'] . ')  NON EXISTS');
                     $this->deleteTask($taskId);
                 }
             }
         }
     }
 }
Esempio n. 10
0
/**
 * Returns list of previous user payments
 * 
 * @param string $login
 * @return string
 */
function web_PaymentsByUser($login)
{
    global $ubillingConfig;
    $allpayments = zb_CashGetUserPayments($login);
    $alter_conf = $ubillingConfig->getAlter();
    $alltypes = zb_CashGetAllCashTypes();
    $allservicenames = zb_VservicesGetAllNamesLabeled();
    $total_payments = "0";
    $curdate = curdate();
    $deletingAdmins = array();
    $editingAdmins = array();
    $iCanDeletePayments = false;
    $iCanEditPayments = false;
    $currentAdminLogin = whoami();
    //extract admin logins with payments delete rights
    if (!empty($alter_conf['CAN_DELETE_PAYMENTS'])) {
        $deletingAdmins = explode(',', $alter_conf['CAN_DELETE_PAYMENTS']);
        $deletingAdmins = array_flip($deletingAdmins);
    }
    //extract admin logins with date edit rights
    if (!empty($alter_conf['CAN_EDIT_PAYMENTS'])) {
        $editingAdmins = explode(',', $alter_conf['CAN_EDIT_PAYMENTS']);
        $editingAdmins = array_flip($editingAdmins);
    }
    //setting editing/deleting flags
    $iCanDeletePayments = isset($deletingAdmins[$currentAdminLogin]) ? true : false;
    $iCanEditPayments = isset($editingAdmins[$currentAdminLogin]) ? true : false;
    $cells = wf_TableCell(__('ID'));
    $cells .= wf_TableCell(__('IDENC'));
    $cells .= wf_TableCell(__('Date'));
    $cells .= wf_TableCell(__('Payment'));
    $cells .= wf_TableCell(__('Balance before'));
    $cells .= wf_TableCell(__('Cash type'));
    $cells .= wf_TableCell(__('Payment note'));
    $cells .= wf_TableCell(__('Admin'));
    $cells .= wf_TableCell(__('Actions'));
    $rows = wf_TableRow($cells, 'row1');
    if (!empty($allpayments)) {
        foreach ($allpayments as $eachpayment) {
            if ($alter_conf['TRANSLATE_PAYMENTS_NOTES']) {
                $eachpayment['note'] = zb_TranslatePaymentNote($eachpayment['note'], $allservicenames);
            }
            //hightlight of today payments
            if ($alter_conf['HIGHLIGHT_TODAY_PAYMENTS']) {
                if (ispos($eachpayment['date'], $curdate)) {
                    $hlight = 'paytoday';
                } else {
                    $hlight = 'row3';
                }
            } else {
                $hlight = 'row3';
            }
            if (!empty($alter_conf['DOCX_SUPPORT']) && !empty($alter_conf['DOCX_CHECK'])) {
                $printcheck = wf_Link('?module=printcheck&paymentid=' . $eachpayment['id'], wf_img('skins/printer_small.gif', __('Print')), false);
            } else {
                $printcheck = wf_tag('a', false, '', 'href="#" onClick="window.open(\'?module=printcheck&paymentid=' . $eachpayment['id'] . '\',\'checkwindow\',\'width=800,height=600\')"');
                $printcheck .= wf_img('skins/printer_small.gif', __('Print'));
                $printcheck .= wf_tag('a', true);
            }
            //payments deleting controls
            if ($iCanDeletePayments) {
                $deleteControls = wf_JSAlert('?module=addcash&username='******'&paymentdelete=' . $eachpayment['id'], wf_img('skins/delete_small.png', __('Delete')), __('Removing this may lead to irreparable results')) . ' &nbsp; ';
            } else {
                $deleteControls = '';
            }
            //payments editing form
            if ($iCanEditPayments) {
                $editControls = wf_modalAuto(wf_img_sized('skins/icon_edit.gif', __('Edit'), '10'), __('Edit'), web_PaymentEditForm($eachpayment), '') . ' &nbsp; ';
            } else {
                $editControls = '';
            }
            $cells = wf_TableCell($eachpayment['id']);
            $cells .= wf_TableCell(zb_NumEncode($eachpayment['id']));
            $cells .= wf_TableCell($eachpayment['date']);
            $cells .= wf_TableCell($eachpayment['summ']);
            $cells .= wf_TableCell($eachpayment['balance']);
            $cells .= wf_TableCell(@__($alltypes[$eachpayment['cashtypeid']]));
            $cells .= wf_TableCell($eachpayment['note']);
            $cells .= wf_TableCell($eachpayment['admin']);
            $cells .= wf_TableCell($deleteControls . $editControls . $printcheck);
            $rows .= wf_TableRow($cells, $hlight);
            $total_payments = $total_payments + $eachpayment['summ'];
        }
    }
    $result = wf_TableBody($rows, '100%', '0', 'sortable');
    $result .= __('Total payments') . ': ' . wf_tag('b') . abs($total_payments) . wf_tag('b') . wf_tag('br');
    return $result;
}
Esempio n. 11
0
 function web_SignupsShowToday()
 {
     $query = "SELECT COUNT(`id`) from `userreg` WHERE `date` LIKE '" . curdate() . "%'";
     $sigcount = simple_query($query);
     $sigcount = $sigcount['COUNT(`id`)'];
     show_window(__('Today signups') . ': ' . $sigcount, '');
 }
Esempio n. 12
0
 /**
  * Renders default subscriptions report
  * 
  * @return string
  */
 public function renderSubscribtionsReportDaily()
 {
     $result = '';
     $defaultDateTo = strtotime(curdate()) + 86400;
     $defaultDateTo = date("Y-m-d", $defaultDateTo);
     $inputs = wf_DatePickerPreset('datefrom', date("Y-m") . '-01', true);
     $inputs .= wf_DatePickerPreset('dateto', $defaultDateTo, true);
     $inputs .= wf_Submit(__('Show'));
     $result .= wf_Form('', 'POST', $inputs, 'glamour');
     $dateFrom = wf_CheckPost(array('datefrom')) ? mysql_real_escape_string($_POST['datefrom']) : date("Y-m") . '-01';
     $dateTo = wf_CheckPost(array('dateto')) ? mysql_real_escape_string($_POST['dateto']) : $defaultDateTo;
     $query = "SELECT * from `payments` WHERE `date` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' AND  `note` LIKE 'MEGOGO:%';";
     $raw = simple_queryall($query);
     $totalSumm = 0;
     $tmpArr = array();
     if (!empty($raw)) {
         foreach ($raw as $io => $each) {
             $tariffId = explode(':', $each['note']);
             $tariffId = $tariffId[1];
             if (isset($tmpArr[$tariffId])) {
                 $tmpArr[$tariffId]['summ'] = $tmpArr[$tariffId]['summ'] + abs($each['summ']);
                 $tmpArr[$tariffId]['count']++;
                 //try&buy user
                 if ($each['summ'] == 0) {
                     $tmpArr[$tariffId]['freeperiod']++;
                 }
             } else {
                 $tmpArr[$tariffId]['summ'] = abs($each['summ']);
                 $tmpArr[$tariffId]['count'] = 1;
                 //try&buy user
                 if ($each['summ'] == 0) {
                     $tmpArr[$tariffId]['freeperiod'] = 1;
                 } else {
                     $tmpArr[$tariffId]['freeperiod'] = 0;
                 }
             }
         }
         if (!empty($tmpArr)) {
             $cells = wf_TableCell(__('Tariff'));
             $cells .= wf_TableCell(__('Fee') . ' / ' . __('month'));
             $cells .= wf_TableCell(__('days'));
             $cells .= wf_TableCell(__('Free period'));
             $cells .= wf_TableCell(__('Total payments'));
             $cells .= wf_TableCell(__('Profit'));
             $rows = wf_TableRow($cells, 'row1');
             foreach ($tmpArr as $io => $each) {
                 $cells = wf_TableCell(@$this->allTariffs[$io]['name']);
                 $cells .= wf_TableCell(@$this->allTariffs[$io]['fee']);
                 $cells .= wf_TableCell($each['count']);
                 $cells .= wf_TableCell($each['freeperiod']);
                 $cells .= wf_TableCell($each['summ']);
                 $cells .= wf_TableCell(zb_Percent($each['summ'], $this->altCfg['MG_PERCENT']));
                 $rows .= wf_TableRow($cells, 'row3');
                 $totalSumm = $totalSumm + $each['summ'];
             }
             $cells = wf_TableCell(wf_tag('b') . __('Total') . wf_tag('b', true));
             $cells .= wf_TableCell('');
             $cells .= wf_TableCell('');
             $cells .= wf_TableCell('');
             $cells .= wf_TableCell($totalSumm);
             $cells .= wf_TableCell(zb_Percent($totalSumm, $this->altCfg['MG_PERCENT']));
             $rows .= wf_TableRow($cells, 'row2');
             $result .= wf_TableBody($rows, '100%', 0, '');
         }
     } else {
         $result .= $this->messages->getStyledMessage(__('Nothing found'), 'info');
     }
     return $result;
 }
					<th>Artikelnaam</th>
					<th>Omschrijving</th>
					<th>Verkoopprijs</th>
					<th>Afbeelding</th>
					<th>Aantal</th>
					<th>Subtotaal</th>
					<th>Verwijderen</th>
				</tr>
			</thead>

			<tbody>
				<?php 
    if (isset($_POST['bestel'])) {
        unset($_POST['table_length']);
        unset($_POST['bestel']);
        $curedate = curdate();
        global $db;
        $sth = $db->prepare("INSERT INTO bestelling (Datum, GebruikerID, Geexporteerd) VALUES (:curdate, :GebruikerID, 0)");
        $sth->bindParam(":GebruikerID", $_SESSION['GebruikerID']);
        $sth->bindParam(":curdate", $curedate);
        $sth->execute();
        $lastInsertId = $db->lastInsertId();
        foreach ($_POST as $productid => $aantal) {
            $sth = $db->prepare("SELECT Verkoopprijs FROM product WHERE ProductID = :ProductID");
            $sth->bindParam(":ProductID", $productid);
            $sth->execute();
            $VerkoopPrijs = $sth->fetchAll(PDO::FETCH_ASSOC);
            $VerkoopPrijs = $VerkoopPrijs['0']['Verkoopprijs'];
            $Totaal = $VerkoopPrijs * $aantal;
            $sth = $db->prepare("INSERT INTO bestelling_product (BestellingID, ProductID, Aantal, Verkoopprijs, Totaalprijs) VALUES (:lastid, :ProductID, :Aantal, :Verkoopprijs, :Totaalprijs)");
            $sth->bindParam(":lastid", $lastInsertId);
Esempio n. 14
0
 /**
  * returns payments search form
  * 
  * @return string
  */
 public function paymentSearchForm()
 {
     //try to save calendar states
     if (wf_CheckPost(array('datefrom', 'dateto'))) {
         $curdate = $_POST['dateto'];
         $yesterday = $_POST['datefrom'];
     } else {
         $curdate = date("Y-m-d", time() + 60 * 60 * 24);
         $yesterday = curdate();
     }
     //try to save cashtype selector state
     if (wf_CheckPost(array('cashtypeid'))) {
         $currentCashtypeId = $_POST['cashtypeid'];
     } else {
         //cash money by default
         $currentCashtypeId = 1;
     }
     $allcashtypes = zb_CashGetAlltypes();
     $cashTypesArr = array();
     if (!empty($allcashtypes)) {
         foreach ($allcashtypes as $io => $each) {
             $cashTypesArr[$each['id']] = __($each['cashtype']);
         }
     }
     $cashTypesArr['any'] = __('Any');
     $inputs = __('Date');
     $inputs .= wf_DatePickerPreset('datefrom', $yesterday) . ' ' . __('From');
     $inputs .= wf_DatePickerPreset('dateto', $curdate) . ' ' . __('To') . ' ';
     $inputs .= wf_Selector('cashtypeid', $cashTypesArr, __('Cash type'), $currentCashtypeId, false);
     $inputs .= wf_HiddenInput('dosearch', 'true');
     $inputs .= wf_Submit(__('Search'));
     $result = wf_Form("", 'POST', $inputs, 'glamour');
     return $result;
 }
Esempio n. 15
0
/**
 *  Replaces all known macro in template with per-user values for selected user
 *
 *  @param  string  $login existing user login
 *  @param  string  $template raw template 
 *  @param  array   $alluserdata collected userdata 
 *  @return  string
 */
function zb_TemplateReplace($login, $template, $alluserdata)
{
    $result = '';
    if (!empty($alluserdata)) {
        $result .= $template;
        //known macro
        $result = str_ireplace('{LOGIN}', $alluserdata[$login]['login'], $result);
        $result = str_ireplace('{PASSWORD}', $alluserdata[$login]['password'], $result);
        $result = str_ireplace('{USERHASH}', $alluserdata[$login]['userhash'], $result);
        $result = str_ireplace('{TARIFF}', $alluserdata[$login]['tariff'], $result);
        $result = str_ireplace('{TARIFFPRICE}', $alluserdata[$login]['tariffprice'], $result);
        $result = str_ireplace('{CASH}', $alluserdata[$login]['cash'], $result);
        $result = str_ireplace('{ROUNDCASH}', round($alluserdata[$login]['cash'], 2), $result);
        $result = str_ireplace('{CURDATE}', curdate(), $result);
        $result = str_ireplace('{CREDIT}', $alluserdata[$login]['credit'], $result);
        $result = str_ireplace('{DOWN}', $alluserdata[$login]['down'], $result);
        $result = str_ireplace('{PASSIVE}', $alluserdata[$login]['passive'], $result);
        $result = str_ireplace('{AO}', $alluserdata[$login]['ao'], $result);
        $result = str_ireplace('{CONTRACT}', $alluserdata[$login]['contract'], $result);
        $result = str_ireplace('{REALNAME}', $alluserdata[$login]['realname'], $result);
        $result = str_ireplace('{ADDRESS}', $alluserdata[$login]['address'], $result);
        $result = str_ireplace('{EMAIL}', $alluserdata[$login]['email'], $result);
        $result = str_ireplace('{PAYID}', $alluserdata[$login]['payid'], $result);
        $result = str_ireplace('{TRAFFIC}', $alluserdata[$login]['traffic'], $result);
        $result = str_ireplace('{TRAFFICDOWN}', $alluserdata[$login]['trafficdown'], $result);
        $result = str_ireplace('{TRAFFICUP}', $alluserdata[$login]['trafficup'], $result);
        $result = str_ireplace('{IP}', $alluserdata[$login]['ip'], $result);
        $result = str_ireplace('{MAC}', $alluserdata[$login]['mac'], $result);
        $result = str_ireplace('{NETID}', $alluserdata[$login]['netid'], $result);
        $result = str_ireplace('{HOSTID}', $alluserdata[$login]['hostid'], $result);
        $result = str_ireplace('{NASID}', $alluserdata[$login]['nasid'], $result);
        $result = str_ireplace('{NASIP}', $alluserdata[$login]['nasip'], $result);
        $result = str_ireplace('{NASNAME}', $alluserdata[$login]['nasname'], $result);
        $result = str_ireplace('{NASTYPE}', $alluserdata[$login]['nastype'], $result);
        $result = str_ireplace('{SPEEDDOWN}', $alluserdata[$login]['speeddown'], $result);
        $result = str_ireplace('{SPEEDUP}', $alluserdata[$login]['speedup'], $result);
        $result = str_ireplace('{PBIRTH}', $alluserdata[$login]['birthdate'], $result);
        $result = str_ireplace('{PNUM}', $alluserdata[$login]['passportnum'], $result);
        $result = str_ireplace('{PDATE}', $alluserdata[$login]['passportdate'], $result);
        $result = str_ireplace('{PWHO}', $alluserdata[$login]['passportwho'], $result);
        $result = str_ireplace('{PCITY}', $alluserdata[$login]['pcity'], $result);
        $result = str_ireplace('{PSTREET}', $alluserdata[$login]['pstreet'], $result);
        $result = str_ireplace('{PBUILD}', $alluserdata[$login]['pbuild'], $result);
        $result = str_ireplace('{PAPT}', $alluserdata[$login]['papt'], $result);
        //custom fields extract
        if (ispos($result, '{CFIELD:')) {
            $split = explode('{CFIELD:', $result);
            $cfid = vf($split[1], 3);
            $result = str_ireplace('{CFIELD:' . $cfid . '}', @$alluserdata[$login]['cf'][$cfid], $result);
        }
        //print macro
        $printsub = '<script language="javascript"> 
                        window.print();
                    </script>';
        $result = str_ireplace('{PRINTME}', $printsub, $result);
    }
    return $result;
}
Esempio n. 16
0
function catv_FinanceReport()
{
    if (!isset($_POST['yearsel'])) {
        $show_year = curyear();
    } else {
        $show_year = $_POST['yearsel'];
    }
    $dateform = '
        <form action="?module=catv&action=reports&showreport=finance" method="POST">
        ' . web_CalendarControl('showdatepayments') . '
        <input type="submit" value="' . __('Show') . '">
        </form>
        <br>
        ';
    $yearform = '
        <form action="?module=catv&action=reports&showreport=finance" method="POST">
         ' . web_year_selector() . '
        <input type="submit" value="' . __('Show') . '">
        </form>
          ';
    show_window(__('Year'), $yearform);
    show_window(__('Payments by date'), $dateform);
    catv_PaymentsShowGraph($show_year);
    if (!isset($_GET['month'])) {
        // payments by somedate
        if (isset($_POST['showdatepayments'])) {
            $paydate = mysql_real_escape_string($_POST['showdatepayments']);
            //deb($paydate);
            show_window(__('Payments by date') . ' ' . $paydate, catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $paydate . "%'"));
        } else {
            // today payments
            $today = curdate();
            show_window(__('Today payments'), catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $today . "%'"));
        }
    } else {
        // show monthly payments
        $paymonth = mysql_real_escape_string($_GET['month']);
        show_window(__('Month payments'), catv_PaymentsShow("SELECT * from `catv_payments` WHERE `date` LIKE '" . $paymonth . "%'"));
    }
}
Esempio n. 17
0
/**
 * Renders export form body
 * 
 * @return string
 */
function zb_ExportForm()
{
    $curdate = curdate();
    $yesterday = date("Y-m-d", time() - 86400);
    $inputs = __('From');
    $inputs .= wf_DatePickerPreset('fromdate', $yesterday);
    $inputs .= __('To');
    $inputs .= wf_DatePickerPreset('todate', $curdate);
    $inputs .= wf_Submit('Export');
    $form = wf_Form("", 'POST', $inputs, 'glamour');
    return $form;
}
Esempio n. 18
0
 /**
  * Do some search actions by captured POST request
  * 
  * @return array
  */
 public function commonSearch()
 {
     $result = array();
     if (wf_CheckPost(array('datefrom', 'dateto'))) {
         $dateFrom = mysql_real_escape_string($_POST['datefrom']);
         $dateTo = mysql_real_escape_string($_POST['dateto']);
         $baseQuery = "SELECT * from `taskman` WHERE `startdate` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' ";
         $appendQuery = '';
         //task id
         if (wf_CheckPost(array('cb_id', 'taskid'))) {
             $taskid = vf($_POST['taskid'], 3);
             $appendQuery .= " AND `id`='" . $taskid . "' ";
         }
         //more than some days count
         if (wf_CheckPost(array('cb_taskdays', 'taskdays'))) {
             $taskdays = vf($_POST['taskdays'], 3);
             $appendQuery .= " AND DATEDIFF(`enddate`, `startdate`) > '" . $taskdays . "' ";
         }
         //task address non strict
         if (wf_CheckPost(array('cb_taskaddress', 'taskaddress'))) {
             $taskaddress = mysql_real_escape_string($_POST['taskaddress']);
             $appendQuery .= " AND `address` LIKE '%" . $taskaddress . "%' ";
         }
         //task phone non strict
         if (wf_CheckPost(array('cb_taskphone', 'taskphone'))) {
             $taskphone = mysql_real_escape_string($_POST['taskphone']);
             $appendQuery .= " AND `phone` LIKE '%" . $taskphone . "%' ";
         }
         //original task employee
         if (wf_CheckPost(array('cb_employee', 'employee'))) {
             $employee = mysql_real_escape_string($_POST['employee']);
             $appendQuery .= " AND `employee`='" . $employee . "' ";
         }
         //original task employeedone
         if (wf_CheckPost(array('cb_employeedone', 'employeedone'))) {
             $employeedone = mysql_real_escape_string($_POST['employeedone']);
             $appendQuery .= " AND `employeedone`='" . $employeedone . "' ";
         }
         //address duplicate search
         if (wf_CheckPost(array('cb_duplicateaddress'))) {
             // $appendQuery.=" AND `address` IN (SELECT `address` FROM `taskman` WHERE `startdate` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' GROUP BY `address` HAVING COUNT(*) > 1) ";
             $baseQuery = "SELECT st1.*, st2.`address` FROM `taskman`  st1  INNER JOIN taskman st2 ON (st2.`startdate` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' AND st1.address = st2.address)  GROUP BY st1.id HAVING COUNT(*) > 1 AND `startdate` BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "' ";
         }
         //late jobs
         if (wf_CheckPost(array('cb_showlate'))) {
             $curdate = curdate();
             $appendQuery .= " AND `status`='0' AND `startdate`< '" . $curdate . "' ";
         }
         //only done jobs
         if (wf_CheckPost(array('cb_onlydone'))) {
             $appendQuery .= " AND `status`='1' ";
         }
         //only undone jobs
         if (wf_CheckPost(array('cb_onlyundone'))) {
             $appendQuery .= " AND `status`='0' ";
         }
         $query = $baseQuery . $appendQuery;
         // deb($query);
         $raw = simple_queryall($query);
         if (!empty($raw)) {
             foreach ($raw as $io => $each) {
                 $result[$each['id']] = $each;
             }
         }
         //salary no jobs processing/excluding
         if (wf_CheckPost(array('cb_nosalsaryjobs'))) {
             $salaryTasks = array();
             $greed = new Avarice();
             $beggar = $greed->runtime('SALARY');
             if (!empty($beggar)) {
                 $querySalaryJobs = "SELECT `id`,`taskid` from `salary_jobs`";
                 $salaryJobsRaw = simple_queryall($querySalaryJobs);
                 if (!empty($salaryJobsRaw)) {
                     foreach ($salaryJobsRaw as $io => $each) {
                         if (!empty($each['taskid'])) {
                             $salaryTasks[$each['taskid']] = $each['id'];
                         }
                     }
                 }
                 if (!empty($salaryTasks)) {
                     foreach ($salaryTasks as $jobTaskid => $eachJobId) {
                         if (isset($result[$jobTaskid])) {
                             unset($result[$jobTaskid]);
                         }
                     }
                 }
             } else {
                 show_error(__('No license key available'));
             }
         }
     }
     return $result;
 }
Esempio n. 19
0
 /**
  * Shows salary summary report
  * 
  * @return void
  */
 public function summaryReport()
 {
     $result = '';
     if ($_SERVER['QUERY_STRING'] == 'module=salary') {
         $messages = new UbillingMessageHelper();
         if (empty($this->allEmployee)) {
             $result .= $messages->getStyledMessage(__('No available workers for wage creation'), 'error');
         } else {
             $result .= $messages->getStyledMessage(__('Total existing employees') . ': ' . sizeof($this->allEmployee), 'info');
         }
         if (empty($this->allJobtypes)) {
             $result .= $messages->getStyledMessage(__('No available job types for pricing'), 'error');
         } else {
             $result .= $messages->getStyledMessage(__('Total existing job types') . ': ' . sizeof($this->allJobtypes), 'info');
         }
         if (empty($this->allJobPrices)) {
             $result .= $messages->getStyledMessage(__('There is no set prices for job types'), 'warning');
         } else {
             $result .= $messages->getStyledMessage(__('Total paid types of work') . ': ' . sizeof($this->allJobPrices), 'info');
         }
         if (empty($this->allWages)) {
             $result .= $messages->getStyledMessage(__('There is no set wages for workers'), 'warning');
         }
         if (empty($this->allJobs)) {
             $result .= $messages->getStyledMessage(__('Not done yet any paid work'), 'warning');
         } else {
             $todayJobs = $this->jobsFilterDate(curdate());
             $todayJobsCount = sizeof($todayJobs);
             $monthJobs = $this->jobsFilterDate(curmonth());
             $monthJobsCount = sizeof($monthJobs);
             $result .= $messages->getStyledMessage(__('Today performed paid work') . ': ' . $todayJobsCount, 'success');
             $result .= $messages->getStyledMessage(__('Month performed paid work') . ': ' . $monthJobsCount, 'success');
             $result .= $messages->getStyledMessage(__('Total performed paid work') . ': ' . sizeof($this->allJobs), 'success');
         }
         if (empty($this->allTimesheetDates)) {
             $result .= $messages->getStyledMessage(__('No filled timesheets'), 'warning');
         } else {
             if (!isset($this->allTimesheetDates[curdate()])) {
                 $result .= $messages->getStyledMessage(__('For today is not filled timesheets'), 'warning');
             } else {
                 $result .= $messages->getStyledMessage(__('For today timesheets is filled'), 'success');
             }
             $result .= $messages->getStyledMessage(__('Filled timesheets for') . ' ' . sizeof($this->allTimesheetDates) . ' ' . __('days'), 'success');
         }
         if (!empty($result)) {
             show_window(__('Stats'), $result);
         }
     }
 }
Esempio n. 20
0
     if ($altcfg['AGENTS_ASSIGN'] == '2') {
         $controlcells .= wf_TableCell(wf_Link("?module=report_agentfinance", wf_img('skins/corporate_small.png') . ' ' . __('Search'), false, 'ubButton'));
     }
     $controlrows .= wf_TableRow($controlcells);
     $controlgrid = wf_TableBody($controlrows, '100%', 0, '');
     show_window('', $controlgrid);
     web_PaymentsShowGraph($show_year);
     if (!isset($_GET['month'])) {
         // payments by somedate
         if (isset($_POST['showdatepayments'])) {
             $paydate = mysql_real_escape_string($_POST['showdatepayments']);
             $paydate = !empty($paydate) ? $paydate : curdate();
             show_window(__('Payments by date') . ' ' . $paydate, web_PaymentsShow("SELECT * from `payments` WHERE `date` LIKE '" . $paydate . "%' ORDER by `date` DESC;"));
         } else {
             // today payments
             $today = curdate();
             show_window(__('Today payments'), web_PaymentsShow("SELECT * from `payments` WHERE `date` LIKE '" . $today . "%' ORDER by `date` DESC;"));
         }
     } else {
         // show monthly payments
         $paymonth = mysql_real_escape_string($_GET['month']);
         show_window(__('Month payments'), web_PaymentsShow("SELECT * from `payments` WHERE `date` LIKE '" . $paymonth . "%'  ORDER by `date` DESC;"));
     }
 } else {
     //show finance analytics info
     if (wf_CheckPost(array('anyearsel'))) {
         $currentYear = $_POST['anyearsel'];
     } else {
         $currentYear = date("Y");
     }
     $yearinputs = wf_YearSelectorPreset('anyearsel', __('Year'), false, $currentYear) . ' ';
Esempio n. 21
0
 /**
  * Returns outcoming operation creation form
  * 
  * @param int $storageid
  * @param int $itemtypeid
  * 
  * @return string
  */
 public function outcomingCreateForm($storageid, $itemtypeid)
 {
     $result = '';
     $storageid = vf($storageid, 3);
     $itemtypeid = vf($itemtypeid, 3);
     $tmpDests = array();
     if (isset($this->allStorages[$storageid]) and isset($this->allItemTypes[$itemtypeid])) {
         $itemData = $this->allItemTypes[$itemtypeid];
         $itemUnit = $this->unitTypes[$itemData['unit']];
         $storageRemains = $this->remainsOnStorage($storageid);
         $allRemains = $this->remainsAll();
         if (isset($storageRemains[$itemtypeid])) {
             $itemRemainsStorage = $storageRemains[$itemtypeid];
         } else {
             $itemRemainsStorage = 0;
         }
         if (isset($allRemains[$itemtypeid])) {
             $itemRemainsTotal = $allRemains[$itemtypeid];
         } else {
             $itemRemainsTotal = 0;
         }
         $isReserved = $this->reserveGet($storageid, $itemtypeid);
         foreach ($this->outDests as $destMark => $destName) {
             $tmpDests[self::URL_ME . '&' . self::URL_OUT . '&' . self::URL_AJODSELECTOR . $destMark] = $destName;
         }
         //form construct
         $inputs = wf_AjaxLoader();
         $inputs .= wf_HiddenInput('newoutdate', curdate());
         $inputs .= wf_AjaxSelectorAC('ajoutdestselcontainer', $tmpDests, __('Destination'), '', false);
         $inputs .= wf_AjaxContainer('ajoutdestselcontainer', '', $this->outcomindAjaxDestSelector('task'));
         $inputs .= wf_HiddenInput('newoutitemtypeid', $itemtypeid);
         $inputs .= wf_HiddenInput('newoutstorageid', $storageid);
         $inputs .= wf_TextInput('newoutcount', $itemUnit . ' (' . ($itemRemainsStorage - $isReserved) . ' ' . __('maximum') . ')', '', true, '4');
         $inputs .= wf_TextInput('newoutprice', __('Price') . ' (' . __('middle price') . ': ' . $this->getIncomeMiddlePrice($itemtypeid) . ')', '', true, '4');
         $inputs .= wf_TextInput('newoutnotes', __('Notes'), '', true, 25);
         $inputs .= wf_tag('br');
         $inputs .= wf_Submit(__('Create'));
         $form = wf_Form('', 'POST', $inputs, 'glamour');
         //notifications
         if ($itemRemainsTotal < $itemData['reserve']) {
             $remainsAlert = __('The balance of goods and materials in stock is less than the amount') . ' ' . $itemData['reserve'] . ' ' . $itemUnit;
         } else {
             $remainsAlert = '';
         }
         $remainsNotification = __('At storage') . ' ' . @$this->allStorages[$storageid] . ' ' . __('remains') . ' ' . $itemRemainsStorage . ' ' . $itemUnit . ' ' . $itemData['name'];
         $notifications = $this->messages->getStyledMessage($remainsNotification, 'success');
         if ($isReserved) {
             $notifications .= $this->messages->getStyledMessage(__('Reserved') . ' ' . $isReserved . ' ' . $itemUnit, 'info');
         }
         if ($remainsAlert) {
             $notifications .= $this->messages->getStyledMessage($remainsAlert, 'warning');
         }
         $notifications .= wf_CleanDiv();
         if (cfr('WAREHOUSERESERVE')) {
             $reserveLink = self::URL_ME . '&' . self::URL_RESERVE . '&itemtypeid=' . $itemtypeid . '&storageid=' . $storageid;
             $notifications .= wf_tag('div', false, '', 'style="margin: 20px 3% 0 3%;"') . wf_Link($reserveLink, wf_img('skins/whreservation.png') . ' ' . __('Reservation'), false, 'ubButton') . wf_tag('div', true);
             $notifications .= wf_CleanDiv();
         }
         $cells = wf_TableCell($form, '40%');
         $cells .= wf_TableCell($notifications, '', '', 'valign="top"');
         $rows = wf_TableRow($cells);
         $result = wf_TableBody($rows, '100%', 0, '');
         //photostorage integration
         if ($this->altCfg['PHOTOSTORAGE_ENABLED']) {
             $photostorage = new PhotoStorage(self::PHOTOSTORAGE_SCOPE, $itemtypeid);
             $result .= $photostorage->renderImagesRaw();
         }
     } else {
         $result = $this->messages->getStyledMessage(__('Strange exeption'), 'error');
     }
     return $result;
 }
Esempio n. 22
0
 function docsis_ModemAdd($maclan)
 {
     $maclan = mysql_real_escape_string($maclan);
     //random mac for usb
     $macusb = '14:' . '88' . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99);
     $altercfg = rcms_parse_ini_file(CONFIG_PATH . '/alter.ini');
     $netid = $altercfg['DOCSIS_MODEM_NETID'];
     $nextfreeip = multinet_get_next_freeip('nethosts', 'ip', $netid);
     $note = '';
     $userbind = '';
     $basetemplate = 'short';
     $date = curdate();
     //check for free ip in subnet
     if (!empty($nextfreeip)) {
         $nic = str_replace('.', 'x', $nextfreeip);
         //check is mac unique?
         if (multinet_mac_free($maclan) and check_mac_format($maclan)) {
             $query = "INSERT INTO `modems` (\n                `id` ,\n                `maclan` ,\n                `macusb` ,\n                `date` ,\n                `ip` ,\n                `conftemplate` ,\n                `userbind` ,\n                `nic` ,\n                `note`\n                )\n                VALUES (\n                NULL , '" . $maclan . "', '" . $maclan . "', '" . $date . "', '" . $nextfreeip . "', '" . $basetemplate . "', '' , '" . $nic . "', ''\n                );";
             nr_query($query);
             $lastid = simple_get_lastid('modems');
             log_register("DOCSIS MODEM ADD MAC" . $maclan . " IP " . $nextfreeip . "[" . $lastid . "]");
             multinet_add_host($netid, $nextfreeip, $maclan, '');
             multinet_rebuild_all_handlers();
             rcms_redirect("?module=docsis&showmodem=" . $lastid);
         } else {
             show_window(__('Error'), __('This MAC is currently used') . ' ' . __('This MAC have wrong format'));
         }
     } else {
         show_window(__('Error'), __('No free IP available in selected pool'));
     }
 }
Esempio n. 23
0
 /**
  * Renders ONU signal history chart
  * 
  * @param int $onuId
  * @return string
  */
 protected function onuSignalHistory($onuId)
 {
     $onuId = vf($onuId, 3);
     $result = '';
     if (isset($this->allOnu[$onuId])) {
         //not empty MAC
         if ($this->allOnu[$onuId]['mac']) {
             if (file_exists(self::ONUSIG_PATH . md5($this->allOnu[$onuId]['mac']))) {
                 $historyKey = self::ONUSIG_PATH . md5($this->allOnu[$onuId]['mac']);
             } elseif (file_exists(self::ONUSIG_PATH . md5($this->allOnu[$onuId]['serial']))) {
                 $historyKey = self::ONUSIG_PATH . md5($this->allOnu[$onuId]['serial']);
             } else {
                 $historyKey = '';
             }
             if (!empty($historyKey)) {
                 $rawData = file_get_contents($historyKey);
                 $result .= wf_delimiter();
                 $result .= wf_tag('h2') . __('ONU signal history') . wf_tag('h2', true);
                 //current day signal levels
                 $todaySignal = '';
                 $curdate = curdate();
                 if (!empty($rawData)) {
                     $todayTmp = explodeRows($rawData);
                     if (!empty($todayTmp)) {
                         foreach ($todayTmp as $io => $each) {
                             if (ispos($each, $curdate)) {
                                 $todaySignal .= $each . "\n";
                             }
                         }
                     }
                 }
                 $result .= __('Today');
                 $result .= wf_tag('div', false, '', '');
                 $result .= wf_Graph($todaySignal, '800', '300', false);
                 $result .= wf_tag('div', true);
                 $result .= wf_tag('br');
                 //current month signal levels
                 $monthSignal = '';
                 $curmonth = curmonth();
                 if (!empty($rawData)) {
                     $monthTmp = explodeRows($rawData);
                     if (!empty($monthTmp)) {
                         foreach ($monthTmp as $io => $each) {
                             if (ispos($each, $curmonth)) {
                                 $monthSignal .= $each . "\n";
                             }
                         }
                     }
                 }
                 $result .= __('Month');
                 $result .= wf_tag('div', false, '', '');
                 $result .= wf_Graph($monthSignal, '800', '300', false);
                 $result .= wf_tag('div', true);
                 $result .= wf_tag('br');
                 //all time signal history
                 $result .= __('All time');
                 $result .= wf_tag('div', false, '', '');
                 $result .= wf_GraphCSV($historyKey, '800', '300', false);
                 $result .= wf_tag('div', true);
             }
         }
     }
     return $result;
 }
Esempio n. 24
0
 function web_AskoziaDateForm()
 {
     $inputs = wf_Link("?module=askozia&config=true", wf_img('skins/settings.png', __('Settings'))) . ' ';
     $inputs .= wf_DatePickerPreset('datefrom', curdate()) . ' ' . __('From');
     $inputs .= wf_DatePickerPreset('dateto', curdate()) . ' ' . __('To');
     $inputs .= wf_Submit(__('Show'));
     $result = wf_Form("", "POST", $inputs, 'glamour');
     return $result;
 }
Esempio n. 25
0
 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;
 }
Esempio n. 26
0
 /**
  * Returns server system information
  * 
  * @return array
  */
 protected function getSystemInformation()
 {
     $result = array();
     $curdate = curdate();
     $operatingSystem = shell_exec('uname');
     $billingVersion = file_get_contents('RELEASE');
     $result['date'] = $curdate;
     $result['os'] = trim($operatingSystem);
     $result['billing']['name'] = 'Ubilling';
     $result['billing']['version'] = trim($billingVersion);
     return $result;
 }
Esempio n. 27
0
 /**
  * Askozia PBX data fetching and processing
  * 
  * @return void
  */
 protected function preprocessAskoziaData()
 {
     if ($this->askoziaFlag) {
         if (!empty($this->askoziaUrl) and !empty($this->askoziaLogin) and !empty($this->askoziaPassword)) {
             $callsTmp = array();
             $normalCalls = array();
             //working time setup
             $rawWorkTime = $this->altCfg['WORKING_HOURS'];
             $rawWorkTime = explode('-', $rawWorkTime);
             $workStartTime = $rawWorkTime[0];
             $workEndTime = $rawWorkTime[1];
             $fields = array('extension_number' => 'all', 'cdr_filter' => 'incomingoutgoing', 'period_from' => $this->curmonth . '-01', 'period_to' => curdate(), 'date_format' => 'Y-m-d', 'time_format' => 'H:i:s', 'page_format' => 'A4', 'SubmitCSVCDR' => 'Download CSV');
             $ch = curl_init();
             curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
             curl_setopt($ch, CURLOPT_URL, $this->askoziaUrl . '/status_cdr.php');
             curl_setopt($ch, CURLOPT_USERPWD, $this->askoziaLogin . ":" . $this->askoziaPassword);
             curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
             curl_setopt($ch, CURLOPT_POSTFIELDS, $fields);
             $rawResult = curl_exec($ch);
             curl_close($ch);
             if (!empty($rawResult)) {
                 $callsTmp = explodeRows($rawResult);
                 if (!empty($callsTmp)) {
                     foreach ($callsTmp as $eachline) {
                         $explode = explode(';', $eachline);
                         //in 2.2.8 delimiter changed from ," to ;
                         if (!empty($eachline)) {
                             $normalCalls[] = str_replace('"', '', $explode);
                         }
                     }
                 }
                 if (!empty($normalCalls)) {
                     unset($normalCalls[0]);
                     foreach ($normalCalls as $io => $each) {
                         if ($each[16] != 'outbound') {
                             $startTime = explode(' ', $each[9]);
                             @($startTime = $startTime[1]);
                             //only working time
                             if (zb_isTimeBetween($workStartTime, $workEndTime, $startTime)) {
                                 if (ispos($each[14], 'ANSWERED') and !ispos($each[7], 'VoiceMail')) {
                                     $this->storeTmp['a_totalanswered']++;
                                 }
                                 $this->storeTmp['a_totalcalls']++;
                                 //call duration in seconds increment
                                 $this->storeTmp['a_totalcallsduration'] += $each[13];
                             }
                         }
                     }
                     //average calls duration
                     $this->storeTmp['a_averagecallduration'] = $this->storeTmp['a_totalcallsduration'] / $this->storeTmp['a_totalanswered'];
                 }
             }
         }
     }
 }
Esempio n. 28
0
 /**
  * Shows signups performed today
  * 
  * @return void
  */
 function web_SignupsShowToday()
 {
     $messages = new UbillingMessageHelper();
     $query = "SELECT COUNT(`id`) from `userreg` WHERE `date` LIKE '" . curdate() . "%'";
     $sigcount = simple_query($query);
     $sigcount = $sigcount['COUNT(`id`)'];
     show_window('', $messages->getStyledMessage(__('Today signups') . ': ' . wf_tag('strong') . $sigcount . wf_tag('strong', true), 'info'));
 }
Esempio n. 29
0
 /**
  * renders finance report
  * 
  * @return void
  */
 public function reportFinance()
 {
     $show_year = !wf_CheckPost(array('yearsel')) ? curyear() : $_POST['yearsel'];
     $dateSelectorPreset = wf_CheckPost(array('showdatepayments')) ? $_POST['showdatepayments'] : curdate();
     $dateinputs = wf_DatePickerPreset('showdatepayments', $dateSelectorPreset);
     $dateinputs .= wf_Submit(__('Show'));
     $dateform = wf_Form(self::URL_REPORTS_MGMT . 'reportFinance', 'POST', $dateinputs, 'glamour');
     $yearinputs = wf_YearSelector('yearsel');
     $yearinputs .= wf_Submit(__('Show'));
     $yearform = wf_Form(self::URL_REPORTS_MGMT . 'reportFinance', 'POST', $yearinputs, 'glamour');
     $controlcells = wf_TableCell(wf_tag('h3', false, 'title') . __('Year') . wf_tag('h3', true));
     $controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Payments by date') . wf_tag('h3', true));
     $controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Debt') . wf_tag('h3', true));
     $controlrows = wf_TableRow($controlcells);
     $controlcells = wf_TableCell($yearform);
     $controlcells .= wf_TableCell($dateform);
     //extract total debt summ
     $debt_q = "SELECT SUM(`cash`) as `totaldebt`, COUNT(`id`) as `debtcount` from `ukv_users` WHERE `cash`<0";
     $totalDebt = simple_query($debt_q);
     $debtData = __('Cash') . ': ' . wf_tag('b') . $totalDebt['totaldebt'] . wf_tag('b', true) . wf_tag('br');
     $debtData .= __('Count') . ': ' . wf_tag('b') . $totalDebt['debtcount'] . wf_tag('b', true);
     $controlcells .= wf_TableCell($debtData);
     $controlrows .= wf_TableRow($controlcells);
     $controlgrid = wf_TableBody($controlrows, '100%', 0, '');
     show_window('', $controlgrid);
     //show per month report
     $this->paymentsShowGraph($show_year);
     if (!isset($_GET['month'])) {
         // payments by somedate
         if (isset($_POST['showdatepayments'])) {
             $paydate = mysql_real_escape_string($_POST['showdatepayments']);
             $paydate = !empty($paydate) ? $paydate : curdate();
             show_window(__('Payments by date') . ' ' . $paydate, $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $paydate . "%' AND `visible`='1' ORDER by `date` DESC;"));
         } else {
             // today payments
             $today = curdate();
             show_window(__('Today payments'), $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $today . "%' AND `visible`='1' ORDER by `date` DESC;"));
         }
     } else {
         // show monthly payments
         $paymonth = mysql_real_escape_string($_GET['month']);
         show_window(__('Month payments'), $this->paymentsShow("SELECT * from `ukv_payments` WHERE `date` LIKE '" . $paymonth . "%'  AND `visible`='1' ORDER by `date` DESC;"));
     }
 }
Esempio n. 30
-1
/**
 * Returns count of undone tasks only for current admin login - used by DarkVoid
 * 
 * @return int
 */
function ts_GetUndoneCountersMy()
{
    $result = 0;
    $curdate = curdate();
    $curyear = curyear();
    $mylogin = whoami();
    $adminQuery = "SELECT `id` from `employee` WHERE `admlogin`='" . $mylogin . "'";
    $adminId = simple_query($adminQuery);
    if (!empty($adminId)) {
        $adminId = $adminId['id'];
        $query = "SELECT `id` from `taskman` WHERE `employee`='" . $adminId . "' AND `status` = '0' AND `startdate` <= '" . $curdate . "' AND `date` LIKE '" . $curyear . "-%';";
        $allundone = simple_queryall($query);
        if (!empty($allundone)) {
            $result = sizeof($allundone);
        }
    }
    return $result;
}