INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','08:25:41'); 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-20261110-0001','1','TFCMR-ZKXI-78-0','1','1.040','1.040','TOKO','CMPTF','TOKO','TFCINMAS'); DELETE FROM tm_barang WHERE kode_barang='TFCMR-ZKXI-78-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-ZKXI-78-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFCMR-ZKXI-78-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-ZKXI-78-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2026-11-10 08:25:58' WHERE kode_barang='TFCMR-ZKXI-78-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-ZKXI-78-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-10 08:25:58','TOKO','TFCINMAS','TFCMR','TFCMR-ZKXI-78-0','1','1.040','1.040','1','1.040','1.040','87.00'); DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' 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='TFCMR-ZKXI-78-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-ZKXI-78-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261110-0001','2026-11-10','08:25','1.040','kasir','2026-11-10 08:25:57'); 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-20261110-0002','1','TFGKR-ZKXI-79-0','1','2.060','2.060','TOKO','GLKTF','TOKO','TFGLK'); DELETE FROM tm_barang WHERE kode_barang='TFGKR-ZKXI-79-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGKR-ZKXI-79-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGKR-ZKXI-79-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGKR-ZKXI-79-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLK',tgl_last_beli='2026-11-10 08:26:18' WHERE kode_barang='TFGKR-ZKXI-79-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGKR-ZKXI-79-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-10 08:26:18','TOKO','TFGLK','TFGKR','TFGKR-ZKXI-79-0','1','2.060','2.060','1','2.060','2.060','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGKR' 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='TFGKR-ZKXI-79-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-ZKXI-79-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261110-0002','2026-11-10','08:26','2.060','kasir','2026-11-10 08:26:18'); 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-20261110-0003','1','TFGRR-ZKXI-80-0','1','2.090','2.090','TOKO','GLRTF','TOKO','TFGLR'); DELETE FROM tm_barang WHERE kode_barang='TFGRR-ZKXI-80-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-80-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGRR-ZKXI-80-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-ZKXI-80-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2026-11-10 08:26:48' WHERE kode_barang='TFGRR-ZKXI-80-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-ZKXI-80-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-10 08:26:48','TOKO','TFGLR','TFGRR','TFGRR-ZKXI-80-0','1','2.090','2.090','1','2.090','2.090','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' 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='TFGRR-ZKXI-80-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-80-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0003','1','TFGRR-ZKXI-81-0','1','2.490','2.490','TOKO','GLRTF','TOKO','TFGLR'); DELETE FROM tm_barang WHERE kode_barang='TFGRR-ZKXI-81-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-81-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGRR-ZKXI-81-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-ZKXI-81-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2026-11-10 08:26:48' WHERE kode_barang='TFGRR-ZKXI-81-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-ZKXI-81-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-10 08:26:48','TOKO','TFGLR','TFGRR','TFGRR-ZKXI-81-0','1','2.490','2.490','1','2.490','2.490','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' 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='TFGRR-ZKXI-81-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-81-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0003','1','TFGRR-ZKXI-82-0','1','0.820','0.820','TOKO','GLRTF','TOKO','TFGLR'); DELETE FROM tm_barang WHERE kode_barang='TFGRR-ZKXI-82-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-82-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGRR-ZKXI-82-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-ZKXI-82-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2026-11-10 08:26:48' WHERE kode_barang='TFGRR-ZKXI-82-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-ZKXI-82-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-10 08:26:48','TOKO','TFGLR','TFGRR','TFGRR-ZKXI-82-0','1','0.820','0.820','1','0.820','0.820','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' 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='TFGRR-ZKXI-82-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-82-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0003','1','TFGRR-ZKXI-83-0','1','0.770','0.770','TOKO','GLRTF','TOKO','TFGLR'); DELETE FROM tm_barang WHERE kode_barang='TFGRR-ZKXI-83-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-83-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFGRR-ZKXI-83-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-ZKXI-83-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2026-11-10 08:26:48' WHERE kode_barang='TFGRR-ZKXI-83-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-ZKXI-83-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-10 08:26:48','TOKO','TFGLR','TFGRR','TFGRR-ZKXI-83-0','1','0.770','0.770','1','0.770','0.770','83.00'); DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' 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='TFGRR-ZKXI-83-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-ZKXI-83-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261110-0003','2026-11-10','08:26','6.170','kasir','2026-11-10 08:26:48'); 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-20261110-0004','1','TFKMP-ZKXI-84-0','1','0.900','0.900','TOKO','KMPTF','TOKO','TFKMP'); DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZKXI-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZKXI-84-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZKXI-84-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZKXI-84-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-11-10 08:27:11' WHERE kode_barang='TFKMP-ZKXI-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZKXI-84-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-10 08:27:11','TOKO','TFKMP','TFKMP','TFKMP-ZKXI-84-0','1','0.900','0.900','1','0.900','0.900','85.00'); DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' 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='TFKMP-ZKXI-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZKXI-84-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261110-0004','2026-11-10','08:27','0.900','kasir','2026-11-10 08:27:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','08:27:36'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-10 ','09:03:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-10 ','09:52:18'); 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-05157','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','700000','0','700000','size 18.5','YL- 01','','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-261110-0001','2026-11-10','2026-11-10 09:57:38','PESANAN : DP-05157','.','TBC','700000','700000'); 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-261110-0002','D','2026-11-10','09:57:38','TBC','PESANAN','DP-05157','30812785464','700000','30813485464','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-05157','2026-11-10','2026-11-10','09:57:38','PLG0018756','KUR','2026-12-02','kasirbip','2026-11-10 09:57:38','2.000','0','0','0','700000','0','0','700000','700000','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-261110-0001','kasirbip','1',' 800K-19-00','TOKO','DUPERBDG','LXPER-ZJBG-13-0','CINCIN SILVER 925 ','','3.880','1','100.00','396000','0','0','17800','950000','0','0','0','950000','PUT','00048667','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='LXPER-ZJBG-13-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-261110-0001','2026-11-10','3.880','2026-11-10','10:58:29','PLG0018757','950000','950000','0','950000','0','kasirbip','2026-11-10 10:58:29','FJ-261110-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-10','FJ-261110-0001','2026-11-10','10:58:29','PUT','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261110-0002','2026-11-10','2026-11-10 10:58:29','PENJUALAN : FJ-261110-0001','.','TBC','950000','950000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261110-0003','D','2026-11-10','10:58:29','TBC','PENJUALAN','FJ-261110-0001','30813485464','950000','30814435464','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='950000' WHERE no_faktur_jual='FJ-261110-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-10 ','11:19:04'); 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-20261110-0005','1','PBDG-ZKXI-16-0','1','2.050','2.050','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-16-0','1','2.050','2.050','1','2.050','2.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-17-0','1','2.170','2.170','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-17-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-17-0','1','2.170','2.170','1','2.170','2.170','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-18-0','1','2.280','2.280','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-18-0','1','2.280','2.280','1','2.280','2.280','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-19-0','1','2.460','2.460','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-19-0','1','2.460','2.460','1','2.460','2.460','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-20-0','1','1.660','1.660','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-20-0','1','1.660','1.660','1','1.660','1.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-21-0','1','2.270','2.270','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-21-0','1','2.270','2.270','1','2.270','2.270','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-22-0','1','1.760','1.760','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-22-0','1','1.760','1.760','1','1.760','1.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-23-0','1','1.650','1.650','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-23-0','1','1.650','1.650','1','1.650','1.650','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-24-0','1','2.240','2.240','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-24-0','1','2.240','2.240','1','2.240','2.240','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-25-0','1','2.130','2.130','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-25-0','1','2.130','2.130','1','2.130','2.130','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-26-0','1','2.260','2.260','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-26-0','1','2.260','2.260','1','2.260','2.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-27-0','1','2.260','2.260','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-27-0','1','2.260','2.260','1','2.260','2.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-28-0','1','1.570','1.570','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-28-0','1','1.570','1.570','1','1.570','1.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-29-0','1','3.270','3.270','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-29-0','1','3.270','3.270','1','3.270','3.270','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-30-0','1','2.850','2.850','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-30-0','1','2.850','2.850','1','2.850','2.850','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-31-0','1','2.790','2.790','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-31-0','1','2.790','2.790','1','2.790','2.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-32-0','1','2.400','2.400','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-32-0','1','2.400','2.400','1','2.400','2.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-33-0','1','1.620','1.620','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-33-0','1','1.620','1.620','1','1.620','1.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-34-0','1','2.500','2.500','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-34-0','1','2.500','2.500','1','2.500','2.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-35-0','1','4.260','4.260','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-35-0','1','4.260','4.260','1','4.260','4.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-36-0','1','4.530','4.530','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-36-0','1','4.530','4.530','1','4.530','4.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-37-0','1','1.660','1.660','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-37-0','1','1.660','1.660','1','1.660','1.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-38-0','1','2.210','2.210','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-38-0','1','2.210','2.210','1','2.210','2.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-39-0','1','1.400','1.400','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-39-0','1','1.400','1.400','1','1.400','1.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-40-0','1','2.390','2.390','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-40-0','1','2.390','2.390','1','2.390','2.390','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-41-0','1','1.560','1.560','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-41-0','1','1.560','1.560','1','1.560','1.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-42-0','1','1.900','1.900','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-42-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-42-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-42-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-42-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-42-0','1','1.900','1.900','1','1.900','1.900','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-42-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-43-0','1','2.430','2.430','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-43-0','1','2.430','2.430','1','2.430','2.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-44-0','1','1.630','1.630','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-44-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-44-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-44-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-44-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-44-0','1','1.630','1.630','1','1.630','1.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-44-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' 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-20261110-0005','1','PBDG-ZKXI-45-0','1','1.750','1.750','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZKXI-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZKXI-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZKXI-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-11-10 11:25:25' WHERE kode_barang='PBDG-ZKXI-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZKXI-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-10 11:25:25','TOKO','BIPPER','PBDG','PBDG-ZKXI-45-0','1','1.750','1.750','1','1.750','1.750','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZKXI-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZKXI-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261110-0005','2026-11-10','11:19','67.910','kasirbip','2026-11-10 11:25:25'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','11:31:55'); 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-261110-0002','kasirbip','1',' DP-04476BI','TOKO','BIPPSN','PSPRT-ZKXE-2-0','CINCIN PERAK ','','3.550','1','100.00','363000','0','0','17800','850000','0','0','0','850000','SAL','00049022','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXE-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPRT-ZKXE-2-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-261110-0002','2026-11-10','3.550','2026-11-10','11:48:52','PLG0018758','850000','850000','0','850000','0','kasirbip','2026-11-10 11:48:52','FJ-261110-0002','DP-04476','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-10','FJ-261110-0002','2026-11-10','11:48:52','SAL','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-261110-0002' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261110-0003','kasirbip',' 1',' DP-04477BI','TOKO','BIPPSN','PSGT-ZJBF-29-0','CINCIN EMAS ','','2.400','1','45.00','2534000','0','0','17800','4210000','0','0','0','4210000','SAL','00048639','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBF-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSGT-ZJBF-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-261110-0003','2026-11-10','2.400','2026-11-10','11:48:52','PLG0018759','4210000','4210000','0','4210000','0','kasirbip','2026-11-10 11:48:52','FJ-261110-0002','DP-04477','3480000'); 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-10','FJ-261110-0003','2026-11-10','11:48:52','SAL','4210000','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-261110-0003','2026-11-10','2026-11-10 11:48:52','PENJUALAN : FJ-261110-0003','.','TBC','730000','730000','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-261110-0004','D','2026-11-10','11:48:52','TBC','PENJUALAN','FJ-261110-0003','30814435464','730000','30815165464','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='730000' WHERE no_faktur_jual='FJ-261110-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-10 ','12:02:58'); 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-05158','DEW','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','950000','0','950000','sz cewe 9.5 sz cwo 14','express 200.000','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0004','2026-11-10','2026-11-10 12:09:05','PESANAN : DP-05158','-','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-261110-0005','D','2026-11-10','12:09:05','TBC','PESANAN','DP-05158','30815165464','950000','30816115464','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-05158','2026-11-10','2026-11-10','12:09:05','PLG0018760','DEW','2026-11-19','jogja','2026-11-10 12:09:05','4.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','12:10:55'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-10 ','12:12:21'); 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-261110-0004','sby','1',' DP-04582SB','TOKO','SBYPSN','PSPRT-ZKXC-15-0','CINCIN PERAK ','','4.810','1','100.00','492000','0','0','17800','1000000','0','0','0','1000000','VAN','00048892','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXC-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.810',berat_jual_asli=berat_jual_asli+'4.810',stock_jual='1',berat_akhir=berat_akhir-'4.810',berat_akhir_asli=berat_akhir_asli-'4.810',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPRT-ZKXC-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-261110-0004','2026-11-10','4.810','2026-11-10','12:14:16','PLG0018761','1000000','1000000','0','1000000','0','sby','2026-11-10 12:14:16','FJ-261110-0004','DP-04582','1000000'); 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-10','FJ-261110-0004','2026-11-10','12:14:16','VAN','1000000','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-261110-0004' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261110-0005','sby',' 1',' DP-04583SB','TOKO','SBYPSN','PSPRT-ZKXE-26-0','CINCIN PERAK ','','4.420','1','100.00','451000','0','0','17800','1900000','0','0','0','1900000','VAN','00049046','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXE-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.420',berat_jual_asli=berat_jual_asli+'4.420',stock_jual='1',berat_akhir=berat_akhir-'4.420',berat_akhir_asli=berat_akhir_asli-'4.420',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPRT-ZKXE-26-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-261110-0005','2026-11-10','4.420','2026-11-10','12:14:16','PLG0018762','1900000','1900000','0','1900000','0','sby','2026-11-10 12:14:16','FJ-261110-0004','DP-04583','1900000'); 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-10','FJ-261110-0005','2026-11-10','12:14:16','VAN','1900000','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-261110-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-261110-0006','kasir','1',' DP-04719MM','TOKO','MMPSN','PSPRT-ZKXF-33-0','CINCIN PERAK ','','2.960','1','100.00','302000','0','0','17800','900000','0','0','0','900000','ALIKA','00049084','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXF-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPRT-ZKXF-33-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-261110-0006','2026-11-10','2.960','2026-11-10','12:14:54','PLG0018763','900000','900000','0','900000','0','kasir','2026-11-10 12:14:54','FJ-261110-0006','DP-04719','900000'); 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-10','FJ-261110-0006','2026-11-10','12:14:54','ALIKA','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-261110-0005','2026-11-10','2026-11-10 12:14:54','PENJUALAN : FJ-261110-0006','.','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-261110-0006','D','2026-11-10','12:14:54','TBC','PENJUALAN','FJ-261110-0006','30816115464','900000','30817015464','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-261110-0006' 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-261110-0007','kasir',' 1',' DP-04718MM','TOKO','MMPSN','PSGT-ZKXF-59-0','CINCIN EMAS ','','3.100','1','45.00','3202000','0','0','17800','5210000','0','0','0','5210000','ALIKA','00049110','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKXF-59-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSGT-ZKXF-59-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-261110-0007','2026-11-10','3.100','2026-11-10','12:14:54','PLG0018764','5210000','5210000','0','5210000','0','kasir','2026-11-10 12:14:54','FJ-261110-0006','DP-04718','4056000'); 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-10','FJ-261110-0007','2026-11-10','12:14:54','ALIKA','5210000','0'); 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-261110-0007' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0007'; 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-261110-0008','kasirbip','1',' 750K-12 ','TOKO','BIPCMP','BDCM-ZIXH-26-0','CINCIN EMAS ','','1.830','1','45.00','1920000','0','0','17800','3129000','0','0','0','3129000','SAL','00047039','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZIXH-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='BDCM-ZIXH-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-261110-0008','2026-11-10','1.830','2026-11-10','12:31:32','PLG0018765','3129000','3129000','0','3129000','0','kasirbip','2026-11-10 12:31:32','FJ-261110-0008','','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-10','FJ-261110-0008','2026-11-10','12:31:32','SAL','3129000','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-261110-0006','2026-11-10','2026-11-10 12:31:32','PENJUALAN : FJ-261110-0008','.','TBC','3129000','3129000','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-261110-0007','D','2026-11-10','12:31:32','TBC','PENJUALAN','FJ-261110-0008','30817015464','3129000','30820144464','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='3129000' WHERE no_faktur_jual='FJ-261110-0008' 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-261110-0009','kasirbip',' 1',' 800K-20-27','TOKO','BIPPER','PBDG-ZFAH-44-0','CINCIN SILVER 925 ','','4.910','1','100.00','501000','0','0','17800','900000','0','0','0','900000','SAL','00044557','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAH-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PBDG-ZFAH-44-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-261110-0009','2026-11-10','4.910','2026-11-10','12:31:32','PLG0018766','900000','900000','0','900000','0','kasirbip','2026-11-10 12:31:32','FJ-261110-0008','','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-10','FJ-261110-0009','2026-11-10','12:31:32','SAL','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-261110-0007','2026-11-10','2026-11-10 12:31:32','PENJUALAN : FJ-261110-0009','.','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-261110-0008','D','2026-11-10','12:31:32','TBC','PENJUALAN','FJ-261110-0009','30820144464','900000','30821044464','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='4029000' WHERE no_faktur_jual='FJ-261110-0009' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02319','SAL','1','CCN EMAS DAN PERAK','CWO PUTIH DOFF AMPLASS FONT VINTAGE ROTTER BERAT AKHIR CCN WANITA TULIS DI KERTAS','6.000','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02319','2026-11-10','2026-11-10','12:34:32','PLG0018767','kasirbip','2026-11-25','kasirbip','2026-11-10 12:34:32','6.000','0','0','0','0','0','0','0','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261110-0010','sby','1',' 800K-24-00','TOKO','SBYPER','PSBY-ZJAD-34-0','CINCIN SILVER 925 ','','4.360','1','100.00','446000','0','0','17800','900000','0','0','0','900000','VAN','00048161','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.360',berat_jual_asli=berat_jual_asli+'4.360',stock_jual='1',berat_akhir=berat_akhir-'4.360',berat_akhir_asli=berat_akhir_asli-'4.360',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSBY-ZJAD-34-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-261110-0010','2026-11-10','4.360','2026-11-10','12:37:59','PLG0018768','900000','900000','0','900000','0','sby','2026-11-10 12:37:58','FJ-261110-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-10','FJ-261110-0010','2026-11-10','12:37:59','VAN','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-261110-0008','2026-11-10','2026-11-10 12:37:58','PENJUALAN : FJ-261110-0010','','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-261110-0009','D','2026-11-10','12:37:59','TBC','PENJUALAN','FJ-261110-0010','30821044464','900000','30821944464','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-261110-0010' 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-05159','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 18 GRF: D.N.W (YASEVA)','PUTIH GLOSSY FULL','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-261110-0009','2026-11-10','2026-11-10 13:28:46','PESANAN : DP-05159','-','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-261110-0010','D','2026-11-10','13:28:46','TBC','PESANAN','DP-05159','30821944464','850000','30822794464','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-05159','2026-11-10','2026-11-10','13:28:46','PLG0018769','DIL','2026-12-05','sby','2026-11-10 13:28:46','2.000','0','0','0','850000','0','0','850000','850000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0010'; 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-261110-0011','kasirbip','1',' DP-04709BI','TOKO','BIPPSN','PSPLT-ZKXF-27-0','CINCIN PALADIUM YL01 ','','2.090','1','17.00','470000','0','0','17800','1300000','0','0','0','1300000','KUR','00049078','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXF-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPLT-ZKXF-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-261110-0011','2026-11-10','2.090','2026-11-10','13:44:35','PLG0018770','1300000','1300000','0','1300000','0','kasirbip','2026-11-10 13:44:35','FJ-261110-0011','DP-04709','1180000'); 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-10','FJ-261110-0011','2026-11-10','13:44:35','KUR','1300000','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-261110-0010','2026-11-10','2026-11-10 13:44:35','PENJUALAN : FJ-261110-0011','.','TBC','120000','120000','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-261110-0011','D','2026-11-10','13:44:35','TBC','PENJUALAN','FJ-261110-0011','30822794464','120000','30822914464','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='120000' WHERE no_faktur_jual='FJ-261110-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-261110-0012','kasirbip',' 1',' DP-04708BI','TOKO','BIPPSN','PSPLT-ZKXF-63-0','CINCIN PALADIUM SR01 ','','1.620','1','17.00','365000','0','0','17800','1267000','0','0','0','1267000','KUR','00049114','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXF-63-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSPLT-ZKXF-63-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-261110-0012','2026-11-10','1.620','2026-11-10','13:44:35','PLG0018771','1267000','1267000','0','1267000','0','kasirbip','2026-11-10 13:44:35','FJ-261110-0011','DP-04708','1260000'); 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-10','FJ-261110-0012','2026-11-10','13:44:35','KUR','1267000','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-261110-0011','2026-11-10','2026-11-10 13:44:35','PENJUALAN : FJ-261110-0012','.','TBC','7000','7000','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-261110-0012','D','2026-11-10','13:44:35','TBC','PENJUALAN','FJ-261110-0012','30822914464','7000','30822921464','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='127000' WHERE no_faktur_jual='FJ-261110-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-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-05160','DEW','1','PLD','WEDRING','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','sz cwo 19','gf vintage : Devvy 11.01.27...','express 200.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0012','2026-11-10','2026-11-10 13:51:19','PESANAN : DP-05160','-','TBC','1800000','1800000'); 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-261110-0013','D','2026-11-10','13:51:19','TBC','PESANAN','DP-05160','30822921464','1800000','30824721464','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-05160','2026-11-10','2026-11-10','13:51:19','PLG0018772','DEW','2026-11-18','jogja','2026-11-10 13:51:19','4.000','0','0','0','1800000','0','800000','2200000','2200000','400000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','14:21:17'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-10 ','15:02:33'); 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-261110-0013','kasir','1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-ZHBE-126-0','THIFA CINCIN MAS RG ','','3.690','1','84.00','7225000','0','0','17800','7225000','0','0','0','7225000','FIR','00046484','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZHBE-126-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.690',berat_jual_asli=berat_jual_asli+'3.690',stock_jual='1',berat_akhir=berat_akhir-'3.690',berat_akhir_asli=berat_akhir_asli-'3.690',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='TFCMR-ZHBE-126-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-261110-0013','2026-11-10','3.690','2026-11-10','15:04:56','PLG0018773','7225000','7225000','0','7225000','0','kasir','2026-11-10 15:04:55','FJ-261110-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-10','FJ-261110-0013','2026-11-10','15:04:56','FIR','7225000','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-261110-0013','2026-11-10','2026-11-10 15:04:55','PENJUALAN : FJ-261110-0013','.','TBC','7225000','7225000','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-261110-0014','D','2026-11-10','15:04:56','TBC','PENJUALAN','FJ-261110-0013','30824721464','7225000','30831946464','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='7225000' WHERE no_faktur_jual='FJ-261110-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-05161','ARA','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','1050000','0','1050000','PERMATA MENYESUAIKAN','SIZE 8 GRF: ?? 23-12-26 ?? (TIMES NEW)','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-261110-0014','2026-11-10','2026-11-10 15:08:26','PESANAN : DP-05161','-','TBC','1050000','1050000'); 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-261110-0015','D','2026-11-10','15:08:26','TBC','PESANAN','DP-05161','30831946464','1050000','30832996464','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-05161','2026-11-10','2026-11-10','15:08:26','PLG0018774','ARA','2026-12-03','sby','2026-11-10 15:08:26','2.000','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-10 ','15:39:31'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-10 ','16:02:51'); 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-261110-0014','kasirbip','1',' PLBDG-0017','TOKO','BIPPLD','PLBDG-ZKXF-9-0','CINCIN PALADIUM YL01 PLBDG-00176 ','','2.260','1','17.00','508000','0','0','17800','1291000','0','0','0','1291000','SULIS','00049060','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZKXF-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PLBDG-ZKXF-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-261110-0014','2026-11-10','2.260','2026-11-10','16:04:03','PLG0018775','1291000','1291000','0','1291000','0','kasirbip','2026-11-10 16:04:02','FJ-261110-0014','','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-10','FJ-261110-0014','2026-11-10','16:04:03','SULIS','1291000','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-261110-0015','2026-11-10','2026-11-10 16:04:02','PENJUALAN : FJ-261110-0014','.','TBC','1291000','1291000','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-261110-0016','D','2026-11-10','16:04:03','TBC','PENJUALAN','FJ-261110-0014','30832996464','1291000','30834287464','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='1291000' WHERE no_faktur_jual='FJ-261110-0014' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02320','SULIS','1','CC PLD','CROM PUTIH GLOSY SZ 22 5 TAMBAH BAHAN FONT VINTAGE ROTTER','2.000','1','100000','100000'); 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-261110-0016','2026-11-10','2026-11-10 16:06:45','SERVICE : SV-02320','.','TBC','100000','100000','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-261110-0017','D','2026-11-10','16:06:45','TBC','SERVICE','SV-02320','30834287464','100000','30834387464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02320','2026-11-10','2026-11-10','16:06:45','PLG0018776','kasirbip','2026-11-25','kasirbip','2026-11-10 16:06:45','2.000','0','0','0','100000','0','100000','100000','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-05162','KUR','1','PER','WEDDRING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwe 10.5 grf Royan','sz cwo 18 grf Ratna','SR.04 font Vladimir','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-261110-0017','2026-11-10','2026-11-10 16:31:39','PESANAN : DP-05162','.','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-261110-0018','D','2026-11-10','16:31:39','TBC','PESANAN','DP-05162','30834387464','950000','30835337464','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-05162','2026-11-10','2026-11-10','16:31:39','PLG0018777','KUR','2026-12-01','kasirbip','2026-11-10 16:31:39','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-05163','KUR','1','PER','WEDDRING PROMO','','','4.000','','925.00','1','100000','0','850000','0','850000','sz cwe 19 grf Mochamad Rifki','sz cwo 16 grf Fathimah Azzahra','font Berkshire','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-261110-0018','2026-11-10','2026-11-10 16:54:30','PESANAN : DP-05163','.','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-261110-0019','D','2026-11-10','16:54:30','TBC','PESANAN','DP-05163','30835337464','950000','30836287464','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-05163','2026-11-10','2026-11-10','16:54:30','PLG0018778','KUR','2026-12-02','kasirbip','2026-11-10 16:54:30','4.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-05164','SULIS','1','PER','WED RING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','permata zircon bulat dan permata oval putih','sz 26.5 putih glosy font yeseva one grf Silvie ....','','500000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0019','2026-11-10','2026-11-10 17:47:32','PESANAN : DP-05164','.','TBC','2000000','2000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261110-0020','D','2026-11-10','17:47:32','TBC','PESANAN','DP-05164','30836287464','2000000','30838287464','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-05164','2026-11-10','2026-11-10','17:47:32','PLG0018779','SULIS','2026-12-09','kasirbip','2026-11-10 17:47:32','4.000','0','0','0','2000000','0','0','2000000','2000000','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-05165','SULIS','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','1000000','2225000','sz 12.5 putih glosy 25 zircon','font yeseva one grf Rizky ....','rangka permata zircon tengah seperti model kanan','250000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0020','2026-11-10','2026-11-10 17:50:02','PESANAN : DP-05165','.','TBC','1980000','1980000'); 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-261110-0021','D','2026-11-10','17:50:02','TBC','PESANAN','DP-05165','30838287464','1980000','30840267464','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-05165','2026-11-10','2026-11-10','17:50:02','PLG0018780','SULIS','2026-12-09','kasirbip','2026-11-10 17:50:02','3.500','0','0','0','1980000','0','1000000','2475000','2475000','495000'); DELETE FROM tm_berlian WHERE kode_barang='TFGRP-ZKXB-21-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 ('TFGRP-ZKXB-21-0','00048839','00048839','THIFA GELANG RANTAI PUTIH ','THIFA GELANG RANTAI PUTIH','','','5001500','5001500',' 0','0','kasir','2026-11-10 17:55:32'); UPDATE tm_barang SET nama_barang='THIFA GELANG RANTAI PUTIH' ,nama_atribut='' ,kode_intern='TFGRP75-76% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFGRP-ZKXB-21-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-261110-0015','kasir','1',' TFGRP75-76','TOKO','TFGLR','TFGRP-ZKXB-21-0','THIFA GELANG RANTAI PUTIH','','2.880','1','76.00','5102000','0','0','17800','5400000','0','0','0','5400000','FAISAL','00048839','TFGRP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-ZKXB-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.880',berat_jual_asli=berat_jual_asli+'2.880',stock_jual='1',berat_akhir=berat_akhir-'2.880',berat_akhir_asli=berat_akhir_asli-'2.880',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='TFGRP-ZKXB-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-261110-0015','2026-11-10','2.880','2026-11-10','17:56:48','PLG0018781','5400000','5400000','0','5400000','0','kasir','2026-11-10 17:56:47','FJ-261110-0015','','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-10','FJ-261110-0015','2026-11-10','17:56:48','FAISAL','5400000','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-261110-0021','2026-11-10','2026-11-10 17:56:47','PENJUALAN : FJ-261110-0015','.','TBC','5400000','5400000','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-261110-0022','D','2026-11-10','17:56:48','TBC','PENJUALAN','FJ-261110-0015','30840267464','5400000','30845667464','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='5400000' WHERE no_faktur_jual='FJ-261110-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0014'; 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-05166','PUT','1','PER','WEDDRING','','','4.000','','925.00','1','100000','0','850000','0','850000','sz 20 crom putih doff semprot','grf Amel .... Ari font Brush','mata di hilang kan lebar di buat 5mili','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-261110-0022','2026-11-10','2026-11-10 18:02:36','PESANAN : DP-05166','.','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-261110-0023','D','2026-11-10','18:02:36','TBC','PESANAN','DP-05166','30845667464','850000','30846517464','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-05166','2026-11-10','2026-11-10','18:02:36','PLG0018782','PUT','2026-12-07','kasirbip','2026-11-10 18:02:36','4.000','0','0','0','850000','0','0','850000','850000','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-261110-0016','kasir','1',' PLDMM-0005','TOKO','MMPLD','PLDMM-ZKXF-6-0','CINCIN PALADIUM YL01 PLDMM-00057 ','','2.430','1','17.00','546000','0','0','17800','1650000','0','0','0','1650000','ASRI','00049057','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZKXF-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PLDMM-ZKXF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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-261110-0016','2026-11-10','2.430','2026-11-10','18:23:35','PLG0018783','1650000','1650000','0','1650000','0','kasir','2026-11-10 18:23:34','FJ-261110-0016','','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-10','FJ-261110-0016','2026-11-10','18:23:35','ASRI','1650000','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-261110-0023','2026-11-10','2026-11-10 18:23:34','PENJUALAN : FJ-261110-0016','.','TBC','1650000','1650000','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-261110-0024','D','2026-11-10','18:23:35','TBC','PENJUALAN','FJ-261110-0016','30846517464','1650000','30848167464','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='1650000' WHERE no_faktur_jual='FJ-261110-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-261110-0017','kasirbip','1',' PLBDG-0017','TOKO','BIPPLD','PLBDG-ZKXF-8-0','CINCIN PALADIUM YL01 PLBDG-00175 ','','1.970','1','17.00','443000','0','0','17800','1189500','0','0','0','1189500','SAL','00049059','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZKXF-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PLBDG-ZKXF-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-261110-0017','2026-11-10','1.970','2026-11-10','18:25:15','PLG0018784','1189500','1189500','0','1189500','0','kasirbip','2026-11-10 18:25:15','FJ-261110-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-10','FJ-261110-0017','2026-11-10','18:25:15','SAL','1189500','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-261110-0024','2026-11-10','2026-11-10 18:25:15','PENJUALAN : FJ-261110-0017','.','TBC','1189500','1189500','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-261110-0025','D','2026-11-10','18:25:15','TBC','PENJUALAN','FJ-261110-0017','30848167464','1189500','30849356964','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='1189500' WHERE no_faktur_jual='FJ-261110-0017' 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-05167','VAN','1','GOLD','WEDDRING WANITA','','','3.000','','75.00','1','2285000','2200000','0','800000','7400000','SIZE:12 PERMATA 3','GRF: ALI FONT: HURUF ARAB','FINISHING: ROSE GOLD GLOSSY','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0025','2026-11-10','2026-11-10 18:31:11','PESANAN : DP-05167','-','TBC','5200000','5200000'); 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-261110-0026','D','2026-11-10','18:31:11','TBC','PESANAN','DP-05167','30849356964','5200000','30854556964','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-05167','2026-11-10','2026-11-10','18:31:11','PLG0018785','VAN','2026-12-05','sby','2026-11-10 18:31:11','3.000','0','0','0','5200000','0','800000','7430000','7430000','2230000'); 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-05168','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz cwe 10 crom putih glosy','grf Ilham ..... font Brush','','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-261110-0026','2026-11-10','2026-11-10 18:59:02','PESANAN : DP-05168','.','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-261110-0027','D','2026-11-10','18:59:02','TBC','PESANAN','DP-05168','30854556964','950000','30855506964','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-05168','2026-11-10','2026-11-10','18:59:02','PLG0018786','PUT','2026-12-04','kasirbip','2026-11-10 18:59:02','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-05169','PUT','1','PER','WEDDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 13 crom putih doff semprot','grf Itik .... font Brush','','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-261110-0027','2026-11-10','2026-11-10 19:00:51','PESANAN : DP-05169','.','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-261110-0028','D','2026-11-10','19:00:51','TBC','PESANAN','DP-05169','30855506964','850000','30856356964','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-05169','2026-11-10','2026-11-10','19:00:51','PLG0018787','PUT','2026-12-04','kasirbip','2026-11-10 19:00:51','2.500','0','0','0','850000','0','0','850000','850000','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-05170','DIL','1','PLD','WEDD RING PRIA','','','4.500','','25.00','1','1200000','550000','0','800000','3275000','PERMATA 1 BUTIR','SIZE 17 GRF: ?? BELLA ?? (BERKSHIRE) - KAPITAL SEMUA','PUTIH GLOSSY MIX KUNING GLOSSY (DETAIL WA)','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261110-0028','2026-11-10','2026-11-10 19:08:28','PESANAN : DP-05170','-','TBC','2200000','2200000'); 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-261110-0029','D','2026-11-10','19:08:28','TBC','PESANAN','DP-05170','30856356964','2200000','30858556964','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-05170','2026-11-10','2026-11-10','19:08:28','PLG0018788','DIL','2026-12-05','sby','2026-11-10 19:08:28','4.500','0','0','0','2200000','0','800000','3285000','3285000','1085000'); 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-261110-0018','sby','1',' DP-04505SB','TOKO','SBYPSN','PSPRT-ZJBI-12-0','CINCIN PERAK ','','2.500','1','100.00','255000','0','0','17800','850000','0','0','0','850000','DIL','00048738','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBI-12-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-10' AND kode_barang='PSPRT-ZJBI-12-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-261110-0018','2026-11-10','2.500','2026-11-10','19:24:10','PLG0018789','850000','850000','0','850000','0','sby','2026-11-10 19:24:09','FJ-261110-0018','DP-04505','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-10','FJ-261110-0018','2026-11-10','19:24:10','DIL','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-261110-0018' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-10 ','19:27:55'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02321','SAL','1','CCN EMAS DAN PER','CWE SZ 9 GAUSAH DI CROM BERAT AKHIR TULIS DI KERTAS POTONGAN KEMBALI KE CUSTOMER CWO PUTIH DOFF AMPLAS FONT VLADIMIR CCN WANITA BERAT AWAL 2 470','4.000','1','150000','150000'); 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-261110-0029','2026-11-10','2026-11-10 19:28:42','SERVICE : SV-02321','.','TBC','150000','150000','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-261110-0030','D','2026-11-10','19:28:42','TBC','SERVICE','SV-02321','30858556964','150000','30858706964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02321','2026-11-10','2026-11-10','19:28:42','PLG0018790','kasirbip','2026-11-26','kasirbip','2026-11-10 19:28:42','4.000','0','0','0','150000','0','150000','150000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-10 ','19:29:02'); 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-261110-0019','kasirbip','1',' 800K-13-00','TOKO','DUPERBDG','LXPER-ZBBC-33-0','CINCIN SILVER 925 ','','2.610','1','100.00','267000','0','0','17800','900000','0','0','0','900000','KUR','00041694','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.610',berat_jual_asli=berat_jual_asli+'2.610',stock_jual='1',berat_akhir=berat_akhir-'2.610',berat_akhir_asli=berat_akhir_asli-'2.610',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='LXPER-ZBBC-33-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-261110-0019','2026-11-10','2.610','2026-11-10','19:49:02','PLG0018791','900000','900000','0','900000','0','kasirbip','2026-11-10 19:49:01','FJ-261110-0019','','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-10','FJ-261110-0019','2026-11-10','19:49:02','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-261110-0030','2026-11-10','2026-11-10 19:49:01','PENJUALAN : FJ-261110-0019','.','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-261110-0031','D','2026-11-10','19:49:02','TBC','PENJUALAN','FJ-261110-0019','30858706964','900000','30859606964','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-261110-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-261110-0020','sby','1',' DP-04607SB','TOKO','SBYPSN','PSGT-ZKXF-54-0','CINCIN EMAS ','','2.170','1','45.00','2242000','0','0','17800','3908000','0','0','0','3908000','DIL','00049105','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKXF-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-11-10' AND kode_barang='PSGT-ZKXF-54-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-261110-0020','2026-11-10','2.170','2026-11-10','19:49:50','PLG0018792','3908000','3908000','0','3908000','0','sby','2026-11-10 19:49:49','FJ-261110-0020','DP-04607','2200000'); 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-10','FJ-261110-0020','2026-11-10','19:49:50','DIL','3908000','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-261110-0031','2026-11-10','2026-11-10 19:49:49','PENJUALAN : FJ-261110-0020','','TBC','1708000','1708000','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-261110-0032','D','2026-11-10','19:49:50','TBC','PENJUALAN','FJ-261110-0020','30859606964','1708000','30861314964','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='1708000' WHERE no_faktur_jual='FJ-261110-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-05171','DEW','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','850000','0','850000','sz cwo 14 sz cwe 19 (oversize cwe)','gf vintage : cwe : Witanto cwo : Riza','','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-261110-0032','2026-11-10','2026-11-10 19:50:44','PESANAN : DP-05171','-','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-261110-0033','D','2026-11-10','19:50:44','TBC','PESANAN','DP-05171','30861314964','950000','30862264964','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-05171','2026-11-10','2026-11-10','19:50:44','PLG0018793','DEW','2026-12-05','jogja','2026-11-10 19:50:44','4.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-10 ','19:51:04'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261110-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261110-0020'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-11','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-11'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-10'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-10'; 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-10' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-10'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-10'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-10'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-10'; 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-11' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-10' 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-261111-0001','D','2026-11-11','21:09:09','TBC','SALDO AWAL','SALDO AWAL','0','30862264964','30862264964'); 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-261111-0001','D','2026-11-11','21:09:09','SHO','SALDO AWAL','SALDO AWAL','0','145535650','145535650'); 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-261111-0001','D','2026-11-11','21:09:09','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','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-261111-0001','D','2026-11-11','21:09:09','BCD','SALDO AWAL','SALDO AWAL','0','1468857500','1468857500'); UPDATE tp_system SET tgl_system='2026-11-11'; UPDATE tm_credit_card SET nama_customer='-',no_ktp='',alamat1='' ,alamat2='' ,kota= '' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-11-10 21:28:31' WHERE id_card = '-'; 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-05172','ARA','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE 19 GRF: Moses ?? Minda (VINTAGE)','KUNING GLOSSY FULL MIX PUTIH 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-261110-0033','2026-11-10','2026-11-10 21:28:39','PESANAN : DP-05172','-','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-261110-0001','D','2026-11-10','21:28:39','TBC','PESANAN','DP-05172','0','900000','900000','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-05172','2026-11-10','2026-11-10','21:28:39','PLG0018794','ARA','2026-12-03','sby','2026-11-10 21:28:39','3.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-05173','ARA','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','1000000','0','1000000','PERMATA MENYESUAIKAN','SIZE 9 GRF: Moses ?? Minda (VINTAGE)','KUNING GLOSSY FULL','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-261110-0034','2026-11-10','2026-11-10 21:31:53','PESANAN : DP-05173','-','TBC','1000000','1000000'); 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-261110-0002','D','2026-11-10','21:31:53','TBC','PESANAN','DP-05173','900000','1000000','1900000','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-05173','2026-11-10','2026-11-10','21:31:53','PLG0018795','ARA','2026-12-03','sby','2026-11-10 21:31:53','2.000','0','0','0','1000000','0','0','1000000','1000000','0');