Website

URL_HOLDER = 'https://polygonscan.com/token/0x6A8Ec2d9BfBDD20A7F5A4E89D640F7E7cebA4499'

Open api

URL_PRICE = 'https://openapi.digifinex.com/v3/ticker'
URL_CURRENCY = 'https://api.exchangerate-api.com/v4/latest/USD'

Target file path

FILE_PATH = '/var/www/html/customer/globalmsq.com/public_html/index.html'

Holder scrap

Find by class and stringify the data. By data processing, pick only required value.

holder_page = requests.get(URL_HOLDER).content
holder_soup = BeautifulSoup(holder_page, 'html.parser')
holder_result = holder_soup.find(class_="mr-3").text.strip().replace(' addresses', '')

Get coin price

By using get method, extract the msq_usdt price from open api in DIGIFINEX.

header = { "symbol": "msq_usdt" }
price = requests.get(URL_PRICE, header).json()["ticker"][0]["last"]

And then, set multiplier to exchange currency. (Use api of currency exchange rate)

currency = requests.get(URL_CURRENCY).json()["rates"]["KRW"]
price_result = "{:,}".format(round(price*currency, 2))

Edit original html file

Use find(class_="CLASS_NAME") method and index, replace the target value.

with open(FILE_PATH) as inf:
  soup = BeautifulSoup(inf.read(), 'html.parser')
  index = 0
  for tag in soup.find(class_="section section-01").find(class_="statistics").find_all(class_="value"):
    if index == 0:
      tag.string.replace_with(price_result + " KRW")
    if index == 2:
      tag.string.replace_with(holder_result)
    index += 1
  new_txt = soup.prettify()

Overwrite

with open(FILE_PATH, 'w') as new_file:
  new_file.write(new_txt)

Crontab script

It executes every 1 minute

* * * * * /usr/bin/python3 /var/www/html/customer/globalmsq.com/public_html/scrap.py

References

https://ostechnix.com/a-beginners-guide-to-cron-jobs/ https://towardsdatascience.com/how-to-schedule-python-scripts-with-cron-the-only-guide-youll-ever-need-deea2df63b4e

Get facebook social username, email, name and process password -> build

public class OAuth2DetailsService extends DefaultOAuth2UserService {

    private final UserRepository userRepository;

    @Override
    public OAuth2User loadUser(OAuth2UserRequest userRequest) throws OAuth2AuthenticationException {

        OAuth2User oAuth2User = super.loadUser(userRequest);

        Map<String, Object> userInfo = oAuth2User.getAttributes();

        String username = "facebook_" + (String) userInfo.get("id");
        String password = new BCryptPasswordEncoder().encode(UUID.randomUUID().toString());
        String email = (String) userInfo.get("email");
        String name = (String) userInfo.get("name");

        User userEntity = userRepository.findByUsername(username);
        if(userEntity == null) {
            User user = User.builder()
                    .username(username)
                    .password(password)
                    .email(email)
                    .name(name)
                    .role("ROLE_USER")
                    .build();
            return new PrincipalDetails(userRepository.save(user), oAuth2User.getAttributes());
        } else {
            return new PrincipalDetails(userEntity, oAuth2User.getAttributes());
        }
    }

}

Make an overload

public PrincipalDetails(User user, Map<String, Object> attributes) {
        this.user = user;
    }

Catch the facebook login users to append at PrincipalDetails data.

userId, imageId, content(length limits) Didn't use native query.

public class Comment {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(length = 100, nullable = false)
    private String content;

    @JsonIgnoreProperties({"images"})
    @JoinColumn(name = "userId")
    @ManyToOne(fetch = FetchType.EAGER)
    private User user;

    @JoinColumn(name = "imageId")
    @ManyToOne(fetch = FetchType.EAGER)
    private Image image;

    private LocalDateTime createDate;

    @PrePersist
    public void createDate() {
        this.createDate = LocalDateTime.now();
    }

}

Controller

Call addCmt and deleteCmt from CommentService. BindingResult -> AOP proccess

public class CommentApiController {

    private final CommentService commentService;

    @PostMapping("/api/comment")
    public ResponseEntity<?> commentSave(@Valid @RequestBody CommentDto commentDto, BindingResult bindingResult, @AuthenticationPrincipal PrincipalDetails principalDetails) {
        Comment comment = commentService.addCmt(commentDto.getContent(), commentDto.getImageId(), principalDetails.getUser().getId());
        return new ResponseEntity<>(new CMRespDto<>(1, "adding comment success", comment), HttpStatus.CREATED);
    }

    @DeleteMapping("/api/comment/{id}")
    public ResponseEntity<?> commentDelete(@PathVariable int id) {
        commentService.deleteCmt(id);
        return new ResponseEntity<>(new CMRespDto<>(1, "deleting comment success", null), HttpStatus.OK);
    }

}v

Service

Get the id from Image object and User object(for imageId and userId). When making object, insert id only. Therefore, it just returns image and user objects which have only id value. Set the comment by using setter(content, image, userEntity).

public class CommentService {

    private final CommentRepository commentRepository;
    private final UserRepository userRepository;

    @Transactional
    public Comment addCmt(String content, int imageId, int userId) {

        Image image = new Image();
        image.setId(imageId);

        User userEntity = userRepository.findById(userId).orElseThrow(() -> {
            throw new CustomApiException("Can't find user id");
        });

        Comment comment = new Comment();
        comment.setContent(content);
        comment.setImage(image);
        comment.setUser(userEntity);

        return commentRepository.save(comment);
    }

    @Transactional
    public void deleteCmt(int id) {
        try { // when it occurs error
            commentRepository.deleteById(id);
        } catch(Exception e) {
            throw new CustomApiException(e.getMessage());
        }
    }

}

AOP

proceedingJoinPoint: In apiController, can access to all target. apiAdvice pre execute than function in apiController.

public class ValidationAdvice {

    @Around("execution(* com.cos.photogram.web.api.*Controller.*(..))")
    public Object apiAdvice(ProceedingJoinPoint proceedingJoinPoint) throws Throwable {

        Object[] args = proceedingJoinPoint.getArgs();

        for (Object arg: args) {
            if(arg instanceof BindingResult) {
                BindingResult bindingResult = (BindingResult) arg;

                if (bindingResult.hasErrors()) {
                    Map<String, String> errorMap = new HashMap<>();
                    for (FieldError error : bindingResult.getFieldErrors()) {
                        errorMap.put(error.getField(), error.getDefaultMessage());
                    }
                    throw new CustomValidationApiException("Validation check failed", errorMap);
                }
            }
        }

        return proceedingJoinPoint.proceed(); // execute origin function
    }

    @Around("execution(* com.cos.photogram.web.*Controller.*(..))")
    public Object advice(ProceedingJoinPoint proceedingJoinPoint) throws Throwable {

        Object[] args = proceedingJoinPoint.getArgs();

        for (Object arg: args) {
            if(arg instanceof BindingResult) {
                BindingResult bindingResult = (BindingResult) arg;

                if (bindingResult.hasErrors()) { // pre-processing
                    Map<String, String> errorMap = new HashMap<>();
                    for (FieldError error : bindingResult.getFieldErrors()) {
                        errorMap.put(error.getField(), error.getDefaultMessage());
                    }
                    throw new CustomValidationException("Validation check failed", errorMap);
                }
            }
        }

        return proceedingJoinPoint.proceed();
    }

}

Bug fix

Prob. Like button infinite recursion

When like button is on active, it can't load the image.

Sol. JsonIgnoreProperties

In Image domain, it imports likes and likes imports image again. Therefore, when imporing likes, add this code

@JsonIgnoreProperties({"image"})

Result:

In ImageRepository, add the native query to select images from following users. Get the image from toUserId and show in the fromUserId's feed.

public interface ImageRepository extends JpaRepository<Image, Integer> {

    @Query(value = "SELECT * FROM image WHERE userId IN (SELECT toUserId FROM subscribe WHERE fromUserId = :principalId) ORDER BY id DESC", nativeQuery = true)
    Page<Image> mStory(int principalId, Pageable pageable);

}

In ImageService, import images from ImageRepository

public Page<Image> imageStory(int principalId, Pageable pageable) {
    Page<Image> images = imageRepository.mStory(principalId, pageable);
    return images;
}

Use ImageApiController and call the imageService. (There are 5 images in one page by default)

public class ImageApiController {

    private final ImageService imageService;

    @GetMapping("/api/image")
    public ResponseEntity<?> imageStory(@AuthenticationPrincipal PrincipalDetails principalDetails,
                                        @PageableDefault(size = 5) Pageable pageable) {
        Page<Image> images = imageService.imageStory(principalDetails.getUser().getId(), pageable);
        return new ResponseEntity<>(new CMRespDto<>(1, "Success", images), HttpStatus.OK);
    }

}

Likes

Model

Get imageId from Image class by using native query. Below code is interface

public interface LikesRepository extends JpaRepository<Likes, Integer> {

    @Modifying
    @Query(value = "INSERT INTO likes(imageId, userId, createDate) VALUES(:imageId, :principalId, now())", nativeQuery = true)
    int mLikes(int imageId, int principalId);

    @Modifying
    @Query(value = "DELETE FROM likes WHERE imageId = :imageId AND userId = :principalId", nativeQuery = true)
    int mUnLikes(int imageId, int principalId);

}

Controller

Make controller in ImageApiController. 'likes', 'unlikes' and each mapping -> PostMapping, DeleteMapping. add below

@PostMapping("/api/image/{imageId}/likes")
public ResponseEntity<?> likes(@PathVariable int imageId, @AuthenticationPrincipal PrincipalDetails principalDetails) {
    likesService.like(imageId, principalDetails.getUser().getId());
    return new ResponseEntity<>(new CMRespDto<>(1, "Like Success", null), HttpStatus.CREATED);
}

@DeleteMapping("/api/image/{imageId}/likes")
public ResponseEntity<?> unLikes(@PathVariable int imageId, @AuthenticationPrincipal PrincipalDetails principalDetails) {
    likesService.unLike(imageId, principalDetails.getUser().getId());
    return new ResponseEntity<>(new CMRespDto<>(1, "Unlike success", null), HttpStatus.CREATED);
}

Service

Get mLikes(imageId, principalId), mUnLikes(imageId, principalId) from LikesRepository.

Bug fix

In Likes model, import User -> Images -> User, Likes ... Therefore, add under code to the private User in Likes.

@JsonIgnoreProperties({"images"})

Domain

1. user id
2. caption
3. post image url

public class Image {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    private String caption;
    private String postImageUrl; // Image will be saved as folder in server - insert path in DB

    @JoinColumn(name="userId")
    @ManyToOne
    private User user;

    private LocalDateTime createDate;

    @PrePersist
    public void createDate() {
        this.createDate = LocalDateTime.now();
    }

}

Dto is used to build caption, postImageUrl, user.

Service

Get the file path from application.yml, image name is made by UUID_{originalFileName}.

Therefore, image file and path are saved to image table(imageRepository).

@Transactional
public void imageUpload(ImageUploadDto imageUploadDto, PrincipalDetails principalDetails) {

    UUID uuid = UUID.randomUUID();
    String imageFileName = uuid + "_" + imageUploadDto.getFile().getOriginalFilename();

    Path imageFilePath = Paths.get(uploadFolder + imageFileName);

    // Communication, I/O -> can occur exception
    try {
        Files.write(imageFilePath, imageUploadDto.getFile().getBytes());
    } catch (Exception e) {
        e.printStackTrace();
    }

    // save to image table
    Image image = imageUploadDto.toEntity(imageFileName, principalDetails.getUser());
    imageRepository.save(image);

}

In controller, throw exception if image is not found.

Subscription

Domain

1. user id
2. from user
3. to user

@Table(
        uniqueConstraints = {
                @UniqueConstraint(
                        name="subscribe_uk",
                        columnNames = {"fromUserId", "toUserId"}
                )
        }
)
public class Subscribe {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @JoinColumn(name="fromUserId")
    @ManyToOne
    private User fromUser;

    @JoinColumn(name="toUserId")
    @ManyToOne
    private User toUser;

    private LocalDateTime createDate;

    @PrePersist
    public void createDate() {
        this.createDate = LocalDateTime.now();
    }

}

('fromUser', 'toUser') set is unique. (use @uniqueConstraints)

Service

First in SubscribeRepository, make 'create, delete set' method. (by using native query)

public interface SubscribeRepository extends JpaRepository<Subscribe, Integer> {

    @Modifying // for INSERT, DELETE, UPDATE in native query
    @Query(value = "INSERT INTO subscribe(fromUserId,toUserId,createDate) VALUES(:fromUserId,:toUserId,now())", nativeQuery = true)
    void mSubscribe(int fromUserId, int toUserId); // 1(success, number of changed row), 0(not executed), -1(fail)

    @Modifying
    @Query(value = "DELETE FROM subscribe WHERE fromUserId=:fromUserId AND toUserId=:toUserId", nativeQuery = true)
    void mUnSubscribe(int fromUserId, int toUserId); // 1, -1

}

Back to service, access to repository and throw exception about any prob.

public class SubscribeService {

    private final SubscribeRepository subscribeRepository;

    @Transactional
    public void sub(int fromUserId, int toUserId) {
        try {
            subscribeRepository.mSubscribe(fromUserId, toUserId);
        } catch(Exception e) {
            throw new CustomApiException("Already subscribed");
        }
    }

    @Transactional
    public void unSub(int fromUserId, int toUserId) {
        subscribeRepository.mUnSubscribe(fromUserId, toUserId);
    }

}

apiController

Use ResponseEntity<> with PostMapping and DeleteMapping, call the service logic.

public class SubscribeApiController {

    private final SubscribeService subscribeService;

    @PostMapping("/api/subscribe/{toUserId}")
    public ResponseEntity<?> subscribe(@AuthenticationPrincipal PrincipalDetails principalDetails, @PathVariable int toUserId) {
        subscribeService.sub(principalDetails.getUser().getId(), toUserId);
        return new ResponseEntity<>(new CMRespDto<>(1, "Subscription success", null), HttpStatus.OK);
    }

    @DeleteMapping("/api/subscribe/{toUserId}")
    public ResponseEntity<?> unSubscribe(@AuthenticationPrincipal PrincipalDetails principalDetails, @PathVariable int toUserId) {
        subscribeService.unSub(principalDetails.getUser().getId(), toUserId);
        return new ResponseEntity<>(new CMRespDto<>(1, "Unsubscription success", null), HttpStatus.OK);
    }

}

In previous post, CustomValidationException catch the signup validation exception (username, password, email, name)

For the Edit user info, create CustomValidationApiException.

public class CustomValidationApiException extends RuntimeException {

    private static final long serialVersionUID = 1L;

    private Map<String, String> errorMap;

    public CustomValidationApiException(String message, Map<String, String> errorMap) {
        super(message);
        this.errorMap = errorMap;
    }

    public CustomValidationApiException(String message) {
        super(message);
    }

    public Map<String, String> getErrorMap() {
        return errorMap;
    }

}

ControllerExceptionHandler

Rewrite to

@ExceptionHandler(CustomValidationException.class)
public String validationException(CustomValidationException e) {
    return Script.back(e.getErrorMap().toString()); // return javascript
}

@ExceptionHandler(CustomValidationApiException.class)
public ResponseEntity<CMRespDto<?>> validationApiException(CustomValidationApiException e) {
    return new ResponseEntity<>(new CMRespDto<>(-1, e.getMessage(), e.getErrorMap()), HttpStatus.BAD_REQUEST); // return data
}

note) Comparison of CMRespDto and Script 1. Response with client - Script 2. Ajax communication - CMRespDto 3. Android communication - CMRespDto

IDE: Intellij DB: Mariadb Framework: Spring boot Compile: Maven (will convert to Gradle) Port: 3307 Views: jsp

Almost front-end settings are done.

Security setting

@Override
    protected void configure(HttpSecurity http) throws Exception {
        http.csrf().disable();
        http.authorizeRequests()
                .antMatchers("/", "/user/**", "/image/**", "/subscribe/**", "/comment/**", "/api/**").authenticated()
                .anyRequest().permitAll()
                .and()
                .formLogin()
                .loginPage("/auth/signin") // GET
                .loginProcessingUrl("/auth/signin") // POST -> spring security proceed login
                .defaultSuccessUrl("/");
    }

Routes to "/", "/user/", "/image/", "/subscribe/", "/comment/", "/api/~" should be authenticated. Default is login page. (GET request -> view page, POST request -> validation method)

Domain(User)

public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) // Strategy of increasing number follow the DB
    private int id;

    @Column(unique = true)
    private String username;
    @Column(nullable = false)
    private String password;

    @Column(nullable = false)
    private String name;
    private String bio;
    private String gender;

    @Column(nullable = false)
    private String email;
    private String phone;
    private String website;

    private String profileImageUrl;
    private String role;

    private LocalDateTime createDate;

    @PrePersist
    public void createDate() {
        this.createDate = LocalDateTime.now();
    }

}

User domain session

Auth

Get UserDetail interface to PrincipalDetails -> Override Didn't consider about account expiration, lock, enable

public class PrincipalDetails implements UserDetails {

    private static final long serialVersionUID = 1L;

    private User user;

    public PrincipalDetails(User user) {
        this.user = user;
    }

    @Override
    public Collection<? extends GrantedAuthority> getAuthorities() {
        Collection<GrantedAuthority> collector = new ArrayDeque<>();
        collector.add(() -> {return user.getRole();});
        return collector;
    }

    @Override
    public String getPassword() {
        return user.getPassword();
    }

    @Override
    public String getUsername() {
        return user.getUsername();
    }

    @Override
    public boolean isAccountNonExpired() {
        return true; // return user.getExpired();
    }

    @Override
    public boolean isAccountNonLocked() {
        return true;
    }

    @Override
    public boolean isCredentialsNonExpired() {
        return true;
    }

    @Override
    public boolean isEnabled() {
        return true;
    }
}

public class PrincipalDetailsService implements UserDetailsService {

    private final UserRepository userRepository;

    // 1. Password: auto check
    // 2. Return(o) -> auto make UserDetails type to session
    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {

        User userEntity = userRepository.findByUsername(username);

        if (userEntity == null) {
            return null;
        } else {
            return new PrincipalDetails(userEntity);
        }

    }

}

Controllers

AuthController

public class AuthController {

    private final AuthService authService;

    @GetMapping("/auth/signin")
    public String signinForm() {
        return "auth/signin";
    }

    @GetMapping("/auth/signup")
    public String signupForm() {
        return "auth/signup";
    }

    @PostMapping("/auth/signup")
    public String signup(@Valid SignupDto signupDto, BindingResult bindingResult) {

        if (bindingResult.hasErrors()) {
            Map<String, String> errorMap = new HashMap<>();
            for (FieldError error : bindingResult.getFieldErrors()) {
                errorMap.put(error.getField(), error.getDefaultMessage());
            }
            throw new CustomValidationException("Validation check failed", errorMap);
        } else {
            User user = signupDto.toEntity();
            User userEntity = authService.signupService(user);
            System.out.println(userEntity);
            return "auth/signin";
        }

    }

}

UserController

public class UserController {

    @GetMapping("/user/{id}")
    public String profile(@PathVariable int id) {
        return "user/profile";
    }

    @GetMapping("/user/{id}/update")
    public String update(@PathVariable int id, @AuthenticationPrincipal PrincipalDetails principalDetails) {
        return "user/update";
    }

}

UserApiController (RestController)

public class UserApiController {

    private final UserService userService;

    @PutMapping("/api/user/{id}")
    public CMRespDto<?> update(@PathVariable int id, UserUpdateDto userUpdateDto, @AuthenticationPrincipal PrincipalDetails principalDetails) {
        User userEntity = userService.editUser(id, userUpdateDto.toEntity());
        principalDetails.setUser(userEntity);
        return new CMRespDto<>(1, "User info edit successfully", userEntity);
    }

}

Services

AuthService

public class AuthService {

    private final UserRepository userRepository;
    private final BCryptPasswordEncoder bCryptPasswordEncoder;

    @Transactional // Write(Insert, Update, Delete)
    public User signupService(User user) {
        String rawPassword = user.getPassword();
        String encPassword = bCryptPasswordEncoder.encode(rawPassword);
        user.setPassword(encPassword);
        user.setRole("ROLE_USER");
        User userEntity = userRepository.save(user);
        return userEntity;
    }

}

Logic of user authentication (Signup) By default, role is ROLE_USER

UserService

public class UserService {

    private final UserRepository userRepository;
    private final BCryptPasswordEncoder bCryptPasswordEncoder;

    @Transactional
    public User editUser(int id, User user) {
        // 1. Persistence
        User userEntity = userRepository.findById(id).get();

        // 2. Edit object - Dirty checking(update finished)
        userEntity.setName(user.getName());

        String rawPassword = user.getPassword();
        String encPassword = bCryptPasswordEncoder.encode(rawPassword);
        userEntity.setPassword(encPassword);

        userEntity.setBio(user.getBio());
        userEntity.setWebsite(user.getWebsite());
        userEntity.setPhone(user.getPhone());
        userEntity.setGender(user.getGender());

        return userEntity;
    }

}

Edit user info

Exception management

Catch RuntimeException (extended by CustomValidationException)

public class CustomValidationException extends RuntimeException {

    private static final long serialVersionUID = 1L;

    private Map<String, String> errorMap;

    public CustomValidationException(String message, Map<String, String> errorMap) {
        super(message);
        this.errorMap = errorMap;
    }

    public Map<String, String> getErrorMap() {
        return errorMap;
    }

}

ControllerExceptionHandler

public class ControllerExceptionHandler {

    @ExceptionHandler(CustomValidationException.class)
    public String validationException(CustomValidationException e) {
        // Comparison of CMRespDto, Script
        // 1. Script is better for response with client
        // 2. Ajax communication - CMRespDto
        // 3. Android communication - CMRespDto
        return Script.back(e.getErrorMap().toString());
    }

}

Refer the comments

Packages

Download and log in to Heroku

$ heroku login

Create a new Git repository

Initialize a git repository

$ cd my-project
$ git init
$ heroku git:remote -a app-name

Deploy my application

Commit the code to repository

$ git add .
$ git commit -am "commit-message"
$ git push heroku main

Existing Git repository

Simply add the heroku remote

$ heroku git:remote -a todo-management-seop

Source

Install guide

https://devcenter.heroku.com/articles/heroku-cli https://dashboard.heroku.com/apps/todo-management-seop/deploy/heroku-git

add the code below to Gemfile

gem "simple_calendar", "~> 2.4"

start bundle

$ bundle install

Set scoffild

$ gem g scoffild Schedules tutor_id:integer start_time:datetime active:integer

parameters - tutor_id, start_time, active(1: available, 2: unavailable)

home.html.erb

Set the home

<h1>Enrollment Page</h1>
<p id="notice" style="color: red"><%= notice %></p>
<hr>
<h3>Input your class format</h3>
<form action="/calendar" method="get">
  Find your tutor (id): <input type="string" name="tutor_id" placeholder="1 ~ 5"/><br>
  Set the time (min): <input type="string" name="time" placeholder="20 or 40"/><br>
  <input type="submit"/>
</form>
<br>
<h3>For tutors</h3>
<form action="/tutor_schedules" method="get">
  Type your tutor id: <input type="string" name="tutor_id" placeholder="1 ~ 5"/><br>
  <input type="submit"/>
</form>
<br>
<a href="/index">Show total schedules</a>

index.html.erb

Load total week-calendar

<h1>Schedules</h1>

<%= link_to 'New Schedules', new_schedule_path %>
<a href='/home'> Back to home </a>
<br><br>

<%= week_calendar events: @schedules do |date, schedules| %>
  <div style="font-weight: 700">
  <%= date %>
  </div>
  <hr>
  <% schedules.each do |schedules| %>
    <div>
      <%= schedules.tutor_id %> / 
      <%= schedules.start_time.hour %>:<% if schedules.start_time.min == 0 %>00
      <% else %><%= schedules.start_time.min %>
      <% end %> / 
      <span style="font-weight: 600">
      <% if schedules.active == 1 %>
      Available
      <% else %>
      Unavailable
      <% end %>
    </div>
  <% end %>
<% end %>

tutor_schedules.html.erb

Tutor-schedules

<h1>Schedules</h1>
<%= link_to 'New Schedules', new_schedule_path %>
<a href='/home'> Back to home </a>
<br><br>

<%= week_calendar events: @schedules do |date, schedules| %>
  <div style="font-weight: 700">
  Date
  <%= date %>
  </div>
  <hr>
  <% schedules.each do |schedules| %>
    <div>
      <%= schedules.tutor_id %>
      <%= schedules.start_time.hour %>:<% if schedules.start_time.min == 0 %>00
      <% else %><%= schedules.start_time.min %>
      <% end %>
      <% if schedules.active == 1 %>
      Available
      <% else %>
      Unavailable
      <% end %>
      <%= link_to 'Show', schedules %>
    </div>
  <% end %>
<% end %>

calendar.html.erb

Enroll by tutor_id, class running time

<h1>Schedules</h1>

<a href='/home'> Back to home </a><br>
<br>

<%= week_calendar events: @schedules do |date, schedules| %>
  <div style="font-weight: 700">
  Date
  <%= date %>
  </div>
  <hr>

  <% if @time == "20" %>
    <% schedules.each do |schedules| %>
      <div>
        <%= schedules.tutor_id %>
        <%= schedules.start_time.hour %>:<% if schedules.start_time.min == 0 %>00
        <% else %><%= schedules.start_time.min %>
        <% end %>
        <% if schedules.active == 1 %>
        <span style="color: green; font-weight: 600">Available</span><br>
        <% else %>
        <span style="color: gray; font-weight: 600">Unavailable</span><br>
        <% end %>
      </div>
    <% end %>

  <% elsif @time == "40" %>
    <% schedules.each do |schedules| %>
      <div>
        <%= schedules.tutor_id %>
        <%= schedules.start_time.hour %>:<% if schedules.start_time.min == 0 %>00
        <% else %><%= schedules.start_time.min %>
        <% end %>
        <% if schedules.active == 1 %>
          <%= render :template => "schedules/search_next", :locals => {:@next_time => schedules.start_time + 30*60, :@sheet => @schedules} %>
        <% elsif schedules.active == 2 %>
          <span style="color: gray; font-weight: 600">Unavailable</span><br>
        <% end %>
      </div>
    <% end %>
  <% end %>

<% end %>

For 40 min class, pass the parameter of 'schedules.start_time + 30*60(sec)' to search_next.html.erb

search_next.html.erb

Search if next class is available

<% @sheet.each_with_index do |schedules, index| %>
  <% if schedules.start_time == @next_time %>
    <% if schedules.active == 1 %>
      <span style="color: green; font-weight: 600">Available</span><br>
    <% elsif schedules.active == 2%>
      <span style="color: gray; font-weight: 600">Unavailable</span><br>
    <% end %>
  <% end %>
<% end %>

schedules_controller.rb

class SchedulesController < ApplicationController
  before_action :set_schedule, only: %i[ show edit update destroy ]

  # GET /schedules or /schedules.json
  def home
  end

  def calendar
    @id = params[:tutor_id]
    @time = params[:time]
    @schedules = Schedule.where(tutor_id: @id)
    if (@id.to_i<1) || (@id.to_i>5)
      redirect_to '/home', notice: "Tutor not found."
    elsif (@time.to_i != 20) && (@time.to_i != 40)
      redirect_to '/home', notice: "Class duration not found."
    end
  end

  def tutor_schedules
    @id = params[:tutor_id]
    @schedules = Schedule.where(tutor_id: @id)
  end

  def index
    @schedules = Schedule.all
  end

  # GET /schedules/1 or /schedules/1.json
  def show
  end

  # GET /schedules/new
  def new
    @schedule = Schedule.new
  end

  # GET /schedules/1/edit
  def edit
  end

  # POST /schedules or /schedules.json
  def create
    @schedule = Schedule.new(schedule_params)

    respond_to do |format|
      if @schedule.save
        format.html { redirect_to schedule_url(@schedule), notice: "Schedule was successfully created." }
        format.json { render :show, status: :created, location: @schedule }
      else
        format.html { render :new, status: :unprocessable_entity }
        format.json { render json: @schedule.errors, status: :unprocessable_entity }
      end
    end
  end

  # PATCH/PUT /schedules/1 or /schedules/1.json
  def update
    respond_to do |format|
      if @schedule.update(schedule_params)
        format.html { redirect_to schedule_url(@schedule), notice: "Schedule was successfully updated." }
        format.json { render :show, status: :ok, location: @schedule }
      else
        format.html { render :edit, status: :unprocessable_entity }
        format.json { render json: @schedule.errors, status: :unprocessable_entity }
      end
    end
  end

  # DELETE /schedules/1 or /schedules/1.json
  def destroy
    @schedule.destroy

    respond_to do |format|
      format.html { redirect_to schedules_url, notice: "Schedule was successfully destroyed." }
      format.json { head :no_content }
    end
  end

  # DELETE all schedules
  def total_destroy
    @schedules = Schedule.all
    @schedules.each do |schedule|
      schedule.destroy
    end
    redirect_to '/index'
  end

  def import
    Schedule.import(params[:file])
    redirect_to schedules_path, notice: "Schedules Added Successfully"
  end

  private
    # Use callbacks to share common setup or constraints between actions.
    def set_schedule
      @schedule = Schedule.find(params[:id])
    end

    # Only allow a list of trusted parameters through.
    def schedule_params
      params.require(:schedule).permit(:tutor_id, :start_time, :active)
    end
end

Results

home page enroll class page total classes

References

Ruby on Rails guide

https://rubykr.github.io/rails_guides/getting_started.html

Install Ruby on Rails

https://ringle.notion.site/rails-mac-a9f4437721a74b19baf9c526b1823b9a

Implement simple-calendar

https://linuxtut.com/implement-a-reservation-system-using-rails-and-simple-calendar!-let%27s-add-validation-to-datetime!-2a900/

Simple-calendar github origin guide

https://github.com/excid3/simple_calendar

Render with locals

https://apidock.com/rails/ActionController/Base/render https://stackoverflow.com/questions/19907178/rails-partial-locals-not-working

Pass parameters in the 'a href' tag

https://stackoverflow.com/questions/18276073/passing-params-to-href-in-rails

Import CSV file

https://www.youtube.com/watch?v=_NSBm_Q431Y

Ruby on Rails basic

https://www.youtube.com/watch?v=iNrT0O2_MQM&list=PLEBQPmkNcLCIE9ERi4k_nUkGgJoBizx6s

sol)

install 'rvm'

https://zwbetz.com/install-ruby-version-manager-on-mac/

run this command

$ rvm fix-permissions

Prob 2. 'rails server' command not working

errMsg1:

/Users/seop/.rvm/gems/ruby-3.0.0/gems/webpacker-5.4.3/lib/webpacker/configuration.rb:103:in `rescue in load': Webpacker configuration file not found /Users/seop/cdTask/config/webpacker.yml. Please run rails webpacker:install Error: No such file or directory @ rb_sysopen - /Users/seop/cdTask/config/webpacker.yml (RuntimeError)

errMsg2:

/Users/seop/.rvm/rubies/ruby-3.0.0/lib/ruby/3.0.0/psych.rb:581:in `initialize': No such file or directory @ rb_sysopen - /Users/seop/cdTask/config/webpacker.yml (Errno::ENOENT)

sol)

run this command

$ rails webpacker:install

Prob 3. Routing Error

errMsg:

No route matches [GET] "/posts/ssg-ssr"

sol)

open the link in the vscode terminal (not just type 'localhost:3000')

Result

https://www.youtube.com/watch?v=iY_vmP-Q3Ak&list=PLuHgQVnccGMCEfBwnNGsJCQDiqSWI-edj

useReducer vs Redux

https://www.imaginarycloud.com/blog/react-hooks-vs-redux/

https://redux.js.org/introduction/core-concepts

custom myLocationButton and zoomButtons

https://github.com/react-native-maps/react-native-maps/issues/1874

https://blog.logrocket.com/react-native-maps-introduction/

Functional components VS Class components

https://www.twilio.com/blog/react-choose-functional-components

  await Location.getCurrentPositionAsync({
    accuracy:
      Platform.OS === "ios"
        ? Location.Accuracy.Balanced
        : Location.Accuracy.Low,
  })

https://docs.expo.dev/versions/latest/sdk/location/#enabling-emulator-location https://snack.expo.dev

https://ebbnflow.tistory.com/268

https://www.npmjs.com/package/rn-sliding-up-panel https://github.com/octopitus/rn-sliding-up-panel/blob/master/README.md

import SlidingUpPanel from 'rn-sliding-up-panel'

https://github.com/react-native-maps/react-native-maps

Marker

import { Marker } from 'react-native-maps';

https://medium.com/geekculture/mapview-in-expo-react-native-5aa69eb81519

Kakao search api

https://m.blog.naver.com/kiddwannabe/221812712712 https://developers.kakao.com/docs/latest/ko/local/dev-guide#search-by-keyword

useState useEffect

https://xiubindev.tistory.com/97

git command

https://github.com/joshnh/Git-Commands

React-native naver-map

Android - can't run emulator iOS - some bugs