ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / sparklp6 / public_html / sparklerfilters-org / administrator / components / com_j2store / models

<?php
/**
 * @package J2Store
* @copyright Copyright (c)2014-17 Ramesh Elamathi / J2Store.org
* @license GNU GPL v3 or later
*/

// No direct access
defined('_JEXEC') or die;
require_once JPATH_ADMINISTRATOR.'/components/com_j2store/models/behavior/autoload.php';
class J2StoreModelInventories extends F0FModel {
	protected $_productlist = array();
	protected $inventory_pagination = null;
	protected $inventory_pagetotal = null;
	public function getStockProductList($overrideLimits = false, $group = '')
	{
		if (empty($this->_productlist))
		{
			$query = $this->getStockProductListQuery($overrideLimits);

if (!$overrideLimits)
			{
				$limitstart = $this->getState('limitstart');
				$limit = $this->getState('limit');
				$this->_productlist = $this->_getList((string) $query, $limitstart, $limit, $group);
			}
			else
			{
				$this->_productlist = $this->_getList((string) $query, 0, 0, $group);
			}

}
		return $this->_productlist;
	}

public function getStockProductListQuery($overrideLimits = false) {

$db = JFactory::getDbo();
		$query = $db->getQuery(true)->select('#__j2store_productquantities.*')->from('#__j2store_productquantities');
		$this->_buildQueryJoins($query);
		$this->_buildWhereQuery($query);
		$this->_buildQueryOrderBy($query);
		$query->group('#__j2store_products.j2store_product_id');
		//$query->group('#__j2store_productquantities.variant_id');
        $model = $this;
		J2Store::plugin()->event('AfterStockProductListQuery', array(&$query, &$model));
		return $query;

}

public function _buildQueryJoins($query){
		$query->select('#__j2store_variants.manage_stock');
		$query->select('#__j2store_variants.availability');
		$query->select('#__j2store_products.j2store_product_id');
		$query->select('#__j2store_products.product_type');
		$query->join('LEFT','#__j2store_variants ON #__j2store_variants.j2store_variant_id = #__j2store_productquantities.variant_id');
		$query->join('INNER','#__j2store_products ON #__j2store_products.j2store_product_id = #__j2store_variants.product_id');
	}

public function _buildWhereQuery(&$query){
        $db = JFactory::getDbo();
		$inventry = $this->getState ('inventry_stock','');
		if($inventry == 'in_stock'){
			$query->where('#__j2store_variants.availability = 1');
		}
		if($inventry == 'out_of_stock'){
			$query->where('#__j2store_variants.availability = 0');
		}

$search = $this->getState('search','');
		if($search){
            $query->where('#__j2store_variants.sku LIKE '.$db->q('%'.$search.'%'));
        }
	}

public function _buildQueryOrderBy($query){
		$db =$this->_db;
		$this->_buildSortQuery($query);
		if(!empty($this->state->filter_order)) {
			$query->order('#__j2store_productquantities.'.$this->state->filter_order.' '.$this->state->filter_order_Dir);
		}else{
			$query->order('#__j2store_productquantities.j2store_productquantity_id DESC');
		}
	}

public function getInventoryPagination()
	{
		if (empty($this->inventory_pagination))
		{
			// Import the pagination library
			JLoader::import('joomla.html.pagination');

// Prepare pagination values
			$total = $this->getInventoryPageTotal();
			$limitstart = $this->getState('limitstart');
			$limit = $this->getState('limit');
			// Create the pagination object
			$this->inventory_pagination = new JPagination($total, $limitstart, $limit);
		}

return $this->inventory_pagination;
	}

/**
	 * Get the number of all items
	 *
	 * @return  integer
	 */
	public function getInventoryPageTotal()
	{
		if (is_null($this->productpagetotal))
		{
			$query = $this->buildCountQuery();

if ($query === false)
			{
				$subquery = $this->getStockProductListQuery(false);
				$subquery->clear('order');
				$query = $this->_db->getQuery(true)
				->select('COUNT(*)')
				->from("(" . (string) $subquery . ") AS a");
			}

$this->_db->setQuery((string) $query);

$this->productpagetotal = $this->_db->loadResult();
		}

return $this->productpagetotal;
	}
}

[-] shippings.php [edit]
[-] coupons.php [edit]
[-] productoptions.php [edit]
[-] inventories.php [edit]
[-] configurations.php [edit]
[-] orders.php [edit]
[+] fields
[-] productprices.php [edit]
[-] index.html [edit]
[-] customers.php [edit]
[-] apps.php [edit]
[-] productoptionvalues.php [edit]
[-] myprofiles.php [edit]
[-] queues.php [edit]
[-] emailtemplates.php [edit]
[-] eupdates.php [edit]
[+] behavior
[-] reports.php [edit]
[-] invoicetemplates.php [edit]
[-] addresses.php [edit]
[-] taxprofiles.php [edit]
[-] orderhistories.php [edit]
[-] manufacturers.php [edit]
[-] carts.php [edit]
[-] orderitems.php [edit]
[-] storeprofiles.php [edit]
[-] products.php [edit]
[-] geozones.php [edit]
[-] currencies.php [edit]
[-] cartitems.php [edit]
[-] filtergroups.php [edit]
[-] orderdownloads.php [edit]
[-] options.php [edit]
[-] appstores.php [edit]
[-] customfields.php [edit]
[-] vouchers.php [edit]
[-] vendors.php [edit]
[-] shippingtroubles.php [edit]
[-] updates.php [edit]
[-] variants.php [edit]
[+] ..
[-] promotions.php [edit]
[-] cartadmins.php [edit]
[-] producttags.php [edit]
[-] payments.php [edit]