PHPEMS

开发信息 返回

• PHPEMS10（20241129）发布

  • 发布人：peadmin

• PHPEMS10（20241129）发布

  1、增加报名模块

  2、增加调查模块

  3、增加实名认证

  4、增加人脸对比验证，默认百度人脸对比接口

  5、试卷界面微调，增加高度滚动条

  6、手机版默认宽度由750改为device-width

  7、播放器改为Video.js

  数据库更新：

  CREATE TABLE `x2_enroll`  (
    `enrollid` int(11) NOT NULL AUTO_INCREMENT,
    `enrollbatid` int(11) NULL DEFAULT NULL,
    `enrolluserid` int(11) NULL DEFAULT NULL,
    `enrolltruename` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enrollpassport` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enrollphone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enrolltime` int(11) NULL DEFAULT NULL,
    `enrollstatus` int(1) NULL DEFAULT NULL,
    `enrollordersn` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enrollsign` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `enrollverify` int(1) NULL DEFAULT NULL,
    `enroll_address` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`enrollid`) USING BTREE,
    INDEX `enrollbatid`(`enrollbatid`) USING BTREE,
    INDEX `enrollstatus`(`enrollstatus`) USING BTREE,
    INDEX `enrollordersn`(`enrollordersn`) USING BTREE,
    INDEX `enrolltruename`(`enrolltruename`) USING BTREE,
    INDEX `enrollpassport`(`enrollpassport`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  CREATE TABLE `x2_enroll_bats`  (
    `enbid` int(11) NOT NULL AUTO_INCREMENT,
    `enbthumb` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enbname` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `enbprice` decimal(10, 2) NULL DEFAULT NULL,
    `enbmoduleid` int(11) NULL DEFAULT NULL,
    `enbstarttime` int(11) NULL DEFAULT NULL,
    `enbendtime` int(11) NULL DEFAULT NULL,
    `enbintro` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `enbtime` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`enbid`) USING BTREE,
    INDEX `enbstarttime`(`enbstarttime`) USING BTREE,
    INDEX `enbendtime`(`enbendtime`) USING BTREE,
    INDEX `enbmoduleid`(`enbmoduleid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  CREATE TABLE `x2_survey`  (
    `svyid` int(11) NOT NULL AUTO_INCREMENT,
    `svytitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `svythumb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `svytime` int(11) NULL DEFAULT NULL,
    `svytype` int(4) NULL DEFAULT NULL,
    `svydescribe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `svystime` int(11) NULL DEFAULT NULL,
    `svyendtime` int(11) NULL DEFAULT NULL,
    `svyuserid` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`svyid`) USING BTREE,
    INDEX `svyuserid`(`svyuserid`) USING BTREE,
    INDEX `svystime`(`svystime`) USING BTREE,
    INDEX `svyendtime`(`svyendtime`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  CREATE TABLE `x2_survey_history`  (
    `syhyid` int(11) NOT NULL AUTO_INCREMENT,
    `syhyuserid` int(11) NULL DEFAULT NULL,
    `syhysvyid` int(11) NULL DEFAULT NULL,
    `syhyanswers` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `syhycode` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `syhytime` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`syhyid`) USING BTREE,
    INDEX `syhysvyid`(`syhysvyid`) USING BTREE,
    INDEX `syhyuserid`(`syhyuserid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  CREATE TABLE `x2_survey_node`  (
    `syneid` int(11) NOT NULL AUTO_INCREMENT,
    `synesvyid` int(11) NULL DEFAULT NULL,
    `synetitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `synedescribe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    PRIMARY KEY (`syneid`) USING BTREE,
    INDEX `synesvyid`(`synesvyid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  CREATE TABLE `x2_survey_questions`  (
    `syqnid` int(11) NOT NULL AUTO_INCREMENT,
    `syqnsvyid` int(11) NULL DEFAULT NULL,
    `syqnsyneid` int(11) NULL DEFAULT NULL,
    `syqnquestion` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `syqnquestiontype` int(11) NULL DEFAULT NULL,
    `syqnquestionselect` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `syqnquestionselectnumber` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`syqnid`) USING BTREE,
    INDEX `syqnsvyid`(`syqnsvyid`) USING BTREE,
    INDEX `syqnsyneid`(`syqnsyneid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

• 2024-12-01