fileuploader = new FileController();
$this->helper = new HelperController();
$this->leads = new LeadController();
}
/**
* Displays datatables front end view
*
* @return \Illuminate\View\View
*/
public function completedLead() {
$subHome = 'Complete Leads List';
$subHomeLink = '/account/leads?status=incompleted';
//Breadcrumb Titles
$breadcrumb = [
'title' => 'Leads',
'subTitle' => 'Incomplete Leads List',
'home' => 'Leads',
'homeLink' => '#',
'subHome' => $subHome,
'subHomeLink' => $subHomeLink,
// 'subChildHome' => 'Vew leads',
'menuColor' => '#fff',
'menu' => 'completed-leads',
'MenuClass' => 'active open',
'SubMenuClass' => 'active',
];
return view('admin.leads.completed_leads', compact('breadcrumb'));
}
public function mmsLead() {
$subHome = 'MMS Transfer Leads List';
$subHomeLink = '/account/leads?status=incompleted';
//Breadcrumb Titles
$breadcrumb = [
'title' => 'Leads',
'subTitle' => 'MMS Transfer Leads List',
'home' => 'Leads',
'homeLink' => '#',
'subHome' => $subHome,
'subHomeLink' => $subHomeLink,
// 'subChildHome' => 'Vew leads',
'menuColor' => '#fff',
'menu' => 'mms-leads',
'MenuClass' => 'active open',
'SubMenuClass' => 'active',
];
return view('admin.leads.mms_leads', compact('breadcrumb'));
}
public function bestToStandardLead() {
$subHome = 'Best to Standard Transfer Leads List';
$subHomeLink = '/account/leads?status=incompleted';
//Breadcrumb Titles
$breadcrumb = [
'title' => 'Leads',
'subTitle' => 'Best to Standard Transfer Leads List',
'home' => 'Leads',
'homeLink' => '#',
'subHome' => $subHome,
'subHomeLink' => $subHomeLink,
// 'subChildHome' => 'Vew leads',
'menuColor' => '#fff',
'menu' => 'mms-leads',
'MenuClass' => 'active open',
'SubMenuClass' => 'active',
];
return view('admin.leads.besttostandard_leads', compact('breadcrumb'));
}
public function completedAffiliateLead() {
$subHome = 'Complete Leads List';
$subHomeLink = '/account/leads?status=incompleted';
//Breadcrumb Titles
$breadcrumb = [
'title' => 'Leads',
'subTitle' => 'Incomplete Leads List',
'home' => 'Leads',
'homeLink' => '#',
'subHome' => $subHome,
'subHomeLink' => $subHomeLink,
// 'subChildHome' => 'Vew leads',
'menuColor' => '#fff',
'menu' => 'completed-leads',
'MenuClass' => 'active open',
'SubMenuClass' => 'active',
];
return view('affliate-admin.completed_leads', compact('breadcrumb'));
}
/**
* Process datatables ajax request.
*
* @return \Illuminate\Http\JsonResponse
*/
public static function completedLeadData(Request $request) {
/* Normal products */
$user = Auth::user();
if ($user->role == 3) {
$affiliate_data = DB::table('users')
->join('affiliate_users', 'affiliate_users.user_id', '=', 'users.id')
->join('affiliates', 'affiliates.id', '=', 'affiliate_users.affiliate_id')
->where('users.id', '=', Auth::user()->id)
->select('affiliates.uid')
->first();
$information = Information::where('policy_number_full', '<>', '')
->where('affid', '=', $affiliate_data->uid)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc');
/*->get(); */
} elseif ($user->role == 6) {
//branch manager
$branch_id = Auth::user()->branch->id;
$broker_users = User::where('role', 3)
->where('branch_id', $branch_id)
->pluck('id')->toArray();
$broker_users = array_merge($broker_users, [$user->id]);
$information = Information::where('policy_number_full', '<>', '')
->with('products', 'tempwebline.webline')
->whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc');
/*->get(); */
} elseif (($user->role == 4) || ($user->role == 5)) {
//Affliate admin or Ho user
$affliate_admin_user = Auth::user();
if ($user->role == 5) {
$affiliate_id = $affliate_uid = $affliate_admin_user->uid;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
} else {
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_id', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
}
$information = Information::
// where('accountnumber','<>', '')->
with('products', 'tempwebline.webline')->
whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc');
/*->get(); */
} else {
$information = Information::
where('policy_number_full', '<>', '')
// ->where('product_id','<>', '28')
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc');
/*->get(); */
}
return Datatables::of($information)
->editColumn('product_name', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
return $query_data->tempwebline->ProductName;
} else {
if (!empty($query_data->products)) {
return $query_data->products->product_name;
}
return "";
}
})
->editColumn('insurance_startdate', function ($query_data) {
if ($query_data->insurance_startdate != '0000-00-00') {
$insurance_startdate = date('d-m-Y', strtotime($query_data->insurance_startdate));
} else {
$insurance_startdate = '';
}
return $insurance_startdate;
})->editColumn('lead_source_field', function ($query_data) {
$lead_source_field = ['bi-app' => 'BestInsurance', 'tle-app' => 'Theleadexpert', 'dlet-app' => 'Discountlettings', '' => 'Direct'];
if($query_data->lead_source_field=="Synaptic - Webline")
{
$quote_information=Quotes::find($query_data->quote_id);
// dd($quote_information);
$affiliate_details_frn=Affiliates::where('frn_number',$quote_information->frn_number)->first();
if(empty($affiliate_details_frn))
{
$result = $query_data->lead_source_field;
return $result;
}
$result = $query_data->lead_source_field."/".$affiliate_details_frn->broker_firm;
// $result = $quote_information->agent_first_name . " " . $quote_information->agent_last_name."/".$affiliate_details_frn->broker_firm;
return $result;
}
if ($query_data->lead_source_field != '' || $query_data->lead_source_field != 'Web Site') {
$result = $query_data->lead_source_field;
} elseif (isset($query_data->affid)) {
foreach ($lead_source_field as $key => $value) {
if ($key == $query_data->affid) {
$result = $value;
}
}
} else {
$result = $lead_source_field['bi-app'];
}
//
return $result;
})->editColumn('submitted_by', function ($query_data) {
$result = "";
if($query_data->lead_source_field=="Synaptic - Webline")
{
$quote_information=Quotes::find($query_data->quote_id);
// dd($quote_information);
$affiliate_details_frn=Affiliates::where('frn_number',$quote_information->frn_number)->first();
if(empty($affiliate_details_frn))
{
$result = $quote_information->agent_first_name . " " . $quote_information->agent_last_name;
return $result;
}
$result = $quote_information->agent_first_name . " " . $quote_information->agent_last_name."/".$affiliate_details_frn->broker_firm;
return $result;
}
if (!empty($query_data->created_id_by) && ($query_data->created_id_by != 0)) {
$created_user = User::find($query_data->created_id_by);
if (!empty($created_user)) {
if (!empty($created_user->branch)) {
$branch_name = $created_user->branch->branch_name;
} else {
$branch_name = "-";
}
$result = $created_user->profile->full_name . "/" . $branch_name;
}
}
else {
$result = "Default/Default";
}
if($query_data->product_id==17 && $query_data->policy_number==12901)
{
$result = "Thomas Hill/Best Risk Management & Financial Service Limited";
}
return $result;
})
->editColumn('payment', function ($query_data) {
if ((Auth::user()->role == 1 || Auth::user()->role == 7 || Auth::user()->role == 8)) {
$payment = "";
if (empty($query_data->payment_date)) {
$payment .= "Payment ";
} else {
$payment .= "Payment made";
}
if (!empty($query_data->cancel_date)) {
if (empty($query_data->refund_date)) {
$payment .= "Refund ";
} else {
$payment .= "Refunded";
}
}
return $payment;
}
})
->editColumn('status', function ($query_data) {
$user_role = Auth::user()->role;
if (!empty($query_data->cancellation_approve_date)) {
$current_date = Carbon::now();
$cancelled_date = Carbon::parse($query_data->cancellation_approve_date);
if ($current_date->lt($cancelled_date)) {
$status = 'To be cancelled on:' . $cancelled_date->format('Y-m-d') . ' Revert ';
} else {
$status = 'Cancelled ';
}
} elseif ($query_data->status == 1) {
$status = 'Approved ';
} elseif ($query_data->status == -1) {
if ($user_role == 1 || $user_role == 7 || $user_role == 8) {
$status = 'Submitted Submitted ';
}} else {
$status = 'Rejected
';
}
return $status;
})->editColumn('customer_status', function ($query_data) {
$user_role = Auth::user()->role;
if($query_data->status=="1" && empty($query_data->cancellation_approve_date))
{
$select_arrears="";
$dd_cancelled="";
$fnol="";
$sold="";
$sold_claim="";
$sold_claim_arrears="";
$sold_claim_complaint="";
$sold_complaint="";
if($query_data->customer_status=="Arrears")
{
$select_arrears="selected";
}
if($query_data->customer_status=="DD Cancelled")
{
$dd_cancelled="selected";
}
if($query_data->customer_status=="FNOL")
{
$fnol="selected";
}
if($query_data->customer_status=="Sold")
{
$sold="selected";
}
if($query_data->customer_status=="Sold-Claim-Arrears")
{
$sold_claim_arrears="selected";
}
if($query_data->customer_status=="Sold-Claim")
{
$sold_claim="selected";
}
if($query_data->customer_status=="Sold-Claim-Complaint")
{
$sold_claim_complaint="selected";
}
if($query_data->customer_status=="Sold-Complaint")
{
$sold_complaint="selected";
}
$customer_status = ''.$query_data->customer_status.' ';
/* $customer_status="
Arrears
DD Cancelled
FNOL
Sold
Sold-Claim
Sold-Claim-Arrears
Sold-Claim-Complaint
Sold-Complaint
";*/
$customer_status.="Update Status '.$query_data->customer_status.' ';
}
else
{
$customer_status = ''.$query_data->customer_status.' ';
}
}
return $customer_status;
})->editColumn('actions', function ($query_data) {
$user_role = Auth::user()->role;
if (!empty($query_data->cancel_date)) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif ($query_data->product_id == Config::get('constant.BEST_ACCIDENT') || $query_data->product_id == Config::get('constant.BEST_ACCIDENT_PROFIT_TREE')) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) != 'YES') {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$action_result = '
Actions
Toggle Dropdown
';
} else {
$action_result = '==';
}
return $action_result;
})
->make(true);
}
/**
* Process datatables ajax request.
*
* @return \Illuminate\Http\JsonResponse
*/
public static function completedLeadDataOld(Request $request) {
/* Normal products */
$user = Auth::user();
if ($user->role == 3) {
$affiliate_data = DB::table('users')
->join('affiliate_users', 'affiliate_users.user_id', '=', 'users.id')
->join('affiliates', 'affiliates.id', '=', 'affiliate_users.affiliate_id')
->where('users.id', '=', Auth::user()->id)
->select('affiliates.uid')
->first();
$information = Information::where('accountnumber', '<>', '')
->where('affid', '=', $affiliate_data->uid)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc');
/*->get(); */
} elseif ($user->role == 6) {
//branch manager
$branch_id = Auth::user()->branch->id;
$broker_users = User::where('role', 3)
->where('branch_id', $branch_id)
->pluck('id')->toArray();
$broker_users = array_merge($broker_users, [$user->id]);
$information = Information::where('accountnumber', '<>', '')
->with('products', 'tempwebline.webline')
->whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc');
/*->get(); */
} elseif (($user->role == 4) || ($user->role == 5)) {
//Affliate admin or Ho user
$affliate_admin_user = Auth::user();
if ($user->role == 5) {
$affiliate_id = $affliate_uid = $affliate_admin_user->uid;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
} else {
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_id', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
}
$information = Information::
// where('accountnumber','<>', '')->
with('products', 'tempwebline.webline')->
whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc');
/*->get(); */
} else {
$information = Information::
where('accountnumber', '<>', '')
// ->where('product_id','<>', '28')
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc');
/*->get(); */
}
return Datatables::of($information)
->editColumn('product_name', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
return $query_data->tempwebline->ProductName;
} else {
if (!empty($query_data->products)) {
return $query_data->products->product_name;
}
return "";
}
})
->editColumn('insurance_startdate', function ($query_data) {
if ($query_data->insurance_startdate != '0000-00-00') {
$insurance_startdate = date('d-m-Y', strtotime($query_data->insurance_startdate));
} else {
$insurance_startdate = '';
}
return $insurance_startdate;
})->editColumn('lead_source_field', function ($query_data) {
$lead_source_field = ['bi-app' => 'BestInsurance', 'tle-app' => 'Theleadexpert', 'dlet-app' => 'Discountlettings', '' => 'Direct'];
if ($query_data->lead_source_field != '' || $query_data->lead_source_field != 'Web Site') {
$result = $query_data->lead_source_field;
} elseif (isset($query_data->affid)) {
foreach ($lead_source_field as $key => $value) {
if ($key == $query_data->affid) {
$result = $value;
}
}
} else {
$result = $lead_source_field['bi-app'];
}
//
return $result;
})->editColumn('submitted_by', function ($query_data) {
$result = "";
if (!empty($query_data->created_id_by) && ($query_data->created_id_by != 0)) {
$created_user = User::find($query_data->created_id_by);
if (!empty($created_user)) {
if (!empty($created_user->branch)) {
$branch_name = $created_user->branch->branch_name;
} else {
$branch_name = "-";
}
$result = $created_user->profile->full_name . "/" . $branch_name;
}
} else {
$result = "Default/Default";
}
return $result;
})
->editColumn('payment', function ($query_data) {
if ((Auth::user()->role == 1 || Auth::user()->role == 7 || Auth::user()->role == 8)) {
$payment = "";
if (empty($query_data->payment_date)) {
$payment .= "Payment ";
} else {
$payment .= "Payment made";
}
if (!empty($query_data->cancel_date)) {
if (empty($query_data->refund_date)) {
$payment .= "Refund ";
} else {
$payment .= "Refunded";
}
}
return $payment;
}
})
->editColumn('status', function ($query_data) {
$user_role = Auth::user()->role;
if (!empty($query_data->cancellation_approve_date)) {
$current_date = Carbon::now();
$cancelled_date = Carbon::parse($query_data->cancellation_approve_date);
if ($current_date->lt($cancelled_date)) {
$status = 'To be cancelled on:' . $cancelled_date->format('Y-m-d') . ' Revert ';
} else {
$status = 'Cancelled ';
}
} elseif ($query_data->status == 1) {
$status = 'Approved ';
} elseif ($query_data->status == -1) {
if ($user_role == 1 || $user_role == 7 || $user_role == 8) {
$status = 'Submitted Submitted ';
}} else {
$status = 'Rejected
';
}
return $status;
})->editColumn('customer_status', function ($query_data) {
$user_role = Auth::user()->role;
if($query_data->status=="1" && empty($query_data->cancellation_approve_date))
{
$select_arrears="";
$dd_cancelled="";
$fnol="";
$sold="";
$sold_claim="";
$sold_claim_arrears="";
$sold_claim_complaint="";
$sold_complaint="";
if($query_data->customer_status=="Arrears")
{
$select_arrears="selected";
}
if($query_data->customer_status=="DD Cancelled")
{
$dd_cancelled="selected";
}
if($query_data->customer_status=="FNOL")
{
$fnol="selected";
}
if($query_data->customer_status=="Sold")
{
$sold="selected";
}
if($query_data->customer_status=="Sold-Claim-Arrears")
{
$sold_claim_arrears="selected";
}
if($query_data->customer_status=="Sold-Claim")
{
$sold_claim="selected";
}
if($query_data->customer_status=="Sold-Claim-Complaint")
{
$sold_claim_complaint="selected";
}
if($query_data->customer_status=="Sold-Complaint")
{
$sold_complaint="selected";
}
$customer_status="
Arrears
DD Cancelled
FNOL
Sold
Sold-Claim
Sold-Claim-Arrears
Sold-Claim-Complaint
Sold-Complaint
";
$customer_status.="Update Status ";
}
else
{
$customer_status = ''.$query_data->customer_status.' ';
}
return $customer_status;
})->editColumn('actions', function ($query_data) {
$user_role = Auth::user()->role;
if (!empty($query_data->cancel_date)) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif ($query_data->product_id == Config::get('constant.BEST_ACCIDENT') || $query_data->product_id == Config::get('constant.BEST_ACCIDENT_PROFIT_TREE')) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'NO') {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$action_result = '
Actions
Toggle Dropdown
';
} else {
$action_result = '';
}
return $action_result;
})
->make(true);
}
/**
* Process datatables ajax request.
*
* @return \Illuminate\Http\JsonResponse
*/
public static function mmsLeadData(Request $request) {
/* Normal products */
$user = Auth::user();
if ($user->role == 3) {
$affiliate_data = DB::table('users')
->join('affiliate_users', 'affiliate_users.user_id', '=', 'users.id')
->join('affiliates', 'affiliates.id', '=', 'affiliate_users.affiliate_id')
->where('users.id', '=', Auth::user()->id)
->select('affiliates.uid')
->first();
$schemeids = "['RBS128','RBS129','RBS130']";
$information = Information::where('accountnumber', '<>', '')
->whereIn('mms_scheme', ['RBS128', 'RBS129', 'RBS130'])
->where('affid', '=', $affiliate_data->uid)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc')
->get();
} elseif ($user->role == 6) {
//branch manager
$branch_id = Auth::user()->branch->id;
$broker_users = User::where('role', 3)
->where('branch_id', $branch_id)
->pluck('id')->toArray();
$broker_users = array_merge($broker_users, [$user->id]);
$information = Information::where('accountnumber', '<>', '')
->whereIn('mms_scheme', ['RBS128', 'RBS129', 'RBS130'])
->with('products', 'tempwebline.webline')
->whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc')
->get();
} elseif (($user->role == 4) || ($user->role == 5)) {
//Affliate admin or Ho user
$affliate_admin_user = Auth::user();
if ($user->role == 5) {
$affiliate_id = $affliate_uid = $affliate_admin_user->uid;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
} else {
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_id', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
}
$information = Information::
// where('accountnumber','<>', '')->
with('products', 'tempwebline.webline')->
whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc')
->get();
} else {
$information = Information::
where('accountnumber', '<>', '')->
whereIn('mms_scheme', ['RBS128', 'RBS129', 'RBS130'])
->with('products', 'tempwebline.webline')->
limit(3000)->
orderBy('date_added', 'desc')->
get();
}
return Datatables::of($information)
->editColumn('product_name', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
return $query_data->tempwebline->ProductName;
} else {
if (!empty($query_data->products)) {
return $query_data->products->product_name;
}
return "";
}
})
// ->setTotalRecords($information_count)
->editColumn('date_added1', function ($query_data) {
return $query_data->date_added;
})
->editColumn('insurance_startdate', function ($query_data) {
if ($query_data->insurance_startdate != '0000-00-00') {
$insurance_startdate = date('d-m-Y', strtotime($query_data->insurance_startdate));
} else {
$insurance_startdate = '';
}
return $insurance_startdate;
}) /*->editColumn('policy_number', function ($query_data)
{
if(strtoupper($query_data->is_webline_product) == 'NO'){
if(!empty($query_data->products)){
$policy_number = $query_data->products->policy_prefix.$query_data->policy_number;
}else{
$policy_number = "";
}
}elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$policy_number = $query_data->policy_number;
}else {
$policy_number = ' ';
}
return $policy_number;
*//*->editColumn('full_name', function ($query_data) {
return $query_data->fname." ".$query_data->lname;
})*/ ->editColumn('lead_source_field', function ($query_data) {
$lead_source_field = ['bi-app' => 'BestInsurance', 'tle-app' => 'Theleadexpert', 'dlet-app' => 'Discountlettings', '' => 'Direct'];
if ($query_data->lead_source_field != '' || $query_data->lead_source_field != 'Web Site') {
$result = $query_data->lead_source_field;
} elseif (isset($query_data->affid)) {
foreach ($lead_source_field as $key => $value) {
if ($key == $query_data->affid) {
$result = $value;
}
}
} else {
$result = $lead_source_field['bi-app'];
}
//
return $result;
})->editColumn('submitted_by', function ($query_data) {
$result = "";
if (!empty($query_data->created_id_by) && ($query_data->created_id_by != 0)) {
$created_user = User::find($query_data->created_id_by);
if (!empty($created_user)) {
if (!empty($created_user->branch)) {
$branch_name = $created_user->branch->branch_name;
} else {
$branch_name = "-";
}
$result = $created_user->profile->full_name . "/" . $branch_name;
}
} else {
$result = "Default/Default";
}
return $result;
})
->editColumn('rates', function ($query_data) {
if (strtoupper($query_data->is_webline_product) == 'NO') {
$premium = 'Reviewable';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$premium = $query_data->rates;
} else {
$premium = ' ';
}
return $premium;
})->editColumn('status', function ($query_data) {
if (!empty($query_data->cancellation_approve_date)) {
$current_date = Carbon::now();
$cancelled_date = Carbon::parse($query_data->cancellation_approve_date);
if ($current_date->lt($cancelled_date)) {
$status = 'To be cancelled on:' . $cancelled_date->format('Y-m-d') . ' Revert ';
} else {
$status = 'Cancelled ';
}
} elseif ($query_data->status == 1) {
$status = 'Approved ';
} elseif ($query_data->status == -1) {
$status = 'Submitted Rejected
';
}
return $status;
})->editColumn('payment', function ($query_data) {
if ($query_data->status != 0 && (Auth::user()->role == 1 || Auth::user()->role == 7 || Auth::user()->role == 8)) {
$payment = "";
if (empty($query_data->payment_date)) {
$payment .= "Payment Refund ";
} else {
return "";
}
})->editColumn('actions', function ($query_data) {
if (!empty($query_data->cancel_date)) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif ($query_data->product_id == Config::get('constant.BEST_ACCIDENT')) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'NO') {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$action_result = '
Actions
Toggle Dropdown
';
} else {
$action_result = '';
}
return $action_result;
})
->make(true);
}
/**
* Process datatables ajax request.
*
* @return \Illuminate\Http\JsonResponse
*/
public static function besttostandardLeadData(Request $request) {
/* Normal products */
$user = Auth::user();
if ($user->role == 3) {
$affiliate_data = DB::table('users')
->join('affiliate_users', 'affiliate_users.user_id', '=', 'users.id')
->join('affiliates', 'affiliates.id', '=', 'affiliate_users.affiliate_id')
->where('users.id', '=', Auth::user()->id)
->select('affiliates.uid')
->first();
$information = Information::where('accountnumber', '<>', '')
->where('product_id', '=', '28')
->where('affid', '=', $affiliate_data->uid)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'desc')
->get();
} elseif ($user->role == 6) {
//branch manager
$branch_id = Auth::user()->branch->id;
$broker_users = User::where('role', 3)
->where('branch_id', $branch_id)
->pluck('id')->toArray();
$broker_users = array_merge($broker_users, [$user->id]);
$information = Information::where('accountnumber', '<>', '')
->where('product_id', '=', '28')
->with('products', 'tempwebline.webline')
->whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc')
->get();
} elseif (($user->role == 4) || ($user->role == 5)) {
//Affliate admin or Ho user
$affliate_admin_user = Auth::user();
if ($user->role == 5) {
$affiliate_id = $affliate_uid = $affliate_admin_user->uid;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
} else {
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_id', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
}
$information = Information::
// where('accountnumber','<>', '')->
with('products', 'tempwebline.webline')->
whereIn('information.created_id_by', $broker_users)
->orderBy('date_added', 'desc')
->get();
} else {
$information = Information::
where('accountnumber', '<>', '')->
where('product_id', '=', '28')->
with('products', 'tempwebline.webline')->
limit(1000)->
orderBy('date_added', 'desc')->
get();
}
return Datatables::of($information)
->editColumn('product_name', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
return $query_data->tempwebline->ProductName;
} else {
if (!empty($query_data->products)) {
return $query_data->products->product_name;
}
return "";
}
})
// ->setTotalRecords($information_count)
->editColumn('date_added1', function ($query_data) {
return $query_data->date_added;
})
->editColumn('insurance_startdate', function ($query_data) {
if ($query_data->insurance_startdate != '0000-00-00') {
$insurance_startdate = date('d-m-Y', strtotime($query_data->insurance_startdate));
} else {
$insurance_startdate = '';
}
return $insurance_startdate;
}) /*->editColumn('policy_number', function ($query_data)
{
if(strtoupper($query_data->is_webline_product) == 'NO'){
if(!empty($query_data->products)){
$policy_number = $query_data->products->policy_prefix.$query_data->policy_number;
}else{
$policy_number = "";
}
}elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$policy_number = $query_data->policy_number;
}else {
$policy_number = ' ';
}
return $policy_number;
*//*->editColumn('full_name', function ($query_data) {
return $query_data->fname." ".$query_data->lname;
})*/ ->editColumn('lead_source_field', function ($query_data) {
$lead_source_field = ['bi-app' => 'BestInsurance', 'tle-app' => 'Theleadexpert', 'dlet-app' => 'Discountlettings', '' => 'Direct'];
if ($query_data->lead_source_field != '' || $query_data->lead_source_field != 'Web Site') {
$result = $query_data->lead_source_field;
} elseif (isset($query_data->affid)) {
foreach ($lead_source_field as $key => $value) {
if ($key == $query_data->affid) {
$result = $value;
}
}
} else {
$result = $lead_source_field['bi-app'];
}
//
return $result;
})->editColumn('submitted_by', function ($query_data) {
$result = "";
if (!empty($query_data->created_id_by) && ($query_data->created_id_by != 0)) {
$created_user = User::find($query_data->created_id_by);
if (!empty($created_user)) {
if (!empty($created_user->branch)) {
$branch_name = $created_user->branch->branch_name;
} else {
$branch_name = "-";
}
$result = $created_user->profile->full_name . "/" . $branch_name;
}
} else {
$result = "Default/Default";
}
return $result;
})
->editColumn('rates', function ($query_data) {
if (strtoupper($query_data->is_webline_product) == 'NO') {
$premium = 'Reviewable';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$premium = $query_data->rates;
} else {
$premium = ' ';
}
return $premium;
})->editColumn('status', function ($query_data) {
if (!empty($query_data->cancellation_approve_date)) {
$current_date = Carbon::now();
$cancelled_date = Carbon::parse($query_data->cancellation_approve_date);
if ($current_date->lt($cancelled_date)) {
$status = 'To be cancelled on:' . $cancelled_date->format('Y-m-d') . ' Revert ';
} else {
$status = 'Cancelled ';
}
} elseif ($query_data->status == 1) {
$status = 'Approved ';
} elseif ($query_data->status == -1) {
$status = 'Submitted Rejected
';
}
return $status;
})->editColumn('payment', function ($query_data) {
if ($query_data->status != 0 && (Auth::user()->role == 1 || Auth::user()->role == 7 || Auth::user()->role == 8)) {
$payment = "";
if (empty($query_data->payment_date)) {
$payment .= "Payment Refund ";
} else {
return "";
}
})->editColumn('actions', function ($query_data) {
if (!empty($query_data->cancel_date)) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif ($query_data->product_id == Config::get('constant.BEST_ACCIDENT')) {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'NO') {
$action_result = '
Actions
Toggle Dropdown
';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$action_result = '
Actions
Toggle Dropdown
';
} else {
$action_result = '';
}
return $action_result;
})
->make(true);
}
/**
* Displays datatables front end view for incomplete leads
*
* @return \Illuminate\View\View
*/
public function incompleteLead() {
$subHome = 'Incomplete Leads List';
$subHomeLink = '/account/incomplete-leads';
//Breadcrumb Titles
$breadcrumb = [
'title' => 'Leads',
'subTitle' => 'Incomplete Leads List',
'home' => 'Leads',
'homeLink' => '#',
'subHome' => $subHome,
'subHomeLink' => $subHomeLink,
// 'subChildHome' => 'Vew leads',
'menuColor' => '#fff',
'menu' => 'incompleted-leads',
'MenuClass' => 'active open',
'SubMenuClass' => 'active',
];
return view('admin.leads.incomplete_leads', compact('breadcrumb'));
}
/**
* Process datatables ajax request for incomplete leads
*
* @return \Illuminate\Http\JsonResponse
*/
public static function incompleteLeadData() {
/* Normal products */
$user = Auth::user();
if ($user->role == 3) {
$affliate_admin_user = $user;
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
$information = Information::where('accountnumber', '')
->whereIn('created_id_by', $broker_users)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'asc');
/*->get();*/
} elseif ($user->role == 6) {
//branch manager
//branch manager
$branch_id = $user->branch->id;
$broker_users = User::where('role', 3)
->where('branch_id', $branch_id)
->pluck('id')->toArray();
$broker_users = array_merge($broker_users, [$user->id]);
$information = Information::where('accountnumber', '')
->whereIn('created_id_by', $broker_users)
->with('products', 'tempwebline.webline')
->orderBy('date_added', 'asc');
/*->get();*/
} elseif (($user->role == 4) || ($user->role == 5)) {
//Affliate admin or Ho user
$affliate_admin_user = Auth::user();
if ($user->role == 5) {
$affiliate_id = $affliate_uid = $affliate_admin_user->uid;
$branches = Branch::where('branch_affliate_admin_uid', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
} else {
$affiliate_id = $affliate_admin_user->affliate_user->affiliate_id;
$branches = Branch::where('branch_affliate_admin_id', $affiliate_id)->pluck('id');
$brokers_and_branch_admin_user_ids = User::whereIn('branch_id', $branches)->pluck('id')->toArray();
//including affliate admin
$broker_users = array_merge($brokers_and_branch_admin_user_ids, [$affliate_admin_user->id]);
}
$information = Information::where('policy_number_full', NULL)
->whereIn('created_id_by', $broker_users)
->with('products', 'tempwebline.webline')
->orderBy('id', 'desc');
/*->get();*/
} else {
$information = Information::where('policy_number_full',NULL)
// ->where('information.is_webline_product','Yes')
->with('products', 'tempwebline.webline')
->orderBy('id', 'desc');
/*->get();*/
}
//
return Datatables::of($information)
->editColumn('product_name', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
return $query_data->tempwebline->ProductName;
} else {
if (!empty($query_data->products)) {
return $query_data->products->product_name;
}
return "";
}
})->editColumn('insurer', function ($query_data) {
if ($query_data->is_webline_product == 'Yes') {
if (!empty($query_data->tempwebline)) {
if (!empty($query_data->tempwebline->webline)) {
return $query_data->tempwebline->webline->insurer;
} else {
return "";
}
} else {
return "";
}
} else {
return $query_data->insurer;
}
})
->editColumn('created_date', function ($query_data) {
$application_date = date('d-m-Y H:i:s', strtotime($query_data->date_added));
return $application_date;
})->editColumn('insurance_startdate', function ($query_data) {
if ($query_data->insurance_startdate != '0000-00-00') {
$insurance_startdate = date('d-m-Y', strtotime($query_data->insurance_startdate));
} else {
$insurance_startdate = '';
}
return $insurance_startdate;
})->editColumn('policy_number', function ($query_data) {
if (strtoupper($query_data->is_webline_product) == 'NO') {
$policy_number = "";
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$policy_number = "";
} else {
$policy_number = ' ';
}
return $policy_number;
})->editColumn('lead_source_field', function ($query_data) {
$lead_source_field = ['bi-app' => 'BestInsurance', 'tle-app' => 'Theleadexpert', 'dlet-app' => 'Discountlettings', '' => 'Direct'];
if ($query_data->lead_source_field != '' || $query_data->lead_source_field != 'Web Site') {
$result = $query_data->lead_source_field;
} elseif (isset($query_data->affid)) {
foreach ($lead_source_field as $key => $value) {
if ($key == $query_data->affid) {
$result = $value;
}
}
} else {
$result = $lead_source_field['bi-app'];
}
//
return $result;
})->editColumn('submitted_by', function ($query_data) {
$result = "";
if (!empty($query_data->created_id_by) && ($query_data->created_id_by != 0)) {
$created_user = User::find($query_data->created_id_by);
if (!empty($created_user)) {
if (!empty($created_user->branch)) {
$branch_name = $created_user->branch->branch_name;
} else {
$branch_name = "-";
}
$result = $created_user->profile->full_name . "/" . $branch_name;
}
} else {
$result = "Default/Default";
}
return $result;
})->editColumn('rates', function ($query_data) {
if (strtoupper($query_data->is_webline_product) == 'NO') {
$premium = 'Reviewable';
} elseif (strtoupper($query_data->is_webline_product) == 'YES') {
$premium = $query_data->rates;
} else {
$premium = ' ';
}
return $premium;
})->editColumn('status', function ($query_data) {
if ($query_data->status == '0' || $query_data->status == '1' || $query_data->status == '') {
$status = 'Yet to connect
';
} else {
$status = '' . $query_data->status . '
';
}
return $status;
})->editColumn('view', function ($query_data) {
if (strtoupper($query_data->is_webline_product) == 'NO' || empty($query_data->is_webline_product)) {
$view = 'Assign ';
}
return $view;
})->editColumn('delete', function ($query_data) {
$status = 'incompleted';
$delete = ' renewal_date)back();
//\Flash::error($error_message);
return redirect()->back();
}
}
else
{
$ins_start_date_to_cancel_yr = Carbon::parse($information->insurance_startdate);
if ($information->mms_scheme == "RBS128" || $information->mms_scheme == "RBS129" || $information->mms_scheme == "RBS130") {
$max_startdate_to_test=Carbon::parse($information->insurance_startdate)->addMonths(2);
}
else
{
$max_startdate_to_test=Carbon::parse($information->insurance_startdate)->addMonths(1);
}
if($max_startdate_to_testinsurance_startdate)back();
}
}
//exit;
// $ins_start_date_to_cancel_yr = Carbon::parse($information->insurance_startdate);
// $ins_start_date_to_cancel_yr->year = date('Y');
$raf_cancel_date=$ins_start_date_to_cancel_yr;
if ($information->mms_scheme == "RBS128" || $information->mms_scheme == "RBS129" || $information->mms_scheme == "RBS130") {
$raf_cancel_date->addMonths(1);
}
//$information->cancel_date = $ins_start_date_to_cancel_yr;
} else {
$CancelFromPaidUpTo = true;
$raf_cancel_date=$cancel_date;
}
echo $raf_cancel_date;
$information->cancellation_approve_date = "$request->cancellation_approve_date";
//echo $cancel_date;
//echo $request->cancellation_approve_date;
// dd($information);
// Cancelling the loan at red apple finance end and updating the required tables
//print_r($information);
//exit;
$i = Information::with('RAFCustomerInfo')->find($lead_id);
// dd($i->RAFCustomerInfo);
if (!empty($i->RAFCustomerInfo->id)) {
$result_data = RAFController::CancelCustomer($i->RAFCustomerInfo->id, $information, $CancelFromPaidUpTo,$raf_cancel_date);
if ($result_data['http_code'] != 200) {
$error_message = json_encode($result_data['response']);
\Flash::error($error_message);
return redirect()->back();
}
}
//dd($result_data);
//$information->cancellation_approve_date = $request->cancellation_approve_date;
$information->customer_status="Cancelled";
$information->save();
/*$activity = Activity::all()->last();
$activity->description = "cancel";
$activity->save();*/
$version = DB::table('log_information')
->select('version as last_version')
->where('application_id', $lead_id)
->orderBy('version', 'desc')
->first();
if (empty($version)) {
$version = 0;
} else {
$version = $version->last_version;
}
// Adding log information
$logInfoId = DB::table('log_information')
->insertGetId([
'application_id' => $information->id,
'product_id' => $information->product_id,
'title' => $information->title,
'fname' => $information->fname,
'lname' => $information->lname,
'dob' => $information->dob,
'emp_status' => $information->emp_status,
'occupation' => $information->occupation,
'employer_name' => $information->employer_name,
'building' => $information->building,
'premiseName' => $information->premiseName,
'address1' => $information->address1,
'address2' => $information->address2,
'address3' => $information->address3,
'address4' => $information->address4,
'postcode' => $information->postcode,
'formattedPO' => $information->formattedPO,
'postaltown' => $information->postaltown,
'county' => $information->county,
'email' => $information->email,
'telephone' => $information->telephone,
'mobile' => $information->mobile,
'marketingOptOut' => $information->marketingOptOut,
'under_writing_q1' => $information->under_writing_q1,
'under_writing_ans' => $information->under_writing_ans,
'under_writing_accept' => $information->under_writing_accept,
'insurance_startdate' => $information->insurance_startdate,
'transfer' => $information->transfer,
'current_provider' => $information->current_provider,
'current_policy_date' => $information->current_policy_date,
'typeofcover' => $information->typeofcover,
'loan_to_pay' => $information->loan_to_pay,
'monthlycommitment' => $information->monthlycommitment,
'monthlygrossincome' => $information->monthlygrossincome,
'mortgagesalary' => $information->mortgagesalary,
'mortgage' => $information->mortgage,
'salary' => $information->salary,
'age' => $information->age,
'monthlybenefit' => $information->monthlybenefit,
'monthlycost' => $information->monthlycost,
'cover' => $information->cover,
'cover_term' => $information->cover_term,
'accept' => $information->accept,
'accountname' => $information->accountname,
'accountname2' => $information->accountname2,
'accountnumber' => $information->accountnumber,
'sortcode' => $information->sortcode,
'iban' => $information->iban,
'bank' => $information->bank,
'bankbic' => $information->bankbic,
'branch' => $information->branch,
'branchbic' => $information->branchbic,
'branch_address' => $information->branch_address,
'town' => $information->town,
'bank_postcode' => $information->bank_postcode,
'bank_phone' => $information->bank_phone,
'directdebits' => $information->directdebits,
'preferreddate' => $information->preferreddate,
'affid' => $information->affid,
'ip' => $information->ip,
'date_added' => $information->date_added,
'time_added' => $information->time_added,
'guid' => $information->guid,
'status' => $information->status,
'comment' => $information->comment,
'mail_send' => $information->mail_send,
'mms_senddate' => $information->mms_senddate,
'mms_sendmonth' => $information->mms_sendmonth,
'subscription' => $information->subscription,
'formtype' => $information->formtype,
'typeofprotection' => $information->typeofprotection,
'excessperiod' => $information->excessperiod,
'insurer' => $information->insurer,
'smoker' => $information->smoker,
'life_cover' => $information->life_cover,
'life_cover_term' => $information->life_cover_term,
'life_cover_type' => $information->life_cover_type,
'life_cover_premium_type' => $information->life_cover_premium_type,
'CIC' => $information->CIC,
'lead_from' => $information->lead_from,
'lead_source_field' => $information->lead_source_field,
'benefit_period' => $information->benefit_period,
'duration' => $information->duration,
'duration_year' => $information->duration_year,
'duration_month' => $information->duration_month,
'contractor_deirectdebitref' => $information->contractor_deirectdebitref,
'contractor_id' => $information->contractor_id,
'policy_number' => $information->policy_number,
'policy_number_full' => $information->policy_number_full,
'mta_updated' => $information->mta_updated,
'renew_updated' => '0',
'insurance_enddate' => $information->insurance_enddate,
'version' => $version + 1,
'edit_updated' => $information->edit_updated,
'mta_date' => $information->mta_date,
'cancel_code' => $information->cancel_code,
'cancel_reason' => $information->cancel_reason,
'reason' => $information->cancel_reason,
'cancel_date' => $information->cancel_date,
'cancellation_approve_date' => $request->cancellation_approve_date,
'action' => 'CANCEL',
'active_loan_id' => $information->active_loan_id,
]);
if (!empty($i->RAFCustomerInfo->id)) {
// $raf_customer_id = $result_data['response']['CustomerId'];
$raf_docs = RAFLoanDocuments::where('CustomerId', $i->RAFCustomerInfo->id)
->where('action_type', "cancel")
->whereNull('log_info_id')
->get();
foreach ($raf_docs as $raf_doc) {
$raf_doc->log_info_id = $logInfoId;
$raf_doc->save();
}
}
// saving cancel file
$cancel_filename = $this->fileuploader->saveCancelPdf($logInfoId);
$update_info = DB::table('information')
->where('id', $information->id)
->update(['cancel_pdf' => $cancel_filename]);
$table_info = DB::table('log_information')
->where('id', $logInfoId)
->update(['cancel_pdf' => $cancel_filename]);
$file_path = $email_data['cancel_filename'] = $cancel_filename;
\Flash::success('Cacnellation completed successfully');
return redirect('account/leads?status=completed');
//end of saving file
// return redirect()->back();
if (isset($logInfoId) &&
empty($request->get('send_mail'))
) {
//echo $file_path;
//exit;
// $file_path = public_path().$file_path;
if ($request->ajax()) {
return Response::json([
'logInfoId' => $logInfoId,
]);
} else {
return response()->download($file_path);
}
} elseif (!empty($request->get('send_mail'))) {
$status = $this->helper->sendEmailWithCancelDocuemnts($logInfoId, $request);
if ($status) {
if ($request->ajax()) {
return response()->json(['status' => 'success', 'message' => 'Email sent successfully']);
} else {
flash()->sucess("Email sent successfully");
return rediret()->back();
}
} else {
if ($request->ajax()) {
return response()->json(['status' => 'error', 'message' => "Something went wrong in processing request"]);
} else {
flash()->error("Something went wrong in processing request");
return rediret()->back();
}
}
}
}
/* public function insertMailTracker($data)
{
$mailtracker = new MailTracker;
$mailtracker->mt_lead_id = $data['mt_lead_id'];
$mailtracker->mt_cc_mails = $data['mt_cc_mails'];
$mailtracker->mt_bcc_mails = $data['mt_bcc_mails'];
$mailtracker->mt_from_mail = $data['mt_from_mail'];
$mailtracker->mt_sent_status = $data['mt_sent_status'];
$mailtracker->mt_contents = $data['mt_contents'];
$mailtracker->mt_type = $data['mt_type'];
$mailtracker->mt_created_u_id = \Auth::user()->id;
$mailtracker->save();
}
public function getCancelDownload(Request $request)
{
$this->leads->download($request);
*/
public function getRevert($lead_id) {
$information = Information::find($lead_id);
$information->cancel_code = null;
$information->cancel_reason = null;
$information->cancel_date = null;
$information->cancellation_approve_date = null;
$information->customer_status ="Reverted";
$information->save();
$user_details=UserInfo::where('user_id',Auth::user()->id)->first();
//$email_data['cc'] = $request->cc_emails;
//$email_data['bcc'] = $request->bcc_emails;
$email_data['subject'] = "Admin Panel Revert";
$email_data['from'] = "advisor@bestinsurance.co.uk";
$email_data['email'] = "adminpanelrevert@bestinsurance.co.uk";
$email_data['first_name'] = $information->fname;
$email_data['last_name'] = $information->lname;
$email_data['ufirst_name'] = $user_details->first_name;
$email_data['ulast_name'] = $user_details->last_name;
$email_data['title'] = $information->title;
$email_data['policy_number_full'] = $information->policy_number_full;
$view = View::make('admin.mail.mail-revert', ['first_name' => $email_data['first_name'], 'last_name' => $email_data['last_name'], 'ufirst_name' => $email_data['ufirst_name'], 'ulast_name' => $email_data['ulast_name'],'policy_number_full' => $email_data['policy_number_full']]);
try {
$mailSuccess = Mail::send(['html' => 'admin.mail.mail-revert'], $email_data, function ($message) use ($email_data) {
$message->from($email_data['from']);
$message->to($email_data['email'])
->subject($email_data['subject']);
if (!empty($email_data['cc'])) {
$message->cc($email_data['cc']);
}
if (!empty($email_data['bcc'])) {
$message->bcc($email_data['bcc']);
}
});
// return true;
} catch (Exception $e) {
//return false;
}
\Flash::success('Reverted successfully');
return redirect()->back();
}
public function updateCustomerStatus(Request $request) {
echo $request->customer_status;
$information = Information::find($request->id);
$information->customer_status = $request->customer_status;
$information->save();
\Flash::success('Customer Status updated successfully');
//return redirect()->back();
}
public function getPayment($lead_id) {
$view = view('modals.payment_window', compact('lead_id'));
$contents = (string) $view;
return $contents = $view->render();
}
public function postPayment(Request $req) {
$lead_id = $req->lead_id;
$information = Information::find($lead_id);
$information->payment_date = $req->payment_date;
$information->save();
\Flash::success('Payment added successfully');
return redirect()->back();
}
public function getRefund($lead_id) {
$view = view('modals.refund_window', compact('lead_id'));
$contents = (string) $view;
return $contents = $view->render();
}
public function postRefund(Request $req) {
$lead_id = $req->lead_id;
$information = Information::find($lead_id);
$information->refund_date = $req->refund_date;
$information->refund_amount = $req->refund_amount;
$information->save();
\Flash::success('Refund added successfully');
return redirect()->back();
}
/**
* [MMS leads data : export
* @param string $value [description]
* @return [type] [description]
*/
public static function mmsreportsExportToExcel($value = '') {
$mms_simple_policies = Information::where('status', 1)
//->whereIn('policy_number_full',['MMS/SPBST/05A10314','MMS/SPBST/05A11920'])
// ->where('policy_number_full','MMS/SPBST/05A9708')
->whereNotIn('policy_number_full',['MMS/SPBST/05A11056','MMS/SPBST/05A10939','MMS/SPBST/05A10884','MMS/SPBST/05A10867','MMS/SPBST/05A10773A','MMS/SPBST/05A10770','MMS/SPBST/05A10645','MMS/SPBST/05A10510','MMS/SPBST/05A10446','MMS/SPBST/A10352/1','MMS/SPBST/05A1031','MMS/SPBST/05A126','MMS/SPBST/05A12519','MMS/SPBST/05A12375','MMS/SPBST/05A12290','MMS/SPBST/05A12283','MMS/SPBST/05A12280','MMS/SPBST/05A12227','MMS/SPBST/05A12221','MMS/SPBST/05A12128','MMS/SPBST/05A12104','MMS/SPBST/05A12103','MMS/SPBST/05A12097','MMS/SPBST/05A12021','MMS/SPBST/05A11929','MMS/SPBST/05A11895','MMS/SPBST/05A11746','MMS/SPBST/05A11553','MMS/SPBST/05A11443','MMS/SPBST/05A978','MMS/SPBST/05A9667','MMS/SPBST/05A958','MMS/SPBST/05A708','MMS/SPBST/05A519','MMS/SPBST/05A518','MMS/SPBST/05A442','MMS/SPBST/6005A352','MMS/SPBST/05A236-2','MMS/SPBST/05A177-2','MMS/SPBST/05A130','MMS/SPBST/05A11090','MMS/SPBST/05A11161','MMS/SPBST/05A11282','MMS/SPBST/05A11007','MMS/SPBST/05A10839','MMS/SPBST/05A10812','MMS/SPBST/05A10715','MMS/SPBST/05A10441','MMS/SPBST/05A10432','MMS/SPBST/05A11483','MMS/SPBST/05A9940','MMS/SPBST/05A9631','MMS/SPBST/05A11110'])
->where('product_id','26')
->where('cancel_date', NULL)
// ->limit(1)
->get();
// dd($mms_simple_policies);
foreach($mms_simple_policies as $key => $value)
{
//echo $policy['id']."