public function echoClientEdit()
{
$id;
$contact_id;
$sex = 'm';
$first_name;
$middle_name;
$last_name;
$suffix;
$ssn;
$dob;
$aka;
$dba;
$success = true;
if ($this->page_type == 'edit') {
$sth = $this->db->prepare("SELECT `contact_id`,`contacts`.`name` AS 'last_name'," . "`first_name`,`middle_name`,`suffix`,`sex`,`ssn`,`aka`,`dba`, " . "DATE_FORMAT(`dob`, '%c-%e-%Y') AS 'dob_format' " . 'FROM `clients` ' . 'JOIN `contacts` ON `clients`.`contact_id`=`contacts`.`id` ' . 'WHERE `clients`.`id`=?');
$sth->execute(array($this->id));
if ($row = $sth->fetch()) {
$id = $this->id;
$contact_id = $row['contact_id'];
$first_name = $row['first_name'];
$middle_name = $row['middle_name'];
$last_name = $row['last_name'];
$suffix = $row['suffix'];
$sex = $row['sex'] ? $row['sex'] : 'none';
$ssn = $row['ssn'];
$dob = $row['dob_format'];
$aka = $row['aka'];
$dba = $row['dba'];
} else {
$success = false;
}
}
if ($success) {
$form = new Form('client');
$form->addHeading('Name');
$form->addSelect('', 'sex', array('m' => 'Male', 'f' => 'Female', 'none' => 'None'), $sex);
$form->addText('First name:', 'first_name', false, $first_name);
$form->addText('Middle:', 'middle_name', false, $middle_name);
$form->addText('Last (or biz name):', 'name', true, $last_name);
$form->addText('Suffix (Jr/Sr/etc):', 'suffix', false, $suffix);
$form->addHeading('Info');
$form->addDate('Date of birth:', 'dob', false, true, $dob);
$form->addText('SSN (no dashes):', 'ssn', false, $ssn, 'minlength="9" maxlength="9" digits="true"');
$form->addText('AKA:', 'aka', false, $aka);
$form->addText('DBA:', 'dba', false, $dba);
$form->addHidden('id', $id);
$form->addHidden('contact_id', $contact_id);
if ($this->admin && $this->page_type == 'edit') {
$form->addDelete();
}
$form->echoForm();
}
}
