开发信息 返回

  • 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