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