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,status_otorisasi,harga_skrg) VALUES ('F225170839411','kasir','1',' MEA1E X DG','TOKO','SMBK-A','A1E-YJXD-156-0','AT X BABY TINDIK DG 8K ','','0.500','1','100.00','530000','0','0','15000','545000','0','0','0','545000','RHM','00372136','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-156-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='A1E-YJXD-156-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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) VALUES ('F225170839411','2025-10-17','0.500','2025-10-17','08:39:42','PLG0073731','545000','545000','0','545000','545000','kasir','2025-10-17 08:39:41','F22517083941');
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-10-17','F225170839411','2025-10-17','08:39:42','RHM','545000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0002','D','2025-10-17','08:39:42','kasir','PENJUALAN','F225170839411','1521096000','545000','1521641000');
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,status_otorisasi,harga_skrg) VALUES ('F225170928481','kasir','1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YIBB-58-T','CC MODEL MATA VAR CM 12 8K ','OL','0.850','1','100.00','884000','0','0','15000','935000','0','5000','0','940000','TJ','T0073194','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2D-YIBB-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225170928481','2025-10-17','0.850','2025-10-17','09:28:48','PLG0073732','935000','935000','5000','940000','940000','kasir','2025-10-17 09:28:48','F22517092848');
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-10-17','F225170928481','2025-10-17','09:28:48','TJ','940000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0003','D','2025-10-17','09:28:48','kasir','PENJUALAN','F225170928481','1521641000','940000','1522581000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='940000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225170928481' 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,status_otorisasi,harga_skrg) VALUES ('F225170928482','kasir',' 1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YJXA-45-T','CC MODEL MATA VAR CM 12 8K ','OL','0.950','1','100.00','988000','0','0','15000','1045000','0','5000','0','1050000','TJ','T0073537','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXA-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2D-YJXA-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225170928482','2025-10-17','0.950','2025-10-17','09:28:48','PLG0073733','1045000','1045000','5000','1050000','1050000','kasir','2025-10-17 09:28:48','F22517092848');
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-10-17','F225170928482','2025-10-17','09:28:48','TJ','1050000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0004','D','2025-10-17','09:28:48','kasir','PENJUALAN','F225170928482','1522581000','1050000','1523631000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225170928482' 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,status_otorisasi,harga_skrg) VALUES ('F225171051001','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YGXB-122-T','AT MODEL GYPSY VAR LG 8K ','','0.530','1','100.00','562000','0','0','15000','578000','0','0','0','578000','RTA','T0070702','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGXB-122-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='A1E-YGXB-122-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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) VALUES ('F225171051001','2025-10-17','0.530','2025-10-17','10:51:01','PLG0073734','578000','578000','0','578000','0','kasir','2025-10-17 10:51:00','F22517105100');
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-10-17','F225171051001','2025-10-17','10:51:01','RTA','578000','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-251017-0001','2025-10-17','2025-10-17 10:51:00','PENJUALAN : F225171051001','90988987767','BCA','578000','578000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251017-0002','D','2025-10-17','10:51:01','BCA','PENJUALAN','F225171051001','4060493888','578000','4061071888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('90988987767','SUMINI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='578000' WHERE no_faktur_jual='F225171051001' 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,status_otorisasi,harga_skrg) VALUES ('F225171051431','kasir','1',' TEA1 X LG ','TOKO','TBK-A','A1TE-XBBF-1-T','AT X KLIP MODEL MATA VAR LG 17K ','OL','1.130','1','100.00','2141000','0','0','15000','2207000','0','8000','0','2215000','RTA','T0054300','A1TE','0','0','-','0','1895000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-XBBF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='A1TE-XBBF-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' 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) VALUES ('F225171051431','2025-10-17','1.130','2025-10-17','10:51:44','PLG0073735','2207000','2207000','8000','2215000','2215000','kasir','2025-10-17 10:51:43','F22517105143');
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-10-17','F225171051431','2025-10-17','10:51:44','RTA','2215000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0005','D','2025-10-17','10:51:44','kasir','PENJUALAN','F225171051431','1523631000','2215000','1525846000');
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,status_otorisasi,harga_skrg) VALUES ('F225171052311','kasir','1',' MEE2 X PM ','TOKO','SMBK-E','E2E-YJAC-297-0','CC X MODEL MATA PM 12 8K ','OL','0.580','1','100.00','615000','0','0','15000','625000','0','5000','0','630000','RTA','00373027','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAC-297-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2E-YJAC-297-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171052311','2025-10-17','0.580','2025-10-17','10:52:32','PLG0073736','625000','625000','5000','630000','630000','kasir','2025-10-17 10:52:31','F22517105231');
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-10-17','F225171052311','2025-10-17','10:52:32','RTA','630000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0006','D','2025-10-17','10:52:32','kasir','PENJUALAN','F225171052311','1525846000','630000','1526476000');
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,status_otorisasi,harga_skrg) VALUES ('F225171053211','kasir','1',' MED1E YT ','TOKO','SMBK-D','D1E-YJAE-6-T','LT MODEL SPECTRA HITAM YT 8K ','OL','0.500','1','100.00','530000','0','0','15000','551000','0','7000','0','558000','RTA','T0074055','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='D1E-YJAE-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F225171053211','2025-10-17','0.500','2025-10-17','10:53:21','PLG0073737','551000','551000','7000','558000','558000','kasir','2025-10-17 10:53:21','F22517105321');
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-10-17','F225171053211','2025-10-17','10:53:21','RTA','558000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0007','D','2025-10-17','10:53:21','kasir','PENJUALAN','F225171053211','1526476000','558000','1527034000');
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,status_otorisasi,harga_skrg) VALUES ('F225171055031','kasir','1',' MEF1 10K Y','TOKO','SMBK-F','F1E-YJAE-25-T','GL TIFF SPECTRA YT 8K ','OL','1.130','1','100.00','1198000','0','0','15000','1239000','0','10000','0','1249000','TJ','T0074074','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJAE-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='F1E-YJAE-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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) VALUES ('F225171055031','2025-10-17','1.130','2025-10-17','10:55:03','PLG0073738','1239000','1239000','10000','1249000','1249000','kasir','2025-10-17 10:55:03','F22517105503');
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-10-17','F225171055031','2025-10-17','10:55:03','TJ','1249000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0008','D','2025-10-17','10:55:03','kasir','PENJUALAN','F225171055031','1527034000','1249000','1528283000');
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,status_otorisasi,harga_skrg) VALUES ('F225171055231','kasir','1',' MGE1 X UB ','TOKO','SMBK-E','E1G-YJAA-84-0','CC X RING POLOS UB 12 8K ','OL','0.330','1','100.00','363000','0','0','15000','378000','0','5000','0','383000','TJ','00372622','E1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YJAA-84-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E1G-YJAA-84-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171055231','2025-10-17','0.330','2025-10-17','10:55:24','PLG0073739','378000','378000','5000','383000','383000','kasir','2025-10-17 10:55:23','F22517105523');
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-10-17','F225171055231','2025-10-17','10:55:24','TJ','383000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0009','D','2025-10-17','10:55:24','kasir','PENJUALAN','F225171055231','1528283000','383000','1528666000');
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,status_otorisasi,harga_skrg) VALUES ('F225171055491','kasir','1',' MFD1F BM ','TOKO','SMBK-D','D1F-YJAE-10-T','LT MODEL PLAT BM 8K ','OL','0.400','1','100.00','432000','0','0','15000','450000','0','5000','0','455000','TJ','T0074059','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAE-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='D1F-YJAE-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F225171055491','2025-10-17','0.400','2025-10-17','10:55:50','PLG0073740','450000','450000','5000','455000','455000','kasir','2025-10-17 10:55:49','F22517105549');
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-10-17','F225171055491','2025-10-17','10:55:50','TJ','455000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0010','D','2025-10-17','10:55:50','kasir','PENJUALAN','F225171055491','1528666000','455000','1529121000');
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,status_otorisasi,harga_skrg) VALUES ('F225171058311','kasir','1',' MJH2 X KH ','TOKO','SMBK-H','H2J-YJAA-171-0','KL X SIEM COBRA KH 44 9K ','OLS RQVJY','1.270','1','100.00','1473000','0','0','15000','1473000','0','80000','0','1553000','RHM','00372709','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJAA-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='H2J-YJAA-171-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F225171058311','2025-10-17','1.270','2025-10-17','10:58:32','PLG0073741','1473000','1473000','80000','1553000','1553000','kasir','2025-10-17 10:58:31','F22517105831');
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-10-17','F225171058311','2025-10-17','10:58:32','RHM','1553000','80000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0011','D','2025-10-17','10:58:32','kasir','PENJUALAN','F225171058311','1529121000','1553000','1530674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171058311' 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,status_otorisasi,harga_skrg) VALUES ('F225171058312','kasir',' 1',' MED2E X LG','TOKO','SMBK-D','D2E-YIAE-93-0','LT X MODEL HURUF MATA LG W 8K ','OLS RQVJY','0.470','1','100.00','498000','0','0','15000','498000','0','55000','0','553000','RHM','00369544','D2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIAE-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='D2E-YIAE-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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) VALUES ('F225171058312','2025-10-17','0.470','2025-10-17','10:58:32','PLG0073742','498000','498000','55000','553000','553000','kasir','2025-10-17 10:58:31','F22517105831');
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-10-17','F225171058312','2025-10-17','10:58:32','RHM','553000','55000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0012','D','2025-10-17','10:58:32','kasir','PENJUALAN','F225171058312','1530674000','553000','1531227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171058312' 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,status_otorisasi,harga_skrg) VALUES ('F225171127181','kasir','1',' MEF3 5K LG','TOKO','SMBK-F','F3E-YJXF-74-T','GL JEDAR MRICAN HITAM VAR LG 8K','OL','0.900','1','100.00','954000','0','0','15000','995000','0','5000','0','1000000','RTA','T0073972','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='F3E-YJXF-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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) VALUES ('F225171127181','2025-10-17','0.900','2025-10-17','11:27:19','PLG0073743','995000','995000','5000','1000000','1000000','kasir','2025-10-17 11:27:18','F22517112718');
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-10-17','F225171127181','2025-10-17','11:27:19','RTA','1000000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0013','D','2025-10-17','11:27:19','kasir','PENJUALAN','F225171127181','1531227000','1000000','1532227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171127181' 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,status_otorisasi,harga_skrg) VALUES ('F225171127182','kasir',' 1',' MFH1 X UB ','TOKO','SMBK-H','H1F-YIBC-448-0','KL X CARENDELANO HURUF A UB 8K ','OL','1.680','1','100.00','1814000','0','0','15000','1880000','0','10000','0','1890000','RTA','00370419','H1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIBC-448-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='H1F-YIBC-448-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F225171127182','2025-10-17','1.680','2025-10-17','11:27:19','PLG0073744','1880000','1880000','10000','1890000','1890000','kasir','2025-10-17 11:27:18','F22517112718');
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-10-17','F225171127182','2025-10-17','11:27:19','RTA','1890000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0014','D','2025-10-17','11:27:19','kasir','PENJUALAN','F225171127182','1532227000','1890000','1534117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1890000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171127182' 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,status_otorisasi,harga_skrg) VALUES ('F225171127183','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YIXB-55-T','CC MODEL HATI MATA VAR CM 14 8K ','OL','0.710','1','100.00','753000','0','0','15000','785000','0','5000','0','790000','RTA','T0072799','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXB-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2E-YIXB-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171127183','2025-10-17','0.710','2025-10-17','11:27:19','PLG0073745','785000','785000','5000','790000','790000','kasir','2025-10-17 11:27:18','F22517112718');
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-10-17','F225171127183','2025-10-17','11:27:19','RTA','790000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0015','D','2025-10-17','11:27:19','kasir','PENJUALAN','F225171127183','1534117000','790000','1534907000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='790000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171127183' 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,status_otorisasi,harga_skrg) VALUES ('F225171158491','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YEXC-362-0','CC X MODEL MATA LG 16 8K','OL','0.630','1','100.00','668000','0','0','15000','693000','0','5000','0','698000','RTA','00352673','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YEXC-362-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2E-YEXC-362-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171158491','2025-10-17','0.630','2025-10-17','11:58:49','PLG0073746','693000','693000','5000','698000','698000','kasir','2025-10-17 11:58:49','F22517115849');
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-10-17','F225171158491','2025-10-17','11:58:49','RTA','698000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0016','D','2025-10-17','11:58:49','kasir','PENJUALAN','F225171158491','1534907000','698000','1535605000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='698000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171158491' 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,status_otorisasi,harga_skrg) VALUES ('F225171158492','kasir',' 1',' MEE2 UB 12','TOKO','SMBK-E','E2E-YJXD-56-T','CC MODEL HATI MATA VAR UB 12 8K','OL','0.650','1','100.00','689000','0','0','15000','715000','0','5000','0','720000','RTA','T0073870','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E2E-YJXD-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171158492','2025-10-17','0.650','2025-10-17','11:58:49','PLG0073747','715000','715000','5000','720000','720000','kasir','2025-10-17 11:58:49','F22517115849');
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-10-17','F225171158492','2025-10-17','11:58:49','RTA','720000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0017','D','2025-10-17','11:58:49','kasir','PENJUALAN','F225171158492','1535605000','720000','1536325000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='720000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171158492' 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,status_otorisasi,harga_skrg) VALUES ('F225171158493','kasir',' 1',' MEB1E CM ','TOKO','SMBK-B','B1E-YJAF-78-T','GW MODEL DAUN SLEP CM 8K ','OL','0.640','1','100.00','678000','0','0','15000','704000','0','5000','0','709000','RTA','T0074204','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJAF-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='B1E-YJAF-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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) VALUES ('F225171158493','2025-10-17','0.640','2025-10-17','11:58:49','PLG0073748','704000','704000','5000','709000','709000','kasir','2025-10-17 11:58:49','F22517115849');
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-10-17','F225171158493','2025-10-17','11:58:49','RTA','709000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251017-0018','D','2025-10-17','11:58:49','kasir','PENJUALAN','F225171158493','1536325000','709000','1537034000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='709000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225171158493' 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,status_otorisasi,harga_skrg) VALUES ('F225171214381','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-59-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.730','1','100.00','774000','0','0','15000','803000','0','5000','0','808000','TIN','T0074185','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='E1E-YJAF-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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) VALUES ('F225171214381','2025-10-17','0.730','2025-10-17','12:14:39','PLG0073749','803000','803000','5000','808000','808000','kasir','2025-10-17 12:14:38','F22517121438');
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-10-17','F225171214381','2025-10-17','12:14:39','TIN','808000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0019','D','2025-10-17','12:14:39','kasir','PENJUALAN','F225171214381','1537034000','808000','1537842000');
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,status_otorisasi,harga_skrg) VALUES ('F225171218471','kasir','1',' MJH2 X KH ','TOKO','SMBK-H','H2J-YHBX-17-0','KL X MILANO KH 42 9K ','OL','2.040','1','100.00','2366000','0','0','15000','2438000','0','10000','0','2448000','RTA','00366295','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YHBX-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='H2J-YHBX-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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) VALUES ('F225171218471','2025-10-17','2.040','2025-10-17','12:18:48','PLG0073750','2438000','2438000','10000','2448000','0','kasir','2025-10-17 12:18:47','F22517121847');
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-10-17','F225171218471','2025-10-17','12:18:48','RTA','2448000','10000');
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-251017-0002','2025-10-17','2025-10-17 12:18:47','PENJUALAN : F225171218471','98098878776','BCA','2448000','2448000','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-251017-0003','D','2025-10-17','12:18:48','BCA','PENJUALAN','F225171218471','4061071888','2448000','4063519888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('98098878776','FERDHA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2448000' WHERE no_faktur_jual='F225171218471' 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,status_otorisasi,harga_skrg) VALUES ('F225170107131','kasir','1',' TEF3 HW ','TOKO','TBK-F','F3TE-YJXC-28-T','GL FANCY POLOS HW 17K ','','1.150','1','100.00','2179000','0','0','15000','2215000','0','0','0','2215000','RTA','T0073749','F3TE','0','0','-','0','1895000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YJXC-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='F3TE-YJXC-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' 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) VALUES ('F225170107131','2025-10-17','1.150','2025-10-17','13:07:13','PLG0073751','2215000','2215000','0','2215000','2215000','kasir','2025-10-17 13:07:13','F22517010713');
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-10-17','F225170107131','2025-10-17','13:07:13','RTA','2215000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0020','D','2025-10-17','13:07:13','kasir','PENJUALAN','F225170107131','1537842000','2215000','1540057000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225170107131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225170107131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225170107131';
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,status_otorisasi,harga_skrg) VALUES ('F225170242071','kasir','1',' MEF3 10K K','TOKO','SMBK-F','F3E-YIXH-65-T','GL RANTAI HOLLOW P4 SLEP KH 8K ','','2.200','1','100.00','2332000','0','0','15000','2398000','0','10000','0','2408000','RTA','T0073074','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXH-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2025-10-17' AND kode_barang='F3E-YIXH-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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) VALUES ('F225170242071','2025-10-17','2.200','2025-10-17','14:42:07','PLG0073752','2398000','2398000','10000','2408000','2408000','kasir','2025-10-17 14:42:07','F22517024207');
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-10-17','F225170242071','2025-10-17','14:42:07','RTA','2408000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251017-0021','D','2025-10-17','14:42:07','kasir','PENJUALAN','F225170242071','1540057000','2408000','1542465000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225170242071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225170242071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225170242071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225170839411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225170839411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225170839411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225170928481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225170928481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225170928481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225170928482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225170928482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225170928482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171051001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171051001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171051001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171051431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171051431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171051431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171052311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171052311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171052311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171053211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171053211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171053211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171055031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171055231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171055491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171055491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171058311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171058311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171058311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171058312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171058312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171058312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171127181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171127182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127183' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171127183' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171127183';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171158491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171158492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171158493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171158493';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171214381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171214381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171214381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225171218471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225171218471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225171218471';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004746','X-00004746','GL OVAL MODEL C GELOMBANG YT D52','GR','---','F1TE','BELI','BELI001','6120000','2025-10-17','4.080','1','kasir','2025-10-17 15:55:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00004746','X-00004746');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251017-0001','F222270259491','TIN','1','BELI','BELI001','F1TE', 'X-00004746', 'GL OVAL MODEL C GELOMBANG YT D52','4.190','4.080','100.00','3143000','6120000','1500000','1895000','1','6120000','6120000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.080',berat_beli_asli=berat_beli_asli+'4.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.080',berat_akhir_asli=berat_akhir_asli+'4.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251017-0001','2025-10-17','2025-10-17','15:55:48','TIN','---','4.080','6120000','6120000','6120000','6120000','6120000','kasir','2025-10-17 15:55:48','FB-251017-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251017-0001','NELY','BRINGIN KAUMAN','','','082213051016','kasir','2025-10-17 15:55:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
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-251017-0022','K','2025-10-17','15:55:48','kasir','PEMBELIAN UMUM','FB-251017-0001','1542465000','6120000','1536345000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004747','X-00004747','CC MODEL MATA LG 13','GR','---','E2E','BELI','BELI001','642000','2025-10-17','0.880','1','kasir','2025-10-17 15:56:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004747','X-00004747');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251017-0002','F224011012011','TJ','1','BELI','BELI001','E2E', 'X-00004747', 'CC MODEL MATA LG 13','0.980','0.880','100.00','578000','642000','729545','1060000','1','642000','642000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.880',berat_beli_asli=berat_beli_asli+'0.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.880',berat_akhir_asli=berat_akhir_asli+'0.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251017-0002','2025-10-17','2025-10-17','15:56:24','TJ','---','0.880','642000','642000','642000','642000','642000','kasir','2025-10-17 15:56:24','FB-251017-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251017-0002','SEPTIA','JL DI PANJAITAN SIMAN','','','085771288428','kasir','2025-10-17 15:56:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
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-251017-0023','K','2025-10-17','15:56:24','kasir','PEMBELIAN UMUM','FB-251017-0002','1536345000','642000','1535703000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004748','X-00004748','GL X TIFF DOBEL UB 8K','GR','---','F3E','BELI','BELI001','1393000','2025-10-17','1.980','1','kasir','2025-10-17 15:56:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004748','X-00004748');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251017-0003','F225260941081','RTA','1','BELI','BELI001','F3E', 'X-00004748', 'GL X TIFF DOBEL UB 8K','2.030','1.980','100.00','1683000','1393000','703535','1060000','1','1393000','1393000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251017-0003','2025-10-17','2025-10-17','15:56:47','RTA','---','1.980','1393000','1393000','1393000','1393000','1393000','kasir','2025-10-17 15:56:47','FB-251017-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251017-0003','GISI PUTRI','GANDUKEPUH','','','085607026647','kasir','2025-10-17 15:56:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
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-251017-0024','K','2025-10-17','15:56:47','kasir','PEMBELIAN UMUM','FB-251017-0003','1535703000','1393000','1534310000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004749','X-00004749','GL KOREA UB 17K','GR','---','F3TF','BELI','BELI001','624000','2025-10-17','0.430','1','kasir','2025-10-17 15:57:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TF','X-00004749','X-00004749');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251017-0004','F225111215401','RTA','1','BELI','BELI001','F3TF', 'X-00004749', 'GL KOREA UB 17K','0.430','0.430','100.00','781000','624000','1451163','1915000','1','624000','624000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TF' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251017-0004','2025-10-17','2025-10-17','15:57:20','RTA','---','0.430','624000','624000','624000','624000','624000','kasir','2025-10-17 15:57:21','FB-251017-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251017-0004','FITRI','CRAGAK 1/2 SLAHUNG','','','','kasir','2025-10-17 15:57:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
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-251017-0025','K','2025-10-17','15:57:20','kasir','PEMBELIAN UMUM','FB-251017-0004','1534310000','624000','1533686000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004750','X-00004750','KL VAR 17K','GR','---','H2TF','BELI','BELI001','4200000','2025-10-17','2.800','1','kasir','2025-10-17 15:58:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2TF','X-00004750','X-00004750');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251017-0005','F223060853221','RHM','1','BELI','BELI001','H2TF', 'X-00004750', 'KL VAR 17K','2.860','2.800','100.00','2275000','4200000','1500000','1915000','1','4200000','4200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.800',berat_beli_asli=berat_beli_asli+'2.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.800',berat_akhir_asli=berat_akhir_asli+'2.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2TF' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251017-0005','2025-10-17','2025-10-17','15:58:24','RHM','---','2.800','4200000','4200000','4200000','4200000','4200000','kasir','2025-10-17 15:58:24','FB-251017-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251017-0005','ENDAH','PURBOSUMAN','','','','kasir','2025-10-17 15:58:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
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-251017-0026','K','2025-10-17','15:58:24','kasir','PEMBELIAN UMUM','FB-251017-0005','1533686000','4200000','1529486000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251017-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251017-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251017-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251017-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251017-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251017-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251017-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251017-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251017-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251017-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-17';
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-10-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251018-0001','D','2025-10-18','16:24:06','SYSTEM','SALDO AWAL','SALDO AWAL','0','1529486000','1529486000');
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-251018-0001','D','2025-10-18','16:24:06','BCA','SALDO AWAL','SALDO AWAL','0','4063519888','4063519888');
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-251018-0001','D','2025-10-18','16:24:06','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-251018-0001','D','2025-10-18','16:24:06','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
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-251018-0001','D','2025-10-18','16:24:06','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
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-251018-0001','D','2025-10-18','16:24:06','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-10-18';