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;
}
