SM0 She11

Path: / / home / saienerg / public_html / intra

Full Path (server): /home/saienerg/public_html/intra

📄 ajax1.php [E] [D]
📄 article_list.php [E] [D]
📁 assets Open [D]
📁 career Open [D]
📄 career_enquiries.php [E] [D]
📄 cat_load.php [E] [D]
📁 change Open [D]
📄 cmn_lib.php [E] [D]
📄 common.php [E] [D]
📄 compressImage.php [E] [D]
📄 config.php [E] [D]
📁 css Open [D]
📁 dashboard Open [D]
📁 data Open [D]
📁 fonts Open [D]
📄 foo_scripts.php [E] [D]
📄 foo_scripts1.php [E] [D]
📄 footer.php [E] [D]
📄 footer1.php [E] [D]
📄 form.php [E] [D]
📁 gallery Open [D]
📄 getExtension.php [E] [D]
📄 header.php [E] [D]
📄 header1.php [E] [D]
📁 hrrepo Open [D]
📁 images Open [D]
📁 includes Open [D]
📄 index.php [E] [D]
📄 index1.php [E] [D]
📄 kis_config.php [E] [D]
📄 login.php [E] [D]
📄 logout.php [E] [D]
📁 masters Open [D]
📁 others Open [D]
📁 perfomances Open [D]
📁 products Open [D]
📄 products.js [E] [D]
📁 services Open [D]
📄 sidebar.php [E] [D]
📄 sidebar1.php [E] [D]
📄 spel_config.php [E] [D]
📄 top_nav.php [E] [D]
📄 top_nav1.php [E] [D]
📁 users Open [D]

Editing: ajax1.php

<?php

include('spel_config.php');

include("cmn_lib.php");

$obj= new common();

if($_GET['type'] == 'splr_search'){
	$q = $_GET['name_startsWith'];	
 
   $sql_res=mysqli_query($idb,"select * from suppliers_list where name  Like '$q%' order by   name ASC  ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
	   
	
		    $splr_id=$row['splr_id'];  $name=strtoupper($row['name']);     $city=strtoupper($row['city']);
	 
 
 $name = $splr_id.'|'.$name.'|'.$city;
			
		
		array_push($data, $name);	
		}
		echo json_encode($data);
 }
 
 if($_GET['type'] == 'cmr_search'){
	$q = $_GET['name_startsWith'];	
 
   $sql_res=mysqli_query($idb,"select * from customers_list where status='0'  and name  Like '$q%' order by   name ASC  ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
	   
	
		    $cmr_id=$row['cmr_id'];  $name=strtoupper($row['name']);     $city=strtoupper($row['city']);
	 
 
 $name = $cmr_id.'|'.$name.'|'.$city;
			
		
		array_push($data, $name);	
		}
		echo json_encode($data);
 }
 
else if($_GET['type'] == 'mtrl_search'){
	$q = $_GET['name_startsWith'];	
	
	$mtyp= $_GET['mtrl_typ'];
	
	
	
	
	
	
 
   $sql_res=mysqli_query($idb,"select * from mtrl_list where status='0' and   mtyp_id='$mtyp' and  name  Like '$q%' order by   name ASC  ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
			
			$mnf_id=$row['mnf_id'];
			
			$mnf_rw=$obj->get_mnfdetails($mnf_id);
			 
		    $mtrl_id=$row['mtrl_id'];  $nme=strtoupper($row['name']);
			
			
			
$row1=$obj->get_mtrldetails($mtrl_id);
  
$nme=  $row1['nme']; $sze=$row1['size'];

$gsm_id=$row1['gsm'];    $clr=$row1['clr'];  $wgt=$row1['wgt'];

$gsm_rw=$obj->get_gsmdetails($gsm_id);  $gsm_nme=$gsm_rw['nme'];
if($gsm_nme!='')
{  $gsm_nme="$gsm_nme GSM,";
} else
{ $gsm_nme='';
}

if($sze!='')
{
$size="($sze)";
}else{
	
$size='';	
}

if($wgt!='')
{
$wgt="($wgt K.G)";	
}else{
$wgt='';	
}

// $mtrl_nme="$nme$size $gsm_nme $wgt  $clr ";			
			
	 $mtrl_nme="$nme$size  $clr ";			 
			
			
			$mnf_nme=$mnf_rw['nme'];
			
if(isset($_GET['type1']))
{
 $avl_qty=$obj->get_mtrlavail($mtrl_id);
}else
{
	$avl_qty='0';
}
			
	$uom_id=$row1['uom'];  	    $um_rw=$obj->get_uomdetails($uom_id);
	
	$uom_nme=$um_rw['nme'];  $sze=$row1['size'];    $meters=$row1['meters']; 
	 
 
 $name = $mtrl_id.'|'.$mtrl_nme.'|'.$mnf_nme.'|'.$avl_qty.'|'.$uom_id.'|'.$uom_nme.'|'.$meters;
			
		
		array_push($data, $name);	
  }
echo json_encode($data);

$sql_res=mysqli_query($idb,"select * from products_list where status='0' and   ptyp_id='$mtyp' and  name  Like '$q%' order by   name ASC  ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
			
			$mnf_id=$row['mnf_id'];
			
			$mnf_rw=$obj->get_mnfdetails($mnf_id);
			 
		    $prd_id=$row['prd_id'];  $nme=strtoupper($row['name']);
			
			
			
			
			
			
$row1=$obj->get_prddetails($prd_id);
  
$nme=  $row1['nme']; $sze=$row1['size'];

$gsm_id=$row1['gsm'];    $clr=$row1['clr'];  $wgt=$row1['wgt'];

$gsm_rw=$obj->get_gsmdetails($gsm_id);  $gsm_nme=$gsm_rw['nme'];
if($gsm_nme!='')
{  $gsm_nme="$gsm_nme GSM,";
} else
{ $gsm_nme='';
}

if($sze!='')
{
$size="($sze)";
}else{
	
$size='';	
}

if($wgt!='')
{
$wgt="($wgt K.G)";	
}else{
$wgt='';	
}

// $mtrl_nme="$nme$size $gsm_nme $wgt  $clr ";			
			
	 $mtrl_nme="$nme$size  $clr ";			 
			
			
			$mnf_nme=$mnf_rw['nme'];
			
 
			
	$uom_id=$row1['uom'];  	    $um_rw=$obj->get_uomdetails($uom_id);
	
	$uom_nme=$um_rw['nme'];  $mrp=$row1['mrp'];    $meters=$row1['meters']; 
	 
 
 $avl_qty=$obj->getprdavail($prd_id);
 
 
 $name = $prd_id.'|'.$nme.'|'.$mnf_nme.'|'.$prd_id.'|'.$avl_qty.'|'.$mrp;
			
		
		array_push($data, $name);	
  }
echo json_encode($data);

}else if($_GET['type'] == 'po_search')
{
	$q = $_GET['no_startsWith'];	
	
	  
    
  $sql_res=mysqli_query($idb,"select * from po_list where ic_sts='0' and  po_no  Like '$q%' order by   po_no ASC  ");
  $data = array();
		while ($trow = mysqli_fetch_array($sql_res)) {
			
			$po_id=$trow['po_id'];
			
			
			
			
			$row=$obj->get_podetails($po_id);
			
			
			
			$po_no=$row['po_no'];      $po_dt=$row['po_dt']; 
			
			 $slpr_nme=$row['splr_nme']; 
			
			
			
		 
 $name = $po_id.'|'.$po_no.'|'.$po_dt.'|'.$slpr_nme;
			
		
		array_push($data, $name);	
		}
		echo json_encode($data);
 } 	
 
 
 
else  if($_GET['type'] == 'pkt_search'){
	$q = $_GET['name_startsWith'];	 $cmr_id = $_GET['cmr_id'];	
	
	 $pkt_typ = $_GET['pkt_typ'];	
	
	if($pkt_typ =='1') // Customer Wise Packet Search
	{
     $cmr_id = $_GET['cmr_id'];
     $e_qry ="and  cmr_id='$cmr_id' and  pkt_for='1' "; $pkt_for='1';
	}else{
		$e_qry="  and  pkt_for='0'";    $cmr_id ='0';
	}
	
	/*if($cmr_id!='')
	{
		 $cmr_id = $_GET['cmr_id'];
	}else
	{
		
	 $cmr_id ='0';	
	}*/
	
	
	
	
       $q1= ("select group_concat(DISTINCT pkt_id) as pkt_ids from packet_details where  status='0'    $e_qry");
   $q1=mysqli_query($idb,"select group_concat(DISTINCT pkt_id) as pkt_ids from packet_details where  status='0'      $e_qry ");
   $rws=mysqli_num_rows($q1);
   if($rws>'0')
   {
	$f1=mysqli_fetch_array($q1);
	$pkt_ids=$f1['pkt_ids'];
   }else
   {
	$pkt_ids='';   
   }
	
	
	if($pkt_ids!='')
	{
 
   $sql_res=mysqli_query($idb,"select * from pkt_list  where pkt_id IN ($pkt_ids) and status='0' and  name  Like '$q%' order by   name ASC  ");
        $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
	   $pkt_id=$row['pkt_id'];  
	   
 	    $iqry=mysqli_query($idb,"select pkd_id ,pkt_prc from packet_details where   pkt_id='$pkt_id'  and cmr_id='$cmr_id' and status='0'");
	   $if1=mysqli_fetch_array($iqry);
	     $pkd_id=$if1['pkd_id'];   $pkt_prc=$if1['pkt_prc'];
	   
 		   $iqry1=mysqli_query($idb,"select sum(pkt_cnt) as pkt_cnt from pktinw_list where   pkt_id='$pkt_id'  and cmr_id='$cmr_id' and status='0' ");
	   $if2=mysqli_fetch_array($iqry1);
	   $pkt_cnt=$if2['pkt_cnt'];
	   
  $iqry2=mysqli_query($idb,"select sum(usd_qty) as usd_cnt from pktinw_products where   pkt_id='$pkt_id'  and cmr_id='$cmr_id' and status='0' ");
	   $if3=mysqli_fetch_array($iqry2);
	   $usd_cnt=$if3['usd_cnt'];
	   
	   
	   $avl_qty=$pkt_cnt-$usd_cnt;
	   
	   if($avl_qty>0&& $avl_qty!='')
	   {
		    //$pkt_cnt=$if2['pkt_cnt'];
			
			$pkt_cnt=$avl_qty;
	   }else
	   {
		    $pkt_cnt='0';
	   }
	   
	
		     	 $pkt_prc= number_format((float)$pkt_prc, 2, '.', '');
			
			$nme=$obj->get_pktnme($pkt_id);
	 
 
 $name = $pkt_id.'|'.$nme.'|'.$pkd_id.'|'.$pkt_cnt.'|'.$pkt_prc;
 
			
		
		array_push($data, $name);	
		}
	}else
	{
		
		$data='';
	}
		echo json_encode($data);
 }
 else   if($_GET['type'] == 'qtn_search'){
	$q = $_GET['name_startsWith'];	
 
   $sql_res=mysqli_query($idb,"select * from qtn_list where qtn_no  Like '$q%' order by   qtn_no ASC  ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
	   
	
		    $qtn_no=$row['qtn_no'];   $qtn_id=$row['qtn_id']; 
			
			
			$qtn_rw=$obj->get_qtndetails($qtn_id);
			
			
	$cmr_id=$qtn_rw['cmr_id']; 		 $cmr_nme=strtoupper($qtn_rw['cmr_nme']);     
	 
 
 $name = $qtn_id.'|'.$qtn_no.'|'.$cmr_id.'|'.$cmr_nme;
			
		
		array_push($data, $name);	
		}
		echo json_encode($data);
 }
 
 else   if($_GET['type'] == 'inv_search'){
	$q = $_GET['name_startsWith'];	
	
//$q1=mysqli_query($idb,"select group_concat(inv_id)as inv_ids from ")	;
	
	
	
 
   $sql_res=mysqli_query($idb,"select * from invoice_list where inv_no  Like '$q%' order by   inv_no ASC  LIMIT 0,10 ");
  $data = array();
		while ($row = mysqli_fetch_array($sql_res)) {
	   
	
		    $inv_no=$row['inv_no'];   $inv_id=$row['inv_id']; 
			
			
			$irw=$obj->get_invdetails($inv_id);
			
			
	$cmr_id=$irw['cmr_id']; 		 $cmr_nme=strtoupper($irw['cmr_nme']);      $inv_dt=$irw['inv_dt'];
	 
 
 $name = $inv_id.'|'.$inv_no.'|'.$inv_dt.'|'.$cmr_id.'|'.$cmr_nme.'|'.$cmr_nme;
			
		
		array_push($data, $name);	
		}
		echo json_encode($data);
 }