/usr/share/horde/whups/lib/Form/Query/DateCriterion.php is in php-horde-whups 3.0.0~beta1-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 | <?php
/**
* Copyright 2001-2002 Robert E. Coyle <robertecoyle@hotmail.com>
* Copyright 2001-2013 Horde LLC (http://www.horde.org/)
*
* See the enclosed file LICENSE for license information (BSD). If you
* did not receive this file, see http://www.horde.org/licenses/bsd.
*
* @author Jan Schneider <jan@horde.org>
* @author Robert E. Coyle <robertecoyle@hotmail.com>
* @category Horde
* @license http://www.horde.org/licenses/bsd BSD
* @package Whups
*/
/**
* Form to add or edit date criteria.
*
* @author Jan Schneider <jan@horde.org>
* @author Robert E. Coyle <robertecoyle@hotmail.com>
* @category Horde
* @copyright 2001-2002 Robert E. Coyle
* @copyright 2001-2013 Horde LLC
* @license http://www.horde.org/licenses/bsd BSD
* @package Whups
*/
class Whups_Form_Query_DateCriterion extends Horde_Form
{
public function __construct(&$vars)
{
parent::__construct(
$vars,
$vars->get('edit') ? _("Edit Date Criterion") : _("Add Date Criterion"),
'Whups_Form_Query_DateCriterion');
$this->addHidden('', 'edit', 'boolean', false);
$this->addVariable(
_("Created from"), 'ticket_timestamp[from]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Created to"), 'ticket_timestamp[to]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Updated from"), 'date_updated[from]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Updated to"), 'date_updated[to]', 'monthdayyear', false, false,
null, array(date('Y') - 10));
$this->addVariable(
_("Resolved from"), 'date_resolved[from]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Resolved to"), 'date_resolved[to]', 'monthdayyear', false, false,
null, array(date('Y') - 10));
$this->addVariable(
_("Assigned from"), 'date_assigned[from]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Assigned to"), 'date_assigned[to]', 'monthdayyear', false,
false, null, array(date('Y') - 10));
$this->addVariable(
_("Due from"), 'ticket_due[from]', 'monthdayyear', false, false,
null, array(date('Y') - 10));
$this->addVariable(
_("Due to"), 'ticket_due[to]', 'monthdayyear', false, false, null,
array(date('Y') - 10));
}
public function execute(&$vars)
{
$path = $vars->get('path');
$parent = false;
$keys = array(
Whups_Query::CRITERION_TIMESTAMP => 'ticket_timestamp',
Whups_Query::CRITERION_UPDATED => 'date_updated',
Whups_Query::CRITERION_RESOLVED => 'date_resolved',
Whups_Query::CRITERION_ASSIGNED => 'date_assigned',
Whups_Query::CRITERION_DUE => 'ticket_due');
foreach ($keys as $key_id => $key_name) {
$date = $vars->get($key_name . '[from]');
if (!empty($date['month'])) {
if (!$parent) {
$path = $GLOBALS['whups_query']->insertBranch(
$path, Whups_Query::TYPE_AND);
$parent = true;
}
$date = mktime(0, 0, 0, $date['month'], $date['day'], $date['year']);
$GLOBALS['whups_query']->insertCriterion(
$path, $key_id, null, Whups_Query::OPERATOR_GREATER, $date);
}
$date = $vars->get($key_name . '[to]');
if (!empty($date['month'])) {
if (!$parent) {
$path = $GLOBALS['whups_query']->insertBranch(
$path, Whups_Query::TYPE_AND);
$parent = true;
}
$date = mktime(0, 0, 0, $date['month'], $date['day'], $date['year']);
$GLOBALS['whups_query']->insertCriterion(
$path, $key_id, null, Whups_Query::OPERATOR_LESS, $date);
}
}
$this->unsetVars($vars);
}
}
|