OSCommerce Product Manager for Windows
FS#168 - Move all SQL code to server-side.
Attached to Project:
OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 13 February 2005, 19:11 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 08:33 GMT
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 13 February 2005, 19:11 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 08:33 GMT
|
DetailsWe should redesign the application so all SQL queries are build server-side.
So, the application would only send request with the form: MOVE ID=243 TO CAT=23 Or something like that. We then would forget about supporting other OSCommerce variants in the Delphi code, because most database/tables/fields issues would be moved to the PHP realm. Also, it's a lot easier to find a PHP programmer than a Delphi programmer. It would make the OSCPMWin application more lightweight, faster, simpler and less prone to failure. Of course this would require a full HTTP interface. This is related to Bug #66. Actually, it is too related it should be fixed concurrently. |
This task depends upon
The Bug #66 has been implemented.
We can start planning how to implement this one.
GET CATEGORY (all or by ID)
GET MANUFACTURER (all or by ID)
GET TAX (all or by ID)
GET CURRENCY (all or by ID)
GET LANGUAGE (all or by ID)
GET PRODUCT (all or by ID)
GET OPTION (all)
SEARCH PRODUCT (by multiple criteria)
UPDATE CATEGORY
UPDATE MANUFACTURER
UPDATE CURRENCY
UPDATE PRODUCT
DELETE CATEGORY
DELETE MANUFACTURER
DELETE CURRENCY
DELETE PRODUCT
ADD CATEGORY
ADD MANUFACTURER
ADD CURRENCY
ADD PRODUCT