<?
    class getData {

        //==========================================================================================================
        function getProduct($id) {

            $result=DB::query(
                "SELECT product.name, productPharmacy.cost, productPharmacy.quantity, manufacturer.name AS manufacturer
                    FROM product, productPharmacy, manufacturer
                    WHERE
                        productPharmacy.idProduct=%i
                        AND product.idSync = productPharmacy.idProduct
                        AND productPharmacy.idManufacturer = manufacturer.idSync
                ORDER BY product.name",
                $id
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>  "Something wrong with server"
                );
            }

             return $result;
        }

        //==========================================================================================================
        function getStoc($id) {

            $result=DB::query(
                "SELECT product.name, productPharmacy.cost, productPharmacy.quantity, manufacturer.name AS manufacturer
                    FROM product, productPharmacy, manufacturer
                    WHERE
                        productPharmacy.idSync=%s
                        AND product.idSync = productPharmacy.idProduct
                        AND productPharmacy.idManufacturer = manufacturer.idSync
                ORDER BY product.name",
                $id
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>  "Something wrong with server"
                );
            }

             return $result;
        }

        //==========================================================================================================
        function getProductAsNameAndManufacturer($idProduct, $idManufacturer, $idPharmacy) {

            $result=DB::query(
                "SELECT productPharmacy.cost, productPharmacy.quantity
                    FROM productPharmacy
                    WHERE
                        productPharmacy.idProduct=%i
                        AND productPharmacy.idManufacturer=%i
                        AND productPharmacy.idPharmacy=%i",
                $idProduct, $idManufacturer, $idPharmacy
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>  "Something wrong with server"
                );
            }

             return $result;
        }

        //==========================================================================================================

        function getProductPharm($id) {

            $result=DB::query(
                "SELECT product.name, productPharmacy.cost, productPharmacy.quantity, manufacturer.name AS manufacturer
                    FROM product, productPharmacy, manufacturer
                    WHERE
                        productPharmacy.idProduct=%i
                        AND productPharmacy.idPharmacy=%i
                        AND product.idSync = productPharmacy.idProduct
                        AND productPharmacy.idManufacturer = manufacturer.idSync
                ORDER BY product.name",
                $id,
                $_SESSION['pharmacy']
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>  "Something wrong with server"
                );
            }

             return $result;
        }

        //==========================================================================================================

        function getProducts($pharmID, $size, $page) {

            if ($size != 0) {
                $result=DB::query(
                    "SELECT product.*,  productPharmacy.cost,  productPharmacy.quantity, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name
                    LIMIT %i, %i",
                    $pharmID,
                    $size*($page-1),
                    $size);
            } else {
                $result=DB::query(
                    "SELECT product.*,  productPharmacy.cost,  productPharmacy.quantity, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name",
                    $pharmID);
            }

            return $result;
        }

        //==========================================================================================================

        function getPharmacy($id) {
            $result=DB::query(
                "SELECT *
                    FROM pharmacy
                    WHERE pharmacy.idSync = %i
                ORDER BY addr",
                $id
                );


            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Аптека не найденна"
                );
            }

            return $result;
        }

        //==========================================================================================================

        function getPharmacys() {
            $result=DB::query(
                "SELECT *
                    FROM pharmacy
                ORDER BY addr"
                );


            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Something wrong with server"
                );
            }

            return $result;
        }

        //==========================================================================================================

        function getProductsFromAlphabet($pharmID, $char, $size, $page){

            if ($size != 0) {
                $result=DB::query(
                    "SELECT product.*,  productPharmacy.cost,  productPharmacy.quantity, product.idSync AS idProduct, productPharmacy.idManufacturer, productPharmacy.idSync AS idStoc, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            product.alphabet = %s
                            AND productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name
                    LIMIT %i, %i",
                    $char,
                    $pharmID,
                    $size*($page-1),
                    $size);
            } else {
                $result=DB::query(
                    "SELECT product.*,  productPharmacy.cost, product.idSync AS idProduct, productPharmacy.idManufacturer, productPharmacy.idSync AS idStoc, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            product.alphabet = %s
                            AND productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name",
                    $char,
                    $pharmID
                    );
            };


            return $result;
        }

        //==========================================================================================================

        function getProductsFromSearch($pharmID, $search, $size, $page){

            if ($size != 0) {
                $result=DB::query(
                    "SELECT product.*, productPharmacy.cost,  productPharmacy.quantity, productPharmacy.idManufacturer, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            LOWER(product.name) LIKE LOWER(%s)
                            AND productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name
                    LIMIT %i, %i",
                    '%'.$search.'%',
                    $pharmID,
                    $size*($page-1),
                    $size);
            } else {
                $result=DB::query(
                    "SELECT product.*, productPharmacy.cost,  productPharmacy.quantity, productPharmacy.idManufacturer, productPharmacy.idSync AS idStoc, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            LOWER(product.name) LIKE LOWER(%s)
                            AND productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name",
                    '%'.$search.'%',
                    $pharmID
                    );
            };
            return $result;
        }

        function getProductsFromFastSearch($search){
            $result=DB::query(
                "SELECT DISTINCT product.name
                    FROM product, productPharmacy
                    WHERE
                        LOWER(product.name) LIKE LOWER(%s)
                        AND product.idSync = productPharmacy.idProduct
                        AND productPharmacy.quantity > 0
                ORDER BY productPharmacy.cost DESC
                LIMIT 0, 5",
                '%'.$search.'%'
                );
            return $result;
        }

        //==========================================================================================================

        /*function getProductsFromCatAlias($alias, $pharmID){

            $result=DB::query(
                    "SELECT categories.id
                        FROM categories , productPharmacy
                        WHERE
                            categories.alias = %s AND
                            productPharmacy.idPharmacy = %i",
                    $alias,
                    $pharmID
            );
            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Не найденна категория по алиасу"
                );
                return $result;
            }

            $id = $result[0]['id'];


            $result=DB::query(
                    "SELECT product.*
                        FROM product, productCategories , productPharmacy
                        WHERE
                            productCategories.idCategories = %i AND
                            product.id = productCategories.idProduct AND
                            productPharmacy.idProduct = %i AND
                            productPharmacy.idProduct = productCategories.idProduct AND
                            product.id = productPharmacy.idProduct
                    ORDER BY product.name",
                $id,
                $pharmID
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Something wrong with server"
                );
            }

            return $result;
        } */

        //========================================================================================================

        function getProductsFromPharmacy($id, $pharmID){

            $result;

            if (!is_int($id)){

                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Not owned id"
                );

                return $result;
            }

            $result=DB::query(
                    "SELECT productPharmacy.idPharmacy,productPharmacy.quantity, product.name
                        FROM product, productPharmacy
                        WHERE
                            productPharmacy.idProduct = %i AND
                            product.idSync = productPharmacy.idProduct AND
                            productPharmacy.idProduct=product.idSync
                    ORDER BY product.name",
                $id
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Something wrong with server"
                );
            }

            return $result;
        }

        //==========================================================================================================

        function getOrder($id){

            $result['information']=DB::query(
                "SELECT orderInformation.fio,
                        orderInformation.phone,
                        orderInformation.dateOrder,
                        orderInformation.status,
                        pharmacy.email
                    FROM orderInformation, pharmacy
                    WHERE
                        orderInformation.idPharmacy = pharmacy.id
                        AND orderInformation.id = %i",
                $id
            );
            $result['product']=DB::query(
                "SELECT *
                    FROM orderProduct
                    WHERE
                        orderProduct.idOrder = %i",
                $id
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Something wrong with server"
                );
            }

            return $result;
        }

        //==========================================================================================================

        function getOrders(){

            $result;

            $result=DB::query(
                    "SELECT *
                        FROM orderProduct"
            );

            if ($result==array())
            {
                $result =array(
                "error"=>0,
                "errorInformation"  =>      "Something wrong with server"
                );
            }

            return $result;
        }

        //==========================================================================================================

        function getCart(){
            if (isset($_SESSION['cart'])) {
                $result = $_SESSION['cart'];
            } else {
                $result = array(
                    'error'=>0,
                    'message'=>'Пустая корзина'
                );
            }
            return $result;
        }

    }
        //==========================================================================================================

    $getData = new getData;

        //==========================================================================================================
?>