subDay(1)->startOfDay()->toDateTimeString(); $date_to = Carbon::now()->subDay(1)->endOfDay()->toDateTimeString(); $customer = Customer::whereBetween('created_at',[$date_from,$date_to])->get(); foreach($customer as $info){ $links = Link::select('link')->where('custId',$info['id'])->get(); array_push($link,$links); } return response()->json($link); // return response($info); // return response()->json(); }); Route::middleware('auth')->group(function(){ Route::get('/welcome', function () { $disclaimer = DB::table('policy')->select('content')->first(); return view('welcome')->with(['disclaimer' => $disclaimer]); }); Route::get('/information',[InformationController::class, 'index'])->name('cust.reg'); Route::get('/report', [AdminController::class, 'reports']); Route::get('/blank', [AdminController::class, 'reportIndex']); Route::get('or_masterfile', [AdminController::class,'orDashboard']); Route::get('get/or_masterfile', [AdminController::class,'orReport']); Route::get('customers_masterfile', [AdminController::class,'customerDashboard']); Route::get('get/customers_masterfile', [AdminController::class,'customerReport']); Route::get('dealers_masterfile', [AdminController::class,'dealerDashboard']); Route::get('get/dealers_masterfile', [AdminController::class,'dealerReport']); Route::get('sms_masterfile', [AdminController::class,'smsDashboard']); Route::get('get/sms_masterfile', [AdminController::class,'smsReport']); Route::get('trs_masterfile', [AdminController::class,'transactionDashboard']); Route::get('get/transactions_masterfile', [AdminController::class,'transactionReport']); Route::get('dealerList', [AdminController::class, 'dealerList']); Route::get('user_management', [AdminController::class,'userMgmnt'])->name('admin.user_management'); Route::get('/users/fetchall',[AdminController::class,'getUserAll']); Route::get('/dealers/fetchall',[AdminController::class,'getDealerAll']); Route::get('/dealers/{id}',[AdminController::class,'getDealer']); Route::post('/dealer/update/{id}',[AdminController::class, 'updateDealer']); Route::post('/dealer/delete/{id}',[AdminController::class, 'deleteDealer']); Route::get('/sms/fetchall',[AdminController::class, 'getSMS']); Route::get('/transaction/fetchall',[AdminController::class, 'getTransactionsAll']); Route::get('/get/transaction/{id}',[AdminController::class,'getTransactionDetails']); Route::post('/update-user/{id}',[AdminController::class, 'updateUserRole']); Route::post('/update-disclaimer',[AdminController::class,'storePolicy']); Route::post('logout',[InformationController::class,'logout'])->name('admin.logout'); Route::post('update-profile',[AdminController::class,'update']); Route::get('admin-dashboard',[AdminController::class,'dashboard']); Route::post('get-customer-frequency',[AdminController::class, 'getCustomerFrequency']); Route::get('forecast',[CustomerProjectionController::class, 'forecast']); }); Route::get('/thankyou/{token}/{id}',[InformationController::class, 'thankyou']); // Route::get('/import',[InformationController::class, 'import']); Route::post('/create-user',[InformationController::class,'create']); Route::get('/get-customer',[InformationController::class,'customerSelect2']); Route::post('/import-details',[InformationController::class,'importDetails']); Route::post('/verify',[ValidationController::class,'validateTop']); Route::get('/fetch-image',[ValidationController::class,'fetchImage']); Route::post('/verify-transaction',[ValidationController::class,'validateTransaction']); Route::get('/dashboard',[AdminController::class,'adminDashboard']); // Route::get('/customer/{custId}/transaction/{transId}/verify/token/{token}', function(){ // return view('verify.verify'); // }); Route::get('/verify/token/{token}/q/{q}', [Validationcontroller::class,'verify']); Route::get('/setup', function(){ return view('auth.setup'); }); Route::get('/', function(){ return view('auth.login'); })->name('/'); Route::post('login-dealer',[InformationController::class,'login']); Route::post('feedback',[InformationController::class,'feedback']); // Route::get('signup', [InformationController::class,'adminRegister'])->name('admin.login'); // admin registration // Route::post('signup-admin', [InformationController::class,'importDetails'])->name('admin.signin');