could i follow some soldering guide or is this beyond repair
As far as I can see, the contacts were been ripped off. You could try scratch away the coating in the lines above and try to get a connection there but I think you need some experience to do that