Wednesday, 25 July 2018
Tuesday, 17 April 2018
Quickest Print Friendly in Oracle APEX
Quickest Print Friendly in Oracle APEX
Video Tutorial Link: https://youtu.be/_Jua7CGfOWc
Classic Reports print code
-------------------------------------
//// Collapse Left Navigation Bar If It Was Expanded ////
var navCollapsed = 0;
if ($("body").hasClass("js-navExpanded")) {
$("#t_Button_navControl").click();
navCollapsed = 1;
};
setTimeout(3000);
//////// Hide ////////
//Hide Navigation Bar List
$("#t_Header").hide();
//Hide Navigation Menu
$("#t_Body_nav").hide();
//Hide Breadcrumb
$("#t_Body_title").hide();
//Hide Content Offset
$("#t_Body_content_offset").hide();
//Hide Report Column Edit Link
$(".apex-edit-page").hide();
//Hide Report Download Links
$(".t-Report-links").hide();
//Hide Buttons
$(".t-Button").hide();
//Hide Footer
$(".t-Footer").hide();
//////// Browser Print ////////
window.print();
//////// Show ////////
//Show Navigation Bar List
$("#t_Header").show();
//Show Navigation Menu
$("#t_Body_nav").show();
//Show Breadcrumb
$("#t_Body_title").show();
//Show Content Offset
$("#t_Body_content_offset").show();
//Show Report Column Edit Link
$(".apex-edit-page").show();
//Show Report Download Links
$(".t-Report-links").show();
//Show Buttons
$(".t-Button").show();
//Show Footer
$(".t-Footer").show();
//// Expand Left Navigation Bar If It Was Colapsed ////
if ( navCollapsed = 1 ) {
$("#t_Button_navControl").click();
}
Interactive Reports print code
----------------------------------------------
//// Collapse Left Navigation Bar If It Was Expanded ////
var navCollapsed = 0;
if ($("body").hasClass("js-navExpanded")) {
$("#t_Button_navControl").click();
navCollapsed = 1;
};
setTimeout(3000);
//////// Hide ////////
//Hide Navigation Bar List
$("#t_Header").hide();
//Hide Navigation Menu
$("#t_Body_nav").hide();
//Hide Breadcrumb
$("#t_Body_title").hide();
//Hide Content Offset
$("#t_Body_content_offset").hide();
//Hide Interactive Report Search Bar
$(".a-IRR-toolbar").hide();
//Hide Report Link Column Header
$("#LINK").hide();
//Hide Report Link Column Elements
$('td[headers="LINK"]').hide();
//Hide Buttons
$(".t-Button").hide();
//Hide Footer
$(".t-Footer").hide();
//////// Browser Print ////////
window.print();
//////// Show ////////
//Show Navigation Bar List
$("#t_Header").show();
//Show Navigation Menu
$("#t_Body_nav").show();
//Show Breadcrumb
$("#t_Body_title").show();
//Show Content Offset
$("#t_Body_content_offset").show();
//Show Interactive Report Search Bar
$(".a-IRR-toolbar").show();
//Show Report Link Column Header
$("#LINK").show();
//Show Report Link Column Elements
$('td[headers="LINK"]').show();
//Show Buttons
$(".t-Button").show();
//Show Footer
$(".t-Footer").show();
//// Expand Left Navigation Bar If It Was Colapsed ////
if ( navCollapsed = 1 ) {
$("#t_Button_navControl").click();
}
Form Print code
----------------------------------
//// Collapse Left Navigation Bar If It Was Expanded ////
var navCollapsed = 0;
if ($("body").hasClass("js-navExpanded")) {
$("#t_Button_navControl").click();
navCollapsed = 1;
};
setTimeout(3000);
//////// Hide ////////
//Hide Navigation Bar List
$("#t_Header").hide();
//Hide Navigation Menu
$("#t_Body_nav").hide();
//Hide Breadcrumb
$("#t_Body_title").hide();
//Hide Content Offset
$("#t_Body_content_offset").hide();
//Hide Buttons
$(".t-Button").hide();
//Hide Footer
$(".t-Footer").hide();
////Print Preview Call////
window.print();
//////// Show ////////
//Show Navigation Bar List
$("#t_Header").show();
//Show Navigation Menu
$("#t_Body_nav").show();
//Show Breadcrumb
$("#t_Body_title").show();
//Show Content Offset
$("#t_Body_content_offset").show();
//Show Buttons
$(".t-Button").show();
//Show Footer
$(".t-Footer").show();
//// Expand Left Navigation Bar If It Was Colapsed ////
if ( navCollapsed = 1 ) {
$("#t_Button_navControl").click();
}
|
Thursday, 15 March 2018
Runtime Alert Message in Oracle APEX
Runtime Alert Message in Oracle APEX
Video Tutorial Link : https://youtu.be/ttxSFm3jSp4
Plugin Download Link
https://drive.google.com/open?id=1psw2f_VbXoDpINClVUjRpaP7Kort-Er9
Output
Video Tutorial Link : https://youtu.be/ttxSFm3jSp4
Plugin Download Link
https://drive.google.com/open?id=1psw2f_VbXoDpINClVUjRpaP7Kort-Er9
Output
Tuesday, 13 March 2018
Covert Number English to Bangla for Oracle APEX
Covert Number English to Bangla for Oracle APEX
Code
create or replace FUNCTION ennumber2bnnumber (in_value NUMBER) RETURN VARCHAR2 IS p_num VARCHAR2 (100) := TO_CHAR (in_value); p_char CHAR (1); o_str NUMBER := 14722982; V_A VARCHAR2 (500); BEGIN /*************************************************** * This function was created by Md. Arif Hossain * ***************************************************/ FOR i IN 1 .. LENGTH (p_num) LOOP p_char := SUBSTR (p_num, i, 1); IF p_char = '.' THEN o_str := 46; ELSE o_str := 14722982 + TO_NUMBER (p_char); END IF; V_A := V_A || CHR (o_str); END LOOP; -- 14722982. RETURN V_A; END;
Video Link: https://youtu.be/QE5yjACicAs
Output
Sunday, 11 March 2018
Google Location Tracking - Oracle APEX
Google Location Tracking - Oracle APEX
https://apex.oracle.com/pls/apex/f?p=JK64_SIMPLE_MAP&c=JK64
Video Link: https://youtu.be/DSNuTKawZYU
Google Places Autocomplete
https://apex.oracle.com/pls/apex/f?p=136441:LOGIN_DESKTOP:4500271432685:::::
Simple Map
https://apex.oracle.com/pls/apex/f?p=JK64_SIMPLE_MAP&c=JK64
Subscribe to:
Posts (Atom)


