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 ('F225250854111','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIXB-35-T','CC WEDDING MATA CM 18 8K ','','2.020','1','100.00','1838000','0','0','15000','1870000','0','10000','0','1880000','RTA','T0072779','E2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2D-YIXB-35-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 ('F225250854111','2025-09-25','2.020','2025-09-25','08:54:12','PLG0072896','1870000','1870000','10000','1880000','1880000','kasir','2025-09-25 08:54:11','F22525085411');
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-25','F225250854111','2025-09-25','08:54:12','RTA','1880000','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-250925-0002','D','2025-09-25','08:54:12','kasir','PENJUALAN','F225250854111','584770000','1880000','586650000');
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 ('F225250857461','kasir','1',' MJH3 X UB ','TOKO','SMBK-H','H3J-YHBX-35-0','KL X SANTA ARESO VAR UB 44 9K ','','2.840','1','100.00','2874000','0','0','15000','2976000','0','0','0','2976000','TJ','00366313','H3J','0','0','-','0','1048000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YHBX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H3J-YHBX-35-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 ('F225250857461','2025-09-25','2.840','2025-09-25','08:57:47','PLG0072897','2976000','2976000','0','2976000','2976000','kasir','2025-09-25 08:57:46','F22525085746');
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-25','F225250857461','2025-09-25','08:57:47','TJ','2976000','0');
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-250925-0003','D','2025-09-25','08:57:47','kasir','PENJUALAN','F225250857461','586650000','2976000','589626000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2976000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250857461' 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 ('F225250857462','kasir',' 1',' MFE1 X UB ','TOKO','SMBK-E','E1F-YIAG-47-0','CC X MODEL BOLA PASIR UB 18 8K ','','1.800','1','100.00','1699000','0','0','15000','1742000','0','0','0','1742000','TJ','00369829','E1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YIAG-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E1F-YIAG-47-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 ('F225250857462','2025-09-25','1.800','2025-09-25','08:57:47','PLG0072898','1742000','1742000','0','1742000','1742000','kasir','2025-09-25 08:57:46','F22525085746');
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-25','F225250857462','2025-09-25','08:57:47','TJ','1742000','0');
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-250925-0004','D','2025-09-25','08:57:47','kasir','PENJUALAN','F225250857462','589626000','1742000','591368000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1742000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250857462' 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 ('F225250950181','kasir','1',' MEE2 CM 12','TOKO','SMBK-E','E2E-YIBB-47-T','CC MODEL MATA VAR CM 12 8K ','OL','0.610','1','100.00','565000','0','0','15000','585000','0','5000','0','590000','RTA','T0073183','E2E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBB-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2E-YIBB-47-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 ('F225250950181','2025-09-25','0.610','2025-09-25','09:50:19','PLG0072899','585000','585000','5000','590000','0','kasir','2025-09-25 09:50:18','F22525095018');
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-25','F225250950181','2025-09-25','09:50:19','RTA','590000','5000');
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-250925-0001','2025-09-25','2025-09-25 09:50:18','PENJUALAN : F225250950181','98887776665','BCA','590000','590000','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-250925-0002','D','2025-09-25','09:50:19','BCA','PENJUALAN','F225250950181','4000521888','590000','4001111888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('98887776665','TANTI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='590000' WHERE no_faktur_jual='F225250950181' 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 ('F225250959271','kasir','1',' MFB1 BW ','TOKO','SMBK-B','B1F-YGXI-12-T','GW TUSUK BUNGA PASIR 2C VAR BW 8K ','ol','0.410','1','100.00','387000','0','0','15000','401000','0','5000','0','406000','TJ','T0070826','B1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YGXI-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='B1F-YGXI-12-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 ('F225250959271','2025-09-25','0.410','2025-09-25','09:59:27','PLG0072900','401000','401000','5000','406000','406000','kasir','2025-09-25 09:59:27','F22525095927');
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-25','F225250959271','2025-09-25','09:59:27','TJ','406000','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-250925-0005','D','2025-09-25','09:59:27','kasir','PENJUALAN','F225250959271','591368000','406000','591774000');
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 ('F225251000551','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-YHXF-66-T','GW TUSUK MRICAN POLOS LG 8K ','ol','0.350','1','100.00','336000','0','0','15000','348000','0','0','0','348000','TIN','T0071958','B1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YHXF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='B1G-YHXF-66-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 ('F225251000551','2025-09-25','0.350','2025-09-25','10:00:55','PLG0072901','348000','348000','0','348000','348000','kasir','2025-09-25 10:00:55','F22525100055');
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-25','F225251000551','2025-09-25','10:00:55','TIN','348000','0');
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-250925-0006','D','2025-09-25','10:00:55','kasir','PENJUALAN','F225251000551','591774000','348000','592122000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='348000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251000551' 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 ('F225251000552','kasir',' 1',' MDD2D X LG','TOKO','SMBK-D','D2D-YABE-155-0','LT X MODEL HURUF MATA LG M 8K ','ol','1.070','1','100.00','974000','0','0','15000','1022000','0','0','0','1022000','TIN','00336438','D2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YABE-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='D2D-YABE-155-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 ('F225251000552','2025-09-25','1.070','2025-09-25','10:00:56','PLG0072902','1022000','1022000','0','1022000','1022000','kasir','2025-09-25 10:00:55','F22525100055');
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-25','F225251000552','2025-09-25','10:00:56','TIN','1022000','0');
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-250925-0007','D','2025-09-25','10:00:56','kasir','PENJUALAN','F225251000552','592122000','1022000','593144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1022000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251000552' 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 ('F225251002051','kasir','1',' TFB1 HK ','TOKO','TBK-B','B1TF-XEAG-5-T','GW TOGE MODEL MATA VAR HK 17K ','olw','0.500','1','100.00','828000','0','0','15000','840000','0','95000','0','935000','TJ','T0057170','B1TF','0','0','-','0','1657000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-XEAG-5-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-09-25' AND kode_barang='B1TF-XEAG-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225251002051','2025-09-25','0.500','2025-09-25','10:02:05','PLG0072903','840000','840000','95000','935000','935000','kasir','2025-09-25 10:02:05','F22525100205');
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-25','F225251002051','2025-09-25','10:02:05','TJ','935000','95000');
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-250925-0008','D','2025-09-25','10:02:05','kasir','PENJUALAN','F225251002051','593144000','935000','594079000');
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 ('F225251027471','kasir','1',' MDD2D X LG','TOKO','SMBK-D','D2D-YABE-155-0','LT X MODEL HURUF MATA LG M 8K ','OL','1.070','1','100.00','974000','0','0','15000','1025000','0','0','0','1025000','TIN','00336438','D2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YABE-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='D2D-YABE-155-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 ('F225251027471','2025-09-25','1.070','2025-09-25','10:27:48','PLG0072904','1025000','1025000','0','1025000','1025000','kasir','2025-09-25 10:27:47','F22525102747');
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-25','F225251027471','2025-09-25','10:27:48','TIN','1025000','0');
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-250925-0011','D','2025-09-25','10:27:48','kasir','PENJUALAN','F225251027471','592709000','1025000','593734000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251027471' 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 ('F225251027472','kasir',' 1',' MGB1 LG ','TOKO','SMBK-B','B1G-YHXF-66-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.350','1','100.00','336000','0','0','15000','349000','0','0','0','349000','TIN','T0071958','B1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YHXF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='B1G-YHXF-66-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 ('F225251027472','2025-09-25','0.350','2025-09-25','10:27:48','PLG0072905','349000','349000','0','349000','349000','kasir','2025-09-25 10:27:47','F22525102747');
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-25','F225251027472','2025-09-25','10:27:48','TIN','349000','0');
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-250925-0012','D','2025-09-25','10:27:48','kasir','PENJUALAN','F225251027472','593734000','349000','594083000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='349000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251027472' 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 ('F225251122221','kasir','1',' MED2 X LG ','TOKO','SMBK-D','D2E-XFBH-153-0','LT X MODEL HURUF MATA LG P 8K ','OL','1.100','1','100.00','1020000','0','0','15000','1048000','0','6000','0','1054000','TIN','00304984','D2E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-XFBH-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='D2E-XFBH-153-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 ('F225251122221','2025-09-25','1.100','2025-09-25','11:22:23','PLG0072906','1048000','1048000','6000','1054000','1054000','kasir','2025-09-25 11:22:22','F22525112222');
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-25','F225251122221','2025-09-25','11:22:23','TIN','1054000','6000');
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-250925-0013','D','2025-09-25','11:22:23','kasir','PENJUALAN','F225251122221','594083000','1054000','595137000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1054000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251122221' 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 ('F225251122222','kasir',' 1',' MDD2 X LG ','TOKO','SMBK-D','D2D-YDCX-288-0','LT X MODEL HURUF MATA LG K 8K ','OL','1.170','1','100.00','1065000','0','0','15000','1115000','0','6000','0','1121000','TIN','00351540','D2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YDCX-288-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='D2D-YDCX-288-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 ('F225251122222','2025-09-25','1.170','2025-09-25','11:22:23','PLG0072907','1115000','1115000','6000','1121000','1121000','kasir','2025-09-25 11:22:22','F22525112222');
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-25','F225251122222','2025-09-25','11:22:23','TIN','1121000','6000');
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-250925-0014','D','2025-09-25','11:22:23','kasir','PENJUALAN','F225251122222','595137000','1121000','596258000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1121000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251122222' 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 ('F225251122223','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-YCAG-207-0','GL X ROLLO SLEP VAR HW 8K ','OL','2.700','1','100.00','2503000','0','0','15000','2573000','0','14000','0','2587000','TIN','00343442','F3E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCAG-207-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='F3E-YCAG-207-0' 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 ('F225251122223','2025-09-25','2.700','2025-09-25','11:22:23','PLG0072908','2573000','2573000','14000','2587000','2587000','kasir','2025-09-25 11:22:22','F22525112222');
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-25','F225251122223','2025-09-25','11:22:23','TIN','2587000','14000');
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-250925-0015','D','2025-09-25','11:22:23','kasir','PENJUALAN','F225251122223','596258000','2587000','598845000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2587000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225251122223' 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 ('F225251140011','kasir','1',' MEA1E X DG','TOKO','SMBK-A','A1E-YIAG-8-0','AT X BABY TINDIK DG 8K ','','0.460','1','100.00','426000','0','0','15000','435000','0','0','0','435000','RHM','00369790','A1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIAG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='A1E-YIAG-8-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 ('F225251140011','2025-09-25','0.460','2025-09-25','11:40:02','PLG0072909','435000','435000','0','435000','435000','kasir','2025-09-25 11:40:01','F22525114001');
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-25','F225251140011','2025-09-25','11:40:02','RHM','435000','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-250925-0016','D','2025-09-25','11:40:02','kasir','PENJUALAN','F225251140011','598845000','435000','599280000');
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 ('F225251237521','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YIBC-315-0','CC X MODEL MATA CM 14 8K ','OL','1.440','1','100.00','1332000','0','0','15000','1377000','0','7000','0','1384000','RTA','00370286','E2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBC-315-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2D-YIBC-315-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 ('F225251237521','2025-09-25','1.440','2025-09-25','12:37:52','PLG0072910','1377000','1377000','7000','1384000','1384000','kasir','2025-09-25 12:37:52','F22525123752');
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-25','F225251237521','2025-09-25','12:37:52','RTA','1384000','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-250925-0017','D','2025-09-25','12:37:52','kasir','PENJUALAN','F225251237521','599280000','1384000','600664000');
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 ('F225251249371','kasir','1',' MIF4 UB ','TOKO','SMBK-F','F4I-YGAB-18-T','GL RANTAI HOLLOW UB 9K ','','2.060','1','100.00','2050000','0','0','15000','2114000','0','0','0','2114000','TIN','T0070901','F4I','0','0','-','0','995000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YGAB-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='F4I-YGAB-18-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 ('F225251249371','2025-09-25','2.060','2025-09-25','12:49:37','PLG0072911','2114000','2114000','0','2114000','2114000','kasir','2025-09-25 12:49:37','F22525124937');
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-25','F225251249371','2025-09-25','12:49:37','TIN','2114000','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-250925-0018','D','2025-09-25','12:49:37','kasir','PENJUALAN','F225251249371','600664000','2114000','602778000');
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 ('F225251253121','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-162-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.500','1','100.00','463000','0','0','15000','481000','0','5000','0','486000','RTA','T0072658','B1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-162-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-09-25' AND kode_barang='B1E-YHBH-162-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 ('F225251253121','2025-09-25','0.500','2025-09-25','12:53:12','PLG0072912','481000','481000','5000','486000','486000','kasir','2025-09-25 12:53:12','F22525125312');
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-25','F225251253121','2025-09-25','12:53:12','RTA','486000','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-250925-0019','D','2025-09-25','12:53:12','kasir','PENJUALAN','F225251253121','602778000','486000','603264000');
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 ('F225250119461','kasir','1',' MDE2 5K CM','TOKO','SMBK-E','E2D-YIBB-74-T','CC MODEL SOLITAIRE MATA CM 16 8K ','OL','0.900','1','100.00','819000','0','0','15000','865000','0','5000','0','870000','TIN','T0073210','E2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-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-09-25' AND kode_barang='E2D-YIBB-74-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 ('F225250119461','2025-09-25','0.900','2025-09-25','13:19:46','PLG0072913','865000','865000','5000','870000','870000','kasir','2025-09-25 13:19:46','F22525011946');
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-25','F225250119461','2025-09-25','13:19:46','TIN','870000','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-250925-0020','D','2025-09-25','13:19:46','kasir','PENJUALAN','F225250119461','603264000','870000','604134000');
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 ('F225250120111','kasir','1',' MDE1 PM 14','TOKO','SMBK-E','E1D-YIXB-45-T','CC MODEL DAUN SLEP VAR PM 14 8K ','OL','0.980','1','100.00','892000','0','0','15000','942000','0','5000','0','947000','TIN','T0072789','E1D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIXB-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E1D-YIXB-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 ('F225250120111','2025-09-25','0.980','2025-09-25','13:20:12','PLG0072914','942000','942000','5000','947000','947000','kasir','2025-09-25 13:20:11','F22525012011');
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-25','F225250120111','2025-09-25','13:20:12','TIN','947000','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-250925-0021','D','2025-09-25','13:20:12','kasir','PENJUALAN','F225250120111','604134000','947000','605081000');
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 ('F225250120331','kasir','1',' MDE2 CM 14','TOKO','SMBK-E','E2D-YIBB-71-T','CC MODEL MATA VAR CM 14 8K ','OL','1.100','1','100.00','1001000','0','0','15000','1051000','0','6000','0','1057000','TIN','T0073207','E2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBB-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2D-YIBB-71-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 ('F225250120331','2025-09-25','1.100','2025-09-25','13:20:33','PLG0072915','1051000','1051000','6000','1057000','1057000','kasir','2025-09-25 13:20:33','F22525012033');
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-25','F225250120331','2025-09-25','13:20:33','TIN','1057000','6000');
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-250925-0022','D','2025-09-25','13:20:33','kasir','PENJUALAN','F225250120331','605081000','1057000','606138000');
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 ('F225250120561','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-YIBC-443-0','KL X TIFF SLEP MATA VAR UB 42 8K','OL','1.470','1','100.00','1389000','0','0','15000','1406000','0','7000','0','1413000','TIN','00370414','H1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBC-443-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H1E-YIBC-443-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 ('F225250120561','2025-09-25','1.470','2025-09-25','13:20:56','PLG0072916','1406000','1406000','7000','1413000','1413000','kasir','2025-09-25 13:20:56','F22525012056');
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-25','F225250120561','2025-09-25','13:20:56','TIN','1413000','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-250925-0023','D','2025-09-25','13:20:56','kasir','PENJUALAN','F225250120561','606138000','1413000','607551000');
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 ('F225250121191','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YIBX-4-T','KL TRIXIE MODEL PITA MATA VAR UB 8K ','OL','1.480','1','100.00','1372000','0','0','15000','1415000','0','7000','0','1422000','TIN','T0073102','H1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBX-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H1E-YIBX-4-T' 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 ('F225250121191','2025-09-25','1.480','2025-09-25','13:21:20','PLG0072917','1415000','1415000','7000','1422000','1422000','kasir','2025-09-25 13:21:19','F22525012119');
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-25','F225250121191','2025-09-25','13:21:20','TIN','1422000','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-250925-0024','D','2025-09-25','13:21:20','kasir','PENJUALAN','F225250121191','607551000','1422000','608973000');
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 ('F225250121441','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YIBX-1-T','KL TRIXIE SERUT MODEL PITA VAR UB 8K ','OL','1.530','1','100.00','1418000','0','0','15000','1462000','0','8000','0','1470000','TIN','T0073099','H1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBX-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H1E-YIBX-1-T' 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 ('F225250121441','2025-09-25','1.530','2025-09-25','13:21:45','PLG0072918','1462000','1462000','8000','1470000','1470000','kasir','2025-09-25 13:21:44','F22525012144');
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-25','F225250121441','2025-09-25','13:21:45','TIN','1470000','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-250925-0025','D','2025-09-25','13:21:45','kasir','PENJUALAN','F225250121441','608973000','1470000','610443000');
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 ('F225250122081','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YIBX-2-T','KL TRIXIE SERUT MODEL PITA VAR UB 8K ','OL','1.530','1','100.00','1418000','0','0','15000','1462000','0','8000','0','1470000','TIN','T0073100','H1E','0','0','-','0','948000');
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 ('F225250122331','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YIBX-2-T','KL TRIXIE SERUT MODEL PITA VAR UB 8K ','OL','1.530','1','100.00','1418000','0','0','15000','1462000','0','8000','0','1470000','TIN','T0073100','H1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H1E-YIBX-2-T' 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 ('F225250122331','2025-09-25','1.530','2025-09-25','13:22:33','PLG0072920','1462000','1462000','8000','1470000','1470000','kasir','2025-09-25 13:22:33','F22525012233');
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-25','F225250122331','2025-09-25','13:22:33','TIN','1470000','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-250925-0026','D','2025-09-25','13:22:33','kasir','PENJUALAN','F225250122331','610443000','1470000','611913000');
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 ('F225250142591','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YIAC-353-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.020','1','100.00','928000','0','0','15000','965000','0','7000','0','972000','RTA','00369437','E2D','0','0','-','0','928000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-353-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2D-YIAC-353-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 ('F225250142591','2025-09-25','1.020','2025-09-25','13:43:00','PLG0072921','965000','965000','7000','972000','0','kasir','2025-09-25 13:42:59','F22525014259');
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-25','F225250142591','2025-09-25','13:43:00','RTA','972000','7000');
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-250925-0002','2025-09-25','2025-09-25 13:42:59','PENJUALAN : F225250142591','9098887767','BCA','972000','972000','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-250925-0003','D','2025-09-25','13:43:00','BCA','PENJUALAN','F225250142591','4001111888','972000','4002083888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('9098887767','PENI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='972000' WHERE no_faktur_jual='F225250142591' 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 ('F225250157341','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-6-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073252','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-6-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-09-25' AND kode_barang='S1G-YIBC-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157341','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072922','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157341','2025-09-25','13:57:35','TIN','406000','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-250925-0027','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157341','611913000','406000','612319000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157341' 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 ('F225250157342','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-13-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073259','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-13-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-09-25' AND kode_barang='S1G-YIBC-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157342','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072923','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157342','2025-09-25','13:57:35','TIN','406000','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-250925-0028','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157342','612319000','406000','612725000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157342' 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 ('F225250157343','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-16-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073262','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-16-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-09-25' AND kode_barang='S1G-YIBC-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157343','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072924','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157343','2025-09-25','13:57:35','TIN','406000','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-250925-0029','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157343','612725000','406000','613131000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157343' 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 ('F225250157344','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-12-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073258','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-12-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-09-25' AND kode_barang='S1G-YIBC-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157344','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072925','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157344','2025-09-25','13:57:35','TIN','406000','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-250925-0030','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157344','613131000','406000','613537000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157344' 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 ('F225250157345','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-5-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073251','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-5-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-09-25' AND kode_barang='S1G-YIBC-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157345','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072926','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157345','2025-09-25','13:57:35','TIN','406000','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-250925-0031','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157345','613537000','406000','613943000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157345' 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 ('F225250157346','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-15-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073261','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-15-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-09-25' AND kode_barang='S1G-YIBC-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157346','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072927','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157346','2025-09-25','13:57:35','TIN','406000','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-250925-0032','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157346','613943000','406000','614349000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157346' 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 ('F225250157347','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-14-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073260','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-14-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-09-25' AND kode_barang='S1G-YIBC-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157347','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072928','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157347','2025-09-25','13:57:35','TIN','406000','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-250925-0033','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157347','614349000','406000','614755000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157347' 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 ('F225250157348','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-10-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073256','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-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-09-25' AND kode_barang='S1G-YIBC-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157348','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072929','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157348','2025-09-25','13:57:35','TIN','406000','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-250925-0034','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157348','614755000','406000','615161000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157348' 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 ('F225250157349','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-9-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073255','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-9-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-09-25' AND kode_barang='S1G-YIBC-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250157349','2025-09-25','0.400','2025-09-25','13:57:35','PLG0072930','401000','401000','5000','406000','406000','kasir','2025-09-25 13:57:34','F22525015734');
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-25','F225250157349','2025-09-25','13:57:35','TIN','406000','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-250925-0035','D','2025-09-25','13:57:35','kasir','PENJUALAN','F225250157349','615161000','406000','615567000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250157349' 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 ('F225250159291','kasir','1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-7-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073253','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-7-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-09-25' AND kode_barang='S1G-YIBC-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159291','2025-09-25','0.400','2025-09-25','13:59:30','PLG0072931','401000','401000','5000','406000','406000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159291','2025-09-25','13:59:30','TIN','406000','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-250925-0036','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159291','615567000','406000','615973000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159291' 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 ('F225250159292','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-44-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073306','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-44-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-09-25' AND kode_barang='S1G-YIBD-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159292','2025-09-25','0.400','2025-09-25','13:59:30','PLG0072932','401000','401000','5000','406000','406000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159292','2025-09-25','13:59:30','TIN','406000','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-250925-0037','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159292','615973000','406000','616379000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159292' 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 ('F225250159293','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBC-11-T','AS EXTENSION UB 8K ','OL','0.400','1','100.00','384000','0','0','15000','401000','0','5000','0','406000','TIN','T0073257','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBC-11-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-09-25' AND kode_barang='S1G-YIBC-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159293','2025-09-25','0.400','2025-09-25','13:59:30','PLG0072933','401000','401000','5000','406000','406000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159293','2025-09-25','13:59:30','TIN','406000','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-250925-0038','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159293','616379000','406000','616785000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159293' 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 ('F225250159294','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-49-T','AS EXTENSION UB 8K ','OL','0.560','1','100.00','538000','0','0','15000','562000','0','5000','0','567000','TIN','T0073311','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='S1G-YIBD-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159294','2025-09-25','0.560','2025-09-25','13:59:30','PLG0072934','562000','562000','5000','567000','567000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159294','2025-09-25','13:59:30','TIN','567000','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-250925-0039','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159294','616785000','567000','617352000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159294' 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 ('F225250159295','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-51-T','AS EXTENSION UB 8K ','OL','0.560','1','100.00','538000','0','0','15000','562000','0','5000','0','567000','TIN','T0073313','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='S1G-YIBD-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159295','2025-09-25','0.560','2025-09-25','13:59:30','PLG0072935','562000','562000','5000','567000','567000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159295','2025-09-25','13:59:30','TIN','567000','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-250925-0040','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159295','617352000','567000','617919000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159295' 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 ('F225250159296','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-47-T','AS EXTENSION UB 8K ','OL','0.560','1','100.00','538000','0','0','15000','562000','0','5000','0','567000','TIN','T0073309','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='S1G-YIBD-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159296','2025-09-25','0.560','2025-09-25','13:59:30','PLG0072936','562000','562000','5000','567000','567000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159296','2025-09-25','13:59:30','TIN','567000','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-250925-0041','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159296','617919000','567000','618486000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159296' 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 ('F225250159297','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-50-T','AS EXTENSION UB 8K ','OL','0.560','1','100.00','538000','0','0','15000','562000','0','5000','0','567000','TIN','T0073312','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='S1G-YIBD-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159297','2025-09-25','0.560','2025-09-25','13:59:30','PLG0072937','562000','562000','5000','567000','567000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159297','2025-09-25','13:59:30','TIN','567000','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-250925-0042','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159297','618486000','567000','619053000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159297' 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 ('F225250159298','kasir',' 1',' MGS1 UB ','TOKO','SMBK-S','S1G-YIBD-48-T','AS EXTENSION UB 8K ','OL','0.560','1','100.00','538000','0','0','15000','562000','0','5000','0','567000','TIN','T0073310','S1G','0','0','-','0','961000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YIBD-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='S1G-YIBD-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F225250159298','2025-09-25','0.560','2025-09-25','13:59:30','PLG0072938','562000','562000','5000','567000','567000','kasir','2025-09-25 13:59:29','F22525015929');
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-25','F225250159298','2025-09-25','13:59:30','TIN','567000','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-250925-0043','D','2025-09-25','13:59:30','kasir','PENJUALAN','F225250159298','619053000','567000','619620000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250159298' 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 ('F225250211191','kasir','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-YFBF-114-T','KL X NORY HW 42CM 17K ','OL','3.580','1','100.00','5871000','0','0','15000','6025000','0','25000','0','6050000','TIN','T0070481','H1TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YFBF-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.580',berat_jual_asli=berat_jual_asli+'3.580',stock_jual='1',berat_akhir=berat_akhir-'3.580',berat_akhir_asli=berat_akhir_asli-'3.580',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='H1TE-YFBF-114-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225250211191','2025-09-25','3.580','2025-09-25','14:11:20','PLG0072939','6025000','6025000','25000','6050000','6050000','kasir','2025-09-25 14:11:19','F22525021119');
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-25','F225250211191','2025-09-25','14:11:20','TIN','6050000','25000');
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-250925-0044','D','2025-09-25','14:11:20','kasir','PENJUALAN','F225250211191','619620000','6050000','625670000');
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 ('F225250224081','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-YIBD-27-T','LT MODEL FINE GOLD LG 8K ','OL ','0.530','1','100.00','501000','0','0','15000','510000','0','5000','0','515000','RHM','T0073289','D1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YIBD-27-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-09-25' AND kode_barang='D1E-YIBD-27-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 ('F225250224081','2025-09-25','0.530','2025-09-25','14:24:08','PLG0072940','510000','510000','5000','515000','515000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224081','2025-09-25','14:24:08','RHM','515000','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-250925-0045','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224081','625670000','515000','626185000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224081' 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 ('F225250224082','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-YIBD-28-T','LT MODEL FINE GOLD LG 8K ','OL ','0.530','1','100.00','501000','0','0','15000','510000','0','5000','0','515000','RHM','T0073290','D1E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YIBD-28-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-09-25' AND kode_barang='D1E-YIBD-28-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 ('F225250224082','2025-09-25','0.530','2025-09-25','14:24:08','PLG0072941','510000','510000','5000','515000','515000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224082','2025-09-25','14:24:08','RHM','515000','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-250925-0046','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224082','626185000','515000','626700000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224082' 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 ('F225250224083','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-YIBC-413-0','GL X P4 BOLA VAR HW 8K ','OL ','2.550','1','100.00','2410000','0','0','15000','2443000','0','13000','0','2456000','RHM','00370384','F3E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBC-413-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='F3E-YIBC-413-0' 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 ('F225250224083','2025-09-25','2.550','2025-09-25','14:24:08','PLG0072942','2443000','2443000','13000','2456000','2456000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224083','2025-09-25','14:24:08','RHM','2456000','13000');
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-250925-0047','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224083','626700000','2456000','629156000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2456000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224083' 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 ('F225250224084','kasir',' 1',' MFB1F X BW','TOKO','SMBK-B','B1F-YIBC-238-0','GW X MODEL BUNGA MATA BW 8K ','OL ','0.340','1','100.00','328000','0','0','15000','334000','0','5000','0','339000','RHM','00370209','B1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIBC-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='B1F-YIBC-238-0' 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 ('F225250224084','2025-09-25','0.340','2025-09-25','14:24:08','PLG0072943','334000','334000','5000','339000','339000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224084','2025-09-25','14:24:08','RHM','339000','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-250925-0048','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224084','629156000','339000','629495000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='339000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224084' 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 ('F225250224085','kasir',' 1',' MFA1F X UB','TOKO','SMBK-A','A1F-YFXC-12-0','AT X MODEL ARESO VAR UB 8K ','OL ','0.740','1','100.00','699000','0','0','15000','727000','0','5000','0','732000','RHM','00356030','A1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YFXC-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='A1F-YFXC-12-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 ('F225250224085','2025-09-25','0.740','2025-09-25','14:24:08','PLG0072944','727000','727000','5000','732000','732000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224085','2025-09-25','14:24:08','RHM','732000','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-250925-0049','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224085','629495000','732000','630227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='732000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224085' 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 ('F225250224086','kasir',' 1',' MFA1 BW ','TOKO','SMBK-A','A1F-YIBD-1-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL ','0.550','1','100.00','531000','0','0','15000','541000','0','5000','0','546000','RHM','T0073263','A1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YIBD-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='A1F-YIBD-1-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 ('F225250224086','2025-09-25','0.550','2025-09-25','14:24:08','PLG0072945','541000','541000','5000','546000','546000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224086','2025-09-25','14:24:08','RHM','546000','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-250925-0050','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224086','630227000','546000','630773000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='546000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224086' 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 ('F225250224087','kasir',' 1',' MFA1 BW ','TOKO','SMBK-A','A1F-YIXC-24-T','AT MODEL ITALY PANJANG SLEP VAR BW 8K ','OL ','0.550','1','100.00','519000','0','0','15000','541000','0','5000','0','546000','RHM','T0072839','A1F','0','0','-','0','968000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YIXC-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='A1F-YIXC-24-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 ('F225250224087','2025-09-25','0.550','2025-09-25','14:24:08','PLG0072946','541000','541000','5000','546000','546000','kasir','2025-09-25 14:24:08','F22525022408');
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-25','F225250224087','2025-09-25','14:24:08','RHM','546000','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-250925-0051','D','2025-09-25','14:24:08','kasir','PENJUALAN','F225250224087','630773000','546000','631319000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='546000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225250224087' 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 ('F225250239051','kasir','1',' MEE2 X AY ','TOKO','SMBK-E','E2E-YIBD-379-0','CC X MODEL MATA AY 17 8K ','OL','0.680','1','100.00','645000','0','0','15000','653000','0','5000','0','658000','TIN','00370800','E2E','0','0','-','0','948000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBD-379-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='E2E-YIBD-379-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 ('F225250239051','2025-09-25','0.680','2025-09-25','14:39:06','PLG0072947','653000','653000','5000','658000','658000','kasir','2025-09-25 14:39:05','F22525023905');
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-25','F225250239051','2025-09-25','14:39:06','TIN','658000','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-250925-0052','D','2025-09-25','14:39:06','kasir','PENJUALAN','F225250239051','631319000','658000','631977000');
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 ('F225250246491','kasir','1',' TEF3 UB ','TOKO','TBK-F','F3TE-VABX-124-T','GL FANCY VAR UB ','','3.730','1','100.00','6117000','0','0','15000','6248000','0','0','0','6248000','RHM','T0027556','F3TE','0','0','-','0','1640000');
UPDATE tm_barang SET tgl_last_jual='2025-09-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-VABX-124-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2025-09-25' AND kode_barang='F3TE-VABX-124-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 ('F225250246491','2025-09-25','3.730','2025-09-25','14:46:50','PLG0072948','6248000','6248000','0','6248000','6248000','kasir','2025-09-25 14:46:49','F22525024649');
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-25','F225250246491','2025-09-25','14:46:50','RHM','6248000','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-250925-0053','D','2025-09-25','14:46:50','kasir','PENJUALAN','F225250246491','631977000','6248000','638225000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250119461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250119461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250119461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250120111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250120331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250120561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250120561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250121191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250121191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250121191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250121441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250121441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250121441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250122331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250122331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250122331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250142591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250142591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250142591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157346' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157346' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157346';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157347' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157347' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157347';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157348' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157348' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157348';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157349' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250157349' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250157349';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159297' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159297' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159297';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159298' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250159298' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250159298';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250211191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250211191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250211191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224083' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224083' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224083';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224084' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224084' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224084';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224085' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224085' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224085';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224086' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224086' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224086';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224087' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250224087' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250224087';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250239051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250239051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250239051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250246491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250246491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250246491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250854111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250854111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250854111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250857461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250857461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250857461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250857462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250857462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250857462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250950181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250950181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250950181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225250959271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225250959271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225250959271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251002051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251002051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251002051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251027471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251027471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251027471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251027472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251027472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251027472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251122221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251122222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251122223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251122223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251140011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251140011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251140011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251237521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251237521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251237521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251249371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251249371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251249371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225251253121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225251253121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225251253121';
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-00004670','X-00004670','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1292000','2025-09-25','1.900','1','kasir','2025-09-25 15:11:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004670','X-00004670');
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-250925-0001','F225280246281','RTA','1','BELI','BELI001','E2D', 'X-00004670', 'CC WEDDING MATA CM 20 8K','2.000','1.900','100.00','1700000','1292000','680000','928000','1','1292000','1292000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-250925-0001','2025-09-25','2025-09-25','15:11:03','RTA','---','1.900','1292000','1292000','1292000','1292000','1292000','kasir','2025-09-25 15:11:03','FB-250925-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250925-0001','DEWI','SOSO BLITAR','','','','kasir','2025-09-25 15:11:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-25' 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-250925-0054','K','2025-09-25','15:11:03','kasir','PEMBELIAN UMUM','FB-250925-0001','638225000','1292000','636933000');
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-00004671','X-00004671','LT Q5 SLOBOK BULAT HURUF BG A 8K','GR','---','D1G','BELI','BELI001','340000','2025-09-25','0.500','1','kasir','2025-09-25 15:11:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00004671','X-00004671');
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-250925-0002','F224071030451','RHM','1','BELI','BELI001','D1G', 'X-00004671', 'LT Q5 SLOBOK BULAT HURUF BG A 8K','0.520','0.500','100.00','327000','340000','680000','961000','1','340000','340000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-250925-0002','2025-09-25','2025-09-25','15:11:31','RHM','---','0.500','340000','340000','340000','340000','340000','kasir','2025-09-25 15:11:32','FB-250925-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250925-0002','PUTRI','JL WILIS 8 BANYUDONO','','','','kasir','2025-09-25 15:11:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-25' 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-250925-0055','K','2025-09-25','15:11:31','kasir','PEMBELIAN UMUM','FB-250925-0002','636933000','340000','636593000');
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-00004672','X-00004672','CC MODEL MATA VAR LG 13 8K','GR','---','E2E','BELI','BELI001','387000','2025-09-25','0.510','1','kasir','2025-09-25 15:12:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004672','X-00004672');
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-250925-0003','F225090233521','RTA','1','BELI','BELI001','E2E', 'X-00004672', 'CC MODEL MATA VAR LG 13 8K','0.510','0.510','100.00','430000','387000','758824','948000','1','387000','387000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-25' 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-250925-0003','2025-09-25','2025-09-25','15:12:15','RTA','---','0.510','387000','387000','387000','387000','387000','kasir','2025-09-25 15:12:16','FB-250925-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250925-0003','FITRI','JL IRAWAN NO 42','','','0895366122452','kasir','2025-09-25 15:12:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-25' 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-250925-0056','K','2025-09-25','15:12:15','kasir','PEMBELIAN UMUM','FB-250925-0003','636593000','387000','636206000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250925-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250925-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250925-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250925-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250925-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250925-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-25';
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-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-25';
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-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-25' 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-250926-0001','D','2025-09-26','16:03:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','636206000','636206000');
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-250926-0001','D','2025-09-26','16:03:30','BCA','SALDO AWAL','SALDO AWAL','0','4002083888','4002083888');
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-250926-0001','D','2025-09-26','16:03:30','','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-250926-0001','D','2025-09-26','16:03:30','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-250926-0001','D','2025-09-26','16:03:30','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-250926-0001','D','2025-09-26','16:03:30','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-09-26';