When Text Embedding Meets Large Language Model: A Comprehensive Survey