Changeset 1638 for temp/trunk/html/admin

Timestamp:

2006/08/24 14:06:27 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/products/index2.php (modified) (3 diffs)

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

@@ -37 +37 @@
 $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);
-//¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
-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;
-    }
-}
-
-// 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($page_max, $startno);
-            // ɽ¼¨½ç½ø
-            $objQuery->setorder($order);
-            // ¸¡º÷·ë²Ì¤Î¼èÆÀ
-            $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-//          $arrProducts = $objQuery->select($col, $from, $where, $arrval);
-            
-//          $objPage->arrTest = $arrProducts;
-            
-            $objPage->tpl_mainpage="products/test.tpl";
-
-            break;
-        }
-    }
-}
-/*
 $arrProducts = Array
 (
@@ -409 +180 @@
 
 
-$objPage->arrProducts = $arrProducts;
-*/
-
-// ¥«¥Æ¥´¥ê¤ÎÆɹþ
-$objPage->arrCatList = sfGetCategoryList();
-$objPage->arrCatIDName = lfGetIDName($objPage->arrCatList);
-
 // ²èÌ̤Îɽ¼¨
 $objView->assignobj($objPage);
@@ -422 +186 @@
 //---------------------------------------------------------------------------------------------------------------------------------------------------------
 
-// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 
-function lfConvertParam() {
-    global $objPage;
-    /*
-     *  ʸ»úÎó¤ÎÊÑ´¹
-     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
-     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
-     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹  
-     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
-     */
-    $arrConvList['search_name'] = "KVa";
-    $arrConvList['search_product_code'] = "KVa";
-    
-    // ʸ»úÊÑ´¹
-    foreach ($arrConvList as $key => $val) {
-        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
-        if(isset($objPage->arrForm[$key])) {
-            $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
-        }
-    }
-}
-
-// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 
-// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
-function lfCheckError() {
-    $objErr = new SC_CheckError();
-    $objErr->doFunc(array("³«»ÏÆü", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
-    $objErr->doFunc(array("½ªÎ»Æü", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE"));
-    $objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM"));
-    return $objErr->arrErr;
-}
-
-// ¥Á¥§¥Ã¥¯¥Ü¥Ã¥¯¥¹ÍÑWHEREʸºîÀ®
-function lfGetCBWhere($key, $max) {
-    $str = "";
-    $find = false;
-    for ($cnt = 1; $cnt <= $max; $cnt++) {
-        if ($_POST[$key . $cnt] == "1") {
-            $str.= "1";
-            $find = true;
-        } else {
-            $str.= "_";
-        }
-    }
-    if (!$find) {
-        $str = "";
-    }
-    return $str;
-}
-
-// ¥«¥Æ¥´¥êID¤ò¥­¡¼¡¢¥«¥Æ¥´¥ê̾¤òÃͤˤ¹¤ëÇÛÎó¤òÊÖ¤¹¡£
-function lfGetIDName($arrCatList) {
-    $max = count($arrCatList);
-    for ($cnt = 0; $cnt < $max; $cnt++ ) {
-        $key = $arrCatList[$cnt]['category_id'];
-        $val = $arrCatList[$cnt]['category_name'];
-        $arrRet[$key] = $val;   
-    }
-    return $arrRet;
-}
-
 ?>