Move QR code generation to utility function
Move URL hit incrementing to a manager method
Lowercase utm_ parameters before insertion