EVOLUTION-NINJA

Edit File: epiduralLA_v_old.php

<?php
    echo view('includes/reports-header');    
?>

<div id='reports-right' 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>CNB Reports</u></h3>
                	<h3 class="mt-4 pt-2">LA Utilisation - Epidural Space LA </h3>
						
						<br/>
						<div class="row">
       							<div class="col-sm-6">
        						<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('from_date'))); ?></span></h5>
          						<h5>To Date : <span id="to_date"><?php echo date('d-m-Y',strtotime(session()->get('to_date'))); ?></span></h5>
          						<h5>Reported by :<span id="reported_by"><?php $name =  session()->get('name');  
							if(substr($name, 0, 3) === "Dr. " || substr($name, 0, 3) === "Dr "){
							 echo	session()->get('name');
							}else{
								echo "Dr. ".session()->get('name');
							} ?></span></h5>
        						</div>
      							</div>
      						    <div class="col-sm-6"></div>
						</div>
						<div class="row" id="demo-table">
						<h5 class="mt-4"><strong>Plain Local Anasthesia Solution (Without Adrenaline)</strong></h5>

<?php if($total_n == 0){ ?>

<h4>No Data Found</h4>

<?php } else { ?>

<h4>Total cases = <?php  echo $total_n; ?></h4>

<table class="table table-bordered" id="mytable">
			        				<thead>
			        					<tr>
			        						<th>Plain Local Anasthesia Solution (Without Adrenaline)</th>
			        						<th>n</th>
			        						<th>Percentage</th>
			        					</tr>
			        				</thead>
			        				<tbody>
			        					
										<?php foreach($products as $row){
										?>
											<tr>
												<td id="report-td-bg"><p>
												<?php echo $row['day']; ?></p>
												</td>
												<td><p>
												<?php echo $row['sell']; ?></p>
												</td>
												<td><p>
												<?php
												if($total_n != 0){
												$number =  (($row['sell']/$total_n)*100);
												echo number_format((float)$number, 1, '.', '')."%";
												}
												else{
												echo "0%";
												}
												?>

</p></td>
											</tr>
										<?php
										}
										?>
			        					
			        				</tbody>
			        			</table>
							</div>
							
						</div>
						<div class="col-sm-4">
							
							<div id="GoogleBarChart" style="height: 400px; width: 100%"></div>

</div>
						
					</div>

<?php }	?>
					</div>

<br/>  </div>
       		
       		 <div class="col-sm-9">

<div class="reports-right pt-4">
				
				<div id="chart_div"></div>
		
						<br/>
						<div class="row" id="demo-table">
							<h5 class="mt-4"><strong>Local Anasthesia Solution with Adrenaline</strong></h5>
						<?php if($total_n1 == 0){ ?>

<h4>No Data Found</h4>

<?php } else { ?>

<div class="col-sm-8">
								<div class="table-responsive">
						
								
							<h4>Total cases with data = <?php echo $total_n1	;?></h4>
							
						<table class="table table-bordered" id="mytable">
        				<thead>
        					<tr>
        						<th>Local Anasthesia Solution with Adrenaline</th>
        						<th>n</th>
        						<th>Percentage</th>
        					</tr>
        				</thead>
        				<tbody>
        					
							<?php foreach($products1 as $row){
							?>
								<tr>
								<td id="report-td-bg"><p>
									<?php echo $row['day']; ?></p>
								</td>
								<td><p>
									<?php echo $row['sell']; ?></p>
								</td>
								<td><p>
									<?php
									if($total_n1 !=0){
									$number = (($row['sell']/$total_n1)*100);
									echo number_format((float)$number, 1, '.', '')."%";
							          }
									  else{
										echo"0%";
									  }
									?>
									
									</p></td>
								</tr>
							<?php
							}
							?>
        					
        				</tbody> 
        			</table>
							</div>
							</div>
						
							<div class="col-sm-4">
								
								<div id="GoogleBarChart1" style="height: 400px; width: 100%"></div>

</div>
							
						</div>

<?php }	?>
					</div>

<br/>  
       		 </div>   
				<div class="col-sm-9">

<h4>Total combo = <?php echo $total_combo;?></h4>
<table class="table table-bordered" id="mytable">
<thead>
<tr>
	<th>characteristics</th>
	<th>n</th>
	<th>Percentage</th>
</tr>
</thead>
<tbody>

<?php foreach($products_combo as $row){
?>
	<tr>
	<td id="report-td-bg"><p>
		<?php echo $row['day']; ?></p>
	</td>
	<td><p>
		<?php echo $row['sell']; ?></p>
	</td>
	<td><p>
		<?php
		if($total_n1 == 0){
			echo '0%';
		}
		else{
			$number = (($row['sell']/$total_combo)*100);
			echo number_format((float)$number, 1, '.', '')."%";
		}
		?>
		
		</p></td>
	</tr>
<?php
}
?>

</tbody> 
</table>

<?php } else{
					echo "<h4>No combos Found</h4>";
				}  ?>
	<br/>  
	</div>   
	</div>
	</div>
</div>
</div>  
       		</div>
	    </div>

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

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

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

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

var column_chart = new google.visualization.ColumnChart(document.getElementById('GoogleBarChart'));
				column_chart.draw(data, options);
}
</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 column_chart1 = new google.visualization.ColumnChart(document.getElementById('GoogleBarChart1'));
				column_chart1.draw(data11, options);

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