/** * 获取用户有权的楼盘 * @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; }