/**
* 品牌
*/
public function actionOct()
{
$brand_id = 24;
$type_brand_list = TypeBrand::model()->findAll('brand_id = :brand_id', array(':brand_id' => $brand_id));
$TypeBrand = new TypeBrand();
$type_ids = implode(',', $TypeBrand->getFindAllids($type_brand_list, 'type_id'));
//类型列表
$type_list = GoodsType::model()->findAllBySql('SELECT * FROM car_b2c_goods_type WHERE type_id IN (' . $type_ids . ')');
//价格区间
$type_price_item = array();
foreach ($type_list as $v) {
$price = unserialize($v->price);
if (empty($price)) {
continue;
}
$type_price_item = $price;
}
//商品属性值
$goods_type_props_list = GoodsTypeProps::model()->findAllBySql('SELECT * FROM car_b2c_goods_type_props WHERE type_id IN (' . $type_ids . ')');
$Goodstypeprops = new GoodsTypeProps();
$props_ids = implode(',', $Goodstypeprops->getFindAllids($goods_type_props_list, 'props_id'));
//商品属性值数据
$goods_type_props_value_list = GoodsTypePropsValue::model()->findAllBySql('SELECT * FROM car_b2c_goods_type_props_value WHERE props_id IN (' . $props_ids . ')');
$goods_type_props_value_item = array();
foreach ($goods_type_props_value_list as $v) {
$goods_type_props_value_item[$v->props_id][] = $v;
}
//规格
/*提交数据到页面*/
$data = array('type_list' => $type_list, 'goods_type_props_list' => $goods_type_props_list, 'goods_type_props_value_item' => $goods_type_props_value_item, 'type_price_item' => $type_price_item);
$this->render('oct', $data);
}
/**
* 删除
*/
public function actionDelete()
{
$props_id = $this->get('props_id');
$result = GoodsTypeProps::model()->deleteAll('props_id = :props_id', array(':props_id' => $props_id));
if (!$result) {
$GoodsTypePropsValue = new GoodsTypePropsValue();
$this->message('error', CHtml::errorSummary($GoodsTypePropsValue), $this->createUrl('index'));
}
GoodsTypePropsRelation::model()->deleteAll('props_id = :props_id', array(':props_id' => $props_id));
$result = GoodsTypePropsValue::model()->deleteAll('props_id = :props_id', array(':props_id' => $props_id));
if ($result) {
$this->message('success', '删除成功', $this->createUrl('index'));
} else {
$GoodsTypePropsValue = new GoodsTypePropsValue();
$this->message('error', CHtml::errorSummary($GoodsTypePropsValue), $this->createUrl('index'));
}
}
