PHP还有mysql 关于时间的处理和查询

统计每个月的数据

$msql = "select MONTH (date(FROM_UNIXTIME(time))) as time,sum(amount) price,count(id) sum from st_pays_shangjia where status = 1 and YEAR(date(FROM_UNIXTIME(time)))={$year} group by time";
   $month = M('pays_shangjia')->Field('MONTH (date(FROM_UNIXTIME(time))) as time,sum(amount) price,count(id) sum')->where($where)->group('time')->select();

传入指定的前后时间来获取中间的时间

function printDates($start,$end){
    $dt_start = strtotime($start);
    $dt_end = strtotime($end);
    while ($dt_start<=$dt_end){
        $list[] = date("Y-m-d",$dt_start);
        $dt_start = strtotime('+1 day',$dt_start);
    }
    return $list;
}

根据传入的字段来对二维数组排序

if(!$list){
            foreach ($datelist as $k => $v) {
                $list[] = array(
                    'logdate' => $v,
                    'sum' => 0,
                    'price' => 0,
                ); 
            }
        }else{
            foreach ($list as $k => $v) {
                $lists[] = $v['logdate'];
            }

            foreach ($datelist as $k => $v) {
                if(!in_array($v,$lists)){
                    $list[] = array(
                        'logdate' => $v,
                        'sum' => 0,
                        'price' => 0,
                    );
                }
            }

        }
        $last_names = array_column($list,'logdate');
        array_multisort($last_names,SORT_ASC,$list);