function getRefusalsByUrid($urid)
{
global $db;
if (isset($this->refusalsByUridArray[$urid])) {
$contacts = $this->refusalsByUridArray[$urid];
} else {
$contacts = array();
//$csidQuery = ' AND code = 103 ';
// $result = $db->selectQuery('select *, aes_decrypt(remark, "' . Config::smsContactRemarkKey() . '") as remark_dec, aes_decrypt(proxyname, "' . Config::smsContactNameKey() . '") as proxyname_dec from ' . Config::dbSurvey() . '_contacts as t1 left join ' . Config::dbSurvey() . '_users as t2 on t1.urid = t2.urid where t1.urid = ' . prepareDatabaseString($urid) . $csidQuery . ' order by t1.contactts desc');
//echo '<br/><br/><br/>'. 'select *, aes_decrypt(remark, "' . Config::smsContactRemarkKey() . '") as remark_dec, aes_decrypt(proxyname, "' . Config::smsContactNameKey() . '") as proxyname_dec from ' . Config::dbSurvey() . '_contacts as t1 left join ' . Config::dbSurvey() . '_users as t2 on t1.urid = t2.urid where t1.urid = ' . prepareDatabaseString($urid) . ' order by t1.contactts desc';
$query = 'select *, aes_decrypt(remark, "' . Config::smsContactRemarkKey() . '") as remark_dec, aes_decrypt(proxyname, "' . Config::smsContactNameKey() . '") as proxyname_dec from ' . Config::dbSurvey() . '_contacts as t1 ';
$query .= 'left join ' . Config::dbSurvey() . '_users as t2 on t1.urid = t2.urid ';
$query .= 'left join ' . Config::dbSurvey() . '_respondents as t3 on t1.primkey = t3.primkey ';
$query .= 'where t3.primkey is not null AND ' . getTextmodeStr() . ' t1.urid = ' . prepareDatabaseString($urid) . ' order by t1.contactts desc';
$result = $db->selectQuery($query);
while ($row = $db->getRow($result)) {
$contact = new Contact($row);
if ($contact->isRefusal()) {
$contacts[] = $contact;
}
}
$this->refusalsByUridArray[$urid] = $contacts;
}
return $contacts;
}
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);
}
}
}
$respondents[$row['hhid']] = new Household($row['hhid']);
}
*/
//search through remarks
$this->searchRemarks($respondents, $searchterm, $test, 1);
//respondents
$this->searchRemarks($respondents, $searchterm, $test, 2);
//households
//search through contacts
$this->searchContacts($respondents, $searchterm, $test, 1);
//respondents
$this->searchContacts($respondents, $searchterm, $test, 2);
//households
return $respondents;
}
function searchRemarks(&$respondents, $searchterm, $uridStr, $type = 1)
