субота, 26. мај 2018.

truck with zones

this oracle apex 18.1 version have dinamicaly actions, determinating time zone forms populated fileds enabling and disable each define advanced
Dinamicaly actions is same as build in apex 4 (only different presentation and positions on 18.1). In this examples exist cascade lov (working as previous version 4.x)

demo

https://apex.oracle.com/pls/apex/f?p=154620

web application for analysis horses races

This examples show visitors horse performances and have basic predictions
Idea is collect dates about horses and analyse performances, build with simple maste detail

demo
https://apex.oracle.com/pls/apex/f?p=73080
tracking for specific items with oracle apex 5.2

Reports need to track 4 dates and calculate differences betwen sent and returns, begin and end agreements. Idea is with extend loaded into blob attached documents (its 500-700 documents per year all with apps 1 mbytes) and with oracle 11g xe which is up to 11 gbytes should be posible.


demo

https://apex.oracle.com/pls/apex/f?p=142791

среда, 18. април 2018.

master detail oracle apex 5.1.x

Master detail oracle apex 5.1 have advanced options, older version apex (4.x/3.x) dont have, on one page could be put 2,3,4... interactive grid (known as tabular form on oldest apex version)
from master page (from master tables) user can view detail for every records( usefull in purchase order/ purchase order lines, invoices and invoice line, orders/order lines, Bill of Quantity / Bill Of quantity lines...all master - detailed situations)
I
theme 42 apex 5.1 have good performances with mozilla browsers (tablet, mobile ...) and apex users can get informations in any places.

Creating region with select type as interactive grid on design mode (not depretiotion mode) should be added details interactive grid with exactly row id selections.











недеља, 15. април 2018.

tracking contract for billing systems



Tracking contract values can be very usefull in billing systems, this example show how this work in oracle apex 5.1

https://apex.oracle.com/pls/apex/f?p=51562:17










CREATE OR REPLACE FORCE VIEW "DATA_RANGES" ("START_DATES", "DT", "FLEX002", "NUMBER_OF_PARTS", "R", "CODE_CO", "DEBT_VALUE_PER_MONTHS") AS
  with nums as
 (select level r from dual connect by level <= 9999)
select t.START_DATES,add_months(t.START_DATES, decode(FLEX002,'MONTH',1,'YEAR',12) * (r-1) ) dt,t.FLEX002,t.NUMBER_OF_PARTS, nums.r,t.CODE_CO,
((VALUE_CO-t.PARTICIPATION-t.ADD_VALUE)/t.NUMBER_OF_PARTS) as debt_value_per_months
 from contract t, nums
 where t.NUMBER_OF_PARTS >= nums.r
 order by t.START_DATES


this view -plan insert values into PLAN_TABLE with procedure calling in final steps in oracle apex form, as active transactions or not, shoud be changes in contract adding cnex of contract-thats reason


 Modal dialog is form for input new values for new contract, consist :
contract values, contract begin -date, contract end -date, number of months between start date and end date is equivalent of number of rates, participation values, if some pay initialy money

Model dialog looks
and with java script have calculations for populate fields








субота, 31. март 2018.

oracle apex 5.1.4 change clasical report to timeline

Gui give extend informations for some internal processing and have great visualisations for users on very simple way
 all version apex have this options, version 5.1.4 give mostly plug - in extends
and this is advanced options now with oracle 11g xe databases I m using for own manipulation of dates (import, sort, select updates inserting etc)

Switch from clasical select * from  view to timeline view :

субота, 23. септембар 2017.

demo apps apex 5.1.1 and 4.1.1 with jasper reports integrated

Apex 5.1.1 have powerfull design, I was compare demo apps from apex 4.1.1 and 5.1.1 part from orders with collection, trying to extend master detail reports with jasper with parameters from reports to form, on one click to pdf, connect to localy 127.0.0.1 hosts, not remotly ip address, this kind of reports development need backup and re-dmp database from remote server to localy, then transfer jrxml to remote folders structures, in this cases to tomcat folders.
Its tipicaly functionality of more erp systems, sales order, service requests, master detail BOM/BOQ, from now, from version 5.1.1 could be really erp system with all functionality, as have compiere or adempeire/idempiere..

 Reporting need consist with ptotos, so its important to change oracle blob data times from blob column to display images option

 next step is delete field (product_image) from detailed region in display, replacing it with images from palletes, which need be mapped to blob colum (product_image), its only need to do, iReport and oracle databases didn have equal data types, so its need be changeg, with this second step.
Next, need add additional parameters for filtering reasons and copu paste this jrxml to tomcat/reports folder(or glassfish /reports folder)  an of course in forms set MASTER_DETAIL_JASPER as report names and all 6 fields which need be populates with java script, if not, could be display all orders,a s pic above shown:

So nice, ist it, and secure, instead of I was built tis reporting with oracle 10g xe on 32 bytes os linux suse 11.3, one cpu 2ghz, 1 GB ram, my old laptop I m only use it for testing, connect to LAN, upgraded to 4.1.1 apex, and jasper reports 2 version with tomcat 6.29 jdk 1.6 0 24, only problem this scenario have is its slowly, and cant be pass more than 5 concurent client, procesor is too slowly and RAM ddr2 slowly too.

its same scenaio, with two version of apex, 4.1.1
and 5.1.1