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:
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
(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
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