_sendMassMenu($selectedMonth); $this->_showSendMass($selectedMonth); SE_Layout::dol(); } private function _showSendMass($selectedMonth) { $zest = array(); if (strlen($selectedMonth) != 7) return; $db = DB::getDB(); $sql = <<0, h.`LAST_SMS_MSG_ID`, h.`LAST_MAIL_MSG_ID`))) WHERE h.`LAST_MAIL_MSG_ID`>0 and h.`A_RECORD_UPDATE_DATE` like '{$selectedMonth}-%' group by h.`A_RECORD_UPDATE_AUTHOR`, substr(h.`A_RECORD_UPDATE_DATE`, 1, 10), hc.`STATUS_MAIL` ) union ( SELECT 'SMS' as `TYPE` , h.`A_RECORD_UPDATE_AUTHOR` , substr(h.`A_RECORD_UPDATE_DATE`, 1, 10) as `_wind_save` , hc.`STATUS_SMS` as `STATUS` , count(*) as cnt FROM `SES_USERS2`.`USERS2_WINDYKACJA_STATUS_HIST` h join `SES_USERS2`.`USERS2_WINDYKACJA_STATUS` w on(w.`ID`=h.`ID_USERS2`) join `billing2013`.`HIST_CONTACTS` hc on(hc.`ID`=(IF(h.`LAST_SMS_MSG_ID` >0, h.`LAST_SMS_MSG_ID`, h.`LAST_MAIL_MSG_ID`))) WHERE h.`LAST_SMS_MSG_ID` > 0 and h.`A_RECORD_UPDATE_DATE` like '{$selectedMonth}-%' group by h.`A_RECORD_UPDATE_AUTHOR`, substr(h.`A_RECORD_UPDATE_DATE`, 1, 10), hc.`STATUS_SMS` ) order by `_wind_save` ASC, `TYPE` ; SQL; $res = $db->query($sql); while ($r = $db->fetch($res)) { $zest[] = $r; } ?>
Typ User Data Status Ilość
TYPE; ?> A_RECORD_UPDATE_AUTHOR; ?> _wind_save; ?> STATUS; ?> cnt; ?>