понедељак, 22. новембар 2021.

 oracle apex 21.2 on oracle 21 c xe database Linux Centos 8 workstation (for laptops) instalations


pic 1 right click on mouse and run install


pic 2 centos 8 automaticaly install oracle 21 c xe and 21 pre instal rpm files




pic 3 after installation its need oracle be configured and need to type systemctl start oracle-xe-21c for automatically start after restart



pic 4 apex 21.2 is copy unzip on /root/apex folders and with export oracle home and oracle sid need run /opt/oracle/product/21c/dbhomeXE/bin sqlplus sys/pass@127.0.0.1:1521/xepdb1 as sysdba and @apexins sysaux sysaux temp /i/

and steps shown on pic 3 2,3 and i add 4 steps @apxrtins sysaux sysaux temp /i/

Most important is from sql run alter user apex_public_user account unlock

 

Pic 4 and static files path to image /root/i/   i - copy folder from apex images

and its important to run java (jdk 11) and orda need to be unziped into folder /root/ords and run from command line java -jar ords.war (before make ords.war executable) and put database parameters for ords. Every time when laptop is restarted its need type /root/ords java -jar ords.war. 

SQL offer LISTAG DISTINCT AGGREGATIONS its new function oracle 21 c XE database have!


pic 5 https://localhost:5500/em https://testtesttest.ddns.net:5500/em



четвртак, 4. фебруар 2021.

 

Electrical installation calculations:

 


 In first example I set 17 floors in house, barier direct D and ked 0.6 (no thermal

equipment in houses) and result give me 180 [mm2] 3 phases wire

 


When I change to enclosed type B there is 120 [mm2] conductors

 DEMO :

http://testtesttest.ddns.net:8282/ords/f?p=130

http://testtesttest.ddns.net:8383/apex/f?p=130:380

 


субота, 23. мај 2020.



                            ELECTRICAL DESIGN

Number of light lamps can be determinate with calculation using :

DEMO:
http://testtesttest.ddns.net:8383/apex/f?p=130


switchboard single line diagram




estimated values E
kitchen 250 [lx]
dayly room 250[lx]
sleep room 60 [lx]
toilets 120 [lx]

k room factor = (a*b)/(h1*(a+b))

h1= h total - h lamps - h2
h2 apps 0.9 [m]

Luminous flux

FLUX=(E * a * b) / (ni * f) [lm]

where f=f1 * f2 (0.9 cleanest and oldest)
and ni is parameter and can be determine from tables (0.2- 3)

Number of lamps = FLUX / unit lamps from tables (for example 1000 [lm]..)

Light really intensity

E= (n * n lamps * FLUX o * ni * f)/(a * b) [lx]



субота, 7. децембар 2019.

ADEMPIERE 392 BOM with costs per elements in BOM



DEMO :
https://www.youtube.com/watch?v=DDu-gqUgwf4



Set up the organization, warehouses, cashbooks,  assets, products (as preventive maintenance with BOM: spare parts oil, filters, types of equipment - as products)
define plants resources and tools and step by step all operations for workflows
with setup times and duration times

Its most important to put products into warehouses/locations storages, using
purchase order, invoices and automatically material receipt form invoices

and invoice is generated automatically for servis- business partners vendor

and material receipt cn be created automaticaly

and finally costs for bom for preventive maintenance service for every 30000 km



ADempiere libero manufacturing give more reports and information for
final users: (using java GUI (applet) on the desktop I was creating more reports



Plans fro MRP (Material requirement planning setup with process Calculate Low level, Create record MRP, regenerative Material plan, Net changes Material Plan and selective material plans and MRP info with MRP information) and CRP (capacity resource planning setup) DRP distribution resource planning setup) and resource loading for one resource(auto mechanic - defined in set up above)



недеља, 17. новембар 2019.

APEX 19.1 remove and install APEX 19.2 on oracle 18 c XE database

its need to log in sys/pass@localhost:1521/xepdb22 as sysdba
from folder where is apex 19.1 install - in my examples /home/oracle/apex
and @apxremove.sql is needed to be executed
When uninstallation of apex 19.2 is completed, I removed apex 19.1 and unzip 19.2 and again connect to oracle database ad sqlplus sys/pass@localhost:1521/xepdb22 and run @apexins sysaux sysaux temp /i/ (I was copy paste folder images from 19.2 to home/oracle and I have renamed this images to only i

Then I was connect again to oracle as sys and run @apex_epg_config /home/oracle
and finally @apxchpwd

All databases schema was in databases, but all workspaces is removed, so its need to create it again and instal exported applications before re-installations from 19.1 to 19.2


субота, 19. октобар 2019.

ghant cart in apex 4 (implementation ADempiere 342 for spare parts importing and set up virtuemart as web stores)




fig 1 browser need flash install (best chrome)

Fig 2 tabular form as a good option for collect data


try demo:
demo



недеља, 13. октобар 2019.


ADempiere 392 swing GUI
ADempiere scenario:
sales order (quotation) -  convert open proposal(or Quotation) to order-schipments- generate invoices-accounting informations

 Fig 1 GardenAdmin/GardenAdmin
Fig 2 Sales order
Fig 3 New sales order

Fig 4 Sales order line

Fig 5 Sales order status set to PREPARE
Fig 6 Sales order looks

Fig 7 Quote  Convert sales order to standard order
Fig 8 Quote convert completed
 Fig 9 set status
Fig 10 conversion completed
 Fig 11 Create shipments from orders and create invoice from shipments with account posting in general ledger (generate schipmentas process exist in earlier version ADempiere 342s/360/370 as indepentent process/icons)


Fig 12 Shipment (customer) older process is replaced with this one
Fig 13 Generate invoice

Fig 14 Generate invoice (quotation is from 8 10 2019 with date promised 9 10, sales order converted from quotation is 10 10 2019, shipment is from 13 10 2019 and invoice is from 13 10 2019 )
Fig 15 Posted accounting