iapt-platform
/
mint
mirror da https://github.com/iapt-platform/mint.git


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062
							<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link type="text/css" rel="stylesheet" href="css/style.css"/>
	<link type="text/css" rel="stylesheet" href="css/color_day.css" id="colorchange" />
	<link type="text/css" rel="stylesheet" href="css/style_mobile.css" media="screen and (max-width:767px)">

</head>
<body>
<?php
//工程文件操作
//建立，
require_once '../path.php';
require_once "../public/_pdo.php";
require_once "../public/function.php";
require_once "../public/load_lang.php";
require_once "./book_list_en.inc";
require_once "../ucenter/function.php";
require_once "../ucenter/setting_function.php";

$user_setting = get_setting();

$sLang["1"]="pali";
$sLang["2"]="en";
$sLang["3"]="sc";
$sLang["4"]="tc";

if(isset($_POST["op"])){
	$op=$_POST["op"];
}
if(isset($_GET["op"])){
	$op=$_GET["op"];
}
if(isset($_POST["data"])){
	$data=$_POST["data"];
}
else if(isset($_GET["data"])){
	$data=$_GET["data"];
}
if($_COOKIE["uid"]){
	$uid = $_COOKIE["uid"];
	$USER_ID = $_COOKIE["userid"];
	$USER_NAME = $_COOKIE["username"];
}
else{
	echo '<a href="../ucenter/index.php" target="_blank">'.$_local->gui->not_login.'</a>';
	exit;
}
switch($op){
	case "create":
		//判断单词数量 太大的不能加载
		$res=json_decode($data);
		$res_book = $res[0]->book;
		$paraList=$res[0]->parlist;
		$paraList=rtrim($paraList,",");
		$strQueryParaList=str_replace(",","','",$paraList);
		$strQueryParaList="('".$strQueryParaList."')";
		PDO_Connect("sqlite:"._FILE_DB_PALITEXT_);
		$query="SELECT sum(lenght) as sum_str FROM pali_text WHERE \"book\" = ".$PDO->quote($res_book)." AND (\"paragraph\" in {$strQueryParaList} ) ";
		$Fetch = PDO_FetchAll($query);
		if(count($Fetch)>0){
			if($Fetch[0]["sum_str"]>15000){
				echo $_local->gui->oversize_to_load;
				exit;
			}
		}
		//判断单词数量 结束

	if(isset($_POST["format"]) && $_POST["format"]=="db"){
		$res=json_decode($data);
		
		$title=$res[0]->title;
		$title_en=pali2english($title);
		$book=$res[0]->book;
		if(substr($book,0,1)=="p"){
			$book=substr($book,1);
		}
		$paragraph=$res[0]->parNum;
		$tag="[$title]";
		$paraList=$res[0]->parlist;
		$paraList=rtrim($paraList,",");
		$strQueryParaList=str_replace(",","','",$paraList);
		$strQueryParaList="('".$strQueryParaList."')";
		$aParaList=str_getcsv($paraList);
		$create_para=$aParaList[0];
		echo $strQueryParaList;
		echo "<textarea>";
		print_r($res);
		echo "</textarea>";	
		$user_title=$_POST["title"];	
		$doc_head ="    <head>\n";
		$doc_head.="        <type>pcdsset</type>\n";
		$doc_head.="        <mode>package</mode>\n";
		$doc_head.="        <ver>1</ver>\n";
		$doc_head.="        <toc></toc>\n";
		$doc_head.="        <style></style>\n";
		$doc_head.="        <doc_title>$user_title</doc_title>\n";
		$doc_head.="        <tag>$tag</tag>\n";
		$doc_head.="        <book>$book</book>\n";
		$doc_head.="        <paragraph>$paragraph</paragraph>\n";
		$doc_head.="    </head>\n";		
		for($iRes=0;$iRes<count($res);$iRes++){
			$get_res_type=$res[$iRes]->type;
			echo "iRes: $iRes,type:$get_res_type<br/>";
			$res_album_id=$res[$iRes]->album_id;
			$res_book=$res[$iRes]->book;
			$get_par_begin=$res[$iRes]->parNum;
			$language=$res[$iRes]->language;
			$author=$res[$iRes]->author;
			
			$db_file = _FILE_DB_RESRES_INDEX_;
			PDO_Connect("sqlite:$db_file");
			$query = "select guid,owner from 'album' where id='{$res_album_id}'";
			$Fetch = PDO_FetchAll($query);
			if(count($Fetch)>0){
				$res_album_guid=$Fetch[0]["guid"];
				$res_album_owner=$Fetch[0]["owner"];
			}
			else{
				$res_album_guid=UUID::v4();
				$res_album_owner=0;
			}
			
			switch($get_res_type){
				case "6"://逐词译模板
				{
					$album_guid = UUID::v4();
					$album_title = "title";
					$album_author = "VRI";
					$album_type=$get_res_type;
					//获取段落层级和标题
					$para_title=array();
					PDO_Connect("sqlite:"._FILE_DB_PALITEXT_);
					$query="SELECT * FROM pali_text WHERE \"book\" = ".$PDO->quote($res_book)." AND (\"paragraph\" in {$strQueryParaList} ) AND level>0 AND level<9";
					$sth = $PDO->prepare($query);
					$sth->execute();
					while($result = $sth->fetch(PDO::FETCH_ASSOC))
					{
						$paragraph = $result["paragraph"];
						$para_title["{$paragraph}"][0]=$result["level"];
						$para_title["{$paragraph}"][1]=$result["text"];
					}
						
					$db_file = _DIR_PALICANON_TEMPLET_."/p".$res_book."_tpl.db3";					
					PDO_Connect("sqlite:$db_file");
					foreach($aParaList as $iPar){
						$query="SELECT * FROM 'main' WHERE (\"paragraph\" = ".$PDO->quote($iPar)." ) ";
						
						$sth = $PDO->prepare($query);
						$sth->execute();
						{
							if(isset($para_title["{$iPar}"])){
								$level=$para_title["{$iPar}"][0];
								$title=$para_title["{$iPar}"][1];
							}
							else{
								$level=100;
								$title="";
							}
							$block_id=UUID::v4();
							$trans_block_id = UUID::v4();
							$block_data[] = array($block_id,"",$_POST["channal"],$USER_ID,$book,$iPar,"_none_",$_POST["lang"],1);
							$block_list[] = array("channal"=>$_POST["channal"],
															"type"=>6,//word by word
															"book"=>$res_book,
															"paragraph"=>$iPar,
															"block_id"=>$block_id,
															"readonly"=>false
														);
														/*
							$block_list[] = array("channal"=>$_POST["channal"],
														"type"=>2,//translation
														"book"=>$res_book,
														"paragraph"=>$iPar,
														"readonly"=>false
													);*/
						while($result = $sth->fetch(PDO::FETCH_ASSOC))
						{
							if($result["gramma"]=="?"){
								$wGrammar="";
							}
							else{
								$wGrammar=$result["gramma"];
							}

							$strXml="<word>";
							$strXml.="<pali>{$result["word"]}</pali>";
							$strXml.="<real>{$result["real"]}</real>";
							$wordid = "p{$result["book"]}-{$result["paragraph"]}-{$result["wid"]}"; 
							$strXml.="<id>{$wordid}</id>";
							$strXml.="<type s=\"0\">{$result["type"]}</type>";
							$strXml.="<gramma s=\"0\">{$wGrammar}</gramma>";
							$strXml.="<mean s=\"0\"></mean>";
							$strXml.="<org s=\"0\">".mb_strtolower($result["part"], 'UTF-8')."</org>";
							$strXml.="<om s=\"0\"></om>";
							$strXml.="<case s=\"0\">{$result["type"]}#{$wGrammar}</case>";
							$strXml.="<style>{$result["style"]}</style>";
							$strXml.="<status>0</status>";
							$strXml.="</word>";
							$wbw_data[] = array(UUID::v4(),$block_id,$book,$iPar,$result["wid"],$result["real"],$strXml,mTime(),mTime(),1,$USER_NAME);
						}
						}
					}
					
					//写入数据库
					// 开始一个事务，关闭自动提交

					PDO_Connect("sqlite:"._FILE_DB_USER_WBW_);
					$PDO->beginTransaction();
					$query="INSERT INTO wbw_block ('id','parent_id','channal','owner','book','paragraph','style','lang','status','modify_time','receive_time') VALUES (?,?,?,?,?,?,?,?,?,?,?)";
					$stmt = $PDO->prepare($query);
					foreach($block_data as $oneParam){
						$stmt->execute($oneParam);
					}
					// 提交更改 
					$PDO->commit();
					if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
						$error = PDO_ErrorInfo();
						echo "error - $error[2] <br>";
					}
					else{
						$count=count($block_data);
						echo "updata $count recorders.";
					}					
						
					// 开始一个事务，关闭自动提交

					$PDO->beginTransaction();
					$query="INSERT INTO wbw ('id','block_id','book','paragraph','wid','word','data','modify_time','receive_time','status','owner') VALUES (?,?,?,?,?,?,?,?,?,?,?)";
					$stmt = $PDO->prepare($query);
					foreach($wbw_data as $oneParam){
						$stmt->execute($oneParam);
					}
					// 提交更改 
					$PDO->commit();
					if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
						$error = PDO_ErrorInfo();
						echo "error - $error[2] <br>";
					}
					else{
						$count=count($block_data);
						echo "updata $count recorders.";
					}
					
					//服务器端文件列表
					$db_file = _FILE_DB_FILEINDEX_;
					PDO_Connect("sqlite:$db_file");
					$query="INSERT INTO fileindex ('id',
												'parent_id',
												'channal',
												'user_id',
												'book',
												'paragraph',
												'file_name',
												'title',
												'tag',
												'status',
												'create_time',
												'modify_time',
												'accese_time',
												'file_size',
												'share',
												'doc_info',
												'doc_block',
												'receive_time'
												) 
									VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
					$stmt = $PDO->prepare($query);
					$doc_id=UUID::v4();
					$file_name = $book . '_' . $create_para . '_' . time();
					$newData=array(
								   $doc_id,
								   "",
								   $_POST["channal"],
								   $uid,
								   $book,
								   $create_para,
								   $file_name,
								   $user_title,
								   $tag,
								   1,
								   mTime(),
								   mTime(),
								   mTime(),
								   $filesize,
								   0,
								   $doc_head,
								   json_encode($block_list, JSON_UNESCAPED_UNICODE),
								   mTime()
								   );
					$stmt->execute($newData);
					if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
						$error = PDO_ErrorInfo();
						echo "error - $error[2] <br>";
					}
					else{
						echo "成功新建一个文件.";
					}
		
					echo "<a href=\"editor.php?op=opendb&doc_id={$doc_id}\">{$_local->gui->open}</a>";
				}
				break;
			}
		}
		
	}
	else
	{
		if(!isset($data)){
			$dl_file_name=$dir_user_base.$USER_ID."/dl.json";
			$data=file_get_contents($dl_file_name);
		}
		$res=json_decode($data);
		
		$title=$res[0]->title;
		$title_en=pali2english($title);
		$book=$res[0]->book;
		if(substr($book,0,1)=="p"){
			$book=substr($book,1);
		}
		$paragraph=$res[0]->parNum;
		$tag="[$title]";
		$paraList=$res[0]->parlist;
		$paraList=rtrim($paraList,",");
		$strQueryParaList=str_replace(",","','",$paraList);
		$strQueryParaList="('".$strQueryParaList."')";
		$aParaList=str_getcsv($paraList);
		echo "<div style='display:none;'>";
		echo $strQueryParaList;
		echo "<textarea>";
		print_r($res);
		echo "</textarea>";
		echo "</div>";
		if(!isset($_POST["title"])){
			$thisFileName=basename(__FILE__);
			echo "<div class='fun_block'>";
			echo "<h2>New Document 新建文档</h2>";
			echo "<form action=\"{$thisFileName}\" method=\"post\">";
			echo "<input type='hidden' name='op' value='{$op}'/>";
			echo "<input type='hidden' name='data' value='{$data}'/>";
			
			echo "<fieldset>";
			echo "<legend>Title 文档标题(必填)</legend>";
			echo "<div>";
			echo "<input type='input' name='title' value='{$title}'/>";
			echo "</div>";
			echo "</fieldset>";
			echo "<fieldset>";
			echo "<legend>Channal 频道(必填)</legend>";
			echo "<div>";
			PDO_Connect("sqlite:"._FILE_DB_CHANNAL_);
			$query = "select * from channal where owner = '{$_COOKIE["userid"]}'   limit 0,100";
			$Fetch = PDO_FetchAll($query);
			$i=0;
			foreach($Fetch as $row){
				echo '<div class="file_list_row" style="padding:5px;">';
			
				echo '<div class="pd-10"  style="max-width:2em;flex:1;">';
				echo '<input name="channal" value="'.$row["id"].'" ';
				if($i==0){
					echo "checked";
				}
				echo ' type="radio" />';
				echo '</div>';
				echo '<div class="title" style="flex:3;padding-bottom:5px;">'.$row["name"].'</div>';
				echo '<div class="title" style="flex:2;padding-bottom:5px;">';
				PDO_Connect("sqlite:"._FILE_DB_USER_WBW_);
				$query = "select count(*) from wbw_block where channal = '{$row["id"]}' and book='{$book}' and paragraph in {$strQueryParaList}  limit 0,100";
				$FetchWBW = PDO_FetchOne($query);
				echo '</div>';
				echo '<div class="title" style="flex:2;padding-bottom:5px;">';
				if($FetchWBW==0){
					echo "空白";
				}
				else{
					echo $FetchWBW."个段落";
				}
				echo '</div>';

				echo '<div class="title" style="flex:2;padding-bottom:5px;">';
				PDO_Connect("sqlite:"._FILE_DB_SENTENCE_);
				$query = "select count(*) from sentence where channal = '{$row["id"]}' and book='{$book}' and paragraph in {$strQueryParaList}  limit 0,100";
				$FetchWBW = PDO_FetchOne($query);
				echo '</div>';
				echo '<div class="title" style="flex:2;padding-bottom:5px;">';
				if($FetchWBW==0){
					echo "空白";
				}
				else{
					echo $FetchWBW."个段落";
				}
				echo '</div>';

				echo '<div class="summary"  style="flex:1;padding-bottom:5px;">'.$row["status"].'</div>';
				echo '<div class="author"  style="flex:1;padding-bottom:5px;">'.$row["create_time"].'</div>';
				
				echo '</div>';
				$i++;
			}
			echo '<div class="file_list_row" style="padding:5px;">';
			
			echo '<div class="pd-10"  style="max-width:2em;flex:1;">New Channal 新建频道</div>';
			echo '<div class="title" style="flex:3;padding-bottom:5px;">';
			echo '<input type="input" placeholder="Channal Title"></div>';
			echo '<div class="author"  style="flex:1;padding-bottom:5px;"><button>New 新建</button></div>';
			
			echo '</div>';
			echo "</div>";
			echo "</fieldset>";
			echo "<fieldset>";
			echo "<legend>Language 语言</legend>";
			echo "<select name='lang'>";
			foreach ($user_setting['studio.translation.lang'] as $key => $value) {
				echo "<option value='{$value}'>".$value."</option>";
			}
			
			echo "</select>";
			echo "</fieldset>";
			echo "<input type=\"submit\" value='Create 建立'>";
			echo "<input type='hidden' name='format' value='db'>";
			echo "</form>";
			echo "</div>";
			echo "</body>";
			exit;
		}
		$user_title=$_POST["title"];
		$create_para=$paragraph;
		
		$FileName = $book."_".$paragraph."_".time().".pcs";
		$sFullFileName=_DIR_USER_BASE_."/".$USER_ID._DIR_MYDOCUMENT_."/".$FileName;
		echo "filename:".$sFullFileName;
		$myfile = fopen($sFullFileName, "w") or die("Unable to open file!");
		
		$strXml="<set>\n";
		
		$doc_head ="    <head>\n";
		$doc_head.="        <type>pcdsset</type>\n";
		$doc_head.="        <mode>package</mode>\n";
		$doc_head.="        <ver>1</ver>\n";
		$doc_head.="        <toc></toc>\n";
		$doc_head.="        <style></style>\n";
		$doc_head.="        <doc_title>$user_title</doc_title>\n";
		$doc_head.="        <tag>$tag</tag>\n";
		$doc_head.="        <book>$book</book>\n";
		$doc_head.="        <paragraph>$paragraph</paragraph>\n";
		$doc_head.="    </head>\n";
		
		$strXml.=$doc_head;
		$strXml.="    <dict></dict>\n";
		$strXml.="    <message></message>\n";
		$strXml.="    <body>\n";
		fwrite($myfile, $strXml);
		echo "count res:".count($res)."<br>";
		for($iRes=0;$iRes<count($res);$iRes++){
			$get_res_type=$res[$iRes]->type;
			echo "iRes: $iRes,type:$get_res_type<br/>";
			$res_album_id=$res[$iRes]->album_id;
			$res_book=$res[$iRes]->book;
			$get_par_begin=$res[$iRes]->parNum;
			$language=$res[$iRes]->language;
			$author=$res[$iRes]->author;
			
			$db_file = _FILE_DB_RESRES_INDEX_;
			PDO_Connect("sqlite:$db_file");
			$query = "select guid,owner from 'album' where id='{$res_album_id}'";
			$Fetch = PDO_FetchAll($query);
			if(count($Fetch)>0){
				$res_album_guid=$Fetch[0]["guid"];
				$res_album_owner=$Fetch[0]["owner"];
			}
			else{
				$res_album_guid=UUID::v4();
				$res_album_owner=0;
			}
			
			switch($get_res_type){
				case "1"://pali text
				{
					PDO_Connect("sqlite:"._FILE_DB_PALITEXT_);
					$query="SELECT * FROM pali_text WHERE \"book\" = ".$PDO->quote($res_book)." AND (\"paragraph\" in {$strQueryParaList} ) ";

					$sth = $PDO->prepare($query);
					$sth->execute();
					echo $query."<br/>";
					{

						while($result = $sth->fetch(PDO::FETCH_ASSOC))
						{							
							$text = $result["text"];
							$paragraph = $result["paragraph"];
							$strXml = "<block>";
							$strXml .= "<info>";
							$strXml .= "<type>palitext</type>";
							$strXml .= "<book>{$book}</book>";
							$strXml .= "<paragraph>{$result["paragraph"]}</paragraph>";
							$strXml .= "<album_id>{$result["album_index"]}</album_id>";
							$strXml .= "<album_guid>{$res_album_guid}</album_guid>";
							$strXml .= "<author>VRI</author>";
							$strXml .= "<language>pali</language>";
							$strXml .= "<version>4</version>";
							$strXml .= "<edition>CSCD4</edition>";
							$strXml .= "<level>{$result["level"]}</level>";
							$strXml .= "<id>".UUID::v4()."</id>";
							$strXml .= "</info>";
							$strXml .= "<data><text>{$result["text"]}</text></data>";
							$strXml .= "</block>";
							fwrite($myfile, $strXml);
							
							if($result["level"]>0 && $result["level"]<9){
								$strXml = "<block>";
								$strXml .= "<info>";
								$strXml .= "<type>heading</type>";
								$strXml .= "<book>{$book}</book>";
								$strXml .= "<paragraph>{$result["paragraph"]}</paragraph>";
								$strXml .= "<album_id>{$result["album_index"]}</album_id>";
								$strXml .= "<album_guid>{$res_album_guid}</album_guid>";
								$strXml .= "<author>VRI</author>";
								$strXml .= "<language>pali</language>";
								$strXml .= "<version>4</version>";
								$strXml .= "<edition>CSCD4</edition>";
								$strXml .= "<level>{$result["level"]}</level>";
								$strXml .= "<id>".UUID::v4()."</id>";
								$strXml .= "</info>";
								$strXml .= "<data><text>{$result["text"]}</text></data>";
								$strXml .= "</block>";
								fwrite($myfile, $strXml);
							}
							else{
									
							}
						}
					}
					break;
				}
				case "2"://wbw逐词解析
				{
					//$res_album_id;
					$album_title = "title";
					$album_author = $author;
					$album_type=$get_res_type;	
					$db_file = _DIR_PALICANON_WBW_."/p{$res_book}_wbw.db3";
					$table_info="p{$res_book}_wbw_info";
					$table_data="p{$res_book}_wbw_data";
					PDO_Connect("sqlite:$db_file");
					foreach($aParaList as $iPar){
						$query="SELECT * FROM '{$table_info}' WHERE paragraph = ".$PDO->quote($iPar)." and album_id=".$PDO->quote($res_album_id);
						//$FetchInfo = PDO_FetchAll($query);
						echo $query."<br>";
						$sth = $PDO->prepare($query);
						$sth->execute();
						echo "para:{$iPar} row:".$sth->rowCount();
						
						if($result = $sth->fetch(PDO::FETCH_ASSOC))
						{
							$lang=$sLang["{$result["language"]}"];
							$info_id=$result["id"];
							$strXml = "<block>";
							$strXml .= "<info>";
							$strXml .= "<type>wbw</type>";
							$strXml .= "<book>{$res_book}</book>";
							$strXml .= "<paragraph>{$iPar}</paragraph>";
							$strXml .= "<level>{$result["level"]}</level>";
							$strXml .= "<title>{$result["title"]}</title>";
							$strXml .= "<album_id>{$res_album_id}</album_id>";
							$strXml .= "<album_guid>{$res_album_guid}</album_guid>";
							$strXml .= "<author>{$result["author"]}</author>";
							$strXml .= "<language>{$lang}</language>";
							$strXml .= "<version>{$result["version"]}</version>";
							$strXml .= "<edition>{$result["edition"]}</edition>";
							$strXml .= "<id>".UUID::v4()."</id>";
							$strXml .= "</info>\n";
							$strXml .= "<data>";
							fwrite($myfile, $strXml);
							$query="SELECT * FROM \"{$table_data}\" WHERE info_id=".$PDO->quote($info_id);
							$sth = $PDO->prepare($query);
							$sth->execute();
							while($result = $sth->fetch(PDO::FETCH_ASSOC))
							{
								$wid="p{$res_book}-{$iPar}-{$result["sn"]}";
								$strXml="<word>";
								$strXml.="<pali>{$result["word"]}</pali>";
								$strXml.="<real>{$result["real"]}</real>";
								$strXml.="<id>{$wid}</id>";
								$strXml.="<type>{$result["type"]}</type>";
								$strXml.="<gramma>{$result["gramma"]}</gramma>";
								$strXml.="<mean>{$result["mean"]}</mean>";
								$strXml.="<note>{$result["note"]}</note>";
								$strXml.="<org>{$result["part"]}</org>";
								$strXml.="<om>{$result["partmean"]}</om>";
								$strXml.="<case>{$result["type"]}#{$result["gramma"]}</case>";
								$strXml.="<style>{$result["style"]}</style>";
								$strXml.="<enter>{$result["enter"]}</enter>";
								$strXml.="<status>0</status>";
								$strXml.="</word>\n";
								fwrite($myfile, $strXml);
							}
							
							$strXml="</data>\n</block>";
							fwrite($myfile, $strXml);
						}
							
					}
					break;
				}
				case "3"://translate
				{
					//打开翻译数据文件
					$db_file = _DIR_PALICANON_TRAN_."/p{$book}_translate.db3";
					PDO_Connect("sqlite:$db_file");
					$table="p{$book}_translate_info";
					//部分段落
					$query="SELECT * FROM {$table} WHERE paragraph in {$strQueryParaList}  and album_id=$res_album_id";
					echo $query."<br/>";
					//查询翻译经文内容
					$FetchText = PDO_FetchAll($query);
					$iFetchText = count($FetchText);
					echo "iFetchText:{$iFetchText}<br/>";
					if($iFetchText>0){
						for($i=0;$i<$iFetchText;$i++){
							$currParNo = $FetchText[$i]["paragraph"];
							$language = $FetchText[$i]["language"];
							$language = $sLang["{$language}"];
							if($res_album_owner == $UID){
								$power = "write";
							}
							else{
								$power = "read";
							}
							//输出数据头
					
							$strXml="<block>";
							$strXml.="<info>";
							$strXml.="<type>translate</type>";
							$strXml.="<book>{$res_book}</book>";
							$strXml.="<paragraph>{$currParNo}</paragraph>";
							$strXml.="<album_id>{$res_album_id}</album_id>";
							$strXml.="<album_guid>{$res_album_guid}</album_guid>";
							$strXml.="<author>{$FetchText[$i]["author"]}</author>";
							$strXml.="<editor>{$FetchText[$i]["editor"]}</editor>";
							$strXml.="<language>{$language}</language>";
							$strXml.="<version>{$FetchText[$i]["version"]}</version>";
							$strXml.="<edition>{$FetchText[$i]["edition"]}</edition>";
							$strXml.="<level>{$FetchText[$i]["level"]}</level>";
							$strXml.="<readonly>0</readonly>";
							$strXml.="<power>{$power}</power>";
							$strXml.="<id>".UUID::v4()."</id>";
							$strXml.="</info>";
							$strXml.="<data>";
					fwrite($myfile, $strXml);
					//查另一个表，获取段落文本。一句一条记录。有些是一段一条记录
					$table_data = "p{$book}_translate_data";
					$query = "SELECT * FROM '{$table_data}' WHERE info_id={$FetchText[$i]["id"]}";
					$aParaText = PDO_FetchAll($query);
					
					//输出数据内容					
					$par_text="";
					foreach($aParaText as $sent){
									$par_text .= "<sen><begin>{$sent["begin"]}</begin><end>{$sent["end"]}</end><text>{$sent["text"]}</text></sen>";
					}
					fwrite($myfile, $par_text);
					//段落块结束
					$strXml = "</data></block>";
					fwrite($myfile, $strXml);
					//获取段落文本结束。
				}
			}
					break;
			}
				case "4"://note
					break;
				case "5":
					break;
				case "6"://逐词译模板
				{
					$album_guid = UUID::v4();
					$album_title = "title";
					$album_author = "VRI";
					$album_type=$get_res_type;
					//获取段落层级和标题
					$para_title=array();
					PDO_Connect("sqlite:"._FILE_DB_PALITEXT_);
					$query="SELECT * FROM pali_text WHERE \"book\" = ".$PDO->quote($res_book)." AND (\"paragraph\" in {$strQueryParaList} ) AND level>0 AND level<9";
					$sth = $PDO->prepare($query);
					$sth->execute();
					while($result = $sth->fetch(PDO::FETCH_ASSOC))
					{
						$paragraph = $result["paragraph"];
						$para_title["{$paragraph}"][0]=$result["level"];
						$para_title["{$paragraph}"][1]=$result["text"];
					}
						
					$db_file = _DIR_PALICANON_TEMPLET_."/p".$res_book."_tpl.db3";					
					PDO_Connect("sqlite:$db_file");
					foreach($aParaList as $iPar){
						$query="SELECT * FROM 'main' WHERE (\"paragraph\" = ".$PDO->quote($iPar)." ) ";
						
						$sth = $PDO->prepare($query);
						$sth->execute();
						{
							if(isset($para_title["{$iPar}"])){
								$level=$para_title["{$iPar}"][0];
								$title=$para_title["{$iPar}"][1];
							}
							else{
								$level=100;
								$title="";
							}
							$strXml="<block>";
							$strXml.="<info>";
							$strXml.="<type>wbw</type>";
							$strXml.="<book>{$book}</book>";
							$strXml.="<paragraph>{$iPar}</paragraph>";
							$strXml.="<level>{$level}</level>";
							$strXml.="<title>{$title}</title>";
							$strXml.="<album_id>-1</album_id>";
							$strXml.="<album_guid>{$album_guid}</album_guid>";		
							$strXml.="<author>{$USER_NAME}</author>";
							$strXml.="<editor>{$USER_NAME}</editor>";
							$strXml.="<language>en</language>";
							$strXml.="<version>1</version>";
							$strXml.="<edition></edition>";
							$strXml.="<splited>0</splited>";
							$strXml.="<id>".UUID::v4()."</id>";
							$strXml.="</info>\n";
							$strXml.="<data>";
						fwrite($myfile, $strXml);
						while($result = $sth->fetch(PDO::FETCH_ASSOC))
						{
							if($result["gramma"]=="?"){
								$wGrammar="";
							}
							else{
								$wGrammar=$result["gramma"];
							}
							$strXml="<word>";
							$strXml.="<pali>{$result["word"]}</pali>";
							$strXml.="<real>{$result["real"]}</real>";
							$strXml.="<id>{$result["wid"]}</id>";
							$strXml.="<type status=\"0\">{$result["type"]}</type>";
							$strXml.="<gramma status=\"0\">{$wGrammar}</gramma>";
							$strXml.="<mean status=\"0\">?</mean>";
							$strXml.="<org status=\"0\">".mb_strtolower($result["part"], 'UTF-8')."</org>";
							$strXml.="<om status=\"0\">?</om>";
							$strXml.="<case status=\"0\">{$result["type"]}#{$wGrammar}</case>";
							$strXml.="<style>{$result["style"]}</style>";
							$strXml.="<status>0</status>";
							$strXml.="</word>";
							fwrite($myfile, $strXml);
						}
							
							$strXml="</data>\n</block>";
							fwrite($myfile, $strXml);
						}
							
					}
					break;
				}

			}
			/*查询结束*/
		}
		/*
		自动新建译文
		*/
		if(isset($_POST["new_tran"])){
			$new_tran=$_POST["new_tran"];
			if($new_tran=="on"){
				$album_guid = UUID::v4();
				foreach($aParaList as $iPar){
					$strXml="<block>";
					$strXml.="<info>";
					$strXml.="<album_id>-1</album_id>";
					$strXml.="<album_guid>{$album_guid}</album_guid>";
					$strXml.="<type>translate</type>";
					$strXml.="<paragraph>{$iPar}</paragraph>";
					$strXml.="<book>{$book}</book>";
					$strXml.="<author>{$author}</author>";
					$strXml.="<language>en</language>";
					$strXml.="<version>0</version>";
					$strXml.="<edition>0</edition>";
					$strXml.="<id>".UUID()::v4."</id>";
					$strXml.="</info>";
					$strXml.="<data>";
					$strXml.="<sen><begin></begin><end></end><text>new translate</text></sen>";
					$strXml.="</data>";
					$strXml.="</block>\n";
					fwrite($myfile, $strXml);
				}
			}
		}
		$strXml="    </body>\n";
		$strXml.="</set>\n";
		fwrite($myfile, $strXml);
		fclose($myfile);
		echo "<p>save ok</p>";
		$filesize=filesize($sFullFileName);
		//服务器端文件列表
		$db_file = _FILE_DB_FILEINDEX_;
		PDO_Connect("sqlite:$db_file");

					$query="INSERT INTO fileindex ('id',
												'parent_id',
												'user_id',
												'book',
												'paragraph',
												'file_name',
												'title',
												'tag',
												'status',
												'create_time',
												'modify_time',
												'accese_time',
												'file_size',
												'share',
												'doc_info',
												'doc_block',
												'receive_time'
												) 
									VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
					$stmt = $PDO->prepare($query);
					$doc_id=UUID::v4();
					$newData=array($doc_id,
								   "",
								   $uid,
								   $book,
								   $create_para,
								   $FileName,
								   $user_title,
								   $tag,
								   1,
								   mTime(),
								   mTime(),
								   mTime(),
								   $filesize,
								   0,
								   "",
								   "",
								   mTime()
								   );
		$stmt->execute($newData);
		if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
			$error = PDO_ErrorInfo();
			echo "error - $error[2] <br>";
		}
		else{
			echo "updata 1 recorders.";
		}
		echo "<a href=\"editor.php?op=open&fileid={$doc_id}\">正在跳转</a>";
		echo "<script>";
		echo "window.location.assign(\"editor.php?op=open&fileid={$doc_id}\");";
		echo "</script>";
		break;
	}
	case "open":
	{
		/*打开工程文件
		三种情况
		1.自己的文档
		2.别人的共享文档，自己以前没有打开过。复制到自己的空间，再打开。
		3.别人的共享文档，自己以前打开过。直接打开
		*/
		if($_COOKIE["uid"]){
			$uid=$_COOKIE["uid"];
		}
		else{
			echo "<h3><a href='../ucenter/index.php?op=login'>{$_local->gui->login}</a>后才可以打开文档</h3>";
			exit;
		}
		$db_file = _FILE_DB_FILEINDEX_;
		PDO_Connect("sqlite:$db_file");
		if(isset($_GET["doc_id"])){
			$doc_id=$_GET["doc_id"];
			$query = "select * from fileindex where id='$doc_id' ";
			$Fetch = PDO_FetchAll($query);
			$iFetch=count($Fetch);
			if($iFetch>0){
				//文档信息
				$owner=$Fetch[0]["user_id"];
				$filename=$Fetch[0]["file_name"];
				$title=$Fetch[0]["title"];
				$tag=$Fetch[0]["tag"];
				$mbook=$Fetch[0]["book"];
				$paragraph=$Fetch[0]["paragraph"];
				$doc_head=$Fetch[0]["doc_info"];
				
				if($owner==$uid){
					//自己的文档
					echo "<h3>{$_local->gui->my_document}</h3>";
					$my_doc_id=$doc_id;
					echo "<a href=\"editor.php?op=opendb&fileid={$doc_id}\">{$_local->gui->open_doc}</a>";
					echo "<script>";
					echo "window.location.assign(\"editor.php?op=opendb&fileid={$doc_id}\");";
					echo "</script>";
				}
				else{
					//别人的文档
					//查询自己是否以前打开过
					$query = "select * from fileindex where parent_id='$doc_id' and user_id='$uid' ";
					$FetchSelf = PDO_FetchAll($query);
					$iFetchSelf=count($FetchSelf);
					if($iFetchSelf>0){
						//以前打开过
						echo "已经复制的文档 Already Copy";
						$my_doc_id=$FetchSelf[0]["id"];
						echo "<a href='../studio/editor.php?op=opendb&fileid={$doc_id}'>Open in Studio</a>";
						echo "<script>";
						echo "window.location.assign(\"editor.php?op=opendb&fileid={$doc_id}\");";
						echo "</script>";						
					}
					else{
						//以前没打开过
						//询问是否打开
						if(isset($_GET["openin"])){
							$open_in=$_GET["openin"];
						}
						else{
						?>
						<p><?php echo $_local->gui->co_doc?>，<?php echo $_local->gui->open?>？</p>
						<div>
						文档信息：
						<ul>
						<?php
						$book_name=$book["p".$mbook];
						echo "<li>Owner：".ucenter_get($owner)."</li>";
						echo "<li>Title：{$title}</li>";
						echo "<li>Book：{$book_name}</li>";
						?>
						</ul>
						</div>
						<p><?php echo $_local->gui->open_with?>：</p>
						<ul>
						<li style="display:none;"><a href="../pcdl/reader.php?file=<?php echo $doc_id;?>"><?php echo $_local->gui->reader;?>（<?php echo $_local->gui->read_only;?>）</a></li>
						<?php
						if(empty($doc_head)){
							echo '<li><a href="../studio/project.php?op=open&doc_id='.$doc_id.'&openin=editor">复制到我的空间用编辑器打开</a></li>';
						}
						else{
							echo '<li>'.$_local->gui->pcd_studio.'<a href="../doc/fork.php?doc_id='.$doc_id.'">'.$_local->gui->folk.$_local->gui->and.$_local->gui->edit.'</a></li>';
						}
						?>
						
						</ul>
						<?php
						exit;
						}
						if($open_in=="editor"){
							//获取文件路径
							echo "共享的文档，复制并打开...";
							$db_file = _FILE_DB_USERINFO_;
							PDO_Connect("sqlite:$db_file");
							$query = "select userid from user where id='$owner'";
							$FetchUid = PDO_FetchOne($query);
							if($FetchUid){
								$source=_DIR_USER_BASE_."/".$FetchUid._DIR_MYDOCUMENT_."/".$filename;
								$dest=_DIR_USER_BASE_."/".$_COOKIE["userid"] ._DIR_MYDOCUMENT_."/".$filename;
							}
							echo "<div>源文件{$source}</div>";
							echo "<div>目标文件{$dest}</div>";
							if(copy($source,$dest)){
								echo "复制文件成功";
								$my_file_name=$filename;
								//插入记录到文件索引
								$filesize=filesize($dest);
								//服务器端文件列表
								$db_file = _FILE_DB_FILEINDEX_;
								PDO_Connect("sqlite:$db_file");


								//$query="INSERT INTO fileindex ('id','userid','parent_id','doc_id','book','paragraph','file_name','title','tag','create_time','modify_time','accese_time','file_size') 
								//				VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?)";
								//$stmt = $PDO->prepare($query);
								//$newData=array($uid,$doc_id,UUID::v4(),$mbook,$paragraph,$filename,$title,$tag,time(),time(),time(),$filesize);
					
					$query="INSERT INTO fileindex ('id',
												'parent_id',
												'user_id',
												'book',
												'paragraph',
												'file_name',
												'title',
												'tag',
												'status',
												'create_time',
												'modify_time',
												'accese_time',
												'file_size',
												'share',
												'doc_info',
												'doc_block',
												'receive_time'
												) 
									VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
					$stmt = $PDO->prepare($query);
					$newdoc_id=UUID::v4();
					$newData=array(
								   $newdoc_id,
								   $doc_id,
								   $uid,
								   $mbook,
								   $paragraph,
								   $filename,
								   $title,
								   $tag,
								   1,
								   mTime(),
								   mTime(),
								   mTime(),
								   $filesize,
								   0,
								   "",
								   "",
								   mTime()
								   );

								$stmt->execute($newData);
								if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
									$error = PDO_ErrorInfo();
									echo "error - $error[2] <br>";
									$my_doc_id="";
								}
								else{
									$my_doc_id = newdoc_id;
									echo "updata 1 recorders.";
								}

							}
							else{
								echo "复制文件失败";
								$my_doc_id="";
							}
						}
						else{
							echo "错误-无法识别的操作：open in:{$open_in}";
							$my_doc_id="";
						}
					}
					
				}
				/*
				if($my_doc_id!=""){
					echo "<script>";
					echo "window.location.assign(\"editor.php?op=open&fileid={$my_doc_id}\");";
					echo "</script>";
					
				}
				*/
			}
			else{
				echo "未知的文档。可能该文件已经被删除。";
			}
		}
	}
	break;
	case "openfile":
	break;
	case "save":
	break;
}
?>
</body>