INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','08:34:38'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSPRE-ZKXF-36-0','1','3.370','3.370','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRE-ZKXF-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXF-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRE-ZKXF-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRE-ZKXF-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSPRE-ZKXF-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRE-ZKXF-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSPRE','PSPRE-ZKXF-36-0','1','3.370','3.370','1','3.370','3.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRE-ZKXF-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXF-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSPLE-ZKXF-55-0','1','3.190','3.190','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLE-ZKXF-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXF-55-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLE-ZKXF-55-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-ZKXF-55-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSPLE-ZKXF-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-ZKXF-55-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSPLE','PSPLE-ZKXF-55-0','1','3.190','3.190','1','3.190','3.190','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLE-ZKXF-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXF-55-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSGE-ZKXF-56-0','1','2.460','2.460','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSGE-ZKXF-56-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGE-ZKXF-56-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGE-ZKXF-56-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGE-ZKXF-56-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSGE-ZKXF-56-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGE-ZKXF-56-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSGE','PSGE-ZKXF-56-0','1','2.460','2.460','1','2.460','2.460','83.00'); DELETE FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGE-ZKXF-56-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZKXF-56-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSPRE-ZKXF-57-0','1','1.460','1.460','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRE-ZKXF-57-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXF-57-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRE-ZKXF-57-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRE-ZKXF-57-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSPRE-ZKXF-57-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRE-ZKXF-57-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSPRE','PSPRE-ZKXF-57-0','1','1.460','1.460','1','1.460','1.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRE-ZKXF-57-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXF-57-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSPLE-ZKXG-1-0','1','2.190','2.190','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLE-ZKXG-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXG-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLE-ZKXG-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-ZKXG-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSPLE-ZKXG-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-ZKXG-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSPLE','PSPLE-ZKXG-1-0','1','2.190','2.190','1','2.190','2.190','57.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLE-ZKXG-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXG-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0001','1','PSPLE-ZKXG-2-0','1','3.170','3.170','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLE-ZKXG-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXG-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLE-ZKXG-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-ZKXG-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-11-07 08:34:50' WHERE kode_barang='PSPLE-ZKXG-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-ZKXG-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 08:34:50','TOKO','PSN','PSPLE','PSPLE-ZKXG-2-0','1','3.170','3.170','1','3.170','3.170','57.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLE-ZKXG-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZKXG-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261107-0001','2026-11-07','08:34','15.840','kasir','2026-11-07 08:34:49'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','10:55:19'); UPDATE th_user_login SET tgl_logout = '2026-11-07', jam_logout = '12:15:45' WHERE user_id = 'kasir' AND tgl_login = '2026-11-07' AND jam_login= '10:55:19'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-07 ','12:26:49'); UPDATE tm_user SET nama_lkp='ANTON GUNAWAN ',pass_key='pw~w~‡wGMIOKU',type='OWN' WHERE user_id='owner'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-07 ','12:29:39'); UPDATE tm_user SET nama_lkp='ANTON GUNAWAN ',pass_key='yA4opwAGCIEO',type='OWN' WHERE user_id='owner'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-11-07 ','12:30:49'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0001','1','CKBE-XFXG-21-0','TOKO','CKB','CINCIN KAWIN CKBE-00921','1','3.780','AMBI'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:32:46',status_delete='3.780' WHERE kode_barang='CKBE-XFXG-21-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CKBE-XFXG-21-0'; DELETE FROM tm_barang WHERE kode_barang='CKBE-XFXG-21-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.780,berat_hancur_asli=berat_hancur_asli+3.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CKB' AND kode_barang='CKBE-XFXG-21-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0001','2026-11-07','owner','2026-11-07','12:32:46','owner','2026-11-07 12:32:46','AMBIL BERLIAN UNTUK PESANAN'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0002','1','GBRE-ZIBC-1-0','TOKO','GBR','GELANG GBRE-01338','1','10.520','AMBI'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:35:15',status_delete='10.520' WHERE kode_barang='GBRE-ZIBC-1-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='GBRE-ZIBC-1-0'; DELETE FROM tm_barang WHERE kode_barang='GBRE-ZIBC-1-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.520,berat_hancur_asli=berat_hancur_asli+10.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='GBR' AND kode_barang='GBRE-ZIBC-1-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0002','2026-11-07','owner','2026-11-07','12:35:15','owner','2026-11-07 12:35:15','IDR GANTI'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0003','1','GBRE-ZFBE-13-0','TOKO','GBR','GELANG GBRE-00722 ','1','5.740','BANDROL ULANG'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:37:23',status_delete='5.740' WHERE kode_barang='GBRE-ZFBE-13-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='GBRE-ZFBE-13-0'; DELETE FROM tm_barang WHERE kode_barang='GBRE-ZFBE-13-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.740,berat_hancur_asli=berat_hancur_asli+5.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='GBR' AND kode_barang='GBRE-ZFBE-13-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0003','2026-11-07','owner','2026-11-07','12:37:23','owner','2026-11-07 12:37:23','GANTI SERUT KE BENGEL'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0004','1','KLBE-XKBI-11-0','TOKO','KLB','KALUNG KLBE-00839','1','16.250','AMBI'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:38:56',status_delete='16.250' WHERE kode_barang='KLBE-XKBI-11-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='KLBE-XKBI-11-0'; DELETE FROM tm_barang WHERE kode_barang='KLBE-XKBI-11-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+16.250,berat_hancur_asli=berat_hancur_asli+16.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='KLB' AND kode_barang='KLBE-XKBI-11-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0004','2026-11-07','owner','2026-11-07','12:38:56','owner','2026-11-07 12:38:56','AMBIL GANTI RANTAI'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-11-07 ','12:39:15'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0005','1','CBRE-ZEXD-61-0','TOKO','CBR','CBRE-07034 GIA 6485009440 ','1','1.900','GANTI MODEL'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:41:31',status_delete='1.900' WHERE kode_barang='CBRE-ZEXD-61-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEXD-61-0'; DELETE FROM tm_barang WHERE kode_barang='CBRE-ZEXD-61-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.900,berat_hancur_asli=berat_hancur_asli+1.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-ZEXD-61-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0005','2','CBRE-ZCAA-3-0','TOKO','CBR','CBRE-07016 GIA 3465783254 ','1','2.150','GANTI MODEL'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:41:31',status_delete='2.150' WHERE kode_barang='CBRE-ZCAA-3-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZCAA-3-0'; DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCAA-3-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.150,berat_hancur_asli=berat_hancur_asli+2.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-ZCAA-3-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0005','2026-11-07','owner','2026-11-07','12:41:31','owner','2026-11-07 12:41:31','GANTI MODEL'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0006','1','CBRE-ZGBD-13-0','TOKO','CBR','CBRE-07056 GIA 5543173295 ','1','3.830','GANTI MODEL'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:42:36',status_delete='3.830' WHERE kode_barang='CBRE-ZGBD-13-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZGBD-13-0'; DELETE FROM tm_barang WHERE kode_barang='CBRE-ZGBD-13-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.830,berat_hancur_asli=berat_hancur_asli+3.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-ZGBD-13-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0006','2026-11-07','owner','2026-11-07','12:42:36','owner','2026-11-07 12:42:36','SALAH BERLIAN'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0007','1','LGM50-YIBC-33-0','TOKO','LM','LOGAM MULIA 50 GR ','1','50.000','BANDROL ULANG'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:43:33',status_delete='50.000' WHERE kode_barang='LGM50-YIBC-33-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='LGM50-YIBC-33-0'; DELETE FROM tm_barang WHERE kode_barang='LGM50-YIBC-33-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+50.000,berat_hancur_asli=berat_hancur_asli+50.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='LM' AND kode_barang='LGM50-YIBC-33-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0007','2026-11-07','owner','2026-11-07','12:43:33','owner','2026-11-07 12:43:33','LM HIJAU AMBI'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-11-07 ','12:43:48'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0008','1','LM100-ZHAB-46-0','TOKO','LM','LM ANTAM 100 GR A76062380 ','1','100.000','AMBI'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:44:45',status_delete='100.000' WHERE kode_barang='LM100-ZHAB-46-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='LM100-ZHAB-46-0'; DELETE FROM tm_barang WHERE kode_barang='LM100-ZHAB-46-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+100.000,berat_hancur_asli=berat_hancur_asli+100.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='LM' AND kode_barang='LM100-ZHAB-46-0' AND stock_akhir > 0; INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0008','2','LM100-ZHAB-47-0','TOKO','LM','LM ANTAM 100 GR A76062376 ','1','100.000','AMBI'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 12:44:45',status_delete='100.000' WHERE kode_barang='LM100-ZHAB-47-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='LM100-ZHAB-47-0'; DELETE FROM tm_barang WHERE kode_barang='LM100-ZHAB-47-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+100.000,berat_hancur_asli=berat_hancur_asli+100.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='LM' AND kode_barang='LM100-ZHAB-47-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0008','2026-11-07','owner','2026-11-07','12:44:45','owner','2026-11-07 12:44:45','BANDROL ULANG'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-11-07 ','13:19:38'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-07 ','13:27:27'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-07 ','13:28:42'); INSERT INTO tt_titip_batal_detail SELECT * FROM tt_titip_detail WHERE no_titip = 'TU-250812-0001'; INSERT INTO tt_titip_batal_head SELECT * FROM tt_titip_head WHERE no_titip= 'TU-250812-0001'; UPDATE tt_barang_saldo SET stock_out= stock_out+'1' ,berat_out=berat_out+'3.340',berat_out_asli=berat_out_asli+'3.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.340',berat_akhir =berat_akhir_asli-'3.340' WHERE tanggal='2026-11-07'AND kode_barang = 'CBRE-XHBX-9-0' AND kode_lokasi_gudang = 'TITIP' AND kode_lokasi_toko = 'TITIP' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES ('2026-11-07','TOKO','CBR','CBRE','CBRE-XHBX-9-0','83.00','1','3.340','3.340','1','3.340','3.340'); INSERT INTO tm_barang SELECT * FROM tm_barang_titip WHERE kode_barang ='CBRE-XHBX-9-0'; DELETE FROM tm_barang_titip WHERE kode_barang ='CBRE-XHBX-9-0'; UPDATE tt_titip_head SET status ='CANC' WHERE no_titip ='TU-250812-0001'; 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-261107-0002','K','2026-11-07','13:33:44','Nagatech','TITIPAN BATAL','TU-250812-0001','4657044','0','4657044'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-11-07 ','13:36:40'); INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-261107-0009','1','CBRE-XHBX-9-0','TOKO','CBR','CBRE-06473 GIA 5496122222','1','3.340','HILANG'); UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-11-07 13:37:39',status_delete='3.340' WHERE kode_barang='CBRE-XHBX-9-0'; INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CBRE-XHBX-9-0'; DELETE FROM tm_barang WHERE kode_barang='CBRE-XHBX-9-0'; UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.340,berat_hancur_asli=berat_hancur_asli+3.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-XHBX-9-0' AND stock_akhir > 0; INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-261107-0009','2026-11-07','owner','2026-11-07','13:37:39','owner','2026-11-07 13:37:39','DP HILANG'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','13:40:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','13:59:01'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-27-0','1','1.190','1.190','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:16' WHERE kode_barang='CKPRE-ZKXG-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:16','TOKO','PERAK','CKPRE','CKPRE-ZKXG-27-0','1','1.190','1.190','1','1.190','1.190','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-28-0','1','1.800','1.800','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:16' WHERE kode_barang='CKPRE-ZKXG-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:16','TOKO','PERAK','CKPRE','CKPRE-ZKXG-28-0','1','1.800','1.800','1','1.800','1.800','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-29-0','1','1.790','1.790','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:16' WHERE kode_barang='CKPRE-ZKXG-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-29-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:16','TOKO','PERAK','CKPRE','CKPRE-ZKXG-29-0','1','1.790','1.790','1','1.790','1.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-30-0','1','1.870','1.870','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-30-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-30-0','1','1.870','1.870','1','1.870','1.870','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-31-0','1','1.830','1.830','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-31-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-31-0','1','1.830','1.830','1','1.830','1.830','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-32-0','1','1.430','1.430','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-32-0','1','1.430','1.430','1','1.430','1.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-33-0','1','1.430','1.430','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-33-0','1','1.430','1.430','1','1.430','1.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-34-0','1','4.360','4.360','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-34-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-34-0','1','4.360','4.360','1','4.360','4.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-35-0','1','4.390','4.390','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-35-0','1','4.390','4.390','1','4.390','4.390','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-36-0','1','4.520','4.520','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-36-0','1','4.520','4.520','1','4.520','4.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261107-0002','1','CKPRE-ZKXG-37-0','1','5.030','5.030','TOKO','PER','TOKO','PERAK'); DELETE FROM tm_barang WHERE kode_barang='CKPRE-ZKXG-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZKXG-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-ZKXG-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2026-11-07 13:59:17' WHERE kode_barang='CKPRE-ZKXG-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-ZKXG-37-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-07 13:59:17','TOKO','PERAK','CKPRE','CKPRE-ZKXG-37-0','1','5.030','5.030','1','5.030','5.030','100.00'); DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-ZKXG-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZKXG-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-07' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261107-0002','2026-11-07','13:59','29.640','kasir','2026-11-07 13:59:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','14:23:14'); 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,keterangan) VALUES ('FE-261107-0001','kasir','1',' 900K-13-12','TOKO','PERAK','CKPRE-ZKXD-34-0','CINCIN SILVER 925 ','','2.050','1','100.00','210000','0','0','18200','1000000','0','0','0','1000000','BARY','00048992','CKPRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZKXD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='CKPRE-ZKXD-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0001','2026-11-07','2.050','2026-11-07','14:25:06','PLG0029909','1000000','1000000','0','1000000','0','kasir','2026-11-07 14:25:05','FE-261107-0001','','POTONG'); 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-11-07','FE-261107-0001','2026-11-07','14:25:06','BARY','1000000','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-261107-0001','2026-11-07','2026-11-07 14:25:05','PENJUALAN : FE-261107-0001','','TBC','1000000','1000000','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-261107-0002','D','2026-11-07','14:25:06','TBC','PENJUALAN','FE-261107-0001','108727782255','1000000','108728782255','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FE-261107-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0001'; DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZKXB-14-0'; INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZKXB-14-0','CBRE-ZKXB-14-0','00048832','RD','1','0.045','475'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZKXB-14-0','00048832','RD','1','0.045','475','21.38') INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZKXB-14-0','CBRE-ZKXB-14-0','00048832','RD','8','0.075','320'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZKXB-14-0','00048832','RD','8','0.075','320','24') INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZKXB-14-0','CBRE-ZKXB-14-0','00048832','RD','13','0.060','320'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZKXB-14-0','00048832','RD','13','0.060','320','19.2') INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-ZKXB-14-0','00048832','00048832','CINCIN CBRE-05511 ','CINCIN CBRE-05511','','','2869000','2869000',' 0','0','kasir','2026-11-07 14:47:44'); UPDATE tm_barang SET nama_barang='CINCIN CBRE-05511' ,nama_atribut='' ,kode_intern='CBRE-05511 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS8 4B0 1026',total_usd_ext='IDB 16 000 000',total_usd='64.58' WHERE kode_barang='CBRE-ZKXB-14-0' 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,keterangan) VALUES ('FE-261107-0002','kasir','1',' CBRE-05511','TOKO','CBR','CBRE-ZKXB-14-0','CINCIN CBRE-05511','','1.700','1','75.00','4449000','1175500','65','18200','5250000','0','0','0','5250000','ONLILUNG','00048832','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZKXB-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='CBRE-ZKXB-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0002','2026-11-07','1.700','2026-11-07','14:48:33','PLG0029910','5250000','5250000','0','5250000','440000','kasir','2026-11-07 14:48:32','FE-261107-0002','','POTONG'); 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-11-07','FE-261107-0002','2026-11-07','14:48:33','ONLILUNG','5250000','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-261107-0003','D','2026-11-07','14:48:33','kasir','PENJUALAN BERLIAN','FE-261107-0002','4657044','440000','5097044','OPEN'); 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-261107-0002','2026-11-07','2026-11-07 14:48:32','PENJUALAN : FE-261107-0002','','TBC','4810000','4810000','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-261107-0003','D','2026-11-07','14:48:33','TBC','PENJUALAN BERLIAN','FE-261107-0002','108728782255','4810000','108733592255','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='440000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4810000' WHERE no_faktur_jual='FE-261107-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','15:23:16'); 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-00009503','X-00009503','CBRE03790','GR','---','CBRE','BELI','BELI001','15920000','2026-11-07','4.950','1','kasir','2026-11-07 15:27:29'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009503','X-00009503'); 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 ('BE-261107-0001','FE-220422-0019','BARY','1','BELI','BELI001','CBRE', 'X-00009503', 'CBRE03790','4.950','4.950','75.00','19900000','15920000','3216162','1','15920000','15920000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.950',berat_beli_asli=berat_beli_asli+'4.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.950',berat_akhir_asli=berat_akhir_asli+'4.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,type_bayar) VALUES ('BE-261107-0001','2026-11-07','2026-11-07','15:27:28','BARY','---','4.950','15920000','15920000','15920000','15920000','15920000','kasir','2026-11-07 15:27:29','BE-261107-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261107-0001','SEPTI MAULIANA','JAKPUS','JAKPUS','','0816979464','kasir','2026-11-07 15:27:29'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0003','2026-11-07','2026-11-07 15:27:29','PEMBELIAN UMUM : BE-261107-0001','-','TBC','15920000','15920000'); 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 ('KK-261107-0004','K','2026-11-07','15:27:28','TBC','PEMBELIAN UMUM','BE-261107-0001','108733592255','15920000','108717672255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','15:33:51'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261107-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261107-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-00009504','X-00009504','GIWANG ABRE-01918','GR','---','ABRE','BELI','BELI001','4560000','2026-11-07','2.550','1','kasir','2026-11-07 15:34:37'); DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00009504','X-00009504'); 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 ('BE-261107-0002','FE-250316-0008','BARY','1','BELI','BELI001','ABRE', 'X-00009504', 'GIWANG ABRE-01918','2.550','2.550','75.00','5700000','4560000','1788235','1','4560000','4560000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.550',berat_beli_asli=berat_beli_asli+'2.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.550',berat_akhir_asli=berat_akhir_asli+'2.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' 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,type_bayar) VALUES ('BE-261107-0002','2026-11-07','2026-11-07','15:34:36','BARY','---','2.550','4560000','4560000','4560000','4560000','4560000','kasir','2026-11-07 15:34:37','BE-261107-0002','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261107-0002','NOVI TRENA','JKT','','','/','kasir','2026-11-07 15:34:37'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0004','2026-11-07','2026-11-07 15:34:37','PEMBELIAN UMUM : BE-261107-0002','-','TBC','4560000','4560000'); 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 ('KK-261107-0005','K','2026-11-07','15:34:36','TBC','PEMBELIAN UMUM','BE-261107-0002','108717672255','4560000','108713112255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); 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-00009505','X-00009505','CINCIN CBRE-04701','GR','---','CBRE','BELI','BELI001','14250000','2026-11-07','4.940','1','kasir','2026-11-07 15:37:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009505','X-00009505'); 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 ('BE-261107-0003','FE-260722-0012','BARY','1','BELI','BELI001','CBRE', 'X-00009505', 'CINCIN CBRE-04701','4.940','4.940','75.00','18000000','14250000','2884615','1','14250000','14250000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.940',berat_beli_asli=berat_beli_asli+'4.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.940',berat_akhir_asli=berat_akhir_asli+'4.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,type_bayar) VALUES ('BE-261107-0003','2026-11-07','2026-11-07','15:37:26','BARY','---','4.940','14250000','14250000','14250000','14250000','14250000','kasir','2026-11-07 15:37:26','BE-261107-0003','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261107-0003','NOVI TRESNA','JKT','','','/','kasir','2026-11-07 15:37:26'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0005','2026-11-07','2026-11-07 15:37:26','PEMBELIAN UMUM : BE-261107-0003','-','TBC','14250000','14250000'); 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 ('KK-261107-0006','K','2026-11-07','15:37:26','TBC','PEMBELIAN UMUM','BE-261107-0003','108713112255','14250000','108698862255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); 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-00009506','X-00009506','CINCIN SYC-00049','GR','---','SYC','BELI','BELI001','6640000','2026-11-07','3.630','1','kasir','2026-11-07 15:40:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-SYC'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-SYC','X-00009506','X-00009506'); 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 ('BE-261107-0004','FE-250316-0011','BARY','1','BELI','BELI001','SYC', 'X-00009506', 'CINCIN SYC-00049','3.630','3.630','75.00','8300000','6640000','1829201','1','6640000','6640000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.630',berat_beli_asli=berat_beli_asli+'3.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.630',berat_akhir_asli=berat_akhir_asli+'3.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='SYC' 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,type_bayar) VALUES ('BE-261107-0004','2026-11-07','2026-11-07','15:40:03','BARY','---','3.630','6640000','6640000','6640000','6640000','6640000','kasir','2026-11-07 15:40:04','BE-261107-0004','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261107-0004','NOVI TRENA','JKT','','','/','kasir','2026-11-07 15:40:04'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0006','2026-11-07','2026-11-07 15:40:04','PEMBELIAN UMUM : BE-261107-0004','-','TBC','6640000','6640000'); 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 ('KK-261107-0007','K','2026-11-07','15:40:03','TBC','PEMBELIAN UMUM','BE-261107-0004','108698862255','6640000','108692222255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','15:40:11'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261107-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261107-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261107-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261107-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261107-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261107-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-00009507','X-00009507','GELANG GBRE-01273','GR','---','GBRE','BELI','BELI001','16000000','2026-11-07','8.810','1','kasir','2026-11-07 15:43:13'); DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00009507','X-00009507'); 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 ('BE-261107-0005','FE-250316-0009','BARY','1','BELI','BELI001','GBRE', 'X-00009507', 'GELANG GBRE-01273','8.810','8.810','75.00','20000000','16000000','1816118','1','16000000','16000000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'8.810',berat_beli_asli=berat_beli_asli+'8.810',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'8.810',berat_akhir_asli=berat_akhir_asli+'8.810',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBRE' 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,type_bayar) VALUES ('BE-261107-0005','2026-11-07','2026-11-07','15:43:12','BARY','---','8.810','16000000','16000000','16000000','16000000','16000000','kasir','2026-11-07 15:43:13','BE-261107-0005','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261107-0005','NOVI TRENA','JKT','','','/','kasir','2026-11-07 15:43:13'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0007','2026-11-07','2026-11-07 15:43:13','PEMBELIAN UMUM : BE-261107-0005','-','TBC','16000000','16000000'); 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 ('KK-261107-0008','K','2026-11-07','15:43:12','TBC','PEMBELIAN UMUM','BE-261107-0005','108692222255','16000000','108676222255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261107-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261107-0005'; 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,keterangan) VALUES ('FE-261107-0003','kasir','1',' DP-03156 ','TOKO','PSN','PSPRE-ZKXE-15-0','CINCIN PERAK CP09 ','','5.730','1','100.00','585000','0','0','18200','1500000','0','0','0','1500000','BARY','00049035','PSPRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRE-ZKXE-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.730',berat_jual_asli=berat_jual_asli+'5.730',stock_jual='1',berat_akhir=berat_akhir-'5.730',berat_akhir_asli=berat_akhir_asli-'5.730',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='PSPRE-ZKXE-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0003','2026-11-07','5.730','2026-11-07','15:56:20','PLG0029911','1500000','1500000','0','1500000','0','kasir','2026-11-07 15:56:20','FE-261107-0003','DP-03156','1500000'); 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-11-07','FE-261107-0003','2026-11-07','15:56:20','BARY','1500000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-261107-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0003'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08439','BARY','1','CBRE','DICROM ULANG PUTIH','3.140','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08439','2026-11-07','2026-11-07','16:12:06','PLG0029912','kasir','2026-11-10','kasir','2026-11-07 16:12:06','3.140','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','16:14:14'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08440','BARY','1','CBRE','DICROM ULANG PUTIH','3.140','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08440','2026-11-07','2026-11-07','16:17:33','PLG0029913','kasir','2026-11-10','kasir','2026-11-07 16:17:33','3.140','0','0','0','0','0','0','0','0'); 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,keterangan) VALUES ('FE-261107-0004','kasir','1',' ABRE-01722','TOKO','ABR','ABRE-ZABF-40-0','ANTING ABRE-01722 ','','3.150','1','75.00','11614000','5242000','288','18200','13000000','0','0','0','13000000','BARY','00041178','ABRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-ZABF-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='ABRE-ZABF-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0004','2026-11-07','3.150','2026-11-07','16:30:20','PLG0029914','13000000','13000000','0','13000000','0','kasir','2026-11-07 16:30:19','FE-261107-0004','','POTONG'); 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-11-07','FE-261107-0004','2026-11-07','16:30:20','BARY','13000000','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-261107-0008','2026-11-07','2026-11-07 16:30:19','PENJUALAN : FE-261107-0004','.','TBC','13000000','13000000','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-261107-0009','D','2026-11-07','16:30:20','TBC','PENJUALAN BERLIAN','FE-261107-0004','108676222255','13000000','108689222255','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='13000000' WHERE no_faktur_jual='FE-261107-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0004'; DELETE FROM tm_berlian WHERE kode_barang='CKSE-YGBD-82-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKSE-YGBD-82-0','00037544','00037544','CINCIN KAWIN SIRKON ELCO ','CINCIN KAWIN SIRKON ELCO','','','5389000','5389000',' 100000','100000','kasir','2026-11-07 17:58:33'); UPDATE tm_barang SET nama_barang='CINCIN KAWIN SIRKON ELCO' ,nama_atribut='' ,kode_intern='CKSE-700K ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKSE-YGBD-82-0' 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,keterangan) VALUES ('FE-261107-0005','kasir','1',' CKSE-700K ','TOKO','CKS','CKSE-YGBD-82-0','CINCIN KAWIN SIRKON ELCO','','2.860','1','83.00','5497000','0','0','18200','6900000','0','0','0','6900000','NANA','00037544','CKSE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKSE-YGBD-82-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='CKSE-YGBD-82-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKS' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0005','2026-11-07','2.860','2026-11-07','17:59:47','PLG0029915','6900000','6900000','0','6900000','0','kasir','2026-11-07 17:59:46','FE-261107-0005','','POTONG'); 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-11-07','FE-261107-0005','2026-11-07','17:59:47','NANA','6900000','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-261107-0009','2026-11-07','2026-11-07 17:59:46','PENJUALAN : FE-261107-0005','.','TBC','6900000','6900000','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-261107-0010','D','2026-11-07','17:59:47','TBC','PENJUALAN','FE-261107-0005','108689222255','6900000','108696122255','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6900000' WHERE no_faktur_jual='FE-261107-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0005'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','19:33:39'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','19:37:23'); DELETE FROM tm_berlian WHERE kode_barang='CMK-UFXG-1'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CMK-UFXG-1','00006709','00006709','CINCIN MAS KUNING','CINCIN MAS KUNING','','','3884500','3884500',' 0','0','kasir','2026-11-07 19:38:22'); UPDATE tm_barang SET nama_barang='CINCIN MAS KUNING' ,nama_atribut='' ,kode_intern='CMKE70-71%', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='70',total_usd_ext='',total_usd='0' WHERE kode_barang='CMK-UFXG-1' 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,keterangan) VALUES ('FE-261107-0006','kasir','1',' CMKE70-71%','TOKO','CMK','CMK-UFXG-1','CINCIN MAS KUNING','','2.410','1','71.00','3963000','0','0','18200','4400000','0','0','0','4400000','FAISAL','00006709','CMK','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMK-UFXG-1' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-11-07' AND kode_barang='CMK-UFXG-1' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CMK' 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,no_persekot,dp_pesanan) VALUES ('FE-261107-0006','2026-11-07','2.410','2026-11-07','19:39:11','PLG0029916','4400000','4400000','0','4400000','0','kasir','2026-11-07 19:39:10','FE-261107-0006','','POTONG'); 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-11-07','FE-261107-0006','2026-11-07','19:39:11','FAISAL','4400000','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-261107-0010','2026-11-07','2026-11-07 19:39:10','PENJUALAN : FE-261107-0006','','TBC','4400000','4400000','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-261107-0011','D','2026-11-07','19:39:11','TBC','PENJUALAN','FE-261107-0006','108696122255','4400000','108700522255','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4400000' WHERE no_faktur_jual='FE-261107-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261107-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261107-0006'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-07 ','19:48:30'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03180','NANA','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2250000','2200000','0','900000','5300000','size 16 5 grf Agung zirkon 19 butir','model sesuai cnth kode cbre 02363','crum full putih glosy max 2 gram','190000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0011','2026-11-07','2026-11-07 19:52:56','PESANAN : DP-03180','.','TBC','2745000','2745000'); 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-261107-0012','D','2026-11-07','19:52:56','TBC','PESANAN','DP-03180','108700522255','2745000','108703267255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03180','2026-11-07','2026-11-07','19:52:56','PLG0029917','NANA','2026-11-28','kasir','2026-11-07 19:52:56','2.000','0','0','0','2745000','0','900000','5490000','5490000','2745000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03181','NANA','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','size 21 5 grf Sulistiyawati','model sesuai cnth putih doff amplas','max 3 gram','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261107-0012','2026-11-07','2026-11-07 19:54:22','PESANAN : DP-03181','.','TBC','900000','900000'); 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-261107-0013','D','2026-11-07','19:54:22','TBC','PESANAN','DP-03181','108703267255','900000','108704167255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03181','2026-11-07','2026-11-07','19:54:22','PLG0029918','NANA','2026-11-28','kasir','2026-11-07 19:54:22','3.000','0','0','0','900000','0','750000','1800000','1800000','900000'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-08','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-08'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-07'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-07'; 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-11-07' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-07'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-07'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-07'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-07'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-08' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-07' 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-261108-0001','D','2026-11-08','20:15:48','TBC','SALDO AWAL','SALDO AWAL','0','108704167255','108704167255'); 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-261108-0001','D','2026-11-08','20:15:48','BCK','SALDO AWAL','SALDO AWAL','0','16924834978.088','16924834978.088'); 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-261108-0001','D','2026-11-08','20:15:48','TMR','SALDO AWAL','SALDO AWAL','0','8955983779','8955983779'); 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-261108-0001','D','2026-11-08','20:15:48','BCD','SALDO AWAL','SALDO AWAL','0','15172621700','15172621700'); 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-261108-0001','D','2026-11-08','20:15:48','SHO','SALDO AWAL','SALDO AWAL','0','2758505684','2758505684'); 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-261108-0001','D','2026-11-08','20:15:48','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900'); 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-261108-0001','D','2026-11-08','20:15:48','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-261108-0001','D','2026-11-08','20:15:48','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-261108-0001','D','2026-11-08','20:15:48','4000000','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-261108-0001','D','2026-11-08','20:15:48','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-261108-0001','D','2026-11-08','20:15:48','3450000','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-261108-0001','D','2026-11-08','20:15:48','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-261108-0001','D','2026-11-08','20:15:48','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-261108-0001','D','2026-11-08','20:15:48','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-261108-0001','D','2026-11-08','20:15:48','BCA','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-261108-0001','D','2026-11-08','20:15:48','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-261108-0001','D','2026-11-08','20:15:48','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-261108-0001','D','2026-11-08','20:15:48','6000000','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-261108-0001','D','2026-11-08','20:15:48','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-261108-0001','D','2026-11-08','20:15:48','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-261108-0001','D','2026-11-08','20:15:48','DPE','SALDO AWAL','SALDO AWAL','0','228362000','228362000'); 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-261108-0001','D','2026-11-08','20:15:48','MANDIRI','SALDO AWAL','SALDO AWAL','0','111637450','111637450'); 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-261108-0001','D','2026-11-08','20:15:48','KET','SALDO AWAL','SALDO AWAL','0','129119250','129119250'); UPDATE tp_system SET tgl_system='2026-11-08';