1 | <?php
|
---|
2 | /*
|
---|
3 | * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
|
---|
4 | *
|
---|
5 | * http://www.lockon.co.jp/
|
---|
6 | */
|
---|
7 | require_once("../require.php");
|
---|
8 |
|
---|
9 | class LC_Page {
|
---|
10 | var $arrSession;
|
---|
11 | function LC_Page() {
|
---|
12 | $this->tpl_mainpage = 'products/trackback_edit.tpl';
|
---|
13 | $this->tpl_subnavi = 'products/subnavi.tpl';
|
---|
14 | $this->tpl_mainno = 'products';
|
---|
15 | $this->tpl_subno = 'trackback';
|
---|
16 | $this->tpl_subtitle = '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯´ÉÍý';
|
---|
17 | }
|
---|
18 | }
|
---|
19 |
|
---|
20 | $objPage = new LC_Page();
|
---|
21 | $objView = new SC_AdminView();
|
---|
22 | $objSess = new SC_Session();
|
---|
23 | $objQuery = new SC_Query();
|
---|
24 |
|
---|
25 | // ǧ¾Ú²ÄÈݤÎȽÄê
|
---|
26 | sfIsSuccess($objSess);
|
---|
27 |
|
---|
28 | //¸¡º÷¥ï¡¼¥É¤Î°ú·Ñ¤®
|
---|
29 | foreach ($_POST as $key => $val){
|
---|
30 | if (ereg("^search_", $key)){
|
---|
31 | $objPage->arrSearchHidden[$key] = $val;
|
---|
32 | }
|
---|
33 | }
|
---|
34 |
|
---|
35 | //¼èÆÀʸ»úÎó¤ÎÊÑ´¹ÍÑ¥«¥é¥à
|
---|
36 | $arrRegistColumn = array (
|
---|
37 | array( "column" => "update_date"),
|
---|
38 | array( "column" => "status"),
|
---|
39 | array( "column" => "title","convert" => "KVa"),
|
---|
40 | array( "column" => "excerpt","convert" => "KVa"),
|
---|
41 | array( "column" => "blog_name","convert" => "KVa"),
|
---|
42 | array( "column" => "url","convert" => "KVa"),
|
---|
43 | array( "column" => "del_flg","convert" => "n")
|
---|
44 | );
|
---|
45 |
|
---|
46 | // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ID¤òÅϤ¹
|
---|
47 | $objPage->tpl_trackback_id = $_POST['trackback_id'];
|
---|
48 | // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¥«¥é¥à¤Î¼èÆÀ
|
---|
49 | $objPage->arrTrackback = lfGetTrackbackData($_POST['trackback_id']);
|
---|
50 | // ¾¦Éʤ´¤È¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯É½¼¨¿ô¼èÆÀ
|
---|
51 | $count = $objQuery->count("dtb_trackback", "del_flg = 0 AND product_id = ?", array($objPage->arrTrackback['product_id']));
|
---|
52 | // ξÊýÁªÂò²Äǽ
|
---|
53 | $objPage->tpl_status_change = true;
|
---|
54 |
|
---|
55 | switch($_POST['mode']) {
|
---|
56 | // ÅÐÏ¿
|
---|
57 | case 'complete':
|
---|
58 | //¥Õ¥©¡¼¥àÃͤÎÊÑ´¹
|
---|
59 | $arrReview = lfConvertParam($_POST, $arrRegistColumn);
|
---|
60 | $objPage->arrErr = lfCheckError($arrTrackback);
|
---|
61 | //¥¨¥é¡¼Ìµ¤·
|
---|
62 |
|
---|
63 | if (!$objPage->arrErr) {
|
---|
64 | //¥ì¥Ó¥å¡¼¾ðÊó¤ÎÊÔ½¸ÅÐÏ¿
|
---|
65 | lfRegistTrackbackData($arrTrackback, $arrRegistColumn);
|
---|
66 | $objPage->arrTrackback = $arrTrackback;
|
---|
67 | $objPage->tpl_onload = "confirm('ÅÐÏ¿¤¬´°Î»¤·¤Þ¤·¤¿¡£');";
|
---|
68 | }
|
---|
69 | break;
|
---|
70 |
|
---|
71 | default:
|
---|
72 | break;
|
---|
73 | }
|
---|
74 |
|
---|
75 | $objView->assignobj($objPage);
|
---|
76 | $objView->display(MAIN_FRAME);
|
---|
77 |
|
---|
78 | //------------------------------------------------------------------------------------------------------------------------------------
|
---|
79 |
|
---|
80 | // ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
|
---|
81 | function lfCheckError($array) {
|
---|
82 | $objErr = new SC_CheckError($array);
|
---|
83 | $objErr->doFunc(array("¥Ö¥í¥°Ì¾", "blog_name", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
|
---|
84 | $objErr->doFunc(array("¥Ö¥í¥°µ»ö¥¿¥¤¥È¥ë", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
|
---|
85 | $objErr->doFunc(array("¥Ö¥í¥°µ»öÆâÍÆ", "excerpt", LTEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
|
---|
86 | $objErr->doFunc(array("¥Ö¥í¥°URL", "url", URL_LEN), array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
|
---|
87 | $objErr->doFunc(array("¾õÂÖ", "status"), array("SELECT_CHECK"));
|
---|
88 | return $objErr->arrErr;
|
---|
89 | }
|
---|
90 |
|
---|
91 | //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹
|
---|
92 | function lfConvertParam($array, $arrRegistColumn) {
|
---|
93 | /*
|
---|
94 | * ʸ»úÎó¤ÎÊÑ´¹
|
---|
95 | * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
|
---|
96 | * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
|
---|
97 | * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹
|
---|
98 | * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹
|
---|
99 | * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
|
---|
100 | */
|
---|
101 | // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó
|
---|
102 | foreach ($arrRegistColumn as $data) {
|
---|
103 | $arrConvList[ $data["column"] ] = $data["convert"];
|
---|
104 | }
|
---|
105 |
|
---|
106 | // ʸ»úÊÑ´¹
|
---|
107 | foreach ($arrConvList as $key => $val) {
|
---|
108 | // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
|
---|
109 | if(strlen(($array[$key])) > 0) {
|
---|
110 | $array[$key] = mb_convert_kana($array[$key] ,$val);
|
---|
111 | }
|
---|
112 | }
|
---|
113 | return $array;
|
---|
114 | }
|
---|
115 |
|
---|
116 | // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¼èÆÀ
|
---|
117 | function lfGetTrackbackData($trackback_id) {
|
---|
118 | global $objPage;
|
---|
119 | global $objQuery;
|
---|
120 | $select = "tra.trackback_id, tra.product_id, tra.blog_name, tra.title, tra.excerpt, ";
|
---|
121 | $select .= "tra.url, tra.status, tra.create_date, tra.update_date, pro.name ";
|
---|
122 | $from = "dtb_trackback AS tra LEFT JOIN dtb_products AS pro ON tra.product_id = pro.product_id ";
|
---|
123 | $where = "tra.del_flg = 0 AND pro.del_flg = 0 AND tra.trackback_id = ? ";
|
---|
124 | $arrTrackback = $objQuery->select($select, $from, $where, array($trackback_id));
|
---|
125 | if(!empty($arrTrackback)) {
|
---|
126 | $objPage->arrTrackback = $arrTrackback[0];
|
---|
127 | } else {
|
---|
128 | sfDispError("");
|
---|
129 | }
|
---|
130 | return $objPage->arrTrackback;
|
---|
131 | }
|
---|
132 |
|
---|
133 | // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤ÎÊÔ½¸ÅÐÏ¿
|
---|
134 | function lfRegistTrackbackData($array, $arrRegistColumn) {
|
---|
135 | global $objQuery;
|
---|
136 |
|
---|
137 | foreach ($arrRegistColumn as $data) {
|
---|
138 | if (strlen($array[ $data["column"] ]) > 0 ) {
|
---|
139 | $arrRegist[ $data["column"] ] = $array[ $data["column"] ];
|
---|
140 | }
|
---|
141 | if ($data['column'] == 'update_date'){
|
---|
142 | $arrRegist['update_date'] = 'now()';
|
---|
143 | }
|
---|
144 | }
|
---|
145 | //ÅÐÏ¿¼Â¹Ô
|
---|
146 | $objQuery->begin();
|
---|
147 | $objQuery->update("dtb_trackback", $arrRegist, "trackback_id = '".$_POST['trackback_id']."'");
|
---|
148 | $objQuery->commit();
|
---|
149 | }
|
---|
150 | ?> |
---|