支付中心数据库查询语句--个人记录

来源：互联网发布：声线测试软件app 编辑：程序博客网时间：2024/04/24 01:08

select id 'ID号',

sn '商城订单号',
(select paycenterdb.pay_order.order_id from paycenterdb.pay_order where paycenterdb.pay_order.out_trade_no = saledb.pay_order.sn) '支付中心订单号',
member_id '用户ID',
(select guangchang.users.nike from guangchang.users where guangchang.users.id= saledb.pay_order.member_id)as '用户名',
(select name from pay_item where pay_item.id=pay_order.item_id)as '商品名',
(select attr_name from pay_attr where pay_attr.id=pay_order.attr_id)as '属性名',
count as '数量',
base_price as '单价',
total_price as '总价',
FROM_UNIXTIME(create_time) as '下单时间',
(case pay_status when 1 then '已支付' when 0 then '未支付' when 2 then '已过期' end)as'支付状态',
(case to_status when 0 then '未发货' when 1 then '已发货' end)as '发货状态',
(case pay_type when 'alipay' then '支付宝-PC版' when 'epaylinks' then '网上银行-PC版' when 'epaylinkswap' then '网上银行-M版' when 'alipaywap' then '支付宝-M版' end)as '支付类型',
(select field_value from pay_order_extend where pay_order_extend.order_id=pay_order.id and extend_id=16)as '手机',
FROM_UNIXTIME(pay_time) as '支付时间',(select paycenterdb.pay_order.updated_remark from paycenterdb.pay_order where paycenterdb.pay_order.out_trade_no = saledb.pay_order.sn)as '票号信息'
from pay_order
ORDER BY create_time desc

0 0