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'); // }