Пример #1
0
 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));
 }