CATATAN SI EVRA

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////



select * from vw_fi_os_all_invoice_ar A;
select * from vw_mapping_salesman_customer B;

WITH data_piutang_jatuh_tempo AS (
	SELECT A.partner_id,A.tenant_id,COALESCE(SUM(A.amount-A.payment_amount),0) as amount
	from vw_fi_os_all_invoice_ar A
	INNER JOIN vw_mapping_salesman_customer B ON A.tenant_id =B.tenant_id AND A.partner_id = B.salesman_id
	WHERE A.tenant_id = 13
	AND B.salesman_id = 1558
	AND A.due_date <= '20200430'
	GROUP BY A.partner_id,A.tenant_id
),data_piutang_belum_jatuh_tempo AS (
	SELECT A.partner_id,A.tenant_id,COALESCE(SUM(A.amount-A.payment_amount),0) as amount
	FROM vw_fi_os_all_invoice_ar A
	INNER JOIN vw_mapping_salesman_customer B ON A.tenant_id =B.tenant_id AND A.partner_id = B.salesman_id
	WHERE A.tenant_id = 13
	AND B.salesman_id = 1558
	AND A.due_date > '20200430'
	GROUP BY A.partner_id,A.tenant_id

) SELECT A.partner_id,f_get_partner_code(A.partner_id) AS partner_code,f_get_partner_name(A.partner_id) AS partner_name,COALESCE(SUM(A.amount+B.amount),0) as seluruh_saldo, COALESCE(SUM(A.amount),0) AS jatuh_tempo, COALESCE(SUM(B.amount),0) AS belum_jatuh_tempo
FROM data_piutang_jatuh_tempo A
INNER JOIN data_piutang_belum_jatuh_tempo B ON A.partner_id = B.partner_id and A.tenant_id = B.tenant_id
where A.tenant_id = 13
	Group By A.partner_id




//////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
@david
Tolong di review pak
BF GetTodaySummarySaldoHutangByTokoId

Fungsi
Mengambil data rangkuman hutang toko hari ini berdasarkan toko id

Input
1.userLoginId(Long)
2.tenantLoginId(Long)
3.roleLoginId(Long)
4.datetime(String)
5.apiKey(String)
6.tokoId(Long)

Output
1.totalDebt(Double)
2.totalDebtDueDate(Double)
3.totalDebtNotDueDate(Double)
4.totalInvoice(Long)
5.totalInvoiceDueDate(Long)
6.totalInvoiceNotDueDate(Long)

BF: https://pastebin.com/VSDSDatU
Service: https://pastebin.com/Np3uDi5f

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

@david
Tolong di review pak
BF GetTodaySalesmanVisitSummaryBySalesman

Fungsi
Mengambil daftar cutomer beserta saldo piutang berdasarkan salesman id

Input
1.userLoginId(Long)
2.tenantLoginId(Long)
3.roleLoginId(Long)
4.datetime(String)
5.apiKey(String)
6.salesmanId(Long)
7.date(String)

Output
1.customerWithSaldoPiutangList (
customerId(Long),
customerCode(String),
customerName(String),
totalSaldoPiutang(Double),
totalSaldoPiutangDueDate(Double),
totalSaldoPiutangNotDueDate(Double)
)

BF: https://pastebin.com/F1uTjdL4
Service: https://pastebin.com/raNee9hv

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
@david
Tolong di review pak
BF GetTodaySummarySaldoHutangByTokoId

Fungsi
Mengambil data rangkuman hutang toko hari ini berdasarkan toko id

Input
1.userLoginId(Long)
2.tenantLoginId(Long)
3.roleLoginId(Long)
4.datetime(String)
5.apiKey(String)
6.tokoId(Long)

Output
1.totalDebt(Double)
2.totalDebtDueDate(Double)
3.totalDebtNotDueDate(Double)
4.totalInvoice(Long)
5.totalInvoiceDueDate(Long)
6.totalInvoiceNotDueDate(Long)

BF: https://pastebin.com/VSDSDatU
Service: https://pastebin.com/Np3uDi5f

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

@david
Tolong di review pak
BF GetCustomerListWithSaldoPiutangBySalesmanId

Fungsi
Mengambil daftar cutomer beserta saldo piutang berdasarkan salesman id

Input
1.userLoginId(Long)
2.tenantLoginId(Long)
3.roleLoginId(Long)
4.datetime(String)
5.apiKey(String)
6.salesmanId(Long)

Output
1.customerWithSaldoPiutangList (
customerId(Long),
customerCode(String),
customerName(String),
totalSaldoPiutang(Double),
totalSaldoPiutangDueDate(Double),
totalSaldoPiutangNotDueDate(Double)
)

BF: https://pastebin.com/F1uTjdL4
Service: https://pastebin.com/raNee9hv

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

@david
Tolong di review pak
BF GetSaldoPiutangListByCustomer

Fungsi
Mengambil daftar saldo piutang berdasarkan customer nya

Input
1.userLoginId(Long)
2.tenantLoginId(Long)
3.roleLoginId(Long)
4.datetime(String)
5.apiKey(String)
6.customerId(Long)
7.statusPiutang(String)

Output
1.saldoPiutangList (
invoiceDocNo(String),
invoiceDocDate(String),
invoiceDueDate(String),
sisaPiutang(Double),
statusPiutang(String)
)

BF: https://pastebin.com/mwNz87mx
Service: https://pastebin.com/kp9fB8Yw
///////////////////////////////////////////////////////////////////////////////////////////////////////
1. Buat class di package util
2. Nama class nya DecodedImageFile
3. Buat method untuk tulis dari Strring base64 ke file
4. Cara panggil

DecodedImageFile.writeFile(strDecoded, folder, namaFile );

String namaImage = id + "_" + System.currentTiemelimis() + ".jpg";

DecodedImageFile.writeFile(strDecoded, "/erp-enterprise/images/tasksales/20200512/", "xxxxxxxxxx.jpg"  );

1. strDecoded -> pastikan valid jika di decode.
byte[] arrayByte = Base64.decode(strDecoded);

2. Buat create folder
new File(folder).mkdirs();

3. Buat full filename

String fullFileName = folder + "/" + namaImage;

4. Tulis file lihat komentar di story



Di SERVICE BOOT
1. Buat branch dulu untuk tasksaels intgr
2. Buat config untuk lokasi image

jleaf:
  taskhub:
    imageHome: ${TASKHUB_IMAGE_HOME:/erp-enterprise/images/}

di BT kalau mau ambil config tersebut, caranya.

@Autowired
Environtment environtment;
// import yg punya spring


String imageHome = environtment.getProperties("jleaf.taskhub.imageHome");

String imageFullDir = imageHome + SalesConstntass.TASKSALES + "/" + DateUtil.dateNow() + "/";

DecodedImageFile.writeFile(strDecoded, imageFullDir, namaFile );


https://emn178.github.io/online-tools/base64_encode_file.html

3. di docker-compose.yml buat volumne agar foler /erp-enterprise/images/ bisa diloihat di local