PHP Classes

File: include/search.inc.php

Recommend this page to a friend!
  Classes of Gregory Mage   xmdoc   include/search.inc.php   Download  
File: include/search.inc.php
Role: Example script
Content type: text/plain
Description: Example script
Class: xmdoc
XOOPS CMS module to manage files attached to posts
Author: By
Last change:
Date: 3 years ago
Size: 2,454 bytes
 

Contents

Class file image Download
<?php
/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/

/**
 * xmdoc module
 *
 * @copyright XOOPS Project (https://xoops.org)
 * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
 * @author Mage Gregory (AKA Mage)
 */
use Xmf\Module\Helper;

function
xmdoc_search($queryarray, $andor, $limit, $offset, $userid)
{
    global
$xoopsDB;

   
$sql = "SELECT document_id, document_category, document_name, document_description, document_date, document_userid FROM " . $xoopsDB->prefix("xmdoc_document") . " WHERE document_status = 1";
   
    if (
$userid != 0 ) {
       
$sql .= " AND document_userid=" . intval($userid) . " ";
    }
   
   
xoops_load('utility', 'xmdoc');
   
$viewPermissionCat = XmdocUtility::getPermissionCat('xmdoc_view');
    if(!empty(
$viewPermissionCat)) {
       
$sql .= ' AND document_id IN ('.implode(',', $viewPermissionCat).') ';
    } else {
        return
null;
    }
   
    if (
is_array($queryarray) && $count = count($queryarray) )
    {
       
$sql .= " AND ((document_name LIKE '%$queryarray[0]%' OR document_description LIKE '%$queryarray[0]%')";

        for(
$i=1;$i<$count;$i++)
        {
           
$sql .= " $andor ";
           
$sql .= "(document_name LIKE '%$queryarray[$i]%' OR document_description LIKE '%$queryarray[$i]%')";
        }
       
$sql .= ")";
    }

   
$sql .= " ORDER BY document_date DESC";
   
$result = $xoopsDB->query($sql,$limit,$offset);
   
$ret = array();
   
$i = 0;
   
$helper = Helper::getHelper('xmdoc');
    while(
$myrow = $xoopsDB->fetchArray($result))
    {
       
$ret[$i]["image"] = "assets/images/xmdoc_search.png";
        if (
$helper->getConfig('general_usemodal', 1) == 1){
           
$ret[$i]["link"] = "download.php?doc_id=" . $myrow["document_id"] . '&cat_id=' . $myrow["document_category"];
        } else {
           
$ret[$i]["link"] = "document.php?doc_id=" . $myrow["document_id"];
        }
       
$ret[$i]["title"] = $myrow["document_name"];
       
$ret[$i]["time"] = $myrow["document_date"];
       
$ret[$i]["uid"] = $myrow["document_userid"];
       
$i++;
    }

    return
$ret;
}