<?php
namespace app\index\controller;
use app\common\util\ExcelUtil;
use app\hander\HelpHander;
use Eden\Mail\Pop3;
use MailSo\Mail\MailClient;
use PhpImap\Mailbox;
use PHPMailer\PHPMailer\Exception;
use PHPMailer\PHPMailer\PHPMailer;
use PhpOffice\PhpWord\PhpWord;
use PhpOffice\PhpWord\TemplateProcessor;
use think\App;
use think\Controller;
use think\Db;
use think\Env;
use think\helper\Time;
use tools\Oaimap;
use tools\Oaimap2;
use tools\Qxsms;
use app\api\controller\v1\HouseFloorInfo;
use Webklex\PHPIMAP\Client;
use Webklex\PHPIMAP\ClientManager;
use Webklex\PHPIMAP\Folder;
class Index extends Controller
{
public function __construct(App $app = null)
{
parent::__construct($app);
// exit();
}
public function delemail(){
exit();
model('Email')->batchDel();
}
public function apply(){
$id = 32884;
$content = '';
$userList = '';
$formJson = '';
$userId = 100221;
model('ApplyRecord')->audit($id,$userId,$content,$formJson,$userList);
}
public function index(){
// $day = "2024-01-04";
// $lastmonth = get_lastmonth_by_day($day);
// halt($lastmonth);
// $day = "1981-11-04";
// halt(calculate_age($day));
//&ipmc_jjzx$.ipmc.
// $qxsms = new Qxsms(config('app.sms_config'));
// $content = "【基建中心】谢正辉提交的上会文件需要您审批。";
// $phone = '13838379499';
// $ret = $qxsms->send($phone,$content);
// dump($qxsms->getError());
// halt($ret);
// $str = 'ABCDEFHHIGKLMNOPGRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890';
// $str1 = msubstr(str_shuffle($str), 0, mt_rand(2,6));
// $str2 = msubstr(str_shuffle($str), 0, mt_rand(2,6));
// $str3 = msubstr(str_shuffle($str), 0, mt_rand(2,6));
// $password = $str1.'&'.$str2.'.'.$str3;
halt(404);
}
public function xgsb(){
exit();
// $salaryRecordId = 521;
$salaryRecordId = 520;
$lists = Db::name('salary_record_special')
->alias('a')
->join('salary_record_log b','b.salary_record_id = a.salary_record_id and b.user_id = a.user_id')
->where('a.salary_record_id',$salaryRecordId)
->field('a.*,b.btjson')
->select();
foreach ($lists as $k=>$v){
$ggj = 0;
$qynj = 0;
$yla = 0;
$yli = 0;
$sye = 0;
$btjson = json_decode($v['btjson'],true);
foreach ($btjson as $kk=>$vv){
// 1=公积金 2=企业年金 3=养老保险 4=医疗保险 5=失业保险
if($vv['sbtype'] == 1){
$ggj += $vv['money'];
}else if($vv['sbtype'] == 2){
$qynj += $vv['money'];
}else if($vv['sbtype'] == 3){
$yla += $vv['money'];
}else if($vv['sbtype'] == 4){
$yli += $vv['money'];
}else if($vv['sbtype'] == 5){
$sye += $vv['money'];
}
}
$data = [
'ljgjj' => $v['ljgjj'] + $ggj*2,
'ljylobx' => $v['ljylobx'] + $yla*2,
'ljsybx' => $v['ljsybx'] + $sye*2,
'ljylibx' => $v['ljylibx'] + $yli*2,
'ljnj' => $v['ljnj'] + $qynj*2,
];
$data['ljsqljxmhj'] = $v['ljsqljxmhj'] + 2*($ggj+$yla+$sye+$yli+$qynj);
Db::name('salary_record_special')->where('id',$v['id'])->update($data);
}
halt(date('Y-m-d H:i:s').'完成');
}
public function dinneruser(){
$lists = Db::name('user')
->alias('a')
->join('user_info b','a.id = b.user_id')
->where('a.enable',1)
->where('a.del',0)
->field('a.id,a.phone,a.password,b.name')
->select();
$lists = $lists?$lists:[];
$count = 0;
foreach ($lists as $k=>$v){
if(!$v['phone']){
continue;
}
$id = Db::name('dinner_user')->where('phone',$v['phone'])->where('del',0)->value('id');
if($id){
continue;
}
Db::name('dinner_user')->insert([
'phone' => $v['phone'],
'password' => $v['password'],
'name' => $v['name'],
'company_id' => 5,
'create_time' => date('Y-m-d H:i:s'),
'enable' => 1,
'del' => 0
]);
$count++;
}
halt($count);
}
public function douser(){ // u1=53 u6=38 u2=40 u3=34 u4=120
exit();
$companyId = input('company/d',0);
if(!in_array($companyId,[1,2,3,4,6])){
halt('参数错误');
}
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load('./u'.$companyId.'.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$keys = ['A','B'];
$data = [];
foreach ($sheet->getRowIterator(2) as $row) {
$tmp = array();
foreach ($row->getCellIterator() as $k=>$cell) {
if(!in_array($k,$keys)){
continue;
}
$val = $cell->getFormattedValue();
if(in_array($k,$keys)){
$tmp[$k] = str_ireplace(',','',$val);
}
}
$data[] = $tmp;
}
dump(count($data));
$count = 0;
foreach ($data as $k=>$v){
$id = Db::name('dinner_user')->where('phone',$v['B'])->where('del',0)->value('id');
if($id){
continue;
}
$ret = Db::name('dinner_user')->insert([
'phone' => $v['B'],
'password' => password_hash('123456',PASSWORD_DEFAULT),
'name' => $v['A'],
'company_id' => $companyId,
'create_time' => date('Y-m-d H:i:s'),
'enable' => 1,
'del' => 0
]);
if($ret){
$count++;
}
}
halt($count);
}
public function email(){
exit();
$lists = Db::name('user_email')->where('id','>',161)->order('id asc')->limit(50)->select();
$lists = $lists?$lists:[];
$count = 0;
$password = "ipmcoa@2020.";
foreach ($lists as $k=>$v){
$ret = $this->editEmail($v['eid'],$v['user_id'],$password);
if($ret){
$count++;
}
}
dump($count);
halt($lists);
}
private function editEmail($id,$userId,$password){
$data = [
'id' => $id,
'password' => $password,
'is_password' => 0,
'uname' => '',
'position' => '',
'tel' => '',
'branch_id' => 0,
'active' => 1, // 启用
'is_imap' => 1,
'limits' => 0,
'limitg' => 0,
'is_convert' => 0,
'login_password' => 0,
'disabled_password' => 1,
'my_spam_mode' => 2,
];
if(!empty($data['password'])){
$data['password'] = $password;
$data['is_password'] = 1;
}
//获取用户最优先的部门
$dep = Db::name('user_job')
->alias('uj')
->join('job j','j.id = uj.job_id')
->join('dep d','d.id = j.dep_id')
->where('uj.user_id',$userId)
->where('j.del',0)
->where('j.enable',1)
->where('d.del',0)
->where('d.enable',1)
->order('d.sorts asc,d.id asc')
->value('d.email_branch');
$data['branch_id'] = $dep?$dep:0;
$config = config('app.email');
$param = [
'_key' => $config['key'],
'_lang' => 'zh-cn',
];
$name = Db::name('user_info')->where('user_id',$userId)->value('name');
$data['uname'] = $name;
$param = array_merge($param,$data);
$url = $config['host'].'User/update';
Db::startTrans();
try{
$sdata = [
'eid' => $data['id'],
'update_time' => date('Y-m-d H:i:s'),
'active' => $data['active']
];
if(!empty($data['password'])){
$sdata['password'] = think_encrypt($data['password']);
}
$res = Db::name('user_email')->where('user_id',$userId)->update($sdata);
if(!$res){
\exception('操作失败');
}
$ret = $this->http_post($url,$param);
if(!$ret){
\exception($this->error);
}
Db::commit();
}catch (\think\Exception $e){
Db::rollback();
trace($e->getMessage());
return false;
}
return true;
}
private function http_post($url,$param){
try{
$ret = curl_post($url,$param);
trace($url);
trace($ret);
$data = json_decode($ret,true);
if($data['status'] == 1){
return $data;
}else{
\exception($data['msg']);
}
}catch (\think\Exception $e){
$this->error = $e->getMessage();
return false;
}
}
public function apply2(){
// $start = '2022-01-28 下午';
// $end = '2022-01-28 下午';
// $type = 1;
// $days = calculate_leave($start,$end,$type);
// halt($days);
// $id = 15016;
// $userId = 100221;
// $content = '同意';
// model('ApplyRecord')->audit($id,$userId,$content,[],[]);
// HelpHander::success([],'操作成功');
$formJson = '[{"componentName":"ddleavefield","components":[{"componentName":"ddleaveselectfield","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":true,"defaultLable":"请假类型","defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":0,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"请假类型选择框","placeholder":false,"print":false,"required":false,"values":"{\"id\":2,\"name\":\"病假\"}"},{"componentName":"dddatefield","defaultApi":0,"defaultAutorekonTime":false,"defaultFormat":"yyyy-MM-dd 上下午","defaultImportant":true,"defaultLable":"开始日期","defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":1,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"日期","placeholder":false,"print":false,"required":false,"values":"2022-01-10 上午"},{"componentName":"dddatefield","defaultApi":0,"defaultAutorekonTime":false,"defaultFormat":"yyyy-MM-dd 上下午","defaultImportant":true,"defaultLable":"结束日期","defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":2,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"日期","placeholder":false,"print":false,"required":false,"values":"2022-01-10 上午"},{"componentName":"ddselectfield","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":false,"defaultLable":"是否离京","defaultOptions":[{"idx":1,"isCheck":false,"text":"是"},{"idx":2,"isCheck":false,"text":"否"}],"defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":3,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"单选框","placeholder":false,"print":false,"required":false,"values":"否"},{"componentName":"dddatefield","defaultApi":0,"defaultAutorekonTime":false,"defaultFormat":"yyyy-MM-dd 上下午","defaultImportant":false,"defaultLable":"离京日期","defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":4,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"日期","placeholder":false,"print":false,"required":false,"values":""},{"componentName":"dddatefield","defaultApi":0,"defaultAutorekonTime":false,"defaultFormat":"yyyy-MM-dd 上下午","defaultImportant":false,"defaultLable":"返京日期","defaultPrint":false,"defaultProps":"请选择","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":5,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"日期","placeholder":false,"print":false,"required":false,"values":""},{"componentName":"textfield","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":false,"defaultLable":"前往地区","defaultPrint":false,"defaultProps":"请输入","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":6,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"单行输入框","placeholder":false,"print":false,"required":false,"values":""}],"defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":true,"defaultLable":"请假套件","defaultPrint":true,"defaultProps":"","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":7,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"请假套件","placeholder":false,"print":false,"required":false},{"componentName":"textareafield","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":true,"defaultLable":"事由及说明","defaultPrint":true,"defaultProps":"请输入","defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":6,"important":true,"inTablefield":false,"isModify":true,"label":true,"name":"多行输入框","placeholder":true,"print":true,"required":true,"values":"就诊"},{"componentName":"ddattachment","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":false,"defaultLable":"附件","defaultPrint":false,"defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":3,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"附件","placeholder":false,"print":false,"required":false,"values":""},{"componentName":"ddphotofield","defaultApi":0,"defaultAutorekonTime":false,"defaultImportant":false,"defaultLable":"图片","defaultPrint":false,"defaultShow":false,"defaultTotal":false,"defaultTranslate":false,"idx":8,"important":false,"inTablefield":false,"isModify":true,"label":false,"name":"图片","placeholder":false,"print":false,"required":false,"values":"http://oaapi.dr-ipmc.org.cn/uploads2/20220110/7a3838a1e2945a45c0027ac9dc5942c1.jpeg"}]';
$formJson = json_decode($formJson,true);
$start = '';
$end = '';
$isleavebj = '否'; // 默认不离京
$lbjstart = '';
$lbjend = '';
$address = '';
$type = 1; // 1=减去节假日 0=不减节假日
$data = [
'org_id' => 3,
'user_id' => 1,
'apply_id' => 5650,
'create_time' => date('Y-m-d H:i:s'),
'status' => 0
];
foreach ($formJson as $k=>$v){
if($v['componentName'] == 'ddleavefield'){
foreach ($v['components'] as $key=>$val){
switch ($val['idx']){
case '0':
$leave = json_decode($val['values'],true);
$data['leave_type'] = $leave['id'];
break;
case '1':
$start = $val['values'];
$starts = explode(' ',$start);
if($starts[count($starts)-1] == '上午'){
$data['start_time'] = $starts[0].' 00:00:00';
}else{
$data['start_time'] = $starts[0].' 12:00:00';
}
break;
case '2':
$end = $val['values'];
$ends = explode(' ',$end);
if($ends[count($ends)-1] == '上午'){
$data['end_time'] = $ends[0].' 11:59:59';
}else{
$data['end_time'] = $ends[0].' 23:59:59';
}
break;
case '3':
$isleavebj = isset($val['values'])?$val['values']:'否';
break;
case '4':
$lbjstart = isset($val['values'])?$val['values']:'';
break;
case '5':
$lbjend = isset($val['values'])?$val['values']:'';
break;
case '6':
$address = isset($val['values'])?$val['values']:'';
break;
}
}
break;
}
}
if($data['leave_type'] == 6){// 产假，不减节假日
$type = 0;
}
dump($start);
dump($end);
dump($type);
$data['days'] = calculate_leave($start,$end,$type);
$data['cur_days'] = $data['days'];
halt($data);
}
public function sb(){
exit();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load('./xinhua.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$keys = ['A','G','I','K','N','P','R','T','X','Z','AC','AE'];
$data = [];
foreach ($sheet->getRowIterator(2) as $row) {
$tmp = array();
foreach ($row->getCellIterator() as $k=>$cell) {
if(!in_array($k,$keys)){
continue;
}
$val = $cell->getFormattedValue();
if(in_array($k,$keys)){
$tmp[$k] = floatval(str_ireplace(',','',$val));
}
}
$data[] = $tmp;
}
// halt($data);
$salaryId = 370;
$num1 = $num2 = 0;
foreach ($data as $k=>$v){
$ret = Db::name('salary_record_sb')
->where('salary_record_id',$salaryId)
->where('user_id',$v['A'])
->find();
if($ret){
$res = Db::name('salary_record_sb')->where('id',$ret['id'])->update([
'ylap' => $ret['ylap'] + floatval($v['G']),
'syep' => $ret['syep'] + floatval($v['I']),
'ylip' => $ret['ylip'] + floatval($v['K']),
'ylac' => $ret['ylac'] + floatval($v['N']),
'syec' => $ret['syec'] + floatval($v['P']),
'ylic' => $ret['ylic'] + floatval($v['R']),
'gsc' => $ret['gsc'] + floatval($v['T']),
'gjjp' => $ret['gjjp'] + floatval($v['X']),
'gjjc' => $ret['gjjc'] + floatval($v['Z']),
'qynjp' => $ret['qynjp'] + floatval($v['AC']),
'qynjc' => $ret['qynjc'] + floatval($v['AE']),
]);
if($res){
$num1++;
}
}
$ret = Db::name('salary_record_special')
->where('salary_record_id',$salaryId)
->where('user_id',$v['A'])
->find();
if($ret){
$res = Db::name('salary_record_special')->where('id',$ret['id'])->update([
'ljgjj' => $ret['ljgjj'] + floatval($v['X']),
'ljnj' => $ret['ljnj'] + floatval($v['AC']),
'ljsybx' => $ret['ljsybx'] + floatval($v['I']),
'ljylobx' => $ret['ljylobx'] + floatval($v['G']),
'ljylibx' => $ret['ljylibx'] + floatval($v['K']),
'ljsqljxmhj' => $ret['ljsqljxmhj'] + floatval($v['X']) + floatval($v['AC']) + floatval($v['I']) + floatval($v['G']) + floatval($v['K'])
]);
if($res){
$num2++;
}
}
}
dump($num1);
dump($num2);
halt($data);
}
public function oa(){
exit();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load('./oa.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$keys = ['A','F','G','I','J','K','N','O','Q','R'];
$data = [];
foreach ($sheet->getRowIterator(2) as $row) {
$tmp = array();
foreach ($row->getCellIterator() as $k=>$cell) {
if(!in_array($k,$keys)){
continue;
}
$val = $cell->getFormattedValue();
if(in_array($k,$keys)){
$tmp[$k] = floatval(str_ireplace(',','',$val));
}
}
$data[] = $tmp;
}
$salaryId = 376;
$num1 = $num2 = 0;
foreach ($data as $k=>$v){
$ret = Db::name('salary_record_sb')
->where('salary_record_id',$salaryId)
->where('user_id',$v['A'])
->find();
if($ret){
$res = Db::name('salary_record_sb')->where('id',$ret['id'])->update([
'syep' => $ret['syep'] + floatval($v['F']),
'ylip' => $ret['ylip'] + floatval($v['G']),
'syec' => $ret['syec'] + floatval($v['I']),
'ylic' => $ret['ylic'] + floatval($v['J']),
'gsc' => $ret['gsc'] + floatval($v['K']),
'gjjp' => $ret['gjjp'] + floatval($v['N']),
'gjjc' => $ret['gjjc'] + floatval($v['O']),
]);
if($res){
$num1++;
}
}
$ret = Db::name('salary_record_special')
->where('salary_record_id',$salaryId)
->where('user_id',$v['A'])
->find();
if($ret){
$res = Db::name('salary_record_special')->where('id',$ret['id'])->update([
'ljgjj' => $ret['ljgjj'] + floatval($v['N']),
'ljsybx' => $ret['ljsybx'] + floatval($v['F']),
'ljylibx' => $ret['ljylibx'] + floatval($v['G']),
'ljsqljxmhj' => $ret['ljsqljxmhj'] + floatval($v['N']) + floatval($v['F']) + floatval($v['G'])
]);
if($res){
$num2++;
}
}
}
dump($num1);
dump($num2);
halt($data);
}
public function save(){
$username = "hzd@dr-ipmc.org.cn";
$password = "12345678";
$c = new Oaimap($username,$password);
$filepath = './email/';
$ret = $c->messageMimeStream('Sent','30','',false,$filepath);
// $c->putFile($filepath,$ret['resource']);
dump(file_get_contents($ret['resource']));
halt($ret);
}
public function important(){
// 已办结的改成已完成
$count = Db::name('important_record')->where('status',2)->setField('status',5);
dump($count);
$count2 = Db::name('important_record')->where('status',0)->where('pid',0)->setField('status',1);
dump($count2);
}
public function salary(){
return false;
//工伤（单位）=取两位小数（基数*0.003）+取两位小数（基数*0.003）-取两位小数（基数*0.0024）
$lists = Db::name('salary_record_sb')->where('salary_record_id',360)->field('id,sb,gsc')->select();
$count = 0;
foreach ($lists as $k=>$v){
$ngsc = round($v['sb']*0.003,2) + round($v['sb']*0.003,2) - round($v['sb']*0.0024,2);
$lists[$k]['ngsc'] = $ngsc;
if($ngsc != $v['gsc']){
$count++;
Db::name('salary_record_sb')->where('id',$v['id'])->update(['gsc'=>$ngsc]);
}
}
halt($lists);
}
public function salarysy(){
return false;
//失业（单位）=取两位小数（基数*0.005）- (取两位小数（基数*0.008）-取两位小数（基数*0.005）)
$lists = Db::name('salary_record_sb')->where('salary_record_id',360)->field('id,sb,syec')->select();
$count = 0;
foreach ($lists as $k=>$v){
$ngsc = round($v['sb']*0.005,2) - (round($v['sb']*0.008,2) - round($v['sb']*0.005,2));
$lists[$k]['nsyec'] = $ngsc;
if($ngsc != $v['syec']){
$count++;
Db::name('salary_record_sb')->where('id',$v['id'])->update(['syec'=>$ngsc]);
}
}
halt($lists);
}
public function salary2(){
return false;
$sid = 319;
$lists = Db::name('salary_record_log')->where('salary_record_id',$sid)->field('id,user_id,btjson')->select();
foreach ($lists as $k=>$v){
$btjson = json_decode($v['btjson'],true);
$bt = 0;
foreach ($btjson as $kk=>$vv){
if($vv['id'] == 50){
$bt = $vv['money'];
}
}
$info = Db::name('salary_record_special')->where('salary_record_id',$sid)->where('user_id',$v['user_id'])->find();
if($info){
Db::name('salary_record_special')->where('id',$info['id'])->update([
'ljsybx' => round($info['ljsybx'] - $bt,2),
'ljsqljxmhj' => round($info['ljsqljxmhj'] - $bt,2)
]);
}
$sb = Db::name('salary_record_sb')->where('salary_record_id',$sid)->where('user_id',$v['user_id'])->find();
if($sb){
Db::name('salary_record_sb')->where('id',$sb['id'])->update([
'syep' => round($sb['syep'] + $bt,2),
]);
}
$lists[$k]['bt'] = $bt;
}
halt($lists);
}
public function index2(){
$val = '';
$val = (float)$val;
halt($val);
$url = 'https://www.lzfh.com/api/dwz.php?cb=1&sturl=3&longurl=http://yyh2.app8888.top/index/user/register/invite_code/JT5XVC.html';
$ret = curl_post($url);
// $ret = file_get_contents($url);
halt($ret);
return false;
$username = "hfp@dr-ipmc.org.cn";
$password = "12345678";
$c = new Oaimap($username,$password);
// $ret = $c->getMessages('Drafts');
// $ret = $c->getMessageByUid('Drafts',5008);
$fromFolder = 'Archive';
$toFolder = 'Trash';
$uids = 6;
$ret = $c->messageMove($fromFolder,$toFolder,$uids,true);
halt($ret);
// 输入文件标签
// Header("Content-type: application/octet-stream");
// Header("Accept-Ranges: bytes");
// Header("Accept-Length: ".$ret['size']);
// Header("Content-Disposition: attachment; filename=" . $ret['name']);
// // 输出文件内容
// echo $ret['content'];
// exit;
}
public function sendMail(){
$username = "hfp@dr-ipmc.org.cn";
$password = "12345678";
$c = new Oaimap($username,$password);
$data = [
'subject' => '3333',
'body' => '4444',
'to' => '[{"email":"hzd@dr-ipmc.org.cn","name":"黄志东"}]',
'cc' => '[]',
'bcc' => '',
'attachment' => '[{"size":974,"name":"JZBRPLYM.png","big":0,"md5":"","url":"http://test.dr-ipmc.org.cn/uploads/20210712/c733555eda22f153b44b4680461f0e67.png"}]', // [{"big":0,"md5":"sdssfwe232323rfwefwef","url":"","name":"","size":122,"source":{"mimeIndex":"","uid":"1","folder":"Sent"}}}]
'bookTime' => '',
'priority' => 1,
'dnt' => 0, // 0=阅读不回复 1=阅读回复
'draftFolder' => 'Drafts', // 保存草稿时传
'messageFolder' => '',// 编辑草稿箱时填写
'messageUid' => '', // 编辑草稿箱uid
'draftInfo' => null, // 回复、转发
'inReplyTo' => '',
'references' => '',
'dsn' => 0 // 0=发送成功不回复 1=发送成功回复
];
$from = [
'name' => 'hfp',
'email' => 'hfp@dr-ipmc.org.cn'
];
$data['from'] = $from;
$ret = $c->sendMessage($data);
halt($ret);
// $this->createEml($data,$from);
// exit();
}
public function createEml($data,$from){
$date = date('D, d M Y H:i:s');
$data['date'] = $date;
$altbody = strip_tags($data['body']);
$messageId = md5(json_encode($data));
$partend = get_rand_num().'.'.time();
$part1 = '1_'.$partend;
$emlstr = "Mime-Version: 1.0".PHP_EOL;
$emlstr .= "Date: ".$date.' +0800'.PHP_EOL;
$emlstr .= "Content-Type: multipart/mixed;".PHP_EOL;
$emlstr .= " boundary=\"--=_Part_{$part1}\"".PHP_EOL;
$emlstr .= "Message-ID: <{$messageId}@localhost>".PHP_EOL;
$emlstr .= "X-Mailer: Postfix".PHP_EOL;
if($data['book_time']){
$emlstr .= "TimedSendDate: 1".PHP_EOL;
}
$emlstr .= 'From: "=?utf-8?B?'.base64_encode($from['name']).'?=" <'.$from['email'].'>'.PHP_EOL;
$tos = json_decode($data['to'],true);
$tostr = [];
foreach ($tos as $k=>$v){
$str = '';
if($v['name']){
$str .= '"=?utf-8?B?'.base64_encode($v['name']).'?=" <'.$v['email'].'>';
}else{
$str .= '<'.$v['email'].'>';
}
$tostr[] = $str;
}
$emlstr .= 'To: '.implode(',',$tostr).PHP_EOL;
$ccs = json_decode($data['cc'],true);
if($ccs){
$ccstr = [];
foreach ($ccs as $k=>$v){
$str = '';
if($v['name']){
$str .= '"=?utf-8?B?'.base64_encode($v['name']).'?=" <'.$v['email'].'>';
}else{
$str .= '<'.$v['email'].'>';
}
$ccstr[] = $str;
}
$emlstr .= 'Cc: '.implode(',',$ccstr).PHP_EOL;
}
$bccs = json_decode($data['bcc'],true);
if($bccs){
$bccstr = [];
foreach ($bccs as $k=>$v){
$str = '';
if($v['name']){
$str .= '"=?utf-8?B?'.base64_encode($v['name']).'?=" <'.$v['email'].'>';
}else{
$str .= '<'.$v['email'].'>';
}
$bccstr[] = $str;
}
$emlstr .= 'Bcc: '.implode(',',$bccstr).PHP_EOL;
}
if($data['dnt'] == 1){
$emlstr .= 'Disposition-Notification-To: '.$from['name'].PHP_EOL;
$emlstr .= 'X-Confirm-Reading-To: '.$from['name'].PHP_EOL;
}
if($data['priority'] == 1){
$emlstr .= 'X-Priority: 1 (Highest)'.PHP_EOL;
}
$emlstr .= 'Subject: =?utf-8?B?'.base64_encode($data['subject']).'?='.PHP_EOL;
$emlstr .= PHP_EOL.'----=_Part_'.$part1.PHP_EOL;
$part2 = '2_'.$partend;
$emlstr .= "Content-Type: multipart/alternative;".PHP_EOL;
$emlstr .= " boundary=\"--=_Part_{$part2}".PHP_EOL;
$emlstr .= PHP_EOL.'----=_Part_'.$part2.PHP_EOL;
$emlstr .= 'Content-Type: text/plain; charset="utf-8"'.PHP_EOL;
$emlstr .= 'Content-Transfer-Encoding: quoted-printable'.PHP_EOL;
$emlstr .= PHP_EOL.quoted_printable_encode($altbody).PHP_EOL;
$emlstr .= PHP_EOL.'----=_Part_'.$part2.PHP_EOL;
$emlstr .= 'Content-Type: text/html; charset="utf-8"'.PHP_EOL;
$emlstr .= 'Content-Transfer-Encoding: quoted-printable'.PHP_EOL;
$emlstr .= PHP_EOL.quoted_printable_encode($data['body']).PHP_EOL;
$emlstr .= PHP_EOL.'----=_Part_'.$part2.'--'.PHP_EOL;
// 附件
// $emlstr .= PHP_EOL.'----=_Part_'.$part1.PHP_EOL;
// $emlstr .= 'Content-Type: image/png; name="favicon.png"'.PHP_EOL;
// $emlstr .= 'Content-Disposition: attachment; filename="favicon.png"'.PHP_EOL;
// $emlstr .= 'Content-Transfer-Encoding: base64'.PHP_EOL;
// $emlstr .= PHP_EOL.base64_encode(file_get_contents('./favicon.png')).PHP_EOL;
// $emlstr .= PHP_EOL.'----=_Part_'.$part1.'--'.PHP_EOL;
file_put_contents('./email/'.date('Ymd_').$messageId.'.eml', $emlstr);
}
public function login(){
$email = 'hzd@dr-ipmc.org.cn';
$res = model('Email')->login($email);
halt($res);
}
public function p(){
halt(config('database.db_email'));
$url = "http://124.71.111.86:8010/Api/Smtp/send";
$param = [
'_key' => '3zMTJH1WHxYVz7yr',
'_lang' => 'zh-cn',
'from' => 'test@dr-ipmc.org.cn',
'from_name' => 'hzdong',
'to' => '13838379499@163.com',
'subject' => 'test',
'content' => 'Neri',
'save_sent' => 1
];
$ret = curl_post($url,$param);
halt(json_decode($ret,true));
}
public function send(){
$mail = new PHPMailer(true);
try {
//服务器配置
$mail->CharSet ="UTF-8"; //设定邮件编码
$mail->isSMTP(); // 使用SMTP
$mail->Host = 'mail.dr-ipmc.org.cn'; // SMTP服务器
$mail->SMTPAuth = true; // 允许 SMTP 认证
$mail->Username = 'hzd@dr-ipmc.org.cn'; // SMTP 用户名 即邮箱的用户名
$mail->Password = '12345678'; // SMTP 密码 部分邮箱是授权码(例如163邮箱)
$mail->Port = 25; // 服务器端口 25 或者465 具体要看邮箱服务器支持
$mail->SMTPOptions = array(
'ssl' => array(
'verify_peer' => false,
'verify_peer_name' => false,
'allow_self_signed' => true
)
);
// 设置优先级(1:紧急 3:普通 5:低)
//message.setHeader("X-Priority", "1");
// 要求阅读回执(收件人阅读邮件时会提示回复发件人,表明邮件已收到,并已阅读)
//message.setHeader("Disposition-Notification-To", from);
$mail->setFrom('hzd@dr-ipmc.org.cn', 'hzd'); //发件人
$mail->addAddress('1570246817@qq.com', '黄志东'); // 收件人
//$mail->addAddress('ellen@example.com'); // 可添加多个收件人
// $mail->addReplyTo('xxxx@163.com', 'info'); //回复的时候回复给哪个邮箱 建议和发件人一致
//$mail->addCC('cc@example.com'); //抄送
//$mail->addBCC('bcc@example.com'); //密送
//发送附件
// $mail->addAttachment('../xy.zip'); // 添加附件
// $mail->addAttachment('../thumb-1.jpg', 'new.jpg'); // 发送附件并且重命名
//Content
$mail->isHTML(true); // 是否以HTML文档格式发送 发送后客户端可直接显示对应HTML内容
$mail->Subject = '这里是邮件标题' . time();
$mail->Body = '<h1>这里是邮件内容</h1>' . date('Y-m-d H:i:s');
$mail->AltBody = '如果邮件客户端不支持HTML则显示此内容';
$ret = $mail->send();
dump($mail->getLastMessageID());
dump($ret);
echo '邮件发送成功';
} catch (Exception $e) {
echo '邮件发送失败: ', $mail->ErrorInfo;
}
}
public function email111(){
$username = "hzd@dr-ipmc.org.cn";
$password = "12345678";
$c = new Oaimap($username,$password);
$ret = $c->getMessageByUid('INBOX',11);
// $msg = file_get_contents('./msg.eml');
// $ret = $c->getFoldersTree($msg);
// $ret = $c->getMessages();
// $c->disconnect();
// $header = [];
// foreach ($ret as $message){
// dump($message->getSubject()) ;
// }
halt($ret);
}
public function email2(){
$username = "hzd@dr-ipmc.org.cn";
$password = "12345678";
$c = new Oaimap2($username,$password);
$ret = $c->getMessageByUid('INBOX',11);
// $msg = file_get_contents('./msg.eml');
// $ret = $c->getFoldersTree($msg);
// $ret = $c->getMessages();
// $c->disconnect();
// $header = [];
// foreach ($ret as $message){
// dump($message->getSubject()) ;
// }
halt($ret);
}
public function mailso(){
include \think\facade\Env::get('root_path') . 'extend/MailSo/MailSo.php';
$username = "hzd@dr-ipmc.org.cn";
$password = "12345678";
$sLogFileFullPath = 'E:/website/';
define('APP_START_TIME', time());
// $oDriver = \MailSo\Log\Drivers\File::NewInstance($sLogFileFullPath);
$oDriver = \MailSo\Log\Drivers\Syslog::NewInstance();
$oLogger = \MailSo\Log\Logger::SingletonInstance()->Add(
$oDriver->WriteOnErrorOnly(false)
->WriteOnPhpErrorOnly(false)
->WriteOnTimeoutOnly(20)
);
$oMailClient = MailClient::NewInstance()->SetLogger($oLogger);
// $oData = $oMailClient
// ->Connect('mail.dr-ipmc.org.cn', 143)
// ->Login($username, $password)
// ->MessageList('INBOX',0,10);
//
// $list = $this->responseObject($oData, 'MessageList');
// $oData = $oMailClient
// ->Connect('mail.dr-ipmc.org.cn', 143)
// ->Login($username, $password)
// ->Message('INBOX',12);
//
// $list = $this->responseObject($oData, 'Message');
$oData = $oMailClient
->Connect('mail.dr-ipmc.org.cn', 143)
->Login($username, $password)
->Folders();
$list = $this->responseObject($oData);
// $ret = $this->std_class_object_to_array($oData);
halt($list);
}
public function std_class_object_to_array($stdclassobject)
{
$array = [];
$_array = is_object($stdclassobject) ? get_object_vars($stdclassobject) : $stdclassobject;
foreach ($_array as $key => $value) {
$value = (is_array($value) || is_object($value)) ? $this->std_class_object_to_array($value) : $value;
$array[$key] = $value;
}
return $array;
}
public function index3(){
$config = config('app.imap');
// halt($config);
$cm = new ClientManager($config);
$oClient = $cm->account();
$oClient->connect();
$folders = $oClient->getFolders();
//Loop through every Mailbox
/** @var \Webklex\PHPIMAP\Folder $folder */
foreach($folders as $folder){
//Get all Messages of the current Mailbox $folder
/** @var \Webklex\PHPIMAP\Support\MessageCollection $messages */
$messages = $folder->messages()->all()->get();
/** @var \Webklex\PHPIMAP\Message $message */
foreach($messages as $message){
dump(is_utf8($message->getSubject()));
if(!is_utf8($message->getSubject())){
echo iconv("GBK","UTF-8",$message->getSubject()).'<br />';
}else{
echo $message->getSubject().'<br />';
}
echo 'Attachments: '.$message->getAttachments()->count().'<br />';
echo $message->getHTMLBody().'<br />';
//Move the current Message to 'INBOX.read'
// if($message->move('INBOX.read') == true){
// echo 'Message has ben moved';
// }else{
// echo 'Message could not be moved';
// }
}
}
exit();
// $aFolder = $oClient->getFolders();
// $ret = $oClient->createFolder('ssss.sssss');
// halt($ret);
$folder = $oClient->getFolderByPath('INBOX');
$aMessage = $folder->messages()->all()->get();
include \think\facade\Env::get('root_path') . 'extend/MailSo/lib/MailSo/Base/Utils.php';
foreach($aMessage as $oMessage){
// echo imap_mime_header_decode($oMessage->getAttributes()["subject"]).'<br />';
echo \MailSo\Base\Utils::Utf8Clear($oMessage->getAttributes()["subject"]).'<br />';
echo 'Attachments: '.$oMessage->getAttachments()->count().'<br />';
// echo $oMessage->getHTMLBody(true);
//Move the current Message to 'INBOX.read'
// if($oMessage->moveToFolder('INBOX.read') == true){
// echo 'Message has ben moved';
// }else{
// echo 'Message could not be moved';
// }
}
halt('1111');
$aFolder = $oClient->getFolders();
foreach($aFolder as $oFolder){
// $info = $oFolder->overview('1:*');
$ret = $oFolder->getClient()->createFolder('subsss');
halt($ret);
dump($oFolder->path);
dump($oFolder->name);
dump($oFolder->full_name);
dump($oFolder->children);
halt(1111);
// dump($info);
//
// //Get all Messages of the current Mailbox $oFolder
// /** @var \Webklex\PHPIMAP\Support\MessageCollection $aMessage */
// $aMessage = $oFolder->messages()->all()->get();
//
// /** @var \Webklex\PHPIMAP\Message $oMessage */
// foreach($aMessage as $oMessage){
// echo $oMessage->getSubject().'<br />';
// echo 'Attachments: '.$oMessage->getAttachments()->count().'<br />';
// echo $oMessage->getHTMLBody(true);
//
// //Move the current Message to 'INBOX.read'
//// if($oMessage->moveToFolder('INBOX.read') == true){
//// echo 'Message has ben moved';
//// }else{
//// echo 'Message could not be moved';
//// }
// }
}
// $aMessage = $oFolder->query()->all()->get();
// halt($aMessage);
}
public function import(){
halt('1111');
$start = "2021-05-01 00:00:00";
$end = "2021-05-31 23:59:59";
$lists = Db::name('file')
->where('del',0)
->where('enable',1)
->where('create_time','>=',$start)
->where('create_time','<=',$end)
->order('id asc')
->select();
$sn = $this->createNewSn(4);
Db::startTrans();
try{
foreach ($lists as $k=>$v){
$data = [
'title' => $v['title'],
'sn' => $sn,
'source' => $v['source'],
'proof' => $v['sn'],
'org_id' => 4,
'transfer' => 1,
'status' => 1,
'transfer_id' => $v['id'],
'create_time' => $v['create_time']
];
$ret = Db::name('important')->insert($data);
if(!$ret){
\exception('操作失吧');
}
$sn++;
}
Db::commit();
echo '操作完成';
}catch (\think\Exception $e){
Db::commit();
halt('错误'.$e->getMessage());
}
}
private function createNewSn($orgId){
$newsn = '';
$sn = Db::name('important')->where('del',0)->where('org_id',$orgId)->order('id desc')->value('sn');
$curY = date('y');
if(!$sn){
$newsn = $curY.'0001';
}else{
$y = substr($sn,0,2);
if($curY != $y){
$newsn = $curY.'0001';
}else{
$newsn = $sn+1;
}
}
return $newsn;
}
private function matchMailHead($str){
$headList = array();
$headArr = array(
'from',
'to',
'date',
'subject'
);
foreach ($headArr as $key){
if(preg_match('/'.$key.':(.*?)[\n\r]/is', $str,$m)){
$match = trim($m[1]);
$headList[$key] = $key=='date'?date('Y-m-d H:i:s',strtotime($match)):$match;
}
}
return $headList;
}
public function word4(){
$PHPWord = new PhpWord();
$templateProcessor = new TemplateProcessor(__DIR__.'\test.docx');
$arr = [
[
'programSn' => 'N0001',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'name' => [
['name' => '未制定安全生','val'=>'sss'],
['name' => '未制定安全生','val'=>'sss'],
]
],
[
'programSn' => 'N0002',
'company' => '新华',
'fhUserName' => '张三2',
'agent' => '李四2',
'name' => [
['name' => '未制定安全生','val'=>'sss'],
['name' => '未制定安全生','val'=>'sss'],
]
],
];
$templateProcessor->cloneBlock('block_name', 0, true, false, $arr);
// 循环次数
$count = count($arr);
// $templateProcessor->cloneRow('programSn', $count); //复制行、
// foreach ($arr as $kk => $vv) {
// $list = '';
// for ($i = 0; $i < count($vv['list']); $i++) {
// if ($i == (count($vv['list']) - 1)) {
// $list = $list . ($i + 1) . ' .${name#' . ($kk + 1) . '#' . ($i + 1) . '}';
// } else {
// // <w:br/> 换行符
// $list = $list . ($i + 1) . ' .${name#' . ($kk + 1) . '#' . ($i + 1) . '}<w:br/>';
// }
// }
// $templateProcessor->setValue('name#' . ($kk + 1), $list);
// }
// 保存新word文档
$path = md5(time());
// 将 word 文档保存至 你设置的路径
$templateProcessor->saveAs('./zss' . time() . ".docx");
}
public function word(){
$templateProcessor = new TemplateProcessor(__DIR__.'/../../../public/word/stamp_tmp.docx');
$templateProcessor->setValue('firstname', 'John');
$templateProcessor->setValue('lastname', 'Doe');
$arr = [
[
'programSn' => 'N0001',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'name1' => '应税凭证名称',
'title' => '111',
'name2' => '对方单位名称',
'company2' => '111',
'name3' => '签订日期',
'handleDate' => '111',
'name4' => '适用印花税税目',
'stampTitle' => '111',
'name5' => '计税金额',
'money' => '111',
'name6' => '适用税率',
'stampBl' => '111',
'name7' => '本期应纳税额',
'sdMoney' => '111',
],
[
'programSn' => 'N0002',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'name1' => '应税凭证名称',
'title' => '111',
'name2' => '对方单位名称',
'company2' => '111',
'name3' => '签订日期',
'handleDate' => '111',
'name4' => '适用印花税税目',
'stampTitle' => '111',
'name5' => '计税金额',
'money' => '111',
'name6' => '适用税率',
'stampBl' => '111',
'name7' => '本期应纳税额',
'sdMoney' => '111',
],
];
$templateProcessor->cloneBlock('block_name', 0, true, false, $arr);
$templateProcessor->cloneBlock('block_name2', 0, true, false, $arr);
// 将 word 文档保存至 你设置的路径
$file_dir = './word/zs' . time() . ".docx";
$templateProcessor->saveAs($file_dir);
$file = fopen ( $file_dir, "rb" );//以只读和二进制模式打开文件
Header ( "Content-type: application/octet-stream" ); //告诉浏览器这是一个文件流格式的文件
Header ( "Accept-Ranges: bytes" ); //请求范围的度量单位
Header ( "Accept-Length: " . filesize ( $file_dir ) ); //Content-Length是指定包含于请求或响应中数据的字节长度
//用来告诉浏览器，文件是可以当做附件被下载，下载后的文件名称为$file_name该变量的值。
Header ( "Content-Disposition: attachment; filename=印花税计算表.docx" );
echo fread ( $file, filesize ( $file_dir ) ); //读取文件内容并直接输出到浏览器
fclose ( $file );
@unlink($file_dir);
exit ();
}
public function word2(){
$templateProcessor = new TemplateProcessor(__DIR__.'/../../../public/word/gerenjianli(1).docx');
$templateProcessor->setValue('name', 'John');
// $templateProcessor->setValue('lastname', 'Doe');
$arr = [
[
'project' => 'N0001',
'project_time' => '中心',
'project_content' => '张三',
'project_link' => '李四',
'project_yeji' => '应税凭证名称',
],
[
'project' => 'N0002',
'project_time' => '中心2',
'project_content' => '张三',
'project_link' => '李四',
'project_yeji' => '应税凭证名称',
],
];
$templateProcessor->cloneBlock('block_name2', 0, true, false, $arr);
// $templateProcessor->cloneBlock('block_name2', 0, true, false, $arr);
$arr2 = [
[
'programSn' => 'N0001',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'name1' => '应税凭证名称',
'title' => '111',
'name2' => '对方单位名称',
'company2' => '111',
'name3' => '签订日期',
'handleDate' => '111',
'name4' => '适用印花税税目',
'stampTitle' => '111',
'name5' => '计税金额',
'money' => '111',
'name6' => '适用税率',
'stampBl' => '111',
'name7' => '本期应纳税额',
'sdMoney' => '111',
],
[
'programSn' => 'N0002',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'name1' => '应税凭证名称',
'title' => '111',
'name2' => '对方单位名称',
'company2' => '111',
'name3' => '签订日期',
'handleDate' => '111',
'name4' => '适用印花税税目',
'stampTitle' => '111',
'name5' => '计税金额',
'money' => '111',
'name6' => '适用税率',
'stampBl' => '111',
'name7' => '本期应纳税额',
'sdMoney' => '111',
],
];
$templateProcessor->cloneBlock('block_name3', 0, true, false, $arr2);
// 将 word 文档保存至 你设置的路径
$file_dir = './word/zs' . time() . ".docx";
$templateProcessor->saveAs($file_dir);
$file = fopen ( $file_dir, "rb" );//以只读和二进制模式打开文件
Header ( "Content-type: application/octet-stream" ); //告诉浏览器这是一个文件流格式的文件
Header ( "Accept-Ranges: bytes" ); //请求范围的度量单位
Header ( "Accept-Length: " . filesize ( $file_dir ) ); //Content-Length是指定包含于请求或响应中数据的字节长度
//用来告诉浏览器，文件是可以当做附件被下载，下载后的文件名称为$file_name该变量的值。
Header ( "Content-Disposition: attachment; filename=印花税计算表.docx" );
echo fread ( $file, filesize ( $file_dir ) ); //读取文件内容并直接输出到浏览器
fclose ( $file );
@unlink($file_dir);
exit ();
}
public function wordold(){
$PHPWord = new PhpWord();
$templateProcessor = new TemplateProcessor(__DIR__.'\test.docx');
$arr = [
[
'programSn' => 'N0001',
'company' => '中心',
'fhUserName' => '张三',
'agent' => '李四',
'list' => [
['list' => '未制定安全生产责任制，扣10分；未经责任人签字确认，扣5分'],
['list' => '未制定安全生产责任制，扣9分；未经责任人签字确认，扣2分'],
]
],
[
'programSn' => 'N0002',
'company' => '新华',
'fhUserName' => '张三2',
'agent' => '李四2',
'list' => [
['list' => '未制定安全生产责任制，扣10分；未经责任人签字确认，扣5分'],
['list' => '未制定安全生产责任制，扣9分；未经责任人签字确认，扣2分'],
]
],
];
// 循环次数
$count = count($arr);
$templateProcessor->cloneRow('programSn', $count); //复制行、
foreach ($arr as $kk => $vv) {
$list = '';
for ($i = 0; $i < count($vv['list']); $i++) {
if ($i == (count($vv['list']) - 1)) {
$list = $list . ($i + 1) . ' .${list#' . ($kk + 1) . '#' . ($i + 1) . '}';
} else {
// <w:br/> 换行符
$list = $list . ($i + 1) . ' .${list#' . ($kk + 1) . '#' . ($i + 1) . '}<w:br/>';
}
}
$templateProcessor->setValue('list#' . ($kk + 1), $list);
}
// 保存新word文档
$path = md5(time());
// 将 word 文档保存至 你设置的路径
$templateProcessor->saveAs('./zs' . time() . ".docx");
}
public function word3(){
header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document');
header('Content-Disposition: attachment;filename="印花税单.docx"');
header('Cache-Control: max-age=0');
$html = '';
$html .= '<div class="stamp-box">';
$html .= '<div class="stamp-title"> 印花税计算表 </div>';
$html .= '<div class="stamp-desc"> 项目编号: {{ item.programSn }} </div>';
$html .= '<div class="stamp-desc"> 报税单位: {{ item.company }} <span class="pull-right">单位: 元</span> </div>';
$html .= '<table border="1" style="width:100%;border-color: #000;">';
$html .= '<tr> <td width="150">应税凭证名称</td><td>{{ item.title }}</td></tr>';
$html .= '<tr><td>对方单位名称</td><td>{{ item.company2 }}</td></tr>';
$html .= '<tr><td>签订日期</td><td>{{ item.handleDate }}</td></tr>';
$html .= '<tr><td>适用印花税税目</td><td>{{ item.stamp.title }}</td></tr>';
$html .= '<tr><td>计税金额</td><td>{{ item.money }}</td></tr>';
$html .= '<tr><td>适用税率</td><td>{{ item.stamp.bl }}‰</td></tr>';
$html .= '<tr><td>本期应纳税额</td><td>{{ item.sdMoney }}</td></tr>';
$html .= '</table>';
$html .= '<table style="width:100%;margin-top: 5px;"><tr><td>核税人: {{ item.fhUserName }}</td><td /><td>填报人: {{ item.agent }}</td><td /></tr></table>';
$html .= '</div>';
$phpword = new PhpWord();
$section = $phpword->addSection();
\PhpOffice\PhpWord\Shared\Html::addHtml($section, $html, false, false);
$objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpword, 'Word2007');
$objWriter->save('php://output');
}
public function import2(){
exit();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
// $spreadsheet = $reader->load('./xinhua.xlsx');
$spreadsheet = $reader->load('./mx.xls');
$sheet = $spreadsheet->getActiveSheet();
// $users = Db::name('user_info')->column('user_id','name');
$adds = Db::name('asset_add')->column('id','title');
$cates = Db::name('asset_cate')->column('id','title');
$units = Db::name('asset_unit')->column('id','title');
$classs = Db::name('asset_class')->column('id','title');
$enables = ['使用' => 2,'在库' => 1];
$company = 2;
$orgId = 4;
$res = array();
$keys = ['A','B','C','D','E','F','G','H','I','J','K','L','M'];
$names = [
'A' => 'sn',
'B' => 'old_sn',
'C' => 'title',
'D' => 'class_id',
'E' => 'cate_id',
'F' => 'nums',
'G' => 'enable',
'H' => 'add_id',
'I' => 'spec',
'J' => 'unit_id',
'K' => 'price',
'L' => 'buy_time',
'M' => 'brand'
];
$oldsn = [];
$data = [];
foreach ($sheet->getRowIterator(2) as $row) {
$tmp = array();
foreach ($row->getCellIterator() as $k=>$cell) {
if(!in_array($k,$keys)){
break;
}
$val = $cell->getFormattedValue();
if($k == 'D'){
if(!empty($classs[$val])){
$tmp[$names[$k]] = $classs[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'E'){
$val = $cell->getFormattedValue();
if(!empty($cates[$val])){
$tmp[$names[$k]] = $cates[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'G'){
$val = $cell->getFormattedValue();
if(!empty($enables[$val])){
$tmp[$names[$k]] = $enables[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'H'){
$val = $cell->getFormattedValue();
if(!empty($adds[$val])){
$tmp[$names[$k]] = $adds[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'J'){
$val = $cell->getFormattedValue();
if(!empty($units[$val])){
$tmp[$names[$k]] = $units[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else{
$tmp[$names[$k]] = $cell->getFormattedValue();
}
}
if(!$tmp['buy_time']){
$tmp['buy_time'] = null;
}
$tmp['buy_time'] = !$tmp['buy_time']?null:date('Y-m-d',strtotime($tmp['buy_time']));
$tmp['company_id'] = $company;
$tmp['org_id'] = $orgId;
$tmp['create_time'] = date('Y-m-d H:i:s');
if(!in_array($tmp['old_sn'],$oldsn)){
$oldsn[] = $tmp['old_sn'];
}
$data[] = $tmp;
}
Db::name('asset_items')->where('old_sn','in',$oldsn)->setField('del',1);
$ret = Db::name('asset_items')->insertAll($data);
dump($ret);
dump($oldsn);
halt($data);
}
public function import1(){
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
// $spreadsheet = $reader->load('./xinhua.xlsx');
$spreadsheet = $reader->load('./zhongxin.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$users = Db::name('user_info')->column('user_id','name');
$adds = Db::name('asset_add')->column('id','title');
$cates = Db::name('asset_cate')->column('id','title');
$units = Db::name('asset_unit')->column('id','title');
$classs = Db::name('asset_class')->column('id','title');
$enables = ['使用' => 2,'在库' => 1];
$company = 1;
$orgId = 4;
$res = array();
$keys = ['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S'];
$names = [
'A' => 'sn',
'B' => 'old_sn',
'C' => 'title',
'D' => 'class_id',
'E' => 'cate_id',
'F' => 'nums',
'H' => 'user_id',
'I' => 'enable',
'J' => 'add_id',
'K' => 'spec',
'L' => 'unit_id',
'M' => 'price',
'N' => 'buy_time',
'O' => 'brand',
'P' => 'remark',
'Q' => 'remark2',
'R' => 'remark3',
'S' => 'remark4'
];
foreach ($sheet->getRowIterator(2) as $row) {
$tmp = array();
foreach ($row->getCellIterator() as $k=>$cell) {
if(!in_array($k,$keys)){
break;
}
if($k != 'G'){
$val = $cell->getFormattedValue();
if($k == 'D'){
if(!empty($classs[$val])){
$tmp[$names[$k]] = $classs[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'E'){
$val = $cell->getFormattedValue();
if(!empty($cates[$val])){
$tmp[$names[$k]] = $cates[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'I'){
$val = $cell->getFormattedValue();
if(!empty($enables[$val])){
$tmp[$names[$k]] = $enables[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'H'){
$val = $cell->getFormattedValue();
if(!empty($users[$val])){
$tmp[$names[$k]] = $users[$val];
$depId = Db::name('user_job')
->alias('uj')
->join('job j','j.id = uj.job_id')
->where('uj.user_id',$users[$val])
->value('j.dep_id');
$tmp['dep_id'] = $depId?$depId:0;
}else{
$tmp[$names[$k]] = 0;
$tmp['dep_id'] = 0;
}
}else if($k == 'J'){
$val = $cell->getFormattedValue();
if(!empty($adds[$val])){
$tmp[$names[$k]] = $adds[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else if($k == 'L'){
$val = $cell->getFormattedValue();
if(!empty($units[$val])){
$tmp[$names[$k]] = $units[$val];
}else{
$tmp[$names[$k]] = 0;
}
}else{
$tmp[$names[$k]] = $cell->getFormattedValue();
}
}
}
if(!$tmp['buy_time']){
$tmp['buy_time'] = null;
}
$tmp['company_id'] = $company;
$tmp['org_id'] = $orgId;
$tmp['create_time'] = date('Y-m-d H:i:s');
if($tmp['user_id'] == 0&&$tmp['enable'] == 2){
// $errors[] = $tmp;
// $errorids[] = $row->getRowIndex();
}else{
if($tmp['sn']){
$ret = Db::name('asset_items')->where('sn',$tmp['sn'])->find();
if(!$ret){
$res[] = $tmp;
}
}
}
}
// halt($res);
dump(count($res));
$ret = Db::name('asset_items')->insertAll($res);
halt($ret);
}
public function programSn(){
exit();
// 获取主合同编号
$programs = Db::name('program')->select();
foreach ($programs as $k=>$v){
$lists = Db::name('contract')
->alias('c')
->join('apply a','a.id = c.apply_id')
->where('c.status',1)
->where('a.del',0)
->where('c.type',0)
->where('c.program_id',$v['id'])
->order('a.finish_time asc')
->field('c.*')
->select();
$i = 1;
foreach ($lists as $kk=>$vv){
$sn = $v['sn'].str_pad($i,4,'0',STR_PAD_LEFT);
Db::name('contract')->where('id',$vv['id'])->update(['program_sn'=>$sn]);
$subs = Db::name('contract')
->alias('c')
->join('apply a','a.id = c.apply_id')
->where('c.status',1)
->where('a.del',0)
->where('c.type',1)
->where('c.parent_apply_id',$vv['id'])
->order('a.finish_time asc')
->field('c.*')
->select();
$j = 1;
foreach ($subs as $kkk => $vvv){
$ssn = $sn.'补'.str_pad($j,2,'0',STR_PAD_LEFT);
Db::name('contract')->where('id',$vvv['id'])->update(['program_sn'=>$ssn]);
$j++;
}
$i++;
}
}
echo '完成';
}
public function budgetDep(){
exit();
$id = 2126;
$info = Db::name('apply')->where('id',$id)->find();
$formJson = $info['form_json'];
$values = [];
$formJson = json_decode($formJson,true);
foreach ($formJson as $k=>$v){
if($v['componentName'] == 'ddbudgetfield'){
foreach ($v['components'] as $key=>$val){
switch ($val['idx']){
case '0':
$values = json_decode($val['values'],true);
break;
}
}
break;
}
}
$items = $values['items'];
$curTime = '2021-01-22 10:41:56';
$orgId = 4;
$apply = Db::name('budget_apply')->where('apply_id',$id)->find();
foreach ($items as $k=>$v){
$sdata = [
'org_id' => $orgId,
'dep_id' => $apply['dep_id'],
'budget_id' => $apply['budget_id'],
'company_id' => $apply['company_id'],
'items_id' => $v['id'],
'money' => floatval($v['money']),
'money2' => !empty($v['money2'])?floatval($v['money2']):0,
'money3' => !empty($v['money3'])?floatval($v['money3']):0,
'intro' => !empty($v['intro'])?$v['intro']:'',
'create_time' => $curTime
];
$res = Db::name('budget_dep')->insert($sdata);
}
halt('成功');
}
public function stamp(){
exit();
$ids = Db::name('contract_stamp_log')->column('contract_id');
trace($ids);
dump($ids);
if($ids){
$ids = array_unique($ids);
$lists = Db::name('contract')->where('id','not in',$ids)->where('type',0)->where('status',1)->select();
}else{
$lists = Db::name('contract')->where('type',0)->where('status',1)->select();
}
foreach ($lists as $k=>$v){
if($v['sdid'] > 0){
$sdinfo = Db::name('stamp_duty')->where('id',$v['sdid'])->find();
$sd_money = round($v['money'] * $sdinfo['bl'] / 1000,1);
if($sd_money < 1 && $sdinfo['type'] == 1){
$sd_money = 1;
}
if($sd_money < 1 && $sdinfo['type'] == 2){
$sd_money = 0;
}
if($sd_money != $v['sd_money']){
trace('修改：'.json_encode($v));
trace('修改为：'.$sd_money);
dump('修改：'.json_encode($v));
dump('修改为：'.$sd_money);
Db::name('contract')->where('id',$v['id'])->update(['sd_money'=>$sd_money]);
}
}
}
halt('完成');
}
public function bksb(){
exit();
$names = ['name','total','sye','yli','gjj'];
$file = './bksb.xlsx';
$data = ExcelUtil::read($file,$names,2);
$salaryRecordId = 493;
$lists = Db::name('salary_record_special')
->alias('srs')
->join('user_info ui','ui.user_id = srs.user_id')
->where('srs.salary_record_id',$salaryRecordId)
->field('srs.*,ui.name')
->select();
$count = 0;
foreach ($lists as $k=>$v){
foreach ($data as $kk=>$vv){
if($v['name'] == $vv['name']){
$nljgjj = round($v['ljgjj'] - round($vv['gjj'],2),2);
$nljsybx = round($v['ljsybx'] - round($vv['sye'],2),2);
$nljylibx = round($v['ljylibx'] - round($vv['yli'],2),2);
$lists[$k]['gjj'] = round($vv['gjj'],2);
$lists[$k]['sye'] = round($vv['sye'],2);
$lists[$k]['yli'] = round($vv['yli'],2);
$lists[$k]['nljgjj'] = $nljgjj;
$lists[$k]['nljsybx'] = $nljsybx;
$lists[$k]['nljylibx'] = $nljylibx;
Db::name('salary_record_special')->where('id',$v['id'])->update([
'ljgjj' => $nljgjj,
'ljsybx' => $nljsybx,
'ljylibx' => $nljylibx
]);
$count++;
break;
}
}
}
dump($count);
halt($lists);
halt($data);
}
public function bksb2(){
exit();
$names = ['name','total','yla','sye','yli','gjj','qynj'];
$file = './bksb2.xlsx';
$data = ExcelUtil::read($file,$names,2);
dump(count($data));
$salaryRecordId = 489;
$lists = Db::name('salary_record_special')
->alias('srs')
->join('user_info ui','ui.user_id = srs.user_id')
->where('srs.salary_record_id',$salaryRecordId)
->field('srs.*,ui.name')
->select();
$count = 0;
foreach ($lists as $k=>$v){
foreach ($data as $kk=>$vv){
if($v['name'] == $vv['name']){
$nljgjj = round($v['ljgjj'] - round($vv['gjj'],2),2);
$nljsybx = round($v['ljsybx'] - round($vv['sye'],2),2);
$nljylibx = round($v['ljylibx'] - round($vv['yli'],2),2);
$nljylobx = round($v['ljylobx'] - round($vv['yla'],2),2);
$nljnj = round($v['ljnj'] - round($vv['qynj'],2),2);
$lists[$k]['gjj'] = round($vv['gjj'],2);
$lists[$k]['sye'] = round($vv['sye'],2);
$lists[$k]['yli'] = round($vv['yli'],2);
$lists[$k]['yla'] = round($vv['yla'],2);
$lists[$k]['qynj'] = round($vv['qynj'],2);
$lists[$k]['nljgjj'] = $nljgjj;
$lists[$k]['nljsybx'] = $nljsybx;
$lists[$k]['nljylibx'] = $nljylibx;
$lists[$k]['nljylobx'] = $nljylobx;
$lists[$k]['nljnj'] = $nljnj;
Db::name('salary_record_special')->where('id',$v['id'])->update([
'ljgjj' => $nljgjj,
'ljsybx' => $nljsybx,
'ljylibx' => $nljylibx,
'ljylobx' => $nljylobx,
'ljnj' => $nljnj
]);
$count++;
break;
}
}
}
dump($count);
halt($lists);
halt($data);
}
}