public function actionLine_add() { $this->setauth(); //检查有无权限 $line = new VcosLine(); $line_language = new VcosLineLanguage(); if ($_POST) { $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"); $state = isset($_POST['state']) ? $_POST['state'] : '0'; $line->state = $state; $line->start_time = $stime; $line->end_time = $etime; //处理事务 $db = Yii::app()->m_db; $transaction = $db->beginTransaction(); try { $line->save(); if (isset($_POST['language']) && $_POST['language'] != '') { //判读是否同时添加系统语言和外语 $sql = "INSERT INTO `vcos_line_language` (`line_id`, `iso`, `line_name`, `voyage_time`) VALUES ('{$line->primaryKey}', '" . Yii::app()->params['language'] . "', '{$_POST['title']}', '{$_POST['vtime']}'), ('{$line->primaryKey}', '{$_POST['language']}', '{$_POST['title_iso']}', '{$_POST['vtime_iso']}')"; $db->createCommand($sql)->execute(); $transaction->commit(); //Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Line/line_list")); Helper::show_message_query(yii::t('vcos', '添加成功,是否继续添加航线介绍?'), Yii::app()->createUrl("Line/line_detail_add"), Yii::app()->createUrl("Line/line_list")); } else { //只添加系统语言时 $line_language->line_id = $line->primaryKey; $line_language->iso = Yii::app()->params['language']; $line_language->line_name = $_POST['title']; $line_language->voyage_time = $_POST['vtime']; $line_language->save(); $transaction->commit(); //Helper::show_message(yii::t('vcos', '添加成功。'), Yii::app()->createUrl("Line/line_list")); Helper::show_message_query(yii::t('vcos', '添加成功,是否继续添加航线介绍?'), Yii::app()->createUrl("Line/line_detail_add"), Yii::app()->createUrl("Line/line_list")); } } catch (Exception $e) { $transaction->rollBack(); Helper::show_message(yii::t('vcos', '添加失败。'), '#'); } } $this->render('line_add', array('line' => $line, 'line_language' => $line_language)); }