صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
book
/
book_admin
3
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: 7d4aad4428
شاخه‌ها تگ‌ها
book_admin
/
application
/
admin
/
command
/
GetSQL.php

GetSQL.php 28 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899 
  1. <?php
    2. 

  2. 

  3. 

  4. namespace app\admin\command;
    5. 

  5. 

  6. use think\console\Command;
    7. 

  7. use think\console\Input;
    8. 

  8. use think\console\Output;
    9. 

  9. use think\Request;
    10. 

  10. 

  11. class GetSQL extends Command
    12. 

  12. {
    13. 

  13.     protected function configure()
    14. 

  14.     {
    15. 

  15.         $this->setName('GetSQL')->setDescription('BC,UC数据恢复');
    16. 

  16.     }
    17. 

  17. 

  18.     protected function execute(Input $input, Output $output)
    19. 

  19.     {
    20. 

  20.         Request::instance()->module('admin');
    21. 

  21.     }
    22. 

  22. 

  23.     public function uc_bakc(){
    24. 

  24. //        ini_set("auto_detect_line_endings", true);
    25. 

  25. //        $handle  = fopen ('/Users/duanenjian/Downloads/ssdb_uc.txt', "r");
    26. 

  26. //        $writeHandle  = fopen ('/Users/duanenjian/Downloads/ssdb_uc_sql.sql', "a");
    27. 

  27. //        while (($line = fgets($handle)) !== false){
    28. 

  28. //            $buffer  = substr(trim($line),69);
    29. 

  29. //            list($admin_id,$time,$data) = explode(" ",$buffer);
    30. 

  30. //            $admin_id = substr($admin_id,strlen('admin_id:'));
    31. 

  31. //            $time = substr($time,strlen('createdate:'));
    32. 

  32. //            $source = trim(substr($data,strlen('data:')),',');
    33. 

  33. //            $data = json_decode(substr($data,strlen('data:')),true);
    34. 

  34. //
    35. 

  35. //            $channel_map = ['admin_id'=>$admin_id,'type'=>1,'createdate'=>$time];
    36. 

  36. //            if($data){
    37. 

  37. //                $insert_sql = $insert_sql = "INSERT INTO `user_collect`(`admin_id` , `type` , `createdate` , `increase_f` , `increase_m` , `increase_fllow` , `increase` , `increase_recharge`, `createtime`, `updatetime`)  VALUES";
    38. 

  38. //                $insert_sql = $insert_sql.vsprintf(" (%d , %d , '%s' , %d , %d , %d , %d , %d , %d , %d);", array_merge($channel_map,$data,array('createtime'=>time(),'updatetime'=>time())));
    39. 

  39. //                fwrite($writeHandle, $insert_sql."\r\n");
    40. 

  40. //            }else{
    41. 

  41. //                $output->error('错误数据: admin_id:'.$admin_id.' time:'.$time.' source:'.$line);
    42. 

  42. //            }
    43. 

  43. //
    44. 

  44. //        }
    45. 

  45. //        if(!feof($handle)){
    46. 

  46. //            $output->error('未读完');
    47. 

  47. //        }
    48. 

  48. //        fclose($writeHandle);
    49. 

  49. //        fclose ($handle);
    50. 

  50.     }
    51. 

  51. 

  52.     public function bc_back(){
    53. 

  53. //        ini_set("auto_detect_line_endings", true);
    54. 

  54. //        $handle  = fopen ('/Users/duanenjian/Downloads/ssdb_bc.txt', "r");
    55. 

  55. //        $writeHandle  = fopen ('/Users/duanenjian/Downloads/ssdb_bc_sql.sql', "a");
    56. 

  56. //        while (($line = fgets($handle)) !== false){
    57. 

  57. //            $buffer  = substr(trim($line),69);
    58. 

  58. //            list($admin_id,$time,$data) = explode(" ",$buffer);
    59. 

  59. //            $admin_id = substr($admin_id,strlen('admin_id:'));
    60. 

  60. //            $time = substr($time,strlen('createdate:'));
    61. 

  61. //            $source = trim(substr($data,strlen('data:')),',');
    62. 

  62. //            $data = json_decode(trim(substr($data,strlen('data:')),','),true);
    63. 

  63. //            if(!$data){
    64. 

  64. //                if($admin_id == '2487'){
    65. 

  65. //                    $data = json_decode('{"11000015901":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"7290","spending_free_kandian":"3570","spending_num":"243","spending_recharge_kandian":"3720","spending_users":"1"},"11000132025":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"8670","spending_free_kandian":"6233","spending_num":"276","spending_recharge_kandian":"2437","spending_users":"117"},"11000154255":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"6970","spending_free_kandian":"5150","spending_num":"226","spending_recharge_kandian":"1820","spending_users":"121"},"11000000165":{"spending_count_kandian":"70","spending_free_kandian":"30","spending_num":"2","spending_recharge_kandian":"40","spending_users":"1"},"11000001481":{"spending_count_kandian":"210","spending_free_kandian":"210","spending_num":"7","spending_recharge_kandian":"0","spending_users":"7"},"11000001995":{"spending_count_kandian":"150","spending_free_kandian":"150","spending_num":"5","spending_recharge_kandian":"0","spending_users":"5"},"11000003034":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"1"},"11000004654":{"spending_count_kandian":"65","spending_free_kandian":"65","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000005207":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000005848":{"spending_count_kandian":"510","spending_free_kandian":"420","spending_num":"17","spending_recharge_kandian":"90","spending_users":"1"},"11000005930":{"spending_count_kandian":"1200","spending_free_kandian":"0","spending_num":"40","spending_recharge_kandian":"1200","spending_users":"1"},"11000005933":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000005934":{"spending_count_kandian":"245","spending_free_kandian":"35","spending_num":"8","spending_recharge_kandian":"210","spending_users":"1"},"11000005936":{"spending_count_kandian":"2145","spending_free_kandian":"1125","spending_num":"67","spending_recharge_kandian":"1020","spending_users":"7"},"11000006288":{"spending_count_kandian":"190","spending_free_kandian":"185","spending_num":"6","spending_recharge_kandian":"5","spending_users":"4"},"11000006338":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000007518":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000008400":{"spending_count_kandian":"295","spending_free_kandian":"30","spending_num":"9","spending_recharge_kandian":"265","spending_users":"2"},"11000008419":{"spending_count_kandian":"1905","spending_free_kandian":"180","spending_num":"57","spending_recharge_kandian":"1725","spending_users":"6"},"11000015245":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000017232":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000031449":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000031455":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000034880":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000035081":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000065150":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000071505":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000072214":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000073432":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000074446":{"spending_count_kandian":"105","spending_free_kandian":"105","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000075457":{"spending_count_kandian":"140","spending_free_kandian":"140","spending_num":"4","spending_recharge_kandian":"0","spending_users":"1"},"11000075873":{"spending_count_kandian":"90","spending_free_kandian":"90","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000078475":{"spending_count_kandian":"170","spending_free_kandian":"170","spending_num":"5","spending_recharge_kandian":"0","spending_users":"2"},"11000078928":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000078939":{"spending_count_kandian":"485","spending_free_kandian":"465","spending_num":"14","spending_recharge_kandian":"20","spending_users":"2"},"11000079369":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000079588":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000080308":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000083649":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"1"},"11000084483":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000088173":{"spending_count_kandian":"65","spending_free_kandian":"0","spending_num":"2","spending_recharge_kandian":"65","spending_users":"1"},"11000089928":{"spending_count_kandian":"365","spending_free_kandian":"365","spending_num":"12","spending_recharge_kandian":"0","spending_users":"7"},"11000090005":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000090849":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000090871":{"spending_count_kandian":"1260","spending_free_kandian":"1200","spending_num":"41","spending_recharge_kandian":"60","spending_users":"29"},"11000091761":{"spending_count_kandian":"120","spending_free_kandian":"120","spending_num":"4","spending_recharge_kandian":"0","spending_users":"3"},"11000091980":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"1"},"11000093009":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000093196":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000093252":{"spending_count_kandian":"585","spending_free_kandian":"60","spending_num":"19","spending_recharge_kandian":"525","spending_users":"2"},"11000093994":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000094755":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000096321":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000097982":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000098330":{"spending_count_kandian":"105","spending_free_kandian":"105","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000101593":{"spending_count_kandian":"690","spending_free_kandian":"30","spending_num":"23","spending_recharge_kandian":"660","spending_users":"1"},"11000103896":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000108202":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000109759":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000110537":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000115034":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000120008":{"spending_count_kandian":"95","spending_free_kandian":"95","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000121489":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000121587":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000122644":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000122932":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000123786":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"1"},"11000124998":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000125095":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000125426":{"spending_count_kandian":"515","spending_free_kandian":"30","spending_num":"15","spending_recharge_kandian":"485","spending_users":"1"},"11000128354":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000129098":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000130960":{"spending_count_kandian":"1435","spending_free_kandian":"30","spending_num":"46","spending_recharge_kandian":"1405","spending_users":"1"},"11000131412":{"spending_count_kandian":"35","spending_free_kandian":"35","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000131459":{"spending_count_kandian":"330","spending_free_kandian":"330","spending_num":"11","spending_recharge_kandian":"0","spending_users":"6"},"11000131898":{"spending_count_kandian":"90","spending_free_kandian":"90","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000132353":{"spending_count_kandian":"90","spending_free_kandian":"90","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000132483":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000132704":{"spending_count_kandian":"270","spending_free_kandian":"270","spending_num":"8","spending_recharge_kandian":"0","spending_users":"4"},"11000135130":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000135210":{"spending_count_kandian":"1125","spending_free_kandian":"1025","spending_num":"37","spending_recharge_kandian":"100","spending_users":"34"},"11000135480":{"spending_count_kandian":"1005","spending_free_kandian":"120","spending_num":"33","spending_recharge_kandian":"885","spending_users":"5"},"11000136329":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000141252":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000141938":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000144642":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"1"},"11000145092":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000145229":{"spending_count_kandian":"90","spending_free_kandian":"90","spending_num":"3","spending_recharge_kandian":"0","spending_users":"1"},"11000145260":{"spending_count_kandian":"60","spending_free_kandian":"60","spending_num":"2","spending_recharge_kandian":"0","spending_users":"2"},"11000145494":{"spending_count_kandian":"420","spending_free_kandian":"420","spending_num":"14","spending_recharge_kandian":"0","spending_users":"11"},"11000145656":{"spending_count_kandian":"575","spending_free_kandian":"125","spending_num":"17","spending_recharge_kandian":"450","spending_users":"5"},"11000146341":{"spending_count_kandian":"120","spending_free_kandian":"120","spending_num":"4","spending_recharge_kandian":"0","spending_users":"1"},"11000146386":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000146654":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000146882":{"spending_count_kandian":"1404","spending_free_kandian":"1287","spending_num":"36","spending_recharge_kandian":"117","spending_users":"32"},"11000147001":{"spending_count_kandian":"655","spending_free_kandian":"130","spending_num":"20","spending_recharge_kandian":"525","spending_users":"3"},"11000147499":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000147626":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000147629":{"spending_count_kandian":"210","spending_free_kandian":"210","spending_num":"7","spending_recharge_kandian":"0","spending_users":"5"},"11000149121":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000149166":{"spending_count_kandian":"1295","spending_free_kandian":"105","spending_num":"37","spending_recharge_kandian":"1190","spending_users":"4"},"11000149860":{"spending_count_kandian":"1615","spending_free_kandian":"1400","spending_num":"48","spending_recharge_kandian":"215","spending_users":"9"},"11000150106":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000151160":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000151445":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000152107":{"spending_count_kandian":"30","spending_free_kandian":"30","spending_num":"1","spending_recharge_kandian":"0","spending_users":"1"},"11000152404":{"spending_count_kandian":"195","spending_free_kandian":"195","spending_num":"6","spending_recharge_kandian":"0","spending_users":"3"},"11000154890":{"spending_count_kandian":"150","spending_free_kandian":"150","spending_num":"5","spending_recharge_kandian":"0","spending_users":"5"}}',true);
    66. 

  66. //                }
    67. 

  67. //                if($admin_id == '2299'){
    68. 

  68. //                    $data = json_decode('{"11000000028":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"605","spending_free_kandian":"30","spending_num":"19","spending_recharge_kandian":"575","spending_users":"1"},"11000001983":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"6820","spending_free_kandian":"540","spending_num":"221","spending_recharge_kandian":"6280","spending_users":"1"},"11000005426":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"615","spending_free_kandian":"65","spending_num":"19","spending_recharge_kandian":"550","spending_users":"2"},"11000006288":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"12685","spending_free_kandian":"3455","spending_num":"395","spending_recharge_kandian":"9230","spending_users":"54"},"11000008419":{"recharge_money":"74000","recharge_num":"16","spending_count_kandian":"88720","spending_free_kandian":"30355","spending_num":"2791","spending_recharge_kandian":"58365","spending_users":"173"},"11000017222":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"1895","spending_free_kandian":"790","spending_num":"58","spending_recharge_kandian":"1105","spending_users":"3"},"11000071525":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"2085","spending_free_kandian":"485","spending_num":"67","spending_recharge_kandian":"1600","spending_users":"2"},"11000072039":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"1045","spending_free_kandian":"65","spending_num":"34","spending_recharge_kandian":"980","spending_users":"3"},"11000072592":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"1680","spending_free_kandian":"1080","spending_num":"52","spending_recharge_kandian":"600","spending_users":"1"},"11000078883":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"2555","spending_free_kandian":"0","spending_num":"81","spending_recharge_kandian":"2555","spending_users":"1"},"11000078928":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"8930","spending_free_kandian":"3665","spending_num":"281","spending_recharge_kandian":"5265","spending_users":"30"},"11000083358":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"7560","spending_free_kandian":"1310","spending_num":"243","spending_recharge_kandian":"6250","spending_users":"8"},"11000089928":{"recharge_money":"10000","recharge_num":"2","spending_count_kandian":"13095","spending_free_kandian":"3190","spending_num":"409","spending_recharge_kandian":"9905","spending_users":"27"},"11000101593":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"5055","spending_free_kandian":"1850","spending_num":"161","spending_recharge_kandian":"3205","spending_users":"62"},"11000114467":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"3510","spending_free_kandian":"2760","spending_num":"112","spending_recharge_kandian":"750","spending_users":"7"},"11000118568":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"1755","spending_free_kandian":"30","spending_num":"56","spending_recharge_kandian":"1725","spending_users":"1"},"11000122941":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"950","spending_free_kandian":"0","spending_num":"29","spending_recharge_kandian":"950","spending_users":"1"},"11000129084":{"recharge_money":"49000","recharge_num":"13","spending_count_kandian":"27790","spending_free_kandian":"18260","spending_num":"794","spending_recharge_kandian":"9530","spending_users":"257"},"11000131459":{"recharge_money":"19000","recharge_num":"5","spending_count_kandian":"23230","spending_free_kandian":"8180","spending_num":"727","spending_recharge_kandian":"15050","spending_users":"60"},"11000132025":{"recharge_money":"13000","recharge_num":"3","spending_count_kandian":"16695","spending_free_kandian":"9200","spending_num":"525","spending_recharge_kandian":"7495","spending_users":"202"},"11000132774":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"4715","spending_free_kandian":"1865","spending_num":"155","spending_recharge_kandian":"2850","spending_users":"47"},"11000135210":{"recharge_money":"10000","recharge_num":"2","spending_count_kandian":"28725","spending_free_kandian":"16030","spending_num":"924","spending_recharge_kandian":"12695","spending_users":"369"},"11000143745":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"4640","spending_free_kandian":"2375","spending_num":"145","spending_recharge_kandian":"2265","spending_users":"35"},"11000145259":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"4930","spending_free_kandian":"2975","spending_num":"162","spending_recharge_kandian":"1955","spending_users":"39"},"11000145494":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"10430","spending_free_kandian":"9255","spending_num":"338","spending_recharge_kandian":"1175","spending_users":"224"},"11000145700":{"recharge_money":"8000","recharge_num":"2","spending_count_kandian":"5030","spending_free_kandian":"1950","spending_num":"160","spending_recharge_kandian":"3080","spending_users":"41"},"11000146882":{"recharge_money":"9000","recharge_num":"3","spending_count_kandian":"10686","spending_free_kandian":"8181","spending_num":"274","spending_recharge_kandian":"2505","spending_users":"174"},"11000146885":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"13640","spending_free_kandian":"11740","spending_num":"440","spending_recharge_kandian":"1900","spending_users":"274"},"11000148204":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"2320","spending_free_kandian":"1090","spending_num":"74","spending_recharge_kandian":"1230","spending_users":"4"},"11000149166":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"5425","spending_free_kandian":"3280","spending_num":"155","spending_recharge_kandian":"2145","spending_users":"55"},"11000152428":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"4435","spending_free_kandian":"3205","spending_num":"145","spending_recharge_kandian":"1230","spending_users":"79"},"11000154256":{"recharge_money":"17000","recharge_num":"5","spending_count_kandian":"30170","spending_free_kandian":"12825","spending_num":"955","spending_recharge_kandian":"17345","spending_users":"291"},"11000155016":{"recharge_money":"18000","recharge_num":"4","spending_count_kandian":"75135","spending_free_kandian":"46860","spending_num":"2411","spending_recharge_kandian":"28275","spending_users":"1032"},"11000156465":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"2550","spending_free_kandian":"1315","spending_num":"81","spending_recharge_kandian":"1235","spending_users":"40"},"11000158256":{"recharge_money":"3000","recharge_num":"1","spending_count_kandian":"7305","spending_free_kandian":"4995","spending_num":"235","spending_recharge_kandian":"2310","spending_users":"143"},"11000158708":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"14910","spending_free_kandian":"4235","spending_num":"485","spending_recharge_kandian":"10675","spending_users":"20"},"11000158709":{"recharge_money":"139500","recharge_num":"28","spending_count_kandian":"104525","spending_free_kandian":"52165","spending_num":"3277","spending_recharge_kandian":"52360","spending_users":"931"},"11000159132":{"recharge_money":"13000","recharge_num":"3","spending_count_kandian":"32325","spending_free_kandian":"9245","spending_num":"1019","spending_recharge_kandian":"23080","spending_users":"31"},"11000160617":{"recharge_money":"5000","recharge_num":"1","spending_count_kandian":"2300","spending_free_kandian":"2170","spending_num":"73","spending_recharge_kandian":"130","spending_users":"35"},"11000161782":{"recharge_money":"113000","recharge_num":"29","spending_count_kandian":"89565","spending_free_kandian":"35405","spending_num":"2810","spending_recharge_kandian":"54160","spending_users":"429"}}',true);
    69. 

  69. //                }
    70. 

  70. //            }
    71. 

  71. //            $channel_map = ['admin_id'=>$admin_id,'type'=>1,'createdate'=>$time];
    72. 

  72. //            if($data){
    73. 

  73. //                foreach($data as $cache_key => $cache_val){
    74. 

  74. //                    $insert_sql = "INSERT INTO `book_collect`(`admin_id` , `type` , `createdate` ,`book_id`, `recharge_money` , `recharge_num` , `spending_count_kandian` , `spending_recharge_kandian` , `spending_free_kandian`,`spending_users`,`spending_num`,`createtime`,`updatetime`)  VALUES";
    75. 

  75. //                    $channel_map['book_id'] = $cache_key;
    76. 

  76. //                    $channel_params = [
    77. 

  77. //                        'recharge_money' => sprintf('%.2f', ($cache_val['recharge_money'] ?? 0)/100),
    78. 

  78. //                        'recharge_num' => $cache_val['recharge_num'] ?? 0,
    79. 

  79. //                        'spending_count_kandian' => $cache_val['spending_count_kandian'] ?? 0,
    80. 

  80. //                        'spending_recharge_kandian' => $cache_val['spending_recharge_kandian'] ?? 0,
    81. 

  81. //                        'spending_free_kandian' => $cache_val['spending_free_kandian'] ?? 0,
    82. 

  82. //                        'spending_users' => $cache_val['spending_users'] ?? 0,
    83. 

  83. //                        'spending_num' => $cache_val['spending_num'] ?? 0,
    84. 

  84. //                    ];
    85. 

  85. //                    $insert_sql = $insert_sql.vsprintf(" (%d , %d , '%s' , %d , %f , %d , %d , %d , %d , %d , %d ,%d ,%d );", array_merge($channel_map,$channel_params,array('createtime'=>time(),'updatetime'=>time())));
    86. 

  86. //                    fwrite($writeHandle, $insert_sql."\r\n");
    87. 

  87. //                }
    88. 

  88. //            }else{
    89. 

  89. //                $output->error('错误数据: admin_id:'.$admin_id.' time:'.$time.' source:'.$line);
    90. 

  90. //            }
    91. 

  91. //
    92. 

  92. //        }
    93. 

  93. //        if(!feof($handle)){
    94. 

  94. //            $output->error('未读完');
    95. 

  95. //        }
    96. 

  96. //        fclose($writeHandle);
    97. 

  97. //        fclose ($handle);
    98. 

  98.     }
    99. 

  99. }
    100.