%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
<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">×</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>