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...
|
