318 lines
12 KiB
PHP
318 lines
12 KiB
PHP
<?php
|
|
/**
|
|
+-----------------------------------------------------------------------------------------------
|
|
* GouGuOPEN [ 左手研发，右手开源，未来可期！]
|
|
+-----------------------------------------------------------------------------------------------
|
|
* @Copyright (c) 2021~2025 http://www.gouguoa.com All rights reserved.
|
|
+-----------------------------------------------------------------------------------------------
|
|
* @Licensed 勾股OA，开源且可免费使用，但并不是自由软件，未经授权许可不能去除勾股OA的相关版权信息
|
|
+-----------------------------------------------------------------------------------------------
|
|
* @Author 勾股工作室 <hdm58@qq.com>
|
|
+-----------------------------------------------------------------------------------------------
|
|
*/
|
|
declare (strict_types = 1);
|
|
namespace app\api\controller;
|
|
|
|
use app\api\BaseController;
|
|
use think\facade\Db;
|
|
use think\facade\View;
|
|
use Mpdf\Mpdf;
|
|
use PhpOffice\PhpWord\TemplateProcessor;
|
|
use app\adm\model\MeetingRecords;
|
|
use app\adm\model\MeetingOrder;
|
|
use app\home\model\Leaves;
|
|
use app\home\model\Trips;
|
|
use app\home\model\Outs;
|
|
use app\adm\model\Seal;
|
|
use app\user\model\PersonalQuit;
|
|
use app\user\model\DepartmentChange;
|
|
use app\user\model\Talent;
|
|
use app\adm\model\OfficialDocs;
|
|
use app\finance\model\Loan;
|
|
use app\finance\model\Expense;
|
|
use app\finance\model\Invoice;
|
|
use app\finance\model\Ticket;
|
|
use app\contract\model\Contract;
|
|
use app\contract\model\Purchase;
|
|
|
|
class Export extends BaseController
|
|
{
|
|
public function pdf($types='',$id=0)
|
|
{
|
|
$name='PDF文件';
|
|
$is_header=true;
|
|
$check_record=true;
|
|
$is_page=false;
|
|
$logo = CMS_ROOT.'public/static/home/images/logo.png';
|
|
//请假审批
|
|
if($types=='leaves'){
|
|
$model = new Leaves();
|
|
$detail= $model->getById($id);
|
|
$detail['types_name'] = leaves_types_name($detail['types']);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的请假审批单';
|
|
}
|
|
//出差审批
|
|
if($types=='trips'){
|
|
$model = new Trips();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的出差审批单';
|
|
}
|
|
//外出审批
|
|
if($types=='outs'){
|
|
$model = new Outs();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的外出审批单';
|
|
}
|
|
//加班审批
|
|
if($types=='overtimes'){
|
|
$model = new Outs();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的加班审批单';
|
|
}
|
|
//用印审批
|
|
if($types=='seal'){
|
|
$model = new Seal();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的用章审批单';
|
|
}
|
|
//离职审批
|
|
if($types=='personal_quit'){
|
|
$model = new PersonalQuit();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的离职审批单';
|
|
}
|
|
//人事调动审批单
|
|
if($types=='department_change'){
|
|
$model = new DepartmentChange();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的人事调动审批单';
|
|
}
|
|
//入职审批单
|
|
if($types=='talent'){
|
|
$model = new Talent();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的入职审批单';
|
|
}
|
|
//公文审批
|
|
if($types=='official_docs'){
|
|
$model = new OfficialDocs();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的公文审批单';
|
|
}
|
|
//借支审批
|
|
if($types=='loan'){
|
|
$model = new Loan();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的借支审批单';
|
|
}
|
|
//报销审批
|
|
if($types=='expense'){
|
|
$model = new Expense();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的报销审批单';
|
|
}
|
|
//开票回款
|
|
if($types=='invoice'){
|
|
$model = new Invoice();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的发票开票审批单';
|
|
}
|
|
//无票回款
|
|
if($types=='invoicea'){
|
|
$model = new Invoice();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的无发票回款审批单';
|
|
}
|
|
//收票付款
|
|
if($types=='ticket'){
|
|
$model = new Ticket();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的收票审批单';
|
|
}
|
|
//无发票付款单
|
|
if($types=='ticketa'){
|
|
$model = new Ticket();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的无发票付款审批单';
|
|
}
|
|
//销售合同
|
|
if($types=='contract'){
|
|
$model = new Contract();
|
|
$detail= $model->getById($id);
|
|
$detail['cate_title'] = Db::name('ContractCate')->where(['id' => $detail['cate_id']])->value('title');
|
|
$detail['subject_title'] = Db::name('Enterprise')->where(['id' => $detail['subject_id']])->value('title');
|
|
$detail['department'] = $detail['sign_department'];
|
|
$detail['content_array'] = unserialize($detail['content']);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的销售合同审批单';
|
|
}
|
|
//采购合同
|
|
if($types=='purchase'){
|
|
$model = new Purchase();
|
|
$detail= $model->getById($id);
|
|
$detail['cate_title'] = Db::name('ContractCate')->where(['id' => $detail['cate_id']])->value('title');
|
|
$detail['subject_title'] = Db::name('Enterprise')->where(['id' => $detail['subject_id']])->value('title');
|
|
$detail['department'] = $detail['sign_department'];
|
|
$detail['content_array'] = unserialize($detail['content']);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的采购合同审批单';
|
|
}
|
|
//会议记录
|
|
if($types=='meeting'){
|
|
$model = new MeetingRecords();
|
|
$detail= $model->getById($id);
|
|
$name = date('Ymd',$detail['meeting_date']).$detail['did_name'].'_会议纪要';
|
|
$check_record=false;
|
|
}
|
|
//会议室预定
|
|
if($types=='meeting_order'){
|
|
$model = new MeetingOrder();
|
|
$detail= $model->getById($id);
|
|
$name = to_date($detail['create_time'],'Ymd').$detail['admin_name'].'提交的会议室预定';
|
|
}
|
|
//员工档案
|
|
if($types=='files'){
|
|
$detail = get_admin($id);
|
|
$detail['pname'] = Db::name('Admin')->where('id',$detail['pid'])->value('name');
|
|
$detail['position'] = Db::name('Position')->where('id',$detail['position_id'])->value('title');
|
|
$detail['department'] = Db::name('Department')->where('id',$detail['did'])->value('title');
|
|
$department_ids = Db::name('DepartmentAdmin')->where('admin_id',$id)->column('department_id');
|
|
$department_names = Db::name('Department')->whereIn('id',$department_ids)->column('title');
|
|
$detail['department_names'] = implode(',',$department_names);
|
|
if($detail['file_ids'] !=''){
|
|
$file_array = Db::name('File')->where('id','in',$detail['file_ids'])->select();
|
|
$detail['file_array'] = $file_array;
|
|
}
|
|
$edu = Db::name('AdminProfiles')->where(['types'=>1,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
|
|
$work = Db::name('AdminProfiles')->where(['types'=>2,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
|
|
$certificate = Db::name('AdminProfiles')->where(['types'=>3,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
|
|
$skills = Db::name('AdminProfiles')->where(['types'=>4,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
|
|
$language = Db::name('AdminProfiles')->where(['types'=>5,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
|
|
View::assign('edu', $edu);
|
|
View::assign('work', $work);
|
|
View::assign('skills', $skills);
|
|
View::assign('certificate', $certificate);
|
|
View::assign('language', $language);
|
|
View::assign('detail', $detail);
|
|
$name = $detail['name'].'_档案信息';
|
|
$check_record=false;
|
|
$is_page=true;
|
|
}
|
|
|
|
if($check_record){
|
|
if(!empty($detail['check_copy_uids'])){
|
|
$check_copy_names = Db::name('Admin')->where([['id','in',$detail['check_copy_uids']],['status','=',1]])->column('name');
|
|
$detail['check_copy_names'] = implode(',',$check_copy_names);
|
|
}
|
|
$detail['check_status_str'] = check_status_name($detail['check_status']);
|
|
//审批记录
|
|
$check_table = $types;
|
|
if($types=='invoicea'){
|
|
$check_table = 'invoice';
|
|
}
|
|
if($types=='ticketa'){
|
|
$check_table = 'ticket';
|
|
}
|
|
$check_record_array = Db::name('FlowRecord')
|
|
->field('f.*,a.name')
|
|
->alias('f')
|
|
->join('Admin a', 'a.id = f.check_uid', 'left')
|
|
->where([['f.action_id','=',$id],['f.check_table','=',$check_table],['f.delete_time','=',0],['f.step_id','>',0]])->select()->toArray();
|
|
foreach ($check_record_array as $kk => &$vv) {
|
|
$vv['check_time_str'] = date('Y-m-d H:i', $vv['check_time']);
|
|
$vv['status_str'] = '提交';
|
|
if($vv['check_status'] == 1){
|
|
$vv['status_str'] = '审核通过';
|
|
}
|
|
else if($vv['check_status'] == 2){
|
|
$vv['status_str'] = '审核拒绝';
|
|
}
|
|
if($vv['check_status'] == 3){
|
|
$vv['status_str'] = '撤销';
|
|
}
|
|
if($vv['check_status'] == 4){
|
|
$vv['status_str'] = '反确认';
|
|
}
|
|
}
|
|
$detail['check_record_array'] = $check_record_array;
|
|
}
|
|
|
|
$detail['pdf_admin'] = Db::name('Admin')->where([['id','=',$this->uid]])->value('name');
|
|
$detail['pdf_time'] = date('Y-m-d H:i:s');
|
|
//var_dump($detail);exit;
|
|
View::assign('detail', $detail);
|
|
View::assign('logo', $logo);
|
|
$html = View::fetch($types);
|
|
$time = time();
|
|
//tempDir指定临时文件目录，需要有可写入的权限，否则会报错
|
|
$mpdf = new Mpdf([
|
|
'mode'=>'zh',//或者utf-8
|
|
'format' => 'A4',
|
|
'margin_top'=>23,
|
|
'margin_bottom'=>19,
|
|
//重新定义字体路径
|
|
'fontDir' => [
|
|
CMS_ROOT . "public/static/font/"
|
|
],
|
|
//重新定义默认字体
|
|
'fontdata' => [
|
|
"sun-exta" => [
|
|
'R' => 'MiSans-Regular.ttf', // regular font
|
|
'B' => 'MiSans-Bold.ttf', // optional: bold font
|
|
'I' => 'MiSans-Regular.ttf', // optional: italic font
|
|
'BI' => 'MiSans-Bold.ttf', // optional: bold-italic font
|
|
'useKashida' => 75,
|
|
'sip-ext' => 'MiSans-Regular.ttf', /* SIP=Plane2 Unicode (extension B) */
|
|
]
|
|
],
|
|
'tempDir' => CMS_ROOT . "public/storage/pdf/"
|
|
]);
|
|
$mpdf->SetDisplayMode('fullpage');
|
|
//自动分析录入内容字体
|
|
$mpdf->autoScriptToLang = true;
|
|
$mpdf->autoLangToFont = true;
|
|
//文件名称
|
|
$filename = $name."_".$time.".pdf";
|
|
//文章pdf文件存储路径
|
|
$path = CMS_ROOT . "public" . "/storage/pdf/".$filename;
|
|
$pageNumber = count($mpdf->pages);
|
|
$header= '<table width="100%" style="margin:0;padding:0"><tr>
|
|
<td width="50%" style="text-align:left;font-size:12px; color:#999999;margin:0;padding:0"><img src="'.$logo.'" height="36" /></td>
|
|
<td width="50%" style="text-align:right;font-size:12px; color:#999999;margin:0;padding:0">勾股OA办公系统</td>
|
|
</tr></table><hr style="border-color:#f1f1f1;margin:0">';
|
|
$page= '<p style="text-align:center;font-size:12px; color:#999999">第 {PAGENO}/{nbpg} 页</p>';
|
|
if($is_header){
|
|
$mpdf->SetHTMLHeader($header);
|
|
}
|
|
if($is_page){
|
|
$mpdf->SetHTMLFooter($page);
|
|
}
|
|
//以html为标准分析写入内容
|
|
$mpdf->WriteHTML($html);
|
|
//直接下载文件
|
|
$mpdf->Output('tmp.pdf',true);
|
|
$mpdf->Output($filename,"d");
|
|
exit;
|
|
/*
|
|
//生成磁盘文件
|
|
$mpdf->Output($path);
|
|
if($type==0){
|
|
//下载文件
|
|
if (is_file($path)){
|
|
//return to_assign(0,"文件生成成功");
|
|
$file = fopen($path, "rb");
|
|
Header( "Content-type: application/octet-stream ");
|
|
Header( "Accept-Ranges: bytes ");
|
|
Header( "Content-Disposition: attachment; filename= $filename");
|
|
while (!feof($file)) {
|
|
echo fread($file, 8192);
|
|
ob_flush();
|
|
flush();
|
|
}
|
|
fclose($file);
|
|
} else {
|
|
return to_assign(1,"文件生成失败");
|
|
}
|
|
}
|
|
*/
|
|
}
|
|
}
|