@extends('includes.master')
@section('content')  

<style>
.error_class{
	color:red;
}
.success_class{
	color:#66ff33;
}

.panel-danger {
	border-color: #ffffff !important;
}
.panel-body {padding:0px !important;}
.x_panel {padding:10px 0px;}

#chartdiv {
	width:100%;
	height: 400px;
}

#chartdiv_2 {
	width:100%;
	height: 400px;
}

#relationdiv {
	width:100%;
	height: 400px;
}

#relationdiv_2 {
	width:100%;
	height: 400px;
}

.canvasjs-chart-credit{
	display: none;
}

g{
	display:block;
}
</style>

<!-- <script type="text/javascript"> 
 $(function(){
  $('.iframeloading').show();
});
 $(document).ready(function(){
	$('.iframeloading').hide();	
});    
</script> -->


<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
<script src="https://www.amcharts.com/lib/4/core.js"></script>
<script src="https://www.amcharts.com/lib/4/charts.js"></script>
<script src="https://www.amcharts.com/lib/4/themes/animated.js"></script>


<div class="right_col" role="main">

	<div class="row"><div class="col-md-12 float-none"><b style="font-size: 22px;font-size: 25px; padding: 5px 10px;background: #fff;font-weight: normal; display: block; margin-bottom: 10px;">{{$company[0]->comp_name}}</b></div>
    </div>

<div class="row  class="right_col"">



	<div class="col-md-12 col-sm-12 col-xs-12">
		<div class="x_panel">
			<div class="container">

				<div class="col-md-6 col-sm-6 col-xs-12">
					<div class="box-body">



          @if(count($check_exit) == 0)

            <div class="row">
              <div class="col-md-12">
                <span>Does Not Any Claim Request</span>
              </div>
            </div>
          @endif

         @if(count($check_exit) > 0)

         

						<div class="table-responsive">
							<center><h2><b>Policy Period</b></h2></center>

							<table class="table table-striped table-bordered">
								<thead>
									<tbody>
										<tr>
											<th>Policy Start Date</th>
											<td>{{$company[0]->start_date}}</td> 
										</tr>

										<tr>
											<th>Policy End Date</th>
											<td>{{$company[0]->end_date}}</td>
										</tr>

										<tr>
											<th>Period Compplate</th>
											<td>11 Month(s),5 Days</td> 
										</tr>

										<tr>
											<th>No Of Days Complated</th>
											<td>343</td>
										</tr>

									</tbody>
								</thead>
							</table>
						</div>
					</div>
				</div>



				<div class="col-md-6 col-sm-6 col-xs-12">
					<div class="box-body">
						<div class="table-responsive">
							<center><h2><b>Summary</b></h2></center>

							<table class="table table-striped table-bordered">
								<thead>
									<tbody>
										<tr>
											<th>Premimum As On Date</th>
											<td>628004</td> 
										</tr>

										<tr>
											<th>Earned Premium</th>
											<td>590152</td>
										</tr>

										<tr>
											<th>Claim Amount</th>
											<td>288418</td> 
										</tr>

										<tr>
											<th>Incurred Claim Ratio</th>
											<td>46%</td>
										</tr>
									</tbody>
								</thead>
							</table>
						</div>
					</div>
				</div>					

				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Cashless Vs Reimbursement</b></h2></center>		
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>Claim Mode</th>
										<th>Claim Amount(Settled & Underprocess)</th>
										<th>As a % total Amt</th>
										<th>No.Of Claim(Settled & Underprocess)</th>
										<th>As a % total Nos.</th>
										<th>Avg Claim Size</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_comp as $val)
									<tr>
										<td>{{$val->claim_type}}</td>
										<td>{{$val->claim_amount}}</td>
										<td>{{$val->per}}</td>
										<td>{{$val->count}}</td>
										<td>{{$val->number_per}}</td>
										<td>{{$val->avg_no_claim_size}}</td>	
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					</div>
					<br><hr>
				</div>
				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Cashless Vs Reimbursement Amount</b></center>
					<div id="chartContainer_amt" style="height: 370px; width: 100%;">
					</div>
				</div>
				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Cashless Vs Reimbursement Number</b></center>
					<div id="chartContainer_nos" style="height: 370px; width: 100%;"></div>
				</div><br><hr>

				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Claim Status Report</b></h2></center>			
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>Claim Mode</th>
										<th>Amount (INR)</th>
										<th>As a % Total </th>
										<th>No.Of Claims</th>
										<th>As a % Total</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_settled as $val)
									<tr>
										<td>{{$val->claim_final_status}}</td>
										<td>{{$val->claim_amount}}</td>
										<td>{{$val->per}}</td>
										<td>{{$val->count}}</td>
										<td>{{$val->number_per}}</td>
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					</div>
					<br><hr>
				</div>


				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Claim Status Analysis(In Value)</b></center>
					<div id="chartdiv"></div>				
				</div>
				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Claim Status Analysis(In Nos)</b></center>
					<div id="chartdiv_2"></div>
				</div>



				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Relationship Wise Settled & Underprocess Claim Up</b></h2></center>			
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>Relation</th>
										<th>Claim Amount</th>
										<th>As a % Total </th>
										<th>No.Of Claims</th>
										<th>As a % Total Nos.</th>
										<th>Avg Claim Size</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_relation_wise as $val)
									<tr>
										<td>{{$val->relationship}}</td>
										<td>{{$val->claim_amount}}</td>
										<td>{{$val->per}}</td>
										<td>{{$val->count}}</td>
										<td>{{$val->number_per}}</td>
										<td>{{$val->avg_no_claim_size}}</td>					
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					</div>
					<br><hr>
				</div>


				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Relationship Wise(In Value)</b></center>
					<div id="relationdiv"></div>				
				</div>
				<div class="col-md-6 col-sm-6 col-xs-12">
					<center><b>Relationship Wise(In Nos)</b></center>
					<div id="relationdiv_2"></div>
				</div>


				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Age Wise Claim Break Up</b></h2></center>		
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>Age</th>
										<th>Claim Amount(Age)</th>
										<th>As a % total Amt</th>
										<th>No.Of Claim</th>
										<th>As a % total No.s</th>
										<th>Avg Claim Size</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_age_wise as $val)
									<tr>
										<td>{{$val->age_group}}</td>
										<td>{{$val->claim_amt}}</td>
										<td>{{$val->claim_per}}%</td>
										<td>{{$val->no_of_claims}}</td>
										<td>{{$val->no_of_claim_perr}}%</td>
										<td>{{$val->avg_claim_sizee}}</td>
									</tr>
									@endforeach
								</tbody>
							</table>
						</div><br><hr>
					</div>


					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>Age Wise Claims (In Value)</b></center>
						<div id="chartContainer_amt_age" style="height: 370px; width: 100%;">
						</div>
					</div>
					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>Age Wise Claims (In Nos)</b></center>
						<div id="chartContainer_nos_age" style="height: 370px; width: 100%;"></div>
					</div><br><hr>

				</div>



				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Amount Band Wise Claim Break Up</b></h2></center>		
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>Amount Band</th>
										<th>Claim Amount(Band)</th>
										<th>As a % total Amt</th>
										<th>No.Of Claim</th>
										<th>As a % total No.s</th>
										<th>Avg Claim Size</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_band_wise as $val)
									<tr>
										<td>{{$val->band_group}}</td>
										<td>{{$val->claim_amt}}</td>
										<td>{{$val->claim_per}}%</td>
										<td>{{$val->no_of_claims}}</td>
										<td>{{$val->no_of_claim_perr}}%</td>
										<td>{{$val->avg_claim_sizee}}</td>
									</tr>
									@endforeach
								</tbody>
							</table>
						</div><br><hr>
					</div>


					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>Amount Band(In Value)</b></center>
						<div id="chartContainer_amt_band" style="height: 370px; width: 100%;">
						</div>
					</div>
					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>Amount Band(In Nos)</b></center>
						<div id="chartContainer_nos_band" style="height: 370px; width: 100%;"></div>
					</div><br><hr>

				</div>


				<div class="col-md-12 col-sm-12 col-xs-12">
					<div class="box-body">
						<div class="table-responsive"><br><hr>
							<center><h2><b>Top 10 City Wise Claim Analysis</b></h2></center>		
							<table class="table table-striped table-bordered">
								<thead>
									<tr>
										<th>City Name</th>
										<th>City Amount</th>
										<th>As a % total Amt</th>
										<th>No.Of Claim</th>
										<th>As a % total No.s</th>
										<th>Avg Claim Size</th>
									</tr>
								</thead>
								<tbody>
									@foreach($get_city_wise as $val)
									<tr>
										<td>{{$val->city}}</td>
										<td>{{$val->claim_amount}}</td>
										<td>{{$val->per}}</td>
										<td>{{$val->count}}</td>
										<td>{{$val->number_per}}</td>
										<td>{{$val->avg_no_claim_size}}</td>
									</tr>
									@endforeach
								</tbody>
							</table>
						</div><br><hr>
					</div>


					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>City Wise(In Value)</b></center>
						<div id="chartContainer_amt_city" style="height: 370px; width: 100%;">
						</div>
					</div>
					<div class="col-md-6 col-sm-6 col-xs-12">
						<center><b>City Wise(In Nos)</b></center>
						<div id="chartContainer_nos_city" style="height: 370px; width: 100%;"></div>
					</div><br><hr>

				</div>
				</div>
</div>
			</div>
		</div>
	</div>


<!--all graf chart Start -->

	








<script>

	function show_chart(container_bind_place , p_dataPoints) {

		var chart = new CanvasJS.Chart(container_bind_place, {
			animationEnabled: true,
			exportEnabled: true,
	theme: "light1", // "light1", "light2", "dark1", "dark2"
	title:{
	},
	data: [{
		type: "column", //change type to bar, area, pie, line,column,spline,splineArea,stepLine,scatter,bubble,stackedColumn,stackedBar,stackedArea,stackedColumn100,stackedBar100,stackedArea100,doughnut, pyramid etc
		
		//indexLabel: "{y}", //Shows y value on all Data Points
		indexLabelFontColor: "#5A5757",
		indexLabelPlacement: "outside",   
		dataPoints: p_dataPoints
	}]
});
		chart.render();
	}


	window.onload = show_chart("chartContainer_amt" , [{"label":"Cashless","y":null},{"label":"Reimbursement","y":null}]);

	window.onload = show_chart("chartContainer_nos" , [{"label":"Cashless","y":null},{"label":"Reimbursement","y":null}]);

	window.onload = show_chart("chartContainer_amt_age" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

	window.onload = show_chart("chartContainer_nos_age" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

	window.onload = show_chart("chartContainer_amt_band" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

	window.onload = show_chart("chartContainer_nos_band" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

	window.onload = show_chart("chartContainer_amt_city" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

	window.onload = show_chart("chartContainer_nos_city" , [{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null},{"label":null,"y":null}]);

</script>


<!--all graf chart End -->




<!-- Claim Status Report Start -->

<script>
	am4core.ready(function() {
		am4core.useTheme(am4themes_animated);
		var chart = am4core.create("chartdiv", am4charts.PieChart3D);
		chart.hiddenState.properties.opacity = 0;
		chart.legend = new am4charts.Legend();

		chart.data = [
		{
			ClaimStatus: "Settled",
			Amount: 		},
		{
			ClaimStatus: "Outstanding",
			Amount: 
		},
		{
			ClaimStatus: "Denied",
			Amount: 		}  
		];

		var series = chart.series.push(new am4charts.PieSeries3D());
		series.dataFields.value = "Amount";
		series.dataFields.category = "ClaimStatus";

	});
</script>

<script>
	am4core.ready(function() {
		am4core.useTheme(am4themes_animated);
		var chart = am4core.create("chartdiv_2", am4charts.PieChart3D);
		chart.hiddenState.properties.opacity = 0;
		chart.legend = new am4charts.Legend();
		chart.data = [
		{
			ClaimStatus: "Settled",
			Number: 		},
		{
			ClaimStatus: "Outstanding",
			Number: 		},
		{
			ClaimStatus: "Denied",
			Number: 		}  
		];

		var series = chart.series.push(new am4charts.PieSeries3D());
		series.dataFields.value = "Number";
		series.dataFields.category = "ClaimStatus";

	});
</script>
<!-- Claim Status Report End -->


<!-- Relationship Start Report End -->
<script>
	am4core.ready(function() {
		am4core.useTheme(am4themes_animated);
		var chart = am4core.create("relationdiv", am4charts.PieChart3D);
		chart.hiddenState.properties.opacity = 0;
		chart.legend = new am4charts.Legend();

		chart.data = [
		{
			ClaimStatus: "Self",
			Amount: 		},
		{
			ClaimStatus: "Spouse",
			Amount: 
		},
		{
			ClaimStatus: "Son",
			Amount: 		}, 
		{
			ClaimStatus: "Doughter",
			Amount: 
		},
		{
			ClaimStatus: "Parent",
			Amount: 		},
		];

		var series = chart.series.push(new am4charts.PieSeries3D());
		series.dataFields.value = "Amount";
		series.dataFields.category = "ClaimStatus";

	});
</script>

<script>
	am4core.ready(function() {
		am4core.useTheme(am4themes_animated);
		var chart = am4core.create("relationdiv_2", am4charts.PieChart3D);
		chart.hiddenState.properties.opacity = 0;
		chart.legend = new am4charts.Legend();
		chart.data = [
		{
			ClaimStatus: "Self",
			Number: 		},
		{
			ClaimStatus: "Spouse",
			Number: 		},
		{
			ClaimStatus: "Son",
			Number: 		},
		{
			ClaimStatus: "Doughter",
			Number: 		},
		{
			ClaimStatus: "Parent",
			Number: 		},
		];

		var series = chart.series.push(new am4charts.PieSeries3D());
		series.dataFields.value = "Number";
		series.dataFields.category = "ClaimStatus";

	});
</script>
<!--Relationship Start Report End -->





@endif



	
</div>

@endsection