{"id":119029,"date":"2026-10-28T19:25:00","date_gmt":"2026-10-28T11:25:00","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/119029.html"},"modified":"2026-10-28T19:25:00","modified_gmt":"2026-10-28T11:25:00","slug":"flask%e8%ae%a2%e5%8d%95%e7%b3%bb%e7%bb%9f%e5%ae%8c%e6%95%b4%e5%ae%9e%e7%8e%b0%ef%bd%9c%e4%ba%8b%e5%8a%a1%e5%a4%84%e7%90%86%e7%8a%b6%e6%80%81%e6%b5%81%e8%bd%ac%e9%98%b2%e8%b6%85%e5%8d%96%ef%bc%88","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/119029.html","title":{"rendered":"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09"},"content":{"rendered":"<p>\u26a0\ufe0f \u514d\u8d23\u58f0\u660e&#xff1a;\u672c\u6587\u9879\u76ee\u4ec5\u4f9b\u6280\u672f\u5b66\u4e60\u53c2\u8003&#xff0c;\u4e25\u7981\u76f4\u63a5\u4f5c\u4e3a\u6bd5\u4e1a\u8bbe\u8ba1\u6216\u8bfe\u7a0b\u4f5c\u4e1a\u63d0\u4ea4\u3002\u8bf7\u7ed3\u5408\u81ea\u8eab\u9700\u6c42\u8fdb\u884c\u4e8c\u6b21\u5f00\u53d1\u4e0e\u521b\u65b0&#xff0c;\u5b66\u672f\u8bda\u4fe1\u4ece\u6211\u505a\u8d77 &#x1f642;<\/p>\n<hr \/>\n<p>\u8d2d\u7269\u8f66\u51fa\u95ee\u9898\u9876\u591a\u662f\u6570\u91cf\u7b97\u9519&#xff0c;\u8ba2\u5355\u51fa\u95ee\u9898\u5c31\u662f\u94b1\u548c\u5e93\u5b58\u5bf9\u4e0d\u4e0a&#xff0c;\u771f\u4f1a\u51fa\u4e8b\u3002<\/p>\n<p>\u4ece\u7528\u6237\u70b9\u51fb&#034;\u63d0\u4ea4\u8ba2\u5355&#034;\u7684\u90a3\u4e00\u523b\u8d77&#xff0c;\u4e00\u8fde\u4e32\u7684\u52a8\u4f5c\u8981\u5728\u6781\u77ed\u65f6\u95f4\u5185\u5b8c\u6210&#xff1a;\u6821\u9a8c\u5e93\u5b58\u3001\u6263\u51cf\u5e93\u5b58\u3001\u751f\u6210\u8ba2\u5355\u53f7\u3001\u521b\u5efa\u8ba2\u5355\u4e3b\u8868\u3001\u521b\u5efa\u8ba2\u5355\u660e\u7ec6\u8868\u3001\u6e05\u7a7a\u8d2d\u7269\u8f66\u3001\u8df3\u652f\u4ed8\u9875\u3002<\/p>\n<p>\u4e2d\u95f4\u4efb\u4f55\u4e00\u6b65\u51fa\u95ee\u9898&#xff0c;\u90fd\u53ef\u80fd\u5bfc\u81f4&#034;\u94b1\u4ed8\u4e86\u8ba2\u5355\u6ca1\u4e86&#034;\u6216\u8005&#034;\u8ba2\u5355\u751f\u6210\u4e86\u5e93\u5b58\u6ca1\u6263&#034;\u7684\u707e\u96be\u3002<\/p>\n<p>\u8bf4\u767d\u4e86\u8fd9\u4e00\u8282\u4f60\u53ea\u8981\u8bb0\u4f4f\u4e00\u4ef6\u4e8b&#xff1a;\u6240\u6709\u5199\u5e93\u7684\u64cd\u4f5c\u5fc5\u987b\u585e\u4e00\u4e2a\u4e8b\u52a1\u91cc&#xff0c;\u4e0d\u7136\u65e9\u665a\u51fa\u4e8b\u3002<\/p>\n<p>\u4e2d\u95f4\u4efb\u4f55\u4e00\u6b65\u6302\u4e86&#xff0c;\u524d\u9762\u5df2\u7ecf\u5199\u8fdb\u53bb\u7684\u4e1c\u897f\u5fc5\u987b\u5168\u90e8\u56de\u6eda&#xff0c;\u4e0d\u7136\u5c31\u662f\u810f\u6570\u636e\u3002<\/p>\n<hr \/>\n<h3>\u8ba2\u5355\u72b6\u6001\u6d41\u8f6c\u5148\u641e\u6e05\u695a<\/h3>\n<p>\u5728\u5199\u4ee3\u7801\u4e4b\u524d&#xff0c;\u5148\u628a\u8ba2\u5355\u6709\u54ea\u4e9b\u72b6\u6001\u3001\u72b6\u6001\u4e4b\u95f4\u600e\u4e48\u8f6c\u7684&#xff0c;\u753b\u5728\u8111\u5b50\u91cc\u3002<\/p>\n<p>\u7528\u6237\u4e0b\u5355<br \/>\n  \u2193<br \/>\n[\u5f85\u652f\u4ed8] \u2500\u2500\u7528\u6237\u53d6\u6d88\u2500\u2500\u2192 [\u5df2\u53d6\u6d88]<br \/>\n  \u2502<br \/>\n  \u2514\u2500\u2500\u652f\u4ed8\u6210\u529f\u2500\u2500\u2192 [\u5f85\u53d1\u8d27] \u2500\u2500\u5546\u5bb6\u53d1\u8d27\u2500\u2500\u2192 [\u5f85\u6536\u8d27] \u2500\u2500\u786e\u8ba4\u6536\u8d27\u2500\u2500\u2192 [\u5df2\u5b8c\u6210]<br \/>\n                      \u2502                     \u2502<br \/>\n                      \u2502                     \u2514\u2500\u2500\u7533\u8bf7\u9000\u6b3e\u2500\u2500\u2192 [\u9000\u6b3e\u4e2d] \u2500\u2500\u9000\u6b3e\u6210\u529f\u2500\u2500\u2192 [\u5df2\u9000\u6b3e]<br \/>\n                      \u2514\u2500\u2500\u7533\u8bf7\u9000\u6b3e\u2500\u2500\u2192 [\u9000\u6b3e\u4e2d]<\/p>\n<p>\u8fd97\u4e2a\u72b6\u6001\u5148\u5728\u8111\u5b50\u91cc\u8fc7\u4e00\u904d&#xff0c;\u4e0d\u7136\u540e\u9762\u4ee3\u7801\u91cc status&#061;\u51e0 \u4f60\u81ea\u5df1\u90fd\u7ed5\u6655&#xff1a;<\/p>\n<table>\n<tr>\u72b6\u6001\u503c\u72b6\u6001\u540d\u89e6\u53d1\u52a8\u4f5c\u8c01\u64cd\u4f5c<\/tr>\n<tbody>\n<tr>\n<td>0<\/td>\n<td>\u5f85\u652f\u4ed8<\/td>\n<td>\u7528\u6237\u4e0b\u5355<\/td>\n<td>\u7528\u6237<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>\u5f85\u53d1\u8d27<\/td>\n<td>\u652f\u4ed8\u6210\u529f<\/td>\n<td>\u7cfb\u7edf\u81ea\u52a8<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>\u5f85\u6536\u8d27<\/td>\n<td>\u5546\u5bb6\u53d1\u8d27<\/td>\n<td>\u7ba1\u7406\u5458<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>\u5df2\u5b8c\u6210<\/td>\n<td>\u7528\u6237\u786e\u8ba4\u6536\u8d27<\/td>\n<td>\u7528\u6237<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>\u5df2\u53d6\u6d88<\/td>\n<td>\u7528\u6237\u53d6\u6d88\u8ba2\u5355<\/td>\n<td>\u7528\u6237 \/ \u7cfb\u7edf\u8d85\u65f6<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>\u9000\u6b3e\u4e2d<\/td>\n<td>\u7528\u6237\u7533\u8bf7\u9000\u6b3e<\/td>\n<td>\u7528\u6237<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>\u5df2\u9000\u6b3e<\/td>\n<td>\u9000\u6b3e\u5ba1\u6838\u901a\u8fc7<\/td>\n<td>\u7ba1\u7406\u5458<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h3>\u4e00\u3001\u751f\u6210\u8ba2\u5355&#xff1a;\u6574\u5957\u6d41\u7a0b &#043; \u6570\u636e\u5e93\u4e8b\u52a1<\/h3>\n<p>\u751f\u6210\u8ba2\u5355\u662f\u6700\u6838\u5fc3\u7684\u4ee3\u7801&#xff0c;\u5fc5\u987b\u653e\u5728\u4e8b\u52a1\u91cc\u3002<\/p>\n<p><span class=\"token keyword\">import<\/span> random<br \/>\n<span class=\"token keyword\">import<\/span> time<br \/>\n<span class=\"token keyword\">from<\/span> datetime <span class=\"token keyword\">import<\/span> datetime<br \/>\n<span class=\"token keyword\">from<\/span> flask <span class=\"token keyword\">import<\/span> request<span class=\"token punctuation\">,<\/span> jsonify<span class=\"token punctuation\">,<\/span> render_template<span class=\"token punctuation\">,<\/span> redirect<span class=\"token punctuation\">,<\/span> url_for<span class=\"token punctuation\">,<\/span> flash<br \/>\n<span class=\"token keyword\">from<\/span> flask_login <span class=\"token keyword\">import<\/span> login_required<span class=\"token punctuation\">,<\/span> current_user<\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/create&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_create<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u751f\u6210\u8ba2\u5355&#034;&#034;&#034;<\/span><br \/>\n    address_id <span class=\"token operator\">&#061;<\/span> request<span class=\"token punctuation\">.<\/span>form<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;address_id&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">type<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    remark <span class=\"token operator\">&#061;<\/span> request<span class=\"token punctuation\">.<\/span>form<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;remark&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;&#039;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token comment\"># \u5f00\u542f\u4e8b\u52a1<\/span><br \/>\n        <span class=\"token keyword\">with<\/span> db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>begin_nested<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c1\u6b65&#xff1a;\u67e5\u8d2d\u7269\u8f66\u4e2d\u9009\u4e2d\u7684\u5546\u54c1 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            cart_items <span class=\"token operator\">&#061;<\/span> db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">(<\/span>Cart<span class=\"token punctuation\">,<\/span> Goods<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span><br \/>\n                Goods<span class=\"token punctuation\">,<\/span> Cart<span class=\"token punctuation\">.<\/span>goods_id <span class=\"token operator\">&#061;&#061;<\/span> Goods<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">filter<\/span><span class=\"token punctuation\">(<\/span><br \/>\n                Cart<span class=\"token punctuation\">.<\/span>user_id <span class=\"token operator\">&#061;&#061;<\/span> current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                Cart<span class=\"token punctuation\">.<\/span>selected <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>with_for_update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">all<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u884c\u9501&#xff0c;\u9632\u6b62\u5e76\u53d1<\/span><\/p>\n<p>            <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> cart_items<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u8bf7\u5148\u9009\u62e9\u5546\u54c1&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c2\u6b65&#xff1a;\u6821\u9a8c\u5e93\u5b58 &#043; \u8ba1\u7b97\u603b\u91d1\u989d &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            total_amount <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">0<\/span><br \/>\n            order_items_data <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span>  <span class=\"token comment\"># \u5b58\u8ba2\u5355\u9879\u6570\u636e<\/span><\/p>\n<p>            <span class=\"token keyword\">for<\/span> cart<span class=\"token punctuation\">,<\/span> goods <span class=\"token keyword\">in<\/span> cart_items<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> goods<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    <span class=\"token keyword\">raise<\/span> Exception<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;\u5546\u54c1\u3010<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>goods<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u3011\u5df2\u4e0b\u67b6&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                <span class=\"token keyword\">if<\/span> cart<span class=\"token punctuation\">.<\/span>quantity <span class=\"token operator\">&gt;<\/span> goods<span class=\"token punctuation\">.<\/span>stock<span class=\"token punctuation\">:<\/span><br \/>\n                    <span class=\"token keyword\">raise<\/span> Exception<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;\u5546\u54c1\u3010<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>goods<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u3011\u5e93\u5b58\u4e0d\u8db3&#xff0c;\u4ec5\u5269<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>goods<span class=\"token punctuation\">.<\/span>stock<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u4ef6&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>                subtotal <span class=\"token operator\">&#061;<\/span> goods<span class=\"token punctuation\">.<\/span>price <span class=\"token operator\">*<\/span> cart<span class=\"token punctuation\">.<\/span>quantity<br \/>\n                total_amount <span class=\"token operator\">&#043;&#061;<\/span> subtotal<\/p>\n<p>                order_items_data<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><br \/>\n                    <span class=\"token string\">&#039;goods_id&#039;<\/span><span class=\"token punctuation\">:<\/span> goods<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;goods_name&#039;<\/span><span class=\"token punctuation\">:<\/span> goods<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;goods_image&#039;<\/span><span class=\"token punctuation\">:<\/span> goods<span class=\"token punctuation\">.<\/span>cover_image<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;price&#039;<\/span><span class=\"token punctuation\">:<\/span> goods<span class=\"token punctuation\">.<\/span>price<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;quantity&#039;<\/span><span class=\"token punctuation\">:<\/span> cart<span class=\"token punctuation\">.<\/span>quantity<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;subtotal&#039;<\/span><span class=\"token punctuation\">:<\/span> subtotal<br \/>\n                <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c3\u6b65&#xff1a;\u67e5\u6536\u8d27\u5730\u5740 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            address <span class=\"token operator\">&#061;<\/span> Address<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n                <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>address_id<span class=\"token punctuation\">,<\/span><br \/>\n                user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> address<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">raise<\/span> Exception<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u8bf7\u9009\u62e9\u6536\u8d27\u5730\u5740&#039;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># \u5730\u5740\u5feb\u7167\u62fc\u63a5&#xff08;\u7701 &#043; \u5e02 &#043; \u533a &#043; \u8be6\u7ec6\u5730\u5740&#xff09;<\/span><br \/>\n            full_address <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>address<span class=\"token punctuation\">.<\/span>province<span class=\"token punctuation\">}<\/span><\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>address<span class=\"token punctuation\">.<\/span>city<span class=\"token punctuation\">}<\/span><\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>address<span class=\"token punctuation\">.<\/span>district<span class=\"token punctuation\">}<\/span><\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>address<span class=\"token punctuation\">.<\/span>detail<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c4\u6b65&#xff1a;\u751f\u6210\u8ba2\u5355\u53f7 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            order_no <span class=\"token operator\">&#061;<\/span> generate_order_no<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c5\u6b65&#xff1a;\u521b\u5efa\u8ba2\u5355\u4e3b\u8868 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">(<\/span><br \/>\n                order_no<span class=\"token operator\">&#061;<\/span>order_no<span class=\"token punctuation\">,<\/span><br \/>\n                user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                receiver_name<span class=\"token operator\">&#061;<\/span>address<span class=\"token punctuation\">.<\/span>receiver<span class=\"token punctuation\">,<\/span><br \/>\n                receiver_phone<span class=\"token operator\">&#061;<\/span>address<span class=\"token punctuation\">.<\/span>phone<span class=\"token punctuation\">,<\/span><br \/>\n                receiver_address<span class=\"token operator\">&#061;<\/span>full_address<span class=\"token punctuation\">,<\/span><br \/>\n                total_amount<span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">round<\/span><span class=\"token punctuation\">(<\/span>total_amount<span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                pay_amount<span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">round<\/span><span class=\"token punctuation\">(<\/span>total_amount<span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>  <span class=\"token comment\"># \u6ca1\u6709\u4f18\u60e0\u7684\u8bdd\u5b9e\u4ed8&#061;\u603b\u4ef7<\/span><br \/>\n                status<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span>  <span class=\"token comment\"># \u5f85\u652f\u4ed8<\/span><br \/>\n                remark<span class=\"token operator\">&#061;<\/span>remark<br \/>\n            <span class=\"token punctuation\">)<\/span><br \/>\n            db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>add<span class=\"token punctuation\">(<\/span>order<span class=\"token punctuation\">)<\/span><br \/>\n            db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>flush<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u62ff\u5230 order.id<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c6\u6b65&#xff1a;\u521b\u5efa\u8ba2\u5355\u660e\u7ec6 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> item <span class=\"token keyword\">in<\/span> order_items_data<span class=\"token punctuation\">:<\/span><br \/>\n                order_item <span class=\"token operator\">&#061;<\/span> OrderItem<span class=\"token punctuation\">(<\/span><br \/>\n                    order_id<span class=\"token operator\">&#061;<\/span>order<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    goods_id<span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;goods_id&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    goods_name<span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;goods_name&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    goods_image<span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;goods_image&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    price<span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;price&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    quantity<span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;quantity&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                    subtotal<span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">round<\/span><span class=\"token punctuation\">(<\/span>item<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;subtotal&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token punctuation\">)<\/span><br \/>\n                db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>add<span class=\"token punctuation\">(<\/span>order_item<span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c7\u6b65&#xff1a;\u6263\u51cf\u5e93\u5b58 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> cart<span class=\"token punctuation\">,<\/span> goods <span class=\"token keyword\">in<\/span> cart_items<span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token comment\"># \u4e50\u89c2\u9501\u65b9\u5f0f\u6263\u5e93\u5b58&#xff1a;stock &gt;&#061; \u6570\u91cf\u65f6\u624d\u66f4\u65b0<\/span><br \/>\n                result <span class=\"token operator\">&#061;<\/span> Goods<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>goods<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><br \/>\n                    <span class=\"token string\">&#039;stock&#039;<\/span><span class=\"token punctuation\">:<\/span> Goods<span class=\"token punctuation\">.<\/span>stock <span class=\"token operator\">&#8211;<\/span> cart<span class=\"token punctuation\">.<\/span>quantity<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;sales&#039;<\/span><span class=\"token punctuation\">:<\/span> Goods<span class=\"token punctuation\">.<\/span>sales <span class=\"token operator\">&#043;<\/span> cart<span class=\"token punctuation\">.<\/span>quantity<br \/>\n                <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n                <span class=\"token keyword\">if<\/span> result <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                    <span class=\"token keyword\">raise<\/span> Exception<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#039;\u5546\u54c1\u3010<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>goods<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u3011\u5e93\u5b58\u4e0d\u8db3&#039;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u7b2c8\u6b65&#xff1a;\u5220\u9664\u8d2d\u7269\u8f66\u4e2d\u5df2\u7ed3\u7b97\u7684\u5546\u54c1 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n            Cart<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">filter<\/span><span class=\"token punctuation\">(<\/span><br \/>\n                Cart<span class=\"token punctuation\">.<\/span>user_id <span class=\"token operator\">&#061;&#061;<\/span> current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                Cart<span class=\"token punctuation\">.<\/span>selected <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>delete<span class=\"token punctuation\">(<\/span>synchronize_session<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># \u4e8b\u52a1\u63d0\u4ea4<\/span><br \/>\n        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u8ba2\u5355\u521b\u5efa\u6210\u529f&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#039;order_id&#039;<\/span><span class=\"token punctuation\">:<\/span> order<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#039;order_no&#039;<\/span><span class=\"token punctuation\">:<\/span> order<span class=\"token punctuation\">.<\/span>order_no<br \/>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token comment\"># \u4e8b\u52a1\u56de\u6eda<\/span><br \/>\n        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>rollback<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>e<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">generate_order_no<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u751f\u6210\u552f\u4e00\u8ba2\u5355\u53f7&#xff1a;\u65f6\u95f4\u6233 &#043; \u7528\u6237ID\u540e4\u4f4d &#043; 4\u4f4d\u968f\u673a\u6570&#034;&#034;&#034;<\/span><br \/>\n    timestamp <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strftime<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;%Y%m%d%H%M%S&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    user_suffix <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>zfill<span class=\"token punctuation\">(<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token operator\">&#8211;<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    random_num <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>random<span class=\"token punctuation\">.<\/span>randint<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">9999<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>zfill<span class=\"token punctuation\">(<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>timestamp<span class=\"token punctuation\">}<\/span><\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>user_suffix<span class=\"token punctuation\">}<\/span><\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>random_num<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><\/p>\n<p>\u8fd9\u6bb5\u4ee3\u7801\u91cc\u6709\u51e0\u4e2a\u5173\u952e\u70b9&#xff0c;\u7b54\u8fa9\u5e38\u95ee&#xff1a;<\/p>\n<h4>1. \u4e3a\u4ec0\u4e48\u7528\u4e8b\u52a1&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u751f\u6210\u8ba2\u5355\u6d89\u53ca\u591a\u4e2a\u6570\u636e\u5e93\u64cd\u4f5c&#xff08;\u521b\u5efa\u8ba2\u5355\u3001\u521b\u5efa\u660e\u7ec6\u3001\u6263\u5e93\u5b58\u3001\u5220\u8d2d\u7269\u8f66&#xff09;&#xff0c;\u4efb\u4f55\u4e00\u6b65\u5931\u8d25\u90fd\u8981\u5168\u90e8\u56de\u9000\u3002\u6bd4\u5982\u5e93\u5b58\u6263\u4e86\u4f46\u8ba2\u5355\u6ca1\u751f\u6210\u2014\u2014\u7528\u6237\u7684\u94b1\u767d\u82b1\u4e86&#xff0c;\u5e93\u5b58\u4e5f\u5c11\u4e86&#xff0c;\u4e24\u5934\u51fa\u95ee\u9898\u3002\u4e8b\u52a1\u4fdd\u8bc1\u8981\u4e48\u5168\u6210\u529f\u3001\u8981\u4e48\u5168\u5931\u8d25\u3002<\/p>\n<h4>2. \u4e3a\u4ec0\u4e48\u7528 with_for_update()&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u884c\u9501\u3002\u9632\u6b62\u4e24\u4e2a\u7528\u6237\u540c\u65f6\u4e70\u6700\u540e\u4e00\u4ef6\u5546\u54c1\u65f6&#xff0c;\u90fd\u901a\u8fc7\u4e86\u5e93\u5b58\u68c0\u67e5&#xff0c;\u7136\u540e\u90fd\u53bb\u6263\u5e93\u5b58&#xff0c;\u5bfc\u81f4\u8d85\u5356\u3002with_for_update() \u4f1a\u5728\u67e5\u8be2\u65f6\u7ed9\u8fd9\u4e9b\u884c\u52a0\u6392\u4ed6\u9501&#xff0c;\u5176\u4ed6\u4e8b\u52a1\u8981\u7b49\u8fd9\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u4e86\u624d\u80fd\u8bfb&#xff0c;\u4fdd\u8bc1\u5e93\u5b58\u6821\u9a8c\u548c\u6263\u51cf\u662f\u539f\u5b50\u7684\u3002<\/p>\n<h4>3. \u8ba2\u5355\u53f7\u600e\u4e48\u751f\u6210\u7684&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u65f6\u95f4\u6233 &#043; \u7528\u6237ID\u540e4\u4f4d &#043; 4\u4f4d\u968f\u673a\u6570\u3002\u8fd9\u6837\u6709\u51e0\u4e2a\u597d\u5904&#xff1a;\u65f6\u95f4\u7ef4\u5ea6\u4e00\u773c\u5c31\u80fd\u770b\u51fa\u4ec0\u4e48\u65f6\u5019\u4e0b\u7684\u5355\u3001\u5305\u542b\u7528\u6237\u4fe1\u606f\u65b9\u4fbf\u6392\u67e5\u3001\u968f\u673a\u6570\u9632\u6b62\u540c\u4e00\u79d2\u540c\u4e00\u7528\u6237\u7684\u591a\u4e2a\u8ba2\u5355\u91cd\u590d\u3002\u957f\u5ea6\u56fa\u5b9a&#xff0c;32\u4f4d\u4ee5\u5185\u3002<\/p>\n<h4>4. \u8ba2\u5355\u9879\u4e3a\u4ec0\u4e48\u8981\u5b58\u5546\u54c1\u540d\u79f0\u548c\u4ef7\u683c\u7684\u5feb\u7167&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u56e0\u4e3a\u5546\u54c1\u4fe1\u606f\u4f1a\u53d8\u2014\u2014\u6539\u540d\u3001\u8c03\u4ef7\u3001\u4e0b\u67b6\u3001\u5220\u9664\u3002\u5982\u679c\u53ea\u5b58\u5546\u54c1ID&#xff0c;\u4ee5\u540e\u67e5\u5386\u53f2\u8ba2\u5355\u65f6&#xff0c;\u5546\u54c1\u540d\u53ef\u80fd\u53d8\u4e86&#xff0c;\u4ef7\u683c\u4e5f\u4e0d\u4e00\u6837\u4e86&#xff0c;\u7528\u6237\u770b\u5230\u7684\u8ba2\u5355\u4fe1\u606f\u5c31\u4e0d\u5bf9\u4e86\u3002\u5feb\u7167\u5b58\u4e0b\u6765&#xff0c;\u8ba2\u5355\u6570\u636e\u6c38\u8fdc\u662f\u4e0b\u5355\u65f6\u7684\u6837\u5b50\u3002<\/p>\n<h4>5. \u5730\u5740\u4e3a\u4ec0\u4e48\u5b58\u5feb\u7167&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u540c\u7406&#xff0c;\u7528\u6237\u53ef\u80fd\u4fee\u6539\u6216\u5220\u9664\u6536\u8d27\u5730\u5740\u3002\u8ba2\u5355\u91cc\u7684\u6536\u8d27\u5730\u5740\u5fc5\u987b\u662f\u4e0b\u5355\u90a3\u4e00\u523b\u7684\u5730\u5740&#xff0c;\u4e0d\u80fd\u8ddf\u7740\u7528\u6237\u5730\u5740\u8868\u7684\u53d8\u5316\u800c\u53d8\u5316\u3002\u6240\u4ee5\u628a\u6536\u8d27\u4eba\u3001\u7535\u8bdd\u3001\u5b8c\u6574\u5730\u5740\u76f4\u63a5\u5b58\u5230\u8ba2\u5355\u8868\u91cc&#xff0c;\u505a\u6210\u5feb\u7167\u3002<\/p>\n<hr \/>\n<h3>\u4e8c\u3001\u8ba2\u5355\u5217\u8868&#xff08;\u7528\u6237\u7aef&#xff09;<\/h3>\n<p>\u7528\u6237\u7684&#034;\u6211\u7684\u8ba2\u5355&#034;\u9875\u9762&#xff0c;\u4e00\u822c\u652f\u6301\u6309\u72b6\u6001\u7b5b\u9009&#xff1a;\u5168\u90e8 \/ \u5f85\u652f\u4ed8 \/ \u5f85\u53d1\u8d27 \/ \u5f85\u6536\u8d27 \/ \u9000\u6b3e \/ \u5df2\u5b8c\u6210\u3002<\/p>\n<p>\u6211\u7684\u8ba2\u5355\u9875\u9762\u957f\u8fd9\u6837\u2014\u2014\u9876\u90e8\u72b6\u6001 Tab&#xff0c;\u4e0b\u9762\u662f\u8ba2\u5355\u5361\u7247&#xff08;\u8ba2\u5355\u53f7\u3001\u5546\u54c1\u660e\u7ec6\u3001\u4e0b\u5355\u65f6\u95f4\u3001\u91d1\u989d\u3001\u8be6\u60c5\u6309\u94ae&#xff09;&#xff1a;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261028112458-6ae1db8af37a1.png\" alt=\"MYD\u5546\u57ce\u8ba2\u5355\u5217\u8868\" \/><\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/list&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_list<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    status <span class=\"token operator\">&#061;<\/span> request<span class=\"token punctuation\">.<\/span>args<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;status&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">type<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token comment\"># \u4e0d\u4f20\u5c31\u662f\u5168\u90e8<\/span><br \/>\n    page <span class=\"token operator\">&#061;<\/span> request<span class=\"token punctuation\">.<\/span>args<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;page&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">type<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    query <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> status <span class=\"token keyword\">is<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        query <span class=\"token operator\">&#061;<\/span> query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>status<span class=\"token operator\">&#061;<\/span>status<span class=\"token punctuation\">)<\/span><\/p>\n<p>    query <span class=\"token operator\">&#061;<\/span> query<span class=\"token punctuation\">.<\/span>order_by<span class=\"token punctuation\">(<\/span>OrderInfo<span class=\"token punctuation\">.<\/span>created_at<span class=\"token punctuation\">.<\/span>desc<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    pagination <span class=\"token operator\">&#061;<\/span> query<span class=\"token punctuation\">.<\/span>paginate<span class=\"token punctuation\">(<\/span>page<span class=\"token operator\">&#061;<\/span>page<span class=\"token punctuation\">,<\/span> per_page<span class=\"token operator\">&#061;<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span> error_out<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    orders <span class=\"token operator\">&#061;<\/span> pagination<span class=\"token punctuation\">.<\/span>items<\/p>\n<p>    <span class=\"token comment\"># \u67e5\u6bcf\u4e2a\u8ba2\u5355\u7684\u660e\u7ec6<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> order <span class=\"token keyword\">in<\/span> orders<span class=\"token punctuation\">:<\/span><br \/>\n        order<span class=\"token punctuation\">.<\/span>items <span class=\"token operator\">&#061;<\/span> OrderItem<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>order_id<span class=\"token operator\">&#061;<\/span>order<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">all<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># \u5404\u72b6\u6001\u6570\u91cf&#xff08;Tab \u4e0a\u663e\u793a\u7ea2\u70b9&#xff09;<\/span><br \/>\n    status_counts <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#039;pending_pay&#039;<\/span><span class=\"token punctuation\">:<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span> status<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>count<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#039;pending_ship&#039;<\/span><span class=\"token punctuation\">:<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span> status<span class=\"token operator\">&#061;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>count<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#039;pending_receive&#039;<\/span><span class=\"token punctuation\">:<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span> status<span class=\"token operator\">&#061;<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>count<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#039;refund&#039;<\/span><span class=\"token punctuation\">:<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">,<\/span> status<span class=\"token operator\">&#061;<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>count<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><\/p>\n<p>    <span class=\"token keyword\">return<\/span> render_template<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;order\/list.html&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                           orders<span class=\"token operator\">&#061;<\/span>orders<span class=\"token punctuation\">,<\/span><br \/>\n                           pagination<span class=\"token operator\">&#061;<\/span>pagination<span class=\"token punctuation\">,<\/span><br \/>\n                           current_status<span class=\"token operator\">&#061;<\/span>status<span class=\"token punctuation\">,<\/span><br \/>\n                           status_counts<span class=\"token operator\">&#061;<\/span>status_counts<span class=\"token punctuation\">)<\/span><\/p>\n<p>\u6a21\u677f\u6e32\u67d3\u6210 Tab \u5207\u6362\u7684\u5f62\u5f0f&#xff1a;<\/p>\n<p><span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>div<\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>order-tabs<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status is none %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\u5168\u90e8<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list?status&#061;0<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status &#061;&#061; 0 %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    \u5f85\u652f\u4ed8 {% if status_counts.pending_pay &gt; 0 %}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>span<\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>badge<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{{ status_counts.pending_pay }}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>span<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{% endif %}<br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list?status&#061;1<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status &#061;&#061; 1 %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    \u5f85\u53d1\u8d27 {% if status_counts.pending_ship &gt; 0 %}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>span<\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>badge<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{{ status_counts.pending_ship }}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>span<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{% endif %}<br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list?status&#061;2<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status &#061;&#061; 2 %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    \u5f85\u6536\u8d27 {% if status_counts.pending_receive &gt; 0 %}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>span<\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>badge<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{{ status_counts.pending_receive }}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>span<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{% endif %}<br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list?status&#061;5<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status &#061;&#061; 5 %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    \u9000\u6b3e\u4e2d {% if status_counts.refund &gt; 0 %}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>span<\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>badge<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{{ status_counts.refund }}<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>span<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>{% endif %}<br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n  <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>a<\/span> <span class=\"token attr-name\">href<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>\/order\/list?status&#061;3<span class=\"token punctuation\">&#034;<\/span><\/span> <span class=\"token attr-name\">class<\/span><span class=\"token attr-value\"><span class=\"token punctuation attr-equals\">&#061;<\/span><span class=\"token punctuation\">&#034;<\/span>{% if current_status &#061;&#061; 3 %}active{% endif %}<span class=\"token punctuation\">&#034;<\/span><\/span><span class=\"token punctuation\">&gt;<\/span><\/span>\u5df2\u5b8c\u6210<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>a<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>div<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/p>\n<hr \/>\n<h3>\u4e09\u3001\u8ba2\u5355\u64cd\u4f5c&#xff1a;\u53d6\u6d88\u3001\u786e\u8ba4\u6536\u8d27\u3001\u7533\u8bf7\u9000\u6b3e<\/h3>\n<h4>\u53d6\u6d88\u8ba2\u5355&#xff08;\u5f85\u652f\u4ed8\u72b6\u6001\u624d\u53ef\u4ee5\u53d6\u6d88&#xff09;<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/cancel\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_cancel<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>order_id<span class=\"token punctuation\">,<\/span><br \/>\n        user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> order<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u8ba2\u5355\u4e0d\u5b58\u5728&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u53ea\u6709\u5f85\u652f\u4ed8\u624d\u80fd\u53d6\u6d88<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5f53\u524d\u72b6\u6001\u4e0d\u80fd\u53d6\u6d88&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">with<\/span> db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>begin_nested<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token comment\"># 1. \u66f4\u65b0\u8ba2\u5355\u72b6\u6001<\/span><br \/>\n            order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">4<\/span>  <span class=\"token comment\"># \u5df2\u53d6\u6d88<\/span><br \/>\n            order<span class=\"token punctuation\">.<\/span>cancel_time <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># 2. \u6062\u590d\u5e93\u5b58&#xff08;\u53d6\u6d88\u8ba2\u5355\u8981\u628a\u5e93\u5b58\u52a0\u56de\u53bb&#xff09;<\/span><br \/>\n            items <span class=\"token operator\">&#061;<\/span> OrderItem<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>order_id<span class=\"token operator\">&#061;<\/span>order<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">all<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> item <span class=\"token keyword\">in<\/span> items<span class=\"token punctuation\">:<\/span><br \/>\n                Goods<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">.<\/span>goods_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><br \/>\n                    <span class=\"token string\">&#039;stock&#039;<\/span><span class=\"token punctuation\">:<\/span> Goods<span class=\"token punctuation\">.<\/span>stock <span class=\"token operator\">&#043;<\/span> item<span class=\"token punctuation\">.<\/span>quantity<span class=\"token punctuation\">,<\/span><br \/>\n                    <span class=\"token string\">&#039;sales&#039;<\/span><span class=\"token punctuation\">:<\/span> Goods<span class=\"token punctuation\">.<\/span>sales <span class=\"token operator\">&#8211;<\/span> item<span class=\"token punctuation\">.<\/span>quantity<br \/>\n                <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u8ba2\u5355\u5df2\u53d6\u6d88&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>rollback<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u53d6\u6d88\u5931\u8d25&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h4>\u786e\u8ba4\u6536\u8d27&#xff08;\u5f85\u6536\u8d27\u72b6\u6001&#xff09;<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/confirm\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_confirm<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>order_id<span class=\"token punctuation\">,<\/span><br \/>\n        user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> order <span class=\"token keyword\">or<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u5f85\u6536\u8d27\u624d\u80fd\u786e\u8ba4<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5f53\u524d\u72b6\u6001\u4e0d\u80fd\u786e\u8ba4\u6536\u8d27&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">3<\/span>  <span class=\"token comment\"># \u5df2\u5b8c\u6210<\/span><br \/>\n    order<span class=\"token punctuation\">.<\/span>finish_time <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5df2\u786e\u8ba4\u6536\u8d27&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h4>\u7533\u8bf7\u9000\u6b3e&#xff08;\u5f85\u53d1\u8d27 \/ \u5f85\u6536\u8d27\u90fd\u80fd\u7533\u8bf7&#xff09;<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/refund\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_refund<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>order_id<span class=\"token punctuation\">,<\/span><br \/>\n        user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> order <span class=\"token keyword\">or<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u5f85\u53d1\u8d27\u6216\u5f85\u6536\u8d27\u624d\u80fd\u7533\u8bf7\u9000\u6b3e<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5f53\u524d\u72b6\u6001\u4e0d\u80fd\u7533\u8bf7\u9000\u6b3e&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">5<\/span>  <span class=\"token comment\"># \u9000\u6b3e\u4e2d<\/span><br \/>\n    db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u9000\u6b3e\u7533\u8bf7\u5df2\u63d0\u4ea4&#xff0c;\u7b49\u5f85\u5ba1\u6838&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<hr \/>\n<h3>\u56db\u3001\u540e\u53f0\u8ba2\u5355\u7ba1\u7406<\/h3>\n<p>\u7ba1\u7406\u5458\u90a3\u8fb9\u7684\u8ba2\u5355\u7ba1\u7406&#xff0c;\u4e3b\u8981\u662f\u53d1\u8d27\u548c\u9000\u6b3e\u5ba1\u6838\u3002<\/p>\n<h4>\u53d1\u8d27&#xff08;\u5f85\u53d1\u8d27 \u2192 \u5f85\u6536\u8d27&#xff09;<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/admin\/order\/ship\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;admin_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">admin_order_ship<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>get_or_404<span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u53ea\u6709\u5f85\u53d1\u8d27\u624d\u80fd\u53d1<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5f53\u524d\u72b6\u6001\u4e0d\u80fd\u53d1\u8d27&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">2<\/span>  <span class=\"token comment\"># \u5f85\u6536\u8d27<\/span><br \/>\n    order<span class=\"token punctuation\">.<\/span>ship_time <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># \u5982\u679c\u6709\u5feb\u9012\u5355\u53f7&#xff0c;\u53ef\u4ee5\u4f20\u8fc7\u6765<\/span><br \/>\n    express_no <span class=\"token operator\">&#061;<\/span> request<span class=\"token punctuation\">.<\/span>form<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;express_no&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> express_no<span class=\"token punctuation\">:<\/span><br \/>\n        order<span class=\"token punctuation\">.<\/span>express_no <span class=\"token operator\">&#061;<\/span> express_no  <span class=\"token comment\"># \u8868\u7ed3\u6784\u91cc\u52a0\u4e0a\u8fd9\u4e2a\u5b57\u6bb5<\/span><\/p>\n<p>    db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u53d1\u8d27\u6210\u529f&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h4>\u9000\u6b3e\u5ba1\u6838&#xff08;\u9000\u6b3e\u4e2d \u2192 \u5df2\u9000\u6b3e&#xff09;<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/admin\/order\/refund-approve\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;admin_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">admin_order_refund_approve<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>get_or_404<span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">5<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># \u53ea\u6709\u9000\u6b3e\u4e2d\u624d\u80fd\u5ba1\u6838<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u5f53\u524d\u72b6\u6001\u4e0d\u80fd\u5ba1\u6838&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">with<\/span> db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>begin_nested<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token comment\"># 1. \u66f4\u65b0\u8ba2\u5355\u72b6\u6001<\/span><br \/>\n            order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">6<\/span>  <span class=\"token comment\"># \u5df2\u9000\u6b3e<\/span><\/p>\n<p>            <span class=\"token comment\"># 2. \u6062\u590d\u5e93\u5b58<\/span><br \/>\n            items <span class=\"token operator\">&#061;<\/span> OrderItem<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span>order_id<span class=\"token operator\">&#061;<\/span>order<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">all<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> item <span class=\"token keyword\">in<\/span> items<span class=\"token punctuation\">:<\/span><br \/>\n                Goods<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>item<span class=\"token punctuation\">.<\/span>goods_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><br \/>\n                    <span class=\"token string\">&#039;stock&#039;<\/span><span class=\"token punctuation\">:<\/span> Goods<span class=\"token punctuation\">.<\/span>stock <span class=\"token operator\">&#043;<\/span> item<span class=\"token punctuation\">.<\/span>quantity<br \/>\n                <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>            <span class=\"token comment\"># 3. \u771f\u5b9e\u9879\u76ee\u91cc\u8fd9\u91cc\u8fd8\u8981\u8c03\u652f\u4ed8\u63a5\u53e3\u9000\u6b3e<\/span><br \/>\n            <span class=\"token comment\"># \u6bd5\u8bbe\u53ef\u4ee5\u7565\u8fc7&#xff0c;\u6216\u8005\u6a21\u62df\u4e00\u4e0b<\/span><\/p>\n<p>        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u9000\u6b3e\u6210\u529f&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>rollback<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u9000\u6b3e\u5931\u8d25&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<hr \/>\n<h3>\u4e94\u3001\u652f\u4ed8\u5bf9\u63a5&#xff08;\u53ef\u9009\u52a0\u5206\u9879&#xff09;<\/h3>\n<p>\u6bd5\u8bbe\u91cc\u652f\u4ed8\u53ef\u4ee5\u505a\u7b80\u5316\u7248\u2014\u2014\u6a21\u62df\u652f\u4ed8\u6210\u529f\u3002<\/p>\n<p>\u4f46\u5982\u679c\u60f3\u505a\u5f97\u771f\u5b9e\u4e00\u70b9&#xff0c;\u53ef\u4ee5\u63a5\u5165\u652f\u4ed8\u5b9d\u6c99\u7bb1\u73af\u5883&#xff0c;\u514d\u8d39\u7684&#xff0c;\u7b54\u8fa9\u6548\u679c\u597d\u3002<\/p>\n<p>\u7b80\u5316\u7248\u652f\u4ed8\u6d41\u7a0b&#xff1a;<\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/pay\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_pay<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u6a21\u62df\u652f\u4ed8\u9875\u9762&#034;&#034;&#034;<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>order_id<span class=\"token punctuation\">,<\/span><br \/>\n        user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first_or_404<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        flash<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\u8ba2\u5355\u72b6\u6001\u5f02\u5e38&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;error&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> redirect<span class=\"token punctuation\">(<\/span>url_for<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;order_list&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">return<\/span> render_template<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;order\/pay.html&#039;<\/span><span class=\"token punctuation\">,<\/span> order<span class=\"token operator\">&#061;<\/span>order<span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;app<span class=\"token punctuation\">.<\/span>route<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/order\/pay-success\/&lt;int:order_id&gt;&#039;<\/span><span class=\"token punctuation\">,<\/span> methods<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;POST&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token decorator annotation punctuation\">&#064;login_required<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">order_pay_success<\/span><span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u6a21\u62df\u652f\u4ed8\u6210\u529f\u56de\u8c03&#034;&#034;&#034;<\/span><br \/>\n    order <span class=\"token operator\">&#061;<\/span> OrderInfo<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">.<\/span>filter_by<span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token builtin\">id<\/span><span class=\"token operator\">&#061;<\/span>order_id<span class=\"token punctuation\">,<\/span><br \/>\n        user_id<span class=\"token operator\">&#061;<\/span>current_user<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>first<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> order <span class=\"token keyword\">or<\/span> order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u8ba2\u5355\u72b6\u6001\u5f02\u5e38&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    order<span class=\"token punctuation\">.<\/span>status <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span>  <span class=\"token comment\"># \u5f85\u53d1\u8d27<\/span><br \/>\n    order<span class=\"token punctuation\">.<\/span>pay_time <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    order<span class=\"token punctuation\">.<\/span>pay_type <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;alipay&#039;<\/span>  <span class=\"token comment\"># \u6a21\u62df\u652f\u4ed8\u5b9d\u652f\u4ed8<\/span><br \/>\n    db<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">return<\/span> jsonify<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#039;code&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;message&#039;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#039;\u652f\u4ed8\u6210\u529f&#039;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>\u771f\u5b9e\u63a5\u5165\u652f\u4ed8\u5b9d\u7684\u8bdd&#xff0c;\u7528 alipay-sdk-python \u8fd9\u4e2a\u5e93\u5c31\u884c&#xff0c;\u6d41\u7a0b\u662f&#xff1a;<\/p>\n<li>\u540e\u7aef\u751f\u6210\u652f\u4ed8\u94fe\u63a5&#xff08;\u8c03\u7528 alipay.trade.page.pay&#xff09;<\/li>\n<li>\u7528\u6237\u8df3\u8f6c\u5230\u652f\u4ed8\u5b9d\u9875\u9762\u4ed8\u6b3e<\/li>\n<li>\u652f\u4ed8\u5b9d\u5f02\u6b65\u56de\u8c03\u901a\u77e5\u652f\u4ed8\u7ed3\u679c<\/li>\n<li>\u540e\u7aef\u9a8c\u7b7e\u540e\u66f4\u65b0\u8ba2\u5355\u72b6\u6001<\/li>\n<p>\u8fd9\u4e2a\u529f\u80fd\u505a\u4e86&#xff0c;\u6bd5\u8bbe\u76f4\u63a5\u4e0a\u4e00\u4e2a\u6863\u6b21\u3002<\/p>\n<hr \/>\n<h3>\u8ba2\u5355\u6a21\u5757&#xff0c;\u7b54\u8fa9\u5e38\u95ee\u8fd9\u51e0\u95ee<\/h3>\n<h4>1. \u600e\u4e48\u9632\u6b62\u8d85\u5356&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u4e09\u79cd\u624b\u6bb5\u914d\u5408&#xff1a;\u2460\u6570\u636e\u5e93\u4e8b\u52a1\u2014\u2014\u6263\u5e93\u5b58\u548c\u521b\u5efa\u8ba2\u5355\u5728\u540c\u4e00\u4e2a\u4e8b\u52a1\u91cc&#xff1b;\u2461\u884c\u7ea7\u9501\u2014\u2014\u7528 SELECT &#8230; FOR UPDATE \u7ed9\u5546\u54c1\u884c\u52a0\u9501&#xff0c;\u9632\u6b62\u5e76\u53d1\u90fd\u8bfb\u5230\u540c\u4e00\u4e2a\u5e93\u5b58&#xff1b;\u2462\u4e50\u89c2\u9501\u2014\u2014\u66f4\u65b0\u5e93\u5b58\u65f6\u52a0 WHERE stock &gt;&#061; \u6570\u91cf \u7684\u6761\u4ef6&#xff0c;\u5f71\u54cd\u884c\u6570\u4e3a0\u5c31\u56de\u6eda\u3002\u4e09\u5c42\u4e00\u8d77\u7528&#xff0c;\u57fa\u672c\u4e0d\u4f1a\u8d85\u5356\u3002<\/p>\n<h4>2. \u8ba2\u5355\u660e\u7ec6\u8868\u4e3a\u4ec0\u4e48\u4e0d\u76f4\u63a5\u5173\u8054\u5546\u54c1\u8868&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u5173\u8054\u4e86&#xff0c;\u5b58\u4e86 goods_id\u3002\u4f46\u540c\u65f6\u5b58\u4e86\u5546\u54c1\u540d\u79f0\u3001\u56fe\u7247\u3001\u4ef7\u683c\u7684\u5feb\u7167\u3002\u56e0\u4e3a\u5546\u54c1\u4fe1\u606f\u4f1a\u53d8\u5316&#xff0c;\u5386\u53f2\u8ba2\u5355\u5fc5\u987b\u4fdd\u7559\u4e0b\u5355\u65f6\u7684\u539f\u59cb\u4fe1\u606f&#xff0c;\u4e0d\u80fd\u8ddf\u7740\u5546\u54c1\u8868\u7684\u53d8\u5316\u800c\u53d8\u5316\u3002\u6211\u6700\u5f00\u59cb\u8ba2\u5355\u660e\u7ec6\u53ea\u5b58\u4e86 goods_id&#xff0c;\u540e\u6765\u5546\u54c1\u6539\u4e86\u4e2a\u4ef7&#xff0c;\u5386\u53f2\u8ba2\u5355\u5168\u8ddf\u7740\u53d8\u4e86&#xff0c;\u5f53\u573a\u5c31\u61f5\u4e86&#xff0c;\u8fd9\u624d\u8865\u7684\u5feb\u7167\u5b57\u6bb5\u3002<\/p>\n<h4>3. \u8ba2\u5355\u53f7\u4e3a\u4ec0\u4e48\u4e0d\u7528\u81ea\u589eID&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u81ea\u589eID\u6709\u51e0\u4e2a\u95ee\u9898&#xff1a;\u66b4\u9732\u8ba2\u5355\u91cf&#xff08;\u522b\u4eba\u80fd\u4ece\u8ba2\u5355\u53f7\u63a8\u7b97\u4f60\u4e00\u5929\u591a\u5c11\u5355&#xff09;\u3001\u4e0d\u591f\u957f\u5bb9\u6613\u88ab\u731c\u5230\u3001\u4e0d\u5e26\u4e1a\u52a1\u4fe1\u606f\u3002\u81ea\u5b9a\u4e49\u8ba2\u5355\u53f7&#xff08;\u65f6\u95f4\u6233&#043;\u7528\u6237&#043;\u968f\u673a\u6570&#xff09;\u65e2\u552f\u4e00\u53c8\u5b89\u5168&#xff0c;\u8fd8\u80fd\u4ece\u8ba2\u5355\u53f7\u770b\u51fa\u65f6\u95f4\u4fe1\u606f\u3002<\/p>\n<h4>4. \u53d6\u6d88\u8ba2\u5355\u4e3a\u4ec0\u4e48\u8981\u6062\u590d\u5e93\u5b58&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u56e0\u4e3a\u4e0b\u5355\u7684\u65f6\u5019\u5df2\u7ecf\u6263\u4e86\u5e93\u5b58&#xff0c;\u5982\u679c\u53d6\u6d88\u4e86\u4e0d\u6062\u590d&#xff0c;\u5e93\u5b58\u5c31\u8d8a\u6765\u8d8a\u5c11&#xff0c;\u5546\u54c1\u4f1a\u83ab\u540d\u5176\u5999\u5730&#034;\u5356\u5b8c&#034;\u3002\u6ce8\u610f&#xff1a;\u53ea\u6709\u5f85\u652f\u4ed8\u72b6\u6001\u53d6\u6d88\u624d\u6062\u590d\u5e93\u5b58&#xff0c;\u5df2\u53d1\u8d27\u4e4b\u540e\u53d6\u6d88\u8d70\u9000\u6b3e\u6d41\u7a0b&#xff0c;\u9000\u6b3e\u7684\u65f6\u5019\u518d\u6062\u590d\u3002<\/p>\n<h4>5. \u4ec0\u4e48\u662f\u4e8b\u52a1&#xff1f;ACID\u662f\u4ec0\u4e48&#xff1f;<\/h4>\n<p>\u7b54&#xff1a;\u4e8b\u52a1\u662f\u4e00\u7ec4\u6570\u636e\u5e93\u64cd\u4f5c&#xff0c;\u8981\u4e48\u5168\u90e8\u6210\u529f&#xff0c;\u8981\u4e48\u5168\u90e8\u5931\u8d25\u3002ACID\u662f\u4e8b\u52a1\u7684\u56db\u4e2a\u7279\u6027&#xff1a;A\u539f\u5b50\u6027&#xff08;Atomicity&#xff0c;\u4e0d\u53ef\u5206\u5272&#xff09;\u3001C\u4e00\u81f4\u6027&#xff08;Consistency&#xff0c;\u6570\u636e\u4ece\u4e00\u4e2a\u4e00\u81f4\u72b6\u6001\u53d8\u5230\u53e6\u4e00\u4e2a\u4e00\u81f4\u72b6\u6001&#xff09;\u3001I\u9694\u79bb\u6027&#xff08;Isolation&#xff0c;\u591a\u4e2a\u4e8b\u52a1\u4e92\u4e0d\u5e72\u6270&#xff09;\u3001D\u6301\u4e45\u6027&#xff08;Durability&#xff0c;\u63d0\u4ea4\u540e\u6c38\u4e45\u751f\u6548&#xff09;\u3002<\/p>\n<hr \/>\n<p>\u8ba2\u5355\u6a21\u5757\u662f\u6574\u4e2a\u7535\u5546\u7cfb\u7edf\u7684\u6838\u5fc3&#xff0c;\u4e5f\u662f\u6bd5\u8bbe\u7b54\u8fa9\u8001\u5e08\u6700\u7231\u95ee\u7684\u5730\u65b9\u3002<\/p>\n<p>\u8fd9\u51e0\u5757\u5728\u7b54\u8fa9PPT\u91cc\u5404\u5360\u4e00\u9875&#xff0c;\u8001\u5e08\u95ee\u5230\u54ea\u4e2a\u4f60\u90fd\u80fd\u5c55\u5f00\u4e24\u53e5&#xff0c;\u57fa\u672c\u5c31\u4e0d\u4f1a\u88ab\u95ee\u5012\u3002<\/p>\n<hr \/>\n<p>\u6885\u96c5\u8fbe\u7f16\u7a0b\u7b14\u8bb0\u539f\u521b \u00b7 \u9996\u53d1 CSDN \u00b7 \u8f6c\u8f7d\u8bf7\u6ce8\u660e\u51fa\u5904<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u26a0\ufe0f \u514d\u8d23\u58f0\u660e&#xff1a;\u672c\u6587\u9879\u76ee\u4ec5\u4f9b\u6280\u672f\u5b66\u4e60\u53c2\u8003&#xff0c;\u4e25\u7981\u76f4\u63a5\u4f5c\u4e3a\u6bd5\u4e1a\u8bbe\u8ba1\u6216\u8bfe\u7a0b\u4f5c\u4e1a\u63d0\u4ea4\u3002\u8bf7\u7ed3\u5408\u81ea\u8eab\u9700\u6c42\u8fdb\u884c\u4e8c\u6b21\u5f00\u53d1\u4e0e\u521b\u65b0&#xff0c;\u5b66\u672f\u8bda\u4fe1\u4ece\u6211\u505a\u8d77 &#x1f642; \u8d2d\u7269\u8f66\u51fa\u95ee\u9898\u9876\u591a\u662f\u6570\u91cf\u7b97\u9519&#xff0c;\u8ba2\u5355\u51fa\u95ee\u9898\u5c31\u662f\u94b1\u548c\u5e93\u5b58\u5bf9\u4e0d\u4e0a&#xff0c;\u771f\u4f1a\u51fa\u4e8b\u3002<br \/>\n\u4ece\u7528\u6237\u70b9\u51fb\\&#8221;\u63d0\u4ea4\u8ba2\u5355\\&#8221;\u7684\u90a3\u4e00\u523b\u8d77&#xff0c;\u4e00\u8fde\u4e32\u7684\u52a8\u4f5c\u8981\u5728\u6781\u77ed\u65f6\u95f4\u5185\u5b8c\u6210&#xff1a;\u6821\u9a8c\u5e93\u5b58\u3001\u6263\u51cf\u5e93\u5b58\u3001\u751f\u6210\u8ba2\u5355\u53f7\u3001\u521b\u5efa\u8ba2\u5355\u4e3b\u8868\u3001\u521b\u5efa\u8ba2\u5355\u660e\u7ec6\u8868\u3001\u6e05\u7a7a\u8d2d\u7269\u8f66\u3001\u8df3\u652f\u4ed8\u9875\u3002<br \/>\n\u4e2d\u95f4\u4efb<\/p>\n","protected":false},"author":2,"featured_media":119028,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[11820,13401,13538,13537,1520,5473],"topic":[],"class_list":["post-119029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-atomgit","tag-myd","tag-13538","tag-13537","tag-1520","tag-5473"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/119029.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u26a0\ufe0f \u514d\u8d23\u58f0\u660e&#xff1a;\u672c\u6587\u9879\u76ee\u4ec5\u4f9b\u6280\u672f\u5b66\u4e60\u53c2\u8003&#xff0c;\u4e25\u7981\u76f4\u63a5\u4f5c\u4e3a\u6bd5\u4e1a\u8bbe\u8ba1\u6216\u8bfe\u7a0b\u4f5c\u4e1a\u63d0\u4ea4\u3002\u8bf7\u7ed3\u5408\u81ea\u8eab\u9700\u6c42\u8fdb\u884c\u4e8c\u6b21\u5f00\u53d1\u4e0e\u521b\u65b0&#xff0c;\u5b66\u672f\u8bda\u4fe1\u4ece\u6211\u505a\u8d77 &#x1f642; \u8d2d\u7269\u8f66\u51fa\u95ee\u9898\u9876\u591a\u662f\u6570\u91cf\u7b97\u9519&#xff0c;\u8ba2\u5355\u51fa\u95ee\u9898\u5c31\u662f\u94b1\u548c\u5e93\u5b58\u5bf9\u4e0d\u4e0a&#xff0c;\u771f\u4f1a\u51fa\u4e8b\u3002 \u4ece\u7528\u6237\u70b9\u51fb&quot;\u63d0\u4ea4\u8ba2\u5355&quot;\u7684\u90a3\u4e00\u523b\u8d77&#xff0c;\u4e00\u8fde\u4e32\u7684\u52a8\u4f5c\u8981\u5728\u6781\u77ed\u65f6\u95f4\u5185\u5b8c\u6210&#xff1a;\u6821\u9a8c\u5e93\u5b58\u3001\u6263\u51cf\u5e93\u5b58\u3001\u751f\u6210\u8ba2\u5355\u53f7\u3001\u521b\u5efa\u8ba2\u5355\u4e3b\u8868\u3001\u521b\u5efa\u8ba2\u5355\u660e\u7ec6\u8868\u3001\u6e05\u7a7a\u8d2d\u7269\u8f66\u3001\u8df3\u652f\u4ed8\u9875\u3002 \u4e2d\u95f4\u4efb\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/119029.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-28T11:25:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261028112458-6ae1db8af37a1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/119029.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/119029.html\",\"name\":\"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-10-28T11:25:00+00:00\",\"dateModified\":\"2026-10-28T11:25:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/119029.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/119029.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/119029.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/119029.html","og_locale":"zh_CN","og_type":"article","og_title":"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u26a0\ufe0f \u514d\u8d23\u58f0\u660e&#xff1a;\u672c\u6587\u9879\u76ee\u4ec5\u4f9b\u6280\u672f\u5b66\u4e60\u53c2\u8003&#xff0c;\u4e25\u7981\u76f4\u63a5\u4f5c\u4e3a\u6bd5\u4e1a\u8bbe\u8ba1\u6216\u8bfe\u7a0b\u4f5c\u4e1a\u63d0\u4ea4\u3002\u8bf7\u7ed3\u5408\u81ea\u8eab\u9700\u6c42\u8fdb\u884c\u4e8c\u6b21\u5f00\u53d1\u4e0e\u521b\u65b0&#xff0c;\u5b66\u672f\u8bda\u4fe1\u4ece\u6211\u505a\u8d77 &#x1f642; \u8d2d\u7269\u8f66\u51fa\u95ee\u9898\u9876\u591a\u662f\u6570\u91cf\u7b97\u9519&#xff0c;\u8ba2\u5355\u51fa\u95ee\u9898\u5c31\u662f\u94b1\u548c\u5e93\u5b58\u5bf9\u4e0d\u4e0a&#xff0c;\u771f\u4f1a\u51fa\u4e8b\u3002 \u4ece\u7528\u6237\u70b9\u51fb\"\u63d0\u4ea4\u8ba2\u5355\"\u7684\u90a3\u4e00\u523b\u8d77&#xff0c;\u4e00\u8fde\u4e32\u7684\u52a8\u4f5c\u8981\u5728\u6781\u77ed\u65f6\u95f4\u5185\u5b8c\u6210&#xff1a;\u6821\u9a8c\u5e93\u5b58\u3001\u6263\u51cf\u5e93\u5b58\u3001\u751f\u6210\u8ba2\u5355\u53f7\u3001\u521b\u5efa\u8ba2\u5355\u4e3b\u8868\u3001\u521b\u5efa\u8ba2\u5355\u660e\u7ec6\u8868\u3001\u6e05\u7a7a\u8d2d\u7269\u8f66\u3001\u8df3\u652f\u4ed8\u9875\u3002 \u4e2d\u95f4\u4efb","og_url":"https:\/\/www.wsisp.com\/helps\/119029.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-10-28T11:25:00+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/10\/20261028112458-6ae1db8af37a1.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/119029.html","url":"https:\/\/www.wsisp.com\/helps\/119029.html","name":"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-10-28T11:25:00+00:00","dateModified":"2026-10-28T11:25:00+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/119029.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/119029.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/119029.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Flask\u8ba2\u5355\u7cfb\u7edf\u5b8c\u6574\u5b9e\u73b0\uff5c\u4e8b\u52a1\u5904\u7406+\u72b6\u6001\u6d41\u8f6c+\u9632\u8d85\u5356\uff08\u9644\u6e90\u7801\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/119029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=119029"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/119029\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/119028"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=119029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=119029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=119029"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=119029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}