Questions Tagged mysql

Answered: You have added it correctly - but it will only display the expand/collapse icon when you add some child resources. If you want to hide the additional columns for these empty groups, you can remove th...

Answered: I hope it helps!

Answered: You can use the locale property to apply culture-specific settings (such as date format, first day of week….). const calendar = new DayPilot.Calendar("calendar", { locale: "en-au", // ... }); calenda...

Answered: Do you see any error in the JavaScript console?

Answered: The cell duration (and number of cells per hour) can be configured in the Calendar , but this option is only available in the Pro version.

Answered: If you just want to change the content of the time header , you can use the onBeforeTimeHeaderRender event handler to customize it in the Pro version of the Calendar . To define custom time slots , i...

Answered: In the Scheduler , you can create your own timeline by defining individual time slots. You can set custom start and end times for each slot, as long as they do not overlap with other slots.

Answered: To change the current date, it is necessary to update the startDate property, which is used as the default date for the columns (if they don’t specify a custom date). You can find an example here: Ne...

Answered: It looks like there is bug in the onchange event handler. An updated version will be released soon.

Answered: > Any possibility to show the current timeline or highlight the current cell duration with different background in lite version? This is not supported in the Lite version at the moment. In the Pro ve...

Answered: Drag and drop In the Lite (open-source) version, you can only enable/disable drag and drop for all calendar events using eventMoveHandling and eventResizeHandling . In the Pro version, you can disabl...

Answered: There is no args.newResource available in onEventResize as the resource doesn’t change during resizing. You can access the event resource ID using args.e.resource() .

Answered: Thanks for the update! The problem is the type of events.resource_id database field. It is incorrectly set to varchar instead of integer . Older versions of PHP/PDO converted integer values to string...

Answered: You can mark specified days as disabled using onBeforeCellRender in the Scheduler component . This method is used in the tutorial to disable weekends: onBeforeCellRender: (args) => { const day = args...

Answered: When displaying a resource calendar ( viewType: "Resources" ), it is necessary to specify the resource id for events using the resource property. This value needs to match the column id exactly (incl...

Answered: If the events don’t display correctly, you should check the id of the resources ( resources[].id ) and the resource of events ( event.list[].resource ). Events are only displayed in a row if these va...

Answered: You can find the documentation here: Resizing: https://doc.daypilot.org/gantt/task-resizing/ https://api.daypilot.org/daypilot-gantt-ontaskresize/ Moving (horizontal): https://doc.daypilot.org/gantt/...

Answered: You can take a look at this tutorial: https://code.daypilot.org/64657/angular-scheduler-resource-management It is for Angular, but it shows how to add a context menu to the row headers with additiona...

Answered: This project shows a single page with the restaurant reservation UI. It is kept as simple as possible so that the code can be modified easily. There is no admin part.

Answered: This is not supported in the Calendar component at the moment but you can take a look at the Scheduler component which can group concurrent events automatically: https://doc.daypilot.org/scheduler/co...

Answered: > If we have multiple event can we show +2 or +3 etc Please see my answer here: https://forums.daypilot.org/question/5848/multiple-event > in weekly can we change date format You can change the calen...

Answered: I recommend checking the HTTP calls to the API (especially work_order_resources.php and work_order_list.php) in the browser developer console (Network tab). Make sure that the response includes the c...

Answered: In order to switch to MySQL please follow the instructions at the bottom of the article (a section called "Database (MySQL, SQLite)"). You need to edit _db.php and _mysql.php files.

Answered: You can find the licensing options at the Buy page: https://javascript.daypilot.org/buy/

Answered: This happens if the PHP backend returns an error instead of a JSON response. I recommend checking the backend HTTP request using browser developer tools. The response will contain an error message wh...

Answered: There is a tutorial available that shows how to display holidays (by setting a custom scheduler cell background color): https://code.daypilot.org/93068/javascript-scheduler-displaying-holidays I beli...

Answered: You need to make sure that the URL used in dp.rows.load() call returns the data correctly. I recommend using browser developer tools (Ctrl-Shift-I or Option-Command-I), the Network tab, to inspect th...

Answered: Please see my answer here: https://forums.daypilot.org/question/5494/how-to-refresh-gannt-chart-based-on-dropdown-values

Answered: The following tutorial includes a project that displays a drop-down list with locations: https://code.daypilot.org/61166/php-shift-planning-javascript-html5-mysql-database When a user selects an item...