function GPS($village, $dwellingid)
{
global $db;
$query = 'select *,';
$query .= 'aes_decrypt(latitude, "' . Config::smsPersonalInfoKey() . '") as latitude, ';
$query .= 'aes_decrypt(longitude, "' . Config::smsPersonalInfoKey() . '") as longitude ';
$query .= ' from ' . Config::dbSurvey() . '_gps where dwellingid = "' . prepareDatabaseString($dwellingid) . '" and code = "' . prepareDatabaseString($village) . '"';
//echo '<br/><br/><br/>' . $query;
$result = $db->selectQuery($query);
$this->gps = $db->getRow($result);
}
function getRespondentsByUserSearch($user, $searchterm, $uridcheck = true)
{
global $db;
$respondents = array();
$test = 'test = 0';
if ($user->isTestMode()) {
$test = 'test = 1';
}
//$userstr = ' 1 = 1 ';
if ($uridcheck) {
$test .= ' AND t1.urid = ' . prepareDatabaseString($user->getUrid());
}
//search through respondent table
$query = 'select *, aes_decrypt(firstname, \'' . Config::smsPersonalInfoKey() . '\') as firstname_dec,
aes_decrypt(lastname, \'' . Config::smsPersonalInfoKey() . '\') as lastname_dec
from ' . Config::dbSurvey() . '_respondents as t1
where ' . $test . ' and (
t1.primkey like "%' . prepareDatabaseString($searchterm) . '%" or
aes_decrypt(firstname, \'' . Config::smsPersonalInfoKey() . '\') like "%' . prepareDatabaseString($searchterm) . '%" or
aes_decrypt(lastname, \'' . Config::smsPersonalInfoKey() . '\') like "%' . prepareDatabaseString($searchterm) . '%"
)';
$result = $db->selectQuery($query);
while ($row = $db->getRow($result)) {
$respondents[$row['primkey']] = new Respondent($row);
}
//search through remarks
$query = 'select *, aes_decrypt(firstname, \'' . Config::smsPersonalInfoKey() . '\') as firstname_dec,
aes_decrypt(lastname, \'' . Config::smsPersonalInfoKey() . '\') as lastname_dec
from ' . Config::dbSurvey() . '_remarks as t1
left join ' . Config::dbSurvey() . '_respondents as t2
on t1.primkey = t2.primkey
where t2.' . $test . ' and (
aes_decrypt(remark, \'' . Config::smsRemarkKey() . '\') like "%' . prepareDatabaseString($searchterm) . '%"
)';
// echo '<br/><br/><br/>' . $query;
$result = $db->selectQuery($query);
while ($row = $db->getRow($result)) {
$respondents[$row['primkey']] = new Respondent($row);
}
return $respondents;
}
{
global $db;
$table = 'respondents';
if ($type == 2) {
$table = 'households';
}
$query = 'select * from ' . Config::dbSurvey() . '_remarks as t1
left join ' . Config::dbSurvey() . '_' . $table . ' as t2
on t1.primkey = t2.primkey
where t2.' . $uridStr . ' and (
UPPER(CAST(aes_decrypt(remark, "' . Config::smsRemarkKey() . '")AS CHAR)) like "%' . prepareDatabaseString(strtoupper($searchterm)) . '%"
)';
$result = $db->selectQuery($query);
while ($row = $db->getRow($result)) {
if ($type == 1) {
$respondents[$row['hhid']] = new Household($row['hhid']);
} else {
$respondents[$row['primkey']] = new Household($row['primkey']);
}
}
function saveChanges()
{
global $db;
$errorMessage = array();
$query = 'UPDATE ' . Config::dbSurvey() . '_respondents SET ';
$query .= 'logincode = AES_ENCRYPT(\'' . prepareDatabaseString($this->getLoginCode()) . '\', \'' . Config::loginCodeKey() . '\'), ';
$query .= 'firstname = AES_ENCRYPT(\'' . prepareDatabaseString($this->getFirstName()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'lastname = AES_ENCRYPT(\'' . prepareDatabaseString($this->getLastName()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'address1 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getAddress1()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'address2 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getAddress2()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'city = AES_ENCRYPT(\'' . prepareDatabaseString($this->getCity()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'puid = \'' . prepareDatabaseString($this->getPuid()) . '\', ';
$query .= 'longitude = AES_ENCRYPT(\'' . prepareDatabaseString($this->getLongitude()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'latitude = AES_ENCRYPT(\'' . prepareDatabaseString($this->getLatitude()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'zip = AES_ENCRYPT(\'' . prepareDatabaseString($this->getZip()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'telephone1 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getTelephone1()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'telephone2 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getTelephone2()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'email = AES_ENCRYPT(\'' . prepareDatabaseString($this->getEmail()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'age = AES_ENCRYPT(\'' . prepareDatabaseString($this->getAge()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'sex = AES_ENCRYPT(\'' . prepareDatabaseString($this->getSex()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'birthdate = AES_ENCRYPT(\'' . prepareDatabaseString($this->getBirthDate()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'schoolingyears = \'' . prepareDatabaseString($this->getYearsOfSchooling()) . '\', ';
$query .= 'educationlevel = \'' . prepareDatabaseString($this->getEducationLevel()) . '\', ';
$query .= 'occupationalstatus = \'' . prepareDatabaseString($this->getOccupationalStatus()) . '\', ';
$query .= 'relationshiphh = \'' . prepareDatabaseString($this->getRelationshipHhHead()) . '\', ';
$query .= 'spouseprimkey = \'' . prepareDatabaseString($this->getSpousePrimkey()) . '\', ';
$query .= 'consenttype = \'' . prepareDatabaseString($this->getConsentType()) . '\', ';
$query .= 'hhhead = \'' . prepareDatabaseString($this->getHhHead()) . '\', ';
$query .= 'famr = \'' . prepareDatabaseString($this->getFamR()) . '\', ';
$query .= 'finr = \'' . prepareDatabaseString($this->getFinR()) . '\', ';
$query .= 'covr = \'' . prepareDatabaseString($this->getCovR()) . '\', ';
if (isset($this->respondent['permanent'])) {
$query .= 'permanent = \'' . prepareDatabaseString($this->getPermanent()) . '\', ';
}
if (isset($this->respondent['validation'])) {
$query .= 'validation = \'' . prepareDatabaseString($this->getValidation()) . '\', ';
}
if (isset($this->respondent['movedout'])) {
$query .= 'movedout = \'' . prepareDatabaseString($this->getMovedOut()) . '\', ';
}
if (isset($this->respondent['hhorder'])) {
$query .= 'hhorder = \'' . prepareDatabaseString($this->getHhOrder()) . '\', ';
}
$query .= 'present = \'' . prepareDatabaseString($this->getPresent()) . '\', ';
$query .= 'selected = \'' . prepareDatabaseString($this->getSelected()) . '\', ';
if (dbConfig::defaultSeparateInterviewAddress()) {
// begin custom personal networks
$query .= 'original_firstname = AES_ENCRYPT(\'' . prepareDatabaseString($this->getOriginalFirstName()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'original_lastname = AES_ENCRYPT(\'' . prepareDatabaseString($this->getOriginalLastName()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'originalR = \'' . prepareDatabaseString($this->getOriginalR()) . '\', ';
$query .= 'callbackOtherR = \'' . prepareDatabaseString($this->getCallbackOtherR()) . '\', ';
$query .= 'interview_address1 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getInterviewAddress1()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'interview_address2 = AES_ENCRYPT(\'' . prepareDatabaseString($this->getInterviewAddress2()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'interview_zip = AES_ENCRYPT(\'' . prepareDatabaseString($this->getInterviewZip()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'interview_city = AES_ENCRYPT(\'' . prepareDatabaseString($this->getInterviewCity()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'interview_state = AES_ENCRYPT(\'' . prepareDatabaseString($this->getInterviewState()) . '\', \'' . Config::smsPersonalInfoKey() . '\'), ';
$query .= 'interview_mode = \'' . prepareDatabaseString($this->getInterviewMode()) . '\', ';
// end custom personal networks
}
$query .= 'status = ' . prepareDatabaseString($this->getStatus()) . ', ';
$query .= 'urid = ' . prepareDatabaseString($this->getUrid()) . ' ';
$query .= 'WHERE primkey = \'' . prepareDatabaseString($this->getPrimkey()) . '\'';
//echo '<br/><br/><br/>' . $query . '<br/>';
$db->executeQuery($query);
return $errorMessage;
}
// return $this->respondent['info_dec'];
}
function getContactPerson()
{
return '';
// return $this->respondent['contactperson_dec'];
}
function saveChanges()
{
global $db;
$errorMessage = array();
$query = 'UPDATE ' . Config::dbSurvey() . '_households SET ';
$query .= 'name = AES_ENCRYPT("' . prepareDatabaseString($this->getName()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'address1 = AES_ENCRYPT("' . prepareDatabaseString($this->getAddress1()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'address2 = AES_ENCRYPT("' . prepareDatabaseString($this->getAddress2()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'city = AES_ENCRYPT("' . prepareDatabaseString($this->getCity()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'puid = "' . prepareDatabaseString($this->getPuid()) . '", ';
$query .= 'hhhead = "' . prepareDatabaseString($this->getHhHead()) . '", ';
$query .= 'longitude = AES_ENCRYPT("' . prepareDatabaseString($this->getLongitude()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'latitude = AES_ENCRYPT("' . prepareDatabaseString($this->getLatitude()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'zip = AES_ENCRYPT("' . prepareDatabaseString($this->getZip()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'telephone1 = AES_ENCRYPT("' . prepareDatabaseString($this->getTelephone1()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
$query .= 'telephone2 = AES_ENCRYPT("' . prepareDatabaseString($this->getTelephone2()) . '", "' . Config::smsPersonalInfoKey() . '"), ';
