cleaned directory

4 files changed, 1 insertions, 598 deletions

diff --git a/.gitignore b/.gitignore
index e78b9aa..f45d885 100755
--- a/.gitignore
+++ b/.gitignore
@@ -42,3 +42,4 @@ xmlrpc.php
 *.swo
 *.swp
 *~
+*.*~
diff --git a/textbook_ companion_fixer.module~ b/textbook_ companion_fixer.module~
deleted file mode 100755
index 9ec5a9b..0000000
--- a/textbook_ companion_fixer.module~
+++ /dev/null
@@ -1,598 +0,0 @@
-<?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"),
-            "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/aicte/in"] = array(
-            "title"  => "Mark Indian edition books",
-            "page callback" => "scilab_fixer_aicte_in_all",
-            "access arguments" => array("fix scilab"),
-            "type" => MENU_CALLBACK
-        );
-        $items["fix/code"] = array(
-            "title"  => "Edit TBC code",
-            "page callback" => "scilab_fixer_code_all",            
-            "access arguments" => array("fix scilab"),
-            "type" => MENU_CALLBACK
-        );
-        $items["fix/ajax"] = array(
-            "page callback" => "scilab_fixer_ajax",
-            "access callback" => TRUE,
-            "type" => MENU_CALLBACK
-        );
-        $items["fix/aicte/book/ajax"] = array(
-            "page callback" => "scilab_fixer_aicte_ajax",
-            "access callback" => TRUE,
-            "type" => MENU_CALLBACK
-        );        
-        return $items;
-    }
-
-    function scilab_fixer_perm() {
-        return array(
-            "fix scilab" =>array(
-            "title" =>t("fix scilab code"),
-            'restrict access' => TRUE,
-            )
-        );
-    }
-
-    function scilab_fixer_caption_form($form, $form_state) {
-        $form = array();
-        $form["wrapper"] = array(
-            "#type" => "fieldset",
-            "#title"=> "Caption change form",
-            "#prefix" => "<div id='fix-tbc-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_wrapper"] = array(
-            "#type" => "fieldset",
-            "#description" => t("No code to display"),
-            "#prefix" => "<div class='well'><pre id='edit-code' class='fix-caption-code'>",
-            "#suffix" => "</pre></div>",
-        );
-        return $form;
-    }
-
-    function scilab_fixer_caption_all() {
-        $page_content = "";
-        $page_content .= "<div id='fix-tbc-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");
-            $scilab_fixer_caption_form = drupal_get_form("scilab_fixer_caption_form");
-            $page_content .= drupal_render($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);*/
-            $query = db_select('textbook_companion_preference', 'pre');
-            $query->fields('pre', array('id', 'book', 'author'));
-            $query->leftJoin('textbook_companion_proposal', 'pro', 'pro.id = pre.proposal_id');
-            $query->condition('pro.proposal_status', 3);
-            $query->condition('pre.approval_status', 1);
-            $query->condition('pre.category', $key);
-            $query->orderBy('pre.book', 'ASC');
-            $result = $query->execute();
-            
-            $data .= "<option value='0'>Please select the book.</option>";
-            while($row =$result->fetchObject()) {
-                $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);*/
-            $query = db_select('textbook_companion_chapter');
-            $query->fields('textbook_companion_chapter');
-            $query->condition('preference_id', $key);
-            $query->orderBy('number', 'ASC');
-            $result = $query->execute();
-            
-            $data .= "<option value='0'>Please select the chapter.</option>";
-            while($row = $result->fetchObject()) {
-                $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);*/
-            $query = db_select('textbook_companion_example');
-            $query->fields('textbook_companion_example');
-            $query->condition('chapter_id', $key);
-            $query->orderBy('number', 'ASC');
-            $result = $query->execute();
-            
-            $data .= "<option value='0'>Please select the example.</option>";
-            while($row = $result->fetchObject()) {
-                $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);*/
-            $query = db_select('textbook_companion_example_files', 'fil');
-            $query->fields('fil');
-            $query->leftJoin('textbook_companion_example', 'exa', 'exa.id = fil.example_id');
-            $query->condition('example_id', $key);
-            $result = $query->execute();
-            $row = $result->fetchObject();
-            /* 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);*/
-            $query = db_update('textbook_companion_example');
-            $query->fields(array(
-              'caption' => $caption,
-            ));
-            $query->condition('id', $example_id);
-            $result = $query->execute();
-            $data .= "Updated";
-        } else if($item == "code" && $key) {
-            $code = $_POST["code"];
-            /*$query = "
-                SELECT * FROM textbook_companion_example_files
-                WHERE example_id = %d AND filetype = 'S'
-            ";
-            $result = db_query($query, $key);*/
-            $query = db_select('textbook_companion_example_files');
-            $query->fields('textbook_companion_example_files');
-            $query->condition('example_id', $key);
-            $query->condition('filetype', 'S');
-            $result = $query->execute();
-            $row = $result->fetchObject();
-            $uploads_dir = $_SERVER['DOCUMENT_ROOT'] . base_path() . "uploads/";
-            $example_path = $uploads_dir . $row->filepath;
-            file_put_contents($example_path, $code);
-            $data .= "updated";
-        } else if($item == "ind-ed" && $key) {
-            $query = "
-                UPDATE textbook_companion_aicte
-                SET ind = !ind
-                WHERE id = :id
-            ";
-            $args = array(
-                ":id" => $key
-            );
-            db_query($query,$args);
-           
-            $data .= "updated";
-        }else {
-            $data = "Nothing to display.";
-        }
-        echo $data;
-        exit();
-    }
-    function scilab_fixer_aicte_ajax($item="", $key="") {
-        $data = "";
-        if($item == "selected") {
-            $query = "
-                UPDATE textbook_companion_aicte
-                SET selected = !selected
-                WHERE id =  :id
-            ";
-            $args = array(
-                ":id" => $key
-            );
-            db_query($query,$args);
-            $data = "updated";
-        }
-        echo $data;
-        exit();
-    }
-
-
-    function scilab_fixer_aicte_form($form, $form_state, $aicte_id='') {
-        /*$query = "
-            SELECT * FROM textbook_companion_aicte
-            WHERE id = {$aicte_id}
-        ";
-        $result = db_query($query);*/
-         $query = db_select('textbook_companion_aicte');
-         $query->fields('textbook_companion_aicte');
-         $query->condition('id', $aicte_id);
-         $result = $query->execute();
-         $row = $result->fetchObject();
-        
-        $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"]
-            );*/
-            
-            $query = db_update('textbook_companion_aicte');
-            $query->fields(array(
-              'book' => $v["book"],
-              'author' => $v["author"],
-              'category' => $v["category"],
-              'isbn' => $v["isbn"],
-              'publisher' => $v["publisher"],
-              'edition' => $v["edition"],
-              'year' => $v["year"],
-            ));
-            $query->condition('id', $v["aicte_id"]);
-            $num_updated = $query->execute();
-            
-            
-            drupal_set_message("Book updated successfully", "status");
-        } else {
-            $query = "
-                INSERT INTO textbook_companion_aicte
-                (book, author, category, isbn, publisher, edition, year)
-                VALUES
-                (:book, :author, :category, :isbn, :publisher, :edition, :year)
-                ";
-            $args = array( 
-                ':book' => $v["book"],
-                ':author' => $v["author"],
-                ':category' => $v["category"], 
-                ':isbn'=> $v["isbn"],
-                ':publisher' => $v["publisher"],
-                ':edition' => $v["edition"],
-                ':year' => $v["year"],
-                
-            );
-            $result = db_query($query,$args);
-            drupal_set_message("Book added successfully", "status");
-        }
-    }
-
-    function scilab_fixer_aicte_all() {
-        $page_content = "";
-        $scilab_fixer_aicte_form = drupal_get_form("scilab_fixer_aicte_form");
-        $page_content .= drupal_render($scilab_fixer_aicte_form);
-        return $page_content;
-    }
-
-    function scilab_fixer_aicte_edit_all($aicte_id=0) {
-        $page_content = "";         
-        if($aicte_id) {
-            $scilab_fixer_aicte_form = drupal_get_form("scilab_fixer_aicte_form", $aicte_id);
-            $page_content .= drupal_render($scilab_fixer_aicte_form);
-        } else {
-            /*$query = "
-                SELECT * FROM textbook_companion_aicte
-                ORDER BY time DESC
-            ";
-            $result = db_query($query);*/
-            $query = db_select('textbook_companion_aicte');
-            $query->fields('textbook_companion_aicte');
-            $query->orderBy('time', 'DESC');
-            $result = $query->execute();
-            $headers = array(
-                "Book", "Author",
-                "Edition", "Action",
-            );
-            $rows = array();
-            
-            while($row = $result->fetchObject()) {
-                $item = array(                    
-                    "{$row->book}",
-                    "{$row->author}",
-                    "{$row->edition}",
-                    l(t("Edit"), "fix/aicte/edit/{$row->id}")                    
-                );
-                if($row->selected) {
-                    $check = "<input class='selected' type='checkbox' data-bid='{$row->id}' checked>";
-                } else {
-                    $check = "<input class='selected' type='checkbox' data-bid='{$row->id}'>";
-                }                
-                array_push($item, $check);
-                array_push($rows, $item);
-                }
-            //$page_content .= theme("table", $headers, $rows);
-            $page_content .= theme("table", array('header' => $headers,'rows'=> $rows));
-        }
-        return $page_content;
-    }
-
-    function scilab_fixer_aicte_in_all(){
-        $page_content = "";        
-        /*$query = "
-            SELECT * FROM textbook_companion_aicte
-        ";
-        $result = db_query($query);*/
-        $query = db_select('textbook_companion_aicte');
-         $query->fields('textbook_companion_aicte');
-         $result = $query->execute();
-        $headers = array(
-            "Book", "Publisher", "Action"
-        );
-        $rows = array();
-        while($row = $result->fetchObject()) {
-            $item = array(
-                "data" => array(
-                    "{$row->book}<br>by{$row->author}",
-                    $row->publisher,
-                ),
-            );
-            $ind_options = array(
-                /* # linking in drupal l() */
-                "fragment" => " ",
-                "external" => TRUE,
-                "attributes" => array(
-                    "class" => "ind-ed",
-                    "data-aicte" => "{$row->id}",
-                )
-            );
-            /* ind-ed link */
-            if($row->ind) {
-                array_push($item["data"], l("Unmark", "", $ind_options));
-            } else {
-                array_push($item["data"], l("Mark", "", $ind_options));
-            }
-            if($row->ind) {
-                $item["class"] .= " orange";
-            }
-            array_push($rows, $item);
-        }
-        $page_content .= theme('table',array('header' =>$headers,'rows' => $rows));
-        return $page_content;
-    }
-
-    function scilab_fixer_code_form($form_state) {
-        $form = array();
-        $form["wrapper"] = array(
-            "#type" => "fieldset",
-            "#title"=> "Code edit form",
-            "#prefix" => "<div id='fix-tbc-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"]["code"] = array(
-            "#type" => "textarea",
-            "#title" => t("Code Editor"),
-        );
-        $form["wrapper"]["submit"] = array(
-            "#type" => "submit",
-            "#value" => "Update"
-        );
-        return $form;
-    }
-
-    function scilab_fixer_code_all() {
-        $page_content = "";
-        $page_content .= "<div id='fix-tbc-page'>";
-            $page_content .= "<center><span id='updating'>Updating...</span></center>";
-            $page_content .= "<span id='done'>Done.</span>";
-            $scilab_fixer_code_form = drupal_get_form("scilab_fixer_code_form");
-            $page_content .= drupal_render($scilab_fixer_code_form);
-            $page_content .= "</div>";
-        return $page_content;
-    }
-
-    function scilab_fixer_init() {
-        drupal_add_css(drupal_get_path("module", "textbook_ companion_fixer") . "/css/textbook_ companion_fixer.css");
-        drupal_add_js(drupal_get_path("module", "textbook_ companion_fixer") . "/js/textbook_ companion_fixer.js");
-        //drupal_add_js(drupal_get_path("module", "scilab_fixer") . "/js/jquery-noconfilct.js");
-        drupal_add_js(drupal_get_path("module", "textbook_ companion_fixer") . "/js/selection.js");
-    }
-?>
diff --git a/textbook_companion_fixer.info~ b/textbook_companion_fixer.info
index bc72bc6..bc72bc6 100755..100644
--- a/textbook_companion_fixer.info~
+++ b/textbook_companion_fixer.info
diff --git a/textbook_companion_fixer.module~ b/textbook_companion_fixer.module
index 13271d0..13271d0 100755..100644
--- a/textbook_companion_fixer.module~
+++ b/textbook_companion_fixer.module