Упрощаем работу с TV

<?php
/*
	OnBeforeDocFormSave
	OnDocFormSave
	OnResourceTVFormRender
*/

$tvs = array(
	2	=> "image",
	3	=> "city",
	4	=> "company",
	5	=> "email",
);

switch($modx->event->name)
{
	/* >> Рендеринг ТВшек */
	case 'OnResourceTVFormRender':
		
		if( !$document = $modx->getObject('modResource', $resource) )
		{
			$modx->log(xPDO::LOG_LEVEL_ERROR, "Не был получен документ");
			return;
		}
		
		$categories = & $scriptProperties['categories'];
		
		foreach( $categories as $c_id => & $category )
		{
			foreach( $category['tvs'] as & $tv )
			{
				if( array_key_exists($tv->id, $tvs) )
				{
					$q = $modx->newQuery('modTemplateVar');
					$q->select( 'type' );
					$q->where( 'name = "'. $tvs[ $tv->id ] .'"' );
					$tv_type = $modx->getValue( $q->prepare() );
					unset($q);
					
					// >> Рендеринг тэгов
					if( $tv_type == 'tags' )
					{
						$q = $modx->newQuery('modResourceTag');
						$q->select(array(
							"GROUP_CONCAT(distinct tag_id) as tags",
						));
						$q->where(array(
							"resource_id" => $document->id,
						));
						$tags = $modx->getValue($q->prepare());
						$value = str_replace(",", "||", $tags);
						$tv->value = $value;
						$tv->relativeValue = $value;
						$inputForm = $tv->renderInput($document, array('value' => $tv->value));
						$tv->set('formElement', $inputForm);
					}
					// << Рендеринг тэгов
					
					
					// >> Рендеринг строковых ТВшек
					else if(
							$tv_type == 'autotag' ||
							$tv_type == 'tag' ||
							$tv_type == 'image' ||
							$tv_type == 'email' ||
							$tv_type == 'date' ||
							$tv_type == 'option' ||
							$tv_type == 'listbox-multiple' ||
							$tv_type == 'listbox' ||
							$tv_type == 'resourcelist' ||
							$tv_type == 'hidden' ||
							$tv_type == 'text' ||
							$tv_type == 'textarea' ||
							$tv_type == 'richtext' ||
							$tv_type == 'list-multiple-legacy' ||
							$tv_type == 'file' ||
							$tv_type == 'checkbox' ||
							$tv_type == 'number' ||
							$tv_type == 'migx'
					) {
						$tv->value = $document->$tvs[ $tv->id ];
						$tv->relativeValue = $tv->value;
						$inputForm = $tv->renderInput($document, array('value'=> $tv->value));
						$tv->set('formElement', $inputForm);
					}
					// << Рендеринг строковых ТВшек
					
					
					// >> Рендеринг массивных ТВшек
					else if(
							$tv_type == 'listbox-multiple'
					) {
						$tv_value_array = array_map( function($v){ return trim($v,':'); }, explode( '::', $document->$tvs[ $tv->id ] ) );
						$tv->value = $tv_value_array;
						$tv->relativeValue = $tv_value_array;
						$inputForm = $tv->renderInput($document, array('value' => $tv->value));
						$tv->set('formElement', $inputForm);
					}
					// << Рендеринг массивных ТВшек
				}
			}
		}
		
	break;
	/* << Рендеринг ТВшек */
	
	
	/* >> Перед сохранением документа */
	case 'OnBeforeDocFormSave':
		
		if( !$resource = & $scriptProperties['resource'] )
		{
			$modx->log(xPDO::LOG_LEVEL_ERROR, "Не был получен документ");
			return;
		}
		
		// >> получим список id ТВшек, с которыми будем работать
		$i=0;
		$tv_where='';
		foreach( $tvs as $id => $name )
		{
			$tv_where .= !$i ? '' : ' OR ';
			$tv_where .= 'name = "'. $name .'"';
			$i++;
		}
		unset($i); unset($id); unset($name);
		
		$q = $modx->newQuery('modTemplateVar');
		$q->select( 'id, type, name' );
		$q->where( $tv_where );
		$s = $q->prepare();
		$s->execute();
		$tv_rows = $s->fetchAll(PDO::FETCH_ASSOC);
		unset($q); unset($s);
		// << получим список id ТВшек, с которыми будем работать
		
		
		// >> Обрабатываем ТВшки
		foreach( $tv_rows as $tv_row )
		{
			$var = 'tv'. $tv_row['id'];
			
			if( isset( $resource->$var ) )
			{
				// >> теги
				if( $tv_row['type'] == 'tags' )
				{
					$tags = array();
					foreach( (array)$resource->Tags as $tag )
					{
						$tag->active = 0;
						$tags[ $tag->tag_id ] = $tag;
					}
					
					if( !empty($resource->$var) )
					{
						foreach( (array)$resource->$var as $tv_value )
						{
							if( $tv_value )
							{
								if( !empty($tags[ $tv_value ]) )
								{
									$tags[ $tv_value ]->active = 1;
								}
								else {
									$tags[ $tv_value ] = $modx->newObject('modResourceTag', array(
										"tag_id" => $tv_value,
									));
								}
							}
						}
					}
					
					$resource->Tags = $tags;
					
					$tags_ids = array();
					foreach( $resource->Tags as $tag )
					{
						if( $tag->active )
						{
							$tags_ids[] = $tag->tag_id;
						}
					}
					
					$resource->$tv_row['name'] = ( $tags_ids ? implode(",", $tags_ids) : NULL );
				}
				// << теги
				
				
				// >> картинки и другие строковые
				else if($tv_row['type'] == 'autotag' ||
						$tv_row['type'] == 'tag' ||
						$tv_row['type'] == 'image' ||
						$tv_row['type'] == 'email' ||
						$tv_row['type'] == 'date' ||
						$tv_row['type'] == 'option' ||
						$tv_row['type'] == 'listbox' ||
						$tv_row['type'] == 'resourcelist' ||
						$tv_row['type'] == 'hidden' ||
						$tv_row['type'] == 'text' ||
						$tv_row['type'] == 'textarea' ||
						$tv_row['type'] == 'richtext' ||
						$tv_row['type'] == 'file' ||
						$tv_row['type'] == 'number' ||
						$tv_row['type'] == 'migx'
				) {
					//print_r( $resource->$var );
					
					$resource->$tv_row['name'] = $resource->$var;
				}
				// << картинки и другие строковые
				
				
				// >> массивы
				else if($tv_row['type'] == 'listbox-multiple' ||
						$tv_row['type'] == 'list-multiple-legacy' ||
						$tv_row['type'] == 'checkbox'
				) {
					$resource->$tv_row['name'] = ( $resource->$var ? implode("||", $resource->$var) : NULL );
				}
				// << массивы
			}
		}
		// << Обрабатываем ТВшки
		
	break;
	/* << Перед сохранением документа */
	
	
	/* >> Сохранение документа */
	case 'OnDocFormSave':
		
		if( !$resource = & $scriptProperties['resource'] )
		{
			$modx->log(xPDO::LOG_LEVEL_ERROR, "Не был получен документ");
			return;
		}
		
		if($tvs)
		{
			$modx->removeCollection('modTemplateVarResource', array(
				'tmplvarid:in'	=> array_keys($tvs),
				'contentid'		=> $resource->id,
			));
			
			// Сбрасываем автоинкримент
			//$sql = "ALTER TABLE {$tv_table} auto_increment = 1";
			//$modx->prepare($sql)->execute();
		}
		
	break;
	/* << Сохранение документа */
}

<?php
switch ($modx->event->name) {
	case 'OnMODXInit':
		// Загружаем поле vip_time в модель ресурса
		$modx->map['modResource']['fields']['vip_time'] = 0;
		$modx->map['modResource']['fieldMeta']['vip_time'] = array(
			'dbtype' => 'int',
			'precision' => 20,
			'phptype' => 'integer',
			'default' => 0,
		);
		break;
	case 'OnDocFormSave':
		// Сохраняем ТВ в поле таблицы ресурса
		$resource->vip_time = strtotime($resource->getTVValue('vip_time'));
		$resource->save();
	    break;
}

<?php
switch ($modx->event->name) {
	
	case 'OnMODXInit':
		$modx->loadClass('modResource');
		$modx->map['modResource']['fields']['show_on_start'] =
		$modx->map['modResource']['fields']['hide_on_start'] = 
		$modx->map['modResource']['fields']['ticket_rating'] = 0;
		$modx->map['modResource']['fieldMeta']['show_on_start'] =
		$modx->map['modResource']['fieldMeta']['hide_on_start'] = array(
			'dbtype' => 'tinyint',
			'precision' => 1,
			'attributes' => 'unsigned',
			'phptype' => 'boolean',
			'null' => true,
			'default' => 0,
		);
		$modx->map['modResource']['fieldMeta']['ticket_rating'] = array(
			'dbtype' => 'int',
			'precision' => 10,
			'attributes' => '',
			'phptype' => 'int',
			'null' => true,
			'default' => 0,
		);
		break;
		
		case 'OnBeforeDocFormSave':
			$resource->set('show_on_start', !empty($resource->get('tv7')));
			$resource->set('hide_on_start', !empty($resource->get('tv8')));
			break;
		
		case 'OnTicketVote':
			if ($object->class == 'Ticket') {
				if ($ticket = $modx->getObject('Ticket', $object->id)) {
					$properties = $ticket->getProperties('tickets');
					$rating = !empty($properties['rating'])
						? $properties['rating']
						: 0;
					$ticket->set('ticket_rating', $rating + $object->value);
					$ticket->save();
				}
			}
			break;
}

case 'OnTVInputRenderList':
        $modx->event->output($corePath.'elements/tv/input/');
        break;