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


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
							<?php
require_once "install_head.php";
?>
<html>
<head>
</head>
<body>
<style>
#step5{
	background-color: #f1e7a4;
}
</style>
<?php
require_once 'nav_bar.php';
?>
<h3>Step 4 Build Pali Canon Database 建立三藏语料数据库</h3>

<div class="card" style="background-color:#f1e7a4;">
你可以下载已经制作好的语料数据库放在项目文件夹中
<a href="https://www.dropbox.com/s/naf7sk9i9sf0dfi/appdata.7z?dl=0">drobox 7z format 754MB</a>
解压缩后放在项目tmp目录中
<pre>
[tmp]
 └appdata
   └dict
     └3rd
	 └system
   └palicanon
 └user 
 </pre>
</div>
<?php
$dbfile[]=array(_FILE_DB_BOLD_,"bold.sql");
$dbfile[]=array(_FILE_DB_INDEX_,"index.sql");
$dbfile[]=array(_FILE_DB_BOOK_WORD_,"bookword.sql");
$dbfile[]=array(_FILE_DB_PALI_INDEX_,"paliindex.sql");
$dbfile[]=array(_FILE_DB_WORD_INDEX_,"wordindex.sql");
$dbfile[]=array(_FILE_DB_PALI_SENTENCE_,"pali_sent.sql");
$dbfile[]=array(_FILE_DB_PALITEXT_,"pali_text.sql");
$dbfile[]=array(_FILE_DB_RESRES_INDEX_,"res.sql");
$dir="./palicanon_db/";

if(isset($_GET["index"])){
echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;background-color:yellow;">';	
	$index = $_GET["index"];
	$dns = "sqlite:".$dbfile[$index][0];
	$dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
	$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
	//建立数据库
	$_sql = file_get_contents($dir.$dbfile[$index][1]);
	$_arr = explode(';', $_sql);
	//执行sql语句
	foreach ($_arr as $_value) {
		$dbh->query($_value.';');
	}
	echo $dns."建立数据库成功";
echo "</div>"; 
}
?>

<div class="card">
<h4>拆分html文件</h4>
<a href="xmlmaker.php">拆分</a><br>
<a href="../../log/palicanoon.log" target="_blank">view log file</a>
</div>

<div class="card">
<h4>逐词解析模板数据库</h4>
<?php
if(file_exists(_DIR_PALICANON_TEMPLET_)){
	$iCount=0;
	for($i=1;$i<=217;$i++){
		if(file_exists(_DIR_PALICANON_TEMPLET_."/p{$i}_tpl.db3")){
			$iCount++;
		}
	}
	if($iCount==217){
		echo "文件已经存在。<br>";
		echo '<a href="db_insert_templet.php">重新生成数据库</a>';
	}
	else{
		echo "缺少".(217-$iCount)."个文件<br>";
		echo '<a href="db_insert_templet.php">生成数据库</a>';
	}
}
else{
	echo "模板数据库目录不存在<br>";
}
?>
</div>

<div class="card">
	<h4>单词索引表</h4>
	<?php
	for($i=2; $i<=4; $i++){
		$db = $dbfile[$i];
		echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;display:flex;">';
		echo '<div style="flex:5;">'.$db[0].'</div>';
		echo '<div style="flex:3;">';
		if(!file_exists($db[0])){
			echo "<span style='color:red;'>数据库不存在</span>";
			echo "</div>"; 
			echo '<div style="flex:2;"><a href="step4.php?index='.$i.'">建立</a></div>';    
		}
		else{
			echo "<span style='color:green;'>已存在</span>";
			echo "</div>"; 
			echo '<div style="flex:2;"><a href="step5.php?index='.$i.'">清空</a><span style="color:red;">注意！此操作将删除原数据库中所有数据！</span></div>';
		}
		echo "</div>";  
	}
	?>
	?>
	<div class="contence">
	<a href="db_insert_index.php" target="_blank">生成-一本书一次写入</a><br>
	<a href="db_insert_index_once.php" target="_blank">一次生成所有的书</a><br>

	<a href="db_insert_index_csv.php" target="_blank">生成中间csv文件（项目文档已经有了。无需生成）</a><br>
	<a href="db_insert_bookword_from_csv.php" target="_blank">从csv文件导入书单词索引表（bookword）</a><br>	
	<a href="db_insert_word_from_csv.php" target="_blank">从csv文件导入单词表(paliindex)</a><br>
	<a href="db_insert_wordindex_from_csv.php" target="_blank">从csv文件导入单词索引表(wordindex)</a><br>

	</div>
</div>

<div class="card">
	<h4>黑体字数据库</h4>
	<?php
	$db = $dbfile[0];
	echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;display:flex;">';
	echo '<div style="flex:5;">'.$db[0].'</div>';
	echo '<div style="flex:3;">';
	if(!file_exists($db[0])){
        echo "<span style='color:red;'>数据库不存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=0">建立</a></div>';    
	}
	else{
        echo "<span style='color:green;'>已存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=0">清空</a><span style="color:red;">注意！此操作将删除原数据库中所有数据！</span></div>';
    }
	echo "</div>";  
	?>
	<div class="contence">
	<a href="db_insert_bold.php" target="_blank">生成</a>
	</div>
</div>

<div class="card">
<h4>Pali句子库</h4>
<?php
	$db = $dbfile[5];
	echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;display:flex;">';
	echo '<div style="flex:5;">'.$db[0].'</div>';
	echo '<div style="flex:3;">';
	if(!file_exists($db[0])){
        echo "<span style='color:red;'>数据库不存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=5">建立</a></div>';    
	}
	else{
        echo "<span style='color:green;'>已存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=5">清空</a><span style="color:red;">注意！此操作将删除原数据库中所有数据！</span></div>';
    }
	echo "</div>";  

if(file_exists(_FILE_DB_PALI_SENTENCE_)){
	echo "Pali句子数据库已经存在<br>";
	echo '<a href="db_insert_sentence.php">重新生成</a>';
}
else{
	echo "Pali句子数据库不存在<br>";
	echo '<a href="db_insert_sentence.php">生成</a>';
}
?>
</div>

<div class="card">
<h4>Pali原文库</h4>
<div>
<?php
	$db = $dbfile[6];
	echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;display:flex;">';
	echo '<div style="flex:5;">'.$db[0].'</div>';
	echo '<div style="flex:3;">';
	if(!file_exists($db[0])){
        echo "<span style='color:red;'>数据库不存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=6">建立</a></div>';    
	}
	else{
        echo "<span style='color:green;'>已存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=6">清空</a><span style="color:red;">注意！此操作将删除原数据库中所有数据！</span></div>';
    }
	echo "</div>";  

if(file_exists(_FILE_DB_PALITEXT_)){
	echo "Pali原文数据库已经存在<br>";
	echo '<a href="db_insert_palitext.php" target="_blank">重新生成</a><br>';
	echo '<a href="db_update_palitext.php" target="_blank">更新</a><br>';
}
else{
	echo '<a href="db_insert_palitext.php">生成</a><br>';
}
echo "<a href = '"._DIR_LOG_."/db_update_palitext.log"."' target='_blank'>view Log</a>"
?>
</div>
</div>


<div class="card">
<h4>标题索引</h4>
<div>
<?php
	$db = $dbfile[7];
	echo '<div style="padding:10px;margin:5px;border-bottom: 1px solid gray;display:flex;">';
	echo '<div style="flex:5;">'.$db[0].'</div>';
	echo '<div style="flex:3;">';
	if(!file_exists($db[0])){
        echo "<span style='color:red;'>数据库不存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=7">建立</a></div>'; 
	}
	else{
        echo "<span style='color:green;'>已存在</span>";
    	echo "</div>"; 
        echo '<div style="flex:2;"><a href="step5.php?index=7">清空</a><span style="color:red;">注意！此操作将删除原数据库中所有数据！</span></div>';
    }
	echo "</div>";  

	if(file_exists(_FILE_DB_PALITEXT_)){
		echo "标题索引数据库已经存在<br>";
		echo '<a href="db_update_toc.php" target="_blank">更新</a><br>';
	}
	else{
		echo "标题索引数据库不存在<br>";
		echo '<div style="flex:2;"><a href="step5.php?index='.$i.'">建立</a></div>'; 
	}
echo "<a href = '"._DIR_LOG_."/db_update_title.log"."' target='_blank'>view Log</a>"
?>
</div>
</div>

<hr>
<h2>完成</h2>
</body>
</html>