IF or Modifiers - targeting the various options in a checkbox TV

nick0

Hello,

Just wondering if someone can please help me on the correct "operator" / approach for an IF or Modifiers call when targeting the various options in a checkbox TV.

(This is in an Evo 1.4.15 site)

I can't get my IF or Modifier calls to work (either direct in a template or in a DocLister call) - I presume because when I select multiple options, the answer changes - I am obviously using the wrong "operator" to check when the condition is met. In IF I am trying inarray, in_array, in, is, = all without success.

I guess I am looking for something like the equivalent of DocLister's containsOne filter parameter.

This is the scenario...

I have a checkbox TV with 10 options.
Each option has a single corresponding Alphabetical letter for a code. For simplicity sake let's presume it is
A,B,C,D,E,F,G,H,I,J
I need to assign a score to each option: for each option that is checked give a score of 1, else give 0 (that is the default score and should apply to all unchecked options).
I need to be able to output the score directly on a template, and also within a DocLister menu.

Anticipated usage is something like this where I return the relevant score per each option...

[[if? &is=`[*my-codes*]:is:A` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:B` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:C` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:D` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:E` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:F` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:G` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:H` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:I` &then=`1` &else=`0`]]
[[if? &is=`[*my-codes*]:is:J` &then=`1` &else=`0`]]

These return 1 true if only option A is checked...

1: [[if? &is=`[*my-codes*]:inarray:A` &then=`1 true` &else=`0 false`]]
2: [[if? &is=`[*my-codes*]:in_array:A` &then=`1 true` &else=`0 false`]]
3: [[if? &is=`[*my-codes*]:in:A` &then=`1 true` &else=`0 false`]]
4: [[if? &is=`[*my-codes*]:is:A` &then=`1 true` &else=`0 false`]]
5: [[if? &is=`[*my-codes*]:=:A` &then=`1 true` &else=`0 false`]]

These always return 0 false when multiple various options, including A, are checked...

1: [[if? &is=`[*my-codes*]:inarray:A` &then=`1 true` &else=`0 false`]]
2: [[if? &is=`[*my-codes*]:in_array:A` &then=`1 true` &else=`0 false`]]
3: [[if? &is=`[*my-codes*]:in:A` &then=`1 true` &else=`0 false`]]
4: [[if? &is=`[*my-codes*]:is:A` &then=`1 true` &else=`0 false`]]
5: [[if? &is=`[*my-codes*]:=:A` &then=`1 true` &else=`0 false`]]

If I select A,C,E and use the following, it returns 1 true but that is obviously not what I need nor sustainable with so many combinations available 😆 ...

[[if? &is=`[*my-codes*]:is:A,C,E` &then=`1 true` &else=`0 false`]]

Any ideas on the correct operator / approach for TVs with checkbox options in this scenario?

Thanks in advance for any help.

modxuser

It would probably be easier to put a "picture" up for this - a mockup in photoshop etc.

That way it makes it easier to actualy see what you are trying to render in the front end

At the moment, reading this I am presuming you want to render all of the boxes that are checked in the TV

If that is so, then the "inarray" would be my choice, simply because it compares the boxes against the choices and then renders them - or am I completely on wrong lines here ?

nick0

modxuser It would probably be easier to put a "picture" up for this - a mockup in photoshop etc.

That way it makes it easier to actualy see what you are trying to render in the front end

At the moment, reading this I am presuming you want to render all of the boxes that are checked in the TV

If that is so, then the "inarray" would be my choice, simply because it compares the boxes against the choices and then renders them - or am I completely on wrong lines here ?

It's for the scoring in a Personality Style Quiz (lots of detail in the first post of this thread) - there's a screencap of an excel sheet that shows a picture of the scoring.

Basically I just need to Output lots of 1's and 0's for the Quiz scoring - literally just 1's for checked and 0's for unchecked.

I thought that would be the easy part of the project, just missing the right operator in IF / Modifiers I think for multiple option checkboxes - but I can't get the If Else calls to work per above.

BBloke

I think the inarray logic needs the parameters reversing.
Try:

[[if? &is=`A:inarray:[*my-codes*]` &then=`1 true` &else=`0 false`]]

modxuser

nick0

I think the logic from BarnsleyBloke is the way to go

Do you want to create a call for all of the letters in the alphabet or 26 individual calls

nick0

BarnsleyBloke I think the inarray logic needs the parameters reversing.
Try:
[[if? &is=A:inarray:[*my-codes*] &then=1 &else=0]]

Nailed it - nice one! Thanks so much BarnsleyBloke 😄 .

(I removed the true and false below as that was just for testing.)

This works perfectly directly in the template...

[[if? &is=`A:inarray:[*my-codes*]` &then=`1` &else=`0`]]

This works perfectly in the DocLister row template chunk...

[[if? &is=`A:inarray:[+my-codes+]` &then=`1` &else=`0`]]

You beauty.

I had the opposite hehe - much more logical order with how BarnsleyBloke put it.
I have been getting the odd quirky result with checkbox tvs for years - will be using the opposite to my opposite moving forward 😆 .

Confirming that these 3 all work:

[[if? &is=`A:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`A:inarray:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`A:in_array:[*my-codes*]` &then=`1` &else=`0`]]

I need to return a score for each letter so using one call for each- eg:

[[if? &is=`A:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`B:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`C:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`D:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`E:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`F:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`G:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`H:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`I:in:[*my-codes*]` &then=`1` &else=`0`]]
[[if? &is=`J:in:[*my-codes*]` &then=`1` &else=`0`]]

with output like...
1
1
1
0
1
0
0
0
1
0

Many, many thanks @BarnsleyBloke 😀 .

nick0

modxuser nick0

I think the logic from BarnsleyBloke is the way to go

Do you want to create a call for all of the letters in the alphabet or 26 individual calls

One for all 10.

BBloke

Alternative would be:

You could always try a custom bit of code. That way you could write one line and total up the results and output as needed.

Create a file in assets/snippets/custom called if.myArray.php with the following contents:

<?php
// Subject must be in the form of input||output
// Input is what you have to check
// output is what you are matching against

function myArray($subject, $operand) {
	$modx = EvolutionCMS();
	
	$i = 0;
	$data = explode("||", $subject);
	
	// data[0] is input
	// data[1] is output
	
	$output = explode(",", $data[1]);
	
	foreach ( $output as $check )
	{
	    if ( in_array($check, explode(",", $data[0])) )
	    {
	    	$i++;
	    }
	}
    
    $modx->setPlaceholder("myArrayResult", $i);
    return $i;
}

Make your snippet call:

[[if? &is=`[*my-codes*]||A,B,C,D,E,F,G,H:myArray` &custom=`myArray` &then=`[+myArrayResult+]`]]

You are passing the TV into the program and checking to see if any of the TVs match against the second list.

If you TV was A,F,G then it would check each A,B,C,D,E,F,G,H and say that 3 match.

nick0

BarnsleyBloke Alternative would be:

You could always try a custom bit of code. That way you could write one line and total up the results and output as needed.

Create a file in assets/snippets/custom called if.myArray.php with the following contents:

Great alternative, Thanks BarnsleyBloke
I haven't tested your snippet approach as your first simpler order changing did the trick but have bookmarked it for future use. Many thanks

modxuser

[!if? &is=`[*my-codes*]:in:A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z` &then=`1 true` &else=`0 false`!]

[!if? &is=`A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z:in:[*my-codes*]` &then=`1 true` &else=`0 false`!]

Not identical, but similar:
https://forums.modx.com/thread/80876/snippet-if-for-modx-evo#dis-post-481755

nick0

modxuser Not identical, but similar:
https://forums.modx.com/thread/80876/snippet-if-for-modx-evo#dis-post-481755

Agreed, very similar. Thanks - bookmarked for future use.
In my usage it seems to only work in the order A:in:[*tv*] rather than [*tv*]:in:A

modxuser

nick0

Out of interest, what would happen if you use the following:

[!if? &is=`A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z:in:[*my-codes*]` &then=`1` &else=`0`!]

Does that just output one single "1" or one single "0" ?

nick0

modxuser Out of interest, what would happen if you use the following:

[!if? &is=A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z:in:[*my-codes*] &then=1 &else=0!]

Does that just output one single "1" or one single "0" ?

That returns one single "0" - all options would need to be checked to match it.

[!if? &is=`A:or:B:or:C:or:D:or:E:or:F:or:G:or:H:or:I:or:J:or:K:or:L:or:M:or:N:or:O:or:P:or:Q:or:R:or:S:or:T:or:U:or:V:or:W:or:X:or:Y:or:Z:in:[*my-codes*]` &then=`1` &else=`0`!]

This alternative returns one single "1" - only one of the options would need to be checked to match it.

modxuser

nick0

Thanks for confirming that - I thought that that would happen 🙂

Glad you got everything working

nick0

Thanks for all the help. Greatly appreciate it.

BBloke

@nick0 No problem.

Here's something a little more dynamic.

Create a file in if/custom called if.myArrayCheckbox.php with the following code:

<?php
// Subject must be a valid TV name that is active in the template of the document

function myArrayCheckbox ($subject, $operand) {
	$modx = EvolutionCMS();

	$i = 0;
	
	$data = $modx->getTemplateVarOutput($subject);
	$data[0] = $data[$subject];

	$tv = $modx->getTemplateVar($subject);
	$tvValues = $tv['elements'];	
	$tvResults = explode("||", $tvValues);

	foreach ( $tvResults as $tvVal )
	{
		//echo $tvKey. $tvVal;
		if ( strpos($tvVal, "==") ) 
		{
			$val = explode("==", $tvVal);
			$values[] = $val[1];
		} else {
			$values[] = $tvVal;
		}
	}

	$output = explode(",", $data[0]);
	
	foreach ( $output as $check )
	{
	    if ( in_array($check, $values) )
	    {
	    	$i++;
	    }
	}
    
    $modx->setPlaceholder("myArrayCheckboxResult", $i);
    return $i;
}

Make your snippet call:

[[if? &is=`checkbox:myArrayCheckbox` &custom=`myArrayCheckbox` &then=`[+myArrayCheckboxResult+]` ]]

This will return the number of matches from the TV input options and choosen TV document output. Works with either long or short format input options even if they are mixed.

Sorry for the long winded code. It's akin to the way my brain works most of the time. Gets the job done though.

BBloke

for posterity: https://github.com/BBloke/CustomIFs

nick0

Nice. Thanks so much.
I can't wait to try it.
Please excuse my ignorance... In your example, which is the name of the TV? Is it checkbox??

[[if? &is=`checkbox:myArrayCheckbox` &custom=`myArrayCheckbox` &then=`Matched [+myArrayCheckboxResult+] Results` ]]

Sorry if a silly question (will probably facepalm when you say the answer)

BBloke

I thought about that this morning. checkbox is the TVname.

[[if? &is=`{TVName}:myArrayCheckbox` &custom=`myArrayCheckbox` &then=`Matched [+myArrayCheckboxResult+] Results` ]]

nick0

BarnsleyBloke I thought about that this morning. checkbox is the TVname.

[[if? &is={TVName}:myArrayCheckbox &custom=myArrayCheckbox &then=Matched [+myArrayCheckboxResult+] Results ]]

That's really interesting. Thanks for sharing. It works and says "Matched 7 results" on my test page, which matches the 7 x 1's return for that page using the std IF calls from above. Not sure how I would use this custom script in the project but interesting to have a look. Thanks BB