summaryrefslogtreecommitdiff
path: root/cloud_comments.module~
diff options
context:
space:
mode:
Diffstat (limited to 'cloud_comments.module~')
-rw-r--r--cloud_comments.module~233
1 files changed, 233 insertions, 0 deletions
diff --git a/cloud_comments.module~ b/cloud_comments.module~
new file mode 100644
index 0000000..a359a41
--- /dev/null
+++ b/cloud_comments.module~
@@ -0,0 +1,233 @@
+<?php
+
+
+function cloud_comments_menu() {
+ $items = array();
+ $items['cloud_comments'] = array(
+ 'title' => 'Cloud Comments',
+ 'page callback' => 'cloud_comments_all',
+ 'access arguments' => array("access cloud_comments"),
+ 'type' => MENU_CALLBACK,
+ );
+
+ $items['cloud_comments/delete'] = array(
+ 'title' => 'Cloud Comments',
+ 'page callback' => 'cloud_comments_delete',
+ 'access arguments' => array("access cloud_comments"),
+ 'type' => MENU_CALLBACK,
+ );
+
+ return $items;
+} // function cloud_comments_menu
+
+function cloud_comments_permission(){
+
+ return array(
+ 'access cloud_comments' => array(
+ 'title' => t('access cloud_comments'),
+ 'restrict access' => TRUE,
+ ),
+ 'reply cloud_comments' => array(
+ 'title' => t('reply cloud_comments'),
+ 'restrict access' => TRUE,
+ ),
+
+ );
+} // function cloud_comments_perm
+
+
+
+function cloud_comments_init() {
+ drupal_add_css(drupal_get_path("module", "cloud_comments") . "/css/cloud_comments.css");
+ drupal_add_js(drupal_get_path("module", "cloud_comments") . "/js/cloud_comments.js");
+} //function cloud_comments_init
+
+
+function cloud_comments_help($path, $arg) {
+ $output = '';
+ switch($path) {
+ case "admin/help#cloud_comments":
+ $output = "<p>" . t("Displays the Comments on cloud and enables the admin to reply to them via e-mail: textbook@scilab.in") . "</p>";
+ break;
+ }
+ return $output;
+} // function cloud_comments_help
+
+
+function cloud_comments_all($example_id=0) {
+ $types = array(
+ "None",
+ "Blank Code / Incorrect code",
+ "Output error",
+ "Execution error",
+ "Missing example(s)",
+ "None",
+ "Blank output",
+ "Any other"
+ );
+ $categories = array(
+ "Others",
+ "Fluid Mechanics",
+ "Control Theory &amp; Control Systems",
+ "Chemical Engineering",
+ "Thermodynamics",
+ "Mechanical Engineering",
+ "Signal Processing",
+ "Digital Communications",
+ "Electrical Technology",
+ "Mathematics &amp; Pure Science",
+ "Analog Electronics",
+ "Digital Electronics",
+ "Computer Programming",
+ "Others"
+ );
+
+ $page_content = "";
+ if($example_id) {
+ $query = "SELECT scc.*, tcc.number AS chapter_no, tce.number AS example_no FROM scilab_cloud_comment scc LEFT JOIN textbook_companion_chapter tcc ON tcc.id = scc.chapter LEFT JOIN textbook_companion_example tce ON tce.id = scc.example WHERE scc.example = {:example_id} ORDER BY scc.date DESC";
+ } else {
+ $query = "SELECT scc.*, tcc.number AS chapter_no, tce.number AS example_no FROM scilab_cloud_comment scc LEFT JOIN textbook_companion_chapter tcc ON tcc.id = scc.chapter LEFT JOIN textbook_companion_example tce ON tce.id = scc.example ORDER BY scc.date DESC";
+ }
+ // $query_result = pager_query($query, 5, 0 );
+ $query_result = db_query($query, array(':example_id' => $example_id));
+
+ while ($row = $query_result->fetchObject()) {
+
+ $border = $row->reply_status?"sent":"not-sent";
+ $page_content .= t("<div class='feedback {$border}'>");
+
+ $page_content .= t("<div class='timestamp'>") . $row->date . t("</div>");
+ if (user_access("reply cloud_comments")) {
+ $page_content .= t("<div class='from'> <b>From:</b> ") . $row->email . t("</div>");
+ }
+
+ $page_content .= t("<div class='type'> <b>Type:</b> ") . $types[$row->type] . t("</div>");
+
+ $q = "SELECT book from {textbook_companion_preference} where id = :book";
+ $qr = db_query($q, array(':book'=>$row->books));
+ $obj = $qr->fetchObject();
+ $page_content .= t("<div class='type'> <b>Category: </b>") . $categories[$row->category] . t("</div>");
+ $page_content .= t("<div class='type'> <b>Book:</b> ") . $obj->book . t("</div>");
+
+ $q = "SELECT name from {textbook_companion_chapter} where id = :chapter";
+ $qr = db_query($q, array(':chapter' => $row->chapter));
+ $obj = $qr->fetchObject();
+ $chapter = $obj->name?$obj->name:"None";
+ $page_content .= t("<div class='type'> <b>Chapter: </b> ") . $chapter . ($row->chapter_no?" (<b>{$row->chapter_no}</b>)":"") . t("</div>");
+
+
+ $q = "SELECT caption from {textbook_companion_example} where id = :example";
+ $qr = db_query($q, array(':example' => $row->example));
+ $obj = $qr->fetchObject();
+ $example_link = $obj->caption?l($obj->caption,"https://cloud.scilab.in/index?eid=".$row->example):"None";
+
+ $page_content .= t("<div class='example'> <b>Example: </b>") . $example_link . ($row->example_no?" (<b>{$row->example_no}</b>)":"") . t("</div>");
+
+ $page_content .= t("<div class='comment'> <br><b>Comment:</b><br>") . $row->comment . t("</div>");
+
+ if ($row->reply) {
+ if(!$row->user){
+ $page_content .= t("<div class='reply'> <br><b>Reply Sent:</b><br>") . $row->reply . t("</div>");
+ }else{
+ $page_content .= t("<div class='reply'> <br><b>Reply Sent By ".$row->user.":</b><br>") . $row->reply . t("</div>");
+ }
+ }
+ else {
+ if (user_access("reply cloud_comments")) {
+ // $page_content .= t("<span class='btn-reply'><a class='form_{$row->id}' href='#form_{$row->id}'>Reply</a></span><br>");
+ $page_content .= t("<div id='form_{$row->id}' class='formwrapper'>");
+ $cloud_comments_reply_form = drupal_get_form("cloud_comments_reply_form_".$row->id, $row->id);
+ $page_content .= drupal_render($cloud_comments_reply_form);
+ $page_content .= t("</div>");
+ $page_content .= t("<a href='cloud_comments/delete/{$row->id}' id='del_{$row->id}' class='delete'>x</a>");
+ }
+ }
+ $page_content .= t("</div>");
+ } // while ends
+ $page_content .= theme('pager', array('header' => NULL, 'rows' => 5 ));
+ return $page_content;
+} // function cloud_comments_all
+
+function cloud_comments_forms($form_id) {
+ $forms = array();
+ if (strpos($form_id, 'cloud_comments_reply_form_') === 0) {
+ $forms[$form_id] = array(
+ 'callback' => 'cloud_comments_reply_form',
+ );
+ }
+ return $forms;
+} // function cloud_comments_forms
+
+function cloud_comments_reply_form($form, $form_state, $comment_id) {
+ $form = array();
+ $form["#submit"] = array(
+ 'cloud_comments_reply_form_submit',
+ );
+
+ $form["content"] = array(
+ '#type' => 'textarea',
+ '#wysiwyg' => True
+ );
+ $form["hidden"] = array(
+ '#type' => 'hidden',
+ '#default_value' => $comment_id
+ );
+ $form["submit"] = array(
+ '#type' => 'submit',
+ '#value' => 'Reply'
+ );
+
+ return $form;
+} // function reply_form
+
+function cloud_comments_reply_form_submit($form, &$form_state) {
+ global $user;
+
+ $query = "UPDATE {scilab_cloud_comment} SET reply = :reply, user= :users, reply_status = 1 WHERE id = :id";
+ $query_result = db_query($query, array(':reply'=> $form_state["values"]["content"], ':users' => $user->name, ':id' => $form_state["values"]["hidden"]));
+
+ $email_query = "SELECT email FROM {scilab_cloud_comment} WHERE id = :id";
+ $result = db_query($email_query, array(':id' => $form_state["values"]["hidden"]));
+ $obj = $result->fetchObject();
+
+ /* $message = array(
+ 'to' => $obj->email,
+ 'subject' => t("Comment Reply"),
+ 'body' => array(0=> t($form_state["values"]["content"])),
+ 'headers' => array("From" => "textbook@scilab.in", "Content-type" => "text/html; charset=iso-8859-1")
+
+ );
+ send_mail($message);
+*/
+/* sending mail */
+ $to = $obj->email;
+ $subject = t("Scilab on Cloud Comment Reply");
+ $message = t($form_state["values"]["content"]);
+ // drupal_mail_send($message);
+ send_mail("textbook@scilab.in", $to, $subject, $message);
+
+
+
+ if (!$query_result) {
+ drupal_set_message("Database updation failed");
+ } else {
+ drupal_set_message("Message sent. . .");
+ }
+
+} // function reply_form_submit
+
+function cloud_comments_delete($comment_id=NULL) {
+ if ($comment_id && user_access("reply cloud_comments")) {
+ $query = "DELETE FROM {scilab_cloud_comment} WHERE id = :id";
+ $query_result = db_query($query, array(':id' => $comment_id));
+ if ($query_result->rowCount() > 0) {
+ drupal_set_message("Deleted");
+ } else {
+ drupal_set_message("MySQL Error: row deletion failed.");
+ }
+ }
+ drupal_goto("cloud_comments");
+}
+
+
+?>
generated by cgit (git 2.34.1) at 2025-03-12 18:59:26 +0000