{"data":[{"idproject":"13","consultant_id":"1","project_id":"18","company":"","title":"Test","description":"Test","sowNr":null,"startDate":"2023-10-17","endDate":"2023-10-31","payment":"Test","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":"1","createdBy":null,"state":"signed","id":"13","client":"1","projectStatus":"signed","projectId":"18","tasks":[{"id":"60","name":"asdsadsa","description":"sadsad","taskid":"59"}]},{"idproject":"14","consultant_id":"19","project_id":"18","company":"","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":"14","client":"19","projectStatus":"created","projectId":"18"},{"idproject":"17","consultant_id":"1","project_id":"20","company":"","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":"17","client":"1","projectStatus":"created","projectId":"20"},{"idproject":"19","consultant_id":"1","project_id":"21","company":"","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":"19","client":"1","projectStatus":"created","projectId":"21"},{"idproject":"20","consultant_id":"19","project_id":"21","company":"","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":"20","client":"19","projectStatus":"created","projectId":"21"},{"idproject":"34","consultant_id":"1","project_id":"20","company":"","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":"34","client":"1","projectStatus":"created","projectId":"20"},{"idproject":"49","consultant_id":"24","project_id":"22","company":"","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":"49","client":"24","projectStatus":"created","projectId":"22"},{"idproject":"51","consultant_id":"19","project_id":"22","company":"","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":"51","client":"19","projectStatus":"created","projectId":"22","tasks":[{"id":"64","name":"asdasd","description":"asdasdasd","taskid":"63"}]},{"idproject":"53","consultant_id":"18","project_id":"22","company":"","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":"53","client":"18","projectStatus":"created","projectId":"22"},{"idproject":"61","consultant_id":"1","project_id":"23","company":"","title":"test","description":"Hiiiii","sowNr":null,"startDate":"2023-10-10","endDate":"2023-10-31","payment":null,"estimation":"20","additionalHours":"5","alertAt":"18","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":null,"createdBy":null,"state":"signed","id":"61","client":"1","projectStatus":"signed","projectId":"23","tasks":[{"id":"71","name":"Arbeit","description":"sadawdsad","taskid":"69"},{"id":"72","name":"Heyy","description":"asdsad","taskid":"70"}]},{"idproject":"62","consultant_id":"15","project_id":"23","company":"","title":"test","description":"Hiiiii","sowNr":null,"startDate":"2023-10-26","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":"62","client":"15","projectStatus":"created","projectId":"23"},{"idproject":"64","consultant_id":"1","project_id":"24","company":"","title":"Showcsase","description":null,"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":"64","client":"1","projectStatus":"created","projectId":"24"},{"idproject":"65","consultant_id":"15","project_id":"24","company":"","title":"Showcsase","description":null,"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":"65","client":"15","projectStatus":"created","projectId":"24"},{"idproject":"66","consultant_id":"30","project_id":"23","company":"","title":"test","description":"Hiiiii","sowNr":null,"startDate":"2023-10-10","endDate":"2023-10-31","payment":"fixed","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":"1","createdBy":null,"state":"signed","id":"66","client":"30","projectStatus":"signed","projectId":"23","tasks":[{"id":"75","name":"asdsa","description":"asdsad","taskid":"69"}]},{"idproject":"67","consultant_id":"15","project_id":"25","company":"","title":"Test","description":null,"sowNr":null,"startDate":"2023-10-02","endDate":"2023-10-31","payment":"monthly","estimation":"30","additionalHours":"5","alertAt":"25","priceWork":"120","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":null,"otherExpenses":"1","createdBy":null,"state":"signed","id":"67","client":"15","projectStatus":"signed","projectId":"25","tasks":[{"id":"78","name":"Hey","description":"asdsad","taskid":"77"}]},{"idproject":"68","consultant_id":"19","project_id":"25","company":"","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":"68","client":"19","projectStatus":"created","projectId":"25"},{"idproject":"69","consultant_id":"22","project_id":"25","company":"","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":"69","client":"22","projectStatus":"created","projectId":"25"},{"idproject":"70","consultant_id":"1","project_id":"26","company":"","title":"ydsfsaf","description":null,"sowNr":null,"startDate":"2023-11-13","endDate":"2023-11-30","payment":null,"estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":"0","otherExpenses":null,"createdBy":null,"state":"created","id":"70","client":"1","projectStatus":"created","projectId":"26"},{"idproject":"71","consultant_id":"15","project_id":"26","company":"","title":"ydsfsaf","description":null,"sowNr":null,"startDate":"2023-11-13","endDate":"2023-11-30","payment":null,"estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":"0","otherExpenses":null,"createdBy":null,"state":"created","id":"71","client":"15","projectStatus":"created","projectId":"26"},{"idproject":"72","consultant_id":"19","project_id":"26","company":"","title":"ydsfsaf","description":null,"sowNr":null,"startDate":"2023-11-13","endDate":"2023-11-30","payment":null,"estimation":"0","additionalHours":"0","alertAt":"0","priceWork":"0","priceTravel":"0","maxTravel":"0","maxCost":null,"paymentDays":"0","otherExpenses":null,"createdBy":null,"state":"created","id":"72","client":"19","projectStatus":"created","projectId":"26"},{"idproject":"74","consultant_id":"24","project_id":"18","company":"","title":"Test","description":"Test","sowNr":null,"startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"15","additionalHours":"20","alertAt":"15","priceWork":"500","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":"6","otherExpenses":"1","createdBy":null,"state":"created","id":"74","client":"24","projectStatus":"created","projectId":"18"},{"idproject":"75","consultant_id":"1","project_id":"19","company":null,"title":"Test","description":"Test","sowNr":null,"startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"20","additionalHours":"5","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"0","maxCost":null,"paymentDays":"10","otherExpenses":"1","createdBy":null,"state":"created","id":"75","client":"1","projectStatus":"created","projectId":"19","tasks":[{"id":"85","name":"Test","description":"asdsad","taskid":"80"}]},{"idproject":"80","consultant_id":"62","project_id":"18","company":"Test","title":"Test","description":"Test","sowNr":"23445","startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"15","additionalHours":"20","alertAt":"15","priceWork":"250","priceTravel":"120","maxTravel":"700","maxCost":"2000","paymentDays":"6","otherExpenses":"1","createdBy":null,"state":"signed","id":"80","client":"62","projectStatus":"signed","projectId":"18","tasks":[{"id":"82","name":"Hi","description":"Sdadsad","taskid":"61"},{"id":"83","name":"Test","description":"Ich bin ein test","taskid":"62"}]},{"idproject":"81","consultant_id":"62","project_id":"19","company":null,"title":"Hi","description":"Test","sowNr":"012712","startDate":"2020-01-01","endDate":"2020-01-31","payment":"monthly","estimation":"25","additionalHours":"35","alertAt":"30","priceWork":"250","priceTravel":"200","maxTravel":"2000","maxCost":"1000","paymentDays":"10","otherExpenses":"1","createdBy":null,"state":"signed","id":"81","client":"62","projectStatus":"signed","projectId":"19","tasks":[{"id":"86","name":"Task","description":"Do this","taskid":"80"}]},{"idproject":"82","consultant_id":"62","project_id":"27","company":null,"title":"Timesheet ","description":"Project is about finishing the Timesheet Function from testing to production ","sowNr":"1234123","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":"82","client":"62","projectStatus":"signed","projectId":"27","tasks":[{"id":"91","name":"Feedback","description":null,"taskid":"88"},{"id":"92","name":"Programming","description":"everything coded","taskid":"90"}]},{"idproject":"83","consultant_id":"15","project_id":"28","company":null,"title":"Allways test","description":"Kick it - baby","sowNr":"0123","startDate":"2024-06-01","endDate":"2024-06-22","payment":"monthly","estimation":"18","additionalHours":"24","alertAt":"20","priceWork":"350","priceTravel":"0","maxTravel":"0","maxCost":"0","paymentDays":"4","otherExpenses":null,"createdBy":null,"state":"signed","id":"83","client":"15","projectStatus":"signed","projectId":"28","tasks":[{"id":"98","name":"ug","description":null,"taskid":"95"},{"id":"99","name":"labern","description":null,"taskid":"96"},{"id":"100","name":"laber","description":null,"taskid":"96"},{"id":"101","name":"Roh daten","description":null,"taskid":"97"}]},{"idproject":"84","consultant_id":"62","project_id":"20","company":null,"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":"84","client":"62","projectStatus":"created","projectId":"20"},{"idproject":"85","consultant_id":"33","project_id":"29","company":null,"title":"Data Review","description":"Overivew on Data","sowNr":"4711","startDate":"2024-06-08","endDate":"2024-08-28","payment":"monthly","estimation":"20","additionalHours":"30","alertAt":"25","priceWork":"250","priceTravel":"125","maxTravel":"10","maxCost":"1500","paymentDays":"5","otherExpenses":"1","createdBy":null,"state":"created","id":"85","client":"33","projectStatus":"created","projectId":"29","tasks":[{"id":"106","name":"In the Data Room","description":null,"taskid":"103"},{"id":"107","name":"On Site","description":"Test","taskid":"104"},{"id":"108","name":"Meetings","description":null,"taskid":"102"}]},{"idproject":"86","consultant_id":"69","project_id":"27","company":null,"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":"35000","paymentDays":"14","otherExpenses":"1","createdBy":null,"state":"signed","id":"86","client":"69","projectStatus":"signed","projectId":"27","tasks":[{"id":"109","name":"sadasdsad","description":"asdsadasd","taskid":"89"}]},{"idproject":"87","consultant_id":"15","project_id":"20","company":null,"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":"87","client":"15","projectStatus":"created","projectId":"20"},{"idproject":"88","consultant_id":"17","project_id":"20","company":null,"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":"88","client":"17","projectStatus":"created","projectId":"20","tasks":[{"id":"110","name":"Test","description":"Halllo","taskid":"87"}]}] }