EVOLUTION-NINJA

Edit File: labour_user_report.php

<?php

echo view('includes/labour-user-reports-header');    
?>

<div class="col-sm-9" >
 
    <div class="row pt-5">
    <div class="col-sm-3">
    <label><b>From Date:</b></label>
    <input type="date"   class="form-control from_date"  name="from_date" value="<?php echo session()->get('l_from_date'); ?>" >
    </div>
    <div class="col-sm-3">
    <label><b>To Date:</b></label>
    <input type="date"   class="form-control to_date"  name="to_date"  value="<?php echo session()->get('l_to_date'); ?>">
    </div>
    <div class="col-sm-6" style="margin-top: 30px;">
    <button type="button" class="btn btn-primary" >Apply</button>
    </div>
    </div>

<div class="reports-right pt-4"    >
    <input id="save-pdf" type="button" value="Save as PDF"  />
    <div id="chart_div"></div>
<div class="col-sm-9" id="reports-pdf"  >
<h3 class="mt-2 mb-3 pt-2 txt-center"><u>Labour Reports</u></h3>
    <h3 class="mt-4 pt-5">Audit Result</h3>

<br />
    
    <div class="row">
      <div class="col-sm-5">
        <div class="report-detail-tag">
          <h4 class="mb-4">Report Details</h4>

<h5>From Date : <span id="from_date"><?php echo date('d-m-Y',strtotime(session()->get('l_from_date'))); ?></span></h5>
          <h5>To Date : <span id="to_date"><?php echo date('d-m-Y',strtotime(session()->get('l_to_date'))); ?></span></h5>
          <h5>Reported by :<span id="reported_by"><?php $name =  session()->get('l_name');  
							if(substr($name, 0, 3) === "Dr. " || substr($name, 0, 3) === "Dr "){
							 echo	session()->get('l_name');
							}else{
								echo "Dr. ".session()->get('name');
							} ?></span></h5>
        </div>
      </div>
      <div class="col-sm-7"></div>
    </div>
    
    <div class="row">
      <div class="col-sm-5 table-responsive" id="demo-table">
      <?php if($total == 0){  ?>
                      <h4>No Data Found</h4>
                      
                      
          <?php   }else{  ?>

<table
      class="table table-bordered"
      style="height: 200px; width: 100%"
      id="mytable"
      >
      <thead>
        <tr>
        <th>Characteristics</th>
        <th>n</th>
    
        </tr>
      </thead>
      <tbody>
        <tr>
        <td>
          <p>Cases recorded with minimum data set - <b>N'</b></p>
        </td>
        <td>
          <p><?php echo $total; ?></p>
        </td>
        </tr>
        <tr>
        <td>
          <p>Cases with complete entry - <strong>N<sub>c</sub></strong></p>
        </td>
        <td>
          <p><?php echo $total_nc; ?></p>
        </td>
      </tr>
      </tbody>
      </table>
    </div>
</div>

<div class="reports-right pt-4">
  
    <div id="chart_div"></div>
    <h3 class="mt-4">Procedure</h3>

<br />
    <div class="row">
    <div class="col-sm-5" id="demo-table">
      <table
      class="table table-bordered"
      style="height: 200px; width: 100%"
      id="mytable"
      >
      <thead>
        <tr>
        <th>Characteristics</th>
        <th>n</th>
        <th>Percentage</th>
        </tr>
      </thead>
      <tbody>
        <tr>
        <td>
          <p>Combined Spinal Epidural <b>Ncse</b></p>
        </td>
        <td>
          <p><?php echo $cse_total; ?></p>
        </td>
        <td>
          <p><?php echo number_format((float)(($cse_total/$total)*100), 1, '.', '')."%";?></p>
        </td>
        </tr>
        <tr>
        <td>
          <p>Epidural alone <strong>N<sub>e</sub></strong></p>
        </td>
        <td>
          <p><?php echo $e_total; ?></p>
        </td>
        <td>
          <p><?php echo number_format((float)(($e_total/$total)*100), 1, '.', '')."%"; ?></p>
        </td>
        </tr>
        <tr>
        <td>
          <p>Spinal alone <strong>N<sub>s</sub></strong></p>
        </td>
        <td>
          <p><?php echo $s_total; ?></p>
        </td>
        <td>
          <p><?php echo number_format((float)(($s_total/$total)*100), 1, '.', '')."%";  ?></p>
        </td>
        </tr>
        <tr>
        <td>
          <p>CSA - Continuous Spinal Anaesthesia <strong>N<sub>csa</sub></strong></p>
        </td>
        <td>
          <p><?php echo $csa_total; ?></p>
        </td>
        <td>
          <p><?php echo number_format((float)(($csa_total/$total)*100), 1, '.', '')."%"; ?></p>
        </td>
        </tr>
      </tbody>
      </table>
    </div>
    <div class="col-sm-7">
        <div id="procedureGoogleTableChart"style="height: 200px; width: 100%"></div>
    </div>
    
    </div>
    <br />

</div>

<div class="consolidated-results">
    <h3>Labour Consolidated Results</h3>
    <p class="cons-p"><b>Date range displayed (Start and End date)</b></p>
    <div class="table-1">
      <div class="row">
        <div class="col-sm-8">
        
          <div class="table-responsive">
            <table class="table table-bordered table-striped">
              <thead>
                <tr>
                  <th>Characteristics</th>
                  <th>Stats</th>
                </tr>
              </thead>
              <tbody>
                <tr>
                  <td>
                    <p>Total number of cases recorded with minimum data set</p>
                  </td>
                  <td><p><b>N'</b></p></td>
                </tr>
                <tr>
                  <td><p>Total number of cases with complete entry</p></td>
                  <td><p>Nc</p></td>
                </tr>
              </tbody>
            </table>
          </div>
        </div>
        <div class="col-sm-4"></div>
      </div>
    </div>
</div>
    <div class="table-cont">
      <h4><b>N'</b></h4>
      <p>
        1)N'  =  Total Number of Cases Recorded includes all the cases which have been uploaded for analysis with a
        <span>minimum mandated three sections filled including Pre-procedure, Procedure and Post-procedure.</span>
        Ie. this may include records with optional follow up or feedback sections also.
      </p>
      <p>2)N' includes following scenarios of data entered by users
</p>
      <ul>
        <li>Cases with Pre-procedure, Procedure and Post-procedure</li>
        <li>Cases with Pre-procedure, Procedure, Post-procedure, Follow-up</li>
        <li>Cases with Pre-procedure, Procedure, Post-procedure, Feedback</li>
        <li>Cases with all sections entered from Pre-Procedure to Feedback</li>
      
      </ul>
      <h4><b>Nc</b></h4>
      <p>
        
       <li> Nc=mandatory sections + Follow-up + feedback <br />
       = Total Number of Cases with Complete Data includes cases where in all five sections are completed (Pre-procedure, Procedure, Post-procedure, Follow up and Feedback)

</p>
      <ul>
      <li>Nc includes following scenario of data entered by users</li>

<li>Cases with Pre-procedure, Procedure, Post-procedure, Follow up and Feedback</li>
        
      </ul>
    </div>
</div>
 
</div>
        
   </script> 
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.5/jspdf.min.js"></script>
<script
  type="text/javascript"
  src="https://www.gstatic.com/charts/loader.js"
></script>
<script  src="https://html2canvas.hertzen.com/dist/html2canvas.js"></script>
<script>

google.load('visualization', '1.0', {'packages':['corechart']});

google.charts.load('current', {'packages':['corechart', 'bar','table']});

google.charts.setOnLoadCallback(drawChart);
           // Line Chart
  function drawChart() {

var data1 = google.visualization.arrayToDataTable([
      ['Characteristics', 'Stats'],
        <?php

echo "['Total number of cases recorded with minimum data set','N’'],";
             echo "['Total number of cases with complete entry','Nc'],";

?>
    ]);
    var data = google.visualization.arrayToDataTable([
      ['Characteristics', 'Count'],
        <?php
          foreach ($products as $row){
             echo "['".$row['day']."',".$row['sell']."],";
        } ?>
    ]);
    var options = {
      title: 'Audit Classification',
      curveType: 'function',
      legend: {
        position: 'top'
      }
    };

// var pie_chart = new google.visualization.PieChart(document.getElementById('GoogleLineChart'));
    // pie_chart.draw(data, options);

// ------------------------PROCEDURE--------------------------

var data1 = google.visualization.arrayToDataTable([
      ['Characteristics', 'Stats'],
        <?php

echo "['Total number of cases recorded with minimum data set','N’'],";
             echo "['Total number of cases with complete entry','Nc'],";

?>
    ]);
    var procedure_data = google.visualization.arrayToDataTable([
      ['Characteristics', 'Count'],
        <?php
          foreach ($cse_products as $row){
          echo "['".$row['day']."',".$row['sell']."],";}

foreach ($e_products as $row){
          echo "['".$row['day']."',".$row['sell']."],";}

foreach ($s_products as $row){
          echo "['".$row['day']."',".$row['sell']."],";}

foreach ($csa_products as $row){
          echo "['".$row['day']."',".$row['sell']."],";}
        ?>
    ]);
    var procedure_options = {
      title: 'Procedure',
      curveType: 'function',
      legend: {
        position: 'top'
      }
    };

var pie_chart = new google.visualization.PieChart(document.getElementById('procedureGoogleTableChart'));
    pie_chart.draw(procedure_data, procedure_options);

}

</script>
<?php     }   ?>

success: function (response) {
        response = jQuery.parseJSON(response);
        console.log(response);
        if (response.result == 1) {
          // alert(response.result);

$("#from_date").html(response.from_date);
          $("#to_date").html(response.to_date);
          $("#reported_by").html(response.name);

window.location.reload();

var dates = response.data;
          dates.forEach(appendDate);

function appendDate(date) {
            console.log(date);
            $("#reported_date").append(date.DATE + " , ");
          }
        } else {
      
        }
      },
    });
  });
</script>

console.log(<?php echo date('d-m-Y',strtotime(session()->get('l_from_date'))); ?>);

<?php if(session()->get('l_from_date')  &&  session('l_to_date')){ ?>

$('#reports-pdf').css('display', 'block');

<?php }else{  ?>

$('#reports-pdf').css('display', 'none');

<?php }; ?>

</script>

<?php
    echo view('includes/labour-user-reports-footer');    
?>