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 ('F326220830381','input','1',' MCB0 DG ','TOKO','PM-B','B0C-ZACA-186-0','GW MRICAN POLOS DG 8K ','','0.500','1','100.00','607000','0','0','15000','608000','0','0','0','608000','SIN','00387645','B0C','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-ZACA-186-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-02-22' AND kode_barang='B0C-ZACA-186-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 ('F326220830381','2026-02-22','0.500','2026-02-22','08:30:38','PLG0027268','608000','608000','0','608000','608000','input','2026-02-22 08:30:38','F32622083038');
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-02-22','F326220830381','2026-02-22','08:30:38','SIN','608000','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-260222-0002','D','2026-02-22','08:30:38','input','PENJUALAN','F326220830381','2513328000','608000','2513936000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='608000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220830381' 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 ('F326220830382','input',' 1',' MEE1 X BW ','TOKO','PM-E','E1E-YLBX-196-0','CC X BANGKOK SLEP BW 14 8K ','','0.580','1','100.00','728000','0','0','15000','710000','0','0','0','710000','SIN','00382076','E1E','0','0','-','1','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E1E-YLBX-196-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 ('F326220830382','2026-02-22','0.580','2026-02-22','08:30:38','PLG0027269','710000','710000','0','710000','710000','input','2026-02-22 08:30:38','F32622083038');
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-02-22','F326220830382','2026-02-22','08:30:38','SIN','710000','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-260222-0003','D','2026-02-22','08:30:38','input','PENJUALAN','F326220830382','2513936000','710000','2514646000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='710000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220830382' 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 ('F326220947001','input','1',' MDE2 CM 20','TOKO','PM-E','E2D-ZAAI-7-0','CC MODEL MATA CM 20 8K ','','1.010','1','100.00','1247000','0','0','15000','1248000','0','0','0','1248000','FIT','00385945','E2D','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAI-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E2D-ZAAI-7-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 ('F326220947001','2026-02-22','1.010','2026-02-22','09:47:00','PLG0027270','1248000','1248000','0','1248000','1248000','input','2026-02-22 09:47:00','F32622094700');
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-02-22','F326220947001','2026-02-22','09:47:00','FIT','1248000','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-260222-0004','D','2026-02-22','09:47:00','input','PENJUALAN','F326220947001','2514646000','1248000','2515894000');
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 ('F326221006061','input','1',' MFB1F X LG','TOKO','PM-B','B1F-YFAI-128-0','GW X BONEKA TAUGE ANAK CAT LG 8K ','','0.560','1','100.00','714000','0','0','15000','715000','0','0','0','715000','SIN','00357999','B1F','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YFAI-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='B1F-YFAI-128-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 ('F326221006061','2026-02-22','0.560','2026-02-22','10:06:07','PLG0027271','715000','715000','0','715000','715000','input','2026-02-22 10:06:06','F32622100606');
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-02-22','F326221006061','2026-02-22','10:06:07','SIN','715000','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-260222-0005','D','2026-02-22','10:06:07','input','PENJUALAN','F326221006061','2515894000','715000','2516609000');
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 ('F326221024201','kasir','1',' MEF1 10K U','TOKO','PM-F','F1E-YLAB-274-0','GL PIPA ANAK CAT SLEP UB 40 8K ','','1.610','1','100.00','2021000','0','0','15000','2021000','0','10000','0','2031000','FIT','00380818','F1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAB-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F1E-YLAB-274-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 ('F326221024201','2026-02-22','1.610','2026-02-22','10:24:20','PLG0027272','2021000','2021000','10000','2031000','2031000','kasir','2026-02-22 10:24:20','F32622102420');
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-02-22','F326221024201','2026-02-22','10:24:20','FIT','2031000','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-260222-0006','D','2026-02-22','10:24:20','kasir','PENJUALAN','F326221024201','2516609000','2031000','2518640000');
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 ('F326221036261','kasir','1',' MEB1 X HK ','TOKO','PM-B','B1E-ZABH-34-0','GW X MODEL TAUGE MATA HK 8K ','','0.400','1','100.00','502000','0','0','15000','503000','0','0','0','503000','AAT','00386892','B1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZABH-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='B1E-ZABH-34-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 ('F326221036261','2026-02-22','0.400','2026-02-22','10:36:27','PLG0027273','503000','503000','0','503000','503000','kasir','2026-02-22 10:36:26','F32622103626');
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-02-22','F326221036261','2026-02-22','10:36:27','AAT','503000','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-260222-0007','D','2026-02-22','10:36:27','kasir','PENJUALAN','F326221036261','2518640000','503000','2519143000');
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 ('F326221053151','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-YKAA-267-0','CC X WEDDING POLOS CM 18 8K ','','1.420','1','100.00','1754000','0','0','15000','1755000','0','0','0','1755000','AAT','00377233','E1D','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAA-267-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E1D-YKAA-267-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 ('F326221053151','2026-02-22','1.420','2026-02-22','10:53:16','PLG0027274','1755000','1755000','0','1755000','1755000','kasir','2026-02-22 10:53:15','F32622105315');
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-02-22','F326221053151','2026-02-22','10:53:16','AAT','1755000','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-260222-0008','D','2026-02-22','10:53:16','kasir','PENJUALAN','F326221053151','2519143000','1755000','2520898000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1755000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221053151' 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 ('F326221053152','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZBAF-287-0','CC WEDDING MATA CM 12 8K ','','1.510','1','100.00','1865000','0','0','15000','1865000','0','10000','0','1875000','AAT','00390259','E2D','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBAF-287-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E2D-ZBAF-287-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 ('F326221053152','2026-02-22','1.510','2026-02-22','10:53:16','PLG0027275','1865000','1865000','10000','1875000','1875000','kasir','2026-02-22 10:53:15','F32622105315');
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-02-22','F326221053152','2026-02-22','10:53:16','AAT','1875000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260222-0009','D','2026-02-22','10:53:16','kasir','PENJUALAN','F326221053152','2520898000','1875000','2522773000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221053152' 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 ('F326221057541','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-YKAA-88-0','GL X OVAL C SLEP YT 60 8K ','','3.600','1','100.00','4518000','0','0','15000','4518000','0','0','0','4518000','SIN','00377054','F1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKAA-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F1E-YKAA-88-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 ('F326221057541','2026-02-22','3.600','2026-02-22','10:57:55','PLG0027276','4518000','4518000','0','4518000','4518000','kasir','2026-02-22 10:57:54','F32622105754');
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-02-22','F326221057541','2026-02-22','10:57:55','SIN','4518000','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-260222-0010','D','2026-02-22','10:57:55','kasir','PENJUALAN','F326221057541','2522773000','4518000','2527291000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4518000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221057541' 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 ('F326221057542','kasir',' 1',' MEF1 X YT ','TOKO','PM-F','F1E-XEAG-77-0','GL X OVAL C SLEP YT 60 8K ','','3.250','1','100.00','4079000','0','0','15000','4079000','0','0','0','4079000','SIN','00298269','F1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XEAG-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F1E-XEAG-77-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 ('F326221057542','2026-02-22','3.250','2026-02-22','10:57:55','PLG0027277','4079000','4079000','0','4079000','4079000','kasir','2026-02-22 10:57:54','F32622105754');
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-02-22','F326221057542','2026-02-22','10:57:55','SIN','4079000','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-260222-0011','D','2026-02-22','10:57:55','kasir','PENJUALAN','F326221057542','2527291000','4079000','2531370000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4079000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221057542' 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 ('F326221057543','kasir',' 1',' MDE1 X HW ','TOKO','PM-E','E1D-ZBXF-150-0','CC X MODEL SLEP HW 17 8K ','','1.780','1','100.00','2198000','0','0','15000','2198000','0','0','0','2198000','SIN','00388732','E1D','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXF-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E1D-ZBXF-150-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 ('F326221057543','2026-02-22','1.780','2026-02-22','10:57:55','PLG0027278','2198000','2198000','0','2198000','2198000','kasir','2026-02-22 10:57:54','F32622105754');
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-02-22','F326221057543','2026-02-22','10:57:55','SIN','2198000','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-260222-0012','D','2026-02-22','10:57:55','kasir','PENJUALAN','F326221057543','2531370000','2198000','2533568000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2198000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221057543' 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 ('F326221057544','kasir',' 1',' MEF3 HW ','TOKO','PM-F','F3E-ZACX-222-0','GL MODEL FLIK VAR HW 8K ','','1.820','1','100.00','2284000','0','0','15000','2285000','0','0','0','2285000','SIN','00387523','F3E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZACX-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F3E-ZACX-222-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 ('F326221057544','2026-02-22','1.820','2026-02-22','10:57:55','PLG0027279','2285000','2285000','0','2285000','2285000','kasir','2026-02-22 10:57:54','F32622105754');
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-02-22','F326221057544','2026-02-22','10:57:55','SIN','2285000','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-260222-0013','D','2026-02-22','10:57:55','kasir','PENJUALAN','F326221057544','2533568000','2285000','2535853000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2285000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326221057544' 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 ('F326221059551','kasir','1',' MJH2 UB 42','TOKO','PM-H','H2J-WEXA-151-0','KL MILANO UB 42CM ','','10.050','1','100.00','13618000','0','0','15000','13618000','0','0','0','13618000','FIT','00229421','H2J','0','0','-','0','1355000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-WEXA-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.050',berat_jual_asli=berat_jual_asli+'10.050',stock_jual='1',berat_akhir=berat_akhir-'10.050',berat_akhir_asli=berat_akhir_asli-'10.050',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='H2J-WEXA-151-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 ('F326221059551','2026-02-22','10.050','2026-02-22','10:59:55','PLG0027280','13618000','13618000','0','13618000','13618000','kasir','2026-02-22 10:59:55','F32622105955');
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-02-22','F326221059551','2026-02-22','10:59:55','FIT','13618000','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-260222-0014','D','2026-02-22','10:59:55','kasir','PENJUALAN','F326221059551','2535853000','13618000','2549471000');
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 ('F326221105521','kasir','1',' MEF3 15K U','TOKO','PM-F','F3E-YCBA-212-0','GL ANAK FANCY BONEKA CAT VAR UB 8K ','','1.920','1','100.00','2410000','0','0','15000','2410000','0','15000','0','2425000','FIT','00344589','F3E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCBA-212-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F3E-YCBA-212-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 ('F326221105521','2026-02-22','1.920','2026-02-22','11:05:52','PLG0027281','2410000','2410000','15000','2425000','2425000','kasir','2026-02-22 11:05:52','F32622110552');
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-02-22','F326221105521','2026-02-22','11:05:52','FIT','2425000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260222-0015','D','2026-02-22','11:05:52','kasir','PENJUALAN','F326221105521','2549471000','2425000','2551896000');
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 ('F326221108011','kasir','1',' TFB1 7K CM','TOKO','PT-B','B1TF-YGXD-14-T','GW TOGE BONEKA CAT VAR CM 17K ','','0.680','1','100.00','1554000','0','0','15000','1553000','0','7000','0','1560000','AAT','T0070764','B1TF','0','0','-','1','2285000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YGXD-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='B1TF-YGXD-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326221108011','2026-02-22','0.680','2026-02-22','11:08:02','PLG0027282','1553000','1553000','7000','1560000','1560000','kasir','2026-02-22 11:08:01','F32622110801');
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-02-22','F326221108011','2026-02-22','11:08:02','AAT','1560000','7000');
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-260222-0016','D','2026-02-22','11:08:02','kasir','PENJUALAN','F326221108011','2551896000','1560000','2553456000');
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 ('F326221109461','kasir','1',' MEF2 X PM ','TOKO','PM-F','F2E-YGAH-154-0','GL X PIPA MATA PM 58 8K ','','6.980','1','100.00','8760000','0','0','15000','8760000','0','0','0','8760000','SIN','00361562','F2E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YGAH-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.980',berat_jual_asli=berat_jual_asli+'6.980',stock_jual='1',berat_akhir=berat_akhir-'6.980',berat_akhir_asli=berat_akhir_asli-'6.980',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F2E-YGAH-154-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 ('F326221109461','2026-02-22','6.980','2026-02-22','11:09:46','PLG0027283','8760000','8760000','0','8760000','8760000','kasir','2026-02-22 11:09:46','F32622110946');
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-02-22','F326221109461','2026-02-22','11:09:46','SIN','8760000','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-260222-0017','D','2026-02-22','11:09:46','kasir','PENJUALAN','F326221109461','2553456000','8760000','2562216000');
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 ('F326221123141','kasir','1',' MEB1 5K HW','TOKO','PM-B','B1E-ZBAI-295-0','GW TRIXIE PANJANG BUNGA CAT HW 8K ','','0.560','1','100.00','703000','0','0','15000','703000','0','5000','0','708000','SIN','00390967','B1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAI-295-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='B1E-ZBAI-295-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 ('F326221123141','2026-02-22','0.560','2026-02-22','11:23:15','PLG0027284','703000','703000','5000','708000','708000','kasir','2026-02-22 11:23:14','F32622112314');
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-02-22','F326221123141','2026-02-22','11:23:15','SIN','708000','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-260222-0018','D','2026-02-22','11:23:15','kasir','PENJUALAN','F326221123141','2562216000','708000','2562924000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221057541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221057542';
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 ('F326220106101','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-ZAAE-120-0','KL X SANTA KH 44 9K ','','2.980','1','100.00','3978000','0','0','15000','3978000','0','0','0','3978000','SIN','00385369','H2I','0','0','-','0','1335000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZAAE-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='H2I-ZAAE-120-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 ('F326220106101','2026-02-22','2.980','2026-02-22','13:06:10','PLG0027285','3978000','3978000','0','3978000','3978000','kasir','2026-02-22 13:06:10','F32622010610');
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-02-22','F326220106101','2026-02-22','13:06:10','SIN','3978000','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-260222-0021','D','2026-02-22','13:06:10','kasir','PENJUALAN','F326220106101','2554327000','3978000','2558305000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3978000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220106101' 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 ('F326220106102','kasir',' 1',' MED1E LG A','TOKO','PM-D','D1E-ZBBX-30-0','LT MODEL HURUF MATA LG A 8K ','','0.620','1','100.00','778000','0','0','15000','778000','0','0','0','778000','SIN','00391007','D1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBBX-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='D1E-ZBBX-30-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 ('F326220106102','2026-02-22','0.620','2026-02-22','13:06:10','PLG0027286','778000','778000','0','778000','778000','kasir','2026-02-22 13:06:10','F32622010610');
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-02-22','F326220106102','2026-02-22','13:06:10','SIN','778000','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-260222-0022','D','2026-02-22','13:06:10','kasir','PENJUALAN','F326220106102','2558305000','778000','2559083000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='778000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220106102' 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-00018265','X-00018265','CC X MODEL SARANGHAEYO MATA LG 10','GR','---','E2TE','BELI','BELI001','2222000','2026-02-22','1.060','1','kasir','2026-02-22 13:15:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00018265','X-00018265');
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-260222-0001','F326070127401','AAT','1','BELI','BELI001','E2TE', 'X-00018265', 'CC X MODEL SARANGHAEYO MATA LG 10','1.060','1.060','100.00','2390000','2222000','2096226','2265000','1','2222000','2222000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260222-0001','2026-02-22','2026-02-22','13:15:00','AAT','---','1.060','2222000','2222000','2222000','2222000','2222000','kasir','2026-02-22 13:15:00','FB-260222-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0001','LINDA','SUMATRA','','','082277979154','kasir','2026-02-22 13:15:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0023','K','2026-02-22','13:15:00','kasir','PEMBELIAN UMUM','FB-260222-0001','2559083000','2222000','2556861000');
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-00018266','X-00018266','CC X MODEL MATA CM 16 8K','GR','---','E2E','BELI','BELI001','483000','2026-02-22','0.610','1','kasir','2026-02-22 13:16:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018266','X-00018266');
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-260222-0002','F325211059261','FIT','1','BELI','BELI001','E2E', 'X-00018266', 'CC X MODEL MATA CM 16 8K','0.610','0.610','100.00','620000','483000','791803','1265000','1','483000','483000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260222-0002','2026-02-22','2026-02-22','13:16:51','FIT','---','0.610','483000','483000','483000','483000','483000','kasir','2026-02-22 13:16:52','FB-260222-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0002','MURJIATI','POHIJO','','','085330063785','kasir','2026-02-22 13:16:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0024','K','2026-02-22','13:16:51','kasir','PEMBELIAN UMUM','FB-260222-0002','2556861000','483000','2556378000');
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-00018267','X-00018267','CC X MODEL MATA VAR CM 14','GR','---','E2TE','BELI','BELI001','4415000','2026-02-22','2.600','1','kasir','2026-02-22 13:18:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00018267','X-00018267');
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-260222-0003','F324191128191','FIT','1','BELI','BELI001','E2TE', 'X-00018267', 'CC X MODEL MATA VAR CM 14','2.600','2.600','100.00','2705000','4415000','1698077','2265000','1','4415000','4415000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.600',berat_beli_asli=berat_beli_asli+'2.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.600',berat_akhir_asli=berat_akhir_asli+'2.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260222-0003','2026-02-22','2026-02-22','13:18:28','FIT','---','2.600','4415000','4415000','4415000','4415000','4415000','kasir','2026-02-22 13:18:28','FB-260222-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0003','VINDA','BANGUNSARI BANDAR PACITAN','','','','kasir','2026-02-22 13:18:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0025','K','2026-02-22','13:18:28','kasir','PEMBELIAN UMUM','FB-260222-0003','2556378000','4415000','2551963000');
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-00018268','X-00018268','CC MODEL MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1032000','2026-02-22','1.120','1','kasir','2026-02-22 13:19:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018268','X-00018268');
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-260222-0004','F325180249231','AAT','1','BELI','BELI001','E2D', 'X-00018268', 'CC MODEL MATA CM 16 8K','1.120','1.120','100.00','1110000','1032000','921429','1245000','1','1032000','1032000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.120',berat_beli_asli=berat_beli_asli+'1.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-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-260222-0004','2026-02-22','2026-02-22','13:19:17','AAT','---','1.120','1032000','1032000','1032000','1032000','1032000','kasir','2026-02-22 13:19:18','FB-260222-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0004','BU SRI','KLITIK KISMANTORO','','','','kasir','2026-02-22 13:19:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0026','K','2026-02-22','13:19:17','kasir','PEMBELIAN UMUM','FB-260222-0004','2551963000','1032000','2550931000');
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-00018269','X-00018269','GW MODEL TOUGE SLEP CM','GR','---','B1TE','BELI','BELI001','1110000','2026-02-22','0.630','1','kasir','2026-02-22 13:20:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1TE','X-00018269','X-00018269');
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-260222-0005','F324041036471','FIT','1','BELI','BELI001','B1TE', 'X-00018269', 'GW MODEL TOUGE SLEP CM','0.630','0.630','100.00','555000','1110000','1761905','2265000','1','1110000','1110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1TE' 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-260222-0005','2026-02-22','2026-02-22','13:20:39','FIT','---','0.630','1110000','1110000','1110000','1110000','1110000','kasir','2026-02-22 13:20:39','FB-260222-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0005','AYA','KISMANTORO','','','','kasir','2026-02-22 13:20:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0027','K','2026-02-22','13:20:39','kasir','PEMBELIAN UMUM','FB-260222-0005','2550931000','1110000','2549821000');
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-00018270','X-00018270','AT KLIP HUGGIES BOLA ARESO UB 8K','GR','---','A1F','BELI','BELI001','857000','2026-02-22','1.130','1','kasir','2026-02-22 13:21:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00018270','X-00018270');
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-260222-0006','F324140220291','AAT','1','BELI','BELI001','A1F', 'X-00018270', 'AT KLIP HUGGIES BOLA ARESO UB 8K','1.130','1.130','100.00','692000','857000','758407','1275000','1','857000','857000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.130',berat_beli_asli=berat_beli_asli+'1.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.130',berat_akhir_asli=berat_akhir_asli+'1.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-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-260222-0006','2026-02-22','2026-02-22','13:21:51','AAT','---','1.130','857000','857000','857000','857000','857000','kasir','2026-02-22 13:21:52','FB-260222-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0006','SERLY','PAYAMAN BULUKERTO','','','','kasir','2026-02-22 13:21:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0028','K','2026-02-22','13:21:51','kasir','PEMBELIAN UMUM','FB-260222-0006','2549821000','857000','2548964000');
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-00018271','X-00018271','KL KADAR 8K','GR','---','H1E','BELI','BELI001','1635000','2026-02-22','2.070','1','kasir','2026-02-22 13:23:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018271','X-00018271');
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-260222-0007','F323121102441','SIN','1','BELI','BELI001','H1E', 'X-00018271', 'KL KADAR 8K','2.070','2.070','100.00','935000','1635000','789855','1265000','1','1635000','1635000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-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-260222-0007','2026-02-22','2026-02-22','13:23:42','SIN','---','2.070','1635000','1635000','1635000','1635000','1635000','kasir','2026-02-22 13:23:42','FB-260222-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0007','RISYA','KARANGAN BADEGAN','','','081336805695','kasir','2026-02-22 13:23:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0029','K','2026-02-22','13:23:42','kasir','PEMBELIAN UMUM','FB-260222-0007','2548964000','1635000','2547329000');
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-00018272','X-00018272','CC X WEDDING MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1460000','2026-02-22','1.500','1','kasir','2026-02-22 13:24:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018272','X-00018272');
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-260222-0008','F325191120551','AAT','1','BELI','BELI001','E2D', 'X-00018272', 'CC X WEDDING MATA CM 14 8K','1.500','1.500','100.00','1555000','1460000','973333','1245000','1','1460000','1460000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-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-260222-0008','2026-02-22','2026-02-22','13:24:33','AAT','---','1.500','1460000','1460000','1460000','1460000','1460000','kasir','2026-02-22 13:24:33','FB-260222-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0008','IWAN','NGADIROJO','','','0882007376660','kasir','2026-02-22 13:24:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0030','K','2026-02-22','13:24:33','kasir','PEMBELIAN UMUM','FB-260222-0008','2547329000','1460000','2545869000');
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-00018273','X-00018273','LT X MODEL HATI MATA LG','GR','---','D2E','BELI','BELI001','335000','2026-02-22','0.430','1','kasir','2026-02-22 13:25:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00018273','X-00018273');
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-260222-0009','F325010106511','FIT','1','BELI','BELI001','D2E', 'X-00018273', 'LT X MODEL HATI MATA LG','0.430','0.430','100.00','351000','335000','779070','1265000','1','335000','335000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260222-0009','2026-02-22','2026-02-22','13:25:55','FIT','---','0.430','335000','335000','335000','335000','335000','kasir','2026-02-22 13:25:55','FB-260222-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0009','EKA','POJOK GONDANG','','','','kasir','2026-02-22 13:25:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0031','K','2026-02-22','13:25:55','kasir','PEMBELIAN UMUM','FB-260222-0009','2545869000','335000','2545534000');
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 ('F326220222071','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZABA-155-0','GL MODEL FANCY VAR HW 8K ','','1.350','1','100.00','1694000','0','0','15000','1695000','0','0','0','1695000','SIN','00386480','F3E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABA-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F3E-ZABA-155-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 ('F326220222071','2026-02-22','1.350','2026-02-22','14:22:07','PLG0027287','1695000','1695000','0','1695000','1695000','input','2026-02-22 14:22:07','F32622022207');
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-02-22','F326220222071','2026-02-22','14:22:07','SIN','1695000','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-260222-0032','D','2026-02-22','14:22:07','input','PENJUALAN','F326220222071','2545534000','1695000','2547229000');
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 ('F326220234351','kasir','1',' MHA1H DG ','TOKO','PM-A','A1H-ZBAD-10-0','AT BABY TINDIK DG 8K ','','0.270','1','100.00','355000','0','0','15000','355000','0','0','0','355000','FIT','00389616','A1H','0','0','-','0','1325000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-ZBAD-10-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-02-22' AND kode_barang='A1H-ZBAD-10-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 ('F326220234351','2026-02-22','0.270','2026-02-22','14:34:36','PLG0027288','355000','355000','0','355000','355000','kasir','2026-02-22 14:34:35','F32622023435');
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-02-22','F326220234351','2026-02-22','14:34:36','FIT','355000','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-260222-0033','D','2026-02-22','14:34:36','kasir','PENJUALAN','F326220234351','2547229000','355000','2547584000');
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-00018274','X-00018274','GL OVAL MODEL HATI ARESO VAR YT D54 8K','GR','---','F1E','BELI','BELI001','1385000','2026-02-22','1.740','1','kasir','2026-02-22 14:35:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018274','X-00018274');
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-260222-0010','F325261047361','AAT','1','BELI','BELI001','F1E', 'X-00018274', 'GL OVAL MODEL HATI ARESO VAR YT D54 8K','1.740','1.740','100.00','1455000','1385000','795977','1265000','1','1385000','1385000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.740',berat_beli_asli=berat_beli_asli+'1.740',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.740',berat_akhir_asli=berat_akhir_asli+'1.740',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260222-0010','2026-02-22','2026-02-22','14:35:25','AAT','---','1.740','1385000','1385000','1385000','1385000','1385000','kasir','2026-02-22 14:35:25','FB-260222-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260222-0010','INDIRA','JATISRONO','','','','kasir','2026-02-22 14:35:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260222-0034','K','2026-02-22','14:35:25','kasir','PEMBELIAN UMUM','FB-260222-0010','2547584000','1385000','2546199000');
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 ('F326220247411','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-YIBD-155-0','GL X OVAL SPECTRA SLEP UB 56 8K ','','1.900','1','100.00','2384000','0','0','15000','2385000','0','0','0','2385000','SIN','00370576','F1E','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIBD-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='F1E-YIBD-155-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 ('F326220247411','2026-02-22','1.900','2026-02-22','14:47:42','PLG0027289','2385000','2385000','0','2385000','2385000','kasir','2026-02-22 14:47:41','F32622024741');
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-02-22','F326220247411','2026-02-22','14:47:42','SIN','2385000','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-260222-0035','D','2026-02-22','14:47:42','kasir','PENJUALAN','F326220247411','2546199000','2385000','2548584000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2385000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220247411' 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 ('F326220247412','kasir',' 1',' MDE2 X PM ','TOKO','PM-E','E2D-YEXA-422-0','CC X MODEL MATA PM 10 8K ','','1.010','1','100.00','1247000','0','0','15000','1248000','0','0','0','1248000','SIN','00352015','E2D','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-422-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-02-22' AND kode_barang='E2D-YEXA-422-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 ('F326220247412','2026-02-22','1.010','2026-02-22','14:47:42','PLG0027290','1248000','1248000','0','1248000','1248000','kasir','2026-02-22 14:47:41','F32622024741');
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-02-22','F326220247412','2026-02-22','14:47:42','SIN','1248000','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-260222-0036','D','2026-02-22','14:47:42','kasir','PENJUALAN','F326220247412','2548584000','1248000','2549832000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1248000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220247412' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260222-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260222-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220106101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220106101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220106101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220106102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220106102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220106102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220222071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220222071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220222071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220234351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220234351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220234351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220247411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220247411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220247411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220247412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220247412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220247412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220830381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220830381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220830381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220830382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220830382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220830382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220947001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220947001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220947001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221006061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221006061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221006061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221024201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221024201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221024201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221036261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221036261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221036261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221053151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221053151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221053151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221053152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221053152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221053152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057543' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057543' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221057543';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057544' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221057544' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221057544';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221059551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221059551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221059551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221105521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221105521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221105521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221108011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221108011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221108011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221109461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221109461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221123141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221123141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221123141';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-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-02-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-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-260223-0001','D','2026-02-23','15:15:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','2549832000','2549832000');
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-260223-0001','D','2026-02-23','15:15:51','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260223-0001','D','2026-02-23','15:15:51','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-260223-0001','D','2026-02-23','15:15:51','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-02-23';