Document management conundrumn

14 posts by 3 authors in: Forums > CMS Builder
Last Post: January 27, 2015   (RSS)

By claire - January 26, 2015

Hey there - what's the code you're using to select which documents to show on each page?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Hi Claire:  see attached file

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Attachments:

minutes.php 8K

By claire - January 27, 2015

Thanks. It's not clear which table the documents are attached to, however. Can you explain which section has the documents?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - January 27, 2015 - edited: January 27, 2015

Hi Claire:  it's both tables. Minutes_overview for the public files and minutes_rods for the private. 

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 27, 2015

Ah I see. Okay, it might be a problem if the documents are stored in two different sections, and there are multiple documents stored in each record.

Are all the documents for each record all set to the same status?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Claire:  Right now, it works, but if the client wants to publish a document to both public and private, he posts them twice.  I was hoping to merge the 2 tables into one and have a checkbox (public, private, both) which would then allow publication in the appropriate area.  Not sure how I would do this. I have attached both schema definitions.

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 27, 2015

The actual merge could be tricky, but it looks like the fields are the same. Assuming you could get all the records into one table, adding two checkboxes - one for public, one for private - would work fine. All you'd have to do is make a few changes to the logic in the two getRecords calls.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

ok, but how do I add the checkboxes to each file entry?  Would I use info2 & info3??

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 27, 2015

Ah I'm sorry - this isn't going to be possible with checkboxes. You'd have to move the documents into a related records section, or just add 'public' and 'private' to their info fields as needed.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/