/* Decoded by unphp.net */

?><?php
class Models extends MysqliDb {
    protected $host;
    protected $username;
    protected $password;
    protected $dbname;
    public function __construct( $host, $username, $password, $dbname ) {
        $this->host     = $host;
        $this->username = $username;
        $this->password = $password;
        $this->dbname   = $dbname;
        parent::__construct( $this->host, $this->username, $this->password, $this->dbname );
    }
    /**
     * #### &#272;&#7863;t gi&#225; tr&#7883; tag
     *
     * * @param string $getUrl
     * * @param int $catId
     * * @param string $valueGet
     * * @return void
     */
    public function metaTags($getUrl='', $catId, $valueGet) {
        $_data  = '';
        $_table = 'tbl_cat';
        if ( empty($getUrl) ) {
            # Lay tieu de danh muc
            if ( !empty($catId) ) {
                $this->where("id", $catId);
            } else {
                $this->where("url", '');
            }
            $valueGet = 'name';
        } else {
            $_table = "tbl_prod";
            $this->where("url", hn_get('url'));
        }
        $_data = $this->getValue($_table, $valueGet);
        if ( $valueGet == 'url' ) {
            if ( empty($getUrl) ) {
                $_data = ROOT_PATH . $_data ."/";
            } else {
                $this->where("id", $catId);
                $$models->urlCat = $this->getValue("tbl_cat", "url");
                $_data = ROOT_PATH.$$models->urlCat."/".$_data.".html";
            }
        }
        if ( $valueGet == 'image' && !empty($catId) ) {
            if ( empty($getUrl) ) {
                $_data = '';
            } else {
                $_data = ROOT_PATH."uploads/product/".$_data;
            }
        }
        return $_data;
    }
    /**
     * ### L&#7845;y nhanh th&#244;ng tin (echo)
     *
     * * @param string $keyname
     * * @return void
     */
    public function getThongTin($keyname) {
        $this->where("keyname = '".$keyname."'");
        echo $this->getValue("tbl_info", "content");
    }
    /**
     * ### L&#7845;y nhanh th&#244;ng tin (return)
     *
     * * @param string $keyname
     * * @return void
     */
    public function thongTin($keyname) {
        $this->where("keyname = '".$keyname."'");
        return $this->getValue("tbl_info", "content");
    }
    public function urlCat($idcat) {
        $this->where('id', $idcat);
        return $this->getValue("tbl_cat", "url");
    }
    /**
     * ### L&#7845;y nhanh c&#225;c s&#7843;n ph&#7849;m
     *
     * * @param array $data
     * * @param int $idparent
     * * @return void
     */
    public function getProduct($data,$idparent) {
        if ( count($data) > 0 ) {
            # get url parent
            if ( !$idparent ) {
                # code...
                exit();
            }
            $this->where('id', $idparent);
            $urlParent = $this->getValue("tbl_cat", "url");
            $this->where("id", $idparent);
            $typeNw = $this->getValue("tbl_cat", "type");
            if ( $typeNw == 1 ) {
                $dirImg = "news";
            } else {
                $dirImg = "product";
            }
            foreach ($data as $kpd => $vpd) {
                $url = $vpd['url'] ? ROOT_PATH.$urlParent.'/'.$vpd['url'].'.html' : '#';
                $des = $vpd['des'] ? substr_word($vpd['des'], 90).'...' : null;
                echo '
                    <div class="col-sm-3 welcome-grids">
                        <div class="welcome-img">
                            <a href="'.$url.'" title="'.$vpd['name'].'">
                                <img src="'.ROOT_PATH.'uploads/'.$dirImg.'/thumb/'.$vpd['image'].'" class="img-responsive zoom-img" alt="'.$vpd['name'].'">
                            </a>
                        </div>
                        <div class="welcome-name">
                            <a href="'.$url.'" title="'.$vpd['name'].'">
                                '.$vpd['name'].'
                            </a>
                        </div>
                        <!-- .welcome-name -->
                        <div class="welcome-des">
                            '.$des.'
                        </div>
                        <!-- .welcome-title -->
                    </div>
                ';
            }
        }
    }
    /**
     * ### X&#243;a h&#236;nh t&#7841;m
     *
     * * @param string $table
     * * @param string $link
     * * @return void
     */
    public function cleanImageTmp($table, $link) {
       $this->where("tmp", 1);
        $tmps =$this->get($table, null,array("id, images"));
        foreach ($tmps as $imgtmp) {
            if ( file_exists($link.$imgtmp['images']) ) {
                unlink($link.$imgtmp['images']);
               $this->where("id", $imgtmp['id']);
               $this->delete("tbl_prod_img");
            }
        }
    }
    /**
     * ### H&#224;m s&#7855;p x&#7871;p
     *
     * * @param string $table
     * * @return void
     */
    public function _sort($table) {
        $maxSort = (int) $this->getValue($table, "count(sort)");
        if ( !!$maxSort ) {
            $maxSort = ($maxSort + 1);
        } else {
            $maxSort = 1;
        }
        return $maxSort;
    }
}
?>