tp3mysql组合查询

tp3当多个组合的时候怎么查询

用法一

		if (!empty($name = I('name'))) {
            $map1['user.name'] = array('like', '%' . $name . '%');
            $map1['user.hl_name'] = Crypt::encrypt($name, 'HL');
            $map1['_logic'] = 'or';
        }
        if (!empty($tel = I('tel'))) {
            $map2['user.tel'] = $tel;
            $map2['user.hl_tel'] = $tel;
            $map2['_logic'] = 'or';
        }
        if (!empty($promote_platform = I('promote_platform'))) {
            $map3['promote.parent_id'] = $promote_platform;
            $map3['promote.parentid_list'] = ['like', "{$promote_platform},%"];
            $map3['_logic'] = 'or';

        }
        $map = array();
        if (!empty($map1)) {
            array_push($map, $map1);
        }

        if (!empty($map2)) {
            array_push($map, $map2);
        }

        if (!empty($map)) {
            $where['_complex'] = array($map);
        }

用法二

		if (!empty($name = I('name'))) {
			$string[] = "user.name Like '%{$name}%' or user.hl_name = ".Crypt::encrypt($name, 'HL');
           
        }
        if (!empty($tel = I('tel'))) {
        	$string[] = "user.tel = {$tel} or user.hl_tel = {$tel}";
        }
        if (!empty($promote_platform = I('promote_platform'))) {
        	$string[] = "promote.parent_id = {$promote_platform} or promote.parentid_list like '{$promote_platform},%'"
        }
      
        if ($string) {
           $where['_string'] = implode(' and ', $string);
        }