Problem adding fields to a reservation

[joedekangeroe]

Hi

I tried to add two extra fields to a reservation. I have downloaded the developer guide and followed instructions.

Now I can make a new reservation but phpscheduleit does not save the given information correctly. He is mixing up some fields.

Modifications to a reservations can be made without any issues.

Any thoughts?

[Nick]

My first guess is that you may be passing the values to the database in the wrong order.

[joedekangeroe]

I altered the database by adding two extra fields (startplace and destination)

Code:

CREATE TABLE `reservations` (
  `resid` varchar(16) NOT NULL default '',
  `machid` varchar(16) NOT NULL default '',
  `scheduleid` varchar(16) NOT NULL default '',
  `start_date` int(11) NOT NULL default '0',
  `end_date` int(11) NOT NULL default '0',
  `starttime` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  `created` int(11) NOT NULL default '0',
  `modified` int(11) default NULL,
  `parentid` varchar(16) default NULL,
  `startplace` text,
  `destination` text,
  `summary` text,
  `is_blackout` smallint(1) NOT NULL default '0',
  `is_pending` smallint(1) NOT NULL default '0',
  `allow_participation` smallint(6) NOT NULL default '0',
  `allow_anon_participation` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`resid`),
  KEY `res_resid` (`resid`),
  KEY `res_machid` (`machid`),
  KEY `res_startTime` (`starttime`),
  KEY `res_endTime` (`endtime`),
  KEY `res_created` (`created`),
  KEY `res_modified` (`modified`),
  KEY `res_isblackout` (`is_blackout`),
  KEY `res_scheduleid` (`scheduleid`),
  KEY `reservations_ispending` (`is_pending`),
  KEY `reservations_startdate` (`start_date`),
  KEY `reservations_enddate` (`end_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

And in ResDB.class.php I have:

Code:

function add_res($res, $is_parent, $users_to_invite, $resources_to_add, $accept_code) {
$id = $this->get_new_id();

// Insert the main reservation data
$values = array (
$id,
$res->get_machid(),
$res->get_scheduleid(),
$res->get_start_date(),
$res->get_end_date(),
$res->get_start(),
$res->get_end(),
mktime(),
null,
($is_parent ? $id : $res->get_parentid()),
intval($res->is_blackout),
$res->get_pending(),
$res->get_startplace(),
$res->get_destination(),
$res->get_summary(),
$res->get_allow_participation(),
$res->get_allow_anon_participation()
);

$query = 'INSERT INTO ' . $this->get_table(TBL_RESERVATIONS) . ' VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
$q = $this->db->prepare($query);
$result = $this->db->execute($q, $values);
$this->check_for_error($result);

// Insert the user participation data
$values = null;
$values[] = array($id, $res->get_memberid(), 1, 0, 1, 1, null);

foreach ($users_to_invite as $memberid => $email) {
$values[] = array($id, $memberid, 0, 1, 0, 0, $accept_code);
}

$query = 'INSERT INTO ' . $this->get_table(TBL_RESERVATION_USERS) . ' VALUES(?,?,?,?,?,?,?)';
$q = $this->db->prepare($query);
$result = $this->db->executeMultiple($q, $values);
$this->check_for_error($result);

// Insert the additional resources data
if (count($resources_to_add) > 0) {
$values = null;
for ($i = 0; $i < count($resources_to_add); $i++) {
$values[] = array($id, $resources_to_add[$i], 0);
}

$query = 'INSERT INTO ' . $this->get_table(TBL_RESERVATION_RESOURCES) . ' VALUES(?,?,?)';
$q = $this->db->prepare($query);
$result = $this->db->executeMultiple($q, $values);
$this->check_for_error($result);
}

unset($values, $query);
return $id;
}

[Nick]

Should be:

Code:

$values = array (
               $id,
               $res->get_machid(),
               $res->get_scheduleid(),
               $res->get_start_date(),
               $res->get_end_date(),
               $res->get_start(),
               $res->get_end(),
               mktime(),
               null,
               ($is_parent ? $id : $res->get_parentid()),            
               $res->get_startplace(),
               $res->get_destination(),
               $res->get_summary(),
 intval($res->is_blackout),
               $res->get_pending(),
               $res->get_allow_participation(),
               $res->get_allow_anon_participation()
            );

[joedekangeroe]

It works! Thanks a lot.

[zaky]

I have the same problem, the value of the new field  selected from a dropdown list of a combobox is not saved in the database ( looking at the reservation table the value zero is stored instead).
What should I need to change?

[Nick]

Sounds like the value was not added to the update SQL statement, or it was not pulled off of the form.  I'd add echo statements along the code path that you changed and see where the value is being lost.

[Marisa261]

I have the same problem and can't fix it!!!
I'm very angry
hopefully fixed soon

[Marisa261]

i solve it

[Marishvcard]

I have the problem is very hardly
please help me

[BernardII]

I am also facing the same problem...i tried the given recommendation. But i think i am on the wrong track

Please Help

[Gornur9]

Thanks to the answer of Nick.
I solve the problem!! 

R4R4

R4R4

 

[tineg@94]

Hi,


Could someone update the Develloper Guide PDF file according to the phpSchedulIt 2.x version?
I know that a new field "Attribute" is going to be added nearly however it would be nice to have a generic method to add a field anywhere.


Thanks in advance

[Nick]

I'll put it on my list. The trouble is there isn't a very generic way of doing this. It's all based on context and what you're trying to achieve.