PHRETS - Извлечение информации об агенте MLS

$search = $rets->SearchQuery("User",11,"(2699=1900-01-01+)");
while ($listing = $rets->FetchRow($search)) {
    echo print_r($listing);
}

Пытаясь вытащить всех агентов MLS, используя эти настройки, но просто ничего не вижу, я перепробовал так много вариантов, но ничего не передалось.

The Field : [2699] => LastLoginDate
(Pulled out directly from get metadatatable)

Я могу без проблем вытащить списки, используя один и тот же код выше с другим именем класса и кодами. Пользователь просто не пройдет, что я пропустил? Большое спасибо

Вот мой результат из таблиц метаданных (так что вы видите, что мой пользователь и 11 хороши)

  Array
   (
   [0] => Array
    (
        [Resource] => DeletedListing
        [Data] => Array
            (
                [0] => Array
                    (
                        [ClassName] => 1021
                        [VisibleName] => DeletedListing
                        [StandardName] => 
                        [Description] => Deleted Listings
                        [TableVersion] => 28.63.49757
                        [TableDate] => Thu, 28 Jul 2011 05:35:57 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

            )

    )

[1] => Array
    (
        [Resource] => Office
        [Data] => Array
            (
                [0] => Array
                    (
                        [ClassName] => 12
                        [VisibleName] => OFF
                        [StandardName] => Office
                        [Description] => Office
                        [TableVersion] => 37.45.13672
                        [TableDate] => Tue, 13 May 2014 15:34:32 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

            )

    )

[2] => Array
    (
        [Resource] => Property
        [Data] => Array
            (
                [0] => Array
                    (
                        [ClassName] => 1
                        [VisibleName] => RES
                        [StandardName] => ResidentialProperty
                        [Description] => Residential
                        [TableVersion] => 37.91.89015
                        [TableDate] => Sun, 06 Jul 2014 18:16:55 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [1] => Array
                    (
                        [ClassName] => 2
                        [VisibleName] => CON
                        [StandardName] => 
                        [Description] => Condominium
                        [TableVersion] => 37.59.63841
                        [TableDate] => Fri, 30 May 2014 10:24:01 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [2] => Array
                    (
                        [ClassName] => 3
                        [VisibleName] => MUL
                        [StandardName] => MultiFamily
                        [Description] => Multifamily
                        [TableVersion] => 37.59.63864
                        [TableDate] => Fri, 30 May 2014 10:24:24 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [3] => Array
                    (
                        [ClassName] => 4
                        [VisibleName] => LOT
                        [StandardName] => LotsAndLand
                        [Description] => Lots
                        [TableVersion] => 37.59.63885
                        [TableDate] => Fri, 30 May 2014 10:24:45 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [4] => Array
                    (
                        [ClassName] => 5
                        [VisibleName] => FAR
                        [StandardName] => 
                        [Description] => Farm
                        [TableVersion] => 37.59.63903
                        [TableDate] => Fri, 30 May 2014 10:25:03 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [5] => Array
                    (
                        [ClassName] => 6
                        [VisibleName] => RNT
                        [StandardName] => 
                        [Description] => Rental
                        [TableVersion] => 37.59.63920
                        [TableDate] => Fri, 30 May 2014 10:25:20 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [6] => Array
                    (
                        [ClassName] => 10
                        [VisibleName] => ICI
                        [StandardName] => 
                        [Description] => Commercial
                        [TableVersion] => 37.59.63952
                        [TableDate] => Fri, 30 May 2014 10:25:52 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

                [7] => Array
                    (
                        [ClassName] => 13
                        [VisibleName] => XProp
                        [StandardName] => CommonInterest
                        [Description] => Cross-Property and Open House
                        [TableVersion] => 37.58.83323
                        [TableDate] => Thu, 29 May 2014 12:02:03 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

            )

    )

[3] => Array
    (
        [Resource] => User
        [Data] => Array
            (
                [0] => Array
                    (
                        [ClassName] => 11
                        [VisibleName] => USE
                        [StandardName] => Agent
                        [Description] => Member
                        [TableVersion] => 37.50.77785
                        [TableDate] => Tue, 20 May 2014 04:16:25 GMT
                        [UpdateVersion] => 
                        [UpdateDate] => 
                    )

            )

    )

)

Мета-таблица для Ressource USER и класса 11

Array
(
    [sysid] => sysid
    [1662] => Address 1
    [1663] => WorkPhone
    [1664] => EMail Address
    [1665] => Agent Home Page
    [1666] => Access Flag
    [1669] => CellPhone
    [1670] => PagerPhone
    [1671] => City
    [1672] => State
    [1673] => MiddleName
    [1674] => NickName
    [1675] => Comments
    [1676] => OfficePID
    [1677] => OfficeContactNotes
    [1678] => SecurityType
    [1679] => Yellow Pages Flag (Old)
    [1680] => Office Phone (Unused)
    [1681] => Office Fax (Old)
    [1682] => BillingAddress1
    [1683] => BillingAddress2
    [1684] => BillingCity
    [1685] => BillingState
    [1686] => BillingZipCode
    [1687] => BillingPhone
    [1688] => BillingFaxPhone
    [1689] => DeliveryAddress1
    [1690] => DeliveryAddress2
    [1691] => DeliveryCity
    [1692] => DeliveryState
    [1693] => DeliveryZipCode
    [1694] => DeliveryPhone
    [1695] => DeliveryFaxPhone
    [1696] => DeliveryPID
    [1697] => DeliveryRoute
    [1698] => DeliveryStop
    [1699] => DeliveryNotes
    [1700] => DeliveryCommAdrs
    [1701] => KeyCardID
    [1702] => AffiliateType
    [1703] => OfficeVoiceExt
    [1704] => AccountingNum
    [1705] => OtherLicenseNum
    [1706] => NRDSMemberID
    [1707] => PublishingProd1
    [1708] => PublishingProd2
    [1709] => PublishingProd3
    [1710] => PublishingProd4
    [1711] => Access Flag Date (Old)
    [1712] => NetMLSAccess
    [1713] => DataLinkAccess
    [1714] => CensusGroup
    [1715] => CensusTract
    [1716] => CensusBlock
    [1717] => BSMemberPrimaryIndicator
    [1718] => Roster Flag
    [1719] => Yellow Page Flag
    [1720] => Direct Line
    [1721] => BSGender
    [1722] => BSHomeZIPCode
    [1723] => BSHomeZIPCode6
    [1724] => BSMailAddress
    [1725] => BSMailAttnCareOf
    [1726] => BSMailCity
    [1727] => BSMailState
    [1728] => BSMailZIPCode
    [1729] => BSMailZIPCode6
    [1730] => BSPreferredMail
    [1731] => BSPreferredPublication
    [1732] => BSHomeAreaCode
    [1733] => Home Phone Number (Old)
    [1734] => BSPersonalFaxArea
    [1735] => Personal Fax (Old)
    [1736] => BSPreferredFax
    [1737] => BSOfficeID
    [1738] => Member Class
    [1739] => BSJoinedDate
    [1740] => BSOrientationDate
    [1741] => BSStatus
    [1742] => BSStatusDate
    [1743] => BSPreviousNonMember
    [1744] => BSDuesWaivedLocal
    [1745] => BSDuesWaivedState
    [1746] => Board
    [1747] => BSSocialSecurityNumber
    [1748] => MLXchange # of Accesses
    [1749] => BSBirthDate
    [1750] => BSTransferDate
    [1751] => BSStopMail
    [1752] => BSJunkMailFlag
    [1753] => BSOnlineStatus
    [1754] => Access Flag Date
    [1755] => BSPrimaryAssociationID
    [1756] => BSSecondaryAssociationID1
    [1757] => BSSecondaryAssociationID2
    [1758] => BSSecondaryAssociationID3
    [1759] => BSPrimaryStateAssocID
    [1760] => BSSecondaryStateAssocID1
    [1761] => BSSecondaryStateAssocID2
    [1762] => BSSecondaryStateAssocID3
    [1763] => BSAffiliationCode#1
    [1764] => BSAffiliationCode#2
    [1765] => BSAffiliationCode#3
    [1766] => BSAffiliationCode#4
    [1767] => BSAffiliationCode#5
    [1768] => BSAffiliationCode#6
    [1769] => BSAffiliationCode#7
    [1770] => BSAffiliationCode#8
    [1771] => BSAffiliationCode#9
    [1772] => BSAffiliationCode#10
    [1773] => BSAffiliationCode#11
    [1774] => BSAffiliationCode#12
    [1775] => BSDesignationDate#1
    [1776] => BSDesignationCode#1
    [1777] => BSDesignationCode#2
    [1778] => BSDesignationDate#2
    [1779] => BSDesignationCode#3
    [1780] => BSDesignationDate#3
    [1781] => BSDesignationCode#4
    [1782] => BSDesignationDate#4
    [1783] => BSDesignationCode#5
    [1784] => BSDesignationDate#5
    [1785] => BSDesignationCode#6
    [1786] => BSDesignationDate#6
    [1787] => BSDesignationCode#7
    [1788] => BSDesignationDate#7
    [1789] => BSDesignationCode#8
    [1790] => BSDesignationDate#8
    [1791] => BSDesignationCode#9
    [1792] => BSDesignationDate#9
    [1793] => BSDesignationCode#10
    [1794] => BSDesignationDate#10
    [1795] => BSDesignationCode#11
    [1796] => BSDesignationDate#11
    [1797] => BSDesignationCode#12
    [1798] => BSDesignationDate#12
    [1799] => BSPrimaryFieldofBusiness
    [1800] => BSSecondaryFieldofBus1
    [1801] => BSSecondaryFieldofBus2
    [1802] => BSSecondaryFieldofBus3
    [1803] => User Title
    [1804] => BSPointOfEntry
    [1805] => BSEMailAddress
    [1806] => BSMLSNumber
    [1807] => Altaira Multi-Login Flag YN
    [1808] => BSStopFaxCode
    [1809] => Agent Extension
    [1810] => BSReinstatementCode
    [1811] => BSReinstatementDate
    [1812] => BSNARDuesPaid
    [1813] => BSStateDuesPaid
    [1814] => Board Old
    [1815] => Address 2
    [1816] => Address 3
    [1817] => Entry Date
    [1818] => First Name
    [1819] => Personal Fax
    [1820] => Last Name
    [1821] => Last Transaction Code
    [1822] => Last Transaction Date
    [1823] => Office Code
    [1824] => Password
    [1825] => Rdfsetdate
    [1826] => Record Delete Flag
    [1827] => Roster Flag (Old)
    [1828] => Primary User Class
    [1829] => Member Code
    [1830] => Agent ID
    [1831] => User Title (Old)
    [1832] => Home Phone 
    [1833] => Postal Code
    [2310] => RegBoard
    [2414] => User Full Name
    [2415] => User Company Name
    [2416] => User Address1
    [2417] => User Address2
    [2418] => User City
    [2419] => User State
    [2420] => User Zip
    [2421] => User Work Phone
    [2422] => User Cell Phone
    [2423] => User Pager-PIN
    [2424] => User Fax
    [2425] => User 800 Phone
    [2426] => User Primary Email
    [2427] => User Cell Email
    [2428] => User Web URL
    [2429] => User Email Signature
    [2468] => MLX Type
    [2469] => SecondaryBoardID
    [2473] => License Type
    [2513] => MDCAuditLevel
    [2514] => AgentFullName
    [2515] => ProNDREmailAddress
    [2530] => SuspensionType
    [2531] => SuspensionDate
    [2555] => PriviledgedSSOUser
    [2556] => Designation
    [2557] => EmailSignature
    [2572] => FirmCode
    [2573] => FirmName
    [2585] => DrivingLatitude
    [2586] => DrivingLongitude
    [2598] => AgentLicense
    [2689] => ListingServiceNameAbbrev
    [2692] => Member CREA ID
    [2699] => LastLoginDate
)

Я должен указать, что этот точный запрос работает для извлечения свойств:

$search = $rets->SearchQuery("Property",1,"(105=2012-01-01+)");
while ($listing = $rets->FetchRow($search)) {
    echo print_r($listing);
}

1 ответ

Можете ли вы показать MetadataTable для пользователя ресурса и ClassName 11.

Я действительно не думаю, что это правильно

(2699=1900-01-01+)

Вы уверены, что это не так:

(LastLoginDate=1900-01-01+)

Другие вопросы по тегам