?>
</span><br>
<label>Vintage:</label><span id="displayVintage"><?php
echo $wine->getVintage();
?>
</span><br>
<label>Regular Cost:</label><span id="displayCost"><?php
echo $wine->getCost();
?>
</span><br>
<label>Regular Selling Price:</label><span id="displaySellPrice"><?php
echo $wine->getSellPrice();
?>
</span><br>
<label>Current Inventory:</label><span id="currentInventory"><?php
echo $wine->getCurrentInventory();
?>
</span><br>
<span class="expand-click" onClick="$('#inventory-detail').css('display','block');">Click for Location Details</span><br>
<div id="inventory-detail" style="display:none;">
<?php
$details = $wine->getDetailInventory();
foreach ($details as $loc => $qty) {
echo $loc . ': ' . $qty . '<br>';
}
?>
</div>
<input class="action" type="button" value="Edit" onClick="$('#show').css('display','none');$('#edit').css('display','block');"> <input class="action" type="button" value="Inventory" onClick="window.location.assign('/showinventory/<?php
echo $_GET['upc'];
?>
')">
function exportCSV($arr, $dbh)
{
if (isset($arr['reportType']) && $arr['reportType'] == 'summaryByUPC') {
$wine = new Wine($dbh);
$wine->fetchWineByUPC($arr['upc']);
if (isset($arr['toDate']) && $arr['toDate'] != null) {
$to = $arr['toDate'];
} else {
$to = null;
}
if (isset($arr['fromDate']) && $arr['fromDate'] != null) {
$from = $arr['fromDate'];
} else {
$from = null;
}
$json = $wine->getInventorySummary($from, $to);
//Generate HTML and echo it out;
$data = json_decode($json, true);
if (!isset($data[0])) {
die('No data was found matching your criteria.');
}
$fp = fopen($_SERVER['DOCUMENT_ROOT'] . '/tmp/summaryByUPC.csv', 'w');
$header = 'UPC,Name,Cost,SellingPrice,Quantity,DateTime,Location';
fwrite($fp, $header);
fwrite($fp, PHP_EOL);
foreach ($data as $row) {
fputcsv($fp, $row);
}
fclose($fp);
header('Location: /tmp/summaryByUPC.csv');
} else {
if (isset($arr['reportType']) && $arr['reportType'] == 'completeInventory') {
$wine = new Wine($dbh);
if (isset($arr['toDate']) && $arr['toDate'] != null) {
$to = $arr['toDate'];
} else {
$to = null;
}
$args = array('date' => $to);
$wines = $wine->fetchAllWines();
$data = json_decode($wines, true);
$fp = fopen($_SERVER['DOCUMENT_ROOT'] . '/tmp/completeInventory.csv', 'w');
$header = 'UPC,Name,Qty,Cost/Bottle,Total Cost,Selling Price,Cost/Selling Price';
fwrite($fp, $header);
fwrite($fp, PHP_EOL);
foreach ($data as $row) {
$curWine = new Wine($dbh);
$curWine->fetchWineByUPC($row['upc']);
$args = array('date' => $to);
$inv = $curWine->getCurrentInventory($args);
//cur is json summary of inventory
$row = '' . $curWine->getUPC() . ',' . $curWine->getName() . ',' . $curWine->getCurrentInventory($args) . ',' . number_format($curWine->getCost(), 2, '.', '') . ',' . number_format($curWine->getCurrentInventory($args) * $curWine->getCost(), 2, '.', '') . ',' . number_format($curWine->getSellPrice(), 2, '.', '') . ',' . $curWine->getCost() / $curWine->getSellPrice();
fwrite($fp, $row);
fwrite($fp, PHP_EOL);
}
fclose($fp);
header('Location: /tmp/completeInventory.csv');
} else {
die('Invalid Report Type');
}
}
}
