@if(count($branchs) > 0) @foreach($branchs as $datas) @php $LastEntryDateObj = App\Model\Orders::select(DB::raw('DATE(MAX(date)) as lastEntryDate'))->where('auto_mer_id', $datas->id)->whereMonth('date', '=', $months)->where('fiscal_year',$fiscal_year)->whereNotIn('transaction_type_slug', ['OPBalance','Ctfr-IB','IB-CDB','IB-HO-Opening'])->where('deleted_at', null)->first(); $LastEntryDate = (!empty($LastEntryDateObj)?$LastEntryDateObj->lastEntryDate:$datas->last_entry_date); @endphp @endforeach @endif

No.	Branch Code	Branch Details	Address Of Branch	User Details	Status
{{ $no++ }}	{{ $datas->ashram_id }}	Last Entry Date : {{ changeDateFormate($LastEntryDate) }} Open Date : @if($datas->open_day_book_date != null){{ changeDateFormate($datas->open_day_book_date) }} @else {{ changeDateFormate($datas->effective_date) }} @endif Created On : {{ changeDateFormate($datas->created_at) }} {{ changeTimeFormate($datas->created_at) }} Branch Type : {{ checkHOParentSubBranch($datas->id)}} Branch Branch Name : {{ $datas->name }} @if(checkHOParentSubBranch($datas->id) == 'Sub') Parent Branch : {{ getBranchCode($datas->parent_merchant_id) }} @endif @if(checkCheackerUser(Auth::user()->admin_role_id,Auth::user()->id) == 1) Checker Name : @if(getHoId(Auth::user()->id) != $datas->id) {{ getCheckerName($datas->id) }} @endif @endif	Branch Incharge : {{ $datas->office_branch_incharge }} Rehbar Name : {{ getRahebarName($datas->rahebar_id) }} Address : {{ $datas->full_address }} City : {{ getCityName($datas->city_id) }} State. : {{ getStateName($datas->state_id) }}	@if($datas->created_user_id > 0) Name : {{ getMerchantTitle(getUserDetailsInfo($datas->created_user_id)->title) }} {{ getUserDetailsInfo($datas->created_user_id)->name }} Email : {{ getUserDetailsInfo($datas->created_user_id)->email }} Registered On : {{ changeDateFormate(getUserDetailsInfo($datas->created_user_id)->created_at) }} {{ changeTimeFormate(getUserDetailsInfo($datas->created_user_id)->created_at) }} Phone. : {{ getUserDetailsInfo($datas->created_user_id)->phone }} Phone model : {{ getUserDetailsInfo($datas->created_user_id)->device_name }} Phone OS : {{ getUserDetailsInfo($datas->created_user_id)->os_version }} Cash book app version. : {{ getUserDetailsInfo($datas->created_user_id)->app_version }} @endif	{{ ($datas->status == 0 )? 'Inactive':'Active'}}