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 iddelvehcle() { $ID = Yii::app()->request->getParam('ID'); $result = JpdDealerVehicles::model()->deleteBypk($ID); return array('result' => $result, 'ID' => $ID); }