EVOLUTION-NINJA

Edit File: summery_report_marketing.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>
    
    <table align="center"  style="border: 1px solid black;">
        <tr>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/all" >ALL</a>
            </td>
            <td>
                <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/04" >April</a>
            </td>
            <td>
                <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/05" >May</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/06" >June</a>
            </td>
            <td>
                <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/07" >July</a>
            </td>
            <td>
                <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/08" >Aug</a>
            </td>
            <td>
                <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/09" >Sept</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/10" >Oct</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/11" >Nov</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/12" >Dec</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/01" >Jan</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/02" >Feb</a>
            </td>
            <td>
                 <a  href = "<?php echo base_url(); ?>g_reports/summery_report_marketing/03" >March</a>
            </td>
            
        </tr>

</table>
    
    
    <h2>Delivery Tracker And Current Orders</h2>
         <p>
        <h4><?php echo 'Financial Year : '.$year;?></h4>
        </p>
    
    
    <div id="reports-pdf">
        <table align="center"  style="border: 1px solid black;">
            
            <tr>
            <td colSpan = 6>
            <div id="summery_chart" style="width: 700px; height: 300px; background-color:powderblue;"></div>
            
            </td>
            
            <td colSpan = 6>
                <h3>Orders Summary</h3>
                  <table align="center"  style="border: 1px solid black;">
                    
                    <tr>
                      <td></td>
                      <td><h4>Order Value</h4></td>
                      <td><h4>Shipped Value</h4></td>
                    </tr>
                    
                    <tr>
                      <td>FABRIC</td>
                      <td><?php echo IND_money_format($f_order_value);?></td>
                      <td><?php echo IND_money_format($f_shipped_value);?></td>
                      
                    </tr>
                    
                     <tr>
                      <td>MADEUPS</td>
                      <td><?php echo IND_money_format($m_order_value);?></td>
                     <td><?php echo IND_money_format($m_shipped_value);?></td>
                    </tr>
                    
                    <tr>
                      <td>Total</td>
                      <td><?php echo IND_money_format($f_order_value + $m_order_value);?></td>
                     <td><?php echo IND_money_format($f_shipped_value + $m_shipped_value);?></td>
                    </tr>
                     </table>
            </td>
            <td colSpan = 6>
                <h3>Orders On Hand</h3>
                  <table align="center"  style="border: 1px solid black;">
                    
                    <tr>
                      <td></td>
                      <td><h4>Order Value</h4></td>
                    </tr>
                    
                    <tr>
                      <td>FABRIC</td>
                      <td style="color:red;"><?php echo IND_money_format($f_order_value - $f_shipped_value);?></td>
                    </tr>
                    
                     <tr>
                      <td>MADEUPS</td>
                      <td style="color:red;"><?php echo IND_money_format($m_order_value - $m_shipped_value);?></td>
                    </tr>
                    
                    <tr>
                      <td>Total</td>
                      <td style="color:red;"><?php echo IND_money_format(($f_order_value - $f_shipped_value) + ($m_order_value - $m_shipped_value));?></td>
                    </tr>
                     </table>
            </td>
            
        
        </table>
        
        <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
            }
            ?>
            </tr>
            
            <tr>
                <td>Order Value</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
            }
            ?>
            </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>
                <th>Sl #</th>
                <th>Delivery Date</th>
                <th>Order Type</th>
                <th>DTL Number</th>
                <th>File No</th>
                <th>Order Value</th>
                
                
                
                
                <th>Order Shipped Value</th>
                <th>Yet to Ship Value </th>
            </tr>
            <?php
            $i = 0;
            $t = 0;
              for($i = 0; $i <count($res); $i++){
                  $t += $res[$i]['indian'];
                  ?>
                  <tr>
                    <td><?php echo  ($i+1);?></td>
                    <td><?php echo  date("d-m-Y", strtotime($res[$i]['deliveryDate']));?></td>
                    <td><?php echo  $res[$i]['orders_Type'];?></td>
                    <td><?php echo  $res[$i]['oslNo'];?></td>
                    <td><?php echo  $res[$i]['fileNo'];?></td>
                    <td><?php echo  IND_money_format($res[$i]['indian']);?></td>
                    
                    
                    
                    
                    <td><?php echo  IND_money_format($res[$i]['sh_val'] * $res[$i]['sh_val_rate']);?></td>
                    <?php
                        if((($res[$i]['sh_val'] * $res[$i]['sh_val_rate']) - $res[$i]['indian']) > 0){
                            ?>
                            <td><?php echo  '0';?></td>
                            <?php
                        }
                        else{
                            ?>
                                 <td><?php echo  IND_money_format($res[$i]['indian'] - ($res[$i]['sh_val'] * $res[$i]['sh_val_rate']));?></td>
                            <?php
                        }
                    ?>
                   
                  </tr>
                  <?php
              }
              ?>
              <tr>
                  <td></td>
                  <td></td>
                  <td></td>
                  <td></td>
                  <td>Total Order Value</td>
                  <td><?php echo   IND_money_format($t);?></td>
                  <td></td>
                  <td></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', 'Value In INR ₹'],
						<?php 
							foreach ($products as $row){
							   echo "['".$row['day']."',".$row['sell']."],";
						} ?>
				]);
				var options = {
					title: 'Orders Based On Delivery',
					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', 'Value 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: 'Orders Summary',
					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;

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