OCA\OcSms\Db\SmsMapper::getAllMessagesForPhoneNumber PHP Метод

    public function getAllMessagesForPhoneNumber($userId, $phoneNumber, $country, $minDate = 0)
    {
        $phlst = $this->getAllPhoneNumbersForFPN($userId, $phoneNumber, $country);
        $messageList = array();
        $query = \OCP\DB::prepare('SELECT sms_date, sms_msg, sms_type FROM ' . '*PREFIX*ocsms_smsdatas WHERE user_id = ? AND sms_address = ? ' . 'AND sms_mailbox IN (?,?) AND sms_date > ?');
        foreach ($phlst as $pn => $val) {
            $result = $query->execute(array($userId, $pn, 0, 1, $minDate));
            while ($row = $result->fetchRow()) {
                $messageList[$row["sms_date"]] = array("msg" => $row["sms_msg"], "type" => $row["sms_type"]);
            }
        }
        return $messageList;
    }