涓轰粈涔堣鍙戝睍绉垎鍟嗗煄锛熷洜涓烘垜浠箣鍓嶇敤杩囧厬鍚х殑鏈嶅姟锛岃繕涓嶉敊锛屼絾鏄簡瑙ｅ埌鍏嶈垂鐗堟湇鍔′細鍦ㄤ粖骞翠笅鍗婂勾锛?018骞达級鍏抽棴锛岄渶瑕佷粯璐硅喘涔颁笓涓氱増鎴栬€呯粓鏋佺増鐗堟湰鏉ヤ娇鐢ㄥ畠銆傚綋鐒讹紝鍏戝惂鐨勫伐浣滀汉鍛樹篃鑱旂郴杩囨垜浠紝鍙互缁欎紭鎯犱环锛屽晢瀹跺惞鐗涗竴瀹氳璇粹€滃ソ鐨勶紝鎴戜滑鍐嶅晢閲忚€冭檻鈥濓紝濡傛灉鎴戜滑鐢ㄤ氦鏄撴墍锛岄偅浣犲氨鐪嬩笉鍒拌繖绡囨枃绔犱簡銆?3333鎴戝紑濮嬫暣浣撴祻瑙堜粬浠殑浜у搧绠＄悊锛屽噺鍘讳竴浜涘拰鎴戜滑涓氬姟鏃犲叧鐨勫姛鑳姐€備富瑕佸姛鑳芥槸浜ゆ崲鏂规硶銆備粬浠噰鐢ㄧ函绉垎銆佺Н鍒?浜烘皯甯佺殑绛栫暐銆傝繕鍔犱簡浜烘皯甯佹敮浠樻柟寮忥紙涓嶉夯鐑︼級锛屽寘閭拰鍖呴偖鐨勫姛鑳介兘鍑忓皯浜嗐€傚幓鍚э紙鍥犱负鎴戜滑鍖呴偖锛夐渶瑕佸紑鍙戠殑涓昏鍔熻兘椤规槸鍝佺被绠＄悊銆佸晢鍝佺鐞嗐€佹敮浠樸€傚浜庤繖閲岀殑鏀粯锛岀浉淇″ぇ瀹跺簲璇ョ爺绌朵竴涓嬫敮浠樺疂鍜屽井淇＄殑鏂囨。锛屽簲璇ヤ笉浼氶檶鐢熴€傚湪璁捐涔嬪垵锛屾垜浠殑琛ㄧ粨鏋勮璁″簲璇ユ槸鏈€绠€鍗曠殑銆傚ぇ浣撶粨鏋勬槸鑷id銆乶ame銆乸icture锛堝甫鍥剧墖鐨勭被鍒級銆佹樉绀洪『搴忋€佺姸鎬佺瓑銆傝琛ㄥ簲璇ョ湅璧锋潵鍍忚繖鏍峰垱寤鸿〃濡傛灉涓嶅瓨鍦╜score_shop_classify`(`id`int(11)unsignedAUTO_INCREMENT,`name`varchar(191)notnullDEFAULT''comment'menuname',`img`textcomment'Menupicture',`show_order`int(11)notnullDEFAULT0comment'Displayorder0maximum',PRIMARYKEY(`id`))engine=InnoDBDEFAULTCHARSET=utf8mb4;鐒跺悗鏄晢鍝佽〃锛屽垎鏋愭搷浣滅晫闈㈡樉绀轰俊鎭紝鍙互澶ц嚧浜嗚В鍟嗗搧鍚嶇О銆佷环鍊笺€佹弿杩颁俊鎭€佸浘鐗囥€佸簱瀛樻暟閲忋€佹崲璐ф鏁般€傚垎鏋愮殑琛ㄧ粨鏋勬槸杩欐牱鐨刢reatetableifnotexists`score_shop_goods`(`id`int(11)unsignedAUTO_INCREMENT,`menuid`int(11)notnullDEFAULT0comment'category',`good_type`varchar(32)notnullDEFAULT'object'comment'鍖哄垎瀹炰綋鍟嗗搧鍜岃櫄鎷熷晢鍝乷bject瀹炰綋鍟嗗搧铏氭嫙铏氭嫙鍟嗗搧浼樻儬鍒?,`good_name`varchar(100)notnullDEFAULT''comment'鍟嗗搧鍚嶇О',`good_icon`textnotnullcomment'鍟嗗搧icon',`good_pic`textnotnullcomment'productpicture',`good_desc`textcomment'productdescription',`good_stock`int(11)notnullDEFAULT0comment'goodsstock',`exchange_type`tinyint(4)notnullDEFAULT0comment'鍟嗗搧绫诲埆0绉垎1鍏?绉垎+RMB',`exchange_info`textnotnullcomment'鍟嗗搧浠锋牸淇℃伅',`exchange_num`int(11)unsignednotnullDEFAULT1comment'鐢ㄦ埛鏈€澶у厬鎹㈡鏁?鏃犻檺榛樿1娆?,`created_time`int(11)unsignednotnullDEFAULT0comment'Creationtime',`updated_time`int(11)unsignednotnullDEFAULT0comment'Updatetime',PRIMARYKEY(`id`))engine=InnoDBDEFAULTCHARSET=utf8mb4;杩欏绉垎鍟嗗煄缁撴瀯搴旇闇€瑕佸崟鐙殑鏀粯琛?涓庝箣鍓嶅瓨鍦ㄧ殑鏀粯琛ㄤ笉鍐茬獊锛屼絾闇€瑕佹湁涓€涓繛鎺ョ偣銆傝繖浠呬緵鍙傝€冦€傚鏋滀笉瀛樺湪鍒欏垱寤鸿〃`score_shop_pay_record`(`id`int(11)unsignedAUTO_INCREMENT,`user_id`int(11)unsignednotnullDEFAULT0comment'UserID',`pay_id`int(11)unsignednotnullDEFAULT0comment'璐拱鍟嗗搧ID',`oid`varchar(50)notnullDEFAULT0comment'璁㈠崟ID',`pay_type`tinyint(4)notnullDEFAULT0comment'鏀粯鏂瑰紡锛?寰俊鏀粯2鏀粯瀹濇敮浠?,`money`int(11)unsignednotnullDEFAULT0comment'paymentamount,unitpoints',`score`int(11)unsignednotnullDEFAULT0comment'Paypoints',`log`varchar(255)notnullDEFAULT''comment'Remarks',`pay_time`int(10)unsignednotnullDEFAULT0comment'Paymenttime',`created_time`int(10)unsignednotnullDEFAULT0comment'ordercreationtime',`updated_time`int(10)unsignednotnullDEFAULT0comment'orderupdatetime',`status`tinyint(4)notnullDEFAULT0comment'paymentstatus,0鍏呭€煎け璐?鍏呭€兼垚鍔熶絾鏈彂璐?宸插彂璐?瀹㈡埛浠樻鎴愬姛4瀹㈡埛鍙栨秷浠樻ent',PRIMARYKEY(`id`))engine=InnoDBDEFAULTCHARSET=utf8;杩欓噷鐨勭姸鎬佹槸瑕佸吋瀹筧pp鏀粯锛岃繖涓缃郴缁熸槸web绔殑h5鏀粯銆傚啓bug鍓嶇殑涓€涓皬闂瓟Q锛氭湁鍝簺鍌婚€肩綉鍙嬪彂缁欐垜锛氱湅涓嶆噦涓嶈绱э紝瀛︿簡灏辨槑鐧戒簡锛屽姫鍔涴煉猀锛氬悜鎴戣婧愮爜:鏂囩珷涓殑浠ｇ爜鈮堟簮鐮侊紙濡傛灉瑕佽锛屽簲璇ュ啓婧愮爜鍙戜竴涓嬶級Q锛氫箣鍓嶇殑琛ㄦ牸璁捐锛屾病鏈夌湅鍒板瓨鍌ㄧ殑鐗╁搧锛屼絾鏄樉绀轰簡浠锋牸銆傛垜锛氱粓浜庢湁浣嶈€佷汉寰堣鐪熺殑闂簡涓€涓棶棰樸€俥xchange_info瀛楁鎻忚堪鈥滃叧浜庡晢鍝佷环鏍肩殑淇℃伅鈥濄€傝繖閲屾槸涓€涓猨son瀛楃涓诧紝鏂逛究灞曞紑淇℃伅锛岃繖鏍疯〃缁撴瀯鐪嬭捣鏉ヤ笉浼氬お娣蜂贡銆?/RMB锛堝崟浣嶏細鍒嗭級{"price":199,"discount":0,"goods":{"coin":20//鍏戞崲鐨勫晢鍝佹槸20閲戝竵}}//绉垎{"score":5999999,"discount":85,//杩欓噷浠嬬粛涓€涓嬫墦鎶橈紝鍏戞崲馃殫15鎶?goods":{"car":81//鍏戞崲鐨勫晢鍝佹槸涓€杈唅d=81鐨勮溅锛堝彲闅忔剰鎵╁厖锛墋}//绉垎+浜烘皯甯侊紝璇疯璁?/PS锛氳繖閲岃娉ㄦ剰锛?绉垎绛変簬鍒?鍒嗭紝鎬庝箞璋冩暣绉垎鍒嗛厤鐢变綘鍐冲畾銆?/涓€鑸儏鍐典笅锛屼环鍊?999鐨勫崟鍙嶇浉鏈虹粰鍑虹殑鍏戞崲浠锋牸鏄?0000绉垎+8599鍏冿紝杩欓噷鎴戜滑鎺ㄥ嚭鐨勬柊鍔熻兘鏄嫢鏈変互涓婄殑鐢ㄦ埛40000绉垎鍙互鑷璋冩暣鍏戞崲绉垎锛岃揪鍒扮敤绉垎鎶垫墸浜烘皯甯佺殑鐩殑锛岄渶瑕佷弗鏍兼帶鍒剁Н鍒嗐€傚綋鐒朵篃涓嶆槸鐢ㄦ埛闅忔剰璋冩暣鐨勶紝鎵€浠ユ垜浠殑鐩告満灏嗘棤娉曟敹鍥炴垚鏈€傛墍浠ュ姞浜嗕袱涓棬妲涘€硷紝鏈€楂樺垎鍜屾渶浣庝汉姘戝竵銆傜敤鎴疯皟鏁寸偣鐨勫€间笉鑳借秴杩囨渶澶х偣銆傝繖涓嶄粎璧嬩簣浜嗙敤鎴疯嚜涓绘潈锛屼篃鎺у埗浜嗘垜浠殑鎹熷け銆傛垜浠細鍦ㄥ啓瀹宐ug涔嬪悗鍐嶅姣斿疄闄呮敮浠樸€傞鍊间篃浜叉皯{"score":40000,"max_score":50000,"price":859900,"min_price":849900,"discount":95,"goods":{"camera":78//鎹竴涓煋穡ithid=78}}//鎶樻墸璁＄畻锛氾紙鎹㈢畻鎴愪汉姘戝竵涔樹互100锛?/鎬讳环鍊?0000+859900=899900//鎶樻墸鎬讳环鍊硷紙40000+859900锛?0.95=854905//鐢ㄦ埛闇€瑕乸ay(((40000+859900)*0.95)-40000)=814905//鎶樻墸浠?59900-814905=44995//鎶樻墸鍔犱笂鏈€澶у彲鐢ㄧН鍒嗙浉褰撲簬渚垮疁1000鍏冦€?.鍐檅ug鍓嶇闇€瑕佺殑鍑犱釜鎿嶄綔锛氳鍒嗙被锛堣繖涓彲浠ョ粨鍚堣鍒嗙被鍟嗗搧鍋氭垚棣栭〉鐣岄潰锛夎鍒嗙被鍟嗗搧璇诲晢鍝佷俊鎭厬鎹㈠晢鍝佽鍏ㄩ儴鍏戞崲璁板綍璇诲崟绗斿厬鎹㈣褰曟煡璇㈠厬鎹㈣褰曠姸鎬侊紙Polling锛夎繖閲岀殑鍓嶇骞朵笉鏄壒鎸噖eb锛岃€屾槸鎸嘺ndroid銆乮os銆亀eb锛屼互鍙婂疄鐜颁笂杩版帴鍙ｇ殑妗岄潰搴旂敤鍚庣銆傛澶栵紝杩橀渶瑕佹暣鍚堟敮浠樸€傞噸鐐规槸鍏戞崲鍟嗗搧鐨勬帴鍙ｄ唬鐮佺殑鎵ц閮ㄥ垎銆傝繖閲屾垜灏嗕娇鐢ㄤ吉浠ｇ爜缂栧啓鍑芥暟convertGoods($userID,$commodityID,$paymenttype,$payRMB,$paymentpoints){$commodity=$commoditytable->find($commodityID);//妫€鏌?commodity鏄惁瀛樺湪锛屽惁鍒欐姤閿?commodity===doesnotexistreturndoesnotexist;//妫€鏌?commodity<=0鐨勫簱瀛榠f$commodity->stock<=0returnInsufficientstock,stoprequest;$鍟嗗搧浠锋牸淇℃伅=JSON瑙ｇ爜($commodity->exchange_info);$commodity鏀粯鏂瑰紡=$commodity->exchange_type;$user=$usertable->find($userID);//鐢ㄦ埛娌℃湁绉垎锛屽晢鍝佹敮浠樻柟寮忎笉闇€瑕佺Н鍒唅f($鍟嗗搧浠锋牸淇℃伅->璇勫垎>$鐢ㄦ埛->璇勫垎)&&($鍟嗗搧鏀粯鏂瑰紡==0||$paymentproduct鏂规硶==2)returnInsufficientpoints;$userID,commodityID=$commodityID,paymentstatus=2)->statistics//鏌ョ湅鍏戞崲娆℃暟if$commodity->exchange_num!==0if$exchangetimes>=$commodity->exchangetimesreturnexceedsexchangeTimes;//妫€鏌ラ噾棰濆悎娉曟€?priceinfo->price=$commoditypriceinfo->price==doesnotexist?0:$鍟嗗搧浠锋牸淇℃伅->浠锋牸;$鍟嗗搧浠锋牸淇℃伅->璇勫垎=$鍟嗗搧浠锋牸淇℃伅->璇勫垎==涓嶅瓨鍦紵0:$鍟嗗搧浠锋牸淇℃伅->璇勫垎锛沬f($payRMB+$paymentpoints)!=($commoditypriceinformation->price+$commoditypriceinformation->score)returnexchange鎵€闇€閲戦涓嶆纭紱switch($paymentmethodofgoods){case0://鐐规敮浠?paymenttablewriteID=$paymenttable->write(paymentpoint,paymenttime,waitingdeliverystatus);//鎵ｉ櫎鐢ㄦ埛绉垎$usertable->find($userID)->update($user->score-$paymentpoints);//鏇存柊鍟嗗搧搴撳瓨$commoditytable->find($commodityID)->update($commodity->stock-1);//鍙戦€佺墿鍝侀€昏緫濡傛灉鍙戦€佸け璐ラ渶瑕佽嚜宸卞疄鐜?paymenttable->search($paymenttablewriteID)returnexchangeissuccessful;浼戞伅;妗堜緥涓€锛?/浜烘皯甯佹敮浠榠f$paymenttype!==0&&$paymenttype!==1&&$paymenttype!==2return璇烽€夋嫨姝ｇ‘鐨勬敮浠樻柟寮忥紱//杩欓噷鐨勫彂璐х姸鎬侀渶瑕佸湪鏀粯瀹濇垨鑰呭井淇＄殑鍥炶皟涓鐞嗭紝鎴戜滑鍙兘棰勮涓虹瓑寰呭彂璐х姸鎬併€?Paymenttable->write(鏀粯鐐广€佹敮浠樻椂闂淬€佺瓑寰呭彂璐х姸鎬?锛?paymentparameters=$paymentSDK->鐢熸垚璁㈠崟锛?/澶勭悊鏀粯瀹濇垨寰俊浜ゆ槗閫昏緫闇€瑕侀渶瑕佸疄鐜癷f$paymentparameter===orderisnotgeneratedreturnfailedtogetpaymentparameter;else杩斿洖鍏戞崲鎴愬姛锛涗紤鎭?case2://绉垎+浜烘皯甯佹敮浠榠f$paymenttype!==0&&$paymenttype!==1&&$paymenttype!==2return璇烽€夋嫨姝ｇ‘鐨勬敮浠樻柟寮忥紱//鏌ョ湅閲戦鍜岀Н鍒嗚寖鍥磇f$PayRMB<$Product->min_price$PayRMB=$Product->min_price;$鏀粯绉垎=$鍟嗗搧浠锋牸淇℃伅->max_score锛沞lseif$paymentRMB>$commoditypriceinformation->price$paymentRMB=$commoditypriceinformation->price;$鏀粯绉垎=$鍟嗗搧浠锋牸淇℃伅->绉垎锛?/杩欓噷鐨勫彂璐х姸鎬侀渶瑕佸湪鏀粯瀹濇垨寰俊鐨勫洖璋冧腑澶勭悊銆傛垜浠彧鑳介璁句负寰呭彂璐х姸鎬?paymenttable->write(paymentpoints,paymenttime,waitingfordeliverystatus);$paymentparameter=$paymentSDK->鐢熸垚璁㈠崟锛?/澶勭悊鏀粯瀹濇垨寰俊鐨勪氦鏄撻€昏緫闇€瑕佽嚜宸卞疄鐜板鏋?payment鍙傛暟===璁㈠崟娌℃湁鐢熸垚return鑾峰彇鏀粯鍙傛暟澶辫触锛沞lsereturn鍏戞崲鎴愬姛锛涗紤鎭?}}鏈€缁堜唬鐮佹祦璇ヨ繃绋嬪畬鎴愩€傚鏋滅湡鐨勫啓浜哹ug锛岃繕闇€瑕佽€冭檻鍏朵粬闂锛屾瘮濡傦細涓€涓墿鍝佸悓鏃惰涓や釜浜轰氦鎹紝鍙彂閫佷竴涓汉锛屽噺灏戞煡璇㈣礋鎷呫€俥xchange杩囩▼涓暟鎹簱鎸備簡锛屾暟鎹簱娌℃湁绱㈠紩銆傚鏋渋tem鎴栬€卲ay瓒婃潵瓒婂锛屾煡璇㈤渶瑕佺殑鏃堕棿灏变細鍙橀暱锛屼紭鍖栬捣鏉ヨ繕鏈夊緢闀跨殑璺璧?/p>
