public function actionActivity_add()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$activity = new VcosActivity();
if ($_POST) {
$name = isset($_POST['name']) ? $_POST['name'] : '';
$desc = isset($_POST['desc']) ? $_POST['desc'] : '';
$time = explode(" - ", $_POST['time']);
$s_time = $time[0] . ' ' . $_POST['stime'];
$e_time = $time[1] . ' ' . $_POST['etime'];
$stime = date('Y/m/d H:i:s', strtotime($s_time));
$etime = date('Y/m/d H:i:s', strtotime($e_time));
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'activity_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'activity_images/' . Yii::app()->params['month'] . '/' . $photo;
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$show = isset($_POST['show']) ? $_POST['show'] : '0';
$show_head = isset($_POST['show_head']) ? $_POST['show_head'] : '0';
$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->activity_desc = $desc;
$activity->activity_img = $photo_url;
$activity->start_time = $stime;
$activity->end_time = $etime;
$activity->status = $state;
$activity->created = $create_times;
$activity->creator = $this_user_name;
$activity->creator_id = $this_user_id;
$activity->is_show_category = $show;
$activity->is_show_head = $show_head;
$activity->cruise_id = $cruise_id;
$activity->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Activity/activity_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '添加失败。'), '#');
}
}
$this->render('activity_add', array('activity' => $activity));
}
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));
}
