{"data":[{"idproject":"18","customer_id":"2","company":null,"title":"Test","description":"Test","sowNr":null,"startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"15","additionalHours":"20","alertAt":"15","priceWork":null,"priceTravel":null,"maxTravel":null,"maxCost":null,"paymentDays":"6","otherExpenses":"1","createdBy":null,"state":"signed","id":"18","client":"2","projectStatus":"signed","sows":[{"consultant_id":"1","sowId":"13"},{"consultant_id":"19","sowId":"14"},{"consultant_id":"24","sowId":"74"},{"consultant_id":"62","sowId":"80"}],"consultant":"1,19,24,62","tasks":[{"id":"59","name":"asdasd","description":"sadasdasd"},{"id":"61","name":"test","description":"asdasdadd"},{"id":"62","name":"hghf","description":"gu"},{"id":"81","name":"ssf","description":"gdvx"}]},{"idproject":"19","customer_id":"2","company":"Test","title":"Test","description":"Test","sowNr":"012712","startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"720","maxCost":null,"paymentDays":"10","otherExpenses":"1","createdBy":null,"state":"signed","id":"19","client":"2","projectStatus":"signed","sows":[{"consultant_id":"1","sowId":"75"},{"consultant_id":"62","sowId":"81"}],"consultant":"1,62","tasks":[{"id":"80","name":"dgcgc","description":"gdhbn"}]},{"idproject":"20","customer_id":"2","company":"asdas","title":"Test","description":"Test","sowNr":"123123","startDate":"2020-01-01","endDate":"2020-01-31","payment":"Test","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":"2500","paymentDays":null,"otherExpenses":"1","createdBy":null,"state":"created","id":"20","client":"2","projectStatus":"created","sows":[{"consultant_id":"1","sowId":"17"},{"consultant_id":"1","sowId":"34"},{"consultant_id":"62","sowId":"84"},{"consultant_id":"15","sowId":"87"},{"consultant_id":"17","sowId":"88"}],"consultant":"1,1,62,15,17","tasks":[{"id":"87","name":"Test","description":"Halllo"}]},{"idproject":"21","customer_id":"2","company":null,"title":"Test","description":"Test","sowNr":null,"startDate":"2020-01-01","endDate":"2020-01-31","payment":"Test","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":"10","otherExpenses":"1","createdBy":null,"state":"created","id":"21","client":"2","projectStatus":"created","sows":[{"consultant_id":"1","sowId":"19"},{"consultant_id":"19","sowId":"20"}],"consultant":"1,19"},{"idproject":"22","customer_id":"2","company":null,"title":"Test","description":"Test","sowNr":null,"startDate":"2020-01-01","endDate":"2020-01-31","payment":"Test","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":"1","createdBy":null,"state":"created","id":"22","client":"2","projectStatus":"created","sows":[{"consultant_id":"24","sowId":"49"},{"consultant_id":"19","sowId":"51"},{"consultant_id":"18","sowId":"53"}],"consultant":"24,19,18","tasks":[{"id":"63","name":"Test1","description":"Ich bin ein Parent Task"}]},{"idproject":"23","customer_id":"19","company":null,"title":"test","description":"Hiiiii","sowNr":null,"startDate":"2023-10-10","endDate":"2023-10-31","payment":"fixed","estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":null,"createdBy":null,"state":"signed","id":"23","client":"19","projectStatus":"signed","sows":[{"consultant_id":"1","sowId":"61"},{"consultant_id":"15","sowId":"62"},{"consultant_id":"30","sowId":"66"}],"consultant":"1,15,30","tasks":[{"id":"69","name":"Test","description":"Task 1"},{"id":"70","name":"Task2","description":"Test2"}]},{"idproject":"24","customer_id":"1","company":null,"title":"Showcsase","description":"TestProject","sowNr":null,"startDate":"2023-10-18","endDate":"2023-10-31","payment":null,"estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":null,"createdBy":null,"state":"created","id":"24","client":"1","projectStatus":"created","sows":[{"consultant_id":"1","sowId":"64"},{"consultant_id":"15","sowId":"65"}],"consultant":"1,15","tasks":[{"id":"73","name":"Showcase 1","description":"Skdnafbjlsdvf"},{"id":"74","name":"asdsad","description":"sdasdad"}]},{"idproject":"25","customer_id":"1","company":null,"title":"Test","description":null,"sowNr":null,"startDate":"2023-10-02","endDate":"2023-10-31","payment":null,"estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":null,"createdBy":null,"state":"created","id":"25","client":"1","projectStatus":"created","sows":[{"consultant_id":"15","sowId":"67"},{"consultant_id":"19","sowId":"68"},{"consultant_id":"22","sowId":"69"}],"consultant":"15,19,22","tasks":[{"id":"76","name":"Test","description":"Task1"},{"id":"77","name":"Test2","description":"Task 2"}]},{"idproject":"26","customer_id":"1","company":null,"title":"ydsfsaf","description":null,"sowNr":null,"startDate":"2023-11-13","endDate":"2023-11-30","payment":"monthly","estimation":"20","additionalHours":"25","alertAt":"20","priceWork":"150","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":"5","otherExpenses":null,"createdBy":null,"state":"created","id":"26","client":"1","projectStatus":"created","sows":[{"consultant_id":"1","sowId":"70"},{"consultant_id":"15","sowId":"71"},{"consultant_id":"19","sowId":"72"}],"consultant":"1,15,19","tasks":[{"id":"79","name":"aDdaD","description":"ASDSADASDA"}]},{"idproject":"27","customer_id":"1","company":"Kreamedica","title":"Timesheet ","description":"Project is about finishing the Timesheet Function from testing to production ","sowNr":"12341223","startDate":"2024-06-01","endDate":"2024-09-30","payment":"monthly","estimation":"100","additionalHours":"150","alertAt":"120","priceWork":"33","priceTravel":"0","maxTravel":"0","maxCost":"0","paymentDays":"14","otherExpenses":null,"createdBy":null,"state":"signed","id":"27","client":"1","projectStatus":"signed","sows":[{"consultant_id":"62","sowId":"82"},{"consultant_id":"69","sowId":"86"}],"consultant":"62,69","tasks":[{"id":"88","name":"Feedback","description":"Changes related to feedback"},{"id":"89","name":"Testing","description":"Testing the App"},{"id":"90","name":"Programming","description":"everything with coding"}]},{"idproject":"28","customer_id":"20","company":"Test","title":"Allways test","description":"Kick it - baby","sowNr":"0123","startDate":"2024-05-31","endDate":"2024-06-21","payment":"monthly","estimation":"18","additionalHours":"24","alertAt":"20","priceWork":"275","priceTravel":"150","maxTravel":"0","maxCost":"3000","paymentDays":"4","otherExpenses":"1","createdBy":null,"state":"signed","id":"28","client":"20","projectStatus":"signed","sows":[{"consultant_id":"15","sowId":"83"}],"consultant":"15","tasks":[{"id":"95","name":"Entwurf","description":"Basteln"},{"id":"96","name":"Meetings","description":"Labern"},{"id":"97","name":"Data Review","description":"Schaun mer mal"}]},{"idproject":"29","customer_id":"20","company":"OmVax","title":"Data Review","description":"Overivew on Data","sowNr":"4711","startDate":"2024-06-09","endDate":"2024-08-29","payment":"monthly","estimation":"20","additionalHours":"30","alertAt":"25","priceWork":"250","priceTravel":"125","maxTravel":"10","maxCost":"1500","paymentDays":"5","otherExpenses":"1","createdBy":null,"state":"signed","id":"29","client":"20","projectStatus":"signed","sows":[{"consultant_id":"33","sowId":"85"}],"consultant":"33","tasks":[{"id":"102","name":"Conference Call","description":"Standard Task"},{"id":"103","name":"Data Review","description":"Excel and fun"},{"id":"104","name":"Site Visit","description":"Watch 'n look"}]}] }