load(); } public function nav() { return $this->data['nav']; } public function info() { return $this->data['nav'][$this->db]; } public function doc() { return $this->doc; } public function menu() { return $this->data['data']; } private function load() { $this->type = Dever::input('type', 'db'); $this->db = Dever::input('db'); $type = 'load_' . $this->type; $this->$type(); } private function create_nav($list, $num = 0) { $this->data['nav'] = array(); $i = 0; foreach ($list as $k => $v) { if ($v['order'] > $num) { if (!$this->db && $i == 0) { $this->db = $k; } $this->data['nav'][$k] = array ( 'name' => $v['lang'], 'link' => Dever::url('doc/view?type=' . $this->type . '&db=' . $k, 'manage'), 'class' => $this->db == $k ? 'active' : '', ); $i++; } } if (!$this->data['nav']) { Dever::alert('没有该数据项'); } } private function load_db() { $list = Dever::load('manage/project.get'); $this->create_nav($list); if (isset($this->data['nav'][$this->db])) { $this->doc = '介绍' . $this->data['nav'][$this->db]['name'] . '项目下的数据结构与对外的数据接口'; $database = Dever::load('manage/database'); $data = $database->config($this->db); $this->data['data'] = array(); $table = array ( '方法名' => '参数', '查询表中所有数据(select)' => array ( 'option_col' => '可选参数,col换成表的字段', ), '统计表中所有数据(total)' => array ( 'option_col' => '可选参数,col换成表的字段', ), '查询表中一条数据(find)' => array ( 'where_id' => '必填参数,表主键', ), '插入数据(insert)' => array ( 'add_col' => '必填参数,col换成表的字段', ), '删除数据(delete)' => array ( 'where_id' => '必填参数,表主键', ), '更新数据(update)' => array ( 'where_id' => '必填参数,表主键', 'set_col' => '必填参数,col换成表的字段', ), ); $this->data['data']['api']['name'] = '通用数据接口'; $this->data['data']['api']['content'] = '
所有数据接口,均使用:Dever::db("项目名/表名")->方法名(参数)调取'; $this->data['data']['api']['content'] .= Dever::table($table); foreach ($data as $k => $v) { $this->data['data'][$k]['content'] = '
例如:Dever::db("manage/role")->select(array("option_name" => "超级管理员"))
库名、表名、字段名必须使用小写字母,多个单词用“_”分割(例如表名:user_comment) 库名、表名、字段名称禁止使用mysql保留字命名 ,比如:select,insert,order,group,delete,limit等等 建库和建表的编码和字符集分别是utf8和utf8_general_ci 使用dever建立表时,请遵守dever框架规范', ), 'sql' => array ( 'name' => '建库建表', 'content' => "
表类型如果读多写极少(比如文章)可以用myisam;读写都较多或者需要用到事物的情况用innodb; 其它情况两个都可以选择 字段必须有详细注释,并且有多值的字段要列出所有值的含义(比如状态status字段) 字段必须为NOT NULL和设置default值 字段固定长度的短字符用char(例如md5后的密码),长度不固定的用varchar,char或者varchar能满足的不要使用text 大字段类型要慎用(TEXT、BLOB等等) 字段能用int类型都使用int型存储", ), ); if (!isset($data[$this->db])) { Dever::alert('没有该数据项'); } $this->data['data'] = $data[$this->db]; return $this->data['data']; } return array(); } private function load_api() { $data = Dever::load('manage/api-getAll'); if (isset($data['manage'])) { unset($data['manage']); } $keys = array_keys($data); $list = array(); $project = Dever::load('manage/project.get'); foreach ($keys as $k => $v) { if (isset($project[$v])) { $list[$v] = $project[$v]; } } $this->create_nav($list, -50); if (isset($this->data['nav'][$this->db]) && isset($data[$this->db])) { $this->doc = '介绍' . $this->data['nav'][$this->db]['name'] . '项目下的对外接口'; $config = Dever::db('manage/api')->config; $type = $config['gettype']; $doc = $config['doc']; $html = $config['html']; $this->data['data'] = array(); $this->data['data']['api']['name'] = '公共参数说明'; $this->data['data']['api']['content'] = '例如: IP可转换成int后存储 日期和时间可用int存储 enum类型可使用tinyint存储密码字段不能明文存储 建表就得考虑索引,而不是发现sql慢了才加索引 单个表字段一般情况下最多不能超过30个字段(可将大字段和不常用的字段拆分到新表中) 建表Demo:CREATE TABLE `user_base` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户 ID' , `username` char(50) NOT NULL DEFAULT ' ' COMMENT '用户名' , `password` char(32) NOT NULL DEFAULT ' ' COMMENT '密码' , `email` char(50) NOT NULL DEFAULT ' ' COMMENT '电子邮件' , `regdate` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册日期' , `last_login_ip` int(11) NOT NULL DEFAULT 0 COMMENT '最后登录IP' , `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态:1正常;2已删除;' , PRIMARY KEY (`id`), UNIQUE INDEX `uniq_username` (`username`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci COMMENT='用户基本表' AUTO_INCREMENT=1
加密共有两种方式:'; $this->data['data']['api']['content'] .= $html; $this->class = Dever::load('manage/api'); $url = Dever::url('manage/api.update_col'); foreach ($data[$this->db] as $k => $v) { $one = array ( 'option_api_id' => $v['id'], 'option_parent_id' => -1, ); $requestData = Dever::db('manage/api_request')->all($one); $responseData = Dever::db('manage/api_response')->all($one); $request = $this->class->showTable($requestData, $url, 'api_request'); $response = $this->class->showTable($responseData, $url, 'api_response'); $this->data['data'][$k]['content'] = '
1、请求加密:所有传输参数均要进行加密,通过token加密,加密方法如下:
' . $doc . '
2、登录加密:由服务端生成signature,然后客户端保存此signature,每次客户端向服务端请求,均需要传输signature,本方式适用移动端登录状态。signature中自带uid。
' . ($v['type'] == 1 ? 'get' : 'post') . ''; $this->data['data'][$k]['content'] .= '
' . Dever::url($v['site'], $v['project']) . ''; $this->data['data'][$k]['content'] .= '