Server side samples for Gantt 19.1

Hello,

I'm trying to setup a gantt for my website, so I downloaded the SyncFusionPhp. Version is 19.1.0.54.

The thing is : I have the feeling to miss something. Do you have documentation about the server side ? How to perform link with a database, or just even update a JSON file ? A lot of documentations are about to "display" the gantt and play with it, but not to update or store in some mysql database. I spent hours try some codes from a lot of  old threads or rearrange one of your guide: https://www.syncfusion.com/kb/7818/how-to-perform-crud-operations-in-gantt-using-php. But it is outdated (version 14), scheme database is not the same, I got date cast error and anyway the javascript side doesn't seem to fit with the new EJGantt.

Is there somewhere we can find updated sample ?

Thanks for your help.

Best regards
 

5 Replies

PP Pooja Priya Krishna Moorthy Syncfusion Team April 22, 2021 09:19 AM UTC

Hi Nexti, 
We have prepared a sample with latest version. We are unable to replicate the issue. We can update DB without any issues on CRUD operation. Please find the tested sample link. 
Please modify the sample to replicate the issue to check from our end and provide you proper solution. 

Regards, 
Pooja K. 



NE Nexti April 23, 2021 06:00 PM UTC

Hello,

Thank you for your answer. But this is not good at all.
I don't know what to say, I wonder if you just test this code yourself.

Dates are not correctly formatted to fit mysql DATE. JSON sends ISO format, I had to change it : date('Y-m-d H:i:s', strtotime($obj_del['startDate']));
No code about parentID or progress in the crud.php file, so simple child function can't work.
Javascript action=update function seems incorrect. When you use indent / outdent, it doesn't pass because it's in args.data.item and not args.item.
Renaming a task doesn't work because there is no if condition for this case.

Am I supposed to guess myself how all of your own objects are working ?

Sorry for that, but I litterally spent hours in this.


PP Pooja Priya Krishna Moorthy Syncfusion Team April 26, 2021 11:47 AM UTC

Hi Nexti, 
We are sorry for the inconvenience caused. 
And also we thank you for taking time to report the missed items. We will modify the KB with latest script version and php version. And it will get refreshed as soon as possible. 
 
Now we have modified a sample, with complete actions like add, edit, delete, indent, outdent. 
Please find the below sample link. 
 
In the above sample, we have tested the following scenarios, 
  1. Editing in both cell and dialog edit.
  2. Adding and deleting
  3. Indent and outdent
  4. Sent dates with correct format.
 
Regards, 
Pooja K. 



NE Nexti May 8, 2021 10:16 AM UTC

Hello,

Sorry to respond so late. I tested your code a little after and it was a lot better, thank you.
I began to create some gantt but unfortunately, there was still somes bugs (for example : if we change the start / end date from the "Task Details" window, it doesn't work). So.. I gave up. For us this is definitely not reliable enough and I already spent too much hours try to make it work properly.

We will probably try your new EJS2 with Angular.


MS Monisha Sivanthilingam Syncfusion Team May 10, 2021 04:29 PM UTC

Hi Nexti, 
 
You are welcome. 
 
We tried with the sample we provided in the previous update. However, we were unable to replicate the issue you reported. We also tried to edit the end date and start date of a task through the edit dialog as you said. However, we were still unable to replicate the error you reported. Please share with us more details with us about your issue, such as: 
  1. The steps taken to replicate the issue.
  2. The call stack of the error you are facing.
  3. If possible, please share a video replicating your issue.
 
Any information you share will be helpful to us in providing you with a solution. 
 
We will also be glad to assist you if you face any difficulties in migrating to EJ2-Angular Gantt Chart. 
 
For more information on EJ2-Angular Gantt Chart, please refer our Online Documentation and Sample. 
 
Regards, 
Monisha. 


Loader.
Up arrow icon