sorry pressed the submit button too soon..
<table cellpadding=0 cellspacing=0 border=1 width="100%">
<tr>
<td valign=top align=left>
<table cellpadding=0 cellspacing=0 align=left border=1 >
<tr><td class=detail colspan=2><B><?=$model_code;?></td>
<tr><td class=detail colspan=2> </td>
<tr><td class=detail colspan=2 align=center><B>PO NO.</td>
<tr><td class=detail colspan=2 align=center><B>PO Issue Date</td>
<tr><td class=detail colspan=2 align=center><B>Lot NO.</td>
<tr><td class=detail colspan=2 align=center><B>Target Delivery Dates</td>
<tr><td class=detail colspan=2 align=center><B>Permit NO.</td>
<tr><td class=detail colspan=2 align=center><B>Invoice NO.</td>
<tr><td class=detail colspan=2 align=center><B>Form NO.</td>
<tr><td class=detail colspan=2> </td>
<tr><td class=detail colspan=2> </td>
<tr><td class=detail colspan=2> </td>
<?
$result2=new pg_resultset;
// $sql2="select distinct(part_longcode), part_name from temp_poi1 order by part_name,part_longcode";
$sql2="select distinct part_longcode, part_name , sum (quantity) as tot_qty from temp_poi1 group by part_name, part_longcode order by part_name,part_longcode";
$rs2=$conn->execute($sql2);
$result2->set_resultset($rs2);
$i=0;
while (!$result2->EOF()) {
$result2->get_row($rs2);
$part_name=rtrim($result2->get_field("part_name"));
$part_longcode=rtrim($result2->get_field("part_longcode"));
$totqty[$i]=rtrim($result2->get_field("tot_qty"));
print "<tr><td class=detail align=left><B>".$part_name."<td class=detail align=center><B>".$part_longcode."</td>";
$i++;
$result2->move_next();
}
?>
<tr><td class=detail colspan=2> </td>
</table>
<td valign=top align=left>
<table border=1 cellpadding=0 cellspacing=0 align=left>
<tr class=detail >
<?
$result4=new pg_resultset;
$sql4="select distinct so_month as month ,cnt as ctr, so_mpt_date from (
select (select count(so_month)
from (select so_month
from temp_poi1 a group by so_month, so_number
) c
where c.so_month=b.so_month
) as cnt,
so_month,so_number, so_mpt_date
from temp_poi1 b
group by so_month, so_number,so_mpt_date
order by b.so_mpt_date
) as x
order by so_mpt_date";
$rs4=$conn->execute($sql4);
$result4->set_resultset($rs4);
while (!$result4->EOF()) {
$result4->get_row($rs4);
$columncnt=rtrim($result4->get_field("ctr"));//echo $columncnt;
$so_month=rtrim($result4->get_field("month")); //echo $so_month;
if ($so_month!=$prevmonth) {
print "<td colspan=".$columncnt." class=detail align=left><B>".$so_month."</td>";
$prevmonth=$so_month;
}
$result4->move_next();
}
print "<td class=detail align=left><b>TOTAL PO</td>";
?>
</tr>
<tr>
<td class=detail align=center colspan=<?=$colspantr;?>> </td>
<?
$result2=new pg_resultset;
$sql2="select so_number ,to_char(so_issue_date,'MM/dd/YYYY') as issue_date, so_cust_lot,to_char(so_mpt_date,'MM/dd/YYYY') as mpt_date,
so_mpt_date, so_pezapermit_num , so_si_num, so_pezaform_num, sum(quantity) as sum_quantity
from temp_poi1
group by so_number, so_issue_date, so_cust_lot, so_mpt_date, so_pezapermit_num , so_si_num, so_pezaform_num
order by so_mpt_date";
$rs2=$conn->execute($sql2);
$result2->set_resultset($rs2);
$socnt=0;
while (!$result2->EOF()) {
$result2->get_row($rs2);
$issue_date[$socnt]=rtrim($result2->get_field("issue_date"));
$so_number=rtrim($result2->get_field("so_number"));
$sonum[$socnt]=$so_number;
$so_cust_lot=rtrim($result2->get_field("so_cust_lot"));
$cust_lot[$socnt]=$so_cust_lot;
$mpt_date[$socnt]=rtrim($result2->get_field("mpt_date"));
$so_pezapermit_num=rtrim($result2->get_field("so_pezapermit_num"));
$ppermit[$socnt]=$so_pezapermit_num;
$so_si_num=rtrim($result2->get_field("so_si_num"));
$sinum[$socnt]=$so_si_num;
$so_pezaform_num=rtrim($result2->get_field("so_pezaform_num"));
$pform[$socnt]=$so_pezaform_num;
$sum_quantity[$socnt]=rtrim($result2->get_field("sum_quantity"));
$tot_sumqty=$tot_sumqty+$sum_quantity[$socnt];
$result2->move_next();
$socnt++;
}
print "<tr>";
for ($j=0;$j<$socnt;$j++)
if ($ppermit[$j]=="" || $sinum[$j]=="" || $pform[$j]=="" )
print "<td class=detail align=center><font color=red >$sonum[$j]</font></td>";
else
print "<td class=detail align=center>$sonum[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$issue_date[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$cust_lot[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$mpt_date[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$ppermit[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$sinum[$j]</td>";
print "<td class=detail> </td>";
print "<tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$pform[$j]</td>";
print "<td class=detail> </td>";
print "<tr><td class=detail align=center colspan=$colspantr> </td>";
print "</tr><tr>";
for ($j=0;$j<$socnt;$j++)
print "<td class=detail align=center>$sum_quantity[$j]</td>";
print "<td class=detail align=center>$tot_sumqty</td>";
print "<tr><td class=detail align=center colspan=$colspantr> </td>";
// print "<tr><td class=detail align=center colspan=1>eyah</td>";
?>
<? print "<tr>";
$result2=new pg_resultset;
$sql2="select part_name, part_longcode, quantity as qty
from
(
select quantity, part_name, part_longcode, so_mpt_date, so_number
from temp_poi1 order by so_mpt_date,so_number
) as x
where part_name = x.part_name
order by part_name,part_longcode";
$rs2=$conn->execute($sql2);
$result2->set_resultset($rs2);
$c=0;
$y=0;
while (!$result2->EOF()) {
$result2->get_row($rs2);
$quantity=rtrim($result2->get_field("qty"));
if ($quantity=="") $quantity=" ";
if ($y==$socnt) {
if ($totqty[$c]=="") $totqty[$c]=" ";
print "<td class=detail align=center>$totqty[$c]</td><tr><td class=detail align=center>$quantity</td>";
$y=0;
$c++;
} else
print "<td class=detail align=center>$quantity</td>";
$y++;
/
if ($ctr%$socnt==0) {print "<tr>";}
print "<td class=detail align=center>$quantity</td>";
$ctr++;/
$result2->move_next();
}
print "<td class=detail align=center>$totqty[$c]</td>";
print "<tr ><td class=detail align=center colspan=$colspantr> </td>";
?>
</table>
