示例#1
0
<?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;
示例#2
0
<?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;
示例#3
0
<?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
示例#4
0
<?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>";
示例#5
0
<?php

include "../../convenienceDB.php";
$transactionNo = $_GET['transactionNo'];
$ro = new convenienceDB();
$ro->showSales($transactionNo);
示例#6
0
<?php

include "../../convenienceDB.php";
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$ro = new convenienceDB();
$date = $year . "-" . $month . "-" . $day;
$ro->showAddedInventory($date);
示例#7
0
<?php

include "../../convenienceDB.php";
$username = $_POST['username'];
$ro = new convenienceDB();
$ro->getInventoryList($username);
示例#8
0
文件: qty.php 项目: rickyx12/protacio
<?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&nbsp;</td>";
echo "<td>";
$ro->coconutTextBox_short("qty", "1");
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
示例#9
0
<?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;
}
示例#10
0
<?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}");
示例#11
0
<?php

include "../../convenienceDB.php";
$ro = new convenienceDB();
$ro->getInventoryList_viewOnly();
示例#12
0
<?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);
示例#14
0
<?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>";
示例#15
0
<?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);
示例#16
0
<?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;
示例#17
0
<?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&nbsp;</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 "&nbsp;<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 "&nbsp;<input type=text name='year' class='shortField' value='" . date("Y") . "'>";
echo "</td>";
echo "</tr>";
示例#18
0
<?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);
示例#19
0
<?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");
}