public static function getUserInfo(User $user)
{
$query = "SELECT DISTINCT s.SCL_ID, s.NAME, c.cls_id, c.name\n FROM CS_SHKET.USR u\n INNER JOIN CS_SHKET.USER_IN_SCL_CLS uc on u.USR_ID = uc.USR_ID\n INNER JOIN CS_SHKET.CLS c on c.SCL_ID = uc.SCL_ID AND c.CLS_ID = uc.cls_id\n INNER JOIN CS_SHKET.scl s on s.SCL_ID = uc.SCL_ID\n WHERE u.ROLE_ID = ? and u.del <> 1 and uc.del<> 1 and c.del <> 1 and s.del <> 1\n AND u.USR_ID = ?";
$result = self::$db_instance->getAll($query, [$user->getRoleId(), $user->getId()]);
return $result;
}
