SELECT
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Name IS NULL AND t2.storage_Name != NULL ) THEN t2.storage_Name ELSE t1.food_Name END AS food_Name,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Unit IS NULL AND t2.storage_Unit != NULL ) THEN t2.storage_Unit ELSE t1.food_Unit END AS food_Unit,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Label IS NULL AND t2.storage_Label != NULL ) THEN t2.storage_Label ELSE t1.food_Label END AS food_Label,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Price IS NULL AND t2.storage_Price != NULL ) THEN t2.storage_Price ELSE t1.food_Price END AS food_Price,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_ImageUrl1 IS NULL AND t2.storage_Imgurl1 != NULL ) THEN t2.storage_Imgurl1 ELSE t1.food_ImageUrl1 END AS food_ImageUrl1,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_ImageUrl2 IS NULL AND t2.storage_Imgurl2 != NULL ) THEN t2.storage_Imgurl2 ELSE t1.food_ImageUrl2 END AS food_ImageUrl2,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_ImageUrl3 IS NULL AND t2.storage_Imgurl3 != NULL ) THEN t2.storage_Imgurl3 ELSE t1.food_ImageUrl3 END AS food_ImageUrl3,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_ImageUrl4 IS NULL AND t2.storage_Imgurl4 != NULL ) THEN t2.storage_Imgurl4 ELSE t1.food_ImageUrl4 END AS food_ImageUrl4,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_ImageUrl5 IS NULL AND t2.storage_Imgurl5 != NULL ) THEN t2.storage_Imgurl5 ELSE t1.food_ImageUrl5 END AS food_ImageUrl5,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Salnumber IS NULL AND t2.storage_Salnumber != NULL ) THEN t2.storage_Salnumber ELSE t1.food_Salnumber END AS food_Salnumber,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Hjh IS NULL AND t2.storage_Hjh != NULL ) THEN t2.storage_Hjh ELSE t1.food_Hjh END AS food_Hjh,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Has_formerprice IS NULL AND t2.storage_Has_formerprice != NULL ) THEN t2.storage_Has_formerprice ELSE t1.food_Has_formerprice END AS food_Has_formerprice,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Formerprice IS NULL AND t2.storage_Formerprice != NULL ) THEN t2.storage_Formerprice ELSE t1.food_Formerprice END AS food_Formerprice,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Integral IS NULL AND t2.storage_Integeal != NULL ) THEN t2.storage_Integeal ELSE t1.food_Integral END AS food_Integral,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Description IS NULL AND t2.storage_Description != NULL ) THEN t2.storage_Description ELSE t1.food_Description END AS food_Description,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Memberlimit IS NULL ) THEN 0 ELSE t1.food_Memberlimit END AS food_Memberlimit,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Member_price_used IS NULL ) THEN 0 ELSE t1.food_Member_price_used END AS food_Member_price_used,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Member_price IS NULL ) THEN 0 ELSE t1.food_Member_price END AS food_Member_price,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Dulixiangou != 0 ) THEN t2.storage_Is_limitfood ELSE t1.food_Is_limitfood END AS food_Is_limitfood,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Dulixiangou != 0 ) THEN t2.storage_Limitfoodnum ELSE t1.food_Limitfoodnum END AS food_Limitfoodnum,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Dulixiangou != 0 ) THEN t2.storage_Isonelylimit ELSE t1.food_Isonelylimit END AS food_Isonelylimit,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Dulikuncun != 0 ) THEN t2.storage_Has_Stock ELSE t1.food_Stock END AS food_Stock,
CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Dulikuncun != 0 ) THEN t2.storage_Stock_Number ELSE t1.food_Stock_Number END AS food_Stock_Number,
CASE WHEN ( t1.food_StorageId > 0 AND t1.food_Formerprice = 0 AND t2.storage_Price > 0 ) THEN t2.storage_Price ELSE t1.food_Formerprice END AS food_Formerprice
,food_Has_formerprice,food_Start_time,food_Stop_time,food_Datetage,food_Timetage,food_Handling,food_ID,food_shopid,food_No,food_Foodtypeid,food_Secondtypeid,food_Status
FROM
t_logic_food t1
LEFT JOIN t_logic_food_storage t2 ON t2.storage_Id = t1.food_StorageId
WHERE
t1.food_ID = 711自己尝试做的modelClass FoodInfoRelationModel extends RelationModel{
protected $tableName='logic_food';
protected $_link=array(
'foods'=>array(
'mapping_type'=>self::BELONGS_TO,
'class_name'=>'logic_food_storage',
'mapping_name'=>'food_StorageId',
'foreign_key'=>'food_StorageId',
//'mapping_fields'=>'CASE WHEN ( t1.food_StorageId != NULL AND t1.food_Name IS NULL AND t2.storage_Name != NULL ) THEN t2.storage_Name ELSE t1.food_Name END AS food_Name'
'mapping_fields'=>'storage_Price',
'as_fields'=>'storage_Price:food_Price'
),
);
}现在的问题是 不知道case 在model里怎么写 最佳答案
