EVOLUTION-NINJA

Edit File: summery_report.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>
    <?php
    function IND_money_format($number){
        $decimal = (string)($number - floor($number));
        $money = floor($number);
        $length = strlen($money);
        $delimiter = '';
        $money = strrev($money);

for($i=0;$i<$length;$i++){
            if(( $i==3 || ($i>3 && ($i-1)%2==0) )&& $i!=$length){
                $delimiter .=',';
            }
            $delimiter .=$money[$i];
        }

$result = strrev($delimiter);
        $decimal = preg_replace("/0\./i", ".", $decimal);
        $decimal = substr($decimal, 0, 3);

if( $decimal != '0'){
            $result = $result.$decimal;
        }

return '₹ '.$result;
    }
?>
    <p style="background:#485b7f;">
    <img src="<?php echo base_url();?>assets/img/2ND%20TT.svg" alt="logo" width="180" style="margin-top:3px;"/>
    </p>
    <h2>Export Summary</h2>
         <p>
        <h4><?php echo 'Financial Year : '.$year;?></h4>
        </p>
    
    
    <div id="reports-pdf">
        <table align="center"  style="border: 1px solid black;">
            
           <tr>
               <td></td>
           <?php
            $total_val = 0;
            foreach($products as $row){
					?>
					
						<td><p>
							<?php echo $row['day']; ?></p>
						</td>
						<?php
            }
            ?>
            <td><b>
							<?php echo "Total" ?></b>
						</td>
            </tr>
            
            <tr>
                <td>Sales In INR</td>
           <?php
            $total_val = 0;
            foreach($products as $row){
                $total_val += $row['sell'];
					?>
						<td><p>
							<?php echo IND_money_format(number_format((float)($row['sell']), 2, '.', '')); ?></p>
						</td>
						<?php
            }
            ?>
            	<td>
					<p><?php echo IND_money_format(number_format((float)($total_val), 2, '.', '')); ?></p>
				</td>
            </tr>
            
            <tr>
                <td>Fabric</td>
           <?php
            $total_val = 0;
            foreach($products_fabric as $row){
                $total_val += $row['sell'];
					?>
						<td><p>
							<?php echo IND_money_format(number_format((float)($row['sell']), 2, '.', '')); ?></p>
						</td>
						<?php
            }
            ?>
            <td>
				<p><?php echo IND_money_format(number_format((float)($total_val), 2, '.', '')); ?></p>
			</td>
            </tr>
            
            <tr>
                <td>Madeups</td>
           <?php
            $total_val = 0;
            foreach($products_madeups as $row){
                $total_val += $row['sell'];
					?>
						<td><p>
							<?php echo IND_money_format(number_format((float)($row['sell']), 2, '.', '')); ?></p>
						</td>
						<?php
            }
            ?>
            <td>
				<p><?php echo IND_money_format(number_format((float)($total_val), 2, '.', '')); ?></p>
			</td>
            </tr>
            
            
        
        </table>
        <table align="center"  style="border: 1px solid black;">
            
            <tr>
            <td colSpan = 12>
            <div id="summery_chart" style="width: 700px; height: 300px; background-color:powderblue;"></div>
            
            </td>
            </tr>
        
        </table>
        
         <table align="center"  style="border: 1px solid black;">
            
            <tr>
            <td colSpan = 12>
                 <div id="customLegend" class="legend"></div>
            </td>
            <td>
            <div id="customer_chart" style="width: 700px; height: 300px; background-color:powderblue;"></div>
            
            </td>
            </tr>
        
        </table>
        
         <table align="center"  style="border: 1px solid black;">
            
            <tr>
            <td colSpan = 12>
                 <div id="countryLegend" class="legend"></div>
            </td>
            <td>
            <div id="country_chart" style="width: 700px; height: 300px; background-color:powderblue;"></div>
            
            </td>
            </tr>
        
        </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([
					['Month', 'FC In INR ₹'],
						<?php 
							foreach ($products as $row){
							   echo "['".$row['day']."',".$row['sell']."],";
						} ?>
				]);
				var options = {
					title: 'Month Wise Exports Sales',
					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);
				
				
				
			
			var data1 = new google.visualization.DataTable();
            data1.addColumn('string', 'Surgical location');
            data1.addColumn('number', 'FC IN INR ₹');
            data1.addColumn({type: 'string', role: 'style'});
    
            data1.addRows([
                <?php 
                $colors = ['#4CAF50', '#FF5733', '#FFC300', '#DAF7A6', '#C70039', '#900C3F', '#581845', '#2E86C1', '#AED6F1', '#E74C3C']; // Define 10 colors
                    $i = 0;
                    foreach ($customer as $row){
                        $color = $colors[$i % count($colors)];
                        echo "['".$row['day']."', ".$row['sell'].", 'color: ".$color."'],";
                        $i++;
                    }
                ?>
            ]);
                
				var options1 = {
					title: 'Customers Wise Sales',
					curveType: 'function',
				
					legend: {
						position: 'top'
					}
				
				};
				
				var column_chart = new google.visualization.ColumnChart(document.getElementById('customer_chart'));
				column_chart.draw(data1, options1);

var legendHTML = '';
            <?php 
            $i = 0;
            foreach ($customer as $row) {
                $color = $colors[$i % count($colors)];
                echo "legendHTML += '<div class=\"legend-item\"><span class=\"legend-color\" style=\"background-color: ".$color.";\"></span>".$row['day']."</div>';";
                $i++;
            }
            ?>
            document.getElementById('customLegend').innerHTML = legendHTML;

var legendHTML = '';
            <?php 
            $i = 0;
            foreach ($country as $row) {
                $color = $colors[$i % count($colors)];
                echo "legendHTML += '<div class=\"legend-item\"><span class=\"legend-color\" style=\"background-color: ".$color.";\"></span>".$row['day']."</div>';";
                $i++;
            }
            ?>
            document.getElementById('countryLegend').innerHTML = legendHTML;

}
			
			
			
		</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>

<style>

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

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

</style>