1 | <!--{* |
---|
2 | /* |
---|
3 | * This file is part of EC-CUBE |
---|
4 | * |
---|
5 | * Copyright(c) 2000-2010 LOCKON CO.,LTD. All Rights Reserved. |
---|
6 | * |
---|
7 | * http://www.lockon.co.jp/ |
---|
8 | * |
---|
9 | * This program is free software; you can redistribute it and/or |
---|
10 | * modify it under the terms of the GNU General Public License |
---|
11 | * as published by the Free Software Foundation; either version 2 |
---|
12 | * of the License, or (at your option) any later version. |
---|
13 | * |
---|
14 | * This program is distributed in the hope that it will be useful, |
---|
15 | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
---|
16 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
---|
17 | * GNU General Public License for more details. |
---|
18 | * |
---|
19 | * You should have received a copy of the GNU General Public License |
---|
20 | * along with this program; if not, write to the Free Software |
---|
21 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
---|
22 | */ |
---|
23 | *}--> |
---|
24 | <script type="text/javascript"> |
---|
25 | <!-- |
---|
26 | // リストボックスのサイズ変更 |
---|
27 | function ChangeSize(button, TextArea, Max, Min, row_tmp){ |
---|
28 | if(TextArea.rows <= Min){ |
---|
29 | TextArea.rows=Max; button.value="小さくする"; row_tmp.value=Max; |
---|
30 | }else{ |
---|
31 | TextArea.rows =Min; button.value="大きくする"; row_tmp.value=Min; |
---|
32 | } |
---|
33 | } |
---|
34 | |
---|
35 | // SQL確認画面起動 |
---|
36 | function doPreview(){ |
---|
37 | document.form1.mode.value="preview" |
---|
38 | document.form1.target = "_blank"; |
---|
39 | document.form1.submit(); |
---|
40 | } |
---|
41 | |
---|
42 | // formのターゲットを自分に戻す |
---|
43 | function fnTargetSelf(){ |
---|
44 | document.form1.target = "_self"; |
---|
45 | } |
---|
46 | |
---|
47 | //--> |
---|
48 | </script> |
---|
49 | |
---|
50 | <!--★★メインコンテンツ★★--> |
---|
51 | <table width="878" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
52 | <form name="form1" id="form1" method="post" action="<!--{$smarty.server.PHP_SELF|escape}-->"> |
---|
53 | <input type="hidden" name="mode" value="confirm"> |
---|
54 | <input type="hidden" name="sql_id" value="<!--{$sql_id}-->"> |
---|
55 | <input type="hidden" name="csv_output_id" value=""> |
---|
56 | <input type="hidden" name="selectTable" value=""> |
---|
57 | <tr valign="top"> |
---|
58 | <td background="<!--{$TPL_DIR}-->img/contents/navi_bg.gif" height="402"> |
---|
59 | <!--▼SUB NAVI--> |
---|
60 | <!--{include file=$tpl_subnavi}--> |
---|
61 | <!--▲SUB NAVI--> |
---|
62 | </td> |
---|
63 | <td class="mainbg"> |
---|
64 | <!--▼登録テーブルここから--> |
---|
65 | <table width="737" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
66 | <!--メインエリア--> |
---|
67 | <tr> |
---|
68 | <td align="center"> |
---|
69 | <table width="706" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
70 | <tr><td height="14"></td></tr> |
---|
71 | <tr> |
---|
72 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_top.jpg" width="706" height="14" alt=""></td> |
---|
73 | </tr> |
---|
74 | <tr> |
---|
75 | <td background="<!--{$TPL_DIR}-->img/contents/main_left.jpg"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="14" height="1" alt=""></td> |
---|
76 | <td bgcolor="#cccccc"> |
---|
77 | |
---|
78 | <!-- SQL一覧 ここから --> |
---|
79 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
80 | <tr> |
---|
81 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_top.gif" width="678" height="7" alt=""></td> |
---|
82 | </tr> |
---|
83 | <tr> |
---|
84 | <td background="<!--{$TPL_DIR}-->img/contents/contents_title_left_bg.gif"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_left.gif" width="22" height="12" alt=""></td> |
---|
85 | <td bgcolor="#636469" width="638" class="fs14n"><span class="white"><!--コンテンツタイトル-->SQL一覧</span></td> |
---|
86 | <td background="<!--{$TPL_DIR}-->img/contents/contents_title_right_bg.gif"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="18" height="1" alt=""></td> |
---|
87 | </tr> |
---|
88 | <tr> |
---|
89 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_bottom.gif" width="678" height="7" alt=""></td> |
---|
90 | </tr> |
---|
91 | <tr> |
---|
92 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_bar.jpg" width="678" height="10" alt=""></td> |
---|
93 | </tr> |
---|
94 | </table> |
---|
95 | |
---|
96 | <table width="678" border="0" cellspacing="1" cellpadding="5" summary=" "> |
---|
97 | <tr class="fs12n"> |
---|
98 | <td bgcolor="#f2f1ec" align="center" colspan=3 ><strong>SQL一覧</strong></td> |
---|
99 | </tr> |
---|
100 | |
---|
101 | <!--{ foreach key=key item=item from=$arrSqlList }--> |
---|
102 | <tr class="fs12n" height=20> |
---|
103 | <td align="center" width=600 bgcolor="<!--{if $item.sql_id == $sql_id}--><!--{$smarty.const.SELECT_RGB}--><!--{else}-->#ffffff<!--{/if}-->"> |
---|
104 | <a href="<!--{$smarty.server.PHP_SELF|escape}-->?sql_id=<!--{$item.sql_id}-->" ><!--{$item.sql_name}--></a> |
---|
105 | </td> |
---|
106 | <td align="center" width=78 bgcolor="<!--{if $item.sql_id == $sql_id}--><!--{$smarty.const.SELECT_RGB}--><!--{else}-->#ffffff<!--{/if}-->"> |
---|
107 | <input type='button' value='CSV出力' name='csv' onclick="fnTargetSelf(); fnFormModeSubmit('form1','csv_output','csv_output_id',<!--{$item.sql_id}-->);" /> |
---|
108 | </td> |
---|
109 | <td align="center" width=78 bgcolor="<!--{if $item.sql_id == $sql_id}--><!--{$smarty.const.SELECT_RGB}--><!--{else}-->#ffffff<!--{/if}-->"> |
---|
110 | <input type='button' value='削除' name='del' onclick="fnTargetSelf(); fnFormModeSubmit('form1','delete','sql_id',<!--{$item.sql_id}-->);" /> |
---|
111 | </td> |
---|
112 | </tr> |
---|
113 | <!--{ /foreach }--> |
---|
114 | </table> |
---|
115 | |
---|
116 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
117 | <tr> |
---|
118 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="5" alt=""></td> |
---|
119 | <td><img src="<!--{$TPL_DIR}-->img/contents/tbl_top.gif" width="676" height="7" alt=""></td> |
---|
120 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="5" alt=""></td> |
---|
121 | </tr> |
---|
122 | <tr> |
---|
123 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="10" alt=""></td> |
---|
124 | <td bgcolor="#e9e7de" align="center"> |
---|
125 | <table border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
126 | <tr> |
---|
127 | <td><input type='button' value='新規SQL作成' name='subm' onclick="fnTargetSelf(); fnFormModeSubmit('form1','new_page','','');" /></td> |
---|
128 | </tr> |
---|
129 | </table> |
---|
130 | </td> |
---|
131 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="10" alt=""></td> |
---|
132 | </tr> |
---|
133 | <tr> |
---|
134 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/tbl_bottom.gif" width="678" height="8" alt=""></td> |
---|
135 | </tr> |
---|
136 | </table> |
---|
137 | <!-- SQL一覧 ここまで --> |
---|
138 | |
---|
139 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
140 | <tr><td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_bar.jpg" width="678" height="10" alt=""></td></tr> |
---|
141 | </table> |
---|
142 | |
---|
143 | <!-- SQL設定 ここから --> |
---|
144 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
145 | <tr> |
---|
146 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_top.gif" width="678" height="7" alt=""></td> |
---|
147 | </tr> |
---|
148 | <tr> |
---|
149 | <td background="<!--{$TPL_DIR}-->img/contents/contents_title_left_bg.gif"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_left.gif" width="22" height="12" alt=""></td> |
---|
150 | <td bgcolor="#636469" width="638" class="fs14n"><span class="white"><!--コンテンツタイトル-->CSV出力設定</span></td> |
---|
151 | <td background="<!--{$TPL_DIR}-->img/contents/contents_title_right_bg.gif"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="18" height="1" alt=""></td> |
---|
152 | </tr> |
---|
153 | <tr> |
---|
154 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/contents_title_bottom.gif" width="678" height="7" alt=""></td> |
---|
155 | </tr> |
---|
156 | <tr> |
---|
157 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_bar.jpg" width="678" height="10" alt=""></td> |
---|
158 | </tr> |
---|
159 | </table> |
---|
160 | |
---|
161 | <table width="678" border="0" cellspacing="1" cellpadding="5" summary=" "> |
---|
162 | <tr class="fs12n"> |
---|
163 | <td bgcolor="#f2f1ec" align="center" colspan=2><strong>SQL設定</strong></td> |
---|
164 | </tr> |
---|
165 | <tr class="fs12n"> |
---|
166 | <td bgcolor="#f2f1ec" align="center" width="100">名称<span class="red"> *</span></td> |
---|
167 | <td bgcolor="#ffffff" align="left"> |
---|
168 | <span class="red12"><!--{$arrErr.sql_name}--></span> |
---|
169 | <input type="text" name="sql_name" value="<!--{$arrSqlData.sql_name|escape}-->" maxlength="<!--{$smarty.const.STEXT_LEN}-->" style="<!--{if $arrErr.name != ""}-->background-color: <!--{$smarty.const.ERR_COLOR}--><!--{/if}-->" size="60" class="box60" /><span class="red"> (上限<!--{$smarty.const.STEXT_LEN}-->文字)</span> |
---|
170 | </td> |
---|
171 | </tr> |
---|
172 | <tr class="fs12n"> |
---|
173 | <td bgcolor="#f2f1ec" align="center" width="100">SQL文<br>(SELECTは記述しないでください。)<span class="red"> *</span></td> |
---|
174 | <td bgcolor="#ffffff" align="left"> |
---|
175 | <span class="red12"><!--{$arrErr.csv_sql}--></span> |
---|
176 | <div> |
---|
177 | <textarea name="csv_sql" cols=75 rows=30 align="left" wrap=off style="<!--{if $arrErr.csv_sql != ""}-->background-color: <!--{$smarty.const.ERR_COLOR}-->;<!--{/if}--> width: 547px;"><!--{$arrSqlData.csv_sql}--></textarea> |
---|
178 | </div> |
---|
179 | </td> |
---|
180 | </tr> |
---|
181 | </table> |
---|
182 | |
---|
183 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
184 | <tr> |
---|
185 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="5" alt=""></td> |
---|
186 | <td><img src="<!--{$TPL_DIR}-->img/contents/tbl_top.gif" width="676" height="7" alt=""></td> |
---|
187 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="5" alt=""></td> |
---|
188 | </tr> |
---|
189 | <tr> |
---|
190 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="10" alt=""></td> |
---|
191 | <td bgcolor="#e9e7de" align="center"> |
---|
192 | <table border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
193 | <tr> |
---|
194 | <td> |
---|
195 | <input type="image" onMouseover="chgImgImageSubmit('<!--{$TPL_DIR}-->img/contents/btn_regist_on.jpg',this)" onMouseout="chgImgImageSubmit('<!--{$TPL_DIR}-->img/contents/btn_regist.jpg',this)" src="<!--{$TPL_DIR}-->img/contents/btn_regist.jpg" width="123" height="24" alt="この内容で登録する" border="0" name="subm" onClick="mode.value='confirm'; fnTargetSelf();"> |
---|
196 | <input type="image" onMouseover="chgImgImageSubmit('<!--{$TPL_DIR}-->img/contents/btn_confirm_on.jpg',this)" onMouseout="chgImgImageSubmit('<!--{$TPL_DIR}-->img/contents/btn_confirm.jpg',this)" src="<!--{$TPL_DIR}-->img/contents/btn_confirm.jpg" width="123" height="24" alt="確認ページへ" border="0" name="subm" onClick="doPreview(); return false;"> |
---|
197 | </td> |
---|
198 | </tr> |
---|
199 | </table> |
---|
200 | </td> |
---|
201 | <td bgcolor="#cccccc"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="1" height="10" alt=""></td> |
---|
202 | </tr> |
---|
203 | <tr> |
---|
204 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/tbl_bottom.gif" width="678" height="8" alt=""></td> |
---|
205 | </tr> |
---|
206 | </table> |
---|
207 | <!-- SQL設定 ここまで --> |
---|
208 | |
---|
209 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
210 | <tr><td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_bar.jpg" width="678" height="10" alt=""></td></tr> |
---|
211 | </table> |
---|
212 | |
---|
213 | <!-- DB一覧 ここから --> |
---|
214 | <table width="678" border="0" cellspacing="0" cellpadding="0" summary=" "> |
---|
215 | <tr> |
---|
216 | <td width="50%"> |
---|
217 | <table width="100%" border="0" cellspacing="1" cellpadding="5" summary=" "> |
---|
218 | <tr class="fs12n"> |
---|
219 | <td bgcolor="#f2f1ec" align="center" colspan=2><strong>テーブル一覧</strong></td> |
---|
220 | </tr> |
---|
221 | <tr class="fs12n"> |
---|
222 | <td bgcolor="#ffffff" align="center"> |
---|
223 | <select name="arrTableList[]" size="20" style="width:325px; height:300px;" onChange="mode.value=''; selectTable.value=this.value; submit();" onDblClick="csv_sql.value = csv_sql.value +' , ' + this.value;"> |
---|
224 | <!--{html_options options=$arrTableList selected=$selectTable}--> |
---|
225 | </select> |
---|
226 | </td> |
---|
227 | </tr> |
---|
228 | </table> |
---|
229 | </td> |
---|
230 | <td width="50%"> |
---|
231 | <table width="100%" border="0" cellspacing="1" cellpadding="5" summary=" "> |
---|
232 | <tr class="fs12n"> |
---|
233 | <td bgcolor="#f2f1ec" align="center" colspan=2><strong>項目一覧</strong></td> |
---|
234 | </tr> |
---|
235 | <tr class="fs12n"> |
---|
236 | <td bgcolor="#ffffff" align="center"> |
---|
237 | <select name="arrColList[]" size="20" style="width:325px; height:300px;" onDblClick="csv_sql.value = csv_sql.value +' , ' + this.value;"> |
---|
238 | <!--{html_options options=$arrColList}--> |
---|
239 | </select> |
---|
240 | </td> |
---|
241 | </tr> |
---|
242 | </table> |
---|
243 | </td> |
---|
244 | </tr> |
---|
245 | </table> |
---|
246 | <!-- DB一覧 ここまで --> |
---|
247 | </td> |
---|
248 | <td background="<!--{$TPL_DIR}-->img/contents/main_right.jpg"><img src="<!--{$TPL_DIR}-->img/common/_.gif" width="14" height="1" alt=""></td> |
---|
249 | </tr> |
---|
250 | <tr> |
---|
251 | <td colspan="3"><img src="<!--{$TPL_DIR}-->img/contents/main_bottom.jpg" width="706" height="14" alt=""></td> |
---|
252 | </tr> |
---|
253 | <tr><td height="30"></td></tr> |
---|
254 | </table> |
---|
255 | </td> |
---|
256 | </tr> |
---|
257 | <!--メインエリア--> |
---|
258 | </table> |
---|
259 | <!--▲登録テーブルここまで--> |
---|
260 | </td> |
---|
261 | </tr> |
---|
262 | </form> |
---|
263 | </table> |
---|
264 | <!--★★メインコンテンツ★★--> |
---|
265 | |
---|
266 | |
---|
267 | </script> |
---|