Periodic pattern formation in the coupled chemotaxis-(Navier–)Stokes system with mixed nonhomogeneous boundary conditions