/**
* Sample use of the products model for getting products with certain properties
* See admin/models/products.php for all the filters currently built into the model
*
* @param $parameters
* @return unknown_type
*/
function getProducts()
{
// Check the registry to see if our Citruscart class has been overridden
if (!class_exists('Citruscart')) {
JLoader::register("Citruscart", JPATH_ADMINISTRATOR . "/components/com_citruscart/defines.php");
}
// load the config class
Citruscart::load('Citruscart', 'defines');
Citruscart::load('CitruscartHelperProduct', 'helpers.product');
JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/tables');
JModelLegacy::addIncludePath(JPATH_SITE . '/components/com_citruscart/models');
// get the model
$model = JModelLegacy::getInstance('Products', 'CitruscartModel');
// setting the model's state tells it what items to return
$model->setState('filter_published', '1');
$date = JFactory::getDate();
$model->setState('filter_published_date', $date->toSql());
$model->setState('filter_enabled', '1');
// Set category state
if ($this->params->get('category', '1') != '1') {
$model->setState('filter_category', $this->params->get('category', '1'));
}
// Set manufacturer state
if ($this->params->get('manufacturer', '') != '') {
$model->setState('filter_manufacturer', $this->params->get('manufacturer', ''));
}
// Set id set state
if ($this->params->get('id_set', '') != '') {
$params_id_set = $this->params->get('id_set');
$id_array = explode(',', $params_id_set);
$id_set = "'" . implode("', '", $id_array) . "'";
$model->setState('filter_id_set', $id_set);
}
// set the states based on the parameters
$model->setState('limit', $this->params->get('max_number', '10'));
if ($this->params->get('price_from', '-1') != '-1') {
$model->setState('filter_price_from', $this->params->get('price_from', '-1'));
}
if ($this->params->get('price_to', '-1') != '-1') {
$model->setState('filter_price_to', $this->params->get('price_to', '-1'));
}
$order = $this->params->get('order');
$direction = $this->params->get('direction', 'ASC');
switch ($order) {
case "2":
case "name":
$model->setState('order', 'tbl.product_name');
break;
case "1":
case "created":
$model->setState('order', 'tbl.created_date');
break;
case "0":
case "ordering":
default:
$model->setState('order', 'tbl.ordering');
break;
}
if ($this->params->get('random', '0') == '1') {
$model->setState('order', 'RAND()');
}
$model->setState('direction', $direction);
$config = Citruscart::getInstance();
$show_tax = $config->get('display_prices_with_tax');
$default_user_group = Citruscart::getInstance()->get('default_user_group');
$user_groups_array = $this->getUserGroups();
$overide_price = false;
if (count($user_groups_array) > 1 && $user_groups_array[0] != $default_user_group) {
$overide_price = true;
}
// using the set filters, get a list of products
if ($products = $model->getList(true, false)) {
if ($show_tax) {
Citruscart::load('CitruscartHelperUser', 'helpers.user');
$geozones = CitruscartHelperUser::getGeoZones(JFactory::getUser()->id);
if (empty($geozones)) {
// use the default
$table = JTable::getInstance('Geozones', 'CitruscartTable');
$table->load(array('geozone_id' => Citruscart::getInstance()->get('default_tax_geozone')));
$geozones = array($table);
}
}
foreach ($products as $product) {
if ($overide_price) {
$filter_group = CitruscartHelperUser::getUserGroup(JFactory::getUser()->id, $product->product_id);
$price = CitruscartHelperProduct::getPrice($product->product_id, '1', $filter_group);
$product->price = $price->product_price;
}
$product->taxtotal = 0;
$product->tax = 0;
if ($show_tax) {
$taxtotal = CitruscartHelperProduct::getTaxTotal($product->product_id, $geozones);
$product->taxtotal = $taxtotal;
$product->tax = $taxtotal->tax_total;
}
$product->filter_category = '';
$categories = CitruscartHelperProduct::getCategories($product->product_id);
if (!empty($categories)) {
$product->link .= "&filter_category=" . $categories[0];
$product->filter_category = $categories[0];
}
$itemid = Citruscart::getClass("CitruscartHelperRoute", 'helpers.route')->category($product->filter_category, true);
if (empty($itemid)) {
$product->itemid = $this->params->get('itemid');
} else {
$product->itemid = $itemid;
}
}
}
return $products;
}
/**
* Sample use of the products model for getting products with certain properties
* See admin/models/products.php for all the filters currently built into the model
*
* @param $parameters
* @return unknown_type
*/
function getProducts()
{
// Check the registry to see if our Citruscart class has been overridden
if (!class_exists('Citruscart')) {
JLoader::register("Citruscart", JPATH_ADMINISTRATOR . "/components/com_citruscart/defines.php");
}
// load the config class
Citruscart::load('Citruscart', 'defines');
Citruscart::load('CitruscartHelperProduct', 'helpers.product');
Citruscart::load('CitruscartHelperUser', 'helpers.user');
$helper = new CitruscartHelperProduct();
JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/tables');
JModelLegacy::addIncludePath(JPATH_SITE . '/components/com_citruscart/models');
// get the model
$model = JModelLegacy::getInstance('OrderItems', 'CitruscartModel');
$model->setState('limit', $this->params->get('max_number', '5'));
$query = $model->getQuery();
// group results by product ID
$query->group('tbl.product_id');
// select the total number of sales for each product
$field = array();
$field[] = " SUM(tbl.orderitem_quantity) AS total_sales ";
$field[] = " p.product_description_short AS product_description_short ";
$query->select($field);
// order results by the total sales
$query->order('total_sales DESC');
$model->setQuery($query);
$show_tax = Citruscart::getInstance()->get('display_prices_with_tax');
// using the set filters, get a list of products
if ($products = $model->getList(false, false)) {
if ($show_tax) {
$geozones = CitruscartHelperUser::getGeoZones(JFactory::getUser()->id);
if (empty($geozones)) {
// use the default
$table = JTable::getInstance('Geozones', 'CitruscartTable');
$table->load(array('geozone_id' => Citruscart::getInstance()->get('default_tax_geozone')));
$geozones = array($table);
}
}
foreach ($products as $product) {
$product->link = 'index.php?option=com_citruscart&view=products&task=view&id=' . $product->product_id;
$filter_group = CitruscartHelperUser::getUserGroup(JFactory::getUser()->id, $product->product_id);
$price = $helper->getPrice($product->product_id, '1', $filter_group);
$product->price = isset($price->product_price) ? $price->product_price : 0;
//product total
$product->taxtotal = 0;
$product->tax = 0;
if ($show_tax) {
$taxtotal = CitruscartHelperProduct::getTaxTotal($product->product_id, $geozones);
$product->taxtotal = $taxtotal;
$product->tax = $taxtotal->tax_total;
}
$product->filter_category = '';
$categories = Citruscart::getClass('CitruscartHelperProduct', 'helpers.product')->getCategories($product->product_id);
if (!empty($categories)) {
$product->link .= "&filter_category=" . $categories[0];
$product->filter_category = $categories[0];
}
$itemid = Citruscart::getClass("CitruscartHelperRoute", 'helpers.route')->category($product->filter_category, true);
if (empty($itemid)) {
$itemid = Citruscart::getClass("CitruscartHelperRoute", 'helpers.route')->findItemid(array('view' => 'products'));
}
$product->itemid = $itemid;
}
}
return $products;
}
/**
* Gets a product's related items
* formatted for display
*
* @param int $address_id
* @return string html
*/
private function getRelationshipsHtml($product_id, $relation_type = 'relates')
{
$input = JFactory::getApplication()->input;
$html = '';
$validation = "";
// get the list
JModelLegacy::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/models');
$model = JModelLegacy::getInstance('ProductRelations', 'CitruscartModel');
$model->setState('filter_relation', $relation_type);
switch ($relation_type) {
case "requires":
$model->setState('filter_product_from', $product_id);
$check_quantity = false;
$layout = 'product_requirements';
break;
case "parent":
case "child":
case "children":
$model->setState('filter_product_from', $product_id);
$check_quantity = true;
$validation = "index.php?option=com_citruscart&view=products&task=validateChildren&format=raw";
$layout = 'product_children';
break;
case "relates":
$model->setState('filter_product', $product_id);
$check_quantity = false;
$layout = 'product_relations';
break;
default:
return $html;
break;
}
if ($items = $model->getList()) {
$filter_category = $model->getState('filter_category', $input->get('filter_category'));
if (empty($filter_category)) {
$categories = Citruscart::getClass('CitruscartHelperProduct', 'helpers.product')->getCategories($product_id);
if (!empty($categories)) {
$filter_category = $categories[0];
}
}
$user = JFactory::getUser();
$config = Citruscart::getInstance();
$show_tax = $config->get('display_prices_with_tax');
foreach ($items as $key => $item) {
if ($check_quantity) {
// TODO Unset $items[$key] if
// this is out of stock &&
// check_inventory &&
// item for sale
}
if ($item->product_id_from == $product_id) {
// display the _product_to
$item->product_id = $item->product_id_to;
$item->product_name = $item->product_name_to;
$item->product_model = $item->product_model_to;
$item->product_sku = $item->product_sku_to;
$item->product_price = $item->product_price_to;
} else {
// display the _product_from
$item->product_id = $item->product_id_from;
$item->product_name = $item->product_name_from;
$item->product_model = $item->product_model_from;
$item->product_sku = $item->product_sku_from;
$item->product_price = $item->product_price_from;
}
//get the right price base on the $filter_group
$filter_group = CitruscartHelperUser::getUserGroup($user->id, $item->product_id);
$priceObj = CitruscartHelperProduct::getPrice($item->product_id, '1', $filter_group);
$item->product_price = $priceObj->product_price;
$itemid = Citruscart::getClass("CitruscartHelperRoute", 'helpers.route')->product($item->product_id, $filter_category, true);
$item->itemid = $input->getInt('Itemid', $itemid);
$item->tax = 0;
$item->showtax = $show_tax;
if ($show_tax) {
Citruscart::load('CitruscartHelperUser', 'helpers.user');
$geozones = CitruscartHelperUser::getGeoZones($user->id);
if (empty($geozones)) {
// use the default
$table = JTable::getInstance('Geozones', 'CitruscartTable');
$table->load(array('geozone_id' => $config->get('default_tax_geozone')));
$geozones = array($table);
}
$taxtotal = CitruscartHelperProduct::getTaxTotal($item->product_id, $geozones);
$tax = $taxtotal->tax_total;
$item->taxtotal = $taxtotal;
$item->tax = $tax;
}
}
}
if (!empty($items)) {
$vars = new JObject();
$vars->items = $items;
$vars->product_id = $product_id;
$vars->filter_category = $filter_category;
$vars->validation = $validation;
ob_start();
echo $this->_getLayout($layout, $vars);
$html = ob_get_contents();
ob_end_clean();
}
return $html;
}
/**
* Set basic properties for the item, whether in a list or a singleton
*
* @param unknown_type $item
* @param unknown_type $key
* @param unknown_type $refresh
*/
protected function prepareItem(&$item, $key = 0, $refresh = false)
{
Citruscart::load("CitruscartHelperProduct", 'helpers.product');
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$helper_product = new CitruscartHelperProduct();
if (!empty($item->product_recurs)) {
$item->recurring_price = $item->price;
if ($item->subscription_prorated) {
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$result = CitruscartHelperSubscription::calculateProRatedTrial($item->subscription_prorated_date, $item->subscription_prorated_term, $item->recurring_period_unit, $item->recurring_trial_price, $item->subscription_prorated_charge);
$item->price = $result['price'];
$item->prorated_price = $result['price'];
$item->prorated_interval = $result['interval'];
$item->prorated_unit = $result['unit'];
// $item->recurring_trial = $result['trial'];
} else {
if (!empty($item->recurring_trial)) {
$item->price = $item->recurring_trial_price;
}
}
}
$user_id = $this->getState('user.id', 0);
$qty = $this->getState('product.qty', -1);
if ($qty > -1) {
$user_group = CitruscartHelperUser::getUserGroup($user_id, $item->product_id);
$price = CitruscartHelperProduct::getPrice($item->product_id, $qty, $user_group);
$item->price = @$price->product_price;
}
$item->product_parameters = new DSCParameter($item->product_params);
$item->slug = $item->product_alias ? ":{$item->product_alias}" : "";
$item->link = 'index.php?option=com_citruscart&view=products&task=view&id=' . $item->product_id;
$item->link_edit = 'index.php?option=com_citruscart&view=products&task=edit&id=' . $item->product_id;
$item->product_categories = $this->getCategories($item->product_id);
$item->default_attributes = $helper_product->getDefaultAttributes($item->product_id);
$item->product_classes = null;
foreach ($item->product_categories as $cat) {
$item->product_classes .= " " . $cat->category_alias;
}
if (!empty($item->product_class_suffix)) {
$item->product_classes .= " " . $item->product_class_suffix;
}
$item->product_classes = trim($item->product_classes);
parent::prepareItem($item, $key, $refresh);
}
