{"id":460,"date":"2019-10-30T06:27:47","date_gmt":"2019-10-30T06:27:47","guid":{"rendered":"http:\/\/flace.de\/?p=460"},"modified":"2025-01-31T18:43:56","modified_gmt":"2025-01-31T18:43:56","slug":"projekt-zustaende-und-status","status":"publish","type":"post","link":"https:\/\/flace.de\/?p=460","title":{"rendered":"Projekt Zust\u00e4nde und Status Schaubild"},"content":{"rendered":"

Bei KWP gibt es einige fest definierte Zust\u00e4nde und Status. Diese haben verschiedene Bedeutungen. Ein Zustand ist in KWP nicht ver\u00e4nderbar und
beinhaltet Funktionen. Statuseinstellungen k\u00f6nnen in den Projekteinstellungen erweitert werden.
\"\"
<\/a><\/p>\n

Projekt:
<\/span>BAuftragStatus AuftragStatus AAuftragstatus

Auftrag noch nicht vergeben\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 99 | 0 | 0
Auftrag nicht erhalten, sonstige Gr\u00fcnde\u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 6 | 10
Auftrag erhalten\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 8| 12
Auftrag abgeschlossen\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 9 |3<\/p>\n

Regie:<\/span>
BAuftragStatus AuftragStatus AAuftragstatus<\/p>\n

nicht freigegeben\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 99 | 0 | 0
nicht vergeben\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 99 | 4 | 4
erhalten\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 0 | 5
ohne Rechnung\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 1\u00a0 | 1
Auftrag abgeschlossen\u00a0 \u00a099 | 2\u00a0 | 6
Rechnung gedruckt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 2 | 2
Auftrag nicht erh\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 3 | 7
Ohne Rech abgeschl\u00a0 \u00a0 \u00a0 \u00a0 \u00a099 | 3 | 3<\/p>\n

Montageauftragsjournal\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Status<\/span><\/p>\n

erzeugt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 10
wartend\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a020
freigegeben\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 30
an Monteur ausg\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 40
an Mob Monteur ausgegeben\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a041
in Arbeit (Online Module)\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a050
r\u00fcckgemeldet\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 60
in Bearbeitung\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a070
zur Abrechnung\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 75
erledigt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 80\u00a0 – Archiveintrag wird automatisiert
erledigt\/storniert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 90


<\/p>\n\n\n

Beispiel SQL um alle Regieauftr\u00e4ge auf ohne Rechnung abgeschlossen<\/strong> zu setzen die vor dem 01.01.2024 erzeugt worden sind und noch den Status Auftrag erhalten<\/strong> haben.<\/p>\n\n\n\n

select BAuftragStatus, AuftragStatus ,AAuftragStatus, Createuser, Createdate, Edituser, Editdate, Info3
from regie where BAuftragStatus=’99‘ and auftragstatus=’0′ and aauftragstatus=’5′<\/p>\n\n\n\n

update regie
set BAuftragStatus=’99‘, auftragstatus=’3′ , aauftragstatus=’3′, info3=’schi‘
where Createdate < ‚01.01.2024‘ and BAuftragStatus=’99‘ and auftragstatus=’0′ and aauftragstatus=’5′<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Bei KWP gibt es einige fest definierte Zust\u00e4nde und Status. Diese haben verschiedene Bedeutungen. Ein Zustand ist in KWP nicht ver\u00e4nderbar und<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,16],"tags":[510,87,31,29],"class_list":["post-460","post","type-post","status-publish","format-standard","hentry","category-projekt","category-sql","tag-projet","tag-regie","tag-sql","tag-status"],"_links":{"self":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=460"}],"version-history":[{"count":9,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/460\/revisions"}],"predecessor-version":[{"id":2163,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/460\/revisions\/2163"}],"wp:attachment":[{"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}