public function getRelatedUsers($numberArr) { $userInfo = array(); $review = new Dcc_Model_Review(); $userIdsAdded = array(); foreach ($numberArr as $number) { // 获取申请人 $sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name), array('id', 'create_user', 'apply_user'))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t1.create_user = t2.id", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t2.employee_id = t3.id", array('creater_email' => 'email'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t1.apply_user = t4.id", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t4.employee_id = t5.id", array('applier_email' => 'email'))->where("t1.number = '" . $number . "'"); //echo $sql.'<br><br>'; $data = $this->fetchRow($sql)->toArray(); array_push($userInfo, array('user_id' => $data['create_user'], 'email' => $data['creater_email'])); array_push($userIdsAdded, $data['create_user']); if ($data['apply_user'] && !in_array($data['apply_user'], $userIdsAdded)) { array_push($userInfo, array('user_id' => $data['apply_user'], 'email' => $data['applier_email'])); } // 获取审核人 $reviewerInfo = $review->getReviewUserInfo('purchse_req_add', $data['id']); foreach ($reviewerInfo as $info) { if (!in_array($info['user_id'], $userIdsAdded)) { array_push($userInfo, $info); } } } return $userInfo; }
public function getReqRelatedUsers($numberArr) { $userInfo = array(); $userIdsAdded = array(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); $i = 0; foreach ($numberArr as $order) { $i++; $sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name), array())->joinLeft(array('t2' => $this->_dbprefix . "erp_pur_order_items"), "t1.order_item_id = t2.id", array())->joinLeft(array('t3' => $this->_dbprefix . "erp_pur_order"), "t1.order_number = t3.number", array('order_create_user' => 'create_user'))->joinLeft(array('t4' => $this->_dbprefix . "erp_pur_req"), "t2.req_number = t4.number", array('id', 'create_user', 'apply_user'))->joinLeft(array('t5' => $this->_dbprefix . 'user'), "t4.create_user = t5.id", array())->joinLeft(array('t6' => $this->_dbprefix . 'employee'), "t5.employee_id = t6.id", array('creater_email' => 'email'))->joinLeft(array('t7' => $this->_dbprefix . 'user'), "t4.apply_user = t7.id", array())->joinLeft(array('t8' => $this->_dbprefix . 'employee'), "t7.employee_id = t8.id", array('applier_email' => 'email'))->joinLeft(array('t9' => $this->_dbprefix . 'user'), "t3.create_user = t9.id", array())->joinLeft(array('t10' => $this->_dbprefix . 'employee'), "t9.employee_id = t10.id", array('order_creater_email' => 'email'))->where("t1.order_number = '" . $order . "'"); $data = $this->fetchRow($sql)->toArray(); array_push($userInfo, array('user_id' => $data['order_create_user'], 'email' => $data['order_creater_email'])); array_push($userIdsAdded, $data['order_create_user']); if ($data['applier_email'] != '' && $data['apply_user'] && !in_array($data['apply_user'], $userIdsAdded)) { array_push($userInfo, array('user_id' => $data['apply_user'], 'email' => $data['applier_email'])); } // 添加采购申请人:直接主管 if ($data['create_user'] != '') { array_push($userInfo, array('user_id' => $data['create_user'], 'email' => $data['creater_email'])); array_push($userIdsAdded, $data['create_user']); $managerInfo = $employee->getManagerByUserId($data['create_user']); if (isset($managerInfo['email']) && $managerInfo['email'] != '' && !in_array($managerInfo['user_id'], $userIdsAdded)) { array_push($userInfo, array('user_id' => $managerInfo['user_id'], 'email' => $managerInfo['email'])); } // 添加采购申请人:部门主管 $deptManagerInfo = $employee->getDeptManagerByUserId($data['create_user']); if (isset($deptManagerInfo['email']) && $deptManagerInfo['email'] != '' && !in_array($deptManagerInfo['user_id'], $userIdsAdded)) { array_push($userInfo, array('user_id' => $deptManagerInfo['user_id'], 'email' => $deptManagerInfo['email'])); } } // 获取审核人 if ($data['id'] != '') { $reviewerInfo = $review->getReviewUserInfo('purchse_req_add', $data['id']); foreach ($reviewerInfo as $info) { if (!in_array($info['user_id'], $userIdsAdded)) { array_push($userInfo, $info); } } } } $data = array(); $ids = array(); foreach ($userInfo as $user) { if (!in_array($user['user_id'], $ids)) { array_push($data, $user); array_push($ids, $user['user_id']); } } return $data; }
public function getlistAction() { $review = new Dcc_Model_Review(); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; // 清理无效数据 $where1 = " type='files' and file_id in (select id from oa_doc_files where state = 'Return' or state = 'Delete')"; $review->delete($where1); $where2 = " type='materiel' and file_id in (select id from oa_product_materiel where state = 'Return' or state = 'Delete')"; $review->delete($where2); $where3 = " type='bom' and file_id in (select id from oa_product_bom_new where state = 'Return' or state = 'Delete')"; $review->delete($where3); $where4 = " type='devbom' and file_id in (select id from oa_product_bom_upd where state = 'Return' or state = 'Delete')"; $review->delete($where4); $where5 = " type='ecobom' and file_id in (select id from oa_product_bom_upd where state = 'Return' or state = 'Delete')"; $review->delete($where5); $where6 = " type='materiel_desc' and file_id in (select id from oa_product_materiel_desc where state = 'Return' or state = 'Delete')"; $review->delete($where6); $data = $review->getBacklogList($user); $updcount = 0; for ($i = 0; $i < count($data); $i++) { if ($data[$i]['type'] == 'devbom') { $updcount += $data[$i]['count']; } else { if ($data[$i]['type'] == 'ecobom') { $updcount += $data[$i]['count']; } else { if ($data[$i]['type'] == 'updbom') { $updcount += $data[$i]['count']; } } } } $result = array(); for ($i = 0; $i < count($data); $i++) { if ($data[$i]['type'] != 'devbom' && $data[$i]['type'] != 'ecobom' && $data[$i]['type'] != 'updbom') { $result[] = $data[$i]; } } if ($updcount > 0) { $result[] = array("count" => $updcount, "type" => "updbom"); } echo Zend_Json::encode($result); exit; }
public function reviewAction() { // 返回值数组 $result = array('success' => true, 'info' => '审核成功'); $request = $this->getRequest()->getParams(); /* echo '<pre>'; print_r($request); exit; */ $review_id = isset($request['review_id']) ? $request['review_id'] : null; $review_operate = isset($request['review_operate']) ? $request['review_operate'] : null; $review_current_step = isset($request['review_current_step']) ? $request['review_current_step'] : null; // 当前阶段(review表ID) $review_last_step = isset($request['review_last_step']) ? $request['review_last_step'] : null; // 是否当前阶段为最后一阶段 $review_to_finish = isset($request['review_to_finish']) ? $request['review_to_finish'] : null; // 是否批准后当前阶段结束 $review_next_step = isset($request['review_next_step']) ? $request['review_next_step'] : null; // 下一阶段(review表ID) $review_remark = isset($request['review_remark']) ? $request['review_remark'] : null; if ($review_id && $review_operate) { $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; // 评审意见 $review_info = '意见: ' . $review_remark; $invoice = new Erp_Model_Purchse_Invoice(); $invoiceItems = new Erp_Model_Purchse_Invoiceitems(); $user = new Application_Model_User(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); $invoiceData = $invoice->getData(null, $review_id); // 更新审核状态及审核意见 if ($review_operate == 'no') { // 更新采购申请状态 $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']'; $data = array('state' => 1, 'review_info' => $invoiceData['review_info'] . '<br>' . $review_info); // 更新订单状态 $invoice->update($data, "id = " . $review_id); // 删除当前申请的审核配置 $review->delete("type = 'purchse_invoice_add' and file_id = " . $review_id); // 发送邮件通知申请人 $reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>'; $mail = new Application_Model_Log_Mail(); $applyEmployeeData = $user->fetchRow("id = " . $invoiceData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); $to = $applyEmployee['email']; // 获取币种信息 $currency = new Erp_Model_Setting_Currency(); $currencyInfo = $currency->getInfoByCode($invoiceData['currency']); $total = $invoiceData['total']; if ($invoiceData['currency'] != 'CNY') { $total = $invoiceData['forein_total']; } $mailContent = '<div>采购发票审核:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>发票号:</b>' . $invoiceData['number'] . '</p> <p><b>申请人:</b>' . $invoiceData['creater'] . '</p> <p><b>金额:</b><a style="color: #467500;font-weight: bold;">' . $currencyInfo['symbol'] . $total . '</a></p> <p><b>备注:</b>' . $invoiceData['remark'] . '</p> <p><b>申请时间:</b>' . $invoiceData['create_time'] . '</p> <p><b>更新时间:</b>' . $invoiceData['update_time'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $invoiceData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '采购发票-审核', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $invoiceData['create_user'], 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $help = new Application_Model_Helpers(); $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']'; $invoiceUpdateData = array('review_info' => $invoiceData['review_info'] . '<br>' . $review_info); $reviewData = $review->fetchRow("id = " . $review_current_step)->toArray(); $actual_user = $reviewData['actual_user'] == '' ? $user_session->user_info['employee_id'] : $reviewData['actual_user'] . ',' . $user_session->user_info['employee_id']; $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); // 当前审核阶段为最后一阶段 if ($review_last_step == 1) { // 当前阶段已完结 if ($review_to_finish == 1) { $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); $reviewResult = '<font style="color: #006400"><b>发布</b></font>'; // 发布 // 更新申请状态 $invoiceUpdateData['state'] = 2; $invoiceUpdateData['release_time'] = $now; // 更新审核记录表 $review->update($data, "id = " . $review_current_step); $mail = new Application_Model_Log_Mail(); $applyEmployeeData = $user->fetchRow("id = " . $invoiceData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); $to = $applyEmployee['email']; // 获取币种信息 $currency = new Erp_Model_Setting_Currency(); $currencyInfo = $currency->getInfoByCode($invoiceData['currency']); $total = $invoiceData['total']; if ($invoiceData['currency'] != 'CNY') { $total = $invoiceData['forein_total']; } $mailContent = '<div>采购发票审核批准,请登录系统查看:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>发票号:</b>' . $invoiceData['number'] . '</p> <p><b>申请人:</b>' . $invoiceData['creater'] . '</p> <p><b>金额:</b><a style="color: #467500;font-weight: bold;">' . $currencyInfo['symbol'] . $total . '</a></p> <p><b>备注:</b>' . $invoiceData['remark'] . '</p> <p><b>申请时间:</b>' . $invoiceData['create_time'] . '</p> <p><b>更新时间:</b>' . $invoiceData['update_time'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $invoiceUpdateData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '采购发票-发布', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $invoiceData['create_user'], 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $data = array('actual_user' => $actual_user); $review->update($data, "id = " . $review_current_step); } } else { // 当前阶段已完结 if ($review_to_finish == 1) { $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); $reviewResult = '<font style="color: #006400"><b>批准</b></font>'; // 进入下一阶段 // 更新审核记录表 $review->update($data, "id = " . $review_current_step); // 邮件通知下一阶段审核人 if ($review->fetchAll("id = " . $review_next_step)->count() > 0) { $reviewNextStepData = $review->fetchRow("id = " . $review_next_step)->toArray(); $mailTo = explode(',', $reviewNextStepData['plan_user']); if ($mailTo) { // 获取币种信息 $currency = new Erp_Model_Setting_Currency(); $currencyInfo = $currency->getInfoByCode($invoiceData['currency']); $total = $invoiceData['total']; if ($invoiceData['currency'] != 'CNY') { $total = $invoiceData['forein_total']; } $mailContent = '<div>新建采购发票,请登录系统查看:</div> <div> <p><b>订单号:</b>' . $invoiceData['number'] . '</p> <p><b>申请人:</b>' . $invoiceData['creater'] . '</p> <p><b>金额:</b><a style="color: #467500;font-weight: bold;">' . $currencyInfo['symbol'] . $total . '</a></p> <p><b>备注:</b>' . $invoiceData['remark'] . '</p> <p><b>申请时间:</b>' . $invoiceData['create_time'] . '</p> <p><b>更新时间:</b>' . $invoiceData['update_time'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $invoiceUpdateData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '采购发票-新建', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now); $resultMail = $help->sendMailToStep($mailTo, $mailData); if (!$resultMail['success']) { $result = $resultMail; } } } } else { $data = array('actual_user' => $actual_user); $review->update($data, "id = " . $review_current_step); } } // 更新申请状态 $invoice->update($invoiceUpdateData, "id = " . $review_id); } } echo Zend_Json::encode($result); exit; }
public function getReviewState($type, $file_id) { $reviewState = array('info' => null, 'reviewer' => array(), 'reviewer_finished' => array(), 'step_chk' => array('current_step' => 0, 'last_step' => 0, 'to_finish' => 1, 'next_step' => 0)); $review = new Dcc_Model_Review(); // 获取审核情况 $reviewRes = $review->fetchAll("type = '" . $type . "' and file_id = " . $file_id, array('id')); if ($reviewRes->count() > 0) { $reviewData = $reviewRes->toArray(); // 检查当前阶段是否为审核最后阶段 if (count($reviewData) == 1 || $reviewData[count($reviewData) - 1]['finish_flg'] == 0 && count($reviewData) > 1 && $reviewData[count($reviewData) - 2]['finish_flg'] == 1) { // 最后一阶段未审核,倒数第二阶段已审核 $reviewState['step_chk']['last_step'] = 1; } // 审核状态信息 $reviewStateArr = array(); // 当前阶段信息 $currentStepMethod = 1; $currentStepEmployee = array(); $currentStepEmployeeFinished = ""; $i = 0; foreach ($reviewData as $r) { $reviewType = $r['method'] == 1 ? '任意' : '全部'; $actual_user = explode(',', $r['actual_user']); $reviewEmployeeArr = array('id' => explode(',', $r['plan_user']), 'name' => $this->getEmployeeNameByIdArr(explode(',', $r['plan_user']))); if ($r['method'] == 2) { for ($j = 0; $j < count($reviewEmployeeArr['id']); $j++) { if (in_array($reviewEmployeeArr['id'][$j], $actual_user)) { $reviewEmployeeArr['name'][$j] .= ': 已审核'; } } } $reviewEmployee = implode(', ', $reviewEmployeeArr['name']) . '(' . $reviewType . ')'; $stepStr = '<a title="' . $reviewEmployee . '">' . $r['step_name'] . '</a>'; if ($r['finish_flg'] == 0) { if ($reviewState['step_chk']['current_step'] > 0) { array_push($reviewStateArr, $stepStr); } else { array_push($reviewStateArr, '<b>' . $stepStr . '</b>'); $currentStepEmployee = $reviewState['reviewer'] = $reviewEmployeeArr['id']; $reviewState['step_chk']['current_step'] = $r['id']; if (isset($reviewData[$i + 1])) { // 获取下一阶段review表ID,作为阶段跳转或发布申请的备用 $reviewState['step_chk']['next_step'] = $reviewData[$i + 1]['id']; } $currentStepMethod = $r['method']; $currentStepEmployeeFinished = $reviewState['reviewer_finished'] = $actual_user; } } else { array_push($reviewStateArr, $stepStr); } $i++; } // 当前阶段方法为全部:检查是否所有人已审核(自己除外) if ($currentStepMethod == 2) { $user_session = new Zend_Session_Namespace('user'); $self_id = $user_session->user_info['employee_id']; foreach ($currentStepEmployee as $e) { if ($self_id != $e && !in_array($e, $currentStepEmployeeFinished)) { $reviewState['step_chk']['to_finish'] = 0; break; } } } $reviewState['info'] = implode(' > ', $reviewStateArr); } return $reviewState; //<img src="' + HOME_PATH + '/public/images/icons/record_next.png"></img> }
/** * 获取文件编码及文件信息 */ public function getfilesbyidAction() { // 获取参数 $request = $this->getRequest()->getParams(); $id = $request['id']; $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $myDept = $user_session->user_info['dept_id']; $nowDate = date('Y-m-d'); $files = new Dcc_Model_Files(); $record = new Dcc_Model_Record(); $upload = new Dcc_Model_Upload(); $codeModel = new Dcc_Model_Code(); $share = new Dcc_Model_Share(); $review = new Dcc_Model_Review(); $modelUser = new Application_Model_User(); $data = $files->getDataById($id); // [id, code, ver, file_id, file_name, file_path, file_view_path] $result = array(); $row0 = $data[0]; $names = explode(',', $row0['name']); $codes = explode(',', $row0['code']); $vers = explode(',', $row0['ver']); $description = explode('|', $row0['description']); $project_info = explode(',', $row0['project_info']); $final_codes = array(); $final_vers = array(); $final_names = array(); $final_descs = array(); $final_projs = array(); $k = 0; for ($i = 0; $i < count($names); $i++) { $sub_names = explode('|', $names[$i]); $final_codes[$k] = $codes[$i]; $final_vers[$k] = $vers[$i]; if (isset($description[$i]) && $description[$i]) { $final_descs[$k] = $description[$i]; } else { $final_descs[$k] = ""; } if (isset($project_info[$i]) && $project_info[$i]) { $final_projs[$k] = $project_info[$i]; } else { $final_projs[$k] = ""; } $final_names[$k] = $sub_names[0]; $k++; for ($j = 1; $j < count($sub_names); $j++) { $final_codes[$k] = $codes[$i]; $final_vers[$k] = $vers[$i]; $final_names[$k] = $sub_names[$j]; if (isset($description[$i]) && $description[$i]) { $final_descs[$k] = $description[$i]; } else { $final_descs[$k] = ""; } if (isset($project_info[$i]) && $project_info[$i]) { $final_projs[$k] = $project_info[$i]; } else { $final_projs[$k] = ""; } $k++; } } $catalog = new Product_Model_Catalog(); for ($i = 0; $i < count($data); $i++) { $paths = $this->getPathByName($data, trim($final_names[$i])); $row = $data[$i]; $result[$i]['id'] = $row['id']; $result[$i]['state'] = $row['state']; if ($final_descs[$i]) { $result[$i]['description'] = $final_descs[$i]; } else { // 获取描述 $descData = $codeModel->getJoinList("code = '{$final_codes[$i]}'", array(), array('description', 'project_no')); if (count($descData) > 0) { $result[$i]['description'] = $descData[0]['description']; if (!$final_projs[$i]) { $final_projs[$i] = $descData[0]['project_no']; } } } $result[$i]['project_no'] = $final_projs[$i]; if ($final_projs[$i]) { $projData = $catalog->getById($final_projs[$i]); if ($projData && $projData['model_internal']) { $result[$i]['project_name'] = $projData['model_internal']; } } $result[$i]['code'] = $final_codes[$i]; $result[$i]['ver'] = $final_vers[$i]; $result[$i]['file_id'] = $paths[0]; $result[$i]['file_name'] = $final_names[$i]; $result[$i]['file_path'] = $paths[1]; $result[$i]['file_view_path'] = $paths[2]; // 权限检查 // 有权限的情况:1、本人上传的文件 2、本人提交的文件评审 3、本人参与审核的文件评审 4、共享给我的 5、将要审核的审核人 6、文件管理员、BOM管理员、物料管理员 // 首先检查文件是否存在 $result[$i]['exists'] = true; if (!file_exists($paths[1])) { $result[$i]['exists'] = false; } $role = false; if ($modelUser->checkPermissionByRoleName('物料管理员') || $modelUser->checkPermissionByRoleName('文件管理员') || $modelUser->checkPermissionByRoleName('系统管理员') || $modelUser->checkPermissionByRoleName('BOM管理员')) { $role = true; } else { if ($row0['create_user'] == $user || $row0['update_user'] == $user) { $role = true; } else { if ($record->fetchAll("table_id = {$id} and handle_user = {$user} and table_name = 'oa_doc_files' and action = '审批'")->count() > 0) { $role = true; } else { if ($upload->fetchAll("id = " . $row['id'] . " and (create_user = {$user} or update_user = {$user})")->count() > 0) { $role = true; } else { if ($share->fetchAll("shared_id = " . $row['id'] . " and type = 'upload' and share_time_begin <= '{$nowDate}' and share_time_end >= '{$nowDate}' and (FIND_IN_SET({$user}, share_user) or FIND_IN_SET({$myDept}, share_dept))")->count() > 0) { $role = true; } else { if ($review->fetchAll("file_id = {$id} and FIND_IN_SET({$user}, plan_user) and type = 'files'")->count() > 0) { $role = true; } } } } } } $result[$i]['role'] = $role; } echo Zend_Json::encode($result); exit; }
/** * 保存采购申请表体 */ public function edititemsAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); $type = isset($request['operate']) ? $request['operate'] : ''; // 操作类别 $typeArr = array('new' => '新建', 'edit' => '修改', 'transfer' => '变更'); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $json = json_decode($request['json']); $order_id = $json->order_id; $transfer_id = $json->transfer_id; $order_id = $json->order_id; $json_items = $json->items; $items_updated = $json_items->updated; $items_inserted = $json_items->inserted; $items_deleted = $json_items->deleted; $items = new Erp_Model_Purchse_Orderitems(); $itemsreq = new Erp_Model_Purchse_Orderitemsreq(); $transfer_items = new Erp_Model_Purchse_Transferorderitems(); // 更新 if (count($items_updated) > 0) { foreach ($items_updated as $val) { $active = $val->items_active ? 1 : 0; $total = round($val->items_qty * $val->items_price, 4); $data = array('active' => $active, 'req_number' => $val->items_req_number, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'supplier_code' => $val->items_supplier_code, 'supplier_codename' => $val->items_supplier_codename, 'supplier_description' => $val->items_supplier_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'price' => $val->items_price, 'total' => $total, 'warehouse_code' => $val->items_warehouse_code, 'request_date' => $val->items_request_date, 'dept_id' => $val->items_dept_id, 'project_info' => $val->items_project_info, 'remark' => $val->items_remark); try { if ($type == 'transfer') { $data['req_item_id'] = $val->items_req_item_id; $data['order_id'] = $order_id; $data['transfer_id'] = $transfer_id; $data['order_item_id'] = $val->items_id; $data['transfer_type'] = 'update'; $transfer_items->insert($data); } else { $data['update_user'] = $user_id; $data['update_time'] = $now; $items->update($data, "id = " . $val->items_id); // 保存分拆订单项信息 $this->saveSplitItem('update', $val->items_id, $val->items_req_item_id, $val->items_qty, $val->items_code, $active); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 插入 if (count($items_inserted) > 0) { foreach ($items_inserted as $val) { $active = $val->items_active ? 1 : 0; $total = round($val->items_qty * $val->items_price, 4); $data = array('order_id' => $order_id, 'active' => $active, 'req_number' => $val->items_req_number, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'supplier_code' => $val->items_supplier_code, 'supplier_codename' => $val->items_supplier_codename, 'supplier_description' => $val->items_supplier_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'price' => $val->items_price, 'total' => $total, 'warehouse_code' => $val->items_warehouse_code, 'request_date' => $val->items_request_date, 'dept_id' => $val->items_dept_id, 'project_info' => $val->items_project_info, 'remark' => $val->items_remark); try { if ($type == 'transfer') { $data['transfer_id'] = $transfer_id; $data['order_item_id'] = $val->items_id; $data['req_item_id'] = $val->items_req_item_id; $data['req_qty'] = $val->items_req_qty; $data['transfer_type'] = 'add'; $transfer_items->insert($data); } else { $data['create_user'] = $user_id; $data['create_time'] = $now; $data['update_user'] = $user_id; $data['update_time'] = $now; $order_item_id = $items->insert($data); $this->saveSplitItem('insert', $order_item_id, $val->items_req_item_id, $val->items_req_qty, $val->items_code); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 删除 if (count($items_deleted) > 0) { foreach ($items_deleted as $val) { try { if ($type == 'transfer') { $active = $val->items_active ? 1 : 0; $line_total = round($val->items_qty * $val->items_price, 4); $data = array('active' => $active, 'transfer_type' => 'delete', 'transfer_id' => $transfer_id, 'order_item_id' => $val->items_id, 'req_number' => $val->items_req_number, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'supplier_code' => $val->items_supplier_code, 'supplier_codename' => $val->items_supplier_codename, 'supplier_description' => $val->items_supplier_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'price' => $val->items_price, 'total' => $total, 'warehouse_code' => $val->items_warehouse_code, 'request_date' => $val->items_request_date, 'dept_id' => $val->items_dept_id, 'project_info' => $val->items_project_info, 'remark' => $val->items_remark); $transfer_items->insert($data); } else { $items->delete("id = " . $val->items_id); // 清除订单项对应的申请项数据 $itemsreq->delete("order_item_id = " . $val->items_id); $this->saveSplitItem('delete', $val->items_id, $val->items_req_item_id, $val->items_req_qty, $val->items_code); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 更新订单项状态 $activeItemsRes = $items->fetchAll("active = 1 and order_id = " . $order_id); if ($activeItemsRes->count() > 0) { $activeItems = $activeItemsRes->toArray(); for ($j = 0; $j < count($activeItems); $j++) { $itemsreq->update(array('active' => 1), "order_item_id = " . $activeItems[$j]['id']); } } // 更新采购申请总计 if ($type != 'transfer') { $items->refreshOrderTotal($order_id); } $order = new Erp_Model_Purchse_Order(); $order_data = $order->getData(null, $order_id); // 保存成功,进入审批流程 if ($result['success']) { // 根据流程ID获取阶段信息 $flow = new Admin_Model_Flow(); $flowData = $flow->fetchRow("id = " . $order_data['order_flow_id'])->toArray(); // 获取审核阶段 $step = new Admin_Model_Step(); $stepIds = $flowData['step_ids']; $stepArr = explode(',', $stepIds); $review = new Dcc_Model_Review(); $review->delete("type = 'purchse_order_add' and file_id = " . $order_id); $mailTo = null; $i = 0; $help = new Application_Model_Helpers(); // 根据阶段信息初始化审批流程,并向第一阶段审核人发送邮件 foreach ($stepArr as $s) { $stepData = $step->fetchRow("id = " . $s)->toArray(); $step_user = $stepData['user'] != '' ? $stepData['user'] : null; $step_role = $stepData['dept'] != '' ? $stepData['dept'] : null; $employeeArr = $help->getReviewEmployee($step_user, $step_role); $employeeIdArr = $employeeArr['id']; $employeeIds = implode(',', $employeeIdArr); $reviewData = array('type' => 'purchse_order_add', 'file_id' => $order_id, 'step_name' => $stepData['step_name'], 'plan_user' => $employeeIds, 'plan_dept' => $step_role, 'method' => $stepData['method'], 'return' => $stepData['return']); $review->insert($reviewData); // 第一阶段发送邮件通知 if ($i == 0) { $mailTo = $employeeIdArr; } $i++; } if ($mailTo) { // 获取币种信息 $currency = new Erp_Model_Setting_Currency(); $currencyInfo = $currency->getInfoByCode($order_data['currency']); $total = $order_data['total']; if ($order_data['currency_rate'] != 1) { $total = $order_data['forein_total']; } $mailContent = '<div>新建采购订单,请登录系统查看:</div> <div> <p><b>订单号:</b>' . $order_data['number'] . '</p> <p><b>采购员:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>类别:</b>' . $order_data['type'] . '</p> <p><b>金额:</b><a style="color: #467500;font-weight: bold;">' . $currencyInfo['symbol'] . $total . '</a></p> <p><b>描述:</b>' . $order_data['description'] . '</p> <p><b>备注:</b>' . $order_data['remark'] . '</p> <p><b>申请时间:</b>' . $order_data['create_time'] . '</p> <p><b>更新时间:</b>' . $order_data['update_time'] . '</p> </div><hr>'; $transferContent = ''; if ($type == 'transfer') { $transferContent .= '<div><style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:12px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } .delete{ text-decoration: line-through; color: #FF0000; } .update{ font-weight: bold; color: #000093; } .inactive{ font-weight: bold; color: #999999; } </style><table class="gridtable"> <tr> <th>#</th> <th>操作类别</th> <th>启用</th> <th>物料号</th> <th>名称</th> <th>描述</th> <th>数量</th> <th>已收货</th> <th>需求日期</th> <th>项目信息</th> <th>备注</th> </tr>'; $i = 1; foreach ($items_inserted as $val) { $active = $val->items_active ? '是' : '否'; $transferContent .= '<tr> <td>' . $i . '</td> <td>新增</td> <td>' . $active . '</td> <td>' . $val->items_code . '</td> <td>' . $val->items_name . '</td> <td>' . $val->items_description . '</td> <td>' . $val->items_qty . '</td> <td>0</td> <td>' . date('Y-m-d', strtotime($val->items_request_date)) . '</td> <td>' . $val->items_project_info . '</td> <td>' . $val->items_remark . '</td> </tr>'; $i++; } foreach ($items_updated as $val) { $tr = '<tr>'; if (!$val->items_active) { $tr = '<tr class="inactive">'; } else { $tr = '<tr class="update">'; } $active = $val->items_active ? '是' : '否'; $transferContent .= $tr . ' <td>' . $i . '</td> <td>更新</td> <td>' . $active . '</td> <td>' . $val->items_code . '</td> <td>' . $val->items_name . '</td> <td>' . $val->items_description . '</td> <td>' . $val->items_qty . '</td> <td>' . $val->items_qty_receive . '</td> <td>' . $val->items_request_date . '</td> <td>' . $val->items_project_info . '</td> <td>' . $val->items_remark . '</td> </tr>'; $i++; } foreach ($items_deleted as $val) { $active = $val->items_active ? '是' : '否'; $transferContent .= '<tr class="delete"> <td>' . $i . '</td> <td>删除</td> <td>' . $active . '</td> <td>' . $val->items_code . '</td> <td>' . $val->items_name . '</td> <td>' . $val->items_description . '</td> <td>' . $val->items_qty . '</td> <td>0</td> <td>' . $val->items_request_date . '</td> <td>' . $val->items_project_info . '</td> <td>' . $val->items_remark . '</td> </tr>'; $i++; } $transferContent .= '</table></div>'; } $mailData = array('type' => '消息', 'subject' => '采购订单-' . $typeArr[$type], 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent . $transferContent, 'add_date' => $now); if ($transferContent != '') { $transfer = new Erp_Model_Purchse_Transfer(); $transfer->update(array('transfer_content' => $transferContent), "id = " . $transfer_id); } $result = $help->sendMailToStep($mailTo, $mailData); } } echo Zend_Json::encode($result); exit; }
/** * @abstract 添加新文件 * @return null */ public function saveAction() { // 返回值数组 $result = array('success' => true, 'result' => true, 'info' => '添加成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $val = (object) $request; $files = new Dcc_Model_Files(); $review = new Dcc_Model_Review(); $code = new Dcc_Model_Code(); $upgrade = new Dcc_Model_Upgrade(); // 新增还是编辑 if ($val->id) { // 判断此次版本是否已存在 if ($files->fetchAll("id != {$val->id} and ver = '" . $val->ver . "' and code = '" . $val->code . "'")->count() > 0) { $result['result'] = false; $result['info'] = "文件“" . $val->code . "”的" . $val->ver . "版本已经存在"; echo Zend_Json::encode($result); exit; } $result['info'] = '修改成功'; $data = array('state' => $val->state, 'code' => $val->code, 'ver' => $val->ver, 'name' => $val->name, 'file_ids' => $val->file_ids, 'description' => $val->description, 'project_info' => $val->project_info, 'send_require' => isset($val->send_require) ? 1 : 0, 'remark' => $val->remark, 'tag' => $val->tag, 'archive_time' => $val->archive_time, 'update_time' => $now, 'update_user' => $user); $id = $val->id; $where = "id = " . $id; $up = false; if ($val->ver && $val->ver > 1.0) { $up = true; // 修改升版记录 $upgradeData = array('reason' => $val->reason, 'reason_type' => $val->reason_type, 'update_time' => $now, 'update_user' => $user); $upgradeWhere = "file_id = {$id}"; } // 更新旧版文件的状态为已作废 if ($val->ver != '1.0' && $val->state == 'Active') { $obsoluteWhere = "ver < '" . $val->ver . "' and code = '" . $val->code . "'"; $obsoluteData = array("state" => "Obsolete"); } $projectData = array("project_no" => $val->project_no); $projectWhere = "code= '" . $val->code . "'"; try { if (isset($obsoluteData) && isset($obsoluteWhere)) { $files->update($obsoluteData, $obsoluteWhere); } if ($up) { $upgrade->update($upgradeData, $upgradeWhere); } $files->update($data, $where); $code->update($projectData, $projectWhere); if ($val->state == 'Active' && isset($val->file_ids) && $val->file_ids != "") { // 更新文件状态为已归档 $uploadData = array("archive" => 1, "archive_time" => $now); $upload = new Dcc_Model_Upload(); // 获取上传文件id $ids = $val->file_ids; $uploadWhere = "id in ({$ids})"; $upload->update($uploadData, $uploadWhere); } if ($val->state == 'Return') { // 更改review状态 // 需更新的审核记录: 所有 $reviewWhere = "type = 'files' and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => "", "finish_time" => null, "finish_flg" => 0); $review->update($reviewData, $reviewWhere); } if ($id) { $attrval = new Admin_Model_Formval(); // 自定义字段 foreach ($request as $field => $value) { if (stripos($field, "intelligenceField") !== false) { $attrId = str_replace("intelligenceField", "", $field); $menu = 'oa_doc_files_' . $id; $formval = array('attrid' => $attrId, 'value' => $value, 'menu' => $menu); $where = "attrid = " . $attrId . " and menu = '" . $menu . "'"; if ($attrval->fetchAll($where)->count() > 0) { // 更新 $attrval->update($formval, $where); } else { $attrval->insert($formval); } } } $record = new Dcc_Model_Record(); // 操作记录 $data = array('type' => "files", 'table_name' => "oa_doc_files", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "编辑", 'ip' => $_SERVER['REMOTE_ADDR'], 'remark' => isset($request['edit_info']) ? $request['edit_info'] : ''); $record->insert($data); } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } echo Zend_Json::encode($result); exit; } else { // 判断此次版本是否已存在 if ($files->fetchAll("ver = " . $val->ver . " and code = '" . $val->code . "'")->count() > 0) { $result['result'] = false; $result['info'] = "文件“" . $val->code . "”的" . $val->ver . "版本已经存在"; echo Zend_Json::encode($result); exit; } $data = array('state' => $val->state, 'code' => $val->code, 'ver' => $val->ver, 'name' => $val->name, 'file_ids' => $val->file_ids, 'description' => $val->description, 'project_info' => $val->project_info, 'send_require' => isset($val->send_require) ? 1 : 0, 'remark' => $val->remark, 'tag' => $val->tag, 'archive_time' => $val->archive_time, 'create_time' => $now, 'create_user' => $user, 'update_time' => $now, 'update_user' => $user); // 更新旧版文件的状态为已作废 if ($val->ver != '1.0' && $val->state == 'Active') { $obsoluteWhere = "ver < '" . $val->ver . "' and code = '" . $val->code . "'"; $obsoluteData = array("state" => "Obsolete"); } try { $id = $files->insert($data); if ($id && $val->ver && $val->ver > 1.0) { // 升版记录 $upgradeData = array('file_id' => $id, 'reason' => $val->reason, 'reason_type' => $val->reason_type, 'create_time' => $now, 'create_user' => $user, 'update_time' => $now, 'update_user' => $user); $upgrade->insert($upgradeData); } if (isset($obsoluteData) && isset($obsoluteWhere)) { $files->update($obsoluteData, $obsoluteWhere); } if (isset($val->file_ids) && $val->file_ids != "") { // 更新文件状态为已归档 $uploadData = array("archive" => 1); $upload = new Dcc_Model_Upload(); // 获取上传文件id $ids = $val->file_ids; $uploadWhere = "id in ({$ids})"; $upload->update($uploadData, $uploadWhere); } if ($id) { $attrval = new Admin_Model_Formval(); // 自定义字段 foreach ($request as $field => $value) { if (stripos($field, "intelligenceField") !== false && $value) { $attrId = str_replace("intelligenceField", "", $field); $menu = 'oa_doc_files_' . $id; $formval = array('attrid' => $attrId, 'value' => $value, 'menu' => $menu); $attrval->insert($formval); } } $record = new Dcc_Model_Record(); // 操作记录 $data = array('type' => "files", 'table_name' => "oa_doc_files", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "新增", 'ip' => $_SERVER['REMOTE_ADDR']); $record->insert($data); } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } echo Zend_Json::encode($result); exit; } }
/** * @abstract 删除 * @return null */ public function removeAction() { // 返回值数组 $result = array('success' => true, 'result' => true, 'info' => '删除成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $json = json_decode($request['json']); $deleted = $json->deleted; $updbom = new Product_Model_Updbom(); $fadev = new Product_Model_Fadev(); $sondev = new Product_Model_Sondev(); $fa = new Product_Model_Fa(); $son = new Product_Model_Son(); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); if (count($deleted) > 0) { foreach ($deleted as $val) { $id = $val->id; $upd_type = $val->upd_type; if ($upd_type == 'ECO') { $bomflg = "ecobom"; $table = "oa_product_bom_eco"; } else { if ($upd_type == 'DEV') { $bomflg = "devbom"; $table = "oa_product_bom_dev"; } } // 操作记录 $data = array('type' => $bomflg, 'table_name' => $table, 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "删除", 'ip' => $_SERVER['REMOTE_ADDR']); // 获取bom fa表的recordkey $sql = "select recordkey from oa_product_bom_fa_dev where nid={$id} and (type='DEV' or type='ECO')"; $keys = $fa->getAdapter()->query($sql)->fetchObject(); if ($keys && $keys->recordkey) { $recordkey = $keys->recordkey; } else { $sql = "select recordkey from oa_product_bom_fa where nid={$id} and (type='DEV' or type='ECO')"; $keys = $fa->getAdapter()->query($sql)->fetchObject(); if ($keys && $keys->recordkey) { $recordkey = $keys->recordkey; } } try { // 增加record记录 $record->insert($data); // 删除review记录 $review->delete("type = '{$bomflg}' and file_id = {$id}"); // 删除bom表 $updbom->delete("id = {$id}"); if (isset($recordkey) && $recordkey) { $where = "recordkey = {$recordkey}"; $fadev->delete($where); $sondev->delete($where); $fa->delete($where); $son->delete($where); } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }
/** * @abstract 删除 * @return null */ public function removeAction() { // 返回值数组 $result = array('success' => true, 'result' => true, 'info' => '删除成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $json = json_decode($request['json']); $deleted = $json->deleted; $desc = new Product_Model_Desc(); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); if (count($deleted) > 0) { foreach ($deleted as $val) { $id = $val->id; // 操作记录 $data = array('type' => "materiel_desc", 'table_name' => "oa_product_materiel_desc", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "删除", 'ip' => $_SERVER['REMOTE_ADDR']); try { // 增加record记录 $record->insert($data); // 删除review记录 $review->delete("type = 'materiel_desc' and file_id = {$id}"); // 更新物料状态 $desc->update(array('state' => 'Deleted'), "id = {$id}"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }
public function overtimeAction() { // 返回值数组 $result = array('success' => true, 'info' => '提交成功'); // 请求参数 $request = $this->getRequest()->getParams(); // 操作类型 $operate = array('new' => '新建', 'edit' => '编辑', 'delete' => '删除'); // 操作类别(新建、更新、删除) $operate_type = isset($request['operate']) ? $request['operate'] : ''; $overtime = new Hra_Model_Attendance_Overtime(); if ($operate_type == 'new_hra' || $operate_type == 'new' || $operate_type == 'edit') { $time_from = str_replace('T', ' ', $request['time_from']); $time_to = str_replace('T', ' ', $request['time_to']); if (date('Y-m', strtotime($time_from)) != date('Y-m', strtotime($time_to))) { $result['success'] = false; $request['info'] = '不允许跨月申请,请重新填写时间!'; echo Zend_Json::encode($result); exit; } // 获取加班人员的用工形式(0:弹性,1:非弹性) $user = new Application_Model_User(); $userInfo = $user->getEmployeeInfoById($request['apply_user']); $userType = $userInfo['employment_type']; $workday = new Hra_Model_Workday(); // 获取请假区间包含的工作日天数 $overtimeInfo = $workday->getOvertimeQtyByTimeRange($userType, $request['time_from'], $request['time_to']); $overtimeQty = $overtimeInfo['qty']; $overtimeQty_hours = $overtimeInfo['qty_hours']; /* echo $overtimeQty; exit; */ // 加班类别按起始日期获取 $overtimeType = $workday->getWorkdayType($userType, date('Y-m-d', strtotime($request['time_from']))); if ($overtimeType == 0) { $result['success'] = false; $request['info'] = '工作日设置错误,请检查工作日设置!'; echo Zend_Json::encode($result); exit; } // 当编辑请假申请时,检查时间是否重叠需要过滤当前加班申请ID $filter_id = null; if ($operate_type == 'edit') { $filter_id = $request['id']; } // 检查加班时间范围是否正确 if ($overtimeQty > 0) { // 检查加班时间范围是否跟已有申请(包括已审核和审核中的申请)重叠 if ($overtime->checkTimeOverlap($request['apply_user'], $request['time_from'], $request['time_to'], $filter_id)) { $result['success'] = false; $result['info'] = '时间设置错误,加班时间重叠,请优先处理未审申请。'; } else { $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; // 当前申请为代申请时,获取申请人真实部门主管 if ($request['apply_user'] != $user_id) { // 获取部门主管 $manager = $user->getManagerUser($request['apply_user']); $request['review_user_1'] = $manager[0]['id']; } if ($request['review_user_1'] >= 0) { $data = array('type' => $overtimeType, 'apply_user' => $request['apply_user'], 'review_user_1' => $request['review_user_1'], 'time_from' => $request['time_from'], 'time_to' => $request['time_to'], 'qty' => $overtimeQty, 'qty_hours' => $overtimeQty_hours, 'reason' => $request['reason'], 'remark' => $request['remark'], 'update_time' => $now, 'update_user' => $user_id); /* echo '<pre>'; print_r($data); exit; */ if ($operate_type == 'new_hra') { // HRA手动添加 $data['state'] = 3; $data['create_time'] = $now; $data['create_user'] = $user_id; $data['review_info'] = $now . ': ' . $user_session->user_info['user_name'] . ' [手动添加]'; try { $overtime_id = $overtime->insert($data); echo Zend_Json::encode($result); exit; } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { if ($operate_type == 'new') { $data['create_time'] = $now; $data['create_user'] = $user_id; $data['review_info'] = $now . ': ' . $user_session->user_info['user_name'] . ' [新建]'; try { $overtime_id = $overtime->insert($data); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $overtime_id = $request['id']; $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [修改]'; $overtimeData = $overtime->getData(null, $overtime_id); $data['review_info'] = $overtimeData['review_info'] . '<br>' . $review_info; $data['state'] = 0; $data['review_time_1'] = null; //$data['review_time_2'] = null; $data['release_time'] = null; try { $overtime->update($data, "id = " . $overtime_id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } $overtimeData = $overtime->getData(null, $overtime_id); $review = new Dcc_Model_Review(); $user = new Application_Model_User(); $help = new Application_Model_Helpers(); // 记录审核日志:审核人1 $apply_user_info = $user->getEmployeeInfoById($request['apply_user']); $review_user_1_info = $user->getEmployeeInfoById($request['review_user_1']); $reviewData = array('type' => 'attendance_overtime', 'file_id' => $overtime_id, 'step_name' => '审核人1', 'plan_user' => $overtimeData['review_employee_1_id'], 'method' => 1, 'return' => 1); $review->insert($reviewData); // 如果存在审核人2记录审核日志:审核人2 /* if($request['review_user_2']){ $review_user_2_info = $user->getEmployeeInfoById($request['review_user_2']); $reviewData = array( 'type' => 'attendance_overtime', 'file_id' => $overtime_id, 'step_name' => '审核人2', 'plan_user' => $overtimeData['review_employee_2_id'], 'method' => 1, 'return' => 1 ); $review->insert($reviewData); } */ // 记录审核日志:人事主管 $member = new Admin_Model_Member(); $hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管'); $hraEmployeeIdArr = array(); foreach ($hraAdminUserArr as $hra) { $hra_info = $user->getEmployeeInfoById($hra['user_id']); array_push($hraEmployeeIdArr, $hra_info['id']); } $hraIds = implode(',', $hraEmployeeIdArr); $reviewData = array('type' => 'attendance_overtime', 'file_id' => $overtime_id, 'step_name' => '人事审核', 'plan_user' => $hraIds, 'method' => 1, 'return' => 1); $review->insert($reviewData); // 向审核人1发送邮件 $mailContent = '<div>你有一个新的加班申请等待审核,请登录系统查看:</div> <div> <p><b>申请人:</b><a style="color:#008B00;font-weight: bold;">' . $overtimeData['apply_user_name'] . '</a></p> <p><b>加班时间:</b><a style="color:#008B00;font-weight: bold;">' . $overtimeData['time_from'] . '</a> 至 <a style="color:#008B00;font-weight: bold;">' . $overtimeData['time_to'] . '</a></p> <p><b>事由:</b>' . $overtimeData['reason'] . '</p> <p><b>备注:</b>' . $overtimeData['remark'] . '</p> <p><b>创建人:</b>' . $overtimeData['creater'] . '</p> <p><b>申请时间:</b>' . $overtimeData['create_time'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $data['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '加班申请-新申请', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now); $result = $help->sendMailToStep(array($review_user_1_info['id']), $mailData); } else { $result['success'] = false; $result['info'] = '申请失败,当前申请人未设置部门主管。'; } } } else { $result['success'] = false; $result['info'] = '时间设置错误,请确认时间范围是否正确。'; } } else { if ($operate_type == 'delete') { if (isset($request['id']) && count(Zend_Json::decode($request['id'])) > 0) { $ids = Zend_Json::decode($request['id']); // 多条申请逐条删除 foreach ($ids as $id) { try { $review = new Dcc_Model_Review(); // 删除审核日志 $review->delete("type = 'attendance_overtime' and file_id = " . $id); $overtime->delete("id = " . $id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } else { $result['success'] = false; $result['info'] = '参数错误,没有删除对象。'; } } else { $result['success'] = false; $result['info'] = '参数错误,没有操作类别。'; } } echo Zend_Json::encode($result); exit; }
public function reviewAction() { // 返回值数组 $result = array('success' => true, 'info' => '审核成功'); $request = $this->getRequest()->getParams(); $review_id = isset($request['review_id']) ? $request['review_id'] : null; $review_operate = isset($request['review_operate']) ? $request['review_operate'] : null; $review_current_step = isset($request['review_current_step']) ? $request['review_current_step'] : null; // 当前阶段(review表ID) $review_last_step = isset($request['review_last_step']) ? $request['review_last_step'] : null; // 是否当前阶段为最后一阶段 $review_to_finish = isset($request['review_to_finish']) ? $request['review_to_finish'] : null; // 是否批准后当前阶段结束 $review_next_step = isset($request['review_next_step']) ? $request['review_next_step'] : null; // 下一阶段(review表ID) $review_remark = isset($request['review_remark']) ? $request['review_remark'] : null; $review_transfer_user = isset($request['review_transfer_user']) ? $request['review_transfer_user'] : null; //转审人 if ($review_id && $review_operate) { $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $employee_id = $user_session->user_info['employee_id']; // 评审意见 $review_info = '意见: ' . $review_remark; $price = new Erp_Model_Sale_Price(); $user = new Application_Model_User(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); $priceData = $price->getData(null, $review_id); // 更新审核状态及审核意见 if ($review_operate == 'transfer') { // 转审 $tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : ''; $review_info = $tmp . $now . ': ' . $user_session->user_info['user_name'] . ' [审核-转审] [' . $review_info . ']'; $price->update(array('review_info' => $review_info), "id = " . $review_id); $reviewState = $review->fetchRow("type = 'sale_price_add' and finish_flg = 0 and file_id = " . $review_id, "id")->toArray(); // 转审对象 $transferUserInfo = $user->getEmployeeInfoById($review_transfer_user); $reviewUsers = $reviewState['plan_user']; $reviewUserArr = explode(',', $reviewUsers); $reviewer = array(); if ($reviewState['method'] == 2) { // 任意: 直接替换审核人为转审对象 foreach ($reviewUserArr as $review_user) { if ($review_user == $employee_id) { array_push($reviewer, $transferUserInfo['id']); } } } else { // 全部: 替换当前审核人为转审对象,其余审核人保留 foreach ($reviewUserArr as $review_user) { if ($review_user == $employee_id) { array_push($reviewer, $transferUserInfo['id']); } else { if (!in_array($review_user, $reviewer)) { array_push($reviewer, $review_user); } } } } $reviewerstr = implode(',', $reviewer); $review->update(array('plan_user' => $reviewerstr), "id = " . $reviewState['id']); // 发送邮件通知制单人 $reviewResult = '<font style="color: #FF0000"><b>转审</b></font>'; $mail = new Application_Model_Log_Mail(); $to = $transferUserInfo['email']; $mailContent = '<div>销售价格申请审核:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>申请单号:</b>' . $priceData['number'] . '</p> <p><b>申请人:</b>' . $priceData['creater'] . '</p> <p><b>描述:</b>' . $priceData['description'] . '</p> <p><b>备注:</b>' . $priceData['remark'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $priceData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '销售价格申请-转审', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $user_session->user_info['user_id'], 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { if ($review_operate == 'no') { // 更新申请状态 $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']'; $tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : ''; $data = array('state' => 1, 'review_info' => $tmp . $review_info); $price->update($data, "id = " . $review_id); // 删除当前申请的审核配置 $review->delete("type = 'sale_price_add' and file_id = " . $review_id); // 发送邮件通知制单人 $reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>'; $mail = new Application_Model_Log_Mail(); $applyEmployeeData = $user->fetchRow("id = " . $priceData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); $to = $applyEmployee['email']; $mailContent = '<div>销售价格申请审核:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>申请单号:</b>' . $priceData['number'] . '</p> <p><b>申请人:</b>' . $priceData['creater'] . '</p> <p><b>描述:</b>' . $priceData['description'] . '</p> <p><b>备注:</b>' . $priceData['remark'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $priceData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '销售价格申请-审核', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $priceData['create_user'], 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $help = new Application_Model_Helpers(); $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']'; $tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : ''; $reqUpdateData = array('review_info' => $tmp . $review_info); $reviewData = $review->fetchRow("id = " . $review_current_step)->toArray(); $actual_user = $reviewData['actual_user'] == '' ? $user_session->user_info['employee_id'] : $reviewData['actual_user'] . ',' . $user_session->user_info['employee_id']; $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); // 当前审核阶段为最后一阶段 if ($review_last_step == 1) { // 当前阶段已完结 if ($review_to_finish == 1) { $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); $reviewResult = '<font style="color: #006400"><b>发布</b></font>'; // 发布:检查客户的当前产品(包括类别)是否存在生效价格(如存在则更新历史价格为作废) $price->updatePriceByPriceId($review_id); // 更新申请状态 $reqUpdateData['state'] = 2; $reqUpdateData['release_time'] = $now; // 更新审核记录表 $review->update($data, "id = " . $review_current_step); $mail = new Application_Model_Log_Mail(); $applyEmployeeData = $user->fetchRow("id = " . $priceData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); $to = $applyEmployee['email']; $cc = $user_session->user_info['user_email']; $mailContent = '<div>销售价格审核批准,请登录系统查看:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>申请单号:</b>' . $priceData['number'] . '</p> <p><b>申请人:</b>' . $priceData['creater'] . '</p> <p><b>描述:</b>' . $priceData['description'] . '</p> <p><b>备注:</b>' . $priceData['remark'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $reqUpdateData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '销售价格申请-发布', 'to' => $to, 'cc' => $cc, 'user_id' => $priceData['create_user'], 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $data = array('actual_user' => $actual_user); $review->update($data, "id = " . $review_current_step); } } else { // 当前阶段已完结 if ($review_to_finish == 1) { $data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1); $reviewResult = '<font style="color: #006400"><b>批准</b></font>'; // 进入下一阶段 // 更新审核记录表 $review->update($data, "id = " . $review_current_step); // 邮件通知下一阶段审核人 $reviewNextStepData = $review->fetchRow("id = " . $review_next_step)->toArray(); $mailTo = explode(',', $reviewNextStepData['plan_user']); if ($mailTo) { $mailContent = '<div>销售价格申请,请登录系统查看:</div> <div> <p><b>审核人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>审核结果:</b>' . $reviewResult . '</p> <p><b>审核意见:</b>' . $review_remark . '</p> <p><b>申请单号:</b>' . $priceData['number'] . '</p> <p><b>申请人:</b>' . $priceData['creater'] . '</p> <p><b>描述:</b>' . $priceData['description'] . '</p> <p><b>备注:</b>' . $priceData['remark'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $reqUpdateData['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '销售价格申请-新申请', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now); $resultMail = $help->sendMailToStep($mailTo, $mailData); if (!$resultMail['success']) { $result = $resultMail; } } } else { $data = array('actual_user' => $actual_user); $review->update($data, "id = " . $review_current_step); // 等待其他审核人批准 } } // 更新申请状态 $price->update($reqUpdateData, "id = " . $review_id); } } } echo Zend_Json::encode($result); exit; }
public function editcatalogAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $request = $this->getRequest()->getParams(); $attribute = isset($request['attribute']) ? $request['attribute'] : false; $catalog = new Product_Model_Catalog(); if ($attribute) { $catalog_id = isset($request['id']) ? $request['id'] : null; $code = isset($request['code']) ? $request['code'] : null; $code_old = isset($request['code_old']) ? $request['code_old'] : null; $stage_id = isset($request['stage_id']) && $request['stage_id'] != '' ? $request['stage_id'] : null; $remark = isset($request['remark']) ? $request['remark'] : null; $date_dvt = isset($request['date_dvt']) && $request['date_dvt'] != '' ? $request['date_dvt'] : null; $qa1_date = isset($request['qa1_date']) && $request['qa1_date'] != '' ? $request['qa1_date'] : null; $qa2_date = isset($request['qa2_date']) && $request['qa2_date'] != '' ? $request['qa2_date'] : null; $evt_date = isset($request['evt_date']) && $request['evt_date'] != '' ? $request['evt_date'] : null; $mass_production_date = isset($request['mass_production_date']) && $request['mass_production_date'] != '' ? $request['mass_production_date'] : null; if ($catalog_id && $code) { if ($catalog->fetchAll("id != " . $catalog_id . " and code = '" . $code . "'")->count() == 0) { $data = array('code' => $code, 'code_old' => $code_old, 'stage_id' => $stage_id, 'remark' => $remark, 'date_dvt' => $date_dvt, 'qa1_date' => $qa1_date, 'qa2_date' => $qa2_date, 'evt_date' => $evt_date, 'mass_production_date' => $mass_production_date, 'update_time' => $now, 'update_user' => $user_id); $where = "id = " . $catalog_id; try { $catalog->update($data, $where); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '代码重复,请重新分配'; echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '信息不完整,编辑失败!'; } } else { $operate = isset($request['operate']) ? $request['operate'] : null; $review = isset($request['review']) ? $request['review'] : null; $id = isset($request['id']) ? $request['id'] : null; $ids = isset($request['ids']) ? $request['ids'] : null; $active = isset($request['active']) ? $request['active'] : null; $active = $active == 'on' ? 1 : 0; $description = isset($request['description']) ? $request['description'] : null; $remark = isset($request['remark']) ? $request['remark'] : null; $code_customer = isset($request['code_customer']) ? trim($request['code_customer']) : null; $model_customer = isset($request['model_customer']) ? trim($request['model_customer']) : null; $description_customer = isset($request['description_customer']) ? $request['description_customer'] : null; $type_id = isset($request['type_id']) ? $request['type_id'] : null; $type_id = isset($request['type_id']) ? $request['type_id'] : null; $series_id = isset($request['series_id']) ? $request['series_id'] : null; $series_id = isset($request['series_id']) ? $request['series_id'] : null; $developmode_id = isset($request['developmode_id']) ? $request['developmode_id'] : null; $model_standard = isset($request['model_standard']) ? trim($request['model_standard']) : null; $model_internal = isset($request['model_internal']) ? trim($request['model_internal']) : null; if ($operate == 'delete' && $id) { // 删除 try { if ($catalog->fetchAll("id = " . $id . " and auditor_id is not null")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('delete' => 1, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [删除]'), "id = " . $id); } else { $catalog->delete("id = " . $id); $review = new Dcc_Model_Review(); $review->delete("type = 'product_add' and file_id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { if ($operate == 'disable' && $ids) { // 作废 $idArr = explode(',', $ids); foreach ($idArr as $id) { try { if ($catalog->fetchAll("id = " . $id . " and active = 1")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('active' => 0, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [作废]'), "id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } else { if ($operate == 'enable' && $ids) { // 启用 $idArr = explode(',', $ids); foreach ($idArr as $id) { try { if ($catalog->fetchAll("id = " . $id . " and active = 0")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('active' => 1, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [启用]'), "id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } else { if ($operate == 'edit' && $id) { // 判断是否重复 if ($catalog->fetchAll("id != " . $id . " and model_internal = '" . $model_internal . "'")->count() == 0) { //type_id = ".$type_id." and series_id = ".$series_id." and $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $data = array('active' => $active, 'type_id' => $type_id, 'series_id' => $series_id, 'developmode_id' => $developmode_id, 'model_standard' => $model_standard, 'model_internal' => $model_internal, 'description' => $description, 'remark' => $remark, 'review' => $review == 1 ? 0 : 2, 'code_customer' => $code_customer, 'model_customer' => $model_customer, 'description_customer' => $description_customer, 'update_time' => $now, 'update_user' => $user_id, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [修改]'); $where = "id = " . $id; try { $catalog->update($data, $where); if ($catalogData['review'] == 1) { // 修改 $member = new Admin_Model_Member(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $flow = new Admin_Model_Flow(); $step = new Admin_Model_Step(); $review = new Dcc_Model_Review(); $flowData = $flow->fetchRow("flow_name = '产品中心-审核'")->toArray(); // 获取审核阶段 $stepIds = $flowData['step_ids']; $stepArr = explode(',', $stepIds); $i = 0; foreach ($stepArr as $s) { $stepData = $step->fetchRow("id = " . $s)->toArray(); $step_user = $stepData['user'] != '' ? $stepData['user'] : null; $step_role = $stepData['dept'] != '' ? $stepData['dept'] : null; $reviewData = array('type' => 'product_add', 'file_id' => $id, 'step_name' => $stepData['step_name'], 'plan_user' => $step_user, 'plan_dept' => $step_role, 'method' => $stepData['method'], 'return' => $stepData['return']); $review->delete("type = 'product_add' AND file_id = " . $id); $review->insert($reviewData); // 第一阶段发送邮件通知 if ($i == 0) { $employeeIdArr = array(); if ($step_user) { $tmpArr = explode(',', $stepData['user']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t); } } } if ($step_role) { $tmpArr = $member->getMember($stepData['dept']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t['employee_id']); } } } $toAddress = array(); $toIds = array(); foreach ($employeeIdArr as $employeeId) { $em = $employee->getInfoById($employeeId); array_push($toAddress, $em['email']); $u = $user->fetchRow("employee_id = " . $employeeId)->toArray(); array_push($toIds, $u['id']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心-修改产品信息,请登录系统审核:</div> <div> <p><b>标准型号:</b>' . $catalogData['model_standard'] . ' -> ' . $model_standard . '</p> <p><b>内部型号:</b>' . $catalogData['model_internal'] . ' -> ' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-修改', 'to' => implode(',', $toAddress), 'cc' => $user_session->user_info['user_email'], 'user_id' => implode(',', $toIds), 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } $i++; } } else { // 变更 $noticeMails = array(); $noticeUsers = array(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $member = new Admin_Model_Member(); $reviewModel = new Dcc_Model_Review(); $reviewerInfo = $reviewModel->getReviewUserInfo('product_add', $id); // 审核人 $applyEmployeeData = $user->fetchRow("id = " . $catalogData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); // 申请人 $noticeTo = $member->getMemberWithManagerByName('产品中心-PM'); // 管理员 foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } foreach ($reviewerInfo as $r) { if ($r['email'] != '' && !in_array($r['user_id'], $noticeUsers)) { array_push($noticeMails, $r['email']); array_push($noticeUsers, $r['user_id']); } } if (!in_array($catalogData['create_user'], $noticeUsers)) { array_push($noticeMails, $applyEmployee['email']); array_push($noticeUsers, $catalogData['create_user']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心产品信息变更,请登录系统查看:</div> <div> <p><b>标准型号:</b>' . $catalogData['model_standard'] . ' -> ' . $model_standard . '</p> <p><b>内部型号:</b>' . $catalogData['model_internal'] . ' -> ' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-变更', 'cc' => $user_session->user_info['user_email'], 'to' => implode(',', $noticeMails), 'user_id' => $user_id, 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '当前型号已存在,请勿重复添加!'; echo Zend_Json::encode($result); exit; } } else { if ($operate == 'add') { if ($catalog->fetchAll("model_internal = '" . $model_internal . "'")->count() == 0) { //type_id = ".$type_id." and series_id = ".$series_id." and $data = array('active' => $active, 'type_id' => $type_id, 'series_id' => $series_id, 'developmode_id' => $developmode_id, 'model_standard' => $model_standard, 'model_internal' => $model_internal, 'remark' => $remark, 'description' => $description, 'code_customer' => $code_customer, 'model_customer' => $model_customer, 'description_customer' => $description_customer, 'create_time' => $now, 'create_user' => $user_id, 'update_time' => $now, 'update_user' => $user_id, 'review_info' => $now . ': ' . $user_session->user_info['user_name'] . ' [添加]'); try { $catalog_id = $catalog->insert($data); $member = new Admin_Model_Member(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $flow = new Admin_Model_Flow(); $step = new Admin_Model_Step(); $review = new Dcc_Model_Review(); $flowData = $flow->fetchRow("flow_name = '产品中心-审核'")->toArray(); // 获取审核阶段 $stepIds = $flowData['step_ids']; $stepArr = explode(',', $stepIds); $i = 0; foreach ($stepArr as $s) { $stepData = $step->fetchRow("id = " . $s)->toArray(); $step_user = $stepData['user'] != '' ? $stepData['user'] : null; $step_role = $stepData['dept'] != '' ? $stepData['dept'] : null; $reviewData = array('type' => 'product_add', 'file_id' => $catalog_id, 'step_name' => $stepData['step_name'], 'plan_user' => $step_user, 'plan_dept' => $step_role, 'method' => $stepData['method'], 'return' => $stepData['return']); $review->insert($reviewData); // 第一阶段发送邮件通知 if ($i == 0) { $employeeIdArr = array(); if ($step_user) { $tmpArr = explode(',', $stepData['user']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t); } } } if ($step_role) { $tmpArr = $member->getMember($stepData['dept']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t['employee_id']); } } } $toAddress = array(); $toIds = array(); foreach ($employeeIdArr as $employeeId) { $em = $employee->getInfoById($employeeId); array_push($toAddress, $em['email']); $u = $user->fetchRow("employee_id = " . $employeeId)->toArray(); array_push($toIds, $u['id']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心新增产品型号,请登录系统审核:</div> <div> <p><b>标准型号:</b>' . $model_standard . '</p> <p><b>内部型号:</b>' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-新建', 'to' => implode(',', $toAddress), 'user_id' => implode(',', $toIds), 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } $i++; } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '当前型号已存在,请勿重复添加!'; echo Zend_Json::encode($result); exit; } } } } } } } echo Zend_Json::encode($result); exit; }
/** * @abstract 审核文件 * @return null */ public function reviewAction() { // 返回值数组 $result = array('success' => true, 'result' => true, 'info' => '审批成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $val = (object) $request; $files = new Dcc_Model_Files(); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); $formval = new Admin_Model_Formval(); $employee = new Hra_Model_Employee(); $upgrade = new Dcc_Model_Upgrade(); $id = $val->id; $remark = $val->remark; $pass = $val->review_result; $review_id = $val->review_id; $publish = false; // 获取文件信息 $filesData = $files->getOne($id); // 获取当前审核情况 // 如果record记录被删除或状态已改变,报错 $reviewWhere = "id = {$review_id}"; $reviewRows = $review->getList($reviewWhere, "files"); if (count($reviewRows) == 0) { $result['result'] = false; $result['info'] = "非法数据"; echo Zend_Json::encode($result); exit; } $reviewRow = $reviewRows[0]; if ($reviewRow['finish_flg'] != 0) { $result['result'] = false; $result['info'] = "数据状态已改变"; echo Zend_Json::encode($result); exit; } // 处理记录 $recordData = array("type" => "files", "table_name" => "oa_doc_files", "table_id" => $id, "handle_user" => $user, "handle_time" => $now, "action" => "审批", "result" => $pass == 1 ? "批准" : ($pass == 2 ? "拒绝" : "转审"), "ip" => $_SERVER['REMOTE_ADDR'], "remark" => $remark); // 增加记录 $record->insert($recordData); // 通过方式 $method = $reviewRow['method']; if ($pass == 1) { if ($method == 2) { // 任何一人处理即通过 $finish_flg = 1; $actual_user = $user; $finish_time = $now; } else { // 所有人都需要审核,检查是否所有人都已经审核 $plan_user = $reviewRow['plan_user']; $actual_user = $reviewRow['actual_user']; $actual_user = !$actual_user ? $user : $actual_user . "," . $user; // 检查计划审核人和实际审核人是否一致 // $plan_dept = $reviewRow['plan_dept']; // if ($plan_dept) { // // 获取部门所有人员 // $tmpUser = $employee->getAdapter()->query("select group_concat(id) as ids from oa_employee where dept_id in ( " . $plan_dept . ")")->fetchObject(); // if ($tmpUser->ids) { // if ($plan_user) // $plan_user .= ","; // $plan_user .= $tmpUser->ids; // } // } $planA = explode(',', $plan_user); $actualA = explode(',', $actual_user); $passFlg = true; foreach ($planA as $u) { if ($u && !in_array($u, $actualA)) { $passFlg = false; } } if ($passFlg) { $finish_flg = 1; $finish_time = $now; } else { $finish_flg = 0; $finish_time = null; } } // 审核情况 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); } else { if ($pass == 3) { // 转审 $finish_flg = 0; if ($method == 2) { // 处理方式为任意时,一个人转审之后其他人员也删除 $plan_user = str_replace('E', '', $val->transfer_id); } else { // 更改审核情况中的审核人 $plan_users = explode(',', $reviewRow['plan_user']); // 审核人不在审核人列表中,并且是管理员,则替换所有人 if (!in_array($user, $plan_users) && (Application_Model_User::checkPermissionByRoleName('文件管理员') || Application_Model_User::checkPermissionByRoleName('系统管理员'))) { $plan_users = array(str_replace('E', '', $val->transfer_id)); } else { for ($i = 0; $i < count($plan_users); $i++) { if ($plan_users[$i] == $user) { $plan_users[$i] = str_replace('E', '', $val->transfer_id); break; } } } $plan_user = implode(',', $plan_users); } // 审核情况 $reviewData = array("plan_user" => $plan_user, "method" => 1); } else { // 退回 $actual_user = null; $finish_time = null; $finish_flg = 0; // 退回选项 $return = $reviewRow['return']; if ($return == 2) { // 退到初始状态 // 需更新的审核记录: 所有 $reviewWhere = "type = 'files' and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { if ($return == 4) { // 退到本阶段开始 // 需更新的审核记录 $reviewWhere = "type = 'files' and finish_flg = 0 and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { if ($return == 3) { // 退到上一阶段 // 需更新的审核记录:最后一个finish_flg为1的数据和第一个finish_flg为0的数据 $last_1 = $first_0 = 0; foreach ($reviewRows as $r) { if ($r['finish_flg'] == 1) { $last_1 = $r['id']; } if ($r['finish_flg'] == 0 && $first_0 == null) { $first_0 = $r['id']; } } $reviewWhere = "id = {$last_1} or id = {$first_0}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { $fileWhere = "id = {$id}"; // 更新文件状态为退回 $fileData = array("state" => "Return"); // 退到初始状态 // 更新所有record的finish_flg为0 $reviewWhere = "type = 'files' and file_id = {$id}"; // 审核情况 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); } } } } } $filesRow = $files->getOne($reviewRow['file_id']); // 判断是否需要更新文件 // 如果所有record的记录的finish_flg 都为1,则发布 if ($finish_flg == 1 && $review->fetchAll("type = 'files' and finish_flg = 0 and file_id = {$id}")->count() == 1) { $publish = true; $obsolute = false; // 如果是多个文件同时归档,需拆分 if (strpos($filesRow['code'], ',') !== false) { $codes = explode(',', $filesRow['code']); $names = explode(',', $filesRow['name']); $file_ids = explode(',', $filesRow['file_ids']); $vers = explode(',', $filesRow['ver']); $description = explode('|', $filesRow['description']); $project_info = explode(',', $filesRow['project_info']); $ids = array(); $k = 0; for ($i = 0; $i < count($names); $i++) { $ids[] = ""; $length = substr_count($names[$i], '|'); for ($j = 0; $j <= $length; $j++) { if (isset($ids[$i]) && $ids[$i]) { $ids[$i] .= ','; } $ids[$i] .= $file_ids[$k++]; } } for ($i = 0; $i < count($codes); $i++) { // 更新第一条 if ($i == 0) { $data = array("state" => "Active", "code" => $codes[$i], "name" => $names[$i], "file_ids" => $ids[$i], "ver" => $vers[$i], "description" => $description[$i], "project_info" => $project_info[$i], "archive_time" => $now); try { $files->update($data, "id = {$id}"); // 如果是升版,登录升版信息 if ($vers[$i] > 1.0) { $upgradeTmpData = array("project_no" => $project_info[$i], "description" => $description[$i]); $upgrade->update($upgradeTmpData, "file_id=" . $id); } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $data = array("state" => "Active", "code" => $codes[$i], "ver" => $vers[$i], "tag" => $filesRow['tag'], "name" => $names[$i], "file_ids" => $ids[$i], "description" => $description[$i], "project_info" => $project_info[$i], "remark" => $filesRow['remark'], "create_time" => $filesRow['create_time'], "update_time" => $filesRow['update_time'], "create_user" => $filesRow['create_user'], "update_user" => $filesRow['update_user'], "archive_time" => $now, "add_flg" => $filesRow['add_flg']); try { $sid = $files->insert($data); // 拆分智能表单数据 if ($sid) { $sids[] = $sid; $whereMenu = "oa_doc_files_" . $id; $menus = $formval->getListByMenu($whereMenu); foreach ($menus as $menu) { $menuData = array("attrid" => $menu['attrid'], "value" => $menu['value'], "menu" => "oa_doc_files_" . $sid); $formval->insert($menuData); } // 如果是升版,登录升版信息 if ($vers[$i] > 1.0) { $obsolute = true; $upgradeRow = $upgrade->fetchAll("file_id = {$id}")->toArray(); foreach ($upgradeRow as $row) { $upgradeTmpData = array("file_id" => $sid, "reason" => $row['reason'], "reason_type" => $row['reason_type'], "project_no" => $project_info[$i], "description" => $description[$i], "create_user" => $row['create_user'], "create_time" => $row['create_time'], "update_user" => $row['update_user'], "update_time" => $row['update_time']); $upgrade->insert($upgradeTmpData); } } $recordRow = $record->fetchAll("type='files' and table_name='oa_doc_files' and table_id={$id}")->toArray(); foreach ($recordRow as $row) { // 增加记录 $recordTmpData = array("type" => $row['type'], "table_name" => $row['table_name'], "table_id" => $sid, "handle_user" => $row['handle_user'], "handle_time" => $row['handle_time'], "action" => $row['action'], "result" => $row['result'], "ip" => $row['ip'], "remark" => $row['remark']); $record->insert($recordTmpData); } } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } $fileData = array("state" => "Active", "archive_time" => $now); $fileWhere = "id = {$id}"; // 更新文件状态为已归档 $uploadData = array("archive" => 1, "archive_time" => $now); $upload = new Dcc_Model_Upload(); // 获取上传文件id $ids = $filesRow['file_ids']; $uploadWhere = "id in ({$ids})"; $upload->update($uploadData, $uploadWhere); // 更新旧版文件的状态为已作废 if (strpos($filesData['ver'], '1.0') === false || $obsolute) { if (isset($sids) && count($sids) > 0) { $obsoluteWhere = " id not in (" . implode(',', $sids) . ") and FIND_IN_SET(code, '" . $filesRow['code'] . "')"; } else { $obsoluteWhere = " FIND_IN_SET(code, '" . $filesRow['code'] . "')"; } $obsoluteData = array("state" => "Obsolete"); } } try { // 更新审核情况 $review->update($reviewData, $reviewWhere); if (isset($obsoluteData) && isset($obsoluteWhere)) { $files->update($obsoluteData, $obsoluteWhere); } // 更新文件 if (isset($fileWhere)) { $files->update($fileData, $fileWhere); } $this->operate("文件审批"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } // 邮件任务 // 文件提交者或更新人 $owner = $filesData['create_user']; if ($filesData['create_user'] != $filesData['update_user']) { $owner .= "," . $filesData['update_user']; } $dev = false; $type = "新文件"; if (stripos($filesData['ver'], '1.0') === false) { $dev = true; $type = "升版文件"; } $content = "<p><b>文件号:</b>" . $filesData['code'] . "</p><p><b>版本:</b>" . $filesData['ver'] . "</p><p><b>文件描述:</b>" . $filesData['description'] . "</p><p><b>备注:</b>" . $filesData['remark'] . "</p><p><b>申请人:</b>" . $filesData['creater'] . "</p><p><b>申请时间:</b>" . $filesData['create_time'] . "</p><p>请登录系统查看详情!</p>"; // 发邮件的情况: // 1、单站审核结束 $finish_flg = 1 && $publish = false if ($finish_flg == 1 && !$publish) { $subject = $type . "审批"; // $to = 下一站审核人 $current = $review->getFirstNoReview("files", $id); $to = $employee->getInfosByOneLine($current['plan_user']); // $cc = $employee->getInfosByOneLine($owner); $cc = $cc['email']; //$cc = ""; $content = "你有一个" . $type . "需要审批," . $content; } // 2、所有审核结束 $publish = true if ($publish) { $subject = $type . "发布"; $to = $employee->getInfosByOneLine($owner); $cc = $employee->getInfosByOneLine($record->getEmployeeIds($filesData['id'], 'files')); $cc = $cc['email']; // $cc = ""; $content .= "<p><b>审核记录:</b><br>" . str_replace(',', '<br>', $record->getHis($filesData['id'], 'files', 'oa_doc_files')) . "</p>"; $content = "你申请的" . $type . "已通过审批," . $content; } // 3、退回 isset($return) if (isset($return)) { $subject = $type . "退回"; $to = $employee->getInfosByOneLine($owner); $cc = ""; // 原审核人 if ($reviewRow['plan_user']) { $orgUser = $reviewRow['plan_user']; $cc = $employee->getInfosByOneLine($orgUser); $cc = $cc['email']; } $content = "你申请的" . $type . "已被退回,<p><b>退回原因:</b>" . $remark . "</p>" . $content; } // 4、转审 $pass == 3 if ($pass == 3) { $subject = $type . "转审"; $toUser = str_replace('E', '', $val->transfer_id); $to = $employee->getInfosByOneLine($toUser); // 原审核人 if ($reviewRow['plan_user']) { $orgUser = $reviewRow['plan_user']; $owner .= "," . $orgUser; } $cc = $employee->getInfosByOneLine($owner); $cc = $cc['email']; // $cc = ""; $content = "有新的" . $type . "被转移到你处审批:" . $content; } if (isset($subject)) { $mailData = array('type' => $type, 'subject' => $subject, 'to' => $to['email'], 'cc' => $cc, 'content' => $content, 'send_time' => $now, 'add_date' => $now); $mail = new Application_Model_Log_Mail(); try { $mailId = $mail->insert($mailData); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } if ($mailId) { $mail->send($mailId); } } echo Zend_Json::encode($result); exit; }
/** * 保存文件编码 */ public function savecodeAction() { $request = $this->getRequest(); $id = $request->getParam('id'); $code = $request->getParam('code'); if ($id && $code) { $code = strtoupper($code); // 检查文件编码是否已经存在 $codeModel = new Dcc_Model_Code(); $data = $codeModel->fetchAll("code = '{$code}'")->toArray(); if ($data && count($data) > 0) { $result['success'] = false; $result['info'] = "文件编码已存在!"; echo Zend_Json::encode($result); exit; } $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $data = array('code' => $code, 'state' => 'Active', 'update_user' => $user, 'update_time' => $now); $where = "id = " . $id; $codeData = $codeModel->getById($id); try { $codeModel->update($data, $where); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); // 处理记录 $recordData = array("type" => "code_apply", "table_name" => "oa_doc_code", "table_id" => $id, "handle_user" => $user, "handle_time" => $now, "action" => "审批", "result" => '批准', "ip" => $_SERVER['REMOTE_ADDR']); // 增加记录 $record->insert($recordData); // 审核情况 $reviewData = array("actual_user" => $user, "finish_time" => $now, "finish_flg" => 1); $review->update($reviewData, "type='code_apply' and file_id = " . $id); // 发邮件 $type = "文件编码申请"; $subject = "文件编码申请审核"; $user_name = $user_session->user_info['user_name']; $to = $codeModel->getAdapter()->query("select group_concat(email) as mail_to from oa_employee where id =(select create_user from oa_doc_code where id = {$id})")->fetchObject(); $content = "<p>你有一个文件编码申请已分配,文件号:{$code}</p>"; $content .= "<p><b>文件描述:</b>" . $codeData['description'] . "</p><p><b>备注:</b>" . $codeData['remark'] . "</p><p><b>申请时间:</b>" . $codeData['create_time'] . "</p><p>请登录系统查看详情!</p>"; $mailData = array('type' => $type, 'subject' => $subject, 'to' => $to->mail_to, 'content' => $content, 'send_time' => $now, 'add_date' => $now); $mail = new Application_Model_Log_Mail(); $mailId = $mail->insert($mailData); if ($mailId) { $mail->send($mailId); } $result['success'] = true; $result['info'] = '分配成功'; echo Zend_Json::encode($result); exit; } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } }
/** * @abstract 审核 * @return null */ public function reviewAction() { // 返回值数组 $result = array('success' => true, 'result' => true, 'info' => '审批成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $val = (object) $request; $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); $db = $employee->getAdapter(); $fadev = new Product_Model_Fadev(); $fa = new Product_Model_Fa(); $sondev = new Product_Model_Sondev(); $id = $val->id; $remark = $val->remark; $pass = $val->review_result; $type = $val->type; $publish = false; if ($type == 'new') { $table = "oa_product_bom_new"; $recordType = "bom"; $bomModel = new Product_Model_Newbom(); } else { if ($type == 'ECO') { $table = "oa_product_bom_eco"; $recordType = "ecobom"; $bomModel = new Product_Model_Updbom(); } else { if ($type == 'DEV') { $table = "oa_product_bom_dev"; $recordType = "devbom"; $bomModel = new Product_Model_Updbom(); } } } // 获取物料信息 $bomData = $bomModel->getOne($id); if (!$bomData) { $result['result'] = false; $result['info'] = "数据状态已改变"; echo Zend_Json::encode($result); exit; } $review_id = $bomData->review_id; // 获取当前审核情况 // 如果record记录被删除或状态已改变,报错 $reviewWhere = "id = {$review_id}"; $reviewRows = $review->getList($reviewWhere, $recordType); if (count($reviewRows) == 0 || !$type) { $result['result'] = false; $result['info'] = "非法数据"; echo Zend_Json::encode($result); exit; } $reviewRow = $reviewRows[0]; if ($reviewRow['finish_flg'] != 0) { $result['result'] = false; $result['info'] = "数据状态已改变"; echo Zend_Json::encode($result); exit; } $bomfaData = $fadev->fetchAll("type = '{$type}' and nid=" . $id)->toArray(); // 处理记录 $recordData = array("type" => $recordType, "table_name" => $table, "table_id" => $id, "handle_user" => $user, "handle_time" => $now, "action" => "审批", "result" => $pass == 1 ? "批准" : ($pass == 2 ? "拒绝" : "转审"), "ip" => $_SERVER['REMOTE_ADDR'], "remark" => $remark); // 增加记录 $record->insert($recordData); // 通过方式 $method = $reviewRow['method']; if ($pass == 1) { if ($method == 2) { // 任何一人处理即通过 $finish_flg = 1; $actual_user = $user; $finish_time = $now; } else { // 所有人都需要审核,检查是否所有人都已经审核 $plan_user = $reviewRow['plan_user']; $actual_user = $reviewRow['actual_user']; $actual_user = !$actual_user ? $user : $actual_user . "," . $user; // 检查计划审核人和实际审核人是否一致 if (strlen($plan_user) == strlen($actual_user)) { $finish_flg = 1; $finish_time = $now; } else { $finish_flg = 0; $finish_time = null; } } // 审核情况 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); } else { if ($pass == 3) { // 转审 $finish_flg = 0; if ($method == 2) { // 处理方式为任意时,一个人转审之后其他人员也删除 $plan_user = str_replace('E', '', $val->transfer_id); } else { // 更改审核情况中的审核人 $plan_users = explode(',', $reviewRow['plan_user']); for ($i = 0; $i < count($plan_users); $i++) { if ($plan_users[$i] == $user) { $plan_users[$i] = str_replace('E', '', $val->transfer_id); break; } } $plan_user = implode(',', $plan_users); } // 审核情况 $reviewData = array("plan_user" => $plan_user); } else { // 退回 $actual_user = null; $finish_time = null; $finish_flg = 0; // 退回选项 $return = $reviewRow['return']; if ($return == 2) { // 退到初始状态 // 需更新的审核记录: 所有 $reviewWhere = "type = '{$recordType}' and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { if ($return == 4) { // 退到本阶段开始 // 需更新的审核记录 $reviewWhere = "type = '{$recordType}' and finish_flg = 0 and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { if ($return == 3) { // 退到上一阶段 // 需更新的审核记录:最后一个finish_flg为1的数据和第一个finish_flg为0的数据 $last_1 = $first_0 = 0; foreach ($reviewRows as $r) { if ($r['finish_flg'] == 1) { $last_1 = $r['id']; } if ($r['finish_flg'] == 0 && $first_0 == null) { $first_0 = $r['id']; } } $reviewWhere = "id = {$last_1} or id = {$first_0}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { $fileWhere = "id = {$id}"; // 更新文件状态为退回 $mData = array("state" => "Return"); // 退到初始状态 // 更新所有record的finish_flg为0 $reviewWhere = "type = '{$recordType}' and file_id = {$id}"; // 审核情况 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); } } } } } // 如果所有record的记录的finish_flg 都为1,则发布 if ($finish_flg == 1 && $review->fetchAll("type = '{$recordType}' and finish_flg = 0 and file_id = {$id}")->count() == 1) { $publish = true; $mData = array("state" => "Active", "archive_time" => $now); $fileWhere = "id = {$id}"; $creater = $bomData['create_user']; // 如果是多个BOM,需要拆分 foreach ($bomfaData as $bomfa) { // 升版的情况,旧版作废 $facode = $bomfa['code']; if ($type != 'new') { $obsoleteData = array("state" => "Obsolete"); $obsoleteWhere = "code = '{$facode}' and recordkey != '" . $bomfa['recordkey'] . "'"; $fa->update($obsoleteData, $obsoleteWhere); } $recordkey = $bomfa['recordkey']; $sql = "insert into oa_product_bom_fa (nid, recordkey, id, code, project_no, bom_file, qty, state, ver, type, remark, create_user) select nid, recordkey, id, code, project_no, bom_file, qty, state, ver, type, remark, '{$creater}' from oa_product_bom_fa_dev where recordkey = {$recordkey}"; $db->query($sql); $sql = "insert into oa_product_bom_son (nid, recordkey, pid, id, code, qty, partposition, `replace`, remark) select nid, recordkey, pid, id, code, qty, partposition, `replace`, remark from oa_product_bom_son_dev where recordkey = {$recordkey}"; $db->query($sql); } } try { // 更新审核情况 $review->update($reviewData, $reviewWhere); // 更新BOM if (isset($fileWhere)) { $bomModel->update($mData, $fileWhere); } $this->operate("BOM审批"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } // 邮件任务 // 文件提交者或更新人 $owner = $bomData['create_user']; $dev = false; $boms = array(); foreach ($bomfaData as $fa) { if ($type == 'new') { $boms[] = $fa['code']; } else { $boms[] = $fa['code'] . " V" . $fa['ver']; } } $bomflg = "devbom"; if ($type == 'ECO') { $bomflg = "ecobom"; } if ($type == 'new') { $subject_type = "新BOM申请"; $content = "<b>BOM号:</b>" . implode(',', $boms) . "</p>" . "<p><b>描述:</b>" . $bomData['description'] . "</p>" . "<p><b>备注:</b>" . $bomData['remark'] . "</p>" . "<p><b>申请人:</b>" . $bomData['creater'] . "</p>" . "<p><b>申请时间:</b>" . $bomData['create_time'] . "</p>" . "<p>请登录系统查看详情!</p>"; } else { $subject_type = "BOM升版"; $reson_type = ""; if ($bomData['reason_type']) { $codemaster = new Admin_Model_Codemaster(); $mstData = $codemaster->getList("type=6 and code='" . $bomData['reason_type'] . "'"); if ($mstData && count($mstData) > 0) { $reson_type = $mstData[0]['text']; } } $content = "<b>BOM号:</b>" . implode(',', $boms) . "</p>" . "<p><b>升版类型:</b>" . $bomData['upd_type'] . "</p>" . "<p><b>升版原因分类:</b>" . $reson_type . "</p>" . "<p><b>升版原因:</b>" . $bomData['upd_reason'] . "</p>" . "<p><b>升版描述:</b>" . $bomData['description'] . "</p>" . "<p><b>备注:</b>" . $bomData['remark'] . "</p>" . "<p><b>申请人:</b>" . $bomData['creater'] . "</p>" . "<p><b>申请时间:</b>" . $bomData['create_time'] . "</p>" . "<p>请登录系统查看详情!</p>"; } $content = "<p><b>BOM号:</b>" . implode(',', $boms) . "</p><p><b>版本:</b>1.0</p><p><b>描述:</b>" . $bomData['description'] . "</p><p><b>备注:</b>" . $bomData['remark'] . "</p><p><b>申请人:</b>" . $bomData['creater'] . "</p><p><b>申请时间:</b>" . $bomData['create_time'] . "</p><p>请登录系统查看详情!</p>"; // 发邮件的情况: // 1、单站审核结束 $finish_flg = 1 && $publish = false if ($finish_flg == 1 && !$publish) { $subject = $subject_type . "审批"; // $to = 下一站审核人 $current = $review->getCurrent($bomflg, $id); $to = $employee->getInfosByOneLine($current['plan_user']); // $cc = $employee->getInfosByOneLine($owner); $cc = $cc['email']; $content = "你有一个" . $subject_type . "需要审批,{$content}"; } // 2、所有审核结束 $publish = true if ($publish) { $subject = $subject_type . "发布"; $to = $employee->getInfosByOneLine($owner); $cc = $employee->getInfosByOneLine($record->getEmployeeIds($bomData['id'], 'bom')); $cc = $cc['email']; $content .= "<hr><p><b>审核记录:</b><br>" . str_replace(',', '<br>', $record->getHis($bomData['id'], $bomflg)) . "</p>"; $content = "你申请的" . $subject_type . "已通过审批,{$content}"; } // 3、退回 isset($return) if (isset($return)) { $subject = $subject_type . "退回"; $to = $employee->getInfosByOneLine($owner); $cc = ""; // 原审核人 if ($reviewRow['plan_user']) { $orgUser = $reviewRow['plan_user']; $cc = $employee->getInfosByOneLine($orgUser); $cc = $cc['email']; } $content = "你申请的" . $subject_type . "已被退回,<p><b>退回原因:</b>" . $remark . "</p>,{$content}"; } // 4、转审 $pass == 3 if ($pass == 3) { $subject = $subject_type . "转审"; $toUser = str_replace('E', '', $val->transfer_id); $to = $employee->getInfosByOneLine($toUser); // 原审核人 if ($reviewRow['plan_user']) { $orgUser = $reviewRow['plan_user']; $owner .= "," . $orgUser; } $cc = $employee->getInfosByOneLine($owner); $cc = $cc['email']; $content = "有新的" . $subject_type . "被转移到你处审批,{$content}"; } if (isset($subject)) { $mailData = array('type' => $subject_type, 'subject' => $subject, 'to' => $to['email'], 'cc' => $cc, 'content' => $content, 'send_time' => $now, 'add_date' => $now); $mail = new Application_Model_Log_Mail(); try { $mailId = $mail->insert($mailData); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } if ($mailId) { $mail->send($mailId); } } echo Zend_Json::encode($result); exit; }