Friday 20 September 2019

APEX Animation Menu

APEX Animation Menu



<style>
/* START OF DEMO CSS - NOT NEEDED */
html, body { height: 100% } /* BODY BACKGROUND IMAGE DOESNT ALWAYS REACH THE BOTTOM OF THE BROWSER*/
body {
background-color: rgb(100, 100, 100);
background-repeat: no-repeat;
background-position: center center;
background-size: cover;
color: rgb(255, 255, 255);
}
.white-background {
background-color: rgb(255, 255, 255);
color: rgb(51, 51, 51);
padding-top: 10px;
border-radius: 4px;
}
.title {
font-size: 3em;
font-weight: 700;
text-shadow: 0px 0px 5px rgb(51, 51, 51);
text-shadow: 0px 0px 5px rgba(51, 51, 51, 0.8);
text-align: center;
}
#fullscreen {
    position: fixed;
    top: 10px;
    right: 10px;
}
/* END OF DEMO CSS */

    .animate {
-webkit-transition: all 0.3s ease-in-out;
-moz-transition: all 0.3s ease-in-out;
-o-transition: all 0.3s ease-in-out;
-ms-transition: all 0.3s ease-in-out;
transition: all 0.3s ease-in-out;
}

.navbar-fixed-left {
position: fixed;
top: 0px;
left: 0px;
border-radius: 0px;
}

.navbar-minimal {
width: 60px;
min-height: 60px;
max-height: 100%;
background-color: rgb(51, 51, 51);
background-color: rgba(51, 51, 51, 0.8);
border-width: 0px;
z-index: 1000;
}

.navbar-minimal > .navbar-toggler {
position: relative;
min-height: 60px;
border-bottom: 1px solid rgb(81, 81, 81);
z-index: 100;
cursor: pointer;
}

.navbar-minimal.open > .navbar-toggler,
.navbar-minimal > .navbar-toggler:hover {
background-color: rgb(158, 202, 59);
}

.navbar-minimal > .navbar-toggler > span {
position: absolute;
top: 50%;
right: 50%;
margin: -8px -8px 0 0;
width: 16px;
height: 16px;
background-image: url(data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz4KPCEtLSBHZW5lcmF0b3I6IEFkb2JlIElsbHVzdHJhdG9yIDE2LjIuMSwgU1ZHIEV4cG9ydCBQbHVnLUluIC4gU1ZHIFZlcnNpb246IDYuMDAgQnVpbGQgMCkgIC0tPgo8IURPQ1RZUEUgc3ZnIFBVQkxJQyAiLS8vVzNDLy9EVEQgU1ZHIDEuMS8vRU4iICJodHRwOi8vd3d3LnczLm9yZy9HcmFwaGljcy9TVkcvMS4xL0RURC9zdmcxMS5kdGQiPgo8c3ZnIHZlcnNpb249IjEuMSIgaWQ9IkxheWVyXzEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiIHg9IjBweCIgeT0iMHB4IgoJIHdpZHRoPSIxNnB4IiBoZWlnaHQ9IjMycHgiIHZpZXdCb3g9IjAgMCAxNiAzMiIgZW5hYmxlLWJhY2tncm91bmQ9Im5ldyAwIDAgMTYgMzIiIHhtbDpzcGFjZT0icHJlc2VydmUiPgo8cGF0aCBmaWxsLXJ1bGU9ImV2ZW5vZGQiIGNsaXAtcnVsZT0iZXZlbm9kZCIgZmlsbD0iI0ZGRkZGRiIgZD0iTTEsN2gxNGMwLjU1MiwwLDEsMC40NDgsMSwxcy0wLjQ0OCwxLTEsMUgxQzAuNDQ4LDksMCw4LjU1MiwwLDgKCVMwLjQ0OCw3LDEsN3oiLz4KPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGZpbGw9IiNGRkZGRkYiIGQ9Ik0xLDEyaDE0YzAuNTUyLDAsMSwwLjQ0OCwxLDFzLTAuNDQ4LDEtMSwxSDFjLTAuNTUyLDAtMS0wLjQ0OC0xLTEKCVMwLjQ0OCwxMiwxLDEyeiIvPgo8cGF0aCBmaWxsLXJ1bGU9ImV2ZW5vZGQiIGNsaXAtcnVsZT0iZXZlbm9kZCIgZmlsbD0iI0ZGRkZGRiIgZD0iTTEsMmgxNGMwLjU1MiwwLDEsMC40NDgsMSwxcy0wLjQ0OCwxLTEsMUgxQzAuNDQ4LDQsMCwzLjU1MiwwLDMKCVMwLjQ0OCwyLDEsMnoiLz4KPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGZpbGw9IiNGRkZGRkYiIGQ9Ik0xLjMzLDI4Ljk3bDExLjY0LTExLjY0YzAuNDU5LTAuNDU5LDEuMjA0LTAuNDU5LDEuNjYzLDAKCWMwLjQ1OSwwLjQ1OSwwLjQ1OSwxLjIwNCwwLDEuNjYzTDIuOTkzLDMwLjYzM2MtMC40NTksMC40NTktMS4yMDQsMC40NTktMS42NjMsMEMwLjg3MSwzMC4xNzQsMC44NzEsMjkuNDMsMS4zMywyOC45N3oiLz4KPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGZpbGw9IiNGRkZGRkYiIGQ9Ik0yLjk5MywxNy4zM2wxMS42NDEsMTEuNjRjMC40NTksMC40NTksMC40NTksMS4yMDQsMCwxLjY2MwoJcy0xLjIwNCwwLjQ1OS0xLjY2MywwTDEuMzMsMTguOTkzYy0wLjQ1OS0wLjQ1OS0wLjQ1OS0xLjIwNCwwLTEuNjYzQzEuNzg5LDE2Ljg3MSwyLjUzNCwxNi44NzEsMi45OTMsMTcuMzN6Ii8+Cjwvc3ZnPgo=);
background-repeat: no-repeat;
background-position: 0 0;
-webkit-transition: -webkit-transform .3s ease-out 0s;
-moz-transition: -moz-transform .3s ease-out 0s;
-o-transition: -moz-transform .3s ease-out 0s;
-ms-transition: -ms-transform .3s ease-out 0s;
transition: transform .3s ease-out 0s;
-webkit-transform: rotate(0deg);
-moz-transform: rotate(0deg);
-o-transform: rotate(0deg);
-ms-transform: rotate(0deg);
transform: rotate(0deg);
}

.navbar-minimal > .navbar-menu {
position: absolute;
top: -1000px;
left: 0px;
margin: 0px;
padding: 0px;
list-style: none;
z-index: 50;
background-color: rgb(51, 51, 51);
background-color: rgba(51, 51, 51, 0.8);
}
.navbar-minimal > .navbar-menu > li {
margin: 0px;
padding: 0px;
border-width: 0px;
height: 54px;
}
.navbar-minimal > .navbar-menu > li > a {
position: relative;
display: inline-block;
color: rgb(255, 255, 255);
padding: 20px 23px;
text-align: left;
cursor: pointer;
border-bottom: 1px solid rgb(81, 81, 81);
width: 100%;
text-decoration: none;
margin: 0px;
}

.navbar-minimal > .navbar-menu > li > a:last-child {
border-bottom-width: 0px;
}
.navbar-minimal > .navbar-menu > li > a:hover {
background-color: rgb(158, 202, 59);
}
.navbar-minimal > .navbar-menu > li > a > .glyphicon {
float: right;
}

.navbar-minimal.open {
width: 320px;
}

.navbar-minimal.open > .navbar-toggler > span {
background-position: 0 -16px;
-webkit-transform: rotate(-180deg);
-moz-transform: rotate(-180deg);
-o-transform: rotate(-180deg);
-ms-transform: rotate(-180deg);
transform: rotate(-180deg);
}

.navbar-minimal.open > .navbar-menu {
top: 60px;
width: 100%;
min-height: 100%;
}

@media (min-width: 768px) {
.navbar-minimal.open {
width: 60px;
}
.navbar-minimal.open > .navbar-menu {
overflow: visible;
}
.navbar-minimal > .navbar-menu > li > a > .desc {
position: absolute;
display: inline-block;
top: 50%;
left: 130px;
margin-top: -20px;
margin-left: 20px;
text-align: left;
white-space: nowrap;
padding: 10px 13px;
border-width: 0px !important;
background-color: rgb(51, 51, 51);
background-color: rgba(51, 51, 51, 0.8);
opacity: 0;
}
.navbar-minimal > .navbar-menu > li > a > .desc:after {
z-index: -1;
position: absolute;
top: 50%;
left: -10px;
margin-top: -10px;
content:'';
width: 0;
height: 0;
border-top: 10px solid transparent;
border-bottom: 10px solid transparent;
border-right: 10px solid rgb(51, 51, 51);
border-right-color: rgba(51, 51, 51, 0.8);
}
.navbar-minimal > .navbar-menu > li > a:hover > .desc {
left: 60px;
opacity: 1;
}
}
</style>
<link href="//netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.0/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<!------ Include the above in your HEAD tag ---------->

    <nav class="navbar navbar-fixed-left navbar-minimal animate" role="navigation">
<div class="navbar-toggler animate">
<span class="menu-icon"></span>
</div>
<ul class="navbar-menu animate">
<li>
<a href="#about-us" class="animate">
<span class="desc animate"> Who We Are </span>
<span class="glyphicon glyphicon-user"></span>
</a>
</li>
<li>
<a href="#blog" class="animate">
<span class="desc animate"> What We Say </span>
<span class="glyphicon glyphicon-info-sign"></span>
</a>
</li>
<li>
<a href="#contact-us" class="animate">
<span class="desc animate"> How To Reach Us </span>
<span class="glyphicon glyphicon-comment"></span>
</a>
</li>
</ul>
</nav>

</div>
<a href="http://bootsnipp.com/iframe/PbDb5" class="btn btn-primary" id="fullscreen" data-toggle="tooltip" data-placement="left" title="Full Screen"><span class="glyphicon glyphicon-fullscreen">
</span></a>

Tuesday 7 May 2019

JQuery With Oracle APEX

JQuery With Oracle APEX 19.1

Video Link: https://youtu.be/ux9dcKfo5jk


Table
---------------------------
CREATE TABLE  "EBA_DEMO_IG_EMP" 
   ( "EMPNO" NUMBER NOT NULL ENABLE, 
 "ENAME" VARCHAR2(60), 
 "JOB" VARCHAR2(9), 
 "MGR" NUMBER, 
 "HIREDATE" DATE, 
 "SAL" NUMBER(7,2), 
 "COMM" NUMBER(7,2), 
 "ONLEAVE" VARCHAR2(1) NOT NULL ENABLE, 
 "NOTES" VARCHAR2(1000), 
 "DEPTNO" NUMBER, 
 "FLEX1" VARCHAR2(1000), 
 "FLEX2" VARCHAR2(1000), 
 "FLEX3" VARCHAR2(1000), 
 "FLEX4" VARCHAR2(1000), 
 "RATING" NUMBER

   )
/


Pl Content Script
-----------------------------------

begin

htp.p('<input id="myInput" type="text" placeholder="Search..">');

htp.p('<style type="text/css">
  /*header table 1 css*/
  #table_1 h3{
   font-size: 30px;
   margin:0px;
  }
  #table_1 tr td{
   font-size: 20px;
  }
  #table_3, 
  #table_3 td{
   border: 1px solid black;
    border-collapse: collapse;
  }
  

 </style>');
    
    htp.p('<table id="table_1" width="100%" style="text-align: center;">
  <thead><tr>
   <td><h3>Oracle APEX Bangladesh</h3></td></tr></thead>
            <thead><tr>
   <td>Chittagong</td></tr></thead>
            <thead><tr>
   <td><ul>Employee Report</ul></td></tr></thead>');
            htp.p('</table>');


 htp.p('<table id="table_3" width="100%"   cellpadding="5px" style="text-align: center;">
          <thead><td>Emp NO</td>
          <td>Employee name</td>
          <td>Job </td>
          <td>Mgr </td></td>');
          
         for x in (select empno,ename,job,mgr from EBA_DEMO_IG_EMP)
         loop
         htp.p('<tbody id="myTable"><tr>
   <td>'||htf.escape_sc(x.empno)||'</td>
               <td>'||htf.escape_sc(x.ename)||'</td>
                 <td>'||htf.escape_sc(x.job)||'</td>
                        <td>'||htf.escape_sc(x.mgr)||'</td></tr></tbody>');
        end loop; 
          htp.p('</table>');
                         htp.p('</div>');
         end;


Copy and Past in Page Header

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
<script>
$(document).ready(function(){
  $("#myInput").on("keyup", function() {
    var value = $(this).val().toLowerCase();
    $("#myTable tr").filter(function() {
      $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
    });
  });
});
</script>