public static function gethotgoods() { $week = date('W', time()); $w = date('w', time()); if ($week == '01') { $year = date("Y", time() + 60 * 60 * 24 * 7); } else { $year = date("Y", time()); } $CarryTime = strtotime($year . '-W' . $week) ? strtotime($year . '-W' . $week) : strtotime($year . '-W0' . $week); $selectsql = "select * from cs_carry where CarryTime = " . $CarryTime; $carry = Yii::app()->csdb->createCommand($selectsql)->queryAll(); if ($carry) { $selectsql = "select * from cs_carry_goods where CarryID = " . $carry[0]['ID'] . " and Week = " . $w; $carry[0]['carrygoods'] = Yii::app()->csdb->createCommand($selectsql)->queryAll(); if ($carry[0]['carrygoods']) { foreach ($carry[0]['carrygoods'] as $k => $v) { $carry[0]['carrygoods'][$k]['Goodsinfo'] = MallService::getredis($v['GoodsID'], 'search'); } return $carry[0]; } else { return 'false'; } } else { return 'false'; } }
public function actionGetGoods() { if (Yii::app()->request->isAjaxRequest) { $goodsid = Yii::app()->request->getParam('goodsid'); $serviceID = Yii::app()->user->getOrganID(); $result = MallService::getredis($goodsid); //商品折扣价 if ($result['IsPro'] != 1) { $PriceRatio = MallService::getDisprice($result['OrganID'], $serviceID); if ($PriceRatio > 0 && $PriceRatio < 100) { $result['DisPrice'] = sprintf('%.2f', $result['Price'] * $PriceRatio / 100); } } $result['spec']['UnitName'] = GoodsUnit::model()->findByPk($result['spec']['Unit'])->attributes['UnitName']; //单位 echo json_encode($result, true); } else { $this->redirect('index'); } }
public function actionDetail() { $serviceID = Yii::app()->user->getOrganID(); $goodsid = Yii::app()->request->getParam('goods'); $result = MallService::getredis($goodsid); //$payment = 1; //$result = MallService::getGoodByID($goodsid, $payment, 'mall'); if ($result == 'null') { echo '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />'; echo "<script>alert('该商品不存在!');window.location.href='" . Yii::app()->createUrl('pap/mall/index') . "'</script>"; exit; } else { if ($result == 'nosale') { echo '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />'; echo "<script>alert('该商品已下架!');window.location.href='" . Yii::app()->createUrl('pap/mall/index') . "'</script>"; exit; } } $result['GoodsID'] = $result['ID']; $result['CommentNo'] = PapGoods::model()->findByPk($result['ID'])->attributes['CommentNo']; //商品折扣价 if ($result['IsPro'] != 1) { $PriceRatio = MallService::getDisprice($result['OrganID'], $serviceID); if ($PriceRatio > 0 && $PriceRatio < 100) { $result['DisPrice'] = sprintf('%.2f', $result['Price'] * $PriceRatio / 100); } } $cookie = Yii::app()->request->getCookies(); $car = array('make' => $cookie['mallmake']->value, 'series' => $cookie['mallseries']->value, 'year' => $cookie['mallyear']->value, 'model' => $cookie['mallmodel']->value); $carmodeltext = MallService::getCarmodeltxt($car); $res = array(); if ($car['make'] && $car['series'] && $car['year'] && $car['model']) { $params = $car; $params['goodsid'] = $goodsid; $res = MallService::checkCarfit($params); } //店内分类 $rows = $this->Getmaincate($result['OrganID']); $cate = $this->findsub($rows); //获取经销商客服列表 $csparams['organID'] = $result['OrganID']; $csparams['type'] = 1; $csinfo = CsService::getcslists($csparams); //大类、子类、标准名称 if (is_array($result['gcategory']) && !$result['gcategory']['BigName']) { $result['BigName'] = $result['gcategory']['BigName']; $result['SubName'] = $result['gcategory']['SubName']; $result['sub'] = $result['gcategory']['SubParts']; } else { $cpArr = MallService::getCategory($result['StandCode']); $result['BigName'] = $cpArr['BigParts']; $result['SubName'] = $cpArr['SubParts']; $result['sub'] = $cpArr['sub']; } //公告信息 $model = new PapGoodsSendnotice(); $sellerID = $result['OrganID']; $notice = $model->find("OrganID = {$sellerID}"); //var_dump($data);die; //店家积分 $result['TotalScore'] = DefaultService::getrecord($result['OrganID']); //店家信息 $organInfo = Organ::model()->findByPk($result['OrganID'])->attributes; $result['Address'] = array(Area::getCity($organInfo['Province']), Area::getCity($organInfo['City']), Area::getCity($organInfo['Area'])); $result['spec']['UnitName'] = GoodsUnit::model()->findByPk($result['spec']['Unit'])->attributes['UnitName']; //单位 //最小交易金额 $result['MinTurnover'] = PapOrderMinTurnover::model()->find("OrganID=:ID", array(":ID" => $result['OrganID']))->attributes['MinTurnover']; $this->pageTitle = Yii::app()->name . '-' . "商品详情"; $this->render('detail', array('r' => $result, 'cate' => $cate, 'carmodeltext' => $carmodeltext, 'res' => $res, 'csinfo' => $csinfo, 'car' => $car, 'data' => $notice)); }
public static function getGoodsData($params) { $serviceID = $params['organID']; Yii::import("widgets.default.WSphinxResult"); $searchCriteria = new stdClass(); $searchCriteria->select = 'goodsid,sales,commentno,ispro,standsort,price'; if ($params['SellerID'] && $params['IsSale'] == 0) { $filters = array('isdelete' => 1, 'issale' => 0, 'organid' => $params['SellerID']); } else { $filters = array('isdelete' => 1, 'issale' => 1); } $query = ''; //子类、标准名称 if ($params['sub']) { //标准名称code查询 if ($params['code']) { $filters['standcode'] = base_convert($params['code'], 36, 10); } else { //子类查询 $codeArr = self::getstandcode($params['sub']); $filters['standcode'] = $codeArr; } } //search页面关键字搜索 if ($params['type'] == 1) { if ($params['keyword']) { $params['keyword'] = str_replace("\"", "'", $params['keyword']); $query = $query ? $query . ' ' . $params['keyword'] : $params['keyword']; } else { $filters['organid'] = '-1'; } } //获取经销商商品列表 if ($params['dealerid']) { $filters['organid'] = $params['dealerid']; } else { //获取联盟内的商品 if (is_array($params['union']) && !empty($params['union'])) { $filters['organid'] = $params['union']; } } //品牌查询 if ($params['brand']) { $brandArr = self::getbrandid($params['brand']); $filters['brandid'] = $brandArr; } //配件档次查询 if ($params['partslevel']) { $filters['partslevel'] = ord($params['partslevel']); } //厂家、车系、车型查询 if ($params['car']['make']) { $filters['make'] = $params['car']['make']; if ($params['car']['series']) { $filters['car'] = $params['car']['series']; } if ($params['car']['year']) { $filters['year'] = $params['car']['year']; } if ($params['car']['model']) { $filters['model'] = $params['car']['model']; } } //是否促销 if ($params['ispro'] == 1) { $filters['ispro'] = 1; } else { if ($params['ispro'] == 2) { $filters['ispro'] = 0; } } //价格区间 if (!empty($params['price']) && is_array($params['price'])) { $filters['range'] = array('price' => $params['price']); } //商品排序 $order = ''; if ($params['order']) { $orderby = $params['order']; if ($orderby == 'sales_l') { // 按销量从多到少 $order = " sales DESC"; } elseif ($orderby == 'sales_h') { // 按销量从少到多 $order = " sales ASC"; } elseif ($orderby == 'price_l') { //总价从高到低 $order = " price DESC"; } elseif ($orderby == 'price_h') { // 总价从低到高 $order = " price ASC"; } elseif ($orderby == 'comment_l') { // 评论数从高到低 $order = " CommentNo DESC"; } elseif ($orderby == 'comment_h') { // 评论数从低到高 $order = " CommentNo ASC"; } $order .= ","; // elseif ($orderby == 'ctime_l') { // 上架时间从高到低 // $order = " order by dg.UpdateTime DESC"; // } elseif ($orderby == 'ctime_h') { // 上架时间从低到高 // $order = " order by dg.UpdateTime ASC"; // } } $order .= 'standsort DESC,standcode asc,price ASC'; // $searchCriteria->groupby = array('field' => 'goodsid', 'mode' => 4, 'order' => $order); $searchCriteria->filters = $filters; $searchCriteria->query = $query; //$searchCriteria->query = '@title ' . 1 . '*'; // $searchCriteria->orders = $order; $searchCriteria->from = "main"; $model = new WSphinxResult($searchCriteria, array('pagination' => array('pageSize' => 12))); //搜索机构 if ($params['type'] != 3 && !$params['dealerid']) { $searchCriteria1 = clone $searchCriteria; $dealerdata = self::getDealerArr($searchCriteria1); } //搜索品牌 if ($params['type'] != 3 && !$params['brand']) { $searchCriteria2 = clone $searchCriteria; $branddata = self::getBrandArr($searchCriteria2); } //搜索子类、标准名称 if ($params['type'] == 1) { $searchCriteria3 = clone $searchCriteria; $codemodel = self::getCodeTree($searchCriteria3); } $data = $model->getData(); foreach ($data as $key => $value) { $goods = MallService::getredis($value['attrs']['goodsid'], 'search'); $goods['standsort'] = $value['attrs']['standsort']; $goods['Sales'] = $value['attrs']['sales']; // $goods['CommentNo'] = $value['attrs']['commentno']; if ($goods['IsPro'] == 1) { $goods['ppp'] = $goods['ProPrice']; } else { $priceratio = self::getDisprice($goods['OrganID'], $serviceID); if (!$priceratio) { $goods['ppp'] = $goods['Price']; } else { $goods['ppp'] = sprintf('%2f', $goods['Price'] * $priceratio / 100); } } $goods['CommentNo'] = PapGoods::model()->findByPk($goods['ID'])->attributes['CommentNo']; $data[$key] = $goods; } $model->setData($data); return array('dataProvider' => $model, 'count' => count($data) == 0 ? 0 : $model->totalNum, 'branddata' => $branddata, 'dealerdata' => $dealerdata, 'codedata' => $codemodel); }