function onGenerateExcel() {
try{
$items = post();
$record_id=$items['id'];
$queries = Db::table('trip')
->select('trip.id as trips_id','trip.unique_id as unique_id','trip.date_start as date_start','trip.date_end as date_end','products_orders.status as status', 'uemura_locations_cities.city_name as city_name','users.name as names','products_orders.invoice_number as invoice_number','trip.created_at as created_at')
->leftJoin('users', 'trip.user_id', '=', 'users.id')
->leftJoin('uemura_locations_cities', 'trip.city_id', '=', 'uemura_locations_cities.id')
->leftJoin('products_orders', 'trip.id', '=', 'products_orders.trip_id')
->where('trip.id', '=', $record_id)
->get();
//print_r($queries); die('okay');
foreach($queries as $data) {
$tripid = $data->trips_id;
$uniqueid = $data->unique_id;
$datestart = $data->date_start;
$dateend = $data->date_end;
$status = $data->status;
$cityname = $data->city_name;
$names = $data->names;
$invoicenumber = $data->invoice_number;
$createdat = $data->created_at;
}
$data = [
'trips_id' => $tripid,
'unique_id' => $uniqueid,
'date_start' => $datestart,
'date_end' => $dateend,
'status' => $status,
'city_name' => $cityname,
'names' => $names,
'invoice_number' => $invoicenumber,
'created_at' => $createdat
];
$excel->sheet('Sheet', function($sheet) {
$sheet->fromModel($data);
});
}
catch (Exception $e) { Flash::error($e->getMessage()); }
}