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)); }