mint/app/term/term.php

<?php
//查询term字典

require_once "../path.php";
require_once "../public/_pdo.php";
require_once '../public/load_lang.php';
require_once '../public/function.php';

//is login
if(isset($_COOKIE["username"])){
	$username = $_COOKIE["username"];
}
else{
	$username = "";
}
if(isset($_GET["language"])){
	$currLanguage=$_GET["language"];
}
else{
	if(isset($_COOKIE["language"])){
		$currLanguage=$_COOKIE["language"];
	}
	else{
		$currLanguage="en";
	}
}

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

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

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

global $PDO;
PDO_Connect("sqlite:"._FILE_DB_TERM_);
switch($op){
	case "pre"://预查询
	{
		$query = "select word,meaning from term where \"eword\" like ".$PDO->quote($word.'%')." OR \"word\" like ".$PDO->quote($word.'%')." group by word limit 0,10";
		$Fetch = PDO_FetchAll($query);
		if(count($Fetch)<5){
			$query = "select word,meaning from term where \"eword\" like ".$PDO->quote('%'.$word.'%')." OR \"word\" like ".$PDO->quote('%'.$word.'%')." group by word limit 0,10";
			$Fetch2 = PDO_FetchAll($query);
			//去掉重复的
			foreach($Fetch2 as $onerow){
				$found=false;
				foreach($Fetch as $oldArray){
					if($onerow["word"]==$oldArray["word"]){
						$found=true;
						break;
					}
				}
				if($found==false){
					array_push($Fetch,$onerow);
				}
			}
			if(count($Fetch)<8){
				$query = "select word,meaning from term where \"meaning\" like ".$PDO->quote($word.'%')." OR \"other_meaning\" like ".$PDO->quote($word.'%')." group by word limit 0,10";
				$Fetch3 = PDO_FetchAll($query);
				
				$Fetch = array_merge($Fetch,$Fetch3);
				if(count($Fetch)<8){
					$query = "select word,meaning from term where \"meaning\" like ".$PDO->quote('%'.$word.'%')." OR \"other_meaning\" like ".$PDO->quote('%'.$word.'%')." group by word limit 0,10";
					$Fetch4 = PDO_FetchAll($query);
					//去掉重复的
					foreach($Fetch4 as $onerow){
						$found=false;
						foreach($Fetch as $oldArray){
							if($onerow["word"]==$oldArray["word"]){
								$found=true;
								break;
							}
						}
						if($found==false){
							array_push($Fetch,$onerow);
						}
					}
				}
			}
		}
		echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
		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 json_encode(array(), JSON_UNESCAPED_UNICODE);	
		}
		break;
	}
	case "search":
	{
		if(!isset($word)){
			return;
		}
		if(trim($word)==""){
			return;
		}
		echo"<div class='pali'>{$word}</div>";
		//查本人数据
		echo "<div></div>";//My Term
		$query = "select * from term  where word = ? AND  owner = ? limit 0,30";
		$Fetch = PDO_FetchAll($query,array($word,$_COOKIE["userid"]));
		$iFetch=count($Fetch);
		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 id='term_dict_my_$guid'>";
				echo "<div class='dict'>{$_local->gui->my_term}</div>";
				echo "<div class='mean'><span>".$mean."</span>";
				echo "<span class='other_mean' style='margin-right: auto;'>（".$Fetch[$i]["other_meaning"]."）</span></div>";
				echo "<div class='tag'>{$Fetch[$i]["tag"]}</div>";
				echo "<div class='mean'>{$Fetch[$i]["channal"]}</div>";				
				echo "<div class='mean'>{$Fetch[$i]["language"]}</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' style='display:flex;'><span style='flex:1;'>{$_local->gui->first_choice_word}：</span>";
				echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->required}' id='term_edit_mean_{$guid}' value='$mean' /></div>";//'意思'
		
				echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->other_meaning}：</span>";
				echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_edit_mean2_{$guid}' value='".$Fetch[$i]["other_meaning"]."'/></div>";//'备选意思（可选项）'

				echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->tag}：</span>";
				echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_edit_tag_{$guid}' value='".$Fetch[$i]["tag"]."'/></div>";//'标签'

				echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->channel}：</span>";
				echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_edit_channal_{$guid}' value='".$Fetch[$i]["channal"]."'/></div>";//'版风'
				
				echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->language}：</span>";
				echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_edit_language_{$guid}' value='".$Fetch[$i]["language"]."'/></div>";//'语言'

				echo "<div class='note'><span style='display:flex;'><span>{$_local->gui->encyclopedia} & {$_local->gui->note}：</span>";
				echo "<guide gid='term_pedia_sys' style='margin-left: auto;'></guide></span>";
				echo "<textarea width='100%' height='3em'  placeholder='{$_local->gui->optional}' id='term_edit_note_$guid'>".$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->save}</button>";//保存
				echo "</div>";
				echo "</div>";
			}
		}
		//新建词条
		echo "<div class='dict_word'>";
		echo "<button id='new_term_button' onclick=\"term_show_new()\">{$_local->gui->new}</button>";
		echo "<div id='term_new_recorder' style='display:none;'>";
		echo "<div class='dict'>".$_local->gui->new_technic_term."</div>";//New Techinc Term
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->pali_word}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->required}' id='term_new_word' value='{$word}' /></div>";//'拼写'
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->first_choice_word}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->required}' id='term_new_mean'/></div>";//'意思'
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->other_meaning}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_new_mean2'/></div>";//'备选意思（可选项）'
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->tag}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_new_tag'/></div>";//'标签'
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->channel}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_new_channal'/></div>";//'标签'
		
		echo "<div class='mean' style='display:flex;'><span style='flex:1;'>{$_local->gui->language}：</span>";
		echo "<input type='input' style='flex:3;' placeholder='{$_local->gui->optional}' id='term_new_language'/></div>";//'标签'
		
		echo "<div class='note'><span style='display:flex;'><span>{$_local->gui->encyclopedia} & {$_local->gui->note}：</span>";
		echo "<guide gid='term_pedia_sys' style='margin-left: auto;'></guide></span>";
		echo "<textarea width='100%' height='3em'  placeholder='{$_local->gui->optional}' id='term_new_note'></textarea></div>";//'注解'
		
		echo "<button onclick=\"term_data_save('')\">{$_local->gui->save}</button>";//保存
		echo "</div>";
		echo "</div>";

		
		//查他人数据
		$query = "SELECT * FROM term  WHERE word = ? AND owner <> ? LIMIT 0,30";
		
		$Fetch = PDO_FetchAll($query,array($word,$_COOKIE["userid"]));
		$iFetch=count($Fetch);
		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='term_note'>".$Fetch[$i]["note"]."</div>";
				echo "<button onclick=\"term_data_copy_to_me($guid)\">{$_local->gui->copy}</button>";//复制
				echo "</div>";
			}
		}

		echo "<div id='dictlist'>";
		echo "</div>";
		
		break;
	}
	case "save":
	{
		$currTime=sprintf("%d",microtime(true)*1000);
		if(isset($_GET["modify_time"])){
			$mTime=$_GET["modify_time"];
		}
		else{
			$mTime=mTime();
		}
		if($_GET["guid"]!=""){
			$query="UPDATE term SET meaning= ? ,other_meaning = ? , tag= ? ,channal = ? ,  language = ? , note = ? , receive_time= ?, modify_time= ?   where guid= ? ";
			$stmt = @PDO_Execute($query,array($_GET["mean"],
																		$_GET["mean2"],
																		$_GET["tag"],
																		$_GET["channal"],
																		$_GET["language"],
																		$_GET["note"],
																		mTime(),
																		$mTime,
																		$_GET["guid"]
																	));
		}
		else{
			$parm = array();
			$parm[]=UUID::v4();
			$parm[]=$_GET["word"];
			$parm[]=pali2english($word);
			$parm[]=$_GET["mean"];
			$parm[]=$_GET["mean2"];
			$parm[]=$_GET["tag"];			
			$parm[]=$_GET["channal"];			
			$parm[]=$_GET["language"];			
			$parm[]=$_GET["note"];
			$parm[]=$_COOKIE["userid"];
			$parm[]=0;
			$parm[]=mTime();
			$parm[]=mTime();
			$parm[]=mTime();
			$query="INSERT INTO term (id, guid, word, worden, meaning, other_meaning, tag, channal, language,note,owner,hit,create_time,modify_time,receive_time ) 
															VALUES (NULL, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "; 

			$stmt = @PDO_Execute($query,$parm);
		}
			
			$respond=array("status"=>0,"message"=>"");
			if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
				$error = PDO_ErrorInfo();
				$respond['status']=1;
				$respond['message']=$error[2].$query;
			}
			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(UUID::v4,
								$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":
	{
		if(isset($_POST["words"])){
			$words=$_POST["words"];
		}
		if(isset($_POST["authors"])){
			$authors=str_getcsv($_POST["authors"]);
		}
		$queryLang = $currLanguage."%";
		$query = "SELECT * from term  where \"word\" in {$words} AND language like ?  limit 0,1000";
		$Fetch = PDO_FetchAll($query,array($queryLang));
		$iFetch=count($Fetch);
		echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
		break;
	}
	case "sync":
	{
		$time=$_GET["time"];
		$query = "SELECT guid,modify_time from term  where receive_time>'{$time}'   limit 0,1000";
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
		break;
	}
	case "get":
	{
		$Fetch = array();
		if(isset($guid)){
			$query = "select * from term  where \"guid\" = '{$guid}'";
		}
		else if(isset($word)){
			$query = "select * from term  where \"word\" = '{$word}'";
		}
		else{
			echo "[]";
			return;
		}
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);

		break;
	}
	
}


?>