Mechanical door locks that work by a physical key are less prone to electrical failures.... or fob failures. Or fob battery failures.....

7 days to discharge a nearly new battery suggests an electrical leakage/load problem (glovebox light on? etc). (or maybe that's the load from listening for the fob to command the car to be unlocked????)

I used to park my car for a month at a time when in college so I'd lift the ground cable from the battery to ensure no discharge at all until I needed the car (but even this isn't adequate for several months at a time).

Until you get this car problem sorted I'd suggest doing the same if you can.

My modern Euro-sedan has a lot of loads in it. So much so that I believe the battery would be flat in 3 weeks. So it gets the top-up charger treatment when I won't be driving it for several days.