RacingCustomerController.php
5.13 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
<?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 RacingCustomerController extends Controller
{
public function __construct()
{
$this->middleware('auth');
//$this->middleware('module_access');
}
public function saveRacingCustomer()
{
//$product_code = Input::get("product_code");
$pb_name = Input::get("pb_name");
$pb_code = Input::get("pb_code");
$pb_landline_contact_no = Input::get("pb_landline_contact_no");
$supervisor_mail_id = Input::get("supervisor_mail_id");
$group_id = Input::get("group_id");
$group_id_name = Input::get("group_id_name");
$cust_id = Input::get("cust_id");
$cust_name = Input::get("cust_name");
$relationship_with_group_id = Input::get("relationship_with_group_id");
$cust_id_next = Input::get("cust_id_next");
$cust_name_next = Input::get("cust_name_next");
$relationship_with_group_id_next = Input::get("relationship_with_group_id_next");
$new_group_addition_to_group = Input::get("new_group_addition_to_group");
$racing_from = Input::get("racing_from");
$user_id = Auth::user()->username;
$clientcode = Input::get('clientcode');
$mobile = Input::get('mobile');
$client = Input::get('client');
if($pb_name=="")return "<script>simpleNotification('error','topRight','please enter pb name');</script>";
if($pb_code=="")return "<script>simpleNotification('error','topRight','please enter pb code');</script>";
if($pb_landline_contact_no=="")return "<script>simpleNotification('error','topRight','please enter PB landline Contact No.');</script>";
if($supervisor_mail_id=="")return "<script>simpleNotification('error','topRight','please enter Supervisor Mail ID');</script>";
if($group_id=="")return "<script>simpleNotification('error','topRight','please enter Group ID');</script>";
if($group_id_name=="")return "<script>simpleNotification('error','topRight','please enter Group ID Name');</script>";
if($cust_id=="")return "<script>simpleNotification('error','topRight','please enter Cust ID');</script>";
if($cust_name=="")return "<script>simpleNotification('error','topRight','please enter Cust Name');</script>";
if($relationship_with_group_id=="")return "<script>simpleNotification('error','topRight','please enter Relationship With Group ID');</script>";
if($cust_id_next=="")return "<script>simpleNotification('error','topRight','please enter Cust ID');</script>";
if($cust_name_next=="")return "<script>simpleNotification('error','topRight','please enter Cust Name');</script>";
if($relationship_with_group_id_next=="")return "<script>simpleNotification('error','topRight','please enter Relationship With Group ID');</script>";
if($new_group_addition_to_group=="")return "<script>simpleNotification('error','topRight','please select Grouping');</script>";
if($racing_from=="")return "<script>simpleNotification('error','topRight','please enter Racing From');</script>";
$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;
}
$setracingCutomer = array();
$setracingCutomer[]="date='".date("Y-m-d H:i:s")."'";
//$setracingCutomer[]="product_code='$product_code'";
$setracingCutomer[]="pb_name='$pb_name'";
$setracingCutomer[]="pb_code='$client'";
$setracingCutomer[]="pb_landline_contact_no='$pb_landline_contact_no'";
$setracingCutomer[]="supervisor_mail_id='$supervisor_mail_id'";
$setracingCutomer[]="group_id='$group_id'";
$setracingCutomer[]="group_id_name='$group_id_name'";
$setracingCutomer[]="cust_id='$cust_id'";
$setracingCutomer[]="cust_name='$cust_name'";
$setracingCutomer[]="relationship_with_group_id='$relationship_with_group_id'";
$setracingCutomer[]="cust_id_next='$cust_id_next'";
$setracingCutomer[]="cust_name_next='$cust_name_next'";
$setracingCutomer[]="relationship_with_group_id_next='$relationship_with_group_id_next'";
$setracingCutomer[]="new_group_addition_to_group='$new_group_addition_to_group'";
$setracingCutomer[]="racing_from='$racing_from'";
$setracingCutomer[]="call_id='$call_id'";
$setracingCut=implode(",",$setracingCutomer);
if($call_status=='ANSWER' && $call_id!="")
{
DB::statement("insert into potentialcustomer_details set $setracingCut");
return "<script>simpleNotification('success','topRight','Customer Details Saved Successfully');</script>";
}
else
{
return "<script>simpleNotification('error','topRight','Please Get on call first');</script>";
}
}
public function updateracingcust()
{
$id=Input::get("id");
$status=Input::get("supervisorstatus");
DB::statement("update potentialcustomer_details set supervisor_status='$status',supervisor_update='".date("Y-m-d H:i:s")."' where id=$id");
return "<script>simpleNotification('success','topRight','Supervisor status Saved Successfully');</script>";
}
}