Drunk cop fired after he’s found slumped over the wheel of patrol car - police