-$sql = "SELECT dim.id,
- dim.reference,
- dim.name,
- dim.type_,
- dim.date_,
- dim.due_date,
- dim.closed
- FROM ".TB_PREF."dimensions as dim WHERE id > 0";
-
-if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
-{
- $sql .= " AND reference LIKE ".db_escape("%". $_POST['OrderNumber'] . "%");
-} else {
-
- if ($dim == 1)
- $sql .= " AND type_=1";
-
- if (isset($_POST['OpenOnly']))
- {
- $sql .= " AND closed=0";
- }
-
- if (isset($_POST['type_']) && ($_POST['type_'] > 0))
- {
- $sql .= " AND type_=".db_escape($_POST['type_']);
- }
-
- if (isset($_POST['OverdueOnly']))
- {
- $today = date2sql(Today());
-
- $sql .= " AND due_date < '$today'";
- }
-
- $sql .= " AND date_ >= '" . date2sql($_POST['FromDate']) . "'
- AND date_ <= '" . date2sql($_POST['ToDate']) . "'";
-}
+$sql = get_sql_for_search_dimensions($dim, $_POST['FromDate'], $_POST['ToDate'],
+ $_POST['OrderNumber'], $_POST['type_'], check_value('OpenOnly'), check_value('OverdueOnly'));