比如一下sql:

SELECT

   DATE_FORMAT(#{queryDate}, '%Y-%m') AS date,

   tab1.model,

   SUM(tab1.saleNum) AS saleNum,

   SUM(tab1.kc) AS kc

FROM (

   SELECT tms.model, tcb.date, tcb.no, tcb.quantity,

          t4.saleNum, tcb.quantity - t4.saleNum AS kc,

          tcb.quantity - t4.lk AS checkFlag

   FROM tabbatch tcb,

   (

       SELECT t3.no, COUNT(1) AS lk, SUM(t3.saleFlag) AS saleNum

       FROM (

           SELECT t1.no, IF(t2.sn2 IS NULL, 0, 1) AS saleFlag

           FROM (

               SELECT DISTINCT tsi.no, tsi.sn  

               FROM tabinfo tsi

               WHERE tsi.is_deleted = 0

                 AND tsi.status IN (1,2)

                 AND tsi.indate <= LAST_DAY(#{queryDate})

           ) t1

           LEFT JOIN (

               SELECT DISTINCT tsi.no, tsi.sn AS sn2

               FROM tabinfo tsi

               WHERE tsi.is_deleted = 0

                 AND tsi.status = 2

                 AND tsi.outdate <= LAST_DAY(#{queryDate})

           ) t2 ON t1.no = t2.no AND t1.sn = t2.sn2

       ) t3

       GROUP BY t3.no

   ) t4,

   tabmodel tms  

   WHERE tcb.no = t4.no

     AND tcb.model = tms.id

) tab1

GROUP BY model

我想queryDate默认传当前月份2026-06,可以选择时间,这个可以实现吗?