function getPaymentVars($pg_plugin, $order_id)
{
if (!class_exists('socialadsModelpayment')) {
//require_once $path;
JLoader::register('socialadsModelpayment', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models' . DS . 'payment.php');
JLoader::load('socialadsModelpayment');
}
$socialadsModelpayment = new socialadsModelpayment();
return $socialadsModelpayment->getPaymentVars($pg_plugin, $order_id, $payPerAd = 1);
/*
require(JPATH_SITE.DS."administrator".DS."components".DS."com_socialads".DS."config".DS."config.php");
$orderdata = $this->getdetails($order_id);
$pg_plugin=$orderdata['pg_plugin'];
$vars = new stdclass;
$vars->order_id=$orderdata['order_id'];
$socialadshelper= new socialadshelper();
$orderdata['ad_title']=$socialadshelper->getAdInfo($orderdata['adid'],'ad_title');
if(!empty($orderdata['payment_type']))
$vars->payment_type=$orderdata['payment_type'];
else
$vars->payment_type="";
$vars->user_id=JFactory::getUser()->id;
$vars->user_name=JFactory::getUser()->name;
$vars->user_firstname=JFactory::getUser()->name;
$vars->user_email=JFactory::getUser()->email;
$vars->item_name = JText::_('ADVERTISEMENT').$orderdata['ad_title']['0']->ad_title;
$msg_fail=JText::_( 'ERROR_SAVE' );
$vars->return = JRoute::_(JUri::root()."index.php?option=com_socialads&view=managead&layout=list");
$vars->submiturl = JRoute::_("index.php?option=com_socialads&controller=showad&task=confirmpayment&processor={$pg_plugin}");
$vars->cancel_return = JRoute::_(JUri::root()."index.php?option=com_socialads&view=managead&layout=list&processor={$pg_plugin}",$msg_fail);
$vars->url=$vars->notify_url= JRoute::_(JUri::root()."?option=com_socialads&controller=showad&task=processpayment&pg_nm={$pg_plugin}&pg_action=onTP_Processpayment&order_id=".$orderdata['order_id']);
$vars->currency_code = $socialads_config['currency'];
$vars->amount = $orderdata['amount'];
$vars->client="socialads";
$vars->success_message = $orderdata['success_message'];
if($vars->payment_type=='recurring')
{
$vars->notify_url= $vars->url=$vars->url."&payment_type=recurring";
$vars->recurring_startdate=$orderdata['recurring_startdate'];
$vars->recurring_payment_interval_unit="days";
$vars->recurring_payment_interval_totaloccurances=$orderdata['recurring_payment_interval_totaloccurances'];
$vars->recurring_payment_interval_length=$orderdata['recurring_payment_interval_length'];
}
return $vars;
* */
}
//getting GETWAYS
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('payment');
if (!is_array($selected_gateways)) {
$gateway_param[] = $selected_gateways;
} else {
$gateway_param = $selected_gateways;
}
if (!empty($gateway_param)) {
$gateways = $dispatcher->trigger('onTP_GetInfo', array($gateway_param));
}
$this->ad_gateways = $gateways;
// getting payment list END
// get SELECTED paymen plugin html
JLoader::import('payment', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models');
$paymodel = new socialadsModelpayment();
$selectedGateway = !empty($adDetail['processor']) ? $adDetail['processor'] : (!empty($this->ad_gateways) ? $this->ad_gateways[0]->id : '');
$payhtml = $paymodel->getHTML($selectedGateway, $order_id);
?>
<!--techjoomla-bootstrap -->
<div class="techjoomla-bootstrap ad_reviewAdmainContainer" >
<?php
echo "";
?>
<!-- bill msg -->
<div class="row-fluid ">
<div class="span12">sasdfasfasd</div>
</div>
<!-- for ad detail and preview -->
function migrateads_camp($migrate_status)
{
require JPATH_SITE . DS . "administrator" . DS . "components" . DS . "com_socialads" . DS . "config" . DS . "config.php";
$input = JFactory::getApplication()->input;
//require(JPATH_SITE.DS."components".DS."com_socialads".DS."models".DS."payment.php");
//jloader
$db = JFactory::getDBO();
$query = " SELECT ad_creator FROM #__ad_data GROUP BY ad_creator";
$db->setQuery($query);
$ad_creator = $db->loadColumn();
$json = 0;
//$msg = JText::_('AUTO_GENERATED');
foreach ($ad_creator as $key) {
$query = " SELECT * FROM #__ad_data WHERE ad_creator = " . $key . " AND camp_id = 0";
$db->setQuery($query);
$ad_info = $db->loadobjectlist();
//print_r($ad_info);
//create new camp as old camp.....
$query = "SELECT campaign,camp_id FROM #__ad_campaign WHERE campaign = 'Old Ads' AND user_id = " . $key;
$db->setQuery($query);
$ifexists_camp = $db->loadobjectlist();
if ($ad_info) {
foreach ($ad_info as $row) {
// for each ad calculate USD
if ($row->ad_credits_balance) {
if ($migrate_status == 'camp_hide') {
$json = 1;
return $json;
}
}
}
}
if (empty($ifexists_camp)) {
$insertcamp = new stdClass();
$insertcamp->camp_id = '';
$insertcamp->user_id = $key;
$insertcamp->campaign = "Old Ads";
$insertcamp->daily_budget = $socialads_config['camp_currency_daily'];
$insertcamp->camp_published = 1;
if (!$db->insertObject('#__ad_campaign', $insertcamp, 'camp_id')) {
echo $db->stderr();
return false;
}
$last_id_camp = $db->insertid();
} else {
$last_id_camp = $ifexists_camp['0']->camp_id;
}
if ($ad_info) {
foreach ($ad_info as $row) {
// for each ad calculate USD
if ($row->ad_credits_balance) {
// if balance then convert in USD
if ($socialads_config['zone_pricing'] == 1) {
if ($row->ad_zone) {
$query = "SELECT per_imp,per_click FROM #__ad_zone WHERE id = " . $row->ad_zone;
$db->setQuery($query);
$zone = $db->loadobjectlist();
if ($row->ad_payment_type == 1) {
$usd_pay = $row->ad_credits_balance * $zone['0']->per_click;
} else {
$usd_pay = $row->ad_credits_balance * $zone['0']->per_imp;
}
}
} else {
if ($row->ad_payment_type == 1) {
$usd_pay = $row->ad_credits_balance * $socialads_config['clicks_price'];
} else {
$usd_pay = $row->ad_credits_balance * $socialads_config['impr_price'];
}
}
$comment_array = array();
$comment_array[] = 'VIA_MIGRATTION';
$comment_array[] = $row->ad_id;
$comment = implode('|', $comment_array);
sleep(1);
$insertpay = new stdClass();
$insertpay->id = '';
$insertpay->ad_id = 0;
$insertpay->cdate = date('Y-m-d H:i:s');
//todays date
$insertpay->mdate = date('Y-m-d H:i:s');
$insertpay->payee_id = $key;
$insertpay->ad_amount = $usd_pay;
$insertpay->status = "C";
$insertpay->ip_address = $_SERVER["REMOTE_ADDR"];
$insertpay->ad_original_amt = $usd_pay;
$insertpay->comment = 'AUTO_GENERATED';
if (!$db->insertObject('#__ad_payment_info', $insertpay, 'id')) {
echo $db->stderr();
return false;
}
$last_id_pay = $db->insertid();
JLoader::import('payment', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models');
$socialadsModelpayment = new socialadsModelpayment();
//$comment = 'VIA_MIGRATTION';
$transac_id = $socialadsModelpayment->add_transc($usd_pay, $last_id_pay, $comment);
//entry for camp_transc table
$query = "UPDATE #__ad_data SET camp_id =" . $last_id_camp . " WHERE ad_id =" . $row->ad_id;
$db->setQuery($query);
$db->execute();
$json = 1;
} elseif ($row->ad_noexpiry == 1) {
$query = "UPDATE #__ad_data SET camp_id =" . $last_id_camp . " WHERE ad_id =" . $row->ad_id;
$db->setQuery($query);
$db->execute();
$json = 1;
}
}
}
}
return $json;
}
function ad_gatewayHtml()
{
$db = JFactory::getDBO();
$jinput = JFactory::getApplication()->input;
$country = $jinput->get('country', '', 'STRING');
$model = $this->getModel('payment');
$model = new socialadsModelpayment();
$selectedGateway = $jinput->get('gateway', '');
$order_id = $jinput->get('order_id', '');
$payPerAd = $jinput->get('payPerAd', 0, 'INT');
$return = '';
if (!empty($selectedGateway) && !empty($order_id)) {
$model->updateOrderGateway($selectedGateway, $order_id);
$payhtml = $model->getHTML($selectedGateway, $order_id, $payPerAd);
$return = !empty($payhtml[0]) ? $payhtml[0] : '';
}
echo $return;
jexit();
}
function saveOrder($data, $orderid, $pg_nm)
{
$db = JFactory::getDBO();
$paymentdata = new stdClass();
$paymentdata->id = $orderid;
$paymentdata->transaction_id = $data['transaction_id'];
if ($data['status'] == 'C') {
$paymentdata->status = 'C';
if (!empty($data['payment_type']) && $data['payment_type'] == 'recurring') {
$paymentdata->subscription_id = $data['subscription_id'];
if (empty($data['payment_number'])) {
$paymentdata->status = 'P';
}
}
$query = "SELECT ad_original_amt FROM #__ad_payment_info WHERE id =" . $orderid;
$db->setQuery($query);
$tol_amt = $db->loadresult();
$comment = "ADS_PAYMENT";
$transc = $this->add_transc($tol_amt, $orderid, $comment);
}
$paymentdata->extras = $data['raw_data'];
if (!$db->updateObject('#__ad_payment_info', $paymentdata, 'id')) {
echo $db->stderr();
return false;
}
if ($paymentdata->status == 'C') {
// added by VM:
$socialadsModelpayment = new socialadsModelpayment();
$sendmail = $socialadsModelpayment->SendOrderMAil($orderid, $pg_nm);
// end Vm
return true;
} else {
return false;
}
}
function store()
{
$data = JRequest::get('post');
$id = $data['id'];
$status = $data['status'];
//require_once(JPATH_SITE.DS."components".DS."com_socialads".DS."helper.php"); // require when we call from backend
$socialadshelper = new socialadshelper();
if ($status == 'RF') {
$query = "UPDATE #__ad_payment_info SET status ='RF' WHERE id =" . $id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
return 2;
}
$socialadshelper->new_pay_mail($id);
return 3;
} elseif ($status == 'E') {
$query = "UPDATE #__ad_payment_info SET status ='E' WHERE id =" . $id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
return 2;
}
$socialadshelper->new_pay_mail($id);
return 3;
} elseif ($status == 'C') {
$query = "SELECT * FROM #__ad_payment_info WHERE id =" . $id;
$this->_db->setQuery($query);
$result = $this->_db->loadObject();
$query = "UPDATE #__ad_payment_info SET status ='C' WHERE id =" . $id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
return 2;
}
//entry for transaction table
$query = "SELECT ad_id FROM #__ad_payment_info WHERE id = " . $id;
$this->_db->setQuery($query);
$ad = $this->_db->loadresult();
JLoader::import('payment', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models');
$socialadsModelpayment = new socialadsModelpayment();
if (empty($ad)) {
// add wallet
$comment = 'ADS_PAYMENT';
$transc = $socialadsModelpayment->add_transc($result->ad_original_amt, $id, $comment);
$sendmail = $socialadsModelpayment->SendOrderMAil($id, $data['search_gateway'], $payPerAd = 0);
} else {
// pay per ad
$sendmail = $socialadsModelpayment->SendOrderMAil($id, $data['search_gateway'], $payPerAd = 1);
}
require_once JPATH_SITE . '/components/com_socialads/helper.php';
$adid = $result->ad_id;
$qryad = "SELECT ad_payment_type FROM #__ad_data WHERE ad_id =" . $adid;
$this->_db->setQuery($qryad);
$ad_payment_type = $this->_db->loadResult();
if ($ad_payment_type != 2) {
$query = "UPDATE #__ad_data SET ad_credits = ad_credits + {$result->ad_credits_qty}, ad_credits_balance = ad_credits_balance + {$result->ad_credits_qty} WHERE ad_id=" . $result->ad_id;
$this->_db->setQuery($query);
$this->_db->execute();
}
//added by sagar for date type ads
if (empty($subscriptiondata[0]->subscription_id) and $ad_payment_type == 2) {
socialadshelper::adddays($adid, $result->ad_credits_qty);
}
//added by sagar for date type ads
} else {
$query = "UPDATE #__ad_payment_info SET status ='P' WHERE id =" . $id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
return 2;
}
}
return 1;
}
