public function showEditForm($memNum, $country = "US")
{
global $FANNIE_URL, $FANNIE_TRANS_DB;
$dbc = $this->db();
$trans = $FANNIE_TRANS_DB . $dbc->sep();
$infoQ = $dbc->prepare_statement("SELECT payments\n FROM {$trans}equity_live_balance\n WHERE memnum=?");
$infoR = $dbc->exec_statement($infoQ, array($memNum));
$equity = 0;
if ($dbc->num_rows($infoR) > 0) {
$w = $dbc->fetch_row($infoR);
$equity = $w['payments'];
}
$plan = new EquityPaymentPlanAccountsModel($dbc);
$plan->cardNo($memNum);
foreach ($plan->find() as $p) {
$plan = $p;
break;
}
$allplans = new EquityPaymentPlansModel($dbc);
$ret = "<div class=\"panel panel-default\">\n <div class=\"panel-heading\">Equity</div>\n <div class=\"panel-body\">";
$ret .= '<div class="form-group">';
$ret .= '<span class="label primaryBackground">Stock Purchased</span> ';
$ret .= sprintf('%.2f', $equity);
$ret .= " <a href=\"{$FANNIE_URL}reports/Equity/index.php?memNum={$memNum}\">History</a>";
$ret .= '</div>';
$ret .= '<div class="form-group form-inline">';
$ret .= '<span class="label primaryBackground">Payment Plan</span> ';
$ret .= '<select name="payment-plan" class="form-control input-sm">
<option value="0">None</option>';
$ret .= $allplans->toOptions($plan->equityPaymentPlanID());
$ret .= '</select>
</div>';
$ret .= '<div class="form-group">';
$ret .= '<span class="label primaryBackground">Last Payment</span> ';
$ret .= sprintf('%s $%.2f', $plan->lastPaymentDate(), $plan->lastPaymentAmount());
$ret .= '</div>';
$ret .= '<div class="form-group">';
$ret .= '<span class="label primaryBackground">Next Payment</span> ';
$ret .= sprintf('%s $%.2f', $plan->nextPaymentDate(), $plan->nextPaymentAmount());
$ret .= '</div>';
$ret .= '<div class="form-group">';
$ret .= "<a href=\"{$FANNIE_URL}mem/correction_pages/MemEquityTransferTool.php?memIN={$memNum}\">Transfer Equity</a>";
$ret .= ' | ';
$ret .= "<a href=\"{$FANNIE_URL}mem/correction_pages/MemArEquitySwapTool.php?memIN={$memNum}\">Convert Equity</a>";
$ret .= '</div>';
$ret .= "</div>";
$ret .= "</div>";
return $ret;
}
