Sunday, 16 February 2020

Profile Card hover over it once

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

Table


CREATE TABLE PROFILE(
ID NUMBER,
NAME VARCHAR2(50),
YOUTUBE_LINK VARCHAR2(100),
FACEBOOK_LINK VARCHAR2(100),
TWITTER_LINK VARCHAR2(100),
IMAGE BLOB);

Query 


select ID,
       NAME NAME,
       YOUTUBE_LINK,
       FACEBOOK_LINK,
       TWITTER_LINK,
        decode(nvl(dbms_lob.getlength(IMAGE),0),0,null,
       '<img class="fancybox" alt="'||apex_escape.html_attribute(ID)||'" title="'||apex_escape.html_attribute(ID)
              ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
              ||'src="'||apex_util.get_blob_file_src('P17_IMAGE',ROWID)||'" height="75" width="75" />
      ') IMAGE
  from PROFILE


HTML

 <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css">
<div class="image-area">
<div class="img-wrapper">
#IMAGE#
<h2>#NAME#</h2>
<ul>
<li><a href=#GIT#><i class="fab fa-github"></i></a></li>
<li><a href=#INS#><i class="fab fa-instagram"></i></a></li>
<li><a href=#TWITTER_LINK#><i class="fab fa-twitter"></i></a></li>
<li><a href=#YOUTUBE_LINK#><i class="fab fa-youtube"></i></a></li>
<li><a href=#FACEBOOK_LINK#><i class="fab fa-facebook"></i></a></li>
</ul>
</div>
</div>




CSS



*

.image-area{ top: 50%; left: 50%; transform: translate(-50%, -50%); position: absolute;}
.img-wrapper{ width: 300px; height: 400px; position: relative; overflow: hidden;}
.img-wrapper:before{ content: ''; position: absolute; top: 0; left: 180%; height: 100%; width: 100%; background: rgba(255,255,255,.3); z-index: 1; transform: skew(45deg); transition: .5s;}
.img-wrapper:hover:before{ left: -180%;}
.img-wrapper img{ height: 400px; width: 300px; filter: grayscale(100%); transition: 2s;}.img-wrapper:hover img{ filter: grayscale(0%); transform: scale(1.1);}
.img-wrapper h2{ background: tomato; font-family: Poppins; color: #fff; text-align: center; text-transform: uppercase; margin: 0; padding: 10px 0; position: absolute; bottom: 0; width: 100%; transform: perspective(400px) rotateY(90deg); transform-origin: right; transition: 1s;}
.img-wrapper:hover h2{ transform: perspective(400px) rotateY(0deg);}
.img-wrapper ul{ position: absolute; top: 0; left: 0; margin: 0; padding: 0; list-style: none; background: rgba(255,255,255,0);}
.img-wrapper ul li{ background: #333; height: 40px; width: 40px; text-align: center; line-height: 40px; transform: perspective(800px) rotateY(90deg); transition: .5s; transform-origin: left;}
.img-wrapper:hover ul li{ transform: perspective(800px) rotateY(0deg);}
.img-wrapper:hover ul li:nth-child(1){ transition-delay: .2s;}
.img-wrapper:hover ul li:nth-child(2){ transition-delay: .6s;}
.img-wrapper:hover ul li:nth-child(3){ transition-delay: .8s;}
.img-wrapper:hover ul li:nth-child(4){ transition-delay: 1s;}
.img-wrapper ul li a{ color: tomato; background: rgba(255,255,255,0);}
.img-wrapper ul li i{ color: tomato; background: rgba(255,255,255,0);}
.img-wrapper ul li i:hover{ color: #fff; background: rgba(255,255,255,0);}

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>































Wednesday, 25 July 2018

Oracle APEX - Barcode create in Oracle APEX

Oracle APEX - Barcode create in Oracle APEX



Check this video 

  https://youtu.be/9OuyOhWuhSA


Tuesday, 17 April 2018

Quickest Print Friendly in Oracle APEX