function zbs_CatvShowPayments($catv_payments) { $monthnames = zbs_months_array_wz(); if (!empty($catv_payments)) { $cells = la_TableCell(__('Date')); $cells .= la_TableCell(__('Cash')); $cells .= la_TableCell(__('Month')); $cells .= la_TableCell(__('Year')); $rows = la_TableRow($cells, 'row1'); foreach ($catv_payments as $io => $each) { $cells = la_TableCell($each['date']); $cells .= la_TableCell($each['summ']); $cells .= la_TableCell(__($monthnames[$each['from_month']])); $cells .= la_TableCell($each['from_year']); $rows .= la_TableRow($cells, 'row3'); } $result = la_TableBody($rows, '100%', '0', ''); show_window(__('CaTV payments'), $result); } else { show_window(__('Sorry'), __('No payments to display')); } }
/** * Renders user traffic stats report * * @param string $login * @return string */ function zbs_UserTraffStats($login) { $login = vf($login); $alldirs = zbs_DirectionsGetAll(); $monthnames = zbs_months_array_wz(); /* * Current month traffic stats */ $result = la_tag('h3') . __('Current month traffic stats') . la_tag('h3', true); $cells = la_TableCell(__('Traffic classes')); $cells .= la_TableCell(__('Downloaded')); $cells .= la_TableCell(__('Uploaded')); $cells .= la_TableCell(__('Total')); $rows = la_TableRow($cells, 'row1'); if (!empty($alldirs)) { foreach ($alldirs as $io => $eachdir) { $query_downup = "SELECT `D" . $eachdir['rulenumber'] . "`,`U" . $eachdir['rulenumber'] . "` from `users` WHERE `login`='" . $login . "'"; $downup = simple_query($query_downup); $cells = la_TableCell($eachdir['rulename']); $cells .= la_TableCell(zbs_convert_size($downup['D' . $eachdir['rulenumber']])); $cells .= la_TableCell(zbs_convert_size($downup['U' . $eachdir['rulenumber']])); $cells .= la_TableCell(zbs_convert_size($downup['U' . $eachdir['rulenumber']] + $downup['D' . $eachdir['rulenumber']])); $rows .= la_TableRow($cells, 'row3'); } } $result .= la_TableBody($rows, '100%', 0, ''); $result .= la_delimiter(); /* * traffic stats by previous months */ $result .= la_tag('h3') . __('Previous month traffic stats') . la_tag('h3', true); $cells = la_TableCell(__('Year')); $cells .= la_TableCell(__('Month')); $cells .= la_TableCell(__('Traffic classes')); $cells .= la_TableCell(__('Downloaded')); $cells .= la_TableCell(__('Uploaded')); $cells .= la_TableCell(__('Total')); $cells .= la_TableCell(__('Cash')); $rows = la_TableRow($cells, 'row1'); if (!empty($alldirs)) { foreach ($alldirs as $io => $eachdir) { $query_prev = "SELECT `D" . $eachdir['rulenumber'] . "`,`U" . $eachdir['rulenumber'] . "`,`month`,`year`,`cash` from `stat` WHERE `login`='" . $login . "' ORDER BY `year`,`month`"; $allprevmonth = simple_queryall($query_prev); if (!empty($allprevmonth)) { foreach ($allprevmonth as $io2 => $eachprevmonth) { $cells = la_TableCell($eachprevmonth['year']); $cells .= la_TableCell(__($monthnames[$eachprevmonth['month']])); $cells .= la_TableCell($eachdir['rulename']); $cells .= la_TableCell(zbs_convert_size($eachprevmonth['D' . $eachdir['rulenumber']])); $cells .= la_TableCell(zbs_convert_size($eachprevmonth['U' . $eachdir['rulenumber']])); $cells .= la_TableCell(zbs_convert_size($eachprevmonth['U' . $eachdir['rulenumber']] + $eachprevmonth['D' . $eachdir['rulenumber']])); $cells .= la_TableCell(round($eachprevmonth['cash'], 2)); $rows .= la_TableRow($cells, 'row3'); } } } } $result .= la_TableBody($rows, '100%', 0, ''); return $result; }