totalCount.php

<?php

if(!empty($argv[1]) && !empty($argv[2])){
    $startDate = $argv[1];
    $endDate = $argv[2];
}else{
    echo "startDate or endDate is empty.\n";die;
}
require_once "/home/work/db.php";
$fileName='t_trans.txt';
$countNum = 0;
$tbName = 't_trans';
for($i=0; $i<=99; $i++) {
    if (strlen($i) == 1) {
        $dbNo = sprintf("%02d", $i);
    } else {
        $dbNo = $i;
    }
    $dbStr = 'bfb_db_'.$dbNo;
    for($j=0; $j<=9; $j++){
        $tbStr = $tbName.'_'.$dbNo.'_'.$j;
        echo $tbStr."\t";
        $sql = "select count(*) as cnt from $dbStr.$tbStr where f_modify_time>='$startDate' and f_create_time>='$startDate' and f_create_time<'$endDate'";
        $data = util::query($sql, conf::COREDB);
        $str = $data[0]['cnt'];
        echo $str."\n";
        $countNum += $data[0]['count_num'];
        file_put_contents($fileName, $str."\n", FILE_APPEND);
    }
}
echo 'totalCount: '.$countNum."\n";