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