You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
405 lines
8.3 KiB
JavaScript
405 lines
8.3 KiB
JavaScript
import { pinjamanchange } from '{js}ts-angsuran-pinjamanchange.js?={time}';
|
|
export const fang = [
|
|
, {
|
|
title: 'No. Anggota',
|
|
type: 'select',
|
|
name: 'kode',
|
|
line: 120,
|
|
row: 4,
|
|
data: JSON.parse(_id('anggota').innerHTML),
|
|
readonly: false,
|
|
action: function (a) {
|
|
_Evchange(a, function () {
|
|
var val = this.value;
|
|
if (val != '') {
|
|
var ang = _master('anggota', 'anggota').cond(val, 'id');
|
|
if (ang.length > 0) {
|
|
ang = ang[0];
|
|
_setval('nip', ang.nip);
|
|
_setval('nama', ang.text);
|
|
_setval('unitkerja', ang.unitkerja);
|
|
_setval('status', ang.status);
|
|
_setval('gaji', ang.gaji.number(2).currency(0));
|
|
}
|
|
var op = '';
|
|
if(window._w == 'u'){
|
|
if (window.gdt != undefined){
|
|
op += ' OR id = "'+window.gdt.fkt+'"';
|
|
}
|
|
}
|
|
var _ld = cssLoader()
|
|
AuditDevQuery(`SELECT
|
|
m.faktur id,
|
|
m.faktur text,
|
|
round( (m.pokok) - (ifnull(b.pokok,0)) ) sisa
|
|
FROM mpinjam m
|
|
LEFT JOIN (
|
|
SELECT fkt, sum(pokok) pokok, sum(bunga) bunga FROM mags WHERE kode = '${val}' GROUP BY fkt
|
|
) b ON b.fkt = m.faktur
|
|
WHERE m.kode = '${val}' HAVING sisa > 10 ${op} `, function (pj) {
|
|
_setoption('fkt', pj)
|
|
_ld.remove();
|
|
});
|
|
}
|
|
})
|
|
},
|
|
},
|
|
, {
|
|
title: 'Nama',
|
|
type: 'text',
|
|
line: 120,
|
|
name: 'nama',
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function (a) {
|
|
},
|
|
},
|
|
, {
|
|
title: 'NIP',
|
|
type: 'text',
|
|
line: 120,
|
|
name: 'nip',
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function (a) {
|
|
},
|
|
},
|
|
, {
|
|
title: 'Unit Kerja',
|
|
type: 'text',
|
|
line: 120,
|
|
name: 'unitkerja',
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function (a) {
|
|
},
|
|
},
|
|
, {
|
|
title: 'Status',
|
|
type: 'text',
|
|
line: 120,
|
|
name: 'status',
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function (a) {
|
|
},
|
|
},
|
|
, {
|
|
title: 'Gol Gaji',
|
|
type: 'text',
|
|
line: 120,
|
|
name: 'gaji',
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function (a) {
|
|
},
|
|
}
|
|
, {
|
|
type: "line"
|
|
}
|
|
, {
|
|
title: 'Tgl Bayar',
|
|
type: 'date',
|
|
name: 'tgl',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: false,
|
|
action: function (w) {
|
|
if (_setup("jht") != undefined) {
|
|
var s = w.split("-");
|
|
s.pop();
|
|
_setval("tgljt", s.join("-") + "-" + _setup("jht"));
|
|
}
|
|
},
|
|
}
|
|
, {
|
|
title: 'No. Pinjaman',
|
|
type: 'select',
|
|
name: 'fkt',
|
|
line: 120,
|
|
row: 4,
|
|
data: [],
|
|
readonly: true,
|
|
action: function (a) {
|
|
_Evchange(a, pinjamanchange)
|
|
},
|
|
}
|
|
, {
|
|
title: 'Akun Penerima',
|
|
type: 'select',
|
|
name: 'cash',
|
|
line: 120,
|
|
row: 4,
|
|
data: [],
|
|
readonly: true,
|
|
action: function (a) { },
|
|
}
|
|
, {
|
|
title: 'Keterangan',
|
|
type: 'text',
|
|
name: 'ket',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'No. Angsuran',
|
|
type: 'text',
|
|
name: 'nomor',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'No. Kwitansi',
|
|
type: 'text',
|
|
name: 'faktur',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
type: "line"
|
|
}
|
|
, {
|
|
title: 'Jumlah Kredit',
|
|
type: 'number',
|
|
name: 'jml',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Tgl. Pinjaman',
|
|
type: 'date',
|
|
name: 'tglpj',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Masa Angsuran',
|
|
type: 'text',
|
|
name: 'lama',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Total Angsuran/ Bulan',
|
|
type: 'number',
|
|
name: 'totang',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Sisa Pokok',
|
|
type: 'number',
|
|
name: 'sisa',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Ags. Terakhir',
|
|
type: 'date',
|
|
name: 'agstgl',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Jasa / Tahun (%)',
|
|
type: 'number',
|
|
name: 'jasa',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Sisa Jasa',
|
|
type: 'number',
|
|
name: 'sisajasa',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Status Pembayaran',
|
|
type: 'text',
|
|
name: 'statusbayar',
|
|
line: 120,
|
|
row: 4,
|
|
readonly: true,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
type: "line"
|
|
}
|
|
, {
|
|
title: 'Jatuh Tempo',
|
|
type: 'date',
|
|
name: 'tgljt',
|
|
row: 2,
|
|
readonly: false,
|
|
unfollow: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Ang. Ke',
|
|
type: 'number',
|
|
name: 'ke',
|
|
row: 1,
|
|
readonly: false,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Angsuran Pokok',
|
|
type: 'number',
|
|
name: 'pokok',
|
|
row: 3,
|
|
display: 'none',
|
|
readonly: false,
|
|
action: function (a) {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Angsuran Pokok ( SHU )',
|
|
type: 'number',
|
|
name: 'shu',
|
|
row: 3,
|
|
readonly: false,
|
|
action: function (a) {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Pelunasan Pokok ( Non SHU )',
|
|
type: 'number',
|
|
name: 'nonshu',
|
|
row: 3,
|
|
readonly: false,
|
|
action: function (a) {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Angsuran Jasa',
|
|
type: 'number',
|
|
name: 'bunga',
|
|
row: 3,
|
|
readonly: false,
|
|
action: function (a) {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Potongan',
|
|
type: 'number',
|
|
name: 'discount',
|
|
row: 3,
|
|
readonly: false,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Total Bayar',
|
|
type: 'number',
|
|
name: 'bayar',
|
|
row: 3,
|
|
readonly: true,
|
|
unfollow: true,
|
|
bold: true,
|
|
action: function (a) {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'Keterangan',
|
|
type: 'text',
|
|
name: 'keterangan',
|
|
row: 6,
|
|
readonly: false,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'user',
|
|
type: 'text',
|
|
name: 'user',
|
|
row: 4,
|
|
display: 'none',
|
|
readonly: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
, {
|
|
title: 'user',
|
|
type: 'text',
|
|
name: 'userlog',
|
|
row: 4,
|
|
display: 'none',
|
|
readonly: true,
|
|
action: function () {
|
|
|
|
},
|
|
}
|
|
];
|