<?php
/*
$Rev: 704 $ | $LastChangedBy: brieb $
$LastChangedDate: 2010-01-01 23:10:02 -0700 (Fri, 01 Jan 2010) $
+-------------------------------------------------------------------------+
| Copyright (c) 2004 - 2010, Kreotek LLC |
| All rights reserved. |
+-------------------------------------------------------------------------+
| |
| Redistribution and use in source and binary forms, with or without |
| modification, are permitted provided that the following conditions are |
| met: |
| |
| - Redistributions of source code must retain the above copyright |
| notice, this list of conditions and the following disclaimer. |
| |
| - Redistributions in binary form must reproduce the above copyright |
| notice, this list of conditions and the following disclaimer in the |
| documentation and/or other materials provided with the distribution. |
| |
| - Neither the name of Kreotek LLC nor the names of its contributore may |
| be used to endorse or promote products derived from this software |
| without specific prior written permission. |
| |
| THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
| "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
| LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A |
| PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT |
| OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
| SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT |
| LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
| DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
| THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
| (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| |
+-------------------------------------------------------------------------+
*/
include("../../include/session.php");
include("../../include/fields.php");
$refquery = "
SELECT
`partname`,
`uuid`
FROM
`products`
WHERE
`id`='".((int) $_GET["id"])."'
";
$refquery=$db->query($refquery);
$refrecord=$db->fetchArray($refquery);
if(isset($_POST["command"])){
switch($_POST["command"]){
case"delete":
$deletestatement = "
DELETE FROM
prerequisites
WHERE
id=".((int) $_POST["deleteid"]);
$db->query($deletestatement);
$statusmessage = "Prerequisite removed.";
break;
case"add":
if($_POST["productid"]!=$refrecord["uuid"] && $_POST["productid"]!=""){
$insertstatement = "
INSERT INTO
prerequisites
(parentid,
childid)
VALUES
('".mysql_real_escape_string($refrecord["uuid"])."',
'".mysql_real_escape_string($_POST["productid"])."')";
$db->query($insertstatement);
$statusmessage = "Prerequisite added.";
} else {
$statusmessage = "Prerequisite not added.";
}//endif
break;
}//endswitch - comand
}//endif - command
$prerequstatement = "
SELECT DISTINCT
`prerequisites`.`id`,
`partnumber`,
`partname`,
`description`
FROM
`prerequisites` INNER JOIN `products` ON `prerequisites`.`childid`=`products`.`uuid`
WHERE
`prerequisites`.`parentid`='".$refrecord["uuid"]."'
";
$prereqresult = $db->query($prerequstatement);
$prereqresult? $numrows = $db->numRows($prereqresult): $numrows=0;
$pageTitle="Product Prerequisites: ".$refrecord["partname"];
$phpbms->cssIncludes[] = "pages/products.css";
$phpbms->jsIncludes[] = "modules/bms/javascript/prereq.js";
//Form Elements
//==============================================================
$theform = new phpbmsForm();
$theinput = new inputSmartSearch($db, "productid", "Pick Product", "", "product", false, 51, 255);
$theform->addField($theinput);
$theform->jsMerge();
//==============================================================
//End Form Elements
include("header.php");
?>
<?php $phpbms->showTabs("products entry","tab:9bfc7eea-5abb-f5d8-763f-f78fe499464d",$_GET["id"]);?><div class="bodyline">
<h1><span><?php echo $pageTitle ?></span></h1>
<form action="<?php echo htmlentities($_SERVER["REQUEST_URI"]) ?>" method="post" name="record">
<input id="deleteid" name="deleteid" type="hidden" value="0" />
<input id="command" name="command" type="hidden" value="" />
<div class="fauxP">
<table border="0" cellpadding="3" cellspacing="0" class="querytable">
<tr>
<th align="left" nowrap="nowrap" class="queryheader">Part Number</th>
<th align="left" nowrap="nowrap" class="queryheader">Name</th>
<th align="left" width="100%" class="queryheader">Description</th>
<th align="center" nowrap="nowrap" class="queryheader"> </th>
</tr>
<?php
$row = 1;
if($numrows){
while ($prereq=$db->fetchArray($prereqresult)){
$row = ($row == 1)? 2: 1;
?>
<tr class="qr<?php echo $row?>">
<td align="left" nowrap="nowrap"><?php echo $prereq["partnumber"] ?></td>
<td align="left" nowrap="nowrap"><?php echo $prereq["partname"] ?></td>
<td align="left" width="100%"><?php echo $prereq["description"]?$prereq["description"]:" " ?></td>
<td align="center">
<button type="submit" class="graphicButtons buttonMinus" onclick="return deleteLine(<?php echo $prereq["id"] ?>)"><span>-</span></button>
</td>
</tr>
<?php }//end while
?>
<tr class="queryfooter">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<?php
} else {?>
<tr class="norecords"><td colspan="4" align="center">No Prerequisites to Display</td></tr>
<?php
}//end if
?>
</table>
</div>
<fieldset>
<legend>add new prerequisite</legend>
<div class="preqAdd fauxP"><?php $theform->showField("productid")?></div>
<p id="addButtonP"><br />
<button type="submit" class="graphicButtons buttonPlus" onclick="return addLine()"><span>+</span></button>
</p>
</fieldset>
<fieldset>
<legend>notes</legend>
<p class="notes">
Prerequisites are products that must be purchased by the client
on a prior order before this product can be purchased.
</p>
<p class="notes">
For example, if you run a membership organization, a membership (product) might be required
before any other products (membership magazine, patches) can be bought.
</p>
</fieldset>
</form>
</div>
<?php include("footer.php");?>