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


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460
							<?php
/*拷贝其他人的文件
*
*
*/
require_once '../studio/index_head.php';
?>
<body id="file_list_body" >
<?php
    require_once "../public/_pdo.php";
    require_once "../public/function.php";
	require_once "../path.php";

	require_once '../studio/index_tool_bar.php';

	echo '<div class="index_inner" style="    margin-left: 18em;margin-top: 5em;">';

    if($_COOKIE["uid"]){
        $uid=$_COOKIE["uid"];
    }
    else{
        echo "尚未登录";
        echo "<h3><a href='../ucenter/index.php?op=login'>登录</a>后才可以打开文档 </h3>";
        exit;
	}
	if(isset($_GET["doc_id"])==false){
		echo "没有 文档编号";
		exit;
	}
	PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);
	$doc_id=$_GET["doc_id"];
	$query = "select * from fileindex where id= ? ";
	$Fetch = PDO_FetchAll($query,array($doc_id));
	$iFetch=count($Fetch);
	if($iFetch>0){
		//文档信息
		$mbook=$Fetch[0]["book"];
		$paragraph=$Fetch[0]["paragraph"];
	}

	if(isset($_GET["channel"])==false){
		echo '<div class="file_list_block">';
		echo "<h2>选择一个空白的版风存储新的文档</h2>";
		echo "<form action='fork.php' method='get'>";
		echo "<input type='hidden' name='doc_id' value='{$_GET["doc_id"]}' />";
		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;display:flex;">';
		
			echo '<div class="pd-10"  style="max-width:2em;flex:1;">';
			echo '<input name="channel" 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:3;padding-bottom:5px;">'.$row["lang"].'</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='{$mbook}' and paragraph in ({$paragraph})  limit 0,100";
			$FetchWBW = PDO_FetchOne($query);
			echo '</div>';
			echo '<div class="title" style="flex:2;padding-bottom:5px;">';
			if($FetchWBW==0){
				echo $_local->gui->blank;
			}
			else{
				echo $FetchWBW.$_local->gui->para;
				echo "<a href='../studio/editor.php?op=openchannal&book=$book&para={$paraList}&channal={$row["id"]}'>open</a>";
			}
			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='{$mbook}' and paragraph in ({$paragraph})  limit 0,100";
			$FetchWBW = PDO_FetchOne($query);
			echo '</div>';
			echo '<div class="title" style="flex:2;padding-bottom:5px;">';
			if($FetchWBW==0){
				echo $_local->gui->blank;
			}
			else{
				echo $FetchWBW.$_local->gui->para;
			}
			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 "<input type='submit' />";
		echo "</form>";
		echo "</div>";
		exit;
	}
    
	//if(isset($_GET["doc_id"]))
	{
		PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);
		$doc_id=$_GET["doc_id"];
		$query = "select * from fileindex where id= ? ";
		$Fetch = PDO_FetchAll($query,array($doc_id));
		$iFetch=count($Fetch);
        if($iFetch>0){
            //文档信息
            $orgFileInfo = $Fetch[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"];
            
            if($owner==$uid){
                //自己的文档
                echo "这是自己的文档，不能复刻。";
            }
            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 "文档已经复刻";
                    echo "正在<a href='../studio/editor.php?op=opendb&doc_id={$doc_id}'>打开</a>文档";
                    echo "<script>";
                    echo "window.location.assign(\"../studio/editor.php?op=opendb&doc_id={$doc_id}\");";
                    echo "</script>";
                }
                else{
                    //以前没打开过
                    echo "<h3>共享的文档，正在fork...</h3>";
                    echo "<div style='display:none;'>";
                    //获取文件路径
                    
                    PDO_Connect("sqlite:"._FILE_DB_USERINFO_);
                    $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.$userid.$dir_mydocument.$filename;
                        //复制数据
                        //打开逐词解析数据库
                        $dns = "sqlite:"._FILE_DB_USER_WBW_;
                        $dbhWBW = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
                        $dbhWBW->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);  

                        //打开译文数据库
                        $dns = "sqlite:"._FILE_DB_SENTENCE_;
                        $dbhSent = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
                        $dbhSent->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); 

                        //逐词解析新数据数组
                        $arrNewBlock = array();
                        $arrNewBlockData = array();
                        $arrBlockTransform = array();
                        
                        //译文新数据数组
                        $arrSentNewBlock = array();
                        $arrSentNewBlockData = array();
                        $arrSentBlockTransform = array(); 

                        $newDocBlockList=array();

                        $blocks = json_decode($Fetch[0]["doc_block"]);
                        for ($i=0;$i<count($blocks);$i++) {
                            switch($blocks[$i]->type){
                                case 1:
                                break;
                                case 2:
                                    //译文
                                    $blockid = $blocks[$i]->block_id;
                                    $query = "select * from sent_block where id= ? ";
                                    $stmt = $dbhSent->prepare($query);
                                    $stmt->execute(array($blockid));
                                    $fBlock = $stmt->fetchAll(PDO::FETCH_ASSOC);
									$newBlockId = UUID::V4();
									//不复刻译文
                                    //$newDocBlockList[]=array('type' => 2,'block_id' => $newBlockId);
                                    $arrSentBlockTransform[$fBlock[0]["id"]] = $newBlockId;
                                    if(count($fBlock)>0){
										array_push( $arrSentNewBlock,
													array($newBlockId,
                                                          $fBlock[0]["id"],
                                                          $fBlock[0]["book"],
                                                          $fBlock[0]["paragraph"],
                                                          $_COOKIE["userid"],
                                                          $fBlock[0]["lang"],
                                                          $fBlock[0]["author"],
                                                          $fBlock[0]["editor"],
                                                          $fBlock[0]["tag"],
                                                          $fBlock[0]["status"],
                                                          mTime(),
                                                          mTime()
                                                        ));
                                    }

                                    $query = "select * from sentence where block_id= ? ";
                                    $stmtSent = $dbhSent->prepare($query);
                                    $stmtSent->execute(array($fBlock[0]["id"]));
                                    $fBlockData = $stmtSent->fetchAll(PDO::FETCH_ASSOC);
                                    foreach($fBlockData as $value){
										array_push( $arrSentNewBlockData,
													array(UUID::V4(),
														$arrSentBlockTransform[$value["block_id"]],
														$value["book"],
														$value["paragraph"],
														$value["begin"],
														$value["end"],
														$value["channal"],
														$value["tag"],
														$value["author"],
														$_COOKIE["userid"],
														$value["text"],
														$value["language"],
														$value["ver"],
														$value["status"],
														mTime(),
														mTime()
													));

                                    }
                                    
                                break;
                                case 3:
                                break;
                                case 4:
                                break;
                                case 5:
                                break;
								case 6: 
									#逐词解析
                                    $blockid = $blocks[$i]->block_id;
                                    $query = "select * from wbw_block where id= ? ";
                                    $stmt = $dbhWBW->prepare($query);
                                    $stmt->execute(array($blockid));
                                    $fBlock = $stmt->fetchAll(PDO::FETCH_ASSOC);
                                    $newBlockId = UUID::V4();
                                    $newDocBlockList[]=array('type' => 6,'block_id' => $newBlockId);
                                    $arrBlockTransform[$fBlock[0]["id"]] = $newBlockId;
                                    if(count($fBlock)>0){
										array_push( $arrNewBlock,
													array($newBlockId,
														$fBlock[0]["id"],
														$_GET["channel"],
														$_COOKIE["userid"],
														$fBlock[0]["book"],
														$fBlock[0]["paragraph"],
														$fBlock[0]["style"],
														$fBlock[0]["lang"],
														$fBlock[0]["status"],
														mTime(),
														mTime()
													));
                                    }

                                    $query = "select * from wbw where block_id= ? ";
                                    $stmtWBW = $dbhWBW->prepare($query);
                                    $stmtWBW->execute(array($fBlock[0]["id"]));
                                    $fBlockData = $stmtWBW->fetchAll(PDO::FETCH_ASSOC);
                                    foreach($fBlockData as $value){
										array_push( $arrNewBlockData,
													array(UUID::V4(),
														$arrBlockTransform[$value["block_id"]],
														$value["book"],
														$value["paragraph"],
														$value["wid"],
														$value["word"],
														$value["data"],
														mTime(),
														mTime(),
														$value["status"],
														$_COOKIE["userid"]
													));

                                    }
                                break;
                                case 2:

                                break;
                            }

                        }
                        //逐词解析block数据块
                        
                        if(count($arrNewBlock)>0){
                            $dbhWBW->beginTransaction();
                            $query="INSERT INTO wbw_block ('id','parent_id','channal','owner','book','paragraph','style','lang','status','modify_time','receive_time') VALUES (?,?,?,?,?,?,?,?,?,?,?)";
                            $stmtNewBlock = $dbhWBW->prepare($query);
                            foreach($arrNewBlock as $oneParam){
                                $stmtNewBlock->execute($oneParam);
                            }
                            // 提交更改 
                            $dbhWBW->commit();
                            if (!$stmtNewBlock || ($stmtNewBlock && $stmtNewBlock->errorCode() != 0)) {
                                $error = $dbhWBW->errorInfo();
                                echo "error - $error[2] <br>";
                            }
                            else{
                                //逐词解析block块复刻成功
                                $count=count($arrNewBlock);
                                echo "wbw block $count recorders.<br/>";                  
                            }
                        }

                        if(count($arrNewBlockData)>0){
                            // 开始一个事务，逐词解析数据 关闭自动提交
                            $dbhWBW->beginTransaction();
                            $query="INSERT INTO wbw ('id','block_id','book','paragraph','wid','word','data','modify_time','receive_time','status','owner') VALUES (?,?,?,?,?,?,?,?,?,?,?)";
                            $stmtWbwData = $dbhWBW->prepare($query);
                            foreach($arrNewBlockData as $oneParam){
                                $stmtWbwData->execute($oneParam);
                            }
                            // 提交更改 
                            $dbhWBW->commit();
                            if (!$stmtWbwData || ($stmtWbwData && $stmtWbwData->errorCode() != 0)) {
                                $error = $dbhWBW->errorInfo();
                                echo "error - $error[2] <br>";
                            }
                            else{
                                //逐词解析 数据 复刻成功
                                $count=count($arrNewBlockData);
                                echo "new wbw $count recorders.";
                            }   
                        }
						
						//不复刻译文
                        
                        //译文 block数据块
                        /*
                        if(count($arrSentNewBlock)>0){
                            $dbhSent->beginTransaction();
                            $query="INSERT INTO sent_block ('id','parent_id','book','paragraph','owner','lang','author','editor','tag','status','modify_time','receive_time') VALUES (?,?,?,?,?,?,?,?,?,?,?,?)";
                            $stmtSentNewBlock = $dbhSent->prepare($query);
                            foreach($arrSentNewBlock as $oneParam){
                                //print_r($oneParam);
                                $stmtSentNewBlock->execute($oneParam);
                            }
                            // 提交更改 
                            $dbhSent->commit();
                            if (!$stmtSentNewBlock || ($stmtSentNewBlock && $stmtSentNewBlock->errorCode() != 0)) {
                                $error = $dbhSent->errorInfo();
                                echo "error - $error[2] <br>";
                            }
                            else{
                                //译文 block块复刻成功
                                $count=count($arrNewBlock);
                                echo "wbw block $count recorders.<br/>";                  
                            }
                        }

                        if(count($arrSentNewBlockData)>0){
                            // 开始一个事务，逐词解析数据 关闭自动提交
                            $dbhSent->beginTransaction();
                            $query="INSERT INTO sentence ('id','block_id','book','paragraph','begin','end','channal','tag','author','editor','text','language','ver','status','modify_time','receive_time') VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?, ?)";
                            $stmtSentData = $dbhSent->prepare($query);
                            foreach($arrSentNewBlockData as $oneParam){
                                $stmtSentData->execute($oneParam);
                            }
                            // 提交更改 
                            $dbhSent->commit();
                            if (!$stmtSentData || ($stmtSentData && $stmtSentData->errorCode() != 0)) {
                                $error = $dbhSent->errorInfo();
                                echo "error - $error[2] <br>";
                            }
                            else{
                                //译文 数据 复刻成功
                                $count=count($arrSentNewBlockData);
                                echo "new translation $count recorders.";
                            }   
                        }
                        */

                        //插入记录到文件索引
                        $filesize=0;
                        //服务器端文件列表
                        PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);
                        $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);
                        $newDocId = UUID::v4();
                        $newDocInfo = $orgFileInfo;
                        $newDocInfo["id"] = $newDocId;
                        $newDocInfo["parent_id"] = $orgFileInfo["id"];
                        $newDocInfo["user_id"] = $_COOKIE["uid"];
                        $newDocInfo["doc_block"] = json_encode($newDocBlockList, JSON_UNESCAPED_UNICODE); 
                        $newData=array($newDocInfo["id"],
                                       $newDocInfo["parent_id"],
                                       $newDocInfo["user_id"],
                                       $newDocInfo["book"],
                                       $newDocInfo["paragraph"],
                                       $newDocInfo["file_name"],
                                       $newDocInfo["title"],
                                       $newDocInfo["tag"],
                                       $newDocInfo["status"],
                                       mTime(),
                                       mTime(),
                                       mTime(),
                                       $newDocInfo["file_size"], 
                                       $newDocInfo["share"], 
                                       $newDocInfo["doc_info"], 
                                       $newDocInfo["doc_block"], 
                                       mTime()
                                    );
                        $stmt->execute($newData);
                        if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
                            $error = PDO_ErrorInfo();
                            echo "error - $error[2] <br>";
                        }
                        else{
                            //文档列表插入成功
                            
                            echo "doc list updata 1 recorders.";
                            echo "</div>";
                            echo "<h3>复刻成功</h3>";
                            echo "正在<a href='../studio/editor.php?op=opendb&doc_id={$newDocId}'>打开</a>文档";
                            echo "<script>";
                            echo "window.location.assign(\"../studio/editor.php?op=opendb&fileid={$newDocId}\");";
                            echo "</script>";
                        } 
                    }
                    else{
                        echo "无效的文档id";
                    }
                    
                }
            }
        }
    }

	echo "</div>";
?>

</body>
</html>