function stg_show_fulluserlistOld() { global $alter_conf; $allusers = zb_UserGetAllStargazerData(); $allrealnames = zb_UserGetAllRealnames(); $alladdress = zb_AddressGetFulladdresslist(); if ($alter_conf['USER_LINKING_ENABLED']) { $alllinkedusers = cu_GetAllLinkedUsers(); $allparentusers = cu_GetAllParentUsers(); } $totaltraff_i = 0; $totaltraff_m = 0; $totaltraff = 0; $ucount = 0; $trueonline = 0; $inacacount = 0; $tcredit = 0; $tcash = 0; // LAT column if ($alter_conf['ONLINE_LAT']) { $lat_col_head = wf_TableCell(__('LAT')); $act_offset = 1; } else { $lat_col_head = ''; $act_offset = 0; } //online stars if ($alter_conf['DN_ONLINE_DETECT']) { $true_online_header = wf_TableCell(__('Users online')); $true_online_selector = ' col_' . (5 + $act_offset) . ': "select",'; } else { $true_online_header = ''; $true_online_selector = ''; } //extended filters if ($alter_conf['ONLINE_FILTERS_EXT']) { $extfilters = wf_Link('javascript:showfilter();', __('Extended filters'), false); } else { $extfilters = ''; } //additional finance links if ($alter_conf['FAST_CASH_LINK']) { $fastcash = true; } else { $fastcash = false; } $result = $extfilters; $result .= wf_tag('table', false, 'sortable', 'width="100%" id="onlineusers"'); $headerCells = wf_TableCell(__('Full address')); $headerCells .= wf_TableCell(__('Real Name')); $headerCells .= wf_TableCell(__('IP')); $headerCells .= wf_TableCell(__('Tariff')); $headerCells .= $lat_col_head; $headerCells .= wf_TableCell(__('Active')); $headerCells .= $true_online_header; $headerCells .= wf_TableCell(__('Traffic')); $headerCells .= wf_TableCell(__('Balance')); $headerCells .= wf_TableCell(__('Credit')); $headerRow = wf_TableRow($headerCells, 'row1'); $result .= $headerRow; if (!empty($allusers)) { foreach ($allusers as $io => $eachuser) { $tinet = 0; $ucount++; $cash = $eachuser['Cash']; $credit = $eachuser['Credit']; for ($classcounter = 0; $classcounter <= 9; $classcounter++) { $dc = 'D' . $classcounter . ''; $uc = 'U' . $classcounter . ''; $tinet = $tinet + ($eachuser[$dc] + $eachuser[$uc]); } $totaltraff = $totaltraff + $tinet; $tcredit = $tcredit + $credit; $tcash = $tcash + $cash; $act = web_green_led() . ' ' . __('Yes'); //finance check if ($cash < '-' . $credit) { $act = web_red_led() . ' ' . __('No'); $inacacount++; } if ($alter_conf['ONLINE_LAT']) { $user_lat = wf_TableCell(date("Y-m-d H:i:s", $eachuser['LastActivityTime'])); } else { $user_lat = ''; } //online check if ($alter_conf['DN_ONLINE_DETECT']) { if (file_exists(DATA_PATH . 'dn/' . $eachuser['login'])) { $online_flag = 1; $trueonline++; } else { $online_flag = 0; } $online_cell = wf_TableCell(web_bool_star($online_flag, true), '', '', 'sorttable_customkey="' . $online_flag . '"'); } else { $online_cell = ''; $online_flag = 0; } if ($alter_conf['ONLINE_LIGHTER']) { $lighter = 'onmouseover="this.className = \'row2\';" onmouseout="this.className = \'row3\';" '; } else { $lighter = ''; } //user linking indicator if ($alter_conf['USER_LINKING_ENABLED']) { //is user child? if (isset($alllinkedusers[$eachuser['login']])) { $corporate = wf_Link('?module=corporate&userlink=' . $alllinkedusers[$eachuser['login']], web_corporate_icon(), false); } else { $corporate = ''; } //is user parent? if (isset($allparentusers[$eachuser['login']])) { $corporate = wf_Link('?module=corporate&userlink=' . $allparentusers[$eachuser['login']], web_corporate_icon('Corporate parent'), false); } } else { $corporate = ''; } //fast cash link if ($fastcash) { $financelink = wf_Link('?module=addcash&username='******'login'] . '#profileending', wf_img('skins/icon_dollar.gif', __('Finance operations')), false); } else { $financelink = ''; } $result .= wf_tag('tr', false, 'row3', $lighter); $result .= wf_tag('td', false); $result .= wf_Link('?module=traffstats&username='******'login'], web_stats_icon(), false); $result .= $financelink; $result .= wf_Link('?module=userprofile&username='******'login'], web_profile_icon(), false); $result .= $corporate; $result .= @$alladdress[$eachuser['login']]; $result .= wf_tag('td', true); $result .= wf_TableCell(@$allrealnames[$eachuser['login']]); $result .= wf_TableCell($eachuser['IP'], '', '', 'sorttable_customkey="' . ip2int($eachuser['IP']) . '"'); $result .= wf_TableCell($eachuser['Tariff']); $result .= $user_lat; $result .= wf_TableCell($act); $result .= $online_cell; $result .= wf_TableCell(stg_convert_size($tinet), '', '', 'sorttable_customkey="' . $tinet . '"'); $result .= wf_TableCell(round($eachuser['Cash'], 2)); $result .= wf_TableCell(round($eachuser['Credit'], 2)); $result .= wf_tag('tr', true); } } if ($alter_conf['DN_ONLINE_DETECT']) { $true_online_counter = wf_TableCell(__('Users online') . ' ' . $trueonline); } else { $true_online_counter = null; } $result .= wf_tag('table', true); $footerCells = wf_TableCell(__('Total') . ': ' . $ucount); $footerCells .= wf_TableCell(__('Active users') . ' ' . ($ucount - $inacacount) . ' / ' . __('Inactive users') . ' ' . $inacacount); $footerCells .= $true_online_counter; $footerCells .= wf_TableCell(__('Traffic') . ': ' . stg_convert_size($totaltraff)); $footerCells .= wf_TableCell(__('Total') . ': ' . round($tcash, 2)); $footerCells .= wf_TableCell(__('Credit total') . ': ' . $tcredit); $footerRows = wf_TableRow($footerCells, 'row1'); $result .= wf_TableBody($footerRows, '100%', '0'); //extended filters again if ($alter_conf['ONLINE_FILTERS_EXT']) { $filtercode = wf_tag('script', false, '', 'language="javascript" type="text/javascript"'); $filtercode .= ' //<![CDATA[ function showfilter() { var onlinefilters = { btn: false, col_' . (4 + $act_offset) . ': "select", ' . $true_online_selector . ' btn_text: ">" } setFilterGrid("onlineusers",0,onlinefilters); } //]]>'; $filtercode .= wf_tag('script', true); } else { $filtercode = ''; } $result .= $filtercode; return $result; }
/** * Generates HTML-table, containing existing lines * * @return string HTML-table */ public function line_list_show() { // Query lines: $query = "SELECT\n `" . self::TABLE_LINES . "`.`id`,\n `" . self::TABLE_LINES . "`.`point_start`,\n `" . self::TABLE_LINES . "`.`point_end`,\n `" . self::TABLE_LINES . "`.`fibers_amount`,\n `" . self::TABLE_LINES . "`.`length`,\n `" . self::TABLE_LINES . "`.`description`,\n `employee`.`name` AS `engineer`,\n `" . self::TABLE_LINES . "`.`param_color`,\n `" . self::TABLE_LINES . "`.`geo`\n FROM `" . self::TABLE_LINES . "`\n LEFT JOIN `employee`\n ON `" . self::TABLE_LINES . "`.`employee_id` = `employee`.id\n "; $result = simple_queryall($query); // HTML-table header: $cells = wf_TableCell(__('ID')); $cells .= wf_TableCell(__('Starting point')); $cells .= wf_TableCell(__('End point')); $cells .= wf_TableCell(__('Fibers amount'), 75); $cells .= wf_TableCell(__('Length'), 100); $cells .= wf_TableCell(__('Description'), 350); $cells .= wf_TableCell(__('Engineer')); $cells .= wf_TableCell(__('Color'), 60); $cells .= wf_TableCell(__('Actions'), 80); $rows = wf_TableRow($cells, 'row2'); // HTML-table content: if (!empty($result)) { foreach ($result as $line) { // Color decoration: $line['param_color'] = '<span style="color: ' . $line['param_color'] . '">' . $line['param_color'] . '</span>'; $cells = wf_TableCell($line['id']); $cells .= wf_TableCell($line['point_start']); $cells .= wf_TableCell($line['point_end']); $cells .= wf_TableCell($line['fibers_amount']); $cells .= wf_TableCell($line['length']); $cells .= wf_TableCell($line['description']); $cells .= wf_TableCell($line['engineer']); $cells .= wf_TableCell($line['param_color']); // Actions: $actions = wf_Link(self::URL_LINE_DEL . $line['id'], web_delete_icon()); $actions .= wf_Link(self::URL_LINE_EDIT . $line['id'], web_edit_icon()); $actions .= wf_Link(self::URL_LINE_DOCS . $line['id'], web_corporate_icon('Documentation')); if (empty($line['geo']) || $line['geo'] == '[ ]') { $actions .= wf_Link(self::URL_LINE_PLACE . $line['id'], web_add_icon(__('Place on map'))); } $cells .= wf_TableCell($actions); $rows .= wf_TableRow($cells, 'row3'); } } else { $cells = wf_TableCell(__('There is no lines to show'), null, null, 'colspan="9" align="center"'); $rows .= wf_TableRow($cells, 'row3'); } // Generate HTML-table: return wf_TableBody($rows, '100%', '0'); }
function bs_ShowHash($hash) { $hash = vf($hash); $allrealnames = zb_UserGetAllRealnames(); $alladdress = zb_AddressGetFulladdresslist(); $checkarr = bs_SearchCheckArr($alladdress, $allrealnames); $alter_conf = rcms_parse_ini_file(CONFIG_PATH . 'alter.ini'); $query = "SELECT * from `bankstaparsed` WHERE `hash`='" . $hash . "' ORDER BY `id` DESC"; $alldata = simple_queryall($query); // проверяем врублены ли корпоративные пользователи if ($alter_conf['USER_LINKING_ENABLED']) { $alllinkedusers = cu_GetAllLinkedUsers(); $allparentusers = cu_GetAllParentUsers(); } if (!empty($alldata)) { $tablecells = wf_TableCell(__('ID')); $tablecells .= wf_TableCell(__('Real Name')); $tablecells .= wf_TableCell(__('Address')); $tablecells .= wf_TableCell(__('Cash')); $tablecells .= wf_TableCell(__('Login poroposal')); $tablecells .= wf_TableCell(__('Processed')); $tablecells .= wf_TableCell(__('Actions')); $tablerows = wf_TableRow($tablecells, 'row1'); foreach ($alldata as $io => $eachrow) { $tablecells = wf_TableCell($eachrow['id']); $tablecells .= wf_TableCell(bs_NameEditForm($eachrow['id'], $eachrow['realname'])); $tablecells .= wf_TableCell(bs_AddressEditForm($eachrow['id'], $eachrow['address'])); $tablecells .= wf_TableCell($eachrow['summ']); //proposal subroutine if (empty($eachrow['login'])) { $proposed_login = bs_SearchLoginByAddresspart($eachrow['address'], $eachrow['realname'], $checkarr); //if no one found if (sizeof($proposed_login) == 0) { $proposal_form = bs_LoginProposalForm($eachrow['id'], ''); } //if only one user found if (sizeof($proposed_login) == 1) { $proposal_form = bs_LoginProposalForm($eachrow['id'], $proposed_login[0]); //заполним со старта что-ли simple_update_field('bankstaparsed', 'login', $proposed_login[0], "WHERE `id`='" . $eachrow['id'] . "'"); } //if many users found if (sizeof($proposed_login) > 1) { //считаем что это корпоративный пользователь и достаем для него родительского if ($alter_conf['USER_LINKING_ENABLED']) { foreach ($proposed_login as $eachcorp) { if (bs_cu_IsParent($eachcorp, $allparentusers)) { $proposal_form = web_corporate_icon() . ' ' . $eachcorp; //заполним родительского пользователя simple_update_field('bankstaparsed', 'login', $eachcorp, "WHERE `id`='" . $eachrow['id'] . "'"); } } } else { // если корпоративщина не включена - вываливаем екзепшн $proposal_form = __('Multiple users found'); } } } else { $proposal_form = bs_LoginProposalForm($eachrow['id'], $eachrow['login']); } $tablecells .= wf_TableCell($proposal_form); $procflag = web_bool_led($eachrow['state']); if (!$eachrow['state']) { $actlink = wf_JSAlert("?module=bankstatements&lockrow=" . $eachrow['id'] . "&showhash=" . $eachrow['hash'], web_key_icon('Lock'), __('Are you serious')); } else { $actlink = ''; } $tablecells .= wf_TableCell($procflag); $tablecells .= wf_TableCell($actlink); $tablerows .= wf_TableRow($tablecells, 'row3'); } $result = wf_TableBody($tablerows, '100%', '0', 'sortable'); } else { $result = __('Strange exeption catched'); } show_window('', wf_Link("?module=bankstatements", 'Back', true, 'ubButton')); show_window(__('Bank statement processing'), $result); }