Changeset 1862 for temp/trunk
- Timestamp:
- 2006/08/24 21:01:30 (20 years ago)
- Location:
- temp/trunk/html/admin
- Files:
-
- 2 edited
-
customer/index.php (modified) (7 diffs)
-
products/index.php (modified) (18 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/customer/index.php
r1328 r1862 3 3 require_once("../require.php"); 4 4 require_once(ROOT_DIR."data/include/csv_output.inc"); 5 6 // ǧ¾Ú²ÄÈݤÎȽÄê 7 $objSess = new SC_Session(); 8 sfIsSuccess($objSess); 5 9 6 10 //---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹ … … 27 31 $this->tpl_mainpage = 'customer/index.tpl'; 28 32 $this->tpl_mainno = 'customer'; 29 $this->tpl_subnavi = 'customer/subnavi.tpl'; 30 $this->tpl_subno = 'index'; 31 $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl'; 32 $this->tpl_subtitle = '¸ÜµÒ¥Þ¥¹¥¿'; 33 33 $this->tpl_subnavi = ''; 34 $this->tpl_subno = "index"; 34 35 global $arrPref; 35 36 $this->arrPref = $arrPref; … … 49 50 } 50 51 } 52 53 54 55 //---- ¸¡º÷ÍѹàÌÜÇÛÎó 56 $arrSearchColumn = array( 57 array( "column" => "customer_id", "convert" => "n" ), 58 array( "column" => "name", "convert" => "aKV" ), 59 array( "column" => "pref", "convert" => "n" ), 60 array( "column" => "kana", "convert" => "CKV" ), 61 array( "column" => "sex", "convert" => "" ), 62 array( "column" => "b_start_year", "convert" => "n" ), 63 array( "column" => "b_start_month", "convert" => "n" ), 64 array( "column" => "b_start_day", "convert" => "n" ), 65 array( "column" => "b_end_year", "convert" => "n" ), 66 array( "column" => "b_end_month", "convert" => "n" ), 67 array( "column" => "b_end_day", "convert" => "n" ), 68 array( "column" => "tel", "convert" => "n" ), 69 array( "column" => "job", "convert" => "" ), 70 array( "column" => "birth_month", "convert" => "n" ), 71 array( "column" => "email", "convert" => "a" ), 72 array( "column" => "buy_total_from", "convert" => "n" ), 73 array( "column" => "buy_total_to", "convert" => "n" ), 74 array( "column" => "buy_times_from", "convert" => "n" ), 75 array( "column" => "buy_times_to", "convert" => "n" ), 76 array( "column" => "start_year", "convert" => "n" ), 77 array( "column" => "start_month", "convert" => "n" ), 78 array( "column" => "start_day", "convert" => "n" ), 79 array( "column" => "end_year", "convert" => "n" ), 80 array( "column" => "end_month", "convert" => "n" ), 81 array( "column" => "end_day", "convert" => "n" ), 82 array( "column" => "page_rows", "convert" => "n" ) 83 84 // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¡¢¥«¥Æ¥´¥ê¤ò¸¡º÷¹àÌܤËÄɲ乤ë START 85 ,array( "column" => "buy_start_year", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü START ǯ 86 ,array( "column" => "buy_start_month", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü START ·î 87 ,array( "column" => "buy_start_day", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü START Æü 88 ,array( "column" => "buy_end_year", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü END ǯ 89 ,array( "column" => "buy_end_month", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü END ·î 90 ,array( "column" => "buy_end_day", "convert" => "n" ) //¡¡ºÇ½ª¹ØÆþÆü END Æü 91 ,array( "column" => "buy_product_name", "convert" => "aKV" ) //¡¡¹ØÆþ¾¦ÉÊ̾ 92 ,array( "column" => "buy_product_code", "convert" => "aKV" ) //¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É 93 ,array( "column" => "category_id", "convert" => "" ) //¡¡¥«¥Æ¥´¥ê 94 // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¡¢¥«¥Æ¥´¥ê¤ò¸¡º÷¹àÌܤËÄɲ乤ë END 95 96 ,array( "column" => "cell", "convert" => "n" ) // 2006/05/10 KAKINAKA-ADD:·ÈÂÓÅÅÏäò¸¡º÷¹àÌܤËÄɲ乤ë END 97 98 ); 99 100 //---- ¥Ú¡¼¥¸½é´üÀßÄê 101 $objConn = new SC_DBConn(); 102 $objPage = new LC_Page(); 103 $objView = new SC_AdminView(); 104 $objDate = new SC_Date(1901); 105 $objPage->arrYear = $objDate->getYear(); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 106 $objPage->arrMonth = $objDate->getMonth(); 107 $objPage->arrDay = $objDate->getDay(); 108 $objPage->objDate = $objDate; 51 109 52 110 //----¡¡CSV¥À¥¦¥ó¥í¡¼¥ÉÍÑ … … 66 124 12 => array("sql" => "tel02", "csv" => "tel02", "header" => "TEL2"), 67 125 13 => array("sql" => "tel03", "csv" => "tel03", "header" => "TEL3"), 68 14 => array("sql" => "fax01", "csv" => "fax01", "header" => "FAX1"), 69 15 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"), 70 16 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"), 71 17 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ' ELSE '½÷À' END AS sex", "csv" => "sex", "header" => "ÀÊÌ"), 72 18 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"), 73 19 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"), 74 20 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"), 75 21 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"), 76 22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"), 77 23 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"), 78 24 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"), 79 25 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"), 80 26 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü") 126 127 // 2006/05/12 KAKINAKA ADD:·ÈÂÓÅÅÏÃÈÖ¹æ¤âcsv½ÐÎϤ¹¤ë START 128 14 => array("sql" => "cell01", "csv" => "cell01", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ1"), 129 15 => array("sql" => "cell02", "csv" => "cell02", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ2"), 130 16 => array("sql" => "cell03", "csv" => "cell03", "header" => "·ÈÂÓÅÅÏÃÈÖ¹æ3"), 131 // 2006/05/12 KAKINAKA ADD:·ÈÂÓÅÅÏÃÈÖ¹æ¤âcsv½ÐÎϤ¹¤ë END 132 133 17 => array("sql" => "fax01", "csv" => "fax01", "header" => "FAX1"), 134 18 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"), 135 19 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"), 136 20 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ' ELSE '½÷À' END AS sex", "csv" => "sex", "header" => "ÀÊÌ"), 137 138 // 2006/05/12 KAKINAKA DEL:¿¦¶È¤Ï½ÐÎϤ·¤Ê¤¤ START 139 //21 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"), 140 // 2006/05/12 KAKINAKA DEL:¿¦¶È¤Ï½ÐÎϤ·¤Ê¤¤ END 141 142 21 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"), 143 22 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"), 144 23 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"), 145 24 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"), 146 25 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"), 147 26 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"), 148 27 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"), 149 28 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü") 81 150 ); 82 151 83 //---- ¥Ú¡¼¥¸½é´üÀßÄê 84 $objConn = new SC_DBConn(); 85 $objPage = new LC_Page(); 86 $objView = new SC_AdminView(); 87 $objDate = new SC_Date(1901); 88 $objPage->arrYear = $objDate->getYear(); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 89 $objPage->arrMonth = $objDate->getMonth(); 90 $objPage->arrDay = $objDate->getDay(); 91 $objPage->objDate = $objDate; 92 93 // ǧ¾Ú²ÄÈݤÎȽÄê 94 $objSess = new SC_Session(); 95 sfIsSuccess($objSess); 96 97 // POSTÃͤΰú¤·Ñ¤® 98 $objPage->arrForm = $_POST; 99 100 // ¥Ú¡¼¥¸Á÷¤êÍÑ 101 $objPage->arrHidden['search_pageno'] = $_POST['search_pageno']; 102 103 // ¸¡º÷¥ï¡¼¥É¤Î°ú¤·Ñ¤® 104 foreach ($_POST as $key => $val) { 105 106 if (ereg("^search_", $key)) { 107 switch($key) { 108 case 'search_sex': 109 $objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val); 110 if(!is_array($val)) { 111 $objPage->arrForm[$key] = split("-", $val); 112 } 113 break; 114 default: 115 $objPage->arrHidden[$key] = $val; 116 break; 117 } 118 } 119 } 120 121 // ¸ÜµÒºï½ü 122 if ($_POST['mode'] == "delete") { 123 $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0"; 124 $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"])); 125 126 if ($result_customer[0]["status"] == 2) { //Ëܲñ°÷ºï½ü 127 $arrDel = array("delete" => 1, "update_date" => "NOW()"); 128 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) ); 129 } elseif ($result_customer[0]["status"] == 1) { //²¾²ñ°÷ºï½ü 130 $sql = "DELETE FROM dtb_customer WHERE customer_id = ?"; 131 $objConn->query($sql, array($_POST["edit_customer_id"])); 132 } 133 $sql = "DELETE FROM dtb_customer_mail WHERE email = ?"; 134 $objConn->query($sql, array($result_customer[0]["email"])); 135 } 136 137 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") { 138 // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹ 139 lfConvertParam(); 140 // ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 141 $objPage->arrErr = lfCheckError($objPage->arrForm); 142 143 $where = "delete = 0"; 144 145 /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */ 146 if (count($objPage->arrErr) == 0) { 147 148 //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 149 $objSelect = new SC_CustomerList($objPage->arrForm, "customer"); 150 if ($_POST["mode"] == 'csv') { 151 $searchSql = $objSelect->getListCSV($arrColumnCSV); 152 }else{ 153 $searchSql = $objSelect->getList(); 154 } 155 $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal); 156 157 switch($_POST['mode']) { 158 case 'csv': 159 $i = 0; 160 $header = ""; 161 162 // CSV¥«¥é¥à¼èÆÀ 163 $arrCsvOutput = (sfgetCsvOutput(2, " WHERE csv_id = 2 AND status = 1")); 164 165 if (count($arrCsvOutput) <= 0) break; 166 167 foreach($arrCsvOutput as $data) { 168 $arrColumn[] = $data["col"]; 169 if ($i != 0) $header .= ", "; 170 $header .= $data["disp_name"]; 171 $i ++; 172 } 173 $header .= "\n"; 174 175 //-¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹ 176 for($i = 0; $i < count($objPage->search_data); $i ++) { 177 $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ]; 178 $objPage->search_data[$i]["job"] = $arrJob[ $objPage->search_data[$i]["job"] ]; 179 } 180 181 //-¡¡CSV½ÐÎÏ 182 $data = lfGetCSVData($objPage->search_data, $arrColumn); 183 sfCSVDownload($header.$data); 184 exit; 185 break; 186 case 'delete_all': 187 // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü 188 $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)"; 189 $sqlval['delete'] = 1; 190 $objQuery->update("dtb_products", $sqlval, $where, $arrval); 191 152 //----¡¡¸ÜµÒ¾ðÊ󸡺÷ 153 if($_POST['mode'] == "search") { 154 155 //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È 156 $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn); 157 158 //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 159 $objPage->arrErr = lfErrorCheck($objPage->list_data); 160 //-- ¸¡º÷³«»Ï¤È²ñ°÷¾ðÊóºï½ü 161 if (! is_array($objPage->arrErr)) { 162 163 //-- ¸ÜµÒºï½ü»þ 164 if ($_POST["del_mode"] == "delete" && is_numeric($_POST["del_customer_id"])) { 192 165 $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0"; 193 166 $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"])); 194 167 195 168 if ($result_customer[0]["status"] == 2) { //Ëܲñ°÷ºï½ü 196 $arrDel = array("delete" => 1, "update_date" => "NOW()"); 169 $arrDel = array("delete" => 1, "update_date" => "NOW()"); 197 170 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) ); 198 171 } elseif ($result_customer[0]["status"] == 1) { //²¾²ñ°÷ºï½ü … … 201 174 } 202 175 $sql = "DELETE FROM dtb_customer_mail WHERE email = ?"; 203 $objConn->query($sql, array($result_customer[0]["email"])); 176 $objConn->query($sql, array($result_customer[0]["email"])); 177 } 204 178 205 break; 206 default: 207 208 // ¹Ô¿ô¤Î¼èÆÀ 209 $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal); 210 $objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ 211 212 // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý 213 if(is_numeric($_POST['search_page_max'])) { 214 $page_max = $_POST['search_page_max']; 215 } else { 216 $page_max = SEARCH_PMAX; 179 $objSelect = new SC_CustomerList($objPage->list_data, "customer"); 180 181 //-- ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý 182 if(is_numeric($_POST['page_rows'])) { 183 $page_max = $_POST['page_rows']; 184 } else { 185 $page_max = SEARCH_PMAX; 186 } 187 188 $objPage->count = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal); 189 $objNavi = new SC_PageNavi($_POST['pageno'], $objPage->count, $page_max, "fnCustomerPage", NAVI_PMAX); 190 191 $objPage->tpl_strnavi = $objNavi->strnavi; 192 $startno = $objNavi->start_row; 193 194 //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 195 if ($_POST["csv_mode"] == 'csv') { 196 $searchSql = $objSelect->getListCSV($arrColumnCSV); 197 } else { 198 $objSelect->setLimitOffset($_POST["page_rows"], $startno); 199 $searchSql = $objSelect->getList(); 200 } 201 202 $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal); 203 204 //--¡¡CSV¥À¥¦¥ó¥í¡¼¥É»þ 205 if ($_POST["csv_mode"] == "csv") { 206 $i = 0; 207 foreach($arrColumnCSV as $data) { 208 $arrColumn[] = $data["csv"]; 209 if ($i != 0) $header .= ", "; 210 $header .= $data["header"]; 211 $i ++; 217 212 } 218 // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ 219 $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX); 220 $startno = $objNavi->start_row; 221 $objPage->arrPagenavi = $objNavi->arrPagenavi; 222 } 223 } 224 } 225 213 $header .= "\n"; 214 215 //-¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹ 216 for($i = 0; $i < count($objPage->search_data); $i ++) { 217 $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ]; 218 $objPage->search_data[$i]["job"] = $arrJob[ $objPage->search_data[$i]["job"] ]; 219 } 220 221 //-¡¡CSV½ÐÎÏ 222 $data = lfGetCSVData($objPage->search_data, $arrColumn); 223 sfCSVDownload($header.$data); 224 exit(); 225 } 226 } 227 228 } 229 230 // 2006/04/18 KAKINAKA-ADD:¥«¥Æ¥´¥ê¤ÎÆɹþ¤òÄɲà 226 231 $objPage->arrCatList = sfGetCategoryList(); 227 232 … … 232 237 233 238 //-------------------------------------------------------------------------------------------------------------------------------------- 234 235 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹236 function lfConvertParam() {237 global $objPage;238 239 /*240 * ʸ»úÎó¤ÎÊÑ´¹241 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹242 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹243 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹244 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹245 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë246 */247 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó248 $arrConvList['search_customer_id'] = "n" ;249 $arrConvList['search_name'] = "aKV" ;250 $arrConvList['search_pref'] = "n" ;251 $arrConvList['search_kana'] = "CKV" ;252 $arrConvList['search_b_start_year'] = "n" ;253 $arrConvList['search_b_start_month'] = "n" ;254 $arrConvList['search_b_start_day'] = "n" ;255 $arrConvList['search_b_end_year'] = "n" ;256 $arrConvList['search_b_end_month'] = "n" ;257 $arrConvList['search_b_end_day'] = "n" ;258 $arrConvList['search_tel'] = "n" ;259 $arrConvList['search_birth_month'] = "n" ;260 $arrConvList['search_email'] = "a" ;261 $arrConvList['search_buy_total_from'] = "n" ;262 $arrConvList['search_buy_total_to'] = "n" ;263 $arrConvList['search_buy_times_from'] = "n" ;264 $arrConvList['search_buy_times_to'] = "n" ;265 $arrConvList['search_start_year'] = "n" ;266 $arrConvList['search_start_month'] = "n" ;267 $arrConvList['search_start_day'] = "n" ;268 $arrConvList['search_end_year'] = "n" ;269 $arrConvList['search_end_month'] = "n" ;270 $arrConvList['search_end_day'] = "n" ;271 $arrConvList['search_page_rows'] = "n" ;272 $arrConvList['search_buy_start_year'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü START ǯ273 $arrConvList['search_buy_start_month'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü START ·î274 $arrConvList['search_buy_start_day'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü START Æü275 $arrConvList['search_buy_end_year'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü END ǯ276 $arrConvList['search_buy_end_month'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü END ·î277 $arrConvList['search_buy_end_day'] = "n" ; //¡¡ºÇ½ª¹ØÆþÆü END Æü278 $arrConvList['search_buy_product_name'] = "aKV" ; //¡¡¹ØÆþ¾¦ÉÊ̾279 $arrConvList['search_buy_product_code'] = "aKV" ; //¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É280 $arrConvList['search_category_id'] = "" ; //¡¡¥«¥Æ¥´¥ê281 282 // ʸ»úÊÑ´¹283 foreach ($arrConvList as $key => $val) {284 // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£285 if(isset($objPage->arrForm[$key])) {286 $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);287 }288 }289 }290 291 292 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯293 function lfCheckError($array) {294 295 $objErr = new SC_CheckError($array);296 297 $objErr->doFunc(array("¸ÜµÒ¥³¡¼¥É", "search_customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));298 $objErr->doFunc(array("ÅÔÆ»Éܸ©", "search_pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));299 $objErr->doFunc(array("¸ÜµÒ̾", "search_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));300 $objErr->doFunc(array("¸ÜµÒ̾(¥«¥Ê)", "search_kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));301 $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array("CHECK_DATE"));302 $objErr->doFunc(array("ÃÂÀ¸Æü(½ªÎ»Æü)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_DATE"));303 $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"));304 $objErr->doFunc(array("ÃÂÀ¸·î", "search_birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));305 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "search_email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));306 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "search_tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));307 $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "search_buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));308 $objErr->doFunc(array("¹ØÆþ¶â³Û(½ªÎ»)", "search_buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));309 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"] .= "¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";310 $objErr->doFunc(array("¹ØÆþ²ó¿ô(³«»Ï)", "search_buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));311 $objErr->doFunc(array("¹ØÆþ²ó¿ô(½ªÎ»)", "search_buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));312 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"] .= "¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";313 $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "search_start_year", "search_start_month", "search_start_day",), array("CHECK_DATE"));314 $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_DATE"));315 $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"));316 $objErr->doFunc(array("ɽ¼¨·ï¿ô", "search_page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK"));317 $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(³«»ÏÆü)318 $objErr->doFunc(array("ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü)319 //¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë320 $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"));321 $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "search_buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ¥³¡¼¥É322 $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ̾", "search_buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ̾¾Î323 324 return $objErr->arrErr;325 }326 327 function lfSetWhere($arrForm){328 foreach ($arrForm as $key => $val) {329 330 $val = sfManualEscape($val);331 332 if($val == "") continue;333 334 switch ($key) {335 case 'search_product_id':336 $where .= " AND product_id = ?";337 $arrval[] = $val;338 break;339 case 'search_product_class_id':340 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";341 $arrval[] = $val;342 break;343 case 'search_name':344 $where .= " AND name ILIKE ?";345 $arrval[] = "%$val%";346 break;347 case 'search_category_id':348 list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);349 if($tmp_where != "") {350 $where.= " AND $tmp_where";351 $arrval = array_merge($arrval, $tmp_arrval);352 }353 break;354 case 'search_product_code':355 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";356 $arrval[] = "%$val%";357 break;358 case 'search_startyear':359 $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);360 $where.= " AND update_date >= ?";361 $arrval[] = $date;362 break;363 case 'search_endyear':364 $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);365 $where.= " AND update_date <= ?";366 $arrval[] = $date;367 break;368 case 'search_product_flag':369 global $arrSTATUS;370 $search_product_flag = sfSearchCheckBoxes($val);371 if($search_product_flag != "") {372 $where.= " AND product_flag LIKE ?";373 $arrval[] = $search_product_flag;374 }375 break;376 case 'search_status':377 $tmp_where = "";378 foreach ($val as $element){379 if ($element != ""){380 if ($tmp_where == ""){381 $tmp_where.="AND (status LIKE ? ";382 }else{383 $tmp_where.="OR status LIKE ? ";384 }385 $arrval[]=$element;386 }387 }388 if ($tmp_where != ""){389 $tmp_where.=")";390 $where.= "$tmp_where";391 }392 break;393 default:394 break;395 }396 }397 }398 239 399 240 //---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ … … 418 259 419 260 261 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 262 function lfConvertParam($array, $arrSearchColumn) { 263 /* 264 * ʸ»úÎó¤ÎÊÑ´¹ 265 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ 266 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ 267 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 268 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹ 269 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë 270 */ 271 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó 272 foreach ($arrSearchColumn as $data) { 273 $arrConvList[ $data["column"] ] = $data["convert"]; 274 } 275 // ʸ»úÊÑ´¹ 276 foreach ($arrConvList as $key => $val) { 277 // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£ 278 if (! is_array($array[$key]) && strlen($array[$key]) > 0) { 279 $array[$key] = mb_convert_kana($array[$key] ,$val); 280 } 281 } 282 return $array; 283 } 284 285 286 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 287 function lfErrorCheck($array) { 288 289 $objErr = new SC_CheckError($array); 290 291 $objErr->doFunc(array("¸ÜµÒ¥³¡¼¥É", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 292 $objErr->doFunc(array("ÅÔÆ»Éܸ©", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 293 $objErr->doFunc(array("¸ÜµÒ̾", "name", STEXT_LEN), array("MAX_LENGTH_CHECK")); 294 $objErr->doFunc(array("¸ÜµÒ̾(¥«¥Ê)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK")); 295 296 $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)", "b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE")); 297 $objErr->doFunc(array("ÃÂÀ¸Æü(½ªÎ»Æü)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE")); 298 $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")); 299 300 $objErr->doFunc(array("ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 301 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 302 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 303 $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 304 $objErr->doFunc(array("¹ØÆþ¶â³Û(½ªÎ»)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 305 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"] .= "¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£"; 306 $objErr->doFunc(array("¹ØÆþ²ó¿ô(³«»Ï)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 307 $objErr->doFunc(array("¹ØÆþ²ó¿ô(½ªÎ»)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 308 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"] .= "¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£"; 309 310 $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "start_year", "start_month", "start_day",), array("CHECK_DATE")); 311 $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "end_year", "end_month", "end_day"), array("CHECK_DATE")); 312 $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM")); 313 314 $objErr->doFunc(array("ɽ¼¨·ï¿ô", "page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK")); 315 316 // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¤ò¸¡º÷¹àÌܤËÄɲ乤ë START 317 $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(³«»ÏÆü) 318 $objErr->doFunc(array("ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü) 319 //¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë 320 $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")); 321 322 $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ¥³¡¼¥É 323 $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ̾", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ̾¾Î 324 // 2006/04/20 KAKINAKA-ADD:ºÇ½ª¹ØÆþÆü¡¢¹ØÆþ¾¦ÉÊ¥³¡¼¥É¡¢¹ØÆþ¾¦ÉÊ̾¾Î¤ò¸¡º÷¹àÌܤËÄɲ乤ë END 325 326 $objErr->doFunc(array("·ÈÂÓÅÅÏÃÈÖ¹æ", "cell", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); // 2006/05/10 KAKINAKA ADD:·ÈÂÓÅÅÏø¡º÷¤òÄɲà 327 328 return $objErr->arrErr; 329 } 330 420 331 ?> -
temp/trunk/html/admin/products/index.php
r1810 r1862 3 3 require_once("../require.php"); 4 4 require_once("./index_csv.php"); 5 require_once(ROOT_DIR . "data/lib/ftp.php"); 5 6 6 7 class LC_Page { … … 11 12 function LC_Page() { 12 13 $this->tpl_mainpage = 'products/index.tpl'; 14 $this->tpl_subnavi = 'products/subnavi.tpl'; 13 15 $this->tpl_mainno = 'products'; 14 $this->tpl_subnavi = 'products/subnavi.tpl';15 16 $this->tpl_subno = 'index'; 16 $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';17 $this->tpl_subtitle = '¾¦ÉÊ¥Þ¥¹¥¿';18 19 17 global $arrPageMax; 20 18 $this->arrPageMax = $arrPageMax; … … 25 23 global $arrPRODUCTSTATUS_COLOR; 26 24 $this->arrPRODUCTSTATUS_COLOR = $arrPRODUCTSTATUS_COLOR; 27 28 } 29 } 30 31 //$conn = new SC_DBConn(); 25 } 26 } 27 32 28 $objPage = new LC_Page(); 33 29 $objView = new SC_AdminView(); 34 30 $objSess = new SC_Session(); 35 31 $objDate = new SC_Date(); 36 32 … … 51 47 $objSess = new SC_Session(); 52 48 sfIsSuccess($objSess); 53 54 49 //¥¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ 55 50 if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") { … … 88 83 // ¾¦Éʺï½ü 89 84 if ($_POST['mode'] == "delete") { 85 // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë 86 lfDeleteProductFiles($_POST['product_id']); 87 90 88 if($_POST['category_id'] != "") { 91 89 // ¥é¥ó¥¯ÉÕ¤¥ì¥³¡¼¥É¤Îºï½ü … … 100 98 101 99 // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô 102 sfCategory_Count($objQuery); 103 } 104 100 $objQuery->getall("SELECT category_count();"); 101 } 105 102 106 103 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") { … … 111 108 112 109 $where = "delete = 0"; 113 114 / / ÆþÎÏ¥¨¥é¡¼¤Ê¤·110 111 /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */ 115 112 if (count($objPage->arrErr) == 0) { 116 117 foreach ($objPage->arrForm as $key => $val) { 113 foreach ($objPage->arrForm as $key => $val) { 118 114 119 115 $val = sfManualEscape($val); … … 170 166 if ($element != ""){ 171 167 if ($tmp_where == ""){ 172 $tmp_where.="AND (status LIKE ? "; 168 $tmp_where.="AND (status LIKE ? "; 173 169 }else{ 174 170 $tmp_where.="OR status LIKE ? "; … … 180 176 $tmp_where.=")"; 181 177 $where.= "$tmp_where"; 182 } 178 } 183 179 break; 184 180 default: … … 186 182 } 187 183 } 188 184 189 185 $order = "update_date DESC"; 190 186 $objQuery = new SC_Query(); … … 195 191 $option = "ORDER BY $order"; 196 192 // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ® 197 $arrOutput = sfSwapArray(sfgetCsvOutput(1, " WHERE csv_id = 1 AND status = 1")); 198 199 if (count($arrOutput) <= 0) break; 200 201 $arrOutputCols = $arrOutput['col']; 202 $arrOutputTitle = $arrOutput['disp_name']; 203 204 $head = sfGetCSVList($arrOutputTitle); 205 206 $data = lfGetProductsCSV($where, $option, $arrval, $arrOutputCols); 207 193 $head = sfGetCSVList($arrPRODUCTS_CVSTITLE); 194 $data = lfGetProductsCSV($where, $option, $arrval); 208 195 // CSV¤òÁ÷¿®¤¹¤ë¡£ 209 196 sfCSVDownload($head.$data); … … 220 207 $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited"; 221 208 $from = "vw_products_nonclass"; 222 209 223 210 // ¹Ô¿ô¤Î¼èÆÀ 224 211 $linemax = $objQuery->count($from, $where, $arrval); 225 212 $objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ 226 213 227 214 // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý 228 215 if(is_numeric($_POST['search_page_max'])) { … … 231 218 $page_max = SEARCH_PMAX; 232 219 } 233 220 234 221 // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ 235 222 $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX); 223 $objPage->tpl_strnavi = $objNavi->strnavi; // ɽ¼¨Ê¸»úÎó 236 224 $startno = $objNavi->start_row; 237 $objPage->arrPagenavi = $objNavi->arrPagenavi;238 225 239 226 //¥¥ã¥ó¥Ú¡¼¥ó¾¦Éʸ¡º÷»þ¤Ï¡¢Á´·ë²Ì¤Î¾¦ÉÊID¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë … … 246 233 } 247 234 } 248 235 249 236 // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È) 250 237 $objQuery->setlimitoffset($page_max, $startno); … … 253 240 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 254 241 $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval); 255 242 256 243 break; 257 244 } … … 269 256 //--------------------------------------------------------------------------------------------------------------------------------------------------------- 270 257 271 / / ¼èÆÀʸ»úÎó¤ÎÊÑ´¹258 /* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */ 272 259 function lfConvertParam() { 273 260 global $objPage; … … 291 278 } 292 279 293 / / ¥¨¥é¡¼¥Á¥§¥Ã¥¯280 /* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */ 294 281 // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 295 282 function lfCheckError() { 296 283 $objErr = new SC_CheckError(); 284 $objErr->doFunc(array("¾¦ÉÊID", "search_product_id", INT_LEN), array("NUM_CHECK")); 285 $objErr->doFunc(array("µ¬³ÊID", "search_product_class_id", INT_LEN), array("NUM_CHECK")); 297 286 $objErr->doFunc(array("³«»ÏÆü", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE")); 298 287 $objErr->doFunc(array("½ªÎ»Æü", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE")); … … 330 319 } 331 320 321 // ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë 322 function lfDeleteProductFiles($product_id) { 323 global $arrWEB_SERVERS; 324 $objQuery = new SC_Query(); 325 $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"; 326 $arrRet = $objQuery->select($col, "dtb_products", "product_id = ?", array($product_id)); 327 foreach($arrRet[0] as $file) { 328 if($file != "") { 329 // ¼«Ê¬¼«¿È¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë 330 $path = IMAGE_SAVE_DIR . $file; 331 if(file_exists($path)) { 332 unlink($path); 333 } 334 // ¼«Ê¬¼«¿È°Ê³°¤Î¥µ¡¼¥Ð¤Î¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë 335 foreach($arrWEB_SERVERS as $array) { 336 if($array['host'] != $_SERVER["SERVER_ADDR"]) { 337 $path = FTP_IMAGE_SAVE_DIR . $file; 338 sfFtpDelete($array['host'], $array['user'], $array['pass'], $path); 339 } 340 } 341 } 342 } 343 } 344 332 345 ?>
Note: See TracChangeset
for help on using the changeset viewer.
