'Down to F---': San Diego Cop Resigns After Locking Himself in Back Seat of Police Car With Female Suspect Who Propositioned Him