$result_compability = mysql_query($check_compability) or die(mysql_error()); if ($result_compability) { echo "<BR/> Compability checked successfuly "; } else { echo "<BR/> Compability checked failed. prepering to turn on Conversion modul.. <BR/><BR/>"; } //echo "Conversion Modul Set Up;"; if (!$result_compability) { echo "Conversion Modul Set Up<BR/><BR />"; echo "Echoing a current dump. Recieved from root system"; /*while($rek_echo=mysql_fetch_array($result_compability)) { }*/ $dump = array(); echo $dump = mysql_fetch_alias_array($result_compability); //here we go conversion module } else { echo "<BR />Systems coherent: Prepering to write: "; echo $site_id_w = $rek_site['site_id']; echo "<BR/>"; echo $origin_origin_id_w = $rek_site['Origin_origin_id']; echo "<BR/>"; echo $site_ref_num_w = $rek_site['site_ref_number']; echo "<BR/>"; echo $rep_auth_w = $rek_site['Rep_Auth']; echo "<BR />"; echo $dest_location_w = $rek_site['Dest_Location']; echo "<BR/>"; echo $batch_date_w = $rek_site['batch_date']; echo "<BR/>";
function displayPreviouslySelectedComponentList($orderline_id_in, $redirect_in = null) { global $tables, $assembly_fee; $query = "SELECT " . $tables['classes'] . ".name, " . $tables['classes'] . ".id,\r\n " . $tables['components'] . ".name, component.price, " . $tables['selectedcomponents'] . ".incompatible_flag FROM " . $tables['selectedcomponents'] . " JOIN\r\n (" . $tables['classes'] . ", " . $tables['families'] . ", " . $tables['components'] . " ) 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 )\r\n WHERE " . $tables['selectedcomponents'] . ".orderline_id=" . $orderline_id_in . "\r\n ORDER BY " . $tables['classes'] . ".priority"; $result = mysqlQuery($query); $num_rows = mysql_num_rows($result); echo "<table border='1' class='cart'>"; $is_flagged = 0; $price = $assembly_fee; for ($index = 0; $index < $num_rows; $index++) { $result_array = mysql_fetch_alias_array($result); $price += $result_array[$tables['components'] . '.price']; echo "<tr>\r\n <td>\r\n <div class='configuration_class_return_hyperlink'>\r\n <span class='configuration_class_return_hyperlink_bold'>\r\n <a href='configuration_system.php?return_to_class=" . $result_array[$tables['classes'] . '.id'] . "&orderline_id=" . $orderline_id_in . "&finished=" . $redirect_in . "'>" . $result_array[$tables['classes'] . '.name'] . "</a>\r\n <span class='colon'>:</span>\r\n </span></div>\r\n </td>\r\n <td>\r\n <span class='cart_component'>\r\n "; if ($result_array[$tables['selectedcomponents'] . '.incompatible_flag']) { $is_flagged = 1; echo "<span class='flagged'>*"; } echo $result_array[$tables['components'] . '.name']; if ($result_array[$tables['selectedcomponents'] . '.incompatible_flag']) { echo "</span>"; } echo "\r\n </span>\r\n </td>\r\n <td>\r\n <p class='cart_price'>\r\n \$" . number_format($result_array[$tables['components'] . '.price'], 2, '.', ',') . "\r\n </p>\r\n </td>\r\n </tr>"; } echo "<tr><td></td><td><span class='cart_assembly_fee'>Item Assembly</span></td><td><p class='cart_price_assembly'>\$" . number_format($assembly_fee, 2, '.', ',') . "</p></td></tr>"; echo "<tr><td></td><td><span class='cart_total'>Item Price</span></td><td><p class='cart_price_total'>\$" . number_format($price, 2, '.', ',') . "</p></td></tr>"; echo "</table>"; $query = "SELECT price FROM orderline WHERE id=" . $orderline_id_in; $db_price = mysqlGetSingleValue($query, $database); if (intval($price * 100) !== intval($db_price * 100)) { renderError("The stored price and the calculated price are different; you will be charged \$" . number_format($db_price, 2, '.', ',') . " for this item. Please contact customer service and provide the following information to customer service: orderline.id=" . $orderline_id_in); } if ($is_flagged == 1) { renderError("You must re-select items for the above red area(s)."); } }