编辑代码

#JSRUN引擎2.0，支持多达30种语言在线运行，全仿真在线交互输入输出。
echo "Hello JSRUN!   

         - from Shell/Bash ."

#日期格式：yyyyMMdd
statdate=$(date -d "${datetime}" +"%Y%m%d")
echo "statdate:${statdate}"
before1day_statdate=$(date -d"1 day ago ${datetime}" +"%Y%m%d")
echo "before1day_statdate:${before1day_statdate}"
before7day_statdate=$(date -d"7 day ago ${datetime}" +"%Y%m%d")
echo "before7day_statdate:${before7day_statdate}"

#日期格式：yyyy-MM-dd
statdate_t=$(date -d "${datetime}" +"%Y-%m-%d")
echo "statdate_t:${statdate_t}"
before1day_statdate_t=$(date -d"1 day ago ${datetime}" +"%Y-%m-%d")
echo "before1day_statdate_t:${before1day_statdate_t}"
before7day_statdate_t=$(date -d"7 day ago ${datetime}" +"%Y-%m-%d")
echo "before7day_statdate_t:${before7day_statdate_t}"

echo "SELECT a.daily_revenue_sum daily_revenue_sum,
                 b.daily_revenue_sum_last_week daily_revenue_last_week_sum,
                 a.statdate revenue_date
          FROM
            (SELECT sum(income_price) daily_revenue_sum,
                    statdate
             FROM db_result.r_b_order_detail_sell_info_dt
             WHERE pay_time LIKE '${before1day_statdate_t}%'
               AND statdate = '${before1day_statdate}'
             GROUP BY statdate) a
          LEFT JOIN
            (SELECT sum(income_price) daily_revenue_sum_last_week,
                    statdate
             FROM db_result.r_b_order_detail_sell_info_dt
             WHERE pay_time LIKE '${before7day_statdate_t}%'
               AND statdate = '${before1day_statdate}'
             GROUP BY statdate) b ON a.statdate = b.statdate;"