/** * 处理显示未归档但实际已归档的文件 */ private function archiveFile() { $upload = new Dcc_Model_Upload(); $files = (new Dcc_Model_Files())->getName(); $id_name = $upload->getName() . '.id'; $ids_name = $files . '.file_ids'; $join = array(array('type' => 5, 'table' => $files, 'condition' => "FIND_IN_SET({$id_name}, {$ids_name})")); $where = $upload->getName() . ".archive=0 and " . $upload->getName() . ".del=0 and " . $upload->getName() . ".private=0 and " . $files . ".state='Active'"; $data = $upload->getJoinList($where, $join); foreach ($data as $row) { $id = $row['id']; $upload->update(array('archive' => 1), array('id=?' => $id)); } }
/** * 获取文件编码及文件信息 */ 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 getlistAction() { $request = $this->getRequest()->getParams(); $limit = $request['limit']; $start = $request['start']; $desc = new Product_Model_Desc(); $descName = $desc->getName(); $whereSearch = "1=1"; $mytype = $this->getRequest()->getParam('mytype'); if ($mytype == 3) { $whereSearch = "{$descName}.state = 'Reviewing'"; } foreach ($request as $k => $v) { if ($v) { if ($k == 'search_tag') { $whereSearch .= " and (ifnull({$descName}.remark,'') like '%{$v}%' or ifnull({$descName}.manufacturers_before,'') like '%{$v}%' or ifnull({$descName}.manufacturers_after,'') like '%{$v}%' or ifnull({$descName}.desc_before,'') like '%{$v}%' or ifnull({$descName}.desc_after,'') like '%{$v}%')"; } else { $col = str_replace('search_', '', $k); if ($col != $k) { // 查询条件 $whereSearch .= " and ifnull({$descName}." . $col . ",'') like '%" . $v . "%'"; } } } } $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $materiel = new Product_Model_Materiel(); $type = new Product_Model_Type(); $record = new Dcc_Model_Record(); $flow = new Admin_Model_Flow(); $step = new Admin_Model_Step(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); // 查询条件 // 供应商 $supply = new Product_Model_Bpartner(); $supplyData = $supply->getJoinList(array(), array(), array('id', 'code', 'cname', 'ename')); // 审核中 $reviewingData = $review->getJoinList("finish_flg = 0 and type = 'materiel_desc' and (actual_user is null or !(FIND_IN_SET({$user},actual_user))) and (FIND_IN_SET({$user}, plan_user))", array(), array('table_id')); $reviewingIds = array(); foreach ($reviewingData as $r) { if (!in_array($r['id'], $reviewingIds)) { $reviewingIds[] = $r['id']; } } // 审核过 $reviewedData = $review->getJoinList("finish_flg = 1 and type = 'materiel_desc' and (FIND_IN_SET({$user},actual_user))", array(), array('table_id')); $reviewedIds = array(); foreach ($reviewedData as $r) { if (!in_array($r['id'], $reviewedIds)) { $reviewedIds[] = $r['id']; } } $join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user')); $myType = ""; if (isset($request['mytype'])) { $myType = $request['mytype']; } if ($myType == 1) { $whereSearch .= " and {$descName}.create_user = {$user}"; } else { if ($myType == 2 && count($reviewedIds) > 0) { $whereSearch .= " and {$descName}.id in (" . implode(',', $reviewedIds) . ")"; } else { if ($myType == 3 && count($reviewingIds) > 0) { $whereSearch .= " and {$descName}.id in (" . implode(',', $reviewingIds) . ")"; } else { // $whereSearch .= " and ($descName.create_user = $user "; $whereSearch .= " and (1=1 "; if (count($reviewedIds) > 0) { $whereSearch .= " or {$descName}.id in (" . implode(',', $reviewedIds) . ")"; } if (count($reviewingIds) > 0) { $whereSearch .= " or {$descName}.id in (" . implode(',', $reviewingIds) . ")"; } $whereSearch .= ")"; } } } $total = $desc->getJoinCount($whereSearch); if ($total > 0) { $join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user', 'cols' => array('creater' => 'cname'))); $data = $desc->getJoinList($whereSearch, $join, null, array($desc->getName() . '.state desc', $desc->getName() . '.create_time desc'), $start, $limit); } else { $data = array(); } $fileIds = array(); // 获取物料数据 for ($i = 0; $i < count($data); $i++) { $mytype = 2; if ($data[$i]['create_user'] == $user) { $mytype = 1; } if (($typeId = $data[$i]['type_before']) != '') { $typeName = $type->getTypeByConnect($typeId, ''); $data[$i]['type_name'] = $typeName; } $data[$i]['create_time'] = strtotime($data[$i]['create_time']); $data[$i]['archive_time'] = strtotime($data[$i]['archive_time']); // files if ($data[$i]['data_file_id_before'] && !in_array($data[$i]['data_file_id_before'], $fileIds)) { $fileIds[] = $data[$i]['data_file_id_before']; } if ($data[$i]['data_file_id_after'] && !in_array($data[$i]['data_file_id_after'], $fileIds)) { $fileIds[] = $data[$i]['data_file_id_after']; } if ($data[$i]['tsr_id_before'] && !in_array($data[$i]['tsr_id_before'], $fileIds)) { $fileIds[] = $data[$i]['tsr_id_before']; } if ($data[$i]['tsr_id_after'] && !in_array($data[$i]['tsr_id_after'], $fileIds)) { $fileIds[] = $data[$i]['tsr_id_after']; } if ($data[$i]['first_report_id_before'] && !in_array($data[$i]['first_report_id_before'], $fileIds)) { $fileIds[] = $data[$i]['first_report_id_before']; } if ($data[$i]['first_report_id_after'] && !in_array($data[$i]['first_report_id_after'], $fileIds)) { $fileIds[] = $data[$i]['first_report_id_after']; } // 增加审核状态 $reviewState = ""; $step_name = ""; if ($data[$i]['state'] == 'Active') { $reviewState = "已归档"; } else { if ($data[$i]['state'] == 'Reviewing') { // 查询当前审核状态 // 查询所有审核阶段 $reviewRows = $review->getList("file_id = " . $data[$i]['id'], "materiel_desc"); if (count($reviewRows) > 0) { $first = true; foreach ($reviewRows as $row) { if ($row['finish_flg'] == 1) { if ($step_name) { $step_name .= "->"; } $step_name .= $row['step_name']; } else { if ($step_name) { $step_name .= "->"; } // 第一条未审核记录就是当前待审核记录 if ($first) { $first = false; $step_name .= "<b>" . $row['step_name'] . "</b>"; $reviewRow = $row; $actual_user = explode(',', $reviewRow['actual_user']); $planUser = $reviewRow['plan_user']; $method = $reviewRow['method']; $plan_user = explode(',', $planUser); $diff = array_diff($plan_user, $actual_user); foreach ($diff as $u) { if (!$u) { continue; } if ($u == $user) { $mytype = 3; } $e = $employee->fetchRow("id = {$u}"); if ($reviewState) { $reviewState .= ", "; } $reviewState .= $e['cname'] . ":未审核"; } foreach ($actual_user as $u) { if (!$u) { continue; } $e = $employee->fetchRow("id = {$u}"); if ($reviewState) { $reviewState .= ", "; } $reviewState .= $e['cname'] . ":已审核"; } } else { $step_name .= $row['step_name']; } } } } } else { if ($data[$i]['state'] == 'Obsolete') { $reviewState = "已作废"; } else { if ($data[$i]['state'] == 'Return') { $reviewState = "退回"; } else { $reviewState = $data[$i]['state']; } } } } $data[$i]['step_name'] = $step_name; $data[$i]['review_state'] = $reviewState; $data[$i]['mytype'] = $mytype; $data[$i]['record'] = $record->getHis($data[$i]['id'], 'materiel_desc'); } // get file names if (count($fileIds) > 0) { $upload = new Dcc_Model_Upload(); $fileData = $upload->getJoinList("id in (" . implode(',', $fileIds) . ")", array(), array('id', 'name')); $files = array(); foreach ($fileData as $f) { $files[$f['id']] = $f['name']; } // data rebuild for ($i = 0; $i < count($data); $i++) { if ($data[$i]['data_file_id_before'] && in_array($data[$i]['data_file_id_before'], $fileIds)) { $data[$i]['data_file_before'] = $files[$data[$i]['data_file_id_before']]; } if ($data[$i]['data_file_id_after'] && in_array($data[$i]['data_file_id_after'], $fileIds)) { $data[$i]['data_file_after'] = $files[$data[$i]['data_file_id_after']]; } if ($data[$i]['tsr_id_before'] && in_array($data[$i]['tsr_id_before'], $fileIds)) { $data[$i]['tsr_before'] = $files[$data[$i]['tsr_id_before']]; } if ($data[$i]['tsr_id_after'] && in_array($data[$i]['tsr_id_after'], $fileIds)) { $data[$i]['tsr_after'] = $files[$data[$i]['tsr_id_after']]; } if ($data[$i]['first_report_id_before'] && in_array($data[$i]['first_report_id_before'], $fileIds)) { $data[$i]['first_report_before'] = $files[$data[$i]['first_report_id_before']]; } if ($data[$i]['first_report_id_after'] && in_array($data[$i]['first_report_id_after'], $fileIds)) { $data[$i]['first_report_after'] = $files[$data[$i]['first_report_id_after']]; } } } // 转为json格式并输出 $resutl = array("totalCount" => $total, "topics" => $data); echo Zend_Json::encode($resutl); 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; } }
/** * 文件查看 */ public function viewAction() { // 返回值数组 $result = array('convert' => false, 'success' => true); // 获取参数 $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']; $id = $request['id']; // 根据id获取在线浏览路径 $upload = new Dcc_Model_Upload(); $record = new Dcc_Model_Record(); $file = $upload->fetchRow("id = '{$id}'"); if (count($file) > 0 && $file->view_path && is_file($file->view_path)) { // swf文件已经存在,直接返回浏览即可 $result['convert'] = true; $viewPath = $file->view_path; } else { // 文件转换 TODO $convertObj = new Dcc_Model_FileCovert(); $viewPath = ""; if ($file->path && is_file($file->path) && $convertObj->isSupport($file->type)) { // 此处应该使用绝对路径 $path = str_replace("../", "/evolve/", $file->path); $name = substr($path, strripos($path, "/") + 1); $path = str_replace($name, "", $path); $absolutepath = $_SERVER['DOCUMENT_ROOT'] . $path; $viewPath = $convertObj->createPreview($absolutepath, $name); if (!$viewPath) { $result['convert'] = false; } else { // 转换回相对路径 $viewPath = str_replace($_SERVER['DOCUMENT_ROOT'] . "/evolve", "..", $viewPath); $result['convert'] = true; $fileData = array('view_path' => $viewPath); try { $upload->update($fileData, "id=" . $file->id); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } if ($result['convert'] == true) { $data = array('type' => "files", 'table_name' => "oa_doc_upload", 'table_id' => $file->id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "在线浏览", 'ip' => $_SERVER['REMOTE_ADDR']); try { $record->insert($data); $this->operate("在线浏览"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } $result['result'] = true; $result['viewpath'] = $viewPath; echo Zend_Json::encode($result); exit; } else { // 文件不存在 // 返回值数组 $result['result'] = false; $result['viewpath'] = ''; echo Zend_Json::encode($result); exit; } }
/** * 文件发送 */ public function sendAction() { // 返回值数组 $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; $upload = new Dcc_Model_Upload(); $doc_ids = ""; $doc_names = ""; if ($val->exfile_ids) { // 根据文件id获取归档文件id $tmp = $upload->getAdapter()->query("select group_concat(id) as doc_ids, group_concat(code) as doc_names from oa_doc_files where (state = 'Active') and name != '' and file_ids in ( " . $val->exfile_ids . ")")->fetchObject(); $doc_ids = $tmp->doc_ids; $doc_names = $tmp->doc_names; $row = $upload->getFileByIds($val->exfile_ids); $names = $row['name']; $paths = $row['path']; } if ($paths) { foreach (explode(',', $paths) as $path) { if (!is_file($path)) { $result['result'] = false; $result['info'] = "文件不存在"; echo Zend_Json::encode($result); exit; } } $employee = new Hra_Model_Employee(); $to = array(); if ($val->to_id) { $toUser = str_replace('E', '', $val->to_id); $to = $employee->getInfosByOneLine($toUser); $to = explode(',', $to['email']); } if (isset($val->custom_linkman) && $val->custom_linkman) { $to[] = $val->custom_linkman; } if (isset($val->supply_linkman) && $val->supply_linkman) { $to[] = $val->supply_linkman; } $dept = ''; if (isset($val->innerdept_id) && $val->innerdept_id) { $dept = str_replace('D', '', $val->innerdept_id); $sql = "select group_concat(email) as email from oa_employee where dept_id in ({$dept})"; $data = $employee->getAdapter()->query($sql)->fetchObject(); if ($data && $data->email) { $toemail = $data->email; foreach (explode(',', $toemail) as $t) { $to[] = $t; } } } $cc = array(); if ($val->cc_id) { $ccUser = str_replace('E', '', $val->cc_id); $cc = $employee->getInfosByOneLine($ccUser); $cc = explode(',', $cc['email']); } $u = $employee->getInfosByOneLine($user); $cc[] = $u->email; if (isset($val->personal_linkman) && $val->personal_linkman) { foreach (explode(',', $val->personal_linkman) as $m) { if (strpos($m, '@') != false) { $to[] = $m; } } } $mailData = array('type' => $val->sendtype == '外发' ? "文件外发" : "文件发放", 'subject' => $val->subject, 'to' => implode(',', $to), 'cc' => implode(',', $cc), 'content' => $val->content, 'attachment_name' => $names, 'attachment_path' => $paths, 'send_time' => $now, 'add_date' => $now); $mail = new Application_Model_Log_Mail(); try { $mailId = $mail->insert($mailData); if ($mailId) { $sendResult = $mail->send($mailId, 0, $val->to_name, $val->footer, true); } $error_info = ""; $success = false; if ($sendResult) { ${$error_info} = $sendResult['info']; $success = $sendResult['success']; } $result['result'] = $success; $result['info'] = ${$error_info}; if (isset($val->out_sendtype)) { $outsend = $val->out_sendtype; } else { $outsend = ""; } if (isset($val->out_custom)) { $partner = $val->out_custom; } else { if (isset($val->out_supply)) { $partner = $val->out_supply; } else { $partner = ''; } } if (isset($val->custom_linkman)) { $linkman = $val->custom_linkman; } else { if (isset($val->supply_linkman)) { $linkman = $val->supply_linkman; } else { $linkman = ''; } } // 获取发放编号 $code = $this->getSendCode(); // 记录 $to = $val->to; if (isset($val->personal_linkman) && $val->personal_linkman) { $to .= $val->personal_linkman; } $data = array('code' => $code, 'dept' => $dept, 'partner' => $partner, 'linkman' => $linkman, 'sendtype' => $val->sendtype, 'to_name' => $val->to_name, 'footer' => $val->footer, 'remark' => $val->remark, 'outsendtype' => $outsend, 'to' => $to, 'cc' => $val->cc, 'subject' => $val->subject, 'content' => $val->content, 'doc_ids' => $doc_ids, 'doc_names' => $doc_names, 'file_ids' => $val->exfile_ids, 'file_names' => $names, 'error_info' => $error_info, 'result' => $success, 'handle_time' => $now, 'handle_user' => $user); $send = new Dcc_Model_Send(); $send->insert($data); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } if (!$result['info']) { $result['info'] = "发送成功"; } echo Zend_Json::encode($result); exit; } else { $result['result'] = false; $result['info'] = "文件不存在"; 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; $materiel = new Product_Model_Materiel(); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); $employee = new Hra_Model_Employee(); $id = $val->id; $remark = $val->remark1; $pass = $val->review_result; $publish = false; if (isset($val->code) && $val->code != '') { $code = $val->code; // 检查code是否重复 if ($materiel->fetchAll("id != {$id} and code = '" . $code . "'")->count() > 0) { $result['result'] = false; $result['info'] = "代码“" . $code . "”已经存在"; echo Zend_Json::encode($result); exit; } } if (isset($val->ids) && $val->ids && strpos($val->ids, ',') !== false) { // 多个 $ids = explode(',', $val->ids); } else { $ids = array($id); } $newCodes = array(); foreach ($ids as $id) { // 获取物料信息 $materielData = $materiel->getOne($id); if (!$materielData) { $result['result'] = false; $result['info'] = "数据状态已改变"; echo Zend_Json::encode($result); exit; } $review_id = $materielData->review_id; // 获取当前审核情况 // 如果record记录被删除或状态已改变,报错 $reviewWhere = "id = {$review_id}"; $reviewRows = $review->getList($reviewWhere, "materiel"); 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" => "materiel", "table_name" => "oa_product_materiel", "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; // 检查计划审核人和实际审核人是否一致 $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 = 'materiel' and file_id = {$id}"; // 审核情况更新数据 $reviewData = array("actual_user" => $actual_user, "finish_time" => $finish_time, "finish_flg" => $finish_flg); // 文件状态不更新 } else { if ($return == 4) { // 退到本阶段开始 // 需更新的审核记录 $reviewWhere = "type = 'materiel' 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 = 'materiel' 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 = 'materiel' and finish_flg = 0 and file_id = {$id}")->count() == 1) { $publish = true; if (!isset($code) || !$code) { // 自动生成物料编码 $code = $this->getCode($materielData->type, $materielData->project_no); if (!$code) { $result['result'] = false; $result['info'] = "生成物料编码失败"; echo Zend_Json::encode($result); exit; } else { if (count($ids) > 1) { $newCodes[] = $code; $result['info'] = "审批成功"; } else { $result['info'] = "审批成功,系统分配物料号:{$code}"; } } } $mData = array("state" => "Active", "code" => $code, "archive_time" => $now); $fileWhere = "id = {$id}"; // 如果有ds等文件,这些文件也设置为已归档 $data_file_id = $materielData->data_file_id; $tsr_id = $materielData->tsr_id; $first_report_id = $materielData->first_report_id; if ($data_file_id || $tsr_id || $first_report_id) { $uploadUpdWhere = " archive = 0 and (1=0 "; if ($data_file_id) { $uploadUpdWhere .= " or id = " . $data_file_id; } if ($tsr_id) { $uploadUpdWhere .= " or id = " . $tsr_id; } if ($first_report_id) { $uploadUpdWhere .= " or id = " . $first_report_id; } $uploadUpdWhere .= ")"; $uploadUpdData = array('archive' => 1, 'archive_time' => $now); } } try { // 更新审核情况 $review->update($reviewData, $reviewWhere); // 更新文件 if (isset($fileWhere)) { $materiel->update($mData, $fileWhere); } // 更新上传文件 if (isset($uploadUpdData)) { $upload = new Dcc_Model_Upload(); $upload->update($uploadUpdData, $uploadUpdWhere); } $this->operate("物料评审"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } // 邮件任务 // 文件提交者或更新人 $owner = $materielData['create_user']; $dev = false; $type = "物料申请"; // 发邮件的情况: // 1、单站审核结束 $finish_flg = 1 && $publish = false if ($finish_flg == 1 && !$publish) { $subject = $type . "审批"; // $to = 下一站审核人 $current = $review->getFirstNoReview("materiel", $id); $to = $employee->getInfosByOneLine($current['plan_user']); // $cc = $employee->getInfosByOneLine($owner); $cc = $cc['email']; $content = "你有一个" . $type . "需要审批,请登录系统查看详情!"; } // 2、所有审核结束 $publish = true if ($publish) { $subject = $type . "发布"; $to = $employee->getInfosByOneLine($owner); $cc = $employee->getInfosByOneLine($record->getEmployeeIds($materielData['id'], 'materiel')); $cc = $cc['email']; $config = new Zend_Config_Ini(CONFIGS_PATH . '/application.ini', 'production'); if (isset($config) && isset($config->email->apply->publish)) { $to_plus = $config->email->apply->publish; if ($to_plus) { if ($cc) { $cc .= "," . $to_plus; } else { $cc = $to_plus; } } } // $cc = ""; $his = "<p><b>审核记录:</b><br>" . str_replace(',', '<br>', $record->getHis($materielData['id'], 'materiel')) . "</p>"; $content = "你申请的" . $type . "已通过审批。<p><b>物料编码:</b>" . $code . "</p><p><b>类别:</b>" . $this->getTypeByConnect($materielData['type'], '') . "</p><p><b>名称:</b>" . $materielData['name'] . "</p><p><b>描述:</b>" . $materielData['description'] . "</p><p><b>申请人:</b>" . $materielData['creater'] . "</p><p><b>申请时间:</b>" . $materielData['create_time'] . "</p>" . $his . "<p>请登录系统查看详情!</p>"; } // 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>,请登录系统查看详情!"; } // 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']; $content = "有新的" . $type . "被转移到你处审批,请登录系统查看详情!"; } 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); } } $code = null; } if (count($newCodes) > 0) { $result['info'] .= ',系统分配物料号分别为:' . implode(',', $newCodes); } echo Zend_Json::encode($result); exit; }
/** * 文件下载 */ public function downloadAction() { // 返回值数组 $result = array('success' => true); // 获取参数 $request = $this->getRequest()->getParams(); $id = $request['id']; $source = isset($request['source']) ? $request['source'] : ''; $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $upload = new Dcc_Model_Upload(); $record = new Dcc_Model_Record(); $file = $upload->getOne($id); $path = $file['path']; $name = $file['name']; if ($source == 'edit') { $source = '日常维护'; } else { if ($source == 'files') { $source = '文件检索'; } else { if ($source == 'mine') { $source = '我的文档'; } } } if (count($file) > 0 && $path) { $data = array('type' => "files", 'table_name' => "oa_doc_upload", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "下载", 'ip' => $_SERVER['REMOTE_ADDR'], 'source' => $source); try { $record->insert($data); $this->operate("下载"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } $filename = $name; header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: can-cache"); header("Content-type: application/octet-stream"); $ua = $_SERVER['HTTP_USER_AGENT']; if (preg_match('/MSIE/', $ua)) { header("Content-disposition: attachment;filename=\"" . urlencode($filename) . "\""); } elseif (preg_match('/FireFox/', $ua)) { header("Content-disposition: attachment;filename*=\"utf-8''" . $filename . "\""); } else { header("Content-disposition: attachment;filename=\"" . $filename . "\""); } readfile($path); exit; } else { // 文件不存在 // 返回值数组 $result['result'] = false; $result['info'] = '文件不存在'; 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; }