| | |
|---|
| | | .selectAs(Company::getName,UnionChange::getShopName) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 0 )",UnionChange::getAddNum) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 1 )",UnionChange::getDelNum) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 2 )",UnionChange::getChangeNum) |
|---|
| | | .select("( select count(1) from apply_chagne_detail ad where t.id = ad.UNION_CHANGE_ID and ad.TYPE = 2 )",UnionChange::getChangeNum).select("( select ifnull(sum(ac.FEE),0) from apply_change ac where t.id = ac.UNION_CHANGE_ID )",UnionChange::getFee) |
|---|
| | | .leftJoin(UnionApply.class,UnionApply::getId,UnionChange::getUnionApplyId) |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,UnionChange::getShopId) |
|---|
