<?php

	require_once('class.db.php');

	class Self_assessment_test_sentences extends DB
	{		
	
		//Get maximum no. of self assessment test sentences to upload in excel file value
		public function getMaxNoOfSelfAssessmentTestSentencesUploadExcel() {			
			//$max_no_sentneces_upload_excel = 100;			
			$sql_get_max_no_of_sentences_upload_excel = "SELECT wea_no_of_sentences_to_upload_in_excel FROM settings WHERE id = 1";
			$result_max_no_of_sentences_upload_excel = $this->con->query( $sql_get_max_no_of_sentences_upload_excel );
			while( $row_max_no_of_sentences_upload_excel = $result_max_no_of_sentences_upload_excel->fetch_object() ) {
				$max_no_sentneces_upload_excel = (int)$row_max_no_of_sentences_upload_excel->wea_no_of_sentences_to_upload_in_excel;
			}
			return $max_no_sentneces_upload_excel;
		}
		
		//Get maximum no. of self assessment test sentences to upload in db table value
		public function getMaxNoOfSelfAssessmentTestSentencesUploadValue() {			
			//$max_no_sentneces_upload = 50;
			$sql_get_max_no_of_sentences_upload_value = "SELECT wea_no_of_sentences_to_store FROM settings WHERE id = 1";
			$result_max_no_of_sentences_upload = $this->con->query( $sql_get_max_no_of_sentences_upload_value );
			while( $row_max_no_of_sentences_upload = $result_max_no_of_sentences_upload->fetch_object() ) {
				$max_no_sentneces_upload = (int)$row_max_no_of_sentences_upload->wea_no_of_sentences_to_store;
			}
			return $max_no_sentneces_upload;
		}
		
		//Get require minimum words count in sentence to upload from excel 
		public function getRequireMinWordsCountInSentence() {
			//$min_require_words_count_in_sentence = 5;
			$sql_settings_values_for_wea_min_word = "SELECT wea_min_words_require_to_upload_sentnece FROM settings WHERE id = 1";
			$settings_wea_min_word_values_result = $this->con->query($sql_settings_values_for_wea_min_word);
			while ($row_settings_wea_min_word_values = $settings_wea_min_word_values_result->fetch_object()) {
				$min_require_words_count_in_sentence = (int)$row_settings_wea_min_word_values->wea_min_words_require_to_upload_sentnece;
			}
			return $min_require_words_count_in_sentence;
		}
		
		//get total no. of self assessment sentences uploaded count by user
		public function getTotalSelfAssessmentTestSentnecesUploadedCount( $uploaded_by_user_id ) {
			$sql_get_self_assessment_test_sentences = "SELECT * FROM `self_assessment_test_sentences` WHERE uploaded_by = " . $uploaded_by_user_id;
			$result_self_assessment_test_sentences = $this->con->query( $sql_get_self_assessment_test_sentences );
			return $result_self_assessment_test_sentences->num_rows;
		}
		
		//get self assessment test sentences count by language id and original message
		public function getSelfAssessmentTestSentencesCountByLanguageIdAndOriginalSentence( $language_id, $original_message ) {
			$sql_get_self_assessment_test_sentences_count = "SELECT * FROM `self_assessment_test_sentences` WHERE language_id = " . $language_id . " AND original_message = '" . $original_message ."' ";
			$result_self_assessment_test_sentences_count = $this->con->query( $sql_get_self_assessment_test_sentences_count );
			return $result_self_assessment_test_sentences_count->num_rows;
		}
		
		//insert uploaded sentences into the self_assessment_test_sentences db table and get sentence id
		public function insertSelfAssessmentTestSentenceAndGetSentenceId( $language_id, $original_message, $translated_message, $uploaded_by_user_id ) {
			$sqlInsert = 'INSERT INTO `self_assessment_test_sentences`(`language_id`, `original_message`, `translated_message`, `uploaded_by`) VALUES '
					. '(' . $language_id . ', "' . addslashes($original_message) . '","' . addslashes($translated_message) . '", ' . $uploaded_by_user_id . ' )';			
			$resultInsert = $this->con->query($sqlInsert);		
			$sentence_id = $this->con->insert_id;			
			return  $sentence_id;			
		}
		
		//insert first suggestion into the self_assessment_test_sentence_suggestion db table
		public function insertFirstSelfAssessmentTestSentenceSuggestion( $sentence_id, $uploaded_by_user_id, $translated_message ) {
			$sql_insert_suggestion = 'INSERT INTO `self_assessment_test_sentence_suggestion`(`sentence_id`, `user_id`,  `suggested_text`, `is_locked`, `is_success`, `submitted_at` ) VALUES '
					. '(' . $sentence_id . ',' . $uploaded_by_user_id . ',"' . addslashes($translated_message) . '", 1, 1, NOW() )';
			$result_insert_suggestion = $this->con->query($sql_insert_suggestion);
		}
		
		//insert uploaded extras sentences into the self_assessment_test_sentences_extras db table 
		public function insertSelfAssessmentTestSentenceExtras( $language_id, $original_message, $translated_message, $uploaded_by_user_id ) {
			$sqlInsert = 'INSERT INTO `self_assessment_test_sentences_extras`(`language_id`, `original_message`, `translated_message`, `uploaded_by`) VALUES '
					. '(' . $language_id . ', "' . addslashes($original_message) . '","' . addslashes($translated_message) . '", ' . $uploaded_by_user_id . ' )';			
			$resultInsert = $this->con->query($sqlInsert);							
		}
		
	}
?>