$row->AddViewField("LOGIN", "<a href=\"javascript:SetValue('".$f_ID."');\" title=\"".GetMessage("MAIN_CHANGE")."\">".$arRes["LOGIN"]."</a>"); $row->AddViewField("NAME", $arRes["NAME"]); $row->AddViewField("LAST_NAME", $arRes["LAST_NAME"]); $row->AddViewField("EMAIL", TxtToHtml($arRes["EMAIL"])); $row->AddViewField("PERSONAL_PROFESSION", $arRes[""]); $row->AddViewField("PERSONAL_WWW", TxtToHtml($arRes["PERSONAL_WWW"])); $row->AddViewField("PERSONAL_ICQ", $arRes["PERSONAL_ICQ"]); $row->AddViewField("PERSONAL_GENDER", $arRes["PERSONAL_GENDER"]); $row->AddViewField("PERSONAL_PHONE", $arRes["PERSONAL_PHONE"]); $row->AddViewField("PERSONAL_MOBILE", $arRes["PERSONAL_MOBILE"]); $row->AddViewField("PERSONAL_CITY", $arRes["PERSONAL_CITY"]); $row->AddViewField("PERSONAL_STREET", $arRes["PERSONAL_STREET"]); $row->AddViewField("WORK_COMPANY", $arRes["WORK_COMPANY"]); $row->AddViewField("WORK_DEPARTMENT", $arRes["WORK_DEPARTMENT"]); $row->AddViewField("WORK_POSITION", $arRes["WORK_POSITION"]); $row->AddViewField("WORK_WWW", TxtToHtml($arRes["WORK_WWW"])); $row->AddViewField("WORK_PHONE", $arRes["WORK_PHONE"]); $row->AddViewField("WORK_CITY", $arRes["WORK_CITY"]); $row->AddViewField("XML_ID", $arRes["XML_ID"]); $arActions = array(); $arActions[] = array( "ICON"=>"", "TEXT"=>GetMessage("MAIN_CHANGE"), "DEFAULT"=>true, "ACTION"=>"SetValue('".$f_ID."');" ); $row->AddActions($arActions); } $lAdmin->AddAdminContextMenu(array());
function FormatText($strText, $strTextType="text") { if(strtolower($strTextType)=="html") return $strText; return TxtToHtml($strText); }
$row =& $lAdmin->AddRow($f_ID, $arRes, "message_edit.php?lang=" . LANGUAGE_ID . "&ID=" . $f_ID, GetMessage("MAIN_ADMIN_MENU_EDIT_TITLE")); $row->AddViewField("ID", '<a href="message_edit.php?lang=' . LANGUAGE_ID . '&ID=' . $f_ID . '" title="' . GetMessage("MAIN_ADMIN_MENU_EDIT_TITLE") . '">' . $f_ID . '</a>'); $strSITE_ID = ''; $db_LID = CEventMessage::GetLang($f_ID); while ($ar_LID = $db_LID->Fetch()) { $strSITE_ID .= htmlspecialcharsbx($ar_LID["LID"]) . "<br>"; } $row->AddViewField("LID", $strSITE_ID); $row->AddCheckField("ACTIVE"); $row->AddInputField("SUBJECT", array("size" => 30)); $row->AddSelectField("BODY_TYPE", $arText_HTML); $row->AddViewField("EMAIL_FROM", TxtToHtml($arRes["EMAIL_FROM"])); $row->AddInputField("EMAIL_FROM"); $row->AddViewField("EMAIL_TO", TxtToHtml($arRes["EMAIL_TO"])); $row->AddInputField("EMAIL_TO"); $row->AddViewField("BCC", TxtToHtml($arRes["BCC"])); $row->AddInputField("BCC"); $row->AddSelectField("EVENT_NAME", $arEventTypes); $arActions = array(); $arActions[] = array("ICON" => "edit", "TEXT" => GetMessage("MAIN_ADMIN_MENU_EDIT"), "ACTION" => $lAdmin->ActionRedirect("message_edit.php?ID=" . $f_ID)); $arActions[] = array("ICON" => "copy", "TEXT" => GetMessage("MAIN_ADMIN_ADD_COPY"), "ACTION" => $lAdmin->ActionRedirect("message_edit.php?COPY_ID=" . $f_ID)); if ($isAdmin) { $arActions[] = array("SEPARATOR" => true); $arActions[] = array("ICON" => "delete", "TEXT" => GetMessage("MAIN_ADMIN_MENU_DELETE"), "ACTION" => "if(confirm('" . GetMessage('CONFIRM_DEL_MESSAGE') . "')) " . $lAdmin->ActionDoGroup($f_ID, "delete")); } $row->AddActions($arActions); } // Footer $lAdmin->AddFooter(array(array("title" => GetMessage("MAIN_ADMIN_LIST_SELECTED"), "value" => $rsData->SelectedRowsCount()), array("counter" => true, "title" => GetMessage("MAIN_ADMIN_LIST_CHECKED"), "value" => "0"))); // Form with buttons $lAdmin->AddGroupActionTable(array("delete" => GetMessage("MAIN_ADMIN_LIST_DELETE"), "activate" => GetMessage("MAIN_ADMIN_LIST_ACTIVATE"), "deactivate" => GetMessage("MAIN_ADMIN_LIST_DEACTIVATE")));
$row->AddViewField("PROBLEM_TIME", $str); } else { $row->AddViewField("PROBLEM_TIME", " "); } $arr = explode(" ",$f_DATE_CREATE); $DATE_CREATE_HTML = $arr[0]." ".$arr[1]."<br>"; if (strlen($f_SOURCE_NAME)>0) $DATE_CREATE_HTML .= "<nobr>[".$f_SOURCE_NAME."] </nobr><br>"; if (strlen($f_OWNER_SID)>0) $DATE_CREATE_HTML .= TxtToHtml($f_OWNER_SID)." <br>"; /* if (intval($f_OWNER_USER_ID)>0) $DATE_CREATE_HTML .= '[<a title="'.GetMessage("SUP_USER_PROFILE").'" href="/bitrix/admin/user_edit.php?lang='.LANG.'&ID='.$f_OWNER_USER_ID.'">'.$f_OWNER_USER_ID.'</a>] ('.$f_OWNER_LOGIN.') '.$f_OWNER_NAME; $row->AddViewField("DATE_CREATE", $DATE_CREATE_HTML); */ $row->AddViewField("LAST_MESSAGE_DATE_EX", $f_LAST_MESSAGE_DATE); } $arRow["arFields"]["t_DATE_CREATE_HTML"] = $DATE_CREATE_HTML; /* $TIMESTAMP_X_HTML = $f_TIMESTAMP_X."<br>";
function WF_SetMove($NEW_ID, $OLD_ID = 0) { if (CModule::IncludeModule("workflow")) { $err_mess = "FILE: " . __FILE__ . "<br>LINE: "; global $DB, $USER; $USER_ID = is_object($USER) ? intval($USER->GetID()) : 0; $NEW = "Y"; $OLD_ID = intval($OLD_ID); $NEW_ID = intval($NEW_ID); if ($OLD_ID > 0) { $old = $DB->Query("SELECT WF_STATUS_ID FROM b_iblock_element WHERE ID = " . $OLD_ID, false, $err_mess . __LINE__); if ($old_r = $old->Fetch()) { $NEW = "N"; } } CTimeZone::Disable(); $new = CIBlockElement::GetByID($NEW_ID); CTimeZone::Enable(); if ($new_r = $new->Fetch()) { $NEW_STATUS_ID = intval($new_r["WF_STATUS_ID"]); $OLD_STATUS_ID = intval($old_r["WF_STATUS_ID"]); $PARENT_ID = intval($new_r["WF_PARENT_ELEMENT_ID"]); CTimeZone::Disable(); $parent = CIBlockElement::GetByID($PARENT_ID); CTimeZone::Enable(); if ($parent_r = $parent->Fetch()) { $arFields = array("TIMESTAMP_X" => $DB->GetNowFunction(), "IBLOCK_ELEMENT_ID" => $PARENT_ID, "OLD_STATUS_ID" => $OLD_STATUS_ID, "STATUS_ID" => $NEW_STATUS_ID, "USER_ID" => $USER_ID); $DB->Insert("b_workflow_move", $arFields, $err_mess . __LINE__); if ($NEW_STATUS_ID != $OLD_STATUS_ID) { // Get creator Email $strSql = "SELECT EMAIL FROM b_user WHERE ID = " . intval($parent_r["CREATED_BY"]); $rs = $DB->Query($strSql, false, $err_mess . __LINE__); if ($ar = $rs->Fetch()) { $parent_r["CREATED_BY_EMAIL"] = $ar["EMAIL"]; } else { $parent_r["CREATED_BY_EMAIL"] = ""; } // gather email of the workflow admins $WORKFLOW_ADMIN_GROUP_ID = intval(COption::GetOptionString("workflow", "WORKFLOW_ADMIN_GROUP_ID")); $strSql = "\n\t\t\t\t\t\t\tSELECT U.ID, U.EMAIL\n\t\t\t\t\t\t\tFROM b_user U, b_user_group UG\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tUG.GROUP_ID=" . $WORKFLOW_ADMIN_GROUP_ID . "\n\t\t\t\t\t\t\t\tAND U.ID = UG.USER_ID\n\t\t\t\t\t\t\t\tAND U.ACTIVE='Y'\n\t\t\t\t\t\t"; $rs = $DB->Query($strSql, false, $err_mess . __LINE__); $arAdmin = array(); while ($ar = $rs->Fetch()) { $arAdmin[$ar["ID"]] = $ar["EMAIL"]; } // gather email for BCC $arBCC = array(); // gather all who changed doc in its current status $strSql = "\n\t\t\t\t\t\t\tSELECT U.EMAIL\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tb_workflow_move WM\n\t\t\t\t\t\t\t\tINNER JOIN b_user U on U.ID = WM.USER_ID\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tIBLOCK_ELEMENT_ID = " . $PARENT_ID . "\n\t\t\t\t\t\t\t\tAND OLD_STATUS_ID = " . $NEW_STATUS_ID . "\n\t\t\t\t\t\t"; $rs = $DB->Query($strSql, false, $err_mess . __LINE__); while ($ar = $rs->Fetch()) { $arBCC[$ar["EMAIL"]] = $ar["EMAIL"]; } // gather all editors // in case status have notifier flag //First those who have write permissions on iblock $strSql = "\n\t\t\t\t\t\t\tSELECT U.EMAIL\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tb_workflow_status S\n\t\t\t\t\t\t\t\tINNER JOIN b_workflow_status2group SG on SG.STATUS_ID = S.ID\n\t\t\t\t\t\t\t\tINNER JOIN b_iblock_group IG on IG.GROUP_ID = SG.GROUP_ID\n\t\t\t\t\t\t\t\tINNER JOIN b_user_group UG on UG.GROUP_ID = IG.GROUP_ID\n\t\t\t\t\t\t\t\tINNER JOIN b_user U on U.ID = UG.USER_ID\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tS.ID = " . $NEW_STATUS_ID . "\n\t\t\t\t\t\t\t\tAND S.NOTIFY = 'Y'\n\t\t\t\t\t\t\t\tAND IG.IBLOCK_ID = " . intval($new_r["IBLOCK_ID"]) . "\n\t\t\t\t\t\t\t\tAND IG.PERMISSION >= 'U'\n\t\t\t\t\t\t\t\tAND SG.PERMISSION_TYPE = '2'\n\t\t\t\t\t\t\t\tAND U.ACTIVE = 'Y'\n\t\t\t\t\t\t"; $rs = $DB->Query($strSql, false, $err_mess . __LINE__); while ($ar = $rs->Fetch()) { $arBCC[$ar["EMAIL"]] = $ar["EMAIL"]; } //Second admins if they in PERMISSION_TYPE = 2 list //because they have all the rights $strSql = "\n\t\t\t\t\t\t\tSELECT U.EMAIL\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tb_workflow_status S\n\t\t\t\t\t\t\t\tINNER JOIN b_workflow_status2group SG on SG.STATUS_ID = S.ID\n\t\t\t\t\t\t\t\tINNER JOIN b_user_group UG on UG.GROUP_ID = SG.GROUP_ID\n\t\t\t\t\t\t\t\tINNER JOIN b_user U on U.ID = UG.USER_ID\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tS.ID = " . $NEW_STATUS_ID . "\n\t\t\t\t\t\t\t\tAND S.NOTIFY = 'Y'\n\t\t\t\t\t\t\t\tAND SG.GROUP_ID = 1\n\t\t\t\t\t\t\t\tAND SG.PERMISSION_TYPE = '2'\n\t\t\t\t\t\t\t\tAND U.ACTIVE = 'Y'\n\t\t\t\t\t\t"; $rs = $DB->Query($strSql, false, $err_mess . __LINE__); while ($ar = $rs->Fetch()) { $arBCC[$ar["EMAIL"]] = $ar["EMAIL"]; } $iblock_r = CIBlock::GetArrayByID($new_r["IBLOCK_ID"]); $iblock_r["LID"] = array(); $rsIBlockSite = $DB->Query("SELECT SITE_ID FROM b_iblock_site WHERE IBLOCK_ID= " . intval($new_r["IBLOCK_ID"])); while ($arIBlockSite = $rsIBlockSite->Fetch()) { $iblock_r["LID"][] = $arIBlockSite["SITE_ID"]; } if (array_key_exists($new_r["MODIFIED_BY"], $arAdmin)) { $new_r["USER_NAME"] .= " (Admin)"; } // it is not new doc if ($NEW != "Y") { if (array_key_exists($parent_r["CREATED_BY"], $arAdmin)) { $parent_r["CREATED_USER_NAME"] .= " (Admin)"; } // send change notification $arEventFields = array("ID" => $PARENT_ID, "IBLOCK_ID" => $new_r["IBLOCK_ID"], "IBLOCK_TYPE" => $iblock_r["IBLOCK_TYPE_ID"], "ADMIN_EMAIL" => implode(",", $arAdmin), "BCC" => implode(",", $arBCC), "PREV_STATUS_ID" => $OLD_STATUS_ID, "PREV_STATUS_TITLE" => CIblockElement::WF_GetStatusTitle($OLD_STATUS_ID), "STATUS_ID" => $NEW_STATUS_ID, "STATUS_TITLE" => CIblockElement::WF_GetStatusTitle($NEW_STATUS_ID), "DATE_CREATE" => $parent_r["DATE_CREATE"], "CREATED_BY_ID" => $parent_r["CREATED_BY"], "CREATED_BY_NAME" => $parent_r["CREATED_USER_NAME"], "CREATED_BY_EMAIL" => $parent_r["CREATED_BY_EMAIL"], "DATE_MODIFY" => $new_r["TIMESTAMP_X"], "MODIFIED_BY_ID" => $new_r["MODIFIED_BY"], "MODIFIED_BY_NAME" => $new_r["USER_NAME"], "NAME" => $new_r["NAME"], "SECTION_ID" => $new_r["IBLOCK_SECTION_ID"], "PREVIEW_HTML" => $new_r["PREVIEW_TEXT_TYPE"] == "html" ? $new_r["PREVIEW_TEXT"] : TxtToHtml($new_r["PREVIEW_TEXT"]), "PREVIEW_TEXT" => $new_r["PREVIEW_TEXT_TYPE"] == "text" ? $new_r["PREVIEW_TEXT"] : HtmlToTxt($new_r["PREVIEW_TEXT"]), "PREVIEW" => $new_r["PREVIEW_TEXT"], "PREVIEW_TYPE" => $new_r["PREVIEW_TEXT_TYPE"], "DETAIL_HTML" => $new_r["DETAIL_TEXT_TYPE"] == "html" ? $new_r["DETAIL_TEXT"] : TxtToHtml($new_r["DETAIL_TEXT"]), "DETAIL_TEXT" => $new_r["DETAIL_TEXT_TYPE"] == "text" ? $new_r["DETAIL_TEXT"] : HtmlToTxt($new_r["DETAIL_TEXT"]), "DETAIL" => $new_r["DETAIL_TEXT"], "DETAIL_TYPE" => $new_r["DETAIL_TEXT_TYPE"], "COMMENTS" => $new_r["WF_COMMENTS"]); CEvent::Send("WF_IBLOCK_STATUS_CHANGE", $iblock_r["LID"], $arEventFields); } else { // it was new one $arEventFields = array("ID" => $PARENT_ID, "IBLOCK_ID" => $new_r["IBLOCK_ID"], "IBLOCK_TYPE" => $iblock_r["IBLOCK_TYPE_ID"], "ADMIN_EMAIL" => implode(",", $arAdmin), "BCC" => implode(",", $arBCC), "STATUS_ID" => $NEW_STATUS_ID, "STATUS_TITLE" => CIblockElement::WF_GetStatusTitle($NEW_STATUS_ID), "DATE_CREATE" => $parent_r["DATE_CREATE"], "CREATED_BY_ID" => $parent_r["CREATED_BY"], "CREATED_BY_NAME" => $parent_r["CREATED_USER_NAME"], "CREATED_BY_EMAIL" => $parent_r["CREATED_BY_EMAIL"], "NAME" => $new_r["NAME"], "PREVIEW_HTML" => $new_r["PREVIEW_TEXT_TYPE"] == "html" ? $new_r["PREVIEW_TEXT"] : TxtToHtml($new_r["PREVIEW_TEXT"]), "PREVIEW_TEXT" => $new_r["PREVIEW_TEXT_TYPE"] == "text" ? $new_r["PREVIEW_TEXT"] : HtmlToTxt($new_r["PREVIEW_TEXT"]), "PREVIEW" => $new_r["PREVIEW_TEXT"], "PREVIEW_TYPE" => $new_r["PREVIEW_TEXT_TYPE"], "SECTION_ID" => $new_r["IBLOCK_SECTION_ID"], "DETAIL_HTML" => $new_r["DETAIL_TEXT_TYPE"] == "html" ? $new_r["DETAIL_TEXT"] : TxtToHtml($new_r["DETAIL_TEXT"]), "DETAIL_TEXT" => $new_r["DETAIL_TEXT_TYPE"] == "text" ? $new_r["DETAIL_TEXT"] : HtmlToTxt($new_r["DETAIL_TEXT"]), "DETAIL" => $new_r["DETAIL_TEXT"], "DETAIL_TYPE" => $new_r["DETAIL_TEXT_TYPE"], "COMMENTS" => $new_r["WF_COMMENTS"]); CEvent::Send("WF_NEW_IBLOCK_ELEMENT", $iblock_r["LID"], $arEventFields); } } } } } }
} } ?> </td> </tr> <tr> <td style="padding:4px;text-align:left;<?php echo $backcolor; ?> "><?php if ($arM["IS_LOG"] != "Y") { echo strlen($arM["SOURCE_NAME"]) > 0 ? "[" . htmlspecialcharsbx($arM["SOURCE_NAME"]) . "] " : ""; $oUID = isset($arM["OWNER_USER_ID"]) ? intval($arM["OWNER_USER_ID"]) : 0; $oGID = isset($arM["OWNER_GUEST_ID"]) ? intval($arM["OWNER_GUEST_ID"]) : 0; if (strlen($arM["OWNER_SID"]) > 0) { echo TxtToHtml($arM["OWNER_SID"]) . " "; if ($oUID > 0) { echo "/ "; } } if ($oUID > 0) { //Support_GetUserInfo($arM["OWNER_USER_ID"], $arM["OWNER_LOGIN"], $arM["OWNER_USER_NAME"]); if (!in_array($oUID, array_keys($arrSUPPORT_TEAM))) { if ($arM["MESSAGE_BY_SUPPORT_TEAM"] == "Y") { $arrSUPPORT_TEAM[$oUID] = "(<span class=\"supportrequired\">" . GetMessage("SUP_TECHSUPPORT") . "</span>)"; } elseif ($arM["MESSAGE_BY_SUPPORT_TEAM"] == "N") { $arrSUPPORT_TEAM[$oUID] = ""; } else { $arrSUPPORT_TEAM[$oUID] = CTicket::IsSupportTeam($uid) || CTicket::IsAdmin($uid) ? "(<span class=\"supportrequired\">" . GetMessage("SUP_TECHSUPPORT") . "</span>)" : ""; } }
<td colspan="2" <?php if ($isEditMode) { ?> align="center"<?php } ?> ><?php if ($isEditMode) { ?> <textarea style="width:85%" name="COMMENTS" rows="7" wrap="VIRTUAL"><?php echo $str_COMMENTS; ?> </textarea><?php } else { echo TxtToHtml($str_COMMENTS); } ?> </td> </tr> <?php $disable = true; if ($isManager || $isAdmin || $isDemo && !$isOwner || $isEditMode) { $disable = false; } $tabControl->Buttons(array("disabled" => $disable, "back_url" => "/bitrix/admin/adv_banner_list.php?lang=" . LANGUAGE_ID)); $tabControl->End(); ?> </form> <script type="text/javascript"> <?php
?> </a><?php } } ?> </td> </tr> <tr> <td style="padding:4px;<?php echo $backcolor; ?> "><?php if ($f_IS_LOG != "Y") { echo strlen($f_SOURCE_NAME) > 0 ? "[" . htmlspecialchars($f_SOURCE_NAME) . "] " : ""; if (strlen($f_OWNER_SID) > 0) { echo TxtToHtml($f_OWNER_SID) . " "; if (intval($f_OWNER_USER_ID) > 0) { echo "/ "; } } if (intval($f_OWNER_USER_ID) > 0) { Support_GetUserInfo($f_OWNER_USER_ID, $f_OWNER_LOGIN, $f_OWNER_USER_NAME); $uid = $f_OWNER_USER_ID; if (!in_array($uid, array_keys($arrSUPPORT_TEAM))) { if ($f_MESSAGE_BY_SUPPORT_TEAM == "Y") { $arrSUPPORT_TEAM[$uid] = "(<span class=\"supportrequired\">" . GetMessage("SUP_TECHSUPPORT") . "</span>)"; } elseif ($f_MESSAGE_BY_SUPPORT_TEAM == "N") { $arrSUPPORT_TEAM[$uid] = ""; } else { $arrSUPPORT_TEAM[$uid] = CTicket::IsSupportTeam($uid) || CTicket::IsAdmin($uid) ? "(<span class=\"supportrequired\">" . GetMessage("SUP_TECHSUPPORT") . "</span>)" : ""; }
</tr> <tr valign="top"> <td><?php echo GetMessage("AD_DESCRIPTION"); ?> </td> <td><?php if (($isAdmin || $isDemo && !$isOwner) && $isEditMode) { ?> <textarea cols="45" name="DESCRIPTION" rows="8"><?php echo $str_DESCRIPTION; ?> </textarea><?php } else { echo TxtToHtml($str_DESCRIPTION); } ?> </td> </tr> <?php $arrStatus = CAdvBanner::GetStatusList(); if ($isEditMode && ($isAdmin || $isDemo && !$isOwner)) { ?> <tr> <td><?php echo GetMessage("AD_DEFAULT_STATUS"); ?> </td> <td><?php
############################################## # Bitrix: SiteManager # # Copyright (c) 2002 Bitrix # # http://www.bitrix.ru # # mailto:admin@bitrix.ru # ############################################## */ define("STOP_STATISTICS", "Y"); require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php"; require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/workflow/prolog.php"; require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/workflow/include.php"; $fname = $_REQUEST["fname"]; if ($APPLICATION->GetGroupRight("workflow") >= "R") { session_write_close(); $src = CWorkflow::GetFileContent($did, $fname, $wf_path, $site); $ext = strtolower(GetFileExtension($fname)); $arrExt = explode(",", strtolower(CFile::GetImageExtensions())); if (in_array($ext, $arrExt)) { if ($ext == "jpg") { $ext = "jpeg"; } header("Content-type: image/" . $ext); header("Cache-Control: no-cache, must-revalidate, post-check=0, pre-check=0"); header("Expires: 0"); header("Pragma: public"); echo $src; die; } echo TxtToHtml($src); } die;
break; } } } } $rsData = CForumUser::GetListEx(array($by => $order), $arFilter); $rsData = new CAdminResult($rsData, $sTableID); $rsData->NavStart(); $lAdmin->NavText($rsData->GetNavPrint(GetMessage("FM_TITLE_PAGE"))); /*******************************************************************/ $lAdmin->AddHeaders(array(array("id" => "ID", "content" => GetMessage("FM_HEAD_FORUM_USER_ID"), "sort" => "ID", "default" => false), array("id" => "USER_ID", "content" => GetMessage("FM_HEAD_USER_ID"), "sort" => "USER_ID", "default" => true), array("id" => "EMAIL", "content" => GetMessage("FM_HEAD_EMAIL"), "sort" => "EMAIL", "default" => true), array("id" => "LOGIN", "content" => GetMessage("FM_HEAD_LOGIN"), "sort" => "LOGIN", "default" => true), array("id" => "NAME", "content" => GetMessage("FM_HEAD_NAME"), "sort" => "NAME", "default" => true), array("id" => "LAST_NAME", "content" => GetMessage("FM_HEAD_LAST_NAME"), "sort" => "LAST_NAME", "default" => true), array("id" => "SUBSC_COUNT", "content" => GetMessage("FM_HEAD_SUBSC"), "sort" => "SUBSC_COUNT", "default" => true), array("id" => "SUBSC_START_DATE", "content" => GetMessage("FM_HEAD_START_DATE"), "sort" => "SUBSC_START_DATE", "default" => true))); /*******************************************************************/ while ($arRes = $rsData->NavNext(true, "t_")) { $row =& $lAdmin->AddRow($t_USER_ID, $arRes); $row->AddViewField("USER_ID", "<a href='user_edit.php?lang=" . LANGUAGE_ID . "&ID=" . $t_USER_ID . "' title='" . GetMessage("FM_MAIN_EDIT_TITLE") . "'>" . $t_USER_ID . "</a>"); $row->AddViewField("EMAIL", TxtToHtml($arRes["EMAIL"])); $row->AddViewField("SUBSC_COUNT", $t_SUBSC_COUNT <= 0 ? GetMessage("FM_NO") : $t_SUBSC_COUNT); $arActions = array(); $arActions[] = array("ICON" => "edit", "TEXT" => GetMessage("FM_ACT_EDIT"), "ACTION" => $lAdmin->ActionRedirect("forum_subscribe_edit.php?lang=" . LANG . "&USER_ID=" . $t_USER_ID), "DEFAULT" => true); $arActions[] = array("SEPARATOR" => true); $arActions[] = array("ICON" => "delete", "TEXT" => GetMessage("FM_ACT_DELETE"), "ACTION" => "if(confirm('" . GetMessage("FM_ACT_DEL_CONFIRM") . "')) " . $lAdmin->ActionDoGroup($t_USER_ID, "delete", "lang=" . LANG)); $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("FM_ACT_DELETE"))); $lAdmin->AddAdminContextMenu(); /*******************************************************************/ $lAdmin->CheckListMode(); /*******************************************************************/ $APPLICATION->SetTitle(GetMessage("FM_TITLE"));
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("SQL_PAGES"))); $intNumFields = $rsData->FieldsCount(); $i = 0; $header = array(); $arFieldName = array(); while ($i < $intNumFields) { $header[] = array("id" => $rsData->FieldName($i), "content" => $rsData->FieldName($i), "sort" => $rsData->FieldName($i), "default" => true, "align" => "left", "valign" => "top"); $arFieldName[] = $rsData->FieldName($i); $i++; } $lAdmin->AddHeaders($header); $j = 0; while ($db_res = $rsData->Fetch()) { $row =& $lAdmin->AddRow("ID", $db_res); foreach ($arFieldName as $field_name) { $row->AddViewField($field_name, TxtToHtml($db_res[$field_name])); } } } else { foreach ($arErrors as $i => $strError) { $lAdmin->AddFilterError(GetMessage("SQL_QUERY_ERROR_1") . "<br>" . $strError); } } } if ($message != null) { $lAdmin->BeginPrologContent(); echo $message->Show(); $lAdmin->EndPrologContent(); } $lAdmin->BeginEpilogContent(); ?>
public static function SetMove($DOCUMENT_ID, $STATUS_ID, $OLD_STATUS_ID, $LOG_ID) { $err_mess = CAllWorkflow::err_mess() . "<br>Function: SetMove<br>Line: "; global $DB, $USER, $APPLICATION; $DOCUMENT_ID = intval($DOCUMENT_ID); $STATUS_ID = intval($STATUS_ID); $OLD_STATUS_ID = intval($OLD_STATUS_ID); $LOG_ID = intval($LOG_ID); $arFields = array("TIMESTAMP_X" => $DB->GetNowFunction(), "DOCUMENT_ID" => $DOCUMENT_ID, "OLD_STATUS_ID" => $OLD_STATUS_ID, "STATUS_ID" => $STATUS_ID, "LOG_ID" => $LOG_ID, "USER_ID" => intval($USER->GetID())); $DB->Insert("b_workflow_move", $arFields, $err_mess . __LINE__); if ($STATUS_ID != $OLD_STATUS_ID) { CTimeZone::Disable(); $d = CWorkflow::GetByID($DOCUMENT_ID); CTimeZone::Enable(); if ($dr = $d->Fetch()) { $STATUS_ID = $dr["STATUS_ID"]; // document creator $ENTERED_BY_USER_ID = $dr["ENTERED_BY"]; // gather email of the workflow admins $WORKFLOW_ADMIN_GROUP_ID = COption::GetOptionInt("workflow", "WORKFLOW_ADMIN_GROUP_ID", 0); $strSql = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tU.ID,\n\t\t\t\t\t\tU.EMAIL\n\t\t\t\t\tFROM\n\t\t\t\t\t\tb_user U,\n\t\t\t\t\t\tb_user_group UG\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tUG.GROUP_ID = {$WORKFLOW_ADMIN_GROUP_ID}\n\t\t\t\t\t\tand U.ID = UG.USER_ID\n\t\t\t\t\t\tand U.ACTIVE = 'Y'\n\t\t\t\t"; $a = $DB->Query($strSql, false, $err_mess . __LINE__); $arAdmin = array(); while ($ar = $a->Fetch()) { $arAdmin[$ar["ID"]] = $ar["EMAIL"]; } // gather email for BCC $arBCC = array(); // gather all who changed doc in its current status $strSql = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tUSER_ID\n\t\t\t\t\tFROM\n\t\t\t\t\t\tb_workflow_move\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tDOCUMENT_ID = {$DOCUMENT_ID}\n\t\t\t\t\t\tand OLD_STATUS_ID = {$STATUS_ID}\n\t\t\t\t"; $z = $DB->Query($strSql, false, $err_mess . __LINE__); while ($zr = $z->Fetch()) { $arBCC[$zr["EMAIL"]] = $zr["EMAIL"]; } // gather all editors // in case status have notifier flag $strSql = "\n\t\t\t\t\tSELECT DISTINCT\n\t\t\t\t\t\tUG.USER_ID\n\t\t\t\t\t\t,U.EMAIL\n\t\t\t\t\tFROM\n\t\t\t\t\t\tb_workflow_status S,\n\t\t\t\t\t\tb_workflow_status2group SG,\n\t\t\t\t\t\tb_user U,\n\t\t\t\t\t\tb_user_group UG\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tS.ID = {$STATUS_ID}\n\t\t\t\t\t\tand S.NOTIFY = 'Y'\n\t\t\t\t\t\tand SG.STATUS_ID = S.ID\n\t\t\t\t\t\tand SG.PERMISSION_TYPE = '2'\n\t\t\t\t\t\tand UG.GROUP_ID = SG.GROUP_ID\n\t\t\t\t\t\tand U.ID = UG.USER_ID\n\t\t\t\t\t\tand U.ACTIVE = 'Y'\n\t\t\t\t"; $z = $DB->Query($strSql, false, $err_mess . __LINE__); while ($zr = $z->Fetch()) { if (!array_key_exists($zr["EMAIL"], $arBCC)) { $grp = array(); $rs = $USER->GetUserGroupList($zr["USER_ID"]); while ($ar = $rs->Fetch()) { $grp[] = $ar["GROUP_ID"]; } $arTasks = $APPLICATION->GetFileAccessPermission($dr["FILENAME"], $grp, true); foreach ($arTasks as $task_id) { $arOps = CTask::GetOperations($task_id, true); if (in_array("fm_edit_in_workflow", $arOps)) { $arBCC[$zr["EMAIL"]] = $zr["EMAIL"]; break; } } } } unset($arBCC[$dr["EUSER_EMAIL"]]); if (array_key_exists($dr["ENTERED_BY"], $arAdmin)) { $dr["EUSER_NAME"] .= " (Admin)"; } // it is not new doc if ($OLD_STATUS_ID > 0) { if (array_key_exists($dr["MODIFIED_BY"], $arAdmin)) { $dr["MUSER_NAME"] .= " (Admin)"; } $q = CWorkflowStatus::GetByID($OLD_STATUS_ID); $qr = $q->Fetch(); // send change notification $arEventFields = array("ID" => $dr["ID"], "ADMIN_EMAIL" => implode(",", $arAdmin), "BCC" => implode(",", $arBCC), "PREV_STATUS_ID" => $OLD_STATUS_ID, "PREV_STATUS_TITLE" => $qr["TITLE"], "STATUS_ID" => $dr["STATUS_ID"], "STATUS_TITLE" => $dr["STATUS_TITLE"], "DATE_ENTER" => $dr["DATE_ENTER"], "ENTERED_BY_ID" => $dr["ENTERED_BY"], "ENTERED_BY_NAME" => $dr["EUSER_NAME"], "ENTERED_BY_EMAIL" => $dr["EUSER_EMAIL"], "DATE_MODIFY" => $dr["DATE_MODIFY"], "MODIFIED_BY_ID" => $dr["MODIFIED_BY"], "MODIFIED_BY_NAME" => $dr["MUSER_NAME"], "FILENAME" => $dr["FILENAME"], "SITE_ID" => $dr["SITE_ID"], "TITLE" => $dr["TITLE"], "BODY_HTML" => $dr["BODY_TYPE"] == "html" ? $dr["BODY"] : TxtToHtml($dr["BODY"]), "BODY_TEXT" => $dr["BODY_TYPE"] == "text" ? $dr["BODY"] : HtmlToTxt($dr["BODY"]), "BODY" => $dr["BODY"], "BODY_TYPE" => $dr["BODY_TYPE"], "COMMENTS" => $dr["COMMENTS"]); CEvent::Send("WF_STATUS_CHANGE", $dr["SITE_ID"], $arEventFields); } else { // it was new one $arEventFields = array("ID" => $dr["ID"], "ADMIN_EMAIL" => implode(",", $arAdmin), "BCC" => implode(",", $arBCC), "STATUS_ID" => $dr["STATUS_ID"], "STATUS_TITLE" => $dr["STATUS_TITLE"], "DATE_ENTER" => $dr["DATE_ENTER"], "ENTERED_BY_ID" => $dr["ENTERED_BY"], "ENTERED_BY_NAME" => $dr["EUSER_NAME"], "ENTERED_BY_EMAIL" => $dr["EUSER_EMAIL"], "FILENAME" => $dr["FILENAME"], "SITE_ID" => $dr["SITE_ID"], "TITLE" => $dr["TITLE"], "BODY_HTML" => $dr["BODY_TYPE"] == "html" ? $dr["BODY"] : TxtToHtml($dr["BODY"]), "BODY_TEXT" => $dr["BODY_TYPE"] == "text" ? $dr["BODY"] : HtmlToTxt($dr["BODY"]), "BODY" => $dr["BODY"], "BODY_TYPE" => $dr["BODY_TYPE"], "COMMENTS" => $dr["COMMENTS"]); CEvent::Send("WF_NEW_DOCUMENT", $dr["SITE_ID"], $arEventFields); } } } }
echo $f_ACTIVE == "Y" ? GetMessage('SALE_YES') : GetMessage('SALE_NO'); ?> </font></td> <td class="tablebody2"><font class="tablebodytext"><?php echo $f_LOGIN; ?> </font></td> <td class="tablebody2"><font class="tablebodytext"><?php echo $f_NAME; ?> <br><?php echo $f_LAST_NAME; ?> </font></td> <td class="tablebody2"><font class="tablebodytext"><?php echo TxtToHtml($f_EMAIL); ?> </font></td> <td class="tablebody3" nowrap><input class="button" type="button" onClick="SetValue('<?php echo $f_ID; ?> ', '<?php echo str_replace("'", "\\'", str_replace("\\", "\\\\", htmlspecialcharsbx($f_NAME . (strlen($f_NAME) <= 0 || strlen($f_LAST_NAME) <= 0 ? "" : " ") . $f_LAST_NAME . " (" . $f_LOGIN . ")"))); ?> ');" value="<?php echo GetMessage("SALE_SELECT"); ?> "></td> </tr> <?php }