在代码点火器上生成多页TCPDF

Question

我有一个表格，用于显示数据并根据每一行生成报告。表格如下所示：

-----------------------------------------------------------------------------------------
|   employee_name  |   division   |   period   |   allowance  |  download   |  checkbox   |
|       tony       | advertising  | august 2018|    15.00     |(downloadbtn)|(checkboxbtn)|
|       lola       | advertising  | august 2018|    20.00     |(downloadbtn)|(checkboxbtn)|
-----------------------------------------------------------------------------------------

这是我到目前为止生成 PDF 的控制器：

<?php
class AllowanceReport extends CI_Controller{
function __construct(){
parent::__construct();
$this->load->model('allowance_m');
}
public function index(){
$this->load->view('allowance_v');
}
public function reportpdf($id){
ob_start();
$allowance= $this->allowance_m->get_allowance_byid($id);
$this->load->library('pdf_surat');
$pdf = new
PDF_SURAT('P','mm','A4',true,'UTF-8',false);
$pdf->AddPage();
$pdf->setXY(12,40);
$txt_pembuka = 'Allowance Report';
//$pdf->SetFontSize(16);
$pdf->SetFont('times', 'B', 16, '', 'false');
$pdf->MultiCell(0, 5, $txt_pembuka, 0, 'C', 0, 2, '', '', true);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->SetFont('times', '', 12, '', 'false');
$pdf->cell(35,5,"Nama");
$pdf->cell(0,5,":   ".$allowance->employee_name);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->cell(35,5,"Periode");
$periode = strtotime($allowance->periode);
$formatperiode = date('F Y',$periode);
$pdf->cell(0,5,":   ".$formatperiode);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->cell(35,5,"Uang Makan");
$pdf->cell(0,5,":   Rp.".$allowance->allowance);
$pdf->Output();
ob_end_flush();
}
}
?>

这是观点：

<div class="table">
<table class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th><center>Employee Name</center></th>
<th><center>Division</center></th>
<th><center>Period</center></th>
<th><center>Allowance</center></th>
<th><center>Download</center></th>
<th><center><input type="checkbox" class="checkAll" /></center></th>
<?php } ?>
</tr>
</thead>
<?php 
$no = 1;
if(is_array($query)){
foreach($query as $row):
?>
<tr>
<td><?php echo $row->employee_name ?></td>
<td><?php echo $row->division ?></td>
<td><?php echo date("F-Y", strtotime($row->period)) ?></td>
<td><?php echo $row->allowance ?></td>
<td>
<center>
<a href="<?php echo base_url(). "index.php/allowancereport/reportpdf/".$row->idallowance;?>" class="btn btn-success" id="cetaksurat_"><b><span class="glyphicon glyphicon-download"></span></b></a>
</center>
</td>
<td>
<center>
<input type="checkbox" class="checkitem" value="<?php echo $row->idmakan; ?>"/>
</center>
</td>
<td>
<center>
<a href="<?php echo base_url();?>absengaji/edit/<?php echo $row->idmakan;?>" class="btn btn-primary btn-xs edit" data-toggle="modal" id="edit_">
<span class="glyphicon glyphicon-pencil"></span></a>
</center>
</td>
<?php } ?>
</tr>
<?php endforeach ; } ?>         
</table>
</div>
</div>
</div>
</div>

这是我的模型

public function get_allowance_byid($id)
{
$sql = "SELECT * FROM allowance WHERE idallowance='".$id."'";
return $this->db->query($sql)->row();
}

我设法为每一行生成一个pdf。 但是是否可以基于选中的复选框生成具有多个页面的文件？ PDF 文件能否生成与文件中不同页面检查的每个数据？

Answer 1

你可以像下面这样做

前端

在表标签之前和之后添加表单标签，将表单目标设置为新方法(allreportpdf(，并添加提交按钮以触发表单内的所有保存报告(可能在表单关闭标记之前(：

<form action="<?php echo base_url() . "index.php/allowancereport/allreportpdf" ?>" method="POST" role="form">
<table class="table table-striped table-bordered table-hover">
...
...
...
</table>
<button type="submit" class="btn btn-primary">Get All Report</button>
</form>

在复选框输入上添加一个名称(可能是eid(，它将用作新方法(allreportpdf(上的发布数据。

<center>
<input type="checkbox" class="checkitem" name="eid[]" value="<?php echo $row->idmakan; ?>"/>
</center>

后端

由于此页面使用不同的布局，您应该在类AllowanceReport上创建一个新方法，使用先前设置的帖子名称(eid(，您可以在foreach()循环中使用它，并修改pdf设置，以便每个id在每个页面上分开：

public function allreportpdf(){
ob_start();
$this->load->library('pdf_surat');
$pdf = new
PDF_SURAT('P','mm','A4',true,'UTF-8',false);
foreach ($this->input->post('eid') as $id) {
$allowance= $this->allowance_m->get_allowance_byid($id);
$pdf->AddPage();
$pdf->setXY(12,40);
$txt_pembuka = 'Allowance Report';
//$pdf->SetFontSize(16);
$pdf->SetFont('times', 'B', 16, '', 'false');
$pdf->MultiCell(0, 5, $txt_pembuka, 0, 'C', 0, 2, '', '', true);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->SetFont('times', '', 12, '', 'false');
$pdf->cell(35,5,"Nama");
$pdf->cell(0,5,":   ".$allowance->employee_name);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->cell(35,5,"Periode");
$periode = strtotime($allowance->periode);
$formatperiode = date('F Y',$periode);
$pdf->cell(0,5,":   ".$formatperiode);
$pdf->setXY(20,$pdf->getY()+7);
$pdf->cell(35,5,"Uang Makan");
$pdf->cell(0,5,":   Rp.".$allowance->allowance);
}
$pdf->output();
ob_end_flush();
}

Answer 2

使用php代码点火器在单个pdf上显示多个页面：-

这是我在 php 代码点火器中解决此问题的简单解决方案。

1-在<head>标签后添加脚本：

<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/0.4.1/html2canvas.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.5.3/jspdf.min.js"></script>

2-创建文档新jspdf

var doc = new jsPDF();

3-定义页面高度和x，y坐标

pageHeight= doc.internal.pageSize.height;
x=15; y = 0 ;

4-现在在一个pdf中添加多个页面：

if (y >= pageHeight)
{
doc.addPage();
}

5-将文档保存在下载文件夹中

doc.save("Download.pdf"); 

6-完整代码：

<script>   
function generatePDF() {
var doc = new jsPDF();
pageHeight= doc.internal.pageSize.height;
x=15; y = 0 ;
if (y >= pageHeight)
{
doc.addPage();
y = 0 

doc.fromHTML(document.getElementById("divId"),x,y,{
'width': 170
}),
y=500;
}
doc.save("CallLetters.pdf");         
}
</script>