apex应用程序创建和对比

最新推荐文章于 2024-07-18 20:04:15 发布

王小小鸭

最新推荐文章于 2024-07-18 20:04:15 发布

阅读量136

点赞数

本文链接：https://blog.csdn.net/clover_oreo/article/details/132618322

版权

oracle apex 同时被 3 个专栏收录

46 篇文章 1 订阅

订阅专栏

PL/SQL

43 篇文章 0 订阅

订阅专栏

oracle

28 篇文章 1 订阅

订阅专栏

创建一个应用程序290，功能全不选展现出来的效果：

对比勾选了功能的应用程序少了很多内容

那看来该勾选还得勾选，删除之前的之后重新创建了一个应用程序290

自己跟着做应用

搜索栏下拉选择部门

在数据库使用sql语句查询，在数据库中能正常查询，但是apex中语句有误

【错误记录】ORA-20999: 在 SQL 查询中选择了错误的列数。

破案了，原来是类型给选错了，SQL查询选成了PL/SQL，找了好久原因，我的问题orz

类型选对“SQL查询”，加入DEPT_ID就可以了

select NAME,DEPT_ID from DEPT_TEST_WXX3;

加载词云库

-- 加载词云库  范例
apex.server.process('word_data', {
    // apex传参
    x01: 1

}, {
    dataType: 'json',
    success: function (data) {
        console.log(data.data);
        if (data.data){
            onload(data.data);
        };
        
        
    },
    error: function (e) {
        alert(e);
    }
});

动态菜单

select
     level,
    m1.NAME label,
    'f?p=&'||'APP_ID.:'||m1.PAGE_ID||':&'||'SESSION.::&'||'DEBUG.::::' target,
    null IS_CURRENT,
    m1.ICON image
from AUTH_MENU m1
where m1.APP_CODE = V('APP_CODE') and m1.TENANT_ID = :USERTENANT and m1.DEL_FLAG = 0 and m1.IS_ACTIVE = 'Y' and m1.MENU_ID in (
    select m2.PARENT_ID as MENU_ID from AUTH_ROLE_MENU_ASSO rma1
    join AUTH_MENU m2
        on rma1.MENU_ID = m2.MENU_ID
    where rma1.ROLE_ID = :ROLEID and m2.PARENT_ID is not null
    union
    select rma2.MENU_ID from AUTH_ROLE_MENU_ASSO rma2 where rma2.ROLE_ID = :ROLEID
    )
start with m1.PARENT_ID is null
connect by prior m1.MENU_ID = m1.PARENT_ID
order siblings by m1.SORT_NO

新建了一个事件表，里面带租户和事件基本信息，将数据填入

-- 事件表 
-- auto-generated definition
create table TEST_EVENT_WXX
(
    EVENT_ID              NUMBER generated by default as identity primary key,  --设置主键非空且唯一
        --default "YWJA"."ISEQ$$_83419".nextval generated as identity primary key,
    CREATED_BY            NUMBER(20),
    CREATION_DATE         DATE            default sysdate,
    UPDATED_BY            NUMBER(20),
    UPDATE_DATE           DATE            default sysdate,
    TENANT_ID             NUMBER(20)                      not null,
    DEL_FLAG              NUMBER          default 0       not null,
    SUBMIT_USER_ID        NUMBER(20),
    SUBMIT_DEPT_ID     NUMBER(20),
    SUBMIT_DEVICE_ID      NUMBER(20),
    SUBMIT_SOURCE         NVARCHAR2(32),
    DESCRIPTION           NVARCHAR2(2000) default null,
    IMAGES_URL            NVARCHAR2(2000),
    AFFECTED_RANGE        NVARCHAR2(128),
    CALL_RANGE            NVARCHAR2(128),
    REMARK                NVARCHAR2(600),
    MAP_ID                NUMBER(20)                      not null,
    BASE_ID               NUMBER(20)                      not null,
    FAB_ID                NUMBER(20)                      not null,
    MAP_AREA_X_ID         NUMBER(20)                      not null,
    MAP_AREA_Y_ID         NUMBER(20)                      not null,
    WORK_TYPE             NVARCHAR2(50)                   not null,
    IS_CREATE_GROUP_CHAT  NUMBER          default 0       not null,
    GROUP_CHAT_ID         NVARCHAR2(100),
    OWNER_SYNC_USER_ID    NVARCHAR2(50),
    GROUP_CHAT_QRCODE_URL NVARCHAR2(200),
    STATUS                NVARCHAR2(20)                   not null,
    START_FOLLOW_TIME     DATE,
    END_TIME              DATE,
    FIRST_EVENT_CODE      VARCHAR2(32)                    not null,
    SECOND_EVENT_CODE     VARCHAR2(32)                    not null,
    PHENOMENON_CODE       VARCHAR2(32)                    not null,
    FULL_EVENT_CODE       NVARCHAR2(200),
    DAILY_SERIAL_NUMBER   NUMBER,
    EVENT_VERIFY_CODE     NVARCHAR2(10)                   not null,
    OPEN_CONVERSATION_ID  NVARCHAR2(128),
    DEVICE_CODE           NVARCHAR2(20),
    ASSIST_ORG_IDS        NVARCHAR2(128),
    MAIN_ORG_ID           NUMBER(20),
    VIDEO_URL             NVARCHAR2(2000),
    VIDEO_IMG_URL         NVARCHAR2(2000),
    EVENT_SERIAL_NO       NUMBER(20),
    WORK_DATE             DATE,
    DURATION_SECONDS      NUMBER          default 0       not null,
    IS_STOP_LINE          VARCHAR2(10)    default 'FALSE' not null,
    IS_KEY_PROCESS        VARCHAR2(10)    default 'FALSE' not null,
    BEGIN_TIME            DATE                            not null
)
/

comment on table TEST_EVENT_WXX is '事件表'
/

comment on column TEST_EVENT_WXX.EVENT_ID is '主键事件id'
/

comment on column TEST_EVENT_WXX.CREATED_BY is '创建人'
/

comment on column TEST_EVENT_WXX.CREATION_DATE is '创建时间'
/

comment on column TEST_EVENT_WXX.UPDATED_BY is '修改人'
/

comment on column TEST_EVENT_WXX.UPDATE_DATE is '修改时间'
/

comment on column TEST_EVENT_WXX.TENANT_ID is '租户id'
/

comment on column TEST_EVENT_WXX.DEL_FLAG is '逻辑删除字段'
/

comment on column TEST_EVENT_WXX.SUBMIT_USER_ID is '上报用户id'
/

comment on column TEST_EVENT_WXX.SUBMIT_DEPT_ID is '上报用户部门id'
/

comment on column TEST_EVENT_WXX.SUBMIT_DEVICE_ID is '上报设备id'
/

comment on column TEST_EVENT_WXX.SUBMIT_SOURCE is '提交来源h5'
/

comment on column TEST_EVENT_WXX.DESCRIPTION is '问题描述'
/

comment on column TEST_EVENT_WXX.IMAGES_URL is '图片逗号分隔'
/

comment on column TEST_EVENT_WXX.AFFECTED_RANGE is '影响范围枚举'
/

comment on column TEST_EVENT_WXX.CALL_RANGE is '呼叫范围'
/

comment on column TEST_EVENT_WXX.REMARK is '解决备注'
/

comment on column TEST_EVENT_WXX.MAP_ID is '地图id'
/

comment on column TEST_EVENT_WXX.BASE_ID is '基地id'
/

comment on column TEST_EVENT_WXX.FAB_ID is '厂区id'
/

comment on column TEST_EVENT_WXX.MAP_AREA_X_ID is 'x轴id'
/

comment on column TEST_EVENT_WXX.MAP_AREA_Y_ID is 'y轴id'
/

comment on column TEST_EVENT_WXX.WORK_TYPE is '1白班2夜班'
/

comment on column TEST_EVENT_WXX.IS_CREATE_GROUP_CHAT is '是否创建群聊'
/

comment on column TEST_EVENT_WXX.GROUP_CHAT_ID is '群聊id'
/

comment on column TEST_EVENT_WXX.OWNER_SYNC_USER_ID is '群主'
/

comment on column TEST_EVENT_WXX.GROUP_CHAT_QRCODE_URL is '群聊二维码链接'
/

comment on column TEST_EVENT_WXX.STATUS is '问题状态'
/

comment on column TEST_EVENT_WXX.START_FOLLOW_TIME is '任务开始跟进时间'
/

comment on column TEST_EVENT_WXX.END_TIME is '问题结束时间'
/

comment on column TEST_EVENT_WXX.FIRST_EVENT_CODE is '一级事件编码'
/

comment on column TEST_EVENT_WXX.SECOND_EVENT_CODE is '二级事件编码'
/

comment on column TEST_EVENT_WXX.PHENOMENON_CODE is '现象编码'
/

comment on column TEST_EVENT_WXX.FULL_EVENT_CODE is '事件完整编码'
/

comment on column TEST_EVENT_WXX.DAILY_SERIAL_NUMBER is '每日序号'
/

comment on column TEST_EVENT_WXX.OPEN_CONVERSATION_ID is '钉钉群聊id 与group_chat_id类似'
/

comment on column TEST_EVENT_WXX.DEVICE_CODE is '设备编码'
/

comment on column TEST_EVENT_WXX.ASSIST_ORG_IDS is '次要责任部门 多个以逗号分隔'
/

comment on column TEST_EVENT_WXX.MAIN_ORG_ID is '主要责任部门'
/

comment on column TEST_EVENT_WXX.VIDEO_URL is '视频URL'
/

comment on column TEST_EVENT_WXX.VIDEO_IMG_URL is '视频封面URL'
/

comment on column TEST_EVENT_WXX.DURATION_SECONDS is '工单持续时间'
/

comment on column TEST_EVENT_WXX.IS_STOP_LINE is '是否停线'
/

comment on column TEST_EVENT_WXX.IS_KEY_PROCESS is '是否关键工序'
/

comment on column TEST_EVENT_WXX.BEGIN_TIME is '事件开始时间'
/

create unique index TEST_EVENT_WXX_EVENT_ID_PHENOMENON_CODE_SECOND_EVENT_CODE_FIRST_EVENT_CODE_TENANT_ID_UINDEX
    on TEST_EVENT_WXX (EVENT_ID, PHENOMENON_CODE, SECOND_EVENT_CODE, FIRST_EVENT_CODE, TENANT_ID)
/

create index TEST_EVENT_WXX_STATUS_INDEX
    on TEST_EVENT_WXX (STATUS)
/

create index TEST_EVENT_WXX_SUBMIT_USER_ID_INDEX
    on TEST_EVENT_WXX (SUBMIT_USER_ID)
/