[PhpHelpdesk-devel] How to Contribute to Development ?

[nicholas b. <nik...@ac...>]

I will be the first to confess that my CVS skills are somewhat lacking. However I 
have made some modifications to phphelpdesk to answer requirements spefic to a 
company which operates a HelpDesk service to other Companies. Obviously I need to 
allow all companies for all users, I need to track billing of customers and allow 
all users to assign and modify other companies.. So heres the changes I made so far 
more explanation available if requested. but questions are.

1. How to contribute changes
2. How to avoid forking the code 
3. how to keep it clear ?

 - 2002-07-23 -
        modified line 345 in addjob.scp.php to allow for ll companies
         if($g_dept_or_comp==0) {
             $query = "SELECT d_name FROM userdepartments WHERE s_user='$user';";
                 } else {
                     $query = "SELECT d_name FROM userdepartments GROUP BY d_name 
ORDER By d_name;";
                         }


        modified line 20 in checkuser.inc.php
                if($g_dept_or_comp==0) {
                          $query .= "WHERE s_user='$user';";
                                    }


        modified line 43,65 in permissions.inc.php to read

         if($g_dept_or_comp==0){ $query2 .= "WHERE s_user=\"$user\" }

             $query2 .= " order by d_name;";



        also modifed the  queries so that they can handle group by
        cluase becuase some user are adding duplicates.



        all this allows groups users for one comapny to register
        companies as a whole.

        also I want to allow all users to be assigned
        and from here they need to be able to asign users.


        to this end addjob.scp.php line 275 modified to
         if($g_dept_or_comp==0) {
               $query = "SELECT userdepartments.s_user, security.s_update_tickets ";
                     $query .= "FROM userdepartments, security ";
                           $query .= "WHERE 
userdepartments.d_name='$lstChooseCompany' ";
                                 $query .= "AND security.s_update_tickets='1'";
                                       $query .= "AND security.s_user = 
userdepartments.s_user";
                                             } else {
                                                     $query = "SELECT s_user from 
security where s_update_tickets=1 order by s_user;";
                                                           }
- 2002-07-21 -
        - add department_id to department, as Unique ID.
                alter table department drop primary key
                alter table department add department_id auto_increment primary key;

        - add department_details to tables.
        create table department_details ( id int auto_increment primary key, 
address mediumtext, oncontract enum("Y","N"), contractend date);
                        id              uniq field
                        address         address deails
                        oncontract      y/n for billing purposes
                        contractend     for edn contract notes.


        - add billing_action
        create table billing_action ( id int auto_increment primary key, action char
(100), code int);

        id              uniq field
        action          char field to define billing action
        code            cause its easier to find later !

        - alter table events, added ba_code
        alter table events add ba_code int after e_description;

        amended the vj_viewjobs and vj_addevent to reflect the
        additional select list called lstBilling which lists items
        from billin_action and records code value in events table



        I am assuming that the duration is decimal, and . refer to minutes
        so change 90 minutes to 1.3
        :





-- 
--
Nik Butler
Technical Director
Actus IT
nik...@ac...