<?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 {
function getCurrentClass($orderline_id_in)
{
global $tables;
$database = connectToDatabase();
$query = "SELECT " . $tables['classes'] . ".name, " . $tables['classes'] . ".id,\r\n " . $tables['classes'] . ".priority,\r\n " . $tables['components'] . ".name, " . $tables['orderlines'] . ".order_id FROM " . $tables['selectedcomponents'] . " JOIN\r\n (" . $tables['classes'] . ", " . $tables['families'] . ", " . $tables['components'] . ", " . $tables['orders'] . ", " . $tables['orderlines'] . " ) ON\r\n ( " . $tables['classes'] . ".id=" . $tables['families'] . ".class_id AND\r\n " . $tables['families'] . ".id=" . $tables['components'] . ".family_id AND\r\n " . $tables['components'] . ".id=" . $tables['selectedcomponents'] . ".component_id AND\r\n " . $tables['selectedcomponents'] . ".orderline_id=" . $tables['orderlines'] . ".id AND\r\n " . $tables['orderlines'] . ".order_id=" . $tables['orders'] . ".id )\r\n WHERE " . $tables['selectedcomponents'] . ".orderline_id=" . $orderline_id_in . "\r\n ORDER BY " . $tables['classes'] . ".priority";
$result = mysqlQuery($query, $database);
$rows = mysql_num_rows($result);
if ($rows <= 0) {
$query_2 = "SELECT id FROM " . $tables['classes'] . " WHERE priority=1";
return mysqlGetSingleValue($query_2);
}
for ($row = 0; $row < $rows; $row++) {
$result_array = mysql_fetch_alias_array($result);
}
$priority = $result_array[$tables['classes'] . '.priority'] + 1;
$query = "SELECT id FROM " . $tables['classes'] . " WHERE priority=" . $priority;
$result = mysqlQuery($query, $database);
$rows = mysql_num_rows($result);
if ($rows <= 0) {
return createNewOrderline($result_array[$tables['orderline'] . '.order_id']);
} else {
$result_array = mysql_fetch_array($result);
return $result_array[0];
}
}
