<?php
include '../../../config.php';
include $FANNIE_ROOT . 'classlib2.0/FannieAPI.php';
if (!class_exists("SQLManager")) {
require_once $FANNIE_ROOT . "src/SQLManager.php";
}
include '../../db.php';
if (isset($_GET['excel'])) {
header('Content-Type: application/ms-excel');
header('Content-Disposition: attachment; filename="inactivationsStock.xls"');
$_SERVER['REQUEST_URI'] = $_SERVER['PHP_SELF'];
}
$cached_output = \COREPOS\Fannie\API\data\DataCache::getFile("monthly");
if ($cached_output) {
echo $cached_output;
return;
}
ob_start();
$query = "select m.card_no,CONCAT(c.FirstName,' ',c.LastName),m.start_date,\n DATE_ADD(m.start_date,INTERVAL 2 YEAR) as endDate,\n s.stockPurchase,s.tdate,n.payments\n from memDates as m left join\n custdata as c on c.CardNo=m.card_no and c.personNum=1\n left join is4c_trans.stockpurchases as s on m.card_no=s.card_no\n left join is4c_trans.equity_live_balance as n on m.card_no=n.memnum\n where " . $sql->monthdiff($sql->now(), 'DATE_ADD(m.start_date,INTERVAL 2 YEAR)') . " = -1\n and c.Type='PC' and n.payments < 100\n order by m.card_no,s.tdate";
echo "<table border=1 cellpadding=0 cellspacing=0>\n";
$headers = array('Mem Num', 'Name', 'Opening Date', 'Ending Date', 'First Buy Ammount', 'Last Buy Date', 'Total Equity');
echo "<tr>";
foreach ($headers as $h) {
echo "<th width=120><font size=2>{$h}</font></th>";
}
echo "</tr>";
function printLine($lastrow, $b)
{
$backgrounds = array('#ffffcc', '#ffffff');
echo "<tr>";
$monthMinus = 1;
if (isset($_GET["monthMinus"])) {
$monthMinus = $_GET["monthMinus"];
}
$stamp = strtotime("-{$monthMinus} month");
echo strtoupper(date("F", $stamp));
echo " ";
echo date("Y", $stamp);
$dlog = "is4c_trans.dlog_90_view";
$dlog = "trans_archive.dlogBig";
echo " NABS</b><br />";
if (!isset($_GET["excel"])) {
echo "<a href=index.php?excel=xls&monthMinus={$monthMinus}>Save to Excel</a>";
}
echo "<p />";
$output = \COREPOS\Fannie\API\data\DataCache::getFile('monthly');
if (!$output) {
ob_start();
$start = date("Y-m-01", $stamp);
$end = date("Y-m-t", $stamp);
$span = array("{$start} 00:00:00", "{$end} 23:59:59");
$accounts = array();
$accountQ = $dbc->prepare_statement("SELECT CardNo from custdata WHERE memType=4 ORDER BY CardNo");
$accountR = $dbc->exec_statement($accountQ);
while ($accountW = $dbc->fetch_row($accountR)) {
$accounts[] = $accountW['CardNo'];
}
$accountStr = "(";
$args = array();
foreach ($accounts as $a) {
$accountStr .= "?,";
function get_startDate_endDate_view()
{
global $FANNIE_URL, $FANNIE_ROOT;
$records = \COREPOS\Fannie\API\data\DataCache::getFile('daily');
if ($records !== False) {
$records = unserialize($records);
}
if (!is_array($records) || FormLib::get('no-cache') == '1') {
$records = $this->get_data();
\COREPOS\Fannie\API\data\DataCache::putFile('daily', serialize($records));
}
$ret = '';
$debit = $credit = 0.0;
if (FormLib::get_form_value('excel', '') === '') {
$ret .= sprintf('<a href="OverShortMAS.php?startDate=%s&endDate=%s&excel=yes">Download</a>', $this->startDate, $this->endDate);
$ret .= '<table class="table table-bordered small">';
foreach ($records as $r) {
if (preg_match('/\\(\\d+-\\d+-\\d+ \\d+-\\d+-\\d+\\)/', $r[5])) {
$tmp = explode(' ', $r[5]);
$date = trim($tmp[count($tmp) - 2], '()');
$trans = trim($tmp[count($tmp) - 1], '()');
$r[5] = sprintf('<a href="%sadmin/LookupReceipt/RenderReceiptPage.php?receipt=%s&date=%s">%s</a>', $FANNIE_URL, $trans, $date, $r[5]);
}
$ret .= sprintf('<tr><td>%d</td><td>%s</td><td>%s</td>
<td>%.2f</td><td>%.2f</td><td>%s</td></tr>', $r[0], $r[1], $r[2], $r[3], $r[4], $r[5]);
$debit += $r[3];
$credit += $r[4];
}
$ret .= sprintf('<tr><td colspan="3">Sum</td><td>%.2f</td><td>%.2f</td><td> </td></tr>', $debit, $credit);
$ret .= '</table>';
} else {
foreach ($records as $row) {
$line = '';
foreach ($row as $val) {
$line .= strstr($val, ',') ? '"' . $val . '"' : $val;
$line .= ',';
}
$line = substr($line, 0, strlen($line) - 1) . "\r\n";
$ret .= $line;
}
}
return $ret;
}