ValuAg Team 2: Difference between revisions

From CS486wiki
Jump to navigationJump to search
Content deleted Content added
 
(33 intermediate revisions by the same user not shown)
Line 1: Line 1:

'''Date''': 2/6/2022
== Week 1 ==
== Week 1 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- Presented the last semester's project.
- Presented the last semester's project.
Line 7: Line 9:
'''To Do''' :
'''To Do''' :
- Migrate the PHP project with Wordpress.
- Migrate the PHP project with Wordpress.

'''Obstacles''' :
- No obstacles this week.




'''Date''': 2/13/2022
== Week 2 ==
== Week 2 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- Started looking into Wordpress page template structure.
- Started looking into Wordpress page template structure.
Line 21: Line 27:
- Couldn't figure out how to do CRUD operations due to not knowing how to manipulate database of Wordpress for it.
- Couldn't figure out how to do CRUD operations due to not knowing how to manipulate database of Wordpress for it.


'''Date''': 2/20/2022


== Week 3 ==
== Week 3 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- Fixed some logical mistakes in some actions.
- Fixed some logical mistakes in some actions.
Line 36: Line 43:
- Couldn't fix transplant, but did fix other actions.
- Couldn't fix transplant, but did fix other actions.


'''Date''': 2/27/2022


== Week 4 ==
== Week 4 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- Added seed_id_table to the database, which fixes a lot of issues.
- Added seed_id_table to the database, which fixes a lot of issues.
- With new table we did add a search function depending on seed id.
- With new table we did add a search function depending on seed id.
- Created 2 php files, one of search other for showing the results in a table.
- Created 2 php files, one of search other for showing the results in a table.
- Also, showed this in Zoom meeting.



'''To Do''':
'''To Do''':
Line 54: Line 62:


'''Date''': 3/6/2022
== Week 5 ==
== Week 5 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- User database table. Now we can put the employee name who did the action to the database.
- User database table. Now we can put the employee name to the database.
- Fixed an error in search and show result pages.
- Fixed an error in search and show result pages.
- Presented everything.
'''To Do''':
'''To Do''':
Line 65: Line 75:
- Sprout will be added soon, find out how to implement it too.
- Sprout will be added soon, find out how to implement it too.


'''Obstacles''':

- Search functionality got broken because of some variable names, couldn't figured this out took hours to fix.
'''Date''': 3/13/2022
- Wordpress stores users in a different table which I couldn't find at first and after finding took a while to figure out,


== Week 6 ==
== Week 6 ==
'''Attendance''': Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- Implemented Sprout process.
- Started working on versioning. Opened up the a Github repository.
- Started working on versioning. Opened up the a Github repository.
- Added CSS and animations to website and presented it to Mr Dutcher as an option for UI.
- Added CSS and animations to website and presented it to Mr Dutcher as an option for UI.
Line 77: Line 91:
- Add color tag to tables.
- Add color tag to tables.


'''Date''': 3/20/2022
'''Obstacles''':
- Sprout process is as big as other process, so it took lots of work to complete.


== Week 7 ==
== Week 7 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner
'''Accomplishments''':
'''Accomplishments''':
- Presented Sprout process.
- Presented Sprout process.
Line 85: Line 102:
- Company logo is added to home page.
- Company logo is added to home page.
- Added Bootsrap to the site.
- Added Bootsrap to the site.
- Added colored circles next to the colors.
- A JavaScript script added to make dropdown lists show the appropriate data when selected.
- A JavaScript script added to make dropdown lists show the appropriate data when selected.
- Button sizes fixed on home page.
- Button sizes fixed on home page.


'''To Do''':
'''To Do''':
- Open a Github to work on versioning.
- Planning to add automation steps working with other team.
- Planning to add automation steps working with other team.
- Add color tags and make text align center.
- Push site to web.


'''Date''': 3/27/2022


== Week 8 ==
== Week 8 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
'''Accomplishments''':
- We added a report page to show every harvested item depending on selected date and color.
- All the latest implementations pushed to the GitHub
- All the latest implementations pushed to the GitHub
- We added color tags next to color names in tables and dropdown menus.
- Both design files and PHP files got merged
- Company logo path fixed on CSS file
- Company logo path fixed on CSS file
- Live version of the site pushed to the EC-2 instance
- Live version of the site pushed to the EC-2 instance
- print function has been created and the function takes the color tag as an input and returns harvested items with the same color tag.


'''To Do''':
'''To Do''':
- Add a report page to show some data. (Didn't talk about which data to put in tables.) This report has 2 inputs, date and color.
- We have been assigned to push site to EC-2 instance

- We have been assigned to add print function
'''Obstacles''':
- Adding the color tag was harder than we thought.
- MySQL database doesn't support that kind of characters, and putting it in html means it isn't responsive.


== Week 9 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
- Added Report page template to our site. Which shows data from given input (date and color).
- Pushed everything to internet and made them compatible with each other.

'''To Do''':
- Integrate 2 websites with the other team.
- Add background image to header side of the page.

'''Obstacles''':
- Getting 2 different data from different tables and putting them together.


== Week 10 - 04-11 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
- Meeting with Talha about team 1's website, how they hold data etc.
- Presented new updates on the website.
- Talked about where to put company logo and background image in all pages.
- Tests are done in plant and treat actions to make sure they work accordingly.

'''To Do''':
- Wait for other team to develop their site for us to integrate.
- Domain name.
- Fix the security problem.
- Put company logo and background image to all pages.
- Add s/ and h/ to dropdown menus, s for sprout h for normal. Or put a line between sprouts and normal plants.

'''Obstacles''':
- Can only change some part of header part of the page, showed this in meeting to get a feedback.


== Week 11 04-18 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
- UI upgrades
- Navigation bar fixed on mobile.
- Added transparent logo in every screen.
- Background image is fixed(scroll off).
- Added -h before herbs and -s before sprouts in planting page.
- Auto suggest in input areas are off now.
- Changed header.php so we can implement all of the above.

'''To Do''':
- Add line between logo and actions
- Add a blank entry to database
- Try to implement calendar in report page.
- Change "Choose color" to "Choose harvesting color"
- Tutorial video.

'''Obstacles''':
- Wordpress header was the biggest obstacle this week.
- Since we couldnt implement a proper way with it, we did delete some lines in it to manipulate all pages.


== Week 12 04-25 ==
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

'''Accomplishments''':
- Fixed seed ordering in dropdown menu. (Plant Page)
- Add a line between header and page.
- Add a unique entry to database to make a disabled line in dropdown lists.
- Changed choose color to choose harvesting color
- Added JQuery calendar for date picker in report searching page.
- Aligned checkboxes in treating page.
- Added distinct unit names in unitlevel_table.
- Added admin panel and inside it added 4 different pages. (add-delete seeds/units)
- Added restrictions to adding new units. Now it checks if there are any same named units while adding, this was crucial since delete units deletes all of the same named units.

'''To Do''':
- Fix adding units in admin panel.
- Wait for Jim's response to updates.

'''Obstacles''':
- To check if the user is admin we need to use a if condition inside php and do everything in this condition. Since we cant just open html elements in php, there was lots of different errors to be handled.
- Wordpress sql get_results() function stores an array. however this array was different than normal arrays, learning how to access datas inside was an obstacle.


== Week 13 05-02 ==
'''Attendance''': -

'''Accomplishments''':
- Meeting with Talha and Sarp from team 1 to talk about databases.
- All pages are added from wordpress page templates.
- Changed footer. (Powered by Wordpress -> Powered by BigYieldGrowers)

'''To Do''':
- Wait for Jim's response.

'''Obstacles''':
- Integrating 2 websites together will include changing some of the work process of our website.
- No meeting with Merwyn and Jim this week.

Latest revision as of 16:43, 3 May 2022

Week 1

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Presented the last semester's project.
- Talked about what can we improve and Jim's new tasks for us.

To Do :

- Migrate the PHP project with Wordpress.

Obstacles :

- No obstacles this week.


Week 2

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Started looking into Wordpress page template structure.

To Do:

- Fix migrating issues
- Find out a way to use database of wordpress.

Obstacles:

- Couldn't figure out how to do CRUD operations due to not knowing how to manipulate database of Wordpress for it.


Week 3

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Fixed some logical mistakes in some actions.
- Add humidity and temperature.
- Add date time of the action.

To Do:

- Implement transplant function differently.

Obstacles:

- Logical errors in the source code slowed the development process
- Couldn't fix transplant, but did fix other actions.


Week 4

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Added seed_id_table to the database, which fixes a lot of issues.
- With new table we did add a search function depending on seed id.
- Created 2 php files, one of search other for showing the results in a table.
- Also, showed this in Zoom meeting.

To Do:

- We have been assigned to make research about plugins and analyze whether or not we can develop a WordPress plugin for CRUD operations
- Fix users, now we only push "Temp Name" as the employee name to the database.

Obstacles:

- It was impossible to implement a search function without a different table in database. 
- After figuring out adding a new table, it was still considerably hard to understand what to di in this situation since we didn't had any experience developing search functionalities.

Week 5

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- User database table. Now we can put the employee name to the database.
- Fixed an error in search and show result pages.
- Presented everything.

To Do:

- Update UI.
- Search about plugins development in Wordpress.
- Sprout will be added soon, find out how to implement it too.

Obstacles:

- Search functionality got broken because of some variable names, couldn't figured this out took hours to fix.
- Wordpress stores users in a different table which I couldn't find at first and after finding took a while to figure out,

Week 6

Attendance: Erkut Cetiner

Accomplishments:

- Implemented Sprout process.
- Started working on versioning. Opened up the a Github repository.
- Added CSS and animations to website and presented it to Mr Dutcher as an option for UI.

To Do:

- Add company's logo to home page.
- Add color tag to tables.

Obstacles:

- Sprout process is as big as other process, so it took lots of work to complete.

Week 7

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Presented Sprout process. 
- Home page design improved.
- Company logo is added to home page.
- Added Bootsrap to the site.
- A JavaScript script added to make dropdown lists show the appropriate data when selected.
- Button sizes fixed on home page.

To Do:

- Planning to add automation steps working with other team.
- Add color tags and make text align center.
- Push site to web.


Week 8

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- All the latest implementations pushed to the GitHub
- We added color tags next to color names in tables and dropdown menus.
- Company logo path fixed on CSS file
- Live version of the site pushed to the EC-2  instance

To Do:

- Add a report page to show some data. (Didn't talk about which data to put in tables.) This report has 2 inputs, date and color.

Obstacles:

- Adding the color tag was harder than we thought.
- MySQL database doesn't support that kind of characters, and putting it in html means it isn't responsive.


Week 9

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Added Report page template to our site. Which shows data from given input (date and color).
- Pushed everything to internet and made them compatible with each other.

To Do:

- Integrate 2 websites with the other team.
- Add background image to header side of the page.

Obstacles:

- Getting 2 different data from different tables and putting them together.


Week 10 - 04-11

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Meeting with Talha about team 1's website, how they hold data etc. 
- Presented new updates on the website.
- Talked about where to put company logo and background image in all pages.
- Tests are done in plant and treat actions to make sure they work accordingly.

To Do:

- Wait for other team to develop their site for us to integrate.
- Domain name.
- Fix the security problem.
- Put company logo and background image to all pages.
- Add s/ and h/ to dropdown menus, s for sprout h for normal. Or put a line between sprouts and normal plants.

Obstacles:

- Can only change some part of header part of the page, showed this in meeting to get a feedback.


Week 11 04-18

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- UI upgrades
- Navigation bar fixed on mobile.
- Added transparent logo in every screen.
- Background image is fixed(scroll off).
- Added -h before herbs and -s before sprouts in planting page.
- Auto suggest in input areas are off now.
- Changed header.php so we can implement all of the above.

To Do:

- Add line between logo and actions
- Add a blank entry to database
- Try to implement calendar in report page.
- Change "Choose color" to "Choose harvesting color"
- Tutorial video.

Obstacles:

- Wordpress header was the biggest obstacle this week. 
- Since we couldnt implement a proper way with it, we did delete some lines in it to manipulate all pages.


Week 12 04-25

Attendance: Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner

Accomplishments:

- Fixed seed ordering in dropdown menu. (Plant Page)
- Add a line between header and page.
- Add a unique entry to database to make a disabled line in dropdown lists.
- Changed choose color to choose harvesting color
- Added JQuery calendar for date picker in report searching page.
- Aligned checkboxes in treating page.
- Added distinct unit names in unitlevel_table.
- Added admin panel and inside it added 4 different pages. (add-delete seeds/units)
- Added restrictions to adding new units. Now it checks if there are any same named units while adding, this was crucial since delete units deletes all of the same named units.

To Do:

- Fix adding units in admin panel.
- Wait for Jim's response to updates.

Obstacles:

- To check if the user is admin we need to use a if condition inside php and do everything in this condition. Since we cant just open html elements in php, there was lots of different errors to be handled.
- Wordpress sql get_results() function stores an array. however this array was different than normal arrays, learning how to access datas inside was an obstacle.


Week 13 05-02

Attendance: -

Accomplishments:

- Meeting with Talha and Sarp from team 1 to talk about databases.
- All pages are added from wordpress page templates.
- Changed footer. (Powered by Wordpress -> Powered by BigYieldGrowers)

To Do:

- Wait for Jim's response.

Obstacles:

- Integrating 2 websites together will include changing some of the work process of our website. 
- No meeting with Merwyn and Jim this week.