5 * @copyright CiviCRM LLC https://civicrm.org/licensing
7 * Generated from xml/schema/CRM/Core/ActionSchedule.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
9 * (GenCodeChecksum:35dfd5d26ce9445b37c831c51ccc5d7e)
13 * Database access object for the ActionSchedule entity.
15 class CRM_Core_DAO_ActionSchedule
extends CRM_Core_DAO
{
16 const EXT
= 'civicrm';
17 const TABLE_ADDED
= '3.4';
20 * Static instance to hold the table name.
24 public static $_tableName = 'civicrm_action_schedule';
27 * Should CiviCRM log any modifications to this table in the civicrm_log table.
31 public static $_log = FALSE;
39 * Name of the action(reminder)
46 * Title of the action(reminder)
60 * Is this the recipient criteria limited to OR in addition to?
78 public $entity_status;
85 public $start_action_offset;
88 * Time units for reminder.
92 public $start_action_unit;
99 public $start_action_condition;
106 public $start_action_date;
114 * Time units for repetition of reminder.
118 public $repetition_frequency_unit;
121 * Time interval for repeating the reminder.
125 public $repetition_frequency_interval;
128 * Time units till repetition of reminder.
132 public $end_frequency_unit;
135 * Time interval till repeating the reminder.
139 public $end_frequency_interval;
142 * Reminder Action till repeating the reminder.
156 * Is this option active?
163 * Contact IDs to which reminder should be sent.
167 public $recipient_manual;
170 * listing based on recipient field.
174 public $recipient_listing;
177 * Body of the mailing in text format.
184 * Body of the mailing in html format.
191 * Content of the SMS text.
195 public $sms_body_text;
205 * Record Activity for this reminder?
209 public $record_activity;
212 * Name/ID of the mapping to use on this table
226 * FK to the message template.
230 public $msg_template_id;
233 * FK to the message template.
237 public $sms_template_id;
240 * Date on which the reminder be sent.
244 public $absolute_date;
247 * Name in "from" field
254 * Email address in "from" field
261 * Send the message as email or sms or both.
270 public $sms_provider_id;
273 * Used for repeating entity
280 * Used for multilingual installation
284 public $filter_contact_language;
287 * Used for multilingual installation
291 public $communication_language;
294 * When was the scheduled reminder created.
298 public $created_date;
301 * When the reminder was created or modified.
305 public $modified_date;
308 * Earliest date to consider start events from.
312 public $effective_start_date;
315 * Latest date to consider end events from.
319 public $effective_end_date;
324 public function __construct() {
325 $this->__table
= 'civicrm_action_schedule';
326 parent
::__construct();
330 * Returns localized title of this entity.
332 * @param bool $plural
333 * Whether to return the plural version of the title.
335 public static function getEntityTitle($plural = FALSE) {
336 return $plural ?
ts('Action Schedules') : ts('Action Schedule');
340 * Returns foreign keys and entity references.
343 * [CRM_Core_Reference_Interface]
345 public static function getReferenceColumns() {
346 if (!isset(Civi
::$statics[__CLASS__
]['links'])) {
347 Civi
::$statics[__CLASS__
]['links'] = static::createReferenceColumns(__CLASS__
);
348 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'group_id', 'civicrm_group', 'id');
349 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'msg_template_id', 'civicrm_msg_template', 'id');
350 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'sms_template_id', 'civicrm_msg_template', 'id');
351 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'sms_provider_id', 'civicrm_sms_provider', 'id');
352 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'links_callback', Civi
::$statics[__CLASS__
]['links']);
354 return Civi
::$statics[__CLASS__
]['links'];
358 * Returns all the column names of this table
362 public static function &fields() {
363 if (!isset(Civi
::$statics[__CLASS__
]['fields'])) {
364 Civi
::$statics[__CLASS__
]['fields'] = [
367 'type' => CRM_Utils_Type
::T_INT
,
368 'title' => ts('Action Schedule ID'),
370 'where' => 'civicrm_action_schedule.id',
371 'table_name' => 'civicrm_action_schedule',
372 'entity' => 'ActionSchedule',
373 'bao' => 'CRM_Core_BAO_ActionSchedule',
383 'type' => CRM_Utils_Type
::T_STRING
,
384 'title' => ts('Name'),
385 'description' => ts('Name of the action(reminder)'),
387 'size' => CRM_Utils_Type
::BIG
,
388 'where' => 'civicrm_action_schedule.name',
389 'table_name' => 'civicrm_action_schedule',
390 'entity' => 'ActionSchedule',
391 'bao' => 'CRM_Core_BAO_ActionSchedule',
397 'type' => CRM_Utils_Type
::T_STRING
,
398 'title' => ts('Title'),
399 'description' => ts('Title of the action(reminder)'),
401 'size' => CRM_Utils_Type
::BIG
,
402 'where' => 'civicrm_action_schedule.title',
403 'table_name' => 'civicrm_action_schedule',
404 'entity' => 'ActionSchedule',
405 'bao' => 'CRM_Core_BAO_ActionSchedule',
410 'name' => 'recipient',
411 'type' => CRM_Utils_Type
::T_STRING
,
412 'title' => ts('Recipient'),
413 'description' => ts('Recipient'),
415 'size' => CRM_Utils_Type
::BIG
,
416 'where' => 'civicrm_action_schedule.recipient',
417 'table_name' => 'civicrm_action_schedule',
418 'entity' => 'ActionSchedule',
419 'bao' => 'CRM_Core_BAO_ActionSchedule',
422 'label' => ts("Recipient"),
427 'name' => 'limit_to',
428 'type' => CRM_Utils_Type
::T_BOOLEAN
,
429 'title' => ts('Limit To'),
430 'description' => ts('Is this the recipient criteria limited to OR in addition to?'),
431 'where' => 'civicrm_action_schedule.limit_to',
432 'table_name' => 'civicrm_action_schedule',
433 'entity' => 'ActionSchedule',
434 'bao' => 'CRM_Core_BAO_ActionSchedule',
437 'label' => ts("Limit To"),
442 'name' => 'entity_value',
443 'type' => CRM_Utils_Type
::T_STRING
,
444 'title' => ts('Entity Value'),
445 'description' => ts('Entity value'),
447 'size' => CRM_Utils_Type
::HUGE
,
448 'where' => 'civicrm_action_schedule.entity_value',
449 'table_name' => 'civicrm_action_schedule',
450 'entity' => 'ActionSchedule',
451 'bao' => 'CRM_Core_BAO_ActionSchedule',
453 'serialize' => self
::SERIALIZE_SEPARATOR_TRIMMED
,
455 'label' => ts("Entity value"),
460 'name' => 'entity_status',
461 'type' => CRM_Utils_Type
::T_STRING
,
462 'title' => ts('Entity Status'),
463 'description' => ts('Entity status'),
465 'size' => CRM_Utils_Type
::BIG
,
466 'where' => 'civicrm_action_schedule.entity_status',
467 'table_name' => 'civicrm_action_schedule',
468 'entity' => 'ActionSchedule',
469 'bao' => 'CRM_Core_BAO_ActionSchedule',
471 'serialize' => self
::SERIALIZE_SEPARATOR_TRIMMED
,
473 'label' => ts("Entity Status"),
477 'start_action_offset' => [
478 'name' => 'start_action_offset',
479 'type' => CRM_Utils_Type
::T_INT
,
480 'title' => ts('Start Action Offset'),
481 'description' => ts('Reminder Interval.'),
482 'where' => 'civicrm_action_schedule.start_action_offset',
484 'table_name' => 'civicrm_action_schedule',
485 'entity' => 'ActionSchedule',
486 'bao' => 'CRM_Core_BAO_ActionSchedule',
489 'label' => ts("Start Action Offset"),
493 'start_action_unit' => [
494 'name' => 'start_action_unit',
495 'type' => CRM_Utils_Type
::T_STRING
,
496 'title' => ts('Start Action Unit'),
497 'description' => ts('Time units for reminder.'),
499 'size' => CRM_Utils_Type
::EIGHT
,
500 'where' => 'civicrm_action_schedule.start_action_unit',
501 'table_name' => 'civicrm_action_schedule',
502 'entity' => 'ActionSchedule',
503 'bao' => 'CRM_Core_BAO_ActionSchedule',
507 'label' => ts("Start Action Unit"),
509 'pseudoconstant' => [
510 'callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits',
514 'start_action_condition' => [
515 'name' => 'start_action_condition',
516 'type' => CRM_Utils_Type
::T_STRING
,
517 'title' => ts('Start Action Condition'),
518 'description' => ts('Reminder Action'),
520 'size' => CRM_Utils_Type
::BIG
,
521 'where' => 'civicrm_action_schedule.start_action_condition',
522 'table_name' => 'civicrm_action_schedule',
523 'entity' => 'ActionSchedule',
524 'bao' => 'CRM_Core_BAO_ActionSchedule',
527 'label' => ts("Start Action condition"),
531 'start_action_date' => [
532 'name' => 'start_action_date',
533 'type' => CRM_Utils_Type
::T_STRING
,
534 'title' => ts('Start Action Date'),
535 'description' => ts('Entity date'),
537 'size' => CRM_Utils_Type
::BIG
,
538 'where' => 'civicrm_action_schedule.start_action_date',
539 'table_name' => 'civicrm_action_schedule',
540 'entity' => 'ActionSchedule',
541 'bao' => 'CRM_Core_BAO_ActionSchedule',
544 'label' => ts("Start Action Date"),
549 'name' => 'is_repeat',
550 'type' => CRM_Utils_Type
::T_BOOLEAN
,
551 'title' => ts('Repeat?'),
552 'where' => 'civicrm_action_schedule.is_repeat',
554 'table_name' => 'civicrm_action_schedule',
555 'entity' => 'ActionSchedule',
556 'bao' => 'CRM_Core_BAO_ActionSchedule',
560 'repetition_frequency_unit' => [
561 'name' => 'repetition_frequency_unit',
562 'type' => CRM_Utils_Type
::T_STRING
,
563 'title' => ts('Repetition Frequency Unit'),
564 'description' => ts('Time units for repetition of reminder.'),
566 'size' => CRM_Utils_Type
::EIGHT
,
567 'where' => 'civicrm_action_schedule.repetition_frequency_unit',
568 'table_name' => 'civicrm_action_schedule',
569 'entity' => 'ActionSchedule',
570 'bao' => 'CRM_Core_BAO_ActionSchedule',
574 'label' => ts("Repetition Frequency Unit"),
576 'pseudoconstant' => [
577 'callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits',
581 'repetition_frequency_interval' => [
582 'name' => 'repetition_frequency_interval',
583 'type' => CRM_Utils_Type
::T_INT
,
584 'title' => ts('Repetition Frequency Interval'),
585 'description' => ts('Time interval for repeating the reminder.'),
586 'where' => 'civicrm_action_schedule.repetition_frequency_interval',
588 'table_name' => 'civicrm_action_schedule',
589 'entity' => 'ActionSchedule',
590 'bao' => 'CRM_Core_BAO_ActionSchedule',
593 'label' => ts("Repetition Frequency Interval"),
597 'end_frequency_unit' => [
598 'name' => 'end_frequency_unit',
599 'type' => CRM_Utils_Type
::T_STRING
,
600 'title' => ts('End Frequency Unit'),
601 'description' => ts('Time units till repetition of reminder.'),
603 'size' => CRM_Utils_Type
::EIGHT
,
604 'where' => 'civicrm_action_schedule.end_frequency_unit',
605 'table_name' => 'civicrm_action_schedule',
606 'entity' => 'ActionSchedule',
607 'bao' => 'CRM_Core_BAO_ActionSchedule',
611 'label' => ts("End Frequency Unit"),
613 'pseudoconstant' => [
614 'callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits',
618 'end_frequency_interval' => [
619 'name' => 'end_frequency_interval',
620 'type' => CRM_Utils_Type
::T_INT
,
621 'title' => ts('End Frequency Interval'),
622 'description' => ts('Time interval till repeating the reminder.'),
623 'where' => 'civicrm_action_schedule.end_frequency_interval',
625 'table_name' => 'civicrm_action_schedule',
626 'entity' => 'ActionSchedule',
627 'bao' => 'CRM_Core_BAO_ActionSchedule',
630 'label' => ts("End Frequency Interval"),
635 'name' => 'end_action',
636 'type' => CRM_Utils_Type
::T_STRING
,
637 'title' => ts('End Action'),
638 'description' => ts('Reminder Action till repeating the reminder.'),
640 'size' => CRM_Utils_Type
::MEDIUM
,
641 'where' => 'civicrm_action_schedule.end_action',
642 'table_name' => 'civicrm_action_schedule',
643 'entity' => 'ActionSchedule',
644 'bao' => 'CRM_Core_BAO_ActionSchedule',
647 'label' => ts("End Action"),
652 'name' => 'end_date',
653 'type' => CRM_Utils_Type
::T_STRING
,
654 'title' => ts('End Date'),
655 'description' => ts('Entity end date'),
657 'size' => CRM_Utils_Type
::BIG
,
658 'where' => 'civicrm_action_schedule.end_date',
659 'table_name' => 'civicrm_action_schedule',
660 'entity' => 'ActionSchedule',
661 'bao' => 'CRM_Core_BAO_ActionSchedule',
664 'label' => ts("End Date"),
669 'name' => 'is_active',
670 'type' => CRM_Utils_Type
::T_BOOLEAN
,
671 'title' => ts('Schedule is Active?'),
672 'description' => ts('Is this option active?'),
673 'where' => 'civicrm_action_schedule.is_active',
675 'table_name' => 'civicrm_action_schedule',
676 'entity' => 'ActionSchedule',
677 'bao' => 'CRM_Core_BAO_ActionSchedule',
681 'recipient_manual' => [
682 'name' => 'recipient_manual',
683 'type' => CRM_Utils_Type
::T_STRING
,
684 'title' => ts('Recipient Manual'),
685 'description' => ts('Contact IDs to which reminder should be sent.'),
687 'size' => CRM_Utils_Type
::HUGE
,
688 'where' => 'civicrm_action_schedule.recipient_manual',
689 'table_name' => 'civicrm_action_schedule',
690 'entity' => 'ActionSchedule',
691 'bao' => 'CRM_Core_BAO_ActionSchedule',
693 'serialize' => self
::SERIALIZE_COMMA
,
696 'recipient_listing' => [
697 'name' => 'recipient_listing',
698 'type' => CRM_Utils_Type
::T_STRING
,
699 'title' => ts('Recipient Listing'),
700 'description' => ts('listing based on recipient field.'),
702 'size' => CRM_Utils_Type
::HUGE
,
703 'where' => 'civicrm_action_schedule.recipient_listing',
704 'table_name' => 'civicrm_action_schedule',
705 'entity' => 'ActionSchedule',
706 'bao' => 'CRM_Core_BAO_ActionSchedule',
711 'name' => 'body_text',
712 'type' => CRM_Utils_Type
::T_LONGTEXT
,
713 'title' => ts('Reminder Text'),
714 'description' => ts('Body of the mailing in text format.'),
715 'where' => 'civicrm_action_schedule.body_text',
716 'table_name' => 'civicrm_action_schedule',
717 'entity' => 'ActionSchedule',
718 'bao' => 'CRM_Core_BAO_ActionSchedule',
723 'name' => 'body_html',
724 'type' => CRM_Utils_Type
::T_LONGTEXT
,
725 'title' => ts('Reminder HTML'),
726 'description' => ts('Body of the mailing in html format.'),
727 'where' => 'civicrm_action_schedule.body_html',
728 'table_name' => 'civicrm_action_schedule',
729 'entity' => 'ActionSchedule',
730 'bao' => 'CRM_Core_BAO_ActionSchedule',
735 'name' => 'sms_body_text',
736 'type' => CRM_Utils_Type
::T_LONGTEXT
,
737 'title' => ts('SMS Reminder Text'),
738 'description' => ts('Content of the SMS text.'),
739 'where' => 'civicrm_action_schedule.sms_body_text',
740 'table_name' => 'civicrm_action_schedule',
741 'entity' => 'ActionSchedule',
742 'bao' => 'CRM_Core_BAO_ActionSchedule',
748 'type' => CRM_Utils_Type
::T_STRING
,
749 'title' => ts('Reminder Subject'),
750 'description' => ts('Subject of mailing'),
752 'size' => CRM_Utils_Type
::HUGE
,
753 'where' => 'civicrm_action_schedule.subject',
754 'table_name' => 'civicrm_action_schedule',
755 'entity' => 'ActionSchedule',
756 'bao' => 'CRM_Core_BAO_ActionSchedule',
760 'record_activity' => [
761 'name' => 'record_activity',
762 'type' => CRM_Utils_Type
::T_BOOLEAN
,
763 'title' => ts('Record Activity for Reminder?'),
764 'description' => ts('Record Activity for this reminder?'),
765 'where' => 'civicrm_action_schedule.record_activity',
767 'table_name' => 'civicrm_action_schedule',
768 'entity' => 'ActionSchedule',
769 'bao' => 'CRM_Core_BAO_ActionSchedule',
774 'name' => 'mapping_id',
775 'type' => CRM_Utils_Type
::T_STRING
,
776 'title' => ts('Reminder Mapping'),
777 'description' => ts('Name/ID of the mapping to use on this table'),
779 'size' => CRM_Utils_Type
::BIG
,
780 'where' => 'civicrm_action_schedule.mapping_id',
781 'table_name' => 'civicrm_action_schedule',
782 'entity' => 'ActionSchedule',
783 'bao' => 'CRM_Core_BAO_ActionSchedule',
788 'name' => 'group_id',
789 'type' => CRM_Utils_Type
::T_INT
,
790 'title' => ts('Group ID'),
791 'description' => ts('FK to Group'),
792 'where' => 'civicrm_action_schedule.group_id',
793 'table_name' => 'civicrm_action_schedule',
794 'entity' => 'ActionSchedule',
795 'bao' => 'CRM_Core_BAO_ActionSchedule',
797 'FKClassName' => 'CRM_Contact_DAO_Group',
800 'label' => ts("Group"),
802 'pseudoconstant' => [
803 'table' => 'civicrm_group',
805 'labelColumn' => 'title',
809 'msg_template_id' => [
810 'name' => 'msg_template_id',
811 'type' => CRM_Utils_Type
::T_INT
,
812 'title' => ts('Message Template ID'),
813 'description' => ts('FK to the message template.'),
814 'where' => 'civicrm_action_schedule.msg_template_id',
815 'table_name' => 'civicrm_action_schedule',
816 'entity' => 'ActionSchedule',
817 'bao' => 'CRM_Core_BAO_ActionSchedule',
819 'FKClassName' => 'CRM_Core_DAO_MessageTemplate',
821 'label' => ts("Message Template"),
825 'sms_template_id' => [
826 'name' => 'sms_template_id',
827 'type' => CRM_Utils_Type
::T_INT
,
828 'title' => ts('SMS Template ID'),
829 'description' => ts('FK to the message template.'),
830 'where' => 'civicrm_action_schedule.sms_template_id',
831 'table_name' => 'civicrm_action_schedule',
832 'entity' => 'ActionSchedule',
833 'bao' => 'CRM_Core_BAO_ActionSchedule',
835 'FKClassName' => 'CRM_Core_DAO_MessageTemplate',
837 'label' => ts("SMS Template"),
842 'name' => 'absolute_date',
843 'type' => CRM_Utils_Type
::T_DATE
,
844 'title' => ts('Fixed Date for Reminder'),
845 'description' => ts('Date on which the reminder be sent.'),
846 'where' => 'civicrm_action_schedule.absolute_date',
847 'table_name' => 'civicrm_action_schedule',
848 'entity' => 'ActionSchedule',
849 'bao' => 'CRM_Core_BAO_ActionSchedule',
854 'name' => 'from_name',
855 'type' => CRM_Utils_Type
::T_STRING
,
856 'title' => ts('Reminder from Name'),
857 'description' => ts('Name in "from" field'),
859 'size' => CRM_Utils_Type
::HUGE
,
860 'where' => 'civicrm_action_schedule.from_name',
861 'table_name' => 'civicrm_action_schedule',
862 'entity' => 'ActionSchedule',
863 'bao' => 'CRM_Core_BAO_ActionSchedule',
868 'name' => 'from_email',
869 'type' => CRM_Utils_Type
::T_STRING
,
870 'title' => ts('Reminder From Email'),
871 'description' => ts('Email address in "from" field'),
873 'size' => CRM_Utils_Type
::HUGE
,
874 'where' => 'civicrm_action_schedule.from_email',
875 'table_name' => 'civicrm_action_schedule',
876 'entity' => 'ActionSchedule',
877 'bao' => 'CRM_Core_BAO_ActionSchedule',
883 'type' => CRM_Utils_Type
::T_STRING
,
884 'title' => ts('Message Mode'),
885 'description' => ts('Send the message as email or sms or both.'),
887 'size' => CRM_Utils_Type
::HUGE
,
888 'where' => 'civicrm_action_schedule.mode',
889 'default' => 'Email',
890 'table_name' => 'civicrm_action_schedule',
891 'entity' => 'ActionSchedule',
892 'bao' => 'CRM_Core_BAO_ActionSchedule',
897 'pseudoconstant' => [
898 'optionGroupName' => 'msg_mode',
899 'optionEditPath' => 'civicrm/admin/options/msg_mode',
903 'sms_provider_id' => [
904 'name' => 'sms_provider_id',
905 'type' => CRM_Utils_Type
::T_INT
,
906 'title' => ts('SMS Provider ID'),
907 'where' => 'civicrm_action_schedule.sms_provider_id',
908 'table_name' => 'civicrm_action_schedule',
909 'entity' => 'ActionSchedule',
910 'bao' => 'CRM_Core_BAO_ActionSchedule',
912 'FKClassName' => 'CRM_SMS_DAO_Provider',
915 'label' => ts("SMS Provider"),
920 'name' => 'used_for',
921 'type' => CRM_Utils_Type
::T_STRING
,
922 'title' => ts('Used For'),
923 'description' => ts('Used for repeating entity'),
925 'size' => CRM_Utils_Type
::BIG
,
926 'where' => 'civicrm_action_schedule.used_for',
927 'table_name' => 'civicrm_action_schedule',
928 'entity' => 'ActionSchedule',
929 'bao' => 'CRM_Core_BAO_ActionSchedule',
932 'label' => ts("Used For"),
936 'filter_contact_language' => [
937 'name' => 'filter_contact_language',
938 'type' => CRM_Utils_Type
::T_STRING
,
939 'title' => ts('Filter Contact Language'),
940 'description' => ts('Used for multilingual installation'),
942 'size' => CRM_Utils_Type
::HUGE
,
943 'where' => 'civicrm_action_schedule.filter_contact_language',
944 'table_name' => 'civicrm_action_schedule',
945 'entity' => 'ActionSchedule',
946 'bao' => 'CRM_Core_BAO_ActionSchedule',
949 'label' => ts("Filter Contact Language"),
953 'communication_language' => [
954 'name' => 'communication_language',
955 'type' => CRM_Utils_Type
::T_STRING
,
956 'title' => ts('Communication Language'),
957 'description' => ts('Used for multilingual installation'),
959 'size' => CRM_Utils_Type
::EIGHT
,
960 'where' => 'civicrm_action_schedule.communication_language',
961 'table_name' => 'civicrm_action_schedule',
962 'entity' => 'ActionSchedule',
963 'bao' => 'CRM_Core_BAO_ActionSchedule',
966 'label' => ts("Communication Language"),
970 'action_schedule_created_date' => [
971 'name' => 'created_date',
972 'type' => CRM_Utils_Type
::T_TIMESTAMP
,
973 'title' => ts('Created Date'),
974 'description' => ts('When was the scheduled reminder created.'),
976 'where' => 'civicrm_action_schedule.created_date',
978 'default' => 'CURRENT_TIMESTAMP',
979 'table_name' => 'civicrm_action_schedule',
980 'entity' => 'ActionSchedule',
981 'bao' => 'CRM_Core_BAO_ActionSchedule',
986 'name' => 'modified_date',
987 'type' => CRM_Utils_Type
::T_TIMESTAMP
,
988 'title' => ts('Modified Date'),
989 'description' => ts('When the reminder was created or modified.'),
991 'where' => 'civicrm_action_schedule.modified_date',
992 'default' => 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
993 'table_name' => 'civicrm_action_schedule',
994 'entity' => 'ActionSchedule',
995 'bao' => 'CRM_Core_BAO_ActionSchedule',
998 'label' => ts("Modified Date"),
1003 'action_schedule_effective_start_date' => [
1004 'name' => 'effective_start_date',
1005 'type' => CRM_Utils_Type
::T_TIMESTAMP
,
1006 'title' => ts('Effective start date'),
1007 'description' => ts('Earliest date to consider start events from.'),
1008 'required' => FALSE,
1009 'where' => 'civicrm_action_schedule.effective_start_date',
1011 'table_name' => 'civicrm_action_schedule',
1012 'entity' => 'ActionSchedule',
1013 'bao' => 'CRM_Core_BAO_ActionSchedule',
1017 'action_schedule_effective_end_date' => [
1018 'name' => 'effective_end_date',
1019 'type' => CRM_Utils_Type
::T_TIMESTAMP
,
1020 'title' => ts('Effective end date'),
1021 'description' => ts('Latest date to consider end events from.'),
1022 'required' => FALSE,
1023 'where' => 'civicrm_action_schedule.effective_end_date',
1025 'table_name' => 'civicrm_action_schedule',
1026 'entity' => 'ActionSchedule',
1027 'bao' => 'CRM_Core_BAO_ActionSchedule',
1032 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'fields_callback', Civi
::$statics[__CLASS__
]['fields']);
1034 return Civi
::$statics[__CLASS__
]['fields'];
1038 * Return a mapping from field-name to the corresponding key (as used in fields()).
1041 * Array(string $name => string $uniqueName).
1043 public static function &fieldKeys() {
1044 if (!isset(Civi
::$statics[__CLASS__
]['fieldKeys'])) {
1045 Civi
::$statics[__CLASS__
]['fieldKeys'] = array_flip(CRM_Utils_Array
::collect('name', self
::fields()));
1047 return Civi
::$statics[__CLASS__
]['fieldKeys'];
1051 * Returns the names of this table
1055 public static function getTableName() {
1056 return self
::$_tableName;
1060 * Returns if this table needs to be logged
1064 public function getLog() {
1069 * Returns the list of fields that can be imported
1071 * @param bool $prefix
1075 public static function &import($prefix = FALSE) {
1076 $r = CRM_Core_DAO_AllCoreTables
::getImports(__CLASS__
, 'action_schedule', $prefix, []);
1081 * Returns the list of fields that can be exported
1083 * @param bool $prefix
1087 public static function &export($prefix = FALSE) {
1088 $r = CRM_Core_DAO_AllCoreTables
::getExports(__CLASS__
, 'action_schedule', $prefix, []);
1093 * Returns the list of indices
1095 * @param bool $localize
1099 public static function indices($localize = TRUE) {
1101 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables
::multilingualize(__CLASS__
, $indices) : $indices;