public function getEmailContent($UseIn, $panelistID = 0) { $message_body = ""; $subject = ""; //if language and country are 0 then send in default language. //If country id not equal to 0 then $sql = "SELECT * FROM " . $this->viewName() . " WHERE use_in = {$UseIn} and isactive = 1 "; $cmd = Yii::app()->db->createCommand($sql); $cnt = $cmd->queryScalar(); $rows = $cmd->queryAll(); $dr = $cmd->query(); if ($cnt > 0) { while (($r = $dr->read()) !== false) { //while ($r = mysql_fetch_array($dataReader)) { $message_body = $r['content_text']; $subject = $r['subject_text']; $email_bodyid = $r['email_bodyid']; $email_subjectid = $r['email_subjectid']; } $panelistID = (int) $panelistID; $preferLanguageCode = Yii::app()->lang->langcode; //Get panel list communication language if ($panelistID > 0) { //$sql="SELECT id as question_id,short_title FROM {{profile_question}} WHERE short_title LIKE 'Prefered-Language'"; $dr = questions::model()->communication_language()->findAll(); if (count($dr) > 0) { $question_id = (int) $dr[0]['id']; //$question_id = (int) 1; } else { $question_id = 0; } if ($question_id > 0) { $columnname = "question_id_{$question_id}"; $qus_language_answer = Yii::app()->db->createCommand("select {$columnname} from {{panellist_answer}} WHERE panellist_id = {$panelistID}")->queryRow(); if (count($qus_language_answer) > 0) { $preferLanguageCode = $qus_language_answer[$columnname]; } else { $preferLanguageCode = Yii::app()->lang->langcode; } } } else { //if there is no panel list then use the default language $preferLanguageCode = Yii::app()->lang->langcode; } if ($preferLanguageCode != "") { //$EmailLanguageCode = $preferLanguageCode; //$tempEmailLanguageCode = $preferLanguageCode; $sql = "SELECT * FROM {{translation_email_body}} WHERE language_code_dest = '{$preferLanguageCode}'\n AND email_bodyid = {$email_bodyid}"; $qur_translate = Yii::app()->db->createCommand($sql)->queryRow(); if (count($qur_translate) > 0) { $message_body = $qur_translate['translated_body']; } else { //$message_body = 'Email body translation not found for language code = $preferLanguageCode, Please inform your webmaster'; $message_body = ''; } $sql = "SELECT * FROM {{translation_email_subjects}} WHERE language_code_dest = '{$preferLanguageCode}'\n AND email_subjectid = {$email_subjectid}"; $qur_translate = Yii::app()->db->createCommand($sql)->queryRow(); if (count($qur_translate) > 0) { $subject = $qur_translate['translated_subject']; } else { //$subject = 'Email subject translation not found for language code = $preferLanguageCode, Please inform your webmaster'; $subject = ''; } } if (strlen($message_body) == 0) { throw new Exception("There is some problem regarding to get the email body"); } if (strlen($subject) == 0) { throw new Exception("There is some problem regarding to get the email subject"); } } else { throw new Exception("No Email Template found for these email point."); } return array("SUBJECT" => $subject, "BODY" => $message_body); }
function mod() { $clang = Yii::app()->lang; if (!Permission::model()->hasGlobalPermission('panellist', 'update')) { Yii::app()->setFlashMessage($clang->gT("You do not have sufficient rights to access this page."), 'error'); $this->getController()->redirect(array("admin/index")); } App()->getClientScript()->registerCssFile(Yii::app()->getConfig('styleurl') . "jquery.dataTables.css"); App()->getClientScript()->registerScriptFile(Yii::app()->getConfig('adminscripts') . 'jquery.dataTables.min.js'); $clang = Yii::app()->lang; $action = isset($_GET['action']) ? $_GET['action'] : ''; $aData = array(); $aViewUrls = array(); if (Permission::model()->hasGlobalPermission('panellist', 'update')) { if ($action == "editquestion") { // Project details $question_id = (int) Yii::app()->request->getPost("question_id"); $category_id = (int) Yii::app()->request->getPost("category"); $short_title = flattenText($_POST['question_short_title'], false, true, 'UTF-8', true); $title = flattenText($_POST['question_title'], false, true, 'UTF-8', true); $field_type = flattenText($_POST['question_field_type'], false, true, 'UTF-8', true); $IsOther = flattenText(Yii::app()->request->getPost("question_is_other")); $is_other = 0; if ($IsOther) { $is_other = 1; } $is_other_field_type = flattenText($_POST['question_field_other_type'], false, true, 'UTF-8', true); $outdate_threshold = (int) $_POST['question_outdate_threshold']; $priority = flattenText($_POST['question_priority'], false, true, 'UTF-8', true); $IsProfile = flattenText(Yii::app()->request->getPost("question_is_profile")); $is_profile = 0; if ($IsProfile) { $is_profile = 1; } $IsProject = flattenText(Yii::app()->request->getPost("question_is_project")); $is_project = 0; if ($IsProject) { $is_project = 1; } $IsActive = flattenText(Yii::app()->request->getPost("IsActive")); $is_active = 0; if ($IsActive) { $is_active = 1; } $sort_order = flattenText($_POST['sort_order'], false, true, 'UTF-8', true); if ($short_title == '') { $aViewUrls['message'] = array('title' => $clang->gT("Failed to add Question"), 'message' => $clang->gT("Question Name is invalid."), 'class' => 'warningheader'); } else { $oUser = questions::model()->findByPk($question_id); $oUser->category_id = $category_id; $oUser->short_title = $short_title; $oUser->title = $title; $oUser->field_type = $field_type; $oUser->is_other = $is_other; $oUser->is_other_field_type = $is_other_field_type; $oUser->outdate_threshold = $outdate_threshold; $oUser->priority = $priority; $oUser->is_profile = $is_profile; $oUser->is_project = $is_project; $oUser->IsActive = $is_active; $oUser->sorder = $sort_order; $oUser->modified_date = Date('y-m-d h:i:s'); $NewQuestion = $oUser->save(); if ($NewQuestion) { Yii::app()->setFlashMessage($clang->gT("Profile Question Updated successfully")); $this->getController()->redirect(array("admin/profilequestion/index")); } } } else { if (isset($_GET['question_id'])) { $aData['row'] = 0; $aData['usr_arr'] = array(); // Project detail $question_id = (int) $_GET['question_id']; $action = $_GET['action']; $sresult = profilequestionview($question_id); // only use in view_editcompany $aData['question_id'] = $question_id; $aData['mur'] = $sresult; $aData['imageurl'] = Yii::app()->getConfig("adminimageurl"); $answerlist = profileanswer_view($question_id); $aData['answer_arr'] = $answerlist; $this->_renderWrappedTemplate('panellist/questions', 'editquestion_view', $aData); return; } } } Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error'); $this->getController()->redirect(array("admin/profilequestion/index")); }
function Question($cat_id, $style = '', $quetype = false, $quelist = FALSE) { $test = ''; $question_type = array(); $question_list = array(); $sql = questions::model()->isactive()->findAll(array("condition" => "category_id = '{$cat_id}'", 'order' => 'sorder')); foreach ($sql as $key => $value) { if ($quetype) { $question_type[$value['id']] = $value['field_type']; } if ($quelist) { $question_list[$value['id']] = $value['title']; } $test .= CreateUi($value['id'], $value['title'], $value['field_type'], $style); } if ($quetype) { return $question_type; } if ($quelist) { return $question_list; } return $test; }