Example #1
0
 function getArrayData($survey, $fieldname)
 {
     global $db;
     $array = array();
     $query = 'select distinct variablename from ' . Config::dbSurveyData() . '_data where suid = ' . $survey . ' and variablename like "' . $fieldname . '[%" and length(primkey) > ' . Config::getMinimumPrimaryKeyLength() . ' and length(primkey) < ' . Config::getMaximumPrimaryKeyLength();
     $result = $db->selectQuery($query);
     if ($db->getNumberOfRows($result) > 0) {
         while ($row = $db->getRow($result)) {
             $array[] = $row["variablename"];
         }
     }
     return $array;
 }
Example #2
0
 function DataExport($suid)
 {
     global $db, $survey;
     $this->db = $db;
     $this->suid = $suid;
     $this->survey = new Survey($this->suid);
     $survey = $this->survey;
     $this->variabledescriptives = array();
     $this->setProperty(DATA_OUTPUT_MAINTABLE, Config::dbSurvey());
     $this->setProperty(DATA_OUTPUT_MAINDATATABLE, Config::dbSurveyData());
     /* set file names */
     $this->setProperty(DATA_OUTPUT_FILENAME, $this->getProperty(DATA_OUTPUT_MAINTABLE));
     /* set defaults */
     $this->setProperty(DATA_OUTPUT_FILETYPE, FILETYPE_STATA);
     $this->setProperty(DATA_OUTPUT_SURVEY, "");
     $this->setProperty(DATA_OUTPUT_MODES, "");
     $this->setProperty(DATA_OUTPUT_LANGUAGES, "");
     $this->setProperty(DATA_OUTPUT_VERSIONS, "");
     $this->setProperty(DATA_OUTPUT_PRIMARY_KEY_IN_DATA, PRIMARYKEY_YES);
     $this->setProperty(DATA_OUTPUT_HIDDEN, DATA_NOTHIDDEN);
     $this->setProperty(DATA_OUTPUT_CLEAN, DATA_DIRTY);
     $this->setProperty(DATA_OUTPUT_INCLUDE_VALUE_LABEL_NUMBERS, VALUELABELNUMBERS_YES);
     $this->setProperty(DATA_OUTPUT_FIELDNAME_CASE, FIELDNAME_LOWERCASE);
     $this->setProperty(DATA_OUTPUT_INCLUDE_VALUE_LABELS, VALUELABEL_YES);
     $this->setProperty(DATA_OUTPUT_VARIABLES_WITHOUT_DATA, VARIABLES_WITHOUT_DATA_YES);
     $this->setProperty(DATA_OUTPUT_VALUELABEL_PREFIX, $this->getProperty(DATA_OUTPUT_MAINTABLE) . "_vl");
     $this->setProperty(DATA_OUTPUT_VALUELABEL_WIDTH, VALUELABEL_WIDTH_FULL);
     $this->setProperty(DATA_OUTPUT_ENCODING, "UTF-8");
     $this->setProperty(DATA_OUTPUT_COMPLETED, INTERVIEW_NOTCOMPLETED);
     $this->setProperty(DATA_OUTPUT_MARK_EMPTY, MARKEMPTY_IN_VARIABLE);
     $this->setProperty(DATA_OUTPUT_KEEP_ONLY, DATA_KEEP_NO);
     $this->setProperty(DATA_OUTPUT_CLEAN, DATA_CLEAN);
     $this->setProperty(DATA_OUTPUT_TYPEDATA, DATA_REAL);
     $this->setProperty(DATA_OUTPUT_VARLIST, "");
     $this->setProperty(DATA_OUTPUT_TYPE, DATA_OUTPUT_TYPE_DATA_TABLE);
     $this->setProperty(DATA_OUTPUT_PRIMARY_KEY_ENCRYPTION, "");
     $this->setProperty(DATA_OUTPUT_FROM, "");
     $this->setProperty(DATA_OUTPUT_TO, "");
     $this->minprimkeylength = Config::getMinimumPrimaryKeyLength();
     $this->maxprimkeylength = Config::getMaximumPrimaryKeyLength();
 }
 function getFieldNotNull($survey, $fieldname)
 {
     global $db;
     $dataStr = '';
     $actions = array();
     //99900174
     $query = 'select DATE(ts) as dateobs, count(*) as cntobs, primkey from ' . Config::dbSurveyData() . '_data where suid = ' . $survey . ' and variablename="' . $fieldname . '" and length(primkey) > ' . Config::getMinimumPrimaryKeyLength() . ' and length(primkey) < ' . Config::getMaximumPrimaryKeyLength() . '  and answer is not null group by DATE(ts) order by ts asc';
     $total = 0;
     $dataStr .= "[Date.UTC(2014,  6, 20), 0   ],";
     $result = $db->selectQuery($query);
     while ($row = $db->getRow($result)) {
         $key = $row['dateobs'];
         $total += $row['cntobs'];
         $dataStr .= "[Date.UTC(" . substr($key, 0, 4) . ", " . (substr($key, 5, 2) - 1) . ", " . substr($key, 8, 2) . "), " . $total . "],";
     }
     $returnStr = rtrim($dataStr, ',');
     return $returnStr;
 }