[PHP] pobierz, plaintext 
  <div class="row bottom1">
    <div class="container">
      <h1>STB Warranty Result</h1>
    </div><!-- container -->
  </div>
  <div class="row bottom1_background"></div>
  <div class="row about_content">
    <div class="container">
      <div class="col-lg-12 col-xs-12">
 
<?php
if ( $_POST['data'] ) {
  include "js/function.php";
 
  try {
    if ( strlen(trim($_POST['data'])) == 0 ) {
        throw new Exception("No entry found.");
    }
    $database = loadDatabase("","","database");
 
    // CREATE TEMP mt1 TABLE
    $aryField = array( 'SN' );
    setQuery( $database, createTempTable( 'mt1', $aryField ) );
 
    // Split input data and insert into mt1 table
    $aryData = preg_split( "/\n|\r|\s/", "SN\n". htmlspecialchars(trim($_POST['data'])), -1, PREG_SPLIT_NO_EMPTY );
    setQuery( $database, insertTempTable( 'mt1', $aryField, removeEmpty($aryData) ) );
 
    /* Remove inaccurate serial numbers
    $query = "DELETE FROM mt1 WHERE SN NOT LIKE '__-_______'";
    setQuery( $database, $query );*/
 
    // Remove duplicate SN and set LIMIT of 100 units only
    $query = "CREATE TEMPORARY TABLE t1 AS (
        SELECT SN AS Find, customer_name, SN AS oSN 
        FROM mt1 
                LEFT JOIN repair_report AS a 
                ON mt1.SN = a.unit_serial_number AND a.customer_rma != 'INVENTORY' AND a.current_status NOT IN ('UTR')
        GROUP BY SN
        ORDER BY complete_date DESC
        LIMIT 0, 100)";
    setQuery( $database, $query );
 
    //---- Start to find the original serials -----------//
    $query = "SELECT Find, customer_name FROM t1";
    $result = getQuery( $database, $query );
    while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 
        //----- Find the original serials along same customer ----//
        $serial = $row['Find'];
        $customer = $row['customer_name'];
 
        $is_end = 1;
        do {
          $query = "SELECT fail_unit_serial_number 
                FROM repair_report 
                WHERE customer_name = ? AND unit_serial_number = ? AND fail_unit_serial_number LIKE '__-_______' 
                ORDER BY complete_date DESC";
          $stmt = $database -> prepare( $query );
 
          $stmt->bind_param( "ss", $customer, $serial );
          $stmt->execute();
          $stmt->store_result();
 
          if ( $stmt->num_rows > 0 ) {
            $stmt->bind_result( $fail_serial );
            $stmt->fetch();
            $serial = $fail_serial;
          } else {
            $is_end = 0;
          }
 
          $stmt->close();
        } while( $is_end > 0 );
 
       //---------------- Update the original serial ----------//
       $query = "UPDATE t1 SET oSN = '". $serial ."' WHERE Find = '". $row['Find'] ."'";
       setQuery( $database, $query );
    }
    mysqli_free_result( $result );
    //-------- End finding the original seiral -------------//
 
    // Find the warranty status for the original SN
    $query = "CREATE TEMPORARY TABLE showCase AS (
        SELECT Find, oSN, (additional_warranty_month + 12)  AS given_warranty_month, database_sale_order, customer, CASE WHEN customer_ship_date = '0000-00-00' THEN manufacturer_ship_date ELSE customer_ship_date END AS customer_ship_date
        FROM t1 LEFT JOIN production_shipment AS a
                ON t1.oSN = a.unit_serial_number )";
    setQuery( $database, $query );
 
    //--------- For EU warranty by prefix and sale order --------------//
    $query = "UPDATE showCase AS t1, customer_order_detail AS a SET t1.given_warranty_month = (a.given_warranty_month + t1.given_warranty_month - 12) WHERE t1.database_sale_order = a.database_sale_order AND SUBSTRING(t1.Find,1,2) = a.serial_prefix";
    setQuery( $database, $query );
 
    //---------- For CCI Kamai500 3 year warranty ----------------------//
    $query = "UPDATE showCase SET given_warranty_month = given_warranty_month + 24 WHERE customer LIKE 'CCI %' AND SUBSTRING(Find,1,2) = '26'";
    setQuery( $database, $query );
 
    //---------- For CCI Amulet400 2 year warranty ----------------------//
    $query = "UPDATE showCase SET given_warranty_month = given_warranty_month + 12 WHERE customer LIKE 'CCI %' AND SUBSTRING(Find,1,2) = '20'";
    setQuery( $database, $query );
 
    //---------- For P&T 15 month warranty ----------------------------//
    $query = "UPDATE showCase SET given_warranty_month = given_warranty_month + 3 WHERE customer LIKE 'P%&%T%' OR customer LIKE 'P%and%T%' OR customer LIKE 'Advanced Media%' OR customer LIKE 'Confluent%'";
    setQuery( $database, $query );
 
    //---------- All customer get addition 12 month warranty period ---//
    $query = "UPDATE showCase SET given_warranty_month = given_warranty_month + 12 WHERE customer_ship_date >= '2016-08-01'";
    setQuery( $database, $query );
 
    $query = "SELECT Find AS SN, SUBSTRING(Find,1,2) AS Model, CASE WHEN customer_ship_date IS NULL THEN 'Not Found' ELSE DATE_ADD(customer_ship_date, INTERVAL given_warranty_month MONTH) END AS ship_date FROM showCase ORDER BY ship_date DESC, Find ASC ";
    $result = getQuery( $database, $query );
 
    //Drawing Tables for second phase of submit serial numbers
    echo "<div class='result_data'>";
    echo "Total ". mysqli_num_rows( $result ) ." records found.<br>";
    generateTables( $result );
    echo "End.";
?>
 
</div></div>
 
<div class="disclaimer">
<ul style="border: 1px solid #DDD; border-radius: 10px; padding: 20px 40px; margin-top: 20px;"><b style="font-size:16px; margin-left: -20px; display: block;">The product is considered out of warranty if any of the following conditions apply:</b>
 <li>The Company product serial number has been defaced or removed.</li>
 <li>Damage has occurred to the product caused by normal wear and tear, accident, negligence, abuse, misuse, misapplication, willful damage, acts of God, or use with non-Companyproducts.</li>
 <li>Damage has occurred to the product due to not adhering to instructions on use and care of product.</li>
 <li>The Company product or a part of the product has been modified, had alterations, or repairs done to it without the written permission of Company.</li>
 <li>Damage has occurred to the Company product due to improper installation, abnormal working conditions, or effects of excessive electrical current or voltage, whether or not caused by lightning.</li>
</ul>
</div>
<?php
 
    echo "</div>";
    mysqli_close($database);
 
  } catch( Exception $e ) {
    echo "<font color=red>ERROR: ". $e->getMessage(). "</font>";
  }
} else {
  echo "<font color=red>ERROR: Invalid Input Data.</font>";
}
 
?>
 
      </div><!-- operators -->
    </div><!-- container -->
  </div>
[PHP] pobierz, plaintext