- Timestamp:
- 2010/02/12 18:13:28 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products.php
r17834 r18561 164 164 165 165 switch ($key) { 166 case 'search_product_id': 166 case 'search_product_id': // 商品ID 167 167 $where .= " AND product_id = ?"; 168 168 $view_where .= " AND product_id = ?"; … … 179 179 $view_where = $where; 180 180 break; 181 case 'search_name': 181 case 'search_name': // 商品名 182 182 $where .= " AND name ILIKE ?"; 183 183 $view_where .= " AND name ILIKE ?"; 184 184 $arrval[] = "%$val%"; 185 185 break; 186 case 'search_category_id': 186 case 'search_category_id': // カテゴリー 187 187 list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($val); 188 188 if($tmp_where != "") { … … 192 192 } 193 193 break; 194 case 'search_product_code': 194 case 'search_product_code': // 商品コード 195 195 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)"; 196 196 $view_where .= " AND EXISTS (SELECT product_id FROM dtb_products_class as cls WHERE cls.product_code ILIKE ? AND dtb_products.product_id = cls.product_id GROUP BY cls.product_id )"; 197 197 $arrval[] = "%$val%"; 198 198 break; 199 case 'search_startyear': 199 case 'search_startyear': // 登録更新日(FROM) 200 200 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']); 201 201 $where.= " AND update_date >= '" . $_POST['search_startyear'] . "/" . $_POST['search_startmonth']. "/" .$_POST['search_startday'] . "'"; 202 202 $view_where.= " AND update_date >= '" . $_POST['search_startyear'] . "/" . $_POST['search_startmonth']. "/" .$_POST['search_startday'] . "'"; 203 203 break; 204 case 'search_endyear': 204 case 'search_endyear': // 登録更新日(TO) 205 205 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']); 206 206 $date = date('Y/m/d', strtotime($date) + 86400); … … 208 208 $view_where.= " AND update_date < date('" . $date . "')"; 209 209 break; 210 case 'search_product_flag': 210 case 'search_product_flag': //種別 211 211 global $arrSTATUS; 212 212 $search_product_flag = SC_Utils_Ex::sfSearchCheckBoxes($val); … … 217 217 } 218 218 break; 219 case 'search_status': 219 case 'search_status': // ステータス 220 220 $tmp_where = ""; 221 221 foreach ($val as $element){ … … 244 244 245 245 switch($_POST['mode']) { 246 case 'csv': 247 248 require_once(CLASS_EX_PATH . "helper_extends/SC_Helper_CSV_Ex.php"); 249 250 $objCSV = new SC_Helper_CSV_Ex(); 251 // オプションの指定 252 $option = "ORDER BY $order"; 253 // CSV出力タイトル行の作成 254 $arrOutput = SC_Utils_Ex::sfSwapArray($objCSV->sfgetCsvOutput(1, " WHERE csv_id = 1 AND status = 1")); 255 256 if (count($arrOutput) <= 0) break; 257 258 $arrOutputCols = $arrOutput['col']; 259 $arrOutputTitle = $arrOutput['disp_name']; 260 261 $head = SC_Utils_Ex::sfGetCSVList($arrOutputTitle); 262 263 $data = $objCSV->lfGetProductsCSV($where, $option, $arrval, $arrOutputCols); 264 265 // CSVを送信する。 266 SC_Utils_Ex::sfCSVDownload($head.$data); 267 exit; 268 break; 269 case 'delete_all': 270 // 検索結果の取得 271 $col = "product_id"; 272 $from = "vw_products_nonclass AS noncls "; 273 $arrProducts = $objQuery->select($col, $from, $where, $arrval); 274 // 検索結果をすべて削除 275 $sqlval['del_flg'] = 1; 276 $where = "product_id = ?"; 277 if (count($arrProducts) > 0) { 278 foreach ($arrProducts as $key => $val) { 279 $objQuery->update("dtb_products", $sqlval, $where, array($arrProducts[$key]["product_id"])); 246 case 'csv': 247 require_once(CLASS_EX_PATH . "helper_extends/SC_Helper_CSV_Ex.php"); 248 249 $objCSV = new SC_Helper_CSV_Ex(); 250 251 // CSVを送信する。正常終了の場合、終了。 252 $objCSV->sfDownloadProductsCsv($where, $arrval, $order) && exit; 253 254 break; 255 case 'delete_all': 256 // 検索結果をすべて削除 257 $where = "product_id IN (SELECT product_id FROM vw_products_allclass_detail AS alldtl WHERE $where)"; 258 $sqlval['del_flg'] = 1; 259 $objQuery->update("dtb_products", $sqlval, $where, $arrval); 260 $objQuery->delete("dtb_customer_favorite_products", $where, $arrval); 261 break; 262 default: 263 // 読み込む列とテーブルの指定 264 $col = "product_id, name, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, update_date"; 265 $from = "vw_products_allclass_detail AS alldtl "; 266 267 // 行数の取得 268 $linemax = $objQuery->count("dtb_products", $view_where, $arrval); 269 $this->tpl_linemax = $linemax; // 何件が該当しました。表示用 270 271 // ページ送りの処理 272 if(is_numeric($_POST['search_page_max'])) { 273 $page_max = $_POST['search_page_max']; 274 } else { 275 $page_max = SEARCH_PMAX; 280 276 } 281 } 282 break; 283 default: 284 // 読み込む列とテーブルの指定 285 $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited"; 286 $from = "vw_products_nonclass AS noncls "; 287 288 // 行数の取得 289 $linemax = $objQuery->count("dtb_products", $view_where, $arrval); 290 $this->tpl_linemax = $linemax; // 何件が該当しました。表示用 291 292 // ページ送りの処理 293 if(is_numeric($_POST['search_page_max'])) { 294 $page_max = $_POST['search_page_max']; 295 } else { 296 $page_max = SEARCH_PMAX; 297 } 298 299 // ページ送りの取得 300 $objNavi = new SC_PageNavi($this->arrHidden['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX); 301 $startno = $objNavi->start_row; 302 $this->arrPagenavi = $objNavi->arrPagenavi; 303 304 //キャンペーン商品検索時は、全結果の商品IDを変数に格納する 305 if(isset($_POST['search_mode']) && $_POST['search_mode'] == 'campaign') { 306 $arrRet = $objQuery->select($col, $from, $where, $arrval); 307 if(count($arrRet) > 0) { 308 $arrRet = sfSwapArray($arrRet); 309 $pid = implode("-", $arrRet['product_id']); 310 $this->arrHidden['campaign_product_id'] = $pid; 277 278 // ページ送りの取得 279 $objNavi = new SC_PageNavi($this->arrHidden['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX); 280 $startno = $objNavi->start_row; 281 $this->arrPagenavi = $objNavi->arrPagenavi; 282 283 //キャンペーン商品検索時は、全結果の商品IDを変数に格納する 284 if(isset($_POST['search_mode']) && $_POST['search_mode'] == 'campaign') { 285 $arrRet = $objQuery->select($col, $from, $where, $arrval); 286 if(count($arrRet) > 0) { 287 $arrRet = sfSwapArray($arrRet); 288 $pid = implode("-", $arrRet['product_id']); 289 $this->arrHidden['campaign_product_id'] = $pid; 290 } 311 291 } 312 } 313 314 // 取得範囲の指定(開始行番号、行数のセット)315 // if(DB_TYPE != "mysql")$objQuery->setlimitoffset($page_max, $startno);316 $objQuery->setlimitoffset($page_max, $startno);317 // 表示順序318 $objQuery->setorder($order); 319 320 // 検索結果の取得321 $this->arrProducts = $objQuery->select($col, $from, $where, $arrval); 322 323 // 各商品ごとのカテゴリIDを取得324 if (count($this->arrProducts) > 0) {325 foreach ($this->arrProducts as $key => $val) {326 $this->arrProducts[$key]["categories"] = $objDb->sfGetCategoryId($val["product_id"]);327 $objDb->g_category_on = false;292 293 // 取得範囲の指定(開始行番号、行数のセット) 294 // if(DB_TYPE != "mysql") $objQuery->setlimitoffset($page_max, $startno); 295 $objQuery->setlimitoffset($page_max, $startno); 296 // 表示順序 297 $objQuery->setorder($order); 298 299 // 検索結果の取得 300 $this->arrProducts = $objQuery->select($col, $from, $where, $arrval); 301 302 // 各商品ごとのカテゴリIDを取得 303 if (count($this->arrProducts) > 0) { 304 foreach ($this->arrProducts as $key => $val) { 305 $this->arrProducts[$key]["categories"] = $objDb->sfGetCategoryId($val["product_id"]); 306 $objDb->g_category_on = false; 307 } 328 308 } 329 }330 309 } 331 310 } … … 354 333 global $objPage; 355 334 /* 356 * 357 * 358 * 359 * 360 * 335 * 文字列の変換 336 * K : 「半角(ハンカク)片仮名」を「全角片仮名」に変換 337 * C : 「全角ひら仮名」を「全角かた仮名」に変換 338 * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します 339 * n : 「全角」数字を「半角(ハンカク)」に変換 361 340 */ 362 341 $arrConvList['search_name'] = "KVa";
Note: See TracChangeset
for help on using the changeset viewer.