public function actionNavigation_add() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $navigation = new VcosNavigation(); $activity = new VcosActivity(); if ($_POST) { $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'; $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 = ''; if ($type_activity != '') { $nav_type .= $type_activity . ','; } if ($type_shop != '') { $nav_type .= $type_shop . ','; } if ($type_product != '') { $nav_type .= $type_product . ','; } $nav_type = trim($nav_type, ','); $create_times = date("Y/m/d H:i:s", time()); $cruise_id = Yii::app()->params['cruise_id']; $this_user_id = Yii::app()->user->id; $this_user_name = Yii::app()->user->name; //先自动生成活动 //事务处理 $transaction = $p_db->beginTransaction(); try { $activity->activity_name = $name; $activity->start_time = $create_times; $activity->status = $state; $activity->created = $create_times; $activity->creator = $this_user_name; $activity->creator_id = $this_user_id; $activity->cruise_id = $cruise_id; $activity->is_show_head = 0; $activity->is_nav = 1; $activity->save(); $ac_id = $activity->attributes['activity_id']; $transaction->commit(); //Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Navigation/navigation_list")); $flag = 1; } catch (Exception $e) { $transaction->rollBack(); //Helper::show_message(yii::t('vcos', '添加失败。'), '#'); $flag = 0; } if ($flag == 1) { //导航添加 //事务处理 $transaction = $p_db->beginTransaction(); try { $navigation->activity_id = $ac_id; $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', '添加失败。'), '#'); } } else { 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_add', array('navigation' => $navigation, 'activity' => $activity)); }
public function actionNavigation_add() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $navigation = new VcosNavigation(); 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_add', array('navigation' => $navigation, 'activity' => $activity)); }