Transition metal complexes of symmetrical and asymmetrical Schiff bases as antibacterial, antifungal, antioxidant, and anticancer agents: progress and prospects