= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $vecObserv[1] . " = '" . trim($vtCod) . "'" ;
}
//------------
if (!empty($vtCodInmb))
{
$vlString = $vlString . " AND " . $vecObserv[2] . " = '" . trim($vtCodInmb) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_Observ($vtInmb_cod, $vthist_propied, $vtotros_datos)
{
/*****************************************/
$vecObserv[0]="tbl_inmb_obser" ;
$vecObserv[1]="inobs_cod" ;
$vecObserv[2]="inobs_inmb_cod" ;
$vecObserv[3]="inobs_hist_propied" ;
$vecObserv[4]="inobs_otros_datos" ;
/*****************************************/
$vlString = "" ;
$vlString = $vlString . " INSERT INTO " . $vecObserv[0] . "( " . $vecObserv[2] . ", " . $vecObserv[3] . ", " . $vecObserv[4] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtInmb_cod . "', " ;
$vlString = $vlString . "'" . fm_ecs($vthist_propied) . "', " ;
$vlString = $vlString . "'" . fm_ecs($vtotros_datos) . "') " ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_mod_Observ($vtCod, $vtInmb_cod, $vthist_propied, $vtotros_datos)
{
/*****************************************/
$vecObserv[0]="tbl_inmb_obser" ;
$vecObserv[1]="inobs_cod" ;
$vecObserv[2]="inobs_inmb_cod" ;
$vecObserv[3]="inobs_hist_propied" ;
$vecObserv[4]="inobs_otros_datos" ;
/*****************************************/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecObserv[0] ;
$vlString = $vlString . " SET " . $vecObserv[2] . " = '" . $vtInmb_cod . "', " ;
$vlString = $vlString . " " . $vecObserv[3] . " = '" . fm_ecs($vthist_propied) . "', " ;
$vlString = $vlString . " " . $vecObserv[4] . " = '" . fm_ecs($vtotros_datos) . "'" ;
$vlString = $vlString . " WHERE " . $vecObserv[1] . " = '" . trim($vtCod) . "'" ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_elim_Observ($vtCod)
{
/*****************************/
$vecObserv[0]="tbl_inmb_obser" ;
$vecObserv[1]="inobs_cod" ;
$vecObserv[2]="inobs_inmb_cod" ;
/*****************************/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $vecObserv[0] ;
$vlString = $vlString . " WHERE " . $vecObserv[2] . " = " . trim($vtCod) ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
?>