Index of /home/htscrtms/newcrm.htshah.com/hslider

• .. (Parent)
• [FILE] 2.php
• [FILE] error_log

Viewing: /home/htscrtms/newcrm.htshah.com/export-bookingreport-excel.php

<?php
include('lib/db_connect.php');
include('lib/auth.php');
date_default_timezone_set("Asia/Kolkata");;
$date=date('d-m-Y');
$fielname='importbooking-report_'.$date.'.xls';
header("Content-Type: application/xls");    
header("Content-Disposition: attachment; filename=$fielname");  
header("Pragma: no-cache"); 
header("Expires: 0");
?>
	<?php
	$count=0;
        if(isset($_REQUEST['seln']) && $_REQUEST['seln']=="Client"){ 
            $selcl="select * from `tabl_client` where userName='".$_REQUEST["name"]."'";
            $qrycl=mysqli_query($con,$selcl) or die(mysqli_error($con));
            $rowcl=mysqli_fetch_array($qrycl);
            
            $sel="select * from `tabl_importbooking` where DELFLAG='N' && STATUS='0' && client_id='".$rowcl['id']."' order by id desc";
        }else{
            $sel="select * from `tabl_importbooking` where DELFLAG='N' && STATUS='0' order by id desc";
        }
        $qry=mysqli_query($con,$sel) or die(mysqli_error($con));
	  ?>
      <table class="table" border="1">
        <thead>
            <tr>
                <th>Sr.</th>            
                <th>HTSHAH Job</th>
                <th>Client</th>
                <th>Bill of entry no</th>
                <th>Product</th>
                <th>FCL / LCL</th>
                <th>Inv. No. & Supplier</th>
                <th>Eta</th>
                <th>GR</th>
                <th>Cont Arrived / Scan</th>
                <th>Duty</th>
                <th>CC / OCC</th>
                <th>Org. docs</th>
                <th>Delivery</th>
                <th>Client Remarks</th>
                <th>Cont. bond</th>
                <th>Empty letter</th>
                <th>Remarks</th>
            </tr>
        </thead>
        <tbody>
        <?php
        while($row=mysqli_fetch_array($qry))
        { $count++;
            $selc="select * from `tabl_client` where id='".$row['client_id']."'";
            $qryc=mysqli_query($con,$selc) or die(mysqli_error($con));
            $rowc=mysqli_fetch_array($qryc);
        ?>
            <tr>
              <td><?php echo $count;?></td>
              <td id="hoverbox"><a href="edit_importbooking.php?id=<?php echo $row['id'] ?>"><?php echo $row['htshah_no']?></a>
                <div id="box" style="display: none">
                   <h4>Job Details</h4>
                   <p>Edi No: <?php echo $row['edi_no']?></p>
                </div>
              </td>
              <td><?php echo $rowc['userName']?></td>
              <td><?php echo $row['thoka_no']?></td>
              <td<?php if($row['product_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['product']?></td>
              <td<?php if($row['fcl_Lcl_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['fcl_Lcl']?></td>
              <td<?php if($row['invoice_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['invoice']?></td>
              <td<?php if($row['eta_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['eta']?></td>
              <td<?php if($row['igm_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['igm']?></td>
              <td<?php if($row['av_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['av']?></td>
              <td<?php if($row['duty_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['duty']?></td>
              <td<?php if($row['free_Detention_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['free_Detention']?></td>
              <td<?php if($row['org_Doc_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['org_Doc_Dt']?></td>
              <td<?php if($row['del_Pro_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['del_Pro_Dt']?></td>
              <td<?php if($row['client_Remark_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['client_Remark']?></td>
              <td<?php if($row['cont_Bond_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['cont_Bond_Dt']?></td>
              <td<?php if($row['emptyLetter_Val_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['emptyLetter_Val_Dt']?></td>
              <td<?php if($row['remark_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['remark']?></td>
            </tr>
        <?php
        }
        ?>
        </tbody>
    </table>