>Misc</option>
<option value="Pop/Water" <?php
echo strtoupper($wine->getType()) == 'POP/WATER' ? 'selected' : '';
?>
>Pop/Water</option>
</select><br>
<label for="name">Name:</label><input type="text" style="width:400px" id="name" name="name" value="<?php
echo $wine->getName();
?>
"><br>
<label for="vintage">Vintage:</label><input type="number" id="vintage" name="vintage" value="<?php
echo $wine->getVintage();
?>
"><br>
<label for="cost">Regular Cost:</label><input type="number" id="cost" name="cost" value="<?php
echo $wine->getCost();
?>
"><br>
<label for="sell_price">Regular Sell Price:</label><input type="number" id="sell_price" name="sell_price" value="<?php
echo $wine->getSellPrice();
?>
"><br>
<input class="submit" type="button" value="Update Wine" onClick="processRequest()"> <input class="cancel" type="button" value="Reset" onclick="$('#form')[0].reset();"> <input class="cancel" type="button" value="Cancel Edit" onClick="$('#edit').css('display','none');$('#show').css('display','block');">
</form>
</div>
<div id="show" style="display:block">
<h2>Show: <span id="showUPC"><?php
echo $_GET['upc'];
?>
</span></h2>
<label>Type</label><span id="displayType"><?php
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');
}
}
}
