ｔｐ关联查询

/*
 * -1 奖项公布，包括手动结束
 * 1 投稿结束,奖项还没公布 ，时间判断
 * 2 未结束=投稿开始了，投稿还没结束
 * 3 未开始
 * */
$map_end = array();
if (!empty($_GET[‘is_end‘])){
    $is_end = $_GET[‘is_end‘];
    if($is_end == ‘-1‘){
        $map_end = array(
            ‘is_end‘=>1,
            ‘publish_time‘=>array(‘lt‘,time()),
            ‘_logic‘=>‘or‘
        );
    }elseif($is_end == ‘1‘){
        $map_end = array(
            ‘is_end‘=>0,
            ‘publish_time‘=>array(‘gt‘,time()),
            ‘endtime‘=>array(‘lt‘,time()),
            ‘_logic‘=>‘and‘
        );
    }elseif($is_end == ‘2‘){
        $map_end = array(
            ‘is_end‘=>0,
            ‘endtime‘=>array(‘gt‘,time()),
            ‘starttime‘=>array(‘lt‘,time()),
            ‘_logic‘=>‘and‘
        );
    }else{
        $map_end = array(
            ‘is_end‘=>0,
            ‘starttime‘=>array(‘gt‘,time()),
            ‘_logic‘=>‘and‘
        );
    }
    $this->assign(‘is_end‘,$is_end);
}

if (!empty($_GET[‘is_rec‘]) || ($_GET[‘is_rec‘] == ‘0‘)){
    $is_rec = $_GET[‘is_rec‘];
    if (count($map_end) == 0){
        $map_rec[‘is_rec‘] = $is_rec;
    }else{
        $map_rec = array(
            ‘is_rec‘ => $is_rec,
            ‘_complex‘ => $map_end,
            ‘_logic‘ => ‘and‘
        );
    }
    $this->assign(‘is_rec‘,$is_rec);
}else{
    $map_rec = $map_end;
}

if (!empty($_GET[‘status‘]) ||($_GET[‘status‘] == ‘0‘)){
    $status = $_GET[‘status‘];
    if (count($map_rec) == 0){
        $map_st[‘status‘] = $status;
    }else{
        $map_st = array(
            ‘status‘ => $status,
            ‘_complex‘ => $map_rec,
            ‘_logic‘ => ‘and‘
        );
    }
    $this->assign(‘status‘,$status);
}else{
    $map_st = $map_rec;
}

ｔｐ关联查询

原文：https://www.cnblogs.com/pansidong/p/9238061.html