/**
* Method to display input to upload images
* @param int $product_id
* @return html
*/
public function onJ2StoreProductFormInput($product_id)
{
$vars = new JObject();
//check product id exist
if (isset($product_id)) {
//get the article item
$article = J2StoreItem::getArticle($product_id);
//get the j2store price for the above item
$price = J2StoreItem::_getJ2Item($product_id);
//assign the product id into vars
$vars->product_id = $product_id;
if (isset($price->additional_image)) {
$vars->additional_image = json_decode($price->additional_image);
}
$vars->asset_id = $article->asset_id;
}
//check asset id exist else get from app
if (!isset($vars->asset_id)) {
$vars->asset_id = JFactory::getApplication()->input->get('option');
}
//check already main image exist
$vars->main_image = isset($price->main_image) ? $price->main_image : "";
$vars->listview_thumb = isset($price->listview_thumb) ? $price->listview_thumb : "";
$vars->no_of_additional_image = $this->params->get('no_of_additional_img', 5);
//load the layot and return the result
$result = $this->_getLayout('default', $vars);
return $result;
}
function setfiles()
{
$app = JFactory::getApplication();
$model = $this->getModel('Productfiles');
//$context = 'com_j2store.productfiles';
/* $filter_order = $app->getUserStateFromRequest( $context.'filter_order', 'filter_order', 'a.ordering', 'cmd' );
$filter_order_Dir = $app->getUserStateFromRequest( $context.'filter_order_Dir', 'filter_order_Dir', '', 'word' );
*/
// table ordering
/* $lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
*/
$total = $model->getTotal();
$pagination = $model->getPagination();
//$id = JRequest::getVar('id', 0, 'get', 'int');
$id = JRequest::getVar('id');
//set states
$model->setState('product.id', $id);
// get items from the table
$items = $model->getItems();
$row = J2StoreItem::getArticle($id);
$files = $model->getFiles();
$error = $model->getError();
$view = $this->getView('productfiles', 'html');
$view->set('_controller', 'products');
$view->set('_view', 'products');
$view->set('_action', "index.php?option=com_j2store&view=products&task=setfiles&tmpl=component&id=" . $id);
$view->setModel($model, true);
$view->assign('state', $model->getState());
$view->assign('row', $row);
$view->assign('items', $items);
$view->assign('files', $files);
$view->assign('lists', $lists);
// for pagination (footer)
$view->assign('error', $error);
$view->assign('total', $total);
$view->assign('pagination', $pagination);
$view->assign('product_id', $id);
//$view->assign( 'product_id', $id );
$view->setLayout('default');
$view->display();
}
/**
* getItemName() - Get the name of an item.
*
* @param string $order_code The order code of the item.
*/
public static function getItemName($order_code)
{
require_once JPATH_ADMINISTRATOR . '/components/com_j2store/libraries/j2item.php';
$article_tbl = J2StoreItem::getArticle($order_code);
return $article_tbl->title;
}
echo JText::_("J2STORE_CART_ITEM_REMOVE");
?>
</th>
</tr>
</thead>
<tbody>
<?php
$i = 0;
$k = 0;
$subtotal = 0;
?>
<?php
foreach ($items as $item) {
?>
<?php
$article = J2StoreItem::getArticle($item->product_id);
$link = ContentHelperRoute::getArticleRoute($article->id, $article->catid, $article->language);
$link = JRoute::_($link);
$image = J2StoreItem::getJ2Image($item->product_id, $this->params);
?>
<tr class="row<?php
echo $k;
?>
">
<td>
<?php
if ($this->params->get('show_thumb_cart')) {
?>
<span class="j2store-cart-item-image">
<?php
function setquantities()
{
$app = JFactory::getApplication();
$product_id = $app->input->getInt('product_id');
$model = $this->getModel('productquantities');
$model->setState('filter_productid', $product_id);
$items = $model->getAll();
$row = J2StoreItem::getArticle($product_id);
J2StoreItem::doProductQuantitiesReconciliation($row->id);
$ns = 'com_j2store.productquantities.setquantities';
$filter_order = $app->getUserStateFromRequest($ns . 'filter_order', 'filter_order', 'tbl.productquantity_id', 'cmd');
$filter_order_Dir = $app->getUserStateFromRequest($ns . 'filter_order_Dir', 'filter_order_Dir', '', 'word');
// table ordering
$model->setState('direction', $filter_order_Dir);
$model->setState('order', $filter_order);
$view = $this->getView('productquantities', 'html');
$view->set('_controller', 'products');
$view->set('_view', 'productquantities');
$view->set('_action', "index.php?option=com_j2store&view=products&task=setquantities&product_id={$row->id}&tmpl=component");
$view->setModel($model, true);
$view->assign('state', $model->getState());
$view->assign('row', $row);
$view->assign('items', $model->getList());
$view->setLayout('setquantities');
$view->display();
}
public static function getItemInfo($id)
{
static $itemsets;
if (!is_array($itemsets)) {
$itemsets = array();
}
if (!isset($itemsets[$id])) {
$row = J2StoreItem::getArticle($id);
//create an object and return
$item = J2StorePrices::getJ2Product($id);
$item->product_id = $id;
$item->product_name = $row->title;
$item->short_description = $row->introtext;
$item->long_description = $row->fulltext;
$item->metakey = $row->metakey;
$item->metadesc = $row->metadesc;
$item->metadata = $row->metadata;
$item->price = $item->item_price;
$item->product_sku = $item->item_sku;
$item->tax_profile_id = $item->item_tax;
$store_config = J2StoreHelperCart::getStoreAddress();
if ($item->use_store_config_min_out_qty > 0) {
$item->min_out_qty = (double) $store_config->store_min_out_qty;
}
if ($item->use_store_config_min_sale_qty > 0) {
$item->min_sale_qty = (double) $store_config->store_min_sale_qty;
}
if ($item->use_store_config_max_sale_qty > 0) {
$item->max_sale_qty = (double) $store_config->store_max_sale_qty;
}
if ($item->use_store_config_notify_qty > 0) {
$item->notify_qty = (double) $store_config->store_notify_qty;
}
$item->product = $row;
//$item = $j2item;
$itemsets[$id] = $item;
}
return $itemsets[$id];
}
public static function getAvailableQuantity($id, $attribute)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$tableQuantity = JTable::getInstance('ProductQuantities', 'Table');
$tableProduct = JTable::getInstance('Prices', 'Table');
$J2Item = J2StoreItem::getArticle($id);
$tableProduct->load(array('article_id' => $id));
if (!isset($tableProduct->manage_stock) || $tableProduct->manage_stock == 0) {
$tableProduct->quantity = '9999';
return $tableProduct;
}
$select[] = "quantities.quantity";
$select[] = "price.manage_stock";
$query->select($select);
$query->from($tableProduct->getTableName() . " AS price");
$leftJoinCondition = $tableQuantity->getTableName() . " as quantities ON price.article_id = quantities.product_id ";
$query->leftJoin($leftJoinCondition);
$whereClause[] = "quantities.product_id = " . (int) $id;
$whereClause[] = "quantities.product_attributes='" . $attribute . "'";
$whereClause[] = "price.manage_stock =1 ";
$query->where($whereClause, "AND");
$db = JFactory::getDBO();
$db->setQuery((string) $query);
$item = $db->loadObject();
if (empty($item)) {
$return = new JObject();
$return->product_id = $id;
$return->product_name = $J2Item->title;
$return->quantity = 0;
$return->manage_stock = $tableProduct->manage_stock;
return $return;
}
return $item;
}
