/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('monitor_post_count')->setCustomRepositoryClass('MauticPlugin\\MauticSocialBundle\\Entity\\PostCountRepository'); $builder->addId(); $builder->createManyToOne('monitor', 'Monitoring')->addJoinColumn('monitor_id', 'id', true, false, 'CASCADE')->build(); $builder->addNamedField('postDate', 'date', 'post_date'); $builder->addNamedField('postCount', 'integer', 'post_count'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('focus_stats')->setCustomRepositoryClass('MauticPlugin\\MauticFocusBundle\\Entity\\StatRepository')->addIndex(['type'], 'focus_type')->addIndex(['type', 'type_id'], 'focus_type_id')->addIndex(['date_added'], 'focus_date_added'); $builder->addId(); $builder->createManyToOne('focus', 'Focus')->addJoinColumn('focus_id', 'id', false, false, 'CASCADE')->build(); $builder->addField('type', 'string'); $builder->addNamedField('typeId', 'integer', 'type_id', true); $builder->addNamedField('dateAdded', 'datetime', 'date_added'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('monitoring_leads')->setCustomRepositoryClass('MauticPlugin\\MauticSocialBundle\\Entity\\LeadRepository'); $builder->createManyToOne('monitor', 'Monitoring')->isPrimaryKey()->addJoinColumn('monitor_id', 'id', false, false, 'CASCADE')->build(); $builder->addLead(false, 'CASCADE', true); $builder->addNamedField('dateAdded', 'datetime', 'date_added'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('channel_url_trackables')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\TrackableRepository')->addIndex(['channel', 'channel_id'], 'channel_url_trackable_search'); $builder->createManyToOne('redirect', 'Mautic\\PageBundle\\Entity\\Redirect')->addJoinColumn('redirect_id', 'id', true, false, 'CASCADE')->cascadePersist()->inversedBy('trackables')->isPrimaryKey()->build(); $builder->createField('channelId', 'integer')->columnName('channel_id')->isPrimaryKey()->build(); $builder->addField('channel', 'string'); $builder->addField('hits', 'integer'); $builder->addNamedField('uniqueHits', 'integer', 'unique_hits'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('lead_frequencyrules')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\FrequencyRuleRepository')->addIndex(['channel'], 'channel_frequency'); $builder->addId(); $builder->addLead(false, 'CASCADE', false, 'frequencyRules'); $builder->addDateAdded(); $builder->addNamedField('frequencyNumber', 'smallint', 'frequency_number'); $builder->createField('frequencyTime', 'string')->columnName('frequency_time')->length(25)->build(); $builder->createField('channel', 'string')->build(); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('lead_donotcontact')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\DoNotContactRepository')->addIndex(['reason'], 'dnc_reason_search'); $builder->addId(); $builder->addLead(true, 'CASCADE', false, 'doNotContact'); $builder->addDateAdded(); $builder->createField('reason', 'smallint')->build(); $builder->createField('channel', 'string')->build(); $builder->addNamedField('channelId', 'integer', 'channel_id', true); $builder->createField('comments', 'text')->nullable()->build(); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('monitoring')->setCustomRepositoryClass('MauticPlugin\\MauticSocialBundle\\Entity\\MonitoringRepository')->addLifecycleEvent('cleanMonitorData', 'preUpdate')->addLifecycleEvent('cleanMonitorData', 'prePersist'); $builder->addCategory(); $builder->addIdColumns('title'); $builder->addNullableField('lists', 'array'); $builder->addNamedField('networkType', 'string', 'network_type', true); $builder->addField('revision', 'integer'); $builder->addNullableField('stats', 'array'); $builder->addNullableField('properties', 'array'); $builder->addPublishDates(); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('page_redirects')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\RedirectRepository'); $builder->addId(); $builder->createField('redirectId', 'string')->columnName('redirect_id')->length(25)->build(); $builder->addField('url', 'text'); $builder->addField('hits', 'integer'); $builder->createField('uniqueHits', 'integer')->columnName('unique_hits')->build(); $builder->createOneToMany('trackables', 'Trackable')->mappedBy('redirect')->fetchExtraLazy()->build(); // @deprecated to be removed in 2.0 $builder->addNamedField('email', 'integer', 'email_id', true); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('campaign_lead_event_log')->setCustomRepositoryClass('Mautic\\CampaignBundle\\Entity\\LeadEventLogRepository')->addIndex(['is_scheduled'], 'event_upcoming_search')->addIndex(['date_triggered'], 'campaign_date_triggered')->addIndex(['lead_id', 'campaign_id'], 'campaign_leads'); $builder->createManyToOne('event', 'Event')->isPrimaryKey()->inversedBy('log')->addJoinColumn('event_id', 'id', false, false, 'CASCADE')->build(); $builder->addLead(false, 'CASCADE', true); $builder->createManyToOne('campaign', 'Campaign')->addJoinColumn('campaign_id', 'id')->build(); $builder->addIpAddress(true); $builder->createField('dateTriggered', 'datetime')->columnName('date_triggered')->nullable()->build(); $builder->createField('isScheduled', 'boolean')->columnName('is_scheduled')->build(); $builder->createField('triggerDate', 'datetime')->columnName('trigger_date')->nullable()->build(); $builder->createField('systemTriggered', 'boolean')->columnName('system_triggered')->build(); $builder->createField('metadata', 'array')->nullable()->build(); $builder->addNullableField('channel', 'string'); $builder->addNamedField('channelId', 'integer', 'channel_id', true); $builder->addNullableField('nonActionPathTaken', 'boolean', 'non_action_path_taken'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('focus')->setCustomRepositoryClass('MauticPlugin\\MauticFocusBundle\\Entity\\FocusRepository')->addIndex(['focus_type'], 'focus_type')->addIndex(['style'], 'focus_style')->addIndex(['form_id'], 'focus_form'); $builder->addIdColumns(); $builder->addCategory(); $builder->addNamedField('type', 'string', 'focus_type'); $builder->addField('style', 'string'); $builder->addNullableField('website', 'string'); $builder->addPublishDates(); $builder->addNullableField('properties', 'array'); $builder->addNamedField('form', 'integer', 'form_id', true); $builder->addNullableField('cache', 'text'); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('message_queue')->setCustomRepositoryClass('Mautic\\CoreBundle\\Entity\\MessageQueueRepository')->addIndex(['status'], 'message_status_search')->addIndex(['date_sent'], 'message_date_sent')->addIndex(['scheduled_date'], 'message_scheduled_date')->addIndex(['priority'], 'message_priority')->addIndex(['success'], 'message_success')->addIndex(['channel', 'channel_id'], 'message_channel_search'); $builder->addId(); $builder->addField('channel', 'string'); $builder->addNamedField('channelId', 'integer', 'channel_id'); $builder->createManyToOne('event', 'Mautic\\CampaignBundle\\Entity\\Event')->addJoinColumn('event_id', 'id', true, false, 'CASCADE')->build(); $builder->addLead(false, 'CASCADE', false); $builder->createField('priority', 'smallint')->columnName('priority')->build(); $builder->createField('maxAttempts', 'smallint')->columnName('max_attempts')->build(); $builder->createField('attempts', 'smallint')->columnName('attempts')->build(); $builder->createField('success', 'boolean')->columnName('success')->build(); $builder->createField('status', 'string')->columnName('status')->build(); $builder->createField('datePublished', 'datetime')->columnName('date_published')->nullable()->build(); $builder->createField('scheduledDate', 'datetime')->columnName('scheduled_date')->nullable()->build(); $builder->createField('lastAttempt', 'datetime')->columnName('last_attempt')->nullable()->build(); $builder->createField('dateSent', 'datetime')->columnName('date_sent')->nullable()->build(); $builder->createField('options', 'array')->nullable()->build(); }