QuestionareController_100317.php
3.56 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php namespace App\Http\Controllers;
use Auth;
use Input;
use Config;
use Session;
use App\Http\Controllers;
use App\Http\Requests;
use Illuminate\Http\Request;
use DB;
use Log;
use App\Models\Group;
use App\Models\User;
use App\Models\CRMCall;
class QuestionareController extends Controller
{
public function __construct()
{
$this->middleware('auth');
//$this->middleware('module_access');
}
public function loadQuestions($qid='', $optid='', $level=1)
{
if($qid == '') {
$auth_ques_count = 5;
$where = 'id = 1';
$auth_questions = DB::select('SELECT * FROM authentication_questions_test ORDER BY RAND() LIMIT '.$auth_ques_count );
$query = 'SELECT * FROM question WHERE '.$where;
$questions = DB::select($query);
return view('layout.module.questionare.questions',compact('qid','questions', 'auth_questions', 'auth_ques_count'));
}
else {
$where = 'question_no IN (SELECT question_id FROM question_tree WHERE parent_id = '.$qid.' AND parent_opt = "opt_'.$optid.'")';
$query = 'SELECT * FROM question WHERE '.$where;
$questions = DB::select($query);
return view('layout.module.questionare.childquestions',compact('qid','questions','auth_questions','level'));
}
}
public function saveQuestionAire()
{
$varid=Input::get('varid');
$questionDateTime=Input::get('questionDateTime');
$questionArray = $_POST['questionArray'];
$questionArray = json_decode($questionArray);
//$questionArray = explode(",",$questionArray);
$questionArray=(array)$questionArray;
$authQuestionArray = $_POST['authQuestionArray'];
$authQuestionArray = json_decode($authQuestionArray);
$authQuestionArray=(array)$authQuestionArray;
$recordDetails = DB::table('records')->where('id','=',$varid)->select('*')->first();
$user_id = Auth::user()->username;
$cust_id = $recordDetails->clientcode;
$name = $recordDetails->firstname;
$mobile = $recordDetails->mobile;
$crmcallDetails=CRMCall::where('crm_id','=',$varid)->orderBy("created_at","DESC")->first();
$call_id = $crmcallDetails->id;
foreach($questionArray as $key=> $quesArray){
$explodeQues = explode("-", $key);
$ques = $explodeQues[1];
DB::statement("insert into questionaire_details set created_at='".date("Y-m-d H:i:s")."', updated_at='".date("Y-m-d H:i:s")."', user_id='".$user_id."',cust_id='".$cust_id."',call_id='".$call_id."',name='".$name."',number='".$mobile."',question_time='".$questionDateTime."',auth_question_1='".$authQuestionArray['auth_0']->auth_ques."',auth_opt_1='".trim($authQuestionArray['auth_0']->auth_opt)."',auth_question_2='".$authQuestionArray['auth_1']->auth_ques."',auth_opt_2='".trim($authQuestionArray['auth_1']->auth_opt)."',auth_question_3='".$authQuestionArray['auth_2']->auth_ques."',auth_opt_3='".trim($authQuestionArray['auth_2']->auth_opt)."',auth_question_4='".$authQuestionArray['auth_3']->auth_ques."',auth_opt_4='".trim($authQuestionArray['auth_3']->auth_opt)."',auth_question_5='".$authQuestionArray['auth_4']->auth_ques."',auth_opt_5='".trim($authQuestionArray['auth_4']->auth_opt)."',question='".$ques."',primary_question='".$quesArray->prim_ques."',primary_response='".trim($quesArray->prim_response)."',primary_text='".$quesArray->prim_txt."',followup_question='".$quesArray->fol_ques."',followup_response='".trim($quesArray->fol_response)."',followup_text='".$quesArray->fol_txt."',secondary_question='".$quesArray->sec_ques."',secondary_response='".trim($quesArray->sec_response)."',secondary_text='".$quesArray->sec_txt."'");
}
return "<div class='alert alert-success'><strong>All Questions Saved Successfully!</strong></div>";
}
}