------------------------------------------------------------------------ */ require_once "common.php"; class Config { private static $table; /* DATABASE */
function showOtherData() { global $db; $type = getFromSessionParams('type'); if ($type != '') { $filename = '_' . date('YmdHis'); $query = ''; switch ($type) { case 1: $filename = 'households' . $filename; $query = 'select primkey,urid,puid,status,ts from ' . dbConfig::dbSurvey() . '_households where test = 0 order by primkey'; break; case 2: $filename = 'respondents' . $filename; $query = 'select primkey,hhid,urid,status,selected,present,hhhead,finr,famr,permanent,validation,ts from ' . dbConfig::dbSurvey() . '_respondents where test = 0 order by primkey'; break; case 3: $filename = 'contacts' . $filename; $query = 'select primkey,code,contactts,proxy,urid, aes_decrypt(remark, "' . Config::smsContactRemarkKey() . '") as remark, ts from ' . dbConfig::dbSurvey() . '_contacts where primkey not like "999%"'; break; case 4: $filename = 'remarks' . $filename; $query = 'select primkey,urid, aes_decrypt(remark, "' . Config::smsRemarkKey() . '") as remark, ts from ' . dbConfig::dbSurvey() . '_remarks where primkey not like "999%"'; break; } if ($query != '') { $result = $db->selectQuery($query); createCSV($result, $filename); } } }
function getContactCodeData($code, $urid = 0, $rorh = 2) { global $db; $dataStr = ''; $actions = array(); $uridstr = ''; if ($urid > 0) { $uridstr = ' t1.urid = ' . $urid . ' AND '; } else { $uridstr = $this->getUridQuery('t2.'); } if ($rorh == 1) { //houseohld level $query = 'select DATE(t1.ts) as dateobs, count(*) as cntobs, t1.primkey from ' . dbConfig::dbSurvey() . '_contacts as t1 '; $query .= 'left join ' . dbConfig::dbSurvey() . '_households as t2 on t2.primkey = t1.primkey '; $query .= 'where ' . $uridstr . getTextmodeStr() . ' t1.ts > "' . date('Y-m-d', config::graphStartDate()) . ' 23:59:99" AND t2.primkey is not null and t1.code = ' . $code . ' group by DATE(t1.ts) order by t1.ts asc'; } else { $query = 'select DATE(t1.ts) as dateobs, count(*) as cntobs, t1.primkey from ' . dbConfig::dbSurvey() . '_contacts as t1 '; $query .= 'left join ' . dbConfig::dbSurvey() . '_respondents t2 on t2.primkey = t1.primkey '; $query .= 'where ' . $uridstr . getTextmodeStr() . ' t1.ts > "' . date('Y-m-d', config::graphStartDate()) . ' 23:59:99" AND t2.primkey is not null and t1.code = ' . $code . ' group by DATE(t1.ts) order by t1.ts asc'; //$query = 'select DATE(ts) as dateobs, count(*) as cntobs, primkey from ' . dbConfig::dbSurvey() . '_contacts as t1 where code = ' . $code . $uridstr . ' group by DATE(ts) order by ts asc'; } // echo '<br/><br/><br/>' . $query; $total = 0; $dataStr .= "[Date.UTC(" . date('Y,m,d', strtotime(date('Y-m-d', config::graphStartDate()) . " -1 months")) . "), 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; }