FishEye: file osCommerce/branches/hpdl/oscommerce/includes/classes/reviews.php

Annotated File View

hpdl	1	1	<?php
hpdl	1	2	/*
mattice	151	3	$Id: reviews.php 1498 2007-03-29 14:04:50Z hpdl $
hpdl	1	4
		5	osCommerce, Open Source E-Commerce Solutions
		6	http://www.oscommerce.com
		7
hpdl	608	8	Copyright (c) 2006 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
		15	class osC_Reviews {
		16	var $is_enabled = false,
		17	$is_moderated = false;
hpdl	368	18
hpdl	1	19	// class constructor
hpdl	1	20	function osC_Reviews() {
hpdl	368	21
hpdl	1	22	$this->enableReviews();
		23	$this->enableModeration();
		24	}
		25
		26	function enableReviews() {
		27	global $osC_Database, $osC_Customer;
		28
		29	switch (SERVICE_REVIEW_ENABLE_REVIEWS) {
		30	case 0:
		31	$this->is_enabled = true;
		32	break;
		33	case 1:
hpdl	368	34	if ($osC_Customer->isLoggedOn()) {
hpdl	1	35	$this->is_enabled = true;
		36	} else {
		37	$this->is_enabled = false;
		38	}
		39	break;
		40	case 2:
		41	if ($this->hasPurchased() == true) {
		42	$this->is_enabled = true;
		43	} else {
		44	$this->is_enabled = false;
		45	}
		46	break;
		47	default:
		48	$this->is_enabled = false;
		49	break;
		50	}
		51	}
hpdl	368	52
hpdl	1	53	function hasPurchased() {
hpdl	1	54	global $osC_Database, $osC_Customer;
hpdl	368	55
hpdl	1	56	$Qhaspurchased = $osC_Database->query('select count(*) as total from :table_orders o, :table_orders_products op, :table_products p where o.customers_id = :customers_id and o.orders_id = op.orders_id and op.products_id = p.products_id and op.products_id = :products_id');
		57	$Qhaspurchased->bindRaw(':table_orders', TABLE_ORDERS);
		58	$Qhaspurchased->bindRaw(':table_orders_products', TABLE_ORDERS_PRODUCTS);
		59	$Qhaspurchased->bindRaw(':table_products', TABLE_PRODUCTS);
hpdl	368	60	$Qhaspurchased->bindInt(':customers_id', $osC_Customer->getID());
hpdl	1	61	$Qhaspurchased->bindInt(':products_id', $_GET['products_id']);
		62	$Qhaspurchased->execute();
		63
		64	if ($Qhaspurchased->valueInt('total') >= '1') {
		65	return true;
		66	} else {
		67	return false;
		68	}
		69	}
hpdl	368	70
hpdl	1	71	function enableModeration() {
		72	global $osC_Database, $osC_Customer;
		73
		74	switch (SERVICE_REVIEW_ENABLE_MODERATION) {
		75	case -1:
		76	$this->is_moderated = false;
		77	break;
		78	case 0:
hpdl	368	79	if ($osC_Customer->isLoggedOn()) {
hpdl	1	80	$this->is_moderated = false;
		81	} else {
		82	$this->is_moderated = true;
		83	}
		84	break;
		85	case 1:
		86	$this->is_moderated = true;
		87	break;
		88	default:
		89	$this->is_moderated = true;
		90	break;
		91	}
		92	}
hpdl	368	93
hpdl	368	94	function getTotal($id) {
hpdl	383	95	global $osC_Database, $osC_Language;
hpdl	368	96
		97	$Qcheck = $osC_Database->query('select count(*) as total from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 limit 1');
		98	$Qcheck->bindTable(':table_reviews', TABLE_REVIEWS);
		99	$Qcheck->bindInt(':products_id', $id);
hpdl	383	100	$Qcheck->bindInt(':languages_id', $osC_Language->getID());
hpdl	368	101	$Qcheck->execute();
		102
		103	return $Qcheck->valueInt('total');
		104	}
		105
		106	function exists($id = null, $groupped = false) {
hpdl	383	107	global $osC_Database, $osC_Language;
hpdl	368	108
		109	$Qcheck = $osC_Database->query('select reviews_id from :table_reviews where');
		110
		111	if (is_numeric($id)) {
		112	if ($groupped === false) {
		113	$Qcheck->appendQuery('reviews_id = :reviews_id and');
		114	$Qcheck->bindInt(':reviews_id', $id);
		115	} else {
		116	$Qcheck->appendQuery('products_id = :products_id and');
		117	$Qcheck->bindInt(':products_id', $id);
		118	}
		119	}
		120
		121	$Qcheck->appendQuery('languages_id = :languages_id and reviews_status = 1 limit 1');
		122	$Qcheck->bindTable(':table_reviews', TABLE_REVIEWS);
hpdl	383	123	$Qcheck->bindInt(':languages_id', $osC_Language->getID());
hpdl	368	124	$Qcheck->execute();
		125
		126	if ($Qcheck->numberOfRows() === 1) {
		127	return true;
		128	}
		129
		130	return false;
		131	}
		132
		133	function getProductID($id) {
		134	global $osC_Database;
		135
		136	$Qreview = $osC_Database->query('select products_id from :table_reviews where reviews_id = :reviews_id');
		137	$Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
		138	$Qreview->bindInt(':reviews_id', $id);
		139	$Qreview->execute();
		140
		141	return $Qreview->valueInt('products_id');
		142	}
		143
		144	function &getListing($id = null) {
hpdl	608	145	global $osC_Database, $osC_Language, $osC_Image;
hpdl	368	146
		147	if (is_numeric($id)) {
		148	$Qreviews = $osC_Database->query('select reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 order by reviews_id desc');
		149	$Qreviews->bindInt(':products_id', $id);
hpdl	383	150	$Qreviews->bindInt(':languages_id', $osC_Language->getID());
hpdl	368	151	} else {
hpdl	608	152	$Qreviews = $osC_Database->query('select r.reviews_id, left(r.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name, p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, i.image from :table_reviews r, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd where r.reviews_status = 1 and r.languages_id = :languages_id and r.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by r.reviews_id desc');
hpdl	368	153	$Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
hpdl	608	154	$Qreviews->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
hpdl	368	155	$Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
hpdl	608	156	$Qreviews->bindInt(':default_flag', 1);
hpdl	383	157	$Qreviews->bindInt(':languages_id', $osC_Language->getID());
hpdl	383	158	$Qreviews->bindInt(':language_id', $osC_Language->getID());
hpdl	368	159	}
		160	$Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
		161	$Qreviews->setBatchLimit((isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), MAX_DISPLAY_NEW_REVIEWS);
		162	$Qreviews->execute();
		163
		164	return $Qreviews;
		165	}
		166
		167	function &getEntry($id) {
hpdl	383	168	global $osC_Database, $osC_Language;
hpdl	368	169
		170	$Qreviews = $osC_Database->query('select reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where reviews_id = :reviews_id and languages_id = :languages_id and reviews_status = 1');
		171	$Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
		172	$Qreviews->bindInt(':reviews_id', $id);
hpdl	383	173	$Qreviews->bindInt(':languages_id', $osC_Language->getID());
hpdl	368	174	$Qreviews->execute();
		175
		176	return $Qreviews;
		177	}
		178
		179	function saveEntry($data) {
hpdl	383	180	global $osC_Database, $osC_Language;
hpdl	368	181
		182	$Qreview = $osC_Database->query('insert into :table_reviews (products_id, customers_id, customers_name, reviews_rating, languages_id, reviews_text, reviews_status, date_added) values (:products_id, :customers_id, :customers_name, :reviews_rating, :languages_id, :reviews_text, :reviews_status, now())');
		183	$Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
		184	$Qreview->bindInt(':products_id', $data['products_id']);
		185	$Qreview->bindInt(':customers_id', $data['customer_id']);
		186	$Qreview->bindValue(':customers_name', $data['customer_name']);
		187	$Qreview->bindValue(':reviews_rating', $data['rating']);
hpdl	383	188	$Qreview->bindInt(':languages_id', $osC_Language->getID());
hpdl	368	189	$Qreview->bindValue(':reviews_text', $data['review']);
		190	$Qreview->bindInt(':reviews_status', $data['status']);
		191	$Qreview->execute();
		192	}
		193	}
		194	?>

FishEye

View

Diff

Annotations

Annotated File View