@php use App\Models\User; use App\Models\ponno_purchase_entry; use App\Models\arod_chotha_info; use App\Models\arod_chotha_entry; use Carbon\Carbon; use Illuminate\Http\Request; use Illuminate\Support\Facades\Cache; $incomplete_purchase = ponno_purchase_entry::where('purchase_type', 1) ->where(function ($query) { $query->where('weight', 0) ->orWhere('rate', 0); })->get(); $incomplete_chotha = ponno_purchase_entry::where('purchase_type', 2) ->whereNotIn('id', function ($query) { $query->select('purchase_id') ->from('arod_chotha_infos'); }) ->where('quantity', '!=', function ($query) { $query->selectRaw('COALESCE(SUM(sales_qty), 0)') ->from('arod_chotha_entries') ->whereColumn('arod_chotha_entries.purchase_id', '=', 'ponno_purchase_entries.id'); }) ->where('quantity', '=', function ($query) { $query->selectRaw('COALESCE(SUM(sales_qty), 0)') ->from('ponno_sales_entries') ->whereColumn('ponno_sales_entries.purchase_id', '=', 'ponno_purchase_entries.id'); }) ->count(); $users = User::all(); @endphp @foreach ($users as $user) @endforeach