<?php
$BILL = new CBilling($GV["dbhost"], $GV["dbname"], $GV["dblogin"], $GV["dbpassword"]);
$list = $BILL->GetTarifs();
if (count($list)) {
for ($i = 0; $i < count($list); ++$i) {
$data = $list[$i];
$total_time_limit = $data[total_time_limit] ? gethours($data[total_time_limit]) . ":" . getmins($data[total_time_limit]) . ":" . getsecs($data[total_time_limit]) : "неограничено";
$month_time_limit = $data[month_time_limit] ? gethours($data[month_time_limit]) . ":" . getmins($data[month_time_limit]) . ":" . getsecs($data[month_time_limit]) : "неограничено";
$week_time_limit = $data[week_time_limit] ? gethours($data[week_time_limit]) . ":" . getmins($data[week_time_limit]) . ":" . getsecs($data[week_time_limit]) : "неограничено";
$day_time_limit = $data[day_time_limit] ? gethours($data[day_time_limit]) . ":" . getmins($data[day_time_limit]) . ":" . getsecs($data[day_time_limit]) : "неограничено";
$session_timeout = $data[session_timeout] ? gethours($data[session_timeout]) . ":" . getmins($data[session_timeout]) . ":" . getsecs($data[session_timeout]) : "неограничено";
$total_traffic_limit = $data[total_traffic_limit] ? bytes2mb($data[total_traffic_limit]) . " Мб" : "неограничено";
$month_traffic_limit = $data[month_traffic_limit] ? bytes2mb($data[month_traffic_limit]) . " Мб" : "неограничено";
$week_traffic_limit = $data[week_traffic_limit] ? bytes2mb($data[week_traffic_limit]) . " Мб" : "неограничено";
$day_traffic_limit = $data[day_traffic_limit] ? bytes2mb($data[day_traffic_limit]) . " Мб" : "неограничено";
$times_d = NULL;
$times_hf = NULL;
$times_ht = NULL;
$times_mf = NULL;
$times_mt = NULL;
makelogintimearrays($data[login_time], &$times_d, &$times_hf, &$times_ht, &$times_mf, &$times_mt);
$times_d_template_s = array("Mo", "Tu", "We", "Th", "Fr", "Sa", "Wk", "Al");
$times_d_template_t = array("Понедельник", "Вторник", "Среда", "Четверг", "Пятница", "Суббота", "Рабочие дни", "Все дни недели");
if (isset($times_d) && count($times_d)) {
$timeslist = "";
for ($j = 0; $j < count($times_d); ++$j) {
$dsel = "<select name=times_d[] style=\"width:100%;\" class=tbl1>";
for ($k = 0; $k < count($times_d_template_s); ++$k) {
if ($times_d[$j] == $times_d_template_s[$k]) {
$timeslist .= $times_d_template_t[$k];
$time_vals[3] = gethours($data['month_time_limit']);
$time_vals[4] = getmins($data['month_time_limit']);
$time_vals[5] = getsecs($data['month_time_limit']);
$time_vals[6] = gethours($data['week_time_limit']);
$time_vals[7] = getmins($data['week_time_limit']);
$time_vals[8] = getsecs($data['week_time_limit']);
$time_vals[9] = gethours($data['day_time_limit']);
$time_vals[10] = getmins($data['day_time_limit']);
$time_vals[11] = getsecs($data['day_time_limit']);
$time_vals[12] = gethours($data['session_timeout']);
$time_vals[13] = getmins($data['session_timeout']);
$time_vals[14] = getsecs($data['session_timeout']);
$vars[1] = bytes2mb($data['total_traffic_limit']);
$vars[2] = bytes2mb($data['month_traffic_limit']);
$vars[3] = bytes2mb($data['week_traffic_limit']);
$vars[4] = bytes2mb($data['day_traffic_limit']);
$vars[6] = (int) $data['simultaneous_use'];
$vars[5] = (int) $data['port_limit'];
$vars[7] = (int) $data['idle_timeout'];
$vars[8] = (int) $data['level'];
$vars[9] = $FLTR->ReverseProcessText($data['prim']);
$vars[10] = $data['rang'];
$vars[11] = $data['exceed_times'];
makelogintimearrays($data['login_time'], &$times_d, &$times_hf, &$times_ht, &$times_mf, &$times_mt);
$data['session_timeout'] = timeinsec($time_vals[12], $time_vals[13], $time_vals[14]);
}
if (!isset($vars)) {
$vars = array();
for ($i = 1; $i < 8; ++$i) {
$vars[$i] = 0;
}
} else {
$data = $BILL->GetTarifAccts($tarif, $fdate, $tdate, 1);
$tdata = $BILL->GetTarifData($tarif);
$accts = NULL;
$accts[0]["traffic"] = $data["traffic"];
$accts[0]["time"] = $data["time"];
$accts[0]["packet"] = $tdata["packet"];
}
$cnt = count($accts);
if (!isset($param)) {
$param = "";
}
if ($param == "traffic") {
for ($k = 0; $k < $cnt; ++$k) {
$data[$k] = $accts[$k]["traffic"];
$labels[$k] = $accts[$k]["packet"] . " (" . bytes2mb($accts[$k]["traffic"]) . " Мб)";
$fdate_s = date_dmy(strtotime($fdate));
$tdate_s = date_dmy(strtotime($tdate));
$params[14] = "Статистика тарифов по траффику за период " . $fdate_s . " - " . $tdate_s;
}
} else {
for ($k = 0; $k < $cnt; ++$k) {
$data[$k] = $accts[$k]["time"];
$labels[$k] = $accts[$k]["packet"] . " (" . gethours($accts[$k]["time"]) . ":" . getmins($accts[$k]["time"]) . ":" . getsecs($accts[$k]["time"]) . ")";
$fdate_s = date_dmy(strtotime($fdate));
$tdate_s = date_dmy(strtotime($tdate));
$params[14] = "Статистика тарифов по времени за период " . $fdate_s . " - " . $tdate_s;
}
}
break;
}
<tr><td width=50%>
Название тарифа:
</td><td width=50%><?php
OUT($data["packet"]);
?>
</td></tr>
<tr><td width=50%>
Количество пользователей:
</td><td width=50%><?php
OUT(count($BILL->GetUsersOfTarif($data["gid"])));
?>
</td></tr>
<tr><td width=50%>
Траффик:
</td><td width=50%><?php
OUT(bytes2mb($tdata["traffic"]) . " Mb");
?>
</td></tr>
<tr><td width=50%>
Время:
</td><td width=50%><?php
OUT(gethours($tdata["time"]) . ":" . getmins($tdata["time"]) . ":" . getsecs($tdata["time"]));
?>
</td></tr>
</table>
</td></tr>
</table>
<table width=100%><td width=50% class=tbl1 align=left>
<?php
if ($data["level"] <= $BILLEVEL) {
?>
$accts[0]["traffic"] = $data["traffic"];
$accts[0]["time"] = $data["time"];
$accts[0]["packet"] = $tdata["packet"];
}
$cnt = count($accts);
$tmpfdate = explode(" ", $fdate);
$ffdate = $tmpfdate[0];
$tmptdate = explode(" ", $tdate);
$ttdate = $tmptdate[0];
if (!isset($param)) {
$param = "";
}
if ($param == "traffic") {
for ($k = 0; $k < $cnt; ++$k) {
$data[$k + 1] = bytes2mb($accts[$k]["traffic"]);
$labels[$k + 1] = iconv('cp1251', 'utf-8', $accts[$k]["packet"]) . " (" . bytes2mb($accts[$k]["traffic"]) . " Мб)";
$fdate_s = date_dmy(strtotime($fdate));
$tdate_s = date_dmy(strtotime($tdate));
$title = "Статистика тарифов по траффику за период " . $fdate_s . " - " . $tdate_s;
}
} else {
for ($k = 0; $k < $cnt; ++$k) {
$data[$k + 1] = gethours($accts[$k]["time"]);
$labels[$k + 1] = iconv('cp1251', 'utf-8', $accts[$k]["packet"]) . " (" . gethours($accts[$k]["time"]) . ":" . getmins($accts[$k]["time"]) . ":" . getsecs($accts[$k]["time"]) . ")";
$fdate_s = date_dmy(strtotime($fdate));
$tdate_s = date_dmy(strtotime($tdate));
$title = "Статистика тарифов по времени за период " . $ffdate . " - " . $ttdate;
}
}
$chart['chart_type'] = "3D pie";
$chart['legend_label'] = array('font' => "Tahoma", 'size' => 10);
if ($prci < 100) {
$colorr = "00";
$colorg = "FF";
} else {
if ($prci > 200) {
$prci = 200.0;
}
$color = (int) (15.0 / 200.0 * $prci);
$colorr = dechex($color) . dechex($color);
$color = (int) (15.0 / 200.0 * (200.0 - $prci));
$colorg = dechex($color) . dechex($color);
}
?>
<td width=10px height=100% valign=bottom>
<font style="font-size:7px;font-color:#000000"><?php
OUT(bytes2mb($history[$i]["traffic"]));
?>
</font><br>
<table align=center bgcolor="#<?php
OUT($colorr);
OUT($colorg);
?>
00" height="<?php
OUT($prc);
?>
px" width=10px valign=bottom border=0>
<td class=tbl1 style="font-size:7px;font-color:#000000"></td>
</table>
<font style="font-size:7px;font-color:#000000"><br>
<?php
echo date("j") != $i + 1 ? $i + 1 : "<BIG><b>" . ($i + 1) . "</b></BIG>";
?>
</td>
<td class=tbl1><?php
OUT($accts[$i]["stop_time"]);
?>
</td>
<td class=tbl1><?php
OUT(bytes2mb($accts[$i]["out_bytes"], 3));
?>
Мб</td>
<td class=tbl1><?php
OUT(get_terminate_cause_str($accts[$i]["terminate_cause"]));
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class=tbl1><b>Итог</b></td>
<td class=tbl1></td>
<td class=tbl1></td>
<td class=tbl1></td>
<td class=tbl1><b><?php
OUT(bytes2mb($sumtra, 3));
?>
Мб</b></td>
<td class=tbl1></td>
</tr>
</table>
OUT("<div align=center>Сохранено!</div><br><div align=center><a href=\"?p={$p}&act={$act}\">назад</a></div>");
} else {
OUT("<div align=center>{$error}</div><br><div align=center><a href=\"?p={$p}&act={$act}\">назад</a></div>");
}
} else {
include SK_DIR . "/billing/month_stats.php";
?>
<form action="<?php
OUT("?p={$p}&act={$act}&action=save");
?>
" method=post>
<div align=center style="font-size:11px"><b>Настройки системы:</b></div>
<table width=80% class=tbl1 align=center>
<tr><td width=70%>Предельное месячное количество траффика (Мб):</td><td><input value="<?php
OUT(bytes2mb($GV["max_month_traffic"]));
?>
" type=text name=max_month_traffic class=inputbox style="width:100%"></td></tr>
<tr><td width=70%>Начальный год отсчёта:</td><td><input value="<?php
OUT($GV["start_year"]);
?>
" type=text name=start_year class=inputbox style="width:100%"></td></tr>
</table>
<div align=center><input class=button type=submit value="Сохранить"></div>
</form>
<div align=center><a href="<?php
OUT("?p={$p}");
?>
">назад</a></div>
<?php
}
function log_url_user_template($data, $onlinedata = null)
{
global $DIRS;
?>
<table width=100% align=center class=tbl2>
<tr><td width=100% colspan=2>
<div align=center><b><?php
OUT($data["fio"]);
?>
</b></div>
</td></tr>
<tr><td width=30%>
<table width=100% align=center><tr><td align=center width=100% align=center>
<a href="<?php
OUT("?p=users&act=userinfo&id=" . $data["uid"]);
?>
">
<b><?php
OUT($data["nick"]);
?>
</b><br>
<?php
if (file_exists($DIRS["users_avatars"] . "/" . $data["uid"]) && is_file($DIRS["users_avatars"] . "/" . $data["uid"])) {
OUT("<img border=0 src=\"" . $DIRS["users_avatars"] . "/" . $data["uid"] . "\">");
}
?>
</a>
</td></tr><tr><td align=center>
<?php
OUT($data["rang"]);
?>
</td></tr>
<tr><td align=center height=100% valign=top>
<?php
OUT(make_raiting_str($data["raiting"]));
?>
</td></tr>
</table>
</td><td width=70%>
<table width=100% class=tbl1>
<tr><td width=50%>
Login:
</td><td width=50%><?php
OUT($onlinedata["user"]);
?>
</td></tr>
<tr><td width=50%>
VIP:
</td><td width=50%><?php
OUT($onlinedata["ip"]);
?>
</td></tr>
<tr><td width=50%>
IP:
</td><td width=50%><?php
OUT($onlinedata["call_from"]);
?>
</td></tr>
<tr><td width=50%>
Траффик:
</td><td width=50%><?php
OUT(bytes2mb($onlinedata["out_bytes"]) . " Mb (" . bytes2kb($onlinedata["out_bytes"]) . " Kb)");
?>
</td></tr>
<tr><td width=50%>
Время:
</td><td width=50%><?php
OUT(gethours($onlinedata["time_on"]) . ":" . getmins($onlinedata["time_on"]) . ":" . getsecs($onlinedata["time_on"]));
?>
</td></tr>
<tr><td width=50%>
Начало сессии:
</td><td width=50%><?php
OUT(norm_date(strtotime($onlinedata["start_time"])));
?>
</td></tr>
<tr><td width=50%>
Последнее изменение:
</td><td width=50%><?php
OUT(norm_date($onlinedata["last_change"]));
?>
</td></tr>
<?php
if ($onlinedata["terminate_cause"] != "Online") {
?>
<tr><td width=50%>
Конец сессии:
</td><td width=50%><?php
OUT(norm_date(strtotime($onlinedata["stop_time"])));
?>
</td></tr>
<?php
}
?>
</table>
</td>
</table>
<?php
}
<tr><td width=50%>
VIP:
</td><td width=50%><?php
OUT($list[$i]["ip"]);
?>
</td></tr>
<tr><td width=50%>
IP:
</td><td width=50%><?php
OUT($list[$i]["call_from"]);
?>
</td></tr>
<tr><td width=50%>
Траффик:
</td><td width=50%><?php
OUT(bytes2mb($list[$i]["out_bytes"]) . " Mb (" . bytes2kb($list[$i]["out_bytes"]) . " Kb)");
?>
</td></tr>
<tr><td width=50%>
Время:
</td><td width=50%><?php
OUT(gethours($list[$i]["time_on"]) . ":" . getmins($list[$i]["time_on"]) . ":" . getsecs($list[$i]["time_on"]));
?>
</td></tr>
<tr><td width=50%>
Начало сессии:
</td><td width=50%><?php
OUT(norm_date(strtotime($list[$i]["start_time"])));
?>
</td></tr>
<tr><td width=50%>
OUT(bytes2mb($accts[$k]["traffic"], 3));
?>
Мб</td>
<td class=tbl1><?php
OUT(gethours($accts[$k]["time"]) . ":" . getmins($accts[$k]["time"]) . ":" . getsecs($accts[$k]["time"]));
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class=tbl1><b>Всего</b></td>
<td class=tbl1></td>
<td class=tbl1><b><?php
OUT(bytes2mb($sumtra, 3) . " Mb");
?>
</b></td>
<td class=tbl1><b><?php
OUT(gethours($sumtim) . ":" . getmins($sumtim) . ":" . getsecs($sumtim));
?>
</b></td>
</tr>
</table>
<?php
if ($cnt) {
?>
<table width=100%><td width=50% align=center>
<td width=50% align=center>
<div align=center><a target=_blank href="<?php
