IDCOL/api/application/models/User_model.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

include_once(FCPATH . 'application/models/Base_model.php');
class User_model extends Base_Model {

    protected $table = 'user';
            
    // 获取用户字段管理
	public function get_user_field($id){
		$this->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 {$colum}={$filter['user_id']}";
	
		$query = $this->db->query($query);
		$data =  $query->result_array();
		return $data;
	}
}