commit.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. <?php
  2. require_once "../path.php";
  3. require_once "../public/_pdo.php";
  4. require_once "../public/function.php";
  5. require_once "../channal/function.php";
  6. require_once "../redis/function.php";
  7. require_once "../share/function.php";
  8. require_once "../usent/function.php";
  9. $_data = array();
  10. if (isset($_POST["data"])) {
  11. $_data = json_decode($_POST["data"], true);
  12. } else {
  13. exit;
  14. }
  15. $channelInfo = new Channal();
  16. $srcChannelPower = $channelInfo->getPower($_data["src"]);
  17. $destChannelPower = $channelInfo->getPower($_data["dest"]);
  18. if($srcChannelPower<10 || $destChannelPower<10){
  19. exit;
  20. }
  21. $db_trans_sent = new PDO(_FILE_DB_SENTENCE_, "", "", array(PDO::ATTR_PERSISTENT => true));
  22. $db_trans_sent->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  23. $query = "SELECT * FROM sentence WHERE book= ? AND paragraph= ? AND begin= ? AND end= ? AND channal = ? ";
  24. $stmt = $db_trans_sent->prepare($query);
  25. if($stmt){
  26. $updateDate=array();
  27. $insertData=array();
  28. $prData=array();
  29. $insertHistoray=array();
  30. foreach ($_data["sent"] as $key => $value) {
  31. # code...
  32. $infoSrc = explode("-",$value);
  33. $infoDest = $infoSrc;
  34. $infoSrc[]=$_data["src"];
  35. $infoDest[]=$_data["dest"];
  36. $stmt->execute($infoSrc);
  37. $fetchSrc = $stmt->fetch(PDO::FETCH_ASSOC);
  38. if ($fetchSrc) {
  39. # 有 源数据
  40. $newData = $fetchSrc;
  41. $newData["modify_time"]=mTime();
  42. $newData["channal"]=$_data["dest"];
  43. $newData["landmark"]="";
  44. $stmt->execute($infoDest);
  45. $fetchDest = $stmt->fetch(PDO::FETCH_ASSOC);
  46. if ($fetchDest) {
  47. #有目标数据,比较时间
  48. if($fetchSrc["modify_time"]>$fetchDest["modify_time"]){
  49. #新数据 更新
  50. if($destChannelPower>=20){
  51. #有权限 直接写入
  52. $newData["id"]=$fetchDest["id"];
  53. $updateDate[] = $newData;
  54. $insertHistoray[] = $newData;
  55. }
  56. else{
  57. #pr
  58. $prData[] = $newData;
  59. }
  60. }
  61. }
  62. else{
  63. #没有目标数据新增
  64. if($destChannelPower>=20){
  65. #有写入权限 直接写入
  66. $newData["id"] = UUID::v4();
  67. $insertData[] = $newData;
  68. $insertHistoray[] = $newData;
  69. }
  70. else{
  71. #pr
  72. $prData[] = $newData;
  73. }
  74. }
  75. }
  76. }
  77. #到此,所有的数据已经准备好
  78. $sentDb = new Sent_DB();
  79. $respond['message'] = "";
  80. $respond['status'] = 0;
  81. if($sentDb->update($updateDate)){
  82. $respond['update'] = count($updateDate);
  83. }
  84. else{
  85. $respond['message'] = $sentDb->getError();
  86. $respond['status'] = 1;
  87. }
  88. if($sentDb->insert($insertData)){
  89. $respond['insert'] = count($insertData);
  90. }else{
  91. $respond['message'] = $sentDb->getError();
  92. $respond['status'] = 1;
  93. }
  94. if($sentDb->send_pr($prData)){
  95. $respond['pr'] = count($prData);
  96. }else{
  97. $respond['message'] = $sentDb->getError();
  98. $respond['status'] = 1;
  99. }
  100. if($sentDb->historay($insertHistoray)){
  101. $respond['historay'] = count($insertHistoray);
  102. }else{
  103. $respond['message'] = $sentDb->getError();
  104. $respond['status'] = 1;
  105. }
  106. }
  107. else{
  108. $respond['message'] = $db_trans_sent->errorInfo();
  109. $respond['status'] = 1;
  110. }
  111. echo json_encode($respond, JSON_UNESCAPED_UNICODE);
  112. ?>