Wiki » History » Revision 11
Revision 10 (Soh Keong, 11/12/2021 10:26 AM) → Revision 11/28 (Soh Keong, 11/12/2021 12:03 PM)
{{toc}} h1. Specification h1. Chart !FlowChart.jpg! h1. Programming Guide h2. Jar version |_. version |_. Description | | 1.0 | Init | h2. Jar File Download "Jar":/redmine/attachments/download/618/keyword-1.0.jar "Jar":/redmine/attachments/download/601/keyword-1.0.jar "Lib":/redmine/attachments/download/602/lib.rar h3. Test Link https://202.129.164.38:9093/TestPage/page/keyword/addKeyword h2. Database Table <pre> CREATE TABLE KEYWORD_PRODUCT ( KEYWORD_REF_NO INTEGER NOT NULL, KEYWORD VARCHAR(50) NOT NULL, STATUS VARCHAR(2) DEFAULT 'A', CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, MODIFY_DATETIME TIMESTAMP, PRIMARY KEY (KEYWORD_REF_NO)) CREATE UNIQUE INDEX UI_PROD_KEYWORD ON KEYWORD_PRODUCT(KEYWORD) </pre> <pre> CREATE TABLE KEYWORD_PRODUCT_PATTERN ( PRODUCT_REF_NO INTEGER NOT NULL, KEYWORD_REF_NO INTEGER NOT NULL, PRIORITY INTEGER, STATUS VARCHAR(2) DEFAULT 'A', CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, MODIFY_DATETIME TIMESTAMP, PRIMARY KEY (PRODUCT_REF_NO,KEYWORD_REF_NO)) CREATE INDEX IX_KEYWORD_PRODUCT_PATTERN_PRIO ON KEYWORD_PRODUCT_PATTERN(PRIORITY) CREATE INDEX IX_KEYWORD_PRODUCT_PATTERN_STATUS ON KEYWORD_PRODUCT_PATTERN(STATUS) CREATE INDEX IX_KEYWORD_PRODUCT_PATTERN_DATE ON KEYWORD_PRODUCT_PATTERN(MODIFY_DATETIME) </pre> <pre> CREATE TABLE KEYWORD_SEARCH_PRODUCT ( PRODUCT_REF_NO INTEGER NOT NULL, SHOPPER_REF_NO INTEGER NOT NULL, SEARCH_TYPE VARCHAR(5) NOT NULL, CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, MODIFY_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (PRODUCT_REF_NO,SHOPPER_REF_NO,SEARCH_TYPE)) CREATE INDEX IX_KEYWORD_SEARCH_PRODUCT_MODI ON KEYWORD_SEARCH_PRODUCT(MODIFY_DATETIME) </pre> <pre> CREATE TABLE KEYWORD_SEARCH_PATTERN ( SHOPPER_REF_NO INTEGER NOT NULL, KEYWORD_REF_NO INTEGER NOT NULL, PRIORITY INTEGER NOT NULL, CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, MODIFY_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (SHOPPER_REF_NO, KEYWORD_REF_NO, PRIORITY)) CREATE INDEX IX_KEYWORD_SEARCH_PATTERN_MODIFY ON KEYWORD_SEARCH_PATTERN(MODIFY_DATETIME) </pre> h2. Methods h3. Keyword <pre> com.cosway.keyword.service.KeywordService service = new com.cosway.keyword.service.KeywordService(); </pre> <pre> boolean added = service.addKeyword(Connection conn, String keyword) boolean updated = service.updateKeywordStatus(Connection conn, int keywordRefNo, String status) Map<Integer, String> KeywordMap = service.getKeywordAInActiveMap(Connection conn) Map<Integer, String> KeywordMap = service.getKeywordAllMap(Connection conn) Map<Integer, String> KeywordMap = service.getKeywordPrefixMap(Connection conn, String search) Map<Integer, String> KeywordMap = service.getKeywordwildcardMap(Connection conn, String search) </pre> h3. Product <pre> com.cosway.keyword.service.ProductService service = new com.cosway.keyword.service.ProductService(); </pre> <pre> boolean added = service.addProductKeyword(Connection conn, KeywordBean keyword) boolean updated = service.updateProductStatus(Connection conn, int productRefNo, String status) Map<Integer, Set<KeywordBean>> productMap = service.getProductKeywordMap(Connection conn) Set<KeywordBean> productSet = service.getProductKeywordSetByProductRefNo(Connection conn, int productRefNo) Set<Integer> productSet = service.getProductSetByStatus(Connection conn, String status) </pre> > * *productRefNo* - > * *keywordRefNo* - > * *priority* - h3. Add product Keyword <pre> com.cosway.keyword.service.PurchaseService service = new com.cosway.keyword.service.PurchaseService(); </pre> <pre> boolean added = service.addProductPattern(Connection conn, PurchaseBean bean) </pre> > * *productRefNo* - > * *searchType* - com.cosway.keyword.constant.SearchType > * *shopperRefNo* - h3. Search <pre> com.cosway.keyword.service.SearchService service = new com.cosway.keyword.service.SearchService(); </pre> <pre> Set<Integer> productSet = service.getProductListByType(Connection conn, SearchBean searchBean) Map<Integer, Integer> productMap = service.getProductRefNoByLevel(Connection conn, SearchBean searchBean) Set<Integer> productSet = service.getProductListByProduct(Connection conn, SearchBean searchBean) </pre> > By Type > * *shopperRefNo* *productRefNo* - > * *noOfRecords* - > * *searchType* - com.cosway.keyword.constant.SearchType > By Level > * *shopperRefNo* - > * *noOfRecords* - > * *level* - > By Product (By Type) > * *productRefNo* - > * *noOfRecords* - > * *level* - (By Level & Product only) Level)