EVOLUTION-NINJA

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

</table>
    <h6>
    <p>
        SWAN HOUSE
    </p>
    <p>
        P.B. 25210, #40, 4TH CROSS,
    </p>
    <p>
       RESIDENCY ROAD, BANGALORE - 560 025, INDIA
    </p>
    <p>
       REX Registration : INREX07940038885TC003
    </p>
    </h6>
    
   
    
    <div id="reports-pdf">
        
            
        
        
        
            
        
        
        
        
        <p>
        <h2>Summary of the Statement on Origin</h2>
        <h4><?php echo 'Financial Year : '.$year;?></h4>
        </p>
          <table align="center"  style="border: 1px solid black;">
            
            <tr>
               <th>Serial Number</th>
               <th>Document Number & Date On Which statement of Origin is made out</th>
               <th>E-Way Date</th>
               <th>HSN</th>
               <th>Description</th>
               <th>Quantity</th>
               <th>FOB value of exports in USD</th>
               <th>Discount</th>
               <th>FOB After Discount</th>
               <th>Destination Port</th>
               <th>Destination of Export</th>
               <th>OriginCriteria"P" </th>
              
               
               <th>REX</th>
               <th>Month</th>
           </tr>
           
					
           <?php
            
            $i = 0;
            foreach($fabric as $row){
                        $i++; 
					?>
					<tr>
					<td><p><?php echo $i; ?></p></td>
					<td style="width:20%"><p><?php echo $row->invoice_num.' '.$row->invoice_date; ?></p></td>
					<td><p><?php echo $row->e_way_date; ?></p></td>
					<td><p><?php echo $row->hsn_code; ?></p></td>
					<td><p><?php echo $row->product_category; ?></p></td>
					<td><p><?php echo $row->sum_wt; ?></p></td>
					<td><p><?php echo number_format((float)($row->sum_values_es*$row->cross_currecy), 2, '.', '');
					?></p></td>
					
					<td><p><?php $total = ($row->total_value + $row->discount);
					             $discount = ($row->discount/$total)*100;
					             echo number_format((float)((($row->sum_values_es * $discount)/100)*$row->cross_currecy), 2, '.', '');
					        ?>
					    </p>
					</td>
					
					<td><p><?php $total = ($row->total_value + $row->discount);
					             $discount = ($row->discount/$total)*100;
					             echo number_format((float) ($row->sum_values_es - (($row->sum_values_es * $discount)/100)), 2, '.', ''); 
					        ?>
					    </p>
					</td>
					
					
					
					<td><p><?php echo $row->port_discharge; ?></p></td>
					<td><p><?php echo $row->country; ?></p></td>
					
					
					<td><p></p></td>
					<?php
					    if($row->rex == 1){
					        ?>
					        	<td><p><?php echo 'Rex'; ?></p></td>
					        <?php
					    }
					    else{
					        ?>
					            <td><p></p></td>
					        <?php
					        
					    }
					 ?>
				    <td><p><?php
                        $e_way_date = $row->e_way_date;
                        $monthNum = date("m",strtotime($e_way_date));
                        
                        $dateObj   = DateTime::createFromFormat('!m', $monthNum);
                        $monthName = $dateObj->format('F'); // March

echo $monthName;
					?></p></td>
					
					</tr>
					<?php
            }
            
            foreach($madeups as $row){
                        $i++;
					?>
					<tr>
					<td><p><?php echo $i; ?></p></td>
					<td style="width:50%"><p><?php echo $row->invoice.' '.$row->invoice_date; ?></p></td>
					<td><p><?php echo $row->e_way_date; ?></p></td>
					<td><p><?php echo $row->hsn_code; ?></p></td>
					<td><p><?php echo $row->product_category; ?></p></td>
					<td><p><?php echo $row->sum_qty; ?></p></td>
					<td><p><?php echo $row->sum_values_es; ?></p></td>
					
					<td><p><?php $total = ($row->total_value + $row->discount);
					             $discount = ($row->discount/$total)*100;
					             echo (($row->sum_values_es * $discount)/100);
					        ?>
					    </p>
					</td>
					<td><p><?php $total = ($row->total_value + $row->discount);
					             $discount = ($row->discount/$total)*100;
					             echo $row->sum_values_es - (($row->sum_values_es * $discount)/100);
					        ?>
					    </p>
					</td>
					
					<td><p><?php echo $row->port_discharge; ?></p></td>
					<td><p><?php echo $row->country; ?></p></td>
					
					
					<td><p></p></td>
					<?php
					    if($row->rex == 1){
					        ?>
					        	<td><p><?php echo 'Rex'; ?></p></td>
					        <?php
					    }
					    else{
					        ?>
					            <td><p></p></td>
					        <?php
					        
					    }
					 ?>
				    <td><p><?php
                        $e_way_date = $row->e_way_date;
                        $monthNum = date("m",strtotime($e_way_date));
                        
                        $dateObj   = DateTime::createFromFormat('!m', $monthNum);
                        $monthName = $dateObj->format('F'); // March

echo $monthName;
					?></p></td>
					
					</tr>
					<?php
            }
            
            ?> 
        </table>
    </div>
</body>
					
	<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>			
		
		
		
		<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>