if(t==this){ t.xxtree269.setDefer(); }else{ t.xxtree269.setSubload(); t.xxtree269.emptyNodes(); t.xxtree269.setUndefer(); } t.xxtree269.add(269,-1,'Examples',''); t.xxtree269.add(339,269,'First example: world','It\'s a programme to see the data from the "world" database avaible on the MySql<\/a> website.\n
\n
\nThe database design is this one.\n
\n\n
\n
\nClick \n here<\/a> to test this.\n
\n
\n'); t.xxtree269.add(271,269,'Second example: CRM','This program is a little CRM for IT services providers to give the possibility to client companies to manage their own contacts.\n
\n
\nEvery company will have a main user called manager in the rest.\n
\nThe manager creates the contacts ( first name, name ....) \n
\nThe manager defines informations that will be linked to the concacts according to the company needs.\n
\n
\nThese informations are two types:\n
\nEvent: it is a meeting, a meal at one date.\n
\nRelation: it is a fact concerning the contact like he is important, medium, small, he speaks french, english, or italien ...\n
\n
\nThe list of contacts is unique for every company, and it will be shared between the company users with relation with the contacts.\n
\n
\nThe manager defines the users ( login, name last name, password ).\n
\n
\nThe user will have a list of contacts that he will pick from the list of contacts of the company.\n
\n
\nFor every contact, he will be able to add relations or events that the manager hed previously defined.\n
\n
\nA contact can be shared by several users.\n
\n
\nA request system allow the user to list among his own contacts the ones that satisfy certains relation. The result of these requests can be combined with AND, OR, NOT, XOR functions.\n
\n
\nThe manager can do requests on all contacts of the company.\n
\nThe data design is the one under.\n\n
\n<\/a>\n<\/div>\n\n
\n
\nYou can see the general documentation ( normaly there is one specific for every type of user )\nclicking here <\/a>.\n
\n
\nIf you want to try it online, send me a mail with the contact page of this site and I will send you a login/password.\nThis programm can be reached here <\/a>.\n
\n
\nIt\'s only a little CRM but you have seen the possibility of MyPitSelf.\n
\n
\nI didn\'t want to load this program with many buttons but it\'s quite easy to add for example the list of user that use a contact from the contact file. \n
\n
\nOne can add also company tables, links between companies and contacts and many other things that require a little more programming.\n
\n
\nA bientôt.\n
\n\n\n'); t.xxtree269.add(14,269,'Third example','Now we are going to use this examples to see the use of this system. \n
\nThe aim is to build a program in this environment. \n
\nThere is a minimal set of explanations. Don\'t worry if you don\'t catch all of them, it will come later. \n
\nThe project approach will have three different layers : \n
\n
\n\nOrganisation layer ( Client needs ) \n<\/span>\n
\nThe client wants to have a system to do his task list. Each user of the system will be able to put some new tasks in the system with a name and a priority level. The priority level is a number and each user will be able to see the task list according to its priority level. \n
\nThe client also wants to find tasks according defined sequences ( word match research ). \n
\nSome users ( eg managers ) must be able to see the tasks of all other users but most of then will see only their own tasks. \n
\nA user can modify each task ( priority and text ), add or delete one. \n
\n
\n\nFunctional layer ( what do we have to do ) \n<\/span>\n
\nA Task table with a user ID, a task name and a task priority. \n
\nA user table with the user ID, his logging name, first name and last name. \n
\n
\nWe will need to have a function to display a list of tasks according to its priority and according to the fact that the task contains a certain word. From this list, one will be able to create new tasks, modify existing ones or delete them. \n
\nAn other functon ( manager ) will display a task list with the user name. \n
\nSo according to the user profile, differents menu will be displayed. \n
\nUser: See my tasks Manager: See my tasks, see all tasks \n
\n
\nA super user will have the possibility to enable other users and to assign them a user level ( manager or user ). \n
\nA manager will be considered as a user for his ( or her ) own tasks. \n
\n
\n\nTechnical layer ( how are we going to do this ? ). \n<\/span>\n
\nSee the next chapters. \n
\n
\nComment:<\/u><\/em><\/strong> \nDuring the modification of a record, a lock is set up and during the next procedures, you might close windows during a modification and so, the lock will remain. \n
\nTo take it off, go to the Profil<\/a> menu then choose the option \nSee the locks<\/a> then click on the Unlock<\/a> button. \n'); t.xxtree269.add(15,14,'A new environment','
\nClick here to open a new window on MyPitSelf <\/a>, \nenter 1/1 as username / password \n
\n
\nThe first thing to do is to create a new environment. \n
\n
\nNote: for the moment, I have not worked enough on the privileges on the database so there is not a fine tunning of them. \n
\nThe way it works is to define for each environment a mysql user/password ( or have always the same one ) and authorizations are set um for this user. \n
\nI advise you to use MyPitSelfDev, it works ! \n\n
\n
\nTo do this, click here <\/a> and perform the actions described. \n
\n
\nTo create a new environment means to create directories and a system database. ( look in folders mypitselfp and mypitselfw )\n'); t.xxtree269.add(71,14,'A new manager','\nClick here to open a window if it\'s not already open.<\/a> on the MyPitSelf environment and log in as 1/1. \n
\n
\nWe have to create a manager who will have the ability to use the new environment. \n
\nFor the moment, there are 3 profiles in MyPitSelf: \n