/**
* Passport data editing form
*
* @param $login - user login
* @param $passportdata - user passport data array
*
* @return void
*
*/
function web_PassportDataEditFormshow($login, $passportdata)
{
$alladdress = zb_AddressGetFulladdresslist();
@($useraddress = $alladdress[$login]);
//extracting passport data
if (!empty($passportdata)) {
$birthdate = $passportdata['birthdate'];
$passportnum = $passportdata['passportnum'];
$passportdate = $passportdata['passportdate'];
$passportwho = $passportdata['passportwho'];
$pcity = $passportdata['pcity'];
$pstreet = $passportdata['pstreet'];
$pbuild = $passportdata['pbuild'];
$papt = $passportdata['papt'];
} else {
$birthdate = '';
$passportnum = '';
$passportdate = '';
$passportwho = '';
$pcity = '';
$pstreet = '';
$pbuild = '';
$papt = '';
}
//form construction
$inputs = wf_tag('h3') . __('Passport data') . wf_tag('h3', true);
$inputs .= wf_DatePickerPreset('editbirthdate', $birthdate, true);
$inputs .= __('Birth date');
$inputs .= wf_delimiter();
$inputs .= wf_TextInput('editpassportnum', __('Passport number'), $passportnum, false, '35');
$inputs .= wf_delimiter();
$inputs .= wf_TextInput('editpassportwho', __('Issuing authority'), $passportwho, false, '35');
$inputs .= wf_delimiter();
$inputs .= wf_DatePickerPreset('editpassportdate', $passportdate, true);
$inputs .= __('Date of issue');
$inputs .= wf_delimiter();
$inputs .= wf_tag('h3') . __('Registration address') . wf_tag('h3', true);
$inputs .= wf_TextInput('editpcity', __('City'), $pcity, false, '20');
$inputs .= wf_delimiter();
$inputs .= wf_TextInput('editpstreet', __('Street'), $pstreet, false, '20');
$inputs .= wf_delimiter();
$inputs .= wf_TextInput('editpbuild', __('Build'), $pbuild, false, '5');
$inputs .= wf_delimiter();
$inputs .= wf_TextInput('editpapt', __('Apartment'), $papt, false, '5');
$inputs .= wf_delimiter();
$inputs .= wf_Submit(__('Save'));
$form = wf_Form('', 'POST', $inputs, 'glamour');
show_window(__('Edit') . ' ' . __('passport data') . ' ' . $useraddress, $form);
}
public function dateForm()
{
$inputs = wf_DatePickerPreset('date', $this->interval);
$inputs .= __('By date') . ' ';
$inputs .= wf_Submit(__('Show'));
$inputs .= ' ' . wf_Link("?module=report_autofreeze&showfrozen=true", __('Currently frozen'), false, 'ubButton');
$result = wf_Form("", 'POST', $inputs, 'glamour');
return $result;
}
<?php
if (cfr('REPORTFINANCE')) {
if (!wf_CheckGet(array('analytics'))) {
if (!wf_CheckPost(array('yearsel'))) {
$show_year = curyear();
} else {
$show_year = $_POST['yearsel'];
}
$altcfg = $ubillingConfig->getAlter();
$dateSelectorPreset = wf_CheckPost(array('showdatepayments')) ? $_POST['showdatepayments'] : curdate();
$dateinputs = wf_DatePickerPreset('showdatepayments', $dateSelectorPreset);
$dateinputs .= wf_Submit(__('Show'));
$dateform = wf_Form("?module=report_finance", 'POST', $dateinputs, 'glamour');
$yearinputs = wf_YearSelector('yearsel');
$yearinputs .= wf_Submit(__('Show'));
$yearform = wf_Form("?module=report_finance", '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') . __('Payment search') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Analytics') . wf_tag('h3', true));
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('ARPU') . wf_tag('h3', true));
if ($altcfg['AGENTS_ASSIGN'] == '2') {
$controlcells .= wf_TableCell(wf_tag('h3', false, 'title') . __('Agent payments') . wf_tag('h3', true));
}
$controlrows = wf_TableRow($controlcells);
$controlcells = wf_TableCell($yearform);
$controlcells .= wf_TableCell($dateform);
$controlcells .= wf_TableCell(wf_Link("?module=payfind", web_icon_search() . ' ' . __('Find'), false, 'ubButton'));
$controlcells .= wf_TableCell(wf_Link("?module=report_finance&analytics=true", wf_img('skins/icon_stats.gif') . ' ' . __('Show'), false, 'ubButton'));
$controlcells .= wf_TableCell(wf_Link("?module=report_arpu", wf_img('skins/ukv/report.png') . ' ' . __('Show'), false, 'ubButton'));
/**
* Returns CDR date selection form
*
* @return string
*/
function web_AsteriskDateForm()
{
global $user_login;
$inputs = wf_Link("?module=asterisk&config=true", wf_img('skins/settings.png', __('Settings'))) . ' ';
$inputs .= wf_DatePickerPreset('datefrom', curdate()) . ' ' . __('From');
$inputs .= wf_DatePickerPreset('dateto', curdate()) . ' ' . __('To');
if (!isset($user_login)) {
$inputs .= wf_Trigger('countnum', 'Показать самых назойливых', false);
}
$inputs .= wf_Submit(__('Show'));
$result = wf_Form("", "POST", $inputs, 'glamour');
return $result;
}
/**
* Renders search form. Deal with it.
*
* @return string
*/
public function renderSearchForm()
{
$result = '';
$datefromDefault = wf_CheckPost(array('datefrom')) ? $_POST['datefrom'] : curdate();
$datetoDefault = wf_CheckPost(array('dateto')) ? $_POST['dateto'] : curdate();
$inputs = __('Date') . ' ' . wf_DatePickerPreset('datefrom', $datefromDefault, true) . ' ' . __('From') . ' ' . wf_DatePickerPreset('dateto', $datetoDefault, true) . ' ' . __('To');
$inputs .= wf_tag('br');
$inputs .= wf_CheckInput('cb_id', '', false, false);
$inputs .= wf_TextInput('taskid', __('ID'), '', true, 4);
$inputs .= wf_CheckInput('cb_taskdays', '', false, false);
$inputs .= wf_TextInput('taskdays', __('Implementation took more days'), '', true, 4);
$inputs .= wf_CheckInput('cb_taskaddress', '', false, false);
$inputs .= wf_TextInput('taskaddress', __('Task address'), '', true, 20);
$inputs .= wf_CheckInput('cb_taskphone', '', false, false);
$inputs .= wf_TextInput('taskphone', __('Phone'), '', true, 20);
$inputs .= wf_CheckInput('cb_employee', '', false, false);
$inputs .= wf_Selector('employee', $this->activeEmployee, __('Who should do'), '', true);
$inputs .= wf_CheckInput('cb_employeedone', '', false, false);
$inputs .= wf_Selector('employeedone', $this->activeEmployee, __('Worker done'), '', true);
$inputs .= wf_CheckInput('cb_duplicateaddress', __('Duplicate address'), true, false);
$inputs .= wf_CheckInput('cb_showlate', __('Show late'), true, false);
$inputs .= wf_CheckInput('cb_onlydone', __('Done tasks'), true, false);
$inputs .= wf_CheckInput('cb_onlyundone', __('Undone tasks'), true, false);
if ($this->altCfg['SALARY_ENABLED']) {
$inputs .= wf_CheckInput('cb_nosalsaryjobs', __('Tasks without jobs'), true, false);
}
$inputs .= wf_Submit(__('Search'));
$result = wf_Form('', 'POST', $inputs, 'glamour');
$result .= wf_CleanDiv();
return $result;
}
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;
}
/**
* Returns tasks by date printing dialogue
*
* @return string
*/
function ts_PrintDialogue()
{
$inputs = wf_DatePickerPreset('printdatefrom', curdate()) . ' ' . __('From');
$inputs .= wf_DatePickerPreset('printdateto', curdate()) . ' ' . __('To');
$inputs .= wf_Submit(__('Print'));
$result = wf_Form("", 'POST', $inputs, 'glamour');
return $result;
}
/**
* Renders timesheet create form
*
* @return string
*/
public function timesheetCreateForm()
{
$result = '';
if (!empty($this->allEmployee)) {
$result .= '<!--ugly hack to prevent datepicker autoopen --> <input type="text" name="shittyhack" style="width: 0; height: 0; top: -100px; position: absolute;"/>';
$result .= wf_HiddenInput('newtimesheet', 'true');
$result .= wf_DatePickerPreset('newtimesheetdate', curdate(), false);
$headers = wf_TableCell(__('Worker'));
$headers .= wf_TableCell(__('Hours'));
$headers .= wf_TableCell(__('Hospitalized'));
$headers .= wf_TableCell(__('Holidays'));
$rows = wf_TableRow($headers, 'row1');
foreach ($this->allEmployee as $employeeid => $employeename) {
$defaultWorkTime = isset($this->allWages[$employeeid]['worktime']) ? $this->allWages[$employeeid]['worktime'] : 0;
$cells = wf_TableCell($employeename);
$cells .= wf_TableCell(wf_TextInput('_employeehours[' . $employeeid . ']', '', $defaultWorkTime, false, '2'));
$cells .= wf_TableCell(wf_CheckInput('_hospital[' . $employeeid . ']', '', false, false));
$cells .= wf_TableCell(wf_CheckInput('_holidays[' . $employeeid . ']', '', false, false));
$rows .= wf_TableRow($cells, 'row3');
}
$result .= wf_TableBody($rows, '100%', '0', '');
$result .= wf_tag('br', false);
$result .= wf_Submit(__('Create'));
$result = wf_Form('', 'POST', $result, '');
}
return $result;
}
/**
* Returns incoming operation creation form
*
* @return string
*/
public function incomingCreateForm()
{
if (!empty($this->allItemTypes) and !empty($this->allCategories) and !empty($this->allContractors) and !empty($this->allStorages)) {
//ajax selector URL-s preprocessing
$tmpCat = array();
$firstCateKey = key($this->allCategories);
foreach ($this->allCategories as $categoryId => $categoryName) {
$tmpCat[self::URL_ME . '&' . self::URL_IN . '&' . self::URL_AJITSELECTOR . $categoryId] = $categoryName;
}
$result = wf_AjaxLoader();
$inputs = wf_DatePickerPreset('newindate', curdate());
$inputs .= wf_tag('br');
$inputs .= wf_AjaxSelectorAC('ajItemtypesContainer', $tmpCat, __('Warehouse categories'), '', false);
if (cfr('WAREHOUSEDIR')) {
$inputs .= wf_Link(self::URL_ME . '&' . self::URL_CATEGORIES, wf_img_sized('skins/categories_icon.png', '', '10', '10'), false);
}
$inputs .= wf_tag('br');
$inputs .= wf_AjaxContainer('ajItemtypesContainer', '', $this->itemtypesCategorySelector('newinitemtypeid', $firstCateKey));
$inputs .= wf_Selector('newincontractorid', $this->allContractors, __('Contractor'), '', false);
if (cfr('WAREHOUSEDIR')) {
$inputs .= wf_Link(self::URL_ME . '&' . self::URL_CONTRACTORS, wf_img_sized('skins/whcontractor_icon.png', '', '10', '10'), false);
}
$inputs .= wf_tag('br');
$inputs .= wf_Selector('newinstorageid', $this->allStorages, __('Warehouse storage'), '', false);
if (cfr('WAREHOUSEDIR')) {
$inputs .= wf_Link(self::URL_ME . '&' . self::URL_STORAGES, wf_img_sized('skins/whstorage_icon.png', '', '10', '10'), false);
}
$inputs .= wf_tag('br');
$inputs .= wf_TextInput('newincount', __('Count'), '', false, 5);
$inputs .= wf_tag('br');
$inputs .= wf_TextInput('newinprice', __('Price per unit'), '', false, 5);
$inputs .= wf_tag('br');
$inputs .= wf_TextInput('newinbarcode', __('Barcode'), '', false, 15);
$inputs .= wf_tag('br');
$inputs .= wf_TextInput('newinnotes', __('Notes'), '', false, 30);
$inputs .= wf_tag('br');
$inputs .= wf_Submit(__('Create'));
$result .= wf_Form(self::URL_ME . '&' . self::URL_IN, 'POST', $inputs, 'glamour');
} else {
$result = $this->messages->getStyledMessage(__('You did not fill all the necessary directories'), 'error');
}
return $result;
}
function web_EasyCreditForm($login, $cash, $credit, $userTariff, $easycreditoption)
{
/////////////////internal controller
if (wf_CheckPost(array('easycreditlogin', 'easycreditlimit', 'easycreditexpire'))) {
global $billing;
$setCredit = vf($_POST['easycreditlimit']);
$setLogin = mysql_real_escape_string($_POST['easycreditlogin']);
$setExpire = mysql_real_escape_string($_POST['easycreditexpire']);
//set credit
$billing->setcredit($setLogin, $setCredit);
log_register('CHANGE Credit (' . $setLogin . ') ON ' . $setCredit);
//set credit expire date
$billing->setcreditexpire($setLogin, $setExpire);
log_register('CHANGE CreditExpire (' . $setLogin . ') ON ' . $setExpire);
rcms_redirect('?module=userprofile&username='******'-' . $credit) {
$creditProposal = $tariffPrice;
$creditNote = __('The amount of money in the account at the moment is sufficient to provide the service. It is therefore proposed to set a credit limit on the fee of the tariff.');
} else {
$creditProposal = abs($cash);
$creditNote = __('At the moment the account have debt. It is proposed to establish credit in its size.');
}
//calculate credit expire date
$nowTimestamp = time();
$creditSeconds = $easycreditoption * 86400;
//days*secs
$creditOffset = $nowTimestamp + $creditSeconds;
$creditExpireDate = date("Y-m-d", $creditOffset);
//construct form
$controlIcon = wf_tag('img', false, '', 'src="skins/icon_calendar.gif" height="10"');
$inputs = '';
$inputs .= wf_HiddenInput('easycreditlogin', $login);
$inputs .= wf_TextInput('easycreditlimit', '', $creditProposal, false, '5') . __('credit limit') . ' ';
$inputs .= __('until');
$inputs .= wf_DatePickerPreset('easycreditexpire', $creditExpireDate);
$inputs .= wf_Submit(__('Save'));
$form = wf_Form("", 'POST', $inputs, 'glamour');
$form .= $creditNote;
$result = wf_modal($controlIcon, __('Change') . ' ' . __('credit limit'), $form, '', '500', '180');
return $result;
}
/**
* 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;
}
/**
* 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;
}
/**
* 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;
}
/**
* Returns edit form
*
* @return string
*/
protected function editForm($noteId)
{
$noteData = $this->getNoteData($noteId);
if (!empty($noteData)) {
$inputs = wf_HiddenInput('editnoteid', $noteId);
$inputs .= wf_tag('label') . __('Text') . ': ' . wf_tag('br') . wf_tag('label', true);
$inputs .= wf_TextArea('edittext', '', $noteData['text'], true, '50x15');
$checkState = $noteData['active'] == 1 ? true : false;
$inputs .= wf_CheckInput('editactive', __('Personal note active'), true, $checkState);
$inputs .= wf_DatePickerPreset('editreminddate', $noteData['reminddate']);
$inputs .= wf_tag('label') . __('Remind only after this date') . wf_tag('label', true);
$inputs .= wf_tag('br');
$inputs .= wf_tag('br');
$inputs .= wf_Submit(__('Save'));
$result = wf_Form('', 'POST', $inputs, 'glamour');
} else {
$result = __('Strange exeption');
}
return $result;
}
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;
}
/**
* 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;
}
function web_TsmsDateForm()
{
$inputs = __('By date') . ' ' . wf_DatePickerPreset('showqueuedate', curdate());
$inputs .= wf_Submit(__('Show'));
$result = wf_Form("", "POST", $inputs, 'glamour');
return $result;
}
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;
}
/**
* 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;
}
/**
* Returns ajax inputs of required type
*
* @return string
*/
public function catchAjRequest()
{
$result = '';
if (wf_CheckGet(array('ajinput'))) {
$request = vf($_GET['ajinput']);
switch ($request) {
case 'addcash':
$result .= wf_HiddenInput('newschedaction', 'addcash');
$result .= wf_TextInput('newschedparam', __('Sum'), '', true, 5);
break;
case 'corrcash':
$result .= wf_HiddenInput('newschedaction', 'corrcash');
$result .= wf_TextInput('newschedparam', __('Sum'), '', true, 5);
break;
case 'setcash':
$result .= wf_HiddenInput('newschedaction', 'setcash');
$result .= wf_TextInput('newschedparam', __('Sum'), '', true, 5);
break;
case 'credit':
$result .= wf_HiddenInput('newschedaction', 'credit');
$result .= wf_TextInput('newschedparam', __('New credit'), '', true, 5);
break;
case 'creditexpire':
$result .= wf_HiddenInput('newschedaction', 'creditexpire');
$result .= wf_DatePickerPreset('newschedparam', curdate()) . ' ' . __('New credit expire') . wf_tag('br');
break;
case 'tariffchange':
$result .= wf_HiddenInput('newschedaction', 'tariffchange');
$result .= web_tariffselector('newschedparam') . ' ' . __('Tariff name') . wf_tag('br');
break;
case 'tagadd':
$result .= wf_HiddenInput('newschedaction', 'tagadd');
$allTags = array();
$allTagsRaw = simple_queryall("SELECT * from `tagtypes`");
if (!empty($allTagsRaw)) {
foreach ($allTagsRaw as $io => $each) {
$allTags[$each['id']] = $each['tagname'];
}
}
$result .= wf_Selector('newschedparam', $allTags, __('Tag'), '', true);
break;
case 'tagdel':
$result .= wf_HiddenInput('newschedaction', 'tagdel');
$allTags = array();
$allTagsRaw = simple_queryall("SELECT * from `tagtypes`");
if (!empty($allTagsRaw)) {
foreach ($allTagsRaw as $io => $each) {
$allTags[$each['id']] = $each['tagname'];
}
}
$result .= wf_Selector('newschedparam', $allTags, __('Tag'), '', true);
break;
case 'freeze':
$result .= wf_HiddenInput('newschedaction', 'freeze');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'unfreeze':
$result .= wf_HiddenInput('newschedaction', 'unfreeze');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'reset':
$result .= wf_HiddenInput('newschedaction', 'reset');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'setspeed':
$result .= wf_HiddenInput('newschedaction', 'setspeed');
$result .= wf_TextInput('newschedparam', __('New speed override'), '', true, 5);
break;
case 'down':
$result .= wf_HiddenInput('newschedaction', 'down');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'undown':
$result .= wf_HiddenInput('newschedaction', 'undown');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'ao':
$result .= wf_HiddenInput('newschedaction', 'ao');
$result .= wf_HiddenInput('newschedparam', '');
break;
case 'unao':
$result .= wf_HiddenInput('newschedaction', 'unao');
$result .= wf_HiddenInput('newschedparam', '');
break;
}
$result .= wf_TextInput('newschednote', __('Notes'), '', true, 30);
$result .= wf_Submit(__('Create'));
if ($request == 'noaction') {
$result = __('Please select action');
}
}
die($result);
}
/**
* 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;"));
}
}
/**
* returns user binding form
*
* @param $login string Existing user login
*
* @return string
*/
public function corpCreateAndBindForm($login)
{
if (!empty($this->taxtypes)) {
$sup = wf_tag('sup') . '*' . wf_tag('sup', true);
$inputs = wf_HiddenInput('createcorpid', 'true');
$inputs .= wf_HiddenInput('alsobindsomelogin', $login);
$inputs .= wf_TextInput('createcorpname', __('Corp name') . $sup, '', true, '40');
$inputs .= wf_TextInput('createaddress', __('Address'), '', true, '40');
$inputs .= $this->doctypeSelector('createdoctype', '');
$inputs .= wf_DatePickerPreset('createdocdate', curdate(), true) . ' ' . __('Document date') . wf_tag('br');
$inputs .= wf_TextInput('adddocnum', __('Document number'), '', true, '20');
$inputs .= wf_TextInput('addbankacc', __('Bank account'), '', true, '20');
$inputs .= wf_TextInput('addbankname', __('Bank name'), '', true, '20');
$inputs .= wf_TextInput('addbankmfo', __('Bank MFO'), '', true, '20');
$inputs .= wf_TextInput('addedrpou', __('EDRPOU'), '', true, '20');
$inputs .= wf_TextInput('addndstaxnum', __('NDS number'), '', true, '20');
$inputs .= wf_TextInput('addinncode', __('INN code'), '', true, '20');
$inputs .= wf_Selector('addtaxtype', $this->taxtypes, __('Tax type'), '', true);
$inputs .= wf_TextInput('addnotes', __('Notes'), '', true, '40');
$inputs .= wf_Submit(__('Create'));
$result = wf_Form(self::URL_CORPS_ADD, 'POST', $inputs, 'glamour');
} else {
$result = __('No existing tax types');
}
return $result;
}
