php[周六代码分享]：返回调度人员…

PHP语言:<wbr></wbr>返回调度人员或者部门审批人数组

01<wbr></wbr><?php
03<wbr></wbr> // 返回调度人员或者部门审批人数组<wbr></wbr>
04<wbr></wbr> // @param <string> $method deptverify(部门审批)、despmanage(调度员)
05<wbr></wbr> // @return array
08<wbr></wbr>function<wbr></wbr>getvehiclemanager($method<wbr></wbr>=<wbr></wbr>'deptverify')<wbr></wbr>{
09<wbr></wbr><wbr></wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$uidarr</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">array</span>();<br><span style="color: rgb(248, 16, 176);">10<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">array</span>();<br><span style="color: rgb(160, 176, 192); font-style: italic;">11<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">if</span><span><wbr></wbr></span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$method</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">!=</span><span><wbr></wbr></span><span style="color: rgb(64, 112, 160);">'despmanage'</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">&amp;&amp;</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$method</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">!=</span><span><wbr></wbr></span><span style="color: rgb(64, 112, 160);">'deptverify'</span>)<span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">{</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">12<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">return</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">13<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">14<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(160, 176, 192); font-style: italic;">//找出后台权限表中有调度员权限的岗位</span><br><span style="color: rgb(248, 16, 176);">15<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(64, 112, 160);">"SELECT positionid FROM "</span><span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">table</span>(<span style="color: rgb(64, 112, 160);">'common_position_purview'</span>)<span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(64, 112, 160);">" WHERE module='vehicle' AND method='</span><span style="color: rgb(64, 112, 160);">$method</span><span style="color: rgb(64, 112, 160);">' AND val=1"</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">16<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$query</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">query</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span>);<br><span style="color: rgb(160, 176, 192); font-style: italic;">17<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$pids_array</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">array</span>();<span><wbr></wbr></span><span style="color: rgb(160, 176, 192); font-style: italic;">//有调度权限的职位id</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">18<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">while</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$row</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">fetch</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$query</span><span style="color: rgb(32, 32, 32);">)){</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">19<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$pids_array</span><span style="color: rgb(32, 32, 32);">[]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$row</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'positionid'</span><span style="color: rgb(32, 32, 32);">];</span><br><span style="color: rgb(248, 16, 176);">20<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">21<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$pids_str</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(76, 143, 47); font-weight: bold;">implode</span>(<span style="color: rgb(64, 112, 160);">','</span><span style="color: rgb(32, 32, 32);">,</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$pids_array</span>);<br><span style="color: rgb(160, 176, 192); font-style: italic;">22<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(64, 112, 160);">"SELECT username,uid,realname FROM "</span><span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">table</span>(<span style="color: rgb(64, 112, 160);">'common_member'</span>)<span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(64, 112, 160);">" WHERE positionid IN(</span><span style="color: rgb(64, 112, 160);">$pids_str</span><span style="color: rgb(64, 112, 160);">) AND status='0'"</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">23<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$query</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">query</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span>);<br><span style="color: rgb(160, 176, 192); font-style: italic;">24<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">while</span><span><wbr></wbr></span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$mrow</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">fetch</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$query</span>))<span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">{</span><br><span style="color: rgb(248, 16, 176);">25<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$uidarr</span><span style="color: rgb(32, 32, 32);">[]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$mrow</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'uid'</span><span style="color: rgb(32, 32, 32);">];</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">26<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$mrow</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'online'</span><span style="color: rgb(32, 32, 32);">]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">false</span>;<span><wbr></wbr></span><span style="color: rgb(160, 176, 192); font-style: italic;">//默认是下线</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">27<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(91, 54, 116); font-style: italic;">$mrow</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'uid'</span><span style="color: rgb(32, 32, 32);">]]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$mrow</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">28<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">29<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><br><span style="color: rgb(248, 16, 176);">30<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$uid_str</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(76, 143, 47); font-weight: bold;">implode</span>(<span style="color: rgb(64, 112, 160);">','</span><span style="color: rgb(32, 32, 32);">,</span><span style="color: rgb(91, 54, 116); font-style: italic;">$uidarr</span>);<br><span style="color: rgb(160, 176, 192); font-style: italic;">31<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(64, 112, 160);">"SELECT uid,invisible FROM "</span><span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">table</span>(<span style="color: rgb(64, 112, 160);">'common_session'</span>)<span style="color: rgb(32, 32, 32);">.</span><span style="color: rgb(64, 112, 160);">" WHERE FIND_IN_SET(uid,'</span><span style="color: rgb(64, 112, 160);">$uid_str</span><span style="color: rgb(64, 112, 160);">')"</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">32<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$query</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">query</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$sql</span>);<span><wbr></wbr></span><span style="color: rgb(160, 176, 192); font-style: italic;">//查询是否上线</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">33<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">while</span><span><wbr></wbr></span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$row</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">DB</span><span style="color: rgb(32, 32, 32);">::</span><span style="color: rgb(6, 40, 126); font-style: italic;">fetch</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$query</span>))<span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">{</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">34<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">if</span><span><wbr></wbr></span>(<span style="color: rgb(32, 32, 32);">!</span><span style="color: rgb(91, 54, 116); font-style: italic;">$row</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'invisible'</span><span style="color: rgb(32, 32, 32);">])</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">{</span><span><wbr></wbr></span><span style="color: rgb(160, 176, 192); font-style: italic;">//如果不是隐身的</span><br><span style="color: rgb(248, 16, 176);">35<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(91, 54, 116); font-style: italic;">$row</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'uid'</span><span style="color: rgb(32, 32, 32);">]][</span><span style="color: rgb(64, 112, 160);">'online'</span><span style="color: rgb(32, 32, 32);">]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">true</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">36<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">37<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">38<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(76, 143, 47); font-weight: bold;">rsort</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span>);<span><wbr></wbr></span><span style="color: rgb(160, 176, 192); font-style: italic;">//重排</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">39<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(160, 176, 192); font-style: italic;">//在线的排在前面 begin</span><br><span style="color: rgb(248, 16, 176);">40<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$onlineArray</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$notlineArray</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">array</span>();<br><span style="color: rgb(160, 176, 192); font-style: italic;">41<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">foreach</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">as</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$key</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=&gt;</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$value</span><span style="color: rgb(32, 32, 32);">){</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">42<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">if</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$value</span><span style="color: rgb(32, 32, 32);">[</span><span style="color: rgb(64, 112, 160);">'online'</span><span style="color: rgb(32, 32, 32);">]){</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">43<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$onlineArray</span><span style="color: rgb(32, 32, 32);">[]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$value</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">44<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><span style="color: rgb(0, 112, 32); font-weight: bold;">else</span><span style="color: rgb(32, 32, 32);">{</span><br><span style="color: rgb(248, 16, 176);">45<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$notlineArray</span><span style="color: rgb(32, 32, 32);">[]</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$value</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">46<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">47<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">}</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">48<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span><span><wbr></wbr></span><span style="color: rgb(32, 32, 32);">=</span><span><wbr></wbr></span><span style="color: rgb(76, 143, 47); font-weight: bold;">array_merge</span>(<span style="color: rgb(91, 54, 116); font-style: italic;">$onlineArray</span><span style="color: rgb(32, 32, 32);">,</span><span style="color: rgb(91, 54, 116); font-style: italic;">$notlineArray</span>);<br><span style="color: rgb(160, 176, 192); font-style: italic;">49<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(160, 176, 192); font-style: italic;">//在线的排在前面 end</span><br><span style="color: rgb(248, 16, 176);">50<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(0, 112, 32); font-weight: bold;">return</span><span><wbr></wbr></span><span style="color: rgb(91, 54, 116); font-style: italic;">$purvarr</span>;<br><span style="color: rgb(160, 176, 192); font-style: italic;">51<wbr></wbr></span><span style="color: rgb(32, 32, 32);">}</span><span style="color: rgb(160, 176, 192); font-style: italic;">//end function</span><br><span style="color: rgb(160, 176, 192); font-style: italic;">52<wbr></wbr></span><span style="color: rgb(16, 96, 160);">?&gt;</span></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>