/*
-- File Name : tbl_zona_sitio.php
-- Description : libreria para tabla tbl_zona_sitio
-- Programmer : Christian Díaz
-- Date : 19/jun/2007
*/
//*****************************************************
function fm_bus_zona_sitio($vtCod)
{
/*---------------*/
$veczona_sitio[0] = "tbl_zona_sitio" ;
$veczona_sitio[1] = "zonsit_cod" ;
$veczona_sitio[2] = "zonsit_desc" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " SELECT " . $veczona_sitio[1] . ", " . $veczona_sitio[2] . " " ;
$vlString = $vlString . " FROM " . $veczona_sitio[0] ;
$vlString = $vlString . " WHERE " . $veczona_sitio[1] . " >= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $veczona_sitio[1] . " = " . "'" . trim($vtCod) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_zona_sitio($vtDesc)
{
/*---------------*/
$veczona_sitio[0] = "tbl_zona_sitio" ;
$veczona_sitio[1] = "zonsit_cod" ;
$veczona_sitio[2] = "zonsit_desc" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " INSERT INTO " . $veczona_sitio[0] . "( " . $veczona_sitio[2] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtDesc . "') " ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_mod_zona_sitio($vtCod, $vtDesc)
{
/*---------------*/
$veczona_sitio[0] = "tbl_zona_sitio" ;
$veczona_sitio[1] = "zonsit_cod" ;
$veczona_sitio[2] = "zonsit_desc" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " UPDATE " . $veczona_sitio[0] ;
$vlString = $vlString . " SET " . $veczona_sitio[2] . " = " . "'" . fm_ecs($vtDesc) . "' " ;
$vlString = $vlString . " WHERE " . $veczona_sitio[1] . " = " . trim($vtCod) ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_elim_zona_sitio($vtCod)
{
/*---------------*/
$veczona_sitio[0] = "tbl_zona_sitio" ;
$veczona_sitio[1] = "zonsit_cod" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $veczona_sitio[0] ;
$vlString = $vlString . " WHERE " . $veczona_sitio[1] . " = " . trim($vtCod) ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
?>