blog_post_category.php

См. документацию.

<?php
 
IncludeModuleLangFile(__FILE__);
 
class CAllBlogPostCategory
{
    /*************** ADD, UPDATE, DELETE *****************/
    public static function CheckFields($ACTION, &$arFields, $ID = 0)
    {
        global $APPLICATION;
 
        if ((is_set($arFields, "POST_ID") || $ACTION=="ADD") && $arFields["POST_ID"] == '')
        {
            $APPLICATION->ThrowException(GetMessage("BLG_GCT_EMPTY_POST_ID"), "EMPTY_POST_ID");
            return false;
        }
        elseif (is_set($arFields, "POST_ID"))
        {
            $arResult = CBlogPost::GetByID($arFields["POST_ID"]);
            if (!$arResult)
            {
                $APPLICATION->ThrowException(str_replace("#ID#", $arFields["POST_ID"], GetMessage("BLG_GCT_ERROR_NO_POST")), "ERROR_NO_POST");
                return false;
            }
        }
 
        if ((is_set($arFields, "BLOG_ID") || $ACTION=="ADD") && intval($arFields["BLOG_ID"]) <= 0)
        {
            $APPLICATION->ThrowException(GetMessage("BLG_GCT_EMPTY_BLOG_ID"), "EMPTY_BLOG_ID");
            return false;
        }
        elseif (is_set($arFields, "BLOG_ID"))
        {
            $arResult = CBlog::GetByID($arFields["BLOG_ID"]);
            if (!$arResult)
            {
                $APPLICATION->ThrowException(str_replace("#ID#", $arFields["BLOG_ID"], GetMessage("BLG_GCT_ERROR_NO_BLOG")), "ERROR_NO_BLOG");
                return false;
            }
        }
 
        if ((is_set($arFields, "CATEGORY_ID") || $ACTION=="ADD") && intval($arFields["CATEGORY_ID"]) <= 0)
        {
            $APPLICATION->ThrowException(GetMessage("BLG_GCT_EMPTY_CATEGORY_ID"), "EMPTY_CATEGORY_ID");
            return false;
        }
        elseif (is_set($arFields, "CATEGORY_ID"))
        {
            $arResult = CBlogCategory::GetByID($arFields["CATEGORY_ID"]);
            if (!$arResult)
            {
                $APPLICATION->ThrowException(str_replace("#ID#", $arFields["CATEGORY_ID"], GetMessage("BLG_GCT_ERROR_NO_CATEGORY")), "ERROR_NO_CATEGORY");
                return false;
            }
        }
 
        return true;
    }
 
    public static function Delete($ID)
    {
        global $DB;
 
        $ID = intval($ID);
 
        return $DB->Query("DELETE FROM b_blog_post_category WHERE ID = ".$ID."", true);
    }
 
    //*************** SELECT *********************/
    public static function GetByID($ID)
    {
        global $DB;
 
        $ID = intval($ID);
 
        $strSql =
            "SELECT C.ID, C.BLOG_ID, C.POST_ID, C.CATEGORY_ID ".
            "FROM b_blog_post_category C ".
            "WHERE C.ID = ".$ID."";
        $dbResult = $DB->Query($strSql);
        if ($arResult = $dbResult->Fetch())
        {
            return $arResult;
        }
        return False;
    }
    
    public static function DeleteByPostID($ID)
    {
        global $DB;
 
        $ID = intval($ID);
 
        return $DB->Query("DELETE FROM b_blog_post_category WHERE POST_ID = ".$ID."", true);
    }
}