<?php
require_once("/opt/msa/lib/php/include/dbPDO.php");

class survey_model {
	private $_quizes = '';
	function __construct() {
		$this->db_cms = CommonPDOConnector::connect('ConnectToCMS');
		$this->db_admin = CommonPDOConnector::connect('ConnectToAdmin');
		$this->_quizes = 'rep_surveys';
	}

	public function createQuiz($user_id, $type=1) {
		if(!empty($user_id ) )
		{
			$quiz_display_id = md5($user_id."_nquiz_".time());
			$data = array('display_id'=> $quiz_display_id,
					'type'=> $type,
					'creator_id'=> $user_id,
					'answer_order'=> 1,
					'privacy'=> 1,
					'published'=> 0			
				     );
			if($this->db_admin->insert($this->_quizes, $data)) {
				return $quiz_display_id;
			}
		}

		return false;
	}

	public function isValidQuiz($display_id, $user_id) {
		$key = md5("display_id=$display_id and creator_id = $user_id");
		$ttl = 60 * 30; // 2 hours

		$result = $this->getRedisKeyData($key);
		if(!$result)
		{
			//$query = $this->db_admin->query($sql);
			$this->db_admin->select("id");
			$this->db_admin->from($this->_quizes); 
			$this->db_admin->where("display_id",$display_id);
			$this->db_admin->where("creator_id",$user_id);
			$this->db_admin->limit(1);
			$result = array();
			if($query->num_rows() == 1) {
				$row = $query->row();
				if($row->id && $row->id != '')
				{
					$this->setRedisKeyData($key, $row->id);
					return true;
				}

			}
		}
		return false;
	}

	public function publishQuiz($quiz_display_id) {
		if($quiz_display_id != '')
		{
			$data = array('published'=>1, 'timestamp'=>time());
			$this->db_admin->where('display_id', $quiz_display_id);
			return $this->db_admin->update($this->_quizes, $data);
		}
		return false;
	}

	public function updatePersonalityQuiz($quiz_id, $title, $description, $answer_order, $privacy) {
		$title = addslashes($title);
		$slug_title = generateSlug($title);
		$description = addslashes($description);

		$data = array('title'=>$title, 'slug_title'=>$slug_title, 'description'=> $description,'answer_order'=>$answer_order,'privacy'=>$privacy);
		$this->db_admin->where('id', $quiz_id);
		$status = $this->db_admin->update($this->_quizes, $data); 
		log_message('error',$this->db_admin->last_query());
		return  $status;
	}

	public function updateVideoQuiz($quiz_id, $title, $description, $answer_order, $privacy) {
		$title = addslashes($title);
		$slug_title = generateSlug($title);
		$description = addslashes($description);

		$data = array('title'=>$title, 'slug_title'=>$slug_title, 'description'=> $description,'answer_order'=>$answer_order,'privacy'=>$privacy);
		$this->db_admin->where('id', $quiz_id);
		return $this->db_admin->update($this->_quizes, $data);

	}

	public function updatePoll($quiz_id, $title, $description, $wrap_text, $answer_order, $privacy) {
		$title = addslashes($title);
		$slug_title = generateSlug($title);
		$description = addslashes($description);
		$wrap_text = addslashes($wrap_text);

		$data = array('title'=>$title, 'slug_title'=>$slug_title, 'description'=> $description,'answer_order'=>$answer_order,'privacy'=>$privacy,'wrap_text'=>$wrap_text);
		$this->db_admin->where('id', $quiz_id);
		return $this->db_admin->update($this->_quizes, $data);		
	}

	public function updateGalleryQuiz($quiz_id, $title, $description, $answer_order, $privacy) {
		$title = addslashes($title);
		$slug_title = generateSlug($title);
		$description = addslashes($description);

		$data = array('title'=>$title, 'slug_title'=>$slug_title, 'description'=> $description,'answer_order'=>$answer_order,'privacy'=>$privacy);
		$this->db_admin->where('id', $quiz_id);
		return $this->db_admin->update($this->_quizes, $data);
	}

	public function updateQuizCategories($quiz_id, $categoriesArr, $otherCategories) {
		$categories = array();
		$dbCategories = array('celebrities'=>1, 'tv'=>2, 'film'=>3, 'music'=>4, 'style'=>5, 'sexy'=>6, 'cute'=>7, 'food'=>8, 'funny'=>9, 'animals'=>10, 'games'=>11, 'love'=>12, 'holidays'=>13, 'retro'=>14, 'tech'=>15, 'politics'=>16, 'internet'=>17, 'books'=>18, 'sports'=>19, 'world'=>20, 'art'=>21, 'news'=>22);

		$this->db_admin->where('survey_id', $quiz_id);
		$this->db_admin->delete('rep_survey_survCat');

		if(isset($categoriesArr) && is_array($categoriesArr) && count($categoriesArr) > 0)
		{
			$categories = $categoriesArr;
		}

		if(count($categories) < 3 && trim($otherCategories) != '')
		{
			$otherCategoriesArr = explode(",", $otherCategories);
			foreach($otherCategoriesArr as $otherCategory)
			{
				$categories[] = addslashes(trim($otherCategory));
			}
		}

		if(count($categories) > 0)
		{
			if(count($categories) > 3)
				$insCategories = array_slice($categories, 0, 3);
			else
				$insCategories = $categories;

			foreach($insCategories as $category)
			{
				$catId = 0;
				if(array_key_exists($category, $dbCategories))
					$catId = $dbCategories[$category];
				else
				{
					$sql = "select * from rep_survey_categories where cat like '{$category}'";
					$query = $this->db_admin->query($sql);
					if($query)
					{
						if($query->num_rows() == 1) {
							$row = $query->row();
							if($row && isset($row->id) && $row->id != '')
							{
								$catId = $row->id;
							}
						}
					}
				}

				if($catId == 0)
				{
					$iSql = "insert into rep_survey_categories values (0, '{$category}')";
					$iquery = $this->db_admin->query($iSql);
					$catId = $this->db_admin->insert_id();
				}

				if($catId > 0)
				{
					$iSql = "insert into rep_survey_survCat values ({$quiz_id}, {$catId})";
					$iquery = $this->db_admin->query($iSql);
				}
			}
		}

		return true;
	}

	public function updateIntroImageS3($quiz_id, $image_url, $imageAttr) {
		$data = array('image_url'=> $image_url,	'image_attr'=> $imageAttr);
		$this->db_admin->where('id', $quiz_id);
		$status = $this->db_admin->update($this->_quizes, $data);

		if( $status ) {
			$data = array('social_image_url'=> $image_url);
			$this->db_admin->where('id', $quiz_id);
			$this->db_admin->where('social_image_url', '');
			return $this->db_admin->update($this->_quizes, $data);
		}
		return $status;
	}

	public function updateIntroImage($quiz_id, $fileDir, $fileName, $imageAttr) {
		$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;

		$data = array('image_url'=> $image_url,	'image_attr'=> $imageAttr);
		$this->db_admin->where('id', $quiz_id);

		if( $this->db_admin->update($this->_quizes, $data)) {
			$data = array('social_image_url'=> $image_url);
			$this->db_admin->where('id', $quiz_id);
			$this->db_admin->where('social_image_url', '');
			return $this->db_admin->update($this->_quizes, $data);
		}
	}

	public function updateSocialImageS3($quiz_id, $image_url) {
		$data = array('social_image_url'=> $image_url);
		$this->db_admin->where('id', $quiz_id);
		return $this->db_admin->update($this->_quizes, $data); 
	}

	public function updateSocialImage($quiz_id, $fileDir, $fileName, $imageAttr) {
		$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;
		$data = array('social_image_url'=> $image_url);
		$this->db_admin->where('id', $quiz_id);
		return $this->db_admin->update($this->_quizes, $data); 
	}

	public function updateResult($quiz_id, $resultId, $resultTitle, $resultDesc) {
		$resultTitle = addslashes($resultTitle);
		$resultDesc = addslashes($resultDesc);

		$data = array('title'=> $resultTitle,'description'=>$resultDesc);
		$this->db_admin->where('id', $resultId);
		$this->db_admin->where('survey_id', $quiz_id);
		$status =  $this->db_admin->update('rep_survey_results', $data); 
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status; 
	}

	public function updateResultImageS3($quiz_id, $resultId, $image_url, $imageAttr) {
		$data = array('image_url'=> $image_url,'image_attr'=>$imageAttr);
		$this->db_admin->where('id', $resultId);
		$this->db_admin->where('survey_id', $quiz_id);
		return $this->db_admin->update('rep_survey_results', $data);
	}

	public function updateResultImage($quiz_id, $fileDir, $fileName, $resultId, $imageAttr) {
		$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;

		$data = array('image_url'=> $image_url,'image_attr'=>$imageAttr);
		$this->db_admin->where('id', $resultId);
		$this->db_admin->where('survey_id', $quiz_id);
		return $this->db_admin->update('rep_survey_results', $data);
	}

	public function updateResultVideo($quiz_id, $quiz_display_id, $resultId, $video_url, $video_start_at) {
		$data = array('video_url'=> $video_url,'video_start_at'=>$video_start_at);
		$this->db_admin->where('id', $resultId);
		$this->db_admin->where('survey_id', $quiz_id);
		return $this->db_admin->update('rep_survey_results', $data);
	}

	public function createResultS3($quiz_id, $title, $description, $image_url, $imageAttr='', $video_url = '', $video_start_at = 0) {
		if($quiz_id == '' || $quiz_id == 0) {
			return false;
		}

		if($title != '' || $description != '' || $image_url != '') {
			$title = addslashes($title);
			$description = addslashes($description);

			$data = array(
					'survey_id'=> $quiz_id,
					'title'=>$title, 
					'description'=>$description, 
					'image_url'=>$image_url, 
					'image_attr'=>$imageAttr, 
					'video_url'=>$video_url, 
					'video_start_at'=>$video_start_at);

			$this->db_admin->insert('rep_survey_results', $data);
			$resultId = $this->db_admin->insert_id(); 
			log_message('error','Result Update Query----'.$this->db_admin->last_query());
			return (int)$resultId;
		} else {
			return false;
		}
	}

	public function createResult($quiz_id, $title, $description, $fileDir, $fileName, $imageAttr='', $video_url = '', $video_start_at = 0) {
		if($quiz_id == '' || $quiz_id == 0)
			return false;

		$image_url = '';
		if($fileDir != '' && $fileName != '')
			$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;

		if($title != '' || $description != '' || $image_url != '')
		{
			$title = addslashes($title);
			$description = addslashes($description);

			$data = array('survey_id'=> $quiz_id,'title'=>$title, 'description'=>$description, 
					'image_url'=>$image_url, 'image_attr'=>$imageAttr, 'video_url'=>$video_url, 
					'video_start_at'=>$video_start_at);
			$this->db_admin->insert('rep_survey_results', $data);
			$resultId = $this->db_admin->insert_id(); 
			log_message('error','Result Update Query----'.$this->db_admin->last_query());
			if($resultId && $resultId > 0)
			{
				return array('success'=>true, 'resultId'=>$resultId);
			}
			else
				return false;
		}
		else
			return false;
	}

	public function deleteResult($resultId) {
		$this->admin_db->where('id', $resultId);
		$status = $this->db_admin->delete('rep_survey_results');
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status;
	}

	public function updateQuestion($questionId, $question, $quiz_id = 0, $orderNum = 0) {
		$question = addslashes($question);
		$this->db_admin->where('id', $questionId);
		$status = $this->db_admin->update('rep_survey_ques', array('question'=>$question));
		log_message('error','Question Update Query----'.$this->db_admin->last_query());

		if($orderNum > 0 && $quiz_id > 0)
		{
			$this->db_admin->where('survey_id', $quiz_id);
			$this->db_admin->where('ques_id', $questionId);
			$this->db_admin->update('rep_survey_survQues', array('order_num'=>$orderNum));
			log_message('error','Question Order Update Query----'.$this->db_admin->last_query());

		}
		return $status;
	}

	public function updateQuestionVideo($questionId, $video_url, $video_start_at) {
		$data = array('video_url'=> $video_url,'video_start_at'=>$video_start_at);
		$this->db_admin->where('id', $questionId);
		$status= $this->db_admin->update('rep_survey_ques', $data);
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status;

	}

	public function updateQuestionImageS3($image_url, $questionId, $imageAttr) {	
		$data = array('image_url'=> $image_url,'image_attr'=>$imageAttr);
		$this->db_admin->where('id', $questionId);
		$status = $this->db_admin->update('rep_survey_ques', $data);
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status;
	}

	public function updateQuestionImage($fileDir, $fileName, $questionId, $imageAttr) {

		$data = array('image_url'=> $image_url,'image_attr'=>$imageAttr);
		$this->db_admin->where('id', $questionId);
		$status = $this->db_admin->update('rep_survey_ques', $data);
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status;
	}

	public function createQuestionS3($quiz_id, $question, $image_url, $imageAttr = '', $orderNum = 0, $video_url = '', $video_start_at = 0) {
		if($quiz_id == '' || $quiz_id == 0){
			return false;
		}

		if($question != '' || $image_url != '' || $video_url != ''){
			$question = addslashes($question);

			$data = array('question'=> $question, 'image_url'=>$image_url, 'image_attr'=>$imageAttr, 'video_url'=>$video_url, 'video_start_at'=>$video_start_at);
			$this->db_admin->insert('rep_survey_ques', $data);
			$questionId = $this->db_admin->insert_id();
			log_message('error','Result Update Query----'.$this->db_admin->last_query());

			if($questionId && $questionId > 0) {
				if($orderNum == 0) {
					$max_ord = 0;
					$mSql = "select IFNULL(max(order_num), 0) as mord from rep_survey_survQues where survey_id = {$quiz_id}";
					$mquery = $this->db_admin->query($mSql);
					if($mquery && $mquery->num_rows() == 1) {
						$mrow = $mquery->row();
						if($mrow->mord && $mrow->mord > 0){
							$max_ord = $mrow->mord;
						}
					}
					$orderNum = $max_ord + 1;
				}

				$data = array('survey_id'=> $quiz_id, 'ques_id'=>$questionId, 'order_num'=>$orderNum);
				$this->db_admin->insert('rep_survey_survQues', $data);
				log_message('error','Result Update Query----'.$this->db_admin->last_query());
				return (int)$questionId;
			} else {
				return false;
			}
		} 

		return false;
	}

	public function createQuestion($quiz_id, $question, $fileDir, $fileName, $imageAttr = '', $orderNum = 0, $video_url = '', $video_start_at = 0) {
		if($quiz_id == '' || $quiz_id == 0)
			return false;

		$image_url = '';
		if($fileDir != '' && $fileName != '')
			$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;

		if($question != '' || $image_url != '' || $video_url != '')
		{
			$question = addslashes($question);

			$data = array('question'=> $question, 'image_url'=>$image_url, 'image_attr'=>$imageAttr, 'video_url'=>$video_url, 'video_start_at'=>$video_start_at);
			$this->db_admin->insert('rep_survey_ques', $data);
			$questionId = $this->db_admin->insert_id();
			log_message('error','Result Update Query----'.$this->db_admin->last_query());

			if($questionId && $questionId > 0)
			{
				if($orderNum == 0)
				{
					$max_ord = 0;
					$mSql = "select max(order_num) as mord from rep_survey_survQues where survey_id = {$quiz_id}";
					$mquery = $this->db_admin->query($mSql);
					if($mquery && $mquery->num_rows() == 1) {
						$mrow = $mquery->row();
						if($mrow->mord && $mrow->mord > 0)
							$max_ord = $mrow->mord;
					}
					$orderNum = $max_ord + 1;
				}

				$data = array('survey_id'=> $quiz_id, 'image_url'=>$questionId, 'image_attr'=>$orderNum);
				$this->db_admin->insert('rep_survey_survQues', $data);
				log_message('error','Result Update Query----'.$this->db_admin->last_query());
				return array('success'=>true, 'questionId'=>$questionId);
			}
			else
				return false;
		}
		else
			return false;
	}

	public function deleteQuestion($questionId) {
		$this->db_admin->where('id', $questionId);
		if($this->db_admin->delete('rep_survey_ques') )
		{

			log_message('error','quiz question Delete Query----'.$this->db_admin->last_query());

			$this->db_admin->where('ques_id', $questionId);
			$this->db_admin->delete('rep_survey_quesAns');
			log_message('error','Answer Delete Query----'.$this->db_admin->last_query());

			$this->db_admin->where('ques_id', $questionId);
			$this->db_admin->delete('rep_survey_survQues');
			log_message('error','Question Delete Query----'.$this->db_admin->last_query());

			return true;
		}
		return false;
	}

	public function updateQuestionOrder($quiz_id, $questionId, $orderNum=0) {
		if($orderNum > 0)
		{
			$data = array('order_num'=> $orderNum);
			$this->db_admin->where('survey_id', $quiz_id);
			$this->db_admin->where('ques_id', $questionId);
			$this->db_admin->update('rep_survey_survQues', $data);
			log_message('error','Question Order update----'.$this->db_admin->last_query());		
		}

		return true;
	}

	public function updateAnswerImageS3($answerId, $image_url) {
		$data = array('image_url'=> $image_url);
		$this->db_admin->where('id', $answerId);
		$status =  $this->db_admin->update('rep_survey_ans', $data);
		log_message('error',' Update Answer Image----'.$this->db_admin->last_query());
		return $status;
	}

	public function updateAnswerImage($answerId, $fileDir, $fileName) {
		$image_url = "http://quizdestiny.com/buzzImages/".$fileDir."/".$fileName;
		$data = array('image_url'=> $image_url);
		$this->db_admin->where('id', $answerId);
		$status =  $this->db_admin->update('rep_survey_ans', $data);
		log_message('error',' Update Answer Image----'.$this->db_admin->last_query());
		return $status;
	}

	public function updateAnswer($questionId, $answerId, $answer, $resultId, $correct = 0) {
		$data = array('answer'=> $answer,'correct'=>$correct);
		$this->db_admin->where('id', $answerId);
		$this->db_admin->update('rep_survey_ans', $data);
		log_message('error','Update answer query----'.$this->db_admin->last_query());

		$data = array('ques_id'=> $questionId,'ans_id'=>$answerId,'result_id'=>$resultId);
		$sql = $this->db_admin->insert_string('rep_survey_quesAns', $data) . " ON DUPLICATE KEY UPDATE result_id={$resultId}";
		$status = $this->db_admin->query($sql); 
		log_message('error','Result Update Query----'.$this->db_admin->last_query());
		return $status;
	} 

	public function createAnswerS3($questionId, $answer, $resultId, $correct = 0, $imageUrl = '') {
		$data = [
			'answer'=> addslashes($answer),
			'image_url'=>$imageUrl, 
			'correct'=>$correct
		];


		$this->db_admin->insert('rep_survey_ans', $data);
		$answerId = $this->db_admin->insert_id();

		log_message('error',' Create Asnwer  for image  Query----'.$this->db_admin->last_query());

		if($answerId && (int)$questionId) {
			$data = [
				'ques_id'=> (int)$questionId,
				'ans_id'=>$answerId, 
				'result_id'=>$resultId
			];
			$sql = $this->db_admin->insert_string('rep_survey_quesAns', $data) . " ON DUPLICATE KEY UPDATE result_id={$resultId}";
			$this->db_admin->query($sql); 
			log_message('error',' Create Asnwer Query----'.$this->db_admin->last_query());
		}

		if($answerId) {
			return $answerId;
		} else {
			return false;
		}
	}

	public function createAnswer($questionId, $answer, $resultId, $correct = 0, $imageUrl = '') {
		$answer = addslashes($answer);

		$data = array('answer'=> $answer,'image_url'=>$imageUrl, 'correct'=>$correct);
		$this->db_admin->insert('rep_survey_ans', $data);
		$answerId = $this->db_admin->insert_id();
		log_message('error',' Create Asnwer  for image  Query----'.$this->db_admin->last_query());

		if($answerId && $answerId > 0 && isset($questionId) && $questionId > 0)
		{

			$data = array('ques_id'=> $questionId,'ans_id'=>$answerId, 'result_id'=>$resultId);
			$sql = $this->db_admin->insert_string('rep_survey_quesAns', $data) . " ON DUPLICATE KEY UPDATE result_id={$resultId}";
			$this->db_admin->query($sql); 
			log_message('error',' Create Asnwer Query----'.$this->db_admin->last_query());
			return array('success'=>true, 'answerId'=>$answerId);
		}
		else if(!$answerId || $answerId == 0)
			return false;
		else
			return array('success'=>true, 'answerId'=>$answerId);

		return false;
	}

	function deleteAnswer($answerId)
	{
		$this->db_admin->where('id', $id);
		if($this->db_admin->delete('rep_survey_ans') )
		{
			$this->db_admin->where('ans_id', $answerId);
			$this->db_admin->delete('rep_survey_quesAns');
			return true;
		}
		return false;
	}

	public function getQuiz($display_id, $user_id) {
		$found = 0;
		$sql = "select * from rep_surveys where display_id = '{$display_id}'";
		if($user_id != 1)
			$sql .= " and creator_id = {$user_id}";
		$sql .= " limit 1";

		$query = $this->db_admin->query($sql);
		$result = array();
		if($query && $query->num_rows() == 1) {
			$row = $query->row();
			if($row->id && $row->id != '')
			{
				$result = array('id'=>$row->id, 'display_id'=>$row->display_id, 'type'=>$row->type, 'cat_id'=>$row->cat_id, 'subcat_id'=>$row->subcat_id, 'title'=>$row->title, 'description'=>$row->description, 'wrap_text'=>$row->wrap_text, 'image_url'=>$row->image_url, 'social_image_url'=>$row->social_image_url, 'answer_order'=>$row->answer_order, 'privacy'=>$row->privacy);
				$found = 1;
			}
		}

		if($found == 0)
			return false;
		else
		{
			// Get categories
			$categories = array();
			$sql = "select c.cat as category from rep_survey_categories c, rep_survey_survCat sc where sc.cat_id = c.id and sc.survey_id = {$result['id']}";
			$query = $this->db_admin->query($sql);
			if($query && $query->num_rows() > 0) {
				foreach($query->result_array() as $row) {
					$categories[] = strtolower(trim($row['category']));
				}
			}
			$result['categories'] = $categories;

			// Get results 
			$sql = "select * from rep_survey_results where survey_id = {$result['id']}";
			$query = $this->db_admin->query($sql);
			if($query && $query->num_rows() > 0) {
				foreach($query->result_array() as $row) {
					$survey_results[] = $row;
				}
				$result['results'] = $survey_results;
			}
			// End get results

			// Get ques/ans 
			$sql = "select q.* from rep_survey_survQues sq, rep_survey_ques q where sq.ques_id = q.id and sq.survey_id = {$result['id']} order by sq.order_num asc";
			$query = $this->db_admin->query($sql);
			if($query && $query->num_rows() > 0) {
				foreach($query->result_array() as $row) {
					$ques_id = $row['id'];
					$answers = array();

					$aSql = "select a.*, qa.result_id from rep_survey_quesAns qa, rep_survey_ans a where qa.ans_id = a.id and qa.ques_id = {$ques_id}";
					$aquery = $this->db_admin->query($aSql);
					if($aquery && $aquery->num_rows() > 0) {
						foreach($aquery->result_array() as $arow) {
							$answers[] = $arow;
						}
					}

					$questions[] = array('id'=>$ques_id, 'question'=>$row['question'], 'image_url'=>$row['image_url'], 'video_url'=>$row['video_url'], 'video_start_at'=>$row['video_start_at'], 'answers'=>$answers);
				}
				$result['questions'] = $questions;
			}
			// End get ques/ans
		}

		return $result;
	}

	public function unsubscribeEmail($email) {	
		$data = array('email'=> $email,'timeStamp'=>time());
		return $this->db_admin->insert('rep_survey_unsubscribe', $data);
	}

	public function insertPollStats($resultId) {
		$data = array($resultId, 1);
		//$sql = $this->db_admin->insert_string('rep_survey_poll_stats', $data) . ' ON DUPLICATE KEY UPDATE count=count+"'.$data['count'].'"';
		$query = "INSERT INTO rep_survey_poll_stats SET result_id = ?, count = ? ON DUPLICATE KEY UPDATE count=count+1";
		$upsert_query = $this->db_admin->prepare($query);
		$upsert_query->execute($data);
	}
}