public function actionProduct_country_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$country = VcosCountry::model()->findByPk($id);
if ($_POST) {
$name = isset($_POST['name']) ? $_POST['name'] : '';
$name_en = isset($_POST['name_en']) ? $_POST['name_en'] : '';
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'basic_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'basic_images/' . Yii::app()->params['month'] . '/' . $photo;
$state = isset($_POST['state']) ? $_POST['state'] : '0';
// var_dump($_POST);exit;
//事务处理
$transaction = $p_db->beginTransaction();
try {
$country->country_cn_name = $name;
$country->country_en_name = $name_en;
if ($photo) {
$country->country_logo = $photo_url;
}
$country->status = $state;
$country->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Basic/product_country_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$this->render('product_country_edit', array('country' => $country));
}
public function actionNav_product_category_add()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$group = new VcosNavigationGroup();
$group_category = new VcosNavigationGroupCategory();
$nav = isset($_POST['nav']) ? $_POST['nav'] : 0;
$val = isset($_POST['val']) ? $_POST['val'] : 0;
$parent = isset($_POST['parent']) ? $_POST['parent'] : 0;
$name = isset($_POST['name']) ? $_POST['name'] : '';
$sort = isset($_POST['sort']) ? $_POST['sort'] : '';
$img_name = isset($_POST['img_name']) ? $_POST['img_name'] : '';
$cat_name = isset($_POST['cat_name']) ? $_POST['cat_name'] : '';
$highlight = isset($_POST['highlight']) ? $_POST['highlight'] : 0;
//var_dump($_POST);exit;
if ($val == 0 || $val == '') {
//新增
if ($parent == 0) {
$photo = '';
if ($_FILES[$img_name]['error'] != 4) {
$result = Helper::upload_file($img_name, Yii::app()->params['img_save_url'] . 'navigation_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'navigation_images/' . Yii::app()->params['month'] . '/' . $photo;
//事务处理
$transaction = $p_db->beginTransaction();
try {
$group->navigation_id = $nav;
$group->navigation_group_name = $name;
$group->sort_order = $sort;
$group->img_url = $photo_url;
$group->save();
//$id = $group->attributes['navigation_group_id'];
$transaction->commit();
Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '添加失败。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
}
} else {
//事务处理
$transaction = $p_db->beginTransaction();
try {
$group_category->navigation_group_id = $parent;
$group_category->navigation_category_name = $name;
$group_category->sort_order = $sort;
$group_category->is_highlight = $highlight;
$group_category->category_type = 1;
$group_category->mapping_id = $cat_name;
$group_category->save();
//$id = $group->attributes['navigation_group_id'];
$transaction->commit();
Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '添加失败。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
}
}
} else {
//修改
if ($parent == 0) {
$photo = '';
if ($_FILES[$img_name]['error'] != 4) {
$result = Helper::upload_file($img_name, Yii::app()->params['img_save_url'] . 'navigation_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'navigation_images/' . Yii::app()->params['month'] . '/' . $photo;
//事务处理
$transaction = $p_db->beginTransaction();
try {
if ($photo == '') {
$sql = "UPDATE `vcos_navigation_group` SET navigation_group_name='{$name}' WHERE navigation_group_id='{$val}'";
} else {
$sql = "UPDATE `vcos_navigation_group` SET navigation_group_name='{$name}',img_url='{$photo_url}' WHERE navigation_group_id='{$val}'";
}
Yii::app()->p_db->createCommand($sql)->execute();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
}
} else {
//事务处理
$transaction = $p_db->beginTransaction();
try {
$sql = "UPDATE `vcos_navigation_group_category` SET navigation_category_name='{$name}',mapping_id='{$cat_name}',is_highlight='{$highlight}' WHERE navigation_group_cid='{$val}'";
Yii::app()->p_db->createCommand($sql)->execute();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), Yii::app()->createUrl("Navigation/nav_column_set", array('nav' => $nav, 'act' => 'category', 'op' => 1)));
}
}
}
}
public function actionAd_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$ad = VcosAd::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_ad a LEFT JOIN vcos_ad_language b ON a.ad_id = b.ad_id WHERE a.ad_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$ad_language = VcosAdLanguage::model()->findByPk($id2['id']);
if ($_POST) {
/*
$photo='';
if($_FILES['photo']['error']!=4){
$result=Helper::upload_file('photo', Yii::app()->params['img_save_url'].'myad_images/'.Yii::app()->params['month'], 'image', 3);
$photo=$result['filename'];
}*/
$photo = '';
$photo_iso = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'myad_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
if (isset($_POST['language']) && $_POST['language'] != '') {
if ($_FILES['photo_iso']['error'] != 4) {
$result = Helper::upload_file('photo_iso', Yii::app()->params['img_save_url'] . 'myad_images/' . Yii::app()->params['month'], 'image', 3);
$photo_iso = $result['filename'];
}
}
/*
$photo_iso_url = '';
if($photo_iso){//判断有无上传图片
$photo_iso_url = 'myad_images/'.Yii::app()->params['month'].'/'.$photo_iso;
}*/
$photo_url = '';
if ($photo) {
//判断有无上传图片
$photo_url = 'myad_images/' . Yii::app()->params['month'] . '/' . $photo;
}
if ($_POST['type'] == 0) {
//模块
$link_url = "article?article_id=" . $_POST['link_model'];
if (isset($_POST['language']) && $_POST['language'] != '') {
$link_url_iso = "article?article_id=" . $_POST['link_model_iso'];
}
} else {
if ($_POST['type'] == 1) {
$link_url = $_POST['link_url'];
if (isset($_POST['language']) && $_POST['language'] != '') {
$link_url_iso = $_POST['link_url_iso'];
}
}
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('ad_state' => $state, 'ad_position' => $_POST['position'], 'link_type' => $_POST['type']);
$db->createCommand()->update('vcos_ad', $columns, 'ad_id = :id', array(':id' => $id));
//编辑系统语言
$l_colums = array('name' => $_POST['title'], 'link_url' => $link_url);
if ($photo) {
//判断有无上传图片
$l_colums['img_url'] = 'myad_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_ad_language', $l_colums, 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$columns = array('ad_id' => $id, 'iso' => $_POST['language'], 'name' => $_POST['title_iso'], 'link_url' => $link_url_iso);
if ($photo_iso) {
//判断有无上传图片
$columns['img_url'] = 'myad_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$db->createCommand()->insert('vcos_ad_language', $columns);
} else {
//编辑外语
$columns = array('name' => $_POST['title_iso'], 'link_url' => $link_url_iso);
if ($photo_iso) {
//判断有无上传图片
$columns['img_url'] = 'myad_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$db->createCommand()->update('vcos_ad_language', $columns, 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Ad/ad_list"));
} else {
//只编辑系统语言状态下
$ad->ad_id = $id;
$ad->ad_state = $state;
$ad->ad_position = $_POST['position'];
$ad->link_type = $_POST['type'];
$ad->save();
$ad_language->id = $id2['id'];
$ad_language->name = $_POST['title'];
if ($photo) {
//判断有无上传图片
$ad_language->img_url = 'myad_images/' . Yii::app()->params['month'] . '/' . $photo;
}
//$ad_language->img_url = $photo_url;
$ad_language->link_url = $link_url;
$ad_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Ad/ad_list"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$sql = "SELECT a.article_id,b.article_title FROM `vcos_article` a LEFT JOIN `vcos_article_language` b ON a.article_id = b.article_id WHERE b.iso = 'zh_cn' AND a.article_state = '1'";
$title_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
$sql = "SELECT a.article_id,b.article_title FROM `vcos_article` a LEFT JOIN `vcos_article_language` b ON a.article_id = b.article_id WHERE b.iso = 'en' AND a.article_state = '1'";
$title_en_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
$position = VcosAdPosition::model()->findAll();
$this->render('ad_edit', array('title_sel' => $title_sel, 'title_en_sel' => $title_en_sel, 'ad' => $ad, 'position' => $position, 'ad_language' => $ad_language));
}
public function actionProduct_graphic_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$product_graphic = VcosProductGraphic::model()->findByPk($id);
if ($_POST) {
$product = isset($_POST['product']) ? $_POST['product'] : 0;
$desc = isset($_POST['desc']) ? $_POST['desc'] : '';
$sort = isset($_POST['sort']) ? $_POST['sort'] : 0;
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'product_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'product_images/' . Yii::app()->params['month'] . '/' . $photo;
//事务处理
$transaction = $p_db->beginTransaction();
try {
$product_graphic->product_id = $product;
if ($desc != '') {
$product_graphic->graphic_desc = $desc;
}
if ($photo) {
$product_graphic->img_url = $photo_url;
}
$product_graphic->sort_order = $sort;
$product_graphic->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Product/product_graphic_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$sql = "SELECT category_code FROM `vcos_product` WHERE product_id=" . $product_graphic['product_id'];
$category_code = Yii::app()->p_db->createCommand($sql)->queryRow();
$category_code = $category_code['category_code'];
$sql = "SELECT parent_cid FROM `vcos_category` WHERE category_code =" . $category_code;
$layer_cat_2 = $p_db->createCommand($sql)->queryRow();
$sql = "SELECT parent_cid FROM `vcos_category` WHERE category_code =" . $layer_cat_2['parent_cid'];
$layer_cat_1 = $p_db->createCommand($sql)->queryRow();
$sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE parent_cid=0";
$layer_1 = $p_db->createCommand($sql)->queryAll();
$sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE parent_cid=" . $layer_cat_1['parent_cid'];
$layer_2 = $p_db->createCommand($sql)->queryAll();
$sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE parent_cid=" . $layer_cat_2['parent_cid'];
$layer_3 = $p_db->createCommand($sql)->queryAll();
$sql = "SELECT product_id,product_name FROM `vcos_product` WHERE category_code=" . $category_code;
$product = $p_db->createCommand($sql)->queryAll();
$layer_cat = $layer_cat_1['parent_cid'];
$layer_cat2 = $layer_cat_2['parent_cid'];
$this->render('product_graphic_edit', array('product_graphic' => $product_graphic, 'product' => $product, 'layer_cat' => $layer_cat, 'layer_cat2' => $layer_cat2, 'layer_1' => $layer_1, 'layer_2' => $layer_2, 'layer_3' => $layer_3, 'category_code' => $category_code));
}
public function actionGoods_category_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$category = VcosDutyfreeGoodsCategory::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_dutyfree_goods_category a LEFT JOIN vcos_dutyfree_goods_category_language b ON a.gc_id = b.gc_id WHERE a.gc_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$category_language = VcosDutyfreeGoodsCategoryLanguage::model()->findByPk($id2['id']);
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'dutyfreegoods_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
if ($state == '0') {
$result = VcosDutyfreeGoods::model()->count('goods_category=:id', array(':id' => $id));
if ($result > 0) {
die(Helper::show_message(yii::t('vcos', '此分类正在使用,不能禁用。')));
}
}
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('state' => $state, 'bg_color' => $_POST['bgcolor']);
if ($photo) {
//判断有无上传图片
$columns['gc_img_url'] = 'dutyfreegoods_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_dutyfree_goods_category', $columns, 'gc_id = :id', array(':id' => $id));
//编辑系统语言
$db->createCommand()->update('vcos_dutyfree_goods_category_language', array('gc_name' => $_POST['title']), 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$db->createCommand()->insert('vcos_dutyfree_goods_category_language', array('gc_id' => $id, 'iso' => $_POST['language'], 'gc_name' => $_POST['title_iso']));
} else {
//编辑外语
$db->createCommand()->update('vcos_dutyfree_goods_category_language', array('gc_name' => $_POST['title_iso']), 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Dutyfreegoods/Goods_category"));
} else {
//只编辑系统语言
$category->gc_id = $id;
$category->bg_color = $_POST['bgcolor'];
$category->state = $state;
if ($photo) {
$category->gc_img_url = 'dutyfreegoods_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$category->save();
$category_language->id = $id2['id'];
$category_language->gc_name = $_POST['title'];
$category_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Dutyfreegoods/Goods_category"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$this->render('goods_category_edit', array('category' => $category, 'category_language' => $category_language));
}
public function actionRoom_detail_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$detail = VcosRoomDetail::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_room_detail a LEFT JOIN vcos_room_detail_language b ON a.detail_id = b.detail_id WHERE a.detail_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$detail_language = VcosRoomDetailLanguage::model()->findByPk($id2['id']);
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'room_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
//匹配替换编辑器中图片路径
$msg = $_POST['describe'];
$img_ueditor = Yii::app()->params['img_ueditor_php'];
$describe = preg_replace($img_ueditor, '', $msg);
if ($_POST['describe_iso'] != '') {
$msg_iso = $_POST['describe_iso'];
$describe_iso = preg_replace($img_ueditor, '', $msg_iso);
}
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('room_id' => $_POST['room'], 'detail_state' => $state);
if ($photo) {
//判断有无上传图片
$columns['room_img_url'] = 'room_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_room_detail', $columns, 'detail_id = :id', array(':id' => $id));
//编辑系统语言
$db->createCommand()->update('vcos_room_detail_language', array('room_describe' => $describe), 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$db->createCommand()->insert('vcos_room_detail_language', array('detail_id' => $id, 'iso' => $_POST['language'], 'room_describe' => $describe_iso));
} else {
//编辑外语
$db->createCommand()->update('vcos_room_detail_language', array('room_describe' => $describe_iso), 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Room/room_detail"));
} else {
//只编辑系统语言状态下
$detail->detail_id = $id;
$detail->room_id = $_POST['room'];
$detail->detail_state = $state;
if ($photo != '') {
$detail->room_img_url = 'room_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$detail->save();
$detail_language->id = $id2['id'];
$detail_language->room_describe = $describe;
$detail_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Room/room_detail"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$sql = "SELECT * FROM vcos_room a LEFT JOIN vcos_room_language b ON a.room_id = b.room_id WHERE a.room_state = '1' AND b.iso = '" . Yii::app()->language . "'";
$room = Yii::app()->m_db->createCommand($sql)->queryAll();
$this->render('room_detail_edit', array('room' => $room, 'detail' => $detail, 'detail_language' => $detail_language));
}
public function actionService_img_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$lifeservice_img = VcosLifeserviceImg::model()->findByPk($id);
$sql = "SELECT ls_category FROM `vcos_lifeservice` WHERE ls_id = " . $lifeservice_img['lifeservice_id'];
$lifeservice_category = Yii::app()->m_db->createCommand($sql)->queryRow();
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'lifeservice_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$iso = isset($_POST['language']) ? $_POST['language'] : 'zh_cn';
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
$lifeservice_img->id = $id;
$lifeservice_img->lifeservice_id = $_POST['life_category'];
$lifeservice_img->state = $state;
$lifeservice_img->iso = $iso;
if ($photo) {
$lifeservice_img->img_url = 'lifeservice_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$lifeservice_img->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Lifeservice/Service_img_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$life_sql = "SELECT a.lc_id,b.lc_name FROM vcos_lifeservice_category a LEFT JOIN vcos_lifeservice_category_language b ON a.lc_id = b.lc_id WHERE b.iso = '" . Yii::app()->language . "' AND a.lc_state = '1'";
$lifeservice_sel = Yii::app()->m_db->createCommand($life_sql)->queryAll();
$sql = "SELECT a.ls_id,b.ls_title FROM vcos_lifeservice a LEFT JOIN vcos_lifeservice_language b ON a.ls_id = b.ls_id WHERE (a.ls_state = '1' OR a.ls_id={$lifeservice_img['lifeservice_id']}) AND b.iso = '" . Yii::app()->language . "' AND a.ls_category = " . $lifeservice_category['ls_category'];
$life_title_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
$this->render('service_img_edit', array('life_title_sel' => $life_title_sel, 'lifeservice_sel' => $lifeservice_sel, 'lifeservice_img' => $lifeservice_img, 'lifeservice_category' => $lifeservice_category['ls_category']));
}
public function actionArticle_edit()
{
$this->setauth();
// 检查有无权限
$id = $_GET['id'];
$article = VcosArticle::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_article a LEFT JOIN vcos_article_language b ON a.article_id = b.article_id WHERE a.article_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$article_language = VcosArticleLanguage::model()->findByPk($id2['id']);
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'article_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$times = date("Y/m/d H:i:s", time());
$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));
// 匹配替换编辑器中图片路径
$msg = $_POST['contents'];
$img_ueditor = Yii::app()->params['img_ueditor_php'];
$describe = preg_replace($img_ueditor, '', $msg);
if ($_POST['contents_iso'] != '') {
$msg_iso = $_POST['contents_iso'];
$describe_iso = preg_replace($img_ueditor, '', $msg_iso);
}
// 事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
// 编辑系统语言和外语状态下
// 编辑主表
$columns = array('article_time' => $times, 'article_start_time' => $stime, 'article_end_time' => $etime, 'article_state' => $state);
if ($photo) {
// 判断有无上传图片
$columns['article_img_url'] = 'article_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_article', $columns, 'article_id = :id', array(':id' => $id));
// 编辑系统语言
$db->createCommand()->update('vcos_article_language', array('article_title' => $_POST['title'], 'article_abstract' => $_POST['abstract'], 'article_content' => $describe), 'id=:id', array(':id' => $id2['id']));
// 判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
// 新增外语
$db->createCommand()->insert('vcos_article_language', array('article_id' => $id, 'iso' => $_POST['language'], 'article_title' => $_POST['title_iso'], 'article_abstract' => $_POST['abstract_iso'], 'article_content' => $describe_iso));
} else {
// 编辑外语
$db->createCommand()->update('vcos_article_language', array('article_title' => $_POST['title_iso'], 'article_abstract' => $_POST['abstract_iso'], 'article_content' => $describe_iso), 'id=:id', array(':id' => $_POST['judge']));
}
// 事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Article/Article_list"));
} else {
// 只编辑系统语言
$article->article_id = $id;
$article->article_time = $times;
$article->article_start_time = $stime;
$article->article_end_time = $etime;
$article->article_state = $state;
if ($photo) {
$article->article_img_url = 'article_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$article->save();
$article_language->id = $id2['id'];
$article_language->article_content = $describe;
$article_language->article_title = $_POST['title'];
$article_language->article_abstract = $_POST['abstract'];
$article_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Article/Article_list"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$this->render('article_edit', array('article' => $article, 'article_language' => $article_language));
}
public function actionCommentandhelp_category_edit()
{
if ($this->auth[0] == '0') {
$access = TRUE;
} else {
$error = Yii::app()->createUrl('error/index');
$this->redirect($error);
}
$id = $_GET['id'];
$category = VcosCommentAndHelpCategory::model()->findByPk($id);
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'system_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
if ($_POST['name'] != '' && $_POST['url'] != '' && $_POST['bgcolor'] != '') {
$category->id = $id;
$category->cnh_category_name = $_POST['name'];
$category->cnh_herf_url = $_POST['url'];
$category->bg_color = $_POST['bgcolor'];
$category->state = $state;
if ($photo) {
$old = Yii::app()->params['img_save_url'] . $category['cnh_img_url'];
if (file_exists($old) && $category['cnh_img_url']) {
unlink($old);
}
$category->cnh_img_url = 'system_images/' . Yii::app()->params['month'] . '/' . $photo;
}
if ($category->save() > 0) {
Helper::show_message(yii::t('vcos', '修改成功'), Yii::app()->createUrl("Systemsetting/Commentandhelp_category"));
} else {
Helper::show_message(yii::t('vcos', '修改失败'));
}
} else {
Helper::show_message(yii::t('vcos', '修改失败'));
}
}
$this->render('commentandhelp_category_edit', array('category' => $category));
}
public function actionMain_nav_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$main_nav = VcosMainNav::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_main_nav a LEFT JOIN vcos_main_nav_language b ON a.nav_id = b.nav_id WHERE a.nav_id = {$id} AND b.iso ='" . Yii::app()->language . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$main_nav_language = VcosMainNavLanguage::model()->findByPk($id2['id']);
if ($_POST) {
$photo = '';
$photo_iso = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'main_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
if (isset($_POST['language']) && $_POST['language'] != '') {
if ($_FILES['photo_iso']['error'] != 4) {
$result = Helper::upload_file('photo_iso', Yii::app()->params['img_save_url'] . 'main_images/' . Yii::app()->params['month'], 'image', 3);
$photo_iso = $result['filename'];
}
}
$photo_url = '';
if ($photo) {
//判断有无上传图片
$photo_url = 'main_images/' . Yii::app()->params['month'] . '/' . $photo;
}
//$state = isset($_POST['state'])?$_POST['state']:'0';
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('state' => $_POST['state'], 'sequence' => $_POST['sequence'], 'category_id' => $_POST['category']);
$db->createCommand()->update('vcos_main_nav', $columns, 'nav_id = :id', array(':id' => $id));
//编辑系统语言
$columns = array('name' => $_POST['name'], 'bg_color' => $_POST['bgcolor']);
if ($photo) {
//判断有无上传图片
$columns['img_url'] = 'main_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_main_nav_language', $columns, 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$columns = array('nav_id' => $id, 'iso' => $_POST['language'], 'name' => $_POST['name_iso'], 'bg_color' => $_POST['bgcolor']);
if ($photo_iso) {
//判断有无上传图片
$columns['img_url'] = 'main_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$db->createCommand()->insert('vcos_main_nav_language', $columns);
} else {
//编辑外语
$columns = array('name' => $_POST['name_iso'], 'bg_color' => $_POST['bgcolor']);
if ($photo_iso) {
//判断有无上传图片
$columns['img_url'] = 'main_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$db->createCommand()->update('vcos_main_nav_language', $columns, 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Main/Main_nav_list"));
} else {
//只编辑系统语言状态下
$main_nav->nav_id = $id;
$main_nav->state = $_POST['state'];
$main_nav->sequence = $_POST['sequence'];
$main_nav->category_id = $_POST['category'];
$main_nav->save();
$main_nav_language->id = $id2['id'];
$main_nav_language->name = $_POST['name'];
$main_nav_language->bg_color = $_POST['bgcolor'];
//$main_nav_language->img_url = $photo_url;
if ($photo) {
//判断有无上传图片
$main_nav_language->img_url = 'main_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$main_nav_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Main/Main_nav_list"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$sql = "SELECT a.main_id,b.name FROM `vcos_main_category` a LEFT JOIN `vcos_main_category_language` b ON a.main_id = b.main_id WHERE a.state = '1' AND b.iso = '" . Yii::app()->language . "'";
$category_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
$this->render('main_nav_edit', array('category_sel' => $category_sel, 'main_nav' => $main_nav, 'main_nav_language' => $main_nav_language));
}
public function actionBrand_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$brand = VcosBrand::model()->findByPk($id);
if ($_POST) {
$name = isset($_POST['name']) ? $_POST['name'] : '';
$names = isset($_POST['names']) ? $_POST['names'] : '';
$country = isset($_POST['country']) ? $_POST['country'] : 0;
$desc = isset($_POST['desc']) ? $_POST['desc'] : '';
$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';
//事务处理
$transaction = $p_db->beginTransaction();
try {
$brand->brand_cn_name = $name;
$brand->brand_en_name = $names;
$brand->country_id = $country;
$brand->brand_desc = $desc;
$brand->brand_status = $state;
if ($photo) {
$brand->brand_logo = $photo_url;
}
$brand->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Brand/brand_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$sql = "SELECT country_id,country_cn_name FROM `vcos_country` WHERE status =1";
$country = Yii::app()->p_db->createCommand($sql)->queryAll();
$this->render('brand_edit', array('brand' => $brand, 'country' => $country));
}
public function actionShop_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$shop = VcosShop::model()->findByPk($id);
if ($_POST) {
$code = isset($_POST['code']) ? $_POST['code'] : '';
$name = isset($_POST['name']) ? $_POST['name'] : '';
$desc = isset($_POST['desc']) ? $_POST['desc'] : '';
$people = isset($_POST['people']) ? $_POST['people'] : '';
$company = isset($_POST['company']) ? $_POST['company'] : '';
$address = isset($_POST['address']) ? $_POST['address'] : '';
$price = isset($_POST['price']) ? $_POST['price'] * 100 : '';
$products = isset($_POST['products']) ? $_POST['products'] : '';
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo;
$photo1 = '';
if ($_FILES['photo1']['error'] != 4) {
$result = Helper::upload_file('photo1', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo1 = $result['filename'];
}
$photo_url1 = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo1;
$photo2 = '';
if ($_FILES['photo2']['error'] != 4) {
$result = Helper::upload_file('photo2', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo2 = $result['filename'];
}
$photo_url2 = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo2;
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$create_times = date("Y/m/d H:i:s", time());
$cruise_id = Yii::app()->params['cruise_id'];
//事务处理
$transaction = $p_db->beginTransaction();
try {
$shop->shop_code = $code;
$shop->shop_title = $name;
if ($photo) {
$shop->shop_logo = $photo_url;
}
if ($photo1) {
$shop->shop_img_url = $photo_url1;
}
if ($photo2) {
$shop->business_license = $photo_url2;
}
$shop->shop_desc = $desc;
$shop->legal_representative = $people;
$shop->company_name = $company;
$shop->shop_address = $address;
$shop->cash_deposit = $price;
$shop->main_products = $products;
$shop->created = $create_times;
$shop->shop_status = $state;
$shop->cruise_id = $cruise_id;
$shop->save();
//修改活动商品（栏目页面配置是否有效问题）
$sql = "SELECT is_delete FROM `vcos_shop` WHERE shop_id='{$id}'";
$this_data = Yii::app()->p_db->createCommand($sql)->queryRow();
if ($state == 0) {
$flag = 1;
} else {
if ($state == 1) {
if ($this_data['is_delete'] == 1) {
$flag = 1;
} else {
$flag = 0;
}
}
}
if ($flag == 1) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=1 WHERE product_id='{$id}' AND product_type=3";
} else {
if ($flag == 0) {
$sql = "UPDATE `vcos_activity_product` SET is_overdue=0 WHERE product_id='{$id}' AND product_type=3";
}
}
$p_db->createCommand($sql)->execute();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Shop/shop_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$sql = "SELECT a.*,b.name,c.name parent_name FROM `vcos_shop_operation_category` a LEFT JOIN `vcos_category` b ON a.category_code=b.category_code LEFT JOIN `vcos_category` c ON a.parent_catogory_code=c.category_code WHERE a.status=1 AND a.shop_id=" . $id;
$shop_operation = Yii::app()->p_db->createCommand($sql)->queryAll();
$shop_operation = self::shopsortOut($shop_operation);
//var_dump($shop_operation);exit;
$sql = "SELECT * FROM `vcos_shop_category` a LEFT JOIN\r\n\t\t(SELECT parent_cid,count(parent_cid) count FROM `vcos_shop_category` b WHERE shop_id=" . $id . " GROUP BY parent_cid) b ON a.parent_cid=b.parent_cid\r\n\t\tWHERE a.shop_id=" . $id . " ORDER BY sort_order";
$shop_cat = $p_db->createCommand($sql)->queryAll();
$shop_cat = self::sortOut($shop_cat);
$this->render('shop_edit', array('shop_cat' => $shop_cat, 'shop' => $shop, 'auth' => $this->auth, 'shop_operation' => $shop_operation));
}
public function actionRestaurant_img_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$restaurant_img = VcosRestaurantImg::model()->findByPk($id);
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'restaurant_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$iso = isset($_POST['language']) ? $_POST['language'] : 'zh_cn';
/*
if($state == '0'){
$result = VcosRestaurantImg::model()->count('id=:id',array(':id'=>$id));
if($result>0){
die(Helper::show_message(yii::t('vcos', '此分类正在使用,不能禁用')));
}
}*/
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
$restaurant_img->id = $id;
$restaurant_img->restaurant_id = $_POST['restaurant'];
$restaurant_img->state = $state;
$restaurant_img->iso = $iso;
if ($photo) {
$restaurant_img->img_url = 'restaurant_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$restaurant_img->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Restaurant/Restaurant_img_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$res_sql = "SELECT a.restaurant_id,b.restaurant_name FROM vcos_restaurant a LEFT JOIN vcos_restaurant_language b ON a.restaurant_id = b.restaurant_id WHERE b.iso = '" . Yii::app()->language . "' AND a.restaurant_state = '1'";
$restaurant_sel = Yii::app()->m_db->createCommand($res_sql)->queryAll();
$this->render('restaurant_img_edit', array('restaurant_sel' => $restaurant_sel, 'restaurant_img' => $restaurant_img));
}
public function actionNotice_to_visitors_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$notice_to_visitors = VcosNoticeToVisitors::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_notice_to_visitors a LEFT JOIN vcos_notice_to_visitors_language b ON a.id = b.n_id WHERE a.id = {$id} AND b.iso ='" . Yii::app()->language . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$notice_to_visitors_language = VcosNoticeToVisitorsLanguage::model()->findByPk($id2['id']);
if ($_POST) {
$photo = '';
$photo_iso = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'safe_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
if (isset($_POST['language']) && $_POST['language'] != '') {
if ($_FILES['photo_iso']['error'] != 4) {
$result = Helper::upload_file('photo_iso', Yii::app()->params['img_save_url'] . 'safe_images/' . Yii::app()->params['month'], 'image', 3);
$photo_iso = $result['filename'];
}
}
$state = isset($_POST['state']) ? $_POST['state'] : '0';
//匹配替换编辑器中图片路径
$msg = $_POST['describe'];
$img_ueditor = Yii::app()->params['img_ueditor_php'];
$describe = preg_replace($img_ueditor, '', $msg);
if ($_POST['describe_iso'] != '') {
$msg_iso = $_POST['describe_iso'];
$describe_iso = preg_replace($img_ueditor, '', $msg_iso);
}
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('state' => $state, 'sort_order' => $_POST['sort'], 'category_id' => $_POST['category']);
$db->createCommand()->update('vcos_notice_to_visitors', $columns, 'id = :id', array(':id' => $id));
if ($photo_iso) {
//判断有无上传图片
$photo_iso_url = 'safe_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$columns_iso = array('content' => $describe);
if ($photo != '') {
//判断有无上传图片
$columns_iso['img_url'] = 'safe_images/' . Yii::app()->params['month'] . '/' . $photo;
}
//编辑系统语言
$db->createCommand()->update('vcos_notice_to_visitors_language', $columns_iso, 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$db->createCommand()->insert('vcos_notice_to_visitors_language', array('n_id' => $id, 'iso' => $_POST['language'], 'img_url' => $photo_iso_url, 'content' => $describe_iso));
} else {
//编辑外语
$columns_iso_language = array('content' => $describe_iso);
if ($photo_iso != '') {
//判断有无上传图片
$columns_iso_language['img_url'] = 'safe_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
}
$db->createCommand()->update('vcos_notice_to_visitors_language', $columns_iso_language, 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Safe/notice_to_visitors"));
} else {
//只编辑系统语言状态下
$notice_to_visitors->state = $state;
$notice_to_visitors->sort_order = $_POST['sort'];
$notice_to_visitors->category_id = $_POST['category'];
$notice_to_visitors->save();
$notice_to_visitors_language->id = $id2['id'];
if ($photo != '') {
//判断有无上传图片
$notice_to_visitors_language->img_url = 'safe_images/' . Yii::app()->params['month'] . '/' . $photo;
}
//$cruise_deck_point_language->img_url = 'cruiseinfo_images/'.Yii::app()->params['month'].'/'.$photo_iso;
$notice_to_visitors_language->content = $describe;
$notice_to_visitors_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Safe/notice_to_visitors"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$sql = "SELECT a.id,b.category_name FROM `vcos_notice_to_visitors_category` a LEFT JOIN `vcos_notice_to_visitors_category_language` b ON a.id=b.category_id WHERE a.state = 1 AND b.iso = '" . Yii::app()->language . "'";
$category_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
$this->render('notice_to_visitors_edit', array('category_sel' => $category_sel, 'notice_to_visitors' => $notice_to_visitors, 'notice_to_visitors_language' => $notice_to_visitors_language));
}
public function actionCruise_model_edit()
{
$this->setauth();
//检查有无权限
//获取当前配置的默认邮轮
$cruise_id = Yii::app()->params['cruise_id'];
$sql = "SELECT * FROM `vcos_cruise_model` WHERE cruise_id='{$cruise_id}' LIMIT 1";
$model = Yii::app()->m_db->createCommand($sql)->queryRow();
//判断是否提交需判断
if ($model) {
$act = 1;
} else {
$act = 0;
}
if ($_POST) {
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'cruiseinfo_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo1 = '';
if ($_FILES['photo1']['error'] != 4) {
$result = Helper::upload_file('photo1', Yii::app()->params['img_save_url'] . 'cruiseinfo_images/' . Yii::app()->params['month'], 'image', 3);
$photo1 = $result['filename'];
}
$photo_url = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo;
$photo1_url = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo1;
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
$sql = '';
$sql_u = '';
if ($photo != '' && $photo1 != '') {
$sql = "INSERT INTO `vcos_cruise_model` (cruise_id,img_back,img_back_over) values ('{$cruise_id}','{$photo_url}','{$photo1_url}')";
$sql_u = "UPDATE `vcos_cruise_model` set img_back='{$photo_url}',img_back_over='{$photo1_url}' WHERE cruise_id='{$cruise_id}'";
} else {
if ($photo != '' && $photo1 == '') {
$sql = "INSERT INTO `vcos_cruise_model` (cruise_id,img_back) values ('{$cruise_id}','{$photo_url}')";
$sql_u = "UPDATE `vcos_cruise_model` set img_back='{$photo_url}' WHERE cruise_id='{$cruise_id}'";
} else {
if ($photo == '' && $photo1 != '') {
$sql = "INSERT INTO `vcos_cruise_model` (cruise_id,img_back_over) values ('{$cruise_id}','{$photo1_url}')";
$sql_u = "UPDATE `vcos_cruise_model` set img_back_over='{$photo1_url}' WHERE cruise_id='{$cruise_id}'";
}
}
}
if ($sql != '' || $sql_u != '') {
if ($act == 1) {
Yii::app()->m_db->createCommand($sql_u)->execute();
} else {
Yii::app()->m_db->createCommand($sql)->execute();
}
}
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Cruiseinfo/cruise_model_edit"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'), '#');
}
}
$this->render('cruise_model_edit', array('model' => $model, 'act' => $act));
}
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 actionNavigation_group_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$navigation_group = VcosNavigationGroup::model()->findByPk($id);
if ($_POST) {
$name = isset($_POST['name']) ? $_POST['name'] : '';
$navigation = isset($_POST['navigation']) ? $_POST['navigation'] : 0;
$activity = isset($_POST['activity']) ? $_POST['activity'] : 0;
$sort = isset($_POST['sort']) ? $_POST['sort'] : '0';
$group_type = isset($_POST['group_type']) ? $_POST['group_type'] : '0';
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'navigation_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo_url = 'navigation_images/' . Yii::app()->params['month'] . '/' . $photo;
//事务处理
$transaction = $p_db->beginTransaction();
try {
$navigation_group->navigation_group_name = $name;
$navigation_group->navigation_id = $navigation;
$navigation_group->activity_id = $activity;
$navigation_group->img_url = $photo_url;
$navigation_group->sort_order = $sort;
$navigation_group->status = $state;
$navigation_group->show_type = $group_type;
$navigation_group->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/navigation_group_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();
$sql = "SELECT navigation_id,navigation_name FROM `vcos_navigation` WHERE is_category=1 AND status=1";
$navigation = Yii::app()->p_db->createCommand($sql)->queryAll();
$this->render('navigation_group_edit', array('activity' => $activity, 'navigation' => $navigation, 'navigation_group' => $navigation_group));
}
public function actionShop_edit()
{
$this->setauth();
//检查有无权限
$p_db = Yii::app()->p_db;
$id = $_GET['id'];
$shop = VcosShop::model()->findByPk($id);
if ($_POST) {
$code = isset($_POST['code']) ? $_POST['code'] : '';
$name = isset($_POST['name']) ? $_POST['name'] : '';
$desc = isset($_POST['desc']) ? $_POST['desc'] : '';
$people = isset($_POST['people']) ? $_POST['people'] : '';
$company = isset($_POST['company']) ? $_POST['company'] : '';
$address = isset($_POST['address']) ? $_POST['address'] : '';
$price = isset($_POST['price']) ? $_POST['price'] * 100 : '';
$products = isset($_POST['products']) ? $_POST['products'] : '';
$photo = '';
if ($_FILES['photo']['error'] != 4) {
$result = Helper::upload_file('photo', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo = $result['filename'];
}
$photo1 = '';
if ($_FILES['photo1']['error'] != 4) {
$result = Helper::upload_file('photo1', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo1 = $result['filename'];
}
$photo2 = '';
if ($_FILES['photo2']['error'] != 4) {
$result = Helper::upload_file('photo2', Yii::app()->params['img_save_url'] . 'shop_images/' . Yii::app()->params['month'], 'image', 3);
$photo1 = $result['filename'];
}
$photo_url2 = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo2;
$photo_url1 = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo1;
$photo_url = 'shop_images/' . Yii::app()->params['month'] . '/' . $photo;
$state = isset($_POST['state']) ? $_POST['state'] : '0';
$create_times = date("Y/m/d H:i:s", time());
$cruise_id = Yii::app()->params['cruise_id'];
//事务处理
$transaction = $p_db->beginTransaction();
try {
$shop->shop_code = $code;
$shop->shop_title = $name;
if ($photo) {
$shop->shop_logo = $photo_url;
}
if ($photo1) {
$shop->business_license = $photo_url1;
}
if ($photo2) {
$shop->shop_img_url = $photo_url2;
}
$shop->shop_desc = $desc;
$shop->legal_representative = $people;
$shop->company_name = $company;
$shop->shop_address = $address;
$shop->cash_deposit = $price;
$shop->main_products = $products;
$shop->created = $create_times;
$shop->shop_status = $state;
$shop->cruise_id = $cruise_id;
$shop->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Shop/shop_list"));
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$this->render('shop_edit', array('shop' => $shop));
}
/**
* 活动编辑*
*/
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));
}
