first commit

6 files changed, 404 insertions, 0 deletions

diff --git a/js/socm.js b/js/socm.js
new file mode 100644
index 0000000..f10101a
--- /dev/null
+++ b/js/socm.js
@@ -0,0 +1,22 @@
+(function($) {
+	$(document).ready(function() {
+
+		var basePath = Drupal.settings.basePath;
+		var modPath1 = basePath + "scilab-on-cloud-management/display-books/";
+		$Selected = $(".selected");
+		$Selected.click(function(e) {
+			$(".sync-msg").remove();
+			$(this).after("<span class='sync-msg'>Saving...</span>");
+			$.ajax({
+				url: modPath1 + "ajax/selected/" + $(this).attr("data-bid"),
+				success: function(data) {
+					$(".sync-msg").remove();
+					console.log("success");
+					console.log(data);
+				}
+			});
+		});
+
+
+	});
+})(jQuery);
diff --git a/js/socm.js~ b/js/socm.js~
new file mode 100644
index 0000000..f10101a
--- /dev/null
+++ b/js/socm.js~
@@ -0,0 +1,22 @@
+(function($) {
+	$(document).ready(function() {
+
+		var basePath = Drupal.settings.basePath;
+		var modPath1 = basePath + "scilab-on-cloud-management/display-books/";
+		$Selected = $(".selected");
+		$Selected.click(function(e) {
+			$(".sync-msg").remove();
+			$(this).after("<span class='sync-msg'>Saving...</span>");
+			$.ajax({
+				url: modPath1 + "ajax/selected/" + $(this).attr("data-bid"),
+				success: function(data) {
+					$(".sync-msg").remove();
+					console.log("success");
+					console.log(data);
+				}
+			});
+		});
+
+
+	});
+})(jQuery);
diff --git a/scilab_on_cloud_management.info b/scilab_on_cloud_management.info
new file mode 100644
index 0000000..ad2fcf8
--- /dev/null
+++ b/scilab_on_cloud_management.info
@@ -0,0 +1,5 @@
+name = Scilab on Cloud management
+description = Module to control display Scilab TBC on scilab on cloud
+version = 7.1
+core = 7.x
+package = IITB
diff --git a/scilab_on_cloud_management.info~ b/scilab_on_cloud_management.info~
new file mode 100644
index 0000000..ad2fcf8
--- /dev/null
+++ b/scilab_on_cloud_management.info~
@@ -0,0 +1,5 @@
+name = Scilab on Cloud management
+description = Module to control display Scilab TBC on scilab on cloud
+version = 7.1
+core = 7.x
+package = IITB
diff --git a/scilab_on_cloud_management.module b/scilab_on_cloud_management.module
new file mode 100644
index 0000000..2f19e2d
--- /dev/null
+++ b/scilab_on_cloud_management.module
@@ -0,0 +1,175 @@
+<?php
+function scilab_on_cloud_management_menu()
+{
+    $items = array();
+    $items["scilab-on-cloud-management/display-books"] = array(
+        "title" => "Display TBC on scilab on cloud",
+        "page callback" => "display_books_edit_all",
+        "access arguments" => array(
+            "enable edit scilab on cloud management"
+        ),
+        "type" => MENU_NORMAL_ITEM
+    );
+    $items["scilab-on-cloud-management/display-books/ajax"] = array(
+        "page callback" => "scilab_on_cloud_management_ajax",
+        "access callback" => TRUE,
+        "access arguments" => array(
+            "enable edit scilab on cloud management"
+        ),
+        "type" => MENU_CALLBACK
+    );
+        return $items;
+    }
+
+function scilab_on_cloud_management_permission()
+{
+    return array(
+        "enable edit scilab on cloud management" => array(
+            "title" => t("Enable edit for scilab_on_cloud_management"),
+            'restrict access' => TRUE
+        )
+    );
+}
+
+function display_books_edit_all(){
+    $page_content = "";
+    $page_content .= "Note: If the book is checked it will not display on scilab on cloud books list";
+        $query = "SELECT pe.id, pe.book as book, pe.author as author,
+                            pe.edition, pe.publisher as publisher,
+                            pe.year as year, pe.cloud_pref_err_status,
+                            pe.id as pe_id, po.approval_date as approval_date
+                            FROM textbook_companion_preference pe
+                            LEFT JOIN textbook_companion_proposal po ON
+                            pe.proposal_id = po.id WHERE po.proposal_status = 3
+                            AND pe.approval_status = 1
+                            ORDER BY pe.book ASC ";
+        $result = db_query($query);
+        $headers = array(
+            "Sr. No.",
+            "Book",
+            "Author",
+            "Publisher",
+            "Edition",
+            "Action"
+        );
+        $rows = array();
+        $i = 1;
+        while ($row = $result->fetchObject()) {
+            $item = array(
+                "$i",
+                "{$row->book}",
+                "{$row->author}",
+                "{$row->publisher}",
+                "{$row->edition}",
+            );
+            $i++;
+            if ($row->cloud_pref_err_status) {
+                $check = "<input class='selected' type='checkbox' data-bid='{$row->id}' checked>";
+            } //$row->selected
+            else {
+                $check = "<input class='selected' type='checkbox' data-bid='{$row->id}'>";
+            }
+            array_push($item, $check);
+            array_push($rows, $item);
+        } //$row = $result->fetchObject()
+        //$page_content .= theme("table", $headers, $rows);
+        $page_content .= theme("table", array(
+            'header' => $headers,
+            'rows' => $rows
+        ));
+    
+    return $page_content;
+}
+
+function scilab_on_cloud_management_ajax($item = "", $key = "")
+{
+    $data = "";
+    global $user;
+    if ($item == "selected") {
+        $query = "
+                UPDATE textbook_companion_preference
+                SET cloud_pref_err_status = !cloud_pref_err_status
+                WHERE id = :id
+            ";
+        $args = array(
+            ":id" => $key
+        );
+        db_query($query, $args);
+        $data = "updated";
+        /* sending email */
+        $email_to = $user->mail;
+        $from = variable_get('textbook_companion_from_email', '');
+        $bcc = variable_get('textbook_companion_fixer_bcc_emails', '');
+        $cc = variable_get('textbook_companion_fixer_cc_emails', '');
+        $params['cloud_error_status_updated']['pref_id'] = $key;
+        $params['cloud_error_status_updated']['user_id'] = $user->uid;
+        $params['cloud_error_status_updated']['headers'] = array(
+            'From' => $from,
+            'MIME-Version' => '1.0',
+            'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+            'Content-Transfer-Encoding' => '8Bit',
+            'X-Mailer' => 'Drupal',
+            'Cc' => $cc,
+            'Bcc' => $bcc
+        );
+        if (!drupal_mail('scilab_on_cloud_management', 'cloud_error_status_updated', $email_to, language_default(), $params, $from, TRUE)) {
+            $data .= 'Error sending email message.';
+        }
+    } //$item == "selected"
+    echo $data;
+    exit();
+}
+function scilab_on_cloud_management_mail($key, &$message, $params)
+{
+    global $user;
+    $language = $message['language'];
+    switch ($key) {
+            case 'cloud_error_status_updated':
+            $query = db_select('textbook_companion_preference');
+            $query->fields('textbook_companion_preference');
+            $query->condition('id', $params['cloud_error_status_updated']['pref_id']);
+            $query->range(0, 1);
+            $result = $query->execute();
+            $preference_data = $result->fetchObject();
+            if ($preference_data->cloud_pref_err_status == 0){
+                $display_book_on_scilab_cloud = "Yes";
+            }else{
+            $display_book_on_scilab_cloud = "No";
+            }
+            $user_data = user_load($params['cloud_error_status_updated']['user_id']);
+            $message['headers'] = $params['cloud_error_status_updated']['headers'];
+            $message['subject'] = t('[!site_name][Textbook companion][Scilab On Cloud] TBC book scilab on cloud error status updated ' . $preference_data->book, array(
+                '!site_name' => variable_get('site_name', '')
+            ), array(
+                'language' => $language->language
+            ));
+            $message['body'] = array(
+                'body' => t('
+Dear !user_name,
+
+You have updated the scilab on cloud error status for following book :
+
+Title of the book : ' . $preference_data->book . '
+Author : ' . $preference_data->author. '
+Publisher : '. $preference_data->publisher .'
+Edition : '. $preference_data->edition .'
+
+Display TBC on scilab on cloud : '. $display_book_on_scilab_cloud .' 
+Best Wishes,
+
+Scilab TBC Team,
+FOSSEE, IIT Bombay', array(
+                    '!site_name' => variable_get('site_name', ''),
+                    '!user_name' => $user_data->name
+                ), array(
+                    'language' => $language->language
+                ))
+            );
+            break;
+    } //$key
+}
+
+function scilab_on_cloud_management_init()
+{
+    drupal_add_js(drupal_get_path("module", "scilab_on_cloud_management") . "/js/socm.js");
+}
diff --git a/scilab_on_cloud_management.module~ b/scilab_on_cloud_management.module~
new file mode 100644
index 0000000..2f19e2d
--- /dev/null
+++ b/scilab_on_cloud_management.module~
@@ -0,0 +1,175 @@
+<?php
+function scilab_on_cloud_management_menu()
+{
+    $items = array();
+    $items["scilab-on-cloud-management/display-books"] = array(
+        "title" => "Display TBC on scilab on cloud",
+        "page callback" => "display_books_edit_all",
+        "access arguments" => array(
+            "enable edit scilab on cloud management"
+        ),
+        "type" => MENU_NORMAL_ITEM
+    );
+    $items["scilab-on-cloud-management/display-books/ajax"] = array(
+        "page callback" => "scilab_on_cloud_management_ajax",
+        "access callback" => TRUE,
+        "access arguments" => array(
+            "enable edit scilab on cloud management"
+        ),
+        "type" => MENU_CALLBACK
+    );
+        return $items;
+    }
+
+function scilab_on_cloud_management_permission()
+{
+    return array(
+        "enable edit scilab on cloud management" => array(
+            "title" => t("Enable edit for scilab_on_cloud_management"),
+            'restrict access' => TRUE
+        )
+    );
+}
+
+function display_books_edit_all(){
+    $page_content = "";
+    $page_content .= "Note: If the book is checked it will not display on scilab on cloud books list";
+        $query = "SELECT pe.id, pe.book as book, pe.author as author,
+                            pe.edition, pe.publisher as publisher,
+                            pe.year as year, pe.cloud_pref_err_status,
+                            pe.id as pe_id, po.approval_date as approval_date
+                            FROM textbook_companion_preference pe
+                            LEFT JOIN textbook_companion_proposal po ON
+                            pe.proposal_id = po.id WHERE po.proposal_status = 3
+                            AND pe.approval_status = 1
+                            ORDER BY pe.book ASC ";
+        $result = db_query($query);
+        $headers = array(
+            "Sr. No.",
+            "Book",
+            "Author",
+            "Publisher",
+            "Edition",
+            "Action"
+        );
+        $rows = array();
+        $i = 1;
+        while ($row = $result->fetchObject()) {
+            $item = array(
+                "$i",
+                "{$row->book}",
+                "{$row->author}",
+                "{$row->publisher}",
+                "{$row->edition}",
+            );
+            $i++;
+            if ($row->cloud_pref_err_status) {
+                $check = "<input class='selected' type='checkbox' data-bid='{$row->id}' checked>";
+            } //$row->selected
+            else {
+                $check = "<input class='selected' type='checkbox' data-bid='{$row->id}'>";
+            }
+            array_push($item, $check);
+            array_push($rows, $item);
+        } //$row = $result->fetchObject()
+        //$page_content .= theme("table", $headers, $rows);
+        $page_content .= theme("table", array(
+            'header' => $headers,
+            'rows' => $rows
+        ));
+    
+    return $page_content;
+}
+
+function scilab_on_cloud_management_ajax($item = "", $key = "")
+{
+    $data = "";
+    global $user;
+    if ($item == "selected") {
+        $query = "
+                UPDATE textbook_companion_preference
+                SET cloud_pref_err_status = !cloud_pref_err_status
+                WHERE id = :id
+            ";
+        $args = array(
+            ":id" => $key
+        );
+        db_query($query, $args);
+        $data = "updated";
+        /* sending email */
+        $email_to = $user->mail;
+        $from = variable_get('textbook_companion_from_email', '');
+        $bcc = variable_get('textbook_companion_fixer_bcc_emails', '');
+        $cc = variable_get('textbook_companion_fixer_cc_emails', '');
+        $params['cloud_error_status_updated']['pref_id'] = $key;
+        $params['cloud_error_status_updated']['user_id'] = $user->uid;
+        $params['cloud_error_status_updated']['headers'] = array(
+            'From' => $from,
+            'MIME-Version' => '1.0',
+            'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+            'Content-Transfer-Encoding' => '8Bit',
+            'X-Mailer' => 'Drupal',
+            'Cc' => $cc,
+            'Bcc' => $bcc
+        );
+        if (!drupal_mail('scilab_on_cloud_management', 'cloud_error_status_updated', $email_to, language_default(), $params, $from, TRUE)) {
+            $data .= 'Error sending email message.';
+        }
+    } //$item == "selected"
+    echo $data;
+    exit();
+}
+function scilab_on_cloud_management_mail($key, &$message, $params)
+{
+    global $user;
+    $language = $message['language'];
+    switch ($key) {
+            case 'cloud_error_status_updated':
+            $query = db_select('textbook_companion_preference');
+            $query->fields('textbook_companion_preference');
+            $query->condition('id', $params['cloud_error_status_updated']['pref_id']);
+            $query->range(0, 1);
+            $result = $query->execute();
+            $preference_data = $result->fetchObject();
+            if ($preference_data->cloud_pref_err_status == 0){
+                $display_book_on_scilab_cloud = "Yes";
+            }else{
+            $display_book_on_scilab_cloud = "No";
+            }
+            $user_data = user_load($params['cloud_error_status_updated']['user_id']);
+            $message['headers'] = $params['cloud_error_status_updated']['headers'];
+            $message['subject'] = t('[!site_name][Textbook companion][Scilab On Cloud] TBC book scilab on cloud error status updated ' . $preference_data->book, array(
+                '!site_name' => variable_get('site_name', '')
+            ), array(
+                'language' => $language->language
+            ));
+            $message['body'] = array(
+                'body' => t('
+Dear !user_name,
+
+You have updated the scilab on cloud error status for following book :
+
+Title of the book : ' . $preference_data->book . '
+Author : ' . $preference_data->author. '
+Publisher : '. $preference_data->publisher .'
+Edition : '. $preference_data->edition .'
+
+Display TBC on scilab on cloud : '. $display_book_on_scilab_cloud .' 
+Best Wishes,
+
+Scilab TBC Team,
+FOSSEE, IIT Bombay', array(
+                    '!site_name' => variable_get('site_name', ''),
+                    '!user_name' => $user_data->name
+                ), array(
+                    'language' => $language->language
+                ))
+            );
+            break;
+    } //$key
+}
+
+function scilab_on_cloud_management_init()
+{
+    drupal_add_js(drupal_get_path("module", "scilab_on_cloud_management") . "/js/socm.js");
+}