BUGS AND ISSUES FIXING: mySQL, PHP and JavaScript

FIXING OF THESE SIMPLE BUGS/ISSUES IN A PHP DEVELOPMENT (NO CMS, NO FRAMEWORKS): This is just a starting point to estabilish a good relationship with skilled developers. We have defined many other issues/bugs to be fixed and development tasks. 37. ISSUE [PRICE UPDATING FORMS] - bad currenc management 1/2 - front end EFFORT: 20 USD URL: [login to view URL] [login to view URL] Description 1. take the currency from the table vendor.default_curr_id NOT from the last price of this vendor offer (query correction, or just one query less) 2. Change the field where there is the currency symbol in a simple not modifiable text, not a drop-down list 3. Take away the previous price from the text field of the form, blank editable field 4. at the UPDATE click control at client side that the edited field is just an integer or float number, no other chars, no NULL value; otherwise, show temporary pop-up writing "Edit just integer or floating figures." 5. for the same updating form of the wizard updating price (URL [login to view URL] ) in case of already updated prices perform the same control for the CORRECT button 6. take away the variable currency (don't know the exact name it has been used the html form) from the updating forms All these corrections in the two price updating forms reported at the beginning. ----------------------------------------- 38. ISSUE [PRICE UPDATING FORMS] - bad currency management 2/2 - back end FFORT: 15 USD URL: [login to view URL] [login to view URL] Description Once fixed the issue 37. there will be no more the currency variable in the WEB form variables. 1. query the vendor table with vendor ID equal to the one of the just received WEB form --> take its default_currency_id 2. use this currency in the new price that is going to be saved in the table 3. keep the existing procedure transferring the previous last price of this offer in the office_price_multi table enduring that in here the currency ID is the one of the previous last price entry and NOT the one read from the vendor table offer_price ---------------------------------- 35. ISSUE [VENDORS OFFER PAGE] - wrong table, vendors list instead vendor offer list EFFORT: 15 USD URL: [login to view URL] Description: This page reports a wrong table. It should be the list of each vendor offer (the products sold by each vendor) instead there is the list of the vendors. The table should have this column 1. Vendor Name (from vendors table) drug name product name format connection size last update date creation date Actions EDIT --> link to page [login to view URL] in editing mode to update this specific offer ERASE --> erase from table (confirmation popup) Filtering by keywords, as in other MNGT table pages (each word shall be present at least in one of the first 3 columns). Correct paging. ------------------------------------------------------ 36. BUG - Passwords and sessions management Effort: 10USD Description: enter to admin panel with an allowed user ID and PW modified the sam admin PW in the mySQL DB the admin can still navigate in the admin panel with the old session just if he log out to log in it is necessary the new PW --> at every new page request or new form submission it MUST be checked if the password is still valid; or if the password has been changed to get the session expiring.