public static function Update($ID, $arFields) { global $DB; $ID = IntVal($ID); if ($ID <= 0) { return False; } $arFields1 = array(); foreach ($arFields as $key => $value) { if (substr($key, 0, 1) == "=") { $arFields1[substr($key, 1)] = $value; unset($arFields[$key]); } } if (!CSaleAffiliateTransact::CheckFields("UPDATE", $arFields, $ID)) { return false; } $strUpdate = $DB->PrepareUpdate("b_sale_affiliate_transact", $arFields); foreach ($arFields1 as $key => $value) { if (strlen($strUpdate) > 0) { $strUpdate .= ", "; } $strUpdate .= $key . "=" . $value . " "; } $strSql = "UPDATE b_sale_affiliate_transact SET " . $strUpdate . " WHERE ID = " . $ID . " "; $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); return $ID; }
function Add($arFields) { global $DB; $arFields1 = array(); foreach ($arFields as $key => $value) { if (substr($key, 0, 1) == "=") { $arFields1[substr($key, 1)] = $value; unset($arFields[$key]); } } if (!CSaleAffiliateTransact::CheckFields("ADD", $arFields, 0)) { return false; } $arInsert = $DB->PrepareInsert("b_sale_affiliate_transact", $arFields); foreach ($arFields1 as $key => $value) { if (strlen($arInsert[0]) > 0) { $arInsert[0] .= ", "; } $arInsert[0] .= $key; if (strlen($arInsert[1]) > 0) { $arInsert[1] .= ", "; } $arInsert[1] .= $value; } $strSql = "INSERT INTO b_sale_affiliate_transact(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")"; $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); $ID = IntVal($DB->LastID()); return $ID; }
} $arResult["CURRENT_PAGE_PARAM"] = $APPLICATION->GetCurPageParam("", array("filter_date_from", "filter_date_to")); $arResult["CURRENT_PAGE"] = $APPLICATION->GetCurPage(); $arResult["CURRENT_DATE"] = date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), time()); $arResult["PAID_SUM_INCOME"] = $arAffiliate["PAID_SUM"] >= 0 ? SaleFormatCurrency($arAffiliate["PAID_SUM"], $affiliateCurrency) : ""; $arResult["PAID_SUM_OUTCOME"] = $arAffiliate["PAID_SUM"] < 0 ? SaleFormatCurrency(-$arAffiliate["PAID_SUM"], $affiliateCurrency) : ""; $arResult["FILTER"] = array("filter_date_from" => $filter_date_from, "filter_date_to" => $filter_date_to); $arFilter = array("AFFILIATE_ID" => $arAffiliate["ID"]); if (StrLen($filter_date_from) > 0) { $arFilter[">=TRANSACT_DATE"] = Trim($filter_date_from); } if (StrLen($filter_date_to) > 0) { $arFilter["<=TRANSACT_DATE"] = Trim($filter_date_to); } $arResult["TRANSACT"] = array(); $dbTransactList = CSaleAffiliateTransact::GetList(array("TRANSACT_DATE" => "ASC"), $arFilter, false, false, array("ID", "TRANSACT_DATE", "AMOUNT", "CURRENCY", "DEBIT", "DESCRIPTION")); while ($arTransactList = $dbTransactList->GetNext()) { $arTransactList["AMOUNT_FORMAT"] = SaleFormatCurrency($arTransactList["AMOUNT"], $arTransactList["CURRENCY"]); $arTransactList["AMOUNT_INCOME"] = $arTransactList["DEBIT"] == "Y" ? $arTransactList["AMOUNT_FORMAT"] : ""; $arTransactList["AMOUNT_OUTCOME"] = $arTransactList["DEBIT"] != "Y" ? $arTransactList["AMOUNT_FORMAT"] : ""; $arTransactList["DESCRIPTION_NOTES"] = array_key_exists($arTransactList["DESCRIPTION"], $arTransactTypes) ? $arTransactTypes[$arTransactList["DESCRIPTION"]] : ""; $arResult["TRANSACT"][] = $arTransactList; } $arResult["FILTER_ID"] = rand(0, 10000); } else { $arResult = False; } $this->IncludeComponentTemplate(); } else { LocalRedirect($arParams["REGISTER_PAGE"] . "?REDIRECT_PAGE=" . UrlEncode($APPLICATION->GetCurPage())); die;
function ClearAffiliateSum($affiliate) { global $DB; $arAffiliate = CSaleAffiliate::CheckAffiliateFunc($affiliate); if (!$arAffiliate) { return False; } $arAffiliate["PAID_SUM"] = str_replace(",", ".", $arAffiliate["PAID_SUM"]); $arAffiliate["PAID_SUM"] = DoubleVal($arAffiliate["PAID_SUM"]); if ($arAffiliate["PAID_SUM"] > 0) { if (!array_key_exists("BASE_LANG_CURRENCIES", $GLOBALS)) { $GLOBALS["BASE_LANG_CURRENCIES"] = array(); } if (!array_key_exists($arAffiliate["SITE_ID"], $GLOBALS["BASE_LANG_CURRENCIES"])) { $GLOBALS["BASE_LANG_CURRENCIES"][$arAffiliate["SITE_ID"]] = CSaleLang::GetLangCurrency($arAffiliate["SITE_ID"]); } if (!CSaleAffiliate::Update($arAffiliate["ID"], array("PAID_SUM" => 0))) { if ($ex = $GLOBALS["APPLICATION"]->GetException()) { $GLOBALS["APPLICATION"]->ThrowException($ex->GetString(), "AF_UPDATE_ERROR"); } else { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("ACGA1_ERROR_UPDATE_SUM"), "AF_UPDATE_ERROR"); } return False; } $arFields = array("AFFILIATE_ID" => $arAffiliate["ID"], "TRANSACT_DATE" => date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID))), "AMOUNT" => $arAffiliate["PAID_SUM"], "CURRENCY" => $GLOBALS["BASE_LANG_CURRENCIES"][$arAffiliate["SITE_ID"]], "DEBIT" => "N", "DESCRIPTION" => "AFFILIATE_CLEAR", "EMPLOYEE_ID" => $GLOBALS["USER"]->IsAuthorized() ? $GLOBALS["USER"]->GetID() : False); CSaleAffiliateTransact::Add($arFields); } return True; }
if (IntVal($filter_affiliate_id) > 0) { $arFilter["AFFILIATE_ID"] = IntVal($filter_affiliate_id); } 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); } $dbTransactList = CSaleAffiliateTransact::GetList(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("ID", "AFFILIATE_ID", "TIMESTAMP_X", "TRANSACT_DATE", "AMOUNT", "CURRENCY", "DEBIT", "DESCRIPTION", "EMPLOYEE_ID", "AFFILIATE_SITE_ID", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL")); $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("SAT2_TRANSACT_DATE"), "sort" => "TRANSACT_DATE", "default" => true), array("id" => "AFFILIATE_ID", "content" => GetMessage("SAT2_AFFILIATE"), "sort" => "AFFILIATE_ID", "default" => true), array("id" => "AMOUNT", "content" => GetMessage("SAT2_SUM"), "sort" => "AMOUNT", "default" => true), array("id" => "TYPE", "content" => GetMessage("SAT2_TYPE"), "sort" => "DESCRIPTION", "default" => true), array("id" => "DESCR", "content" => GetMessage("SAT2_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/sale_affiliate_edit.php?ID=" . $f_AFFILIATE_ID . "&lang=" . LANG . "\" title=\"" . GetMessage("SAT2_AFF_PROFILE") . "\">" . $f_AFFILIATE_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["AFFILIATE_SITE_ID"]) . " "; $fieldValue .= htmlspecialcharsEx($arTransact["USER_LOGIN"]) . " "; $fieldValue .= "<a href=\"mailto:" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "\" title=\"" . GetMessage("SAT2_MAIL") . "\">" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "</a>"; $row->AddField("AFFILIATE_ID", $fieldValue);