Questions Tagged mysql
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...
New Event with dropdown values as name
On the creation of a new event, instead of typing name, get possible values from a query to a mysql. Getting a dropdown menu to select the name of the event.
New Event from a list of pre define events
Answered: I'm not sure if this is what you are looking for but if you have existing unscheduled events/tasks that need to be scheduled you can use external drag and drop to move them to a specific time slot in...
No of Days Calculation is getting reduced by One Day
Answered: If you only work with full days, you can switch to eventEndSpec="Date" mode which will translate the end date to "end of day": https://doc.daypilot.org/scheduler/event-end-date-time/ But that will no...
remove demo
Answered: You'll need to purchase a license: https://javascript.daypilot.org/buy/ The tutorial includes a trial version of DayPilot Pro.
How can I fetch value of new column from database and display it on the calendar?
Answered: You can use onBeforeEventRender event handler to modify the event HTML (args.data.html) using the staff column (args.data.staff): https://doc.daypilot.org/calendar/event-customization/ You can also m...
Questions 1-30 of 53
Next