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)); }
public static function iddelcpname() { $ID = Yii::app()->request->getParam('ID'); $result = JpdOrganCpname::model()->deleteBypk($ID); return array('result' => $result, 'ID' => $ID); }
public function Getmaincate($organID) { $big = JpdOrganCpname::model()->findAll(array('select' => 'DISTINCT BigpartsID,BigName', 'condition' => 'OrganID=' . $organID)); return $big; }
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; }