Exemplo n.º 1
1
 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;
 }
Exemplo n.º 2
0
 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));
 }
Exemplo n.º 3
0
 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;
 }
Exemplo n.º 4
0
    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 : '';
Exemplo n.º 5
0
        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;
                }
Exemplo n.º 6
0
 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;
 }
Exemplo n.º 7
0
 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);
 }
Exemplo n.º 8
0
 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');
     }
 }
Exemplo n.º 9
0
 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));
 }
Exemplo n.º 10
0
Arquivo: detail.php Projeto: zwq/unpei
    .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 
}
?>
Exemplo n.º 11
0
 /**
  * 立即购买一件商品生成订单
  */
 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));
 }
Exemplo n.º 12
0
 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';
     }
 }
Exemplo n.º 13
0
Arquivo: buynow.php Projeto: zwq/unpei
    }
    .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>
Exemplo n.º 14
0
            ?>
                <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'];
Exemplo n.º 15
0
 public function actionIssale()
 {
     $goodsid = Yii::app()->request->getParam('goodsid');
     $res = MallService::getunsale($goodsid);
     if ($res == 0) {
         echo json_encode(array('message' => '商品已下架'));
     }
 }
Exemplo n.º 16
0
 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));
 }
Exemplo n.º 17
0
    ?>
" 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'];
        ?>
">
Exemplo n.º 18
0
 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);
 }