Changeset 15679 for branches/feature-module-update
- Timestamp:
- 2007/09/11 20:40:40 (17 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 2 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/html/admin/contents/csv.php
r15532 r15679 5 5 * http://www.lockon.co.jp/ 6 6 */ 7 8 // {{{ requires 7 9 require_once("../../require.php"); 8 require_once( DATA_PATH . "include/csv_output.inc");10 require_once(CLASS_PATH . "page_extends/admin/contents/LC_Page_Admin_Contents_CSV_Ex.php"); 9 11 10 class LC_Page { 11 var $arrForm; 12 var $arrHidden; 12 // }}} 13 // {{{ generate page 13 14 14 function LC_Page() { 15 $this->tpl_mainpage = 'contents/csv.tpl'; 16 $this->tpl_subnavi = 'contents/subnavi.tpl'; 17 $this->tpl_subno = 'csv'; 18 $this->tpl_subno_csv = $this->arrSubnavi[1]; 19 $this->tpl_mainno = "contents"; 20 $this->tpl_subtitle = 'CSV出力設定'; 21 } 22 } 23 $objPage = new LC_Page(); 24 $objView = new SC_AdminView(); 25 $objSess = new SC_Session(); 26 27 $objPage->arrSubnavi = $arrSubnavi; 28 $objPage->arrSubnaviName = $arrSubnaviName; 29 30 // 認証可否の判定 31 $objSess = new SC_Session(); 32 sfIsSuccess($objSess); 33 34 $arrOutput = array(); 35 $arrChoice = array(); 36 37 $get_tpl_subno_csv = $_GET['tpl_subno_csv']; 38 // GETで値が送られている場合にはその値を元に画面表示を切り替える 39 if ($get_tpl_subno_csv != ""){ 40 // 送られてきた値が配列に登録されていなければTOPを表示 41 if (in_array($get_tpl_subno_csv,$objPage->arrSubnavi)){ 42 $subno_csv = $get_tpl_subno_csv; 43 }else{ 44 $subno_csv = $objPage->arrSubnavi[1]; 45 } 46 } else { 47 // GETで値がなければPOSTの値を使用する 48 if ($_POST['tpl_subno_csv'] != ""){ 49 $subno_csv = $_POST['tpl_subno_csv']; 50 }else{ 51 $subno_csv = $objPage->arrSubnavi[1]; 52 } 53 } 54 55 // subnoの番号を取得 56 $subno_id = array_keys($objPage->arrSubnavi,$subno_csv); 57 $subno_id = $subno_id[0]; 58 // データの登録 59 if ($_POST["mode"] == "confirm") { 60 61 // エラーチェック 62 $objPage->arrErr = lfCheckError($_POST['output_list']); 63 64 if (count($objPage->arrErr) <= 0){ 65 // データの更新 66 lfUpdCsvOutput($subno_id, $_POST['output_list']); 67 68 // 画面のリロード 69 sfReload("tpl_subno_csv=$subno_csv"); 70 } 71 } 72 73 // 出力項目の取得 74 $arrOutput = sfSwapArray(sfgetCsvOutput($subno_csv, "WHERE csv_id = ? AND status = 1", array($subno_id))); 75 $arrOutput = sfarrCombine($arrOutput['col'], $arrOutput['disp_name']); 76 77 // 非出力項目の取得 78 $arrChoice = sfSwapArray(sfgetCsvOutput($subno_csv, "WHERE csv_id = ? AND status = 2", array($subno_id))); 79 $arrChoice = sfarrCombine($arrChoice['col'], $arrChoice['disp_name']); 80 81 $objPage->arrOutput=$arrOutput; 82 $objPage->arrChoice=$arrChoice; 83 84 85 $objPage->SubnaviName = $objPage->arrSubnaviName[$subno_id]; 86 $objPage->tpl_subno_csv = $subno_csv; 87 88 // 画面の表示 89 $objView->assignobj($objPage); 90 $objView->display(MAIN_FRAME); 91 92 //--------------------------------------------------------------------------------------------------------------------------------------------------------- 93 /************************************************************************************************************** 94 * 関数名 :lfUpdCsvOutput 95 * 処理内容 :CSV出力項目を更新する 96 * 引数 :なし 97 **************************************************************************************************************/ 98 function lfUpdCsvOutput($csv_id, $arrData = array()){ 99 $objQuery = new SC_Query(); 100 101 // ひとまず、全部使用しないで更新する 102 $upd_sql = "UPDATE dtb_csv SET status = 2, rank = NULL, update_date = now() WHERE csv_id = ?"; 103 $objQuery->query($upd_sql, array($csv_id)); 104 105 // 使用するものだけ、再更新する。 106 if (is_array($arrData)) { 107 foreach($arrData as $key => $val){ 108 $upd_sql = "UPDATE dtb_csv SET status = 1, rank = ? WHERE csv_id = ? AND col = ? "; 109 $objQuery->query($upd_sql, array($key+1, $csv_id,$val)); 110 } 111 } 112 } 113 114 /************************************************************************************************************** 115 * 関数名 :lfUpdCsvOutput 116 * 処理内容 :CSV出力項目を更新する 117 * 引数 :なし 118 * 戻値 :なし 119 **************************************************************************************************************/ 120 function lfCheckError($data){ 121 $objErr = new SC_CheckError(); 122 $objErr->doFunc( array("出力項目", "output_list"), array("EXIST_CHECK") ); 123 124 return $objErr->arrErr; 125 126 } 127 15 $objPage = new LC_Page_Admin_Contents_CSV_Ex(); 16 $objPage->init(); 17 $objPage->process(); 18 register_shutdown_function(array($objPage, "destroy")); 19 ?>
Note: See TracChangeset
for help on using the changeset viewer.