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-20260325-0001','1','A1E-ZCBD-114-0','1','0.470','0.470','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZCBD-114-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZCBD-114-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-03-25 07:58:31' WHERE kode_barang='A1E-ZCBD-114-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZCBD-114-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-03-25 07:58:31','TOKO','SMBK-A','A1E','A1E-ZCBD-114-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-ZCBD-114-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZCBD-114-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260325-0001','2026-03-25','07:58','0.470','input','2026-03-25 07:58:31');
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-20260325-0001','1','D1F-ZCBD-100-0','1','0.450','0.450','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZCBD-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZCBD-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-25 07:58:46' WHERE kode_barang='D1F-ZCBD-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZCBD-100-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-03-25 07:58:46','TOKO','SMBK-D','D1F','D1F-ZCBD-100-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZCBD-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZCBD-100-0';
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-20260325-0001','1','D1F-ZCBD-101-0','1','0.610','0.610','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZCBD-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZCBD-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-25 07:58:46' WHERE kode_barang='D1F-ZCBD-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZCBD-101-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-03-25 07:58:46','TOKO','SMBK-D','D1F','D1F-ZCBD-101-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZCBD-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZCBD-101-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260325-0001','2026-03-25','07:58','1.060','input','2026-03-25 07:58:46');
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 ('F226250928431','kasir','1',' TAA0 X DG ','TOKO','TBK-A','A0TA-YLBF-14-T','AT X JERSY POLOS DG 17K ','','1.500','1','100.00','3000000','0','0','15000','3000000','0','0','0','3000000','NS','T0076184','A0TA','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='A0TA-YLBF-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250928431','2026-03-25','1.500','2026-03-25','09:28:43','PLG0078425','3000000','3000000','0','3000000','3000000','kasir','2026-03-25 09:28:43','F22625092843');
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-03-25','F226250928431','2026-03-25','09:28:43','NS','3000000','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-260325-0002','D','2026-03-25','09:28:43','kasir','PENJUALAN','F226250928431','7524619000','3000000','7527619000');
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 ('F226250946041','kasir','1',' MEE2 HW 15','TOKO','SMBK-E','E2E-YHXG-95-T','CC MODEL MATA VAR HW 15 8K ','','0.570','1','100.00','661000','0','0','15000','661000','0','0','0','661000','NS','T0072082','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXG-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E2E-YHXG-95-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 ('F226250946041','2026-03-25','0.570','2026-03-25','09:46:04','PLG0078426','661000','661000','0','661000','661000','kasir','2026-03-25 09:46:04','F22625094604');
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-03-25','F226250946041','2026-03-25','09:46:04','NS','661000','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-260325-0003','D','2026-03-25','09:46:04','kasir','PENJUALAN','F226250946041','7527619000','661000','7528280000');
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 ('F226250948471','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-ZBAH-67-T','CC PIPA MODEL PITA MATA VAR HTM 15 8K ','','0.540','1','100.00','626000','0','0','15000','626000','0','0','0','626000','RTA','T0077512','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAH-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E2E-ZBAH-67-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 ('F226250948471','2026-03-25','0.540','2026-03-25','09:48:48','PLG0078427','626000','626000','0','626000','626000','kasir','2026-03-25 09:48:47','F22625094847');
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-03-25','F226250948471','2026-03-25','09:48:48','RTA','626000','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-260325-0004','D','2026-03-25','09:48:48','kasir','PENJUALAN','F226250948471','7528280000','626000','7528906000');
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 ('F226251014551','kasir','1',' TDE1 X BM ','TOKO','TBK-E','E1TD-YLAA-48-T','CC COR VELG MATA SLEP 16 BM 17K ','OL','2.980','1','100.00','6198000','0','0','15000','6207000','0','21000','0','6228000','NS','T0075706','E1TD','0','0','-','0','2080000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAA-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E1TD-YLAA-48-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 ('F226251014551','2026-03-25','2.980','2026-03-25','10:14:56','PLG0078428','6207000','6207000','21000','6228000','6228000','kasir','2026-03-25 10:14:55','F22625101455');
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-03-25','F226251014551','2026-03-25','10:14:56','NS','6228000','21000');
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-260325-0005','D','2026-03-25','10:14:56','kasir','PENJUALAN','F226251014551','7528906000','6228000','7535134000');
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 ('F226251015321','kasir','1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YHBE-60-T','KL RANTAI HOLLOW KH 44CM 8K','OL','3.030','1','100.00','3515000','0','0','15000','3530000','0','15000','0','3545000','NS','T0072545','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHBE-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='H1E-YHBE-60-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 ('F226251015321','2026-03-25','3.030','2026-03-25','10:15:32','PLG0078429','3530000','3530000','15000','3545000','3545000','kasir','2026-03-25 10:15:32','F22625101532');
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-03-25','F226251015321','2026-03-25','10:15:32','NS','3545000','15000');
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-260325-0006','D','2026-03-25','10:15:32','kasir','PENJUALAN','F226251015321','7535134000','3545000','7538679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251015321' 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 ('F226251015322','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXE-7-T','LT PLAT FINE GOLD VAR LG 8K ','OL','0.520','1','100.00','603000','0','0','15000','608000','0','5000','0','613000','NS','T0077683','D1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXE-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='D1E-ZCXE-7-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 ('F226251015322','2026-03-25','0.520','2026-03-25','10:15:32','PLG0078430','608000','608000','5000','613000','613000','kasir','2026-03-25 10:15:32','F22625101532');
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-03-25','F226251015322','2026-03-25','10:15:32','NS','613000','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-260325-0007','D','2026-03-25','10:15:32','kasir','PENJUALAN','F226251015322','7538679000','613000','7539292000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251015322' 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 ('F226251049051','kasir','1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZCAH-19-T','AT MODEL ITALY PANJANG VAR HW 8K ','','0.580','1','100.00','673000','0','0','15000','673000','0','0','0','673000','TIN','T0078207','A1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAH-19-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-03-25' AND kode_barang='A1E-ZCAH-19-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 ('F226251049051','2026-03-25','0.580','2026-03-25','10:49:06','PLG0078431','673000','673000','0','673000','673000','kasir','2026-03-25 10:49:05','F22625104905');
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-03-25','F226251049051','2026-03-25','10:49:06','TIN','673000','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-260325-0008','D','2026-03-25','10:49:06','kasir','PENJUALAN','F226251049051','7539292000','673000','7539965000');
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 ('F226251135191','kasir','1',' TEB1 X UB ','TOKO','TBK-B','B1TE-YJBH-36-T','GW X TUSUK MRICAN SLEP UB 17K ','','0.630','1','100.00','1323000','0','0','15000','1332000','0','7000','0','1339000','TIN','T0074518','B1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-YJBH-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='B1TE-YJBH-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251135191','2026-03-25','0.630','2026-03-25','11:35:20','PLG0078432','1332000','1332000','7000','1339000','1339000','kasir','2026-03-25 11:35:19','F22625113519');
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-03-25','F226251135191','2026-03-25','11:35:20','TIN','1339000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260325-0009','D','2026-03-25','11:35:20','kasir','PENJUALAN','F226251135191','7539965000','1339000','7541304000');
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 ('F226251203051','kasir','1',' MEH1 UB 46','TOKO','SMBK-H','H1E-ZAAI-67-T','KL NORY UB 46CM 8K ','','1.000','1','100.00','1160000','0','0','15000','1160000','0','0','0','1160000','TIN','T0076732','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAI-67-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-03-25' AND kode_barang='H1E-ZAAI-67-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 ('F226251203051','2026-03-25','1.000','2026-03-25','12:03:06','PLG0078433','1160000','1160000','0','1160000','1160000','kasir','2026-03-25 12:03:05','F22625120305');
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-03-25','F226251203051','2026-03-25','12:03:06','TIN','1160000','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-260325-0010','D','2026-03-25','12:03:06','kasir','PENJUALAN','F226251203051','7541304000','1160000','7542464000');
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 ('F226251235291','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-YLXH-175-0','CC X MODEL MATA UB 14 8K ','','0.880','1','100.00','1003000','0','0','15000','1003000','0','0','0','1003000','NS','00380297','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E2D-YLXH-175-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 ('F226251235291','2026-03-25','0.880','2026-03-25','12:35:30','PLG0078434','1003000','1003000','0','1003000','1003000','kasir','2026-03-25 12:35:29','F22625123529');
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-03-25','F226251235291','2026-03-25','12:35:30','NS','1003000','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-260325-0011','D','2026-03-25','12:35:30','kasir','PENJUALAN','F226251235291','7542464000','1003000','7543467000');
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 ('F226251237361','kasir','1',' TDE1 X CM ','TOKO','TBK-E','E1TD-YLAA-46-T','CC COR VELG SLEP 16 CM 17K ','','2.010','1','100.00','4181000','0','0','15000','4181000','0','0','0','4181000','RTA','T0075704','E1TD','0','0','-','0','2080000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAA-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E1TD-YLAA-46-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 ('F226251237361','2026-03-25','2.010','2026-03-25','12:37:37','PLG0078435','4181000','4181000','0','4181000','4181000','kasir','2026-03-25 12:37:36','F22625123736');
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-03-25','F226251237361','2026-03-25','12:37:37','RTA','4181000','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-260325-0012','D','2026-03-25','12:37:37','kasir','PENJUALAN','F226251237361','7543467000','4181000','7547648000');
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 ('F226251243021','kasir','1',' MEE1 5K UB','TOKO','SMBK-E','E1E-ZCXG-56-T','CC BANGKOK PASIR UB 13 8K ','OL','0.600','1','100.00','696000','0','0','15000','705000','0','10000','0','715000','RTA','T0077927','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-56-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-03-25' AND kode_barang='E1E-ZCXG-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251243021','2026-03-25','0.600','2026-03-25','12:43:02','PLG0078436','705000','705000','10000','715000','715000','kasir','2026-03-25 12:43:02','F22625124302');
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-03-25','F226251243021','2026-03-25','12:43:02','RTA','715000','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-260325-0013','D','2026-03-25','12:43:02','kasir','PENJUALAN','F226251243021','7547648000','715000','7548363000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='715000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251243021' 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 ('F226251243022','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZCAB-17-T','GL RANTAI HOLLOW DOUBLE KH 8K ','OL','3.050','1','100.00','3538000','0','0','15000','3554000','0','31000','0','3585000','RTA','T0078088','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAB-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='F3E-ZCAB-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 ('F226251243022','2026-03-25','3.050','2026-03-25','12:43:02','PLG0078437','3554000','3554000','31000','3585000','3585000','kasir','2026-03-25 12:43:02','F22625124302');
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-03-25','F226251243022','2026-03-25','12:43:02','RTA','3585000','31000');
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-260325-0014','D','2026-03-25','12:43:02','kasir','PENJUALAN','F226251243022','7548363000','3585000','7551948000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3585000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251243022' 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 ('F226251245021','kasir','1',' MEH1 UB 32','TOKO','SMBK-H','H1E-ZBAX-82-T','KL NORY ANAK UB 32CM 8K ','','1.020','1','100.00','1183000','0','0','15000','1183000','0','0','0','1183000','TIN','T0077197','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='H1E-ZBAX-82-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 ('F226251245021','2026-03-25','1.020','2026-03-25','12:45:03','PLG0078438','1183000','1183000','0','1183000','1183000','kasir','2026-03-25 12:45:02','F22625124502');
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-03-25','F226251245021','2026-03-25','12:45:03','TIN','1183000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260325-0015','D','2026-03-25','12:45:03','kasir','PENJUALAN','F226251245021','7551948000','1183000','7553131000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1183000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251245021' 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 ('F226251245022','kasir',' 1',' MGD1 5K LG','TOKO','SMBK-D','D1G-ZCXG-18-T','LT MODEL BONEKA CAT VAR LG 8K ','','0.350','1','100.00','420000','0','0','15000','420000','0','5000','0','425000','TIN','T0077889','D1G','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXG-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='D1G-ZCXG-18-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 ('F226251245022','2026-03-25','0.350','2026-03-25','12:45:03','PLG0078439','420000','420000','5000','425000','425000','kasir','2026-03-25 12:45:02','F22625124502');
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-03-25','F226251245022','2026-03-25','12:45:03','TIN','425000','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-260325-0016','D','2026-03-25','12:45:03','kasir','PENJUALAN','F226251245022','7553131000','425000','7553556000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251245022' 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 ('F226251249161','kasir','1',' TEB1 X CM ','TOKO','TBK-B','B1TE-ZCBC-5-T','GW X TUSUK MODEL KELINCI VAR CM 17K ','OL','0.510','1','100.00','1071000','0','0','15000','1080000','0','10000','0','1090000','RTA','T0078240','B1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-ZCBC-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='B1TE-ZCBC-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251249161','2026-03-25','0.510','2026-03-25','12:49:17','PLG0078440','1080000','1080000','10000','1090000','1090000','kasir','2026-03-25 12:49:16','F22625124916');
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-03-25','F226251249161','2026-03-25','12:49:17','RTA','1090000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260325-0017','D','2026-03-25','12:49:17','kasir','PENJUALAN','F226251249161','7553556000','1090000','7554646000');
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 ('F226251250091','kasir','1',' TEE2 CM 16','TOKO','TBK-E','E2TE-WGBE-35-T','CC MODEL MATA VAR CM 16 ','OL','1.300','1','100.00','2730000','0','0','15000','2737000','0','13000','0','2750000','RTA','T0046582','E2TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WGBE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E2TE-WGBE-35-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 ('F226251250091','2026-03-25','1.300','2026-03-25','12:50:10','PLG0078441','2737000','2737000','13000','2750000','2750000','kasir','2026-03-25 12:50:09','F22625125009');
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-03-25','F226251250091','2026-03-25','12:50:10','RTA','2750000','13000');
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-260325-0018','D','2026-03-25','12:50:10','kasir','PENJUALAN','F226251250091','7554646000','2750000','7557396000');
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 ('F226251253061','kasir','1',' MDD2D X LG','TOKO','SMBK-D','D2D-XIAH-97-0','LT X MODEL HURUF MATA LG G 8K ','','1.060','1','100.00','1208000','0','0','15000','1208000','0','0','0','1208000','NS','00318063','D2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-XIAH-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='D2D-XIAH-97-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 ('F226251253061','2026-03-25','1.060','2026-03-25','12:53:07','PLG0078442','1208000','1208000','0','1208000','1208000','kasir','2026-03-25 12:53:06','F22625125306');
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-03-25','F226251253061','2026-03-25','12:53:07','NS','1208000','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-260325-0019','D','2026-03-25','12:53:07','kasir','PENJUALAN','F226251253061','7557396000','1208000','7558604000');
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 ('F226250110551','kasir','1',' TEE2 X YT ','TOKO','TBK-E','E2TE-WEAB-26-T','CC X MODEL MATA YT 15 ','','1.510','1','100.00','3171000','0','0','15000','3171000','0','0','0','3171000','TIN','T0044243','E2TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WEAB-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-03-25' AND kode_barang='E2TE-WEAB-26-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 ('F226250110551','2026-03-25','1.510','2026-03-25','13:10:55','PLG0078443','3171000','3171000','0','3171000','3171000','kasir','2026-03-25 13:10:55','F22625011055');
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-03-25','F226250110551','2026-03-25','13:10:55','TIN','3171000','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-260325-0020','D','2026-03-25','13:10:55','kasir','PENJUALAN','F226250110551','7558604000','3171000','7561775000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250110551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250110551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250110551';
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 ('F226250138281','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZCXG-51-T','CC MODEL DAUN SLEP VAR LG 16 8K ','','0.410','1','100.00','476000','0','0','15000','476000','0','0','0','476000','RTA','T0077922','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-51-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-03-25' AND kode_barang='E1E-ZCXG-51-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 ('F226250138281','2026-03-25','0.410','2026-03-25','13:38:28','PLG0078444','476000','476000','0','476000','476000','kasir','2026-03-25 13:38:28','F22625013828');
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-03-25','F226250138281','2026-03-25','13:38:28','RTA','476000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260325-0021','D','2026-03-25','13:38:28','kasir','PENJUALAN','F226250138281','7561775000','476000','7562251000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='476000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250138281' 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 ('F226250138282','kasir',' 1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZCXG-50-T','CC MODEL DAUN SLEP VAR LG 16 8K ','','0.410','1','100.00','476000','0','0','15000','476000','0','0','0','476000','RTA','T0077921','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-50-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-03-25' AND kode_barang='E1E-ZCXG-50-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 ('F226250138282','2026-03-25','0.410','2026-03-25','13:38:28','PLG0078445','476000','476000','0','476000','476000','kasir','2026-03-25 13:38:28','F22625013828');
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-03-25','F226250138282','2026-03-25','13:38:28','RTA','476000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260325-0022','D','2026-03-25','13:38:28','kasir','PENJUALAN','F226250138282','7562251000','476000','7562727000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='476000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250138282' 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 ('F226250138283','kasir',' 1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-YKBH-134-T','CC PIPA MODEL MATA VAR HTM 16 8K ','','0.530','1','100.00','615000','0','0','15000','615000','0','0','0','615000','RTA','T0075366','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKBH-134-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-03-25' AND kode_barang='E1E-YKBH-134-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 ('F226250138283','2026-03-25','0.530','2026-03-25','13:38:28','PLG0078446','615000','615000','0','615000','615000','kasir','2026-03-25 13:38:28','F22625013828');
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-03-25','F226250138283','2026-03-25','13:38:28','RTA','615000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260325-0023','D','2026-03-25','13:38:28','kasir','PENJUALAN','F226250138283','7562727000','615000','7563342000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250138283' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250138281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250138282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250138283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250138283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250928431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250928431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250928431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250946041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250946041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250946041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250948471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250948471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250948471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251014551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251014551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251014551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251015321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251015321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251015321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251015322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251015322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251015322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251049051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251049051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251049051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251135191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251135191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251135191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251203051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251203051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251203051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251235291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251235291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251235291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251237361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251237361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251237361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251243021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251243021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251243021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251243022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251243022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251243022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251245021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251245021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251245021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251245022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251245022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251245022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251249161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251249161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251249161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251250091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251250091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251250091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251253061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251253061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251253061';
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-00005219','X-00005219','CC COR T 17K','GR','---','E1TE','BELI','BELI001','2067000','2026-03-25','1.300','1','kasir','2026-03-25 15:54:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00005219','X-00005219');
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-260325-0001','F223211238152','RTA','1','BELI','BELI001','E1TE', 'X-00005219', 'CC COR T 17K','1.450','1.300','100.00','1240000','2067000','1590000','2100000','1','2067000','2067000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.300',berat_beli_asli=berat_beli_asli+'1.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.300',berat_akhir_asli=berat_akhir_asli+'1.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-260325-0001','2026-03-25','2026-03-25','15:53:59','RTA','---','1.300','2067000','2067000','2067000','2067000','2067000','kasir','2026-03-25 15:54:00','FB-260325-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260325-0001','ARYA','TRISONO BBD','','','','kasir','2026-03-25 15:54:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260325-0024','K','2026-03-25','15:53:59','kasir','PEMBELIAN UMUM','FB-260325-0001','7563342000','2067000','7561275000');
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-00005220','X-00005220','GW TUSUK MRICAN SLEP AV 8K','GR','---','B1G','BELI','BELI001','150000','2026-03-25','0.220','1','kasir','2026-03-25 15:54:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00005220','X-00005220');
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-260325-0002','F224060956141','NS','1','BELI','BELI001','B1G', 'X-00005220', 'GW TUSUK MRICAN SLEP AV 8K','0.260','0.220','100.00','161000','150000','681818','1200000','1','150000','150000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.220',berat_beli_asli=berat_beli_asli+'0.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.220',berat_akhir_asli=berat_akhir_asli+'0.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1G' 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-260325-0002','2026-03-25','2026-03-25','15:54:29','NS','---','0.220','150000','150000','150000','150000','150000','kasir','2026-03-25 15:54:30','FB-260325-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260325-0002','AVI','MLILIR','','','081515957918','kasir','2026-03-25 15:54:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260325-0025','K','2026-03-25','15:54:29','kasir','PEMBELIAN UMUM','FB-260325-0002','7561275000','150000','7561125000');
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-00005221','X-00005221','GL BANGKOK MODEL C TD D56 8K','GR','---','F1E','BELI','BELI001','4200000','2026-03-25','4.000','1','kasir','2026-03-25 15:55:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005221','X-00005221');
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-260325-0003','F226170310532','RTA','1','BELI','BELI001','F1E', 'X-00005221', 'GL BANGKOK MODEL C TD D56 8K','4.000','4.000','100.00','4980000','4200000','1050000','1160000','1','4200000','4200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.000',berat_beli_asli=berat_beli_asli+'4.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.000',berat_akhir_asli=berat_akhir_asli+'4.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260325-0003','2026-03-25','2026-03-25','15:55:04','RTA','---','4.000','4200000','4200000','4200000','4200000','4200000','kasir','2026-03-25 15:55:04','FB-260325-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260325-0003','IBU PADEMI','PERUM CEMARA PAJU JL YOS SUDARSO','','','081392691875','kasir','2026-03-25 15:55:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260325-0026','K','2026-03-25','15:55:04','kasir','PEMBELIAN UMUM','FB-260325-0003','7561125000','4200000','7556925000');
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-00005222','X-00005222','GL MODEL CAPELA VAR HW 8K','GR','---','F3E','BELI','BELI001','1164000','2026-03-25','1.400','1','kasir','2026-03-25 15:56:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005222','X-00005222');
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-260325-0004','F225290404221','TIN','1','BELI','BELI001','F3E', 'X-00005222', 'GL MODEL CAPELA VAR HW 8K','1.400','1.400','100.00','1456000','1164000','831429','1160000','1','1164000','1164000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260325-0004','2026-03-25','2026-03-25','15:56:07','TIN','---','1.400','1164000','1164000','1164000','1164000','1164000','kasir','2026-03-25 15:56:07','FB-260325-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260325-0004','RISMA','SIMAN','','','082132548404','kasir','2026-03-25 15:56:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260325-0027','K','2026-03-25','15:56:07','kasir','PEMBELIAN UMUM','FB-260325-0004','7556925000','1164000','7555761000');
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-00005223','X-00005223','AT MODEL ITALY PANJANG VAR UB 17K','GR','---','A1TF','BELI','BELI001','1828000','2026-03-25','1.150','1','kasir','2026-03-25 15:56:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TF','X-00005223','X-00005223');
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-260325-0005','F224260406231','TIN','2','BELI','BELI001','A1TF', 'X-00005223', 'AT MODEL ITALY PANJANG VAR UB 17K','1.220','1.150','100.00','1300000','1828000','1589565','2120000','1','1828000','1828000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TF' 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-260325-0005','2026-03-25','2026-03-25','15:56:07','TIN','---','1.150','1828000','1828000','1828000','1828000','1828000','kasir','2026-03-25 15:56:07','FB-260325-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260325-0005','RISMA','SIMAN','','','082132548404','kasir','2026-03-25 15:56:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260325-0028','K','2026-03-25','15:56:07','kasir','PEMBELIAN UMUM','FB-260325-0005','7555761000','1828000','7553933000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260325-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260325-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260325-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260325-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260325-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260325-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260325-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260325-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260325-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260325-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260326-0001','D','2026-03-26','16:42:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','7553933000','7553933000');
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-260326-0001','D','2026-03-26','16:42:51','BCA','SALDO AWAL','SALDO AWAL','0','4317221888','4317221888');
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-260326-0001','D','2026-03-26','16:42:51','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260326-0001','D','2026-03-26','16:42:51','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-260326-0001','D','2026-03-26','16:42:51','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-260326-0001','D','2026-03-26','16:42:51','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-03-26';