====== offer-cube Entwickler Webservice Dokumentation ====== Zurück zur [[offer-cube:webservice|Webservice Dokumentation Startseite]] ====== Basisoperation /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 ^ | = | Das angegebene Feld muss dem Wert value entsprechen | | = | Das angegebene Feld muss dem Wert value entsprechen | | = | 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) { "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":[] }