chamilo / chamilo-lms

        }

        // Search simple

        if (isset($_GET['submit_simple']) && $_GET['keyword'] != '') {

            $keyword = Database::escape_string(trim($_GET['keyword']));

            $sql .= " AND (

                      ticket.id LIKE '%$keyword%' OR

                      ticket.code LIKE '%$keyword%' OR

                      ticket.subject LIKE '%$keyword%' OR

                      ticket.message LIKE '%$keyword%' OR

                      ticket.keyword LIKE '%$keyword%' OR

                      ticket.source LIKE '%$keyword%' OR

                      ticket.personal_email LIKE '%$keyword%'                          

            )";

        }

        // Search advanced

        if (isset($_GET['submit_advanced'])) {

        }

        // Search simple

        if (isset($_GET['submit_simple'])) {

            if ($_GET['keyword'] != '') {

                $keyword = Database::escape_string(trim($_GET['keyword']));

                $sql .= " AND (

                          ticket.code LIKE '%$keyword%' OR

                          ticket.subject LIKE '%$keyword%' OR

                          ticket.message LIKE '%$keyword%' OR

                          ticket.keyword LIKE '%$keyword%' OR

                          ticket.personal_email LIKE '%$keyword%' OR

                          ticket.source LIKE '%$keyword%'

                )";

            }

        }

        // Search advanced

        if (isset($_GET['submit_advanced'])) {

                    AND ticket.status_id = status.id

                    AND user.user_id = ticket.request_user ";

        // Search simple

        if (isset($_GET['submit_simple'])) {

            if ($_GET['keyword'] !== '') {

                $keyword = Database::escape_string(trim($_GET['keyword']));

                $sql .= " AND (ticket.code = '$keyword'

                          OR user.firstname LIKE '%$keyword%'

                          OR user.lastname LIKE '%$keyword%'

                          OR concat(user.firstname,' ',user.lastname) LIKE '%$keyword%'

                          OR concat(user.lastname,' ',user.firstname) LIKE '%$keyword%'

                          OR user.username LIKE '%$keyword%')  ";

            }

        }

        //Search advanced

        if (isset($_GET['submit_advanced'])) {

            $keyword_category = Database::escape_string(

        $access_url_rel_user_table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

        $sql .= " INNER JOIN $access_url_rel_user_table url_rel_user ON (u.user_id=url_rel_user.user_id)";

    }

    if (isset($_GET['keyword'])) {

        $keyword = Database::escape_string(trim($_GET['keyword']));

        $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR

                  u.lastname LIKE '%$keyword%'  OR

                  concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR

                  concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR

                  u.username LIKE '%$keyword%' OR

                  u.email LIKE '%$keyword %'  OR

                  u.official_code LIKE '%$keyword%') ";

    }

    $res = Database::query($sql);

    $obj = Database::fetch_object($res);

    return $obj->total_number_of_items;

              u.expiration_date AS exp

           FROM $user_table u ";

    if (isset($_GET['keyword'])) {

        $keyword = Database::escape_string(trim($_GET['keyword']));

        $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR

                  u.lastname LIKE '%$keyword%' OR

                  concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR

                  concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR

                  u.username LIKE '%$keyword%'  OR

                  u.official_code LIKE '%$keyword%'

                  OR u.email LIKE '%$keyword%' )";

    }

    if (!in_array($direction, array('ASC', 'DESC'))) {

        $direction = 'ASC';

    }