/** * 通过自定义分类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); }