INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','08:20:40'); 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-20261023-0001','1','TFA-ZJBB-19-0','1','2.020','2.020','TOKO','TFA.BALIK','TOKO','TFABR'); DELETE FROM tm_barang WHERE kode_barang='TFA-ZJBB-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFA-ZJBB-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFA-ZJBB-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFA-ZJBB-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFABR',tgl_last_beli='2026-10-23 08:21:24' WHERE kode_barang='TFA-ZJBB-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFA-ZJBB-19-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-10-23 08:21:24','TOKO','TFABR','TFA','TFA-ZJBB-19-0','1','2.020','2.020','1','2.020','2.020','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFA' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFA' LIMIT 1; DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFA-ZJBB-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFA-ZJBB-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261014-0002'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0001','2026-10-23','08:21','2.020','kasir','2026-10-23 08:21:24'); 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-20261023-0002','1','TFC-ZJBB-9-0','1','1.100','1.100','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZJBB-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZJBB-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZJBB-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-10-23 08:21:47' WHERE kode_barang='TFC-ZJBB-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZJBB-9-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-10-23 08:21:47','TOKO','TFCBR','TFC','TFC-ZJBB-9-0','1','1.100','1.100','1','1.100','1.100','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1; DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZJBB-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261010-0001'; 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-20261023-0002','1','TFC-ZJBB-16-0','1','2.270','2.270','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZJBB-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZJBB-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZJBB-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-10-23 08:21:47' WHERE kode_barang='TFC-ZJBB-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZJBB-16-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-10-23 08:21:47','TOKO','TFCBR','TFC','TFC-ZJBB-16-0','1','2.270','2.270','1','2.270','2.270','75.00'); DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1; DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZJBB-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261013-0001'; 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-20261023-0002','1','TFC-ZJBB-18-0','1','1.300','1.300','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZJBB-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZJBB-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZJBB-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-10-23 08:21:47' WHERE kode_barang='TFC-ZJBB-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZJBB-18-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-10-23 08:21:47','TOKO','TFCBR','TFC','TFC-ZJBB-18-0','1','1.300','1.300','1','1.300','1.300','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1; DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZJBB-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261014-0001'; 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-20261023-0002','1','TFC-ZJBB-20-0','1','0.470','0.470','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZJBB-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZJBB-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZJBB-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-10-23 08:21:47' WHERE kode_barang='TFC-ZJBB-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZJBB-20-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-10-23 08:21:47','TOKO','TFCBR','TFC','TFC-ZJBB-20-0','1','0.470','0.470','1','0.470','0.470','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1; DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZJBB-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZJBB-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261015-0001'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0002','2026-10-23','08:21','5.140','kasir','2026-10-23 08:21:47'); 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-20261023-0003','1','TFCMP-ZJBB-21-0','1','1.940','1.940','TOKO','CMPTF','TOKO','TFCINMAS'); DELETE FROM tm_barang WHERE kode_barang='TFCMP-ZJBB-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-ZJBB-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFCMP-ZJBB-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-ZJBB-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2026-10-23 08:22:08' WHERE kode_barang='TFCMP-ZJBB-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-ZJBB-21-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-10-23 08:22:08','TOKO','TFCINMAS','TFCMP','TFCMP-ZJBB-21-0','1','1.940','1.940','1','1.940','1.940','76.00'); DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-ZJBB-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-ZJBB-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli='FB-261016-0001'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0003','2026-10-23','08:22','1.940','kasir','2026-10-23 08:22:08'); 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-20261023-0004','1','PSGT-ZJBB-25-0','1','2.180','2.180','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBB-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBB-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBB-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-23 08:22:45' WHERE kode_barang='PSGT-ZJBB-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBB-25-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-10-23 08:22:45','TOKO','MMPSN','PSGT','PSGT-ZJBB-25-0','1','2.180','2.180','1','2.180','2.180','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBB-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0004','1','PSPRT-ZJBB-29-0','1','3.480','3.480','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-23 08:22:45' WHERE kode_barang='PSPRT-ZJBB-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 08:22:45','TOKO','MMPSN','PSPRT','PSPRT-ZJBB-29-0','1','3.480','3.480','1','3.480','3.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0004','1','PSPRT-ZJBB-39-0','1','3.940','3.940','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-23 08:22:45' WHERE kode_barang='PSPRT-ZJBB-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-39-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-10-23 08:22:45','TOKO','MMPSN','PSPRT','PSPRT-ZJBB-39-0','1','3.940','3.940','1','3.940','3.940','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0004','1','PSPRT-ZJBB-40-0','1','3.590','3.590','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-23 08:22:45' WHERE kode_barang='PSPRT-ZJBB-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-40-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-10-23 08:22:45','TOKO','MMPSN','PSPRT','PSPRT-ZJBB-40-0','1','3.590','3.590','1','3.590','3.590','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0004','2026-10-23','08:22','13.190','kasir','2026-10-23 08:22:44'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','08:40:13'); DELETE FROM tm_berlian WHERE kode_barang='TFLMK-ZJBX-57-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 ('TFLMK-ZJBX-57-0','00048390','00048390','THIFA LIONTIN MAS KUNING ','THIFA LIONTIN MAS KUNING','','','1984000','1984000',' 0','0','kasir','2026-10-23 08:42:07'); UPDATE tm_barang SET nama_barang='THIFA LIONTIN MAS KUNING' ,nama_atribut='' ,kode_intern='TFLMK70-77% ', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFLMK-ZJBX-57-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFLMK-ZJBX-56-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 ('TFLMK-ZJBX-56-0','00048389','00048389','THIFA LIONTIN MAS KUNING ','THIFA LIONTIN MAS KUNING','','','2090000','2090000',' 0','0','kasir','2026-10-23 08:42:17'); UPDATE tm_barang SET nama_barang='THIFA LIONTIN MAS KUNING' ,nama_atribut='' ,kode_intern='TFLMK70-77% ', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFLMK-ZJBX-56-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFLMK-ZJBX-55-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 ('TFLMK-ZJBX-55-0','00048388','00048388','THIFA LIONTIN MAS KUNING ','THIFA LIONTIN MAS KUNING','','','1399500','1399500',' 0','0','kasir','2026-10-23 08:42:26'); UPDATE tm_barang SET nama_barang='THIFA LIONTIN MAS KUNING' ,nama_atribut='' ,kode_intern='TFLMK70-77% ', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFLMK-ZJBX-55-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFLMK-ZJBX-54-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 ('TFLMK-ZJBX-54-0','00048387','00048387','THIFA LIONTIN MAS KUNING ','THIFA LIONTIN MAS KUNING','','','1346000','1346000',' 0','0','kasir','2026-10-23 08:42:33'); UPDATE tm_barang SET nama_barang='THIFA LIONTIN MAS KUNING' ,nama_atribut='' ,kode_intern='TFLMK70-77% ', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFLMK-ZJBX-54-0' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','08:48:29'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','09:46:33'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','09:48:09'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-23 ','09:48:59'); 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 ('FJ-261023-0001','kasirbip','1',' DP-03982DU','TOKO','DUPSN','PSPRT-ZJXH-18-0','CINCIN PERAK YL01 ','','3.160','1','100.00','323000','0','0','17800','1050000','0','0','0','1050000','PUT','00048040','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.160',berat_jual_asli=berat_jual_asli+'3.160',stock_jual='1',berat_akhir=berat_akhir-'3.160',berat_akhir_asli=berat_akhir_asli-'3.160',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJXH-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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 ('FJ-261023-0001','2026-10-23','3.160','2026-10-23','09:57:49','PLG0017747','1050000','1050000','0','1050000','0','kasirbip','2026-10-23 09:57:48','FJ-261023-0001','DP-03982','1050000'); 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-23','FJ-261023-0001','2026-10-23','09:57:49','PUT','1050000','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='FJ-261023-0001' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-23 ','10:10:06'); 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 ('FJ-261023-0002','sby','1',' DP-03988SB','TOKO','SBYPSN','PSGT-ZJXB-45-0','CINCIN EMAS ','','3.460','1','45.00','3981000','0','0','17800','6254000','0','0','0','6254000','DIL','00047864','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSGT-ZJXB-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0002','2026-10-23','3.460','2026-10-23','10:13:30','PLG0017748','6254000','6254000','0','6254000','0','sby','2026-10-23 10:13:30','FJ-261023-0002','DP-03988','4400000'); 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-23','FJ-261023-0002','2026-10-23','10:13:30','DIL','6254000','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-261023-0001','2026-10-23','2026-10-23 10:13:30','PENJUALAN : FJ-261023-0002','','TBC','1854000','1854000','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-261023-0002','D','2026-10-23','10:13:30','TBC','PENJUALAN','FJ-261023-0002','29768123464','1854000','29769977464','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='1854000' WHERE no_faktur_jual='FJ-261023-0002' 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 ('FJ-261023-0003','kasirbip','1',' DP-04212DU','TOKO','DUPSN','PSPRT-ZJBX-90-0','CINCIN PERAK SR02 YL01 ','','3.710','1','100.00','379000','0','0','17800','1050000','0','0','0','1050000','MIL','00048423','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-90-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.710',berat_jual_asli=berat_jual_asli+'3.710',stock_jual='1',berat_akhir=berat_akhir-'3.710',berat_akhir_asli=berat_akhir_asli-'3.710',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBX-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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 ('FJ-261023-0003','2026-10-23','3.710','2026-10-23','10:22:10','PLG0017749','1050000','1050000','0','1050000','0','kasirbip','2026-10-23 10:22:09','FJ-261023-0003','DP-04212','1050000'); 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-23','FJ-261023-0003','2026-10-23','10:22:10','MIL','1050000','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='FJ-261023-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-23 ','11:17:28'); 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 ('FJ-261023-0004','jogja','1',' DP-04210JO','TOKO','JOGPSN','PSGT-ZJAF-26-0','CINCIN EMAS ','','2.230','1','57.00','2983000','0','0','17800','4014000','0','700000','0','4714000','ADL','00048223','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSGT-ZJAF-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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 ('FJ-261023-0004','2026-10-23','2.230','2026-10-23','11:21:11','PLG0017750','4014000','4014000','700000','4714000','0','jogja','2026-10-23 11:21:11','FJ-261023-0004','DP-04210','2600000'); 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-23','FJ-261023-0004','2026-10-23','11:21:11','ADL','4714000','700000'); 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-261023-0002','2026-10-23','2026-10-23 11:21:11','PENJUALAN : FJ-261023-0004','','TBC','2114000','2114000','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-261023-0003','D','2026-10-23','11:21:11','TBC','PENJUALAN','FJ-261023-0004','29769977464','2114000','29772091464','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='2114000' WHERE no_faktur_jual='FJ-261023-0004' 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 ('FJ-261023-0005','jogja',' 1',' DP-04211JO','TOKO','JOGPSN','PSPLT-ZJAF-25-0','CINCIN PALADIUM ','','2.530','1','17.00','569000','0','0','17800','885500','0','700000','0','1585500','ADL','00048222','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPLT-ZJAF-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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 ('FJ-261023-0005','2026-10-23','2.530','2026-10-23','11:21:11','PLG0017751','885500','885500','700000','1585500','0','jogja','2026-10-23 11:21:11','FJ-261023-0004','DP-04211','787500'); 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-23','FJ-261023-0005','2026-10-23','11:21:11','ADL','1585500','700000'); 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-261023-0003','2026-10-23','2026-10-23 11:21:11','PENJUALAN : FJ-261023-0005','','TBC','798000','798000','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-261023-0004','D','2026-10-23','11:21:11','TBC','PENJUALAN','FJ-261023-0005','29772091464','798000','29772889464','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='2912000' WHERE no_faktur_jual='FJ-261023-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,keterangan) VALUES ('FJ-261023-0006','sby','1',' DP-04329SB','TOKO','SBYPSN','PSPRT-ZJBA-39-0','CINCIN PERAK YL01 ','','2.900','1','100.00','296000','0','0','17800','700000','0','0','0','700000','VAN','00048469','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBA-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBA-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0006','2026-10-23','2.900','2026-10-23','11:26:19','PLG0017752','700000','700000','0','700000','0','sby','2026-10-23 11:26:19','FJ-261023-0006','DP-04329','700000'); 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-23','FJ-261023-0006','2026-10-23','11:26:19','VAN','700000','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='FJ-261023-0006' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-23 ','12:40:32'); 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 ('FJ-261023-0007','kasirbip','1',' DP-04486BI','TOKO','BIPPSN','PSPRT-ZJAI-30-0','CINCIN PERAK ','','3.190','1','100.00','326000','0','0','17800','850000','0','0','0','850000','SULIS','00048274','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAI-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJAI-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-261023-0007','2026-10-23','3.190','2026-10-23','12:41:24','PLG0017753','850000','850000','0','850000','0','kasirbip','2026-10-23 12:41:24','FJ-261023-0007','DP-04486','850000'); 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-23','FJ-261023-0007','2026-10-23','12:41:24','SULIS','850000','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='FJ-261023-0007' 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 ('FJ-261023-0008','kasirbip',' 1',' DP-04596BI','TOKO','BIPPSN','PSPRT-ZJBX-77-0','CINCIN PERAK ','','2.520','1','100.00','258000','0','0','17800','950000','0','0','0','950000','SULIS','00048410','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-77-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBX-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-261023-0008','2026-10-23','2.520','2026-10-23','12:41:24','PLG0017754','950000','950000','0','950000','0','kasirbip','2026-10-23 12:41:24','FJ-261023-0007','DP-04596','950000'); 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-23','FJ-261023-0008','2026-10-23','12:41:24','SULIS','950000','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='FJ-261023-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0008'; 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-20261023-0005','1','PSPRT-ZJBA-27-0','1','4.190','4.190','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-23 13:45:38' WHERE kode_barang='PSPRT-ZJBA-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-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-10-23 13:45:38','TOKO','JOGPSN','PSPRT','PSPRT-ZJBA-27-0','1','4.190','','1','4.190','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0005','1','PSPLT-ZJBA-43-0','1','2.100','2.100','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBA-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBA-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBA-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-23 13:45:38' WHERE kode_barang='PSPLT-ZJBA-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBA-43-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-10-23 13:45:38','TOKO','JOGPSN','PSPLT','PSPLT-ZJBA-43-0','1','2.100','','1','2.100','','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBA-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0005','1','PSPLT-ZJBA-41-0','1','2.410','2.410','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBA-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBA-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBA-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-23 13:45:38' WHERE kode_barang='PSPLT-ZJBA-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBA-41-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-10-23 13:45:38','TOKO','JOGPSN','PSPLT','PSPLT-ZJBA-41-0','1','2.410','','1','2.410','','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBA-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0005','1','PSPRT-ZJBA-42-0','1','1.640','1.640','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-42-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-42-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-42-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-23 13:45:38' WHERE kode_barang='PSPRT-ZJBA-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-42-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-10-23 13:45:38','TOKO','JOGPSN','PSPRT','PSPRT-ZJBA-42-0','1','1.640','','1','1.640','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-42-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0005','1','PSPRT-ZJBA-38-0','1','4.450','4.450','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-23 13:45:38' WHERE kode_barang='PSPRT-ZJBA-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-38-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-10-23 13:45:38','TOKO','JOGPSN','PSPRT','PSPRT-ZJBA-38-0','1','4.450','','1','4.450','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0005','2026-10-23','13:41','14.790','jogja','2026-10-23 13:45:38'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-23 ','13:47:29'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-23 ','13:47:30'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-23 ','13:53:13'); 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-20261023-0006','1','PJOG-ZJBA-22-0','1','5.240','5.240','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJBA-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJBA-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJBA-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-10-23 13:56:36' WHERE kode_barang='PJOG-ZJBA-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJBA-22-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-10-23 13:56:36','TOKO','JOGPER','PJOG','PJOG-ZJBA-22-0','1','5.240','','1','5.240','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZJBA-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0006','1','PJOG-ZJBA-21-0','1','3.770','3.770','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJBA-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJBA-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJBA-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-10-23 13:56:36' WHERE kode_barang='PJOG-ZJBA-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJBA-21-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-10-23 13:56:36','TOKO','JOGPER','PJOG','PJOG-ZJBA-21-0','1','3.770','','1','3.770','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZJBA-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0006','1','PJOG-ZJBA-20-0','1','3.390','3.390','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJBA-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJBA-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJBA-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-10-23 13:56:36' WHERE kode_barang='PJOG-ZJBA-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJBA-20-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-10-23 13:56:36','TOKO','JOGPER','PJOG','PJOG-ZJBA-20-0','1','3.390','','1','3.390','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZJBA-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJBA-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0006','2026-10-23','13:53','12.400','jogja','2026-10-23 13:56:36'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-23 ','14:09:08'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-23 ','14:39:08'); 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-04729','ADL','1','PER','WEDDRING','','','1.500','','925.00','1','100000','0','800000','0','800000','sz cwe 9 5','gf Berksbire : R...F 21.11.26','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0004','2026-10-23','2026-10-23 14:42:41','PESANAN : DP-04729','-','TBC','800000','800000'); 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-261023-0005','D','2026-10-23','14:42:41','TBC','PESANAN','DP-04729','29772889464','800000','29773689464','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-04729','2026-10-23','2026-10-23','14:42:41','PLG0017755','ADL','2026-11-14','jogja','2026-10-23 14:42:41','1.500','0','0','0','800000','0','0','800000','800000','0'); 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-04730','ADL','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz cwo 17','gf Berksbire : R...F 21.11.26','di hilangkan bintik bintiknya','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0005','2026-10-23','2026-10-23 14:46:54','PESANAN : DP-04730','-','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-261023-0006','D','2026-10-23','14:46:54','TBC','PESANAN','DP-04730','29773689464','900000','29774589464','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-04730','2026-10-23','2026-10-23','14:46:54','PLG0017756','ADL','2026-11-14','jogja','2026-10-23 14:46:54','2.000','0','0','0','900000','0','0','900000','900000','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 ('FJ-261023-0009','kasirbip','1',' 750K-95-29','TOKO','BIPPER','PBDG-ZIBC-5-0','CINCIN SILVER 925 ','','1.490','1','100.00','152000','0','0','17800','850000','0','0','0','850000','SAL','00047484','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBC-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PBDG-ZIBC-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-261023-0009','2026-10-23','1.490','2026-10-23','14:54:56','PLG0017757','850000','850000','0','850000','0','kasirbip','2026-10-23 14:54:56','FJ-261023-0009','','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-10-23','FJ-261023-0009','2026-10-23','14:54:56','SAL','850000','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-261023-0006','2026-10-23','2026-10-23 14:54:56','PENJUALAN : FJ-261023-0009','.','TBC','850000','850000','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-261023-0007','D','2026-10-23','14:54:56','TBC','PENJUALAN','FJ-261023-0009','29774589464','850000','29775439464','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='850000' WHERE no_faktur_jual='FJ-261023-0009' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-23 ','15:30:37'); 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 ('FJ-261023-0010','kasirbip','1',' 750K-12-27','TOKO','BIPPER','PBDG-ZGAE-20-0','CINCIN SILVER 925 ','','1.730','1','100.00','177000','0','0','17800','850000','0','0','0','850000','SULIS','00045208','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAE-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PBDG-ZGAE-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-261023-0010','2026-10-23','1.730','2026-10-23','16:11:49','PLG0017758','850000','850000','0','850000','0','kasirbip','2026-10-23 16:11:48','FJ-261023-0010','','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-10-23','FJ-261023-0010','2026-10-23','16:11:49','SULIS','850000','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-261023-0007','2026-10-23','2026-10-23 16:11:48','PENJUALAN : FJ-261023-0010','.','TBC','850000','850000','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-261023-0008','D','2026-10-23','16:11:49','TBC','PENJUALAN','FJ-261023-0010','29775439464','850000','29776289464','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='850000' WHERE no_faktur_jual='FJ-261023-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0010'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-23 ','16:15:29'); 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-04731','ADL','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','sz cwe 13','gf Berksbire : Andre 16.11.2026 ...','express 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0008','2026-10-23','2026-10-23 16:24:42','PESANAN : DP-04731','-','TBC','1380000','1380000'); 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-261023-0009','D','2026-10-23','16:24:42','TBC','PESANAN','DP-04731','29776289464','1380000','29777669464','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-04731','2026-10-23','2026-10-23','16:24:42','PLG0017759','ADL','2026-11-06','jogja','2026-10-23 16:24:42','2.500','0','0','0','1380000','0','850000','1725000','1725000','345000'); 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-20261023-0007','1','PSPRT-ZJBB-26-0','1','4.260','4.260','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-26-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-26-0','1','4.260','4.260','1','4.260','4.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-27-0','1','3.230','3.230','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-27-0','1','3.230','3.230','1','3.230','3.230','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-28-0','1','2.050','2.050','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-28-0','1','2.050','2.050','1','2.050','2.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-30-0','1','2.790','2.790','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-30-0','1','2.790','2.790','1','2.790','2.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-31-0','1','3.350','3.350','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-31-0','1','3.350','3.350','1','3.350','3.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-32-0','1','1.920','1.920','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-32-0','1','1.920','1.920','1','1.920','1.920','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-33-0','1','2.470','2.470','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-33-0','1','2.470','2.470','1','2.470','2.470','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-34-0','1','3.850','3.850','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-34-0','1','3.850','3.850','1','3.850','3.850','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPLT-ZJBB-35-0','1','4.040','4.040','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBB-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBB-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBB-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPLT-ZJBB-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPLT','PSPLT-ZJBB-35-0','1','4.040','4.040','1','4.040','4.040','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBB-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSGT-ZJBB-36-0','1','1.610','1.610','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBB-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBB-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBB-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSGT-ZJBB-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSGT','PSGT-ZJBB-36-0','1','1.610','1.610','1','1.610','1.610','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBB-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPLT-ZJBB-37-0','1','2.560','2.560','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBB-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBB-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBB-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPLT-ZJBB-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBB-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-10-23 16:26:30','TOKO','DUPSN','PSPLT','PSPLT-ZJBB-37-0','1','2.560','2.560','1','2.560','2.560','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBB-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSGT-ZJBB-38-0','1','3.120','3.120','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBB-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBB-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBB-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSGT-ZJBB-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBB-38-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-10-23 16:26:30','TOKO','DUPSN','PSGT','PSGT-ZJBB-38-0','1','3.120','3.120','1','3.120','3.120','83.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBB-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBB-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-41-0','1','2.510','2.510','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-41-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-41-0','1','2.510','2.510','1','2.510','2.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-42-0','1','2.680','2.680','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-42-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-42-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-42-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-42-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-42-0','1','2.680','2.680','1','2.680','2.680','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-42-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0007','1','PSPRT-ZJBB-43-0','1','3.450','3.450','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-23 16:26:30' WHERE kode_barang='PSPRT-ZJBB-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-43-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-10-23 16:26:30','TOKO','DUPSN','PSPRT','PSPRT-ZJBB-43-0','1','3.450','3.450','1','3.450','3.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0007','2026-10-23','16:25','43.890','kasirbip','2026-10-23 16:26:29'); INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-04731'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-04731'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-04731'; 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-261023-0002','K','2026-10-23','16:30:22','jogja','PESANAN BATAL','DP-04731','294600','0','294600'); 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-04732','ADL','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','sz cwe 13 zircon 30','gf Berksbire : Andre 16.11.2026 ...','express 100.000','300000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0009','2026-10-23','2026-10-23 16:34:43','PESANAN : DP-04732','-','TBC','1620000','1620000'); 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-261023-0010','D','2026-10-23','16:34:43','TBC','PESANAN','DP-04732','29777669464','1620000','29779289464','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-04732','2026-10-23','2026-10-23','16:34:43','PLG0017760','ADL','2026-11-06','jogja','2026-10-23 16:34:43','2.500','0','0','0','1620000','0','850000','2025000','2025000','405000'); 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-04733','ADL','1','PLD','WEDDING RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz cwo 19','gf Berksbire : Nana 16.11.2026 ...','express 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0010','2026-10-23','2026-10-23 16:39:15','PESANAN : DP-04733','-','TBC','1580000','1580000'); 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-261023-0011','D','2026-10-23','16:39:15','TBC','PESANAN','DP-04733','29779289464','1580000','29780869464','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-04733','2026-10-23','2026-10-23','16:39:15','PLG0017761','ADL','2026-11-06','jogja','2026-10-23 16:39:15','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000'); 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 ('FJ-261023-0011','sby','1',' DP-04281SB','TOKO','SBYPSN','PSPRT-ZJBX-91-0','CINCIN PERAK ','','3.380','1','100.00','345000','0','0','17800','800000','0','0','0','800000','ARA','00048424','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-91-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBX-91-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0011','2026-10-23','3.380','2026-10-23','16:43:45','PLG0017762','800000','800000','0','800000','0','sby','2026-10-23 16:43:45','FJ-261023-0011','DP-04281','800000'); 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-23','FJ-261023-0011','2026-10-23','16:43:45','ARA','800000','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='FJ-261023-0011' 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 ('FJ-261023-0012','sby','1',' DP-04282SB','TOKO','SBYPSN','PSPRT-ZJBX-97-0','CINCIN PERAK ','','2.370','1','100.00','242000','0','0','17800','850000','0','0','0','850000','ARA','00048430','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-97-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBX-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0012','2026-10-23','2.370','2026-10-23','16:45:21','PLG0017763','850000','850000','0','850000','0','sby','2026-10-23 16:45:21','FJ-261023-0012','DP-04282','850000'); 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-23','FJ-261023-0012','2026-10-23','16:45:21','ARA','850000','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='FJ-261023-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0012'; 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-20261023-0008','1','PSPLT-ZJBB-44-0','1','4.600','4.600','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBB-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-44-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBB-44-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBB-44-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-23 17:02:07' WHERE kode_barang='PSPLT-ZJBB-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBB-44-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-10-23 17:02:07','TOKO','BIPPSN','PSPLT','PSPLT-ZJBB-44-0','1','4.600','4.600','1','4.600','4.600','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBB-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBB-44-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0008','1','PSPRT-ZJBB-45-0','1','1.540','1.540','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-23 17:02:07' WHERE kode_barang='PSPRT-ZJBB-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-45-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-10-23 17:02:07','TOKO','BIPPSN','PSPRT','PSPRT-ZJBB-45-0','1','1.540','1.540','1','1.540','1.540','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0008','1','PSPRT-ZJBB-46-0','1','2.000','2.000','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-23 17:02:07' WHERE kode_barang='PSPRT-ZJBB-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-46-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-10-23 17:02:07','TOKO','BIPPSN','PSPRT','PSPRT-ZJBB-46-0','1','2.000','2.000','1','2.000','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' 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-20261023-0008','1','PSPRT-ZJBB-47-0','1','3.480','3.480','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBB-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-47-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBB-47-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBB-47-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-23 17:02:07' WHERE kode_barang='PSPRT-ZJBB-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBB-47-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-10-23 17:02:07','TOKO','BIPPSN','PSPRT','PSPRT-ZJBB-47-0','1','3.480','3.480','1','3.480','3.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBB-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBB-47-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-23' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261023-0008','2026-10-23','17:01','11.620','kasirbip','2026-10-23 17:02:06'); 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 ('FJ-261023-0013','kasirbip','1',' DP-04270DU','TOKO','DUPSN','PSPRT-ZJAI-80-0','CINCIN PERAK CM01 ','','3.860','1','100.00','394000','0','0','17800','1200000','0','0','0','1200000','PUT','00048324','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAI-80-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.860',berat_jual_asli=berat_jual_asli+'3.860',stock_jual='1',berat_akhir=berat_akhir-'3.860',berat_akhir_asli=berat_akhir_asli-'3.860',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJAI-80-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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 ('FJ-261023-0013','2026-10-23','3.860','2026-10-23','17:21:20','PLG0017764','1200000','1200000','0','1200000','0','kasirbip','2026-10-23 17:21:19','FJ-261023-0013','DP-04270','1200000'); 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-23','FJ-261023-0013','2026-10-23','17:21:20','PUT','1200000','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='FJ-261023-0013' LIMIT 1; 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-04734','ARA','1','PER','SEPAKET SR950 03','','','3.000','','92.50','1','100000','0','950000','0','950000','Size wanita 17 GRF : Siska ?? Hery','Size Pria 24 GRf : Hery ?? Siska','Font : Vladinir Finishing : putih glosy','100000','100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0011','2026-10-23','2026-10-23 18:30:05','PESANAN : DP-04734','-','TBC','1150000','1150000'); 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-261023-0012','D','2026-10-23','18:30:05','TBC','PESANAN','DP-04734','29780869464','1150000','29782019464','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-04734','2026-10-23','2026-10-23','18:30:05','PLG0017765','ARA','2026-11-17','sby','2026-10-23 18:30:05','3.000','0','0','0','1150000','0','0','1150000','1150000','0'); 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-04735','ARA','1','PER','SEPAKET SR950 03','','','3.000','','92.50','1','100000','0','950000','0','950000','Size wanita 17 GRF : Siska ?? Hery','Size Pria 24 GRf : Hery ?? Siska','Font : Vladinir Finishing : putih glosy','100000','100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0012','2026-10-23','2026-10-23 18:30:28','PESANAN : DP-04735','-','TBC','1150000','1150000'); 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-261023-0013','D','2026-10-23','18:30:28','TBC','PESANAN','DP-04735','29782019464','1150000','29783169464','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-04735','2026-10-23','2026-10-23','18:30:28','PLG0017766','ARA','2026-11-17','sby','2026-10-23 18:30:28','3.000','0','0','0','1150000','0','0','1150000','1150000','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 ('FJ-261023-0014','sby','1',' DP-04259SB','TOKO','SBYPSN','PSPLT-ZJAF-41-0','CINCIN PALADIUM ','','3.400','1','32.00','1437000','0','0','17800','2670000','0','0','0','2670000','DIL','00048238','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPLT-ZJAF-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0014','2026-10-23','3.400','2026-10-23','18:38:45','PLG0017767','2670000','2670000','0','2670000','0','sby','2026-10-23 18:38:45','FJ-261023-0014','DP-04259','2000000'); 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-23','FJ-261023-0014','2026-10-23','18:38:45','DIL','2670000','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-261023-0013','2026-10-23','2026-10-23 18:38:45','PENJUALAN : FJ-261023-0014','','TBC','670000','670000','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-261023-0014','D','2026-10-23','18:38:45','TBC','PENJUALAN','FJ-261023-0014','29783169464','670000','29783839464','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='670000' WHERE no_faktur_jual='FJ-261023-0014' 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 ('FJ-261023-0015','sby',' 1',' DP-04260SB','TOKO','SBYPSN','PSPLT-ZJAI-87-0','CINCIN PALADIUM ','','2.870','1','32.00','1213000','0','0','17800','2449000','0','0','0','2449000','DIL','00048331','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAI-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPLT-ZJAI-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0015','2026-10-23','2.870','2026-10-23','18:38:45','PLG0017768','2449000','2449000','0','2449000','0','sby','2026-10-23 18:38:45','FJ-261023-0014','DP-04260','2000000'); 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-23','FJ-261023-0015','2026-10-23','18:38:45','DIL','2449000','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-261023-0014','2026-10-23','2026-10-23 18:38:45','PENJUALAN : FJ-261023-0015','','TBC','449000','449000','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-261023-0015','D','2026-10-23','18:38:45','TBC','PENJUALAN','FJ-261023-0015','29783839464','449000','29784288464','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='1119000' WHERE no_faktur_jual='FJ-261023-0015' LIMIT 1; 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-04736','DEW','1','GOLD','WEDRING','','','1.500','','375.00','1','2300000','1400000','0','800000','2900000','sz cwe 13','ukir nama fn vintage : C...P','Gold','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261023-0015','2026-10-23','2026-10-23 18:47:24','PESANAN : DP-04736','-','TBC','2320000','2320000'); 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-261023-0016','D','2026-10-23','18:47:24','TBC','PESANAN','DP-04736','29784288464','2320000','29786608464','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-04736','2026-10-23','2026-10-23','18:47:24','PLG0017769','DEW','2026-11-14','jogja','2026-10-23 18:47:24','1.500','0','0','0','2320000','0','800000','2900000','2900000','580000'); 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 ('FJ-261023-0016','sby','1',' DP-04311SB','TOKO','SBYPSN','PSPRT-ZJBA-40-0','CINCIN PERAK ','','3.860','1','100.00','394000','0','0','17800','850000','0','0','0','850000','ARA','00048470','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBA-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.860',berat_jual_asli=berat_jual_asli+'3.860',stock_jual='1',berat_akhir=berat_akhir-'3.860',berat_akhir_asli=berat_akhir_asli-'3.860',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='PSPRT-ZJBA-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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 ('FJ-261023-0016','2026-10-23','3.860','2026-10-23','19:15:02','PLG0017770','850000','850000','0','850000','0','sby','2026-10-23 19:15:01','FJ-261023-0016','DP-04311','850000'); 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-23','FJ-261023-0016','2026-10-23','19:15:02','ARA','850000','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='FJ-261023-0016' 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 ('FJ-261023-0017','kasirbip','1',' 750K-165-0','TOKO','DUPERBDG','LXPER-ZEAB-22-0','CINCIN SILVER 925 ','','2.100','1','100.00','215000','0','0','17800','800000','0','0','0','800000','KUR','00043489','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='LXPER-ZEAB-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-261023-0017','2026-10-23','2.100','2026-10-23','19:21:55','PLG0017771','800000','800000','0','800000','0','kasirbip','2026-10-23 19:21:55','FJ-261023-0017','','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-10-23','FJ-261023-0017','2026-10-23','19:21:55','KUR','800000','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-261023-0016','2026-10-23','2026-10-23 19:21:55','PENJUALAN : FJ-261023-0017','.','TBC','800000','800000','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-261023-0017','D','2026-10-23','19:21:55','TBC','PENJUALAN','FJ-261023-0017','29786608464','800000','29787408464','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='800000' WHERE no_faktur_jual='FJ-261023-0017' 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 ('FJ-261023-0018','kasirbip',' 1',' 900K-85-00','TOKO','DUPERBDG','LXPER-ZGCX-40-0','CINCIN SILVER 925 ','','1.920','1','100.00','196000','0','0','17800','950000','0','0','0','950000','KUR','00045768','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGCX-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-10-23' AND kode_barang='LXPER-ZGCX-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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 ('FJ-261023-0018','2026-10-23','1.920','2026-10-23','19:21:55','PLG0017772','950000','950000','0','950000','0','kasirbip','2026-10-23 19:21:55','FJ-261023-0017','','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-10-23','FJ-261023-0018','2026-10-23','19:21:55','KUR','950000','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-261023-0017','2026-10-23','2026-10-23 19:21:55','PENJUALAN : FJ-261023-0018','.','TBC','950000','950000','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-261023-0018','D','2026-10-23','19:21:55','TBC','PENJUALAN','FJ-261023-0018','29787408464','950000','29788358464','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='1750000' WHERE no_faktur_jual='FJ-261023-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi=''; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261023-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261023-0018'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-23 ','19:45:10'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-24','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-23'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-23'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-23'; 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-23' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-23'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-23'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-23'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-23'; 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-24' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-23' 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-261024-0001','D','2026-10-24','21:10:43','TBC','SALDO AWAL','SALDO AWAL','0','29788358464','29788358464'); 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-261024-0001','D','2026-10-24','21:10:43','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261024-0001','D','2026-10-24','21:10:43','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-261024-0001','D','2026-10-24','21:10:43','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-261024-0001','D','2026-10-24','21:10:43','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-261024-0001','D','2026-10-24','21:10:43','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-261024-0001','D','2026-10-24','21:10:43','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-261024-0001','D','2026-10-24','21:10:43','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-261024-0001','D','2026-10-24','21:10:43','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261024-0001','D','2026-10-24','21:10:43','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261024-0001','D','2026-10-24','21:10:43','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); 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-261024-0001','D','2026-10-24','21:10:43','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); UPDATE tp_system SET tgl_system='2026-10-24';