= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $vecarea_aux[1] . " = '" . trim($vtCod) . "'" ;
}
//------------
if (!empty($vtCodInmb))
{
$vlString = $vlString . " AND " . $vecarea_aux[2] . " = '" . trim($vtCodInmb) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_area_aux($vtCodInmb, $vtConst, $vtJardin, $vtTerra)
{
/*---------------*/
$vecarea_aux[0] = "tbl_area_aux" ;
$vecarea_aux[1] = "areaux_cod" ;
$vecarea_aux[2] = "areaux_inmb_cod" ;
$vecarea_aux[3] = "areaux_const" ;
$vecarea_aux[4] = "areaux_jardin" ;
$vecarea_aux[5] = "areaux_terra" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " INSERT INTO " . $vecarea_aux[0] . "( " . $vecarea_aux[2] . ", " . $vecarea_aux[3] . ", " . $vecarea_aux[4] . ", " . $vecarea_aux[5] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtCodInmb . "', " ;
$vlString = $vlString . "'" . fm_format_number($vtConst) . "', " ;
$vlString = $vlString . "'" . fm_format_number($vtJardin) . "', " ;
$vlString = $vlString . "'" . fm_format_number($vtTerra) . "') " ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_mod_area_aux($vtCod, $vtCodInmb, $vtConst, $vtJardin, $vtTerra)
{
/*---------------*/
$vecarea_aux[0] = "tbl_area_aux" ;
$vecarea_aux[1] = "areaux_cod" ;
$vecarea_aux[2] = "areaux_inmb_cod" ;
$vecarea_aux[3] = "areaux_const" ;
$vecarea_aux[4] = "areaux_jardin" ;
$vecarea_aux[5] = "areaux_terra" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecarea_aux[0] ;
$vlString = $vlString . " SET " . $vecarea_aux[2] . " = '" . $vtCodInmb . "', " ;
$vlString = $vlString . " " . $vecarea_aux[3] . " = '" . fm_format_number($vtConst) . "', " ;
$vlString = $vlString . " " . $vecarea_aux[4] . " = '" . fm_format_number($vtJardin) . "', " ;
$vlString = $vlString . " " . $vecarea_aux[5] . " = '" . fm_format_number($vtTerra) . "'" ;
$vlString = $vlString . " WHERE " . $vecarea_aux[1] . " = '" . trim($vtCod) . "'";
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_elim_area_aux($vtCod)
{
/*---------------*/
$vecarea_aux[0] = "tbl_area_aux" ;
$vecarea_aux[1] = "areaux_cod" ;
$vecarea_aux[2] = "areaux_inmb_cod" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $vecarea_aux[0] ;
$vlString = $vlString . " WHERE " . $vecarea_aux[2] . " = '" . trim($vtCod) . "'";
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
?>