/**
* 根据person.id查找
*/
public function findById($id)
{
$sql = "select person.id id, person.name name, person.state state, person.description description " . ",now.longitude now_lng, now.latitude now_lat, now.zoom now_zoom " . ", want.longitude want_lng, want.latitude want_lat, want.zoom want_zoom " . "from person left join point as now on person.now = now.id " . "left join point as want on person.want = want.id " . "where person.id = {$id}";
$mysql = new MysqlAccess();
$result = $mysql->getLine($sql);
return $result;
}
/**
* 根据楼盘id返回项目
*/
public function findPremisesById($id)
{
$sql = "select premises.id pid, premises.name name, point.longitude lng, " . " point.latitude lat, premises.description description, " . " project.name proname from premises" . " left join point on premises.point_id = point.id " . " left join project on project.id = premises.project_id where premises.id = {$id}";
$mysql = new MysqlAccess();
$result = $mysql->getLine($sql);
return $result;
}
/**
* 根据用户名查找
*/
public function findByUsername($uname)
{
$mysql = new MysqlAccess();
$sql = "select `username`, `password`, `last_login`, `last_ip` from admin where `username` = '{$uname}'";
$result = $mysql->getLine($sql);
return $result;
}
