DateSearchParameterHandler Class Reference

DateSearchParameterHandler is a SearchParameterHandler for date database types. More...

Inheritance diagram for DateSearchParameterHandler:

Collaboration diagram for DateSearchParameterHandler:

Public Member Functions
	reformatToSQLDate ($date)
	equal ($name, $value)
	Generates the constraint expression for equality matching parameters. More...
	like ($name, $value)
	Generates the constraint expression for 'like' matching parameters, i.e. More...
	startsWith ($name, $value)
	Generates the constraint expression for 'startsWith' matching parameters, i.e. More...
	from ($name, $from)
	Generates the constraint expression for 'from' matching parameters, i.e. More...
	to ($name, $to)
	Generates the constraint expression for 'to' matching parameters, i.e. More...
	range ($name, $from, $to)
	Generates the constraint expression for 'range' matching parameters, i.e. More...
Public Member Functions inherited from SearchParameterHandler
	member ($name, $set)
	Generate the constraint expression for set membership matching paramters, matching values in a comma delimite set. More...
	any ($name, $value)
	Generate the constraint expression for matching any word in a group of words. More...
	all ($name, $value)
	Generate the constraint expression for matching all words in a group of words but allowing other words in between. More...
	fullName ($f_name, $l_name, $value)
	Generate the constraint expression for matching the f_name and l_name fields to a given value. More...
	checked ($name, $value)
	Generate the constraint expresssion for matching boolean only when the UI element is selected. More...

Detailed Description

DateSearchParameterHandler is a SearchParameterHandler for date database types.

Author

andy

Definition at line 415 of file search_form.inc.

Member Function Documentation

equal()

DateSearchParameterHandler::equal	(		$name,
			$value
	)

Generates the constraint expression for equality matching parameters.

Parameters

string	$name	the name of the field
mixed	$value	the value to match

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 439 of file search_form.inc.

     {
          $date = $this->reformatToSQLDate($value);
          return "$name='$date'";
     }

from()

DateSearchParameterHandler::from	(		$name,
			$from
	)

Generates the constraint expression for 'from' matching parameters, i.e.

matching values that are greater than or equal to the specified value.

Parameters

string	$name	the name of the field
mixed	$from	the lower bound

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 456 of file search_form.inc.

     {
          
          $from = $this->reformatToSQLDate($from);
          return "$name >= '$from'";
     }

like()

DateSearchParameterHandler::like	(		$name,
			$value
	)

Generates the constraint expression for 'like' matching parameters, i.e.

matching a substring or partial match.

Parameters

string	$name	the name of the field
mixed	$value	the value to match

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 445 of file search_form.inc.

     {
          //TODO: Fuzzy Date Matching Logic
          die("Inappropriate matching mode");
     }

range()

DateSearchParameterHandler::range	(		$name,
			$from,
			$to
	)

Generates the constraint expression for 'range' matching parameters, i.e.

matching values that within the range of the two specified values.

Parameters

string	$name	the name of the field
string	$from	the lower bound
mixed	$to	the value to match

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 469 of file search_form.inc.

     {
          $from = $this->reformatToSQLDate($from);
          $to = $this->reformatToSQLDate($to);
          
          if ($from > $to)
          {
               $tmp = $from;
               $from = $to;
               $to = $tmp;
          }
          
          return "($name BETWEEN '$from' AND '$to')";
     }

reformatToSQLDate()

DateSearchParameterHandler::reformatToSQLDate

(

$date

)

Definition at line 417 of file search_form.inc.

     {
          trace($date, 3);
          $fields = array();
          if (preg_match("|^(\\d+)[\-/](\\d+)[\-/](\\d{4})$|", $date, $fields))
          {
               $date = $fields[3]."-".$fields[1]."-".$fields[2];
               // JDG 5/2012  - need month and day to have "0" if single digit
               $date = date('Y-m-d', strtotime($date));
          }
          // datetime
          else if (preg_match("|^(\\d+)/(\\d+)/(\\d{4})\\s+(\\d+:\\d+:\\d+)|", $date, $fields))
          {
               // JDG 5/2012  - need month and day to have "0" if single digit
               $date = date('Y-m-d', strtotime($date));
               $date = $fields[3]."-".$fields[1]."-".$fields[2]." ".$fields[4];
          }
     
          return ConnectionManager::escape($date);
     }

startsWith()

DateSearchParameterHandler::startsWith	(		$name,
			$value
	)

Generates the constraint expression for 'startsWith' matching parameters, i.e.

matching a substring or partial match at the start of the field only.

Parameters

string	$name	the name of the field
string	$value	the value to match

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 451 of file search_form.inc.

     {
          die("Inappropriate matching mode");
     }

to()

DateSearchParameterHandler::to	(		$name,
			$to
	)

Generates the constraint expression for 'to' matching parameters, i.e.

matching values that are less than or equal to the specified value.

Parameters

string	$name	the name of the field
mixed	$to	the upper bound

Returns

string a SQL expression to perform the match

Reimplemented from SearchParameterHandler.

Definition at line 463 of file search_form.inc.

     {
          $to = $this->reformatToSQLDate($to);
          return "$name <= '$to'";
     }

---

The documentation for this class was generated from the following file:

• C:/code/cms.sonjara.com/framework/search_form.inc