数据库查询

select count(*) from order_form t1 left join industry_tags_store t2 on t1.company_id=t2.id WHERE DATEDIFF(t1.sign_for_time,NOW())=-1 and t1.status=3 and t2.is_enterprise=1

 

SELECT commision,order_revenue,currency,store,store_id,username,user_id,dms_account,work_account,enterprise_account,DATE_FORMAT(gather_time,'%Y-%m-%d') gathertime, sum(layer_income) layerIncome FROM company_day_income GROUP BY gathertime

 

select count(*) from order_form t1 left join industry_tags_store t2 on t1.company_id=t2.id WHERE DATEDIFF(t1.sign_for_time,NOW())=-1 and t1.status=3 and t2.is_enterprise=1

版权声明:
作者:admin
链接:http://lixiaofang.top/2021/12/14/%e6%95%b0%e6%8d%ae%e5%ba%93%e6%9f%a5%e8%af%a2/
来源:码农日志
文章版权归作者所有,未经允许请勿转载。

THE END
分享
二维码
< <上一篇
下一篇>>