开发信息 返回

• PHPEMS7.0发布

  • 发布人：peadmin

• 更新内容

  1、后台界面优化

  2、重写证书功能，增加在线生成证书

  3、增加后台查看课程学习进度

  4、修复已知bug

  数据库更新

  x2_certificate表增加字段 cedays,类型int(11),cetpl 类型varchar(120),cetags类型text

  x2_coursesubject增加字段 csprogress,类型tinyint(1)

  DROP TABLE IF EXISTS `x2_navs`;

  CREATE TABLE `x2_navs`  (
    `navid` int(11) NOT NULL AUTO_INCREMENT,
    `navtitle` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `navurl` varchar(240) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `navsequence` int(11) NULL DEFAULT NULL,
    `navstatus` int(1) NULL DEFAULT NULL,
    PRIMARY KEY (`navid`) USING BTREE,
    INDEX `navsequence`(`navsequence`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

  x2_orders ordersn字段增加长度至18

  x2_position 增加字段 posapp,类型varchar(48)

  DROP TABLE IF EXISTS `x2_record`;

  CREATE TABLE `x2_record`  (
    `recordid` int(11) NOT NULL AUTO_INCREMENT,
    `recordquestionid` int(11) NOT NULL DEFAULT 0,
    `recorduserid` int(11) NOT NULL DEFAULT 0,
    `recordtime` int(11) NOT NULL DEFAULT 0,
    `recordsubjectid` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`recordid`) USING BTREE,
    INDEX `recordquestionid`(`recordquestionid`) USING BTREE,
    INDEX `recorduserid`(`recorduserid`) USING BTREE,
    INDEX `recordsubjectid`(`recordsubjectid`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = FIXED;

  DROP TABLE IF EXISTS `x2_recorddata`;

  CREATE TABLE `x2_recorddata`  (
    `rdid` int(11) NOT NULL AUTO_INCREMENT,
    `rduserid` int(11) NULL DEFAULT NULL,
    `rdsubjectid` int(11) NULL DEFAULT NULL,
    `rddata` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `rdtime` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`rdid`) USING BTREE,
    INDEX `rduserid`(`rduserid`) USING BTREE,
    INDEX `rdsubjectid`(`rdsubjectid`) USING BTREE,
    INDEX `rdtime`(`rdtime`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

  证书模板设置规则

  txt,140,350,{username},25

  规则如上，第一个txt表示文字，140表示文字出现在图片模板位置的横坐标，350表示纵坐标，{username}为变量，即用户名，可用变量还有 userpassport（身份证号），usertruename（姓名），useraddress（地址）和userphone（电话）以及ceqsn（证书编号），25为文字大小，单位像素。

• 2021-10-08