@extends('admin.layout.master') @section('content')

Police Station Details

{{ $policestation->name }}

Police Station Information

Phone Number: {{ $policestation->phone_no }}
Email: {{ $policestation->email }}
Division: {{ $policestation->division->bn_name }}
District: {{ $policestation->district->bn_name }}
Upazila: {{ $policestation->upazila->bn_name }}
Address: {{ $policestation->address }}

User Information

User Email: {{ $policestation->userinfo->email }}
User Name: {{ $policestation->userinfo->name }}
User Type: {{ $policestation->userinfo->user_type }}
Total Complain

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','Complain')->get()->count() }}

Pending Complain

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','Complain')->where('status','Pending')->get()->count() }}

Solve Complain

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','Complain')->where('status','Solved')->get()->count() }}

Total General Diary

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','GD')->get()->count() }}

Pending General Diary

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','GD')->where('status','Pending')->get()->count() }}

Solve General Diary

{{ App\Models\Complain::where('police_station', $policestation->id )->where('type','GD')->where('status','Solved')->get()->count() }}

@endsection