Example #1
0
 public function actionDetail()
 {
     $this->layout = "//layouts/base";
     //$model = Dealer::model()->find("userID=:userID", array(":userID" => $_GET['dealer']));
     $organID = Yii::app()->request->getParam("dealer");
     $model = Organ::model()->with('dealer')->findByPK($organID);
     //主营品牌
     // $brands = Brand::model()->findAll("OrganID = $organID");
     $brandsql = "select * from pap_dealer_brand db join pap_brand b on db.brandID=b.ID where db.OrganID={$organID}";
     $brandres = Yii::app()->papdb->CreateCommand($brandsql)->queryAll();
     //主营车系
     $dealerv = JpdDealerVehicles::model()->findAll("OrganID=:userID", array(":userID" => $organID));
     //主营品类
     $cpnames = JpdOrganCpname::model()->findAll('OrganID=:userID', array(':userID' => $organID));
     // 机构照片
     $photosql = 'select * from `{{organ_photo}}` where Purpose = 0 AND OrganID=' . $organID;
     $organphotos = Yii::app()->jpdb->createCommand($photosql)->queryAll();
     $Brand_sql = "SELECT b.BrandName, a.ID, a.url1, a.url2 FROM pap_dealer_brand AS a LEFT JOIN pap_brand AS b " . "ON a.BrandID = b.ID WHERE a.OrganID = {$organID}";
     $Brandphotos = Yii::app()->papdb->createCommand($Brand_sql)->queryAll();
     $this->render("detail", array('model' => $model, 'organphotos' => $organphotos, 'dealerv' => $dealerv, 'showcpnames' => $cpnames, 'brand' => $brandres, 'Brandphotos' => $Brandphotos));
 }
Example #2
0
 public static function iddelcpname()
 {
     $ID = Yii::app()->request->getParam('ID');
     $result = JpdOrganCpname::model()->deleteBypk($ID);
     return array('result' => $result, 'ID' => $ID);
 }
Example #3
0
 public function Getmaincate($organID)
 {
     $big = JpdOrganCpname::model()->findAll(array('select' => 'DISTINCT BigpartsID,BigName', 'condition' => 'OrganID=' . $organID));
     return $big;
 }
Example #4
0
 public function Getmaincate($organID)
 {
     $big = JpdOrganCpname::model()->findAll('OrganID=:org', array(':org' => $organID));
     foreach ($big as $k => $v) {
         $childs[$k] = $v->attributes;
         $cri = new CDbCriteria(array('condition' => 'ParentID =' . $v[BigpartsID] . ' and IsShow=1', 'order' => 'SortOrder asc'));
         $sub = Gcategory::model()->findAll($cri);
         $childs[$k]['children'] = $sub;
     }
     return $childs;
 }