function getMobileReports()
{
define('COLUMNS_COUNT_FOR_SIMPLE_TEMPLATE', 3);
define('PATH_TO_MOBILE_REPORTS', '/bitrix/admin/mobile/sale_reports_view.php');
// Using report module
if (!CModule::IncludeModule('report')) {
return false;
}
// Using catalog module
if (!CModule::IncludeModule('catalog')) {
return false;
}
CBaseSaleReportHelper::initOwners();
$dbRepList = Bitrix\Report\ReportTable::getList(array('select' => array('ID', 'TITLE', 'SETTINGS'), 'filter' => array('=CREATED_BY' => $GLOBALS["USER"]->GetID(), '=OWNER_ID' => CBaseSaleReportHelper::getOwners())));
$arMenuItems = array();
while ($arReport = $dbRepList->fetch()) {
$settings = unserialize($arReport['SETTINGS']);
if (isset($settings['mobile']) && is_array($settings['mobile']) && isset($settings['mobile']['enabled']) && $settings['mobile']['enabled'] == true) {
if (count($settings['select']) <= COLUMNS_COUNT_FOR_SIMPLE_TEMPLATE) {
$template = "admin_mobile";
} else {
$template = "admin_mobile_encl";
}
$arMenuItems[] = array("text" => htmlspecialcharsbx($arReport['TITLE']), "data-url" => PATH_TO_MOBILE_REPORTS . '?ID=' . $arReport['ID'] . '&rep_templ=' . $template);
}
}
if (empty($arMenuItems)) {
return false;
} else {
return array("text" => GetMessage("SMOB_REPORTS"), "type" => "section", "items" => $arMenuItems);
}
}
"items_id" => "menu_sale_stat",
"items" => array(),
);
if(IsModuleInstalled('report'))
{
$arSaleReports = array();
if(method_exists($adminMenu, "IsSectionActive"))
{
if($adminMenu->IsSectionActive("menu_sale_report") && CModule::IncludeModule("report"))
{
CModule::IncludeModule("sale");
CBaseSaleReportHelper::initOwners();
$dbRepList = Bitrix\Report\ReportTable::getList(array(
'select' => array('ID', 'TITLE', 'DESCRIPTION'),
'filter' => array('=CREATED_BY' => $USER->GetID(), '=OWNER_ID' => CBaseSaleReportHelper::getOwners())
));
while($arReport = $dbRepList->fetch())
{
$arSaleReports[] = array(
"text" => htmlspecialcharsbx($arReport["TITLE"]),
"title" => htmlspecialcharsbx($arReport["DESCRIPTION"]),
"url" => "sale_report_view.php?lang=".LANGUAGE_ID."&ID=".$arReport["ID"],
"more_url" => array("sale_report_construct.php?lang=".LANGUAGE_ID."&ID=".$arReport["ID"]),
);
}
}
}
$arMenu["items"][] = array(
"text" => GetMessage("SALE_REPORTS_DESCR"),
$DB->StartTransaction();
if (!CReport::Delete($ID)) {
$DB->Rollback();
if ($ex = $APPLICATION->GetException()) {
$lReports->AddGroupError($ex->GetString(), $ID);
} else {
$lReports->AddGroupError(GetMessage("SALE_REPORT_ERROR_DELREPFROMLIST"), $ID);
}
}
$DB->Commit();
break;
}
}
}
// Getting reports list.
$dbRepList = Bitrix\Report\ReportTable::getList(array('select' => array('ID', 'TITLE', 'DESCRIPTION', 'CREATED_DATE', 'MARK_DEFAULT'), 'filter' => array('=CREATED_BY' => $USER->GetID(), '=OWNER_ID' => CBaseSaleReportHelper::getOwners())));
$dbRepList = new CAdminResult($dbRepList, $sTableID);
$dbRepList->NavStart();
$lReports->NavText($dbRepList->GetNavPrint(GetMessage("SALE_REPORT_TITLE")));
$lReports->AddHeaders(array(array('id' => 'TITLE', 'content' => '<b>' . GetMessage('SALE_REPORT_LIST_TITLE') . '</b>', 'sort' => 'TITLE', 'default' => true), array('id' => 'CREATED_DATE', 'content' => '<b>' . GetMessage('SALE_REPORT_LIST_CREATED_DATE') . '</b>', 'sort' => 'CREATED_DATE', 'default' => true)));
// $arRes containing array as: array( 'ID' =>..., 'TITLE'=>..., 'DESCRIPTION'=>..., 'CREATED_DATE'=>... ).
$nReports = 0;
while ($arRes = $dbRepList->NavNext(false)) {
$lRow = $lReports->AddRow($arRes['ID'], $arRes);
$lRow->AddViewField('TITLE', "<a href='" . "sale_report_view.php?lang=" . LANG . '&ID=' . $arRes['ID'] . "' title='" . $arRes['DESCRIPTION'] . "'>" . $arRes['TITLE'] . "</a>");
$createdDateStr = $arRes['CREATED_DATE'] instanceof \Bitrix\Main\Type\DateTime || $arRes['CREATED_DATE'] instanceof \Bitrix\Main\Type\Date ? ConvertTimeStamp($arRes['CREATED_DATE']->getTimestamp(), 'SHORT') : '';
$lRow->AddViewField('CREATED_DATE', $createdDateStr);
$markNum = 0;
if (isset($arRes['MARK_DEFAULT'])) {
$markNum = intval($arRes['MARK_DEFAULT']);
}
?>
<span>
<style type="text/css">
.reports-title-label {
color: #92907E;
font-size: 14px;
padding: 5px 0 6px 4px;
}
</style>
<span class="reports-title-label"><?php
echo GetMessage('SALE_REPORT_HELPER_SELECTOR_LABEL_TEXT') . ':';
?>
</span>
<select id="sale-report-helper-selector" name="rep_owner" class="filter-dropdown">
<?php
foreach (CBaseSaleReportHelper::getOwners() as $ownerId) {
?>
<?php
$ownerText = GetMessage('SALE_REPORT_HELPER_NAME_' . $ownerId);
?>
<?php
if ($ownerText) {
?>
<option value="<?php
echo htmlspecialcharsbx($ownerId);
?>
"><?php
echo htmlspecialcharsbx($ownerText);
?>
</option>
<?php
