function getFieldIsNull($rorh = 1, $fieldname)
{
global $db;
$dataStr = '';
$actions = array();
//99900174
$userStr = $this->getUridQuery();
if ($rorh == 1) {
//houseohld level
$query = 'select DATE(t1.ts) as dateobs, count(*) as cntobs, t1.primkey from ' . dbConfig::dbSurveyData() . '_data as t1 ';
$query .= 'left join ' . dbConfig::dbSurvey() . '_households t2 on t2.primkey = t1.primkey ';
$query .= 'where ' . $userStr . getTextmodeStr('t1.') . ' t1.ts > "' . date('Y-m-d', config::graphStartDate()) . ' 23:59:99" AND suid = ' . $rorh . ' and variablename="' . $fieldname . '" and answer is null 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::dbSurveyData() . '_data as t1 ';
$query .= 'left join ' . dbConfig::dbSurvey() . '_respondents t2 on t2.primkey = t1.primkey ';
$query .= 'where ' . $userStr . getTextmodeStr('t1.') . ' t1.ts > "' . date('Y-m-d', config::graphStartDate()) . ' 23:59:99" AND suid = ' . $rorh . ' and variablename="' . $fieldname . '" and answer is null group by DATE(t1.ts) order by t1.ts asc';
}
//$query = 'select DATE(ts) as dateobs, count(*) as cntobs, primkey from recruit_data ';
//$query .= 'where ' . getTextmodeStr('') . ' ts > "' . date('Y-m-d', config::graphStartDate()) . ' 23:59:99" AND suid = ' . $rorh . ' and variablename="' . $fieldname . '" and answer is null 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;
}
