private void saveStartProjects(File file) throws IOException {
Calendar cal = Calendar.getInstance();
try (PrintWriter out = new PrintWriter(file, "windows-1251")) {
for (Region region : this.regions) {
cal.setTime(region.start);
out.write("\"");
out.write(region.filial + " " + region.name);
out.write("\";;;");
int skeepCells = (cal.get(Calendar.YEAR) - 2017) * 5 + (cal.get(Calendar.MONDAY) % 4);
for (int i = 0; i < skeepCells; i++) {
out.write(";");
}
out.println("X");
}
}
}
private void saveExcelPoject(File file) throws IOException {
Workbook wb = new XSSFWorkbook();
Sheet sheet = wb.createSheet("timeplan");
// Заголовок в 0 строке
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Филиал");
cell = row.createCell(1);
cell.setCellValue("Город");
Calendar cal = Calendar.getInstance();
cal.set(2017, 0, 5); // Начальная дата проекта
SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yy");
for (int i = 0; i < 3 * 52; i++) { // Счетчик по неделям
cell = row.createCell(i + 2);
cell.setCellValue(sdf.format(cal.getTime()));
cal.add(Calendar.WEEK_OF_YEAR, 1); // Следующая неделя
}
// sheet.setColumnWidth(0, 256);
// Цвета ячеек
CellStyle[] styles = new CellStyle[6];
styles[0] = wb.createCellStyle();
styles[0].setFillForegroundColor(HSSFColor.RED.index);
styles[0].setFillPattern(FillPatternType.SOLID_FOREGROUND);
styles[1] = wb.createCellStyle();
styles[1].setFillForegroundColor(HSSFColor.GREEN.index);
styles[1].setFillPattern(FillPatternType.SOLID_FOREGROUND);
styles[2] = wb.createCellStyle();
styles[2].setFillForegroundColor(HSSFColor.BLUE.index);
styles[2].setFillPattern(FillPatternType.SOLID_FOREGROUND);
styles[3] = wb.createCellStyle();
styles[3].setFillForegroundColor(HSSFColor.ROSE.index);
styles[3].setFillPattern(FillPatternType.SOLID_FOREGROUND);
styles[4] = wb.createCellStyle();
styles[4].setFillForegroundColor(HSSFColor.LIGHT_BLUE.index);
styles[4].setFillPattern(FillPatternType.SOLID_FOREGROUND);
styles[5] = wb.createCellStyle();
styles[5].setFillForegroundColor(HSSFColor.LIGHT_GREEN.index);
styles[5].setFillPattern(FillPatternType.SOLID_FOREGROUND);
short rowIdx = 0;
for (Region region : this.regions) {
row = sheet.createRow(++rowIdx);
cell = row.createCell(0);
cell.setCellValue(region.filial);
cell = row.createCell(1);
cell.setCellValue(region.name);
cal = Calendar.getInstance();
cal.set(2017, 0, 5); // Начальная дата проекта
for (int i = 0; i < 3 * 52; i++) { // Счетчик по неделям
short color = region.getDateColorIndex(cal.getTime());
if (color >= 0) {
cell = row.createCell(i + 2);
cell.setCellStyle(styles[color]);
}
cal.add(Calendar.WEEK_OF_YEAR, 1); // Следующая неделя
}
}
try (FileOutputStream fileOut = new FileOutputStream(file)) {
wb.write(fileOut);
}
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFFreeSwitchXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
// Request Attributes
String attrSecSessionId = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstLogOut");
CFFreeSwitchXMsgRqstHandler xmsgRqstHandler = (CFFreeSwitchXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFFreeSwitchSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Extract Attributes
numAttrs = attrs.getLength();
for (idxAttr = 0; idxAttr < numAttrs; idxAttr++) {
attrLocalName = attrs.getLocalName(idxAttr);
if (attrLocalName.equals("Id")) {
if (attrId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("SecSessionId")) {
if (attrSecSessionId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrSecSessionId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("schemaLocation")) {
// ignored
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnrecognizedAttributeException(
getClass(), S_ProcName, getParser().getLocationInfo(), attrLocalName);
}
}
// Ensure that required attributes have values
if ((attrSecSessionId == null) || (attrSecSessionId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "SecSessionId");
}
UUID secSessionId = UUID.fromString(attrSecSessionId);
if (secSessionId == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "converted-secSessionId");
}
if (schemaObj.getAuthorization() == null) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Already disconnected from the database");
}
ICFSecuritySecSessionObj secSession = schemaObj.getSecSession();
if (secSession == null) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Security session does not exist for this schema");
}
if (!secSessionId.equals(secSession.getRequiredSecSessionId())) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Security session id does not match the one established by this schema");
}
if (secSession.getOptionalFinish() == null) {
schemaObj.rollback();
schemaObj.beginTransaction();
ICFSecuritySecSessionEditObj editSecSession = secSession.beginEdit();
editSecSession.setOptionalFinish(Calendar.getInstance());
editSecSession.update();
editSecSession.endEdit();
schemaObj.commit();
}
schemaObj.disconnect(false);
schemaObj.setAuthorization(null);
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFFreeSwitchXMsgSchemaMessageFormatter.formatRspnLoggedOut("\n\t\t\t", secSessionId)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
((CFFreeSwitchXMsgRqstHandler) getParser()).appendResponse(response);
} catch (RuntimeException e) {
CFFreeSwitchXMsgRqstHandler xmsgRqstHandler = ((CFFreeSwitchXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFFreeSwitchXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFFreeSwitchXMsgRqstHandler xmsgRqstHandler = ((CFFreeSwitchXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFFreeSwitchXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}
