public function selectReportByExpense(Request $request, ExpenseAjax $expense)
{
$input = $request->all();
$exchangerate = DB::table('exchange_rates')->orderBy('id', 'desc')->first();
$services = Service::select('sections.name AS section_name', 'uom_expenses.name AS expense_uom_name', 'services.*')->leftJoin('sections', 'sections.id', '=', 'services.section_id')->leftJoin('uom_expenses', 'uom_expenses.id', '=', 'services.uom_expense_id')->where('sections.is_active', 1)->whereBetween('services.expense_date', array($input['dateFrom'], $input['dateTo']))->orderBy('services.expense_date')->get();
return View::make('reports.reportExpenseResult')->with('services', $services)->with('exchangerate', $exchangerate);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$sv = Service::select('services.*', 'sections.name AS section_name', 'uom_expenses.name AS uom_expense_name')->join('sections', 'sections.id', '=', 'section_id')->leftJoin('uom_expenses', 'uom_expenses.id', '=', 'uom_expense_id')->where('services.is_active', 1)->get();
$services = json_encode($sv);
$sections = DB::table('sections')->lists('name', 'id');
$uom = DB::table('uom_expenses')->lists('name', 'id');
$exchangerate = DB::table('exchange_rates')->orderBy('id', 'desc')->first();
return view('services/index', compact('services', 'sections', 'uom', 'exchangerate'));
}
