$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;
