/**
* 获取用户有权的楼盘
* @param $user 用户数据
* @return array
*/
function biz_getProjects($user)
{
$sql = 'select projguid,projname from ' . tablename('project');
$projects = biz_getUserProject($user);
if (is_array($projects)) {
$sql .= ' where projguid in (\'' . implode("','", $projects) . '\')';
}
return pdo_fetchall($sql);
}
<?php
$_W['page']['title'] = '楼盘项目列表 - 楼盘项目';
$sql = 'select * from ' . tablename('project');
$condition = ' where 1=1 ';
$projects = biz_getUserProject($_W['user']);
if (is_array($projects)) {
$condition .= ' and projguid in (\'' . implode("','", $projects) . '\')';
}
$status = biz_getDictionary('projstatus');
$pars = array();
$keyword = trim($_GPC['keyword']);
if (!empty($keyword)) {
$condition = " AND `projname` LIKE :name";
$pars[':name'] = "%{$keyword}%";
}
$sql .= $condition;
$list = pdo_fetchall($sql, $pars);
$import_enable = $_W['isfounder'];
include template('project/display', TEMPLATE_INCLUDEPATH);
/**
* 获取用户有权的楼盘
* @param $user 用户数据
* @param $hasBuild 是否包含楼盘信息
* @return array
*/
function App_getProjects($user, $hasBuild = false)
{
$sql = 'select projguid,projname from ' . tablename('project');
$projects = biz_getUserProject($user);
if (is_array($projects)) {
$sql .= ' where projguid in (\'' . implode("','", $projects) . '\')';
}
$list = pdo_fetchall($sql);
if ($hasBuild) {
foreach ($list as &$item) {
$item['build'] = App_db_GetBuildInfo($item['projguid']);
}
unset($item);
}
return $list;
}
