Help with Nested MIGXdb

44 Posts

tsnekifox Reply #11, 12 years, 2 months ago

Bruno
Thank you so much! I will take a look at this and let you know if I have any questions.

44 Posts

tsnekifox Reply #12, 12 years, 2 months ago

Bruno
This is perfect! I just need to setup my front end templates with Blox and I should be good to go. Again thank you so much! Ill be buying you some beer for sure.

5,888 Posts

Bruno17 Reply #13, 12 years, 2 months ago

you can also just use migxLoopCollection for all the frontend - stuff.
No need to install another package.

pdoResources of the pdoTools - package should also work great.

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

793 Posts

ottogal Reply #14, 12 years, 2 months ago

By the way: What are in general the pros and cons for using migxLoopCollection vs. Blox vs. getImageList...?

5,888 Posts

Bruno17 Reply #15, 12 years, 2 months ago

Quote from: ottogal at Jul 24, 2014, 10:15 AM

By the way: What are in general the pros and cons for using migxLoopCollection vs. Blox vs. getImageList...?

getImageList is only for listing json-arrays, as they come from a MIGX-TV for example.

blox originally was written for EVO and was adapted for Revo-usage.
It is nice for advanced setups, where you have many nested arrays and chunks, for example calendar-views, tree-views, search-forms with many listboxes and where you want to have customizable configurations and customizable getdatas-php-files.
There are really a lot of options, how to set it up.

migxLoopCollection, included with MIGX is much simpler.
There are options for joining, filtering and sorting and you can, of course nest multiple migxLoopCollection-calls into another(which was not that easy possible in EVO), so it should work for most use-cases.

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

793 Posts

ottogal Reply #16, 12 years, 2 months ago

Thanks for the explanation!

44 Posts

tsnekifox Reply #17, 12 years, 2 months ago

Quote from: Bruno17 at Jul 24, 2014, 09:10 AM

you can also just use migxLoopCollection for all the frontend - stuff.
No need to install another package.

pdoResources of the pdoTools - package should also work great.

Bruno
Thanks again for the help on the MIGX side of things. I have just had a chance to get back to this and test things out. How would I go about listing the information for the agenda page. Example code below:

Session Call-

[[!migxLoopCollection?
&packageName=`sriagenda`
&classname=`sriagenda_ses`
&tpl=`main_agenda`
]]

main_agenda -

[[+ses_title]]
<br/>
[[+ses_type]]
<br/>
[[!migxLoopCollection?
&packageName=`sriagenda`
&classname=`sriagenda_spk`
&tpl=`@CODE:[[+spk_fname]] [[+spk_lname]], `
]]
<br/><br/>

Obviously, the code above would list all of the speakers in all of the sessions. How do I go about limiting the speakers to the ones that are assigned to each session?

Thanks!

5,888 Posts

Bruno17 Reply #18, 12 years, 2 months ago

does this work?

[[+ses_title]]
<br/>
[[+ses_type]]
<br/>
[[!migxLoopCollection?
&packageName=`sriagenda`
&classname=`sriagenda_ses_spk`
&joins=`[{"alias":"Speaker"}]`
&where=`{"ses_id":"[[+id]]"}`
&tpl=`@CODE:[[+Speaker_spk_fname]] [[+Speaker_spk_lname]]`
&outputSeparator=`, `
]]
<br/><br/>

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

44 Posts

tsnekifox Reply #19, 12 years, 2 months ago

That worked Bruno! I want to now make the template to be a link now. Would that look something like this?

Note: the Speaker Bio page I created has a resource id of 2

&tpl=`@CODE:<a href="[[~2? &objectID=`[[+Speaker_id]]`]]">[[+Speaker_spk_fname]] [[+Speaker_spk_lname]]</a>`

What would the migxLoopCollection call look like on the bio page? Anything like this?

[[migxLoopCollection?
  &packageName=`sriagenda`
  &classname=`sriagenda_spk`
  &tpl=`@CODE:[[+spk_fname]] [[+spk_lname]]`
  &where=`{"id":"[[!getReqParam? &name=`objectID`]]"}`
]]

5,888 Posts

Bruno17 Reply #20, 12 years, 2 months ago

Quote from: tsnekifox at Jul 28, 2014, 03:40 AM

That worked Bruno! I want to now make the template to be a link now. Would that look something like this?

Note: the Speaker Bio page I created has a resource id of 2
&tpl=`@CODE:<a href="[[~2? &objectID=`[[+Speaker_id]]`]]">[[+Speaker_spk_fname]] [[+Speaker_spk_lname]]</a>`
What would the migxLoopCollection call look like on the bio page? Anything like this?
[[migxLoopCollection?
  &packageName=`sriagenda`
  &classname=`sriagenda_spk`
  &tpl=`@CODE:[[+spk_fname]] [[+spk_lname]]`
  &where=`{"id":"[[!getReqParam? &name=`objectID`]]"}`
]]

this should work, but migxLoopCollection has to be called uncached there:

[[!migxLoopCollection?
  &packageName=`sriagenda`
  &classname=`sriagenda_spk`
  &tpl=`@CODE:[[+spk_fname]] [[+spk_lname]]`
  &where=`{"id":"[[!getReqParam? &name=`objectID`]]"}`
]]

maybe you will need a tpl-chunk here:

&tpl=`tpl_speaker_link`

<a href="[[~2? &objectID=`[[+Speaker_id]]`]]">[[+Speaker_spk_fname]] [[+Speaker_spk_lname]]</a>

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

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

Answered Help with Nested MIGXdb