PageController.class.php 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. <?php
  2. namespace Api\Controller;
  3. use Think\Controller;
  4. class PageController extends BaseController {
  5. //页面详情
  6. public function info(){
  7. $page_id = I("page_id/d");
  8. $page = D("Page")->where(" page_id = '$page_id' ")->find();
  9. if (!$page) {
  10. sleep(1);
  11. $this->sendError(10101);
  12. return false;
  13. }
  14. $login_user = $this->checkLogin(false);
  15. if (!$this->checkItemVisit($login_user['uid'] , $page['item_id'])) {
  16. $this->sendError(10103);
  17. return;
  18. }
  19. $page = $page ? $page : array();
  20. if ($page) {
  21. //unset($page['page_content']);
  22. $page['addtime'] = date("Y-m-d H:i:s",$page['addtime']);
  23. $item_id = $page['item_id'];
  24. $item = D("Item")->where("item_id = '$item_id'")->find();
  25. $page['item_name'] = $item['item_name'];
  26. }
  27. $this->sendResult($page);
  28. }
  29. //删除页面
  30. public function delete(){
  31. $page_id = I("page_id/d")? I("page_id/d") : 0;
  32. $page = D("Page")->where(" page_id = '$page_id' ")->find();
  33. $login_user = $this->checkLogin();
  34. if (!$this->checkItemCreator($login_user['uid'] , $page['item_id']) && $login_user['uid'] != $page['author_uid']) {
  35. $this->sendError(10303);
  36. return ;
  37. }
  38. if ($page) {
  39. $ret = D("Page")->where(" page_id = '$page_id' ")->delete();
  40. //更新项目时间
  41. D("Item")->where(" item_id = '$page[item_id]' ")->save(array("last_update_time"=>time()));
  42. }
  43. if ($ret) {
  44. $this->sendResult(array());
  45. }else{
  46. $this->sendError(10101);
  47. }
  48. }
  49. //保存
  50. public function save(){
  51. $login_user = $this->checkLogin();
  52. $page_id = I("page_id/d") ? I("page_id/d") : 0 ;
  53. $page_title = I("page_title") ?I("page_title") : L("default_title");
  54. $page_comments = I("page_comments") ?I("page_comments") :'';
  55. $page_content = I("page_content");
  56. $cat_id = I("cat_id/d")? I("cat_id/d") : 0;
  57. $item_id = I("item_id/d")? I("item_id/d") : 0;
  58. $s_number = I("s_number/d")? I("s_number/d") : 99;
  59. $login_user = $this->checkLogin();
  60. if (!$this->checkItemPermn($login_user['uid'] , $item_id)) {
  61. $this->sendError(10103);
  62. return;
  63. }
  64. $data['page_title'] = $page_title ;
  65. $data['page_content'] = $page_content ;
  66. $data['page_comments'] = $page_comments ;
  67. $data['s_number'] = $s_number ;
  68. $data['item_id'] = $item_id ;
  69. $data['cat_id'] = $cat_id ;
  70. $data['addtime'] = time();
  71. $data['author_uid'] = $login_user['uid'] ;
  72. $data['author_username'] = $login_user['username'];
  73. if ($page_id > 0 ) {
  74. //在保存前先把当前页面的版本存档
  75. $page = D("Page")->where(" page_id = '$page_id' ")->find();
  76. $insert_history = array(
  77. 'page_id'=>$page['page_id'],
  78. 'item_id'=>$page['item_id'],
  79. 'cat_id'=>$page['cat_id'],
  80. 'page_title'=>$page['page_title'],
  81. 'page_comments'=>$page['page_comments'],
  82. 'page_content'=>base64_encode( gzcompress($page['page_content'], 9)),
  83. 's_number'=>$page['s_number'],
  84. 'addtime'=>$page['addtime'],
  85. 'author_uid'=>$page['author_uid'],
  86. 'author_username'=>$page['author_username'],
  87. );
  88. D("PageHistory")->add($insert_history);
  89. $ret = D("Page")->where(" page_id = '$page_id' ")->save($data);
  90. //统计该page_id有多少历史版本了
  91. $Count = D("PageHistory")->where(" page_id = '$page_id' ")->Count();
  92. if ($Count > 20 ) {
  93. //每个单页面只保留最多20个历史版本
  94. $ret = D("PageHistory")->where(" page_id = '$page_id' ")->limit("20")->order("page_history_id desc")->select();
  95. D("PageHistory")->where(" page_id = '$page_id' and page_history_id < ".$ret[19]['page_history_id'] )->delete();
  96. }
  97. //如果是单页项目,则将页面标题设置为项目名
  98. $item_array = D("Item")->where(" item_id = '$item_id' ")->find();
  99. if ($item_array['item_type'] == 2 ) {
  100. D("Item")->where(" item_id = '$item_id' ")->save(array("last_update_time"=>time(),"item_name"=>$page_title));
  101. }else{
  102. D("Item")->where(" item_id = '$item_id' ")->save(array("last_update_time"=>time()));
  103. }
  104. $return = D("Page")->where(" page_id = '$page_id' ")->find();
  105. }else{
  106. $page_id = D("Page")->add($data);
  107. //更新项目时间
  108. D("Item")->where(" item_id = '$item_id' ")->save(array("last_update_time"=>time()));
  109. $return = D("Page")->where(" page_id = '$page_id' ")->find();
  110. }
  111. if (!$return) {
  112. $return['error_code'] = 10103 ;
  113. $return['error_message'] = 'request fail' ;
  114. }
  115. $this->sendResult($return);
  116. }
  117. //历史版本列表
  118. public function history(){
  119. $login_user = $this->checkLogin(false);
  120. $page_id = I("page_id/d") ? I("page_id/d") : 0 ;
  121. $page = M("Page")->where(" page_id = '$page_id' ")->find();
  122. if (!$this->checkItemVisit($login_user['uid'] , $page['item_id'])) {
  123. $this->sendError(10103);
  124. return;
  125. }
  126. $PageHistory = D("PageHistory")->where("page_id = '$page_id' ")->order(" addtime desc")->limit(10)->select();
  127. if ($PageHistory) {
  128. foreach ($PageHistory as $key => &$value) {
  129. $value['addtime'] = date("Y-m-d H:i:s" , $value['addtime']);
  130. $page_content = uncompress_string($value['page_content']);
  131. if (!empty($page_content)) {
  132. $value['page_content'] = htmlspecialchars_decode($page_content) ;
  133. }
  134. }
  135. $this->sendResult($PageHistory);
  136. }else{
  137. $this->sendResult(array());
  138. }
  139. }
  140. //返回当前页面和历史某个版本的页面以供比较
  141. public function diff(){
  142. $page_id = I("page_id/d");
  143. $page_history_id = I("page_history_id/d");
  144. if (!$page_id) {
  145. return false;
  146. }
  147. $page = M("Page")->where(" page_id = '$page_id' ")->find();
  148. if (!$page) {
  149. sleep(1);
  150. $this->sendError(10101);
  151. return false;
  152. }
  153. $login_user = $this->checkLogin(false);
  154. if (!$this->checkItemVisit($login_user['uid'] , $page['item_id'])) {
  155. $this->sendError(10103);
  156. return;
  157. }
  158. $history_page = D("PageHistory")->where(" page_history_id = '$page_history_id' ")->find();
  159. $page_content = uncompress_string($history_page['page_content']);
  160. $history_page['page_content'] = $page_content ? $page_content : $history_page['page_content'] ;
  161. $this->sendResult(array("page"=>$page,"history_page"=>$history_page));
  162. }
  163. //上传图片
  164. public function uploadImg(){
  165. $login_user = $this->checkLogin();
  166. $item_id = I("item_id/d") ? I("item_id/d") : 0 ;
  167. $page_id = I("page_id/d") ? I("page_id/d") : 0 ;
  168. if ($_FILES['editormd-image-file']['name'] == 'blob') {
  169. $_FILES['editormd-image-file']['name'] .= '.jpg';
  170. }
  171. if (strstr(strtolower($_FILES['editormd-image-file']['name']), ".php") ) {
  172. return false;
  173. }
  174. $qiniu_config = C('UPLOAD_SITEIMG_QINIU') ;
  175. if (!empty($qiniu_config['driverConfig']['secrectKey'])) {
  176. //上传到七牛
  177. $Upload = new \Think\Upload(C('UPLOAD_SITEIMG_QINIU'));
  178. $info = $Upload->upload($_FILES);
  179. $url = $info['editormd-image-file']['url'] ;
  180. if ($ret) {
  181. echo json_encode(array("url"=>$url,"success"=>1));
  182. }
  183. }else{
  184. $upload = new \Think\Upload();// 实例化上传类
  185. $upload->maxSize = 3145728 ;// 设置附件上传大小
  186. $upload->allowExts = array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
  187. $upload->rootPath = './../Public/Uploads/';// 设置附件上传目录
  188. $upload->savePath = '';// 设置附件上传子目录
  189. $info = $upload->upload() ;
  190. if(!$info) {// 上传错误提示错误信息
  191. $this->error($upload->getError());
  192. return;
  193. }else{// 上传成功 获取上传文件信息
  194. $url = get_domain().__ROOT__.substr($upload->rootPath,1).$info['editormd-image-file']['savepath'].$info['editormd-image-file']['savename'] ;
  195. echo json_encode(array("url"=>$url,"success"=>1));
  196. }
  197. }
  198. }
  199. }