spider/database/col.php

<?php

# 定义几个常用的选项
$option = array
(
	1 => '正常',
	2 => '删除',
);
return array
(
	# 表名
	'name' => 'col',
	# 显示给用户看的名称
	'lang' => '采集字段管理',
	'menu' => false,
	# 后台菜单排序
	'order' => 6,
	'desc' => '字段唯一标识符：如果用逗号隔开，则前面的是dever公共函数，如maketime.date，则会调用Dever::maketime()来处理date的数据
	<br />
	<a href="'.Dever::url('spider/lib/api.test?id=' . Dever::input('search_option_project_id', -1)).'" target="_blank">点此进行测试</a>：请按住ctrl打开新页面并查看源代码',
	# 数据结构
	'struct' => array
	(
	
		'id' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> 'ID',
			'default' 	=> '',
			'desc' 		=> '',
			'match' 	=> 'is_numeric',
			'search'	=> 'order',
			'list'		=> true,
			'order'		=> 'desc',
		),

		'name'		=> array
		(
			'type' 		=> 'varchar-100',
			'name' 		=> '字段名称',
			'default' 	=> '',
			'desc' 		=> '字段名称',
			'match' 	=> 'is_string',
			'update'	=> 'text',
			'search'	=> 'fulltext',
			'list'		=> true,
			'edit'		=> true,
		),

		'key'		=> array
		(
			'type' 		=> 'varchar-100',
			'name' 		=> '字段唯一标识符',
			'default' 	=> '',
			'desc' 		=> '字段唯一标识符',
			'match' 	=> 'is_string',
			'update'	=> 'text',
			'search'	=> 'fulltext',
			'list'		=> true,
			'edit'		=> true,
		),

		'project_id'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '项目id',
			'default' 	=> Dever::input('search_option_project_id', -1),
			'desc' 		=> '请选择项目id',
			'match' 	=> 'is_numeric',
			'search'	=> 'order',
			'update'	=> 'hidden',
		),
		
		'collect_rule'		=> array
		(
			'type' 		=> 'varchar-500',
			'name' 		=> '采集规则-支持dom解析、正则',
			'default' 	=> '',
			'desc' 		=> '采集规则',
			'match' 	=> 'is_string',
			'update'	=> 'textarea',
			'list'		=> true,
			'edit'		=> 'textarea',
		),

		'collect_include'		=> array
		(
			'type' 		=> 'varchar-500',
			'name' 		=> '包含字符-如果填写该项，则进一步过滤，只保留包含有该字符的',
			'default' 	=> '',
			'desc' 		=> '采集规则',
			'match' 	=> 'option',
			'update'	=> 'textarea',
		),

		'collect_exclude'		=> array
		(
			'type' 		=> 'varchar-500',
			'name' 		=> '不包含字符-如果填写该项，则进一步过滤，只保留不包含有该字符的',
			'default' 	=> '',
			'desc' 		=> '采集规则',
			'match' 	=> 'option',
			'update'	=> 'textarea',
		),

		'collect_filter'		=> array
		(
			'type' 		=> 'varchar-500',
			'name' 		=> '过滤规则-如果填写该项，则过滤掉符合该规则的字符，仅支持字符串和正则',
			'default' 	=> '',
			'desc' 		=> '采集规则',
			'match' 	=> 'option',
			'update'	=> 'textarea',
		),

		'state'		=> array
		(
			'type' 		=> 'tinyint-1',
			'name' 		=> '数据状态',
			'default' 	=> '1',
			'desc' 		=> '请选择状态',
			'match' 	=> 'is_numeric',
		),
		
		'cdate'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '录入时间',
			'match' 	=> array('is_numeric', time()),
			'desc' 		=> '',
			# 只有insert时才生效
			'insert'	=> true,
			'list'		=> 'date("Y-m-d H:i:s", {cdate})',
		),
	),

	'request' => array
	(
		'getList' => array
		(
			'where' => array
			(
				'project_id' => 'yes',
				'state' => 1,
			),
			'type' => 'all',
			'order' => array
			(
				'id' => 'desc',
			),
			'col' => '*|key',
		),
	)
);