|
|
|---|
| 0 |
-- a/classes/registration/RegistrationOptionDAO.inc.php |
0 |
++ b/classes/registration/RegistrationOptionDAO.inc.php |
|
Lines 178-184
class RegistrationOptionDAO extends DAO {
|
Link Here
|
|---|
|
|---|
| 178 |
$registrationOption->setSchedConfId($row['sched_conf_id']); |
178 |
$registrationOption->setSchedConfId($row['sched_conf_id']); |
| 179 |
$registrationOption->setCode($row['code']); |
179 |
$registrationOption->setCode($row['code']); |
| 180 |
$registrationOption->setOpeningDate($this->dateFromDB($row['opening_date'])); |
180 |
$registrationOption->setOpeningDate($this->dateFromDB($row['opening_date'])); |
| 181 |
$registrationOption->setClosingDate($this->dateFromDB($row['closing_date'])); |
181 |
$registrationOption->setClosingDate($this->datetimeFromDB($row['closing_date'])); |
| 182 |
$registrationOption->setSequence($row['seq']); |
182 |
$registrationOption->setSequence($row['seq']); |
| 183 |
$registrationOption->setPublic($row['pub']); |
183 |
$registrationOption->setPublic($row['pub']); |
| 184 |
|
184 |
|
|
Lines 219-225
class RegistrationOptionDAO extends DAO {
|
Link Here
|
|---|
|
|---|
| 219 |
VALUES |
219 |
VALUES |
| 220 |
(?, %s, %s, ?, ?, ?)', |
220 |
(?, %s, %s, ?, ?, ?)', |
| 221 |
$this->dateToDB($registrationOption->getOpeningDate()), |
221 |
$this->dateToDB($registrationOption->getOpeningDate()), |
| 222 |
$this->dateToDB($registrationOption->getClosingDate()) |
222 |
$this->datetimeToDB($registrationOption->getClosingDate()) |
| 223 |
), array( |
223 |
), array( |
| 224 |
(int) $registrationOption->getSchedConfId(), |
224 |
(int) $registrationOption->getSchedConfId(), |
| 225 |
(int) $registrationOption->getPublic(), |
225 |
(int) $registrationOption->getPublic(), |
|
Lines 250-256
class RegistrationOptionDAO extends DAO {
|
Link Here
|
|---|
|
|---|
| 250 |
code = ? |
250 |
code = ? |
| 251 |
WHERE option_id = ?', |
251 |
WHERE option_id = ?', |
| 252 |
$this->dateToDB($registrationOption->getOpeningDate()), |
252 |
$this->dateToDB($registrationOption->getOpeningDate()), |
| 253 |
$this->dateToDB($registrationOption->getClosingDate()) |
253 |
$this->datetimeToDB($registrationOption->getClosingDate()) |
| 254 |
), array( |
254 |
), array( |
| 255 |
(int) $registrationOption->getSchedConfId(), |
255 |
(int) $registrationOption->getSchedConfId(), |
| 256 |
(int) $registrationOption->getPublic(), |
256 |
(int) $registrationOption->getPublic(), |
| 257 |
-- a/classes/registration/RegistrationTypeDAO.inc.php |
257 |
++ b/classes/registration/RegistrationTypeDAO.inc.php |
|
Lines 234-240
class RegistrationTypeDAO extends DAO {
|
Link Here
|
|---|
|
|---|
| 234 |
$registrationType->setCost($row['cost']); |
234 |
$registrationType->setCost($row['cost']); |
| 235 |
$registrationType->setCurrencyCodeAlpha($row['currency_code_alpha']); |
235 |
$registrationType->setCurrencyCodeAlpha($row['currency_code_alpha']); |
| 236 |
$registrationType->setOpeningDate($this->dateFromDB($row['opening_date'])); |
236 |
$registrationType->setOpeningDate($this->dateFromDB($row['opening_date'])); |
| 237 |
$registrationType->setClosingDate($this->dateFromDB($row['closing_date'])); |
237 |
$registrationType->setClosingDate($this->datetimeFromDB($row['closing_date'])); |
| 238 |
$registrationType->setExpiryDate($this->dateFromDB($row['expiry_date'])); |
238 |
$registrationType->setExpiryDate($this->dateFromDB($row['expiry_date'])); |
| 239 |
$registrationType->setAccess($row['access']); |
239 |
$registrationType->setAccess($row['access']); |
| 240 |
$registrationType->setInstitutional($row['institutional']); |
240 |
$registrationType->setInstitutional($row['institutional']); |
| 241 |
-- a/dbscripts/xml/ocs_schema.xml |
241 |
++ b/dbscripts/xml/ocs_schema.xml |
|
|
|---|
| 1382 |
</field> |
1382 |
</field> |
| 1383 |
<field name="code" type="C2" size="80" /> |
1383 |
<field name="code" type="C2" size="80" /> |
| 1384 |
<field name="opening_date" type="D"/> |
1384 |
<field name="opening_date" type="D"/> |
| 1385 |
<field name="closing_date" type="D"> |
1385 |
<field name="closing_date" type="T"> |
| 1386 |
<NOTNULL/> |
1386 |
<NOTNULL/> |
| 1387 |
</field> |
1387 |
</field> |
| 1388 |
<field name="pub" type="I1"> |
1388 |
<field name="pub" type="I1"> |