如何将FPDF总计添加到表的最后一行?
我有一组由它们的源e.g分类表: “客户”,“股票”,“Floorstock”。 他们看起来像这样:如何将FPDF总计添加到表的最后一行?
每个包含的价格列表,其中需要添加并总计表的最后一行。
我在链接一个“总计”数组的“表”阵列的问题 - 每次在总
到目前为止,在另一个函数生成每个表的总计每个表的末尾具体显示,其中sourceTotals
是一个实例数组:
public function setSourceTotalsArray($data)
{
$this->sourceTotals = $data["source_totals"];
return $this->sourceTotals;
}
这将返回一个数组,看起来像这样:
array(4) { ["Floorstock"]=> int(0) ["Stock"]=> int(0) ["Client"]=> float(32.18) }
这里就是我定义我的$pdf
对象:
if($_SERVER["REQUEST_METHOD"] == "POST"){
$data = json_decode($_POST["printData"],true);
$pdf = new PDF();
// Column headings
$month = $pdf->getMonth($data['month']);
$year = $data['year'];
$pdf->SetFont('Arial','',10);
$pdf->AddPage();
$pdf>title(array('month'=>$month,'year'=>$year,'showroom'=>ucfirst($data['showroom_name'])));
$pdf->tableBody($data);
if(!empty($data["order_detail"])){
$customerOrders = array();
$stockOrders = array();
$floorstockOrders = array();
$otherOrders = array();
foreach($data["order_detail"] as $o){
switch($o["orderSource"]){
case 'Client':
$customerOrders[] = $o;
break;
case 'Stock':
$stockOrders[] = $o;
break;
case 'Floorstock':
$floorstockOrders[] = $o;
break;
default:
$otherOrders[] = $o;
break;
}
}
if (!empty($customerOrders)) {
$pdf->orderDetail($customerOrders, $data['currency'], 'Client');
}
if (!empty($stockOrders)) {
$pdf->orderDetail($stockOrders, $data['currency'], 'Stock');
}
if (!empty($floorstockOrders)) {
$pdf->orderDetail($floorstockOrders, $data['currency'], 'Floor Stock');
}
if (!empty($otherOrders)) {
$pdf->orderDetail($otherOrders, $data['currency'], 'Client');
}
}
$pdf->Output();
的orderDetail
功能是$pdf
对象中的哪些结构表,该表具有对应于正确的列名细胞:
function orderDetail($data,$currencyShortCode, $type){
$this->orderType = $type;
list($currencySymbol, $w_symbol, $cellHight) = $this->getOrderDetailHeader($currencyShortCode, $type);
foreach ($data as $d){
$commaValue = $this->addComma((float)$d['value']);
$this->Cell(15,$cellHight,$d['order_no'],'LTB',0,'L');
$this->Cell(20,$cellHight,substr($d['customer'],0,13),'TB',0,'L');
$this->Cell(20,$cellHight,substr($d['company'],0,13),'TB',0,'L');
$this->Cell(20,$cellHight,substr($d['ref'],0,13),'TB',0,'L');
$this->Cell(2,$cellHight,'','TB',0,'R');
$this->Cell($w_symbol,$cellHight,$currencySymbol,'TB',0,'R');
$this->Cell(16-$w_symbol,$cellHight,$commaValue,'TB',0,'R');
$this->Cell(2,$cellHight,'','TB',0,'R');
$this->Cell(10,$cellHight,$d['cat'],'TB',0,'L');
$this->Cell(84,$cellHight,$d['description'],'RTB',0,'L');
$this->Ln($cellHight);
}
//BOTTOM TOTAL
$this->Cell(13,$cellHight,'TOTAL','LRTB',0,'L');
$this->Cell(22,$cellHight,'','TB',0,'L');
$this->Cell(20,$cellHight,'','TB',0,'L');
$this->Cell(20,$cellHight,'','TB',0,'L');
$this->Cell(4,$cellHight,$currencySymbol,'TB',0,'R');
$this->Cell(14,$cellHight,$this->setSourceTotalsArray($data),'TB',0,'R'); //HERE
$this->Cell(2,$cellHight,'','TB',0,'R');
$this->Cell(10,$cellHight,'','TB',0,'L');
$this->Cell(84,$cellHight,'','RTB',0,'L');
}
我只是不知道如何通过setSourceTotalsArray
到orderDetail
,因为我现在的愿望只能返回null
。
您的setSourceTotalsArray
方法没有做任何事情,所以如果它返回null
那意味着$data
没有source_totals
节点。 (建议/旁注:设置error reporting到E_ALL
所以PHP会警告你这一点;然后现场环境转display_errors
关闭,使log_errors
所以你会看到在日志中的错误,但你的访问者不会看到它们在屏幕上。) 原因source_totals
在$data
不存在的是,$数据variable inside
的完整剧本的OrderDetail is only a subset of
$ data`。
我会做的就是添加一个$total
参数orderDetail
。你得到的东西是这样的:
function orderDetail($data,$currencyShortCode, $type, $total) {
...
$this->Cell(14,$cellHight, $total,'TB',0,'R'); //HERE
...
}
而且
if (!empty($customerOrders)) {
$pdf->orderDetail($customerOrders, $data['currency'], 'Client', $data['source_totals']['Client']);
}
// Also add the 4th argument for stock orders, floor orders and others.
另一种很好的方式来生成PDF是简单地使用wkhtmltopdf二进制文件。
如果您已经有一份报告,它会生成html,您可以使用输出缓冲来生成html,然后转换为pdf,它可以在大多数环境中运行,并且可以像WebKit一样控制输出,Safari等)使用熟悉的语言(HTML)进行操作。
HTH。