hpdl
|
210
|
1
|
<?php
|
|
2
|
/*
|
|
3
|
$Id: account.php 207 2005-09-26 01:29:31 +0200 (Mo, 26 Sep 2005) hpdl $
|
|
4
|
|
|
5
|
osCommerce, Open Source E-Commerce Solutions
|
|
6
|
http://www.oscommerce.com
|
|
7
|
|
|
8
|
Copyright (c) 2005 osCommerce
|
|
9
|
|
|
10
|
Released under the GNU General Public License
|
|
11
|
*/
|
|
12
|
|
|
13
|
class osC_Product {
|
|
14
|
var $_data = array();
|
|
15
|
|
|
16
|
function osC_Product($id) {
|
hpdl
|
213
|
17
|
global $osC_Database, $osC_Services;
|
hpdl
|
210
|
18
|
|
|
19
|
$Qproduct = $osC_Database->query('select pd.products_name as name, pd.products_description as description, p.products_model as model, p.products_quantity as quantity, p.products_image as image, pd.products_url as url, p.products_price as price, p.products_tax_class_id as tax_class_id, p.products_date_added as date_added, p.products_date_available as date_available, p.manufacturers_id from :table_products p, :table_products_description pd where p.products_id = :products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id');
|
|
20
|
$Qproduct->bindTable(':table_products', TABLE_PRODUCTS);
|
|
21
|
$Qproduct->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
|
|
22
|
$Qproduct->bindInt(':products_id', tep_get_prid($id));
|
|
23
|
$Qproduct->bindInt(':language_id', $_SESSION['languages_id']);
|
|
24
|
$Qproduct->execute();
|
|
25
|
|
|
26
|
$this->_data = $Qproduct->toArray();
|
|
27
|
$this->_data['id'] = $id;
|
|
28
|
|
|
29
|
$Qcheck = $osC_Database->query('select products_attributes_id from :table_products_attributes patrib where products_id = :products_id limit 1');
|
|
30
|
$Qcheck->bindTable(':table_products_attributes', TABLE_PRODUCTS_ATTRIBUTES);
|
|
31
|
$Qcheck->bindInt(':products_id', tep_get_prid($id));
|
|
32
|
$Qcheck->execute();
|
|
33
|
|
|
34
|
if ($Qcheck->numberOfRows() === 1) {
|
|
35
|
$this->_data['attributes'] = array();
|
|
36
|
|
|
37
|
$Qattributes = $osC_Database->query('select pa.*, po.*, pov.* from :table_products_attributes pa, :table_products_options po, :table_products_options_values pov where pa.products_id = :products_id and pa.options_id = po.products_options_id and po.language_id = :language_id and pa.options_values_id = pov.products_options_values_id and pov.language_id = :language_id order by po.products_options_name, pov.products_options_values_name');
|
|
38
|
$Qattributes->bindTable(':table_products_attributes', TABLE_PRODUCTS_ATTRIBUTES);
|
|
39
|
$Qattributes->bindTable(':table_products_options', TABLE_PRODUCTS_OPTIONS);
|
|
40
|
$Qattributes->bindTable(':table_products_options_values', TABLE_PRODUCTS_OPTIONS_VALUES);
|
|
41
|
$Qattributes->bindInt(':products_id', tep_get_prid($id));
|
|
42
|
$Qattributes->bindInt(':language_id', $_SESSION['languages_id']);
|
|
43
|
$Qattributes->bindInt(':language_id', $_SESSION['languages_id']);
|
|
44
|
$Qattributes->execute();
|
|
45
|
|
|
46
|
while ($Qattributes->next()) {
|
|
47
|
$this->_data['attributes'][] = array('options_id' => $Qattributes->valueInt('options_id'),
|
|
48
|
'options_name' => $Qattributes->value('products_options_name'),
|
|
49
|
'options_values_id' => $Qattributes->valueInt('options_values_id'),
|
|
50
|
'options_values_name' => $Qattributes->value('products_options_values_name'),
|
|
51
|
'options_values_price' => $Qattributes->value('options_values_price'),
|
|
52
|
'price_prefix' => $Qattributes->value('price_prefix'));
|
|
53
|
}
|
|
54
|
}
|
hpdl
|
213
|
55
|
|
|
56
|
if ($osC_Services->isStarted('reviews')) {
|
|
57
|
$Qavg = $osC_Database->query('select avg(reviews_rating) as rating from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1');
|
|
58
|
$Qavg->bindTable(':table_reviews', TABLE_REVIEWS);
|
|
59
|
$Qavg->bindInt(':products_id', $id);
|
|
60
|
$Qavg->bindInt(':languages_id', $_SESSION['languages_id']);
|
|
61
|
$Qavg->execute();
|
|
62
|
|
|
63
|
$this->_data['reviews_average_rating'] = round($Qavg->value('rating'));
|
|
64
|
}
|
hpdl
|
210
|
65
|
}
|
|
66
|
|
hpdl
|
213
|
67
|
function getData($key) {
|
|
68
|
if (isset($this->_data[$key])) {
|
|
69
|
return $this->_data[$key];
|
|
70
|
}
|
|
71
|
|
|
72
|
return false;
|
|
73
|
}
|
|
74
|
|
hpdl
|
210
|
75
|
function getID() {
|
|
76
|
return $this->_data['id'];
|
|
77
|
}
|
|
78
|
|
|
79
|
function getTitle() {
|
|
80
|
return $this->_data['name'];
|
|
81
|
}
|
|
82
|
|
|
83
|
function getDescription() {
|
|
84
|
return $this->_data['description'];
|
|
85
|
}
|
|
86
|
|
|
87
|
function hasModel() {
|
|
88
|
return (isset($this->_data['model']) && !empty($this->_data['model']));
|
|
89
|
}
|
|
90
|
|
|
91
|
function getModel() {
|
|
92
|
return $this->_data['model'];
|
|
93
|
}
|
|
94
|
|
|
95
|
function getPrice() {
|
|
96
|
}
|
|
97
|
|
|
98
|
function getPriceFormated($with_special = false) {
|
|
99
|
global $osC_Services, $osC_Specials, $osC_Currencies;
|
|
100
|
|
|
101
|
if (($with_special === true) && $osC_Services->isStarted('specials') && ($new_price = $osC_Specials->getPrice($this->_data['id']))) {
|
|
102
|
$price = '<s>' . $osC_Currencies->displayPrice($this->_data['price'], $this->_data['tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $this->_data['tax_class_id']) . '</span>';
|
|
103
|
} else {
|
|
104
|
$price = $osC_Currencies->displayPrice($this->_data['price'], $this->_data['tax_class_id']);
|
|
105
|
}
|
|
106
|
|
|
107
|
return $price;
|
|
108
|
}
|
|
109
|
|
|
110
|
function hasImage() {
|
|
111
|
return (isset($this->_data['image']) && !empty($this->_data['image']));
|
|
112
|
}
|
|
113
|
|
|
114
|
function getImage() {
|
|
115
|
return $this->_data['image'];
|
|
116
|
}
|
|
117
|
|
|
118
|
function hasURL() {
|
|
119
|
return (isset($this->_data['url']) && !empty($this->_data['url']));
|
|
120
|
}
|
|
121
|
|
|
122
|
function getURL() {
|
|
123
|
return $this->_data['url'];
|
|
124
|
}
|
|
125
|
|
|
126
|
function getDateAvailable() {
|
|
127
|
return $this->_data['date_available'];
|
|
128
|
}
|
|
129
|
|
|
130
|
function getDateAdded() {
|
|
131
|
return $this->_data['date_added'];
|
|
132
|
}
|
|
133
|
|
|
134
|
function hasAttributes() {
|
|
135
|
return (isset($this->_data['attributes']) && !empty($this->_data['attributes']));
|
|
136
|
}
|
|
137
|
|
|
138
|
function &getAttributes() {
|
|
139
|
global $osC_Currencies;
|
|
140
|
|
|
141
|
$array = array();
|
|
142
|
|
|
143
|
foreach ($this->_data['attributes'] as $attribute) {
|
|
144
|
if (!isset($array[$attribute['options_id']])) {
|
|
145
|
$array[$attribute['options_id']] = array('options_name' => $attribute['options_name'],
|
|
146
|
'values' => array(),
|
|
147
|
'data' => array());
|
|
148
|
}
|
|
149
|
|
|
150
|
$array[$attribute['options_id']]['values'][] = array('options_values_id' => $attribute['options_values_id'],
|
|
151
|
'options_values_name' => $attribute['options_values_name'],
|
|
152
|
'options_values_price' => $attribute['options_values_price'],
|
|
153
|
'price_prefix' => $attribute['price_prefix']);
|
|
154
|
|
|
155
|
$array[$attribute['options_id']]['data'][] = array('id' => $attribute['options_values_id'],
|
|
156
|
'text' => $attribute['options_values_name'] . ($attribute['options_values_price'] != '0' ? ' (' . $attribute['price_prefix'] . $osC_Currencies->displayPrice($attribute['options_values_price'], $this->_data['tax_class_id']) . ')' : ''));
|
|
157
|
}
|
|
158
|
|
|
159
|
return $array;
|
|
160
|
}
|
|
161
|
|
|
162
|
function checkEntry($id) {
|
|
163
|
global $osC_Database;
|
|
164
|
|
|
165
|
$Qcheck = $osC_Database->query('select products_id from :table_products where products_id = :products_id and products_status = 1 limit 1');
|
|
166
|
$Qcheck->bindTable(':table_products', TABLE_PRODUCTS);
|
|
167
|
$Qcheck->bindInt(':products_id', tep_get_prid($id));
|
|
168
|
$Qcheck->execute();
|
|
169
|
|
|
170
|
if ($Qcheck->numberOfRows() === 1) {
|
|
171
|
return true;
|
|
172
|
}
|
|
173
|
|
|
174
|
return false;
|
|
175
|
}
|
|
176
|
|
|
177
|
function incrementCounter() {
|
|
178
|
global $osC_Database;
|
|
179
|
|
|
180
|
$Qupdate = $osC_Database->query('update :table_products_description set products_viewed = products_viewed+1 where products_id = :products_id and language_id = :language_id');
|
|
181
|
$Qupdate->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
|
|
182
|
$Qupdate->bindInt(':products_id', tep_get_prid($this->_data['id']));
|
|
183
|
$Qupdate->bindInt(':language_id', $_SESSION['languages_id']);
|
|
184
|
$Qupdate->execute();
|
|
185
|
}
|
hpdl
|
211
|
186
|
|
|
187
|
function &getListingNew() {
|
|
188
|
global $osC_Database;
|
|
189
|
|
|
190
|
$Qproducts = $osC_Database->query('select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from :table_products p left join :table_manufacturers m on (p.manufacturers_id = m.manufacturers_id), :table_products_description pd where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by p.products_date_added desc, pd.products_name');
|
|
191
|
$Qproducts->bindTable(':table_products', TABLE_PRODUCTS);
|
|
192
|
$Qproducts->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
|
|
193
|
$Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
|
|
194
|
$Qproducts->bindInt(':language_id', $_SESSION['languages_id']);
|
|
195
|
$Qproducts->setBatchLimit($_GET['page'], MAX_DISPLAY_PRODUCTS_NEW);
|
|
196
|
$Qproducts->execute();
|
|
197
|
|
|
198
|
return $Qproducts;
|
|
199
|
}
|
hpdl
|
210
|
200
|
}
|
|
201
|
?>
|
