didong
/
owl-admin


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464
							<!DOCTYPE html><html><head>
      <title>index</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1.0">
      
      <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.16.11/dist/katex.min.css">
      
      
      
      
      
      <style>
      pre{font-family:Menlo,Monaco,Consolas,'Courier New',monospace;direction:ltr;text-align:left;white-space:pre;word-spacing:normal;word-break:normal;padding:1em;margin:.5em 0;overflow:auto;line-height:1.5;tab-size:4;hyphens:none;color:#555;background-color:#f0f0f0!important;border:#d6d6d6;border-radius:3px}pre[class*=language-]{padding:1em}code[class*=language-] .token.cdata,code[class*=language-] .token.comment,code[class*=language-] .token.doctype,code[class*=language-] .token.prolog,pre[class*=language-] .token.cdata,pre[class*=language-] .token.comment,pre[class*=language-] .token.doctype,pre[class*=language-] .token.prolog{color:#998;font-style:italic}code[class*=language-] .token.punctuation,pre[class*=language-] .token.punctuation{color:#920b2d}code[class*=language-] .namespace,pre[class*=language-] .namespace{opacity:.7}code[class*=language-] .token.property,pre[class*=language-] .token.property{font-weight:700;color:#333}code[class*=language-] .token.boolean,code[class*=language-] .token.function-name,code[class*=language-] .token.number,pre[class*=language-] .token.boolean,pre[class*=language-] .token.function-name,pre[class*=language-] .token.number{color:#d14}code[class*=language-] .token.tag,pre[class*=language-] .token.tag{color:#d14}code[class*=language-] .token.symbol,pre[class*=language-] .token.symbol{color:#990073}code[class*=language-] .token.selector,pre[class*=language-] .token.selector{color:teal}code[class*=language-] .token.attr-name,pre[class*=language-] .token.attr-name{color:#458;font-weight:700}code[class*=language-] .token.string,pre[class*=language-] .token.string{color:#d14}code[class*=language-] .token.char,pre[class*=language-] .token.char{color:#606aa1}code[class*=language-] .token.url,pre[class*=language-] .token.url{color:#888}code[class*=language-] .token.atrule,code[class*=language-] .token.attr-value,code[class*=language-] .token.keyword,pre[class*=language-] .token.atrule,pre[class*=language-] .token.attr-value,pre[class*=language-] .token.keyword{color:#222;font-weight:700}code[class*=language-] .token.function,pre[class*=language-] .token.function{color:#900}code[class*=language-] .token.class-name,pre[class*=language-] .token.class-name{text-decoration:underline;color:#606aa1}code[class*=language-] .token.variable,pre[class*=language-] .token.variable{color:teal}code[class*=language-] .token.bold,code[class*=language-] .token.important,pre[class*=language-] .token.bold,pre[class*=language-] .token.important{font-weight:700}code[class*=language-] .token.italic,pre[class*=language-] .token.italic{font-style:italic}code[class*=language-] .token.entity,pre[class*=language-] .token.entity{cursor:help}pre[data-line]{position:relative;padding:1em 0 1em 3em}pre[data-line] .line-highlight-wrapper{position:absolute;top:0;left:0;background-color:transparent;display:block;width:100%}pre[data-line] .line-highlight{position:absolute;left:0;right:0;padding:inherit 0;margin-top:1em;background:hsla(24,20%,50%,.08);background:linear-gradient(to right,hsla(24,20%,50%,.1) 70%,hsla(24,20%,50%,0));pointer-events:none;line-height:inherit;white-space:pre}pre[data-line] .line-highlight:before,pre[data-line] .line-highlight[data-end]:after{content:attr(data-start);position:absolute;top:.4em;left:.6em;min-width:1em;padding:0 .5em;background-color:hsla(24,20%,50%,.4);color:#f4f1ef;font:bold 65%/1.5 sans-serif;text-align:center;vertical-align:.3em;border-radius:999px;text-shadow:none;box-shadow:0 1px #fff}pre[data-line] .line-highlight[data-end]:after{content:attr(data-end);top:auto;bottom:.4em}html body{font-family:'Helvetica Neue',Helvetica,'Segoe UI',Arial,freesans,sans-serif;font-size:16px;line-height:1.6;color:#555;background-color:#fff;overflow:initial;box-sizing:border-box;word-wrap:break-word}html body>:first-child{margin-top:0}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{line-height:1.2;margin-top:1em;margin-bottom:16px;color:#030303}html body h1{font-size:2.25em;font-weight:300;padding-bottom:.3em}html body h2{font-size:1.75em;font-weight:400;padding-bottom:.3em}html body h3{font-size:1.5em;font-weight:500}html body h4{font-size:1.25em;font-weight:600}html body h5{font-size:1.1em;font-weight:600}html body h6{font-size:1em;font-weight:600}html body h1,html body h2,html body h3,html body h4,html body h5{font-weight:600}html body h5{font-size:1em}html body h6{color:#7e7e7e}html body strong{color:#030303}html body del{color:#7e7e7e}html body a:not([href]){color:inherit;text-decoration:none}html body a{color:#08c;text-decoration:none}html body a:hover{color:#00a3f5;text-decoration:none}html body img{max-width:100%}html body>p{margin-top:0;margin-bottom:16px;word-wrap:break-word}html body>ol,html body>ul{margin-bottom:16px}html body ol,html body ul{padding-left:2em}html body ol.no-list,html body ul.no-list{padding:0;list-style-type:none}html body ol ol,html body ol ul,html body ul ol,html body ul ul{margin-top:0;margin-bottom:0}html body li{margin-bottom:0}html body li.task-list-item{list-style:none}html body li>p{margin-top:0;margin-bottom:0}html body .task-list-item-checkbox{margin:0 .2em .25em -1.8em;vertical-align:middle}html body .task-list-item-checkbox:hover{cursor:pointer}html body blockquote{margin:16px 0;font-size:inherit;padding:0 15px;color:#7e7e7e;background-color:#f0f0f0;border-left:4px solid #d6d6d6}html body blockquote>:first-child{margin-top:0}html body blockquote>:last-child{margin-bottom:0}html body hr{height:4px;margin:32px 0;background-color:#d6d6d6;border:0 none}html body table{margin:10px 0 15px 0;border-collapse:collapse;border-spacing:0;display:block;width:100%;overflow:auto;word-break:normal;word-break:keep-all}html body table th{font-weight:700;color:#030303}html body table td,html body table th{border:1px solid #d6d6d6;padding:6px 13px}html body dl{padding:0}html body dl dt{padding:0;margin-top:16px;font-size:1em;font-style:italic;font-weight:700}html body dl dd{padding:0 16px;margin-bottom:16px}html body code{font-family:Menlo,Monaco,Consolas,'Courier New',monospace;font-size:.85em;color:#030303;background-color:#f0f0f0;border-radius:3px;padding:.2em 0}html body code::after,html body code::before{letter-spacing:-.2em;content:'\00a0'}html body pre>code{padding:0;margin:0;word-break:normal;white-space:pre;background:0 0;border:0}html body .highlight{margin-bottom:16px}html body .highlight pre,html body pre{padding:1em;overflow:auto;line-height:1.45;border:#d6d6d6;border-radius:3px}html body .highlight pre{margin-bottom:0;word-break:normal}html body pre code,html body pre tt{display:inline;max-width:initial;padding:0;margin:0;overflow:initial;line-height:inherit;word-wrap:normal;background-color:transparent;border:0}html body pre code:after,html body pre code:before,html body pre tt:after,html body pre tt:before{content:normal}html body blockquote,html body dl,html body ol,html body p,html body pre,html body ul{margin-top:0;margin-bottom:16px}html body kbd{color:#030303;border:1px solid #d6d6d6;border-bottom:2px solid #c7c7c7;padding:2px 4px;background-color:#f0f0f0;border-radius:3px}@media print{html body{background-color:#fff}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{color:#030303;page-break-after:avoid}html body blockquote{color:#7e7e7e}html body pre{page-break-inside:avoid}html body table{display:table}html body img{display:block;max-width:100%;max-height:100%}html body code,html body pre{word-wrap:break-word;white-space:pre}}.markdown-preview{width:100%;height:100%;box-sizing:border-box}.markdown-preview ul{list-style:disc}.markdown-preview ul ul{list-style:circle}.markdown-preview ul ul ul{list-style:square}.markdown-preview ol{list-style:decimal}.markdown-preview ol ol,.markdown-preview ul ol{list-style-type:lower-roman}.markdown-preview ol ol ol,.markdown-preview ol ul ol,.markdown-preview ul ol ol,.markdown-preview ul ul ol{list-style-type:lower-alpha}.markdown-preview .newpage,.markdown-preview .pagebreak{page-break-before:always}.markdown-preview pre.line-numbers{position:relative;padding-left:3.8em;counter-reset:linenumber}.markdown-preview pre.line-numbers>code{position:relative}.markdown-preview pre.line-numbers .line-numbers-rows{position:absolute;pointer-events:none;top:1em;font-size:100%;left:0;width:3em;letter-spacing:-1px;border-right:1px solid #999;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none}.markdown-preview pre.line-numbers .line-numbers-rows>span{pointer-events:none;display:block;counter-increment:linenumber}.markdown-preview pre.line-numbers .line-numbers-rows>span:before{content:counter(linenumber);color:#999;display:block;padding-right:.8em;text-align:right}.markdown-preview .mathjax-exps .MathJax_Display{text-align:center!important}.markdown-preview:not([data-for=preview]) .code-chunk .code-chunk-btn-group{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .status{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .output-div{margin-bottom:16px}.markdown-preview .md-toc{padding:0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link div,.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}.markdown-preview .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}.scrollbar-style::-webkit-scrollbar{width:8px}.scrollbar-style::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}.scrollbar-style::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode]){position:relative;width:100%;height:100%;top:0;left:0;margin:0;padding:0;overflow:auto}html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{position:relative;top:0;min-height:100vh}@media screen and (min-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em calc(50% - 457px + 2em)}}@media screen and (max-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{font-size:14px!important;padding:1em}}@media print{html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{display:none}}html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{position:fixed;bottom:8px;left:8px;font-size:28px;cursor:pointer;color:inherit;z-index:99;width:32px;text-align:center;opacity:.4}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] #sidebar-toc-btn{opacity:1}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc{position:fixed;top:0;left:0;width:300px;height:100%;padding:32px 0 48px 0;font-size:14px;box-shadow:0 0 4px rgba(150,150,150,.33);box-sizing:border-box;overflow:auto;background-color:inherit}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar{width:8px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc a{text-decoration:none}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc{padding:0 16px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link div,html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{left:300px;width:calc(100% - 300px);padding:2em calc(50% - 457px - 300px / 2);margin:0;box-sizing:border-box}@media screen and (max-width:1274px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{width:100%}}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .markdown-preview{left:50%;transform:translateX(-50%)}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .md-sidebar-toc{display:none}
/* Please visit the URL below for more information: */
/*   https://shd101wyy.github.io/markdown-preview-enhanced/#/customize-css */

      </style>
      <!-- The content below will be included at the end of the <head> element. --><script type="text/javascript">
  document.addEventListener("DOMContentLoaded", function () {
    // your code here
  });
</script></head><body for="html-export">
    
    
      <div class="crossnote markdown-preview  ">
      
<h2 id="系统架构">系统架构 </h2>
<h3 id="技术选型">技术选型 </h3>
<ul>
<li>php8.3</li>
<li>mysql8.0</li>
<li>nginx</li>
<li>redis</li>
<li>rabbitmq</li>
<li>uniapp(vue3)</li>
</ul>
<h3 id="一-快速后台开发解决方案">一、快速后台开发解决方案 </h3>
<p></p><h4 id="1-快速开发框架选型">1. 快速开发框架选型 </h4>
<ul>
<li>框架名称：dcat-admin</li>
<li>官方资料：
<ul>
<li>官网：<a href="https://github.com/jqhph/dcat-admin">https://github.com/jqhph/dcat-admin</a></li>
<li>文档：<a href="https://learnku.com/docs/dcat-admin/2.x">https://learnku.com/docs/dcat-admin/2.x</a></li>
</ul>
</li>
<li>选型原因：
<ul>
<li>基于laravel开发，架构优秀</li>
<li>文档详细，上手快</li>
<li>功能齐全，可扩展可定制能力强，二次开发成本低</li>
<li>laravel文档：<a href="https://learnku.com/docs/laravel/9.x/installation/12200#1dabc3">https://learnku.com/docs/laravel/9.x/installation/12200#1dabc3</a></li>
</ul>
</li>
</ul>
<h4 id="2-安装配置步骤">2. 安装配置步骤 </h4>
<ol>
<li>安装bt面板等继承环境
<ul>
<li>安装php8.1</li>
<li>安装composer2.6.6</li>
<li>配置php扩展和禁用函数</li>
<li>安装nginx</li>
<li>安装frpc</li>
<li>安装redis</li>
<li>安装mysql 8.0</li>
</ul>
</li>
<li>安装配置laravel，熟悉laravel框架</li>
<li>安装dcat-admin: <a href="https://learnku.com/docs/dcat-admin/2.x/install/8081#fa405f">https://learnku.com/docs/dcat-admin/2.x/install/8081#fa405f</a></li>
</ol>
<h4 id="3-快速开发后台管理系统">3. 快速开发后台管理系统 </h4>
<ol>
<li>数据库完成评审工作后，通过scaffold生成基础模块CRUD代码</li>
<li>通过scaffold生成基础模块CRUD代码</li>
</ol>
<ul>
<li><a href="https://learnku.com/docs/dcat-admin/2.x/basic-use/8140#8b8ca1">https://learnku.com/docs/dcat-admin/2.x/basic-use/8140#8b8ca1</a></li>
</ul>
<ol start="3">
<li>手动增加菜单</li>
<li>访问查看基础效果</li>
</ol>
<h4 id="4-ai-prompt提示词技巧">4. AI prompt提示词技巧 </h4>
<h5 id="41-调优管理界面">4.1 调优管理界面 </h5>
<p>打开生成的模块ctroller或service文件，通过AI快速调优管理界面，prompt举例：</p>
<pre data-role="codeBlock" data-info="" class="language-text"><code>请修改：
服务封面 -&gt; 图片
所属分类 -&gt; 下拉单选 分类列表
服务价格、原价、物料费 -&gt; 金额，单位：元
销量 -&gt; 数字，单位：单
服务时长 -&gt; 数字，单位：分
分佣比例 -&gt; 数字，单位：%
加钟服务、支持到店、支持上门 -&gt; 开关按钮
排序 -&gt; 数字
项目介绍、禁忌说明、下单须知 -&gt; 富文本编辑
其他列，隐藏

列表操作列，增加:
1. “取消订单”按钮，并参照以下逻辑实现handler：
这里面请复制你设计好的那个接口的后台逻辑描述
2. “删除”按钮，并参照以下逻辑实现handler：
这里面请复制你设计好的那个接口的后台逻辑描述
</code></pre><h5 id="42-给技巧起个名字">4.2 给技巧起个名字 </h5>
<blockquote>
<p>待补充，研发过程中再补充，新的AI prompt提示词 技巧</p>
</blockquote>
<p></p>
<h3 id="二-工具类库">二、工具类库 </h3>
<p></p><blockquote>
<p>以下工具类库，默认基于laravel框架</p>
</blockquote>
<blockquote>
<p>开始开发前，每个项目参与者都必须对laravel、dcat中的一些模块或概念有个基本的认识。否则将无法有效提供AI提示词，则无法加快研发效率。 要求每个人在业余时间对官方文档提供的每一个功能点，做一个开发和测试，这样建立基本的认识。</p>
</blockquote>
<h4 id="1-事务处理">1. 事务处理 </h4>
<h5 id="场景说明">场景说明 </h5>
<ul>
<li>
<p><strong>串行化 (SERIALIZABLE)</strong>：适用于需要严格事务隔离的场景，例如银行转账，确保事务完全隔离，避免所有并发问题，但可能会影响性能。</p>
</li>
<li>
<p><strong>可重复读 (REPEATABLE READ)</strong>：适用于需要保证在同一事务中多次读取同一数据的一致性的场景，例如库存查询和减少操作，避免在事务过程中数据被其他事务修改。</p>
</li>
<li>
<p><strong>读已提交 (READ COMMITTED)</strong>：适用于大多数需要避免脏读的场景，每次读取都能看到其他事务的最新提交结果，但可能会出现不可重复读和幻读。</p>
</li>
<li>
<p><strong>读未提交 (READ UNCOMMITTED)</strong>：适用于读操作对数据一致性要求不高的场景，允许读取到其他事务未提交的数据，可能会导致脏读、不可重复读和幻读。</p>
</li>
</ul>
<h5 id="用法举例">用法举例 </h5>
<pre data-role="codeBlock" data-info="php" class="language-php php"><code><span class="token comment">// 串行化 (SERIALIZABLE) - 最严格的隔离级别，完全隔离，事务串行执行</span>
<span class="token keyword keyword-use">use</span> <span class="token package">Illuminate<span class="token punctuation">\</span>Support<span class="token punctuation">\</span>Facades<span class="token punctuation">\</span>DB</span><span class="token punctuation">;</span>

<span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token comment">// 操作1：读取用户A的当前余额</span>
    <span class="token variable">$balanceA</span> <span class="token operator">=</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">where</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'user_id'</span><span class="token punctuation">,</span> <span class="token variable">$userIdA</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">value</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'balance'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

    <span class="token comment">// 操作2：减少用户A的余额</span>
    <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">where</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'user_id'</span><span class="token punctuation">,</span> <span class="token variable">$userIdA</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">decrement</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'balance'</span><span class="token punctuation">,</span> <span class="token variable">$amount</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

    <span class="token comment">// 操作3：增加用户B的余额</span>
    <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">where</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'user_id'</span><span class="token punctuation">,</span> <span class="token variable">$userIdB</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">increment</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'balance'</span><span class="token punctuation">,</span> <span class="token variable">$amount</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_SERIALIZABLE</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
</code></pre><pre data-role="codeBlock" data-info="php" class="language-php php"><code><span class="token comment">// 可重复读 (REPEATABLE READ) - 保证事务中每次读取结果都相同，避免不可重复读和脏读</span>
<span class="token keyword keyword-use">use</span> <span class="token package">Illuminate<span class="token punctuation">\</span>Support<span class="token punctuation">\</span>Facades<span class="token punctuation">\</span>DB</span><span class="token punctuation">;</span>

<span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
   
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_REPEATABLE_READ</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
</code></pre><pre data-role="codeBlock" data-info="php" class="language-php php"><code><span class="token comment">// 读已提交 (READ COMMITTED) - 每次读取只能看到其他事务已经提交的数据，避免脏读</span>
<span class="token keyword keyword-use">use</span> <span class="token package">Illuminate<span class="token punctuation">\</span>Support<span class="token punctuation">\</span>Facades<span class="token punctuation">\</span>DB</span><span class="token punctuation">;</span>

<span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_READ_COMMITTED</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
</code></pre><pre data-role="codeBlock" data-info="php" class="language-php php"><code><span class="token comment">// 读未提交 (READ UNCOMMITTED) - 最宽松的隔离级别，可能会读取到其他事务未提交的数据（脏读）</span>
<span class="token keyword keyword-use">use</span> <span class="token package">Illuminate<span class="token punctuation">\</span>Support<span class="token punctuation">\</span>Facades<span class="token punctuation">\</span>DB</span><span class="token punctuation">;</span>

<span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
  
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_READ_UNCOMMITTED</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
</code></pre><h5 id="事务嵌套">事务嵌套 </h5>
<p>在 Laravel 中，如果你在一个 DB::transaction 回调中调用另一个也使用 DB::transaction 的方法，将会出现以下情况：</p>
<pre class="language-text">嵌套事务：Laravel 支持嵌套事务。当你在事务中调用另一个事务时，Laravel 会使用保存点（Savepoints）来处理嵌套的事务。保存点允许你在事务中设置一个点，之后可以回滚到这个点，而不影响事务中之前的操作。

保存点的创建：对于每个嵌套的事务，Laravel 会创建一个保存点。如果内部事务成功提交，保存点会被释放；如果内部事务失败并回滚，只有内部事务的更改会被回滚到保存点，外部事务的其他操作不受影响。

事务的回滚：如果内部事务中抛出异常，整个内部事务会被回滚到最近的保存点。如果外部事务中抛出异常，整个外部事务（包括所有内部事务）会被回滚。
</pre>
<p>下面是一个示例，说明这种情况：</p>
<pre data-role="codeBlock" data-info="php" class="language-php php"><code><span class="token keyword keyword-use">use</span> <span class="token package">Illuminate<span class="token punctuation">\</span>Support<span class="token punctuation">\</span>Facades<span class="token punctuation">\</span>DB</span><span class="token punctuation">;</span>

<span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token comment">// 外部事务开始</span>

    <span class="token comment">// 一些数据库操作</span>
    <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">insert</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token operator">...</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

    <span class="token this keyword">$this</span><span class="token operator">-&gt;</span><span class="token function">nestedTransaction</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token comment">// 调用包含内部事务的方法</span>

    <span class="token comment">// 更多数据库操作</span>
    <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">update</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token operator">...</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_SERIALIZABLE</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token comment">// 包含内部事务的方法</span>
<span class="token keyword keyword-protected">protected</span> <span class="token keyword keyword-function">function</span> <span class="token function-definition function">nestedTransaction</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
<span class="token punctuation">{</span>
    <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">transaction</span><span class="token punctuation">(</span><span class="token keyword keyword-function">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
        <span class="token comment">// 内部事务开始</span>

        <span class="token comment">// 一些数据库操作</span>
        <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">insert</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token operator">...</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

        <span class="token comment">// 假设这里发生了错误，内部事务会回滚</span>
        <span class="token keyword keyword-throw">throw</span> <span class="token keyword keyword-new">new</span> <span class="token class-name">Exception</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'Something went wrong!'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

        <span class="token comment">// 更多数据库操作，如果内部事务成功，这些操作会执行</span>
        <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token function">table</span><span class="token punctuation">(</span><span class="token string single-quoted-string">'accounts'</span><span class="token punctuation">)</span><span class="token operator">-&gt;</span><span class="token function">update</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token operator">...</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token scope">DB<span class="token punctuation">::</span></span><span class="token constant">TRANSACTION_SERIALIZABLE</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
</code></pre><blockquote>
<p>在这个例子中，如果 nestedTransaction 方法中的内部事务因为抛出异常而失败，只有内部事务中的操作会被回滚。外部事务中的操作（在调用 nestedTransaction 之前和之后的操作）不会受到影响，除非外部事务本身抛出异常。</p>
</blockquote>
<h4 id="2-队列处理">2. 队列处理 </h4>
<p><a href="https://learnku.com/docs/laravel/9.x/queues/12236#0796f7">参考laravel官方文档</a></p>
<h4 id="3-缓存处理">3. 缓存处理 </h4>
<p><a href="https://learnku.com/docs/laravel/9.x/redis/12250#e11144">参考laravel官方文档</a></p>
<h4 id="4-日志记录">4. 日志记录 </h4>
<p><a href="https://learnku.com/docs/laravel/9.x/logging/12237#0796f7">参考laravel官方文档</a></p>
<h4 id="5-其他请参考官方文档">5. 其他请参考官方文档 </h4>
<p><a href="https://learnku.com/docs/laravel/9.x">laravel官方文档</a></p>
<p><a href="https://learnku.com/docs/dcat-admin/2.x">dcat文档</a></p>
<p></p>
<h3 id="websocket解决方案">WebSocket解决方案 </h3>
<p></p><blockquote>
<p>WebSocket解决方案</p>
</blockquote>
<p></p>
<h3 id="swaggerapi文档解决方案">SwaggerAPI文档解决方案 </h3>
<p></p><blockquote>
<p>SwaggerAPI文档解决方案</p>
</blockquote>
<p></p>
<h3 id="多级配置参数设置解决方案">多级配置参数设置解决方案 </h3>
<p></p><blockquote>
<p>多级配置参数设置解决方案</p>
</blockquote>
<p></p>
<h3 id="统一支付汇付天下解决方案">统一支付（汇付天下）解决方案 </h3>
<p></p><blockquote>
<p>统一支付（汇付天下）解决方案</p>
</blockquote>
<p></p>
<h3 id="基于lbs的near算法解决方案">基于LBS的Near算法解决方案 </h3>
<p></p><blockquote>
<p>基于LBS的Near算法解决方案</p>
</blockquote>
<ul>
<li>方案一：使用redis geo 实现</li>
<li>方案二：使用mysql空间扩展，实现geohash与mysql索引结合，实现附近技师检索。</li>
<li>方案三：使用第三方地图API，实现附近技师检索。</li>
</ul>
<p></p>
<h3 id="技师抢单解决方案">技师抢单解决方案 </h3>
<p></p><blockquote>
<p>技师抢单解决方案</p>
</blockquote>
<p></p>
<h3 id="订单状态机解决方案">订单状态机解决方案 </h3>
<p></p><blockquote>
<p>订单状态机解决方案</p>
</blockquote>
<ul>
<li>方案一：使用laravel-state-machine实现</li>
<li>方案二：使用php-enum实现</li>
<li>方案三：使用数据库实现</li>
<li>方案四：使用laravel-activitylog实现</li>
</ul>
<p></p>
<h3 id="技师排班的解决方案技师排班的解决方案html"><a href="./%E6%8A%80%E5%B8%88%E6%8E%92%E7%8F%AD%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88.html">技师排班的解决方案</a> </h3>
<h3 id="saas多租户解决方案">SaaS多租户解决方案 </h3>
<p></p><blockquote>
<p>SaaS多租户解决方案</p>
</blockquote>
<ul>
<li>方案一：使用laravel-tenancy实现</li>
<li>方案二：使用database实现</li>
</ul>
<p></p>
<h3 id="告警监控解决方案">告警监控解决方案 </h3>
<p></p><blockquote>
<p>告警监控解决方案</p>
</blockquote>
<ul>
<li>方案一：使用laravel-monitor实现</li>
<li>方案二：使用laravel-health实现</li>
</ul>
<p></p>

      </div>
      <div class="md-sidebar-toc">
<div class="md-toc">
<details style="padding:0;;padding-left:0px;" open="">
        <summary class="md-toc-link-wrapper">
          <a href="#系统架构" class="md-toc-link"><p>系统架构</p>
</a>
          </summary>
        <div>
          <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#技术选型" class="md-toc-link">
            <p>技术选型</p>

          </a></div><details style="padding:0;;padding-left:24px;" open="">
        <summary class="md-toc-link-wrapper">
          <a href="#一-快速后台开发解决方案" class="md-toc-link"><p>一、快速后台开发解决方案</p>
</a>
          </summary>
        <div>
          <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#1-快速开发框架选型" class="md-toc-link">
            <ol>
<li>快速开发框架选型</li>
</ol>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#2-安装配置步骤" class="md-toc-link">
            <ol start="2">
<li>安装配置步骤</li>
</ol>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#3-快速开发后台管理系统" class="md-toc-link">
            <ol start="3">
<li>快速开发后台管理系统</li>
</ol>

          </a></div><details style="padding:0;;padding-left:24px;" open="">
        <summary class="md-toc-link-wrapper">
          <a href="#4-ai-prompt提示词技巧" class="md-toc-link"><ol start="4">
<li>AI prompt提示词技巧</li>
</ol>
</a>
          </summary>
        <div>
          <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#41-调优管理界面" class="md-toc-link">
            <p>4.1 调优管理界面</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#42-给技巧起个名字" class="md-toc-link">
            <p>4.2 给技巧起个名字</p>

          </a></div>
        </div>
      </details>
    
        </div>
      </details>
    <details style="padding:0;;padding-left:24px;" open="">
        <summary class="md-toc-link-wrapper">
          <a href="#二-工具类库" class="md-toc-link"><p>二、工具类库</p>
</a>
          </summary>
        <div>
          <details style="padding:0;;padding-left:24px;" open="">
        <summary class="md-toc-link-wrapper">
          <a href="#1-事务处理" class="md-toc-link"><ol>
<li>事务处理</li>
</ol>
</a>
          </summary>
        <div>
          <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#场景说明" class="md-toc-link">
            <p>场景说明</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#用法举例" class="md-toc-link">
            <p>用法举例</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#事务嵌套" class="md-toc-link">
            <p>事务嵌套</p>

          </a></div>
        </div>
      </details>
    <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#2-队列处理" class="md-toc-link">
            <ol start="2">
<li>队列处理</li>
</ol>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#3-缓存处理" class="md-toc-link">
            <ol start="3">
<li>缓存处理</li>
</ol>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#4-日志记录" class="md-toc-link">
            <ol start="4">
<li>日志记录</li>
</ol>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#5-其他请参考官方文档" class="md-toc-link">
            <ol start="5">
<li>其他请参考官方文档</li>
</ol>

          </a></div>
        </div>
      </details>
    <div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#websocket解决方案" class="md-toc-link">
            <p>WebSocket解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#swaggerapi文档解决方案" class="md-toc-link">
            <p>SwaggerAPI文档解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#多级配置参数设置解决方案" class="md-toc-link">
            <p>多级配置参数设置解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#统一支付汇付天下解决方案" class="md-toc-link">
            <p>统一支付（汇付天下）解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#基于lbs的near算法解决方案" class="md-toc-link">
            <p>基于LBS的Near算法解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#技师抢单解决方案" class="md-toc-link">
            <p>技师抢单解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#订单状态机解决方案" class="md-toc-link">
            <p>订单状态机解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#技师排班的解决方案技师排班的解决方案html" class="md-toc-link">
            </a><p><a href="#技师排班的解决方案技师排班的解决方案html" class="md-toc-link"></a><a href="./%E6%8A%80%E5%B8%88%E6%8E%92%E7%8F%AD%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88.html">技师排班的解决方案</a></p>

          </div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#saas多租户解决方案" class="md-toc-link">
            <p>SaaS多租户解决方案</p>

          </a></div><div class="md-toc-link-wrapper" style="padding:0;;display:list-item;list-style:square;margin-left:42px">
          <a href="#告警监控解决方案" class="md-toc-link">
            <p>告警监控解决方案</p>

          </a></div>
        </div>
      </details>
    
</div>
</div>
      <a id="sidebar-toc-btn">≡</a>
    
    
    
    
    
    
<script>
document.body.setAttribute('html-show-sidebar-toc', true)
var sidebarTOCBtn = document.getElementById('sidebar-toc-btn')
sidebarTOCBtn.addEventListener('click', function(event) {
  event.stopPropagation()
  if (document.body.hasAttribute('html-show-sidebar-toc')) {
    document.body.removeAttribute('html-show-sidebar-toc')
  } else {
    document.body.setAttribute('html-show-sidebar-toc', true)
  }
})
</script>
      
  
    </body></html>