if (substr($user, 0, $l) == "user_") {
$result = htmlspecialcharsbx(CBPHelper::ConvertUserToPrintableForm(intval(substr($user, $l))));
} else {
$result = $GLOBALS["__bwl1_ParseStringParameterTmp_arAllowableUserGroups"][$user];
}
} elseif ($matches[1] == "group") {
$result = $GLOBALS["__bwl1_ParseStringParameterTmp_arAllowableUserGroups"][$matches[2]];
} else {
$result = $matches[0];
}
return $result;
}
$arResult["GRID_ID"] = "bizproc_loggrid_" . $arWorkflowState["WORKFLOW_TEMPLATE_ID"];
$gridOptions = new CGridOptions($arResult["GRID_ID"]);
$gridColumns = $gridOptions->GetVisibleColumns();
$gridSort = $gridOptions->GetSorting(array("sort" => array("ID" => "desc")));
$arResult["SORT"] = $gridSort["sort"];
$arResult["FILTER"] = array();
if ($arParams["INLINE_MODE"] != "Y") {
$arResult["FILTER"] = array(array("id" => "MODIFIED", "name" => GetMessage("CBBWL_C_MODIFIED"), "type" => "date"), array("id" => "TYPE", "name" => GetMessage("CBBWL_C_TYPE"), "type" => "list", "items" => array("" => GetMessage("BPWC_WLC_NOT_SET"), 6 => GetMessage("BPABL_TYPE_7"), 5 => GetMessage("BPABL_TYPE_5"), 1 => GetMessage("BPABL_TYPE_1"), 2 => GetMessage("BPABL_TYPE_2"), 3 => GetMessage("BPABL_TYPE_3"), 4 => GetMessage("BPABL_TYPE_4"))), array("id" => "ADMIN_MODE", "name" => GetMessage("CBBWL_C_ADMIN_MODE"), "type" => "checkbox"));
}
$arResult["AdminMode"] = false;
$arFilter = array("WORKFLOW_ID" => $arWorkflowState["ID"]);
$gridFilter = $gridOptions->GetFilter($arResult["FILTER"]);
foreach ($gridFilter as $key => $value) {
if ($key == "ADMIN_MODE") {
$arResult["AdminMode"] = $value == "Y" ? true : false;
continue;
}
if (substr($key, -5) == "_from") {
$op = ">=";
protected function createDataExcel()
{
$obList = new CList($this->arIBlock["ID"]);
$gridOptions = new CGridOptions($this->arResult["GRID_ID"]);
$gridColumns = $gridOptions->GetVisibleColumns();
$gridSort = $gridOptions->GetSorting(array("sort" => array("name" => "asc")));
$this->arResult["ELEMENTS_HEADERS"] = array();
$arSelect = array("ID", "IBLOCK_ID");
$arProperties = array();
$this->arResult["FIELDS"] = $arListFields = $obList->GetFields();
foreach ($arListFields as $fieldId => $arField) {
if (!count($gridColumns) || in_array($fieldId, $gridColumns)) {
if (substr($fieldId, 0, 9) == "PROPERTY_") {
$arProperties[] = $fieldId;
} else {
$arSelect[] = $fieldId;
}
}
if ($fieldId == "CREATED_BY") {
$arSelect[] = "CREATED_USER_NAME";
}
if ($fieldId == "MODIFIED_BY") {
$arSelect[] = "USER_NAME";
}
$this->arResult["ELEMENTS_HEADERS"][$fieldId] = array("name" => htmlspecialcharsex($arField["NAME"]), "default" => true, "sort" => $arField["MULTIPLE"] == "Y" ? "" : $fieldId);
}
if (!count($gridColumns) || in_array("IBLOCK_SECTION_ID", $gridColumns)) {
$arSelect[] = "IBLOCK_SECTION_ID";
}
$this->arResult["ELEMENTS_HEADERS"]["IBLOCK_SECTION_ID"] = array("name" => Loc::getMessage("CC_BLL_COLUMN_SECTION"), "default" => true, "sort" => false);
/* FILTER */
$sections = array();
foreach ($this->arResult["LIST_SECTIONS"] as $id => $name) {
$sections[$id] = $name;
}
$this->arResult["FILTER"] = array(array("id" => "list_section_id", "type" => "list", "items" => $sections, "filtered" => $this->arResult["SECTION_ID"] !== false, "filter_value" => $this->arResult["SECTION_ID"], "value" => $this->arResult["SECTION_ID"]));
$i = 1;
$arFilterable = array();
$arDateFilter = array();
foreach ($arListFields as $fieldId => $arField) {
if ($arField["TYPE"] == "ACTIVE_FROM" || $arField["TYPE"] == "ACTIVE_TO") {
$this->arResult["FILTER"][$i] = array("id" => "DATE_" . $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "date");
$arFilterable["DATE_" . $fieldId] = "";
$arDateFilter["DATE_" . $fieldId] = true;
} elseif ($arField["TYPE"] == "DATE_CREATE" || $arField["TYPE"] == "TIMESTAMP_X") {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "date");
$arFilterable[$fieldId] = "";
$arDateFilter[$fieldId] = true;
} elseif (is_array($arField["PROPERTY_USER_TYPE"]) && array_key_exists("GetPublicFilterHTML", $arField["PROPERTY_USER_TYPE"])) {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "custom", "enable_settings" => false, "value" => call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicFilterHTML"], array($arField, array("VALUE" => $fieldId, "FORM_NAME" => "filter_" . $this->arResult["GRID_ID"], "GRID_ID" => $this->arResult["GRID_ID"]))));
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "SORT" || $arField["TYPE"] == "N") {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "number");
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "G") {
$items = array();
$prop_secs = CIBlockSection::GetList(array("left_margin" => "asc"), array("IBLOCK_ID" => $arField["LINK_IBLOCK_ID"]));
while ($ar_sec = $prop_secs->Fetch()) {
$items[$ar_sec["ID"]] = str_repeat(". ", $ar_sec["DEPTH_LEVEL"] - 1) . $ar_sec["NAME"];
}
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "list", "items" => $items, "params" => array("size" => 5, "multiple" => "multiple"), "valign" => "top");
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "E") {
//Should be handled in template
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "E", "value" => $arField);
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "L") {
$items = array();
$propEnums = CIBlockProperty::GetPropertyEnum($arField["ID"]);
while ($arEnum = $propEnums->Fetch()) {
$items[$arEnum["ID"]] = $arEnum["VALUE"];
}
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "list", "items" => $items, "params" => array("size" => 5, "multiple" => "multiple"), "valign" => "top");
$arFilterable[$fieldId] = "";
} elseif (in_array($arField["TYPE"], array("S", "S:HTML", "NAME", "DETAIL_TEXT", "PREVIEW_TEXT"))) {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]));
$arFilterable[$fieldId] = "?";
} else {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]));
$arFilterable[$fieldId] = "";
}
$i++;
}
$arFilter = array();
$gridFilter = $gridOptions->GetFilter($this->arResult["FILTER"]);
foreach ($gridFilter as $key => $value) {
if (substr($key, -5) == "_from") {
$op = ">=";
$newKey = substr($key, 0, -5);
} elseif (substr($key, -3) == "_to") {
$op = "<=";
$newKey = substr($key, 0, -3);
if (array_key_exists($newKey, $arDateFilter)) {
if (!preg_match("/\\d\\d:\\d\\d:\\d\\d\$/", $value)) {
$value .= " 23:59:59";
}
}
} else {
$op = "";
$newKey = $key;
}
if (array_key_exists($newKey, $arFilterable)) {
if ($op == "") {
$op = $arFilterable[$newKey];
}
$arFilter[$op . $newKey] = $value;
}
}
$arFilter["IBLOCK_ID"] = $this->arIBlock["ID"];
if (!$this->arResult["ANY_SECTION"]) {
$arFilter["SECTION_ID"] = $this->arResult["SECTION_ID"];
}
$rsElements = CIBlockElement::GetList($gridSort["sort"], $arFilter, false, false, $arSelect);
$this->arResult["EXCEL_COLUMN_NAME"] = array();
$this->arResult["EXCEL_CELL_VALUE"] = array();
$count = 0;
while ($obElement = $rsElements->GetNextElement()) {
$data = $obElement->GetFields();
$propertyArray = $obElement->GetProperties();
if (!empty($arProperties)) {
foreach ($propertyArray as $arProp) {
$fieldId = "PROPERTY_" . $arProp["ID"];
if (in_array($fieldId, $arProperties)) {
$arField = $this->arResult["FIELDS"][$fieldId];
if (is_array($arField["PROPERTY_USER_TYPE"]) && is_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"])) {
if (is_array($arProp["~VALUE"])) {
foreach ($arProp["~VALUE"] as $propValue) {
$data[$fieldId][] = call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"], array($arField, array("VALUE" => $propValue), array()));
}
} else {
$data[$fieldId] = call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"], array($arField, array("VALUE" => $arProp["~VALUE"]), array()));
}
} elseif ($arField["PROPERTY_TYPE"] == "L") {
$data[$fieldId] = htmlspecialcharsex($arProp["VALUE_ENUM"]);
} elseif ($arField["PROPERTY_TYPE"] == "F") {
$files = is_array($arProp["VALUE"]) ? $arProp["VALUE"] : array($arProp["VALUE"]);
foreach ($files as $file) {
$value = CFile::MakeFileArray($file);
$data[$fieldId] .= $value["name"] . "\r\n";
}
} else {
$data[$fieldId] = htmlspecialcharsex($arProp["VALUE"]);
}
}
}
if (!empty($data["IBLOCK_SECTION_ID"])) {
if (array_key_exists($data["IBLOCK_SECTION_ID"], $this->arResult["SECTIONS"])) {
$data["IBLOCK_SECTION_ID"] = $this->arResult["SECTIONS"][$data["IBLOCK_SECTION_ID"]]["NAME"];
}
}
if (in_array("BIZPROC", $gridColumns)) {
$data["BIZPROC"] = $this->getArrayBizproc($data);
}
}
if (isset($data["CREATED_BY"])) {
$data["CREATED_BY"] = "[" . $data["CREATED_BY"] . "] " . $data["CREATED_USER_NAME"];
}
if (isset($data["MODIFIED_BY"])) {
$data["MODIFIED_BY"] = "[" . $data["MODIFIED_BY"] . "] " . $data["USER_NAME"];
}
if (isset($data["ACTIVE_FROM"])) {
$data['ACTIVE_FROM'] = FormatDateFromDB($data['ACTIVE_FROM']);
}
if (isset($data["ACTIVE_TO"])) {
$data['ACTIVE_TO'] = FormatDateFromDB($data['ACTIVE_TO']);
}
if (isset($data["DATE_CREATE"])) {
$data['DATE_CREATE'] = FormatDateFromDB($data['DATE_CREATE']);
}
if (isset($data["TIMESTAMP_X"])) {
$data['TIMESTAMP_X'] = FormatDateFromDB($data['TIMESTAMP_X']);
}
foreach ($gridColumns as $position => $id) {
$this->arResult["EXCEL_CELL_VALUE"][$count][$position] = is_array($data[$id]) ? implode('/', $data[$id]) : $data[$id];
$this->arResult["EXCEL_COLUMN_NAME"][$position] = $this->arResult["ELEMENTS_HEADERS"][$id]["name"];
}
$count++;
}
}
//Show error message if required
if ($_SERVER['REQUEST_METHOD'] === 'GET' && isset($_GET['error'])) {
if ($_GET['error'] === $errorID) {
if (!isset($_SESSION[$errorID])) {
LocalRedirect(CHTTP::urlDeleteParams($APPLICATION->GetCurPage(), array('error')));
}
$strError = strval($_SESSION[$errorID]);
unset($_SESSION[$errorID]);
if ($strError !== '') {
ShowError(htmlspecialcharsbx($strError));
}
}
}
$grid_options = new CGridOptions($arResult["GRID_ID"]);
$grid_columns = $grid_options->GetVisibleColumns();
$grid_sort = $grid_options->GetSorting(array("sort" => array("name" => "asc")));
if ($arResult["IBLOCK"]["BIZPROC"] == "Y" && CModule::IncludeModule('bizproc')) {
$arDocumentTemplates = CBPDocument::GetWorkflowTemplatesForDocumentType(BizProcDocument::generateDocumentComplexType($arParams["IBLOCK_TYPE_ID"], $arResult["IBLOCK_ID"]));
$arResult["BIZPROC"] = "Y";
} else {
$arDocumentTemplates = array();
$arResult["BIZPROC"] = "N";
}
/* FIELDS */
$arResult["ELEMENTS_HEADERS"] = array();
$arSelect = array("ID", "IBLOCK_ID");
$arProperties = array();
$arResult["FIELDS"] = $arListFields = $obList->GetFields();
foreach ($arListFields as $FIELD_ID => $arField) {
if (!count($grid_columns) || in_array($FIELD_ID, $grid_columns)) {
if (substr($FIELD_ID, 0, 9) == "PROPERTY_") {
protected function createDataExcel()
{
$obList = new CList($this->arIBlock["ID"]);
$gridOptions = new CGridOptions($this->arResult["GRID_ID"]);
$gridColumns = $gridOptions->GetVisibleColumns();
$gridSort = $gridOptions->GetSorting(array("sort" => array("name" => "asc")));
$this->arResult["ELEMENTS_HEADERS"] = array();
$arSelect = array("ID", "IBLOCK_ID");
$arProperties = array();
$this->arResult["FIELDS"] = $arListFields = $obList->GetFields();
foreach ($arListFields as $fieldId => $arField) {
if (!count($gridColumns) || in_array($fieldId, $gridColumns)) {
if (substr($fieldId, 0, 9) == "PROPERTY_") {
$arProperties[] = $fieldId;
} else {
$arSelect[] = $fieldId;
}
}
if ($fieldId == "CREATED_BY") {
$arSelect[] = "CREATED_USER_NAME";
}
if ($fieldId == "MODIFIED_BY") {
$arSelect[] = "USER_NAME";
}
$this->arResult["ELEMENTS_HEADERS"][$fieldId] = $arField["NAME"];
}
if (!count($gridColumns) || in_array("IBLOCK_SECTION_ID", $gridColumns)) {
$arSelect[] = "IBLOCK_SECTION_ID";
}
$this->arResult["ELEMENTS_HEADERS"]["IBLOCK_SECTION_ID"] = Loc::getMessage("CC_BLL_COLUMN_SECTION");
/* FILTER */
$sections = array();
foreach ($this->arResult["LIST_SECTIONS"] as $id => $name) {
$sections[$id] = $name;
}
$this->arResult["FILTER"] = array(array("id" => "list_section_id", "type" => "list", "items" => $sections, "filtered" => $this->arResult["SECTION_ID"] !== false, "filter_value" => $this->arResult["SECTION_ID"], "value" => $this->arResult["SECTION_ID"]));
$i = 1;
$arFilterable = array();
$arCustomFilter = array();
$arDateFilter = array();
foreach ($arListFields as $fieldId => $arField) {
if ($arField["TYPE"] == "ACTIVE_FROM" || $arField["TYPE"] == "ACTIVE_TO") {
$this->arResult["FILTER"][$i] = array("id" => "DATE_" . $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "date");
$arFilterable["DATE_" . $fieldId] = "";
$arDateFilter["DATE_" . $fieldId] = true;
} elseif ($arField["TYPE"] == "DATE_CREATE" || $arField["TYPE"] == "TIMESTAMP_X") {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "date");
$arFilterable[$fieldId] = "";
$arDateFilter[$fieldId] = true;
} elseif (is_array($arField["PROPERTY_USER_TYPE"]) && array_key_exists("GetPublicFilterHTML", $arField["PROPERTY_USER_TYPE"])) {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "custom", "fieldsType" => $arField["TYPE"], "enable_settings" => false, "value" => call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicFilterHTML"], array($arField, array("VALUE" => $fieldId, "FORM_NAME" => "filter_" . $this->arResult["GRID_ID"], "GRID_ID" => $this->arResult["GRID_ID"]))));
$arFilterable[$fieldId] = "";
if (array_key_exists("AddFilterFields", $arField["PROPERTY_USER_TYPE"])) {
$arCustomFilter[$fieldId] = array("callback" => $arField["PROPERTY_USER_TYPE"]["AddFilterFields"], "filter" => &$this->arResult["FILTER"][$i]);
}
} elseif ($arField["TYPE"] == "SORT" || $arField["TYPE"] == "N") {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "number");
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "G") {
$items = array();
$prop_secs = CIBlockSection::GetList(array("left_margin" => "asc"), array("IBLOCK_ID" => $arField["LINK_IBLOCK_ID"]));
while ($ar_sec = $prop_secs->Fetch()) {
$items[$ar_sec["ID"]] = str_repeat(". ", $ar_sec["DEPTH_LEVEL"] - 1) . $ar_sec["NAME"];
}
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "list", "items" => $items, "params" => array("size" => 5, "multiple" => "multiple"), "valign" => "top");
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "E") {
//Should be handled in template
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "E", "value" => $arField);
$arFilterable[$fieldId] = "";
} elseif ($arField["TYPE"] == "L") {
$items = array();
$propEnums = CIBlockProperty::GetPropertyEnum($arField["ID"]);
while ($arEnum = $propEnums->Fetch()) {
$items[$arEnum["ID"]] = $arEnum["VALUE"];
}
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "type" => "list", "items" => $items, "params" => array("size" => 5, "multiple" => "multiple"), "valign" => "top");
$arFilterable[$fieldId] = "";
} elseif (in_array($arField["TYPE"], array("S", "S:HTML", "NAME", "DETAIL_TEXT", "PREVIEW_TEXT"))) {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]));
$arFilterable[$fieldId] = "?";
} else {
$this->arResult["FILTER"][$i] = array("id" => $fieldId, "name" => htmlspecialcharsex($arField["NAME"]), "fieldsType" => $arField["TYPE"]);
$arFilterable[$fieldId] = "";
}
$i++;
}
$arFilter = array();
$gridFilter = $gridOptions->GetFilter($this->arResult["FILTER"]);
foreach ($gridFilter as $key => $value) {
if (substr($key, -5) == "_from") {
$op = ">=";
$newKey = substr($key, 0, -5);
} elseif (substr($key, -3) == "_to") {
$op = "<=";
$newKey = substr($key, 0, -3);
if (array_key_exists($newKey, $arDateFilter)) {
if (!preg_match("/\\d\\d:\\d\\d:\\d\\d\$/", $value)) {
$value .= " 23:59:59";
}
}
} else {
$op = "";
$newKey = $key;
}
if (array_key_exists($newKey, $arFilterable)) {
if ($op == "") {
$op = $arFilterable[$newKey];
}
$arFilter[$op . $newKey] = $value;
}
}
foreach ($arCustomFilter as $fieldId => $arCallback) {
$filtered = false;
call_user_func_array($arCallback["callback"], array($arListFields[$fieldId], array("VALUE" => $fieldId, "GRID_ID" => $this->arResult["GRID_ID"]), &$arFilter, &$filtered));
}
$arFilter["IBLOCK_ID"] = $this->arIBlock["ID"];
$arFilter["CHECK_PERMISSIONS"] = $this->listsPerm >= CListPermissions::CAN_READ ? "N" : "Y";
if (!$this->arResult["ANY_SECTION"]) {
$arFilter["SECTION_ID"] = $this->arResult["SECTION_ID"];
}
$rsElements = CIBlockElement::GetList($gridSort["sort"], $arFilter, false, false, $arSelect);
$this->arResult["EXCEL_COLUMN_NAME"] = array();
$this->arResult["EXCEL_CELL_VALUE"] = array();
$count = 0;
$comments = false;
if (in_array("COMMENTS", $gridColumns) && CModule::includeModule("forum")) {
$comments = true;
}
while ($obElement = $rsElements->GetNextElement()) {
$data = $obElement->GetFields();
$propertyArray = $obElement->GetProperties();
if (!empty($arProperties)) {
foreach ($propertyArray as $arProp) {
$fieldId = "PROPERTY_" . $arProp["ID"];
if (in_array($fieldId, $arProperties)) {
$arField = $this->arResult["FIELDS"][$fieldId];
if (is_array($arField["PROPERTY_USER_TYPE"]) && is_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"])) {
if ($arProp["USER_TYPE"] == "map_yandex") {
$data[$fieldId] = !empty($arProp["VALUE"]) ? $arProp["VALUE"] : '';
continue;
} elseif ($arProp["USER_TYPE"] == "DiskFile") {
if (!empty($arProp["VALUE"]) && $this->arResult["DISK"]) {
$listValue = current($arProp["VALUE"]);
if (!is_array($listValue)) {
$listValue = $arProp["VALUE"];
}
$number = 0;
$countFiles = count($listValue);
foreach ($listValue as $idAttached) {
$number++;
list($type, $realId) = Bitrix\Disk\Uf\FileUserType::detectType($idAttached);
if ($type == Bitrix\Disk\Uf\FileUserType::TYPE_ALREADY_ATTACHED) {
$attachedModel = Bitrix\Disk\AttachedObject::loadById($realId);
if (!$attachedModel) {
continue;
}
$fileModel = Bitrix\Disk\File::loadById($attachedModel->getObjectId(), array('STORAGE'));
if (!$fileModel) {
continue;
}
$data[$fieldId] .= $fileModel->getName();
$data[$fieldId] .= $countFiles != $number ? ', ' : '';
}
}
}
continue;
}
if (is_array($arProp["~VALUE"])) {
foreach ($arProp["~VALUE"] as $propValue) {
$data[$fieldId][] = call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"], array($arField, array("VALUE" => $propValue), array()));
}
} else {
$data[$fieldId] = call_user_func_array($arField["PROPERTY_USER_TYPE"]["GetPublicViewHTML"], array($arField, array("VALUE" => $arProp["~VALUE"]), array()));
}
} elseif ($arField["PROPERTY_TYPE"] == "E") {
if (empty($arProp['VALUE'])) {
continue;
}
if (!is_array($arProp['VALUE'])) {
$arProp['VALUE'] = array($arProp['VALUE']);
}
$elementQuery = CIBlockElement::getList(array(), array("=ID" => $arProp['VALUE']), false, false, array("NAME"));
while ($element = $elementQuery->fetch()) {
$data[$fieldId][] = $element['NAME'];
}
} elseif ($arField["PROPERTY_TYPE"] == "G") {
if (empty($arProp['VALUE'])) {
continue;
}
if (!is_array($arProp['VALUE'])) {
$arProp['VALUE'] = array($arProp['VALUE']);
}
$sectionQuery = CIBlockSection::getList(array(), array("=ID" => $arProp['VALUE']));
while ($section = $sectionQuery->fetch()) {
$data[$fieldId][] = $section['NAME'];
}
} elseif ($arField["PROPERTY_TYPE"] == "L") {
$data[$fieldId] = htmlspecialcharsex($arProp["VALUE_ENUM"]);
} elseif ($arField["PROPERTY_TYPE"] == "F") {
$files = is_array($arProp["VALUE"]) ? $arProp["VALUE"] : array($arProp["VALUE"]);
$number = 1;
$countFiles = count($files);
foreach ($files as $file) {
$value = CFile::MakeFileArray($file);
$data[$fieldId] .= $value["name"];
$data[$fieldId] .= $countFiles != $number ? ', ' : '';
$number++;
}
} else {
$data[$fieldId] = htmlspecialcharsex($arProp["VALUE"]);
}
}
}
if (!empty($data["IBLOCK_SECTION_ID"])) {
if (array_key_exists($data["IBLOCK_SECTION_ID"], $this->arResult["SECTIONS"])) {
$data["IBLOCK_SECTION_ID"] = $this->arResult["SECTIONS"][$data["IBLOCK_SECTION_ID"]]["NAME"];
}
}
if (in_array("BIZPROC", $gridColumns)) {
$data["BIZPROC"] = $this->getArrayBizproc($data);
}
}
if ($comments) {
$countComments = $this->getCommentsProcess($data["ID"]);
}
if (isset($data["CREATED_BY"])) {
$data["CREATED_BY"] = "[" . $data["CREATED_BY"] . "] " . $data["CREATED_USER_NAME"];
}
if (isset($data["MODIFIED_BY"])) {
$data["MODIFIED_BY"] = "[" . $data["MODIFIED_BY"] . "] " . $data["USER_NAME"];
}
if (isset($data["ACTIVE_FROM"])) {
$data['ACTIVE_FROM'] = FormatDateFromDB($data['ACTIVE_FROM']);
}
if (isset($data["ACTIVE_TO"])) {
$data['ACTIVE_TO'] = FormatDateFromDB($data['ACTIVE_TO']);
}
if (isset($data["DATE_CREATE"])) {
$data['DATE_CREATE'] = FormatDateFromDB($data['DATE_CREATE']);
}
if (isset($data["TIMESTAMP_X"])) {
$data['TIMESTAMP_X'] = FormatDateFromDB($data['TIMESTAMP_X']);
}
foreach ($gridColumns as $position => $id) {
if ($id == "COMMENTS") {
if ($comments) {
$data[$id] = $countComments;
} else {
continue;
}
}
$this->arResult["EXCEL_CELL_VALUE"][$count][$position] = is_array($data[$id]) ? implode('/', $data[$id]) : $data[$id];
$this->arResult["EXCEL_COLUMN_NAME"][$position] = $this->arResult["ELEMENTS_HEADERS"][$id];
}
$count++;
}
}
$arResult["FILTER"] = array(
array("id"=>"ID", "name"=>GetMessage('SUP_F_ID')),
array("id"=>"LAMP", "name"=>GetMessage('SUP_F_LAMP'), "type"=>"list", "params"=>array("size"=>4, "multiple"=>"multiple"), "valign"=>"top", "items"=>array(
'red' => GetMessage('SUP_RED'), 'green' => GetMessage('SUP_GREEN'), 'grey' => GetMessage('SUP_GREY')
)),
array("id"=>"CLOSE", "name"=>GetMessage('SUP_F_CLOSE'), "type" => "list", "items" => array(
"" => GetMessage('SUP_ALL'), 'Y' => GetMessage('SUP_CLOSED'),'N' => GetMessage('SUP_OPENED')
)),
array("id"=>"MESSAGE", "name"=>GetMessage('SUP_F_MESSAGE_TITLE'))
);
$arParams["TICKETS_PER_PAGE"] = (intval($arParams["TICKETS_PER_PAGE"]) <= 0 ? 50 : intval($arParams["TICKETS_PER_PAGE"]));
$grid_options = new CGridOptions($arResult["GRID_ID"]);
$aSort = $grid_options->GetSorting(array("sort"=>array("id"=>"desc"), "vars"=>array("by"=>"by", "order"=>"order")));
$aNav = $grid_options->GetNavParams(array("nPageSize"=>$arParams["TICKETS_PER_PAGE"]));
$aSortArg = each($aSort["sort"]);
$aFilter = $grid_options->GetFilter($arResult["FILTER"]);
$aSortVal = $aSort['sort'];
$sort_order = current($aSortVal);
$sort_by = key($aSortVal);
if (strlen($arParams["SITE_ID"]) > 0)
$aFilter["LID"] = $arParams["SITE_ID"];
$rsTickets = CTicket::GetList(
$sort_by,
$sort_order,
} else {
$notifyEmail->deleteIdea($_REQUEST["ENTITY_CODE"]);
}
}
}
LocalRedirect($APPLICATION->GetCurPageParam("", array("ACTION", "ID", "ENTITY_TYPE", "ENTITY_CODE", "sessid")));
break;
}
}
$arResult = array("USER_ID" => $USER->GetID(), "IDEA" => array(), "SUBSCRIBE" => array(), "IDEA_STATUS" => array(), "GRID" => array());
//Get Idea subscribtion
if ($arResult["USER_ID"] > 0) {
//InitGrid
$GridOptions = new CGridOptions($arResult["GRID_ID"]);
//Grid Sort
$arSort = $GridOptions->GetSorting(array("sort" => array("DATE_PUBLISH" => "DESC"), "vars" => array("by" => "by", "order" => "order")));
$arResult["GRID"]["SORT"] = $arSort["sort"];
$arResult["GRID"]["SORT_VARS"] = $arSort["vars"];
$arNav = $GridOptions->GetNavParams(array("nPageSize" => 25));
$db_res = \Bitrix\Idea\NotifyEmailTable::getList(array('filter' => array("USER_ID" => $arResult["USER_ID"]), 'select' => array("ID" => "RUNTIME_ID", "SUBSCRIBE_TYPE", "ENTITY_TYPE", "ENTITY_CODE", "CATEGORY_NAME" => "ASCENDED_CATEGORIES.NAME"), 'order' => array("ENTITY_TYPE" => "ASC", "ENTITY_CODE" => "ASC"), 'runtime' => array(new \Bitrix\Main\Entity\ExpressionField('RUNTIME_ID', \Bitrix\Main\Application::getConnection()->getSqlHelper()->getConcatFunction("CASE " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_IDEA . "' AND %s='' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_ALL . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_IDEA . "' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_IDEA_COMMENT . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' AND %s='' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' THEN '" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' " . "ELSE 'UNK' END", "%s"), array("ENTITY_TYPE", "ENTITY_CODE", "ENTITY_TYPE", "ENTITY_TYPE", "ENTITY_CODE", "ENTITY_TYPE", "ENTITY_CODE")))));
$oIdeaSubscribe = new CDBResult($db_res);
$oIdeaSubscribe->NavStart($arNav["nPageSize"], false);
//Select Subscribe
$arBlogPostId = array();
while ($r = $oIdeaSubscribe->Fetch()) {
$arResult["SUBSCRIBE"][] = $r["ID"];
if ($r["ID"] == CIdeaManagmentEmailNotify::SUBSCRIBE_ALL) {
$arResult["IDEA"] = array(CIdeaManagmentEmailNotify::SUBSCRIBE_ALL => $r + array("TITLE" => GetMessage("IDEA_SUBSCRIBE_ALL_SUBSCRIBED"), "ID" => CIdeaManagmentEmailNotify::SUBSCRIBE_ALL)) + $arResult["IDEA"];
} else {
if ($r["ID"] == CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA) {
$arResult["IDEA"] = array(CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA => $r + array("TITLE" => GetMessage("IDEA_SUBSCRIBE_ALL_IDEA_SUBSCRIBED"), "ID" => CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA)) + $arResult["IDEA"];
$res = CFileInput::Show('NO_FIELDS[' . $property_value_id . ']', $property_value, array('IMAGE' => 'Y', 'PATH' => false, 'FILE_SIZE' => false, 'DIMENSIONS' => false, 'IMAGE_POPUP' => false, 'MAX_SIZE' => array('W' => 50, 'H' => 50), 'MIN_SIZE' => array('W' => 1, 'H' => 1)), array('upload' => false, 'medialib' => false, 'file_dialog' => false, 'cloud' => false, 'del' => false, 'description' => false));
$res = preg_replace('!<script[^>]*>.*</script>!isU', '', $res);
return $res;
}
/*$arSKUProps = $arResult['SKU_PROPS'];*/
$arFilter = $arResult['FILTER'];
$arHeaders = $arResult['HEADERS'];
$arPrices = $arResult['PRICES'];
$tableId = $arResult['TABLE_ID'];
$leftContainerId = $tableId . '_left_container';
$splitterBtnId = $tableId . '_splitter_btn';
$jsEventsManagerId = isset($_GET['JS_EVENTS_MANAGER_ID']) ? strval($_GET['JS_EVENTS_MANAGER_ID']) : '';
// START TEMPLATE
// Grid options
$gridOptions = new CGridOptions($arResult['TABLE_ID']);
$arSort = $gridOptions->GetSorting(array('sort' => array('name' => 'asc'), 'vars' => array('by' => 'by', 'order' => 'order')));
$arResult['SORT'] = $arSort['sort'];
$arResult['SORT_VARS'] = $arSort['SORT']['vars'];
unset($arSort);
$arResult['ROWS_COUNT'] = $arResult['DB_RESULT_LIST'] instanceof \CDBResult ? $arResult['DB_RESULT_LIST']->SelectedRowsCount() : 0;
$arResult['GRID_DATA'] = array();
foreach ($arResult['PRODUCTS'] as $productId => $arItems) {
$arActions = array();
if ($arItems['TYPE'] === 'S') {
$arActions[] = array('ICONCLASS' => 'select', 'TEXT' => GetMessage('SPS_SELECT'), 'ONCLICK' => $tableId . '_helper.onSectionChange(' . $arItems['ID'] . ',"' . CUtil::JSEscape($arItems['NAME']) . '");', 'DEFAULT' => true);
} else {
$params = array('id' => $productId, 'type' => $arItems['TYPE']);
$arActions[] = array('TEXT' => GetMessage('SPS_SELECT'), 'ONCLICK' => $tableId . '_helper.SelEl(' . CUtil::PhpToJSObject($params) . ', this);', 'DEFAULT' => true);
}
$gridDataRecord = array('id' => $arItems['TYPE'] . $arItems['ID'], 'actions' => $arActions, 'data' => $arItems, 'editable' => false, 'columns' => array('NAME' => '<a class="crm-gds-item' . ($arItems['TYPE'] === 'S' ? ' crm-gds-item-section' : ' crm-gds-item-gds') . '">' . $arItems['NAME'] . '</a>', 'ACTIVE' => $arItems['ACTIVE'] === 'Y' ? GetMEssage('SPS_PRODUCT_ACTIVE') : GetMEssage('SPS_PRODUCT_NO_ACTIVE'), 'PREVIEW_PICTURE' => getImageField('NO_FIELDS[' . $arItems['ID'] . '][PREVIEW_PICTURE]', $arItems['PREVIEW_PICTURE']), 'DETAIL_PICTURE' => getImageField('NO_FIELDS[' . $arItems['ID'] . '][DETAIL_PICTURE]', $arItems['DETAIL_PICTURE'])));
// Product properties
$arTemplates = $cache->GetVars();
} else {
$db_res = CBPWorkflowTemplateLoader::GetList(array(), array("DOCUMENT_TYPE" => $arParams["DOCUMENT_TYPE"]), false, false, array("ID", "AUTO_EXECUTE", "NAME", "DESCRIPTION", "MODIFIED", "USER_ID", "PARAMETERS", "TEMPLATE"));
while ($arWorkflowTemplate = $db_res->GetNext()) {
$arTemplates[$arWorkflowTemplate["ID"]] = $arWorkflowTemplate;
}
if ($arParams["CACHE_TIME"] > 0) {
$cache->StartDataCache($arParams["CACHE_TIME"], $cache_id, $cache_path_main);
$cache->EndDataCache($arTemplates);
}
}
}
$arParams["TEMPLATES"] = $arTemplates;
}
$grid_options = new CGridOptions($arParams["GRID_ID"]);
$gridSort = $grid_options->GetSorting(array("sort" => array("NAME" => "desc")));
global $by, $order;
if (is_array($gridSort["sort"])) {
$by = key($gridSort["sort"]);
$order = $gridSort["sort"][$by];
}
$arFilter = array();
if (isset($_REQUEST["clear_filter"]) && $_REQUEST["clear_filter"] == "Y") {
$urlParams = array();
foreach ($arResult["FILTER"] as $id => $arFilter) {
if ($arFilter['id'] == 'FILE_SIZE') {
$urlParams[] = $arFilter["id"] . "_from";
$urlParams[] = $arFilter["id"] . "_to";
$urlParams[] = $arFilter["id"] . "_multiply";
} elseif ($arFilter["type"] == "user") {
$urlParams[] = $arFilter["id"];
/********************************************************************
Default falues
********************************************************************/
$arResult["NAV_STRING"] = "";
$arResult["NAV_RESULT"] = "";
$arResult["TEMPLATES"] = array();
$arResult["GRID_TEMPLATES"] = array();
/********************************************************************
/Default falues
********************************************************************/
/********************************************************************
Data
********************************************************************/
$arResult["GRID_ID"] = "bizproc_wflist_" . $arParams["MODULE_ID"];
$gridOptions = new CGridOptions($arResult["GRID_ID"]);
$gridSort = $gridOptions->GetSorting(array("sort" => array("NAME" => "ASC")));
$db_res = CBPWorkflowTemplateLoader::GetList($gridSort["sort"], array("DOCUMENT_TYPE" => $documentType), false, false, array("ID", "NAME", "DESCRIPTION", "MODIFIED", "USER_ID", "AUTO_EXECUTE", "USER_NAME", "USER_LAST_NAME", "USER_LOGIN", "ACTIVE", "USER_SECOND_NAME"));
if ($db_res) {
$db_res->NavStart(25, false);
$arResult["NAV_RESULT"] = $db_res;
$arResult["NAV_STRING"] = $db_res->GetPageNavStringEx($navComponentObject, GetMessage("BPATT_NAV"), "");
$adminPage = $APPLICATION->GetCurPageParam('back_url=' . urlencode($back_url) . '&action=delete&' . bitrix_sessid_get(), array('back_url', 'action', 'ID', 'sessid'));
while ($res = $db_res->GetNext()) {
$res["URL"] = array("EDIT" => CComponentEngine::MakePathFromTemplate($arParams["~EDIT_URL"], array("ID" => $res["ID"], "MODULE_ID" => $arParams["MODULE_ID"], "ENTITY" => $arParams["ENTITY"], "DOCUMENT_ID" => $arParams["DOCUMENT_ID"])), "DELETE" => $adminPage . "&ID=" . $res["ID"]);
if (isset($arParams["~EDIT_VARS_URL"]) && strlen($arParams["~EDIT_VARS_URL"]) > 0) {
$res["URL"]["VARS"] = CComponentEngine::MakePathFromTemplate($arParams["~EDIT_VARS_URL"], array("ID" => $res["ID"], "MODULE_ID" => $arParams["MODULE_ID"], "ENTITY" => $arParams["ENTITY"], "DOCUMENT_ID" => $arParams["DOCUMENT_ID"]));
}
if (isset($arParams["~EDIT_CONSTANTS_URL"]) && strlen($arParams["~EDIT_CONSTANTS_URL"]) > 0) {
$res["URL"]["CONSTANTS"] = CComponentEngine::MakePathFromTemplate($arParams["~EDIT_CONSTANTS_URL"], array("ID" => $res["ID"], "MODULE_ID" => $arParams["MODULE_ID"], "ENTITY" => $arParams["ENTITY"], "DOCUMENT_ID" => $arParams["DOCUMENT_ID"]));
}
foreach ($res["URL"] as $key => $val) {
$errorMessage .= sprintf(GetMessage("CRM_EXT_SALE_C1STATUS") . "<br>", $response["STATUS"]["CODE"], $response["STATUS"]["PHRASE"]);
} elseif (strpos($response["BODY"], "form_auth") !== false) {
$errorMessage .= GetMessage("CRM_EXT_SALE_C1NO_AUTH") . "<br>";
}
}
$arResult["ErrorMessage"] .= $errorMessage;
if (strlen($errorMessage) <= 0) {
$arResult["SuccessMessage"] = GetMessage("CRM_EXT_SALE_C1SUCCESS") . "<br>";
}
}
}
if (strlen($arResult["FatalErrorMessage"]) <= 0) {
$arResult["GRID_ID"] = "crm_config_external_sale";
$gridOptions = new CGridOptions($arResult["GRID_ID"]);
$gridColumns = $gridOptions->GetVisibleColumns();
$gridSort = $gridOptions->GetSorting(array("sort" => array("DATE_UPDATE" => "desc")));
$arResult["HEADERS"] = array(array("id" => "NAME", "name" => GetMessage("BPWC_WLC_NAME"), "default" => true, "sort" => "NAME"), array("id" => "ACTIVE", "name" => GetMessage("BPWC_WLC_ACTIVE"), "default" => true, "sort" => "ACTIVE"), array("id" => "IMPORT_AGENT", "name" => GetMessage("BPWC_WLC_IMPORT_AGENT"), "default" => true, "sort" => ""), array("id" => "MESSAGE", "name" => GetMessage("BPWC_WLC_MESSAGE"), "default" => true, "sort" => ""), array("id" => "URL", "name" => GetMessage("BPWC_WLC_URL"), "default" => true, "sort" => ""), array("id" => "LAST_STATUS_DATE", "name" => GetMessage("BPWC_WLC_LAST_STATUS_DATE"), "default" => true, "sort" => "LAST_STATUS_DATE"), array("id" => "LAST_STATUS", "name" => GetMessage("BPWC_WLC_STATUS"), "default" => false, "sort" => "LAST_STATUS"), array("id" => "DATE_UPDATE", "name" => GetMessage("BPWC_WLC_DATE_UPDATE"), "default" => false, "sort" => "DATE_UPDATE"), array("id" => "IMPORT_PREFIX", "name" => GetMessage("BPWC_WLC_IMPORT_PREFIX"), "default" => false, "sort" => "IMPORT_PREFIX"), array("id" => "ID", "name" => "ID", "default" => false, "sort" => "ID"), array("id" => "DATE_CREATE", "name" => GetMessage("BPWC_WLC_DATE_CREATE"), "default" => false, "sort" => "DATE_CREATE"), array("id" => "IMPORT_SIZE", "name" => GetMessage("BPWC_WLC_SIZE"), "default" => false, "sort" => "IMPORT_SIZE"), array("id" => "IMPORT_PERIOD", "name" => GetMessage("BPWC_WLC_IMPORT_PERIOD"), "default" => false, "sort" => "IMPORT_PERIOD"), array("id" => "IMPORT_PROBABILITY", "name" => GetMessage("BPWC_WLC_IMPORT_PROBABILITY"), "default" => false, "sort" => "IMPORT_PROBABILITY"), array("id" => "IMPORT_PUBLIC", "name" => GetMessage("BPWC_WLC_IMPORT_PUBLIC"), "default" => false, "sort" => "IMPORT_PUBLIC"));
$arResult["SORT"] = $gridSort["sort"];
$arResult["RECORDS"] = array();
$dbRecordsList = CCrmExternalSale::GetList($gridSort["sort"], array());
while ($arRecord = $dbRecordsList->GetNext()) {
$path2Edit = CComponentEngine::MakePathFromTemplate($arParams["PATH_TO_EDIT"], array("id" => $arRecord["ID"]));
$path2Sync = CComponentEngine::MakePathFromTemplate($arParams["PATH_TO_SYNC"], array("id" => $arRecord["ID"]));
$agentInterval = 0;
$dbAgents = CAgent::GetList(array(), array("NAME" => "CCrmExternalSaleImport::DataSync(" . $arRecord["ID"] . ");", "MODULE_ID" => "crm", "ACTIVE" => "Y"));
if ($arAgent = $dbAgents->Fetch()) {
$agentInterval = intval($arAgent["AGENT_INTERVAL"] / 60);
}
$v = htmlspecialcharsbx($arRecord["SCHEME"] . "://" . $arRecord["SERVER"] . (intval($arRecord["PORT"]) > 0 ? ":" . $arRecord["PORT"] : ""));
$aCols = array("URL" => "<a href=\"" . $v . "\" target=\"_blank\">" . $v . "</a>", "ACTIVE" => $arRecord["ACTIVE"] == "Y" ? GetMessage("BPWC_WLC_YES") : GetMessage("BPWC_WLC_NO"), "IMPORT_PUBLIC" => $arRecord["IMPORT_PUBLIC"] == "Y" ? GetMessage("BPWC_WLC_YES") : GetMessage("BPWC_WLC_NO"), "IMPORT_AGENT" => $agentInterval > 0 ? $agentInterval : GetMessage("BPWC_WLC_MANUAL"), "MESSAGE" => "");
if (intval($arRecord["MODIFICATION_LABEL"]) == 0) {
