Monday, October 25, 2021

ICON STATUS

 create table city_statuses
 (city_name varchar2(50),
  status1   varchar2(2),
    status2   varchar2(2),
    status3   varchar2(2)
  )
  
  insert into city_statuses
  values('Dhaka','1','0','-1')
  
  
  
  insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','-1','1','1')
    insert into city_statuses
  values('Dhaka','1','0','-1')
    insert into city_statuses
  values('Dhaka','1','0','-1')

 insert into city_statuses
  values('BARISHAL','1','0','-1')
  
  
  
  insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','-1','1','1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
    insert into city_statuses
  values('BARISHAL','1','0','-1')
  
  For the icons and modifiers, I used:
  • Success:  fa-check-circle-o u-success-text
  • Warning:  fa-exclamation-triangle u-warning-text
  • Error:  fa-exception u-danger-text
  SQL
  select city_name,
       status1,
       status2,
       status3,
       case status1 
           when '1' then 'fa-check-circle-o u-success-text'
           when '0' then 'fa-exclamation-triangle u-warning-text'
           when '-1' then 'fa-exception u-danger-text'
       end status1_icon,
       case status1 
           when '1'  then 'OK'
           when '0'  then 'Warning'
           when '-1' then 'Danger'
       end status1_description,        
       case status2 
           when '1'  then 'fa-check-circle-o u-success-text'
           when '0'  then 'fa-exclamation-triangle u-warning-text'
           when '-1' then 'fa-exception u-danger-text'
       end status2_icon,
       case status2 
           when '1'  then 'OK'
           when '0'  then 'Warning'
           when '-1' then 'Danger'
       end status2_description,                
       case status3 
           when '1'  then 'fa-check-circle-o u-success-text'
           when '0'  then 'fa-exclamation-triangle u-warning-text'
           when '-1' then 'fa-exception u-danger-text'
       end status3_icon,
       case status3 
           when '1'  then 'OK'
           when '0'  then 'Warning'
           when '-1' then 'Danger'
       end status3_description
 from city_statuses
  


Then, for the columns STATUS1, STATUS2 and STATUS3, in Page Designer I changed the property HTML Expression to:

<span class="fa #STATUS1_ICON#" title="#STATUS1_DESCRIPTION#"></span>

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...