public function index() { $expenses = Expense::where('office', '=', '2')->orderBy('paid_on', 'desc')->get(); $payments = Payment::orderBy('paid_on', 'desc')->get(); // \Auth::user()->name; //get name of Auth user return view('expenses.index', compact('expenses', 'payments')); }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $expensesss = Expense::where('project_id', '=', 0)->first(); $expensess = Expense::where('project_id', '=', 0)->orderBy('paid_on', 'desc')->get(); $clients = Client::orderBy('created_at', 'desc')->get(); $projects = Project::orderBy('created_at', 'desc')->get(); $expenses = Expense::where('project_id', '>', 0)->orderBy('paid_on', 'desc')->get(); $payments = Payment::orderBy('created_at', 'desc')->get(); $hours = Hour::where('amount_paid', '<', 0)->orderBy('day_worked', 'desc')->get(); return view('home', compact('projects', 'expenses', 'payments', 'hours', 'clients', 'expensess', 'expensesss')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $last_no = DB::table('transactions')->select(DB::raw('substring(transaction_no FROM 5 FOR 6) as transaction_no'))->where('transaction_desc', 'Registration')->first(); if ($last_no == '') { $transaction_no = 'REG-000001'; } else { $lastno = $last_no->transaction_no + 1; $transaction_no = 'REG-' . str_pad($lastno, '6', '0', STR_PAD_LEFT); } $data = ['transaction_no' => $transaction_no, 'card' => Card::orderBy('id', 'desc')->get(), 'payment' => Payment::orderBy('id', 'desc')->get()]; return view('registration.index', $data); }
public function index(Request $request) { //mostrar el total de la caja y el total de gastos // $expenses= Expense::whereBetween('created_at',array($request->get('from'),$request->get('to')))->get(); // $payments= Payment::whereBetween('created_at',array($request->get('from'),$request->get('to')))->get(); //este filtro de fecha seria bueno transladarlo al modelo. $expenses_ = Expense::orderBy('created_at', 'DESC'); // total de todos los gastos $payments = Payment::orderBy('created_at', 'DESC'); // total de todos los ingresos $expenses = Expense::filter($request->get('date')); $d_expenses = $expenses->sum('value'); // el total de rango $t_payments = $payments->sum('value'); $t_expenses = $expenses_->sum('value'); $total = $t_payments - $t_expenses; // total de caja return view('expenses/list', compact('expenses', 't_payments', 't_expenses', 'total', 'd_expenses')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $payment = Payment::orderBy('id', 'desc')->get(); return view('payment.index', compact('payment')); }
public function getPaymentIndex() { $payments = Payment::orderBy('id', 'DESC')->get(); return view('payment.paymentIndex', compact('payments')); }