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 ('F226240818501','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZABC-18-T','CC MODEL BUNGA CLOVER SLEP CM 16 8K ','OL','0.950','1','100.00','1173000','0','0','15000','1188000','0','5000','0','1193000','NS','T0076908','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZABC-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E1D-ZABC-18-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 ('F226240818501','2026-02-24','0.950','2026-02-24','08:18:50','PLG0077586','1188000','1188000','5000','1193000','1193000','kasir','2026-02-24 08:18:50','F22624081850');
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-02-24','F226240818501','2026-02-24','08:18:50','NS','1193000','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-260224-0002','D','2026-02-24','08:18:50','kasir','PENJUALAN','F226240818501','6375952000','1193000','6377145000');
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 ('F226240904381','kasir','1',' MEH1 UB 46','TOKO','SMBK-H','H1E-ZAAI-64-T','KL NORY UB 46CM 8K ','OLS KGE38','1.000','1','100.00','1255000','0','0','15000','1275000','0','110000','0','1385000','RHM','T0076729','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAI-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H1E-ZAAI-64-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 ('F226240904381','2026-02-24','1.000','2026-02-24','09:04:38','PLG0077587','1275000','1275000','110000','1385000','1385000','kasir','2026-02-24 09:04:38','F22624090438');
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-02-24','F226240904381','2026-02-24','09:04:38','RHM','1385000','110000');
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-260224-0003','D','2026-02-24','09:04:38','kasir','PENJUALAN','F226240904381','6377145000','1385000','6378530000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1385000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240904381' 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 ('F226240904382','kasir',' 1',' MDD1 LG ','TOKO','SMBK-D','D1D-ZBAI-47-T','LT MODEL SLEP VAR LG 8K ','OLS KGE38','0.950','1','100.00','1173000','0','0','15000','1207000','0','110000','0','1317000','RHM','T0077579','D1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZBAI-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='D1D-ZBAI-47-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 ('F226240904382','2026-02-24','0.950','2026-02-24','09:04:38','PLG0077588','1207000','1207000','110000','1317000','1317000','kasir','2026-02-24 09:04:38','F22624090438');
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-02-24','F226240904382','2026-02-24','09:04:38','RHM','1317000','110000');
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-260224-0004','D','2026-02-24','09:04:38','kasir','PENJUALAN','F226240904382','6378530000','1317000','6379847000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1317000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240904382' 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 ('F226240942431','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZAAC-40-T','GW TUSUK DAISY MATA CM 8K ','OL','0.270','1','100.00','355000','0','0','15000','365000','0','5000','0','370000','RTA','T0076562','B1H','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZAAC-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='B1H-ZAAC-40-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 ('F226240942431','2026-02-24','0.270','2026-02-24','09:42:44','PLG0077589','365000','365000','5000','370000','370000','kasir','2026-02-24 09:42:43','F22624094243');
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-02-24','F226240942431','2026-02-24','09:42:44','RTA','370000','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-260224-0005','D','2026-02-24','09:42:44','kasir','PENJUALAN','F226240942431','6379847000','370000','6380217000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240942431' 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 ('F226240942432','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZAAC-35-T','GW TUSUK DAISY MATA CM 8K ','OL','0.280','1','100.00','368000','0','0','15000','378000','0','5000','0','383000','RTA','T0076557','B1H','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZAAC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='B1H-ZAAC-35-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 ('F226240942432','2026-02-24','0.280','2026-02-24','09:42:44','PLG0077590','378000','378000','5000','383000','383000','kasir','2026-02-24 09:42:43','F22624094243');
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-02-24','F226240942432','2026-02-24','09:42:44','RTA','383000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260224-0006','D','2026-02-24','09:42:44','kasir','PENJUALAN','F226240942432','6380217000','383000','6380600000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='383000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240942432' 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 ('F226240942433','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YLAF-91-T','GW MODEL MATA LG PE 8K','OL','0.580','1','100.00','728000','0','0','15000','748000','0','5000','0','753000','RTA','T0075911','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLAF-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='B1E-YLAF-91-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 ('F226240942433','2026-02-24','0.580','2026-02-24','09:42:44','PLG0077591','748000','748000','5000','753000','753000','kasir','2026-02-24 09:42:43','F22624094243');
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-02-24','F226240942433','2026-02-24','09:42:44','RTA','753000','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-260224-0007','D','2026-02-24','09:42:44','kasir','PENJUALAN','F226240942433','6380600000','753000','6381353000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='753000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226240942433' 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 ('F226241017341','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAI-13-T','GL SANTA SERUT BUNGA CLOVER SLEP UB 8K ','','2.060','1','100.00','2585000','0','0','15000','2596000','0','0','0','2596000','RTA','T0077545','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-13-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='2026-02-24' AND kode_barang='F3E-ZBAI-13-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 ('F226241017341','2026-02-24','2.060','2026-02-24','10:17:35','PLG0077592','2596000','2596000','0','2596000','2596000','kasir','2026-02-24 10:17:34','F22624101734');
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-02-24','F226241017341','2026-02-24','10:17:35','RTA','2596000','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-260224-0008','D','2026-02-24','10:17:35','kasir','PENJUALAN','F226241017341','6381353000','2596000','6383949000');
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 ('F226241027031','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZBAG-8-T','LT MODEL BOTEGA LG 8K ','OL','0.500','1','100.00','627000','0','0','15000','638000','0','5000','0','643000','RTA','T0077450','D1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAG-8-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='2026-02-24' AND kode_barang='D1E-ZBAG-8-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 ('F226241027031','2026-02-24','0.500','2026-02-24','10:27:04','PLG0077593','638000','638000','5000','643000','643000','kasir','2026-02-24 10:27:03','F22624102703');
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-02-24','F226241027031','2026-02-24','10:27:04','RTA','643000','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-260224-0009','D','2026-02-24','10:27:04','kasir','PENJUALAN','F226241027031','6383949000','643000','6384592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241027031' 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 ('F226241027032','kasir',' 1',' MEF3 LT ','TOKO','SMBK-F','F3E-ZBAI-94-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL','1.030','1','100.00','1293000','0','0','15000','1308000','0','5000','0','1313000','RTA','T0077626','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F3E-ZBAI-94-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 ('F226241027032','2026-02-24','1.030','2026-02-24','10:27:04','PLG0077594','1308000','1308000','5000','1313000','1313000','kasir','2026-02-24 10:27:03','F22624102703');
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-02-24','F226241027032','2026-02-24','10:27:04','RTA','1313000','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-260224-0010','D','2026-02-24','10:27:04','kasir','PENJUALAN','F226241027032','6384592000','1313000','6385905000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1313000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241027032' 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 ('F226241028391','kasir','1',' MGD1G X LG','TOKO','SMBK-D','D1G-YIAB-70-0','LT X BONEKA ANAK CAT LG 8K ','','0.380','1','100.00','484000','0','0','15000','495000','0','5000','0','500000','NS','00368847','D1G','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIAB-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='D1G-YIAB-70-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 ('F226241028391','2026-02-24','0.380','2026-02-24','10:28:40','PLG0077595','495000','495000','5000','500000','500000','kasir','2026-02-24 10:28:39','F22624102839');
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-02-24','F226241028391','2026-02-24','10:28:40','NS','500000','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-260224-0011','D','2026-02-24','10:28:40','kasir','PENJUALAN','F226241028391','6385905000','500000','6386405000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241028391' 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 ('F226241028392','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-ZBAX-22-T','KL SANTA BOLA PASIR VAR HW 8K ','','2.020','1','100.00','2535000','0','0','15000','2545000','0','10000','0','2555000','NS','T0077137','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-22-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='2026-02-24' AND kode_barang='H1E-ZBAX-22-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 ('F226241028392','2026-02-24','2.020','2026-02-24','10:28:40','PLG0077596','2545000','2545000','10000','2555000','2555000','kasir','2026-02-24 10:28:39','F22624102839');
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-02-24','F226241028392','2026-02-24','10:28:40','NS','2555000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260224-0012','D','2026-02-24','10:28:40','kasir','PENJUALAN','F226241028392','6386405000','2555000','6388960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241028392' 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 ('F226241042411','kasir','1',' MDA1D CM','TOKO','SMBK-A','A1D-ZBAC-71-T','AT HUGGIES SPECTRA SLEP CM 8K','','1.200','1','100.00','1482000','0','0','15000','1482000','0','0','0','1482000','NS','T0077280','A1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAC-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='A1D-ZBAC-71-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 ('F226241042411','2026-02-24','1.200','2026-02-24','10:42:42','PLG0000001','1482000','1482000','0','1482000','1482000','kasir','2026-02-24 10:42:41','F22624104241');
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-02-24','F226241042411','2026-02-24','10:42:42','NS','1482000','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-260224-0013','D','2026-02-24','10:42:42','kasir','PENJUALAN','F226241042411','6388960000','1482000','6390442000');
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 ('F226241111121','kasir','1',' MDA1D CM','TOKO','SMBK-A','A1D-ZBAC-71-T','AT HUGGIES SPECTRA SLEP CM 8K','','1.200','1','100.00','1482000','0','0','15000','1482000','0','0','0','1482000','NS','T0077280','A1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAC-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='A1D-ZBAC-71-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 ('F226241111121','2026-02-24','1.200','2026-02-24','11:11:13','PLG0000001','1482000','1482000','0','1482000','1482000','kasir','2026-02-24 11:11:12','F22624111112');
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-02-24','F226241111121','2026-02-24','11:11:13','NS','1482000','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-260224-0015','D','2026-02-24','11:11:13','kasir','PENJUALAN','F226241111121','6388960000','1482000','6390442000');
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 ('F226241121301','kasir','1',' MEF3 15K U','TOKO','SMBK-F','F3E-ZBAX-19-T','GL TRIXIE SERUT SPECTRA VAR UB 8K ','OL','1.640','1','100.00','2058000','0','0','15000','2076000','0','15000','0','2091000','TIN','T0077134','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F3E-ZBAX-19-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 ('F226241121301','2026-02-24','1.640','2026-02-24','11:21:31','PLG0077597','2076000','2076000','15000','2091000','2091000','kasir','2026-02-24 11:21:30','F22624112130');
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-02-24','F226241121301','2026-02-24','11:21:31','TIN','2091000','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-260224-0016','D','2026-02-24','11:21:31','kasir','PENJUALAN','F226241121301','6390442000','2091000','6392533000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241111121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241111121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241111121';
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 ('F226241131541','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZBAD-238-0','KL X SANTA AUREL MATA HW 42 8K ','OL','2.320','1','100.00','2912000','0','0','15000','2946000','0','12000','0','2958000','RTA','00389844','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAD-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H1E-ZBAD-238-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 ('F226241131541','2026-02-24','2.320','2026-02-24','11:31:55','PLG0077598','2946000','2946000','12000','2958000','2958000','kasir','2026-02-24 11:31:54','F22624113154');
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-02-24','F226241131541','2026-02-24','11:31:55','RTA','2958000','12000');
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-260224-0018','D','2026-02-24','11:31:55','kasir','PENJUALAN','F226241131541','6391051000','2958000','6394009000');
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 ('F226241152011','kasir','1',' TFH1 HW 32','TOKO','TBK-H','H1TF-YGBD-85-T','KL ANAK SANTA HW 32CM 17K ','','2.120','1','100.00','4887000','0','0','15000','4855000','0','0','0','4855000','TJ','T0071513','H1TF','0','0','-','1','2305000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YGBD-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H1TF-YGBD-85-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 ('F226241152011','2026-02-24','2.120','2026-02-24','11:52:01','PLG0077599','4855000','4855000','0','4855000','4855000','kasir','2026-02-24 11:52:01','F22624115201');
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-02-24','F226241152011','2026-02-24','11:52:01','TJ','4855000','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-260224-0019','D','2026-02-24','11:52:01','kasir','PENJUALAN','F226241152011','6394009000','4855000','6398864000');
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 ('F226241201511','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZBAH-83-T','GW TRIXIE PANJANG PITA MATA VAR LG 8K ','OL','0.590','1','100.00','740000','0','0','15000','752000','0','5000','0','757000','NS','T0077528','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAH-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='B1E-ZBAH-83-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 ('F226241201511','2026-02-24','0.590','2026-02-24','12:01:51','PLG0077600','752000','752000','5000','757000','757000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201511','2026-02-24','12:01:51','NS','757000','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-260224-0020','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201511','6398864000','757000','6399621000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='757000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201511' 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 ('F226241201512','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAH-33-T','GL MODEL CAPELA VAR HW 8K ','OL','1.200','1','100.00','1506000','0','0','15000','1524000','0','6000','0','1530000','NS','T0077478','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAH-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F3E-ZBAH-33-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 ('F226241201512','2026-02-24','1.200','2026-02-24','12:01:51','PLG0077601','1524000','1524000','6000','1530000','1530000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201512','2026-02-24','12:01:51','NS','1530000','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-260224-0021','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201512','6399621000','1530000','6401151000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201512' 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 ('F226241201513','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZBAC-7-T','GL FANCY MODEL VAR HW 8K ','OL','1.380','1','100.00','1732000','0','0','15000','1753000','0','7000','0','1760000','NS','T0077216','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAC-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F3E-ZBAC-7-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 ('F226241201513','2026-02-24','1.380','2026-02-24','12:01:51','PLG0077602','1753000','1753000','7000','1760000','1760000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201513','2026-02-24','12:01:51','NS','1760000','7000');
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-260224-0022','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201513','6401151000','1760000','6402911000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1760000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201513' 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 ('F226241201514','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZBAI-26-T','CC MODEL SLEP VAR CM 16 8K ','OL','1.220','1','100.00','1507000','0','0','15000','1525000','0','6000','0','1531000','NS','T0077558','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAI-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E1D-ZBAI-26-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 ('F226241201514','2026-02-24','1.220','2026-02-24','12:01:51','PLG0077603','1525000','1525000','6000','1531000','1531000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201514','2026-02-24','12:01:51','NS','1531000','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-260224-0023','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201514','6402911000','1531000','6404442000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1531000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201514' 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 ('F226241201515','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAI-6-T','GL MODEL SIEM COBRA UB 8K ','OL','0.410','1','100.00','515000','0','0','15000','523000','0','5000','0','528000','NS','T0077538','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-6-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='2026-02-24' AND kode_barang='F3E-ZBAI-6-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 ('F226241201515','2026-02-24','0.410','2026-02-24','12:01:51','PLG0077604','523000','523000','5000','528000','528000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201515','2026-02-24','12:01:51','NS','528000','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-260224-0024','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201515','6404442000','528000','6404970000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='528000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201515' 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 ('F226241201516','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-ZBAI-60-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.600','1','100.00','753000','0','0','15000','765000','0','5000','0','770000','NS','T0077592','A1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='A1E-ZBAI-60-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 ('F226241201516','2026-02-24','0.600','2026-02-24','12:01:51','PLG0077605','765000','765000','5000','770000','770000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201516','2026-02-24','12:01:51','NS','770000','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-260224-0025','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201516','6404970000','770000','6405740000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201516' 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 ('F226241201517','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-ZBAI-62-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.600','1','100.00','753000','0','0','15000','765000','0','5000','0','770000','NS','T0077594','A1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='A1E-ZBAI-62-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 ('F226241201517','2026-02-24','0.600','2026-02-24','12:01:51','PLG0077606','765000','765000','5000','770000','770000','kasir','2026-02-24 12:01:51','F22624120151');
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-02-24','F226241201517','2026-02-24','12:01:51','NS','770000','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-260224-0026','D','2026-02-24','12:01:51','kasir','PENJUALAN','F226241201517','6405740000','770000','6406510000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241201517' 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 ('F226241210151','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZAAG-48-T','GL KAKI MODEL FANCY VAR KH 8K ','','3.070','1','100.00','3853000','0','0','15000','3868000','0','0','0','3868000','RTA','T0076642','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAG-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F3E-ZAAG-48-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 ('F226241210151','2026-02-24','3.070','2026-02-24','12:10:16','PLG0077607','3868000','3868000','0','3868000','0','kasir','2026-02-24 12:10:15','F22624121015');
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-02-24','F226241210151','2026-02-24','12:10:16','RTA','3868000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260224-0001','2026-02-24','2026-02-24 12:10:15','PENJUALAN : F226241210151','909887766565','BCA','3868000','3868000','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-260224-0002','D','2026-02-24','12:10:16','BCA','PENJUALAN','F226241210151','4283342888','3868000','4287210888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('909887766565','BASORI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3868000' WHERE no_faktur_jual='F226241210151' 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 ('F226241211011','kasir','1',' MEB1 X CM ','TOKO','SMBK-B','B1E-XFAX-5-T','GW X TUSUK MODEL HATI VAR CM PE 8K ','','0.650','1','100.00','816000','0','0','15000','820000','0','0','0','820000','RTA','T0057848','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-XFAX-5-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-02-24' AND kode_barang='B1E-XFAX-5-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 ('F226241211011','2026-02-24','0.650','2026-02-24','12:11:02','PLG0077608','820000','820000','0','820000','0','kasir','2026-02-24 12:11:01','F22624121101');
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-02-24','F226241211011','2026-02-24','12:11:02','RTA','820000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260224-0002','2026-02-24','2026-02-24 12:11:01','PENJUALAN : F226241211011','89877676565','BCA','820000','820000','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-260224-0003','D','2026-02-24','12:11:02','BCA','PENJUALAN','F226241211011','4287210888','820000','4288030888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89877676565','BASORI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='820000' WHERE no_faktur_jual='F226241211011' 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 ('F226241214351','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJAH-105-T','LT CHARM BULAT HURUF K BG 8K ','OL','0.340','1','100.00','440000','0','0','15000','452000','0','5000','0','457000','NS','T0074318','D1G','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJAH-105-T' 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='2026-02-24' AND kode_barang='D1G-YJAH-105-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 ('F226241214351','2026-02-24','0.340','2026-02-24','12:14:36','PLG0077609','452000','452000','5000','457000','457000','kasir','2026-02-24 12:14:35','F22624121435');
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-02-24','F226241214351','2026-02-24','12:14:36','NS','457000','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-260224-0027','D','2026-02-24','12:14:36','kasir','PENJUALAN','F226241214351','6406510000','457000','6406967000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='457000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241214351' 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 ('F226241214352','kasir',' 1',' MFD1 X BG ','TOKO','SMBK-D','D1F-YDXC-67-0','LT X SLOBOK HURUF BG T 8K ','OL','0.560','1','100.00','714000','0','0','15000','734000','0','5000','0','739000','NS','00347774','D1F','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YDXC-67-0' 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='2026-02-24' AND kode_barang='D1F-YDXC-67-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 ('F226241214352','2026-02-24','0.560','2026-02-24','12:14:36','PLG0077610','734000','734000','5000','739000','739000','kasir','2026-02-24 12:14:35','F22624121435');
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-02-24','F226241214352','2026-02-24','12:14:36','NS','739000','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-260224-0028','D','2026-02-24','12:14:36','kasir','PENJUALAN','F226241214352','6406967000','739000','6407706000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='739000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241214352' 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 ('F226241214353','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZBAI-17-T','GL OVAL MODEL C UB D58 8K ','OL','2.330','1','100.00','2924000','0','0','15000','2994000','0','12000','0','3006000','NS','T0077549','F1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAI-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='F1E-ZBAI-17-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 ('F226241214353','2026-02-24','2.330','2026-02-24','12:14:36','PLG0077611','2994000','2994000','12000','3006000','3006000','kasir','2026-02-24 12:14:35','F22624121435');
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-02-24','F226241214353','2026-02-24','12:14:36','NS','3006000','12000');
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-260224-0029','D','2026-02-24','12:14:36','kasir','PENJUALAN','F226241214353','6407706000','3006000','6410712000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3006000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241214353' 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 ('F226241217031','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZAXG-27-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.460','1','100.00','577000','0','0','15000','585000','0','5000','0','590000','RTA','T0076318','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZAXG-27-T' 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='2026-02-24' AND kode_barang='B1E-ZAXG-27-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 ('F226241217031','2026-02-24','0.460','2026-02-24','12:17:04','PLG0077612','585000','585000','5000','590000','590000','kasir','2026-02-24 12:17:03','F22624121703');
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-02-24','F226241217031','2026-02-24','12:17:04','RTA','590000','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-260224-0030','D','2026-02-24','12:17:04','kasir','PENJUALAN','F226241217031','6410712000','590000','6411302000');
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 ('F226241217521','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZBAA-98-0','GW X TIFF MATA VAR LG 8K ','OL','0.550','1','100.00','690000','0','0','15000','699000','0','5000','0','704000','RTA','00389244','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAA-98-0' 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='2026-02-24' AND kode_barang='B1E-ZBAA-98-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 ('F226241217521','2026-02-24','0.550','2026-02-24','12:17:53','PLG0077613','699000','699000','5000','704000','704000','kasir','2026-02-24 12:17:52','F22624121752');
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-02-24','F226241217521','2026-02-24','12:17:53','RTA','704000','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-260224-0031','D','2026-02-24','12:17:53','kasir','PENJUALAN','F226241217521','6411302000','704000','6412006000');
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 ('F226241225331','kasir','1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-5-T','AT COR MODEL ITALY BM 8K ','OL','0.530','1','100.00','665000','0','0','15000','676000','0','5000','0','681000','TIN','T0075473','A1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-5-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-02-24' AND kode_barang='A1E-YLXD-5-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 ('F226241225331','2026-02-24','0.530','2026-02-24','12:25:34','PLG0077614','676000','676000','5000','681000','681000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225331','2026-02-24','12:25:34','TIN','681000','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-260224-0032','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225331','6412006000','681000','6412687000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='681000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225331' 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 ('F226241225332','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-ZBAI-63-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.550','1','100.00','690000','0','0','15000','701000','0','5000','0','706000','TIN','T0077595','A1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-63-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='2026-02-24' AND kode_barang='A1E-ZBAI-63-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 ('F226241225332','2026-02-24','0.550','2026-02-24','12:25:34','PLG0077615','701000','701000','5000','706000','706000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225332','2026-02-24','12:25:34','TIN','706000','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-260224-0033','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225332','6412687000','706000','6413393000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='706000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225332' 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 ('F226241225333','kasir',' 1',' MGB1G LG ','TOKO','SMBK-B','B1G-YLAF-85-T','GW TUSUK MATA LG 8K ','OL','0.300','1','100.00','388000','0','0','15000','395000','0','5000','0','400000','TIN','T0075905','B1G','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YLAF-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='B1G-YLAF-85-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 ('F226241225333','2026-02-24','0.300','2026-02-24','12:25:34','PLG0077616','395000','395000','5000','400000','400000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225333','2026-02-24','12:25:34','TIN','400000','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-260224-0034','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225333','6413393000','400000','6413793000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225333' 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 ('F226241225334','kasir',' 1',' MGB1 LG ','TOKO','SMBK-B','B1G-YJXF-9-T','GW TUSUK DAISY MATA LG 8K ','OL','0.310','1','100.00','401000','0','0','15000','408000','0','5000','0','413000','TIN','T0073907','B1G','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YJXF-9-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-02-24' AND kode_barang='B1G-YJXF-9-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 ('F226241225334','2026-02-24','0.310','2026-02-24','12:25:34','PLG0077617','408000','408000','5000','413000','413000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225334','2026-02-24','12:25:34','TIN','413000','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-260224-0035','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225334','6413793000','413000','6414206000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='413000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225334' 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 ('F226241225335','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YKAG-16-T','LT SLOBOK BULAT HURUF BG A 8K ','OL','0.660','1','100.00','855000','0','0','15000','868000','0','5000','0','873000','TIN','T0075019','D1G','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YKAG-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='D1G-YKAG-16-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 ('F226241225335','2026-02-24','0.660','2026-02-24','12:25:34','PLG0077618','868000','868000','5000','873000','873000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225335','2026-02-24','12:25:34','TIN','873000','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-260224-0036','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225335','6414206000','873000','6415079000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='873000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225335' 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 ('F226241225336','kasir',' 1',' MDE1 X LG ','TOKO','SMBK-E','E1D-YHXB-273-0','CC X SOLITARE MATA LG 14 8K ','OL','1.050','1','100.00','1297000','0','0','15000','1313000','0','5000','0','1318000','TIN','00363683','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHXB-273-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E1D-YHXB-273-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 ('F226241225336','2026-02-24','1.050','2026-02-24','12:25:34','PLG0077619','1313000','1313000','5000','1318000','1318000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225336','2026-02-24','12:25:34','TIN','1318000','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-260224-0037','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225336','6415079000','1318000','6416397000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1318000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225336' 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 ('F226241225337','kasir',' 1',' MDE1 10K L','TOKO','SMBK-E','E1F-ZBAF-13-T','CC MODEL PASIR VAR LG 16 8K','OL','1.260','1','100.00','1606000','0','0','15000','1571000','0','10000','0','1581000','TIN','T0077392','E1F','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZBAF-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E1F-ZBAF-13-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 ('F226241225337','2026-02-24','1.260','2026-02-24','12:25:34','PLG0077620','1571000','1571000','10000','1581000','1581000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225337','2026-02-24','12:25:34','TIN','1581000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260224-0038','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225337','6416397000','1581000','6417978000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225337' 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 ('F226241225338','kasir',' 1',' MFE1 10K A','TOKO','SMBK-E','E1F-ZBAF-30-T','CC MODEL DURIAN PASIR VAR BG ADJT 8K ','OL','2.030','1','100.00','2588000','0','0','15000','2620000','0','10000','0','2630000','TIN','T0077409','E1F','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZBAF-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E1F-ZBAF-30-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 ('F226241225338','2026-02-24','2.030','2026-02-24','12:25:34','PLG0077621','2620000','2620000','10000','2630000','2630000','kasir','2026-02-24 12:25:33','F22624122533');
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-02-24','F226241225338','2026-02-24','12:25:34','TIN','2630000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260224-0039','D','2026-02-24','12:25:34','kasir','PENJUALAN','F226241225338','6417978000','2630000','6420608000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2630000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241225338' 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 ('F226241226551','kasir','1',' MJH2 KH 42','TOKO','SMBK-H','H2J-YIBI-93-T','KL BORSALINO KH 42CM 9K ','OL','1.080','1','100.00','1463000','0','0','15000','1480000','0','5000','0','1485000','TIN','T0073406','H2J','0','0','-','0','1355000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YIBI-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H2J-YIBI-93-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 ('F226241226551','2026-02-24','1.080','2026-02-24','12:26:56','PLG0077622','1480000','1480000','5000','1485000','1485000','kasir','2026-02-24 12:26:55','F22624122655');
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-02-24','F226241226551','2026-02-24','12:26:56','TIN','1485000','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-260224-0040','D','2026-02-24','12:26:56','kasir','PENJUALAN','F226241226551','6420608000','1485000','6422093000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1485000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241226551' 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 ('F226241226552','kasir',' 1',' MJH2 KH 42','TOKO','SMBK-H','H2J-YLBC-35-T','KL BORSALINO KH 42CM 9K ','OL','1.110','1','100.00','1504000','0','0','15000','1520000','0','6000','0','1526000','TIN','T0076097','H2J','0','0','-','0','1355000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YLBC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H2J-YLBC-35-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 ('F226241226552','2026-02-24','1.110','2026-02-24','12:26:56','PLG0077623','1520000','1520000','6000','1526000','1526000','kasir','2026-02-24 12:26:55','F22624122655');
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-02-24','F226241226552','2026-02-24','12:26:56','TIN','1526000','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-260224-0041','D','2026-02-24','12:26:56','kasir','PENJUALAN','F226241226552','6422093000','1526000','6423619000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241226552' 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 ('F226241226553','kasir',' 1',' MIH2I KH 4','TOKO','SMBK-H','H2I-YLBX-24-T','KL JEDAR KH 42 8K ','OL','1.200','1','100.00','1602000','0','0','15000','1620000','0','6000','0','1626000','TIN','T0076009','H2I','0','0','-','0','1335000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YLBX-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='H2I-YLBX-24-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 ('F226241226553','2026-02-24','1.200','2026-02-24','12:26:56','PLG0077624','1620000','1620000','6000','1626000','1626000','kasir','2026-02-24 12:26:55','F22624122655');
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-02-24','F226241226553','2026-02-24','12:26:56','TIN','1626000','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-260224-0042','D','2026-02-24','12:26:56','kasir','PENJUALAN','F226241226553','6423619000','1626000','6425245000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1626000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241226553' 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 ('F226241226554','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZABA-112-T','KL SANTA KH 42CM 8K ','OL','1.530','1','100.00','1920000','0','0','15000','1943000','0','8000','0','1951000','TIN','T0076885','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZABA-112-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='2026-02-24' AND kode_barang='H1E-ZABA-112-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 ('F226241226554','2026-02-24','1.530','2026-02-24','12:26:56','PLG0077625','1943000','1943000','8000','1951000','1951000','kasir','2026-02-24 12:26:55','F22624122655');
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-02-24','F226241226554','2026-02-24','12:26:56','TIN','1951000','8000');
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-260224-0043','D','2026-02-24','12:26:56','kasir','PENJUALAN','F226241226554','6425245000','1951000','6427196000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1951000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226241226554' 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 ('F226240139281','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-ZABC-83-0','CC X MODEL MATA UB 12 8K ','','0.950','1','100.00','1173000','0','0','15000','1178000','0','0','0','1178000','NS','00386713','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZABC-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-02-24' AND kode_barang='E2D-ZABC-83-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 ('F226240139281','2026-02-24','0.950','2026-02-24','13:39:29','PLG0077626','1178000','1178000','0','1178000','1178000','kasir','2026-02-24 13:39:28','F22624013928');
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-02-24','F226240139281','2026-02-24','13:39:29','NS','1178000','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-260224-0044','D','2026-02-24','13:39:29','kasir','PENJUALAN','F226240139281','6427196000','1178000','6428374000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240139281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240139281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240139281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240818501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240818501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240818501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240904381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240904381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240904381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240904382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240904382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240904382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240942431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240942432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240942433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240942433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241017341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241017341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241017341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241027031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241027031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241027031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241027032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241027032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241027032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241028391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241028391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241028391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241028392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241028392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241028392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241121301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241121301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241121301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241131541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241131541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241131541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241152011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241152011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241152011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201514' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201514' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201514';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201515' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201515' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201515';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201516' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201516' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201516';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201517' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241201517' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241201517';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241210151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241210151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241210151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241211011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241211011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241211011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241214351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241214352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241214353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241214353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241217031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241217031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241217031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241217521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241217521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241217521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225333' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225333' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225333';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225334' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225334' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225334';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225335' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225335' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225335';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225336' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225336' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225336';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225337' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225337' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225337';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225338' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241225338' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241225338';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241226551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241226552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226553' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226553' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241226553';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226554' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226241226554' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226241226554';
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 ('F226240314281','kasir','1',' MDE1 CM 20','TOKO','SMBK-E','E1D-ZAXI-3-T','CC VELG KACA CM 20 8K ','','1.010','1','100.00','1247000','0','0','15000','1252000','0','0','0','1252000','NS','T0076478','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-02-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXI-3-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-02-24' AND kode_barang='E1D-ZAXI-3-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 ('F226240314281','2026-02-24','1.010','2026-02-24','15:14:29','PLG0077627','1252000','1252000','0','1252000','1252000','kasir','2026-02-24 15:14:28','F22624031428');
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-02-24','F226240314281','2026-02-24','15:14:29','NS','1252000','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-260224-0045','D','2026-02-24','15:14:29','kasir','PENJUALAN','F226240314281','6428374000','1252000','6429626000');
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-00005125','X-00005125','WG CC 17K','GR','---','PETG','BELI','BELI001','1674000','2026-02-24','0.900','1','kasir','2026-02-24 15:33:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-PETG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PETG','X-00005125','X-00005125');
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-260224-0001','F223260259142','RTA','1','BELI','BELI001','PETG', 'X-00005125', 'WG CC 17K','1.150','0.900','100.00','949000','1674000','1860000','2325000','1','1674000','1674000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PETG' 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-260224-0001','2026-02-24','2026-02-24','15:33:05','RTA','---','0.900','1674000','1674000','1674000','1674000','1674000','kasir','2026-02-24 15:33:05','FB-260224-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260224-0001','ANDRIANI','SEDARAT BALONG','','','','kasir','2026-02-24 15:33:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-24' 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-260224-0046','K','2026-02-24','15:33:05','kasir','PEMBELIAN UMUM','FB-260224-0001','6429626000','1674000','6427952000');
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-00005126','X-00005126','WG CC 17K','GR','---','PETG','BELI','BELI001','2790000','2026-02-24','1.500','1','kasir','2026-02-24 15:33:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-PETG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PETG','X-00005126','X-00005126');
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-260224-0002','F223260259141','RTA','2','BELI','BELI001','PETG', 'X-00005126', 'WG CC 17K','1.530','1.500','100.00','1262000','2790000','1860000','2325000','1','2790000','2790000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PETG' 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-260224-0002','2026-02-24','2026-02-24','15:33:05','RTA','---','1.500','2790000','2790000','2790000','2790000','2790000','kasir','2026-02-24 15:33:05','FB-260224-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260224-0002','ANDRIANI','SEDARAT BALONG','','','','kasir','2026-02-24 15:33:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-24' 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-260224-0047','K','2026-02-24','15:33:05','kasir','PEMBELIAN UMUM','FB-260224-0002','6427952000','2790000','6425162000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260224-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260224-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260224-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260224-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226240314281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226240314281';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-24';
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-02-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-24' 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-260225-0001','D','2026-02-25','16:03:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','6425162000','6425162000');
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-260225-0001','D','2026-02-25','16:03:56','BCA','SALDO AWAL','SALDO AWAL','0','4288030888','4288030888');
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-260225-0001','D','2026-02-25','16:03:56','','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-260225-0001','D','2026-02-25','16:03:56','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-260225-0001','D','2026-02-25','16:03:56','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-260225-0001','D','2026-02-25','16:03:56','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-02-25';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','F1E-ZBAG-56-0','1','3.030','3.030','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAG-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAG-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-02-25 16:33:03' WHERE kode_barang='F1E-ZBAG-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAG-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 16:33:03','TOKO','SMBK-F','F1E','F1E-ZBAG-56-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZBAG-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAG-56-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','16:32','3.030','input','2026-02-24 16:33:03');