Windows, Mirrors and Doors Issues

Hi all,

Looking at purchasing a 2010 Superb 2.0l SE at 160,000miles. Engine history looks confidence inspiring but it has a few electrical issues that are either a common fix, or a big deal, and I'm trying to work out if its worth taking the project on.

Drivers (right hand) door only opens using key manually in lock.

All other central locking works ok.
Rear o/s door does not open from in or out (deadlocked)
Both front windows and mirrors temperamental.

Looks like the cables through the drivers door have a had small solder/fix at some point.

Is this likely a simple DIY job with a new wiring harness, or a quick fix for an auto electrician, or might something larger be at play here? ordering a full loom?

I have read the many similar threads on here, but its a bit of mission trying to decipher them all, so any advice much appreciated.