bgycoding

　　

//add by zzw@曾志伟 2015-12-9 【碧桂园项目】 begin
            if(condition.indexOf("glbdef8 = 'Y'")>0){                
                String mySql = "SELECT HVP.PK_PSNDOC" +
                        "                            FROM HRVM_VIRTUALPSN HVP," +
                        "                            HRVM_VIRTUALORG HVO," +
                        "                            HRVM_VIRTUALTYPE HVT" +
                        "                            WHERE 1 = 1" +
                        "                            AND HVP.PK_VIRTUALORG = HVO.PK_VIRTUALORG" +
                        "                            AND HVO.PK_VIRTUALTYPE = HVT.PK_VIRTUALTYPE" +
                        "                            AND HVT.TYPENAME = '碧业生'";
                Object obj = getQryService().queryBySql_retArray(mySql);
                if (obj != null) {
                    ArrayList<String> mypk = (ArrayList<String>) obj;
                    for(String mypk_child:mypk){
                        AggEvaObjectVO[] obj_agg=(AggEvaObjectVO[]) ((EvaObjectAppModel) this.getModel()).getData().toArray(new AggEvaObjectVO[0]);
                        for(Object obj_a_child:obj_agg){
                            String obj1= ((EvaObjectVO) ((AggEvaObjectVO) obj_a_child).getParentVO()).getPk_psndoc();
                            /**
                             * 查询虚拟组织的碧业生的信息（人员编码）（下图为虚拟组织），
                             * 与绩效管理-【人员设置】选定方案中现有人员的信息（人员编码）对比，
                             * 如果有相同人员
                             */
                            if(mypk_child.equals(obj1)){
                                String pk_psndoc=obj1;
                                //Calendar a=Calendar.getInstance();
                                //String year="bgy"+a.get(Calendar.YEAR);// HVO.CODE='bgy2015'
                                //String mySql1="";
                                /*condition += " and (" + EvaObjectVO.PK_EVA_GROUP + " = '"
                                        + evaGroupPK + "')";*/
                                String mySql_re = "SELECT HVP.PK_PSNDOC" +
                                        "                            FROM HRVM_VIRTUALPSN HVP," +
                                        "                            HRVM_VIRTUALORG HVO," +
                                        "                            HRVM_VIRTUALTYPE HVT" +
                                        "                            WHERE 1 = 1" +
                                        "                            AND HVP.PK_VIRTUALORG = HVO.PK_VIRTUALORG" +
                                        "                            AND HVO.PK_VIRTUALTYPE = HVT.PK_VIRTUALTYPE" +
                                        "                            AND HVT.TYPENAME = '碧业生'" +
                                        "                            AND SUBSTR(HVO.CODE,4)='2016'";
                                Object obj_re = getQryService().queryBySql_retArray(mySql);
                                if (obj != null) {
                                    ArrayList<String> mypk_re = (ArrayList<String>) obj_re;
                                    StringBuffer mybuf_re = new StringBuffer();
                                    mybuf_re.append("(");
                                    for (String mystr_re : mypk_re) {
                                        if (mystr_re != null) {
                                            mystr_re = "'" + mystr_re + "',";
                                            mybuf_re.append(mystr_re);
                                        }
                                    }                                    
                                    res_re = mybuf_re.substring(0, mybuf_re.length() - 1);
                                    res_re = res_re + ")";
                                    System.out.println();
                                }
                                res_re = "pk_psndoc  in " + res_re;
                                String replaceStr = "glbdef8 = 'Y'";
                                condition = condition.replace(replaceStr, res);
                            }
                        }                        
                    }
                }

                //AggEvaObjectVO[] obj=(AggEvaObjectVO[]) ((EvaObjectAppModel) this.getModel()).getData().toArray(new AggEvaObjectVO[0]);                 
                
                //String obj1= ((EvaObjectVO) obj[1].getParentVO()).getPk_psndoc();
            }
            if(condition.indexOf("glbdef8 = 'N'")>0){
                
            }            
            //add by zzw@曾志伟 2015-12-9 【碧桂园项目】 end