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 ('F326010916511','input','1',' MDA1 7K LG','TOKO','PM-A','A1D-YGXD-371-0','AT MODEL APEL CAT MATA VAR LG 8K ','','1.040','1','100.00','1269000','0','0','15000','1270000','0','7000','0','1277000','FIT','00359694','A1D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGXD-371-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='A1D-YGXD-371-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 ('F326010916511','2026-02-01','1.040','2026-02-01','09:16:52','PLG0026979','1270000','1270000','7000','1277000','1277000','input','2026-02-01 09:16:51','F32601091651');
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-01','F326010916511','2026-02-01','09:16:52','FIT','1277000','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-260201-0002','D','2026-02-01','09:16:52','input','PENJUALAN','F326010916511','2150350000','1277000','2151627000');
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 ('F326011004161','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-YIAC-183-0','CC X MODEL MATA LG 14 8K ','','1.040','1','100.00','1269000','0','0','15000','1270000','0','0','0','1270000','SIN','00369267','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E2D-YIAC-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 ('F326011004161','2026-02-01','1.040','2026-02-01','10:04:17','PLG0026980','1270000','1270000','0','1270000','1270000','input','2026-02-01 10:04:16','F32601100416');
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-01','F326011004161','2026-02-01','10:04:17','SIN','1270000','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-260201-0003','D','2026-02-01','10:04:17','input','PENJUALAN','F326011004161','2151627000','1270000','2152897000');
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-00018112','X-00018112','GL OVAL MODEL C TD D52 8K','GR','---','F1E','BELI','BELI001','3845000','2026-02-01','4.690','1','kasir','2026-02-01 10:19:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018112','X-00018112');
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-260201-0001','F325300317521','FIT','1','BELI','BELI001','F1E', 'X-00018112', 'GL OVAL MODEL C TD D52 8K','4.690','4.690','100.00','3660000','3845000','819829','1250000','1','3845000','3845000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.690',berat_beli_asli=berat_beli_asli+'4.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.690',berat_akhir_asli=berat_akhir_asli+'4.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' 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-260201-0001','2026-02-01','2026-02-01','10:19:41','FIT','---','4.690','3845000','3845000','3845000','3845000','3845000','kasir','2026-02-01 10:19:42','FB-260201-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0001','FELIA','SUMBER SENDANG','','','','kasir','2026-02-01 10:19:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0004','K','2026-02-01','10:19:41','kasir','PEMBELIAN UMUM','FB-260201-0001','2152897000','3845000','2149052000');
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 ('F326011021351','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-YIBD-307-0','CC X WEDDING MATA CM 12 8K ','','2.070','1','100.00','2525000','0','0','15000','2525000','0','0','0','2525000','AAT','00370728','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBD-307-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E2D-YIBD-307-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 ('F326011021351','2026-02-01','2.070','2026-02-01','10:21:35','PLG0026981','2525000','2525000','0','2525000','2525000','kasir','2026-02-01 10:21:35','F32601102135');
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-01','F326011021351','2026-02-01','10:21:35','AAT','2525000','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-260201-0005','D','2026-02-01','10:21:35','kasir','PENJUALAN','F326011021351','2149052000','2525000','2151577000');
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 ('F326011034411','kasir','1',' MDA1 HW ','TOKO','PM-A','A1D-ZABA-166-0','AT MODEL BOLA ARESO VAR HW 8K ','','0.900','1','100.00','1098000','0','0','15000','1098000','0','0','0','1098000','SIN','00386491','A1D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZABA-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='A1D-ZABA-166-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 ('F326011034411','2026-02-01','0.900','2026-02-01','10:34:42','PLG0026982','1098000','1098000','0','1098000','1098000','kasir','2026-02-01 10:34:41','F32601103441');
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-01','F326011034411','2026-02-01','10:34:42','SIN','1098000','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-260201-0006','D','2026-02-01','10:34:42','kasir','PENJUALAN','F326011034411','2151577000','1098000','2152675000');
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 ('F326011048561','kasir','1',' MEE1 X CM ','TOKO','PM-E','E1E-YLXH-113-0','CC X MODEL DAUN SLEP CM 14 8K ','','0.670','1','100.00','831000','0','0','15000','830000','0','0','0','830000','FIT','00380235','E1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLXH-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E1E-YLXH-113-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 ('F326011048561','2026-02-01','0.670','2026-02-01','10:48:57','PLG0026983','830000','830000','0','830000','830000','kasir','2026-02-01 10:48:56','F32601104856');
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-01','F326011048561','2026-02-01','10:48:57','FIT','830000','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-260201-0007','D','2026-02-01','10:48:57','kasir','PENJUALAN','F326011048561','2152675000','830000','2153505000');
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 ('F326011049511','kasir','1',' MGPE X UB ','TOKO','PM-P','PEG-XHBH-8-0','CC X WG MODEL BINTANG MATA VAR UB 14 8K','','0.710','1','100.00','909000','0','0','15000','910000','0','0','0','910000','SIN','00314114','PEG','0','0','-','0','1280000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEG-XHBH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PEG-XHBH-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326011049511','2026-02-01','0.710','2026-02-01','10:49:51','PLG0026984','910000','910000','0','910000','910000','kasir','2026-02-01 10:49:51','F32601104951');
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-01','F326011049511','2026-02-01','10:49:51','SIN','910000','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-260201-0008','D','2026-02-01','10:49:51','kasir','PENJUALAN','F326011049511','2153505000','910000','2154415000');
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 ('F326011117471','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-YIBC-434-0','KL X GUCCI UB 42 8K ','','1.120','1','100.00','1389000','0','0','15000','1390000','0','0','0','1390000','FIT','00370405','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBC-434-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='H1E-YIBC-434-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 ('F326011117471','2026-02-01','1.120','2026-02-01','11:17:48','PLG0026985','1390000','1390000','0','1390000','1390000','kasir','2026-02-01 11:17:47','F32601111747');
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-01','F326011117471','2026-02-01','11:17:48','FIT','1390000','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-260201-0009','D','2026-02-01','11:17:48','kasir','PENJUALAN','F326011117471','2154415000','1390000','2155805000');
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-00018113','X-00018113','GL SANTA MODEL DAUN VAR UB 8K','GR','---','F3E','BELI','BELI001','1785000','2026-02-01','1.940','1','kasir','2026-02-01 12:48:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018113','X-00018113');
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-260201-0002','F325061152251','AAT','1','BELI','BELI001','F3E', 'X-00018113', 'GL SANTA MODEL DAUN VAR UB 8K','1.940','1.940','100.00','1900000','1785000','920103','1250000','1','1785000','1785000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.940',berat_beli_asli=berat_beli_asli+'1.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.940',berat_akhir_asli=berat_akhir_asli+'1.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' 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-260201-0002','2026-02-01','2026-02-01','12:48:33','AAT','---','1.940','1785000','1785000','1785000','1785000','1785000','kasir','2026-02-01 12:48:34','FB-260201-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0002','RINTIN','KARANGLO','','','','kasir','2026-02-01 12:48:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0010','K','2026-02-01','12:48:33','kasir','PEMBELIAN UMUM','FB-260201-0002','2155805000','1785000','2154020000');
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-00018114','X-00018114','CC MODEL DAUN SLEP LG 10 8K','GR','---','E1E','BELI','BELI001','400000','2026-02-01','0.430','1','kasir','2026-02-01 12:48:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018114','X-00018114');
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-260201-0003','F325071144421','AAT','1','BELI','BELI001','E1E', 'X-00018114', 'CC MODEL DAUN SLEP LG 10 8K','0.430','0.430','100.00','425000','400000','930233','1250000','1','400000','400000','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-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260201-0003','2026-02-01','2026-02-01','12:48:55','AAT','---','0.430','400000','400000','400000','400000','400000','kasir','2026-02-01 12:48:55','FB-260201-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0003','RINTIN','KARANGLO','','','','kasir','2026-02-01 12:48:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0011','K','2026-02-01','12:48:55','kasir','PEMBELIAN UMUM','FB-260201-0003','2154020000','400000','2153620000');
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-00018115','X-00018115','CC X MODEL MATA LG 14 8K','GR','---','E2D','BELI','BELI001','935000','2026-02-01','1.010','1','kasir','2026-02-01 12:49:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018115','X-00018115');
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-260201-0004','F325110151441','FIT','1','BELI','BELI001','E2D', 'X-00018115', 'CC X MODEL MATA LG 14 8K','1.010','1.010','100.00','995000','935000','925743','1220000','1','935000','935000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' 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-260201-0004','2026-02-01','2026-02-01','12:49:29','FIT','---','1.010','935000','935000','935000','935000','935000','kasir','2026-02-01 12:49:29','FB-260201-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0004','DEWI','SLOGOHIMO','','','','kasir','2026-02-01 12:49:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0012','K','2026-02-01','12:49:29','kasir','PEMBELIAN UMUM','FB-260201-0004','2153620000','935000','2152685000');
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-00018116','X-00018116','LT MODEL MATA SLEP VAR CM 8K','GR','---','D2D','BELI','BELI001','820000','2026-02-01','0.830','1','kasir','2026-02-01 12:49:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00018116','X-00018116');
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-260201-0005','F325241014441','FIT','1','BELI','BELI001','D2D', 'X-00018116', 'LT MODEL MATA SLEP VAR CM 8K','0.830','0.830','100.00','893000','820000','987952','1220000','1','820000','820000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-260201-0005','2026-02-01','2026-02-01','12:49:51','FIT','---','0.830','820000','820000','820000','820000','820000','kasir','2026-02-01 12:49:51','FB-260201-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0005','WIDIA','GUNUNG WIJIL','','','081227841445','kasir','2026-02-01 12:49:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0013','K','2026-02-01','12:49:51','kasir','PEMBELIAN UMUM','FB-260201-0005','2152685000','820000','2151865000');
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-00018117','X-00018117','CC WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1300000','2026-02-01','1.570','1','kasir','2026-02-01 12:50:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018117','X-00018117');
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-260201-0006','F325161205211','AAT','1','BELI','BELI001','E2D', 'X-00018117', 'CC WEDDING MATA CM 16 8K','1.570','1.570','100.00','1397000','1300000','828025','1220000','1','1300000','1300000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.570',berat_beli_asli=berat_beli_asli+'1.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.570',berat_akhir_asli=berat_akhir_asli+'1.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' 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-260201-0006','2026-02-01','2026-02-01','12:50:10','AAT','---','1.570','1300000','1300000','1300000','1300000','1300000','kasir','2026-02-01 12:50:10','FB-260201-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0006','KEYSA','KLITIK KISMANTORO','','','','kasir','2026-02-01 12:50:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0014','K','2026-02-01','12:50:10','kasir','PEMBELIAN UMUM','FB-260201-0006','2151865000','1300000','2150565000');
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 ('F326010108561','kasir','1',' MDE2 8K CM','TOKO','PM-E','E2D-ZAAI-142-0','CC WEDDING MATA CM 12 8K ','','1.480','1','100.00','1806000','0','0','15000','1805000','0','8000','0','1813000','SIN','00386083','E2D','0','0','-','1','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAI-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E2D-ZAAI-142-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 ('F326010108561','2026-02-01','1.480','2026-02-01','13:08:56','PLG0026986','1805000','1805000','8000','1813000','1813000','kasir','2026-02-01 13:08:56','F32601010856');
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-01','F326010108561','2026-02-01','13:08:56','SIN','1813000','8000');
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-260201-0015','D','2026-02-01','13:08:56','kasir','PENJUALAN','F326010108561','2150565000','1813000','2152378000');
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 ('F326010112551','kasir','1',' TFA1 X UB ','TOKO','PT-A','A1TF-XAXC-62-T','AT X MODEL HATI ARESO UB ','','1.110','1','100.00','2509000','0','0','15000','2510000','0','0','0','2510000','AAT','T0052907','A1TF','0','0','-','0','2260000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-XAXC-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='A1TF-XAXC-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326010112551','2026-02-01','1.110','2026-02-01','13:12:55','PLG0026987','2510000','2510000','0','2510000','2510000','kasir','2026-02-01 13:12:55','F32601011255');
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-01','F326010112551','2026-02-01','13:12:55','AAT','2510000','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-260201-0016','D','2026-02-01','13:12:55','kasir','PENJUALAN','F326010112551','2152378000','2510000','2154888000');
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-00018118','X-00018118','CC X WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1315000','2026-02-01','1.700','1','kasir','2026-02-01 13:29:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018118','X-00018118');
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-260201-0007','F324071001463','AAT','1','BELI','BELI001','E2D', 'X-00018118', 'CC X WEDDING MATA CM 16 8K','1.700','1.700','100.00','1091000','1315000','773529','1220000','1','1315000','1315000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.700',berat_beli_asli=berat_beli_asli+'1.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.700',berat_akhir_asli=berat_akhir_asli+'1.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' 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-260201-0007','2026-02-01','2026-02-01','13:29:35','AAT','---','1.700','1315000','1315000','1315000','1315000','1315000','kasir','2026-02-01 13:29:36','FB-260201-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0007','DIAN','TERBIS KISMANTORO','','','081353795663','kasir','2026-02-01 13:29:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0017','K','2026-02-01','13:29:35','kasir','PEMBELIAN UMUM','FB-260201-0007','2154888000','1315000','2153573000');
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 ('F326010140411','kasir','1',' MEF2 XX PM','TOKO','PM-F','F2E-YLBE-78-0','GL XX PIPA MATA PM 56 8K ','','2.950','1','100.00','3658000','0','0','15000','3570000','0','0','0','3570000','AAT','00383098','F2E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLBE-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='F2E-YLBE-78-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 ('F326010140411','2026-02-01','2.950','2026-02-01','13:40:41','PLG0026988','3570000','3570000','0','3570000','3570000','kasir','2026-02-01 13:40:41','F32601014041');
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-01','F326010140411','2026-02-01','13:40:41','AAT','3570000','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-260201-0018','D','2026-02-01','13:40:41','kasir','PENJUALAN','F326010140411','2153573000','3570000','2157143000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010140411' 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 ('F326010140412','kasir',' 1',' MGB1G X LG','TOKO','PM-B','B1G-ZABC-30-0','GW X TUSUK DAISY MATA LG 8K ','','0.370','1','100.00','474000','0','0','15000','475000','0','0','0','475000','AAT','00386660','B1G','0','0','-','0','1280000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZABC-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='B1G-ZABC-30-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 ('F326010140412','2026-02-01','0.370','2026-02-01','13:40:41','PLG0026989','475000','475000','0','475000','475000','kasir','2026-02-01 13:40:41','F32601014041');
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-01','F326010140412','2026-02-01','13:40:41','AAT','475000','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-260201-0019','D','2026-02-01','13:40:41','kasir','PENJUALAN','F326010140412','2157143000','475000','2157618000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='475000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010140412' 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 ('F326010206281','kasir','1',' MEB1 LG PE','TOKO','PM-B','B1E-YLBC-170-0','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.530','1','100.00','657000','0','0','15000','657000','0','0','0','657000','FIT','00382613','B1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBC-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='B1E-YLBC-170-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 ('F326010206281','2026-02-01','0.530','2026-02-01','14:06:29','PLG0026990','657000','657000','0','657000','657000','kasir','2026-02-01 14:06:28','F32601020628');
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-01','F326010206281','2026-02-01','14:06:29','FIT','657000','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-260201-0020','D','2026-02-01','14:06:29','kasir','PENJUALAN','F326010206281','2157618000','657000','2158275000');
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 ('F326010222101','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YLAG-60-0','GL X TIFF SLEP UB 8K ','','0.930','1','100.00','1153000','0','0','15000','1153000','0','0','0','1153000','FIT','00381414','F3E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='F3E-YLAG-60-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 ('F326010222101','2026-02-01','0.930','2026-02-01','14:22:10','PLG0026991','1153000','1153000','0','1153000','1153000','input','2026-02-01 14:22:10','F32601022210');
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-01','F326010222101','2026-02-01','14:22:10','FIT','1153000','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-260201-0021','D','2026-02-01','14:22:10','input','PENJUALAN','F326010222101','2158275000','1153000','2159428000');
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-00018119','X-00018119','AT GYPSY MRICAN VAR LG 8K','GR','---','A1E','BELI','BELI001','462000','2026-02-01','0.550','1','kasir','2026-02-01 14:23:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00018119','X-00018119');
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-260201-0008','F325110254141','FIT','1','BELI','BELI001','A1E', 'X-00018119', 'AT GYPSY MRICAN VAR LG 8K','0.550','0.550','100.00','493000','462000','840000','1250000','1','462000','462000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260201-0008','2026-02-01','2026-02-01','14:23:22','FIT','---','0.550','462000','462000','462000','462000','462000','kasir','2026-02-01 14:23:22','FB-260201-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260201-0008','SELINA','PUCANGANOM PUHPELEM','','','','kasir','2026-02-01 14:23:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-01' 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-260201-0022','K','2026-02-01','14:23:22','kasir','PEMBELIAN UMUM','FB-260201-0008','2159428000','462000','2158966000');
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 ('F326010303541','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-YKAA-89-0','GL X OVAL C GELOMBANG SLEP YT 54 8K ','','3.130','1','100.00','3881000','0','0','15000','3882000','0','0','0','3882000','FIT','00377055','F1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKAA-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='F1E-YKAA-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326010303541','2026-02-01','3.130','2026-02-01','15:03:54','PLG0026992','3882000','3882000','0','3882000','3882000','kasir','2026-02-01 15:03:54','F32601030354');
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-01','F326010303541','2026-02-01','15:03:54','FIT','3882000','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-260201-0023','D','2026-02-01','15:03:54','kasir','PENJUALAN','F326010303541','2158966000','3882000','2162848000');
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 ('F326010312031','kasir','1',' MDE2 CM 24','TOKO','PM-E','E2D-ZAAI-5-0','CC MODEL MATA CM 24 8K ','','1.030','1','100.00','1257000','0','0','15000','1257000','0','0','0','1257000','SIN','00385943','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAI-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E2D-ZAAI-5-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 ('F326010312031','2026-02-01','1.030','2026-02-01','15:12:04','PLG0026993','1257000','1257000','0','1257000','1257000','kasir','2026-02-01 15:12:03','F32601031203');
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-01','F326010312031','2026-02-01','15:12:04','SIN','1257000','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-260201-0024','D','2026-02-01','15:12:04','kasir','PENJUALAN','F326010312031','2162848000','1257000','2164105000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1257000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010312031' 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 ('F326010312032','kasir',' 1',' MDE1 UB 15','TOKO','PM-E','E1D-ZAAG-199-0','CC MODEL BUNGA CLOVER SLEP UB 15 8K ','','1.140','1','100.00','1391000','0','0','15000','1391000','0','0','0','1391000','SIN','00385932','E1D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAAG-199-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='E1D-ZAAG-199-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 ('F326010312032','2026-02-01','1.140','2026-02-01','15:12:04','PLG0026994','1391000','1391000','0','1391000','1391000','kasir','2026-02-01 15:12:03','F32601031203');
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-01','F326010312032','2026-02-01','15:12:04','SIN','1391000','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-260201-0025','D','2026-02-01','15:12:04','kasir','PENJUALAN','F326010312032','2164105000','1391000','2165496000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1391000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010312032' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260201-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260201-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010108561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010108561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010108561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010112551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010112551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010112551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010140411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010140411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010140411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010140412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010140412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010140412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010206281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010206281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010206281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010222101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010222101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010222101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010303541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010303541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010303541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010312031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010312031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010312031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010312032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010312032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010312032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010916511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010916511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010916511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011004161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011004161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011004161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011021351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011021351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011021351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011034411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011034411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011034411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011048561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011048561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011048561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011049511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011049511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011049511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011117471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011117471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011117471';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260201-0001','1','A1D-ZAAI-104-0','1','1.000','1.000','TOKO','PM-A','TOKO','SBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-A' WHERE kode_barang='A1D-ZAAI-104-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-A';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-01','TOKO','SBK-A','A1D','A1D-ZAAI-104-0','100.00','1','1.000','1.000','1','1.000','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-01' AND kode_barang='A1D-ZAAI-104-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260201-0001','2026-02-01','2026-02-01','15:35','1','input','2026-02-01 15:36:04');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-01';
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-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-01' 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-260202-0001','D','2026-02-02','15:38:43','SYSTEM','SALDO AWAL','SALDO AWAL','0','2165496000','2165496000');
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-260202-0001','D','2026-02-02','15:38:43','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260202-0001','D','2026-02-02','15:38:43','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-260202-0001','D','2026-02-02','15:38:43','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-02-02';