head 1.14; access; symbols AS_AFTER_RESTRUCTURING:1.14 AS_PRODUCTION:1.1; locks; strict; comment @# @; 1.14 date 2002.10.15.13.41.40; author thl; state Exp; branches; next 1.13; 1.13 date 2002.10.14.15.17.22; author rse; state Exp; branches; next 1.12; 1.12 date 2002.10.14.13.25.42; author thl; state Exp; branches; next 1.11; 1.11 date 2002.10.03.08.13.29; author rse; state Exp; branches; next 1.10; 1.10 date 2002.10.02.17.31.51; author rse; state Exp; branches; next 1.9; 1.9 date 2002.10.02.14.18.16; author rse; state Exp; branches; next 1.8; 1.8 date 2002.10.02.13.35.45; author rse; state Exp; branches; next 1.7; 1.7 date 2002.09.30.15.21.37; author rse; state Exp; branches; next 1.6; 1.6 date 2002.09.26.19.48.43; author rse; state Exp; branches; next 1.5; 1.5 date 2002.09.25.15.17.09; author rse; state Exp; branches; next 1.4; 1.4 date 2002.09.25.15.11.16; author rse; state Exp; branches; next 1.3; 1.3 date 2002.09.24.19.03.41; author rse; state Exp; branches; next 1.2; 1.2 date 2002.09.24.18.52.55; author rse; state Exp; branches; next 1.1; 1.1 date 2002.09.13.14.32.44; author rse; state Exp; branches; next ; desc @@ 1.14 log @SYNOPSIS and FILES section @ text @ WebUI ===== http://www.template-toolkit.org/ ? Client ====== SOAP: - download writeable accounts - download all floating events - commit event(s) General ======= - Object: Individuals: User, Groups of Users and Groups, ... - Object: Reporting Lines: primary (budget), secondary (dotted lines), ... - Object: Projects: Dependencies, Auto-Adjust Deadlines, Subprojects, Milestones, ... - Object: External Resources: CVS Commits cvs:openpkg:2020 -> http://cvs.openpkg.org/cl?2002 ChangeLog-Machines host:www1-MUC1 -> ?? Tickets# ars:CW-00020202 -> http://as.is.eu.cw.com/ars?tk=CW-0020202 Customer# cus:searchname -> http://as.is.eu.cw.com/ars?cus=searchname URL ftp://..., http://.. - Task: Accounting: time on tasks, ... - Task: Reporting: Result-Oriented Status, MOF, ... Accounts ======== - central object, should be mostly dynamically managed - hierarchically sub-structured but with cross-references - access rights: read, write, admin - admin: create, rename, merge, split, freeze/unfreeze, destroy - types: abstract (for structuring), real (for accounting), virtual (for reporting; views) - read accumulation: is.meeting = is.dev.meeting+is.hst.meeting+is.prg.*.meeting - write diversion: is.prj.mof (what user uses) -> is.prj.mof.m2 (what admin wants) - auto-creation ala alt.* groups: is.em.rse.* -> autocreation of sub-accounts on-the-fly Access ====== - who is allowed to login to system - who is allowed to manipulate accounts - who is allowed to see reports about which accounts - who is allowed to account onto what (remember: proxy user, admin, assistence/boss) THL Idea: (container tree) as_membership: object/was child/inhalt as_trust: wer(trustee) wo(target) was(rwx) inheritance(y/n) as_security_equivalence: wer wo was(rwx) Company Structure ================= - Division - Team - Employee Remarks ======= - Remark field also useable for referencing customers in order to specify extra billing - see also DBTeam /public/timesheets/... - customer id also part of system Dialogs ======= - Accounting - - Reporting - Current State (Last Timeframe) - per employee - per team - per division - Progression State (History) - per employee - per team - per division - Administration - New User - Edit User - Delete User - Switch User - History Log - Session - login or logout via username,password - change password - change profile Accounts ======== Abstract is is.com Real: is.com.troubleshooting is.com.meeting is.com.support.internal (support for internal teams) is.com.support.external (support for external teams, customers, etc.) is.com.training.visit (visit Trainings, Circular Lessons, Educational Services) is.com.training.perform (perform Trainings, Circular Lessons, Educational Services) is.man.meeting (Management Meeting) is.man.mor.tk (Ticket Flow Reporting Project) is.man.mor.ru (Rack Utilization Reporting Project) is.prj.hh.meeting (Conference, Meeting) is.prj.hh.migration (Customer Migration Work) is.hosting.isod (ISOD Tasks) is.hosting.isow (ISOW Tasks) is.dev.ossp.pth (OSSP component development) is.dev.openpkg.pmod (OpenPKG PMOD/PSOD Tasks) is.dev.openpkg.re (OpenPKG release engineering) is.dev.openpkg.dev (OpenPKG package development) Virtual: com.meeting *.com.meeting com.support *.com.support com.support.internal *.com.support.internal com.support.external *.com.support.external prj.openpkg is.dev.openpkg.*,!is.dev.openpkg.dev Database Usage ============== -- INSERT INTO as_log (lg_entry) VALUES ('...entry text...'); -- SELECT lg_time,lg_entry FROM as_log WHERE lg_time >= 'yyyy-mm-dd' AND lg_time < 'yyyy-mm-dd' ORDER BY lg_time DESC; -- SELECT lg_time,lg_entry FROM as_log ORDER BY lg_time DESC LIMIT 20 OFFSET 10; Accounting/Acquisition ====================== - TxtUI (Vi) 2002-09 09 man.mor.tk 6 man.mor.ru 2 man.meeting 1.5 10 man.mor.ru 7 com.communication 30 com.support 30 IT com.support 30 Hosting 11 man.meeting 1 1:1 com.meeting 1 RUT man.mor.ru 6 - WebUI - JavaUI ZEPPELIN ======== only accounting tasks >= 15 minutes Accounts: - Allgemeine trouble meeting beratung/support schulung (alles was klein genug ist, dasz es nicht exakt accounted wird alles wofuer ein weiteres aufdroeseln nichts bringt fangen alles das auf, was nicht geplant ist, z.B. Trouble) - Projekte hierarchisch - Tasks/Anforderungen Accounting und Planung trennen! Planung: - jeder Mitarberbeiter hat einen Prozenzsatz (nominell) wo seine Zeit planbar ist (kann nicht 100% sein, wg. Meetings und Troubleshootings). Also der Teil der in Projekte und Tasks reinfallen kann. also wieviel % seiner Arbeitszeit er voraussichtlich(!) auf planbare Taetigkeiten. - Nicht Mitarbeiter kontrollieren, sondern System ist selbstschutz! Es geht nicht darum die 8 Stunden zu verteilen! Es ist ok, wenn jemand weniger angibt, da man Loesungsorientiert arbeiten soll! 2002-08 4 trouble 1,5 webconnect zertufukat expired meet 1 IV Gesamtmeeting fs.test.zugrifsschcht 1 urlden tabelle für inttest t-1347 4 ZEITNACHWEIS username date account-id minutes remark chrei 2002-08-04 123 90 webconnect zertufukat expired ACCOUNT account-id account-name 123 trouble USER user-id user-name chrei Christian Reiber # MySQL dump 8.14 # # Host: localhost Database: zivas2_prod #-------------------------------------------------------- # Server version 3.23.38-log # # Table structure for table 'Allgemein' # CREATE TABLE Allgemein ( AllgemeinID int(10) unsigned NOT NULL default '0', MasterID int(10) unsigned NOT NULL default '0', Status char(1) default NULL, Code char(50) default NULL, Beschreibung char(255) default NULL, PRIMARY KEY (AllgemeinID), KEY MasterID (MasterID) ) TYPE=MyISAM; # # Table structure for table 'Aufgabe' # CREATE TABLE Aufgabe ( AufgabeID int(10) unsigned NOT NULL default '0', Planungsmonat date NOT NULL default '0000-00-00', UserID char(5) NOT NULL default '', Aufwand int(10) unsigned default NULL, KontoID int(10) unsigned NOT NULL default '0', PRIMARY KEY (AufgabeID), KEY Monat (Planungsmonat), KEY UserID (UserID), KEY KontoID (KontoID) ) TYPE=MyISAM; # # Table structure for table 'CCM_Task' # CREATE TABLE CCM_Task ( ReleaseID char(10) NOT NULL default '', TaskID int(11) NOT NULL default '0', UserID char(5) NOT NULL default '', CcmID int(11) NOT NULL default '0', PRIMARY KEY (CcmID), KEY ITaskID (TaskID), KEY IReleaseID (ReleaseID) ) TYPE=MyISAM; # # Table structure for table 'Domaene' # CREATE TABLE Domaene ( DomID int(11) NOT NULL default '0', MasterID int(11) default NULL, Code char(10) default NULL, Beschreibung char(50) default NULL, PRIMARY KEY (DomID) ) TYPE=MyISAM; # # Table structure for table 'Fachbereich' # CREATE TABLE Fachbereich ( FachID int(11) NOT NULL default '0', MasterID int(11) default NULL, Code char(10) default NULL, Beschreibung char(50) default NULL, PRIMARY KEY (FachID) ) TYPE=MyISAM; # # Table structure for table 'Fehlzeit' # CREATE TABLE Fehlzeit ( UserID char(5) NOT NULL default '', Planungsmonat date NOT NULL default '0000-00-00', FehlzeitTyp char(10) NOT NULL default '', Fehlzeit int(11) default NULL, PRIMARY KEY (UserID,Planungsmonat,FehlzeitTyp) ) TYPE=MyISAM; # # Table structure for table 'Konto' # CREATE TABLE Konto ( KontoID int(10) unsigned NOT NULL default '0', AllgemeinID int(10) unsigned NOT NULL default '0', ProjektID int(10) unsigned NOT NULL default '0', TeilprojektID int(10) unsigned NOT NULL default '0', TaskID int(10) unsigned NOT NULL default '0', PRIMARY KEY (KontoID), KEY AllgemeinID (AllgemeinID), KEY TaskID (TaskID), KEY TeilprojektID (TeilprojektID), KEY ProjektID (ProjektID) ) TYPE=MyISAM; # # Table structure for table 'MitarbeiterIV' # CREATE TABLE MitarbeiterIV ( USERID char(5) NOT NULL default '', Name char(50) NOT NULL default '', IsIntern char(1) default NULL, Arbeitszeitfaktor decimal(4,2) default NULL, Produktivfaktor decimal(4,2) default NULL, PRIMARY KEY (USERID) ) TYPE=MyISAM; # # Table structure for table 'Planungsmonat' # CREATE TABLE Planungsmonat ( Monat date default NULL, Arbeitstage int(11) default NULL, Status char(1) default NULL ) TYPE=MyISAM; # # Table structure for table 'Projekt' # CREATE TABLE Projekt ( ProjektID int(10) unsigned NOT NULL default '0', MasterID int(10) unsigned NOT NULL default '0', Status char(1) default NULL, Code char(50) default NULL, Beschreibung char(255) default NULL, ProjektStart date default NULL, ProjektEnde date default NULL, PRIMARY KEY (ProjektID) ) TYPE=MyISAM; # # Table structure for table 'Release' # CREATE TABLE Release ( ReleaseID varchar(10) NOT NULL default '', Beschreibung varchar(255) NOT NULL default '', Releasemanager varchar(5) NOT NULL default '', Builtmanager varchar(5) NOT NULL default '', Termin varchar(10) NOT NULL default '', Status char(1) NOT NULL default '', AVler varchar(20) default NULL, PRIMARY KEY (ReleaseID) ) TYPE=MyISAM; # # Table structure for table 'Task' # CREATE TABLE Task ( TaskID int(10) unsigned NOT NULL default '0', MasterID int(10) unsigned default NULL, Code char(10) default NULL, Beschreibung char(255) default NULL, AufwandSoll int(10) unsigned default NULL, Status char(1) default NULL, StatusText char(20) default NULL, ReleaseID char(10) default NULL, ApplixNR int(10) unsigned default NULL, Bereich char(15) default NULL, Ansprechpartner char(15) default NULL, Dom char(1) default NULL, FIX_Datum date default NULL, Plan_Datum date default NULL, Erfasst_Datum date default NULL, Erfasst_von char(5) default NULL, Erledigt_Datum date default NULL, Erledigt_von char(5) default NULL, Dokument char(20) default NULL, CCMNR int(10) default NULL, PRIMARY KEY (TaskID) ) TYPE=MyISAM; # # Table structure for table 'Teilprojekt' # CREATE TABLE Teilprojekt ( TeilprojektID int(10) unsigned NOT NULL default '0', MasterID int(10) unsigned NOT NULL default '0', ProjektID int(10) unsigned NOT NULL default '0', Status char(1) default NULL, Code char(50) default NULL, Beschreibung char(255) default NULL, AufwandSoll int(10) unsigned NOT NULL default '0', PRIMARY KEY (TeilprojektID), KEY MasterID (MasterID), KEY ProjektID (ProjektID) ) TYPE=MyISAM; # # Table structure for table 'Zeitnachweis' # CREATE TABLE Zeitnachweis ( ZeitnachweisID int(10) unsigned NOT NULL auto_increment, USERID char(5) NOT NULL default '', Tagesdatum date NOT NULL default '0000-00-00', Aufwand int(10) unsigned NOT NULL default '0', KontoID int(10) unsigned NOT NULL default '0', Bemerkung char(255) default NULL, FachbereichID int(11) default NULL, PRIMARY KEY (ZeitnachweisID), KEY UserID (USERID), KEY KontoID (KontoID), KEY Tagesdatum (Tagesdatum), KEY I_TagesdatumUserID (Tagesdatum,USERID) ) TYPE=MyISAM; ============================================================================ -- System Configuration CREATE TABLE as_config ( cf_version TEXT, -- data model version cf_name TEXT PRIMARY KEY, -- variable name cf_value TEXT -- variable value ); -- External Resource CREATE TABLE as_resource ( rs_id TEXT, rs_url TEXT ); -- System Themes CREATE TABLE as_theme ( th_name TEXT, -- name of theme th_color_1_bg CHAR(6), -- RGB of color level #1 (background) th_color_1_fg CHAR(6), -- RGB of color level #1 (foreground) th_color_2_bg CHAR(6), -- RGB of color level #2 (background) th_color_2_fg CHAR(6), -- RGB of color level #2 (foreground) th_color_3_bg CHAR(6), -- RGB of color level #3 (background) th_color_3_fg CHAR(6), -- RGB of color level #3 (foreground) th_color_4_bg CHAR(6), -- RGB of color level #4 (background) th_color_4_fg CHAR(6), -- RGB of color level #4 (foreground) th_color_5_bg CHAR(6), -- RGB of color level #5 (background) th_color_5_fg CHAR(6) -- RGB of color level #5 (foreground) ); -- System Sessions CREATE TABLE as_session ( se_session_id TEXT PRIMARY KEY, -- session id se_user_id INTEGER NOT NULL, -- associated user se_expire_time TIMESTAMP (0) WITHOUT TIME ZONE NOT NULL -- expire time ); -- Reporting CREATE TABLE as_reporting ( re_id TEXT PRIMARY KEY, -- user id re_transitive TEXT, -- report receiver is allowed to re-report re_other TEXT, -- user id of receiver user re_account TEXT, -- root of reported accounts re_read_accu TEXT -- read accumulation -- [is.dev.meeting,is.hst.meeting,is.prg.*.meeting,!is.dev.meeting.foo] ); us_leader TEXT, -- leader of his group(s) [yes] us_admin TEXT, -- administrator of group (s) [yes] us_theme TEXT, -- WebUI theme [default] @ 1.13 log @flush work of today @ text @a9 42 $HOME/.as/lock: %!AS-LOCK- $HOME/.as/serial: %!AS-SERIAL- ${HOME}/.as/as_event %!AS-EVENTS- [# ] rse f81d4fae-7dec-11d0-a765-00a0c91e6bf6 XXXXXXXX 42 2002-10-01 00:00 24:00 03:00 /de/is/com/absence "blah blah" # ERROR: 49 200210-01 x x x ${HOME}/.as/as_account %!AS-ACCOUNTS- A / "ROOT" A /de "Deutschland" A /de/is "Internet Services" R /de/is/com "Common" R /de/is/com/absence "[A] approved absence" ${HOME}/.as/rc: UserName rse Password foobar SOAPServer http://as.is.eu.cw.com/soap DefaultMode commit $ as ... -o|--option=var=val ... $ as -d|--download $ as -u|--update $ as -q|--query $ as [-c|--commit] [-D|--date=]