publicvoidindex(){
//数据可见受限
//if(getCurrentUser()==null){
//toDwzJson(300,"登录超时,请重新登录!",navTabId);
//return;
//}
StringBufferselect=newStringBuffer("");
StringBufferwhere=newStringBuffer("");
Listparam=newArrayList();
select.append("select");
select.append("count(t1.loan_application_code)as申请单数,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoint_groupt2");
select.append("ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='普陀贷款总公司'");
select.append(")as普陀贷款总公司,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='浦东贷款分公司'");
select.append(")as浦东贷款分公司申请,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoint_groupt2on");
select.append("t1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='黄浦贷款分公司'");
select.append(")as黄浦贷款分公司申请,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoint_groupt2on");
select.append("t1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='徐汇贷款分公司'");
select.append(")as黄浦贷款分公司,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("wheret1.`status`='通过'");
select.append(")as通过单数,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='普陀贷款总公司'");
select.append("andt1.`status`='通过'");
select.append(")as普陀贷款总公司通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='浦东贷款分公司'");
select.append("andt1.`status`='通过'");
select.append(")as浦东贷款分公司通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='黄浦贷款分公司'");
select.append("andt1.`status`='通过'");
select.append(")as黄浦贷款分公司通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='徐汇贷款分公司'");
select.append("andt1.`status`='通过'");
select.append(")as徐汇贷款分公司通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("wheret1.`status`='不通过'");
select.append(")as不通过单数,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='普陀贷款总公司'");
select.append("andt1.`status`='不通过'");
select.append(")as普陀贷款总公司不通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='浦东贷款分公司'");
select.append("andt1.`status`='不通过'");
select.append(")as浦东贷款分公司不通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='黄浦贷款分公司'");
select.append("andt1.`status`='不通过'");
select.append(")as黄浦贷款分公司不通过,");
select.append("(select");
select.append("count(t1.loan_application_code)");
select.append("from");
select.append("t_al_loan_applicationt1");
select.append("leftjoin");
select.append("t_groupt2ont1.control_unit_id=t2.group_id");
select.append("wheret2.group_name='徐汇贷款分公司'");
select.append("andt1.`status`='不通过'");
select.append(")as徐汇贷款分公司不通过");
StringfromDate=getPara("from_date");
StringtoDate=getPara("to_date");
where.append("from");
where.append("t_al_loan_applicationt1");
where.append("where");
if(fromDate!=null&&"".equals(fromDate.trim())){
where.append("t1.loan_application_date>=?");
param.add(fromDate.trim());
}
if(toDate!=null&&!"".equals(toDate.trim())){
where.append("andt1.loan_application_date --> |