<?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]; } }