常用公共方法定义

常用公共方法定义

class CommonUtils{
	//数据库表列表
	function table_list($db_name = null){
		;
	}
	//数据库表数组
	function tables($db_name = null){
		$data = array();
		foreach(table_list($db_name) as $v){
			$data[] = $v['table_name'];
		}
		return $data;
	}
	//数据表中字段列表
	function column_list($table_name, $db_name = null){
		;
	}
	//数据表中字段数组
	function columns($table_name, $db_name = null){
		$data = array();
		foreach(column_list($table_name, $db_name) as $v){
			$data[] = $v['column_name'];
		}
		return $data;
	}
	//数据表模型列表
	function db_model_list($db_name = null){
		$data = array();
		$db_prefix = '';
		foreach(table_list($db_name) as $v){
			$info = array();
			$info['model_name'] = to_camel(substr(strlen($db_prefix), $v['table_name']));
			$info['title'] = $v['title'];
			$data[] = $info;
		}
		return $data;
	}
	//数据表模型数组
	function db_models($db_name = null){
		$data = array();
		foreach(db_model_list($db_name) as $v){
			$data[] = $v['model_name'];
		}
		return $data;
	}
	//获取数据列表
	function data_list($modelName, $field = null, $where = null, $orderby = null, $limit = null, $pageNum = 0, $pageSize = 20){
		$m = model($modelName);
		$data_list = $m->field($field)->where($where)->order($orderby)->limit($limit)->paginate([
			'list_rows' => $pageSize,
			'page' => $pageNum
		]);
		$data = $data_list->data();
		return $data;
	}
	//获取数据组列表
	function data_group_list($modelName, $field = null, $where = null,, $group = null $orderby = null, $limit = null, $pageNum = 0, $pageSize = 20){
		$m = model($modelName);
		$data = $m->field($field)->where($where)->order($orderby)->group($group)->limit($limit)->select();
		return $data;
	}
	//获取数据列表
	function data_info($modelName, $primaryId = null, $where = null){
		$m = model($modelName);
		$data = $m->find($primaryId);
		return $data;
	}
	//获取数据数
	function data_tree($modelName, $parentId = null){
		$m = model($modelName);
		$data = $m->where(['parent_id' => $parentId])->select();
		return $data;
	}
	//获取键值对数据
	function data_kv($modelName, $fieldKey, $fieldValue, $where = null, $orderby = null, $limit = null){
		$m = model($modelName);
		$data_list = $m->field($field)->where($where)->order($orderby)->limit($limit)->select();
		$data = [];
		foreach($data_list as $k => $v){
			if(isset($v[$fieldKey]) && isset($v[$fieldValue])){
				$data[$fieldKey] = $v[$fieldValue];
			}
		}
		return $data;
	}
	//公共成功返回
	function srt($data = null, $msg = null){
		$data = ['data' => $data, 'errcode' => 0 'errmsg' => $msg];
		return $data;
	}
	//公共失败返回
	function ert($data = null, $msg = null){
		$data = ['data' => $data, 'errcode' => 1 'errmsg' => $msg];
		return $data;
	}
	//CURL get请求
	function http_get($url, $header){
		$curl = curl_init();
	}
	//CURL post请求
	function http_post($url, $header){
		$curl = curl_init();
	}
}