房产中介小程序+weixinmao_house+2.8

<?php /** * 企业小程序模块小程序接口定义 * * @author w*w*w*.*e*f*w*w*w*.*c*o*m 易福源码网 * @url */ defined('IN_IA') or exit('Access Denied'); class Weixinmao_houseModuleWxapp extends WeModuleWxapp { public function GetSiteUrl() { global $_GPC, $_W; if($_W['attachurl']!=""){ $siteurl = $_W['attachurl']; }else{ $siteurl = $_W['siteroot'].'attachment/'; } return $siteurl; } public function doPageGetcity() { global $_GPC, $_W; $sql = 'SELECT * FROM ' . tablename('weixinmao_house_area') . ' WHERE `uniacid` = :uniacid ORDER BY `sort` DESC'; $arealist = pdo_fetchall($sql, array(':uniacid' => $_W['uniacid'])); return $this->result(0, 'success', $arealist); } public function doPageGetpubinit() { global $_GPC, $_W; $uid = $_GPC['uid']; $sql = 'SELECT * FROM ' . tablename('weixinmao_house_area') . ' WHERE `uniacid` = :uniacid ORDER BY `sort` DESC'; $arealist = pdo_fetchall($sql, array(':uniacid' => $_W['uniacid'])); $sql = 'SELECT id FROM ' . tablename('weixinmao_house_message') . ' WHERE `uniacid` = :uniacid AND `uid` =:uid'; $messageinfo = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'],':uid'=>$uid)); if($messageinfo['id']>0) { $ismaster = 1; }else{ $ismaster = 0; } //$money = 0.01; //$toplist = array(array('id'=>1,'money'=>0.01,'title'=>'0.01元/1天'),array('id'=>1,'money'=>0.02,'title'=>'0.02元/2天')); $sql = 'SELECT * FROM ' . tablename('weixinmao_house_toplist') . ' WHERE `uniacid` = :uniacid ORDER BY `sort` DESC'; $toplist = pdo_fetchall($sql, array(':uniacid' => $_W['uniacid'])); foreach($toplist as $k=>$v) { $toplist[$k]['title'] = $v['money'].'元/'.$v['days'].'天'; } $firsttop = array('id'=>0,title=>"不置顶直接发布",money=>0); array_unshift($toplist,$firsttop); $data = array('arealist'=>$arealist,'ismaster'=>$ismaster,'toplist'=>$toplist); return $this->result(0, 'success', $data); } public function doPageGetagentlist() { global $_GPC, $_W; //$siteurl = $this->GetSiteUrl(); $condition = ' WHERE `uniacid` = :uniacid '; $params = array(':uniacid' => $_W['uniacid']); if($_GPC['page']) $page = $_GPC['page']; else $page =1; $limit = ' LIMIT 0,'.$page*100; $sql = 'SELECT * FROM ' . tablename('weixinmao_house_agent') .$condition ; $list = pdo_fetchall($sql, $params); if($list){ foreach($list as $k=>$v) { $list[$k]['thumb'] = tomedia($v['thumb']); } } return $this->result(0, 'success', $list); } public function doPageGetagentdetail() { global $_GPC, $_W; //$siteurl = $this->GetSiteUrl(); $id = $_GPC['id']; $list = pdo_fetch("SELECT * FROM " . tablename('weixinmao_house_agent') ." WHERE uniacid=:uniacid AND id=".$id,array(":uniacid" => $_W['uniacid'])); $list['content'] = html_entity_decode($list['content']); $list['createtime'] = date('Y-m-d',$list['createtime']); $list['thumb'] = tomedia($list['thumb']); $condition = " WHERE tel=:tel AND uniacid=:uniacid "; $sql = 'SELECT * FROM ' . tablename('weixinmao_house_oldhouseinfo') . $condition ; $oldhouselist = pdo_fetchall($sql,array(":uniacid" => $_W['uniacid'],':tel'=>$list['tel'])); if($oldhouselist) { foreach($oldhouselist as $k=>$v) { $oldhouselist[$k]['thumb'] = tomedia($v['thumb']); $oldhouselist[$k]['money'] = $v['saleprice']; } } $data = array('list'=>$list,'oldhouselist'=>$oldhouselist,'lethouselist'=>$lethouselist); return $this->result(0, 'success', $data); } public function doPageGetagenthouse() { global $_GPC, $_W; // $siteurl = $this->GetSiteUrl(); $pid = $_GPC['pid']; $tel = $_GPC['tel']; $condition = " WHERE tel=:tel AND uniacid=:uniacid "; if($pid ==1) { $sql = 'SELECT * FROM ' . tablename('weixinmao_house_oldhouseinfo') . $condition ; }else{ $sql = 'SELECT * FROM ' . tablename('weixinmao_house_lethouseinfo') . $condition ; } $houselist = pdo_fetchall($sql,array(":uniacid" => $_W['uniacid'],':tel'=>$tel)); if($houselist) { foreach($houselist as $k=>$v) { $houselist[$k]['thumb'] = tomedia($v['thumb']); if($pid ==1) $houselist[$k]['money'] = $v['saleprice']; else $houselist[$k]['money'] = $v['money']; } } $data = array('houselist'=>$houselist); return $this->result(0, 'success', $data); } public function doPageGetsalelist() { global $_GPC, $_W; //$siteurl = $this->GetSiteUrl(); $condition = ' WHERE `uniacid` = :uniacid AND ischeck = 1 AND (toplistid =0 OR endtime < '.time().')'; $topcondition = ' WHERE `uniacid` = :uniacid AND ischeck = 1 AND toplistid>0 AND endtime > '.time(); $params = array(':uniacid' => $_W['uniacid']); if($_GPC['page']) $page = $_GPC['page']; else $page =1; $limit = ' LIMIT 0,'.$page*10; if ($_GPC['houseareaid']>0) { $condition .= ' AND `houseareaid` = :houseareaid'; $topcondition .= ' AND `houseareaid` = :houseareaid'; $params[':houseareaid'] = $_GPC['houseareaid'] ; } if ($_GPC['housetype']>0) { $condition .= ' AND `type` = :housetype'; $topcondition .= ' AND `type` = :housetype'; $params[':housetype'] = $_GPC['housetype'] ; } $sort =' ORDER BY createtime DESC '; $condition .= $sort; $sql = 'SELECT * FROM ' . tablename('weixinmao_house_saleinfo') .$condition. $limit ; $salelist = pdo_fetchall($sql, $params); $topsql = 'SELECT * FROM ' . tablename('weixinmao_house_saleinfo') .$topcondition. $limit ; $topsalelist = pdo_fetchall($topsql, $params); $sql = 'SELECT * FROM ' . tablename('weixinmao_house_area') . ' WHERE `uniacid` = :uniacid ORDER BY `sort` DESC'; $arealist = pdo_fetchall($sql, array(':uniacid' => $_W['uniacid'])); if($salelist) { foreach($salelist as $k=>$v) { $sql = 'SELECT name,tel,avatarUrl FROM ' . tablename('weixinmao_house_userinfo') . ' WHERE `uniacid` = :uniacid AND `uid` = :uid '; $userinfo = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'],':uid'=>$v['uid'])); $salelist[$k]['name'] = $userinfo['name']; $salelist[$k]['tel'] = $userinfo['tel']; $salelist[$k]['avatarUrl'] = $userinfo['avatarUrl']; $salelist[$k]['areaname'] = $areainfo[$v['houseareaid']]; $salelist[$k]['createtime'] = date('Y-m-d H:m:s',$v['createtime']); if($v['type'] ==1) { $salelist[$k]['type'] = '出售'; }elseif($v['type'] == 2){ $salelist[$k]['type'] = '出租'; }elseif($v['type'] == 3){ $salelist[$k]['type'] = '求购'; }elseif($v['type'] == 4){ $salelist[$k]['type'] = '求租'; } if($v['thumb_url']) { $piclist1 = unserialize($v['thumb_url']); $piclist = array(); if(is_array($piclist1)){ foreach($piclist1 as $p) { if($p) { $piclist[] = tomedia($p); } } } $salelist[$k]['piclist'] = $piclist; } if($v['special']){ $salelist[$k]['special'] = explode(',',$v['special']); } } } //置顶信息 if($topsalelist) { foreach($topsalelist as $k=>$v) { $sql = 'SELECT name,tel,avatarUrl FROM ' . tablename('weixinmao_house_userinfo') . ' WHERE `uniacid` = :uniacid AND `uid` = :uid '; $userinfo = pdo_fetch($sql, array(':uniacid' => $_W['uniacid'],':uid'=>$v['uid'])); $topsalelist[$k]['name'] = $userinfo['name']; $topsalelist[$k]['tel'] = $userinfo['tel']; $topsalelist[$k]['avat