public function actionSurvey_grade_edit()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$grade = VcosSurveyChoose::model()->findByPk($id);
$sql = "SELECT b.id FROM vcos_survey_choose a LEFT JOIN vcos_survey_choose_language b ON a.survey_choose_id = b.survey_choose_id WHERE a.survey_choose_id = {$id} AND b.iso ='" . Yii::app()->params['language'] . "'";
$id2 = Yii::app()->m_db->createCommand($sql)->queryRow();
$grade_language = VcosSurveyChooseLanguage::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_survey_choose', array('survey_choose_state' => $state), 'survey_choose_id = :id', array(':id' => $id));
//编辑系统语言
$db->createCommand()->update('vcos_survey_choose_language', array('survey_choose_name' => $_POST['title']), 'id=:id', array(':id' => $id2['id']));
//判断外语是新增OR编辑
if ($_POST['judge'] == 'add') {
//新增外语
$db->createCommand()->insert('vcos_survey_choose_language', array('survey_choose_id' => $id, 'iso' => $_POST['language'], 'survey_choose_name' => $_POST['title_iso']));
} else {
//编辑外语
$db->createCommand()->update('vcos_survey_choose_language', array('survey_choose_name' => $_POST['title_iso']), 'id=:id', array(':id' => $_POST['judge']));
}
//事务提交
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Commentandhelp/survey_grade"));
} else {
//只编辑系统语言状态下
$grade->survey_choose_id = $id;
$grade->survey_choose_state = $state;
$grade->save();
$grade_language->id = $id2['id'];
$grade_language->survey_choose_name = $_POST['title'];
$grade_language->save();
$transaction->commit();
Helper::show_message(yii::t('vcos', '修改成功。'), Yii::app()->createUrl("Commentandhelp/survey_grade"));
}
} catch (Exception $e) {
$transaction->rollBack();
}
}
$this->render('survey_grade_edit', array('grade' => $grade, 'grade_language' => $grade_language));
}
public function actionSurvey_statistics()
{
$this->setauth();
//检查有无权限
$id = $_GET['id'];
$db = Yii::app()->m_db;
$sql = "SELECT b.survey_title FROM vcos_survey a LEFT JOIN vcos_survey_language b ON a.survey_id = b.survey_id WHERE a.survey_id = {$id} AND b.iso = '" . Yii::app()->language . "'";
$title = $db->createCommand($sql)->queryRow();
$sql2 = "SELECT a.survey_choose_id, b.survey_choose_name FROM vcos_survey_choose a LEFT JOIN vcos_survey_choose_language b ON a.survey_choose_id = b.survey_choose_id WHERE b.iso = '" . Yii::app()->language . "'";
$grade = $db->createCommand($sql2)->queryAll();
$grade_num = VcosSurveyChoose::model()->count();
$condition = array();
$result = array();
for ($i = 1, $j = 0; $i <= $grade_num; $i++, $j++) {
$condition[] = "survey_id={$id} and survey_choose_id={$grade[$j]['survey_choose_id']}";
}
foreach ($condition as $row) {
$result[] = VcosSurveyResult::model()->count($row);
}
$this->render('survey_statistics', array('grade' => $grade, 'result' => $result, 'title' => $title));
}
