ItogKolpas = ItogKolpas + rs.getLong(6)-rs.getLong(10);

ItogKolpasMin = rs.getLong(6)- rs.getLong(10) + ItogKolpasMin;

vc.setMkolpas(integerFormat(rs.getLong(7)-rs.getLong(11)));

ItogMkolpas = ItogMkolpas + rs.getLong(7)-rs.getLong(11);

ItogMkolpasMin = rs.getLong(7)- rs.getLong(11) + ItogMkolpasMin;

vc.setSumpr(MainFormat(rs.getLong(8), mkoef));

ItogSumpr = ItogSumpr + rs.getLong(8);

ItogSumprMin = rs.getLong(8) + ItogSumprMin;

vc.setMsumpr(MainFormat(rs.getLong(9), mkoef));

ItogMsumpr = ItogMsumpr + rs.getLong(9);

ItogMsumprMin = ItogMsumprMin + rs.getLong(9);

vc.setKolpr(integerFormat(rs.getLong(10)));

ItogKolpr = ItogKolpr + rs.getLong(10);

ItogKolprMin = ItogKolprMin + rs.getLong(10);

vc.setMkolpr(integerFormat(rs.getLong(11)));

ItogMkolpr = ItogMkolpr + rs.getLong(11);

ItogMkolprMin = ItogMkolprMin + rs.getLong(11);

vc.setSumbag(MainFormat(rs.getLong(12), mkoef));

ItogSumbag = ItogSumbag + rs.getLong(12);

ItogSumbagMin = ItogSumbagMin + rs.getLong(12);

vc.setMsumbag(MainFormat(rs.getLong(13), mkoef));

ItogMsumbag = ItogMsumbag + rs.getLong(13);

ItogMsumbagMin = ItogMsumbagMin + rs.getLong(13);

vc.setKolbag(integerFormat(rs.getLong(14)));

ItogKolbag = ItogKolbag + rs.getLong(14);

ItogKolbagMin = ItogKolbagMin + rs.getLong(14);

vc.setMkolbag(integerFormat(rs.getLong(15)));

ItogMkolbag = ItogMkolbag + rs.getLong(15);

ItogMkolbagMin = ItogMkolbagMin + rs.getLong(15);

vc.setKomsbv(MainFormat(rs.getLong(16), mkoef));

ItogKomsbv = ItogKomsbv + rs.getLong(16);

ItogKomsbvMin = ItogKomsbvMin + rs.getLong(16);

vc.setMkomsbv(MainFormat(rs.getLong(17), mkoef));

ItogMkomsbv = ItogMkomsbv + rs.getLong(17);

ItogMkomsbvMin = ItogKomsbvMin + rs.getLong(17);

vc.setKolv(integerFormat(rs.getLong(18)));

ItogKolv = ItogKolv + rs.getLong(18);

ItogKolvMin = ItogKolvMin + rs.getLong(18);

vc.setMkolv(integerFormat(rs.getLong(19)));

ItogMkolv = ItogMkolv + rs.getLong(19);

ItogMkolvMin = ItogMkolvMin + rs.getLong(19);

tableRows.add(vc);

row_min++;

}

if(agent.equals("**"))

AgentFirst = rs.getString(2);

if(per.equals("**"))

PerFirst = rs.getString(2);

}

// ===

if ((ob_minNo[j]!= null) && (!obName.equals("")) && (chek_str) && (Long.parseLong(obName)<Long.parseLong(ob_minNo[j]))){

while(ob_minNo[j]!=null){

vc = new VoinClass();

if(min.equals("*")){

vc.setMin_name(ob_minName[j]);

}

else

vc.setMin_name("");

vc.setMin(ob_minNo[j]);

if (agent.equals("**")){

vc.setAgent_name(ob_name_agent);

vc.setAgent(ob_agent);

vc.setPer("");

vc.setPer_name("");

}

if (per.equals("**")){

vc.setPer_name(ob_name_per);

vc.setPer(ob_per);

vc.setAgent("");

vc.setAgent_name("");

}

vc.setOplata("0");

vc.setMoplata("0");

vc.setSumpd("0");

ItogSumpdS=Long.toString(ItogSumpd);

vc.setMsumpd("0");

vc.setKolpas("0");

vc.setMkolpas("0");

vc.setSumpr("0");

vc.setMsumpr("0");

vc.setKolpr("0");

vc.setMkolpr("0");

vc.setSumbag("0");

vc.setMsumbag("0");

vc.setKolbag("0");

vc.setMkolbag("0");

vc.setKomsbv("0");

vc.setMkomsbv("0");

vc.setKolv("0");

vc.setMkolv("0");

tableRows.add(vc);

j++;

kol++;

schet_rows = Long.toString(kol);

}

}

//===

if (min_query.equals("ЛЮБОЙ") && (!ItogSumpdS.equals("x"))) {

vc = new VoinClass();

vc.setMin_name("");

vc.setAgent("");

vc.setAgent_name("");

vc.setPer("");

vc.setPer_name("");

vc.setMin("ИТОГО");

vc.setOplata(MainFormat(ItogOplata, mkoef));

SetItogOplata = SetItogOplata + ItogOplata;

vc.setMoplata(MainFormat(ItogMoplata, mkoef));

SetItogMoplata = SetItogMoplata + ItogMoplata;

vc.setSumpd(MainFormat(ItogSumpd, mkoef));

SetItogSumpd = SetItogSumpd + ItogSumpd;

vc.setMsumpd(MainFormat(ItogMsumpd, mkoef));

SetItogMsumpd = SetItogMsumpd + ItogMsumpd;

vc.setKolpas(integerFormat(ItogKolpas));

SetItogKolpas = SetItogKolpas + ItogKolpas;

vc.setMkolpas(integerFormat(ItogMkolpas));

SetItogMkolpas = SetItogMkolpas + ItogMkolpas;

vc.setSumpr(MainFormat(ItogSumpr, mkoef));

SetItogSumpr = SetItogSumpr + ItogSumpr;

vc.setMsumpr(MainFormat(ItogMsumpr, mkoef));

SetItogMsumpr = SetItogMsumpr + ItogMsumpr;

vc.setKolpr(integerFormat(ItogKolpr));

SetItogKolpr = SetItogKolpr + ItogKolpr;

vc.setMkolpr(integerFormat(ItogMkolpr));

SetItogMkolpr = SetItogMkolpr + ItogMkolpr;

vc.setSumbag(MainFormat(ItogSumbag, mkoef));

SetItogSumbag = SetItogSumbag + ItogSumbag;

vc.setMsumbag(MainFormat(ItogMsumbag, mkoef));

SetItogMsumbag = SetItogMsumbag + ItogMsumbag;

vc.setKolbag(integerFormat(ItogKolbag));

SetItogKolbag = SetItogKolbag + ItogKolbag;

vc.setMkolbag(integerFormat(ItogMkolbag));

SetItogMkolbag = SetItogMkolbag + ItogMkolbag;

vc.setKomsbv(MainFormat(ItogKomsbv, mkoef));

SetItogKomsbv = SetItogKomsbv + ItogKomsbv;

vc.setMkomsbv(MainFormat(ItogMkomsbv, mkoef));

SetItogMkomsbv = SetItogMkomsbv + ItogMkomsbv;

vc.setKolv(integerFormat(ItogKolv));

SetItogKolv = SetItogKolv + ItogKolv;

vc.setMkolv(integerFormat(ItogMkolv));

SetItogMkolv = SetItogMkolv + ItogMkolv;

tableRows.add(vc);

kol++;

schet_rows = Long.toString(kol);

}

//===================

if(!min_query.equals("ЛЮБОЙ")&&(row_min>1)&&(!ItogSumpdS.equals("x")))

{

vc = new VoinClass();

vc.setMin_name("");

if(agent.equals("**")){

vc.setAgent("");

vc.setAgent_name("ВСЕГО");

vc.setPer("");

vc.setPer_name("");

}

if (per.equals("**"))

{

vc.setPer("");

vc.setPer_name("ВСЕГО");

vc.setAgent("");

vc.setAgent_name("");

}

vc.setMin("");

vc.setOplata(MainFormat(ItogOplataMin, mkoef));

vc.setMoplata(MainFormat(ItogMoplataMin, mkoef));

vc.setSumpd(MainFormat(ItogSumpdMin, mkoef));

vc.setMsumpd(MainFormat(ItogMsumpdMin, mkoef));

vc.setKolpas(integerFormat(ItogKolpasMin));

vc.setMkolpas(integerFormat(ItogMkolpasMin));

vc.setSumpr(MainFormat(ItogSumprMin, mkoef));

vc.setMsumpr(MainFormat(ItogMsumprMin, mkoef));

vc.setKolpr(integerFormat(ItogKolprMin));

vc.setMkolpr(integerFormat(ItogMkolprMin));

vc.setSumbag(MainFormat(ItogSumbagMin, mkoef));

vc.setMsumbag(MainFormat(ItogMsumbagMin, mkoef));

vc.setKolbag(integerFormat(ItogKolbagMin));

vc.setMkolbag(integerFormat(ItogMkolbagMin));

vc.setKomsbv(MainFormat(ItogKomsbvMin, mkoef));

vc.setMkomsbv(MainFormat(ItogMkomsbvMin, mkoef));

vc.setKolv(integerFormat(ItogKolvMin));

vc.setMkolv(integerFormat(ItogMkolvMin));

tableRows.add(vc);

}

//==ИТОГОВАЯ СУММА ПО ДОРОГЕ ПО НЕСКОЛЬКИМ АГЕНТАМ==============

if ((min_query.equals("ЛЮБОЙ")) && (!AgentFirst.equals(FirstAgent)) && agent.equals("**")) {

set_vc = new VoinClass();

set_vc.setMin_name("");

set_vc.setAgent("");

set_vc.setAgent_name("");

set_vc.setPer("");

set_vc.setPer_name("");

set_vc.setMin("ВСЕГО");

set_vc.setOplata(MainFormat(SetItogOplata, mkoef));

set_vc.setMoplata(MainFormat(SetItogMoplata, mkoef));

set_vc.setSumpd(MainFormat(SetItogSumpd, mkoef));

set_vc.setMsumpd(MainFormat(SetItogMsumpd, mkoef));

set_vc.setKolpas(integerFormat(SetItogKolpas));

set_vc.setMkolpas(integerFormat(SetItogMkolpas));

set_vc.setSumpr(MainFormat(SetItogSumpr, mkoef));

set_vc.setMsumpr(MainFormat(SetItogMsumpr, mkoef));

set_vc.setKolpr(integerFormat(SetItogKolpr));

set_vc.setMkolpr(integerFormat(SetItogMkolpr));

set_vc.setSumbag(MainFormat(SetItogSumbag, mkoef));

set_vc.setMsumbag(MainFormat(SetItogMsumbag, mkoef));

set_vc.setKolbag(integerFormat(SetItogKolbag));

set_vc.setMkolbag(integerFormat(SetItogMkolbag));

set_vc.setKomsbv(MainFormat(SetItogKomsbv, mkoef));

set_vc.setMkomsbv(MainFormat(SetItogMkomsbv, mkoef));

set_vc.setKolv(integerFormat(SetItogKolv));

set_vc.setMkolv(integerFormat(SetItogMkolv));

tableRowsSet.add(set_vc);

}

// ==ИТОГОВАЯ СУММА ПО ДОРОГЕ ПО НЕСКОЛЬКИМ Перевозчикам==============

if ((min_query.equals("ЛЮБОЙ")) && (!PerFirst.equals(FirstPer)) && per.equals("**")) {

set_vc = new VoinClass();

set_vc.setMin_name("");

set_vc.setAgent("");

set_vc.setAgent_name("");

set_vc.setPer("");

set_vc.setPer_name("");

set_vc.setMin("ВСЕГО");

set_vc.setOplata(MainFormat(SetItogOplata, mkoef));

set_vc.setMoplata(MainFormat(SetItogMoplata, mkoef));

set_vc.setSumpd(MainFormat(SetItogSumpd, mkoef));

set_vc.setMsumpd(MainFormat(SetItogMsumpd, mkoef));

set_vc.setKolpas(integerFormat(SetItogKolpas));

set_vc.setMkolpas(integerFormat(SetItogMkolpas));

set_vc.setSumpr(MainFormat(SetItogSumpr, mkoef));

set_vc.setMsumpr(MainFormat(SetItogMsumpr, mkoef));

set_vc.setKolpr(integerFormat(SetItogKolpr));

set_vc.setMkolpr(integerFormat(SetItogMkolpr));

set_vc.setSumbag(MainFormat(SetItogSumbag, mkoef));

set_vc.setMsumbag(MainFormat(SetItogMsumbag, mkoef));

set_vc.setKolbag(integerFormat(SetItogKolbag));

set_vc.setMkolbag(integerFormat(SetItogMkolbag));

set_vc.setKomsbv(MainFormat(SetItogKomsbv, mkoef));

set_vc.setMkomsbv(MainFormat(SetItogMkomsbv, mkoef));

set_vc.setKolv(integerFormat(SetItogKolv));

set_vc.setMkolv(integerFormat(SetItogMkolv));

tableRowsSet.add(set_vc);

}

}

}

//=============

if (ust.equals("all_set")){

param_dor = "all_set";

}

if (ust.equals("*")){

param_dor = "*";

}

//// ========min==========

if (!min_query.equals("ЛЮБОЙ")){

String str = " SELECT DISTINCT NAME, NOMMV FROM EXPBD.LGOT, EXPBD.SERV S WHERE " +

" NOMMV = ? AND ";

if(!data.equals("fdat") && !data.equals("f_month")){

str +=" DATAN<='" +dohod_data+ "' AND DATAOT>='" +dohod_data+ "' ";

}

else {

str +=" DATAN<='" +data_end+ "' AND DATAOT>='" +data_end+ "' ";

}

str +=" AND GOS=S.GOS_ABD ";

int schet_min = 1;

pstmt_name = connec.prepareStatement(str);

pstmt_name.setString(schet_min++,min.toString());

rs_name = pstmt_name.executeQuery();

while (rs_name.next()) {

min_query = rs_name.getString(1);

}

rs_name.close();

pstmt_name.close();

}

// ========agent------

if (!agent_query.equals("ЛЮБОЙ") && agent.equals("0")){

String str = " SELECT DISTINCT A.MNKODP, A.SKP FROM DBKLAS.SOBPER A, EXPBD.SERV S " +" WHERE A.SKP = ? AND ";

if(!data.equals("fdat") && !data.equals("f_month")){

str += " A.DATANO<='" +dohod_data+ "' AND A.DATAKO>='" +dohod_data+ "' AND " +

" A.DATANP<='" +dohod_data+ "' AND A.DATAKP>='" +dohod_data+ "' ";

}

else {

str += " A.DATANO<='" +data_end+ "' AND A.DATAKO>='" +data_end+ "' AND " +

" A.DATANP<='" +data_end+ "' AND A.DATAKP>='" +data_end+ "' ";

}

str +=" AND A.GOS = S.GOS_ABD ";

int schet_agent = 1;

pstmt_name = connec.prepareStatement(str);

pstmt_name.setString(schet_agent++,agent.toString());

rs_name = pstmt_name.executeQuery();

while (rs_name.next()) {

agent_query = rs_name.getString(1);

}

rs_name.close();

pstmt_name.close();

}

// =====perevoz=====

if (!per_query.equals("ЛЮБОЙ") && per.equals("0")){

String str = " SELECT DISTINCT A.MNKODP, A.SKP FROM DBKLAS.SOBPER A, EXPBD.SERV S " +" WHERE A.SKP = ? AND ";

if(!data.equals("fdat") && !data.equals("f_month")){

str +=" A.DATANO<='" +dohod_data+ "' AND A.DATAKO>='" +dohod_data+ "' AND " +

" A.DATANP<='" +dohod_data+ "' AND A.DATAKP>='" +dohod_data+ "' ";

}

else {

str +=" A.DATANO<='" +data_end+ "' AND A.DATAKO>='" +data_end+ "' AND " +

" A.DATANP<='" +data_end+ "' AND A.DATAKP>='" +data_end+ "' ";

}

str += " AND A.GOS = S.GOS_ABD ";

int schet_per = 1;

pstmt_name = connec.prepareStatement(str);

pstmt_name.setString(schet_per++,per.toString());

rs_name = pstmt_name.executeQuery();

while (rs_name.next()) {

per_query = rs_name.getString(1);

}

rs_name.close();

pstmt_name.close();

}

//======dor_query=========

if (!ust.equals("all_set") && (!dor.equals("*"))) {

String str = "SELECT DISTINCT NAZVD FROM EXPBD.DOR WHERE ";

if(!data.equals("fdat") && !data.equals("f_month")){

str +=" DATAN<= '" +dohod_data+ "' AND DATAK>= '" +dohod_data+ "' AND KODD =? ";

}else{

str +=" DATAN<= '" +data_end+ "' AND DATAK>= '" +data_end+ "' AND KODD =? ";

}

int schet_dor = 1;

pstmt_name = connec.prepareStatement(str);

pstmt_name.setString(schet_dor++, dor_query.toString());

rs_name = pstmt_name.executeQuery();

while (rs_name.next()) {

dor_query = rs_name.getString(1);

}

rs_name.close();

pstmt_name.close();

}

//=====================

if (!session.isNew()){

session.removeAttribute("tableRows");

session.removeAttribute("tableRowsSet");

session.removeAttribute("dor");

session.removeAttribute("min_name");

session.removeAttribute("min");

session.removeAttribute("per");

session.removeAttribute("nazvd");

session.removeAttribute("sumpd");

session.removeAttribute("msumpd");

session.removeAttribute("kolpas");

session.removeAttribute("mkolpas");

session.removeAttribute("sumpr");

session.removeAttribute("msumpr");

session.removeAttribute("kolpr");

session.removeAttribute("mkolpr");

session.removeAttribute("sumbag");

session.removeAttribute("msumbag");

session.removeAttribute("kolbag");

session.removeAttribute("mkolbag");

session.removeAttribute("komsbv");

session.removeAttribute("mkomsbv");

session.removeAttribute("kolv");

session.removeAttribute("mkolv");

session.removeAttribute("FirstDor");

session.removeAttribute("schet_rows");

session.removeAttribute("schet_row_dors");

session.removeAttribute("ItogSumpdS");

session.removeAttribute("NazvFirstDor");

session.removeAttribute("DorFirst");

session.removeAttribute("AgentFirst");

session.removeAttribute("FirstAgent");

session.removeAttribute("PerFirst");

session.removeAttribute("FirstPer");

session.removeAttribute("schet_data");

session.removeAttribute("schet_dataAll");

session.removeAttribute("data_begin");

session.removeAttribute("data_end");

session.removeAttribute("begin_data");

session.removeAttribute("end_data");

//============================

session.removeAttribute("tableRowsAll");

session.removeAttribute("ItogSumpdAllS");

session.removeAttribute("min_query");

session.removeAttribute("per_query");

session.removeAttribute("agent_query");

//===================

session.removeAttribute("param_dor");

session.removeAttribute("dor_query");

session.removeAttribute("agent");

session.removeAttribute("nazvl");

session.removeAttribute("FirstAgent_name");

session.removeAttribute("FirstPer_name");

session.removeAttribute("agent_name");

session.removeAttribute("per_name");

session.removeAttribute("ust");

session.removeAttribute("month_period");

session.removeAttribute("year_period");

}

//============================

session.setAttribute("dor",dor);

session.setAttribute("min_name", min_name);

session.setAttribute("min",min);

session.setAttribute("nazvd",nazvd);

session.setAttribute("oplata",oplata);

session.setAttribute("moplata", moplata);

session.setAttribute("sumpd",sumpd);

session.setAttribute("msumpd", msumpd);

session.setAttribute("kolpas", kolpas);

session.setAttribute("mkolpas", mkolpas);

session.setAttribute("sumpr", sumpr);

session.setAttribute("msumpr", msumpr);

session.setAttribute("kolpr",kolpr);

session.setAttribute("mkolpr", mkolpr);

session.setAttribute("sumbag",sumbag);

session.setAttribute("msumbag", msumbag);

session.setAttribute("kolbag", kolbag);

session.setAttribute("mkolbag", mkolbag);

session.setAttribute("komsbv", komsbv);

session.setAttribute("mkomsbv", mkomsbv);

session.setAttribute("kolv", kolv);

session.setAttribute("mkolv", mkolv);

session.setAttribute("FirstDor", FirstDor);

session.setAttribute("schet_rows", schet_rows);

session.setAttribute("schet_row_dors", schet_row_dors);

session.setAttribute("schet_data", schet_data);

session.setAttribute("schet_dataAll", schet_dataAll);

session.setAttribute("data_begin", data_begin);

session.setAttribute("data_end", data_end);

session.setAttribute("begin_data", begin_data);

session.setAttribute("end_data", end_data);

session.setAttribute("DorFirst", DorFirst);

session.setAttribute("NazvFirstDor", NazvFirstDor);

ItogSumpdS=Long.toString(ItogSumpd);

session.setAttribute("ItogSumpdS", ItogSumpdS);

session.setAttribute("tableRows", tableRows);

session.setAttribute("tableRowsAll",tableRowsAll);

session.setAttribute("tableRowsSet",tableRowsSet);

session.setAttribute("ItogSumpdAllS", ItogSumpdAllS);

session.setAttribute("min_query", min_query);

session.setAttribute("agent_query", agent_query);

session.setAttribute("agent", agent);

session.setAttribute("per_query", per_query);

session.setAttribute("per", per);

session.setAttribute("AgentFirst", AgentFirst );

session.setAttribute("FirstAgent", FirstAgent);

session.setAttribute("FirstAgent_name", FirstAgent_name);

session.setAttribute("agent_name", agent_name);

session.setAttribute("PerFirst", PerFirst );

session.setAttribute("FirstPer", FirstPer);

session.setAttribute("FirstPer_name", FirstPer_name);

session.setAttribute("per_name", per_name);

//-===========================

session.setAttribute("param_dor", param_dor);

session.setAttribute("dor_query", dor_query);

session.setAttribute("nazvl", nazvl);

session.setAttribute("ust", ust);

session.setAttribute("month_period", month_period);

session.setAttribute("year_period", year_period);

}

catch (SQLException e) {

// Report the error using the appropriate name and ID.

errors.add("errorDB2", new ActionError("error.errorDB2", e.getMessage()));

}

catch (Exception e) {

if (errors.isEmpty())

errors.add("Exception", new ActionError("error.Exception", e.getMessage()));

e.printStackTrace();

}

finally {

try {

if (rs != null) {

rs.close();

}

if (pstmt != null) {

pstmt.close();

}

if (rsAll != null) {

rsAll.close();

}

if (pstmtAll != null) {

pstmtAll.close();

}

if (rs_name != null) {

rs_name.close();

}

if (pstmt_name != null) {

pstmt_name.close();

}

if (rs_min != null) {

rs_min.close();

}

if (pstmt_min != null) {

pstmt_min.close();

}

jdbcConnection.releaseConnection();

} catch (SQLException e1) {

if (rs != null) {

rs.close();

}

if (pstmt != null) {

pstmt.close();

}

if (rsAll != null) {

rsAll.close();

}

if (pstmtAll != null) {

pstmtAll.close();

}

if (rs_name != null) {

rs_name.close();

}

if (pstmt_name != null) {

pstmt_name.close();

}

if (rs_min != null) {

rs_min.close();

}

if (pstmt_min != null) {

pstmt_min.close();

}

throw e1;

}

}

String ust = armvoinForm.getUst();

String dor = armvoinForm.getDor();

String agent = armvoinForm.getAgent();

String per = armvoinForm.getPer();

String data = armvoinForm.getData();

String min = armvoinForm.getMin();

boolean chek_str = armvoinForm.getChek_str();

//=========agent=====

String [] temp = null;

temp = agent.split("--");

agent = temp[0];

//=======per==========

temp = null;

temp = per.split("--");

per = temp[0];

//======Dor===========

if (!ust.equals("all_set")){

temp=null;

temp = dor.split("--");

dor = temp[0];

}

//====Min==========

temp = null;

temp = min.split("--");

min = temp[0];

//=============

if (!errors.isEmpty()) {

saveErrors(request, errors);

forward = mapping.findForward("failure");

}

else {

if ((ust.equals("dor")) && (dor.equals("*")) && (!agent.equals("**")) && (!per.equals("**")) && (!data.equals("fdat")) &&(!data.equals("f_month")))

{

if(!chek_str){

forward = mapping.findForward("success1");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success1");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

else if ((!agent.equals("**")) && (!per.equals("**")) && (!data.equals("fdat")) &&(!data.equals("f_month")))

{

if(!chek_str){

forward = mapping.findForward("success");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((ust.equals("dor")) && (dor.equals("*")))

{

if (((agent.equals("**") || (per.equals("**")))) && (!data.equals("fdat")) &&(!data.equals("f_month")))

{

if(!chek_str){

forward = mapping.findForward("success_det_dor");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success_det_dor");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((agent.equals("**") && (per.equals("**"))))

forward = mapping.findForward("success_det_not");

}

if ((ust.equals("dor")) && (!dor.equals("*")) && (!data.equals("fdat")) &&(!data.equals("f_month"))&& ((agent.equals("**")) || (per.equals("**"))))

{

if(!chek_str){

forward = mapping.findForward("success_det_dor");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success_det_dor");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((ust.equals("all_set")) && (((agent.equals("**")) || (per.equals("**"))))){

forward = mapping.findForward("success_det_not");

}

if (agent.equals("**")&&(per.equals("**"))) {

forward = mapping.findForward("success_det_not");

}

//=======fdat && f_month======

if ((ust.equals("dor")) && (dor.equals("*")) && (!agent.equals("**")) && (!per.equals("**")) && ((data.equals("fdat")) || (data.equals("f_month"))))

{

if(!chek_str){

forward = mapping.findForward("success1_f");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success1_f");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

else if ((!agent.equals("**")) && (!per.equals("**")) && ((data.equals("fdat")) ||(data.equals("f_month"))))

{

if(!chek_str){

forward = mapping.findForward("success_f");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success_f");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((ust.equals("dor")) && (dor.equals("*")))

{

if (((agent.equals("**") || (per.equals("**")))) && ((data.equals("fdat")) || (data.equals("f_month"))))

{

if(!chek_str){

forward = mapping.findForward("success_det_dor_f");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success_det_dor_f");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((agent.equals("**") && (per.equals("**"))))

forward = mapping.findForward("success_det_not");

}

if ((ust.equals("dor")) && (!dor.equals("*")) && ((data.equals("fdat")) || (data.equals("f_month")))&& ((agent.equals("**")) || (per.equals("**"))))

{

if(!chek_str){

forward = mapping.findForward("success_det_dor_f");

}

if((chek_str) && (min.equals("*"))){

forward = mapping.findForward("success_det_dor_f");

}

if((chek_str) && (!min.equals("*"))){

forward = mapping.findForward("success_not_null_str");

}

}

if ((ust.equals("all_set")) && (((agent.equals("**")) || (per.equals("**"))))){

forward = mapping.findForward("success_det_not");

}

if (agent.equals("**")&&(per.equals("**"))) {

forward = mapping.findForward("success_det_not");

}

}

return (forward);

}

private String integerFormat(double decim){

DecimalFormatSymbols dfs=null;

DecimalFormat df=new DecimalFormat("#,##0;#,##0");

df.setGroupingSize(3);

df.setGroupingUsed(true);

dfs=df.getDecimalFormatSymbols();

dfs.setGroupingSeparator(' ');

df.setDecimalFormatSymbols(dfs);

return df.format(decim);

}

private String MainFormat (long decim, int mkoef){

String decim_str = "";

int valut = 10;

if (mkoef == 100)

valut = 1;

if (mkoef == 1 || (mkoef != 1 && mkoef != 10 && mkoef != 100))

valut = 100;

long dec = Math.abs(decim / valut);

long dec_mod = Math.abs(decim % valut);

long dec_dec_mod = Math.abs(dec_mod / 10);

long dec_mod_mod = Math.abs (dec_mod %10);

DecimalFormatSymbols dfs=null;

DecimalFormat df=new DecimalFormat("#,##0;#,##0");

df.setGroupingSize(3);

df.setGroupingUsed(true);

dfs=df.getDecimalFormatSymbols();

dfs.setGroupingSeparator(' ');

df.setDecimalFormatSymbols(dfs);

decim_str = df.format(dec);

if (decim < 0)

decim_str = "-" +decim_str;

if (dec_mod !=0 && valut == 10)

decim_str = decim_str + "." + (long)(dec_mod);

if (dec_mod != 0 && dec_mod>9 && valut==100 && dec_mod_mod !=0)

decim_str = decim_str + "." + (long)(dec_mod);

if (dec_mod != 0 && dec_mod>9 && valut==100 && dec_mod_mod ==0 )

decim_str = decim_str + "." + (long)(dec_dec_mod);

if (dec_mod !=0 && dec_mod<10 && valut == 100)

decim_str = decim_str +".0" + (long)(dec_mod);

return decim_str;

}

}

index2.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>

<%@ page import="voin.Classes.*, java.util.*" %>

<%@page language="java" contentType="text/html; charset=Windows-1251"

pageEncoding="Windows-1251"%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=Windows-1251">

<META name="GENERATOR" content="IBM Software Development Platform">

<META http-equiv="Content-Style-Type" content="text/css">

<LINK href="theme/Master.css" rel="stylesheet" type="text/css">

<title>Кредитовые ведомства</title>

</HEAD>

<script language="JavaScript">

function doSendEx() {

var newWindowEx;

if (!newWindowEx || newWindowEx.closed) {

var props = 'scrollBars=yes,resizable=yes,toolbar=yes,menubar=yes,location=no,directories=no,width=550,height=550';

newWindowEx = window.open("/dohodv/index2Ex.jsp","Excel",props);

}

}

</script>

<%

String dor = "";

String min = "";

String per = "";

String a = "";

String b = "";

String FirstDor = "";

String schet_rows = "0";

String schet_data = "";

String NazvFirstDor = "";

String ItogSumpdS ="";

String ItogMsumpdS = "";

String ItogKolpasS = "";

String ItogMkolpasS = "";

String ItogSumprS = "";

String ItogMsumprS = "";

String ItogKolprS = "";

String ItogMkolprS = "";

String ItogSumbagS = "";

String ItogMsumbagS = "";

String ItogKolbagS = "";

String ItogMkolbagS = "";

String ItogKomsbvS = "";

String ItogMkomsbvS = "";

String ItogKolvS = "";

String ItogMkolvS = "";

String ItogSumpdMinS ="";

String ItogMsumpdMinS = "";

String ItogKolpasMinS = "";

String ItogMkolpasMinS = "";

String ItogSumprMinS = "";

String ItogMsumprMinS = "";

String ItogKolprMinS = "";

String ItogMkolprMinS = "";

String ItogSumbagMinS = "";

String ItogMsumbagMinS = "";

String ItogKolbagMinS = "";

String ItogMkolbagMinS = "";

String ItogKomsbvMinS = "";

String ItogMkomsbvMinS = "";

String ItogKolvMinS = "";

String ItogMkolvMinS = "";

String DorFirst = "";

String agent_query = "";

String per_query = "";

String min_query = "";

String min_name = "";

String param_dor = "";

String dor_query = "";

String nazvl = "";

String schet_row_dors ="0";

String ust = "";

int countRows=((ArrayList)session.getAttribute("tableRows")).size();

dor = (String)session.getAttribute("dor");

min = (String)session.getAttribute("min");

per = (String)session.getAttribute("per");

FirstDor = (String)session.getAttribute("FirstDor");

schet_rows = (String)session.getAttribute("schet_rows");

schet_row_dors = (String)session.getAttribute("schet_row_dors");

DorFirst = (String)session.getAttribute("DorFirst");

NazvFirstDor = (String)session.getAttribute("NazvFirstDor");

ItogSumpdS = (String)session.getAttribute("ItogSumpdS");

ItogMsumpdS = (String)session.getAttribute("ItogMsumpdS");

ItogKolpasS = (String)session.getAttribute("ItogKolpasS");

ItogMkolpasS = (String)session.getAttribute("ItogMkolpasS");

ItogSumprS = (String)session.getAttribute("ItogSumprS");

ItogMsumprS = (String)session.getAttribute("ItogMsumprS");

ItogKolprS = (String)session.getAttribute("ItogKolprS");

ItogMkolprS = (String)session.getAttribute("ItogMkolprS");

ItogSumbagS = (String)session.getAttribute("ItogSumbagS");

ItogMsumbagS = (String)session.getAttribute("ItogMsumbagS");

ItogKolbagS = (String)session.getAttribute("ItogKolbagS");

ItogMkolbagS = (String)session.getAttribute("ItogMkolbagS");

ItogKomsbvS = (String)session.getAttribute("ItogKomsbvS");

ItogMkomsbvS = (String)session.getAttribute("ItogMkomsbvS");

ItogKolvS = (String)session.getAttribute("ItogKolvS");

ItogMkomsbvS = (String)session.getAttribute("ItogMkolvS");

schet_data = (String)session.getAttribute("schet_data");

agent_query = (String)session.getAttribute("agent_query");

per_query = (String)session.getAttribute("per_query");

min_query = (String)session.getAttribute("min_query");

min_name = (String)session.getAttribute("min_name");

ItogSumpdMinS = (String)session.getAttribute("ItogSumpdMinS");

ItogMsumpdMinS = (String)session.getAttribute("ItogMsumpdMinS");

ItogKolpasMinS = (String)session.getAttribute("ItogKolpasMinS");

ItogMkolpasMinS = (String)session.getAttribute("ItogMkolpasMinS");

ItogSumprMinS = (String)session.getAttribute("ItogSumprMinS");

ItogMsumprMinS = (String)session.getAttribute("ItogMsumprMinS");

ItogKolprMinS = (String)session.getAttribute("ItogKolprMinS");

ItogMkolprMinS = (String)session.getAttribute("ItogMkolprMinS");

ItogSumbagMinS = (String)session.getAttribute("ItogSumbagMinS");

ItogMsumbagMinS = (String)session.getAttribute("ItogMsumbagMinS");

ItogKolbagMinS = (String)session.getAttribute("ItogKolbagMinS");

ItogMkolbagMinS = (String)session.getAttribute("ItogMkolbagMinS");

ItogKomsbvMinS = (String)session.getAttribute("ItogKomsbvMinS");

ItogMkomsbvMinS = (String)session.getAttribute("ItogMkomsbvMinS");

ItogKolvMinS = (String)session.getAttribute("ItogKolvMinS");

ItogMkomsbvMinS = (String)session.getAttribute("ItogMkolvMinS");

param_dor = (String)session.getAttribute("param_dor");

dor_query = (String)session.getAttribute("dor_query");

nazvl = (String)session.getAttribute("nazvl");

ust = (String)session.getAttribute("ust");

%>

<script language="JavaScript">

function onSubmit(objForm){

location.href="voin.do?reset=false";

}

</script>

<body bgcolor="white">

<a href="/express3/">Вернуться на страницу "Экспресс-3"</a>&nbsp;|&nbsp;

<a href="/armpp/">Главная страница АРМа</a>&nbsp;|&nbsp;

<a href="index3.jsp">Назад</a><br/><br/>

<center>

<html:form action="/voin">

<br>

<%

a=FirstDor;

%>

<% if(countRows==0){

if (param_dor.equals("all_set")){ %>

<h2 align="center">Информация о кредитовых ведомствах по сети &nbsp;за&nbsp;<%=schet_data%>&nbsp; отсутствует</h2>

<%}

else {%>

<h2 align="center">Информация о кредитовых ведомствах по дороге &nbsp;<%=dor_query%>за&nbsp;<%=schet_data%>&nbsp; отсутствует</h2>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ") || !per_query.equals("ЛЮБОЙ") || !agent_query.equals("ЛЮБОЙ")) { %>

<h4 align="left" style="font-size: 13pt">Дополнительная информация:</h4>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ")) { %>

<h4 align="left"style="font-size: 10pt">Код ведомства:&nbsp;&nbsp;<%=min_query%>&nbsp;</h4>

<%} if (!per_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код перевозчика:&nbsp;&nbsp;<%=per_query%>&nbsp;</h4>

<%} if (!agent_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код агента:&nbsp;&nbsp;<%=agent_query%>&nbsp;</h4>

<%}

}

else{

if (!param_dor.equals("all_set")){

%>

<h2 class="" align="center" style="font-size: 14pt">Информация о кредитовых ведомствах по дороге&nbsp;<%=dor_query%>&nbsp;за&nbsp;<%=schet_data%>&nbsp;

<br><font color="red" style="font-size: 12pt">(Все денежные суммы показаны в НДЕ: <%=nazvl%>

)</font></h2>

<%

}

if (param_dor.equals("all_set")) {

%>

<h2 class="" align="center" style="font-size: 14pt">Информация о кредитовых ведомствах по сети &nbsp;за&nbsp;<%=schet_data%>&nbsp;

<br><font color="red" style="font-size: 12pt">(Все денежные суммы показаны в НДЕ: <%=nazvl%>

)</font></h2>

<%

}

%>

<%if (!min_query.equals("ЛЮБОЙ") || !per_query.equals("ЛЮБОЙ") || !agent_query.equals("ЛЮБОЙ")) { %>

<h4 align="left" style="font-size: 13pt">Дополнительная информация</h4>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ")) { %>

<h4 align="left"style="font-size: 10pt">Код ведомства:&nbsp;&nbsp;<%=min_query%>&nbsp;</h4>

<%} if (!per_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код перевозчика:&nbsp;&nbsp;<%=per_query%>&nbsp;</h4>

<%} if (!agent_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код агента:&nbsp;&nbsp;<%=agent_query%>&nbsp;</h4>

<%} %>

<Table border="1" class="table" width="50%" cellpadding="2" cellspacing="0" bordercolor="#0c91f0" >

<tr>

<%if (min_query.equals("ЛЮБОЙ")) { %>

<th class="" align="center" style="font-size:7pt" colspan="2">Кредитовые ведомства&nbsp;</th>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ") && countRows>0) { %>

<th class="" align="center" style="font-size:7pt" rowspan="2">Дорога&nbsp;</th>

<%} %>

<th class="" align="center" style="font-size:7pt" colspan="2">К оплате</th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма от проданных документов в дальнем сообщении</th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. оформленных пассажиров в дальнем сообщении</th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма пригородных </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. пригородных пассажиров </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма от оформ. багажных документов </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. оформ. багажных документов </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Комсбор от продажи при возврате </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол-во док. по воинск. треб. </th>

</tr>

<tr>

<%if (min_query.equals("ЛЮБОЙ")) { %>

<th class="" align="center" style="font-size: 7pt">Название</th>

<th class="" align="center" style="font-size: 7pt">Номер</th>

<%} %>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

</tr>

<%

if (!schet_row_dors.equals("0")&& min_query.equals("ЛЮБОЙ")&& countRows>0 && !ust.equals("dor") ){

%>

<tr>

<th class="" align="center" colspan="20" style="font-size: 14pt">&nbsp;&nbsp; <%= NazvFirstDor %></th>

</tr>

<%

}

%>

<logic:iterate id="tableRow" name="tableRows" indexId="i" >

<%

b=((VoinClass)tableRow).getDor();

%>

<%

if (!b.equals(a) && min_query.equals("ЛЮБОЙ")&& countRows>1) {

%>

<tr>

<th class="" align="center" colspan="20" style="font-size: 14pt"><%=((VoinClass)tableRow).getNazvd()%>&nbsp;</th>

</tr>

<%

}

%>

<tr>

<%if (min_query.equals("ЛЮБОЙ")) { %>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRow).getMin_name()%>&nbsp;</td>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRow).getMin()%>&nbsp;</td>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ")&& countRows>0) { %>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRow).getNazvd()%>&nbsp;</td>

<%} %>

<TD nowrap="nowrap"><bean:write name="tableRow" property="oplata"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="moplata"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="sumpd"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="msumpd"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="kolpas"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="mkolpas"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="sumpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="msumpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="kolpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="mkolpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="sumbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="msumbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="kolbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="mkolbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="komsbv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="mkomsbv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="kolv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRow" property="mkolv"></bean:write>&nbsp;</TD>

<%

a=((VoinClass)tableRow).getDor();

%>

</tr>

</logic:iterate>

<% if (min_query.equals("ЛЮБОЙ")) { %>

<logic:iterate id="tableRowSet" name="tableRowsSet" indexId="j" >

<tr>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRowSet).getMin_name()%>&nbsp;</td>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRowSet).getMin()%>&nbsp;</td>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="oplata"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="moplata"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="sumpd"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="msumpd"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="kolpas"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="mkolpas"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="sumpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="msumpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="kolpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="mkolpr"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="sumbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="msumbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="kolbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="mkolbag"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="komsbv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="mkomsbv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="kolv"></bean:write>&nbsp;</TD>

<TD nowrap="nowrap"><bean:write name="tableRowSet" property="mkolv"></bean:write>&nbsp;</TD>

</tr>

</logic:iterate>

<% }%>

</Table>

<%

}

if (countRows>0){

%>

<br>

<div>

<input type="button" name="sendEx" value="Передать в Excel" onclick="doSendEx()"></div>

<%} %>

</html:form>

</body>

</html>

index 4.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>

<%@ page import="voin.Classes.*, java.util.*" %>

<%@ page import="voin.Classes.JDBCConnection"%>

<%@ page import="java.io.*"%>

<%@ page import="java.sql.*"%>

<%@ page import="javax.naming.*"%>

<%@page language="java" contentType="text/html; charset=Windows-1251"

pageEncoding="Windows-1251"%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=Windows-1251">

<META name="GENERATOR" content="IBM Software Development Platform">

<META http-equiv="Content-Style-Type" content="text/css">

<LINK href="theme/Master.css" rel="stylesheet" type="text/css">

<title>Кредитовые ведомства</title>

</HEAD>

<script language="JavaScript">

function doSendEx() {

var newWindowEx;

if (!newWindowEx || newWindowEx.closed) {

var props = 'scrollBars=yes,resizable=yes,toolbar=yes,menubar=yes,location=no,directories=no,width=550,height=550';

newWindowEx = window.open("/dohodv/index4Ex.jsp","Excel",props);

}

}

</script>

<%

String dor = "";

String per = "";

String schet_dataAll = "";

String ItogSumpdAllS ="";

String ItogMsumpdAllS = "";

String ItogKolpasAllS = "";

String ItogMkolpasAllS = "";

String ItogSumprAllS = "";

String ItogMsumprAllS = "";

String ItogKolprAllS = "";

String ItogMkolprAllS = "";

String ItogSumbagAllS = "";

String ItogMsumbagAllS = "";

String ItogKolbagAllS = "";

String ItogMkolbagAllS = "";

String ItogKomsbvAllS = "";

String ItogMkomsbvAllS = "";

String ItogKolvAllS = "";

String ItogMkolvAllS = "";

String min_name ="";

String agent_query = "";

String per_query = "";

String min_query = "";

String nazvl = "";

int countRowsAll=((ArrayList)session.getAttribute("tableRowsAll")).size();

ItogSumpdAllS = (String)session.getAttribute("ItogSumpdAllS");

ItogMsumpdAllS = (String)session.getAttribute("ItogMsumpdAllS");

ItogKolpasAllS = (String)session.getAttribute("ItogKolpasAllS");

ItogMkolpasAllS = (String)session.getAttribute("ItogMkolpasAllS");

ItogSumprAllS = (String)session.getAttribute("ItogSumprAllS");

ItogMsumprAllS = (String)session.getAttribute("ItogMsumprAllS");

ItogKolprAllS = (String)session.getAttribute("ItogKolprAllS");

ItogMkolprAllS = (String)session.getAttribute("ItogMkolprAllS");

ItogSumbagAllS = (String)session.getAttribute("ItogSumbagAllS");

ItogMsumbagAllS = (String)session.getAttribute("ItogMsumbagAllS");

ItogKolbagAllS = (String)session.getAttribute("ItogKolbagAllS");

ItogMkolbagAllS = (String)session.getAttribute("ItogMkolbagAllS");

ItogKomsbvAllS = (String)session.getAttribute("ItogKomsbvAllS");

ItogMkomsbvAllS = (String)session.getAttribute("ItogMkomsbvAllS");

ItogKolvAllS = (String)session.getAttribute("ItogKolvAllS");

ItogMkolvAllS = (String)session.getAttribute("ItogMkolvAllS");

dor = (String)session.getAttribute("dor");

per = (String)session.getAttribute("per");

schet_dataAll = (String)session.getAttribute("schet_dataAll");

min_name = (String)session.getAttribute("min_name");

agent_query = (String)session.getAttribute("agent_query");

per_query = (String)session.getAttribute("per_query");

min_query = (String)session.getAttribute("min_query");

nazvl = (String)session.getAttribute("nazvl");

%>

<script language="JavaScript">

function onSubmit(objForm){

location.href="voin.do?reset=false";

}

</script>

<body bgcolor="white">

<a href="/express3/">Вернуться на страницу "Экспресс-3"</a>&nbsp;|&nbsp;

<a href="/armpp/">Главная страница АРМа</a>&nbsp;|&nbsp;

<a href="index3.jsp">Назад</a><br/><br/>

<html:form action="/voin">

<br>

<center>

<% if(countRowsAll==0){%>

<h2 align="center">Информация за&nbsp;<%=schet_dataAll%>&nbsp;о кредитовых ведомствах. Итог по дорогам России отсутствует</h2>

<%if (!min_query.equals("ЛЮБОЙ") || !per_query.equals("ЛЮБОЙ") || !agent_query.equals("ЛЮБОЙ")) { %>

<h4 align="left" style="font-size: 13pt">Дополнительная информация:</h4>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ")) { %>

<h4 align="left"style="font-size: 10pt">Код ведомства:&nbsp;&nbsp;<%=min_query%>&nbsp;</h4>

<%} if (!per_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код перевозчика:&nbsp;&nbsp;<%=per_query%>&nbsp;</h4>

<%} if (!agent_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код агента:&nbsp;&nbsp;<%=agent_query%>&nbsp;</h4>

<% }

}

else{ %>

<h2 align="center" style="font-size: 18pt">Информация о кредитовых ведомствах.

<br><font align="center">Итог по дорогам России за&nbsp;<%=schet_dataAll%>&nbsp;

</font>

<br><font color="red" style="font-size: 12pt">(Все денежные суммы показаны в НДЕ: <%=nazvl%>

)</font> </h2>

<br><br>

<%if (!min_query.equals("ЛЮБОЙ") || !per_query.equals("ЛЮБОЙ") || !agent_query.equals("ЛЮБОЙ")) { %>

<h4 align="left" style="font-size: 13pt">Дополнительная информация:</h4>

<%} %>

<%if (!min_query.equals("ЛЮБОЙ")) { %>

<h4 align="left"style="font-size: 10pt">Код ведомства:&nbsp;&nbsp;<%=min_query%>&nbsp;</h4>

<%} if (!per_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код перевозчика:&nbsp;&nbsp;<%=per_query%>&nbsp;</h4>

<%} if (!agent_query.equals("ЛЮБОЙ")) {%>

<h4 align="left"style="font-size: 10pt">Код агента:&nbsp;&nbsp;<%=agent_query%>&nbsp;</h4>

<%} %>

<Table border="1" class="table" width="50%" cellpadding="2" cellspacing="0" bordercolor="#0c91f0" >

<tr>

<%if (min_query.equals("ЛЮБОЙ")) { %>

<th class="" align="center" style="font-size:7pt" colspan="2">Кредитовые ведомства </th>

<%} %>

<th class="" align="center" style="font-size:7pt" colspan="2">К оплате </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма от проданных документов в дальнем сообщении </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. оформленных пассажиров в дальнем сообщении </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма пригородных </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. пригородных пассажиров </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Сумма от оформ. багажных документов </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол. оформ. багажных документов </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Комсбор от продажи при возврате </th>

<th class="" align="center" style="font-size:7pt" colspan="2">Кол-во док. по воинск. треб. </th>

</tr>

<tr>

<%if (min_query.equals("ЛЮБОЙ")) { %>

<th class="" align="center" style="font-size: 7pt">Название</th>

<th class="" align="center" style="font-size: 7pt">Номер</th>

<%} %>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

<th class="" align="center" style="font-size: 7pt">На одну дату</th>

<th class="" align="center" style="font-size: 7pt">С нач. месяца</th>

</tr>

<logic:iterate id="tableRowAll" name="tableRowsAll" indexId="i" >

<tr>

<%if (min_query.equals("ЛЮБОЙ")){ %>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRowAll).getMin_name()%>&nbsp;</td>

<td class="" align="center" style="font-size: 7pt">&nbsp;<%=((VoinClass)tableRowAll).getMin()%>&nbsp;</td>

<%} %>