jiazhi/service/database/order.php

<?php

$type = array
(
	1 => '购买',
	2 => '兑换',
);

$status = array
(
	1 => '待支付',
	2 => '已支付',
	3 => '支付失败',
	//4 => '申请退款',
	5 => '已退款',
);

$product = function()
{
	return Dever::db('service/product')->state();
};

/*
$feedback_status = array
(
	1 => '未反馈',
	2 => '已反馈',
	3 => '已出方案',
);
*/
$feedback_status = array
(
	1 => '未填写问卷',
	2 => '填写问卷中',
	3 => '完成填写问卷',
	4 => '已出方案',
);

return array
(
	# 表名
	'name' => 'order',
	# 显示给用户看的名称
	'lang' => '订单管理',
	'order' => 100,
	'feedback_status' => $feedback_status,

	'end' => array
	(
		'update' => 'service/lib/manage.order',
	),

	# 数据结构
	'struct' => array
	(
	
		'id' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> 'ID',
			'default' 	=> '',
			'desc' 		=> '',
			'match' 	=> 'is_numeric',
			'search'	=> 'order',
			'list'		=> true,
		),

		'order_id'		=> array
		(
			'type' 		=> 'varchar-100',
			'name' 		=> '订单id',
			'default' 	=> '',
			'desc' 		=> '付款订单id',
			'match' 	=> 'is_string',
			'update'	=> 'text',
			'search'	=> 'fulltext',
			//'list'		=> true,
			//'list'		=> '"{order_id}" ? "{order_id}" : "{code}"',
		), 

		'name'		=> array
		(
			'type' 		=> 'varchar-80',
			'name' 		=> '订单名称',
			'default' 	=> '',
			'desc' 		=> '订单名称',
			'match' 	=> 'is_string',
			'update'	=> 'text',
			'search'	=> 'fulltext',
			'list_name'	=> '订单信息',
			'list'		=> 'Dever::load("service/lib/manage.showOrderUser", "{id}")',
		),

		'uid'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '用户id',
			'default' 	=> '',
			'desc' 		=> '用户id',
			'match' 	=> 'is_numeric',
			'update'	=> 'text',
			'list_name'	=> '问卷详情',
			'list'		=> 'Dever::load("service/lib/manage.showQuestion", "{uid}", "{product_id}", "{id}", "{feedback_status}")',
		),

		'product_id'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '产品',
			'default' 	=> '',
			'desc' 		=> '产品',
			'match' 	=> 'is_numeric',
			'update'	=> 'select',
			'option'	=> $product,
			'search'	=> 'select',
			//'list'		=> true,
		),

		'type'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '支付方式',
			'default' 	=> '1',
			'desc' 		=> '支付方式',
			'match' 	=> 'is_numeric',
			'option' 	=> $type,
			'search'	=> 'select',
			'update'	=> 'radio',
			//'list'		=> true,
			'control'	=> 'type',
		),

		'notice'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '模板消息提醒次数',
			'default' 	=> '0',
			'desc' 		=> '模板消息提醒次数',
			'match' 	=> 'is_numeric',
		),

		'cash'		=> array
		(
			'type' 		=> 'varchar-50',
			'name' 		=> '支付金额',
			'default' 	=> '',
			'desc' 		=> '支付金额',
			'match' 	=> 'option',
			'update'	=> 'text',
			//'list'		=> true,
			'show'		=> 'type=1',
		),

		'code'		=> array
		(
			'type' 		=> 'varchar-50',
			'name' 		=> '使用的兑换码',
			'default' 	=> '',
			'desc' 		=> '使用的兑换码',
			'match' 	=> 'option',
			'update'	=> 'text',
			//'list'		=> true,
			'show'		=> 'type=2',
		),

		'status'		=> array
		(
			'type' 		=> 'tinyint-1',
			'name' 		=> '订单状态',
			'default' 	=> '1',
			'desc' 		=> '请选择订单状态',
			'match' 	=> 'is_numeric',
			'option' 	=> $status,
			'search'	=> 'select',
			'update'	=> 'radio',
			'list'		=> 'Dever::load("service/lib/manage.showOrderStatus", "{id}")',
			'control'	=> 'status',
		),

		'feedback_status'		=> array
		(
			'type' 		=> 'tinyint-1',
			'name' 		=> '反馈状态',
			'default' 	=> '1',
			'desc' 		=> '反馈状态',
			'match' 	=> 'is_numeric',
			'option' 	=> $feedback_status,
			'search'	=> 'select',
			'update'	=> 'select',
			'list'		=> 'Dever::load("service/lib/manage.showFeedbackStatus", "{id}")',
		),

		'feedback_time'		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '设计反馈时间-直接填写天数 已废弃',
			'default' 	=> '7',
			'desc' 		=> '设计反馈时间',
			'match' 	=> 'option',
			//'update'	=> 'text',
			'show'		=> 'feedback_status=2',
		),

		'feedback_desc'		=> array
		(
			'type' 		=> 'varchar-300',
			'name' 		=> '设计反馈说明 已废弃',
			'default' 	=> '',
			'desc' 		=> '设计反馈说明',
			'match' 	=> 'option',
			//'update'	=> 'textarea',
			'show'		=> 'feedback_status=2',
		),

		'tk_time' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '退款时间',
			'default' 	=> '',
			'desc' 		=> '退款时间',
			'match' 	=> 'option',
			//'list'		=> true,
			'show'		=> 'status=5',
		),

		'tk_admin' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '退款审核人',
			'default' 	=> '1',
			'desc' 		=> '退款审核人',
			'match' 	=> 'option',
			//'list'		=> true,
			'show'		=> 'status=5',
		),

		'tk_desc'		=> array
		(
			'type' 		=> 'varchar-300',
			'name' 		=> '退款备注',
			'default' 	=> '',
			'desc' 		=> '退款备注',
			'match' 	=> 'option',
			'update'	=> 'textarea',
			//'show'		=> 'status=5',
		),

		'feedback_date' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '反馈问卷时间',
			'default' 	=> '',
			'desc' 		=> '反馈问卷时间',
			'match' 	=> 'option',
			'search'	=> 'date',
			//'list'		=> true,
		),

		'survey_date' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '填写问卷时间',
			'default' 	=> '',
			'desc' 		=> '填写问卷时间',
			'match' 	=> 'option',
			'search'	=> 'date',
			//'list'		=> true,
		),

		'survey_end_date' 		=> array
		(
			'type' 		=> 'int-11',
			'name' 		=> '完成填写问卷时间',
			'default' 	=> '',
			'desc' 		=> '完成填写问卷时间',
			'match' 	=> 'option',
			//'search'	=> 'date',
			//'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,
			'search'	=> 'date',
			//'list'		=> 'date("Y-m-d H:i:s", {cdate})',
			'list'		=> 'Dever::load("service/lib/manage.showOrderTime", "{id}")',
		),

		'info'		=> array
		(
			'type' 		=> 'varchar-300',
			'name' 		=> '备注',
			'default' 	=> '',
			'desc' 		=> '备注',
			'match' 	=> 'option',
			'update'	=> 'textarea',
			//'show'		=> 'status=5'
			'list'		=> '"{info}" ? "{info}" : "双击添加备注"',
			'edit'		=> true,
		),

		'mobile'		=> array
		(
			'type' 		=> 'varchar-300',
			'name' 		=> '手机号',
			'default' 	=> '',
			'desc' 		=> '手机号',
			'match' 	=> 'option',
			//'show'		=> 'status=5'
			'search'	=> array
			(
				'api' => 'passport/user-all',//接口地址，最好是获取多条数据的地址
				'col' => 'mobile',//要查询的字段
				'result' => 'id',//返回的字段
				'search' => 'uid',//本表的字段，默认为当前的字段
			),
		),
	),

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

		'button' => array
		(
			'导出订单' => array('location', 'service/lib/manage.out'),
		),

		//'list' => array('查看问卷', '"feedback&project=service&search_option_order_id={id}&search_option_product_id={product_id}&oper_parent=order&oper_project=service"'),

		'list_button' => array(
			'edit' => array('退款', 'tk_time,tk_desc,tk_admin', '{status} > 1'),

			'add' => array('添加方案', '"feedback&project=service&search_option_order_id={id}&search_option_product_id={product_id}&search_option_uid={uid}&oper_parent=order&oper_project=service&oper_save_jump=order&where_id={id}"', '{feedback_status} >= 3'),

			'oper' => array('发送方案', '"service/lib/manage.sendFeedback?id={id}"', '{feedback_status} == 3'),

			'oper1' => array('再次发送短信', '"service/lib/manage.sendFeedbackSms?id={id}"', '{feedback_status} == 4'),

			'delete' => array('删除', '', '{status} == 1'),
		),
	),

	'request' => array
	(
		'getAll' => array
		(
			# 匹配的正则或函数 选填项
			'option' => array
			(
				'status' => array('1', '!='),
				'uid' => 'yes',
				'state' => 1,
			),
			'type' => 'all',
			'order' => array('cdate' => 'desc'),
			'page' => array(10, 'list'),
			'col' => '*',
		),

		'getYes' => array
		(
			# 匹配的正则或函数 选填项
			'option' => array
			(
				'product_id' => 'yes',
				'feedback_status' => array('yes', '>='),
				'state' => 1,
			),
			'type' => 'all',
			'order' => array('cdate' => 'desc'),
			'col' => '*',
		),

		# 获取提交订单超过12个小时并且没有提交问卷的
		'getDataByTime' => array
		(
			# 匹配的正则或函数 选填项
			'option' => array
			(
				'cdate' => array('yes', '>='),
				'feedback_status' => array(2, '<='),
				'notice' => 'yes',
				'state' => 1,
			),
			'type' => 'all',
			'order' => array('cdate' => 'desc'),
			'col' => '*',
		),
	),
);