示例#1
0
 $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).");
    }
}