vendredi 23 septembre 2016

Export/Import Data with total records count using Laravel

Hello Friends I am trying to export data from database and after that show count of total exported records below export button right now Export is working fine and I am able to get count also but on view page it's not coming.

Problem: if Export is working then count is not showing on view page

Blade File(Export&Import Excel):

<a href=""><button class="btn btn-primary">D-Square Export CSV</button></a>
<p class="last-run"><b>Last Run:</b> </p> 

Controller:

public function ImportExport()
{
    return view('admin.ImportExport', ['runtime' => '']);
}
public function downloadCsvD2S($type)
{
    $labors=DB::table('labors')->get();

    $data = array();
    foreach ($labors as $result) {
         $temp = (array)$result;  
         $data[] = $temp;
    }
   Excel::create('labors_'.date('m-d-y'), function($excel) use ($data) {
        $excel->sheet('mySheet', function($sheet) use ($data)
        {
            $sheet->fromArray($data);
        });
    })->download($type)->with(array());
   // Here Trying to return count when user clicks export button
    return view('admin.ImportExport', ['runtime' => date('m/d/y h:i  A').'&nbsp;'.count($labors).'&nbsp;'.'Records']);
}

Routes:

Route::get('ImportExport', 'ImportExportController@ImportExport');
Route::get('downloadCsvD2S/{type}', 'ImportExportController@downloadCsvD2S');



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire