start=1; $wc[]="1=1"; $wc[]="purchaseordercf.cf_528='0'"; $wc[]="purchaseorder.tracking_no!=''"; $vc1->where=@implode(" and ",$wc); $vc->getData(); $cnt=$vc->getCount(); $data=$vc->data; if(count($data)>0){ foreach($data as $d){ if(trim($d['tracking_no'])==trim($_GET['tracking_no'])){ $dd[]=$d; } } } $data=$dd; $ile=ceil((count($data)+1)/17); $pdf = new HTML2FPDF("L"); $j=0; $k=0; $m=0; for($i=0;$ito_display_date($data[$i]['deliverydate'])." ".$_GET['tracking_no']).''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; } if($i==count($data)){ $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; } else{ $id=$vc->getIdByCode($data[$i]['productcode']); $r=mysql_fetch_array(mysql_query("select pieces_per_carton as ppc,carton_volume_meter as cvm from ecmproducts where id='".$id."'")); @$cartons=$data[$i]['quantity']/$r['ppc']; @$cbm=$data[$i]['quantity']*$r['cvm']/$r['ppc']; $qty_sum+=$data[$i]['quantity']; $cartons_sum+=$cartons; $cbm_sum+=$cbm; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; $html.=''; } $j++; $k++; $m++; if($j==17 || count($data)+1==$k){ $st++; $html.='

Index	Name	Quantity	Cartons	CBM
		'.iconv("UTF-8","ISO-8859-2",$qty_sum).'	'.iconv("UTF-8","ISO-8859-2",round($cartons_sum,0)).'	'.iconv("UTF-8","ISO-8859-2",number_format($cbm_sum,2,",",".")).'
'.iconv("UTF-8","ISO-8859-2",$data[$i]['productcode']).'	'.iconv("UTF-8","ISO-8859-2",$data[$i]['productname']).'	'.iconv("UTF-8","ISO-8859-2",$data[$i]['quantity']).'	'.iconv("UTF-8","ISO-8859-2",round($cartons,0)).'	'.iconv("UTF-8","ISO-8859-2",number_format($cbm,2,",",".")).'

'; $html.=''; $html.=''; $html.=''; $html.='

www.e5.pl

'.$st.'/'.$ile.'

'; $ohtml=$html; $html=''; $pdf->AddPage(); $pdf->WriteHTML($ohtml); $j=0; } } //echo $html; $pdf->Output("Containers.pdf", "D"); ?>