/**
* @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;
}
