| Server IP : 37.220.80.31 / Your IP : 13.58.2.68 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/esol.importexportexcel/admin/ |
Upload File : |
<?php
use Bitrix\Main\Entity\Query;
use Bitrix\Main\Entity\ExpressionField;
if(!defined('NO_AGENT_CHECK')) define('NO_AGENT_CHECK', true);
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php");
require_once($_SERVER["DOCUMENT_ROOT"].BX_ROOT."/modules/main/prolog.php");
$moduleId = 'esol.importexportexcel';
$moduleFilePrefix = 'esol_import_excel';
$moduleJsId = 'esol_importexcel';
$moduleJsId2 = str_replace('.', '_', $moduleId);
$moduleDemoExpiredFunc = $moduleJsId2.'_demo_expired';
$moduleShowDemoFunc = $moduleJsId2.'_show_demo';
CModule::IncludeModule('iblock');
CModule::IncludeModule($moduleId);
CJSCore::Init(array($moduleJsId));
IncludeModuleLangFile(__FILE__);
include_once(dirname(__FILE__).'/../install/demo.php');
if ($moduleDemoExpiredFunc()) {
require ($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_after.php");
$moduleShowDemoFunc();
require ($DOCUMENT_ROOT."/bitrix/modules/main/include/epilog_admin.php");
die();
}
$MODULE_RIGHT = $APPLICATION->GetGroupRight($moduleId);
if($MODULE_RIGHT < "W") $APPLICATION->AuthForm(GetMessage("ACCESS_DENIED"));
$oProfile = new CKDAImportProfile();
$arProfiles = $oProfile->GetList();
$logger = new CKDAImportLogger(false);
$sTableID = "tbl_kda_importexcel_view_event_stat";
$oSort = new CAdminSorting($sTableID, "ID", "DESC");
$lAdmin = new CAdminList($sTableID, $oSort);
$arFilterFields = array(
"find",
"find_profile_id",
"find_timestamp_x_1",
"find_timestamp_x_2",
"find_user_id"
);
$arFilter = array();
$lAdmin->InitFilter($arFilterFields);
InitSorting();
$find = $_REQUEST["find"];
$find_profile_id = $_REQUEST["find_profile_id"];
$find_timestamp_x_1 = $_REQUEST["find_timestamp_x_1"];
$find_timestamp_x_2 = $_REQUEST["find_timestamp_x_2"];
$find_user_id = $_REQUEST["find_user_id"];
if(strlen($find_profile_id) > 0) $arFilter['PROFILE_ID'] = $find_profile_id;
if(strlen($find_timestamp_x_1) > 0) $arFilter['>=DATE_START'] = $find_timestamp_x_1;
if(strlen($find_timestamp_x_2) > 0) $arFilter['<=DATE_START'] = $find_timestamp_x_2;
if(strlen($find_user_id) > 0) $arFilter['RUNNED_BY'] = $find_user_id;
/*if(($arID = $lAdmin->GroupAction()))
{
$removedCnt = 0;
if($_REQUEST['action_target']=='selected')
{
$arID = Array();
$dbResultList = \Bitrix\KdaImportexcel\ProfileExecTable::getList(array('filter'=>$arFilter, 'select'=>array('ID')));
while($arResult = $dbResultList->Fetch())
$arID[] = $arResult['ID'];
}
foreach ($arID as $ID)
{
if(strlen($ID) <= 0)
continue;
switch ($_REQUEST['action'])
{
case "delete":
$dbRes = \Bitrix\KdaImportexcel\ProfileExecTable::delete($ID);
if($dbRes->isSuccess())
{
$removedCnt++;
}
else
{
$error = '';
if($dbRes->getErrors())
{
foreach($dbRes->getErrors() as $errorObj)
{
$error .= $errorObj->getMessage().'. ';
}
}
if($error)
$lAdmin->AddGroupError($error, $ID);
else
$lAdmin->AddGroupError(GetMessage("KDA_IE_ERROR_DELETING_TYPE"), $ID);
}
break;
}
}
}*/
$usePageNavigation = true;
if (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel')
{
$usePageNavigation = false;
}
else
{
$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize(
$sTableID,
array('nPageSize' => 20, 'sNavID' => $APPLICATION->GetCurPage())
));
if ($navyParams['SHOW_ALL'])
{
$usePageNavigation = false;
}
else
{
$navyParams['PAGEN'] = (int)$navyParams['PAGEN'];
$navyParams['SIZEN'] = (int)$navyParams['SIZEN'];
}
}
$getListParams = array(
'order'=>array($by => $order),
'filter'=>$arFilter,
'select'=>array(
'ID',
'DATE_START',
'DATE_FINISH',
'PARAMS',
'PROFILE_ID',
'PROFILE_NAME'=>'PROFILE.NAME',
'RUNNED_BY_USER_LOGIN'=>'RUNNED_BY_USER.LOGIN',
'RUNNED_BY_USER_ID'=>'RUNNED_BY_USER.ID',
)
);
if ($usePageNavigation)
{
$getListParams['limit'] = $navyParams['SIZEN'];
$getListParams['offset'] = $navyParams['SIZEN']*($navyParams['PAGEN']-1);
}
if ($usePageNavigation)
{
$countQuery = new Query(\Bitrix\KdaImportexcel\ProfileExecTable::getEntity());
$countQuery->addSelect(new ExpressionField('CNT', 'COUNT(1)'));
$countQuery->setFilter($getListParams['filter']);
$totalCount = $countQuery->setLimit(null)->setOffset(null)->exec()->fetch();
unset($countQuery);
$totalCount = (int)$totalCount['CNT'];
if ($totalCount > 0)
{
$totalPages = ceil($totalCount/$navyParams['SIZEN']);
if ($navyParams['PAGEN'] > $totalPages)
$navyParams['PAGEN'] = $totalPages;
$getListParams['limit'] = $navyParams['SIZEN'];
$getListParams['offset'] = $navyParams['SIZEN']*($navyParams['PAGEN']-1);
}
else
{
$navyParams['PAGEN'] = 1;
$getListParams['limit'] = $navyParams['SIZEN'];
$getListParams['offset'] = 0;
}
}
$rsData = new CAdminResult(\Bitrix\KdaImportexcel\ProfileExecTable::getList($getListParams), $sTableID);
if ($usePageNavigation)
{
$rsData->NavStart($getListParams['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
$rsData->NavRecordCount = $totalCount;
$rsData->NavPageCount = $totalPages;
$rsData->NavPageNomer = $navyParams['PAGEN'];
}
else
{
$rsData->NavStart();
}
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("KDA_IE_EVENTLOG_LIST_PAGE")));
$arHeaders = array(
array(
"id" => "ID",
"content" => GetMessage("KDA_IE_EVENTLOG_ID"),
"sort" => "ID",
"default" => true,
"align" => "right",
),
array(
"id" => "PROFILE_ID",
"content" => GetMessage("KDA_IE_EVENTLOG_PROFILE_ID"),
"default" => true,
),
array(
"id" => "DATE_START",
"content" => GetMessage("KDA_IE_EVENTLOG_DATE_START"),
"sort" => "DATE_START",
"default" => true,
"align" => "right",
),
array(
"id" => "DATE_FINISH",
"content" => GetMessage("KDA_IE_EVENTLOG_DATE_FINISH"),
"sort" => "DATE_FINISH",
"default" => true,
"align" => "right",
),
array(
"id" => "RUNNED_BY",
"content" => GetMessage("KDA_IE_EVENTLOG_USER_ID"),
"default" => true,
),
array(
"id" => "PARAMS",
"content" => GetMessage("KDA_IE_EVENTLOG_PARAMS"),
"default" => true,
),
array(
"id" => "ADDED_LINE",
"content" => GetMessage("KDA_IE_EVENTLOG_RES_ELEMENT_ADDED_LINE"),
"default" => false,
),
array(
"id" => "UPDATED_LINE",
"content" => GetMessage("KDA_IE_EVENTLOG_RES_ELEMENT_UPDATED_LINE"),
"default" => false,
),
);
$lAdmin->AddHeaders($arHeaders);
$arParamKeys = array(
array(
'required' => true,
'fields' => array(
'total_line' => true,
'correct_line' => true,
'error_line' => true
)
),
array(
'required' => true,
'fields' => array(
'element_added_line' => true,
'element_updated_line' => true,
'element_changed_line' => true,
'element_removed_line' => false,
'killed_line' => false,
'zero_stock_line' => false,
'old_removed_line' => false
)
),
array(
'required' => false,
'fields' => array(
'sku_added_line' => true,
'sku_updated_line' => true,
'sku_changed_line' => true,
'offer_killed_line' => false,
'offer_zero_stock_line' => false,
'offer_old_removed_line' => false
)
),
array(
'required' => false,
'fields' => array(
'section_added_line' => true,
'section_updated_line' => true,
'section_deactivate_line' => false,
'section_remove_line' => false
)
),
);
$arUsersCache = array();
$arGroupsCache = array();
$arForumCache = array("FORUM" => array(), "TOPIC" => array(), "MESSAGE" => array());
$a_ID = $a_DATE_EXEC = $a_PROFILE_NAME = $a_RUNNED_BY_USER_ID = $a_RUNNED_BY_USER_LOGIN = $a_DATE_START = $a_DATE_END = $a_PARAMS = '';
while($db_res = $rsData->NavNext(true, "a_"))
{
$row =& $lAdmin->AddRow($a_ID, $db_res);
$row->AddViewField("ID", '<a href="/bitrix/admin/'.$moduleFilePrefix.'_event_log.php?lang='.LANG.'&find_profile_id='.$a_PROFILE_ID.'&find_exec_id='.$a_ID.'">'.$a_ID.'</a>');
$row->AddViewField("PROFILE_ID", '<a href="/bitrix/admin/'.$moduleFilePrefix.'.php?lang='.LANG.'&PROFILE_ID='.($a_PROFILE_ID - 1).'">'.$a_PROFILE_NAME.'</a>');
$row->AddViewField("DATE_START", $a_DATE_START);
$row->AddViewField("DATE_END", $a_DATE_END);
$row->AddViewField("RUNNED_BY", ($a_RUNNED_BY_USER_ID ? '[<a href="user_edit.php?lang='.LANG.'&ID='.$a_RUNNED_BY_USER_ID.'">'.$a_RUNNED_BY_USER_ID.'</a>] '.$a_RUNNED_BY_USER_LOGIN : ''));
$arParams = unserialize($db_res['PARAMS']);
if(!is_array($arParams)) $arParams = array();
$arGroupsParams = array();
if(!empty($arParams))
{
foreach($arParamKeys as $k=>$v)
{
$text = '';
$empty = true;
foreach($v['fields'] as $k2=>$v2)
{
if(strlen(GetMessage("KDA_IE_EVENTLOG_RES_".ToUpper($k2)))==0) continue;
if(array_key_exists($k2, $arParams) && $arParams[$k2] > 0)
{
$text .= GetMessage("KDA_IE_EVENTLOG_RES_".ToUpper($k2)).': '.$arParams[$k2].'<br>';
$empty = false;
}
elseif($v2) $text .= GetMessage("KDA_IE_EVENTLOG_RES_".ToUpper($k2)).': 0'.'<br>';
}
if(strlen($text) > 0 && ($v['required'] || !$empty)) $arGroupsParams[] = $text;
}
}
$row->AddViewField("PARAMS", implode('<br>', $arGroupsParams));
if(array_key_exists('element_added_line', $arParams)) $row->AddViewField("ADDED_LINE", $arParams['element_added_line']);
if(array_key_exists('element_updated_line', $arParams)) $row->AddViewField("UPDATED_LINE", $arParams['element_updated_line']);
/*$arActions = array();
$arActions[] = array("ICON"=>"delete", "TEXT"=>GetMessage("KDA_IE_LOG_RECORD_DELETE"), "ACTION"=>"if(confirm('".GetMessageJS('KDA_IE_LOG_RECORD_DELETE_CONFIRM')."')) ".$lAdmin->ActionDoGroup($a_ID, "delete"));
$row->AddActions($arActions);*/
}
$lAdmin->AddFooter(
array(
array(
"title" => GetMessage("MAIN_ADMIN_LIST_SELECTED"),
"value" => $rsData->SelectedRowsCount()
),
array(
"counter" => true,
"title" => GetMessage("MAIN_ADMIN_LIST_CHECKED"),
"value" => "0"
),
)
);
/*$lAdmin->AddGroupActionTable(
array(
"delete" => GetMessage("MAIN_ADMIN_LIST_DELETE"),
)
);*/
$aContext = array();
$lAdmin->AddAdminContextMenu($aContext);
$APPLICATION->SetTitle(GetMessage("KDA_IE_EVENTLOG_PAGE_TITLE"));
$lAdmin->CheckListMode();
require($_SERVER["DOCUMENT_ROOT"].BX_ROOT."/modules/main/include/prolog_admin_after.php");
if (!$moduleDemoExpiredFunc()) {
$moduleShowDemoFunc();
}
?>
<form name="find_form" method="GET" action="<?echo $APPLICATION->GetCurPage()?>?">
<input type="hidden" name="lang" value="<?echo LANG?>">
<?
$arFilterNames = array(
"find_timestamp_x" => GetMessage("KDA_IE_EVENTLOG_DATE_START"),
"find_user_id" => GetMessage("KDA_IE_EVENTLOG_USER_ID"),
);
$oFilter = new CAdminFilter($sTableID."_filter", $arFilterNames);
$oFilter->Begin();
?>
<tr>
<td><?echo GetMessage("KDA_IE_EVENTLOG_PROFILE_ID")?>:</td>
<td>
<select name="find_profile_id" >
<option value=""><?echo GetMessage("KDA_IE_ALL"); ?></option>
<?
foreach($arProfiles as $k=>$profile)
{
$key = $k + 1;
?><option value="<?echo $key;?>" <?if($find_profile_id==$key){echo 'selected';}?>><?echo $profile; ?></option><?
}
?>
</select>
</td>
</tr>
<tr>
<td><?echo GetMessage("KDA_IE_EVENTLOG_DATE_START")?>:</td>
<td><?echo CAdminCalendar::CalendarPeriod("find_timestamp_x_1", "find_timestamp_x_2", $find_timestamp_x_1, $find_timestamp_x_2, false, 15, true)?></td>
</tr>
<tr>
<td><?echo GetMessage("KDA_IE_EVENTLOG_USER_ID")?>:</td>
<td><input type="text" name="find_user_id" size="47" value="<?echo htmlspecialcharsbx($find_user_id)?>"></td>
</tr>
<?
$oFilter->Buttons(array("table_id"=>$sTableID, "url"=>$APPLICATION->GetCurPage(), "form"=>"find_form"));
$oFilter->End();
?>
</form>
<?
$lAdmin->DisplayList();
/*echo BeginNote();
echo GetMessage("KDA_IE_EVENTLOG_BOTTOM_NOTE");
echo EndNote();*/
require($_SERVER["DOCUMENT_ROOT"].BX_ROOT."/modules/main/include/epilog_admin.php");
?>