account/database/info.php

<?php
$config = function()
{
	$array = array();
	$info = Dever::db('account/config')->state();
	if($info)
	{
		$array += $info;
	}
	return $array;
};

$project = function()
{
	$array = array();
	$data = Dever::load('account/config_project-state');
	if($data)
	{
		$array += $data;
	}
	return $array;
};

$user = '用户ID';
$search = 'fulltext';

$config_id = Dever::input('search_option_config_id');
if ($config_id) {
	$search_config = Dever::load('account/lib/info')->getSearch($config_id);
	if ($search_config) {
		$search = $search_config;
		$user = '用户名称';
	}
}

return array
(
	# 表名
	'name' => 'info',
	# 显示给用户看的名称
	'lang' => '用户账户列表',
	'order' => 100,
	# 数据结构
	'struct' => array
	(
		'id' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> 'ID',
			'default' 	=> '',
			'desc' 		=> '',
			'match' 	=> 'is_numeric',
			//'list'		=> true,
		),

		'uid'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> $user,
			'default' 	=> '0',
			'desc' 		=> '用户名称',
			'match' 	=> 'is_numeric',
            'search'	=> $search,
            'list_name'	=> '用户名称',
			'list'		=> 'Dever::load("account/lib/info.getName", {uid}, {config_id})',
		),

		'config_id'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '账户名称',
			'default' 	=> '1',
			'desc' 		=> '账户名称',
			'match' 	=> 'is_numeric',
			'update'	=> 'select',
			'option'	=> $config,
			'search'	=> 'select',
			'list'		=> true,
		),

		'project_id'        => array
        (
            'type'      => 'int-11',
            'name'      => '所属项目',
            'default'   => '1',
            'desc'      => '所属项目',
            'match'     => 'is_numeric',
            'update'    => 'radio',
            'option'    => $project,
            'list'		=> true,
        ),

		'cash'		=> array
		(
			'type'      => 'decimal-11,2',
			'name' 		=> '可用金额',
			'default' 	=> '0',
			'desc' 		=> '可用金额',
			'match' 	=> 'option',
			'update'	=> 'text',
			'list'		=> true,
		),

		'z_cash'		=> array
		(
			'type'      => 'decimal-11,2',
			'name' 		=> '总获取金额',
			'default' 	=> '0',
			'desc' 		=> '总获取金额',
			'match' 	=> 'option',
			'update'	=> 'text',
			'list'		=> true,
		),

		't_cash'		=> array
		(
			'type'      => 'decimal-11,2',
			'name' 		=> '总消耗金额',
			'default' 	=> '0',
			'desc' 		=> '总消耗金额',
			'match' 	=> 'option',
			'update'	=> 'text',
			'list'		=> true,
		),

		'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,
		),
	),

	# 索引
	'index' => array
	(
		1 => array
		(
			'search' => 'uid,config_id,project_id',
		),
		
		# 版本号 更改版本号会更新当前表的索引
		'version' => 1,
	),

	'manage' => array
	(
		'delete' => false,
		'edit' => false,
		'insert' => false,

		# 列表
		'list_button' => array
		(
			'list' => array('账户流水', '"info_log&&project=account&search_option_uid={uid}&oper_parent=info&oper_project=account"'),
		),
	),

	# request 请求接口定义
	'request' => array
	(
		# 更新
		'inc' => array
		(
			'type' => 'update',
			'where' => array
			(
				'id' => 'yes',
			),
			'set' => array
			(
				'cash' => array('yes', '+='),
				'col' => array('yes-z_cash', '+='),
			),
		),

		# 更新
		'dec' => array
		(
			'type' => 'update',
			'where' => array
			(
				'id' => 'yes',
			),
			'set' => array
			(
				'cash' => array('yes', '+='),
				'col' => array('yes-t_cash', '+='),
			),
		),
	)
);