INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-29 ','09:23:33'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','09:44:28'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','09:57:54'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-29','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-28'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-28'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-28'; 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-05-28' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-28'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-28'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-28'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-28'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; UPDATE tt_barang_saldo SET tanggal= '2026-05-29' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-28' 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-260529-0001','D','2026-05-29','10:04:49','TBC','SALDO AWAL','SALDO AWAL','0','22942429514','22942429514'); 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-260529-0001','D','2026-05-29','10:04:49','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650'); 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-260529-0001','D','2026-05-29','10:04:49','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); 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-260529-0001','D','2026-05-29','10:04:49','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-260529-0001','D','2026-05-29','10:04:49','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-260529-0001','D','2026-05-29','10:04:49','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-260529-0001','D','2026-05-29','10:04:49','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); 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-260529-0001','D','2026-05-29','10:04:49','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-260529-0001','D','2026-05-29','10:04:49','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-260529-0001','D','2026-05-29','10:04:49','','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-260529-0001','D','2026-05-29','10:04:49','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-260529-0001','D','2026-05-29','10:04:49','BCD','SALDO AWAL','SALDO AWAL','0','1389903500','1389903500'); UPDATE tp_system SET tgl_system='2026-05-29'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','10:10:21'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-29 ','10:12:26'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','10:17:40'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260529-0001','1','PSPRT-ZEBH-2-0','1','3.400','3.400','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBH-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBH-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBH-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 10:18:03' WHERE kode_barang='PSPRT-ZEBH-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBH-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-29 10:18:03','TOKO','MMPSN','PSPRT','PSPRT-ZEBH-2-0','1','3.400','3.400','1','3.400','3.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBH-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0001','1','PSPRT-ZEBH-3-0','1','3.220','3.220','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBH-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBH-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBH-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 10:18:03' WHERE kode_barang='PSPRT-ZEBH-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBH-3-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-05-29 10:18:03','TOKO','MMPSN','PSPRT','PSPRT-ZEBH-3-0','1','3.220','3.220','1','3.220','3.220','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBH-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0001','1','PSPRT-ZEBH-4-0','1','2.110','2.110','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBH-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBH-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBH-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 10:18:03' WHERE kode_barang='PSPRT-ZEBH-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBH-4-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-05-29 10:18:03','TOKO','MMPSN','PSPRT','PSPRT-ZEBH-4-0','1','2.110','2.110','1','2.110','2.110','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBH-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0001','1','PSPRT-ZEBH-5-0','1','1.800','1.800','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBH-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBH-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBH-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 10:18:03' WHERE kode_barang='PSPRT-ZEBH-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBH-5-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-05-29 10:18:03','TOKO','MMPSN','PSPRT','PSPRT-ZEBH-5-0','1','1.800','1.800','1','1.800','1.800','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBH-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260529-0001','2026-05-29','10:17','10.530','kasir','2026-05-29 10:18:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','10:23:34'); UPDATE tt_service_head SET tgl_selesai='2026-05-29', status ='DONE' WHERE no_service='SV-02069'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02069'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-29', status ='CLOS' WHERE no_service='SV-02069'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02069'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-29 ','10:35:15'); 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-260529-0001','kasirbip','1',' DP-02118BI','TOKO','BIPPSN','PSGT-ZEBB-16-0','CINCIN EMAS ','','1.910','1','45.00','2149000','0','0','17800','3785000','0','0','0','3785000','GIN','00043728','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBB-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSGT-ZEBB-16-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-260529-0001','2026-05-29','1.910','2026-05-29','10:38:55','PLG0011480','3785000','3785000','0','3785000','0','kasirbip','2026-05-29 10:38:54','FJ-260529-0001','DP-02118','3736000'); 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-05-29','FJ-260529-0001','2026-05-29','10:38:55','GIN','3785000','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-260529-0001','2026-05-29','2026-05-29 10:38:54','PENJUALAN : FJ-260529-0001','.','TBC','49000','49000','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-260529-0002','D','2026-05-29','10:38:55','TBC','PENJUALAN','FJ-260529-0001','22942429514','49000','22942478514','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='49000' WHERE no_faktur_jual='FJ-260529-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0002','kasirbip','1',' DP-02208DU','TOKO','DUPSN','PSPLT-ZEBF-15-0','CINCIN PALADIUM YL-10 ','','4.160','1','57.00','3131000','0','0','17800','4910000','0','0','0','4910000','PUT','00043805','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEBF-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0002','2026-05-29','4.160','2026-05-29','10:42:13','PLG0011481','4910000','4910000','0','4910000','0','kasirbip','2026-05-29 10:42:12','FJ-260529-0002','DP-02208','3800000'); 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-05-29','FJ-260529-0002','2026-05-29','10:42:13','PUT','4910000','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-260529-0002','2026-05-29','2026-05-29 10:42:12','PENJUALAN : FJ-260529-0002','.','TBC','1110000','1110000','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-260529-0003','D','2026-05-29','10:42:13','TBC','PENJUALAN','FJ-260529-0002','22942478514','1110000','22943588514','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='1110000' WHERE no_faktur_jual='FJ-260529-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-260529-0003','kasirbip','1',' DP-02209DU','TOKO','DUPSN','PSPLT-ZEBF-14-0','CINCIN PALADIUM ','','2.790','1','57.00','2100000','0','0','17800','4180000','0','0','0','4180000','PUT','00043804','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEBF-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0003','2026-05-29','2.790','2026-05-29','10:43:02','PLG0011482','4180000','4180000','0','4180000','0','kasirbip','2026-05-29 10:43:01','FJ-260529-0003','DP-02209','3112000'); 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-05-29','FJ-260529-0003','2026-05-29','10:43:02','PUT','4180000','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-260529-0003','2026-05-29','2026-05-29 10:43:01','PENJUALAN : FJ-260529-0003','.','TBC','1068000','1068000','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-260529-0004','D','2026-05-29','10:43:02','TBC','PENJUALAN','FJ-260529-0003','22943588514','1068000','22944656514','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='1068000' WHERE no_faktur_jual='FJ-260529-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0003'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02089','SAL','1','CC SILVER','RESIZE MENJADI SIZE 14 PUTIH GLOSSY COMB DOFF SEMPROT GRF JGN HILANG','2.000','1','50000','50000'); 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-260529-0004','2026-05-29','2026-05-29 10:58:33','SERVICE : SV-02089','.','TBC','50000','50000','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-260529-0005','D','2026-05-29','10:58:33','TBC','SERVICE','SV-02089','22944656514','50000','22944706514','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-02089','2026-05-29','2026-05-29','10:58:33','PLG0011483','kasirbip','2026-06-14','kasirbip','2026-05-29 10:58:33','2.000','0','0','0','50000','0','50000','50000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','11:12:50'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-29 ','11:46:24'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260529-0002','1','PSPRT-ZEBH-21-0','1','1.580','1.580','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBH-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBH-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBH-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-29 11:59:52' WHERE kode_barang='PSPRT-ZEBH-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBH-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-05-29 11:59:52','TOKO','DUPSN','PSPRT','PSPRT-ZEBH-21-0','1','1.580','1.580','1','1.580','1.580','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBH-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBH-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260529-0002','2026-05-29','11:59','1.580','kasirbip','2026-05-29 11:59:51'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-29 ','12:10:57'); 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-02259','DIL','1','GOLD','WEDD RING','','','4.000','','50.00','1','2420000','2000000','0','850000','8850000','PERMATA ZIRCON 14 BUTIR','SIZE 14 GRF : Antonius (yaseva one)','crom putih (emas putih)','140000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0005','2026-05-29','2026-05-29 12:15:27','PESANAN : DP-02259','-','TBC','6200000','6200000'); 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-260529-0006','D','2026-05-29','12:15:27','TBC','PESANAN','DP-02259','22944706514','6200000','22950906514','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-02259','2026-05-29','2026-05-29','12:15:27','PLG0011484','DIL','2026-06-01','sby','2026-05-29 12:15:27','4.000','0','0','0','6200000','0','850000','8990000','8990000','2790000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-29 ','12:15:49'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-29 ','12:55:33'); 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-02260','DIL','1','GOLD','WEDD RING CUSTOM','','','2.500','','37.50','1','2420000','1500000','0','1000000','4750000','PERMATA 1 OVAL MAISSONATE . PERMATA ZIRCON 38 BUTIR','SIZE 14 . GRF : Septa ?? Nadea (berkshire)','putih (emas putih)','1130000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0006','2026-05-29','2026-05-29 13:03:20','PESANAN : DP-02260','-','TBC','3600000','3600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260529-0007','D','2026-05-29','13:03:20','TBC','PESANAN','DP-02260','22950906514','3600000','22954506514','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-02260','2026-05-29','2026-05-29','13:03:20','PLG0011485','DIL','2026-06-03','sby','2026-05-29 13:03:20','2.500','0','0','0','3600000','0','1000000','5880000','5880000','2280000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-29 ','13:06:35'); UPDATE tt_service_head SET tgl_selesai='2026-05-29', status ='DONE' WHERE no_service='SV-02066'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02066'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-29', status ='CLOS' WHERE no_service='SV-02066'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02066'; 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-02261','SAL','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','sz 28 3 zircon putih glosy font vladimir','berat jangan di atas 4 grf Wilma','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0007','2026-05-29','2026-05-29 14:25:49','PESANAN : DP-02261','.','TBC','1680000','1680000'); 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-260529-0008','D','2026-05-29','14:25:49','TBC','PESANAN','DP-02261','22954506514','1680000','22956186514','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-02261','2026-05-29','2026-05-29','14:25:49','PLG0011486','SAL','2026-06-29','kasirbip','2026-05-29 14:25:49','4.000','0','0','0','1680000','0','700000','2100000','2100000','420000'); 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-260529-0004','kasirbip','1',' DP-02040BI','TOKO','BIPPSN','PSPLT-ZEAD-7-0','CINCIN PALADIUM ','','1.670','1','17.00','376000','0','0','17800','1461000','0','0','0','1461000','KUR','00043565','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAD-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEAD-7-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-260529-0004','2026-05-29','1.670','2026-05-29','14:27:13','PLG0011487','1461000','1461000','0','1461000','0','kasirbip','2026-05-29 14:27:13','FJ-260529-0004','DP-02040','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-05-29','FJ-260529-0004','2026-05-29','14:27:13','KUR','1461000','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-260529-0008','2026-05-29','2026-05-29 14:27:13','PENJUALAN : FJ-260529-0004','.','TBC','281000','281000','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-260529-0009','D','2026-05-29','14:27:13','TBC','PENJUALAN','FJ-260529-0004','22956186514','281000','22956467514','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='281000' WHERE no_faktur_jual='FJ-260529-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-260529-0005','kasirbip',' 1',' DP-02039BI','TOKO','BIPPSN','PSPRT-ZEBX-3-0','CINCIN PERAK ','','3.140','1','100.00','321000','0','0','17800','900000','0','0','0','900000','KUR','00043648','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBX-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEBX-3-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-260529-0005','2026-05-29','3.140','2026-05-29','14:27:13','PLG0011488','900000','900000','0','900000','0','kasirbip','2026-05-29 14:27:13','FJ-260529-0004','DP-02039','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-05-29','FJ-260529-0005','2026-05-29','14:27:13','KUR','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='281000' WHERE no_faktur_jual='FJ-260529-0005' 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-02262','SAL','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','1000000','1700000','sz 11 putih glosy 14 zircon','font vladimir grf Aldi','','140000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0009','2026-05-29','2026-05-29 14:29:44','PESANAN : DP-02262','.','TBC','1472000','1472000'); 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-260529-0010','D','2026-05-29','14:29:44','TBC','PESANAN','DP-02262','22956467514','1472000','22957939514','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-02262','2026-05-29','2026-05-29','14:29:44','PLG0011489','SAL','2026-06-29','kasirbip','2026-05-29 14:29:44','2.000','0','0','0','1472000','0','1000000','1840000','1840000','368000'); 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-260529-0006','kasir','1',' TFGRP75-84','TOKO','TFGLR','TFGRP-YLXD-52-0','THIFA GELANG RANTAI PUTIH ','','1.810','1','84.00','3754000','0','0','17800','3925000','0','0','0','3925000','IQB','00040232','TFGRP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-YLXD-52-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='TFGRP-YLXD-52-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-260529-0006','2026-05-29','1.810','2026-05-29','14:35:52','PLG0011490','3925000','3925000','0','3925000','0','kasir','2026-05-29 14:35:51','FJ-260529-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-29','FJ-260529-0006','2026-05-29','14:35:52','IQB','3925000','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-260529-0010','2026-05-29','2026-05-29 14:35:51','PENJUALAN : FJ-260529-0006','.','TBC','3925000','3925000','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-260529-0011','D','2026-05-29','14:35:52','TBC','PENJUALAN','FJ-260529-0006','22957939514','3925000','22961864514','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='3925000' WHERE no_faktur_jual='FJ-260529-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0006'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0007','kasirbip','1',' DP-02061DU','TOKO','DUPSN','PSPLT-ZEBB-23-0','CINCIN PALADIUM ','','1.920','1','17.00','432000','0','0','17800','1456000','0','0','0','1456000','KUR','00043735','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBB-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEBB-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0007','2026-05-29','1.920','2026-05-29','14:54:50','PLG0011491','1456000','1456000','0','1456000','0','kasirbip','2026-05-29 14:54:50','FJ-260529-0007','DP-02061','1184000'); 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-05-29','FJ-260529-0007','2026-05-29','14:54:50','KUR','1456000','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-260529-0011','2026-05-29','2026-05-29 14:54:50','PENJUALAN : FJ-260529-0007','.','TBC','272000','272000','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-260529-0012','D','2026-05-29','14:54:50','TBC','PENJUALAN','FJ-260529-0007','22961864514','272000','22962136514','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='272000' WHERE no_faktur_jual='FJ-260529-0007' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0008','kasirbip','1',' DP-02062DU','TOKO','DUPSN','PSPLT-ZEBX-10-0','CINCIN PALADIUM ','','3.010','1','17.00','676000','0','0','17800','1653000','0','0','0','1653000','KUR','00043655','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBX-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEBX-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0008','2026-05-29','3.010','2026-05-29','14:55:46','PLG0011492','1653000','1653000','0','1653000','0','kasirbip','2026-05-29 14:55:45','FJ-260529-0008','DP-02062','1320000'); 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-05-29','FJ-260529-0008','2026-05-29','14:55:46','KUR','1653000','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-260529-0012','2026-05-29','2026-05-29 14:55:45','PENJUALAN : FJ-260529-0008','.','TBC','333000','333000','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-260529-0013','D','2026-05-29','14:55:46','TBC','PENJUALAN','FJ-260529-0008','22962136514','333000','22962469514','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='333000' WHERE no_faktur_jual='FJ-260529-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0008'; 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-260529-0009','kasir','1',' DP-02001MM','TOKO','MMPSN','PSGT-ZEXF-4-0','CINCIN EMAS ','','1.780','1','83.00','3617000','0','0','17800','5002000','0','0','0','5002000','ALIKA','00043298','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEXF-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSGT-ZEXF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0009','2026-05-29','1.780','2026-05-29','16:14:55','PLG0011493','5002000','5002000','0','5002000','0','kasir','2026-05-29 16:14:55','FJ-260529-0009','DP-02001','4424000'); 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-05-29','FJ-260529-0009','2026-05-29','16:14:55','ALIKA','5002000','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-260529-0013','2026-05-29','2026-05-29 16:14:55','PENJUALAN : FJ-260529-0009','0','TBC','578000','578000','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-260529-0014','D','2026-05-29','16:14:55','TBC','PENJUALAN','FJ-260529-0009','22962469514','578000','22963047514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='578000' WHERE no_faktur_jual='FJ-260529-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0010','kasir',' 1',' DP-02002MM','TOKO','MMPSN','PSPLT-ZEXG-1-0','CINCIN PALADIUM ','','2.390','1','32.00','1010000','0','0','17800','1895000','0','0','0','1895000','ALIKA','00043353','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEXG-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPLT-ZEXG-1-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-260529-0010','2026-05-29','2.390','2026-05-29','16:14:55','PLG0011494','1895000','1895000','0','1895000','0','kasir','2026-05-29 16:14:55','FJ-260529-0009','DP-02002','1760000'); 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-05-29','FJ-260529-0010','2026-05-29','16:14:55','ALIKA','1895000','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-260529-0014','2026-05-29','2026-05-29 16:14:55','PENJUALAN : FJ-260529-0010','0','TBC','135000','135000','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-260529-0015','D','2026-05-29','16:14:55','TBC','PENJUALAN','FJ-260529-0010','22963047514','135000','22963182514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='713000' WHERE no_faktur_jual='FJ-260529-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-02263','FIR','1','PER','CINCIN SR 01 SILVER','','','1.000','','925.00','1','100000','0','950000','0','950000','cwe size 15 grf Aji S. model sr 01','cwo size 17 grf Sessy S. model yl 01 putih doff amplas','cwe doff semprot setengah','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0015','2026-05-29','2026-05-29 16:21:48','PESANAN : DP-02263','.','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-260529-0016','D','2026-05-29','16:21:48','TBC','PESANAN','DP-02263','22963182514','950000','22964132514','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-02263','2026-05-29','2026-05-29','16:21:48','PLG0011495','FIR','2026-06-12','kasir','2026-05-29 16:21:48','1.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','16:22:36'); 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-20260529-0003','1','PSGT-ZEBI-1-0','1','3.170','3.170','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 16:22:49' WHERE kode_barang='PSGT-ZEBI-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-29 16:22:49','TOKO','MMPSN','PSGT','PSGT-ZEBI-1-0','1','3.170','3.170','1','3.170','3.170','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBI-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0003','1','PSPRT-ZEBI-2-0','1','3.510','3.510','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 16:22:49' WHERE kode_barang='PSPRT-ZEBI-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-29 16:22:49','TOKO','MMPSN','PSPRT','PSPRT-ZEBI-2-0','1','3.510','3.510','1','3.510','3.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBI-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0003','1','PSPRT-ZEBI-3-0','1','3.140','3.140','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 16:22:49' WHERE kode_barang='PSPRT-ZEBI-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-3-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-05-29 16:22:49','TOKO','MMPSN','PSPRT','PSPRT-ZEBI-3-0','1','3.140','3.140','1','3.140','3.140','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBI-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0003','1','PSGT-ZEBI-43-0','1','2.600','2.600','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 16:22:49' WHERE kode_barang='PSGT-ZEBI-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-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-05-29 16:22:49','TOKO','MMPSN','PSGT','PSGT-ZEBI-43-0','1','2.600','2.600','1','2.600','2.600','57.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBI-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' 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-20260529-0003','1','PSPLT-ZEBI-44-0','1','3.450','3.450','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBI-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-44-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBI-44-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBI-44-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-29 16:22:49' WHERE kode_barang='PSPLT-ZEBI-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBI-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-05-29 16:22:49','TOKO','MMPSN','PSPLT','PSPLT-ZEBI-44-0','1','3.450','3.450','1','3.450','3.450','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZEBI-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-44-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-29' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260529-0003','2026-05-29','16:22','15.870','kasir','2026-05-29 16:22:48'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','16:25:03'); 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-260529-0011','kasirbip','1',' DP-02099BI','TOKO','BIPPSN','PSPRT-ZEAI-2-0','CINCIN PERAK SR-03 YL-01 ','','3.480','1','100.00','355000','0','0','17800','1050000','0','0','0','1050000','GIN','00043629','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEAI-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.480',berat_jual_asli=berat_jual_asli+'3.480',stock_jual='1',berat_akhir=berat_akhir-'3.480',berat_akhir_asli=berat_akhir_asli-'3.480',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEAI-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-260529-0011','2026-05-29','3.480','2026-05-29','17:06:59','PLG0011496','1050000','1050000','0','1050000','0','kasirbip','2026-05-29 17:06:59','FJ-260529-0011','DP-02099','1050000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-29','FJ-260529-0011','2026-05-29','17:06:59','GIN','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260529-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0011'; 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-02264','KUR','1','PER','1 BUAH CINCIN','','','2.000','','925.00','1','100000','0','700000','0','700000','exspress 100.000','YL 01 size 15','grf Aliya font vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0016','2026-05-29','2026-05-29 17:24:03','PESANAN : DP-02264','.','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-260529-0017','D','2026-05-29','17:24:03','TBC','PESANAN','DP-02264','22964132514','700000','22964832514','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-02264','2026-05-29','2026-05-29','17:24:03','PLG0011497','KUR','2026-06-09','kasirbip','2026-05-29 17:24:03','2.000','0','0','0','700000','0','0','700000','700000','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-02265','KUR','1','PER','1 BUAH CINCIN','','','2.000','','925.00','1','100000','0','700000','0','700000','exspress 100.000','YL 01 size 15','grf Aliya font vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260529-0017','2026-05-29','2026-05-29 17:24:05','PESANAN : DP-02265','.','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-260529-0018','D','2026-05-29','17:24:05','TBC','PESANAN','DP-02265','22964832514','700000','22965532514','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-02265','2026-05-29','2026-05-29','17:24:05','PLG0011498','KUR','2026-06-09','kasirbip','2026-05-29 17:24:05','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-260529-0012','kasirbip','1',' 800K-20-26','TOKO','BIPPER','PBDG-ZEBB-38-0','CINCIN SILVER 925 ','','2.780','1','100.00','284000','0','0','17800','950000','0','0','0','950000','GIN','00043750','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PBDG-ZEBB-38-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-260529-0012','2026-05-29','2.780','2026-05-29','18:12:20','PLG0011499','950000','950000','0','950000','0','kasirbip','2026-05-29 18:12:19','FJ-260529-0012','','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-05-29','FJ-260529-0012','2026-05-29','18:12:20','GIN','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-260529-0018','2026-05-29','2026-05-29 18:12:19','PENJUALAN : FJ-260529-0012','.','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-260529-0019','D','2026-05-29','18:12:20','TBC','PENJUALAN BERLIAN','FJ-260529-0012','22965532514','950000','22966482514','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-260529-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0012'; UPDATE tt_service_head SET tgl_selesai='2026-05-29', status ='DONE' WHERE no_service='SV-02073'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02073'; UPDATE tt_service_head SET tgl_selesai='2026-05-29', status ='DONE' WHERE no_service='SV-02077'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02077'; UPDATE tt_service_head SET tgl_selesai='2026-05-29', status ='DONE' WHERE no_service='SV-02081'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02081'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-29', status ='CLOS' WHERE no_service='SV-02073'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02073'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-29', status ='CLOS' WHERE no_service='SV-02077'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02077'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-29', status ='CLOS' WHERE no_service='SV-02081'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02081'; 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-02266','PUT','1','PLD','1 BUAH CINCIN','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','Exspress 100.000','size 20 YL01','','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-260529-0019','2026-05-29','2026-05-29 18:23:56','PESANAN : DP-02266','.','TBC','2140000','2140000'); 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-260529-0020','D','2026-05-29','18:23:56','TBC','PESANAN','DP-02266','22966482514','2140000','22968622514','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-02266','2026-05-29','2026-05-29','18:23:56','PLG0011500','PUT','2026-06-07','kasirbip','2026-05-29 18:23:56','3.500','0','0','0','2140000','0','750000','2675000','2675000','535000'); 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-260529-0013','kasir','1',' DP-02134MM','TOKO','MMPSN','PSPRT-ZEBH-2-0','CINCIN PERAK SR-03 YL-01 ','','3.400','1','100.00','347000','0','0','17800','950000','0','0','0','950000','ALIKA','00043807','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBH-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEBH-2-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-260529-0013','2026-05-29','3.400','2026-05-29','18:24:41','PLG0011501','950000','950000','0','950000','0','kasir','2026-05-29 18:24:41','FJ-260529-0013','DP-02134','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-29','FJ-260529-0013','2026-05-29','18:24:41','ALIKA','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260529-0013' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-29 ','18:45:27'); UPDATE tm_sales SET deleted_by = 'kasir',deleted_date = '2026-05-29 18:45:57' WHERE sales_id = 'MIA'; INSERT INTO tm_sales_deleted SELECT * FROM tm_sales WHERE sales_id = 'MIA'; DELETE FROM tm_sales WHERE sales_id= 'MIA'; UPDATE tm_sales SET deleted_by = 'kasir',deleted_date = '2026-05-29 18:46:40' WHERE sales_id = 'RIS'; INSERT INTO tm_sales_deleted SELECT * FROM tm_sales WHERE sales_id = 'RIS'; DELETE FROM tm_sales WHERE sales_id= 'RIS'; UPDATE tm_sales SET deleted_by = 'kasir',deleted_date = '2026-05-29 18:47:16' WHERE sales_id = 'DE'; INSERT INTO tm_sales_deleted SELECT * FROM tm_sales WHERE sales_id = 'DE'; DELETE FROM tm_sales WHERE sales_id= 'DE'; 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-260529-0014','kasirbip','1',' 800K-115-0','TOKO','DUPERBDG','LXPER-ZDBH-30-0','CINCIN SILVER 925 ','','1.180','1','100.00','121000','0','0','17800','900000','0','0','0','900000','KUR','00042846','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDBH-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='LXPER-ZDBH-30-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-260529-0014','2026-05-29','1.180','2026-05-29','19:05:16','PLG0011502','900000','900000','0','900000','0','kasirbip','2026-05-29 19:05:16','FJ-260529-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-05-29','FJ-260529-0014','2026-05-29','19:05:16','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-260529-0020','2026-05-29','2026-05-29 19:05:16','PENJUALAN : FJ-260529-0014','.','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-260529-0021','D','2026-05-29','19:05:16','TBC','PENJUALAN BERLIAN','FJ-260529-0014','22968622514','900000','22969522514','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-260529-0014' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0015','kasirbip',' 1',' 700K-125-0','TOKO','DUPERBDG','LXPER-ZDXI-25-0','CINCIN SILVER 925 ','','1.630','1','100.00','167000','0','0','17800','800000','0','0','0','800000','KUR','00042419','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXI-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='LXPER-ZDXI-25-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-260529-0015','2026-05-29','1.630','2026-05-29','19:05:16','PLG0011503','800000','800000','0','800000','0','kasirbip','2026-05-29 19:05:16','FJ-260529-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-05-29','FJ-260529-0015','2026-05-29','19:05:16','KUR','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260529-0021','2026-05-29','2026-05-29 19:05:16','PENJUALAN : FJ-260529-0015','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260529-0022','D','2026-05-29','19:05:16','TBC','PENJUALAN BERLIAN','FJ-260529-0015','22969522514','800000','22970322514','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='1700000' WHERE no_faktur_jual='FJ-260529-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0015'; 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-260529-0016','kasir','1',' DP-02135MM','TOKO','MMPSN','PSPRT-ZEBH-3-0','CINCIN PERAK SR-03 YL-01 ','','3.220','1','100.00','329000','0','0','17800','950000','0','0','0','950000','RIRIN','00043808','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBH-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEBH-3-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-260529-0016','2026-05-29','3.220','2026-05-29','19:30:40','PLG0011504','950000','950000','0','950000','0','kasir','2026-05-29 19:30:40','FJ-260529-0016','DP-02135','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-29','FJ-260529-0016','2026-05-29','19:30:40','RIRIN','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260529-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-260529-0017','kasirbip','1',' DP-02143DU','TOKO','DUPSN','PSPRT-ZEBH-21-0','CINCIN PERAK ','','1.580','1','100.00','162000','0','0','17800','900000','0','0','0','900000','KUR','00043826','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBH-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEBH-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0017','2026-05-29','1.580','2026-05-29','19:42:37','PLG0011505','900000','900000','0','900000','0','kasirbip','2026-05-29 19:42:37','FJ-260529-0017','DP-02143','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-05-29','FJ-260529-0017','2026-05-29','19:42:37','KUR','900000','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-260529-0017' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260529-0018','kasirbip',' 1',' DP-02144DU','TOKO','DUPSN','PSPRT-ZEBB-4-0','CINCIN PERAK YL-01 ','','1.860','1','100.00','190000','0','0','17800','650000','0','0','0','650000','KUR','00043716','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBB-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-05-29' AND kode_barang='PSPRT-ZEBB-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260529-0018','2026-05-29','1.860','2026-05-29','19:42:37','PLG0011506','650000','650000','0','650000','0','kasirbip','2026-05-29 19:42:37','FJ-260529-0017','DP-02144','650000'); 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-05-29','FJ-260529-0018','2026-05-29','19:42:37','KUR','650000','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-260529-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260529-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260529-0018'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-29 ','20:00:46'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-29 ','20:01:46'); INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02264'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02264'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02264'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260529-0002','K','2026-05-29','20:03:02','kasirbip','PESANAN BATAL','DP-02264','194200','0','194200');