Changeset 17245 for branches/version-1/html

Timestamp:

2008/04/10 02:38:22 (16 years ago)

Author:

adachi

Message:

サイバーソース連携用

File:

• branches/version-1/html/admin/order/index.php (modified) (13 diffs)

branches/version-1/html/admin/order/index.php

@@ -12 +12 @@
 }
 
+if(file_exists(MODULE_PATH . 'mdl_cybs/mdl_cybs.inc')) {
+    require_once(MODULE_PATH . 'mdl_cybs/mdl_cybs.inc');
+}
+
 class LC_Page {
     function LC_Page() {
         $this->tpl_mainpage = 'order/index.tpl';
         $this->tpl_subnavi = 'order/subnavi.tpl';
-        $this->tpl_mainno = 'order';        
+        $this->tpl_mainno = 'order';
         $this->tpl_subno = 'index';
         $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl';
@@ -60 +64 @@
                 $objPage->arrHidden[$key] = $val;
                 break;
-        }       
+        }
     }
 }
@@ -76 +80 @@
         $sqlval['del_flg'] = '1';
         $objQuery->update("dtb_order", $sqlval, $where, array($_POST['order_id']));
-    }   
+    }
 }
 
@@ -82 +86 @@
 case 'delete':
 case 'csv':
+case 'cybs_csv':
 case 'delete_all':
 case 'search':
@@ -96 +101 @@
             }
             $val = sfManualEscape($val);
-            
+
             switch ($key) {
                 case 'search_order_name':
@@ -136 +141 @@
                         }
                     }
-                    
+
                     if($tmp_where != "") {
                         $tmp_where .= ")";
                         $where .= " $tmp_where ";
-                    }                   
+                    }
                     break;
                 case 'search_order_tel':
@@ -167 +172 @@
                         }
                     }
-                    
+
                     if($tmp_where != "") {
                         $tmp_where .= ")";
@@ -215 +220 @@
                     $arrval[] = $val;
                     break;
+                // ¥µ¥¤¥Ð¡¼¥½¡¼¥¹Í¿¿®¥¹¥Æ¡¼¥¿¥¹¤Î¸¡º÷
+                case 'search_cybs_auth_status':
+                    $where.= " AND memo06 = ?";
+                    $arrval[] = MDL_CYBS_AUTH_STATUS_AUTH;
                 default:
                     break;
             }
         }
-        
+
         $order = "update_date DESC";
-        
+
         switch($_POST['mode']) {
         case 'csv':
             // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
             $option = "ORDER BY $order";
-            
+
             // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
             $arrCsvOutput = sfSwapArray(sfgetCsvOutput(3, " WHERE csv_id = 3 AND status = 1"));
-            
+
             if (count($arrCsvOutput) <= 0) break;
-            
+
             $arrCsvOutputCols = $arrCsvOutput['col'];
             $arrCsvOutputTitle = $arrCsvOutput['disp_name'];
             $head = sfGetCSVList($arrCsvOutputTitle);
             $data = lfGetCSV("dtb_order", $where, $option, $arrval, $arrCsvOutputCols);
-            
+
             // CSV¤òÁ÷¿®¤¹¤ë¡£
             sfCSVDownload($head.$data);
             exit;
             break;
+        // ¥µ¥¤¥Ð¡¼¥½¡¼¥¹ÍÑCSV¥À¥¦¥ó¥í¡¼¥É
+        case 'cybs_csv':
+            sfCybsCSVDownload($where, $arrval);
+            exit;
+            break;
         case 'delete_all':
             // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
@@ -251 +265 @@
             $col = "*";
             $from = "dtb_order";
-            
+
             $objQuery = new SC_Query();
             // ¹Ô¿ô¤Î¼èÆÀ
             $linemax = $objQuery->count($from, $where, $arrval);
             $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
-            
+
             // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
-            if(is_numeric($_POST['search_page_max'])) { 
+            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;
-        
+
             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
             $objQuery->setlimitoffset($page_max, $startno);
@@ -278 +292 @@
     }
     break;
-    
+
 default:
     break;
@@ -340 +354 @@
     $objFormParam->addParam("½ªÎ»Æü", "search_ebirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
     $objFormParam->addParam("½ªÎ»Æü", "search_ebirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+    $objFormParam->addParam("¥µ¥¤¥Ð¡¼¥½¡¼¥¹Í¿¿®¥¹¥Æ¡¼¥¿¥¹", "search_cybs_auth_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
 }
 
@@ -349 +364 @@
     $objErr = new SC_CheckError($arrRet);
     $objErr->arrErr = $objFormParam->checkError();
-    
+
     // Æüì¹àÌÜ¥Á¥§¥Ã¥¯
     $objErr->doFunc(array("¼õÃíÈÖ¹æ1", "¼õÃíÈÖ¹æ2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK"));
@@ -357 +372 @@
     $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"));
-    
+
     $objErr->doFunc(array("³«»ÏÆü", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array("CHECK_DATE"));
     $objErr->doFunc(array("½ªÎ»Æü", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_DATE"));