coop.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?php
  2. /*
  3. *
  4. list (doc_id)
  5. add (doc_id ,userid)
  6. del (doc_id, userid)
  7. set (doc_id ,userid ,value)
  8. *
  9. */
  10. require_once "../path.php";
  11. require_once "../public/_pdo.php";
  12. require_once "../public/function.php";
  13. require_once "../ucenter/function.php";
  14. $userid="";
  15. $isLogin=false;
  16. if($_COOKIE["userid"]){
  17. $userid=$_COOKIE["userid"];
  18. $isLogin = true;
  19. }
  20. if($_GET["do"]){
  21. $_do=$_GET["do"];
  22. }
  23. else{
  24. echo "Error:缺乏必要的参数 do";
  25. exit;
  26. }
  27. if($_GET["doc_id"]){
  28. $_doc_id=$_GET["doc_id"];
  29. }
  30. else{
  31. echo "Error:缺乏必要的参数 doc_id";
  32. exit;
  33. }
  34. $powerlist["10"] = "阅读";
  35. $powerlist["20"] = "建议";
  36. $powerlist["30"] = "修改";
  37. $powerlist["40"] = "管理员";
  38. PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);
  39. echo "<input id='doc_coop_docid' type='hidden' value='{$_doc_id}' />";
  40. $query = "SELECT * from fileindex where id = ? ";
  41. $Fetch = PDO_FetchAll($query,array($_doc_id));
  42. $iFetch=count($Fetch);
  43. if($iFetch>0){
  44. $owner = $Fetch[0]["user_id"];
  45. $uid = $_COOKIE["uid"];
  46. if($owner==$uid){
  47. //自己的文档
  48. switch($_do){
  49. case "list":
  50. break;
  51. case "add":
  52. $query="INSERT INTO power ('id','doc_id','user','power','status','create_time','modify_time','receive_time')
  53. VALUES (?,?,?,?,?,?,?,?)";
  54. $stmt = $PDO->prepare($query);
  55. $stmt->execute(
  56. array(UUID::v4(),
  57. $_GET["doc_id"],
  58. $_GET["user_id"],
  59. 10,
  60. 1,
  61. mTime(),
  62. mTime(),
  63. mTime())
  64. );
  65. if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
  66. $error = PDO_ErrorInfo();
  67. echo "error - $error[2] <br>";
  68. }
  69. break;
  70. case "del":
  71. $query="DELETE FROM power WHERE doc_id = ? AND user = ? ";
  72. $stmt = $PDO->prepare($query);
  73. $stmt->execute(
  74. array($_GET["doc_id"],
  75. $_GET["user_id"])
  76. );
  77. if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
  78. $error = PDO_ErrorInfo();
  79. echo "error - $error[2] <br>";
  80. }
  81. break;
  82. case "set":
  83. $query="UPDATE power SET power = ? , modify_time = ? WHERE doc_id = ? AND user = ? ";
  84. $stmt = $PDO->prepare($query);
  85. $stmt->execute(
  86. array($_GET["value"],
  87. mTime(),
  88. $_GET["doc_id"],
  89. $_GET["user_id"])
  90. );
  91. if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
  92. $error = PDO_ErrorInfo();
  93. echo "error - $error[2] <br>";
  94. }
  95. break;
  96. }
  97. $query = "SELECT * from power where doc_id = ? ";
  98. $Fetch = PDO_FetchAll($query,$_doc_id);
  99. echo "<ul>";
  100. foreach($Fetch as $row){
  101. echo "<li>";
  102. echo ucenter_getA($row["user"],"");
  103. echo "<select onchange=\"coop_power_change('{$row["user"]}',this)\">";
  104. foreach($powerlist as $key=>$value){
  105. echo "<option value='{$key}' ";
  106. if($row["power"]==$key){
  107. echo "selected";
  108. }
  109. echo ">{$value}</option>";
  110. }
  111. echo "</select>";
  112. echo "<button onclick=\"coop_del('{$row["user"]}')\">删除</button>";
  113. echo "</li>";
  114. }
  115. echo "</ul>";
  116. ?>
  117. 添加协作者
  118. <div id="wiki_search" style="width:100%;">
  119. <div><input id="username_input" type="input" placeholder="用户名" onkeyup="username_search_keyup(event,this)"/></div>
  120. <div id="search_result">
  121. </div>
  122. </div>
  123. <?php
  124. }
  125. else{
  126. //别人的的文档
  127. echo "<a href='fork.php?doc_id={$doc_id}'>[复刻]</a>";
  128. }
  129. }
  130. ?>