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

Timestamp:

2006/08/24 21:01:30 (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 {
@@ -11 +12 @@
     function LC_Page() {
         $this->tpl_mainpage = 'products/index.tpl';
+        $this->tpl_subnavi = 'products/subnavi.tpl';
         $this->tpl_mainno = 'products';
-        $this->tpl_subnavi = 'products/subnavi.tpl';
         $this->tpl_subno = 'index';
-        $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';
-        $this->tpl_subtitle = '¾¦ÉÊ¥Þ¥¹¥¿';
-
         global $arrPageMax;
         $this->arrPageMax = $arrPageMax;
@@ -25 +23 @@
         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();
 
@@ -51 +47 @@
 $objSess = new SC_Session();
 sfIsSuccess($objSess);
-
 //¥­¥ã¥ó¥Ú¡¼¥ó¤ÎÊÔ½¸»þ
 if(sfIsInt($_POST['campaign_id']) && $_POST['mode'] == "camp_search") {
@@ -88 +83 @@
 // ¾¦Éʺï½ü
 if ($_POST['mode'] == "delete") {
+    // ¾¦ÉʤËɳ¤Å¤¤¤¿¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë
+    lfDeleteProductFiles($_POST['product_id']);
+    
     if($_POST['category_id'] != "") {
         // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü
@@ -100 +98 @@
     
     // ·ï¿ô¥«¥¦¥ó¥È¥Ð¥Ã¥Á¼Â¹Ô
-    sfCategory_Count($objQuery);    
-}
-
+    $objQuery->getall("SELECT category_count();");  
+}
 
 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "camp_search") {
@@ -111 +108 @@
 
     $where = "delete = 0";
-
-    // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
+    
+    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
     if (count($objPage->arrErr) == 0) {
-
-        foreach ($objPage->arrForm as $key => $val) {
+            foreach ($objPage->arrForm as $key => $val) {
                 
             $val = sfManualEscape($val);
@@ -170 +166 @@
                         if ($element != ""){
                             if ($tmp_where == ""){
-                                $tmp_where.="AND (status LIKE ? ";
+                                $tmp_where.="AND (status LIKE ? "; 
                             }else{
                                 $tmp_where.="OR status LIKE ? ";
@@ -180 +176 @@
                         $tmp_where.=")";
                         $where.= "$tmp_where";
-                    }
+                    }   
                     break;
                 default:
@@ -186 +182 @@
             }
         }
-
+        
         $order = "update_date DESC";
         $objQuery = new SC_Query();
@@ -195 +191 @@
             $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);
-
+            $head = sfGetCSVList($arrPRODUCTS_CVSTITLE);
+            $data = lfGetProductsCSV($where, $option, $arrval);
             // CSV¤òÁ÷¿®¤¹¤ë¡£
             sfCSVDownload($head.$data);
@@ -220 +207 @@
             $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'])) { 
@@ -231 +218 @@
                 $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¤òÊÑ¿ô¤Ë³ÊǼ¤¹¤ë
@@ -246 +233 @@
                 }
             }
-
+            
             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
             $objQuery->setlimitoffset($page_max, $startno);
@@ -253 +240 @@
             // ¸¡º÷·ë²Ì¤Î¼èÆÀ
             $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
-
+            
             break;
         }
@@ -269 +256 @@
 //---------------------------------------------------------------------------------------------------------------------------------------------------------
 
-// ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 
+/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
 function lfConvertParam() {
     global $objPage;
@@ -291 +278 @@
 }
 
-// ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 
+/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
 // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
 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"));
@@ -330 +319 @@
 }
 
+// ¾¦Éʥ쥳¡¼¥É¤Ëɳ¤Å¤¯²èÁü¤òºï½ü¤¹¤ë
+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);
+                }
+            }
+        }
+    }
+}
+
 ?>