One Hat Cyber Team

View File Name : Regional.class.php

<?php
/**
 * Created by Mohammad reza Moshaver.
 * Date: 8/8/2018 AD
 * Time: 21:39
 */
$ROOT = dirname(dirname(dirname(dirname(__FILE__))));

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

class Regional {

    private $SECRET_KEY;

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

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

        $con = $General->Connect();

        if ($ParentID == '') {
            $query = mysqli_query($con, "INSERT INTO `bas.regional` VALUES(NULL,'$Type','$Name',NULL)");
        } else {
            $query = mysqli_query($con, "INSERT INTO `bas.regional` VALUES(NULL,'$Type','$Name','$ParentID')");
        }
        if ($query) {

            $Result['success'] = true;
            $Result['message'] = 'منطقه جغرافیایی «' . $Name . '» ایجاد شد.';
            $ResultArray = json_encode($Result);
            return $ResultArray;

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

    }

    public function Edit($ID, $Name, $ParentID)
    {              //ویرایش مشخصات
        $General = new General();

        $con = $General->Connect();

        if ($ParentID == '') {
            $query = mysqli_query($con, "UPDATE `bas.regional` SET `Name`='$Name', `ParentID`=NULL WHERE (`ID`='$ID')");
        } else {
            $query = mysqli_query($con, "UPDATE `bas.regional` SET `Name`='$Name', `ParentID`='$ParentID' 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 Delete($ID)
    {
        $General = new General();

        $con = $General->Connect();

        $query = mysqli_query($con, "DELETE FROM `bas.regional` WHERE (`ID`='$ID') OR (`ParentID`='$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 SelectRegional($ID,$Type,$ParentID, $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($Type != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Type`='$Type')";
        }
        if($ParentID != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`ParentID`='$ParentID')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `bas.regional` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `bas.regional` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    public function SelectRegionalName($ID,$Name,$ParentID, $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($Name != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Name` LIKE '%$Name%')";
        }
        if($ParentID != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`ParentID`='$ParentID')";
        }
        if($Condition != '') {
            $Query = mysqli_query($con, "SELECT * FROM `bas.regional` WHERE $Condition $ORDER_BY $ORDER_TYPE $LIMIT");
        }
        else{
            $Query = mysqli_query($con, "SELECT * FROM `bas.regional` $ORDER_BY $ORDER_TYPE $LIMIT");
        }

        return $Query;
    }

    ######## Nationality #########

    /*
     * Status:0 => غیرفعال
     * Status:1 => فعال
     */
    public function AddNationality($Name,$NameEn,$Priority,$Status)
    {              //تعریف کاربر
        $General = new General();

        $con = $General->Connect();
        $time = time();



        mysqli_query($con, "INSERT INTO `bas.nationality` VALUES(NULL, '$Name', '$NameEn', '$Priority' , '$Status')");
        if (mysqli_affected_rows($con) > 0) {



            $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 DeleteNationality($ID)
    {                //حذف کاربر
        $General = new General();

        $con = $General->Connect();

        mysqli_query($con, "DELETE FROM `bas.nationality` WHERE (`ID`='$ID')");
        if (mysqli_affected_rows($con) > 0) {
            $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 SelectNationality($ID, $Name, $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($Name != '') {
            if($Condition != '') {
                $Condition = $Condition . ' AND ';
            }
            $Condition = $Condition . "(`Name`='$Name')";
        }

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


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

        return $Query;

    }
}

?>