public function postReactivatedeal(Request $request)
 {
     $reactivateleadid = Input::get('leadid');
     $recdeal = leadsheet::where('id', $reactivateleadid)->get();
     // dd($recdeal);
     foreach ($recdeal as $deald) {
         # code...
     }
     $c = new leadsheet();
     $dateValue = date('d-m-Y');
     $time = strtotime($dateValue);
     $year = date("Y", $time);
     if ($deald['leadcat'] == 'Vendors') {
         $leadcode = 'VL';
         $count = leadsheet::where('leadcat', '=', 'Vendors')->count();
         $counti = str_pad($count + 1, 5, '0', STR_PAD_LEFT);
         $leadc = $leadcode . '' . $year . '' . $counti;
         // dd($leadc);
     }
     $c->company_name = $deald['company_name'];
     $c->country = $deald['country'];
     $c->website = $deald['website'];
     $c->leadcode = $leadc;
     $c->leadcat = $deald['leadcat'];
     $c->product_category = $deald['product_category'];
     $c->product_sub_category = $deald['product_sub_category'];
     $c->phone = $deald['phone'];
     $c->otheroffice = $deald['otheroffice'];
     $c->fax = $deald['fax'];
     $c->partnership_package_name = $deald['partnership_package_name'];
     $c->partnership_package_value = $deald['partnership_package_value'];
     $c->dmname = $deald['dmname'];
     $c->dmdesignation = $deald['dmdesignation'];
     $c->dmphone = $deald['dmphone'];
     $c->dmmobile = $deald['dmmobile'];
     $c->dmemail = $deald['dmemail'];
     $c->dmaltnumber = $deald['dmaltnumber'];
     $c->infname = $deald['infname'];
     $c->infdesignation = $deald['infdesignation'];
     $c->infphone = $deald['infphone'];
     $c->infmobile = $deald['infmobile'];
     $c->infemail = $deald['infemail'];
     $c->infaltnumber = $deald['infaltnumber'];
     $c->specname = $deald['specname'];
     $c->specdesignation = $deald['specdesignation'];
     $c->specphone = $deald['specphone'];
     $c->spemobile = $deald['spemobile'];
     $c->speemail = $deald['speemail'];
     $c->spealtnumber = $deald['spealtnumber'];
     $c->remarks = $deald['remarks'];
     $c->competitors = $deald['competitors'];
     $c->empid = $deald['empid'];
     $c->empname = $deald['empname'];
     $c->callback = '0';
     $c->followup = '0';
     $c->reassignedId = '0';
     $c->save();
     $request->session()->flash('alert-success', 'Lead Has Been inserted Successfully');
     return redirect('initiator/leadsheet');
     //
 }
 public function postGenerateleadsheet(LeadsheetRequest $request)
 {
     $data = Input::get();
     $c = new leadsheet();
     $eid = Input::get('emp_id');
     $result = explode('|', $eid, 2);
     $emid = trim($result[0]);
     $ename = trim($result[1]);
     $variable = Input::get('empdept');
     $dateValue = date('d-m-Y');
     $time = strtotime($dateValue);
     $year = date("Y", $time);
     if ($variable == 'Marketing') {
         $leadcode = 'ML';
         $count = leadsheet::where('leadcat', '=', 'Marketing')->count();
         $counti = str_pad($count + 1, 5, '0', STR_PAD_LEFT);
         $leadc = $leadcode . '' . $year . '' . $counti;
         // dd($leadc);
     }
     $c->company_name = $data['company_name'];
     $c->country = $data['country'];
     $c->website = $data['website'];
     $c->leadcode = $leadc;
     $c->leadcat = $data['empdept'];
     $c->product_category = $data['product_category'];
     $c->product_sub_category = $data['product_sub_category'];
     $c->phone = $data['boardline'];
     $c->otheroffice = $data['office_number'];
     $c->fax = $data['fax'];
     $c->partnership_package_name = $data['pname'];
     $c->partnership_package_value = $data['pvalue'];
     $c->dmname = $data['dmname'];
     $c->dmdesignation = $data['dmdesignation'];
     $c->dmphone = $data['dmphone'];
     $c->dmmobile = $data['dmmobile'];
     $c->dmemail = $data['dmemail'];
     $c->dmaltnumber = $data['dmaltnumber'];
     $c->infname = $data['infname'];
     $c->infdesignation = $data['infdesignation'];
     $c->infphone = $data['infphone'];
     $c->infmobile = $data['infmobile'];
     $c->infemail = $data['infemail'];
     $c->infaltnumber = $data['infaltnumber'];
     $c->specname = $data['specname'];
     $c->specdesignation = $data['specdesignation'];
     $c->specphone = $data['specphone'];
     $c->spemobile = $data['spemobile'];
     $c->speemail = $data['speemail'];
     $c->spealtnumber = $data['spealtnumber'];
     $c->remarks = $data['remarks'];
     $c->competitors = $data['competitors'];
     $c->empid = $emid;
     $c->empname = $ename;
     $c->callback = '0';
     $c->followup = '0';
     $c->reassignedId = '0';
     $c->save();
     $request->session()->flash('alert-success', 'Lead Has Been inserted Successfully');
     return redirect('marketing/leadsheet');
     //
 }