Materials and Mechanisms of Photo-Assisted Chemical Reactions under Light and Dark Conditions: Can Day-Night Photocatalysis Be Achieved?