This shows you the differences between two versions of the page.
— |
design2budget:webservice:operation:list [2015/11/27 14:09] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== design2budget Entwickler Webservice Dokumentation ====== | ||
+ | |||
+ | Zurück zur [[design2budget:webservice|Webservice Dokumentation Startseite]] | ||
+ | |||
+ | ====== Basisoperation <module>/list ====== | ||
+ | |||
+ | Diese Action wird von jedem Modul angeboten und liefert eine Liste mit Einträgen für das jeweilige Modul. | ||
+ | |||
+ | Die Anzahl an zurückgegebenen Records wird über den Parameter perpage angegeben. | ||
+ | |||
+ | Die zurückgegebene Liste kann durch Angabe von Filterkriterien eingeschränkt werden. Die Filterkriterien werden im POST Request übergeben. | ||
+ | |||
+ | Die Filterkriterien müssen nur beim 1. Aufruf von list übergeben werden. Beim Holen der Seite 2 (z.B. Paramter p=1) verwendet das System automatisch die zuvor gesetzten Filterkriterien. | ||
+ | |||
+ | ==== GET ==== | ||
+ | |||
+ | https://server/tenant/s/module/list/?sid=sessionID[&output=outputMode][&perpage=(1-500)][&p=page][&o=sortField][&d=sortDirection] | ||
+ | |||
+ | ^ parameter ^ Optional: Standard ^ Beschreibung ^ | ||
+ | | output | JA: json | JSON REST API (json) oder XML REST API (xml) | | ||
+ | | perpage | JA: 12 | anzahl an Elemente pro Seite (1-500) | | ||
+ | | p | JA: 0 | aktuelle Seite (0=erste Seite) | | ||
+ | | o | JA: unterschiedlich je modul | Feld für Sortierung | | ||
+ | | d | JA: 0 | aufsteigend (0) oder absteigend (1) | | ||
+ | |||
+ | Beispiel: | ||
+ | |||
+ | https://server/tenant/s/offer/list/?sid=9bd3b5f93692e4659632c8585eb35447&perpage=100&p=2&o=startdate&d=0 | ||
+ | |||
+ | Holt 100 Angebote (perpage=100) beginnend auf Seite 3 (page=2) sortiert nach Startdatum (o=startdate) in aufsteigender Reihenfolge (d=0) | ||
+ | |||
+ | ==== POST ==== | ||
+ | |||
+ | Per POST Parameter werden die Filterkriterien übergeben. | ||
+ | |||
+ | Der Parametername entspricht hierbei einfach dem Feldnamen (siehe Aktion schema) und der Parameterwert entspricht dem jeweiligen Inhalt, den das Feld haben muss. | ||
+ | |||
+ | Die einzelnen Kriterien werden UND verknüpft (d.h. alle Kriterien müssen zutreffen). | ||
+ | |||
+ | ^ Parameter ^ Beschreibung ^ | ||
+ | | <field>=<value> | Das angegebene Feld muss dem Wert value entsprechen | | ||
+ | | <field2>=<value2> | Das angegebene Feld muss dem Wert value entsprechen | | ||
+ | | <field...>=<value...> | Das angegebene Feld muss dem Wert value entsprechen | | ||
+ | |||
+ | === Filter Syntax === | ||
+ | |||
+ | ^ Syntaxelement ^ Beschreibung ^ | ||
+ | | keines | Der angegebene Inhalt muss exakt entsprechen | | ||
+ | | % | Es kann ein beliebiger Inhalt vorkommen | | ||
+ | | > | Nur gültig bei Zahlen: Zahl muss größer sein | | ||
+ | | >= | Nur gültig bei Zahlen: Zahl muss größer gleich sein | | ||
+ | | < | Nur gültig bei Zahlen: Zahl muss kleiner sein | | ||
+ | | <= | Nur gültig bei Zahlen: Zahl muss kleiner gleich sein | | ||
+ | | ! | Nur gültig bei Zahlen: Zahl muss ungleich sein | | ||
+ | | & | Nur gültig bei Zahlen: UND Verknüpfung 2er Bedingungen | | ||
+ | | %%|%% | Nur gültig bei Zahlen: ODER Verknüpfung 2er Bedingungen | | ||
+ | |||
+ | Bei Datumsfelder kann direkt das Datum im deutschsprachigen Format DD.MM.YYYY angegeben werden. Das System kann hier auch mit Vergleichen (Größer, Kleiner) umgehen. \\ | ||
+ | Alternativ ist auch die Angabe von Unixtimestamps möglich. \\ | ||
+ | Das System erkennt das Datums/Zeitformat automatisch. | ||
+ | |||
+ | |||
+ | **ACHTUNG:** Groß- und Kleinschreibung wird bei Filterwerten NICHT unterschieden (bei Feldnamen jedoch schon). | ||
+ | |||
+ | Beispiele: | ||
+ | |||
+ | ^ Beispiel ^ Erklärung ^ | ||
+ | | lastname="Mustermann" | Nachname muss exakt "Mustermann" sein | | ||
+ | | lastname="Muster%" | Nachname muss mit "Muster" beginnen | | ||
+ | | id=">5" | Die ID muss größer 5 sein | | ||
+ | | id=">5&<9" | Die ID muss größer 5 und kleiner 9 sein | | ||
+ | | id="!100" | Die ID muss ungleich 100 sein | | ||
+ | | startdate=">=1.10.2014&<=31.12.2014" | Das Startdatum muss zwischen 1.10.2014 und 31.12.2014 liegen | | ||
+ | |||
+ | |||
+ | === Beispiel: JSON Return === | ||
+ | |||
+ | https://server/tenant/s/offer/list/?sid=9bd3b5f93692e4659632c8585eb35447&perpage=3&p=0&o=startdate&d=0 | ||
+ | |||
+ | Die ersten 3 Angebote (perpage=3) auf der ersten Seite (p=0) sortiert nach Startdatum (o=startdate) aufsteigend (d=0) | ||
+ | |||
+ | <code javascript> | ||
+ | { | ||
+ | "module":"offer", | ||
+ | "list": [{ | ||
+ | "id":"1", | ||
+ | "created_user":"1", | ||
+ | "created_user__id":"1", | ||
+ | "created_user__created_user":"0", | ||
+ | "created_user__created_ip":null, | ||
+ | "created_user__created_date":"0", | ||
+ | "created_user__modified_user":"1", | ||
+ | "created_user__modified_ip":"10.1.1.214", | ||
+ | "created_user__modified_date":"1422778828", | ||
+ | "created_user__email":"admin@example.com", | ||
+ | "created_user__tel":"+436641234567", | ||
+ | "created_user__username":"admin@example.com", | ||
+ | "created_user__status":"0", | ||
+ | "created_user__status_inactive_dt":"0", | ||
+ | "created_user__accesstype":"1024", | ||
+ | "created_user__firstname":"Chuck", | ||
+ | "created_user__lastname":"Tester", | ||
+ | "created_user__title":"", | ||
+ | "created_user__location_string":null, | ||
+ | "created_user__location_privacy":"0", | ||
+ | "created_user__location":"0", | ||
+ | "created_user__location_street":"", | ||
+ | "created_user__location_city":"", | ||
+ | "created_user__location_zip":"0", | ||
+ | "created_user__location_country":"", | ||
+ | "created_user__partner":"0", | ||
+ | "created_ip":"10.1.1.56", | ||
+ | "created_date":"1373988203", | ||
+ | "modified_user":"1", | ||
+ | "modified_user__id":"1", | ||
+ | "modified_user__created_user":"0", | ||
+ | "modified_user__created_ip":null, | ||
+ | "modified_user__created_date":"0", | ||
+ | "modified_user__modified_user":"1", | ||
+ | "modified_user__modified_ip":"10.1.1.214", | ||
+ | "modified_user__modified_date":"1422778828", | ||
+ | "modified_user__email":"admin@example.com", | ||
+ | "modified_user__tel":"+436641234567", | ||
+ | "modified_user__username":"admin@example.com", | ||
+ | "modified_user__status":"0", | ||
+ | "modified_user__status_inactive_dt":"0", | ||
+ | "modified_user__accesstype":"1024", | ||
+ | "modified_user__firstname":"Chuck", | ||
+ | "modified_user__lastname":"Tester", | ||
+ | "modified_user__title":"", | ||
+ | "modified_user__location_string":null, | ||
+ | "modified_user__location_privacy":"0", | ||
+ | "modified_user__location":"0", | ||
+ | "modified_user__location_street":"", | ||
+ | "modified_user__location_city":"", | ||
+ | "modified_user__location_zip":"0", | ||
+ | "modified_user__location_country":"", | ||
+ | "modified_user__partner":"0", | ||
+ | "modified_ip":"10.1.1.56", | ||
+ | "modified_date":"1375451044", | ||
+ | "record_status":"0", | ||
+ | "status":"8", | ||
+ | "status_change_dt":"0", | ||
+ | "status_sent":"0", | ||
+ | "status_custinstructed":"0", | ||
+ | "status_custinstructed_ip":null, | ||
+ | "status_custdeclined":"0", | ||
+ | "status_custdeclined_ip":null, | ||
+ | "declinereason":"0", | ||
+ | "reviewdate":"0", | ||
+ | "sendtype":"0", | ||
+ | "locked":"1", | ||
+ | "customer":"3", | ||
+ | "customer__id":"3", | ||
+ | "customer__created_user":"1", | ||
+ | "customer__created_ip":"10.1.1.56", | ||
+ | "customer__created_date":"1373982851", | ||
+ | "customer__modified_user":"0", | ||
+ | "customer__modified_ip":"LOCALEXEC", | ||
+ | "customer__modified_date":"1433455286", | ||
+ | "customer__record_status":"0", | ||
+ | "customer__status":"0", | ||
+ | "customer__status_change_dt":"0", | ||
+ | "customer__ctype":"1", | ||
+ | "customer__lastname":"Seppenberger", | ||
+ | "customer__firstname":"Franz", | ||
+ | "customer__title":"1", | ||
+ | "customer__company":"Franz Seppenberger OG", | ||
+ | "customer__comboname":"Fa. Franz Seppenberger OG \/ Herr Franz Seppenberger ", | ||
+ | "customer__comboname2":null, | ||
+ | "customer__zip":"2320", | ||
+ | "customer__city":"Rannersdorf", | ||
+ | "customer__street":"Brauhausstr. 53-55", | ||
+ | "customer__country":"\u00d6sterreich", | ||
+ | "customer__email":"og.franz.seppenberger@example.com", | ||
+ | "customer__phone":"01\/2312313", | ||
+ | "customer__mobile":"+43 665 2312312", | ||
+ | "customer__fax":"ffaaxx", | ||
+ | "customer__web":"www.seppenberger-kg.at", | ||
+ | "customer__vatno":null, | ||
+ | "customer__code":null, | ||
+ | "customer__paymenttype":null, | ||
+ | "customer__paymentinfo":null, | ||
+ | "customer__annexoffer":null, | ||
+ | "customer__annexinvoice":null, | ||
+ | "customer__discount":"2.5", | ||
+ | "customer__tax":"0", | ||
+ | "customer__description":null, | ||
+ | "customer__istemplate":"0", | ||
+ | "customer__mainatt":"0", | ||
+ | "customer__lastcorrespondence":"166", | ||
+ | "customer__linkurl":null, | ||
+ | "customer__location":"0", | ||
+ | "offerpdf":"6", | ||
+ | "offerpdf__id":"6", | ||
+ | "offerpdf__created_user":"1", | ||
+ | "offerpdf__created_ip":"10.1.1.56", | ||
+ | "offerpdf__created_date":"1375285612", | ||
+ | "offerpdf__modified_user":"1", | ||
+ | "offerpdf__modified_ip":"10.1.1.56", | ||
+ | "offerpdf__modified_date":"1375285612", | ||
+ | "offerpdf__customer":"0", | ||
+ | "offerpdf__positiongroup":"0", | ||
+ | "offerpdf__article":"0", | ||
+ | "offerpdf__offer":"1", | ||
+ | "offerpdf__order":"0", | ||
+ | "offerpdf__invoice":"0", | ||
+ | "offerpdf__dunning":"0", | ||
+ | "offerpdf__position":"0", | ||
+ | "offerpdf__user":"0", | ||
+ | "offerpdf__inoutexpenses":"0", | ||
+ | "offerpdf__settings":"", | ||
+ | "offerpdf__sysevents":"0", | ||
+ | "offerpdf__direction":"0", | ||
+ | "offerpdf__type":"3", | ||
+ | "offerpdf__code":null, | ||
+ | "offerpdf__sentdate":"0", | ||
+ | "offerpdf__readdate":"0", | ||
+ | "offerpdf__filename":"offer-1-1375285612.pdf", | ||
+ | "offerpdf__tempname":"00000\/6", | ||
+ | "offerpdf__filetype":"21", | ||
+ | "offerpdf__summary":null, | ||
+ | "offerpdf__description":null, | ||
+ | "offerpdf__token":null, | ||
+ | "site_name":"Franz Seppenberger", | ||
+ | "site_lastname":null, | ||
+ | "site_firstname":null, | ||
+ | "site_title":"0", | ||
+ | "site_company":"Franz Seppenberger KG", | ||
+ | "site_zip":"2320", | ||
+ | "site_city":"Schwechat", | ||
+ | "site_street":"Murauerstr. 1", | ||
+ | "site_country":"\u00d6sterreich", | ||
+ | "site_email":"franz@seppenberger-kg.at", | ||
+ | "site_phone":"01\/2312312", | ||
+ | "site_mobile":"+43 664 2312312", | ||
+ | "site_fax":"ffaaxx", | ||
+ | "site_vatno":null, | ||
+ | "site_discount":"2.5", | ||
+ | "site_tax":"0", | ||
+ | "istemplate":"0", | ||
+ | "parent":"0", | ||
+ | "parent__id":null, | ||
+ | "parent__created_user":null, | ||
+ | "parent__created_ip":null, | ||
+ | "parent__created_date":null, | ||
+ | "parent__modified_user":null, | ||
+ | "parent__modified_ip":null, | ||
+ | "parent__modified_date":null, | ||
+ | "parent__record_status":null, | ||
+ | "parent__status":null, | ||
+ | "parent__status_change_dt":null, | ||
+ | "parent__status_sent":null, | ||
+ | "parent__status_custinstructed":null, | ||
+ | "parent__status_custinstructed_ip":null, | ||
+ | "parent__status_custdeclined":null, | ||
+ | "parent__status_custdeclined_ip":null, | ||
+ | "parent__declinereason":null, | ||
+ | "parent__reviewdate":null, | ||
+ | "parent__sendtype":null, | ||
+ | "parent__locked":null, | ||
+ | "parent__customer":null, | ||
+ | "parent__offerpdf":null, | ||
+ | "parent__site_name":null, | ||
+ | "parent__site_lastname":null, | ||
+ | "parent__site_firstname":null, | ||
+ | "parent__site_title":null, | ||
+ | "parent__site_company":null, | ||
+ | "parent__site_zip":null, | ||
+ | "parent__site_city":null, | ||
+ | "parent__site_street":null, | ||
+ | "parent__site_country":null, | ||
+ | "parent__site_email":null, | ||
+ | "parent__site_phone":null, | ||
+ | "parent__site_mobile":null, | ||
+ | "parent__site_fax":null, | ||
+ | "parent__site_vatno":null, | ||
+ | "parent__site_discount":null, | ||
+ | "parent__site_tax":null, | ||
+ | "parent__istemplate":null, | ||
+ | "parent__parent":null, | ||
+ | "parent__newversion":null, | ||
+ | "parent__price":null, | ||
+ | "parent__description":null, | ||
+ | "parent__positionsummary":null, | ||
+ | "parent__reason":null, | ||
+ | "parent__annotation":null, | ||
+ | "parent__startdate":null, | ||
+ | "parent__mainatt":null, | ||
+ | "parent__linkurl":null, | ||
+ | "parent__order":null, | ||
+ | "parent__invoice":null, | ||
+ | "parent__partner":null, | ||
+ | "parent__location":null, | ||
+ | "newversion":"0", | ||
+ | "newversion__id":null, | ||
+ | "newversion__created_user":null, | ||
+ | "newversion__created_ip":null, | ||
+ | "newversion__created_date":null, | ||
+ | "newversion__modified_user":null, | ||
+ | "newversion__modified_ip":null, | ||
+ | "newversion__modified_date":null, | ||
+ | "newversion__record_status":null, | ||
+ | "newversion__status":null, | ||
+ | "newversion__status_change_dt":null, | ||
+ | "newversion__status_sent":null, | ||
+ | "newversion__status_custinstructed":null, | ||
+ | "newversion__status_custinstructed_ip":null, | ||
+ | "newversion__status_custdeclined":null, | ||
+ | "newversion__status_custdeclined_ip":null, | ||
+ | "newversion__declinereason":null, | ||
+ | "newversion__reviewdate":null, | ||
+ | "newversion__sendtype":null, | ||
+ | "newversion__locked":null, | ||
+ | "newversion__customer":null, | ||
+ | "newversion__offerpdf":null, | ||
+ | "newversion__site_name":null, | ||
+ | "newversion__site_lastname":null, | ||
+ | "newversion__site_firstname":null, | ||
+ | "newversion__site_title":null, | ||
+ | "newversion__site_company":null, | ||
+ | "newversion__site_zip":null, | ||
+ | "newversion__site_city":null, | ||
+ | "newversion__site_street":null, | ||
+ | "newversion__site_country":null, | ||
+ | "newversion__site_email":null, | ||
+ | "newversion__site_phone":null, | ||
+ | "newversion__site_mobile":null, | ||
+ | "newversion__site_fax":null, | ||
+ | "newversion__site_vatno":null, | ||
+ | "newversion__site_discount":null, | ||
+ | "newversion__site_tax":null, | ||
+ | "newversion__istemplate":null, | ||
+ | "newversion__parent":null, | ||
+ | "newversion__newversion":null, | ||
+ | "newversion__price":null, | ||
+ | "newversion__description":null, | ||
+ | "newversion__positionsummary":null, | ||
+ | "newversion__reason":null, | ||
+ | "newversion__annotation":null, | ||
+ | "newversion__startdate":null, | ||
+ | "newversion__mainatt":null, | ||
+ | "newversion__linkurl":null, | ||
+ | "newversion__order":null, | ||
+ | "newversion__invoice":null, | ||
+ | "newversion__partner":null, | ||
+ | "newversion__location":null, | ||
+ | "price":"605", | ||
+ | "description":"", | ||
+ | "positionsummary":null, | ||
+ | "reason":"Die angebotene WP mit 11kW ist zu klein dimensioniert.", | ||
+ | "annotation":null, | ||
+ | "startdate":"0", | ||
+ | "mainatt":"0", | ||
+ | "mainatt__id":null, | ||
+ | "mainatt__created_user":null, | ||
+ | "mainatt__created_ip":null, | ||
+ | "mainatt__created_date":null, | ||
+ | "mainatt__modified_user":null, | ||
+ | "mainatt__modified_ip":null, | ||
+ | "mainatt__modified_date":null, | ||
+ | "mainatt__customer":null, | ||
+ | "mainatt__positiongroup":null, | ||
+ | "mainatt__article":null, | ||
+ | "mainatt__offer":null, | ||
+ | "mainatt__order":null, | ||
+ | "mainatt__invoice":null, | ||
+ | "mainatt__dunning":null, | ||
+ | "mainatt__position":null, | ||
+ | "mainatt__user":null, | ||
+ | "mainatt__inoutexpenses":null, | ||
+ | "mainatt__settings":null, | ||
+ | "mainatt__sysevents":null, | ||
+ | "mainatt__direction":null, | ||
+ | "mainatt__type":null, | ||
+ | "mainatt__code":null, | ||
+ | "mainatt__sentdate":null, | ||
+ | "mainatt__readdate":null, | ||
+ | "mainatt__filename":null, | ||
+ | "mainatt__tempname":null, | ||
+ | "mainatt__filetype":null, | ||
+ | "mainatt__summary":null, | ||
+ | "mainatt__description":null, | ||
+ | "mainatt__token":null, | ||
+ | "linkurl":null, | ||
+ | "order":"0", | ||
+ | "order__id":null, | ||
+ | "order__created_user":null, | ||
+ | "order__created_ip":null, | ||
+ | "order__created_date":null, | ||
+ | "order__modified_user":null, | ||
+ | "order__modified_ip":null, | ||
+ | "order__modified_date":null, | ||
+ | "order__record_status":null, | ||
+ | "order__status":null, | ||
+ | "order__status_change_dt":null, | ||
+ | "order__done_dt":null, | ||
+ | "order__locked":null, | ||
+ | "order__customer":null, | ||
+ | "order__orderpdf":null, | ||
+ | "order__site_name":null, | ||
+ | "order__site_lastname":null, | ||
+ | "order__site_firstname":null, | ||
+ | "order__site_title":null, | ||
+ | "order__site_company":null, | ||
+ | "order__site_zip":null, | ||
+ | "order__site_city":null, | ||
+ | "order__site_street":null, | ||
+ | "order__site_country":null, | ||
+ | "order__site_email":null, | ||
+ | "order__site_phone":null, | ||
+ | "order__site_mobile":null, | ||
+ | "order__site_fax":null, | ||
+ | "order__site_vatno":null, | ||
+ | "order__site_discount":null, | ||
+ | "order__site_tax":null, | ||
+ | "order__offer":null, | ||
+ | "order__parent":null, | ||
+ | "order__newversion":null, | ||
+ | "order__price":null, | ||
+ | "order__description":null, | ||
+ | "order__positionsummary":null, | ||
+ | "order__annotation":null, | ||
+ | "order__startdate":null, | ||
+ | "order__enddate":null, | ||
+ | "order__contractenddate":null, | ||
+ | "order__accountingperiod":null, | ||
+ | "order__accountingfirstdate":null, | ||
+ | "order__accountingnextdate":null, | ||
+ | "order__accounting_dayofmonth":null, | ||
+ | "order__ackrequired":null, | ||
+ | "order__lastinvoice":null, | ||
+ | "order__mainatt":null, | ||
+ | "order__linkurl":null, | ||
+ | "order__partner":null, | ||
+ | "order__location":null, | ||
+ | "invoice":"0", | ||
+ | "invoice__id":null, | ||
+ | "invoice__created_user":null, | ||
+ | "invoice__created_ip":null, | ||
+ | "invoice__created_date":null, | ||
+ | "invoice__modified_user":null, | ||
+ | "invoice__modified_ip":null, | ||
+ | "invoice__modified_date":null, | ||
+ | "invoice__record_status":null, | ||
+ | "invoice__status":null, | ||
+ | "invoice__status_change_dt":null, | ||
+ | "invoice__status_sent":null, | ||
+ | "invoice__duepayment_dt":null, | ||
+ | "invoice__invoice_dt":null, | ||
+ | "invoice__sendtype":null, | ||
+ | "invoice__paid_dt":null, | ||
+ | "invoice__locked":null, | ||
+ | "invoice__customer":null, | ||
+ | "invoice__invoicepdf":null, | ||
+ | "invoice__site_name":null, | ||
+ | "invoice__site_lastname":null, | ||
+ | "invoice__site_firstname":null, | ||
+ | "invoice__site_title":null, | ||
+ | "invoice__site_company":null, | ||
+ | "invoice__site_zip":null, | ||
+ | "invoice__site_city":null, | ||
+ | "invoice__site_street":null, | ||
+ | "invoice__site_country":null, | ||
+ | "invoice__site_email":null, | ||
+ | "invoice__site_phone":null, | ||
+ | "invoice__site_mobile":null, | ||
+ | "invoice__site_fax":null, | ||
+ | "invoice__site_vatno":null, | ||
+ | "invoice__site_discount":null, | ||
+ | "invoice__site_tax":null, | ||
+ | "invoice__offer":null, | ||
+ | "invoice__order":null, | ||
+ | "invoice__parent":null, | ||
+ | "invoice__newversion":null, | ||
+ | "invoice__dunning":null, | ||
+ | "invoice__price":null, | ||
+ | "invoice__description":null, | ||
+ | "invoice__positionsummary":null, | ||
+ | "invoice__reason":null, | ||
+ | "invoice__annotation":null, | ||
+ | "invoice__mainatt":null, | ||
+ | "invoice__linkurl":null, | ||
+ | "invoice__partner":null, | ||
+ | "invoice__location":null, | ||
+ | "partner":"0", | ||
+ | "location":"0", | ||
+ | "_representationname":"o1 Franz Seppenberger (Franz Seppenberger KG)", | ||
+ | "created_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "modified_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "customer___representationname":"Herr Franz Seppenberger (Franz Seppenberger OG)", | ||
+ | "offerpdf___representationname":"offer-1-1375285612.pdf", | ||
+ | "parent___representationname":"o ", | ||
+ | "newversion___representationname":"o ", | ||
+ | "mainatt___representationname":"attachment:", | ||
+ | "order___representationname":"n ", | ||
+ | "invoice___representationname":"r ", | ||
+ | "__discount_price_subtract":-15.125, | ||
+ | "__price_sum":589.875, | ||
+ | "__price_sum_wtax":589.875 | ||
+ | },{ | ||
+ | "id":"2", | ||
+ | "created_user":"1", | ||
+ | "created_user__id":"1", | ||
+ | "created_user__created_user":"0", | ||
+ | "created_user__created_ip":null, | ||
+ | "created_user__created_date":"0", | ||
+ | "created_user__modified_user":"1", | ||
+ | "created_user__modified_ip":"10.1.1.214", | ||
+ | "created_user__modified_date":"1422778828", | ||
+ | "created_user__email":"admin@example.com", | ||
+ | "created_user__tel":"+436641234567", | ||
+ | "created_user__username":"admin@example.com", | ||
+ | "created_user__status":"0", | ||
+ | "created_user__status_inactive_dt":"0", | ||
+ | "created_user__accesstype":"1024", | ||
+ | "created_user__firstname":"Chuck", | ||
+ | "created_user__lastname":"Tester", | ||
+ | "created_user__title":"", | ||
+ | "created_user__location_string":null, | ||
+ | "created_user__location_privacy":"0", | ||
+ | "created_user__location":"0", | ||
+ | "created_user__location_street":"", | ||
+ | "created_user__location_city":"", | ||
+ | "created_user__location_zip":"0", | ||
+ | "created_user__location_country":"", | ||
+ | "created_user__partner":"0", | ||
+ | "created_ip":"10.1.1.56", | ||
+ | "created_date":"1373989920", | ||
+ | "modified_user":"1", | ||
+ | "modified_user__id":"1", | ||
+ | "modified_user__created_user":"0", | ||
+ | "modified_user__created_ip":null, | ||
+ | "modified_user__created_date":"0", | ||
+ | "modified_user__modified_user":"1", | ||
+ | "modified_user__modified_ip":"10.1.1.214", | ||
+ | "modified_user__modified_date":"1422778828", | ||
+ | "modified_user__email":"admin@example.com", | ||
+ | "modified_user__tel":"+436641234567", | ||
+ | "modified_user__username":"admin@example.com", | ||
+ | "modified_user__status":"0", | ||
+ | "modified_user__status_inactive_dt":"0", | ||
+ | "modified_user__accesstype":"1024", | ||
+ | "modified_user__firstname":"Chuck", | ||
+ | "modified_user__lastname":"Tester", | ||
+ | "modified_user__title":"", | ||
+ | "modified_user__location_string":null, | ||
+ | "modified_user__location_privacy":"0", | ||
+ | "modified_user__location":"0", | ||
+ | "modified_user__location_street":"", | ||
+ | "modified_user__location_city":"", | ||
+ | "modified_user__location_zip":"0", | ||
+ | "modified_user__location_country":"", | ||
+ | "modified_user__partner":"0", | ||
+ | "modified_ip":"10.1.1.56", | ||
+ | "modified_date":"1375963059", | ||
+ | "record_status":"0", | ||
+ | "status":"2", | ||
+ | "status_change_dt":"0", | ||
+ | "status_sent":"1375963059", | ||
+ | "status_custinstructed":"0", | ||
+ | "status_custinstructed_ip":null, | ||
+ | "status_custdeclined":"0", | ||
+ | "status_custdeclined_ip":null, | ||
+ | "declinereason":"0", | ||
+ | "reviewdate":"1377122400", | ||
+ | "sendtype":"1", | ||
+ | "locked":"1", | ||
+ | "customer":"1", | ||
+ | "customer__id":"1", | ||
+ | "customer__created_user":"1", | ||
+ | "customer__created_ip":"10.1.1.56", | ||
+ | "customer__created_date":"1373982680", | ||
+ | "customer__modified_user":"0", | ||
+ | "customer__modified_ip":"LOCALEXEC", | ||
+ | "customer__modified_date":"1432724983", | ||
+ | "customer__record_status":"0", | ||
+ | "customer__status":"0", | ||
+ | "customer__status_change_dt":"0", | ||
+ | "customer__ctype":"0", | ||
+ | "customer__lastname":"Mustermann", | ||
+ | "customer__firstname":"Leo", | ||
+ | "customer__title":"1", | ||
+ | "customer__company":"Mustermann Idea Consulting GmbH", | ||
+ | "customer__comboname":"Fa. Mustermann Idea Consulting GmbH \/ Herr Leo Mustermann ", | ||
+ | "customer__comboname2":null, | ||
+ | "customer__zip":"2432", | ||
+ | "customer__city":"Schwadorf", | ||
+ | "customer__street":"Musterstrasse 3b", | ||
+ | "customer__country":"\u00d6sterreich", | ||
+ | "customer__email":"", | ||
+ | "customer__phone":"01\/4540085", | ||
+ | "customer__mobile":"", | ||
+ | "customer__fax":"", | ||
+ | "customer__web":"", | ||
+ | "customer__vatno":null, | ||
+ | "customer__code":null, | ||
+ | "customer__paymenttype":null, | ||
+ | "customer__paymentinfo":null, | ||
+ | "customer__annexoffer":null, | ||
+ | "customer__annexinvoice":null, | ||
+ | "customer__discount":"0", | ||
+ | "customer__tax":"0", | ||
+ | "customer__description":null, | ||
+ | "customer__istemplate":"0", | ||
+ | "customer__mainatt":"0", | ||
+ | "customer__lastcorrespondence":"161", | ||
+ | "customer__linkurl":null, | ||
+ | "customer__salesuser":"0", | ||
+ | "customer__partner":"0", | ||
+ | "customer__partnerrevenueshare":"0", | ||
+ | "customer__location":"0", | ||
+ | "offerpdf":"41", | ||
+ | "offerpdf__id":"41", | ||
+ | "offerpdf__created_user":"1", | ||
+ | "offerpdf__created_ip":"10.1.1.56", | ||
+ | "offerpdf__created_date":"1375963059", | ||
+ | "offerpdf__modified_user":"1", | ||
+ | "offerpdf__modified_ip":"10.1.1.56", | ||
+ | "offerpdf__modified_date":"1375963059", | ||
+ | "offerpdf__customer":"0", | ||
+ | "offerpdf__positiongroup":"0", | ||
+ | "offerpdf__article":"0", | ||
+ | "offerpdf__offer":"2", | ||
+ | "offerpdf__order":"0", | ||
+ | "offerpdf__invoice":"0", | ||
+ | "offerpdf__dunning":"0", | ||
+ | "offerpdf__position":"0", | ||
+ | "offerpdf__user":"0", | ||
+ | "offerpdf__inoutexpenses":"0", | ||
+ | "offerpdf__settings":"", | ||
+ | "offerpdf__sysevents":"0", | ||
+ | "offerpdf__direction":"0", | ||
+ | "offerpdf__type":"3", | ||
+ | "offerpdf__code":null, | ||
+ | "offerpdf__sentdate":"0", | ||
+ | "offerpdf__readdate":"0", | ||
+ | "offerpdf__filename":"offer-2-1375963059.pdf", | ||
+ | "offerpdf__tempname":"00000\/41", | ||
+ | "offerpdf__filetype":"21", | ||
+ | "offerpdf__summary":null, | ||
+ | "offerpdf__description":null, | ||
+ | "offerpdf__token":"2a943a764108ed053bb63a0029980fd7", | ||
+ | "site_name":"Herr Leo Mustermann", | ||
+ | "site_lastname":null, | ||
+ | "site_firstname":null, | ||
+ | "site_title":"0", | ||
+ | "site_company":"", | ||
+ | "site_zip":"2432", | ||
+ | "site_city":"Schwadorf", | ||
+ | "site_street":"Musterstrasse 6", | ||
+ | "site_country":"\u00d6sterreich", | ||
+ | "site_email":"leo@Mustermann.at", | ||
+ | "site_phone":"", | ||
+ | "site_mobile":"02\/mobil", | ||
+ | "site_fax":"03\/fax", | ||
+ | "site_vatno":null, | ||
+ | "site_discount":"3.5", | ||
+ | "site_tax":"0", | ||
+ | "istemplate":"0", | ||
+ | "parent":"0", | ||
+ | "parent__id":null, | ||
+ | "parent__created_user":null, | ||
+ | "parent__created_ip":null, | ||
+ | "parent__created_date":null, | ||
+ | "parent__modified_user":null, | ||
+ | "parent__modified_ip":null, | ||
+ | "parent__modified_date":null, | ||
+ | "parent__record_status":null, | ||
+ | "parent__status":null, | ||
+ | "parent__status_change_dt":null, | ||
+ | "parent__status_sent":null, | ||
+ | "parent__status_custinstructed":null, | ||
+ | "parent__status_custinstructed_ip":null, | ||
+ | "parent__status_custdeclined":null, | ||
+ | "parent__status_custdeclined_ip":null, | ||
+ | "parent__declinereason":null, | ||
+ | "parent__reviewdate":null, | ||
+ | "parent__sendtype":null, | ||
+ | "parent__locked":null, | ||
+ | "parent__customer":null, | ||
+ | "parent__offerpdf":null, | ||
+ | "parent__site_name":null, | ||
+ | "parent__site_lastname":null, | ||
+ | "parent__site_firstname":null, | ||
+ | "parent__site_title":null, | ||
+ | "parent__site_company":null, | ||
+ | "parent__site_zip":null, | ||
+ | "parent__site_city":null, | ||
+ | "parent__site_street":null, | ||
+ | "parent__site_country":null, | ||
+ | "parent__site_email":null, | ||
+ | "parent__site_phone":null, | ||
+ | "parent__site_mobile":null, | ||
+ | "parent__site_fax":null, | ||
+ | "parent__site_vatno":null, | ||
+ | "parent__site_discount":null, | ||
+ | "parent__site_tax":null, | ||
+ | "parent__istemplate":null, | ||
+ | "parent__parent":null, | ||
+ | "parent__newversion":null, | ||
+ | "parent__price":null, | ||
+ | "parent__description":null, | ||
+ | "parent__positionsummary":null, | ||
+ | "parent__reason":null, | ||
+ | "parent__annotation":null, | ||
+ | "parent__startdate":null, | ||
+ | "parent__mainatt":null, | ||
+ | "parent__linkurl":null, | ||
+ | "parent__order":null, | ||
+ | "parent__invoice":null, | ||
+ | "parent__partner":null, | ||
+ | "parent__location":null, | ||
+ | "newversion":"0", | ||
+ | "newversion__id":null, | ||
+ | "newversion__created_user":null, | ||
+ | "newversion__created_ip":null, | ||
+ | "newversion__created_date":null, | ||
+ | "newversion__modified_user":null, | ||
+ | "newversion__modified_ip":null, | ||
+ | "newversion__modified_date":null, | ||
+ | "newversion__record_status":null, | ||
+ | "newversion__status":null, | ||
+ | "newversion__status_change_dt":null, | ||
+ | "newversion__status_sent":null, | ||
+ | "newversion__status_custinstructed":null, | ||
+ | "newversion__status_custinstructed_ip":null, | ||
+ | "newversion__status_custdeclined":null, | ||
+ | "newversion__status_custdeclined_ip":null, | ||
+ | "newversion__declinereason":null, | ||
+ | "newversion__reviewdate":null, | ||
+ | "newversion__sendtype":null, | ||
+ | "newversion__locked":null, | ||
+ | "newversion__customer":null, | ||
+ | "newversion__offerpdf":null, | ||
+ | "newversion__site_name":null, | ||
+ | "newversion__site_lastname":null, | ||
+ | "newversion__site_firstname":null, | ||
+ | "newversion__site_title":null, | ||
+ | "newversion__site_company":null, | ||
+ | "newversion__site_zip":null, | ||
+ | "newversion__site_city":null, | ||
+ | "newversion__site_street":null, | ||
+ | "newversion__site_country":null, | ||
+ | "newversion__site_email":null, | ||
+ | "newversion__site_phone":null, | ||
+ | "newversion__site_mobile":null, | ||
+ | "newversion__site_fax":null, | ||
+ | "newversion__site_vatno":null, | ||
+ | "newversion__site_discount":null, | ||
+ | "newversion__site_tax":null, | ||
+ | "newversion__istemplate":null, | ||
+ | "newversion__parent":null, | ||
+ | "newversion__newversion":null, | ||
+ | "newversion__price":null, | ||
+ | "newversion__description":null, | ||
+ | "newversion__positionsummary":null, | ||
+ | "newversion__reason":null, | ||
+ | "newversion__annotation":null, | ||
+ | "newversion__startdate":null, | ||
+ | "newversion__mainatt":null, | ||
+ | "newversion__linkurl":null, | ||
+ | "newversion__order":null, | ||
+ | "newversion__invoice":null, | ||
+ | "newversion__partner":null, | ||
+ | "newversion__location":null, | ||
+ | "price":"0", | ||
+ | "description":"Komische Sache\r\nN\u00e4chste Zeile\r\nUnd jetzt ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und ganz viel Tex und", | ||
+ | "positionsummary":null, | ||
+ | "reason":null, | ||
+ | "annotation":null, | ||
+ | "startdate":"0", | ||
+ | "mainatt":"0", | ||
+ | "mainatt__id":null, | ||
+ | "mainatt__created_user":null, | ||
+ | "mainatt__created_ip":null, | ||
+ | "mainatt__created_date":null, | ||
+ | "mainatt__modified_user":null, | ||
+ | "mainatt__modified_ip":null, | ||
+ | "mainatt__modified_date":null, | ||
+ | "mainatt__customer":null, | ||
+ | "mainatt__positiongroup":null, | ||
+ | "mainatt__article":null, | ||
+ | "mainatt__offer":null, | ||
+ | "mainatt__order":null, | ||
+ | "mainatt__invoice":null, | ||
+ | "mainatt__dunning":null, | ||
+ | "mainatt__position":null, | ||
+ | "mainatt__user":null, | ||
+ | "mainatt__inoutexpenses":null, | ||
+ | "mainatt__settings":null, | ||
+ | "mainatt__sysevents":null, | ||
+ | "mainatt__direction":null, | ||
+ | "mainatt__type":null, | ||
+ | "mainatt__code":null, | ||
+ | "mainatt__sentdate":null, | ||
+ | "mainatt__readdate":null, | ||
+ | "mainatt__filename":null, | ||
+ | "mainatt__tempname":null, | ||
+ | "mainatt__filetype":null, | ||
+ | "mainatt__summary":null, | ||
+ | "mainatt__description":null, | ||
+ | "mainatt__token":null, | ||
+ | "linkurl":null, | ||
+ | "order":"0", | ||
+ | "order__id":null, | ||
+ | "order__created_user":null, | ||
+ | "order__created_ip":null, | ||
+ | "order__created_date":null, | ||
+ | "order__modified_user":null, | ||
+ | "order__modified_ip":null, | ||
+ | "order__modified_date":null, | ||
+ | "order__record_status":null, | ||
+ | "order__status":null, | ||
+ | "order__status_change_dt":null, | ||
+ | "order__done_dt":null, | ||
+ | "order__locked":null, | ||
+ | "order__customer":null, | ||
+ | "order__orderpdf":null, | ||
+ | "order__site_name":null, | ||
+ | "order__site_lastname":null, | ||
+ | "order__site_firstname":null, | ||
+ | "order__site_title":null, | ||
+ | "order__site_company":null, | ||
+ | "order__site_zip":null, | ||
+ | "order__site_city":null, | ||
+ | "order__site_street":null, | ||
+ | "order__site_country":null, | ||
+ | "order__site_email":null, | ||
+ | "order__site_phone":null, | ||
+ | "order__site_mobile":null, | ||
+ | "order__site_fax":null, | ||
+ | "order__site_vatno":null, | ||
+ | "order__site_discount":null, | ||
+ | "order__site_tax":null, | ||
+ | "order__offer":null, | ||
+ | "order__parent":null, | ||
+ | "order__newversion":null, | ||
+ | "order__price":null, | ||
+ | "order__description":null, | ||
+ | "order__positionsummary":null, | ||
+ | "order__annotation":null, | ||
+ | "order__startdate":null, | ||
+ | "order__enddate":null, | ||
+ | "order__contractenddate":null, | ||
+ | "order__accountingperiod":null, | ||
+ | "order__accountingfirstdate":null, | ||
+ | "order__accountingnextdate":null, | ||
+ | "order__accounting_dayofmonth":null, | ||
+ | "order__ackrequired":null, | ||
+ | "order__lastinvoice":null, | ||
+ | "order__mainatt":null, | ||
+ | "order__linkurl":null, | ||
+ | "order__partner":null, | ||
+ | "order__location":null, | ||
+ | "invoice":"0", | ||
+ | "invoice__id":null, | ||
+ | "invoice__created_user":null, | ||
+ | "invoice__created_ip":null, | ||
+ | "invoice__created_date":null, | ||
+ | "invoice__modified_user":null, | ||
+ | "invoice__modified_ip":null, | ||
+ | "invoice__modified_date":null, | ||
+ | "invoice__record_status":null, | ||
+ | "invoice__status":null, | ||
+ | "invoice__status_change_dt":null, | ||
+ | "invoice__status_sent":null, | ||
+ | "invoice__duepayment_dt":null, | ||
+ | "invoice__invoice_dt":null, | ||
+ | "invoice__sendtype":null, | ||
+ | "invoice__paid_dt":null, | ||
+ | "invoice__locked":null, | ||
+ | "invoice__customer":null, | ||
+ | "invoice__invoicepdf":null, | ||
+ | "invoice__site_name":null, | ||
+ | "invoice__site_lastname":null, | ||
+ | "invoice__site_firstname":null, | ||
+ | "invoice__site_title":null, | ||
+ | "invoice__site_company":null, | ||
+ | "invoice__site_zip":null, | ||
+ | "invoice__site_city":null, | ||
+ | "invoice__site_street":null, | ||
+ | "invoice__site_country":null, | ||
+ | "invoice__site_email":null, | ||
+ | "invoice__site_phone":null, | ||
+ | "invoice__site_mobile":null, | ||
+ | "invoice__site_fax":null, | ||
+ | "invoice__site_vatno":null, | ||
+ | "invoice__site_discount":null, | ||
+ | "invoice__site_tax":null, | ||
+ | "invoice__offer":null, | ||
+ | "invoice__order":null, | ||
+ | "invoice__parent":null, | ||
+ | "invoice__newversion":null, | ||
+ | "invoice__dunning":null, | ||
+ | "invoice__price":null, | ||
+ | "invoice__description":null, | ||
+ | "invoice__positionsummary":null, | ||
+ | "invoice__reason":null, | ||
+ | "invoice__annotation":null, | ||
+ | "invoice__mainatt":null, | ||
+ | "invoice__linkurl":null, | ||
+ | "invoice__partner":null, | ||
+ | "invoice__location":null, | ||
+ | "partner":"0", | ||
+ | "location":"0", | ||
+ | "_representationname":"o2 Herr Leo Mustermann ", | ||
+ | "created_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "modified_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "customer___representationname":"Herr Leo Mustermann (Mustermann Idea Consulting GmbH)", | ||
+ | "offerpdf___representationname":"offer-2-1375963059.pdf", | ||
+ | "parent___representationname":"o ", | ||
+ | "newversion___representationname":"o ", | ||
+ | "mainatt___representationname":"attachment:", | ||
+ | "order___representationname":"n ", | ||
+ | "invoice___representationname":"r ", | ||
+ | "__discount_price_subtract":-0, | ||
+ | "__price_sum":0, | ||
+ | "__price_sum_wtax":0 | ||
+ | },{ | ||
+ | "id":"3", | ||
+ | "created_user":"1", | ||
+ | "created_user__id":"1", | ||
+ | "created_user__created_user":"0", | ||
+ | "created_user__created_ip":null, | ||
+ | "created_user__created_date":"0", | ||
+ | "created_user__modified_user":"1", | ||
+ | "created_user__modified_ip":"10.1.1.214", | ||
+ | "created_user__modified_date":"1422778828", | ||
+ | "created_user__email":"admin@example.com", | ||
+ | "created_user__tel":"+436641234567", | ||
+ | "created_user__username":"admin@example.com", | ||
+ | "created_user__status":"0", | ||
+ | "created_user__status_inactive_dt":"0", | ||
+ | "created_user__accesstype":"1024", | ||
+ | "created_user__firstname":"Chuck", | ||
+ | "created_user__lastname":"Tester", | ||
+ | "created_user__title":"", | ||
+ | "created_user__location_string":null, | ||
+ | "created_user__location_privacy":"0", | ||
+ | "created_user__location":"0", | ||
+ | "created_user__location_street":"", | ||
+ | "created_user__location_city":"", | ||
+ | "created_user__location_zip":"0", | ||
+ | "created_user__location_country":"", | ||
+ | "created_user__partner":"0", | ||
+ | "created_ip":"10.1.1.56", | ||
+ | "created_date":"1373990781", | ||
+ | "modified_user":"1", | ||
+ | "modified_user__id":"1", | ||
+ | "modified_user__created_user":"0", | ||
+ | "modified_user__created_ip":null, | ||
+ | "modified_user__created_date":"0", | ||
+ | "modified_user__modified_user":"1", | ||
+ | "modified_user__modified_ip":"10.1.1.214", | ||
+ | "modified_user__modified_date":"1422778828", | ||
+ | "modified_user__email":"admin@example.com", | ||
+ | "modified_user__tel":"+436641234567", | ||
+ | "modified_user__username":"admin@example.com", | ||
+ | "modified_user__status":"0", | ||
+ | "modified_user__status_inactive_dt":"0", | ||
+ | "modified_user__accesstype":"1024", | ||
+ | "modified_user__firstname":"Chuck", | ||
+ | "modified_user__lastname":"Tester", | ||
+ | "modified_user__title":"", | ||
+ | "modified_user__location_string":null, | ||
+ | "modified_user__location_privacy":"0", | ||
+ | "modified_user__location":"0", | ||
+ | "modified_user__location_street":"", | ||
+ | "modified_user__location_city":"", | ||
+ | "modified_user__location_zip":"0", | ||
+ | "modified_user__location_country":"", | ||
+ | "modified_user__partner":"0", | ||
+ | "modified_ip":"10.1.1.56", | ||
+ | "modified_date":"1375451044", | ||
+ | "record_status":"0", | ||
+ | "status":"0", | ||
+ | "status_change_dt":"0", | ||
+ | "status_sent":"0", | ||
+ | "status_custinstructed":"0", | ||
+ | "status_custinstructed_ip":null, | ||
+ | "status_custdeclined":"0", | ||
+ | "status_custdeclined_ip":null, | ||
+ | "declinereason":"0", | ||
+ | "reviewdate":"0", | ||
+ | "sendtype":"0", | ||
+ | "locked":"0", | ||
+ | "customer":"4", | ||
+ | "customer__id":"4", | ||
+ | "customer__created_user":"1", | ||
+ | "customer__created_ip":"10.1.1.56", | ||
+ | "customer__created_date":"1373982893", | ||
+ | "customer__modified_user":"1", | ||
+ | "customer__modified_ip":"10.1.1.56", | ||
+ | "customer__modified_date":"1430919850", | ||
+ | "customer__record_status":"0", | ||
+ | "customer__status":"0", | ||
+ | "customer__status_change_dt":"0", | ||
+ | "customer__ctype":"0", | ||
+ | "customer__lastname":"Nudlinger", | ||
+ | "customer__firstname":"Franz", | ||
+ | "customer__title":"1", | ||
+ | "customer__company":"Nudelsoup KG", | ||
+ | "customer__comboname":"Fa. Nudelsoup KG \/ Herr Franz Nudlinger ", | ||
+ | "customer__comboname2":null, | ||
+ | "customer__zip":"0", | ||
+ | "customer__city":"", | ||
+ | "customer__street":"", | ||
+ | "customer__country":"", | ||
+ | "customer__email":"nudelsoup@example.com", | ||
+ | "customer__phone":"", | ||
+ | "customer__mobile":"", | ||
+ | "customer__fax":"", | ||
+ | "customer__web":"", | ||
+ | "customer__vatno":null, | ||
+ | "customer__code":null, | ||
+ | "customer__paymenttype":null, | ||
+ | "customer__paymentinfo":null, | ||
+ | "customer__annexoffer":null, | ||
+ | "customer__annexinvoice":null, | ||
+ | "customer__discount":"0", | ||
+ | "customer__tax":"0", | ||
+ | "customer__description":null, | ||
+ | "customer__istemplate":"0", | ||
+ | "customer__mainatt":"0", | ||
+ | "customer__lastcorrespondence":"155", | ||
+ | "customer__linkurl":null, | ||
+ | "customer__salesuser":"0", | ||
+ | "customer__partner":"0", | ||
+ | "customer__partnerrevenueshare":"0", | ||
+ | "customer__location":"0", | ||
+ | "offerpdf":"0", | ||
+ | "offerpdf__id":null, | ||
+ | "offerpdf__created_user":null, | ||
+ | "offerpdf__created_ip":null, | ||
+ | "offerpdf__created_date":null, | ||
+ | "offerpdf__modified_user":null, | ||
+ | "offerpdf__modified_ip":null, | ||
+ | "offerpdf__modified_date":null, | ||
+ | "offerpdf__customer":null, | ||
+ | "offerpdf__positiongroup":null, | ||
+ | "offerpdf__article":null, | ||
+ | "offerpdf__offer":null, | ||
+ | "offerpdf__order":null, | ||
+ | "offerpdf__invoice":null, | ||
+ | "offerpdf__dunning":null, | ||
+ | "offerpdf__position":null, | ||
+ | "offerpdf__user":null, | ||
+ | "offerpdf__inoutexpenses":null, | ||
+ | "offerpdf__settings":null, | ||
+ | "offerpdf__sysevents":null, | ||
+ | "offerpdf__direction":null, | ||
+ | "offerpdf__type":null, | ||
+ | "offerpdf__code":null, | ||
+ | "offerpdf__sentdate":null, | ||
+ | "offerpdf__readdate":null, | ||
+ | "offerpdf__filename":null, | ||
+ | "offerpdf__tempname":null, | ||
+ | "offerpdf__filetype":null, | ||
+ | "offerpdf__summary":null, | ||
+ | "offerpdf__description":null, | ||
+ | "offerpdf__token":null, | ||
+ | "site_name":"", | ||
+ | "site_lastname":null, | ||
+ | "site_firstname":null, | ||
+ | "site_title":"0", | ||
+ | "site_company":"Nudelsuppen KG", | ||
+ | "site_zip":"0", | ||
+ | "site_city":"", | ||
+ | "site_street":"", | ||
+ | "site_country":"", | ||
+ | "site_email":"", | ||
+ | "site_phone":"call me other", | ||
+ | "site_mobile":"", | ||
+ | "site_fax":"", | ||
+ | "site_vatno":null, | ||
+ | "site_discount":"0", | ||
+ | "site_tax":"0", | ||
+ | "istemplate":"0", | ||
+ | "parent":"0", | ||
+ | "parent__id":null, | ||
+ | "parent__created_user":null, | ||
+ | "parent__created_ip":null, | ||
+ | "parent__created_date":null, | ||
+ | "parent__modified_user":null, | ||
+ | "parent__modified_ip":null, | ||
+ | "parent__modified_date":null, | ||
+ | "parent__record_status":null, | ||
+ | "parent__status":null, | ||
+ | "parent__status_change_dt":null, | ||
+ | "parent__status_sent":null, | ||
+ | "parent__status_custinstructed":null, | ||
+ | "parent__status_custinstructed_ip":null, | ||
+ | "parent__status_custdeclined":null, | ||
+ | "parent__status_custdeclined_ip":null, | ||
+ | "parent__declinereason":null, | ||
+ | "parent__reviewdate":null, | ||
+ | "parent__sendtype":null, | ||
+ | "parent__locked":null, | ||
+ | "parent__customer":null, | ||
+ | "parent__offerpdf":null, | ||
+ | "parent__site_name":null, | ||
+ | "parent__site_lastname":null, | ||
+ | "parent__site_firstname":null, | ||
+ | "parent__site_title":null, | ||
+ | "parent__site_company":null, | ||
+ | "parent__site_zip":null, | ||
+ | "parent__site_city":null, | ||
+ | "parent__site_street":null, | ||
+ | "parent__site_country":null, | ||
+ | "parent__site_email":null, | ||
+ | "parent__site_phone":null, | ||
+ | "parent__site_mobile":null, | ||
+ | "parent__site_fax":null, | ||
+ | "parent__site_vatno":null, | ||
+ | "parent__site_discount":null, | ||
+ | "parent__site_tax":null, | ||
+ | "parent__istemplate":null, | ||
+ | "parent__parent":null, | ||
+ | "parent__newversion":null, | ||
+ | "parent__price":null, | ||
+ | "parent__description":null, | ||
+ | "parent__positionsummary":null, | ||
+ | "parent__reason":null, | ||
+ | "parent__annotation":null, | ||
+ | "parent__startdate":null, | ||
+ | "parent__mainatt":null, | ||
+ | "parent__linkurl":null, | ||
+ | "parent__order":null, | ||
+ | "parent__invoice":null, | ||
+ | "parent__partner":null, | ||
+ | "parent__location":null, | ||
+ | "newversion":"0", | ||
+ | "newversion__id":null, | ||
+ | "newversion__created_user":null, | ||
+ | "newversion__created_ip":null, | ||
+ | "newversion__created_date":null, | ||
+ | "newversion__modified_user":null, | ||
+ | "newversion__modified_ip":null, | ||
+ | "newversion__modified_date":null, | ||
+ | "newversion__record_status":null, | ||
+ | "newversion__status":null, | ||
+ | "newversion__status_change_dt":null, | ||
+ | "newversion__status_sent":null, | ||
+ | "newversion__status_custinstructed":null, | ||
+ | "newversion__status_custinstructed_ip":null, | ||
+ | "newversion__status_custdeclined":null, | ||
+ | "newversion__status_custdeclined_ip":null, | ||
+ | "newversion__declinereason":null, | ||
+ | "newversion__reviewdate":null, | ||
+ | "newversion__sendtype":null, | ||
+ | "newversion__locked":null, | ||
+ | "newversion__customer":null, | ||
+ | "newversion__offerpdf":null, | ||
+ | "newversion__site_name":null, | ||
+ | "newversion__site_lastname":null, | ||
+ | "newversion__site_firstname":null, | ||
+ | "newversion__site_title":null, | ||
+ | "newversion__site_company":null, | ||
+ | "newversion__site_zip":null, | ||
+ | "newversion__site_city":null, | ||
+ | "newversion__site_street":null, | ||
+ | "newversion__site_country":null, | ||
+ | "newversion__site_email":null, | ||
+ | "newversion__site_phone":null, | ||
+ | "newversion__site_mobile":null, | ||
+ | "newversion__site_fax":null, | ||
+ | "newversion__site_vatno":null, | ||
+ | "newversion__site_discount":null, | ||
+ | "newversion__site_tax":null, | ||
+ | "newversion__istemplate":null, | ||
+ | "newversion__parent":null, | ||
+ | "newversion__newversion":null, | ||
+ | "newversion__price":null, | ||
+ | "newversion__description":null, | ||
+ | "newversion__positionsummary":null, | ||
+ | "newversion__reason":null, | ||
+ | "newversion__annotation":null, | ||
+ | "newversion__startdate":null, | ||
+ | "newversion__mainatt":null, | ||
+ | "newversion__linkurl":null, | ||
+ | "newversion__order":null, | ||
+ | "newversion__invoice":null, | ||
+ | "newversion__partner":null, | ||
+ | "newversion__location":null, | ||
+ | "price":"3150.35", | ||
+ | "description":"", | ||
+ | "positionsummary":null, | ||
+ | "reason":null, | ||
+ | "annotation":null, | ||
+ | "startdate":"0", | ||
+ | "mainatt":"0", | ||
+ | "mainatt__id":null, | ||
+ | "mainatt__created_user":null, | ||
+ | "mainatt__created_ip":null, | ||
+ | "mainatt__created_date":null, | ||
+ | "mainatt__modified_user":null, | ||
+ | "mainatt__modified_ip":null, | ||
+ | "mainatt__modified_date":null, | ||
+ | "mainatt__customer":null, | ||
+ | "mainatt__positiongroup":null, | ||
+ | "mainatt__article":null, | ||
+ | "mainatt__offer":null, | ||
+ | "mainatt__order":null, | ||
+ | "mainatt__invoice":null, | ||
+ | "mainatt__dunning":null, | ||
+ | "mainatt__position":null, | ||
+ | "mainatt__user":null, | ||
+ | "mainatt__inoutexpenses":null, | ||
+ | "mainatt__settings":null, | ||
+ | "mainatt__sysevents":null, | ||
+ | "mainatt__direction":null, | ||
+ | "mainatt__type":null, | ||
+ | "mainatt__code":null, | ||
+ | "mainatt__sentdate":null, | ||
+ | "mainatt__readdate":null, | ||
+ | "mainatt__filename":null, | ||
+ | "mainatt__tempname":null, | ||
+ | "mainatt__filetype":null, | ||
+ | "mainatt__summary":null, | ||
+ | "mainatt__description":null, | ||
+ | "mainatt__token":null, | ||
+ | "linkurl":null, | ||
+ | "order":"0", | ||
+ | "order__id":null, | ||
+ | "order__created_user":null, | ||
+ | "order__created_ip":null, | ||
+ | "order__created_date":null, | ||
+ | "order__modified_user":null, | ||
+ | "order__modified_ip":null, | ||
+ | "order__modified_date":null, | ||
+ | "order__record_status":null, | ||
+ | "order__status":null, | ||
+ | "order__status_change_dt":null, | ||
+ | "order__done_dt":null, | ||
+ | "order__locked":null, | ||
+ | "order__customer":null, | ||
+ | "order__orderpdf":null, | ||
+ | "order__site_name":null, | ||
+ | "order__site_lastname":null, | ||
+ | "order__site_firstname":null, | ||
+ | "order__site_title":null, | ||
+ | "order__site_company":null, | ||
+ | "order__site_zip":null, | ||
+ | "order__site_city":null, | ||
+ | "order__site_street":null, | ||
+ | "order__site_country":null, | ||
+ | "order__site_email":null, | ||
+ | "order__site_phone":null, | ||
+ | "order__site_mobile":null, | ||
+ | "order__site_fax":null, | ||
+ | "order__site_vatno":null, | ||
+ | "order__site_discount":null, | ||
+ | "order__site_tax":null, | ||
+ | "order__offer":null, | ||
+ | "order__parent":null, | ||
+ | "order__newversion":null, | ||
+ | "order__price":null, | ||
+ | "order__description":null, | ||
+ | "order__positionsummary":null, | ||
+ | "order__annotation":null, | ||
+ | "order__startdate":null, | ||
+ | "order__enddate":null, | ||
+ | "order__contractenddate":null, | ||
+ | "order__accountingperiod":null, | ||
+ | "order__accountingfirstdate":null, | ||
+ | "order__accountingnextdate":null, | ||
+ | "order__accounting_dayofmonth":null, | ||
+ | "order__ackrequired":null, | ||
+ | "order__lastinvoice":null, | ||
+ | "order__mainatt":null, | ||
+ | "order__linkurl":null, | ||
+ | "order__partner":null, | ||
+ | "order__location":null, | ||
+ | "invoice":"0", | ||
+ | "invoice__id":null, | ||
+ | "invoice__created_user":null, | ||
+ | "invoice__created_ip":null, | ||
+ | "invoice__created_date":null, | ||
+ | "invoice__modified_user":null, | ||
+ | "invoice__modified_ip":null, | ||
+ | "invoice__modified_date":null, | ||
+ | "invoice__record_status":null, | ||
+ | "invoice__status":null, | ||
+ | "invoice__status_change_dt":null, | ||
+ | "invoice__status_sent":null, | ||
+ | "invoice__duepayment_dt":null, | ||
+ | "invoice__invoice_dt":null, | ||
+ | "invoice__sendtype":null, | ||
+ | "invoice__paid_dt":null, | ||
+ | "invoice__locked":null, | ||
+ | "invoice__customer":null, | ||
+ | "invoice__invoicepdf":null, | ||
+ | "invoice__site_name":null, | ||
+ | "invoice__site_lastname":null, | ||
+ | "invoice__site_firstname":null, | ||
+ | "invoice__site_title":null, | ||
+ | "invoice__site_company":null, | ||
+ | "invoice__site_zip":null, | ||
+ | "invoice__site_city":null, | ||
+ | "invoice__site_street":null, | ||
+ | "invoice__site_country":null, | ||
+ | "invoice__site_email":null, | ||
+ | "invoice__site_phone":null, | ||
+ | "invoice__site_mobile":null, | ||
+ | "invoice__site_fax":null, | ||
+ | "invoice__site_vatno":null, | ||
+ | "invoice__site_discount":null, | ||
+ | "invoice__site_tax":null, | ||
+ | "invoice__offer":null, | ||
+ | "invoice__order":null, | ||
+ | "invoice__parent":null, | ||
+ | "invoice__newversion":null, | ||
+ | "invoice__dunning":null, | ||
+ | "invoice__price":null, | ||
+ | "invoice__description":null, | ||
+ | "invoice__positionsummary":null, | ||
+ | "invoice__reason":null, | ||
+ | "invoice__annotation":null, | ||
+ | "invoice__mainatt":null, | ||
+ | "invoice__linkurl":null, | ||
+ | "invoice__partner":null, | ||
+ | "invoice__location":null, | ||
+ | "partner":"0", | ||
+ | "location":"0", | ||
+ | "_representationname":"o3 Nudelsuppen KG", | ||
+ | "created_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "modified_user___representationname":"admin@example.com (Tester, Chuck)", | ||
+ | "customer___representationname":"Herr Franz Nudlinger (Nudelsoup KG)", | ||
+ | "offerpdf___representationname":"attachment:", | ||
+ | "parent___representationname":"o ", | ||
+ | "newversion___representationname":"o ", | ||
+ | "mainatt___representationname":"attachment:", | ||
+ | "order___representationname":"n ", | ||
+ | "invoice___representationname":"r ", | ||
+ | "__discount_price_subtract":-0, | ||
+ | "__price_sum":3150.35, | ||
+ | "__price_sum_wtax":3150.35 | ||
+ | }], | ||
+ | "count":"470", | ||
+ | "pages":157, | ||
+ | "page":0, | ||
+ | "perpage":"3", | ||
+ | "errormsg":[] | ||
+ | } | ||
+ | </code> | ||