function display($tpl = null) { $this->_setToolBar(); $mainframe = JFactory::getApplication(); $input = JFactory::getApplication()->input; $option = $input->get('option', '', 'STRING'); $view = $input->get('view', '', 'STRING'); $filter_order_Dir = $mainframe->getUserStateFromRequest("{$option}.filter_order_Dir", 'filter_order_Dir', 'desc', 'word'); $filter_type = $mainframe->getUserStateFromRequest("{$option}.filter_type", 'filter_type', 0, 'string'); $filter_state = $mainframe->getUserStateFromRequest($option . 'search_list', 'search_list', '', 'string'); $search = $mainframe->getUserStateFromRequest($option . $view . 'search', 'search', '', 'string'); $search = JString::strtolower($search); $limit = ''; $limitstart = ''; $cid = 0; if ($search == null) { $search = ''; } $edit = $input->get('edit', ''); $layout = $input->get('layout', ''); $cid = $input->get('cid', '', 'ARRAY'); $model = $this->getModel('managezone'); if ($cid) { $total = $this->get('Total'); $pagination = $this->get('Pagination'); $zones = $model->Editlist($cid[0]); JLoader::import('buildad', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models'); $Importfields = new socialadsModelBuildad(); $fields = $Importfields->getFields(); $this->fields = $fields; $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', 'limit', 'int'); $limitstart = $mainframe->getUserStateFromRequest($option . 'limitstart', 'limitstart', 0, 'int'); $model->setState('limit', $limit); // Set the limit variable for query later on $model->setState('limitstart', $limitstart); } else { $total = $this->get('Total'); $pagination = $this->get('Pagination'); $zones = $this->get('Managezone'); $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', 'limit', 'int'); $limitstart = $mainframe->getUserStateFromRequest($option . 'limitstart', 'limitstart', 0, 'int'); $model->setState('limit', $limit); // Set the limit variable for query later on $model->setState('limitstart', $limitstart); } // search filter $lists['search_select'] = $search; $lists['search'] = $search; $lists['search_list'] = $filter_state; $lists['order'] = $filter_type; $lists['order_Dir'] = $filter_order_Dir; $lists['limit'] = $limit; $lists['limitstart'] = $limitstart; $modules = $this->get('Zoneamodule'); $this->assignRef('modules', $modules); // Get data from the model $this->assignRef('lists', $lists); $this->assignRef('pagination', $pagination); $this->assignRef('zones', $zones); if (JVERSION >= 3.0) { $this->sidebar = JHtmlSidebar::render(); } parent::display($tpl); }
function getInvoiceDetail($order_id, $pg_nm, $payPerAd = 1) { if (empty($order_id)) { return; } $mainframe = JFactory::getApplication(); $site = $mainframe->getCfg('sitename'); require JPATH_SITE . DS . "administrator" . DS . "components" . DS . "com_socialads" . DS . "config" . DS . "config.php"; $db = JFactory::getDBO(); $query = "SELECT p.id as order_id,p.`ad_id`,p.mdate,p.ad_amount,p.transaction_id,p.status,p.processor,p.payee_id,u.username,u.id, u.email\n\t\tFROM #__ad_payment_info as p, #__users as u\n\t\t\tWHERE p.payee_id=u.id\n\t\t\tAND p.id=" . $order_id; $db->setQuery($query); $orderDetails = $db->loadObject(); $body = JText::_('PAY_PAYMENT_BODY'); $socialadshelper = new socialadshelper(); // GET USER ID FOR BILL INFO //$userId = $socialadshelper->getOrderUserId($order_id); //GET BILL INFO JLoader::import('buildad', JPATH_SITE . DS . 'components' . DS . 'com_socialads' . DS . 'models'); $socialadsModelBuildad = new socialadsModelBuildad(); $billinfo = $socialadsModelBuildad->getbillDetails($orderDetails->id); // DEFINE ORDER STATUS if ($orderDetails->status == 'C') { $orderstatus = JText::_('ADS_INVOICE_STATUS_COMPLEATE'); } else { if ($orderDetails->status == 'P') { $orderstatus = JText::_('ADS_INVOICE_STATUS_PENDING'); } else { if ($orderDetails->status == 'E') { $orderstatus = JText::_('ADS_INVOICE_STATUS_COMPLEATE_ERROR_OCCURED'); } else { $orderstatus = JText::_('ADS_INVOICE_AMOUNT_CANCELLED'); } } } $inv_adver_Html = ""; $sa_displayblocks = array(); // if ad wallet if ($payPerAd == 0) { $sa_displayblocks = array('invoiceDetail' => 1, 'billingDetail' => 0, 'adsDetail' => 0); } $billpath = $socialadshelper->getViewpath('payment', 'invoice'); ob_start(); include $billpath; $inv_adver_Html = ob_get_contents(); ob_end_clean(); //----------------------------- jimport('joomla.utilities.utility'); global $mainframe; $app = JFactory::getApplication(); $mainframe = JFactory::getApplication(); $sitelink = JUri::root(); $manageAdLink = "<a href='" . $sitelink . "administrator" . DS . "index.php?option=com_socialads&view=approveads' targe='_blank'>" . JText::_("COM_SOCIALADS_EMAIL_THIS_LINK") . "</a>"; // GET config details $frommail = $mainframe->getCfg('mailfrom'); $fromname = $mainframe->getCfg('fromname'); $adTitle = $socialadshelper->getAdTitle($orderDetails->ad_id); $siteName = $mainframe->getCfg('sitename'); $today = date('Y-m-d H:i:s'); if (empty($orderDetails->payee_id)) { // return payee id not found return; } $user = JFactory::getUser($orderDetails->payee_id); $adUserName = $user->username; $recipient = $user->email; $displayOrderid = sprintf("%05s", $order_id); // if paper mode if ($payPerAd == 1) { $approve_msg = JText::_("COM_SOCIALADS_INVOICE_MAIL_ADMIN_APPROCE_NO_MSG"); if ($socialads_config['approval'] == 1) { $approve_msg = JText::_("COM_SOCIALADS_INVOICE_MAIL_ADMIN_APPROCE_YES_MSG"); } // FOR ADVERTISER INVICE AND ORDER CONFIRM MAIL $advertiserEmailBody = JText::_("COM_SOCIALADS_INVOICE_MAIL_CONTENT"); // NOW find & REPLACE TAG $find = array('[SEND_TO_NAME]', '[ADVERTISER_NAME]', '[SITENAME]', '[SITELINK]', '[ADTITLE]', '[CONTENT]', '[TIMESTAMP]', '[ORDERID]', '[ADMIN_APPROVAL_MSG]'); $replace = array($adUserName, $adUserName, $siteName, $sitelink, $adTitle, $content, $today, $displayOrderid, $approve_msg); $advertiserEmailBody = str_replace($find, $replace, $advertiserEmailBody); $advertiserEmailBody = $advertiserEmailBody . "<br> <br>" . $inv_adver_Html; $subject = JText::sprintf('ADS_INVOICE_MAIL_SUB', $displayOrderid); $status = $socialadshelper->sendmail($recipient, $subject, $advertiserEmailBody, '', 0, ""); // -------------- ADMIN INVOICE MAIL COPY -------------------- $adminEmailBody = JText::_("COM_SOCIALADS_INVOICE_MAIL_CONTENT_ADMIN_COPY"); $orderPrice = $orderDetails->ad_amount . " " . $socialads_config["currency"]; $admin_approve_msg = ''; //!$app->isAdmin() && $admin_approve_msg = ''; if ($socialads_config['approval'] == 1) { $admin_approve_msg = JText::sprintf("COM_SOCIALADS_APPRVE_MAIL_TO_ADMIN_ADD_MSG", $manageAdLink); } $find = array('[SEND_TO_NAME]', '[ADVERTISER_NAME]', '[SITENAME]', '[VALUE]', '[ORDERID]', '[ADMIN_APPROVAL_MSG]'); $replace = array($fromname, $adUserName, $siteName, $orderPrice, $displayOrderid, $admin_approve_msg); $adminEmailBody = str_replace($find, $replace, $adminEmailBody); $adminEmailBody = $adminEmailBody . "<br> <br>" . $inv_adver_Html; $subject = JText::sprintf('COM_SOCIALADS_INVOICE_MAIL_ADVERTISER_ADMIN_SUBJECT', $displayOrderid); $status = $socialadshelper->sendmail($frommail, $subject, $adminEmailBody, '', 0, ""); } else { // ADVERTISER MAIL $advertiserEmailBody = JText::_("COM_SOCIALADS_WALLET_ADDED_BALACE_ADVETISER_EMAIL"); // NOW find & REPLACE TAG $find = array('[SEND_TO_NAME]', '[SITENAME]', '[ORDERID]'); $replace = array($adUserName, $siteName, $displayOrderid); $advertiserEmailBody = str_replace($find, $replace, $advertiserEmailBody); $advertiserEmailBody = $advertiserEmailBody . "<br> <br>" . $inv_adver_Html; $subject = JText::sprintf('COM_SOCIALADS_WALLET_ADDED_BALACE_ADVETISER_EMAIL_SUBJECT', $displayOrderid); $status = $socialadshelper->sendmail($recipient, $subject, $advertiserEmailBody, '', 0, ""); // ADMIN INVOICE MAIL COPY $adminEmailBody = JText::_("COM_SOCIALADS_INVOICE_MAIL_CONTENT_ADMIN_COPY"); $orderPrice = $orderDetails->ad_amount . " " . $socialads_config["currency"]; $find = array('[SEND_TO_NAME]', '[ADVERTISER_NAME]', '[SITENAME]', '[VALUE]', '[ORDERID]', '[ADMIN_APPROVAL_MSG]'); $replace = array($fromname, $adUserName, $siteName, $orderPrice, $displayOrderid, ''); $adminEmailBody = str_replace($find, $replace, $adminEmailBody); $adminEmailBody = $adminEmailBody . "<br> <br>" . $inv_adver_Html; $subject = JText::sprintf('COM_SOCIALADS_INVOICE_MAIL_ADVERTISER_ADMIN_SUBJECT', $displayOrderid); $status = $socialadshelper->sendmail($frommail, $subject, $adminEmailBody, '', 0, ""); // ad wallet mode } }