GiftCards Generator & Manager with PrestaShop integration

GiftCards Generator & Manager with PrestaShop integration and simple database for storage of giftcards and admins/users. 1. Login with password page Database: - login - password - shop_code 2. Show list of all giftcards - Generate new giftcards button - Edit codes parameters - Select codes for export to xls + Export button 3. Generate new giftcard(s) - Giftcard numbers can't duplicate and have to be unique - Select date from and date to, default from today and to 3 years - Select Partial use - yes/no, default: yes - Select number of cards to genarate (1 to 25) - Select giftcard amount (25, 50 and 100 USD by default, custom amount if needed) - Select shop where giftcard is generated (disabled input, show shop basing on account) - Generation scheme: ZZZDDYYMMSCXX ZZZ - amount from 001 to 999 (1 to 999 USD) DD - day of card generation YY - year of card generation MM - month of card generation SC - shop code 01 to 99 XX - card number 01 to 25 - Create additional code for PrestaShop (ps_cart_rule > code column) - this code can be used in PrestaShop cart, 8 characters, alphanum only capital letters eg. H518VI7A - Sync with PrestaShop (5) - Export generated codes to xls (Excel file), codes range in filename 4. Activate/Deactivate giftcard (separate page) - Show inputbox where you can scan, enter or paste giftcard number - Show confirmation of gift card amount - Show confirmation of gift card vaild to date - Show submit button "Activate/Deactivate the card" 5. Sync with PrestaShop database - Sync with ps_cart_rule table in PrestaShop database - Columns id_cart_rule - automatic id_lang - always 1 name - ZZZ USD Voucher id_customer - always 0 date_from - depending on generator date_to - depending on generator description - always empty quantity - always 1 quantity_per_user - always 1 priority - always 1 partial_use - depending on selection code - 8 characters, alphanum only capital letters eg. H518VI7A minimum_amount - always 0.00 minimum_amount_tax - always 0 minimum_amount_currency - always 0 minimum_amount_shipping - always 0 country_restriction - 0 carrier_restriction - 0 group_restriction - 0 cart_rule_restriction - 0 product_restriction - 0 shop_restriction - 0 free_shipping - 0 reduction_percent - 0.00 reduction_amount - ZZZ.00 depending on selection reduction_tax - 0 reduction_currency - 0 reduction_product - 0 gift_product - 0 gift_product_attribute - 0 highlight - 0 active - default 0, change according to activation/deactivation date_add - sync date date_upd - sync date - Change active column in ps_cart_rule table