posting_pdl_pay.py
2.67 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
row_tbp = SipkdTbp()
row_tbp.unitkey = unitkey
row_tbp.notbp = kodekey
row_tbp.keybend1 = keybend
row_tbp.kdstatus = statuskd
row_tbp.keybend2 = keybend
row_tbp.idxkode = '1' #pendapatan
row_tbp.tgltbp = row.tgl_trans
row_tbp.penyetor = row.nama
row_tbp.alamat = row.alamat
row_tbp.uraitbp = row.rekening_nm
row_tbp.tglvalid = row.tgl_trans
SipkdDBSession.add(row_tbp)
SipkdDBSession.flush()
if row.pokok+row.denda+row.bunga>0:
row_tbpdet = SipkdTbpDet()
row_tbpdet.unitkey = unitkey
row_tbpdet.notbp = kodekey
row_tbpdet.nilai = row.pokok+row.denda+row.bunga
row_tbpdet.mtgkey = SipkdRek4.get_key_by_kode(row.rekening_kd)
row_tbpdet.nojetra = '11' #Penerimaan STS/TBP
SipkdDBSession.add(row_tbpdet)
SipkdDBSession.flush()
row_bku = SipkdBkuTbp()
row_bku.unitkey = unitkey
row_bku.nobkuskpd = kodekey
row_bku.notbp = kodekey
row_bku.idxttd = keybend
row_bku.tglbkuskpd = row.tgl_trans
row_bku.uraian = row.nama
row_bku.tglvalid = row.tgl_trans
row_bku.keybend = keybend
SipkdDBSession.add(row_bku)
SipkdDBSession.flush()
row_bku.tglvalid = row.tgl_trans
SipkdDBSession.add(row_bku)
SipkdDBSession.flush()
""""
if (row.denda+row.bunga)>0:
row_tbpdet = SipkdTbpDet()
row_tbpdet.UNITKEY = unitkey
row_tbpdet.NOTBP = kodekey
row_tbpdet.NILAI = row.denda+row.bunga
row_tbpdet.MTGKEY = SipkdRek4.get_key_by_kode(row.rekening_kd)
row_tbpdet.NOJETRA = '11' #Penerimaan STS/TBP
SipkdDBSession.add(row_tbpdet)
SipkdDBSession.flush()
if row_skp:
row_skptbp = SipkdSkpTbp()
row_skptbp.UNITKEY = unitkey
row_skptbp.NOTBP = row_tbp.NOTBP
row_skptbp.NOSKP = row.ref_kode
SipkdDBSession.add(row_skptbp)
SipkdDBSession.flush()
"""