<?php

/**

* User: Eden

* Date: 2019/3/30

* 共有内容

*/

/**

 CREATE TABLE `tf_configs` (

    `id` int(11) NOT NULL COMMENT 'id',

    `key` varchar(100) NOT NULL COMMENT 'key',

    `value` text NOT NULL COMMENT 'value',

    `create_time` int(11) NOT NULL COMMENT '创建时间'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置表';

 */

namespace Common\Service;

class ConfigService extends CommonService {

    /**

     * 查询单个key

     * $key = 'total_donate';

     * @param $key

     * @return array

     */

    public function queryOneKey($key) {

        $configs = M('configs');

        $data = $configs->where(['key'=>$key])->find();

        return $data['value'];

    }

    /**

     * 查询多个key

     * $keys = 'total_donate,total_help,total_join';

     * $keys = ['total_donate','total_help','total_join'];

     * @param array $keys

     * @return mixed

     */

    public function queryKeys($keys = [])

    {

        $where = [];

        if ($keys) {

            $where['key'] = ['in', $keys];

        }

        $configs = M('configs');

        $data = $configs->where($where)->getField('`key`, `value`');

        return $data;

    }

    /**

     * 查询key

     * $key = ['key'=>['in', 'total_donate,total_help,total_join']];

     * $key = ['key'=>['in', ['total_donate','total_help','total_join']]];

     * @param $key

     * @return array

     */

    public function queryKey($key) {

        $configs = M('configs');

        $website = $configs->where($key)->getField('`key`, `value`');

        return $website;

    }

}

这种配置表，比较灵活，属于竖表。比传统的横表更加的灵活。使用的时候也有区别，需要额外处理。