Django or Vue developer needed to create 2 pages
Budget
160$
per month
Posted: 5 years ago
Opened
- Description
- Hi,
I need a developer to create the below 2 pages using Django or Vue. All code must be handed over upon completion with deployment instructions!! This is not a very complicated project so wouldn't expect it to take too long to complete. Please don't submit quotes over the budget as these will immediately be rejected. This is a simple request and ane developer with experience in this field will be able to pull this together in no time.
https://xd.adobe.com/view/373ed7f0-cdc4-42e6-4172-9156d2de67b6-410f/
The underlying MySQL DB tables are already created and I can share the DB DDL for the 3 tables used.
generic_product_data - Is the key table which holds most data regarding products
generic_image_data - holds all images and order of images
category_lookup - used for category dropdown lists
----- Login Screen-----
There needs to be a login page, I'm happy with built-in security, using Linux users or a custom MySQL table for authentication.
-----End of Login Screen-----
----- Screen 1: -----
This screen is a list of all products from the generic_product_listings table.
There are 2 search fields at the top to filter data using SQL like functionality.
Search Field
If you type in 'Prod' in the search field, the table will be populated with all products that have either generic_product_data.site_sku or generic_product_data.site_product_name like '%Prod%'. The search is not case sensitive.
Supplier Code
Same search functionality but against supplier_sku
Table:
List of all products that match the search criteria. Columns are from an outer join between the 2 tables to capture the images but should only include the image with image_order=1 (so the first image), more info can be found on page 2
1. image.full_path (this will be a locally downloaded file
2. generic_product_data.site_product_name (could be null)
3. generic_product_data.site_sku (this could be null if not configured yet)
4. generic_product_data.supplier_product_name
5. PK - generic_product_data.supplier_sku
6. generic_product_data.list_on_site (should be a checkbox. Once clicked the values should be updated in the table)
7. PK - generic_product_data.supplier_code (a 3 letter code identifying supplier)
----- End of Screen 1: -----
----- Screen 2 -----
There are 3 sections, the data for the top 2 sections are from generic_product_data table. Of the 2 sections, only the one on the right should be enabled for edit, the left section is read-only.
Section 1 - Supplier Product Information
Most of the columns are self-explanatory and links to the table by similarly named columns.
For clarity, RRP excl VAT in this table links to supplied_rrp_excl_vat
Section 2 - Site Product Information
generic_product_data.site_product_type - should have 2 options (simple,variable).
If variable is selected, the following fields should be enabled -
Parent SKU, Colour Option, Size Option
If simple is selected, the above fields should be disabled
Category 1,2 and 3 are predefined lists of categories which can be read from a table called category_lookup and column category_key.
Buttons:
Copy >> When this button is selected, it should copy over the following fields from the left section to the right section:
Supplier Product Name > Site Product Name
Short Description > Short Description
Full Description > Full Description
40%, 70%, cust - These buttons should take the trade_price_excl_vat and add 40%, 70% or a custom % and place it in site_rrp_excl_vat
Section 3 - Image information:
This data is pulled from the generic_image_data table and shows the following columns:
1. supplier_image (this is a locally hosted file)
2. supplier_file_path (where the file is stored locally)
3. site_file_name (a customer name for file). This is an editable field
4. site_image_description
5. seo_meta_description
The icons on the left is to change the order of the images. The order is controlled by a column called image_order and should be updated as images are moved up and down
----- End of Screen 2 -----
I look forward to your response and proposal.
Thanks,
Skills:
structured query language (sql),linux,mysql,authentication,customization,database,Django-cms,software development,user interface (UI)
- Category
Source: peopleperhour.com
Drag