save($data);
$process['item_id'] = $data['id'];
$process['mid'] = 2;
$process['process'] = '反馈'.($data['status']==4?'及提报':'');
$process['time'] = time();
Db::name('common_process_list')->insert($process);
exit(json_encode(array('code'=>0,'msg'=>'反馈完成！','id'=>$data['id'])));
}
//分层审核确认
public function layerFeedbackConfirm(){
$process['item_id'] = input('post.id');
$process['mid'] = 2;
$process['time'] = time();
if(input('?post.rej')){
Db::name('quality_layer_issue')->where('id',input('post.id'))->update(['status'=>3,'mark'=>input('post.rej')]);
$process['process'] = '驳回';
$process['status'] = 2;
$process['mark'] = input('post.rej');
}else{
Db::name('quality_layer_issue')->where('id',input('post.id'))->update(['status'=>5]);
$process['process'] = '确认';
}
Db::name('common_process_list')->insert($process);
exit(json_encode(array('code'=>0,'msg'=>input('?post.rej')?'驳回完成！':'确认完成！')));
}
//分层审核重点跟踪设置
public function layerGreatSet(){
Db::name('quality_layer_issue')->where('id',input('post.id'))->update(['great'=>input('post.great')]);
exit(json_encode(array('code'=>0,'msg'=>'设置成功！')));
}
//现场问题新增及更新
public function onsiteIssueUpdate(){
$data = input('post.');
if($data['id']>0){
$data = array_intersect_key($data,['id'=>0,'type'=>0,'owner'=>0,'issue_desc'=>0]);
Db::name('onsite_issue_list')->save($data);
$process['item_id'] = $data['id'];
$process['mid'] = 3;
$process['process'] = '更新';
$process['time'] = time();
Db::name('common_process_list')->insert($process);
$msg = '修改成功！';
}else{
unset($data['id']);
$data['aid'] = session('admin')['id'];
$data['issue_date'] = time();
$today_num = Db::name('onsite_issue_list')->where('issue_date','>=',strtotime('today'))->count();
$data['s_num'] = date('y-m-d',strtotime('today')).'-'.($today_num + 1);
$process['item_id'] = $id = Db::name('onsite_issue_list')->insertGetId($data);
$process['mid'] = 3;
$process['process'] = '创建';
$process['time'] = time();
Db::name('common_process_list')->insert($process);
$msg = '新增成功！';
}
//邮件
$owner_info = Db::name('admin_user')->find($data['owner']);
if(isset($data['id'])==false&&(strlen($owner_info['e_mail'])>5||$data['freq']>1)){
$team_info = $data['tid']>0?Db::name('team_list')->where('id',$data['tid'])->find():'';
$team = $data['tid']>0?$team_info['team']:'';
$team_leader = $data['tid']>0?Db::name('admin_user')->where('id',$team_info['aid'])->value('truename'):'';
$issue_type = $data['issue_type']>0?Db::name('onsite_base')->where('id',$data['issue_type'])->value('content'):'';
$poid = $data['poid']>0?Db::name('team_plan_position')->where('id',$data['poid'])->value('position'):'';
$family = $data['family']>0?Db::name('team_base')->where('id',$data['family'])->value('title'):'';
$dpt = $data['dpt']>0?Db::name('admin_org')->where('id',$data['dpt'])->value('title'):'';
$owner = $data['owner']>0?Db::name('admin_user')->where('id',$data['owner'])->value('truename'):'';
$html1 = '：
以下是新反馈的现场问题,请及时回复!';
$html2 = '
| 流水号 |
班组 |
班长 |
family |
涉及工位 |
问题类型 |
问题描述 |
责任部门 |
责任人 |
计划完成日期 |
发生频次 |
';
$html3 = '
| '.$data['s_num'].' |
'.$team.' |
'.$team_leader.' |
'.$family.' |
'.$poid.' |
'.$issue_type.' |
'.$data['issue_desc'].' |
'.$dpt.' |
'.$owner.' |
'.date('Y-m-d',$data['issue_date']).' |
'.($data['freq']==1?"首次":($data['freq']==2?"二次发生":"三次及以上")).' |
';
$html4 = '
';
$html5 = 'OMS运营管理系统后台请 点击进入 ！
tips: 请使用谷歌浏览器或其他高级浏览器，如未安装，请自行下载安装，也可点击下载安装谷歌浏览器
';
$mail['content'] = 'Dear '.$html1.$html2.$html3.$html4.$html5;
$mail['title'] = '新增现场问题';
$mail['to'] = [$data['owner']];
if($data['freq']>1){
$mail['title'] = '新增现场问题 —— 重复问题';
$opmId = Db::name('admin_user')->where(array('job'=>50,'status'=>1))->value('id');
if($opmId){
array_push($mail['to'],$opmId);
}
$job = Db::name('admin_org')->where(array('mid'=>$owner_info['dpt'],'title'=>'经理'))->value('id');
$manager = Db::name('admin_user')->where(array('job'=>$job,'status'=>1))->value('id');
array_push($mail['to'],$manager);
}
$mail_model = new send();
$res = $mail_model->sendMail($mail);
}
exit(json_encode(array('code'=>0,'msg'=>$msg,'id'=>$process['item_id'])));
}
//现场问题反馈
public function onsiteIssueFeedback(){
$data = input('post.');
$info = Db::name('onsite_issue_list')->find($data['id']);
$data['due_date'] = strtotime($data['due_date']);
$data['feedback_time'] = strtotime('today');
if($info['due_date']<$data['due_date']){
$data['mark'] = $info['due_date']>0?($data['mark']==null?$info['due_date']:($data['mark'].','.$info['due_date'])):null;
}
Db::name('onsite_issue_list')->save($data);
$process['item_id'] = $data['id'];
$process['mid'] = 3;
$process['process'] = '反馈';
$process['time'] = time();
Db::name('common_process_list')->insert($process);
exit(json_encode(array('code'=>0,'msg'=>'反馈完成！')));
}
//现场问题转责任人
public function onsiteIssueOwnerChange(){
$data = input('post.');
$info = Db::name('onsite_issue_list')->find($data['id']);
Db::name('onsite_issue_list')->save($data);
$owner_info = Db::name('admin_user')->find($data['owner']);
if(strlen($owner_info['e_mail'])>5){
$old_owner = Db::name('admin_user')->find($info['owner']);
$team_info = $info['tid']>0?Db::name('team_list')->where('id',$info['tid'])->find():'';
$team = $info['tid']>0?$team_info['team']:'';
$team_leader = $info['tid']>0?Db::name('admin_user')->where('id',$team_info['aid'])->value('truename'):'';
$issue_type = $info['issue_type']>0?Db::name('onsite_base')->where('id',$info['issue_type'])->value('content'):'';
$poid = $info['poid']>0?Db::name('team_plan_position')->where('id',$info['poid'])->value('position'):'';
$family = $info['family']>0?Db::name('team_base')->where('id',$info['family'])->value('title'):'';
$dpt = $info['dpt']>0?Db::name('admin_org')->where('id',$info['dpt'])->value('title'):'';
$owner = $data['owner']>0?Db::name('admin_user')->where('id',$info['owner'])->value('truename'):'';
$html1 = '：
以下是 '.$old_owner['truename'].' 转发给您的现场问题,请及时回复!';
$html2 = '
| 流水号 |
班组 |
班长 |
family |
涉及工位 |
问题类型 |
问题描述 |
责任部门 |
责任人 |
计划完成日期 |
发生频次 |
';
$html3 = '
| '.$info['s_num'].' |
'.$team.' |
'.$team_leader.' |
'.$family.' |
'.$poid.' |
'.$issue_type.' |
'.$info['issue_desc'].' |
'.$dpt.' |
'.$owner.' |
'.date('Y-m-d',$info['issue_date']).' |
'.($info['freq']==1?"首次":($info['freq']==2?"二次发生":"三次及以上")).' |
';
$html4 = '
';
$html5 = 'OMS运营管理系统后台请 点击进入 ！
tips: 请使用谷歌浏览器或其他高级浏览器，如未安装，请自行下载安装，也可点击下载安装谷歌浏览器
';
$mail['content'] = 'Dear '.$html1.$html2.$html3.$html4.$html5;
$mail['title'] = '现场问题反馈转发';
$mail['to'] = [$data['owner']];
$mail_model = new send();
$res = $mail_model->sendMail($mail);
}
exit(json_encode(array('code'=>0,'msg'=>'责任人已变更！')));
}
//现场问题确认
public function onsiteIssueFeedbackConfirm(){
$process['item_id'] = input('post.id');
$process['mid'] = 3;
$process['time'] = time();
if(input('?post.rej')){
Db::name('onsite_issue_list')->where('id',input('post.id'))->update(['status'=>2,'mark'=>input('post.rej')]);
$process['process'] = '驳回';
$process['status'] = 2;
$process['mark'] = input('post.rej');
}else{
Db::name('onsite_issue_list')->where('id',input('post.id'))->update(['status'=>5]);
$process['process'] = '确认';
}
Db::name('common_process_list')->insert($process);
exit(json_encode(array('code'=>0,'msg'=>input('?post.rej')?'驳回完成！':'确认完成！')));
}
//现场问题确认
public function onsiteIssueDelete(){
Db::name('onsite_issue_list')->where('id',input('post.id'))->update(['status'=>0]);
exit(json_encode(array('code'=>0,'msg'=>'删除完成！')));
}
//分层审核结果保存
public function layerResultUpdate(){
$data = input('post.');
$record = Db::name('quality_layer_record')->where(array('plan_id'=>$data['plan_id'],'check_id'=>$data['check_id'],'status'=>1))->find();
if($data['record_id']==0){
if($record&&$record['check_id']>0){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'该条款已经审核过，请确认！')));
}
}else{
if($record['record']!==$data['result']){
Db::name('quality_layer_record')->where('id',$record['id'])->update(['status'=>0]);
if($record['record']==2){
Db::name('quality_layer_issue')->where('record_id',$data['record_id'])->update(['status'=>0]);
}
}else{
exit(json_encode(array('code'=>0,'id'=>$record['id'])));
}
}
$record = new QualityLayerRecord;
$record->plan_id = $data['plan_id'];
$record->check_id = $data['check_id'];
$record->record = $data['result'];
$record->audit_time = time();
$record->desc = isset($data['desc'])?htmlspecialchars($data['desc']):null;
$record->save();
if((int)$data['result']==2){
exit(json_encode(array('code'=>0,'id'=>$record->id)));
}else{
exit(json_encode(array('code'=>0,'msg'=>'该条款审核结果已保存！')));
}
}
//分层审核问题保存
public function layerIssueUpdate(){
$data = input('post.');
$data['auditor'] = session('admin')['id'];
$data['auditDpt'] = session('admin')['dpt'];
$data['audit_date'] = time();
$data['update'] = time();
$data['status'] = 1;
$data['issue'] = htmlspecialchars($data['issue']);
if($data['id']==''){
unset($data['id']);
$id = Db::name('quality_layer_issue')->insertGetId($data);
}else{
Db::name('quality_layer_issue')->save($data);
$id = $data['id'];
}
exit(json_encode(array('code'=>0,'msg'=>'审核问题已保存！','id'=>$id)));
}
//分层审核计划上传
public function layerPlanUpload(){
$data = input('post.');
$area_info = Db::name('quality_layer_check_list')->where(array('mid'=>1,'status'=>1))->whereIn('content',array_column($data,'area'))->column('id','content');
$diff = array_diff(array_column($data,'area'),array_keys($area_info));
if($diff){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'以下区域不存在，请确认！
'.join(",
",$diff))));
}
$aid_info = Db::name('admin_user')->where('status',1)->column('id','truename');
$diff = array_diff(array_column($data,'auditor'),array_keys($aid_info));
if($diff){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'以下审核人员不存在，请确认！
'.join(",
",$diff))));
}
$check_list = Db::name('quality_layer_check_list')->where('status',2)->whereIn('area',$area_info)->field('id,area,title')->lists();
foreach ($check_list as $k => $v) {
$check_info[$v['area']][$v['title']] = $v['id'];
}
foreach ($data as $k => $v) {
$date = explode('~',$v['date']);
if(isset($date[1])==false||strtotime($date[0])==0||strtotime($date[1])==0){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'第'.($k+1).'行审核日期（'.$v['date'].'）有误，请确认！')));
}
if(trim($v['check_list'])==''){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'第'.($k+1).'行区域无任何审核条款，请确认！')));
}
$upload_check_list = explode('-',$v['check_list']);
$diff = array_diff($upload_check_list,array_keys($check_info[$area_info[$v['area']]]));
if($diff){
http_response_code(440);
exit(json_encode(array('code'=>1,'msg'=>'第'.($k+1).'行区域'.$v['area'].'的下列审核条款不存在，请确认！
'.join(",
",$diff))));
}
}
foreach ($data as $k => $v) {
$date = explode('~',$v['date']);
$res['start'] = strtotime($date[0]);
$res['end'] = strtotime($date[1]);
$res['auditor'] = $aid_info[$v['auditor']];
$res['area'] = $area_info[$v['area']];
$res['level'] = $v['level'];
$res['location'] = $v['location'];
$res['content'] = $v['content'];
$res['planner'] = session('admin')['id'];
$res['update'] = time();
$upload_check_list = explode('-',$v['check_list']);
foreach ($upload_check_list as $ke => $val) {
$upload_check_list[$ke] = $check_info[$area_info[$v['area']]][$val];
}
$res['check_list'] = json_encode($upload_check_list);
Db::name('quality_layer_planning')->insert($res);
}
exit(json_encode(array('code'=>0,'msg'=>'审核计划上传成功！')));
}
//值班问题保存
public function dutyIssueUpdate(){
$data = input('post.');
if(isset($data['action'])){
$data['due_date'] = strtotime($data['due_date']);
Db::name('common_manager_duty_list')->save($data);
$id = $data['id'];
$process['process'] = $data['status']==3?'回复':'提报确认';
$msg = '问题回复完成!';
}else{
if(isset($data['type'])){
if($data['type']==1){
if(isset($data['line'][1])){
$data['project'] = $data['line'][0];
$data['line'] = $data['line'][1];
}
$data['area'] = null;
}else{
$data['line'] = null;
}
if(isset($data['owner'][2])){
$data['dpt'] = $data['owner'][0];
$data['owner'] = $data['owner'][2];
}
$data['duty_date'] = strtotime('today');
$data['create_time'] = time();
$data['status'] = 2;
$data['auditor'] = session('admin')['id'];
if($data['id']>0){
$id = $data['id'];
Db::name('common_manager_duty_list')->save($data);
$process['process'] = '修改';
$msg = '问题修改成功!';
}else{
unset($data['id']);
$id = Db::name('common_manager_duty_list')->insertGetId($data);
$process['process'] = '新增';
$msg = '新增问题成功！';
}
}else{
$id = $data['id'];
Db::name('common_manager_duty_list')->save($data);
$process['process'] = '确认';
$msg = '关闭成功!';
}
}
$process['item_id'] = $id;
$process['mid'] = 4;
$process['time'] = time();
Db::name('common_process_list')->insert($process);
exit(json_encode(array('code'=>0,'msg'=>$msg,'id'=>$id)));
}
//值班问题删除
public function dutyIssueDelete(){
Db::name('common_manager_duty_list')->where('id',input('post.id'))->update(['status'=>0]);
exit(json_encode(array('code'=>0,'msg'=>'问题删除成功！')));
}
//值班问题责任人变更
public function dutyIssueChangeOwner(){
Db::name('common_manager_duty_list')->save(input('post.'));
exit(json_encode(array('code'=>0,'msg'=>'责任人变更成功！')));
}
//美国件状态更新
public function cooSampleTypeUpdate(){
Db::name('common_usa_coo')->where('id',input('post.id'))->update(['sample_type'=>input('post.sample_type')]);
exit(json_encode(array('code'=>0)));
}
//美国件基本信息更新
public function cooInfoDetailUpdate(){
$data = input('post.');
if($data['status']==1){
$data['status'] = 2;
$data['replace'] = 2;
$data = array_diff_key($data,['sample_type'=>0,'vali_num'=>0]);
Db::name('common_usa_coo')->save($data);
}else{
Db::name('common_usa_coo')->where('id',$data['id'])->update(['vali_num'=>$data['vali_num'],'status'=>3]);
}
exit(json_encode(array('code'=>0,'msg'=>'保存成功！')));
}
//美国件步骤详情更新
public function cooStepDetailUpdate(){
$data = input('post.');
if($data['status']!==$data['step']){
Db::name('common_usa_coo')->where('id',$data['c_id'])->update(['status'=>$data['status']]);
}
unset($data['status']);
$data['owner'] = session('admin')['id'];
$data['update'] = time();
Db::name('common_usa_coo_step')->insert($data);
exit(json_encode(array('code'=>0,'msg'=>'保存成功！')));
}
//无纸化审批申请
public function eSignUpdate(){
$data = input('post.form');
$list['owner'] = session('admin')['id'];
$list['create_time'] = time();
$list['title'] = $data['title'];
$list['content'] = htmlspecialchars($data['content']);
$sign = input('post.sign');
foreach ($sign as $k => $v) {
if($v['type']==1){
$list['step'] = $v['aid'];
$first_aid = $v['aid'];
break;
}
}
$id = Db::name('onsite_paperless_list')->insertGetId($list);
foreach ($sign as $k => $v) {
$v['p_id'] = $id;
unset($v['name']);
Db::name('onsite_paperless_step')->save($v);
}
$apv_name = Db::name('admin_user')->where('id',$first_aid)->value('truename');
//发送邮件消息
$html1 = $apv_name.'：
以下无纸化审核单需要您的审批,请及时处理！
申请人：'.session('admin')['truename'].'
申请内容：'.$list['title'].'
';
$mail['title'] = '无纸化系统审核通知';
$mail['to'] = [$first_aid];
$html2 = 'OMS运营管理系统后台请 点击进入 ！
tips: 请使用谷歌浏览器或其他高级浏览器，如未安装，请自行下载安装，也可点击下载安装谷歌浏览器
';
$mail['content'] = 'Dear '.$html1.$html2;
// print_r($mail);die;
$mail_model = new send();
// $res = $mail_model->sendMail($mail);
exit(json_encode(array('code'=>0,'msg'=>'新增审核申请成功！','id'=>$id)));
}
//无纸化签核审批
public function eSignConfirm(){
$data = input('post.');
$data['update'] = time();
if($data['sign']==1){
$info = Db::name('onsite_paperless_list')->find($data['p_id']);
$steps = Db::name('onsite_paperless_step')->where(array('p_id'=>$data['p_id'],'type'=>1))->order('order')->cates('order');
$aid_info = Db::name('admin_user')->cache('adminName',600)->column('truename','id');
$order_start = 0;
foreach ($steps as $k => $v) {
if($order_start > 0){
$order_next = (int)$v['order'];
break;
}
if($v['aid']==session('admin')['id']){
$order_start = (int)$v['order'];
}
}
$mail['to'] = [];
if(isset($order_next)){
//发送邮件消息
Db::name('onsite_paperless_list')->where('id',$data['p_id'])->update(['step'=>$steps[$order_next]['aid'],'status'=>2]);
array_push($mail['to'],$steps[$order_next]['aid']);
$html1 = $aid_info[$steps[$order_next]['aid']].'：
以下无纸化审核单需要您的审批,请及时处理！
申请人：'.$aid_info[$info['owner']].'
申请内容：'.$info['title'].'
';
$mail['title'] = '无纸化系统审核通知';
$msg = '审批已通过！';
}else{
//已审核结束
//发送邮件消息
Db::name('onsite_paperless_list')->where('id',$data['p_id'])->update(['step'=>0,'status'=>3]);
array_push($mail['to'],$info['owner']);
$html1 = 'All：
以下无纸化审核单已审批结束！
申请人：'.$aid_info[$info['owner']].'
申请内容：'.$info['title'].'
';
$mail['title'] = '无纸化系统审核完成通知';
$msg = '审批已通过,本审核单已签核完毕！';
$order_next = 999;
}
Db::name('onsite_paperless_sign')->insert($data);
$announce = Db::name('onsite_paperless_step')->where(array('p_id'=>$data['p_id'],'type'=>2))->lists();
foreach ($announce as $k => $v) {
if($v['order'] > $order_start && $v['order'] < $order_next){
array_push($mail['to'],$v['aid']);
}
}
if(count($mail['to'])==1&&$mail['to'][0]==$info['owner']){
$owner_email = Db::name('admin_user')->where('id',$info['owner'])->value('e_mail');
if($owner_email==0||$owner_email==''||$owner_email==null){
exit(json_encode(array('code'=>0,'msg'=>'审批已通过,本审核单已签核完毕！')));
}
}
$html2 = 'OMS运营管理系统后台请 点击进入 ！
tips: 请使用谷歌浏览器或其他高级浏览器，如未安装，请自行下载安装，也可点击下载安装谷歌浏览器
';
$mail['content'] = 'Dear '.$html1.$html2;
print_r($mail);die;
$mail_model = new send();
$res = $mail_model->sendMail($mail);
exit(json_encode(array('code'=>0,'msg'=>$msg)));
}else{
$info = Db::name('onsite_paperless_list')->find($data['p_id']);
$aid_info = Db::name('admin_user')->cache('adminName',600)->column('truename','id');
$step_info = Db::name('onsite_paperless_step')->where(array('p_id'=>$data['p_id'],'type'=>1))->column('order','aid');
//发送邮件消息
Db::name('onsite_paperless_list')->where('id',$data['p_id'])->update(['step'=>null,'status'=>0]);
Db::name('onsite_paperless_sign')->insert($data);
$html1 = 'All：
以下无纸化审核单已被'.session('admin')['truename'].'驳回,请处理！
申请人：'.$aid_info[$info['owner']].'
申请内容：'.$info['title'].'
驳回原因：'.$data['mark'].'
';
$mail['title'] = '无纸化系统审核驳回通知';
$steps = Db::name('onsite_paperless_step')->where('p_id',input('post.confirm'))->order('order')->lists();
$mail['to'] = [$info['owner']];
foreach ($steps as $k => $v) {
if(session('admin')['id'] !== $v['aid']){
array_push($mail['to'],$v['aid']);
}else{
break;
}
}
$html2 = 'OMS运营管理系统后台请 点击进入 ！
tips: 请使用谷歌浏览器或其他高级浏览器，如未安装，请自行下载安装，也可点击下载安装谷歌浏览器
';
$mail['content'] = 'Dear '.$html1.$html2;
print_r($mail);die;
$mail_model = new send();
$res = $mail_model->sendMail($mail);
exit(json_encode(array('code'=>0,'msg'=>'审批单已驳回！')));
}
}
//外网合理化建议同步上传
public function suggestionUpload(){
$data = input('post.');
print_r($data);
exit(json_encode(array('code'=>0,'msg'=>'保存成功！')));
}
}