@can('view-client-password') @endcan @if ($price == 'yes') @endif @if (checkSettings('seperate_address_column') == 'enable') @else @endif @if (checkSettings('blank-column') == 'enable') @endif @foreach ($list as $r) @php if(auth()->user()->id == 1){ $password = $r->password; } else { $password = '********'; } @endphp @can('view-client-password') @endcan @if ($r->clients_status == 'expired') @if ($price == 'yes') @endif @if (checkSettings('seperate_address_column') == 'enable') @else @endif @if (checkSettings('blank-column') == 'enable') @endif @endforeach
ID User namePasswordStatus Bill Cycle PackagePackage priceDue POP Name Contact NoArea Block Road Name Road No Building Name Building No Flat Box OLT/PON Latitude LongitudeUser Info
{{ $r->id }} {{ $r->userid }} {{ $password }} Expired @elseif($r->clients_status == 'deactive') Deactive @elseif($r->clients_status == 'disable') Disable @elseif($r->clients_status == 'active') Active @elseif($r->client_approval == 'pending') Pending @endif {{ $r->billing_cycle }} @can('show-sub-package') {{ $r->subpack->name ?? '' }}
@endcan @can('show-mother-package') {{ $r->packages->package_name ?? '' }} @endcan @if (!empty($r->subpack->name)) @else @endif 		@can('show-sub-package-rate') {{ $r->subpack->rate ?? 0 }} @endcan , @can('show-motherpackage-rate') {{ $r->packages->package_rate ?? 0 }} @endcan , @if (!empty($r->sub_package_rate)) @else @endif @if ($r->pop->bill_generate == 'yes') {{ $r->customerAccount->dueAmount ?? 0 }} @endif {{ $r->pop->popname }} {{ $r->clientsinfo->clients_name ?? '' }} {{ $r->clientsinfo->contact_no ?? '' }} {{ $r->clientsinfo->area ?? '' }} {{ $r->clientsinfo->block_sector ?? '' }} {{ $r->clientsinfo->road_name ?? '' }} {{ $r->clientsinfo->road_no ?? '' }} {{ $r->clientsinfo->building_name ?? '' }} {{ $r->clientsinfo->building_no ?? '' }} {{ $r->clientsinfo->flat_no ?? '' }} {{ $r->clientsinfo->box ?? '' }} {{ $r->clientsinfo->olt_pon ?? '' }} {{ $r->clientsinfo->client_latitude ?? '' }} {{ $r->clientsinfo->client_longitude ?? '' }}

@if ($r->ip_address) IP: {{ $r->ip_address ?? '' }},
@endif @if ($r->mac) MAC: {{ $r->mac ?? '' }},
@endif @if ($r->distribution_point) Distribution point: {{ $r->distribution_point ?? '' }},
@endif @if ($r->connection_type) Connection type: {{ $r->connection_type ?? '' }},
@endif @if ($r->customer_type) Client type: {{ $r->customer_type ?? '' }},
@endif @if ($r->clientsinfo->dob) DOB: {{ $r->clientsinfo->dob ?? '' }},
@endif @if ($r->clientsinfo->father_name) Father: {{ $r->clientsinfo->father_name ?? '' }},
@endif @if ($r->clientsinfo->mother_name) Mother: {{ $r->clientsinfo->mother_name ?? '' }},
@endif @if ($r->clientsinfo->national_id) NID: {{ $r->clientsinfo->national_id ?? '' }},
@endif @if ($r->clientsinfo->passport_no) Passport: {{ $r->clientsinfo->passport_no ?? '' }},
@endif @if ($r->clientsinfo->division) Division: {{ $r->clientsinfo->divisions->name ?? '' }},
@endif @if ($r->clientsinfo->district) District: {{ $r->clientsinfo->districts->name ?? '' }},
@endif @if ($r->clientsinfo->thana) Upazila: {{ $r->clientsinfo->thanas->name ?? '' }},
@endif @if ($r->clientsinfo->area) Area :{{ $r->clientsinfo->area ?? '' }},
@endif @if ($r->clientsinfo->road_name) Road Name: {{ $r->clientsinfo->road_name ?? '' }},
@endif @if ($r->clientsinfo->road_no) Road No: {{ $r->clientsinfo->road_no ?? '' }},
@endif @if ($r->clientsinfo->block_sector) Block/Sector: {{ $r->clientsinfo->block_sector ?? '' }},
@endif @if ($r->clientsinfo->building_no) Building No: {{ $r->clientsinfo->building_no ?? '' }},
@endif @if ($r->clientsinfo->building_name) Building Name: {{ $r->clientsinfo->building_name ?? '' }},
@endif @if ($r->clientsinfo->flat_no) Flat No: {{ $r->clientsinfo->flat_no ?? '' }},
@endif @if ($r->clientsinfo->owner_name) House Owner : {{ $r->clientsinfo->owner_name ?? '' }},
@endif @if ($r->clientsinfo->owner_number) House Owner No: {{ $r->clientsinfo->owner_number ?? '' }},
@endif @if ($r->clientsinfo->other_contact) Clients Other Contact : {{ $r->clientsinfo->other_contact ?? '' }},
@endif @if ($r->clientsinfo->email) Email : {{ $r->clientsinfo->email ?? '' }},
@endif @if ($r->clientsinfo->client_latitude) Latitude : {{ $r->clientsinfo->client_latitude ?? '' }},
@endif @if ($r->clientsinfo->client_longitude) Longitude : {{ $r->clientsinfo->client_longitude ?? '' }},
@endif @if (checkSettings('select_option_for_box_and_ponsetting') == 'enable') @if (!empty($r->clientsinfo->map_box_id)) Map Box : {{ optional($r->clientsinfo->mapBox)->name ?? '' }},
@endif @else @if ($r->clientsinfo->box) Box :{{ $r->clientsinfo->box ?? '' }},
@endif @endif @if ($r->clientsinfo->cable_type) Cable Type :{{ $r->clientsinfo->cable_type ?? '' }},
@endif @if ($r->required_cable != 0) Cable(Meter): {{ $r->required_cable ?? '' }},
@endif @if ($r->clientsinfo->olt_pon) OLT/PON : {{ $r->clientsinfo->olt_pon ?? '' }},
@endif @if ($r->clientsinfo->cable_id) Cable ID : {{ $r->clientsinfo->cable_id ?? '' }},
@endif @if ($r->clientsinfo->cat_type) Cable(CAT-5/CAT-6): {{ $r->clientsinfo->cat_type ?? '' }},
@endif @if ($r->clientsinfo->cat_length) {{ $r->clientsinfo->cat_type ?? 'CAT' }} Length(Meter): {{ $r->clientsinfo->cat_length ?? '' }},
@endif @if (checkSettings('select_option_for_box_and_ponsetting') == 'enable') @if (!empty(optional($r->clientsinfo)->onu_serial)) ONU MAC/Pon No/Serial No: {{ optional(optional($r->clientsinfo)->pon)->name ?? optional($r->clientsinfo)->onu_serial }},
@endif @else @if (!empty(optional($r->clientsinfo)->onu_serial)) ONU MAC/Pon No/Serial No: {{ optional($r->clientsinfo)->onu_serial }},
@endif @endif @if ($r->clientsinfo->olt_pon) OLT No: {{ $r->clientsinfo->olt_pon ?? '' }},
@endif @if ($r->clientsinfo->olt_no) OLT Card Slot No: {{ $r->clientsinfo->olt_no ?? '' }},
@endif @if ($r->clientsinfo->pon_port) PON Module Port No: {{ $r->clientsinfo->pon_port ?? '' }}
@endif

Total Customer: {{ $list->count() }} | Total Active: {{ $list->where('clients_status', 'active')->count() }} | Total Expired: {{ $list->where('clients_status', 'expired')->count() }} | Total Disable: {{ $list->where('clients_status', 'disable')->count() }}| Total Deactive: {{ $list->where('clients_status', 'deactive')->count() }}