the project is stand alone web application where we will add potential business parteners, have more columns with their details, some of the columns will have the option to select drop down in the certain cells, and conditional format of lines based on selection in certain cells.
After each communication with business partners we will add a communication summary and it will save with the date, time and name and surename of the slaes rep who had the communication with them. It could save it in certain cell in the line of the business partner like "[url removed, login to view]"+"hh:mm"+sales-rep-name. By clicking a "+" sign on the end of this cell it will open a popup window where teh sales rep can add the message of the communication with the client/business partner. After clicking on any of the saved communication it is opening a popup where is shown the message inserted by the sales rep.
by clicking on button on top of the table "add new busines partner", it will open a popup where we will fill all the parameters of the business partner and after clicking save it save to the table.
each header would have a sort function by clicking on it no matter if it is text or number format.
add a search box on top which will filter lines by matching the typed text
on end of each line add a button edit and delete in order to edit or delete the selected business partner.
We would also need a user management part where we would create a sales rep with their name, surename, mobile number, date of birth.
the admin account would be the one who would asign business partners to different users (by selecting multiple busines partners from the table)
maybe would occur some more functions to be added but mostly were described above.
requiered: Experienced in SQL, angularJS, PHP