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 ('F326081021341','input','1',' MED1 UB ','TOKO','PM-D','D1E-YHXE-175-0','LT MODEL SLEP VAR UB 8K ','','0.500','1','100.00','620000','0','0','15000','620000','0','0','0','620000','FIT','00363962','D1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YHXE-175-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-08' AND kode_barang='D1E-YHXE-175-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 ('F326081021341','2026-02-08','0.500','2026-02-08','10:21:34','PLG0027071','620000','620000','0','620000','620000','input','2026-02-08 10:21:34','F32608102134');
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-08','F326081021341','2026-02-08','10:21:34','FIT','620000','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-260208-0002','D','2026-02-08','10:21:34','input','PENJUALAN','F326081021341','2310542000','620000','2311162000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='620000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081021341' 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 ('F326081021342','input',' 1',' MJH2 X UB ','TOKO','PM-H','H2J-YLAE-95-0','KL X GUCCI UB 42 9K ','','2.920','1','100.00','3913000','0','0','15000','3913000','0','0','0','3913000','FIT','00381073','H2J','0','0','-','0','1340000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YLAE-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='H2J-YLAE-95-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 ('F326081021342','2026-02-08','2.920','2026-02-08','10:21:34','PLG0027072','3913000','3913000','0','3913000','3913000','input','2026-02-08 10:21:34','F32608102134');
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-08','F326081021342','2026-02-08','10:21:34','FIT','3913000','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-260208-0003','D','2026-02-08','10:21:34','input','PENJUALAN','F326081021342','2311162000','3913000','2315075000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3913000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081021342' 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 ('F326081039101','input','1',' MFF3 KH ','TOKO','PM-F','F3F-YIBB-119-0','GL MODEL MEDAN VAR KH 8K ','','2.180','1','100.00','2747000','0','0','15000','2748000','0','0','0','2748000','FIT','00370167','F3F','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YIBB-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='F3F-YIBB-119-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 ('F326081039101','2026-02-08','2.180','2026-02-08','10:39:10','PLG0027073','2748000','2748000','0','2748000','2748000','input','2026-02-08 10:39:10','F32608103910');
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-08','F326081039101','2026-02-08','10:39:10','FIT','2748000','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-260208-0004','D','2026-02-08','10:39:10','input','PENJUALAN','F326081039101','2315075000','2748000','2317823000');
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 ('F326081045341','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-YLXF-187-0','GW X MODEL MATA LG PE 8K ','','0.550','1','100.00','682000','0','0','15000','683000','0','0','0','683000','SIN','00380003','B1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLXF-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='B1E-YLXF-187-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 ('F326081045341','2026-02-08','0.550','2026-02-08','10:45:34','PLG0027074','683000','683000','0','683000','683000','input','2026-02-08 10:45:34','F32608104534');
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-08','F326081045341','2026-02-08','10:45:34','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) VALUES ('KM-260208-0005','D','2026-02-08','10:45:34','input','PENJUALAN','F326081045341','2317823000','683000','2318506000');
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 ('F326081051421','input','1',' MEE2 CM 16','TOKO','PM-E','E2E-ZAAI-147-0','CC PIPA MODEL MATA VAR CM 16 8K ','','0.600','1','100.00','744000','0','0','15000','745000','0','0','0','745000','SIN','00386088','E2E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZAAI-147-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-02-08' AND kode_barang='E2E-ZAAI-147-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 ('F326081051421','2026-02-08','0.600','2026-02-08','10:51:43','PLG0027075','745000','745000','0','745000','745000','input','2026-02-08 10:51:42','F32608105142');
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-08','F326081051421','2026-02-08','10:51:43','SIN','745000','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-260208-0006','D','2026-02-08','10:51:43','input','PENJUALAN','F326081051421','2318506000','745000','2319251000');
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 ('F326081054541','input','1',' MEF1 X 10K','TOKO','PM-F','F1E-YLAH-114-0','GL X PIPA BONEKA ANAK CAT UB 40 8K ','','1.850','1','100.00','2294000','0','0','15000','2295000','0','10000','0','2305000','FIT','00381775','F1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAH-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='F1E-YLAH-114-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 ('F326081054541','2026-02-08','1.850','2026-02-08','10:54:55','PLG0027076','2295000','2295000','10000','2305000','2305000','input','2026-02-08 10:54:54','F32608105454');
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-08','F326081054541','2026-02-08','10:54:55','FIT','2305000','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-260208-0007','D','2026-02-08','10:54:55','input','PENJUALAN','F326081054541','2319251000','2305000','2321556000');
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 ('F326081113181','input','1',' MEE1 X AY ','TOKO','PM-E','E1E-ZBXF-183-0','CC X MODEL HURUF SLEP AY A 10 8K ','','0.470','1','100.00','583000','0','0','15000','583000','0','0','0','583000','SIN','00388765','E1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBXF-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='E1E-ZBXF-183-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 ('F326081113181','2026-02-08','0.470','2026-02-08','11:13:18','PLG0027077','583000','583000','0','583000','583000','input','2026-02-08 11:13:18','F32608111318');
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-08','F326081113181','2026-02-08','11:13:18','SIN','583000','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-260208-0008','D','2026-02-08','11:13:18','input','PENJUALAN','F326081113181','2321556000','583000','2322139000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='583000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081113181' 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 ('F326081113182','input',' 1',' MDE1 CM 13','TOKO','PM-E','E1D-YLBX-257-0','CC MODEL DAUN SLEP CM 13 8K ','','0.850','1','100.00','1037000','0','0','15000','1037000','0','0','0','1037000','SIN','00382137','E1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLBX-257-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='E1D-YLBX-257-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 ('F326081113182','2026-02-08','0.850','2026-02-08','11:13:18','PLG0027078','1037000','1037000','0','1037000','1037000','input','2026-02-08 11:13:18','F32608111318');
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-08','F326081113182','2026-02-08','11:13:18','SIN','1037000','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-260208-0009','D','2026-02-08','11:13:18','input','PENJUALAN','F326081113182','2322139000','1037000','2323176000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1037000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081113182' 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 ('F326081113441','input','1',' MDD2D X LG','TOKO','PM-D','D2D-YLAF-93-0','LT X SLOBOK BOLA MATA LG 8K ','','0.910','1','100.00','1110000','0','0','15000','1110000','0','0','0','1110000','FIT','00381277','D2D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YLAF-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='D2D-YLAF-93-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 ('F326081113441','2026-02-08','0.910','2026-02-08','11:13:45','PLG0027079','1110000','1110000','0','1110000','1110000','input','2026-02-08 11:13:44','F32608111344');
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-08','F326081113441','2026-02-08','11:13:45','FIT','1110000','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-260208-0010','D','2026-02-08','11:13:45','input','PENJUALAN','F326081113441','2323176000','1110000','2324286000');
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 ('F326081129011','input','1',' MDE1 CM 16','TOKO','PM-E','E1D-ZAXH-109-T','CC MODEL DAUN VAR CM 16 8K ','','0.980','1','100.00','1196000','0','0','15000','1196000','0','0','0','1196000','FIT','T0076432','E1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-109-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='E1D-ZAXH-109-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326081129011','2026-02-08','0.980','2026-02-08','11:29:02','PLG0027080','1196000','1196000','0','1196000','1196000','input','2026-02-08 11:29:01','F32608112901');
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-08','F326081129011','2026-02-08','11:29:02','FIT','1196000','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-260208-0011','D','2026-02-08','11:29:02','input','PENJUALAN','F326081129011','2324286000','1196000','2325482000');
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 ('F326081152221','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-YLXE-131-0','KL GUCCI ANAK UB 34 8K ','','1.080','1','100.00','1339000','0','0','15000','1340000','0','0','0','1340000','SIN','00379801','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXE-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='H1E-YLXE-131-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 ('F326081152221','2026-02-08','1.080','2026-02-08','11:52:23','PLG0027081','1340000','1340000','0','1340000','1340000','input','2026-02-08 11:52:22','F32608115222');
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-08','F326081152221','2026-02-08','11:52:23','SIN','1340000','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-260208-0012','D','2026-02-08','11:52:23','input','PENJUALAN','F326081152221','2325482000','1340000','2326822000');
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 ('F326081157371','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-YIBD-248-0','KL X FLAMINGO KH 42 9K ','','4.950','1','100.00','6534000','0','0','15000','6535000','0','0','0','6535000','AAT','00370669','H2I','0','0','-','0','1320000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YIBD-248-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='H2I-YIBD-248-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 ('F326081157371','2026-02-08','4.950','2026-02-08','11:57:38','PLG0027082','6535000','6535000','0','6535000','6535000','input','2026-02-08 11:57:37','F32608115737');
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-08','F326081157371','2026-02-08','11:57:38','AAT','6535000','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-260208-0013','D','2026-02-08','11:57:38','input','PENJUALAN','F326081157371','2326822000','6535000','2333357000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081157371' 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 ('F326081157372','input',' 1',' MFD1F X BG','TOKO','PM-D','D1F-YKBB-150-0','LT X MODEL ARESO SLEP BG 8K ','','0.510','1','100.00','643000','0','0','15000','643000','0','0','0','643000','AAT','00378299','D1F','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YKBB-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='D1F-YKBB-150-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 ('F326081157372','2026-02-08','0.510','2026-02-08','11:57:38','PLG0027083','643000','643000','0','643000','643000','input','2026-02-08 11:57:37','F32608115737');
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-08','F326081157372','2026-02-08','11:57:38','AAT','643000','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-260208-0014','D','2026-02-08','11:57:38','input','PENJUALAN','F326081157372','2333357000','643000','2334000000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081157372' 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 ('F326081158401','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-YJBB-141-0','KL X MILANO KH 42 9K ','','3.980','1','100.00','5333000','0','0','15000','5333000','0','0','0','5333000','SIN','00374204','H2J','0','0','-','0','1340000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJBB-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.980',berat_jual_asli=berat_jual_asli+'3.980',stock_jual='1',berat_akhir=berat_akhir-'3.980',berat_akhir_asli=berat_akhir_asli-'3.980',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='H2J-YJBB-141-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 ('F326081158401','2026-02-08','3.980','2026-02-08','11:58:41','PLG0027084','5333000','5333000','0','5333000','5333000','input','2026-02-08 11:58:40','F32608115840');
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-08','F326081158401','2026-02-08','11:58:41','SIN','5333000','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-260208-0015','D','2026-02-08','11:58:41','input','PENJUALAN','F326081158401','2334000000','5333000','2339333000');
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 ('F326080100011','input','1',' MHD1H X BG','TOKO','PM-D','D1H-ZAXE-154-0','LT X SLOBOK BOLA SLEP BG 8K ','GT A','0.270','1','100.00','351000','0','0','15000','351000','0','20000','0','371000','FIT','00384075','D1H','0','0','-','0','1300000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZAXE-154-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-08' AND kode_barang='D1H-ZAXE-154-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 ('F326080100011','2026-02-08','0.270','2026-02-08','13:00:02','PLG0027085','351000','351000','20000','371000','371000','input','2026-02-08 13:00:01','F32608010001');
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-08','F326080100011','2026-02-08','13:00:02','FIT','371000','20000');
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-260208-0016','D','2026-02-08','13:00:02','input','PENJUALAN','F326080100011','2339333000','371000','2339704000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='371000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080100011' 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 ('F326080100012','input',' 1',' MHD1H X BG','TOKO','PM-D','D1H-ZAXE-158-0','LT X SLOBOK BOLA SLEP BG 8K ','','0.270','1','100.00','351000','0','0','15000','351000','0','0','0','351000','FIT','00384079','D1H','0','0','-','0','1300000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZAXE-158-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-08' AND kode_barang='D1H-ZAXE-158-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 ('F326080100012','2026-02-08','0.270','2026-02-08','13:00:02','PLG0027086','351000','351000','0','351000','351000','input','2026-02-08 13:00:01','F32608010001');
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-08','F326080100012','2026-02-08','13:00:02','FIT','351000','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-260208-0017','D','2026-02-08','13:00:02','input','PENJUALAN','F326080100012','2339704000','351000','2340055000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080100012' 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-00018165','X-00018165','GL X OSROT BONEKA ANAK CAT LG 8K','GR','---','F1E','BELI','BELI001','1487000','2026-02-08','1.910','1','kasir','2026-02-08 13:35:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018165','X-00018165');
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-260208-0001','F325271048143','AAT','1','BELI','BELI001','F1E', 'X-00018165', 'GL X OSROT BONEKA ANAK CAT LG 8K','1.910','1.910','100.00','1577000','1487000','778534','1250000','1','1487000','1487000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.910',berat_beli_asli=berat_beli_asli+'1.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.910',berat_akhir_asli=berat_akhir_asli+'1.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-08' 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-260208-0001','2026-02-08','2026-02-08','13:35:16','AAT','---','1.910','1487000','1487000','1487000','1487000','1487000','kasir','2026-02-08 13:35:17','FB-260208-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260208-0001','PARSI','PUH PELEM','','','081393252881','kasir','2026-02-08 13:35:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-08' 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-260208-0018','K','2026-02-08','13:35:16','kasir','PEMBELIAN UMUM','FB-260208-0001','2340055000','1487000','2338568000');
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-00018166','X-00018166','GL OSROT ANAK BONEKA CAT VAR LG 8K','GR','---','F1E','BELI','BELI001','1630000','2026-02-08','2.070','1','kasir','2026-02-08 13:35:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018166','X-00018166');
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-260208-0002','F325271048144','AAT','2','BELI','BELI001','F1E', 'X-00018166', 'GL OSROT ANAK BONEKA CAT VAR LG 8K','2.070','2.070','100.00','1708000','1630000','787440','1250000','1','1630000','1630000','RUSAK');
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-08' 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-260208-0002','2026-02-08','2026-02-08','13:35:16','AAT','---','2.070','1630000','1630000','1630000','1630000','1630000','kasir','2026-02-08 13:35:17','FB-260208-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260208-0002','PARSI','PUH PELEM','','','081393252881','kasir','2026-02-08 13:35:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-08' 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-260208-0019','K','2026-02-08','13:35:16','kasir','PEMBELIAN UMUM','FB-260208-0002','2338568000','1630000','2336938000');
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-00018167','X-00018167','CC X MODEL MATA LG 6 8K','GR','---','E2D','BELI','BELI001','682000','2026-02-08','0.910','1','kasir','2026-02-08 13:36:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018167','X-00018167');
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-260208-0003','F325010305581','FIT','1','BELI','BELI001','E2D', 'X-00018167', 'CC X MODEL MATA LG 6 8K','0.910','0.910','100.00','727000','682000','749451','1230000','1','682000','682000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-08' 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-260208-0003','2026-02-08','2026-02-08','13:36:07','FIT','---','0.910','682000','682000','682000','682000','682000','kasir','2026-02-08 13:36:08','FB-260208-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260208-0003','ZAHRA','SENDANG PURWANTORO','','','','kasir','2026-02-08 13:36:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-08' 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-260208-0020','K','2026-02-08','13:36:07','kasir','PEMBELIAN UMUM','FB-260208-0003','2336938000','682000','2336256000');
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-00018168','X-00018168','KL X NORY PANJANG KH 58 8K','GR','---','H1E','BELI','BELI001','6500000','2026-02-08','6.910','1','kasir','2026-02-08 13:36:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018168','X-00018168');
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-260208-0004','F325080113261','AAT','1','BELI','BELI001','H1E', 'X-00018168', 'KL X NORY PANJANG KH 58 8K','6.910','6.910','100.00','6840000','6500000','940666','1250000','1','6500000','6500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.910',berat_beli_asli=berat_beli_asli+'6.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.910',berat_akhir_asli=berat_akhir_asli+'6.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-08' 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-260208-0004','2026-02-08','2026-02-08','13:36:24','AAT','---','6.910','6500000','6500000','6500000','6500000','6500000','kasir','2026-02-08 13:36:25','FB-260208-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260208-0004','SRI HARTINI','JATISRONO','','','','kasir','2026-02-08 13:36:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-08' 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-260208-0021','K','2026-02-08','13:36:24','kasir','PEMBELIAN UMUM','FB-260208-0004','2336256000','6500000','2329756000');
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 ('F326080140571','kasir','1',' MDE2 X 10K','TOKO','PM-E','E2D-YKAD-30-0','CC X WEDDING MATA CM 14 8K ','','1.980','1','100.00','2416000','0','0','15000','2416000','0','10000','0','2426000','SIN','00377368','E2D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAD-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='E2D-YKAD-30-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 ('F326080140571','2026-02-08','1.980','2026-02-08','13:40:57','PLG0027087','2416000','2416000','10000','2426000','2426000','kasir','2026-02-08 13:40:57','F32608014057');
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-08','F326080140571','2026-02-08','13:40:57','SIN','2426000','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-260208-0022','D','2026-02-08','13:40:57','kasir','PENJUALAN','F326080140571','2329756000','2426000','2332182000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080140571' 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 ('F326080140572','kasir',' 1',' MDE2 X 10K','TOKO','PM-E','E2D-YKXC-4-0','CC X WEDDING MATA CM 19 8K ','','1.730','1','100.00','2111000','0','0','15000','2111000','0','10000','0','2121000','SIN','00375925','E2D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXC-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='E2D-YKXC-4-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 ('F326080140572','2026-02-08','1.730','2026-02-08','13:40:57','PLG0027088','2111000','2111000','10000','2121000','2121000','kasir','2026-02-08 13:40:57','F32608014057');
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-08','F326080140572','2026-02-08','13:40:57','SIN','2121000','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-260208-0023','D','2026-02-08','13:40:57','kasir','PENJUALAN','F326080140572','2332182000','2121000','2334303000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2121000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080140572' 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-00018169','X-00018169','GL LEMES 8K','GR','---','F3E','BELI','BELI001','1635000','2026-02-08','2.060','1','kasir','2026-02-08 13:54:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018169','X-00018169');
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-260208-0005','F323100209281','AAT','1','BELI','BELI001','F3E', 'X-00018169', 'GL LEMES 8K','2.060','2.060','100.00','930000','1635000','793689','1250000','1','1635000','1635000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260208-0005','2026-02-08','2026-02-08','13:54:44','AAT','---','2.060','1635000','1635000','1635000','1635000','1635000','kasir','2026-02-08 13:54:45','FB-260208-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260208-0005','RAHMA','SLOGOHIMO','','','','kasir','2026-02-08 13:54:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-08' 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-260208-0024','K','2026-02-08','13:54:44','kasir','PEMBELIAN UMUM','FB-260208-0005','2334303000','1635000','2332668000');
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 ('F326080212331','input','1',' MDE1 10K C','TOKO','PM-E','E1D-YLAE-158-0','CC WEDDING MATA CM 22 8K ','','1.510','1','100.00','1842000','0','0','15000','1842000','0','10000','0','1852000','SIN','00381136','E1D','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLAE-158-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-08' AND kode_barang='E1D-YLAE-158-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 ('F326080212331','2026-02-08','1.510','2026-02-08','14:12:33','PLG0027089','1842000','1842000','10000','1852000','1852000','input','2026-02-08 14:12:33','F32608021233');
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-08','F326080212331','2026-02-08','14:12:33','SIN','1852000','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-260208-0025','D','2026-02-08','14:12:33','input','PENJUALAN','F326080212331','2332668000','1852000','2334520000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1852000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080212331' 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 ('F326080212332','input',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-YLBE-129-0','KL X JEDAR SLEP VAR KH 42 8K ','','1.930','1','100.00','2393000','0','0','15000','2393000','0','0','0','2393000','SIN','00383149','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBE-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-02-08' AND kode_barang='H1E-YLBE-129-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 ('F326080212332','2026-02-08','1.930','2026-02-08','14:12:33','PLG0027090','2393000','2393000','0','2393000','2393000','input','2026-02-08 14:12:33','F32608021233');
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-08','F326080212332','2026-02-08','14:12:33','SIN','2393000','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-260208-0026','D','2026-02-08','14:12:33','input','PENJUALAN','F326080212332','2334520000','2393000','2336913000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080212332' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080100011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080100011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080100011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080100012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080100012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080100012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080140571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080140571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080140571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080140572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080140572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080140572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080212331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080212331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080212331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080212332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080212332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080212332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081021341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081021341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081021341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081021342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081021342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081021342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081039101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081039101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081039101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081045341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081045341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081045341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081051421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081051421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081051421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081054541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081054541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081054541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081129011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081129011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081129011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081152221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081152221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081152221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081157371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081157371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081157371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081157372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081157372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081157372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081158401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081158401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081158401';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260208-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260208-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260208-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260208-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260208-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260208-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260208-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260208-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260208-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260208-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-08';
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-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-08';
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-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-08' 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-260209-0001','D','2026-02-09','15:14:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','2336913000','2336913000');
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-260209-0001','D','2026-02-09','15:14:03','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-260209-0001','D','2026-02-09','15:14:03','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-260209-0001','D','2026-02-09','15:14:03','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-02-09';