Revision Navigation

Revision 235

Date:

2012/08/29 15:03:50

Author:

ahitrov

Revision Log:

aliases

Files:


22	22	[3, 'Системный блог (contenido)'],
23	23	],
24	24	},
	25	{ 'attr' => 'header', 'type' => 'string', 'rusname' => 'HTML-заголовок' },
25	26	{ 'attr' => 'abstr', 'type' => 'wysiwyg', 'rusname' => 'Краткое описание', 'rows' => 10 },
26	27	{ 'attr' => 'icon', 'type' => 'image', 'rusname' => 'Аватар', preview => ['300x300','250x250','200x200','150x150','120x120','100x100','32x32'] },
27	28	)


27	27	_link_filter
28	28	_uid_filter
29	29	_type_filter
	30	_alias_filter
30	31	);
31	32	return \@available_filters;
32	33	}
…	…
50	51	my @parent_properties = $self->SUPER::required_properties;
51	52	return (
52	53	@parent_properties,
	54	{
	55	'attr' => 'alias',
	56	'type' => 'string',
	57	'rusname' => 'Web-алиас',
	58	'db_field' => 'alias',
	59	'db_type' => 'varchar(64)',
	60	},
53	61	{ # Тип блога...
54	62	'attr' => 'type',
55	63	'type' => 'status',
…	…
118	126	return &SQL::Common::_generic_int_filter('d.type', $opts{type});
119	127	}
120	128
	129	sub _alias_filter {
	130	my ($self,%opts)=@_;
	131	return undef unless ( exists $opts{alias} );
	132	return &SQL::Common::_generic_text_filter('d.alias', $opts{alias});
	133	}
121	134
	135
122	136	sub _link_filter {
123	137	my ($self,%opts)=@_;
124	138


52	52	my @parent_properties = $self->SUPER::required_properties;
53	53	return (
54	54	@parent_properties,
	55	{
	56	'attr' => 'alias',
	57	'type' => 'string',
	58	'rusname' => 'Web-алиас',
	59	'db_field' => 'alias',
	60	'db_type' => 'varchar(64)',
	61	},
55	62	{ # Пользователь...
56	63	'attr' => 'uid',
57	64	'type' => 'integer',


9	9	uid integer not null,
10	10	blog_id integer not null,
11	11	sections integer[],
	12	alias varchar(64),
12	13	name text,
13	14	comments integer default 0,
14	15	tags text,
…	…
17	18	create index blog_records_sections on blog_records using gist ( "sections" "gist__int_ops" );
18	19	create index blog_records_dtime on blog_records (dtime);
19	20	create index blog_records_uid on blog_records (uid);
	21	create index blog_records_alias on blog_records (alias) where alias is not null and alias != '';
20	22	create index blog_records_blog_id on blog_records (blog_id);