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 actionNavigation_group_category_edit() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $id = $_GET['id']; $navigation_group_category = VcosNavigationGroupCategory::model()->findByPk($id); if ($_POST) { $navigation_group = isset($_POST['navigation_group']) ? $_POST['navigation_group'] : 0; $name = isset($_POST['name']) ? $_POST['name'] : ''; $sort = isset($_POST['sort']) ? $_POST['sort'] : '0'; $highlight = isset($_POST['highlight']) ? $_POST['highlight'] : 0; $type = isset($_POST['type']) ? $_POST['type'] : '0'; if ($type == 1) { $mapping = isset($_POST['mapping']) ? $_POST['mapping'] : ''; $mapping = trim($mapping, ','); } else { $mapping = isset($_POST['one_sel']) ? $_POST['one_sel'] : ''; } //$mapping = isset($_POST['mapping'])?$_POST['mapping']:''; $state = isset($_POST['state']) ? $_POST['state'] : '0'; //事务处理 $transaction = $p_db->beginTransaction(); try { $navigation_group_category->navigation_group_id = $navigation_group; $navigation_group_category->navigation_category_name = $name; $navigation_group_category->sort_order = $sort; $navigation_group_category->is_highlight = $highlight; $navigation_group_category->category_type = $type; $navigation_group_category->mapping_id = $mapping; $navigation_group_category->status = $state; $navigation_group_category->save(); $transaction->commit(); Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Navigation/navigation_group_category_list")); } catch (Exception $e) { $transaction->rollBack(); Helper::show_message(yii::t('vcos', '修改失败。')); } } $sql = "SELECT * FROM `vcos_navigation_group` WHERE status=1"; $navigation_group = Yii::app()->p_db->createCommand($sql)->queryAll(); $sql = "SELECT category_code,name FROM `vcos_category` WHERE parent_cid=0"; $cat_1 = Yii::app()->p_db->createCommand($sql)->queryAll(); $this_type_val = $navigation_group_category['category_type']; $type_cat = ''; $cat2_val = ''; $cat1_val = ''; $cat2_name = ''; $checked_sel = ''; if ($this_type_val == 2) { $sql = "SELECT brand_id as val1,brand_cn_name as val2 FROM `vcos_brand` WHERE brand_status=1"; } elseif ($this_type_val == 3) { $sql = "SELECT shop_id as val1,shop_title as val2 FROM `vcos_shop`"; } $type_cat = Yii::app()->p_db->createCommand($sql)->queryAll(); if ($this_type_val == 1) { $this_code = $navigation_group_category['mapping_id']; $this_code = trim($this_code, ','); $sql = "SELECT category_code,name from `vcos_category` WHERE category_code in ({$this_code})"; $checked_sel = Yii::app()->p_db->createCommand($sql)->queryAll(); $this_code = explode(",", $this_code); $this_code = $this_code[0]; $this_code_length = strlen($this_code); if ($this_code_length == 7) { //三级 $sql = "SELECT parent_cid FROM `vcos_category` WHERE category_code=" . $this_code; $cat2_res = Yii::app()->p_db->createCommand($sql)->queryRow(); $sql = "SELECT parent_cid,name FROM `vcos_category` WHERE category_code=" . $cat2_res['parent_cid']; $cat1_res = Yii::app()->p_db->createCommand($sql)->queryRow(); $cat1_val = $cat1_res['parent_cid']; $cat2_name = $cat1_res['name']; $cat2_val = $cat2_res['parent_cid']; } else { //二级 $sql = "SELECT parent_cid,name FROM `vcos_category` WHERE category_code=" . $this_code; $cat1_res = Yii::app()->p_db->createCommand($sql)->queryRow(); $cat2_name = $cat1_res['name']; $cat1_val = $cat1_res['parent_cid']; $cat2_val = $this_code; } $sql = "SELECT * from `vcos_category` WHERE parent_cid=0"; $cat1_sel = Yii::app()->p_db->createCommand($sql)->queryAll(); $sql = "SELECT * from `vcos_category` WHERE parent_cid=" . $cat1_val; $cat2_sel = Yii::app()->p_db->createCommand($sql)->queryAll(); $sql = "SELECT * from `vcos_category` WHERE parent_cid=" . $cat2_val; $cat3_sel = Yii::app()->p_db->createCommand($sql)->queryAll(); } $this->render('navigation_group_category_edit', array('checked_sel' => $checked_sel, 'cat2_name' => $cat2_name, 'type_cat' => $type_cat, 'cat1_val' => $cat1_val, 'cat2_val' => $cat2_val, 'cat1_sel' => $cat1_sel, 'cat2_sel' => $cat2_sel, 'cat3_sel' => $cat3_sel, 'navigation_group' => $navigation_group, 'navigation_group_category' => $navigation_group_category)); }