File: /home/barbeatleanalyti/www/m.beatleanalytics.com/application/controllers/Survey.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Survey extends CI_Controller {
/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see https://codeigniter.com/user_guide/general/urls.html
*/
public function diwalibanner(){
echo '<img src="'.base_url().'assets/survey/assets/'.rand(1,6).'.jpg">';
exit;
}
public function index()
{
$this->load->model('Survey_model');
$alldata = '';
if(isset($_SESSION['LoginIndid'])){
if( preg_match('/m.beatle/', $_SERVER['HTTP_HOST'])){
redirect('index.php/survey/home');
}
}
if (isset($_POST['depSubmit']))
{
$depId = $this->input->post('departmentId');
$alldata = $this->Survey_model->loginSurvey($depId);
if (!empty($alldata))
{
$dataUsesrId = $alldata[0]->IndId;
$sessiondata = $this->session->set_userdata('LoginIndid',$dataUsesrId);
redirect ('index.php/survey/home');
}
else
{
$alldata['error_masg'] = 'Department-Id Is Not Match Please Enter Right Department-Id';
}
}
$this->load->view('survey/index' , $alldata);
}
public function home()
{
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
if (isset($_POST['storySubmit']))
{
redirect('index.php/survey/end_user_login');
}
$this->load->view('survey/home' , $alldata);
}
public function end_user_login()
{
/*
// while customer allready logged in
if(isset($_SESSION['tokenID']) && isset($_SESSION['tokenID'])){
$tokenID = $this->session->userdata('tokenID');
redirect('index.php/survey/feedback?token='.$tokenID);
}
*/
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$token = $this->input->post('token');
if (isset($_POST['userSubmit']) && empty($token))
{
$username = $this->input->post('endusername');
$password = $this->input->post('enduserpassword');
$dataUsesr = $this->Survey_model->endUserLogin($username,$password);
//print_r($dataUsesr);die;
if (!empty($dataUsesr))
{
$dataUsesrId = $dataUsesr[0]->userId;
$sessiondata = $this->session->set_userdata('userId',$dataUsesrId);
$tokenID = md5(date("YmdHis"));
$this->session->set_userdata('tokenID',$tokenID);
$tokenID = $this->session->userdata('tokenID');
redirect('index.php/survey/feedback?token='.$tokenID);
}
else
{
$alldata['error_masg'] = 'Username or Password Does Not Match Please Confirm Your Username Or Password Again';
}
}
$this->load->view('survey/userLogin' , $alldata);
}
public function usersignup()
{
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$BranchID = $alldata['LimeData'][0]->db_bracnchid;
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$token = $this->input->post('token');
if (isset($_POST['userSubmit']))
{
$enduseremail = $this->input->post('enduseremail');
$endusermobile = $this->input->post('endusermobile');
$endpassword = $this->input->post('endpassword');
$pass = md5($endpassword);
$status = '1';
$date = date('Y-m-d H:i:s');
$uniq = rand(1,1000);
$unqId = 'END_'.$uniq;
$usertype = 'End_user';
$insertdata = array
(
'db_userRandId' => $unqId,
'db_email' => "",
'db_phone' => $endusermobile,
'db_password' => $pass,
'created_date' => $date,
'db_usertype' => $usertype,
'IndustryID' => $indId,
'OrgID' => $Orgid,
'BranchID' => $BranchID
);
$alldata = $this->Survey_model->SignUpUserLogin($insertdata,$enduseremail);
if ($alldata == 'yes')
{
redirect('index.php/survey/end_user_login');
}
else if ($alldata == 'no')
{
$alldata['error_masg'] = 'Some Problum In Insert Data';
}
else
{
$alldata['error_masg'] = 'Username or Password Already Exists';
}
}
$this->load->view('survey/usersignup' , $alldata);
}
public function feedback()
{
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
//print_r($alldata['orgdata']);
$this->load->view('survey/feedback' , $alldata);
}
public function userfeedback_question(){
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
$alldata['Inddata'] = $this->Admin_model->getIndustryById($indId);
$this->load->view('survey/userfeedback_question' , $alldata);
}
public function logout(){
unset($_SESSION['userId']);
unset($_SESSION['tokenID']);
redirect('index.php/survey/end_user_login');
}
public function summery(){
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
$alldata['Inddata'] = $this->Admin_model->getIndustryById($indId);
$this->session->userdata('LoginIndid');
$alldata['userPhoneNo'] = $this->Admin_model->getUserPhoneNo($this->session->userdata('userId'),$this->session->userdata('tokenID'));
$this->load->view('survey/summery' , $alldata);
}
public function userfeedback()
{
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
$alldata['Inddata'] = $this->Admin_model->getIndustryById($indId);
$this->load->view('survey/userfeedback' , $alldata);
}
public function insertUserFeedback()
{
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
$this->load->model('Survey_model');
$userid = $_REQUEST['userid'];
$LoginIndid = $_REQUEST['LoginIndid'];
$pageid = $_REQUEST['pageid'];
$pageConId = $_REQUEST['pageConId'];
$avavalue = $_REQUEST['avavalue'];
$data = $this->Survey_model->insertUserFeedback($userid,$LoginIndid,$pageid,$pageConId,$avavalue);
if (!empty($data))
{
echo 'yes';
}
}
public function thankyou(){
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
$alldata['Inddata'] = $this->Admin_model->getIndustryById($indId);
$this->session->userdata('LoginIndid');
$alldata['userPhoneNo'] = $this->Admin_model->getUserPhoneNo($this->session->userdata('userId'),$this->session->userdata('tokenID'));
// set bonus point data
$this->Admin_model->setBonusPoints($this->session->userdata('userId'),$this->session->userdata('tokenID'),$indId,$Orgid,$alldata['LimeData'][0]->BranchID,$alldata['Loginuserdata'][0]->db_usertype);
$this->db->where("tokenid",$this->session->userdata('tokenID'));
$this->db->where("db_surveyUserid",$this->session->userdata('userId'));
$insertquery = $this->db->update("beatle_survey" , array('is_submit' => "Y"));
$this->load->view('survey/thankyou' , $alldata);
unset($_SESSION['userId']);
unset($_SESSION['tokenID']);
}
public function dailyreports(){
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$rsSurveyData = $this->Admin_model->getAllOrgByIndustryId($indId);
$userID = $rsSurveyData[0]->db_userid;
$OrgID = $rsSurveyData[0]->OrgId;
$BranchID = $rsSurveyData[0]->db_bracnchid;
$PageID = $rsSurveyData[0]->db_pagesId;
$alldata['rsSurveyData'] = $this->Admin_model->fetchLoginDataFrom($indId,$OrgID,$BranchID,$PageID);
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($OrgID);
$alldata['pageData'] = $this->Admin_model->fetchPageIDDetails($PageID);
//echo "<pre>";
//print_r($alldata['rsSurveyData']);
//echo "</pre>";
$this->load->view('survey/dailyreports' , $alldata);
}
public function createticket()
{
if(!isset($_SESSION['userId']) || !isset($_SESSION['tokenID']))
redirect('index.php/survey/end_user_login');
//echo "<pre>";
//print_r($_POST);
//print_r($_SESSION);
$this->load->model('Survey_model');
$this->load->model('Admin_model');
$indId = $this->session->userdata('LoginIndid');
$userid = $this->session->userdata('userId');
$alldata['LimeData'] = $this->Admin_model->getAllUserByIndustryId($indId);
$Orgid = $alldata['LimeData'][0]->db_branchOrg;
$alldata['orgdata'] = $this->Admin_model->getOrganizationById($Orgid);
$alldata['Loginuserdata'] = $this->Admin_model->getuserdata($userid);
if($this->input->post('actionfollow') == 'submitticket') {
$tktid = $this->Admin_model->getLastTicketid();
$indid = $alldata['LimeData'][0]->BranchID;
$orgid = $alldata['LimeData'][0]->OrgID;
$branchid = $alldata['LimeData'][0]->db_bracnchid;
$indid = $alldata['LimeData'][0]->IndId;
$alldata['lmData'] = $this->Admin_model->getLinemanagerByIndustryId($indId);
$assign_usrid = $alldata['lmData'][0]->userId;
$assignto_type = $alldata['lmData'][0]->db_usertype;
$usertype = $alldata['Loginuserdata'][0]->db_usertype;
$insertArr = array();
$insertArr['userid'] = $userid;
$insertArr['usertype'] = $usertype;
$insertArr['orgid'] = $orgid;
$insertArr['branchid'] = $branchid;
$insertArr['indid'] = $indid;
$insertArr['assignto'] = $assign_usrid;
$insertArr['assignto_type'] = $assignto_type;
$insertArr['message'] = $this->input->post('message');
$insertArr['forward'] = "N";
$insertArr['status'] = 'new';
$insertArr['tokenid'] = $this->session->userdata('tokenID');
$insertArr['created_date'] = date("Y-m-d H:i:s");
$insertArr['level'] = 1;
$insertArr['contentselection'] = serialize($_SESSION['ticketdata']);
$insertArr['parentid'] = 0;
$insertArr['id'] = $tktid;
$insertArr['active'] = "Y";
$returnArr = $this->Admin_model->insertTicketData($insertArr);
if($returnArr[0] == 1){
$alldata['messageid'] = $returnArr[0];
$alldata['message'] = "Thank you for using ticket, your ticket no. <strong>".$returnArr[1]."</strong> has been submitted successfully.";
}
redirect ('index.php/survey/feedback?token='.$this->session->userdata('tokenID')."&msg=".$alldata['message']);
}
//echo "<pre>";
//print_r($alldata);
//echo "</pre>";
$this->load->view('survey/createticket' , $alldata);
}
}