%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream

nadelinn - rinduu

Command :

ikan Uploader :
Directory :  /var/www/html/shardahospital.org/incident/application/views/
Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 
Current File : /var/www/html/shardahospital.org/incident/application/views/admindashboard.php
<div class="wrapper d-flex align-items-stretch">

<?php include('_parts/admin_sidebar.php') ?>

<div id="content">
<?php include('_parts/admin_internal_header.php') ?>
	<section id="main-content">
	
 			   <div class="container-fluid">
			   
				<div class="top-dash-sec white-box">
					 <?php if(!in_array($_SESSION['ADMIN_DETAILS']['role'], array('1','10'))){?>
					 <div class="headings"><h4> <i class="fa fa-dashboard" aria-hidden="true"></i>Dashboard</h4> </div>
					 <?php } ?>
					<div class="container-fluid">
							<div class="row">
								<?php if(in_array($_SESSION['ADMIN_DETAILS']['role'], array('1','10'))){ ?>
								<div class="col-md-9">
								<div class="export-div">
									<h3>Export Report</h3>
									
									
								  </div>
								  </div>
								  <div class="col-md-3"> 
								   <div class="export-div">
										<button  data-bs-toggle="modal" data-bs-target="#Export-Report" class="btn button1  button1-ex">Export Report </button>                   
									<div class="clearfix"></div>
									</div>	
									</div>
								
								<?php }?>
							</div>    
					</div>   
				</div>
          </div> 
          <!-- The Modal -->
          
<div class="modal fade" id="Export-Report" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true" style="display:none;">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Export Report</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
      <form method="POST" class="export-popup" id="exportgrievanceform">
 						<select name="selectgrievances" id="selectgrievances" >
						    <option value="">Select Incident </option>
							<option value="new_grievances">Total Incident </option>
							<option value="pending_grievances">Pending Incident </option>
							<option value="closed_grievances">Closed Incident </option>
                        </select>
						<span>Date From :</span><input type="date" name="grievance_from" id="grievance_from" max="<?=date('Y-m-d')?>">
						<span>Date To: </span><input type="date" name="grievance_to" id="grievance_to" max="<?=date('Y-m-d')?>" onchange="return validatedate()">
                        
						<input type="submit" class="btn button1" name="exportgrievances" id="exportgrievances" value="Export Report" >
                    </form>
      </div>
       
    </div>
  </div>
</div>
<!--<div id="myModal" class="modal-new">
  
  <div class="modal-content new-modal-con">
    <span class="close">&times;</span>
	<form method="POST" class="export-popup" id="exportgrievanceform">
    	<h3>Export Report</h3>
						<select name="selectgrievances" id="selectgrievances" >
						    <option value="">Select Grievance</option>
							<option value="new_grievances">New Grievances</option>
							<option value="pending_grievances">Pending Grievances</option>
							<option value="closed_grievances">Closed Grievances</option>
                        </select>
						<span>Date From :</span><input type="date" name="grievance_from" id="grievance_from" max="<?=date('Y-m-d')?>">
						<span>Date To: </span><input type="date" name="grievance_to" id="grievance_to" max="<?=date('Y-m-d')?>" onchange="return validatedate()">
                        
						<input type="submit" class="btn button1" name="exportgrievances" id="exportgrievances" value="Export Report"  disabled>
                    </form>	
  </div>
  
</div>-->
        	<?php $divClass = "" ;if($_SESSION['ADMIN_DETAILS']['role'] == '1' || $_SESSION['ADMIN_DETAILS']['role'] == '10'){ $divClass  = "col-sm-2" ;} else { $divClass  = "col-sm-3" ;}?>
                <div class="top-3-sec" >	
                <div class="container-fluid">
            <div class="row">		  			
				<div class="<?=$divClass?>"><a href="<?=base_url('complaints/newgrievance')?>">
					<div class="box color3">
						 <div class="icon">
									<?php echo count($processed_complaints);?>
								</div> 
                             <div class="detail"> 
                             
					  			<h6>Total Incident </h6>
					  			
								
                  			</div>
                  			</div>
					  		</a>	
                  		</div>
				<?php if(in_array($_SESSION['ADMIN_DETAILS']['role'], array('1','2','3','7'))){ ?>		
				<div class="<?=$divClass?>"><a href="<?=base_url('complaints/notprocessedgrievance')?>">
					<div class="box color4">
						 <div class="icon">
									<?php echo count($notprocessed_complaints);?>
								</div> 
                             <div class="detail"> 
                             
					  			<h6>Not Processed</h6>
					  			
								
                  			</div>
                  			</div>
					  		</a>	
                </div>
				<?php } ?>
					<div class="<?=$divClass?>"><a href="<?=base_url('complaints/pendinggrievance')?>">
                        <div class="box color1">
							 <div class="icon">
									<?php echo count($pending_complaints);?>
							</div> 
						<div class="detail">
                        
						<h6>Pending Incident </h6>
							
						</div>
                    </div>
				</a></div>
                <div class="<?=$divClass?>"><a href="<?=base_url('complaints/closedgrievance')?>">
					<div class="box color2">
						 <div class="icon"><?php echo count($closed_complaints);?></div> 
						<div class="detail">
                        
                        <h6>Resolved Incident </h6>
							
						</div>
					</div>
				</a></div> 
                
                <?php if($_SESSION['ADMIN_DETAILS']['role'] == '1' || $_SESSION['ADMIN_DETAILS']['role'] == '10'){?>
				
				<div class="col-sm-3">
				<a href="<?=base_url('complaints/pushbackincident')?>">
					<div class="box color4">
						  <div class="icon">
									<?php echo count($pushback_complaints);?>
								</div> 
                             <div class="detail"> 
                              
					  			<h6>Push Back</h6>
					  			
								
                  			</div>
                  			</div>
					  </a>			
                  		</div>
				<div class="col-sm-3">
					<div class="box color4">
						  <div class="icon">
									<?php echo $averageFirstResponse;?>
								</div> 
                             <div class="detail"> 
                              
					  			<h6>Avg. no. of days for first response</h6>
					  			
								
                  			</div>
                  			</div>
					  			
                  		</div>
					<div class="col-sm-3">
                        <div class="box color5">
							 <div class="icon">
									<?php echo $averageClosureDate;?>
							</div> 
						<div class="detail">
                        
						<h6>Avg. no. of days for closure</h6>
							
						</div>
                    </div>
				</div> 
               
                <?php }?>
                
                
                </div>
                </div> 
                </div>      
                
          <!-- /row mt -->	
        
		<div class="main-chart" style="display:none;">
			<div class="main-chart-in">
            <div class="container-fluid">
            <div class="row">	
				<div class="col-sm-6"><div class="chart-inner"> <div id="chartContainer" style="height: 300px; width: 100%;"> </div></div></div>
				<div class="col-sm-6"><div class="chart-inner"><div id="circleChartContainer" style="height: 300px; width: 100%;"></div></div></div>
				<?php //if(empty($_SESSION['MODULE_LIST'])) {
					if($_SESSION['ADMIN_DETAILS']['role'] == '1' || $_SESSION['ADMIN_DETAILS']['role'] == '10'){  ?>
					<div class="col-sm-12"><div class="chart-inner"> <div id="chartSchoolContainer" style="height: 300px; width: 100%;"> </div> </div></div>
				<?php } ?>
			</div>
			<?php 
				$total = count($processed_complaints)+count($pending_complaints)+count($closed_complaints);
			?>
		</div> 
        </div>
        </div>
    <?php if($_SESSION['ADMIN_DETAILS']['role'] == '1' || $_SESSION['ADMIN_DETAILS']['role'] == '10'){   ?>    
    <div class="container-fluid" style="display:none;">
        <div class="row">
			<div class="col-sm-12">
			<h4>Data Filter (N=New,P=Pending,R=Resolved)</h4>
			</div>				
            <div class="col-sm-6">
            	<div class="department-sec">
            		<h4>Department wise/school wise</h4>
                    
                    
                    <!--<ul class="nav-departent nav-tabs first-nav" id="myTab">
                    	<li class="active"><a href="#academic1">Academic</a></li>
                    	<li class=""><a href="#non-Academic1">non-Academic</a></li>
                    </ul>-->
                    <div class="tab-content">
                    <label><input type="radio" name="academic1" checked="checked" value="2"  /> Academic </label>
   					<label><input type="radio" name="academic1" value="3" /> non-Academic</label>
                    
            		<div id="academic12" class="department-inner first-con main-body1">
						<table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>School</th>
								<th>Department</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($departmentArrayAcademic as $row){
									$processedschooldeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'Not Processed','category' =>'academic'),NULL,NULL));
									$pendingschooldeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'in process','category' =>'academic'),NULL,NULL)); 
									$resolvedschooldeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'closed','category' =>'academic'),NULL,NULL));  
									$progriev = $processedschooldeptwisegriev != '' ? $processedschooldeptwisegriev.' N '  : '' ;
									$pengriev = $pendingschooldeptwisegriev != '' ? $pendingschooldeptwisegriev.' P '  : '';
									$resgriev = $resolvedschooldeptwisegriev != '' ? $resolvedschooldeptwisegriev.' R'  : ''; 
									?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$schoolList[$row['school_id']]?></td>
									<td><?=$row['name']?></td>
									<td><?php if($progriev =='' && $pengriev=='' && $resgriev=='') {echo '-';} else { echo $progriev;if(empty($progriev) && !empty($pengriev)){ echo $pengriev;}else if(!empty($progriev) && !empty($pengriev)){echo ','.$pengriev;} if(empty($progriev) && empty($pengriev) && !empty($resgriev)) { echo $resgriev;} else if((empty($progriev) && !empty($pengriev) && !empty($resgriev)) || (!empty($progriev) && empty($pengriev) && !empty($resgriev)) || (!empty($progriev) && !empty($pengriev) && !empty($resgriev))){ echo ','.$resgriev;}}  ?></td>
								</tr>
								<?php }?>
							</tbody>
	                   </table>
                     
                    </div>
                    <div id="academic13" class="department-inner first-con main-body1" style="display:none;">
					<table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Department</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($departmentArrayNonAcademic as $row){
									$processeddeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'Not Processed','category' =>'non-academic'),NULL,NULL));
									$pendingdeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'in process','category' =>'non-academic'),NULL,NULL)); 
									$resolveddeptwisegriev = count(getTotalNoOfGrievances('tblcomplaints',array('school_id'=>$row['school_id'],'department_id'=>$row['id'],'status'=>'closed','category' =>'non-academic'),NULL,NULL));  
									$progriev1 = $processeddeptwisegriev != '' ? $processeddeptwisegriev.' N '  : '' ;
									$pengriev1 = $pendingdeptwisegriev != '' ? $pendingdeptwisegriev.' P '  : '';
									$resgriev1 = $resolveddeptwisegriev != '' ? $resolveddeptwisegriev.' R'  : '';
									?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$row['name']?></td>
									<td><?php if($progriev1 =='' && $pengriev1=='' && $resgriev1=='') {echo '-';} else { echo $progriev1;if(empty($progriev1) && !empty($pengriev1)){ echo $pengriev1;}else if(!empty($progriev1) && !empty($pengriev1)){echo ','.$pengriev1;} if(empty($progriev1) && empty($pengriev1) && !empty($resgriev1)) { echo $resgriev1;} else if((empty($progriev1) && !empty($pengriev1) && !empty($resgriev1)) || (!empty($progriev1) && empty($pengriev1) && !empty($resgriev1)) || (!empty($progriev1) && !empty($pengriev1) && !empty($resgriev1))){ echo ','.$resgriev1;}} ?></td>
								
								</tr>
								<?php }?>
							</tbody>
	                   </table>
                    </div>
                    </div>
            	</div>
            
            </div>
            <div class="col-sm-6">
            	<div class="department-sec">
            		<h4>id wise incident </h4>
                    <div class="tab-content">
                    <label><input type="radio" name="idw" checked="checked" value="2"  /> Academic </label>
   					<label><input type="radio" name="idw" value="3" /> non-Academic</label>
					
            		<div id="idw2" class="department-inner first-con1 main-body1">
					    <table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Admin ID</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($adminArrayAcademic as $row){
									$tbl_name = 'tblcomplaints';
									$where_id = explode(',',$row['ngrievance_type']);
									if(!empty($row['department_id'])){
									$processedadminacademicgriev = array('school_id'=>$row['school_id'],'department_id'=>$row['department_id'],'status'=>'Not Processed');
									$pendingadminacademicgriev = array('school_id'=>$row['school_id'],'department_id'=>$row['department_id'],'status'=>'in process'); 
									$resolvedadminacademicgriev = array('school_id'=>$row['school_id'],'department_id'=>$row['department_id'],'status'=>'closed');  
								   }else if($row['school_id'] != '99'){
									$processedadminacademicgriev = array('school_id'=>$row['school_id'],'status'=>'Not Processed');
									$pendingadminacademicgriev = array('school_id'=>$row['school_id'],'status'=>'in process'); 
									$resolvedadminacademicgriev = array('school_id'=>$row['school_id'],'status'=>'closed');
								   }else{
									$processedadminacademicgriev = array('status'=>'Not Processed','category' =>'academic');
									$pendingadminacademicgriev = array('status'=>'in process','category' =>'academic'); 
									$resolvedadminacademicgriev = array('status'=>'closed','category' =>'academic');
								   }
								   if($row['user_level'] == 'L2'){
									$tbl_name = 'tbl_leveltwo_complaints'; 
									$where_id = '';
								   }
								   else if($row['user_level'] == 'L3'){
									$tbl_name = 'tbl_levelthree_complaints'; 
									$processedadminacademicgriev= array('status'=>'Not Processed');
									$pendingadminacademicgriev= array('status'=>'in Process');
									$resolvedadminacademicgriev= array('status'=>'closed');
									$where_id = '';
								   }
								    $totalprocessedcomplaints = count(getTotalNoOfGrievances($tbl_name,$processedadminacademicgriev,'grievance_type',$where_id));
									$totalpendingcomplaints = count(getTotalNoOfGrievances($tbl_name,$pendingadminacademicgriev,'grievance_type',$where_id)); 
									$totalresolvedcomplaints = count(getTotalNoOfGrievances($tbl_name,$resolvedadminacademicgriev,'grievance_type',$where_id));  
								    $progriev2 = $totalprocessedcomplaints != '' ? $totalprocessedcomplaints.' N '  : '' ;
									$pengriev2 = $totalpendingcomplaints != '' ? $totalpendingcomplaints.' P '  : '';
									$resgriev2 = $totalresolvedcomplaints != '' ? $totalresolvedcomplaints.' R'  : '';
								    ?>								
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$row['username']?></td>
									<td><?php if($progriev2 =='' && $pengriev2=='' && $resgriev2=='') {echo '-';} else { echo $progriev2;if(empty($progriev2) && !empty($pengriev2)){ echo $pengriev2;}else if(!empty($progriev2) && !empty($pengriev2)){echo ','.$pengriev2;} if(empty($progriev2) && empty($pengriev2) && !empty($resgriev2)) { echo $resgriev2;} else if((empty($progriev2) && !empty($pengriev2) && !empty($resgriev2)) || (!empty($progriev2) && empty($pengriev2) && !empty($resgriev2)) || (!empty($progriev2) && !empty($pengriev2) && !empty($resgriev2))){ echo ','.$resgriev2;}} ?></td>
									
								</tr>
								<?php }?>
							</tbody>
	                    </table>
                    </div>
					<div id="idw3" class="department-inner first-con1 main-body1" style="display:none;">
					    <table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Admin ID</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($adminArrayNonAcademic as $row){
									$tbl_name = 'tblcomplaints';
									if(!empty($row['department_id'])){
									$processedadminnonacademicgriev = array('department_id'=>$row['department_id'],'status'=>'Not Processed','category' =>'non-academic');
									$pendingadminnonacademicgriev = array('department_id'=>$row['department_id'],'status'=>'in process','category' =>'non-academic'); 
									$resolvedadminnonacademicgriev = array('department_id'=>$row['department_id'],'status'=>'closed','category' =>'non-academic');  
								   }

								   if($row['user_level'] == 'L2'){
									$tbl_name = 'tbl_leveltwo_complaints'; 
									$processedadminnonacademicgriev= array('status'=>'Not Processed','category' =>'non-academic');
									$pendingadminnonacademicgriev= array('status'=>'in Process','category' =>'non-academic');
									$resolvedadminnonacademicgriev= array('status'=>'closed','category' =>'non-academic');
								   }
								   else if($row['user_level'] == 'L3'){
									$tbl_name = 'tbl_levelthree_complaints'; 
									$processedadminnonacademicgriev= array('status'=>'Not Processed','category' =>'non-academic');
									$pendingadminnonacademicgriev= array('status'=>'in Process','category' =>'non-academic');
									$resolvedadminnonacademicgriev= array('status'=>'closed','category' =>'non-academic');
								   }
								    $totalprocessedcomplaintsnonacademic = count(getTotalNoOfGrievances($tbl_name,$processedadminnonacademicgriev));
								    $totalpendingcomplaintsnonacademic = count(getTotalNoOfGrievances($tbl_name,$pendingadminnonacademicgriev));
								    $totalresolvedcomplaintsnonacademic = count(getTotalNoOfGrievances($tbl_name,$resolvedadminnonacademicgriev));
								    $progriev3 = $totalprocessedcomplaintsnonacademic != '' ? $totalprocessedcomplaintsnonacademic.' N '  : '' ;
									$pengriev3 = $totalpendingcomplaintsnonacademic != '' ? $totalpendingcomplaintsnonacademic.' P '  : '';
									$resgriev3 = $totalresolvedcomplaintsnonacademic != '' ? $totalresolvedcomplaintsnonacademic.' R'  : '';
								    ?>								
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$row['username']?></td>
									<td><?php if($progriev3 =='' && $pengriev3=='' && $resgriev3=='') {echo '-';} else { echo $progriev3;if(empty($progriev3) && !empty($pengriev3)){ echo $pengriev3;}else if(!empty($progriev3) && !empty($pengriev3)){echo ','.$pengriev3;} if(empty($progriev3) && empty($pengriev3) && !empty($resgriev3)) { echo $resgriev3;} else if((empty($progriev3) && !empty($pengriev3) && !empty($resgriev3)) || (!empty($progriev3) && empty($pengriev3) && !empty($resgriev3)) || (!empty($progriev3) && !empty($pengriev3) && !empty($resgriev3))){ echo ','.$resgriev3;}} ?></td>
									
								</tr>
								<?php }?>
							</tbody>
	                    </table>
                    </div>
					</div>
            	</div>
            
            </div>
                        
            <div class="col-sm-6">
            	<div class="department-sec">
            		<h4>Recurring incident </h4>
                    <div class="tab-content">
                    <label><input type="radio" name="catw" checked="checked" value="2"  /> Academic </label>
   					<label><input type="radio" name="catw" value="3" /> non-Academic</label>
                    
            		<div id="catw2" class="department-inner first-con2 main-body1">
					    <table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Incident  Type</th>
								<th>Count</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($mostRecurringArrayAcademic as $row){ ?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$grievanceArray[$row['grievance_type']]['grievance_name']?></td>
									<td><?=$row['no_grievances']?></td>									
								</tr>
								<?php }?>
							</tbody>
	                    </table>
                    </div>
					<div id="catw3" class="department-inner first-con2 main-body1" style="display:none;">
					    <table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Incident  Type</th>
								<th>Count</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($mostRecurringArrayNonAcademic as $row){ ?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$grievanceArray[$row['grievance_type']]['grievance_name']?></td>
									<td><?=$row['no_grievances']?></td>									
								</tr>
								<?php }?>
							</tbody>
	                    </table>
					</div>   
					</div>
            	</div>
            
            </div>
            
            <div class="col-sm-6">
            	<div class="department-sec">
            		<h4>All Incident  Types</h4>
                   <div class="tab-content">
                    <label><input type="radio" name="allg" checked="checked" value="2"  /> Academic </label>
   					<label><input type="radio" name="allg" value="3" /> non-Academic</label>
                    
            		<div id="allg2" class="department-inner first-con3 main-body1">
                        <table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Incident Type</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($grievanceArrayAcademic as $row){
									$processedacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'Not Processed','category' =>'academic'),NULL,NULL));
									$pendingacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'in process','category' =>'academic'),NULL,NULL)); 
									$resolvedacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'closed','category' =>'academic'),NULL,NULL)); 
									$progriev4 = $processedacademicgriev != '' ? $processedacademicgriev.' N '  : '' ;
									$pengriev4 = $pendingacademicgriev != '' ? $pendingacademicgriev.' P '  : '';
									$resgriev4 = $resolvedacademicgriev != '' ? $resolvedacademicgriev.' R'  : ''; ?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$row['grievance_name']?></td>
									<td><?php if($progriev4 =='' && $pengriev4=='' && $resgriev4=='') {echo '-';} else { echo $progriev4;if(empty($progriev4) && !empty($pengriev4)){ echo $pengriev4;}else if(!empty($progriev4) && !empty($pengriev4)){echo ','.$pengriev4;} if(empty($progriev4) && empty($pengriev4) && !empty($resgriev4)) { echo $resgriev4;} else if((empty($progriev4) && !empty($pengriev4) && !empty($resgriev4)) || (!empty($progriev4) && empty($pengriev4) && !empty($resgriev4)) || (!empty($progriev4) && !empty($pengriev4) && !empty($resgriev4))){ echo ','.$resgriev4;}} ?></td>
									
								</tr>
								<?php }?>
							</tbody>
	                    </table>
                    </div>
					<div id="allg3" class="department-inner first-con3 main-body1" style="display:none;">
					<table class="table3">
							<thead>
							<tr>
								<th>S.No</th>
								<th>Incident  Type</th>
								<th>Result</th>
								
							</tr>
							</thead>
							<tbody>
								<?php $cnt = 1; foreach($grievanceArrayNonAcademic as $row){
									$processednonacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'Not Processed','category' =>'non-academic'),NULL,NULL));
									$pendingnonacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'in process','category' =>'non-academic'),NULL,NULL)); 
									$resolvednonacademicgriev = count(getTotalNoOfGrievances('tblcomplaints',array('grievance_type'=>$row['id'],'status'=>'closed','category' =>'non-academic'),NULL,NULL));  
									$progriev5 = $processednonacademicgriev != '' ? $processednonacademicgriev.' N '  : '' ;
									$pengriev5 = $pendingnonacademicgriev != '' ? $pendingnonacademicgriev.' P '  : '';
									$resgriev5 = $resolvednonacademicgriev != '' ? $resolvednonacademicgriev.' R'  : ''; ?>
								<tr>
									<td><?=$cnt++?></td>
									<td><?=$row['grievance_name']?></td>
									<td><?php if($progriev5 =='' && $pengriev5=='' && $resgriev5=='') {echo '-';} else { echo $progriev5;if(empty($progriev5) && !empty($pengriev5)){ echo $pengriev5;}else if(!empty($progriev5) && !empty($pengriev5)){echo ','.$pengriev5;} if(empty($progriev5) && empty($pengriev5) && !empty($resgriev5)) { echo $resgriev5;} else if((empty($progriev5) && !empty($pengriev5) && !empty($resgriev5)) || (!empty($progriev5) && empty($pengriev5) && !empty($resgriev5)) || (!empty($progriev5) && !empty($pengriev5) && !empty($resgriev5))){ echo ','.$resgriev5;}} ?></td>
									
								</tr>
								<?php }?>
							</tbody>
	                   </table>
					</div>   
					</div>
            	</div>
            
            </div>
            
        </div>
    </div>
    <?php } ?>    
    <?php if($processed_complaints){?>
     <div class="container-fluid" style="display:none;">
            <div class="row">	
            <div class="col-sm-12">
    <div class="responsive table-secs main-body1">
					<table class="table3">
						<thead>
						<tr>
							<th>S. No</th>
							<th>Grievances id</th>
							<th>Category</th>
							<th>Nature of Incident </th>
							<th>Incident  Description</th>
							<th>Reg. Date</th>
							<th>Priority</th>
						</tr>
						</thead>
						<tbody>									
							
								<?php
								$i=1;
								foreach($processed_complaints as $complaints){
								$priority = '<span style="color: #fff;background-color: green;padding: 4px;">new</span>';
								$diff = (strtotime(date('Y-m-d'))-strtotime(date('Y-m-d',strtotime($complaints['regDate']))))/60/60/24;
								if($diff>2){
									$priority = '<span style="color: #000;background-color: yellow;padding: 4px;">Critical</span>';
								} if($diff>=4){
									$priority = '<span style="color: #fff;background-color: red;padding: 4px;">Urgent</span>';
								}
								?>
								<tr>
								<td><?=$i?></td>
								<td><?=$complaints['compNumber']?></td>
								<td><?=$complaints['category']?></td>
								<td><?=$grievanceArray[$complaints['grievance_type']]['grievance_name']?></td>
								<td><?=substr(htmlentities($complaints['complaindetails']),0,100);?></td>
								<td><?php echo htmlentities($complaints['regDate']);?></td>
								<td><?=$priority?></td>
							</tr>	
							<?php $i++;} ?>							
					</tbody></table>
                    </div>
                    </div>
				</div>
                </div>
				<?php }?>
     
  <script type="text/javascript">
  window.onload = function () {
   var chart = new CanvasJS.Chart("chartContainer", {
	theme: "light2", // "light1", "light2", "dark1", "dark2"
	exportEnabled: true,
	animationEnabled: true,
	title: {
		text: "Over All Incident "
	},
	data: [{
		type: "pie",
		startAngle: 25,
		dataPoints: [
			{ y: <?=count($processed_complaints)?>, label: "Total" },
			{ y: <?=count($pending_complaints)?>, label: "Inprogress" },
			{ y: <?=count($closed_complaints)?>, label: "Closed" }
		]
	}]
});
chart.render();

   var chart = new CanvasJS.Chart("circleChartContainer", {
	theme: "light2", // "light1", "light2", "dark1", "dark2"
	exportEnabled: true,
	animationEnabled: true,
	title: {
		text: "<?=date('M Y')?> Stats"
	},
	data: [{
		type: "pie",
		startAngle: 25,
		dataPoints: [
			{ y: <?=count($processedMonthlycomplaints)?>, label: "Total" },
			{ y: <?=count($pendingMonthlycomplaints)?>, label: "Inprogress" },
			{ y: <?=count($closedMonthlycomplaints)?>, label: "Closed" }
		]
	}]
});
chart.render();

  // School Wise Chart
  var chart = new CanvasJS.Chart("chartSchoolContainer",
  {
	theme: "light2", // "light1", "light2", "dark1", "dark2"
	exportEnabled: true,
	animationEnabled: true,
	title: {
		text: "Business Unit Wise Incident "
	},
    axisY: {
      title: "Count",
      interlacedColor: "Azure",
      interval: 100,
      tickColor: "navy",
      gridColor: "navy",
      tickLength: 10
    },
    data: [
      { 
        showInLegend: true,           
        legendText: "New Incident ",
		axisYType: "secondary",
        dataPoints: [
		{label: "<?=$schoolList[2]?>", y: <?=$processedstatsArray[2]?>},
        {label: "<?=$schoolList[3]?>", y: <?=$processedstatsArray[3]?>},
        {label: "<?=$schoolList[4]?>", y: <?=$processedstatsArray[4]?>0},
        {label: "<?=$schoolList[5]?>", y: <?=$processedstatsArray[5]?>},
        {label: "<?=$schoolList[6]?>", y: <?=$processedstatsArray[6]?>},
        {label: "<?=$schoolList[7]?>", y: <?=$processedstatsArray[7]?>},
        {label: "<?=$schoolList[8]?>", y: <?=$processedstatsArray[8]?>},
        {label: "<?=$schoolList[9]?>", y: <?=$processedstatsArray[9]?>},
        {label: "<?=$schoolList[10]?>", y: <?=$processedstatsArray[10]?>},
        {label: "<?=$schoolList[11]?>", y: <?=$processedstatsArray[11]?>},
        {label: "<?=$schoolList[12]?>", y: <?=$processedstatsArray[12]?>},
        {label: "<?=$schoolList[13]?>", y: <?=$processedstatsArray[13]?>},
        {label: "<?=$schoolList[99]?>", y: <?=$processedstatsArray[99]?>}      
        ]
      },
      {        
		showInLegend: true, 
		legendText: "Inprogress",
		axisYType: "secondary",
		dataPoints: [
     	{label: "<?=$schoolList[2]?>", y: <?=$pendingstatsArray[2]?>},
        {label: "<?=$schoolList[3]?>", y: <?=$pendingstatsArray[3]?>},
        {label: "<?=$schoolList[4]?>", y: <?=$pendingstatsArray[4]?>0},
        {label: "<?=$schoolList[5]?>", y: <?=$pendingstatsArray[5]?>},
        {label: "<?=$schoolList[6]?>", y: <?=$pendingstatsArray[6]?>},
        {label: "<?=$schoolList[7]?>", y: <?=$pendingstatsArray[7]?>},
        {label: "<?=$schoolList[8]?>", y: <?=$pendingstatsArray[8]?>},
        {label: "<?=$schoolList[9]?>", y: <?=$pendingstatsArray[9]?>},
        {label: "<?=$schoolList[10]?>", y: <?=$pendingstatsArray[10]?>},
        {label: "<?=$schoolList[11]?>", y: <?=$pendingstatsArray[11]?>},
        {label: "<?=$schoolList[12]?>", y: <?=$pendingstatsArray[12]?>},
        {label: "<?=$schoolList[13]?>", y: <?=$pendingstatsArray[13]?>},
        {label: "<?=$schoolList[99]?>", y: <?=$pendingstatsArray[99]?>}  
		]
      },
      {        
		showInLegend: true, 
		legendText: "Closed",
		axisYType: "secondary",
		dataPoints: [
		{label: "<?=$schoolList[2]?>", y: <?=$closedstatsArray[2]?>},
        {label: "<?=$schoolList[3]?>", y: <?=$closedstatsArray[3]?>},
        {label: "<?=$schoolList[4]?>", y: <?=$closedstatsArray[4]?>0},
        {label: "<?=$schoolList[5]?>", y: <?=$closedstatsArray[5]?>},
        {label: "<?=$schoolList[6]?>", y: <?=$closedstatsArray[6]?>},
        {label: "<?=$schoolList[7]?>", y: <?=$closedstatsArray[7]?>},
        {label: "<?=$schoolList[8]?>", y: <?=$closedstatsArray[8]?>},
        {label: "<?=$schoolList[9]?>", y: <?=$closedstatsArray[9]?>},
        {label: "<?=$schoolList[10]?>", y: <?=$closedstatsArray[10]?>},
        {label: "<?=$schoolList[11]?>", y: <?=$closedstatsArray[11]?>},
        {label: "<?=$schoolList[12]?>", y: <?=$closedstatsArray[12]?>},
        {label: "<?=$schoolList[13]?>", y: <?=$closedstatsArray[13]?>},
        {label: "<?=$schoolList[99]?>", y: <?=$closedstatsArray[99]?>}  
        ]
      }

      ]
  });

  chart.render();
  
//   $("#selectgrievances").change(function(){
// 	  this.form.submit();
//   });

 

 }

 $(document).ready(function() {
					$("input[name$='academic1']").click(function() {
						var test = $(this).val();
				
						$("div.first-con").hide();
						$("#academic1" + test).show();
					});
					$("input[name$='idw']").click(function() {
						var test = $(this).val();
				
						$("div.first-con1").hide();
						$("#idw" + test).show();
					});
					$("input[name$='catw']").click(function() {
						var test = $(this).val();
				
						$("div.first-con2").hide();
						$("#catw" + test).show();
					});
					$("input[name$='allg']").click(function() {
						var test = $(this).val();
				
						$("div.first-con3").hide();
						$("#allg" + test).show();
					});

				});

				function validatedate(){
					var grievance_from = $('#grievance_from').val();
					var grievance_to = $('#grievance_to').val();
                if(grievance_from ==''){
					alert("Date From must not be empty");
					$('#grievance_to').val('');
				}
				if(grievance_to < grievance_from){
					alert("Date To must be greater than or equal to Date From");
					$('#grievance_to').val('');
				}
				}

// Get the modal
var modal = document.getElementById("myModal");

// Get the button that opens the modal
var btn = document.getElementById("myBtn");

// Get the <span> element that closes the modal
var span = document.getElementsByClassName("close")[0];

// When the user clicks the button, open the modal 
btn.onclick = function() {
  modal.style.display = "block";
}

// When the user clicks on <span> (x), close the modal
span.onclick = function() {
  modal.style.display = "none";
  document.getElementById("exportgrievanceform").reset();
  $('#exportgrievances').attr("disabled", true);
}

// When the user clicks anywhere outside of the modal, close it
window.onclick = function(event) {
  if (event.target == modal) {
    modal.style.display = "none";
	document.getElementById("exportgrievanceform").reset();
    $('#exportgrievances').attr("disabled", true);
  }
}

$(document).ready(function() {
	$('#exportgrievances').prop('disabled', true);
     $('#selectgrievances').change(function() {
        if($(this).val() != '') {
           $('#exportgrievances').prop('disabled', false);
        }else { $('#exportgrievances').prop('disabled', true); }
     });
});

</script>
<script src="<?= base_url('assets/js/canvasjs.js') ?>"></script>

<script>
$('#myTab a').click(function (e) {
  e.preventDefault()
  $(this).tab('show')
})
</script>
 </section>
 </div>
 </div>
 
 
  <script src="<?=base_url('assets/js/popper.js'); ?>"></script>
<script src="<?=base_url('assets/js/main.js'); ?>"></script>

Kontol Shell Bypass