$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;
}
}
} catch (Exception $e) {
// Anything that doesn't save, we're just going to ignore
// No sense bringing over bad data.
echo "Couldn't save followup\n";
echo $e->getMessage() . "\n";
print_r($history);
exit;
}
}
if ($row['completed_date']) {
$history = new History();
$history->setAction('close');
$history->setActionDate($row['completed_date']);
$history->setEnteredDate($row['completed_date']);
if ($lastPerson) {
$history->setEnteredByPerson($lastPerson);
$history->setActionPerson($lastPerson);
}
$ticket->updateHistory($history);
}
}
try {
if (!$ticket->getEnteredByPerson()) {
$ticket->setEnteredByPerson('unknown');
}
if (!$ticket->getAssignedPerson()) {
$ticket->setAssignedPerson('unknown');
}
$ticket->save();
} catch (Exception $e) {
echo $e->getMessage() . "\n";