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 ('F326250908211','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YEXA-240-0','CC X MODEL MATA CM 10 8K ','','0.800','1','100.00','968000','0','0','15000','968000','0','0','0','968000','FIT','00351833','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-240-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-25' AND kode_barang='E2D-YEXA-240-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250908211','2026-01-25','0.800','2026-01-25','09:08:21','PLG0026882','968000','968000','0','968000','968000','input','2026-01-25 09:08:21','F32625090821');
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-25','F326250908211','2026-01-25','09:08:21','FIT','968000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0002','D','2026-01-25','09:08:21','input','PENJUALAN','F326250908211','2053439000','968000','2054407000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='968000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250908211' 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 ('F326250908212','input',' 1',' MEE2 X UB ','TOKO','PM-E','E2E-YKAA-290-0','CC X MODEL MATA UB 10 8K ','','0.750','1','100.00','922000','0','0','15000','922000','0','0','0','922000','FIT','00377256','E2E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKAA-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='E2E-YKAA-290-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250908212','2026-01-25','0.750','2026-01-25','09:08:21','PLG0026883','922000','922000','0','922000','922000','input','2026-01-25 09:08:21','F32625090821');
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-25','F326250908212','2026-01-25','09:08:21','FIT','922000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0003','D','2026-01-25','09:08:21','input','PENJUALAN','F326250908212','2054407000','922000','2055329000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='922000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250908212' 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 ('F326250916381','input','1',' MEF1 XXX Y','TOKO','PM-F','F1E-ZAAE-23-0','GL XXX OVAL C GELOMBANG YT 54 8K ','','3.050','1','100.00','3751000','0','0','15000','3660000','0','0','0','3660000','FIT','00385272','F1E','0','0','-','1','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAE-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F1E-ZAAE-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250916381','2026-01-25','3.050','2026-01-25','09:16:39','PLG0026884','3660000','3660000','0','3660000','3660000','input','2026-01-25 09:16:38','F32625091638');
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-25','F326250916381','2026-01-25','09:16:39','FIT','3660000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0004','D','2026-01-25','09:16:39','input','PENJUALAN','F326250916381','2055329000','3660000','2058989000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3660000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250916381' 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 ('F326250916382','input',' 1',' MDE2 X YT ','TOKO','PM-E','E2D-ZAAF-141-0','CC X MODEL MATA YT 14 8K ','','0.810','1','100.00','980000','0','0','15000','980000','0','0','0','980000','FIT','00385592','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='E2D-ZAAF-141-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250916382','2026-01-25','0.810','2026-01-25','09:16:39','PLG0026885','980000','980000','0','980000','980000','input','2026-01-25 09:16:38','F32625091638');
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-25','F326250916382','2026-01-25','09:16:39','FIT','980000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0005','D','2026-01-25','09:16:39','input','PENJUALAN','F326250916382','2058989000','980000','2059969000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250916382' 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 ('F326250916383','input',' 1',' MDE1 XX UB','TOKO','PM-E','E1D-ZAXI-392-0','CC XX MODEL SLEP UB 16 8K ','','0.850','1','100.00','1028000','0','0','15000','1003000','0','0','0','1003000','FIT','00384769','E1D','0','0','-','1','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXI-392-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='E1D-ZAXI-392-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250916383','2026-01-25','0.850','2026-01-25','09:16:39','PLG0026886','1003000','1003000','0','1003000','1003000','input','2026-01-25 09:16:38','F32625091638');
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-25','F326250916383','2026-01-25','09:16:39','FIT','1003000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0006','D','2026-01-25','09:16:39','input','PENJUALAN','F326250916383','2059969000','1003000','2060972000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1003000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250916383' 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 ('F326251012311','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-YLCX-180-0','CC X WEDDING POLOS CM 10 8K ','','1.020','1','100.00','1234000','0','0','15000','1235000','0','0','0','1235000','AAT','00383585','E1D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLCX-180-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='E1D-YLCX-180-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251012311','2026-01-25','1.020','2026-01-25','10:12:32','PLG0026887','1235000','1235000','0','1235000','1235000','input','2026-01-25 10:12:31','F32625101231');
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-25','F326251012311','2026-01-25','10:12:32','AAT','1235000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260125-0007','D','2026-01-25','10:12:32','input','PENJUALAN','F326251012311','2060972000','1235000','2062207000');
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 ('F326251039271','input','1',' MEF3 UB ','TOKO','PM-F','F3E-ZABX-80-0','GL LEMES MODEL CASTELI UB 8K ','','0.870','1','100.00','1070000','0','0','15000','1070000','0','0','0','1070000','AAT','00386309','F3E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABX-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F3E-ZABX-80-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251039271','2026-01-25','0.870','2026-01-25','10:39:27','PLG0026888','1070000','1070000','0','1070000','1070000','input','2026-01-25 10:39:27','F32625103927');
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-25','F326251039271','2026-01-25','10:39:27','AAT','1070000','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-260125-0008','D','2026-01-25','10:39:27','input','PENJUALAN','F326251039271','2062207000','1070000','2063277000');
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 ('F326251120361','input','1',' MEF2 XXX P','TOKO','PM-F','F2E-YLAX-225-0','GL XXX PIPA MATA PM 56 8K ','','5.020','1','100.00','6175000','0','0','15000','6025000','0','0','0','6025000','AAT','00380571','F2E','0','0','-','1','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAX-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.020',berat_jual_asli=berat_jual_asli+'5.020',stock_jual='1',berat_akhir=berat_akhir-'5.020',berat_akhir_asli=berat_akhir_asli-'5.020',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F2E-YLAX-225-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251120361','2026-01-25','5.020','2026-01-25','11:20:37','PLG0026889','6025000','6025000','0','6025000','6025000','input','2026-01-25 11:20:36','F32625112036');
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-25','F326251120361','2026-01-25','11:20:37','AAT','6025000','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-260125-0009','D','2026-01-25','11:20:37','input','PENJUALAN','F326251120361','2063277000','6025000','2069302000');
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 ('F326251159411','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-YKXA-222-0','KL X SIEM COBRA KH 42 9K ','','1.330','1','100.00','1769000','0','0','15000','1770000','0','0','0','1770000','SIN','00375793','H2J','0','0','-','0','1330000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YKXA-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='H2J-YKXA-222-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251159411','2026-01-25','1.330','2026-01-25','11:59:42','PLG0026890','1770000','1770000','0','1770000','1770000','input','2026-01-25 11:59:41','F32625115941');
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-25','F326251159411','2026-01-25','11:59:42','SIN','1770000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0010','D','2026-01-25','11:59:42','input','PENJUALAN','F326251159411','2069302000','1770000','2071072000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251159411' 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 ('F326251159412','input',' 1',' MFD1F UB ','TOKO','PM-D','D1F-YLXB-17-0','LT MODEL ARESO SLEP UB 8K ','','0.390','1','100.00','487000','0','0','15000','488000','0','0','0','488000','SIN','00379276','D1F','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXB-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='D1F-YLXB-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251159412','2026-01-25','0.390','2026-01-25','11:59:42','PLG0026891','488000','488000','0','488000','488000','input','2026-01-25 11:59:41','F32625115941');
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-25','F326251159412','2026-01-25','11:59:42','SIN','488000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0011','D','2026-01-25','11:59:42','input','PENJUALAN','F326251159412','2071072000','488000','2071560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='488000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251159412' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251159412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251159412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251159412';
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 ('F326251203211','kasir','1',' MFD1F UB ','TOKO','PM-D','D1F-YLXB-17-0','LT MODEL ARESO SLEP UB 8K ','','0.390','1','100.00','487000','0','0','15000','488000','0','0','0','488000','SIN','00379276','D1F','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXB-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='D1F-YLXB-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251203211','2026-01-25','0.390','2026-01-25','12:03:22','PLG0026892','488000','488000','0','488000','488000','kasir','2026-01-25 12:03:21','F32625120321');
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-25','F326251203211','2026-01-25','12:03:22','SIN','488000','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-260125-0013','D','2026-01-25','12:03:22','kasir','PENJUALAN','F326251203211','2071072000','488000','2071560000');
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 ('F326251217341','kasir','1',' TEF3 X HW ','TOKO','PT-F','F3TE-YLAC-35-T','GL X FANCY POLOS HW 17K ','','1.350','1','100.00','2997000','0','0','15000','2998000','0','0','0','2998000','SIN','T0075770','F3TE','0','0','-','0','2220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F3TE-YLAC-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326251217341','2026-01-25','1.350','2026-01-25','12:17:35','PLG0026893','2998000','2998000','0','2998000','2998000','kasir','2026-01-25 12:17:34','F32625121734');
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-25','F326251217341','2026-01-25','12:17:35','SIN','2998000','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-260125-0014','D','2026-01-25','12:17:35','kasir','PENJUALAN','F326251217341','2071560000','2998000','2074558000');
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 ('F326251249081','kasir','1',' MDD2D X LG','TOKO','PM-D','D2D-XJBE-224-0','LT X MODEL HURUF MATA LG J 8K ','','0.950','1','100.00','1149000','0','0','15000','1150000','0','0','0','1150000','FIT','00323862','D2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-XJBE-224-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-25' AND kode_barang='D2D-XJBE-224-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251249081','2026-01-25','0.950','2026-01-25','12:49:09','PLG0026894','1150000','1150000','0','1150000','1150000','kasir','2026-01-25 12:49:08','F32625124908');
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-25','F326251249081','2026-01-25','12:49:09','FIT','1150000','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-260125-0015','D','2026-01-25','12:49:09','kasir','PENJUALAN','F326251249081','2074558000','1150000','2075708000');
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 ('F326251253171','kasir','1',' MEF2 UB D5','TOKO','PM-F','F2E-YKBH-90-0','GL OVAL MODEL PITA MATA UB D56 8K ','','2.520','1','100.00','3100000','0','0','15000','3100000','0','0','0','3100000','SIN','00378951','F2E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YKBH-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F2E-YKBH-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326251253171','2026-01-25','2.520','2026-01-25','12:53:18','PLG0026895','3100000','3100000','0','3100000','3100000','kasir','2026-01-25 12:53:17','F32625125317');
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-25','F326251253171','2026-01-25','12:53:18','SIN','3100000','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-260125-0016','D','2026-01-25','12:53:18','kasir','PENJUALAN','F326251253171','2075708000','3100000','2078808000');
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 ('F326250146081','kasir','1',' MEE1 LG 16','TOKO','PM-E','E1E-ZAXH-130-T','CC MODEL DAUN LG 16 8K ','','0.470','1','100.00','578000','0','0','15000','578000','0','0','0','578000','FIT','T0076453','E1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZAXH-130-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='E1E-ZAXH-130-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250146081','2026-01-25','0.470','2026-01-25','13:46:09','PLG0026896','578000','578000','0','578000','578000','kasir','2026-01-25 13:46:08','F32625014608');
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-25','F326250146081','2026-01-25','13:46:09','FIT','578000','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-260125-0017','D','2026-01-25','13:46:09','kasir','PENJUALAN','F326250146081','2078808000','578000','2079386000');
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-00018053','X-00018053','LT COR M 8K','GR','---','D2F','BELI','BELI001','355000','2026-01-25','0.500','1','kasir','2026-01-25 13:54:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00018053','X-00018053');
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-260125-0001','F321301107491','SIN','1','BELI','BELI001','D2F', 'X-00018053', 'LT COR M 8K','0.500','0.500','100.00','215000','355000','710000','1250000','1','355000','355000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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-260125-0001','2026-01-25','2026-01-25','13:54:01','SIN','---','0.500','355000','355000','355000','355000','355000','kasir','2026-01-25 13:54:02','FB-260125-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0001','ZAHRA','JERUK','','','','kasir','2026-01-25 13:54:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0018','K','2026-01-25','13:54:01','kasir','PEMBELIAN UMUM','FB-260125-0001','2079386000','355000','2079031000');
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-00018054','X-00018054','GL CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1245000','2026-01-25','1.500','1','kasir','2026-01-25 13:55:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018054','X-00018054');
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-260125-0002','F325071248171','AAT','1','BELI','BELI001','F3E', 'X-00018054', 'GL CAPELLA SLEP HW 8K','1.520','1.500','100.00','1125000','1245000','830000','1240000','1','1245000','1245000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260125-0002','2026-01-25','2026-01-25','13:55:48','AAT','---','1.500','1245000','1245000','1245000','1245000','1245000','kasir','2026-01-25 13:55:48','FB-260125-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0002','TITIS','NAWANGAN PACITAN','','','','kasir','2026-01-25 13:55:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0019','K','2026-01-25','13:55:48','kasir','PEMBELIAN UMUM','FB-260125-0002','2079031000','1245000','2077786000');
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-00018055','X-00018055','CC X MODEL MATA LG 6 8K','GR','---','E2E','BELI','BELI001','800000','2026-01-25','1.020','1','kasir','2026-01-25 13:57:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018055','X-00018055');
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-260125-0003','F324170912161','FIT','1','BELI','BELI001','E2E', 'X-00018055', 'CC X MODEL MATA LG 6 8K','1.020','1.020','100.00','533000','800000','784314','1240000','1','800000','800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260125-0003','2026-01-25','2026-01-25','13:57:08','FIT','---','1.020','800000','800000','800000','800000','800000','kasir','2026-01-25 13:57:08','FB-260125-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0003','SUWANTI','JAJAR TALESAN','','','','kasir','2026-01-25 13:57:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0020','K','2026-01-25','13:57:08','kasir','PEMBELIAN UMUM','FB-260125-0003','2077786000','800000','2076986000');
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 ('F326250202481','kasir','1',' MEH1 KH 42','TOKO','PM-H','H1E-YKBI-176-0','KL SIEM KH 42CM 8K ','','2.030','1','100.00','2497000','0','0','15000','2497000','0','0','0','2497000','AAT','00379142','H1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBI-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='H1E-YKBI-176-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250202481','2026-01-25','2.030','2026-01-25','14:02:48','PLG0026897','2497000','2497000','0','2497000','2497000','kasir','2026-01-25 14:02:48','F32625020248');
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-25','F326250202481','2026-01-25','14:02:48','AAT','2497000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0021','D','2026-01-25','14:02:48','kasir','PENJUALAN','F326250202481','2076986000','2497000','2079483000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2497000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250202481' 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 ('F326250202482','kasir',' 1',' MED2E X LG','TOKO','PM-D','D2E-YJBA-118-0','LT X MODEL HURUF MATA LG E 8K ','','0.560','1','100.00','689000','0','0','15000','688000','0','0','0','688000','AAT','00373995','D2E','0','0','-','1','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJBA-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='D2E-YJBA-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250202482','2026-01-25','0.560','2026-01-25','14:02:48','PLG0026898','688000','688000','0','688000','688000','kasir','2026-01-25 14:02:48','F32625020248');
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-25','F326250202482','2026-01-25','14:02:48','AAT','688000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260125-0022','D','2026-01-25','14:02:48','kasir','PENJUALAN','F326250202482','2079483000','688000','2080171000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='688000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250202482' 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 ('F326250207141','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-ZABC-141-0','GL TRIXIE SERUT BUNGA CLOVER VAR UB 8K ','','3.180','1','100.00','3911000','0','0','15000','3910000','0','0','0','3910000','FIT','00386771','F3E','0','0','-','1','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABC-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F3E-ZABC-141-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250207141','2026-01-25','3.180','2026-01-25','14:07:15','PLG0026899','3910000','3910000','0','3910000','3910000','kasir','2026-01-25 14:07:14','F32625020714');
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-25','F326250207141','2026-01-25','14:07:15','FIT','3910000','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-260125-0023','D','2026-01-25','14:07:15','kasir','PENJUALAN','F326250207141','2080171000','3910000','2084081000');
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 ('F326250231121','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-YLBI-182-0','GL XX TIFF SPECTRA SERUT YT 8K ','','1.090','1','100.00','1341000','0','0','15000','1342000','0','0','0','1342000','SIN','00383334','F3E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBI-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='F3E-YLBI-182-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250231121','2026-01-25','1.090','2026-01-25','14:31:13','PLG0026900','1342000','1342000','0','1342000','1342000','kasir','2026-01-25 14:31:12','F32625023112');
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-25','F326250231121','2026-01-25','14:31:13','SIN','1342000','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-260125-0024','D','2026-01-25','14:31:13','kasir','PENJUALAN','F326250231121','2084081000','1342000','2085423000');
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 ('F326250232551','kasir','1',' MEA1E X PM','TOKO','PM-A','A1D-YLBI-8-0','AT X ITALY SLEP VAR PM 8K','','0.600','1','100.00','726000','0','0','15000','738000','0','0','0','738000','FIT','00383160','A1D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLBI-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='A1D-YLBI-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250232551','2026-01-25','0.600','2026-01-25','14:32:56','PLG0026901','738000','738000','0','738000','738000','kasir','2026-01-25 14:32:55','F32625023255');
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-25','F326250232551','2026-01-25','14:32:56','FIT','738000','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-260125-0025','D','2026-01-25','14:32:56','kasir','PENJUALAN','F326250232551','2085423000','738000','2086161000');
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-00018056','X-00018056','GL X SANTAI MATA VAR SERUT UB 8K','GR','---','F3E','BELI','BELI001','1302000','2026-01-25','1.550','1','kasir','2026-01-25 14:34:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018056','X-00018056');
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-260125-0004','F325140300131','SIN','1','BELI','BELI001','F3E', 'X-00018056', 'GL X SANTAI MATA VAR SERUT UB 8K','1.550','1.550','100.00','1387000','1302000','840000','1240000','1','1302000','1302000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260125-0004','2026-01-25','2026-01-25','14:34:41','SIN','---','1.550','1302000','1302000','1302000','1302000','1302000','kasir','2026-01-25 14:34:42','FB-260125-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0004','NANIK HANDAYANI','KAPURAN BADEGAN','','','','kasir','2026-01-25 14:34:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0026','K','2026-01-25','14:34:41','kasir','PEMBELIAN UMUM','FB-260125-0004','2086161000','1302000','2084859000');
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 ('F326250238521','kasir','1',' MEA1 X 5K ','TOKO','PM-A','A1E-YLBC-225-0','AT X MODEL BONEKA CAT MATA LG 8K ','','0.550','1','100.00','676000','0','0','15000','675000','0','5000','0','680000','AAT','00382668','A1E','0','0','-','1','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBC-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='A1E-YLBC-225-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250238521','2026-01-25','0.550','2026-01-25','14:38:53','PLG0026902','675000','675000','5000','680000','680000','kasir','2026-01-25 14:38:52','F32625023852');
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-25','F326250238521','2026-01-25','14:38:53','AAT','680000','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-260125-0027','D','2026-01-25','14:38:53','kasir','PENJUALAN','F326250238521','2084859000','680000','2085539000');
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-00018057','X-00018057','GW MODEL TAOGE SLEP HK','GR','---','B1F','BELI','BELI001','140000','2026-01-25','0.200','1','kasir','2026-01-25 14:39:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00018057','X-00018057');
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-260125-0005','F322201059241','AAT','1','BELI','BELI001','B1F', 'X-00018057', 'GW MODEL TAOGE SLEP HK','0.400','0.200','100.00','172000','140000','700000','1250000','1','140000','140000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.200',berat_beli_asli=berat_beli_asli+'0.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.200',berat_akhir_asli=berat_akhir_asli+'0.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-260125-0005','2026-01-25','2026-01-25','14:39:41','AAT','---','0.200','140000','140000','140000','140000','140000','kasir','2026-01-25 14:39:41','FB-260125-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0005','NANA','GONDANG BULUKERTO','','','','kasir','2026-01-25 14:39:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0028','K','2026-01-25','14:39:41','kasir','PEMBELIAN UMUM','FB-260125-0005','2085539000','140000','2085399000');
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 ('F326250246291','kasir','1',' MEA1 LG ','TOKO','PM-A','A1E-YGXB-154-0','AT MODEL MATA VAR LG 8K ','','0.600','1','100.00','738000','0','0','15000','740000','0','0','0','740000','AAT','00359239','A1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-01-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGXB-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-01-25' AND kode_barang='A1E-YGXB-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326250246291','2026-01-25','0.600','2026-01-25','14:46:29','PLG0026903','740000','740000','0','740000','740000','kasir','2026-01-25 14:46:29','F32625024629');
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-25','F326250246291','2026-01-25','14:46:29','AAT','740000','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-260125-0029','D','2026-01-25','14:46:29','kasir','PENJUALAN','F326250246291','2085399000','740000','2086139000');
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-00018058','X-00018058','GL X TIFF BOLA MATA VAR UB 8K','GR','---','F3E','BELI','BELI001','4467000','2026-01-25','4.180','1','kasir','2026-01-25 15:11:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018058','X-00018058');
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-260125-0006','F326160300012','AAT','1','BELI','BELI001','F3E', 'X-00018058', 'GL X TIFF BOLA MATA VAR UB 8K','4.180','4.180','100.00','4753000','4467000','1068660','1240000','1','4467000','4467000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.180',berat_beli_asli=berat_beli_asli+'4.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.180',berat_akhir_asli=berat_akhir_asli+'4.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260125-0006','2026-01-25','2026-01-25','15:11:56','AAT','---','4.180','4467000','4467000','4467000','4467000','4467000','kasir','2026-01-25 15:11:56','FB-260125-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0006','CICI','BITING BADEGAN','','','','kasir','2026-01-25 15:11:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0030','K','2026-01-25','15:11:56','kasir','PEMBELIAN UMUM','FB-260125-0006','2086139000','4467000','2081672000');
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-00018059','X-00018059','GL X OVAL MODEL C UB D58 8K','GR','---','F1E','BELI','BELI001','4055000','2026-01-25','4.670','1','kasir','2026-01-25 15:11:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018059','X-00018059');
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-260125-0007','F325070215321','AAT','2','BELI','BELI001','F1E', 'X-00018059', 'GL X OVAL MODEL C UB D58 8K','4.670','4.670','100.00','4607000','4055000','868308','1240000','1','4055000','4055000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.670',berat_beli_asli=berat_beli_asli+'4.670',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.670',berat_akhir_asli=berat_akhir_asli+'4.670',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260125-0007','2026-01-25','2026-01-25','15:11:56','AAT','---','4.670','4055000','4055000','4055000','4055000','4055000','kasir','2026-01-25 15:11:56','FB-260125-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260125-0007','CICI FATMAWATI','BITING BADEGAN','','','','kasir','2026-01-25 15:11:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260125-0031','K','2026-01-25','15:11:56','kasir','PEMBELIAN UMUM','FB-260125-0007','2081672000','4055000','2077617000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260125-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260125-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250146081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250146081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250146081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250202481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250202481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250202481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250202482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250202482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250202482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250207141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250207141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250207141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250231121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250231121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250231121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250232551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250232551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250232551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250238521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250238521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250238521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250246291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250246291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250246291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250908211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250908211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250908211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250908212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250908212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250908212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250916381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250916382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916383' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250916383' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250916383';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251012311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251012311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251012311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251039271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251039271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251039271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251120361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251120361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251120361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251159411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251159411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251159411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251203211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251203211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251203211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251217341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251217341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251217341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251249081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251249081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251249081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251253171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251253171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251253171';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-25';
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-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260126-0001','D','2026-01-26','15:51:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','2077617000','2077617000');
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-260126-0001','D','2026-01-26','15:51:23','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260126-0001','D','2026-01-26','15:51:23','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-260126-0001','D','2026-01-26','15:51:23','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-01-26';