File: /home/barbeatleanalyti/www/mbaris.beatleanalytics.com/application/models/Survey_model.php
<?php
class Survey_model extends CI_Model
{
public function loginSurvey($staId)
{
$this->load->database();
$query = $this->db->get_where("baris_station" , array("db_stLoginId"=>$staId));
$result = $query->result();
return $result;
}
public function endUserLogin($username,$password)
{
$this->load->database();
$pass = md5($password);
$SQL = "SELECT * FROM baris_userlogin WHERE db_userLoginName = '".$username."' AND db_password = '".$pass."' AND db_usertype = 'auditor' ";
//echo "<br />";
$query = $this->db->query($SQL);
$data = $query->result();
if($data)
{
return $data;
}
else
{
$json = '0';
return $json;
}
}
public function getAllquestionBystd($stationId)
{
$this->load->database();
$query = $this->db->get_where("baris_station" , array("stationId"=>$stationId));
$result = $query->result();
$SQL = "SELECT * FROM baris_question WHERE queId in (".$result[0]->db_questionsId.") ";
//echo "<br />";
$query = $this->db->query($SQL);
$data = $query->result();
return $data;
}
public function getAllquestion($queId = ""){
$this->load->database();
if(empty($queId))
$query = $this->db->get('baris_question');
else
$query = $this->db->get_where("baris_question",array("queId"=>$queId));
$result = $query->result();
return $result;
}
public function getAllparams($paramId = ""){
$this->load->database();
if(empty($paramId))
$query = $this->db->get('baris_param');
else
$query = $this->db->get_where("baris_param",array("paramId"=>$paramId));
$result = $query->result();
return $result;
}
public function getParamsDetails($paramIds){
$this->load->database();
//$query = $this->db->get_where("baris_param",array("queId"=>$queId));
$SQL = "SELECT * FROM baris_param where paramId in (".$paramIds.")";
$query = $this->db->query($SQL);
return $query->result();
}
public function getPagesDetails($pageid){
$this->load->database();
$SQL = "SELECT * FROM baris_page where pageId in (".$pageid.")";
$query = $this->db->query($SQL);
return $query->result();
}
public function insertUserFeedback($stationId,$userId,$questionId,$paramId,$pageid,$avavalue)
{
$this->load->database();
/*$branchId = 0;
$getBranchID = $this->db->get_where("beatle_industry" ,array("IndId"=>$this->session->userdata('LoginIndid')));
$rsBrandID = $getBranchID->result();
$branchId = $rsBrandID[0]->db_bracnchid;
// to get orgid
$rsBranches = $this->db->get_where("beatle_branch",array("branchId"=>$branchId));
$rsBrancDetails = $rsBranches->result();
$orgID = $rsBrancDetails[0]->db_branchOrg;*/
$date = date('Y-m-d H:i:s');
$tokenID = md5($stationId."".$userId."".date("Ymd"));
$insertdata = array
(
'db_surveyStationId' => $stationId,
'db_surveyUserid' => $userId,
'db_surveyQuestionId' => $questionId,
'db_surveyParamId' => $paramId,
'db_surveyPageId' => $pageid,
'db_surveyValue' => $avavalue,
'created_date' => $date,
'tokenid' => $tokenID,
'is_submit' => "Y"
);
$updatecheck = array
(
'db_surveyStationId' => $stationId,
'db_surveyUserid' => $userId,
'db_surveyQuestionId' => $questionId,
'db_surveyParamId' => $paramId,
'db_surveyPageId' => $pageid,
'tokenid' => $tokenID,
'is_submit' => "Y"
);
//$this->db->select("*");
//$this->db->from();
$query = $this->db->get_where("baris_survey" , $updatecheck);
$result = $query->result();
if (empty($result))
{
$insertquery = $this->db->insert("baris_survey" , $insertdata);
if ($insertquery)
{
echo 'ddd';
}
}
else
{
$this->load->database();
$this->db->where("db_surveyStationId",$stationId);
$this->db->where("db_surveyUserid",$userId);
$this->db->where("db_surveyQuestionId",$questionId);
$this->db->where("db_surveyParamId",$paramId);
$this->db->where("db_surveyPageId",$pageid);
$this->db->where("tokenid",$tokenID);
$insertquery = $this->db->update("baris_survey" , array('db_surveyValue' => $avavalue));
if ($insertquery)
{
echo 'update';
}
}
}
public function getPageFeedbackStatus($queId,$paramId,$pageId){
$this->load->database();
$stationId = $_SESSION['LoginIndid'];
$userId = $_SESSION['userId'];
$SQL = "SELECT * FROM baris_survey WHERE is_submit = 'Y'";
$SQL .= "
AND db_surveyStationId = ".$stationId." " ;
$SQL .= "
AND db_surveyQuestionId = ".$queId." " ;
$SQL .= "
AND db_surveyUserid = ".$userId." " ;
$SQL .= "
AND db_surveyParamId = ".$paramId." " ;
$SQL .= "
AND db_surveyPageId = ".$pageId." " ;
$SQL .= "
AND tokenid = '".md5($stationId."".$userId."".date("Ymd"))."' " ;
//echo md5($userId."".date("Ymd"));
//die();
//0da4c962d2ea575dd18d95cad0c418de
$query = $this->db->query($SQL);
return $query->result();
}
public function getParamFeedbackStatus($queId,$paramId){
$this->load->database();
$stationId = $_SESSION['LoginIndid'];
$userId = $_SESSION['userId'];
$SQL = "SELECT * FROM baris_survey WHERE is_submit = 'Y'";
$SQL .= "
AND db_surveyStationId = ".$stationId." " ;
$SQL .= "
AND db_surveyQuestionId = ".$queId." " ;
$SQL .= "
AND db_surveyUserid = ".$userId." " ;
$SQL .= "
AND db_surveyParamId = ".$paramId." " ;
$SQL .= "
AND tokenid = '".md5($stationId."".$userId."".date("Ymd"))."' " ;
$query = $this->db->query($SQL);
return $query->result();
}
public function getQuestionFeedbackStatus($queId){
$this->load->database();
$stationId = $_SESSION['LoginIndid'];
$userId = $_SESSION['userId'];
$SQL = "SELECT * FROM baris_survey WHERE is_submit = 'Y'";
$SQL .= "
AND db_surveyStationId = ".$stationId." " ;
$SQL .= "
AND db_surveyQuestionId = ".$queId." " ;
$SQL .= "
AND db_surveyUserid = ".$userId." " ;
$SQL .= "
AND tokenid = '".md5($stationId."".$userId."".date("Ymd"))."' " ;
$SQL .= " GROUP BY db_surveyParamId ";
$query = $this->db->query($SQL);
return $query->result();
}
public function getPageIdOfQuestion($queId){
$this->load->database();
$SQL = "SELECT db_pagesId FROM baris_question WHERE queId = ".$queId;
$query = $this->db->query($SQL);
$result = $query->result();
$SQL = "SELECT GROUP_CONCAT(pageId) AS ListsID FROM baris_page WHERE pageId IN (".$result[0]->db_pagesId.")";
$query = $this->db->query($SQL);
$rsPages = $query->result();
if(!empty($rsPages[0]->ListsID)) {
$rsArr = explode(",",$rsPages[0]->ListsID);
$returnArr = array();
foreach($rsArr as $key => $val){
if(!in_array($val,$returnArr))
$returnArr[] = $val;
}
return $returnArr;
}else {
return array();
}
}
public function getParamIdOfQuestion($queId){
$this->load->database();
$SQL = "SELECT db_paramId FROM baris_question WHERE queId = ".$queId;
$query = $this->db->query($SQL);
$result = $query->result();
$SQL = "SELECT GROUP_CONCAT(paramId) AS ListsID FROM baris_param WHERE paramId IN (".$result[0]->db_paramId.")";
$query = $this->db->query($SQL);
$rsParam = $query->result();
if(!empty($rsParam[0]->ListsID)) {
$rsArr = explode(",",$rsParam[0]->ListsID);
$returnArr = array();
foreach($rsArr as $key => $val){
if(!in_array($val,$returnArr))
$returnArr[] = $val;
}
return $returnArr;
}else {
return array();
}
}
/*public function insertUserFeedback($userid,$LoginIndid,$pageid,$pageConId,$avavalue)
{
$this->load->database();
$branchId = 0;
$getBranchID = $this->db->get_where("beatle_industry" ,array("IndId"=>$this->session->userdata('LoginIndid')));
$rsBrandID = $getBranchID->result();
$branchId = $rsBrandID[0]->db_bracnchid;
// to get orgid
$rsBranches = $this->db->get_where("beatle_branch",array("branchId"=>$branchId));
$rsBrancDetails = $rsBranches->result();
$orgID = $rsBrancDetails[0]->db_branchOrg;
$date = date('Y-m-d H:i:s');
$insertdata = array
(
'db_surveyUserid' => $userid,
'db_surveyIndId' => $LoginIndid,
'db_surveyPageid' => $pageid,
'db_surveyContentId' => $pageConId,
'db_surveyBranchid' => $branchId,
'db_surveyValue' => $avavalue,
'created_date' => $date,
'tokenid' => $this->session->userdata('tokenID'),
'orgid' => $orgID,
'is_submit' => "N"
);
$updatecheck = array
(
'db_surveyUserid' => $userid,
'db_surveyIndId' => $LoginIndid,
'db_surveyPageid' => $pageid,
'db_surveyBranchid' => $branchId,
'db_surveyContentId' => $pageConId,
'tokenid' => $this->session->userdata('tokenID'),
'orgid' => $orgID,
'is_submit' => "N"
);
//$this->db->select("*");
//$this->db->from();
$query = $this->db->get_where("beatle_survey" , $updatecheck);
$result = $query->result();
if (empty($result))
{
$insertquery = $this->db->insert("beatle_survey" , $insertdata);
if ($insertquery)
{
echo 'ddd';
}
}
else
{
$this->load->database();
$this->db->where("db_surveyUserid",$userid);
$this->db->where("db_surveyIndId",$LoginIndid);
$this->db->where("db_surveyPageid",$pageid);
$this->db->where("db_surveyContentId",$pageConId);
$insertquery = $this->db->update("beatle_survey" , array('db_surveyValue' => $avavalue));
if ($insertquery)
{
echo 'update';
}
}
}*/
}
?>