public function getHome() { $categories = Event::all(); $employee = Employee::all(); $invoice = Invoice::orderBy('Id', 'DESC')->get(); return View('executor/home')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice)); }
public function getIndex() { $categories = Event::all(); $employee = Employee::all(); $invoice = Invoice::orderBy('Id', 'desc')->get(); return View('home1')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice)); }
public function getHome() { $year = date("Y"); $categories = Event::where(DB::raw('year(date)'), $year)->get(); $employee = Employee::all(); // dd($year); $invoice = Invoice::orderBy('Id', 'DESC')->where(DB::raw('year(InvoiceDate)'), $year)->where(DB::raw('year(DueDate)'), $year)->get(); return View('executor/home')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice)); }
public function getHome() { $year = date("Y"); $varr = Auth::user()->empid; $evarr = User::where('empid', $varr)->get(); $edetails = Employee::where('emp_ide_id', $varr)->get(); $categories = Event::where(DB::raw('year(date)'), $year)->get(); $employee = Employee::all(); $invoice = Invoice::orderBy('Id', 'DESC')->where(DB::raw('year(InvoiceDate)'), $year)->where(DB::raw('year(DueDate)'), $year)->get(); $invnull = Invoice::where('Status', '=', 'Null')->get(); return View('reviewer/home')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invnull' => $invnull, 'edetails' => $edetails)); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $Invoices = Invoice::orderBy('created_at', 'desc')->paginate(5); return view('invoice.list', ['Invoices' => $Invoices]); }
static function getLast($count) { $Last = Invoice::orderBy('created_at', 'desc')->take($count)->get(); return $Last; }
<?php use App\Invoice; use App\Event; $lastId = Invoice::orderBy('updated_at', 'desc')->first(); $lastinvoice = Invoice::where('Id', $lastId->Id)->get(); foreach ($lastinvoice as $inv) { $evname = $inv['EventName']; } $varr = Event::where('event', $evname)->get(); ?> @foreach($lastinvoice as $inv) @foreach($varr as $invar) <p><b>Dear {{$inv['ClientName']}},</b></p> <p>We thank <b>{{$inv['Companyname']}}</b> for giving us an opportunity to serve you at our <b>{{$inv['EventName']}}</b> initiative to be held on <b>{{$invar['date']}}</b> at <b>{{$invar['city']}}-{{$invar['country']}}</b> , in this regards please find attached Pro-Forma invoice numbered : <b>{{$inv['InvoiceCode']}}</b> dated : <b>{{$inv['InvoiceDate']}}</b>.</p> <p><b>Special Note: please pay the due amount as per the terms mentioned in the pro-forma invoice.</b></p> @endforeach @endforeach