123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301 |
- <?php
- $status = array(
- 1 => '未确认',
- 2 => '已入账',
- );
- $fenzhang_status = array(
- 1 => '未分账',
- 2 => '已分账',
- 3 => '分账失败',
- );
- $button = array();
- $merchant_id = Dever::input('search_option_merchant_id');
- $account_id = Dever::input('search_option_account_id');
- $info = '';
- if ($merchant_id) {
- $info = Dever::load('pay/yspay/cash')->getInfo($merchant_id);
- if (Dever::load('manage/auth')->checkFunc('pay.account', 'huafu', '账户提现')) {
- $button = array(
- '账户提现' => array('fast', '', 'yspay_cash_tixian&search_option_merchant_id=' . $merchant_id),
- );
- }
- $button['账户日志'] = array('location', 'l=project/database/list&project=pay&table=yspay_merchant_log&search_option_state=1&search_option_account_id=' . $account_id . '&search_option_merchant_id=' . $merchant_id . '&[refer]');
- $button['导出数据'] = array('oper', 'pay/api.buy_order?merchant_id=' . $merchant_id);
- }
- return array(
- # 表名
- 'name' => 'yspay_cash',
- # 显示给用户看的名称
- 'lang' => '银联资金记录表',
- 'menu' => false,
- 'info' => $info,
- 'status' => $status,
- 'fenzhang_status' => $fenzhang_status,
- # 数据结构
- 'struct' => array(
- 'id' => array(
- 'type' => 'int-11',
- 'name' => 'ID',
- 'default' => '',
- 'desc' => '',
- 'match' => 'is_numeric',
- 'search' => 'order',
- 'update' => 'hidden',
- //'list' => true,
- ),
- 'account_id' => array(
- 'type' => 'int-11',
- 'name' => '账户id',
- 'default' => '',
- 'desc' => '账户id',
- 'match' => 'option',
- 'search' => 'hidden',
- 'update' => 'hidden',
- 'value' => $account_id,
- ),
- 'merchant_id' => array(
- 'type' => 'int-11',
- 'name' => '商户id',
- 'default' => '',
- 'desc' => '商户id',
- 'match' => 'option',
- 'search' => 'hidden',
- 'update' => 'hidden',
- 'value' => $merchant_id,
- 'list_name' => '商户名称',
- 'list' => 'Dever::load("pay/yspay_merchant-one#name", "{merchant_id}")',
- ),
- 'order_num' => array(
- 'type' => 'varchar-800',
- 'name' => '流水号',
- 'default' => '',
- 'desc' => '流水号',
- 'match' => 'is_string',
- 'update' => 'text',
- 'search' => 'fulltext',
- 'list' => true,
- ),
- 'source_order_num' => array(
- 'type' => 'varchar-800',
- 'name' => '关联订单号',
- 'default' => '',
- 'desc' => '关联订单号',
- 'match' => 'is_string',
- 'update' => 'text',
- 'search' => 'fulltext',
- 'list' => true,
- ),
- 'ycash' => array(
- 'type' => 'int-11',
- 'name' => '交易金额',
- 'default' => '0',
- 'desc' => '交易金额',
- 'match' => 'option',
- 'list' => 'Dever::number({ycash}/100, 2)',
- ),
- 'yl_cash' => array(
- 'type' => 'int-11',
- 'name' => '银联手续费',
- 'default' => '0',
- 'desc' => '银联手续费',
- 'match' => 'option',
- 'list' => 'Dever::number({yl_cash}/100, 2)',
- ),
- 'pt_cash' => array(
- 'type' => 'int-11',
- 'name' => '平台手续费',
- 'default' => '0',
- 'desc' => '平台手续费',
- 'match' => 'option',
- 'list' => 'Dever::number({pt_cash}/100, 2)',
- ),
- 'cash' => array(
- 'type' => 'int-11',
- 'name' => '实际金额',
- 'default' => '0',
- 'desc' => '实际金额',
- 'match' => 'option',
- 'list' => 'Dever::number({cash}/100, 2)',
- ),
- 'hf_cash' => array(
- 'type' => 'int-11',
- 'name' => '商户划付金额',
- 'default' => '0',
- 'desc' => '划付金额',
- 'match' => 'option',
- //'update' => 'text',
- 'list' => 'Dever::number({hf_cash}/100, 2)',
- ),
- 'fz_cash' => array(
- 'type' => 'int-11',
- 'name' => '平台分账金额',
- 'default' => '0',
- 'desc' => '分账金额',
- 'match' => 'option',
- //'update' => 'text',
- 'list' => 'Dever::number({fz_cash}/100, 2)',
- ),
- 'fdate' => array(
- 'type' => 'int-11',
- 'name' => '入账时间',
- 'default' => '',
- 'match' => 'is_numeric',
- 'desc' => '',
- 'search' => 'date',
- 'list' => '"{fdate}" ? date("Y-m-d H:i", \'{fdate}\') : "-"',
- 'list_order' => 100,
- ),
- 'rdate' => array(
- 'type' => 'int-11',
- 'name' => '分账时间',
- 'default' => '',
- 'match' => 'is_numeric',
- 'desc' => '',
- 'search' => 'date',
- 'list' => '"{rdate}" ? date("Y-m-d H:i", \'{rdate}\') : "-"',
- 'list_order' => 100,
- ),
- 'tdate' => array(
- 'type' => 'int-11',
- 'name' => '提现时间',
- 'default' => '',
- 'match' => 'is_numeric',
- 'desc' => '',
- //'search' => 'date',
- //'list' => '"{tdate}" ? date("Y-m-d H:i", \'{tdate}\') : "-"',
- //'list_order' => 101,
- ),
- 'status' => array(
- 'type' => 'tinyint-1',
- 'name' => '订单状态',
- 'default' => '1',
- 'desc' => '订单状态',
- 'match' => 'is_numeric',
- 'option' => $status,
- 'search' => 'select',
- 'list' => true,
- ),
- 'fenzhang_status' => array(
- 'type' => 'tinyint-1',
- 'name' => '分账状态',
- 'default' => '1',
- 'desc' => '分账状态',
- 'match' => 'is_numeric',
- 'option' => $fenzhang_status,
- 'search' => 'select',
- '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})',
- ),
- ),
- 'manage' => array(
- 'edit' => false,
- 'insert' => false,
- 'delete' => false,
- 'button' => $button,
- ),
- 'request' => array(
- 'getTotal' => array(
- 'option' => array(
- 'merchant_id' => 'yes',
- 'status' => array('yes', '>='),
- 'state' => 1,
- ),
- 'type' => 'one',
- 'col' => 'sum(cash) as cash,sum(hf_cash) as hf_cash,sum(fz_cash) as fz_cash,sum(yl_cash) as yl_cash,sum(pt_cash) as pt_cash',
- ),
- 'getList' => array(
- 'option' => array(
- 'start' => array('yes-cdate', '>='),
- 'end' => array('yes-cdate', '<='),
- 'fdate_start' => array('yes-fdate', '>='),
- 'fdate_end' => array('yes-fdate', '<='),
- 'order_num' => array('yes', 'like'),
- 'source_order_num' => array('yes', 'like'),
- 'merchant_id' => 'yes',
- 'status' => 'yes',
- 'state' => 1,
- ),
- 'type' => 'all',
- 'page' => array(20, 'list'),
- 'order' => array('id' => 'desc'),
- 'col' => '*',
- ),
- 'getOtherList' => array(
- 'option' => array(
- 'start' => array('yes-cdate', '>='),
- 'end' => array('yes-cdate', '<='),
- 'source_order_num' => array('yes', 'like'),
- 'merchant_id' => 'yes',
- 'status' => 'yes',
- 'fenzhang_status' => 'yes',
- 'state' => 1,
- ),
- 'type' => 'all',
- 'page' => array(20, 'list'),
- 'order' => array('id' => 'desc'),
- 'col' => '*',
- ),
- 'getOtherListExcel' => array(
- 'option' => array(
- 'start' => array('yes-cdate', '>='),
- 'end' => array('yes-cdate', '<='),
- 'source_order_num' => array('yes', 'like'),
- 'merchant_id' => 'yes',
- 'status' => 'yes',
- 'fenzhang_status' => 'yes',
- 'state' => 1,
- ),
- 'type' => 'all',
- 'page' => array(20, 'list'),
- 'order' => array('id' => 'desc'),
- 'col' => '*',
- ),
- ),
- );
|