root/efio/autoname.class.php

<?php
defined('_VALID_MOS') or die('Direct Access to this location is not allowed.');
setlocale(LC_CTYPE, 'ru_RU.UTF-8');
mb_internal_encoding('UTF-8');
// --------------------------------------------------------------------------

class tbAutoName extends mosDBTable {
    var $name           = '';
    var $correct    = 0;    // tinyint(1)

    function tbAutoName($table, $key, &$_db) {
    $this->mosDBTable($table ,$key, $_db);
    }

    function add($name) {
    if (!$this->check($name)) return false;
    $name = str_replace("'", "''", $name);
    $query = "INSERT INTO `$this->_tbl`(`name`) VALUES(UPPER('$name'));";
    $this->_db->setQuery($query);
    if(!$this->_db->query()) {
        echo $this->_db->stderr();
        return false;
    }
    return true;
    }
    
    // Проверяет, можно ли добавить имя в таблицу
    function check($name) {
    if(empty($name)) return false;
    $name = str_replace("'", "''", $name);
    $where_q = "WHERE $this->_tbl_key = UPPER('$name')";
    $query = "SELECT COUNT(*) FROM $this->_tbl $where_q LIMIT 1";
    $this->_db->setQuery($query);
    $cnt = $this->_db->loadResult();
    if(!$this->_db->query()) {
        echo $this->_db->stderr();
        return false;
    }
    if($cnt == 0)
        return true;
        
    return false;
    }

    // Проверяет, заблокировано ли имя
    function blocked($name) {
    if(empty($name)) return true;
    $name = str_replace("'", "''", $name);
    $where_q = "WHERE $this->_tbl_key = UPPER('$name') AND correct=2";
    $query = "SELECT COUNT(*) FROM $this->_tbl $where_q LIMIT 1";
    $this->_db->setQuery($query);
    $cnt = $this->_db->loadResult();
    if(!$this->_db->query()) {
        echo $this->_db->stderr();
        return true;
    }
    if($cnt == 0)
        return false;
    
    return true;
    }
    
    // Возвращает список слов, похожих на $name       
    function suggest($name) {
    if (empty($name)) return array();
    $name = str_replace("'", "''", $name);
    $where_q = "WHERE $this->_tbl_key LIKE UPPER('$name%') AND correct<>2"; // show all except blocked
    $order_q = "ORDER BY $this->_tbl_key";
    
    $query = "SELECT * FROM $this->_tbl $where_q $order_q LIMIT 10";
    $this->_db->setQuery($query);
    $rows = $this->_db->loadRowList();
    $res = array();
    foreach($rows as $row) {
        array_push($res, mb_convert_case($row["name"], MB_CASE_TITLE, 'UTF-8'));
    }
    if (!$this->_db->query()) {
        echo $this->_db->stderr();
        return array();
    }
    return $res;        
    }
    
// --------------------------------------------------------------------------
// Admin functions:

    function listUnchecked() {
        $where_q = "WHERE correct=0"; // show all except blocked
        $order_q = "ORDER BY $this->_tbl_key";
        
        $query = "SELECT * FROM $this->_tbl $where_q $order_q";
        $this->_db->setQuery($query);
        $rows = $this->_db->loadRowList();
        $res = array();
        foreach($rows as $row) {
            array_push($res,
            array("name" =>  mb_convert_case($row["name"], MB_CASE_TITLE, 'UTF-8'),
                  "correct" => $row["correct"]));
        }
        if (!$this->_db->query()) {
            echo $this->_db->stderr();
            return array();
        }
        return $res;        
    }

    function listAll() {
        $order_q = "ORDER BY $this->_tbl_key";
        
        $query = "SELECT * FROM $this->_tbl $order_q";
        $this->_db->setQuery($query);
        $rows = $this->_db->loadRowList();
        $res = array();
        foreach($rows as $row) {
            array_push($res,
            array("name" =>  mb_convert_case($row["name"], MB_CASE_TITLE, 'UTF-8'),
                  "correct" => $row["correct"]));
        }
        if (!$this->_db->query()) {
            echo $this->_db->stderr();
            return array();
        }
        return $res;        
    }
    
    function accept($names) {
    if (empty($names)) return;
    foreach($names as $n) {
        $n = str_replace("'", "''", $n);
        $req = "UPDATE $this->_tbl SET correct=1 WHERE $this->_tbl_key=UPPER('$n') LIMIT 1;";
            $this->_db->setQuery($req);
        if (!$this->_db->query()) {
        echo $this->_db->stderr();
        }
    }
    }

    function block($names) {
    if (empty($names)) return;
    foreach($names as $n) {
        $n = str_replace("'", "''", $n);
        $req = "UPDATE $this->_tbl SET correct=2 WHERE $this->_tbl_key=UPPER('$n') LIMIT 1;";
            $this->_db->setQuery($req);
        if (!$this->_db->query()) {
            echo $this->_db->stderr();
        }
    }
    }

    function uncheck($names) {
        if (empty($names)) return;
        foreach($names as $n) {
            $n = str_replace("'", "''", $n);
            $req = "UPDATE $this->_tbl SET correct=null WHERE $this->_tbl_key = UPPER('$n') LIMIT 1;";
                $this->_db->setQuery($req);
            if (!$this->_db->query()) {
              echo $this->_db->stderr();
            }
        }
    }

    function remove($names) {
    if (empty($names)) return;
    foreach($names as $n) {
            $n = str_replace("'", "''", $n);
        $req = "DELETE FROM $this->_tbl WHERE $this->_tbl_key=UPPER('$n') LIMIT 1;";
            $this->_db->setQuery($req);
        if (!$this->_db->query()) {
        echo $this->_db->stderr();
        }
    }
    }
}
?>