@EVAL return $modx->runSnippet('list.lister', array('line'=>`[[+line_id]]`));
This question has been answered by Bruno17. See the first response.
<object class="productLine" table="rli_product_line" extends="xPDOSimpleObject" > <field key="name" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="priority" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default="100"/> <field key="description" dbtype="mediumtext" phptype="string" null="true" default=""/> <field key="disabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="video" dbtype="varchar" precision="255" phptype="string" null="true" default=""/> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="false" /> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="deletedon" dbtype="datetime" phptype="datetime" null="false" /> <field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="publishedon" dbtype="datetime" phptype="datetime" null="false" /> <field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> </object> <object class="productInfo" table="rli_products" extends="xPDOSimpleObject" > <field key="prod_no" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index"/> <field key="options" dbtype="mediumtext" phptype="string" null="true" default=""/> <field key="qty" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default=""/> <field key="so" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default=""/> <field key="so_text" dbtype="varchar" precision="255" phptype="string" null="true" default="" index="index"/> <field key="grp_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="line_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="category" dbtype="varchar" precision="255" phptype="string" null="false" default=""/> <field key="colors" dbtype="varchar" precision="255" phptype="string" null="true" default=""/> <field key="priority" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default="100"/> <field key="disabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="sample" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="sample_qty" dbtype="tinyint" precision="4" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="false" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLine" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="productColorGroups" table="rli_color_groups" extends="xPDOSimpleObject" > <field key="colorgroupname" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="colorgroupvalue" dbtype="mediumtext" phptype="string" null="false" default="" /> <field key="line_id" dbtype="varchar" precision="255" phptype="string" null="true" default=""/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> </object>
<?xml version="1.0" encoding="UTF-8"?> <model package="rhythmcatalog" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1"> <object class="productLine" table="rli_product_line" extends="xPDOSimpleObject" > <field key="name" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="priority" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default="100"/> <field key="description" dbtype="mediumtext" phptype="string" null="true" default=""/> <field key="disabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="video" dbtype="varchar" precision="255" phptype="string" null="true" default=""/> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="false" /> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="deletedon" dbtype="datetime" phptype="datetime" null="false" /> <field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="publishedon" dbtype="datetime" phptype="datetime" null="false" /> <field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <composite alias="ProductColorGroup" class="productLineColorGroup" local="id" foreign="line_id" cardinality="many" owner="local"/> </object> <object class="productGroup" table="rli_product_group" extends="xPDOSimpleObject" > <field key="name" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="description" dbtype="varchar" precision="255" phptype="string" null="true" default="" /> <field key="line_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="image_path" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="disabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="sample_days" dbtype="tinyint" precision="4" attributes="unsigned" phptype="integer" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLineColorGroup" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="productInfo" table="rli_products" extends="xPDOSimpleObject" > <field key="prod_no" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index"/> <field key="options" dbtype="mediumtext" phptype="string" null="true" default=""/> <field key="qty" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default=""/> <field key="so" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default=""/> <field key="so_text" dbtype="varchar" precision="255" phptype="string" null="true" default="" index="index"/> <field key="grp_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="line_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="category" dbtype="varchar" precision="255" phptype="string" null="false" default=""/> <field key="colors" dbtype="tinyinteger" attributes="unsigned" phptype="integer" null="true" default=""/> <field key="priority" dbtype="integer" precision="10" phptype="integer" attributes="unsigned" null="true" default="100"/> <field key="disabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="sample" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="sample_qty" dbtype="tinyint" precision="4" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="false" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLine" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="ProductColor" class="productColorGroup" local="colors" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="ProductGroup" class="productGroup" local="grp_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="productColor" table="rli_colors" extends="xPDOSimpleObject" > <field key="colorname" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="colorvalue" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="basevalue" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="colorgroup" dbtype="integer" precision="1" phptype="integer" attributes="unsigned" null="false" default="0"/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> </object> <object class="productColorGroup" table="rli_color_groups" extends="xPDOSimpleObject" > <field key="colorgroupname" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="colorgroupvalue" dbtype="mediumtext" phptype="string" null="false" default="" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <composite alias="ProductLineColorGroup" class="productLineColorGroup" local="id" foreign="cg_id" cardinality="many" owner="local"/> </object> <object class="productCategory" table="rli_categories" extends="xPDOSimpleObject" > <field key="name" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" /> <field key="value" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="description" dbtype="varchar" precision="255" phptype="string" null="true" default="" /> <field key="line_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLine" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="productLineColorGroup" table="rli_line_cg_opts" extends="xPDOSimpleObject" > <field key="cg_id" dbtype="tinyint" phptype="integer" attributes="unsigned" null="false" default="0"/> <field key="line_id" dbtype="tinyint" phptype="integer" attributes="unsigned" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLine" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="ProductColorGroup" class="productColorGroup" local="cg_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="productLineOptions" table="rli_product_line_opts" extends="xPDOSimpleObject" > <field key="line_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="opt_id" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="ProductLine" class="productLine" local="line_id" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="ProductOption" class="productColorGroups" local="opt_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="customProduct" table="rli_custom_products" extends="xPDOSimpleObject" > <field key="pkg_id" dbtype="integer" precision="5" phptype="integer" attributes="unsigned" null="false" default=""/> <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default=""/> <field key="description" dbtype="mediumtext" phptype="string" null="false" default=""/> <field key="colors" dbtype="mediumtext" phptype="string" null="false" default=""/> <field key="options" dbtype="mediumtext" phptype="string" null="true" default=""/> <field key="qty" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> <aggregate alias="CustomKit" class="customKit" local="pkg_id" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="customKit" table="rli_custom_kits" extends="xPDOSimpleObject" > <field key="pkg_name" dbtype="varchar" precision="255" phptype="string" null="false" default=""/> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="id" collation="A" null="false" /> </index> </object> </model>
<?php $object_id = $this->modx->getOption('object_id',$_REQUEST,0); //let us get only products, which belong to the current productline $this->customconfigs['getlistwhere']='{"line_id":"'.$object_id.'"}';
<?php $config = $modx->migx->customconfigs; $prefix = isset($config['prefix']) && !empty($config['prefix']) ? $config['prefix'] : null; $object_id = 'new'; if (isset($config['use_custom_prefix']) && !empty($config['use_custom_prefix'])) { $prefix = isset($config['prefix']) ? $config['prefix'] : ''; } $packageName = $config['packageName']; $sender = 'default/fields'; $packagepath = $modx->getOption('core_path') . 'components/' . $packageName . '/'; $modelpath = $packagepath . 'model/'; if (is_dir($modelpath)){ $modx->addPackage($packageName, $modelpath, $prefix); } $classname = $config['classname']; $joinalias = isset($config['join_alias']) ? $config['join_alias'] : ''; $joins = isset($config['joins']) && !empty($config['joins']) ? $modx->fromJson($config['joins']) : false; if (!empty($joinalias)) { if ($fkMeta = $modx->getFKDefinition($classname, $joinalias)) { $joinclass = $fkMeta['class']; } else { $joinalias = ''; } } if ($this->modx->lexicon) { $this->modx->lexicon->load($packageName . ':default'); } $line_id = $modx->getOption('co_id',$scriptProperties,0); if (empty($scriptProperties['object_id']) || $scriptProperties['object_id'] == 'new') { if ($object = $modx->newObject($classname)){ $object->set('object_id', 'new'); //set current line-id, if new product $object->set('line_id',$line_id); } } else { $c = $modx->newQuery($classname, $scriptProperties['object_id']); $pk = $modx->getPK($classname); $c->select(' `' . $classname . '`.*, `' . $classname . '`.`' . $pk . '` AS `object_id` '); if (!empty($joinalias)) { $c->leftjoin($joinclass, $joinalias); $c->select($modx->getSelectColumns($joinclass, $joinalias, 'Joined_')); } if ($joins) { $modx->migx->prepareJoins($classname, $joins, $c); } if ($object = $modx->getObject($classname, $c)){ $object_id = $object->get('id'); } } $_SESSION['migxWorkingObjectid'] = $object_id; //handle json fields if ($object){ $record = $object->toArray(); } else{ $record = array(); } foreach ($record as $field => $fieldvalue) { if (!empty($fieldvalue) && is_array($fieldvalue)) { foreach ($fieldvalue as $key => $value) { $record[$field . '.' . $key] = $value; } } }
<?php $query = $modx->getOption('query', $scriptProperties, ''); $tv = $modx->getObject('modTemplateVar', array('name' => $scriptProperties['tvname'])); $inputProperties = $tv->get('input_properties'); $modx->lexicon->load('tv_widget', 'dynamicdropdowntv:inputoptions'); $lang = $modx->lexicon->fetch('dynamicdropdowntv.', TRUE); $firstText = $modx->getOption('firstText', $inputProperties, $lang['firstText_default'], TRUE); $packageName = 'rhythmcatalog'; $packagepath = $modx->getOption('core_path') . 'components/' . $packageName . '/'; $modelpath = $packagepath . 'model/'; $modx->addPackage($packageName, $modelpath); $classname = 'productLine'; $c = $modx->newQuery($classname); $options = array(); $count = 1; if (!empty($query)) { $c->where(array('name:LIKE' => $query . '%')); } else { $options[] = array('id' => '', 'name' => $firstText); } //$c->where(array('parent' => '0')); //$c->prepare();echo $c->toSql(); if ($collection = $modx->getCollection($classname, $c)) { $count += $modx->getCount($classname); foreach ($collection as $object) { $option['id'] = $object->get('id'); $option['name'] = $object->get('name'); $rows[strtolower($option['name'])] = $option; } ksort($rows); foreach ($rows as $option) { $options[] = $option; } } return $this->outputArray($options, $count);
<?php $query = $modx->getOption('query', $scriptProperties, ''); $line_id = $modx->getOption('productlines',$scriptProperties,0); $tv = $modx->getObject('modTemplateVar', array('name' => $scriptProperties['tvname'])); $inputProperties = $tv->get('input_properties'); $modx->lexicon->load('tv_widget', 'dynamicdropdowntv:inputoptions'); $lang = $modx->lexicon->fetch('dynamicdropdowntv.', TRUE); $firstText = $modx->getOption('firstText', $inputProperties, $lang['firstText_default'], TRUE); $packageName = 'rhythmcatalog'; $packagepath = $modx->getOption('core_path') . 'components/' . $packageName . '/'; $modelpath = $packagepath . 'model/'; $modx->addPackage($packageName, $modelpath); $classname = 'productGroup'; $c = $modx->newQuery($classname); $options = array(); $count = 1; if (!empty($query)) { $c->where(array('name:LIKE' => $query . '%')); } else { $options[] = array('id' => '', 'name' => $firstText); } $c->where(array('line_id' => $line_id)); //$c->prepare();echo $c->toSql(); if ($collection = $modx->getCollection($classname, $c)) { $count += $modx->getCount($classname); foreach ($collection as $object) { $option['id'] = $object->get('id'); $option['name'] = $object->get('name'); $rows[strtolower($option['name'])] = $option; } ksort($rows); foreach ($rows as $option) { $options[] = $option; } } return $this->outputArray($options, $count);
<?php //@EVAL return $modx->runSnippet('list.lister', array('useid'=>'1', 'class'=>'productColorGroups','nameField'=>'colorgroupname')); $query = $modx->getOption('query', $scriptProperties, ''); $group_id = $modx->getOption('productgroups',$scriptProperties,0); $line_id = $modx->getOption('productlines',$scriptProperties,0); $tv = $modx->getObject('modTemplateVar', array('name' => $scriptProperties['tvname'])); $inputProperties = $tv->get('input_properties'); $modx->lexicon->load('tv_widget', 'dynamicdropdowntv:inputoptions'); $lang = $modx->lexicon->fetch('dynamicdropdowntv.', TRUE); $firstText = $modx->getOption('firstText', $inputProperties, $lang['firstText_default'], TRUE); $packageName = 'rhythmcatalog'; $packagepath = $modx->getOption('core_path') . 'components/' . $packageName . '/'; $modelpath = $packagepath . 'model/'; $modx->addPackage($packageName, $modelpath); $classname = 'productColorGroup';//here I'm not sure which class you want select from, $c = $modx->newQuery($classname); //may be you will need to join here to some other table, needs to be figured out $options = array(); $count = 1; if (!empty($query)) { $c->where(array('colorgroupname:LIKE' => $query . '%')); } else { $options[] = array('id' => '', 'name' => $firstText); } $c->where(array('cg_id' => $group_id));//this needs to be figured out //$c->prepare();echo $c->toSql(); if ($collection = $modx->getCollection($classname, $c)) { $count += $modx->getCount($classname); foreach ($collection as $object) { $option['id'] = $object->get('id'); $option['name'] = $object->get('colorgroupname'); $rows[strtolower($option['name'])] = $option; } ksort($rows); foreach ($rows as $option) { $options[] = $option; } } return $this->outputArray($options, $count);
{ "formtabs":[ { "MIGX_id":1, "caption":"Product Info", "print_before_tabs":"0", "fields":[ { "MIGX_id":1, "field":"prod_no", "caption":"Product Number", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":2, "field":"line_id", "caption":"Belongs to Product Line:", "description":"", "description_is_code":"0", "inputTV":"productlines", "inputTVtype":"", "validation":"required", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":3, "field":"grp_id", "caption":"Product Group", "description":"", "description_is_code":"0", "inputTV":"productgroups", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":10, "field":"colors", "caption":"Color Group", "description":"", "description_is_code":"0", "inputTV":"colorgroups", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":5, "field":"category", "caption":"Product Category", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"listbox", "validation":"required", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"@EVAL return 'select one==||' . $modx->runSnippet('migxLoopCollection', array('classname'=>'productCategory','tpl'=>'@CODE:[[+name]]==[[+id]]','outputSeparator'=>'||'));", "default":"" }, { "MIGX_id":4, "field":"options", "caption":"Product Specifications", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"migx", "validation":"", "configs":"Options", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":7, "field":"qty", "caption":"Quantity", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"number", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":8, "field":"id", "caption":"", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"none", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" } ] }, { "MIGX_id":2, "caption":"Additional Product Settings", "print_before_tabs":"0", "fields":[ { "MIGX_id":1, "field":"sample", "caption":"Sample Available?", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"listbox", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"No==0||Yes==1", "default":"0" }, { "MIGX_id":2, "field":"sample_qty", "caption":"How many can be ordered?", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"0" }, { "MIGX_id":3, "field":"so", "caption":"Is this a special order item?", "description":"", "description_is_code":"0", "inputTV":"yes-no-list", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"0" }, { "MIGX_id":11, "field":"so_text", "caption":"Special Order Text", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"", "default":"" }, { "MIGX_id":10, "field":"disabled", "caption":"Hide This Product?", "description":"", "description_is_code":"0", "inputTV":"", "inputTVtype":"listbox", "validation":"", "configs":"", "restrictive_condition":"", "display":"", "sourceFrom":"config", "sources":"[]", "inputOptionValues":"No==0||Yes==1", "default":"0" } ] } ], "contextmenus":"update||duplicate||remove", "actionbuttons":"addItem", "columnbuttons":"update||duplicate||remove", "filters":[ { "MIGX_id":1, "name":"search", "label":"Product Search", "emptytext":"", "type":"textbox", "getlistwhere":{ "prod_no:LIKE":"%[[+search]]%", "OR:options:LIKE":"%[[+search]]%" }, "getcomboprocessor":"", "combotextfield":"", "comboidfield":"", "comboparent":"", "default":"" } ], "extended":{ "migx_add":"Add Product", "formcaption":"Product Manager", "update_win_title":"", "win_id":"ProductList", "maxRecords":"", "addNewItemAt":"bottom", "multiple_formtabs":"", "actionbuttonsperrow":4, "winbuttonslist":"", "extrahandlers":"this.duplicate", "filtersperrow":4, "packageName":"rhythmcatalog", "classname":"productInfo", "task":"products", "getlistsort":"prod_no", "getlistsortdir":"", "use_custom_prefix":"0", "prefix":"", "grid":"", "gridload_mode":2, "check_resid":"0", "check_resid_TV":"", "join_alias":"", "has_jointable":"no", "getlistwhere":"", "joins":[ { "alias":"ProductLine" } ], "cmpmaincaption":"", "cmptabcaption":"Product Listing", "cmptabdescription":"This is a listing of all products in the Rhythmlink database", "cmptabcontroller":"", "winbuttons":"", "onsubmitsuccess":"", "submitparams":"" }, "columns":[ { "MIGX_id":1, "header":"id", "dataIndex":"id", "width":"", "sortable":"false", "show_in_grid":"0", "renderer":"", "clickaction":"", "selectorconfig":"", "renderchunktpl":"", "renderoptions":"[]" }, { "MIGX_id":3, "header":"Product Number", "dataIndex":"prod_no", "width":"", "sortable":true, "show_in_grid":1, "renderer":"this.renderRowActions", "clickaction":"selectFromGrid", "selectorconfig":"", "renderchunktpl":"", "renderoptions":"[]" } ] }
[[+id:is=``:then=`1`:else=`0`]]