Any competent electronic shop can repair that in less than 10 minutes.  Check your area for "Electronic Contract Manufacturer".  They'll probably charge you tech time at 40-100 bucks per hour (depending on area of the country), but it's a piece of cake repair.  Yeah, the pads and some of the traces have been ripped off, but that's no big deal for anyone who is a real technician.

If there are no Electronic CM's in your area, try a HAM Radio repair shop - some of those guys are pretty darn good.

I can't even tell you how many USB/HDMI/etc connectors I've fixed for people who did the exact same thing.  Solder connector in place, solder pins to any remaining pads/traces, use wire-wrap wire to extend pins to missing pads/traces.  Easy as pie.  Add a few dabs of scotchcast for good measure so that the connector can NEVER again be ripped off.

Best of luck,
Enigma