/**
* 通过自定义分类ID修改自定义分类信息
* @param $brandid 品牌ID号
*/
public function select_category($brandid)
{
$criteria = new CDbCriteria();
$criteria->select = '*';
$criteria->order = 'id DESC';
$criteria->addCondition('brandid=:brandid');
$criteria->addCondition('status=0');
$criteria->params[':brandid'] = $brandid;
$users = erp_brandcategory::model()->findAll($criteria);
return $users;
//查询成功返回
}
public function actionsetcustomcategory()
{
$brandid = $_SESSION['brandid'];
$count = 100;
$submit_status = 1;
$mes = "";
//添加 修改标签
if (strtolower($_SERVER['REQUEST_METHOD']) == 'post') {
//获取该品牌下的所有分类
$brandcategory_obj = Yii::app()->db->createCommand()->select('*')->from('erp_brandcategory')->where('brandId=:brandId and status=:status', array(':brandId' => $brandid, ':status' => 0))->queryAll();
$category_array = array();
for ($i = 0; $i < 100; $i++) {
$category_array[$i] = array();
$category_array[$i]['id'] = '';
$category_array[$i]['name'] = '';
if (Yii::app()->request->getParam('category_id_' . $i)) {
$category_array[$i]['id'] = Yii::app()->request->getParam('category_id_' . $i);
}
if (Yii::app()->request->getParam('category_name_' . $i)) {
$category_array[$i]['name'] = Yii::app()->request->getParam('category_name_' . $i);
}
}
$category_name = array();
for ($i = 0; $i < count($category_array); $i++) {
if (!empty($category_array[$i]['id']) || !empty($category_array[$i]['name'])) {
if (!in_array($category_array[$i]['name'], $category_name)) {
$category_name[] = $category_array[$i]['name'];
} else {
$submit_status = 0;
$mes = "分类名已创建";
}
}
}
if ($submit_status == 1) {
for ($i = 0; $i < count($category_array); $i++) {
if (empty($category_array[$i]['id']) && !empty($category_array[$i]['name'])) {
$erp_brandcategory = new erp_brandcategory();
$erp_brandcategory->name = $category_array[$i]['name'];
$erp_brandcategory->addtime = date("Y-m-d H:i:s");
$erp_brandcategory->brandid = $brandid;
$erp_brandcategory->status = 0;
$erp_brandcategory->insert();
} else {
if (!empty($category_array[$i]['id'])) {
$update_arr = array();
$update_arr['name'] = $category_array[$i]['name'];
erp_brandcategory::model()->updateAll($update_arr, 'id=:textx', array(':textx' => $category_array[$i]['id']));
}
}
$mes = "编辑分类成功";
}
}
}
//获取该品牌下的所有分类
$brandcategory_obj = Yii::app()->db->createCommand()->select('*')->from('erp_brandcategory')->where('brandId=:brandId and status=:status', array(':brandId' => $brandid, ':status' => 0))->queryAll();
$arry = array('brandcategory_obj' => $brandcategory_obj, 'submit_status' => $submit_status, 'mes' => $mes);
echo $this->render('/erp/setcustomcategory', $arry);
}
