/**
* @abstract 获取文件JSON数据
* @return null
*/
public function getfilesAction()
{
$this->archiveFile();
// 请求参数
$request = $this->getRequest()->getParams();
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$dept = $user_session->user_info['dept_id'];
$archive = 0;
if (isset($request['search_archive']) && ($request['search_archive'] == '已归档' || $request['search_archive'] == '1')) {
$archive = 1;
}
$where = "1 = 1";
// 是否用于文件归档
if (isset($request['type']) && $archive == 0) {
$where = "t1.archive = 0";
}
if (!isset($request['all'])) {
$where .= " and t1.private=0";
}
if (isset($request['full'])) {
$where = "1=1";
}
foreach ($request as $k => $v) {
if ($v != '') {
if ("search_upload_date_from" == $k && $v) {
$where .= " and t1.upload_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_upload_date_to" == $k && $v) {
$where .= " and t1.upload_time <= '" . str_replace('T00:00:00', ' 23:59:59', $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 {
if ("search_archive" == $k) {
if (!isset($request['full']) || $request['full'] != 1) {
$where .= " and t1.archive = {$archive}";
}
} else {
if ("search_del" == $k) {
$where .= " and t1.del = {$v}";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$where .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
}
}
$upload = new Dcc_Model_Upload();
if (isset($request['full'])) {
$where1 = $where2 = "";
} else {
$where1 = " and (t1.create_user = {$user} or t1.update_user = {$user})";
$where2 = " and (FIND_IN_SET({$user}, share_user) or FIND_IN_SET({$dept}, share_dept))";
}
$data = $upload->getFilesList($where . $where1, $where . $where2);
$employee = new Hra_Model_Employee();
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]['upload_time'] = strtotime($data[$i]['upload_time']);
$data[$i]['archive'] = $data[$i]['archive'] == 1 ? true : false;
// 共享期间
$begin = $data[$i]['share_time_begin'];
$end = $data[$i]['share_time_end'];
$data[$i]['share_time'] = $begin == '2013-01-01' ? '' : $begin;
$data[$i]['share_time'] .= "~";
$data[$i]['share_time'] .= $end == '2099-12-31' ? '' : $end;
$data[$i]['share_time'] = $data[$i]['share_time'] == '~' ? '' : $data[$i]['share_time'];
$data[$i]['share_time_begin'] = strtotime($data[$i]['share_time_begin']);
$data[$i]['share_time_end'] = strtotime($data[$i]['share_time_end']);
// 共享给个人
$share_user = $data[$i]['share_id'];
if ($share_user) {
$share = str_replace("E", "", $share_user);
$share_name = $employee->getInfosByOneLine($share_user);
$data[$i]['share_name'] = $share_name['cname'];
}
// 共享给部门
$share_dept = $data[$i]['share_dept'];
if ($share_dept) {
$share = str_replace("D", "", $share_dept);
$share_name = $upload->getDeptNames($share_dept);
$data[$i]['share_dept_name'] = $share_name['dept_name'];
}
}
echo Zend_Json::encode($data);
exit;
}
