OneAssistController.php
2.94 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
<?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 OneAssistController extends Controller
{
public function __construct()
{
$this->middleware('auth');
//$this->middleware('module_access');
}
public function saveOneAssistFormDetails()
{
$call_status="";
$record_id="";
$crm_id="";
$call_number="";
$varid=Input::get('varid');
$mobile=Input::get('mobile');
$client=Input::get('client');
$cod_cust=Input::get('clientcode');
$ucic_id=Input::get('ucicid_clientcode');
$firstname=Input::get('customer_name');
$unit=Input::get('unit');
$emailid=Input::get('emailid');
$remarks=Input::get('agent_remarks');
$cust_remarks=Input::get('cust_remarks');
$user_id=Auth::user()->id;
/*$crmcallDetails=CRMCall::where('number','like','%'.substr($mobile,-10).'%')->orderBy("created_at","DESC")->first();*/
//echo "mobile-----".$mobile."-----customer name---".$firstname;
$crmcallDetails=CRMCall::where('crm_id','=',$varid)->orderBy("created_at","DESC")->first();
if($crmcallDetails)
{
$created_at = $crmcallDetails->created_at;
$call_id = $crmcallDetails->id;
$call_status = $crmcallDetails->status;
$crm_id = $crmcallDetails->crm_id;
$call_number = $crmcallDetails->number;
}
/*$remarks = DB::table("full_remark")->where("call_id","=",$call_id)->select("fullremark","DESC")->first();*/
//$setracingCutomer = array();
$setoaentry = array();
$setoaentry[]="agent_remarks='$remarks'";
$setoaentry[]="call_number='$call_number'";
$setoaentry[]="mobile='$mobile'";
$setoaentry[]="pbcode='$client'";
$setoaentry[]="customer_name='$firstname'";
$setoaentry[]="user_id='$user_id'";
$setoaentry[]="call_id='$call_id'";
$setoaentry[]="record_id='$varid'";
$setoaentry[]="emailid='$emailid'";
$setoaentry[]="unit='$unit'";
$setoaentry[]="cod_cust='$cod_cust'";
$setoaentry[]="ucic_id='$ucic_id'";
$setoaentry[]="call_created_at='$created_at'";
$setoaentry[]="cust_remarks='$cust_remarks'";
$setoaenter=implode(",",$setoaentry);
$oaFormrecordid = DB::table("oa_leadform")->where("record_id","=",$varid)->where("call_id","=",$call_id)->select('record_id','call_id')->first();
if($oaFormrecordid)
{
$record_id=$oaFormrecordid->record_id;
$oacallid=$oaFormrecordid->call_id;
}
if($record_id==$varid && $oacallid==$call_id)
{
DB::statement("update oa_leadform set $setoaenter,updated_at=now() where record_id='$varid' and call_id='$call_id'");
}
else
{
DB::statement("insert into oa_leadform set $setoaenter,created_at=now()");
}
return "<script>simpleNotification('success','topRight','Customer Details Saved Successfully');</script>";
}
}