1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 |
- <?php
- class TicketPlugin extends Plugin
- {
-
- public static function create()
- {
- static $result = null;
- return $result ? $result : $result = new self();
- }
-
- protected function __construct()
- {
- $settings = array(
- 'tool_enable' => 'boolean',
- 'allow_student_add' => 'boolean',
- 'allow_category_edition' => 'boolean',
- 'warn_admin_no_user_in_category' => 'boolean',
- 'send_warning_to_all_admins' => 'boolean'
- );
- parent::__construct(
- '3.0',
- 'Kenny Rodas Chavez, Genesis Lopez, Francis Gonzales, Yannick Warnier, Julio Montoya',
- $settings
- );
- }
-
- public function install()
- {
-
- require_once api_get_path(SYS_PLUGIN_PATH) . PLUGIN_NAME . '/database.php';
- }
-
- public function uninstall()
- {
- $tblSettings = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
- $tblTicketTicket = Database::get_main_table(TABLE_TICKET_TICKET);
- $tblTicketStatus = Database::get_main_table(TABLE_TICKET_STATUS);
- $tblTicketProject = Database::get_main_table(TABLE_TICKET_PROJECT);
- $tblTicketPriority = Database::get_main_table(TABLE_TICKET_PRIORITY);
- $tblTicketMesAttch = Database::get_main_table(TABLE_TICKET_MESSAGE_ATTACHMENTS);
- $tblTicketMessage = Database::get_main_table(TABLE_TICKET_MESSAGE);
- $tblTicketCategory = Database::get_main_table(TABLE_TICKET_CATEGORY);
- $tblTicketAssgLog = Database::get_main_table(TABLE_TICKET_ASSIGNED_LOG);
- $settings = $this->get_settings();
- $plugSetting = current($settings);
-
- $sql = "DELETE FROM $tblSettings WHERE variable = 'ticket_tool_enable'";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketTicket";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketStatus";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketProject";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketPriority";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketMesAttch";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketMessage";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketCategory";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketAssgLog";
- Database::query($sql);
- $sql = "DROP TABLE IF EXISTS $tblTicketTicket";
- Database::query($sql);
- $rsTab = $this->deleteTab($plugSetting['comment']);
- if ($rsTab) {
- echo "<script>location.href = '" . $_SERVER['REQUEST_URI'] . "';</script>";
- }
- }
- }
|