Announcement Webpage Add.Function

As of February 2021, this is an experience that I was in charge of as an internal development at my current job.

http://infrait.co.kr/bbs/notice.asp

Requirements:

1. You need to make photo 1 (the existing homepage) look like photo 2 (the desired look).
2. You must meet the requirements below.
   1. Add 'period'
   2. ‘Processing status output’ according to ‘period’

Skills:

1. ASP-HTML
   1. FORM, etc.
2. JAVASCRIPT
3. DB (Microsoft DB Server Management Service)

process:

1. Add 'period' to DB table of each post
   1. Modify the ‘Write a post’ and ‘Edit post’ pages related to the notice/event page
      1. general homepage
         1. Edit post list display
         2. Edit each post edit page
      2. admin page
         1. Edit post creation page
         2. Edit post Edit page
   2. Edit related DB connected to each post
2. Check output

Form type:

The period has been added as above. Because it is a period, I created two values ​​(bperiod1, bperiod2).

• First, as shown above, bperiod1 and bperiod2 were added to the variables, SQL statements, and forms in the write.asp and save.asp files.

Database

• In the DB Table, bperiod1 and bperiod2 were designated as datetime variables.

  • In order to create a 'processing status' after comparing the values ​​later, it was set to datetime.

• The picture above is index.asp. That is, the main page. Looking here, it says /board/list.asp is the one that uses include to print out notices in the db.

• The picture above is list.asp. Additionally, I created variables bPeriod1 & 2, loaded them from the DB, added the values, and added the period to the post title (if bbs="notice" if it was a notice board) to display it.

• The list page is finished as shown above.

admin page

• What you see above is the list of 'Notices/Events' posts on the administrator page, and you can see the 'Write' button below.
• Click the write button → write page

Existing writing style

Writing after adding features

• The writing/editing page was modified to change as shown above, and the code in save.asp was also modified as shown in the picture below so that period1 and period2 are also saved in the DB.

• And the photo above shows the ‘Write’ and ‘Modify’ functions at the bottom of each post.

  • The above two pages also need to be modified.

test

• An input was provided so that a period could be entered on the write/edit page of the administrator page.
• By writing code in the save.asp file linked to the administrator page, period variables accepted as input can be saved to the DB.
• Even on general homepages, you can get the value from the DB, print the period, compare the last date of the period and the current date, and print the progress status as 'in progress' or 'closed'.
• They said that the edit function is not used on the general homepage, so the feature additions that were in progress were left as is.

Impressions and Reviews:

• Although I had used it before, the functions were not used often, so when problems or difficulties arose, I had to solve them on my own. By going through various included files, I can now look at the code myself, find out which functions are connected to which other functions or pages, analyze them, refer to functions similar to the desired function, and develop additional functions through Googling. I was able to.
• I also felt that I had become much more proficient in using DB management. I was able to find the connected DB and Table, add the necessary variables to the DB/Table, and also input values ​​into each data for testing.
• Since the functions are implemented on one page, it was a page that used many includes and switches, so it was very complicated. However, by thinking, implementing, and applying each one separately, I think I was able to implement the desired functions well without any problems.