Merge pull request #2 from prashantsinalkar/drupal_7.x

added validaiton and chapter caption editing, mailing feature

1 files changed, 154 insertions, 0 deletions

diff --git a/textbook_companion_fixer_email.inc b/textbook_companion_fixer_email.inc
new file mode 100644
index 0000000..38df00b
--- /dev/null
+++ b/textbook_companion_fixer_email.inc
@@ -0,0 +1,154 @@
+<?php
+/**
+ * Implementation of hook_mail().
+ */
+function textbook_companion_fixer_mail($key, &$message, $params)
+{
+	global $user;
+	$language = $message['language'];
+	switch ($key) {
+		case 'chapter_example_updated':
+			// bcc to textbook_companion_emails
+			//$message['headers'] += $tbc_bcc_emails;
+			/*$example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $params['example_updated']['example_id']);
+			$example_data = db_fetch_object($example_q);*/
+			$query = db_select('textbook_companion_example');
+			$query->fields('textbook_companion_example');
+			$query->condition('id', $params['chapter_example_updated']['example_id']);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$example_data = $result->fetchObject();
+			$query = db_select('textbook_companion_chapter');
+			$query->fields('textbook_companion_chapter');
+			$query->condition('id', $example_data->chapter_id);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$chapter_data = $result->fetchObject();
+			$query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $chapter_data->preference_id);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$user_data = user_load($params['chapter_example_updated']['user_id']);
+			$message['headers'] = $params['chapter_example_updated']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion] You have updated chapter, example caption for textbook ' . $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 following example:
+
+Title of the book : ' . $preference_data->book . '
+Title of the chapter : ' . $chapter_data->name . '
+Example number : ' . $example_data->number . '
+Caption : ' . $example_data->caption . '
+
+
+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;
+		case 'chapter_updated':
+			
+			$query = db_select('textbook_companion_chapter');
+			$query->fields('textbook_companion_chapter');
+			$query->condition('id', $params['chapter_updated']['chapter_id']);;
+			$query->range(0, 1);
+			$result = $query->execute();
+			$chapter_data = $result->fetchObject();
+			$query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $chapter_data->preference_id);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$user_data = user_load($params['chapter_updated']['user_id']);
+			$message['headers'] = $params['chapter_updated']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion] You have updated chapter name for textbook ' . $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 following example:
+
+Title of the book : ' . $preference_data->book . '
+Title of the chapter : ' . $chapter_data->name . '
+
+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;
+		case 'example_updated':
+			$query = db_select('textbook_companion_example');
+			$query->fields('textbook_companion_example');
+			$query->condition('id', $params['example_updated']['example_id']);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$example_data = $result->fetchObject();
+			$query = db_select('textbook_companion_chapter');
+			$query->fields('textbook_companion_chapter');
+			$query->condition('id', $example_data->chapter_id);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$chapter_data = $result->fetchObject();
+			$query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $chapter_data->preference_id);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$user_data = user_load($params['example_updated']['user_id']);
+			$message['headers'] = $params['example_updated']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion] You have updated example caption for textbook ' . $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 following example:
+
+Title of the book : ' . $preference_data->book . '
+Title of the chapter : ' . $chapter_data->name . '
+Example number : ' . $example_data->number . '
+Caption : ' . $example_data->caption . '
+
+
+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
+}