source: branches/comu/html/admin/basis/seo.php @ 2

Revision 2, 4.9 KB checked in by root, 17 years ago (diff)

new import

Line 
1<?php
2/*
3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../../require.php");
8require_once(DATA_PATH . "include/page_layout.inc");
9
10class LC_Page {
11    var $arrSession;
12    var $tpl_mode;
13    function LC_Page() {
14        $this->tpl_mainpage = 'basis/seo.tpl';
15        $this->tpl_subnavi = 'basis/subnavi.tpl';
16        $this->tpl_subno = 'seo';
17        $this->tpl_mainno = 'basis';
18        $this->tpl_subtitle = 'SEO´ÉÍý';
19        global $arrPref;
20        $this->arrPref = $arrPref;
21        global $arrTAXRULE;
22        $this->arrTAXRULE = $arrTAXRULE;
23       
24    }
25}
26
27
28$conn = new SC_DBConn();
29$objPage = new LC_Page();
30$objView = new SC_AdminView();
31$objSess = new SC_Session();
32$objQuery = new SC_Query();
33
34// ǧ¾Ú²ÄÈݤÎȽÄê
35sfIsSuccess($objSess);
36
37// ¥Ç¡¼¥¿¤Î¼èÆÀ
38$arrPageData = lfgetPageData(" edit_flg = 2 ");
39$objPage->arrPageData = $arrPageData;
40
41$page_id = $_POST['page_id'];
42
43if($_POST['mode'] == "confirm") {
44    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
45    $objPage->arrErr[$page_id] = lfErrorCheck($arrPOST['meta'][$page_id]);
46   
47    // ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð¥Ç¡¼¥¿¤ò¹¹¿·
48    if(count($objPage->arrErr[$page_id]) == 0) {
49
50        // ¹¹¿·¥Ç¡¼¥¿¤ÎÊÑ´¹
51        $arrMETA = lfConvertParam($_POST['meta'][$page_id]);
52
53        // ¹¹¿·¥Ç¡¼¥¿ÇÛÎóÀ¸À®
54        $arrUpdData = array($arrMETA['author'], $arrMETA['description'], $arrMETA['keyword'], $page_id);
55        // ¥Ç¡¼¥¿¹¹¿·
56        lfUpdPageData($arrUpdData);
57    }else{ 
58        // POST¤Î¥Ç¡¼¥¿¤òºÆɽ¼¨
59        $arrPageData = lfSetData($arrPageData, $arrPOST['meta']);
60        $objPage->arrPageData = $arrPageData;
61    }
62}
63
64// ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð¥Ç¡¼¥¿¤Î¼èÆÀ
65if(count($objPage->arrErr[$page_id]) == 0) {
66    // ¥Ç¡¼¥¿¤Î¼èÆÀ
67    $arrPageData = lfgetPageData(" edit_flg = 2 ");
68    $objPage->arrPageData = $arrPageData;
69}
70
71// ɽ¼¨Ž¥Èóɽ¼¨ÀÚ¤êÂؤ¨
72$arrDisp_flg = array();
73foreach($arrPageData as $key => $val){
74    $arrDisp_flg[$val['page_id']] = $_POST['disp_flg'.$val['page_id']];
75}
76
77$objPage->disp_flg = $arrDisp_flg;
78
79$objView->assignobj($objPage);
80$objView->display(MAIN_FRAME);
81//--------------------------------------------------------------------------------------------------------------------------------------
82/**************************************************************************************************************
83 * ´Ø¿ô̾   ¡§lfUpdPageData
84 * ½èÍýÆâÍÆ ¡§¥Ú¡¼¥¸¥ì¥¤¥¢¥¦¥È¥Æ¡¼¥Ö¥ë¤Ë¥Ç¡¼¥¿¹¹¿·¤ò¹Ô¤¦
85 * °ú¿ô     ¡§¹¹¿·¥Ç¡¼¥¿
86 * Ìá¤êÃÍ   ¡§¹¹¿··ë²Ì
87 **************************************************************************************************************/
88function lfUpdPageData($arrUpdData = array()){
89    $objQuery = new SC_Query();
90    $sql = "";
91
92    // SQLÀ¸À®
93    $sql .= " UPDATE ";
94    $sql .= "     dtb_pagelayout ";
95    $sql .= " SET ";
96    $sql .= "     author = ? , ";
97    $sql .= "     description = ? , ";
98    $sql .= "     keyword = ? ";
99    $sql .= " WHERE ";
100    $sql .= "     page_id = ? ";
101    $sql .= " ";
102
103    // SQL¼Â¹Ô
104    $ret = $objQuery->query($sql, $arrUpdData);
105   
106    return $ret;   
107}
108
109/**************************************************************************************************************
110 * ´Ø¿ô̾   ¡§lfErrorCheck
111 * ½èÍýÆâÍÆ ¡§ÆþÎϹàÌܤΥ¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦
112 * °ú¿ô     ¡§¥¨¥é¡¼¥Á¥§¥Ã¥¯Âоݥǡ¼¥¿
113 * Ìá¤êÃÍ   ¡§¥¨¥é¡¼ÆâÍÆ
114 **************************************************************************************************************/
115function lfErrorCheck($array) {
116    $objErr = new SC_CheckError($array);
117   
118    $objErr->doFunc(array("¥á¥¿¥¿¥°:Author", "author", STEXT_LEN), array("MAX_LENGTH_CHECK"));
119    $objErr->doFunc(array("¥á¥¿¥¿¥°:Description", "description", STEXT_LEN), array("MAX_LENGTH_CHECK"));
120    $objErr->doFunc(array("¥á¥¿¥¿¥°:Keywords", "keyword", STEXT_LEN), array("MAX_LENGTH_CHECK"));
121
122    return $objErr->arrErr;
123}
124
125/**************************************************************************************************************
126 * ´Ø¿ô̾   ¡§lfSetData
127 * ½èÍýÆâÍÆ ¡§¥Æ¥ó¥×¥ì¡¼¥Èɽ¼¨¥Ç¡¼¥¿¤ËÃͤò¥»¥Ã¥È¤¹¤ë
128 * °ú¿ô1    ¡§É½¼¨¸µ¥Ç¡¼¥¿
129 * °ú¿ô2    ¡§É½¼¨¥Ç¡¼¥¿
130 * Ìá¤êÃÍ   ¡§É½¼¨¥Ç¡¼¥¿
131 **************************************************************************************************************/
132function lfSetData($arrPageData, $arrDispData){
133   
134    foreach($arrPageData as $key => $val){
135        $page_id = $val['page_id'];
136        $arrPageData[$key]['author'] = $arrDispData[$page_id]['author'];
137        $arrPageData[$key]['description'] = $arrDispData[$page_id]['description'];
138        $arrPageData[$key]['keyword'] = $arrDispData[$page_id]['keyword'];
139    }
140   
141    return $arrPageData;
142}
143
144/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
145function lfConvertParam($array) {
146    /*
147     *  ʸ»úÎó¤ÎÊÑ´¹
148     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
149     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
150     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 
151     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
152     *  a :  Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
153     */
154    // ¿Íʪ´ðËܾðÊó
155   
156    // ¥¹¥Ý¥Ã¥È¾¦ÉÊ
157    $arrConvList['author'] = "KVa";
158    $arrConvList['description'] = "KVa";
159    $arrConvList['keyword'] = "KVa";
160
161    // ʸ»úÊÑ´¹
162    foreach ($arrConvList as $key => $val) {
163        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
164        if(isset($array[$key])) {
165            $array[$key] = mb_convert_kana($array[$key] ,$val);
166        }
167    }
168    return $array;
169}
170
171
172?>
Note: See TracBrowser for help on using the repository browser.