HuaWeiController.php 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  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\User\Services\ReadRecordService;
  12. use Illuminate\Support\Facades\DB;
  13. class HuaWeiController extends Controller
  14. {
  15. public function index(){
  16. // $sql = "SELECT id,send_order_id 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;";
  17. $sql = "SELECT id,send_order_id FROM users WHERE 1 limit 1";
  18. $uids = DB::select($sql);
  19. foreach ($uids as $v){
  20. $res = ReadRecordService::getReadRecord($v->id);
  21. // $res = ReadRecordService::getReadRecord(1234598187);
  22. if(count($res) > 1){
  23. echo "<pre><hr>".$v->id."<br>";
  24. var_export($res);
  25. }else{
  26. }
  27. }
  28. }
  29. }