web开发之兑换码用户筛选数据

CodeUid.php

<?php

require_once(dirname(__FILE__) . "/stat_init.php");
use \Stat\Models\ModelBase;
use \Stat\Models\Tn;

$db = new ModelBase();
$db->setSsdbName(SSDB_HOT) ;
$ids=[];
$code_info=[];
$codeIds = $db->hGetAll("redeemCodeAll");

//獲取code_id
foreach ($codeIds as $k=>$v)
{
    $infos = $db -> hGetAll("redeemCode_".$k);
    $info=json_decode($infos["award"],true);
    if($infos["count"]==1000 && $info["chips"]==30000 && $infos["createTime"]>=1555689600)
    {
        $ids[]=$k;
    }
}

//將獲取到的信息整理成2維數組
foreach ($ids as $k=>$v)
{
    $info = $db->hGetAll("redeemCodeUsed_".$v);
    foreach ($info as $uid=>$time)
    {
        $one = [];
        $dev_id = $db->hGet("reg_".$uid,"devKey");
        $one["codeId"] = $v;
        $one["uid"] = $uid;
        $one["dev_id"] = $dev_id;
        $one["time"] = date("Y-m-d H:i:s",$time);

        $code_info[] = $one;
    }
}

//將二維數組寫到csv文件中
function setCsv($data)
{
    if(empty($data))
    {
        return false;
    }

    // 打开文件资源，不存在则创建
    $fp = fopen('/tmp/texas/codeUid30k'.'.csv','a');

    // 处理内容
    $content = '';
    foreach($data as $uid => $one){
        $csv_body = [];
        $csv_body[] = $one['codeId'];
        $csv_body[] = $one['uid'];
        $csv_body[] = $one['dev_id'];
        $csv_body[] = $one['time'];

        $content .= implode(',', $csv_body) . PHP_EOL;
    }

    // 写入并关闭资源
    fwrite($fp, $content);
    fclose($fp);

    return true;
}
setCsv($code_info);