Changeset 1863 for temp/trunk/html/admin

Timestamp:

2006/08/24 21:02:04 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• customer/index.php (modified) (7 diffs)
• products/index.php (modified) (18 diffs)

temp/trunk/html/admin/customer/index.php

@@ -3 +3 @@
 require_once("../require.php");
 require_once(ROOT_DIR."data/include/csv_output.inc");
-
-// ǧ¾Ú²ÄÈݤÎȽÄê
-$objSess = new SC_Session();
-sfIsSuccess($objSess);
 
 //---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹
@@ -31 +27 @@
         $this->tpl_mainpage = 'customer/index.tpl';
         $this->tpl_mainno = 'customer';
-        $this->tpl_subnavi = '';
-        $this->tpl_subno = "index";
+        $this->tpl_subnavi = 'customer/subnavi.tpl';
+        $this->tpl_subno = 'index';
+        $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';
+        $this->tpl_subtitle = '¸ÜµÒ¥Þ¥¹¥¿';
+        
         global $arrPref;
         $this->arrPref = $arrPref;
@@ -50 +49 @@
     }
 }
-
-
-
-//---- ¸¡º÷ÍѹàÌÜÇÛÎó
-$arrSearchColumn = array(
-                            array(  "column" => "customer_id",      "convert" => "n" ),
-                            array(  "column" => "name",             "convert" => "aKV" ),
-                            array(  "column" => "pref",             "convert" => "n" ),
-                            array(  "column" => "kana",             "convert" => "CKV" ),
-                            array(  "column" => "sex",              "convert" => "" ),
-                            array(  "column" => "b_start_year",     "convert" => "n" ),
-                            array(  "column" => "b_start_month",    "convert" => "n" ),
-                            array(  "column" => "b_start_day",      "convert" => "n" ),
-                            array(  "column" => "b_end_year",       "convert" => "n" ),
-                            array(  "column" => "b_end_month",      "convert" => "n" ),
-                            array(  "column" => "b_end_day",        "convert" => "n" ),
-                            array(  "column" => "tel",              "convert" => "n" ),
-                            array(  "column" => "job",              "convert" => "" ),
-                            array(  "column" => "birth_month",      "convert" => "n" ),
-                            array(  "column" => "email",            "convert" => "a" ),
-                            array(  "column" => "buy_total_from",   "convert" => "n" ),
-                            array(  "column" => "buy_total_to",     "convert" => "n" ),
-                            array(  "column" => "buy_times_from",   "convert" => "n" ),
-                            array(  "column" => "buy_times_to",     "convert" => "n" ),
-                            array(  "column" => "start_year",       "convert" => "n" ),
-                            array(  "column" => "start_month",      "convert" => "n" ),
-                            array(  "column" => "start_day",        "convert" => "n" ),
-                            array(  "column" => "end_year",         "convert" => "n" ),
-                            array(  "column" => "end_month",        "convert" => "n" ),
-                            array(  "column" => "end_day",          "convert" => "n" ),
-                            array(  "column" => "page_rows",        "convert" => "n" )
-
-                            // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¡¢¥«¥Æ¥´¥ê¤ò¸¡º÷¹àÌܤËÄɲ乤ë START
-                            ,array(  "column" => "buy_start_year",      "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü START ǯ
-                            ,array(  "column" => "buy_start_month",     "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü START ·î
-                            ,array(  "column" => "buy_start_day",       "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü START Æü
-                            ,array(  "column" => "buy_end_year",        "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü END ǯ
-                            ,array(  "column" => "buy_end_month",       "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü END ·î
-                            ,array(  "column" => "buy_end_day",         "convert" => "n" )      //¡¡ºÇ½ª¹ØÆþÆü END Æü
-                            ,array(  "column" => "buy_product_name",    "convert" => "aKV" )    //¡¡¹ØÆþ¾¦ÉÊ̾
-                            ,array(  "column" => "buy_product_code",    "convert" => "aKV" )    //¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É
-                            ,array(  "column" => "category_id",         "convert" => "" )       //¡¡¥«¥Æ¥´¥ê
-                            // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¡¢¥«¥Æ¥´¥ê¤ò¸¡º÷¹àÌܤËÄɲ乤ë END
-                            
-                            ,array(  "column" => "cell",                "convert" => "n" )      // 2006/05/10 KAKINAKA-ADD:·ÈÂÓÅÅÏäò¸¡º÷¹àÌܤËÄɲ乤ë END
-
-                         );
-
-//---- ¥Ú¡¼¥¸½é´üÀßÄê
-$objConn = new SC_DBConn();
-$objPage = new LC_Page();
-$objView = new SC_AdminView();
-$objDate = new SC_Date(1901);
-$objPage->arrYear = $objDate->getYear();    //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê
-$objPage->arrMonth = $objDate->getMonth();
-$objPage->arrDay = $objDate->getDay();
-$objPage->objDate = $objDate;
 
 //----¡¡CSV¥À¥¦¥ó¥í¡¼¥ÉÍÑ
@@ -124 +66 @@
                         12 => array("sql" => "tel02", "csv" => "tel02", "header" => "TEL2"),
                         13 => array("sql" => "tel03", "csv" => "tel03", "header" => "TEL3"),
-
-                        // 2006/05/12 KAKINAKA ADD:·ÈÂÓÅÅÏÃÈÖ¹æ¤âcsv½ÐÎϤ¹¤ë START
-                        14 => array("sql" => "cell01", "csv" => "cell01", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ1"),
-                        15 => array("sql" => "cell02", "csv" => "cell02", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ2"),
-                        16 => array("sql" => "cell03", "csv" => "cell03", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ3"),
-                        // 2006/05/12 KAKINAKA ADD:·ÈÂÓÅÅÏÃÈÖ¹æ¤âcsv½ÐÎϤ¹¤ë END
-
-                        17 => array("sql" => "fax01", "csv" => "fax01", "header" => "FAX1"),
-                        18 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"),
-                        19 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"),
-                        20 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ­' ELSE '½÷À­' END AS sex", "csv" => "sex", "header" => "À­ÊÌ"),
-
-                        // 2006/05/12 KAKINAKA DEL:¿¦¶È¤Ï½ÐÎϤ·¤Ê¤¤ START
-                        //21 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"),
-                        // 2006/05/12 KAKINAKA DEL:¿¦¶È¤Ï½ÐÎϤ·¤Ê¤¤ END
-
-                        21 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"),
-                        22 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"),
-                        23 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"),
-                        24 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"),
-                        25 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"),
-                        26 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"),
-                        27 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"),
-                        28 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü")
+                        14 => array("sql" => "fax01", "csv" => "fax01", "header" => "FAX1"),
+                        15 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"),
+                        16 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"),
+                        17 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ­' ELSE '½÷À­' END AS sex", "csv" => "sex", "header" => "À­ÊÌ"),
+                        18 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"),
+                        19 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"),
+                        20 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"),
+                        21 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"),
+                        22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"),
+                        23 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"),
+                        24 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"),
+                        25 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"),
+                        26 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü")
                     );
 
-//----¡¡¸ÜµÒ¾ðÊ󸡺÷
-if($_POST['mode'] == "search") {
-
-    //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È
-    $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn);
-
-    //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯
-    $objPage->arrErr = lfErrorCheck($objPage->list_data);
-    //-- ¸¡º÷³«»Ï¤È²ñ°÷¾ðÊóºï½ü
-    if (! is_array($objPage->arrErr)) {
-
-        //-- ¸ÜµÒºï½ü»þ     
-        if ($_POST["del_mode"] == "delete" && is_numeric($_POST["del_customer_id"])) {
+//---- ¥Ú¡¼¥¸½é´üÀßÄê
+$objConn = new SC_DBConn();
+$objPage = new LC_Page();
+$objView = new SC_AdminView();
+$objDate = new SC_Date(1901);
+$objPage->arrYear = $objDate->getYear();    //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê
+$objPage->arrMonth = $objDate->getMonth();
+$objPage->arrDay = $objDate->getDay();
+$objPage->objDate = $objDate;
+
+// ǧ¾Ú²ÄÈݤÎȽÄê
+$objSess = new SC_Session();
+sfIsSuccess($objSess);
+
+// POSTÃͤΰú¤­·Ñ¤®
+$objPage->arrForm = $_POST;
+
+// ¥Ú¡¼¥¸Á÷¤êÍÑ
+$objPage->arrHidden['search_pageno'] = $_POST['search_pageno'];
+
+// ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
+foreach ($_POST as $key => $val) {
+
+    if (ereg("^search_", $key)) {
+        switch($key) {
+            case 'search_sex':
+                $objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val);
+                if(!is_array($val)) {
+                    $objPage->arrForm[$key] = split("-", $val);
+                }
+                break;
+            default:
+                $objPage->arrHidden[$key] = $val;
+                break;
+        }
+    }
+}
+
+// ¸ÜµÒºï½ü
+if ($_POST['mode'] == "delete") {
+    $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+    $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
+
+    if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
+        $arrDel = array("delete" => 1, "update_date" => "NOW()"); 
+        $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
+    } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
+        $sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
+        $objConn->query($sql, array($_POST["edit_customer_id"]));
+    }
+    $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
+    $objConn->query($sql, array($result_customer[0]["email"]));
+}
+
+if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
+    // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
+    lfConvertParam();
+    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+    $objPage->arrErr = lfCheckError($objPage->arrForm);
+
+    $where = "delete = 0";
+
+    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
+    if (count($objPage->arrErr) == 0) {
+        
+        //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ
+        $objSelect = new SC_CustomerList($objPage->arrForm, "customer");
+        if ($_POST["mode"] == 'csv') {
+            $searchSql = $objSelect->getListCSV($arrColumnCSV);
+        }else{
+            $searchSql = $objSelect->getList();
+        }
+        $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
+
+        switch($_POST['mode']) {
+        case 'csv':
+            $i = 0;
+            $header = "";
+            
+            // CSV¥«¥é¥à¼èÆÀ
+            $arrCsvOutput = (sfgetCsvOutput(2, " WHERE csv_id = 2 AND status = 1"));
+
+            if (count($arrCsvOutput) <= 0) break;
+
+            foreach($arrCsvOutput as $data) {
+                $arrColumn[] = $data["col"];
+                if ($i != 0) $header .= ", ";
+                $header .= $data["disp_name"];
+                $i ++;
+            }
+            $header .= "\n";
+
+            //-¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹
+            for($i = 0; $i < count($objPage->search_data); $i ++) {
+                $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ];
+                $objPage->search_data[$i]["job"]  = $arrJob[ $objPage->search_data[$i]["job"] ];
+            }
+
+            //-¡¡CSV½ÐÎÏ
+            $data = lfGetCSVData($objPage->search_data, $arrColumn);
+            sfCSVDownload($header.$data);
+            exit;
+            break;
+        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);
+
             $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
             $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
 
             if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
-                $arrDel = array("delete" => 1, "update_date" => "NOW()"); 
+                $arrDel = array("delete" => 1, "update_date" => "NOW()");
                 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
             } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
@@ -174 +201 @@
             }
             $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
-            $objConn->query($sql, array($result_customer[0]["email"]));
-        }
+            $objConn->query($sql, array($result_customer[0]["email"])); 
             
-        $objSelect = new SC_CustomerList($objPage->list_data, "customer");
-    
-        //-- ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
-        if(is_numeric($_POST['page_rows'])) {   
-            $page_max = $_POST['page_rows'];
-        } else {
-            $page_max = SEARCH_PMAX;
-        }
-                
-        $objPage->count = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
-        $objNavi = new SC_PageNavi($_POST['pageno'], $objPage->count, $page_max, "fnCustomerPage", NAVI_PMAX);
-
-        $objPage->tpl_strnavi = $objNavi->strnavi;
-        $startno = $objNavi->start_row;
-
-        //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ
-        if ($_POST["csv_mode"] == 'csv') {
-            $searchSql = $objSelect->getListCSV($arrColumnCSV);
-        } else {
-            $objSelect->setLimitOffset($_POST["page_rows"], $startno);
-            $searchSql = $objSelect->getList();
-        }
-    
-        $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
-
-        //--¡¡CSV¥À¥¦¥ó¥í¡¼¥É»þ
-        if ($_POST["csv_mode"] == "csv") {
-            $i = 0;
-            foreach($arrColumnCSV as $data) {
-                $arrColumn[] = $data["csv"];
-                if ($i != 0) $header .= ", ";
-                $header .= $data["header"];
-                $i ++;
+            break;
+        default:
+
+            // ¹Ô¿ô¤Î¼èÆÀ
+            $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
+            $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
+    
+            // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
+            if(is_numeric($_POST['search_page_max'])) { 
+                $page_max = $_POST['search_page_max'];
+            } else {
+                $page_max = SEARCH_PMAX;
             }
-            $header .= "\n";
-
-            //-¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹
-            for($i = 0; $i < count($objPage->search_data); $i ++) {
-                $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ];
-                $objPage->search_data[$i]["job"]  = $arrJob[ $objPage->search_data[$i]["job"] ];
-            }
-
-            //-¡¡CSV½ÐÎÏ
-            $data = lfGetCSVData($objPage->search_data, $arrColumn);
-            sfCSVDownload($header.$data);
-            exit();
-        }
-    }
-
-}
-
-// 2006/04/18 KAKINAKA-ADD:¥«¥Æ¥´¥ê¤ÎÆɹþ¤òÄɲÃ
+            // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
+            $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX);
+            $startno = $objNavi->start_row;
+            $objPage->arrPagenavi = $objNavi->arrPagenavi;      
+        }
+    }
+}
+
 $objPage->arrCatList = sfGetCategoryList();
 
@@ -238 +233 @@
 //--------------------------------------------------------------------------------------------------------------------------------------
 
-//---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ
-function lfGetCSVData( $array, $arrayIndex){    
-    
-    for ($i=0; $i<count($array); $i++){
-        
-        for ($j=0; $j<count($array[$i]); $j++ ){
-            if ( $j > 0 ) $return .= ",";
-            $return .= "\"";            
-            if ( $arrayIndex ){
-                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\"";  
-            } else {
-                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\"";
-            }
-        }
-        $return .= "\n";            
-    }
-    
-    return $return;
-}
-
-
 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹
-function lfConvertParam($array, $arrSearchColumn) {
+function lfConvertParam() {
+    global $objPage;
+    
     /*
      *  ʸ»úÎó¤ÎÊÑ´¹
@@ -270 +246 @@
      */
     // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó
-    foreach ($arrSearchColumn as $data) {
-        $arrConvList[ $data["column"] ] = $data["convert"];
-    }
+    $arrConvList['search_customer_id'] = "n" ;
+    $arrConvList['search_name'] = "aKV" ;
+    $arrConvList['search_pref'] = "n" ;
+    $arrConvList['search_kana'] = "CKV" ;
+    $arrConvList['search_b_start_year'] = "n" ;
+    $arrConvList['search_b_start_month'] = "n" ;
+    $arrConvList['search_b_start_day'] = "n" ;
+    $arrConvList['search_b_end_year'] = "n" ;
+    $arrConvList['search_b_end_month'] = "n" ;
+    $arrConvList['search_b_end_day'] = "n" ;
+    $arrConvList['search_tel'] = "n" ;
+    $arrConvList['search_birth_month'] = "n" ;
+    $arrConvList['search_email'] = "a" ;
+    $arrConvList['search_buy_total_from'] = "n" ;
+    $arrConvList['search_buy_total_to'] = "n" ;
+    $arrConvList['search_buy_times_from'] = "n" ;
+    $arrConvList['search_buy_times_to'] = "n" ;
+    $arrConvList['search_start_year'] = "n" ;
+    $arrConvList['search_start_month'] = "n" ;
+    $arrConvList['search_start_day'] = "n" ;
+    $arrConvList['search_end_year'] = "n" ;
+    $arrConvList['search_end_month'] = "n" ;
+    $arrConvList['search_end_day'] = "n" ;
+    $arrConvList['search_page_rows'] = "n" ;
+    $arrConvList['search_buy_start_year'] = "n" ;       //¡¡ºÇ½ª¹ØÆþÆü START ǯ
+    $arrConvList['search_buy_start_month'] = "n" ;      //¡¡ºÇ½ª¹ØÆþÆü START ·î
+    $arrConvList['search_buy_start_day'] = "n" ;        //¡¡ºÇ½ª¹ØÆþÆü START Æü
+    $arrConvList['search_buy_end_year'] = "n" ;         //¡¡ºÇ½ª¹ØÆþÆü END ǯ
+    $arrConvList['search_buy_end_month'] = "n" ;        //¡¡ºÇ½ª¹ØÆþÆü END ·î
+    $arrConvList['search_buy_end_day'] = "n" ;          //¡¡ºÇ½ª¹ØÆþÆü END Æü
+    $arrConvList['search_buy_product_name'] = "aKV" ;   //¡¡¹ØÆþ¾¦ÉÊ̾
+    $arrConvList['search_buy_product_code'] = "aKV" ;   //¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É
+    $arrConvList['search_category_id'] = "" ;           //¡¡¥«¥Æ¥´¥ê
+        
     // ʸ»úÊÑ´¹
     foreach ($arrConvList as $key => $val) {
         // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
-        if (! is_array($array[$key]) && strlen($array[$key]) > 0) {
-            $array[$key] = mb_convert_kana($array[$key] ,$val);
-        }
-    }
-    return $array;
+        if(isset($objPage->arrForm[$key])) {
+            $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
+        }
+    }
 }
 
 
 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
-function lfErrorCheck($array) {
+function lfCheckError($array) {
 
     $objErr = new SC_CheckError($array);
     
-    $objErr->doFunc(array("¸ÜµÒ¥³¡¼¥É", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("ÅÔÆ»Éܸ©", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¸ÜµÒ̾", "name", STEXT_LEN), array("MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¸ÜµÒ̾(¥«¥Ê)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));
-
-    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)", "b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE"));
-    $objErr->doFunc(array("ÃÂÀ¸Æü(½ªÎ»Æü)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE"));
-    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)","ÃÂÀ¸Æü(½ªÎ»Æü)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM"));
-    
-    $objErr->doFunc(array("ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¹ØÆþ¶â³Û(½ªÎ»)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    if ( (is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && ($array["buy_total_from"] > $array["buy_total_to"]) ) $objErr->arrErr["buy_total_from"] .= "¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
-    $objErr->doFunc(array("¹ØÆþ²ó¿ô(³«»Ï)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¹ØÆþ²ó¿ô(½ªÎ»)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
-    if ( (is_numeric($array["buy_times_from"]) && is_numeric($array["buy_times_to"]) ) && ($array["buy_times_from"] > $array["buy_times_to"]) ) $objErr->arrErr["buy_times_from"] .= "¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
-
-    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "start_year", "start_month", "start_day",), array("CHECK_DATE"));
-    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "end_year", "end_month", "end_day"), array("CHECK_DATE"));    
-    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM"));
-    
-    $objErr->doFunc(array("ɽ¼¨·ï¿ô", "page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK"));  
-
-    // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¤ò¸¡º÷¹àÌܤËÄɲ乤ë START
-    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE"));   //ºÇ½ª¹ØÆþÆü(³«»ÏÆü)
-    $objErr->doFunc(array("ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE"));            //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü)
+    $objErr->doFunc(array("¸ÜµÒ¥³¡¼¥É", "search_customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("ÅÔÆ»Éܸ©", "search_pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¸ÜµÒ̾", "search_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¸ÜµÒ̾(¥«¥Ê)", "search_kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array("CHECK_DATE"));
+    $objErr->doFunc(array("ÃÂÀ¸Æü(½ªÎ»Æü)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_DATE"));
+    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)","ÃÂÀ¸Æü(½ªÎ»Æü)", "search_b_start_year", "search_b_start_month", "search_b_start_day", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_SET_TERM"));
+    $objErr->doFunc(array("ÃÂÀ¸·î", "search_birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "search_email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "search_tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "search_buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¹ØÆþ¶â³Û(½ªÎ»)", "search_buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    if ( (is_numeric($array["search_buy_total_from"]) && is_numeric($array["search_buy_total_to"]) ) && ($array["search_buy_total_from"] > $array["search_buy_total_to"]) ) $objErr->arrErr["search_buy_total_from"] .= "¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
+    $objErr->doFunc(array("¹ØÆþ²ó¿ô(³«»Ï)", "search_buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¹ØÆþ²ó¿ô(½ªÎ»)", "search_buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
+    if ( (is_numeric($array["search_buy_times_from"]) && is_numeric($array["search_buy_times_to"]) ) && ($array["search_buy_times_from"] > $array["search_buy_times_to"]) ) $objErr->arrErr["search_buy_times_from"] .= "¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
+    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "search_start_year", "search_start_month", "search_start_day",), array("CHECK_DATE"));
+    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_DATE"));   
+    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_start_year", "search_start_month", "search_start_day", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_SET_TERM"));
+    $objErr->doFunc(array("ɽ¼¨·ï¿ô", "search_page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK"));   
+    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array("CHECK_DATE"));  //ºÇ½ª¹ØÆþÆü(³«»ÏÆü)
+    $objErr->doFunc(array("ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_DATE"));           //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü)
     //¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë
-    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM")); 
-    
-    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK"));                     //¹ØÆþ¾¦ÉÊ¥³¡¼¥É
-    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ̾", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));                         //¹ØÆþ¾¦ÉÊ̾¾Î
-    // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¤ò¸¡º÷¹àÌܤËÄɲ乤ë END
-
-    $objErr->doFunc(array("·ÈÂÓÅÅÏÃÈÖ¹æ", "cell", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); // 2006/05/10 KAKINAKA ADD:·ÈÂÓÅÅÏø¡º÷¤òÄɲÃ
+    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_SET_TERM"));   
+    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "search_buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK"));                      //¹ØÆþ¾¦ÉÊ¥³¡¼¥É
+    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ̾", "search_buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));                          //¹ØÆþ¾¦ÉÊ̾¾Î
     
     return $objErr->arrErr;
 }
 
+function lfSetWhere($arrForm){
+    foreach ($arrForm as $key => $val) {
+        
+        $val = sfManualEscape($val);
+        
+        if($val == "") continue;
+        
+        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 ?";
+                $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);
+                }
+                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_startyear':
+                $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
+                $where.= " AND update_date >= ?";
+                $arrval[] = $date;
+                break;
+            case 'search_endyear':
+                $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
+                $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";
+                }   
+                break;
+            default:
+                break;
+        }
+    }
+}
+
+//---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ
+function lfGetCSVData( $array, $arrayIndex){    
+    
+    for ($i=0; $i<count($array); $i++){
+        
+        for ($j=0; $j<count($array[$i]); $j++ ){
+            if ( $j > 0 ) $return .= ",";
+            $return .= "\"";            
+            if ( $arrayIndex ){
+                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\"";  
+            } else {
+                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\"";
+            }
+        }
+        $return .= "\n";            
+    }
+    
+    return $return;
+}
+
+
 ?>

temp/trunk/html/admin/products/index.php

@@ -3 +3 @@
 require_once("../require.php");
 require_once("./index_csv.php");
-require_once(ROOT_DIR . "data/lib/ftp.php");
 
 class LC_Page {
@@ -12 +11 @@
     function LC_Page() {
         $this->tpl_mainpage = 'products/index.tpl';
+        $this->tpl_mainno = 'products';
         $this->tpl_subnavi = 'products/subnavi.tpl';
-        $this->tpl_mainno = 'products';
         $this->tpl_subno = 'index';
+        $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';
+        $this->tpl_subtitle = '¾¦ÉÊ¥Þ¥¹¥¿';
+
         global $arrPageMax;
         $this->arrPageMax = $arrPageMax;
@@ -23 +25 @@
         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();
 
@@ -47 +51 @@
 $objSess = new SC_Session();
 sfIsSuccess($objSess);
+
 //¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
 if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") {
@@ -83 +88 @@
 // ¾¦Éʺï½ü
 if ($_POST['mode'] == "delete") {
-    // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë
-    lfDeleteProductFiles($_POST['product_id']);
-    
     if($_POST['category_id'] != "") {
         // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü
@@ -98 +100 @@
     
     // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô
-    $objQuery->getall("SELECT category_count();");  
-}
+    sfCategory_Count($objQuery);    
+}
+
 
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") {
@@ -108 +111 @@
 
     $where = "delete = 0";
-    
-    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
+
+    // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
     if (count($objPage->arrErr) == 0) {
-            foreach ($objPage->arrForm as $key => $val) {
+
+        foreach ($objPage->arrForm as $key => $val) {
                 
             $val = sfManualEscape($val);
@@ -166 +170 @@
                         if ($element != ""){
                             if ($tmp_where == ""){
-                                $tmp_where.="AND (status LIKE ? "; 
+                                $tmp_where.="AND (status LIKE ? ";
                             }else{
                                 $tmp_where.="OR status LIKE ? ";
@@ -176 +180 @@
                         $tmp_where.=")";
                         $where.= "$tmp_where";
-                    }   
+                    }
                     break;
                 default:
@@ -182 +186 @@
             }
         }
-        
+
         $order = "update_date DESC";
         $objQuery = new SC_Query();
@@ -191 +195 @@
             $option = "ORDER BY $order";
             // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
-            $head = sfGetCSVList($arrPRODUCTS_CVSTITLE);
-            $data = lfGetProductsCSV($where, $option, $arrval);
+            $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);
@@ -207 +220 @@
             $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'])) { 
@@ -218 +231 @@
                 $page_max = SEARCH_PMAX;
             }
-            
+
             // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
             $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
-            $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
             $startno = $objNavi->start_row;
+            $objPage->arrPagenavi = $objNavi->arrPagenavi;
             
             //¥­¥ã¥ó¥Ú¡¼¥ó¾¦Éʸ¡º÷»þ¤Ï¡¢Á´·ë²Ì¤Î¾¦ÉÊID¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë
@@ -233 +246 @@
                 }
             }
-            
+
             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
             $objQuery->setlimitoffset($page_max, $startno);
@@ -240 +253 @@
             // ¸¡º÷·ë²Ì¤Î¼èÆÀ
             $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-            
+
             break;
         }
@@ -256 +269 @@
 //---------------------------------------------------------------------------------------------------------------------------------------------------------
 
-/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
+// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 
 function lfConvertParam() {
     global $objPage;
@@ -278 +291 @@
 }
 
-/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
+// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 
 // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
 function lfCheckError() {
     $objErr = new SC_CheckError();
-    $objErr->doFunc(array("¾¦ÉÊID", "search_product_id", INT_LEN), array("NUM_CHECK"));
-    $objErr->doFunc(array("µ¬³ÊID", "search_product_class_id", INT_LEN), array("NUM_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"));
@@ -319 +330 @@
 }
 
-// ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë
-function lfDeleteProductFiles($product_id) {
-    global $arrWEB_SERVERS;
-    $objQuery = new SC_Query();
-    $col = "file1,file2,file3,file4,file5,file6,main_list_image,main_image,main_large_image,sub_large_image1,sub_large_image2,sub_large_image3,sub_large_image4,sub_large_image5,sub_large_image6";
-    $arrRet = $objQuery->select($col, "dtb_products", "product_id = ?", array($product_id));
-    foreach($arrRet[0] as $file) {
-        if($file != "") {
-            // ¼«Ê¬¼«¿È¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë
-            $path = IMAGE_SAVE_DIR . $file;
-            if(file_exists($path)) {
-                unlink($path);
-            }               
-            // ¼«Ê¬¼«¿È°Ê³°¤Î¥µ¡¼¥Ð¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë
-            foreach($arrWEB_SERVERS as $array) {
-                if($array['host'] != $_SERVER["SERVER_ADDR"]) {
-                    $path = FTP_IMAGE_SAVE_DIR . $file;
-                    sfFtpDelete($array['host'], $array['user'], $array['pass'], $path);
-                }
-            }
-        }
-    }
-}
-
 ?>