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("sqlite:"._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;
}


?>