Oracle APEX 经典报表中的Checkbox

WU CHUNYU

已于 2025-08-23 09:32:52 修改

阅读量130

点赞数 5

CC 4.0 BY-SA版权

分类专栏： Oracle APEX 文章标签： Oracle APEX

于 2025-08-22 11:32:34 首次发布

本文链接：https://blog.csdn.net/wuchunyu002/article/details/150605811

Oracle APEX 专栏收录该内容

15 篇文章

订阅专栏

2-4. Function and Global Variable Declaration

2-5. Execute when Page Loads

2-6. Process

3. 运行效果编辑

1. 建表＆投入测试数据

CREATE TABLE CONTRACT_YEAR_SETTING (
    BU_CODE        VARCHAR2(2 CHAR)
  , BU_NAME        VARCHAR2(500 CHAR)
  , YEAR           NUMBER(4)
  , STATUS         VARCHAR2(30)
  , START_DATE     DATE
  , END_DATE       DATE
);
/
INSERT INTO CONTRACT_YEAR_SETTING VALUES('02', '医学部_01',2024,'O',TO_DATE('2024-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2024-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO CONTRACT_YEAR_SETTING VALUES('03', '医学部_02',2024,'O',TO_DATE('2024-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2024-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO CONTRACT_YEAR_SETTING VALUES('10', '医学部_10',2024,'O',TO_DATE('2024-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2024-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO CONTRACT_YEAR_SETTING VALUES('02', '医学部_01',2025,'O',TO_DATE('2025-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2025-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO CONTRACT_YEAR_SETTING VALUES('03', '医学部_02',2025,'O',TO_DATE('2025-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2025-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO CONTRACT_YEAR_SETTING VALUES('10', '医学部_10',2025,'O',TO_DATE('2025-01-01 12:34:56','YYYY-MM-DD HH24:MI:SS'),TO_DATE('2025-12-01 12:34:56','YYYY-MM-DD HH24:MI:SS'));
COMMIT;

2. 经典报表做成

2-1. 画面布局如下

2-2. 报表使用的SQL

select APEX_ITEM.CHECKBOX2(1,ROWID,'class="row-checkbox"') as RS,
       BU_CODE,
       BU_NAME,
       YEAR,
       DECODE(STATUS,'O','オーペン','C','クロース','') AS STATUS,
       START_DATE,
       END_DATE
  from CONTRACT_YEAR_SETTING cys
 where (:P3003_YEAR IS NULL OR cys.YEAR = :P3003_YEAR)
 order by cys.BU_CODE, cys.YEAR

2-3. RS列的Heading设定

<input type="checkbox" id="selectAll" onclick="toggleSelectAll(this)">

2-4. Function and Global Variable Declaration

function toggleSelectAll(checkbox) {
    $('.row-checkbox').prop('checked', checkbox.checked);
}
function initCheckboxSync() {
  $('#selectAll').click(function() {
    var isChecked = $(this).prop('checked');
    $('.row-checkbox').prop('checked', isChecked).trigger('change');
  });

  $('.row-checkbox').change(function() {
    updateHeaderState();
    updateSelectedItems();
  });
  updateHeaderState();
}
function updateHeaderState() {
  var total = $('.row-checkbox').length;
  var checked = $('.row-checkbox:checked').length;
  $('#selectAll')
    .prop('checked', checked === total)
    .prop('indeterminate', false);
}

2-5. Execute when Page Loads

initCheckboxSync();

2-6. Process

DECLARE
    lt_selected_ids    apex_application_global.vc_arr2;
    lv_status          CONTRACT_YEAR_SETTING.STATUS%type;
BEGIN
    lt_selected_ids := apex_application.g_f01;

    if lt_selected_ids.COUNT = 0 then
        apex_error.add_error (
            p_message          => 'No rows are selected or updated.',
            p_display_location => apex_error.c_inline_in_notification );
        return;
    end if;
    FOR i IN 1..lt_selected_ids.COUNT LOOP
        SELECT STATUS
          INTO lv_status
          FROM CONTRACT_YEAR_SETTING
         WHERE ROWID = lt_selected_ids(i);
        
        IF lv_status = 'C' THEN
            UPDATE CONTRACT_YEAR_SETTING
               SET STATUS = 'O'
             WHERE ROWID = lt_selected_ids(i);
        ELSE
            UPDATE CONTRACT_YEAR_SETTING
               SET STATUS = 'C'
             WHERE ROWID = lt_selected_ids(i);
        END IF;
    END LOOP;
    COMMIT;
END;