Index: /temp/trunk/html/admin/customer/index.php =================================================================== --- /temp/trunk/html/admin/customer/index.php (revision 1862) +++ /temp/trunk/html/admin/customer/index.php (revision 1863) @@ -3,8 +3,4 @@ require_once("../require.php"); require_once(ROOT_DIR."data/include/csv_output.inc"); - -// ǧ¾Ú²ÄÈݤÎȽÄê -$objSess = new SC_Session(); -sfIsSuccess($objSess); //---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹ @@ -31,6 +27,9 @@ $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,61 +49,4 @@ } } - - - -//---- ¸¡º÷ÍѹàÌÜÇÛÎó -$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,48 +66,133 @@ 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,59 +201,27 @@ } $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,27 +233,8 @@ //-------------------------------------------------------------------------------------------------------------------------------------- -//---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ -function lfGetCSVData( $array, $arrayIndex){ - - for ($i=0; $i 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,62 +246,175 @@ */ // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó - 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 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; +} + + ?> Index: /temp/trunk/html/admin/products/index.php =================================================================== --- /temp/trunk/html/admin/products/index.php (revision 1862) +++ /temp/trunk/html/admin/products/index.php (revision 1863) @@ -3,5 +3,4 @@ require_once("../require.php"); require_once("./index_csv.php"); -require_once(ROOT_DIR . "data/lib/ftp.php"); class LC_Page { @@ -12,7 +11,10 @@ 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,10 +25,12 @@ 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,4 +51,5 @@ $objSess = new SC_Session(); sfIsSuccess($objSess); + //¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") { @@ -83,7 +88,4 @@ // ¾¦Éʺï½ü if ($_POST['mode'] == "delete") { - // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë - lfDeleteProductFiles($_POST['product_id']); - if($_POST['category_id'] != "") { // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü @@ -98,6 +100,7 @@ // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô - $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,8 +111,9 @@ $where = "delete = 0"; - - /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */ + + // ÆþÎÏ¥¨¥é¡¼¤Ê¤· if (count($objPage->arrErr) == 0) { - foreach ($objPage->arrForm as $key => $val) { + + foreach ($objPage->arrForm as $key => $val) { $val = sfManualEscape($val); @@ -166,5 +170,5 @@ if ($element != ""){ if ($tmp_where == ""){ - $tmp_where.="AND (status LIKE ? "; + $tmp_where.="AND (status LIKE ? "; }else{ $tmp_where.="OR status LIKE ? "; @@ -176,5 +180,5 @@ $tmp_where.=")"; $where.= "$tmp_where"; - } + } break; default: @@ -182,5 +186,5 @@ } } - + $order = "update_date DESC"; $objQuery = new SC_Query(); @@ -191,6 +195,15 @@ $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,9 +220,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'])) { @@ -218,9 +231,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¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë @@ -233,5 +246,5 @@ } } - + // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È) $objQuery->setlimitoffset($page_max, $startno); @@ -240,5 +253,5 @@ // ¸¡º÷·ë²Ì¤Î¼èÆÀ $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval); - + break; } @@ -256,5 +269,5 @@ //--------------------------------------------------------------------------------------------------------------------------------------------------------- -/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */ +// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ function lfConvertParam() { global $objPage; @@ -278,10 +291,8 @@ } -/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */ +// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 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,27 +330,3 @@ } -// ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë -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); - } - } - } - } -} - ?>