QuestionareController.php
6.42 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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?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()
{
$call_id = '';
$call_status = '';
$crm_id = '';
$varid=Input::get('varid');
$questionDateTime=Input::get('questionDateTime');
$questionArray = $_POST['questionArray'];
$questionArray = json_decode($questionArray);
//$questionArray = explode(",",$questionArray);
$questionArray=(array)$questionArray;
/* $recordDetails = DB::table('records')->where('id','=',$varid)->select('firstname','mobile','clientcode')->first();
$user_id = Auth::user()->username;
$cust_id = $recordDetails->clientcode;
$name = $recordDetails->firstname;
$mobile = $recordDetails->mobile;*/
$user_id = Auth::user()->username;
$cust_id = Input::get('clientcode');
$name = Input::get('firstname');
$mobile = Input::get('mobile');
//use number for currection of alert get on call first : by prashant 11/07/2017
//$crmcallDetails=CRMCall::where('crm_id','=',$varid)->orderBy("created_at","DESC")->first();
$crmcallDetails=CRMCall::where('number','like','%'.substr($mobile,-10).'%')->orderBy("created_at","DESC")->first();
if($crmcallDetails)
{
$call_id = $crmcallDetails->id;
$call_status = $crmcallDetails->status;
$crm_id = $crmcallDetails->crm_id;
}
else
{
//return "<script>simpleNotification('Alert','topRight','Get on call first!!')</script>";
}
if($call_status=='ANSWER' && $call_id !="")
{
foreach($questionArray as $key=> $quesArray)
{
$explodeQues = explode("-", $key);
$ques = $explodeQues[1];
$questionid='';
$questioncallid='';
$questiondetails=DB::table("questionaire_details")->where("cust_id","=",$cust_id)->where("call_id","=",$call_id)->where("question","=",$ques)->select('call_id','question')->first();
if($questiondetails)
{
$questioncallid=$questiondetails->call_id;
$questionid=$questiondetails->question;
//echo $questioncallid."---".$questionid;
}
if($questioncallid==$call_id && $questionid==$ques)
{
DB::statement("update questionaire_details set 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."',question='".$ques."',primary_question='".$quesArray->prim_ques."',primary_response='".trim($quesArray->prim_response)."',primary_text='".$quesArray->prim_txt."',followup1_question='".$quesArray->fol1_ques."',followup1_response='".trim($quesArray->fol1_response)."',followup1_text='".$quesArray->fol1_txt."',followup2_question='".$quesArray->fol2_ques."',followup2_response='".trim($quesArray->fol1_response)."',followup2_text='".$quesArray->fol2_txt."',followup3_question='".$quesArray->fol3_ques."',followup3_response='".trim($quesArray->fol1_response)."',followup3_text='".$quesArray->fol3_txt."',followup4_question='".$quesArray->fol4_ques."',followup4_response='".trim($quesArray->fol4_response)."',followup4_text='".$quesArray->fol4_txt."',followup5_question='".$quesArray->fol5_ques."',followup5_response='".trim($quesArray->fol5_response)."',followup5_text='".$quesArray->fol5_txt."',followup6_question='".$quesArray->fol6_ques."',followup6_response='".trim($quesArray->fol6_response)."',followup6_text='".$quesArray->fol6_txt."',followup7_question='".$quesArray->fol7_ques."',followup7_response='".trim($quesArray->fol7_response)."',followup7_text='".$quesArray->fol7_txt."' where call_id='".$call_id."' and question='".$ques."' and cust_id='".$cust_id."' ");
}
else
{
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."',question='".$ques."',primary_question='".$quesArray->prim_ques."',primary_response='".trim($quesArray->prim_response)."',primary_text='".$quesArray->prim_txt."',followup1_question='".$quesArray->fol1_ques."',followup1_response='".trim($quesArray->fol1_response)."',followup1_text='".$quesArray->fol1_txt."',followup2_question='".$quesArray->fol2_ques."',followup2_response='".trim($quesArray->fol1_response)."',followup2_text='".$quesArray->fol2_txt."',followup3_question='".$quesArray->fol3_ques."',followup3_response='".trim($quesArray->fol1_response)."',followup3_text='".$quesArray->fol3_txt."',followup4_question='".$quesArray->fol4_ques."',followup4_response='".trim($quesArray->fol4_response)."',followup4_text='".$quesArray->fol4_txt."',followup5_question='".$quesArray->fol5_ques."',followup5_response='".trim($quesArray->fol5_response)."',followup5_text='".$quesArray->fol5_txt."',followup6_question='".$quesArray->fol6_ques."',followup6_response='".trim($quesArray->fol6_response)."',followup6_text='".$quesArray->fol6_txt."',followup7_question='".$quesArray->fol7_ques."',followup7_response='".trim($quesArray->fol7_response)."',followup7_text='".$quesArray->fol7_txt."'");
}
}
return "<div class='alert alert-success'><strong>All Questions Saved Successfully!</strong></div>";
}
else
{
return "<script>simpleNotification('error','topRight','Please Get on call first');</script>";
}
}
}