def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formkonversi' == c:
return HttpResponse(json.dumps(prepareFormKonversi(util.data)))
if 'simpanitemkonversi' == c:
ipbl = simpanItemKonversi(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([ipbl.barang, ipbl.konversi, ipbl], prefiks=['barang_', 'konversi_'])))
if 'hapusitemkonversi' == c:
iks = models.ItemKonversi.objects.filter(id__exact=util.nvlGet('itemId'))
for ik in iks:
jik = util.modelToDicts([ik])
ik.delete()
return HttpResponse(json.dumps(jik))
if 'getitemkonversi' == c:
ipbls = getItemKonversi(util.nvlGet('id', 0), util.nvlGet('kredebit'), util.nvlGet('jenisProduk', 1),
util.nvlGet('a', 20))
jitemkonversis = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
replaces=['id:barang_id'])
jitemkonversis.append(jitem)
return HttpResponse(json.dumps(jitemkonversis))
if 'gethdrkonversi' == c:
pbls = models.Konversi.objects.filter(id__exact=util.nvlGet('id', 0))
for pbl in pbls:
jpbl = util.modelToDicts([pbl])
return HttpResponse(json.dumps({'data': jpbl}))
return HttpResponse('No data with this id ')
if 'gettotalitemkonversi' == c:
y = 'nanti di garap'
if 'formbrowsekonversi' == c:
return render_to_response('inventory/form_konversi_browse.html')
if 'browsekonversi' == c:
return HttpResponse(json.dumps({'data': browseKonversi(util.data)}))
if 'simpankonversi' == c:
bb = barangBisnis()
konversi_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana konversi telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if konversi_id != 0:
bb.konversiProduksi(konversi_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan konversi', 'html': html}))
else: return HttpResponse(json.dumps({'sukses': False, 'message': 'Rencana konversi tidak disimpan'}))
if 'konversisider' == c:
return HttpResponse(json.dumps({'html': getKonversiSider(util.data)}))
return HttpResponseServerError('can''t find param')
def prepareSideSaldo(reqData):
requtil = Utility(reqData=reqData)
barang_id = requtil.nvlGet('barang_id', 0)
bdis = models.BarangDiInventory.objects.filter(barang__id__exact=barang_id)
html = 'tes'
if len(bdis):
barang = bdis[0].barang
barang_nama = barang.nama
daftar_saldo = bdis
bb = barangBisnis()
saldo = bb.getSaldoBarang(barang.id)
html = render_to_string('inventory/side_saldo_barang.html', {'barang_nama': barang_nama, 'total': saldo,
'daftar_saldo': daftar_saldo})
return html
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formpembelian' == c:
return HttpResponse(json.dumps(prepareFormBarang(util.data)))
if 'formrencanapembelian' == c:
return HttpResponse(json.dumps(prepareFormRencanaPembelian(util.data)))
if 'simpanitempembelian' == c:
ipbl = simpanItemPembelian(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([ipbl.barang, ipbl.pembelian, ipbl.pembelian.supplier, ipbl],
replaces=['id:barang_id', 'id:id', 'id:supplier_id', 'id:id', 'id:itempembelian_id',
'tanggal:tgl_rencana_pembelian', 'nomor:no_rencana_pembelian'])))
if 'getitempembelian' == c:
ipbls = getItemPembelian(util.nvlGet('id', 0), util.nvlGet('a', 20))
jitempembelians = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
replaces=['id:barang_id'])
jitempembelians.append(jitem)
return HttpResponse(json.dumps(jitempembelians))
if 'gethdrpembelian' == c:
pbls = models.Pembelian.objects.filter(id__exact=util.nvlGet('id', 0))
for pbl in pbls:
jpbl = util.modelToDicts([pbl.supplier, pbl], prefiks=['supplier', ''])
return HttpResponse(json.dumps({'data': jpbl}))
if 'gettotalitempembelian' == c:
y = 'nanti di garap'
if 'formbrowsepembelian' == c:
return render_to_response('inventory/form_pembelian_browse.html')
if 'browsepembelian' == c:
return HttpResponse(json.dumps({'data': browsePembelian(util.data)}))
if 'simpanrencanapembelian' == c:
bb = barangBisnis()
pembelian_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana pembelian telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if pembelian_id != 0:
bb.debetPembelian(pembelian_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan pembelian', 'html': html}))
else: return HttpResponse(json.dumps({'sukses': False, 'message': 'Rencana pembelian tidak disimpan'}))
if 'pembeliansider' == c:
return HttpResponse(json.dumps({'html': getPembelianSider(util.data)}))
return HttpResponseServerError('can''t find param')
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formbcdtmap' == c:
return HttpResponse(json.dumps({'html': render_to_string('inventory/form_bcdtmap.html')}))
if 'getmapping' == c:
return HttpResponse(json.dumps({'items': getMaping(util.nvlGet('id'))}))
if 'getmapheader' == c:
return HttpResponse(json.dumps({'hdr': getMapHeader(util.nvlGet('id'))}))
if 'mapbarang' == c:
return HttpResponse(json.dumps({'item': mapBarang(
util.nvlGet('item_id'),
util.nvlGet('barang_id'))}))
if 'upload' == c:
f = request.FILES['uploadedfile']
hdr = ekstrakFileZip(f)
if hdr is not None: return HttpResponse('{"sukses":true,"id":%s}' % (hdr.id))
else: return HttpResponse('{"sukses":false}')
if 'formbrowsebcdtmap' == c:
return render_to_response('inventory/form_bcdtmap_browse.html')
if 'browsebcdtmap' == c:
return HttpResponse(json.dumps({'data': browseMapping(util.data)}))
if 'simpanmapping' == c:
bb = barangBisnis()
bcdt_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data mapping BC 2.3 telah berhasil disimpang</div>
'''
print 'simpan dokumen mapping'
print bcdt_id
if bcdt_id != 0:
bb.debetBc23(bcdt_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan mapping dokumen BC 2.3', 'html': html}))
else: return HttpResponse(json.dumps({'sukses': False, 'message': 'Rencana pembelian tidak disimpan'}))
return HttpResponseServerError('can''t find param')
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formrencanapenjualan' == c:
return HttpResponse(json.dumps(prepareFormRencanaPenjualan(util.data)))
if 'simpanitempenjualan' == c:
ipbl = simpanItemPenjualan(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([ipbl.barang, ipbl.penjualan, ipbl.penjualan.customer, ipbl],
replaces=['id:barang_id', 'id:id', 'id:customer_id', 'id:id', 'id:itempenjualan_id',
'tanggal:tgl_rencana_penjualan', 'nomor:no_rencana_penjualan'])))
if 'getitempenjualan' == c:
ipbls = getItemPenjualan(util.nvlGet('id', 0), util.nvlGet('a', 20))
jitempenjualans = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
replaces=['id:barang_id'])
jitempenjualans.append(jitem)
return HttpResponse(json.dumps(jitempenjualans))
if 'gettotalitempenjualan' == c:
y = 'nanti di garap'
if 'simpanrencanapenjualan' == c:
bb = barangBisnis()
penjualan_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana penjualan telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if penjualan_id != 0:
bb.kreditPenjualan(penjualan_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan penjualan', 'html': html}))
else: return HttpResponse(json.dumps({'sukses': False, 'message': 'Rencana penjualan tidak disimpan'}))
return HttpResponseServerError('can''t find param')
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formpengeluaranPabean' == c:
return HttpResponse(json.dumps(prepareFormBarang(util.data)))
if 'formpengeluaranpabean' == c:
return HttpResponse(json.dumps(prepareFormPengeluaranPabean(util.data)))
if 'simpanitempengeluaranpabean' == c:
doc = simpanItemPengeluaranPabean(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([doc.barang, doc, doc.dokumen], prefiks=['barang_', '', ''])))
if 'getitempengeluaranpabean' == c:
ipbls = getItemBarangPabean(util.nvlGet('id', 0), util.nvlGet('a', 20))
jitempengeluaranPabeans = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
replaces=['id:barang_id'])
jitempengeluaranPabeans.append(jitem)
return HttpResponse(json.dumps(jitempengeluaranPabeans))
if 'gethdrpengeluaranpabean' == c:
pbls = models.DokumenPabean.objects.filter(id__exact=util.nvlGet('id', 0))
for pbl in pbls:
jpbl = util.modelToDicts([pbl], prefiks=[''])
return HttpResponse(json.dumps({'data': jpbl}))
if 'gettotalitempengeluaranPabean' == c:
y = 'nanti di garap'
if 'formbrowsedokumenpabean' == c:
return render_to_response('inventory/form_dokumen_pabean_browse.html')
if 'browsedokumenpabean' == c:
return HttpResponse(json.dumps({'data': browseDokumenPabean(util.data)}))
if 'simpanpengeluaranpabean' == c:
bb = barangBisnis()
pengeluaranPabean_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana pengeluaranPabean telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if pengeluaranPabean_id != 0:
bb.pengeluaranPabean(pengeluaranPabean_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan pengeluaranPabean', 'html': html}))
else: return HttpResponse(
json.dumps({'sukses': False, 'message': 'Rencana pengeluaranPabean tidak disimpan'}))
if 'pengeluaranPabeansider' == c:
return HttpResponse(json.dumps({'html': getPengeluaranPabeanSider(util.data)}))
## FORM PEMASUKAN PABEAN
if 'formpemasukanpabean' == c:
return HttpResponse(json.dumps(prepareFormPemasukanPabean(util.data)))
if 'simpanitempemasukanpabean' == c:
doc = simpanItemPengeluaranPabean(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([doc.barang, doc, doc.dokumen], prefiks=['barang_', '', ''])))
if 'getitempemasukanpabean' == c:
ipbls = getItemBarangPabean(util.nvlGet('id', 0), util.nvlGet('a', 20))
jitempengeluaranPabeans = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
replaces=['id:barang_id'])
jitempengeluaranPabeans.append(jitem)
return HttpResponse(json.dumps(jitempengeluaranPabeans))
if 'gethdrpemasukanpabean' == c:
pbls = models.DokumenPabean.objects.filter(id__exact=util.nvlGet('id', 0))
for pbl in pbls:
jpbl = util.modelToDicts([pbl], prefiks=[''])
return HttpResponse(json.dumps({'data': jpbl}))
if 'simpanpemasukanpabean' == c:
bb = barangBisnis()
pengeluaranPabean_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana pengeluaranPabean telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if pengeluaranPabean_id != 0:
bb.pemasukanPabean(pengeluaranPabean_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan pengeluaranPabean', 'html': html}))
else: return HttpResponse(
json.dumps({'sukses': False, 'message': 'Rencana pengeluaranPabean tidak disimpan'}))
if 'getjenisdokumen' == c:
pbls = models.Referensi.objects.filter(id__exact=util.nvlGet('jenisDokumen', 0))
for pbl in pbls:
return HttpResponse(json.dumps({'data': pbl.nama}))
return HttpResponseServerError('can''t find param')
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formbarang' == c:
return HttpResponse(json.dumps(prepareFormBarang(util.data)))
if 'formpencarianbarang' == c:
return render_to_response('inventory/form_barang_cari.html')
if 'pencarianbarang' == c:
return HttpResponse(json.dumps({'data': pencarianBarang(util.data)}))
if 'barangsider' == c:
return HttpResponse(json.dumps({'html': getBarangSider(util.data)}))
if 'lookupbarang' == c:
return HttpResponse(
json.dumps(lookupBarang(util.nvlGet('katakunci', None), util.nvlGet('id'), util.nvlGet('max', None))));
if 'lookupbdi' == c:
return HttpResponse(
json.dumps(lookupBdi(util.nvlGet('katakunci', None),
util.nvlGet('inventory_id', None), util.nvlGet('id'), util.nvlGet('max', None))));
if 'caribarang' == c:
return render_to_response('inventory/cari_kata_kunci.html')
if 'formupload' == c:
return HttpResponse(json.dumps({'html': render_to_string('inventory/form_barang_upload.html')}))
if 'formuploadtes' == c:
return render_to_response('inventory/form_barang_upload.html')
if 'pdfsider' == c:
slash = '/' if settings.ON_OPENSHIFT else '\\'
return render_to_pdf('inventory/pdf/laporan.html', {'nama': 'tejo', 'merk': 'cocacola',
'font': '%s%s' % (
os.path.join(settings.PROJECT_DIR, 'inventory',
'static', 'img', 'font'), slash)})
if 'upload' == c:
f = request.FILES['uploadedfile']
id = util.nvlGet('id', '-')
url = saveGambarBarang(f, id)
return HttpResponse('{"file":"%s","url":"%s","sukses":"true"}' % (f.name, url))
if 'formlistbarang' == c:
return HttpResponse(json.dumps(dict(
{'html': render_to_string('inventory/list_barang.html'),
'data': prepareListBarangByKataKunci(util.data)})))
if 'formbahanbaku' == c:
return HttpResponse(json.dumps(prepareFormBarang(util.data)))
if 'barangbyname' == c:
par = util.nvlGet('q', '')
namas = []
#g=500/0
nama = 'noname'
if len(par) > 2:
pas = models.Barang.objects.filter(nama__icontains=par)[:util.nvlGet('a', 8)]
for p in pas:
nama = util.modelToDicts([p])
namas.append(nama)
#return HttpResponseServerError('error dari server lhoo')
data = dict({'eventid': util.nvlGet('eventid'), 'data': namas})
return HttpResponse(json.dumps(data))
if 'barangbyid' == c:
brgs = models.Barang.objects.filter(id__exact=par)
brg = models.Barang();
if len(brgs):
brg = brgs[0]
return HttpResponse(json.dumps(util.modelToDicts([brg])))
if 'baranginventorylist_bybarangid' == c:
idBrg = util.nvlGet('id', None)
jresp = {}
jbdis = []
if idBrg is not None:
bdis = models.BarangDiInventory.objects.filter(barang__id__exact=idBrg)[:util.nvlGet('a', 8)]
for bdi in bdis:
jbdi = util.modelToDicts([bdi.barang, bdi.inventory, bdi], replaces=['nama:nama_barang'])
jbdis.append(jbdi)
jresp = dict({'html': render_to_string('inventory/list_saldo_barang.html'), 'data': jbdis})
return HttpResponse(json.dumps(jresp))
if 'barang_bynamamerktag' == c:
jresp = dict({'data': prepareListBarangByKataKunci(util.data), 'eventid': util.nvlGet('eventid')})
return HttpResponse(json.dumps(jresp))
if 'hapusbarang' == c:
barang = models.Barang.objects.filter(id__exact=util.nvlGet('id', 0));
dp = {}
if barang:
#hapus semua barang di inventory
barangs = models.BarangDiInventory.objects.filter(barang__id__exact=util.nvlGet('id', 0));
#hapus semua harga
hargas = models.Harga.objects.filter(barang__id__exact=util.nvlGet('id', 0));
for brgInv in barangs:
brgInv.delete();
for hrg in hargas:
hrg.delete();
dp = util.modelToDict(barang[0])
barang[0].delete()
return HttpResponse(json.dumps(dp))
if 'updatebarang' == c:
#hanya untuk mengupdate data barang, bukan barang di inventory
return HttpResponse(json.dumps(updateBarang(util.data)))
if 'simpanbarang' == c:
#simpanPasien(request.POST)
return HttpResponse(json.dumps(saveUpdateBarangDiInventory(util.data)))
if 'sidesaldo' == c:
return HttpResponse(json.dumps({'html': prepareSideSaldo(util.data)}))
if 'tesjurnal' == c:
bj = barangJurnal();
jbs = bj.getMonthlyJurnal(3, 2, date.today(), 'D')
jbdis = []
for jb in jbs:
jbdi = util.modelToDicts([jb.barang.barang, jb])
jbdis.append(jbdi)
return HttpResponse(json.dumps(jbdis))
if 'teskredit' == c:
bb = barangBisnis()
bb.kredit(1, 2, 50, 8500, 'Penjualan')
return HttpResponse('Penjualan berhasil')
return HttpResponseServerError('can''t find param')
def dispatch(request):
util = Utility(post=request.POST, get=request.GET)
c = util.nvlGet('c');
par = util.nvlGet('q', '')
if c is not None:
if 'formopname' == c:
return HttpResponse(json.dumps(prepareFormOpname(util.data)))
if 'simpanitemopname' == c:
iop = simpanItemOpname(util.data)
return HttpResponse(json.dumps(
util.modelToDicts([iop.barang, iop.opname, iop], prefiks=['barang_', 'opname_', ''])))
if 'hapusitemopname' == c:
iks = models.ItemOpname.objects.filter(id__exact=util.nvlGet('itemId'))
for ik in iks:
jik = util.modelToDicts([ik])
ik.delete()
return HttpResponse(json.dumps(jik))
if 'getitemopname' == c:
ipbls = getItemOpname(util.nvlGet('id', 0))
jitemopnames = []
for ipbl in ipbls:
jitem = util.modelToDicts([ipbl.barang, ipbl],
prefiks=['barang_', ''])
jitemopnames.append(jitem)
return HttpResponse(json.dumps(jitemopnames))
if 'prepareitemopname' == c:
#mengambil data barang dari inventory tertentu
print 'prepare opname barang'
barangs = models.BarangDiInventory.objects.filter(
inventory__id__exact=util.nvlGet('inventory_id'))
jitemopnames = []
for brg in barangs:
jitem = util.modelToDicts([brg.barang, brg],
prefiks=['barang_', ''])
jitem['opname'] = 0
jitem['keterangan'] = ''
jitemopnames.append(jitem)
return HttpResponse(json.dumps(jitemopnames))
if 'gethdropname' == c:
pbls = models.Opname.objects.filter(id__exact=util.nvlGet('id', 0))
for pbl in pbls:
jpbl = util.modelToDicts([pbl])
return HttpResponse(json.dumps({'data': jpbl}))
return HttpResponse('No data with this id ')
if 'gettotalitemopname' == c:
y = 'nanti di garap'
if 'formbrowseopname' == c:
return render_to_response('inventory/form_opname_browse.html')
if 'browseopname' == c:
return HttpResponse(json.dumps({'data': browseOpname(util.data)}))
if 'simpanopname' == c:
bb = barangBisnis()
opname_id = util.nvlGet('id', 0)
html = '''
<div class="formrow" style:font 12px verdana>Data rencana opname telah berhasil disimpang</div>
<input type="button" value="Lanjut Perekaman" id="btnMore"/>
'''
if opname_id != 0:
bb.opname(opname_id)
return HttpResponse(
json.dumps({'sukses': True, 'message': 'Berhasil melakukan opname', 'html': html}))
else: return HttpResponse(json.dumps({'sukses': False, 'message': 'Rencana opname tidak disimpan'}))
if 'opnamesider' == c:
return HttpResponse(json.dumps({'html': getOpnameSider(util.data)}))
return HttpResponseServerError('can''t find param')
