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;
}
