Index: /temp/trunk/html/admin/products/index.php
===================================================================
--- /temp/trunk/html/admin/products/index.php (revision 1627)
+++ /temp/trunk/html/admin/products/index.php (revision 1629)
@@ -11,6 +11,6 @@
var $arrPageMax;
function LC_Page() {
-// $this->tpl_mainpage = 'products/index.tpl';
- $this->tpl_mainpage="products/test.tpl";
+ $this->tpl_mainpage = 'products/index.tpl';
+// $this->tpl_mainpage="products/test.tpl";
$this->tpl_mainno = 'products';
@@ -32,30 +32,54 @@
}
-
-$conn = new SC_DBConn();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();
-// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
-$objFormParam = new SC_FormParam();
-// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
-lfInitParam();
-$objFormParam->setParam($_POST);
-
-$objFormParam->splitParamCheckBoxes('search_order_sex');
-$objFormParam->splitParamCheckBoxes('search_payment_id');
+$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;
// ¸¡º÷¥ï¡¼¥É¤Î°ú¤·Ñ¤®
foreach ($_POST as $key => $val) {
- if (ereg("^search_", $key)) {
+ if (ereg("^search_", $key) || ereg("^campaign_", $key)) {
switch($key) {
- case 'search_order_sex':
- case 'search_payment_id':
+ case 'search_product_flag':
+ case 'search_status':
$objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val);
+ if(!is_array($val)) {
+ $objPage->arrForm[$key] = split("-", $val);
+ }
break;
default:
$objPage->arrHidden[$key] = $val;
break;
- }
+ }
}
}
@@ -64,105 +88,64 @@
$objPage->arrHidden['search_pageno'] = $_POST['search_pageno'];
-// ǧ¾Ú²ÄÈݤÎȽÄê
-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 ($_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";
+
+ // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
if (count($objPage->arrErr) == 0) {
- $where = "delete = 0";
- foreach ($arrRet as $key => $val) {
+
+ foreach ($objPage->arrForm as $key => $val) {
+
+ $val = sfManualEscape($val);
+
if($val == "") {
continue;
}
- $val = sfManualEscape($val);
switch ($key) {
- 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 >= ?";
+ case 'search_product_id':
+ $where .= " AND product_id = ?";
$arrval[] = $val;
break;
- case 'search_order_id2':
- $where .= " AND order_id <= ?";
+ 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_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;
- }
+ case 'search_name':
+ $where .= " AND name ILIKE ?";
+ $arrval[] = "%$val%";
+ break;
+ case 'search_category_id':
+ list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);
+ if($tmp_where != "") {
+ $where.= " AND $tmp_where";
+ $arrval = array_merge($arrval, $tmp_arrval);
}
-
- 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 ?";
+ 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%";
- break;
- 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 != "") {
- $tmp_where .= ")";
- $where .= " $tmp_where ";
- }
- break;
- case 'search_total1':
- $where .= " AND total >= ?";
- $arrval[] = $val;
- break;
- case 'search_total2':
- $where .= " AND total <= ?";
- $arrval[] = $val;
break;
case 'search_startyear':
@@ -172,21 +155,32 @@
break;
case 'search_endyear':
- $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday'], true);
+ $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
$where.= " AND update_date <= ?";
$arrval[] = $date;
break;
- 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;
+ 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";
+ }
break;
default:
@@ -194,6 +188,7 @@
}
}
-
+
$order = "update_date DESC";
+ $objQuery = new SC_Query();
switch($_POST['mode']) {
@@ -201,15 +196,16 @@
// ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
$option = "ORDER BY $order";
-
// CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
- $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);
-
+ $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);
+
// CSV¤òÁ÷¿®¤¹¤ë¡£
sfCSVDownload($head.$data);
@@ -218,18 +214,17 @@
case 'delete_all':
// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
+ $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
$sqlval['delete'] = 1;
- $objQuery = new SC_Query();
- $objQuery->update("dtb_order", $sqlval, $where, $arrval);
+ $objQuery->update("dtb_products", $sqlval, $where, $arrval);
break;
default:
// Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
- $col = "*";
- $from = "dtb_order";
-
- $objQuery = new SC_Query();
+ $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited";
+ $from = "vw_products_nonclass";
+
// ¹Ô¿ô¤Î¼èÆÀ
$linemax = $objQuery->count($from, $where, $arrval);
$objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
-
+
// ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
if(is_numeric($_POST['search_page_max'])) {
@@ -238,10 +233,20 @@
$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;
-
+ $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;
+ }
+ }
+
// ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
$objQuery->setlimitoffset($page_max, $startno);
@@ -249,90 +254,232 @@
$objQuery->setorder($order);
// ¸¡º÷·ë²Ì¤Î¼èÆÀ
- $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
+ $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;
}
}
- 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');
-
+}
+/*
+$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);
+
+// ²èÌ̤Îɽ¼¨
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
-//-----------------------------------------------------------------------------------------------------------------------------------
-/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
-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 lfConvertParam() {
+ global $objPage;
+ /*
+ * ʸ»úÎó¤ÎÊÑ´¹
+ * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
+ * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
+ * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹
+ * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹
+ */
+ $arrConvList['search_name'] = "KVa";
+ $arrConvList['search_product_code'] = "KVa";
+
+ // ʸ»úÊÑ´¹
+ foreach ($arrConvList as $key => $val) {
+ // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
+ if(isset($objPage->arrForm[$key])) {
+ $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
+ }
+ }
+}
+
+// ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
function lfCheckError() {
- global $objFormParam;
- // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
- $arrRet = $objFormParam->getHashArray();
- $objErr = new SC_CheckError($arrRet);
- $objErr->arrErr = $objFormParam->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 = new SC_CheckError();
$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;
+}
?>