gjAxBk9G

1NEW =============================
2CREATE TABLE IF NOT EXISTS `tickets` (
3  `id` int(11) NOT NULL auto_increment,
4  `number` varchar(40) NOT NULL,
5  `email` varchar(255) NOT NULL default '',
6  `name` varchar(20) NOT NULL default '',
7  `subject` varchar(255) NOT NULL default '',
8  `date` int(11) NOT NULL default '0',
9  `status` int(11) NOT NULL default '0',
10  `priority` tinyint(4) NOT NULL default '0',
11  `lastactivity` int(11) NOT NULL default '0',
12  `lastpost` int(11) NOT NULL default '-1',
13  PRIMARY KEY  (`id`)
14) 
15
16OLD ==============================
17CREATE TABLE IF NOT EXISTS `tickets` (
18  `id` int(11) NOT NULL auto_increment,
19  `number` varchar(40) NOT NULL,
20  `dept_id` int(11) NOT NULL default '0',
21  `email` varchar(255) NOT NULL default '',
22  `name` varchar(20) NOT NULL default '',
23  `subject` varchar(255) NOT NULL default '',
24  `date` int(11) NOT NULL default '0',
25  `status` int(11) NOT NULL default '0',
26  `notify` tinyint(4) NOT NULL default '1',
27  `priority` tinyint(4) NOT NULL default '0',
28  `custom` text NOT NULL,
29  `lastactivity` int(11) NOT NULL default '0',
30  `lastpost` int(11) NOT NULL default '-1',
31  `flag` int(11) NOT NULL default '-1',
32  `private` int(4) NOT NULL default '0',
33  `cc` text NOT NULL,
34  `phone` varchar(20) default '',
35  `company` varchar(255) default '',
36  PRIMARY KEY  (`id`)
37)
38  def create
39    @ticket = Ticket.new(params[:ticket])
40
41    respond_to do |format|
42      if @ticket.save
43        flash[:notice] = 'Ticket was successfully created.'
44        format.html { redirect_to(@ticket) }
45        format.xml  { render :xml => @ticket, :status => :created, :location => @ticket }
46      else
47        format.html { render :action => "new" }
48        format.xml  { render :xml => @ticket.errors, :status => :unprocessable_entity }
49      end
50    end
51  end
52
53
54class Ticket < ActiveRecord::Base
55  attr_accessor :message
56  
57
58  def validate
59    errors.add(:Name, "must not be empty") if name.empty?
60    errors.add(:Email, "must not be empty") if email.empty?
61    errors.add(:Subject, "must not be empty") if subject.empty?
62    errors.add(:Message, "must not be empty") if message.empty?
63  end
64  
65end