function reassignHousehold(Household $household, $oldurid, $newurid)
{
$oldUser = new User($oldurid);
//add to new iwer first.. then remove from old.
if ($newurid != -1) {
//back to agency
//insert data into new iwer
$data = $this->exportTables(array('data', 'datarecords', 'states', 'times', 'remarks', 'contacts'), '', 'primkey = "' . $household->getPrimkey() . '"');
$this->addSQLToUser($data, $newurid);
//insert data into new iwer (for respodnents)
foreach ($household->getSelectedRespondentsWithFinFamR() as $respondent) {
$data = $this->exportTables(array('data', 'datarecords', 'states', 'times', 'remarks', 'contacts'), '', 'primkey = "' . $respondent->getPrimkey() . '"');
$this->addSQLToUser($data, $newurid);
}
//get data for household and respondents and add to new urid
$data = $this->exportTables(array('households'), '', 'primkey = "' . $household->getPrimkey() . '"');
$data .= "\n";
$data .= $this->exportTables(array('respondents'), '', 'hhid = "' . $household->getPrimkey() . '"');
$this->addSQLToUser($data, $newurid);
}
if ($oldUser->getUserType() == USER_INTERVIEWER) {
//not if this isn't an interviewer
//remove data from old interviewer
$data = $this->removeFromTables(array('data', 'datarecords', 'states', 'times', 'remarks', 'contacts'), '', 'primkey = "' . $household->getPrimkey() . '"');
$this->addSQLToUser($data, $oldurid);
//remove data from old interviewer (for respondents)
foreach ($household->getSelectedRespondentsWithFinFamR() as $respondent) {
$data = $this->exportTables(array('data', 'datarecords', 'states', 'times', 'remarks', 'contacts'), '', 'primkey = "' . $respondent->getPrimkey() . '"');
$this->addSQLToUser($data, $oldurid);
}
//now remove from oldurid
$data = $this->removeFromTables(array('households'), '', 'primkey = "' . $household->getPrimkey() . '"');
$data .= "\n";
$data .= $this->removeFromTables(array('respondents'), '', 'hhid = "' . $household->getPrimkey() . '"');
$this->addSQLToUser($data, $oldurid);
}
}
function showAddRemark($primkey, $type = 1)
{
if ($type == 1) {
$respondent = new Respondent($primkey);
} else {
$respondent = new Household($primkey);
}
if (loadvar('remark') != '') {
$remark = new Remarks();
$query = $remark->addRemark($respondent->getPrimkey(), loadvar('remark'), $_SESSION['URID']);
$communication = new Communication();
$communication->addSQLToUser($query, $respondent->getUrid(), true);
}
$displaySupervisor = new DisplaySupervisor();
return $displaySupervisor->showRemarks($respondent);
}
function showAddRemark($primkey, $type = 1)
{
if ($type == 1) {
$respondent = new Respondent($primkey);
} else {
$respondent = new Household($primkey);
}
if (loadvar('remark') != '') {
$remark = new Remarks();
$remark->addRemark($respondent->getPrimkey(), loadvar('remark'), $_SESSION['URID']);
}
$displayInterviewer = new DisplayInterviewer();
return $displayInterviewer->showRemarks($respondent);
}
