{sum sum=value action=sql sql='select * from cms_member_paylog WHERE value < 0 AND DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(from_unixtime(paytime))' return=zonghe}
方案
外聘专员-小波工作室#1 · 2023-12-30 18:56:07
满意答案
{php $sql=urlencode('select * from cms_member_paylog WHERE value < 0 AND DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(from_unixtime(paytime))');}
{sum sum=value action=sql sql='$sql' return=zonghe}{$zonghe_sum}
{php $sql=urlencode('select * from cms_member_paylog WHERE value < 0 AND DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(from_unixtime(paytime))');} {sum sum=value action=sql sql='$sql' return=zonghe}{$zonghe_sum}