Changeset 1777 for temp/trunk

Timestamp:

2006/08/24 18:40:35 (20 years ago)

Author:

naka

Message:

* empty log message *

File:

• temp/trunk/html/admin/products/index_test.php (modified) (1 diff)

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

@@ -28 +28 @@
     }
 }
-
-$objPage = new LC_Page();
-$objView = new SC_AdminView();
-
-$objDate = new SC_Date();
-
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷³«»Ïǯ
-$objDate->setStartYear(RELEASE_YEAR);
-$objDate->setEndYear(DATE("Y"));
-$objPage->arrStartYear = $objDate->getYear();
-$objPage->arrStartMonth = $objDate->getMonth();
-$objPage->arrStartDay = $objDate->getDay();
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷½ªÎ»Ç¯
-$objDate->setStartYear(RELEASE_YEAR);
-$objDate->setEndYear(DATE("Y"));
-$objPage->arrEndYear = $objDate->getYear();
-$objPage->arrEndMonth = $objDate->getMonth();
-$objPage->arrEndDay = $objDate->getDay();
-
-// ǧ¾Ú²ÄÈݤÎȽÄê
-//$objSess = new SC_Session();
-//sfIsSuccess($objSess);
-
 session_start();
 
-/*
-//¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
-if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") {
-    $objQuery = new SC_Query();
-    $search_data = $objQuery->get("dtb_campaign", "search_condition", "campaign_id = ? ", array($_POST['campaign_id']));
-    $arrSearch = unserialize($search_data);
-    foreach ($arrSearch as $key => $val) {
-        $_POST[$key] = $val;
-    }
+$max = 10;
+for($i = 0; $i < $max; $i++) {
+    $objPage->arrProducts[$i]['product_id'] = $i;
 }
-
-// POSTÃͤΰú¤­·Ñ¤®
-$objPage->arrForm = $_POST;
-
-// ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
-foreach ($_POST as $key => $val) {
-    if (ereg("^search_", $key) || ereg("^campaign_", $key)) {
-        switch($key) {
-            case 'search_product_flag':
-            case 'search_status':
-                $objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val);
-                if(!is_array($val)) {
-                    $objPage->arrForm[$key] = split("-", $val);
-                }
-                break;
-            default:
-                $objPage->arrHidden[$key] = $val;
-                break;
-        }
-    }
-}
-
-// ¥Ú¡¼¥¸Á÷¤êÍÑ
-$objPage->arrHidden['search_pageno'] = $_POST['search_pageno'];
-
-// ¾¦Éʺï½ü
-if ($_POST['mode'] == "delete") {
-    if($_POST['category_id'] != "") {
-        // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü
-        $where = "category_id = " . addslashes($_POST['category_id']);
-        sfDeleteRankRecord("dtb_products", "product_id", $_POST['product_id'], $where);
-    } else {
-        sfDeleteRankRecord("dtb_products", "product_id", $_POST['product_id']);
-    }
-    // »Ò¥Æ¡¼¥Ö¥ë(¾¦Éʵ¬³Ê)¤Îºï½ü
-    $objQuery = new SC_Query();
-    $objQuery->delete("dtb_products_class", "product_id = ?", array($_POST['product_id']));
-    
-    // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô
-    sfCategory_Count($objQuery);    
-}
-
-*/
-/*
-if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") {
-    // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
-    lfConvertParam();
-    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
-    $objPage->arrErr = lfCheckError();
-
-    $where = "delete = 0";
-
-    // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
-    if (count($objPage->arrErr) == 0) {
-
-        foreach ($objPage->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;
-            }
-        }
-
-        $order = "update_date DESC";
-        $objQuery = new SC_Query();
-        
-        switch($_POST['mode']) {
-        case 'csv':
-            // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
-            $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);
-
-            // CSV¤òÁ÷¿®¤¹¤ë¡£
-            sfCSVDownload($head.$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);
-            break;
-        default:
-            /*
-            // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
-            $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'])) { 
-                $page_max = $_POST['search_page_max'];
-            } else {
-                $page_max = SEARCH_PMAX;
-            }
-
-            // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
-            $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
-            $startno = $objNavi->start_row;
-            $objPage->arrPagenavi = $objNavi->arrPagenavi;
-            
-            //¥­¥ã¥ó¥Ú¡¼¥ó¾¦Éʸ¡º÷»þ¤Ï¡¢Á´·ë²Ì¤Î¾¦ÉÊID¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë
-            if($_POST['search_mode'] == 'campaign') {
-                $arrRet = $objQuery->select($col, $from, $where, $arrval);
-                if(count($arrRet) > 0) {
-                    $arrRet = sfSwapArray($arrRet);
-                    $pid = implode("-", $arrRet['product_id']);
-                    $objPage->arrHidden['campaign_product_id'] = $pid;
-                }
-            }
-            
-            // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
-            $objQuery->setlimitoffset(10, $startno);
-            // ɽ¼¨½ç½ø
-            $objQuery->setorder($order);
-            
-            // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-            //$objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-            */
-            $max = 10;
-            for($i = 0; $i < $max; $i++) {
-                $objPage->arrProducts[$i]['product_id'] = $i;
-            }
-/*          
-            break;
-        }
-    }
-}
-*/
-
-/*
-// ¥«¥Æ¥´¥ê¤ÎÆɹþ
-$objPage->arrCatList = sfGetCategoryList();
-$objPage->arrCatIDName = lfGetIDName($objPage->arrCatList);
-*/
 
 // ²èÌ̤Îɽ¼¨