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 ('F226030807461','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-YKAA-266-0','CC X WEDDING POLOS CM 14 8K ','OL','1.030','1','100.00','1076000','0','0','15000','1092000','0','5000','0','1097000','TIN','00377232','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAA-266-0' 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-01-03' AND kode_barang='E1D-YKAA-266-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 ('F226030807461','2026-01-03','1.030','2026-01-03','08:07:47','PLG0076131','1092000','1092000','5000','1097000','1097000','kasir','2026-01-03 08:07:46','F22603080746');
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-01-03','F226030807461','2026-01-03','08:07:47','TIN','1097000','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-260103-0002','D','2026-01-03','08:07:47','kasir','PENJUALAN','F226030807461','4484255000','1097000','4485352000');
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 ('F226030811221','kasir','1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-13-T','AT COR MODEL ITALY BM 8K ','OL','0.600','1','100.00','648000','0','0','15000','655000','0','5000','0','660000','NS','T0075481','A1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-13-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-01-03' AND kode_barang='A1E-YLXD-13-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 ('F226030811221','2026-01-03','0.600','2026-01-03','08:11:22','PLG0076132','655000','655000','5000','660000','660000','kasir','2026-01-03 08:11:22','F22603081122');
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-01-03','F226030811221','2026-01-03','08:11:22','NS','660000','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-260103-0003','D','2026-01-03','08:11:22','kasir','PENJUALAN','F226030811221','4485352000','660000','4486012000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='660000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030811221' 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 ('F226030811222','kasir',' 1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-10-T','AT COR MODEL ITALY BM 8K ','OL','0.600','1','100.00','648000','0','0','15000','655000','0','5000','0','660000','NS','T0075478','A1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-10-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-01-03' AND kode_barang='A1E-YLXD-10-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 ('F226030811222','2026-01-03','0.600','2026-01-03','08:11:22','PLG0076133','655000','655000','5000','660000','660000','kasir','2026-01-03 08:11:22','F22603081122');
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-01-03','F226030811222','2026-01-03','08:11:22','NS','660000','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-260103-0004','D','2026-01-03','08:11:22','kasir','PENJUALAN','F226030811222','4486012000','660000','4486672000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='660000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030811222' 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 ('F226030842211','kasir','1',' MDA1D LT ','TOKO','SMBK-A','A1D-YLAF-76-T','AT HUGGIES MATA VAR LT 8K ','','1.050','1','100.00','1113000','0','0','15000','1108000','0','0','0','1108000','NS','T0075896','A1D','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAF-76-T' 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-01-03' AND kode_barang='A1D-YLAF-76-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 ('F226030842211','2026-01-03','1.050','2026-01-03','08:42:21','PLG0076134','1108000','1108000','0','1108000','1108000','kasir','2026-01-03 08:42:21','F22603084221');
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-01-03','F226030842211','2026-01-03','08:42:21','NS','1108000','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-260103-0005','D','2026-01-03','08:42:21','kasir','PENJUALAN','F226030842211','4486672000','1108000','4487780000');
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 ('F226030855431','kasir','1',' TDE1 CM 12','TOKO','TBK-E','E1TD-YLAC-44-T','CC MODEL DAUN SLEP 12 CM 17K ','OL','1.260','1','100.00','2457000','0','0','15000','2454000','0','9000','0','2463000','RTA','T0075779','E1TD','0','0','-','1','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAC-44-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-01-03' AND kode_barang='E1TD-YLAC-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030855431','2026-01-03','1.260','2026-01-03','08:55:44','PLG0076135','2454000','2454000','9000','2463000','2463000','kasir','2026-01-03 08:55:43','F22603085543');
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-01-03','F226030855431','2026-01-03','08:55:44','RTA','2463000','9000');
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-260103-0006','D','2026-01-03','08:55:44','kasir','PENJUALAN','F226030855431','4487780000','2463000','4490243000');
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 ('F226030858071','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-YLXD-25-T','GL LEMES MODEL RANTE HOLLOW KH 8K ','OL','1.100','1','100.00','1188000','0','0','15000','1193000','0','6000','0','1199000','RTA','T0075493','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXD-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F3E-YLXD-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030858071','2026-01-03','1.100','2026-01-03','08:58:07','PLG0076136','1193000','1193000','6000','1199000','1199000','kasir','2026-01-03 08:58:07','F22603085807');
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-01-03','F226030858071','2026-01-03','08:58:07','RTA','1199000','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-260103-0007','D','2026-01-03','08:58:07','kasir','PENJUALAN','F226030858071','4490243000','1199000','4491442000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1199000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030858071' 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 ('F226030858072','kasir',' 1',' MEF1 YT 60','TOKO','SMBK-F','F1E-YLAX-54-T','GL COR OVAL MODEL C DM 60 YT 8K ','OL','3.510','1','100.00','3791000','0','0','15000','3808000','0','18000','0','3826000','RTA','T0075638','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAX-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F1E-YLAX-54-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 ('F226030858072','2026-01-03','3.510','2026-01-03','08:58:07','PLG0076137','3808000','3808000','18000','3826000','3826000','kasir','2026-01-03 08:58:07','F22603085807');
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-01-03','F226030858072','2026-01-03','08:58:07','RTA','3826000','18000');
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-260103-0008','D','2026-01-03','08:58:07','kasir','PENJUALAN','F226030858072','4491442000','3826000','4495268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3826000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030858072' 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 ('F226030858073','kasir',' 1',' MEH1 UB ','TOKO','SMBK-H','H1E-YLBC-3-T','KL TRIXIE MODEL BOTEGA VAR UB 8K ','','1.070','1','100.00','1156000','0','0','15000','1161000','0','5000','0','1166000','RTA','T0076065','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBC-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='H1E-YLBC-3-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 ('F226030858073','2026-01-03','1.070','2026-01-03','08:58:07','PLG0076138','1161000','1161000','5000','1166000','1166000','kasir','2026-01-03 08:58:07','F22603085807');
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-01-03','F226030858073','2026-01-03','08:58:07','RTA','1166000','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-260103-0009','D','2026-01-03','08:58:07','kasir','PENJUALAN','F226030858073','4495268000','1166000','4496434000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1166000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030858073' 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 ('F226030953271','kasir','1',' MED2E X AY','TOKO','SMBK-D','D2E-XLBG-37-0','LT X MODEL MATA AY 8K ','OLS2USGQ','0.780','1','100.00','842000','0','0','15000','850000','0','110000','0','960000','TIN','00331561','D2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-XLBG-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='D2E-XLBG-37-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 ('F226030953271','2026-01-03','0.780','2026-01-03','09:53:28','PLG0076139','850000','850000','110000','960000','960000','kasir','2026-01-03 09:53:27','F22603095327');
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-01-03','F226030953271','2026-01-03','09:53:28','TIN','960000','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-260103-0010','D','2026-01-03','09:53:28','kasir','PENJUALAN','F226030953271','4496434000','960000','4497394000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030953271' 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 ('F226030953272','kasir',' 1',' MFF1 XX UB','TOKO','SMBK-F','F1F-YKAA-98-0','GL XX OVAL TINJU PASIR UB 54 8K ','OLS2USGQ','3.570','1','100.00','3873000','0','0','15000','3802000','0','150000','0','3952000','TIN','00377064','F1F','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1F-YKAA-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.570',berat_jual_asli=berat_jual_asli+'3.570',stock_jual='1',berat_akhir=berat_akhir-'3.570',berat_akhir_asli=berat_akhir_asli-'3.570',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F1F-YKAA-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030953272','2026-01-03','3.570','2026-01-03','09:53:28','PLG0076140','3802000','3802000','150000','3952000','3952000','kasir','2026-01-03 09:53:27','F22603095327');
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-01-03','F226030953272','2026-01-03','09:53:28','TIN','3952000','150000');
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-260103-0011','D','2026-01-03','09:53:28','kasir','PENJUALAN','F226030953272','4497394000','3952000','4501346000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3952000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030953272' 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 ('F226031000241','kasir','1',' MDE1 X PM ','TOKO','SMBK-E','E1D-YLCX-140-0','CC X MODEL DAUN SLEP PM 12 8K ','OL','0.930','1','100.00','986000','0','0','15000','995000','0','5000','0','1000000','TIN','00383545','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLCX-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='E1D-YLCX-140-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 ('F226031000241','2026-01-03','0.930','2026-01-03','10:00:25','PLG0076141','995000','995000','5000','1000000','1000000','kasir','2026-01-03 10:00:24','F22603100024');
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-01-03','F226031000241','2026-01-03','10:00:25','TIN','1000000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260103-0012','D','2026-01-03','10:00:25','kasir','PENJUALAN','F226031000241','4501346000','1000000','4502346000');
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 ('F226031019231','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YLXF-274-0','GL X CASTELI SLEP HW 8K ','','1.250','1','100.00','1350000','0','0','15000','1344000','0','0','0','1344000','RHM','00380090','F3E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXF-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F3E-YLXF-274-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031019231','2026-01-03','1.250','2026-01-03','10:19:24','PLG0076142','1344000','1344000','0','1344000','1344000','kasir','2026-01-03 10:19:23','F22603101923');
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-01-03','F226031019231','2026-01-03','10:19:24','RHM','1344000','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-260103-0013','D','2026-01-03','10:19:24','kasir','PENJUALAN','F226031019231','4502346000','1344000','4503690000');
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 ('F226031032311','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YKXC-234-0','GL OVAL MODEL C TD D54 8K ','','3.170','1','100.00','3424000','0','0','15000','3408000','0','0','0','3408000','RTA','00376156','F1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXC-234-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F1E-YKXC-234-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031032311','2026-01-03','3.170','2026-01-03','10:32:31','PLG0076143','3408000','3408000','0','3408000','0','kasir','2026-01-03 10:32:31','F22603103231');
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-01-03','F226031032311','2026-01-03','10:32:31','RTA','3408000','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-260103-0001','2026-01-03','2026-01-03 10:32:31','PENJUALAN : F226031032311','89878776665','BCA','3408000','3408000','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-260103-0002','D','2026-01-03','10:32:31','BCA','PENJUALAN','F226031032311','4222754888','3408000','4226162888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89878776665','WELIF');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3408000' WHERE no_faktur_jual='F226031032311' 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 ('F226031058231','kasir','1',' MEF3E LT ','TOKO','SMBK-F','F3E-YLAF-58-T','GL PAPERLINA VAR LT 8K ','','1.030','1','100.00','1112000','0','0','15000','1107000','0','0','0','1107000','RTA','T0075878','F3E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAF-58-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-01-03' AND kode_barang='F3E-YLAF-58-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 ('F226031058231','2026-01-03','1.030','2026-01-03','10:58:23','PLG0076144','1107000','1107000','0','1107000','1107000','kasir','2026-01-03 10:58:23','F22603105823');
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-01-03','F226031058231','2026-01-03','10:58:23','RTA','1107000','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-260103-0014','D','2026-01-03','10:58:23','kasir','PENJUALAN','F226031058231','4503690000','1107000','4504797000');
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 ('F226031117051','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YIXD-68-T','CC X MODEL MATA VAR CM 16 17K ','','2.850','1','100.00','5557000','0','0','15000','5530000','0','15000','0','5545000','RHM','T0072920','E2TD','0','0','-','1','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='E2TD-YIXD-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031117051','2026-01-03','2.850','2026-01-03','11:17:05','PLG0076145','5530000','5530000','15000','5545000','5545000','kasir','2026-01-03 11:17:05','F22603111705');
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-01-03','F226031117051','2026-01-03','11:17:05','RHM','5545000','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-260103-0015','D','2026-01-03','11:17:05','kasir','PENJUALAN','F226031117051','4504797000','5545000','4510342000');
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 ('F226031119471','kasir','1',' MDE1 X YT ','TOKO','SMBK-E','E1D-YGXG-264-0','CC X MODEL CAT MERAH YT 16 8K ','OL','1.260','1','100.00','1336000','0','0','15000','1342000','0','6000','0','1348000','TIN','00360249','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YGXG-264-0' 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-01-03' AND kode_barang='E1D-YGXG-264-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 ('F226031119471','2026-01-03','1.260','2026-01-03','11:19:48','PLG0076146','1342000','1342000','6000','1348000','1348000','kasir','2026-01-03 11:19:47','F22603111947');
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-01-03','F226031119471','2026-01-03','11:19:48','TIN','1348000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260103-0016','D','2026-01-03','11:19:48','kasir','PENJUALAN','F226031119471','4510342000','1348000','4511690000');
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 ('F226030106401','kasir','1',' TDE2 X LG ','TOKO','TBK-E','E2TD-YFBF-87-T','CC X MODEL MATA VAR LG 17 17K ','','1.380','1','100.00','2691000','0','0','15000','2677000','0','5000','0','2682000','RTA','T0070454','E2TD','0','0','-','1','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YFBF-87-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-01-03' AND kode_barang='E2TD-YFBF-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030106401','2026-01-03','1.380','2026-01-03','13:06:40','PLG0076147','2677000','2677000','5000','2682000','2682000','kasir','2026-01-03 13:06:40','F22603010640');
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-01-03','F226030106401','2026-01-03','13:06:40','RTA','2682000','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-260103-0017','D','2026-01-03','13:06:40','kasir','PENJUALAN','F226030106401','4511690000','2682000','4514372000');
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 ('F226030123311','kasir','1',' MEF1 X KH ','TOKO','SMBK-F','F1E-XKAC-131-0','GL X BANGKOK KACA ANAK KH 42 8K ','','1.610','1','100.00','1739000','0','0','15000','1731000','0','0','0','1731000','TIN','00326018','F1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XKAC-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='F1E-XKAC-131-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030123311','2026-01-03','1.610','2026-01-03','13:23:32','PLG0076148','1731000','1731000','0','1731000','1731000','kasir','2026-01-03 13:23:31','F22603012331');
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-01-03','F226030123311','2026-01-03','13:23:32','TIN','1731000','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-260103-0018','D','2026-01-03','13:23:32','kasir','PENJUALAN','F226030123311','4514372000','1731000','4516103000');
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 ('F226030125481','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-YJXD-63-T','GW TUSUK DAISY MATA LG 8K ','','0.320','1','100.00','358000','0','0','15000','357000','0','0','0','357000','RHM','T0073877','B1G','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YJXD-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-01-03' AND kode_barang='B1G-YJXD-63-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 ('F226030125481','2026-01-03','0.320','2026-01-03','13:25:49','PLG0076149','357000','357000','0','357000','0','kasir','2026-01-03 13:25:48','F22603012548');
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-01-03','F226030125481','2026-01-03','13:25:49','RHM','357000','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-260103-0002','2026-01-03','2026-01-03 13:25:48','PENJUALAN : F226030125481','65363636363674','BCA','357000','357000','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-260103-0003','D','2026-01-03','13:25:49','BCA','PENJUALAN','F226030125481','4226162888','357000','4226519888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('65363636363674','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='357000' WHERE no_faktur_jual='F226030125481' LIMIT 1;
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-00004983','X-00004983','GL TRIXIE SERUT SPECTRA VAR YT 8K','GR','---','F3F','BELI','BELI001','2400000','2026-01-03','3.100','1','kasir','2026-01-03 14:26:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004983','X-00004983');
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-260103-0001','F224040946511','TIN','1','BELI','BELI001','F3F', 'X-00004983', 'GL TRIXIE SERUT SPECTRA VAR YT 8K','3.160','3.100','100.00','1907000','2400000','774194','1115000','1','2400000','2400000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.100',berat_beli_asli=berat_beli_asli+'3.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.100',berat_akhir_asli=berat_akhir_asli+'3.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260103-0001','2026-01-03','2026-01-03','14:26:40','TIN','---','3.100','2400000','2400000','2400000','2400000','2400000','kasir','2026-01-03 14:26:41','FB-260103-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260103-0001','RIFAUL KHOMARIAH','','','','','kasir','2026-01-03 14:26:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-03' 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-260103-0019','K','2026-01-03','14:26:40','kasir','PEMBELIAN UMUM','FB-260103-0001','4516103000','2400000','4513703000');
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-00004984','X-00004984','GL KOREA UB 9K','GR','---','F4I','BELI','BELI001','834000','2026-01-03','0.970','1','kasir','2026-01-03 14:27:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F4I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F4I','X-00004984','X-00004984');
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-260103-0002','F225290127091','RTA','1','BELI','BELI001','F4I', 'X-00004984', 'GL KOREA UB 9K','1.070','0.970','100.00','958000','834000','859794','1160000','1','834000','834000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F4I' 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-260103-0002','2026-01-03','2026-01-03','14:27:26','RTA','---','0.970','834000','834000','834000','834000','834000','kasir','2026-01-03 14:27:27','FB-260103-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260103-0002','KHOIRUDIN','GABEL 2/1 SUMOROTO','','','','kasir','2026-01-03 14:27:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-03' 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-260103-0020','K','2026-01-03','14:27:26','kasir','PEMBELIAN UMUM','FB-260103-0002','4513703000','834000','4512869000');
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-00004985','X-00004985','AT KLIP SLEP UB 8K','GR','---','A1E','BELI','BELI001','648000','2026-01-03','0.720','1','kasir','2026-01-03 14:28:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004985','X-00004985');
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-260103-0003','F225041056141','NS','1','BELI','BELI001','A1E', 'X-00004985', 'AT KLIP SLEP UB 8K','0.720','0.720','100.00','720000','648000','900000','1075000','1','648000','648000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.720',berat_beli_asli=berat_beli_asli+'0.720',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.720',berat_akhir_asli=berat_akhir_asli+'0.720',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260103-0003','2026-01-03','2026-01-03','14:28:01','NS','---','0.720','648000','648000','648000','648000','648000','kasir','2026-01-03 14:28:01','FB-260103-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260103-0003','BILQIS','SUKOREJO','','','081235846080','kasir','2026-01-03 14:28:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-03' 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-260103-0021','K','2026-01-03','14:28:01','kasir','PEMBELIAN UMUM','FB-260103-0003','4512869000','648000','4512221000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030106401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030106401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030106401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030123311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030123311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030123311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030125481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030125481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030125481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030807461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030807461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030807461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030811221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030811221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030811221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030811222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030811222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030811222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030842211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030842211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030842211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030855431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030855431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030855431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030858071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030858072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858073' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030858073' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030858073';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030953271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030953271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030953271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030953272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030953272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030953272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031000241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031000241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031000241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031019231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031019231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031019231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031032311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031032311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031032311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031058231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031058231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031058231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031117051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031117051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031117051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031119471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031119471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031119471';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260103-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260103-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260103-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260103-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260103-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260103-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226030323591','kasir','1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YKXC-36-T','LT SLOBOK BOLA KRAWANG BG 8K ','OLSJTFKV','0.300','1','100.00','342000','0','0','15000','345000','0','60000','0','405000','TIN','T0074949','D1H','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-01-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YKXC-36-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-01-03' AND kode_barang='D1H-YKXC-36-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 ('F226030323591','2026-01-03','0.300','2026-01-03','15:23:59','PLG0076150','345000','345000','60000','405000','405000','kasir','2026-01-03 15:23:59','F22603032359');
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-01-03','F226030323591','2026-01-03','15:23:59','TIN','405000','60000');
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-260103-0022','D','2026-01-03','15:23:59','kasir','PENJUALAN','F226030323591','4512221000','405000','4512626000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030323591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030323591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030323591';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-03';
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-01-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-03' 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-260104-0001','D','2026-01-04','16:03:16','SYSTEM','SALDO AWAL','SALDO AWAL','0','4512626000','4512626000');
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-260104-0001','D','2026-01-04','16:03:16','BCA','SALDO AWAL','SALDO AWAL','0','4226519888','4226519888');
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-260104-0001','D','2026-01-04','16:03:16','','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-260104-0001','D','2026-01-04','16:03:16','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-260104-0001','D','2026-01-04','16:03:16','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-260104-0001','D','2026-01-04','16:03:16','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-01-04';