= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $vecArea[1] . " = '" . trim($vtCod) . "'" ;
}
//------------
if (!empty($vtCodInmb))
{
$vlString = $vlString . " AND " . $vecArea[2] . " = '" . trim($vtCodInmb) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_Area($vtInmb_cod, $vthab_ppal, $vtbano_visit, $vtbano_med, $vttipo_cocina, $vtestad_cocina,
$vttipo_estufa, $vttipo_horno, $vtnevera, $vtcongelador, $vtlavaplato, $vtMicro,
$vtPantry, $vtLavadora, $vtsecadora, $vtutensilio, $vttipo_salon_comedor, $vtestudio,
$vtfamily_room, $vthab_serv, $vtbano_serv, $vthab_chofer, $vttipo_estaciona, $vtmaletero)
{
/*******************************************/
$vecArea[0] ="tbl_inmb_area" ;
$vecArea[1] ="inarea_cod" ;
$vecArea[2] ="inarea_inmb_cod" ;
$vecArea[4] ="inarea_hab_ppal" ;
$vecArea[6] ="inarea_bano_visit" ;
$vecArea[7] ="inarea_bano_med" ;
$vecArea[8] ="inarea_tipo_cocina" ;
$vecArea[9] ="inarea_estad_cocina" ;
$vecArea[10]="inarea_tipo_estufa" ;
$vecArea[11]="inarea_tipo_horno" ;
$vecArea[12]="inarea_nevera" ;
$vecArea[13]="inarea_congelador" ;
$vecArea[14]="inarea_lavaplato" ;
$vecArea[15]="inarea_micro" ;
$vecArea[16]="inarea_pantry" ;
$vecArea[17]="inarea_lavadora" ;
$vecArea[18]="inarea_secadora" ;
$vecArea[19]="inarea_utensilio" ;
$vecArea[20]="inarea_tipo_salon_comedor" ;
$vecArea[22]="inarea_estudio" ;
$vecArea[23]="inarea_family_room" ;
$vecArea[24]="inarea_hab_serv" ;
$vecArea[25]="inarea_bano_serv" ;
$vecArea[26]="inarea_hab_chofer" ;
$vecArea[28]="inarea_tipo_estaciona" ;
$vecArea[29]="inarea_maletero" ;
/*******************************************/
$vlString = "" ;
$vlString = $vlString . " INSERT INTO " . $vecArea[0] . "( " . $vecArea[2] . ", " . $vecArea[4] . ", " ;
$vlString = $vlString . $vecArea[6] . ", " . $vecArea[7] . ", " . $vecArea[8] . ", " . $vecArea[9] . ", " ;
$vlString = $vlString . $vecArea[10] . ", " . $vecArea[11] . ", " . $vecArea[12] . ", " . $vecArea[13] . ", " . $vecArea[14] . ", " ;
$vlString = $vlString . $vecArea[15] . ", " . $vecArea[16] . ", " . $vecArea[17] . ", " . $vecArea[18] . ", " . $vecArea[19] . ", " ;
$vlString = $vlString . $vecArea[20] . ", " . $vecArea[22] . ", " . $vecArea[23] . ", " . $vecArea[24] . ", " ;
$vlString = $vlString . $vecArea[25] . ", " . $vecArea[26] . ", " . $vecArea[28] . ", " . $vecArea[29] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtInmb_cod . "', " ;
$vlString = $vlString . "'" . $vthab_ppal . "', " ;
$vlString = $vlString . "'" . $vtbano_visit . "', " ;
$vlString = $vlString . "'" . $vtbano_med . "', " ;
$vlString = $vlString . "'" . $vttipo_cocina . "', " ;
$vlString = $vlString . "'" . $vtestad_cocina . "', " ;
$vlString = $vlString . "'" . $vttipo_estufa . "', " ;
$vlString = $vlString . "'" . $vttipo_horno . "', " ;
$vlString = $vlString . "'" . $vtnevera . "', " ;
$vlString = $vlString . "'" . $vtcongelador . "', " ;
$vlString = $vlString . "'" . $vtlavaplato . "', " ;
$vlString = $vlString . "'" . $vtMicro . "', " ;
$vlString = $vlString . "'" . $vtPantry . "', " ;
$vlString = $vlString . "'" . $vtLavadora . "', " ;
$vlString = $vlString . "'" . $vtsecadora . "', " ;
$vlString = $vlString . "'" . $vtutensilio . "', " ;
$vlString = $vlString . "'" . $vttipo_salon_comedor . "', " ;
$vlString = $vlString . "'" . $vtestudio . "', " ;
$vlString = $vlString . "'" . $vtfamily_room . "', " ;
$vlString = $vlString . "'" . $vthab_serv . "', " ;
$vlString = $vlString . "'" . $vtbano_serv . "', " ;
$vlString = $vlString . "'" . $vthab_chofer . "', " ;
$vlString = $vlString . "'" . $vttipo_estaciona . "', " ;
$vlString = $vlString . "'" . $vtmaletero . "')" ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_mod_Area($vtCod, $vtInmb_cod, $vthab_ppal, $vtbano_visit, $vtbano_med, $vttipo_cocina,
$vtestad_cocina, $vttipo_estufa, $vttipo_horno, $vtnevera, $vtcongelador, $vtlavaplato, $vtMicro,
$vtPantry, $vtLavadora, $vtsecadora, $vtutensilio, $vttipo_salon_comedor, $vtestudio,
$vtfamily_room, $vthab_serv, $vtbano_serv, $vthab_chofer, $vttipo_estaciona, $vtmaletero)
{
/*******************************************/
$vecArea[0] ="tbl_inmb_area" ;
$vecArea[1] ="inarea_cod" ;
$vecArea[2] ="inarea_inmb_cod" ;
$vecArea[4] ="inarea_hab_ppal" ;
$vecArea[6] ="inarea_bano_visit" ;
$vecArea[7] ="inarea_bano_med" ;
$vecArea[8] ="inarea_tipo_cocina" ;
$vecArea[9] ="inarea_estad_cocina" ;
$vecArea[10]="inarea_tipo_estufa" ;
$vecArea[11]="inarea_tipo_horno" ;
$vecArea[12]="inarea_nevera" ;
$vecArea[13]="inarea_congelador" ;
$vecArea[14]="inarea_lavaplato" ;
$vecArea[15]="inarea_micro" ;
$vecArea[16]="inarea_pantry" ;
$vecArea[17]="inarea_lavadora" ;
$vecArea[18]="inarea_secadora" ;
$vecArea[19]="inarea_utensilio" ;
$vecArea[20]="inarea_tipo_salon_comedor" ;
$vecArea[22]="inarea_estudio" ;
$vecArea[23]="inarea_family_room" ;
$vecArea[24]="inarea_hab_serv" ;
$vecArea[25]="inarea_bano_serv" ;
$vecArea[26]="inarea_hab_chofer" ;
$vecArea[28]="inarea_tipo_estaciona" ;
$vecArea[29]="inarea_maletero" ;
/*******************************************/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecArea[0] ;
$vlString = $vlString . " SET " . $vecArea[2] . " ='" . $vtInmb_cod . "', " ;
$vlString = $vlString . " " . $vecArea[4] . " ='" . $vthab_ppal . "', " ;
$vlString = $vlString . " " . $vecArea[6] . " ='" . $vtbano_visit . "', " ;
$vlString = $vlString . " " . $vecArea[7] . " ='" . $vtbano_med . "', " ;
$vlString = $vlString . " " . $vecArea[8] . " ='" . $vttipo_cocina . "', " ;
$vlString = $vlString . " " . $vecArea[9] . " ='" . $vtestad_cocina . "', " ;
$vlString = $vlString . " " . $vecArea[10] . " ='" . $vttipo_estufa . "', " ;
$vlString = $vlString . " " . $vecArea[11] . " ='" . $vttipo_horno . "', " ;
$vlString = $vlString . " " . $vecArea[12] . " = " . $vtnevera . ", " ;
$vlString = $vlString . " " . $vecArea[13] . " = " . $vtcongelador . ", " ;
$vlString = $vlString . " " . $vecArea[14] . " = " . $vtlavaplato . ", " ;
$vlString = $vlString . " " . $vecArea[15] . " = " . $vtMicro . ", " ;
$vlString = $vlString . " " . $vecArea[16] . " = " . $vtPantry . ", " ;
$vlString = $vlString . " " . $vecArea[17] . " = " . $vtLavadora . ", " ;
$vlString = $vlString . " " . $vecArea[18] . " = " . $vtsecadora . ", " ;
$vlString = $vlString . " " . $vecArea[19] . " = " . $vtutensilio . ", " ;
$vlString = $vlString . " " . $vecArea[20] . " ='" . $vttipo_salon_comedor . "', " ;
$vlString = $vlString . " " . $vecArea[22] . " = " . $vtestudio . ", " ;
$vlString = $vlString . " " . $vecArea[23] . " = " . $vtfamily_room . ", " ;
$vlString = $vlString . " " . $vecArea[24] . " = '" . $vthab_serv . "', " ;
$vlString = $vlString . " " . $vecArea[25] . " = " . $vtbano_serv . ", " ;
$vlString = $vlString . " " . $vecArea[26] . " = " . $vthab_chofer . "," ;
$vlString = $vlString . " " . $vecArea[28] . " ='" . $vttipo_estaciona . "', " ;
$vlString = $vlString . " " . $vecArea[29] . " = " . $vtmaletero . " ";
$vlString = $vlString . " WHERE " . $vecArea[1] . " = '" . trim($vtCod) . "'" ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
function fm_elim_Area($vtCod)
{
/*****************************/
$vecArea[0] ="tbl_inmb_area" ;
$vecArea[1] ="inarea_cod" ;
$vecArea[2] ="inarea_inmb_cod" ;
/*****************************/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $vecArea[0] ;
$vlString = $vlString . " WHERE " . $vecArea[2] . " = " . trim($vtCod) ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
/********************************************************************************/
?>