INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','10:55:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-11 ','11:05:31');
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-260711-0001','kasirbip','1',' DP-02529BI','TOKO','BIPPSN','PSPLT-ZGXC-22-0','CINCIN PALADIUM ','','2.520','1','17.00','566000','0','0','17800','2032000','0','0','0','2032000','SULIS','00044926','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXC-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXC-22-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-260711-0001','2026-07-11','2.520','2026-07-11','11:06:33','PLG0013004','2032000','2032000','0','2032000','0','kasirbip','2026-07-11 11:06:33','FJ-260711-0001','DP-02529','1900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0001','2026-07-11','11:06:33','SULIS','2032000','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-260711-0001','2026-07-11','2026-07-11 11:06:33','PENJUALAN : FJ-260711-0001','.','TBC','132000','132000','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-260711-0002','D','2026-07-11','11:06:33','TBC','PENJUALAN','FJ-260711-0001','24669389564','132000','24669521564','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='132000' WHERE no_faktur_jual='FJ-260711-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-11 ','11:31: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-260711-0002','kasirbip','1',' DP-02484BI','TOKO','BIPPSN','PSPLT-ZGXB-3-0','CINCIN PALADIUM ','','3.920','1','17.00','880000','0','0','17800','2072000','0','0','0','2072000','SAL','00044894','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXB-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.920',berat_jual_asli=berat_jual_asli+'3.920',stock_jual='1',berat_akhir=berat_akhir-'3.920',berat_akhir_asli=berat_akhir_asli-'3.920',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXB-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0002','2026-07-11','3.920','2026-07-11','11:42:53','PLG0013005','2072000','2072000','0','2072000','0','kasirbip','2026-07-11 11:42:52','FJ-260711-0002','DP-02484','1680000');
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-07-11','FJ-260711-0002','2026-07-11','11:42:53','SAL','2072000','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-260711-0002','2026-07-11','2026-07-11 11:42:52','PENJUALAN : FJ-260711-0002','.','TBC','392000','392000','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-260711-0003','D','2026-07-11','11:42:53','TBC','PENJUALAN','FJ-260711-0002','24669521564','392000','24669913564','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='392000' WHERE no_faktur_jual='FJ-260711-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0003','kasirbip',' 1',' DP-02483BI','TOKO','BIPPSN','PSGT-ZFBF-16-0','CINCIN EMAS ','','1.570','1','45.00','1781000','0','0','17800','3055000','0','0','0','3055000','SAL','00044758','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSGT-ZFBF-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0003','2026-07-11','1.570','2026-07-11','11:42:53','PLG0013006','3055000','3055000','0','3055000','0','kasirbip','2026-07-11 11:42:52','FJ-260711-0002','DP-02483','2960000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0003','2026-07-11','11:42:53','SAL','3055000','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-260711-0003','2026-07-11','2026-07-11 11:42:52','PENJUALAN : FJ-260711-0003','.','TBC','95000','95000','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-260711-0004','D','2026-07-11','11:42:53','TBC','PENJUALAN','FJ-260711-0003','24669913564','95000','24670008564','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='487000' WHERE no_faktur_jual='FJ-260711-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','12:00:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-11 ','12:19:33');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0004','kasirbip','1',' DP-02603DU','TOKO','DUPSN','PSPRT-ZGXH-17-0','CINCIN PERAK ','','1.570','1','100.00','161000','0','0','17800','1100000','0','0','0','1100000','KUR','00045062','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGXH-17-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-260711-0004','2026-07-11','1.570','2026-07-11','12:22:26','PLG0013007','1100000','1100000','0','1100000','0','kasirbip','2026-07-11 12:22:25','FJ-260711-0004','DP-02603','1100000');
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-07-11','FJ-260711-0004','2026-07-11','12:22:26','KUR','1100000','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-260711-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-260711-0005','kasirbip',' 1',' DP-02605DU','TOKO','DUPSN','PSPRT-ZGXH-18-0','CINCIN PERAK ','','4.400','1','100.00','450000','0','0','17800','950000','0','0','0','950000','KUR','00045063','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXH-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.400',berat_jual_asli=berat_jual_asli+'4.400',stock_jual='1',berat_akhir=berat_akhir-'4.400',berat_akhir_asli=berat_akhir_asli-'4.400',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGXH-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0005','2026-07-11','4.400','2026-07-11','12:22:26','PLG0013008','950000','950000','0','950000','0','kasirbip','2026-07-11 12:22:25','FJ-260711-0004','DP-02605','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-07-11','FJ-260711-0005','2026-07-11','12:22:26','KUR','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-260711-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-02162','KUR','1','CINCIN EMAS','SIZE 12 ROSEGOLD GLOSSY FONT BERKSHIRE SWASH','1.380','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260711-0004','2026-07-11','2026-07-11 12:26:18','SERVICE : SV-02162','.','TBC','100000','100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0005','D','2026-07-11','12:26:18','TBC','SERVICE','SV-02162','24670008564','100000','24670108564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02162','2026-07-11','2026-07-11','12:26:18','PLG0013009','kasirbip','2026-07-31','kasirbip','2026-07-11 12:26:18','1.380','0','0','0','100000','0','100000','100000','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-260711-0006','kasirbip','1',' DP-02478BI','TOKO','BIPPSN','PSGT-ZFBF-19-0','CINCIN EMAS ','','1.380','1','45.00','1565000','0','0','17800','2870000','0','0','0','2870000','KUR','00044761','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSGT-ZFBF-19-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-260711-0006','2026-07-11','1.380','2026-07-11','12:27:31','PLG0013010','2870000','2870000','0','2870000','0','kasirbip','2026-07-11 12:27:30','FJ-260711-0006','DP-02478','3040000');
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-07-11','FJ-260711-0006','2026-07-11','12:27:31','KUR','2870000','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-260711-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0007','kasirbip',' 1',' DP-02481BI','TOKO','BIPPSN','PSPLT-ZFBI-40-0','CINCIN PALADIUM ','','1.520','1','17.00','342000','0','0','17800','1282000','0','0','0','1282000','KUR','00044831','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-40-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-07-11' AND kode_barang='PSPLT-ZFBI-40-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-260711-0007','2026-07-11','1.520','2026-07-11','12:27:31','PLG0013011','1282000','1282000','0','1282000','0','kasirbip','2026-07-11 12:27:30','FJ-260711-0006','DP-02481','1440000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0007','2026-07-11','12:27:31','KUR','1282000','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-260711-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0008','kasirbip','1',' DP-02527BI','TOKO','BIPPSN','PSPRT-ZFBD-30-0','CINCIN PERAK ','','2.690','1','100.00','275000','0','0','17800','950000','0','0','0','950000','KUR','00044685','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZFBD-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0008','2026-07-11','2.690','2026-07-11','12:31:18','PLG0013012','950000','950000','0','950000','0','kasirbip','2026-07-11 12:31:17','FJ-260711-0008','DP-02527','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-07-11','FJ-260711-0008','2026-07-11','12:31:18','KUR','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-260711-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0009','kasirbip',' 1',' DP-02526BI','TOKO','BIPPSN','PSGT-ZGXC-9-0','CINCIN EMAS ','','2.180','1','45.00','2372000','0','0','17800','4020000','0','0','0','4020000','KUR','00044913','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGXC-9-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-07-11' AND kode_barang='PSGT-ZGXC-9-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-260711-0009','2026-07-11','2.180','2026-07-11','12:31:18','PLG0013013','4020000','4020000','0','4020000','0','kasirbip','2026-07-11 12:31:17','FJ-260711-0008','DP-02526','3600000');
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-07-11','FJ-260711-0009','2026-07-11','12:31:18','KUR','4020000','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-260711-0005','2026-07-11','2026-07-11 12:31:17','PENJUALAN : FJ-260711-0009','.','TBC','420000','420000','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-260711-0006','D','2026-07-11','12:31:18','TBC','PENJUALAN','FJ-260711-0009','24670108564','420000','24670528564','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='420000' WHERE no_faktur_jual='FJ-260711-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0009';
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-260711-0010','sby','1',' DP-02492SB','TOKO','SBYPSN','PSPLT-ZGXH-23-0','CINCIN PALADIUM ','','3.800','1','32.00','1606000','0','0','17800','2790000','0','0','0','2790000','VAN','00045068','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXH-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXH-23-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-260711-0010','2026-07-11','3.800','2026-07-11','12:46:03','PLG0013014','2790000','2790000','0','2790000','0','sby','2026-07-11 12:46:02','FJ-260711-0010','DP-02492','2000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0010','2026-07-11','12:46:03','VAN','2790000','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-260711-0006','2026-07-11','2026-07-11 12:46:02','PENJUALAN : FJ-260711-0010','','TBC','2790000','2790000','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-260711-0007','D','2026-07-11','12:46:03','TBC','PENJUALAN','FJ-260711-0010','24670528564','2790000','24673318564','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='2790000' WHERE no_faktur_jual='FJ-260711-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-260711-0011','sby',' 1',' DP-02493SB','TOKO','SBYPSN','PSGT-ZGXF-23-0','CINCIN EMAS ','','2.910','1','57.00','4011000','0','0','17800','6910000','0','0','0','6910000','VAN','00044951','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGXF-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSGT-ZGXF-23-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-260711-0011','2026-07-11','2.910','2026-07-11','12:46:03','PLG0013015','6910000','6910000','0','6910000','0','sby','2026-07-11 12:46:02','FJ-260711-0010','DP-02493','4900000');
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-07-11','FJ-260711-0011','2026-07-11','12:46:03','VAN','6910000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2790000' WHERE no_faktur_jual='FJ-260711-0011' 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-02866','KUR','1','PLD','CINCIN KAWIN','','','3.000','','10.00','1','1200000','350000','0','850000','1900000','size 15 grf Pinkan Juanda','putih dof semprot','font yeseva 0ne','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-260711-0007','2026-07-11','2026-07-11 12:47:03','PESANAN : DP-02866','.','TBC','1520000','1520000');
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-260711-0008','D','2026-07-11','12:47:03','TBC','PESANAN','DP-02866','24673318564','1520000','24674838564','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-02866','2026-07-11','2026-07-11','12:47:03','PLG0013016','KUR','2026-08-03','kasirbip','2026-07-11 12:47:03','3.000','0','0','0','1520000','0','850000','1900000','1900000','380000');
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-02867','KUR','1','GOLD','CINCIN KAWIN','','','3.000','','375.00','1','2290000','1400000','0','850000','5050000','size 10 grf Al Rizki','putih kilat sirkon 1','font yeseva one','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-260711-0008','2026-07-11','2026-07-11 13:00:01','PESANAN : DP-02867','.','TBC','3350000','3350000');
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-260711-0009','D','2026-07-11','13:00:01','TBC','PESANAN','DP-02867','24674838564','3350000','24678188564','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-02867','2026-07-11','2026-07-11','13:00:01','PLG0013017','KUR','2026-08-03','kasirbip','2026-07-11 13:00:01','3.000','0','0','0','3350000','0','850000','5050000','5050000','1700000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-11 ','13:43:15');
UPDATE tt_service_head SET tgl_selesai='2026-07-11',  status ='DONE' WHERE no_service='SV-02149';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02149';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-10';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-10' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tt_service_head SET tgl_selesai='2026-07-11',  status ='DONE' WHERE no_service='SV-02156';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02156';
UPDATE tt_service_head SET tgl_selesai='2026-07-11',  status ='DONE' WHERE no_service='SV-02155';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02155';
UPDATE tt_service_head SET tgl_selesai='2026-07-11',  status ='DONE' WHERE no_service='SV-02154';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02154';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','13:49:30');
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-260711-0012','kasir','1',' 750K-195-1','TOKO','MMPER','PMM-ZGXF-6-0','CINCIN SILVER 925 ','','2.810','1','100.00','287000','0','0','17800','850000','0','0','0','850000','ELLA','00044934','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGXF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PMM-ZGXF-6-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-260711-0012','2026-07-11','2.810','2026-07-11','13:51:50','PLG0013018','850000','850000','0','850000','0','kasir','2026-07-11 13:51:50','FJ-260711-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-07-11','FJ-260711-0012','2026-07-11','13:51:50','ELLA','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-260711-0009','2026-07-11','2026-07-11 13:51:50','PENJUALAN : FJ-260711-0012','0','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-260711-0010','D','2026-07-11','13:51:50','TBC','PENJUALAN','FJ-260711-0012','24678188564','850000','24679038564','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='850000' WHERE no_faktur_jual='FJ-260711-0012' 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-260711-0013','kasir',' 1',' 800K-14-92','TOKO','MMPER','PMM-ZBBG-40-0','CINCIN SILVER 925 ','','2.050','1','100.00','210000','0','0','17800','900000','0','0','0','900000','ELLA','00042042','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PMM-ZBBG-40-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-260711-0013','2026-07-11','2.050','2026-07-11','13:51:50','PLG0013019','900000','900000','0','900000','0','kasir','2026-07-11 13:51:50','FJ-260711-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-07-11','FJ-260711-0013','2026-07-11','13:51:50','ELLA','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-260711-0010','2026-07-11','2026-07-11 13:51:50','PENJUALAN : FJ-260711-0013','0','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-260711-0011','D','2026-07-11','13:51:50','TBC','PENJUALAN','FJ-260711-0013','24679038564','900000','24679938564','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='1750000' WHERE no_faktur_jual='FJ-260711-0013' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260711-0001','1','PSPRT-ZGAX-2-0','1','1.750','1.750','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-2-0','1','1.750','1.750','1','1.750','1.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-3-0','1','2.490','2.490','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-3-0','1','2.490','2.490','1','2.490','2.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-4-0','1','2.780','2.780','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-4-0','1','2.780','2.780','1','2.780','2.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-5-0','1','3.110','3.110','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-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-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-5-0','1','3.110','3.110','1','3.110','3.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-6-0','1','3.080','3.080','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-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-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-6-0','1','3.080','3.080','1','3.080','3.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-7-0','1','0.980','0.980','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-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-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-7-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-22-0','1','3.230','3.230','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-22-0','1','3.230','3.230','1','3.230','3.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-23-0','1','4.010','4.010','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-23-0','1','4.010','4.010','1','4.010','4.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-25-0','1','1.860','1.860','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-25-0','1','1.860','1.860','1','1.860','1.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-26-0','1','1.700','1.700','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-26-0','1','1.700','1.700','1','1.700','1.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-27-0','1','7.120','7.120','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-27-0','1','7.120','7.120','1','7.120','7.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0001','1','PSPRT-ZGAX-28-0','1','3.750','3.750','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-11 13:54:03' WHERE kode_barang='PSPRT-ZGAX-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 13:54:03','TOKO','BIPPSN','PSPRT','PSPRT-ZGAX-28-0','1','3.750','3.750','1','3.750','3.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260711-0001','2026-07-11','13:53','35.860','kasirbip','2026-07-11 13:54:03');
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-02868','ALIKA','1','PLD','WEDDING RING','','','5.500','','10.00','1','1200000','350000','0','800000','2725000','size 17 grf YANTI WAWAN','WARNA PUTIH DOFF SEMPROT SESUAI MODEL','ZIRCONE 1 BUTIR','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0011','2026-07-11','2026-07-11 14:04:40','PESANAN : DP-02868','0','TBC','2180000','2180000');
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-260711-0012','D','2026-07-11','14:04:40','TBC','PESANAN','DP-02868','24679938564','2180000','24682118564','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-02868','2026-07-11','2026-07-11','14:04:40','PLG0013020','ALIKA','2026-08-10','kasir','2026-07-11 14:04:40','5.500','0','0','0','2180000','0','800000','2725000','2725000','545000');
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-02869','ALIKA','1','PLD','WEDDING RING','','','5.500','','10.00','1','1200000','350000','0','800000','2725000','size 17 grf YANTI WAWAN','WARNA PUTIH DOFF SEMPROT SESUAI MODEL','ZIRCONE 1 BUTIR','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0012','2026-07-11','2026-07-11 14:04:42','PESANAN : DP-02869','0','TBC','2180000','2180000');
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-260711-0013','D','2026-07-11','14:04:42','TBC','PESANAN','DP-02869','24682118564','2180000','24684298564','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-02869','2026-07-11','2026-07-11','14:04:42','PLG0013021','ALIKA','2026-08-10','kasir','2026-07-11 14:04:42','5.500','0','0','0','2180000','0','800000','2725000','2725000','545000');
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-02870','PUT','1','GOLD','WEDRING','','','2.500','','50.00','1','2290000','1800000','0','750000','5250000','sz 14 crom Kuning gllosy','grf Zidni 08.08.2026','font Vintage Express 100.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0013','2026-07-11','2026-07-11 14:05:00','PESANAN : DP-02870','.','TBC','4200000','4200000');
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-260711-0014','D','2026-07-11','14:05:00','TBC','PESANAN','DP-02870','24684298564','4200000','24688498564','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-02870','2026-07-11','2026-07-11','14:05:00','PLG0013022','PUT','2026-07-23','kasirbip','2026-07-11 14:05:00','2.500','0','0','0','4200000','0','750000','5250000','5250000','1050000');
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-02871','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz 20 crom doff semprot','grf Dila 08.08.2026','font Vintage Exspress 100.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0014','2026-07-11','2026-07-11 14:09:12','PESANAN : DP-02871','.','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-260711-0015','D','2026-07-11','14:09:12','TBC','PESANAN','DP-02871','24688498564','1300000','24689798564','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-02871','2026-07-11','2026-07-11','14:09:12','PLG0013023','PUT','2026-07-23','kasirbip','2026-07-11 14:09:12','2.500','0','0','0','1300000','0','750000','1625000','1625000','325000');
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-02872','PUT','1','GOLD','WEDRING','','','3.000','','37.50','1','2290000','1400000','0','750000','4950000','sz 13.5 crom doff semprot','grf Fahmi.Hani font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0015','2026-07-11','2026-07-11 14:23:53','PESANAN : DP-02872','.','TBC','3960000','3960000');
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-260711-0016','D','2026-07-11','14:23:53','TBC','PESANAN','DP-02872','24689798564','3960000','24693758564','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-02872','2026-07-11','2026-07-11','14:23:53','PLG0013024','PUT','2026-08-10','kasirbip','2026-07-11 14:23:53','3.000','0','0','0','3960000','0','750000','4950000','4950000','990000');
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-02873','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 20 crom doff semprot','grf Hani.Fahmi font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0016','2026-07-11','2026-07-11 14:26:43','PESANAN : DP-02873','.','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-260711-0017','D','2026-07-11','14:26:43','TBC','PESANAN','DP-02873','24693758564','850000','24694608564','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-02873','2026-07-11','2026-07-11','14:26:43','PLG0013025','PUT','2026-08-10','kasirbip','2026-07-11 14:26:43','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-11 ','14:48:08');
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-260711-0014','kasirbip','1',' 750K-155-0','TOKO','DUPERBDG','LXPER-ZGXF-68-0','CINCIN SILVER 925 ','','2.110','1','100.00','216000','0','0','17800','850000','0','0','0','850000','PUT','00044996','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGXF-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZGXF-68-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-260711-0014','2026-07-11','2.110','2026-07-11','14:50:10','PLG0013026','850000','850000','0','850000','0','kasirbip','2026-07-11 14:50:10','FJ-260711-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0014','2026-07-11','14:50:10','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-260711-0017','2026-07-11','2026-07-11 14:50:10','PENJUALAN : FJ-260711-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-260711-0018','D','2026-07-11','14:50:10','TBC','PENJUALAN','FJ-260711-0014','24694608564','850000','24695458564','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-260711-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0015','kasirbip',' 1',' 750K-115-0','TOKO','DUPERBDG','LXPER-ZFAF-51-0','CINCIN SILVER 925 ','','1.910','1','100.00','195000','0','0','17800','850000','0','0','0','850000','PUT','00044481','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAF-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZFAF-51-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-260711-0015','2026-07-11','1.910','2026-07-11','14:50:10','PLG0013027','850000','850000','0','850000','0','kasirbip','2026-07-11 14:50:10','FJ-260711-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0015','2026-07-11','14:50:10','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-260711-0018','2026-07-11','2026-07-11 14:50:10','PENJUALAN : FJ-260711-0015','.','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-260711-0019','D','2026-07-11','14:50:10','TBC','PENJUALAN','FJ-260711-0015','24695458564','850000','24696308564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260711-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0015';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0016','kasir','1',' PLDMM-0003','TOKO','MMPLD','PLDMM-ZACX-20-0','CINCIN PALADIUM PLDMM-00034 ','','3.320','1','17.00','746000','0','0','17800','2012000','0','0','0','2012000','ALIKA','00041234','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZACX-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PLDMM-ZACX-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0016','2026-07-11','3.320','2026-07-11','15:04:16','PLG0013028','2012000','2012000','0','2012000','0','kasir','2026-07-11 15:04:16','FJ-260711-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-07-11','FJ-260711-0016','2026-07-11','15:04:16','ALIKA','2012000','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-260711-0019','2026-07-11','2026-07-11 15:04:16','PENJUALAN : FJ-260711-0016','0','TBC','2012000','2012000','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-260711-0020','D','2026-07-11','15:04:16','TBC','PENJUALAN','FJ-260711-0016','24696308564','2012000','24698320564','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='2012000' WHERE no_faktur_jual='FJ-260711-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0017','kasir',' 1',' 800K-18-10','TOKO','MMPER','PMM-ZGXF-17-0','CINCIN SILVER 925 ','','4.260','1','100.00','435000','0','0','17800','900000','0','0','0','900000','ALIKA','00044945','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGXF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PMM-ZGXF-17-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-260711-0017','2026-07-11','4.260','2026-07-11','15:04:16','PLG0013029','900000','900000','0','900000','0','kasir','2026-07-11 15:04:16','FJ-260711-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-07-11','FJ-260711-0017','2026-07-11','15:04:16','ALIKA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260711-0020','2026-07-11','2026-07-11 15:04:16','PENJUALAN : FJ-260711-0017','0','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-260711-0021','D','2026-07-11','15:04:16','TBC','PENJUALAN','FJ-260711-0017','24698320564','900000','24699220564','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='2912000' WHERE no_faktur_jual='FJ-260711-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-260711-0018','sby','1',' DP-02489SB','TOKO','SBYPSN','PSPLT-ZGXA-7-0','CINCIN PALADIUM','','2.600','1','17.00','584000','0','0','17800','1660000','0','0','0','1660000','VAN','00044867','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXA-7-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-260711-0018','2026-07-11','2.600','2026-07-11','15:16:54','PLG0013030','1660000','1660000','0','1660000','0','sby','2026-07-11 15:16:53','FJ-260711-0018','DP-02489','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0018','2026-07-11','15:16:54','VAN','1660000','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-260711-0021','2026-07-11','2026-07-11 15:16:53','PENJUALAN : FJ-260711-0018','','TBC','160000','160000','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-260711-0022','D','2026-07-11','15:16:54','TBC','PENJUALAN','FJ-260711-0018','24699220564','160000','24699380564','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='160000' WHERE no_faktur_jual='FJ-260711-0018' 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-02874','DIL','1','PER','WEDD RING PROMO','','','3.000','','925.00','1','100000','0','1500000','0','1500000','WANITA: SIZE 15 GRF: Fariz 14.08.26 (yaseva)','PRIA: SIZE 18 GRF: Tiwi 14.08.26 (yaseva)','CROM SESUAI FOTO','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-260711-0022','2026-07-11','2026-07-11 15:23:49','PESANAN : DP-02874','-','TBC','1600000','1600000');
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-260711-0023','D','2026-07-11','15:23:49','TBC','PESANAN','DP-02874','24699380564','1600000','24700980564','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-02874','2026-07-11','2026-07-11','15:23:49','PLG0013031','DIL','2026-08-07','sby','2026-07-11 15:23:49','3.000','0','0','0','1600000','0','0','1600000','1600000','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-02875','DIL','1','PER','WEDD RING PROMO','','','3.000','','925.00','1','100000','0','1500000','0','1500000','WANITA: SIZE 15 GRF: Fariz 14.08.26 (yaseva)','PRIA: SIZE 18 GRF: Tiwi 14.08.26 (yaseva)','CROM SESUAI FOTO','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-260711-0023','2026-07-11','2026-07-11 15:23:56','PESANAN : DP-02875','-','TBC','1600000','1600000');
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-260711-0024','D','2026-07-11','15:23:56','TBC','PESANAN','DP-02875','24700980564','1600000','24702580564','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-02875','2026-07-11','2026-07-11','15:23:56','PLG0013032','DIL','2026-08-07','sby','2026-07-11 15:23:56','3.000','0','0','0','1600000','0','0','1600000','1600000','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-260711-0019','kasirbip','1',' DP-02534BI','TOKO','BIPPSN','PSPLT-ZGXF-31-0','CINCIN PALADIUM ','','4.020','1','17.00','903000','0','0','17800','2907000','0','0','0','2907000','SAL','00044959','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXF-31-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-260711-0019','2026-07-11','4.020','2026-07-11','16:03:27','PLG0013033','2907000','2907000','0','2907000','0','kasirbip','2026-07-11 16:03:27','FJ-260711-0019','DP-02534','2320000');
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-07-11','FJ-260711-0019','2026-07-11','16:03:27','SAL','2907000','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-260711-0024','2026-07-11','2026-07-11 16:03:27','PENJUALAN : FJ-260711-0019','.','TBC','587000','587000','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-260711-0025','D','2026-07-11','16:03:27','TBC','PENJUALAN','FJ-260711-0019','24702580564','587000','24703167564','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='587000' WHERE no_faktur_jual='FJ-260711-0019' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260711-0002','1','PSPRT-ZGAX-8-0','1','2.260','2.260','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSPRT-ZGAX-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-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-07-11 16:24:02','TOKO','DUPSN','PSPRT','PSPRT-ZGAX-8-0','1','2.260','2.260','1','2.260','2.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0002','1','PSPRT-ZGAX-9-0','1','3.070','3.070','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSPRT-ZGAX-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:24:02','TOKO','DUPSN','PSPRT','PSPRT-ZGAX-9-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0002','1','PSPRT-ZGAX-10-0','1','2.490','2.490','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSPRT-ZGAX-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-10-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-07-11 16:24:02','TOKO','DUPSN','PSPRT','PSPRT-ZGAX-10-0','1','2.490','2.490','1','2.490','2.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0002','1','PSGT-ZGAX-11-0','1','2.300','2.300','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAX-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAX-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAX-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAX-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSGT-ZGAX-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAX-11-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-07-11 16:24:02','TOKO','DUPSN','PSGT','PSGT-ZGAX-11-0','1','2.300','2.300','1','2.300','2.300','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGAX-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAX-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0002','1','PSPLT-ZGAX-24-0','1','3.180','3.180','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAX-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAX-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAX-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSPLT-ZGAX-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAX-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:24:02','TOKO','DUPSN','PSPLT','PSPLT-ZGAX-24-0','1','3.180','3.180','1','3.180','3.180','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAX-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0002','1','PSPRT-ZGAX-30-0','1','5.010','5.010','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-11 16:24:02' WHERE kode_barang='PSPRT-ZGAX-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:24:02','TOKO','DUPSN','PSPRT','PSPRT-ZGAX-30-0','1','5.010','5.010','1','5.010','5.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260711-0002','2026-07-11','16:22','18.310','kasirbip','2026-07-11 16:24:01');
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-260711-0020','kasirbip','1',' DP-02583DU','TOKO','DUPSN','PSPRT-ZGAX-10-0','CINCIN PERAK ','','2.490','1','100.00','255000','0','0','17800','925000','0','0','0','925000','KUR','00045090','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGAX-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0020','2026-07-11','2.490','2026-07-11','16:28:27','PLG0013034','925000','925000','0','925000','0','kasirbip','2026-07-11 16:28:26','FJ-260711-0020','DP-02583','925000');
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-07-11','FJ-260711-0020','2026-07-11','16:28:27','KUR','925000','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-260711-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-260711-0021','kasirbip',' 1',' DP-02582DU','TOKO','DUPSN','PSPRT-ZGAX-9-0','CINCIN PERAK ','','3.070','1','100.00','314000','0','0','17800','925000','0','0','0','925000','KUR','00045089','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGAX-9-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-260711-0021','2026-07-11','3.070','2026-07-11','16:28:27','PLG0013035','925000','925000','0','925000','0','kasirbip','2026-07-11 16:28:26','FJ-260711-0020','DP-02582','925000');
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-07-11','FJ-260711-0021','2026-07-11','16:28:27','KUR','925000','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-260711-0021' LIMIT 1;
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02875';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02875';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02875';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260711-0002','K','2026-07-11','16:34:08','sby','PESANAN BATAL','DP-02875','25153200','0','25153200');
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-20260711-0003','1','PSGT-ZGAX-12-0','1','2.270','2.270','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGAX-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGAX-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGAX-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGAX-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSGT-ZGAX-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGAX-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSGT','PSGT-ZGAX-12-0','1','2.270','2.270','1','2.270','2.270','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGAX-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGAX-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPRT-ZGAX-13-0','1','4.530','4.530','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPRT-ZGAX-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-13-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-07-11 16:38:03','TOKO','SBYPSN','PSPRT','PSPRT-ZGAX-13-0','1','4.530','4.530','1','4.530','4.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPRT-ZGAX-14-0','1','3.670','3.670','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPRT-ZGAX-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-14-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-07-11 16:38:03','TOKO','SBYPSN','PSPRT','PSPRT-ZGAX-14-0','1','3.670','3.670','1','3.670','3.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPRT-ZGAX-15-0','1','3.550','3.550','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPRT-ZGAX-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-15-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-07-11 16:38:03','TOKO','SBYPSN','PSPRT','PSPRT-ZGAX-15-0','1','3.550','3.550','1','3.550','3.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPRT-ZGAX-16-0','1','2.980','2.980','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGAX-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGAX-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGAX-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPRT-ZGAX-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGAX-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSPRT','PSPRT-ZGAX-16-0','1','2.980','2.980','1','2.980','2.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGAX-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGAX-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPLT-ZGAX-17-0','1','3.120','3.120','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAX-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAX-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAX-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPLT-ZGAX-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAX-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSPLT','PSPLT-ZGAX-17-0','1','3.120','3.120','1','3.120','3.120','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAX-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPLT-ZGAX-18-0','1','3.480','3.480','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAX-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAX-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAX-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPLT-ZGAX-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAX-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSPLT','PSPLT-ZGAX-18-0','1','3.480','3.480','1','3.480','3.480','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAX-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPLT-ZGAX-19-0','1','2.550','2.550','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAX-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAX-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAX-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPLT-ZGAX-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAX-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSPLT','PSPLT-ZGAX-19-0','1','2.550','2.550','1','2.550','2.550','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGAX-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' 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-20260711-0003','1','PSPLT-ZGAX-29-0','1','2.200','2.200','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGAX-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGAX-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGAX-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-11 16:38:03' WHERE kode_barang='PSPLT-ZGAX-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGAX-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-11 16:38:03','TOKO','SBYPSN','PSPLT','PSPLT-ZGAX-29-0','1','2.200','2.200','1','2.200','2.200','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-ZGAX-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGAX-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-11' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260711-0003','2026-07-11','16:37','28.350','sby','2026-07-11 16:38: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-260711-0022','kasir','1',' 950K-85-98','TOKO','MMPER','PMM-ZEBA-28-0','CINCIN SILVER 925 ','','1.760','1','100.00','180000','0','0','17800','1100000','0','0','0','1100000','ELLA','00043707','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZEBA-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PMM-ZEBA-28-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-260711-0022','2026-07-11','1.760','2026-07-11','16:40:14','PLG0013036','1100000','1100000','0','1100000','0','kasir','2026-07-11 16:40:13','FJ-260711-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-07-11','FJ-260711-0022','2026-07-11','16:40:14','ELLA','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260711-0025','2026-07-11','2026-07-11 16:40:13','PENJUALAN : FJ-260711-0022','0','TBC','1100000','1100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0026','D','2026-07-11','16:40:14','TBC','PENJUALAN','FJ-260711-0022','24703167564','1100000','24704267564','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='1100000' WHERE no_faktur_jual='FJ-260711-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-260711-0023','kasir',' 1',' 800K-16-10','TOKO','MMPER','PMM-ZGXF-16-0','CINCIN SILVER 925 ','','4.470','1','100.00','456000','0','0','17800','950000','0','0','0','950000','ELLA','00044944','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGXF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.470',berat_jual_asli=berat_jual_asli+'4.470',stock_jual='1',berat_akhir=berat_akhir-'4.470',berat_akhir_asli=berat_akhir_asli-'4.470',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PMM-ZGXF-16-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-260711-0023','2026-07-11','4.470','2026-07-11','16:40:14','PLG0013037','950000','950000','0','950000','0','kasir','2026-07-11 16:40:13','FJ-260711-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-07-11','FJ-260711-0023','2026-07-11','16:40:14','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-260711-0026','2026-07-11','2026-07-11 16:40:13','PENJUALAN : FJ-260711-0023','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-260711-0027','D','2026-07-11','16:40:14','TBC','PENJUALAN','FJ-260711-0023','24704267564','950000','24705217564','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='2050000' WHERE no_faktur_jual='FJ-260711-0023' 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-02876','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz 13 putih doff semprot 1 zirkon','font vladimir grf Atikah','model sprt contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0027','2026-07-11','2026-07-11 16:47:03','PESANAN : DP-02876','.','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-260711-0028','D','2026-07-11','16:47:03','TBC','PESANAN','DP-02876','24705217564','950000','24706167564','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-02876','2026-07-11','2026-07-11','16:47:03','PLG0013038','KUR','2026-07-25','kasirbip','2026-07-11 16:47:03','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-11 ','16:47:19');
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-02877','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz 13 putih glossy 1 zirkon','font vladimir grf Tantan','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0028','2026-07-11','2026-07-11 16:50:11','PESANAN : DP-02877','.','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-260711-0029','D','2026-07-11','16:50:11','TBC','PESANAN','DP-02877','24706167564','950000','24707117564','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-02877','2026-07-11','2026-07-11','16:50:11','PLG0013039','KUR','2026-07-31','kasirbip','2026-07-11 16:50:11','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02878','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','850000','size 19 grf Shinta','warna putih doff amplas','express 100.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0029','2026-07-11','2026-07-11 16:53:16','PESANAN : DP-02878','0','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-260711-0030','D','2026-07-11','16:53:16','TBC','PESANAN','DP-02878','24707117564','850000','24707967564','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-02878','2026-07-11','2026-07-11','16:53:16','PLG0013040','ALIKA','2026-07-24','kasir','2026-07-11 16:53:16','4.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0023';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','16:58:24');
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-07-11',  status ='CLOS' WHERE no_service='SV-02151';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02151';
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-260711-0024','kasirbip','1',' 750K-14-00','TOKO','DUPERBDG','LXPER-ZGXF-76-0','CINCIN SILVER 925 ','','2.020','1','100.00','207000','0','0','17800','850000','0','0','0','850000','PUT','00045004','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGXF-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZGXF-76-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-260711-0024','2026-07-11','2.020','2026-07-11','17:00:14','PLG0013041','850000','850000','0','850000','0','kasirbip','2026-07-11 17:00:13','FJ-260711-0024','','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-07-11','FJ-260711-0024','2026-07-11','17:00:14','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-260711-0030','2026-07-11','2026-07-11 17:00:13','PENJUALAN : FJ-260711-0024','.','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-260711-0031','D','2026-07-11','17:00:14','TBC','PENJUALAN','FJ-260711-0024','24707967564','850000','24708817564','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-260711-0024' 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-260711-0025','kasirbip',' 1',' 500K-18-00','TOKO','DUPERBDG','LXPER-ZFAF-37-0','CINCIN SILVER 925 YL-01 ','','1.970','1','100.00','201000','0','0','17800','600000','0','0','0','600000','PUT','00044467','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAF-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZFAF-37-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-260711-0025','2026-07-11','1.970','2026-07-11','17:00:14','PLG0013042','600000','600000','0','600000','0','kasirbip','2026-07-11 17:00:13','FJ-260711-0024','','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-07-11','FJ-260711-0025','2026-07-11','17:00:14','PUT','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-260711-0031','2026-07-11','2026-07-11 17:00:13','PENJUALAN : FJ-260711-0025','.','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-260711-0032','D','2026-07-11','17:00:14','TBC','PENJUALAN','FJ-260711-0025','24708817564','600000','24709417564','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='1450000' WHERE no_faktur_jual='FJ-260711-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0025';
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-260711-0026','kasirbip','1',' DP-02665DU','TOKO','DUPSN','PSPRT-ZGXC-7-0','CINCIN PERAK ','','2.560','1','100.00','262000','0','0','17800','850000','0','0','0','850000','PUT','00044911','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXC-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGXC-7-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-260711-0026','2026-07-11','2.560','2026-07-11','17:19:27','PLG0013043','850000','850000','0','850000','0','kasirbip','2026-07-11 17:19:27','FJ-260711-0026','DP-02665','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-07-11','FJ-260711-0026','2026-07-11','17:19:27','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-260711-0026' 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-260711-0027','kasirbip',' 1',' DP-02664DU','TOKO','DUPSN','PSPRT-ZGXA-23-0','CINCIN PERAK ','','2.360','1','100.00','241000','0','0','17800','900000','0','0','0','900000','PUT','00044883','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXA-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGXA-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0027','2026-07-11','2.360','2026-07-11','17:19:27','PLG0013044','900000','900000','0','900000','0','kasirbip','2026-07-11 17:19:27','FJ-260711-0026','DP-02664','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0027','2026-07-11','17:19:27','PUT','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260711-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0027';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','17:29:01');
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-260711-0028','kasir','1',' DP-02571MM','TOKO','MMPSN','PSPLT-ZFBI-37-0','CINCIN PALADIUM ','','1.060','1','17.00','239000','0','0','17800','1071000','0','0','0','1071000','ELLA','00044828','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZFBI-37-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-260711-0028','2026-07-11','1.060','2026-07-11','17:31:26','PLG0013045','1071000','1071000','0','1071000','-49000','kasir','2026-07-11 17:31:25','FJ-260711-0028','DP-02571','1120000');
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-07-11','FJ-260711-0028','2026-07-11','17:31:26','ELLA','1071000','0');
UPDATE tt_jual_head SET dibayar_rp='-49000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260711-0028' 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-02879','DIL','1','PLD','WEDD RING PRIA','','','3.500','','25.00','1','1200000','550000','0','700000','2625000','SIZE 20 GRF: Melinda ?? (vintage)','CROM PUTIH GLOSSY MIX DOFF','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0032','2026-07-11','2026-07-11 17:36:51','PESANAN : DP-02879','-','TBC','1800000','1800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0033','D','2026-07-11','17:36:51','TBC','PESANAN','DP-02879','24709417564','1800000','24711217564','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-02879','2026-07-11','2026-07-11','17:36:51','PLG0013046','DIL','2026-08-10','sby','2026-07-11 17:36:51','3.500','0','0','0','1800000','0','700000','2625000','2625000','825000');
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-02880','DIL','1','PLD','WEDD RING WANITA','','','2.500','','25.00','1','1200000','550000','0','750000','2125000','PERMATA 7 BUTIR','SIZE 13 GRF: Arfanni ?? (vintage)','CROM PUTIH GLOSSY','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0033','2026-07-11','2026-07-11 17:39:01','PESANAN : DP-02880','-','TBC','1500000','1500000');
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-260711-0034','D','2026-07-11','17:39:01','TBC','PESANAN','DP-02880','24711217564','1500000','24712717564','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-02880','2026-07-11','2026-07-11','17:39:01','PLG0013047','DIL','2026-08-10','sby','2026-07-11 17:39:01','2.500','0','0','0','1500000','0','750000','2195000','2195000','695000');
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-02881','ELLA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2290000','2250000','0','850000','6475000','size 16','warna crom putih glosy','zircone 9 butir','0','0','90000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0034','2026-07-11','2026-07-11 17:46:02','PESANAN : DP-02881','0','TBC','5252000','5252000');
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-260711-0035','D','2026-07-11','17:46:02','TBC','PESANAN','DP-02881','24712717564','5252000','24717969564','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-02881','2026-07-11','2026-07-11','17:46:02','PLG0013048','ELLA','2026-08-10','kasir','2026-07-11 17:46:02','2.500','0','0','0','5252000','0','850000','6565000','6565000','1313000');
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-02882','ELLA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2290000','2250000','0','750000','6375000','size 16','zircone 1 butir','warna putih doff semprot sesuai model','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0035','2026-07-11','2026-07-11 17:49:00','PESANAN : DP-02882','0','TBC','5100000','5100000');
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-260711-0036','D','2026-07-11','17:49:00','TBC','PESANAN','DP-02882','24717969564','5100000','24723069564','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-02882','2026-07-11','2026-07-11','17:49:00','PLG0013049','ELLA','2026-08-10','kasir','2026-07-11 17:49:00','2.500','0','0','0','5100000','0','750000','6375000','6375000','1275000');
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-02883','ELLA','1','PLD','WEDDING RING','','','5.000','','10.00','1','1200000','350000','0','750000','2500000','size 21.5','warna putih doff semprot sesuai model','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0036','2026-07-11','2026-07-11 17:51:34','PESANAN : DP-02883','0','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0037','D','2026-07-11','17:51:34','TBC','PESANAN','DP-02883','24723069564','2000000','24725069564','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-02883','2026-07-11','2026-07-11','17:51:34','PLG0013050','ELLA','2026-08-10','kasir','2026-07-11 17:51:34','5.000','0','0','0','2000000','0','750000','2500000','2500000','500000');
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-07-11',  status ='CLOS' WHERE no_service='SV-02157';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02157';
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-02884','ALIKA','1','GOLD','WEDING RING','','','2.500','','375.00','1','2290000','1400000','0','800000','4300000','size 15 grf Ferdi','crom full gold EXP 100K','zircone 27 butir','0','0','270000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0037','2026-07-11','2026-07-11 18:00:05','PESANAN : DP-02884','0','TBC','3656000','3656000');
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-260711-0038','D','2026-07-11','18:00:05','TBC','PESANAN','DP-02884','24725069564','3656000','24728725564','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-02884','2026-07-11','2026-07-11','18:00:05','PLG0013051','ALIKA','2026-07-24','kasir','2026-07-11 18:00:05','2.500','0','0','0','3656000','0','800000','4570000','4570000','914000');
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-260711-0029','kasirbip','1',' DP-02608BI','TOKO','BIPPSN','PSPLT-ZGXH-28-0','CINCIN PALADIUM ','','2.150','1','17.00','483000','0','0','17800','1452500','0','0','0','1452500','SULIS','00045073','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPLT-ZGXH-28-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-260711-0029','2026-07-11','2.150','2026-07-11','18:06:52','PLG0013052','1452500','1452500','0','1452500','0','kasirbip','2026-07-11 18:06:51','FJ-260711-0029','DP-02608','1300000');
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-07-11','FJ-260711-0029','2026-07-11','18:06:52','SULIS','1452500','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-260711-0038','2026-07-11','2026-07-11 18:06:51','PENJUALAN : FJ-260711-0029','.','TBC','152500','152500','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-260711-0039','D','2026-07-11','18:06:52','TBC','PENJUALAN','FJ-260711-0029','24728725564','152500','24728878064','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='152500' WHERE no_faktur_jual='FJ-260711-0029' 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-260711-0030','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-XAAI-123-0','THIFA CINCIN MAS RG ','','1.280','1','85.00','2517000','0','0','17800','2600000','0','0','0','2600000','FIR','00026146','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-XAAI-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='TFCMR-XAAI-123-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-260711-0030','2026-07-11','1.280','2026-07-11','18:08:42','PLG0013053','2600000','2600000','0','2600000','0','kasir','2026-07-11 18:08:41','FJ-260711-0030','','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-07-11','FJ-260711-0030','2026-07-11','18:08:42','FIR','2600000','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-260711-0039','2026-07-11','2026-07-11 18:08:41','PENJUALAN : FJ-260711-0030','.','TBC','2600000','2600000','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-260711-0040','D','2026-07-11','18:08:42','TBC','PENJUALAN','FJ-260711-0030','24728878064','2600000','24731478064','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='2600000' WHERE no_faktur_jual='FJ-260711-0030' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-11 ','18:11:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-11 ','18:11:57');
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-260711-0031','sby','1',' 850K-105-0','TOKO','SBYPER','PSBY-ZEXE-73-0','CINCIN SILVER 925 ','','1.410','1','100.00','144000','0','0','17800','950000','0','0','0','950000','VAN','00043269','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSBY-ZEXE-73-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-260711-0031','2026-07-11','1.410','2026-07-11','18:13:44','PLG0013054','950000','950000','0','950000','0','sby','2026-07-11 18:13:44','FJ-260711-0031','','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-07-11','FJ-260711-0031','2026-07-11','18:13:44','VAN','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-260711-0040','2026-07-11','2026-07-11 18:13:44','PENJUALAN : FJ-260711-0031','','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-260711-0041','D','2026-07-11','18:13:44','TBC','PENJUALAN','FJ-260711-0031','24731478064','950000','24732428064','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-260711-0031' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0030';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-11 ','19:17:19');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260711-0003','K','2026-07-11','19:19:23','kasir','KAS BESAR','SALAH INPUT','25153200','560000','24593200');
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-02885','VAN','1','PER','WEDDRING SEPAKET 950K','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE WANITA: 7.5 SIZE PRIA: 16.5','GRF WANITA: Dedi 26-11-26 FONT: VLADIMIR','GRF PRIA: Anggita 26-11-26 PUTIH','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-260711-0041','2026-07-11','2026-07-11 19:23:49','PESANAN : DP-02885','-','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-260711-0042','D','2026-07-11','19:23:49','TBC','PESANAN','DP-02885','24732428064','950000','24733378064','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-02885','2026-07-11','2026-07-11','19:23:49','PLG0013055','VAN','2026-08-03','sby','2026-07-11 19:23:49','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02886','NAD','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','1500000','2550000','zircon 7 dibuat 1 zircon tengah nya 7','sz 15 lebar 4-5mm crom putih gllosy','grf Hendri .. Adlyn Font Berkshire','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0042','2026-07-11','2026-07-11 19:28:06','PESANAN : DP-02886','.','TBC','2096000','2096000');
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-260711-0043','D','2026-07-11','19:28:06','TBC','PESANAN','DP-02886','24733378064','2096000','24735474064','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-02886','2026-07-11','2026-07-11','19:28:06','PLG0013056','NAD','2026-08-10','kasirbip','2026-07-11 19:28:06','3.000','0','0','0','2096000','0','1500000','2620000','2620000','524000');
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-02887','NAD','1','PLD','WEDRING','','','4.000','','10.00','1','1200000','350000','0','1500000','2900000','sz 20 lebar 5-6mm crom putih gllosy','grf Adlyn .. Hendri Font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0043','2026-07-11','2026-07-11 19:32:33','PESANAN : DP-02887','.','TBC','2320000','2320000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0044','D','2026-07-11','19:32:33','TBC','PESANAN','DP-02887','24735474064','2320000','24737794064','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-02887','2026-07-11','2026-07-11','19:32:33','PLG0013057','NAD','2026-08-10','kasirbip','2026-07-11 19:32:33','4.000','0','0','0','2320000','0','1500000','2900000','2900000','580000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260711-0032','kasirbip','1',' DP-02735DU','TOKO','DUPSN','PSPRT-ZGXF-26-0','CINCIN PERAK ','','1.970','1','100.00','201000','0','0','17800','850000','0','0','0','850000','PUT','00044954','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXF-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSPRT-ZGXF-26-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-260711-0032','2026-07-11','1.970','2026-07-11','19:36:17','PLG0013058','850000','850000','0','850000','0','kasirbip','2026-07-11 19:36:16','FJ-260711-0032','DP-02735','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-07-11','FJ-260711-0032','2026-07-11','19:36:17','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-260711-0032' 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-260711-0033','kasirbip',' 1',' DP-02736DU','TOKO','DUPSN','PSPRT-ZGAX-8-0','CINCIN PERAK ','','2.260','1','100.00','232000','0','0','17800','1200000','0','0','0','1200000','PUT','00045088','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-8-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-07-11' AND kode_barang='PSPRT-ZGAX-8-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-260711-0033','2026-07-11','2.260','2026-07-11','19:36:17','PLG0013059','1200000','1200000','0','1200000','0','kasirbip','2026-07-11 19:36:16','FJ-260711-0032','DP-02736','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-11','FJ-260711-0033','2026-07-11','19:36:17','PUT','1200000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260711-0033' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0033';
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-02888','SAL','1','GOLD','WED RING','','','1.900','','37.50','1','2290000','1400000','0','950000','3610000','sz 9 rosegold glossy 17 zirkon 170.000','model sprt contoh','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0044','2026-07-11','2026-07-11 19:38:44','PESANAN : DP-02888','.','TBC','3024000','3024000');
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-260711-0045','D','2026-07-11','19:38:44','TBC','PESANAN','DP-02888','24737794064','3024000','24740818064','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-02888','2026-07-11','2026-07-11','19:38:44','PLG0013060','SAL','2026-08-07','kasirbip','2026-07-11 19:38:44','1.900','0','0','0','3024000','0','950000','3610000','3610000','586000');
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-260711-0034','kasirbip','1',' 700K-16-00','TOKO','DUPERBDG','LXPER-ZCXB-7-0','CINCIN SILVER 925 ','','1.550','1','100.00','159000','0','0','17800','800000','0','0','0','800000','PUT','00042068','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZCXB-7-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-260711-0034','2026-07-11','1.550','2026-07-11','19:57:59','PLG0013061','800000','800000','0','800000','0','kasirbip','2026-07-11 19:57:58','FJ-260711-0034','','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-07-11','FJ-260711-0034','2026-07-11','19:57:59','PUT','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-260711-0045','2026-07-11','2026-07-11 19:57:58','PENJUALAN : FJ-260711-0034','.','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-260711-0046','D','2026-07-11','19:57:59','TBC','PENJUALAN','FJ-260711-0034','24740818064','800000','24741618064','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-260711-0034' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0034';
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-02889','ELLA','1','PER','CINCIN PROMO CM01 SLV','','','2.000','','925.00','1','100000','0','0','0','1200000','CWE SIZE 13 GRF HERY & FITRI ZIRCONE 1 BTR','CWO SIZE 20 GRF FITRI & HERY','WARNA CROM PUTIH SESUAI MODEL EXP 200K','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0046','2026-07-11','2026-07-11 19:59:52','PESANAN : DP-02889','0','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-260711-0047','D','2026-07-11','19:59:52','TBC','PESANAN','DP-02889','24741618064','1200000','24742818064','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-02889','2026-07-11','2026-07-11','19:59:52','PLG0013062','ELLA','2026-07-24','kasir','2026-07-11 19:59:52','2.000','0','0','0','1200000','0','0','1200000','1200000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-11 ','20:14:34');
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-02890','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE WANITA: 16.5','GRF : Pendik ??','FONT: VLADIMIR FINISHING: ROSE GOLD GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0047','2026-07-11','2026-07-11 20:17:46','PESANAN : DP-02890','-','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-260711-0048','D','2026-07-11','20:17:46','TBC','PESANAN','DP-02890','24742818064','900000','24743718064','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-02890','2026-07-11','2026-07-11','20:17:46','PLG0013063','VAN','2026-07-31','sby','2026-07-11 20:17:46','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-260711-0035','kasirbip','1',' 700K-125-0','TOKO','DUPERBDG','LXPER-ZCXB-44-0','CINCIN SILVER 925 ','','2.480','1','100.00','253000','0','0','17800','800000','0','0','0','800000','NAD','00042105','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZCXB-44-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-260711-0035','2026-07-11','2.480','2026-07-11','20:18:55','PLG0013064','800000','800000','0','800000','0','kasirbip','2026-07-11 20:18:54','FJ-260711-0035','','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-07-11','FJ-260711-0035','2026-07-11','20:18:55','NAD','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-260711-0048','2026-07-11','2026-07-11 20:18:54','PENJUALAN : FJ-260711-0035','.','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-260711-0049','D','2026-07-11','20:18:55','TBC','PENJUALAN','FJ-260711-0035','24743718064','800000','24744518064','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-260711-0035' 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-260711-0036','kasirbip',' 1',' 1.1K-14-00','TOKO','DUPERBDG','LXPER-ZDBH-40-0','CINCIN SILVER 925 ','','2.680','1','100.00','274000','0','0','17800','1200000','0','0','0','1200000','NAD','00042856','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDBH-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='LXPER-ZDBH-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0036','2026-07-11','2.680','2026-07-11','20:18:55','PLG0013065','1200000','1200000','0','1200000','0','kasirbip','2026-07-11 20:18:54','FJ-260711-0035','','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-07-11','FJ-260711-0036','2026-07-11','20:18:55','NAD','1200000','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-260711-0049','2026-07-11','2026-07-11 20:18:54','PENJUALAN : FJ-260711-0036','.','TBC','1200000','1200000','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-260711-0050','D','2026-07-11','20:18:55','TBC','PENJUALAN','FJ-260711-0036','24744518064','1200000','24745718064','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='2000000' WHERE no_faktur_jual='FJ-260711-0036' 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-02891','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE PRIA: 21','GRF: Yevinta?? FONT: VLADIMIR','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0050','2026-07-11','2026-07-11 20:20:21','PESANAN : DP-02891','-','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-260711-0051','D','2026-07-11','20:20:21','TBC','PESANAN','DP-02891','24745718064','850000','24746568064','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-02891','2026-07-11','2026-07-11','20:20:21','PLG0013066','VAN','2026-07-31','sby','2026-07-11 20:20:21','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0035';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0036';
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-260711-0037','sby','1',' DP-02533SB','TOKO','SBYPSN','PSGT-ZGXA-15-0','CINCIN EMAS ','','1.930','1','45.00','2021000','0','0','17800','4005000','0','0','0','4005000','DIL','00044875','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGXA-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-07-11' AND kode_barang='PSGT-ZGXA-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260711-0037','2026-07-11','1.930','2026-07-11','20:34:12','PLG0013067','4005000','4005000','0','4005000','0','sby','2026-07-11 20:34:12','FJ-260711-0037','DP-02533','3400000');
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-07-11','FJ-260711-0037','2026-07-11','20:34:12','DIL','4005000','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-260711-0051','2026-07-11','2026-07-11 20:34:12','PENJUALAN : FJ-260711-0037','','TBC','605000','605000','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-260711-0052','D','2026-07-11','20:34:12','TBC','PENJUALAN','FJ-260711-0037','24746568064','605000','24747173064','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='605000' WHERE no_faktur_jual='FJ-260711-0037' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260711-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260711-0037';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-11';
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-07-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-11' 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-260712-0001','D','2026-07-12','21:13:02','TBC','SALDO AWAL','SALDO AWAL','0','24747173064','24747173064');
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-260712-0001','D','2026-07-12','21:13:02','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
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-260712-0001','D','2026-07-12','21:13:02','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260712-0001','D','2026-07-12','21:13:02','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260712-0001','D','2026-07-12','21:13:02','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-260712-0001','D','2026-07-12','21:13:02','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-260712-0001','D','2026-07-12','21:13:02','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260712-0001','D','2026-07-12','21:13:02','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-260712-0001','D','2026-07-12','21:13:02','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-260712-0001','D','2026-07-12','21:13:02','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-260712-0001','D','2026-07-12','21:13:02','','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-260712-0001','D','2026-07-12','21:13:02','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-07-12';
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-02892','DIL','1','PLD','WEDD RING PRIA','','','5.500','','25.00','1','1200000','550000','0','850000','3875000','PERMATA 2 BUTIR','SIZE 19.5 GRF: Lina ?? 11.11.26 (BERKSHIRE)','CROM PUTIH GLOSSY','20000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0052','2026-07-11','2026-07-11 21:17:02','PESANAN : DP-02892','-','TBC','2700000','2700000');
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-260711-0001','D','2026-07-11','21:17:02','TBC','PESANAN','DP-02892','0','2700000','2700000','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-02892','2026-07-11','2026-07-11','21:17:02','PLG0013068','DIL','2026-08-10','sby','2026-07-11 21:17:02','5.500','0','0','0','2700000','0','850000','3895000','3895000','1195000');
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-02893','DIL','1','PLD','WEDD RING WANITA','','','3.500','','25.00','1','1200000','550000','0','1300000','3225000','PERMATA 15 BUTIR','SIZE 12.5 GRF: Syahrul ?? 11.11.26 (BERKSHIRE)','CROM PUTIH GLOSSY','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0053','2026-07-11','2026-07-11 21:19:31','PESANAN : DP-02893','-','TBC','2300000','2300000');
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-260711-0002','D','2026-07-11','21:19:31','TBC','PESANAN','DP-02893','2700000','2300000','5000000','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-02893','2026-07-11','2026-07-11','21:19:31','PLG0013069','DIL','2026-08-10','sby','2026-07-11 21:19:31','3.500','0','0','0','2300000','0','1300000','3375000','3375000','1075000');
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-02894','VAN','1','PER','WEDDRING WANITA','','','2.500','','25.00','1','100000','550000','0','900000','2275000','PERMATA 19','GRF: CHANDRA ?? FONT: YESEVA ONE','PUTIH GLOSSY SIZE: 12','190000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0054','2026-07-11','2026-07-11 21:29:31','PESANAN : DP-02894','-','TBC','1700000','1700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260711-0003','D','2026-07-11','21:29:31','TBC','PESANAN','DP-02894','5000000','1700000','6700000','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-02894','2026-07-11','2026-07-11','21:29:31','PLG0013070','VAN','2026-08-03','sby','2026-07-11 21:29:31','2.500','0','0','0','1700000','0','900000','2465000','2465000','765000');
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-02895','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','PERMATA 1','SIZE: 20 GRF: ZAKIYAH ??','FONT: YESEVA FINISHING: PUTIH DOFF MIX GLOSSY','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260711-0055','2026-07-11','2026-07-11 21:33:01','PESANAN : DP-02895','-','TBC','1500000','1500000');
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-260711-0004','D','2026-07-11','21:33:01','TBC','PESANAN','DP-02895','6700000','1500000','8200000','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-02895','2026-07-11','2026-07-11','21:33:01','PLG0013071','VAN','2026-08-03','sby','2026-07-11 21:33:01','4.000','0','0','0','1500000','0','800000','2210000','2210000','710000');