×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

cronAGReport.php

0
0
 
1
Language: PHP
Posted by: user6d450
Added: May 17, 2019 7:12 AM
Views: 3917
Tags: no tags
  1. <?php
  2.  
  3. /*
  4.  * To change this license header, choose License Headers in Project Properties.
  5.  * To change this template file, choose Tools | Templates
  6.  * and open the template in the editor.
  7.  */
  8.  
  9.  
  10.  
  11. include_once('../config.php');
  12.  
  13. include_once('function.php');
  14.  
  15.  
  16. //include_once GAMEBASEPATH.'agClass.php';
  17.  
  18.  
  19. //$newObj = new agClass(1);
  20. error_reporting(0);
  21.  
  22.  
  23. $timeFrom = time();
  24.  
  25. $timeTo  = time();
  26. function random_strings($length_of_string)
  27. {
  28.  
  29.     // String of all alphanumeric character
  30.     $str_result = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
  31.  
  32.     // Shufle the $str_result and returns substring
  33.     // of specified length
  34.     return substr(str_shuffle($str_result),  
  35.                        0, $length_of_string);
  36. }
  37.  
  38. function random19() {
  39.   $number = "";
  40.   for($i=0; $i<19; $i++) {
  41.     $min = ($i == 0) ? 1:0;
  42.     $number .= mt_rand($min,9);
  43.   }
  44.   return $number;
  45. }
  46. function callMeAlways($timeFrom,$nextId='')
  47. {
  48.    
  49.    
  50.     global $newObj;
  51.    
  52.     //$data = $newObj->getBetRecords($timeFrom,$nextId);
  53.    
  54.    
  55.     $data = json_decode($data,true);
  56.    
  57.     //print_r($data);
  58.       $playerIds = callsql("SELECT player_user_id FROM player_user order by player_user_id desc limit 50,200 ",'rows');
  59.      
  60.       //$wagerids=array("GC0081930108p");
  61.       $gamenames=array("ag_26","ag_12");
  62.       $channels=array("ag_26","ag_12");
  63.       $betamounts=array("600","800","700","2000");
  64.       $payoffs=array("1950","2000","700","3000");
  65.       $dates=array("2019-04-01 02:00:00","2019-04-02 02:00:00","2019-04-03 07:00:00","2019-04-04 06:00:00","2019-04-15 02:00:00","2019-04-16 02:00:00","2019-04-17 09:00:00","2019-04-21 11:00:00","2019-04-11 02:00:00","2019-04-16 02:00:00","2019-04-20 02:00:00","2019-04-21 02:00:00","2019-04-01 22:00:00","2019-04-23 02:00:00","2019-04-25 02:00:00","2019-04-24 02:00:00"
  66.           ,"2019-04-26 02:00:00","2019-04-27 02:00:00","2019-04-28 02:00:00","2019-04-29 02:00:00","2019-04-30 04:00:00");
  67.  
  68. $roundids=array("ivan001_RT","ivan002_RT");
  69. $sequences=array("ivan001_RT","ivan002_RT");
  70.  
  71.  
  72.    for($i=1;$i<1000;$i++)
  73.    {
  74.        $rand=random_strings(8);;
  75. $data['response']['data']['key'.$i]['UserName']=$playerIds[array_rand($playerIds)]['player_user_id'];
  76. $data['response']['data']['key'.$i]['WagersID']='GC00'.$rand;
  77. $data['response']['data']['key'.$i]['GAMENAME']=$gamenames[array_rand($gamenames)];
  78. $data['response']['data']['key'.$i]['betIp']='';
  79. $data['response']['data']['key'.$i]['WagersDate']=$dates[array_rand($dates)];
  80. $data['response']['data']['key'.$i]['BetAmount']=$betamounts[array_rand($betamounts)];
  81. $data['response']['data']['key'.$i]['Payoff']=$payoffs[array_rand($payoffs)];
  82. $data['response']['data']['key'.$i]['Currency']='CNY';
  83. $data['response']['data']['key'.$i]['jackpotAmount']='';
  84. $data['response']['data']['key'.$i]['luckyDrawId']='';
  85. $data['response']['data']['key'.$i]['roundId']=$roundids[array_rand($roundids)];
  86. $data['response']['data']['key'.$i]['SESSIONID']=$roundids[array_rand($roundids)];
  87. $data['response']['data']['key'.$i]['GAMETYPE']=$gamenames[array_rand($gamenames)];
  88. $data['response']['data']['key'.$i]['BALANCE']='';
  89. $data['response']['data']['key'.$i]['jpWin']='';
  90.    }
  91. $datas = $data['response']['data'];
  92.  
  93.     $serviceCode = 'AG';
  94.     $sg_turnover = $sg_unprocessed = $sg_winArray =array();
  95.  
  96.     $iaska =0;
  97.     foreach ($datas as $key=>$value)
  98.     {
  99.        // echo "SELECT username FROM player_user WHERE player_user_id='".$value['UserName']."'";
  100.         $playername = callsql("SELECT username FROM player_user WHERE player_user_id='".$value['UserName']."'",'value');
  101.           $upd = callsql("UPDATE player_game_details SET bbin_username='".$playername."',bbin_password='".$playername."' WHERE player_id='".$value['UserName']."'");
  102.        
  103.         $resultDetails = json_encode($value);
  104.      
  105.        
  106.         $iaska++;
  107.        
  108.         $sessionId = $value['SESSIONID'];
  109.         $timeTrans = strtotime($value['GAMEDATE']);
  110.        
  111.         //$md5 = md5($sessionId.$timeTrans);
  112.        
  113.         $acctId = $playername;
  114.         $ticketId = $value['WagersID']; //Tricky Way To Generate Ticket Id .. No Other Option to get Unique Transaction Id
  115.         $categoryId = $value['GAMENAME'];
  116.         $gameCode = $value['GameType'];
  117.         $betIp = $value['betIp'];
  118.         $ticketTime = $value['WagersDate'];
  119.         $betAmount = $value['BetAmount'];
  120.         $winLoss = $value['Payoff'];
  121.         $currency =$value['Currency'];
  122.         $result  = $resultDetails;
  123.         $jackpotAmount = $value['jackpotAmount'];
  124.         $luckyDrawId = $value['luckyDrawId'];
  125.         $result = $value['Result'];
  126.        
  127.  $r=random19();
  128.         $result = '{"BetAmount":'.$betAmount.',"Win":'.$winLoss.',"BetID":"'.$ticketId.'","BetTime":"'.$value['WagersDate'].'","BetTraceID":"'.$acctId.'_RT8::AG::STAKE::'.$r.'","GameCode":"'.$categoryId.'","UserName":"'.$acctId.'"}';
  129.        
  130.         $turnover = (isset($value['BetAmount']))?$value['BetAmount']:0;
  131.         $effective_turnover = $turnover;
  132.        
  133.         if($kind == 1 && $result == 'S') //Need to ask BBIN for more accurate
  134.             $completed = 0;
  135.         else
  136.             $completed = 1;
  137.            
  138.         $roundId = $value['roundId'];
  139.         $sequence = $value['SESSIONID'];
  140.         $channel = $value['GAMETYPE'];
  141.         $balance = $value['BALANCE'];
  142.         $jpWin = $value['jpWin'];
  143.  
  144.         $time = strtotime($ticketTime); //Convert to GMT + 8 - Now Result GMT -4
  145.        // echo "SELECT player_id FROM player_game_details WHERE bbin_username='$acctId'";
  146.         $playerId = callsql("SELECT player_id FROM player_game_details WHERE bbin_username='$acctId'",'value');
  147.       // exit();
  148.  
  149.         $checkExit = callsql("SELECT COUNT(*) FROM game_play_history WHERE  service_code='$serviceCode' AND ticketId='$ticketId'",'value');
  150.  
  151.  
  152.         if(!empty($playerId))
  153.         {
  154.             if(empty($checkExit) && $completed == 1)
  155.             {
  156.    
  157.                 $ins = mysql_query("INSERT INTO  game_play_history SET player_id='$playerId',service_code='$serviceCode',ticketId='$ticketId',categoryId='$categoryId',"
  158.                         . " gameCode='$gameCode',transTime='$time',betIp='$betIp',betAmount='$betAmount',winLoss='$winLoss',currency='$currency',result='$result',"
  159.                         . " jackpotAmount='$jackpotAmount',luckyDrawId='$luckyDrawId',status=1,roundId='$roundId',sequence='$sequence',channel='$channel',aftr_bal='$balance',jpWin='$jpWin',turnover='$turnover',effective_turnover='$effective_turnover'  ");
  160.    
  161.    
  162.    
  163.                 $sg_unprocessed[$playerId] = $sg_unprocessed[$playerId] + ($winLoss);
  164.    
  165.                 $sg_turnover[$playerId]= $sg_turnover[$playerId] + ($betAmount);
  166.    
  167.                 //echo "$iss <br>";
  168.                 if($winLoss > 0)
  169.                 {
  170.                     $sg_winArray[$playerId] = $sg_winArray[$playerId]+ $winLoss;
  171.                 }
  172.    
  173.                 $iss++;
  174.    
  175.             }
  176.         }
  177.          
  178.  
  179.     }
  180.    
  181.     foreach ($sg_turnover as $keyId=>$keyVal)
  182.     {
  183.         $upd = mysql_query("UPDATE player_game_details SET ag_turnover=ag_turnover+$keyVal,ag_unprocessed=ag_unprocessed+$sg_unprocessed[$keyId] WHERE player_id='$keyId'");
  184.    
  185.         $vendorId = 'AG';
  186.         $checkActivePromo = callsql("SELECT * FROM promo_activity_list WHERE player_id='$keyId' AND running_promo=1 AND used_games LIKE '%$vendorId%' ",'row');
  187.        
  188.         $addonPreWallet = $keyVal;
  189.        
  190.         if($sg_winArray[$keyId] > 0)
  191.         {
  192.             $addonPreWallet  =  $addonPreWallet + $sg_winArray[$keyId];
  193.         }
  194.        
  195.         if(!empty($checkActivePromo))
  196.         {
  197.             //$activeAddon = " , promo_turnover = promo_turnover + $keyVal ";  
  198.            
  199.             $myQry = mysql_query("SELECT * FROM promo_activity_list WHERE player_id='$keyId' AND running_promo=1 AND used_games LIKE '%$vendorId%' ORDER BY create_time ASC");
  200.            
  201.             $needToUse = $keyVal;
  202.            
  203.             while($myRes = mysql_fetch_assoc($myQry))
  204.             {
  205.                 if($needToUse > 0)
  206.                 {
  207.                     $currentMax = $myRes['turover_amount'];
  208.                     $currentReached = $myRes['turnover_reached'];
  209.                     $currentPromoBal = $myRes['bal_amount'];
  210.                     $promo_activity_list_id = $myRes['promo_activity_list_id'];
  211.                     $tempAfterAdd = $currentReached+$needToUse;
  212.                     $promoAmount = $myRes['amount'];
  213.  
  214.                    
  215.                     if($currentReached >= $currentMax && $currentPromoBal == 0)
  216.                     {
  217.                         $amountToUse =0;
  218.                         $status = 2;
  219.                         $running_promo = 0;
  220.                         $end_type = 1;
  221.                         $end_time = time();
  222.                     }
  223.                     if($tempAfterAdd >= $currentMax && $currentPromoBal ==0)
  224.                     {
  225.                         $amountToUse = $currentMax-$currentReached;
  226.                         $needToUse = $needToUse -$amountToUse;
  227.                         $status = 2;
  228.                         $running_promo = 0;
  229.                         $end_type = 1;
  230.                         $end_time = time();
  231.  
  232.  
  233.                         addPromoToMainWallet($keyId,$myRes['promo_activity_list_id']);
  234.  
  235.  
  236.                     }
  237.                     else
  238.                     {
  239.                         $amountToUse = $needToUse;
  240.                         $needToUse =0;
  241.                         if($currentPromoBal > 0)
  242.                             $status = 0;
  243.                         else
  244.                             $status =1;
  245.                        
  246.                         $running_promo = 1;
  247.                         $end_type = 0;
  248.                         $end_time = '';
  249.                     }
  250.                    
  251.                     mysql_query("UPDATE promo_activity_list SET promo_status='$status',running_promo='$running_promo',"
  252.                             . "end_type='$end_type',end_time='$end_time',turnover_reached=turnover_reached+$amountToUse WHERE promo_activity_list_id ='$promo_activity_list_id'");
  253.                    
  254.                     $transId = $myRes['transid'];
  255.                    
  256.                     if($status == 2)
  257.                     {
  258.                         if(!empty($transId))
  259.                         {
  260.                             $update = mysql_query("UPDATE player_turnover SET status=2,deposit_turnover=deposit_turnover+1 WHERE transaction_id='$transId' AND status != 2");
  261.                         }
  262.                     }
  263.                    
  264.                 }
  265.             }
  266.                
  267.         }
  268.         else
  269.         {
  270.             $activeAddon = " , pre_wallet_bal=pre_wallet_bal+$addonPreWallet ";
  271.             updateTurnover($keyId,$keyVal);
  272.         }
  273.        
  274.        
  275.         mysql_query(" UPDATE player_wallet SET deposit_turnover=deposit_turnover+$keyVal,vip_turnover=vip_turnover+$keyVal $activeAddon WHERE player_id ='$keyId'");
  276.        
  277.        
  278.        
  279.     }
  280.    
  281.     if(!empty($data['response']['pagination']))
  282.     {
  283.         $totalPages = $data['response']['pagination']['TotalPage'];
  284.         $currentPages = $data['response']['pagination']['Page'];
  285.        
  286.         if($totalPages > $currentPages )
  287.         {
  288.             $newPage = $currentPages+1;
  289.             callMeAlways($timeFrom,$newPage);
  290.         }
  291.     }
  292.    
  293.    
  294. }
  295.  
  296.  
  297. callMeAlways($timeFrom);
  298. ?>
  299.  

Write a comment

To post comments, please log in or register.