鍓嶈█涓婁竴绡囥€婇€氱敤鎶藉宸ュ叿涔嬮渶姹傚垎鏋愩€嬫垜浠€氳繃涓€浜涘父瑙佺殑鎶藉鍦烘櫙寰楀埌浜嗘弧瓒宠繖浜涙娊濂栧満鏅殑鎶藉宸ュ叿鐨勪簲瑕佺礌锛氭娊濂栦簲瑕佺礌瑕佺礌鍚嶇О绗竴瑕佺礌娲诲姩绗簩瑕佺礌瀛楁绗笁瑕佺礌鏄鍝侊紝绗洓涓厓绱犳槸涓姒傜巼锛岀浜斾釜鍏冪礌鏄钩鍧囨姇绁ㄥ拰鍒涘缓鎶藉浜嬩欢鐨?涓熀鏈楠わ紝濡備笅锛氫簨浠堕厤缃簨浠堕厤缃鍝侀厤缃鍝佷腑濂栨鐜囬厤缃鍝佸鍝侀厤缃笂涓€绡囪瘎璁恒€婇€氱敤鎶藉宸ュ叿涔嬮渶姹傚垎鏋愩€嬮渶姹傚垎鏋愬畬浜嗭紝浠婂ぉ鎴戜滑灏辨潵鐪嬬湅杩欎釜閫氱敤鎶藉宸ュ叿鐨勫叿浣撹璁★紝鍒嗕负浠ヤ笅涓変釜閮ㄥ垎锛欴B璁捐閰嶇疆鍚庡彴璁捐鐣岄潰璁捐DB璁捐绗竴瑕佺礌娲诲姩閰嶇疆鎶藉娲诲姩琛細--閫氱敤鎶藉宸ュ叿(Glue)glue_activity鎶藉娲诲姩琛–REATETABLE`glue_activity`(`id`int(11)unsignedNOTNULLAUTO_INCREMENTCOMMENT'娲诲姩ID',`serial_no`char(16)unsignedNOTNULLDEFAULT''COMMENT'娲诲姩number(md5鍊间腑闂?6浣?',`name`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'娲诲姩鍚嶇О',`description`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'娲诲姩鎻忚堪',`activity_type`tinyint(1)unsignedNOTNULLDEFAULT'1'COMMENT'娲诲姩鎶藉绫诲瀷1锛氭寜鏃堕棿鎶藉2锛氭寜鎶藉娆℃暟鎶藉3锛氭寜閲戦鑼冨洿鎶藉',`probability_type`tinyint(1)unsignedNOTNULLDEFAULT'1'COMMENT'鑾疯儨姒傜巼绫诲瀷1锛歴tatic2:dynamic',`times_limit`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'闄愬埗鎶藉娆℃暟锛?榛樿涓嶉檺鍒?,`start_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'娲诲姩寮€濮嬫椂闂?,`end_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'娲诲姩缁撴潫鏃堕棿',`create_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鍒涘缓鏃堕棿',`create_by`int(11)鏃犵鍙種OTNULLDEFAULT'0'COMMENT'creatorstaff_id',`update_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鏇存柊鏃堕棿',`update_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'淇敼浜虹墿staff_id',`status`tinyint(1)NOTNULLDEFAULT'0'COMMENT'status-1:deleted,0:disable,1:enable',PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='鎶藉娲诲姩琛?;鎶藉浼氳瘽閰嶇疆琛ㄧ浜屼釜鍏冪礌锛?-閫氱敤鎶藉宸ュ叿锛坓lue锛塯lue_session鎶藉浼氳瘽琛–REATETABLE`glue_session`(`id`int(11)unsignedNOTNULLAUTO_INCREMENTCOMMENT'EventID',`activity_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'娲诲姩ID',`times_limit`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'闄愬埗寮€濂栨鏁帮紝0榛樿涓轰笉闄愬埗',`start_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Sessionstarttime',`end_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Sessionendtime',`create_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鍒涘缓鏃堕棿',`create_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Creatorstaff_id',`update_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'updatetime',`update_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'modifiedbystaff_id',`status`tinyint(1)NOTNULLDEFAULT'0'COMMENT'status-1:deleted,0:disable,1:enable',PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='tableoflotterysessions';涓夊洓鍏冨鍝侀厤缃鍝佽〃锛?-閫氱敤鎶藉宸ュ叿(Glue)glue_session_prizes濂栧搧濂栧搧琛–REATETABLE`glue_session_prizes`(`id`int(11)unsignedNOTNULLAUTO_INCREMENTCOMMENT'鑷ID',`session_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'SessionID',`node`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'鑺傜偣ID鎸夋椂闂村紑濂栵細绌哄€硷紝鎸夋鏁發otterydraws:鍙備笌鍊肩殑鏁伴噺锛屾寜閲戦鑼冨洿Intervallottery:閲戦涓婇檺interval',`prize_type`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Prizetype1:Coupon,2:Points,3:Realobjects,4:Emptyprize...',`name`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'濂栧搧鍚嶇О',`pic_url`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'濂栧搧鍥剧墖',`value`varchar(255)unsignedNOTNULLDEFAULT''COMMENT'PrizeAbstractValueCoupon:CouponID銆丳oints锛氱偣鍊硷紝鐪熷疄瀵硅薄锛歴kuID',`probability`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'涓姒傜巼1~100',`create_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鍒涘缓鏃堕棿',`create_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Creatorstaff_id',`update_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鏇存柊鏃堕棿',`update_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Modifierstaff_id',`status`tinyint(1)NOTNULLDEFAULT'0'COMMENT'status-1:deleted,0:disable,1:enable',PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='骞歌繍鎶藉濂栧搧琛?;绗簲涓厓绱犳槸鐢ㄤ簬骞冲潎鍒嗛厤濂栧搧鐨勫父瑙勫僵绁ㄥ鍝佸垎閰嶅櫒琛細--閫氱敤褰╃エ宸ュ叿锛圙lue锛塯lue_session_prizes_timer鎶藉鏃堕棿濂栧搧瀹氭椂鍒嗛厤鍣ㄨ〃CREATETABLE`glue_session_prizes_timer`(`id`int(11)unsignedNOTNULLAUTO_INCREMENTCOMMENT'auto-incrementID',`session_prizes_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鎶藉ID',`delivery_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'閫佸鏃堕棿',`prize_quantity`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'濂栧搧鏁伴噺',`create_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鍒涘缓鏃堕棿',`create_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'creatorstaff_id',`update_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'updatetime',`update_by`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'modifiedbystaff_id',`status`tinyint(1)NOTNULLDEFAULT'0'COMMENT'Status-1:deleted,0:wait,1:success',PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='鎶藉瀹氭椂鍒嗛厤琛?;OthersTable,寮€濂栬褰?濂栧搧鍒嗛厤璁板綍琛?--閫氱敤寮€濂栧伐鍏?Glue)glue_user_draw_record鐢ㄦ埛寮€濂栬褰曡〃CREATETABLE`glue_user_draw_record`(`id`int(11)unsignedNOTNULLAUTO_INCREMENTCOMMENT'auto-incrementID',`activity_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'activityID',`session_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'sessionID',`prize_type_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'PrizeTypeID',`user_id`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'Creatoruser_id',`create_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鍒涘缓鏃堕棿',`update_at`int(11)unsignedNOTNULLDEFAULT'0'COMMENT'鏇存柊鏃堕棿',`status`tinyint(1)NOTNULLDEFAULT'0'COMMENT'Status-1:鏈腑濂?1:涓,2:澶辫触,3:鑾峰',`log`textCOMMENT'鎿嶄綔淇℃伅绛夎褰?,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='鐢ㄦ埛鎶藉璁板綍琛?;閰嶇疆鍚庡彴璁捐锛屽垱寤烘椿鍔紝鍒涘缓娲诲姩浼氳瘽鈥斺€旀寜閲戦鑼冨洿range寮€濂栨椿鍔ㄥ垪琛ㄧ晫闈㈣璁?.鑾峰彇娲诲姩淇℃伅GET{version}/glue/activity璇锋眰鍙傛暟锛歠ield鏄惁蹇呴』浼犵被鍨嬭鏄巗erial_nostringY娲诲姩缂栧彿鍝嶅簲鍐呭锛歿"code":"200","msg":"OK","result":{"serial_no":"string,娲诲姩缂栧彿","type":"缂栧彿,娲诲姩鎶藉绫诲瀷1:鎸夋椂闂存娊濂?锛氭寜鎶藉娆℃暟鎶藉3锛氭寜閲戦鑼冨洿鎶藉鈥?"name":"string,浜嬩欢鍚嶇О","description":"string,浜嬩欢鎻忚堪","start_time":"number,浜嬩欢寮€濮嬫椂闂?,"end_time":"浜烘暟,娲诲姩寮€濮嬫椂闂?,"remaining_times":"浜烘暟,娲诲姩鎶藉娆℃暟闄愬埗,0涓嶉檺","sessions_list":[{"start_time":"浜烘暟,娲诲姩寮€濮嬫椂闂?,"end_time":"number,浼氳瘽寮€濮嬫椂闂?,"remaining_times":"numberr,鎶藉娆℃暟鏈夐檺,0涓嶉檺","prizes_list":[{"name":"string,濂栧搧鍚嶇О","pic_url":"string,濂栧搧鍥剧墖"}]}]}}2銆佸僵绁≒OST{version}/glue/activity/draw璇锋眰鍙傛暟锛氬瓧娈电被鍨嬫槸鍚﹀繀濉弿杩皊erial_nostringY娲诲姩鍙穟idnumberY鐢ㄦ埛ID鍝嶅簲鍐呭锛?/winning{"code":"200","msg":"OK","result":{"serial_no":"string,spuid","act_remaining_times":"number,鏈娲诲姩鍓╀綑鎶藉娆℃暟锛?涓嶉檺","session_remaining_times":"number,鏈娲诲姩鎶藉鍓╀綑娆℃暟,0涓嶉檺","prizes_info":{"name":"string,濂栧搧鍚嶇О","pic_url":"string,濂栧搧鍥剧墖"}}}//娌′腑濂杮"code":"401","msg":"","result":{}}缁撯€嬧€嬭娲诲姩钀ラ攢绯荤粺绗竴涓瘝鏄郴缁熼€氱敤鐨勬娊濂栧伐鍏凤紝甯屾湜瀹冧細瀵瑰ぇ瀹舵湁涓€瀹氱殑甯姪鎴栬€呭惎鍙戙€俫鐨勪唬鐮佽璁￠€氱敤鐨勫僵绁ㄧ粯鍥惧伐鍏风壒鍒€傜敤浜庤璁℃ā寮忎腑鐨勬ā鏉挎ā寮忋€傚悇浣嶅ぇ澶т滑浣犱滑鎬庝箞鐪嬸煒傪煒傪煒傘€傞偅涔堬紝鏂扮殑涓€骞达紝鎴戜細涓嶄細鍐嶅啓涓€绡囨枃绔犮€奫Skr-Shop]閫氱敤鎶藉宸ュ叿涔嬩唬鐮佽璁°€嬶紵锛圤_O锛夛紵2020骞寸粨鏉熷悗锛岀澶у2020鏂板勾蹇箰~銆怱krShop銆戦」鐩湴鍧€闀挎寜杩涘叆锛歨ttps://github.com/skr-shop/m...鏇村SkrShop绯诲垪鏂囩珷:SkrShop閫氱敤褰╃エ宸ュ叿绯荤粺璁捐SkrShop钀ラ攢绯荤粺寮€閫歋krShop璐墿杞﹁璁′綔涓洪渶姹傚垎鏋恈oder锛屼綘鑳借璁′竴涓氦鏄撶郴缁熷悧锛堝疄鎴樼瘒锛夛紵Coder锛屼綘鑳借璁′竴涓氦鏄撶郴缁燂紙姒傚康锛夊悧锛熺涓夋柟鏀粯娴佺▼鍒嗘瀽鎬荤粨鐢靛瓙鍟嗗姟璁捐鎵嬪唽鍟嗗搧鍩烘湰淇℃伅鐢靛瓙鍟嗗姟璁捐鎵嬪唽鐢ㄦ埛绯荤粺
