Questions Tagged php
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.
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...
Looking for a coder
Hi :) Hope this is allowd by admin, if not let me know. Im doing a small “home-project” and need assistance with configurering the AJAX Scheduler for JavaScript/PHP. I have some specific behavior i w...
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...
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...
Customer Event Add Modal
Answered: When the users selects a time range the Scheduler fires the onTimeRangeSelected event:
onTimeRangeSelected: args => {
this.create.show(args);
}
You can modify the event handler to...
How can I add full calendar to Spring Boot MVC (Gradle) and Hibernate
Answered: You can take a look at this example that uses DayPilot Pro: https://code.daypilot.org/41760/using-javascript-html5-event-calendar-in-spring-boot-java The Maven config used in this project is very bas...
Week Calendar. How to have events of arbitrary length
Answered: In the Lite (open-source) version this is not supported but in the Pro version you can set the behavior using useEventBoxes property. Please see more here: https://doc.daypilot.org/calendar/exact-eve...
the status and the user's name in the Edit appointment slot doesn't appear!
please i need help, the modal 'Edit appointment slot' works well just the status and the name and the button 'save' :/ i dunno why? and also i wanna ask about the documentation they said: "As soon as...
'DayPilot' is not defined
Answered: Please make sure that daypilot-all.min.js is loaded before the month control initialization code [@Html.DayPilotMonth("dp",....]. If the library is not loaded at that point it will generate an error ...
Insert not working
Answered: I'd recommend checking the server response (backend_events_create.php call) using browser developer tools. It may include additional information about a server-side error.
when click on even
when click on event how do I load event detail in pop up, now empty pop up shows up.
how to add Switching Day/Week View
Answered: To switch the view, you just need to change the viewType value and call update(), like this: Switch to day view:
dp.viewType = "Day";
dp.update();
Switch to week view:
dp.viewType = "Week";
d...
2 rows for one resource
Answered: It is possible to display two rows for each resource: 1. The resource id needs to be unique. This can be done by prefixing a certain string to the resource id, e.g. "R" + id for reservations rows, "I...
database
Answered: In PHP, you can modify the backend scripts (backend_events.php, backend_create.php) to work with your database. The DB connection properties can be found in _db.php. The MVC version defines the data ...
Extra Fields Add
Answered: The modal dialog can show any HTML page using showUrl() method. You can create a standard page with the required fields and display it using showUrl(). You can pass the form data back to the calendar...
start date and end date
Answered: You can use "startDate" to change the visible date range: https://doc.daypilot.org/calendar/manual-date-switching/ The end date is calculated automatically, depending on the viewType value (https://d...
Changing the Daypilot instance
Answered: I found the solution myself, would be of help to others if ever come across this question. I simply used the dispose() method of the DayPilot, so when the event is triggered, I first got rid of the e...
backend_delete
Answered: Please take a look at the documentation: https://doc.daypilot.org/calendar/event-deleting/ You need to use onEventDelete event handler to call backend_delete.php endpoint on the server side. You need...
Event Calendar
Answered: Have you checked the docs? https://doc.daypilot.org/scheduler/event-deleting/
Gantt graph appearance height
Answered: You can use dp.heightSpec = "Parent100Pct" to set the Gantt height to 100% of the parent element. Just make sure that the parent height is set explicitly (either using "height" style or using "top"/"...
Database
Answered: Javascript can't connect directly to a database, but it can request data from external pages, files. I use PHP, and a MS SQL database. I have created an API were I can request data for my scheduler, ...
How to remove orange rectangle with text "DEMO" from month view of daypilot?
Answered: It looks like you have used DayPilot Pro (the paid version) in your project. 1. You can use DayPilot Lite (open-source) instead - but it doesn't include all Pro features: https://javascript.daypilot....