public function getcodemasterAction()
{
$request = $this->getRequest()->getParams();
if ($request['type'] == 'passrule') {
$type = 3;
} else {
if ($request['type'] == 'returnmethod') {
$type = 2;
}
}
if ($type) {
$where = "type=" . $type;
$codemaster = new Admin_Model_Codemaster();
$data = $codemaster->getList($where);
// 转为json格式并输出
echo Zend_Json::encode($data);
}
exit;
}
/**
* @abstract 获取文件JSON数据
* @return null
*/
public function getfilesAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$where = " (t1.state = 'Active' or t1.state='Obsolete')";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$cols = array("t1.project_info", "t1.code", "t1.name", "t1.description", "t1.remark", "t2.cname", "t7.model_standard", "t7.model_internal");
$arr = preg_split('/\\s+/', trim($v));
for ($i = 0; $i < count($arr); $i++) {
$tmp = array();
foreach ($cols as $c) {
$tmp[] = "ifnull({$c},'')";
}
$arr[$i] = "concat(" . implode(',', $tmp) . ") like '%" . $arr[$i] . "%'";
}
$where .= " and " . join(' AND ', $arr);
// $where .= " and (ifnull(t1.project_info,'') like '%$v%' or ifnull(t1.code,'') like '%$v%' or ifnull(t1.name,'') like '%$v%' or ifnull(t1.description,'') like '%$v%' or ifnull(t1.remark,'') like '%$v%' or ifnull(t2.cname,'') like '%$v%' or ifnull(t7.model_standard,'') like '%$v%' or ifnull(t7.model_internal,'') like '%$v%')";
} else {
if ("search_archive_date_from" == $k && $v) {
$where .= " and t1.archive_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_category" == $k && $v) {
$where .= " and t5.category = '{$v}'";
} else {
if ("search_archive_date_to" == $k && $v) {
$where .= " and t1.archive_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$where .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
$files = new Dcc_Model_Files();
$codemaster = new Admin_Model_Codemaster();
$data = $files->getFilesList($where, $start, $limit);
$tmp = $files->getAdapter()->query("select count(*) as sum from oa_doc_files t1 left join oa_employee t2 on t1.create_user = t2.id left join oa_doc_code t4 on t1.code = t4.code left join oa_doc_type t5 on t4.prefix = t5.id left join oa_product_catalog t7 on t4.project_no = t7.id where {$where}")->fetchObject();
$count = $tmp->sum;
// $count = $files->getCount($where, $start, $limit);
$totalCount = $count;
for ($i = 0; $i < count($data); $i++) {
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['update_time'] = strtotime($data[$i]['update_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
$data[$i]['codever'] = $data[$i]['code'] . 'V' . $data[$i]['ver'];
$data[$i]['description'] = $data[$i]['code_description'];
if ($data[$i]['reason_type']) {
$masterData = $codemaster->fetchRow("type = 5 and code = '" . $data[$i]['reason_type'] . "'");
$reason_type_name = $masterData->text;
$data[$i]['reason_type_name'] = $reason_type_name;
}
}
$resutl = array("totalCount" => $totalCount, "topics" => $data);
echo Zend_Json::encode($resutl);
exit;
}
/**
* @abstract 获取文件JSON数据
* @return null
*/
public function getfilesAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$where = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$cols = array("t1.project_info", "t1.code", "t1.name", "t1.description", "t1.remark", "t2.cname", "t7.model_standard", "t7.model_internal");
$arr = preg_split('/\\s+/', trim($v));
for ($i = 0; $i < count($arr); $i++) {
$tmp = array();
foreach ($cols as $c) {
$tmp[] = "ifnull({$c},'')";
}
$arr[$i] = "concat(" . implode(',', $tmp) . ") like '%" . $arr[$i] . "%'";
}
$where .= " and " . join(' AND ', $arr);
// $where .= " and (ifnull(t1.project_info,'') like '%$v%' or ifnull(t1.code,'') like '%$v%' or ifnull(t1.name,'') like '%$v%' or ifnull(t1.description,'') like '%$v%' or ifnull(t1.remark,'') like '%$v%' or ifnull(t2.cname,'') like '%$v%')";
} else {
if ("search_category" == $k && $v) {
$where .= " and t5.category = '{$v}'";
} else {
if ("search_archive_date_from" == $k && $v) {
$where .= " and t1.archive_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_archive_date_to" == $k && $v) {
$where .= " and t1.archive_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$where .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
$files = new Dcc_Model_Files();
$record = new Dcc_Model_Record();
$flow = new Admin_Model_Flow();
$step = new Admin_Model_Step();
$share = new Dcc_Model_Share();
$type = new Dcc_Model_Type();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
$dept = new Hra_Model_Dept();
$codemaster = new Admin_Model_Codemaster();
if (isset($request['method'])) {
$data = $files->getFilesListForEdit($where, $start, $limit);
$count = $files->getCountForEdit($where, $start, $limit);
$totalCount = $count;
} else {
$data = $files->getFilesList($where . " and (t1.state = 'Active' or t1.state = 'Obsolete')", $start, $limit);
$count = $files->getCount($where . " and (t1.state = 'Active' or t1.state = 'Obsolete')", $start, $limit);
$totalCount = $count;
}
for ($i = 0; $i < count($data); $i++) {
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['update_time'] = strtotime($data[$i]['update_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
$data[$i]['codever'] = $data[$i]['code'] . ' V' . $data[$i]['ver'];
$data[$i]['send_require'] = $data[$i]['send_require'] == 1 ? true : false;
$data[$i]['description'] = $data[$i]['code_description'];
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已发布";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], "files");
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_dept = $reviewRow['plan_dept'];
$depts = array();
$plan_user = explode(',', $planUser);
$diff = array_diff($plan_user, $actual_user);
foreach ($diff as $u) {
if (!$u) {
continue;
}
$e = $employee->fetchRow("id = {$u}");
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $e['cname'] . "：未审核";
}
foreach ($depts as $d) {
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $d . "：未审核";
}
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;
if ($data[$i]['reason_type']) {
$masterData = $codemaster->fetchRow("type = 5 and code = '" . $data[$i]['reason_type'] . "'");
$reason_type_name = $masterData->text;
$data[$i]['reason_type_name'] = $reason_type_name;
}
}
$resutl = array("totalCount" => $totalCount, "topics" => $data);
echo Zend_Json::encode($resutl);
exit;
}
public function getreasonAction()
{
$where = "type=6";
$codemaster = new Admin_Model_Codemaster();
$data = $codemaster->getList($where);
// 转为json格式并输出
echo Zend_Json::encode($data);
exit;
}
public function getcodemasterAction()
{
$request = $this->getRequest()->getParams();
if ($request['type'] == 'category') {
$type = 4;
}
if ($type) {
$where = "type=" . $type;
$codemaster = new Admin_Model_Codemaster();
$data = $codemaster->getList($where);
// 转为json格式并输出
echo Zend_Json::encode($data);
}
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;
}
