Apps.api

Материал из CMS Sitebill Wiki
Перейти к навигации Перейти к поиску

apps.api необходим для взаимодействия с внешними приложениями.

Например, с мобильным приложением Sitebill https://play.google.com/store/apps/details?id=ru.sitebill.mobilecms


1 LOGIN

Запрос Параметр Тип данных Описание action Строка Значение должно быть oauth do Строка Значение должно быть login login Строка Логин пользователя password Строка Пароль пользователя в открытом виде

Ответ Параметр Тип данных Описание user_id Целое идентификатор пользователя из CMS session_key Строка ключ сессии (далее он будет использоваться при авторизации любых запросов без ввода логина и пароля)

admin_panel_login Boolean ‘0/1’; 0 – если пользователю нельзя входить в админку CMS, 1 – если можно.

error Строка Сообщение об ошибке login failed, если авторизация не удалась

Пример JSON Запрос http://estate.sitebill.ru/apps/api/rest.php?action=oauth&do=login&login=admin&password=admin Ответ { "user_id":"1", "session_key":"9bc07b8887ddbb6bf4409039f8d50dae", "admin_panel_login":1 }


2 CHECK_SESSION_KEY Запрос Параметр Тип данных Описание action Строка Значение должно быть oauth do Строка Значение должно быть check_session_key session_key Строка это ключ сессии

Ответ Параметр Тип данных Описание user_id Целое Идентификатор пользователя session_key Строка Ключ сессии config Массив Состав массива ниже config[per_page] Целое Это дополнительный параметр, который определяет сколько объектов (объявлений) на страницу будет выводиться в пейджере. error Строка check_session_key_failed – если ошибка при проверке ключа, например, такого ключа нет.

Пример JSON http://estate.sitebill.ru/apps/api/rest.php?action=oauth&do=check_session_key&session_key=demo_session_key { "user_id":"1", "config":{

        "per_page":"20"

}, "admin_panel_login":1, "city_list":[ {"city_id":"7","name":"Москва"}, {"city_id":"2","name":"Красноярск"}, {"city_id":"1","name":"Новосибирск"} ] }


3 STAT_URL Запрос, пока не используется Параметр Тип данных Описание action Строка stat - значение do Строка сommon - значение

Ответ Параметр Тип данных Описание data_total Целое Количество объявлений на сайте data_notactive Целое Количество неактивных объявлений user_totla Целое Количество зарегистрированных пользователей client_total Целое Количество клиентов из apps.client

Пример JSON http://estate.sitebill.ru/apps/api/rest.php?action=stat&do=common&session_key=demo_session_key { "data_total":"21", "data_notactive":"0", "user_total":"32", "client_total":"1" }


4 CITY_LIST Запрос Параметр Тип данных Описание action Строка stat - значение do Строка get_city_list - значение session_key Строка Ключ сессии

Ответ Параметр Тип данных Описание city_list Массив Содержит массив городов city_id Целое Идентификатор города name Строка Название города

Пример JSON http://estate.sitebill.ru/apps/api/rest.php?action=stat&do=get_city_list&session_key=demo_session_key { "city_list":[ {"city_id":"7","name":"Москва"}, {"city_id":"2","name":"Красноярск"}, {"city_id":"1","name":"Новосибирск"}, {"city_id":"3","name":"Екатеринбург"}, {"city_id":"4","name":"Санкт-Петербург"}, {"city_id":"6","name":"Сочи"} ] }


5 DATA_GRID Запрос Параметр Тип данных Описание action Строка stat - значение do Строка data_grid – значение session_key Строка Ключ сессии

Ответ Параметр Тип данных Описание params Массив Тут передаются параметры params[max_page] Целое Максимальное количество страниц с объявлениями по данному запросу. data Массив Это массив объявлений Id Целое Идентификатор объявления Дальше идет очень много параметров, думаю по названиям понятно для чего они. Каритнки хранятся в каталоге на сайте /img/data/ - относительного этого пути нужно их искать.

Пример JSON http://estate.sitebill.ru/apps/api/rest.php?action=stat&do=data_grid&page=1&session_key=demo_session_key


{

   "data": [
       {
           "price_ue": "123123",
           "id": "33815",
           "user_id": "1",
           "type_id": "0",
           "topic_id": "14",
           "country_id": "0",
           "city_id": "1",
           "metro_id": "5",
           "district_id": "26",
           "street": "Мира",
           "price": "123123",
           "text": "Просторная квартира",
           "contact": null,
           "date_added": "2015-04-14 12:05:26",
           "agent_tel": null,
           "room_count": "1",
           "elite": "0",
           "session_id": "",
           "active": "1",
           "image": [
               {
                   "preview": "prv552ce6884bc6c_1429005960_1.jpg",
                   "normal": "img552ce6884bc32_1429005960_1.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               },
               {
                   "preview": "prv552ce68863ff7_1429005960_2.jpg",
                   "normal": "img552ce68863fbe_1429005960_2.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               },
               {
                   "preview": "prv552ce6886c1fe_1429005960_3.jpg",
                   "normal": "img552ce6886c1be_1429005960_3.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               }
           ],
           "sub_id1": "0",
           "sub_id2": "0",
           "reviews_count": "0",
           "hot": "0",
           "floor": "2",
           "floor_count": "3",
           "walls": "кирпич",
           "balcony": "лоджия",
           "square_all": "40",
           "square_live": "60",
           "square_kitchen": "20",
           "bathroom": "раздельный",
           "img1": "",
           "img2": "",
           "img3": "",
           "img4": "",
           "img5": "",
           "img1_preview": "",
           "img2_preview": "",
           "img3_preview": "",
           "img4_preview": "",
           "img5_preview": "",
           "is_telephone": "1",
           "furniture": "1",
           "plate": "электро",
           "agent_email": "",
           "number": "",
           "spec": "0",
           "floor_cover": null,
           "square_room": null,
           "is_kitchen": "0",
           "region_id": "6",
           "street_id": "844",
           "planning": "новая",
           "dom": "",
           "flat_number": "",
           "owner": "",
           "source": "",
           "adv_date": "",
           "more1": "",
           "more2": "",
           "more3": "",
           "youtube": "",
           "realty_type_id": "0",
           "view_count": "0",
           "fio": "",
           "email": "",
           "tmp_password": "",
           "phone": "",
           "best": "0",
           "currency_id": "1",
           "ad_mobile_phone": "",
           "ad_stacionary_phone": "",
           "can_call_start": "",
           "can_call_end": "",
           "url": null,
           "geo_lat": null,
           "geo_lng": null,
           "land_square": "",
           "road_distance": "",
           "name_ua": null,
           "name_cn": null,
           "name_am": null,
           "premium_status_end": "0",
           "vip_status_end": "0",
           "bold_status_end": "0",
           "meta_title": null,
           "meta_keywords": null,
           "meta_description": null,
           "bathroom_unit": "",
           "floor_covering": "",
           "window_view": "",
           "building_name": "",
           "building_type": "",
           "building_series": "",
           "building_state": "",
           "built_year": "",
           "ready_quarter": "",
           "lift": "0",
           "rubbish_chute": "0",
           "is_elite": "0",
           "parking": "0",
           "alarm": "0",
           "ceiling_height": "",
           "pmg": "0",
           "kitchen": "0",
           "pool": "0",
           "billiard": "0",
           "sauna": "0",
           "heating_supply": "0",
           "water_supply": "0",
           "sewerage_supply": "0",
           "electricity_supply": "0",
           "gas_supply": "0",
           "toilet": "",
           "shower": "",
           "expire_date": "0000-00-00 00:00:00",
           "payed_adv": "0",
           "manually_added": "0",
           "direction": "",
           "distance": "",
           "time_on_transport": "",
           "time_on_foot": "",
           "railway_station": "",
           "not_for_agents": "0",
           "haggle": "0",
           "mortgage": "0",
           "prepayment": "",
           "rent_pledge": "0",
           "agent_fee": "",
           "with_pets": "0",
           "with_children": "0",
           "renovation": "",
           "lot_type": "",
           "lot_area": "",
           "new_flat": "0",
           "rooms": "0",
           "rooms_offered": "0",
           "open_plan": "0",
           "rooms_type": "",
           "internet": "0",
           "room_furniture": "0",
           "kitchen_furniture": "0",
           "television": "0",
           "washing_machine": "0",
           "refrigerator": "0",
           "type_sh": "2-комнатная.",
           "region": "Красноярский край",
           "district": "Советский",
           "city": "Красноярск",
           "metro": "Революции",
           "user": "Иван Иванов",
           "currency": "RUR",
           "path": "Аренда \/ 2-комнатная.",
           "date": "14.04",
           "datetime": "14.04 12:05",
           "topic_info": {
               "id": "14",
               "name": "2-комнатная.",
               "active": "2",
               "parent_id": "1",
               "order": "12",
               "sql_where": "room_count = 2",
               "obj_type_id": "0",
               "def_id1": "0",
               "def_id2": "0",
               "operation_type_id": "0",
               "url": "arenda-kvartir\/2-komn",
               "description": null,
               "meta_title": null,
               "meta_keywords": null,
               "meta_description": null,
               "name_en": null,
               "name_ua": null,
               "name_cn": null,
               "name_am": null,
               "public_title": null
           },
           "parent_category_url": "arenda-kvartir\/2-komn\/",
           "href": "\/arenda-kvartir\/2-komn\/realty33815",
           "img": [
               {
                   "preview": "prv552ce6884bc6c_1429005960_1.jpg",
                   "normal": "img552ce6884bc32_1429005960_1.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               },
               {
                   "preview": "prv552ce68863ff7_1429005960_2.jpg",
                   "normal": "img552ce68863fbe_1429005960_2.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               },
               {
                   "preview": "prv552ce6886c1fe_1429005960_3.jpg",
                   "normal": "img552ce6886c1be_1429005960_3.jpg",
                   "type": "graphic",
                   "mime": "jpg"
               }
           ]
       }
   ],
   "params": {
       "max_page": 2
   }

}

6 REALTY_VIEW Запрос Параметр Тип данных Описание action Строка stat - значение do Строка realty_view – значение realty_id Целое Идентификатор объявления session_key Строка Ключ сессии

Ответ Параметр Тип данных Описание data Массив Массив с данным об объявлении user Массив Массив данных о владельце объявления Для каждого поля есть набор системных параметров, например, для ID есть name, title, value … Весь этот набор строится на основе модели дынных внутри CMS Sitebill Про саму модель есть видео http://www.youtube.com/watch?v=vpVpUq0q5GA


Пример JSON http://estate.sitebill.ru/apps/api/rest.php?action=stat&do=realty_view&realty_id=1967&session_key=demo_session_key

{

   "data": {
       "id": {
           "name": "id",
           "title": "Идентификатор",
           "value": "1967",
           "type": "primary_key",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": [],
           "required": "off",
           "unique": "off"
       },
       "user_id": {
           "name": "user_id",
           "title": "Идентификатор пользователя",
           "value": "1",
           "type": "primary_key",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "active": {
           "name": "active",
           "title": "Публиковать на сайте",
           "value": "1",
           "type": "checkbox",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": [],
           "required": "off",
           "unique": "off"
       },
       "hot": {
           "name": "hot",
           "title": "Спецразмещение",
           "value": "1",
           "type": "checkbox",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "topic_id": {
           "name": "topic_id",
           "title": "Категория",
           "value": "4110",
           "type": "select_box_structure",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "Офисы",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "выберите одну категорию",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": [],
           "required": "on",
           "unique": "off"
       },
       "region_id": {
           "name": "region_id",
           "title": "Регион",
           "value": "11",
           "type": "select_by_query",
           "primary_key_name": "region_id",
           "primary_key_table": "region",
           "value_string": "Караганда",
           "query": "select * from re_region order by name",
           "value_name": "name",
           "title_default": "выбрать регион",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off",
           "onchange": " update_child_list('city_id',this);  set_empty('district_id',this);  set_empty('metro_id',this);  set_empty('street_id',this); ",
           "ajax_options": {
               "update_child_list": [
                   "city_id"
               ],
               "set_empty": [
                   "district_id",
                   "metro_id",
                   "street_id"
               ]
           }
       },
       "city_id": {
           "name": "city_id",
           "title": "Город",
           "value": "1",
           "type": "select_by_query",
           "primary_key_name": "city_id",
           "primary_key_table": "city",
           "value_string": "Москва",
           "query": "select * from re_city order by name",
           "value_name": "name",
           "title_default": "выбрать город",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off",
           "onchange": " update_child_list('metro_id',this);  update_child_list('district_id',this);  set_empty('street_id',this); ",
           "ajax_options": {
               "update_child_list": [
                   "district_id"
               ],
               "set_empty": [
                   "street_id"
               ]
           }
       },
       "metro_id": {
           "name": "metro_id",
           "title": "Метро",
           "value": "0",
           "type": "select_by_query",
           "primary_key_name": "metro_id",
           "primary_key_table": "metro",
           "value_string": "",
           "query": "select * from re_metro order by name",
           "value_name": "name",
           "title_default": "выбрать метро",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "district_id": {
           "name": "district_id",
           "title": "Район",
           "value": "29",
           "type": "select_by_query",
           "primary_key_name": "id",
           "primary_key_table": "district",
           "value_string": "Васька",
           "query": "select * from re_district order by name",
           "value_name": "name",
           "title_default": "выбрать район",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off",
           "onchange": " update_child_list('street_id',this); ",
           "ajax_options": {
               "update_child_list": [
                   "street_id"
               ]
           }
       },
       "street_id": {
           "name": "street_id",
           "title": "Улица",
           "value": "527",
           "type": "select_by_query",
           "primary_key_name": "street_id",
           "primary_key_table": "street",
           "value_string": "Мусоргского",
           "query": "select * from re_street order by name",
           "value_name": "name",
           "title_default": "выбрать улицу",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": {
               "autocomplete": "1"
           },
           "required": "off",
           "unique": "off"
       },
       "price": {
           "name": "price",
           "title": "Цена",
           "value": "5000000",
           "type": "price",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "geo": {
           "name": "geo",
           "title": "Координаты",
           "value": {
               "lat": "55.861676",
               "lng": "37.621246"
           },
           "type": "geodata",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": null,
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "можно указывать координаты на карте, например, для земельных участков без адреса",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": [],
           "required": "off",
           "unique": "off"
       },
       "room_count": {
           "name": "room_count",
           "title": "Кол.во комнат",
           "value": "2",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "floor": {
           "name": "floor",
           "title": "Этаж",
           "value": "8",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "floor_count": {
           "name": "floor_count",
           "title": "Этажность",
           "value": "10",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "walls": {
           "name": "walls",
           "title": "Материал стен",
           "value": "кирпич",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "planning": {
           "name": "planning",
           "title": "Планировка",
           "value": "",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "balcony": {
           "name": "balcony",
           "title": "Балкон",
           "value": "лоджия",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "square_all": {
           "name": "square_all",
           "title": "Площадь общая",
           "value": "80",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "square_live": {
           "name": "square_live",
           "title": "Площадь жилая",
           "value": "50",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "square_kitchen": {
           "name": "square_kitchen",
           "title": "Площадь кухни",
           "value": "12",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "bathroom": {
           "name": "bathroom",
           "title": "Сан. узел",
           "value": "раздельный",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "plate": {
           "name": "plate",
           "title": "Плита",
           "value": "электро",
           "type": "select_box",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "электро",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "select_data": {
               "нет": "нет",
               "газ": "газ",
               "электро": "электро"
           },
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "is_telephone": {
           "name": "is_telephone",
           "title": "Телефон",
           "value": "0",
           "type": "checkbox",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "furniture": {
           "name": "furniture",
           "title": "Мебель",
           "value": "0",
           "type": "checkbox",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Характеристики объекта",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "text": {
           "name": "text",
           "title": "Описание",
           "value": "Офис для крупной компании. Здесь можно второй гугл построить!",
           "type": "textarea",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "Фото и комментарии",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "fio": {
           "name": "fio",
           "title": "Ваше имя",
           "value": "",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "email": {
           "name": "email",
           "title": "E-mail",
           "value": "",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "phone": {
           "name": "phone",
           "title": "Ваш телефон",
           "value": "",
           "type": "mobilephone",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "columns",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "view_count": {
           "name": "view_count",
           "title": "Количество просмотров",
           "value": "129",
           "type": "hidden",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": null,
           "hint": null,
           "active_in_topic": null,
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "image": {
           "name": "image",
           "title": "Фото",
           "value": [
               {
                   "normal": "img52afcba7afd71_1387252647_1.jpg",
                   "preview": "prv52afcba7afd9c_1387252647_1.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_1.jpg",
                   "preview": "prv31445_1361327684_1.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_2.jpg",
                   "preview": "prv31445_1361327684_2.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_3.jpg",
                   "preview": "prv31445_1361327684_3.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               }
           ],
           "type": "uploads",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": null,
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "data",
           "primary_key": "id",
           "primary_key_value": "1967",
           "action": "",
           "tab": "Фото и комментарии",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": "",
           "combo": "0",
           "parameters": [],
           "required": "off",
           "unique": "off",
           "image_array": [
               {
                   "normal": "img52afcba7afd71_1387252647_1.jpg",
                   "preview": "prv52afcba7afd9c_1387252647_1.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_1.jpg",
                   "preview": "prv31445_1361327684_1.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_2.jpg",
                   "preview": "prv31445_1361327684_2.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               },
               {
                   "normal": "img31445_1361327684_3.jpg",
                   "preview": "prv31445_1361327684_3.jpg",
                   "title": "",
                   "description": "",
                   "mime": "jpg",
                   "type": "graphic"
               }
           ]
       }
   },
   "user": {
       "user_id": {
           "name": "user_id",
           "title": "ID",
           "value": "1",
           "type": "primary_key",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "group_id": {
           "name": "group_id",
           "title": "Группа",
           "value": "1",
           "type": "select_by_query",
           "primary_key_name": "group_id",
           "primary_key_table": "group",
           "value_string": "Администраторы",
           "query": "select * from re_group order by name",
           "value_name": "name",
           "title_default": "выбрать группу",
           "value_default": "0",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "on",
           "unique": "off"
       },
       "login": {
           "name": "login",
           "title": "Login",
           "value": "admin",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "on",
           "unique": "off"
       },
       "reg_date": {
           "name": "reg_date",
           "title": "Дата регистрации",
           "value": "0000-00-00 00:00:00",
           "type": "hidden",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "newpass": {
           "name": "newpass",
           "title": "Новый пароль",
           "value": null,
           "type": "password",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "notable",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "newpass_retype": {
           "name": "newpass_retype",
           "title": "Повторите новый пароль",
           "value": null,
           "type": "password",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "notable",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "fio": {
           "name": "fio",
           "title": "ФИО",
           "value": "Иван Иванов",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "email": {
           "name": "email",
           "title": "Email",
           "value": "kondin@etown.ru",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "on",
           "unique": "on"
       },
       "phone": {
           "name": "phone",
           "title": "Телефон",
           "value": "234-34-34",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "mobile": {
           "name": "mobile",
           "title": "Мобильный телефон",
           "value": "",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "icq": {
           "name": "icq",
           "title": "ICQ#",
           "value": "73072365",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "site": {
           "name": "site",
           "title": "Сайт",
           "value": "http:\/\/www.sitebill.ru",
           "type": "safe_string",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       },
       "imgfile": {
           "name": "imgfile",
           "title": "Фото",
           "value": "img9866_1338745122_379.jpg",
           "type": "photo",
           "primary_key_name": "",
           "primary_key_table": "",
           "value_string": "",
           "query": "",
           "value_name": "",
           "title_default": "",
           "value_default": "",
           "value_table": "",
           "value_primary_key": "",
           "value_field": "",
           "assign_to": "",
           "dbtype": "",
           "table_name": "",
           "primary_key": "",
           "primary_key_value": "",
           "action": "",
           "tab": "",
           "hint": "",
           "active_in_topic": "0",
           "group_id": "0",
           "entity": null,
           "combo": "0",
           "required": "off",
           "unique": "off"
       }
   }

}