/
home
/
sjslayjy
/
public_html
/
devlok
/
app
/
Http
/
Controllers
/
Upload File
HOME
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; class ImportMasterController extends Controller { public function importSale(Request $request) { $response = array(); $d=[]; $d['sale_detailes']=\App\SaleDetail::whereDate('created_at',date('Y-m-d'))->get(); if($request->isMethod('POST')) { $validator = \Validator::make($request->all(), array( 'sale_file' =>'required' ) ); if($validator->fails()) { return redirect('/import/sales')->with('error','Please Select excel file.'); }else{ $extension = \File::extension($request->file('sale_file')->getClientOriginalName()); if ($extension == "xlsx" || $extension == "xls") { $import = new \App\Imports\SalesImport(); $data = \Excel::import($import, $request->file('sale_file')); $datas = \app\SaleDetail::all(); // dd($datas); // dd('stop file'); // dd($data); return redirect('/import/sales')->with(['message'=>'Data Imported Successfully']); }else{ return redirect('/import/sales')->with('error','Only xlsx and xls file type allowed.'); } } } return view('dashboard.import.import-sale',$d); } public function importRemit(Request $request) { $response = array(); $d=[]; $d['remits']=\App\Remit::whereDate('created_at',date('Y-m-d'))->get(); if($request->isMethod('POST')) { $validator = \Validator::make($request->all(), array( 'remit_file' =>'required' ) ); if($validator->fails()) { return redirect('/import/remits')->with('error','Please Select excel file.'); }else{ $extension = \File::extension($request->file('remit_file')->getClientOriginalName()); if ($extension == "xlsx" || $extension == "xls") { $import = new \App\Imports\RemitsImport(); $data = \Excel::import($import, $request->file('remit_file')); $datas = \app\Remit::all(); // dd($datas); // dd('stop file'); // dd($data); return redirect('/import/remits')->with(['message'=>'Data Imported Successfully']); }else{ return redirect('/import/remits')->with('error','Only xlsx and xls file type allowed.'); } } } return view('dashboard.import.import-remit',$d); } }