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

@section('content')

<div class="page-content" style="padding-top:0px; margin-top:0px;">
        	
	<form action="" method="get" enctype="multipart/form-data"> <!--enctype needed for image upload-->
	@csrf
	    <div class="row">
		    <div class="col-xl-4 col-lg-4 col-md-4">
				<div class="container-fluid">
					<div class="form-group">
						<label for="orgSel" style="color:rgb(255,255,255);">Select an Organization</label>					

						<select name="orgSel" id="orgSel" class="form-control mb-2" onchange="page_direct('buildings_volume.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><!--container-fluid-->			
	        </div><!--end col-xl-4-->
    
    	    
    	    <div class="col-xl-4 col-lg-4 col-md-4">
				<div class="container-fluid">
					<div class="form-group">
						<label for="yearSel" style="color:rgb(255,255,255);">Select a Year</label>					

						<select name="yearSel" id="yearSel" class="form-control mb-2" onchange="page_direct('buildings_volume.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><!--container-fluid-->			
		    </div><!--end col-xl-4-->
    
	
    		<div class="col-xl-4 col-lg-4 col-md-4">
    			<div class="container-fluid">
					<div class="form-group">
						<label for="timeline_datepick" style="color:rgb(255,255,255);">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_volume.show_by_param', 'timeline__' + this.value)"/>

					</div><!--end form-group-->
    			</div><!--container-fluid-->
    		</div><!--end col-xl-4-->
		    
	    </div><!--end row -->
	</form>
    
    <div class="row" style="margin-top:25px;">
        
        <div class="col-xl-2 col-md-6" style="box-sizing:border-box;">
            <div class="card overflow-hidden" style="border-radius: 25px 25px 0px 0px; box-shadow: 10px 10px 5px black; color:rgb(0,0,0); font-size:14px; font-weight:bold;">
                
                <div class="bg-dark" >
                    <div class="row">
                        <div>
                            <h5 style="font-size:20px; text-align:center; padding:10px; color:rgb(255,255,255)">Annual Black</h5>
                        </div>
                    </div><!--end row-->
                </div><!--end bg-dark-->
            
                <div class="row no-gutters" style="border-top:2px solid black;">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Consumed</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['consumed_black_year'])) {{number_format($year_totals_array['consumed_black_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
            
                <div class="row no-gutters">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Budgeted</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['budgeted_black_year'])) {{number_format($year_totals_array['budgeted_black_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Projected</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['projected_black_year'])) {{number_format($year_totals_array['projected_black_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
            
            </div><!--card overflow-hidden-->
        
        
        
            <div class="card overflow-hidden" style="border-radius: 25px 25px 0px 0px; box-shadow: 10px 10px 5px black; color:rgb(0,0,0); font-size:14px; font-weight:bold;">
                <div style="background-color:#a4ddd6;"> <!--#00ffff-->
                    <div class="row">
                        <div>
                            <h5 style="font-size:20px; text-align:center; padding:10px;">Annual Color</h5>
                        </div>
                    </div><!--end row-->
                </div><!--end background-color-->
                
                <div class="row no-gutters" style="border-top:2px solid black;">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Consumed</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['consumed_color_year'])) {{number_format($year_totals_array['consumed_color_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Budgeted</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['budgeted_color_year'])) {{number_format($year_totals_array['budgeted_color_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-6" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 10px 5px 25px;">Projected</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 35px 5px 10px; text-align:right;">
                        @if(isset($year_totals_array['projected_color_year'])) {{number_format($year_totals_array['projected_color_year'],0 ,0, ',')}} @endif
                    </div>
                </div>
            </div><!--card overflow-hidden-->
            
            
            
            <div class="card overflow-hidden" style="border-radius: 25px 25px 0px 0px; box-shadow: 10px 10px 5px black; font-size:12px; font-weight:bold;">
                <div style="border-radius: 25px 25px 0px 0px; background-color:#a4abdd;">
                    <div class="row">
                        <div >
                            <h5 style="font-size:20px; text-align:center; padding:10px; color:rgb(0,0,0);">Data Totals</h5>
                        </div>
                    </div><!--end row-->
                </div><!--end border-radius-->
                
                
                <div class="row no-gutters" style="border-top:2px solid black;">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 5px 5px 25px;">Total Contract Devices</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'contract__contract_y_n__y__choice')}}">@if(isset($contract_devices_count)) {{$contract_devices_count}} @endif</a>
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 5px 5px 25px;">Contract Devices Reporting</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'reporting__reporting_y_n__y__choice')}}">@if(isset($devices_reporting_count)) {{$devices_reporting_count}} @endif</a>
                    </div>
                </div>
                    
                <div class="row no-gutters">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 5px 5px 25px;">Devices Not Reporting</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'reporting__reporting_y_n__n__choice')}}">@if(isset($not_reporting_count)) {{$not_reporting_count}} @endif</a>
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 5px 5px 25px;">Devices W/Toner Alert</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'toner__y')}}">@if(isset($toner_alert_count)) {{$toner_alert_count}} @endif</a>
                    </div>
                </div>
                
                <div class="row no-gutters">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 0px 5px 25px;">Devices W/Service Needed</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'service__y')}}">@if(isset($service_needed_count)) {{$service_needed_count}} @endif </a>
                    </div>
                </div>
                
                <!--The default for Contracted Devices is y, so to have a separate link for the non-contracted devices I have added the additional
					    parameter to the url string. The other links do not need this extra part of the string because they have natural defaults. For
					    example Devices w/Toner Alert defaults to y for yes and Devices w/Service Needed defaults to y for yes. The nonreporting will be
					    like Contracted Devices, but as of today, 10/3/2022, I still have a separate elseif for nonreporting. -->
                
                <div class="row no-gutters">
                    <div class="col-xl-9" style="border-bottom:2px solid black; border-right:2px solid black; padding:5px 5px 5px 25px;">Non-Contracted Devices</div>
                    <div class="col-xl-3" style="border-bottom:2px solid black; padding:5px 30px 5px 5px; text-align:right;">
                        <a href="{{route('show_device_data', 'contract__contract_y_n__n__choice')}}">@if(isset($non_contract_devices_count)) {{$non_contract_devices_count}} @endif </a>
                    </div>
                </div>
                    
                <div class="row no-gutters">
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 5px 5px 25px;">Last Sync Date:</div>
                    <div class="col-xl-6" style="border-bottom:2px solid black; padding:5px 10px 5px 5px;">
                        @if(isset($last_sync_date)) {{$last_sync_date->dt}} @endif
                    </div>
                </div>
                
                <div class="row no-gutters" style="color:red; padding:5px 5px 5px 25px;">
					*Not reporting for 15 days.
				</div>
                
            </div><!--card overflow-hidden-->
        </div><!--end col-xl-2 col-md-6-->
    
        
        <div class="container-responsive gaugeDiv col-xl-9" style="box-sizing:border-box; margin-left:15px;">
    	    <div class="row" style="box-sizing:border-box;">
				    
		        <div class="col-xl-5">
                    <h4 style="font-weight:bold; color:rgb(255,255,255); margin:15px 0px 15px -10px;">@if(isset($org_name)) {{$org_name}} @endif </h4>
                </div>
                
                <div class="col-xl-3">
                    <h6 style="font-weight:bold; color:rgb(255,255,255); margin:15px 0px 15px 20px;">
                        Commencement Date: @if(isset($fiscalYearBegin)) {{$fiscalYearBegin}} @endif
                    </h6>
                </div>
                
                <div class="col-xl-3">
                    <h6 style="font-weight:bold; color:rgb(255,255,255); margin:15px 0px 15px -20px;">
                        Install Date: @if(isset($install_dt)) {{$install_dt}} @endif
                    </h6>
                </div>
            </div><!--end row-->

            
            <div class="row no-gutters col-xl-12">
                <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>Volume Data by building</i></span>
                    					</h2>
                    					<div class="panel-toolbar">
                    						<button class="btn btn-sm" style="background-color:#a4abdd; color:rgb(0,0,0);" 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 Striped </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><br>
                    							An amount in <span style="color:red; font-weight:bold;">red</span> indicates year-end projected overage.<br>
                    							Next year&apos;s projections includes devices that are not reporting.<br><br>
                    							
                    							<div class="btn-group my-1">
                                        		    @if(isset($industry_avg_report_path))
                                        		        <a href={{asset($industry_avg_report_path)}} class="btn btn-sm center" style="background-color:#a4ddd6; color:rgb(0,0,0);">View Industry Black and Color Averages for the last five years.</a>
                                        		    @endif
                                    		    </div>
                    							
                    						</div><!--end panel-tag-->
                            
                            
                                            @if(isset($org_id))
                                            
                            
                    						<!-- 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>Live Floorplan</th>
                    								</tr>
                    							</thead>
                    							
                    							<tbody>
                    							    <!--classNum will be a suffix to add to the class name to be able to distinguish between which
                    							        building data will be shown. classDef is needed to prevent issues with concatenating php
                    							        variables with html. targetChild concatenates the name of the class to a . because the .
                    							        selector says the targetChild is a class. Notice that the php variables within the
                    							        curly brackets in the td elements are enclosed with "". -->
                                                	
                                                	@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)
                            									    @if($row_key !== 'floorplan_image')
                            									    
                            									        {{--If projected values are greater than budgeted, color projected values in red --}}
                            									        @if($row_key == 'projected_black')
                            									        
                            									            @if($value['projected_black'] > $value['budgeted_black'])
                            									                <td><span style="color:red; font-weight:bold;">{{number_format($val,0 ,0, ',')}}</span></td>
                            									            @else
                            									                <td>{{number_format($val,0 ,0, ',')}}</td>
                            									            @endif
                            									            
                            									        @elseif($row_key == 'projected_color')
                            									        
                            									            @if($value['projected_color'] > $value['budgeted_color'])
                            									                <td><span style="color:red; font-weight:bold;">{{number_format($val,0 ,0, ',')}}</span></td>
                            									            @else
                            									                <td>{{number_format($val,0 ,0, ',')}}</td>
                            									            @endif
                            									        @else
                            									            <td>{{number_format($val,0 ,0, ',')}}</td>
                            									        @endif
                            									    
                            									        
                            									    @else
                            									        <td><a href={{asset($val)}}>Go to Live Floorplan</a></td>
                            									    @endif
                            									@endforeach
                            									
                    									    </tr> 
                    									     
                    									        @php
                    									            $first_bldg = 'Y';
                                                                    $bldg_name = '';
                                                                @endphp
                    									         
                    									        @foreach($volume_totals as $rec)
                    									        
                    									            <!-- If this is the first building, assign the bldg_name to $bldg_name, then change value of $first_bldg to N -->
                                                                    @php
                                                                    if($first_bldg == 'Y'){
                                                                        $bldg_name = $rec->bldg_name;
                                                                        $first_bldg = 'N';
                                                                    }//end if $first_bldg == Y
                    									            @endphp
                    									        
                    									            <!--If the bldg_name from volume_totals = bldg_name from array_bldgs...
                    									            Then use a foreach to loop through the array_indiv_proj_vals to get the projected
                    									            values for black and color for each serial_number that matches the current serial_number
                    									            in $volume_totals-->
                    									            @if($rec->bldg_name == $key)
                    									                @php
                    									                    if($rec->is_color == 'Y'){ $mach_col = 'Color';}
                    									                    else{ $mach_col = 'Black';}
                    									                    
                    									                        foreach($array_indiv_proj_vals as $ser_num_key => $proj_val){
                            									                    $ser_num = $ser_num_key;
                            									                    if($ser_num_key == $rec->proposed_serial_number){
                            									                        $prj_blk = $array_indiv_proj_vals[$ser_num_key]['projected_black'];
                            									                        $prj_col = $array_indiv_proj_vals[$ser_num_key]['projected_color'];
                            									                        $prj_next_blk = $array_indiv_proj_vals[$ser_num_key]['proj_blk_year_next'];
                            									                        $prj_next_col = $array_indiv_proj_vals[$ser_num_key]['proj_col_year_next'];
                            									                    }
                    									                        }
                    									                @endphp
                    									            
                        									            <tr style="background-color:#f9f1c5; line-height:1em; font-size:11px;">
                        									                <td class="{{$classDef}}">{{$rec->mach_make}} - {{$rec->model}} {{$rec->room_name}}
                        									                    <br>SN: {{$rec->proposed_serial_number}} - {{$mach_col}}</td>
                        									                <td class="{{$classDef}}">{{$rec->consumed_black}}</td>
                        									                <td class="{{$classDef}}">{{number_format($rec->budgeted_black,0 ,0, ',')}}</td>
                        									                
                        									                <!--If projected black is greater than budgeted black, color projecetd black in red-->
                        									                @if($prj_blk > $rec->budgeted_black)
                        									                    <td class="{{$classDef}}"><span style="color:red; font-weight:bold;">{{number_format($prj_blk,0 ,0, ',')}}</span></td>
                        									                @else
                        									                    <td class="{{$classDef}}">{{number_format($prj_blk,0 ,0, ',')}}</td>
                        									                @endif
                        									                
                        									                <td class="{{$classDef}}">{{number_format($prj_blk,0 ,0, ',')}}</td>
                        									                <td class="{{$classDef}}"></td>
                        									                <td class="{{$classDef}}">{{number_format($prj_next_blk,0 ,0, ',')}}</td>
                        									                <td class="{{$classDef}}">{{$rec->consumed_color}}</td>
                        									                <td class="{{$classDef}}">{{number_format($rec->budgeted_color,0 ,0, ',')}}</td>
                        									                
                        									                <!--If projected color is greater than budgeted color, make projecetd color red-->
                        									                @if($prj_col > $rec->budgeted_color)
                        									                    <td class="{{$classDef}}"><span style="color:red; font-weight:bold;">{{number_format($prj_col,0 ,0, ',')}}</span></td>
                        									                @else
                        									                    <td class="{{$classDef}}">{{number_format($prj_col,0 ,0, ',')}}</td>
                        									                @endif
                        									                
                        									                
                        									                <td class="{{$classDef}}"></td>
                        									                <td class="{{$classDef}}">{{number_format($prj_next_col,0 ,0, ',')}}</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-->
                                                	
                                                    <tfoot>   
                                                    	@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
                									</tfoot>
                    							</tbody>
                    						</table><!-- end datatable -->
                    						
                    						@else
                    						
                    						    <div>There is no data matching this criteria.</div>
                    						
                    						@endif
                    					</div><!-- end panel-content -->
                    				</div><!-- end panel-container -->
                    			</div><!-- end panel-l -->
                    		  </div><!-- end col-xl-12 -->
                          </div><!-- end row -->
                      
                    </form>
                </main>
            </div><!--end row col-xl-12-->
        </div><!--end container-responsive-->
    </div><!--end row-->
</div><!--end page-content-->

@endsection