type;
echo "iRes: $iRes,type:$get_res_type
";
$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();
$block_data[] = array($block_id,"",$USER_ID,$book,$iPar,"_none_","zh-cn",1);
$block_list[] = array("type"=>6,"block_id"=>$block_id);
while($result = $sth->fetch(PDO::FETCH_ASSOC))
{
if($result["gramma"]=="?"){
$wGrammar="";
}
else{
$wGrammar=$result["gramma"];
}
$strXml="";
$strXml.="{$result["word"]}";
$strXml.="{$result["real"]}";
$wordid = "p{$result["book"]}-{$result["paragraph"]}-{$result["wid"]}";
$strXml.="{$wordid}";
$strXml.="{$result["type"]}";
$strXml.="{$wGrammar}";
$strXml.="";
$strXml.="".mb_strtolower($result["part"], 'UTF-8')."";
$strXml.="";
$strXml.="{$result["type"]}#{$wGrammar}";
$strXml.="";
$strXml.="0";
$strXml.="";
$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','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]
";
}
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]
";
}
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',
'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,
"",
$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]
";
}
else{
echo "成功新建一个文件.";
}
echo "{$_local->gui->open}";
}
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 $strQueryParaList;
echo "";
if(!isset($_POST["title"])){
$thisFileName=basename(__FILE__);
echo "";
echo "
新建工程
";
echo "";
echo "";
echo "