@extends('layouts.app')
<!--buildings_cost/index.blade.php-->

@section('content')

<div class="col-xl-4 float-right">		
	<div id="panel-1" class="panel">
		<div class="panel-hdr">
			<div class="panel-content table-responsive">
				<h5>Data Totals</h5>
			</div>
		</div><!--end panel-hdr-->
    
    	
		<div class="panel-container show">
			<div class="panel-content">
				<table id="dt-basic-example" class="table table-bordered table-hover table-striped w-100">
					<tr>
						<td>Total Contract Devices:
						</td>
                    <td><a href="{{route('show_contract_devices', 'contract')}}">@if(isset($contract_devices_count)) {{$contract_devices_count}} @endif</a>
						</td>
					</tr>
					<tr>
						<td>Contract Devices Reporting: 
						</td>
						<td><a href="{{route('show_reporting_devices', 'reporting_devices')}}">@if(isset($devices_reporting_count)) {{$devices_reporting_count}} @endif</a>
						</td>
					</tr>
					<tr>
						<td>Devices Not Reporting<span style="color:red;">*</span>:
						</td>
						<td><a href="{{route('show_not_reporting_devices', 'not_reporting')}}">@if(isset($not_reporting_count)) {{$not_reporting_count}} @endif</a>
						</td>
                </tr>
					<tr>
						<td>Devices W/Toner Alert:
						</td>
						<td><a href="{{route('show_toner_data', 'toner')}}">@if(isset($toner_alert_count)) {{$toner_alert_count}} @endif</a>
						</td>
					</tr>
					<tr>
						<td>Devices W/Service Needed:
						</td>
						<td><a href="{{route('show_service_data', 'service_needed')}}">@if(isset($service_needed_count)) {{$service_needed_count}} @endif </a>
						</td>
					</tr>
					<tr>
						<td>Non-Contracted Devices:
						</td>
						<td><a href="{{route('show_non_contract_devices', 'non_contract')}}">@if(isset($non_contract_devices_count)) {{$non_contract_devices_count}} @endif </a>
						</td>
					</tr>
					<tr>
						<td>Last Sync Date:
						</td>
						<td>@if(isset($last_sync_date)) {{$last_sync_date->dt}} @endif</td>
					</tr>
				</table>
				
				<div style="color:red;">
					*Not reporting for 15 days.
				</div>
				
				<div class="btn-group my-2">
					<a href="index" class="btn btn-sm btn-primary center">View Device Listing</a>
				</div>
				
			</div><!--end panel-content-->
		</div><!--endpanel-container show-->		
	</div><!--end panel-1-->
</div><!--end col-xl-4-->


<div style="float-left">
	<div class="row col-xl-8">
		<div class="col-xl-3">
        	
			<form action="" method="get" enctype="multipart/form-data"> <!--enctype needed for image upload-->
			@csrf
				<div class="container-fluid">
					<div class="d-flex my-3">
                    
						<div class="form-group">
							<label for="orgSel">Select an Organization</label>					

							<select name="orgSel" id="orgSel" class="form-control mb-2" onchange="page_direct('buildings_cost.show_by_param', 'org__' + this.value)"> 
								<option>Select an Organization</option>
								<!--Display all orgs from the resultset.-->						
								@if(isset($orgs))
									@foreach($orgs as $row)
										<option value="{{$row->org_id}}"
											@if(isset($org_id))
												@if($row->org_id == $org_id)
													selected
												@endif
											@endif
										>{{$row->org_name}}</option>
									@endforeach
								@endif
									
							</select>
						</div><!--end form-group-->						
					</div><!--end d-flex-->
				</div><!--container-fluid-->			
		</div><!--end col-xl-3-->

    
    	<div class="col-xl-3">
           
				<div class="container-fluid">
					<div class="d-flex my-3">
						<div class="form-group">
							<label for="yearSel">Select a Year</label>					

							<select name="yearSel" id="yearSel" class="form-control mb-2" onchange="page_direct('buildings_cost.show_by_param', 'year__' + this.value)">
								<option value="">Select a Year</option>
                            	<!--Display all years from the resultset.-->						
								@if(isset($years))
									@foreach($years as $row)
										@if($row->year_id >= (22 - 7))
										<option value="{{$row->year_id}}"
											@if(isset($year))
												@if($row->year_id == $year)
													selected
												@endif
											@endif
										>{{$row->school_year}}</option>
										@endif
									@endforeach
								@endif                            
                            							
							</select>
						</div><!--end form-group-->						
					</div><!--end d-flex-->
				</div><!--container-fluid-->			
		</div><!--end col-xl-3-->
    
	
		<div class="col-xl-3">		
				<div class="container-fluid">
					<div class="d-flex my-3">
						<div class="form-group">
							<label for="timeline_datepick">Select Timeline Date</label>
							<input type="text" id="timeline_datepick" name="timeline_datepick" class="form-control mb-2" value="@if(isset($timeline_date)){{$timeline_date}}@endif"
							onchange="page_direct('buildings_cost.show_by_param', 'timeline__' + this.value)"/>

						</div><!--end form-group-->						
					</div><!--end d-flex-->
				</div><!--container-fluid-->
			</form>
		</div><!--end col-xl-3-->
	</div><!--end row-->

	
	<div class="row col-xl-8">
		<div class="col-xl-4">		
			<div id="panel-1" class="panel">
				<div class="panel-hdr">
					<div class="panel-content">
						<h5>Annual Black</h5>
					</div>
				</div>
				
				<div class="panel-container show">
					<div class="panel-content table-responsive">
						<table id="dt-basic-example" class="table table-bordered table-hover table-striped w-100">
							
							<tr>
								<td>Consumed:
								</td>
								<td id="consBlk" name="consBlk">@if(isset($year_totals_array['consumed_black_year'])) ${{number_format($year_totals_array['consumed_black_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
							<tr>
								<td>Budgeted:
								</td>
								<td id="bgtBlk">@if(isset($year_totals_array['budgeted_black_year'])) ${{number_format($year_totals_array['budgeted_black_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
							<tr>
								<td>Projected:
								</td>
								<td id="projBlk">@if(isset($year_totals_array['projected_black_year'])) ${{number_format($year_totals_array['projected_black_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
							
						</table>
					</div>
				</div>				
			</div><!--end panel-1-->
		</div><!--end col-xl-4-->
		
		<div class="col-xl-4">		
			<div id="panel-1" class="panel">
				<div class="panel-hdr">
					<div class="panel-content table-responsive">
						<h5>Annual Color</h5>
					</div>
				</div>
				
				<div class="panel-container show">
					<div class="panel-content table-responsive">
						<table id="dt-basic-example" class="table table-bordered table-hover table-striped w-100">
							<tr>
								<td>Consumed:
								</td>
								<td>@if(isset($year_totals_array['consumed_color_year'])) ${{number_format($year_totals_array['consumed_color_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
							<tr>
								<td>Budgeted:
								</td>
								<td>@if(isset($year_totals_array['budgeted_color_year'])) ${{number_format($year_totals_array['budgeted_color_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
							<tr>
								<td>Projected:
								</td>
								<td>@if(isset($year_totals_array['projected_color_year'])) ${{number_format($year_totals_array['projected_color_year'],0 ,0, ',')}} @endif
								</td>
							</tr>
						</table>
					</div>
				</div>			
			</div><!--end panel-1-->
		</div><!--end col-xl-4-->


		<div class="col-xl-4">		
			<div id="panel-1" class="panel">
				<div class="panel-hdr">
					<div class="panel-content">
						<h5>Request History</h5>
					</div>
				</div>
				<div class="panel-container show">
					<div class="panel-content">
						<p class="my-1">
							When was the last time you had a vendor do a service history on your account?
						</p>
						<div class="btn-group my-1">
							<a href="{{route('request_org_service_history')}}" class="btn btn-sm btn-primary center">Request Org Service History</a>
						</div>
						<div class="btn-group my-1">
						    @if(isset($history_report_path))
						        <a href={{asset($history_report_path)}} class="btn btn-sm btn-primary center">View Latest Report</a>
						    @endif
						</div>
					</div>
				</div>			
			</div><!--end panel-1-->
		</div><!--end col-xl-4-->
	</div><!--end row col-xl-8-->
	

<div style="float-left">
<div class="row col-xl-12">
    <div class="container-fluid">
    <main id="js-page-content" >
        <form action="" method="get" enctype="multipart/form-data"> <!--enctype needed for image upload-->
    		@csrf
    	<div class="row">
    		<div class="col-xl-12">
    			<div id="panel-1" class="panel">
    				<div class="panel-hdr">
    					<h2>
    					    @if(isset($org_name)) {{$org_name}} @endif<span class="fw-300"><i>Cost Data by building</i></span>
    					</h2>
    					<div class="panel-toolbar">
    						<button class="btn btn-primary btn-sm" data-toggle="dropdown">Table Style</button>
    						<div class="dropdown-menu dropdown-menu-animated dropdown-menu-right position-absolute pos-top">
    							<button class="dropdown-item active" data-action="toggle" data-class="table-bordered" data-target="#dt-basic-example"> Bordered Table </button>
    							<button class="dropdown-item" data-action="toggle" data-class="table-sm" data-target="#dt-basic-example"> Smaller Table </button>
    							<button class="dropdown-item" data-action="toggle" data-class="table-dark" data-target="#dt-basic-example"> Table Dark </button>
    							<button class="dropdown-item active" data-action="toggle" data-class="table-hover" data-target="#dt-basic-example"> Table Hover </button>
    							<button class="dropdown-item active" data-action="toggle" data-class="table-stripe" data-target="#dt-basic-example"> Table Stripped </button>
    							<div class="dropdown-divider m-0"></div>
    							
    						</div><!--end dropdown-menu-->
    					</div><!--end panel-toolbar-->
    				</div><!--end panel-hdr-->
                
                					
    				<div class="panel-container show">
    					<div class="panel-content table-responsive">
    						<div class="panel-tag">
    							This table shows all volumes <strong>that match the selected criteria.</strong> 
    						</div>
            
            
    						<!-- datatable start -->
    						<table id="dt-basic-example" class="table table-bordered table-hover table-striped w-100">
    							<thead class="myTabHead">						
    								
    								<tr>
    									<th>Building Name</th>
    									<th>Consumed<br>Black<br>to date</th>
    									<th>Budgeted<br>Black<br> @if(isset($proj_year))FY{{$proj_year}}@endif</th>
    									<th>Projected<br>Black<br> @if(isset($proj_year))FY{{$proj_year}}@endif</th>
    									<th>Avg<br>Per<br>Student</th>
    									<th>Next Years<br>Black<br>@if(isset($proj_year_next))FY{{$proj_year_next}}@endif</th>
    									<th>Consumed<br>Color<br>to date</th>
    									<th>Budgeted<br>Color<br>@if(isset($proj_year))FY{{$proj_year}}@endif</th>
    									<th>Projected<br>Color<br>@if(isset($proj_year))FY{{$proj_year}}@endif</th>
    									<th>Avg<br>Per<br>Student</th>
    									<th>Next Years<br>Color<br>@if(isset($proj_year_next))FY{{$proj_year_next}}@endif</th>
    									<th>Over/Under<br>Budget</th>
    									<th>Live Floorplan</th>
    								</tr>
    							</thead>
    							<tbody>
                                	
                                	@if(isset($array_bldgs) && $display_meter_data == 'Y')
    									
    									 @php $classNum = 0;
    									 $classDef = "";
    									 $targetChild = "";
    								@endphp
    									
									    @foreach ($array_bldgs as $key => $value)
    									    
    									    @php $classNum += 1;
    									         $classDef = "hiddenRow collapse acc_cell_$classNum" ;
    									         $targetChild = ".acc_cell_" . $classNum;
    									    @endphp
    									    
    									    <tr data-toggle="collapse" data-target={{$targetChild}}>
            									<td>{{$key}}</td>
            									
            									@foreach ($value as $row_key => $val)
            									    <td>{{number_format($val,0 ,0, ',')}}</td>
                									
            									@endforeach
            									<td>Go to Live Floorplan</td>
    									    </tr>
    									    
    									     
    									        @foreach($volume_totals as $rec)
    									            
    									            @if($rec->bldg_name == $key)
    									                @php
    									                   if($rec->is_color == 'Y'){
    									                        $mach_col = 'Color';
    									                   }
    									                   else{
    									                        $mach_col = 'Black';
    									                   }
    									                @endphp
    									            
        									            <tr style="background-color:#f9f1c5;">
        									                <td class="{{$classDef}}">{{$rec->mach_make}} - {{$rec->model}} {{$rec->room_name}}
        									                    <br>SN: {{$rec->proposed_serial_number}} - {{$mach_col}}</td>
        									                <td class="{{$classDef}}">${{number_format($rec->consumed_black,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}">${{number_format($rec->budgeted_black,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}">${{number_format($rec->projected_black,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}"></td>
        									                <td class="{{$classDef}}">Next Years Black</td>
        									                <td class="{{$classDef}}">${{number_format($rec->consumed_color,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}">${{number_format($rec->budgeted_color,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}">${{number_format($rec->projected_color,0 ,0, ',')}}</td>
        									                <td class="{{$classDef}}"></td>
        									                <td class="{{$classDef}}">NextYears Black</td>
        									                <td class="{{$classDef}}">over_under_budget</td>
        									                <td class="{{$classDef}}"></td>
    									                </tr>
    									            @endif
    									        @endforeach
                        	            @endforeach
                                	@endif
                                	<!--Add the footer row-->
                                	<!--To get user friendly number, use round to get rid of decimal points, then use number_format to add commas-->
                                	<tr colspan="19">
                                        
                                        	@if(isset($year_totals_array) && $display_meter_data == 'Y')
    									        <th style="text-align:right">Yearly Totals: </th>
    									        
        									    @foreach ($year_totals_array as $key => $value)
                                          
                									<th>${{number_format(round($value, 0, PHP_ROUND_HALF_UP),0,0, ',')}}</th>
                									
            								    @endforeach
        									    <th></th>
        									@endif
                                    </tr>
    							</tbody>
    						</table><!-- end datatable -->
    					</div><!-- end panel-content -->
    				</div><!-- end panel-container -->
    			</div><!-- end panel-l -->
    		</div><!-- end col-xl-12 -->
          </div><!-- end row -->
        </form>
    
    </main>
    </div><!--end container-fluid-->
</div>
</div>

@endsection