Creating a mappable database

  • tsortore

    (@tsortore)


    7 years, 5 months ago

    Hello, I am working on an employee portal for my company and need a bit of help getting a feature built.

    1) Admins, my boss and operations managers and I, will have a table of drilling rigs.
    2) They will create a new project, and assign it a rig and location (must be lat/long or assigned lat/longs by directly picking from a map).
    3) Employees, users with BuddyPress profiles, will then select a rig from a drop-down menu when they get on-site.
    a) This could be from their BuddyPress profile but that’s not necessary.
    4) They and others at that location will be displayed in an info window on the map when the pin is clicked.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Joy

    (@joyously)

    7 years, 5 months ago

    That’s not a question, that’s a requirements list.
    Start by searching for plugins that do parts of what you need. Then you can decide to use the ones you find with code you write, or combine the ones you find to do what you want.

    If the data for locations is not used for page display, it should probably be in its own table. WordPress is geared toward showing what’s in the posts table, although using postmeta could work if that’s how your data is needed.
    If each location is a custom post, with a map as image, or lat/long as post meta, then you can use the built-in queries and things for showing them.

    Thread Starter tsortore

    (@tsortore)

    7 years, 5 months ago

    Thanks for the replay, Joy.

    The locations do not need to be displayed anywhere but on the map. I have the database of locations within a table using ‘Participants Database’. But sadly there doesn’t seem to be any compatibility between this table and the user database in BuddyPress without manually editing and code. I’ve done plenty of searching, and decided it was time to reach out to someone more acquainted with WordPress.

    If there is a way to tie a location to a project, and map the projects with the users assigned to the project in the map markers’ infowindows, then this would be an easy task.

    Any help would be wonderful!

    Thanks again.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Creating a mappable database’ is closed to new replies.