public function actionLscategoryadd()
{
if ($this->auth[0] == '0') {
} else {
$error = Yii::app()->createUrl('error/index');
$this->redirect($error);
}
$lc = new VcosLifeserviceCategory();
$lc_language = new VcosLifeserviceCategoryLanguage();
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';
$lc->bg_color = $_POST['bgcolor'];
$lc->lc_state = $state;
$lc->lc_img_url = 'lifeservice_images/' . Yii::app()->params['month'] . '/' . $photo;
//处理事务
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
$lc->save();
if (isset($_POST['language']) && $_POST['language'] != '') {
//判读是否同时添加系统语言和外语
$sql = "INSERT INTO `vcos_lifeservice_category_language` (`lc_id`, `iso`, `lc_name`) VALUES ('{$lc->primaryKey}', '" . Yii::app()->params['language'] . "', '{$_POST['title']}'), ('{$lc->primaryKey}', '{$_POST['language']}', '{$_POST['title_iso']}')";
$db->createCommand($sql)->execute();
$transaction->commit();
Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Lifeservice/Service_category"));
} else {
//只添加系统语言时
$lc_language->lc_id = $lc->primaryKey;
$lc_language->iso = Yii::app()->params['language'];
$lc_language->lc_name = $_POST['title'];
$lc_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Lifeservice/Service_category"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '添加失败。'), '#');
}
}
$this->render('lscategoryadd', array('lc' => $lc, 'lc_language' => $lc_language));
}
public function actionService_categoryedit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$lc = VcosLifeserviceCategory::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_lifeservice_category a LEFT JOIN vcos_lifeservice_category_language b ON a.lc_id = b.lc_id WHERE a.lc_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$lc_language = VcosLifeserviceCategoryLanguage::model()->findByPk($id2['id']);
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';
if ($state == '0') {
//$result = VcosLifeservice::model()->count('ls_category=:id',array(':id'=>$id));
$sql = "SELECT count(*) count FROM vcos_lifeservice WHERE ls_state = 1 AND ls_category =" . $id;
$count = Yii::app()->m_db->createCommand($sql)->queryRow();
if ($count['count'] > 0) {
die(Helper::show_message(yii::t('vcos', '此分类正在使用,不能禁用。')));
}
}
//事务处理
$db = Yii::app()->m_db;
$transaction = $db->beginTransaction();
try {
if (isset($_POST['language']) && $_POST['language'] != '') {
//编辑系统语言和外语状态下
//编辑主表
$columns = array('lc_state' => $state, 'bg_color' => $_POST['bgcolor']);
if ($photo) {
//判断有无上传图片
$columns['lc_img_url'] = 'lifeservice_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$db->createCommand()->update('vcos_lifeservice_category', $columns, 'lc_id = :id', array(':id' => $id));
//编辑系统语言
$db->createCommand()->update('vcos_lifeservice_category_language', array('lc_name' => $_POST['title']), 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$db->createCommand()->insert('vcos_lifeservice_category_language', array('lc_id' => $id, 'iso' => $_POST['language'], 'lc_name' => $_POST['title_iso']));
} else {
//编辑外语
$db->createCommand()->update('vcos_lifeservice_category_language', array('lc_name' => $_POST['title_iso']), 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Lifeservice/Service_category"));
} else {
//只编辑系统语言
$lc->lc_id = $id;
$lc->bg_color = $_POST['bgcolor'];
$lc->lc_state = $state;
if ($photo) {
$lc->lc_img_url = 'lifeservice_images/' . Yii::app()->params['month'] . '/' . $photo;
}
$lc->save();
$lc_language->id = $id2['id'];
$lc_language->lc_name = $_POST['title'];
$lc_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Lifeservice/Service_category"));
}
} catch (Exception $e) {
$transaction->rollBack();
Helper::show_message(yii::t('vcos', '修改失败。'));
}
}
$this->render('categoryedit', array('lifeservice_category' => $lc, 'lc_language' => $lc_language));
}