Jasper Report - Idempiere - Date

 #utk report dg parameter date Optional, pakai query:
Parameters
tgl = java.util.Date

SQL = select * from tableX where lahir=coalesce($P{tgl},lahir)

paham?

Merubah directory dalam script

 # tambahan  

OLDPWD=$(pwd)

cd /opt/[direktory]

function atexit() { cd "$OLDPWD"; }

trap atexit EXIT # go back to where we came from, however we exit

# end of tambahan  

idem81 on centos 8

 perlu :

1.disable firewalld

2.set di .bash_profile

##tambahan

ORACLE_SID=XE

export ORACLE_SID

export ORAENV_ASK=NO

. oraenv

3.install fontconfig

yum install fontconfig

4.buat service idem

install debian 10 buster

install from CD
kosongi semua software, kecuali server ssh, minimal terakhir
mirror pilih mirror.0x.sg

root@localhost:/etc/apt# cat sources.list
#

# deb cdrom:[Debian GNU/Linux 10.2.0 _Buster_ - Official amd64 NETINST 20191116-09:56]/ buster main

#deb cdrom:[Debian GNU/Linux 10.2.0 _Buster_ - Official amd64 NETINST 20191116-09:56]/ buster main


deb http://mirror.0x.sg/debian/ buster main
deb-src http://mirror.0x.sg/debian/ buster main

deb http://security.debian.org/debian-security buster/updates main contrib
deb-src http://security.debian.org/debian-security buster/updates main contrib

# buster-updates, previously known as 'volatile'
deb http://mirror.0x.sg/debian/ buster-updates main contrib
deb-src http://mirror.0x.sg/debian/ buster-updates main contrib

apt-get update -y
[apt-get install postgres, openjdk, mc, ntp, net-utils]
apt-get install nginx, php, php-fpm

install swoole:
apt-get install php-dev

custom

latihan mencoba custom

idempiere Callout Factory and Callout

public class MyCalloutFactory implements IColumnCalloutFactory{

@Override
public IColumnCallout[] getColumnCallouts(String tableName, String columnName) {
// TODO Auto-generated method stub

List list = new ArrayList();

System.out.println("Kolom:"+tableName+"."+columnName);

if(tableName.equalsIgnoreCase("C_ORDER") && columnName.equalsIgnoreCase("DESCRIPTION"))
list.add(new MyCallout());

if(tableName.equalsIgnoreCase("C_ORDER") && columnName.equalsIgnoreCase("AD_ORG_ID"))
list.add(new MyCallout());

return list!=null ? list.toArray(new IColumnCallout[0]) : new IColumnCallout[0];
}


}

Setiap masuk window, maka fungsi diatas dipanggil sebanyak kolom, untuk assign.

public class MyCallout implements IColumnCallout{
CLogger log = CLogger.getCLogger(MyCallout.class);
@Override
public String start(Properties ctx, int WindowNo, GridTab mTab, GridField mField, Object value, Object oldValue) {
// TODO Auto-generated method stub
log.warning("* dari sini *");
log.warning("ColumnName: "+mField.getColumnName());
if (value != null)
log.warning("NewValue: "+value.toString());
if (oldValue != null)
log.warning("Oldvalue: "+oldValue.toString());
mTab.setValue("DocumentNo", "Test");
return null;
}
}

Ini dipanggil HANYA oleh kolom yang di-assign

idempiere total-record

drop materialized view z_afei_total_record_03;

idempiere Single Production Journal

generate z_period

CREATE OR REPLACE PROCEDURE adempiere.z_generate_z_period(xad_org_id numeric
                                                         ,xtahun numeric)
LANGUAGE plpgsql
AS $procedure$  declare
    z_value numeric;
    z_nama  varchar(80);
begin
-- Enter function body here
for i in 1..12
loop
z_value:=xtahun*100+i;
select to_char(to_date(xtahun||'-'||right('0'||i,2),'yyyy-mm'),'Mon-yyyy') into z_nama;
 
INSERT INTO z_period
(ad_org_id, created, createdby, isactive
, updated, updatedby, z_period_id
, z_period_uu
, "name", value, ad_client_id, isclosed)
VALUES(xad_org_id, statement_timestamp(), 1000000, 'Y'::bpchar
        , statement_timestamp(), 1000000
        , nextid((select ad_sequence_id from ad_sequence where name = 'z_period')::Integer, 'N'::Varchar)
        , generate_uuid()
        , z_nama,z_value, 1000000, 'N'::bpchar);
     
commit;
    end loop;
end;
 $procedure$
;

Auto run idempiere / autostart idempiere

nano /etc/systemd/system/idempiere.service

--copy pastekan ini:

[Unit]
Description=Description for sample script goes here
After=local-fs.target

[Service]
Type=simple
ExecStart=/opt/idempiere-server/idempiere-server.sh
TimeoutStartSec=0

[Install]
WantedBy=default.target

--ctrl X to exit and choose save Y

--lalu

systemctl daemon-reload

systemctl enable idempiere.service

systemctl start idempiere.service

systemctl reboot

--coba

selesai