added email notifications for category changes

2 files changed, 205 insertions, 3 deletions

diff --git a/textbook_companion_fixer_edit_book_category.inc b/textbook_companion_fixer_edit_book_category.inc
index 9dc7bc3..531e07a 100644
--- a/textbook_companion_fixer_edit_book_category.inc
+++ b/textbook_companion_fixer_edit_book_category.inc
@@ -108,14 +108,15 @@ function textbook_companion_fixer_category_edit_form($form, &$form_state)
 }
 function textbook_companion_fixer_edit_book_category_ajax($item, $key)
 {
+	global $user;
 	$data = "";
 	$item = arg(2);
+	$main_category = $_POST['main_category'];
+	$sub_category = $_POST['sub_category'];
 	if ($item == "edit-book-category")
 	{
 		if ($_POST['action'] == "add")
 		{
-			$main_category = $_POST['main_category'];
-			$sub_category = $_POST['sub_category'];
 			$query_in1 = "
                 INSERT INTO {textbook_companion_book_main_subcategories}
                 (pref_id, main_category, sub_category)
@@ -128,6 +129,27 @@ function textbook_companion_fixer_edit_book_category_ajax($item, $key)
 				':subcategory' => $sub_category
 			);
 			$result_in1 = db_query($query_in1, $args_in1);
+			/* 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['category_updated']['pref_id'] = $_POST['pref_id'];
+		$params['category_updated']['main_category'] = $main_category;
+		$params['category_updated']['sub_category'] = $sub_category;
+		$params['category_updated']['user_id'] = $user->uid;
+		$params['category_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('textbook_companion_fixer', 'new_category_updated', $email_to, language_default(), $params, $from, TRUE)) {
+			$data .= 'Error sending email message.';
+		}
 		} //$_POST['action'] == "add"
 		elseif ($_POST['action'] == "delete")
 		{
@@ -140,6 +162,27 @@ WHERE pref_id= :pref_id AND main_category= :main_category AND sub_category = :su
 				':subcategory' => $_POST['sub_category']
 			);
 			$result_del1 = db_query($query_del1, $args_del1);
+			/* 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['subcategory_deleted']['pref_id'] = $_POST['pref_id'];
+		$params['subcategory_deleted']['main_category'] = $main_category;
+		$params['subcategory_deleted']['sub_category'] = $sub_category;
+		$params['subcategory_deleted']['user_id'] = $user->uid;
+		$params['subcategory_deleted']['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('textbook_companion_fixer', 'new_subcategory_deleted', $email_to, language_default(), $params, $from, TRUE)) {
+			$data .= 'Error sending email message.';
+		}
 		} //$_POST['action'] == "delete"
 		elseif ($_POST['action'] == "delete-main-with-ub-category")
 		{
@@ -151,6 +194,26 @@ WHERE pref_id= :pref_id AND main_category= :main_category
 				':main_category' => $_POST['main_category']
 			);
 			$result_del2 = db_query($query_del2, $args_del2);
+					/* 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['maincategory_deleted']['pref_id'] = $_POST['pref_id'];
+		$params['maincategory_deleted']['main_category'] = $main_category;
+		$params['maincategory_deleted']['user_id'] = $user->uid;
+		$params['maincategory_deleted']['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('textbook_companion_fixer', 'new_maincategory_deleted', $email_to, language_default(), $params, $from, TRUE)) {
+			$data .= 'Error sending email message.';
+		}
 		} //$_POST['action'] == "delete-main-with-ub-category"
 		else
 		{
diff --git a/textbook_companion_fixer_email.inc b/textbook_companion_fixer_email.inc
index 38df00b..0e9117b 100644
--- a/textbook_companion_fixer_email.inc
+++ b/textbook_companion_fixer_email.inc
@@ -61,7 +61,6 @@ FOSSEE, IIT Bombay', array(
 			);
 			break;
 		case 'chapter_updated':
-			
 			$query = db_select('textbook_companion_chapter');
 			$query->fields('textbook_companion_chapter');
 			$query->condition('id', $params['chapter_updated']['chapter_id']);;
@@ -150,5 +149,145 @@ FOSSEE, IIT Bombay', array(
 				))
 			);
 			break;
+			case 'new_category_updated':
+			$query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $params['category_updated']['pref_id']);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$query_mcat = db_select('list_of_category');
+			$query_mcat->fields('list_of_category');
+			$query_mcat->condition('category_id', $params['category_updated']['main_category']);
+			$query_mcat->range(0, 1);
+			$result_mcat = $query_mcat->execute();
+			$main_category_data = $result_mcat->fetchObject();
+			$query_subcat = db_select('list_of_subcategory');
+			$query_subcat->fields('list_of_subcategory');
+			$query_subcat->condition('subcategory_id', $params['category_updated']['sub_category']);
+			$query_subcat->range(0, 1);
+			$result_subcat = $query_subcat->execute();
+			$sub_category_data = $result_subcat->fetchObject();
+			$user_data = user_load($params['category_updated']['user_id']);
+			$message['headers'] = $params['category_updated']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion][category] You have updated category 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 category for following book :
+
+Title of the book : ' . $preference_data->book . '
+Author : ' . $preference_data->author. '
+
+Main category : '. $main_category_data->maincategory .'
+Sub category : '. $sub_category_data->subcategory .'
+
+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 'new_subcategory_deleted':
+			query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $params['subcategory_deleted']['pref_id']);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$query_mcat = db_select('list_of_category');
+			$query_mcat->fields('list_of_category');
+			$query_mcat->condition('category_id', $params['subcategory_deleted']['main_category']);
+			$query_mcat->range(0, 1);
+			$result_mcat = $query_mcat->execute();
+			$main_category_data = $result_mcat->fetchObject();
+			$query_subcat = db_select('list_of_subcategory');
+			$query_subcat->fields('list_of_subcategory');
+			$query_subcat->condition('subcategory_id', $params['subcategory_deleted']['sub_category']);
+			$query_subcat->range(0, 1);
+			$result_subcat = $query_subcat->execute();
+			$sub_category_data = $result_subcat->fetchObject();
+			$user_data = user_load($params['subcategory_deleted']['user_id']);
+			$message['headers'] = $params['subcategory_deleted']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion][category] You have deleted subcategory 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 deleted the subcategory for following book :
+
+Title of the book : ' . $preference_data->book . '
+Author : ' . $preference_data->author. '
+
+Main category : '. $main_category_data->maincategory .'
+Sub category : '. $sub_category_data->subcategory .'
+
+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 'new_maincategory_deleted':
+			query = db_select('textbook_companion_preference');
+			$query->fields('textbook_companion_preference');
+			$query->condition('id', $params['maincategory_deleted']['pref_id']);
+			$query->range(0, 1);
+			$result = $query->execute();
+			$preference_data = $result->fetchObject();
+			$query_mcat = db_select('list_of_category');
+			$query_mcat->fields('list_of_category');
+			$query_mcat->condition('category_id', $params['maincategory_deleted']['main_category']);
+			$query_mcat->range(0, 1);
+			$result_mcat = $query_mcat->execute();
+			$main_category_data = $result_mcat->fetchObject();
+			$user_data = user_load($params['maincategory_deleted']['user_id']);
+			$message['headers'] = $params['maincategory_deleted']['headers'];
+			$message['subject'] = t('[!site_name][Textbook companion][category] You have deleted main category 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 deleted the main category with subcategory for following book :
+
+Title of the book : ' . $preference_data->book . '
+Author : ' . $preference_data->author. '
+
+Main category : '. $main_category_data->maincategory .'
+
+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
 }