mint/app/studio/term-.php

<?php
//查询term字典
require_once "../path.php";
require_once "../public/_pdo.php";
require_once "./public.inc";
require_once "../public/load_lang.php";

$username = "";
if (isset($_COOKIE["username"]) && !empty($_COOKIE["username"])) {
    $username = $_COOKIE["username"];
}

$op = $_GET["op"];
if (isset($_GET["word"])) {
    if (empty($_GET["word"])) {
        return;
    }
    $word = mb_strtolower($_GET["word"], 'UTF-8');
    $org_word = $word;
}

if (isset($_GET["list"])) {
    $list = $_GET["list"];
}

$count_return = 0;
$dict_list = array();

global $PDO;
PDO_Connect("" . _FILE_DB_TERM_);
switch ($op) {
    case "pre": //预查询

        echo "<wordlist>";
        $query = "select word,count from dict where \"eword\" like " . $PDO->quote($word . '%') . " OR \"word\" like " . $PDO->quote($word . '%') . "  limit 0,100";
        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($iFetch > 0) {
            for ($i = 0; $i < $iFetch; $i++) {
                $outXml = "<word>";
                $word = $Fetch[$i]["word"];
                $outXml = $outXml . "<pali>$word</pali>";
                $outXml = $outXml . "<count>" . $Fetch[$i]["count"] . "</count>";
                $outXml = $outXml . "</word>";
                echo $outXml;
            }
        }
        echo "</wordlist>";
        break;
    case "my":
        $query = "select guid,word,meaning,other_meaning from term  where owner= " . $PDO->quote($username);
        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($iFetch > 0) {
            echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
        }
        break;
    case "allpali":
        $query = "select word from term  where 1 group by word";
        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($iFetch > 0) {
            echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
        }
        break;

    case "allmean":
        $query = "select meaning from term  where \"word\" = " . $PDO->quote($word) . " group by meaning";
        $Fetch = PDO_FetchAll($query);
        foreach ($Fetch as $one) {
            echo "<a>" . $one["meaning"] . "</a> ";
        }
        //echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
        break;
    case "load_id":
        if (isset($_GET["id"])) {
            $id = $_GET["id"];
            $query = "select * from term  where \"guid\" = " . $PDO->quote($id);
            $Fetch = PDO_FetchAll($query);
            echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
        } else {
            echo "{}";
        }
        break;
    case "search":
        //查本人数据
        echo "<div>" . $module_gui_str['editor']['1122'] . "</div>"; //My Term
        $query = "select * from term  where \"word\" = " . $PDO->quote($word) . " AND \"owner\"= " . $PDO->quote($username) . " limit 0,30";

        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        $count_return += $iFetch;
        if ($iFetch > 0) {
            for ($i = 0; $i < $iFetch; $i++) {
                $mean = $Fetch[$i]["meaning"];
                $guid = $Fetch[$i]["guid"];
                $dict_list[$guid] = $Fetch[$i]["owner"];
                echo "<div class='dict_word'>";
                echo "<a name='ref_dict_$guid'></a>";
                echo "<div class='dict'>$word</div>";
                echo "<div id='term_dict_my_$guid'>";
                echo "<div class='mean'>" . $mean . "</div>";
                echo "<div class='other_mean'>" . $Fetch[$i]["other_meaning"] . "</div>";
                echo "<div class='term_note' status=0>" . $Fetch[$i]["note"] . "</div>";
                echo "</div>";
                //编辑词条表单
                echo "<div id='term_dict_my_edit_$guid' style='display:none'>";
                echo "<input type='hidden' id='term_edit_word_$guid' value='$word' />";
                echo "<div class='mean'><input type='input' id='term_edit_mean_$guid'  placeholder='" . $_local->gui->g_mean . "'value='$mean' /></div>"; //'意思'
                echo "<div class='other_mean'><input type='input' id='term_edit_mean2_$guid'  placeholder=" . $_local->gui->other_meaning . " value='" . $Fetch[$i]["other_meaning"] . "' /></div>"; //'备选意思（可选项）'
                echo "<div class='note'><textarea  id='term_edit_note_$guid'  placeholder='" . $_local->gui->note . "'>" . $Fetch[$i]["note"] . "</textarea></div>"; //'注解'
                echo "</div>";
                echo "<div id='term_edit_btn1_$guid'>";
                echo "<button onclick=\"term_apply('$guid')\">" . $_local->gui->apply . "</button>"; //Apply
                echo "<button onclick=\"term_edit('$guid')\">" . $_local->gui->edit . "</button>"; //Edit
                echo "</div>";
                echo "<div id='term_edit_btn2_$guid'  style='display:none'>";
                echo "<button onclick=\"term_data_esc_edit('$guid')\">" . $_local->gui->cancel . "</button>"; //Cancel
                echo "<button onclick=\"term_data_save('$guid')\">" . $_local->gui->cancel . "</button>"; //保存
                echo "</div>";
                echo "</div>";
            }
        }
        //新建词条
        echo "<div class='dict_word'>";
        echo "<div class='dict'>" . $_local->gui->new_technic_term . "</div>"; //New Techinc Term
        echo "<div class='mean'>";
        echo "<span>" . $_local->gui->spell . "：</span>";
        echo "<input type='input' placeholder=" . $_local->gui->spell . " id='term_new_word' value='{$word}' />";
        echo "</div>"; //'拼写'
        echo "<div class='mean'>";
        echo "<span>" . $_local->gui->g_mean . "：</span>";
        echo "<input type='input' placeholder='" . $_local->gui->g_mean . "' id='term_new_mean'/>";
        echo "</div>"; //'意思'
        echo "<div class='other_mean'>";
        echo "<span>" . $_local->gui->other_meaning . "：</span>";
        echo "<input type='input'  placeholder='" . $_local->gui->other_meaning . "' id='term_new_mean2'/>";
        echo "</div>"; //'备选意思（可选项）'
        echo "<div class='tag'>";
        echo "<span>" . $_local->gui->tag . "：</span>";
        echo "<input type='input'  placeholder='" . $_local->gui->tag . "' id='term_new_tag'/>";
        echo "</div>"; //'标签'
        echo "<div class='note'>";
        echo "<span>" . $_local->gui->note . "：</span>";
        echo "<textarea width='100%' height='3em'  placeholder='" . $_local->gui->note . "' id='term_new_note'></textarea>";
        echo "</div>"; //'注解'
        echo "<button onclick=\"term_data_save('')\">" . $_local->gui->save . "</button>"; //保存
        echo "</div>";

        //查他人数据
        $query = "select * from term  where \"word\" = " . $PDO->quote($word) . "AND \"owner\" <> " . $PDO->quote($username) . " limit 0,30";

        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        $count_return += $iFetch;
        if ($iFetch > 0) {
            for ($i = 0; $i < $iFetch; $i++) {
                $mean = $Fetch[$i]["meaning"];
                $guid = $Fetch[$i]["guid"];
                $dict_list[$guid] = $Fetch[$i]["owner"];
                echo "<div class='dict_word'>";
                echo "<a name='ref_dict_$guid'></a>";
                echo "<div class='dict'>" . $Fetch[$i]["owner"] . "</div>";
                echo "<div class='mean'>" . $mean . "</div>";
                echo "<div class='other_mean'>" . $Fetch[$i]["other_meaning"] . "</div>";
                echo "<div class='note'>" . $Fetch[$i]["note"] . "</div>";
                echo "<button onclick=\"term_data_copy_to_me($guid)\">" . $module_gui_str['editor']['1123'] . "</button>"; //复制
                echo "</div>";
            }
        }

        //查内容
        if ($count_return < 2) {
            $word1 = $org_word;
            $wordInMean = "%$org_word%";
            echo $module_gui_str['editor']['1124'] . "：$org_word<br />";
            $query = "select * from term  where \"meaning\" like " . $PDO->quote($word) . " limit 0,30";
            $Fetch = PDO_FetchAll($query);
            $iFetch = count($Fetch);
            $count_return += $iFetch;
            if ($iFetch > 0) {
                for ($i = 0; $i < $iFetch; $i++) {
                    $mean = $Fetch[$i]["meaning"];
                    $pos = mb_stripos($mean, $word, 0, "UTF-8");
                    if ($pos) {
                        if ($pos > 20) {
                            $start = $pos - 20;
                        } else {
                            $start = 0;
                        }
                        $newmean = mb_substr($mean, $start, 100, "UTF-8");
                    } else {
                        $newmean = $mean;
                    }
                    $pos = mb_stripos($newmean, $word1, 0, "UTF-8");
                    $head = mb_substr($newmean, 0, $pos, "UTF-8");
                    $mid = mb_substr($newmean, $pos, mb_strlen($word1, "UTF-8"), "UTF-8");
                    $end = mb_substr($newmean, $pos + mb_strlen($word1, "UTF-8"), null, "UTF-8");
                    $heigh_light_mean = "$head<hl>$mid</hl>$end";
                    $outXml = "<div class='dict_word'>";
                    $outXml = $outXml . "<div class='dict'>" . $Fetch[$i]["owner"] . "</div>";
                    $outXml = $outXml . "<div class='pali'>" . $Fetch[$i]["word"] . "</div>";
                    $outXml = $outXml . "<div class='mean'>" . $heigh_light_mean . "</div>";
                    $outXml = $outXml . "<div class='note'>{$Fetch[$i]["note"]}</div>";
                    $outXml = $outXml . "</div>";
                    echo $outXml;
                }
            }
        }
        //查内容结束

        echo "<div id='dictlist'>";
        foreach ($dict_list as $x => $x_value) {
            echo "<a href='#ref_dict_$x'>$x_value</a><br/>";
        }
        echo "</div>";

        break;
    case "save":
        if ($_GET["guid"] != "") {
            $mean = $_GET["mean"];
            $query = "UPDATE term SET meaning='$mean' ,
									other_meaning='" . $_GET["mean2"] . "' ,
									note='" . $_GET["note"] . "'
							where guid='" . $_GET["guid"] . "'";
        } else {
            $newGuid = GUIDv4();
            $newGuid = str_replace("-", "", $newGuid);
            $word = $_GET["word"];
            $worden = pali2english($word);
            $mean = $_GET["mean"];
            $mean2 = $_GET["mean2"];
            $note = $_GET["note"];
            $tag = $_GET["tag"];
            $time = time();
            $query = "INSERT INTO term VALUES (NULL,
											'$newGuid',
											'$word',
											'$worden',
											'$mean',
											'$mean2',
											'$note',
											'$tag',
											'$time',
											'$username',
											'1',
											'zh',
											'0',
											'0',
											'0')";
        }
        $stmt = @PDO_Execute($query);
        $respond = array("status" => 0, "message" => "");
        if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
            $error = PDO_ErrorInfo();
            $respond['status'] = 1;
            $respond['message'] = $error[2];
        } else {
            $respond['status'] = 0;
            $respond['message'] = $word;
        }
        echo json_encode($respond, JSON_UNESCAPED_UNICODE);
        break;
    case "copy": //拷贝到我的字典

        $query = "select * from term  where \"guid\" = " . $PDO->quote($_GET["wordid"]);

        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($iFetch > 0) {
            /* 开始一个事务，关闭自动提交 */
            $PDO->beginTransaction();
            $query = "INSERT INTO term ('id','guid','word','word_en','meaning','other_meaning','note','tag','create_time','owner','hit') VALUES (null,?,?,?,?,?,?,?," . time() . ",'$username',1)";
            $stmt = $PDO->prepare($query);
            {
                $stmt->execute(array(GUIDv4(false),
                    $Fetch[0]["word"],
                    $Fetch[0]["word_en"],
                    $Fetch[0]["meaning"],
                    $Fetch[0]["other_meaning"],
                    $Fetch[0]["note"],
                    $Fetch[0]["tag"],
                ));
            }
            /* 提交更改 */
            $PDO->commit();
            if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
                $error = PDO_ErrorInfo();
                echo "error - $error[2] <br>";
            } else {
                echo "updata ok.";
            }
        }
        break;
    case "extract":

        $query = "select * from term  where \"guid\" in ($list)  limit 0,1000";
        $Fetch = PDO_FetchAll($query);
        $iFetch = count($Fetch);
        if ($iFetch > 0) {
            echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
        }
        break;
}