<?
class DBMain
{

    public $conn;
    public $table;

    function __construct($database = 'pro_art_bronze_jobcards', $prefix = 'elegaysv')
    {
        $myfile = fopen($_SERVER['DOCUMENT_ROOT'] . "/WebBuilder/name.txt", "r") or die("Unable to open file!");
        $data = fread($myfile, filesize($_SERVER['DOCUMENT_ROOT'] . "/WebBuilder/name.txt"));
        $data_name = $data;
        fclose($myfile);

        $myfile = fopen("/home/elegaysv/quickstart_inv_files/$data_name.txt", "r") or die("Unable to open file!");
        $data = fread($myfile, filesize("/home/elegaysv/quickstart_inv_files/$data_name.txt"));

        $data_sniplits = explode(';', $data);
        $user = explode(':', $data_sniplits[1]);
        $pass = explode(':', $data_sniplits[2]);
        $db = explode(':', $data_sniplits[0]);
        fclose($myfile);

        $ip = 'ewg.dedicated.co.za';
        $user = $user[1];
        $pass = $pass[1];
        $db = $db[1];
        $this->conn = mysqli_connect($ip, $prefix . "_" . $user, $pass, $prefix . '_' . $db);
    }

    function insert($Query = '')
    {

        $this->conn->query($Query);

        return $this->conn->insert_id;
    }

    public function query(string $query): mysqli_result
    {
        $exec = $this->conn->query($query);

        if (!$exec) {
            throw new Exception($this->conn->error);
        }

        return $exec;
    }

    function CheckAccount($email)
    {
    }

    function Update($tableName, $columns = [], $values = [], $where = '1', $devmode = False)
    {

        $this->table = $tableName;

        if (count($columns) == count($values)) {


            $queryDatabase[] = "UPDATE $this->table SET ";
            $i = 0;
            foreach ($columns as $colls) {

                $queryDatabaseCols[] = "`$colls` = '$values[$i]'";

                $i++;
            }
            $queryDatabase[] = implode(',', $queryDatabaseCols);

            $queryDatabase[] = " WHERE $where";

            if ($devmode == True) {

                echo implode('', $queryDatabase);
            } else {

                // echo implode('',$queryDatabase);

                return $this->conn->query(implode('', $queryDatabase));
            }
        } else {
            return "values and columns not same length";
        }
    }

    function exec_query($tableName, $columns = [], $joinType = '', $joinTable = '', $table1Column = '', $table2Column = '', $where = '1', $orderBy = "", $devMode = False)
    {

        $this->table = $tableName;

        if ($columns[0] == '*') {

            $results = "";
            $join = strlen($joinType) > 1 ? " a $joinType JOIN $joinTable b ON a.$table1Column = b.$table2Column " : '';


            $queryDatabase = "SELECT * FROM `$this->table` $join WHERE $where $orderBy";


            $results = $this->conn->query($queryDatabase);


            if (!$results)
                var_dump($results);

            if ($devMode == True) {

                echo $queryDatabase;
            } else {
                return $results;
            }
        } else {
            $queryColumns = [];

            foreach ($columns as $col) {

                $queryColumns[] = " $col ";
            }

            $queryColumns = implode(' , ', $queryColumns);

            $queryDatabase = "SELECT $queryColumns FROM `$this->table` WHERE $where $orderBy";


            $results = $this->conn->query($queryDatabase);


            if ($results->num_rows > 0) {

                if ($devMode == True) {

                    echo $queryDatabase;
                } else {
                    echo $queryDatabase;

                    // return $results;
                }
            } else {

                return "$queryDatabase";
            }
        }
    }

    function add_log($log_text, $table_name, $affected_record_id)
    {
        if (strlen($log_text) < 1) {
            echo "PLEASE SUPPLY A LOG REASON";
        } else {
            $date = date('Y-m-d H:i', strtotime('+ 2 Hours'));
            self::insert("INSERT INTO `logs` (`proart_accounting_users_id`,`log`,`date_time`,`table_name`,`affected_record`) VALUES ({$_SESSION['user_id']},'" . strtoupper($log_text) . "','$date','$table_name',$affected_record_id)");
        }
    }
}

class WebApp
{
    public $db;
    function __construct()
    {
        $db = new DBMain();
        $this->db = $db;

        session_start();
?>
        <link rel="stylesheet" href="../WebApp/Styles/styles.css">
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

    <?


    }

    function landing_page($text)
    {
        echo "<div class='landing_page'><h1 style='font-size:10vw;color:#04AA6D; margin-top:auto;margin-bottom:auto;' > $text </h1></div>
        
        
        ";
    }

    function big_button($page_pointer = '', $text = '', $button_class = 'button')
    { ?>
        <button class='<? echo $button_class; ?>' onclick='window.location.href="<? echo $page_pointer; ?>"'><? echo $text; ?></button>
    <? }

    function pageHeading($text = '', $container_div_class = 'form_container')
    {
        echo "<div class='$container_div_class' style='margin-bottom:1vw;width:90%;border: 1px solid #04AA6D'><h1>$text</h1></div>";
    }

    function form_input_empty_single($table_name, $href_action_after_completion = '', $custom_select_query = [], $input_class_name = 'input', $select_class_name = 'select', $label_class_name = 'label', $button_class = 'button', $container_div_class = 'form_container', $line_breaks = true)
    {
        echo "<div class='$container_div_class'>";
        $results = $this->db->query("SELECT COLUMN_NAME,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE  FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name'and table_schema = '{$_SESSION['db_name']}'");
        while ($row = $results->fetch_assoc()) {
            $column_name = $row['COLUMN_NAME'];
            $max_legth = $row['CHARACTER_MAXIMUM_LENGTH'];
            $is_nullabe = $row['IS_NULLABLE'];

            if ($column_name == 'record_id') {
                continue;
            } else {
                $js_cul_names_arr[] = $column_name;
                $js_nullable[] = $is_nullabe;
                if (strpos($column_name, '_id')) {
                    $link_table_name = substr($column_name, 0, strpos($column_name, '_id'));
                    if ($line_breaks) {
                        echo "<br>";
                    }
                    echo "<label class='$label_class_name'>" . strtoupper($link_table_name) . "</label>";
                    if ($line_breaks) {
                        echo "<br>";
                    }

                    echo "<select aria-labelledby='my-select-label' class='$select_class_name' name='$column_name'  id='id_$column_name'>";
                    if (strlen($custom_select_query[$column_name]) < 5) {
                        $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', "1", "ORDER BY " . $link_table_name . "_name ASC");
                    } else {
                        $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', $custom_select_query[$column_name], "ORDER BY " . $link_table_name . "_name ASC");
                    }
                    echo "<option value=''></option>";
                    while ($link_table_data = $link_table_result->fetch_assoc()) {
                        echo "<option value='{$link_table_data['record_id']}'>{$link_table_data[$link_table_name . '_name']}</option>";
                    }
                    echo "</select>";
                    if ($line_breaks) {
                        echo "<br>";
                    }
                } else {
                    if ($line_breaks) {
                        echo "<br>";
                    }
                    echo "<label class='$label_class_name'>" . str_replace("_", " ", strtoupper($column_name)) . "</label>";
                    if ($line_breaks) {
                        echo "<br>";
                    }

                    if (strpos($column_name, 'password') > 0) {
                        $type = 'password';
                        $data[$column_name] = '';
                    } else 
                    if (strpos($column_name, 'email') > 0) {
                        $type = 'email';
                    } elseif (strpos($column_name, 'date') > 0) {
                        $type = 'date';
                    } else {
                        $type = 'text';
                    }
                    echo "<input type='$type' maxlength='{$max_legth}' class='$input_class_name' name='$column_name' id='id_$column_name' />";
                    if ($line_breaks) {
                        echo "<br>";
                    }
                }
            }
        }
        if ($line_breaks) {
            echo "<br>";
        }
        echo "<button class='$button_class' onclick='" . $table_name . "_add()'>SUBMIT</button>";
        echo "</div>";


    ?>
        <script>
            function <? echo $table_name; ?>_add() {
                var error = 0;
                <?
                $js_index = 0;
                foreach ($js_cul_names_arr as $colls) {
                    echo "var " . $colls . "_val = document.getElementById('id_$colls').value;
                    ";
                    $get_string[] = "$colls='+$colls" . "_val+'";

                    if ($js_nullable[$js_index] == 'NO') {
                        echo "if(document.getElementById('id_$colls').value.length < 1){ error = 1; alert('Please enter a value at " . strtoupper(str_replace('_', " ", $colls)) . "');}";
                    }


                    $js_index++;
                }


                $get_string = implode('&', $get_string);
                ?>
                if (error == 0) {
                    const xhttp = new XMLHttpRequest();
                    // Define a callback function
                    xhttp.onload = function() {
                            console.log(this.responseText);
                        // Here you can use the Data
                        if (this.responseText == 1) {
                            alert("ADDED");
                            window.location.href = "<? echo $href_action_after_completion; ?>";

                        } else {
                            alert(this.responseText);


                        }
                    }
                    xhttp.open("GET", '/WebBuilder/ajax_insert.php?table_name=<? echo $table_name; ?>&<? echo $get_string; ?>');
                    xhttp.send();
                }
            }
        </script>
        <?
    }

    function form_input_edit_single($table_name, $data_record_id, $href_action_after_completion = 'none', $custom_select_query = [], $input_class_name = 'input', $select_class_name = 'select', $label_class_name = 'label', $button_class = 'button', $container_div_class = 'form_container',  $line_breaks = true)
    {

        if (strlen($data_record_id) < 1) {
            echo "data received : " . $data_record_id;
        } else {
            echo "<div class='$container_div_class'>";
            $data_result = $this->db->exec_query($table_name, ['*'], '', '', '', '', "record_id = $data_record_id");
            $data = $data_result->fetch_assoc();
            if ($data == NULL) {
                echo "<br> NO DATA RECEVIED FROM THE DATABASE WITH RECORD ID OF $data_record_id <br>";
            }
            $results = $this->db->query("SELECT COLUMN_NAME,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE  FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name'and table_schema = '{$_SESSION['db_name']}'");
            while ($row = $results->fetch_assoc()) {
                $column_name = $row['COLUMN_NAME'];
                $max_legth = $row['CHARACTER_MAXIMUM_LENGTH'];
                $is_nullabe = $row['IS_NULLABLE'];

                if ($column_name == 'record_id') {
                    continue;
                } else {
                    $js_cul_names_arr[] = $column_name;
                    $js_nullable[] = $is_nullabe;
                    if (strpos($column_name, '_id')) {
                        $link_table_name = substr($column_name, 0, strpos($column_name, '_id'));
                        if ($line_breaks) {
                            echo "<br>";
                        }
                        echo "<label class='$label_class_name'>" . strtoupper($link_table_name) . "</label>";
                        if ($line_breaks) {
                            echo "<br>";
                        }
                        echo "<select aria-labelledby='my-select-label' class='$select_class_name' name='$column_name'  id='id_$column_name'>
                        ";
                        echo "<option value=''></option>";
                        if (strlen($custom_select_query[$column_name]) < 5) {
                            $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', "1", "ORDER BY " . $link_table_name . "_name ASC");
                        } else {
                            $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', $custom_select_query[$column_name], "ORDER BY " . $link_table_name . "_name ASC");
                        }
                        while ($link_table_data = $link_table_result->fetch_assoc()) {
                            echo "<option value='{$link_table_data['record_id']}'>{$link_table_data[$link_table_name . '_name']}</option>";
                        }
                        echo "</select>";
                        if ($line_breaks) {
                            echo "<br>";
                        }
                        echo "<script>document.getElementById('id_$column_name').value = {$data[$column_name]};</script>";
                    } else {
                        if ($line_breaks) {
                            echo "<br>";
                        }
                        echo "<label class='$label_class_name'>" . str_replace("_", " ", strtoupper($column_name)) . "</label>";
                        if ($line_breaks) {
                            echo "<br>";
                        }

                        if (strpos($column_name, 'password') > 0) {
                            $type = 'password';
                            $data[$column_name] = '';
                        } else 
                    if (strpos($column_name, 'email') > 0) {
                            $type = 'email';
                        } elseif (strpos($column_name, 'date') > 0) {
                            $type = 'date';
                        } else {
                            $type = 'text';
                        }
                        echo "<input type='$type' maxlength='{$max_legth}' class='$input_class_name' value='{$data[$column_name]}' name='$column_name' id='id_$column_name' />";
                        if ($line_breaks) {
                            echo "<br>";
                        }
                    }
                }
            }
            if ($line_breaks) {
                echo "<br>";
            }
            echo "<button class='$button_class' onclick='" . $table_name . "_update_" . $data_record_id . "()'>UPDATE</button>";
            echo "</div>";


        ?>
            <script>
                function <? echo $table_name; ?>_update_<? echo $data_record_id; ?>() {
                    var error = 0;
                    <?
                    $js_index = 0;
                    foreach ($js_cul_names_arr as $colls) {
                        echo "var " . $colls . "_val = document.getElementById('id_$colls').value;
                    ";
                        $get_string[] = "$colls='+$colls" . "_val+'";

                        if ($js_nullable[$js_index] == 'NO') {
                            echo "if(document.getElementById('id_$colls').value.length < 1){ error = 1; alert('Please enter a value at " . strtoupper(str_replace('_', " ", $colls)) . "');}";
                        }


                        $js_index++;
                    }


                    $get_string = implode('&', $get_string);
                    ?>
                    if (error == 0) {
                        const xhttp = new XMLHttpRequest();
                        // Define a callback function
                        xhttp.onload = function() {
                            // Here you can use the Data
                            if (this.responseText != 1) {
                                alert("UPDATED");
                                if ("<? echo $href_action_after_completion; ?>" != 'none') {
                                    window.location.href = "<? echo $href_action_after_completion; ?>";
                                }

                            } else {
                                alert(this.responseText);


                            }
                        }
                        xhttp.open("GET", '/WebBuilder/ajax_update.php?table_name=<? echo $table_name; ?>&record_id=<? echo $data_record_id; ?>&<? echo $get_string; ?>');
                        xhttp.send();
                    }
                }
            </script>
        <?
        }
    }

    function find_string_in_string($heystack, $needle)
    {

        preg_match("/\b" . $needle . "\b/", str_replace('_', ' ', $heystack), $match, PREG_OFFSET_CAPTURE);
        if (strlen($match[0][0]) > 0) {
            return true;
        } else {
            return false;
        }
    }

    function search_basic($table_name, $page_pointer = '', $custom_select_query = [], $container_div_class = 'form_container', $input_class_name = 'input', $select_class_name = 'select', $label_class_name = 'label', $button_class = 'button')
    {

        echo "<div class='$container_div_class'>";

        $results = $this->db->query("SELECT COLUMN_NAME,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE  FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name' and table_schema = '{$_SESSION['db_name']}'");
        while ($row = $results->fetch_assoc()) {
            $column_name = $row['COLUMN_NAME'];
            $max_legth = $row['CHARACTER_MAXIMUM_LENGTH'];
            $is_nullabe = $row['IS_NULLABLE'];

            if ($column_name == 'record_id') {
                continue;
            } else {
                $js_cul_names_arr[] = $column_name;
                $js_nullable[] = $is_nullabe;
                if (strpos($column_name, '_id')) {
                    $link_table_name = substr($column_name, 0, strpos($column_name, '_id'));


                    echo "<select aria-labelledby='my-select-label' class='$select_class_name' name='$column_name'  id='id_$column_name'>
                        ";
                    echo "<option value=''>" . str_replace("_", " ", strtoupper($column_name)) . "</option>";

                    if (strlen($custom_select_query[$column_name]) < 5) {
                        $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', "1", "ORDER BY " . $link_table_name . "_name ASC");
                    } else {
                        $link_table_result = $this->db->exec_query($link_table_name, ['*'], '', '', '', '', $custom_select_query[$column_name], "ORDER BY " . $link_table_name . "_name ASC");
                    }

                    while ($link_table_data = $link_table_result->fetch_assoc()) {
                        echo "<option value='{$link_table_data['record_id']}'>{$link_table_data[$link_table_name . '_name']}</option>";
                    }
                    echo "</select>";
                } else {

                    if (self::find_string_in_string($column_name, 'password') > 0) {
                        $type = 'password';
                        $data[$column_name] = '';
                    } else 
                    if (self::find_string_in_string($column_name, 'date') > 0) {
                        $type = 'date';
                    } else {
                        $type = 'text';
                    }


                    echo "<label>" . str_replace("_", " ", strtoupper($column_name)) . "</label><input type='$type' maxlength='{$max_legth}' class='$input_class_name' placeholder='" . str_replace("_", " ", strtoupper($column_name)) . "' name='$column_name' id='id_$column_name' />";
                }
            }
        }
        echo "<hr><br><label class='$label_class_name'>ORDER BY : </label>";
        echo "<select class='$select_class_name' id='order_by'><option value='record_id'>RECENT</option>";
        foreach ($js_cul_names_arr as $colls) {
            echo "<option value='$colls'>" . str_replace("_", " ", strtoupper($colls)) . "</option>";
        }
        echo "</select>";
        echo "<select class='$select_class_name' id='order_type'><option value='ASC'>ASCENDING</option><option value='DESC'>DESCENDING</option></select>";
        echo "<button class='$button_class' id='" . $table_name . "_button' onclick='" . $table_name . "_search()'>SEARCH</button>";
        echo "</div><br><div class='data_container_for_search_function' id='id_data_div'></div>";


        ?>
        <script>
            function loading_button() {

                document.getElementById('<? echo $table_name; ?>_button').innerHTML = 'LOADING.';
            }

            function clear_data() {
                document.getElementById('id_data_div').innerHTML = '';
            }

            function done() {
                document.getElementById('<? echo $table_name; ?>_button').innerHTML = 'SEARCH';
            }

            function <? echo $table_name; ?>_search() {
                clear_data();
                loading_button();
                var error = 0;
                <?
                foreach ($js_cul_names_arr as $colls) {
                    echo "var " . $colls . "_val = document.getElementById('id_$colls').value;
                    ";
                    $get_string[] = "$colls='+$colls" . "_val+'";
                }


                $get_string = implode('&', $get_string);
                ?>

                order_by = document.getElementById('order_by').value;
                order_type = document.getElementById('order_type').value;
                if (error == 0) {
                    const xhttp = new XMLHttpRequest();
                    // Define a callback function
                    xhttp.onload = function() {
                        // Here you can use the Data
                        if (this.responseText != 1) {
                            // alert(this.responseText);
                            document.getElementById('id_data_div').innerHTML = this.responseText;
                            document.getElementById('<? echo $table_name; ?>_button').innerHTML = 'SEARCH';
                            done();
                        } else {
                            alert(this.responseText);


                        }
                    }
                    xhttp.open("GET", '/WebBuilder/ajax_search_basic.php?table_name=<? echo $table_name; ?>&pointer=<? echo $page_pointer; ?>&<? echo $get_string; ?>&order_by=' + order_by + '&order_type=' + order_type);
                    xhttp.send();
                }
            }
        </script>
<?
    }
}


$WebApp = new WebApp();