@extends('layout.erp.app') @section('page') @php $total_orders = DB::select('SELECT sum(order_total) total FROM orders'); $total_orders_paid = DB::select('SELECT sum(paid_amount) total FROM orders'); $total_orders_no = DB::select('SELECT count(*) as total FROM orders'); $total_purchsase = DB::select('SELECT sum(order_total) total FROM purchases'); $total_purchsase_paid = DB::select('SELECT sum(paid_amount) total FROM purchases'); $total_purchsase_no = DB::select('SELECT count(*) as total FROM purchases'); $total_customers = DB::select('SELECT COUNT(*) AS total_customers FROM customers'); $total_suppliers = DB::select('SELECT COUNT(*) AS total_suppliers FROM suppliers'); // print_r($total_orders_no[0]->total); @endphp
img
${{$total_purchsase[0]->total}}
Total Purchase
img
${{$total_orders[0]->total}}
Total Sale
img
${{$total_orders_paid[0]->total}}
Total Sale Paid
img
${{$total_purchsase_paid[0]->total}}
Total Expense Amount

{{$total_customers[0]->total_customers}}

Customers

{{$total_suppliers[0]->total_suppliers}}

Suppliers

{{$total_purchsase_no[0]->total}}

Purchase
icon

{{$total_orders_no[0]->total}}

Sales
{{--
Purchase & Sales
  • Sales
  • Purchase

Recent Products

View All
# Products Price
1 product Lenevo 3rd Generation $12500
2 product Bold V3.2 $1600
3 product Nike Jordan $2000
4 product Apple Series 5 Watch $800

Expired Products

Product SKU Manufactured Date Expired Date Action
product Red Premium Handy
PT006 17 Jan 2023 29 Mar 2023
product Iphone 14 Pro
PT007 22 Feb 2023 04 Apr 2023
product Black Slim 200
PT008 18 Mar 2023 13 May 2023
product Woodcraft Sandal
PT009 29 Mar 2023 27 May 2023
product Apple Series 5 Watch
PT010 24 Mar 2023 26 May 2023
--}} @endsection