db->where('userid',$id); return $this->db->get('user_field')->row_array(); } // 更新用户字段管理 public function update_user_field($data){ $this->db->where('userid',$data['userid']); $res = $this->db->get('user_field')->row_array(); if (empty($res)) { $this->db->insert('user_field',$data); }else{ $this->db->where('userid',$data['userid'])->update('user_field',$data); } } // 获取所有维修人员 public function get_repair_user($filter){ if(!isset($filter['user_id']) || empty($filter['user_id'])){ return array(); } // $query = "SELECT * FROM user WHERE id={$filter['user_id']}"; // $query = $this->db->query($query); // $user = $query->row_array(); // if (empty($user)) { // return array(); // } // $colum = 'role_'.$user['role']; $query = "SELECT id,name FROM repair_user WHERE owner_id={$filter['user_id']}"; $query = $this->db->query($query); $data = $query->result_array(); return $data; } }