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'));
}
