PHPackages dhtmlx/scheduler-helper - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Utility & Helpers](/categories/utility) 4. / 5. dhtmlx/scheduler-helper ActiveLibrary[Utility & Helpers](/categories/utility) dhtmlx/scheduler-helper ======================= Helper for working with recurring events in dhtmlxScheduler. 1.1.0(10y ago)8165.8k↑74.5%8[1 PRs](https://github.com/DHTMLX/scheduler-helper-php/pulls)GNUPHPPHP >=5.4.0 Since Apr 30Pushed 3y ago14 watchersCompare [ Source](https://github.com/DHTMLX/scheduler-helper-php)[ Packagist](https://packagist.org/packages/dhtmlx/scheduler-helper)[ RSS](/packages/dhtmlx-scheduler-helper/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependenciesVersions (3)Used By (0) Scheduler Helper for PHP ======================== [](#scheduler-helper-for-php) ### Requirements [](#requirements) - PHP>=5.4 (PDO~) - MySQL, PostgreSQL, Sqlite, etc. ### Installation [](#installation) - composer 'dhtmlx/scheduler-helper' or - just download the files from this repository ':DHTMLX/scheduler-helper-php.git' ``` require_once "./SchedulerHelper.php"; use DHTMLX_Scheduler\Helper; ``` ### How to use [](#how-to-use) In order to create a helper object you should call the class constructor `DHTMLX_Scheduler\Helper([$connectorDataArray]):` ``` $helper = new Helper( array( "dbsm" => "mysql", // optional, "mysql" by default "host" => "localhost", // optional, "localhost" by default "db_name" => "scheduler_helper_db", "user" => "root", "password" => "root", "table_name" => "events_rec" // name of the table that contains data of recurring events ) ); ``` In the helper a standard set of fields for working with a table is defined: ``` helper::FLD_ID => "event_id", helper::FLD_START_DATE => "start_date", helper::FLD_END_DATE => "end_date", helper::FLD_TEXT => "text", helper::FLD_RECURRING_TYPE => "rec_type", helper::FLD_PARENT_ID => "event_pid", helper::FLD_LENGTH => "event_length" ``` To redefine the helper and create new fields, you should use the method 'setFieldsNames(\[$fieldsDataArray\])': ``` $helper->setFieldsNames(array( $helper::FLD_RECURRING_TYPE => "my_recurring_type_field", // redefining the field 'FLD_RECURRING_TYPE'. "my_property_field" // initialization of a new field )); ``` For getting only fields that have set, you need just to set 'true' like second parameter in the function 'setFieldsNames(\[$fieldsDataArray\], true)' ``` $helper->setFieldsNames(array( $helper::FLD_RECURRING_TYPE => "my_recurring_type_field", // redefining the field 'FLD_RECURRING_TYPE'. "my_property_field" // initialization of a new field ), true); ``` For setting weather server time zone will be considered you should use server\_date config(false by default). If true helper will use server time, else will use dates as it goes from database. ``` $helper->config["server_date"] = true; ``` For setting weather if recurring occurrence date is saved in UTC in database "occurrence\_timestamp\_in\_utc" config can be used (false by default). If true helper processes exceptions dates as UTC. ``` $helper->config["occurrence_timestamp_in_utc"] = true; ``` To save data to the database, use the method 'saveData(\[dataArray\])': ``` // To save data of the field 'FLD_RECURRING_TYPE', you can use a data array or a string in the format 'week_2_____1,3#10'. $newRecurringTypeArray = array( "each" => "week", "step" => 2, "days_of_week" => "monday,wednesday", // if the field 'week_number' is set, the field 'days_of_week' must contain only one value // "week_number" => 2, "repeat" => 10 ); $helper->saveData(array( // $helper::FLD_ID => "20", // if you pass this field for saving, data in the database will be updated by this value, otherwise new data will be written $helper::FLD_RECURRING_TYPE => $newRecurringTypeArray, $helper::FLD_START_DATE => "2015-09-30 00:00:00", $helper::FLD_END_DATE => $helper->getRecurringEndDateStr($newRecurringTypeArray, "2015-09-30 00:00:00", 500), // to count the end date of the recurring series, you can use the function 'getRecurringEndDateStr' $helper::FLD_LENGTH => 500, "my_property_field" => "Any data..." // new fields defined by the user must be presented in this way )); ``` To delete data from the database, you should use the method 'deleteById(\[ID\])': ``` $helper->deleteById(48); // will delete data by the field 'FLD_ID'. ``` To get data of the recurring events, use the method 'getData(\[$startDateStr\], \[$endDateStr\])': ``` $helper->getData("2015-02-10 09:00:00", "2020-01-02 07:00:00"); // The function will return recurring events from the defined range taking into account exclusion of events series // The result will look as follows: //array( // array( // "start_date" => "2015-02-13 00:00:00", // "end_date" => "2015-02-15 00:00:00", // "text" => "Second Friday", // ... // ), // .... //); ``` \#####Tests In order to run tests: 1. Install PHPUnit following this instruction 2. Configure DB settings in tests/TestConfig.php 3. Enter repository folder and execute ``` phpunit --bootstrap SchedulerHelper.php tests/SchedulerHelperTest ``` ### License [](#license) The MIT License Copyright (c) 2015 DHTMLX Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. ============================================================================================================================================================================================================================================================================================================================================================================================================================================================================ [](#the-software-is-provided-as-is-without-warranty-of-any-kind-express-or-implied-including-but-not-limited-to-the-warranties-of-merchantabilityfitness-for-a-particular-purpose-and-noninfringement-in-no-event-shall-the-authors-or-copyright-holders-be-liable-for-any-claim-damages-or-otherliability-whether-in-an-action-of-contract-tort-or-otherwise-arising-from-out-of-or-in-connection-with-the-software-or-the-use-or-other-dealingsin-the-software) ### Health Score 38 — LowBetter than 85% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity41 Moderate usage in the ecosystem Community19 Small or concentrated contributor base Maturity59 Maturing project, gaining track record Bus Factor1 Top contributor holds 70.9% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~333 days Total 2 Last Release 3702d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/7b95856bef086ccf413282dcd3146278e214b2473e028ed63f72000044ba0ba2?d=identicon)[dhtmlx](/maintainers/dhtmlx) --- Top Contributors [![mperednya](https://avatars.githubusercontent.com/u/10597750?v=4)](https://github.com/mperednya "mperednya (78 commits)")[![AlexKlimenkov](https://avatars.githubusercontent.com/u/988260?v=4)](https://github.com/AlexKlimenkov "AlexKlimenkov (15 commits)")[![EgorLazarovich](https://avatars.githubusercontent.com/u/7933406?v=4)](https://github.com/EgorLazarovich "EgorLazarovich (15 commits)")[![Stanislav-Wolski](https://avatars.githubusercontent.com/u/917554?v=4)](https://github.com/Stanislav-Wolski "Stanislav-Wolski (2 commits)") --- Tags helperdhtmlx ### Embed Badge ![Health badge](/badges/dhtmlx-scheduler-helper/health.svg) ``` [![Health](https://phpackages.com/badges/dhtmlx-scheduler-helper/health.svg)](https://phpackages.com/packages/dhtmlx-scheduler-helper) ``` ### Alternatives [barryvdh/laravel-ide-helper Laravel IDE Helper, generates correct PHPDocs for all Facade classes, to improve auto-completion. 14.9k123.0M687](/packages/barryvdh-laravel-ide-helper)[bryanjhv/slim-session Session middleware and helper for Slim framework 4. 233961.5k16](/packages/bryanjhv-slim-session)[laravelista/ekko Framework agnostic PHP package for marking navigation items active. 278673.4k4](/packages/laravelista-ekko)[beste/json A simple JSON helper to decode and encode JSON 4222.7M3](/packages/beste-json)[chillerlan/php-settings-container A container class for immutable settings objects. Not a DI container. 3427.3M21](/packages/chillerlan-php-settings-container)[kartik-v/yii2-helpers A collection of useful helper functions for Yii Framework 2.0 883.0M29](/packages/kartik-v-yii2-helpers) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)