This commit refactors the code in the ShopProduct class to improve the process of deleting a product and updating the SEO links. It adds new database queries to delete entries from the pp_routes and pp_redirects tables when a product is deleted. It also updates the SEO links for translated product names, ensuring that the new SEO link is generated correctly and checking for any existing redirects before adding a new one. Additionally, the commit adds a new function, canAddRedirect, to check for cycles in the redirect map before adding a new redirect.
Refactor deleting product and updating SEO links in class.S
This commit refactors the clear_redis_cache function in the S class to improve the process of updating the routes and redirects in the .htaccess file. It adds new database queries to delete entries from the pp_routes table and updates the code to generate the RewriteRule directives for the routes. It also adds a new condition to the .htaccess file to skip rewriting requests for existing files and directories.
Refactor retrieving subcategories in class.Category
This commit refactors the getCategoryData function in the Category class to improve the process of retrieving subcategories. It removes the ORDER clause from the database query to retrieve subcategories, allowing the categories to be returned in their natural order. This change ensures that the subcategories are displayed correctly in the category navigation.
Check redirects and routes in index.php
This commit adds new code to the index.php file to check for redirects and routes before processing the request. It checks if the requested URL matches any entries in the pp_redirects table and redirects the user to the new URL if a match is found. It also checks if the requested URL matches any entries in the pp_routes table and parses the destination to extract GET parameters if a match is found. This change improves the handling of redirects and routes in the application.
