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&nbsp;" . 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&nbsp;" . 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&nbsp;" . 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&nbsp;" . 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&nbsp;" . 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&nbsp;" . 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);
}