Nonlinear Schrödinger systems with trapping potentials for mixed attractive and repulsive interactions