public function actionNavigation_edit() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $id = $_GET['id']; $navigation = VcosNavigation::model()->findByPk($id); if ($_POST) { $old_name = isset($_POST['old_name']) ? $_POST['old_name'] : ''; $act_id = isset($_POST['act_id']) ? $_POST['act_id'] : ''; $name = isset($_POST['name']) ? $_POST['name'] : ''; $sort = isset($_POST['sort']) ? $_POST['sort'] : '0'; $type_activity = isset($_POST['type_activity']) ? $_POST['type_activity'] : ''; $type_shop = isset($_POST['type_shop']) ? $_POST['type_shop'] : ''; $type_product = isset($_POST['type_product']) ? $_POST['type_product'] : ''; $state = isset($_POST['state']) ? $_POST['state'] : '0'; $cruise_id = Yii::app()->params['cruise_id']; $show = isset($_POST['show']) ? $_POST['show'] : 0; $set_cat = isset($_POST['set_cat']) ? $_POST['set_cat'] : 0; $main = isset($_POST['main']) ? $_POST['main'] : 0; $nav_type = ''; $un_activity_product = ''; if ($type_activity != '') { $nav_type .= $type_activity . ','; } else { if ($type_activity == '') { $un_activity_product .= '4,'; } } if ($type_shop != '') { $nav_type .= $type_shop . ','; } else { if ($type_shop == '') { $un_activity_product .= '3,'; } } if ($type_product != '') { $nav_type .= $type_product . ','; } else { if ($type_product == '') { $un_activity_product .= '6,'; } } $nav_type = trim($nav_type, ','); $un_activity_product = trim($un_activity_product, ','); if ($old_name != $name) { $sql = "UPDATE `vcos_activity` SET activity_name='" . $name . "' WHERE activity_id=" . $act_id; Yii::app()->p_db->createCommand($sql)->execute(); } //事务处理 $transaction = $p_db->beginTransaction(); try { $navigation->navigation_name = $name; $navigation->sort_order = $sort; $navigation->status = $state; $navigation->navigation_style_type = $nav_type; $navigation->cruise_id = $cruise_id; $navigation->is_show = $show; $navigation->is_category = $set_cat; $navigation->is_main = $main; $navigation->save(); if ($un_activity_product != '') { $sql = "DELETE FROM `vcos_activity_product` WHERE activity_id='{$act_id}' AND product_type in ({$un_activity_product})"; Yii::app()->p_db->createCommand($sql)->execute(); } //商品分类:启用和禁用导航 ,修改相应子类 if ($set_cat == 1) { $sql = "UPDATE `vcos_navigation_group` SET status='{$state}' WHERE navigation_id='{$id}'"; Yii::app()->p_db->createCommand($sql)->execute(); $sql = "SELECT navigation_group_id FROM `vcos_navigation_group` WHERE navigation_id='{$id}'"; $nav_cats = Yii::app()->p_db->createCommand($sql)->queryAll(); $nav_cat_ids = ''; foreach ($nav_cats as $row) { $nav_cat_ids .= $row['navigation_group_id'] . ','; } $nav_cat_ids = trim($nav_cat_ids, ','); $sql = "UPDATE `vcos_navigation_group_category` SET status='{$state}' WHERE navigation_group_id in ({$nav_cat_ids})"; Yii::app()->p_db->createCommand($sql)->execute(); } $sql = "UPDATE `vcos_activity` SET status='{$state}' WHERE activity_id='{$act_id}'"; Yii::app()->p_db->createCommand($sql)->execute(); $transaction->commit(); Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/navigation_list")); } catch (Exception $e) { $transaction->rollBack(); Helper::show_message(yii::t('vcos', '修改失败。')); } } $sql = "SELECT activity_id,activity_name FROM `vcos_activity` WHERE status=1"; $activity = Yii::app()->p_db->createCommand($sql)->queryAll(); $this->render('navigation_edit', array('navigation' => $navigation, 'activity' => $activity)); }
public function actionNavigation_edit() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $id = $_GET['id']; $navigation = VcosNavigation::model()->findByPk($id); if ($_POST) { $name = isset($_POST['name']) ? $_POST['name'] : ''; $sort = isset($_POST['sort']) ? $_POST['sort'] : '0'; $activity = isset($_POST['activity']) ? $_POST['activity'] : 0; $nav_type = isset($_POST['nav_type']) ? $_POST['nav_type'] : '0'; $state = isset($_POST['state']) ? $_POST['state'] : '0'; $cruise_id = Yii::app()->params['cruise_id']; $show = isset($_POST['show']) ? $_POST['show'] : 0; $set_cat = isset($_POST['set_cat']) ? $_POST['set_cat'] : 0; $main = isset($_POST['main']) ? $_POST['main'] : 0; //事务处理 $transaction = $p_db->beginTransaction(); try { $navigation->activity_id = $activity; $navigation->navigation_name = $name; $navigation->sort_order = $sort; $navigation->status = $state; $navigation->navigation_style_type = $nav_type; $navigation->cruise_id = $cruise_id; $navigation->is_show = $show; $navigation->is_category = $set_cat; $navigation->is_main = $main; $navigation->save(); $transaction->commit(); Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/navigation_list")); } catch (Exception $e) { $transaction->rollBack(); Helper::show_message(yii::t('vcos', '修改失败。')); } } $sql = "SELECT activity_id,activity_name FROM `vcos_activity` WHERE status=1"; $activity = Yii::app()->p_db->createCommand($sql)->queryAll(); $this->render('navigation_edit', array('navigation' => $navigation, 'activity' => $activity)); }