INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326190902461','input','1',' MEF3E X LG','TOKO','PM-F','F3E-ZDBI-151-0','GL X PAJERO LG 8K ','','2.710','1','100.00','2827000','0','0','15000','2828000','0','0','0','2828000','LIS','00401797','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBI-151-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='F3E-ZDBI-151-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326190902461','2026-10-19','2.710','2026-10-19','09:02:47','PLG0031966','2828000','2828000','0','2828000','2828000','input','2026-10-19 09:02:46','F32619090246'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326190902461','2026-10-19','09:02:47','LIS','2828000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0002','D','2026-10-19','09:02:47','input','PENJUALAN','F326190902461','7908055000','2828000','7910883000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326190912471','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIAE-295-0','CC WEDDING MATA CM 22 8K ','','1.530','1','100.00','1565000','0','0','15000','1565000','0','10000','0','1575000','FIT','00423831','E2D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAE-295-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='E2D-ZIAE-295-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326190912471','2026-10-19','1.530','2026-10-19','09:12:48','PLG0031967','1565000','1565000','10000','1575000','1575000','kasir','2026-10-19 09:12:47','F32619091247'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326190912471','2026-10-19','09:12:48','FIT','1575000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0003','D','2026-10-19','09:12:48','kasir','PENJUALAN','F326190912471','7910883000','1575000','7912458000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326190913451','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZHBF-140-0','CC X MODEL MATA SLEP VAR CM 16 8K ','','1.150','1','100.00','1176000','0','0','15000','1175000','0','0','0','1175000','LIS','00420512','E2D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBF-140-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='E2D-ZHBF-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326190913451','2026-10-19','1.150','2026-10-19','09:13:46','PLG0031968','1175000','1175000','0','1175000','1175000','kasir','2026-10-19 09:13:45','F32619091345'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326190913451','2026-10-19','09:13:46','LIS','1175000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0004','D','2026-10-19','09:13:46','kasir','PENJUALAN','F326190913451','7912458000','1175000','7913633000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326191142021','kasir','1',' MEH1 UB ','TOKO','PM-H','H1E-ZIBB-87-0','KL SIEM COBRA MODEL HATI VAR UB 8K ','','1.500','1','100.00','1564000','0','0','15000','1565000','0','0','0','1565000','SIN','00425095','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIBB-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='H1E-ZIBB-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191142021','2026-10-19','1.500','2026-10-19','11:42:03','PLG0031969','1565000','1565000','0','1565000','1565000','kasir','2026-10-19 11:42:02','F32619114202'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326191142021','2026-10-19','11:42:03','SIN','1565000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261019-0005','D','2026-10-19','11:42:03','kasir','PENJUALAN','F326191142021','7913633000','1565000','7915198000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326191142021' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326191142022','kasir',' 1',' MGB1G X CM','TOKO','PM-B','B1G-ZIXH-36-0','GW X TUSUK DAISY MATA CM 8K ','','0.300','1','100.00','325000','0','0','15000','325000','0','0','0','325000','SIN','00422303','B1G','0','0','-','0','1083000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZIXH-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='B1G-ZIXH-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191142022','2026-10-19','0.300','2026-10-19','11:42:03','PLG0031970','325000','325000','0','325000','325000','kasir','2026-10-19 11:42:02','F32619114202'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326191142022','2026-10-19','11:42:03','SIN','325000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261019-0006','D','2026-10-19','11:42:03','kasir','PENJUALAN','F326191142022','7915198000','325000','7915523000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='325000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326191142022' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326191200101','kasir','1',' MEF1 XX UB','TOKO','PM-F','F1E-ZJAE-87-0','GL XX OVAL C SLEP UB 52 8K ','','3.130','1','100.00','3296000','0','0','15000','3170000','0','0','0','3170000','FIT','00429970','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJAE-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='F1E-ZJAE-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191200101','2026-10-19','3.130','2026-10-19','12:00:10','PLG0031971','3170000','3170000','0','3170000','3170000','kasir','2026-10-19 12:00:10','F32619120010'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326191200101','2026-10-19','12:00:10','FIT','3170000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0007','D','2026-10-19','12:00:10','kasir','PENJUALAN','F326191200101','7915523000','3170000','7918693000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326191202461','kasir','1',' MEF3E X PM','TOKO','PM-F','F3E-ZJXG-180-0','GL X KREPYAK DAUN SLEP PM 8K ','','3.170','1','100.00','3306000','0','0','15000','3308000','0','0','0','3308000','FIT','00428422','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXG-180-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='F3E-ZJXG-180-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191202461','2026-10-19','3.170','2026-10-19','12:02:46','PLG0031972','3308000','3308000','0','3308000','3308000','kasir','2026-10-19 12:02:46','F32619120246'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326191202461','2026-10-19','12:02:46','FIT','3308000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0008','D','2026-10-19','12:02:46','kasir','PENJUALAN','F326191202461','7918693000','3308000','7922001000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326191242381','kasir','1',' MED2E X LG','TOKO','PM-D','D2E-ZEXI-41-0','LT X MODEL MATA LG 8K ','','0.750','1','100.00','782000','0','0','15000','783000','0','0','0','783000','SIN','00402862','D2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEXI-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-10-19' AND kode_barang='D2E-ZEXI-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191242381','2026-10-19','0.750','2026-10-19','12:42:39','PLG0031973','783000','783000','0','783000','783000','kasir','2026-10-19 12:42:38','F32619124238'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-19','F326191242381','2026-10-19','12:42:39','SIN','783000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261019-0009','D','2026-10-19','12:42:39','kasir','PENJUALAN','F326191242381','7922001000','783000','7922784000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020586','X-00020586','KL X GUCCI UB 44 9K','GR','---','H2J','BELI','BELI001','2112000','2026-10-19','1.970','1','kasir','2026-10-19 13:46:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2J'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020586','X-00020586'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261019-0001','F326130943101','LIS','1','BELI','BELI001','H2J', 'X-00020586', 'KL X GUCCI UB 44 9K','1.970','1.970','100.00','2355000','2112000','1072081','1143000','1','2112000','2112000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261019-0001','2026-10-19','2026-10-19','13:46:42','LIS','---','1.970','2112000','2112000','2112000','2112000','2112000','kasir','2026-10-19 13:46:43','FB-261019-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261019-0001','MARSI','PURWANTORO','','','','kasir','2026-10-19 13:46:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-19' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261019-0010','K','2026-10-19','13:46:42','kasir','PEMBELIAN UMUM','FB-261019-0001','7922784000','2112000','7920672000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020587','X-00020587','CC X MODEL MATA VAR SLEP PM 16 8K','GR','---','E2D','BELI','BELI001','1367000','2026-10-19','1.450','1','kasir','2026-10-19 13:57:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020587','X-00020587'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261019-0002','F326031137592','AAT','1','BELI','BELI001','E2D', 'X-00020587', 'CC X MODEL MATA VAR SLEP PM 16 8K','1.450','1.450','100.00','1472000','1367000','942759','1033000','1','1367000','1367000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261019-0002','2026-10-19','2026-10-19','13:57:06','AAT','---','1.450','1367000','1367000','1367000','1367000','1367000','kasir','2026-10-19 13:57:07','FB-261019-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261019-0002','RATNA','BONGGI GAMBIRANOM','','','082257382004','kasir','2026-10-19 13:57:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-19' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261019-0011','K','2026-10-19','13:57:06','kasir','PEMBELIAN UMUM','FB-261019-0002','7920672000','1367000','7919305000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020588','X-00020588','KL MILANO UB 42 8K','GR','---','H1E','BELI','BELI001','1790000','2026-10-19','2.000','1','kasir','2026-10-19 14:00:20'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020588','X-00020588'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261019-0003','F326211215291','SIN','1','BELI','BELI001','H1E', 'X-00020588', 'KL MILANO UB 42 8K','2.000','2.000','100.00','2106000','1790000','895000','1053000','1','1790000','1790000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261019-0003','2026-10-19','2026-10-19','14:00:20','SIN','---','2.000','1790000','1790000','1790000','1790000','1790000','kasir','2026-10-19 14:00:20','FB-261019-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261019-0003','FITRI','PONOROGO','','','','kasir','2026-10-19 14:00:20'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-19' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261019-0012','K','2026-10-19','14:00:20','kasir','PEMBELIAN UMUM','FB-261019-0003','7919305000','1790000','7917515000'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020589','X-00020589','KL SANTA MODEL HERME CAT VAR HW 8K','GR','---','H1F','BELI','BELI001','1425000','2026-10-19','1.960','1','kasir','2026-10-19 14:01:55'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00020589','X-00020589'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261019-0004','F324131015556','LIS','1','BELI','BELI001','H1F', 'X-00020589', 'KL SANTA MODEL HERME CAT VAR HW 8K','2.330','1.960','100.00','1382000','1425000','727041','1073000','1','1425000','1425000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.960',berat_beli_asli=berat_beli_asli+'1.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.960',berat_akhir_asli=berat_akhir_asli+'1.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261019-0004','2026-10-19','2026-10-19','14:01:54','LIS','---','1.960','1425000','1425000','1425000','1425000','1425000','kasir','2026-10-19 14:01:55','FB-261019-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261019-0004','SINDY','GENENG BULUKERTO','','','','kasir','2026-10-19 14:01:55'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-19' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261019-0013','K','2026-10-19','14:01:54','kasir','PEMBELIAN UMUM','FB-261019-0004','7917515000','1425000','7916090000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261019-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261019-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261019-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261019-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261019-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261019-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261019-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261019-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190902461' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190902461' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190902461'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190912471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190912471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190912471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190913451' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190913451' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190913451'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191142021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191142021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191142021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191142022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191142022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191142022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191200101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191200101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191200101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191202461' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191202461' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191202461'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191242381' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191242381' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191242381'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-20','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-19'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-19'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-19'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-19' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-19'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-19'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-19'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-19'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-20' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-19' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261020-0001','D','2026-10-20','15:16:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','7916090000','7916090000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261020-0001','D','2026-10-20','15:16:07','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261020-0001','D','2026-10-20','15:16:07','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261020-0001','D','2026-10-20','15:16:07','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-20';