StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7762028
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-10-14T00:49:45.590
FavoriteCount
0
LastActivityDate
2011-10-14T15:42:28.727
LastEditDate
2011-10-14T15:42:28.727
LastEditorUserId
961455
OwnerUserId
961455
ParentId
7759607
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
Excellent question. As you noted, the data you wish to display is already part of the admin/backend of OpenCart, but it is not available on the frontend. I'll show you how to add it. Due to the <a href="http://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller" rel="nofollow">MVC</a> architecture of OpenCart, you'll have to make changes in 3 places. The Model, the View and the Controller. First things first, you will have to get the data from the database. Because we're looking to make changes to the frontend, everything will be contained in the catalog directory. If you look at the code, you'll find catalog/model/catalog/product.php. This is where we're going to make our first change. Special price is available in the ModelCatalogProduct, but the special price end date is not. You can either modify the existing getProduct() method, or you can create your own method. I am going to show you the latter, while the former is left as an exercise for the user. catalog/model/catalog/product.php <pre><code>class ModelCatalogProduct extends Model { ... // Return an array containing special (price, date_start, date_end). // or false if no special price exists. public function getSpecialPriceDates($product_id) { if ($this->customer->isLogged()) { $customer_group_id = $this->customer->getCustomerGroupId(); } else { $customer_group_id = $this->config->get('config_customer_group_id'); } $query = $this->db->query("SELECT price, date_start, date_end FROM " . DB_PREFIX . "product_special WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$customer_group_id . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1"); if ($query->num_rows) { return array( 'special' => $query->row['price'], 'date_start' => $query->row['date_start'], 'date_end' => $query->row['date_end'], ); } else { return false; } } ... } </code></pre> Great, now there is a function getSpecialPriceDates() you can call to find out when a product special will end. Let's make this data available to the View. In order to to that, we're going to have to add it to the Controller. Look in the ControllerProductProduct for where the 'special' variable is set. catalog/controller/product/product.php <pre><code>... if ((float)$product_info['special']) { $this->data['special'] = $this->currency->format($this->tax->calculate($product_info['special'], $product_info['tax_class_id'], $this->config->get('config_tax'))); // +++ NEW CODE $special_info = $this->model_catalog_product->getSpecialPriceDates($product_id); if ($special_info) { $this->data['special_date_end'] = $special_info['date_end']; } else { $this->date['special_date_end'] = false; } // +++ END NEW CODE } else { $this->data['special'] = false; } ... </code></pre> The last task is to implement your timer in the product view. This will be located somewhere like catalog/view/theme/default/template/product/product.tpl (if you have your own theme, replace default with {your-theme}). There are a lot of different countdown timer solutions for jQuery, pick your <a href="http://plugins.jquery.com/project/countdown2" rel="nofollow" title="jQuery Countdown">favorite</a>. catalog/view/theme/default/template/product/product.tpl <pre><code> <?php if (!$special) { ?> <?php echo $price; ?> <?php } else { ?> <?php echo $price; ?> <?php echo $special; ?> <?php if ($special_date_end): ?>  <div class="timer"></div> <?php endif; ?> <?php } ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POtrying to add jquery countdown timer for special price in opencart
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USnachito
UserOwnerUserId
1. USnachito
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POtrying to add jquery countdown timer for special price in opencart
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COthanks one small thing, mysql did't support ORDER_BY so i use ORDER BY. once again thanks
 singulars
 PostPostId
 PO
 UserUserId
 USair
2. COOops, typo. Fixed.
 singulars
 PostPostId
 PO
 UserUserId
 USnachito

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.