HuaWeiController.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. /**
  3. * ${CARET}
  4. * @file:HuaWeiController.php
  5. * @Created by gnitif
  6. * @Date: 2023/2/6
  7. * @Time: 15:40
  8. */
  9. namespace App\Http\Controllers\QuickApp;
  10. use App\Http\Controllers\Controller;
  11. use App\Modules\Subscribe\Services\ChapterOrderService;
  12. use Illuminate\Support\Facades\DB;
  13. class HuaWeiController extends Controller
  14. {
  15. public function index(){
  16. $has =ChapterOrderService::checkBookIsOrdered(341799779,66643);
  17. echo "<pre><hr>";
  18. var_export($has);
  19. echo "<hr>";
  20. die();
  21. die();
  22. $sql = "SELECT id,send_order_id,balance,created_at FROM users WHERE send_order_id in (4007118,4007706,4007708,4007731,4007733,4007793,4007834,4007843,4009806,4012429,4016127,4023097) and LENGTH(openid) > 32 AND created_at > '2023-02-2' and balance > 0 and balance < 100;";
  23. // $sql = "SELECT id,send_order_id,balance,created_at FROM users WHERE 1 limit 10";
  24. $uids = DB::select($sql);
  25. foreach ($uids as $v){
  26. $res = ReadRecordService::getReadRecord($v->id);
  27. // $res = ReadRecordService::getReadRecord(1234598187);
  28. echo "<pre><hr> uid => ".$v->id."\t 书币:{$v->balance} \t 注册时间:{$v->created_at} \t 阅读书籍本数:".count($res)."<br> ";
  29. var_export($res);
  30. }
  31. }
  32. }