Ejemplo n.º 1
0
 public static function upload_file($input_name, $file_path = './', $type = 'image', $allow_size = 2)
 {
     // 上传的文件
     $file = $_FILES[$input_name];
     // 错误信息
     $error = '';
     // 允许上传的文件类型数组
     $allow_type = array('image' => array('jpg' => 'image/jpeg', 'png' => 'image/png', 'gif' => 'image/gif'));
     // 检查上传文件的类型是否在允许的文件类型数组里
     if (!in_array($file['type'], $allow_type[$type])) {
         $error = "请上传" . implode('、', array_keys($allow_type[$type])) . "格式的文件";
         Helper::show_message($error);
         die;
     }
     // 检查上传文件的大小是否超过指定大小
     $size = $allow_size * 1024 * 1024;
     if ($file['size'] > $size) {
         $error = "你上传的文件大小请不要超过{$allow_size}MB";
         Helper::show_message($error);
         die;
     }
     // 错误状态
     switch ($file['error']) {
         case 1:
             $error = '你所上传的文件大小超过了服务器配置的大小';
             Helper::show_message($error);
             die;
         case 2:
             $error = '你所上传的文件大小超过了表单设置的大小';
             Helper::show_message($error);
             die;
         case 3:
             $error = '网络出现问题,请检查你的网络是否连接?';
             Helper::show_message($error);
             die;
         case 4:
             $error = '请选择你要上传的文件';
             Helper::show_message($error);
             die;
     }
     // 自动生成目录
     if (!file_exists($file_path)) {
         mkdir($file_path, 0777, true);
     }
     if ($error) {
         return array('error' => 1, 'warning' => $error);
     }
     // 生成保存到服务器的文件名
     $filename = date('YmdHis') . mt_rand(1000, 9999) . "." . array_search($file['type'], $allow_type[$type]);
     // 保存上传文件到本地目录
     if (move_uploaded_file($file['tmp_name'], $file_path . "/" . $filename)) {
         return array('error' => 0, 'filename' => $filename);
     }
 }
Ejemplo n.º 2
0
 /**
  * 编辑活动分类*
  */
 public function actionActivity_category_edit()
 {
     $this->setauth();
     // 检查有无权限
     $p_db = Yii::app()->p_db;
     $id = $_GET['id'];
     $activity_category = VcosActivityCategory::model()->findByPk($id);
     if ($_POST) {
         $activity = isset($_POST['activity']) ? $_POST['activity'] : 0;
         $name = isset($_POST['name']) ? $_POST['name'] : '';
         $sort = isset($_POST['sort']) ? $_POST['sort'] : '';
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         // 事务处理
         $transaction = $p_db->beginTransaction();
         try {
             $activity_category->activity_id = $activity;
             $activity_category->activity_category_name = $name;
             $activity_category->sort_order = $sort;
             $activity_category->status = $state;
             $activity_category->save();
             $transaction->commit();
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Activity/activity_category_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('activity_category_edit', array('activity_category' => $activity_category, 'activity' => $activity));
 }
Ejemplo n.º 3
0
 public function actionActivity_product_edit()
 {
     $this->setauth();
     //检查有无权限
     $p_db = Yii::app()->p_db;
     $id = $_GET['id'];
     $layer_cat = '';
     $layer_cat2 = '';
     $layer_1 = '';
     $layer_2 = '';
     $layer_3 = '';
     $product_sel = '';
     $category_code = '';
     $activity_product = VcosActivityProduct::model()->findByPk($id);
     if ($_POST) {
         $activicty = isset($_POST['activity']) ? $_POST['activity'] : 0;
         $product = isset($_POST['product']) ? $_POST['product'] : 0;
         $shop = isset($_POST['shop']) ? $_POST['shop'] : 0;
         $activity_child = isset($_POST['activity_child']) ? $_POST['activity_child'] : 0;
         $activity_category = isset($_POST['activity_category']) ? $_POST['activity_category'] : 0;
         $sort = isset($_POST['sort']) ? $_POST['sort'] : '';
         $product_type = isset($_POST['product_type']) ? $_POST['product_type'] : 0;
         $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));
         if ($product_type == 3) {
             $product_shop = $shop;
             $activity_category = '';
         } elseif ($product_type == 6) {
             $product_shop = $product;
             $activity_category = $activity_category;
         } elseif ($product_type == 4) {
             $product_shop = $activity_child;
             $activity_category = '';
         }
         //事务处理
         $transaction = $p_db->beginTransaction();
         try {
             $activity_product->activity_id = $activicty;
             $activity_product->product_id = $product_shop;
             $activity_product->activity_cid = $activity_category;
             $activity_product->sort_order = $sort;
             $activity_product->start_show_time = $stime;
             $activity_product->end_show_time = $etime;
             $activity_product->product_type = $product_type;
             $activity_product->save();
             $transaction->commit();
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Activity/activity_product_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 product_id,product_name FROM `vcos_product` WHERE status=1";
     //$product = Yii::app()->p_db->createCommand($sql)->queryAll();
     $sql = "SELECT activity_cid,activity_category_name FROM `vcos_activity_category` WHERE status=1 AND activity_id = " . $activity_product['activity_id'];
     $activity_category = Yii::app()->p_db->createCommand($sql)->queryAll();
     $sql = "SELECT shop_id,shop_title FROM `vcos_shop` ";
     $shop = Yii::app()->p_db->createCommand($sql)->queryAll();
     $sql = "SELECT activity_id,activity_name FROM `vcos_activity` WHERE activity_id !=" . $activity[0]['activity_id'];
     $activity_child = Yii::app()->p_db->createCommand($sql)->queryAll();
     if ($activity_product['product_type'] == 6) {
         $sql = "SELECT category_code FROM `vcos_product` WHERE product_id=" . $activity_product['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'];
     } else {
         $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_1[0]['category_code'];
         $layer_2 = $p_db->createCommand($sql)->queryAll();
         $sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE parent_cid=" . $layer_2[0]['category_code'];
         $layer_3 = $p_db->createCommand($sql)->queryAll();
         $sql = "SELECT product_id,product_name,category_code FROM `vcos_product` WHERE status=1 AND category_code=" . $layer_3[0]['category_code'];
         $product = Yii::app()->p_db->createCommand($sql)->queryAll();
     }
     $this->render('activity_product_edit', array('activity_child' => $activity_child, 'shop' => $shop, 'activity' => $activity, 'product' => $product, 'activity_category' => $activity_category, 'activity_product' => $activity_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));
 }
Ejemplo n.º 4
0
 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));
 }
Ejemplo n.º 5
0
 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)));
             }
         }
     }
 }
Ejemplo n.º 6
0
 public function actionShop_operation()
 {
     $this->setauth();
     //检查有无权限
     $p_db = Yii::app()->p_db;
     if ($_POST) {
         $str_sql = '';
         $str_cat2 = array();
         $str_cat1 = array();
         $shop = $_POST['shop'];
         $data = $_POST['code'];
         //分区一二三级
         $cat1 = '';
         $cat2 = '';
         $cat3 = '';
         foreach ($data as $row) {
             if (strlen($row) == 2) {
                 $cat1 .= $row . ',';
             } else {
                 if (strlen($row) == 4) {
                     $cat2 .= $row . ',';
                 } else {
                     if (strlen($row)) {
                         $cat3 .= $row . ',';
                     }
                 }
             }
         }
         $cat1 = trim($cat1, ',');
         $cat2 = trim($cat2, ',');
         $cat3 = trim($cat3, ',');
         $cat1 = explode(',', $cat1);
         $cat2 = explode(',', $cat2);
         $cat3 = explode(',', $cat3);
         //连接三级sql,并判断父类存在否
         if (!empty($cat3)) {
             foreach ($cat3 as $row) {
                 $parent_1 = substr($row, 0, 2);
                 $parent_2 = substr($row, 0, 4);
                 if (!in_array($parent_1, $cat1) && !in_array($parent_1, $str_cat1)) {
                     $str_cat1[] = $parent_1;
                 }
                 if (!in_array($parent_2, $cat2) && !in_array($parent_2, $str_cat2)) {
                     $str_cat2[] = $parent_2;
                 }
                 $str_sql .= "('{$shop}','{$row}','3','1','1','{$parent_2}'),";
             }
         }
         //连接二级,全选状态
         if (!empty($cat2)) {
             foreach ($cat2 as $row) {
                 $parent_1 = substr($row, 0, 2);
                 if ($row != '') {
                     $str_sql .= "('{$shop}','{$row}','2','1','1','{$parent_1}'),";
                 }
             }
         }
         //连接二级不选中状态
         if (!empty($str_cat2)) {
             foreach ($str_cat2 as $row) {
                 $parent_1 = substr($row, 0, 2);
                 if ($row != '') {
                     $str_sql .= "('{$shop}','{$row}','2','0','1','{$parent_1}'),";
                 }
             }
         }
         //连接一级,全选状态
         if (!empty($cat1)) {
             foreach ($cat1 as $row) {
                 if ($row != '') {
                     $str_sql .= "('{$shop}','{$row}','1','1','1','0'),";
                 }
             }
         }
         //连接一级不选中状态
         if (!empty($str_cat1)) {
             foreach ($str_cat1 as $row) {
                 if ($row != '') {
                     $str_sql .= "('{$shop}','{$row}','1','0','1','0'),";
                 }
             }
         }
         $str_sql = trim($str_sql, ',');
         $transaction = $p_db->beginTransaction();
         try {
             $sql = "INSERT INTO `vcos_shop_operation_category`(shop_id,category_code,tree_type,is_sub_all,status,parent_catogory_code) VALUES" . $str_sql;
             $result = $p_db->createCommand($sql)->execute();
             $transaction->commit();
             Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Shop/Shop_operation"));
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '添加失败。'));
         }
     }
     $sql = "SELECT shop_id,shop_title FROM `vcos_shop` WHERE shop_status=1";
     $shop = $p_db->createCommand($sql)->queryAll();
     $sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE status=1 AND parent_cid=0";
     $cat1_sel = $p_db->createCommand($sql)->queryAll();
     $sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE status=1 AND length(category_code)=4 ORDER BY parent_cid";
     $cat2_sel = $p_db->createCommand($sql)->queryAll();
     $sql = "SELECT category_code,name,parent_cid FROM `vcos_category` WHERE status=1 AND length(category_code)=7 ORDER BY parent_cid";
     $cat3_sel = $p_db->createCommand($sql)->queryAll();
     $cat1_but = $cat1_sel[0]['category_code'];
     $cat2_but = $cat2_sel[0]['category_code'];
     $this->render('shop_operation', array('cat1_but' => $cat1_but, 'cat2_but' => $cat2_but, 'shop' => $shop, 'cat1_sel' => $cat1_sel, 'cat2_sel' => $cat2_sel, 'cat3_sel' => $cat3_sel));
 }
Ejemplo n.º 7
0
 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));
 }
Ejemplo n.º 8
0
 public function actionWifi_config_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $wifi = VcosWifiConfig::model()->findByPk($id);
     if ($_POST) {
         if ($_POST['describe'] != '' && $_POST['loginurl'] != '' && $_POST['logouturl'] != '' && $_POST['change'] != '' && $_POST['notice'] != '' && $_POST['policy'] != '' && $_POST['ssid'] != '' && $_POST['acip'] != '' && $_POST['apmac'] != '') {
             $wifi->config_id = $id;
             $wifi->config_describe = $_POST['describe'];
             $wifi->config_login_url = $_POST['loginurl'];
             $wifi->config_logout_url = $_POST['logouturl'];
             $wifi->config_change_url = $_POST['change'];
             $wifi->config_notice = $_POST['notice'];
             $wifi->config_policy = $_POST['policy'];
             $wifi->config_ssid = $_POST['ssid'];
             $wifi->config_acip = $_POST['acip'];
             $wifi->config_apmac = $_POST['apmac'];
             if ($wifi->save() > 0) {
                 Helper::show_message(yii::t('vcos', '修改成功'), Yii::app()->createUrl("Wifisetting/wifi_config_list"));
             } else {
                 Helper::show_message(yii::t('vcos', '修改失败'));
             }
         } else {
             Helper::show_message(yii::t('vcos', '修改失败'));
         }
     }
     $this->render('wifi_config_edit', array('wifi' => $wifi));
 }
Ejemplo n.º 9
0
 public function actionHelp_category_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $help_category = VcosHelpCategory::model()->findByPk($id);
     $sql = "SELECT b.id FROM vcos_help_category a LEFT JOIN vcos_help_category_language b ON a.id = b.category_id WHERE a.id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
     $id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
     $help_category_language = VcosHelpCategoryLanguage::model()->findByPk($id2['id']);
     if ($_POST) {
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         //事务处理
         $db = Yii::app()->m_db;
         $transaction = $db->beginTransaction();
         try {
             if (isset($_POST['language']) && $_POST['language'] != '') {
                 //编辑系统语言和外语状态下
                 //编辑主表
                 $db->createCommand()->update('vcos_help_category', array('state' => $state), 'id = :id', array(':id' => $id));
                 //编辑系统语言
                 $category_columns = array('category_name' => $_POST['title']);
                 //编辑系统语言
                 $db->createCommand()->update('vcos_help_category_language', $category_columns, 'id=:id', array(':id' => $id2['id']));
                 //判断外语是新增OR编辑
                 if ($_POST['judge'] == 'add') {
                     //新增外语
                     $db->createCommand()->insert('vcos_help_category_language', array('category_id' => $id, 'iso' => $_POST['language'], 'category_name' => $_POST['title_iso']));
                 } else {
                     //编辑外语
                     $columns = array('category_name' => $_POST['title_iso']);
                     $db->createCommand()->update('vcos_help_category_language', $columns, 'id=:id', array(':id' => $_POST['judge']));
                 }
                 //事务提交
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Commentandhelp/help_category"));
             } else {
                 //只编辑系统语言状态下
                 $help_category->id = $id;
                 $help_category->state = $state;
                 $help_category->save();
                 $help_category_language->id = $id2['id'];
                 $help_category_language->category_name = $_POST['title'];
                 $help_category_language->save();
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Commentandhelp/help_category"));
             }
         } catch (Exception $e) {
             $transaction->rollBack();
         }
     }
     $this->render('help_category_edit', array('help_category' => $help_category, 'help_category_language' => $help_category_language));
 }
Ejemplo n.º 10
0
 public function actionUpdateProductCheckInventory()
 {
     $this->setauth();
     //检查有无权限
     $p_db = Yii::app()->p_db;
     $code = isset($_POST['code']) ? $_POST['code'] : '';
     $name = isset($_POST['name']) ? $_POST['name'] : '';
     $status = isset($_POST['status']) ? $_POST['status'] : '';
     $inventory_old = isset($_POST['inventory_old']) ? $_POST['inventory_old'] : '';
     $inventory = isset($_POST['inventory']) ? $_POST['inventory'] : '';
     $time = date('Y-m-d H:i:s', time());
     $this_user_name = Yii::app()->user->name;
     $flag = 0;
     if ($code != '') {
         $transaction = $p_db->beginTransaction();
         try {
             $check_code = OrderService::createOrderno();
             //新增盘点记录
             $sql = "INSERT INTO `vcos_product_check` (check_code,check_time,check_type,check_people) VALUES ('{$check_code}','{$time}','{$status[0]}','{$this_user_name}')";
             Yii::app()->p_db->createCommand($sql)->execute();
             for ($i = 0; $i < count($code); $i++) {
                 $sql = "INSERT INTO `vcos_product_check_detail` (check_code,product_name,inventory_num,check_num,product_code) VALUES ('{$check_code}','{$name[$i]}','{$inventory_old[$i]}','{$inventory[$i]}','{$code[$i]}')";
                 Yii::app()->p_db->createCommand($sql)->execute();
                 $sql = "UPDATE `vcos_product` SET inventory_num='{$inventory[$i]}' WHERE product_code='{$code[$i]}'";
                 Yii::app()->p_db->createCommand($sql)->execute();
             }
             $transaction->commit();
             $flag = 1;
         } catch (Exception $e) {
             $transaction->rollBack();
             $flag = 0;
         }
     }
     if ($flag == 1) {
         Helper::show_message(yii::t('vcos', '提交成功。'), Yii::app()->createUrl("Product/product_check"));
     } else {
         Helper::show_message(yii::t('vcos', '提交失败。'), Yii::app()->createUrl("Product/product_check"));
     }
 }
Ejemplo n.º 11
0
 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));
 }
Ejemplo n.º 12
0
 public function actionGoods_order_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $detail = VcosMemberOrder::model()->findByPk($id);
     if ($_POST) {
         $detail->order_id = $id;
         $detail->order_remark = $_POST['remark'];
         $detail->order_status = $_POST['state'];
         $detail->is_read = '1';
         if ($detail->save() > 0) {
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Dutyfreegoods/goods_order_list"));
         } else {
             Helper::show_message(yii::t('vcos', '修改失败。'));
         }
     }
     $sql = "SELECT *\r\n                FROM vcos_member_order_detail\r\n                WHERE order_serial_num = '{$detail->order_serial_num}'";
     $sub_detail = Yii::app()->m_db->createCommand($sql)->queryAll();
     $sql = "SELECT cn_name FROM vcos_member WHERE member_code = {$detail->membership_code}";
     $user = Yii::app()->db->createCommand($sql)->queryRow();
     $this->render('goods_order_edit', array('detail' => $detail, 'sub_detail' => $sub_detail, 'user' => $user));
 }
Ejemplo n.º 13
0
 public function actionGoods_order_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $detail = VcosGoodsOrder::model()->findByPk($id);
     if ($_POST) {
         $detail->order_id = $id;
         $detail->order_remark = $_POST['remark'];
         $detail->order_state = $_POST['state'];
         $detail->is_read = '1';
         if ($detail->save() > 0) {
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Dutyfreegoods/goods_order_list"));
         } else {
             Helper::show_message(yii::t('vcos', '修改失败。'));
         }
     }
     $sql = "SELECT a.*, c.goods_name, b.goods_img_url \r\n                FROM vcos_goods_order_detail a, vcos_dutyfree_goods b, vcos_dutyfree_goods_language c\r\n                WHERE a.goods_id=b.goods_id AND a.order_serial_num = {$detail->order_serial_num} AND b.goods_id = c.goods_id AND c.iso = '" . Yii::app()->language . "'";
     $sub_detail = Yii::app()->m_db->createCommand($sql)->queryAll();
     $user = VcosMember::model()->findByPk($detail->membership_id);
     $this->render('goods_order_edit', array('detail' => $detail, 'sub_detail' => $sub_detail, 'user' => $user));
 }
Ejemplo n.º 14
0
 public function actionResetpassword()
 {
     $id = $_GET['id'];
     $admin = VcosAdmin::model()->findByPk($id);
     $admin->admin_id = $id;
     $admin->admin_password = md5('12345678');
     if ($admin->save() > 0) {
         Helper::show_message(yii::t('vcos', '重设成功,密码为12345678。'), Yii::app()->createUrl("Auth/admin"));
     } else {
         Helper::show_message(yii::t('vcos', '重设失败。'));
     }
 }
Ejemplo n.º 15
0
 public function actionNavigation_group_brand_edit()
 {
     $this->setauth();
     //检查有无权限
     $p_db = Yii::app()->p_db;
     $id = $_GET['id'];
     $navigation_group_brand = VcosNavigationGroupBrand::model()->findByPk($id);
     if ($_POST) {
         $navigation = isset($_POST['navigation']) ? $_POST['navigation'] : 0;
         $brand = isset($_POST['brand']) ? $_POST['brand'] : 0;
         $sort = isset($_POST['sort']) ? $_POST['sort'] : '0';
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         //事务处理
         $transaction = $p_db->beginTransaction();
         try {
             $navigation_group_brand->navigation_group_id = $navigation;
             $navigation_group_brand->brand_id = $brand;
             $navigation_group_brand->sort_order = $sort;
             $navigation_group_brand->status = $state;
             $navigation_group_brand->save();
             $transaction->commit();
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/navigation_group_brand_list"));
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '修改失败。'));
         }
     }
     $sql = "SELECT navigation_group_id,navigation_group_name FROM `vcos_navigation_group` WHERE status=1";
     $navigation_group = Yii::app()->p_db->createCommand($sql)->queryAll();
     $sql = "SELECT brand_id,brand_cn_name FROM `vcos_brand` WHERE brand_status=1";
     $brand = Yii::app()->p_db->createCommand($sql)->queryAll();
     $this->render('navigation_group_brand_edit', array('brand' => $brand, 'navigation_group' => $navigation_group, 'navigation_group_brand' => $navigation_group_brand));
 }
Ejemplo n.º 16
0
 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));
 }
Ejemplo n.º 17
0
 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));
 }
Ejemplo n.º 18
0
 public function actionResetpassword()
 {
     $id = $_GET['id'];
     $detail = VcosMember::model()->findByPk($id);
     $detail->member_id = $id;
     $detail->member_password = md5('888888');
     if ($detail->save() > 0) {
         Helper::show_message(yii::t('vcos', '重设成功(密码为:12345678)'), Yii::app()->createUrl("User/user_list"));
     } else {
         Helper::show_message(yii::t('vcos', '重设失败'));
     }
 }
Ejemplo n.º 19
0
 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));
 }
Ejemplo n.º 20
0
 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));
 }
Ejemplo n.º 21
0
 public function actionReport_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $record = VcosWeatherRecord::model()->findByPk($id);
     if ($_POST) {
         $iso = isset($_POST['language']) ? $_POST['language'] : 'zh_cn';
         //判断语言
         if (isset($_POST['language']) && $_POST['language'] != '') {
             //外语
             $time = explode(" - ", $_POST['time_iso']);
             $stime = date('Y/m/d H:i:s', strtotime($time[0]));
             $etime = date('Y/m/d H:i:s', strtotime($time[1]) + "86399");
             $record->record_id = $id;
             $weathers = explode("-", $_POST['weather_iso']);
             $record->weather_id = $weathers[0];
             $record->weather_name = $weathers[1];
             $record->city_id = $_POST['city_iso'];
             $record->record_start_time = $stime;
             $record->record_end_time = $etime;
             $record->record_temperature_min = $_POST['min_temp_iso'];
             $record->record_temperature_max = $_POST['max_temp_iso'];
             $record->wind_direction = $_POST['direction_iso'];
             $record->wind_scale = $_POST['scale_iso'];
             $record->iso = $iso;
             $count = $record->update('record_id', 'weather_id', 'weather_name', 'record_start_time', 'record_end_time', 'record_temperature_min', 'record_temperature_max', 'wind_direction', 'wind_scale', 'iso');
             if ($count > 0) {
                 Helper::show_message(yii::t('vcos', '修改成功'), Yii::app()->createUrl("Weather/Report_list"));
             } else {
                 Helper::show_message(yii::t('vcos', '修改失败'));
             }
         } else {
             //中文
             $time = explode(" - ", $_POST['time']);
             $stime = date('Y/m/d H:i:s', strtotime($time[0]));
             $etime = date('Y/m/d H:i:s', strtotime($time[1]) + "86399");
             $record->record_id = $id;
             $weathers = explode("-", $_POST['weather']);
             $record->weather_id = $weathers[0];
             $record->weather_name = $weathers[1];
             $record->city_id = $_POST['city'];
             $record->record_start_time = $stime;
             $record->record_end_time = $etime;
             $record->record_temperature_min = $_POST['min_temp'];
             $record->record_temperature_max = $_POST['max_temp'];
             $record->wind_direction = $_POST['direction'];
             $record->wind_scale = $_POST['scale'];
             $record->iso = $iso;
             $count = $record->update('record_id', 'weather_id', 'weather_name', 'record_start_time', 'record_end_time', 'record_temperature_min', 'record_temperature_max', 'wind_direction', 'wind_scale', 'iso');
             if ($count > 0) {
                 Helper::show_message(yii::t('vcos', '修改成功'), Yii::app()->createUrl("Weather/Report_list"));
             } else {
                 Helper::show_message(yii::t('vcos', '修改失败'));
             }
         }
     }
     $sql = "SELECT a.city_id,b.city_name,b.iso FROM `vcos_strategy_city` a LEFT JOIN `vcos_strategy_city_language` b ON a.city_id = b.city_id WHERE a.state = '1' ";
     $city_sel = Yii::app()->db->createCommand($sql)->queryAll();
     $sql = "SELECT a.id,b.weather_name,b.iso FROM `vcos_weather` a LEFT JOIN `vcos_weather_language` b ON a.id=b.weather_id";
     $weather = Yii::app()->db->createCommand($sql)->queryAll();
     //风速
     $sql = "SELECT a.id,b.wind_scale_name,b.iso  FROM `vcos_wind_scale` a LEFT JOIN `vcos_wind_scale_language` b ON a.id=b.wind_scale_id";
     $wind_scale = Yii::app()->db->createCommand($sql)->queryAll();
     //风向
     $sql = "SELECT a.id,b.wind_direction_name,b.iso FROM `vcos_wind_direction` a LEFT JOIN `vcos_wind_direction_language` b ON a.id=b.wind_direction_id";
     $wind_direction = Yii::app()->db->createCommand($sql)->queryAll();
     $this->render('edit', array('city_sel' => $city_sel, 'record' => $record, 'weather' => $weather, 'wind_scale' => $wind_scale, 'wind_direction' => $wind_direction));
 }
Ejemplo n.º 22
0
 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));
 }
Ejemplo n.º 23
0
 public function actionWifi_service_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $wifi_item = VcosWifiItem::model()->findByPk($id);
     $sql = "SELECT b.id FROM vcos_wifi_item a LEFT JOIN vcos_wifi_item_language b ON a.wifi_id = b.wifi_id WHERE a.wifi_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
     $id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
     $wifi_item_language = VcosWifiItemLanguage::model()->findByPk($id2['id']);
     if ($_POST) {
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         $price = isset($_POST['price']) ? $_POST['price'] * 100 : '0';
         $time = isset($_POST['time']) ? $_POST['time'] : '0';
         //事务处理
         $db = Yii::app()->m_db;
         $transaction = $db->beginTransaction();
         try {
             if (isset($_POST['language']) && $_POST['language'] != '') {
                 //编辑系统语言和外语状态下
                 //编辑主表
                 $columns = array('sale_price' => $price, 'status' => $state, 'wifi_time' => $time);
                 $db->createCommand()->update('vcos_wifi_item', $columns, 'wifi_id = :id', array(':id' => $id));
                 //编辑系统语言
                 $db->createCommand()->update('vcos_wifi_item_language', array('wifi_name' => $_POST['name']), 'id=:id', array(':id' => $id2['id']));
                 //判断外语是新增OR编辑
                 if ($_POST['judge'] == 'add') {
                     //新增外语
                     $db->createCommand()->insert('vcos_wifi_item_language', array('wifi_id' => $id, 'iso' => $_POST['language'], 'wifi_name' => $_POST['name_iso']));
                 } else {
                     //编辑外语
                     $db->createCommand()->update('vcos_wifi_item_language', array('wifi_name' => name_iso), 'id=:id', array(':id' => $_POST['judge']));
                 }
                 //事务提交
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Wifisetting/wifi_service_list"));
             } else {
                 //只编辑系统语言状态下
                 $wifi_item->wifi_id = $id;
                 $wifi_item->sale_price = $price;
                 $wifi_item->wifi_time = $time;
                 $wifi_item->status = $state;
                 $wifi_item->save();
                 $wifi_item_language->id = $id2['id'];
                 $wifi_item_language->wifi_name = $_POST['name'];
                 $wifi_item_language->save();
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Wifisetting/wifi_service_list"));
             }
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '修改失败。'), '#');
         }
     }
     $this->render('wifi_service_edit', array('wifi_item' => $wifi_item, 'wifi_item_language' => $wifi_item_language));
 }
Ejemplo n.º 24
0
 public function init()
 {
     MyLanguage::setLanguage();
     if (empty(Yii::app()->user->id)) {
         if (!stripos(Yii::app()->request->getUrl(), 'login')) {
             $this->redirect(Yii::app()->createUrl('login/login'));
         }
     } else {
         $admin_id = Yii::app()->user->id;
         $sql = "SELECT * FROM vcos_admin WHERE admin_id = '{$admin_id}'";
         $result = Yii::app()->m_db->createCommand($sql)->queryRow();
         if (!$result) {
             Yii::app()->session->clear();
             Yii::app()->session->destroy();
             die(Helper::show_message(Yii::t('vcos', '你的账户已经被删除了'), Yii::app()->createUrl("login/login")));
         }
     }
     $this->auth = $this->setmyaction();
 }
Ejemplo n.º 25
0
 public function actionSafe_info_edit()
 {
     $this->setauth();
     //检查有无权限
     $db = Yii::app()->m_db;
     $id = $_GET['id'];
     $safe = VcosSafe::model()->findByPk($id);
     $sql = "SELECT b.id FROM vcos_safe a LEFT JOIN vcos_safe_language b ON a.safe_id = b.safe_id WHERE a.safe_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
     $id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
     $safe_language = VcosSafeLanguage::model()->findByPk($id2['id']);
     if ($_POST) {
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         //事务处理
         $db = Yii::app()->m_db;
         $transaction = $db->beginTransaction();
         try {
             if (isset($_POST['language']) && $_POST['language'] != '') {
                 //编辑系统语言和外语状态下
                 //编辑主表
                 $db->createCommand()->update('vcos_safe', array('safe_state' => $state), 'safe_id = :id', array(':id' => $id));
                 //编辑系统语言
                 $db->createCommand()->update('vcos_safe_language', array('safe_title' => $_POST['title'], 'safe_content' => $_POST['describe']), 'id=:id', array(':id' => $id2['id']));
                 //判断外语是新增OR编辑
                 if ($_POST['judge'] == 'add') {
                     //新增外语
                     $db->createCommand()->insert('vcos_safe_language', array('safe_id' => $id, 'iso' => $_POST['language'], 'safe_title' => $_POST['title_iso'], 'safe_content' => $_POST['describe_iso']));
                 } else {
                     //编辑外语
                     $db->createCommand()->update('vcos_safe_language', array('safe_title' => $_POST['title_iso'], 'safe_content' => $_POST['describe_iso']), 'id=:id', array(':id' => $_POST['judge']));
                 }
                 //事务提交
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Safe/safe_info_list"));
             } else {
                 //只编辑系统语言
                 $safe->safe_state = $state;
                 $safe->save();
                 $safe_language->id = $id2['id'];
                 $safe_language->safe_title = $_POST['title'];
                 $safe_language->safe_content = $_POST['describe'];
                 $safe_language->save();
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Safe/safe_info_list"));
             }
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '修改失败。'));
         }
     }
     $this->render('safe_info_edit', array('safe' => $safe, 'safe_language' => $safe_language));
 }
Ejemplo n.º 26
0
 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']));
 }
Ejemplo n.º 27
0
 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));
 }
Ejemplo n.º 28
0
 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));
 }
Ejemplo n.º 29
0
 public function actionShop_category_edit()
 {
     $this->setauth();
     //检查有无权限
     $p_db = Yii::app()->p_db;
     $id = $_GET['id'];
     $shop_category = VcosShopCategory::model()->findByPk($id);
     if ($_POST) {
         $shop = isset($_POST['shop']) ? $_POST['shop'] : '0';
         $category = isset($_POST['category_3']) ? $_POST['category_3'] : 0;
         $sort = isset($_POST['sort']) ? $_POST['sort'] : 0;
         //事务处理
         $transaction = $p_db->beginTransaction();
         try {
             $shop_category->shop_id = $shop;
             $shop_category->category_code = $category;
             $shop_category->sort_order = $sort;
             $shop_category->save();
             $transaction->commit();
             Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Shop/shop_category_list"));
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '修改失败。'));
         }
     }
     $category_code = $shop_category['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 shop_id,shop_title from `vcos_shop` WHERE shop_status=1";
     $shop = $p_db->createCommand($sql)->queryAll();
     $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();
     $this->render('shop_category_edit', array('shop' => $shop, 'layer_cat' => $layer_cat_1['parent_cid'], 'layer_cat2' => $layer_cat_2['parent_cid'], 'shop_category' => $shop_category, 'layer_1' => $layer_1, 'layer_2' => $layer_2, 'layer_3' => $layer_3));
 }
Ejemplo n.º 30
0
 public function actionCruise_deck_point_edit()
 {
     $this->setauth();
     //检查有无权限
     $id = $_GET['id'];
     $cruise_deck_point = VcosCruiseDeckPoint::model()->findByPk($id);
     $sql = "SELECT b.id FROM vcos_cruise_deck_point a LEFT JOIN vcos_cruise_deck_point_language b ON a.deck_point_id = b.deck_point_id WHERE a.deck_point_id = {$id} AND b.iso ='" . Yii::app()->language . "'";
     $id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
     $cruise_deck_point_language = VcosCruiseDeckPointLanguage::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'] . 'cruiseinfo_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'] . 'cruiseinfo_images/' . Yii::app()->params['month'], 'image', 3);
                 $photo_iso = $result['filename'];
             }
         }
         $state = isset($_POST['state']) ? $_POST['state'] : '0';
         //匹配替换编辑器中图片路径
         $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('deck_point_state' => $state, 'deck_number' => $_POST['number'], 'deck_id' => $_POST['deck']);
                 $db->createCommand()->update('vcos_cruise_deck_point', $columns, 'deck_point_id = :id', array(':id' => $id));
                 if ($photo_iso) {
                     //判断有无上传图片
                     $photo_iso_url = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
                 }
                 $columns_deck_point = array('deck_point_name' => $_POST['name'], 'deck_point_describe' => $_POST['desc'], 'deck_point_info' => $describe);
                 if ($photo != '') {
                     //判断有无上传图片
                     $columns_deck_point['img_url'] = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo;
                 }
                 //编辑系统语言
                 $db->createCommand()->update('vcos_cruise_deck_point_language', $columns_deck_point, 'id=:id', array(':id' => $id2['id']));
                 //判断外语是新增OR编辑
                 if ($_POST['judge'] == 'add') {
                     //新增外语
                     $db->createCommand()->insert('vcos_cruise_deck_point_language', array('deck_point_id' => $id, 'iso' => $_POST['language'], 'img_url' => $photo_iso_url, 'deck_point_name' => $_POST['name_iso'], 'deck_point_describe' => $_POST['desc_iso'], 'deck_point_info' => $describe_iso));
                 } else {
                     //编辑外语
                     $columns_deck_point_language = array('deck_point_name' => $_POST['name_iso'], 'deck_point_describe' => $_POST['desc_iso'], 'deck_point_info' => $describe_iso);
                     if ($photo_iso != '') {
                         //判断有无上传图片
                         $columns_deck_point_language['img_url'] = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo_iso;
                     }
                     $db->createCommand()->update('vcos_cruise_deck_point_language', $columns_deck_point_language, 'id=:id', array(':id' => $_POST['judge']));
                 }
                 //事务提交
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Cruiseinfo/Cruise_deck_point_list"));
             } else {
                 //只编辑系统语言状态下
                 $cruise_deck_point->deck_point_state = $state;
                 $cruise_deck_point->deck_number = $_POST['number'];
                 $cruise_deck_point->deck_id = $_POST['deck'];
                 $cruise_deck_point->save();
                 $cruise_deck_point_language->id = $id2['id'];
                 if ($photo != '') {
                     //判断有无上传图片
                     $cruise_deck_point_language->img_url = 'cruiseinfo_images/' . Yii::app()->params['month'] . '/' . $photo;
                 }
                 //$cruise_deck_point_language->img_url = 'cruiseinfo_images/'.Yii::app()->params['month'].'/'.$photo_iso;
                 $cruise_deck_point_language->deck_point_name = $_POST['name'];
                 $cruise_deck_point_language->deck_point_describe = $_POST['desc'];
                 $cruise_deck_point_language->deck_point_info = $describe;
                 $cruise_deck_point_language->save();
                 $transaction->commit();
                 Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Cruiseinfo/Cruise_deck_point_list"));
             }
         } catch (Exception $e) {
             $transaction->rollBack();
             Helper::show_message(yii::t('vcos', '修改失败。'), '#');
         }
     }
     $sql = "SELECT a.deck_id,b.deck_name FROM `vcos_cruise_deck` a LEFT JOIN `vcos_cruise_deck_language` b ON a.deck_id = b.deck_id WHERE b.iso = '" . Yii::app()->language . "'";
     $deck_sel = Yii::app()->m_db->createCommand($sql)->queryAll();
     $this->render('cruise_deck_point_edit', array('deck_sel' => $deck_sel, 'cruise_deck_point' => $cruise_deck_point, 'cruise_deck_point_language' => $cruise_deck_point_language));
 }