= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $vecvarios[1] . " = '" . trim($vtCod) . "'" ;
}
//------------
if (!empty($vtCodInmb))
{
$vlString = $vlString . " AND " . $vecvarios[2] . " = '" . trim($vtCodInmb) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_varios($vtInmb_cod, $vtTennis, $vtGimnasio, $vtSquash, $vtSauna, $vtSalaFiest, $vtJardin, $vtTip_vigilancia)
{
/*****************************************/
$vecvarios[0]="tbl_inmb_varios" ;
$vecvarios[1]="invar_cod" ;
$vecvarios[2]="invar_inmb_cod" ;
$vecvarios[3]="invar_tennis" ;
$vecvarios[4]="invar_gimnasio" ;
$vecvarios[5]="invar_squash" ;
$vecvarios[6]="invar_sala_fies" ;
$vecvarios[7]="invar_sauna" ;
$vecvarios[8]="invar_jardin" ;
$vecvarios[9]="invar_tip_vigilancia" ;
/*****************************************/
$vlString = "" ;
$vlString = $vlString . " INSERT INTO " . $vecvarios[0] . "( " . $vecvarios[2] . ", " . $vecvarios[3] . ", " . $vecvarios[4] . ", " ;
$vlString = $vlString . $vecvarios[5] . ", " . $vecvarios[6] . ", " . $vecvarios[7] . ", " . $vecvarios[8] . ", " . $vecvarios[9] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtInmb_cod . "', " ;
$vlString = $vlString . $vtTennis . ", " ;
$vlString = $vlString . $vtGimnasio . ", " ;
$vlString = $vlString . $vtSquash . ", " ;
$vlString = $vlString . $vtSauna . ", " ;
$vlString = $vlString . $vtSalaFiest . ", " ;
$vlString = $vlString . $vtJardin . ", " ;
$vlString = $vlString . "'" . $vtTip_vigilancia . "') " ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_mod_varios($vtCod, $vtInmb_cod, $vtTennis, $vtGimnasio, $vtSquash, $vtSauna, $vtSalaFiest, $vtJardin, $vtTip_vigilancia)
{
/*****************************************/
$vecvarios[0]="tbl_inmb_varios" ;
$vecvarios[1]="invar_cod" ;
$vecvarios[2]="invar_inmb_cod" ;
$vecvarios[3]="invar_tennis" ;
$vecvarios[4]="invar_gimnasio" ;
$vecvarios[5]="invar_squash" ;
$vecvarios[6]="invar_sala_fies" ;
$vecvarios[7]="invar_sauna" ;
$vecvarios[8]="invar_jardin" ;
$vecvarios[9]="invar_tip_vigilancia" ;
/*****************************************/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecvarios[0] ;
$vlString = $vlString . " SET " . $vecvarios[2] . " = '" . $vtInmb_cod . "', " ;
$vlString = $vlString . " " . $vecvarios[3] . " = " . $vtTennis . ", " ;
$vlString = $vlString . " " . $vecvarios[4] . " = " . $vtGimnasio . ", " ;
$vlString = $vlString . " " . $vecvarios[5] . " = " . $vtSquash . ", " ;
$vlString = $vlString . " " . $vecvarios[6] . " = " . $vtSauna . ", " ;
$vlString = $vlString . " " . $vecvarios[7] . " = " . $vtSalaFiest . ", " ;
$vlString = $vlString . " " . $vecvarios[8] . " = " . $vtJardin . ", " ;
$vlString = $vlString . " " . $vecvarios[9] . " = " . $vtTip_vigilancia . " " ;
$vlString = $vlString . " WHERE " . $vecvarios[1] . " = '" . trim($vtCod) . "'" ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_elim_varios($vtCod)
{
/*****************************/
$vecvarios[0]="tbl_inmb_varios" ;
$vecvarios[1]="invar_cod" ;
$vecvarios[2]="invar_inmb_cod" ;
/*****************************/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $vecvarios[0] ;
$vlString = $vlString . " WHERE " . $vecvarios[2] . " = " . trim($vtCod) ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
?>