<?php

session_start();
$com="AS";
include("DMMYSQLG.php");
$resultado=[];  
$textBus=mysqli_real_escape_string($con,$_REQUEST['term']);
	  if(trim($textBus)!=''){
              $sq_invent=mysqli_query($con ,"SELECT DISTINCT(nparte1), np_desc1 FROM ctarea WHERE modulo='".$_SESSION['mod_sis']."' AND   np_desc1 like '$textBus%' or
                  modulo='".$_SESSION['mod_sis']."' AND   nparte1 like '$textBus%'  order by nparte1");
          }  
          while(@$reg = mysqli_fetch_array($sq_invent)){	
                      $row["label"]="(".$reg['nparte1'].")".$reg['np_desc1'];
                       $row["np_desc1"]=$reg['np_desc1'];
                      $row["id"]=$reg['nparte1'];
                      $row["value"]=$reg['np_desc1'];
                       
              $resultado[]=$row;  
		  }
	  
          
  echo json_encode($resultado);

//$q = mysqli_real_escape_string($con,$_GET["q"]);
//$limit= mysqli_real_escape_string($con,$_GET["limit"]);
//if($_GET['tipBus']=='d')
//	$sq_invent=mysqli_query($con ,"SELECT ctarea.np_desc1,ctarea.nparte1,ctarea.cod_var FROM ctarea WHERE ctarea.modulo='".$_SESSION['mod_sis']."' AND   np_desc1 like '$q%' order by np_desc1 limit $limit");
//elseif($_GET['tipBus']=='c')
//		$sq_invent=mysqli_query($con ,"SELECT * FROM ctarea WHERE ctarea.modulo='".$_SESSION['mod_sis']."' AND   nparte1 like '$q%' OR cod_var='$q' order by nparte1 limit $limit");
//while($dt_invent=mysqli_fetch_array($sq_invent)){
//	if(isset($dt_invent['np_desc1'])&&$dt_invent['np_desc1']==''){
//            echo'$dt_invent["np_desc1"]';
//        }  
//                
//            if(isset($dt_invent['nparte1'])&&$dt_invent['nparte1']==''){
//                echo'$dt_invent["nparte1"]';
//            }
//}
?>
