hpdl
|
1
|
1
|
<?php
|
|
2
|
/*
|
hpdl
|
121
|
3
|
$Id: reviews.php 1763 2007-12-27 21:27:48Z frank $
|
hpdl
|
1
|
4
|
|
|
5
|
osCommerce, Open Source E-Commerce Solutions
|
|
6
|
http://www.oscommerce.com
|
|
7
|
|
hpdl
|
1371
|
8
|
Copyright (c) 2007 osCommerce
|
hpdl
|
1
|
9
|
|
hpdl
|
1498
|
10
|
This program is free software; you can redistribute it and/or modify
|
|
11
|
it under the terms of the GNU General Public License v2 (1991)
|
|
12
|
as published by the Free Software Foundation.
|
hpdl
|
1
|
13
|
*/
|
|
14
|
|
hpdl
|
1371
|
15
|
if ( !class_exists('osC_Summary') ) {
|
hpdl
|
1
|
16
|
include('includes/classes/summary.php');
|
|
17
|
}
|
|
18
|
|
|
19
|
class osC_Summary_reviews extends osC_Summary {
|
|
20
|
|
|
21
|
/* Class constructor */
|
|
22
|
|
|
23
|
function osC_Summary_reviews() {
|
hpdl
|
1492
|
24
|
global $osC_Language;
|
|
25
|
|
|
26
|
$osC_Language->loadIniFile('modules/summary/reviews.php');
|
|
27
|
|
|
28
|
$this->_title = $osC_Language->get('summary_reviews_title');
|
hpdl
|
1076
|
29
|
$this->_title_link = osc_href_link_admin(FILENAME_DEFAULT, 'reviews');
|
hpdl
|
1
|
30
|
|
hpdl
|
1371
|
31
|
if ( osC_Access::hasAccess('reviews') ) {
|
hpdl
|
1078
|
32
|
$this->_setData();
|
|
33
|
}
|
hpdl
|
1
|
34
|
}
|
|
35
|
|
|
36
|
/* Private methods */
|
|
37
|
|
|
38
|
function _setData() {
|
hpdl
|
1434
|
39
|
global $osC_Database, $osC_Language;
|
hpdl
|
1
|
40
|
|
|
41
|
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
|
|
42
|
' <thead>' .
|
|
43
|
' <tr>' .
|
hpdl
|
1492
|
44
|
' <th>' . $osC_Language->get('summary_reviews_table_heading_products') . '</th>' .
|
|
45
|
' <th>' . $osC_Language->get('summary_reviews_table_heading_language') . '</th>' .
|
|
46
|
' <th>' . $osC_Language->get('summary_reviews_table_heading_rating') . '</th>' .
|
|
47
|
' <th>' . $osC_Language->get('summary_reviews_table_heading_date') . '</th>' .
|
hpdl
|
1
|
48
|
' </tr>' .
|
|
49
|
' </thead>' .
|
|
50
|
' <tbody>';
|
|
51
|
|
hpdl
|
1076
|
52
|
$Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, greatest(r.date_added, ifnull(r.last_modified, 0)) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.code as languages_code from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by date_last_modified desc limit 6');
|
hpdl
|
1
|
53
|
$Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
|
|
54
|
$Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
|
|
55
|
$Qreviews->bindTable(':table_languages', TABLE_LANGUAGES);
|
|
56
|
$Qreviews->execute();
|
|
57
|
|
hpdl
|
1371
|
58
|
while ( $Qreviews->next() ) {
|
hpdl
|
365
|
59
|
$this->_data .= ' <tr onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">' .
|
hpdl
|
1492
|
60
|
' <td>' . osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, 'reviews&rID=' . $Qreviews->valueInt('reviews_id') . '&action=save'), osc_icon('reviews.png') . ' ' . $Qreviews->value('products_name')) . '</td>' .
|
hpdl
|
1434
|
61
|
' <td align="center">' . $osC_Language->showImage($Qreviews->value('languages_code')) . '</td>' .
|
hpdl
|
1493
|
62
|
' <td align="center">' . osc_image('../images/stars_' . $Qreviews->valueInt('reviews_rating') . '.png', $Qreviews->valueInt('reviews_rating') . '/5') . '</td>' .
|
frank
|
1763
|
63
|
' <td>' . osC_DateTime::getShort($Qreviews->value('date_last_modified')) . '</td>' .
|
hpdl
|
1
|
64
|
' </tr>';
|
|
65
|
}
|
|
66
|
|
|
67
|
$this->_data .= ' </tbody>' .
|
|
68
|
'</table>';
|
hpdl
|
1371
|
69
|
|
|
70
|
$Qreviews->freeResult();
|
hpdl
|
1
|
71
|
}
|
|
72
|
}
|
|
73
|
?>
|
