/home/groups/y/ya/yaacs/svnrepo/yaacs/admin.tcl
| Procedure Summary |
::admin::build_history { db proj proj_table }get a project contacts' history into an array whose keys are contacts' rid. |
::admin::clearCache { }clear cached values for project's |
::admin::countStateForOp { db idPj op state }countStateForOp - counts how many contacts has been marked with a specifed state(s) by an |
::admin::delPj { db idPj } |
::admin::delPjReal { db idPj }delete a |
::admin::delTurn { db idT }delete a |
::admin::flushStat { db idPj }flush stat for a project: move data from statistiche to |
::admin::getAllPjOss { db pj }Get a project start-end timestamp to use as performance osservation |
::admin::getDataPj { db idPj }get all project's attribute. |
::admin::getFieldLIst { db schema tab }getFieldList - gives you back two list of field/type of table |
::admin::getIdtByTName { db idt }get turn/shift name bi turn |
::admin::getOperators { db idPj }getOperators - get a list of all operators which have been involved into a |
::admin::getPjTurns { db pj date }get project's turns for a specified |
::admin::getSamples { db }get all sampling algorithm |
::admin::getSmsTxt { db proj } |
::admin::getStatTable { db idPj }get project statistics table's |
::admin::getTurns { db }get all turns defined on |
::admin::importFile { db idPj slist path }importFile - import file into table pj |
::admin::importSampleStructure { db idPj path }import the sampling structure from a specified formatted |
::admin::massFax { db pj faxserver cover }do a massive fax send to all contacts of a specified |
::admin::massMail { db pj mailserver fromadd path }do a massive mail send to all contacts of a specified |
::admin::newUpPj { ce db name desc duration wtime active is4company {maxt samplet} soglia pausep freqmon table url shiftDef impS g_stuff {idPj {}} }create/edit a new cati |
::admin::newUpTurn { ce db name start end {idT {}} }create/edit a |
::admin::quotaCheck { db idPj type qPerc {deflist {}} }perform quota checking; you can choose between 2 types of them setting the type |
::admin::quotaCodCol { db idPj type }quota checking for Stratified |
::admin::quotaCodColS { db idPj type }quota checking for Cod col - |
::admin::quotaCodProv { db idPj type qPerc }quota checking for |
::admin::quotaGenAge { db idPj deflist }quotaGendAge checking for gender and |
::admin::quotaRuotato { db idPj type }quota checking for |
::admin::quotaSost { db idPj type }quota checking for |
::admin::refreshOldContact { db idPj pjname oldM newM } |
::admin::setLia { db pj email invite sms fax }::admin::setLia update lia data for a given |
::admin::setPjDuration { db pj start end }set a project |
::admin::setTurns { db pj turns }set turns for a |
::admin::summarize { db idPj {fromHere {}} {toHere {}} }summarize the project status calculating some |
::admin::timeSpent { db idPj op }get the time a user has spent on a |
::admin::turnTime { db idPj op start end }get the time a user has spent for a project in a specific work turn starting from start and ending not after |
| Procedure Detail |
proc ::admin::build_history { db proj proj_table }
proc ::admin::clearCache { }
proc ::admin::countStateForOp { db idPj op state }
db - (operators) database connection handler
idPj - project's id
op - operator's id
state - state you want to match
proc ::admin::delPj { db idPj }
proc ::admin::delPjReal { db idPj }
db - database connection handler
idPj - project's id on db.
proc ::admin::delTurn { db idT }
db - database connection handler
idT - turn's id on db.
proc ::admin::flushStat { db idPj }
db - (operators) database connection handler
idPj - project's id on db
proc ::admin::getAllPjOss { db pj }
(sample) - db database connectoin handler
pj - project's id
return a two timestamps (start and end) list; -1 on error.
proc ::admin::getDataPj { db idPj }
db - database connection handler
idPj - project's id on db
proc ::admin::getFieldLIst { db schema tab }
db - - db connections handler (sample)
tab - - table whose yuo eant two know the list of fields
proc ::admin::getIdtByTName { db idt }
proc ::admin::getOperators { db idPj }
db - (operators) database connection handler
idPj - project's id on db
proc ::admin::getPjTurns { db pj date }
db - (sampling) database connection handler
pj - project's id on db
date - the date for which you want to retrive informations
proc ::admin::getSamples { db }
db - database connection handler
proc ::admin::getSmsTxt { db proj }
proc ::admin::getStatTable { db idPj }
db - database connection handler
idPj - project's id on db
proc ::admin::getTurns { db }
db - database connection handler
proc ::admin::importFile { db idPj slist path }
db - - db connection handler
idPj - - project id
slist - - field list to import
path - - file where contatcs are stored
proc ::admin::importSampleStructure { db idPj path }
db - (sampling) database connection handler
idPj - project's id on db
path - file's path
return 0 on success; -1 on error
proc ::admin::massFax { db pj faxserver cover }
db - (sampling) database connection handler
pj - project's id on db
faxserver - server to be used to send faxes
cover - fax template
proc ::admin::massMail { db pj mailserver fromadd path }
db - (sampling) database connection handler
pj - project's id on db
mailserver - server to be used to send emails
fromadd - from email address
path - mail's body file path
proc ::admin::newUpPj { ce db name desc duration wtime active is4company {maxt samplet} soglia pausep freqmon table url shiftDef impS g_stuff {idPj {}} }
ce - choose if you want to create (0) or edit (1) a project
db - database connection handler
dbInt - operators' database connection handler
name - survey project's name
desc - survey project's description
duration - when does this project start/end? (two dates list)
wtime - list which specifies how long do you have to wait for
a call back for no answer, busy, fax machine and answering
machine respectively. (times are expressed in minutes)
active - flag which says if the project is running (!0) or not (0)
is4company - flag which says if the project's refered to company (!0) or not (0)
maxt - max numeber re-calling times
samplet - sample type expressed by an integer which unique identify the
algorithm you want to apply
soglia - used for a specific type of sample
pausep - pause's params; a two elements list reporting max minutes for
a pause duration and for their sum
freqmon - monitoring update frequence
table - default setted to name; db's table name to store project's data
url - default setted to ""; url to point a browser to do the survey
shiftDef - a messed list of list, each sublist contains turns id, day, seats
smstxt, updatelist and massSms, action
impS - file and file's structured where contacts are stored
g_stuff - a list of 4 params that affect operator's GUI (1st show contact name,
2nd mandatory callback anagraphic data, 3rd mandatory anagraphic data on completed
and 4th auto call definition: 0 no auto call, 1 auto call always on, 2 user selectable
idPj - [optional] project's id on db; use it if you're editing a project.
proc ::admin::newUpTurn { ce db name start end {idT {}} }
ce - choose if you want to create (0) or edit (1) a turn
db - database connection handler
name - turn's name
start - turn's start (time without time zone)
end - turn's end (time without time zone)
idT - [optional] turn's id on db. Use it to edit a turn.
proc ::admin::quotaCheck { db idPj type qPerc {deflist {}} }
db - database connection handler
idPj - project's id on db.
type - integer that specify the type of quota checking to
perform;you can choose from:
0: stands x geographical quota (completed interviews)
1: stands x geographical quota (distance from goal)
2: stands x gender-age quota
quota - output parameter. it's a list which contains
results.
proc ::admin::quotaCodCol { db idPj type }
db - database connection handler
idPj - project's id on db.
type - integer that specify if yuo want
numerosita' or distanza dall'obiettivo.
proc ::admin::quotaCodColS { db idPj type }
db - database connection handler
idPj - project's id on db.
type - integer that specify if yuo want
numerosita' or distanza dall'obiettivo.
proc ::admin::quotaCodProv { db idPj type qPerc }
db - database connection handler
idPj - project's id on db.
type - integer that specify if yuo want
numerosita' or distanza dall'obiettivo.
proc ::admin::quotaGenAge { db idPj deflist }
db - database connection handler
idPj - project's id on db.
proc ::admin::quotaRuotato { db idPj type }
db - database connection handler
idPj - project's id on db.
type - integer that specify if yuo want
numerosita' or distanza dall'obiettivo.
proc ::admin::quotaSost { db idPj type }
db - database connection handler
idPj - project's id on db.
type - integer that specify if yuo want
numerosita' or distanza dall'obiettivo.
proc ::admin::refreshOldContact { db idPj pjname oldM newM }
proc ::admin::setLia { db pj email invite sms fax }
db - database connection handler
pj - the project you're working on
email - email template data
invite - panel invite template data
sms - sms template data
fax - fax template data
return - 0 on success; -1 on error.
proc ::admin::setPjDuration { db pj start end }
db - database connection handler
pj - project's id on db
start - start date
end - end date
proc ::admin::setTurns { db pj turns }
db - (sampling) database connection handler
pj - project's id on db
turns - list of all turns to be saved. Each
element of the list is it self a three
elements list composed by {date,turns' id, pos}
proc ::admin::summarize { db idPj {fromHere {}} {toHere {}} }
db - - database connection handler
idPj - project's id on db.
fromHere - [optional] where do you want to start to calculate performance indexes?
toHere - [optional] where do you want to stop to calculate performance indexes?
proc ::admin::timeSpent { db idPj op }
db - operators database connection handler
idPj - project's id
op - which operator are you going to "process"
proc ::admin::turnTime { db idPj op start end }
db - operators database connection handler
idPj - project's id on db
op - which operator are you looking for?
start - when does this turn start?
end - upper limit for turn ending (i.e. the next turn's start)