接口讲解视频

http://v.uninote.com.cn/video_play.html?video_url=https://admin.bb.uninote.com.cn/oss?path=video/upload/202111/20211113_135241.mp4

http://v.uninote.com.cn/video_play.html?video_url=https://admin.bb.uninote.com.cn/oss?path=video/upload/202111/20211113_141148.mp4

本次新增接口列表：

• 获取图片分类列表：http://powder.dajxyl.com/?select-module=client%2Findex&select-api=imageModelList#/
• 获取图片列表：http://powder.dajxyl.com/?select-module=client%2Findex&select-api=imageFileList#/

代码更新

• 项目：biglove-cms、dajx-api
• 分支：sprint17

配置文件改动

• biglove-cms项目下/cms/config/__params.php文件

  # 说明：Aliyun下新增url、url2字段配置
  'Aliyun' => [
      'url' => 'https://admin.dajxyl.com/oss?path=',
  	'url2' => 'http://admin.dajxyl.com/oss?path=',
  ]
  

nginx配置文件

dajx_cms.conf新增配置内容

    location /dajxapi {
        rewrite /api/(.*)$ /$1 break;
        proxy_pass https://api.dajxyl.com;
        proxy_set_header Host      $proxy_host;
        proxy_set_header X-Real-IP $remote_addr;
    }

数据库改动

# dajx-api

## 创建菜单数据
INSERT INTO `menu` (`pid`, `title`) VALUES ('900', '图片分类管理');

## 创建图片分类管理表
CREATE TABLE `image_model` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '分类配图',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '分类标题',
  `pid` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '所属模块ID（关联menu表id字段）',
  `image_count` int(11) NOT NULL DEFAULT 0 COMMENT '图片张数',
  `sort` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '排序（降序）',
  `description` varchar(50) NOT NULL DEFAULT '' COMMENT '分类图片介绍',
  `status` tinyint(1) unsigned NOT NULL DEFAULT 2 COMMENT '状态 1=下线,2=上线',
  `time` int(11) unsigned NOT NULL DEFAULT 0,
  `update_time` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='图片分类管理表';

## 图片分类关联图片表
CREATE TABLE `image_files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '图片路径（不包含域名host）',
  `pid` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '所属分类ID（关联image_model表id字段）',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '图片昵称（相当于给图片起了个别名）',
  `time` int(11) NOT NULL DEFAULT 0,
  `update_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='图片分类关联图片表';

# biglove

## 权限
INSERT INTO `access` (`id`, `pid`, `title`, `urls`) VALUES ('4000', '256', '图片分类管理', '/admin/image/model.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4000', '新建图片分类', '/admin/image/add.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4000', '编辑图片分类', '/admin/image/edit.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4000', '删除图片分类', '/admin/image/del.html');
INSERT INTO `access` (`id`, `pid`, `title`, `urls`) VALUES ('4100', '4000', '图片管理', '/admin/image/imageFiles.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4100', '删除图片', '/admin/image/delFile.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4100', '移动图片', '/admin/image/moveFile.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4100', '设置图片名称', '/admin/image/setFileTitle.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('4100', '上传图片', '/admin/image/addImageFiles.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('256', '获取APP接口的token', '/admin/auth/getDajxApiToken.html');