1 # BEGIN BPS TAGGED BLOCK {{{
5 # This software is Copyright (c) 1996-2011 Best Practical Solutions, LLC
6 # <sales@bestpractical.com>
8 # (Except where explicitly superseded by other copyright notices)
13 # This work is made available to you under the terms of Version 2 of
14 # the GNU General Public License. A copy of that license should have
15 # been provided with this software, but in any event can be snarfed
18 # This work is distributed in the hope that it will be useful, but
19 # WITHOUT ANY WARRANTY; without even the implied warranty of
20 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
21 # General Public License for more details.
23 # You should have received a copy of the GNU General Public License
24 # along with this program; if not, write to the Free Software
25 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
26 # 02110-1301 or visit their web page on the internet at
27 # http://www.gnu.org/licenses/old-licenses/gpl-2.0.html.
30 # CONTRIBUTION SUBMISSION POLICY:
32 # (The following paragraph is not intended to limit the rights granted
33 # to you to modify and distribute this software under the terms of
34 # the GNU General Public License and is only of importance to you if
35 # you choose to contribute your changes and enhancements to the
36 # community by submitting them to Best Practical Solutions, LLC.)
38 # By intentionally submitting any modifications, corrections or
39 # derivatives to this work, or any other work intended for use with
40 # Request Tracker, to Best Practical Solutions, LLC, you confirm that
41 # you are the copyright holder for those contributions and you grant
42 # Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable,
43 # royalty-free, perpetual, license to use, copy, create derivative
44 # works based on those contributions, and sublicense and distribute
45 # those contributions and any derivatives thereof.
47 # END BPS TAGGED BLOCK }}}
49 # Autogenerated by DBIx::SearchBuilder factory (by <jesse@bestpractical.com>)
50 # WARNING: THIS FILE IS AUTOGENERATED. ALL CHANGES TO THIS FILE WILL BE LOST.
52 # !! DO NOT EDIT THIS FILE !!
77 @ISA= qw( RT::Record );
82 $self->Table('Tickets');
83 $self->SUPER::_Init(@_);
90 =head2 Create PARAMHASH
92 Create takes a hash of values and creates a row in the database:
94 int(11) 'EffectiveId'.
97 int(11) 'IssueStatement'.
100 varchar(200) 'Subject' defaults to '[no subject]'.
101 int(11) 'InitialPriority'.
102 int(11) 'FinalPriority'.
104 int(11) 'TimeEstimated'.
105 int(11) 'TimeWorked'.
106 varchar(10) 'Status'.
113 smallint(6) 'Disabled'.
126 IssueStatement => '0',
129 Subject => '[no subject]',
130 InitialPriority => '0',
131 FinalPriority => '0',
133 TimeEstimated => '0',
145 $self->SUPER::Create(
146 EffectiveId => $args{'EffectiveId'},
147 Queue => $args{'Queue'},
148 Type => $args{'Type'},
149 IssueStatement => $args{'IssueStatement'},
150 Resolution => $args{'Resolution'},
151 Owner => $args{'Owner'},
152 Subject => $args{'Subject'},
153 InitialPriority => $args{'InitialPriority'},
154 FinalPriority => $args{'FinalPriority'},
155 Priority => $args{'Priority'},
156 TimeEstimated => $args{'TimeEstimated'},
157 TimeWorked => $args{'TimeWorked'},
158 Status => $args{'Status'},
159 TimeLeft => $args{'TimeLeft'},
160 Told => $args{'Told'},
161 Starts => $args{'Starts'},
162 Started => $args{'Started'},
164 Resolved => $args{'Resolved'},
165 Disabled => $args{'Disabled'},
174 Returns the current value of id.
175 (In the database, id is stored as int(11).)
183 Returns the current value of EffectiveId.
184 (In the database, EffectiveId is stored as int(11).)
188 =head2 SetEffectiveId VALUE
191 Set EffectiveId to VALUE.
192 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
193 (In the database, EffectiveId will be stored as a int(11).)
201 Returns the current value of Queue.
202 (In the database, Queue is stored as int(11).)
206 =head2 SetQueue VALUE
210 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
211 (In the database, Queue will be stored as a int(11).)
219 Returns the Queue Object which has the id returned by Queue
226 my $Queue = RT::Queue->new($self->CurrentUser);
227 $Queue->Load($self->__Value('Queue'));
235 Returns the current value of Type.
236 (In the database, Type is stored as varchar(16).)
244 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
245 (In the database, Type will be stored as a varchar(16).)
251 =head2 IssueStatement
253 Returns the current value of IssueStatement.
254 (In the database, IssueStatement is stored as int(11).)
258 =head2 SetIssueStatement VALUE
261 Set IssueStatement to VALUE.
262 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
263 (In the database, IssueStatement will be stored as a int(11).)
271 Returns the current value of Resolution.
272 (In the database, Resolution is stored as int(11).)
276 =head2 SetResolution VALUE
279 Set Resolution to VALUE.
280 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
281 (In the database, Resolution will be stored as a int(11).)
289 Returns the current value of Owner.
290 (In the database, Owner is stored as int(11).)
294 =head2 SetOwner VALUE
298 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
299 (In the database, Owner will be stored as a int(11).)
307 Returns the current value of Subject.
308 (In the database, Subject is stored as varchar(200).)
312 =head2 SetSubject VALUE
315 Set Subject to VALUE.
316 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
317 (In the database, Subject will be stored as a varchar(200).)
323 =head2 InitialPriority
325 Returns the current value of InitialPriority.
326 (In the database, InitialPriority is stored as int(11).)
330 =head2 SetInitialPriority VALUE
333 Set InitialPriority to VALUE.
334 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
335 (In the database, InitialPriority will be stored as a int(11).)
343 Returns the current value of FinalPriority.
344 (In the database, FinalPriority is stored as int(11).)
348 =head2 SetFinalPriority VALUE
351 Set FinalPriority to VALUE.
352 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
353 (In the database, FinalPriority will be stored as a int(11).)
361 Returns the current value of Priority.
362 (In the database, Priority is stored as int(11).)
366 =head2 SetPriority VALUE
369 Set Priority to VALUE.
370 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
371 (In the database, Priority will be stored as a int(11).)
379 Returns the current value of TimeEstimated.
380 (In the database, TimeEstimated is stored as int(11).)
384 =head2 SetTimeEstimated VALUE
387 Set TimeEstimated to VALUE.
388 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
389 (In the database, TimeEstimated will be stored as a int(11).)
397 Returns the current value of TimeWorked.
398 (In the database, TimeWorked is stored as int(11).)
402 =head2 SetTimeWorked VALUE
405 Set TimeWorked to VALUE.
406 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
407 (In the database, TimeWorked will be stored as a int(11).)
415 Returns the current value of Status.
416 (In the database, Status is stored as varchar(10).)
420 =head2 SetStatus VALUE
424 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
425 (In the database, Status will be stored as a varchar(10).)
433 Returns the current value of TimeLeft.
434 (In the database, TimeLeft is stored as int(11).)
438 =head2 SetTimeLeft VALUE
441 Set TimeLeft to VALUE.
442 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
443 (In the database, TimeLeft will be stored as a int(11).)
451 Returns the current value of Told.
452 (In the database, Told is stored as datetime.)
460 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
461 (In the database, Told will be stored as a datetime.)
469 Returns the current value of Starts.
470 (In the database, Starts is stored as datetime.)
474 =head2 SetStarts VALUE
478 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
479 (In the database, Starts will be stored as a datetime.)
487 Returns the current value of Started.
488 (In the database, Started is stored as datetime.)
492 =head2 SetStarted VALUE
495 Set Started to VALUE.
496 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
497 (In the database, Started will be stored as a datetime.)
505 Returns the current value of Due.
506 (In the database, Due is stored as datetime.)
514 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
515 (In the database, Due will be stored as a datetime.)
523 Returns the current value of Resolved.
524 (In the database, Resolved is stored as datetime.)
528 =head2 SetResolved VALUE
531 Set Resolved to VALUE.
532 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
533 (In the database, Resolved will be stored as a datetime.)
541 Returns the current value of LastUpdatedBy.
542 (In the database, LastUpdatedBy is stored as int(11).)
550 Returns the current value of LastUpdated.
551 (In the database, LastUpdated is stored as datetime.)
559 Returns the current value of Creator.
560 (In the database, Creator is stored as int(11).)
568 Returns the current value of Created.
569 (In the database, Created is stored as datetime.)
577 Returns the current value of Disabled.
578 (In the database, Disabled is stored as smallint(6).)
582 =head2 SetDisabled VALUE
585 Set Disabled to VALUE.
586 Returns (1, 'Status message') on success and (0, 'Error Message') on failure.
587 (In the database, Disabled will be stored as a smallint(6).)
594 sub _CoreAccessible {
598 {read => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => ''},
600 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
602 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
604 {read => 1, write => 1, sql_type => 12, length => 16, is_blob => 0, is_numeric => 0, type => 'varchar(16)', default => ''},
606 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
608 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
610 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
612 {read => 1, write => 1, sql_type => 12, length => 200, is_blob => 0, is_numeric => 0, type => 'varchar(200)', default => '[no subject]'},
614 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
616 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
618 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
620 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
622 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
624 {read => 1, write => 1, sql_type => 12, length => 10, is_blob => 0, is_numeric => 0, type => 'varchar(10)', default => ''},
626 {read => 1, write => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
628 {read => 1, write => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
630 {read => 1, write => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
632 {read => 1, write => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
634 {read => 1, write => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
636 {read => 1, write => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
638 {read => 1, auto => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
640 {read => 1, auto => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
642 {read => 1, auto => 1, sql_type => 4, length => 11, is_blob => 0, is_numeric => 1, type => 'int(11)', default => '0'},
644 {read => 1, auto => 1, sql_type => 11, length => 0, is_blob => 0, is_numeric => 0, type => 'datetime', default => ''},
646 {read => 1, write => 1, sql_type => 5, length => 6, is_blob => 0, is_numeric => 1, type => 'smallint(6)', default => '0'},
651 RT::Base->_ImportOverlays();
655 This class allows "overlay" methods to be placed
656 into the following files _Overlay is for a System overlay by the original author,
657 _Vendor is for 3rd-party vendor add-ons, while _Local is for site-local customizations.
659 These overlay files can contain new subs or subs to replace existing subs in this module.
661 Each of these files should begin with the line
663 no warnings qw(redefine);
665 so that perl does not kick and scream when you redefine a subroutine or variable in your overlay.
667 RT::Ticket_Overlay, RT::Ticket_Vendor, RT::Ticket_Local