/**
* @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 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 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;
}
public function getlistAction()
{
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$fa = new Product_Model_Fa();
$db = $fa->getAdapter();
$whereSearch = "1=1";
// if(isset($request['search_state']) && $request['search_state'] != 'Active') {
// $whereSearch = " t1.state != 'Active'";
// }
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_key') {
$whereSearch .= " and (ifnull(t1.remark,'') like '%{$v}%' or ifnull(t3.cname,'') like '%{$v}%' or ifnull(t1.description,'') like '%{$v}%')";
} else {
if ("search_fa" == $k && $v) {
$nid = "";
$faData = $db->query("select group_concat(nid) as nid from oa_product_bom_fa_dev where code like '%{$v}%'")->fetchObject();
if ($faData && $faData->nid) {
$nid = $faData->nid;
}
if (!$nid) {
$nid = "0";
}
$whereSearch .= " and t1.id in ({$nid})";
} else {
if ("search_son" == $k && $v) {
$nid = "";
$sonData = $db->query("select group_concat(nid) as nid from oa_product_bom_son_dev where code like '%{$v}%'")->fetchObject();
if ($sonData && $sonData->nid) {
$nid = $sonData->nid;
}
if (!$nid) {
$nid = "0";
}
$whereSearch .= " and t1.id in ({$nid})";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $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();
$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();
$updbom = new Product_Model_Updbom();
// 查询条件
// 类型
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
// 获取物料数据
$data = $updbom->getMy($myType, $whereSearch, $user, $start, $limit);
$totalCount = $updbom->getMyCount($myType, $whereSearch, $user);
for ($i = 0; $i < count($data); $i++) {
$upd_type = $data[$i]['upd_type'];
if ($upd_type == 'ECO') {
$bomflg = "ecobom";
} else {
if ($upd_type == 'DEV') {
$bomflg = "devbom";
}
}
$mytype = 2;
if ($data[$i]['create_user'] == $user) {
$mytype = 1;
}
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
// 获取BOM
$table = "oa_product_bom_fa_dev";
$bomData = $updbom->getAdapter()->query("select group_concat(concat(code,' V', ver)) as bom from {$table} where type='{$upd_type}' and nid = " . $data[$i]['id'])->fetchObject();
$data[$i]['bom'] = $bomData->bom;
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已归档";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], $bomflg);
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 {
if ($data[$i]['state'] == 'Draft') {
$reviewState = "草稿";
} else {
$reviewState = $data[$i]['state'];
}
}
}
}
}
$data[$i]['step_name'] = $step_name;
$data[$i]['review_state'] = $reviewState;
$data[$i]['mytype'] = $mytype;
$data[$i]['replacea'] = $data[$i]['replace'];
$data[$i]['record'] = $record->getHis($data[$i]['id'], $bomflg);
}
// 排序
$dataT3 = array();
$dataT2 = array();
$dataT1 = array();
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['mytype'] == 3) {
$dataT3[] = $data[$i];
} else {
if ($data[$i]['mytype'] == 2) {
$dataT2[] = $data[$i];
} else {
$dataT1[] = $data[$i];
}
}
}
$data = array_merge($dataT3, $dataT1, $dataT2);
$resutl = array("totalCount" => $totalCount, "topics" => $data);
// 转为json格式并输出
echo Zend_Json::encode($resutl);
exit;
}
public function reviewAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '审核成功');
$request = $this->getRequest()->getParams();
$review_type = isset($request['review_type']) ? $request['review_type'] : null;
$review_step = isset($request['review_step']) ? $request['review_step'] : null;
$review_id = isset($request['review_id']) ? $request['review_id'] : null;
$review_operate = isset($request['review_operate']) ? $request['review_operate'] : null;
$review_remark = isset($request['review_remark']) ? $request['review_remark'] : null;
if ($review_id && $review_type) {
$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;
$user = new Application_Model_User();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
if ($review_type == 'vacation') {
$vacation = new Hra_Model_Attendance_Vacation();
$vacationData = $vacation->getData(null, $review_id);
if ($review_operate == 'no') {
// 拒绝
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']';
$timeType = 'review_time_1';
if ($vacationData['review_time_1']) {
$timeType = 'review_time_2';
}
$data = array('state' => 1, $timeType => date('Y-m-d H:i:s'), 'review_info' => $vacationData['review_info'] . '<br>' . $review_info);
$vacation->update($data, "id = " . $review_id);
// 删除当前申请的审核配置
$review->delete("type = 'attendance_vacation' and file_id = " . $review_id);
// 调休假申请被拒绝后：还原对调加班时间的调休状态
if ($vacationData['type'] == 8) {
$overtimeIdArr = explode(',', $vacationData['exchange_overtime_ids']);
$overtime = new Hra_Model_Attendance_Overtime();
foreach ($overtimeIdArr as $overtimeId) {
$overtime->update(array('exchange' => 0), "id = " . $overtimeId);
}
}
// 发送邮件通知申请人
$reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>';
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $vacationData['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><a style="color:#008B00;font-weight: bold;">' . $vacationData['apply_user_name'] . '</a></p>
<p><b>请假类别：</b>' . $vacationData['type_name'] . '</p>
<p><b>请假时间：</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['time_from'] . '</a> 至 <a style="color:#008B00;font-weight: bold;">' . $vacationData['time_to'] . '</a></p>
<p><b>代理人：</b>' . $vacationData['agent_name'] . '</p>
<p><b>事由：</b>' . $vacationData['reason'] . '</p>
<p><b>工作交接：</b>' . $vacationData['work'] . '</p>
<p><b>备注：</b>' . $vacationData['remark'] . '</p>
<p><b>创建人：</b>' . $vacationData['creater'] . '</p>
<p><b>申请时间：</b>' . $vacationData['create_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $data['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '请假申请-审核', 'to' => $to, 'user_id' => $vacationData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
// 批准
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']';
$reviewResult = '<font style="color: #006400"><b>批准</b></font>';
$updateData = array();
$toArr = array();
$subject = '审核';
$mailCc = null;
if ($review_step == 'review_1') {
$step_name = '审核人1';
if ($vacationData['review_user_2'] > 0 && $vacationData['review_time_1'] == '') {
// 二级审核，当前申请批准后进入第二级审核
array_push($toArr, $vacationData['review_employee_2_id']);
$updateData = array('review_time_1' => $now, 'review_info' => $vacationData['review_info'] . '<br>' . $review_info);
} else {
// 一级审核，当前申请批准后进入HRA审核
$member = new Admin_Model_Member();
$hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管');
$hraEmployeeIdArr = array();
foreach ($hraAdminUserArr as $hra) {
$hra_info = $user->getEmployeeInfoById($hra['user_id']);
array_push($toArr, $hra_info['id']);
}
if (isset($vacationData['manager_id']) && $vacationData['manager_id'] != '') {
array_push($toArr, $vacationData['manager_id']);
}
$updateData = array('state' => 2, 'review_time_1' => $now, 'review_info' => $vacationData['review_info'] . '<br>' . $review_info);
}
} else {
if ($review_step == 'review_2') {
// 二级审核，当前申请批准后进入HRA审核
$step_name = '审核人2';
$member = new Admin_Model_Member();
$hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管');
$hraEmployeeIdArr = array();
foreach ($hraAdminUserArr as $hra) {
$hra_info = $user->getEmployeeInfoById($hra['user_id']);
array_push($toArr, $hra_info['id']);
}
if (isset($vacationData['manager_id']) && $vacationData['manager_id'] != '') {
array_push($toArr, $vacationData['manager_id']);
}
$updateData = array('state' => 2, 'review_time_2' => $now, 'review_info' => $vacationData['review_info'] . '<br>' . $review_info);
} else {
if ($review_step == 'review_hra') {
// HRA审核，当前申请批准后发布
$step_name = '人事审核';
$reviewResult = '<font style="color: #006400"><b>发布</b></font>';
$subject = '发布';
array_push($toArr, $vacationData['apply_employee_id']);
$updateData = array('state' => 3, 'release_time' => $now, 'release_user' => $user_id, 'review_info' => $vacationData['review_info'] . '<br>' . $review_info);
$mailCc = $vacationData['agent_email'];
if ($mailCc != '') {
if ($vacationData['manager_email'] != '') {
$mailCc .= ',' . $vacationData['manager_email'];
}
} else {
$mailCc = $vacationData['manager_email'];
}
if ($vacationData['type'] == 2) {
// 当年假申请批准后，更新年假库的已用时间：根据员工工号以及入司年数
$vacationStorage = new Hra_Model_Vacationstorage();
$vacationStorage->update(array('qty_used' => new Zend_Db_Expr("qty_used + " . $vacationData['qty'])), "number = '" . $vacationData['number'] . "' and in_year_qty = " . $vacationData['in_year_qty']);
}
// 请假申请发布后，在打卡记录中按请假时间加入打卡时间，且备注请假类别
/* $attendance = new Hra_Model_Attendance();
$attendance->setClock($vacationData['number'], $vacationData['employment_type'], $vacationData['time_from'], $vacationData['time_to'], $vacationData['type_name']); */
}
}
}
// 更新Review表
$reviewData = array('actual_user' => $user_session->user_info['employee_id'], 'finish_time' => $now, 'finish_flg' => 1);
$review->update($reviewData, "type = 'attendance_vacation' and file_id = " . $review_id . " and step_name = '" . $step_name . "'");
// 更新请假申请
$vacation->update($updateData, "id = " . $review_id);
// 发送邮件
if (count($toArr)) {
$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><a style="color:#008B00;font-weight: bold;">' . $vacationData['apply_user_name'] . '</a></p>
<p><b>请假类别：</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['type_name'] . '</a></p>
<p><b>请假时间：</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['time_from'] . '</a> 至 <a style="color:#008B00;font-weight: bold;">' . $vacationData['time_to'] . '</a></p>
<p><b>代理人：</b>' . $vacationData['agent_name'] . '</p>
<p><b>事由：</b>' . $vacationData['reason'] . '</p>
<p><b>工作交接：</b>' . $vacationData['work'] . '</p>
<p><b>备注：</b>' . $vacationData['remark'] . '</p>
<p><b>创建人：</b>' . $vacationData['creater'] . '</p>
<p><b>申请时间：</b>' . $vacationData['create_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $updateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '请假申请-' . $subject, 'user_id' => $vacationData['create_user'], 'content' => $mailContent, 'add_date' => $now);
if ($mailCc) {
$mailData['cc'] = $mailCc;
}
$help = new Application_Model_Helpers();
$resultMail = $help->sendMailToStep($toArr, $mailData);
if (!$result['success']) {
$result = $resultMail;
}
}
}
} else {
if ($review_type == 'overtime') {
$overtime = new Hra_Model_Attendance_Overtime();
$overtimeData = $overtime->getData(null, $review_id);
if ($review_operate == 'no') {
// 拒绝
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']';
$timeType = 'review_time_1';
if ($overtimeData['review_time_1']) {
$timeType = 'review_time_2';
}
$data = array('state' => 1, $timeType => date('Y-m-d H:i:s'), 'review_info' => $overtimeData['review_info'] . '<br>' . $review_info);
$overtime->update($data, "id = " . $review_id);
// 删除当前申请的审核配置
$review->delete("type = 'attendance_overtime' and file_id = " . $review_id);
// 发送邮件通知申请人
$reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>';
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $overtimeData['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><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' => '加班申请-审核', 'to' => $to, 'user_id' => $overtimeData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
// 批准
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']';
$reviewResult = '<font style="color: #006400"><b>批准</b></font>';
$updateData = array();
$toArr = array();
$subject = '审核';
if ($review_step == 'review_1') {
$step_name = '审核人1';
if ($overtimeData['review_user_2'] > 0 && $overtimeData['review_time_1'] == '') {
// 二级审核，当前申请批准后进入第二级审核
array_push($toArr, $overtimeData['review_employee_2_id']);
$updateData = array('review_time_1' => $now, 'review_info' => $overtimeData['review_info'] . '<br>' . $review_info);
} else {
// 一级审核，当前申请批准后进入HRA审核
$member = new Admin_Model_Member();
$hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管');
$hraEmployeeIdArr = array();
foreach ($hraAdminUserArr as $hra) {
$hra_info = $user->getEmployeeInfoById($hra['user_id']);
array_push($toArr, $hra_info['id']);
}
if (isset($overtimeData['manager_id']) && $overtimeData['manager_id'] != '') {
array_push($toArr, $overtimeData['manager_id']);
}
$updateData = array('state' => 2, 'review_time_1' => $now, 'review_info' => $overtimeData['review_info'] . '<br>' . $review_info);
}
} else {
if ($review_step == 'review_2') {
// 二级审核，当前申请批准后进入HRA审核
$step_name = '审核人2';
$member = new Admin_Model_Member();
$hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管');
$hraEmployeeIdArr = array();
foreach ($hraAdminUserArr as $hra) {
$hra_info = $user->getEmployeeInfoById($hra['user_id']);
array_push($toArr, $hra_info['id']);
}
if (isset($overtimeData['manager_id']) && $overtimeData['manager_id'] != '') {
array_push($toArr, $overtimeData['manager_id']);
}
$updateData = array('state' => 2, 'review_time_2' => $now, 'review_info' => $overtimeData['review_info'] . '<br>' . $review_info);
} else {
if ($review_step == 'review_hra') {
// HRA审核，当前申请批准后发布
$step_name = '人事审核';
$reviewResult = '<font style="color: #006400"><b>发布</b></font>';
$subject = '发布';
array_push($toArr, $overtimeData['apply_employee_id']);
$updateData = array('state' => 3, 'release_time' => $now, 'release_user' => $user_id, 'review_info' => $overtimeData['review_info'] . '<br>' . $review_info);
}
}
}
// 更新Review表
$reviewData = array('actual_user' => $user_session->user_info['employee_id'], 'finish_time' => $now, 'finish_flg' => 1);
$review->update($reviewData, "type = 'attendance_overtime' and file_id = " . $review_id . " and step_name = '" . $step_name . "'");
// 更新加班申请
$overtime->update($updateData, "id = " . $review_id);
// 发送邮件
if (count($toArr)) {
$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><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>' . $updateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '加班申请-' . $subject, 'user_id' => $overtimeData['create_user'], 'content' => $mailContent, 'add_date' => $now);
$help = new Application_Model_Helpers();
$resultMail = $help->sendMailToStep($toArr, $mailData);
if (!$result['success']) {
$result = $resultMail;
}
}
}
}
}
} 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_type_id = isset($request['review_type_id']) ? $request['review_type_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;
//转审人
$review_transfer = $request['review_transfer'] == 1 ? true : false;
if ($review_id && $review_operate) {
$transfer = new Erp_Model_Purchse_Transfer();
$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;
$req = new Erp_Model_Purchse_Req();
$user = new Application_Model_User();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
$reqData = $req->getData(null, $review_id);
// 更新审核状态及审核意见
if ($review_operate == 'transfer') {
// 转审
$review_info = $reqData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [审核-转审] [' . $review_info . ']';
$req->update(array('review_info' => $review_info), "id = " . $review_id);
$reviewState = $review->fetchRow("type = 'purchse_req_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>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqData['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 . ']';
$data = array('state' => 1, 'transfer_description' => null, 'review_info' => $reqData['review_info'] . '<br>' . $review_info);
$req->update($data, "id = " . $review_id);
if ($review_transfer) {
$transfer->update(array('state' => 1), "id = " . $reqData['transfer_id']);
}
// 删除当前申请的审核配置
$review->delete("type = 'purchse_req_add' and file_id = " . $review_id);
// 发送邮件通知制单人
$reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>';
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $reqData['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>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-审核', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $reqData['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 . ']';
$reqUpdateData = array('review_info' => $reqData['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) {
if ($review_transfer) {
if ($reqData['transfer_type'] == '取消') {
$this->cancelReq($review_id);
} else {
$this->approveTransferUpdateItems($reqData['transfer_id']);
}
$transfer->update(array('state' => 2), "id = " . $reqData['transfer_id']);
}
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
$reviewResult = '<font style="color: #006400"><b>发布</b></font>';
// 发布
// 更新申请状态
$reqUpdateData['state'] = 2;
$reqUpdateData['transfer_description'] = null;
$reqUpdateData['release_time'] = $now;
// 更新审核记录表
$review->update($data, "id = " . $review_current_step);
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $reqData['create_user'])->toArray();
$applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray();
$to = $applyEmployee['email'];
$cc = $user_session->user_info['user_email'];
// 发布通知采购员
$buyer = new Erp_Model_Purchse_Buyer();
$buyerData = $buyer->getData();
foreach ($buyerData as $b) {
$cc .= ',' . $b['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>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqUpdateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-发布', 'to' => $to, 'cc' => $cc, 'user_id' => $reqData['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>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</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);
// 等待其他审核人批准
}
}
// 更新申请状态
$req->update($reqUpdateData, "id = " . $review_id);
}
}
}
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 getlistAction()
{
$request = $this->getRequest()->getParams();
$whereSearch = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$whereSearch .= " and (ifnull(t1.remark,'') like '%{$v}%' or ifnull(t1.transfer_reason,'') like '%{$v}%' or ifnull(t1.state_before,'') like '%{$v}%' or ifnull(t1.state_after,'') like '%{$v}%' or ifnull(t1.code,'') like '%{$v}%')";
} else {
if ($k == 'search_description') {
$whereSearch .= " and t4.description like '%" . $v . "%'";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $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();
$transfer = new Product_Model_Transfer();
// 查询条件
// 类型
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
// 获取物料数据
$data = $transfer->getMy($myType, $whereSearch, $user);
for ($i = 0; $i < count($data); $i++) {
$mytype = 2;
if ($data[$i]['create_user'] == $user) {
$mytype = 1;
}
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已归档";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], "materiel_transfer");
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_transfer');
}
// 转为json格式并输出
echo Zend_Json::encode($data);
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;
}
public function getlistAction()
{
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$type = new Product_Model_Type();
$whereSearch = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$cols = array("t1.name", "t1.remark", "t1.manufacturers", "t1.code", "t1.description", "t3.cname");
$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] . "%'";
}
$whereSearch .= " and " . join(' AND ', $arr);
// $whereSearch .= " and (ifnull(t1.name,'') like '%$v%' or ifnull(t1.remark,'') like '%$v%' or ifnull(t1.manufacturers,'') like '%$v%' or ifnull(t1.code,'') like '%$v%' or ifnull(t1.description,'') like '%$v%' or ifnull(t3.cname,'') like '%$v%')";
} else {
if ("search_archive_date_from" == $k && $v) {
$whereSearch .= " and t1.archive_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_archive_date_to" == $k && $v) {
$whereSearch .= " and t1.archive_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
if ("search_type" == $k && $v) {
$whereSearch .= " and t1.type in ({$v})";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$materiel = new Product_Model_Materiel();
$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();
// 查询条件
// 类型
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
// 获取物料数据
$data = $materiel->getMy($myType, $whereSearch, $user, $start, $limit);
$totalCount = $materiel->getMyCount($myType, $whereSearch, $user);
for ($i = 0; $i < count($data); $i++) {
$data[$i]['description'] = htmlspecialchars($data[$i]['description']);
$mytype = 2;
if ($data[$i]['create_user'] == $user) {
$mytype = 1;
}
if (($typeId = $data[$i]['type']) != '') {
$typeName = $this->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']);
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已归档";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], "materiel");
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');
}
// 排序
$dataT3 = array();
$dataT2 = array();
$dataT1 = array();
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['mytype'] == 3) {
$dataT3[] = $data[$i];
} else {
if ($data[$i]['mytype'] == 2) {
$dataT2[] = $data[$i];
} else {
$dataT1[] = $data[$i];
}
}
}
$data = array_merge($dataT3, $dataT1, $dataT2);
$resutl = array("totalCount" => $totalCount, "topics" => $data);
// 转为json格式并输出
echo Zend_Json::encode($resutl);
exit;
}
/**
* @abstract 获取文件JSON数据
* @return null
*/
public function getfilesAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$whereSearch = "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");
$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] . "%'";
}
$whereSearch .= " and " . join(' AND ', $arr);
// $whereSearch .= " 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) {
$whereSearch .= " and t.category = '{$v}'";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " 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();
// 我的ID
$user_session = new Zend_Session_Namespace('user');
$myId = $user_session->user_info['employee_id'];
$myDept = $user_session->user_info['dept_id'];
// 类型
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
$file_ids = array();
if ($myType == 4 || $myType == '') {
// 4、共享给我的
// 查询共享给我的文件ID
$share = new Dcc_Model_Share();
$nowDate = date('Y-m-d');
$uploadRows = $share->fetchAll("type = 'upload' and share_time_begin <= '{$nowDate}' and share_time_end >= '{$nowDate}' and (FIND_IN_SET({$myId}, share_user) or FIND_IN_SET({$myDept}, share_dept))")->toArray();
for ($i = 0; $i < count($uploadRows); $i++) {
$upload_id = $uploadRows[$i]['shared_id'];
// 查询使用了此上传文件的文件
$filesRows = $files->fetchAll("state != 'Deleted' and del_flg = 0 and FIND_IN_SET({$upload_id}, file_ids)")->toArray();
for ($j = 0; $j < count($filesRows); $j++) {
$file_id = $filesRows[$j]['id'];
if (!in_array($file_id, $file_ids)) {
$file_ids[] = $file_id;
}
}
}
}
// $datas = $files->getMy($myType, $whereSearch, $myId, $file_ids, $start, $limit);
$totalData = $files->getMyCount($myType, $whereSearch, $myId, $file_ids);
$totalCount = count($totalData);
$datas = array_slice($totalData, $start, $limit);
$data = array();
foreach ($datas as $tmp) {
$mytype = 2;
if ($tmp['create_user'] == $myId) {
$mytype = 1;
} else {
if (in_array($tmp['id'], $file_ids)) {
$mytype = 4;
}
}
$tmp['create_time'] = strtotime($tmp['create_time']);
$tmp['update_time'] = strtotime($tmp['update_time']);
$tmp['archive_time'] = strtotime($tmp['archive_time']);
$tmp['codever'] = $tmp['code'] . ' V' . $tmp['ver'];
$tmp['send_require'] = $tmp['send_require'] == 1 ? true : false;
$tmp['description'] = $tmp['code_description'];
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($tmp['state'] == 'Active') {
$reviewState = "已发布";
} else {
if ($tmp['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $tmp['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) {
$tmp['review_id'] = $row['id'];
$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();
/* if ($method == 1 && $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 ($planUser)
$planUser .= ",";
$planUser .= $tmpUser->ids;
}
} else if ($method == 2 && $plan_dept) {
$tmpDept = $step->getAdapter()->query("select group_concat(name) as name from oa_employee_dept where id in ( " . $plan_dept . ")")->fetchObject();
$step_dept_name = $tmpDept->name;
if ($step_dept_name) {
$depts = explode(',', $step_dept_name);
}
} */
$plan_user = explode(',', $planUser);
$diff = array_diff($plan_user, $actual_user);
foreach ($diff as $u) {
if (!$u) {
continue;
}
if ($u == $myId) {
$mytype = 3;
}
$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 ($tmp['state'] == 'Obsolete') {
$reviewState = "已作废";
} else {
if ($tmp['state'] == 'Return') {
$reviewState = "退回";
} else {
$reviewState = $tmp['state'];
}
}
}
}
$tmp['step_name'] = $step_name;
$tmp['review_state'] = $reviewState;
if ($tmp['reason_type']) {
$masterData = $codemaster->fetchRow("type = 5 and code = '" . $tmp['reason_type'] . "'");
$reason_type_name = $masterData->text;
$tmp['reason_type_name'] = $reason_type_name;
}
// int转换为字符串
$tmp['mytype'] = " " + $mytype;
$data[] = $tmp;
}
// 排序
$dataT3 = array();
$dataT1 = array();
$dataT2 = array();
$dataT4 = array();
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['mytype'] == 3) {
$dataT3[] = $data[$i];
} else {
if ($data[$i]['mytype'] == 1) {
$dataT1[] = $data[$i];
} else {
if ($data[$i]['mytype'] == 2) {
$dataT2[] = $data[$i];
} else {
$dataT4[] = $data[$i];
}
}
}
}
$data = array_merge($dataT3, $dataT1, $dataT2, $dataT4);
$resutl = array("totalCount" => $totalCount, "topics" => $data);
echo Zend_Json::encode($resutl);
exit;
}
