Changeset 1863 for temp/trunk/html/admin/products

Timestamp:

2006/08/24 21:02:04 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/products/index.php (modified) (18 diffs)

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

@@ -3 +3 @@
 require_once("../require.php");
 require_once("./index_csv.php");
-require_once(ROOT_DIR . "data/lib/ftp.php");
 
 class LC_Page {
@@ -12 +11 @@
     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 +25 @@
         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 +51 @@
 $objSess = new SC_Session();
 sfIsSuccess($objSess);
+
 //¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
 if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") {
@@ -83 +88 @@
 // ¾¦Éʺï½ü
 if ($_POST['mode'] == "delete") {
-    // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë
-    lfDeleteProductFiles($_POST['product_id']);
-    
     if($_POST['category_id'] != "") {
         // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü
@@ -98 +100 @@
     
     // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô
-    $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 +111 @@
 
     $where = "delete = 0";
-    
-    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
+
+    // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
     if (count($objPage->arrErr) == 0) {
-            foreach ($objPage->arrForm as $key => $val) {
+
+        foreach ($objPage->arrForm as $key => $val) {
                 
             $val = sfManualEscape($val);
@@ -166 +170 @@
                         if ($element != ""){
                             if ($tmp_where == ""){
-                                $tmp_where.="AND (status LIKE ? "; 
+                                $tmp_where.="AND (status LIKE ? ";
                             }else{
                                 $tmp_where.="OR status LIKE ? ";
@@ -176 +180 @@
                         $tmp_where.=")";
                         $where.= "$tmp_where";
-                    }   
+                    }
                     break;
                 default:
@@ -182 +186 @@
             }
         }
-        
+
         $order = "update_date DESC";
         $objQuery = new SC_Query();
@@ -191 +195 @@
             $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 +220 @@
             $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 +231 @@
                 $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 +246 @@
                 }
             }
-            
+
             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
             $objQuery->setlimitoffset($page_max, $startno);
@@ -240 +253 @@
             // ¸¡º÷·ë²Ì¤Î¼èÆÀ
             $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-            
+
             break;
         }
@@ -256 +269 @@
 //---------------------------------------------------------------------------------------------------------------------------------------------------------
 
-/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
+// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 
 function lfConvertParam() {
     global $objPage;
@@ -278 +291 @@
 }
 
-/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
+// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 
 // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
 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 +330 @@
 }
 
-// ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë
-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);
-                }
-            }
-        }
-    }
-}
-
 ?>