INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','08:25:43'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-10 ','08:37:12'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-10','119','0','-182900000','119','0','-182900000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-09'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-09'; 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-09' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-09'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-09'; 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-10' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-09' 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-261010-0001','D','2026-10-10','08:37:21','','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-261010-0001','D','2026-10-10','08:37:21','BCA','SALDO AWAL','SALDO AWAL','0','1366639582','1366639582'); UPDATE tp_system SET tgl_system='2026-10-10'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-10 ','08:37:34'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','08:46:41'); INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261010-0001','1','X-00009900','BELI','BELI001','AT ITALY BT BTR SHB','1','1.300','1859000.00' ,'0.00','1859000','','1859000','1859000','RUSAK ADA HILANG'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-10 08:46:59' WHERE kode_barang='X-00009900' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009900' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009900' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.300',berat_hancur_asli=berat_hancur_asli+'1.300', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261010-0001','2','X-00009901','BELI','BELI001','KL FANCY DB 42CM KKT S UBS','1','5.570','3899000.00' ,'0.00','3899000','','3899000','7617000','RONGSOK'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-10 08:46:59' WHERE kode_barang='X-00009901' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009901' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009901' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'5.570',berat_hancur_asli=berat_hancur_asli+'5.570', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'5.570',berat_akhir_asli=berat_akhir_asli-'5.570' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261010-0001','3','X-00009902','BELI','BELI001','CN PLINTIR SHB','1','1.890','3059500.00' ,'0.00','3059500','','3059500','14575500','MULUS'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-10 08:46:59' WHERE kode_barang='X-00009902' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009902' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009902' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.890',berat_hancur_asli=berat_hancur_asli+'1.890', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-261010-0001','4','X-00009903','BELI','BELI001','CN COR SLP BT SHB','1','0.950','1358000.00' ,'0.00','1358000','','1358000','18993000','RONGSOK'); UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-10-10 08:46:59' WHERE kode_barang='X-00009903' AND kode_lokasi_toko ='BELI001' LIMIT 1; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009903' AND kode_lokasi_toko ='BELI001' LIMIT 1; DELETE FROM tm_barang_beli WHERE kode_barang='X-00009903' AND kode_lokasi_toko ='BELI001' LIMIT 1; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.950',berat_hancur_asli=berat_hancur_asli+'0.950', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1; INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-261010-0001','adminpusat','2026-10-10','2026-10-10','08:47:00','10175500','18993000', 'adminpusat','2026-10-10 08:46:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-10-10 ','09:00:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-10-10 ','10:14:41'); INSERT INTO tm_credit_card(id_card,nama_customer,no_ktp,alamat1,alamat2,kota,no_telp,tgl_daftar,tgl_valid_until,tgl_last_gesek) VALUES ('6019007609732053','BCA','', ' ' , ' ' , ' ' ,'','2026-10-10 10:54:11','','2026-10-10 10:54:11'); 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-261010-0001','sales','1',' ','TOKO','BTGLMT','MTGL-ZIXI-113-0','GL BANGKOK TL AIR SHB ','','4.830','1','100.00','8887500','0','0','0','8887500','0','0','0','8887500','2502','00031417','MTGL','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZIXI-113-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.830',berat_jual_asli=berat_jual_asli+'4.830',stock_jual='1',berat_akhir=berat_akhir-'4.830',berat_akhir_asli=berat_akhir_asli-'4.830',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='MTGL-ZIXI-113-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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-261010-0001','2026-10-10','4.830','2026-10-10','10:54:21','PLG0019570','8887500','8887500','0','8887500','7000000','sales','2026-10-10 10:54:18','FJ-261010-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-10-10','FJ-261010-0001','2026-10-10','10:54:21','2502','8887500','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-261010-0002','D','2026-10-10','10:54:21','sales','PENJUALAN','FJ-261010-0001','141014086','7000000','148014086','OPEN'); INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-261010-0001','2026-10-10','2026-10-10 10:54:18','PENJUALAN : FJ-261010-0001','6019007609732053','BCA','1887500','1887500','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0002','D','2026-10-10','10:54:21','BCA','PENJUALAN','FJ-261010-0001','1366639582','1887500','1368527082','DEBET'); UPDATE tt_jual_head SET dibayar_rp='7000000',debet_rp='1887500',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0001'; 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-261010-0002','sales','1',' EX ','TOKO','BTATMD','MDAT-ZHBI-2-0','AT JEPSI POLOS MK ','','0.480','1','100.00','533000','0','0','0','533000','0','0','0','533000','2105','00031174','MDAT','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZHBI-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='MDAT-ZHBI-2-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-261010-0002','2026-10-10','0.480','2026-10-10','11:03:52','PLG0019571','533000','533000','0','533000','0','sales','2026-10-10 11:03:52','FJ-261010-0002'); 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-10','FJ-261010-0002','2026-10-10','11:03:52','2105','533000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0001','2026-10-10','2026-10-10 11:03:52','PENJUALAN : FJ-261010-0002','anisa','BCA','533000','533000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0003','D','2026-10-10','11:03:52','BCA','PENJUALAN','FJ-261010-0002','1368527082','533000','1369060082','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('anisa','DANA'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='533000' WHERE no_faktur_jual='FJ-261010-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0002'; 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-261010-0003','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZIAH-21-0','CN COR TDK BT SHB ','','1.820','1','100.00','2020500','0','0','0','2020500','0','0','0','2020500','2103','00031458','MDCN','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZIAH-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='MDCN-ZIAH-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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-261010-0003','2026-10-10','1.820','2026-10-10','11:38:37','PLG0019572','2020500','2020500','0','2020500','2020500','sales','2026-10-10 11:38:37','FJ-261010-0003'); 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-10','FJ-261010-0003','2026-10-10','11:38:37','2103','2020500','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-261010-0003','D','2026-10-10','11:38:37','sales','PENJUALAN','FJ-261010-0003','148014086','2020500','150034586'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0003'; UPDATE tt_hutang_head SET byr_harus_rp='1000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1037000',tgl_lunas='2026-10-10',status='CLOS',total_lunas='1037000' WHERE no_hutang='PI26-01847'; UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1000000' WHERE tanggal='2026-10-10'; 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-261010-0004','D','2026-10-10','12:10:57','cashier1','HUTANG LUNAS','PI26-01847','150034586','1037000','151071586'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','12:32:38'); 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-261010-0004','sales','1',' ','TOKO','BTATMT','MTAT-ZGBG-42-0','AT KLP KTK BT SHB ','','1.330','1','100.00','2447500','0','0','0','2447500','0','0','0','2447500','2402','00030889','MTAT','221000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZGBG-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='MTAT-ZGBG-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-261010-0004','2026-10-10','1.330','2026-10-10','13:23:03','PLG0019573','2447500','2447500','0','2447500','2447500','sales','2026-10-10 13:23:03','FJ-261010-0004'); 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-10','FJ-261010-0004','2026-10-10','13:23:03','2402','2447500','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-261010-0005','D','2026-10-10','13:23:03','sales','PENJUALAN','FJ-261010-0004','151071586','2447500','153519086'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0004'; 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-00009904','X-00009904','CN SESER SHB','GR','---','MTCN','BELI','BELI001','8111000','2026-10-10','5.010','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009904','X-00009904'); 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-261010-0001','FJ-240701-0001','2106','1','BELI','BELI001','MTCN', 'X-00009904', 'CN SESER SHB','5.110','5.010','100.00','4829000','8111000','1618962','1','8111000','8111000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.010',berat_beli_asli=berat_beli_asli+'5.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.010',berat_akhir_asli=berat_akhir_asli+'5.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-261010-0001','2026-10-10','2026-10-10','13:46:16','2106','---','5.010','8111000','8111000','8111000','8111000','8111000','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0001','ROKAYAH','SDA','','','','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0006','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0001','153519086','8111000','145408086','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-00009905','X-00009905','GL KERONCONG PLINTIR KOMB 6 SHB','GR','---','MTGL','BELI','BELI001','25625500','2026-10-10','17.920','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009905','X-00009905'); 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-261010-0002','FJ-240124-0003','2106','2','BELI','BELI001','MTGL', 'X-00009905', 'GL KERONCONG PLINTIR KOMB 6 SHB','18.020','17.920','100.00','14326000','25625500','1429994','1','25625500','25625500','RONGSOK'); 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-10-10','BELI','BELI001','MTGL','MTGL','100.00','17.920','17.920','1','17.920','17.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-261010-0002','2026-10-10','2026-10-10','13:46:16','2106','---','17.920','25625500','25625500','25625500','25625500','25625500','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0002','ROKAYYEH','TEBEL SDA','','','087754305437','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0007','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0002','145408086','25625500','119782586','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-00009906','X-00009906','LT COR JODHA SHB','GR','---','MTLT','BELI','BELI001','6136000','2026-10-10','3.790','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTLT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTLT','X-00009906','X-00009906'); 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-261010-0003','FJ-240722-0007','2106','3','BELI','BELI001','MTLT', 'X-00009906', 'LT COR JODHA SHB','3.890','3.790','100.00','3793000','6136000','1618997','1','6136000','6136000','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-10-10','BELI','BELI001','MTLT','MTLT','100.00','3.790','3.790','1','3.790','3.790','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-261010-0003','2026-10-10','2026-10-10','13:46:16','2106','---','3.790','6136000','6136000','6136000','6136000','6136000','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0003','ROKAYYA','SIDOARJO','','','087739892277','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0008','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0003','119782586','6136000','113646586','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-00009907','X-00009907','KL RANTAI PJG 65CM KKT PER SHB','GR','---','MTKL','BELI','BELI001','43178500','2026-10-10','26.670','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009907','X-00009907'); 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-261010-0004','FJ-240722-0006','2106','4','BELI','BELI001','MTKL', 'X-00009907', 'KL RANTAI PJG 65CM KKT PER SHB','26.770','26.670','100.00','26101000','43178500','1618991','1','43178500','43178500','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-10-10','BELI','BELI001','MTKL','MTKL','100.00','26.670','26.670','1','26.670','26.670','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-261010-0004','2026-10-10','2026-10-10','13:46:16','2106','---','26.670','43178500','43178500','43178500','43178500','43178500','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0004','ROKAYYA','SIDOARJO','','','087739892277','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0009','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0004','113646586','43178500','70468086','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-00009908','X-00009908','CN COR TDK BT SHB','GR','---','MTCN','BELI','BELI001','3577500','2026-10-10','2.210','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009908','X-00009908'); 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-261010-0005','FJ-241015-0009','2106','5','BELI','BELI001','MTCN', 'X-00009908', 'CN COR TDK BT SHB','2.260','2.210','100.00','2271500','3577500','1618778','1','3577500','3577500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.210',berat_beli_asli=berat_beli_asli+'2.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.210',berat_akhir_asli=berat_akhir_asli+'2.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-261010-0005','2026-10-10','2026-10-10','13:46:16','2106','---','2.210','3577500','3577500','3577500','3577500','3577500','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0005','ROKAYA','SIDOARJO','','','','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0010','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0005','70468086','3577500','66890586','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-00009909','X-00009909','CN COR DB SHB','GR','---','MTCN','BELI','BELI001','2007500','2026-10-10','1.240','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009909','X-00009909'); 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-261010-0006','FJ-211210-0010','2106','6','BELI','BELI001','MTCN', 'X-00009909', 'CN COR DB SHB','1.290','1.240','100.00','858000','2007500','1618952','1','2007500','2007500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.240',berat_beli_asli=berat_beli_asli+'1.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.240',berat_akhir_asli=berat_akhir_asli+'1.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-261010-0006','2026-10-10','2026-10-10','13:46:16','2106','---','1.240','2007500','2007500','2007500','2007500','2007500','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0006','ROKAYYAH','TEBEL BARAT SDA','','','087754305437','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0011','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0006','66890586','2007500','64883086','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-00009910','X-00009910','GL VANESSA DOLLAR CDY 17CM KKT PER SHB','GR','---','MTGL','BELI','BELI001','8030000','2026-10-10','4.960','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009910','X-00009910'); 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-261010-0007','FJ-220331-0010','2106','7','BELI','BELI001','MTGL', 'X-00009910', 'GL VANESSA DOLLAR CDY 17CM KKT PER SHB','5.060','4.960','100.00','3517000','8030000','1618952','1','8030000','8030000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.960',berat_beli_asli=berat_beli_asli+'4.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.960',berat_akhir_asli=berat_akhir_asli+'4.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' 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-261010-0007','2026-10-10','2026-10-10','13:46:16','2106','---','4.960','8030000','8030000','8030000','8030000','8030000','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0007','AYNIA','TEBEL SDA','','','087851807618','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0012','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0007','64883086','8030000','56853086','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-00009911','X-00009911','GL BLB VAR 16CM KKT PER SHB','GR','---','MTGL','BELI','BELI001','6735000','2026-10-10','4.160','1','sales','2026-10-10 13:46:17'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009911','X-00009911'); 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-261010-0008','FJ-241015-0007','2106','8','BELI','BELI001','MTGL', 'X-00009911', 'GL BLB VAR 16CM KKT PER SHB','4.260','4.160','100.00','4281500','6735000','1618990','1','6735000','6735000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.160',berat_beli_asli=berat_beli_asli+'4.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.160',berat_akhir_asli=berat_akhir_asli+'4.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' 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-261010-0008','2026-10-10','2026-10-10','13:46:16','2106','---','4.160','6735000','6735000','6735000','6735000','6735000','sales','2026-10-10 13:46:17','FB-261010-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0008','ROKAYAH','SIDOARJO','','','','sales','2026-10-10 13:46:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0013','K','2026-10-10','13:46:16','sales','PEMBELIAN UMUM','FB-261010-0008','56853086','6735000','50118086','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0008'; 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-261010-0014','K','2026-10-10','14:14:10','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB','50118086','54000','50064086'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','14:43:04'); 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-261010-0005','sales','1',' ','TOKO','BTGLMD','MDGL-ZJXB-4-0','GL PAJERO 18CM KKT PER SHB ','','3.060','1','100.00','3397000','0','0','0','3397000','0','0','0','3397000','2502','00031531','MDGL','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZJXB-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJXB-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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-261010-0005','2026-10-10','3.060','2026-10-10','14:51:57','PLG0019574','3397000','3397000','0','3397000','3397000','sales','2026-10-10 14:51:57','FJ-261010-0005'); 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-10','FJ-261010-0005','2026-10-10','14:51:57','2502','3397000','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-261010-0015','D','2026-10-10','14:51:57','sales','PENJUALAN','FJ-261010-0005','50064086','3397000','53461086','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3397000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0005' 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,potong_rp) VALUES ('FJ-261010-0006','sales',' 1',' EX ','TOKO','BTGWMD','MDGW-ZGAE-78-0','GW COR TDK BT LC2 ','','0.750','1','100.00','832500','0','0','0','832500','0','0','0','832500','2502','00030830','MDGW','155500','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGW-ZGAE-78-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-10' AND kode_barang='MDGW-ZGAE-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGWMD' 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-261010-0006','2026-10-10','0.750','2026-10-10','14:51:57','PLG0019575','832500','832500','0','832500','832500','sales','2026-10-10 14:51:57','FJ-261010-0005'); 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-10','FJ-261010-0006','2026-10-10','14:51:57','2502','832500','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-261010-0016','D','2026-10-10','14:51:57','sales','PENJUALAN','FJ-261010-0006','53461086','832500','54293586','OPEN'); UPDATE tt_jual_head SET dibayar_rp='832500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0006'; 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-00009912','X-00009912','GL ITALY ST SRT VAR BT 17CM KKT PER BLT MK','GR','---','MTGL','BELI','BELI001','5358500','2026-10-10','3.310','1','sales','2026-10-10 15:52:44'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009912','X-00009912'); 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-261010-0009','FJ-240911-0005','2105','1','BELI','BELI001','MTGL', 'X-00009912', 'GL ITALY ST SRT VAR BT 17CM KKT PER BLT MK','3.390','3.310','100.00','3305500','5358500','1618882','1','5358500','5358500','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-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' 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-261010-0009','2026-10-10','2026-10-10','15:52:43','2105','---','3.310','5358500','5358500','5358500','5358500','5358500','sales','2026-10-10 15:52:44','FB-261010-0009','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0009','LINDA','KARANG TEMBOK 4/4','','','081327152471','sales','2026-10-10 15:52:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-10' 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-261010-0017','K','2026-10-10','15:52:43','sales','PEMBELIAN UMUM','FB-261010-0009','54293586','5358500','48935086','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0009'; 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-261010-0018','D','2026-10-10','16:27:24','cashier1','PEMASUKAN','TERIMA DARI PUSAT PAK BUDI','48935086','100000000','148935086');