package main

import (
    "fmt"
    "strings"
)

// replacePlaceholders 替換SQL查詢中的時(shí)間占位符
func replacePlaceholders(sql, startTime, endTime string) string {
    // 替換起始時(shí)間占位符
    sql = strings.Replace(sql, "${time_start}", startTime, -1)
    // 替換結(jié)束時(shí)間占位符
    sql = strings.Replace(sql, "${time_end}", endTime, -1)
    return sql
}

package main

import (
    "fmt"
    "strings"
    "time"
)

// replacePlaceholders 替換SQL查詢中的時(shí)間占位符，并設(shè)置默認(rèn)日期
func replacePlaceholders(sql, startTime, endTime string) string {
    // 如果startTime為空，設(shè)置為當(dāng)前年份的11月1日
    if startTime == "" {
        currentYear := time.Now().Year()
        startTime = fmt.Sprintf("%d-11-01", currentYear)
    }
    // 如果endTime為空，設(shè)置為10年后的1月1日
    if endTime == "" {
        tenYearsLater := time.Now().Year() + 10
        endTime = fmt.Sprintf("%d-01-01", tenYearsLater)
    }

    // 替換起始時(shí)間占位符
    sql = strings.Replace(sql, "${time_start}", startTime, -1)
    // 替換結(jié)束時(shí)間占位符
    sql = strings.Replace(sql, "${time_end}", endTime, -1)
    return sql
}

SELECT COUNT(*) FROM (
    SELECT DATE_FORMAT(check_time, '%Y-%m-%d') , checker, checker_id, count(*) 
    FROM buyer_info_check 
    WHERE checker_id != -1 
      AND check_time >= '${time_start}' 
      AND check_time <= '${time_end}'  
      AND status=0  
    GROUP BY DATE_FORMAT(check_time, '%Y-%m-%d'), checker
) a 
LEFT JOIN (
    SELECT user_id, user_name, team_name, area_name, agent, 
           SUM(call_out_total) as call_out_total, 
           SUM(call_in_total) as call_in_total, 
           SUM(call_success) as call_success, 
           SUM(total_time) as total_time
    FROM static_team_seat
    WHERE static_time >= '${time_start}' 
      AND static_time <= '${time_end}'
    GROUP BY user_id
) b 
ON a.checker_id = b.user_id