$person = new Person($row2['username']);
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
$ticket->updateHistory($history);
}
//
// responses go in issueHistory
//
$sql = "select r.date as date,r.notes as notes,\n u.username as username, c.name as contactMethod\n\t\tfrom responses r\n left join referrals rf on r.referral_id = rf.id\n left join users u on r.user_id = u.id\n left join contactMethods c on r.contactMethod_id = c.id\n\t\twhere rf.request_id=" . $row['id'];
$result2 = $pdo->query($sql);
while ($result2 && ($row2 = $result2->fetch(PDO::FETCH_ASSOC))) {
$history = new History();
$history->setAction('response');
$history->setEnteredDate($row2['date']);
$history->setActionDate($row2['date']);
$history->setNotes($row2['notes']);
$person = new Person($row2['username']);
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
$ticket->updateHistory($history);
}
try {
$ticket->save();
echo $ticket->getId() . " {$cnt}\n";
$cnt++;
} catch (Exception $e) {
echo $e->getMessage() . "\n";
print_r($e);
exit;
}
}
try {
$ticket->updateHistory($history);
} catch (Exception $e) {
// Any problems when creating the inspection, and we'll just not bother
// to create it. We're missing important information
echo "Couldn't save inspection\n";
echo $e->getMessage() . "\n";
print_r($history);
exit;
}
if ($row['followup_date']) {
$history = new History();
$history->setAction('followup');
$history->setActionDate($row['followup_date']);
$history->setEnteredDate($row['followup_date']);
$history->setNotes("{$row['action_taken']}\n{$row['next_action']}");
if ($lastPerson) {
try {
$history->setEnteredByPerson($lastPerson);
$history->setActionPerson($lastPerson);
} catch (Exception $e) {
echo "Could not set a person for the followup\n";
print_r($ticket);
print_r($lastPerson);
exit;
}
}
try {
$ticket->updateHistory($history);
} catch (Exception $e) {
// Anything that doesn't save, we're just going to ignore
