<?php

namespace models;


class promo_to_user extends \db
{
    ///////////////////////////////////for_backend///////////////////////////////////////////
    public function getAllData()
    {

        return $this->get(
            '
                SELECT * FROM
                    public.promo_to_user
            '
            ,
            [
            ],
            -1
        );
    }


    public function getOneData($id)
    {
        return $this->get(
            '
                SELECT *
                FROM public.promo_to_user
                WHERE
                    id = :id
            ',
            [
                'id' => $id
            ],
            -1
        );
    }

    public function getOneDataByCode($data)
    {
        return $this->get(
            "
                SELECT *
                FROM public.promo_to_user
                WHERE
                    code = :code
                    AND
                    email = :email
            ",
            [
                'code' => $data['code'],
                'email' => $data['email'],
            ],
            -1
        );
    }

    public function getPromoByCode($code) {
        return $this->get(
            '
                SELECT *
                FROM public.promo_to_user
                WHERE
                    code = :code',
            [
                'code' => $code
            ],
            -1
        );
    }

    public function deleteData($id)
    {
        return $this->exec(
            '   DELETE
                FROM
                    public.promo_to_user
                WHERE
                    id  = :id
            ',
            [
                'id' => $id
            ]
        );
    }

    public function addData($data)
    {

        return $this->get(
            '
                INSERT INTO
                    public.promo_to_user
                        (
                          code,
                          email

                        )
                        VALUES
                        (
                          :code,
                          :email

                        )
                        RETURNING id
            ',
            [
                'code' => $data['code'],
                'email' => $data['email'],

            ],
            -1
        );


    }

    public function updateData($data, $id)
    {

        return $this->exec(
            '
                UPDATE
                    public.promo_to_user
                SET
                    code = :code,
                    email = :email

                WHERE
                    id  = :id
            ',
            [
                'code' => $data['code'],
                'email' => $data['email'],
                'id' => $id
            ]
        );
    }

    public function countData()
    {
        return $this->get(
            '
                SELECT
                    COUNT(id) AS total
                FROM
                    public.promo_to_user
            ',
            [

            ],
            -1
        );
    }
}