Answered MIGXdb passing record property to input option

<?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`]]