= 1 " ;
//------------
if (!empty($vtCod))
{
$vlString = $vlString . " AND " . $vecfoto[1] . " = '" . trim($vtCod) . "'" ;
}
//------------
if (!empty($vtCodInmb))
{
$vlString = $vlString . " AND " . $vecfoto[2] . " = '" . trim($vtCodInmb) . "'" ;
}
//------------
if (!empty($vtStatus))
{
$vlString = $vlString . " AND " . $vecfoto[5] . " = '" . trim($vtStatus) . "'" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
function fm_reg_foto($vtCodInmb, $vtNomb, $vtDesc, $vtActiv)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_cod" ;
$vecfoto[2] = "fot_inmb_cod" ;
$vecfoto[3] = "fot_nomb" ;
$vecfoto[4] = "fot_desc" ;
$vecfoto[5] = "fot_stat" ;
/*---------------*/
if($vtActiv == 1){fm_mod_stat_foto_gen($vtCodInmb);}
/*---------------*/
$vlString = "";
$vlString = $vlString . " INSERT INTO " . $vecfoto[0] . "( " . $vecfoto[2] . ", " . $vecfoto[3] . ", " . $vecfoto[4] . ", " . $vecfoto[5] . ") " ;
$vlString = $vlString . " VALUES ( " ;
$vlString = $vlString . "'" . $vtCodInmb . "', " ;
$vlString = $vlString . "'" . $vtNomb . "', " ;
$vlString = $vlString . "'" . $vtDesc . "', " ;
$vlString = $vlString . $vtActiv . ") " ;
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_mod_foto($vtCod, $vtCodInmb, $vtNomb, $vtDesc, $vtActiv)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_cod" ;
$vecfoto[2] = "fot_inmb_cod" ;
$vecfoto[3] = "fot_nomb" ;
$vecfoto[4] = "fot_desc" ;
$vecfoto[5] = "fot_stat" ;
/*---------------*/
if($vtActiv == 1){fm_mod_stat_foto_gen($vtCodInmb);}
/*---------------*/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecfoto[0] ;
$vlString = $vlString . " SET " . $vecfoto[2] . " = '" . $vtCodInmb . "', " ;
$vlString = $vlString . " " . $vecfoto[3] . " = '" . fm_ecs($vtNomb) . "', " ;
$vlString = $vlString . " " . $vecfoto[4] . " = '" . fm_ecs($vtDesc) . "', " ;
$vlString = $vlString . " " . $vecfoto[5] . " = '" . $vtActiv . "'" ;
$vlString = $vlString . " WHERE " . $vecfoto[1] . " = '" . trim($vtCod) . "'";
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_elim_foto($vtCod, $vtNomb)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_cod" ;
$vecfoto[2] = "fot_inmb_cod" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " DELETE FROM " . $vecfoto[0] ;
$vlString = $vlString . " WHERE " . $vecfoto[1] . " = '" . trim($vtCod) . "'";
/*---------------*/
if (!empty($vtNomb))
{
$vlArchivo = "../../fotos/". $vtNomb;
unlink($vlArchivo);
}
/*---------------*/
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_mod_stat_foto($vtCod, $vtActiv, $vtCodInmb)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_cod" ;
$vecfoto[2] = "fot_stat" ;
/*---------------*/
if($vtActiv == 1){fm_mod_stat_foto_gen($vtCodInmb);}
/*---------------*/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecfoto[0] ;
$vlString = $vlString . " SET " . $vecfoto[2] . " = " . $vtActiv . " " ;
$vlString = $vlString . " WHERE " . $vecfoto[1] . " = '" . trim($vtCod) . "'";
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_mod_stat_foto_gen($vtCodInmb)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_inmb_cod" ;
$vecfoto[2] = "fot_stat" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " UPDATE " . $vecfoto[0] ;
$vlString = $vlString . " SET " . $vecfoto[2] . " = 0 " ;
$vlString = $vlString . " WHERE " . $vecfoto[1] . " = '" . trim($vtCodInmb) . "'" ;
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
fm_query_gen($vlString);
fm_desconect();
}
//*****************************************************
function fm_bus_cant_foto($vtCod)
{
/*---------------*/
$vecfoto[0] = "tbl_foto" ;
$vecfoto[1] = "fot_inmb_cod" ;
/*---------------*/
$vlString = "";
$vlString = $vlString . " SELECT * FROM " . $vecfoto[0] ;
$vlString = $vlString . " WHERE " . $vecfoto[1] . " = '" . trim($vtCod) . "'";
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlResult = fm_query_gen($vlString);
$vlReturn = mysql_num_rows($vlResult);
if(!empty($vlReturn))
{
$vlRetval= $vlReturn;
}else{
$vlRetval = 0 ;
}
return $vlRetval;
}
//*****************************************************
function fm_bus_foto_Ofer($vtStatus)
{
/*---------------*/
$vlString = "";
$vlString = $vlString . " SELECT a.fot_cod, a.fot_nomb, a.fot_inmb_cod, d.zon_desc, c.inmb_transac ";
$vlString = $vlString . " FROM tbl_foto a, tbl_inmb_ubicacion b, tbl_inmueble c , tbl_zona d ";
$vlString = $vlString . " WHERE a.fot_cod >= 1 " ;
$vlString = $vlString . " AND a.fot_inmb_cod = b.inubic_inmb_cod " ;
$vlString = $vlString . " AND a.fot_inmb_cod = c.inmb_cod " ;
$vlString = $vlString . " AND b.inubic_zon_cod = d.zon_cod " ;
$vlString = $vlString . " AND c.inmb_stat_ofer = 1 " ;
//------------
if (!empty($vtStatus))
{
$vlString = $vlString . " AND a.fot_stat= " . trim($vtStatus) . "" ;
}
//------------
//echo " vlString : " . $vlString . "
" ;
//exit();
//------------
$vlQuery = fm_query_gen($vlString);
return $vlQuery;
fm_desconect();
}
//*****************************************************
?>