------------------------------------------------------------------------
*/
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;
}
