public function getlistAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$step = new Admin_Model_Step();
$employee = new Hra_Model_Employee();
$where = " 1=1";
foreach ($request as $k => $v) {
if ($v != '') {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$where .= " and " . $col . " like '%" . $v . "%'";
}
}
}
$data = $step->getList($where, $start, $limit, null);
for ($i = 0; $i < count($data); $i++) {
$step_user = $data[$i]['user'];
if ($step_user) {
$step_user_name = $employee->getInfosByOneLine($step_user);
$data[$i]['step_user_name'] = $step_user_name['cname'];
}
// 重新检索角色信息
if ($data[$i]['dept']) {
$role = $data[$i]['dept'];
$sql = "select GROUP_CONCAT(name) as step_dept_name from oa_user_role where id in ({$role})";
$db = $step->getAdapter();
$result = $db->query($sql)->fetchObject();
$data[$i]['step_dept_name'] = $result->step_dept_name;
}
$data[$i]['manager'] = $data[$i]['manager'] == 1 ? true : false;
}
$resutl = array("totalCount" => count($step->getList($where, null, null, null)), "topics" => $data);
echo Zend_Json::encode($resutl);
exit;
}
