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 ('F326190823361','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDAX-243-0','CC X MODEL DAUN SLEP CM 24 8K','','1.260','1','100.00','1443000','0','0','15000','1443000','0','0','0','1443000','AAT','00399013','E1D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAX-243-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E1D-ZDAX-243-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 ('F326190823361','2026-04-19','1.260','2026-04-19','08:23:36','PLG0028702','1443000','1443000','0','1443000','1443000','input','2026-04-19 08:23:36','F32619082336');
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-04-19','F326190823361','2026-04-19','08:23:36','AAT','1443000','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-260419-0002','D','2026-04-19','08:23:36','input','PENJUALAN','F326190823361','4443880000','1443000','4445323000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1443000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190823361' 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 ('F326190823362','input',' 1',' MDE2 MJ 12','TOKO','PM-E','E2D-ZCAI-793-0','CC MODEL MATA VAR MJ 12 8K ','','0.980','1','100.00','1122000','0','0','15000','1122000','0','0','0','1122000','AAT','00396196','E2D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-793-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E2D-ZCAI-793-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 ('F326190823362','2026-04-19','0.980','2026-04-19','08:23:36','PLG0028703','1122000','1122000','0','1122000','1122000','input','2026-04-19 08:23:36','F32619082336');
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-04-19','F326190823362','2026-04-19','08:23:36','AAT','1122000','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-260419-0003','D','2026-04-19','08:23:36','input','PENJUALAN','F326190823362','4445323000','1122000','4446445000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1122000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190823362' 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 ('F326190823363','input',' 1',' MEF3E X BG','TOKO','PM-F','F3E-ZCXG-251-0','GL X TIFF HATI VAR BG 8K ','','1.520','1','100.00','1771000','0','0','15000','1770000','0','0','0','1770000','AAT','00392687','F3E','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-251-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='F3E-ZCXG-251-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 ('F326190823363','2026-04-19','1.520','2026-04-19','08:23:36','PLG0028704','1770000','1770000','0','1770000','1770000','input','2026-04-19 08:23:36','F32619082336');
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-04-19','F326190823363','2026-04-19','08:23:36','AAT','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-260419-0004','D','2026-04-19','08:23:36','input','PENJUALAN','F326190823363','4446445000','1770000','4448215000','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='F326190823363' 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 ('F326190911571','input','1',' MEF3 PM ','TOKO','PM-F','F3E-ZDAC-81-0','GL KREPYAK HARLEY SISIK NAGA PM 8K ','','10.030','1','100.00','11685000','0','0','15000','11685000','0','0','0','11685000','SIN','00399251','F3E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAC-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.030',berat_jual_asli=berat_jual_asli+'10.030',stock_jual='1',berat_akhir=berat_akhir-'10.030',berat_akhir_asli=berat_akhir_asli-'10.030',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='F3E-ZDAC-81-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 ('F326190911571','2026-04-19','10.030','2026-04-19','09:11:58','PLG0028705','11685000','11685000','0','11685000','11685000','input','2026-04-19 09:11:57','F32619091157');
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-04-19','F326190911571','2026-04-19','09:11:58','SIN','11685000','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-260419-0005','D','2026-04-19','09:11:58','input','PENJUALAN','F326190911571','4448215000','11685000','4459900000');
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 ('F326190955431','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZCXG-223-0','KL X SIEM COBRA KH 42 9K ','','1.260','1','100.00','1594000','0','0','15000','1595000','0','0','0','1595000','SIN','00392659','H2J','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCXG-223-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='H2J-ZCXG-223-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 ('F326190955431','2026-04-19','1.260','2026-04-19','09:55:44','PLG0028706','1595000','1595000','0','1595000','1595000','input','2026-04-19 09:55:43','F32619095543');
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-04-19','F326190955431','2026-04-19','09:55:44','SIN','1595000','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-260419-0006','D','2026-04-19','09:55:44','input','PENJUALAN','F326190955431','4459900000','1595000','4461495000');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1751500',harga_beli ='1751500' WHERE kode_barcode='T0073760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3566000',harga_beli ='3566000' WHERE kode_barcode='T0075756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2954000',harga_beli ='2954000' WHERE kode_barcode='T0075751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2764500',harga_beli ='2764500' WHERE kode_barcode='T0075747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3017500',harga_beli ='3017500' WHERE kode_barcode='T0075746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2743000',harga_beli ='2743000' WHERE kode_barcode='T0075743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2701000',harga_beli ='2701000' WHERE kode_barcode='T0075742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0074492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='T0074491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1920500',harga_beli ='1920500' WHERE kode_barcode='T0075757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2870000',harga_beli ='2870000' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2490000',harga_beli ='2490000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2068000',harga_beli ='2068000' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4283500',harga_beli ='4283500' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2996500',harga_beli ='2996500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1857000',harga_beli ='1857000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='T0075758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2954000',harga_beli ='2954000' WHERE kode_barcode='T0075759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3524000',harga_beli ='3524000' WHERE kode_barcode='T0075761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3123000',harga_beli ='3123000' WHERE kode_barcode='T0075762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4178000',harga_beli ='4178000' WHERE kode_barcode='T0075766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='T0076229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='T0076234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3439500',harga_beli ='3439500' WHERE kode_barcode='T0076235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3123000',harga_beli ='3123000' WHERE kode_barcode='T0076236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='T0070411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4114500',harga_beli ='4114500' WHERE kode_barcode='T0076171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='T0078281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4157000',harga_beli ='4157000' WHERE kode_barcode='T0078280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2068000',harga_beli ='2068000' WHERE kode_barcode='T0078492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='T0078496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5022000',harga_beli ='5022000' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5127500',harga_beli ='5127500' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2637500',harga_beli ='2637500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3397500',harga_beli ='3397500' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2743000',harga_beli ='2743000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2553500',harga_beli ='2553500' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2806500',harga_beli ='2806500' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5064000',harga_beli ='5064000' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4853000',harga_beli ='4853000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2068000',harga_beli ='2068000' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2448000',harga_beli ='2448000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2448000',harga_beli ='2448000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3735000',harga_beli ='3735000' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4157000',harga_beli ='4157000' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3692500',harga_beli ='3692500' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2637500',harga_beli ='2637500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2912000',harga_beli ='2912000' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3608500',harga_beli ='3608500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='9516500',harga_beli ='9516500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2637500',harga_beli ='2637500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2026000',harga_beli ='2026000' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','2110000','input','2026-04-19 10:00:51');
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 ('F326191001231','input','1',' TDE2 X LG ','TOKO','PT-E','E2TD-YIXE-12-T','CC X MODEL MATA VAR LG 10 17K ','','1.210','1','100.00','2553000','0','0','15000','2555000','0','0','0','2555000','AAT','T0072982','E2TD','0','0','-','0','2110000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXE-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E2TD-YIXE-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326191001231','2026-04-19','1.210','2026-04-19','10:01:24','PLG0028707','2555000','2555000','0','2555000','2555000','input','2026-04-19 10:01:23','F32619100123');
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-04-19','F326191001231','2026-04-19','10:01:24','AAT','2555000','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-260419-0007','D','2026-04-19','10:01:24','input','PENJUALAN','F326191001231','4461495000','2555000','4464050000');
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 ('F326191109541','kasir','1',' MEH1 X 15K','TOKO','PM-H','H1E-ZCAF-4-0','KL X ANAK SANTA BONEKA CAT VAR UB 8K ','','2.580','1','100.00','3006000','0','0','15000','3005000','0','15000','0','3020000','AAT','00394622','H1E','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='H1E-ZCAF-4-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 ('F326191109541','2026-04-19','2.580','2026-04-19','11:09:54','PLG0028708','3005000','3005000','15000','3020000','3020000','kasir','2026-04-19 11:09:54','F32619110954');
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-04-19','F326191109541','2026-04-19','11:09:54','AAT','3020000','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-260419-0008','D','2026-04-19','11:09:54','kasir','PENJUALAN','F326191109541','4464050000','3020000','4467070000');
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 ('F326191114491','kasir','1',' MEF3E 10K ','TOKO','PM-F','F3E-ZDAE-220-0','GL RANTAI HOLLOW P3 SLEP UB 8K ','','1.000','1','100.00','1165000','0','0','15000','1165000','0','10000','0','1175000','LIS','00399506','F3E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAE-220-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='F3E-ZDAE-220-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 ('F326191114491','2026-04-19','1.000','2026-04-19','11:14:50','PLG0028709','1165000','1165000','10000','1175000','1175000','kasir','2026-04-19 11:14:49','F32619111449');
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-04-19','F326191114491','2026-04-19','11:14:50','LIS','1175000','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-260419-0009','D','2026-04-19','11:14:50','kasir','PENJUALAN','F326191114491','4467070000','1175000','4468245000');
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 ('F326191201121','kasir','1',' MHA1 CM ','TOKO','PM-A','A1H-ZDXG-169-0','AT TINDIK BABY CM 8K ','','0.260','1','100.00','318000','0','0','15000','320000','0','0','0','320000','SIN','00398344','A1H','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-ZDXG-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='A1H-ZDXG-169-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 ('F326191201121','2026-04-19','0.260','2026-04-19','12:01:13','PLG0028710','320000','320000','0','320000','320000','kasir','2026-04-19 12:01:12','F32619120112');
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-04-19','F326191201121','2026-04-19','12:01:13','SIN','320000','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-260419-0010','D','2026-04-19','12:01:13','kasir','PENJUALAN','F326191201121','4468245000','320000','4468565000');
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 ('F326191208271','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZDAX-136-0','GL X TIFF SPECTRA VAR HW 8K ','','3.110','1','100.00','3623000','0','0','15000','3623000','0','0','0','3623000','LIS','00398906','F3E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAX-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='F3E-ZDAX-136-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 ('F326191208271','2026-04-19','3.110','2026-04-19','12:08:28','PLG0028711','3623000','3623000','0','3623000','3623000','kasir','2026-04-19 12:08:27','F32619120827');
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-04-19','F326191208271','2026-04-19','12:08:28','LIS','3623000','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-260419-0011','D','2026-04-19','12:08:28','kasir','PENJUALAN','F326191208271','4468565000','3623000','4472188000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3623000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326191208271' 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 ('F326191208272','kasir',' 1',' MEH1 UB 42','TOKO','PM-H','H1E-ZCAG-207-0','KL GUCCI UB 42 8K ','','3.050','1','100.00','3553000','0','0','15000','3553000','0','0','0','3553000','LIS','00394925','H1E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAG-207-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-04-19' AND kode_barang='H1E-ZCAG-207-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 ('F326191208272','2026-04-19','3.050','2026-04-19','12:08:28','PLG0028712','3553000','3553000','0','3553000','3553000','kasir','2026-04-19 12:08:27','F32619120827');
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-04-19','F326191208272','2026-04-19','12:08:28','LIS','3553000','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-260419-0012','D','2026-04-19','12:08:28','kasir','PENJUALAN','F326191208272','4472188000','3553000','4475741000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326191208272' 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 ('F326191208273','kasir',' 1',' MDD2D X CM','TOKO','PM-D','D2D-ZAXI-253-0','LT X MODEL MATA CM 8K ','','0.850','1','100.00','973000','0','0','15000','974000','0','0','0','974000','LIS','00384630','D2D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZAXI-253-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-04-19' AND kode_barang='D2D-ZAXI-253-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 ('F326191208273','2026-04-19','0.850','2026-04-19','12:08:28','PLG0028713','974000','974000','0','974000','974000','kasir','2026-04-19 12:08:27','F32619120827');
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-04-19','F326191208273','2026-04-19','12:08:28','LIS','974000','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-260419-0013','D','2026-04-19','12:08:28','kasir','PENJUALAN','F326191208273','4475741000','974000','4476715000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='974000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326191208273' 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 ('F326191228411','kasir','1',' MDE2 X BM ','TOKO','PM-E','E2D-YGXG-234-0','CC X MODEL MATA CAT BM 16 8K ','','1.460','1','100.00','1672000','0','0','15000','1670000','0','0','0','1670000','AAT','00360219','E2D','0','0','-','1','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXG-234-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E2D-YGXG-234-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 ('F326191228411','2026-04-19','1.460','2026-04-19','12:28:42','PLG0028714','1670000','1670000','0','1670000','1670000','kasir','2026-04-19 12:28:41','F32619122841');
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-04-19','F326191228411','2026-04-19','12:28:42','AAT','1670000','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-260419-0014','D','2026-04-19','12:28:42','kasir','PENJUALAN','F326191228411','4476715000','1670000','4478385000');
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 ('F326191234141','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCBE-210-0','CC X MODEL SLEP CM 16 8K ','','1.550','1','100.00','1775000','0','0','15000','1775000','0','0','0','1775000','SIN','00396672','E1D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCBE-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E1D-ZCBE-210-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 ('F326191234141','2026-04-19','1.550','2026-04-19','12:34:14','PLG0028715','1775000','1775000','0','1775000','1775000','kasir','2026-04-19 12:34:14','F32619123414');
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-04-19','F326191234141','2026-04-19','12:34:14','SIN','1775000','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-260419-0015','D','2026-04-19','12:34:14','kasir','PENJUALAN','F326191234141','4478385000','1775000','4480160000');
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-00018863','X-00018863','AT MODEL BOLA ARESO VAR HW 8K','GR','---','A1D','BELI','BELI001','902000','2026-04-19','0.850','1','kasir','2026-04-19 12:35:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00018863','X-00018863');
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-260419-0001','F326201156321','AAT','1','BELI','BELI001','A1D', 'X-00018863', 'AT MODEL BOLA ARESO VAR HW 8K','0.850','0.850','100.00','1037000','902000','1061176','1155000','1','902000','902000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260419-0001','2026-04-19','2026-04-19','12:35:24','AAT','---','0.850','902000','902000','902000','902000','902000','kasir','2026-04-19 12:35:24','FB-260419-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0001','NARTI','SAMPUNG','','','08257835312','kasir','2026-04-19 12:35:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0016','K','2026-04-19','12:35:24','kasir','PEMBELIAN UMUM','FB-260419-0001','4480160000','902000','4479258000');
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-00018864','X-00018864','CC MODEL DAUN LG 9 8K','GR','---','E1E','BELI','BELI001','443000','2026-04-19','0.410','1','kasir','2026-04-19 12:35:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018864','X-00018864');
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-260419-0002','F326201156322','AAT','1','BELI','BELI001','E1E', 'X-00018864', 'CC MODEL DAUN LG 9 8K','0.410','0.410','100.00','508000','443000','1080488','1175000','1','443000','443000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.410',berat_beli_asli=berat_beli_asli+'0.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.410',berat_akhir_asli=berat_akhir_asli+'0.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' 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-260419-0002','2026-04-19','2026-04-19','12:35:49','AAT','---','0.410','443000','443000','443000','443000','443000','kasir','2026-04-19 12:35:50','FB-260419-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0002','NARTI','SAMPUNG','','','08257835312','kasir','2026-04-19 12:35:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0017','K','2026-04-19','12:35:49','kasir','PEMBELIAN UMUM','FB-260419-0002','4479258000','443000','4478815000');
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-00018865','X-00018865','KL MILANO 42 CM UB 8K','GR','---','H1E','BELI','BELI001','2260000','2026-04-19','2.110','1','kasir','2026-04-19 12:36:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018865','X-00018865');
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-260419-0003','F326091042281','SIN','1','BELI','BELI001','H1E', 'X-00018865', 'KL MILANO 42 CM UB 8K','2.110','2.110','100.00','2458000','2260000','1071090','1175000','1','2260000','2260000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.110',berat_beli_asli=berat_beli_asli+'2.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.110',berat_akhir_asli=berat_akhir_asli+'2.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260419-0003','2026-04-19','2026-04-19','12:36:44','SIN','---','2.110','2260000','2260000','2260000','2260000','2260000','kasir','2026-04-19 12:36:45','FB-260419-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0003','BETI','KISMANTORO','','','085631147677','kasir','2026-04-19 12:36:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0018','K','2026-04-19','12:36:44','kasir','PEMBELIAN UMUM','FB-260419-0003','4478815000','2260000','4476555000');
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-00018866','X-00018866','GL X HARELY SLEP KH 8K','GR','---','F3E','BELI','BELI001','9618000','2026-04-19','10.090','1','kasir','2026-04-19 12:37:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018866','X-00018866');
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-260419-0004','F325141246161','FIT','1','BELI','BELI001','F3E', 'X-00018866', 'GL X HARELY SLEP KH 8K','10.090','10.090','100.00','10343000','9618000','953221','1175000','1','9618000','9618000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.090',berat_beli_asli=berat_beli_asli+'10.090',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.090',berat_akhir_asli=berat_akhir_asli+'10.090',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' 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-260419-0004','2026-04-19','2026-04-19','12:37:09','FIT','---','10.090','9618000','9618000','9618000','9618000','9618000','kasir','2026-04-19 12:37:09','FB-260419-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0004','SITI','JERUK PACITAN','','','','kasir','2026-04-19 12:37:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0019','K','2026-04-19','12:37:09','kasir','PEMBELIAN UMUM','FB-260419-0004','4476555000','9618000','4466937000');
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-00018867','X-00018867','CC WEDDING MATA CM 14','GR','---','E2E','BELI','BELI001','1560000','2026-04-19','2.020','1','kasir','2026-04-19 12:37:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018867','X-00018867');
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-260419-0005','F322100849231','LIS','1','BELI','BELI001','E2E', 'X-00018867', 'CC WEDDING MATA CM 14','2.020','2.020','100.00','879000','1560000','772277','1175000','1','1560000','1560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' 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-260419-0005','2026-04-19','2026-04-19','12:37:48','LIS','---','2.020','1560000','1560000','1560000','1560000','1560000','kasir','2026-04-19 12:37:49','FB-260419-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0005','IMAM','GOLO JRAKAH PUHPELEM','','','','kasir','2026-04-19 12:37:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0020','K','2026-04-19','12:37:48','kasir','PEMBELIAN UMUM','FB-260419-0005','4466937000','1560000','4465377000');
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-00018868','X-00018868','GL MODEL FANCY VAR LT 8K','GR','---','F3E','BELI','BELI001','1502000','2026-04-19','1.880','1','kasir','2026-04-19 12:44:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018868','X-00018868');
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-260419-0006','F325040829131','LIS','1','BELI','BELI001','F3E', 'X-00018868', 'GL MODEL FANCY VAR LT 8K','2.010','1.880','100.00','1615000','1502000','798936','1175000','1','1502000','1502000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.880',berat_beli_asli=berat_beli_asli+'1.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.880',berat_akhir_asli=berat_akhir_asli+'1.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' 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-260419-0006','2026-04-19','2026-04-19','12:44:20','LIS','---','1.880','1502000','1502000','1502000','1502000','1502000','kasir','2026-04-19 12:44:21','FB-260419-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0006','OCA','SAMBITILENG','','','','kasir','2026-04-19 12:44:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0021','K','2026-04-19','12:44:20','kasir','PEMBELIAN UMUM','FB-260419-0006','4465377000','1502000','4463875000');
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 ('F326190129181','kasir','1',' MEE2 5K LG','TOKO','PM-E','E2E-ZCAH-339-0','CC OSROT ANAK BONEKA CAT MATA LG 8K ','','0.450','1','100.00','524000','0','0','15000','525000','0','5000','0','530000','LIS','00395294','E2E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAH-339-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E2E-ZCAH-339-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 ('F326190129181','2026-04-19','0.450','2026-04-19','13:29:19','PLG0028716','525000','525000','5000','530000','530000','kasir','2026-04-19 13:29:18','F32619012918');
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-04-19','F326190129181','2026-04-19','13:29:19','LIS','530000','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-260419-0022','D','2026-04-19','13:29:19','kasir','PENJUALAN','F326190129181','4463875000','530000','4464405000');
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-00018869','X-00018869','CC WEDDING POLOS CM 24 8K','GR','---','E1D','BELI','BELI001','1432000','2026-04-19','1.550','1','kasir','2026-04-19 14:03:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018869','X-00018869');
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-260419-0007','F325160250351','AAT','1','BELI','BELI001','E1D', 'X-00018869', 'CC WEDDING POLOS CM 24 8K','1.550','1.550','100.00','1558000','1432000','923871','1155000','1','1432000','1432000','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-04-19' 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-260419-0007','2026-04-19','2026-04-19','14:03:02','AAT','---','1.550','1432000','1432000','1432000','1432000','1432000','kasir','2026-04-19 14:03:02','FB-260419-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0007','IMAM','BITING JATISARI','','','085227073965','kasir','2026-04-19 14:03:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0023','K','2026-04-19','14:03:02','kasir','PEMBELIAN UMUM','FB-260419-0007','4464405000','1432000','4462973000');
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 ('F326190241341','kasir','1',' MDE2 X 16 ','TOKO','PM-E','E2D-ZAAF-139-0','CC X MODEL MATA 16 8K ','','0.870','1','100.00','996000','0','0','15000','996000','0','0','0','996000','AAT','00385590','E2D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-139-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-04-19' AND kode_barang='E2D-ZAAF-139-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 ('F326190241341','2026-04-19','0.870','2026-04-19','14:41:35','PLG0028717','996000','996000','0','996000','996000','kasir','2026-04-19 14:41:34','F32619024134');
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-04-19','F326190241341','2026-04-19','14:41:35','AAT','996000','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-260419-0024','D','2026-04-19','14:41:35','kasir','PENJUALAN','F326190241341','4462973000','996000','4463969000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='996000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190241341' 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 ('F326190241342','kasir',' 1',' MDE2 X HW ','TOKO','PM-E','E2D-YHXE-17-0','CC X MODEL MATA HW 15 8K ','','1.200','1','100.00','1374000','0','0','15000','1374000','0','0','0','1374000','AAT','00363804','E2D','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHXE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E2D-YHXE-17-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 ('F326190241342','2026-04-19','1.200','2026-04-19','14:41:35','PLG0028718','1374000','1374000','0','1374000','1374000','kasir','2026-04-19 14:41:34','F32619024134');
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-04-19','F326190241342','2026-04-19','14:41:35','AAT','1374000','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-260419-0025','D','2026-04-19','14:41:35','kasir','PENJUALAN','F326190241342','4463969000','1374000','4465343000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1374000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190241342' 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 ('F326190244111','kasir','1',' MEE1 CM 10','TOKO','PM-E','E1E-ZDXG-206-0','CC MODEL DAUN VAR CM 10 8K ','','0.730','1','100.00','850000','0','0','15000','850000','0','0','0','850000','SIN','00398384','E1E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='E1E-ZDXG-206-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 ('F326190244111','2026-04-19','0.730','2026-04-19','14:44:12','PLG0028719','850000','850000','0','850000','850000','kasir','2026-04-19 14:44:11','F32619024411');
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-04-19','F326190244111','2026-04-19','14:44:12','SIN','850000','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-260419-0026','D','2026-04-19','14:44:12','kasir','PENJUALAN','F326190244111','4465343000','850000','4466193000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='850000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190244111' 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 ('F326190244112','kasir',' 1',' MEE2 X LG ','TOKO','PM-E','E2E-YJXB-84-0','CC X MODEL MATA LG 10 8K ','','0.470','1','100.00','548000','0','0','15000','548000','0','0','0','548000','SIN','00371668','E2E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-84-0' 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-04-19' AND kode_barang='E2E-YJXB-84-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 ('F326190244112','2026-04-19','0.470','2026-04-19','14:44:12','PLG0028720','548000','548000','0','548000','548000','kasir','2026-04-19 14:44:11','F32619024411');
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-04-19','F326190244112','2026-04-19','14:44:12','SIN','548000','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-260419-0027','D','2026-04-19','14:44:12','kasir','PENJUALAN','F326190244112','4466193000','548000','4466741000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326190244112' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018870','X-00018870','GW COR 8K','GR','---','B1E','BELI','BELI001','450000','2026-04-19','0.740','1','kasir','2026-04-19 14:58:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00018870','X-00018870');
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-260419-0008','F321230921081','SIN','1','BELI','BELI001','B1E', 'X-00018870', 'GW COR 8K','0.930','0.740','100.00','387000','450000','608108','1175000','1','450000','450000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.740',berat_beli_asli=berat_beli_asli+'0.740',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.740',berat_akhir_asli=berat_akhir_asli+'0.740',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-19' 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-260419-0008','2026-04-19','2026-04-19','14:58:53','SIN','---','0.740','450000','450000','450000','450000','450000','kasir','2026-04-19 14:58:54','FB-260419-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0008','PRAPTI','PLOSO KISMANTORO','','','','kasir','2026-04-19 14:58:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0028','K','2026-04-19','14:58:53','kasir','PEMBELIAN UMUM','FB-260419-0008','4466741000','450000','4466291000');
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-00018871','X-00018871','CC MODEL MATA VAR LG 15 8K','GR','---','E2E','BELI','BELI001','725000','2026-04-19','1.020','1','kasir','2026-04-19 14:58:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018871','X-00018871');
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-260419-0009','F324080951332','SIN','2','BELI','BELI001','E2E', 'X-00018871', 'CC MODEL MATA VAR LG 15 8K','1.020','1.020','100.00','574000','725000','710784','1175000','1','725000','725000','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-04-19' 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-260419-0009','2026-04-19','2026-04-19','14:58:53','SIN','---','1.020','725000','725000','725000','725000','725000','kasir','2026-04-19 14:58:54','FB-260419-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260419-0009','ANIKA SARA','PLOSO KISMANTORO','','','','kasir','2026-04-19 14:58:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-19' 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-260419-0029','K','2026-04-19','14:58:53','kasir','PEMBELIAN UMUM','FB-260419-0009','4466291000','725000','4465566000');
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 ('F326190317341','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZCCX-298-0','GL X TIFF SLEP UB 8K ','','1.030','1','100.00','1200000','0','0','15000','1200000','0','0','0','1200000','SIN','00396952','F3E','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCCX-298-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-04-19' AND kode_barang='F3E-ZCCX-298-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 ('F326190317341','2026-04-19','1.030','2026-04-19','15:17:35','PLG0028721','1200000','1200000','0','1200000','1200000','kasir','2026-04-19 15:17:34','F32619031734');
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-04-19','F326190317341','2026-04-19','15:17:35','SIN','1200000','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-260419-0030','D','2026-04-19','15:17:35','kasir','PENJUALAN','F326190317341','4465566000','1200000','4466766000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260419-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260419-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190129181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190129181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190129181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190241341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190241341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190241341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190241342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190241342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190241342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190244111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190244111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190244111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190244112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190244112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190244112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190317341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190317341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190317341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190823361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190823362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190823363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190823363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190911571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190911571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190911571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190955431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190955431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190955431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191001231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191001231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191001231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191109541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191109541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191109541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191114491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191114491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191114491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191201121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191201121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191201121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191208271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191208272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208273' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191208273' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191208273';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191228411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191228411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191228411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191234141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191234141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191234141';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-19';
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-04-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-19' 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-260420-0001','D','2026-04-20','15:53:38','SYSTEM','SALDO AWAL','SALDO AWAL','0','4466766000','4466766000');
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-260420-0001','D','2026-04-20','15:53:38','BCA','SALDO AWAL','SALDO AWAL','0','708411000','708411000');
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-260420-0001','D','2026-04-20','15:53:38','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-260420-0001','D','2026-04-20','15:53:38','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-20';