Questions Tagged mysql
Timeline & resync events in resource view
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...
How to prevent even dragging and resize on selected events
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 disable...
newResourceId is undefined on event resize
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().
Backend events are not loaded in the resource calender
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 ...
Part Time employees
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 = ar...
Impossible to show events from my database (resource calendar)
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 (includ...
How I can modify resources? If I don’t need group?
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 value ...
Moving and resizing tasks was not explained
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/...
How do I modify a database?
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...
Back end
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.
multiple event
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...
Multiple event show +1
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...
DB Connection data not showing at index
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...
MySQL cannot use just SQlite can use only why?
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.
php hotel room booking
Answered: You can find the licensing options at the Buy page: https://javascript.daypilot.org/buy/
JSON error in file: daypilot-all.min.js
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...
How to add a database and script to handle public holidays.
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...
How to load row axis based on selected items from dropdown by the user
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...
load data based on dropdown list
Answered: Please see my answer here: https://forums.daypilot.org/question/5494/how-to-refresh-gannt-chart-based-on-dropdown-values
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...
How to change color of duration bar based on values in database
Answered: The backend_events.php script should look like this:
<?php
require_once '_db.php';
$stmt = $db->prepare("SELECT * FROM leave_event WHERE NOT ((leave_end <= :start) OR (leave_start >= :end))");
...
Empy header cell for next columns if treeEnabled = true
Answered: The column content is set in onBeforeRowHeaderRender event handler. You'll need to modify it to exclude parent rows:
dp.onBeforeRowHeaderRender = (args) => {
// skip parent rows
if (arg...
Features available for react js schedular
Answered: All DayPilot Pro for JavaScript features are available in React as well. To learn more about event editing, please see the following documentation page: https://doc.daypilot.org/scheduler/event-editi...
Total hour by Employee by tasks
El total que me da por empleado, no es correct. Estoy utilizando una prueba de Scheduler y no suma los minitos correctaente, me ma menos.
How to convert php to spring boot
Answered: Unfortunately, this tutorial is not available for Spring Boot at this moment. To see how the Calendar and Scheduler components can be used with Spring Boot backend, please see the following tutorials...
i want to chart add in codeigniter but data not fetch from conreoller
i want to chart add in codeigniter but data not fetch from conreoller anyone can send me code for codeigniter same chart?
What program should i use for the codes?
Answered: In order to run the project, you'll need PHP, a webserver and a MySQL database server. A decent knowledge of JavaScript is also necessary if you want to customize the project. If you are a complete b...
Console.log display error unique ID
Answered: Unfortunately, I'm not able to reproduce the problem using the sample project. Please note that duplicate IDs are not allowed. Every event that you add to the Scheduler needs to have a unique ID ("id...
Questions 1-30 of 58
Next