Keyboard ribbon cable problems! Not switching on.

After a battery replacement, more than half of the keyboard stopped working. I decided to check if all cables were plugged in properly and upon removing the keyboard ribbon cable I accidentally broke off half of the locking mechanism. I didnt think much of it until the Macbook didnt power up anymore. I have tried the tape trick to get the cable in, but it doesnt seem to connect properly. The macbook only switches on if I hold the cable down with force, but still the same issue with non working keys. So basically I need 2 things. A solution for the powering up issue and a fully working keyboard.

Photo:

https://drive.google.com/open?id=1IVd1Lz...