WebDocument.inc
4.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
/**
* Class Web Documents
*
* Represents a web document as per the web_documents table in the database
*
* @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa
* @date 19 January 2003
*/
class WebDocument {
/** primary key of web document */
var $iId;
/** primary key of document to which this web document related*/
var $iDocumentID;
/** primary key of web site on which document is published */
var $iWebSiteID;
/** unit to which this document belongs */
var $iUnitID;
/** status of document */
var $iStatusID;
var $dDateTime;
function WebDocument($iNewDocumentID, $iNewWebSiteID, $iNewUnitID, $iNewStatusID, $dNewDateTime) {
//object not yet created in database
$this->iId = -1;
$this->iDocumentID = $iNewDocumentID;
$this->iWebSiteID = $iNewWebSiteID;
$this->iUnitID = $iNewUnitID;
$this->iStatusID = $iNewStatusID;
$this->dDateTime = $dNewDateTime;
}
/**
* Create the current object in the database
*
* @return boolean on successful store, false otherwise and set $_SESSION["errorMessage"]
*
*/
function create() {
global $default, $lang_err_database, $lang_err_object_exists;
//if the object hasn't been created
if ($this->iId < 0) {
$sql = new Owl_DB();
$result = $sql->query("INSERT INTO " . $default->owl_web_documents_table . " (document_id, web_site_id, unit_id, status_id, datetime) VALUES ($this->iDocumentID, $this->iWebSiteID, $this->iUnitID, $this->iStatusID, '$this->dDateTime')");
if ($result) {
$this->iId = $sql->insert_id();
return true;
}
$_SESSION["errorMessage"] = $lang_err_database;
return false;
}
$_SESSION["errorMessage"] = $lang_err_object_exists . "id = " . $this->iId . " table = document_fields";
return false;
}
/**
* Update the values in the database table with the object's current values
*
* @return boolean true on successful update, false otherwise and set $_SESSION["errorMessage"]
*
*/
function update() {
global $default, $lang_err_database, $lang_err_object_key;
//only update if the object has been stored
if ($this->iId > 0) {
$sql = new Owl_DB();
$result = $sql->query("UPDATE " . $default->owl_web_documents_table . " SET document_id = $this->iDocumentID, web_site_id = $this->iWebSiteID, unit_id = $this->iUnitID, status_id = $this->iStatusID, datetime = '$this->dDateTime' WHERE id = $this->iId");
if ($result) {
return true;
}
$_SESSION["errorMessage"] = $lang_err_database;
return false;
}
$_SESSION["errorMessage"] = $lang_err_object_key;
return false;
}
/**
* Delete the current object from the database
*
* @return boolean true on successful deletion, false otherwise and set $_SESSION["errorMessage"]
*
*/
function delete() {
global $default, $lang_err_database, $lang_err_object_key;
//only delete the object if it exists in the database
if ($this->iId >= 0) {
$sql = new Owl_DB();
$result = $sql->query("DELETE FROM $default->owl_web_documents_table WHERE id = $this->iId");
if ($result) {
return true;
}
$_SESSION["errorMessage"] = $lang_err_database;
return false;
}
$_SESSION["errorMessage"] = $lang_err_object_key;
return false;
}
/**
* Static function.
* Given a web_documents primary key it will create a
* WebDocuments object and populate it with the
* corresponding database values
*
* @return WebDocument populated WebDocument object on successful query, false otherwise and set $_SESSION["errorMessage"]
*/
function & get($iWebDocumentsID) {
global $default;
$sql = new Owl_DB();
$result = $sql->query("SELECT * FROM $default->owl_web_documents_table WHERE id = $iWebDocumentsID");
if ($result) {
if ($sql->next_record()) {
$oWebDocument = & new WebDocument($sql->f("document_id"), $sql->f("web_site_id"), $sql->f("unit_id"), $sql->f("status_id"), $sql->f("datetime"));
$oWebDocument->iId = $iWebDocumentsID;
return $oWebDocument;
}
$_SESSION["errorMessage"] = $lang_err_object_not_exist . "id = " . $iWebDocumentsID . " table = $default->owl_web_documents_table";
return false;
}
$_SESSION["errorMessage"] = $lang_err_database;
return false;
}
}
?>