function draw_buy_table($pf_id, $pf_working_date, $pf_exch, $pf_nam)
{
global $pdo;
print '<form action="' . $_SERVER['REQUEST_URI'] . '" method="post" name="cart" id="cart">';
print '<table border="1" cellpadding="5" cellspacing="0" align="center">';
print '<tr><td>Symb</td><td>Name</td><td>Comment</td><td>Date</td><td>Volume</td><td>Close</td><td>Value</td>';
if (isset($_SESSION['chart'])) {
print '<td>Chart</td></tr>';
if (isset($_SESSION['chart_period'])) {
$chart_period = $_SESSION['chart_period'];
} else {
$chart_period = 180;
}
}
print '</tr>';
$query = "select * from cart where date <= '{$pf_working_date}' and pfid = '{$pf_id}' order by symb;";
foreach ($pdo->query($query) as $row) {
$symb = $row['symb'];
$date = $row['date'];
$symb_name = get_symb_name($symb, $pf_exch);
$close = get_stock_close($symb, $pf_working_date, $pf_exch);
$value = round($close * $row['volume'], 2);
print "<tr><td><input type=\"checkbox\" name=\"mark[]\" value=\"{$symb}\">";
print "<a href=\"/inspector.php?symb={$symb}\" target=\"_blank\">{$symb}</a></td>\n";
print "<td>{$symb_name}</td>\n";
print "<td>\n";
$warnings = get_warnings($symb, $pf_exch, $pf_working_date, $row['volume']);
print "{$warnings}\n";
print "<textarea wrap=\"soft\" rows=\"1\" cols=\"50\" name=\"comment_{$symb}\">" . $row['comment'] . '</textarea></td>';
print "<td>{$date}<input type=\"hidden\" name=\"date_{$symb}\" value=\"{$date}\"></td>\n";
print "<td><textarea wrap=\"soft\" rows=\"1\" cols=\"10\" name=\"volume_{$symb}\">" . $row['volume'] . '</textarea></td>';
print "<td>{$close}</td>\n";
print "<td>{$value}</td>\n";
if (isset($_SESSION['chart'])) {
print "<td><img SRC=\"/cgi-bin/chartstock.php?TickerSymbol={$symb}&TimeRange={$chart_period}&working_date={$pf_working_date}&exch={$pf_exch}&ref_date={$date}&ChartSize=S&Volume=1&VGrid=1&HGrid=1&LogScale=0&ChartType=OHLC&Band=None&avgType1=SMA&movAvg1=10&avgType2=SMA&movAvg2=25&Indicator1=RSI&Indicator2=MACD&Indicator3=WilliamR&Indicator4=TRIX&Button1=Update%20Chart\" ALIGN=\"bottom\" BORDER=\"0\"></td>";
}
print "</tr>\n";
}
if (isset($_SESSION['chart'])) {
print "<tr><td><table><tr><td><input type=\"checkbox\" name=\"chart\" value=\"chart\" checked>Draw Charts\n</td></tr><td> " . chart_select() . "</td></tr></table></td>\n";
} else {
print "<tr><td><table><tr><td><input type=\"checkbox\" name=\"chart\" value=\"chart\">Draw Charts\n</td></tr><td> " . chart_select() . "</td></tr></table></td>\n";
}
print '<td colspan="10"><input name="recalc" value="Update" type="submit"/></td></tr>';
print '<tr><td colspan="10"><input name="delete" value="Delete" type="submit"/></td></tr>';
print '<tr><td colspan="10"><input name="watch" value="Move to Watch list" type="submit"/></td></tr>';
print '<tr><td colspan="10"><input name="buy" value="Buy" type="submit"/></td></tr>';
print '</table>';
print '</form>';
}
function draw_performance_table($portfolio)
{
global $pdo;
$pf_id = $portfolio->getID();
$pf_name = $portfolio->getName();
$pf_opening_balance = $portfolio->getOpeningBalance();
$pf_opening_date = $portfolio->getStartDate();
$pf_days_traded = $portfolio->countDaysTraded();
$pf_exchange_name = $portfolio->getExch()->getName();
$pf_exch = $portfolio->getExch()->getID();
$pf_working_date = $portfolio->getWorkingDate();
print '<form action="' . $_SERVER['REQUEST_URI'] . '" method="post" name="cart" id="cart">';
print '<table border="1" cellpadding="5" cellspacing="0" align="center">';
print '<tr><td>Symb</td><td>Name</td><td>Comment</td><td>Date of Purchase</td><td>Volume</td><td>Buy Price</td><td>close</td><td>gain</td><td>Value</td>';
if (isset($_SESSION['chart'])) {
print '<td>Chart</td></tr>';
if (isset($_SESSION['chart_period'])) {
$chart_period = $_SESSION['chart_period'];
} else {
$chart_period = 180;
}
}
print '</tr>';
$query = "select * from trades where pfid = '{$pf_id}' order by date, symb;";
foreach ($pdo->query($query) as $row) {
$symb = $row['symb'];
$hid = $row['hid'];
$symb_name = get_symb_name($symb, $pf_exch);
$price = $row['price'];
$close = get_stock_close($symb, $pf_working_date, $pf_exch);
$price_diff_pc = round(($close - $price) / $price, 2) * 100;
$volume = $row['volume'];
$value = sprintf("%.2f", round($close * $volume, 2));
$buy_date = $row['date'];
$comment = $row['comment'];
if ($price_diff_pc == 0) {
$colour = 'black';
} elseif ($price_diff_pc > 0) {
if ($volume > 0) {
$colour = 'green';
} else {
$colour = 'red';
$price_diff_pc = 0 - $price_diff_pc;
}
} else {
if ($volume > 0) {
$colour = 'red';
} else {
$colour = 'green';
$price_diff_pc = 0 - $price_diff_pc;
}
}
print "<tr><td><a href=\"/inspector.php?symb={$symb}\" target=\"_blank\">{$symb}</a></td>\n";
print "<td><font color=\"{$colour}\">{$symb_name}</font></td>\n";
print "<td><textarea wrap=\"soft\" rows=\"1\" cols=\"50\" name=\"comment_{$hid}\">{$comment}</textarea></td>";
print "<td>{$buy_date}<input type=\"hidden\" name=\"date_{$symb}\" value=\"{$buy_date}\"></td>\n";
print "<td align=\"right\">" . $row['volume'] . '</td>';
print "<td align=\"right\">{$price}</td>\n";
print "<td align=\"right\">{$close}</td>\n";
print "<td align=\"right\">{$price_diff_pc} %</td>\n";
print "<td align=\"right\">{$value}</td>\n";
if (isset($_SESSION['chart'])) {
print "<td><img SRC=\"/cgi-bin/chartstock.php?TickerSymbol={$symb}&TimeRange={$chart_period}&working_date={$pf_working_date}&exch={$pf_exch}&price={$price}&ref_date={$buy_date}&ChartSize=S&Volume=1&VGrid=1&HGrid=1&LogScale=0&ChartType=OHLC&Band=None&avgType1=SMA&movAvg1=10&avgType2=SMA&movAvg2=25&Indicator1=RSI&Indicator2=MACD&Indicator3=WilliamR&Indicator4=TRIX&Button1=Update%20Chart\" ALIGN=\"bottom\" BORDER=\"0\"></td>";
}
print "</tr>\n";
}
$pf_cash_in_hand = $portfolio->getCashInHand();
$pf_holdings = $portfolio->getHoldings();
$pf_total = sprintf("%.2f", $pf_cash_in_hand + $pf_holdings);
if (isset($_SESSION['chart'])) {
print "<tr><td><table><tr><td><input type=\"checkbox\" name=\"chart\" value=\"chart\" checked>Draw Charts\n</td></tr><td> " . chart_select() . "</td></tr></table></td>\n";
} else {
print "<tr><td><table><tr><td><input type=\"checkbox\" name=\"chart\" value=\"chart\">Draw Charts\n</td></tr><td> " . chart_select() . "</td></tr></table></td>\n";
}
print '<td colspan="10"><input name="update" value="Update" type="submit"/></td></tr>';
print '</table>';
print '<table border="1" cellpadding="5" cellspacing="0" align="center">';
print "<tr><td align=\"left\">Portfolio:</td><td>{$pf_name}</td></tr>\n";
print "<tr><td align=\"left\">Exchange:</td><td>{$pf_exchange_name}</td></tr>\n";
print "<tr><td align=\"left\">Opening date:</td><td align=\"right\">{$pf_opening_date}</td>\n";
print "<tr><td align=\"left\">Days Traded:</td><td align=\"right\">{$pf_days_traded}</td>\n";
print "<tr><td align=\"left\">Opening Balance:</td><td align=\"right\">{$pf_opening_balance}</td>\n";
print "<tr><td align=\"left\">Cash In Hand:</td><td align=\"right\">{$pf_cash_in_hand}</td>\n";
print "<tr><td align=\"left\">Holdings:</td><td align=\"right\">{$pf_holdings}</td>\n";
print "<tr><td align=\"left\">Total:</td><td align=\"right\">{$pf_total}</td>\n";
print "<tr><td colspan=\"10\"><img src=\"/cgi-bin/portfolio_chart.php?pfid={$pf_id}\"/></td></tr>";
print '</form>';
}
