$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']);
} else {
if (isOrderLineFull($_POST['orderline_id'])) {
if ($_GET['return_to_class']) {
$class_id = $_GET['return_to_class'];
setup();
} else {
orderComplete($_POST['orderline_id']);
}
} else {
setup();
}
}
}
} else {
setup();
}
}
}
addSpacing();
require_once 'footer.php';
if (mysql_num_rows($result) < 1) {
noItemsInCart();
}
while ($result_array = mysql_fetch_array($result)) {
$orderlines++;
displayOrderline($result_array[0], $orderlines);
if (!isOrderlineFull($result_array[0])) {
$incomplete++;
renderError("This item is not full!");
}
}
if (!$orderlines) {
noItemsInCart();
}
if (!$incomplete) {
orderComplete(0, $order, 1);
} else {
renderError("Please complete all incomplete items before checking out.");
}
echo "<br/><br/>";
}
}
function displayOrderline($orderline_id_in, $orderline_number_in)
{
//SELECT component.name,component.description,class.id,class.name
//FROM selectedcomponent
//JOIN ( component, family, class )
//ON ( selectedcomponent.component_id=component.id
//AND component.family_id=family.id
//AND family.class_id=class.id )
//WHERE orderline_id=3
function getCurrentOrderline($order_id_in)
{
if ($_GET['orderline_id']) {
return $_GET['orderline_id'];
}
global $tables;
$database = connectToDatabase();
$query = "SELECT id FROM " . $tables['orderlines'] . " WHERE order_id=" . $order_id_in;
$result = mysqlQuery($query, $database);
$rows = mysql_num_rows($result);
if ($rows <= 0) {
return createNewOrderline($order_id_in);
}
for ($row = 0; $row < $rows; $row++) {
$result_array = mysql_fetch_array($result);
$orderline_id = $result_array[0];
if (!isOrderlineFull($orderline_id)) {
return $orderline_id;
}
}
orderComplete($orderline_id, $order_id, 0, 1);
return -1;
}
