The pedals make the back wheel go round and the front brake stops the front wheel from going round so technically it's usable on the roads, but the gear cables aren't attached yet and the back V-brake needs replacing.
Total damage will be new cables (outers were fine with a bit of grease), new rear brake calipers, and new rear derailleur (the old one was fine apart from the barrel adjuster which broke off in the thread and I made a mess of trying to get the remainder out). New cassette and chain would have been routine maintenance anyway so doesn't really count.
The crankset is functioning but not at all pretty - the pedal bearings are a bit ropey but the pedals seem to be welded to the cranks so it may be a case of replacing everything once the pedals are no longer acceptable.
I'll take a photo once it's done and the wee guy is on it, he's going to help me stay in Zone 2 on my lunchtime rides.