static function getRecords( $user_id, $limit ){
$dbo = JFactory::getDBO();
$dbo->setQuery( modBidsHelper::getQuery($user_id) );
$list = $dbo->loadObjectList();
return $list;
}
static function getQuery( &$params ){
$module_type = $params->get("type_display",0);
$sort_by = $params->get("sort_by","start_date");
$userid=$params->get("filter_user","");
$selectCols = array(
"a.id",
"a.title",
"a.userid",
"a.auction_type",
"a.initial_price",
"a.BIN_price",
"a.currency",
"u.username as by_user",
"a.start_date",
"a.end_date",
'a.params',
'a.close_offer',
'p.picture',
'MAX(b.bid_price) AS maxBid'
);
$where = array(
"a.published = 1",
"a.close_offer = 0",
"a.close_by_admin = 0",
"a.start_date <= UTC_TIMESTAMP()",
"a.end_date >= UTC_TIMESTAMP()"
);
if ($userid) {
$where[] = "a.userid='{$userid}'";
}
switch( $params->get('bin_filter', 0) )
{
case 1:
$where[] = 'a.auction_type = '.AUCTION_TYPE_PUBLIC;
$where[] = 'a.BIN_price>0';
break;
case 2:
$where[] = 'a.auction_type = ' . AUCTION_TYPE_BIN_ONLY;
break;
}
$orderings = array();
modBidsHelper::_paramQuery($params, $selectCols, $where, $orderings );
$JoinList = array("LEFT JOIN `#__users` as u on a.userid=u.id ",
"LEFT JOIN #__bid_pictures AS p on a.id=p.auction_id");
$orderings[] = "a.$sort_by DESC, p.ordering";
$query="SELECT ".implode(",",$selectCols).
" FROM `#__bid_auctions` as a
LEFT JOIN `#__bids` as b ON a.id=b.auction_id ".
implode(" \r\n ",$JoinList)."\r\n".
"WHERE ".implode(" AND ",$where)." ".PHP_EOL.
"GROUP BY a.id ".PHP_EOL.
"ORDER BY ".implode(",",$orderings);
return $query;
}
$user_id =JRequest::getVar('user');
if(!$user_id){
return;
}
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'options.php');
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'defines.php');
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'helpers'.DS.'bids.php');
BidsHelper::LoadHelperClasses();
JHtml::addIncludePath(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_bids'.DS.'htmlelements');
$mid = $module->id;
$module_type = $params->get("type_display",0);
$nr_auctions = $params->get("nr_auctions_displayed",1);
$image_width = $params->get("image_width",30);
$image_height = $params->get("image_height",30);
$display_image = $params->get("display_image",1);
$display_counter = $params->get("display_counter",0);
$layout = $params->get('template','list');
$sort_by = $params->get("sort_by","start_date");
$filter_featured = $params->get("featured",false);
require_once(dirname(__FILE__).DS.'helper.php');
$rows = modBidsHelper::getRecords( $user_id, 1 );
if($rows && count($rows) > 0){
require(JModuleHelper::getLayoutPath('mod_bids_custom', $layout));
}
}
*/
// no direct access
defined( '_JEXEC' ) or die( 'Restricted access' );
error_reporting(JDEBUG ? E_ALL ^ E_STRICT : 0);
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'options.php');
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'defines.php');
require_once (JPATH_ROOT.DS."components".DS."com_bids".DS.'helpers'.DS.'bids.php');
BidsHelper::LoadHelperClasses();
JHtml::addIncludePath(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_bids'.DS.'htmlelements');
$mid = $module->id;
$module_type = $params->get("type_display",0);
$nr_auctions = $params->get("nr_auctions_displayed",10);
$image_width = $params->get("image_width",30);
$image_height = $params->get("image_height",30);
$display_image = $params->get("display_image",1);
$display_counter = $params->get("display_counter",0);
$layout = $params->get('template','list');
$sort_by = $params->get("sort_by","start_date");
$filter_featured = $params->get("featured",false);
require_once(dirname(__FILE__).DS.'helper.php');
$rows = modBidsHelper::getRecords( $params );
require(JModuleHelper::getLayoutPath('mod_bids', $layout));
