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 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; }