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 actionActivity_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$activity = VcosActivity::model()->findByPk($id);
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->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;
if ($photo) {
$activity->activity_img = $photo_url;
}
$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_edit', array('activity' => $activity));
}
/**
* 活动编辑*
*/
public function actionActivity_edit()
{
$this->setauth();
// 检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$activity = VcosActivity::model()->findByPk($id);
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->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;
if ($photo) {
$activity->activity_img = $photo_url;
}
$activity->save();
// 修改活动商品是否过期
if ($state == 0) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=1 WHERE activity_id='{$id}' AND product_type=6";
$p_db->createCommand($sql)->execute();
$sql = "UPDATE `vcos_activity_product` SET is_overdue=1 WHERE product_id='{$id}' AND product_type=4";
$p_db->createCommand($sql)->execute();
} else {
if ($stime <= $create_times && $etime >= $create_times) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=0 WHERE product_id='{$id}' AND product_type=4";
$p_db->createCommand($sql)->execute();
$sql = "SELECT product_id,start_show_time,end_show_time FROM `vcos_activity_product` WHERE activity_id='{$id}' AND product_type=6";
$data = Yii::app()->p_db->createCommand($sql)->queryAll();
if ($data) {
foreach ($data as $row) {
$sql = "SELECT sale_start_time s_time,sale_end_time e_time,status FROM `vcos_product` WHERE product_id='{$row['product_id']}'";
$this_data = Yii::app()->p_db->createCommand($sql)->queryRow();
if ($this_data['status'] == 0) {
$flag = 1;
} else {
if ($row['start_show_time'] <= $create_times && $row['end_show_time'] >= $create_times) {
if ($this_data['s_time'] <= $create_times && $this_data['e_time'] >= $create_times) {
if ($row['start_show_time'] >= $this_data['s_time'] && $row['end_show_time'] <= $this_data['e_time']) {
$flag = 0;
} else {
$flag = 1;
}
} else {
$flag = 1;
}
} else {
$flag = 1;
}
}
if ($flag == 1) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=1 WHERE product_id='{$row['product_id']}' AND activity_id='{$id}' AND product_type=6";
} else {
if ($flag == 0) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=0 WHERE product_id='{$row['product_id']}' AND activity_id='{$id}' AND product_type=6";
}
}
$p_db->createCommand($sql)->execute();
}
}
} else {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=1 WHERE product_id='{$id}' AND product_type=4";
$p_db->createCommand($sql)->execute();
}
}
$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_edit', array('activity' => $activity));
}
