public function show($condition) { $sql = "SELECT * FROM " . DB_PREFIX . "audit_record WHERE " . $condition; //echo $sql;die; $q = $this->db->query($sql); $data = $audit_record = array(); $bill_id = $space = ''; //$i = 0; while ($row = $this->db->fetch_array($q)) { if ($row['audit_level'] > 0) { $sql = "SELECT * FROM " . DB_PREFIX . "audit_record WHERE state=0 AND bill_id=" . $row['bill_id'] . " AND audit_level<" . $row['audit_level']; //echo $sql;die; $f = $this->db->query_first($sql); if (!$f) { if ($row['bill_id']) { $bill_id .= $space . $row['bill_id']; $space = ','; } $data[] = $row; } //存在,说明上一级审核未通过 } else { if ($row['bill_id']) { $bill_id .= $space . $row['bill_id']; $space = ','; } $data[] = $row; } } if ($bill_id) { include_once CUR_CONF_PATH . 'lib/bill.class.php'; $bill = new bill(); $bill_info = $tmp = array(); $tmp = $bill->show(' AND id IN(' . $bill_id . ')'); if ($tmp) { foreach ($tmp as $k => $v) { $bill_info[$v['id']] = array('project_name' => $v['project_name'], 'cause' => $v['cause'], 'user_id' => $v['user_id'], 'user_name' => $v['user_name']); } foreach ($data as $k => $v) { $data[$k]['bill'] = $bill_info[$v['bill_id']]; } } } return $data; }