ValuAg Team 2: Difference between revisions
Created page with "'''Date''': 2/6/2022 == Week 1 (Spring) == '''To Do''' : - Find ideas to reach the database of WordPress to do backend operations. - Or create a private database and install..." (change visibility) |
|||
| (43 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 |
|||
'''To Do''' : |
|||
- Find ideas to reach the database of WordPress to do backend operations. |
|||
- Or create a private database and install to another AWS EC-2 instance, then connect two different instances with each other. |
|||
'''Accomplishments''': |
'''Accomplishments''': |
||
- Presented the last semester's project. |
|||
- We have created a database to use on WordPress. |
|||
- Talked about what can we improve and Jim's new tasks for us. |
|||
- That database is merged with the WordPress site to handle data operations. |
|||
- Still need to work on for other pages such as Treat. |
|||
'''To Do''' : |
|||
- Migrate the PHP project with Wordpress. |
|||
'''Obstacles''' : |
'''Obstacles''' : |
||
- No obstacles this week. |
|||
- Design on WordPress is little bit complicated, however, we are going to handle it. |
|||
== Week 2 == |
|||
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner |
|||
'''Accomplishments''': |
|||
- Started looking into Wordpress page template structure. |
|||
'''Date''': 2/13/2022 |
|||
== Week 2 (Spring) == |
|||
'''To Do''': |
'''To Do''': |
||
- Fix migrating issues |
|||
- Start to merge PHP and WordPress files and migrate to AWS. |
|||
- Find out a way to use database of wordpress. |
|||
- Handle the database operations for each action page. |
|||
'''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''': |
'''Accomplishments''': |
||
- Fixed some logical mistakes in some actions. |
|||
- Merged WordPress and PHP files and uploaded to AWS. |
|||
- Add humidity and temperature. |
|||
- Database operations are designed and implemented for each different action such as "Plant", "Harvest" etc. |
|||
- Add date time of the action. |
|||
- Search function is added to web application. |
|||
- Seed id table is added to database. |
|||
- Have been tried to learn more about WordPress design. |
|||
'''Date''': 2/20/2022 |
|||
== Week 3 (Spring) == |
|||
'''To Do''': |
'''To Do''': |
||
- Implement transplant function differently. |
|||
- Updating the UI and add sprout to the database |
|||
- Adding temperature and humidity to the tables |
|||
'''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''': |
'''Accomplishments''': |
||
- Added seed_id_table to the database, which fixes a lot of issues. |
|||
- we updated our tables as requested(humidity and temperature added) |
|||
- With new table we did add a search function depending on seed id. |
|||
- CSS layout minor changes(WordPress's theme restrains us to manipulate the user interface) added to the site. |
|||
- Created 2 php files, one of search other for showing the results in a table. |
|||
- Also, showed this in Zoom meeting. |
|||
'''Date''': 2/27/2022 |
|||
== Week 4 (Spring) == |
|||
'''To Do''': |
'''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 |
- 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''': |
'''Accomplishments''': |
||
- User database table. Now we can put the employee name to the database. |
|||
-We have met with ValuAG team1 and talked about what can be done about developing plugin. |
|||
- Fixed an error in search and show result pages. |
|||
-Started to develop for us to be able to add sprouts to our tables. |
|||
- 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. |
|||
'''Date''': 3/6/2022 |
|||
== Week 5 (Spring) == |
|||
'''To Do''': |
'''To Do''': |
||
- Add company's logo to home page. |
|||
- Updating the UI |
|||
- Add color tag to tables. |
|||
- Plugin research |
|||
'''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''': |
'''Accomplishments''': |
||
- Presented Sprout process. |
|||
- added some JS code to the dropdown menu's functionality for input attribute by means of changing its placeholder. |
|||
- Home page design improved. |
|||
- class tables get updated for sprout. |
|||
- |
- Company logo is added to home page. |
||
- Added Bootsrap to the site. |
|||
- meeting with team1. |
|||
- 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 == |
|||
'''Date''': 3/13/2022 |
|||
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner |
|||
== Week 6(Spring) == |
|||
'''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''': |
'''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''': |
'''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 == |
|||
'''Date''': 3/20/2022 |
|||
'''Attendance''': Mahmut Cuneyt Unsal, Emre Serdar, Erkut Cetiner |
|||
== Week 7 (Spring) == |
|||
'''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''': |
'''To Do''': |
||
- Wait for other team to develop their site for us to integrate. |
|||
- Will work on versioning. Planning to add automation steps. |
|||
- 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''': |
'''Accomplishments''': |
||
- UI upgrades |
|||
- Started working on versioning. Opened up the github repository. |
|||
- Navigation bar fixed on mobile. |
|||
- Added CSS and animations to website and presented it to Mr Dutcher |
|||
- 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.