id: 20 name: migxChunklistToJson category: MIGX properties: 'a:0:{}' ----- $category = $modx->getOption('category', $scriptProperties, ''); $format = $modx->getOption('format', $scriptProperties, 'json'); $classname = 'modChunk'; $rows = array(); $output = ''; $c = $modx->newQuery($classname); $c->select($modx->getSelectColumns($classname, $classname, '', array('id', 'name'))); $c->sortby('name'); if (!empty($category)) { $c->where(array('category' => $category)); } //$c->prepare();echo $c->toSql(); if ($collection = $modx->getCollection($classname, $c)) { $i = 0; switch ($format) { case 'json': foreach ($collection as $object) { $row['MIGX_id'] = (string )$i; $row['name'] = $object->get('name'); $row['selected'] = '0'; $rows[] = $row; $i++; } $output = $modx->toJson($rows); break; case 'optionlist': foreach ($collection as $object) { $rows[] = $object->get('name'); $i++; } $output = implode('||',$rows); break; } } return $output;