Changeset 15329 for branches/feature-module-update
- Timestamp:
- 2007/08/21 14:28:03 (17 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 2 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/html/admin/basis/kiyaku.php
r15080 r15329 5 5 * http://www.lockon.co.jp/ 6 6 */ 7 8 // {{{ requires 7 9 require_once("../require.php"); 10 require_once(CLASS_PATH . "page_extends/admin/basis/LC_Page_Admin_Basis_Kiyaku_Ex.php"); 8 11 9 class LC_Page { 10 var $arrSession; 11 function LC_Page() { 12 $this->tpl_mainpage = 'basis/kiyaku.tpl'; 13 $this->tpl_subnavi = 'basis/subnavi.tpl'; 14 $this->tpl_subno = 'kiyaku'; 15 $this->tpl_subtitle = '会員規約登録'; 16 $this->tpl_mainno = 'basis'; 17 } 18 } 12 // }}} 13 // {{{ generate page 19 14 20 $conn = new SC_DBConn(); 21 $objPage = new LC_Page(); 22 $objView = new SC_AdminView(); 23 $objSess = new SC_Session(); 24 $objQuery = new SC_Query(); 25 26 // 認証可否の判定 27 sfIsSuccess($objSess); 28 29 // 要求判定 30 switch($_POST['mode']) { 31 // 編集処理 32 case 'edit': 33 // POST値の引き継ぎ 34 $objPage->arrForm = $_POST; 35 // 入力文字の変換 36 $objPage->arrForm = lfConvertParam($objPage->arrForm); 37 38 // エラーチェック 39 $objPage->arrErr = lfErrorCheck(); 40 if(count($objPage->arrErr) <= 0) { 41 if($_POST['kiyaku_id'] == "") { 42 lfInsertClass($objPage->arrForm); // 新規作成 43 } else { 44 lfUpdateClass($objPage->arrForm); // 既存編集 45 } 46 // 再表示 47 sfReload(); 48 } else { 49 // POSTデータを引き継ぐ 50 $objPage->tpl_kiyaku_id = $_POST['kiyaku_id']; 51 } 52 break; 53 // 削除 54 case 'delete': 55 sfDeleteRankRecord("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id'], "", true); 56 // 再表示 57 sfReload(); 58 break; 59 // 編集前処理 60 case 'pre_edit': 61 // 編集項目をDBより取得する。 62 $where = "kiyaku_id = ?"; 63 $arrRet = $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($_POST['kiyaku_id'])); 64 // 入力項目にカテゴリ名を入力する。 65 $objPage->arrForm['kiyaku_title'] = $arrRet[0]['kiyaku_title']; 66 $objPage->arrForm['kiyaku_text'] = $arrRet[0]['kiyaku_text']; 67 // POSTデータを引き継ぐ 68 $objPage->tpl_kiyaku_id = $_POST['kiyaku_id']; 69 break; 70 case 'down': 71 sfRankDown("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']); 72 // 再表示 73 sfReload(); 74 break; 75 case 'up': 76 sfRankUp("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']); 77 // 再表示 78 sfReload(); 79 break; 80 default: 81 break; 82 } 83 84 // 規格の読込 85 $where = "del_flg <> 1"; 86 $objQuery->setorder("rank DESC"); 87 $objPage->arrKiyaku = $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where); 88 89 $objView->assignobj($objPage); 90 $objView->display(MAIN_FRAME); 91 92 //-------------------------------------------------------------------------------------------------------------------------------- 93 94 /* DBへの挿入 */ 95 function lfInsertClass($arrData) { 96 $objQuery = new SC_Query(); 97 // INSERTする値を作成する。 98 $sqlval['kiyaku_title'] = $arrData['kiyaku_title']; 99 $sqlval['kiyaku_text'] = $arrData['kiyaku_text']; 100 $sqlval['creator_id'] = $_SESSION['member_id']; 101 $sqlval['rank'] = $objQuery->max("dtb_kiyaku", "rank") + 1; 102 $sqlval['update_date'] = "Now()"; 103 $sqlval['create_date'] = "Now()"; 104 // INSERTの実行 105 $ret = $objQuery->insert("dtb_kiyaku", $sqlval); 106 return $ret; 107 } 108 109 /* DBへの更新 */ 110 function lfUpdateClass($arrData) { 111 $objQuery = new SC_Query(); 112 // UPDATEする値を作成する。 113 $sqlval['kiyaku_title'] = $arrData['kiyaku_title']; 114 $sqlval['kiyaku_text'] = $arrData['kiyaku_text']; 115 $sqlval['update_date'] = "Now()"; 116 $where = "kiyaku_id = ?"; 117 // UPDATEの実行 118 $ret = $objQuery->update("dtb_kiyaku", $sqlval, $where, array($_POST['kiyaku_id'])); 119 return $ret; 120 } 121 122 /* 取得文字列の変換 */ 123 function lfConvertParam($array) { 124 // 文字変換 125 $arrConvList['kiyaku_title'] = "KVa"; 126 $arrConvList['kiyaku_text'] = "KVa"; 127 128 foreach ($arrConvList as $key => $val) { 129 // POSTされてきた値のみ変換する。 130 if(isset($array[$key])) { 131 $array[$key] = mb_convert_kana($array[$key] ,$val); 132 } 133 } 134 return $array; 135 } 136 137 /* 入力エラーチェック */ 138 function lfErrorCheck() { 139 $objErr = new SC_CheckError(); 140 $objErr->doFunc(array("規約タイトル", "kiyaku_title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 141 $objErr->doFunc(array("規約内容", "kiyaku_text", MLTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 142 if(!isset($objErr->arrErr['name'])) { 143 $objQuery = new SC_Query(); 144 $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title'])); 145 // 編集中のレコード以外に同じ名称が存在する場合 146 if ($arrRet[0]['kiyaku_id'] != $_POST['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $_POST['kiyaku_title']) { 147 $objErr->arrErr['name'] = "※ 既に同じ内容の登録が存在します。<br>"; 148 } 149 } 150 return $objErr->arrErr; 151 } 15 $objPage = new LC_Page_Admin_Basis_Kiyaku_Ex(); 16 $objPage->init(); 17 $objPage->process(); 18 register_shutdown_function(array($objPage, "destroy")); 152 19 ?> 20 ?>
Note: See TracChangeset
for help on using the changeset viewer.