$data[] = $row; } //exit(); /* print "<pre>"; var_dump($data); exit();*/ $pdf->ezTable( $data ,$ds['Columns'] ,html_entity_decode($ds['Title']) ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( 'Nummer'=>array('justification'=>'left') ,'InKrSumma'=>array('justification'=>'right') ,'InKr'=>array('justification'=>'right') ,'Admin'=>array('justification'=>'right') ) )); $result2 = $db->Query($ds['QueryTotal'] . " LIMIT 0,2000"); $row = $db->GetRow($result2); $row['OutKr'] = number_format($row['OutKr'],2,',','.'); $data[] = $row; $pdf->ezText("<i>Antal poster:</i> ".$row['items']." <i>Outkr Total:</i> ".$row['OutKr'],12,array('justification'=>'center')); function doHeader($pdf,$pageno,$pages) { $text = 'Sida '.$pageno.' av '.$pages;
} */ function NewPageCallback($rowIndex) { global $ds; if ($rowIndex > $ds['MaxSize']) { return 'Bailout'; } } $pdf->ezTable( $data ,$ds['Columns'] ,html_entity_decode($ds['Title']) ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( 'ProjectId'=>array('justification'=>'center') ,'InKr'=>array('justification'=>'right') ,'Admin'=>array('justification'=>'right') ,'OutKr'=>array('justification'=>'right') ) )); function doHeader($pdf,$pageno,$pages) { $text = 'Sida '.$pageno.' av '.$pages; $pdf->addText(($pdf->ez['pageWidth'] / 2)-strlen($text), 12, 9, $text); } $pdf->siHeadersAndFooters(array('AllPages'=>'doHeader')); $pdf->doHeader('Utskrift '.date('Y-m-d'),10,'left'); $pdf->doHeader("<b>Trosgnistan</b>",10,'right');
while($row = $db->GetRow($result)) { $data[] = $row; } $pdf->ezTable( $data //columns ,array('Fadderbarn.Id'=>'Childno' ,'Fadderbarn.Name'=>'Barnnamn' ,'Giver.Id'=>'Givare#' ,'Giver.Name'=>'Givare' ,'Fadderbarn.Mkr'=>'kr' ) ,"Barnland" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( 'Fadderbarn.Id'=>array() ,'Fadderbarn.Name'=>array() ,'Giver.Id'=>array() ,'Giver.Name'=>array() ,'Fadderbarn.Mkr'=>array() ) ) ); function pageNoFooter($pdf,$pageno,$pages) { $text = "Sida $pageno av $pages"; $x = ($pdf->ez['pageWidth'] / 2)-strlen($text);
$pdf->ezText("<b>VERY IMPORTANT! Trosgnistan have increased the support for most of the children from last year. See the list. Be sure that 90% of the support reach the children. Please read the new text.</b>"); $pdf->ezSetDy(-30); $pdf->ezText("Children list $area $areaName"); $pdf->ezSetDy(-15); $pdf->ezTable( $data //columns ,array('Fadderbarn.Area1'=>'<b>Area</b>' ,'Fadderbarn.Id'=>'<b>Childno.</b>' ,'Fadderbarn.Name'=>'<b>Name of Child</b>' ,'Giver.Id'=>'<b>Sponsor</b>' ,'Giver.Name'=>'<b>Givare</b>' ,'publicKr'=>'<b>Sek p/mon.</b>' ) ,"" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( ) ,'maxWidth'=>$pdf->ez['pageWidth']-20 ,'showHeadings'=>1 ,'shaded'=>0 ,'showLines'=>0 ,'showLines' => '0') ); $pdf->ezSetDy(-20); $count = count($data)-1;//1 for totals row. //$pdf->ezText("No.: <b>$count Total amount for this area in Swedish currency $tot sek"); $pdf->ezText("No.: $count Total amount for this area in Swedish currency $tot sek");
$result = $db->Query($query); $data = array(); while($row = $db->GetRow($result)) { $data[] = $row; } $pdf->ezTable( $data //columns ,array('ChurchName'=>'Namn' ,'Address'=>'Adress' ,'Zip'=>'Postnr' ,'ZipTown'=>'Ort' ,'Contact'=>'Kontakt' ) ,"Church" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( ),maxWidth=>$pdf->ez['pageWidth']-20 ) ); $pdf->doHeader("<b>Trosgnistan</b>",10,'right'); $pdf->doFooter("<b>Trosgnistan</b>",10,'right'); function pageNoFooter($pdf,$pageno,$pages) { $text = "Sida $pageno av $pages"; $x = ($pdf->ez['pageWidth'] / 2)-strlen($text);
$pdf = new SiCezpdf('A4', 'portrait'); $sql = " SELECT Id, Name From Giver Limit 0,200 "; $result = $db->Query($sql); $data = array(); while($row = $db->GetRow($result)) { $data[] = $row; } fb($data); //var_dump($data); $pages = 0; function NewPageCallback($rowIndex) { global $pages, $pdf; $pdf->addText(20, $pages * 3, 12, $rowIndex); if ($pages>2) { return 'Bailout'; } $pages++; } $pdf->ezTable( $data,array('Id'=>'#', 'Name'=> 'Namn') ,'Givare' ,array('NewPageCallback'=>'NewPageCallback', 'splitRows'=>0) ); header('connection:close'); $pdf->ezStream(); ?>
//add a totals row... $row = array(); $row["Payment.OutKr"] = "<b>".$OutTot."</b>";$row["ProjectName"] = "<b>Total</b>"; $data[] = $row; $pdf->ezTable( $data //columns ,array('Payment.ProjectId'=>'Projekt#' ,'ProjectName'=>'Projekt' ,'Payment.OutKr'=>'Totalt utbetalt' ) ,"Utbetalningar ".$_REQUEST["Date"]."" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( 'Payment.ProjectId'=>array('justification'=>'center') ,'ProjectName'=>array('justification'=>'center') ,'Payment.OutKr'=>array('justification'=>'right') ) ) ); function pageNoHeader($pdf,$pageno,$pages) { $text = "Sida $pageno av $pages"; $x = ($pdf->ez['pageWidth'] / 2)-strlen($text); $y = $pdf->ez['bottomMargin']-15;
//add a totals row... $row = array(); $row["Payment.InKrTotal"] = "<b>".$inTot."</b>";$row["GiverName"] = "<b>Total</b>"; $data[] = $row; $pdf->ezTable( $data //columns ,array('Payment.GiverId'=>'Givare#' ,'GiverName'=>'Namn' ,'Payment.ProjectId'=>'Projekt#' ,'Payment.InKrTotal'=>'InKrSumma' ) ,"".$_REQUEST["PaymentSource"]." betalningar ".$_REQUEST["Date"]."" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( 'Payment.GiverId'=>array('justification'=>'left') ,'GiverName'=>array('justification'=>'left') ,'Payment.ProjectId'=>array('justification'=>'center') ,'Payment.InKrTotal'=>array('justification'=>'right') ) ) ); function pageNoFooter($pdf,$pageno,$pages) { $text = "Sida $pageno av $pages"; $x = ($pdf->ez['pageWidth'] / 2)-strlen($text); $y = $pdf->ez['bottomMargin']-15;
$result = $db->Query($ds['Query']);//. "LIMIT 0,2000" $data = array(); while($row = $db->GetRow($result)) { $data[] = $row; } function NewPageCallback($rowIndex) { global $ds; if ($rowIndex > $ds['MaxSize']) { return 'Bailout'; } } $pdf->ezTable( $data ,$ds['Columns'] ,html_entity_decode($ds['Title']) ,array('NewPageCallback' => 'NewPageCallback') ); function doHeader($pdf,$pageno,$pages) { $text = 'Sida '.$pageno.' av '.$pages; $pdf->addText(($pdf->ez['pageWidth'] / 2)-strlen($text), 12, 9, $text); } $pdf->siHeadersAndFooters(array('AllPages'=>'doHeader')); $pdf->doHeader('Utskrift '.date('Y-m-d'),10,'left'); $pdf->doHeader("<b>Trosgnistan</b>",10,'right'); $pdf->doFooter("<b>Trosgnistan</b>",10,'right'); $pdf->doFooter('Utskrift '.date('Y-m-d'),10,'left'); header('connection:close');
$result = $db->Query($query); $data = array(); while($row = $db->GetRow($result)) { $data[] = $row; } $pdf->ezTable( $data //columns ,array('Name'=>'Namn' ,'Address'=>'Adress' ,'Zip'=>'Post' ,'ZipTown'=>'Ort' ) ,"Betel" //options ,array('NewPageCallback' => 'NewPageCallback' ,'cols'=>array( ),maxWidth=>$pdf->ez['pageWidth']-20 ) ); $pdf->doHeader("<b>Trosgnistan</b>",10,'right'); $pdf->doFooter("<b>Trosgnistan</b>",10,'right'); function pageNoFooter($pdf,$pageno,$pages) { $text = "Sida $pageno av $pages"; $x = ($pdf->ez['pageWidth'] / 2)-strlen($text); $y = $pdf->ez['bottomMargin']-15;