OCA\OcSms\Db\SmsMapper::getNewMessagesCountForAllPhonesNumbers PHP Method

    public function getNewMessagesCountForAllPhonesNumbers($userId, $lastDate)
    {
        $ld = $lastDate == '' ? 0 : $lastDate;
        $sql = 'SELECT sms_address, COUNT(sms_date) AS ct FROM ' . '*PREFIX*ocsms_smsdatas WHERE user_id = ? AND sms_mailbox IN (?,?) ' . 'AND sms_date > ? GROUP BY sms_address';
        $query = \OCP\DB::prepare($sql);
        $result = $query->execute(array($userId, 0, 1, $ld));
        $phoneList = array();
        while ($row = $result->fetchRow()) {
            $phoneNumber = preg_replace("#[ ]#", "", $row["sms_address"]);
            if ($this->convStateMapper->getLastForPhoneNumber($userId, $phoneNumber) < $lastDate) {
                if (!array_key_exists($phoneNumber, $phoneList)) {
                    $phoneList[$phoneNumber] = $row["ct"];
                } else {
                    $phoneList[$phoneNumber] += $row["ct"];
                }
            }
        }
        return $phoneList;
    }