Require an experience php / mysql programmer to develop in house ticketing system monitoring customer call in for software support.
1. Instant Search for customer displaying valid contract with assign button to support personnel, customer contact person, telephone that allow to edit
2. Ticketing menu showing support personnel assigned task with customers name, telephone, person in charge, time, date assigned with color defining the time past and closed and re-assign button. (Normal color < 1/2 hour, Yellow >1/2 < 2 hours, Red > 2 hours)
4. User Permission to edit and re-assign