<?php

/* These are the things we need

read_config($from);

makeform_login();
$role = validate_login();
store_login();

makeform_basequery();
$tuneit = validate_base();
store_base();

makeform_rows();
validate_rows();
store_rows();

makeform_cols();
validate_cols();
store_cols();

makeform_grouping();
validate_groups();
store_groups();

makeform_result()
$whatnext = validate_results();
store_results();
run_query();

//////////////////////////////////////////////////////////
*/

require_once ("$include_from/sqlwrapper.inc");

function read_config($source) {
        $fh = fopen($source,"r");
        $_SESSION[config] = array();
        while ($line = fgets($fh,65536)) {
                $line = trim($line);
                if ($line == "" or ereg("^#",$line)) continue;
                $fields = explode(" ",$line);
                $fname = array_shift($fields);

                if (! is_array($_SESSION[config][$fname])) {
                        $_SESSION[config][$fname] = array();
                        }
                array_push($_SESSION[config][$fname],implode(" ",$fields));

                }
        }

function makeform_login() {
        $fields = array (
                array("name","Your name:",$_POST[name]),
                array("password","Your password:",$_POST[password],
                        "type" => "password"));
        $form = makeform($fields);
        return $form;
        }

function validate_login() {
        global $error;
        global $_warnings;
        $role = "";
        if ($_POST[name] != "demo") {
                $error = 1;
                $_warnings[name] = "Invalid account";
                $_warnings[password] = "Invalid account";
                }
        if ($_POST[password] != "xxx111") {
                $error = 1;
                $_warnings[name] = "Invalid account";
                $_warnings[password] = "Invalid account";
                }
        if ($error != 1) {
                $role = "user";
                }
        return $role;
        }

function store_login() {
        $_SESSION[user] = $_POST[name];
        }

function makeform_basequery() { // To be "Choose a standard query"
        $fields = array(array("bq","Which query?",$_POST[onto],
                        type => "submit",
                        options => "default|tuned"));
        $form = makeform($fields);
        return $form;
        }

function validate_base() {
        $_SESSION[wheres] = array();
        if ($_POST[bq] == "tuned") return 1;
        makeform_cols(); // To force column selection defaults
        // More to be added
        return 0; // tune it? Not at first!
        }

function store_base() {
        }

function makeform_rows() {
        $fields = array();
        foreach ($_SESSION[config]["whereopt:"] as $orow) {
                $testtypes = explode(" ",$orow);
                $testfield = array_shift($testtypes);
                foreach ($testtypes as $thistest) {
                        $rowtest = array("$testfield/$thistest",
                                "A <b>$thistest</b> test is on <b>$testfield</b>",
                                $_SESSION["$testfield/$thistest"]);
                        array_push($fields,$rowtest);
                        }
                }
        $form = makeform($fields);
        return $form;
        }

function makeform_cols() {
        $fields = array();
        foreach ($_SESSION[config]["displayopt:"] as $ocol) {
                $colinfo = explode(" ",$ocol);
                $testfield = array_shift($colinfo);
                $defcolstat = array_shift($colinfo);
                // Add handling to offer sort options
                if ($defcolstat != "always" and $defcolstat != "never") {
                if ($defcolstat == "on" and
                        ! is_string($_SESSION["$testfield/display"]))
                                $_SESSION["$testfield/display"] = "on";
                $coltest = array("$testfield/display",
                                "Display column <b>$testfield</b>",
                                $_SESSION["$testfield/display"],
                                type => "checkbox");
                array_push($fields,$coltest);
                }
                }
        $form = makeform($fields);
        return $form;
        }

function validate_rows() {
        // To add - check that lessthan contains a number and a host of
        // other checks
        }

function validate_cols() {
        // To add - checks
        }

function store_rows() {
        foreach ($_SESSION[config]["whereopt:"] as $orow) {
                $testtypes = explode(" ",$orow);
                $testfield = array_shift($testtypes);
                foreach ($testtypes as $thistest) {
                        $_SESSION["$testfield/$thistest"] =
                                stripslashes($_POST["$testfield/$thistest"]) ;
                }
        }
}

function store_cols() {
        foreach ($_SESSION[config]["displayopt:"] as $ocol) {
                $testtypes = explode(" ",$ocol);
                $discol = array_shift($testtypes);
                $disdef = array_shift($testtypes);
                $_SESSION["$discol/display"] =
                        stripslashes($_POST["$discol/display"]) ;
        }
}

function makeform_result() { // To be "what is your next action"
        $fields = array(array("onto","What next?",$_POST[onto],
                        type => "submit",
                        options => "new|logout|next|".
                                "previous|all|tailor|name"));

        $form = makeform($fields);
        return $form;
        }

function run_query() {

        $result = "";

// Get where clauses
        $wheres = array();
        foreach ($_SESSION[config]["whereopt:"] as $orow) {
                $testtypes = explode(" ",$orow);
                $testfield = array_shift($testtypes);
                foreach ($testtypes as $thistest) {
                        if ($_SESSION["$testfield/$thistest"]) {
                                switch ($thistest) {
case "is":
        $wcl = "$testfield = \"".
                        addslashes($_SESSION["$testfield/$thistest"]).
                        "\"";
        break;
case "contains":
        $wcl = "$testfield like \"%".
                        addslashes($_SESSION["$testfield/$thistest"]).
                        "%\"";
        break;
case "lessthan":
        $wcl = "$testfield < ".
                        addslashes($_SESSION["$testfield/$thistest"]);
        break;
case "greaterthan":
        $wcl = "$testfield > ".
                        addslashes($_SESSION["$testfield/$thistest"]);
        break;
default:
        $wcl = "1 = 1"; // We know we have a problem is we see this reported
        break;
}
        array_push($wheres,$wcl);
                }
        }
}
        $wherestring = implode(" and ",$wheres);
        if ($wherestring) $wherestring = " where $wherestring";

// Get Base query

        $basequery = $_SESSION[config]["basequery:"][0];

// Get Column list

        $whats = array();
        foreach ($_SESSION[config]["displayopt:"] as $ocol) {
                $testtypes = explode(" ",$ocol);
                $colwant = array_shift($testtypes);
                $defcol = array_shift($testtypes);
                if ($defcol == "never") continue;
                if ($defcol == "always") {
                        array_push($whats,$colwant);
                        continue;
                        }
                if ($_SESSION["$colwant/display"]) {
                        array_push($whats,$colwant);
                        }
        }

        $whatstring = implode(", ",$whats);
        if ($whatstring == "") $whatstring = "*";

// Make up complete query

        $query = "select $whatstring from $basequery $wherestring";

        sql_connect();
        $rset = sql_query($query);

        $result .= "Running <b>".htmlspecialchars($query)."</b><br><br>";
        $result .= "<table border=1>";
        while ($row = sql_fetch($rset)) {
                $rowcount++;
                if ($rowcount < 2) { // header row
                $result .= "<tr>";
                foreach (array_keys($row) as $col) {
                        $result .= cell($col,"head");
                        }
                $result .= "</tr>";
                }
                $result .= "<tr>";
                foreach (array_keys($row) as $col) {
                        $result .= cell($row[$col]);
                        }
                $result .= "</tr>";
                }
        $result .= "</table>";
        return $result;
}

function validate_results() {
        // What to do next?
        if ($_POST[onto] == "logout") return "logout";
        return "new";
        }

function store_results() {
        }

?>