name('password.request'); Route::post('password/reset', 'Auth\ResetPasswordController@postReset')->name('password.reset'); Route::get('/po-approval', function(){ $approvedInvoices = InvoiceStatuses::where(function($q) { $q->where('status', 'approve') ->orWhere('status', 'request_change'); })->distinct()->get(['invoice_id'])->pluck('invoice_id'); $invoices = InvoiceStatuses::whereNotIn('invoice_id', $approvedInvoices)->get(); echo "

Total PO Pending Approval:".count($invoices)."

"; foreach ($invoices as $invoice){ echo "".$invoice->invoice->booking->id."
"; } })->name('po.approval'); Route::get('/old-invoices', function(){ $bookings = \App\Booking::where('status', 6)->where('user_id', '!=', 1)->whereHas('purchaseOrder', function($q){ $q->whereNotNull('image_path'); })->get(); $months = $bookings->groupBy(function($item) { return $item->created_at->format('Y-m'); }); echo "

Total pending invoices:".count($bookings)."

"; foreach ($months as $month => $bookings) { echo "

".$month."(".count($bookings).")


"; foreach ($bookings as $booking) { echo "".$booking->id." date: ".$booking->created_at."
"; } echo "


"; } })->name('invoice.old'); Route::group(['middleware' => ['role:admin']], function() { Route::get('bulkBookings', function () { return view('booking.bulkBooking'); })->name('booking.bulk.form'); Route::post('/bulkBookings', 'BulkBookingController@index')->name('booking.bulk'); }); Route::get('{path}', 'WelcomeController@index')->where('path', '(.*)'); Auth::routes(); //Route::get('/home', 'WelcomeController@index')->name('home'); // // // //create data Route::get('/announcement/create', 'Announcement\CreateAnnouncementController@create')->name('announcement.create'); //store data Route::post('/announcement/post', 'Announcement\PostAnnouncementController@store')->name('announcement.post'); //list all data Route::get('/announcements/view', 'Announcement\ViewAnnouncementsController@index')->name('announcements.view'); //list a data Route::get('/announcement/{id}/view', 'Announcement\ViewAnnouncementController@show')->name('announcement.view'); //edit data Route::get('/announcement/{id}/edit', 'Announcement\EditAnnouncementController@edit')->name('announcement.edit'); //update data Route::put('/announcement/{id}/update', 'Announcement\UpdateAnnouncementController@update')->name('announcement.update'); //delete data Route::delete('/announcement/{id}/delete', 'Announcement\DeleteAnnouncementController@destroy')->name('announcement.delete'); // // // //Route::get('/man', 'man');