INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-01';
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-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-01' 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-260102-0001','D','2026-01-02','08:00:31','SYSTEM','SALDO AWAL','SALDO AWAL','0','4407499000','4407499000');
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-260102-0001','D','2026-01-02','08:00:31','BCA','SALDO AWAL','SALDO AWAL','0','4220478888','4220478888');
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-260102-0001','D','2026-01-02','08:00:31','','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-260102-0001','D','2026-01-02','08:00:31','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-260102-0001','D','2026-01-02','08:00:31','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-260102-0001','D','2026-01-02','08:00:31','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-01-02';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260102-0001','1','D1G-YJBI-144-T','1','0.320','TOKO','BK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1G-YJBI-144-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1G-YJBI-144-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MG' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MG' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1G-YJBI-144-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.320',berat_out_asli='0.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.320',berat_akhir_asli =berat_akhir_asli-'0.320' WHERE kode_barang='D1G-YJBI-144-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260102-0001','2','D1F-YLCX-29-T','1','0.380','TOKO','BK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YLCX-29-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1F-YLCX-29-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1F-YLCX-29-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.380',berat_out_asli='0.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.380',berat_akhir_asli =berat_akhir_asli-'0.380' WHERE kode_barang='D1F-YLCX-29-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260102-0001','2026-01-02','2026-01-02','08:08','0.380','input','260102');
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-20260102-0001','1','F2E-YLAE-64-0','1','8.010','8.010','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-02 08:08:40' WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YLAE-64-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-01-02 08:08:40','TOKO','SMBK-F','F2E','F2E-YLAE-64-0','1','8.010','8.010','1','8.010','8.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-YLAE-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YLAE-64-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-20260102-0001','1','F2E-YLBI-127-0','1','5.050','5.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YLBI-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YLBI-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-02 08:08:40' WHERE kode_barang='F2E-YLBI-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YLBI-127-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-01-02 08:08:40','TOKO','SMBK-F','F2E','F2E-YLBI-127-0','1','5.050','5.050','1','5.050','5.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-YLBI-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YLBI-127-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260102-0001','2026-01-02','08:08','13.060','input','2026-01-02 08:08:40');
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 ('F226020831471','kasir','1',' MHB1 LG ','TOKO','SMBK-B','B1H-YJBI-26-T','GW TUSUK MRICAN POLOS LG 8K ','OL ','0.270','1','100.00','308000','0','0','15000','311000','0','5000','0','316000','RHM','T0074586','B1H','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YJBI-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='B1H-YJBI-26-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 ('F226020831471','2026-01-02','0.270','2026-01-02','08:31:47','PLG0076094','311000','311000','5000','316000','0','kasir','2026-01-02 08:31:47','F22602083147');
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-02','F226020831471','2026-01-02','08:31:47','RHM','316000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260102-0001','2026-01-02','2026-01-02 08:31:47','PENJUALAN : F226020831471','656363865366367','BCA','316000','316000','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-260102-0002','D','2026-01-02','08:31:47','BCA','PENJUALAN','F226020831471','4220478888','316000','4220794888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('656363865366367','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='316000' WHERE no_faktur_jual='F226020831471' 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 ('F226020832251','kasir','1',' MFE1 8K BG','TOKO','SMBK-E','E1F-YLCX-15-T','CC MODEL RANTAI PASIR BG 20 8K ','OL ','1.450','1','100.00','1595000','0','0','15000','1602000','0','8000','0','1610000','RHM','T0076256','E1F','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YLCX-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E1F-YLCX-15-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 ('F226020832251','2026-01-02','1.450','2026-01-02','08:32:26','PLG0076095','1602000','1602000','8000','1610000','0','kasir','2026-01-02 08:32:25','F22602083225');
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-02','F226020832251','2026-01-02','08:32:26','RHM','1610000','8000');
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-260102-0002','2026-01-02','2026-01-02 08:32:25','PENJUALAN : F226020832251','538538535854566','BCA','1610000','1610000','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-260102-0003','D','2026-01-02','08:32:26','BCA','PENJUALAN','F226020832251','4220794888','1610000','4222404888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('538538535854566','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1610000' WHERE no_faktur_jual='F226020832251' 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 ('F226021001521','kasir','1',' MDE1 CM 20','TOKO','SMBK-E','E1D-YJBI-73-T','CC POLOS CM 20 8K ','','1.510','1','100.00','1601000','0','0','15000','1593000','0','0','0','1593000','RTA','T0074633','E1D','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBI-73-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-01-02' AND kode_barang='E1D-YJBI-73-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 ('F226021001521','2026-01-02','1.510','2026-01-02','10:01:52','PLG0076096','1593000','1593000','0','1593000','1593000','kasir','2026-01-02 10:01:52','F22602100152');
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-02','F226021001521','2026-01-02','10:01:52','RTA','1593000','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-260102-0002','D','2026-01-02','10:01:52','kasir','PENJUALAN','F226021001521','4407499000','1593000','4409092000');
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 ('F226021018141','kasir','1',' MFB1F X CM','TOKO','SMBK-B','B1F-YFXI-52-0','GW X TAUGE MATA CM 8K ','','0.320','1','100.00','352000','0','0','15000','350000','0','0','0','350000','RTA','00356797','B1F','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YFXI-52-0' 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-02' AND kode_barang='B1F-YFXI-52-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021018141','2026-01-02','0.320','2026-01-02','10:18:15','PLG0076097','350000','350000','0','350000','0','kasir','2026-01-02 10:18:14','F22602101814');
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-02','F226021018141','2026-01-02','10:18:15','RTA','350000','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-260102-0003','2026-01-02','2026-01-02 10:18:14','PENJUALAN : F226021018141','87876767678789','BCA','350000','350000','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-260102-0004','D','2026-01-02','10:18:15','BCA','PENJUALAN','F226021018141','4222404888','350000','4222754888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87876767678789','ROSITA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='350000' WHERE no_faktur_jual='F226021018141' 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 ('F226021021571','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLCX-37-T','LT SLOBOK BALOK HURUF BG M 8K ','','0.700','1','100.00','770000','0','0','15000','768000','0','5000','0','773000','NS','T0076278','D1F','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLCX-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='D1F-YLCX-37-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 ('F226021021571','2026-01-02','0.700','2026-01-02','10:21:58','PLG0076098','768000','768000','5000','773000','773000','kasir','2026-01-02 10:21:57','F22602102157');
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-02','F226021021571','2026-01-02','10:21:58','NS','773000','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-260102-0003','D','2026-01-02','10:21:58','kasir','PENJUALAN','F226021021571','4409092000','773000','4409865000');
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 ('F226021037521','kasir','1',' TEE1 X OR ','TOKO','TBK-E','E1TE-YDAH-38-T','CC BANGKOK SLEP VAR OR 10 17K ','','1.060','1','100.00','2088000','0','0','15000','2078000','0','0','0','2078000','TIN','T0068724','E1TE','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-YDAH-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E1TE-YDAH-38-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 ('F226021037521','2026-01-02','1.060','2026-01-02','10:37:52','PLG0076099','2078000','2078000','0','2078000','2078000','kasir','2026-01-02 10:37:52','F22602103752');
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-02','F226021037521','2026-01-02','10:37:52','TIN','2078000','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-260102-0004','D','2026-01-02','10:37:52','kasir','PENJUALAN','F226021037521','4409865000','2078000','4411943000');
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 ('F226021134101','kasir','1',' MEE1 HW 17','TOKO','SMBK-E','E1E-YKXA-117-T','CC MODEL SLEP VAR HW 17 8K ','OL','0.760','1','100.00','821000','0','0','15000','828000','0','5000','0','833000','TIN','T0074912','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXA-117-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E1E-YKXA-117-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 ('F226021134101','2026-01-02','0.760','2026-01-02','11:34:11','PLG0076100','828000','828000','5000','833000','833000','kasir','2026-01-02 11:34:10','F22602113410');
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-02','F226021134101','2026-01-02','11:34:11','TIN','833000','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-260102-0005','D','2026-01-02','11:34:11','kasir','PENJUALAN','F226021134101','4411943000','833000','4412776000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='833000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021134101' 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 ('F226021134102','kasir',' 1',' MDE2 X UB ','TOKO','SMBK-E','E2D-YLCX-129-0','CC X MODEL MATA UB 16 8K ','OL','0.950','1','100.00','1007000','0','0','15000','1017000','0','5000','0','1022000','TIN','00383534','E2D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLCX-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E2D-YLCX-129-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 ('F226021134102','2026-01-02','0.950','2026-01-02','11:34:11','PLG0076101','1017000','1017000','5000','1022000','1022000','kasir','2026-01-02 11:34:10','F22602113410');
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-02','F226021134102','2026-01-02','11:34:11','TIN','1022000','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-260102-0006','D','2026-01-02','11:34:11','kasir','PENJUALAN','F226021134102','4412776000','1022000','4413798000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1022000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021134102' 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 ('F226021134103','kasir',' 1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YLBC-47-T','GL OVAL MODEL C TD D52 8K ','OL','4.620','1','100.00','4990000','0','0','15000','5013000','0','23000','0','5036000','TIN','T0076109','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBC-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F1E-YLBC-47-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 ('F226021134103','2026-01-02','4.620','2026-01-02','11:34:11','PLG0076102','5013000','5013000','23000','5036000','5036000','kasir','2026-01-02 11:34:10','F22602113410');
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-02','F226021134103','2026-01-02','11:34:11','TIN','5036000','23000');
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-260102-0007','D','2026-01-02','11:34:11','kasir','PENJUALAN','F226021134103','4413798000','5036000','4418834000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5036000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021134103' 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 ('F226021140211','kasir','1',' TEF3 LT ','TOKO','TBK-F','F3TE-YLAC-62-T','GL RANTE HOLLOW P4 LT 17K ','','4.030','1','100.00','7939000','0','0','15000','7900000','0','0','0','7900000','NS','T0075797','F3TE','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAC-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3TE-YLAC-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021140211','2026-01-02','4.030','2026-01-02','11:40:22','PLG0076103','7900000','7900000','0','7900000','7900000','kasir','2026-01-02 11:40:21','F22602114021');
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-02','F226021140211','2026-01-02','11:40:22','NS','7900000','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-260102-0008','D','2026-01-02','11:40:22','kasir','PENJUALAN','F226021140211','4418834000','7900000','4426734000');
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 ('F226021217451','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YLCX-139-0','CC X SOLITAIRE MATA CM 12 8K ','OL','1.230','1','100.00','1304000','0','0','15000','1306000','0','10000','0','1316000','RTA','00383544','E2D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLCX-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E2D-YLCX-139-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 ('F226021217451','2026-01-02','1.230','2026-01-02','12:17:45','PLG0076104','1306000','1306000','10000','1316000','1316000','kasir','2026-01-02 12:17:45','F22602121745');
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-02','F226021217451','2026-01-02','12:17:45','RTA','1316000','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-260102-0009','D','2026-01-02','12:17:45','kasir','PENJUALAN','F226021217451','4426734000','1316000','4428050000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1316000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021217451' 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 ('F226021217452','kasir',' 1',' MEF1 X YT ','TOKO','SMBK-F','F1E-YLBE-80-0','GL X OVAL C SLEP YT 52 8K ','OL','2.270','1','100.00','2452000','0','0','15000','2463000','0','11000','0','2474000','RTA','00383100','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBE-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F1E-YLBE-80-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 ('F226021217452','2026-01-02','2.270','2026-01-02','12:17:45','PLG0076105','2463000','2463000','11000','2474000','2474000','kasir','2026-01-02 12:17:45','F22602121745');
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-02','F226021217452','2026-01-02','12:17:45','RTA','2474000','11000');
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-260102-0010','D','2026-01-02','12:17:45','kasir','PENJUALAN','F226021217452','4428050000','2474000','4430524000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2474000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021217452' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021217451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021217451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021217451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021217452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021217452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021217452';
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 ('F226020201161','kasir','1',' MDE2 X PM ','TOKO','SMBK-E','E2D-YLAG-213-0','CC X MODEL MATA PM 14 8K ','OL H','0.970','1','100.00','1028000','0','0','15000','1033000','0','10000','0','1043000','NS','00381567','E2D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAG-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E2D-YLAG-213-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 ('F226020201161','2026-01-02','0.970','2026-01-02','14:01:16','PLG0076106','1033000','1033000','10000','1043000','1043000','kasir','2026-01-02 14:01:16','F22602020116');
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-02','F226020201161','2026-01-02','14:01:16','NS','1043000','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-260102-0011','D','2026-01-02','14:01:16','kasir','PENJUALAN','F226020201161','4430524000','1043000','4431567000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1043000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020201161' 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 ('F226020201162','kasir',' 1',' MDE1 X CM ','TOKO','SMBK-E','E1D-YLCX-141-0','CC X MODEL SLEP CM 14 8K ','OL H','1.160','1','100.00','1230000','0','0','15000','1252000','0','12000','0','1264000','NS','00383546','E1D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLCX-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E1D-YLCX-141-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 ('F226020201162','2026-01-02','1.160','2026-01-02','14:01:16','PLG0076107','1252000','1252000','12000','1264000','1264000','kasir','2026-01-02 14:01:16','F22602020116');
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-02','F226020201162','2026-01-02','14:01:16','NS','1264000','12000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260102-0012','D','2026-01-02','14:01:16','kasir','PENJUALAN','F226020201162','4431567000','1264000','4432831000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1264000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020201162' 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 ('F226020201163','kasir',' 1',' MEF3 X HW ','TOKO','SMBK-F','F3E-YLAG-83-0','GL X TIFF SLEP VAR HW 8K ','OL H','1.720','1','100.00','1858000','0','0','15000','1858000','0','17000','0','1875000','NS','00381437','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3E-YLAG-83-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 ('F226020201163','2026-01-02','1.720','2026-01-02','14:01:16','PLG0076108','1858000','1858000','17000','1875000','1875000','kasir','2026-01-02 14:01:16','F22602020116');
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-02','F226020201163','2026-01-02','14:01:16','NS','1875000','17000');
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-260102-0013','D','2026-01-02','14:01:16','kasir','PENJUALAN','F226020201163','4432831000','1875000','4434706000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020201163' 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 ('F226020201164','kasir',' 1',' MEF3 LG 12','TOKO','SMBK-F','F3E-YLAF-59-T','GL MODEL MEDAN SLEP PASIR LG 8K ','OL H','2.680','1','100.00','2894000','0','0','15000','2895000','0','27000','0','2922000','NS','T0075879','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAF-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3E-YLAF-59-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 ('F226020201164','2026-01-02','2.680','2026-01-02','14:01:16','PLG0076109','2895000','2895000','27000','2922000','2922000','kasir','2026-01-02 14:01:16','F22602020116');
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-02','F226020201164','2026-01-02','14:01:16','NS','2922000','27000');
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-260102-0014','D','2026-01-02','14:01:16','kasir','PENJUALAN','F226020201164','4434706000','2922000','4437628000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2922000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020201164' 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 ('F226020201165','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-YLAF-51-T','GL OVAL C SLEP YT 56 8K ','OL H','4.590','1','100.00','4957000','0','0','15000','4963000','0','40000','0','5003000','NS','T0075871','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAF-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.590',berat_jual_asli=berat_jual_asli+'4.590',stock_jual='1',berat_akhir=berat_akhir-'4.590',berat_akhir_asli=berat_akhir_asli-'4.590',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F1E-YLAF-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020201165','2026-01-02','4.590','2026-01-02','14:01:16','PLG0076110','4963000','4963000','40000','5003000','5003000','kasir','2026-01-02 14:01:16','F22602020116');
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-02','F226020201165','2026-01-02','14:01:16','NS','5003000','40000');
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-260102-0015','D','2026-01-02','14:01:16','kasir','PENJUALAN','F226020201165','4437628000','5003000','4442631000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5003000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020201165' 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 ('F226020205551','kasir','1',' MDD1 LT ','TOKO','SMBK-D','D1D-YLBD-3-T','LT MODEL FG SLEP LT 8K ','OL H','1.470','1','100.00','1558000','0','0','15000','1558000','0','15000','0','1573000','NS','T0076165','D1D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YLBD-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='D1D-YLBD-3-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 ('F226020205551','2026-01-02','1.470','2026-01-02','14:05:56','PLG0076111','1558000','1558000','15000','1573000','1573000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205551','2026-01-02','14:05:56','NS','1573000','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-260102-0016','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205551','4442631000','1573000','4444204000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205551' 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 ('F226020205552','kasir',' 1',' MED1E X LG','TOKO','SMBK-D','D1E-YLXF-212-0','LT X MODEL HURUF MATA LG Q 8K ','OL H','0.460','1','100.00','497000','0','0','15000','499000','0','8000','0','507000','NS','00380028','D1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YLXF-212-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='D1E-YLXF-212-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 ('F226020205552','2026-01-02','0.460','2026-01-02','14:05:56','PLG0076112','499000','499000','8000','507000','507000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205552','2026-01-02','14:05:56','NS','507000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260102-0017','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205552','4444204000','507000','4444711000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='507000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205552' 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 ('F226020205553','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YLAG-225-0','CC X MODEL AUREL MATA CM 12 8K ','OL H','0.680','1','100.00','734000','0','0','15000','736000','0','10000','0','746000','NS','00381579','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLAG-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E2E-YLAG-225-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 ('F226020205553','2026-01-02','0.680','2026-01-02','14:05:56','PLG0076113','736000','736000','10000','746000','746000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205553','2026-01-02','14:05:56','NS','746000','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-260102-0018','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205553','4444711000','746000','4445457000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='746000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205553' 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 ('F226020205554','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YKAA-306-0','CC X LISTERING MATA CM 14 8K ','OL H','0.800','1','100.00','848000','0','0','15000','851000','0','10000','0','861000','NS','00377272','E2D','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAA-306-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='E2D-YKAA-306-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 ('F226020205554','2026-01-02','0.800','2026-01-02','14:05:56','PLG0076114','851000','851000','10000','861000','861000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205554','2026-01-02','14:05:56','NS','861000','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-260102-0019','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205554','4445457000','861000','4446318000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='861000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205554' 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 ('F226020205555','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-YIAG-91-0','GL X RANTAI HOLLOW UB 8K ','OL H','4.910','1','100.00','5303000','0','0','15000','5312000','0','40000','0','5352000','NS','00369873','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAG-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3E-YIAG-91-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 ('F226020205555','2026-01-02','4.910','2026-01-02','14:05:56','PLG0076115','5312000','5312000','40000','5352000','5352000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205555','2026-01-02','14:05:56','NS','5352000','40000');
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-260102-0020','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205555','4446318000','5352000','4451670000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205555' 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 ('F226020205556','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YLAF-35-T','KL MILANO VAR UB 42 8K ','OL H','3.150','1','100.00','3402000','0','0','15000','3402000','0','32000','0','3434000','NS','T0075855','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLAF-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020205556','2026-01-02','3.150','2026-01-02','14:05:56','PLG0076116','3402000','3402000','32000','3434000','3434000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205556','2026-01-02','14:05:56','NS','3434000','32000');
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-260102-0021','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205556','4451670000','3434000','4455104000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3434000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205556' 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 ('F226020205557','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YLAF-38-T','KOL SIEM COBRA MATA VAR KH 42 8K ','OL H','1.830','1','100.00','1976000','0','0','15000','1977000','0','18000','0','1995000','NS','T0075858','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLAF-38-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 ('F226020205557','2026-01-02','1.830','2026-01-02','14:05:56','PLG0076117','1977000','1977000','18000','1995000','1995000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205557','2026-01-02','14:05:56','NS','1995000','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-260102-0022','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205557','4455104000','1995000','4457099000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1995000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205557' 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 ('F226020205558','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YLAF-13-T','KL SANTA ARESO PASIR VAR 42 HW 8K ','OL H','1.990','1','100.00','2149000','0','0','15000','2150000','0','20000','0','2170000','NS','T0075833','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLAF-13-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 ('F226020205558','2026-01-02','1.990','2026-01-02','14:05:56','PLG0076118','2150000','2150000','20000','2170000','2170000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205558','2026-01-02','14:05:56','NS','2170000','20000');
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-260102-0023','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205558','4457099000','2170000','4459269000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2170000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205558' 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 ('F226020205559','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YLAF-14-T','KL SANTA ARESO PASIR VAR 42 HW 8K ','OL H','1.930','1','100.00','2084000','0','0','15000','2085000','0','19000','0','2104000','NS','T0075834','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLAF-14-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 ('F226020205559','2026-01-02','1.930','2026-01-02','14:05:56','PLG0076119','2085000','2085000','19000','2104000','2104000','kasir','2026-01-02 14:05:55','F22602020555');
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-02','F226020205559','2026-01-02','14:05:56','NS','2104000','19000');
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-260102-0024','D','2026-01-02','14:05:56','kasir','PENJUALAN','F226020205559','4459269000','2104000','4461373000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2104000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020205559' 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 ('F226020207331','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-YLAF-15-T','KL SANTA ARESO PASIR VAR 42 HW 8K ','OL H','2.000','1','100.00','2160000','0','0','15000','2160000','0','20000','0','2180000','NS','T0075835','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLAF-15-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 ('F226020207331','2026-01-02','2.000','2026-01-02','14:07:33','PLG0076120','2160000','2160000','20000','2180000','2180000','kasir','2026-01-02 14:07:33','F22602020733');
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-02','F226020207331','2026-01-02','14:07:33','NS','2180000','20000');
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-260102-0025','D','2026-01-02','14:07:33','kasir','PENJUALAN','F226020207331','4461373000','2180000','4463553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2180000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020207331' 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 ('F226020207332','kasir',' 1',' MEH1E HW 4','TOKO','SMBK-H','H1E-YLBX-13-T','KL SANTA BOLA SLEP HW 42 8K ','OL H','1.840','1','100.00','1987000','0','0','15000','1988000','0','18000','0','2006000','NS','T0075998','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLBX-13-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 ('F226020207332','2026-01-02','1.840','2026-01-02','14:07:33','PLG0076121','1988000','1988000','18000','2006000','2006000','kasir','2026-01-02 14:07:33','F22602020733');
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-02','F226020207332','2026-01-02','14:07:33','NS','2006000','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-260102-0026','D','2026-01-02','14:07:33','kasir','PENJUALAN','F226020207332','4463553000','2006000','4465559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2006000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020207332' 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 ('F226020207333','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YLBX-9-T','KL TIFF MATA VAR UB 42 8K ','OL H','1.580','1','100.00','1706000','0','0','15000','1707000','0','16000','0','1723000','NS','T0075994','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='H1E-YLBX-9-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 ('F226020207333','2026-01-02','1.580','2026-01-02','14:07:33','PLG0076122','1707000','1707000','16000','1723000','1723000','kasir','2026-01-02 14:07:33','F22602020733');
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-02','F226020207333','2026-01-02','14:07:33','NS','1723000','16000');
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-260102-0027','D','2026-01-02','14:07:33','kasir','PENJUALAN','F226020207333','4465559000','1723000','4467282000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1723000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020207333' 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 ('F226020207334','kasir',' 1',' MEF2 PM 56','TOKO','SMBK-F','F2E-YLAF-55-T','GL PIPA MODEL MATA SLEP PM D56 8K ','OL H','2.950','1','100.00','3186000','0','0','15000','3186000','0','30000','0','3216000','NS','T0075875','F2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAF-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F2E-YLAF-55-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 ('F226020207334','2026-01-02','2.950','2026-01-02','14:07:33','PLG0076123','3186000','3186000','30000','3216000','3216000','kasir','2026-01-02 14:07:33','F22602020733');
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-02','F226020207334','2026-01-02','14:07:33','NS','3216000','30000');
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-260102-0028','D','2026-01-02','14:07:33','kasir','PENJUALAN','F226020207334','4467282000','3216000','4470498000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3216000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020207334' 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 ('F226020207335','kasir',' 1',' MEF2 PM 56','TOKO','SMBK-F','F2E-YLAF-56-T','GL PIPA MODEL MATA SLEP PM D56 8K ','OL H','3.020','1','100.00','3262000','0','0','15000','3262000','0','30000','0','3292000','NS','T0075876','F2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F2E-YLAF-56-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 ('F226020207335','2026-01-02','3.020','2026-01-02','14:07:33','PLG0076124','3262000','3262000','30000','3292000','3292000','kasir','2026-01-02 14:07:33','F22602020733');
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-02','F226020207335','2026-01-02','14:07:33','NS','3292000','30000');
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-260102-0029','D','2026-01-02','14:07:33','kasir','PENJUALAN','F226020207335','4470498000','3292000','4473790000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3292000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020207335' 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 ('F226020210401','kasir','1',' TDA1 X LG ','TOKO','TBK-A','A1TD-XIBG-13-T','AT X JERSY SLEP LG 17K ','OL H','0.970','1','100.00','1891000','0','0','15000','1893000','0','10000','0','1903000','NS','T0062338','A1TD','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-XIBG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='A1TD-XIBG-13-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 ('F226020210401','2026-01-02','0.970','2026-01-02','14:10:40','PLG0076125','1893000','1893000','10000','1903000','1903000','kasir','2026-01-02 14:10:40','F22602021040');
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-02','F226020210401','2026-01-02','14:10:40','NS','1903000','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-260102-0030','D','2026-01-02','14:10:40','kasir','PENJUALAN','F226020210401','4473790000','1903000','4475693000');
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 ('F226020211191','kasir','1',' TEF1 LT 56','TOKO','TBK-F','F1TE-YLAC-1-T','GL OVAL MODEL DAUN 56 LT 17K ','OL H','3.490','1','100.00','6875000','0','0','15000','6858000','0','35000','0','6893000','NS','T0075736','F1TE','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-YLAC-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F1TE-YLAC-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020211191','2026-01-02','3.490','2026-01-02','14:11:20','PLG0076126','6858000','6858000','35000','6893000','6893000','kasir','2026-01-02 14:11:19','F22602021119');
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-02','F226020211191','2026-01-02','14:11:20','NS','6893000','35000');
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-260102-0031','D','2026-01-02','14:11:20','kasir','PENJUALAN','F226020211191','4475693000','6893000','4482586000');
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 ('F226020219201','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YJBI-46-T','GL RANTAI HOLLOW PLAT VAR UB 8K ','OL','3.000','1','100.00','3240000','0','0','15000','3255000','0','15000','0','3270000','RTA','T0074606','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBI-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3E-YJBI-46-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 ('F226020219201','2026-01-02','3.000','2026-01-02','14:19:20','PLG0076127','3255000','3255000','15000','3270000','3270000','kasir','2026-01-02 14:19:20','F22602021920');
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-02','F226020219201','2026-01-02','14:19:20','RTA','3270000','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-260102-0032','D','2026-01-02','14:19:20','kasir','PENJUALAN','F226020219201','4482586000','3270000','4485856000');
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 ('F226020224471','kasir','1',' MFD1 X BG ','TOKO','SMBK-D','D1F-YIAG-41-0','LT X SLOBOK HURUF BULAT BG L 8K ','OL','0.510','1','100.00','561000','0','0','15000','564000','0','5000','0','569000','TIN','00369823','D1F','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YIAG-41-0' 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-01-02' AND kode_barang='D1F-YIAG-41-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 ('F226020224471','2026-01-02','0.510','2026-01-02','14:24:48','PLG0076128','564000','564000','5000','569000','569000','kasir','2026-01-02 14:24:47','F22602022447');
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-02','F226020224471','2026-01-02','14:24:48','TIN','569000','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-260102-0033','D','2026-01-02','14:24:48','kasir','PENJUALAN','F226020224471','4485856000','569000','4486425000');
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 ('F226020227161','kasir','1',' TGPB AY ','TOKO','TBK-P','PBTG-WFXI-129-T','GW WG TUSUK DEASY MATA AY ','','0.420','1','100.00','844000','0','0','15000','840000','0','0','0','840000','TIN','T0045114','PBTG','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBTG-WFXI-129-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='PBTG-WFXI-129-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' 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 ('F226020227161','2026-01-02','0.420','2026-01-02','14:27:17','PLG0076129','840000','840000','0','840000','840000','kasir','2026-01-02 14:27:16','F22602022716');
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-02','F226020227161','2026-01-02','14:27:17','TIN','840000','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-260102-0034','D','2026-01-02','14:27:17','kasir','PENJUALAN','F226020227161','4486425000','840000','4487265000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020201161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020201162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201163' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201163' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020201163';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201164' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201164' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020201164';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201165' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020201165' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020201165';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205553' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205553' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205553';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205554' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205554' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205554';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205555' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205555' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205555';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205556' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205556' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205556';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205557' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205557' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205557';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205558' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205558' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205558';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205559' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020205559' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020205559';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207333' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207333' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207333';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207334' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207334' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207334';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207335' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207335' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207335';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020210401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020210401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020210401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020211191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020211191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020211191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020219201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020219201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020219201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020224471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020224471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020224471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020227161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020227161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020227161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020831471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020831471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020831471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020832251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020832251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020832251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021001521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021001521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021001521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021018141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021018141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021018141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021021571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021021571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021021571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021037521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021037521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021037521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021134101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021134102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134103' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021134103' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021134103';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021140211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021140211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021140211';
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-00004975','X-00004975','CC MODEL PITA SLEP CM 13 8K','GR','---','E1E','BELI','BELI001','677000','2026-01-02','0.700','1','kasir','2026-01-02 15:17:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00004975','X-00004975');
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-260102-0001','F225200233061','RTA','1','BELI','BELI001','E1E', 'X-00004975', 'CC MODEL PITA SLEP CM 13 8K','0.700','0.700','100.00','753000','677000','967143','1075000','1','677000','677000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260102-0001','2026-01-02','2026-01-02','15:17:26','RTA','---','0.700','677000','677000','677000','677000','677000','kasir','2026-01-02 15:17:27','FB-260102-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0001','YAYUK','NDURU 1/1 SAMBIT','','','','kasir','2026-01-02 15:17:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0035','K','2026-01-02','15:17:26','kasir','PEMBELIAN UMUM','FB-260102-0001','4487265000','677000','4486588000');
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-00004976','X-00004976','GW TUSUK MODEL HATI MATA CM PE 8K','GR','---','B1E','BELI','BELI001','680000','2026-01-02','0.730','1','kasir','2026-01-02 15:17:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00004976','X-00004976');
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-260102-0002','F225121155291','RTA','2','BELI','BELI001','B1E', 'X-00004976', 'GW TUSUK MODEL HATI MATA CM PE 8K','0.730','0.730','100.00','756000','680000','931507','1075000','1','680000','680000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.730',berat_beli_asli=berat_beli_asli+'0.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.730',berat_akhir_asli=berat_akhir_asli+'0.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260102-0002','2026-01-02','2026-01-02','15:17:26','RTA','---','0.730','680000','680000','680000','680000','680000','kasir','2026-01-02 15:17:27','FB-260102-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0002','WIDIA','NGAMPEL BALONG','','','085791514565','kasir','2026-01-02 15:17:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0036','K','2026-01-02','15:17:26','kasir','PEMBELIAN UMUM','FB-260102-0002','4486588000','680000','4485908000');
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-00004977','X-00004977','GL MODEL FLIK VAR HW 8K','GR','---','F3E','BELI','BELI001','110000','2026-01-02','1.600','1','kasir','2026-01-02 15:17:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004977','X-00004977');
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-260102-0003','F225291022271','RTA','3','BELI','BELI001','F3E', 'X-00004977', 'GL MODEL FLIK VAR HW 8K','1.600','1.600','100.00','1248000','110000','68750','1075000','1','110000','110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' 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-260102-0003','2026-01-02','2026-01-02','15:17:26','RTA','---','1.600','110000','110000','110000','110000','110000','kasir','2026-01-02 15:17:27','FB-260102-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0003','RIRIN HAYUNINGSIH','PUDAK WETAN PUDAK','','','081330962422','kasir','2026-01-02 15:17:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0037','K','2026-01-02','15:17:26','kasir','PEMBELIAN UMUM','FB-260102-0003','4485908000','110000','4485798000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0003';
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-00004978','X-00004978','GL MODEL FLIK VAR HW 8K','GR','---','F3E','BELI','BELI001','1100000','2026-01-02','1.600','1','kasir','2026-01-02 15:19:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004978','X-00004978');
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-260102-0003','F225291022271','RTA','1','BELI','BELI001','F3E', 'X-00004978', 'GL MODEL FLIK VAR HW 8K','1.600','1.600','100.00','1248000','1100000','687500','1075000','1','1100000','1100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' 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-260102-0003','2026-01-02','2026-01-02','15:19:42','RTA','---','1.600','1100000','1100000','1100000','1100000','1100000','kasir','2026-01-02 15:19:42','FB-260102-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0003','RIRIN HAYUNINGSIH','PUDAK WETAN PUDAK','','','081330962422','kasir','2026-01-02 15:19:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0039','K','2026-01-02','15:19:42','kasir','PEMBELIAN UMUM','FB-260102-0003','4485908000','1100000','4484808000');
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-00004979','X-00004979','CC WARU DW 12','GR','---','E0TA','BELI','BELI001','2910000','2026-01-02','2.000','1','kasir','2026-01-02 15:20:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00004979','X-00004979');
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-260102-0004','F225170830552','NS','1','BELI','BELI001','E0TA', 'X-00004979', 'CC WARU DW 12','2.000','2.000','100.00','2410000','2910000','1455000','1870000','1','2910000','2910000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-260102-0004','2026-01-02','2026-01-02','15:20:20','NS','---','2.000','2910000','2910000','2910000','2910000','2910000','kasir','2026-01-02 15:20:20','FB-260102-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0004','SUMIRAH','SAWUH SIMAN','','','081230828166','kasir','2026-01-02 15:20:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0040','K','2026-01-02','15:20:20','kasir','PEMBELIAN UMUM','FB-260102-0004','4484808000','2910000','4481898000');
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-00004980','X-00004980','GW TUSUK DAISY MATA LG 8K','GR','---','B1G','BELI','BELI001','298000','2026-01-02','0.300','1','kasir','2026-01-02 15:20:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00004980','X-00004980');
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-260102-0005','F225190918042','TIN','1','BELI','BELI001','B1G', 'X-00004980', 'GW TUSUK DAISY MATA LG 8K','0.300','0.300','100.00','332000','298000','993333','1120000','1','298000','298000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' 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-260102-0005','2026-01-02','2026-01-02','15:20:48','TIN','---','0.300','298000','298000','298000','298000','298000','kasir','2026-01-02 15:20:48','FB-260102-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0005','LEONA','BARENG BABADAN','','','082232346540','kasir','2026-01-02 15:20:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0041','K','2026-01-02','15:20:48','kasir','PEMBELIAN UMUM','FB-260102-0005','4481898000','298000','4481600000');
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-00004981','X-00004981','GW MODEL TUSUK BUNGA BM 8K','GR','---','B1E','BELI','BELI001','432000','2026-01-02','0.450','1','kasir','2026-01-02 15:20:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00004981','X-00004981');
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-260102-0006','F225190918041','TIN','2','BELI','BELI001','B1E', 'X-00004981', 'GW MODEL TUSUK BUNGA BM 8K','0.450','0.450','100.00','480000','432000','960000','1075000','1','432000','432000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260102-0006','2026-01-02','2026-01-02','15:20:48','TIN','---','0.450','432000','432000','432000','432000','432000','kasir','2026-01-02 15:20:48','FB-260102-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0006','LEONA','BARENG BABADAN','','','082232346540','kasir','2026-01-02 15:20:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0042','K','2026-01-02','15:20:48','kasir','PEMBELIAN UMUM','FB-260102-0006','4481600000','432000','4481168000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0006';
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-00004982','X-00004982','CC POLOS CM 18 8K','GR','---','E1D','BELI','BELI001','833000','2026-01-02','1.030','1','kasir','2026-01-02 15:45:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00004982','X-00004982');
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-260102-0007','F225031258051','TIN','1','BELI','BELI001','E1D', 'X-00004982', 'CC POLOS CM 18 8K','1.030','1.030','100.00','984000','833000','808738','1060000','1','833000','833000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260102-0007','2026-01-02','2026-01-02','15:45:14','TIN','---','1.030','833000','833000','833000','833000','833000','kasir','2026-01-02 15:45:15','FB-260102-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260102-0007','ANANG WAHYUDI','BRINGIN 01/01 KAUMAN','','','081946071922','kasir','2026-01-02 15:45:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-02' 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-260102-0043','K','2026-01-02','15:45:14','kasir','PEMBELIAN UMUM','FB-260102-0007','4481168000','833000','4480335000');
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 ('F226020403291','admin','1',' TEF3 UB ','TOKO','TBK-F','F3TE-YFAA-48-T','GL RANTAI HOLLOW UB 17K ','','2.000','1','100.00','3940000','0','0','15000','3920000','0','0','0','3920000','RTA','T0069899','F3TE','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-01-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YFAA-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-01-02' AND kode_barang='F3TE-YFAA-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020403291','2026-01-02','2.000','2026-01-02','16:03:29','PLG0076130','3920000','3920000','0','3920000','3920000','admin','2026-01-02 16:03:29','F22602040329');
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-02','F226020403291','2026-01-02','16:03:29','RTA','3920000','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-260102-0044','D','2026-01-02','16:03:29','admin','PENJUALAN','F226020403291','4480335000','3920000','4484255000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020403291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020403291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020403291';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260102-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260102-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-02';
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-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-02';
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-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-02' 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-260103-0001','D','2026-01-03','16:17:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','4484255000','4484255000');
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-260103-0001','D','2026-01-03','16:17:10','BCA','SALDO AWAL','SALDO AWAL','0','4222754888','4222754888');
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-260103-0001','D','2026-01-03','16:17:10','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-260103-0001','D','2026-01-03','16:17:10','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-260103-0001','D','2026-01-03','16:17:10','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-260103-0001','D','2026-01-03','16:17:10','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-01-03';
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-20260103-0001','1','E1D-YKAA-266-0','1','1.030','1.030','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YKAA-266-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YKAA-266-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-03 16:35:16' WHERE kode_barang='E1D-YKAA-266-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YKAA-266-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-01-03 16:35:16','TOKO','SMBK-E','E1D','E1D-YKAA-266-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YKAA-266-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YKAA-266-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260103-0001','2026-01-03','16:35','1.030','input','2026-01-02 16:35:15');
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-20260103-0001','1','F1F-YKAA-98-0','1','3.570','3.570','TOKO','SBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1F-YKAA-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1F-YKAA-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-03 16:35:32' WHERE kode_barang='F1F-YKAA-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1F-YKAA-98-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-01-03 16:35:32','TOKO','SMBK-F','F1F','F1F-YKAA-98-0','1','3.570','3.570','1','3.570','3.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1F' 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='F1F-YKAA-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1F-YKAA-98-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260103-0001','2026-01-03','16:35','3.570','input','2026-01-02 16:35:31');