show_search_parts.php

<?php
/*
    part-db version 0.1
    Copyright (C) 2005 Christoph Lechner
    http://www.cl-projects.de/

    part-db version 0.2+
    Copyright (C) 2009 K. Jacobs and others (see authors.php)
    http://code.google.com/p/part-db/

    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.

    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.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
*/

include_once('start_session.php');
/** @noinspection PhpIncludeInspection */
include_once(BASE.'/inc/lib.export.php');

use PartDB\Database;
use PartDB\HTML;
use PartDB\Log;
use PartDB\Part;
use PartDB\User;

$messages = array();
$fatal_error = false; // if a fatal error occurs, only the $messages will be printed, but not the site content

/********************************************************************************
 *
 *   Evaluate $_REQUEST
 *
 *********************************************************************************/

$part_id                = isset($_REQUEST['selected_id'])       ? (integer)$_REQUEST['selected_id']     : 0;
$keyword                = isset($_REQUEST['keyword'])           ? trim((string)$_REQUEST['keyword'])    : '';
$search_name            = isset($_REQUEST['search_name']);
$search_category        = isset($_REQUEST['search_category']);
$search_description     = isset($_REQUEST['search_description']);
$search_comment         = isset($_REQUEST['search_comment']);
$search_supplier        = isset($_REQUEST['search_supplier']);
$search_supplierpartnr  = isset($_REQUEST['search_supplierpartnr']);
$search_storelocation   = isset($_REQUEST['search_storelocation']);
$search_footprint       = isset($_REQUEST['search_footprint']);
$search_manufacturer    = isset($_REQUEST['search_manufacturer']);
$table_rowcount         = isset($_REQUEST['table_rowcount'])    ? (integer)$_REQUEST['table_rowcount']  : 0;

$groupby                = isset($_REQUEST['groupby']) ? (string)$_REQUEST['groupby'] : "categories";

$export_format_id       = isset($_REQUEST['export_format'])     ? (integer)$_REQUEST['export_format']   : 0;

$disable_pid_input      = isset($_REQUEST['disable_pid_input']);

$regex_search           = isset($_REQUEST['regex']);

$action = 'default';
if (isset($_REQUEST['export'])) {
    $action = 'export';
}
$selected_part_id = 0;
for ($i=0; $i<$table_rowcount; $i++) {
    if (isset($_POST['decrement_'.$i])) {
        $action = 'decrement';
        $selected_part_id = isset($_POST['id_'.$i]) ? (integer)$_POST['id_'.$i] : 0;
    }

    if (isset($_POST['increment_'.$i])) {
        $action = 'increment';
        $selected_part_id = isset($_POST['id_'.$i]) ? (integer)$_POST['id_'.$i] : 0;
    }
}

if (isset($_REQUEST['hint'])) {
    $action = "hint";
}

/********************************************************************************
 *
 *   Initialize Objects
 *
 *********************************************************************************/

$html = new HTML($config['html']['theme'], $user_config['theme'], 'Suchresultate');

try {
    $database           = new Database();
    $log                = new Log($database);
    $current_user       = User::getLoggedInUser($database, $log);

    if ($selected_part_id > 0) {
        $part = new Part($database, $current_user, $log, $selected_part_id);
    } else {
        $part = null;
    }

    if (!empty($keyword)) {
        $html->setTitle(_('Suchresultate') . ": " . $keyword);
    }

    //Remember what page user visited, so user can return there, when he deletes a part.
    session_start();
    $_SESSION["part_delete_last_link"] = $_SERVER['REQUEST_URI'];
    session_write_close();
} catch (Exception $e) {
    $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
    $fatal_error = true;
}

/********************************************************************************
 *
 *   Execute actions
 *
 *********************************************************************************/

if (! $fatal_error) {
    if (!$disable_pid_input) {
        $matches = array();
        if (preg_match('/^\$L(\d{5,})/', $keyword, $matches) == 1) {
            if (count($matches) > 1) {
                $lid = (integer) $matches[1];
                header("Location: show_location_parts.php?lid=" . $lid);
            }
        }

        //Check if keyword is a pid from a barcode scanner or so
        //This is the case if the input only contains digits and is 8 or 9 chars long
        if (is_numeric($keyword) && (mb_strlen($keyword) == 7 || mb_strlen($keyword) == 8)) {
            if (mb_strlen($keyword) == 8) {
                //Remove parity
                $keyword = substr($keyword, 0, -1);
            }
            $pid = (integer) $keyword;
            header("Location: show_part_info.php?pid=" . $pid);
        }
    }

    switch ($action) {
        case 'decrement': // remove one part
            try {
                if (! is_object($part)) {
                    throw new Exception('Es wurde keine gültige Bauteil-ID übermittelt!');
                }

                $part->withdrawalParts(1);

                $reload_site = true;
            } catch (Exception $e) {
                $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
            }
            break;

        case 'increment': // add one part
            try {
                if (! is_object($part)) {
                    throw new Exception('Es wurde keine gültige Bauteil-ID übermittelt!');
                }

                $part->addParts(1);

                $reload_site = true;
            } catch (Exception $e) {
                $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
            }
            break;

        case 'export':
            try {
                $parts = Part::searchParts(
                    $database,
                    $current_user,
                    $log,
                    $keyword,
                    '',
                    $search_name,
                    $search_description,
                    $search_comment,
                    $search_footprint,
                    $search_category,
                    $search_storelocation,
                    $search_supplier,
                    $search_supplierpartnr,
                    $search_manufacturer
                );

                $export_string = exportParts($parts, 'searchparts', $export_format_id, true, 'search_parts');
            } catch (Exception $e) {
                $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
            }
            break;

        case 'hint':
            //Set $fatal_error to true, so that the search gets skipped.
            $fatal_error = true;
            break;
    }
}

if (isset($reload_site) && $reload_site) {
    // reload the site to avoid multiple actions by manual refreshing
    $header = 'Location: show_search_parts.php?keyword='.$keyword;
    if ($search_name) {
        $header.= '&search_name=1';
    }
    if ($search_category) {
        $header.= '&search_category=1';
    }
    if ($search_description) {
        $header.= '&search_description=1';
    }
    if ($search_comment) {
        $header.= '&search_comment=1';
    }
    if ($search_supplier) {
        $header.= '&search_supplier=1';
    }
    if ($search_supplierpartnr) {
        $header.= '&search_supplierpartnr=1';
    }
    if ($search_storelocation) {
        $header.= '&search_storelocation=1';
    }
    if ($search_footprint) {
        $header.= '&search_footprint=1';
    }
    if ($search_manufacturer) {
        $header.= '&search_manufacturer=1';
    }
    header($header);
}

/********************************************************************************
 *
 *   Generate Table
 *
 *********************************************************************************/

if (! $fatal_error) {
    try {
        $category_parts = Part::searchParts(
            $database,
            $current_user,
            $log,
            $keyword,
            $groupby,
            $search_name,
            $search_description,
            $search_comment,
            $search_footprint,
            $search_category,
            $search_storelocation,
            $search_supplier,
            $search_supplierpartnr,
            $search_manufacturer,
            $regex_search
        );

        $hits_count = count($category_parts, COUNT_RECURSIVE) - count($category_parts);

        $parts_table_loops = array();

        //When parts should not get grouped by a variable, we only have a one dimensional array
        if ($groupby == "") {
            $parts_table_loops["Alle Kategorien"] = Part::buildTemplateTableArray($category_parts, 'search_parts_category');
        } else {
            /**
             * @var  $category_parts Part[][]
             */
            foreach ($category_parts as $category_full_path => $parts) {
                $parts_table_loops[$category_full_path] = Part::buildTemplateTableArray($parts, 'search_parts');
            }
        }
    } catch (Exception $e) {
        $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');
        $fatal_error = true;
    }
}

/********************************************************************************
 *
 *   Set the rest of the HTML variables
 *
 *********************************************************************************/

if (! $fatal_error) {
    try {
        $html->setVariable('keyword', $keyword, 'string');
        $html->setVariable('hits_count', (isset($hits_count) ? $hits_count : 0), 'integer');
        $html->setVariable('search_name', $search_name, 'boolean');
        $html->setVariable('search_category', $search_category, 'boolean');
        $html->setVariable('search_description', $search_description, 'boolean');
        $html->setVariable('search_comment', $search_comment, 'boolean');
        $html->setVariable('search_supplier', $search_supplier, 'boolean');
        $html->setVariable('search_supplierpartnr', $search_supplierpartnr, 'boolean');
        $html->setVariable('search_storelocation', $search_storelocation, 'boolean');
        $html->setVariable('search_footprint', $search_footprint, 'boolean');
        $html->setVariable('search_manufacturer', $search_manufacturer, 'boolean');

        // export formats
        $html->setLoop('export_formats', buildExportFormatsLoop('searchparts'));
        $html->setLoop('group_formats', Part::buildSearchGroupByLoop($groupby));

        // global stuff
        $html->setVariable('disable_footprints', $config['footprints']['disable'], 'boolean');
        $html->setVariable('disable_manufacturers', $config['manufacturers']['disable'], 'boolean');
        $html->setVariable('disable_auto_datasheets', $config['auto_datasheets']['disable'], 'boolean');

        $html->setVariable('use_modal_popup', $config['popup']['modal'], 'boolean');
        $html->setVariable('popup_width', $config['popup']['width'], 'integer');
        $html->setVariable('popup_height', $config['popup']['height'], 'integer');
        $html->setVariable('highlighting', $config['search']['highlighting'], 'boolean');
    } catch (Exception $e) {
        $messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red', );
        $fatal_error = true;
    }
}

/********************************************************************************
 *
 *   Generate HTML Output
 *
 *********************************************************************************/


//If a ajax version is requested, say this the template engine.
if (isset($_REQUEST["ajax"])) {
    $html->setVariable("ajax_request", true);
}

$html->printHeader($messages);

if (! $fatal_error) {
    $html->printTemplate('search_header');

    foreach ($parts_table_loops as $category_full_path => $loop) {
        $html->setVariable('category_full_path', $category_full_path, 'string');
        $html->setVariable('table_rowcount', count($loop), 'integer');
        $html->setLoop('table', $loop);
        $html->printTemplate('searched_parts_table');
    }
}

if ($action == "hint") {
    $html->printTemplate('livesearch_hint');
}

$html->printFooter();