本文整理汇总了PHP中CAdminResult::Fetch方法的典型用法代码示例。如果您正苦于以下问题:PHP CAdminResult::Fetch方法的具体用法?PHP CAdminResult::Fetch怎么用?PHP CAdminResult::Fetch使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CAdminResult
的用法示例。
在下文中一共展示了CAdminResult::Fetch方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: GetMessage
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage('SALE_DH_NAV_TITLE')));
$lAdmin->AddHeaders(array(
//array("id"=>"INSTALLED", "content" => GetMessage('SALE_DH_TABLE_ISCONFIG'), "sort"=>"ISCONFIG", "default"=>true),
array("id"=>"ACTIVE", "content" => GetMessage('SALE_DH_TABLE_ACTIVE'), "sort"=>"ACTIVE", "default"=>true),
array("id"=>"SORT", "content"=>GetMessage("SALE_DH_TABLE_SORT"), "sort"=>"SORT", "default"=>true),
array("id"=>"SID", "content"=>"SID", "sort"=>"SID", "default"=>true),
array("id"=>"NAME", "content" => GetMessage("SALE_DH_TABLE_NAME"), "sort"=>"NAME", "default"=>true),
array("id"=>"HANDLER", "content" => GetMessage("SALE_DH_TABLE_PATH"), "sort"=>"HANDLER", "default"=>true),
));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arDeliveryService = $dbResultList->Fetch())
{
$row =& $lAdmin->AddRow($arDeliveryService['SID'], $arDeliveryService, "sale_delivery_handler_edit.php?SID=".$arDeliveryService['SID']."&lang=".LANGUAGE_ID, GetMessage("SALE_EDIT_DESCR"));
$row->AddField("SID", $arDeliveryService['SID']);
//$row->AddViewField("INSTALLED", '<div class="lamp-'.($f_INSTALLED == "Y" ? "green" : "red").'"></div>');
if ($arDeliveryService['INSTALLED'] == 'Y')
{
$res = '';
$bUseTable = true;
foreach ($arDeliveryHandlersList[$arDeliveryService['SID']] as $siteID => $arHandler)
{
if ($siteID == 'ALL')
{
$res = '<div class="lamp-'.($arDeliveryService['ACTIVE'] == "Y" ? "green" : "red").'">';
示例2: LocalRedirect
}
}
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>";
}
$row->AddField("USER_ID", $fieldValue);
$row->AddField("LID", "[" . htmlspecialcharsbx($arBasket["LID"]) . "] " . htmlspecialcharsbx($siteName[$arBasket["LID"]]));
$row->AddField("PRICE_ALL", SaleFormatCurrency($arBasket["PRICE_ALL"], $arBasket["CURRENCY"]));
$fieldValue = "";
$productId = "";
$arFilterBasket = array("ORDER_ID" => false, "FUSER_ID" => $arBasket["FUSER_ID"], "LID" => $arBasket["LID"]);
示例3: CAdminResult
$dbRecords = new CAdminResult($dbRes, $sTableID_tab5);
$dbRecords->NavStart();
$lAdmin_tab5->NavText($dbRecords->GetNavPrint(GetMessage('SOD_HIST_LIST')));
$histdHeader = array(
array("id"=>"DATE_CREATE", "content"=>GetMessage("SOD_HIST_H_DATE"), "sort"=>"DATE_CREATE", "default"=>true),
array("id"=>"USER_ID", "content"=>GetMessage("SOD_HIST_H_USER"), "sort"=>"USER_ID", "default"=>true),
array("id"=>"TYPE", "content"=>GetMessage("SOD_HIST_TYPE"), "sort"=>"TYPE", "default"=>true),
array("id"=>"DATA", "content"=>GetMessage("SOD_HIST_DATA"), "sort"=>"", "default"=>true),
);
$lAdmin_tab5->AddHeaders($histdHeader);
$arOperations = array();
while ($arChangeRecord = $dbRecords->Fetch())
{
$row =& $lAdmin_tab5->AddRow($arChangeRecord["ID"], $arChangeRecord, '', '');
$stmp = MakeTimeStamp($arChangeRecord["DATE_CREATE"], "DD.MM.YYYY HH:MI:SS");
$row->AddField("DATE_CREATE", date("d.m.Y H:i", $stmp));
$row->AddField("USER_ID", GetFormatedUserName($arChangeRecord["USER_ID"], false));
$arRecord = CSaleOrderChange::GetRecordDescription($arChangeRecord["TYPE"], $arChangeRecord["DATA"]);
$row->AddField("TYPE", $arRecord["NAME"]);
$row->AddField("DATA", htmlspecialcharsbx($arRecord["INFO"]));
$arOperations[$arChangeRecord["TYPE"]] = $arRecord["NAME"];
}
示例4: array
}
$dbResultList = CCatalogStore::GetList(array($_REQUEST["by"] => $_REQUEST["order"]), array(), false, $arNavParams, $arSelect);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("group_admin_nav")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "TITLE", "content" => GetMessage("TITLE"), "sort" => "TITLE", "default" => true), array("id" => "ACTIVE", "content" => GetMessage("STORE_ACTIVE"), "sort" => "ACTIVE_FLAG", "default" => true), array("id" => "ADDRESS", "content" => GetMessage("ADDRESS"), "sort" => "ADDRESS", "default" => true), array("id" => "IMAGE_ID", "content" => GetMessage("STORE_IMAGE"), "sort" => "IMAGE_ID", "default" => false), array("id" => "DESCRIPTION", "content" => GetMessage("DESCRIPTION"), "sort" => "DESCRIPTION", "default" => true), array("id" => "GPS_N", "content" => GetMessage("GPS_N"), "sort" => "GPS_N", "default" => false), array("id" => "GPS_S", "content" => GetMessage("GPS_S"), "sort" => "GPS_S", "default" => false), array("id" => "PHONE", "content" => GetMessage("PHONE"), "sort" => "PHONE", "default" => true), array("id" => "SCHEDULE", "content" => GetMessage("SCHEDULE"), "sort" => "SCHEDULE", "default" => true), array("id" => "DATE_MODIFY", "content" => GetMessage("DATE_MODIFY"), "sort" => "DATE_MODIFY", "default" => true), array("id" => "MODIFIED_BY", "content" => GetMessage("MODIFIED_BY"), "sort" => "MODIFIED_BY", "default" => true), array("id" => "DATE_CREATE", "content" => GetMessage("DATE_CREATE"), "sort" => "DATE_CREATE", "default" => false), array("id" => "USER_ID", "content" => GetMessage("USER_ID"), "sort" => "USER_ID", "default" => false)));
$arSelectFields = $lAdmin->GetVisibleHeaderColumns();
if (!in_array('ID', $arSelectFields)) {
$arSelectFields[] = 'ID';
}
$arSelectFieldsMap = array_fill_keys($arSelectFields, true);
$arUserList = array();
$arUserID = array();
$strNameFormat = CSite::GetNameFormat(true);
$arRows = array();
while ($arSTORE = $dbResultList->Fetch()) {
$arSTORE['ID'] = intval($arSTORE['ID']);
if (array_key_exists('USER_ID', $arSelectFieldsMap)) {
$arSTORE['USER_ID'] = intval($arSTORE['USER_ID']);
if (0 < $arSTORE['USER_ID']) {
$arUserID[$arSTORE['USER_ID']] = true;
}
}
if (array_key_exists('MODIFIED_BY', $arSelectFieldsMap)) {
$arSTORE['MODIFIED_BY'] = intval($arSTORE['MODIFIED_BY']);
if (0 < $arSTORE['MODIFIED_BY']) {
$arUserID[$arSTORE['MODIFIED_BY']] = true;
}
}
$arRows[$arSTORE['ID']] = $row =& $lAdmin->AddRow($arSTORE['ID'], $arSTORE);
$row->AddField("ID", $arSTORE['ID']);
示例5: strcmp
else
$sort = 1;
if(strtoupper($order) == "ASC")
$ord = 1;
else
$ord = -1;
usort($arLogRecs, create_function('$a, $b', 'return strcmp($a['.$sort.'], $b['.$sort.'])*('.$ord.');'));
}
$rsData = new CAdminResult(null, $sTableID);
$rsData->InitFromArray($arLogRecs);
$rsData->NavStart();
$lAdmin->NavText($rsData->GetNavPrint(GetMessage("update_log_nav")));
$n = 0;
while($rec = $rsData->Fetch())
{
$row = &$lAdmin->AddRow(0, null);
$aDate = explode(" ", htmlspecialcharsbx($rec[1]));
$row->AddField("DATE", '<span style="white-space:nowrap">'.$aDate[0].'</span> '.$aDate[1]);
$row->AddField("DESCRIPTION", ($rec[3]<>""? '<a href="javascript:void(0)" onClick="jsUtils.ToggleDiv(\'descr_'.$n.'\')" title="'.GetMessage("HINT_WIND_EXEC_ALT").'">'.htmlspecialcharsbx($rec[2]).'</a>' : htmlspecialcharsbx($rec[2])).'<div id="descr_'.$n.'" style="display:none;">'.$rec[3].'</div>');
$s = "";
if($rec[0]=="S")
$s = '<div class="lamp-green" style="float:left"></div>'.GetMessage("SUP_HIST_SUCCESS");
elseif($rec[0]=="E")
$s = '<div class="lamp-red" style="float:left"></div>'.GetMessage("SUP_HIST_ERROR");
elseif($rec[0]=="N")
$s = '<div class="lamp-yellow" style="float:left"></div>'.GetMessage("SUP_HIST_NOTES");
示例6: while
while ($arPriceLang = $rsPriceLangs->Fetch()) {
$arLangList[$arPriceLang['LID']] = true;
$arLangDefList[$arPriceLang['LID']] = str_replace('#LANG#', htmlspecialcharsex($arPriceLang['NAME']), GetMessage('BT_CAT_GROUP_ADM_LANG_MESS'));
}
}
if (array_key_exists("mode", $_REQUEST) && $_REQUEST["mode"] == "excel") {
$arNavParams = false;
} else {
$arNavParams = 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")));
$arRows = array();
while ($arRes = $dbResultList->Fetch()) {
$arRows[$arRes['ID']] = $row =& $lAdmin->AddRow($arRes['ID'], $arRes);
$row->AddViewField("ID", '<a href="/bitrix/admin/cat_group_edit.php?lang=' . LANGUAGE_ID . '&ID=' . $arRes["ID"] . '&' . GetFilterParams("filter_") . '">' . $arRes["ID"] . '</a>');
if (!$bReadOnly) {
if (array_key_exists('NAME', $arSelectFieldsMap)) {
$row->AddInputField("NAME", array("size" => 30));
}
if (array_key_exists('SORT', $arSelectFieldsMap)) {
$row->AddInputField("SORT", array("size" => 3));
}
if (array_key_exists('XML_ID', $arSelectFieldsMap)) {
$row->AddInputField("XML_ID", array("size" => 30));
}
} else {
if (array_key_exists('NAME', $arSelectFieldsMap)) {
$row->AddViewField("NAME", '<a href="/bitrix/admin/cat_group_edit.php?lang=' . LANGUAGE_ID . '&ID=' . $arRes["ID"] . '&' . GetFilterParams("filter_") . '">' . htmlspecialcharsex($arRes['NAME']) . '</a>');
示例7: array
}
$arSelectFields = array_values($arSelectFields);
if (array_key_exists("mode", $_REQUEST) && $_REQUEST["mode"] == "excel") {
$arNavParams = false;
} else {
$arNavParams = array("nPageSize" => CAdminResult::GetNavSize($sTableID));
}
$dbResultList = CSaleDiscount::GetList(array($by => $order), $arFilter, false, $arNavParams, $arSelectFields);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("BT_SALE_DISCOUNT_LIST_MESS_NAV")));
$arUserList = array();
$arUserID = array();
$strNameFormat = CSite::GetNameFormat(true);
$arRows = array();
while ($arDiscount = $dbResultList->Fetch()) {
$arDiscount['ID'] = intval($arDiscount['ID']);
if (array_key_exists('CREATED_BY', $arSelectFieldsMap)) {
$arDiscount['CREATED_BY'] = intval($arDiscount['CREATED_BY']);
if (0 < $arDiscount['CREATED_BY']) {
$arUserID[$arDiscount['CREATED_BY']] = true;
}
}
if (array_key_exists('MODIFIED_BY', $arSelectFieldsMap)) {
$arDiscount['MODIFIED_BY'] = intval($arDiscount['MODIFIED_BY']);
if (0 < $arDiscount['MODIFIED_BY']) {
$arUserID[$arDiscount['MODIFIED_BY']] = true;
}
}
$arRows[$arDiscount['ID']] = $row =& $lAdmin->AddRow($arDiscount['ID'], $arDiscount, "sale_discount_edit.php?ID=" . $arDiscount['ID'] . "&lang=" . LANGUAGE_ID . GetFilterParams("filter_"), GetMessage("BT_SALE_DISCOUNT_LIST_MESS_EDIT_DISCOUNT"));
if (array_key_exists('DATE_CREATE', $arSelectFieldsMap)) {
示例8: CAdminResult
$params['offset'] = 0;
}
}
$dbResultList = new CAdminResult(PaymentTable::getList($params), $tableId);
if ($usePageNavigation) {
$dbResultList->NavStart($params['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
$dbResultList->NavRecordCount = $totalCount;
$dbResultList->NavPageCount = $totalPages;
$dbResultList->NavPageNomer = $navyParams['PAGEN'];
} else {
$dbResultList->NavStart();
}
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("group_admin_nav")));
$lAdmin->AddHeaders($headers);
$visibleHeaders = $lAdmin->GetVisibleHeaderColumns();
while ($payment = $dbResultList->Fetch()) {
$row =& $lAdmin->AddRow($payment['ID'], $payment);
$row->AddField("ID", "<a href=\"sale_order_payment_edit.php?order_id=" . $payment['ORDER_ID'] . "&payment_id=" . $payment['ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . $payment['ID'] . "</a>");
$row->AddField("ORDER_ID", "<a href=\"sale_order_edit.php?ID=" . $payment['ORDER_ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . $payment['ORDER_ID'] . "</a>");
$row->AddField("ACCOUNT_NUMBER", "<a href=\"sale_order_edit.php?ID=" . $payment['ORDER_ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . htmlspecialcharsbx($payment['ORDER_ACCOUNT_NUMBER']) . "</a>");
$row->AddField("SUM", \CCurrencyLang::CurrencyFormat($payment['SUM'], $payment['CURRENCY']));
$row->AddField("PAID", $payment['PAID'] == 'Y' ? GetMessage("PAYMENT_ORDER_PAID_YES") : GetMessage("PAYMENT_ORDER_PAID_NO"));
$row->AddField("PAY_SYSTEM_NAME", "<a href='sale_pay_system_edit.php?ID=" . $payment['PAY_SYSTEM_ID'] . "&lang=" . $lang . "'>" . htmlspecialcharsbx($payment['PAY_SYSTEM_NAME']) . "</a>");
$row->AddField("COMPANY_BY", "<a href='sale_pay_system_edit.php?ID=" . $payment['COMPANY_ID'] . "&lang=" . $lang . "'>" . htmlspecialcharsbx($payment['COMPANY_BY_NAME']) . "</a>");
$row->AddField("ORDER_USER_NAME", "<a href='/bitrix/admin/user_edit.php?ID=" . $payment['ORDER_USER_ID'] . "&lang=" . $lang . "'>" . htmlspecialcharsbx($payment['ORDER_USER_NAME']) . " " . htmlspecialcharsbx($payment['ORDER_USER_LAST_NAME']) . "</a>");
$row->AddField("RESPONSIBLE_BY", "<a href=\"user_edit.php?ID=" . $payment['RESPONSIBLE_ID'] . "\">" . htmlspecialcharsbx($payment['RESPONSIBLE_BY_NAME']) . " " . htmlspecialcharsbx($payment['RESPONSIBLE_BY_LAST_NAME']) . "</a>");
$arActions = array();
$arActions[] = array("ICON" => "edit", "TEXT" => GetMessage("EDIT_PAYMENT_ALT"), "ACTION" => $lAdmin->ActionRedirect("sale_order_payment_edit.php?order_id=" . $payment['ORDER_ID'] . "&payment_id=" . $payment['ID'] . "&lang=" . $lang . GetFilterParams("filter_") . ""), "DEFAULT" => true);
if (!$bReadOnly) {
$arActions[] = array("SEPARATOR" => true);
$arActions[] = array("ICON" => "delete", "TEXT" => GetMessage("DELETE_PAYMENT_ALT"), "ACTION" => "if(confirm('" . GetMessageJS('DELETE_PAYMENT_CONFIRM') . "')) " . $lAdmin->ActionDoGroup($payment['ID'], "delete", "order_id=" . $payment['ORDER_ID']));
示例9: array
if ($usePageNavigation) {
$dbOrderList->NavStart($getListParams['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
$dbOrderList->NavRecordCount = $totalCount;
$dbOrderList->NavPageCount = $totalPages;
$dbOrderList->NavPageNomer = $navyParams['PAGEN'];
} else {
$dbOrderList->NavStart();
}
// $dbOrderList->NavStart();
$lAdmin_tab3->NavText($dbOrderList->GetNavPrint(GetMessage('BUYER_ORDER_LIST')));
$orderHeader = array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "STATUS_ID", "content" => GetMessage("BUYERS_H_STATUS"), "sort" => "STATUS_ID", "default" => true), array("id" => "PAYED", "content" => GetMessage("BUYERS_H_PAID"), "sort" => "PAYED", "default" => true), array("id" => "ALLOW_DELIVERY", "content" => GetMessage("BUYER_LAST_H_ALLOW_DELIVERY"), "sort" => "", "default" => true), array("id" => "PRODUCT", "content" => GetMessage("BUYERS_H_ALL_PRODUCT"), "sort" => "", "default" => true), array("id" => "PRICE", "content" => GetMessage("BUYERS_H_SUM"), "sort" => "PRICE", "default" => true), array("id" => "DATE_INSERT", "content" => GetMessage("BUYERS_H_DATE_INSERT"), "sort" => "DATE_INSERT", "default" => true));
if (count($arSites) > 1) {
$orderHeader[] = array("id" => "LID", "content" => GetMessage("BUYERS_H_SITE"), "sort" => "LID", "default" => true);
}
$lAdmin_tab3->AddHeaders($orderHeader);
while ($arOrder = $dbOrderList->Fetch()) {
$row =& $lAdmin_tab3->AddRow($arOrder["ID"], $arOrder, "sale_order_view.php?ID=" . $arOrder["ID"] . "&lang=" . LANG, GetMessage("BUYERS_ORDER_EDIT"));
$orderLink = "<a href=\"sale_order_view.php?ID=" . $arOrder["ID"] . "&lang=" . LANG . "\">" . $arOrder["ID"] . "</a>";
$row->AddField("ID", $orderLink);
$status_id = "<a title=\"" . GetMessage('BUYERS_ORDER_DETAIL_PAGE') . "\" href=\"/bitrix/admin/sale_order_view.php?ID=" . $arOrder["ID"] . "&lang=" . LANG . "\">" . GetMessage('BUYERS_PREF') . $arOrder["ID"] . "</a>";
$status_id .= "<input type=\"hidden\" name=\"table_id\" value=\"" . $sTableID_tab3 . "\">";
$row->AddField("STATUS_ID", $status_id);
$payed = "";
$res = \Bitrix\Sale\Internals\PaymentTable::getList(array('order' => array('ID' => 'ASC'), 'filter' => array('ORDER_ID' => $arOrder['ID'])));
while ($payment = $res->fetch()) {
if (strval($payed) != "") {
$payed .= "<hr>";
}
$payed .= "[<a href='/bitrix/admin/sale_order_payment_edit.php?order_id=" . $arOrder['ID'] . "&payment_id=" . $payment["ID"] . "&lang=" . LANGUAGE_ID . "'>" . $payment["ID"] . "</a>], " . htmlspecialcharsbx($payment["PAY_SYSTEM_NAME"]) . ", " . ($payment["PAID"] == "Y" ? \Bitrix\Main\Localization\Loc::getMessage("SOB_PAYMENTS_PAID") : \Bitrix\Main\Localization\Loc::getMessage("SOB_PAYMENTS_UNPAID")) . ", " . (strlen($payment["PS_STATUS"]) > 0 ? \Bitrix\Main\Localization\Loc::getMessage("SOB_PAYMENTS_STATUS") . ": " . htmlspecialcharsbx($payment["PS_STATUS"]) . ", " : "") . '<span style="white-space:nowrap;">' . htmlspecialcharsex(SaleFormatCurrency($payment["SUM"], $payment["CURRENCY"])) . '<span>';
}
$row->AddField("PAYED", $payed);
示例10: array
break;
}
}
}
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "C_SORT", "content" => GetMessage("CVAT_SORT"), "sort" => "C_SORT", "default" => true), array("id" => "ACTIVE", "content" => GetMessage("CVAT_ACTIVE"), "sort" => "ACTIVE", "default" => true), array("id" => "NAME", "content" => GetMessage("CVAT_NAME"), "sort" => "NAME", "default" => true), array("id" => "RATE", "content" => GetMessage("CVAT_RATE"), "sort" => "RATE", "default" => true)));
$arSelectFields = $lAdmin->GetVisibleHeaderColumns();
if (!in_array('ID', $arSelectFields)) {
$arSelectFields[] = 'ID';
}
$arSelectFields = array_values($arSelectFields);
$arNavParams = isset($_REQUEST["mode"]) && 'excel' == $_REQUEST["mode"] ? false : array("nPageSize" => CAdminResult::GetNavSize($sTableID));
$dbResultList = CCatalogVat::GetListEx(array($by => $order), $arFilter, false, $arNavParams, $arSelectFields);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("CVAT_NAV")));
while ($arVAT = $dbResultList->Fetch()) {
$arVAT['ID'] = (int) $arVAT['ID'];
$row =& $lAdmin->AddRow($arVAT['ID'], $arVAT);
$row->AddField("ID", $arVAT['ID']);
if ($bReadOnly) {
$row->AddCheckField("ACTIVE", false);
$row->AddInputField("NAME", false);
$row->AddViewField("C_SORT", false);
} else {
$row->AddCheckField("ACTIVE");
$row->AddInputField("NAME", array("size" => 30));
$row->AddInputField("C_SORT", array("size" => 5));
$row->AddInputField("RATE", array("size" => 5));
}
$row->AddViewField("RATE", doubleval($arVAT['RATE']) . " %");
$arActions = array();
示例11: GetMessage
$dbSite = CSite::GetList($b = "SORT", $o = "ASC");
while ($arSite = $dbSite->Fetch()) {
$serverName = $arSite["SERVER_NAME"];
if (strLen($serverName) <= 0) {
if (defined("SITE_SERVER_NAME") && strlen(SITE_SERVER_NAME) > 0) {
$serverName = SITE_SERVER_NAME;
} else {
$serverName = COption::GetOptionString("main", "server_name", "");
}
if (strlen($serverName) <= 0) {
$serverName = $_SERVER["SERVER_NAME"];
}
}
$arServerName[$arSite["ID"]] = "http://" . $serverName;
}
while ($arComment = $dbResultList->Fetch()) {
$path = str_replace("#comment_id#", $arComment["ID"], $arComment["PATH"]);
if (!preg_match("/^[a-z]+:\\/\\//", $path)) {
$path = $arServerName[$arComment["BLOG_GROUP_SITE_ID"]] . $path;
}
$row =& $lAdmin->AddRow($arComment["ID"], $arComment, $path, GetMessage("BLB_VIEW_ALT"));
$row->AddField("ID", '<a href="' . $path . '" title="' . GetMessage("BLB_VIEW_ALT") . '">' . $arComment["ID"] . '</a>');
$row->AddField("DATE_CREATE", $arComment["DATE_CREATE"]);
$row->AddField("POST_TEXT", "<a href=\"" . $path . "\" title=\"" . htmlspecialcharsEx($arComment["POST_TEXT"]) . "\">" . htmlspecialcharsEx(TruncateText($arComment["POST_TEXT"], 150)) . "</a>");
$row->AddField("POST_TITLE", "<span title=\"" . htmlspecialcharsEx($arComment["POST_TITLE"]) . "\">" . htmlspecialcharsEx(TruncateText($arComment["POST_TITLE"], 50)) . "</span>");
$row->AddField("PUBLISH_STATUS", $arComment["PUBLISH_STATUS"] == "P" ? GetMessage("BLB_YES") : GetMessage("BLB_NO"));
if (IntVal($arComment["AUTHOR_ID"]) > 0) {
$row->AddField("AUTHOR_ID", "[<a href=\"/bitrix/admin/user_edit.php?ID=" . $arComment["AUTHOR_ID"] . "&lang=" . LANG . "\">" . $arComment["AUTHOR_ID"] . "</a>] " . htmlspecialcharsEx("(" . $arComment["USER_LOGIN"] . ") " . $arComment["USER_NAME"] . " " . $arComment["USER_LAST_NAME"]));
} elseif (strlen($arComment["AUTHOR_NAME"]) > 0) {
$row->AddField("AUTHOR_ID", htmlspecialcharsEx($arComment["AUTHOR_NAME"] . " (" . $arComment["AUTHOR_EMAIL"] . ")"));
}
示例12: CAdminResult
$rsData = new CAdminResult($rsData, $sTableID);
$rsData->bPostNavigation = true;
$rsData->NavStart();
$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();
示例13: array
if ($usePageNavigation) {
$dbResultList->NavStart($params['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
$dbResultList->NavRecordCount = $totalCount;
$dbResultList->NavPageCount = $totalPages;
$dbResultList->NavPageNomer = $navyParams['PAGEN'];
} else {
$dbResultList->NavStart();
}
//$dbResultList = new CAdminResult($shipments, $tableId);
//$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("group_admin_nav")));
$lAdmin->AddHeaders($headers);
$allSelectedFields = array("ORDER_ID" => false, "PAID" => false, "DATE_PAID" => false);
$visibleHeaders = $lAdmin->GetVisibleHeaderColumns();
$allSelectedFields = array_merge($allSelectedFields, array_fill_keys($visibleHeaders, true));
while ($shipment = $dbResultList->Fetch()) {
$row =& $lAdmin->AddRow($shipment['ID'], $shipment);
$row->AddField("ID", "<a href=\"sale_order_shipment_edit.php?order_id=" . $shipment['ORDER_ID'] . "&shipment_id=" . $shipment['ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . $shipment['ID'] . "</a>");
$row->AddField("ORDER_ID", "<a href=\"sale_order_edit.php?ID=" . $shipment['ORDER_ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . $shipment['ORDER_ID'] . "</a>");
$row->AddField("DELIVERY_NAME", "<a href=\"sale_delivery_service_edit.php?ID=" . $shipment['DELIVERY_ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . htmlspecialcharsbx($shipment['DELIVERY_NAME']) . "</a>");
$row->AddField("ACCOUNT_NUMBER", htmlspecialcharsbx($shipment['SALE_INTERNALS_SHIPMENT_ORDER_ACCOUNT_NUMBER']));
$row->AddField("ALLOW_DELIVERY", $shipment["ALLOW_DELIVERY"] == "Y" ? GetMessage("SHIPMENT_ORDER_YES") : GetMessage("SHIPMENT_ORDER_NO"));
$row->AddField("COMPANY_BY", "<a href=\"sale_company_edit.php?ID=" . $shipment['COMPANY_ID'] . "&lang=" . $lang . GetFilterParams("filter_") . "\">" . htmlspecialcharsbx($shipment['SALE_INTERNALS_SHIPMENT_COMPANY_BY_NAME']) . "</a>");
$row->AddField("ORDER_USER_NAME", "<a href='/bitrix/admin/user_edit.php?ID=" . $shipment['ORDER_USER_ID'] . "&lang=" . $lang . "'>" . htmlspecialcharsbx($shipment['ORDER_USER_NAME']) . " " . htmlspecialcharsbx($shipment['ORDER_USER_LAST_NAME']) . "</a>");
$row->AddField("PRICE_DELIVERY", \CCurrencyLang::CurrencyFormat($shipment['PRICE_DELIVERY'], $shipment['SALE_INTERNALS_SHIPMENT_ORDER_CURRENCY']));
$row->AddField("DEDUCTED", ($shipment["DEDUCTED"] == "Y" ? GetMessage("SHIPMENT_ORDER_YES") : GetMessage("SHIPMENT_ORDER_NO")) . "<br><a href=\"user_edit.php?ID=" . $shipment['EMP_DEDUCTED_ID'] . "\">" . htmlspecialcharsbx($shipment['SALE_INTERNALS_SHIPMENT_EMP_DEDUCTED_BY_LAST_NAME']) . " " . htmlspecialcharsbx($shipment['SALE_INTERNALS_SHIPMENT_EMP_DEDUCTED_BY_NAME']) . "</a><br>" . htmlspecialcharsbx($shipment['DATE_DEDUCTED']));
$row->AddField("RESPONSIBLE_BY", "<a href=\"user_edit.php?ID=" . $shipment['RESPONSIBLE_ID'] . "\">" . htmlspecialcharsbx($shipment['RESPONSIBLE_BY_NAME']) . " " . htmlspecialcharsbx($shipment['RESPONSIBLE_BY_LAST_NAME']) . "</a>");
$row->AddField("ALLOW_DELIVERY", ($shipment["ALLOW_DELIVERY"] == "Y" ? GetMessage("SHIPMENT_ORDER_YES") : GetMessage("SHIPMENT_ORDER_NO")) . "<br><a href=\"user_edit.php?ID=" . $shipment['EMP_ALLOW_DELIVERY_ID'] . "\">" . htmlspecialcharsbx($shipment['EMP_ALLOW_DELIVERY_BY_LAST_NAME']) . " " . htmlspecialcharsbx($shipment['EMP_ALLOW_DELIVERY_BY_NAME']) . "</a><br>" . htmlspecialcharsbx($shipment['DATE_ALLOW_DELIVERY']));
$row->AddField("CANCELED", ($shipment["CANCELED"] == "Y" ? GetMessage("SHIPMENT_ORDER_YES") : GetMessage("SHIPMENT_ORDER_NO")) . "<br><a href=\"user_edit.php?ID=" . $shipment['EMP_CANCELED_ID'] . "\">" . htmlspecialcharsbx($shipment['EMP_CANCELED_BY_LAST_NAME']) . " " . htmlspecialcharsbx($shipment['EMP_CANCELED_BY_NAME']) . "</a><br>" . htmlspecialcharsbx($shipment['DATE_CANCELED']));
$row->AddField("MARKED", ($shipment["MARKED"] == "Y" ? GetMessage("SHIPMENT_ORDER_YES") : GetMessage("SHIPMENT_ORDER_NO")) . "<br><a href=\"user_edit.php?ID=" . $shipment['EMP_MARKED_ID'] . "\">" . htmlspecialcharsbx($shipment['EMP_MARKED_BY_LAST_NAME']) . " " . htmlspecialcharsbx($shipment['EMP_MARKED_BY_NAME']) . "</a><br>" . htmlspecialcharsbx($shipment['DATE_MARKED']));
$row->AddField("STATUS", htmlspecialcharsbx($shipment['STATUS_NAME']));
示例14: date
$arDate["SS"] = 59;
}
$filters_date_history_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
$arFilterHistory["H_DATE_INSERT_TO"] = $filters_date_history_to;
} else {
$filters_date_history_to = "";
}
}
$dbHistory = CSaleOrder::GetHistoryList($arHistSort, $arFilterHistory, false, false, array("*"));
$dbHistory = new CAdminResult($dbHistory, $sTableID_tab5);
$dbHistory->NavStart();
$lAdmin_tab5->NavText($dbHistory->GetNavPrint(GetMessage('SOD_HIST_LIST')));
$histdHeader = array(array("id" => "H_DATE_INSERT", "content" => GetMessage("SOD_HIST_H_DATE"), "sort" => "H_DATE_INSERT", "default" => true), array("id" => "H_USER_ID", "content" => GetMessage("SOD_HIST_H_USER"), "sort" => "H_USER_ID", "default" => true), array("id" => "STATUS_ID", "content" => $arFieldsAll["STATUS_ID"], "sort" => "STATUS_ID", "default" => true), array("id" => "PAYED", "content" => $arFieldsAll["PAYED"], "sort" => "PAYED", "default" => true), array("id" => "ALLOW_DELIVERY", "content" => $arFieldsAll["ALLOW_DELIVERY"], "sort" => "ALLOW_DELIVERY", "default" => true), array("id" => "CANCELED", "content" => $arFieldsAll["CANCELED"], "sort" => "CANCELED", "default" => true), array("id" => "DEDUCTED", "content" => $arFieldsAll["DEDUCTED"], "sort" => "DEDUCTED", "default" => true), array("id" => "MARKED", "content" => $arFieldsAll["MARKED"], "sort" => "MARKED", "default" => true), array("id" => "PRICE", "content" => $arFieldsAll["PRICE"], "sort" => "PRICE", "default" => true), array("id" => "MORE", "content" => GetMessage("SOD_HIST_H_MORE"), "sort" => "", "default" => true));
$lAdmin_tab5->AddHeaders($histdHeader);
$arDeleteFields = array("ID", "H_USER_ID", "H_DATE_INSERT", "H_CURRENCY", "H_ORDER_ID", "EMP_CANCELED_ID", "EMP_DEDUCTED_ID", "EMP_MARKED_ID", "EMP_STATUS_ID", "EMP_ALLOW_DELIVERY_ID", "STATUS_ID", "PAYED", "ALLOW_DELIVERY", "CANCELED", "DEDUCTED", "MARKED", "PRICE");
while ($arHistory = $dbHistory->Fetch()) {
$row =& $lAdmin_tab5->AddRow($arHistory["ID"], $arHistory, '', '');
$stmp = MakeTimeStamp($arHistory["H_DATE_INSERT"], "DD.MM.YYYY HH:MI:SS");
$row->AddField("H_DATE_INSERT", date("d.m.Y H:i", $stmp));
$row->AddField("H_USER_ID", GetFormatedUserName($arHistory["H_USER_ID"], false));
$payed = "";
if ($arHistory["PAYED"] == "Y") {
$payed = GetMessage("SOD_HIST_YES");
} elseif ($arHistory["PAYED"] == "N") {
$payed = GetMessage("SOD_HIST_NO");
}
$row->AddField("PAYED", $payed);
$allo_delivery = "";
if ($arHistory["ALLOW_DELIVERY"] == "Y") {
$allo_delivery = GetMessage("SOD_HIST_YES");
} elseif ($arHistory["ALLOW_DELIVERY"] == "N") {
示例15: GetMessage
"id" => "PARTNER",
"content" => GetMessage("MOD_PARTNER"),
"default" => true,
),
array(
"id" => "DATE_TO",
"content" => GetMessage("MOD_DATE_TO"),
"default" => true,
),
);
$lAdmin1->AddHeaders($arHeaders1);
$rsData = new CDBResult;
$rsData->InitFromArray($modulesNew);
$rsData = new CAdminResult($rsData, $sTableID1);
while($info = $rsData->Fetch())
{
$row =& $lAdmin1->AddRow($info["ID"], $info);
$row->AddViewField("NAME", "<b><a href=\"http://marketplace.1c-freetrix.ru/".htmlspecialcharsbx($info["ID"])."\" target=\"_blank\">".htmlspecialcharsbx($info["NAME"])."</a></b> (".htmlspecialcharsbx($info["ID"]).")<br />".htmlspecialcharsbx($info["DESCRIPTION"]));
$row->AddViewField("PARTNER", $info["PARTNER"]);
if($info["UPDATE_END"] == "Y")
{
if($linkToBuy)
{
if(strlen($info["DATE_TO"]) > 0)
$row->AddViewField("DATE_TO", "<span style=\"color:red;\">".$info["DATE_TO"]."</span><br /><a href=\"".str_replace("#CODE#", $info["ID"], $linkToBuyUpdate)."\" target=\"_blank\">".GetMessage("MOD_UPDATE_BUY")."</a>");
else
$row->AddViewField("DATE_TO", "<a href=\"".str_replace("#CODE#", $info["ID"], $linkToBuyUpdate)."\" target=\"_blank\">".GetMessage("MOD_UPDATE_BUY")."</a>");