代码片段如下:
$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'
);
$this
->changename(
$fangareaId
);
$this
->assign(
'quyu'
,
$quyu
)
->assign(
'sqData'
,
$this
->changename(
$fangareaId
))
->assign(
'data'
,
$d
);
$this
->display();
}
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
;
}