<?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="";
		$varid=Input::get('varid');
		$mobile=Input::get('mobile');
		$client=Input::get('client');
		$clientcode=Input::get('clientcode');
		$firstname=Input::get('firstname');
		$product = Input::get("product");
		$customer_name = Input::get("customer_name");
		$mobile_number = Input::get("mobile_number");
		$city = Input::get("city");
		$state = Input::get("state");
		$agent_memo = Input::get("agent_memo");
		$customer_memo = Input::get("customer_memo");
		$remarks = Input::get("remarks");
		$transfer_memo = Input::get("transfer_memo");
		$address=Input::get("address");
    	$user_id=Auth::user()->id;
		$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[]="product='$product'";
		$setracingCutomer[]="customer_name='$customer_name'";
		$setracingCutomer[]="mobile_number='$mobile_number'";
		$setracingCutomer[]="city='$city'";
		$setracingCutomer[]="state='$state'";
		$setracingCutomer[]="agent_memo='$agent_memo'";
		$setracingCutomer[]="customer_memo='$customer_memo'";
		$setracingCutomer[]="remarks='$remarks'";
		$setracingCutomer[]="transfer_memo='$transfer_memo'";
		$setracingCutomer[]="address='$address'";
		$setracingCutomer[]="mobile='$mobile'";
		$setracingCutomer[]="client='$client'";
		$setracingCutomer[]="clientcode='$clientcode'";
		$setracingCutomer[]="firstname='$firstname'";
		$setracingCutomer[]="user_id='$user_id'";
		$setracingCutomer[]="call_id='$call_id'";
		$setracingCutomer[]="record_id='$varid'";

		$setracingCut=implode(",",$setracingCutomer);

		$leadFormrecordid = DB::table("lead_form")->where("record_id","=",$varid)->select('record_id')->first();
		if($leadFormrecordid)
		{
			$record_id=$leadFormrecordid->record_id;
		}
	
		if($call_status=='ANSWER' && $crm_id==$varid)
		{
          if($record_id==$varid)
    		{
    			DB::statement("update lead_form set $setracingCut,updated_at=now() where record_id='$varid'");
			}
			else
    		{
    			DB::statement("insert into lead_form set $setracingCut,created_at=now()");
    		}
		}else
		{
			return "<script>simpleNotification('error','topRight','Please Get on call first');</script>";
		}
    	
	
		return "<script>simpleNotification('success','topRight','Customer Details Saved Successfully');</script>";
	}

}