Changeset 14781 for branches/dev/html

Timestamp:

2007/06/18 20:11:09 (19 years ago)

Author:

naka

Message:

受注日、変更日で検索できるように変更

File:

• branches/dev/html/admin/order/index.php (modified) (2 diffs)

branches/dev/html/admin/order/index.php

@@ -172 +172 @@
                     $arrval[] = $val;
                     break;
-                case 'search_startyear':
-                    $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
+                case 'search_startyear_c':
+                    $date = sfGetTimestamp($_POST['search_startyear_c'], $_POST['search_startmonth_c'], $_POST['search_startday_c']);
+                    $where.= " AND create_date >= ?";
+                    $arrval[] = $date;
+                    break;
+                case 'search_endyear_c':
+                    $date = sfGetTimestamp($_POST['search_endyear_c'], $_POST['search_endmonth_c'], $_POST['search_endday_c'], true);
+                    $where.= " AND create_date <= ?";
+                    $arrval[] = $date;
+                    break;
+                case 'search_startyear_u':
+                    $date = sfGetTimestamp($_POST['search_startyear_u'], $_POST['search_startmonth_u'], $_POST['search_startday_u']);
                     $where.= " AND update_date >= ?";
                     $arrval[] = $date;
                     break;
-                case 'search_endyear':
-                    $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday'], true);
+                case 'search_endyear_u':
+                    $date = sfGetTimestamp($_POST['search_endyear_u'], $_POST['search_endmonth_u'], $_POST['search_endday_u'], true);
                     $where.= " AND update_date <= ?";
                     $arrval[] = $date;
@@ -303 +313 @@
     $objFormParam->addParam("¹ØÆþ¶â³Û2", "search_total2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
     $objFormParam->addParam("ɽ¼¨·ï¿ô", "search_page_max", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("³«»ÏÆü", "search_startyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("³«»ÏÆü", "search_startmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("³«»ÏÆü", "search_startday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("½ªÎ»Æü", "search_endyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("½ªÎ»Æü", "search_endmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-    $objFormParam->addParam("½ªÎ»Æü", "search_endday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_startyear_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_startmonth_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_startday_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_endyear_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_endmonth_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¼õÃíÆü", "search_endday_c", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_startyear_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_startmonth_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_startday_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_endyear_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_endmonth_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("Êѹ¹Æü", "search_endday_u", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
     $objFormParam->addParam("³«»ÏÆü", "search_sbirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
     $objFormParam->addParam("³«»ÏÆü", "search_sbirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));