How to create cool Dashboard in Oracle Apex by using Template

 


At first go to Shared Components and click the Template-

Step 1: COPY Template "Value Attribute Pairs - Row" and name as "system_dash" -->

Step 2: Row Template 1(Value Required)---->

<div class="javainhand #CONTAINER_CLASS#">    

<div class="circle-tile ">

        <a href="#LINK#"><div class="circle-tile-heading #CLASS1#"><i class="fa #ICON_CLASS#"></i></div></a>

        <div class="circle-tile-content #CLASS2#">

          <div class="circle-tile-description text-faded">#TITLE#</div>

          <div class="circle-tile-number text-faded ">#DATA#</div>

          <a class="circle-tile-footer" href="#LINK#">More Info<i class="fa fa fa-chevron-circle-right"></i></a>

        </div>

      </div>

</div>


Step 3:------------inline css--

.javainhand {

   float: right;

    height: -22px;

    margin-right: 1%;

    padding: 10px;

    position: relative;

    width: 24%;

    

}

.circle-tile {

    margin-bottom: 15px;

    text-align: center;

}

.circle-tile-heading {

    border: 3px solid rgba(255, 255, 255, 0.3);

    border-radius: 100%;

    color: #FFFFFF;

    height: 80px;

    margin: 0 auto -40px;

    position: relative;

    transition: all 0.3s ease-in-out 0s;

    width: 80px;

}

.circle-tile-heading .fa {

    line-height: 80px;

}

.circle-tile-content {

    padding-top: 50px;

       border-radius: 5px;

    margin: 5px;

}

.circle-tile-number {

    font-size: 26px;

    font-weight: 700;

    line-height: 1;

    padding: 5px 0 15px;

}

.circle-tile-description {

    text-transform: capitalize;

.circle-tile-footer {

    background-color: rgba(0, 0, 0, 0.1);

    color: rgba(255, 255, 255, 0.5);

    display: block;

    padding: 5px;

    transition: all 0.3s ease-in-out 0s;

}

.circle-tile-footer:hover {

    background-color: rgba(0, 0, 0, 0.2);

    color: rgba(255, 255, 255, 0.5);

    text-decoration: none;

}

.circle-tile-heading.dark-blue:hover {

    background-color: #2E4154;

}

.circle-tile-heading.green:hover {

    background-color: #138F77;

}

.circle-tile-heading.orange:hover {

    background-color: #DA8C10;

}

.circle-tile-heading.blue:hover {

    background-color: #2473A6;

}

.circle-tile-heading.red:hover {

    background-color: #B71C1C;

}

.circle-tile-heading.purple:hover {

    background-color: #7F3D9B;

}

.tile-img {

    text-shadow: 2px 2px 3px rgba(0, 0, 0, 0.9);

}


.dark-blue {

    background-color: #34495E;

}

.green {

    background-color: #2E7D32;

}

.blue {

    background-color: #2980B9;

}

.orange {

    background-color:#ffa000;

}

.red {

    background-color: #e53935;

}

.purple {

    background-color: #8E44AD;

}

.dark-gray {

    background-color: #7F8C8D;

}

.gray {

    background-color: #95A5A6;

}

.light-gray {

    background-color: #BDC3C7;

}

.yellow {

    background-color: #F1C40F;

}

.text-dark-blue {

    color: #34495E;

}

.text-green {

    color: #16A085;

}

.text-blue {

    color: #2980B9;

}

.text-orange {

    color: #F39C12;

}

.text-red {

    color: #E74C3C;

}

.text-purple {

    color: #8E44AD;

}


Step 4 : -- Now you take new Region and wright  Classic report query -->


select 1 as sort_order

, 'Total Employee' title

, EMPLOYEES  data

, 'fa-users fa-fw fa-3x' as icon_class

, 'blue' as class1

, 'blue' as class2

, '#' as LINK

from SYSTEM

union all

select 2 as sort_order

,'Total Suppliers' title

,SUPPLIERS  data

,'fa-user-md' as icon_class

,'red' as class1

,'red' as class2

,'#' as LINK

from SYSTEM

union all

select 3 as sort_order

,'Total Customer' title

,CUSTOMERS  data

,'fa-user fa-fw fa-3x' as icon_class

,'green' as class1

,'green' as class2

,'#' as LINK

from SYSTEM

union all

select 4 as sort_order

,'Total Departments' title

,DEPARTMENTS  data

,'fa fa-pie-chart' as icon_class

,'blue' as class1

,'blue' as class2

,'#' as LINK

from SYSTEM

Step 5 : Finally you go to Region "Attribute" and select Template "system_dash"

Post a Comment

Previous Post Next Post