bitsCN.com
create view `v_noprovide` as select *from tb_sectionwhere provide = '0'create view `v_thismonth` as select ts.userid as id, concat( 'thismonth:', sum(ts.amount), 'yuan' ) as 'thismonth'from tb_section as tswhere ts.yearmonth = date_format(now(), '%y%m')create view `v_lastmonth` as select ts.userid as id, concat( 'lastmonth:', sum(ts.amount), 'yuan' ) as 'lastmonth'from tb_section as tswhere ts.yearmonth = date_format( date_sub(now(), interval 1 month), '%y%m' )create view `v_usermanage` asselect u.id as id, u.email as email, u.`name` as `name`, concat( coalesce ( la.lastmonth, 'lastmonth:0yuan' ), coalesce ( th.thismonth, 'thismonth:0yuan' ) ) as recent, sum(coalesce(b.amount,0)) as totalbonus, sum(coalesce(n.amount,0)) as unbilledfrom tb_user as uleft join tb_bonus as b on u.id = b.receiveridleft join v_noprovide as n on u.id = n.useridleft join v_thismonth as th on u.id = th.idleft join v_lastmonth as la on u.id = la.idgroup by u.id
具有服装类网店的常用的功能和完善的商品类型管理、商品管理、配送支付管理、订单管理、会员分组、会员管理、查询统计和多项商品促销功能。系统具有静态HTML生成、UTF-8多语言支持、可视化模版引擎等技术特点，适合建立服装、鞋帽、服饰类网店。系统具有以下主要功能模块： 网站参数设置 - 对网站的一些参数进行个性化定义 会员类型设置 - 可以任意创建多个会员类型，设置不同会员类型的权限和价格级别 货币类型
0
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
794
收藏
