перезапускал, не видит.
java 1.6
описание отчета
<?xml version="1.0" encoding="UTF-8"?>
<report title="Выгрузка в ЕРКЦ" type="java" >
<combo name="yr" title="Год" x="1" y="2" width="2">
<item id="2014" title="2014"/>
<item id="2015" title="2015"/>
<item id="2016" title="2016"/>
<item id="2017" title="2017"/>
<item id="2018" title="2018"/>
</combo>
<combo name="mn" title="Месяц" x="3" y="2" width="2">
<item id="1" title="Январь"/>
<item id="2" title="Февраль"/>
<item id="3" title="Март"/>
<item id="4" title="Апрель"/>
<item id="5" title="Май"/>
<item id="6" title="Июнь"/>
<item id="7" title="Июль"/>
<item id="8" title="Август"/>
<item id="9" title="Сентябрь"/>
<item id="10" title="Октябрь"/>
<item id="11" title="Ноябрь"/>
<item id="12" title="Декабрь"/>
</combo>
<combo name="em" title="Email" y="3" width="4">
<item id="1@mail.ru" title="1@mail.ru"/>
<item id="2@mail.ru" title="2@mail.ru"/>
<item id="3@mail.ru" title="3@mail.ru"/>
</combo>
</report>
сам отчет.
import java.sql.*;
import ru.mycompany.rep1.*;
public void fillReport( con, filter, result ) {
int year = filter.getIntParam( "yr" );
int month = filter.getIntParam("mn");
String em = filter.getStringParam("em");
ArrayList data = new ArrayList( 1000 );
map = new HashMap();
getReport gR = new getReport();
try {
gR.InitBase(con);
gR.setNameVar("Лицевой счёт%");
gR.setNameType("%ЧТО-ТО%");
gR.setYear(Integer.parseInt(yr));
gR.setMonth(Integer.parseInt(mn));
gR.setDirOut("/usr/local/BGBillingServer/tmp/");
gR.setFNameTxt("un");
gR.initFiles();
gR.setPSString("Select c1.id,c1.title,c1.val,crp.title from ("
+" Select cc.id,cc.title,cr.cid,cr.val,cr.pid from ("
+" select distinct cp.id, cp.title"
+" from bgbilling.contract cp,"
+" bgbilling.contract_group cg"
+" where cp.status=0"
+" and cg.title like ?"
+" and cp.gr & pow(2,cg.id) = pow(2,cg.id)"
+" )"
+" cc LEFT JOIN bgbilling.contract_parameter_type_1 cr on cr.cid=cc.id"
+" ) c1"
+" LEFT JOIN bgbilling.contract_parameters_pref crp ON c1.pid = crp.id and crp.title like ?"
+" where crp.title like ? or crp.title is null "
+" order by c1.title asc, crp.title desc");
gR.RunReport();
gR.send2mail("/usr/local/BGBillingServer/tmp/un.zip", "billing@mycompany.ru", em, "ip", "billing", "billing", "un", "See attached file");
map.put( "File ", " sending to "+em );
//
gR.setFNameTxt("un_cl");
gR.initFiles();
gR.setPSString("Select c1.id,c1.title,c1.val,crp.title from ("
+" Select cc.id,cc.title,cr.cid,cr.val,cr.pid from ("
+" select distinct cp.id, cp.title"
+" from bgbilling.contract cp,"
+" bgbilling.contract_group cg,"
+" bgbilling.contract_status cs"
+" where cp.status!=0"
+" and cg.title like ?"
+" and cp.gr & pow(2,cg.id) = pow(2,cg.id)"
+" and cp.status=cs.status"
+" and cp.id=cs.cid"
+" and year(cs.date1)=?"
+" and month(cs.date1)=?"
+" )"
+" cc LEFT JOIN bgbilling.contract_parameter_type_1 cr on cr.cid=cc.id"
+" ) c1"
+" LEFT JOIN bgbilling.contract_parameters_pref crp ON c1.pid = crp.id and crp.title like ?"
+" where crp.title like ? or crp.title is null "
+" order by c1.title asc, crp.title desc");
gR.RunReport();
gR.Close();
gR.send2mail("/usr/local/BGBillingServer/tmp/un_cl.zip", "billing@mycompany.ru", em, "ip", "billing", "billing", "un", "See attached file");
map.put( "File ", " sending to "+em );
data.add( map );
}
catch (Exception e) {e.printStackTrace();
map.put( "Error", e.getMessage());
data.add( map );
}
result.setData( data );
}
Прекрасно понимаю что должен видеть библиотеки, но не видит.....
Вход
Регистрация
FAQ
Поиск
