require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php"); use Bitrix\Main\Localization\Loc; use Bitrix\Sale\Exchange\EntityType; use Bitrix\Sale\Exchange\Logger; \Bitrix\Main\Loader::includeModule('sale'); IncludeModuleLangFile(__FILE__); require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/sale/prolog.php"); function getAdminUrlByType($typeId, $entityId, $ownerEntityId = null) { $r = ''; if(\Bitrix\Sale\Exchange\EntityType::isDefined($typeId)) { $urlAdmin = array( \Bitrix\Sale\Exchange\EntityType::ORDER=>"/bitrix/admin/sale_order_view.php?ID=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::SHIPMENT=>"/bitrix/admin/sale_order_shipment_edit.php?order_id=#OWNER_ENTITY_ID#&shipment_id=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::PAYMENT_CASH=>"/bitrix/admin/sale_order_payment_edit.php?order_id=#OWNER_ENTITY_ID#&payment_id=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::PAYMENT_CASH_LESS=>"/bitrix/admin/sale_order_payment_edit.php?order_id=#OWNER_ENTITY_ID#&payment_id=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::PAYMENT_CARD_TRANSACTION=>"/bitrix/admin/sale_order_payment_edit.php?order_id=#OWNER_ENTITY_ID#&payment_id=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::PAYMENT_CARD_TRANSACTION=>"/bitrix/admin/sale_order_payment_edit.php?order_id=#OWNER_ENTITY_ID#&payment_id=#ENTITY_ID#", \Bitrix\Sale\Exchange\EntityType::USER_PROFILE=>"/bitrix/admin/user_edit.php?ID=#ENTITY_ID#", ); $r = str_replace(array("#ENTITY_ID#", "#OWNER_ENTITY_ID#"),array($entityId, $ownerEntityId), $urlAdmin[$typeId]); } return $r; } $tableId = "tbl_sale_exchange_log"; $instance = \Bitrix\Main\Application::getInstance(); $context = $instance->getContext(); $request = $context->getRequest(); $oSort = new CAdminSorting($tableId, "ID", "asc"); $lAdmin = new CAdminList($tableId, $oSort); $arFilterFields = array( 'filter_entity_type_id', 'filter_entity_id_from', 'filter_entity_id_to', 'filter_parent_id_from', 'filter_parent_id_to', 'filter_order_id_from', 'filter_order_id_to', 'filter_direction_id', 'filter_xml_id', 'filter_date_insert_from', 'filter_date_insert_to', ); $lAdmin->InitFilter($arFilterFields); $filter = array(); if(isset($filter_entity_type_id) && is_array($filter_entity_type_id) && count($filter_entity_type_id) > 0) { $countFilter = count($filter_entity_type_id); for ($i = 0; $i < $countFilter; $i++) { $filter_entity_type_id[$i] = trim($filter_entity_type_id[$i]); if($filter_entity_type_id[$i] <> '') $filter["=ENTITY_TYPE_ID"][] = $filter_entity_type_id[$i]; } } if ($filter_date_insert_from <> '') { $filter[">=DATE_INSERT"] = trim($filter_date_insert_from); } elseif($set_filter!="Y" && $del_filter != "Y") { $filter_date_insert_from_FILTER_PERIOD = 'day'; $filter_date_insert_from_FILTER_DIRECTION = 'current'; $filter[">=DATE_INSERT"] = new \Bitrix\Main\Type\Date(); } if ($filter_date_insert_to <> '') { if($arDate = ParseDateTime($filter_date_insert_to, CSite::GetDateFormat("FULL", SITE_ID))) { if(mb_strlen($filter_date_insert_to) < 11) { $arDate["HH"] = 23; $arDate["MI"] = 59; $arDate["SS"] = 59; } $filter_date_insert_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"])); $filter["<=DATE_INSERT"] = $filter_date_insert_to; } else { $filter_date_insert_to = ""; } } if((int)($filter_entity_id_from)>0) $filter[">=ENTITY_ID"] = (int)($filter_entity_id_from); if((int)($filter_entity_id_to)>0) $filter["<=ENTITY_ID"] = (int)($filter_entity_id_to); if((int)($filter_parent_id_from)>0) $filter[">=PARENT_ID"] = (int)($filter_parent_id_from); if((int)($filter_parent_id_to)>0) $filter["<=PARENT_ID"] = (int)($filter_parent_id_to); if ($filter_xml_id <> '') $filter["=XML_ID"] = trim($filter_xml_id); if ($filter_direction_id <> '') $filter["=DIRECTION"] = trim($filter_direction_id); if ($del_filter !== 'Y') { $params = array( 'filter' => $filter ); } if (isset($by)) { $order = isset($order) ? $order : "ASC"; $params['order'] = array($by => $order); } $navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($tableId)); if ($navyParams['SHOW_ALL']) { $usePageNavigation = false; } else { $navyParams['PAGEN'] = (int)$navyParams['PAGEN']; $navyParams['SIZEN'] = (int)$navyParams['SIZEN']; } $totalPages = 0; $params['select']=array('*'); $headers = array( array("id"=>"ID", "content"=>Loc::getMessage("LOG_ID"), "sort"=>"ID", "default"=>true), array("id"=>"ENTITY_ID", "content"=>Loc::getMessage("LOG_ENTITY_ID"), "sort"=>"ENTITY_ID", "default"=>true), array("id"=>"ENTITY_TYPE_ID", "content"=>Loc::getMessage("LOG_ENTITY_TYPE_ID"), "sort"=>"ENTITY_TYPE_ID", "default"=>true), array("id"=>"PARENT_ID", "content"=>Loc::getMessage("LOG_PARENT_ID"), "sort"=>"PARENT_ID", "default"=>true), array("id"=>"OWNER_ENTITY_ID", "content"=>Loc::getMessage("LOG_OWNER_ENTITY_ID"), "sort"=>"OWNER_ENTITY_ID", "default"=>true), array("id"=>"ENTITY_DATE_UPDATE", "content"=>Loc::getMessage("LOG_ENTITY_DATE_UPDATE"), "sort"=>"ENTITY_DATE_UPDATE", "default"=>true), array("id"=>"XML_ID", "content"=>Loc::getMessage("LOG_XML_ID"), "sort"=>"XML_ID", "default"=>true), array("id"=>"MARKED", "content"=>Loc::getMessage("LOG_MARKED"), "sort"=>"MARKED", "default"=>true), array("id"=>"MESSAGE", "content"=>Loc::getMessage("LOG_MESSAGE"), "sort"=>"MESSAGE", "default"=>true), array("id"=>"DATE_INSERT", "content"=>Loc::getMessage("LOG_DATE_INSERT"), "sort"=>"DATE_INSERT", "default"=>true), ); $dbResultList = new CAdminResult((new Logger\Exchange(Logger\ProviderType::ONEC_NAME))->getList($params), $tableId); $dbResultList->NavStart(); $lAdmin->NavText($dbResultList->GetNavPrint(Loc::getMessage("group_admin_nav"))); $lAdmin->AddHeaders($headers); $visibleHeaders = $lAdmin->GetVisibleHeaderColumns(); while ($report = $dbResultList->Fetch()) { $row =& $lAdmin->AddRow($report['ID'], $report); $message = ''; if($report['MESSAGE']<>'') { $message .= '