<?php

if (session_status() == PHP_SESSION_NONE) {

    session_start();

}



//Including Database configuration file.

include "../db.php";

$iduserlog=$_SESSION["iduserlogin"];

$idcompany = $_SESSION["compid"];

//Getting value of "search" variable from "script.js".

if (isset($_POST['articlepartvalue'])) {

//Search box value assigning to $Name variable.

   $Name = $_POST['articlepartvalue'];

//Search query.

  

 //Query execution

    /*   $Query = "

SELECT *

FROM identificationparts 

LEFT JOIN `trf-details` ON `trf-details`.idtrfdetails = identificationparts.idtrfdetails 

WHERE identificationparts.article_identificationparts LIKE '%$Name%' 

AND `trf-details`.idcompany = '$idcompany' 

GROUP BY identificationparts.article_identificationparts, identificationparts.material_identificationparts

LIMIT 5";

*/



    $Query = "SELECT 

MIN(identificationparts.ididentificationparts) AS id, 

identificationparts.article_identificationparts, 

identificationparts.description_identificationparts, 

identificationparts.material_identificationparts,

MAX(identificationparts.color_identificationparts) AS color_identificationparts,

MAX(identificationparts.component_identificationparts) AS component_identificationparts,

MAX(identificationparts.cmcreportnumber_identificationparts) AS cmcreportnumber_identificationparts,

MAX(identificationparts.cmcreportdate_identificationparts) AS cmcreportdate_identificationparts,

MAX(identificationparts.thirdlabreportnumber_identificationparts) AS thirdlabreportnumber_identificationparts,

MAX(identificationparts.thirdlabreportdate_identificationparts) AS thirdlabreportdate_identificationparts,

MAX(identificationparts.reportof) AS reportof,

MAX(identificationparts.kindoftest) AS kindoftest,

MAX(identificationparts.partsidnumber) AS partsidnumber,

MAX(identificationparts.arttypeid) AS arttypeid,

MAX(`trf-details`.idtrfdetails) AS idtrfdetails,

`trf-details`.idcompany

FROM 

identificationparts 

LEFT JOIN 

`trf-details` 

ON 

`trf-details`.idtrfdetails = identificationparts.idtrfdetails 

WHERE 

identificationparts.article_identificationparts LIKE '%$Name%' 

AND `trf-details`.idcompany = '$idcompany'

GROUP BY 

identificationparts.article_identificationparts, 

identificationparts.description_identificationparts, 

identificationparts.material_identificationparts

LIMIT 15";







//Query execution

   $ExecQuery = MySQLi_query($conn, $Query);

//Creating unordered list to display result.

   echo '

<ul>

   ';

   //Fetching result from database.

    $bgcolor = "#f2f2f2";

   

   while ($Result = MySQLi_fetch_array($ExecQuery)) {

   //Switching background color.

       if ($bgcolor == "#f2f2f2") {

           $bgcolor = "#e6f7ff";

       } else {

           $bgcolor = "#f2f2f2";

       }

       ?>

   <!-- Creating unordered list items.

        Calling javascript function named as "fill" found in "script.js" file.

        By passing fetched result as parameter. -->

        <li onclick='fill(

    <?php echo json_encode($Result['article_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['material_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['color_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['description_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['partsidnumber'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['arttypeid'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['cmcreportnumber_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['cmcreportdate_identificationparts'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['reportof'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>, 

    <?php echo json_encode($Result['kindoftest'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>

    )' style="cursor: pointer; background-color: <?php echo $bgcolor; ?>; border: 1px solid #ccc; border-radius: 5px; padding: 10px; margin-bottom: 5px;">

            <span style="text-decoration: none; color: #333;">

                <?php echo htmlspecialchars($Result['article_identificationparts'], ENT_QUOTES, 'UTF-8'); ?> -

                <?php echo htmlspecialchars($Result['material_identificationparts'], ENT_QUOTES, 'UTF-8'); ?> -

                <?php echo htmlspecialchars($Result['color_identificationparts'], ENT_QUOTES, 'UTF-8'); ?> -

                [<?php echo htmlspecialchars($Result['description_identificationparts'], ENT_QUOTES, 'UTF-8'); ?>]

                <?php if (!empty($Result['cmcreportnumber_identificationparts'])) { ?>

                    - Rep. <?php echo htmlspecialchars($Result['cmcreportnumber_identificationparts'], ENT_QUOTES, 'UTF-8'); ?>

                <?php } ?>

                <?php if (!empty($Result['cmcreportdate_identificationparts'])) { ?>

                    - Date: <?php echo htmlspecialchars($Result['cmcreportdate_identificationparts'], ENT_QUOTES, 'UTF-8'); ?>

                <?php } ?>

            </span>

        </li>

   <!-- Below php code is just for closing parenthesis. Don't be confused. -->

   <?php

}}

?>

</ul>