Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/sale/general/ |
Upload File : |
<?php IncludeModuleLangFile(__FILE__); class CAllSaleOrderPropsVariant { public static function GetByValue($PropID, $Value) { $PropID = intval($PropID); $db_res = CSaleOrderPropsVariant::GetList(($by="SORT"), ($order="ASC"), Array("ORDER_PROPS_ID"=>$PropID, "VALUE"=>$Value)); if ($res = $db_res->Fetch()) { return $res; } return False; } public static function GetByID($ID) { global $DB; $ID = intval($ID); $strSql = "SELECT * ". "FROM b_sale_order_props_variant ". "WHERE ID = ".$ID.""; $db_res = $DB->Query($strSql); if ($res = $db_res->Fetch()) { return $res; } return False; } public static function CheckFields($ACTION, &$arFields, $ID = 0) { global $DB, $USER; if ((is_set($arFields, "VALUE") || $ACTION=="ADD") && $arFields["VALUE"] == '') { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_EMPTY_VAR"), "ERROR_NO_VALUE"); return false; } if ((is_set($arFields, "NAME") || $ACTION=="ADD") && $arFields["NAME"] == '') { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_EMPTY_NAME"), "ERROR_NO_NAME"); return false; } if ((is_set($arFields, "ORDER_PROPS_ID") || $ACTION=="ADD") && intval($arFields["ORDER_PROPS_ID"])<=0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_EMPTY_CODE"), "ERROR_NO_ORDER_PROPS_ID"); return false; } if (is_set($arFields, "ORDER_PROPS_ID")) { if (!($arOrder = CSaleOrderProps::GetByID($arFields["ORDER_PROPS_ID"]))) { $GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $arFields["ORDER_PROPS_ID"], GetMessage("SKGOPV_NO_PROP")), "ERROR_NO_PROPERY"); return false; } } return True; } public static function Update($ID, $arFields) { global $DB; $ID = intval($ID); if (!CSaleOrderPropsVariant::CheckFields("UPDATE", $arFields, $ID)) return false; $strUpdate = $DB->PrepareUpdate("b_sale_order_props_variant", $arFields); $strSql = "UPDATE b_sale_order_props_variant SET ".$strUpdate." WHERE ID = ".$ID.""; $DB->Query($strSql); return $ID; } public static function Delete($ID) { global $DB; $ID = intval($ID); return $DB->Query("DELETE FROM b_sale_order_props_variant WHERE ID = ".$ID."", true); } public static function DeleteAll($ID) { global $DB; $ID = intval($ID); return $DB->Query("DELETE FROM b_sale_order_props_variant WHERE ORDER_PROPS_ID = ".$ID."", true); } }