세금 계산서 스킨 질문..... 정보
세금 계산서 스킨 질문.....본문
세금계산서 스킨을 사용하는데.....
"등록정보"에 글을쓰려고 하면 팝업이 뜨면서...위 그림처럼.....
select count(*) as cnt from synd_c_member where (1) order by no desc
1146 : Table 'spectrum.synd_c_member' doesn't exist
$sql_order = " order by $sst $sod ";
window.close();
return false;
}
</script>
<? }
error file : /home/skin/board/tax/impom.php
뜹니다.
수정하라는...write_update.skin.php도 수정 하였습니다..
카이루님의 세금계산서 스킨의...http://sir.co.kr/bbs/tb.php/g4_skin_board/9459의
ssyoung 4버전을 다운받았습니다..
답변 부탁 드립니다..
impom.php
<?
$g4_path = "../../..";
include_once("$g4_path/common.php");
$g4['title'] = "";
include_once("$g4[path]/head.sub.php");
$table_member = "synd_c_member"; //디비장소
$g4_path = "../../..";
include_once("$g4_path/common.php");
$g4['title'] = "";
include_once("$g4[path]/head.sub.php");
$table_member = "synd_c_member"; //디비장소
if ($member[mb_level] >= $board[bo_write_level]) {
if (!$sst) {
$sst = "no";
$sod = "desc";
} //정렬
$sst = "no";
$sod = "desc";
} //정렬
$sql_common = " from $table_member ";
$sql_search = " where (1) ";
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "number" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_1" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_2" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_3" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_4" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_5" :
$sql_search .= " ($sfl = '$stx') ";
break;
default :
$sql_search .= " ($sfl like '$stx%') ";
break;
}
$sql_search .= " ) ";
}
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "number" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_1" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_2" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_3" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_4" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "wr_5" :
$sql_search .= " ($sfl = '$stx') ";
break;
default :
$sql_search .= " ($sfl like '$stx%') ";
break;
}
$sql_search .= " ) ";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 15; //페이지
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
$colspan = 5; // 칸수
?>
<table width=98% align="center">
<form name=fsearch method=get>
<input type=hidden name=bo_table value='<?=$bo_table?>'>
<tr>
<td width=50% align=left> (총 회사 : <?=number_format($total_count)?></font>)</td>
<td width=50% align=right>
<select name=sfl class=cssfl>
<option value='number'>사업자번호</option>
<option value='wr_1'>상호명</option>
<option value='wr_2'>성명</option>
<option value='wr_3'>주소</option>
<option value='wr_4'>업태</option>
<option value='wr_5'>종목</option>
</select>
<input type=text name=stx required itemname='검색어' value='<? echo $stx ?>'>
<input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
</table>
<form name=fsearch method=get>
<input type=hidden name=bo_table value='<?=$bo_table?>'>
<tr>
<td width=50% align=left> (총 회사 : <?=number_format($total_count)?></font>)</td>
<td width=50% align=right>
<select name=sfl class=cssfl>
<option value='number'>사업자번호</option>
<option value='wr_1'>상호명</option>
<option value='wr_2'>성명</option>
<option value='wr_3'>주소</option>
<option value='wr_4'>업태</option>
<option value='wr_5'>종목</option>
</select>
<input type=text name=stx required itemname='검색어' value='<? echo $stx ?>'>
<input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
</table>
<table width=98% cellpadding=1 border="1" cellspacing=1 align="center">
<form name=fmemberlist method=post>
<input type=hidden name=frm_name value='<?=$frm_name?>'>
<input type=hidden name=bo_table value='<?=$bo_table?>'>
<input type=hidden name=sst value='<?=$sst?>'>
<input type=hidden name=sod value='<?=$sod?>'>
<input type=hidden name=sfl value='<?=$sfl?>'>
<input type=hidden name=stx value='<?=$stx?>'>
<input type=hidden name=page value='<?=$page?>'>
<colgroup width='30'>
<colgroup width='100'>
<colgroup width=50>
<colgroup width=50>
<colgroup width=50>
<colgroup width=''>
<tr><td colspan='<?=$colspan?>' class='line1'></td></tr>
<tr class='bgcol1 bold col1 ht center' align="center">
<td>번호</td>
<td><?=subject_sort_link('number')?>등록번호</a></td>
<td><?=subject_sort_link('wr_1')?>상호명</a></td>
<td><?=subject_sort_link('wr_2')?>성명</a></td>
<td><a href="<?=$board_skin_path?>/impom_write.php?table_member=<?=$table_member?>&frm_name=<?=$frm_name?>&bo_table=<?=$bo_table?>&page=<?=$page?>&sst=<?=$sst?>&sod=<?=$sod?>&sfle=<?=$sfl?>&stx=<?=$stx?>"><img src='<?=$g4[admin_path]?>/img/icon_insert.gif' border=0 title='추가'></a></td>
</tr>
<tr><td colspan='<?=$colspan?>' class='line2'></td></tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
$list = $i%2;
<form name=fmemberlist method=post>
<input type=hidden name=frm_name value='<?=$frm_name?>'>
<input type=hidden name=bo_table value='<?=$bo_table?>'>
<input type=hidden name=sst value='<?=$sst?>'>
<input type=hidden name=sod value='<?=$sod?>'>
<input type=hidden name=sfl value='<?=$sfl?>'>
<input type=hidden name=stx value='<?=$stx?>'>
<input type=hidden name=page value='<?=$page?>'>
<colgroup width='30'>
<colgroup width='100'>
<colgroup width=50>
<colgroup width=50>
<colgroup width=50>
<colgroup width=''>
<tr><td colspan='<?=$colspan?>' class='line1'></td></tr>
<tr class='bgcol1 bold col1 ht center' align="center">
<td>번호</td>
<td><?=subject_sort_link('number')?>등록번호</a></td>
<td><?=subject_sort_link('wr_1')?>상호명</a></td>
<td><?=subject_sort_link('wr_2')?>성명</a></td>
<td><a href="<?=$board_skin_path?>/impom_write.php?table_member=<?=$table_member?>&frm_name=<?=$frm_name?>&bo_table=<?=$bo_table?>&page=<?=$page?>&sst=<?=$sst?>&sod=<?=$sod?>&sfle=<?=$sfl?>&stx=<?=$stx?>"><img src='<?=$g4[admin_path]?>/img/icon_insert.gif' border=0 title='추가'></a></td>
</tr>
<tr><td colspan='<?=$colspan?>' class='line2'></td></tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
$list = $i%2;
echo "<input type=hidden name=no[$i] value='$row[no]'>
<tr class='list$list col1 ht center' align='center'>
<td>$row[no]</td>
<td><nobr style='display:block; overflow:hidden;'>$row[number]</nobr></td>
<td><nobr style='display:block; overflow:hidden;'>$row[wr_1]</nobr></td>
<td><nobr style='display:block; overflow:hidden;'>$row[wr_2]</nobr></td>
<td><a href='javascript:;' onclick=\"find_imp('$row[number]','$row[wr_1]','$row[wr_2]','$row[wr_3]','$row[wr_4]','$row[wr_5]')\";>선택</a>
<a href=\"$board_skin_path/impom_write.php?table_member=$table_member&frm_name=$frm_name&bo_table=$bo_table&page=$page&sst=$sst&sod=$sod&sfle=$sfl&stx=$stx&w=u&no=$row[no]\">수정</a>
<a href=\"$board_skin_path/impom_del.php?table_member=$table_member&frm_name=$frm_name&bo_table=$bo_table&page=$page&sst=$sst&sod=$sod&sfle=$sfl&stx=$stx&w=d&no=$row[no]\">삭제</a></td></tr>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>자료가 없습니다.</td></tr>";
echo "<tr><td colspan='$colspan' class='line2'></td></tr>";
echo "</table>";
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
<tr class='list$list col1 ht center' align='center'>
<td>$row[no]</td>
<td><nobr style='display:block; overflow:hidden;'>$row[number]</nobr></td>
<td><nobr style='display:block; overflow:hidden;'>$row[wr_1]</nobr></td>
<td><nobr style='display:block; overflow:hidden;'>$row[wr_2]</nobr></td>
<td><a href='javascript:;' onclick=\"find_imp('$row[number]','$row[wr_1]','$row[wr_2]','$row[wr_3]','$row[wr_4]','$row[wr_5]')\";>선택</a>
<a href=\"$board_skin_path/impom_write.php?table_member=$table_member&frm_name=$frm_name&bo_table=$bo_table&page=$page&sst=$sst&sod=$sod&sfle=$sfl&stx=$stx&w=u&no=$row[no]\">수정</a>
<a href=\"$board_skin_path/impom_del.php?table_member=$table_member&frm_name=$frm_name&bo_table=$bo_table&page=$page&sst=$sst&sod=$sod&sfle=$sfl&stx=$stx&w=d&no=$row[no]\">삭제</a></td></tr>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>자료가 없습니다.</td></tr>";
echo "<tr><td colspan='$colspan' class='line2'></td></tr>";
echo "</table>";
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
if ($stx)
echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>
echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>
<script language='Javascript'>
function find_imp(number,wr_1, wr_2, wr_3, wr_4, wr_5)
{
var of = opener.document.fwrite;
of.wr_subject.value = number;
of.wr_content.value = wr_1;
of.wr_1.value = wr_2;
of['wr2['+0+']'].value = wr_3;
of['wr2['+1+']'].value = wr_4;
of['wr2['+2+']'].value = wr_5;
function find_imp(number,wr_1, wr_2, wr_3, wr_4, wr_5)
{
var of = opener.document.fwrite;
of.wr_subject.value = number;
of.wr_content.value = wr_1;
of.wr_1.value = wr_2;
of['wr2['+0+']'].value = wr_3;
of['wr2['+1+']'].value = wr_4;
of['wr2['+2+']'].value = wr_5;
window.close();
return false;
}
</script>
<? }
include_once("$g4[path]/tail.sub.php");
?>
?>
synd_c_member
-- MySQL dump 9.11
--
-- Host: localhost Database: g4
-- ------------------------------------------------------
-- Server version 4.0.26-nt
--
-- Host: localhost Database: g4
-- ------------------------------------------------------
-- Server version 4.0.26-nt
--
-- Table structure for table `synd_c_member`
--
-- Table structure for table `synd_c_member`
--
CREATE TABLE synd_c_member (
no int(11) NOT NULL auto_increment,
number varchar(255) NOT NULL default '',
wr_1 varchar(255) default NULL,
wr_2 varchar(255) default NULL,
wr_3 varchar(255) default NULL,
wr_4 varchar(255) default NULL,
wr_5 varchar(255) default NULL,
wr_ip varchar(255) NOT NULL default '',
wr_6 varchar(255) NOT NULL default '',
wr_7 varchar(255) NOT NULL default '',
wr_8 varchar(255) NOT NULL default '',
wr_9 varchar(255) NOT NULL default '',
wr_date date NOT NULL default '0000-00-00',
PRIMARY KEY (no)
) TYPE=MyISAM;
no int(11) NOT NULL auto_increment,
number varchar(255) NOT NULL default '',
wr_1 varchar(255) default NULL,
wr_2 varchar(255) default NULL,
wr_3 varchar(255) default NULL,
wr_4 varchar(255) default NULL,
wr_5 varchar(255) default NULL,
wr_ip varchar(255) NOT NULL default '',
wr_6 varchar(255) NOT NULL default '',
wr_7 varchar(255) NOT NULL default '',
wr_8 varchar(255) NOT NULL default '',
wr_9 varchar(255) NOT NULL default '',
wr_date date NOT NULL default '0000-00-00',
PRIMARY KEY (no)
) TYPE=MyISAM;
--
-- Dumping data for table `synd_c_member`
--
-- Dumping data for table `synd_c_member`
--
댓글 전체
아무리 생각해봐도 위 sql문으로 DB에 테이블을 생성안하신거 같은데요...???
감사합니다~^^
DB에 추가하는게 따로 있었군요.....
덕분에 성공했습니다...
정말 감사합니다~^^
DB에 추가하는게 따로 있었군요.....
덕분에 성공했습니다...
정말 감사합니다~^^
저도 같은문제인데... 시그너스님 설명으론 어떻게 해야 할지 모르겠습니다. 구체적으로 설명을 해주시면 좋겠습니다.
