One Hat Cyber Team

View File Name : Website.class.php

<?php
/**
 *
 * Date: 10/11/2018 AD
 * Time: 10:58
 */
$ROOT = dirname(dirname(dirname(dirname(__FILE__))));

require_once($ROOT.'/Panel/class/General/General.class.php');

class Website {

    private $SECRET_KEY;

    public function __construct() {
        global $SECRET_KEY;
        $this->SECRET_KEY=$SECRET_KEY;
    }

    /*
     * Type:1 => کشور
     * Type:2 => استان
     * Type:3 => شهر
     */
    public function AddSlide($Title, $Upload,$url,$lang)
    {              //ثبت منطقه جغرافیای جدید
        $General = new General();

        $con = $General->Connect();

        $CT = time();
        $query = mysqli_query($con, "INSERT INTO `web.slideshow` VALUES (NULL,'$Title','$Upload','$url','$CT','$lang','1')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « اسلایدشو با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function EditSlide($ID, $Title, $Upload)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "UPDATE `web.slideshow` SET `Name`='$Title', `Pic`='$Upload' WHERE (`ID`='$ID')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeleteSlide($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `web.slideshow` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectSlide($ID,$Lang,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();

        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Lang != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Lang`='$Lang')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `web.slideshow` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `web.slideshow` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    public function AddContant($Title, $Detail, $Pic, $Locate, $Type)
    {              //ثبت منطقه جغرافیای جدید
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "INSERT INTO `web.content` VALUES(NULL,'$Title','$Detail','$Pic','$Locate','$Type','1')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « اسلایدشو با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeleteContant($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `web.content` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectContant($ID,$Locate,$Type,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();

        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }
        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($Locate != '') {
            $Condition = " (`Locate`='$Locate')";
        }
        if($Type != '') {
            $Condition = " (`Type`='$Type')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `web.content` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `web.content` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    public function AddOffer($HID,$Name, $Detail, $Pic, $Offer, $Expair, $Type)
    {              //ثبت منطقه جغرافیای جدید
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "INSERT INTO `web.offer` VALUES(NULL,'$HID','$Name','$Detail','$Pic','$Offer','$Expair','$Type','1')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « اسلایدشو با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeleteOffer($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `web.offer` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectOffer($ID,$HID , $Type ,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();

        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($HID != '') {
            $Condition = " (`HID`='$HID')";
        }
        if($Type != '') {
            $Condition = " (`Type`='$Type')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `web.offer` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `web.offer` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }


    /*
     * Lang:1 => English
     * Lang:2 => Persian
     */
    public function AddCategory($ParentID,$Name,$Slug,$Desc,$Pic,$Show,$Order,$Lang,$Status)
    {
        $General = new General();
        $con = $General->Connect();


        $query = mysqli_query($con, "INSERT INTO `bas.category` VALUES(NULL,'$ParentID','$Name','$Slug','$Desc','$Pic','$Show','$Order','$Lang','$Status')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « دسته بندی با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function EditCategory($ID, $ParentID,$Name,$Slug,$Desc,$Pic,$Show,$Order,$Lang,$Status)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "UPDATE `bas.category` SET `ParentID`='$ParentID', `Name`='$Name', `Slug`='$Slug', `Desc`='$Desc', `Pic`='$Pic', `Show`='$Show', `Order`='$Order', `Lang`='$Lang', `Status`='$Status' WHERE (`ID`='$ID')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = false;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeletCategory($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `bas.category` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectCategory($ID,$ParentID,$Name,$Slug,$Show,$Order,$Lang,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();

        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($ParentID != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`ParentID`='$ParentID')";
        }
        if($Name != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Name` LIKE '%$Name%')";
        }
        if($Slug != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Slug`='$Slug')";
        }
        if($Show != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Show`='$Show')";
        }
        if($Order != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Order`='$Order')";
        }
        if($Lang != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Lang`='$Lang')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `bas.category` WHERE $Condition AND (`ID` != '100') $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `bas.category` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }



    /*
     * Lang:1 => English
     * Lang:2 => Persian
     */
    public function AddMenu($ParentID,$Name,$Url,$Level,$Order,$Lang,$Status)
    {
        $General = new General();
        $con = $General->Connect();


        $query = mysqli_query($con, "INSERT INTO `bas.manu` VALUES(NULL,'$ParentID','$Name','$Url','$Level','$Order','$Lang','$Status')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « دسته بندی با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function EditMenu($ID,$ParentID,$Name,$Url,$Level,$Order,$Lang,$Status)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "UPDATE `bas.manu` SET `ParentID`='$ParentID', `Name`='$Name', `Url`='$Url', `Level`='$Level', `Order`='$Order', `Lang`='$Lang', `Status`='$Status' WHERE (`ID`='$ID')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = false;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeletMenu($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `bas.manu` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectMenu($ID,$ParentID,$Name,$Url,$Level,$Lang,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();
        $Order ="";
        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($ParentID != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`ParentID`='$ParentID')";
        }
        if($Name != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Name` LIKE '%$Name%')";
        }
        if($Url != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Url`='$Url')";
        }
        if($Level != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Level`='$Level')";
        }
        if($Order != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Order`='$Order')";
        }
        if($Lang != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Lang`='$Lang')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `bas.manu` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `bas.manu` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }



    /*
     * Lang:1 => English
     * Lang:2 => Persian
     */
    public function AddBlog($CatID,$Titile,$Slug,$Context,$Image,$IsAudio,$Audio,$IsVideo,$Video,$IsSerial,$CountSerial,$NextPost,$UT,$CT,$Author,$Type,$Lang,$Status)
    {
        $General = new General();
        $con = $General->Connect();

        $Context = mysqli_real_escape_string($con,$Context);
        $Audio = mysqli_real_escape_string($con,$Audio);
        $query = mysqli_query($con, "INSERT INTO `blog.post` VALUES(NULL,'$CatID','$Titile','$Slug','$Context','$Image','$IsAudio','$Audio','$IsVideo','$Video','$IsSerial','$CountSerial','$NextPost','$UT','$CT','$Lang','$Author','$Type','$Status')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « مقاله با موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function EditBlog($ID,$CatID,$Titile,$Slug,$Context,$Image,$IsAudio,$Audio,$IsVideo,$Video,$IsSerial,$CountSerial,$NextPost,$UT,$CT,$Author,$Type,$Lang,$Status)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();


        $Context = mysqli_real_escape_string($con,$Context);
        $Audio = mysqli_real_escape_string($con,$Audio);
        $Status = (int)$Status;
        $query = mysqli_query($con, "UPDATE `blog.post` SET `CatID`='$CatID', `Titile`='$Titile', `Slug`='$Slug', `Context`='$Context', `Image`='$Image', `IsAudio`='$IsAudio', `Audio`='$Audio', `IsVideo`='$IsVideo', `Video`='$Video', `IsSerial`='$IsSerial', `CountSerial`='$CountSerial', `NextPost`='$NextPost', `UT`='$UT', `Lang`='$Lang', `Author`='$Author', `Type`='$Type', `Status`=$Status WHERE (`ID`='$ID')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = false;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function DeletBlog($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `blog.post` WHERE (`ID`='$ID')");
        if ($query) {
            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = true;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectBlog($ID,$CatID,$Titile,$Slug,$Context,$IsAudio,$IsVideo,$IsSerial,$CountSerial,$Nextpost,$Type,$Author,$Lang,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT, $PAGE){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();


        if ($LIMIT != '') {
            if($PAGE != ''){
                $LIMIT = "LIMIT " . ($LIMIT * ($PAGE-1)) . ", $LIMIT";
            }else {
                $LIMIT = "LIMIT $LIMIT";
            }
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($CatID != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`CatID`='$CatID')";
        }
        if($Titile != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Titile` LIKE '%$Titile%')";
        }
        if($Context != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Context` LIKE '%$Context%')";
        }
        if($Slug != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Slug`='$Slug')";
        }
        if($IsAudio != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`IsAudio`='$IsAudio')";
        }
        if($IsVideo != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`IsVideo`='$IsVideo')";
        }
        if($IsSerial != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`IsSerial`='$IsSerial')";
        }
        if($CountSerial != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`CountSerial`='$CountSerial')";
        }
        if($Nextpost != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`NextPost`='$Nextpost')";
        }
        if($Lang != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Lang`='$Lang')";
        }
        if($Type != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Type`='$Type')";
        }
        if($Author != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Author`='$Author')";
        }
        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `blog.post` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `blog.post` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    /*
     * Newsletter
     */
    public function AddNewsletter($FullName,$Email,$Status)
    {
        $General = new General();
        $con = $General->Connect();


        $query = mysqli_query($con, "INSERT INTO `web.newsletter` VALUES(NULL,'$FullName','$Email','$Status')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = ' « موفقیت درج شد » ';
            $ResultArray = json_encode($Result);
            return $ResultArray;

        } else {
            $Result['success'] = false;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }
    public function SelectNewsletter($ID,$Email,$Status, $ORDER_BY, $ORDER_TYPE, $LIMIT){                //لیست مناطق جفرافیایی
        $General = new General();
        $con = $General->Connect();

        if($LIMIT != ''){
            $LIMIT = "LIMIT $LIMIT";
        }
        if($ORDER_BY != ''){
            $ORDER_BY = "ORDER BY $ORDER_BY";
        }

        $Condition = '';
        if($ID != '') {
            $Condition = " (`ID`='$ID')";
        }
        if($Email != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Email`='$Email')";
        }

        if($Status != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Status`='$Status')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `web.newsletter` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `web.newsletter` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    /*
  * Setting
  */
    public function EditSetting($Lang,$Title,$Description,$Logo,$TodayText)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();


        $query = mysqli_query($con, "UPDATE `web.setting` SET `Title`='$Title', `Description`='$Description', `Logo`='$Logo', `TodayText`='$TodayText' WHERE (`Lang`='$Lang')");

        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'عملیات با موفقیت انجام شد';
            $ResultArray = json_encode($Result);
            return $ResultArray;
        } else {
            $Result['success'] = false;
            $Result['message'] = 'عملیات ناموفق<br> خطا:' . mysqli_error($con);
            $ResultArray = json_encode($Result);
            return $ResultArray;
        }

    }

    public function SelectSetting($Lang){
        $General = new General();
        $con = $General->Connect();

        if($Lang != ""){

            $Query = mysqli_query($con, "SELECT * FROM `web.setting` WHERE (`Lang`='$Lang')");

        }else{
            $Query = mysqli_query($con, "SELECT * FROM `web.setting`");

        }


        return $Query;
    }


}

?>