INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','09:02:18');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250912-0001','1','LMT25-YIAB-4-0','1','25.000','25.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT25-YIAB-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT25-YIAB-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT25-YIAB-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT25-YIAB-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2025-09-12 09:02:29' WHERE kode_barang='LMT25-YIAB-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT25-YIAB-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 ('2025-09-12 09:02:29','TOKO','TFLM','LMT25','LMT25-YIAB-4-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LMT25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT25-YIAB-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT25-YIAB-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-12' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250912-0001','2025-09-12','09:02','25.000','kasir','2025-09-12 09:02:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','09:55:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','11:54:53');
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-250912-0001','kasir','1',' DP-00890BI','TOKO','BIPPSN','PSPLT-YGBI-45-0','CINCIN PALADIUM ','','1.540','1','7.00','207000','0','0','16500','1085000','0','0','0','1085000','HELMI','00037681','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YGBI-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSPLT-YGBI-45-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-250912-0001','2025-09-12','1.540','2025-09-12','11:56:08','PLG0006317','1085000','1085000','0','1085000','0','kasir','2025-09-12 11:56:08','FJ-250912-0001','DP-00890','725000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0001','2025-09-12','11:56:08','HELMI','1085000','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-250912-0002','2025-09-12','2025-09-12 11:56:08','PENJUALAN : FJ-250912-0001','.','TBC','360000','360000','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-250912-0003','D','2025-09-12','11:56:08','TBC','PENJUALAN','FJ-250912-0001','16342699064','360000','16343059064','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='360000' WHERE no_faktur_jual='FJ-250912-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250912-0002','kasir',' 1',' DP-00889BI','TOKO','BIPPSN','PSPLT-YGCA-7-0','CINCIN PALADIUM ','','1.210','1','7.00','163000','0','0','16500','1202500','0','0','0','1202500','HELMI','00037809','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YGCA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSPLT-YGCA-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0002','2025-09-12','1.210','2025-09-12','11:56:08','PLG0006318','1202500','1202500','0','1202500','0','kasir','2025-09-12 11:56:08','FJ-250912-0001','DP-00889','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0002','2025-09-12','11:56:08','HELMI','1202500','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-250912-0003','2025-09-12','2025-09-12 11:56:08','PENJUALAN : FJ-250912-0002','.','TBC','502500','502500','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-250912-0004','D','2025-09-12','11:56:08','TBC','PENJUALAN','FJ-250912-0002','16343059064','502500','16343561564','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='862500' WHERE no_faktur_jual='FJ-250912-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01250','HELMI','1','CC SLV','GRF','1.760','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01250','2025-09-12','2025-09-12','12:30:37','PLG0006319','kasir','2025-09-13','kasir','2025-09-12 12:30:37','1.760','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-12 ','13:19:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','13:20:06');
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-250912-0003','kasir','1',' 850K-155-1','TOKO','BIPPER','PBDG-YHBI-11-0','CINCIN SILVER 925 ','','2.450','1','100.00','63000','0','0','16500','599000','0','0','0','599000','HELMI','00038362','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHBI-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PBDG-YHBI-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0003','2025-09-12','2.450','2025-09-12','13:51:54','PLG0006320','599000','599000','0','599000','0','kasir','2025-09-12 13:51:54','FJ-250912-0003','','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('2025-09-12','FJ-250912-0003','2025-09-12','13:51:54','HELMI','599000','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-250912-0004','2025-09-12','2025-09-12 13:51:54','PENJUALAN : FJ-250912-0003','.','TBC','599000','599000','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-250912-0005','D','2025-09-12','13:51:54','TBC','PENJUALAN','FJ-250912-0003','16343561564','599000','16344160564','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='599000' WHERE no_faktur_jual='FJ-250912-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0003';
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-250912-0004','kasir','1',' DP-01022BI','TOKO','BIPPSN','PSGT-YIXD-10-0','CINCIN EMAS ','','2.100','1','83.00','3290000','0','0','16500','4123000','0','0','0','4123000','HELMI','00038528','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YIXD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSGT-YIXD-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0004','2025-09-12','2.100','2025-09-12','14:43:55','PLG0006321','4123000','4123000','0','4123000','0','kasir','2025-09-12 14:43:54','FJ-250912-0004','DP-01022','3150000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0004','2025-09-12','14:43:55','HELMI','4123000','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-250912-0005','2025-09-12','2025-09-12 14:43:54','PENJUALAN : FJ-250912-0004','.','TBC','973000','973000','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-250912-0006','D','2025-09-12','14:43:55','TBC','PENJUALAN','FJ-250912-0004','16344160564','973000','16345133564','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='973000' WHERE no_faktur_jual='FJ-250912-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-250912-0005','kasir',' 1',' DP-01023BI','TOKO','BIPPSN','PSPLT-YIXD-11-0','CINCIN PALADIUM ','','4.440','1','7.00','634000','0','0','16500','1810000','0','0','0','1810000','HELMI','00038529','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIXD-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.440',berat_jual_asli=berat_jual_asli+'4.440',stock_jual='1',berat_akhir=berat_akhir-'4.440',berat_akhir_asli=berat_akhir_asli-'4.440',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSPLT-YIXD-11-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-250912-0005','2025-09-12','4.440','2025-09-12','14:43:55','PLG0006322','1810000','1810000','0','1810000','0','kasir','2025-09-12 14:43:54','FJ-250912-0004','DP-01023','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('2025-09-12','FJ-250912-0005','2025-09-12','14:43:55','HELMI','1810000','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-250912-0006','2025-09-12','2025-09-12 14:43:54','PENJUALAN : FJ-250912-0005','.','TBC','960000','960000','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-250912-0007','D','2025-09-12','14:43:55','TBC','PENJUALAN','FJ-250912-0005','16345133564','960000','16346093564','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='1933000' WHERE no_faktur_jual='FJ-250912-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-12 ','15:56:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','16:40:44');
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-20250912-0002','1','PSGT-YIAA-7-0','1','2.720','2.720','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YIAA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YIAA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YIAA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YIAA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-12 16:40:54' WHERE kode_barang='PSGT-YIAA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YIAA-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 ('2025-09-12 16:40:54','TOKO','MMPSN','PSGT','PSGT-YIAA-7-0','1','2.720','2.720','1','2.720','2.720','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YIAA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YIAA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-12' 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-20250912-0002','1','PSGT-YIAB-1-0','1','2.890','2.890','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YIAB-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YIAB-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YIAB-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YIAB-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-12 16:40:54' WHERE kode_barang='PSGT-YIAB-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YIAB-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-12 16:40:54','TOKO','MMPSN','PSGT','PSGT-YIAB-1-0','1','2.890','2.890','1','2.890','2.890','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YIAB-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YIAB-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-12' 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-20250912-0002','1','PSPLT-YIAB-11-0','1','3.090','3.090','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YIAB-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YIAB-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YIAB-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YIAB-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-12 16:40:54' WHERE kode_barang='PSPLT-YIAB-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YIAB-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 ('2025-09-12 16:40:54','TOKO','MMPSN','PSPLT','PSPLT-YIAB-11-0','1','3.090','3.090','1','3.090','3.090','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-YIAB-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YIAB-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-12' 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-20250912-0002','1','PSPLT-YIAB-12-0','1','4.480','4.480','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YIAB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YIAB-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YIAB-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YIAB-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-12 16:40:54' WHERE kode_barang='PSPLT-YIAB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YIAB-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 ('2025-09-12 16:40:54','TOKO','MMPSN','PSPLT','PSPLT-YIAB-12-0','1','4.480','4.480','1','4.480','4.480','7.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-YIAB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YIAB-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-12' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250912-0002','2025-09-12','16:40','13.180','kasir','2025-09-12 16:40:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','16:54:21');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01251','HELMI','1','SEPASANG SILVER','FONT VINTAGE ROTTER','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01251','2025-09-12','2025-09-12','16:55:02','PLG0006323','kasir','2025-09-23','kasir','2025-09-12 16:55:02','2.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01094','ZAHRA','1','GOLD','WEDDING RING','','','3.000','','75.00','1','1910000','1730000','0','750000','5940000','zirkon 21btr','size 15 krum ttp pth spt cth','grf ALFI NM 101025','200000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250912-0007','2025-09-12','2025-09-12 17:04:48','PESANAN : DP-01094','-','TBC','5000000','5000000');
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-250912-0008','D','2025-09-12','17:04:48','TBC','PESANAN','DP-01094','16346093564','5000000','16351093564','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-01094','2025-09-12','2025-09-12','17:04:48','PLG0006324','ZAHRA','2025-09-26','kasir','2025-09-12 17:04:48','3.000','0','0','0','5000000','0','750000','6140000','6140000','1140000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','18:14:28');
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-250912-0006','kasir','1',' DP-01011MM','TOKO','MMPSN','PSPLT-YIXC-2-0','CINCIN PALADIUM ','','4.600','1','17.00','1574000','0','0','16500','2780000','0','0','0','2780000','NIS','00038507','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIXC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.600',berat_jual_asli=berat_jual_asli+'4.600',stock_jual='1',berat_akhir=berat_akhir-'4.600',berat_akhir_asli=berat_akhir_asli-'4.600',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSPLT-YIXC-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0006','2025-09-12','4.600','2025-09-12','18:16:36','PLG0006325','2780000','2780000','0','2780000','0','kasir','2025-09-12 18:16:36','FJ-250912-0006','DP-01011','2368000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0006','2025-09-12','18:16:36','NIS','2780000','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-250912-0008','2025-09-12','2025-09-12 18:16:36','PENJUALAN : FJ-250912-0006','.','TBC','412000','412000','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-250912-0009','D','2025-09-12','18:16:36','TBC','PENJUALAN','FJ-250912-0006','16351093564','412000','16351505564','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='412000' WHERE no_faktur_jual='FJ-250912-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-250912-0007','kasir',' 1',' DP-01010MM','TOKO','MMPSN','PSGT-YIXE-6-0','CINCIN EMAS ','','3.110','1','83.00','4872000','0','0','16500','5779000','0','0','0','5779000','NIS','00038587','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YIXE-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PSGT-YIXE-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0007','2025-09-12','3.110','2025-09-12','18:16:36','PLG0006326','5779000','5779000','0','5779000','0','kasir','2025-09-12 18:16:36','FJ-250912-0006','DP-01010','4480000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0007','2025-09-12','18:16:36','NIS','5779000','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-250912-0009','2025-09-12','2025-09-12 18:16:36','PENJUALAN : FJ-250912-0007','.','TBC','1299000','1299000','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-250912-0010','D','2025-09-12','18:16:36','TBC','PENJUALAN','FJ-250912-0007','16351505564','1299000','16352804564','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='1711000' WHERE no_faktur_jual='FJ-250912-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-250912-0008','kasir','1',' 700K-23-12','TOKO','BIPPER','PBDG-YEBH-17-0','CINCIN SILVER 925 ','','4.000','1','100.00','92000','0','0','16500','650000','0','0','0','650000','HELMI','00035937','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YEBH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='PBDG-YEBH-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0008','2025-09-12','4.000','2025-09-12','18:42:45','PLG0006327','650000','650000','0','650000','0','kasir','2025-09-12 18:42:44','FJ-250912-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0008','2025-09-12','18:42:45','HELMI','650000','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-250912-0010','2025-09-12','2025-09-12 18:42:44','PENJUALAN : FJ-250912-0008','.','TBC','650000','650000','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-250912-0011','D','2025-09-12','18:42:45','TBC','PENJUALAN','FJ-250912-0008','16352804564','650000','16353454564','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='650000' WHERE no_faktur_jual='FJ-250912-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-250912-0009','kasir',' 1',' 750K-13-15','TOKO','BIPPER','PBDG-YHXF-1-0','CINCIN SILVER 925 ','','1.280','1','100.00','33000','0','0','16500','700000','0','0','0','700000','HELMI','00037885','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHXF-1-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='2025-09-12' AND kode_barang='PBDG-YHXF-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0009','2025-09-12','1.280','2025-09-12','18:42:45','PLG0006328','700000','700000','0','700000','0','kasir','2025-09-12 18:42:44','FJ-250912-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0009','2025-09-12','18:42:45','HELMI','700000','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-250912-0011','2025-09-12','2025-09-12 18:42:44','PENJUALAN : FJ-250912-0009','.','TBC','700000','700000','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-250912-0012','D','2025-09-12','18:42:45','TBC','PENJUALAN','FJ-250912-0009','16353454564','700000','16354154564','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='1350000' WHERE no_faktur_jual='FJ-250912-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','19:30:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','19:42:04');
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-250912-0010','kasir','1',' TFGRR75-85','TOKO','TFGLR','TFGRR-XAAI-78-0','THIFA GELANG RANTAI RG ','','3.010','1','85.00','4923000','0','0','16500','5130000','0','0','0','5130000','FIR','00026101','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-XAAI-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='TFGRR-XAAI-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250912-0010','2025-09-12','3.010','2025-09-12','19:44:23','PLG0006329','5130000','5130000','0','5130000','0','kasir','2025-09-12 19:44:23','FJ-250912-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-12','FJ-250912-0010','2025-09-12','19:44:23','FIR','5130000','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-250912-0012','2025-09-12','2025-09-12 19:44:23','PENJUALAN : FJ-250912-0010','.','TBC','5130000','5130000','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-250912-0013','D','2025-09-12','19:44:23','TBC','PENJUALAN','FJ-250912-0010','16354154564','5130000','16359284564','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='5130000' WHERE no_faktur_jual='FJ-250912-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250912-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250912-0010';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','19:51:48');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-12';
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='2025-09-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-12' 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-250913-0001','D','2025-09-13','20:12:51','TBC','SALDO AWAL','SALDO AWAL','0','16359284564','16359284564');
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-250913-0001','D','2025-09-13','20:12:51','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-250913-0001','D','2025-09-13','20:12:51','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-250913-0001','D','2025-09-13','20:12:51','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-250913-0001','D','2025-09-13','20:12:51','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-250913-0001','D','2025-09-13','20:12:51','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-250913-0001','D','2025-09-13','20:12:51','BCD','SALDO AWAL','SALDO AWAL','0','1329371000','1329371000');
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-250913-0001','D','2025-09-13','20:12:51','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-250913-0001','D','2025-09-13','20:12:51','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-250913-0001','D','2025-09-13','20:12:51','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-250913-0001','D','2025-09-13','20:12:51','KET','SALDO AWAL','SALDO AWAL','0','148563000','148563000');
UPDATE tp_system SET tgl_system='2025-09-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','20:14:10');
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-01095','SULIS','1','PER','WEDDING RING','','','3.000','','925.00','1','25000','0','700000','0','700000','sz 18 crom putih doff amplass','lebar 4 mm','font berkshire swash 07-12-25','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250913-0001','2025-09-13','2025-09-12 20:16:42','PESANAN : DP-01095','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250913-0002','D','2025-09-13','20:16:42','TBC','PESANAN','DP-01095','16359284564','700000','16359984564','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-01095','2025-09-13','2025-09-13','20:16:42','PLG0006330','SULIS','2025-10-02','kasir','2025-09-12 20:16:42','3.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-12 ','20:39:53');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01252','HELMI','1','SEPASANG CC SLV','CEWE JD SIZE 5 5 COWO SIZE 23','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01252','2025-09-13','2025-09-13','20:41:05','PLG0006331','kasir','2025-09-14','kasir','2025-09-12 20:41:05','5.000','0','0','0','0','0','0','0','0');