1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / sathmcmy / public_html / classes /
Filename : Brand.php
back
<?php

$filepath = realpath(dirname(__FILE__));
include_once ($filepath.'/../lib/Database.php');
include_once ($filepath.'/../helpers/Format.php');

class Brand {

    private $db;
    private $fm;

    public function __construct()
    {
        
        $this->db= new Database();

        $this->fm= new Format();
        
    }

    public function brandInsert($brandName)
    {

        $brandName= $this->fm->validation($brandName);

        $brandName= mysqli_real_escape_string($this->db->link, $brandName);

        if(empty($brandName)) {

            $loginmsg= "<span style='text-align: center; color: red; border: 1px solid red; padding: .5rem 3rem;'>Brand must not be empty!</span>";
            return $loginmsg;

        } else {

            $query= "INSERT INTO tbl_brand (brandName) VALUES ('$brandName')";

            $brandinsert= $this->db->insert($query);

            if($brandinsert) {
                $msg= "<span style='color: green; text-align: center; border: 1px solid green; padding: .5rem 2rem;'>Brand inserted Successfully</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; text-align: center; border: 1px solid red; padding: .5rem 2rem;'>Brand not inserted</span>";
            }

        }

    }

    public function getAllBrand()
    {

        $query= "SELECT * FROM tbl_brand ORDER BY brandId DESC";

        $result= $this->db->select($query);

        return $result;

    }

    public function getBrandById($id) 
    {

        $id= $this->fm->validation($id);

        $id= mysqli_real_escape_string($this->db->link, $id);

        $query= "SELECT * FROM tbl_brand WHERE brandId= $id";

        $result= $this->db->select($query);

        return $result;

    }

    public function brandUpdate($brandName, $id)
    {

        $brandName= $this->fm->validation($brandName);
        $id= $this->fm->validation($id);

        $brandName= mysqli_real_escape_string($this->db->link, $brandName);
        $id= mysqli_real_escape_string($this->db->link, $id);

        if(empty($brandName) || empty($id)) {

            $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Brand field must not be empty!</span>";
            return $msg;

        } else {

            $query= "UPDATE tbl_brand SET brandName='$brandName' WHERE brandId=$id";
    
            $update_row= $this->db->update($query);
    
            if($update_row) {
                $msg= "<span style='color:green; padding: .5rem 2rem; border: 1px solid green;'>Brand Updated Successfully</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Brand Not Updated</span>";
                return $msg;
            }

        }

    }

    public function delBrandById($id)
    {

        $id= $this->fm->validation($id);

        $id= mysqli_real_escape_string($this->db->link, $id);

        $query= "DELETE FROM tbl_brand WHERE brandId=$id";

        $deldata= $this->db->delete($query);

        if($deldata) {
            $msg= "<span style='color: green; padding: .5rem 2rem; border: 1px solid green;'>Brand Deleted successfully</span>";
            return $msg;
        } else {
            $msg= "<span style='color: red; padding: .5rem 2rem; border: 1px solid red;'>Brand COuld not be deleted</span>";
            return $msg;
        }

    }

    public function getCopyrightText()
    {

        $query= "SELECT * FROM tbl_copy WHERE id=1";
        $res= $this->db->select($query);
        return $res;

    }

    public function updateCopyright($copy)
    {

        $query= "UPDATE tbl_copy SET copyright= '$copy' WHERE id=1";

        $res= $this->db->update($query);

        if($res) {
            $msg= "<span style='color: green; padding: .5rem 2rem; border: 1px solid green;'>Copyright text updated successfully</span>";
            return $msg;
        } else {
            $msg= "<span style='color: red; padding: .5rem 2rem; border: 1px solid red;'>Failed to update!</span>";
            return $msg;
        }

    }

    public function socialLinks()
    {

        $query= "SELECT * FROM tbl_social WHERE id=1";

        $res= $this->db->select($query);

        return $res;

    }

    public function updateSocial($fb, $ln, $gp, $tw)
    {

        $query= "UPDATE tbl_social SET fb='$fb', ln='$ln', tw='$tw', gp='$gp' WHERE id=1";

        $res= $this->db->update($query);

        return $res;

    }

    public function getAllimage()
    {

        $query= "SELECT * FROM tbl_image";

        $res= $this->db->select($query);

        return $res;

    }

    public function sliderInsert($data, $file)
    {

        $title = $data['title'];
        $title = mysqli_real_escape_string($this->db->link, $title);

        $permited= ['jpg', 'jpeg', 'png', 'gif'];

        $file_name= $file['image']['name'];
        $file_size= $file['image']['size'];
        $file_temp= $file['image']['tmp_name'];

        $div= explode('.', $file_name);

        $file_ext= strtolower(end($div));

        $unique_image= substr(md5(time()), 0, 10) . '.'. $file_ext;

        $uploaded_image= "upload/".$unique_image;

        if($title=="") {
            $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Field must not be empty.</span>";
            return $msg;
        } else {

            move_uploaded_file($file_temp, $uploaded_image);

            $query= "INSERT INTO tbl_image (title, image) VALUES ('$title', '$uploaded_image')";

            $inserted_row= $this->db->insert($query);

            if($inserted_row) {
                $msg= "<span style='color: green; border: 1px solid green; padding: .5rem 2rem;'>Slider inserted successfully.</span>";
                return $msg;
            } else {
                $msg= "<span style='color: red; border: 1px solid red; padding: .5rem 2rem;'>Slider not inserted!</span>";
                return $msg;
            }


        }

    }

    public function deleteSlider($id)
    {

        $query= "DELETE FROM tbl_image WHERE id=$id";
        $res= $this->db->select($query);

        return $res;

    }

    public function getMessageUnseenCount()
    {

        $query= "SELECT * FROM tbl_message WHERE seen_status=0";

        $res= $this->db->select($query);

        return $res->num_rows;

    }

    public function countUndeliveredOrders() {
        $query= "SELECT * FROM tbl_order WHERE status=0";
        
        $result= $this->db->select($query);

        $count= $result->num_rows;
        return $count;
    }

    public function countProcessingOrders() {
        $query= "SELECT * FROM tbl_order WHERE status=2";

        $result= $this->db->select($query);

        $count= $result->num_rows;

        return $count;

    }

    public function countDeliveredOrders() {
        $query= "SELECT * FROM tbl_order WHERE status=1";

        $result= $this->db->select($query);

        $count= $result->num_rows;

        return $count;
    }

}

?>