alias( a )->join( br_esf_village_expand as&nbs..."/>
您好,登錄后才能下訂單哦!
代碼片段如下: $data = $villageDb->alias('a')->join('br_esf_village_expand as b on a.villageId=b.villageId', 'LEFT')->where($where)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $houseDb=D("House"); foreach($data as $key => $val){ $quyuname = ''; if ($val['fangAreaId']) { $quyuname = $areaDb->getAreaName($val['fangAreaId']); } $shangquanname = ''; if ($val['fangTradingId']) { $shangquanname = $areaDb->getShangName($val['fangTradingId']); } $data[$key]['quyuname'] = $quyuname; $data[$key]['shangquanname'] = $shangquanname; $data[$key]['ispublish']=$houseDb->ishouseCount($val['villageId']); $data[$key]['nopublish']=$houseDb->nohouseCount($val['villageId']); } $d=$this->multi_array_sort($data, 'ispublish'); //鍵值ispublish排序 $this->changename($fangareaId); //傳值 $this->assign('quyu', $quyu) //得到區(qū)域 ->assign('sqData', $this->changename($fangareaId)) //搜索賦值商圈 ->assign('data', $d); // 得到商圈 $this->display(); } //二維數(shù)組鍵值排序 function multi_array_sort($multi_array, $sort_key, $sort = SORT_DESC) { if (is_array($multi_array)) { foreach ($multi_array as $row_array) { if (is_array($row_array)) { $key_array[] = $row_array[$sort_key]; } else { return FALSE; } } } else { return FALSE; } array_multisort($key_array, $sort, $multi_array); return $multi_array; }
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。