public function show() { $shop = trim(IFilter::act(IReq::get("id"))); $where = 0 < intval($shop) ? " where a.shopid = " . $shop : "where shortname='" . $shop . "'"; $shopinfo = $this->mysql->select_one("select * from " . Mysite::$app->config['tablepre'] . "shopfast as a left join " . Mysite::$app->config['tablepre'] . "shop as b on a.shopid = b.id " . $where . " "); if (empty($shopinfo)) { $link = IUrl::creaturl("site/index"); $this->message("获取店铺信息失败", $link); } if ($shopinfo['endtime'] < time()) { $link = IUrl::creaturl("site/index"); $this->message("店铺已关门", $link); } $nowhour = date("H:i:s", time()); $nowhour = strtotime($nowhour); $data['shopinfo'] = $shopinfo; $data['shopopeninfo'] = $this->shopIsopen($shopinfo['is_open'], $shopinfo['starttime'], $shopinfo['is_orderbefore'], $nowhour); $data['com_goods'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "goods where shopid = " . $shopinfo['id'] . " and is_com = 1 and is_goshop=1 "); $goodstype = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "goodstype where shopid = " . $shopinfo['id'] . " and cattype = " . $shopinfo['shoptype'] . " and is_goshop=1 order by orderid asc"); $data['goodstype'] = array(); $tempids = array(); foreach ($goodstype as $key => $value) { $value['det'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "goods where typeid = " . $value['id'] . " and shopid=" . $shopinfo['id'] . " and is_goshop=1"); $tempids[] = $value['id']; $data['goodstype'][] = $value; } $data['mainattr'] = array(); $templist = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "shoptype where cattype = " . $shopinfo['shoptype'] . " and parent_id = 0 and is_main =1 order by orderid asc limit 0,1000"); foreach ($templist as $key => $value) { $value['det'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "shoptype where parent_id = " . $value['id'] . " order by orderid asc limit 0,20"); $data['mainattr'][] = $value; } $data['shopattr'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "shopattr where cattype = " . $shopinfo['shoptype'] . " and shopid = '" . $shopinfo['id'] . "' order by firstattr asc limit 0,1000"); $data['goodsattr'] = array(); $goodsattr = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "goodssign where type = 'goods' order by id asc limit 0,1000"); foreach ($goodsattr as $key => $value) { $data['goodsattr'][$value['id']] = $value['imgurl']; } $data['psinfo'] = $this->pscost($shopinfo, 1); $sellrule = new sellrule(); $sellrule->setdata($shopinfo['shopid'], 1000, $shopinfo['shoptype']); $ruleinfo = $sellrule->getdata(); $data['ruledata'] = array(); if (isset($ruleinfo['cxids']) && $ruleinfo['cxids']) { $data['ruledata'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "rule where id in(" . $ruleinfo['cxids'] . ") order by id asc limit 0,1000"); } $cximglist = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "goodssign where type = 'cx' order by id asc limit 0,1000"); $data['ruleimg'] = array(); foreach ($cximglist as $key => $value) { $data['ruleimg'][$value['id']] = $value['imgurl']; } $data['cxlist'] = $ruleinfo; $data['scoretocost'] = Mysite::$app->config['scoretocost']; $data['collect'] = array(); if (!empty($this->memberinfo)) { $data['collect'] = $this->mysql->select_one("select * from " . Mysite::$app->config['tablepre'] . "collect where collectid=" . $shopinfo['id'] . " and collecttype = 0 and uid=" . $this->member['uid'] . " "); } $bzinfo = Mysite::$app->config['orderbz']; $data['bzlist'] = array(); if (!empty($bzinfo)) { $data['bzlist'] = unserialize($bzinfo); } $addresslist = array(); if (0 < $this->member['uid']) { $addresslist = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "address where userid=" . $this->member['uid'] . " "); } $data['addresslist'] = $addresslist; $data['paylist'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "paylist order by id desc "); $data['juanlist'] = array(); if (!empty($this->member['uid'])) { $data['juanlist'] = $this->mysql->getarr("select * from " . Mysite::$app->config['tablepre'] . "juan where uid ='" . $this->member['uid'] . "' and status = 1 and endtime > " . time() . " order by id desc limit 0,20"); } Mysite::$app->setdata($data); }