
<?php

    // $con = mysql_connect('dmj.rm153.com:33333','root','321');

    // $db  = mysql_select_db('dbplb',$con);
include 'connect.php';
session_start();

$nobukti=$_SESSION['nobukti'];
$cabang=$_SESSION['cbg'];
$kdharga=$_SESSION['kdharga'];
$kdgudang=$_SESSION['gudang'];
$kdslm=$_SESSION['kdslm'];
$custno=$_SESSION['custno'];

    

    if (isset($_GET['input'])) {

        $input = $_GET['input'];
		
        $cariharga=mysqli_query($con,"select tglberlaku from hargajual where kdharga='$kdharga' order by tglberlaku desc limit 1;");
	    $hargajual=mysqli_fetch_array($cariharga);
		
		$tglberlaku=$hargajual['tglberlaku'];
        $query = mysqli_query($con,"SELECT a.kdbrg,a.namabrg1,a.isi3,a.hrgjual,concat(a.namabrg1,' /isi : ',a.isi3) as gabung  FROM barang a
		left join salesman_supp c on a.kdsupplier=c.kdsupplier and c.kdslm='$kdslm'
		WHERE a.stat='1' and a.namabrg1 LIKE '%$input%' group by a.kdsupplier,a.kdbrg desc limit 20"); //query mencari hasil search

        if ($query === FALSE) {

    die(mysqli_error());

}

        $hasil = mysqli_num_rows($query);

        if ($hasil > 0)

        {

            while ($data = mysqli_fetch_row($query)) {

            ?>

            <a href="javascript:autoInsert('<?=$data[0]?>','<?=$data[1]?>','<?=$data[2]?>','<?=$data[3]?>','<?=$data[4]?>');"><?=$data[1]?><br> <!--- hasil -->

            <?php

            }    

        }

    } 

?>