public static function querydealer() { $cri = new CDbCriteria(); $cri->addCondition('Identity=2'); $cri->addCondition("IsBlack='0'"); $cri->addCondition("IsFreeze='0'"); $cri->addCondition("Status='1'"); //获得联盟id $organID = Yii::app()->user->getOrganID(); $unionid = MallService::getUnioninfo($organID); $unionid = $unionid ? $unionid : '-1'; //联盟商品 $dids = MallService::getUnionOrgan(array('UnionID' => $unionid, 'type' => 2)); $cri->addCondition('ID in (' . $dids . ')'); $cri->order = 'Sort ASC'; $dealer = Organ::model()->findAll($cri); $deal_info = array(); if ($dealer) { foreach ($dealer as $key => $val) { //将机构图片换成LOGO 修改时间2014-09-03 修改人:邓家文 //$img=JpdOrganPhoto::model()->find('OrganID=:organ',array(':organ'=>$val['ID'])); $deal_info[$key]['ID'] = $val['ID']; $deal_info[$key]['OrganName'] = $val['OrganName']; $deal_info[$key]['Phone'] = $val['Phone']; if (!isset($val['Logo']) && empty($val['Logo'])) { $val['Logo'] = 'common/default-goods.png'; } $deal_info[$key]['imgpath'] = $val['Logo']; } } return $deal_info; }
public function run() { $re = array('OrganID' => $this->sellerID, 'rows' => 3, 'page' => 1); $serviceID = Yii::app()->user->getOrganID(); $organID = $this->sellerID; $sql = "select ID,Name,ProPrice from pap_goods where IsDelete=1 and IsSale=1 and IsPro=1 and OrganID={$organID} limit 0,3 "; $goods = Yii::app()->papdb->createCommand($sql)->queryAll(); foreach ($goods as $k => $v) { $image = MallService::getOneGoodsImage($v['ID']); if (!$image) { $goods[$k]['image'] = F::uploadUrl() . 'dealer/goods-img-big.jpg'; } else { $goods[$k]['image'] = F::uploadUrl() . $image; } } $this->render("goods", array('goods' => $goods)); }
public static function getpurchase($purchaseids = array(), $payment) { $BuyerID = Yii::app()->user->getOrganID(); $purchaseids = implode(',', $purchaseids); $cartArr = array(); $sql = "select distinct jo1.ID as SellerID,jo1.OrganName as SellerName,jo2.ID as BuyerID,\n \t\tjo2.OrganName as BuyerName from \n\t\t\t\tpap_reserve_purchase as prp, pap_goods as pg, jpd.jpd_organ as jo1, jpd.jpd_organ as jo2\n\t\t\t\twhere prp.ID in ({$purchaseids}) AND prp.GoodsID = pg.ID AND pg.OrganID = jo1.ID \n\t\t\t\tAND prp.OrganID = jo2.ID AND prp.OrganID = '{$BuyerID}'"; $purchase = Yii::app()->papdb->createCommand($sql)->queryAll(); if ($purchase) { foreach ($purchase as $key => $val) { $cartArr[$key]["SellerID"] = $val['SellerID']; //卖家ID $cartArr[$key]["SellerName"] = $val['SellerName']; //卖家名称 $cartArr[$key]["BuyerName"] = $val['BuyerName']; //买家名称 //获取经销商订单折扣率--商城订单 $sellerID = $val['SellerID']; $discount = PapOrderDiscount::model()->find(array("condition" => "OrderType = 1")); if (isset($discount) && !empty($discount)) { if ($payment == 1) { $dis = $discount['OrderAlipay']; } else { if ($payment == 2) { $dis = $discount['OrderLogis']; } } if (isset($dis) && !empty($dis)) { $cartArr[$key]["discount"] = $dis; } else { $cartArr[$key]["discount"] = 100; } } else { $cartArr[$key]["discount"] = 100; } //获取经销商订单最小交易额 $turnover = PapOrderMinTurnover::model()->find("OrganID=:ID", array(":ID" => $val['SellerID'])); if ($turnover) { $cartArr[$key]["MinTurnover"] = $turnover['MinTurnover']; //订单最小交易额 } //将经销商的商品添加到经销商的组中 $sql = "SELECT distinct prp.ID as purchaseID, pg.ID as GoodsID, pg.Price, pg.ProPrice, \n \t\t\tpg.IsPro, prp.Num as Quantity, pg.Name as GoodsName, pg.GoodsNO as GoodsNum, \n \t\t\tpg.Brand, jg.Name as CpName, prp.CreateTime, pg.OrganID, pg.Version\n\t\t \tFROM pap_reserve_purchase AS prp , jpd.jpd_gcategory AS jg, \n\t\t \tpap_goods AS pg\n\t\t WHERE prp.GoodsID = pg.ID AND prp.GcategoryCode = jg.Code \n\t\t AND prp.OrganID = '{$BuyerID}' AND pg.OrganID = '{$val['SellerID']}' AND prp.ID in ({$purchaseids})\n \t\t"; $cartArr[$key]["GoodsList"] = Yii::app()->papdb->CreateCommand($sql)->queryAll(); foreach ($cartArr[$key]["GoodsList"] as $k => $value) { $ispro = PapGoods::model()->findBypk($value['GoodsID']); if (!$ispro->IsPro) { $goodsinfo = MallService::getDealerGoodByID($value['GoodsID']); $cartArr[$key]["GoodsList"][$k]['Price'] = $goodsinfo['Price']; $cartArr[$key]["GoodsList"][$k]['ProPrice'] = $goodsinfo['DisPrice']; } if ($ispro->IsPro == 1) { $cartArr[$key]["GoodsList"][$k]['ProPrice'] = $ispro['ProPrice']; } } } } return $cartArr; }
echo Yii::app()->theme->baseUrl; ?> /images/shophome/com-step1.jpg"></div> <div class="float_l m_left140"> <img src="<?php echo Yii::app()->theme->baseUrl; ?> /images/shophome/cx-bg.jpg"> </div> <div class="choice-cx float_l"> <p class="p-choice" id="make-select-mall" onclick="ajaxLoading()"> <?php $cookie = Yii::app()->request->getCookies(); $car = array('make' => $cookie['mallmake']->value, 'series' => $cookie['mallseries']->value, 'year' => $cookie['mallyear']->value, 'model' => $cookie['mallmodel']->value); if ($car['make']) { $str = MallService::getCarmodeltxt($car); ?> <a href="javascript:void(0)" id='veh'>更换车型</a> <?php } else { ?> <a href="javascript:void(0)" id='veh'>选择车型</a> <?php } ?> <!-- <a href="javascript:;" id='veh'>选择车型</a>--> </p> <p class="p-choiced" style='display:none' ></p> <input type="hidden" id="vechileold" value="<?php echo $str ? $str : '';
echo $goods['GoodsInfo']['Brand']; ?> </span></p> <p class="m-top5" style="width:300px;height: 18px;white-space: nowrap;overflow: hidden; text-overflow: ellipsis;">标准名称:<span><?php echo $goods['GoodsInfo']['StandCodeName']; ?> </span> | 拼音代码:<span><?php echo $goods['GoodsInfo']['Pinyin']; ?> </span> </p> <?php $orderGoods = PapOrderGoods::model()->find("OrderID=:OrderID and GoodsID=:GoodsID", array(":OrderID" => $v['OrderID'], ":GoodsID" => $goods['GoodsInfo']['ID'])); ?> <p>定位车型:<span><?php echo MallService::getCarmodeltxt(array('make' => $orderGoods['MakeID'], 'series' => $orderGoods['CarID'], 'year' => $orderGoods['Year'], 'model' => $orderGoods['ModelID'])); ?> </span></p> <p class="m-top5">配件档次:<span><?php echo $goods['GoodsInfo']['PartsLevelName']; ?> </span></p> <p class="m-top5" style="width:300px;height: 18px;white-space: nowrap;overflow: hidden; text-overflow: ellipsis;" >OE号:<span><?php if ($goods['GoodsInfo']['oeno']) { foreach ($goods['GoodsInfo']['oeno'] as $key => $value) { if ($key) { echo '、' . $value; } else { echo $value; }
private static function getVersionGoods($v) { $res = DealergoodsService::getmongoversion($v['GoodsID'], $v['Version']); $goods = $res['GoodsInfo']; // if (is_array($goods) && !empty($goods)) { //商品图片 if (is_array($goods['img']) && !empty($goods['img'])) { if (!$goods['img'][0]['ImageUrl']) { $v['ImageUrl'] = $goods['img'][0]['MallImage']; } else { $v['ImageUrl'] = $goods['img'][0]['ImageUrl']; } } else { $v['ImageUrl'] = ''; } //商品oe号 if (is_array($goods['oeno']) && !empty($goods['oeno'])) { $oe = ''; foreach ($goods['oeno'] as $ov) { if ($ov) { $oe .= $ov . ','; } } $v['GoodsOE'] = substr($oe, 0, -1); } else { $v['GoodsOE'] = ''; } $v['GoodsName'] = $goods['Name']; $v['GoodsNum'] = $goods['GoodsNO']; $v['Brand'] = $goods['Brand']; $v['PartsLevelName'] = $goods['PartsLevelName']; $v['CpName'] = Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code='{$goods['StandCode']}'"))->attributes['Name']; $v['Carmodeltxt'] = MallService::getCarmodeltxt(array('make' => $v['MakeID'], 'series' => $v['CarID'], 'year' => $v['Year'], 'model' => $v['ModelID'])); return $v; }
public function actionIndex() { $this->pageTitle = Yii::app()->name . '-经销商店铺'; $dealerid = Yii::app()->request->getParam('dealerid'); $model = Organ::model()->findByPk($dealerid, "Identity=2"); if (!$model) { $this->redirect(array('/pap/home/index')); } if (!isset($dealerid) || empty($dealerid)) { throw new CHttpException(404, 'Invalid request. Please do not repeat this request again.'); } $orderGet = Yii::app()->request->getParam('order'); $brandGet = Yii::app()->request->getParam('brand'); $priceGet = Yii::app()->request->getParam('price'); $skwd1 = urldecode(Yii::app()->request->getParam('skwd')); $skwd = MallService::checkKey($skwd1); $sub = Yii::app()->request->getParam('sub'); $ispro = Yii::app()->request->getParam('ispro'); $partslevel = Yii::app()->request->getParam('partslevel'); //车型车系 $cookie = Yii::app()->request->getCookies(); //var_dump($cookie); $car['make'] = $cookie['mallmake']->value; $car['series'] = $cookie['mallseries']->value; $car['year'] = $cookie['mallyear']->value; $car['model'] = $cookie['mallmodel']->value; //获取商品品牌 $brandparams['dealerid'] = $dealerid; $brandparams['type'] = 2; $brandparams['brand'] = $brandGet; $brandparams['sub'] = $sub; $brandparams['skwd'] = $skwd; $brandparams['car'] = $car; $brandModel = MallService::getDealerbrand($brandparams); //$brandModel = MallService::getBrand($brandparams); $brandData = $brandModel['data']; $brand = $brandModel['brand']; //价格区间 $priceModel = MallService::getPrice(array('price' => $priceGet)); $priceData = $priceModel['data']; $price = $priceModel['price']; //获得排序 $orderData = $this->getOrder($orderGet); //获取url $get = $this->getSearchParams($_GET); $params = array('order' => $orderData[0], 'dealerid' => $dealerid, 'skwd' => $skwd, 'brand' => $brandGet, 'price' => $price['cond'], 'car' => $car, 'sub' => $sub, 'ispro' => $ispro, 'rows' => 12, 'resource' => "mall", 'partslevel' => $partslevel, 'type' => 3, 'organID' => Yii::app()->user->getOrganID()); //获取适用车型text //$carmodeltxt = MallService::getCarmodeltxt($car); //经销商店铺信息 $seller = DefaultService::sellerstore($dealerid); //店铺积分 $TotalScore = DefaultService::getrecord($dealerid); //获取大类名称 if ($sub) { $big = Gcategory::model()->findByPk($sub); } //获取商品 $goods = MallService::getGoodsData($params); $rows = $this->Getmaincate($dealerid); $cate = $this->findsub($rows); // var_dump($cate);exit; //底部分页 //推荐商品 //获取经销商客服列表 $csparams['organID'] = $dealerid; $csparams['type'] = 1; $csinfo = CsService::getcslists($csparams); $data = array('seller' => $seller, 'csinfo' => $csinfo, 'TotalScore' => $TotalScore, 'dataProvider' => $goods['dataProvider'], 'pages' => $this->getShortPage($goods["count"], $params['rows']), 'dealerID' => $dealerid, 'order' => $orderData, 'get' => $get, 'cate' => $cate, 'displayType' => MallService::getDisplayType("seller_displayType"), 'params' => array('brand' => $brand, 'price' => $price, 'ispro' => $ispro, 'partslevel' => $partslevel), 'brand' => $brandData, 'price' => $priceData, 'order' => $orderData, 'bigid' => $big['ParentID']); $this->render('index', $data); }
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 actionOrderGoods() { $this->layout = '//layouts/papmall'; $goodsid = $subParts = Yii::app()->request->getParam('goods'); $payment = 1; $result = MallService::getGoodByID($goodsid, $payment); if (!$result) { $this->redirect(array('index')); } $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); } $this->pageTitle = Yii::app()->name . '-' . "商品详情"; //获取经销商客服列表 $csparams['organID'] = $result['SellerID']; $csparams['type'] = 1; $csinfo = CsService::getcslists($csparams); $this->render('ordergoods', array('r' => $result, 'carmodeltext' => $carmodeltext, 'res' => $res, 'csinfo' => $csinfo)); }
.dialog_button {width: 50px;height: 26px;line-height: 26px;background: #F00;border: none;color: #fff;font-weight: bold;} .zoomdiv{margin-left:210px!important} .btn-green-tiny{background:#ff6600;color:#fff} .sptj ul li{list-style:disc;} .sptj ol li{list-style:decimal;} .sptj ol {padding-left:20px;} .sptj ul {padding-left:20px;} </style> <?php $cartid = Yii::app()->request->getParam('cart'); if ($cartid) { $locatecarmodel = MallService::getlocalcarmodel(array('from' => 'cart', 'ID' => $cartid)); } $orderid = Yii::app()->request->getParam('order'); if ($orderid) { $locatecarmodel = MallService::getlocalcarmodel(array('from' => 'order', 'ID' => $orderid)); } ?> <div class="wrap-contents" style="background:#fff;width:990px;padding:5px; margin-top:5px; border:1px solid #ccc"> <div class="contents" style="padding-bottom:0px"> <div class="sp_mbx"> <ul class="sp_mbx_ul"> <li><?php if ($r['BigName']) { ?> <b><a><?php echo $r['BigName']; ?> </a> ></b><?php } ?>
/** * 立即购买一件商品生成订单 */ public function actionBuynoworder() { $goodsId = Yii::app()->request->getParam("goodsid"); if (!$goodsId) { $this->redirect(array('/pap/home/index')); } $payment = Yii::app()->request->getParam("payment"); if ($payment) { $payment = Yii::app()->request->getParam("payment"); } else { $payment = 1; } if (!$payment) { $this->redirect(array('/pap/home/index')); } //获取物流 前台页面input name属性 $ShipLogis = Yii::app()->request->getParam("logistics"); $quantity = Yii::app()->request->getParam("quantity"); if (!$quantity) { $this->redirect(array('/pap/home/index')); } $addressId = Yii::app()->request->getParam("addr"); if (!$addressId) { $this->redirect(array('/pap/home/index')); } $ship = $this->getShip($addressId); if (!$ship) { $this->redirect(array('/pap/home/index')); } $goods = MallService::getGoodByID($goodsId, $payment); $locate = Yii::app()->request->getParam('locate'); //优惠券减免金额 $lottid = Yii::app()->request->getParam("lott"); $PromoID = Yii::app()->request->getParam('PromoID'); $usecouponID = Yii::app()->request->getParam('usecouponID'); /* * 方法参数:$goods:商品信息 $payment:支付方式 $ShipLogis:物流公司 $ship:收货地址 */ $params = array('goods' => $goods, 'payment' => $payment, 'shiplogis' => $ShipLogis, 'ship' => $ship, 'quantity' => $quantity, 'locate' => $locate, 'usecouponID' => $usecouponID); $orderId = BuyGoodsService::createbuynoworder($params); if ($orderId && $lottid && $PromoID) { $this->redirect(array("payment", "id" => $orderId, 'lottid' => $lottid, 'promoid' => $PromoID)); } $this->redirect(array("payment", "id" => $orderId)); }
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'; } }
} .select{padding:3px 0px} .display-n{ color:#EC8051} .goodname{font-size:14px; font-weight: bold} .addr table{width:988px; margin:0px;} .addr table td{text-align:center} .dd_info_lm span{font-weight:bold} .select{margin-top:0px} .addr input{margin-top:0px} .shop_company{line-height:30px; margin-top:10px} </style> <?php $locatecar = Yii::app()->request->getParam('locate'); $locate = explode('_', $locatecar); $locatecarmodel = MallService::getCarmodeltxt(array('make' => $locate[0], 'series' => $locate[1], 'year' => $locate[2], 'model' => $locate[3])); ?> <div class="wrap-contents" style="background:#fff;border:1px solid #ccc;padding:5px; width:990px;margin-top:5px"> <p class="gwc_lm"><span class="gwc_lm_info">我的购物车</span></p> <div class="step"> <div class="step_info"> <ul> <li> <i><img src="<?php echo Yii::app()->theme->baseUrl . '/images/papmall/gouwuche/step2.jpg'; ?> "></i><br> <span>1.确认商品信息</span> </li> <li>
?> <li class="zxq_li" style="width: 250px;position: relative;z-index:<?php echo count($dealer) - $k; ?> "> <div> <a href="<?php echo Yii::app()->createUrl($currenturl, $jxs); ?> " style="display:block; overflow: hidden;text-overflow: ellipsis; white-space: nowrap; width:130px; float: left"><?php echo $jxsname; ?> </a> <p style="width:100px; float: right; margin-left:10px"> <?php $xinxin_html = MallService::showxinxin($v['ID']); ?> <?php echo $xinxin_html['avg'] . '分'; ?> </p> </div> <div class="li_div" style=""> <p style="text-align:center"><b><?php echo $jxsname; ?> </b></p> <p style="border-bottom:1px solid #ccc;margin-top:5px "></p> <?php echo $xinxin_html['PartIt'] . $xinxin_html['CarRate'] . $xinxin_html['GoodsLevel'] . $xinxin_html['PriceLevel'];
public function actionIssale() { $goodsid = Yii::app()->request->getParam('goodsid'); $res = MallService::getunsale($goodsid); if ($res == 0) { echo json_encode(array('message' => '商品已下架')); } }
public function actionIndex() { $type = Yii::app()->request->getParam('type'); $state = Yii::app()->request->getParam('State'); $city = Yii::app()->request->getParam('City'); $homeajax = Yii::app()->request->getParam('homeajax'); $pagesize = 12; if ($state === '') { $province = 'all'; } elseif ($state === null) { $province = '370000'; } else { $province = $state; } $brand = Yii::app()->request->getParam('brand'); $type = $type === null ? 1 : $type; //1网格 2列表 //获得联盟id $organID = Yii::app()->user->getOrganID(); $unionid = MallService::getUnioninfo($organID); $unionid = $unionid ? $unionid : '-1'; //联盟商品 $dids = MallService::getUnionOrgan(array('UnionID' => $unionid, 'type' => 2)); $where = ' where Identity=2 and IsBlack="0" and IsFreeze="0" and Status="1"'; $where .= ' and ID in (' . $dids . ')'; if ($homeajax == 1) { $province = 'all'; $pagesize = 6; } if ($province !== 'all') { $where .= ' and Province=' . $province; } if ($city) { $where .= ' and City=' . $city; } if (!empty($brand)) { $ids = $this->getdealerbybrand($brand); $where .= ' and ID in' . $ids; } if ($homeajax == 1) { //工作台首页 $sql = ' select ID,OrganName,Logo from jpd_organ' . $where; } else { $sql = ' select * from jpd_organ' . $where; } $sqlcount = ' select count(*) from jpd_organ' . $where; $count = Yii::app()->jpdb->createCommand($sqlcount)->queryScalar(); $sql .= ' order by Sort ASC '; $dataProvider = new CSqlDataProvider($sql, array('db' => Yii::app()->jpdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => $pagesize))); $organ = $dataProvider->getData(); if ($homeajax == 1) { echo json_encode($organ); die; } if ($organ) { foreach ($organ as $key => $val) { $a = array(); $b = array(); $organ[$key]['OrganName'] = '<a target="_black" href="' . Yii::app()->createUrl('servicer/servicedetail/detail', array('dealer' => $val['ID'])) . '">' . $val['OrganName'] . '</a>'; $brand = PapBrand::model()->findAll('OrganID=:organ', array(':organ' => $val['ID'])); $brand_str = ""; foreach ($brand as $k => $v) { if ($v['BrandName'] === null) { continue; } $a[] = $v['BrandName']; } if ($a) { $brand_str = implode(',', $a); $organ[$key]['brand'] = '<a title="' . $brand_str . '">' . $brand_str . '</a>'; $organ[$key]['firstbrand'] = '<a title="' . $brand_str . '">' . $a[0] . '</a>'; } else { $organ[$key]['brand'] = '暂无'; $organ[$key]['firstbrand'] = '主营品牌:暂无'; } $vehicles = DealerVehicles::model()->findAll('OrganID=:organ', array(':organ' => $val['ID'])); $str = ""; foreach ($vehicles as $k => $v) { $car = $v['Make']; if ($v['Car']) { $car .= ' ' . $v['Car']; if ($v['Year']) { $car .= ' ' . $v['Year']; if ($v['Model']) { $car .= ' ' . $v['Model']; } else { $car .= ' ' . '全车型'; } } else { $car .= ' ' . '全年款'; } } else { $car .= ' ' . '全车系'; } $b[] = $car; } if ($b) { $str = implode('; ', $b); //$organ[$key]['vehicles'] = '<a title="' . $str . '">' . $str . '</a>'; $organ[$key]['vehicles'] = $str; } else { $organ[$key]['vehicles'] = '暂无'; } $organ[$key]['TelPhone'] = $organ[$key]['TelPhone'] ? $organ[$key]['TelPhone'] : '暂无'; } } $dataProvider->setData($organ); $branddata = $this->getBrand($dids); $get = $this->geturlparams($_GET); $get['type'] = $type; $pages = new CPagination($count); $pages->pageSize = $pagesize; $page = $pages->getCurrentPage() + 1; $totalpage = $pages->getPageCount(); $start = 1 + ($page - 1) * $pagesize; $end = $page < $totalpage ? $start + $pagesize - 1 : $count; $footer = '<span class="zdyfooter">第 ' . $start . ' - ' . $end . ' 条, 共 ' . $count . ' 条.</span>'; $this->render('index', array('dataProvider' => $dataProvider, 'brand' => $branddata, 'get' => $get, 'type' => $type, 'province' => $province, 'city' => $city, 'pages' => $pages, 'footer' => $footer)); }
?> " target="_blank"><?php echo isset($cart['SellerName']) ? $cart['SellerName'] : ''; ?> </a></span></p> <input type="hidden" class="input" name="minTurnover" value="<?php echo $cart["MinTurnover"]; ?> "/> <ul> <?php foreach ($cart["GoodsList"] as $list) { ?> <?php if ($list['MakeID']) { $locatecarmodel = MallService::getCarmodeltxt(array('make' => $list['MakeID'], 'series' => $list['CarID'], 'year' => $list['Year'], 'model' => $list['ModelID'])); $goodsurl = Yii::app()->createUrl('pap/mall/detail', array('goods' => $list['GoodsID'], 'cart' => $list['ID'])); } else { $goodsurl = Yii::app()->createUrl('pap/mall/detail', array('goods' => $list['GoodsID'])); } ?> <?php $oldTotal = $list['ProPrice'] ? $list['ProPrice'] * $list['Quantity'] : $list['Price'] * $list['Quantity']; ?> <?php $subTotal = sprintf('%.2f', $oldTotal); ?> <li id="li<?php echo $list['ID']; ?> ">
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); }