<style type="text/css">.text {font-family: Verdana; font-size:13px;}
.stylebottom
{
	border-right:1px solid #999;	
	border-bottom:1px solid #999;
}	
</style>

<?php 
  include ("../../include/db.php");
error_reporting(0);
ob_start();
session_start();
$session_branch=$_SESSION['branch'];
$session_user_type=$_SESSION['user_type'];
$branch_name=$_GET['branch_name'];
?>
<div class="row-fluid">
<div class="span12">
<div class="table-responsive">
<div class="CSSTableGenerator"> 
 <table width="800" border="0" align="center"  cellpadding="0" cellspacing="0">
<tr style="height:60">
<td width="137" height="106" align="right" valign="top" style="font-size:12px; "><img src="../../img/logo_image.png" width="140" height="146"/></td>
<td width="711" colspan="5" align="center" valign="top" style=""><strong style="font-size: 30px; color: #06F; padding-top: 5px; width: 80px; font-family: Verdana, sans-serif">SRI AMMAN DIGITAL PRINTS</strong><br />
        <span width="80%" class="title1" style="font-size:14px;font-family:Verdana, sans-serif; font-weight:bold"><b></b> DOOR No: 1/2,1/3  KOMBAI THOTTAM MAIN ROAD,</span><br />
       <span width="80%" class="title0" style="font-size:14px;font-family:Verdana, sans-serif; font-weight:bold"><b></b>SELLANDIAMMAN THURAI ROAD,</span><br />
       <span width="80%" class="title0" style="font-size:14px;font-family:Verdana, sans-serif; font-weight:bold"><b></b>TIRUPPUR-641604 TAMILNADU STATE INDIA,</span><br/>
       <span width="80%" class="title00" style="font-size:14px;font-family:Verdana, sans-serif; font-weight:bold"><b></b>Contact Office: 0421-4355333,+91 83442-33555,+91 83442-33888,</span><br/>
       <span width="80%" class="title0" style="font-size:14px;font-family:Verdana, sans-serif; font-weight:bold"><b></b>Email Id : sriammandigitalprints@gmail.com/yahoo.com.</span><br/>
       <span width="80%" class="title0" style="font-size:18px;font-family:Verdana, sans-serif; font-weight:bold">Pending JobCard Print</span></p></td>
</tr>
</table>

<table width="100%" align="center"  cellpadding="0" cellspacing="0" style="border-top:dashed 1px; border-bottom:dashed 1px" >
      <tr>
      <th  width="51" height="18" align="center" style="border-bottom:dashed 1px;font-family:Verdana, sans-serif; font-size:12px;"  >S.No</th>
      <th width="155" align="left" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px;">&nbsp;Date</th>
      <th width="218" align="left" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px;">&nbsp;&nbsp;Jobcard No</th>
      <th align="left" width="253" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px;"> &nbsp;Customer Name</th>
      <th width="182" align="left" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px;">Job Created</th>
      <th width="165" align="left" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px; ">Fabric Type</th>
      <th width="193" align="left" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px; " >Style Name&nbsp;</th>
      <th width="117" align="right" style="border-bottom:dashed 1px; font-family:Verdana, sans-serif; font-size:12px;" >Printed Qty</th>
      
      </tr>
  <?php
  include ("../../include/db.php");
 $from_date=$_GET['from_date'];
 $to_date=$_GET['to_date'];
 $current_date=date('Y-m-d');
 
 if($from_date!=""){ $from_date1= "DATE_FORMAT(print_date,'%Y-%m-%d')>='$from_date'"; }else{$from_date1="print_date='$current_date'"; }
 if($to_date!=""){ $to_date1 = "DATE_FORMAT(print_date,'%Y-%m-%d')<='$to_date'";}else{$to_date1="print_date='$current_date'";}

$all_value10 = $from_date1."@".$to_date1;
$all_array10 = explode('@',$all_value10);
foreach($all_array10 as $value10)
{ 
if($value10!='')
{
$get_query103 .= $value10." AND ";
}
}
if($from_date!=""){ $from_date1= "DATE_FORMAT(a.entry_time,'%Y-%m-%d')>='$from_date'"; }else{$from_date1="DATE_FORMAT(a.entry_time,'%Y-%m-%d')='$current_date'"; }
if($to_date!=""){ $to_date1 = "DATE_FORMAT(a.entry_time,'%Y-%m-%d')<='$to_date'";}else{$to_date1="DATE_FORMAT(a.entry_time,'%Y-%m-%d')='$current_date'";}
$all_value10 = $from_date1."@".$to_date1;
$all_array10 = explode('@',$all_value10);
foreach($all_array10 as $value10)
{ 
if($value10!='')
{
$get_query1031 .= $value10." AND ";
}
}	  



 //$sql="select * from printer_production_main where printer_status='0' and billed_status='0' and job_type='sticker' and $get_query103 p_id!='' union select * from fusing_production_main where printer_status='0' and billed_status='0'  and $get_query103 p_id!='' order by job_card_no DESC";
 
 $sql="select p_id,style_name,cust_name,job_card_no,printed_qty,print_date,job_created,fabric_type from printer_production_main where printer_status='0' and billed_status='0' and job_type='sticker' and $get_query103 p_id!='' union select p_id,style_name,cust_name,job_card_no,printed_qty,print_date,job_created,fabric_type from fusing_production_main where printer_status='0' and billed_status='0'  and $get_query103 p_id!='' 
    UNION 
    select a.job_id as p_id,a.particulars as style_name,a.customer_name as cust_name,a.jobcard_no as job_card_no,sum(a.qty) as printed_qty,a.entry_time as print_date,a.created_by as job_created,a.fabric_type as fabric_type from jobcard_sublist as a LEFT JOIN printer_production_main as b ON a.jobcard_no=b.job_card_no left JOIN fusing_production_main as c ON a.jobcard_no=c.job_card_no where $get_query1031 b.job_card_no IS NULL and  c.job_card_no IS NULL group by a.jobcard_no ORDER BY print_date asc  ";

    $rs=mysql_query($sql);
	$sno=0;
	$from=0;
   		while($rsdata=mysql_fetch_array($rs))
  			{
   				$sno=$sno+1;
				$from=$from+1;
   				$p_id=$rsdata['p_id'];
   				$job_card_no=$rsdata['job_card_no'];
				$print_date=$rsdata['print_date'];
	   			$cust_name=$rsdata['cust_name'];
	   			$job_created=$rsdata['job_created'];
				$cust_po=$rsdata['cust_po'];
	   			$fabric_type=$rsdata['fabric_type'];
	   			$style_name=$rsdata['style_name'];
				$combo=$rsdata['combo'];
	   			$printed_qty=$rsdata['printed_qty'];
				$billed_status=$rsdata['billed_status'];
			    $refer=$rsdata['refer'];
  ?>
  <tr>
    <td width="51"  align="center" height="30" style="font-family:Verdana, sans-serif; font-size:12px;"><?php echo $from; ?></td>
    <td width="155" align="left" style="font-family:Verdana, sans-serif; font-size:12px;">&nbsp;<?php echo date("d-m-Y",strtotime($print_date));?></td>
    <td align="left" style=" font-family:Verdana, sans-serif; font-size:12px;">&nbsp;&nbsp;<?php echo $job_card_no;?></td>
    <td width="253" align="left" style="font-family:Verdana, sans-serif; font-size:12px;">&nbsp;&nbsp;<?php echo $cust_name;?></td>
    <td align="left" style=" font-family:Verdana, sans-serif; font-size:12px;"><?php echo $job_created;?></td>
    <td align="left" style=" font-family:Verdana, sans-serif; font-size:12px;"><?php echo $fabric_type;?></td>
    <td align="left" style=" font-family:Verdana, sans-serif; font-size:12px;"><?php echo $style_name;?>&nbsp;</td>
    <td align="right" style="font-family:Verdana, sans-serif; font-size:12px;"><?php echo number_format($printed_qty,3);?></td>
    
   </tr>
  <?php $tot_print_qty+=$printed_qty; } ?>
  <tr>
   
    <td align="right" colspan="7" style="font-family:Verdana, sans-serif; font-size:12px; border-top:dashed 1px;"><strong>Total&nbsp;</strong></td>
    <td align="right" style="font-family:Verdana, sans-serif; font-size:12px; border-top:dashed 1px;"><strong><?php echo number_format($tot_print_qty,3);?></strong></td> 
  
  </tr>
</table>
<table width="1010" align="center"> 
<tr>
<td align="right" style=" font-family:Verdana, sans-serif; font-size:14px;"> Printed Date : <?php echo date('d-m-Y h:m a');?>  </td>
  </tr>
  </table>
</div>
</div>
</div>
</div>
</div></div></div></div>
