function __construct($config=array())
{
$MyApp= JTheFactoryApplication::getInstance();
$lang= JFactory::getLanguage();
$lang->load('thefactory.payments');
$config['view_path']=$MyApp->app_path_front.'payments'.DS."views";
parent::__construct($config);
JTheFactoryHelper::modelIncludePath('payments');
JTheFactoryHelper::tableIncludePath('payments');
}
function __construct($modulename = null)
{
$this->modulename = $modulename;
if (!$modulename) {
$this->modulename = $this->name;
}
$MyApp = JTheFactoryApplication::getInstance();
$this->basepath = $MyApp->app_path_admin . strtolower($this->modulename);
$config = array('view_path' => $this->basepath . DS . "views");
parent::__construct($config);
$this->loadLanguage();
$this->registerClass('toolbar');
$this->registerClass('helper');
$this->registerClass('submenu');
if (file_exists($this->basepath . DS . "models")) {
JTheFactoryHelper::modelIncludePath($this->modulename);
}
if (file_exists($this->basepath . DS . "tables")) {
JTheFactoryHelper::tableIncludePath($this->modulename);
}
}
function getBalance() {
JTheFactoryHelper::modelIncludePath('payments');
$balance = JModelLegacy::getInstance('balance','JTheFactoryModel');
return $balance->getUserBalance();
}
function getModel($model)
{
jimport('joomla.application.component.model');
JTheFactoryHelper::modelIncludePath('payments');
return JModel::getInstance($model, 'JTheFactoryModel');
}
function sendNotificationMail($user)
{
$config = JFactory::getConfig();
$mail_from = $config->getValue("mailfrom");
$sitename = $config->getValue("sitename");
JTheFactoryHelper::modelIncludePath('payments');
$balancemodel = JModel::getInstance('Balance', 'JTheFactoryModel');
$balance = $balancemodel->getUserBalance($user->id);
$r = $this->loadPricingObject();
$params = new JParameter($r->params);
$email_text = base64_decode($params->get('email_text'));
$link = JURI::root() . '/index.php?option=' . APP_EXTENSION . '&task=paycomission';
$email_text = str_replace('%USERNAME%', $user->username, $email_text);
$email_text = str_replace('%NAME%', $user->name, $email_text);
$email_text = str_replace('%BALANCE%', $balance->balance . " " . $balance->currency, $email_text);
$email_text = str_replace('%LINK%', $link, $email_text);
JUTility::sendMail($mail_from, $sitename, $user->email, JText::_("COM_BIDS_COMISION_PAYMENT_NOTIFICATION"), $email_text, true);
}
function cron()
{
/* cron script Pass and authentication*/
$cfg=BidsHelperTools::getConfig();
$config =JFactory::getConfig();
$pass=JRequest::getVar('pass');
$debug= JRequest::getVar('debug',0);
$date=new JDate();
$nowMysql=$date->toMySQL(false);
$database = JFactory::getDbo();
JTheFactoryHelper::modelIncludePath('payments');
JTheFactoryHelper::tableIncludePath('payments');
$log= JTable::getInstance('bidcronlog');
$log->priority='log';
$log->event='cron';
$log->logtime=$nowMysql;
$logtext="";
if ($cfg->bid_opt_cron_password!==$pass) {
//Bad Password, log and exit;
$log->log=JText::_("COM_BIDS_BAD_PASSWORD_USED")." > $pass";
$log->store();
die(JText::_("COM_BIDS_ACCESS_DENIED"));
}
@set_time_limit(0);
@ignore_user_abort(true);
// reminder for due to expire suggestions
$database->setQuery(" SELECT s.auction_id,a.userid
FROM #__bid_suggestions AS s
LEFT JOIN #__bid_auctions AS a
ON s.auction_id = a.id
WHERE
s.status=2
AND UTC_TIMESTAMP() > DATE_ADD( s.modified, INTERVAL 24 HOUR)
AND a.published=1
AND a.close_offer=0
AND a.close_by_admin=0
AND UTC_TIMESTAMP() < a.end_date
GROUP BY s.auction_id");
$curs = $database->loadObjectList();
if(count($curs)>0) {
$auction = JTable::getInstance('auction');
$userIds = array();
foreach($curs as $k=>$val) {
$userIds[] = $val->userid;
}
$database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ( '.implode(',',$userIds).' )');
$mails = $database->loadObjectList();
$auction->SendMails($mails,'suggest_reminder'); //Notyfy Sellers abour pending suggestions
}
// reject expired suggestions
$database->setQuery(" SELECT a.id AS suggestionId,a.auction_id,b.userid
FROM #__bid_suggestions AS a
LEFT JOIN #__bid_auctions AS b
ON a.auction_id = b.id
WHERE
UTC_TIMESTAMP() > DATE_ADD( a.modified, INTERVAL 48 HOUR)
AND a.status=2");
$curs = $database->loadObjectList();
if(count($curs)>0) {
$auction = JTable::getInstance('auction');
$userIds = array();
$suggestionIds = array();
foreach($curs as $k=>$val) {
$suggestionIds[] = $val->suggestionId;
$userIds[] = $val->userid;
}
$database->setQuery('UPDATE #__bid_suggestions SET status=0 WHERE id IN ('.implode(',',$suggestionIds).')');
$database->query();// reject the suggestions
$database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ( '.implode(',',$userIds).' )');
$mails = $database->loadObjectList();
$auction->SendMails($mails,'suggest_rejected'); //Notyfy Bidders abour rejected suggestion
}
//CLOSE auctions
$query = "SELECT
a.*,
a.id as auctionId,
GROUP_CONCAT(b.userid) AS bidderIds,
GROUP_CONCAT(w.userid) AS watcherIds
FROM #__bid_auctions AS a
LEFT JOIN #__bids AS b
ON a.id=b.auction_id
LEFT JOIN #__bid_watchlist AS w
ON a.id=w.auction_id
WHERE
UTC_TIMESTAMP() >= a.end_date
AND a.close_offer = 0
AND a.published = 1
AND a.close_by_admin=0
GROUP BY a.id";
$database->setQuery($query);
$rows = $database->loadObjectList('auctionId');
$extendedAuctions = array();
if($cfg->bid_opt_auto_extent && $cfg->bid_opt_auto_extent_nobids) {
//these auctions have no bids and will be extended
foreach($rows as $id=>$r) {
if(!$r->bidderIds) {
$extendedAuctions[] = $id;
}
}
}
if(count($rows)>0) {
$auction = JTable::getInstance('auction');
//exclude auctions that are going to be extended
$closeAuctions = array_diff(array_keys($rows),$extendedAuctions);
if(count($closeAuctions)) {
$database->setQuery('UPDATE
#__bid_auctions
SET
close_offer=1,
closed_date=UTC_TIMESTAMP()
WHERE
id IN ('.implode(',', $closeAuctions).')');
$database->query();
}
foreach ($rows as $r) {
//Notify bidders
$auction->bind($r);
//extend auctions with no bids
if($cfg->bid_opt_auto_extent && $cfg->bid_opt_auto_extent_nobids>0 && !$r->bidderIds) {
$extendedPeriodSeconds = $cfg->bid_opt_auto_extent_nobids * BidsHelperDateTime::translateAutoextendPeriod($cfg->bid_opt_auto_extent_nobids_type);
$endTime = BidsHelperDateTime::getTimeStamp($auction->end_date);
$newEndTime = $endTime + $extendedPeriodSeconds;
$auction->end_date = gmdate('Y-m-d H:i:s',$newEndTime);
$auction->store();
continue;
}
jimport('joomla.application.component.model');
JModelLegacy::addIncludePath(JPATH_COMPONENT_SITE.DS.'models');
$auctionmodel = JModelLegacy::getInstance('auction','bidsModel');
$auctionmodel->load($r->auctionId);
$seller = JTable::getInstance('user');
$seller->load($r->userid);
if($r->automatic) {
$a = $auctionmodel->get('auction');
$highestBid = $a->highestBid;
$nrHighestBids = 1;
if( AUCTION_TYPE_PRIVATE == $a->auction_type ) {
if($highestBid) {
$query = 'SELECT COUNT(1) AS nrHighestBids
FROM #__bids
WHERE
auction_id='.$r->auctionId.'
AND bid_price='.$highestBid->bid_price;
$database->setQuery($query);
$nrHighestBids = $database->loadResult();
}
else {
$nrHighestBids = 0;
}
}
if($highestBid) {
if ($nrHighestBids>1) {
//mark auction as NOT automatic and alert owner that 2 or more bids are the same
$database->setQuery('UPDATE #__bid_auctions SET automatic=0 WHERE id='.$a->id);
$database->query();
$auctionmodel->SendMails(array($seller),'bid_choose_winner');
} else {
if ($cfg->bid_opt_global_enable_reserve_price && $a->reserve_price>0 && $a->reserve_price>=$highestBid->bid_price) {
//reserve price not met!
$auctionmodel->SendMails(array($seller),'bid_reserve_not_met');//reserve price not met
} else {
$bid = JTable::getInstance('bid');
$bid->bind($highestBid);
$auctionmodel->close($bid);
}
}
} else {
$auctionmodel->SendMails(array($seller),'bid_offer_no_winner_to_owner');
}
} else {
// Notify owner to choose winner OR that his auction has no winner
$auctionmodel->SendMails(array($seller), $r->bidderIds ? 'bid_choose_winner' : 'bid_offer_no_winner_to_owner');
}
if($r->bidderIds) {
$database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ('.$r->bidderIds.')');
$mails = $database->loadObjectList();
$auctionmodel->SendMails($mails,'bid_closed'); //Notyfy Bidders abour closed Auction
$database->setQuery('DELETE FROM #__bid_watchlist WHERE auction_id='.$r->id.' AND userid IN ('.$r->bidderIds.')');
$database->query();//delete bidders from watchlist, to avoid double notification
}
//Notify Watchlist, Clean Watchlist
if($r->watcherIds) {
$database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ('.$r->watcherIds.')');
$mails = $database->loadObjectList();
$auctionmodel->SendMails($mails,'bid_watchlist_closed'); //Notify Watchlist
$database->setQuery('DELETE FROM #__bid_watchlist WHERE auction_id='.$r->id);
$database->query();
}
}
}
// END EXPIRED AUCTION
//Daily Jobs (things that should run once a day )
$daily= JRequest::getVar('daily','');
if ($daily){
//Notify upcoming expirations
$query = "SELECT a.* from #__bid_auctions AS a
WHERE UTC_TIMESTAMP() >= DATE_ADD(end_date,INTERVAL -1 DAY) AND a.close_offer != 1 AND published = 1 AND a.close_by_admin!=1";
$database->setQuery($query);
$rows = $database->loadObjectList();
$auction = JTable::getInstance('auction');
$logtext.=sprintf("Soon to expire: %d auctions\r\n",count($rows));
foreach ($rows as $row){
$auction->load($row->id);
$usr=JFactory::getUser($row->userid);
$auction->SendMails(array($usr),'bid_your_will_expire'); // Notify Owner that his auction will soon expire
$query = "SELECT u.* FROM #__users u
left join #__bid_watchlist w on u.id = w.userid
where w.auction_id = ".$row->id;
$database->setQuery($query);
$watchlist_mails = $database->loadObjectList();
$auction->SendMails($watchlist_mails,'bid_watchlist_will_expire'); //Notify Users in watchlist that an auction will expire
}
//Close all auctions without a parent user (deleted users?)s
$query = "UPDATE
#__bid_auctions AS a
LEFT JOIN #__users AS b
ON a.userid=b.id
SET
close_by_admin=1,
closed_date=UTC_TIMESTAMP()
WHERE b.id IS NULL";
$database->setQuery($query);
$database->query();
//delete Very old auctions (past Archived time)
$interval = intval($bidCfg->bid_opt_archive);
$d_opt = ( $bidCfg->bid_opt_archive_type!='') ? $bidCfg->bid_opt_archive_type : 'month';
$d_opt_sql = strtoupper($d_opt);
if ($interval>0){
$query = "SELECT id
FROM #__bid_auctions
WHERE UTC_TIMESTAMP() > DATE_ADD( closed_date, INTERVAL $interval
{$d_opt_sql} )
AND (close_offer =1
or close_by_admin=1)";
$database->setQuery($query);
$idx = $database->loadResultArray(); //select auctions that have to be purged
$row = JTable::getInstance('auction');
if (count($idx)) {
foreach ($idx as $id){
$row->delete($id);
}
}
}
$model= JModelLegacy::getInstance('Currency','JTheFactoryModel');
$currtable= JTable::getInstance('CurrencyTable','JTheFactory');
$currencies=$model->getCurrencyList();
$default_currency=$model->getDefault();
$results=array();
foreach($currencies as $currency){
if ($currency->name==$default_currency){
$currtable->load($currency->id);
$currtable->convert=1;
$currtable->store();
$results[]=$currency->name." ---> ".$default_currency." = 1";
continue;
}
$conversion=$model->getGoogleCurrency($currency->name,$default_currency);
if ($conversion===false){
$results[]=JText::_("COM_BIDS_ERROR_CONVERTING")." {$currency->name} --> $default_currency";
continue;
}
$currtable->load($currency->id);
$currtable->convert=$conversion;
$currtable->store();
$results[]=$currency->name." ---> ".$default_currency." = $conversion ";
}
$logtext.=implode("\r\n",$results);
$logtext.="\r\n";
//some cleanup
}
$log->log=$logtext;
$log->store();
if ($debug) return;
ob_clean();
exit();
}
function notices()
{
JTheFactoryHelper::modelIncludePath('payments');
$balancemodel = JModel::getInstance('Balance', 'JTheFactoryModel');
$balancemodel->set('filters', 'p.balance<0');
$rows = $balancemodel->getBalancesList();
$viewMenu = $this->getView('menu');
$viewMenu->display();
$view = $this->getView('Notices');
$view->assign('userbalances', $rows);
$view->assign('pagination', $balancemodel->get('pagination'));
$view->display();
}
function changeProfileIntegration()
{
$MyApp = JTheFactoryApplication::getInstance();
$cfg = BidsHelperTools::getConfig();
$cfg->bid_opt_profile_mode = JRequest::getVar('profile_mode');
$cfg->bid_opt_registration_mode = JRequest::getVar('registration_mode');
JTheFactoryHelper::modelIncludePath('config');
$formxml = JPATH_ROOT . DS . "administrator" . DS . "components" . DS . APP_EXTENSION . DS . $MyApp->getIniValue('configxml');
$model = JModel::getInstance('Config', 'JTheFactoryModel', array('formxml' => $formxml));
$model->save($cfg);
$this->setRedirect("index.php?option=com_bids&task=integration", JText::_("COM_BIDS_SETTINGS_SAVED"));
}
function setCurrentTheme($theme)
{
$MyApp = JTheFactoryApplication::getInstance();
$cfg = JTheFactoryHelper::getConfig();
$cfg->theme = $theme;
JTheFactoryHelper::modelIncludePath('config');
$formxml = JPATH_ROOT . DS . "administrator" . DS . "components" . DS . APP_EXTENSION . DS . $MyApp->getIniValue('configxml');
$model = JModel::getInstance('Config', 'JTheFactoryModel', array('formxml' => $formxml));
$model->save($cfg);
}
function smarty_positions($params, &$smarty) {
if(!isset($params['position']) || empty($params['position']))
return null;
if(!isset($params['item']) || empty($params['item']))
return null;
$item=$params['item'];
$page=(isset($params['page']))?$params['page']:"";
$catfield=null;
if (is_callable(array($item,'getCategoryField')))
$catfield=$item->getCategoryField(); //make sure proper object is passed
if (is_object($item)) $item=get_object_vars($item);
$position=$params['position'];
$template_file=$smarty->get_template_vars('template_file');
JTheFactoryHelper::modelIncludePath('positions');
$model= JModelLegacy::getInstance('Positions','JTheFactoryModel');
$fields=$model->getFieldsForPosition($template_file,$position);
$result="";
$fieldObj= JTable::getInstance('FieldsTable','JTheFactory');
JTheFactoryHelper::modelIncludePath('fields');
$fieldsmodel= JModelLegacy::getInstance('Fields','JTheFactoryModel');
foreach($fields as $field)
if (isset($item[$field->db_name])&&$page==$field->page)
{
$fieldObj->bind($field);
if ($catfield && $fieldObj->categoryfilter && !$fieldsmodel->hasAssignedCat($fieldObj,$item->$catfield))
continue;
$ftype= CustomFieldsFactory::getFieldType($field->ftype);
$field_label=$field->name;
$field_html=$ftype->getTemplateHTML($fieldObj,$item[$field->db_name]);
$result.="<div id='{$field->db_name}'><label class='custom_field'>{$field_label}</label>: {$field_html}</div>";
}
return $result;
}