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 ('F326220836361','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZFAG-68-0','KL X SANTA ARESO VAR SERUT UB 42 8K ','','3.060','1','100.00','3320000','0','0','15000','3320000','0','0','0','3320000','AAT','00408891','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAG-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFAG-68-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 ('F326220836361','2026-06-22','3.060','2026-06-22','08:36:37','PLG0029905','3320000','3320000','0','3320000','3320000','input','2026-06-22 08:36:36','F32622083636');
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-06-22','F326220836361','2026-06-22','08:36:37','AAT','3320000','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-260622-0002','D','2026-06-22','08:36:37','input','PENJUALAN','F326220836361','5819004000','3320000','5822324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220836361' 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 ('F326220836362','input',' 1',' TDE1 UB 13','TOKO','PT-E','E1TD-YHBG-18-T','CC MODEL HATI SLEP VAR UB 13 17K ','','1.050','1','100.00','2068000','0','0','15000','2070000','0','0','0','2070000','AAT','T0072610','E1TD','0','0','-','0','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBG-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1TD-YHBG-18-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 ('F326220836362','2026-06-22','1.050','2026-06-22','08:36:37','PLG0029906','2070000','2070000','0','2070000','2070000','input','2026-06-22 08:36:36','F32622083636');
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-06-22','F326220836362','2026-06-22','08:36:37','AAT','2070000','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-260622-0003','D','2026-06-22','08:36:37','input','PENJUALAN','F326220836362','5822324000','2070000','5824394000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2070000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220836362' 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 ('F326221013421','input','1',' MFD1 XX BG','TOKO','PM-D','D1G-YLBX-182-0','LT XX SLOBOK HURUF BALOK BG A 8K','GL M H','0.590','1','100.00','664000','0','0','15000','635000','0','30000','0','665000','SIN','00382062','D1G','0','0','-','1','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YLBX-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1G-YLBX-182-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 ('F326221013421','2026-06-22','0.590','2026-06-22','10:13:42','PLG0029907','635000','635000','30000','665000','665000','input','2026-06-22 10:13:42','F32622101342');
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-06-22','F326221013421','2026-06-22','10:13:42','SIN','665000','30000');
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-260622-0004','D','2026-06-22','10:13:42','input','PENJUALAN','F326221013421','5824394000','665000','5825059000');
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 ('F326221041381','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZEXI-158-0','GL X TIFF SLEP VAR HW 8K ','','1.330','1','100.00','1443000','0','0','15000','1443000','0','0','0','1443000','LIS','00402979','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXI-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZEXI-158-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 ('F326221041381','2026-06-22','1.330','2026-06-22','10:41:39','PLG0029908','1443000','1443000','0','1443000','1443000','input','2026-06-22 10:41:38','F32622104138');
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-06-22','F326221041381','2026-06-22','10:41:39','LIS','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) VALUES ('KM-260622-0005','D','2026-06-22','10:41:39','input','PENJUALAN','F326221041381','5825059000','1443000','5826502000');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260622-0001','1','F3E-ZEXA-9-0','1','1.930','TOKO','SBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-F';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3E-ZEXA-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='F3E-ZEXA-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260622-0001','2026-06-22','2026-06-22','10:41','1.930','admpindah','260622');
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 ('F326221105291','input','1',' MEB1 LG PE','TOKO','PM-B','B1E-YCAE-89-0','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.600','1','100.00','651000','0','0','15000','651000','0','0','0','651000','LIS','00343205','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YCAE-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-YCAE-89-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 ('F326221105291','2026-06-22','0.600','2026-06-22','11:05:30','PLG0029909','651000','651000','0','651000','651000','input','2026-06-22 11:05:29','F32622110529');
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-06-22','F326221105291','2026-06-22','11:05:30','LIS','651000','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-260622-0006','D','2026-06-22','11:05:30','input','PENJUALAN','F326221105291','5826502000','651000','5827153000');
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 ('F326221109351','input','1',' MEE1 LG 18','TOKO','PM-E','E1E-ZFAI-20-0','CC MODEL ISYANA SLEP LG 18 8K ','','0.630','1','100.00','690000','0','0','15000','683000','0','0','0','683000','SIN','00409325','E1E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAI-20-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 ('F326221109351','2026-06-22','0.630','2026-06-22','11:09:35','PLG0029910','683000','683000','0','683000','683000','input','2026-06-22 11:09:35','F32622110935');
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-06-22','F326221109351','2026-06-22','11:09:35','SIN','683000','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-260622-0007','D','2026-06-22','11:09:35','input','PENJUALAN','F326221109351','5827153000','683000','5827836000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221109351' 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 ('F326221109352','input',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-ZFXI-104-0','CC X LISTERING MATA HITAM CM 20 8K ','','0.770','1','100.00','835000','0','0','15000','835000','0','0','0','835000','SIN','00408171','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E2E-ZFXI-104-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 ('F326221109352','2026-06-22','0.770','2026-06-22','11:09:35','PLG0029911','835000','835000','0','835000','835000','input','2026-06-22 11:09:35','F32622110935');
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-06-22','F326221109352','2026-06-22','11:09:35','SIN','835000','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-260622-0008','D','2026-06-22','11:09:35','input','PENJUALAN','F326221109352','5827836000','835000','5828671000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='835000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221109352' 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 ('F326221128261','input','1',' MEF2 10K L','TOKO','PM-F','F2E-ZFXA-115-0','GL BONEKA ANAK CAT MATA LG 40 8K ','','2.060','1','100.00','2235000','0','0','15000','2235000','0','10000','0','2245000','LIS','00406283','F2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFXA-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F2E-ZFXA-115-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 ('F326221128261','2026-06-22','2.060','2026-06-22','11:28:26','PLG0029912','2235000','2235000','10000','2245000','2245000','input','2026-06-22 11:28:26','F32622112826');
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-06-22','F326221128261','2026-06-22','11:28:26','LIS','2245000','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-260622-0009','D','2026-06-22','11:28:26','input','PENJUALAN','F326221128261','5828671000','2245000','5830916000');
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 ('F326221200011','input','1',' MDA1 5K LG','TOKO','PM-A','A1D-ZEAE-213-0','AT ANAK KLIP BONEKA CAT MATA LG 8K ','','0.970','1','100.00','1033000','0','0','15000','1033000','0','5000','0','1038000','SIN','00403691','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEAE-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1D-ZEAE-213-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 ('F326221200011','2026-06-22','0.970','2026-06-22','12:00:01','PLG0029913','1033000','1033000','5000','1038000','1038000','input','2026-06-22 12:00:01','F32622120001');
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-06-22','F326221200011','2026-06-22','12:00:01','SIN','1038000','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-260622-0010','D','2026-06-22','12:00:01','input','PENJUALAN','F326221200011','5830916000','1038000','5831954000');
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-00019454','X-00019454','GL COR M 8K','GR','---','F2E','BELI','BELI001','5600000','2026-06-22','7.610','1','kasir','2026-06-22 12:04:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00019454','X-00019454');
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-260622-0001','00036123','AAT','1','BELI','BELI001','F2E', 'X-00019454', 'GL COR M 8K','7.610','7.610','100.00','3215000','5600000','735874','1095000','1','5600000','5600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.610',berat_beli_asli=berat_beli_asli+'7.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.610',berat_akhir_asli=berat_akhir_asli+'7.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260622-0001','2026-06-22','2026-06-22','12:04:20','AAT','---','7.610','5600000','5600000','5600000','5600000','5600000','kasir','2026-06-22 12:04:21','FB-260622-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0001','VINA','WATUBONANG BADEGAN','','','085608460696','kasir','2026-06-22 12:04:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0011','K','2026-06-22','12:04:20','kasir','PEMBELIAN UMUM','FB-260622-0001','5831954000','5600000','5826354000');
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-00019455','X-00019455','KL X SANTA MATA VAR UB 44 9K','GR','---','H3J','BELI','BELI001','4390000','2026-06-22','3.950','1','kasir','2026-06-22 12:12:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-H3J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H3J','X-00019455','X-00019455');
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-260622-0002','F326130935181','AAT','1','BELI','BELI001','H3J', 'X-00019455', 'KL X SANTA MATA VAR UB 44 9K','3.950','3.950','100.00','4820000','4390000','1111392','1195000','1','4390000','4390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.950',berat_beli_asli=berat_beli_asli+'3.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.950',berat_akhir_asli=berat_akhir_asli+'3.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H3J' 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-260622-0002','2026-06-22','2026-06-22','12:12:14','AAT','---','3.950','4390000','4390000','4390000','4390000','4390000','kasir','2026-06-22 12:12:14','FB-260622-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0002','SILVIANA','BITING BADEGAN','','','081914775355','kasir','2026-06-22 12:12:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0012','K','2026-06-22','12:12:14','kasir','PEMBELIAN UMUM','FB-260622-0002','5826354000','4390000','5821964000');
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-00019456','X-00019456','CC MODEL HATI SLEP VAR CM 12 8K','GR','---','E1D','BELI','BELI001','1157000','2026-06-22','1.170','1','kasir','2026-06-22 12:12:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019456','X-00019456');
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-260622-0003','F326130935182','AAT','2','BELI','BELI001','E1D', 'X-00019456', 'CC MODEL HATI SLEP VAR CM 12 8K','1.170','1.170','100.00','1288000','1157000','988889','1075000','1','1157000','1157000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.170',berat_beli_asli=berat_beli_asli+'1.170',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.170',berat_akhir_asli=berat_akhir_asli+'1.170',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' 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-260622-0003','2026-06-22','2026-06-22','12:12:14','AAT','---','1.170','1157000','1157000','1157000','1157000','1157000','kasir','2026-06-22 12:12:14','FB-260622-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0003','SILVIANA','BITING BADEGAN','','','081914775355','kasir','2026-06-22 12:12:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0013','K','2026-06-22','12:12:14','kasir','PEMBELIAN UMUM','FB-260622-0003','5821964000','1157000','5820807000');
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-00019457','X-00019457','CC X MODEL SLEP CAT HITAM BM 12 8K','GR','---','E1D','BELI','BELI001','1005000','2026-06-22','1.170','1','kasir','2026-06-22 12:12:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019457','X-00019457');
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-260622-0004','F325231012201','FIT','1','BELI','BELI001','E1D', 'X-00019457', 'CC X MODEL SLEP CAT HITAM BM 12 8K','1.170','1.170','100.00','1070000','1005000','858974','1075000','1','1005000','1005000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.170',berat_beli_asli=berat_beli_asli+'1.170',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.170',berat_akhir_asli=berat_akhir_asli+'1.170',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' 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-260622-0004','2026-06-22','2026-06-22','12:12:54','FIT','---','1.170','1005000','1005000','1005000','1005000','1005000','kasir','2026-06-22 12:12:55','FB-260622-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0004','DEVI','GELURAN SUKOMANGU','','','','kasir','2026-06-22 12:12:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0014','K','2026-06-22','12:12:54','kasir','PEMBELIAN UMUM','FB-260622-0004','5820807000','1005000','5819802000');
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-00019458','X-00019458','AT JERSEY MATA VAR UB','GR','---','A1F','BELI','BELI001','440000','2026-06-22','0.700','1','kasir','2026-06-22 12:14:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00019458','X-00019458');
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-260622-0005','F322301231501','FIT','1','BELI','BELI001','A1F', 'X-00019458', 'AT JERSEY MATA VAR UB','0.700','0.700','100.00','306000','440000','628571','1115000','1','440000','440000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260622-0005','2026-06-22','2026-06-22','12:14:34','FIT','---','0.700','440000','440000','440000','440000','440000','kasir','2026-06-22 12:14:35','FB-260622-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0005','AINI','KEPYAR','','','','kasir','2026-06-22 12:14:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0015','K','2026-06-22','12:14:34','kasir','PEMBELIAN UMUM','FB-260622-0005','5819802000','440000','5819362000');
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-00019459','X-00019459','CC X MODEL DAUN SLEP CM 20 8K','GR','---','E1D','BELI','BELI001','1000000','2026-06-22','1.000','1','kasir','2026-06-22 12:15:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019459','X-00019459');
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-260622-0006','F326130151261','AAT','1','BELI','BELI001','E1D', 'X-00019459', 'CC X MODEL DAUN SLEP CM 20 8K','1.000','1.000','100.00','1165000','1000000','1000000','1075000','1','1000000','1000000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' 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-260622-0006','2026-06-22','2026-06-22','12:15:04','AAT','---','1.000','1000000','1000000','1000000','1000000','1000000','kasir','2026-06-22 12:15:04','FB-260622-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0006','AYUK','DAWUNG KISMANTORO','','','','kasir','2026-06-22 12:15:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0016','K','2026-06-22','12:15:04','kasir','PEMBELIAN UMUM','FB-260622-0006','5819362000','1000000','5818362000');
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-00019460','X-00019460','LT COR T 8K','GR','---','D1F','BELI','BELI001','400000','2026-06-22','0.600','1','kasir','2026-06-22 12:16:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00019460','X-00019460');
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-260622-0007','F323031120172','AAT','1','BELI','BELI001','D1F', 'X-00019460', 'LT COR T 8K','0.670','0.600','100.00','328000','400000','666667','1115000','1','400000','400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260622-0007','2026-06-22','2026-06-22','12:16:14','AAT','---','0.600','400000','400000','400000','400000','400000','kasir','2026-06-22 12:16:14','FB-260622-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0007','ALMIRA','KEPUH PLOSO','','','','kasir','2026-06-22 12:16:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0017','K','2026-06-22','12:16:14','kasir','PEMBELIAN UMUM','FB-260622-0007','5818362000','400000','5817962000');
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 ('F326221227151','kasir','1',' MEH1 10K L','TOKO','PM-H','H1E-ZFXB-88-0','KL TIFF ANAK CAT MATA SLEP LG 34 8K ','','1.750','1','100.00','1899000','0','0','15000','1900000','0','10000','0','1910000','SIN','00406480','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXB-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFXB-88-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 ('F326221227151','2026-06-22','1.750','2026-06-22','12:27:15','PLG0029914','1900000','1900000','10000','1910000','1910000','kasir','2026-06-22 12:27:15','F32622122715');
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-06-22','F326221227151','2026-06-22','12:27:15','SIN','1910000','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-260622-0018','D','2026-06-22','12:27:15','kasir','PENJUALAN','F326221227151','5817962000','1910000','5819872000');
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 ('F326221229241','kasir','1',' MHB1H X CM','TOKO','PM-B','B1H-ZCXG-107-0','GW X TUSUK MATA CM 8K ','','0.270','1','100.00','309000','0','0','15000','310000','0','0','0','310000','AAT','00392543','B1H','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCXG-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1H-ZCXG-107-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 ('F326221229241','2026-06-22','0.270','2026-06-22','12:29:24','PLG0029915','310000','310000','0','310000','310000','kasir','2026-06-22 12:29:24','F32622122924');
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-06-22','F326221229241','2026-06-22','12:29:24','AAT','310000','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-260622-0019','D','2026-06-22','12:29:24','kasir','PENJUALAN','F326221229241','5819872000','310000','5820182000');
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 ('F326220101271','kasir','1',' MFD1 UB ','TOKO','PM-D','D1F-YCBG-257-0','LT SLOBOK BAMBU BUNGA KRAWANG UB 8K ','','0.690','1','100.00','762000','0','0','15000','763000','0','0','0','763000','FIT','00346324','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YCBG-257-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1F-YCBG-257-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 ('F326220101271','2026-06-22','0.690','2026-06-22','13:01:27','PLG0029916','763000','763000','0','763000','763000','kasir','2026-06-22 13:01:27','F32622010127');
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-06-22','F326220101271','2026-06-22','13:01:27','FIT','763000','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-260622-0020','D','2026-06-22','13:01:27','kasir','PENJUALAN','F326220101271','5820182000','763000','5820945000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221041381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221041381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221041381';
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 ('F326220147281','input','1',' MGPBG UB ','TOKO','PM-P','PBG-WAAH-48-0','GW WG ITALY MATA VAR UB ','','1.320','1','100.00','1485000','0','0','15000','1485000','0','0','0','1485000','SIN','00208920','PBG','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBG-WAAH-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='PBG-WAAH-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220147281','2026-06-22','1.320','2026-06-22','13:47:28','PLG0029917','1485000','1485000','0','1485000','1485000','input','2026-06-22 13:47:28','F32622014728');
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-06-22','F326220147281','2026-06-22','13:47:28','SIN','1485000','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-260622-0022','D','2026-06-22','13:47:28','input','PENJUALAN','F326220147281','5819502000','1485000','5820987000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1485000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220147281' 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 ('F326220147282','input',' 1',' MFPHF X KH','TOKO','PM-P','PHF-YLBC-115-0','KL X WG NORI KH 46 8K ','','2.000','1','100.00','2210000','0','0','15000','2210000','0','0','0','2210000','SIN','00382558','PHF','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHF-YLBC-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='PHF-YLBC-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220147282','2026-06-22','2.000','2026-06-22','13:47:28','PLG0029918','2210000','2210000','0','2210000','2210000','input','2026-06-22 13:47:28','F32622014728');
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-06-22','F326220147282','2026-06-22','13:47:28','SIN','2210000','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-260622-0023','D','2026-06-22','13:47:28','input','PENJUALAN','F326220147282','5820987000','2210000','5823197000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2210000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220147282' 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-00019461','X-00019461','KL X TIFF SPECTRA SLEP VAR UB 8K','GR','---','H1E','BELI','BELI001','1782000','2026-06-22','1.750','1','kasir','2026-06-22 14:09:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019461','X-00019461');
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-260622-0008','F326240150171','LIS','1','BELI','BELI001','H1E', 'X-00019461', 'KL X TIFF SPECTRA SLEP VAR UB 8K','1.750','1.750','100.00','1985000','1782000','1018286','1095000','1','1782000','1782000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' 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-260622-0008','2026-06-22','2026-06-22','14:09:48','LIS','---','1.750','1782000','1782000','1782000','1782000','1782000','kasir','2026-06-22 14:09:48','FB-260622-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0008','SRI SUYANTI','SUGIHAN BULUKERTO','','','081326996176','kasir','2026-06-22 14:09:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0024','K','2026-06-22','14:09:48','kasir','PEMBELIAN UMUM','FB-260622-0008','5823197000','1782000','5821415000');
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-00019462','X-00019462','CC X MODEL MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1070000','2026-06-22','1.070','1','kasir','2026-06-22 14:09:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019462','X-00019462');
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-260622-0009','F326190851201','LIS','2','BELI','BELI001','E2D', 'X-00019462', 'CC X MODEL MATA CM 18 8K','1.070','1.070','100.00','1242000','1070000','1000000','1075000','1','1070000','1070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260622-0009','2026-06-22','2026-06-22','14:09:48','LIS','---','1.070','1070000','1070000','1070000','1070000','1070000','kasir','2026-06-22 14:09:48','FB-260622-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0009','SRI SURYANTI','SEMBUNG BULUKERTO 5/1','','','','kasir','2026-06-22 14:09:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0025','K','2026-06-22','14:09:48','kasir','PEMBELIAN UMUM','FB-260622-0009','5821415000','1070000','5820345000');
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 ('F326220230021','kasir','1',' MEH1E UB 4','TOKO','PM-H','H1E-ZFXD-310-0','KL TIFF BOTEGA SLEP UB 40 8K ','','1.160','1','100.00','1259000','0','0','15000','1260000','0','0','0','1260000','FIT','00407189','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-310-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFXD-310-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 ('F326220230021','2026-06-22','1.160','2026-06-22','14:30:03','PLG0029919','1260000','1260000','0','1260000','1260000','kasir','2026-06-22 14:30:02','F32622023002');
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-06-22','F326220230021','2026-06-22','14:30:03','FIT','1260000','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-260622-0026','D','2026-06-22','14:30:03','kasir','PENJUALAN','F326220230021','5820345000','1260000','5821605000');
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 ('F326220237421','kasir','1',' MEE1 X CM ','TOKO','PM-E','E1E-ZEBH-341-0','CC XX MODEL SLEP CM 12 8K ','','0.500','1','100.00','542000','0','0','15000','528000','0','0','0','528000','SIN','00405559','E1E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-341-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-06-22' AND kode_barang='E1E-ZEBH-341-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 ('F326220237421','2026-06-22','0.500','2026-06-22','14:37:43','PLG0029920','528000','528000','0','528000','528000','kasir','2026-06-22 14:37:42','F32622023742');
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-06-22','F326220237421','2026-06-22','14:37:43','SIN','528000','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-260622-0027','D','2026-06-22','14:37:43','kasir','PENJUALAN','F326220237421','5821605000','528000','5822133000');
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 ('F326220239291','kasir','1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFAI-74-0','CC MODEL BANGKOK SLEP HT 14 8K ','','0.660','1','100.00','723000','0','0','15000','717000','0','0','0','717000','FIT','00409379','E1E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAI-74-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 ('F326220239291','2026-06-22','0.660','2026-06-22','14:39:29','PLG0029921','717000','717000','0','717000','717000','kasir','2026-06-22 14:39:29','F32622023929');
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-06-22','F326220239291','2026-06-22','14:39:29','FIT','717000','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-260622-0028','D','2026-06-22','14:39:29','kasir','PENJUALAN','F326220239291','5822133000','717000','5822850000');
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 ('F326220303321','kasir','1',' MEA1E X UB','TOKO','PM-A','A1E-ZEXI-109-0','AT X GYPSY MATA VAR UB 8K ','','0.800','1','100.00','868000','0','0','15000','868000','0','0','0','868000','SIN','00402930','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXI-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1E-ZEXI-109-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 ('F326220303321','2026-06-22','0.800','2026-06-22','15:03:33','PLG0029922','868000','868000','0','868000','868000','kasir','2026-06-22 15:03:32','F32622030332');
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-06-22','F326220303321','2026-06-22','15:03:33','SIN','868000','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-260622-0029','D','2026-06-22','15:03:33','kasir','PENJUALAN','F326220303321','5822850000','868000','5823718000');
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-00019463','X-00019463','AT ANAK BONEKA CAT VAR CM 8K','GR','---','A1E','BELI','BELI001','232000','2026-06-22','0.290','1','kasir','2026-06-22 15:05:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019463','X-00019463');
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-260622-0010','F326281149061','SIN','1','BELI','BELI001','A1E', 'X-00019463', 'AT ANAK BONEKA CAT VAR CM 8K','0.600','0.290','100.00','672000','232000','800000','1095000','1','232000','232000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.290',berat_beli_asli=berat_beli_asli+'0.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.290',berat_akhir_asli=berat_akhir_asli+'0.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260622-0010','2026-06-22','2026-06-22','15:05:34','SIN','---','0.290','232000','232000','232000','232000','232000','kasir','2026-06-22 15:05:34','FB-260622-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0010','KINAS','BANDAR PACITAN','','','','kasir','2026-06-22 15:05:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' 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-260622-0030','K','2026-06-22','15:05:34','kasir','PEMBELIAN UMUM','FB-260622-0010','5823718000','232000','5823486000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220101271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220101271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220101271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220147281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220147281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220147281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220147282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220147282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220147282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220230021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220230021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220230021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220237421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220237421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220237421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220239291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220239291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220239291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220303321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220303321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220303321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220836361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220836361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220836361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220836362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220836362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220836362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221013421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221013421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221013421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221105291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221105291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221105291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221109351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221109352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221128261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221128261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221128261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221200011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221200011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221200011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221227151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221227151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221227151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221229241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221229241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221229241';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-22';
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-06-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-22' 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-260623-0001','D','2026-06-23','15:17:57','SYSTEM','SALDO AWAL','SALDO AWAL','0','5823486000','5823486000');
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-260623-0001','D','2026-06-23','15:17:57','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
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-260623-0001','D','2026-06-23','15:17:57','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-260623-0001','D','2026-06-23','15:17:57','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-23';