Re: Views filter rooms by occupacy

--===============5238336559173505970==
Content-Type: multipart/alternative; boundary=f46d041c408e25f33b050d0286f2

--f46d041c408e25f33b050d0286f2
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I would be happy to write back latter with more support on a views query as
those criteria should not be to bad but in the mean time you might want to
look at http://www.drupalrooms.com.

-Steve

On Monday, January 19, 2015, Llu=C3=ADs Forns <[email protected]> wrote:

> I have a site with 2 content types: rooms and reservations. I want to lis=
t
> all the rooms without a reservation for an interval, and also for service=
s,
> capacity, ....
>
> I tried creating a view with a PHP filter to check free rooms, but then i=
f
> the page lists 10 rooms, sometimes there are 7, 2, or 0; because the filt=
er
> lists the 10 rooms and after remove the occupied ones.
>
> I have tried to create a "subview" filter to select nodes "not in (view o=
f
> occupied rooms); but I haven't find a way to do so.
>
> Any idea of how to accomplish this?
>
> thanks
> --
> *Ser freak no =C3=A9s imprescindible per ser inform=C3=A0tic, per=C3=B2 a=
juda.
>


--=20
Steve Kessler
Owner and Lead Consultant
Denver DataMan, LLC
303-587-4428

--f46d041c408e25f33b050d0286f2
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I would be happy to write back latter with more support on a views query as=
 those criteria should not be to bad but in the mean time you might want to=
 look at=C2=A0<a href=3D"http://www.drupalrooms.com">http://www.drupalrooms=
.com</a>.<div><br></div><div>-Steve=C2=A0<span></span><br><br>On Monday, Ja=
nuary 19, 2015, Llu=C3=ADs Forns &lt;<a href=3D"mailto:[email protected]">en=
[email protected]</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D=
"ltr"><div>I have a site with 2 content types: rooms and reservations. I wa=
nt to list all the rooms without a reservation for an interval, and also fo=
r services, capacity, ....<br></div><div><br></div><div>I tried creating a =
view with a PHP filter to check free rooms, but then if the page lists 10 r=
ooms, sometimes there are 7, 2, or 0; because the filter lists the 10 rooms=
 and after remove the occupied ones.<br clear=3D"all"><div><br></div><div>I=
 have tried to create a &quot;subview&quot; filter to select nodes &quot;no=
t in (view of occupied rooms); but I haven&#39;t find a way to do so.</div>=
<div><br></div><div>Any idea of how to accomplish this?</div><div><br></div=
><div>thanks</div>-- <br><div>*Ser freak no =C3=A9s imprescindible per ser =
inform=C3=A0tic, per=C3=B2 ajuda.<br></div>
</div></div>
</blockquote></div><br><br>-- <br>Steve Kessler<div>Owner and Lead Consulta=
nt=C2=A0</div><div>Denver DataMan, LLC=C2=A0</div><div>303-587-4428</div><b=
r>

--f46d041c408e25f33b050d0286f2--

--===============5238336559173505970==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-- 
[ Drupal support list | http://lists.drupal.org/ ]
--===============5238336559173505970==--