{"contacts":[{"db":{"db":{},"type":"mysqli","forcecharset":"utf8","forcecollate":"utf8_unicode_ci","connected":true,"database_selected":true,"database_name":"agec","database_user":"agec","database_host":"139.144.217.136","database_port":"3306","transaction_opened":0,"lastquery":"SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'socpeople' ORDER BY pos","lastqueryerror":null,"lasterror":null,"lasterrno":null,"prefix_db":null,"ok":true,"error":null},"id":"1","entity":"1","error":null,"errorhidden":null,"errors":[],"validateFieldsErrors":[],"element":"contact","element_for_permission":null,"table_element":"socpeople","table_element_line":"","import_key":null,"array_options":[],"array_languages":null,"contacts_ids":null,"linked_objects":null,"linkedObjectsIds":null,"linkedObjects":null,"linkedObjectsFullLoaded":[],"oldcopy":null,"restrictiononfksoc":0,"context":[],"canvas":null,"project":null,"fk_project":null,"projet":null,"fk_projet":null,"contact":null,"contact_id":null,"thirdparty":null,"user":null,"origin":null,"origin_id":null,"ref":"1","ref_ext":null,"ref_previous":null,"ref_next":null,"newref":null,"statut":"1","status":null,"country":"France","country_id":"1","country_code":"FR","state":null,"state_id":null,"state_code":null,"region_id":null,"region_code":null,"region":null,"barcode_type":null,"barcode_type_code":null,"barcode_type_label":null,"barcode_type_coder":null,"mode_reglement_id":null,"cond_reglement_id":null,"demand_reason_id":null,"transport_mode_id":null,"cond_reglement":null,"fk_delivery_address":null,"shipping_method_id":null,"model_pdf":null,"modelpdf":null,"last_main_doc":null,"fk_bank":null,"fk_account":null,"openid":null,"note_public":"","note_private":"","note":"","total_ht":null,"total_tva":null,"total_localtax1":null,"total_localtax2":null,"total_ttc":null,"lines":null,"comments":[],"name":null,"lastname":"DUPONT","firstname":"Fr\u00e9d\u00e9ric","civility_id":null,"date_creation":1655278866,"date_validation":null,"date_modification":1655286066,"date_cloture":null,"user_author":null,"user_creation":null,"user_creation_id":null,"user_valid":null,"user_validation":null,"user_validation_id":null,"user_closing_id":null,"user_modification":null,"user_modification_id":null,"next_prev_filter":null,"specimen":0,"sendtoid":null,"alreadypaid":null,"ismultientitymanaged":1,"picto":"contact","fields":{"rowid":{"type":"integer","label":"TechnicalID","enabled":1,"visible":0,"notnull":1,"position":10},"entity":{"type":"integer","label":"Entity","default":1,"enabled":1,"visible":3,"notnull":1,"position":30,"index":1},"ref_ext":{"type":"varchar(255)","label":"Ref ext","enabled":1,"visible":3,"position":35},"civility":{"type":"varchar(6)","label":"Civility","enabled":1,"visible":3,"position":40},"lastname":{"type":"varchar(50)","label":"Lastname","enabled":1,"visible":1,"position":45,"showoncombobox":1,"searchall":1},"firstname":{"type":"varchar(50)","label":"Firstname","enabled":1,"visible":1,"position":50,"showoncombobox":1,"searchall":1},"poste":{"type":"varchar(80)","label":"PostOrFunction","enabled":1,"visible":-1,"position":52},"address":{"type":"varchar(255)","label":"Address","enabled":1,"visible":-1,"position":55},"zip":{"type":"varchar(25)","label":"Zip","enabled":1,"visible":1,"position":60},"town":{"type":"text","label":"Town","enabled":1,"visible":-1,"position":65},"fk_departement":{"type":"integer","label":"Fk departement","enabled":1,"visible":3,"position":70},"fk_pays":{"type":"integer","label":"Fk pays","enabled":1,"visible":3,"position":75},"birthday":{"type":"date","label":"Birthday","enabled":1,"visible":3,"position":80},"phone":{"type":"varchar(30)","label":"Phone","enabled":1,"visible":1,"position":90,"searchall":1},"phone_perso":{"type":"varchar(30)","label":"PhonePerso","enabled":1,"visible":-1,"position":95,"searchall":1},"phone_mobile":{"type":"varchar(30)","label":"PhoneMobile","enabled":1,"visible":1,"position":100,"searchall":1},"fax":{"type":"varchar(30)","label":"Fax","enabled":1,"visible":-1,"position":105,"searchall":1},"email":{"type":"varchar(255)","label":"Email","enabled":1,"visible":1,"position":110,"searchall":1},"socialnetworks":{"type":"text","label":"SocialNetworks","enabled":1,"visible":3,"position":115},"photo":{"type":"varchar(255)","label":"Photo","enabled":1,"visible":3,"position":170},"priv":{"type":"smallint(6)","label":"ContactVisibility","enabled":1,"visible":1,"notnull":1,"position":175},"fk_stcommcontact":{"type":"integer","label":"ProspectStatus","enabled":1,"visible":-1,"notnull":1,"position":220},"fk_prospectlevel":{"type":"varchar(12)","label":"ProspectLevel","enabled":1,"visible":-1,"position":255},"note_private":{"type":"text","label":"NotePrivate","enabled":1,"visible":3,"position":195,"searchall":1},"note_public":{"type":"text","label":"NotePublic","enabled":1,"visible":3,"position":200,"searchall":1},"default_lang":{"type":"varchar(6)","label":"Default lang","enabled":1,"visible":3,"position":205},"canvas":{"type":"varchar(32)","label":"Canvas","enabled":1,"visible":3,"position":210},"datec":{"type":"datetime","label":"DateCreation","enabled":1,"visible":-1,"position":300},"tms":{"type":"timestamp","label":"DateModification","enabled":1,"visible":-1,"notnull":1,"position":305},"fk_user_creat":{"type":"integer","label":"UserAuthor","enabled":1,"visible":3,"position":310},"fk_user_modif":{"type":"integer","label":"UserModif","enabled":1,"visible":3,"position":315},"statut":{"type":"tinyint(4)","label":"Status","enabled":1,"visible":1,"notnull":1,"position":500},"import_key":{"type":"varchar(14)","label":"ImportId","enabled":1,"visible":-1,"position":1000}},"civility_code":"MR","civility":"Monsieur","civilite":null,"address":"","zip":"","town":"","poste":"","socid":"1","fk_soc":"1","code":null,"email":"","url":null,"no_email":null,"socialnetworks":[],"skype":null,"twitter":null,"facebook":null,"linkedin":null,"jabberid":null,"photo":null,"phone_pro":"","phone_perso":"","phone_mobile":"","fax":"","priv":"0","birthday":"","default_lang":null,"ref_facturation":null,"ref_contrat":null,"ref_commande":null,"ref_propal":null,"user_id":"7","user_login":"frederic.dupont","roles":null,"cacheprospectstatus":[],"fk_prospectlevel":"","stcomm_id":"0","statut_commercial":"Jamais contacté","stcomm_picto":null,"field":{"fk_stcommcontact":{"enabled":0},"fk_prospectcontactlevel":{"enabled":0}},"socname":"LES NOUVEAUX ENTREPRENEURS","mail":"","gender":"man"}],"error":""}