<?php
/**
 * 元数据
 */
return [
	'title' => "凭证", 
	//主要用于《写操作》
	'table' => "voucher", 
	//主要用于《读操作》,数据表格sql,如果没有查询条件在末尾加上  where 1=1
	'view_old' => "SELECT * FROM (SELECT *
				,CONCAT(mid(v_cycle,3,4),'-',v_seq) cycleseq
				,getObjectFullName(v_subject) subjectText
				,getObjectKeyword(v_subject) subjectKeyword
				,(SELECT o_name FROM `object` WHERE o_id=v_object_1 LIMIT 1) depText
				,(SELECT o_keyword FROM `object` WHERE o_id=v_object_1 LIMIT 1) depKeyword
				,(SELECT o_name FROM `object` WHERE o_id=v_object_2 LIMIT 1) staffText
				,(SELECT o_keyword FROM `object` WHERE o_id=v_object_2 LIMIT 1) staffKeyword
				,(SELECT o_name FROM `object` WHERE o_id=v_object_4 LIMIT 1) clientText
				,(SELECT o_keyword FROM `object` WHERE o_id=v_object_4 LIMIT 1) clientKeyword
				,(CASE v_state WHEN 0 THEN '' ELSE '已审核' END) stateText
				FROM voucher v) V_ WHERE v_state<>3",
	'view' => "SELECT * FROM (SELECT *
				,CONCAT(mid(v_cycle,3,4),'-',v_seq) cycleseq
				,'' subjectText
				,'' subjectKeyword
				,'' depText
				,'' depKeyword
				,'' staffText
				,'' staffKeyword
				,'' clientText
				,'' clientKeyword
				,'' stateText
				FROM voucher v) V_ WHERE v_state<>3",
	'view' => "SELECT *
				,CONCAT(mid(v_cycle,3,4),'-',v_seq) cycleseq
				,'' subjectText
				,'' subjectKeyword
				,'' depText
				,'' depKeyword
				,'' staffText
				,'' staffKeyword
				,'' clientText
				,'' clientKeyword
				,'' stateText
				FROM voucher WHERE v_state<>3",
	'order' => "v_cycle desc,v_seq,v_id", //默认排序
	'key' => "v_id", //主键字段
	'caption' => "v_seq", //主要显示字段
	'fields'=>[
		'v_id'=>[
			'field'=>'v_id',
			'name'=>'ID', //字段描述
			'type'=>'decimal',
			'key'=>true, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>13, //长度(含有小数)
			'scale'=>5, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'hidden', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'number',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_cycle'=>[
			'field'=>'v_cycle',
			'name'=>'会计周期(年月)', //字段描述
			'type'=>'smallint',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>5, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_date'=>[
			'field'=>'v_date',
			'name'=>'日期', //字段描述
			'type'=>'date',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_seq'=>[
			'field'=>'v_seq',
			'name'=>'号', //字段描述
			'type'=>'int',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'list'=>['formatter'=>'link'], //列格式化
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_subject'=>[
			'field'=>'v_subject',
			'name'=>'科目', //字段描述
			'type'=>'int',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_object_1'=>[
			'field'=>'v_object_1',
			'name'=>'部门_核算对象', //字段描述
			'type'=>'int',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_object_2'=>[
			'field'=>'v_object_2',
			'name'=>'职员_核算对象', //字段描述
			'type'=>'int',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_object_4'=>[
			'field'=>'v_object_4',
			'name'=>'客户_核算对象', //字段描述
			'type'=>'int',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>10, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_summary'=>[
			'field'=>'v_summary',
			'name'=>'摘要', //字段描述
			'type'=>'varchar',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>100, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_j'=>[
			'field'=>'v_j',
			'name'=>'借方余额', //字段描述
			'type'=>'decimal',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>12, //长度(含有小数)
			'scale'=>2, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_d'=>[
			'field'=>'v_d',
			'name'=>'贷方余额', //字段描述
			'type'=>'decimal',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>12, //长度(含有小数)
			'scale'=>2, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_state'=>[
			'field'=>'v_state',
			'name'=>'1:有效，2:废弃,3:删除', //字段描述
			'type'=>'tinyint',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>3, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
		'v_checkout'=>[
			'field'=>'v_checkout',
			'name'=>'0:未结,1:已结', //字段描述
			'type'=>'tinyint',
			'key'=>false, //是否为主键
			'unique'=>false, //是否唯一
			'maxlength'=>3, //长度(含有小数)
			'scale'=>0, //小数位数
			'issearch'=>true, //是否参入查询
			'islist'=>true, //是否在列表中显示
			'isview'=>true, //是否在详情视图中显示
			'isorder'=>true, 
			'editor'=> [
				'required'=> true, //是否为必须项
				'type'=> 'text', //text,hidden,select,checkbox,radio,textarea
				'fieldtype'=> 'string',//string,number(含有小数),digits(整数)
				'minlength'=>0
			]
		],
	],
];