12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019 |
- class CreateObjectManager < ActiveRecord::Migration
- def up
- add_column :tickets, :pending_time, :timestamp, :null => true
- add_index :tickets, [:pending_time]
- add_column :tickets, :type, :string, :limit => 100, :null => true
- add_index :tickets, [:type]
- create_table :object_manager_attributes do |t|
- t.references :object_lookup, :null => false
- t.column :name, :string, :limit => 200, :null => false
- t.column :display, :string, :limit => 200, :null => false
- t.column :data_type, :string, :limit => 100, :null => false
- t.column :data_option, :string, :limit => 8000, :null => true
- t.column :editable, :boolean, :null => false, :default => true
- t.column :active, :boolean, :null => false, :default => true
- t.column :screens, :string, :limit => 2000, :null => true
- t.column :pending_migration, :boolean, :null => false, :default => true
- t.column :position, :integer, :null => false
- t.column :created_by_id, :integer, :null => false
- t.column :updated_by_id, :integer, :null => false
- t.timestamps
- end
- add_index :object_manager_attributes, [:name], :unique => true
- add_index :object_manager_attributes, [:object_lookup_id]
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'customer_id',
- :display => 'Customer',
- :data_type => 'autocompletion',
- :data_option => {
- :relation => 'User',
- :autocapitalize => false,
- :multiple => false,
- :null => false,
- :limit => 200,
- :placeholder => 'Enter Person or Organisation/Company',
- :help => 'Select the customer of the Ticket or create one.',
- :helpLink => '<a href="" class="customer_new">»</a>',
- :minLengt => 2,
- :translate => false,
- :source => '#{@apiPath}/users/search',
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {
- :Agent => {
- :null => false,
- },
- },
- :edit => {},
- },
- :pending_migration => false,
- :position => 10,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'type',
- :display => 'Type',
- :data_type => 'select',
- :data_option => {
- :options => {
- 'Incident' => 'Incident',
- 'Problem' => 'Problem',
- 'Request for Change' => 'Request for Change',
- },
- :nulloption => true,
- :multiple => false,
- :null => true,
- :translate => true,
- },
- :editable => false,
- :active => false,
- :screens => {
- :create_middle => {
- '-all-' => {
- :null => false,
- :item_class => 'column',
- },
- },
- :edit => {
- :Agent => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 20,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'group_id',
- :display => 'Group',
- :data_type => 'select',
- :data_option => {
- :relation => 'Group',
- :relation_condition => { :access => 'rw' },
- :nulloption => true,
- :multiple => false,
- :null => false,
- :translate => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_middle => {
- '-all-' => {
- :null => false,
- :item_class => 'column',
- },
- },
- :edit => {
- :Agent => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 20,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'owner_id',
- :display => 'Owner',
- :data_type => 'select',
- :data_option => {
- :relation => 'User',
- :relation_condition => { :roles => 'Agent' },
- :nulloption => true,
- :multiple => false,
- :null => true,
- :translate => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_middle => {
- :Agent => {
- :null => true,
- :item_class => 'column',
- },
- },
- :edit => {
- :Agent => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 30,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'state_id',
- :display => 'State',
- :data_type => 'select',
- :data_option => {
- :relation => 'TicketState',
- :nulloption => true,
- :multiple => false,
- :null => false,
- :default => 2,
- :translate => true,
- :filter => [1,2,3,4],
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_middle => {
- :Agent => {
- :null => false,
- :item_class => 'column',
- },
- :Customer => {
- :item_class => 'column',
- :nulloption => false,
- :null => true,
- :filter => [1,4],
- :default => 1,
- },
- },
- :edit => {
- :Agent => {
- :nulloption => false,
- :null => false,
- :filter => [2,3,4],
- },
- :Customer => {
- :nulloption => false,
- :null => true,
- :filter => [2,4],
- :default => 2,
- },
- },
- },
- :pending_migration => false,
- :position => 40,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'pending_time',
- :display => 'Pending till',
- :data_type => 'datetime',
- :data_option => {
- :future => true,
- :past => false,
- :diff => 24,
- :null => true,
- :translate => true,
- :required_if => {
- :state_id => [3]
- },
- :shown_if => {
- :state_id => [3]
- },
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_middle => {
- '-all-' => {
- :null => false,
- :item_class => 'column',
- },
- },
- :edit => {
- :Agent => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 41,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'priority_id',
- :display => 'Priority',
- :data_type => 'select',
- :data_option => {
- :relation => 'TicketPriority',
- :nulloption => true,
- :multiple => false,
- :null => false,
- :default => 2,
- :translate => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_middle => {
- :Agent => {
- :null => false,
- :item_class => 'column',
- },
- },
- :create_web => {},
- :edit => {
- :Agent => {
- :null => false,
- :nulloption => false,
- },
- },
- },
- :pending_migration => false,
- :position => 80,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'tags',
- :display => 'Tags',
- :data_type => 'tag',
- :data_option => {
- :type => 'text',
- :null => true,
- :translate => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_bottom => {
- :Agent => {
- :null => true,
- },
- },
- :create_web => {},
- :edit => {},
- },
- :pending_migration => false,
- :position => 900,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'Ticket',
- :name => 'title',
- :display => 'Title',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 200,
- :null => false,
- :translate => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {
- '-all-' => {
- :null => false,
- },
- },
- :create_web => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {},
- },
- :pending_migration => false,
- :position => 15,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'TicketArticle',
- :name => 'type_id',
- :display => 'Type',
- :data_type => 'select',
- :data_option => {
- :relation => 'TicketArticleType',
- :nulloption => false,
- :multiple => false,
- :null => false,
- :default => 9,
- :translate => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {},
- :edit => {
- :Agent => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 100,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'TicketArticle',
- :name => 'internal',
- :display => 'Visibility',
- :data_type => 'select',
- :data_option => {
- :options => { :true => 'internal', :false => 'public' },
- :nulloption => false,
- :multiple => false,
- :null => true,
- :default => false,
- :translate => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {},
- :edit => {
- :Agent => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 200,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'TicketArticle',
- :name => 'to',
- :display => 'To',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 1000,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {},
- :edit => {
- :Agent => {
- :null => true,
- },
- }, },
- :pending_migration => false,
- :position => 300,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'TicketArticle',
- :name => 'cc',
- :display => 'Cc',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 1000,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_phone_in => {},
- :create_phone_out => {},
- :create_email_out => {
- '-all-' => {
- :null => true,
- }
- },
- :create_web => {},
- :edit => {
- :Agent => {
- :null => true,
- },
- }, },
- :pending_migration => false,
- :position => 400,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'TicketArticle',
- :name => 'body',
- :display => 'Text',
- :data_type => 'textarea',
- :data_option => {
- :type => 'text',
- :maxlength => 20000,
- :upload => true,
- :rows => 8,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :create_top => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {
- :Agent => {
- :null => true,
- },
- :Customer => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 600,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'login',
- :display => 'Login',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 100,
- :null => true,
- :autocapitalize => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {},
- },
- :pending_migration => false,
- :position => 100,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'firstname',
- :display => 'Firstname',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 150,
- :null => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {
- '-all-' => {
- :null => false,
- },
- },
- :invite_agent => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {
- '-all-' => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 200,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'lastname',
- :display => 'Lastname',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 150,
- :null => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {
- '-all-' => {
- :null => false,
- },
- },
- :invite_agent => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {
- '-all-' => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 300,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'email',
- :display => 'Email',
- :data_type => 'input',
- :data_option => {
- :type => 'email',
- :maxlength => 150,
- :null => false,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {
- '-all-' => {
- :null => false,
- },
- },
- :invite_agent => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {
- '-all-' => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 400,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'web',
- :display => 'Web',
- :data_type => 'input',
- :data_option => {
- :type => 'url',
- :maxlength => 250,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 500,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'phone',
- :display => 'Phone',
- :data_type => 'input',
- :data_option => {
- :type => 'phone',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 600,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'mobile',
- :display => 'Mobile',
- :data_type => 'input',
- :data_option => {
- :type => 'phone',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 700,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'fax',
- :display => 'Fax',
- :data_type => 'input',
- :data_option => {
- :type => 'phone',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 800,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'organization_id',
- :display => 'Organization',
- :data_type => 'select',
- :data_option => {
- :multiple => false,
- :nulloption => true,
- :null => true,
- :relation => 'Organization',
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 900,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'department',
- :display => 'Department',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 200,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1000,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'street',
- :display => 'Street',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1100,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'zip',
- :display => 'Zip',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1200,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'city',
- :display => 'City',
- :data_type => 'input',
- :data_option => {
- :type => 'text',
- :maxlength => 100,
- :null => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1300,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'password',
- :display => 'Password',
- :data_type => 'input',
- :data_option => {
- :type => 'password',
- :maxlength => 100,
- :null => true,
- :autocomplete => 'off',
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {
- '-all-' => {
- :null => true,
- },
- },
- :invite_agent => {},
- :edit => {
- :Admin => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1400,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'note',
- :display => 'Note',
- :data_type => 'textarea',
- :data_option => {
- :type => 'text',
- :maxlength => 250,
- :null => true,
- :note => 'Notes are visible to agents only, never to customers.',
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- '-all-' => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1500,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'role_ids',
- :display => 'Roles',
- :data_type => 'checkbox',
- :data_option => {
- :multiple => true,
- :null => false,
- :relation => 'Role',
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- :Admin => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 1600,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'group_ids',
- :display => 'Groups',
- :data_type => 'checkbox',
- :data_option => {
- :multiple => true,
- :null => true,
- :relation => 'Group',
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {
- '-all-' => {
- :null => false,
- },
- },
- :edit => {
- :Admin => {
- :null => true,
- },
- },
- },
- :pending_migration => false,
- :position => 1700,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- ObjectManager::Attribute.add(
- :object => 'User',
- :name => 'active',
- :display => 'Active',
- :data_type => 'boolean',
- :data_option => {
- :maxlength => 250,
- :null => true,
- :default => true,
- },
- :editable => false,
- :active => true,
- :screens => {
- :signup => {},
- :invite_agent => {},
- :edit => {
- :Admin => {
- :null => false,
- },
- },
- },
- :pending_migration => false,
- :position => 1800,
- :created_by_id => 1,
- :updated_by_id => 1,
- )
- end
- def down
- drop_table :object_manager_attributes
- end
- end
|