Index: temp/trunk/html/admin/customer/index.php =================================================================== --- temp/trunk/html/admin/customer/index.php (revision 1328) +++ temp/trunk/html/admin/customer/index.php (revision 1862) @@ -3,4 +3,8 @@ require_once("../require.php"); require_once(ROOT_DIR."data/include/csv_output.inc"); + +// ǧ¾Ú²ÄÈݤÎȽÄê +$objSess = new SC_Session(); +sfIsSuccess($objSess); //---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹ @@ -27,9 +31,6 @@ $this->tpl_mainpage = 'customer/index.tpl'; $this->tpl_mainno = 'customer'; - $this->tpl_subnavi = 'customer/subnavi.tpl'; - $this->tpl_subno = 'index'; - $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl'; - $this->tpl_subtitle = '¸ÜµÒ¥Þ¥¹¥¿'; - + $this->tpl_subnavi = ''; + $this->tpl_subno = "index"; global $arrPref; $this->arrPref = $arrPref; @@ -49,4 +50,61 @@ } } + + + +//---- ¸¡º÷ÍѹàÌÜÇÛÎó +$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¥À¥¦¥ó¥í¡¼¥ÉÍÑ @@ -66,133 +124,48 @@ 12 => array("sql" => "tel02", "csv" => "tel02", "header" => "TEL2"), 13 => array("sql" => "tel03", "csv" => "tel03", "header" => "TEL3"), - 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" => "¹¹¿·Æü") + + // 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" => "¹¹¿·Æü") ); -//---- ¥Ú¡¼¥¸½é´üÀßÄê -$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); - +//----¡¡¸ÜµÒ¾ðÊ󸡺÷ +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"])) { $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) { //²¾²ñ°÷ºï½ü @@ -201,27 +174,59 @@ } $sql = "DELETE FROM dtb_customer_mail WHERE email = ?"; - $objConn->query($sql, array($result_customer[0]["email"])); + $objConn->query($sql, array($result_customer[0]["email"])); + } - 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; + $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 ++; } - // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ - $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX); - $startno = $objNavi->start_row; - $objPage->arrPagenavi = $objNavi->arrPagenavi; - } - } -} - + $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:¥«¥Æ¥´¥ê¤ÎÆɹþ¤òÄɲà $objPage->arrCatList = sfGetCategoryList(); @@ -232,168 +237,4 @@ //-------------------------------------------------------------------------------------------------------------------------------------- - -//----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ -function lfConvertParam() { - global $objPage; - - /* - * ʸ»úÎó¤ÎÊÑ´¹ - * K : ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ - * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ - * V : ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ - * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹ - * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë - */ - // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó - $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(isset($objPage->arrForm[$key])) { - $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val); - } - } -} - - -//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ -function lfCheckError($array) { - - $objErr = new SC_CheckError($array); - - $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("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "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½ÐÎÏÍѥǡ¼¥¿¼èÆÀ @@ -418,3 +259,73 @@ +//----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ +function lfConvertParam($array, $arrSearchColumn) { + /* + * ʸ»úÎó¤ÎÊÑ´¹ + * K : ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ + * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ + * V : ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ + * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹ + * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë + */ + // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó + foreach ($arrSearchColumn as $data) { + $arrConvList[ $data["column"] ] = $data["convert"]; + } + // ʸ»úÊÑ´¹ + 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; +} + + +//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ +function lfErrorCheck($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")); //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü) + //¹ØÆþ¶â³Û(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:·ÈÂÓÅÅÏø¡º÷¤òÄɲà + + return $objErr->arrErr; +} + ?> Index: temp/trunk/html/admin/products/index.php =================================================================== --- temp/trunk/html/admin/products/index.php (revision 1810) +++ temp/trunk/html/admin/products/index.php (revision 1862) @@ -3,4 +3,5 @@ require_once("../require.php"); require_once("./index_csv.php"); +require_once(ROOT_DIR . "data/lib/ftp.php"); class LC_Page { @@ -11,10 +12,7 @@ function LC_Page() { $this->tpl_mainpage = 'products/index.tpl'; + $this->tpl_subnavi = 'products/subnavi.tpl'; $this->tpl_mainno = 'products'; - $this->tpl_subnavi = 'products/subnavi.tpl'; $this->tpl_subno = 'index'; - $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl'; - $this->tpl_subtitle = '¾¦ÉÊ¥Þ¥¹¥¿'; - global $arrPageMax; $this->arrPageMax = $arrPageMax; @@ -25,12 +23,10 @@ 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(); @@ -51,5 +47,4 @@ $objSess = new SC_Session(); sfIsSuccess($objSess); - //¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") { @@ -88,4 +83,7 @@ // ¾¦Éʺï½ü if ($_POST['mode'] == "delete") { + // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë + lfDeleteProductFiles($_POST['product_id']); + if($_POST['category_id'] != "") { // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü @@ -100,7 +98,6 @@ // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô - sfCategory_Count($objQuery); -} - + $objQuery->getall("SELECT category_count();"); +} if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") { @@ -111,9 +108,8 @@ $where = "delete = 0"; - - // ÆþÎÏ¥¨¥é¡¼¤Ê¤· + + /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */ if (count($objPage->arrErr) == 0) { - - foreach ($objPage->arrForm as $key => $val) { + foreach ($objPage->arrForm as $key => $val) { $val = sfManualEscape($val); @@ -170,5 +166,5 @@ if ($element != ""){ if ($tmp_where == ""){ - $tmp_where.="AND (status LIKE ? "; + $tmp_where.="AND (status LIKE ? "; }else{ $tmp_where.="OR status LIKE ? "; @@ -180,5 +176,5 @@ $tmp_where.=")"; $where.= "$tmp_where"; - } + } break; default: @@ -186,5 +182,5 @@ } } - + $order = "update_date DESC"; $objQuery = new SC_Query(); @@ -195,15 +191,6 @@ $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); - + $head = sfGetCSVList($arrPRODUCTS_CVSTITLE); + $data = lfGetProductsCSV($where, $option, $arrval); // CSV¤òÁ÷¿®¤¹¤ë¡£ sfCSVDownload($head.$data); @@ -220,9 +207,9 @@ $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'])) { @@ -231,9 +218,9 @@ $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¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë @@ -246,5 +233,5 @@ } } - + // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È) $objQuery->setlimitoffset($page_max, $startno); @@ -253,5 +240,5 @@ // ¸¡º÷·ë²Ì¤Î¼èÆÀ $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval); - + break; } @@ -269,5 +256,5 @@ //--------------------------------------------------------------------------------------------------------------------------------------------------------- -// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ +/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */ function lfConvertParam() { global $objPage; @@ -291,8 +278,10 @@ } -// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ +/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */ // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 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")); @@ -330,3 +319,27 @@ } +// ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë +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); + } + } + } + } +} + ?>