<?Php
class sigesp_srh_c_municipio
{
	var $obj="";
	var $io_sql;
	var $siginc;
	var $con;
	var $ls_codemp;

	function sigesp_srh_c_municipio($path)
	{   require_once($path."shared/class_folder/class_sql.php");
		require_once($path."shared/class_folder/class_datastore.php");
		require_once($path."shared/class_folder/class_mensajes.php");
		require_once($path."shared/class_folder/sigesp_include.php");
		require_once($path."shared/class_folder/sigesp_c_seguridad.php");
		require_once($path."shared/class_folder/class_funciones.php");
		$this->io_msg=new class_mensajes();
		$this->io_funcion = new class_funciones();
		$this->la_empresa=$_SESSION["la_empresa"];
		$in=new sigesp_include();
		$this->con=$in->uf_conectar();
		$this->io_sql=new class_sql($this->con);
		$this->seguridad= new sigesp_c_seguridad();
		$this->ls_codemp=$_SESSION["la_empresa"]["codemp"];

}
  

  public function getProximoCodigo($ps_codest)
  {
    $ls_codmun = "01";
    $ls_sql = "SELECT MAX(codmun) AS codigo FROM sigesp_municipio ".
	          "WHERE codest = '$ps_codest'";
   $rs_data=$this->io_sql->select($ls_sql);
		if($rs_data===false)
		{
			$this->io_msg->message("CLASE->municipio MÉTODO->getProximoCodigo ERROR->".$this->io_funcion->uf_convertirmsg($this->io_sql->message));
			
		}
		else
		{
      $ls_codmun = $la_datos["codigo"][0]+1;
	  }
    if ($ls_codmun < 10)
     $ls_codmun = "0".$ls_codmun;
    return $ls_codmun;
  }
  
  
  public function getMunicipios($ps_codpai,$ps_codest,$ps_orden="",&$pa_datos="")
  {
    $lb_valido=true;
    $ls_sql = " SELECT * FROM sigesp_municipio ".
	          " WHERE  codpai = '$ps_codpai' ".
	          " AND    codest = '$ps_codest' ".
			  " AND    codmun <> '---' ".$ps_orden;
     

	$lb_valido=$this->io_sql->seleccionar($ls_sql, $pa_datos);
   
    return $lb_valido;
	}
  
 
}
?>