[Resuelto] Advice on setting up Post Relationships

[Autor]

Mensajes

[Craig]

I am just about to try and set up some Custom Post Types for an upcoming project and was looking for some advice on how best to set up the relationships…

There will be the following CPTs (required fields in parentheses):

Housing Personnel (Name, Email Address, Telephone, Locations)
Maintenance Personnel (Name, Email Address, Telephone, Locations)
Support Personnel (Name, Email Address, Telephone, Locations)

Each of the above CPTs should be able to be assigned multiple locations.

The following will also be required for displaying on a Google Map with Clustering

Housing Locations (Name, Address, Weblink)

Any thoughts on the best way to set this up?

[Shane Supporter Languages: Inglés (English ) Timezone: America/Jamaica (GMT-05:00)]

Hi Craig,

Thank you for contacting our support forum.

So i understand what you are trying to do but not sure how these posts are actually related to each other.

Could you explain a bit further on the relationship between them?

Thanks,
Shane

[Craig]

Hi Shane,

Thanks for replying. OK, let me try to explain in more detail…

Housing Personnel, Maintenance Personnel and Support Personnel will all have at least one 'Housing location' assigned to them, but sometimes more than one.

Each 'Housing Location' will be a town name which will be displayed on a separate Google map and will also be selectable via dropdown menu. There may also be multiple 'Housing Location's per town.

e.g.
Joe Bloggs, Housing Officer covers Town A, Town B and Town C.
John Doe, Maintenance Officer covers Town A.
Mary Smith, Support Officer covers Town C.
Jane Doe, Support Officer covers Town A and Town B.

If someone searched for Town A, the result would list Joe Bloggs, John Doe & Jane Doe (with their contact details).
If someone searched for Town C, the result would list Joe Bloggs & Mary Smith (with their contact details).

The Map would be used show the locations of all the available Housing (clustered where there are many locations in close vicinity).

I hope that explains things a bit better. If not, let me know and I'll try an visualise it.

Kind regards,
Craig

[Shane Supporter Languages: Inglés (English ) Timezone: America/Jamaica (GMT-05:00)]

Hi Craig,

Thank you for clearing this up for me.

So what I suggest is that you have a single post called Towns, then for towns you will have
Housing Personnel
Maintenance Personnel
Support Personnel

Being parents of that towns custom post type. Then you can add the map field to towns.

Please let me know if this helps.
Thanks,
Shane

[Craig]

Hi Shane,

Thank you for your input, I shall give this a try and follow-up if I need any further help.

Kind regards,
Craig