Oracle APEX: Generic Hierarchy Trees,Attachments,Adjust Side Panels,Multi Language Templates,Map.
[email protected] - Team Leader Oracle ERP/APEX/Web Developer.
Generic Hierarchy Trees Application with Content Management. Oracle APEX5.1 and higher.
This is a generic Application for Hierarchy Trees or related Master-Detail data.
This Application is fully responsive - works both on Mobile and Desktop Browsers.
Freezed Tool Panel with Icons and Search Block will help You to navigate and manage the Tree.
Clicking on the Search Button will focus on next relevant Node.
In one place manage Hierarchy Trees, Tree Nodes with maximum visualization and detailed Information on each level.
Choose Node Icons with Icon Picker with preview.
This App also includes Generic Tree Nodes LOV with Single or Multi nodes selection.
APEX Objects/Functionality Involved:
Interactive Grid : ig_toolbar
Tree: find(apex.region("genTree").widget(), nodeIndex);
$("button.t-Button--hideShow")[1].getAttribute("aria-expanded")
trigger("apexrefresh")
$(".apex-rds").data("onRegionChange",function(mode,activeTab)
$('.apex-rds').data().apexATabs.activeTab.href
apex.jQuery("#genTree div[role='tree']").treeView("getSelectedNodes")
Draggable Menu and Summary Side Panels Application. Oracle APEX 5.1 and higher.
In this Application I have implemented Drag & Drop Functionality that is supported both on Mobile and Desktop versions.
There is a Close/Open state, fully controlled panel width. Using Cookies the component remembers the last selected
Positions of Left Menu and Right Summary Panels.
So You can adjust the panels width using your fingers on Mobile or mouse on Desktop Browser.
APEX Objects/Functionality Involved:
Customized:
Implemented: Mobile_JQry_DragAndDrop.js
$('#RightSplitter').draggable
$(document).ready
Global Page
Expand / Collapse Navigation,Expand / Collapse Side Column
$("#t_Body_nav").width
$("#t_Body_actions").width
$(window).trigger("apexwindowresized");
$("#t_PageBody"),$("#t_TreeNav"), $(".t-Body-actionsContent"), $("#t_Button_navControl")
jQuery.uaMatch( navigator.userAgent );
apex.storage.getCookie
$('#t_Button_navControl').unbind('click');
observer.observe(target, options);
event.stopPropagation();
Generic Attachments Utility Application. Oracle APEX 5.1 and higher.
The Component is reusable and easy to use.
On the Attachment Button there is an indication of how many files are attached to current Entity.
Upload,Download,View and Delete Attachments in intuitive and simple way.
APEX Objects/Functionality Involved:
apex_page.get_url
(
p_application =＞ 158,
p_page =＞ 210,
p_items =＞ 'P210_TABLE_NAME,P210_PK1,P210_PK2',
p_values =＞ 'ALXB_APEX_GEN_TREE_NODES,'||:P5_TREE_ID||','||:P5_NODE_ID,
p_clear_cache =＞ 'RP,210'
)
Generic Multi Language Mail/Message or any other Templates Application. Oracle APEX 5.1 and higher.
In case the Organization has a multiple branches located in different countries, it is highly recommended to use this Application.
One Template Row can be translated in any Language and it supports LTR and RTL page alignments.
Right-To-Left / Left-To-Right
Right to Left Languages:
Hebrew,Arabic,Aramaic,Azeri,Dhivehi,Fula,Kurdish,N'Ko,Persian,Rohingya,Syriac,Urdu..
Accordingly to selected Language from LOV(located on the upper Toolbar) the Application will automatically switch
to chosen Template Language Row and change to relevant Page Alignment.
The main Template component of this Application is RTE(Rich Text Editor).
You can easily design Dynamic Logos,Images,Tables and any other HTML content combining them with dynamic Bind Variables.
Click Preview to Immediately view generated (parsed) result.
In Preview mode You can send the generated output to mail for final testing.
Bonus for Developers - to make your life easier: Generate Parameters/SQL Block
APEX Objects/Functionality Involved:
DIR=RTL
apex-item-wrapper--rich-text-editor
Select Language LOV
Region Display Selector
Application: On The Map. Oracle APEX 5.1 and higher.
This Application demonstrates how You can search the table data with distance calculation and visually see the results in integrated Google Map.
So in This Sample we will see the integration between Interactive Report and Google Map.
First You need to give the browser permission to know your current location or enter manually the desired Address location.
Use Range Slider component to filter the results by defining distance radius parameter.
The selected rows will be displayed as Location Markers on the Map.
APEX Objects/Functionality Involved:
https://maps.googleapis.com/maps/api/...
google.maps.LatLng;
navigator.geolocation.getCurrentPosition
google.maps.Marker
Bounds.extend
Geocoder.geocode
google.maps.GeocoderStatus.OK
[email protected] - Team Leader Oracle ERP/APEX/Web Developer