INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','08:18:09'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','08:42:58'); 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-20261106-0001','1','PLDMM-ZKXF-5-0','1','2.300','2.300','TOKO','MMPLD','TOKO','MMPLD'); DELETE FROM tm_barang WHERE kode_barang='PLDMM-ZKXF-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLDMM-ZKXF-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXF-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPLD',tgl_last_beli='2026-11-06 08:43:09' WHERE kode_barang='PLDMM-ZKXF-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLDMM-ZKXF-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-11-06 08:43:09','TOKO','MMPLD','PLDMM','PLDMM-ZKXF-5-0','1','2.300','2.300','1','2.300','2.300','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLDMM-ZKXF-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' 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-20261106-0001','1','PLDMM-ZKXF-6-0','1','2.430','2.430','TOKO','MMPLD','TOKO','MMPLD'); DELETE FROM tm_barang WHERE kode_barang='PLDMM-ZKXF-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLDMM-ZKXF-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXF-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPLD',tgl_last_beli='2026-11-06 08:43:09' WHERE kode_barang='PLDMM-ZKXF-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLDMM-ZKXF-6-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-06 08:43:09','TOKO','MMPLD','PLDMM','PLDMM-ZKXF-6-0','1','2.430','2.430','1','2.430','2.430','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLDMM-ZKXF-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' 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-20261106-0001','1','PLDMM-ZKXF-7-0','1','4.930','4.930','TOKO','MMPLD','TOKO','MMPLD'); DELETE FROM tm_barang WHERE kode_barang='PLDMM-ZKXF-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLDMM-ZKXF-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXF-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPLD',tgl_last_beli='2026-11-06 08:43:09' WHERE kode_barang='PLDMM-ZKXF-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLDMM-ZKXF-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-06 08:43:09','TOKO','MMPLD','PLDMM','PLDMM-ZKXF-7-0','1','4.930','4.930','1','4.930','4.930','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLDMM-ZKXF-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXF-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0001','2026-11-06','08:43','9.660','kasir','2026-11-06 08:43:09'); 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-20261106-0002','1','PSGT-ZKXE-6-0','1','2.640','2.640','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKXE-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKXE-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKXE-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXE-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-06 08:43:26' WHERE kode_barang='PSGT-ZKXE-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKXE-6-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-06 08:43:26','TOKO','MMPSN','PSGT','PSGT-ZKXE-6-0','1','2.640','2.640','1','2.640','2.640','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-ZKXE-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXE-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' 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-20261106-0002','1','PSPLT-ZKXE-7-0','1','4.260','4.260','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXE-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXE-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXE-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXE-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-06 08:43:26' WHERE kode_barang='PSPLT-ZKXE-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXE-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-06 08:43:26','TOKO','MMPSN','PSPLT','PSPLT-ZKXE-7-0','1','4.260','4.260','1','4.260','4.260','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-ZKXE-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXE-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' 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-20261106-0002','1','PSPLT-ZKXE-8-0','1','2.590','2.590','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXE-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXE-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXE-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXE-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-06 08:43:26' WHERE kode_barang='PSPLT-ZKXE-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXE-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-06 08:43:26','TOKO','MMPSN','PSPLT','PSPLT-ZKXE-8-0','1','2.590','2.590','1','2.590','2.590','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-ZKXE-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXE-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-06' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0002','2026-11-06','08:43','9.490','kasir','2026-11-06 08:43:26'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-06 ','09:11:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','09:48:32'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-06 ','10:44:52'); 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-261106-0001','kasirbip','1',' 900K-105 ','TOKO','BIPCMP','BDCM-ZKXB-55-0','CINCIN EMAS ','','1.340','1','45.00','1385000','0','0','17800','2650000','0','0','0','2650000','KUR','00048873','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZKXB-55-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='BDCM-ZKXB-55-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-261106-0001','2026-11-06','1.340','2026-11-06','10:46:46','PLG0018502','2650000','2650000','0','2650000','0','kasirbip','2026-11-06 10:46:46','FJ-261106-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-06','FJ-261106-0001','2026-11-06','10:46:46','KUR','2650000','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-261106-0001','2026-11-06','2026-11-06 10:46:46','PENJUALAN : FJ-261106-0001','.','TBC','2650000','2650000','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-261106-0002','D','2026-11-06','10:46:46','TBC','PENJUALAN','FJ-261106-0001','30531521964','2650000','30534171964','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='2650000' WHERE no_faktur_jual='FJ-261106-0001' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261106-0002','kasirbip',' 1',' 800K-18-27','TOKO','BIPPER','PBDG-ZFAH-54-0','CINCIN SILVER 925 ','','2.590','1','100.00','265000','0','0','17800','900000','0','0','0','900000','KUR','00044567','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAH-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.590',berat_jual_asli=berat_jual_asli+'2.590',stock_jual='1',berat_akhir=berat_akhir-'2.590',berat_akhir_asli=berat_akhir_asli-'2.590',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PBDG-ZFAH-54-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-261106-0002','2026-11-06','2.590','2026-11-06','10:46:46','PLG0018503','900000','900000','0','900000','0','kasirbip','2026-11-06 10:46:46','FJ-261106-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-06','FJ-261106-0002','2026-11-06','10:46:46','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-261106-0002','2026-11-06','2026-11-06 10:46:46','PENJUALAN : FJ-261106-0002','.','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-261106-0003','D','2026-11-06','10:46:46','TBC','PENJUALAN','FJ-261106-0002','30534171964','900000','30535071964','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='3550000' WHERE no_faktur_jual='FJ-261106-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','10:53:56'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','11:03:57'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02311','KUR','1','CC SILVER','SZ 16 GRAFIR JANGAN HILANG CROM PUTIH DOF SEMPROT','2.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-02311','2026-11-06','2026-11-06','11:47:15','PLG0018504','kasirbip','2026-11-21','kasirbip','2026-11-06 11:47:15','2.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-06 ','12:06: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-261106-0003','kasirbip','1',' DP-04446BI','TOKO','BIPPSN','PSPRT-ZKXB-33-0','CINCIN PERAK ','','2.070','1','100.00','212000','0','0','17800','850000','0','0','0','850000','KUR','00048851','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXB-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSPRT-ZKXB-33-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-261106-0003','2026-11-06','2.070','2026-11-06','12:34:46','PLG0018505','850000','850000','0','850000','0','kasirbip','2026-11-06 12:34:45','FJ-261106-0003','DP-04446','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-06','FJ-261106-0003','2026-11-06','12:34:46','KUR','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-261106-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-06 ','12:42:24'); 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-261106-0004','kasirbip','1',' 750K-165-2','TOKO','BIPPER','PBDG-ZGXF-42-0','CINCIN SILVER 925 ','','2.260','1','100.00','232000','0','0','17800','850000','0','0','0','850000','SULIS','00044970','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-42-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-06' AND kode_barang='PBDG-ZGXF-42-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-261106-0004','2026-11-06','2.260','2026-11-06','12:59:07','PLG0018506','850000','850000','0','850000','0','kasirbip','2026-11-06 12:59:07','FJ-261106-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-06','FJ-261106-0004','2026-11-06','12:59:07','SULIS','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0003','2026-11-06','2026-11-06 12:59:07','PENJUALAN : FJ-261106-0004','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0004','D','2026-11-06','12:59:07','TBC','PENJUALAN','FJ-261106-0004','30535071964','850000','30535921964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261106-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-261106-0005','kasirbip',' 1',' 850K-155-3','TOKO','BIPPER','PBDG-ZKXC-30-0','CINCIN SILVER 925 ','','1.420','1','100.00','145000','0','0','17800','950000','0','0','0','950000','SULIS','00048907','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZKXC-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PBDG-ZKXC-30-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-261106-0005','2026-11-06','1.420','2026-11-06','12:59:07','PLG0018507','950000','950000','0','950000','0','kasirbip','2026-11-06 12:59:07','FJ-261106-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-06','FJ-261106-0005','2026-11-06','12:59:07','SULIS','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-261106-0004','2026-11-06','2026-11-06 12:59:07','PENJUALAN : FJ-261106-0005','.','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-261106-0005','D','2026-11-06','12:59:07','TBC','PENJUALAN','FJ-261106-0005','30535921964','950000','30536871964','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='1800000' WHERE no_faktur_jual='FJ-261106-0005' 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-02312','SULIS','1','SEPASANG SILVER','CWE SZ 14 PUTIH GLOSY KEDUANYA FONT BRUSH SCRIPT','3.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-02312','2026-11-06','2026-11-06','13:02:08','PLG0018508','kasirbip','2026-11-21','kasirbip','2026-11-06 13:02:08','3.000','0','0','0','0','0','0','0','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-05048','PUT','1','PER','WEDDRING PROMO','','','4.500','','925.00','1','100000','0','1200000','0','1200000','sz cwe 16 grf A & W 28.11.26','sz cwo 17 grf A & W 28.11.26','font Brush CM.03 express 100.000','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-261106-0005','2026-11-06','2026-11-06 13:04:48','PESANAN : DP-05048','.','TBC','1300000','1300000'); 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-261106-0006','D','2026-11-06','13:04:48','TBC','PESANAN','DP-05048','30536871964','1300000','30538171964','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-05048','2026-11-06','2026-11-06','13:04:48','PLG0018509','PUT','2026-11-20','kasirbip','2026-11-06 13:04:48','4.500','0','0','0','1300000','0','0','1300000','1300000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-06 ','13:46:28'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0005'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-06 ','14:57:12'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','15:01:42'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-06 ','15:04:47'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','15:06:35'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','15:08:05'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','15:08:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-06 ','15:17:07'); 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-05049','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE 26.5 GRF: Ivi ?? Ferdi (BERKSHIRE)','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-261106-0006','2026-11-06','2026-11-06 15:24:14','PESANAN : DP-05049','-','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-261106-0007','D','2026-11-06','15:24:14','TBC','PESANAN','DP-05049','30538171964','900000','30539071964','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-05049','2026-11-06','2026-11-06','15:24:14','PLG0018510','DIL','2026-11-30','sby','2026-11-06 15:24:14','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-05050','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','950000','0','950000','PERMATA 10 BUTIR','SIZE 12.5 GRF: Ferdi ?? Ivi (BERKSHIRE)','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-261106-0007','2026-11-06','2026-11-06 15:27:00','PESANAN : DP-05050','-','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-261106-0008','D','2026-11-06','15:27:00','TBC','PESANAN','DP-05050','30539071964','950000','30540021964','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-05050','2026-11-06','2026-11-06','15:27:00','PLG0018511','DIL','2026-11-30','sby','2026-11-06 15:27:00','2.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-06 ','15:58:37'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261106-0006','kasirbip','1',' 800K-23-30','TOKO','BIPPER','PBDG-ZJBF-12-0','CINCIN SILVER 925 ','','3.250','1','100.00','332000','0','0','17800','900000','0','0','0','900000','SAL','00048622','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJBF-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PBDG-ZJBF-12-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-261106-0006','2026-11-06','3.250','2026-11-06','16:56:03','PLG0018512','900000','900000','0','900000','0','kasirbip','2026-11-06 16:56:03','FJ-261106-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-06','FJ-261106-0006','2026-11-06','16:56:03','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-261106-0008','2026-11-06','2026-11-06 16:56:03','PENJUALAN : FJ-261106-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-261106-0009','D','2026-11-06','16:56:03','TBC','PENJUALAN','FJ-261106-0006','30540021964','900000','30540921964','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-261106-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-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-261106-0007','sby','1',' 750K-13-00','TOKO','SBYPER','PSBY-ZEXE-15-0','CINCIN SILVER 925 ','','2.180','1','100.00','223000','0','0','17800','850000','0','0','0','850000','ARA','00043211','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSBY-ZEXE-15-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-261106-0007','2026-11-06','2.180','2026-11-06','17:03:32','PLG0018513','850000','850000','0','850000','0','sby','2026-11-06 17:03:31','FJ-261106-0007','','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-06','FJ-261106-0007','2026-11-06','17:03:32','ARA','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0009','2026-11-06','2026-11-06 17:03:31','PENJUALAN : FJ-261106-0007','','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0010','D','2026-11-06','17:03:32','TBC','PENJUALAN','FJ-261106-0007','30540921964','850000','30541771964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261106-0007' 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-05051','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','cwo YL01 sz 20.5 UPSIZE 100.000 grf Apipah','cwe putih glosy sz 19 UPSIZE grf Iwan','font vladimir','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0010','2026-11-06','2026-11-06 17:07:47','PESANAN : DP-05051','.','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-261106-0011','D','2026-11-06','17:07:47','TBC','PESANAN','DP-05051','30541771964','850000','30542621964','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-05051','2026-11-06','2026-11-06','17:07:47','PLG0018514','SULIS','2026-11-27','kasirbip','2026-11-06 17:07:47','2.000','0','0','0','850000','0','0','850000','850000','0'); 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-11-06', status ='CLOS' WHERE no_service='SV-02304'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02304'; 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-261106-0008','kasirbip','1',' DP-04126DU','TOKO','DUPSN','PSPRT-ZJAF-31-0','CINCIN PERAK ','','4.160','1','100.00','425000','0','0','17800','850000','0','0','0','850000','PUT','00048228','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-31-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-11-06' AND kode_barang='PSPRT-ZJAF-31-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-261106-0008','2026-11-06','4.160','2026-11-06','17:41:53','PLG0018515','850000','850000','0','850000','0','kasirbip','2026-11-06 17:41:53','FJ-261106-0008','DP-04126','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-06','FJ-261106-0008','2026-11-06','17:41:53','PUT','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-261106-0008' 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-05052','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 11.5 putih doff semprot 1 zirkon','font brush script grf Luthfi','','','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0011','2026-11-06','2026-11-06 17:52:57','PESANAN : DP-05052','.','TBC','1440000','1440000'); 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-261106-0012','D','2026-11-06','17:52:57','TBC','PESANAN','DP-05052','30542621964','1440000','30544061964','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-05052','2026-11-06','2026-11-06','17:52:57','PLG0018516','KUR','2026-11-28','kasirbip','2026-11-06 17:52:57','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); 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-05053','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 15 putih doff semprot','font brush script grf Salma','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0012','2026-11-06','2026-11-06 17:54:50','PESANAN : DP-05053','.','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-261106-0013','D','2026-11-06','17:54:50','TBC','PESANAN','DP-05053','30544061964','900000','30544961964','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-05053','2026-11-06','2026-11-06','17:54:50','PLG0018517','KUR','2026-11-28','kasirbip','2026-11-06 17:54:50','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','18:00: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-261106-0009','kasirbip','1',' 750K-145-0','TOKO','DUPERBDG','LXPER-ZJAI-14-0','CINCIN SILVER 925 ','','1.520','1','100.00','156000','0','0','17800','850000','0','0','0','850000','MIL','00048258','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJAI-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='LXPER-ZJAI-14-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-261106-0009','2026-11-06','1.520','2026-11-06','18:00:35','PLG0018518','850000','850000','0','850000','0','kasirbip','2026-11-06 18:00:34','FJ-261106-0009','','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-06','FJ-261106-0009','2026-11-06','18:00:35','MIL','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-261106-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-261106-0010','kasir','1',' 850K-13-64','TOKO','MMPER','PMM-YLAX-74-0','CINCIN SILVER 925 ','','1.600','1','100.00','98000','0','0','17800','950000','0','0','0','950000','ELLA','00040476','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-74-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PMM-YLAX-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261106-0010','2026-11-06','1.600','2026-11-06','18:01:17','PLG0018519','950000','950000','0','950000','0','kasir','2026-11-06 18:01:16','FJ-261106-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-06','FJ-261106-0010','2026-11-06','18:01:17','ELLA','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-261106-0013','2026-11-06','2026-11-06 18:01:16','PENJUALAN : FJ-261106-0010','0','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-261106-0014','D','2026-11-06','18:01:17','TBC','PENJUALAN','FJ-261106-0010','30544961964','950000','30545911964','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='950000' WHERE no_faktur_jual='FJ-261106-0010' 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-261106-0011','kasir',' 1',' 500K-235-1','TOKO','MMPER','PMM-ZJAD-20-0','CINCIN SILVER 925 YL01 ','','2.070','1','100.00','212000','0','0','17800','600000','0','0','0','600000','ELLA','00048147','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJAD-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PMM-ZJAD-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261106-0011','2026-11-06','2.070','2026-11-06','18:01:17','PLG0018520','600000','600000','0','600000','0','kasir','2026-11-06 18:01:16','FJ-261106-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-06','FJ-261106-0011','2026-11-06','18:01:17','ELLA','600000','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-261106-0014','2026-11-06','2026-11-06 18:01:16','PENJUALAN : FJ-261106-0011','0','TBC','600000','600000','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-261106-0015','D','2026-11-06','18:01:17','TBC','PENJUALAN','FJ-261106-0011','30545911964','600000','30546511964','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='1550000' WHERE no_faktur_jual='FJ-261106-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-261106-0012','kasirbip','1',' 750K-18-30','TOKO','BIPPER','PBDG-ZKXC-25-0','CINCIN SILVER 925 ','','2.200','1','100.00','225000','0','0','17800','850000','0','0','0','850000','SAL','00048902','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZKXC-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PBDG-ZKXC-25-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-261106-0012','2026-11-06','2.200','2026-11-06','18:14:05','PLG0018521','850000','850000','0','850000','0','kasirbip','2026-11-06 18:14:05','FJ-261106-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-11-06','FJ-261106-0012','2026-11-06','18:14:05','SAL','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0015','2026-11-06','2026-11-06 18:14:05','PENJUALAN : FJ-261106-0012','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0016','D','2026-11-06','18:14:05','TBC','PENJUALAN','FJ-261106-0012','30546511964','850000','30547361964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261106-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0012'; 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-261106-0013','kasirbip','1',' 850K-12-00','TOKO','DUPERBDG','LXPER-ZJBG-16-0','CINCIN SILVER 925 ','','1.790','1','100.00','183000','0','0','17800','950000','0','0','0','950000','PUT','00048670','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.790',berat_jual_asli=berat_jual_asli+'1.790',stock_jual='1',berat_akhir=berat_akhir-'1.790',berat_akhir_asli=berat_akhir_asli-'1.790',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='LXPER-ZJBG-16-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-261106-0013','2026-11-06','1.790','2026-11-06','18:15:08','PLG0018522','950000','950000','0','950000','0','kasirbip','2026-11-06 18:15:08','FJ-261106-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-06','FJ-261106-0013','2026-11-06','18:15:08','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-261106-0016','2026-11-06','2026-11-06 18:15:08','PENJUALAN : FJ-261106-0013','.','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-261106-0017','D','2026-11-06','18:15:08','TBC','PENJUALAN','FJ-261106-0013','30547361964','950000','30548311964','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-261106-0013' 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-261106-0014','kasirbip',' 1',' 800K-20-00','TOKO','DUPERBDG','LXPER-ZJBG-14-0','CINCIN SILVER 925 ','','2.820','1','100.00','288000','0','0','17800','850000','0','0','0','850000','PUT','00048668','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.820',berat_jual_asli=berat_jual_asli+'2.820',stock_jual='1',berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='LXPER-ZJBG-14-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-261106-0014','2026-11-06','2.820','2026-11-06','18:15:08','PLG0018523','850000','850000','0','850000','0','kasirbip','2026-11-06 18:15:08','FJ-261106-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-06','FJ-261106-0014','2026-11-06','18:15:08','PUT','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0017','2026-11-06','2026-11-06 18:15:08','PENJUALAN : FJ-261106-0014','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0018','D','2026-11-06','18:15:08','TBC','PENJUALAN','FJ-261106-0014','30548311964','850000','30549161964','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='1800000' WHERE no_faktur_jual='FJ-261106-0014' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','18:27:43'); 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-261106-0015','kasir','1',' TFCMR75-76','TOKO','TFCINMAS','TFCMR-ZHBX-5-0','THIFA CINCIN MAS RG ','','0.540','1','76.00','942000','0','0','17800','1000000','0','0','0','1000000','FIR','00046263','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZHBX-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='TFCMR-ZHBX-5-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-261106-0015','2026-11-06','0.540','2026-11-06','18:30:38','PLG0018524','1000000','1000000','0','1000000','0','kasir','2026-11-06 18:30:37','FJ-261106-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-06','FJ-261106-0015','2026-11-06','18:30:38','FIR','1000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0018','2026-11-06','2026-11-06 18:30:37','PENJUALAN : FJ-261106-0015','.','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0019','D','2026-11-06','18:30:38','TBC','PENJUALAN','FJ-261106-0015','30549161964','1000000','30550161964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-261106-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-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-05054','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1200000','0','1200000','cwo YL01 sz 16 grf Ica & Bayu','cwe sz 10.5 putih glossy 1 zirkon grf Bayu & Ica','font berkshire swash','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0019','2026-11-06','2026-11-06 18:39:31','PESANAN : DP-05054','.','TBC','1200000','1200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0020','D','2026-11-06','18:39:31','TBC','PESANAN','DP-05054','30550161964','1200000','30551361964','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-05054','2026-11-06','2026-11-06','18:39:31','PLG0018525','SAL','2026-12-05','kasirbip','2026-11-06 18:39:31','3.000','0','0','0','1200000','0','0','1200000','1200000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-06 ','18:41:09'); 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-05055','ELLA','1','PER','WEDDING RING','','','2.000','','925.00','1','100000','0','0','0','900000','size 11 grf Rizki','warna crom putih doff semprot','zircone 1 butir','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0020','2026-11-06','2026-11-06 18:48:09','PESANAN : DP-05055','0','TBC','900000','900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0021','D','2026-11-06','18:48:09','TBC','PESANAN','DP-05055','30551361964','900000','30552261964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-05055','2026-11-06','2026-11-06','18:48:09','PLG0018526','ELLA','2026-12-04','kasir','2026-11-06 18:48:09','2.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-05056','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','900000','size 14 grf Nurma ( font vintage rotter )','warna crom putih doff semprot','tanpa permata','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261106-0021','2026-11-06','2026-11-06 18:52:14','PESANAN : DP-05056','0','TBC','900000','900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0022','D','2026-11-06','18:52:14','TBC','PESANAN','DP-05056','30552261964','900000','30553161964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-05056','2026-11-06','2026-11-06','18:52:14','PLG0018527','ELLA','2026-12-04','kasir','2026-11-06 18:52:14','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261106-0016','kasir','1',' TFAMR75-81','TOKO','TFAMP','TFAMR-YLXC-25-0','THIFA ANTING MAS RG ','','1.500','1','81.00','2789000','0','0','17800','2799000','0','0','0','2799000','IQB','00040148','TFAMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFAMR-YLXC-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='TFAMR-YLXC-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFAMP' 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-261106-0016','2026-11-06','1.500','2026-11-06','19:15:00','PLG0018528','2799000','2799000','0','2799000','0','kasir','2026-11-06 19:14:59','FJ-261106-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-06','FJ-261106-0016','2026-11-06','19:15:00','IQB','2799000','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-261106-0022','2026-11-06','2026-11-06 19:14:59','PENJUALAN : FJ-261106-0016','.','TBC','2799000','2799000','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-261106-0023','D','2026-11-06','19:15:00','TBC','PENJUALAN','FJ-261106-0016','30553161964','2799000','30555960964','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='2799000' WHERE no_faktur_jual='FJ-261106-0016' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0016'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02313','SULIS','1','CCN SILVER','SZ 15 5 KROM PUTIH DOFF SEMPROT','2.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-02313','2026-11-06','2026-11-06','19:27:32','PLG0018529','kasirbip','2026-11-21','kasirbip','2026-11-06 19:27:32','2.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-06 ','19:27:50'); 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-261106-0017','kasir','1',' DP-04817MM','TOKO','MMPSN','PSGT-ZKXE-6-0','CINCIN EMAS ','','2.640','1','57.00','3454000','0','0','17800','6292000','0','0','0','6292000','ALIKA','00049026','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKXE-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSGT-ZKXE-6-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-261106-0017','2026-11-06','2.640','2026-11-06','19:34:59','PLG0018530','6292000','6292000','0','6292000','0','kasir','2026-11-06 19:34:59','FJ-261106-0017','DP-04817','5264000'); 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-06','FJ-261106-0017','2026-11-06','19:34:59','ALIKA','6292000','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-261106-0023','2026-11-06','2026-11-06 19:34:59','PENJUALAN : FJ-261106-0017','0','TBC','1028000','1028000','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-261106-0024','D','2026-11-06','19:34:59','TBC','PENJUALAN','FJ-261106-0017','30555960964','1028000','30556988964','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='1028000' WHERE no_faktur_jual='FJ-261106-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-261106-0018','sby','1',' 950K-15-00','TOKO','SBYPER','PSBY-ZJXE-18-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','1050000','0','0','0','1050000','ARA','00047903','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJXE-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSBY-ZJXE-18-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-261106-0018','2026-11-06','2.270','2026-11-06','19:36:14','PLG0018531','1050000','1050000','0','1050000','0','sby','2026-11-06 19:36:14','FJ-261106-0018','','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-06','FJ-261106-0018','2026-11-06','19:36:14','ARA','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0024','2026-11-06','2026-11-06 19:36:14','PENJUALAN : FJ-261106-0018','','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261106-0025','D','2026-11-06','19:36:14','TBC','PENJUALAN','FJ-261106-0018','30556988964','1050000','30558038964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-261106-0018' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261106-0019','sby',' 1',' 800K-18-00','TOKO','SBYPER','PSBY-ZKXC-45-0','CINCIN SILVER 925 ','','4.170','1','100.00','426000','0','0','17800','900000','0','0','0','900000','ARA','00048922','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZKXC-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.170',berat_jual_asli=berat_jual_asli+'4.170',stock_jual='1',berat_akhir=berat_akhir-'4.170',berat_akhir_asli=berat_akhir_asli-'4.170',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSBY-ZKXC-45-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-261106-0019','2026-11-06','4.170','2026-11-06','19:36:14','PLG0018532','900000','900000','0','900000','0','sby','2026-11-06 19:36:14','FJ-261106-0018','','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-06','FJ-261106-0019','2026-11-06','19:36:14','ARA','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-261106-0025','2026-11-06','2026-11-06 19:36:14','PENJUALAN : FJ-261106-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-261106-0026','D','2026-11-06','19:36:14','TBC','PENJUALAN','FJ-261106-0019','30558038964','900000','30558938964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1950000' WHERE no_faktur_jual='FJ-261106-0019' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0019'; 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-261106-0020','kasir','1',' 800K-28-13','TOKO','MMPER','PMM-ZJBF-10-0','CINCIN SILVER 925 ','','3.520','1','100.00','360000','0','0','17800','800000','0','0','0','800000','ASRI','00048620','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJBF-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PMM-ZJBF-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261106-0020','2026-11-06','3.520','2026-11-06','19:40:35','PLG0018533','800000','800000','0','800000','0','kasir','2026-11-06 19:40:35','FJ-261106-0020','','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-06','FJ-261106-0020','2026-11-06','19:40:35','ASRI','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-261106-0026','2026-11-06','2026-11-06 19:40:35','PENJUALAN : FJ-261106-0020','.','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-261106-0027','D','2026-11-06','19:40:35','TBC','PENJUALAN','FJ-261106-0020','30558938964','800000','30559738964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-261106-0020' 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-261106-0021','kasir',' 1',' 800K-12-94','TOKO','MMPER','PMM-ZDAF-7-0','CINCIN SILVER 925 ','','2.330','1','100.00','238000','0','0','17800','800000','0','0','0','800000','ASRI','00042602','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDAF-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PMM-ZDAF-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261106-0021','2026-11-06','2.330','2026-11-06','19:40:35','PLG0018534','800000','800000','0','800000','0','kasir','2026-11-06 19:40:35','FJ-261106-0020','','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-06','FJ-261106-0021','2026-11-06','19:40:35','ASRI','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-261106-0027','2026-11-06','2026-11-06 19:40:35','PENJUALAN : FJ-261106-0021','.','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-261106-0028','D','2026-11-06','19:40:35','TBC','PENJUALAN','FJ-261106-0021','30559738964','800000','30560538964','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='1600000' WHERE no_faktur_jual='FJ-261106-0021' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0021'; 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-261106-0022','sby','1',' 800K-185-0','TOKO','SBYPER','PSBY-ZJAI-78-0','CINCIN SILVER 925 ','','3.120','1','100.00','319000','0','0','17800','900000','0','0','0','900000','DIL','00048322','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-78-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSBY-ZJAI-78-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-261106-0022','2026-11-06','3.120','2026-11-06','19:46:17','PLG0018535','900000','900000','0','900000','0','sby','2026-11-06 19:46:17','FJ-261106-0022','','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-06','FJ-261106-0022','2026-11-06','19:46:17','DIL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261106-0028','2026-11-06','2026-11-06 19:46:17','PENJUALAN : FJ-261106-0022','','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-261106-0029','D','2026-11-06','19:46:17','TBC','PENJUALAN','FJ-261106-0022','30560538964','900000','30561438964','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-261106-0022' 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-261106-0023','sby','1',' DP-04512SB','TOKO','SBYPSN','PSPRT-ZKXB-43-0','CINCIN PERAK ','','3.850','1','100.00','393000','0','0','17800','950000','0','0','0','950000','DIL','00048861','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXB-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSPRT-ZKXB-43-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-261106-0023','2026-11-06','3.850','2026-11-06','20:17:17','PLG0018536','950000','950000','0','950000','0','sby','2026-11-06 20:17:16','FJ-261106-0023','DP-04512','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-11-06','FJ-261106-0023','2026-11-06','20:17:17','DIL','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-261106-0023' LIMIT 1; 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-11-06', status ='CLOS' WHERE no_service='SV-02295'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02295'; 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-261106-0024','sby','1',' DP-04556SB','TOKO','SBYPSN','PSPRT-ZJCX-49-0','CINCIN PERAK ','','4.770','1','100.00','488000','0','0','17800','950000','0','0','0','950000','DIL','00048813','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJCX-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.770',berat_jual_asli=berat_jual_asli+'4.770',stock_jual='1',berat_akhir=berat_akhir-'4.770',berat_akhir_asli=berat_akhir_asli-'4.770',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='PSPRT-ZJCX-49-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-261106-0024','2026-11-06','4.770','2026-11-06','20:39:56','PLG0018537','950000','950000','0','950000','0','sby','2026-11-06 20:39:56','FJ-261106-0024','DP-04556','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-11-06','FJ-261106-0024','2026-11-06','20:39:56','DIL','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-261106-0024' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261106-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261106-0024'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-07','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-07'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-06'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-06'; 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-06' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-06'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-06'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-06'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-06'; 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-07' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-06' 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-261107-0001','D','2026-11-07','21:20:09','TBC','SALDO AWAL','SALDO AWAL','0','30561438964','30561438964'); 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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20: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-261107-0001','D','2026-11-07','21:20:09','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261107-0001','D','2026-11-07','21:20:09','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261107-0001','D','2026-11-07','21:20:09','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); UPDATE tp_system SET tgl_system='2026-11-07';