When Click "Platform Promotion" (refer to Merzido admin old version)
must have basic layout with below tabs
Sr.No, PROMOTION ID, PROMOTION NAME, START DATE, END DATE, REGISTRATION END, CREATED TIME, CREATED BY, STATUS, ACTIONS
These tabs are above the SEARCH.......
CREATE, EXPORT, DISABLE, DELETE
When Click "Time Deal / Daily Deal" (refer to Merzido admin & merzido sellerhub old version)
CREATE, VIEW, REJECT
Sr.No, Seller ID | Seller Name | Deal StartDate | Deal EndDate | Display Time | Total Products | Status, Actions
When Click "Merzido Promotion" (refer to Merzido admin old version)
must have basic layout with below tabs
Sr.No, PROMOTION ID, PROMOTION NAME, START DATE, END DATE, PROMO CODE, MIN SPEND, PROMO TYPE, PROMO VALUE, CREATED TIME, CREATED BY, STATUS, ACTIONS
These tabs are above the SEARCH.......
CREATE, EXPORT, DISABLE, DELETE
when clicked on DEAL Management all DEAL should be displayed .
Admin to have preview Button DEAL .Preview should display DEALS same as of User Terminal
Deals Managment to display seller price and new price along with all data from DEAL_MSTR
Admin to be able to edit all the attributes of image except ID .
Admin to have Check Box for Bulk Action on Deals ( Edit , View , Delete)
Admin to have Filter to select active . rejected , pending , deleted deals
Admin to have Export Excel,.
All the deals created by seller would come for admin approval , Admin to accept/Reject .
CREATE TABLE DEAL_MSTR (
DEAL_MSTR_DEAL_ID VARCHAR(20) PRIMARY KEY ,
DEAL_MSTR_DEAL_NAME VARCHAR(200) NOT NULL UNIQUE KEY,
DEAL_MSTR_DEAL_DESC VARCHAR(200),
DEAL_MSTR_STATUS VARCHAR(4) NOT NULL DEFAULT 'LIVE' CHECK ('PNDG' or 'LIVE' or 'REJ' or 'DLTD'),
DEAL_MSTR_START_DATE DATE ,
DEAL_MSTR_END_DATE DATE ,
DEAL_MSTR_START_TIME TIMESTAMP ,
DEAL_MSTR_END_TIME TIMESTAMP ,
DEAL_MSTR_DEAL_TYPE VARCHAR(5) NOT NULL CHECK ('TIME' or 'DAILY' ) ,
DEAL_MSTR_DEAL_DISCOUNT FLOAT NOT NULL ,
DEAL_MSTR_CREATED_BY VARCHAR(20),
DEAL_MSTR_CREATED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
DEAL_MSTR_MODIFIED_BY VARCHAR(20),
DEAL_MSTR_MODIFIED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
DEAL_MSTR_POSITION INT NOT NULL UNIQUE KEY,
);
Create sub tabs as Deal Management, Merzido Promotion,Seller Promotion
Deal Management Contain Time and Daily Deals
Check Flow of Daily and Timely Deal, Check image is displayed on view part or not. and manage it.
Display that deals on seller panel ask this part to mydeen.
Refer merzido old admin for admin part and lazada seller for seller part
When click "Promotion Management":
Have these sub titles:
Seller Promotion
Merzido Promotion
When Click "Platform Promotion" (refer to Merzido admin old version)
These tabs are above the SEARCH....... CREATE, EXPORT, DISABLE, DELETE
When Click "Time Deal / Daily Deal" (refer to Merzido admin & merzido sellerhub old version) CREATE, VIEW, REJECT
Sr.No, Seller ID | Seller Name | Deal StartDate | Deal EndDate | Display Time | Total Products | Status, Actions
When Click "Merzido Promotion" (refer to Merzido admin old version)
These tabs are above the SEARCH....... CREATE, EXPORT, DISABLE, DELETE
CREATE TABLE
DEAL_MSTR
(DEAL_MSTR_DEAL_ID
VARCHAR(20) PRIMARY KEY ,DEAL_MSTR_DEAL_NAME
VARCHAR(200) NOT NULL UNIQUE KEY,DEAL_MSTR_DEAL_DESC
VARCHAR(200),DEAL_MSTR_STATUS
VARCHAR(4) NOT NULL DEFAULT 'LIVE' CHECK ('PNDG' or 'LIVE' or 'REJ' or 'DLTD'),DEAL_MSTR_START_DATE
DATE ,DEAL_MSTR_END_DATE
DATE ,DEAL_MSTR_START_TIME
TIMESTAMP ,DEAL_MSTR_END_TIME
TIMESTAMP ,DEAL_MSTR_DEAL_TYPE
VARCHAR(5) NOT NULL CHECK ('TIME' or 'DAILY' ) ,DEAL_MSTR_DEAL_DISCOUNT
FLOAT NOT NULL ,DEAL_MSTR_CREATED_BY
VARCHAR(20),DEAL_MSTR_CREATED_TIME
TIMESTAMP DEFAULT CURRENT_TIMESTAMP,DEAL_MSTR_MODIFIED_BY
VARCHAR(20),DEAL_MSTR_MODIFIED_TIME
TIMESTAMP DEFAULT CURRENT_TIMESTAMP,DEAL_MSTR_POSITION
INT NOT NULL UNIQUE KEY, );