Printing Bar Code in Oracle Apex

Bar Code report in Oracle Apex




Steps:


1.  Download barcode font 

2. Upload the both .ttf & .woff font in Application > Shared Component > Static Application Files

3. Write the below code 
    a. Pages Designer > Javascript > Function and Global Variable Declaration

function printContent(el){
      var restorepage = $('body').html();
      var printcontent = $('#' + el).clone();
      $('body').empty().html(printcontent);
      window.print();
      $('body').html(restorepage);
      }

   b. Pages Designer > CSS > Inline

@font-face {  
 font-family: 'barcode';  
        src: url('#APP_IMAGES#Code39Azalea.ttf') format('truetype');  
        src: url('#APP_IMAGES#Code39Azalea.woff') format('woff');   
 font-weight: normal;  
 font-style: normal;  
} 

@font-face {
    font-family: "3 of 9 Barcode";
    src: url(#APP_IMAGES#FRE3OF9X.TTF) format("truetype");
    font-weight: normal;
    font-style: normal;
    }
.demo  
 {  
     font-family:'barcode',Code39;  
     width:200px;  
     margin:10px auto;  
     text-align:left;  
     padding:10px;  
     font-size:24pt; 
} 
.barCode 
{
     font-family:'barcode',Code39Azalea;  
     width:200px;  
     margin:10px auto;  
     text-align:left;  
     border:1px solid #666;  
     padding:10px;  
     font-size:24pt; 
}

 3. Make PL/SQL Dynamic content Region as sample below

begin
htp.p('<html>');
htp.p('<head>');
htp.p('<style>');

htp.p('@font-face {
    font-family: "barcode";
    src: url(#APP_IMAGES#Code39Azalea.ttf) format("truetype");
    font-weight: normal;
    font-style: normal;
    }
.demo1  
 {  
     font-family:''barcode'',Code39Azalea;       
     width:50px;  
     text-align:left;  
     font-size:40pt;    
}');

htp.p('</style>');htp.p('</head>');

      htp.p('Printing Barcode');
      htp.p('<br>'); htp.p('<br>'); htp.p('<br>');
      for i in (
      select '*12345*' tag from dual
      union
      select '*43543*' tag from dual
      union
      select '*45345*' tag from dual
      union
      select '*89089*' tag from dual
      union
      select '*76867*' tag from dual
      union
      select '*45645*' tag from dual
      union
      select '*23423*' tag from dual) 
  loop
     htp.p('<p class="demo1">'); htp.p(i.tag); htp.p('</p>'); 
     htp.p('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;');
                         htp.p('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;');
     htp.p(i.tag); htp.p('<br>');  
     htp.p('<b>'); htp.p('DESC: CPU DELL OPTIPLEX 9020 MT');  htp.p('<br>');  
     htp.p('MODEL: 2013');    htp.p('<br>');
     htp.p('S.NO: 7843A21DF');    htp.p('<br>');
     htp.p('<br>');htp.p('<br>'); htp.p('<br>');htp.p('<br>');
     htp.p('</b>'); htp.p('<br>');htp.p('<br>'); htp.p('</b>');
  end loop;
     htp.p('');
   end;

 

Comments

Post a Comment

Popular posts from this blog

Displaying Images in Oracle Apex

Image
Displaying Images in Oracle Apex Steps : 1. Create PL/SQL dynamic Content Region and write the code declare  cursor c1 is   select FILE_SHORT_INFO,emp_code from prtl_files where emp_code = :P8_empcd;  t varchar2(200); begin    for i in c1    loop     htp.p('<body>');htp.p('<p>&nbsp;</p>');        htp.p('<table width="100%">');         htp.p('<tr>');       for rec in (select * from PRTL_FILES                where emp_code = :P8_EMPCD and status='A')     loop       IF rec.ATT_MIMETYPE is not null or rec.ATT_MIMETYPE != '' THEN  htp.p('<td colspan="2">'); htp.p( '<img src="my_image_display?                          fid='||NVL(rec.FILE_ID,0)||'" height="'||100||'"/>' );    ...
Read more

Customize Apex Login

Image
How to customize Oracle Apex - Application Login Page Sometime i feel little dryness in Oracle Application login page, just like similar to below  While searching in internet i found below steps to change your login page appearances like below Application Express 18.1.0.00.45 Steps : 1. upload the files into your workspace Application Builder -- Shared Components - Static Application files  2. Write Below HTML - CSS code  in     a. Goto Page # 9999 (Default Login Page)     b. Goto Page Designer Property > CSS > Inline span.t-Login-logo { background-image: url(#APP_IMAGES#logo.jpg); background-size: cover; width: 400px; height: 204px; } .t-Body {   background: url(&APP_IMAGES.backround.jpg); } That's All, You can see nice login page during login.
Read more