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 ('F226140835341','kasir','1',' TEE2 YT 16','TOKO','TBK-E','E2TE-WGBE-54-T','CC MODEL HATI MATA YT 16 ','OL','1.120','1','100.00','2397000','0','0','15000','2400000','0','8000','0','2408000','NS','T0046601','E2TE','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WGBE-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2TE-WGBE-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226140835341','2026-04-14','1.120','2026-04-14','08:35:34','PLG0079065','2400000','2400000','8000','2408000','2408000','kasir','2026-04-14 08:35:34','F22614083534');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140835341','2026-04-14','08:35:34','NS','2408000','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-260414-0002','D','2026-04-14','08:35:34','kasir','PENJUALAN','F226140835341','8467107000','2408000','8469515000');
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 ('F226140949411','kasir','1',' TFF3 X HW ','TOKO','TBK-F','F3TF-YJBH-58-T','GL X KOREA HW 17K ','','1.960','1','100.00','4234000','0','0','15000','4235000','0','0','0','4235000','RTA','T0074540','F3TF','0','0','-','0','2160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJBH-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3TF-YJBH-58-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 ('F226140949411','2026-04-14','1.960','2026-04-14','09:49:42','PLG0079066','4235000','4235000','0','4235000','4235000','kasir','2026-04-14 09:49:41','F22614094941');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140949411','2026-04-14','09:49:42','RTA','4235000','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-260414-0003','D','2026-04-14','09:49:42','kasir','PENJUALAN','F226140949411','8469515000','4235000','8473750000');
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 ('F226141013311','kasir','1',' MDE2 X YT ','TOKO','SMBK-E','E2D-ZDAX-344-0','CC X MODEL MATA YT 16 8K ','OL','0.930','1','100.00','1083000','0','0','15000','1093000','0','5000','0','1098000','TIN','00399114','E2D','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAX-344-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2D-ZDAX-344-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 ('F226141013311','2026-04-14','0.930','2026-04-14','10:13:32','PLG0079067','1093000','1093000','5000','1098000','1098000','kasir','2026-04-14 10:13:31','F22614101331');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141013311','2026-04-14','10:13:32','TIN','1098000','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-260414-0004','D','2026-04-14','10:13:32','kasir','PENJUALAN','F226141013311','8473750000','1098000','8474848000');
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 ('F226141014051','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YLBC-97-T','GW TUSUK MODEL MATA LG PE 8K ','OL','0.510','1','100.00','604000','0','0','15000','610000','0','5000','0','615000','NS','T0076159','B1E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBC-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='B1E-YLBC-97-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 ('F226141014051','2026-04-14','0.510','2026-04-14','10:14:05','PLG0079068','610000','610000','5000','615000','615000','kasir','2026-04-14 10:14:05','F22614101405');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141014051','2026-04-14','10:14:05','NS','615000','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-260414-0005','D','2026-04-14','10:14:05','kasir','PENJUALAN','F226141014051','8474848000','615000','8475463000');
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 ('F226141043251','kasir','1',' MDE2D CM 1','TOKO','SMBK-E','E2D-YJAH-38-T','CC MODEL MATA CM 14 8K ','OL','0.870','1','100.00','1014000','0','0','15000','1022000','0','5000','0','1027000','NS','T0074251','E2D','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAH-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2D-YJAH-38-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 ('F226141043251','2026-04-14','0.870','2026-04-14','10:43:26','PLG0079069','1022000','1022000','5000','1027000','1027000','kasir','2026-04-14 10:43:25','F22614104325');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141043251','2026-04-14','10:43:26','NS','1027000','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-260414-0006','D','2026-04-14','10:43:26','kasir','PENJUALAN','F226141043251','8475463000','1027000','8476490000');
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 ('F226141044051','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXA-33-T','CC MODEL MATA VAR CM 14 8K ','OL','0.820','1','100.00','972000','0','0','15000','980000','0','5000','0','985000','NS','T0073525','E2E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXA-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2E-YJXA-33-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 ('F226141044051','2026-04-14','0.820','2026-04-14','10:44:06','PLG0079070','980000','980000','5000','985000','985000','kasir','2026-04-14 10:44:05','F22614104405');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141044051','2026-04-14','10:44:06','NS','985000','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-260414-0007','D','2026-04-14','10:44:06','kasir','PENJUALAN','F226141044051','8476490000','985000','8477475000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='985000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141044051' 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 ('F226141044052','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZCAX-8-T','CC MODEL MATA VAR CM 14 8K ','OL','0.750','1','100.00','889000','0','0','15000','896000','0','5000','0','901000','NS','T0077949','E2E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2E-ZCAX-8-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 ('F226141044052','2026-04-14','0.750','2026-04-14','10:44:06','PLG0079071','896000','896000','5000','901000','901000','kasir','2026-04-14 10:44:05','F22614104405');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141044052','2026-04-14','10:44:06','NS','901000','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-260414-0008','D','2026-04-14','10:44:06','kasir','PENJUALAN','F226141044052','8477475000','901000','8478376000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='901000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226141044052' 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 ('F226141101371','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZCCX-477-0','CC X MODEL MATA CM 14 8K ','OL','1.580','1','100.00','1841000','0','0','15000','1849000','0','8000','0','1857000','RTA','00397131','E2D','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-477-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2D-ZCCX-477-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 ('F226141101371','2026-04-14','1.580','2026-04-14','11:01:37','PLG0079072','1849000','1849000','8000','1857000','1857000','kasir','2026-04-14 11:01:37','F22614110137');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141101371','2026-04-14','11:01:37','RTA','1857000','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-260414-0009','D','2026-04-14','11:01:37','kasir','PENJUALAN','F226141101371','8478376000','1857000','8480233000');
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 ('F226141140351','kasir','1',' TDE2 15K C','TOKO','TBK-E','E2TD-ZAAI-101-T','CC WEDDING MATA CM 12 17K ','','2.080','1','100.00','4410000','0','0','15000','4410000','0','15000','0','4425000','RTA','T0076766','E2TD','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZAAI-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2TD-ZAAI-101-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226141140351','2026-04-14','2.080','2026-04-14','11:40:35','PLG0079073','4410000','4410000','15000','4425000','4425000','kasir','2026-04-14 11:40:35','F22614114035');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141140351','2026-04-14','11:40:35','RTA','4425000','15000');
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-260414-0010','D','2026-04-14','11:40:35','kasir','PENJUALAN','F226141140351','8480233000','4425000','8484658000');
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 ('F226141142161','kasir','1',' MEF3 PM ','TOKO','SMBK-F','F3E-ZDAC-8-T','GL MODEL DAUN SLEP VAR PM 8K ','','2.970','1','100.00','3519000','0','0','15000','3520000','0','0','0','3520000','RTA','T0078627','F3E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAC-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3E-ZDAC-8-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 ('F226141142161','2026-04-14','2.970','2026-04-14','11:42:17','PLG0079074','3520000','3520000','0','3520000','3520000','kasir','2026-04-14 11:42:16','F22614114216');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141142161','2026-04-14','11:42:17','RTA','3520000','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-260414-0011','D','2026-04-14','11:42:17','kasir','PENJUALAN','F226141142161','8484658000','3520000','8488178000');
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 ('F226141213341','kasir','1',' MDE1 HW 15','TOKO','SMBK-E','E1D-ZCXF-35-T','CC MODEL DAUN SLEP VAR HW 15 8K ','','1.060','1','100.00','1235000','0','0','15000','1235000','0','0','0','1235000','RHM','T0077857','E1D','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXF-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E1D-ZCXF-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 ('F226141213341','2026-04-14','1.060','2026-04-14','12:13:34','PLG0079075','1235000','1235000','0','1235000','1235000','kasir','2026-04-14 12:13:34','F22614121334');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141213341','2026-04-14','12:13:34','RHM','1235000','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-260414-0012','D','2026-04-14','12:13:34','kasir','PENJUALAN','F226141213341','8488178000','1235000','8489413000');
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 ('F226141225191','kasir','1',' TEH1 UB 42','TOKO','TBK-H','H1TE-YGAH-186-T','KL NORY UB 42CM 17K ','','1.010','1','100.00','2161000','0','0','15000','2161000','0','0','0','2161000','RTA','T0071217','H1TE','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YGAH-186-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='H1TE-YGAH-186-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 ('F226141225191','2026-04-14','1.010','2026-04-14','12:25:20','PLG0079076','2161000','2161000','0','2161000','2161000','kasir','2026-04-14 12:25:19','F22614122519');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141225191','2026-04-14','12:25:20','RTA','2161000','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-260414-0013','D','2026-04-14','12:25:20','kasir','PENJUALAN','F226141225191','8489413000','2161000','8491574000');
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 ('F226141226001','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZCAX-2-T','CC MODEL MATA VAR CM 14 8K ','','0.650','1','100.00','770000','0','0','15000','770000','0','0','0','770000','RTA','T0077943','E2E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='E2E-ZCAX-2-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 ('F226141226001','2026-04-14','0.650','2026-04-14','12:26:01','PLG0079077','770000','770000','0','770000','770000','kasir','2026-04-14 12:26:00','F22614122600');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141226001','2026-04-14','12:26:01','RTA','770000','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-260414-0014','D','2026-04-14','12:26:01','kasir','PENJUALAN','F226141226001','8491574000','770000','8492344000');
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 ('F226141229221','kasir','1',' MGF3G UB ','TOKO','SMBK-F','F3G-YJAE-51-T','GL RANTAI HOLLOW UB 8K ','ol','0.360','1','100.00','441000','0','0','15000','445000','0','5000','0','450000','TIN','T0074100','F3G','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YJAE-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3G-YJAE-51-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 ('F226141229221','2026-04-14','0.360','2026-04-14','12:29:22','PLG0079078','445000','445000','5000','450000','450000','kasir','2026-04-14 12:29:22','F22614122922');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141229221','2026-04-14','12:29:22','TIN','450000','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-260414-0015','D','2026-04-14','12:29:22','kasir','PENJUALAN','F226141229221','8492344000','450000','8492794000');
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 ('F226141249181','kasir','1',' MEE2 CM 12','TOKO','SMBK-E','E2E-ZCCA-79-T','CC MODEL HATI MATA VAR CM 12 8K ','ol','0.530','1','100.00','628000','0','0','15000','633000','0','5000','0','638000','RTA','T0078375','E2E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCCA-79-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='2026-04-14' AND kode_barang='E2E-ZCCA-79-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 ('F226141249181','2026-04-14','0.530','2026-04-14','12:49:19','PLG0079079','633000','633000','5000','638000','638000','kasir','2026-04-14 12:49:18','F22614124918');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226141249181','2026-04-14','12:49:19','RTA','638000','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-260414-0016','D','2026-04-14','12:49:19','kasir','PENJUALAN','F226141249181','8492794000','638000','8493432000');
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 ('F226140124301','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZAXE-104-0','GL X TIFF MATA SERUT UB 8K ','ol','1.150','1','100.00','1363000','0','0','15000','1368000','0','6000','0','1374000','RTA','00384025','F3E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXE-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3E-ZAXE-104-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 ('F226140124301','2026-04-14','1.150','2026-04-14','13:24:31','PLG0079080','1368000','1368000','6000','1374000','1374000','kasir','2026-04-14 13:24:30','F22614012430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140124301','2026-04-14','13:24:31','RTA','1374000','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-260414-0017','D','2026-04-14','13:24:31','kasir','PENJUALAN','F226140124301','8493432000','1374000','8494806000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140124301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140124301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140124301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140835341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140835341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140835341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140949411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140949411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140949411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141013311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141013311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141013311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141014051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141014051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141014051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141043251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141043251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141043251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141044051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141044051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141044051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141044052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141044052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141044052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141101371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141101371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141101371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141140351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141140351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141140351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141142161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141142161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141142161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141213341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141213341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141213341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141225191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141225191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141225191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141226001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141226001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141226001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141229221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141229221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141229221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141249181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141249181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141249181';
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 ('F226140256401','kasir','1',' MGB1G LG ','TOKO','SMBK-B','B1G-YLAF-84-T','GW TUSUK MATA LG 8K ','','0.310','1','100.00','380000','0','0','15000','380000','0','0','0','380000','RHM','T0075904','B1G','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YLAF-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='B1G-YLAF-84-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 ('F226140256401','2026-04-14','0.310','2026-04-14','14:56:40','PLG0079081','380000','380000','0','380000','380000','kasir','2026-04-14 14:56:40','F22614025640');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140256401','2026-04-14','14:56:40','RHM','380000','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-260414-0018','D','2026-04-14','14:56:40','kasir','PENJUALAN','F226140256401','8494806000','380000','8495186000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140256401' 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 ('F226140256402','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZCBE-246-0','GL X TIFF SPECTRA VAR SERUT UB 8K ','','1.320','1','100.00','1564000','0','0','15000','1564000','0','0','0','1564000','RHM','00396708','F3E','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCBE-246-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3E-ZCBE-246-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 ('F226140256402','2026-04-14','1.320','2026-04-14','14:56:40','PLG0079082','1564000','1564000','0','1564000','1564000','kasir','2026-04-14 14:56:40','F22614025640');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140256402','2026-04-14','14:56:40','RHM','1564000','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-260414-0019','D','2026-04-14','14:56:40','kasir','PENJUALAN','F226140256402','8495186000','1564000','8496750000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1564000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140256402' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140256401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140256401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140256401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140256402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140256402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140256402';
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 ('F226140334511','kasir','1',' MGS1G X DG','TOKO','SMBK-S','S1G-ZDAX-82-0','AS X EXTENTION DG 8K ','','0.200','1','100.00','245000','0','0','15000','245000','0','0','0','245000','RTA','00398852','S1G','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZDAX-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='S1G-ZDAX-82-0' 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 ('F226140334511','2026-04-14','0.200','2026-04-14','15:34:52','PLG0079083','245000','245000','0','245000','245000','kasir','2026-04-14 15:34:51','F22614033451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140334511','2026-04-14','15:34:52','RTA','245000','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-260414-0020','D','2026-04-14','15:34:52','kasir','PENJUALAN','F226140334511','8496750000','245000','8496995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140334511' 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 ('F226140334512','kasir',' 1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHAB-41-T','GL RANTAI HOLLOW UB 8K ','','0.370','1','100.00','453000','0','0','15000','453000','0','0','0','453000','RTA','T0072248','F3G','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-04-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHAB-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-04-14' AND kode_barang='F3G-YHAB-41-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 ('F226140334512','2026-04-14','0.370','2026-04-14','15:34:52','PLG0079084','453000','453000','0','453000','453000','kasir','2026-04-14 15:34:51','F22614033451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-14','F226140334512','2026-04-14','15:34:52','RTA','453000','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-260414-0021','D','2026-04-14','15:34:52','kasir','PENJUALAN','F226140334512','8496995000','453000','8497448000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='453000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140334512' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140334511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140334511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140334511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140334512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140334512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140334512';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-04-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-14' 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-260415-0001','D','2026-04-15','16:02:18','SYSTEM','SALDO AWAL','SALDO AWAL','0','8497448000','8497448000');
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-260415-0001','D','2026-04-15','16:02:18','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260415-0001','D','2026-04-15','16:02:18','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-260415-0001','D','2026-04-15','16:02:18','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-260415-0001','D','2026-04-15','16:02:18','','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-260415-0001','D','2026-04-15','16:02:18','BCA','SALDO AWAL','SALDO AWAL','0','4353255888','4353255888');
UPDATE tp_system SET tgl_system='2026-04-15';