function displayComponentDescription($component_id_in)
{
global $tables;
$query = "SELECT description FROM " . $tables['components'] . " WHERE id=" . $component_id_in;
$result = mysqlGetSingleValue($query);
return $result;
}
function displayClassForm($name_in, $required_in = null)
{
if (!isset($required_in)) {
$required_in = 0;
createClass($name_in, 0, 0);
$query = "SELECT id FROM class WHERE name='" . $name_in . "'";
$_GET['edit_class'] = mysqlGetSingleValue($query);
}
?>
<form method="post" action='index.php'>
<input type='hidden' name='submitted' value='1' />
<?php
if (isset($required_in)) {
echo "<input type='hidden' name='next_page' value='6' />";
echo "<input type='hidden' name='id' value='" . $_GET['edit_class'] . "' />";
}
echo "Class Name:<input type='text' name='name' value='{$name_in}' /><br/>";
//echo "Required?<input type='checkbox' name='required' ".(($required_in == 1)?"checked":"")." /><br/>";
echo "<br/><br/>";
global $tables;
$database = connectToDatabase();
if ($database) {
$result_array = mysql_fetch_array(mysqlQuery("SELECT id,priority FROM " . $tables['classes'] . " WHERE name='" . $name_in . "'", $database));
$priority = $result_array['priority'];
$id = $result_array['id'];
$query = "SELECT id,name FROM " . $tables['classes'] . " WHERE priority<'" . $priority . "' ORDER BY priority";
$result = mysqlQuery($query, $database);
if (!mysql_error() && mysql_num_rows($result) > 0) {
$num_rows = mysql_num_rows($result);
echo "<span class='dependability'>Dependabilities</span><br/>";
for ($row = 0; $row < $num_rows; $row++) {
$result_array = mysql_fetch_array($result);
if (isset($required_in)) {
$query_2 = "SELECT id FROM " . $tables['dependabilities'] . " WHERE dependent_id=" . $id . " AND independent_id=" . $result_array['id'];
$result_2 = mysqlQuery($query_2, $database);
if (mysql_num_rows($result_2) > 0) {
echo $result_array['name'] . "<input type='checkbox' name='dependability[]' value='" . $result_array['id'] . "' checked /><br/>";
} else {
echo $result_array['name'] . "<input type='checkbox' name='dependability[]' value='" . $result_array['id'] . "' /><br/>";
}
} else {
echo $result_array['name'] . "<input type='checkbox' name='dependability[]' value='" . $result_array['id'] . "' /><br/>";
}
}
}
}
?>
<input type='submit' value='Submit' />
</form>
<?php
}
require_once 'utilities.php';
require_once 'header.php';
require_once 'login.php';
require_once 'customer_functions.php';
$_GET = array_map('mysql_real_escape_string', $_GET);
$_POST = array_map('mysql_real_escape_string', $_POST);
if (isLoggedIn()) {
global $tables;
if ($_POST['CS']) {
createNewOrderline($_POST['order_id']);
setup();
} else {
if ($_POST['submit'] && is_numeric($_POST['configuration_system_name'])) {
$database = connectToDatabase();
$query = "SELECT " . $tables['classes'] . ".id FROM " . $tables['components'] . " JOIN ( " . $tables['classes'] . ", " . $tables['families'] . " ) ON ( " . $tables['components'] . ".family_id=" . $tables['families'] . ".id AND " . $tables['families'] . ".class_id=" . $tables['classes'] . ".id ) WHERE " . $tables['components'] . ".id=" . $_POST['configuration_system_name'];
$class_id = mysqlGetSingleValue($query, $database);
$query = "SELECT " . $tables['selectedcomponents'] . ".id FROM " . $tables['selectedcomponents'] . " JOIN ( " . $tables['orderlines'] . ", " . $tables['components'] . ", " . $tables['families'] . ", " . $tables['classes'] . " ) ON ( " . $tables['selectedcomponents'] . ".orderline_id=" . $tables['orderlines'] . ".id AND " . $tables['components'] . ".id=" . $tables['selectedcomponents'] . ".component_id AND " . $tables['families'] . ".id=" . $tables['components'] . ".family_id AND " . $tables['classes'] . ".id=" . $tables['families'] . ".class_id ) WHERE " . $tables['orderlines'] . ".id=" . $_POST['orderline_id'] . " AND " . $tables['classes'] . ".id=" . $class_id;
$result = mysqlQuery($query, $database);
if (mysql_num_rows($result) > 0) {
$result_array = mysql_fetch_array($result);
$query = "UPDATE " . $tables['selectedcomponents'] . " SET component_id=" . $_POST['configuration_system_name'] . " WHERE " . $tables['selectedcomponents'] . ".id=" . $result_array[0] . " LIMIT 1";
} else {
$query = "INSERT INTO " . $tables['selectedcomponents'] . " VALUES ( NULL, " . $_POST['configuration_system_name'] . ", " . $_POST['orderline_id'] . ", 0 )";
}
mysqlQuery($query, $database);
updateFlags($class_id, $database);
if ($_GET['finished']) {
redirect($_GET['finished']);
} else {
if ($_POST['finished']) {
redirect($_POST['finished']);
function updateFlags($class_id_in, $database)
{
setIncompatibleFlag($_POST['orderline_id'], $_POST['configuration_system_name'], 0);
$database = connectToDatabase();
$query = "SELECT component.id\r\n FROM orderline\r\n JOIN ( selectedcomponent, component, family, class )\r\n ON ( selectedcomponent.component_id=component.id\r\n AND orderline.id=selectedcomponent.orderline_id\r\n AND component.family_id=family.id\r\n AND family.class_id=class.id)\r\n WHERE orderline.id=" . $_POST['orderline_id'] . "\r\n AND class.id\r\n IN (\r\n SELECT dependent_id\r\n FROM dependability\r\n WHERE independent_id=" . $class_id_in . ") ";
//AND selectedcomponent.flag=0
$result = mysqlQuery($query, $database);
$rows = mysql_num_rows($result);
//debug( "THIS COMPONENT", $_POST['configuration_system_name'] );
if (mysql_num_rows($result) >= 1) {
while ($result_array = mysql_fetch_array($result)) {
$query_2 = "SELECT component_id FROM familycompatibility WHERE family_id=(SELECT family_id FROM component WHERE id=" . $result_array[0] . " LIMIT 1)";
//debug( "query_2", $query_2 );
$result_2 = mysqlQuery($query_2, $database);
$families = array();
while ($result_array_2 = mysql_fetch_array($result_2)) {
$families[] = $result_array_2[0];
}
// debugArray( "families", $families );
$component_id = $result_array[0];
//debug( "component_id", $component_id );
if (mysql_num_rows($result_2) < 1) {
setIncompatibleFlag($_POST['orderline_id'], $component_id, 1);
//debug( "flag1", $component_id );
continue;
}
//$query_3 = "SELECT family_id FROM component WHERE id=".$component_id;
//$family_id = mysqlGetSingleValue( $query_3, $database );
if (!in_array($_POST['configuration_system_name'], $families)) {
setIncompatibleFlag($_POST['orderline_id'], $component_id, 1);
//debug( "flag2", $component_id );
continue;
}
$query_4 = "SELECT id FROM componentnoncompatibility WHERE component_id=" . $component_id . " AND noncompatible_component_id=" . $_POST['configuration_system_name'];
$result_4 = mysqlQuery($query_4, $database);
if (mysql_num_rows($result_4) > 0) {
setIncompatibleFlag($_POST['orderline_id'], $component_id, 1);
//debug( "flag3", $component_id );
continue;
}
//setIncompatibleFlag( $_POST['orderline_id'], $component_id, 0 );
//debug( "unflag", $component_id );
$query_99 = "SELECT component.id\r\n FROM orderline\r\n JOIN ( selectedcomponent, component, family, class )\r\n ON ( selectedcomponent.component_id=component.id\r\n AND orderline.id=selectedcomponent.orderline_id\r\n AND component.family_id=family.id\r\n AND family.class_id=class.id)\r\n WHERE orderline.id=" . $_POST['orderline_id'] . "\r\n AND class.id\r\n IN (\r\n SELECT independent_id\r\n FROM dependability\r\n WHERE dependent_id=(SELECT class_id FROM family WHERE id=(SELECT family_id FROM component WHERE id=" . $component_id . ")))";
//debug( "query_99", $query_99 );
$result_99 = mysqlQuery($query_99, $database);
if (mysql_num_rows($result_99) >= 1) {
$good = 1;
while ($result_array_99 = mysql_fetch_array($result_99)) {
$query_21 = "SELECT family_id FROM familycompatibility WHERE component_id=" . $result_array_99[0];
//debug( "query_21", $query_21 );
$result_21 = mysqlQuery($query_21, $database);
$families = array();
while ($result_array_21 = mysql_fetch_array($result_21)) {
$families[] = $result_array_21[0];
}
$component_id1 = $result_array_99[0];
//debug( "component_id", $component_id1 );
if (mysql_num_rows($result_21) < 1) {
//debug( "ungood1" );
$good = 0;
continue;
}
//$query_3 = "SELECT family_id FROM component WHERE id=".$component_id;
//$family_id = mysqlGetSingleValue( $query_3, $database );
$query_98 = "SELECT family_id FROM component WHERE id=" . $component_id;
$family = mysqlGetSingleValue($query_98, $database);
//debugArray( "families", $families );
//debug( "family", $family );
if (!in_array($family, $families)) {
//debug( "ungood2" );
$good = 0;
continue;
}
$query_41 = "SELECT id FROM componentnoncompatibility WHERE component_id=" . $component_id1 . " AND noncompatible_component_id=" . $component_id;
$result_41 = mysqlQuery($query_41, $database);
if (mysql_num_rows($result_41) > 0) {
//debug( "ungood3" );
//setIncompatibleFlag( $_POST['orderline_id'], $component_id, 1 );
$good = 0;
continue;
}
}
//unflag if all while loops are successful
if ($good == 1) {
setIncompatibleFlag($_POST['orderline_id'], $component_id, 0);
//debug( "unflag99", $component_id );
} else {
setIncompatibleFlag($_POST['orderline_id'], $component_id, 1);
//debug( "flag99", $component_id );
}
}
}
}
}
