public function actionDetailCreate() { $model = new ProductSetDetail(); $model->dpid = $this->companyId; $pslid = Yii::app()->request->getParam('psid'); $model->set_id = $pslid; if (Yii::app()->request->isPostRequest) { $model->attributes = Yii::app()->request->getPost('ProductSetDetail'); $se = new Sequence("porduct_set_detail"); $model->lid = $se->nextval(); $model->create_at = date('Y-m-d H:i:s', time()); $model->delete_flag = '0'; $modelsp = Yii::app()->db->createCommand('select count(*) as num from nb_product_set_detail t where t.dpid=' . $this->companyId . ' and t.set_id=' . $pslid . ' and t.delete_flag=0 and group_no=' . $model->group_no)->queryRow(); //var_dump($modelsp);exit; if ($model->is_select == "1") { $sqlgroup = "update nb_product_set_detail set is_select=0 where group_no=" . $model->group_no . " and dpid=" . $this->companyId . " and set_id=" . $model->set_id; Yii::app()->db->createCommand($sqlgroup)->execute(); } if ($model->save()) { Yii::app()->user->setFlash('success', yii::t('app', '添加成功')); $this->redirect(array('productSet/detailindex', 'companyId' => $this->companyId, 'lid' => $model->set_id)); } } $maxgroupno = $this->getMaxGroupNo($pslid); $categories = $this->getCategories(); $categoryId = 0; $products = $this->getProducts($categoryId); $productslist = CHtml::listData($products, 'lid', 'product_name'); $this->render('detailcreate', array('model' => $model, 'categories' => $categories, 'categoryId' => $categoryId, 'products' => $productslist, 'maxgroupno' => $maxgroupno)); }