Index: temp/trunk/html/admin/products/index.php
===================================================================
--- temp/trunk/html/admin/products/index.php (revision 1621)
+++ temp/trunk/html/admin/products/index.php (revision 1624)
@@ -1,85 +1,50 @@
tpl_mainpage = 'products/index.tpl';
-// $this->tpl_mainpage="products/test.tpl";
-
- $this->tpl_mainno = 'products';
- $this->tpl_subnavi = 'products/subnavi.tpl';
+ $this->tpl_mainpage = 'order/index.tpl';
+ $this->tpl_subnavi = 'order/subnavi.tpl';
+ $this->tpl_mainno = 'order';
$this->tpl_subno = 'index';
$this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';
- $this->tpl_subtitle = '¾¦ÉÊ¥Þ¥¹¥¿';
-
+ $this->tpl_subtitle = '¼õÃí´ÉÍý';
+ global $arrORDERSTATUS;
+ $this->arrORDERSTATUS = $arrORDERSTATUS;
+ global $arrORDERSTATUS_COLOR;
+ $this->arrORDERSTATUS_COLOR = $arrORDERSTATUS_COLOR;
+ global $arrSex;
+ $this->arrSex = $arrSex;
global $arrPageMax;
$this->arrPageMax = $arrPageMax;
- global $arrDISP;
- $this->arrDISP = $arrDISP;
- global $arrSTATUS;
- $this->arrSTATUS = $arrSTATUS;
- global $arrPRODUCTSTATUS_COLOR;
- $this->arrPRODUCTSTATUS_COLOR = $arrPRODUCTSTATUS_COLOR;
-
}
}
+$conn = new SC_DBConn();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();
-$objDate = new SC_Date();
-
-
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷³«»Ïǯ
-$objDate->setStartYear(RELEASE_YEAR);
-$objDate->setEndYear(DATE("Y"));
-$objPage->arrStartYear = $objDate->getYear();
-$objPage->arrStartMonth = $objDate->getMonth();
-$objPage->arrStartDay = $objDate->getDay();
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷½ªÎ»Ç¯
-$objDate->setStartYear(RELEASE_YEAR);
-$objDate->setEndYear(DATE("Y"));
-$objPage->arrEndYear = $objDate->getYear();
-$objPage->arrEndMonth = $objDate->getMonth();
-$objPage->arrEndDay = $objDate->getDay();
-
-// ǧ¾Ú²ÄÈݤÎȽÄê
-$objSess = new SC_Session();
-sfIsSuccess($objSess);
-//¥¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
-if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") {
- $objQuery = new SC_Query();
- $search_data = $objQuery->get("dtb_campaign", "search_condition", "campaign_id = ? ", array($_POST['campaign_id']));
- $arrSearch = unserialize($search_data);
- foreach ($arrSearch as $key => $val) {
- $_POST[$key] = $val;
- }
-}
-
-// POSTÃͤΰú¤·Ñ¤®
-$objPage->arrForm = $_POST;
+// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
+$objFormParam = new SC_FormParam();
+// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
+lfInitParam();
+$objFormParam->setParam($_POST);
+
+$objFormParam->splitParamCheckBoxes('search_order_sex');
+$objFormParam->splitParamCheckBoxes('search_payment_id');
// ¸¡º÷¥ï¡¼¥É¤Î°ú¤·Ñ¤®
foreach ($_POST as $key => $val) {
- if (ereg("^search_", $key) || ereg("^campaign_", $key)) {
+ if (ereg("^search_", $key)) {
switch($key) {
- case 'search_product_flag':
- case 'search_status':
+ case 'search_order_sex':
+ case 'search_payment_id':
$objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val);
- if(!is_array($val)) {
- $objPage->arrForm[$key] = split("-", $val);
- }
break;
default:
$objPage->arrHidden[$key] = $val;
break;
- }
+ }
}
}
@@ -88,64 +53,105 @@
$objPage->arrHidden['search_pageno'] = $_POST['search_pageno'];
-// ¾¦Éʺï½ü
-if ($_POST['mode'] == "delete") {
- if($_POST['category_id'] != "") {
- // ¥é¥ó¥¯ÉÕ¤¥ì¥³¡¼¥É¤Îºï½ü
- $where = "category_id = " . addslashes($_POST['category_id']);
- sfDeleteRankRecord("dtb_products", "product_id", $_POST['product_id'], $where);
- } else {
- sfDeleteRankRecord("dtb_products", "product_id", $_POST['product_id']);
- }
- // »Ò¥Æ¡¼¥Ö¥ë(¾¦Éʵ¬³Ê)¤Îºï½ü
- $objQuery = new SC_Query();
- $objQuery->delete("dtb_products_class", "product_id = ?", array($_POST['product_id']));
-
- // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô
- sfCategory_Count($objQuery);
-}
-
-
-if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") {
- // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
- lfConvertParam();
- // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
- $objPage->arrErr = lfCheckError();
-
- $where = "delete = 0";
-
- // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
+// ǧ¾Ú²ÄÈݤÎȽÄê
+sfIsSuccess($objSess);
+
+if($_POST['mode'] == 'delete') {
+ if(sfIsInt($_POST['order_id'])) {
+ $objQuery = new SC_Query();
+ $where = "order_id = ?";
+ $sqlval['delete'] = '1';
+ $objQuery->update("dtb_order", $sqlval, $where, array($_POST['order_id']));
+ }
+}
+
+switch($_POST['mode']) {
+case 'delete':
+case 'csv':
+case 'delete_all':
+case 'search':
+ // ÆþÎÏÃͤÎÊÑ´¹
+ $objFormParam->convParam();
+ $objPage->arrErr = lfCheckError($arrRet);
+ $arrRet = $objFormParam->getHashArray();
+ // ÆþÎϤʤ·
if (count($objPage->arrErr) == 0) {
-
- foreach ($objPage->arrForm as $key => $val) {
-
- $val = sfManualEscape($val);
-
+ $where = "delete = 0";
+ foreach ($arrRet as $key => $val) {
if($val == "") {
continue;
}
+ $val = sfManualEscape($val);
switch ($key) {
- case 'search_product_id':
- $where .= " AND product_id = ?";
- $arrval[] = $val;
- break;
- case 'search_product_class_id':
- $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";
- $arrval[] = $val;
- break;
- case 'search_name':
- $where .= " AND name ILIKE ?";
+ case 'search_order_name':
+ $where .= " AND order_name01||order_name02 ILIKE ?";
+ $nonsp_val = ereg_replace("[ ¡¡]+","",$val);
+ $arrval[] = "%$nonsp_val%";
+ break;
+ case 'search_order_kana':
+ $where .= " AND order_kana01||order_kana02 ILIKE ?";
+ $nonsp_val = ereg_replace("[ ¡¡]+","",$val);
+ $arrval[] = "%$nonsp_val%";
+ break;
+ case 'search_order_id1':
+ $where .= " AND order_id >= ?";
+ $arrval[] = $val;
+ break;
+ case 'search_order_id2':
+ $where .= " AND order_id <= ?";
+ $arrval[] = $val;
+ break;
+ case 'search_order_sex':
+ $tmp_where = "";
+ foreach($val as $element) {
+ if($element != "") {
+ if($tmp_where == "") {
+ $tmp_where .= " AND (order_sex = ?";
+ } else {
+ $tmp_where .= " OR order_sex = ?";
+ }
+ $arrval[] = $element;
+ }
+ }
+
+ if($tmp_where != "") {
+ $tmp_where .= ")";
+ $where .= " $tmp_where ";
+ }
+ break;
+ case 'search_order_tel':
+ $where .= " AND (order_tel01||order_tel02||order_tel03) ILIKE ?";
+ $nonmark_val = ereg_replace("[()-]+","",$val);
+ $arrval[] = "$nonmark_val%";
+ break;
+ case 'search_order_email':
+ $where .= " AND order_email ILIKE ?";
$arrval[] = "%$val%";
break;
- case 'search_category_id':
- list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);
+ case 'search_payment_id':
+ $tmp_where = "";
+ foreach($val as $element) {
+ if($element != "") {
+ if($tmp_where == "") {
+ $tmp_where .= " AND (payment_id = ?";
+ } else {
+ $tmp_where .= " OR payment_id = ?";
+ }
+ $arrval[] = $element;
+ }
+ }
+
if($tmp_where != "") {
- $where.= " AND $tmp_where";
- $arrval = array_merge($arrval, $tmp_arrval);
+ $tmp_where .= ")";
+ $where .= " $tmp_where ";
}
break;
- case 'search_product_code':
- $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
- $arrval[] = "%$val%";
+ case 'search_total1':
+ $where .= " AND total >= ?";
+ $arrval[] = $val;
+ break;
+ case 'search_total2':
+ $where .= " AND total <= ?";
+ $arrval[] = $val;
break;
case 'search_startyear':
@@ -155,32 +161,21 @@
break;
case 'search_endyear':
- $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
+ $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday'], true);
$where.= " AND update_date <= ?";
$arrval[] = $date;
break;
- case 'search_product_flag':
- global $arrSTATUS;
- $search_product_flag = sfSearchCheckBoxes($val);
- if($search_product_flag != "") {
- $where.= " AND product_flag LIKE ?";
- $arrval[] = $search_product_flag;
- }
- break;
- case 'search_status':
- $tmp_where = "";
- foreach ($val as $element){
- if ($element != ""){
- if ($tmp_where == ""){
- $tmp_where.="AND (status LIKE ? ";
- }else{
- $tmp_where.="OR status LIKE ? ";
- }
- $arrval[]=$element;
- }
- }
- if ($tmp_where != ""){
- $tmp_where.=")";
- $where.= "$tmp_where";
- }
+ case 'search_sbirthyear':
+ $date = sfGetTimestamp($_POST['search_sbirthyear'], $_POST['search_sbirthmonth'], $_POST['search_sbirthday']);
+ $where.= " AND order_birth >= ?";
+ $arrval[] = $date;
+ break;
+ case 'search_ebirthyear':
+ $date = sfGetTimestamp($_POST['search_ebirthyear'], $_POST['search_ebirthmonth'], $_POST['search_ebirthday'], true);
+ $where.= " AND order_birth <= ?";
+ $arrval[] = $date;
+ break;
+ case 'search_order_status':
+ $where.= " AND status = ?";
+ $arrval[] = $val;
break;
default:
@@ -188,7 +183,6 @@
}
}
-
+
$order = "update_date DESC";
- $objQuery = new SC_Query();
switch($_POST['mode']) {
@@ -196,16 +190,15 @@
// ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
$option = "ORDER BY $order";
+
// CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
- $arrOutput = sfSwapArray(sfgetCsvOutput(1, " WHERE csv_id = 1 AND status = 1"));
-
- if (count($arrOutput) <= 0) break;
-
- $arrOutputCols = $arrOutput['col'];
- $arrOutputTitle = $arrOutput['disp_name'];
-
- $head = sfGetCSVList($arrOutputTitle);
-
- $data = lfGetProductsCSV($where, $option, $arrval, $arrOutputCols);
-
+ $arrCsvOutput = sfSwapArray(sfgetCsvOutput(3, " WHERE csv_id = 3 AND status = 1"));
+
+ if (count($arrCsvOutput) <= 0) break;
+
+ $arrCsvOutputCols = $arrCsvOutput['col'];
+ $arrCsvOutputTitle = $arrCsvOutput['disp_name'];
+ $head = sfGetCSVList($arrCsvOutputTitle);
+ $data = lfGetCSV("dtb_order", $where, $option, $arrval, $arrCsvOutputCols);
+
// CSV¤òÁ÷¿®¤¹¤ë¡£
sfCSVDownload($head.$data);
@@ -214,17 +207,18 @@
case 'delete_all':
// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
- $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
$sqlval['delete'] = 1;
- $objQuery->update("dtb_products", $sqlval, $where, $arrval);
+ $objQuery = new SC_Query();
+ $objQuery->update("dtb_order", $sqlval, $where, $arrval);
break;
default:
// Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
- $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited";
- $from = "vw_products_nonclass";
-
+ $col = "*";
+ $from = "dtb_order";
+
+ $objQuery = new SC_Query();
// ¹Ô¿ô¤Î¼èÆÀ
$linemax = $objQuery->count($from, $where, $arrval);
$objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
-
+
// ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
if(is_numeric($_POST['search_page_max'])) {
@@ -233,20 +227,10 @@
$page_max = SEARCH_PMAX;
}
-
+
// ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
$objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
$startno = $objNavi->start_row;
- $objPage->arrPagenavi = $objNavi->arrPagenavi;
-
- //¥¥ã¥ó¥Ú¡¼¥ó¾¦Éʸ¡º÷»þ¤Ï¡¢Á´·ë²Ì¤Î¾¦ÉÊID¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë
- if($_POST['search_mode'] == 'campaign') {
- $arrRet = $objQuery->select($col, $from, $where, $arrval);
- if(count($arrRet) > 0) {
- $arrRet = sfSwapArray($arrRet);
- $pid = implode("-", $arrRet['product_id']);
- $objPage->arrHidden['campaign_product_id'] = $pid;
- }
- }
-
+ $objPage->arrPagenavi = $objNavi->arrPagenavi;
+
// ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
$objQuery->setlimitoffset($page_max, $startno);
@@ -254,232 +238,90 @@
$objQuery->setorder($order);
// ¸¡º÷·ë²Ì¤Î¼èÆÀ
- $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-// $arrProducts = $objQuery->select($col, $from, $where, $arrval);
-
-// $objPage->arrTest = $arrProducts;
-
- $objPage->tpl_mainpage="products/test.tpl";
-
- break;
+ $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
}
}
-}
-/*
-$arrProducts = Array
-(
- '0' => Array
- (
- 'product_id' => '18',
- 'name' => 'test',
- 'category_id' => '11',
- 'main_list_image' => '08172054_44e458f942afc.gif',
- 'status' => '1',
- 'product_code' => 'cd 01',
- 'price01' => '500',
- 'price02' => '500',
- 'stock' => '43',
- 'stock_unlimited' => ""
- ),
-
- '1' => Array
- (
- 'product_id' => '14',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '14999',
- 'stock_unlimited' => ""
- ),
-
- '2' => Array
- (
- 'product_id' => '16',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08181941_44e59975c535d.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '14927',
- 'stock_unlimited' => ""
- ),
-
- '3' => Array
- (
- 'product_id' => '15',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '14998',
- 'stock_unlimited' => ""
- ),
- '4' => Array
- (
- 'product_id' => '17',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '15',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '0',
- 'stock_unlimited' => ""
- ),
-
- '5' => Array
- (
- 'product_id' => '13',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '15000',
- 'stock_unlimited' => ""
- ),
-
- '6' => Array
- (
- 'product_id' => '12',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '15000',
- 'stock_unlimited' => ""
- ),
-
- '7' => Array
- (
- 'product_id' => '11',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '15000',
- 'stock_unlimited' => ""
- ),
- '8' => Array
- (
- 'product_id' => '10',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '15000',
- 'stock_unlimited' => ""
- ),
-
- '9' => Array
- (
- 'product_id' => '9',
- 'name' => 'LPO¥¨¥Ó¥¹',
- 'category_id' => '10',
- 'main_list_image' => '08171740_44e42b7f67953.gif',
- 'status' => '1',
- 'product_code' => 'LPO',
- 'price01' => '15000',
- 'price02' => '15000',
- 'stock' => '15000',
- 'stock_unlimited' => ""
- )
-
-);
-
-
-$objPage->arrProducts = $arrProducts;
-*/
-
-// ¥«¥Æ¥´¥ê¤ÎÆɹþ
-$objPage->arrCatList = sfGetCategoryList();
-$objPage->arrCatIDName = lfGetIDName($objPage->arrCatList);
-
-// ²èÌ̤Îɽ¼¨
+ break;
+
+default:
+ break;
+}
+
+$objDate = new SC_Date();
+// ÅÐÏ¿¡¦¹¹¿·Æü¸¡º÷ÍÑ
+$objDate->setStartYear(RELEASE_YEAR);
+$objDate->setEndYear(DATE("Y"));
+$objPage->arrRegistYear = $objDate->getYear();
+// À¸Ç¯·îÆü¸¡º÷ÍÑ
+$objDate->setStartYear(BIRTH_YEAR);
+$objDate->setEndYear(DATE("Y"));
+$objPage->arrBirthYear = $objDate->getYear();
+// ·îÆü¤ÎÀßÄê
+$objPage->arrMonth = $objDate->getMonth();
+$objPage->arrDay = $objDate->getDay();
+
+// ÆþÎÏÃͤμèÆÀ
+$objPage->arrForm = $objFormParam->getFormParamList();
+// »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ
+$arrRet = sfGetPayment();
+$objPage->arrPayment = sfArrKeyValue($arrRet, 'payment_id', 'payment_method');
+
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
-//---------------------------------------------------------------------------------------------------------------------------------------------------------
-
-// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹
-function lfConvertParam() {
- global $objPage;
- /*
- * ʸ»úÎó¤ÎÊÑ´¹
- * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
- * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
- * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹
- * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹
- */
- $arrConvList['search_name'] = "KVa";
- $arrConvList['search_product_code'] = "KVa";
+//-----------------------------------------------------------------------------------------------------------------------------------
+/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
+function lfInitParam() {
+ global $objFormParam;
+ $objFormParam->addParam("¼õÃíÈÖ¹æ1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("¼õÃíÈÖ¹æ2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("Âбþ¾õ¶·", "search_order_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("¸ÜµÒ̾", "search_order_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam("¸ÜµÒ̾(¥«¥Ê)", "search_order_kana", STEXT_LEN, "KVCa", array("KANA_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam("ÀÊÌ", "search_order_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam("ǯÎð1", "search_age1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("ǯÎð2", "search_age2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "search_order_email", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam("TEL", "search_order_tel", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam("»Ùʧ¤¤ÊýË¡", "search_payment_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("¹ØÆþ¶â³Û1", "search_total1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $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_sbirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("³«»ÏÆü", "search_sbirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("³«»ÏÆü", "search_sbirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("½ªÎ»Æü", "search_ebirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("½ªÎ»Æü", "search_ebirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+ $objFormParam->addParam("½ªÎ»Æü", "search_ebirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+}
+
+/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
+function lfCheckError() {
+ global $objFormParam;
+ // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
+ $arrRet = $objFormParam->getHashArray();
+ $objErr = new SC_CheckError($arrRet);
+ $objErr->arrErr = $objFormParam->checkError();
- // ʸ»úÊÑ´¹
- foreach ($arrConvList as $key => $val) {
- // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
- if(isset($objPage->arrForm[$key])) {
- $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
- }
- }
-}
-
-// ¥¨¥é¡¼¥Á¥§¥Ã¥¯
-// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
-function lfCheckError() {
- $objErr = new SC_CheckError();
+ // Æüì¹àÌÜ¥Á¥§¥Ã¥¯
+ $objErr->doFunc(array("¼õÃíÈÖ¹æ1", "¼õÃíÈÖ¹æ2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK"));
+ $objErr->doFunc(array("ǯÎð1", "ǯÎð2", "search_age1", "search_age2"), array("GREATER_CHECK"));
+ $objErr->doFunc(array("¹ØÆþ¶â³Û1", "¹ØÆþ¶â³Û2", "search_total1", "search_total2"), array("GREATER_CHECK"));
$objErr->doFunc(array("³«»ÏÆü", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
$objErr->doFunc(array("½ªÎ»Æü", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE"));
$objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM"));
+
+ $objErr->doFunc(array("³«»ÏÆü", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array("CHECK_DATE"));
+ $objErr->doFunc(array("½ªÎ»Æü", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_DATE"));
+ $objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_SET_TERM"));
+
return $objErr->arrErr;
}
-// ¥Á¥§¥Ã¥¯¥Ü¥Ã¥¯¥¹ÍÑWHEREʸºîÀ®
-function lfGetCBWhere($key, $max) {
- $str = "";
- $find = false;
- for ($cnt = 1; $cnt <= $max; $cnt++) {
- if ($_POST[$key . $cnt] == "1") {
- $str.= "1";
- $find = true;
- } else {
- $str.= "_";
- }
- }
- if (!$find) {
- $str = "";
- }
- return $str;
-}
-
-// ¥«¥Æ¥´¥êID¤ò¥¡¼¡¢¥«¥Æ¥´¥ê̾¤òÃͤˤ¹¤ëÇÛÎó¤òÊÖ¤¹¡£
-function lfGetIDName($arrCatList) {
- $max = count($arrCatList);
- for ($cnt = 0; $cnt < $max; $cnt++ ) {
- $key = $arrCatList[$cnt]['category_id'];
- $val = $arrCatList[$cnt]['category_name'];
- $arrRet[$key] = $val;
- }
- return $arrRet;
-}
?>