`Laravel`版`小丑路人社区`改版中,与`Hyperf版小丑路人社区`数据互动,此版本改版中……尚未彻底完结!

Q:

thinkphp6:haswhere与withjoin共用时:1.会存在别人全局大写;2.getTable为数组

<p>think-orm2.0版本已经提了pull,看作者改不改了。</p><p>github地址:<a href="https://github.com/top-think/think-orm/pull/198">https://github.com/top-think/think-orm/pull/198</a></p><p><img src="/storage/ueditor/image/20201028/1603873715608400.png" title="1603873715608400.png" alt="QQ图片20201028162816.png"/></p><p>代码如下:</p><pre class="brush:php;toolbar:false"><pre style="background-color:#ffffff;color:#080808;font-family:&#39;JetBrains Mono&#39;;font-size:11.3pt;"><span style="color:#660000;background-color:#f7faff;">$list </span><span style="background-color:#f7faff;">= </span><span style="color:#000000;background-color:#f7faff;">user_infos</span><span style="background-color:#f7faff;">::</span><span style="color:#00627a;background-color:#f7faff;font-style:italic;">getInstance</span><span style="background-color:#f7faff;">()<br/></span><span style="background-color:#f7faff;"> &nbsp; &nbsp;-&gt;</span><span style="color:#00627a;background-color:#f7faff;">alias</span><span style="background-color:#f7faff;">(</span><span style="color:#067d17;background-color:#f7faff;">&#39;user_infos&#39;</span><span style="background-color:#f7faff;">)<br/></span><span style="background-color:#f7faff;"> &nbsp; &nbsp;-&gt;</span><span style="color:#00627a;background-color:#f7faff;">withJoin</span><span style="background-color:#f7faff;">([<br/></span><span style="background-color:#f7faff;"> &nbsp; &nbsp; &nbsp; &nbsp;</span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;">// </span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;">外键表 用户资料表 显示的字段<br/></span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;"> &nbsp; &nbsp; &nbsp; &nbsp;</span><span style="color:#067d17;background-color:#f7faff;">&#39;orderTaking&#39;<br/></span><span style="color:#067d17;background-color:#f7faff;"> &nbsp; &nbsp;</span><span style="background-color:#f7faff;">], </span><span style="color:#067d17;background-color:#f7faff;">&#39;left&#39;</span><span style="background-color:#f7faff;">)<br/></span><span style="background-color:#f7faff;"> &nbsp; &nbsp;-&gt;</span><span style="color:#00627a;background-color:#f7faff;">where</span><span style="background-color:#f7faff;">(</span><span style="color:#067d17;background-color:#f7faff;">&#39;user_infos.wedding_role&#39;</span><span style="background-color:#f7faff;">, </span><span style="color:#660000;background-color:#f7faff;">$params</span><span style="background-color:#f7faff;">[</span><span style="color:#067d17;background-color:#f7faff;">&#39;wedding_role&#39;</span><span style="background-color:#f7faff;">]) </span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;"><br/></span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;"> &nbsp; &nbsp;</span><span style="background-color:#f7faff;">-&gt;</span><span style="color:#00627a;background-color:#f7faff;">hasWhere</span><span style="background-color:#f7faff;">(</span><span style="color:#067d17;background-color:#f7faff;">&#39;user&#39;</span><span style="background-color:#f7faff;">, [</span><span style="color:#067d17;background-color:#f7faff;">&#39;log_off&#39; </span><span style="background-color:#f7faff;">=&gt; </span><span style="color:#1750eb;background-color:#f7faff;">0</span><span style="background-color:#f7faff;">])<br/></span><span style="background-color:#f7faff;"> &nbsp; &nbsp;-&gt;</span><span style="color:#00627a;background-color:#f7faff;">order</span><span style="background-color:#f7faff;">(</span><span style="color:#067d17;background-color:#f7faff;">&#39;user_infos.user_integral&#39;</span><span style="background-color:#f7faff;">, </span><span style="color:#067d17;background-color:#f7faff;">&#39;DESC&#39;</span><span style="background-color:#f7faff;">) </span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;"><br/></span><span style="color:#8c8c8c;background-color:#f7faff;font-style:italic;font-family:&#39;宋体&#39;;"> &nbsp; &nbsp;</span><span style="background-color:#f7faff;">-&gt;</span><span style="color:#00627a;background-color:#f7faff;">paginate</span><span style="background-color:#f7faff;">(</span><span style="color:#1750eb;background-color:#f7faff;">10</span><span style="background-color:#f7faff;">);</span></pre></pre><p>报错如下:</p><pre class="brush:php;toolbar:false">#0&nbsp;[2]ErrorException&nbsp;in&nbsp;BaseQuery.php&nbsp;line&nbsp;803Illegal&nbsp;offset&nbsp;type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/&nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;alias($alias)&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(is_array($alias))&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;options[&#39;alias&#39;]&nbsp;=&nbsp;$alias;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$table&nbsp;=&nbsp;$this-&gt;getTable();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;改动前:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;options[&#39;alias&#39;][$table]&nbsp;=&nbsp;$alias;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;改动后&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(is_array($table)){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;options[&#39;alias&#39;]&nbsp;=&nbsp;$table;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;options[&#39;alias&#39;][$table]&nbsp;=&nbsp;$alias;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</pre><p><br/></p>
生活点滴
订阅

评论记录


评论/回复