/** @return \CDBResult */
public function getData()
{
$groupId = $this->getFieldValue('GROUP_ID', null);
$dateRegister = $this->getFieldValue('DATE_REGISTER', null);
$active = $this->getFieldValue('ACTIVE', null);
$filter = array();
if ($groupId) {
$filter['GROUP_ID'] = $groupId;
}
if (strlen($dateRegister) > 0) {
if (\Bitrix\Main\Type\Date::isCorrect($dateRegister)) {
$dateRegister = new \Bitrix\Main\Type\Date($dateRegister);
$filter['><USER.DATE_REGISTER'] = array($dateRegister->toString(), $dateRegister->add('1 DAY')->toString());
} else {
$result = new \CDBResult();
$result->InitFromArray(array());
return $result;
}
}
if ($active == 'Y') {
$filter['USER.ACTIVE'] = $active;
} elseif ($active == 'N') {
$filter['USER.ACTIVE'] = $active;
}
$userDb = \Bitrix\Main\UserGroupTable::getList(array('select' => array('NAME' => 'USER.NAME', 'EMAIL' => 'USER.EMAIL', 'USER_ID'), 'filter' => $filter, 'group' => array('NAME', 'EMAIL', 'USER_ID'), 'order' => array('USER_ID' => 'ASC')));
return new \CDBResult($userDb);
}
use Bitrix\Conversion\AttributeManager;
use Bitrix\Conversion\AttributeGroupManager;
use Bitrix\Conversion\ReportContext;
use Bitrix\Main\Loader;
use Bitrix\Main\SiteTable;
use Bitrix\Main\Type\Date;
use Bitrix\Main\Localization\Loc;
Loc::loadMessages(__FILE__);
Loader::IncludeModule('conversion');
if ($APPLICATION->GetGroupRight('conversion') < 'W') {
$APPLICATION->AuthForm(Loc::getMessage('ACCESS_DENIED'));
}
$userOptions = CUserOptions::GetOption('conversion', 'filter', array());
// PERIOD
$from = ($d = $_GET['from'] ?: $userOptions['from']) && Date::isCorrect($d) ? new Date($d) : Date::createFromPhp(new DateTime('first day of last month'));
$to = ($d = $_GET['to'] ?: $userOptions['to']) && Date::isCorrect($d) ? new Date($d) : Date::createFromPhp(new DateTime('last day of this month'));
// RATES
if (!($rateTypes = RateManager::getTypes())) {
die('No rates available!');
}
$rateName = $_GET['rate'] ?: $userOptions['rate'];
if (!($rateType = $rateTypes[$rateName])) {
list($rateName, $rateType) = each($rateTypes);
}
// SITES
$sites = array();
$result = SiteTable::getList(array('select' => array('LID', 'NAME'), 'order' => array('DEF' => 'DESC', 'SORT' => 'ASC')));
while ($row = $result->fetch()) {
$sites[$row['LID']] = $row['NAME'];
}
if (!$sites) {
$gaps = $_SESSION[$loadingSession]['GAPS'];
} else {
$res = array('error' => array('message' => 'loading session broken'));
break;
}
} else {
if (in_array($_REQUEST["type"], array("week_ago", "month_ago", "interval"))) {
$period = array();
\CGridOptions::CalcDates("", array("_datesel" => $_REQUEST["type"], "_days" => 1, "_from" => $_REQUEST["date_from"], "_to" => $_REQUEST["date_to"]), $period);
if (Date::isCorrect($period['_from'])) {
$dateStart = new Date($period['_from']);
} else {
$res = array('error' => array('message' => Loc::getMessage('SEO_ERROR_INCORRECT_DATE') . ': ' . $period['_from']));
break;
}
if (Date::isCorrect($period['_to'])) {
$dateFinish = new Date($period['_to']);
} else {
$res = array('error' => array('message' => Loc::getMessage('SEO_ERROR_INCORRECT_DATE') . ': ' . $period['_to']));
break;
}
$statsData = Adv\YandexStatTable::getCampaignStat($campaignId, $dateStart, $dateFinish);
$gaps = Adv\YandexStatTable::getMissedPeriods($statsData, $dateStart, $dateFinish);
} else {
$res = array('error' => array('message' => 'invalid interval type'));
}
}
$errorMessage = null;
$finish = true;
if (count($gaps) > 0) {
$cnt = 0;
"TYPE" => "ERROR",
"DETAILS" => Loc::getMessage("SEO_ERROR_NO_CAMPAIGN"),
"HTML" => true
));
echo $message->Show();
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/epilog_admin.php");
}
}
if($bShowStats)
{
if(
isset($_REQUEST['date_from']) && isset($_REQUEST['date_to'])
&& Main\Type\Date::isCorrect($_REQUEST['date_from'])
&& Main\Type\Date::isCorrect($_REQUEST['date_to'])
)
{
$statsDateStart = new Main\Type\Date($_REQUEST['date_from']);
$statsDateFinish = new Main\Type\Date($_REQUEST['date_to']);
}
else
{
$statsDateStart = new Main\Type\Date();
$statsDateStart->add("-".Engine\YandexDirectLive::MAX_STAT_DAYS_DELTA." days");
$statsDateFinish = new Main\Type\Date();
}
}
if($bShowStats)
$campaign['SETTINGS']['StartDate'] = ConvertTimeStamp(MakeTimeStamp($campaign['SETTINGS']['StartDate'], "YYYY-MM-DD"));
$campaign['SETTINGS']['EmailNotification']['SendWarn'] = $campaign['SETTINGS']['EmailNotification']['SendWarn'] != Engine\YandexDirect::BOOL_NO;
if ($campaign['OWNER_ID'] != $currentUser['id']) {
$bReadOnly = true;
$bAllowUpdate = false;
$message = new CAdminMessage(array("TYPE" => "ERROR", "MESSAGE" => Loc::getMessage('SEO_CAMPAIGN_WRONG_OWNER', array("#USERINFO#" => "(" . $campaign["OWNER_ID"] . ") " . $campaign["OWNER_NAME"]))));
}
} else {
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_after.php";
$message = new CAdminMessage(array("TYPE" => "ERROR", "DETAILS" => Loc::getMessage("SEO_ERROR_NO_CAMPAIGN"), "HTML" => true));
echo $message->Show();
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/epilog_admin.php";
}
}
if ($bShowStats) {
if (isset($_REQUEST['date_from']) && isset($_REQUEST['date_to']) && Main\Type\Date::isCorrect($_REQUEST['date_from']) && Main\Type\Date::isCorrect($_REQUEST['date_to'])) {
$statsDateStart = new Main\Type\Date($_REQUEST['date_from']);
$statsDateFinish = new Main\Type\Date($_REQUEST['date_to']);
} else {
$statsDateStart = new Main\Type\Date();
$statsDateStart->add("-" . Engine\YandexDirect::MAX_STAT_DAYS_DELTA . " days");
$statsDateFinish = new Main\Type\Date();
}
}
if ($bShowStats) {
$tableID = "tbl_yandex_campaign_banner_stats";
//hack to prevent browser history insertion
if (isset($_REQUEST["mode"]) && ($_REQUEST["mode"] == 'list' || $_REQUEST["mode"] == 'frame')) {
$_REQUEST['admin_history'] = 'Y';
}
$oSort = new \CAdminSorting($tableID, "BANNER_CTR", "desc");
