LeadEntryFormController.php
3.04 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 LeadEntryFormController extends Controller
{
public function __construct()
{
$this->middleware('auth');
//$this->middleware('module_access');
}
public function saveLeadEntryFormDetails()
{
$call_status="";
$record_id="";
$crm_id="";
$connected_number="";
$varid=Input::get('varid');
$mobile=Input::get('mobile');
$client=Input::get('client');
$clientcode=Input::get('clientcode');
$firstname=Input::get('firstname');
$br_code=Input::get('br_code');
$br_name=Input::get('br_name');
$lg_code=Input::get('lg_code');
$processing_entity=Input::get('processing_entity');
$lead_owner=Input::get('lead_owner');
$lead_priority=Input::get('lead_priority');
$product = Input::get("product");
$customer_profile=Input::get('customer_profile');
$remarks=Input::get('remarks');
$user_id=Auth::user()->id;
/*$crmcallDetails=CRMCall::where('number','like','%'.substr($mobile,-10).'%')->orderBy("created_at","DESC")->first();*/
$crmcallDetails=CRMCall::where('crm_id','=',$varid)->orderBy("created_at","DESC")->first();
if($crmcallDetails)
{
$call_id = $crmcallDetails->id;
$call_status = $crmcallDetails->status;
$crm_id = $crmcallDetails->crm_id;
$connected_number = $crmcallDetails->number;
}
//$setracingCutomer = array();
$setleadentry = array();
$setleadentry[]="br_code='$br_code'";
$setleadentry[]="br_name='$br_name'";
$setleadentry[]="lg_code='$lg_code'";
$setleadentry[]="processing_entity='$processing_entity'";
$setleadentry[]="lead_owner='$lead_owner'";
$setleadentry[]="product='$product'";
$setleadentry[]="lead_priority='$lead_priority'";
$setleadentry[]="customer_profile='$customer_profile'";
$setleadentry[]="remarks='$remarks'";
$setleadentry[]="connected_number='$connected_number'";
$setleadentry[]="mobile='$mobile'";
$setleadentry[]="client='$client'";
$setleadentry[]="clientcode='$clientcode'";
$setleadentry[]="firstname='$firstname'";
$setleadentry[]="customer_name='$firstname'";
$setleadentry[]="user_id='$user_id'";
$setleadentry[]="call_id='$call_id'";
$setleadentry[]="record_id='$varid'";
$setleadenter=implode(",",$setleadentry);
$leadFormrecordid = DB::table("lead_form")->where("record_id","=",$varid)->where("call_id","=",$call_id)->select('record_id','call_id')->first();
if($leadFormrecordid)
{
$record_id=$leadFormrecordid->record_id;
$leadcallid=$leadFormrecordid->call_id;
}
if($record_id==$varid && $leadcallid==$call_id)
{
DB::statement("update lead_form set $setleadenter,updated_at=now() where record_id='$varid' and call_id='$call_id'");
}
else
{
DB::statement("insert into lead_form set $setleadenter,created_at=now()");
}
return "<script>simpleNotification('success','topRight','Customer Details Saved Successfully');</script>";
}
}