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 ('F326240813211','input','1',' MDE1 X YS ','TOKO','PM-E','E1D-YJXB-39-0','CC X VELG KACA YS 10 8K ','','0.970','1','100.00','1043000','0','0','15000','1043000','0','0','0','1043000','LIS','00371623','E1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXB-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E1D-YJXB-39-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 ('F326240813211','2026-05-24','0.970','2026-05-24','08:13:22','PLG0029346','1043000','1043000','0','1043000','1043000','input','2026-05-24 08:13:21','F32624081321');
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-05-24','F326240813211','2026-05-24','08:13:22','LIS','1043000','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-260524-0002','D','2026-05-24','08:13:22','input','PENJUALAN','F326240813211','5151718000','1043000','5152761000');
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 ('F326240824441','input','1',' MEE2 X MJ ','TOKO','PM-E','E2D-ZCAD-162-0','CC X MODEL MATA MJ 18 8K','','0.730','1','100.00','785000','0','0','15000','800000','0','0','0','800000','AAT','00394290','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAD-162-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-05-24' AND kode_barang='E2D-ZCAD-162-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 ('F326240824441','2026-05-24','0.730','2026-05-24','08:24:45','PLG0029347','800000','800000','0','800000','800000','input','2026-05-24 08:24:44','F32624082444');
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-05-24','F326240824441','2026-05-24','08:24:45','AAT','800000','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-260524-0003','D','2026-05-24','08:24:45','input','PENJUALAN','F326240824441','5152761000','800000','5153561000');
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 ('F326240924311','input','1',' MDE2 CM 22','TOKO','PM-E','E2D-ZEXG-1-0','CC MODEL BUNGA MATA VAR CM 22 8K ','','1.290','1','100.00','1387000','0','0','15000','1388000','0','0','0','1388000','FIT','00402597','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.290',berat_jual_asli=berat_jual_asli+'1.290',stock_jual='1',berat_akhir=berat_akhir-'1.290',berat_akhir_asli=berat_akhir_asli-'1.290',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E2D-ZEXG-1-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 ('F326240924311','2026-05-24','1.290','2026-05-24','09:24:31','PLG0029348','1388000','1388000','0','1388000','1388000','input','2026-05-24 09:24:31','F32624092431');
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-05-24','F326240924311','2026-05-24','09:24:31','FIT','1388000','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-260524-0004','D','2026-05-24','09:24:31','input','PENJUALAN','F326240924311','5153561000','1388000','5154949000');
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 ('F326240935561','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDCX-7-0','GL MODEL FLIK BOLA ARESO VAR HW 8K ','','3.350','1','100.00','3668000','0','0','15000','3668000','0','0','0','3668000','AAT','00401866','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='F3E-ZDCX-7-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 ('F326240935561','2026-05-24','3.350','2026-05-24','09:35:56','PLG0029349','3668000','3668000','0','3668000','3668000','input','2026-05-24 09:35:56','F32624093556');
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-05-24','F326240935561','2026-05-24','09:35:56','AAT','3668000','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-260524-0005','D','2026-05-24','09:35:56','input','PENJUALAN','F326240935561','5154949000','3668000','5158617000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3668000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240935561' 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 ('F326240935562','input',' 1',' MJH2 X KH ','TOKO','PM-H','H2J-ZEXI-184-0','KL X SIEM COBRA KH 42 9K','','1.250','1','100.00','1494000','0','0','15000','1495000','0','0','0','1495000','AAT','00403005','H2J','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZEXI-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='H2J-ZEXI-184-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 ('F326240935562','2026-05-24','1.250','2026-05-24','09:35:56','PLG0029350','1495000','1495000','0','1495000','1495000','input','2026-05-24 09:35:56','F32624093556');
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-05-24','F326240935562','2026-05-24','09:35:56','AAT','1495000','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-260524-0006','D','2026-05-24','09:35:56','input','PENJUALAN','F326240935562','5158617000','1495000','5160112000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240935562' 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 ('F326240935563','input',' 1',' MEE2 X HW ','TOKO','PM-E','E1E-ZDAH-193-0','CC X PIPA MATA HW 18 8K ','','0.500','1','100.00','547000','0','0','15000','547000','0','0','0','547000','AAT','00399894','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDAH-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E1E-ZDAH-193-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 ('F326240935563','2026-05-24','0.500','2026-05-24','09:35:56','PLG0029351','547000','547000','0','547000','547000','input','2026-05-24 09:35:56','F32624093556');
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-05-24','F326240935563','2026-05-24','09:35:56','AAT','547000','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-260524-0007','D','2026-05-24','09:35:56','input','PENJUALAN','F326240935563','5160112000','547000','5160659000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='547000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240935563' 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 ('F326240941131','input','1',' MDE2 X OR ','TOKO','PM-E','E2D-ZCAE-198-0','CC X MODEL MATA OR 20 8K ','','2.270','1','100.00','2440000','0','0','15000','2440000','0','0','0','2440000','SIN','00394605','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAE-198-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E2D-ZCAE-198-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 ('F326240941131','2026-05-24','2.270','2026-05-24','09:41:13','PLG0029352','2440000','2440000','0','2440000','2440000','input','2026-05-24 09:41:13','F32624094113');
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-05-24','F326240941131','2026-05-24','09:41:13','SIN','2440000','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-260524-0008','D','2026-05-24','09:41:13','input','PENJUALAN','F326240941131','5160659000','2440000','5163099000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2440000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240941131' 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 ('F326240941132','input',' 1',' MDA1D X M4','TOKO','PM-A','A1D-ZDXD-222-0','AT X BANGKOK KLIP SLEP M4 8K ','','1.100','1','100.00','1182000','0','0','15000','1183000','0','0','0','1183000','SIN','00397922','A1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDXD-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='A1D-ZDXD-222-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 ('F326240941132','2026-05-24','1.100','2026-05-24','09:41:13','PLG0029353','1183000','1183000','0','1183000','1183000','input','2026-05-24 09:41:13','F32624094113');
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-05-24','F326240941132','2026-05-24','09:41:13','SIN','1183000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260524-0009','D','2026-05-24','09:41:13','input','PENJUALAN','F326240941132','5163099000','1183000','5164282000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1183000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240941132' 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 ('F326241022071','input','1',' TDE2 X LG ','TOKO','PT-E','E2TD-YIXE-16-T','CC X MODEL METRO MATA VAR LG 18 17K ','','1.000','1','100.00','1980000','0','0','15000','1980000','0','0','0','1980000','SIN','T0072986','E2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXE-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E2TD-YIXE-16-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 ('F326241022071','2026-05-24','1.000','2026-05-24','10:22:07','PLG0029354','1980000','1980000','0','1980000','1980000','input','2026-05-24 10:22:07','F32624102207');
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-05-24','F326241022071','2026-05-24','10:22:07','SIN','1980000','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-260524-0010','D','2026-05-24','10:22:07','input','PENJUALAN','F326241022071','5164282000','1980000','5166262000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241022071' 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 ('F326241022072','input',' 1',' TDE1 X 14 ','TOKO','PT-E','E1TD-ZEBA-12-T','CC X MODEL SLEP 14 17K ','','1.150','1','100.00','2277000','0','0','15000','2278000','0','0','0','2278000','SIN','T0079719','E1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZEBA-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E1TD-ZEBA-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 ('F326241022072','2026-05-24','1.150','2026-05-24','10:22:07','PLG0029355','2278000','2278000','0','2278000','2278000','input','2026-05-24 10:22:07','F32624102207');
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-05-24','F326241022072','2026-05-24','10:22:07','SIN','2278000','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-260524-0011','D','2026-05-24','10:22:07','input','PENJUALAN','F326241022072','5166262000','2278000','5168540000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2278000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241022072' 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 ('F326241030241','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-YLBI-51-0','GW X MODEL SLEP LG PE 8K ','','0.480','1','100.00','526000','0','0','15000','526000','0','0','0','526000','LIS','00383203','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBI-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='B1E-YLBI-51-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326241030241','2026-05-24','0.480','2026-05-24','10:30:24','PLG0029356','526000','526000','0','526000','526000','input','2026-05-24 10:30:24','F32624103024');
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-05-24','F326241030241','2026-05-24','10:30:24','LIS','526000','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-260524-0012','D','2026-05-24','10:30:24','input','PENJUALAN','F326241030241','5168540000','526000','5169066000');
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 ('F326241036271','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDXD-265-0','GL RANTE DAUN VAR HW 8K ','','2.710','1','100.00','2967000','0','0','15000','2968000','0','0','0','2968000','AAT','00397965','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXD-265-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='F3E-ZDXD-265-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 ('F326241036271','2026-05-24','2.710','2026-05-24','10:36:28','PLG0029357','2968000','2968000','0','2968000','2968000','input','2026-05-24 10:36:27','F32624103627');
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-05-24','F326241036271','2026-05-24','10:36:28','AAT','2968000','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-260524-0013','D','2026-05-24','10:36:28','input','PENJUALAN','F326241036271','5169066000','2968000','5172034000');
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 ('F326241038461','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-ZDAX-44-0','KL X SANTA KH 44 9K ','','2.960','1','100.00','3478000','0','0','15000','3478000','0','0','0','3478000','SIN','00398814','H2I','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZDAX-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='H2I-ZDAX-44-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 ('F326241038461','2026-05-24','2.960','2026-05-24','10:38:47','PLG0029358','3478000','3478000','0','3478000','3478000','input','2026-05-24 10:38:46','F32624103846');
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-05-24','F326241038461','2026-05-24','10:38:47','SIN','3478000','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-260524-0014','D','2026-05-24','10:38:47','input','PENJUALAN','F326241038461','5172034000','3478000','5175512000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3478000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241038461' 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 ('F326241038462','input',' 1',' MDD2D X UB','TOKO','PM-D','D2D-YIBC-247-0','LT X MODEL MATA UB 8K ','','1.070','1','100.00','1150000','0','0','15000','1150000','0','0','0','1150000','SIN','00370218','D2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YIBC-247-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='D2D-YIBC-247-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 ('F326241038462','2026-05-24','1.070','2026-05-24','10:38:47','PLG0029359','1150000','1150000','0','1150000','1150000','input','2026-05-24 10:38:46','F32624103846');
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-05-24','F326241038462','2026-05-24','10:38:47','SIN','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,status_valid) VALUES ('KM-260524-0015','D','2026-05-24','10:38:47','input','PENJUALAN','F326241038462','5175512000','1150000','5176662000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1150000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241038462' 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 ('F326241040201','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZDBX-89-0','GL X TIFF AUREL MATA HW 8K ','','1.680','1','100.00','1840000','0','0','15000','1840000','0','0','0','1840000','FIT','00400024','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='F3E-ZDBX-89-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 ('F326241040201','2026-05-24','1.680','2026-05-24','10:40:20','PLG0029360','1840000','1840000','0','1840000','1840000','input','2026-05-24 10:40:20','F32624104020');
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-05-24','F326241040201','2026-05-24','10:40:20','FIT','1840000','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-260524-0016','D','2026-05-24','10:40:20','input','PENJUALAN','F326241040201','5176662000','1840000','5178502000');
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 ('F326241120501','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZDBA-111-0','CC X EROPA ANAK MATA LG 8K ','','1.100','1','100.00','1182000','0','0','15000','1183000','0','5000','0','1188000','FIT','00400394','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBA-111-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E2D-ZDBA-111-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 ('F326241120501','2026-05-24','1.100','2026-05-24','11:20:50','PLG0029361','1183000','1183000','5000','1188000','1188000','input','2026-05-24 11:20:50','F32624112050');
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-05-24','F326241120501','2026-05-24','11:20:50','FIT','1188000','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-260524-0017','D','2026-05-24','11:20:50','input','PENJUALAN','F326241120501','5178502000','1188000','5179690000');
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 ('F326241124501','input','1',' MEA1 5K LG','TOKO','PM-A','A1E-YJAH-56-0','AT BONEKA ANAK MATA CAT LG 8K ','','0.530','1','100.00','580000','0','0','15000','580000','0','5000','0','585000','SIN','00373751','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJAH-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='A1E-YJAH-56-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 ('F326241124501','2026-05-24','0.530','2026-05-24','11:24:51','PLG0029362','580000','580000','5000','585000','585000','input','2026-05-24 11:24:50','F32624112450');
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-05-24','F326241124501','2026-05-24','11:24:51','SIN','585000','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-260524-0018','D','2026-05-24','11:24:51','input','PENJUALAN','F326241124501','5179690000','585000','5180275000');
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 ('F326241143521','input','1',' MEF2E X UB','TOKO','PM-F','F2E-ZCAD-65-0','GL X PIPA ANAK MATA UB 42 8K ','','1.910','1','100.00','2091000','0','0','15000','2091000','0','0','0','2091000','SIN','00394193','F2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCAD-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='F2E-ZCAD-65-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 ('F326241143521','2026-05-24','1.910','2026-05-24','11:43:52','PLG0029363','2091000','2091000','0','2091000','2091000','input','2026-05-24 11:43:52','F32624114352');
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-05-24','F326241143521','2026-05-24','11:43:52','SIN','2091000','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-260524-0019','D','2026-05-24','11:43:52','input','PENJUALAN','F326241143521','5180275000','2091000','5182366000');
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 ('F326241149521','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZEXI-258-0','CC X MODEL MATA LG 8 8K ','','0.530','1','100.00','580000','0','0','15000','580000','0','0','0','580000','SIN','00403079','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEXI-258-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='E2E-ZEXI-258-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 ('F326241149521','2026-05-24','0.530','2026-05-24','11:49:53','PLG0029364','580000','580000','0','580000','580000','input','2026-05-24 11:49:52','F32624114952');
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-05-24','F326241149521','2026-05-24','11:49:53','SIN','580000','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-260524-0020','D','2026-05-24','11:49:53','input','PENJUALAN','F326241149521','5182366000','580000','5182946000');
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-00019208','X-00019208','LT X MODEL SPECTRA YT 8K','GR','---','D1G','BELI','BELI001','388000','2026-05-24','0.390','1','kasir','2026-05-24 12:20:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00019208','X-00019208');
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-260524-0001','F326201117411','LIS','1','BELI','BELI001','D1G', 'X-00019208', 'LT X MODEL SPECTRA YT 8K','0.390','0.390','100.00','475000','388000','994872','1135000','1','388000','388000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.390',berat_beli_asli=berat_beli_asli+'0.390',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.390',berat_akhir_asli=berat_akhir_asli+'0.390',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260524-0001','2026-05-24','2026-05-24','12:20:09','LIS','---','0.390','388000','388000','388000','388000','388000','kasir','2026-05-24 12:20:10','FB-260524-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260524-0001','FADILA','SIGERENG BITING','','','','kasir','2026-05-24 12:20:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-24' 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-260524-0021','K','2026-05-24','12:20:09','kasir','PEMBELIAN UMUM','FB-260524-0001','5182946000','388000','5182558000');
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-00019209','X-00019209','GL X TIFF HATI VAR YT 8K','GR','---','F3E','BELI','BELI001','1117000','2026-05-24','1.150','1','kasir','2026-05-24 12:20:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019209','X-00019209');
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-260524-0002','F326040153561','LIS','1','BELI','BELI001','F3E', 'X-00019209', 'GL X TIFF HATI VAR YT 8K','1.150','1.150','100.00','1335000','1117000','971304','1105000','1','1117000','1117000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-24' 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-260524-0002','2026-05-24','2026-05-24','12:20:45','LIS','---','1.150','1117000','1117000','1117000','1117000','1117000','kasir','2026-05-24 12:20:46','FB-260524-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260524-0002','ANA','SLOGOHIMO','','','082257627291','kasir','2026-05-24 12:20:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-24' 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-260524-0022','K','2026-05-24','12:20:45','kasir','PEMBELIAN UMUM','FB-260524-0002','5182558000','1117000','5181441000');
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 ('F326240148141','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-ZEXI-106-0','AT X GYPSY ANAK SLEP LG 8K ','','0.410','1','100.00','449000','0','0','15000','450000','0','0','0','450000','SIN','00402927','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXI-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='A1E-ZEXI-106-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 ('F326240148141','2026-05-24','0.410','2026-05-24','13:48:15','PLG0029365','450000','450000','0','450000','450000','kasir','2026-05-24 13:48:14','F32624014814');
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-05-24','F326240148141','2026-05-24','13:48:15','SIN','450000','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-260524-0023','D','2026-05-24','13:48:15','kasir','PENJUALAN','F326240148141','5181441000','450000','5181891000');
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-00019210','X-00019210','AT BABY TIDIK DG 8K','GR','---','A1H','BELI','BELI001','85000','2026-05-24','0.120','1','kasir','2026-05-24 14:07:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00019210','X-00019210');
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-260524-0003','F325250953281','SIN','1','BELI','BELI001','A1H', 'X-00019210', 'AT BABY TIDIK DG 8K','0.250','0.120','100.00','221000','85000','708333','1155000','1','85000','85000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.120',berat_beli_asli=berat_beli_asli+'0.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.120',berat_akhir_asli=berat_akhir_asli+'0.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' 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-260524-0003','2026-05-24','2026-05-24','14:07:17','SIN','---','0.120','85000','85000','85000','85000','85000','kasir','2026-05-24 14:07:18','FB-260524-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260524-0003','SITI HALIMAH','BUGELAN','','','','kasir','2026-05-24 14:07:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-24' 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-260524-0024','K','2026-05-24','14:07:17','kasir','PEMBELIAN UMUM','FB-260524-0003','5181891000','85000','5181806000');
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 ('F326240242211','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZEBX-222-0','CC WEDDING MATA CM 14 8K ','','1.550','1','100.00','1666000','0','0','15000','1667000','0','10000','0','1677000','FIT','00404500','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBX-222-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-05-24' AND kode_barang='E2D-ZEBX-222-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 ('F326240242211','2026-05-24','1.550','2026-05-24','14:42:22','PLG0029366','1667000','1667000','10000','1677000','1677000','kasir','2026-05-24 14:42:21','F32624024221');
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-05-24','F326240242211','2026-05-24','14:42:22','FIT','1677000','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-260524-0025','D','2026-05-24','14:42:22','kasir','PENJUALAN','F326240242211','5181806000','1677000','5183483000');
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 ('F326240249121','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-YJBX-40-0','AT GYPSY ANAK MRICAN SLEP LG 8K ','','0.520','1','100.00','569000','0','0','15000','570000','0','0','0','570000','SIN','00373823','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-05-24' AND kode_barang='A1E-YJBX-40-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 ('F326240249121','2026-05-24','0.520','2026-05-24','14:49:13','PLG0029367','570000','570000','0','570000','570000','kasir','2026-05-24 14:49:12','F32624024912');
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-05-24','F326240249121','2026-05-24','14:49:13','SIN','570000','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-260524-0026','D','2026-05-24','14:49:13','kasir','PENJUALAN','F326240249121','5183483000','570000','5184053000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240148141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240148141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240148141';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260524-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260524-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260524-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260524-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260524-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260524-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240242211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240242211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240242211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240249121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240249121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240249121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240813211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240813211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240813211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240824441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240824441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240824441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240924311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240924311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240924311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240935561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240935562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240935563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240935563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240941131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240941131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240941131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240941132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240941132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240941132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241022071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241022071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241022071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241022072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241022072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241022072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241030241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241030241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241030241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241036271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241036271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241036271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241038461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241038462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241040201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241040201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241040201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241120501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241120501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241120501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241124501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241124501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241124501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241143521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241143521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241143521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241149521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241149521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241149521';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-24';
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-05-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-24' 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-260525-0001','D','2026-05-25','15:16:00','SYSTEM','SALDO AWAL','SALDO AWAL','0','5183603000','5183603000');
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-260525-0001','D','2026-05-25','15:16:00','BCA','SALDO AWAL','SALDO AWAL','0','712562000','712562000');
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-260525-0001','D','2026-05-25','15:16:00','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260525-0001','D','2026-05-25','15:16:00','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-25';