mint/app/studio/dict_find_one.php

<?php
require_once "../path.php";
require_once "../public/_pdo.php";
require_once "../public/function.php";
require_once '../ucenter/setting_function.php';

if (isset($_GET["book"])) {
    $in_book = $_GET["book"];
}
if (isset($_GET["paragraph"])) {
    $in_para = $_GET["paragraph"];
}
if (isset($_GET["sn"])) {
    $in_sn = $_GET["sn"];
}
if (isset($_GET["type"])) {
    $type = $_GET["type"];
} else {
    $type = "wbw";
}
if (isset($_GET["dict_name"])) {
    $dict_name = $_GET["dict_name"];
} else {
    $dict_name = "";
}
if ($type == "part") {
    $lookup_loop = 3;
} else {
    $lookup_loop = 3;
}
if (isset($_GET["deep"])) {
    $lookup_loop = $_GET["deep"];
} else {
    $lookup_loop = 3;
}
$in_word = $_GET["word"];
if (isset($_GET["debug"])) {
    $debug = true;
} else {
    $debug = false;
}

if (mb_strlen($in_word) == 0) {
    exit;
}

function microtime_float()
{
    list($usec, $sec) = explode(" ", microtime());
    return ((float) $usec + (float) $sec);
}

$time_start = microtime_float();

$user_setting = get_setting();

//open database

global $PDO;
$word_list = str_getcsv($in_word);

$dict_word_spell = array();
$output = array();
$db_file_list = array();
//用户词典
if ($dict_name == "") {
    array_push($db_file_list, _FILE_DB_WBW1_);

    array_push($db_file_list, _DIR_DICT_SYSTEM_ . "/sys_regular.db");
    array_push($db_file_list, _DIR_DICT_SYSTEM_ . "/sys_irregular.db");
    array_push($db_file_list, _DIR_DICT_SYSTEM_ . "/union.db");
    array_push($db_file_list, _DIR_DICT_SYSTEM_ . "/comp.db");

    array_push($db_file_list, _DIR_DICT_3RD_ . "/pm.db");
    array_push($db_file_list, _DIR_DICT_3RD_ . "/bhmf.db");
    array_push($db_file_list, _DIR_DICT_3RD_ . "/shuihan.db");
    array_push($db_file_list, _DIR_DICT_3RD_ . "/concise.db");
    array_push($db_file_list, _DIR_DICT_3RD_ . "/uhan_en.db");
} else {
    $dict_list = str_getcsv($dict_name, ',');
    foreach ($dict_list as $dict) {
        array_push($db_file_list, $dict);
    }
}

$_dict_db = array();
foreach ($db_file_list as $db_file) {
    try {
        $dbh = new PDO("sqlite:" . $db_file, "", "");
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
        $_dict_db[] = array("file" => $db_file, "dbh" => $dbh);

    } catch (PDOException $e) {
        if ($debug) {
            print "Error!: " . $e->getMessage() . "<br/>";
        }
    }
}

for ($i = 0; $i < $lookup_loop; $i++) {
    $parent_list = array();
    $strQueryWord = "("; //单词查询字串
    foreach ($word_list as $word) {
        $word = str_replace("'", "’", $word);
        $strQueryWord .= "'{$word}',";
    }
    $strQueryWord = mb_substr($strQueryWord, 0, mb_strlen($strQueryWord, "UTF-8") - 1, "UTF-8");
    $strQueryWord .= ")";
    if ($debug) {
        echo "<h2>第" . ($i + 1) . "轮查询：" . count($word_list) . "</h2>";
    }
    foreach ($_dict_db as $db_file) {
        if ($debug) {
            echo "dict connect:{$db_file["file"]}<br>";
        }
        if ($i == 0) {
            $query = "select * from dict where \"pali\" in $strQueryWord ORDER BY rowid DESC";
        } else {
            $query = "select * from dict where  \"pali\" in $strQueryWord  AND ( type <> '.n.' AND  type <> '.ti.' AND  type <> '.adj.'  AND  type <> '.pron.'  AND  type <> '.v.' )   ORDER BY rowid DESC";
		}
		
        if ($debug) {
            echo $query . "<br>";
        }
        if ($db_file["dbh"]) {
            try {
                $stmt = $db_file["dbh"]->query($query);
                if ($stmt) {
                    $Fetch = $stmt->fetchAll(PDO::FETCH_ASSOC);
                } else {
                    $Fetch = array();
                    if ($debug) {
                        echo "无效的Statement句柄";
                    }
                }
            } catch (PDOException $e) {
                if ($debug) {
                    print "Error!: " . $e->getMessage() . "<br/>";
                }
                $Fetch = array();
            }
        } else {
            $Fetch = array();
            if ($debug) {
                echo "无效的数据库句柄";
            }
        }
        //$Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($debug) {
            echo "count:$iFetch<br>";
        }
        if ($iFetch > 0) {
            foreach ($Fetch as $one) {
                $id = $one["id"];
                if (isset($one["guid"])) {
                    $guid = $one["guid"];
                } else {
                    $guid = "";
                }
                if (isset($one["lang"])) {
                    $language = $one["lang"];
                } else if (isset($one["language"])) {
                    $language = $one["language"];
                } else {
                    $language = "en";
                }

                $pali = $one["pali"];
                $dict_word_spell["{$pali}"] = 1;
                $type = $one["type"];
                $gramma = $one["gramma"];
                $parent = $one["parent"];
                //$mean = $one["mean"];

                if (inLangSetting($language, $user_setting["dict.lang"])) {
                    $mean = $one["mean"];
                } else {
                    $mean = "";
                }

                $note = $one["note"];
                if (isset($one["factors"])) {
                    $parts = $one["factors"];
                } else if (isset($one["parts"])) {
                    $parts = $one["parts"];
                } else {
                    $parts = "";
                }

                if (isset($one["factormean"])) {
                    $partmean = $one["factormean"];
                } else if (isset($one["partmean"])) {
                    $partmean = $one["partmean"];
                } else {
                    $partmean = "";
                }

                if (inLangSetting($language, $user_setting["dict.lang"]) == false) {
                    $partmean = "";
                }

                $status = $one["status"];
                if (isset($one["confidence"])) {
                    $confidence = $one["confidence"];
                } else {
                    $confidence = 100;
                }

                if (isset($one["dict_name"])) {
                    $dict_name = $one["dict_name"];
                } else {
                    $dict_name = "";
                }

                array_push($output, array(
                    "id" => $id,
                    "guid" => $guid,
                    "pali" => $pali,
                    "type" => $type,
                    "gramma" => $gramma,
                    "parent" => $parent,
                    "mean" => $mean,
                    "note" => $note,
                    "parts" => $parts,
                    "partmean" => $partmean,
                    "status" => $status,
                    "confidence" => $confidence,
                    "dict_name" => $dict_name,
                    "language" => $language,
                ));
                //将语基插入下次查询的列表
                if (!empty($parent)) {
                    if ($pali != $parent) {
                        $parent_list[$parent] = 1;
                    }
                }
                //将拆分插入下次查询的列表
                if ($type != ".part.") {
                    if (!empty($parts)) {
                        $wordparts = str_getcsv($parts, '+');
                        foreach ($wordparts as $x) {
                            if (!empty($x)) {
                                if ($x != $pali) {
                                    $parent_list[$x] = 1;
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    /*
    if($i==0){
    //自动查找单词词干
    $word_base=getPaliWordBase($in_word);
    foreach($word_base as $x=>$infolist){
    foreach($infolist as $gramma){
    array_push($output,
    array("pali"=>$in_word,
    "parent"=>$x,
    "type"=>$gramma["type"],
    "gramma"=>$gramma["gramma"],
    "parts"=>$gramma["parts"],
    "partmean"=>"",
    "mean"=>"",
    "language"=>"en",
    "dict_name"=>"auto",
    "status"=>128
    ));
    $part_list=str_getcsv($gramma["parts"],"+");
    foreach($part_list as $part){
    $parent_list[$part]=1;
    }
    }
    }
    }
     */
    if ($debug) {
        echo "parent:" . count($parent_list) . "<br>";
        print_r($parent_list) . "<br>";
    }
    if (count($parent_list) == 0) {
        break;
    } else {
        $word_list = array();
        foreach ($parent_list as $x => $value) {
            array_push($word_list, $x);
        }
    }

}
//删除无效数据
$newOutput = array();
foreach ($output as $value) {
    if ($value["dict_name"] == "auto") {
        if (isset($dict_word_spell["{$value["parent"]}"])) {
            array_push($newOutput, $value);
        }
    } else {
        array_push($newOutput, $value);
    }
}

if ($debug) {
    echo "<textarea width=\"100%\" >";
}
echo json_encode($newOutput, JSON_UNESCAPED_UNICODE);
if ($debug) {
    echo "</textarea>";
}
if ($debug) {
    echo "生成：" . count($output) . "<br>";
    echo "有效：" . count($newOutput) . "<br>";
    foreach ($newOutput as $result) {
        echo "{$result["pali"]}-{$result["parent"]}-{$result["mean"]}<br>";
    }
    $queryTime = (microtime_float() - $time_start) * 1000;
    echo "<div >搜索时间：$queryTime 毫秒</div>";
}