$arHeaders[] = array("id" => "MARK_ID", "content" => GetMessage("SUP_MARK"), "default" => false, "sort" => "s_mark");
if ($bADS) {
$arHeaders[] = array("id" => "PROBLEM_TIME", "content" => GetMessage("SUP_PROBLEM_TIME"), "default" => false, "sort" => "s_problem_time");
}
if ($bADS) {
$arHeaders[] = array("id" => "COUPON", "content" => GetMessage("SUP_COUPON"), "default" => false, "sort" => "s_coupon");
}
if ($bADS) {
$arHeaders[] = array("id" => "SUPPORT_DEADLINE", "content" => GetMessage("SUP_DEADLINE"), "default" => true, "sort" => "s_deadline");
}
$USER_FIELD_MANAGER->AdminListAddHeaders($entity_id, $arHeaders);
// заголовок списка
$lAdmin->AddHeaders($arHeaders);
$get_user_name = "N";
//$rsData = CTicket::GetList($by, $order, $arFilter, $is_filtered, "Y", $get_user_name, $get_extra_names);
$rsData = CTicket::GetList($by, $order, $arFilter, $is_filtered, "Y", $get_user_name, $get_extra_names, false, array("SELECT" => $lAdmin->GetVisibleHeaderColumns(), 'NAV_PARAMS' => array('nPageSize' => CAdminResult::GetNavSize($sTableID), 'bShowAll' => false)));
$rsData = new CAdminResult($rsData, $sTableID);
// установка строки навигации
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("SUP_PAGES")));
// построение списка
$arRows = array();
$aUserIDs = array();
$arGuestIDs = array();
$arUsersPref = array("RESPONSIBLE", "OWNER", "CREATED", "MODIFIED");
$arGuestsPref = array("OWNER", "CREATED", "MODIFIED");
while ($arRes = $rsData->NavNext(true, "f_")) {
$lamp = "/bitrix/images/support/{$f_LAMP}.gif";
$lamp_alt = GetMessage("SUP_" . strtoupper($f_LAMP) . "_ALT");
/*if ($get_user_name=="N")
{
Support_GetUserInfo($f_RESPONSIBLE_USER_ID, $f_RESPONSIBLE_LOGIN, $f_RESPONSIBLE_NAME);
}
$propertyOrder = array();
if ($by == 'PROPERTY_TYPE') {
$propertyOrder = array('PROPERTY_TYPE' => $order, 'USER_TYPE' => $order);
} else {
$propertyOrder = array(strtoupper($by) => strtoupper($order));
}
if (!isset($propertyOrder['ID'])) {
$propertyOrder['ID'] = 'ASC';
}
$usePageNavigation = true;
$navyParams = array();
if (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel') {
$usePageNavigation = false;
} else {
$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($sTableID));
if ($navyParams['SHOW_ALL']) {
$usePageNavigation = false;
} else {
$navyParams['PAGEN'] = (int) $navyParams['PAGEN'];
$navyParams['SIZEN'] = (int) $navyParams['SIZEN'];
}
}
if ($selectFields['PROPERTY_TYPE']) {
$selectFields['USER_TYPE'] = true;
}
$selectFields = array_keys($selectFields);
$getListParams = array('select' => $selectFields, 'filter' => $arFilter, 'order' => $propertyOrder);
if ($usePageNavigation) {
$getListParams['limit'] = $navyParams['SIZEN'];
$getListParams['offset'] = $navyParams['SIZEN'] * ($navyParams['PAGEN'] - 1);
function NavStart($nPageSize=20, $bShowAll=true, $iNumPage=false)
{
$nSize = CAdminResult::GetNavSize($this->table_id, $nPageSize);
if(!is_array($nPageSize))
$nPageSize = array();
$nPageSize["nPageSize"] = $nSize;
if($_REQUEST["mode"] == "excel")
$nPageSize["NavShowAll"] = true;
$this->nInitialSize = $nPageSize["nPageSize"];
parent::NavStart($nPageSize, $bShowAll, $iNumPage);
}
$selectFieldsMap = array_fill_keys(array_keys($headerList), false);
$selectFieldsMap = array_merge($selectFieldsMap, $selectFields);
$userList = array();
$userIDs = array();
$nameFormat = CSite::GetNameFormat(true);
$rowList = array();
$couponTypeList = array();
if ($selectFieldsMap['TYPE']) {
$couponTypeList = Internals\DiscountCouponTable::getCouponTypes(true);
}
$usePageNavigation = true;
$navyParams = array();
if (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel') {
$usePageNavigation = false;
} else {
$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($adminListTableID, array('nPageSize' => 20, 'sNavID' => $adminList->GetListUrl(true))));
if ($navyParams['SHOW_ALL']) {
$usePageNavigation = false;
} else {
$navyParams['PAGEN'] = (int) $navyParams['PAGEN'];
$navyParams['SIZEN'] = (int) $navyParams['SIZEN'];
}
}
if ($selectFields['TYPE']) {
$selectFields['USE_COUNT'] = true;
}
$selectFields = array_keys($selectFields);
$getListParams = array('select' => $selectFields, 'filter' => $filter, 'order' => array($by => $order));
if ($usePageNavigation) {
$countQuery = new Main\Entity\Query(Internals\DiscountCouponTable::getEntity());
$countQuery->addSelect(new Main\Entity\ExpressionField('CNT', 'COUNT(1)'));
if (!$ob->Update($ID, $arFields)) {
$lAdmin->AddGroupError(GetMessage("subscr_save_error") . $ob->LAST_ERROR, $ID);
}
break;
case "confirm":
$ob = new CSubscription();
$arFields = array("CONFIRMED" => "Y");
if (!$ob->Update($ID, $arFields)) {
$lAdmin->AddGroupError(GetMessage("subscr_save_error") . $ob->LAST_ERROR, $ID);
}
break;
}
}
}
$cData = new CSubscription();
$rsData = $cData->GetList(array($by => $order), $arFilter, array("nPageSize" => CAdminResult::GetNavSize($sTableID)));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("subscr_nav")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "align" => "right", "default" => true), array("id" => "DATE_INSERT", "content" => GetMessage("POST_DATE_INSERT"), "sort" => "date_insert", "default" => true), array("id" => "EMAIL", "content" => GetMessage("subscr_addr"), "sort" => "email", "default" => true), array("id" => "USER_ID", "content" => GetMessage("subscr_user"), "sort" => "user", "default" => true), array("id" => "CONFIRMED", "content" => GetMessage("subscr_conf"), "sort" => "conf", "default" => true), array("id" => "ACTIVE", "content" => GetMessage("subscr_act"), "sort" => "act", "default" => true), array("id" => "FORMAT", "content" => GetMessage("subscr_fmt"), "sort" => "fmt", "default" => true), array("id" => "DATE_UPDATE", "content" => GetMessage("subscr_updated"), "sort" => "date_update", "default" => false), array("id" => "DATE_CONFIRM", "content" => GetMessage("subscr_conf_time"), "sort" => "date_confirm", "default" => false), array("id" => "CONFIRM_CODE", "content" => GetMessage("subscr_conf_code"), "sort" => "confirm_code", "default" => false)));
while ($arRes = $rsData->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arRes);
if ($f_USER_ID > 0) {
$strUser = "******"/bitrix/admin/user_edit.php?ID=" . $f_USER_ID . "&lang=" . LANG . "\" title=\"" . GetMessage("subscr_user_edit_title") . "\">" . $f_USER_ID . "</a>] (" . $f_USER_LOGIN . ") " . $f_USER_NAME . " " . $f_USER_LAST_NAME;
} else {
$strUser = GetMessage("subscr_adm_anon");
}
$row->AddViewField("USER_ID", $strUser);
$row->AddCheckField("ACTIVE");
$row->AddInputField("EMAIL", array("size" => 20));
$row->AddViewField("EMAIL", '<a href="subscr_edit.php?ID=' . $f_ID . '&lang=' . LANG . '" title="' . GetMessage("subscr_upd") . '">' . $f_EMAIL . '</a>');
@unlink($_SERVER["DOCUMENT_ROOT"] . ($arSmile['TYPE'] == CSmile::TYPE_ICON ? CSmile::PATH_TO_ICON : CSmile::PATH_TO_SMILE) . $arSmile['SET_ID'] . '/' . $arSmile['IMAGE']);
}
}
}
}
}
if ($lAdmin->EditAction()) {
foreach ($FIELDS as $ID => $arFields) {
$ID = IntVal($ID);
if ($ID <= 0) {
continue;
}
CSmile::update($ID, array('LANG' => array(LANGUAGE_ID => $arFields['NAME']), 'SORT' => $arFields['SORT'], 'TYPING' => $arFields['TYPING']));
}
}
$dbResultList = CSmile::getList(array('SELECT' => array('ID', 'SET_ID', 'SET_NAME', 'TYPE', 'NAME', 'SORT', 'TYPING', 'IMAGE', 'IMAGE_WIDTH', 'IMAGE_HEIGHT'), 'FILTER' => $arFilter, 'ORDER' => array($by => $order), 'NAV_PARAMS' => array("nPageSize" => CAdminResult::GetNavSize($sTableID)), 'RETURN_RES' => 'Y'));
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("SMILE_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => GetMessage("SMILE_ID"), "sort" => "ID", "default" => true), array("id" => "SORT", "content" => GetMessage("SMILE_SORT"), "sort" => "SORT", "default" => true, "align" => "right"), array("id" => "NAME", "content" => GetMessage("SMILE_NAME"), "default" => true), array("id" => "TYPING", "content" => GetMessage("SMILE_TYPING"), "default" => true), array("id" => "ICON", "content" => GetMessage("SMILE_ICON"), "default" => true), array("id" => "SET_NAME", "content" => GetMessage("SMILE_SET_NAME"), "default" => true), array("id" => "TYPE", "content" => GetMessage('SMILE_TYPE'), "default" => true), array("id" => "IMAGE", "content" => GetMessage("SMILE_IMAGE_FILE"), "default" => false)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arForum = $dbResultList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arForum);
$row->AddField("ID", $f_ID);
$row->AddField("SORT", $f_SORT);
$row->AddField("TYPE", $f_TYPE == CSmile::TYPE_ICON ? GetMessage("SMILE_TYPE_ICON") : GetMessage("SMILE_TYPE_SMILE"));
$row->AddViewField("SET_NAME", '<a title="' . GetMessage("SMILE_EDIT_DESCR") . '" href="' . "smile_set_edit.php?ID=" . $f_SET_ID . "&lang=" . LANG . "&" . GetFilterParams("filter_") . '">' . (strlen($f_SET_NAME) > 0 ? $f_SET_NAME : GetMessage('SMILE_SET_NO_NAME', array('#ID#' => $f_SET_ID))) . '</a>');
$row->AddViewField("NAME", '<a title="' . GetMessage("SMILE_EDIT_DESCR") . '" href="' . "smile_edit.php?ID=" . $f_ID . "&lang=" . LANG . "&" . GetFilterParams("filter_") . '">' . (strlen($f_NAME) > 0 ? $f_NAME : GetMessage('SMILE_NO_NAME')) . '</a>');
$row->AddField("TYPING", $f_TYPING);
$row->AddField("ICON", "<img src=\"" . ($f_TYPE == CSmile::TYPE_ICON ? CSmile::PATH_TO_ICON : CSmile::PATH_TO_SMILE) . $f_SET_ID . "/" . $f_IMAGE . "\" border=\"0\" " . (IntVal($f_IMAGE_WIDTH) > 0 ? "width=\"" . $f_IMAGE_WIDTH . "\"" : "") . " " . (IntVal($f_IMAGE_HEIGHT) > 0 ? "height=\"" . $f_IMAGE_HEIGHT . "\"" : "") . ">");
$row->AddField("IMAGE", ($f_TYPE == CSmile::TYPE_ICON ? CSmile::PATH_TO_ICON : CSmile::PATH_TO_SMILE) . $f_SET_ID . "/" . $f_IMAGE);
if (strlen($filter_user) > 0) {
$arFilter["%USER_USER"] = $filter_user;
}
if (strlen($filter_currency) > 0) {
$arFilter["CURRENCY"] = $filter_currency;
}
if (strlen($filter_transact_date_from) > 0) {
$arFilter[">=TRANSACT_DATE"] = Trim($filter_transact_date_from);
}
if (strlen($filter_transact_date_to) > 0) {
$arFilter["<=TRANSACT_DATE"] = Trim($filter_transact_date_to);
}
if (IntVal($filter_order_id) > 0) {
$arFilter["ORDER_ID"] = IntVal($filter_order_id);
}
$dbTransactList = CSaleUserTransact::GetList(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("*"));
$dbTransactList = new CAdminResult($dbTransactList, $sTableID);
$dbTransactList->NavStart();
$lAdmin->NavText($dbTransactList->GetNavPrint(GetMessage("STA_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "default" => true), array("id" => "TRANSACT_DATE", "content" => GetMessage("STA_TRANS_DATE1"), "sort" => "transact_date", "default" => true), array("id" => "USER_ID", "content" => GetMessage('STA_USER1'), "sort" => "user_id", "default" => true), array("id" => "AMOUNT", "content" => GetMessage("STA_SUM"), "sort" => "amount", "default" => true), array("id" => "ORDER_ID", "content" => GetMessage("STA_ORDER"), "sort" => "order_id", "default" => true), array("id" => "TYPE", "content" => GetMessage("STA_TYPE"), "sort" => "description", "default" => true), array("id" => "DESCR", "content" => GetMessage("STA_DESCR"), "sort" => "", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arTransact = $dbTransactList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arTransact);
$row->AddField("ID", $f_ID);
$row->AddField("TRANSACT_DATE", $f_TRANSACT_DATE);
$fieldValue = "[<a href=\"/bitrix/admin/user_edit.php?ID=" . $f_USER_ID . "&lang=" . LANG . "\" title=\"" . GetMessage("STA_USER_INFO") . "\">" . $f_USER_ID . "</a>] ";
$fieldValue .= htmlspecialcharsEx($arTransact["USER_NAME"] . (strlen($arTransact["USER_NAME"]) <= 0 || strlen($arTransact["USER_LAST_NAME"]) <= 0 ? "" : " ") . $arTransact["USER_LAST_NAME"]) . "<br>";
$fieldValue .= htmlspecialcharsEx($arTransact["USER_LOGIN"]) . " ";
$fieldValue .= "<a href=\"mailto:" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "\" title=\"" . GetMessage("STA_MAILTO") . "\">" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "</a>";
$row->AddField("USER_ID", $fieldValue);
$row->AddField("AMOUNT", ($arTransact["DEBIT"] == "Y" ? "+" : "-") . SaleFormatCurrency($arTransact["AMOUNT"], $arTransact["CURRENCY"]) . "<br><small>" . ($arTransact["DEBIT"] == "Y" ? GetMessage("STA_TO_ACCOUNT") : GetMessage("STA_FROM_ACCOUNT")) . "</small>");
$arFilter["ORDER_ID"] = IntVal($filter_order_id);
}
if (strlen($filter_transact_date_to) > 0) {
if ($arDate = ParseDateTime($filter_transact_date_to, CSite::GetDateFormat("FULL", SITE_ID))) {
if (StrLen($filter_transact_date_to) < 11) {
$arDate["HH"] = 23;
$arDate["MI"] = 59;
$arDate["SS"] = 59;
}
$filter_transact_date_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
$arFilter["<=TRANSACT_DATE"] = $filter_transact_date_to;
} else {
$filter_transact_date_to = "";
}
}
$nPageSize = CAdminResult::GetNavSize($sTableID);
$dbTransactList = CSaleUserTransact::GetList(array($by => $order), $arFilter, false, array("nPageSize" => $nPageSize), array("*"));
$dbTransactList = new CAdminResult($dbTransactList, $sTableID);
$dbTransactList->NavStart();
$lAdmin->NavText($dbTransactList->GetNavPrint(GetMessage("STA_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "default" => true), array("id" => "TRANSACT_DATE", "content" => GetMessage("STA_TRANS_DATE1"), "sort" => "transact_date", "default" => true), array("id" => "USER_ID", "content" => GetMessage('STA_USER1'), "sort" => "user_id", "default" => true), array("id" => "AMOUNT", "content" => GetMessage("STA_SUM"), "sort" => "amount", "default" => true), array("id" => "ORDER_ID", "content" => GetMessage("STA_ORDER"), "sort" => "order_id", "default" => true), array("id" => "TYPE", "content" => GetMessage("STA_TYPE"), "sort" => "description", "default" => true), array("id" => "DESCR", "content" => GetMessage("STA_DESCR"), "sort" => "", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$LOCAL_TRANS_USER_CACHE = array();
if (in_array("DESCR", $arVisibleColumns)) {
$dbTransactList1 = CSaleUserTransact::GetList(array($by => $order), $arFilter, false, array("nPageSize" => $nPageSize), array("ID", "EMPLOYEE_ID"));
$arTrUsers = array();
while ($arTransact = $dbTransactList1->Fetch()) {
$tmpTrans[] = $arTransact;
if (IntVal($arTransact["EMPLOYEE_ID"]) > 0 && !in_array($arTransact["EMPLOYEE_ID"], $arTrUsers)) {
$arTrUsers[] = $arTransact["EMPLOYEE_ID"];
}
} else {
foreach ($arUniqueIndexes as $arIndexColumns) {
$arMissed = array_diff($arIndexColumns, $arSelectedFields);
if (count($arMissed) == 0) {
$bDelete = true;
$arPKColumns = $arIndexColumns;
break;
}
}
}
$bDelete = $bDelete && $RIGHT >= "W";
$obSchema = new CPerfomanceSchema();
$arChildren = $obSchema->GetChildren($table_name);
$arParents = $obSchema->GetParents($table_name);
CTimeZone::Disable();
$rsData = $obTable->GetList($arSelectedFields, $arFilter, array($by => $order), array("nPageSize" => CAdminResult::GetNavSize($sTableID)));
CTimeZone::Enable();
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("PERFMON_TABLE_PAGE")));
$max_display_url = COption::GetOptionInt("perfmon", "max_display_url");
while ($arRes = $rsData->Fetch()) {
$row =& $lAdmin->AddRow($arRes["ID"], $arRes);
$arRowPK = array();
foreach ($arFields as $FIELD_NAME => $FIELD_TYPE) {
if (strlen($arRes[$FIELD_NAME]) > 0) {
if ($FIELD_TYPE == "int") {
if ($_REQUEST["mode"] == "excel") {
$val = number_format($arRes[$FIELD_NAME], 0, "", "");
} else {
$val = str_replace(" ", " ", number_format($arRes[$FIELD_NAME], 0, "", " "));
/**
* @param bool|string $table_id
* @param int|array $nPageSize
* @param string $list_url
* @return int
*/
function GetNavSize($table_id = false, $nPageSize = 20, $list_url = '')
{
$list_url = (string) $list_url;
if ($list_url != '') {
if (!is_array($nPageSize)) {
$nPageSize = array('nPageSize' => $nPageSize);
}
$nPageSize['sNavID'] = $list_url;
}
return parent::GetNavSize($table_id, $nPageSize);
}
if ($ar = $res->Fetch()) {
$DB->StartTransaction();
if (!CTestAttempt::Delete($ID)) {
$DB->Rollback();
$lAdmin->AddGroupError(GetMessage("LEARNING_DELETE_ERROR"), $ID);
} else {
CGradeBook::RecountAttempts($ar["STUDENT_ID"], $ar["TEST_ID"]);
}
$DB->Commit();
}
break;
}
}
}
// fetch data
$rsData = CTestAttempt::GetList(array($by => $order), $arFilter, array(), array('nPageSize' => CAdminResult::GetNavSize($sTableID)));
$rsData = new CAdminResult($rsData, $sTableID);
// navigation string setup
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("LEARNING_ADMIN_RESULTS")));
// list header
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "default" => true), array("id" => "USER_NAME", "content" => GetMessage('LEARNING_ADMIN_STUDENT'), "sort" => "student_id", "default" => true), array("id" => "TEST_NAME", "content" => GetMessage('LEARNING_ADMIN_TEST'), "sort" => "test_name", "default" => true), array("id" => "DATE_START", "content" => GetMessage('LEARNING_ADMIN_DATE_START'), "sort" => "date_start", "default" => true), array("id" => "DATE_END", "content" => GetMessage('LEARNING_ADMIN_DATE_END'), "sort" => "date_end", "default" => true), array("id" => "STATUS", "content" => GetMessage('LEARNING_ADMIN_STATUS'), "sort" => "status", "default" => true), array("id" => "QUESTIONS", "content" => Getmessage('LEARNING_ADMIN_QUESTIONS'), "sort" => "questions", "default" => true, "align" => "center"), array("id" => "COMPLETED", "content" => Getmessage('LEARNING_ADMIN_COMPLETED'), "sort" => "completed", "default" => true), array("id" => "SCORE", "content" => GetMessage('LEARNING_ADMIN_SCORE'), "sort" => "score", "default" => true), array("id" => "MAX_SCORE", "content" => GetMessage('LEARNING_ADMIN_MAX_SCORE'), "sort" => "max_score", "default" => true)));
// building list
while ($arRes = $rsData->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arRes);
$row->AddCalendarField("DATE_START");
$row->AddCalendarField("DATE_END");
$row->AddSelectField("STATUS", $arStatus);
$row->AddCheckField("COMPLETED");
$row->AddInputField("SCORE", array("size" => "3"));
$row->AddInputField("MAX_SCORE", array("size" => "3"));
$row->AddViewField("ID", '<a href="learn_test_result_admin.php?lang=' . LANG . '&ATTEMPT_ID=' . $f_ID . '">' . $f_ID . '</a>');
}
$ID = IntVal($ID);
switch ($_REQUEST['action']) {
case "delete":
@set_time_limit(0);
$DB->StartTransaction();
if (!CControllerLog::Delete($ID)) {
$DB->Rollback();
$lAdmin->AddGroupError(GetMessage("CTRL_LOG_ADMIN_ERR_DELETE"), $ID);
}
$DB->Commit();
break;
}
}
}
$rsData = CControllerLog::GetList(array($by => $order), $arFilter, array("nPageSize" => CAdminResult::GetNavSize($sTableID)));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("CTRL_LOG_ADMIN_PAGETITLE")));
$arHeaders = array();
$arHeaders[] = array("id" => "TIMESTAMP_X", "content" => GetMessage("CTRL_LOG_ADMIN_COLUMN_CREATED"), "default" => true, "sort" => "timestamp_x");
$arHeaders[] = array("id" => "NAME", "content" => GetMessage("CTRL_LOG_ADMIN_COLUMN_NAME"), "default" => true, "sort" => "name");
$arHeaders[] = array("id" => "CONTROLLER_MEMBER_NAME", "content" => GetMessage("CTRL_LOG_ADMIN_FILTER_CLIENT"), "default" => true, "sort" => "controller_member_name");
$arHeaders[] = array("id" => "STATUS", "content" => GetMessage("CTRL_LOG_ADMIN_FILTER_STATUS"), "default" => true, "sort" => "status");
$arHeaders[] = array("id" => "TASK_NAME", "content" => GetMessage("CTRL_LOG_ADMIN_FILTER_TASK"), "default" => true, "sort" => "task_name");
$arHeaders[] = array("id" => "USER", "content" => GetMessage("CTRL_LOG_ADMIN_COLUMN_USER"), "default" => true);
$arHeaders[] = array("id" => "DESCRIPTION", "content" => GetMessage("CTRL_LOG_ADMIN_FILTER_DESC"));
$arHeaders[] = array("id" => "ID", "content" => "ID", "default" => true, "sort" => "id");
$lAdmin->AddHeaders($arHeaders);
while ($arRes = $rsData->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arRes);
}
if ($lAdmin->EditAction()) {
foreach ($FIELDS as $ID => $arFields) {
$ID = IntVal($ID);
if ($ID <= 0) {
continue;
}
CSmileSet::update($ID, array('LANG' => array(LANGUAGE_ID => $arFields['NAME']), 'STRING_ID' => $arFields['STRING_ID'], 'SORT' => $arFields['SORT']));
}
}
if (isset($_REQUEST['GALLERY_ID'])) {
$arFilter['PARENT_ID'] = intval($_REQUEST['GALLERY_ID']);
} else {
LocalRedirect("smile_gallery.php?lang=" . LANG);
}
$dbResultList = CSmileSet::getList(array('SELECT' => array('ID', 'STRING_ID', 'NAME', 'SORT', 'SMILE_COUNT'), 'FILTER' => $arFilter, 'ORDER' => array($by => $order), 'NAV_PARAMS' => array("nPageSize" => CAdminResult::GetNavSize($sTableID)), 'RETURN_RES' => 'Y'));
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("SMILE_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => GetMessage("SMILE_ID"), "sort" => "ID", "default" => false), array("id" => "NAME", "content" => GetMessage("SMILE_NAME"), "default" => true), array("id" => "STRING_ID", "content" => GetMessage("SMILE_STRING_ID"), "default" => false), array("id" => "SORT", "content" => GetMessage("SMILE_SORT"), "sort" => "SORT", "default" => true, "align" => "right"), array("id" => "SMILE_COUNT", "content" => GetMessage("SMILE_SMILE_COUNT"), "sort" => "SMILE_COUNT", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arForum = $dbResultList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arForum);
$row->AddField("ID", $f_ID);
$row->AddField("SORT", $f_SORT);
$row->AddViewField("NAME", '<a title="' . GetMessage("SMILE_EDIT_DESCR") . '" href="' . "smile.php?SET_ID=" . $f_ID . "&lang=" . LANG . "&" . GetFilterParams("filter_") . '">' . (strlen($f_NAME) > 0 ? $f_NAME : GetMessage('SMILE_SET_NAME', array('#ID#' => $f_ID))) . '</a>');
$row->AddViewField("SMILE_COUNT", $f_SMILE_COUNT);
$row->AddInputField("NAME", array("size" => 20));
$row->AddInputField("STRING_ID", array("size" => 20));
$row->AddInputField("SORT", array("size" => 5));
if (in_array($f_STRING_ID, array('bitrix_main'))) {
if ($result->isSuccess()) {
Application::getConnection()->commitTransaction();
} else {
$lAdmin->AddGroupError(implode('\\n', $result->getErrorMessages()));
}
}
break;
}
}
}
$headers = array(array("id" => "DATE_PAID", "content" => GetMessage("SALE_ORDER_DATE_PAID"), "sort" => "DATE_PAID", "default" => true), array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "ORDER_ID", "content" => GetMessage("SALE_ORDER_ID"), "sort" => "ORDER_ID", "default" => true), array("id" => "ACCOUNT_NUMBER", "content" => GetMessage("SALE_ACCOUNT_NUMBER"), "sort" => "ORDER.ACCOUNT_NUMBER", "default" => false), array("id" => "ORDER_USER_NAME", "content" => GetMessage("SALE_ORDER_USER_NAME"), "sort" => "ORDER_USER_NAME", "default" => true), array("id" => "PAID", "content" => GetMessage("SALE_ORDER_PAID"), "sort" => "PAID", "default" => true), array("id" => "PAY_SYSTEM_NAME", "content" => GetMessage("SALE_ORDER_PAY_SYSTEM_NAME"), "sort" => "PAY_SYSTEM_NAME", "default" => true), array("id" => "SUM", "content" => GetMessage("SALE_ORDER_SUM"), "sort" => "SUM", "default" => true), array("id" => "COMPANY_BY", "content" => GetMessage("SALE_ORDER_COMPANY_BY"), "sort" => "COMPANY_BY.NAME", "default" => true), array("id" => "PAY_VOUCHER_NUM", "content" => GetMessage("SALE_ORDER_PAY_VOUCHER_NUM"), "sort" => "PAY_VOUCHER_NUM", "default" => true), array("id" => "RESPONSIBLE_BY", "content" => GetMessage("SALE_ORDER_RESPONSIBLE_BY"), "sort" => "", "default" => true), array("id" => "PS_STATUS", "content" => GetMessage("SALE_ORDER_PS_STATUS"), "sort" => "PS_STATUS", "default" => false), array("id" => "PS_STATUS_CODE", "content" => GetMessage("SALE_ORDER_PS_STATUS_CODE"), "sort" => "PS_STATUS_CODE", "default" => false), array("id" => "PS_STATUS_DESCRIPTION", "content" => GetMessage("SALE_ORDER_PS_STATUS_DESCRIPTION"), "sort" => "PS_STATUS_DESCRIPTION", "default" => false), array("id" => "PS_STATUS_MESSAGE", "content" => GetMessage("SALE_ORDER_PS_STATUS_MESSAGE"), "sort" => "PS_STATUS_MESSAGE", "default" => false), array("id" => "PS_SUM", "content" => GetMessage("SALE_ORDER_PS_SUM"), "sort" => "PS_SUM", "default" => false), array("id" => "PS_CURRENCY", "content" => GetMessage("SALE_ORDER_PS_CURRENCY"), "sort" => "PS_CURRENCY", "default" => false), array("id" => "PS_RESPONSE_DATE", "content" => GetMessage("SALE_ORDER_PS_RESPONSE_DATE"), "sort" => "PS_RESPONSE_DATE", "default" => false), array("id" => "PAY_VOUCHER_DATE", "content" => GetMessage("SALE_ORDER_PAY_VOUCHER_DATE"), "sort" => "PAY_VOUCHER_DATE", "default" => false), array("id" => "DATE_PAY_BEFORE", "content" => GetMessage("SALE_ORDER_DATE_PAY_BEFORE"), "sort" => "DATE_PAY_BEFORE", "default" => false), array("id" => "DATE_BILL", "content" => GetMessage("SALE_ORDER_DATE_BILL"), "sort" => "DATE_BILL", "default" => false), array("id" => "PAY_SYSTEM_NAME", "content" => GetMessage("SALE_ORDER_PAY_SYSTEM_NAME"), "sort" => "PAY_SYSTEM_NAME", "default" => false));
$select = array('*', 'COMPANY_BY_NAME' => 'COMPANY_BY.NAME', 'RESPONSIBLE_BY_NAME' => 'RESPONSIBLE_BY.NAME', 'RESPONSIBLE_BY_LAST_NAME' => 'RESPONSIBLE_BY.LAST_NAME', 'ORDER_ACCOUNT_NUMBER' => 'ORDER.ACCOUNT_NUMBER', 'ORDER_USER_NAME' => 'ORDER.USER.NAME', 'ORDER_USER_LAST_NAME' => 'ORDER.USER.LAST_NAME', 'ORDER_USER_ID' => 'ORDER.USER_ID');
$params = array('select' => $select, 'filter' => $arFilter, 'order' => array($by => $order));
$usePageNavigation = true;
$navyParams = array();
$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($tableId));
if ($navyParams['SHOW_ALL']) {
$usePageNavigation = false;
} else {
$navyParams['PAGEN'] = (int) $navyParams['PAGEN'];
$navyParams['SIZEN'] = (int) $navyParams['SIZEN'];
}
if ($usePageNavigation) {
$params['limit'] = $navyParams['SIZEN'];
$params['offset'] = $navyParams['SIZEN'] * ($navyParams['PAGEN'] - 1);
}
$totalPages = 0;
if ($usePageNavigation) {
$countQuery = new \Bitrix\Main\Entity\Query(PaymentTable::getEntity());
$countQuery->addSelect(new \Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(1)'));
$countQuery->setFilter($params['filter']);
if(in_array("PREVIEW_TEXT", $arSelectedFields))
$arSelectedFields[] = "PREVIEW_TEXT_TYPE";
if(in_array("DETAIL_TEXT", $arSelectedFields))
$arSelectedFields[] = "DETAIL_TEXT_TYPE";
$arSelectedFields[] = "LOCK_STATUS";
$arSelectedFields[] = "WF_NEW";
$arSelectedFields[] = "WF_STATUS_ID";
$arSelectedFields[] = "DETAIL_PAGE_URL";
$arSelectedFields[] = "SITE_ID";
$arSelectedFields[] = "CODE";
$arSelectedFields[] = "EXTERNAL_ID";
$arSelectedFields[] = "NAME";
$arSelectedFields[] = "XML_ID";
$rsData = CIBlockElement::GetList($arOrder, $arFilter, false, array("nPageSize"=>CAdminResult::GetNavSize($sTableID)), $arSelectedFields);
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint($arIBlock["ELEMENTS_NAME"]));
function GetElementName($ID)
{
$ID = IntVal($ID);
static $cache = array();
if(!array_key_exists($ID, $cache) && $ID > 0)
{
$rsElement = CIBlockElement::GetList(array(), array("ID"=>$ID, "SHOW_HISTORY"=>"Y"), false, false, array("ID","IBLOCK_ID","NAME"));
$cache[$ID] = $rsElement->GetNext();
}
return $cache[$ID];
}
function getDataSource($arOrder, $arFilter, $arSelect)
{
return CPerfomanceHit::GetList($arOrder, $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($this->sTableID)), $arSelect);
}
$arSitesShop[] = array("ID" => $key, "NAME" => $val["NAME"]);
}
}
if (empty($arSitesShop)) {
$arSitesShop = $arSites;
}
$arCountry = GetCountryArray();
$arCountry["reference_id"] = array_flip($arCountry["reference_id"]);
/*
* select all user (byuers)
*/
$arHeaders = array(array("id" => "USER_ID", "content" => "ID", "sort" => "USER_ID"), array("id" => "BUYER", "content" => GetMessage("BUYER_ROW_BUYER"), "sort" => "NAME", "default" => true), array("id" => "LOGIN", "content" => GetMessage("BUYER_ROW_LOGIN"), "sort" => "LOGIN"), array("id" => "LAST_NAME", "content" => GetMessage("BUYER_ROW_LAST"), "sort" => "LAST_NAME"), array("id" => "NAME", "content" => GetMessage("BUYER_ROW_NAME"), "sort" => "NAME"), array("id" => "SECOND_NAME", "content" => GetMessage("BUYER_ROW_SECOND"), "sort" => "SECOND_NAME"), array("id" => "EMAIL", "content" => GetMessage("BUYER_ROW_MAIL"), "sort" => "EMAIL", "default" => true), array("id" => "PERSONAL_PHONE", "content" => GetMessage("BUYER_ROW_PHONE"), "sort" => "PERSONAL_PHONE", "default" => true), array("id" => "LAST_LOGIN", "content" => GetMessage('BUYER_ROW_LAST_LOGIN'), "sort" => "LAST_LOGIN", "default" => false), array("id" => "DATE_REGISTER", "content" => GetMessage('BUYER_ROW_DATE_REGISTER'), "sort" => "DATE_REGISTER", "default" => true), array("id" => "LAST_ORDER_DATE", "content" => GetMessage('BUYER_ROW_LAST_ORDER_DATE'), "sort" => "LAST_ORDER_DATE", "default" => true), array("id" => "ORDER_COUNT", "content" => GetMessage('BUYER_ROW_COUNT_ORDER'), "sort" => "ORDER_COUNT", "default" => true, "align" => "right"), array("id" => "ORDER_SUM", "content" => GetMessage('BUYER_ROW_SUM_ORDER'), "sort" => "ORDER_SUM", "default" => true, "align" => "right"), array("id" => "GROUPS_ID", "content" => GetMessage('BUYER_ROW_GROUP')));
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$arOrderBuyer[$by] = $order;
$dbUsersList = CSaleUser::GetBuyersList($arOrderBuyer, $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("ID", "LID", "ACTIVE", "DATE_REGISTER", "LOGIN", "EMAIL", "NAME", "LAST_NAME", "SECOND_NAME", "PERSONAL_PHONE", "USER_ID", "LAST_LOGIN", "ORDER_COUNT", "ORDER_SUM", "CURRENCY", "LAST_ORDER_DATE"));
$dbUsersList = new CAdminResult($dbUsersList, $sTableID);
$dbUsersList->NavStart();
$lAdmin->NavText($dbUsersList->GetNavPrint(GetMessage("BUYER_PRLIST")));
while ($arBuyers = $dbUsersList->Fetch()) {
$row =& $lAdmin->AddRow($arBuyers["USER_ID"], $arBuyers, "sale_buyers_profile.php?USER_ID=" . $arBuyers["USER_ID"] . "&lang=" . LANGUAGE_ID, GetMessage("BUYER_SUB_ACTION_PROFILE"));
$profile = '<a href="sale_buyers_profile.php?USER_ID=' . $arBuyers["USER_ID"] . '&lang=' . LANGUAGE_ID . '">' . $arBuyers["USER_ID"] . '</a>';
$row->AddField("USER_ID", $profile);
if (floatVal($arBuyers["ORDER_SUM"]) > 0 && in_array("ORDER_SUM", $arVisibleColumns)) {
$row->AddField("ORDER_SUM", SaleFormatCurrency($arBuyers["ORDER_SUM"], $arBuyers["CURRENCY"]));
}
if (floatVal($arBuyers["ORDER_COUNT"]) <= 0) {
$row->AddField("ORDER_COUNT", ' ');
}
if (in_array("GROUPS_ID", $arVisibleColumns)) {
$strUserGroup = '';
$arCounters[$key] = $arCounter;
$arHeaders[] = array("id" => $key, "content" => htmlspecialcharsex($arCounter["NAME"]), "sort" => $key, "align" => $arCounter["COUNTER_FORMAT"] == "F" ? "right" : "left");
}
$USER_FIELD_MANAGER->AdminListAddHeaders($entity_id, $arHeaders);
$lAdmin->AddHeaders($arHeaders);
$arSelect = $lAdmin->GetVisibleHeaderColumns();
$arSelect[] = "ID";
$arSelect[] = "DISCONNECTED";
$arSelect[] = "SHARED_KERNEL";
if (in_array("MODIFIED_BY", $arSelect)) {
$arSelect[] = "MODIFIED_BY_USER";
}
if (in_array("CREATED_BY", $arSelect)) {
$arSelect[] = "CREATED_BY_USER";
}
$rsData = CControllerMember::GetList(array($by => $order), $arFilter, $arSelect, array(), array("nPageSize" => CAdminResult::GetNavSize($sTableID)));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("CTRL_MEMB_ADMIN_NAVSTRING")));
while ($arRes = $rsData->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arRes);
$USER_FIELD_MANAGER->AddUserFields($entity_id, $arRes, $row);
$row->AddViewField("MODIFIED_BY", '[<a href="user_edit.php?ID=' . $f_MODIFIED_BY . '">' . $f_MODIFIED_BY . '</a>] ' . $f_MODIFIED_BY_USER);
$row->AddViewField("CREATED_BY", '[<a href="user_edit.php?ID=' . $f_CREATED_BY . '">' . $f_CREATED_BY . '</a>] ' . $f_CREATED_BY_USER);
$row->AddCheckField("ACTIVE");
if (ControllerIsSharedMode()) {
$row->AddCheckField("SHARED_KERNEL");
}
$row->AddInputField("NAME", array("size" => "35"));
$row->AddInputField("URL", array("size" => "35"));
if ($f_DISCONNECTED == 'Y') {
function NavStart($nPageSize = 20, $bShowAll = true, $iNumPage = false)
{
if ($this->table_id) {
if ($_REQUEST["mode"] == "excel") {
return;
}
$nSize = CAdminResult::GetNavSize($this->table_id, $nPageSize);
if (is_array($nPageSize)) {
$this->nInitialSize = $nPageSize["nPageSize"];
$nPageSize["nPageSize"] = $nSize;
} else {
$this->nInitialSize = $nPageSize;
$nPageSize = $nSize;
}
}
parent::NavStart($nPageSize, $bShowAll, $iNumPage);
}
if (!CCatalogContractor::Delete($ID)) {
$DB->Rollback();
if ($ex = $APPLICATION->GetException()) {
$lAdmin->AddGroupError($ex->GetString(), $ID);
} else {
$lAdmin->AddGroupError(GetMessage("ERROR_DELETING_TYPE"), $ID);
}
} else {
$DB->Commit();
}
break;
}
}
}
$arSelect = array("ID", "PERSON_TYPE", "PERSON_NAME", "EMAIL", "PHONE", "POST_INDEX", "COUNTRY", "CITY", "COMPANY", "INN", "KPP", "ADDRESS");
$arNavParams = isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel' ? false : array("nPageSize" => CAdminResult::GetNavSize($sTableID));
if (!isset($by)) {
$by = 'ID';
}
if (!isset($order)) {
$order = 'ASC';
}
$dbResultList = CCatalogContractor::GetList(array($by => $order), $arFilter, false, $arNavParams, $arSelect);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("group_admin_nav")));
$arHeaders = array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array('id' => 'PERSON_TYPE', 'content' => GetMessage('CONTRACTOR_TYPE'), 'sort' => 'PERSON_TYPE', 'default' => true), array('id' => 'PERSON_NAME', 'content' => GetMessage('CONTRACTOR_PERSON_TITLE'), 'sort' => 'PERSON_NAME', 'default' => true), array("id" => "COMPANY", "content" => GetMessage("CONTRACTOR_COMPANY"), "sort" => "COMPANY", "default" => true), array("id" => "EMAIL", "content" => GetMessage("CONTRACTOR_EMAIL"), "sort" => "EMAIL", "default" => true), array("id" => "PHONE", "content" => GetMessage("CONTRACTOR_PHONE"), "sort" => "PHONE", "default" => false), array("id" => "POST_INDEX", "content" => GetMessage("CONTRACTOR_POST_INDEX"), "sort" => "POST_INDEX", "default" => false), array("id" => "INN", "content" => GetMessage("CONTRACTOR_INN"), "sort" => "INN", "default" => false));
if (trim(GetMessage("CONTRACTOR_KPP")) != '') {
$arHeaders[] = array("id" => "KPP", "content" => GetMessage("CONTRACTOR_KPP"), "sort" => "KPP", "default" => false);
}
$arHeaders[] = array("id" => "ADDRESS", "content" => GetMessage("CONTRACTOR_ADDRESS"), "sort" => "ADDRESS", "default" => true);
return true;
}
$arFilter = array();
if (CheckFilter($arFilterFields)) {
$arFilter = array("ID" => $find_id, "TIMESTAMP_1" => $find_timestamp_1, "TIMESTAMP_2" => $find_timestamp_2, "LAST_LOGIN_1" => $find_last_login_1, "LAST_LOGIN_2" => $find_last_login_2, "ACTIVE" => $find_active, "LOGIN" => $find != '' && $find_type == "login" ? $find : $find_login, "NAME" => $find != '' && $find_type == "name" ? $find : $find_name, "EMAIL" => $find != '' && $find_type == "email" ? $find : $find_email, "KEYWORDS" => $find_keywords, "GROUPS_ID" => $find_group_id);
}
if (!$USER->CanDoOperation('view_all_users')) {
$arUserSubordinateGroups = array();
$arUserGroups = CUser::GetUserGroup($USER->GetID());
foreach ($arUserGroups as $grp) {
$arUserSubordinateGroups = array_merge($arUserSubordinateGroups, CGroup::GetSubordinateGroups($grp));
}
$arFilter["CHECK_SUBORDINATE"] = array_unique($arUserSubordinateGroups);
}
// инициализация списка - выборка данных
$rsData = CUser::GetList($by, $order, $arFilter, array("NAV_PARAMS" => array("nPageSize" => CAdminResult::GetNavSize($sTableID))));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
// установке параметров списка
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("PAGES")));
// заголовок списка
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "default" => true), array("id" => "TIMESTAMP_X", "content" => GetMessage('TIMESTAMP'), "sort" => "timestamp_x", "default" => true), array("id" => "ACTIVE", "content" => GetMessage('ACTIVE'), "sort" => "active", "default" => true), array("id" => "LOGIN", "content" => GetMessage("LOGIN"), "sort" => "login", "default" => true), array("id" => "NAME", "content" => GetMessage("NAME"), "sort" => "name", "default" => true), array("id" => "LAST_NAME", "content" => GetMessage("LAST_NAME"), "sort" => "last_name", "default" => true), array("id" => "EMAIL", "content" => GetMessage('EMAIL'), "sort" => "email", "default" => true), array("id" => "LAST_LOGIN", "content" => GetMessage("LAST_LOGIN"), "sort" => "last_login", "default" => true), array("id" => "DATE_REGISTER", "content" => GetMessage("DATE_REGISTER"), "sort" => "date_register"), array("id" => "PERSONAL_BIRTHDAY", "content" => GetMessage("PERSONAL_BIRTHDAY"), "sort" => "personal_birthday"), array("id" => "PERSONAL_PROFESSION", "content" => GetMessage("PERSONAL_PROFESSION"), "sort" => "personal_profession"), array("id" => "PERSONAL_WWW", "content" => GetMessage("PERSONAL_WWW"), "sort" => "personal_www"), array("id" => "PERSONAL_ICQ", "content" => GetMessage("PERSONAL_ICQ"), "sort" => "personal_icq"), array("id" => "PERSONAL_GENDER", "content" => GetMessage("PERSONAL_GENDER"), "sort" => "personal_gender"), array("id" => "PERSONAL_PHONE", "content" => GetMessage("PERSONAL_PHONE"), "sort" => "personal_phone"), array("id" => "PERSONAL_MOBILE", "content" => GetMessage("PERSONAL_MOBILE"), "sort" => "personal_mobile"), array("id" => "PERSONAL_CITY", "content" => GetMessage("PERSONAL_CITY"), "sort" => "personal_city"), array("id" => "PERSONAL_STREET", "content" => GetMessage("PERSONAL_STREET"), "sort" => "personal_street"), array("id" => "WORK_COMPANY", "content" => GetMessage("WORK_COMPANY"), "sort" => "work_company"), array("id" => "WORK_DEPARTMENT", "content" => GetMessage("WORK_DEPARTMENT"), "sort" => "work_department"), array("id" => "WORK_POSITION", "content" => GetMessage("WORK_POSITION"), "sort" => "work_position"), array("id" => "WORK_WWW", "content" => GetMessage("WORK_WWW"), "sort" => "work_www"), array("id" => "WORK_PHONE", "content" => GetMessage("WORK_PHONE"), "sort" => "work_phone"), array("id" => "WORK_CITY", "content" => GetMessage("WORK_CITY"), "sort" => "work_city"), array("id" => "XML_ID", "content" => GetMessage("XML_ID"), "sort" => "external_id"), array("id" => "EXTERNAL_AUTH_ID", "content" => GetMessage("EXTERNAL_AUTH_ID"))));
// построение списка
while ($arRes = $rsData->GetNext()) {
$f_ID = $arRes['ID'];
$row =& $lAdmin->AddRow($f_ID, $arRes);
$row->AddViewField("ID", $f_ID);
$row->AddCheckField("ACTIVE", false);
$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"]);
$arSelectFieldsMap = array_merge($arSelectFieldsMap, array_fill_keys($arSelectFields, true));
$mxKey = array_search('NAME_LID', $arSelectFields);
if (false !== $mxKey) {
unset($arSelectFields[$mxKey]);
$arSelectFields = array_values($arSelectFields);
}
$arLangList = array();
$arLangDefList = array();
if ($arSelectFieldsMap['NAME_LID']) {
$rsPriceLangs = CLangAdmin::GetList($by1 = "sort", $order1 = "asc");
while ($arPriceLang = $rsPriceLangs->Fetch()) {
$arLangList[$arPriceLang['LID']] = true;
$arLangDefList[$arPriceLang['LID']] = str_replace('#LANG#', htmlspecialcharsex($arPriceLang['NAME']), GetMessage('BT_CAT_GROUP_ADM_LANG_MESS'));
}
}
$arNavParams = isset($_REQUEST["mode"]) && 'excel' == $_REQUEST["mode"] ? false : array("nPageSize" => CAdminResult::GetNavSize($sTableID));
$dbResultList = CCatalogGroup::GetList(array($by => $order), array(), false, $arNavParams, $arSelectFields);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("group_admin_nav")));
$arUserList = array();
$arUserID = array();
$strNameFormat = CSite::GetNameFormat(true);
$arRows = array();
while ($arRes = $dbResultList->Fetch()) {
$arRes['ID'] = (int) $arRes['ID'];
if ($arSelectFieldsMap['CREATED_BY']) {
$arRes['CREATED_BY'] = (int) $arRes['CREATED_BY'];
if (0 < $arRes['CREATED_BY']) {
$arUserID[$arRes['CREATED_BY']] = true;
}
} elseif ($arItems["DELAY"] == "Y") {
$url .= "&productDelay[]=" . $arItems["PRODUCT_ID"];
} elseif ($arItems["SUBSCRIBE"] == "Y") {
$url .= "&productSub[]=" . $arItems["PRODUCT_ID"];
} else {
$url .= "&productNA[]=" . $arItems["PRODUCT_ID"];
}
}
if (count($arID) > 0) {
LocalRedirect($url);
die;
}
}
}
}
$dbResultList = CSaleBasket::GetLeave(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)));
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("SB_NAV")));
$lAdmin->AddHeaders(array(array("id" => "DATE_UPDATE_MAX", "content" => GetMessage("SB_DATE_UPDATE"), "sort" => "DATE_UPDATE_MAX", "default" => true), array("id" => "USER_ID", "content" => GetMessage("SB_USER"), "sort" => "user_id", "default" => true), array("id" => "PRICE_ALL", "content" => GetMessage("SB_PRICE_ALL"), "sort" => "PRICE_ALL", "default" => true, "align" => "right"), array("id" => "QUANTITY_ALL", "content" => GetMessage('SB_QUANTITY_ALL'), "sort" => "QUANTITY_ALL", "default" => false, "align" => "right"), array("id" => "PR_COUNT", "content" => GetMessage("SB_CNT"), "sort" => "PR_COUNT", "default" => true, "align" => "right"), array("id" => "LID", "content" => GetMessage("SB_LID"), "sort" => "LID", "default" => count($siteName) == 1 ? false : true), array("id" => "BASKET", "content" => GetMessage("SB_BASKET"), "sort" => "", "default" => true), array("id" => "BASKET_NAME", "content" => GetMessage("SB_BASKET_NAME"), "sort" => "", "default" => false), array("id" => "BASKET_QUANTITY", "content" => GetMessage("SB_BASKET_QUANTITY"), "sort" => "", "default" => false, "align" => "right"), array("id" => "BASKET_PRICE", "content" => GetMessage("SB_BASKET_PRICE"), "sort" => "", "default" => false, "align" => "right"), array("id" => "BASKET_AVAIBLE", "content" => GetMessage("BASKET_AVAIBLE"), "sort" => "", "default" => false), array("id" => "DATE_INSERT_MIN", "content" => GetMessage("SB_DATE_INSERT"), "sort" => "DATE_INSERT_MIN", "default" => true), array("id" => "FUSER_ID", "content" => GetMessage("SB_FUSER_ID"), "sort" => "FUSER_ID", "default" => false)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arBasket = $dbResultList->Fetch()) {
$row =& $lAdmin->AddRow($arBasket["ID"], $arBasket);
$row->AddField("ID", $arBasket["ID"]);
$fieldValue = GetMessage("SB_NOT_AUTH");
if (IntVal($arBasket["USER_ID"]) > 0) {
$fieldValue = "[<a href=\"/bitrix/admin/user_edit.php?ID=" . $arBasket["USER_ID"] . "&lang=" . LANG . "\" title=\"" . GetMessage("SB_USER_INFO") . "\">" . $arBasket["USER_ID"] . "</a>] ";
$fieldValue .= " (" . htmlspecialcharsEx($arBasket["USER_LOGIN"]) . ") ";
$fieldValue .= "<a href=\"sale_buyers_profile.php?USER_ID=" . $arBasket["USER_ID"] . "&lang=" . LANG . "\" title=\"" . GetMessage("SB_FUSER_INFO") . "\">" . htmlspecialcharsEx($arBasket["USER_NAME"] . (strlen($arBasket["USER_NAME"]) <= 0 || strlen($arBasket["USER_LAST_NAME"]) <= 0 ? "" : " ") . $arBasket["USER_LAST_NAME"]) . "</a><br />";
$fieldValue .= "<a href=\"mailto:" . htmlspecialcharsEx($arBasket["USER_EMAIL"]) . "\" title=\"" . GetMessage("SB_MAILTO") . "\">" . htmlspecialcharsEx($arBasket["USER_EMAIL"]) . "</a>";
}
}
unset($boolPriceInc);
}
$arSelectedFieldsMap = array();
foreach($arSelectedFields as $field)
$arSelectedFieldsMap[$field] = true;
if (isset($_REQUEST["mode"]) && $_REQUEST["mode"] == "excel")
{
$arNavParams = false;
}
else
{
$arNavParams = array("nPageSize"=>CAdminResult::GetNavSize(
$sTableID,
array('nPageSize' => 20, 'sNavID' => $APPLICATION->GetCurPage().'?IBLOCK_ID='.$IBLOCK_ID))
);
}
$rsData = CIBlockElement::GetList(
$arOrder,
$arFilter,
false,
$arNavParams,
$arSelectedFields
);
$rsData->SetTableID($sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(htmlspecialcharsbx($arIBlock["ELEMENTS_NAME"])));
}
break;
}
}
}
$arHeaders = array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "NAME", "content" => GetMessage("BLB_NAME"), "sort" => "NAME", "default" => true), array("id" => "DATE_CREATE", "content" => GetMessage('BLB_DATE_CREATE'), "sort" => "DATE_CREATE", "default" => true), array("id" => "DATE_UPDATE", "content" => GetMessage('BLB_DATE_UPDATE'), "sort" => "DATE_UPDATE", "default" => true), array("id" => "ACTIVE", "content" => GetMessage('BLB_ACTIVE'), "sort" => "ACTIVE", "default" => true), array("id" => "OWNER_INFO", "content" => GetMessage('BLB_OWNER_ID'), "sort" => "", "default" => true), array("id" => "SOCNET_GROUP_ID", "content" => GetMessage('BLB_SOCNET_GROUP_ID'), "sort" => "SOCNET_GROUP_ID"), array("id" => "URL", "content" => GetMessage('BLB_URL'), "sort" => "URL", "default" => true), array("id" => "GROUP_ID", "content" => GetMessage('BLB_GROUP_ID'), "sort" => "GROUP_ID", "default" => true), array("id" => "USE_SOCNET", "content" => GetMessage('BLB_USE_SOCNET'), "sort" => "USE_SOCNET", "default" => false));
$USER_FIELD_MANAGER->AdminListAddHeaders("BLOG_BLOG", $arHeaders);
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$arSelectedFields = array("ID", "NAME", "DATE_CREATE", "DATE_UPDATE", "ACTIVE", "OWNER_ID", "URL", "REAL_URL", "GROUP_ID", "OWNER_LOGIN", "OWNER_NAME", "OWNER_LAST_NAME", "OWNER_EMAIL", "GROUP_NAME", "GROUP_SITE_ID", "SOCNET_GROUP_ID", "USE_SOCNET");
foreach ($arVisibleColumns as $val) {
if (!in_array($val, $arSelectedFields)) {
$arSelectedFields[] = $val;
}
}
$dbResultList = CBlog::GetList(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), $arSelectedFields);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("BLB_GROUP_NAV")));
while ($arBlog = $dbResultList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arBlog, "/bitrix/admin/blog_blog_edit.php?ID=" . $f_ID . "&lang=" . LANGUAGE_ID, GetMessage("BLB_UPDATE_ALT"));
$row->AddField("ID", '<a href="/bitrix/admin/blog_blog_edit.php?ID=' . $f_ID . '&lang=' . LANGUAGE_ID . '" title="' . GetMessage("BLB_UPDATE_ALT") . '">' . $f_ID . '</a>');
$row->AddField("NAME", "<a href=\"" . CBlog::PreparePath($f_URL, $f_GROUP_SITE_ID, false, $f_OWNER_ID, $f_SOCNET_GROUP_ID) . "\">" . $f_NAME . "</a>");
$row->AddField("DATE_CREATE", $f_DATE_CREATE);
$row->AddField("DATE_UPDATE", $f_DATE_UPDATE);
$row->AddField("ACTIVE", $f_ACTIVE == "Y" ? GetMessage("BLB_YES") : GetMessage("BLB_NO"));
if (IntVal($f_OWNER_ID) > 0) {
$row->AddField("OWNER_INFO", "<a href=\"/bitrix/admin/user_edit.php?ID=" . $f_OWNER_ID . "&lang=" . LANG . "\">[" . $f_OWNER_ID . "] " . $f_OWNER_NAME . " " . $f_OWNER_LAST_NAME . " (" . $f_OWNER_LOGIN . ")</a>");
}
if (IntVal($f_SOCNET_GROUP_ID) > 0) {
$row->AddField("SOCNET_GROUP_ID", $f_SOCNET_GROUP_ID);
case "delete":
$entity_data_class::delete($ID);
break;
}
}
}
$arr = array('delete' => true);
$lAdmin->AddGroupActionTable($arr);
// select data
/** @var string $order */
$order = strtoupper($order);
$usePageNavigation = true;
if (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel') {
$usePageNavigation = false;
} else {
$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($sTableID, array('nPageSize' => 20, 'sNavID' => $APPLICATION->GetCurPage() . '?ENTITY_ID=' . $ENTITY_ID)));
if ($navyParams['SHOW_ALL']) {
$usePageNavigation = false;
} else {
$navyParams['PAGEN'] = (int) $navyParams['PAGEN'];
$navyParams['SIZEN'] = (int) $navyParams['SIZEN'];
}
}
$getListParams = array('select' => $lAdmin->GetVisibleHeaderColumns(), 'filter' => $filterValues, 'order' => array($by => $order));
unset($filterValues);
if ($usePageNavigation) {
$getListParams['limit'] = $navyParams['SIZEN'];
$getListParams['offset'] = $navyParams['SIZEN'] * ($navyParams['PAGEN'] - 1);
}
if ($usePageNavigation) {
$countQuery = new Query($entity_data_class::getEntity());
}
$DB->Commit();
break;
}
}
}
$arHeaders = array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "NAME", "content" => GetMessage("EXTRA_NAME"), "sort" => "NAME", "default" => true), array("id" => "PERCENTAGE", "content" => GetMessage('EXTRA_PERCENTAGE'), "sort" => "PERCENTAGE", "default" => true));
if (!$bReadOnly) {
$arHeaders[] = array("id" => "RECALCULATE", "content" => GetMessage("EXTRA_RECALCULATE"), "default" => true);
}
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
if (array_key_exists("mode", $_REQUEST) && $_REQUEST["mode"] == "excel") {
$arNavParams = false;
} else {
$arNavParams = array("nPageSize" => CAdminResult::GetNavSize($sTableID));
}
$dbResultList = CExtra::GetList(array($by => $order), $arFilter, false, $arNavParams);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("cat_extra_nav")));
while ($arExtra = $dbResultList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arExtra);
$row->AddField("ID", $f_ID);
if ($bReadOnly) {
$row->AddViewField("NAME", $f_NAME);
$row->AddViewField("PERCENTAGE", $f_PERCENTAGE);
} else {
$row->AddInputField("NAME", array("size" => "35"));
$row->AddInputField("PERCENTAGE", array("size" => "10"));
$row->AddCheckField("RECALCULATE");
"CREATED_BY" => false,
"DATE_CREATE" => false,
);
$arSelectFields = $lAdmin->GetVisibleHeaderColumns();
if (!in_array('ID', $arSelectFields))
$arSelectFields[] = 'ID';
$arSelectFields = array_values($arSelectFields);
$arSelectFieldsMap = array_merge($arSelectFieldsMap, array_fill_keys($arSelectFields, true));
$arCouponType = CCatalogDiscountCoupon::GetCoupontTypes(true);
$arNavParams = (isset($_REQUEST["mode"]) && 'excel' == $_REQUEST["mode"]
? false
: array("nPageSize" => CAdminResult::GetNavSize($sTableID))
);
$dbResultList = CCatalogDiscountCoupon::GetList(
array($by => $order),
$arFilter,
false,
$arNavParams,
$arSelectFields
);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("DSC_NAV")));
);
}
if(!$USER->CanDoOperation('view_all_users'))
{
$arUserSubordinateGroups = array();
$arUserGroups = CUser::GetUserGroup($USER->GetID());
foreach($arUserGroups as $grp)
$arUserSubordinateGroups = array_merge($arUserSubordinateGroups, CGroup::GetSubordinateGroups($grp));
$arFilter["CHECK_SUBORDINATE"] = array_unique($arUserSubordinateGroups);
}
$rsData = CUser::GetList($by, $order, $arFilter, array(
"NAV_PARAMS"=> array("nPageSize"=>CAdminResult::GetNavSize($sTableID)),
));
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("PAGES")));
$lAdmin->AddHeaders(array(
array("id"=>"ID", "content"=>"ID", "sort"=>"id", "default"=>true),
array("id"=>"TIMESTAMP_X", "content"=>GetMessage('TIMESTAMP'), "sort"=>"timestamp_x", "default"=>true),
array("id"=>"ACTIVE", "content"=>GetMessage('ACTIVE'), "sort"=>"active", "default"=>true),
array("id"=>"LOGIN", "content"=>GetMessage("LOGIN"), "sort"=>"login", "default"=>true),
array("id"=>"NAME", "content"=>GetMessage("NAME"), "sort"=>"name", "default"=>true),
array("id"=>"LAST_NAME", "content"=>GetMessage("LAST_NAME"), "sort"=>"last_name", "default"=>true),
}
}
break;
case "affiliate_0":
if (!CSaleAffiliate::ClearAffiliateSum($ID)) {
if ($ex = $APPLICATION->GetException()) {
$lAdmin->AddGroupError($ex->GetString(), $ID);
} else {
$lAdmin->AddGroupError(GetMessage("SAA_ERROR_CLEAR"), $ID);
}
}
break;
}
}
}
$dbResultList = CSaleAffiliate::GetList(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("ID", "SITE_ID", "USER_ID", "AFFILIATE_ID", "PLAN_ID", "ACTIVE", "TIMESTAMP_X", "DATE_CREATE", "PAID_SUM", "APPROVED_SUM", "PENDING_SUM", "ITEMS_NUMBER", "ITEMS_SUM", "LAST_CALCULATE", "FIX_PLAN", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL"));
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("SAA_AFFILIATES")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "SITE_ID", "content" => GetMessage("SAA_SITE"), "sort" => "SITE_ID", "default" => true), array("id" => "USER_ID", "content" => GetMessage("SAA_USER"), "sort" => "USER_ID", "default" => true), array("id" => "PLAN_ID", "content" => GetMessage("SAA_PLAN"), "sort" => "PLAN_ID", "default" => true), array("id" => "ACTIVE", "content" => GetMessage("SAA_ACTIVE"), "sort" => "ACTIVE", "default" => true), array("id" => "DATE_CREATE", "content" => GetMessage("SAA_DATE_CREATE"), "sort" => "DATE_CREATE", "default" => true), array("id" => "PAID_SUM", "content" => GetMessage("SAA_PAYED_SUM"), "sort" => "PAID_SUM", "default" => true), array("id" => "PENDING_SUM", "content" => GetMessage("SAA_PENDING_SUM"), "sort" => "PENDING_SUM", "default" => true), array("id" => "LAST_CALCULATE", "content" => GetMessage("SAA_LAST_CALCULATE"), "sort" => "LAST_CALCULATE", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$arSites = array();
$dbSiteList = CSite::GetList($b = "sort", $o = "asc");
while ($arSite = $dbSiteList->Fetch()) {
$arSites[$arSite["LID"]] = "[" . $arSite["LID"] . "] " . $arSite["NAME"];
}
$arPlans = array();
$dbPlanList = CSaleAffiliatePlan::GetList(array("NAME" => "ASC"), array(), false, false, array("ID", "NAME"));
while ($arPlan = $dbPlanList->Fetch()) {
$arPlans[$arPlan["ID"]] = "[" . $arPlan["ID"] . "] " . $arPlan["NAME"];
}
