function content()
{
$page = CurrentPageName();
$tpl = new templates();
$t = $_GET["t"];
$ff = time();
$ID = $_GET["ID"];
if (!is_numeric($t)) {
$t = time();
}
$rp = new squid_report($ID);
$html = "\n\t<div class=BodyContent>\n\t\t<div style='font-size:14px'>\n\t\t\t<a href=\"miniadm.index.php\">{myaccount}</a>\n\t\t\t » <a href=\"miniadm.webstats-start.php?t={$t}\">{web_statistics}</a>\n\t\t\t » <a href=\"miniadm.MembersTrack.php\">{member_wwwtrack}</a>\n\t\t</div>\n\t\t<H1>{$rp->report}</H1>\n\t\t<p>" . $rp->explain() . "</p>\n\t</div>\t\n\t<div id='webstats-middle-{$ff}'></div>\n\t\n\t<script>\n\t\tLoadAjax('webstats-middle-{$ff}','{$page}?webstats-middle=yes&t={$t}&ID={$ID}');\n\t\t{$jsadd}\n\t</script>\n\t";
echo $tpl->_ENGINE_parse_body($html);
}
function report_items()
{
$t = $_GET["t"];
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$users = new usersMenus();
$sock = new sockets();
$search = '%';
$tablemain = "TrackMembers";
$page = 1;
$FORCE_FILTER = null;
$table = "(SELECT ID,report,userfield,userdata,categories,\n\t\tsitename,duration,scheduled,csv,LENGTH(csvContent) as csvContentBytes FROM {$tablemain}) as t";
if (!$q->TABLE_EXISTS($tablemain, $database)) {
json_error_show("{$table} doesn't exists...", 1);
}
if ($q->COUNT_ROWS($tablemain, $database) == 0) {
json_error_show("No rules", 1);
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
$searchstring = string_to_flexquery();
if ($searchstring != null) {
$sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER} {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database));
$total = $ligne["TCOUNT"];
} else {
$sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, $database);
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if (!$q->ok) {
json_error_show($q->mysql_error);
}
$rows_txt = $tpl->_ENGINE_parse_body("{rows}");
$scheduled_text = $tpl->_ENGINE_parse_body("{scheduled}");
while ($ligne = mysql_fetch_assoc($results)) {
$zmd5 = md5(serialize($ligne));
$color = "black";
$urljsSTAT = null;
$delete = imgsimple("delete-24.png", null, "ReportDelete{$t}(ID)");
$stats_img = "statistics-32-grey.png";
$rowsBlock_txt = null;
$rowsFormat = null;
$scheduled = null;
//familysite size hits
$ID_FIELD = $ligne["ID"];
$report_settings_js = "Loadjs('{$MyPage}?report-js=yes&ID={$ligne["ID"]}&t={$t}');";
$prctxt = null;
$urljsSIT = "<a href=\"javascript:blur();\" \n\tOnClick=\"javascript:{$report_settings_js}\"\n\tstyle='font-size:14px;text-decoration:underline;color:{$color}'>";
$ligne["report"] = utf8_encode($ligne["report"]);
$rp = new squid_report($ligne["ID"]);
$rows = $q->COUNT_ROWS("WebTrackMem{$ligne["ID"]}");
$rowsBlock = $q->COUNT_ROWS("WebTrackMeB{$ligne["ID"]}");
$explain = $tpl->_ENGINE_parse_body($rp->explain());
$run = imgsimple("run-24.png", "", "RunReport({$ligne["ID"]})");
if (is_file("ressources/logs/squid.report.{$ligne["ID"]}.rp")) {
$prc = trim(@file_get_contents("ressources/logs/squid.report.{$ligne["ID"]}.rp"));
if ($prc < 100) {
$ID_FIELD = "<img src='img/preloader.gif'>";
$prctxt = $tpl->_ENGINE_parse_body("<br>{building_report}: <strong>{$prc}%</strong>");
$run = "<img src='img/preloader.gif'>";
}
}
$rowsFormat = FormatNumber($rows);
if ($rows > 0) {
$urljsSTAT = "<a href=\"miniadm.MembersTrack.report.php?ID={$ligne["ID"]}\" style='font-size:14px;text-decoration:underline;color:{$color}'>";
$stats_img = "statistics-32.png";
}
if ($rowsBlock > 0) {
$rowsBlock = FormatNumber($rowsBlock);
$rowsBlock_txt = $tpl->_ENGINE_parse_body(" |{$rowsBlock} {blocked_rows}");
}
if ($ligne["scheduled"] == 1) {
$scheduled = " <i>({$scheduled_text})</i>";
}
$csvContentBytes = null;
if ($ligne["csvContentBytes"] > 0) {
$csvsize = FormatBytes($ligne["csvContentBytes"] / 1024);
$csvContentBytes = "<br><a href=\"{$MyPage}?csv={$ligne["ID"]}\" style='font-size:12px;color:{$color};text-decoration:underline'><strong>report{$ligne["ID"]}.csv.gz</a> <span style='font-size:11px'>({$csvsize})</span></strong>";
}
$data['rows'][] = array('id' => "{$ligne["ID"]}", 'cell' => array("<span style='font-size:14px;color:{$color}'>{$urljsSIT}{$ID_FIELD}</a></span>", "<span style='font-size:14px;color:{$color}'>{$urljsSIT}{$ligne["report"]}</a>{$prctxt}{$scheduled}{$csvContentBytes}</span>", "<span style='font-size:14px;color:{$color}'>{$urljsSTAT}{$explain}</span><div style='text-align:right'><i>{$rowsFormat} {$rows_txt}{$rowsBlock_txt}</i>{$rp->error}</div>", "<span style='font-size:14px;color:{$color}'>{$urljsSTAT}<img src='img/{$stats_img}'></a></span>", "<span style='font-size:14px;color:{$color}'>{$run}</span>", "<span style='font-size:14px;color:{$color}'>{$delete}</span>"));
}
echo json_encode($data);
}
