<?php 
    function scilab_fixer_menu() {
        $items = array();
        $items["fix/caption"] = array(
            "title"  => "Fix TBC captions",
            "page callback" => "scilab_fixer_caption_all",
            "access arguments" => array("fix scilab"),
            "type" => MENU_NORMAL_ITEM
        );
        $items["fix/aicte"] = array(
            "title"  => "Add AICTE books",
            "page callback" => "scilab_fixer_aicte_all",
            "access arguments" => array("fix scilab"),
            "access arguments" => array("fix scilab"),
            "weight" => 30,
            "type" => MENU_NORMAL_ITEM
        );
        $items["fix/aicte/new"] = array(
            "title"  => "Add AICTE books",
            "page callback" => "scilab_fixer_aicte_all",
            "access arguments" => array("fix scilab"),
            "weight" => 1,
            "type" => MENU_DEFAULT_LOCAL_TASK
        );
        $items["fix/aicte/edit"] = array(
            "title"  => "Edit AICTE books",
            "page callback" => "scilab_fixer_aicte_edit_all",
            "access arguments" => array("fix scilab"),
            "weight" => 2,
            "type" => MENU_LOCAL_TASK
        );
        $items["fix/ajax"] = array(
            "page callback" => "scilab_fixer_ajax",
            "access callback" => TRUE,
            "type" => MENU_CALLBACK
        );
        return $items;
    }

    function scilab_fixer_perm() {
        return array(
            "fix scilab",
        );
    }

    function scilab_fixer_caption_form($form_state) {
        $form = array();
        $form["wrapper"] = array(
            "#type" => "fieldset",
            "#title"=> "Caption change form",
            "#prefix" => "<div id='fix-caption-form'>",
            "#suffix" => "</div>",
        );
        $form["wrapper"]["category"] = array(
            "#type" => "select",
            "#title" => t("Please select the category"),
            '#options' => array(
                0 => 'Please select a category',
                1 => 'Fluid Mechanics',
                2 => 'Control Theory & Control Systems',
                3 => 'Chemical Engineering',
                4 => 'Thermodynamics',
                5 => 'Mechanical Engineering',
                6 => 'Signal Processing',
                7 => 'Digital Communications',
                8 => 'Electrical Technology',
                9 => 'Mathematics & Pure Science',
               10 => 'Analog Electronics',
               11 => 'Digital Electronics',
               12 => 'Computer Programming',
               13 => 'Others'
            ),
        );
        $form["wrapper"]["book"] = array(
            "#type" => "select",
            "#title" => t("Please select the book."),
            "#options" => array(
                0 => "Please select a book"
            )
        );
        $form["wrapper"]["chapter"] = array(
            "#type" => "select",
            "#title" => t("Please select the chapter"),
            "#options" => array(
                0 => "Please select a chapter"
            )
        );
        $form["wrapper"]["example"] = array(
            "#type" => "select",
            "#title" => t("Please select the example"),
            "#options" => array(
                0 => "Please select a example"
            )
        );
        $form["wrapper"]["caption"] = array(
            "#type" => "textfield",
            "#title" => t("Enter new caption"),
        );
        $form["wrapper"]["submit"] = array(
            "#type" => "submit",
            "#value" => "Update"
        );
        $form["wrapper"]["code"] = array(
            "#type" => "fieldset",
            "#description" => t("No code to display"),
            "#prefix" => "<div class='well'><pre id='fix-caption-code'>",
            "#suffix" => "</pre></div>",
        );
        return $form;
    }

    function scilab_fixer_caption_all() {
        $page_content = "";
        $page_content .= "<div id='fix-caption-page'>";
            $page_content .= "<center><span id='updating'>Updating...</span></center>";
            $page_content .= "<span id='done'>Done.</span>";
            $page_content .= drupal_get_form("scilab_fixer_caption_form");
        $page_content .= "</div>";
        $page_content .= "<small>* Selecting text from above code-area with mouse will add it to the caption textbox.</small>";
        return $page_content;
    }

    function scilab_fixer_ajax($item, $key) {
        $data = "";
        if($item == "category" && $key) {
            $query = "
                SELECT pre.id AS id, pre.book, pre.author FROM textbook_companion_preference pre
                LEFT JOIN textbook_companion_proposal pro ON pro.id = pre.proposal_id
                WHERE pro.proposal_status = 3 AND pre.approval_status = 1 AND pre.category = %d
                ORDER BY pre.book ASC
            ";
            $result = db_query($query, $key);
            
            $data .= "<option value='0'>Please select the book.</option>";
            while($row = db_fetch_object($result)) {
                $data .= "<option value='{$row->id}'>{$row->book} ({$row->author})</option>";
            }
        } else if($item == "book" && $key) {
            $query = "SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number";
            $result = db_query($query, $key);
            
            $data .= "<option value='0'>Please select the chapter.</option>";
            while($row = db_fetch_object($result)) {
                $data .= "<option value='{$row->id}'>{$row->number} {$row->name}</option>";
            }
        } else if($item == "chapter" && $key) {
            $query = "SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d ORDER BY number";
            $result = db_query($query, $key);
            
            $data .= "<option value='0'>Please select the example.</option>";
            while($row = db_fetch_object($result)) {
                $data .= "<option value='{$row->id}'>{$row->number} {$row->caption}</option>";
            }
        } else if($item == "example" && $key) {
            $query = "
                SELECT * FROM textbook_companion_example_files fil
                LEFT JOIN textbook_companion_example exa ON exa.id = fil.example_id
                WHERE example_id = %d
            ";
            $result = db_query($query, $key);
            $row = db_fetch_object($result);
            /* fetching example file data */
            $uploads_dir = $_SERVER['DOCUMENT_ROOT'] . base_path() . "uploads/";
            $example_path = $uploads_dir . $row->filepath;
            $example = file_get_contents($example_path);
            $data .= "<div id='caption'>{$row->caption}</div>";
            $data .= "<div id='code'>{$example}</div>";
        } else if($item == "update") {
            $example_id = $_POST["example_id"];
            $caption = $_POST["caption"];
            $query = "
                UPDATE textbook_companion_example
                SET caption = '%s'
                WHERE id = %d
            ";
            $result = db_query($query, $caption, $example_id);
            $data .= "Updated";
        } else {
            $data = "Nothing to display.";
        }
        echo $data;
        exit();
    }

    function scilab_fixer_aicte_form($form_state, $aicte_id) {
        $query = "
            SELECT * FROM textbook_companion_aicte
            WHERE id = {$aicte_id}
        ";
        $result = db_query($query);
        $row = db_fetch_object($result);
        
        $form = array();
        $form["book"] = array(
            "#type" => "textfield",
            "#title" => "Book Name",
            "#default_value" => $row->book,
            "#required" => TRUE
        );
        $form["author"] = array(
            "#type" => "textfield",
            "#title" => "Author",
            "#default_value" => $row->author,
            "#required" => TRUE
        );
        $form["category"] = array(
            "#type" => "select",
            "#title" => "Book Category",
            '#options' => array(
                0 => 'Please select a category',
                1 => 'Fluid Mechanics',
                2 => 'Control Theory & Control Systems',
                3 => 'Chemical Engineering',
                4 => 'Thermodynamics',
                5 => 'Mechanical Engineering',
                6 => 'Signal Processing',
                7 => 'Digital Communications',
                8 => 'Electrical Technology',
                9 => 'Mathematics & Pure Science',
               10 => 'Analog Electronics',
               11 => 'Digital Electronics',
               12 => 'Computer Programming',
               13 => 'Others'
            ),
            "#default_value" => $row->category,
            "#required" => TRUE
        );
        $form["isbn"] = array(
            "#type" => "textfield",
            "#title" => "ISBN",
            "#default_value" => $row->isbn,
            "#required" => FALSE
        );
        $form["publisher"] = array(
            "#type" => "textfield",
            "#title" => "Publisher",
            "#default_value" => $row->publisher,
            "#required" => TRUE
        );
        $form["edition"] = array(
            "#type" => "textfield",
            "#title" => "Edition",
            "#default_value" => $row->edition,
            "#required" => TRUE
        );
        $form["year"] = array(
            "#type" => "textfield",
            "#title" => "Year of publication",
            "#default_value" => $row->year,
            "#required" => TRUE
        );
        $form["aicte_id"] = array(
            "#type" => "hidden",
            "#value" => $row->id
        );
        $form["submit"] = array(
            "#type" => "submit",
            "#value" => "Submit"
        );
        return $form;
    }

    function scilab_fixer_aicte_form_validate($form, &$form_state) {
        if(!$form_state["values"]["category"]) {
            form_set_error("category", "Please select a category.");
        }
        if(!is_numeric($form_state["values"]["edition"])) {
            form_set_error("edition", "Only digits are allowed.");
        }
        if(!is_numeric($form_state["values"]["year"]) && strlen($form["values"]["year"]) != 4) {
            form_set_error("year", "Please enter a valid year. eg: 2011.");
        }
    }

    function scilab_fixer_aicte_form_submit($form, &$form_state) {
        $v = $form_state["values"];
        if($v["aicte_id"]) {
            $query = "
                UPDATE textbook_companion_aicte
                SET book = '%s', author = '%s', category = %d,
                isbn = '%s', publisher = '%s', edition = %d,
                year = %d 
                WHERE id = %d
            ";
            $result = db_query($query, 
                $v["book"], $v["author"], $v["category"], $v["isbn"],
                $v["publisher"], $v["edition"], $v["year"], $v["aicte_id"]
            );
            drupal_set_message("Book updated successfully", "status");
        } else {
            $query = "
                INSERT INTO textbook_companion_aicte
                (book, author, category, isbn, publisher, edition, year)
                VALUES
                ('%s', '%s', %d, '%s', '%s', %d, %d)
                ";
            $result = db_query($query, 
                $v["book"], $v["author"], $v["category"], $v["isbn"],
                $v["publisher"], $v["edition"], $v["year"]
            );
            drupal_set_message("Book added successfully", "status");
        }
    }

    function scilab_fixer_aicte_all() {
        $page_content = "";
        $page_content .= drupal_get_form("scilab_fixer_aicte_form");
        return $page_content;
    }

    function scilab_fixer_aicte_edit_all($aicte_id=0) {
        $page_content = "";
        if($aicte_id) {
            $page_content .= drupal_get_form("scilab_fixer_aicte_form", $aicte_id);
        } else {
            $query = "
                SELECT * FROM textbook_companion_aicte
                ORDER BY time DESC
            ";
            $result = db_query($query);
            $headers = array(
                "Book", "Author",
                "Edition", "Action",
            );
            $rows = array();
            while($row = db_fetch_object($result)) {
                $item = array(
                    "{$row->book}",
                    "{$row->author}",
                    "{$row->edition}",
                    l(t("Edit"), "fix/aicte/edit/{$row->id}")
                );
                array_push($rows, $item);
            }
            $page_content .= theme("table", $headers, $rows);
        }
        return $page_content;
    }

    function scilab_fixer_init() {
        drupal_add_css(drupal_get_path("module", "scilab_fixer") . "/css/scilab_fixer.css");
        drupal_add_js(drupal_get_path("module", "scilab_fixer") . "/js/scilab_fixer.js");
        drupal_add_js(drupal_get_path("module", "scilab_fixer") . "/js/selection.js");
    }
?>