INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-26 ','08:42:27'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-26','119','0','-176500000','119','0','-176500000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-25'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-25'; 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-09-25' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-25'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-25'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-25'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-25'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08'; UPDATE tt_barang_saldo SET tanggal= '2026-09-26' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-25' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; 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-260926-0001','D','2026-09-26','08:42:44','BCA','SALDO AWAL','SALDO AWAL','0','1350626082','1350626082'); 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-260926-0001','D','2026-09-26','08:42:44','','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-09-26'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-26 ','08:42:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-26 ','08:52:12'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-26 ','10:17:49'); 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-00009853','X-00009853','AT ITALY HT BT SHB','GR','---','MTAT','BELI','BELI001','1489000','2026-09-26','0.920','1','sales','2026-09-26 10:18:36'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009853','X-00009853'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260926-0001','FJ-250722-0002','2502','1','BELI','BELI001','MTAT', 'X-00009853', 'AT ITALY HT BT SHB','0.970','0.920','100.00','1314500','1489000','1618478','1','1489000','1489000','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-26','BELI','BELI001','MTAT','MTAT','100.00','0.920','0.920','1','0.920','0.920','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,status_valid) VALUES ('FB-260926-0001','2026-09-26','2026-09-26','10:18:35','2502','---','0.920','1489000','1489000','1489000','1489000','1489000','sales','2026-09-26 10:18:36','FB-260926-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260926-0001','FIRDA','SIDODADI','','','087743341392','sales','2026-09-26 10:18:36'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-26' 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,status_valid) VALUES ('KK-260926-0002','K','2026-09-26','10:18:35','sales','PEMBELIAN UMUM','FB-260926-0001','106424286','1489000','104935286','OPEN'); 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-00009854','X-00009854','GW COR TDK BT LC2','GR','---','MDGW','BELI','BELI001','601000','2026-09-26','0.630','1','sales','2026-09-26 10:35:09'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGW'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGW','X-00009854','X-00009854'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260926-0002','FJ-260816-0002','2403','1','BELI','BELI001','MDGW', 'X-00009854', 'GW COR TDK BT LC2','0.630','0.630','100.00','715500','601000','953968','1','601000','601000','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-26','BELI','BELI001','MDGW','MDGW','100.00','0.630','0.630','1','0.630','0.630','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,status_valid) VALUES ('FB-260926-0002','2026-09-26','2026-09-26','10:35:08','2403','---','0.630','601000','601000','601000','601000','601000','sales','2026-09-26 10:35:09','FB-260926-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260926-0002','VONY','BULAK KALI TINJANG BARU BLOK A/81','','','0895328255242','sales','2026-09-26 10:35:09'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-26' 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,status_valid) VALUES ('KK-260926-0003','K','2026-09-26','10:35:08','sales','PEMBELIAN UMUM','FB-260926-0002','104935286','601000','104334286','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260926-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260926-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260926-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260926-0002'; UPDATE tt_hutang_head SET byr_harus_rp='2000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'2080000',tgl_lunas='2026-09-26',status='CLOS',total_lunas='2080000' WHERE no_hutang='PI26-01836'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000' WHERE tanggal='2026-09-26'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'2',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'2',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000' WHERE tanggal='2026-09-26'; 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-260926-0004','D','2026-09-26','11:10:51','cashier1','HUTANG LUNAS','PI26-01836','104334286','2080000','106414286'); 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-00009855','X-00009855','CN COR FORTUNE LC2','GR','---','MDCN','BELI','BELI001','3159000','2026-09-26','3.310','1','sales','2026-09-26 12:52:21'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009855','X-00009855'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260926-0003','FJ-240325-0004','2106','1','BELI','BELI001','MDCN', 'X-00009855', 'CN COR FORTUNE LC2','3.410','3.310','100.00','1896000','3159000','954381','1','3159000','3159000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.310',berat_beli_asli=berat_beli_asli+'3.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.310',berat_akhir_asli=berat_akhir_asli+'3.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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,status_valid) VALUES ('FB-260926-0003','2026-09-26','2026-09-26','12:52:20','2106','---','3.310','3159000','3159000','3159000','3159000','3159000','sales','2026-09-26 12:52:21','FB-260926-0003','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260926-0003','ROMLAH','SUMBO 2/25','','SBY','087853469492','sales','2026-09-26 12:52:21'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-26' 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,status_valid) VALUES ('KK-260926-0005','K','2026-09-26','12:52:20','sales','PEMBELIAN UMUM','FB-260926-0003','106414286','3159000','103255286','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260926-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260926-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-26 ','14:01:23'); 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-00009856','X-00009856','CN COR BT SHB','GR','---','MDCN','BELI','BELI001','878000','2026-09-26','0.920','1','sales','2026-09-26 14:18:26'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009856','X-00009856'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260926-0004','FJ-260618-0001','2403','1','BELI','BELI001','MDCN', 'X-00009856', 'CN COR BT SHB','0.920','0.920','100.00','1044500','878000','954348','1','878000','878000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.920',berat_beli_asli=berat_beli_asli+'0.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.920',berat_akhir_asli=berat_akhir_asli+'0.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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,status_valid) VALUES ('FB-260926-0004','2026-09-26','2026-09-26','14:18:26','2403','---','0.920','878000','878000','878000','878000','878000','sales','2026-09-26 14:18:26','FB-260926-0004','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260926-0004','IBU. SUHARTIK','KOMP SDTP BRT 3/28','','','','sales','2026-09-26 14:18:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-26' 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,status_valid) VALUES ('KK-260926-0006','K','2026-09-26','14:18:26','sales','PEMBELIAN UMUM','FB-260926-0004','103255286','878000','102377286','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260926-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260926-0004'; 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,potong_rp) VALUES ('FJ-260926-0001','sales','1',' EX ','TOKO','BTATMD','MDAT-ZDAX-8-0','AT COR KLP BT MK ','','1.150','1','100.00','1276500','0','0','0','1276500','0','0','0','1276500','2602','00029038','MDAT','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-09-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZDAX-8-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-09-26' AND kode_barang='MDAT-ZDAX-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260926-0001','2026-09-26','1.150','2026-09-26','14:26:55','PLG0019517','1276500','1276500','0','1276500','1276500','sales','2026-09-26 14:26:54','FJ-260926-0001'); 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-09-26','FJ-260926-0001','2026-09-26','14:26:55','2602','1276500','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-260926-0007','D','2026-09-26','14:26:55','sales','PENJUALAN','FJ-260926-0001','102377286','1276500','103653786'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260926-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260926-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260926-0001'; 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-00009857','X-00009857','AT TINDIK TALI AIR SHB','GR','---','MTAT','BELI','BELI001','679500','2026-09-26','0.420','1','sales','2026-09-26 15:26:46'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009857','X-00009857'); 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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260926-0005','FJ-230726-0003','2402','1','BELI','BELI001','MTAT', 'X-00009857', 'AT TINDIK TALI AIR SHB','0.470','0.420','100.00','345500','679500','1617857','1','679500','679500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' 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,status_valid) VALUES ('FB-260926-0005','2026-09-26','2026-09-26','15:26:46','2402','---','0.420','679500','679500','679500','679500','679500','sales','2026-09-26 15:26:46','FB-260926-0005','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260926-0005','ROMLAH','ARIMBI 12','','','081802221700','sales','2026-09-26 15:26:46'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-26' 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,status_valid) VALUES ('KK-260926-0008','K','2026-09-26','15:26:46','sales','PEMBELIAN UMUM','FB-260926-0005','103653786','679500','102974286','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260926-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260926-0005';