среда, 27. јун 2018.

Oracle apex could very easily collect and for statisticaly purposes manipulate with huge data files collect from different sources in the world

Source: Data provided through GARPR 2014
Source: 2013 HIV Prevalence and Socio-behavioural Characteristics Among Men Who Have Sex with Men Across Seven Sites in Malawi
Source: 2013 Malawi Biological and Behavioural Surveillance Study (Preliminary Report)
Source: 2013 Malawi Biological and Behavioural Surveillance Study (Preliminary Results)
Source: Behavioural Surveillance Survey, 2013
Source: Data provided through GARPR 2014
Source: GARPR 2014
Source: Malawi MSM Final Report, 2014
Source: PHIA
Source: Spectrum
Source: UNAIDS special analysis
UNAIDS estimates.
UNAIDS_GAM_
UNAIDS_TGF_Data_
WHO MPHIA tables_2018
WHO THIS tables_2018
World Bank, International Comparison Program database.
World Health Organization Global Health Expenditure database ( 60 mbytes zip date)

Strong graphicaly functions give basic informations for different kind of reports


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

субота, 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 :