function requeteur_popup() { $page = CurrentPageName(); $tpl = new templates(); squid_stats_default_values(); $t = $_GET["t"]; $per["1m"] = "{minute}"; $per["5m"] = "5 {minutes}"; $per["10m"] = "10 {minutes}"; $per["1h"] = "{hour}"; $per["1d"] = "{day}"; $members["frommail"] = "{sender}"; $members["tomail"] = "{recipient}"; $q = new postgres_sql(); $Selectore = $q->fieldSelectore(); $html = "<div style='width:98%;margin-bottom:20px' class=form>\n\t<table style='width:100%'>\n\t<tr>\n\t\t\t\n\t\t<td style='vertical-align:top;font-size:18px' class=legend>{members}:</td>\n\t\t<td style='vertical-align:top;font-size:18px;'>" . Field_array_Hash($members, "members-{$t}", $_SESSION["SQUID_STATS_MEMBER"], "blur()", null, 0, "font-size:18px;") . "</td>\n\t</tr>\n\t<tr>\t\t\t\n\t\n\t\t<td style='vertical-align:top;font-size:18px' class=legend>{from_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("from-date-{$t}", $_SESSION["SQUID_STATS_DATE1"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("from-time-{$t}", $_SESSION["SQUID_STATS_TIME1"], ";font-size:18px;width:82px") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td style='vertical-align:top;font-size:18px' class=legend>{to_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("to-date-{$t}", $_SESSION["SQUID_STATS_DATE2"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("to-time-{$t}", $_SESSION["SQUID_STATS_TIME2"], ";font-size:18px;width:82px") . "</td>\n\t\t\n\t</tr>\n\t<tr>\n\t\t<td style='vertical-align:middle;font-size:18px' class=legend>{search}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . Field_text("search-{$t}", $_SESSION["SQUID_STATS_MEMBER_SEARCH"], ";font-size:18px;width:98%") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td style='vertical-align:top;font-size:18px;' colspan=2 align='right'><hr>" . button("{generate_statistics}", "Run{$t}()", 18) . "</td>\n\t</tr>\n\t</table>\n\t</div>\n<script>\nfunction Run{$t}(){\n\tvar date1=document.getElementById('from-date-{$t}').value;\n\tvar time1=document.getElementById('from-time-{$t}').value;\n\tvar date2=document.getElementById('to-date-{$t}').value\n\tvar time2=document.getElementById('to-time-{$t}').value;\n\tvar user=document.getElementById('members-{$t}').value;\n\tvar search=encodeURIComponent(document.getElementById('search-{$t}').value);\n\tvar interval=0;\n\t\n\n\t\n\tLoadjs('{$page}?query-js=yes&t={$t}&container=graph-{$t}&date1='+date1+'&time1='+time1+'&date2='+date2+'&time2='+time2+'&interval='+interval+'&user='******'&search='+search);\n\t\n}\n</script>\n\t"; echo $tpl->_ENGINE_parse_body($html); }
function requeteur_popup() { $page = CurrentPageName(); $tpl = new templates(); squid_stats_default_values(); $t = $_GET["t"]; $per["10m"] = "10 {minutes}"; $per["1h"] = "1 {hour}"; $per["1d"] = "1 {day}"; $per["1w"] = "1 {week}"; $per["30d"] = "1 {month}"; $members["MAC"] = "{MAC}"; $members["USERID"] = "{uid}"; $members["IPADDR"] = "{ipaddr}"; $q = new postgres_sql(); $Selectore = $q->fieldSelectore(); $stylelegend = "style='vertical-align:top;font-size:18px;padding-top:5px' nowrap"; $html = "<div style='width:98%;margin-bottom:20px' class=form>\n\t<table style='width:100%'>\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{from_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("from-date-{$t}", $_SESSION["SQUID_STATS_DATE1"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("from-time-{$t}", $_SESSION["SQUID_STATS_TIME1"], ";font-size:18px;width:82px") . "</td>\n\t\t\n\t</tr>\n\t\t<td {$stylelegend} class=legend>{to_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("to-date-{$t}", $_SESSION["SQUID_STATS_DATE2"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("to-time-{$t}", $_SESSION["SQUID_STATS_TIME2"], ";font-size:18px;width:82px") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{interval}:</td>\n\t\t<td style='vertical-align:top;font-size:18px;'>" . Field_array_Hash($per, "interval-{$t}", "10m", "blur()", null, 0, "font-size:18px;") . "</td>\n\t</tr>\t\n\t\t\t\t\n\t\t\t\t\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{member}:</td>\n\t\t<td style='vertical-align:top;font-size:18px;'>" . Field_text("members-search-{$t}", "*", "font-size:18px;") . "</td>\n\t</tr>\t\t\t\t\n\t<tr style='height:50px'>\t\n\t\t<td style='vertical-align:top;font-size:18px;' colspan=2 align='right'>" . button("{generate_statistics}", "Run{$t}()", 22) . "</td>\n\t</tr>\n\t</table>\n\t</div>\n<script>\nfunction Run{$t}(){\n\tvar date1=document.getElementById('from-date-{$t}').value;\n\tvar time1=document.getElementById('from-time-{$t}').value;\n\tvar date2=document.getElementById('to-date-{$t}').value\n\tvar time2=document.getElementById('to-time-{$t}').value;\n\tvar user='';\n\tvar interval=document.getElementById('interval-{$t}').value;\n\tvar searchuser=encodeURIComponent(document.getElementById('members-search-{$t}').value);\n\tvar categories='';\n\tLoadjs('{$page}?query-js=yes&t={$t}&container=graph-{$t}&categories='+categories+'&searchuser='******'&date1='+date1+'&time1='+time1+'&date2='+date2+'&time2='+time2+'&interval='+interval+'&user='+user);\n\n}\n</script>\n"; echo $tpl->_ENGINE_parse_body($html); }
function requeteur_popup() { $page = CurrentPageName(); $tpl = new templates(); squid_stats_default_values(); $t = $_GET["t"]; $per["1h"] = "1 {hour}"; $per["1d"] = "1 {day}"; $per["1w"] = "1 {week}"; $per["30d"] = "1 {month}"; $members["MAC"] = "{MAC}"; $members["USERID"] = "{uid}"; $members["IPADDR"] = "{ipaddr}"; $q = new influx(); $date_start = date("Y-m-d", intval(@file_get_contents("{$GLOBALS["BASEDIR"]}/DATE_START"))); $date_end = date("Y-m-d", intval(@file_get_contents("{$GLOBALS["BASEDIR"]}/DATE_END"))); $Selectore = "mindate:{$date_start};maxdate:{$date_end}"; $stylelegend = "style='vertical-align:top;font-size:18px;padding-top:5px' nowrap"; $html = "<div style='width:98%;margin-bottom:20px' class=form>\n\t<table style='width:100%'>\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{interval}:</td>\n\t\t<td style='vertical-align:top;font-size:18px;'>" . Field_array_Hash($per, "interval-{$t}", "10m", "blur()", null, 0, "font-size:18px;") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{members}:</td>\n\t\t<td style='vertical-align:top;font-size:18px;'>" . Field_array_Hash($members, "members-{$t}", $_SESSION["SQUID_STATS_MEMBER"], "blur()", null, 0, "font-size:18px;") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td {$stylelegend} class=legend>{from_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("from-date-{$t}", $_SESSION["SQUID_STATS_DATE1"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("from-time-{$t}", $_SESSION["SQUID_STATS_TIME1"], ";font-size:18px;width:82px") . "</td>\n\t\t\n\t</tr>\n\t\t<td {$stylelegend} class=legend>{to_date}:</td>\n\t\t<td style='vertical-align:top;font-size:18px'>" . field_date("to-date-{$t}", $_SESSION["SQUID_STATS_DATE2"], ";font-size:18px;width:160px", $Selectore) . "\n\t\t " . Field_text("to-time-{$t}", $_SESSION["SQUID_STATS_TIME2"], ";font-size:18px;width:82px") . "</td>\n\t</tr>\n\t<tr>\t\n\t\t<td style='vertical-align:top;font-size:18px;' colspan=2 align='right'>" . button("{generate_statistics}", "Run{$t}()", 18) . "</td>\n\t</tr>\n\t</table>\n\t</div>\n<script>\nfunction Run{$t}(){\n\tvar date1=document.getElementById('from-date-{$t}').value;\n\tvar time1=document.getElementById('from-time-{$t}').value;\n\tvar date2=document.getElementById('to-date-{$t}').value\n\tvar time2=document.getElementById('to-time-{$t}').value;\n\tvar user=document.getElementById('members-{$t}').value;\n\tvar interval=document.getElementById('interval-{$t}').value;\n\tLoadjs('{$page}?query-js=yes&t={$t}&container=graph-{$t}&date1='+date1+'&time1='+time1+'&date2='+date2+'&time2='+time2+'&interval='+interval+'&user='+user);\n\n}\n</script>\n"; echo $tpl->_ENGINE_parse_body($html); }
function build_query_js() { header("content-type: application/x-javascript"); squid_stats_default_values(); $page = CurrentPageName(); $tpl = new templates(); $q = new mysql_squid_builder(); if (isset($_GET["from-zmd5"])) { $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT params FROM reports_cache WHERE `zmd5`='{$_GET["from-zmd5"]}'")); $params = unserialize($ligne["params"]); $from = $params["FROM"]; $to = $params["TO"]; $interval = $params["INTERVAL"]; if ($interval == 0) { $interval = "1h"; } $USER_FIELD = $params["USER"]; $USER_DATA = $_GET["USER_DATA"]; } else { $zmd5 = $_GET["zmd5"]; $t = time(); $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT params FROM reports_cache WHERE `zmd5`='{$zmd5}'")); if (!$q->ok) { echo "alert('" . $tpl->javascript_parse_text("{$q->mysql_error}") . "');"; return; } $params = unserialize($ligne["params"]); $from = $params["FROM"]; $to = $params["TO"]; $interval = $params["INTERVAL"]; if ($interval == 0) { $interval = "1h"; } $USER_FIELD = $params["USER"]; $USER_DATA = $_GET["USER_DATA"]; } $nextFunction = "Loadjs('{$page}?build-graph-js=yes&zmd5={$zmd5}');"; $nextFunction_encoded = urlencode(base64_encode($nextFunction)); $q = new mysql_squid_builder(); $q->CheckReportTable(); $timetext1 = $tpl->time_to_date(strtotime($from), true); $timetext2 = $tpl->time_to_date(strtotime($to), true); $ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ID,builded FROM reports_cache WHERE `zmd5`='{$zmd5}'")); if (intval($ligne["ID"]) == 0) { $md5 = md5("MEMBERS_UNIQ:{$from}{$to}{$interval}{$USER_FIELD}{$USER_DATA}"); $nextFunction = "Loadjs('{$page}?build-graph-js=yes&zmd5={$md5}');"; $nextFunction_encoded = urlencode(base64_encode($nextFunction)); $array["FROM"] = $from; $array["TO"] = $to; $array["INTERVAL"] = $interval; $array["USER"] = $USER_FIELD; $array["SEARCH"] = $USER_DATA; $serialize = mysql_escape_string2(serialize($array)); $title = "{report_member}: {$timetext1} -{$timetext2} - {$USER_DATA}"; $sql = "INSERT IGNORE INTO `reports_cache` (`zmd5`,`title`,`report_type`,`zDate`,`params`) VALUES\n\t\t('{$md5}','{$title}','MEMBER_UNIQ',NOW(),'{$serialize}')"; $q->QUERY_SQL($sql); if (!$q->ok) { echo "alert('" . $tpl->javascript_parse_text($q->mysql_errror) . "')"; return; } echo "Loadjs('squid.statistics.progress.php?zmd5={$md5}&NextFunction={$nextFunction_encoded}')"; return; } if (intval($ligne["builded"] == 0)) { echo "\n\t\tfunction Start{$t}(){\n\t\tLoadjs('squid.statistics.progress.php?zmd5={$md5}&NextFunction={$nextFunction_encoded}&t={$t}');\n\t}\n\n\tLockPage();\n\tsetTimeout('Start{$t}()',800);\n\t"; return; } echo $nextFunction; }
function page() { $page = CurrentPageName(); $tpl = new templates(); squid_stats_default_values(); $t = time(); echo "<div style='float:right;margin:5px;margin-top:-47px'>" . button($tpl->_ENGINE_parse_body("{build_the_query}"), "Loadjs('{$page}?requeteur-js=yes&t={$t}')", 16) . "</div>"; $html = "\t\n\t\n\t<div style='width:1490px;margin-bottom:10px' id='table-squid-stats-requests'></div>\t\n<script>\n\tLoadAjax('table-squid-stats-requests','{$page}?query-js=yes&Maxlines={$_SESSION["SQUID_STATS_MAX_LINES"]}&date1={$_SESSION["SQUID_STATS_DATE1"]}&time1={$_SESSION["SQUID_STATS_TIME1"]}&date2={$_SESSION["SQUID_STATS_DATE2"]}&time2={$_SESSION["SQUID_STATS_TIME2"]}&interval=0&user={$_SESSION["SQUID_STATS_MEMBER"]}&search={$_SESSION["SQUID_STATS_MEMBER_SEARCH"]}');\n\t\n</script>"; echo $tpl->_ENGINE_parse_body($html); }