INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-03 ','08:27:38'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261103-0001','1','TFC-ZKXB-7-0','1','2.410','2.410','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZKXB-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZKXB-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZKXB-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-11-03 08:27:55' WHERE kode_barang='TFC-ZKXB-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZKXB-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 08:27:55','TOKO','TFCBR','TFC','TFC-ZKXB-7-0','1','2.410','2.410','1','2.410','2.410','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-ZKXB-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli='FB-261018-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-20261103-0001','1','TFC-ZKXB-8-0','1','9.480','9.480','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZKXB-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZKXB-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZKXB-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-11-03 08:27:55' WHERE kode_barang='TFC-ZKXB-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZKXB-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 08:27:55','TOKO','TFCBR','TFC','TFC-ZKXB-8-0','1','9.480','9.480','1','9.480','9.480','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-ZKXB-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli='FB-261018-0002'; 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-20261103-0001','1','TFC-ZKXB-12-0','1','4.000','4.000','TOKO','TFC.BALIK','TOKO','TFCBR'); DELETE FROM tm_barang WHERE kode_barang='TFC-ZKXB-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFC-ZKXB-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZKXB-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-11-03 08:27:55' WHERE kode_barang='TFC-ZKXB-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZKXB-12-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 08:27:55','TOKO','TFCBR','TFC','TFC-ZKXB-12-0','1','4.000','4.000','1','4.000','4.000','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-ZKXB-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZKXB-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli='FB-261021-0001'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0001','2026-11-03','08:27','15.890','kasir','2026-11-03 08:27:55'); 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-20261103-0002','1','TFCMP-ZKXB-22-0','1','0.900','0.900','TOKO','CMPTF','TOKO','TFCINMAS'); DELETE FROM tm_barang WHERE kode_barang='TFCMP-ZKXB-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-ZKXB-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFCMP-ZKXB-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-ZKXB-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2026-11-03 08:28:18' WHERE kode_barang='TFCMP-ZKXB-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-ZKXB-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-11-03 08:28:18','TOKO','TFCINMAS','TFCMP','TFCMP-ZKXB-22-0','1','0.900','0.900','1','0.900','0.900','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-ZKXB-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-ZKXB-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli='FB-261026-0002'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0002','2026-11-03','08:28','0.900','kasir','2026-11-03 08:28:17'); 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-20261103-0003','1','TFGRP-ZKXB-21-0','1','2.880','2.880','TOKO','GLRTF','TOKO','TFGLR'); DELETE FROM tm_barang WHERE kode_barang='TFGRP-ZKXB-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRP-ZKXB-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGRP-ZKXB-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRP-ZKXB-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2026-11-03 08:28:38' WHERE kode_barang='TFGRP-ZKXB-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRP-ZKXB-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-11-03 08:28:38','TOKO','TFGLR','TFGRP','TFGRP-ZKXB-21-0','1','2.880','2.880','1','2.880','2.880','76.00'); DELETE FROM tm_dept WHERE kode_dept='TFGRP' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRP' 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='TFGRP-ZKXB-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGRP-ZKXB-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli='FB-261026-0001'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0003','2026-11-03','08:28','2.880','kasir','2026-11-03 08:28:37'); 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-20261103-0004','1','PSPRT-ZKXB-45-0','1','4.630','4.630','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-03 08:29:00' WHERE kode_barang='PSPRT-ZKXB-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXB-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-11-03 08:29:00','TOKO','MMPSN','PSPRT','PSPRT-ZKXB-45-0','1','4.630','4.630','1','4.630','4.630','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-ZKXB-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0004','2026-11-03','08:28','4.630','kasir','2026-11-03 08:29:00'); 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-20261103-0005','1','CMMM-ZKXB-48-0','1','1.230','1.230','TOKO','MMCM','TOKO','MMCM'); DELETE FROM tm_barang WHERE kode_barang='CMMM-ZKXB-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMMM-ZKXB-48-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CMMM-ZKXB-48-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMMM-ZKXB-48-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMCM',tgl_last_beli='2026-11-03 08:29:20' WHERE kode_barang='CMMM-ZKXB-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CMMM-ZKXB-48-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 08:29:20','TOKO','MMCM','CMMM','CMMM-ZKXB-48-0','1','1.230','1.230','1','1.230','1.230','45.00'); DELETE FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMMM' 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='CMMM-ZKXB-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZKXB-48-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0005','1','CMMM-ZKXB-49-0','1','1.470','1.470','TOKO','MMCM','TOKO','MMCM'); DELETE FROM tm_barang WHERE kode_barang='CMMM-ZKXB-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CMMM-ZKXB-49-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CMMM-ZKXB-49-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CMMM-ZKXB-49-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMCM',tgl_last_beli='2026-11-03 08:29:20' WHERE kode_barang='CMMM-ZKXB-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CMMM-ZKXB-49-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 08:29:20','TOKO','MMCM','CMMM','CMMM-ZKXB-49-0','1','1.470','1.470','1','1.470','1.470','45.00'); DELETE FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CMMM' 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='CMMM-ZKXB-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZKXB-49-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0005','2026-11-03','08:29','2.700','kasir','2026-11-03 08:29:20'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-03 ','08:41:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-03 ','08:49:25'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-03 ','09:21:14'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-03 ','10:21:35'); 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-04992','KUR','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz cwe 15.5 crom putih glosy','grf Ewaldo .... Febby font Berkshire','','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-261103-0001','2026-11-03','2026-11-03 10:31:12','PESANAN : DP-04992','.','TBC','950000','950000'); 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-261103-0002','D','2026-11-03','10:31:12','TBC','PESANAN','DP-04992','30386668964','950000','30387618964','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-04992','2026-11-03','2026-11-03','10:31:12','PLG0018377','KUR','2026-11-22','kasirbip','2026-11-03 10:31:12','2.000','0','0','0','950000','0','0','950000','950000','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-04993','KUR','1','PER','WEDDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 21.5 crom putih doff semprot','grf Febby ... Ewaldo font Berkshire','','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-261103-0002','2026-11-03','2026-11-03 10:33:43','PESANAN : DP-04993','.','TBC','950000','950000'); 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-261103-0003','D','2026-11-03','10:33:43','TBC','PESANAN','DP-04993','30387618964','950000','30388568964','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-04993','2026-11-03','2026-11-03','10:33:43','PLG0018378','KUR','2026-11-24','kasirbip','2026-11-03 10:33:43','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-03 ','11:17:38'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-03 ','11:23:41'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-03 ','11:25:30'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04994','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwe sz 10 SR-01 grf Zeni Vickry','cwo sz 19.5 YL-01 Grf Ade Siti','font vladimir','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261103-0003','2026-11-03','2026-11-03 11:26:47','PESANAN : DP-04994','.','TBC','950000','950000'); 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-261103-0004','D','2026-11-03','11:26:47','TBC','PESANAN','DP-04994','30388568964','950000','30389518964','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-04994','2026-11-03','2026-11-03','11:26:47','PLG0018379','SAL','2026-11-18','kasirbip','2026-11-03 11:26:47','2.000','0','0','0','950000','0','0','950000','950000','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-261103-0001','jogja','1',' DP-04574JO','TOKO','JOGPSN','PSPLT-ZKXB-1-0','CINCIN PALADIUM ','','4.140','1','32.00','1749000','0','0','17800','2277000','0','1500000','0','3777000','ADL','00048819','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.140',berat_jual_asli=berat_jual_asli+'4.140',stock_jual='1',berat_akhir=berat_akhir-'4.140',berat_akhir_asli=berat_akhir_asli-'4.140',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZKXB-1-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-261103-0001','2026-11-03','4.140','2026-11-03','11:31:44','PLG0018380','2277000','2277000','1500000','3777000','0','jogja','2026-11-03 11:31:44','FJ-261103-0001','DP-04574','2960000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0001','2026-11-03','11:31:44','ADL','3777000','1500000'); 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-261103-0004','2026-11-03','2026-11-03 11:31:44','PENJUALAN : FJ-261103-0001','','TBC','817000','817000','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-261103-0005','D','2026-11-03','11:31:44','TBC','PENJUALAN','FJ-261103-0001','30389518964','817000','30390335964','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='817000' WHERE no_faktur_jual='FJ-261103-0001' 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-261103-0002','jogja',' 1',' DP-04573JO','TOKO','JOGPSN','PSPLT-ZJBH-25-0','CINCIN PALADIUM ','','2.710','1','32.00','1146000','0','0','17800','1520500','30000','800000','0','2320500','ADL','00048726','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBH-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJBH-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-261103-0002','2026-11-03','2.710','2026-11-03','11:31:44','PLG0018381','1520500','1520500','800000','2320500','0','jogja','2026-11-03 11:31:44','FJ-261103-0001','DP-04573','2040000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0002','2026-11-03','11:31:44','ADL','2320500','800000'); 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-261103-0005','2026-11-03','2026-11-03 11:31:44','PENJUALAN : FJ-261103-0002','','TBC','280500','280500','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-261103-0006','D','2026-11-03','11:31:44','TBC','PENJUALAN','FJ-261103-0002','30390335964','280500','30390616464','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='1097500' WHERE no_faktur_jual='FJ-261103-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0002'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261103-0003','kasirbip','1',' DP-04562DU','TOKO','DUPSN','PSPLT-ZJBI-34-0','CINCIN PALADIUM ','','2.740','1','17.00','615000','0','0','17800','1659000','0','0','0','1659000','PUT','00048760','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBI-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.740',berat_jual_asli=berat_jual_asli+'2.740',stock_jual='1',berat_akhir=berat_akhir-'2.740',berat_akhir_asli=berat_akhir_asli-'2.740',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJBI-34-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-261103-0003','2026-11-03','2.740','2026-11-03','11:35:32','PLG0018382','1659000','1659000','0','1659000','0','kasirbip','2026-11-03 11:35:31','FJ-261103-0003','DP-04562','1540000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0003','2026-11-03','11:35:32','PUT','1659000','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-261103-0006','2026-11-03','2026-11-03 11:35:31','PENJUALAN : FJ-261103-0003','.','TBC','119000','119000','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-261103-0007','D','2026-11-03','11:35:32','TBC','PENJUALAN','FJ-261103-0003','30390616464','119000','30390735464','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='119000' WHERE no_faktur_jual='FJ-261103-0003' LIMIT 1; 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-20261103-0006','1','PSPRT-ZKXB-35-0','1','3.180','3.180','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXB-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:25:42','TOKO','DUPSN','PSPRT','PSPRT-ZKXB-35-0','1','3.180','3.180','1','3.180','3.180','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-ZKXB-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSGT-ZKXB-36-0','1','2.050','2.050','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKXB-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXB-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKXB-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:25:42','TOKO','DUPSN','PSGT','PSGT-ZKXB-36-0','1','2.050','2.050','1','2.050','2.050','57.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-ZKXB-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXB-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSPRT-ZKXB-37-0','1','1.590','1.590','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXB-37-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:25:42','TOKO','DUPSN','PSPRT','PSPRT-ZKXB-37-0','1','1.590','1.590','1','1.590','1.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-ZKXB-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSPLT-ZKXB-38-0','1','1.860','1.860','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:25:42','TOKO','DUPSN','PSPLT','PSPLT-ZKXB-38-0','1','1.860','1.860','1','1.860','1.860','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-ZKXB-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSPLT-ZKXB-39-0','1','2.390','2.390','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPLT-ZKXB-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:25:42','TOKO','DUPSN','PSPLT','PSPLT-ZKXB-39-0','1','2.390','2.390','1','2.390','2.390','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-ZKXB-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSPLT-ZKXB-40-0','1','2.760','2.760','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPLT-ZKXB-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:25:42','TOKO','DUPSN','PSPLT','PSPLT-ZKXB-40-0','1','2.760','2.760','1','2.760','2.760','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-ZKXB-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0006','1','PSPLT-ZKXB-41-0','1','3.030','3.030','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-03 12:25:42' WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:25:42','TOKO','DUPSN','PSPLT','PSPLT-ZKXB-41-0','1','3.030','3.030','1','3.030','3.030','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-ZKXB-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0006','2026-11-03','12:25','16.860','kasirbip','2026-11-03 12:25:42'); 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-20261103-0007','1','PSGT-ZJCX-43-0','1','2.500','2.500','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJCX-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJCX-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJCX-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJCX-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSGT-ZJCX-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJCX-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-11-03 12:45:40','TOKO','BIPPSN','PSGT','PSGT-ZJCX-43-0','1','2.500','2.500','1','2.500','2.500','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-ZJCX-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJCX-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-23-0','1','2.500','2.500','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-23-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-23-0','1','2.500','2.500','1','2.500','2.500','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-ZKXB-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-24-0','1','3.160','3.160','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-24-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-24-0','1','3.160','3.160','1','3.160','3.160','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-ZKXB-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-25-0','1','2.740','2.740','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-25-0','1','2.740','2.740','1','2.740','2.740','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-ZKXB-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-26-0','1','3.120','3.120','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-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-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-26-0','1','3.120','3.120','1','3.120','3.120','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-ZKXB-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-27-0','1','3.230','3.230','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-27-0','1','3.230','3.230','1','3.230','3.230','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-ZKXB-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-28-0','1','3.250','3.250','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-28-0','1','3.250','3.250','1','3.250','3.250','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-ZKXB-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-29-0','1','2.320','2.320','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-29-0','1','2.320','2.320','1','2.320','2.320','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-ZKXB-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-30-0','1','2.940','2.940','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-30-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-30-0','1','2.940','2.940','1','2.940','2.940','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-ZKXB-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-31-0','1','3.340','3.340','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-31-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-31-0','1','3.340','3.340','1','3.340','3.340','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-ZKXB-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPLT-ZKXB-32-0','1','2.910','2.910','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPLT','PSPLT-ZKXB-32-0','1','2.910','2.910','1','2.910','2.910','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-ZKXB-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPRT-ZKXB-33-0','1','2.070','2.070','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPRT','PSPRT-ZKXB-33-0','1','2.070','2.070','1','2.070','2.070','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-ZKXB-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' 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-20261103-0007','1','PSPRT-ZKXB-34-0','1','2.800','2.800','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXB-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXB-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-03 12:45:40' WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXB-34-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-03 12:45:40','TOKO','BIPPSN','PSPRT','PSPRT-ZKXB-34-0','1','2.800','2.800','1','2.800','2.800','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-ZKXB-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXB-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-03' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261103-0007','2026-11-03','12:45','36.880','kasirbip','2026-11-03 12:45:39'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0003'; 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-04995','DIL','1','PER','WEDD RING CP07','','','3.000','','925.00','1','100000','0','1600000','0','1600000','WANITA: SIZE 12 GRF: RJ.201126 (BERKSHIRE)','PRIA: SIZE 22 GRF: RJ.201126 (BERKSHIRE)','CROM SESUAI FOTO (EXPRESS 300.000)','0','100000',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261103-0007','2026-11-03','2026-11-03 12:59:28','PESANAN : DP-04995','-','TBC','1700000','1700000'); 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-261103-0008','D','2026-11-03','12:59:28','TBC','PESANAN','DP-04995','30390735464','1700000','30392435464','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-04995','2026-11-03','2026-11-03','12:59:28','PLG0018383','DIL','2026-11-13','sby','2026-11-03 12:59:28','3.000','0','0','0','1700000','0','0','1700000','1700000','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-04996','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE: 21','TNPA UKIR','FINISHING: PUTIH DOFF MIX GLOSSY','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-261103-0008','2026-11-03','2026-11-03 13:55:50','PESANAN : DP-04996','-','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-261103-0009','D','2026-11-03','13:55:50','TBC','PESANAN','DP-04996','30392435464','900000','30393335464','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-04996','2026-11-03','2026-11-03','13:55:50','PLG0018384','VAN','2026-11-25','sby','2026-11-03 13:55:50','3.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-261103-0004','jogja','1',' 950K-125-0','TOKO','JOGPER','PJOG-ZJAI-65-0','CINCIN SILVER 925 ','','2.030','1','100.00','208000','0','0','17800','1050000','0','0','0','1050000','DEW','00048309','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZJAI-65-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PJOG-ZJAI-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261103-0004','2026-11-03','2.030','2026-11-03','15:21:48','PLG0018385','1050000','1050000','0','1050000','0','jogja','2026-11-03 15:21:47','FJ-261103-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0004','2026-11-03','15:21:48','DEW','1050000','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-261103-0009','2026-11-03','2026-11-03 15:21:47','PENJUALAN : FJ-261103-0004','','TBC','1050000','1050000','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-261103-0010','D','2026-11-03','15:21:48','TBC','PENJUALAN','FJ-261103-0004','30393335464','1050000','30394385464','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='1050000' WHERE no_faktur_jual='FJ-261103-0004' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-03 ','15:32:11'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0004'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261103-0005','kasirbip','1',' 850K-12-30','TOKO','BIPPER','PBDG-ZIBI-11-0','CINCIN SILVER 925 ','','1.390','1','100.00','142000','0','0','17800','1000000','0','0','0','1000000','SULIS','00047750','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBI-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PBDG-ZIBI-11-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-261103-0005','2026-11-03','1.390','2026-11-03','15:43:26','PLG0018386','1000000','1000000','0','1000000','0','kasirbip','2026-11-03 15:43:25','FJ-261103-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0005','2026-11-03','15:43:26','SULIS','1000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261103-0010','2026-11-03','2026-11-03 15:43:25','PENJUALAN : FJ-261103-0005','.','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261103-0011','D','2026-11-03','15:43:26','TBC','PENJUALAN','FJ-261103-0005','30394385464','1000000','30395385464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-261103-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-261103-0006','kasirbip',' 1',' 750K-155-2','TOKO','BIPPER','PBDG-ZHCA-50-0','CINCIN SILVER 925 ','','2.160','1','100.00','221000','0','0','17800','850000','0','0','0','850000','SULIS','00046742','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHCA-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PBDG-ZHCA-50-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-261103-0006','2026-11-03','2.160','2026-11-03','15:43:26','PLG0018387','850000','850000','0','850000','0','kasirbip','2026-11-03 15:43:25','FJ-261103-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0006','2026-11-03','15:43:26','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-261103-0011','2026-11-03','2026-11-03 15:43:25','PENJUALAN : FJ-261103-0006','.','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-261103-0012','D','2026-11-03','15:43:26','TBC','PENJUALAN','FJ-261103-0006','30395385464','850000','30396235464','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='1850000' WHERE no_faktur_jual='FJ-261103-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0006'; 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-261103-0007','sby','1',' DP-04471SB','TOKO','SBYPSN','PSPLT-ZJBH-15-0','CINCIN PALADIUM ','','3.280','1','17.00','737000','0','0','17800','1958000','0','0','0','1958000','DIL','00048716','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBH-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJBH-15-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-261103-0007','2026-11-03','3.280','2026-11-03','15:44:09','PLG0018388','1958000','1958000','0','1958000','0','sby','2026-11-03 15:44:08','FJ-261103-0007','DP-04471','1500000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0007','2026-11-03','15:44:09','DIL','1958000','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-261103-0012','2026-11-03','2026-11-03 15:44:08','PENJUALAN : FJ-261103-0007','','TBC','458000','458000','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-261103-0013','D','2026-11-03','15:44:09','TBC','PENJUALAN','FJ-261103-0007','30396235464','458000','30396693464','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='458000' WHERE no_faktur_jual='FJ-261103-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-261103-0008','sby',' 1',' DP-04472SB','TOKO','SBYPSN','PSGT-ZJBH-14-0','CINCIN EMAS ','','2.480','1','45.00','2585000','0','0','17800','4682000','0','0','0','4682000','DIL','00048715','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBH-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSGT-ZJBH-14-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-261103-0008','2026-11-03','2.480','2026-11-03','15:44:09','PLG0018389','4682000','4682000','0','4682000','0','sby','2026-11-03 15:44:08','FJ-261103-0007','DP-04472','3500000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0008','2026-11-03','15:44:09','DIL','4682000','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-261103-0013','2026-11-03','2026-11-03 15:44:08','PENJUALAN : FJ-261103-0008','','TBC','1182000','1182000','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-261103-0014','D','2026-11-03','15:44:09','TBC','PENJUALAN','FJ-261103-0008','30396693464','1182000','30397875464','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='1640000' WHERE no_faktur_jual='FJ-261103-0008' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-03 ','16:05:00'); 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-261103-0009','jogja','1',' 1.0K-14-00','TOKO','JOGPER','PJOG-ZJCX-20-0','CINCIN SILVER 925 ','','1.750','1','100.00','179000','0','0','17800','1100000','0','0','0','1100000','ADL','00048784','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZJCX-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PJOG-ZJCX-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261103-0009','2026-11-03','1.750','2026-11-03','16:46:19','PLG0018390','1100000','1100000','0','1100000','0','jogja','2026-11-03 16:46:19','FJ-261103-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-11-03','FJ-261103-0009','2026-11-03','16:46:19','ADL','1100000','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-261103-0014','2026-11-03','2026-11-03 16:46:19','PENJUALAN : FJ-261103-0009','','TBC','1100000','1100000','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-261103-0015','D','2026-11-03','16:46:19','TBC','PENJUALAN','FJ-261103-0009','30397875464','1100000','30398975464','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='1100000' WHERE no_faktur_jual='FJ-261103-0009' 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-261103-0010','jogja',' 1',' 750K-18-00','TOKO','JOGPER','PJOG-ZHBF-46-0','CINCIN SILVER 925 ','','2.210','1','100.00','226000','0','0','17800','850000','0','0','0','850000','ADL','00046552','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZHBF-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PJOG-ZHBF-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261103-0010','2026-11-03','2.210','2026-11-03','16:46:19','PLG0018391','850000','850000','0','850000','0','jogja','2026-11-03 16:46:19','FJ-261103-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-11-03','FJ-261103-0010','2026-11-03','16:46:19','ADL','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-261103-0015','2026-11-03','2026-11-03 16:46:19','PENJUALAN : FJ-261103-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-261103-0016','D','2026-11-03','16:46:19','TBC','PENJUALAN','FJ-261103-0010','30398975464','850000','30399825464','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='1950000' WHERE no_faktur_jual='FJ-261103-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0010'; 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-04997','PUT','1','PER','WEDDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','Sz cwe 11 grf Putri','Sz cwo 19 grf Adi','font Vintage','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-261103-0016','2026-11-03','2026-11-03 17:19:12','PESANAN : DP-04997','.','TBC','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,jenis_trx) VALUES ('KM-261103-0017','D','2026-11-03','17:19:12','TBC','PESANAN','DP-04997','30399825464','850000','30400675464','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-04997','2026-11-03','2026-11-03','17:19:12','PLG0018392','PUT','2026-12-02','kasirbip','2026-11-03 17:19:12','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-03 ','17:22:16'); 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-04998','ELLA','1','PER','WEDDING RING','','','2.500','','925.00','1','100000','0','0','0','900000','size14 grf JP','warna crom putih glosy','zircone 1 butir','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-261103-0017','2026-11-03','2026-11-03 17:25:43','PESANAN : DP-04998','0','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-261103-0018','D','2026-11-03','17:25:43','TBC','PESANAN','DP-04998','30400675464','900000','30401575464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-04998','2026-11-03','2026-11-03','17:25:43','PLG0018393','ELLA','2026-11-30','kasir','2026-11-03 17:25:43','2.500','0','0','0','900000','0','0','900000','900000','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-04999','ADL','1','GOLD','WEDDINGRING','','','2.500','','375.00','1','2250000','1300000','0','1050000','4300000','sz cwe 12','gf Berksbire : Huda...Nurul','Gold (zircon 20)','0','0','200000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261103-0018','2026-11-03','2026-11-03 17:27:57','PESANAN : DP-04999','-','TBC','3600000','3600000'); 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-261103-0019','D','2026-11-03','17:27:57','TBC','PESANAN','DP-04999','30401575464','3600000','30405175464','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-04999','2026-11-03','2026-11-03','17:27:57','PLG0018394','ADL','2026-11-28','jogja','2026-11-03 17:27:57','2.500','0','0','0','3600000','0','1050000','4500000','4500000','900000'); 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-05000','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','950000','size 22.5 grf T L','warna crom putih doff semprot','TANPA PERMATA','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-261103-0019','2026-11-03','2026-11-03 17:29:06','PESANAN : DP-05000','0','TBC','950000','950000'); 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-261103-0020','D','2026-11-03','17:29:06','TBC','PESANAN','DP-05000','30405175464','950000','30406125464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05000','2026-11-03','2026-11-03','17:29:06','PLG0018395','ELLA','2026-11-30','kasir','2026-11-03 17:29:06','3.000','0','0','0','950000','0','0','950000','950000','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-05001','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','SR-01 cwe 8.5 grf Kusworo ....','YL-01 cwo sz 16.5 Milatry ....','font brush script','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261103-0020','2026-11-03','2026-11-03 17:29:26','PESANAN : DP-05001','.','TBC','950000','950000'); 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-261103-0021','D','2026-11-03','17:29:26','TBC','PESANAN','DP-05001','30406125464','950000','30407075464','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-05001','2026-11-03','2026-11-03','17:29:26','PLG0018396','SAL','2026-11-19','kasirbip','2026-11-03 17:29:26','2.000','0','0','0','950000','0','0','950000','950000','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-05002','ADL','1','PLD','WEDDINGRING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz cwo 18','gf Berkshbire : Huda...Nurul','warna 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-261103-0021','2026-11-03','2026-11-03 17:30:03','PESANAN : DP-05002','-','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-261103-0022','D','2026-11-03','17:30:03','TBC','PESANAN','DP-05002','30407075464','1620000','30408695464','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-05002','2026-11-03','2026-11-03','17:30:03','PLG0018397','ADL','2026-11-28','jogja','2026-11-03 17:30:03','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000'); 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-261103-0011','kasirbip','1',' DP-04510BI','TOKO','BIPPSN','PSPLT-ZKXB-29-0','CINCIN PALADIUM ','','2.320','1','17.00','521000','0','0','17800','1842000','0','0','0','1842000','KUR','00048847','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXB-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZKXB-29-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-261103-0011','2026-11-03','2.320','2026-11-03','18:08:53','PLG0018398','1842000','1842000','0','1842000','0','kasirbip','2026-11-03 18:08:52','FJ-261103-0011','DP-04510','1660000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0011','2026-11-03','18:08:53','KUR','1842000','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-261103-0022','2026-11-03','2026-11-03 18:08:52','PENJUALAN : FJ-261103-0011','.','TBC','182000','182000','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-261103-0023','D','2026-11-03','18:08:53','TBC','PENJUALAN','FJ-261103-0011','30408695464','182000','30408877464','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='182000' WHERE no_faktur_jual='FJ-261103-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-261103-0012','kasirbip',' 1',' DP-04511BI','TOKO','BIPPSN','PSPLT-ZKXB-27-0','CINCIN PALADIUM ','','3.230','1','17.00','725000','0','0','17800','1880500','0','0','0','1880500','KUR','00048845','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXB-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZKXB-27-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-261103-0012','2026-11-03','3.230','2026-11-03','18:08:53','PLG0018399','1880500','1880500','0','1880500','0','kasirbip','2026-11-03 18:08:52','FJ-261103-0011','DP-04511','1720000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0012','2026-11-03','18:08:53','KUR','1880500','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-261103-0023','2026-11-03','2026-11-03 18:08:52','PENJUALAN : FJ-261103-0012','.','TBC','160500','160500','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-261103-0024','D','2026-11-03','18:08:53','TBC','PENJUALAN','FJ-261103-0012','30408877464','160500','30409037964','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='342500' WHERE no_faktur_jual='FJ-261103-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0012'; 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-05003','DIL','1','PER','WEDD RING PRIA YL01','','','2.000','','925.00','1','100000','0','600000','0','600000','SIZE 22 GRF: Ameliya & Abdu (VLADIMIR)','PUTIH GLOSSY MIX DOFF','','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-261103-0024','2026-11-03','2026-11-03 18:29:54','PESANAN : DP-05003','-','TBC','600000','600000'); 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-261103-0025','D','2026-11-03','18:29:54','TBC','PESANAN','DP-05003','30409037964','600000','30409637964','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-05003','2026-11-03','2026-11-03','18:29:54','PLG0018400','DIL','2026-11-28','sby','2026-11-03 18:29:54','2.000','0','0','0','600000','0','0','600000','600000','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-261103-0013','kasirbip','1',' 800K-20-00','TOKO','DUPERBDG','LXPER-ZJCX-3-0','CINCIN SILVER 925 ','','3.760','1','100.00','384000','0','0','17800','900000','0','0','0','900000','KUR','00048767','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJCX-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.760',berat_jual_asli=berat_jual_asli+'3.760',stock_jual='1',berat_akhir=berat_akhir-'3.760',berat_akhir_asli=berat_akhir_asli-'3.760',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='LXPER-ZJCX-3-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-261103-0013','2026-11-03','3.760','2026-11-03','18:36:20','PLG0018401','900000','900000','0','900000','0','kasirbip','2026-11-03 18:36:19','FJ-261103-0013','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0013','2026-11-03','18:36:20','KUR','900000','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-261103-0025','2026-11-03','2026-11-03 18:36:19','PENJUALAN : FJ-261103-0013','.','TBC','900000','900000','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-261103-0026','D','2026-11-03','18:36:20','TBC','PENJUALAN','FJ-261103-0013','30409637964','900000','30410537964','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='900000' WHERE no_faktur_jual='FJ-261103-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-05004','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','1200000','0','1200000','MODEL OVAL (REQ BODY NYA AGAK CEMBUNG / BULAT)','SIZE 19 GRF: Abdu & Dona 25.03.27 (VLADIMIR)','PUTIH GLOSSY','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-261103-0026','2026-11-03','2026-11-03 18:46:20','PESANAN : DP-05004','-','TBC','1200000','1200000'); 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-261103-0027','D','2026-11-03','18:46:20','TBC','PESANAN','DP-05004','30410537964','1200000','30411737964','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-05004','2026-11-03','2026-11-03','18:46:20','PLG0018402','DIL','2026-11-28','sby','2026-11-03 18:46:20','2.000','0','0','0','1200000','0','0','1200000','1200000','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-05005','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','900000','0','900000','MODEL V','SIZE 19 GRF: Abdu & Dona 25.03.27 (VLADIMIR)','PUTIH GLOSSY','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-261103-0027','2026-11-03','2026-11-03 18:48:45','PESANAN : DP-05005','-','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-261103-0028','D','2026-11-03','18:48:45','TBC','PESANAN','DP-05005','30411737964','900000','30412637964','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-05005','2026-11-03','2026-11-03','18:48:45','PLG0018403','DIL','2026-11-28','sby','2026-11-03 18:48:45','2.000','0','0','0','900000','0','0','900000','900000','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-05006','ALIKA','1','PER','WEDDING RING','','','2.500','','925.00','1','100000','0','0','0','950000','SIZE 17 GRF Fina','emerald kotak','crom putih sesuai modell','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-261103-0028','2026-11-03','2026-11-03 19:14:12','PESANAN : DP-05006','0','TBC','950000','950000'); 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-261103-0029','D','2026-11-03','19:14:12','TBC','PESANAN','DP-05006','30412637964','950000','30413587964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-05006','2026-11-03','2026-11-03','19:14:12','PLG0018404','ALIKA','2026-11-30','kasir','2026-11-03 19:14:12','2.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-03 ','19:22:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-03 ','19:26:21'); DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJCX-43-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 ('PSGT-ZJCX-43-0','00048807','00048807','CINCIN EMAS ','CINCIN EMAS','','','4710500','4710500',' 390000','390000','kasir','2026-11-03 19:28:35'); UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-04694BIP ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 10',total_usd_ext='PSN04694BIP',total_usd='0' WHERE kode_barang='PSGT-ZJCX-43-0' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261103-0014','kasir','1',' DP-04694BI','TOKO','BIPPSN','PSGT-ZJCX-43-0','CINCIN EMAS','','2.500','1','83.00','4805000','0','0','17800','6615000','0','0','0','6615000','SULIS','00048807','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJCX-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSGT-ZJCX-43-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-261103-0014','2026-11-03','2.500','2026-11-03','19:30:28','PLG0018405','6615000','6615000','0','6615000','0','kasir','2026-11-03 19:30:27','FJ-261103-0014','DP-04694','5292000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0014','2026-11-03','19:30:28','SULIS','6615000','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-261103-0029','2026-11-03','2026-11-03 19:30:27','PENJUALAN : FJ-261103-0014','.','TBC','1323000','1323000','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-261103-0030','D','2026-11-03','19:30:28','TBC','PENJUALAN','FJ-261103-0014','30413587964','1323000','30414910964','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='1323000' WHERE no_faktur_jual='FJ-261103-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0014'; 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-261103-0015','kasirbip','1',' DP-04465DU','TOKO','DUPSN','PSPLT-ZKXB-41-0','CINCIN PALADIUM ','','3.030','1','17.00','681000','0','0','17800','1810500','0','0','0','1810500','KUR','00048859','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXB-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZKXB-41-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-261103-0015','2026-11-03','3.030','2026-11-03','19:29:52','PLG0018406','1810500','1810500','0','1810500','0','kasirbip','2026-11-03 19:29:52','FJ-261103-0015','DP-04465','1440000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0015','2026-11-03','19:29:52','KUR','1810500','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-261103-0030','2026-11-03','2026-11-03 19:29:52','PENJUALAN : FJ-261103-0015','.','TBC','370500','370500','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-261103-0031','D','2026-11-03','19:29:52','TBC','PENJUALAN','FJ-261103-0015','30414910964','370500','30415281464','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='370500' WHERE no_faktur_jual='FJ-261103-0015' 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-261103-0016','kasirbip',' 1',' DP-04464DU','TOKO','DUPSN','PSPLT-ZKXB-38-0','CINCIN PALADIUM ','','1.860','1','17.00','418000','0','0','17800','1761000','0','0','0','1761000','KUR','00048856','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXB-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZKXB-38-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-261103-0016','2026-11-03','1.860','2026-11-03','19:29:52','PLG0018407','1761000','1761000','0','1761000','0','kasirbip','2026-11-03 19:29:52','FJ-261103-0015','DP-04464','1580000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0016','2026-11-03','19:29:52','KUR','1761000','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-261103-0031','2026-11-03','2026-11-03 19:29:52','PENJUALAN : FJ-261103-0016','.','TBC','181000','181000','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-261103-0032','D','2026-11-03','19:29:52','TBC','PENJUALAN','FJ-261103-0016','30415281464','181000','30415462464','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='551500' WHERE no_faktur_jual='FJ-261103-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-261103-0017','kasir','1',' DP-04576MM','TOKO','MMPSN','PSPLT-ZJBI-4-0','CINCIN PALADIUM ','','3.540','1','17.00','795000','0','0','17800','2349000','0','0','0','2349000','ALIKA','00048730','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBI-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.540',berat_jual_asli=berat_jual_asli+'3.540',stock_jual='1',berat_akhir=berat_akhir-'3.540',berat_akhir_asli=berat_akhir_asli-'3.540',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJBI-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-261103-0017','2026-11-03','3.540','2026-11-03','19:31:57','PLG0018408','2349000','2349000','0','2349000','0','kasir','2026-11-03 19:31:56','FJ-261103-0017','DP-04576','1868000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0017','2026-11-03','19:31:57','ALIKA','2349000','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-261103-0032','2026-11-03','2026-11-03 19:31:56','PENJUALAN : FJ-261103-0017','.','TBC','481000','481000','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-261103-0033','D','2026-11-03','19:31:57','TBC','PENJUALAN','FJ-261103-0017','30415462464','481000','30415943464','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='481000' WHERE no_faktur_jual='FJ-261103-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-261103-0018','kasir',' 1',' DP-04577MM','TOKO','MMPSN','PSPRT-ZKXB-45-0','CINCIN PERAK ','','4.630','1','100.00','473000','0','0','17800','1050000','0','0','0','1050000','ALIKA','00048863','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXB-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.630',berat_jual_asli=berat_jual_asli+'4.630',stock_jual='1',berat_akhir=berat_akhir-'4.630',berat_akhir_asli=berat_akhir_asli-'4.630',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPRT-ZKXB-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-261103-0018','2026-11-03','4.630','2026-11-03','19:31:57','PLG0018409','1050000','1050000','0','1050000','0','kasir','2026-11-03 19:31:56','FJ-261103-0017','DP-04577','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-11-03','FJ-261103-0018','2026-11-03','19:31:57','ALIKA','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='481000' WHERE no_faktur_jual='FJ-261103-0018' 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-261103-0019','kasirbip','1',' DP-04145BI','TOKO','BIPPSN','PSPRT-ZJAD-10-0','CINCIN PERAK ','','2.190','1','100.00','224000','0','0','17800','850000','0','0','0','850000','SULIS','00048137','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAD-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPRT-ZJAD-10-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-261103-0019','2026-11-03','2.190','2026-11-03','19:34:05','PLG0018410','850000','850000','0','850000','0','kasirbip','2026-11-03 19:34:04','FJ-261103-0019','DP-04145','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-11-03','FJ-261103-0019','2026-11-03','19:34:05','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-261103-0019' 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-261103-0020','kasirbip',' 1',' DP-04146BI','TOKO','BIPPSN','PSPLT-ZJAF-13-0','CINCIN PALADIUM ','','1.550','1','17.00','349000','0','0','17800','1512000','0','0','0','1512000','SULIS','00048210','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJAF-13-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-261103-0020','2026-11-03','1.550','2026-11-03','19:34:05','PLG0018411','1512000','1512000','0','1512000','0','kasirbip','2026-11-03 19:34:04','FJ-261103-0019','DP-04146','1196000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0020','2026-11-03','19:34:05','SULIS','1512000','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-261103-0033','2026-11-03','2026-11-03 19:34:04','PENJUALAN : FJ-261103-0020','.','TBC','316000','316000','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-261103-0034','D','2026-11-03','19:34:05','TBC','PENJUALAN','FJ-261103-0020','30415943464','316000','30416259464','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='316000' WHERE no_faktur_jual='FJ-261103-0020' 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-05007','ALIKA','1','PER','WEDDINGB RING CP 10','','','3.000','','925.00','1','100000','0','0','0','1400000','cwe size 13 grf Arvi zircone 7 btr','cwo size 26 grf Putri UPSIZE 150K','EXPRES 200K CROM PUTIH SESUAI MODEL','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-261103-0034','2026-11-03','2026-11-03 19:37:43','PESANAN : DP-05007','.','TBC','1400000','1400000'); 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-261103-0035','D','2026-11-03','19:37:43','TBC','PESANAN','DP-05007','30416259464','1400000','30417659464','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-05007','2026-11-03','2026-11-03','19:37:43','PLG0018412','ALIKA','2026-11-11','kasir','2026-11-03 19:37:43','3.000','0','0','0','1400000','0','0','1400000','1400000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0020'; 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-261103-0021','sby','1',' DP-04571SB','TOKO','SBYPSN','PSPLT-ZJBH-17-0','CINCIN PALADIUM ','','2.780','1','17.00','625000','0','0','17800','1573000','0','0','0','1573000','DIL','00048718','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBH-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSPLT-ZJBH-17-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-261103-0021','2026-11-03','2.780','2026-11-03','20:13:05','PLG0018413','1573000','1573000','0','1573000','0','sby','2026-11-03 20:13:05','FJ-261103-0021','DP-04571','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-11-03','FJ-261103-0021','2026-11-03','20:13:05','DIL','1573000','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-261103-0035','2026-11-03','2026-11-03 20:13:05','PENJUALAN : FJ-261103-0021','','TBC','373000','373000','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-261103-0036','D','2026-11-03','20:13:05','TBC','PENJUALAN','FJ-261103-0021','30417659464','373000','30418032464','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='373000' WHERE no_faktur_jual='FJ-261103-0021' 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-261103-0022','sby',' 1',' DP-04572SB','TOKO','SBYPSN','PSGT-ZJBI-38-0','CINCIN EMAS ','','1.640','1','45.00','1710000','0','0','17800','3026000','0','0','0','3026000','DIL','00048764','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBI-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSGT-ZJBI-38-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-261103-0022','2026-11-03','1.640','2026-11-03','20:13:05','PLG0018414','3026000','3026000','0','3026000','0','sby','2026-11-03 20:13:05','FJ-261103-0021','DP-04572','2300000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0022','2026-11-03','20:13:05','DIL','3026000','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-261103-0036','2026-11-03','2026-11-03 20:13:05','PENJUALAN : FJ-261103-0022','','TBC','726000','726000','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-261103-0037','D','2026-11-03','20:13:05','TBC','PENJUALAN','FJ-261103-0022','30418032464','726000','30418758464','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='1099000' WHERE no_faktur_jual='FJ-261103-0022' 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-05008','VAN','1','GOLD','WEDDRING WANITA','','','3.000','','50.00','1','2250000','1600000','0','750000','5550000','PERMATA ZIRKON BIRU','SIZE: 15 TANPA UKIR','FINISHING: PUTIH MIX GOLD KUNING','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261103-0037','2026-11-03','2026-11-03 20:34:14','PESANAN : DP-05008','-','TBC','4300000','4300000'); 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-261103-0038','D','2026-11-03','20:34:14','TBC','PESANAN','DP-05008','30418758464','4300000','30423058464','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-05008','2026-11-03','2026-11-03','20:34:14','PLG0018415','VAN','2026-11-25','sby','2026-11-03 20:34:14','3.000','0','0','0','4300000','0','750000','5650000','5650000','1350000'); 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-05009','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','SIZE: 27','TANPA UKIR NAMA','FINISHING: PUTIH MIX GOLD KUNING','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-261103-0038','2026-11-03','2026-11-03 20:38:26','PESANAN : DP-05009','-','TBC','1400000','1400000'); 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-261103-0039','D','2026-11-03','20:38:26','TBC','PESANAN','DP-05009','30423058464','1400000','30424458464','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-05009','2026-11-03','2026-11-03','20:38:26','PLG0018416','VAN','2026-11-25','sby','2026-11-03 20:38:26','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0022'; 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-261103-0023','sby','1',' 800K-185-0','TOKO','SBYPER','PSBY-ZJAI-75-0','CINCIN SILVER 925 ','','3.250','1','100.00','332000','0','0','17800','900000','0','0','0','900000','DIL','00048319','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-11-03' AND kode_barang='PSBY-ZJAI-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-261103-0023','2026-11-03','3.250','2026-11-03','21:02:38','PLG0018417','900000','900000','0','900000','0','sby','2026-11-03 21:02:38','FJ-261103-0023','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-03','FJ-261103-0023','2026-11-03','21:02:38','DIL','900000','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-261103-0039','2026-11-03','2026-11-03 21:02:38','PENJUALAN : FJ-261103-0023','','TBC','900000','900000','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-261103-0040','D','2026-11-03','21:02:38','TBC','PENJUALAN','FJ-261103-0023','30424458464','900000','30425358464','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='900000' WHERE no_faktur_jual='FJ-261103-0023' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261103-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261103-0023'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-04','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-04'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-03'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-03'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-03' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-03'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-03'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-04' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-03' 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-261104-0001','D','2026-11-04','21:25:53','TBC','SALDO AWAL','SALDO AWAL','0','30425358464','30425358464'); 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-261104-0001','D','2026-11-04','21:25:53','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); 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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','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-261104-0001','D','2026-11-04','21:25:53','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-11-04';