@extends('layouts/microfin_layout')
@section('title', '| Member Transaction Status')
@section('content')

<style type="text/css">
	.name{
		text-align: left;
	}

	.amount{
		text-align: right;
	}
</style>

<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default" style="background-color:#708090;">
            <div class="panel-heading" style="padding-bottom:0px">
                <div class="panel-options">

                    {{-- <button id="btnExportExcel" class="btn btn-info pull-center addViewBtn" target="_blank" style="">
                        <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Excel</i>
                    </button> --}}

                    {{--
        			<button id="export" class="btn btn-info pull-center print-icon"  target="_blank" data-export="export">
        				<i class="fa-file-excel-o fa-lg" aria-hidden="true"> Export</i>
        			</button>	
                    --}}
                </div>
                <h3 style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">Member Transaction Status </h3>
            </div>

            <div class="panel-body panelBodyView">

                <div class="row" id="balanceReportFilter">
                    <form action="" class="form-horizontal form-groups" role="form" id="filterFormId" method="get">
                        {{-- Start of report level --}}
                        <div class="col-md-1">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="reportLabel" class="control-label pull-left" style="color:black">Report
                                        Level:</label>
                                </div>
                                <div class="col-md-12">
                                    <select class="form-control input-sm input-fields" id="filReportLevel"
                                        name="filReportLevel" aria-label="Default select example" autocomplete="off">
                                        @foreach ($data['reportLevelList'] as $reportLevel)
                                            <option value="{{$reportLevel}}" @if (isset($data['searchData']['filReportLevel']) && $data['searchData']['filReportLevel'] == $reportLevel) selected @endif>{{$reportLevel}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- end of report level --}}

                        {{-- Start of area level --}}
                        <div class="col-md-1" id="areaDiv" style="display: none;">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="area" class="control-label pull-left" style="color:black">Area:</label>
                                </div>
                                <div class="col-md-12">
                                    <select id="filArea" name="filArea" class="form-control input-sm input-fields"
                                        style="color: black">
                                        <option value="">--All--</option>
                                        @foreach ($data['areaList'] as $area)
                                        <option value="{{$area->id}}" @if (isset($data['searchData']['filArea']) && $data['searchData']['filArea'] == $area->id) selected @endif>{{$area->name}}</option>
                                        @php
                                        $barnchIds = str_replace(['"','[',']'], '', $area->branchId);
                                        $barnchIds = explode(',', $barnchIds);
                                        $branches = DB::table('gnr_branch')
                                        ->whereIn('id',$barnchIds)
                                        ->select(DB::raw("CONCAT ( LPAD(branchCode,3,0) ,' - ', name ) AS
                                        name"))
                                        ->get();
                                        @endphp
                                        @foreach ($branches as $branch)
                                        <option value="" disabled="disabled">&nbsp {{$branch->name}}</option>
                                        @endforeach
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- end of area level --}}

                        {{-- start of zone level --}}
                        <div class="col-md-1" id="zoneDiv" style="display: none;">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="Zone" class="control-label pull-left" style="color: black">Zone:</label>
                                </div>
                                <div class="col-md-12">
                                    <select id="filZone" name="filZone" class="form-control input-sm input-fields"
                                        style="color: black">
                                        <option value="">--All--</option>
                                        @foreach ($data['zoneList'] as $zone)
                                        <option value="{{$zone->id}}" @if (isset($data['searchData']['filZone']) && $data['searchData']['filZone'] == $zone->id) selected @endif>{{$zone->name}}</option>
                                        @php
                                        $areaIds = str_replace(['"','[',']'], '', $zone->areaId);
                                        $areaIds = explode(',', $areaIds);
                                        $areas = DB::table('gnr_area')
                                        ->whereIn('id',$areaIds)
                                        ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                        ->get();
                                        @endphp
                                        @foreach ($areas as $area)
                                        <option value="" disabled="disabled">&nbsp {{$area->name}}</option>
                                        @endforeach
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- End of zone level --}}

                        {{-- Start of region level --}}
                        <div class="col-md-1" id="regionDiv" style="display: none;">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="Division" class="control-label pull-left"
                                        style="color: black">Division:</label>
                                </div>
                                <div class="col-md-12">
                                    <select id="filRegion" name="filRegion" class="form-control input-sm input-fields"
                                        style="color: black">
                                        <option value="">--All--</option>
                                        @foreach ($data['regionList'] as $region)
                                        <option value="{{$region->id}}" @if (isset($data['searchData']['filRegion']) && $data['searchData']['filRegion'] == $region->id) selected @endif>{{$region->name}}</option>
                                        @php
                                        $zoneIds = str_replace(['"','[',']'], '', $region->zoneId);
                                        $zoneIds = explode(',', $zoneIds);
                                        $zones = DB::table('gnr_zone')
                                        ->whereIn('id',$zoneIds)
                                        ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                        ->get();
                                        @endphp
                                        @foreach ($zones as $zone)
                                        <option value="" disabled="disabled">&nbsp {{$zone->name}}</option>
                                        @endforeach
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- End of region level --}}

                        {{-- Start of branch level --}}
                        <div class="col-md-1" id="branchDiv">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="Branch" class="control-label pull-left"
                                        style="color: black">Branch:</label>
                                </div>
                                <div class="col-md-12">
                                    <select class="form-control input-sm input-fields" id="filBranch" name="filBranch"
                                        aria-label="Default select example" autocomplete="off">
                                        <option value="0">--All--</option>
                                        @foreach ($data['branchList'] as $key=>$branch)
                                        <option value="{{$key}}" @if (isset($data['searchData']['filBranch']) && $data['searchData']['filBranch'] == $key) selected @endif>{{$branch}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- end of branch level --}}

                        {{-- Start of trx Type --}}
                        <div class="col-md-1">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="Branch" class="control-label pull-left" style="color: black">Txn Type:</label>
                                </div>
                                <div class="col-md-12">
                                    <select class="form-control input-sm input-fields" id="trxType" name="trxType[]" aria-label="Default select example" autocomplete="off" multiple>
											<option value="loan" @if (isset($data['searchData']['trxType']) && in_array("loan" , $data['searchData']['trxType'])) selected @endif>Loan</option>
                                        @foreach ($data['trxTypes'] as $trxType)
                                        	<option value="{{$trxType}}" @if (isset($data['searchData']['trxType']) && in_array($trxType , $data['searchData']['trxType'])) selected @endif>{{$trxType}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- end of trx type --}}

						{{-- Start of Date Type --}}
                        <div class="col-md-2">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="Branch" class="control-label pull-left" style="color: black">Date Type:</label>
                                </div>
                                <div class="col-md-12">
                                    <select class="form-control input-sm input-fields" id="dateType" name="DateType" aria-label="Default select example" autocomplete="off">
                                        @foreach ($data['dateType'] as $key=>$type)
                                        	<option value="{{$key}}" @if (isset($data['searchData']['DateType']) && $data['searchData']['DateType'] == $key) selected @endif>{{$type}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                        {{-- end of Date type --}}

						{{-- start date --}}
                        <div class="col-md-2">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="date" class="control-label pull-left" style="color: black">Date: </label>
                                </div>
                                <div class="col-md-12">
                                    <input type="text" name="date" class="form-control input-sm input-fields datepicker" autocomplete="off" style="cursor:pointer" @if (!empty($data['searchData'])) value="{{$data['searchData']['date']}}" @endif>
                                </div>
                            </div>
                        </div>
                        {{-- end date --}}

						{{-- start form time --}}
                        <div class="col-md-2" id="timeForm">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="formTime" class="control-label pull-left" style="color: black">Form Time: </label>
                                </div>
                                <div class="col-md-12">
                                    <input type="time" id="fromtime" name="formTime" class="form-control input-sm input-fields " autocomplete="off" style="cursor:pointer" @if (!empty($data['searchData'])) value="{{$data['searchData']['formTime']}}"
									@endif>
                                </div>
                            </div>
                        </div>
                        {{-- start date --}}

                        {{-- Start to time --}}
                        <div class="col-md-2" id="timeTo">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <label for="toTime" class="control-label pull-left" style="color: black">To Time: </label>
                                </div>
                                <div class="col-md-12">
                                    <input type="time" id="totime" name="toTime" class="form-control input-sm input-fields" autocomplete="off" style="cursor:pointer" @if (!empty($data['searchData'])) value="{{$data['searchData']['toTime']}}"
										
									@endif>
                                </div>
                            </div>
                        </div>
                        {{-- To date --}}


                        {{-- Start of the Submit Button --}}
                        <div class="col-md-1">
                            <div class="form-group">
                                {!! Form::label('', '.', ['class' => 'control-label col-md-12', 'style' =>
                                'color:#708090'])
                                !!}
                                <div class="col-md-12">
                                    <button type="submit" id="reportSubmit"
                                        class="btn btn-primary input-fields">Show</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
               
				<div id="printDiv">
					<div id="statusReport">
						<div class="title-section">
							<div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold; "> {{-- div for Company --}}
								{{-- <span style="text-decoration: underline;  font-size:14px;">Member Transaction Status</span> --}}
							</div>
						</div>
						
						<div class="row">
							<div class="col-lg-12">
								<div class="table-responsive">
									<table class="table table-striped table-bordered view" id="areaListView">
										<thead>
											<tr>
												<th rowspan="2" width="0">SL No.</th>
												<th rowspan="2" width="0">Branch Name</th>
												<th colspan="2" width="0">Member</th>
												<th rowspan="2" width="0">TXN Code</th>
												<th rowspan="2" width="0">Product</th>
												<th rowspan="2" width="0">TXN Ref</th>
												@if (!empty($data['searchData']) && $data['searchData']['DateType'] == "systemDate")
													<th rowspan="2" width="0">TXN Date</th>
												@endif
												<th colspan="2" width="0">System</th>
												<th rowspan="2" width="0">TXN By</th>
												<th rowspan="2" width="0">TXN Amount</th>
											</tr>
											<tr>
												<th>Name</th>
												<th>Code</th>
												<th>Date</th>
												<th>Time</th>
											</tr>
										</thead>
										<tbody>
											@php
												$totalAmount = 0;
												$grandTotalColspan = 9;
                                                $colspan = 11;
												if ( !empty($data['searchData']) && $data['searchData']['DateType'] == "systemDate"){ $grandTotalColspan = 10; $colspan = 12;}
											@endphp
											@forelse ($data['finalData'] as $item)
												<tr>
													<td>{{$loop->iteration}}</td>
													<td class="name">{{$item['branch']}}</td>
													<td class="name">{{$item['name']}}</td>
													<td class="name">{{$item['code']}}</td>
													<td >{{$item['txnCode']}}</td>
													<td>{{$item['product']}}</td>
													<td>{{$item['txnRef']}}</td>
													@if (!empty($data['searchData']) && $data['searchData']['DateType'] == "systemDate")
                                                        <td>{{ \Carbon\Carbon::parse($item['txnDate'])->format('d-m-Y') }}</td>
													@endif
                                                    <td>{{ \Carbon\Carbon::parse($item['date'])->format('d-m-Y') }}</td>
													<td>{{$item['time']}}</td>
                                                    <td class="name">{{$item['txnBy']}}</td>
													<td class="amount">{{number_format($item['amount'],2)}}</td>
													@php
														$totalAmount += $item['amount'];
													@endphp
												</tr>
												
											@empty
											<tr>
												<td colspan="{{$colspan}}" class="noDataFound">No Data found</td>
											</tr>
											@endforelse
											<tr>
												<td></td>
												<td colspan="{{$grandTotalColspan}}" class="name">Grand Total</td>
												<td class="amount">{{number_format($totalAmount,2)}}</td>
											</tr>
										</tbody>
									</table>
								</div>
							</div>
						</div>
					</div>
				</div>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript">
    $(".datepicker").datepicker({
        changeMonth: true,
        changeYear: true,
        dateFormat: 'dd-mm-yy',
        yearRange: '2010:c',
    });

</script>



<script text="text/javascript">
    $(document).ready(function () {
        /*on change filReportLevel hide/show contents*/
        $("#filReportLevel").change(function (event) {
            if ($(this).val() == "Branch") {
                $("#branchDiv").show();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();

                $("#filArea").prop('required', false);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Area") {
                $("#branchDiv").hide();
                $("#areaDiv").show();
                $("#zoneDiv").hide();
                $("#regionDiv").hide();
                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', true);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Zone") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").show();
                $("#regionDiv").hide();

                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', false);
                $("#filZone").prop('required', true);
                $("#filRegion").prop('required', false);
            } else if ($(this).val() == "Region" || $(this).val() == "Division") {
                $("#branchDiv").hide();
                $("#areaDiv").hide();
                $("#zoneDiv").hide();
                $("#regionDiv").show();

                //$("#filBranch").prop('required', false);
                $("#filArea").prop('required', false);
                $("#filZone").prop('required', false);
                $("#filRegion").prop('required', true);
            }
        });

        /*end on change filReportLevel hide/show contents*/
        $("#filReportLevel").trigger('change');

		$('#timeForm').click(function(){
			$('#fromtime').val("");
			
		});
		$('#timeTo').click(function(){
			$('#totime').val("");
		});

		let type = $('#dateType').val();
		if (type == "systemDate") {
			$('#timeForm').show();
			$('#timeTo').show();
		}else{
			$('#timeForm').hide();
			$('#timeTo').hide();
		}

		
		$('#dateType').change(function(e){
			e.preventDefault();
			let type = $('#dateType').val();
			if (type == "systemDate") {
				$('#timeForm').show();
				$('#timeTo').show();
			}else{
				$('#timeForm').val("");
				$('#timeForm').hide();
				$('#timeTo').val("");
				$('#timeTo').hide();
			}
		});
    });

</script>

@endsection