charts
colors
bars="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
hbars="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
pies="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
lines="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
splines="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
measure_category
item1="485"
item2="486"
item3="487"
item4="488"
item5="489"
item6="490"
item7="491"
item8="492"
item9="1001"
item11="1002"
item12="1004"
item13="1005"
item14="1006"
item15="1013"
item16="1014"
item17="1015"
item18="1016"
item19="1017"
item20="1018"
item21="1019"
item22="1020"
item23="1021"
servizi="1022"
servizi_centrali="1023"
item28="1024"
item29="1025"
item30="1026"
item31="1027"
item32="1028"
item33="1029"
item34="1030"
personale="99915"
orario="99916"
6b67577dee2c76cbd1b94a2cd4b4b803="99955"
adminuser
enabled="yes"
username="superuser"
password="298c476c44"
staff_level
manager="99906"
organizational_position="99907"
level_a="99908"
level_b="99909"
level_c="99910"
level_d="99911"
unestablished="99912"
measure_fte_year_avg_week
fte_year_avg_week_id="99948"
fte_year_avg_week_total="99949"
autoupdate
url="http://www.simonlib.com/patches/25/simonlib.ini"
autoreg="http://licenses.simonlib.it/licenses?entry=autoreg"
interval="3600000"
timeout="60000"
measure_staff_level
measure_staff_level_id="99937"
staff_level_total="99938"
staff_level_manager="99939"
staff_level_organiz_pos="99940"
staff_level_a="99941"
staff_level_b="99942"
staff_level_c="99943"
staff_level_d="99944"
staff_level_unestablished="99945"
sql
sql-quote-replace="''"
tostring1=" "
tostring2=" "
schema-quote="`"
dateA="'"
dateB="'"
yearA="YEAR("
yearB=")"
monthA="MONTH("
monthB=")"
dayA="DAY("
dayB=")"
dbdate="yyyy-MM-dd HH:mm:ss.S"
delete="DELETE"
is_null=" IS NULL"
primary=" "
storage=" TYPE=InnoDB"
datetime="datetime"
double="DECIMAL(28,15)"
memotype="text"
varchar="varchar"
distinctlong="text"
castnum1="CAST("
castnum2=" AS DECIMAL(19,2))"
castdecimalsA=" "
castdecimalsB=" "
add1=" CONCAT("
addsep=","
add2=")"
lenght="LENGTH"
limitSQLServer=" "
limitRest=" LIMIT "
limitSQLServer1=" "
limitRest1=" LIMIT 1 "
bitandA="("
bitandB="&"
bitandC=")"
bitorA="("
bitorB="|"
bitorC=")"
notA="(CASE "
notB=" WHEN 0 THEN 1 ELSE 0 END)"
caseA="(CASE "
caseB=" WHEN "
caseC=" THEN "
caseD=" ELSE "
caseE=" END)"
orderby=" "
orderbyDesc=" "
escape_und1="\_"
escape_und2=" "
filters
languages
table_name="`descriptions`"
queryTagID="(JD|DJ|D2J)[0-9]+"
query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT JD%.`IDUnique` FROM `descriptions` JD%
INNER JOIN (SELECT D2J%.`ID`, max((D2J%.`FkLanguage`&@LID1@))
+ (((CASE max((D2J%.`FkLanguage`&@LID1@)) WHEN 0 THEN 1 ELSE 0 END)) * (max((D2J%.`FkLanguage`&@LID2@))))
+ (((CASE max((D2J%.`FkLanguage`&@LID1@)) + max((D2J%.`FkLanguage`&@LID2@)) WHEN 0 THEN 1 ELSE 0 END)) * max(D2J%.`FkLanguage`)) AS `FkLanguage`
FROM `descriptions` D2J% GROUP BY D2J%.`ID`) DJ% ON (JD%.`ID`=DJ%.`ID` AND JD%.`FkLanguage`=DJ%.`FkLanguage`)
WHERE @TLABEL@`ID`=JD%.`ID`)"
libraries
table_name="`libraries`"
queryTagID="JL[0-9]+"
query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT `ID`+2000*(`ID`-10000)+(CASE MAX(`LYear`) WHEN 0 THEN 0 ELSE MAX(`LYear`)-1899 END) FROM `libraries` JL% WHERE JL%.`LYear`<=@YEAR@ AND @TLABEL@`ID`=JL%.`ID` GROUP BY JL%.`ID`)"
hierarchy
table_name="`library_views`"
queryTagID="JLV[0-9]+"
query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT `FkLibrary`+2000*(`FkLibrary`-10000)+(CASE MAX(`LYear`) WHEN 0 THEN 0 ELSE MAX(`LYear`)-1899 END) FROM `library_views` JLV% WHERE JLV%.`LYear`<=@YEAR@ AND @TLABEL@`FkLibrary`=JLV%.`FkLibrary` GROUP BY JLV%.`FkLibrary`)"
thresholds
table_name="`thresholds`"
queryTagID="(JTE|ETJ)[0-9]+"
query="@TLABEL@`ID` IS NULL OR @TLABEL@`ID`= ANY (SELECT `ID` FROM `thresholds` JTE%
INNER JOIN (SELECT `FkIndex`, MAX(`TYear`) AS `TYear`, `FkRangePar`, `FkSubRangeDesc`
FROM `thresholds` JT%
WHERE JT%.`TYear`<=@YEAR@
GROUP BY JT%.`FkIndex`,JT%.`FkRangePar`,JT%.`FkSubRangeDesc`) ETJ%
ON (JTE%.`FkIndex`=ETJ%.`FkIndex` AND JTE%.`TYear`=ETJ%.`TYear` AND JTE%.`FkRangePar`=ETJ%.`FkRangePar` AND ((JTE%.`FkSubRangeDesc` IS NULL AND ETJ%.`FkSubRangeDesc` IS NULL) OR JTE%.`FkSubRangeDesc`=ETJ%.`FkSubRangeDesc`))
WHERE JTE%.`FkIndex`=@TLABEL@`FkIndex` AND JTE%.`TYear`=@TLABEL@`TYear` AND JTE%.`FkRangePar`=@TLABEL@`FkRangePar` AND ((JTE%.`FkSubRangeDesc` IS NULL AND @TLABEL@`FkSubRangeDesc` IS NULL) OR JTE%.`FkSubRangeDesc`=@TLABEL@`FkSubRangeDesc`)
)"
unique-id-violation-message-retry="Duplicate entry
'"
lockA="LOCK TABLES "
lockB=" WRITE"
unlockA="UNLOCK TABLES"
datediffA="DATEDIFF("
datediffB=")"
strtodateA="STR_TO_DATE("
strtodateB=", '%Y-%M-%d')"
timediffA="TIMEDIFF("
timediffB=")"
timeformatA="TIME_FORMAT("
timeformatB=", '%H:%i')"
timetosecA="TIME_TO_SEC("
timetosecB=")"
weekA="WEEK("
weekB=", 1)"
concatA="CONCAT("
concatB=")"
roundA="ROUND("
roundB=", 2)"
copy_types
value="480"
clone="481"
merge="482"
_OS_="linux"
measure_opening_hours
total_hours_opening="99917"
total_hours_morning="99918"
total_hours_afternoon="99919"
total_hours_evening="99920"
total_hours_saturday="99921"
total_hours_sunday="99922"
total_hours_holidays="99923"
total_hours_working="99924"
measure_hour_id="99925"
measure_type
empty="99900"
hour="99901"
personnel="99902"
measure_opening_weeks
measure_opening_weeks_id="99926"
opening_weeks_total="99927"
opening_weeks_winter="99928"
opening_weeks_summer="99929"
opening_weeks_other="99930"
database
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-connect="jdbc:mysql://127.0.0.1:3306/istat_demo?user=simonlib&password=298c476c44&zeroDateTimeBehavior=convertToNull"
enckey="NyZB6u8U9w5W&L7W!u2A2SAZ#!3B6EACQKqrMxtqq78MzhnAYj"
libraries
councillabels="0"
languages
smart_shema="0"
schema="0"
staff_occupation
full_time="99913"
partial_time="99914"
measure_fte_week_units
fte_week_units_id="99946"
fte_week_units_total="99947"
langs
it="1"
en="2"
de="4"
fr="8"
abil_report
measure_periodicity
yearly="130"
monthly="131"
daily="132"
sixmonths="133"
theemonths="134"
custom="135"
three_year="140"
graph_types
line="450"
bars="451"
pie="452"
hbars="453"
splines="454"
usedb="mysql"
measure_items_value_repeat
non_repeatable="125"
repeatable="126"
graph_periods
none="470"
day="471"
month="472"
years="473"
library_type
standalone="160"
system_client="161"
system="162"
citycounil_system="163"
county_system="164"
countrystate_system="165"
country_system="166"
citycounil_group="167"
county_group="168"
countrystate_group="169"
country_group="170"
label="180"
libraries
registration_code="solo.per.noi"
ALL_RIGHTS_PATTERN="33554431"
measure_TO_type
no_takeover="150"
total_takeover="151"
item_takeover="152"
env="dev"
rate_types
margins="200"
system_compare="201"
measure_staff
measure_staff_id="99931"
staff_total="99932"
staff_role_total="99933"
staff_role_full_time="99934"
staff_role_partial_time="99935"
staff_not_role="99936"
opening_type
winter="99903"
summer="99904"
other="99905"
rate_groups_names
accessibility="210"
vitality="211"
productivity="212"
efficacy="213"
system
use-version="2.0"
xsl-error-page="generic-error"
localization-path="yes"
log-filename="systrace.log"
debug="yes"
development="yes"
cache-application="no"
cache-validation="yes"
cache-graphic="no"
data-compression="-1"
split-country-graphicyes="yes"
split-visp-graphic="no"
_project_path="/opt/simonlib/tomcat/webapps/istat"
entities
measures="320"
indexes="321"
rates="322"
queries="323"
p3p-header="CP="CAO DSP COR CURa ADMa DEVa OUR IND PHY ONL UNI COM NAV INT DEM PRE""
days
Monday="312"
Tuesday="313"
Wednesday="314"
Thursday="315"
Friday="316"
Saturday="317"
Sunday="318"
bridge
lc="6AR3579PM95HM"
me="255"
cl="0"
ml="0"
tp="5"
dp="0"
pk="10"
state="1"
hide="1"
fields
09="0123456789"
az="abcdefghijklmnopqrstuvwxyzäöü"
AZ="ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ"
Az="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ"
Az09="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789"
Az09special="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789_-."
email="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789_-.@"
name="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ ìòàèéù"