Ignore:
Timestamp:
2007/07/20 15:58:59 (17 years ago)
Author:
nanasess
Message:

r15064 から svn cp
とりあえず暫定コミット.

  • UTF-8 に変更
  • slib.php, glib.php のクラス化
  • LC_Page の抽象化（一部）
Location:
branches/feature-module-update
Files:
1 edited
2 copied

Legend:

Unmodified
Added
Removed

  • branches/feature-module-update

    • Property svn:ignore set to
      .cache

      .settings

      .projectOptions

  • branches/feature-module-update/html/admin/order/index.php

    r12157 r15078  
    1515        $this->tpl_subno = 'index'; 
    1616        $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl'; 
    17         $this->tpl_subtitle = '¼õÃí´ÉÍý'; 
     17        $this->tpl_subtitle = '受注管理'; 
    1818        global $arrORDERSTATUS; 
    1919        $this->arrORDERSTATUS = $arrORDERSTATUS; 
    … …  
    3131$objView = new SC_AdminView(); 
    3232$objSess = new SC_Session(); 
    33 // ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ 
     33// パラメータ管理クラス 
    3434$objFormParam = new SC_FormParam(); 
    35 // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ 
     35// パラメータ情報の初期化 
    3636lfInitParam(); 
    3737$objFormParam->setParam($_POST); 
    … …  
    4040$objFormParam->splitParamCheckBoxes('search_payment_id'); 
    4141 
    42 // ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤® 
     42// 検索ワードの引き継ぎ 
    4343foreach ($_POST as $key => $val) { 
    4444    if (ereg("^search_", $key)) { 
    … …  
    5555} 
    5656 
    57 // ¥Ú¡¼¥¸Á÷¤êÍÑ 
     57// ページ送り用 
    5858$objPage->arrHidden['search_pageno'] = $_POST['search_pageno']; 
    5959 
    60 // ǧ¾Ú²ÄÈݤÎȽÄê 
     60// 認証可否の判定 
    6161sfIsSuccess($objSess); 
    6262 
    … …  
    7575case 'delete_all': 
    7676case 'search': 
    77     // ÆþÎÏÃͤÎÊÑ´¹ 
     77    // 入力値の変換 
    7878    $objFormParam->convParam(); 
    7979    $objPage->arrErr = lfCheckError($arrRet); 
    8080    $arrRet = $objFormParam->getHashArray(); 
    81     // ÆþÎϤʤ· 
     81    // 入力なし 
    8282    if (count($objPage->arrErr) == 0) { 
    8383        $where = "del_flg = 0"; 
    … …  
    9595                        $where .= " AND concat(order_name01,order_name02) ILIKE ?"; 
    9696                    } 
    97                     $nonsp_val = ereg_replace("[ ¡¡]+","",$val); 
     97                    $nonsp_val = ereg_replace("[ 　]+","",$val); 
    9898                    $arrval[] = "%$nonsp_val%"; 
    9999                    break; 
    … …  
    104104                        $where .= " AND concat(order_kana01,order_kana02) ILIKE ?"; 
    105105                    } 
    106                     $nonsp_val = ereg_replace("[ ¡¡]+","",$val); 
     106                    $nonsp_val = ereg_replace("[ 　]+","",$val); 
    107107                    $arrval[] = "%$nonsp_val%"; 
    108108                    break; 
    … …  
    205205        switch($_POST['mode']) { 
    206206        case 'csv': 
    207             // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê 
     207            // オプションの指定 
    208208            $option = "ORDER BY $order"; 
    209209             
    210             // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ® 
     210            // CSV出力タイトル行の作成 
    211211            $arrCsvOutput = sfSwapArray(sfgetCsvOutput(3, " WHERE csv_id = 3 AND status = 1")); 
    212212             
    … …  
    218218            $data = lfGetCSV("dtb_order", $where, $option, $arrval, $arrCsvOutputCols); 
    219219             
    220             // CSV¤òÁ÷¿®¤¹¤ë¡£ 
     220            // CSVを送信する。 
    221221            sfCSVDownload($head.$data); 
    222222            exit; 
    223223            break; 
    224224        case 'delete_all': 
    225             // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü 
     225            // 検索結果をすべて削除 
    226226            $sqlval['del_flg'] = 1; 
    227227            $objQuery = new SC_Query(); 
    … …  
    229229            break; 
    230230        default: 
    231             // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê 
     231            // 読み込む列とテーブルの指定 
    232232            $col = "*"; 
    233233            $from = "dtb_order"; 
    234234             
    235235            $objQuery = new SC_Query(); 
    236             // ¹Ô¿ô¤Î¼èÆÀ 
     236            // 行数の取得 
    237237            $linemax = $objQuery->count($from, $where, $arrval); 
    238             $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ 
    239              
    240             // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý 
     238            $objPage->tpl_linemax = $linemax;               // 何件が該当しました。表示用 
     239             
     240            // ページ送りの処理 
    241241            if(is_numeric($_POST['search_page_max'])) {  
    242242                $page_max = $_POST['search_page_max']; 
    … …  
    245245            } 
    246246             
    247             // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ 
     247            // ページ送りの取得 
    248248            $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX); 
    249249            $startno = $objNavi->start_row; 
    250250            $objPage->arrPagenavi = $objNavi->arrPagenavi;       
    251251             
    252             // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È) 
     252            // 取得範囲の指定(開始行番号、行数のセット) 
    253253            $objQuery->setlimitoffset($page_max, $startno); 
    254             // ɽ¼¨½ç½ø 
     254            // 表示順序 
    255255            $objQuery->setorder($order); 
    256             // ¸¡º÷·ë²Ì¤Î¼èÆÀ 
     256            // 検索結果の取得 
    257257            $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval); 
    258258        } 
    … …  
    265265 
    266266$objDate = new SC_Date(); 
    267 // ÅÐÏ¿¡¦¹¹¿·Æü¸¡º÷ÍÑ 
     267// 登録・更新日検索用 
    268268$objDate->setStartYear(RELEASE_YEAR); 
    269269$objDate->setEndYear(DATE("Y")); 
    270270$objPage->arrRegistYear = $objDate->getYear(); 
    271 // À¸Ç¯·îÆü¸¡º÷ÍÑ 
     271// 生年月日検索用 
    272272$objDate->setStartYear(BIRTH_YEAR); 
    273273$objDate->setEndYear(DATE("Y")); 
    274274$objPage->arrBirthYear = $objDate->getYear(); 
    275 // ·îÆü¤ÎÀßÄê 
     275// 月日の設定 
    276276$objPage->arrMonth = $objDate->getMonth(); 
    277277$objPage->arrDay = $objDate->getDay(); 
    278278 
    279 // ÆþÎÏÃͤμèÆÀ 
     279// 入力値の取得 
    280280$objPage->arrForm = $objFormParam->getFormParamList(); 
    281 // »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ 
     281// 支払い方法の取得 
    282282$arrRet = sfGetPayment(); 
    283283$objPage->arrPayment = sfArrKeyValue($arrRet, 'payment_id', 'payment_method'); 
    … …  
    287287 
    288288//----------------------------------------------------------------------------------------------------------------------------------- 
    289 /* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ 
     289/* パラメータ情報の初期化 */ 
    290290function lfInitParam() { 
    291291    global $objFormParam; 
    292     $objFormParam->addParam("¼õÃíÈÖ¹æ1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    293     $objFormParam->addParam("¼õÃíÈÖ¹æ2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    294     $objFormParam->addParam("Âбþ¾õ¶·", "search_order_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    295     $objFormParam->addParam("¸ÜµÒ̾", "search_order_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); 
    296     $objFormParam->addParam("¸ÜµÒ̾(¥«¥Ê)", "search_order_kana", STEXT_LEN, "KVCa", array("KANA_CHECK","MAX_LENGTH_CHECK")); 
    297     $objFormParam->addParam("À­ÊÌ", "search_order_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK")); 
    298     $objFormParam->addParam("ǯÎð1", "search_age1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    299     $objFormParam->addParam("ǯÎð2", "search_age2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    300     $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "search_order_email", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); 
     292    $objFormParam->addParam("受注番号1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     293    $objFormParam->addParam("受注番号2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     294    $objFormParam->addParam("対応状況", "search_order_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     295    $objFormParam->addParam("顧客名", "search_order_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); 
     296    $objFormParam->addParam("顧客名(カナ)", "search_order_kana", STEXT_LEN, "KVCa", array("KANA_CHECK","MAX_LENGTH_CHECK")); 
     297    $objFormParam->addParam("性別", "search_order_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK")); 
     298    $objFormParam->addParam("年齢1", "search_age1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     299    $objFormParam->addParam("年齢2", "search_age2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     300    $objFormParam->addParam("メールアドレス", "search_order_email", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); 
    301301    $objFormParam->addParam("TEL", "search_order_tel", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); 
    302     $objFormParam->addParam("»Ùʧ¤¤ÊýË¡", "search_payment_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    303     $objFormParam->addParam("¹ØÆþ¶â³Û1", "search_total1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    304     $objFormParam->addParam("¹ØÆþ¶â³Û2", "search_total2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    305     $objFormParam->addParam("ɽ¼¨·ï¿ô", "search_page_max", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    306     $objFormParam->addParam("³«»ÏÆü", "search_startyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    307     $objFormParam->addParam("³«»ÏÆü", "search_startmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    308     $objFormParam->addParam("³«»ÏÆü", "search_startday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    309     $objFormParam->addParam("½ªÎ»Æü", "search_endyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    310     $objFormParam->addParam("½ªÎ»Æü", "search_endmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    311     $objFormParam->addParam("½ªÎ»Æü", "search_endday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    312     $objFormParam->addParam("³«»ÏÆü", "search_sbirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    313     $objFormParam->addParam("³«»ÏÆü", "search_sbirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    314     $objFormParam->addParam("³«»ÏÆü", "search_sbirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    315     $objFormParam->addParam("½ªÎ»Æü", "search_ebirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    316     $objFormParam->addParam("½ªÎ»Æü", "search_ebirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    317     $objFormParam->addParam("½ªÎ»Æü", "search_ebirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
    318 } 
    319  
    320 /* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */ 
     302    $objFormParam->addParam("支払い方法", "search_payment_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     303    $objFormParam->addParam("購入金額1", "search_total1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     304    $objFormParam->addParam("購入金額2", "search_total2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     305    $objFormParam->addParam("表示件数", "search_page_max", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     306    $objFormParam->addParam("開始日", "search_startyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     307    $objFormParam->addParam("開始日", "search_startmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     308    $objFormParam->addParam("開始日", "search_startday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     309    $objFormParam->addParam("終了日", "search_endyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     310    $objFormParam->addParam("終了日", "search_endmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     311    $objFormParam->addParam("終了日", "search_endday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     312    $objFormParam->addParam("開始日", "search_sbirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     313    $objFormParam->addParam("開始日", "search_sbirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     314    $objFormParam->addParam("開始日", "search_sbirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     315    $objFormParam->addParam("終了日", "search_ebirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     316    $objFormParam->addParam("終了日", "search_ebirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     317    $objFormParam->addParam("終了日", "search_ebirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 
     318} 
     319 
     320/* 入力内容のチェック */ 
    321321function lfCheckError() { 
    322322    global $objFormParam; 
    323     // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ 
     323    // 入力データを渡す。 
    324324    $arrRet =  $objFormParam->getHashArray(); 
    325325    $objErr = new SC_CheckError($arrRet); 
    326326    $objErr->arrErr = $objFormParam->checkError(); 
    327327     
    328     // Æüì¹àÌÜ¥Á¥§¥Ã¥¯ 
    329     $objErr->doFunc(array("¼õÃíÈÖ¹æ1", "¼õÃíÈÖ¹æ2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK")); 
    330     $objErr->doFunc(array("ǯÎð1", "ǯÎð2", "search_age1", "search_age2"), array("GREATER_CHECK")); 
    331     $objErr->doFunc(array("¹ØÆþ¶â³Û1", "¹ØÆþ¶â³Û2", "search_total1", "search_total2"), array("GREATER_CHECK")); 
    332     $objErr->doFunc(array("³«»ÏÆü", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE")); 
    333     $objErr->doFunc(array("½ªÎ»Æü", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE")); 
    334     $objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM")); 
     328    // 特殊項目チェック 
     329    $objErr->doFunc(array("受注番号1", "受注番号2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK")); 
     330    $objErr->doFunc(array("年齢1", "年齢2", "search_age1", "search_age2"), array("GREATER_CHECK")); 
     331    $objErr->doFunc(array("購入金額1", "購入金額2", "search_total1", "search_total2"), array("GREATER_CHECK")); 
     332    $objErr->doFunc(array("開始日", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE")); 
     333    $objErr->doFunc(array("終了日", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE")); 
     334    $objErr->doFunc(array("開始日", "終了日", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM")); 
    335335     
    336     $objErr->doFunc(array("³«»ÏÆü", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array("CHECK_DATE")); 
    337     $objErr->doFunc(array("½ªÎ»Æü", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_DATE")); 
    338     $objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_SET_TERM")); 
     336    $objErr->doFunc(array("開始日", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array("CHECK_DATE")); 
     337    $objErr->doFunc(array("終了日", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_DATE")); 
     338    $objErr->doFunc(array("開始日", "終了日", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_SET_TERM")); 
    339339 
    340340    return $objErr->arrErr; 
Note: See TracChangeset for help on using the changeset viewer.