Index: backend/src/main/java/com/shifterwebapp/shifter/config/SecurityConfig.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/config/SecurityConfig.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/config/SecurityConfig.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -50,5 +50,5 @@ public CorsConfigurationSource corsConfigurationSource() { CorsConfiguration config = new CorsConfiguration(); - config.addAllowedOrigin("http://localhost:5173"); // your frontend origin + config.addAllowedOriginPattern("http://localhost:*"); config.addAllowedHeader("*"); config.addAllowedMethod("*"); Index: backend/src/main/java/com/shifterwebapp/shifter/course/Course.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/Course.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/Course.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -33,10 +33,8 @@ private String title; - private String topic; - @Enumerated(EnumType.STRING) private Difficulty difficulty; - - private Double durationHours; + + private Integer durationMinutes; private Double price; @@ -54,4 +52,7 @@ private String descriptionLong; + @ElementCollection + @Column(columnDefinition = "text") + private List whatWillBeLearned; @ElementCollection(targetClass = Skills.class) @@ -61,5 +62,5 @@ @ElementCollection(targetClass = Interests.class) @Enumerated(EnumType.STRING) - private List whatWillBeLearned; + private List topicsCovered; @OneToMany(mappedBy = "course", orphanRemoval = true) // IS THIS GOOD BUSINESS LOGIC? SHOULD I HAVE CASCADES? Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseController.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseController.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseController.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -8,7 +8,10 @@ import com.shifterwebapp.shifter.enums.Interests; import com.shifterwebapp.shifter.enums.Skills; +import com.shifterwebapp.shifter.user.User; +import com.shifterwebapp.shifter.user.service.UserService; import lombok.RequiredArgsConstructor; import org.springframework.data.jpa.domain.Specification; import org.springframework.http.ResponseEntity; +import org.springframework.security.core.Authentication; import org.springframework.web.bind.annotation.*; @@ -22,4 +25,5 @@ private final CourseService courseService; + private final UserService userService; @GetMapping @@ -59,12 +63,29 @@ } - List courseDtos = courseService.getAllCourses(spec); + List courseDtos = courseService.getAllCourses(spec); + return ResponseEntity.ok(courseDtos); + } - return ResponseEntity.ok(courseDtos); + @GetMapping("/recommended") + public ResponseEntity getRecommendedCourses(Authentication authentication) { + if (authentication == null || !authentication.isAuthenticated()) { + List topRatedCourses = courseService.getTopRatedCourses(); +// List mostPopularCourses = courseService.getMostPopularCourses(); + return ResponseEntity.ok(topRatedCourses.subList(0, 5)); + } + + String userEmail = authentication.getName(); + User user = userService.getUserByEmail(userEmail); + + List userSkills = user.getSkills(); + List userInterests = user.getInterests(); + + List recommendedCourses = courseService.getRecommendedCourses(userSkills, userInterests); + return ResponseEntity.ok(recommendedCourses); } @GetMapping("/{courseId}") public ResponseEntity getCourseById(@PathVariable("courseId") Long courseId) { - CourseDto courseDto = courseService.getCourseById(courseId); + CourseDtoDetail courseDto = courseService.getCourseById(courseId); return ResponseEntity.ok(courseDto); } Index: ckend/src/main/java/com/shifterwebapp/shifter/course/CourseDto.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseDto.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ (revision ) @@ -1,53 +1,0 @@ -package com.shifterwebapp.shifter.course; - -import com.shifterwebapp.shifter.enums.Difficulty; -import com.shifterwebapp.shifter.coursecontent.CourseContentDto; -import com.shifterwebapp.shifter.enums.Interests; -import com.shifterwebapp.shifter.enums.Skills; -import lombok.AllArgsConstructor; -import lombok.Data; -import lombok.NoArgsConstructor; - -import java.util.List; - -@Data -@NoArgsConstructor -@AllArgsConstructor -public class CourseDto { - - private Long id; - - private String imageUrl; - - private String color; - - private String titleShort; - - private String title; - - private String topic; - - private Difficulty difficulty; - - private Double durationHours; - - private Double price; - - private Integer rating; - - private Integer ratingCount; - - private String descriptionShort; - - private String description; - - private String descriptionLong; - - private List skillsGained; - - private List whatWillBeLearned; - - // DO I NEED THIS ??? -// private List courseContents; -} - Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoDetail.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoDetail.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoDetail.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,55 @@ +package com.shifterwebapp.shifter.course; + +import com.shifterwebapp.shifter.coursecontent.CourseContentDto; +import com.shifterwebapp.shifter.enums.Difficulty; +import com.shifterwebapp.shifter.enums.Interests; +import com.shifterwebapp.shifter.enums.Skills; +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.NoArgsConstructor; + +import java.util.List; + +@Data +@NoArgsConstructor +@AllArgsConstructor +public class CourseDtoDetail { + + private Long id; + + private String imageUrl; + + private String color; + + private String titleShort; + + private String title; + + private Difficulty difficulty; + + private Integer durationMinutes; + + private Double price; + + private Integer rating; + + private Integer ratingCount; + + private List skillsGained; + + private List topicsCovered; + +// NEW FOR DETAILED DTO + + private String descriptionShort; + + private String description; + + private String descriptionLong; + + private List whatWillBeLearned; + + private List courseContents; +} + Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoPreview.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseDtoPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,41 @@ +package com.shifterwebapp.shifter.course; + +import com.shifterwebapp.shifter.enums.Difficulty; +import com.shifterwebapp.shifter.enums.Interests; +import com.shifterwebapp.shifter.enums.Skills; +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.NoArgsConstructor; + +import java.util.List; + +@Data +@NoArgsConstructor +@AllArgsConstructor +public class CourseDtoPreview { + + private Long id; + + private String imageUrl; + + private String color; + + private String titleShort; + + private String title; + + private Difficulty difficulty; + + private Integer durationMinutes; + + private Double price; + + private Integer rating; + + private Integer ratingCount; + + private List skillsGained; + + private List topicsCovered; +} + Index: ckend/src/main/java/com/shifterwebapp/shifter/course/CourseMapper.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapper.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ (revision ) @@ -1,17 +1,0 @@ -package com.shifterwebapp.shifter.course; - -import org.mapstruct.InheritInverseConfiguration; -import org.mapstruct.Mapper; -import java.util.List; - -@Mapper(componentModel = "spring") -public interface CourseMapper { - - CourseDto toDto(Course course); - List toDto(List courses); - - @InheritInverseConfiguration - Course toEntity(CourseDto courseDto); - @InheritInverseConfiguration - List toEntity(List courseDtos); -} Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperDetail.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperDetail.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperDetail.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,19 @@ +package com.shifterwebapp.shifter.course; + +import org.mapstruct.InheritInverseConfiguration; +import org.mapstruct.Mapper; +import org.mapstruct.Mapping; + +import java.util.List; + +@Mapper(componentModel = "spring") +public interface CourseMapperDetail { + + CourseDtoDetail toDto(Course course); + List toDto(List courses); + + @InheritInverseConfiguration + Course toEntity(CourseDtoDetail courseDto); + @InheritInverseConfiguration + List toEntity(List courseDtos); +} Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperPreview.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseMapperPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,19 @@ +package com.shifterwebapp.shifter.course; + +import org.mapstruct.InheritInverseConfiguration; +import org.mapstruct.Mapper; +import org.mapstruct.Mapping; + +import java.util.List; + +@Mapper(componentModel = "spring") +public interface CourseMapperPreview { + + CourseDtoPreview toDto(Course course); + List toDto(List courses); + + @InheritInverseConfiguration + Course toEntity(CourseDtoPreview courseDto); + @InheritInverseConfiguration + List toEntity(List courseDtos); +} Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseRepository.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseRepository.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseRepository.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -14,5 +14,9 @@ List findCoursesByTitle(String searchTitle); - List findCoursesByTopic(String searchTopic); + @Query("select c from Course c order by c.rating/c.ratingCount desc") + List findCoursesOrderedByRating(); + + @Query("select c from Course c order by size(c.enrollments) desc") + List findCoursesOrderedByPopularity(); List findCoursesByDifficulty(Difficulty searchDifficulty); @@ -21,12 +25,9 @@ List findCoursesByPriceRange(@Param("floorPrice") Float floorPrice,@Param("ceilPrice") Float ceilPrice); - @Query("select c from Course c where c.durationHours >= :floorDuration and c.durationHours <= :ceilDuration") - List findCoursesByDurationHoursRange(@Param("floorDuration") Float floorDuration, @Param("ceilDuration") Float ceilDuration); - List findCoursesBySkillsGainedIn(List searchSkills); List findCoursesByDifficultyIn(List searchDifficulties); - @Query("select distinct c.whatWillBeLearned from Course c") + @Query("select distinct c.topicsCovered from Course c") List getCourseTopics(); Index: backend/src/main/java/com/shifterwebapp/shifter/course/CourseSpecification.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/CourseSpecification.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/CourseSpecification.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -15,18 +15,12 @@ public class CourseSpecification { - public static Specification hasTitleLike(String title) { - return (root, query, cb) -> - cb.like(cb.lower(root.get("title")), "%" + title.toLowerCase() + "%"); - } - public static Specification hasSearchLike(String search) { return (root, query, cb) -> { query.distinct(true); Join skillsJoin = root.join("skillsGained", JoinType.LEFT); - Join topicsJoin = root.join("whatWillBeLearned", JoinType.LEFT); + Join topicsJoin = root.join("topicsCovered", JoinType.LEFT); return cb.or( cb.like(cb.lower(root.get("title")), "%" + search.toLowerCase() + "%"), - cb.like(cb.lower(root.get("topic")), "%" + search.toLowerCase() + "%"), cb.like(cb.lower(root.get("descriptionShort")), "%" + search.toLowerCase() + "%"), cb.like(cb.lower(root.get("description")), "%" + search.toLowerCase() + "%"), @@ -36,9 +30,4 @@ ); }; - } - - public static Specification hasTopicLike(String topic) { - return (root, query, cb) -> - cb.like(cb.lower(root.get("topic")), "%" + topic.toLowerCase() + "%"); } @@ -52,5 +41,5 @@ public static Specification hasTopics(List topics) { - return (root, query, cb) -> root.join("whatWillBeLearned").in(topics); + return (root, query, cb) -> root.join("topicsCovered").in(topics); } @@ -93,14 +82,14 @@ switch (duration) { case "extraShort": - predicates.add(cb.lessThanOrEqualTo(root.get("durationHours"), 3.0)); + predicates.add(cb.lessThanOrEqualTo(root.get("durationMinutes"), 3.0 * 60.0)); break; case "short": - predicates.add(cb.between(root.get("durationHours"), 3.0, 6.0)); + predicates.add(cb.between(root.get("durationMinutes"), 3.0 * 60.0, 6.0 * 60.0)); break; case "medium": - predicates.add(cb.between(root.get("durationHours"), 6.0, 10.0)); + predicates.add(cb.between(root.get("durationMinutes"), 6.0 * 60.0, 10.0 * 60.0)); break; case "long": - predicates.add(cb.greaterThanOrEqualTo(root.get("durationHours"), 10.0)); + predicates.add(cb.greaterThanOrEqualTo(root.get("durationMinutes"), 10.0 * 60.0)); break; } Index: backend/src/main/java/com/shifterwebapp/shifter/course/ScoredCourse.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/ScoredCourse.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/course/ScoredCourse.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,13 @@ +package com.shifterwebapp.shifter.course; + +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.NoArgsConstructor; + +@Data +@AllArgsConstructor +@NoArgsConstructor +public class ScoredCourse { + private Course course; + private Integer score; +} Index: backend/src/main/java/com/shifterwebapp/shifter/course/service/CourseService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/service/CourseService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/service/CourseService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -11,4 +11,5 @@ import org.springframework.stereotype.Service; +import java.util.ArrayList; import java.util.List; @@ -18,21 +19,71 @@ private final CourseRepository courseRepository; - private final CourseMapper courseMapper; - private final CourseContentMapper courseContentMapper; + private final CourseMapperPreview courseMapperPreview; + private final CourseMapperDetail courseMapperDetail; private final Validate validate; @Override - public List getAllCourses(Specification specification) { + public List getAllCourses(Specification specification) { List courses = specification == null ? courseRepository.findAll() : courseRepository.findAll(specification); - return courseMapper.toDto(courses); + return courseMapperPreview.toDto(courses); } @Override - public CourseDto getCourseById(Long courseId) { + public List getRecommendedCourses(List skills, List interests) { + List courses = courseRepository.findAll(); + + List scoredCourses = new ArrayList<>(); + for (Course course : courses) { + boolean matchesSkills = course.getSkillsGained().stream().anyMatch(skills::contains); + boolean matchesInterests = course.getWhatWillBeLearned().stream().anyMatch(interests::contains); + + int score = 0; + if (matchesSkills && matchesInterests) { + score += 2; + } else if (matchesSkills || matchesInterests) { + score += 1; + } + + if (score > 0) + scoredCourses.add(new ScoredCourse(course, score)); + } + + scoredCourses.sort((a, b) -> Integer.compare(b.getScore(), a.getScore())); + + if (scoredCourses.size() < 5) { + courses.sort((a, b) -> Integer.compare(b.getRating()/b.getRatingCount(), a.getRating()/a.getRatingCount())); + + while (scoredCourses.size() < 5) + scoredCourses.add(new ScoredCourse(courses.remove(0), 0)); + } + + return scoredCourses + .subList(0, 5) + .stream() + .map(ScoredCourse::getCourse) + .map(courseMapperPreview::toDto) + .toList(); + } + + @Override + public List getTopRatedCourses() { + List courses = courseRepository.findCoursesOrderedByRating(); + return courseMapperPreview.toDto(courses); + } + + @Override + public List getMostPopularCourses() { + List courses = courseRepository.findCoursesOrderedByPopularity(); + return courseMapperPreview.toDto(courses); + } + + + @Override + public CourseDtoDetail getCourseById(Long courseId) { validate.validateCourseExists(courseId); Course course = courseRepository.findById(courseId).orElseThrow(); - return courseMapper.toDto(course); + return courseMapperDetail.toDto(course); } @@ -46,54 +97,3 @@ return courseRepository.getCourseSkills(); } - - @Override - public CourseDto createCourse(CourseDto request) { - Course course = Course.builder() - .title(request.getTitle()) - .topic(request.getTopic()) - .difficulty(request.getDifficulty()) - .durationHours(request.getDurationHours()) - .price(request.getPrice()) - .rating(request.getRating()) - .ratingCount(request.getRatingCount()) - .descriptionShort(request.getDescriptionShort()) - .description(request.getDescription()) - .descriptionLong(request.getDescriptionLong()) - .skillsGained(request.getSkillsGained()) - .whatWillBeLearned(request.getWhatWillBeLearned()) -// .courseContents(courseContentMapper.toEntity(request.getCourseContents())) // ?????? - .build(); - - return courseMapper.toDto(course); - } - - @Override - public List searchCoursesByTitle(String searchTitle) { - List courses = courseRepository.findCoursesByTitle(searchTitle); - return courseMapper.toDto(courses); - } - - @Override - public List searchCoursesByTopic(String searchTopic) { - List courses = courseRepository.findCoursesByTopic(searchTopic); - return courseMapper.toDto(courses); - } - - @Override - public List searchCoursesByDifficulties(List searchDifficulties) { - List courses = courseRepository.findCoursesByDifficultyIn(searchDifficulties); - return courseMapper.toDto(courses); - } - - @Override - public List searchCoursesByDurationHours(Float floorHours, Float ceilHours) { - List courses = courseRepository.findCoursesByDurationHoursRange(floorHours, ceilHours); - return courseMapper.toDto(courses); - } - - @Override - public List searchCoursesBySkillsGained(List searchSkills) { - List courses = courseRepository.findCoursesBySkillsGainedIn(searchSkills); - return courseMapper.toDto(courses); - } } Index: backend/src/main/java/com/shifterwebapp/shifter/course/service/ImplCourseService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/course/service/ImplCourseService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/course/service/ImplCourseService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -2,5 +2,6 @@ import com.shifterwebapp.shifter.course.Course; -import com.shifterwebapp.shifter.course.CourseDto; +import com.shifterwebapp.shifter.course.CourseDtoDetail; +import com.shifterwebapp.shifter.course.CourseDtoPreview; import com.shifterwebapp.shifter.enums.Difficulty; import com.shifterwebapp.shifter.enums.Interests; @@ -11,18 +12,11 @@ public interface ImplCourseService { - List getAllCourses(Specification specification); - CourseDto getCourseById(Long id); + List getAllCourses(Specification specification); + List getRecommendedCourses(List skills, List topics); + List getTopRatedCourses(); + List getMostPopularCourses(); + CourseDtoDetail getCourseById(Long id); List getAllTopics(); List getAllSkills(); - - CourseDto createCourse(CourseDto request); - - List searchCoursesByTitle(String searchTitle); - List searchCoursesByTopic(String searchTopic); - List searchCoursesByDifficulties(List searchDifficulty); - List searchCoursesByDurationHours(Float floorHours, Float ceilHours); - List searchCoursesBySkillsGained(List searchSkills); - - } Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContent.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContent.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContent.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -2,7 +2,10 @@ import com.shifterwebapp.shifter.course.Course; +import com.shifterwebapp.shifter.courselecture.CourseLecture; import jakarta.persistence.*; import com.shifterwebapp.shifter.enums.ContentType; import lombok.*; + +import java.util.List; @Getter @@ -15,6 +18,4 @@ @Id -// @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "course_seq") -// @SequenceGenerator(name = "course_seq", sequenceName = "course_sequence", allocationSize = 1) @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @@ -24,8 +25,6 @@ private Integer position; - private String contentURL; - - @Enumerated(EnumType.STRING) - private ContentType contentType; + @OneToMany(mappedBy = "courseContent", cascade = CascadeType.ALL, orphanRemoval = true) + private List courseLectures; @ManyToOne Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentController.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentController.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentController.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,23 @@ +package com.shifterwebapp.shifter.coursecontent; + +import com.shifterwebapp.shifter.coursecontent.service.CourseContentService; +import lombok.RequiredArgsConstructor; +import org.springframework.http.ResponseEntity; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + +@RestController +@RequiredArgsConstructor +@RequestMapping("${api.base.path}/course-content") +@CrossOrigin +public class CourseContentController { + + private final CourseContentService courseContentService; + + @GetMapping("/{courseId}") + public ResponseEntity getCourseContent(@PathVariable Long courseId) { + List courseContents = courseContentService.getCourseContentByCourseId(courseId); + return ResponseEntity.ok(courseContents); + } +} Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentDto.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentDto.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -1,8 +1,11 @@ package com.shifterwebapp.shifter.coursecontent; +import com.shifterwebapp.shifter.courselecture.CourseLecturePreviewDto; import com.shifterwebapp.shifter.enums.ContentType; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; + +import java.util.List; @Data @@ -11,15 +14,9 @@ public class CourseContentDto { - private Long id; - private String title; private Integer position; - private String contentURL; - - private ContentType contentType; - - private Integer courseId; + private List courseLectures; } Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentMapper.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentMapper.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentMapper.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -1,6 +1,4 @@ package com.shifterwebapp.shifter.coursecontent; -import com.shifterwebapp.shifter.course.Course; -import com.shifterwebapp.shifter.course.CourseDto; import org.mapstruct.InheritInverseConfiguration; import org.mapstruct.Mapper; Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentRepository.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentRepository.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/CourseContentRepository.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -3,4 +3,8 @@ import org.springframework.data.jpa.repository.JpaRepository; +import java.util.List; + public interface CourseContentRepository extends JpaRepository { + + List getCourseContentByCourse_Id(Long courseId); } Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/CourseContentService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/CourseContentService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/CourseContentService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -1,9 +1,24 @@ package com.shifterwebapp.shifter.coursecontent.service; +import com.shifterwebapp.shifter.coursecontent.CourseContent; +import com.shifterwebapp.shifter.coursecontent.CourseContentDto; +import com.shifterwebapp.shifter.coursecontent.CourseContentMapper; +import com.shifterwebapp.shifter.coursecontent.CourseContentRepository; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; + +import java.util.List; @Service @RequiredArgsConstructor public class CourseContentService implements ImplCourseContentService { + + private final CourseContentRepository courseContentRepository; + private final CourseContentMapper courseContentMapper; + + @Override + public List getCourseContentByCourseId(Long courseId) { + List courseContents = courseContentRepository.getCourseContentByCourse_Id(courseId); + return courseContentMapper.toDto(courseContents); + } } Index: backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/ImplCourseContentService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/ImplCourseContentService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/coursecontent/service/ImplCourseContentService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -3,5 +3,8 @@ import com.shifterwebapp.shifter.coursecontent.CourseContentDto; +import java.util.List; + public interface ImplCourseContentService { + List getCourseContentByCourseId(Long courseId); } Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecture.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecture.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecture.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,41 @@ +package com.shifterwebapp.shifter.courselecture; + +import com.shifterwebapp.shifter.coursecontent.CourseContent; +import jakarta.persistence.*; +import com.shifterwebapp.shifter.enums.ContentType; +import lombok.*; + +@Getter +@Setter +@NoArgsConstructor +@AllArgsConstructor +@Builder +@Entity +public class CourseLecture { + + @Id + @GeneratedValue(strategy = GenerationType.IDENTITY) + private Long id; + + private String title; + + @Column(columnDefinition = "text") + private String description; + + private Integer durationMinutes; + + private Integer position; + + @Column(columnDefinition = "text") + private String contentText; + + private String contentUrl; + + @Enumerated(EnumType.STRING) + private ContentType contentType; + + @ManyToOne + @JoinColumn(name = "course_content_id") + private CourseContent courseContent; +} + Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureFullDto.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureFullDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureFullDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,29 @@ +package com.shifterwebapp.shifter.courselecture; + +import com.shifterwebapp.shifter.coursecontent.CourseContent; +import com.shifterwebapp.shifter.enums.ContentType; +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.NoArgsConstructor; + +@Data +@AllArgsConstructor +@NoArgsConstructor +public class CourseLectureFullDto { + + private Long id; + + private String title; + + private String description; + + private Integer durationMinutes; + + private Integer position; + + private String contentText; + + private String contentUrl; + + private ContentType contentType; +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperFull.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperFull.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperFull.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,18 @@ +package com.shifterwebapp.shifter.courselecture; + +import org.mapstruct.InheritInverseConfiguration; +import org.mapstruct.Mapper; + +import java.util.List; + +@Mapper(componentModel = "spring") +public interface CourseLectureMapperFull { + + CourseLectureFullDto toDto(CourseLecture courseContent); + List toDto(List courseContents); + + @InheritInverseConfiguration + CourseLecture toEntity(CourseLectureFullDto courseContentDto); + @InheritInverseConfiguration + List toEntity(List courseContentDtos); +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperPreview.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureMapperPreview.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,18 @@ +package com.shifterwebapp.shifter.courselecture; + +import org.mapstruct.InheritInverseConfiguration; +import org.mapstruct.Mapper; + +import java.util.List; + +@Mapper(componentModel = "spring") +public interface CourseLectureMapperPreview { + + CourseLecturePreviewDto toDto(CourseLecture courseContent); + List toDto(List courseContents); + + @InheritInverseConfiguration + CourseLecture toEntity(CourseLecturePreviewDto courseContentDto); + @InheritInverseConfiguration + List toEntity(List courseContentDtos); +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecturePreviewDto.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecturePreviewDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLecturePreviewDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,22 @@ +package com.shifterwebapp.shifter.courselecture; + +import com.shifterwebapp.shifter.enums.ContentType; +import lombok.AllArgsConstructor; +import lombok.Data; +import lombok.NoArgsConstructor; + +@Data +@AllArgsConstructor +@NoArgsConstructor +public class CourseLecturePreviewDto { + + private String title; + + private String description; + + private Integer durationMinutes; + + private Integer position; + + private ContentType contentType; +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureRepository.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureRepository.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/CourseLectureRepository.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,6 @@ +package com.shifterwebapp.shifter.courselecture; + +import org.springframework.data.jpa.repository.JpaRepository; + +public interface CourseLectureRepository extends JpaRepository { +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/CourseLectureService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/CourseLectureService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/CourseLectureService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,4 @@ +package com.shifterwebapp.shifter.courselecture.service; + +public class CourseLectureService implements ImplCourseLectureService{ +} Index: backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/ImplCourseLectureService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/ImplCourseLectureService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/courselecture/service/ImplCourseLectureService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,4 @@ +package com.shifterwebapp.shifter.courselecture.service; + +public interface ImplCourseLectureService { +} Index: backend/src/main/java/com/shifterwebapp/shifter/enrollment/EnrollmentDto.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/enrollment/EnrollmentDto.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/enrollment/EnrollmentDto.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -1,8 +1,5 @@ package com.shifterwebapp.shifter.enrollment; -import com.shifterwebapp.shifter.course.CourseDto; import com.shifterwebapp.shifter.enums.EnrollmentStatus; -import com.shifterwebapp.shifter.payment.PaymentDto; -import com.shifterwebapp.shifter.review.ReviewDto; import lombok.AllArgsConstructor; import lombok.Data; Index: backend/src/main/java/com/shifterwebapp/shifter/enums/Interests.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/enums/Interests.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/enums/Interests.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -32,4 +32,7 @@ CONTINUOUS_IMPROVEMENT, TEAM_OPTIMIZATION, - SYSTEM_DESIGN + SYSTEM_DESIGN, + PARADIGM_CONCEPTS, + PERCEPTION_AND_PERSPECTIVE, + BUSINESS_AND_CAREER_FOUNDATIONS } Index: backend/src/main/java/com/shifterwebapp/shifter/enums/Skills.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/enums/Skills.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/enums/Skills.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -46,4 +46,7 @@ PROBLEM_SOLVING, NEGOTIATION, + PARADIGM_UNDERSTANDING, + PERCEPTION_MANAGEMENT, + PERSPECTIVE_SHIFTING, // ENTREPRENEURSHIP Index: ckend/src/main/java/com/shifterwebapp/shifter/sql/courseInitialize.sql =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/sql/courseInitialize.sql (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ (revision ) @@ -1,321 +1,0 @@ -INSERT INTO course (title_short, - title, - description_short, - description, - description_long, - difficulty, - duration_hours, - price, - rating, - rating_count, - topic, - image_url, - color) -VALUES - ( - 'Foundations for a Successful Business & Career', - 'Building New Paradigm / Perception & Perspective as Foundations for a Successful Business and Professional Career', - 'Understand how paradigms, perception, and perspective shape your business and career success.', - 'Explore the concept of paradigms and how perception and perspective influence your progress in business and professional life. Learn why incorrect use of perception and perspective can hinder your growth.', - 'This course delves into the foundational concepts of paradigms, perception, and perspective as critical factors in business and career development. You will learn what a paradigm is, how perception and perspective are interconnected, and why changing one requires changing the other. Understand the potential negative consequences of misused perception and perspective and how to harness them effectively for success.', - 'BEGINNER', - 3, - 0, - 47, - 10, - 'Business & Career Development', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751286550/Foundations_for_a_Successful_Business_Career_k8vcuu.jpg', - '#02C2FF' - ), - ( - 'From Manager to Leader', - 'From Manager to Leader: Empowering People, Managing Processes', - 'Transform your managerial skills into effective leadership.', - 'Learn to lead people and manage processes with proven leadership tools and models.', - 'This course is designed for managers who want to become impactful leaders. It covers the core principles of leadership such as the 3xH’s of generative leadership, the difference between responsibility and guilt, communication strategies, feedback, and models like AB, Min/Max, and SMART objectives. Gain the mindset and practical tools to lead teams effectively, break silos, delegate with confidence, and mentor others.', - 'INTERMEDIATE', - 3, - 29, - 48, - 10, - 'Leadership & Management', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/From_Manager_to_Leader_-_Empowering_People_Managing_Processes_vgoyoh.webp', - '#19C6D6' - ), - ( - 'Business Transformation Blueprint', - 'Business Transformation Blueprint: Crafting the Path to Success', - 'Design and implement successful business transformations.', - 'Master the framework for guiding organizations through structured, sustainable transformation.', - 'This course provides a complete blueprint for driving successful business transformations. You’ll learn to identify when transformation is needed, and why following the proper sequence of steps is critical. We explore the role of middle management, the six core stages of transformation (from purpose to KPIs), and how to establish agile and resilient structures. You’ll also develop a new paradigm and perspective to boost your business’s STABILITY, AGILITY, RESILIENCE, and SUSTAINABILITY.', - 'ADVANCED', - 5.5, - 54, - 49, - 10, - 'Business Strategy & Transformation', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Business_Transformation_Blueprint_-_Crafting_the_Path_to_Success_aimssk.jpg', - '#1FB0C3'), - ( - 'SME Business Roadmap', - 'Business Roadmap for SME’s: A Step-by-Step Guide for Establishing Core Business Foundations for Sustainable Growth', - 'Step-by-step guidance for SMEs to build solid business foundations.', - 'Cut through the noise and build sustainable business foundations with clarity and confidence.', - 'In today’s world of overwhelming information, especially around business growth, marketing, and sales strategies, it’s difficult to know where to begin. This course helps small and medium-sized businesses eliminate that confusion by providing a structured, step-by-step roadmap for building strong business foundations. Through a new paradigm and broadened perspective, you’ll increase your STABILITY, AGILITY, RESILIENCE, and SUSTAINABILITY while gaining clarity on what truly matters for long-term growth.', - 'INTERMEDIATE', - 6, - 35, - 49, - 10, - 'Entrepreneurship & SME Growth', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Business_Roadmap_for_SME_s_-_A_Step-by-Step_Guide_for_Establishing_Core_Business_Foundations_for_Sustainable_Growth_qeejox.jpg', - '#002E5D'), - ( - 'Sales Masterclass', - 'Sales Masterclass: Leadership, Communication, and Modern Sales Process', - 'Master modern sales strategies, leadership, and communication.', - 'A complete guide to building elite sales skills, behaviors, and mindset.', - 'This comprehensive masterclass is designed for sales professionals who want to excel in today’s fast-paced and client-centric environment. Learn the role of frontline salespeople, how to build team synergy, and understand the critical difference between being responsible and feeling guilty. Explore how silos hurt sales, how to manage time effectively, and what truly defines high-performance behavior. Master modern sales and negotiation techniques, improve communication and decision-making, and learn to lead with clarity and confidence. Includes practical tools like the AB model and marketing techniques tailored for salespeople.', - 'ADVANCED', - 4, - 29, - 47, - 10, - 'Sales & Communication', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Sales_Masterclass_-_Leadership_Communication_and_Modern_Sales_Process_v74qdh.webp', - '#034D4C'), - ( - 'Mastering Success Skills', - 'From Good to Extraordinary: Mastering Skills for Success', - 'Unlock your full potential with practical skills for extraordinary success.', - 'A holistic course for professionals aiming to elevate their effectiveness and mindset.', - 'This course is built for individuals who want to go from good to extraordinary in their personal and professional lives. You’ll explore key topics like perception, time management, managing expectations, and setting smart priorities. Learn and apply powerful tools like the AB and Min/Max models, the SMART objectives model, and the method of deduction. Develop cognitive skills, improve communication maturity, and boost your efficiency in meetings, decision-making, and real-world interactions. Focused on practical results, not just theory.', - 'INTERMEDIATE', - 6, - 35, - 48, - 10, - 'Personal Development & Productivity', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751032528/From_Good_to_Extraordinary_-_Mastering_Skills_for_Success_fm0io9.webp', - '#D0B8A3'), - ( - 'Winning Markets in 3 Steps', - 'Winning Markets in 3 Steps: Building a Clear Go-to-Market Strategy', - 'Build a clear, effective go-to-market strategy in just 3 steps.', - 'Learn to target the right clients and approach the market with clarity and confidence.', - 'Without a clear marketing strategy, businesses often drift without direction. This course shows you how to avoid that by creating a precise go-to-market strategy in 3 steps. Define your ideal target client using 8 key characteristics: needs, wants, expectations, challenges, fears, intentions, prejudices, and opportunities. Learn when, where, and how to reach your audience, using tools like the AB model and a quantification method for negotiation and sales. Includes real-world examples to help you implement a clear, winning strategy.', - 'INTERMEDIATE', - 5, - 29, - 49, - 10, - 'Market Strategy', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Winning_Markets_in_3_Steps_-_Building_a_Clear_Go-to-Market_Strategy_vayg15.png', - '#FF6F61'), - ( - 'How to Create Added Value', - 'Creating Added Value: How to Offer Solutions/Concepts, Instead of Services', - 'Shift from selling services to offering impactful solutions and concepts.', - 'Learn how to transition from offering services to delivering real value through solutions and long-term concepts.', - 'In this course, you’ll learn how to move beyond just offering products or services by creating added value through solutions and concepts. Understand the importance of knowing your target audience, identifying the problems your offering solves, and crafting offers that connect deeply with client needs. We’ll explore the difference between selling a service vs. a solution, and what it means to go a step further into creating a long-term concept. Includes real-world examples like the Nescafe Frape concept to bring theory to life.', - 'INTERMEDIATE', - 3.5, - 29, - 49, - 10, - 'Value Creation & Strategic Marketing', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Creating_Added_Value_-_How_to_Offer_SolutionsConcepts_Instead_of_Services_z9fs3c.png', - '#F5AD01'), - ( - 'Seamless Onboarding Strategy', - 'Onboarding Fundamentals: How to Successfully Incorporate New Employees', - 'Master the essentials of onboarding to boost retention and employee satisfaction.', - 'Learn how to create a structured onboarding experience that accelerates productivity and ensures long-term success.', - 'This course dives into the core principles of effective onboarding. You’ll learn how a well-designed onboarding process can significantly improve employee retention, boost engagement, and enhance workplace satisfaction. Discover how to help new employees smoothly integrate into company culture, quickly understand their roles, and feel empowered from day one. Practical strategies, examples, and onboarding templates are included to help you implement a seamless onboarding journey.', - 'BEGINNER', - 3, - 25, - 48, - 10, - 'HR & Talent Development', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Onboarding_Fundamentals_-_How_to_Successfully_Incorporate_New_Employees_bksbad.png', - '#008CC2'), - ( - 'Growth Through Self-Assessment', - 'Professional Self-Assessment: Identify Barriers Holding You Back & Areas for Improvement', - 'Use self-assessment tools to unlock growth and overcome personal barriers.', - 'Gain insight into your professional strengths, weaknesses, and areas for growth using proven self-assessment techniques.', - 'This course provides practical tools and frameworks to help you evaluate your professional performance and identify what’s holding you back. You’ll explore techniques like performance and need assessments, and learn to apply the method of deduction to draw clear conclusions about your development. Emphasis is placed on the role of efficiency and practical application in everyday work. Ideal for professionals looking to grow in self-awareness, accountability, and effectiveness.', - 'BEGINNER', - 2.5, - 25, - 47, - 10, - 'Personal Growth & Career Development', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Professional_Self-Assessment_-_Identify_Barriers_Holding_You_Back_Areas_for_Improvement_tiyydc.jpg', - '#CC6232'), - ( - 'Business Excellence Blueprint', - 'Establishing Continuous Business Excellence in Your Company', - 'Create a high-performance culture through proven excellence frameworks.', - 'Learn how to implement continuous improvement models to optimize operations, team alignment, and long-term success.', - 'This course is designed for professionals and leaders who want to embed a culture of excellence within their organization. You’ll explore powerful models such as the Effective Meetings Model, AB model, DF model, and pre/post evaluation frameworks. Learn how to map and address organizational disproportions and improve performance across all departments. By the end, you’ll be equipped with tools to drive consistency, accountability, and strategic growth across your company.', - 'ADVANCED', - 4, - 39, - 49, - 10, - 'Operational Excellence & Leadership', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028998/Establishing_Continuous_Business_Excellence_in_Your_Company_g3yvao.png', - '#18898D'), - ( - 'Organizational Success Through Structure', - 'High-Performing Teams and Systems: Organizational Success Through Structure', - 'Build efficient, structured teams and systems that drive sustainable organizational success.', - 'Explore how to structure your teams and systems to optimize performance, efficiency, and collaboration across your organization.', - 'This course focuses on creating high-performing teams by implementing structured systems and eliminating inefficiencies. Learn how to apply a systematic approach to team organization, overcome the pitfalls of working in silos, and increase alignment through effective meetings, communication, confrontation, and decision-making practices. Ideal for team leaders and managers seeking a structured path to operational excellence.', - 'INTERMEDIATE', - 3.5, - 32, - 48, - 10, - 'Team Management & Organizational Structure', - 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/High-Performing_Teams_and_Systems_-_Organizational_Success_Through_Structure_b6jvm5.jpg', - '#FF9503'); - -INSERT INTO course_skills_gained (course_id, skills_gained) VALUES --- 1. From Manager to Leader -(1, 'LEADERSHIP'), -(1, 'DELEGATION'), -(1, 'DECISION_MAKING'), -(1, 'PEOPLE_MANAGEMENT'), - --- 2. Business Transformation Blueprint -(2, 'STRATEGIC_PLANNING'), -(2, 'CHANGE_MANAGEMENT'), -(2, 'PROJECT_MANAGEMENT'), -(2, 'RISK_MANAGEMENT'), - --- 3. Business Roadmap for SME’s -(3, 'BUSINESS_MODEL_CREATION'), -(3, 'STRATEGIC_THINKING'), -(3, 'OPERATION_MANAGEMENT'), - --- 4. Sales Masterclass -(4, 'SALES'), -(4, 'COMMUNICATION'), -(4, 'NEGOTIATION'), -(4, 'LEADERSHIP'), - --- 5. From Good to Extraordinary -(5, 'COMMUNICATION'), -(5, 'DECISION_MAKING'), -(5, 'CRITICAL_THINKING'), -(5, 'EMOTIONAL_INTELLIGENCE'), - --- 6. Winning Markets in 3 Steps -(6, 'MARKETING'), -(6, 'SALES'), -(6, 'STRATEGIC_THINKING'), - --- 7. Creating Added Value -(7, 'OPPORTUNITY_IDENTIFICATION'), -(7, 'INNOVATION_MANAGEMENT'), -(7, 'MARKETING'), - --- 8. Onboarding Fundamentals -(8, 'PEOPLE_MANAGEMENT'), -(8, 'TEAM_BUILDING'), -(8, 'COMMUNICATION'), - --- 9. Professional Self-Assessment -(9, 'EMOTIONAL_INTELLIGENCE'), -(9, 'CRITICAL_THINKING'), -(9, 'COMMUNICATION'), - --- 10. Establishing Continuous Business Excellence -(10, 'PROJECT_MANAGEMENT'), -(10, 'PERFORMANCE_EVALUATION'), -(10, 'CHANGE_MANAGEMENT'), -(10, 'STRATEGIC_PLANNING'), - --- 11. High-Performing Teams and Systems -(11, 'TEAM_BUILDING'), -(11, 'OPERATION_MANAGEMENT'), -(11, 'PEOPLE_MANAGEMENT'), -(11, 'PERFORMANCE_EVALUATION'); - - -INSERT INTO course_what_will_be_learned (course_id, what_will_be_learned) VALUES --- 1. From Manager to Leader -(1, 'LEADERSHIP'), -(1, 'MANAGEMENT'), -(1, 'COMMUNICATION'), -(1, 'TEAM_DEVELOPMENT'), -(1, 'DECISION_MAKING'), - --- 2. Business Transformation Blueprint -(2, 'BUSINESS_TRANSFORMATION'), -(2, 'DIGITAL_TRANSFORMATION'), -(2, 'CHANGE_MANAGEMENT'), -(2, 'STRATEGIC_PLANNING'), -(2, 'AGILITY'), - --- 3. Business Roadmap for SME’s -(3, 'ENTREPRENEURSHIP'), -(3, 'STARTUP_METHODS'), -(3, 'BUSINESS_TRANSFORMATION'), -(3, 'STRATEGIC_PLANNING'), -(3, 'OPERATIONAL_EXCELLENCE'), - --- 4. Sales Masterclass -(4, 'SALES_STRATEGIES'), -(4, 'NEGOTIATION'), -(4, 'LEADERSHIP'), -(4, 'COMMUNICATION'), -(4, 'CLIENT_RELATIONSHIPS'), - --- 5. From Good to Extraordinary -(5, 'PERSONAL_GROWTH'), -(5, 'LEADERSHIP'), -(5, 'COMMUNICATION'), -(5, 'TIME_MANAGEMENT'), -(5, 'DECISION_MAKING'), - --- 6. Winning Markets in 3 Steps -(6, 'SALES_STRATEGIES'), -(6, 'MARKETING'), -(6, 'GO_TO_MARKET_STRATEGY'), -(6, 'CLIENT_TARGETING'), - --- 7. Creating Added Value -(7, 'MARKETING'), -(7, 'SALES'), -(7, 'VALUE_CREATION'), -(7, 'BUSINESS_INNOVATION'), - --- 8. Onboarding Fundamentals -(8, 'HR'), -(8, 'MANAGEMENT'), -(8, 'LEADERSHIP'), -(8, 'CULTURE_INTEGRATION'), - --- 9. Professional Self-Assessment -(9, 'PERSONAL_GROWTH'), -(9, 'LEADERSHIP'), -(9, 'SELF_AWARENESS'), -(9, 'PERFORMANCE_IMPROVEMENT'), - --- 10. Establishing Continuous Business Excellence -(10, 'MANAGEMENT'), -(10, 'BUSINESS_TRANSFORMATION'), -(10, 'CONTINUOUS_IMPROVEMENT'), -(10, 'STRATEGIC_PLANNING'), -(10, 'AGILITY'), - --- 11. High-Performing Teams and Systems -(11, 'MANAGEMENT'), -(11, 'LEADERSHIP'), -(11, 'BUSINESS_TRANSFORMATION'), -(11, 'TEAM_OPTIMIZATION'), -(11, 'SYSTEM_DESIGN'); Index: backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourse.sql =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourse.sql (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourse.sql (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,420 @@ +INSERT INTO course (title_short, + title, + description_short, + description, + description_long, + difficulty, + duration_minutes, + price, + rating, + rating_count, + image_url, + color) +VALUES ('Foundations for a Successful Business & Career', + 'Building New Paradigm / Perception & Perspective as Foundations for a Successful Business and Professional Career', + 'Understand how paradigms, perception, and perspective shape your business and career success.', + 'Explore how paradigms shape your thinking, and how perception and perspective impact your professional and personal growth. In this course, you’ll uncover why shifting these mental models is crucial for unlocking new opportunities and overcoming hidden barriers. You’ll also learn how to use these concepts to build a resilient foundation that supports confident decision-making and continuous improvement in business and career contexts.', + 'This comprehensive course deeply explores the powerful concepts of paradigms, perception, and perspective as they relate to business and professional growth. You''ll gain a thorough understanding of what paradigms are — deeply ingrained mental frameworks that shape how you interpret and interact with the world around you. You''ll learn how perception (your interpretation of external events) and perspective (your angle or approach) are interconnected and influence every decision and action you take. We examine common pitfalls that professionals encounter when they hold rigid paradigms or outdated perspectives, preventing them from adapting to change and seizing opportunities. Through practical exercises, real-life case studies, and reflective assessments, you''ll learn how to identify and reframe limiting paradigms to adopt a growth-oriented mindset that supports continuous improvement. You''ll explore advanced strategies to strengthen self-awareness and emotional intelligence, crucial skills for leadership and personal development. Additionally, we delve into subtle but critical differences between perception and perspective and how misalignment can undermine even the most skilled professionals. By the end of this course, you''ll have a robust framework for self-assessment and practical tools to shift your mental models, enhance decision-making, and achieve sustainable success in your business and career.', + 'BEGINNER', 221, 0, 47, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751286550/Foundations_for_a_Successful_Business_Career_k8vcuu.jpg', + '#02C2FF'), + + ('From Manager to Leader', + 'From Manager to Leader: Empowering People, Managing Processes', + 'Transform your managerial skills into effective leadership.', + 'Learn how to shift from simply managing tasks to truly leading with purpose and clarity. In this course, you will explore leadership mindsets, communication strategies, and practical tools to empower your team, foster accountability, and create a motivating environment. You will also understand how to balance responsibility and delegation while cultivating a strong culture of trust and performance within your organization.', + 'This course is designed for managers who aspire to become impactful leaders capable of driving both people and processes to success. You''ll learn about generative leadership and the 3xH''s model (Head, Heart, and Hands), which helps leaders balance logic, emotion, and action. Discover the fundamental differences between responsibility and guilt, and how to build a strong foundation for team accountability. The course covers vital communication strategies, effective feedback methods, and advanced delegation skills, ensuring that you empower rather than micromanage your team. You''ll explore leadership models like AB, Min/Max, and SMART objectives to clarify goals and expectations. Practical scenarios and real-world case studies will help you understand common challenges faced by managers as they step into leadership roles, including breaking organizational silos and fostering cross-functional collaboration. Additionally, you will learn how to mentor and develop future leaders, cultivate a culture of trust and innovation, and handle difficult conversations with grace. By the end, you''ll possess a complete toolkit to inspire, guide, and lead with confidence and authenticity, making you a true catalyst for organizational success.', + 'INTERMEDIATE', 242, 29, 48, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/From_Manager_to_Leader_-_Empowering_People_Managing_Processes_vgoyoh.webp', + '#19C6D6'), + + ('Business Transformation Blueprint', + 'Business Transformation Blueprint: Crafting the Path to Success', + 'Design and implement successful business transformations.', + 'Master a detailed, step-by-step framework designed to guide your business through structured, sustainable transformation. In this course, you will learn how to align teams around a clear purpose, engage middle management, establish effective KPIs, and implement change initiatives that ensure long-term resilience and growth. Discover how to create agile structures and overcome resistance to change with confidence.', + 'This course serves as a complete roadmap for leaders and strategists who want to guide their organizations through impactful, sustainable transformation. You will learn how to recognize when transformation is necessary, understand its drivers, and define a clear purpose and direction. The program unpacks the six essential stages of transformation: from establishing a powerful purpose to developing robust KPIs that measure progress and success. You''ll explore the pivotal role middle management plays as both champions and gatekeepers of change, and how to effectively engage them in the process. Through detailed exploration of each transformation stage, you will understand the importance of sequential execution to avoid chaos and resistance. The course also emphasizes building agile and resilient organizational structures that can adapt to market changes while maintaining long-term stability and sustainability. Real-world examples and case studies provide insights into overcoming common pitfalls, such as stakeholder misalignment and cultural resistance. By integrating new paradigms and perspectives, you''ll empower your business to achieve unmatched levels of stability, agility, resilience, and sustainability. By the end, you''ll have the strategic and operational tools to design and execute transformative initiatives that create enduring business success.', + 'ADVANCED', 239, 54, 49, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Business_Transformation_Blueprint_-_Crafting_the_Path_to_Success_aimssk.jpg', + '#1FB0C3'), + + ('SME Business Roadmap', + 'Business Roadmap for SME’s: A Step-by-Step Guide for Establishing Core Business Foundations for Sustainable Growth', + 'Step-by-step guidance for SMEs to build solid business foundations.', + 'Gain a practical, step-by-step approach to building strong business foundations for your SME. This course helps you navigate information overload, focus on what truly matters, and set up systems that promote stability, agility, and sustainable growth. You will also learn how to align your team around a shared vision and build long-term strategies that empower you to grow confidently and strategically.', + 'In today''s information-saturated world, small and medium-sized enterprises often face an overwhelming number of business growth strategies, marketing advice, and conflicting success frameworks. This course is designed to eliminate that confusion and provide a structured, practical approach to building a solid business foundation. You''ll learn how to clearly define your purpose, align your team, and develop a strategic plan that ensures long-term success. The course introduces a new paradigm and expanded perspective to help you focus on what truly matters for sustainable growth. You''ll explore how to achieve stability, agility, resilience, and sustainability by applying tried-and-tested models and frameworks tailored for SMEs. Detailed modules will guide you through core business functions including operations, sales, marketing, finance, and HR, ensuring every area supports your overall strategic vision. You will also learn how to evaluate and improve organizational efficiency, establish clear KPIs, and build a culture of continuous improvement. Real-world case studies and hands-on exercises will help solidify these concepts, empowering you to navigate uncertainty with clarity and confidence. By the end, you''ll have a complete step-by-step guide to transform your SME into a thriving, future-proof business.', + 'INTERMEDIATE', 165, 50, 49, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Business_Roadmap_for_SME_s_-_A_Step-by-Step_Guide_for_Establishing_Core_Business_Foundations_for_Sustainable_Growth_qeejox.jpg', + '#002E5D'), + + ('Sales Masterclass', + 'Sales Masterclass: Leadership, Communication, and Modern Sales Process', + 'Master modern sales strategies, leadership, and communication.', + 'Unlock a comprehensive roadmap to mastering modern sales processes, leadership, and communication. You will learn advanced techniques to build high-performance sales teams, foster synergy, improve negotiation outcomes, and cultivate a growth-focused mindset. This course empowers you to close deals confidently, inspire your team, and consistently exceed sales targets in a rapidly changing market.', + 'This comprehensive sales masterclass is designed for professionals who want to stand out and excel in today''s dynamic and client-centric market. You''ll gain in-depth insights into the roles of frontline salespeople and sales leaders, understanding how to create synergy and high-performance teams. Learn the critical difference between being responsible and feeling guilty and how this affects your sales mindset and resilience. Explore how organizational silos negatively impact sales efficiency and how to overcome them to foster seamless collaboration. You''ll study advanced time management techniques tailored for sales environments, and understand what truly defines high-performance behaviors and results. The course covers essential negotiation strategies, modern communication techniques, and practical leadership tools like the AB model, helping you build stronger client relationships and close deals with greater success. Through practical examples, exercises, and case studies, you''ll develop a powerful mix of technical skills and soft skills necessary for outstanding sales performance. By the end of the course, you will have the confidence, strategic understanding, and practical tools to lead in sales, exceed targets consistently, and build a long-lasting, client-centered career.', + 'ADVANCED', 240, 29, 47, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Sales_Masterclass_-_Leadership_Communication_and_Modern_Sales_Process_v74qdh.webp', + '#034D4C'), + + ('Mastering Success Skills', + 'From Good to Extraordinary: Mastering Skills for Success', + 'Unlock your full potential with practical skills for extraordinary success.', + 'Develop essential skills to move from being good to truly extraordinary in your personal and professional life. In this course, you’ll explore powerful frameworks for time management, decision-making, and expectation management, as well as cognitive and behavioral tools that enhance overall effectiveness. Learn how to create impactful habits, improve communication, and unlock new levels of personal growth and achievement.', + 'This holistic course is designed for individuals and professionals who want to elevate their effectiveness, mindset, and results. You''ll explore essential topics such as perception, time management, managing expectations, and setting smart priorities. Through practical frameworks like the AB model, Min/Max analysis, SMART objectives, and the method of deduction, you''ll learn to improve decision-making, enhance efficiency, and boost overall performance. The course also emphasizes cognitive skills development, communication maturity, and how to handle high-pressure situations with confidence. You''ll master meeting productivity, strategic thinking, and personal effectiveness in real-world scenarios. By engaging in reflective exercises and practical activities, you''ll uncover hidden habits that limit your potential and replace them with proactive, empowering behaviors. Real-world case studies and success stories illustrate how these skills can transform your professional journey from merely good to truly extraordinary. By the end of this course, you will possess a robust toolkit for achieving outstanding results, strengthening relationships, and continuously advancing both personally and professionally.', + 'INTERMEDIATE', 197, 35, 48, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751032528/From_Good_to_Extraordinary_-_Mastering_Skills_for_Success_fm0io9.webp', + '#D0B8A3'), + + ('Winning Markets in 3 Steps', + 'Winning Markets in 3 Steps: Building a Clear Go-to-Market Strategy', + 'Build a clear, effective go-to-market strategy in just 3 steps.', + 'Learn to build a clear and highly effective go-to-market strategy in three actionable steps. You will discover how to identify and understand your ideal client profile, define precise messaging, and choose the best channels to reach them. By applying practical tools and real-world examples, you’ll gain the confidence and clarity needed to succeed in even the most competitive markets.', + 'Without a clear marketing strategy, businesses often drift without focus and waste resources. This course introduces a straightforward, three-step approach to creating a highly effective go-to-market strategy. You will learn how to define your ideal target client using eight key characteristics: needs, wants, expectations, challenges, fears, intentions, prejudices, and opportunities. Next, you will master how to determine the right timing, channels, and messaging to reach and engage your audience most effectively. The course includes strategic tools like the AB model and a quantitative negotiation method, enabling you to make data-driven and confident decisions. You will also explore how to build strong value propositions and design a compelling customer journey that increases conversion and loyalty. Real-world case studies and practical exercises will help you directly apply these concepts to your business. By the end of this course, you will have a clear, actionable, and winning strategy that strengthens market positioning, drives revenue, and supports long-term growth.', + 'INTERMEDIATE', 206, 29, 49, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Winning_Markets_in_3_Steps_-_Building_a_Clear_Go-to-Market_Strategy_vayg15.png', + '#FF6F61'), + + ('How to Create Added Value', + 'Creating Added Value: How to Offer Solutions/Concepts, Instead of Services', + 'Shift from selling services to offering impactful solutions and concepts.', + 'Learn how to move beyond selling services and start offering impactful solutions and strategic concepts that create true value for your clients. This course helps you understand your clients'' real needs, develop offers that solve deeper problems, and position yourself as a trusted strategic partner. Gain the skills to design solutions that resonate and drive long-term business relationships.', + 'In this course, you will learn how to move beyond selling services to providing impactful solutions and long-term concepts that generate true value. You will understand the critical differences between selling a service, providing a solution, and developing a concept — and why moving to solutions and concepts unlocks higher client loyalty and market differentiation. You will learn to deeply analyze your target audience, identify real problems they face, and design solutions that directly address those needs. The course covers techniques for developing strong value propositions, strategic storytelling, and crafting offers that resonate with clients on both functional and emotional levels. Using practical examples, including the iconic Nescafe Frape concept, you will see how theory transforms into actionable business models. You will also explore frameworks to ensure your solutions are scalable and sustainable, and how to create offers that position you as a strategic partner rather than just a service provider. By the end of this course, you will have a clear roadmap to build offers that inspire, engage, and create lasting value for your clients and your business.', + 'INTERMEDIATE', 203, 29, 49, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Creating_Added_Value_-_How_to_Offer_SolutionsConcepts_Instead_of_Services_z9fs3c.png', + '#F5AD01'), + + ('Seamless Onboarding Strategy', + 'Onboarding Fundamentals: How to Successfully Incorporate New Employees', + 'Master the essentials of onboarding to boost retention and employee satisfaction.', + 'Discover how to design an onboarding experience that helps new employees integrate quickly and successfully into your organization. You’ll learn to create a structured onboarding plan that enhances engagement, clarifies expectations, and improves long-term retention. This course provides practical strategies and tools to ensure new hires feel confident, motivated, and fully prepared to contribute from day one.', + 'Effective onboarding is essential for ensuring new employees feel confident, welcomed, and prepared to succeed. This course covers how to build a structured onboarding journey that integrates new hires smoothly into your company culture and operational workflow. You will learn to design clear role expectations, create pre-boarding materials, and organize first-week activities that build strong initial connections. The course also provides strategies for extending onboarding beyond the first weeks to reinforce learning, encourage engagement, and foster long-term retention. You will explore templates and feedback loops that help continuously improve the onboarding process. By using real-world examples and practical exercises, you will be able to avoid common pitfalls that lead to disengagement and turnover. By the end, you will have the skills and resources to design a seamless onboarding experience that strengthens employee satisfaction, boosts retention, and supports overall organizational success.', + 'BEGINNER', 141, 25, 48, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Onboarding_Fundamentals_-_How_to_Successfully_Incorporate_New_Employees_bksbad.png', + '#008CC2'), + + ('Growth Through Self-Assessment', + 'Professional Self-Assessment: Identify Barriers Holding You Back & Areas for Improvement', + 'Use self-assessment tools to unlock growth and overcome personal barriers.', + 'Unlock your growth potential by learning to evaluate your strengths and weaknesses using proven self-assessment methods. This course guides you through frameworks for understanding what holds you back, helps you set actionable improvement goals, and empowers you to create a roadmap for professional and personal development. Gain clarity and build the confidence needed to achieve sustained growth.', + 'This course provides a step-by-step approach to understanding and improving your professional effectiveness. You will explore self-assessment techniques such as performance evaluations, needs analysis, and the method of deduction to uncover hidden patterns in your behavior and mindset. The course emphasizes practical applications that help you turn self-reflection into actionable growth strategies. You will learn how to identify barriers holding you back, develop clear action plans to overcome them, and set measurable goals for continuous improvement. Additionally, you will explore the importance of seeking feedback from peers and mentors to enhance self-awareness and accountability. Through exercises, case studies, and personal reflection, you will gain the tools to improve decision-making, boost confidence, and advance your career more strategically. By the end of the course, you will have a comprehensive self-development roadmap, empowering you to achieve personal and professional breakthroughs and realize your full potential.', + 'BEGINNER', 154, 25, 47, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/Professional_Self-Assessment_-_Identify_Barriers_Holding_You_Back_Areas_for_Improvement_tiyydc.jpg', + '#CC6232'), + + ('Business Excellence Blueprint', + 'Establishing Continuous Business Excellence in Your Company', + 'Create a high-performance culture through proven excellence frameworks.', + 'Discover how to embed operational excellence and continuous improvement deeply into your organization. Learn to align teams, set impactful goals, streamline communication, and create systems that support high performance and growth. This course equips you with practical models and real-world strategies to build a culture of excellence that drives long-term competitive advantage.', + 'This course is designed to help leaders and professionals embed a culture of excellence and continuous improvement across their organizations. You will explore powerful models including the Effective Meetings Model, AB model, DF model, and pre/post evaluation frameworks to improve alignment and accountability. The course guides you through mapping organizational disproportions, streamlining communication, and fostering cross-functional collaboration. You will learn to set clear goals, establish robust KPIs, and create feedback loops that reinforce progress and drive sustained success. Real-world examples and case studies show how to navigate resistance to change and build momentum for new initiatives. You will also develop strategies for ensuring long-term adoption of excellence practices and integrating them into the daily rhythm of the organization. By the end of the course, you will possess the mindset, frameworks, and tools needed to transform your organization into a resilient, agile, and continuously improving enterprise, capable of maintaining a competitive edge in any market.', + 'ADVANCED', 161, 39, 49, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028998/Establishing_Continuous_Business_Excellence_in_Your_Company_g3yvao.png', + '#18898D'), + + ('Organizational Success Through Structure', + 'High-Performing Teams and Systems: Organizational Success Through Structure', + 'Build efficient, structured teams and systems that drive sustainable organizational success.', + 'Learn to build strong, structured teams and efficient systems that drive organizational success and growth. This course teaches you how to break down silos, improve collaboration, clarify team roles, and establish accountability structures. Gain the skills to design organizational systems that promote agility, optimize performance, and create a foundation for long-term sustainability and resilience.', + 'This course provides a comprehensive guide to creating high-performing teams and building structured systems that drive organizational success. You will learn how to develop systematic approaches to team design, clarify roles and responsibilities, and eliminate inefficiencies caused by miscommunication and silos. The course covers essential practices for aligning teams with organizational goals, improving collaboration, and establishing strong accountability mechanisms. You will also explore frameworks for effective meetings, conflict resolution, and strategic decision-making that help maintain cohesion and high performance. Using practical exercises and case studies, you will learn to diagnose structural bottlenecks and design solutions that enable scalability and agility. By the end, you will have the knowledge and skills to build robust organizational structures that support continuous improvement, empower teams to excel, and sustain competitive advantage in a dynamic business environment.', + 'INTERMEDIATE', 165, 32, 48, 10, + 'https://res.cloudinary.com/dwlevfwtt/image/upload/v1751028999/High-Performing_Teams_and_Systems_-_Organizational_Success_Through_Structure_b6jvm5.jpg', + '#FF9503'); + + +INSERT INTO course_skills_gained (course_id, skills_gained) +VALUES +-- 1. Building New Paradigm / Perception & Perspective +(1, 'PARADIGM_UNDERSTANDING'), +(1, 'PERCEPTION_MANAGEMENT'), +(1, 'PERSPECTIVE_SHIFTING'), + +-- 2. From Manager to Leader +(2, 'LEADERSHIP'), +(2, 'DELEGATION'), +(2, 'DECISION_MAKING'), +(2, 'PEOPLE_MANAGEMENT'), + +-- 3. Business Transformation Blueprint +(3, 'STRATEGIC_PLANNING'), +(3, 'CHANGE_MANAGEMENT'), +(3, 'PROJECT_MANAGEMENT'), +(3, 'RISK_MANAGEMENT'), + +-- 4. Business Roadmap for SME’s +(4, 'BUSINESS_MODEL_CREATION'), +(4, 'STRATEGIC_THINKING'), +(4, 'OPERATION_MANAGEMENT'), + +-- 5. Sales Masterclass +(5, 'SALES'), +(5, 'COMMUNICATION'), +(5, 'NEGOTIATION'), +(5, 'LEADERSHIP'), + +-- 6. From Good to Extraordinary +(6, 'COMMUNICATION'), +(6, 'DECISION_MAKING'), +(6, 'CRITICAL_THINKING'), +(6, 'EMOTIONAL_INTELLIGENCE'), + +-- 7. Winning Markets in 3 Steps +(7, 'MARKETING'), +(7, 'SALES'), +(7, 'STRATEGIC_THINKING'), + +-- 8. Creating Added Value +(8, 'OPPORTUNITY_IDENTIFICATION'), +(8, 'INNOVATION_MANAGEMENT'), +(8, 'MARKETING'), + +-- 9. Onboarding Fundamentals +(9, 'PEOPLE_MANAGEMENT'), +(9, 'TEAM_BUILDING'), +(9, 'COMMUNICATION'), + +-- 10. Professional Self-Assessment +(10, 'EMOTIONAL_INTELLIGENCE'), +(10, 'CRITICAL_THINKING'), +(10, 'COMMUNICATION'), + +-- 11. Establishing Continuous Business Excellence +(11, 'PROJECT_MANAGEMENT'), +(11, 'PERFORMANCE_EVALUATION'), +(11, 'CHANGE_MANAGEMENT'), +(11, 'STRATEGIC_PLANNING'), + +-- 12. High-Performing Teams and Systems +(12, 'TEAM_BUILDING'), +(12, 'OPERATION_MANAGEMENT'), +(12, 'PEOPLE_MANAGEMENT'), +(12, 'PERFORMANCE_EVALUATION'); + + +INSERT INTO course_topics_covered (course_id, topics_covered) +VALUES +-- 1. Building New Paradigm / Perception & Perspective +(1, 'PARADIGM_CONCEPTS'), +(1, 'PERCEPTION_AND_PERSPECTIVE'), +(1, 'BUSINESS_AND_CAREER_FOUNDATIONS'), + +-- 2. From Manager to Leader +(2, 'LEADERSHIP'), +(2, 'MANAGEMENT'), +(2, 'COMMUNICATION'), +(2, 'TEAM_DEVELOPMENT'), +(2, 'DECISION_MAKING'), + +-- 3. Business Transformation Blueprint +(3, 'BUSINESS_TRANSFORMATION'), +(3, 'DIGITAL_TRANSFORMATION'), +(3, 'CHANGE_MANAGEMENT'), +(3, 'STRATEGIC_PLANNING'), +(3, 'AGILITY'), + +-- 4. Business Roadmap for SME’s +(4, 'ENTREPRENEURSHIP'), +(4, 'STARTUP_METHODS'), +(4, 'BUSINESS_TRANSFORMATION'), +(4, 'STRATEGIC_PLANNING'), +(4, 'OPERATIONAL_EXCELLENCE'), + +-- 5. Sales Masterclass +(5, 'SALES_STRATEGIES'), +(5, 'NEGOTIATION'), +(5, 'LEADERSHIP'), +(5, 'COMMUNICATION'), +(5, 'CLIENT_RELATIONSHIPS'), + +-- 6. From Good to Extraordinary +(6, 'PERSONAL_GROWTH'), +(6, 'LEADERSHIP'), +(6, 'COMMUNICATION'), +(6, 'TIME_MANAGEMENT'), +(6, 'DECISION_MAKING'), + +-- 7. Winning Markets in 3 Steps +(7, 'SALES_STRATEGIES'), +(7, 'VALUE_CREATION'), +(7, 'MARKETING'), +(7, 'GO_TO_MARKET_STRATEGY'), +(7, 'CLIENT_TARGETING'), + +-- 8. Creating Added Value +(8, 'MARKETING'), +(8, 'SALES'), +(8, 'VALUE_CREATION'), +(8, 'BUSINESS_INNOVATION'), +(8, 'CLIENT_TARGETING'), + +-- 9. Onboarding Fundamentals +(9, 'HR'), +(9, 'MANAGEMENT'), +(9, 'LEADERSHIP'), +(9, 'CULTURE_INTEGRATION'), +(9, 'TEAM_OPTIMIZATION'), + +-- 10. Professional Self-Assessment +(10, 'PERSONAL_GROWTH'), +(10, 'LEADERSHIP'), +(10, 'SELF_AWARENESS'), +(10, 'PERFORMANCE_IMPROVEMENT'), +(10, 'TIME_MANAGEMENT'), + +-- 11. Establishing Continuous Business Excellence +(11, 'MANAGEMENT'), +(11, 'TIME_MANAGEMENT'), +(11, 'BUSINESS_TRANSFORMATION'), +(11, 'CONTINUOUS_IMPROVEMENT'), +(11, 'STRATEGIC_PLANNING'), +(11, 'AGILITY'), + +-- 12. High-Performing Teams and Systems +(12, 'MANAGEMENT'), +(12, 'LEADERSHIP'), +(12, 'BUSINESS_TRANSFORMATION'), +(12, 'TEAM_OPTIMIZATION'), +(12, 'SYSTEM_DESIGN'); + +INSERT INTO course_what_will_be_learned (course_id, what_will_be_learned) +VALUES +-- 1. Building New Paradigm / Perception & Perspective +(1, 'Understand how paradigms shape your business and personal decisions.'), +(1, 'Learn to identify limiting beliefs and reframe them for growth.'), +(1, 'Explore the differences between perception and perspective and their impact.'), +(1, 'Develop skills to challenge and shift outdated mental models.'), +(1, 'Enhance emotional intelligence and self-awareness for leadership success.'), +(1, 'Adopt a growth-oriented mindset to unlock new opportunities.'), +(1, 'Build resilience through deeper self-understanding and perspective shifts.'), +(1, 'Apply practical tools to improve decision-making and personal growth.'), +(1, 'Strengthen your ability to adapt and thrive in changing environments.'), +(1, 'Create a personal framework for continuous improvement and success.'), + +-- 2. From Manager to Leader +(2, 'Transition from task-focused management to inspiring leadership.'), +(2, 'Learn how to empower and motivate diverse teams.'), +(2, 'Master effective delegation to build trust and accountability.'), +(2, 'Strengthen communication and feedback skills for team alignment.'), +(2, 'Understand the balance between responsibility and guilt in leadership.'), +(2, 'Develop coaching and mentoring skills for future leaders.'), +(2, 'Create a culture of trust, innovation, and high performance.'), +(2, 'Handle difficult conversations with confidence and empathy.'), +(2, 'Break organizational silos to foster collaboration.'), +(2, 'Use strategic models to set clear objectives and drive results.'), + +-- 3. Business Transformation Blueprint +(3, 'Identify when and why business transformation is necessary.'), +(3, 'Establish a clear purpose and strategic direction for change.'), +(3, 'Develop and implement effective KPIs to measure progress.'), +(3, 'Engage middle management as champions of transformation.'), +(3, 'Overcome resistance and ensure stakeholder alignment.'), +(3, 'Design agile organizational structures for long-term success.'), +(3, 'Sequence transformation stages to avoid chaos and confusion.'), +(3, 'Build resilience and adaptability within the organization.'), +(3, 'Learn from real-world case studies and practical frameworks.'), +(3, 'Create a sustainable roadmap for continuous improvement and growth.'), + +-- 4. Business Roadmap for SME’s +(4, 'Define a clear and compelling business purpose for your SME.'), +(4, 'Align your team around shared goals and a unified vision.'), +(4, 'Develop strategic plans focused on sustainable growth.'), +(4, 'Set up practical systems to support stability and agility.'), +(4, 'Integrate core functions like marketing, sales, and finance effectively.'), +(4, 'Establish clear KPIs and performance measurement tools.'), +(4, 'Foster a culture of continuous improvement and adaptability.'), +(4, 'Simplify decision-making in an information-overloaded environment.'), +(4, 'Learn to navigate uncertainty with confidence and clarity.'), +(4, 'Build a long-term strategy for a future-proof business foundation.'), + +-- 5. Sales Masterclass +(5, 'Master modern sales processes and high-impact selling techniques.'), +(5, 'Understand the dynamics between salespeople and sales leaders.'), +(5, 'Foster synergy and high performance within sales teams.'), +(5, 'Improve negotiation outcomes through strategic communication.'), +(5, 'Overcome silos to create seamless customer experiences.'), +(5, 'Build a resilient and growth-focused sales mindset.'), +(5, 'Strengthen time management specifically for sales contexts.'), +(5, 'Develop stronger client relationships for long-term success.'), +(5, 'Leverage advanced leadership models to inspire sales teams.'), +(5, 'Consistently exceed sales targets in dynamic market environments.'), + +-- 6. From Good to Extraordinary +(6, 'Develop a growth mindset to elevate personal and professional success.'), +(6, 'Master time management and priority-setting for higher productivity.'), +(6, 'Enhance decision-making skills through practical frameworks.'), +(6, 'Cultivate impactful habits that drive extraordinary results.'), +(6, 'Strengthen communication and interpersonal effectiveness.'), +(6, 'Navigate high-pressure situations with confidence and control.'), +(6, 'Identify and transform limiting behaviors and mindsets.'), +(6, 'Apply cognitive and behavioral tools for continuous improvement.'), +(6, 'Learn to run effective meetings and manage expectations.'), +(6, 'Build a strategic approach to achieve outstanding long-term outcomes.'), + +-- 7. Winning Markets in 3 Steps +(7, 'Define and analyze your ideal target client profile precisely.'), +(7, 'Craft clear and compelling messaging tailored to your audience.'), +(7, 'Select the most effective channels to reach your clients.'), +(7, 'Build a strong value proposition that resonates and converts.'), +(7, 'Design a compelling customer journey for improved engagement.'), +(7, 'Apply strategic tools to support data-driven marketing decisions.'), +(7, 'Develop a clear and actionable go-to-market roadmap.'), +(7, 'Strengthen market positioning for competitive advantage.'), +(7, 'Increase conversion rates and build client loyalty effectively.'), +(7, 'Gain the confidence to launch and scale successful market strategies.'), + +-- 8. Creating Added Value +(8, 'Understand the differences between services, solutions, and concepts.'), +(8, 'Analyze client needs to design impactful solutions.'), +(8, 'Develop offers that create long-term client loyalty.'), +(8, 'Craft strong value propositions and strategic storytelling.'), +(8, 'Position yourself as a trusted strategic partner, not just a service provider.'), +(8, 'Ensure your offers are scalable and sustainable over time.'), +(8, 'Learn frameworks to transition from services to solutions.'), +(8, 'Master concept-based selling to stand out in the market.'), +(8, 'Incorporate practical examples like the Nescafe Frape concept.'), +(8, 'Build offers that resonate emotionally and functionally with clients.'), + +-- 9. Onboarding Fundamentals +(9, 'Design effective onboarding experiences tailored to each role.'), +(9, 'Create pre-boarding materials to prepare new hires early.'), +(9, 'Organize first-week activities that build strong connections.'), +(9, 'Clarify expectations and reduce early-stage confusion.'), +(9, 'Foster engagement and motivation from day one.'), +(9, 'Extend onboarding to reinforce learning and integration.'), +(9, 'Implement feedback loops to improve onboarding processes.'), +(9, 'Avoid common pitfalls that cause disengagement and turnover.'), +(9, 'Strengthen employee satisfaction and long-term retention.'), +(9, 'Build a foundation for confident, productive new team members.'), + +-- 10. Professional Self-Assessment +(10, 'Use self-assessment techniques to identify personal barriers.'), +(10, 'Transform self-reflection into actionable improvement plans.'), +(10, 'Develop clear and measurable growth objectives.'), +(10, 'Improve decision-making through deeper self-awareness.'), +(10, 'Seek constructive feedback to enhance accountability.'), +(10, 'Build confidence and advance your career strategically.'), +(10, 'Turn hidden patterns into opportunities for growth.'), +(10, 'Design a personalized self-development roadmap.'), +(10, 'Strengthen both professional and personal resilience.'), +(10, 'Achieve breakthroughs by aligning mindset and action.'), + +-- 11. Establishing Continuous Business Excellence +(11, 'Embed a culture of excellence across your organization.'), +(11, 'Align teams using clear goals and accountability models.'), +(11, 'Streamline communication to improve collaboration and results.'), +(11, 'Apply powerful frameworks to drive continuous improvement.'), +(11, 'Establish robust KPIs and feedback loops for growth.'), +(11, 'Overcome resistance to change and build momentum.'), +(11, 'Navigate structural challenges to maintain agility.'), +(11, 'Integrate excellence practices into daily business rhythm.'), +(11, 'Create systems that support sustainable high performance.'), +(11, 'Transform your organization into a competitive, resilient enterprise.'), + +-- 12. High-Performing Teams and Systems +(12, 'Design structured, high-performing teams that drive success.'), +(12, 'Clarify team roles and eliminate organizational silos.'), +(12, 'Improve cross-functional collaboration for better outcomes.'), +(12, 'Establish strong accountability systems and performance metrics.'), +(12, 'Develop effective conflict resolution and meeting frameworks.'), +(12, 'Optimize systems for scalability and organizational agility.'), +(12, 'Diagnose and solve structural bottlenecks.'), +(12, 'Align team structures with strategic organizational goals.'), +(12, 'Create sustainable systems to support long-term growth.'), +(12, 'Empower teams to continuously improve and excel.'); Index: backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourseContent.sql =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourseContent.sql (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) +++ backend/src/main/java/com/shifterwebapp/shifter/sql/initializeCourseContent.sql (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -0,0 +1,585 @@ + +-- Foundations for a Successful Business & Career +INSERT INTO course_content (title, position, course_id) +VALUES + ('Understanding Paradigms & Mental Frameworks', 1, 1), + ('Exploring Perception and Perspective', 2, 1), + ('Transforming Mindsets for Growth', 3, 1); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Understanding Paradigms & Mental Frameworks (course_content_id: 1) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will gain a deep understanding of paradigms and their role in shaping mental frameworks that drive daily decision-making. This video covers how paradigms form, their impact on success, and strategies to identify limiting beliefs. You will learn to recognize your own paradigms and leverage them for professional growth. Action: Watch the video and list three paradigms influencing your decisions.', + 20, 1, 'Introduction to Paradigms and Mental Frameworks for Success', 1), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s.', + 'TEXT', NULL, + 'Users will discover how paradigms shape decision-making in business and personal contexts. This article covers common paradigm types, their effects on behavior, and methods to reframe limiting paradigms. You will gain insights into adapting mental models for better outcomes. Action: Reflect on your mental models and write a summary of one paradigm you wish to change.', + 15, 2, 'Understanding How Paradigms Influence Decision-Making', 1), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will acquire tools to identify and assess their current paradigms through this worksheet. It provides exercises to pinpoint paradigms that help or hinder progress and offers strategies to reframe them. You will learn to create actionable plans for paradigm shifts. Action: Complete the worksheet and discuss findings with a peer before the next session.', + 18, 3, 'Worksheet for Identifying and Reframing Paradigms', 1), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their understanding of paradigms and mental frameworks through this interactive quiz. It covers key concepts like paradigm formation and reframing techniques, helping you assess your grasp of these ideas. You will gain clarity on areas for improvement. Action: Complete the quiz and review incorrect answers to enhance your knowledge.', + 15, 4, 'Interactive Quiz on Paradigms and Mental Frameworks', 1), + + -- Exploring Perception and Perspective (course_content_id: 2) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn the critical differences between perception and perspective in leadership and business settings. This video covers their influence on decision-making, team dynamics, and strategic planning, with real-world examples. You will gain skills to apply these concepts effectively. Action: Watch the video and note two examples of how perception or perspective shapes your decisions.', + 22, 1, 'Exploring Perception and Perspective in Leadership and Business', 2), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand how perception and perspective shape professional interactions and outcomes. This article covers their psychological and practical aspects, conflict resolution techniques, and perspective-shifting strategies. You will gain tools to improve collaboration and results. Action: Reflect on a recent interaction and identify how your perspective influenced the outcome.', + 14, 2, 'Deep Dive into Perception and Perspective in Professional Interactions', 2), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will identify gaps in their perception and perspective using this worksheet. It provides exercises to realign perspectives with professional goals and foster collaboration. You will learn to create actionable realignment strategies. Action: Complete the worksheet and discuss findings in a group setting.', + 16, 3, 'Worksheet for Realigning Perspectives with Professional Goals', 2), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will assess their knowledge of perception and perspective concepts through this quiz. It covers distinctions, applications, and common pitfalls, providing feedback on your understanding. You will gain insights into areas for improvement. Action: Complete the quiz and review results to refine your approach.', + 18, 4, 'Interactive Quiz on Perception and Perspective Concepts', 2), + + -- Transforming Mindsets for Growth (course_content_id: 3) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will acquire practical steps to transform their mindset for growth and adaptability in professional settings. This video covers reframing challenges, embracing feedback, and cultivating resilience, with case studies. You will gain actionable strategies for a growth mindset. Action: Watch the video and practice one mindset transformation technique this week.', + 25, 1, 'Practical Steps for Transforming Mindsets to Achieve Growth', 3), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will learn how to shift mental models for success in business and career through this guide. It covers adopting a growth mindset, overcoming fixed mindset barriers, and integrating new habits. You will gain insights into sustainable mindset changes. Action: Implement one practice and track its impact for one week.', + 16, 2, 'Comprehensive Guide to Shifting Mental Models for Success', 3), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will track mindset changes and progress toward a growth-oriented approach using this workbook. It provides templates for goal-setting, reflecting on challenges, and evaluating outcomes. You will learn to maintain consistent progress. Action: Update the workbook regularly and review progress monthly.', + 20, 3, 'Workbook for Tracking Mindset Changes and Progress', 3), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their understanding of mindset transformation techniques through this quiz. It covers practical implementation and key concepts, helping you identify growth areas. You will gain feedback to solidify your learning. Action: Complete the quiz and review answers to enhance your knowledge.', + 22, 4, 'Final Quiz on Mindset Transformation Techniques', 3); + +-- From Manager to Leader +INSERT INTO course_content (title, position, course_id) +VALUES + ('Leadership Mindsets & Models', 1, 2), + ('Communication & Delegation Mastery', 2, 2), + ('Building Accountability & Trust', 3, 2), + ('Navigating Organizational Change', 4, 2); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Leadership Mindsets & Models (course_content_id: 4) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will gain insights into leadership mindsets, including the 3xH’s framework (Head, Heart, Hands), and their role in effective leadership. This video covers how these mindsets differentiate managers from leaders, with real-world examples. You will learn to cultivate impactful leadership traits. Action: Watch the video and identify one 3xH trait to focus on this week.', + 23, 1, 'Introduction to Leadership Mindsets and the 3xH Framework', 4), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand generative leadership and models like AB and SMART objectives through this article. It covers their applications in strategic decision-making and team success. You will gain tools to apply leadership frameworks effectively. Action: Study the article and apply one model to a current project.', + 18, 2, 'Exploring Generative Leadership and Key Models for Success', 4), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will assess their leadership strengths and development areas using this worksheet. It provides exercises to evaluate alignment with leadership models and identify growth opportunities. You will learn to create targeted development plans. Action: Complete the worksheet and reflect on your results.', + 15, 3, 'Self-Assessment Worksheet for Leadership Strengths', 4), + + -- Communication & Delegation Mastery (course_content_id: 5) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will master communication strategies and delegation techniques for leadership through this video. It covers assigning tasks clearly, motivating teams, and avoiding delegation pitfalls, with examples. You will gain skills to enhance leadership through communication. Action: Watch the video and practice one delegation scenario with your team.', + 24, 1, 'Mastering Communication and Delegation Techniques for Leaders', 5), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will learn to balance responsibility and guilt in leadership communication through this article. It covers active listening, feedback delivery, and empathetic interaction strategies. You will gain tools to refine your communication style. Action: Reflect on your communication style and practice one technique this week.', + 14, 2, 'Balancing Responsibility in Leadership Communication', 5), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will streamline task assignment with this delegation checklist and templates. It provides tools to enhance team efficiency and accountability through structured processes. You will learn to implement effective delegation strategies. Action: Use the templates to delegate a task and review the outcome.', + 12, 3, 'Delegation Checklists and Templates for Effective Task Management', 5), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their knowledge of leadership communication and delegation principles through this quiz. It covers strategies, challenges, and best practices, providing feedback on your skills. You will gain insights into areas for improvement. Action: Complete the quiz and review results to enhance your approach.', + 18, 4, 'Interactive Quiz on Leadership Communication and Delegation', 5), + + -- Building Accountability & Trust (course_content_id: 6) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to build accountability and trust within teams through this video. It covers transparent communication, consistent follow-through, and real-world examples of trust-building strategies. You will gain actionable steps to foster a reliable team culture. Action: Watch the video and implement one trust-building strategy with your team.', + 22, 1, 'Strategies for Building Accountability and Trust in Teams', 6), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand the difference between responsibility and guilt in fostering accountability through this article. It provides frameworks for setting expectations and maintaining trust. You will gain tools to create a supportive team environment. Action: Read the article and discuss one framework with your team.', + 16, 2, 'Fostering Accountability and Trust in Team Dynamics', 6), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will build accountability within teams using this worksheet. It provides templates for setting expectations and tracking progress, helping you strengthen team trust. You will learn to implement accountability systems. Action: Fill out the worksheet with your team and review progress.', + 15, 3, 'Worksheet for Building Accountability Frameworks in Teams', 6), + + -- Navigating Organizational Change (course_content_id: 7) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn strategies for navigating organizational change and breaking silos through this video. It covers aligning teams, managing resistance, and fostering collaboration, with case studies. You will gain skills to lead change initiatives successfully. Action: Watch the video and prepare one change management strategy for your organization.', + 28, 1, 'Navigating Organizational Change and Breaking Silos', 7), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will discover steps to engage middle management and foster collaboration during organizational change. This article covers frameworks for managing transitions and aligning teams with new goals. You will gain tools to implement effective change strategies. Action: Apply one step to a current change initiative.', + 20, 2, 'Engaging Teams for Effective Organizational Change Management', 7), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will assess their knowledge of change management and organizational dynamics through this quiz. It covers collaboration strategies and resistance management, providing feedback on your understanding. You will gain insights into areas for improvement. Action: Complete the quiz and review results to refine your approach.', + 17, 3, 'Interactive Quiz on Change Management and Organizational Dynamics', 7); + +-- Business Transformation Blueprint +INSERT INTO course_content (title, position, course_id) +VALUES + ('Foundations of Business Transformation', 1, 3), + ('Engaging Stakeholders & Middle Management', 2, 3), + ('Implementing Change & Measuring Success', 3, 3), + ('Building Agile & Resilient Organizations', 4, 3); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Foundations of Business Transformation (course_content_id: 8) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will gain a comprehensive understanding of business transformation principles and stages through this video. It covers transformation triggers like market shifts and internal inefficiencies, with a roadmap for success. You will learn to identify transformation opportunities in your business. Action: Watch the video and note three relevant transformation triggers.', + 26, 1, 'Introduction to Principles and Stages of Business Transformation', 8), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will learn about transformation drivers and setting a clear purpose for change initiatives. This article covers strategic planning, stakeholder alignment, and pitfalls to avoid. You will gain insights into launching effective transformation projects. Action: Reflect on your organization’s transformation readiness.', + 18, 2, 'Understanding Drivers and Purpose in Business Transformation', 8), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will assess their business’s readiness for transformation using this template. It provides exercises to evaluate strengths, weaknesses, and external factors. You will learn to create a transformation readiness plan. Action: Complete the template with your team and discuss results.', + 15, 3, 'Template for Assessing Business Transformation Readiness', 8), + + -- Engaging Stakeholders & Middle Management (course_content_id: 9) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn strategies to engage middle management as change agents in transformation initiatives. This video covers communication techniques, stakeholder mapping, and gaining buy-in, with examples. You will gain skills to align stakeholders effectively. Action: Plan a stakeholder communication strategy for your organization.', + 23, 1, 'Engaging Middle Management as Change Agents in Transformation', 9), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will discover best practices for stakeholder alignment and communication during transformation. This article covers identifying stakeholders, addressing concerns, and fostering collaboration. You will gain tools to build strong stakeholder relationships. Action: Analyze your stakeholder map and identify one improvement area.', + 17, 2, 'Best Practices for Stakeholder Alignment and Communication', 9), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will structure stakeholder engagement with this communication plan template. It provides tools to outline messaging, timelines, and feedback mechanisms. You will learn to create effective communication strategies. Action: Customize the template for your change initiative.', + 13, 3, 'Communication Plan Template for Change Initiatives', 9), + + -- Implementing Change & Measuring Success (course_content_id: 10) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to implement KPIs and monitor transformation progress through this video. It covers selecting relevant KPIs, tracking tools, and interpreting data. You will gain skills to measure transformation effectively. Action: Apply one KPI measurement tool to your initiative.', + 27, 1, 'Implementing KPIs and Monitoring Transformation Progress', 10), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand how to define and use KPIs effectively to track transformation. This article covers selecting measurable metrics, aligning with goals, and avoiding pitfalls. You will gain a robust KPI framework. Action: Set three KPIs for your transformation project and outline their tracking process.', + 19, 2, 'Guide to Defining and Using KPIs in Business Transformation', 10), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will monitor transformation progress with this KPI tracking dashboard template. It provides tools to visualize data and evaluate outcomes. You will learn to implement and maintain KPI tracking systems. Action: Implement the dashboard and monitor KPIs weekly.', + 14, 3, 'KPI Tracking Dashboard Template for Transformation Monitoring', 10), + + -- Building Agile & Resilient Organizations (course_content_id: 11) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to build agility and resilience into organizational structures through this video. It covers flexible frameworks, adaptive strategies, and examples of resilient organizations. You will gain skills to design agile systems. Action: Assess your organization’s structure for agility.', + 29, 1, 'Building Agility and Resilience in Organizational Structures', 11), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand concepts and frameworks for creating agile organizations. This article covers organizational design, cross-functional collaboration, and resilience strategies. You will gain tools to improve your structure. Action: Evaluate your organizational design and identify one agility improvement.', + 20, 2, 'Frameworks for Creating Agile and Resilient Organizations', 11), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will assess their understanding of agile and resilient structures through this quiz. It covers flexibility and adaptability strategies, providing feedback on your knowledge. You will gain insights into areas for improvement. Action: Complete the quiz and review results to enhance your understanding.', + 18, 3, 'Interactive Quiz on Agile and Resilient Organizational Structures', 11); + +-- SME Business Roadmap +INSERT INTO course_content (title, position, course_id) +VALUES + ('Core Foundations for SME Success', 1, 4), + ('Aligning Teams & Vision', 2, 4), + ('Building Sustainable Growth Systems', 3, 4); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Core Foundations for SME Success (course_content_id: 12) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will discover core foundations for SME growth and stability through this video. It covers strategic planning, resource management, and examples of successful SMEs. You will gain skills to build a strong business base. Action: Note three key foundations for your SME.', + 24, 1, 'Core Foundations for Driving SME Growth and Stability', 12), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will learn to overcome common SME challenges like financial management and market positioning. This article covers practical strategies to strengthen your business foundation. You will gain insights into addressing SME-specific obstacles. Action: Write a plan to address one business challenge.', + 15, 2, 'Overcoming Challenges for SME Success and Growth', 12), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will assess their SME’s foundational strengths and weaknesses with this worksheet. It provides exercises to evaluate financial, operational, and strategic readiness. You will learn to create a robust foundation plan. Action: Complete the worksheet and discuss with your team.', + 17, 3, 'Assessment Worksheet for SME Foundational Strengths', 12), + + -- Aligning Teams & Vision (course_content_id: 13) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to align their SME team around a shared vision and mission through this video. It covers fostering team buy-in, creating a cohesive culture, and real-world examples. You will gain skills to unify your team. Action: Implement one alignment activity with your team.', + 22, 1, 'Aligning SME Teams Around a Shared Vision and Mission', 13), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will discover steps to build a motivating shared vision for their SME team. This article covers vision-setting workshops, communication strategies, and alignment techniques. You will gain tools to create a cohesive team vision. Action: Lead a vision-building session with your team.', + 14, 2, 'Steps to Build a Motivating Vision for SME Teams', 13), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will craft a clear and inspiring vision for their SME using this template. It provides tools to articulate values and goals that resonate with your team. You will learn to formalize your vision. Action: Customize the template for your SME’s vision and mission.', + 13, 3, 'Vision and Mission Template for SME Alignment', 13), + + -- Building Sustainable Growth Systems (course_content_id: 14) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to build scalable systems for sustainable SME growth through this video. It covers process optimization, automation, and scalability strategies, with examples. You will gain skills to design growth-oriented systems. Action: Plan one system implementation for your SME.', + 26, 1, 'Building Scalable Systems for Sustainable SME Growth', 14), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand operational efficiency and process design for SMEs through this article. It covers frameworks for streamlining workflows and ensuring scalability. You will gain tools to optimize business processes. Action: Map one SME process and identify an efficiency improvement.', + 18, 2, 'Operational Efficiency and Process Design for SMEs', 14), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will design growth-oriented processes for their SME with this systems planning worksheet. It provides templates for mapping workflows and identifying scalability factors. You will learn to create sustainable systems. Action: Use the worksheet to design one growth-oriented system.', + 16, 3, 'Systems Planning Worksheet for SME Growth', 14); + +-- Sales Masterclass +INSERT INTO course_content (title, position, course_id) +VALUES + ('Sales Leadership Fundamentals', 1, 5), + ('Advanced Sales Techniques', 2, 5), + ('Building High-Performance Sales Teams', 3, 5), + ('Negotiation & Client Relationships', 4, 5); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Sales Leadership Fundamentals (course_content_id: 15) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will gain insights into sales leadership principles and mindset through this video. It covers building team synergy, vision-setting, and motivation, with real-world examples. You will learn to lead sales teams effectively. Action: Reflect on your current sales leadership approach.', + 23, 1, 'Introduction to Sales Leadership Principles and Mindset', 15), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will understand the role of leadership in sales through this article. It covers building synergy and aligning teams with business goals, with strategies for motivation. You will gain tools to enhance your leadership impact. Action: Apply one strategy to improve your team’s influence.', + 17, 2, 'Building Synergy and Influence in Sales Leadership', 15), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will assess their leadership strengths and growth areas with this worksheet. It provides exercises to evaluate skills and set development goals for sales managers. You will learn to create a personal growth plan. Action: Complete the worksheet and set one leadership goal.', + 15, 3, 'Self-Assessment Worksheet for Sales Leadership Growth', 15), + + -- Advanced Sales Techniques (course_content_id: 16) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will master advanced sales techniques to increase close rates through this video. It covers consultative selling, objection handling, and practical demonstrations. You will gain skills to refine your sales approach. Action: Practice one technique in your next sales interaction.', + 27, 1, 'Advanced Sales Techniques for Increasing Close Rates', 16), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will learn to overcome sales silos and improve collaboration through this article. It covers pipeline management, customer engagement, and advanced sales strategies. You will gain tools to optimize your sales process. Action: Analyze your sales process and identify one improvement area.', + 16, 2, 'Overcoming Silos and Optimizing Sales Collaboration', 16), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their knowledge of advanced sales strategies through this quiz. It covers objection handling, pipeline management, and other key concepts, providing feedback on your skills. You will gain insights into areas for improvement. Action: Complete the quiz and review results to refine your approach.', + 20, 3, 'Interactive Quiz on Advanced Sales Strategies', 16), + + -- Building High-Performance Sales Teams (course_content_id: 17) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to build and manage high-performance sales teams through this video. It covers recruitment, training, and motivation strategies, with examples of successful teams. You will gain skills to design a team improvement plan. Action: Draft a plan to enhance your sales team’s performance.', + 28, 1, 'Building and Managing High-Performance Sales Teams', 17), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will discover steps to foster accountability and growth in sales teams. This article covers setting expectations, tracking performance, and building team cohesion. You will gain tools to create a high-performance culture. Action: Implement one accountability strategy with your sales team.', + 18, 2, 'Fostering Accountability and Growth in Sales Teams', 17), + (NULL, 'FILE', 'https://drive.google.com/file/d/14LBFO5sNWu7P3L8Co-MeGUxMbg7fhC76/view?usp=drive_link', + 'Users will track sales team KPIs and goals with this template. It provides tools to set measurable targets and monitor progress, helping you maintain team accountability. You will learn to sustain team performance. Action: Fill out the template and track your team’s performance regularly.', + 15, 3, 'KPI Tracking Template for Sales Team Performance', 17), + + -- Negotiation & Client Relationships (course_content_id: 18) + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn strategies for effective negotiation and building strong client relationships through this video. It covers handling objections, building trust, and closing deals, with real-world scenarios. You will gain skills to strengthen client partnerships. Action: Prepare one negotiation scenario for practice.', + 25, 1, 'Strategies for Effective Negotiation and Client Relationships', 18), + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry.', + 'TEXT', NULL, + 'Users will discover how to turn client objections into opportunities for stronger relationships. This article covers negotiation frameworks, active listening, and trust-building techniques. You will gain tools to enhance client interactions. Action: Apply one technique in your next client meeting.', + 19, 2, 'Turning Client Objections into Relationship Opportunities', 18), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will evaluate their negotiation and client management skills through this quiz. It covers objection handling and relationship-building strategies, providing feedback on your skills. You will gain insights into areas for improvement. Action: Complete the quiz and review results for enhancement.', + 17, 3, 'Interactive Quiz on Negotiation and Client Management Skills', 18); + +-- Mastering Success Skills +INSERT INTO course_content (title, position, course_id) +VALUES + ('Foundations of Effective Skill-Building', 1, 6), + ('Time Management & Prioritization Strategies', 2, 6), + ('Communication & Cognitive Tools for Success', 3, 6), + ('Transforming Good Habits into Extraordinary Results', 4, 6); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Foundations of Effective Skill-Building (course_content_id: 19) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn the core principles behind building essential skills for personal and professional growth. This article covers the psychology of skill acquisition, learning frameworks, and practical applications. You will gain a structured skill-building plan. Action: Reflect on your current skills and outline one skill to develop.', + 15, 1, 'Core Principles of Effective Skill-Building for Success', 19), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore practical frameworks for mastering new skills through this video. It covers goal-setting, feedback loops, and examples of successful skill-building strategies. You will gain a solid foundation for skill development. Action: List three key takeaways for your skill-building plan.', + 20, 2, 'Practical Frameworks for Mastering New Skills', 19), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their understanding of skill-building principles through this quiz. It covers learning frameworks and practical applications, helping you identify areas for improvement. You will gain feedback on your knowledge. Action: Complete the quiz and review results to refine your approach.', + 10, 3, 'Interactive Quiz on Skill-Building Principles', 19), + + -- Time Management & Prioritization Strategies (course_content_id: 20) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will discover proven methods to prioritize tasks and manage time effectively. This article covers techniques like the Eisenhower Matrix and time-blocking, with practical tips. You will gain tools to boost productivity without burnout. Action: Implement the weekly planner for one week.', + 18, 1, 'Proven Methods for Effective Time Management and Prioritization', 20), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn advanced time management techniques to enhance productivity and balance. This video covers prioritization frameworks and workload management tools. You will gain skills to optimize your schedule. Action: Apply one time management technique today.', + 25, 2, 'Advanced Techniques for Time Management and Productivity', 20), + + -- Communication & Cognitive Tools for Success (course_content_id: 21) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn how powerful communication and cognitive strategies drive success. This article covers active listening, emotional intelligence, and problem-solving tools. You will gain skills to enhance effectiveness in dynamic environments. Action: Practice active listening in your next team meeting.', + 20, 1, 'Powerful Communication and Cognitive Strategies for Success', 21), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore cognitive tools to adapt, grow, and thrive in dynamic settings. This video covers decision-making frameworks, communication techniques, and real-world applications. You will gain skills to apply cognitive strategies effectively. Action: Identify one insight to implement in your work.', + 28, 2, 'Cognitive Tools and Communication Techniques for Growth', 21), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will assess their communication maturity and readiness for high-stakes situations. This quiz covers active listening and cognitive strategies, providing feedback on your skills. You will gain insights into areas for improvement. Action: Complete the quiz and reflect on results to improve.', + 12, 3, 'Interactive Quiz on Communication and Cognitive Skills', 21), + + -- Transforming Good Habits into Extraordinary Results (course_content_id: 22) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn to transform everyday habits into extraordinary results. This article covers habit formation, consistency frameworks, and sustained improvement strategies. You will gain tools to build high-impact habits. Action: Write a new habit plan based on the article.', + 22, 1, 'Transforming Everyday Habits into High-Impact Results', 22), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how successful individuals design habits for continuous improvement. This video covers case studies and practical habit-building strategies. You will gain skills to create sustainable habits. Action: Implement one habit-building strategy today.', + 27, 2, 'Case Studies on Designing Habits for Continuous Improvement', 22); + +-- Winning Markets in 3 Steps +INSERT INTO course_content (title, position, course_id) +VALUES + ('Defining Your Ideal Client Profile', 1, 7), + ('Crafting Precise Messaging and Value Propositions', 2, 7), + ('Choosing Effective Marketing Channels', 3, 7), + ('Integrating Strategy into Execution', 4, 7); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Defining Your Ideal Client Profile (course_content_id: 23) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn to define an ideal client profile to focus marketing efforts. This article covers analyzing customer needs, behaviors, and demographics for targeted strategies. You will gain skills to create a precise client profile. Action: Write your ideal client profile.', + 18, 1, 'Defining the Eight Characteristics of an Ideal Client Profile', 23), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore real-world examples of businesses defining ideal client profiles. This video covers strategies for identifying high-value clients and tailoring offerings. You will gain skills to refine client targeting. Action: Note one applicable insight for your business.', + 24, 2, 'Real-World Examples of Defining Ideal Client Profiles', 23), + + -- Crafting Precise Messaging and Value Propositions (course_content_id: 24) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn to create messaging that resonates with their audience. This article covers frameworks for crafting compelling value propositions and aligning with client needs. You will gain skills to develop impactful messaging. Action: Draft your core message.', + 20, 1, 'Crafting Resonant Messaging and Value Propositions', 24), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will discover techniques for building powerful value propositions that stand out. This video covers successful messaging strategies and their impact, with examples. You will gain skills to create compelling value propositions. Action: Identify your main value points.', + 26, 2, 'Techniques for Building Powerful Value Propositions', 24), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their understanding of messaging and value propositions through this quiz. It covers messaging frameworks and key concepts, providing feedback on your skills. You will gain insights into areas for improvement. Action: Complete the quiz and adjust your messaging.', + 12, 3, 'Interactive Quiz on Messaging and Value Propositions', 24), + + -- Choosing Effective Marketing Channels (course_content_id: 25) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn to identify where their audience is most active through this article. It covers analyzing digital, traditional, and hybrid marketing channels, with selection strategies. You will gain skills to choose effective channels. Action: Choose your top three marketing channels.', + 17, 1, 'Analyzing and Selecting Effective Marketing Channels', 25), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how to balance multiple marketing channels with consistent messaging. This video covers channel integration, audience targeting, and performance tracking. You will gain skills to create a cohesive channel strategy. Action: Create your channel strategy.', + 25, 2, 'Balancing Multiple Channels for Consistent Marketing', 25), + + -- Integrating Strategy into Execution (course_content_id: 26) + ('Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text...', + 'TEXT', NULL, + 'Users will learn to combine client profiles, messaging, and channels into a go-to-market strategy. This article covers strategic planning, execution steps, and alignment techniques. You will gain skills to build an effective roadmap. Action: Build your go-to-market roadmap.', + 22, 1, 'Integrating Client Profiles and Messaging into a Go-to-Market Strategy', 26), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will discover how top companies align go-to-market plans for maximum impact. This video covers case studies and practical execution steps. You will gain skills to implement cohesive strategies. Action: List three strategic takeaways for your business.', + 28, 2, 'Case Studies on Aligning Go-to-Market Strategies for Impact', 26), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will check their readiness to launch an integrated go-to-market strategy through this quiz. It covers strategy alignment and execution, providing feedback on your plans. You will gain insights into gaps to address. Action: Complete the quiz and revise your strategy.', + 14, 3, 'Interactive Quiz on Integrated Go-to-Market Strategies', 26); + +-- How to Create Added Value +INSERT INTO course_content (title, position, course_id) +VALUES + ('Understanding Client Problems Deeply', 1, 8), + ('Designing Impactful Solutions', 2, 8), + ('Developing Scalable Concepts', 3, 8), + ('Positioning Yourself as a Strategic Partner', 4, 8); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Understanding Client Problems Deeply (course_content_id: 27) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to uncover hidden client problems and analyze root causes. This article covers needs analysis, stakeholder interviews, and practical applications. You will gain skills to identify high-impact client pain points. Action: List your top three client pain points.', + 20, 1, 'Uncovering and Analyzing Hidden Client Problems', 27), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore case studies where deep problem analysis led to breakthrough solutions. This video covers methodologies for identifying client needs and prioritizing solutions. You will gain skills to conduct effective problem discovery. Action: Note one methodology to apply to your clients.', + 25, 2, 'Case Studies on Effective Client Problem Discovery', 27), + + -- Designing Impactful Solutions (course_content_id: 28) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to design solutions addressing core client problems. This article covers design thinking, iterative development, and solution validation techniques. You will gain skills to create impactful solutions. Action: Sketch a solution concept for one client problem.', + 22, 1, 'Designing Solutions for Core Client Problems', 28), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will discover iterative design approaches for refining solutions. This video covers successful solution development and testing processes, with examples. You will gain skills to iterate effectively. Action: Identify one area to test in your solution design.', + 28, 2, 'Iterative Approaches to Solution Design and Refinement', 28), + + -- Developing Scalable Concepts (course_content_id: 29) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to build concepts that scale across client needs. This article covers scalability factors, modular design, and cross-industry applications. You will gain skills to create versatile solutions. Action: Define scalability factors for one concept.', + 19, 1, 'Building Scalable Concepts for Diverse Client Needs', 29), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how top brands create scalable solutions and concepts. This video covers case studies and strategies for scalability and adaptability. You will gain skills to design scalable concepts. Action: Draft a scalability plan for one concept.', + 26, 2, 'Case Studies on Creating Scalable Solutions and Concepts', 29), + + -- Positioning Yourself as a Strategic Partner (course_content_id: 30) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to position themselves as strategic partners, not just vendors. This article covers relationship-building, value alignment, and trust strategies. You will gain skills to foster long-term client loyalty. Action: Write your value positioning statement.', + 21, 1, 'Positioning as a Strategic Partner for Client Loyalty', 30), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will discover relationship-based strategies for long-term client loyalty. This video covers examples of strategic partnerships and practical steps. You will gain skills to build strong client relationships. Action: Map your partner strategy.', + 27, 2, 'Relationship-Based Strategies for Long-Term Client Loyalty', 30), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their knowledge of moving from services to strategic partnerships. This quiz covers relationship-building techniques and key concepts, providing feedback on your understanding. You will gain insights into areas for improvement. Action: Complete the quiz and review results to refine your approach.', + 15, 3, 'Interactive Quiz on Strategic Partnership and Value Creation', 30); + +-- Seamless Onboarding Strategy +INSERT INTO course_content (title, position, course_id) +VALUES + ('Pre-Onboarding Preparation', 1, 9), + ('First Week Essentials', 2, 9), + ('Long-Term Integration and Development', 3, 9); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Pre-Onboarding Preparation (course_content_id: 31) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to prepare for a new hire’s arrival to ensure smooth onboarding. This article covers creating pre-onboarding checklists, setting expectations, and aligning resources. You will gain skills to set new hires up for success. Action: Create a pre-onboarding checklist.', + 18, 1, 'Preparing for a Smooth New Hire Onboarding Process', 31), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how pre-onboarding impacts early employee engagement. This video covers case studies of effective pre-onboarding strategies and their outcomes. You will gain skills to enhance onboarding readiness. Action: Identify one improvement for your pre-onboarding process.', + 22, 2, 'Case Studies on Effective Pre-Onboarding Strategies', 31), + + -- First Week Essentials (course_content_id: 32) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to plan structured activities for a new hire’s first week to build connection. This article covers team introductions, role clarity, and initial goal-setting. You will gain skills to design an effective first week. Action: Outline your first-week onboarding agenda.', + 19, 1, 'Designing a Connected First Week for New Hires', 32), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore successful approaches to immersive onboarding weeks. This video covers schedules, team-building activities, and orientation strategies. You will gain skills to create impactful first weeks. Action: Draft your week 1 onboarding schedule.', + 25, 2, 'Creating an Immersive First Week for New Hires', 32), + + -- Long-Term Integration and Development (course_content_id: 33) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to extend onboarding for continuous growth and integration. This article covers 90-day plans, mentorship programs, and feedback loops. You will gain skills to sustain onboarding success. Action: Design a 90-day integration plan.', + 20, 1, 'Extending Onboarding for Continuous Employee Development', 33), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to reinforce learning and build long-term retention strategies during onboarding. This video covers follow-up processes and development frameworks, with examples. You will gain skills to sustain employee engagement. Action: Create a follow-up process.', + 24, 2, 'Sustaining Long-Term Engagement in Onboarding', 33), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will test their understanding of seamless onboarding journeys through this quiz. It covers pre-onboarding and long-term strategies, providing feedback on your knowledge. You will gain insights into areas for improvement. Action: Complete the quiz and review results to improve.', + 13, 3, 'Interactive Quiz on Seamless Onboarding Strategies', 33); + +-- Growth Through Self-Assessment +INSERT INTO course_content (title, position, course_id) +VALUES + ('Identifying Personal Barriers', 1, 10), + ('Developing Actionable Improvement Plans', 2, 10), + ('Implementing Continuous Self-Improvement', 3, 10); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Identifying Personal Barriers (course_content_id: 34) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to identify hidden barriers hindering professional growth. This article covers common blockers like self-doubt and procrastination, with self-assessment strategies. You will gain skills to pinpoint growth obstacles. Action: List your top three personal blockers.', + 20, 1, 'Identifying Hidden Barriers to Professional Growth', 34), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore examples of professionals overcoming personal barriers. This video covers self-reflection and barrier identification techniques, with practical applications. You will gain skills to address your blockers. Action: Reflect on one barrier and plan to address it.', + 26, 2, 'Real-World Examples of Overcoming Personal Barriers', 34), + + -- Developing Actionable Improvement Plans (course_content_id: 35) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to translate self-reflection into actionable improvement plans. This article covers goal-setting frameworks, prioritization techniques, and progress tracking. You will gain skills to create effective growth plans. Action: Draft your improvement roadmap.', + 22, 1, 'Creating Actionable Plans for Professional Improvement', 35), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore frameworks for goal setting and progress tracking in self-improvement. This video covers successful action plans and their outcomes, with examples. You will gain skills to design actionable plans. Action: Outline your first improvement goals.', + 24, 2, 'Frameworks for Effective Goal Setting and Progress Tracking', 35), + + -- Implementing Continuous Self-Improvement (course_content_id: 36) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to sustain improvement momentum through continuous self-assessment. This article covers accountability systems, habit-building, and long-term tracking. You will gain skills to maintain growth momentum. Action: Create a personal accountability plan.', + 21, 1, 'Sustaining Continuous Self-Improvement Through Accountability', 36), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore long-term success stories from continuous self-improvement. This video covers strategies for maintaining progress and measuring success. You will gain skills to sustain your growth efforts. Action: Identify one long-term metric to track your progress.', + 27, 2, 'Case Studies on Sustained Self-Improvement Success', 36), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will check their readiness for continuous self-improvement through this quiz. It covers accountability and tracking strategies, providing feedback on your knowledge. You will gain insights into areas for growth. Action: Complete the quiz and define your next steps.', + 14, 3, 'Interactive Quiz on Continuous Self-Improvement Strategies', 36); + +-- Business Excellence Blueprint +INSERT INTO course_content (title, position, course_id) +VALUES + ('Laying the Foundations of Excellence', 1, 11), + ('Establishing Continuous Improvement Systems', 2, 11), + ('Embedding a High-Performance Culture', 3, 11); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Laying the Foundations of Excellence (course_content_id: 37) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn the core principles of organizational excellence, including strategic alignment and operational efficiency. This article covers frameworks for building a strong foundation and avoiding pitfalls. You will gain skills to assess your organization’s readiness. Action: Assess your current organizational foundation.', + 21, 1, 'Core Principles for Building Organizational Excellence', 37), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how top companies build foundations for organizational excellence. This video covers case studies, strategic planning, and alignment strategies. You will gain skills to adopt best practices for excellence. Action: Identify one best practice to implement.', + 26, 2, 'Case Studies on Building Foundations for Excellence', 37), + + -- Establishing Continuous Improvement Systems (course_content_id: 38) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to create systems driving continuous improvement across their organization. This article covers improvement frameworks, feedback loops, and performance tracking. You will gain skills to design effective systems. Action: Design an improvement loop for your organization.', + 23, 1, 'Creating Systems for Continuous Organizational Improvement', 38), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore examples of continuous improvement initiatives in action. This video covers practical implementation steps and case studies. You will gain skills to launch improvement initiatives. Action: Define your first improvement initiative.', + 27, 2, 'Practical Examples of Continuous Improvement Initiatives', 38), + + -- Embedding a High-Performance Culture (course_content_id: 39) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to embed a culture valuing high performance. This article covers cultural values, leadership roles, and employee engagement strategies. You will gain skills to create a high-performance culture. Action: Outline your organization’s cultural values.', + 22, 1, 'Building a High-Performance Organizational Culture', 39), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore how to maintain momentum in a high-performance culture. This video covers case studies and strategies for cultural alignment. You will gain skills to sustain performance excellence. Action: Draft your culture plan.', + 28, 2, 'Sustaining Momentum in a High-Performance Culture', 39), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will assess their readiness to establish a culture of excellence through this quiz. It covers cultural alignment and engagement strategies, providing feedback on your knowledge. You will gain insights into areas for improvement. Action: Complete the quiz and review results.', + 14, 3, 'Interactive Quiz on Establishing a Culture of Excellence', 39); + +-- Organizational Success Through Structure +INSERT INTO course_content (title, position, course_id) +VALUES + ('Building Effective Team Structures', 1, 12), + ('Optimizing Systems for Agility', 2, 12), + ('Maintaining Long-Term Performance', 3, 12); + +INSERT INTO course_lecture (content_text, content_type, content_url, description, duration_minutes, position, title, course_content_id) +VALUES + -- Building Effective Team Structures (course_content_id: 40) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to design efficient team structures for clarity and accountability. This article covers organizational design principles, role definitions, and collaboration frameworks. You will gain skills to create effective team structures. Action: Map your current team structure.', + 21, 1, 'Designing Efficient Team Structures for Accountability', 40), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore case studies of successful team structures and collaboration. This video covers aligning teams for efficiency and accountability, with examples. You will gain skills to optimize team design. Action: Note one structural improvement for your team.', + 27, 2, 'Case Studies on High-Performing Team Structures', 40), + + -- Optimizing Systems for Agility (course_content_id: 41) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to design systems that adapt quickly to change. This article covers agility frameworks, process optimization, and adaptive strategies. You will gain skills to create agile systems. Action: Identify one agility enabler for your organization.', + 23, 1, 'Designing Agile Systems for Rapid Adaptation', 41), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will explore strategies for integrating agility into daily processes. This video covers case studies of agile organizations and implementation steps. You will gain skills to design agile systems. Action: Design an agility roadmap for your organization.', + 28, 2, 'Practical Strategies for Integrating Organizational Agility', 41), + + -- Maintaining Long-Term Performance (course_content_id: 42) + ('Lorem Ipsum is simply dummy text...', + 'TEXT', NULL, + 'Users will learn to create processes supporting sustained organizational performance. This article covers performance monitoring, feedback loops, and continuous improvement strategies. You will gain skills to maintain long-term success. Action: Plan your continuous monitoring process.', + 22, 1, 'Creating Processes for Sustained Organizational Performance', 42), + (NULL, 'VIDEO', 'https://www.youtube.com/watch?v=aeBaSrJmTMk&list=RDaeBaSrJmTMk&start_radio=1&ab_channel=AVAIONVEVO', + 'Users will learn to track, evaluate, and adjust systems for sustained success. This video covers performance metrics, case studies, and adaptation strategies. You will gain skills to sustain performance. Action: Define one key performance metric to track.', + 29, 2, 'Tracking and Adapting Systems for Long-Term Success', 42), + (NULL, 'QUIZ', 'https://www.britannica.com/games/sudoku', + 'Users will check their readiness to sustain structural success through this quiz. It covers performance monitoring and adaptation strategies, providing feedback on your knowledge. You will gain insights into areas for improvement. Action: Complete the quiz and review results.', + 15, 3, 'Interactive Quiz on Sustaining Structural Success', 42); Index: backend/src/main/java/com/shifterwebapp/shifter/user/UserController.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/user/UserController.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/user/UserController.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -7,100 +7,102 @@ import lombok.RequiredArgsConstructor; import org.springframework.http.ResponseEntity; +import org.springframework.security.core.Authentication; import org.springframework.web.bind.annotation.*; @RequiredArgsConstructor @RestController -@RequestMapping("${api.base.path}/account") +@RequestMapping("${api.base.path}/user") public class UserController { private final UserService userService; - @GetMapping("/{accountId}") - public ResponseEntity getUser(@PathVariable Long accountId) { - UserDto userDto = userService.getUserById(accountId); + @GetMapping("/{userId}") + public ResponseEntity getUser(@PathVariable Long userId) { + UserDto userDto = userService.getUserById(userId); return ResponseEntity.ok(userDto); } - @DeleteMapping("/{accountId}") - public ResponseEntity deleteUser(@PathVariable Long accountId) { - userService.deleteUser(accountId); + @DeleteMapping("/{userId}") + public ResponseEntity deleteUser(@PathVariable Long userId) { + userService.deleteUser(userId); return ResponseEntity.noContent().build(); } - @PutMapping("/{accountId}/name") - public ResponseEntity updateName(@PathVariable Long accountId, @RequestParam String newName) { - UserDto userDto = userService.updateName(accountId, newName); + @PutMapping("/{userId}/name") + public ResponseEntity updateName(@PathVariable Long userId, @RequestParam String newName) { + UserDto userDto = userService.updateName(userId, newName); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/mail") - public ResponseEntity updateMail(@PathVariable Long accountId, @RequestParam String newMail) { - UserDto userDto = userService.updateMail(accountId, newMail); + @PutMapping("/{userId}/mail") + public ResponseEntity updateMail(@PathVariable Long userId, @RequestParam String newMail) { + UserDto userDto = userService.updateMail(userId, newMail); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/password") - public ResponseEntity updatePassword(@PathVariable Long accountId, @RequestParam String newPassword) { - UserDto userDto = userService.updatePassword(accountId, newPassword); + @PutMapping("/{userId}/password") + public ResponseEntity updatePassword(@PathVariable Long userId, @RequestParam String newPassword) { + UserDto userDto = userService.updatePassword(userId, newPassword); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/work-position") - public ResponseEntity updateWorkPosition(@PathVariable Long accountId, @RequestParam String newWorkPosition) { - UserDto userDto = userService.updateWorkPosition(accountId, newWorkPosition); + @PutMapping("/{userId}/work-position") + public ResponseEntity updateWorkPosition(@PathVariable Long userId, @RequestParam String newWorkPosition) { + UserDto userDto = userService.updateWorkPosition(userId, newWorkPosition); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/company-type") - public ResponseEntity updateCompanyType(@PathVariable Long accountId, @RequestParam CompanyType newCompanyType) { - UserDto userDto = userService.updateCompanyType(accountId, newCompanyType); + @PutMapping("/{userId}/company-type") + public ResponseEntity updateCompanyType(@PathVariable Long userId, @RequestParam CompanyType newCompanyType) { + UserDto userDto = userService.updateCompanyType(userId, newCompanyType); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/add/interest") - public ResponseEntity addInterest(@PathVariable Long accountId, @RequestParam Interests newInterest) { - UserDto userDto = userService.addInterest(accountId, newInterest); + @PutMapping("/{userId}/add/interest") + public ResponseEntity addInterest(@PathVariable Long userId, @RequestParam Interests newInterest) { + UserDto userDto = userService.addInterest(userId, newInterest); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/add/skill") - public ResponseEntity addSkill(@PathVariable Long accountId, @RequestParam Skills newSkill) { - UserDto userDto = userService.addSkill(accountId, newSkill); + @PutMapping("/{userId}/add/skill") + public ResponseEntity addSkill(@PathVariable Long userId, @RequestParam Skills newSkill) { + UserDto userDto = userService.addSkill(userId, newSkill); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/add/skill-gap") - public ResponseEntity addSkillGap(@PathVariable Long accountId, @RequestParam Skills newSkillGap) { - UserDto userDto = userService.addSkillGap(accountId, newSkillGap); + @PutMapping("/{userId}/add/skill-gap") + public ResponseEntity addSkillGap(@PathVariable Long userId, @RequestParam Skills newSkillGap) { + UserDto userDto = userService.addSkillGap(userId, newSkillGap); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/add/favorite-course") - public ResponseEntity addFavoriteCourse(@PathVariable Long accountId, @RequestParam Integer newFavoriteCourse) { - UserDto userDto = userService.addFavoriteCourse(accountId, newFavoriteCourse); + @PutMapping("/favorite-course/{courseId}") + public ResponseEntity toggleFavoriteCourse(@PathVariable Integer courseId, Authentication authentication) { + System.out.println("im here"); + UserDto userDto = userService.toggleFavoriteCourse(authentication, courseId); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/remove/interest") - public ResponseEntity removeInterest(@PathVariable Long accountId, @RequestParam Interests oldInterest) { - UserDto userDto = userService.removeInterest(accountId, oldInterest); + @PutMapping("/{userId}/remove/interest") + public ResponseEntity removeInterest(@PathVariable Long userId, @RequestParam Interests oldInterest) { + UserDto userDto = userService.removeInterest(userId, oldInterest); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/remove/skill") - public ResponseEntity removeSkill(@PathVariable Long accountId, @RequestParam Skills oldSkill) { - UserDto userDto = userService.removeSkill(accountId, oldSkill); + @PutMapping("/{userId}/remove/skill") + public ResponseEntity removeSkill(@PathVariable Long userId, @RequestParam Skills oldSkill) { + UserDto userDto = userService.removeSkill(userId, oldSkill); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/remove/skill-gap") - public ResponseEntity removeSkillGap(@PathVariable Long accountId, @RequestParam Skills oldSkillGap) { - UserDto userDto = userService.removeSkillGap(accountId, oldSkillGap); + @PutMapping("/{userId}/remove/skill-gap") + public ResponseEntity removeSkillGap(@PathVariable Long userId, @RequestParam Skills oldSkillGap) { + UserDto userDto = userService.removeSkillGap(userId, oldSkillGap); return ResponseEntity.ok(userDto); } - @PutMapping("/{accountId}/remove/favorite-course") - public ResponseEntity removeFavoriteCourse(@PathVariable Long accountId, @RequestParam Integer oldFavoriteCourse) { - UserDto userDto = userService.removeFavoriteCourse(accountId, oldFavoriteCourse); + @PutMapping("/{userId}/remove/favorite-course") + public ResponseEntity removeFavoriteCourse(@PathVariable Long userId, @RequestParam Integer oldFavoriteCourse) { + UserDto userDto = userService.removeFavoriteCourse(userId, oldFavoriteCourse); return ResponseEntity.ok(userDto); } Index: backend/src/main/java/com/shifterwebapp/shifter/user/service/ImplUserService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/user/service/ImplUserService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/user/service/ImplUserService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -8,4 +8,5 @@ import com.shifterwebapp.shifter.enums.Interests; import com.shifterwebapp.shifter.enums.Skills; +import org.springframework.security.core.Authentication; import java.util.List; @@ -30,5 +31,5 @@ UserDto addSkills(Long id, List newSkills); UserDto addSkillGap(Long id, Skills newSkillGap); - UserDto addFavoriteCourse(Long id, Integer newFavoriteCourseId); + UserDto toggleFavoriteCourse(Authentication authentication, Integer newFavoriteCourseId); UserDto addPoints(Long id, Integer newPointsAchieved); UserDto addPayment(Long id, Payment newPayment); Index: backend/src/main/java/com/shifterwebapp/shifter/user/service/UserService.java =================================================================== --- backend/src/main/java/com/shifterwebapp/shifter/user/service/UserService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/main/java/com/shifterwebapp/shifter/user/service/UserService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -9,4 +9,5 @@ import com.shifterwebapp.shifter.user.*; import lombok.RequiredArgsConstructor; +import org.springframework.security.core.Authentication; import org.springframework.security.crypto.password.PasswordEncoder; import org.springframework.stereotype.Service; @@ -169,8 +170,12 @@ @Override - public UserDto addFavoriteCourse(Long accountId, Integer newFavoriteCourseId) { - validate.validateUserExists(accountId); - User user = userRepository.findById(accountId).orElseThrow(); - if (!user.getFavoriteCourses().contains(newFavoriteCourseId)) { + public UserDto toggleFavoriteCourse(Authentication authentication, Integer newFavoriteCourseId) { + String email = authentication.getName(); + User user = userRepository.findByEmail(email) + .orElseThrow(() -> new RuntimeException("User not found")); + + if (user.getFavoriteCourses().contains(newFavoriteCourseId)) { + user.getFavoriteCourses().remove(newFavoriteCourseId); + } else { user.getFavoriteCourses().add(newFavoriteCourseId); } Index: backend/src/test/java/com/shifterwebapp/shifter/unittests/TestReviewService.java =================================================================== --- backend/src/test/java/com/shifterwebapp/shifter/unittests/TestReviewService.java (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ backend/src/test/java/com/shifterwebapp/shifter/unittests/TestReviewService.java (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -69,5 +69,5 @@ Long courseId = 1L; - Mockito.when(reviewRepository.findAverageRatingByCourse(courseId)).thenReturn(5F); + Mockito.when(reviewRepository.findAverageRatingByCourse(courseId)).thenReturn(5.0); Mockito.doNothing().when(validate).validateCourseExists(courseId); Index: frontend/index.html =================================================================== --- frontend/index.html (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ frontend/index.html (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -3,5 +3,5 @@ - + Index: frontend/package-lock.json =================================================================== --- frontend/package-lock.json (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ frontend/package-lock.json (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -27,4 +27,5 @@ "react-router-dom": "^7.6.2", "react-slick": "^0.30.3", + "react-toastify": "^11.0.5", "slick-carousel": "^1.8.1", "tailwindcss": "^4.1.10", @@ -4929,4 +4930,17 @@ } }, + "node_modules/react-toastify": { + "version": "11.0.5", + "resolved": "https://registry.npmjs.org/react-toastify/-/react-toastify-11.0.5.tgz", + "integrity": "sha512-EpqHBGvnSTtHYhCPLxML05NLY2ZX0JURbAdNYa6BUkk+amz4wbKBQvoKQAB0ardvSarUBuY4Q4s1sluAzZwkmA==", + "license": "MIT", + "dependencies": { + "clsx": "^2.1.1" + }, + "peerDependencies": { + "react": "^18 || ^19", + "react-dom": "^18 || ^19" + } + }, "node_modules/react-transition-group": { "version": "4.4.5", Index: frontend/package.json =================================================================== --- frontend/package.json (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ frontend/package.json (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -29,4 +29,5 @@ "react-router-dom": "^7.6.2", "react-slick": "^0.30.3", + "react-toastify": "^11.0.5", "slick-carousel": "^1.8.1", "tailwindcss": "^4.1.10", Index: ontend/public/vite.svg =================================================================== --- frontend/public/vite.svg (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ (revision ) @@ -1,1 +1,0 @@ - Index: frontend/src/App.tsx =================================================================== --- frontend/src/App.tsx (revision ff6c3b7ddd4880243be29679e37d8a82d155513b) +++ frontend/src/App.tsx (revision 4f654cd20d3ada13e934fbcd263f09a30f194969) @@ -7,4 +7,8 @@ import Courses from "./pages/Courses.tsx"; import {useGlobalContext} from "./context/GlobalContext.tsx"; +import {useEffect} from "react"; +import CourseDetails from "./pages/CourseDetails.tsx"; +import { ToastContainer } from 'react-toastify'; +import 'react-toastify/dist/ReactToastify.css'; function LayoutWrapper() { @@ -21,8 +25,19 @@ } /> } /> + } /> {!hideLayout &&