<?php include "../../convenienceDB.php"; $username = $_GET['username']; $ro = new convenienceDB(); $ro->coconutDesign(); ?> <link rel="stylesheet" type="text/css" href="http://<?php echo $ro->getMyUrl(); ?> /COCONUT/myCSS/coconutCSS.css" /> <style type="text/css"> a { text-decoration:none; color:red; } .button{ border: 1px solid #fff; color: #000; height: 28px; width: 381px; border-color:blue blue blue blue; font-size:15px; text-align:center; background-color:white; } .button1{ border: 1px solid #fff; color: #000;
<?php include "../../convenienceDB.php"; $username = $_GET['username']; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); /* $ro->getBatchNo(); $myFile = "/opt/lampp/htdocs/COCONUT/trackingNo/batchNo.dat"; $fh = fopen($myFile, 'r'); $batchNo = fread($fh, 100); fclose($fh); */ ?> <script type='text/javascript'> function showResult() { if (document.addCharge.description.value.length==0) { document.getElementById("livesearch").innerHTML=""; document.getElementById("livesearch").style.border="0px"; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else
<?php include "../../convenienceDB.php"; $username = $_GET['username']; $inventoryNo = $_GET['inventoryNo']; $description = $_GET['description']; $qty = $_GET['qty']; $unitcost = $_GET['unitcost']; $price = $_GET['price']; $ro = new convenienceDB(); $ro->coconutDesign(); echo "<Br><br><br>"; $ro->coconutFormStart("post", "editInventory1.php"); $ro->coconutHidden("inventoryNo", $inventoryNo); $ro->coconutHidden("username", $username); $ro->coconutBoxStart("500", "185"); echo "<br>"; echo "<Table border=0>"; echo "<tr>"; echo "<td>Description</td>"; echo "<td>"; $ro->coconutTextBox("description", $description); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>QTY</td>"; echo "<td>"; $ro->coconutTextBox_short("qty", $qty); echo "</td>"; echo "</tr>"; echo "<tr>";
<?php include "../../convenienceDB.php"; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); $ro->showSales($transactionNo);
<?php include "../../convenienceDB.php"; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $ro = new convenienceDB(); $date = $year . "-" . $month . "-" . $day; $ro->showAddedInventory($date);
<?php include "../../convenienceDB.php"; $username = $_POST['username']; $ro = new convenienceDB(); $ro->getInventoryList($username);
<?php include "../../convenienceDB.php"; $inventoryNo = $_GET['inventoryNo']; $transactionNo = $_GET['transactionNo']; $description = $_GET['description']; $price = $_GET['price']; $username = $_GET['username']; $ro = new convenienceDB(); $ro->coconutDesign(); echo "<br><br><br><br><bR>"; $ro->coconutFormStart("get", "addSales.php"); $ro->coconutHidden("inventoryNo", $inventoryNo); $ro->coconutHidden("transactionNo", $transactionNo); $ro->coconutHidden("description", $description); $ro->coconutHidden("price", $price); $ro->coconutHidden("username", $username); $ro->coconutBoxStart("400", "80"); echo "<br>"; echo "<table border=0>"; echo "<tr>"; echo "<td>QTY </td>"; echo "<td>"; $ro->coconutTextBox_short("qty", "1"); echo "</td>"; echo "</tr>"; echo "</table>"; echo "<br>"; $ro->coconutButton("Proceed"); $ro->coconutBoxStop(); $ro->coconutFormStop();
<?php include "../../convenienceDB.php"; $description = $_POST['description']; $qty = $_POST['qty']; $unitCost = $_POST['unitCost']; $price = $_POST['price']; $username = $_POST['username']; $ro = new convenienceDB(); ?> <link rel="stylesheet" type="text/css" href="http://<?php echo $ro->getMyUrl(); ?> /COCONUT/myCSS/coconutCSS.css" /> <style type="text/css"> a { text-decoration:none; color:red; } .button{ border: 1px solid #fff; color: #000; height: 28px; width: 381px; border-color:blue blue blue blue; font-size:15px; text-align:center; background-color:white; }
<?php include "../../convenienceDB.php"; $salesNo = $_GET['salesNo']; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); $salesQTY = $ro->selectNow("convenience_sales", "qty", "salesNo", $salesNo); $inventoryNo = $ro->selectNow("convenience_sales", "inventoryNo", "salesNo", $salesNo); $newQTY = $ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) + $salesQTY; $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $newQTY); $ro->deleteNow("convenience_sales", "salesNo", $salesNo); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/convenience/sales_output_update.php?transactionNo={$transactionNo}");
<?php include "../../convenienceDB.php"; $ro = new convenienceDB(); $ro->getInventoryList_viewOnly();
<?php include "../../convenienceDB.php"; $username = $_GET['username']; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); echo "\n<frameset cols='90%,150%' framespacing='0' border='1'>\n <frame src='http://" . $ro->getMyUrl() . "/COCONUT/convenience/searchInventory.php?transactionNo={$transactionNo}&username={$username}' scrolling=no frameborder=1 framespacing=1 name='selection' />\n <frame src='http://" . $ro->getMyUrl() . "/COCONUT/convenience/sales_output_update.php?transactionNo={$transactionNo}' name='selection1' />\n\n</frameset>\n\n\n";
<?php include "../../convenienceDB.php"; $description = $_GET['description']; $username = $_GET['username']; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); $ro->searchInventory($username, $description, $transactionNo);
<?php include "../../convenienceDB.php"; $username = $_POST['username']; $ro = new convenienceDB(); $ro->coconutDesign(); echo "<Br><br><br>"; $ro->coconutFormStart("post", "addInventory1.php"); $ro->coconutHidden("username", $username); $ro->coconutBoxStart("500", "185"); echo "<br>"; echo "<Table border=0>"; echo "<tr>"; echo "<td>Description</td>"; echo "<td>"; $ro->coconutTextBox("description", ""); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>QTY</td>"; echo "<td>"; $ro->coconutTextBox_short("qty", ""); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>Unitcost</td>"; echo "<td>"; $ro->coconutTextBox_short("unitCost", ""); echo "</td>"; echo "</tr>"; echo "<tr>";
<?php include "../../convenienceDB.php"; $fromMonth = $_POST['fromMonth']; $fromDay = $_POST['fromDay']; $fromYear = $_POST['fromYear']; $toMonth = $_POST['toMonth']; $toDay = $_POST['toDay']; $toYear = $_POST['toYear']; $ro = new convenienceDB(); $from = $fromYear . "-" . $fromMonth . "-" . $fromDay; $to = $toYear . "-" . $toMonth . "-" . $toDay; echo "<Center>"; $ro->showCollectionReport_new($from, $to);
<?php include "../../convenienceDB.php"; $ro = new convenienceDB(); ?> <link rel="stylesheet" type="text/css" href="http://<?php echo $ro->getMyUrl(); ?> /COCONUT/myCSS/coconutCSS.css" /> <?php echo "<form method='get' action='inventoryAddedRep1.php'>"; echo "<center><br><br><br><br><Br><br><div style='border:1px solid #000000; width:500px; height:80px; border-color:black black black black;'>"; echo "<br><table border=0 cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<td><font class='labelz'>Date </font></td>"; echo "<td>\n<select name='month' class='comboBoxShort'> \n<option value='" . date("m") . "'>" . date("M") . "</option>\n<option value='01'>Jan</option>\n<option value='02'>Feb</option>\n<option value='03'>Mar</option>\n<option value='04'>Apr</option>\n<option value='05'>May</option>\n<option value='06'>Jun</option>\n<option value='07'>Jul</option>\n<option value='08'>Aug</option>\n<option value='09'>Sep</option>\n<option value='10'>Oct</option>\n<option value='11'>Nov</option>\n<option value='12'>Dec</option>\n</select>"; echo " <select name='day' class='comboBoxShort'>"; echo "<option value='" . date("d") . "'>" . date("d") . "</option>"; for ($x = 1; $x < 32; $x++) { if ($x < 10) { echo "<option value='0{$x}'>0{$x}</option>"; } else { echo "<option value='{$x}'>{$x}</option>"; } } echo "</select>"; echo " <input type=text name='year' class='shortField' value='" . date("Y") . "'>"; echo "</td>"; echo "</tr>";
<?php include "../../convenienceDB.php"; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $fromTime_hour = $_GET['fromTime_hour']; $fromTime_minutes = $_GET['fromTime_minutes']; $fromTime_seconds = $_GET['fromTime_seconds']; $toTime_hour = $_GET['toTime_hour']; $toTime_minutes = $_GET['toTime_minutes']; $toTime_seconds = $_GET['toTime_seconds']; $ro = new convenienceDB(); $date = $year . "-" . $month . "-" . $day; $from = $fromTime_hour . ":" . $fromTime_minutes . ":" . $fromTime_seconds; $to = $toTime_hour . ":" . $toTime_minutes . ":" . $toTime_seconds; $ro->showCollectionReport($date, $from, $to);
<?php include "../../convenienceDB.php"; $inventoryNo = $_GET['inventoryNo']; $transactionNo = $_GET['transactionNo']; $description = $_GET['description']; $price = $_GET['price']; $qty = $_GET['qty']; $username = $_GET['username']; $ro = new convenienceDB(); $dateAdded = date("Y-m-d"); $timeAdded = date("H:i:s"); $total = $price * $qty; if ($ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) >= $qty) { $newQTY = $ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) - $qty; $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $newQTY); $ro->addSales($inventoryNo, $transactionNo, $description, $price, $qty, $total, $dateAdded, $timeAdded, $username); } else { $ro->getBack("Your Requested Quantity is Higher than the available quantity"); }