Advances and Frontiers of LLM-based Issue Resolution in Software Engineering: A Comprehensive Survey