1
I’m developing a real estate portal but as it’s the first time I do one, I don’t know exactly how the logic works to achieve the desired result. After plotting a path, I’ll still have to turn it into requisitions SQL.
As can be seen in the image, I have variants for TIPO
, for DORMITORIOS
, for AREA
, for VAGAS
, for VALOR
, for BAIRROS
, for CODIGO
.
Not exactly looking for ready answers, I seek ideas on how to accomplish this task and I am open to increase information according to the doubts found.
Things I already know:
- When typing a
CODIGO
all other fields will be disregarded ... - I think I can start filtering by
VALOR
,AREA
...
It seems that TYPE, DORMITORIOS, AREA, VACANCIES, VALUE and NEIGHBORHOODS are the filters and CODE would be a certain ad. If CODE is reported, disregard filters. I believe filters are optional, so each field can take a value default in case of not being informed and when informed you use the value in QUERY.
– Papa Charlie