EVOLUTION-NINJA

Edit File: hscode_summery.php

<body>
    <table align="center"  style="border: 1px solid black;">
        <tr>
              <td>
                 <a  href = "<?php echo base_url();?>g_reports/summery_report_order_date" >Orders Received</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/summery_report_marketing" >Delivery Tracker</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url();?>g_reports/summery_report" >Sales Summary</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/export_report" >Sales - Export</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/fabric_reports" >Fabrics - Export</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url();?>g_reports/madeups_reports" >Madeups - Export</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/rex_report" >REX Details</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/duty_drawback_report" >Duty Drawback / Export Incentive Details</a>
            </td>
            <td>
                <a  href = "<?php echo base_url();?>g_reports/gst_report" >IGST List</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url();?>g_reports/gst_summery_reports" >IGST Summary</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url();?>g_reports/hscode_summery_reports" >HS Code Summary</a>
            </td>
             <td>
                 <a  href = "<?php echo base_url();?>g_reports/po_reports" >PO Summary</a>
            </td>
            
        </tr>

</table>
    
    <p style="background:#485b7f;">
    <img src="<?php echo base_url();?>assets/img/2ND%20TT.svg" alt="logo" width="180" style="margin-top:3px;"/>
    </p>
    
    <div id="reports-pdf">
        
            
        
        
        
            
        
        
        
        
        
        <h2>HSCODE Summary</h2>
         <p>
        <h4><?php echo 'Financial Year : '.$year;?></h4>
        </p>
          <table align="center"  style="border: 1px solid black;">
            
           <tr>
               <th>HSN</th>
               <th>Products</th>
               <th>Apr</th>
               <th>May</th>
               <th>Jun</th>
               <th>Jul</th>
               <th>Aug</th>
               <th>Sept</th>
               
               <th>Oct</th>
               <th>Nov</th>
               <th>Dec</th>
               <th>Jan</th>
               <th>Feb</th>
               <th>March</th>
               
               
           </tr>
           <?php
            $total_val = 0;
            $i = 0;
            
            
            ?>
            
                <tr>
                        <td></td>
						<td><p>
							<?php echo 'Total FABRIC HSCODE INR ₹'; ?></p>
						</td>
						<td><p>
					        <?php echo('₹ '.number_format((float)($total_array[0]), 2, '.', '')); ?></p>
				        </td>
				        	<td><p>
					        <?php echo('₹ '.number_format((float)($total_array[1]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[2]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[3]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[4]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[5]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[6]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[7]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[8]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					       <?php echo('₹ '.number_format((float)($total_array[9]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[10]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array[11]), 2, '.', '')); ?></p>
				        </td>
				        
				</tr>
				
				
            <?php
            
            
            
            for($i = 0; $i<count($category) ; $i++){
        
					?>
						<tr>
						<td><p>
							<?php echo $hsn[$i]; ?></p>
						</td>
						<td><p>
							<?php echo $category[$i]; ?></p>
						</td>
				       	<td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][0]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][1]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][2]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][3]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][4]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][5]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][6]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][7]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][8]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][9]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][10]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products[$category[$i]][11]), 2, '.', '')); ?></p>
				        </td>
						</tr>
			    <?php
            }
            ?>
            
          
				
				 <tr>
                        <td></td>
						<td><p>
							<?php echo 'Total MADEUPS HSCODE  INR ₹'; ?></p>
						</td>
						<td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[0]), 2, '.', '')); ?></p>
				        </td>
				        	<td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[1]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[2]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[3]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[4]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[5]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[6]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[7]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[8]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					       <?php echo('₹ '.number_format((float)($total_array_madeups[9]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[10]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($total_array_madeups[11]), 2, '.', '')); ?></p>
				        </td>
				        
				</tr>
				
				<?php
				
				for($i = 0; $i<count($category_madeups) ; $i++){
        
					?>
						<tr>
						<td><p>
							<?php echo $hsn_madeups[$i]; ?></p>
						</td>
						<td><p>
							<?php echo $category_madeups[$i]; ?></p>
						</td>
				       	<td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][0]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][1]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][2]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][3]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][4]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][5]), 2, '.', '')); ?></p>
				        </td>
				        
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][6]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][7]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][8]), 2, '.', '')); ?></p>
				        </td>
				        <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][9]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][10]), 2, '.', '')); ?></p>
				        </td>
				         <td><p>
					        <?php echo('₹ '.number_format((float)($products_madeups[$category_madeups[$i]][11]), 2, '.', '')); ?></p>
				        </td>
						</tr>
			    <?php
            }
            ?>
            
        
        </table>
        
        
    </div>
</body>
		<php
			
		?>
					
	<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 data = google.visualization.arrayToDataTable([
					['Surgical location', 'Count'],
						<?php 
							foreach ($products as $row){
							   echo "['".$row['day']."',".$row['sell']."],";
						} ?>
				]);
				var options = {
					title: 'Exports',
					curveType: 'function',
					colors: ['#e0440e', '#e6693e', '#ec8f6e', '#f3b49f', '#f6c7b6'],
					legend: {
						position: 'top'
					}
				
				};
				
				var column_chart = new google.visualization.ColumnChart(document.getElementById('summery_chart'));
				column_chart.draw(data, options);

}
			
			
			
		</script>
		
		
		<style>
    .chart-container {
        display: flex;
        align-items: center;
    }

.legend {
        display: flex;
        flex-direction: column;
        margin-right: 20px;
    }

.legend-item {
        display: flex;
        align-items: center;
        margin-bottom: 5px;
    }

.legend-color {
        width: 20px;
        height: 20px;
        display: inline-block;
        margin-right: 5px;
    }
    
    
    
    
</style>

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #dddddd;
}
</style>