Exemplo n.º 1
0
 /**
  * Show dialogs and create a new tokens table
  */
 function _newtokentable($iSurveyId)
 {
     $clang = $this->getController()->lang;
     $aSurveyInfo = getSurveyInfo($iSurveyId);
     if (!Permission::model()->hasSurveyPermission($iSurveyId, 'surveysettings', 'update') && !Permission::model()->hasSurveyPermission($iSurveyId, 'tokens', 'create')) {
         Yii::app()->session['flashmessage'] = $clang->gT("Tokens have not been initialised for this survey.");
         $this->getController()->redirect(array("/admin/survey/sa/view/surveyid/{$iSurveyId}"));
     }
     $bTokenExists = tableExists('{{tokens_' . $iSurveyId . '}}');
     if ($bTokenExists) {
         Yii::app()->session['flashmessage'] = $clang->gT("Tokens already exist for this survey.");
         $this->getController()->redirect(array("/admin/survey/sa/view/surveyid/{$iSurveyId}"));
     }
     // The user have rigth to create token, then don't test right after
     Yii::import('application.helpers.admin.token_helper', true);
     if (Yii::app()->request->getQuery('createtable') == "Y") {
         createTokenTable($iSurveyId);
         LimeExpressionManager::SetDirtyFlag();
         // LimeExpressionManager needs to know about the new token table
         $this->_renderWrappedTemplate('token', array('message' => array('title' => $clang->gT("Token control"), 'message' => $clang->gT("A token table has been created for this survey.") . " (\"" . Yii::app()->db->tablePrefix . "tokens_{$iSurveyId}\")<br /><br />\n" . "<input type='submit' value='" . $clang->gT("Continue") . "' onclick=\"window.open('" . $this->getController()->createUrl("admin/tokens/sa/index/surveyid/{$iSurveyId}") . "', '_top')\" />\n")));
     } elseif (returnGlobal('restoretable') == "Y" && Yii::app()->request->getPost('oldtable')) {
         //Rebuild attributedescription value for the surveys table
         $table = Yii::app()->db->schema->getTable(Yii::app()->request->getPost('oldtable'));
         $fields = array_filter(array_keys($table->columns), 'filterForAttributes');
         $fieldcontents = $aSurveyInfo['attributedescriptions'];
         if (!is_array($fieldcontents)) {
             $fieldcontents = array();
         }
         foreach ($fields as $fieldname) {
             $name = $fieldname;
             if ($fieldname[10] == 'c') {
                 //This belongs to a cpdb attribute
                 $cpdbattid = substr($fieldname, 15);
                 $data = ParticipantAttributeName::model()->getAttributeName($cpdbattid, Yii::app()->session['adminlang']);
                 $name = $data['attribute_name'];
             }
             if (!isset($fieldcontents[$fieldname])) {
                 $fieldcontents[$fieldname] = array('description' => $name, 'mandatory' => 'N', 'show_register' => 'N');
             }
         }
         Survey::model()->updateByPk($iSurveyId, array('attributedescriptions' => serialize($fieldcontents)));
         Yii::app()->db->createCommand()->renameTable(Yii::app()->request->getPost('oldtable'), Yii::app()->db->tablePrefix . "tokens_" . intval($iSurveyId));
         Yii::app()->db->schema->getTable(Yii::app()->db->tablePrefix . "tokens_" . intval($iSurveyId), true);
         // Refresh schema cache just in case the table existed in the past
         //Check that the tokens table has the required fields
         TokenDynamic::model($iSurveyId)->checkColumns();
         //Add any survey_links from the renamed table
         SurveyLink::model()->rebuildLinksFromTokenTable($iSurveyId);
         $this->_renderWrappedTemplate('token', array('message' => array('title' => $clang->gT("Import old tokens"), 'message' => $clang->gT("A token table has been created for this survey and the old tokens were imported.") . " (\"" . Yii::app()->db->tablePrefix . "tokens_{$iSurveyId}" . "\")<br /><br />\n" . "<input type='submit' value='" . $clang->gT("Continue") . "' onclick=\"window.open('" . $this->getController()->createUrl("admin/tokens/sa/index/surveyid/{$iSurveyId}") . "', '_top')\" />\n")));
         LimeExpressionManager::SetDirtyFlag();
         // so that knows that token tables have changed
     } else {
         $this->getController()->loadHelper('database');
         $result = Yii::app()->db->createCommand(dbSelectTablesLike("{{old_tokens_" . intval($iSurveyId) . "_%}}"))->queryAll();
         $tcount = count($result);
         if ($tcount > 0) {
             foreach ($result as $rows) {
                 $oldlist[] = reset($rows);
             }
             $aData['oldlist'] = $oldlist;
         }
         $thissurvey = getSurveyInfo($iSurveyId);
         $aData['thissurvey'] = $thissurvey;
         $aData['surveyid'] = $iSurveyId;
         $aData['tcount'] = $tcount;
         $aData['databasetype'] = Yii::app()->db->getDriverName();
         $this->_renderWrappedTemplate('token', 'tokenwarning', $aData);
     }
 }
 function attributeMapToken()
 {
     Yii::app()->loadHelper('common');
     App()->getClientScript()->registerScriptFile(Yii::app()->getConfig('adminscripts') . "attributeMapToken.js");
     App()->getClientScript()->registerCssFile(Yii::app()->getConfig('adminstyleurl') . "attributeMapToken.css");
     $iSurveyID = (int) Yii::app()->request->getQuery('sid');
     $aCPDBAttributes = ParticipantAttributeName::model()->getCPDBAttributes();
     $aTokenAttributes = getTokenFieldsAndNames($iSurveyID, TRUE);
     $selectedattribute = array();
     $selectedcentralattribute = array();
     $alreadymappedattid = array();
     $alreadymappedattdisplay = array();
     $alreadymappedattnames = array();
     $i = 0;
     $j = 0;
     foreach ($aTokenAttributes as $key => $value) {
         if ($value['cpdbmap'] == '') {
             $selectedattribute[$value['description']] = $key;
         } else {
             $attributeid = $value['cpdbmap'];
             $continue = false;
             foreach ($aCPDBAttributes as $attribute) {
                 if ($attribute['attribute_id'] == $attributeid) {
                     $continue = true;
                 }
             }
             if ($continue) {
                 $alreadymappedattid[] = $attributeid;
                 $alreadymappedattdisplay[] = $key;
                 $alreadymappedattnames[$key] = $value['description'];
             } else {
                 $selectedattribute[$value['description']] = $key;
             }
         }
     }
     foreach ($aCPDBAttributes as $row) {
         if (!in_array($row['attribute_id'], $alreadymappedattid)) {
             $selectedcentralattribute[$row['attribute_id']] = $row['attribute_name'];
         }
     }
     $aData = array('attribute' => $selectedcentralattribute, 'tokenattribute' => $selectedattribute, 'alreadymappedattributename' => $alreadymappedattdisplay, 'alreadymappedattdescription' => $alreadymappedattnames);
     $this->_renderWrappedTemplate('participants', 'attributeMapToken', $aData);
 }
Exemplo n.º 3
0
 private function getParticipantsSelectCommand($count = false, $attid, $search = null, $userid = null, $page = null, $limit = null, $order = null)
 {
     $selectValue = array();
     $joinValue = array();
     $selectValue[] = "p.*";
     $selectValue[] = "luser.full_name as ownername";
     $selectValue[] = "luser.users_name as username";
     $aAllAttributes = ParticipantAttributeName::model()->getAllAttributes();
     foreach ($aAllAttributes as $aAttribute) {
         if (!is_null($search) && strpos($search->condition, 'attribute' . $aAttribute['attribute_id']) !== false) {
             $attid[$aAttribute['attribute_id']] = $aAttribute;
         }
     }
     // Add survey count subquery
     $subQuery = Yii::app()->db->createCommand()->select('count(*) survey')->from('{{survey_links}} sl')->where('sl.participant_id = p.participant_id');
     $selectValue[] = sprintf('(%s) survey', $subQuery->getText());
     array_push($joinValue, "left join {{users}} luser ON luser.uid=p.owner_uid");
     foreach ($attid as $iAttributeID => $aAttributeDetails) {
         if ($iAttributeID == 0) {
             continue;
         }
         $sDatabaseType = Yii::app()->db->getDriverName();
         if ($sDatabaseType == 'mssql' || $sDatabaseType == "sqlsrv" || $sDatabaseType == 'dblib') {
             $selectValue[] = "cast(attribute" . $iAttributeID . ".value as varchar(max)) as a" . $iAttributeID;
         } else {
             $selectValue[] = "attribute" . $iAttributeID . ".value as a" . $iAttributeID;
         }
         array_push($joinValue, "LEFT JOIN {{participant_attribute}} attribute" . $iAttributeID . " ON attribute" . $iAttributeID . ".participant_id=p.participant_id AND attribute" . $iAttributeID . ".attribute_id=" . $iAttributeID);
     }
     $aConditions = array();
     // this wil hold all conditions
     $aParams = array();
     if (!is_null($userid)) {
         // We are not superadmin so we need to limit to our own or shared with us
         $selectValue[] = '{{participant_shares}}.can_edit';
         $joinValue[] = 'LEFT JOIN {{participant_shares}} ON p.participant_id={{participant_shares}}.participant_id';
         $aConditions[] = 'p.owner_uid = :userid1 OR {{participant_shares}}.share_uid = :userid2 OR {{participant_shares}}.share_uid = 0';
     }
     if ($count) {
         $selectValue = 'count(*) as cnt';
     }
     $data = Yii::app()->db->createCommand()->select($selectValue)->from('{{participants}} p');
     $data->setJoin($joinValue);
     if (!empty($search)) {
         /* @var $search CDbCriteria */
         $aSearch = $search->toArray();
         $aConditions[] = $aSearch['condition'];
         $aParams = $aSearch['params'];
     }
     if (Yii::app()->getConfig('hideblacklisted') == 'Y') {
         $aConditions[] = "blacklisted<>'Y'";
     }
     $condition = '';
     // This will be the final condition
     foreach ($aConditions as $idx => $newCondition) {
         if ($idx > 0) {
             $condition .= ' AND ';
         }
         $condition .= '(' . $newCondition . ')';
     }
     if (!empty($condition)) {
         $data->setWhere($condition);
     }
     if (!$count) {
         // Apply order and limits
         if (!empty($order)) {
             $data->setOrder($order);
         }
         if ($page != 0) {
             $offset = ($page - 1) * $limit;
             $data->offset($offset)->limit($limit);
         }
     }
     $data->bindValues($aParams);
     if (!is_null($userid)) {
         $data->bindParam(":userid1", $userid, PDO::PARAM_INT)->bindParam(":userid2", $userid, PDO::PARAM_INT);
     }
     return $data;
 }
Exemplo n.º 4
0
 /**
  * Check for column duplicates from CPDB to token attributes
  * Throws error message if an attribute already exists; otherwise false.
  *
  * @param int $surveyId
  * @param string[] $newAttributes Array of CPDB attributes ids like ['42', '32', ...]
  * @return boolean
  * @throws CPDBException with error message
  */
 private function checkColumnDuplicates($surveyId, array $newAttributes)
 {
     $tokenTableSchema = Yii::app()->db->schema->getTable("{{tokens_{$surveyId}}}");
     foreach ($tokenTableSchema->columns as $columnName => $columnObject) {
         if (strpos($columnName, 'attribute_') !== false) {
             $id = substr($columnName, 10);
             if (in_array($id, $newAttributes)) {
                 $name = ParticipantAttributeName::model()->getAttributeName($id, $_SESSION['adminlang']);
                 if (empty($name)) {
                     $name = array('attribute_name' => '[Found no name]');
                 }
                 throw new CPDBException(sprintf("Token attribute already exists: %s", $name['attribute_name']));
             }
         }
     }
     return false;
 }
 function storeAttributeCSV($data)
 {
     $oParticipantAttributeName = new ParticipantAttributeName();
     $oParticipantAttributeName->attribute_type = $data['attribute_type'];
     $oParticipantAttributeName->defaultname = $data['defaultname'];
     $oParticipantAttributeName->visible = $data['visible'];
     $oParticipantAttributeName->save();
     $iAttributeID = $oParticipantAttributeName->attribute_id;
     $oParticipantAttributeNameLang = new ParticipantAttributeNameLang();
     $oParticipantAttributeNameLang->attribute_id = $iAttributeID;
     $oParticipantAttributeNameLang->attribute_name = $data['defaultname'];
     $oParticipantAttributeNameLang->lang = Yii::app()->session['adminlang'];
     $oParticipantAttributeNameLang->save();
     return $iAttributeID;
 }
Exemplo n.º 6
0
 /**
  * This function is responsible for attribute mapping while copying participants from tokens to CPDB
  */
 public function attributeMapToken()
 {
     Yii::app()->loadHelper('common');
     $this->registerScriptFile('ADMIN_SCRIPT_PATH', 'attributeMapToken.js');
     $this->registerCssFile('ADMIN', 'attributeMapToken.css');
     $iSurveyID = (int) Yii::app()->request->getQuery('sid');
     $aCPDBAttributes = ParticipantAttributeName::model()->getCPDBAttributes();
     $aTokenAttributes = getTokenFieldsAndNames($iSurveyID, TRUE);
     $selectedattribute = array();
     $selectedcentralattribute = array();
     $alreadymappedattid = array();
     $alreadymappedattdisplay = array();
     $alreadymappedattnames = array();
     foreach ($aTokenAttributes as $key => $value) {
         if ($value['cpdbmap'] == '') {
             $selectedattribute[$value['description']] = $key;
         } else {
             $attributeid = $value['cpdbmap'];
             $continue = false;
             foreach ($aCPDBAttributes as $attribute) {
                 if ($attribute['attribute_id'] == $attributeid) {
                     $continue = true;
                 }
             }
             if ($continue) {
                 $alreadymappedattid[] = $attributeid;
                 $alreadymappedattdisplay[] = $key;
                 $alreadymappedattnames[$key] = $value['description'];
             } else {
                 $selectedattribute[$value['description']] = $key;
             }
         }
     }
     foreach ($aCPDBAttributes as $row) {
         if (!in_array($row['attribute_id'], $alreadymappedattid)) {
             $selectedcentralattribute[$row['attribute_id']] = $row['attribute_name'];
         }
     }
     if (count($selectedattribute) === 0) {
         Yii::app()->setFlashMessage(gT("There are no unmapped attributes"), 'warning');
     }
     $aData = array('attribute' => $selectedcentralattribute, 'tokenattribute' => $selectedattribute, 'alreadymappedattributename' => $alreadymappedattdisplay, 'alreadymappedattdescription' => $alreadymappedattnames);
     $this->_renderWrappedTemplate('participants', 'attributeMapToken', $aData);
 }
Exemplo n.º 7
0
 /**
  * This function import a participant to the LimeSurvey cpd. It stores attributes as well, if they are registered before within ui
  *
  * Call the function with $response = $myJSONRPCClient->cpd_importParticipants( $sessionKey, $aParticipants);
  *
  * @param int $sSessionKey
  * @param array $aParticipants
  * [[0] => ["email"=>"*****@*****.**","firstname"=>"max","lastname"=>"mustermann"]]
  * @return array with status
  */
 public function cpd_importParticipants($sSessionKey, $aParticipants)
 {
     if (!$this->_checkSessionKey($sSessionKey)) {
         return array('status' => 'Invalid session key');
     }
     $aResponse = array();
     $aAttributeData = array();
     $aAttributes = array();
     $aDefaultFields = array('participant_id', 'firstname', 'lastname', 'email', 'language', 'blacklisted');
     $bIsValidEmail = true;
     $bDoImport = true;
     $sMandatory = 0;
     $sAttribCount = 0;
     $aResponse = array();
     $aResponse['ImportCount'] = 0;
     // get all attributes for mapping
     $oFindCriteria = new CDbCriteria();
     $oFindCriteria->offset = -1;
     $oFindCriteria->limit = -1;
     $aAttributeRecords = ParticipantAttributeName::model()->with('participant_attribute_names_lang')->findAll($oFindCriteria);
     foreach ($aParticipants as $sKey => $aParticipantData) {
         $aData = array('firstname' => $aParticipantData['firstname'], 'lastname' => $aParticipantData['lastname'], 'email' => $aParticipantData['email'], 'owner_uid' => Yii::app()->session['loginID']);
         //Check for duplicate participants
         $arRecordExists = Participant::model()->exists('firstname = :firstname AND lastname = :lastname AND email = :email AND owner_uid = :owner_uid', array(':firstname' => $aData['firstname'], ':lastname' => $aData['lastname'], ':email' => $aData['email'], ':owner_uid' => $aData['owner_uid']));
         // check if email is valid
         $this->_checkEmailFormat($aData['email']);
         if ($bIsValidEmail == true) {
             //First, process the known fields
             if (!isset($aData['participant_id']) || $aData['participant_id'] == "") {
                 //  $arParticipantModel = new Participant();
                 $aData['participant_id'] = Participant::gen_uuid();
             }
             if (isset($aData['emailstatus']) && trim($aData['emailstatus'] == '')) {
                 unset($aData['emailstatus']);
             }
             if (!isset($aData['language']) || $aData['language'] == "") {
                 $aData['language'] = "en";
             }
             if (!isset($aData['blacklisted']) || $aData['blacklisted'] == "") {
                 $aData['blacklisted'] = "N";
             }
             $aData['owner_uid'] = Yii::app()->session['loginID'];
             if (isset($aData['validfrom']) && trim($aData['validfrom'] == '')) {
                 unset($aData['validfrom']);
             }
             if (isset($aData['validuntil']) && trim($aData['validuntil'] == '')) {
                 unset($aData['validuntil']);
             }
             if (!empty($aData['email'])) {
                 //The mandatory fields of email, firstname and lastname
                 $sMandatory++;
                 $bDoImport = false;
             }
             // Write to database if record not exists
             if (empty($arRecordExists)) {
                 // save participant to database
                 Participant::model()->insertParticipantCSV($aData);
                 // Prepare atrribute values to store in db . Iterate through our values
                 foreach ($aParticipantData as $sLabel => $sAttributeValue) {
                     // skip default fields
                     if (!in_array($sLabel, $aDefaultFields)) {
                         foreach ($aAttributeRecords as $sKey => $arValue) {
                             $aAttributes = $arValue->getAttributes();
                             if ($aAttributes['defaultname'] == $sLabel) {
                                 $aAttributeData['participant_id'] = $aData['participant_id'];
                                 $aAttributeData['attribute_id'] = $aAttributes['attribute_id'];
                                 $aAttributeData['value'] = $sAttributeValue;
                                 $sAttribCount++;
                                 // save attributes values for participant
                                 ParticipantAttributeName::model()->saveParticipantAttributeValue($aAttributeData);
                             }
                         }
                     }
                 }
                 $aResponse['ImportCount']++;
             }
         }
     }
     return $aResponse;
 }
 /**
  * RPC Routine to get all the participants in the Central Participants Database
  *
  * @access public
  * @param string $sSessionKey - Auth credentials
  * @param string $search - (null is passed when searching all participants)
  * @param int $page - (can be empty)
  * 
  * */
 public function get_global_participants($sSessionKey, $search = null, $page = null, $results_per_page = 1000000)
 {
     // Check sessionkey
     if (!$this->_checkSessionKey($sSessionKey)) {
         return array('status' => 'Invalid session key');
     }
     // this is because the JSON-RPC libary ignores variable names and just goes on the position of the variable when called
     if ($page == null) {
         $page = 1;
     }
     $number_of_rows = $results_per_page;
     // Cut'n'pate from > applications/controllers/admin/participantsaction.php
     //$page = $page;
     $limit = $number_of_rows;
     $limit = isset($limit) ? $limit : 50;
     //Stop division by zero errors (don't know if this is still needed if it is populated in the function call)
     // adds additional user attributes to the end of the array
     $attid = ParticipantAttributeName::model()->getVisibleAttributes();
     $participantfields = array('participant_id', 'can_edit', 'firstname', 'lastname', 'email', 'blacklisted', 'survey', 'language', 'owner_uid');
     foreach ($attid as $key => $value) {
         array_push($participantfields, $value['attribute_id']);
     }
     // sorts the array
     // TODO:
     $sidx = Yii::app()->request->getPost('sidx');
     $sidx = !empty($sidx) ? $sidx : "lastname";
     $sord = Yii::app()->request->getPost('sord');
     $sord = !empty($sord) ? $sord : "asc";
     $order = $sidx . " " . $sord;
     $aData = new stdClass();
     //If super admin all the participants will be visible
     if (Permission::model()->hasGlobalPermission('superadmin', 'read')) {
         $iUserID = null;
     } else {
         $iUserID = Yii::app()->session['loginID'];
     }
     $aData->records = Participant::model()->getParticipantsCount($attid, $search, $iUserID);
     $aData->total = ceil($aData->records / $limit);
     if ($page > $aData->total) {
         $page = $aData->total;
     }
     $aData->page = $page;
     $records = Participant::model()->getParticipants($page, $limit, $attid, $order, $search, $iUserID);
     $aRowToAdd = array();
     foreach ($records as $key => $row) {
         if (array_key_exists('can_edit', $row)) {
             $sCanEdit = $row['can_edit'];
             if (is_null($sCanEdit)) {
                 $sCanEdit = 'true';
             }
             // Super admin
         } else {
             $sCanEdit = "true";
         }
         if (trim($row['ownername']) == '') {
             $row['ownername'] = $row['username'];
         }
         $aRowToAdd['cell'] = array($row['participant_id'], $sCanEdit, htmlspecialchars($row['firstname']), htmlspecialchars($row['lastname']), htmlspecialchars($row['email']), $row['blacklisted'], $row['survey'], $row['language'], $row['ownername']);
         $aRowToAdd['id'] = $row['participant_id'];
         // add attribute values
         foreach ($row as $key => $attvalue) {
             if (preg_match('/^a\\d+$/', $key)) {
                 $aRowToAdd['cell'][] = $attvalue;
             }
         }
         $aData->rows[] = $aRowToAdd;
     }
     return $aData;
 }
 function getnotaddedAttributes($attributeid)
 {
     $output = array();
     $notin = array();
     foreach ($attributeid as $row) {
         $notin[] = $row;
     }
     $criteria = new CDbCriteria();
     $alias = $this->getTableAlias();
     $criteria->addNotInCondition("{$alias}.attribute_id", $attributeid);
     $records = ParticipantAttributeName::model()->with('participant_attribute_names_lang')->findAll($criteria);
     foreach ($records as $row) {
         //Iterate through each attribute
         $thisname = "";
         $thislang = "";
         foreach ($row->participant_attribute_names_lang as $names) {
             //Iterate through each language version of this attribute
             if ($thisname == "") {
                 $thisname = $names->attribute_name;
                 $thislang = $names->lang;
             }
             //Choose the first item by default
             if ($names->lang == Yii::app()->session['adminlang']) {
                 $thisname = $names->attribute_name;
                 $thislang = $names->lang;
             }
             //Override the default with the admin language version if found
         }
         $output[] = array('attribute_id' => $row->attribute_id, 'attribute_type' => $row->attribute_type, 'attribute_display' => $row->visible, 'attribute_name' => $thisname, 'lang' => $thislang);
     }
     return $output;
 }
 /**
  * Adds the data for a new attribute
  * 
  * @param mixed $data
  */
 function storeAttribute($data)
 {
     $insertnames = array('attribute_type' => $data['attribute_type'], 'defaultname' => $data['defaultname'], 'visible' => $data['visible']);
     // Do not allow more than 60 attributes because queries will break because of too many joins
     if (ParticipantAttributeName::model()->count() > 59) {
         return false;
     }
     Yii::app()->db->createCommand()->insert('{{participant_attribute_names}}', $insertnames);
     $attribute_id = getLastInsertID($this->tableName());
     $insertnameslang = array('attribute_id' => intval($attribute_id), 'attribute_name' => $data['attribute_name'], 'lang' => Yii::app()->session['adminlang']);
     Yii::app()->db->createCommand()->insert('{{participant_attribute_names_lang}}', $insertnameslang);
     return $attribute_id;
 }