ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / ticketing.nipponia.com / include

<?php
/*********************************************************************
    class.knowledgebase.php

Backend support for knowledgebase creates, edits, deletes, and
    attachments.

Released under the GNU General Public License WITHOUT ANY WARRANTY.
    See LICENSE.TXT for details.

vim: expandtab sw=4 ts=4 sts=4:
**********************************************************************/
require_once("class.file.php");

class Knowledgebase {

function __construct($id) {
        $res=db_query(
            'SELECT title, isenabled, dept_id, created, updated '
           .'FROM '.CANNED_TABLE.' WHERE canned_id='.db_input($id));
        if (!$res || !db_num_rows($res)) return false;
        list(   $this->title,
                $this->enabled,
                $this->department,
                $this->created,
                $this->updated) = db_fetch_row($res);
        $this->id = $id;
        $this->_attachments = new AttachmentList(
            CANNED_ATTACHMENT_TABLE, 'canned_id='.db_input($id));
    }

/* ------------------> Getter methods <--------------------- */
    function getTitle() { return $this->title; }
    function isEnabled() { return !!$this->enabled; }
    function getAnswer() {
        if (!isset($this->answer)) {
            if ($res=db_query('SELECT answer FROM '.CANNED_TABLE
                    .' WHERE canned_id='.db_input($this->id))) {
                list($this->answer)=db_fetch_row($res);
            }
        }
        return $this->answer;
    }
    function getCreated() { return $this->created; }
    function lastUpdated() { return $this->updated; }
    function attachments() { return $this->_attachments; }
    function getDeptId() { return $this->department; }
    function getDepartment() { return new Dept($this->department); }
    function getId() { return $this->id; }

/* ------------------> Setter methods <--------------------- */
    function publish() { $this->published = true; }
    function unpublish() { $this->published = false; }
    function setPublished($val) { $this->published = !!$val; }
    function setEnabled($val) { $this->enabled = !!$val; }
    function setTitle($title) { $this->title = $title; }
    function setKeywords($words) { $this->keywords = $words; }
    function setAnswer($text) { $this->answer = $text; }
    function setDepartment($id) { $this->department = $id; }

/* -------------> Validation and Clean methods <------------ */
    function validate(&$errors, $what=null) {
        if (!$what) $what=$this->getHashtable();
        else $this->clean($what);
        # TODO: Validate current values ($this->yada)
        # Apply hashtable to this -- return error list
        $validation = array(
            'title' => array('is_string', __('Title is required'))
        );
        foreach ($validation as $key=>$details) {
            list($func, $error) = $details;
            if (!call_user_func($func, $what[$key])) {
                $errors[$key] = $error;
            }
        }
        return count($errors) == 0;
    }

function clean(&$what) {
        if (isset($what['topic']))
            $what['topic']=Format::striptags(trim($what['topic']));
    }

function getHashtable() {
        # TODO: Return hashtable like the one that would be passed into
        #       $this->save() or self::create()
        return array('title'=>$this->title, 'department'=>$this->department,
            'isenabled'=>$this->enabled);
    }

/* -------------> Database access methods <----------------- */
    function update() {
        if (!@$this->validate()) return false;
        db_query(
            'UPDATE '.CANNED_TABLE.' SET title='.db_input($this->title)
                .', isenabled='.db_input($this->enabled)
                .', dept_id='.db_input($this->department)
                .', updated=NOW()'
                .((isset($this->answer))
                    ? ', answer='.db_input($this->answer) : '')
                .' WHERE canned_id='.db_input($this->id));
        return db_affected_rows() == 1;
    }
    function delete() {
        db_query('DELETE FROM '.CANNED_TABLE.' WHERE canned_id='
            .db_input($this->id));
        return db_affected_rows() == 1;
    }
    /* For ->attach() and ->detach(), use $this->attachments() */
    function attach($file) { return $this->_attachments->add($file); }
    function detach($file) { return $this->_attachments->remove($file); }

/* ------------------> Static methods <--------------------- */
    function create($hash, &$errors) {
        if (!self::validate($hash, $errors)) return false;
        db_query('INSERT INTO '.CANNED_TABLE
            .' (title, answer, department, isenabled, created, updated) VALUES ('
            .db_input($hash['title']).','
            .db_input($hash['answer']).','
            .db_input($hash['dept']).','
            .db_input($hash['isenabled']).',NOW(),NOW()');
        return db_insert_id();
    }

function save($id, $new_stuff, &$errors) {
        if (!$id) return self::create($new_stuff, $errors);
        if (!self::validate($errors, $new_stuff)) return false;

# else
        if (!($obj = new Knowledgebase($id))) { return false; }
        $obj->setEnabled($new_stuff['enabled']);
        $obj->setTitle($new_stuff['title']);
        $obj->setAnswer($new_stuff['answer']);
        $obj->setDepartment($new_stuff['dept']);

return $obj->update();
    }

function findByTitle($title) {
        $res=db_query('SELECT canned_id FROM '.CANNED_TABLE
            .' WHERE title LIKE '.db_input($title));
        if (list($id) = db_fetch_row($res)) {
            return new Knowledgebase($id);
        }
        return false;
    }

function lookup($id) {
        return ($id && is_numeric($id) && ($obj= new Knowledgebase($id)) && $obj->getId()==$id)
            ? $obj : null;
    }
}

[+] ..
[-] class.model.php [edit]
[-] ajax.i18n.php [edit]
[-] class.json.php [edit]
[-] class.mime.php [edit]
[-] class.orm.php [edit]
[-] class.dept.php [edit]
[-] ajax.filter.php [edit]
[-] api.tickets.php [edit]
[-] ajax.note.php [edit]
[-] class.2fa.php [edit]
[-] class.setup.php [edit]
[-] ajax.orgs.php [edit]
[-] class.format.php [edit]
[-] class.message.php [edit]
[-] class.xml.php [edit]
[-] class.priority.php [edit]
[-] class.app.php [edit]
[-] index.php [edit]
[-] ajax.forms.php [edit]
[-] ajax.config.php [edit]
[-] ajax.tickets.php [edit]
[-] ajax.content.php [edit]
[-] class.file.php [edit]
[-] ajax.email.php [edit]
[-] class.cli.php [edit]
[-] class.company.php [edit]
[-] class.mailer.php [edit]
[-] class.list.php [edit]
[-] class.canned.php [edit]
[-] class.client.php [edit]
[+] upgrader
[-] class.csrf.php [edit]
[-] ost-sampleconfig.php [edit]
[-] class.http.php [edit]
[-] ajax.staff.php [edit]
[-] class.search.php [edit]
[-] JSON.php [edit]
[-] class.avatar.php.bak [edit]
[-] class.error.php [edit]
[-] class.mail.php [edit]
[-] class.sla.php [edit]
[-] class.draft.php [edit]
[-] class.dispatcher.php [edit]
[-] class.note.php [edit]
[-] class.mailparse.php [edit]
[-] class.filter_action.php [edit]
[-] class.queue.php [edit]
[-] class.i18n.php [edit]
[-] class.osticket.php [edit]
[-] ajax.users.php [edit]
[-] class.staff.php [edit]
[+] fpdf
[-] class.crypto.php [edit]
[+] laminas-mail
[-] class.misc.php [edit]
[-] class.auth.php [edit]
[-] html2text.php [edit]
[-] class.translation.php [edit]
[-] class.util.php [edit]
[-] class.schedule.php [edit]
[-] class.banlist.php [edit]
[-] class.config.php [edit]
[-] ajax.upgrader.php [edit]
[+] mpdf
[-] class.email.php [edit]
[-] ajax.admin.php [edit]
[+] config
[-] ajax.thread.php [edit]
[-] class.user.php [edit]
[-] class.passwd.php [edit]
[-] class.import.php [edit]
[+] client
[-] ajax.tips.php [edit]
[-] tnef_decoder.php [edit]
[-] class.oauth2.php [edit]
[-] class.plugin.php [edit]
[-] class.timezone.php [edit]
[-] class.ticket.php [edit]
[-] class.nav.php [edit]
[-] class.category.php [edit]
[-] class.charset.php [edit]
[+] cli
[-] class.cron.php [edit]
[-] class.captcha.php [edit]
[-] class.dynamic_forms.php [edit]
[-] class.faq.php [edit]
[+] plugins
[-] class.pdf.php [edit]
[-] ajax.schedule.php [edit]
[-] class.usersession.php [edit]
[-] class.topic.php [edit]
[-] class.base32.php [edit]
[-] htmLawed.php [edit]
[-] ajax.sequence.php [edit]
[+] i18n
[-] class.signal.php [edit]
[-] class.mailfetch.php [edit]
[-] UniversalClassLoader.php [edit]
[-] class.sequence.php [edit]
[-] class.businesshours.php [edit]
[-] class.role.php [edit]
[+] pear
[-] class.yaml.php [edit]
[-] Spyc.php [edit]
[-] mysqli.php [edit]
[-] class.thread_actions.php [edit]
[-] class.export.php [edit]
[-] ajax.plugins.php [edit]
[-] class.collaborator.php [edit]
[-] class.ostsession.php [edit]
[+] staff
[-] class.attachment.php [edit]
[-] class.template.php [edit]
[-] class.filter.php [edit]
[-] class.controller.php [edit]
[-] class.team.php [edit]
[-] class.session.php [edit]
[-] class.avatar.php [edit]
[-] ajax.kbase.php [edit]
[-] class.variable.php [edit]
[-] class.validator.php [edit]
[-] ajax.tasks.php [edit]
[-] class.upgrader.php [edit]
[-] class.page.php [edit]
[-] ajax.export.php [edit]
[-] ajax.search.php [edit]
[-] PasswordHash.php [edit]
[-] class.report.php [edit]
[-] class.forms.php [edit]
[-] class.task.php [edit]
[-] class.migrater.php [edit]
[-] class.lock.php [edit]
[-] class.organization.php [edit]
[-] class.pagenate.php [edit]
[-] api.cron.php [edit]
[-] class.api.php [edit]
[-] class.thread.php [edit]
[-] class.knowledgebase.php [edit]
[-] .MANIFEST [edit]
[-] class.log.php [edit]
[-] ajax.draft.php [edit]
[-] class.ajax.php [edit]
[-] ost-config.php [edit]
[-] txets.php [edit]
[-] .htaccess.disabled [edit]