|
주문양식에 관한 코드입니다.....
추가 내용이란 칸에 10 줄 이상의 글을 쓰면 무조건 3줄 만 나타나고 그 양식의 전체적인 표 양식이 늘어났닙다....
도데체 어디에 문제가 있는지 알수가 없습니다...
방법을 알려 주십시요....
prodt00.php
<?
session_register("suserid");
session_register("arrange");
session_register("arrow");
session_register("sortcode");
if ($sortcode1)$sortcode=$sortcode1;
$sortcodea=explode("-",$sortcode);
include "dbcon.php";
$resusr=mysql_query("select * from $usert where id1='$suserid'");
if ($resusr){
$rsusr=mysql_fetch_array($resusr);
$level=$rsusr[level];
$writer=$suserid;
$email=$rsusr[email];
$shopgroup=$rsusr[shopgroup];
}
if ($arrange1!="")$arrange=$arrange1;
if ($arrow1!="")$arrow=$arrow1;
if ($arrange=="")$arrange="rowid";
if ($arrow=="")$arrow="desc";
?>
<?if ($level>9){?>
<script>
window.alert("권한이 없습니다.");
history.go(-1);
</script>
<?die;}?>
<?
/*
유닉스 타임을 대입하면 2000-08-10 10:20:30 와 같은 방식으로 값을 리턴하는 사용자정의 함수 ymdhis()를 정의한다.
*/
function ymdhis($t){
return date("Y-m-d H:i:s",$t);
}
/*
mkunixtime()은 2000-08-10 10:20:30 와 같은 방식으로 되어 있는 일자 값을 분석하여 유닉스 타임으로 시각값을 리턴하는 사용자정의 함수이다.
*/
function mkunixtime($ymdhis,$ha,$ia,$sa,$ma,$da,$ya){
$ymdhisa=explode(" ",$ymdhis);
$ymda=explode("-",$ymdhisa[0]);
$hisa=explode(":",$ymdhisa[1]);
$y=$ymda[0];
$m=$ymda[1];
$d=$ymda[2];
$h=$hisa[0];
$i=$hisa[1];
$s=$hisa[2];
return mktime($h+$ha,$i+$ia,$s+$sa,$m+$ma,$d+$da,$y+$ya);
}
?>
<link rel="stylesheet" href="../css/owlshop3.css">
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function SearchZip(){
winzip= window.open("zip.php","zip","scrollbars=no,resizable=no,width=500,height=150");
winzip.focus();
}
//-->
function ValidateForm(theForm)
{
if (theForm.prodname.value=="") {
alert("주문자 이름을 입력해 주세요!");
theForm.prodname.focus();
return false;
}
if (theForm.myprice.value=="") {
alert("연락처를 입력하세요.");
theForm.myprice.focus();
return false;
}
if (theForm.bname.value=="") {
alert("입금하실 분의 이름을 입력하세요.");
theForm.bname.focus();
return false;
}
if (theForm.price.value=="") {
alert("입금액을 입력하세요.");
theForm.price.focus();
return false;
}
if( (theForm.stprice.value == "") ||
((theForm.stprice.value.indexOf("@") == -1) || (theForm.stprice.value.indexOf(".") == -1)) )
{
alert("Email를 제대로 작성하세요.");
theForm.stprice.focus();
return false;
}
if (theForm.ZIP1.value == "" || theForm.ZIP1.value.length != 3 || !isnum(theForm.ZIP1.value)) {
alert("우편번호를 정확하게 입력하세요.");
theForm.ZIP1.focus();
return false;
}
if (theForm.ZIP2.value == "" || theForm.ZIP2.value.length != 3 || !isnum(theForm.ZIP2.value)) {
alert("우편번호를 정확하게 입력하세요.");
theForm.ZIP2.focus();
return false;
}
if (theForm.ADDR.value == "" || theForm.ADDR.value.length < 10 ) {
alert("주소를 정확하게 입력하세요.");
theForm.ADDR.focus();
return false;
}
checkInput(theForm);
}
</script>
<body background="" topmargin="0">
<?
$ipp = 15;
$ten = 20;
if ($keyfield ==""){
$keyfield = "sortcode";}
if ($page == ""){
$curpage = 1;
} else {
$curpage = $page;}
$startrow = ($curpage - 1) * $ipp
?> <?if ($startpage == ""){
$startpage = 1;}else{$startpage = (int)$startpage;}
if ($startpage <= 0) {$startpage = 1;}
if ($curpage <= 0) {$curpage = 1;}
$start_ten = $startpage - $ten;
if ($startpage <= 0){$startpage = 1;}
//기본 링크 변수
$prodt_parm = $PATH_INFO."?type=prodt&dbname=dmprint&tbname=prodt&keyfield=".$keyfield."&key=".$key;
$prodt_parm2 = $PATH_INFO."?type=prodt&dbname=dmprint&tbname=prodt";
//일반 링크 변수
$prodt_parm1 = $prodt_parm."&page=".$curpage."&startpage=".$startpage;
//제목
if ($tbname == "prodt"){$title = "제품";}
?>
<table width="655" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr align="center">
<td>
<?if ($tbname == "prodt"){?>
<div align="center">
<table width="308" height="25" border="0" align="center" cellpadding="0" cellspacing="0" background="../newimg/sadmin6.gif">
<tr align="center" valign="middle">
<td class="textitleen">
<?
/*
분류코드가 없을 경우 기본값으로 초기화시킨다.
*/
if ($sortcode==""){
$res=mysql_query("select * from $sortt where sortlevel='0' limit 1");
if ($res){
$rs=mysql_fetch_array($res);
$sortcode=$rs[sortcode];
}else{
echo "관리실의 분류테이블에서 쇼핑몰센터를 만드십시오.";
}
}
//분류코드로 분류 레벨을 계산한다.
$sortlevel=count(explode("-",$sortcode))-1;
//해당 분류 코드에 대한 정보를 가져온다.
$res=mysql_query("select * from sortt where sortcode='$sortcode' ");
if ($res){
$rs=mysql_fetch_array($res);
}
$sortname=$rs[sortname];
?>
<?
//분류 이름을 /로 분할하여 계층별 디렉토리 이름을 배열로 구한다.
$sorta=explode("/",$rs[sortname]);
?>
<?echo $sorta[0];?> <?echo $title;?> 주문 정보</td>
</tr>
</table>
<?if ($mode == "list" || $mode == ""){?>
<? $result = mysql_query("select * from ".$tbname." limit 1 ",$sock);
if ($result){
$fieldnum = mysql_num_fields($result);
}
$k = 0;
while ($k < $fieldnum){
$fname[$k] = mysql_field_name($result,$k);
$ftype[$k] = mysql_field_type($result,$k);
$flen[$k] = mysql_field_len($result,$k);
$form_fname = "$form_".$fname[$k];
if ($keyfield == $fname[$k]){
$key_k = $k;
}
$k++;
}
?>
<?if ($ftype[$key_k] == "int"){
$key = intval($key);
$query1 = "select count(*) from $tbname where $keyfield = $key ";
}else{
$query1 = "select count(*) from $tbname where $keyfield like '%$key%' ";
}
if ($level<9){
$query1 .= " and sortcode like '$shopgroup%'";
}
?>
<?
$result = mysql_query($query1,$sock);
if ($result){
$row1 = mysql_fetch_row($result);
$totrec1 = $row1[0];
}
?>
<?
$totpage = $totrec1 /$ipp;
$totpage = (int)$totpage;
if (($totpage * $ipp)!=$totrec1)
{
$totpage = $totpage + 1;
}
$unixdate=time();
$nowdate=date("Y-m-d H:i:s",$unixdate);
echo"<!-- [[[[[[[[[[ $prodt_parm ]]]]]]]]]] -->";
?>
<form action="<?echo $prodt_parm;?>&mode=list" method="post" name="search">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="text">
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td class="text"> </td>
<td class="text" align="right">
<select name="keyfield">
<option value="prodname">이름</option>
<option value="prodcode" >접수번호</option>
<option value="stprice">메일</option>
</select>
<input type="text" size="20" maxlength="30" name="key">
<input type="submit" value="Search" name="submit">
</td>
</tr>
</table>
<?
if ($ftype[$key_k] == "int") {
$query2 = "select * from $tbname where $keyfield = $key ";
} else {
$query2 = "select * from $tbname where $keyfield like '%$key%' ";
}
if ($level<9){
$query2 .= " and sortcode like '$shopgroup%'";
}
?> <?
if ($arrange=="" || $arrow=="") {
$query2=$query2." order by rowid desc limit ".$startrow.",".$ipp." ";
}else{
$query2=$query2." order by $arrange $arrow limit ".$startrow.",".$ipp." ";
}
?> <?
$res2 = mysql_query($query2,$sock);
?>
<table width="655" border="0" cellpadding="0" cellspacing="1" bgcolor="#0000FF">
<tr bgcolor="#6666FF" class="retextwite">
<td align="center" > <font size="2">
<?if ($arrange=="rowid" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=rowid&arrow1=asc" class="retextwite">번
호↑</a>
<?}else if ($arrange=="rowid" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=rowid&arrow1=desc" class="retextwite">번
호↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=rowid&arrow1=desc" class="retextwite">번
호↕ </a>
<?}?>
</font></td>
<td align="center" > <font size="2">
<?if ($arrange=="prodname" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodname&arrow1=asc" class="retextwite">이름↑</a>
<?}else if ($arrange=="prodcode" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodname&arrow1=desc" class="retextwite">이름↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodname&arrow1=desc" class="retextwite">이름↕
</a>
<?}?>
</font></td>
<td align="center" > <font size="2">
<?if ($arrange=="prodcode" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodcode&arrow1=asc" class="retextwite">접수번호↑</a>
<?}else if ($arrange=="prodname" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodcode&arrow1=desc" class="retextwite">접수번호↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=prodcode&arrow1=desc" class="retextwite">접수번호↕
</a>
<?}?>
</font></td>
<td align="center" bgcolor="#6666FF" > <font size="2">
<?if ($arrange1=="check" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=check&arrow1=asc" class="retextwite">주문확인↑</a>
<?}else if ($arrange=="sortcode" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=check&arrow1=desc" class="retextwite">주문확인↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=check&arrow1=desc" class="retextwite">주문확인↕
</a>
<?}?>
</font></td>
<td align="center" > <font size="2">
<?if ($arrange=="stprice" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=myprice&arrow1=asc" class="retextwite">조회↑</a>
<?}else if ($arrange=="stprice" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=myprice&arrow1=desc" class="retextwite">조회↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=myprice&arrow1=desc" class="retextwite">조회↕
</a>
<?}?>
</font></td>
<td align="center" > <font size="2">
<?if ($arrange=="proddate" && $arrow=="desc") {?>
<a href="<?echo $prodt_parm1;?>&arrange1=proddate&arrow1=asc" class="retextwite">주문일자↑</a>
<?}else if ($arrange=="proddate" && $arrow=="asc"){?>
<a href="<?echo $prodt_parm1;?>&arrange1=proddate&arrow1=desc" class="retextwite">주문일자↓</a>
<?}else{?>
<a href="<?echo $prodt_parm1;?>&arrange1=proddate&arrow1=desc" class="retextwite">주문일자↕
</a>
<?}?>
</font></td>
</tr>
<?if ($res2) {?>
<?
$i=0;
while ($row2 = mysql_fetch_array($res2)) {
?>
<?if (($i % 2)==0){?>
<tr bgcolor="#FFFFFF">
<td class="text" align="right" > <font size="2">
<?echo $row2[rowid];?>
<a href="<?echo ${$tbname."_parm1"};?>&rowid=<?echo $row2[rowid];?>&mode=editform"><img src="../img/sedit.gif" width="11" height="11" alt="Edit" border="0"></a><a href="<?echo ${$tbname."_parm1"};?>&rowid=<?echo $row2[rowid];?>&mode=delform"><img src="../img/sdel.gif" width="11" height="11" hspace="3" alt="Delete" border="0"></a>
</font></td>
<td align="center" > <font size="2">
<?echo $row2[prodname];?>
</font></td>
<td bgcolor="#FFFFFF"> <font size="2">
<?echo $row2[prodcode];?>
</font></td>
<td><font size="2">
<?echo $row2[check];?>
</font></td>
<td align="right"> <font size="2">
<?echo number_format($row2[stprice]);?>
</font></td>
<td align="center">
<div align="right"><font size="2">
<?echo $row2[proddate];?>
</font></div>
</td>
</tr>
<?} else {?>
<tr bgcolor="#ECECFF">
<td class="text" align="right" > <font size="2">
<?echo $row2[rowid];?>
<a href="<?echo ${$tbname."_parm1"};?>&rowid=<?echo $row2[rowid];?>&mode=editform"><img src="../img/sedit.gif" width="11" height="11" alt="Edit" border="0"></a><a href="<?echo ${$tbname."_parm1"};?>&rowid=<?echo $row2[rowid];?>&mode=delform"><img src="../img/sdel.gif" width="11" height="11" hspace="3" alt="Delete" border="0"></a>
</font></td>
<td bgcolor="#ECECFF" align="center" > <font size="2">
<?echo $row2[prodname];?>
</font></td>
<td > <font size="2">
<?echo $row2[prodcode];?>
</font></td>
<td bgcolor="#ECECFF" >
<font size="2">
<?echo $row2[check];?>
</font></td>
<td align="right" > <font size="2">
<?echo number_format($row2[stprice]);?>
</font></td>
<td align="center" >
<div align="right"><font size="2">
<?echo $row2[proddate];?>
</font></div>
</td>
</tr>
<?}?>
<?$i++;}//while.....?>
<?}//$res?>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><?
if (($totpage%$ten)==0){
$startpage_last=$totpage-$ten+1;
}else{
$startpage_last=$totpage-($totpage%$ten)+1;
}
?><?
if ($ten < $totpage) {
if ($startpage == 1) {
?>◀☞☜▶ <?} else {?><a href="<?echo ${$tbname."_parm"};?>&mode=list&page=1&startpage=1">◀</a><a href="<?echo ${$tbname."_parm"};?>&mode=list&page=<?echo $startpage_ten;?>&startpage=<?echo $startpage_ten;?>">☞</a>
<?}?> <? $a = $startpage;
while ($a <= $startpage + $ten - 1) {
if ($a > $totpage) {
break;
}?> <? if ($a == $curpage) { ?> <?echo $a;?> <?}else {?> <a href="<?echo ${$tbname."_parm"};?>&mode=list&page=<?echo $a;?>&startpage=<?echo $startpage;?>"><?echo $a;?></a>
<?}
$a = $a + 1; } ?> <?
$a_ten = $startpage + $ten;
if ( $a_ten <= $totpage) {
?> <a href="<?echo ${$tbname."_parm"};?>&mode=list&page=<?echo $a;?>&startpage=<?echo $a;?>">☜</a><a href="<?echo ${$tbname."_parm"};?>&mode=list&page=<?echo $startpage_last;?>&startpage=<?echo $startpage_last;?>">▶</a>
<?}else {?> ☜▶ <?}?> <?}
$a=$startpage;
if ($ten >= $totpage) {
?> ◀☞ <?while ($a <= $totpage) {
if ($a == $curpage) {
?> <?echo $a;?> <?}else { ?> <a href="<?echo ${$tbname."_parm"};?>&mode=list&page=<?echo $a;?>&startpage=<?echo $startpage;?>"><?echo $a;?></a>
<?}
$a = $a + 1; } ?> ☜▶ <?}?> </td>
<td align="right">[<?echo $totrec1;?> records / <?echo $totpage;?>
pages]<br>
현재시각 : <?echo $nowdate;?> </td>
</tr>
</table>
</td>
</tr>
</table>
</form></div>
<div align="center">
<?}//if mode list?>
<?if ($mode == "editform"){?>
<?
$query2 = "select * from $tbname where rowid = '$rowid'";
$res2 = mysql_query($query2, $sock);
$row2 = mysql_fetch_array($res2);
?>
</div>
<form method="post" action="<?echo ${$tbname."_parm"};?>" name="upform" >
<div align="center"><b> </b>
<input type="hidden" name="mode" value="edit">
<input type="hidden" name="rowid" value="<?echo $rowid;?>">
<input type="hidden" name="sortcode" value="01">
<table width="655" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="649"><table width="640" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#CCCCCC">
<td width="108" height="31" bgcolor="#FFD460"> <div align="center">접 수 번 호</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[prodcode]; ?>
</td>
</tr>
<tr>
<td height="29" bgcolor="#FFD460"> <div align="center">이 름</div></td>
<td width="216" bgcolor="#FBFAE1"> <? echo $row2[prodname]; ?>
</td>
<td width="91" bgcolor="#FFD460"> <div align="center">상 호</div></td>
<td width="220" bgcolor="#FBFAE1"> <? echo $row2[cname]; ?></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="27" bgcolor="#FFD460"> <div align="center">메 일</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[stprice]; ?></td>
<td bgcolor="#FFD460"> <div align="center">입 금 은 행</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[bank]; ?></td>
</tr>
<tr>
<td height="31" bgcolor="#FFD460"> <div align="center">연 락 처</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[myprice]; ?></td>
<td bgcolor="#FFD460"> <div align="center">입 금 자 명</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[bname]; ?></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="57" bgcolor="#FFD460"> <div align="center">요 청 자 료</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[pds]; ?> <br>
<? echo $row2[pds1]; ?> <br> <? echo $row2[pds2]; ?></td>
<td bgcolor="#FFD460"> <div align="center">입 금 액</div></td>
<td bgcolor="#FBFAE1"> <? echo $row2[price]; ?> <br>
<? echo $row2[pds3]; ?><br> <? echo $row2[pds4]; ?></td>
</tr>
<tr>
<td height="76" rowspan="2" bgcolor="#FFD460"> <div align="center">받으실주소</div></td>
<td rowspan="2" bgcolor="#FBFAE1"> <? echo $row2[ZIP1]; ?>
- <? echo $row2[ZIP2]; ?> <br> <? echo $row2[ADDR]; ?>
<? echo $row2[ADDR_ADD]; ?></td>
<td height="37" bgcolor="#FFD460"><div align="center">주 문 확 인</div></td>
<td bgcolor="#FBFAE1"> <input type="TEXT" name="check" value="<? echo $row2[check];?>">
<p>
<center>
<select name="check" size="4">
<option type="TEXT" name="check" value="주문접수(입금확인중)">주문접수(입금확인중)</option>
<option name="check" value="인쇄 제작중">인쇄 제작중</option>
<option name="check" value="제작완료">제작완료</option>
<option name="check" value="발송했습니다">발송했습니다</option>
</select>
</center>
</p></td>
</tr>
<tr>
<td height="38" bgcolor="#FFD460"><div align="center">시 안 확 인</div></td>
<td bgcolor="#FBFAE1"> <input type="TEXT" name="prodpic3" >
<br>
<input type="button" name="Submit32" value="파일선택" onClick="MM_openBrWindow('http://www.dmprint.net/owlshop3/config/imgup04.php?subdir1=prodimg&page=&startpage=&submode=&mode=addform')"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="75" bgcolor="#FFD460"> <div align="center">명 함</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[remain]; ?>
<br> <br> <div align="center"> 샘플번호
: <? echo $row2[remain1]; ?> <br>
수 량
: 총 <? echo $row2[remain3]; ?> 건 / 각
<? echo $row2[remain4]; ?> 매 </div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460"> <div align="center">스 티 커</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[remain_virtual]; ?>
<br> <br> 샘플번호 : <? echo $row2[remain_virtual1]; ?>
<div align="center"><br>
기타규격 : <? echo $row2[remain_virtual3]; ?>
수
량 : 총 <? echo $row2[remain_virtual4]; ?> 매
</div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460"> <div align="center">칼 라 전 단</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[suggest]; ?><br>
<br> 샘플번호 : <? echo $row2[suggest1]; ?>
<div align="center"><br>
수 량
: 총 <? echo $row2[suggest3]; ?> 매</div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460"> <div align="center">소 봉 투</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[auction]; ?><br>
<br> 샘플번호 : <? echo $row2[auction1]; ?>   인 쇄 도 수
: <? echo $row2[auction2]; ?> <br> <br> <div align="center"> 수
량 : 총 <? echo $row2[auction3]; ?> 매</div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="75" bgcolor="#FFD460"> <div align="center">대 봉 투</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[lbox]; ?>
<br> <br> 샘플번호 : <? echo $row2[lbox1]; ?>
인 쇄 도 수
: <? echo $row2[lbox2]; ?> <br> <br> <div align="center"> 수
량
: 총 <? echo $row2[lbox3]; ?> 매</div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460">
<div align="center">(기타) <br>
서 식 / 양 식</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[form]; ?><br>
<br> 종 류
: <? echo $row2[form1]; ?>
인 쇄 도 수 : <? echo $row2[form2]; ?>
기타서식/양식 :
<? echo $row2[form3]; ?> <br> <br> 수
량 : 총 <? echo $row2[form4]; ?> 권(매)<br> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="36" bgcolor="#FFD460"> <div align="center">주 문 일 자</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[proddate]; ?></td>
</tr>
<tr>
<td height="34" bgcolor="#FFD460"> <div align="center">납기희망일자</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <? echo $row2[fproddate11]; ?><? echo $row2[remain2]; ?></td>
</tr>
<tr>
<td height="150" bgcolor="#FFD460"> <div align="center">추 가 내 용</div></td>
<td height="150" colspan="3" bgcolor="#FBFAE1"> <? echo $row2[remain_virtual2]; ?></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="66%"> <input type="submit" name="edit" value="제품등록정보수정">
<input type="button" name="Submit5" value="주문서목록" onClick="self.location='<?echo ${$tbname."_parm"};?>&mode=list'">
</td>
<td align="right" width="34%">
<?
$resprev = mysql_query("select * from $tbname where sortcode like '$shopgroup%' and rowid < $rowid order by rowid desc limit 1 ");
if ($resprev){
$rsprev = mysql_fetch_array($resprev);
if ($rsprev[rowid]){
?>
<a href="<?echo $PATH_INFO;?>?type=prodt&dbname=owlshop3&tbname=prodt&keyfield=<?echo $keyfield;?>&key=<?echo $key;?>&page=<?echo $curpage;?>&startpage=<?echo $startpage;?>&rowid=<?echo $rsprev[rowid];?>&mode=editform">◀이전</a>
<?}//if empty
}//if $res?>
|
<?
$resnext=0;
$resnext = mysql_query("select * from $tbname where sortcode like '$shopgroup%' and rowid > $rowid order by rowid asc limit 1");
if ($resnext){
$rsnext = mysql_fetch_array($resnext);
if ($rsnext[rowid]){
?>
<a href="<?echo $PATH_INFO;?>?type=prodt&dbname=owlshop3&tbname=prodt&keyfield=<?echo $keyfield;?>&key=<?echo $key;?>&page=<?echo $curpage;?>&startpage=<?echo $startpage;?>&rowid=<?echo $rsnext[rowid];?>&mode=editform">다음▶</a>
<?}//if
}//if?>
</td>
</tr>
</table></td>
</tr>
</table>
<br>
<br>
</div>
</form>
<div align="center">
<?}//mode?>
<?if ($mode == "edit"){?>
<?
$query2 = "update $tbname set check='".$check."',prodpic3='".$prodpic3."' where rowid = $rowid";
$res2 = mysql_query($query2, $sock);
?>
<script>
window.alert("수정완료");
self.location="<?echo "$prodt_parm1&rowid=$rowid&mode=editform"?>";
</script>
<?}//mode?>
<?if ($mode == "delform"){?>
<?
$query2 = "select * from $tbname where rowid = '$rowid'";
$res2 = mysql_query($query2, $sock);
$row2 = mysql_fetch_array($res2);
?>
</div>
<form method="post" action="<?echo ${$tbname."_parm"};?>&mode=del" name="del">
<div align="center"><b> 삭제</b><br>
다음 주문을 삭제합니다.
<input type="hidden" name="mode" value="del">
<input type="hidden" name="rowid" value="<?echo $rowid;?>">
<strong></strong>
<table>
<tr>
<td align="right"> 주문일자 : </td>
<td> <?echo $row2[proddate];?></td>
</tr>
<tr>
<td align="right"> 접수번호 : </td>
<td> <?echo $row2[prodcode];?> <input type="hidden" name="prodcode" value=<?echo $row2[prodcode];?>>
</td>
</tr>
<tr>
<td align="right"> <div align="center">이 름 : </div></td>
<td> <? echo $row2[prodname];?> <input type="hidden" name="prodname" value=<?echo $row2[prodname];?>>
</td>
</tr>
<tr>
<td align="right"> 분류코드 : </td>
<td><? echo $row2[sortcode];?></td>
</tr>
<tr>
<td align="right"> </td>
<td> <input type="submit" name="del" value="삭제"> <input type="button" name="Submit52" value="주문서목록" onClick="self.location='<?echo ${$tbname."_parm"};?>&mode=list'">
</td>
</tr>
</table>
</div>
</form>
<div align="center">
<?}//mode?>
<?if ($mode == "del"){?>
<?
$query2 = "delete from $tbname where rowid = $rowid";
mysql_query($query2);
?>
<script>
window.alert("삭제완료");
self.location="<?echo "$prodt_parm1&mode=list"?>";
</script>
<?}?>
<?if ($mode == "addform"){?>
</div>
<form method="post" action="<?echo ${$tbname."_parm"};?>" name="upform" onsubmit="return ValidateForm(this)">
<div align="center">
<input type="hidden" name="mode" value="add">
<table align="center" width="663" border="0" cellpadding="2" cellspacing="0" bgcolor="#6666FF">
<tr valign="top">
<td width="272" bgcolor="#FFFFFF">
<input type="hidden" name="sortcode" value="01"><center>
<table align="center" width="640" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#CCCCCC">
<td width="108" height="31" bgcolor="#FFD460">
<div align="center">접 수 번 호</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<input type="TEXT" name="prodcode" size="18""> (신청자 주민번호 뒷자리를 적어주시기 바랍니다.)
</td>
</tr>
<tr>
<td height="29" bgcolor="#FFD460">
<div align="center">이 름</div></td>
<td width="216" bgcolor="#FBFAE1">
<input type="TEXT" name="prodname" size="15">
</td>
<td width="91" bgcolor="#FFD460">
<div align="center">상 호</div></td>
<td width="220" bgcolor="#FBFAE1">
<input type="TEXT" name="cname" size="15"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="27" bgcolor="#FFD460">
<div align="center">메 일</div></td>
<td bgcolor="#FBFAE1">
<input type="TEXT" name="stprice" size="20"></td>
<td bgcolor="#FFD460">
<div align="center">입 금 은 행</div></td>
<td bgcolor="#FBFAE1">
<select name="bank">
<option value="대구은행(068-07-132358)">대구은행(068-07-132358)</option>
<option value="국민은행(813601-01-098890)">국민은행(813601-01-098890)</option>
</select></td>
</tr>
<tr>
<td height="31" bgcolor="#FFD460">
<div align="center">연 락 처</div></td>
<td bgcolor="#FBFAE1">
<input type="TEXT" name="myprice" size="15"></td>
<td bgcolor="#FFD460">
<div align="center">입 금 자 명</div></td>
<td bgcolor="#FBFAE1">
<input type="TEXT" name="bname" size="15"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="57" bgcolor="#FFD460">
<div align="center">요 청 자 료</div></td>
<td bgcolor="#FBFAE1"> <input type="checkbox" name="pds" value="세금계산서">
세금계산서<br> <input type="checkbox" name="pds1" value="영수증">
영수증 <br> <input name="pds2" type="checkbox" value="불필요">
불필요</td>
<td bgcolor="#FFD460">
<div align="center">입 금 액</div></td>
<td bgcolor="#FBFAE1">
<input type="TEXT" name="price" size="15"> <br>
<input type="checkbox" name="pds3" value="택배비포함">
택배비포함 <br> <input type="checkbox" name="pds4" value="택배비미포함">
택배비미포함</td>
</tr>
<tr>
<td height="76" bgcolor="#FFD460">
<div align="center">받으실주소</div></td>
<td colspan="3" bgcolor="#FBFAE1"> <input type="text" name="ZIP1" size="3" maxlength="3">
-
<input type="text" name="ZIP2" size="3" maxlength="3">
<input type="button" name="Submit22" onClick="SearchZip();" value="우편번호찾기" class="myForm">
<br> <input type="text" name="ADDR" size="38" maxlength="60">
<br>
<input type="text" name="ADDR_ADD" size="38" maxlength="60"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="75" bgcolor="#FFD460">
<div align="center">명 함</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="remain">
<option value="">종류를선택하세요</option>
<option value="코팅명함">코팅명함</option>
<option value="무코팅명함">무코팅명함</option>
<option value="탄트지">탄트지</option>
<option value="휘라레">휘라레</option>
<option value="즉석복권">즉석복권 </option>
<option value="쿠폰/할인권">쿠폰/할인권</option>
</select> 샘플번호
<input type="TEXT" name="remain1" size="15"> <div align="right"><br>
수량: 총
<input type="text" name="remain3" maxlength=100 size="5">
건 / 각
<input type="text" name="remain4" maxlength=100 size="5">
매 </div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460">
<div align="center">스 티 커</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="remain_virtual">
<option value="">종류를선택하세요</option>
<option value="코팅스티커">코팅스티커</option>
<option value="자유형칼라스티커">자유형칼라스티커</option>
<option value="자석스티커">자석스티커</option>
<option value="오프너">오프너 </option>
</select> 샘플번호:
<input type="TEXT" name="remain_virtual1" size="15"> <div align="center"><br>
원하시는 규격을 입력하세요!
<input type="text" name="remain_virtual3" size="15">
수 량 : 총
<input type="text" name="remain_virtual4" maxlength=100 size="5">
매 </div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460">
<div align="center">칼 라 전 단</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="suggest">
<option value="">종류를선택하세요</option>
<option value="32절">32절</option>
<option value="16절">16절</option>
<option value="A4">A4</option>
<option value="8절">8절</option>
<option value="A3">A3</option>
<option value="4">4절</option>
<option value="2">2절</option>
</select> 샘플번호:
<input type="TEXT" name="suggest1" size="15">
<div align="center"><br>
수
량 : 총
<input type="text" name="suggest3" maxlength=100 size="5">
매</div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460">
<div align="center">소 봉 투</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="auction">
<option value="">종류를선택하세요</option>
<option value="재생봉투(황색)">재생봉투(황색)</option>
<option value="100모조">100모조</option>
<option value="레쟈크지">레쟈크지</option>
<option value="쟈켓레쟈크">쟈켓레쟈크</option>
<option value="쟈켓백모조">쟈켓백모조</option>
<option value="쟈켓밍크">쟈켓밍크</option>
<option value="백모조창1">백모조창1</option>
<option value="백모조창2">백모조창2</option>
<option value="백모조경조사">백모조경조사</option>
<option value="쟈켓밍크지">쟈켓밍크지</option>
<option value="수강료납입봉투">수강료납입봉투</option>
</select> 샘플번호:
<input type="TEXT" name="auction1" size="15"> 인쇄도수
<select name="auction2">
<option value="">인쇄도수</option>
<option value="1도">1도</option>
<option value="2도">2도</option>
<option value="4도">4도</option>
</select> <br> <br> <div align="center"> 수
량 : 총
<input type="text" name="auction3" maxlength=100 size="5">
매</div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="75" bgcolor="#FFD460">
<div align="center">대 봉 투</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="lbox">
<option value="">종류를선택하세요</option>
<option>재생봉투(황색) </option>
<option>100모조</option>
<option>120모조</option>
<option>레쟈크</option>
</select> 샘플번호:
<input type="text" name="lbox1" size="15">
인쇄도수
<select name="lbox2">
<option value="">인쇄도수</option>
<option value="1도">1도</option>
<option value="2도">2도</option>
<option value="4도">4도</option>
</select> <br> <br> <div align="center"> 수
량 : 총
<input type="text" name="lbox3" maxlength=100 size="5">
매</div></td>
</tr>
<tr>
<td height="75" bgcolor="#FFD460">
<div align="center">(기 타)<br>서 식 / 양 식</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<select name="form1">
<option value="">종류</option>
<option value="작업일보">작업일보</option>
<option value="운행일지">운행일지</option>
<option value="장부">장부</option>
<option value="작업전표">작업전표 </option>
<option value="거래명세서">거래명세서 </option>
<option value="계산서">계산서 </option>
<option value="계산서">NCR지 </option>
<option value="기타">기타</option>
</select>
종류
<select name="form">
<option value="">종류를선택하세요</option>
<option value="16절">16절</option>
<option value="32절">32절</option>
<option value="16절3판걸이">16절3판걸이</option>
<option value="16절4판걸이">16절4판걸이 </option>
<option value="A4">A4 </option>
<option value="A4 2판걸이">A4 2판걸이 </option>
<option value="A4 3판걸이">A4 3판걸이 </option>
<option value="A4 4판걸이">A4 4판걸이 </option>
</select>
인쇄도수
<select name="form2">
<option value="1도">1도 </option>
<option value="2도">2도 </option>
</select>
<br>
<br>
<input type="text" name="form3" size="45">
수 량 : 총
<input type="text" name="form4" maxlength=100 size="5">
권(매)<br>
(기타 원하시는 양식이나 서식이 있으시면 입력해주세요!</td>
</tr>
<tr>
<td height="34" bgcolor="#FFD460">
<div align="center">납기희망일자</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<input type="TEXT" name="remain2" size="15"> 주문일자 <input type="TEXT" name="hidden" size="0"value="<?echo date("Y-m-d H:i:s");?>"></td>
</tr>
<!--
<tr bgcolor="#CCCCCC">
<td height="31" bgcolor="#FFD460">
<div align="center">첨 부 파 일1</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<input type="TEXT" name="prodpic">
<input type="button" name="Submit3" value="파일선택" onClick="MM_openBrWindow('http://www.dmprint.net/owlshop3/config/imgup01.php?subdir1=prodimg&page=&startpage=&submode=&mode=addform')"></td>
</tr>
<tr>
<td height="31" bgcolor="#FFD460">
<div align="center">첨 부 파 일2</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<input type="TEXT" name="prodpic1">
<input type="button" name="Submit33" value="파일선택" onClick="MM_openBrWindow('http://www.dmprint.net/owlshop3/config/imgup02.php?subdir1=prodimg&page=&startpage=&submode=&mode=addform')"></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="28" bgcolor="#FFD460">
<div align="center">첨 부 파 일3</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<input type="TEXT" name="prodpic2">
<input type="button" name="Submit34" value="파일선택" onClick="MM_openBrWindow('http://www.dmprint.net/owlshop3/config/imgup03.php?subdir1=prodimg&page=&startpage=&submode=&mode=addform')"></td>
</tr>
-->
<tr>
<td bgcolor="#FFD460">
<div align="center">추 가 내 용</div></td>
<td colspan="3" bgcolor="#FBFAE1">
<textarea name="remain_virtual2" cols="60" rows="10"></textarea></td>
</tr>
</table>
</td>
</tr>
</table>
<input type="submit" name="Submit4" value="주문하기"> <input type="reset" name="다시적기">
</div>
</form>
<div align="center">
<?}//mode?>
<?if ($mode == "add"){?>
<?
$query = "select * from prodt where prodcode = '$prodcode'";
$res = mysql_query($query, $sock);
$rs = mysql_fetch_array($res);
if ($rs[rowid] == ""){
$query2 = "insert into ".$tbname." (prodcode,prodname,sortcode,cname,stprice,myprice,bank,bname,price,ZIP1,ZIP2,ADDR,ADDR_ADD,remain,remain1,remain2,remain3,remain4,remain_virtual,remain_virtual1,remain_virtual2,remain_virtual3,remain_virtual4,suggest,suggest1,suggest2,suggest3,auction,auction1,auction2,auction3,lbox,lbox1,lbox2,lbox3,form,form1,form2,form3,form4,proddate,proddate11,prodpic,prodpic1,prodpic2,prodinfo3,pds,pds1,pds2,pds3,pds4) VALUES ('$prodcode','$prodname','$sortcode','$cname','$stprice','$myprice','$bank','$bname','$price','$ZIP1','$ZIP2','$ADDR','$ADDR_ADD','$remain','$remain1','$remain2','$remain3','$remain4','$remain_virtual','$remain_virtual1','$remain_virtual2','$remain_virtual3','$remain_virtual4','$suggest','$suggest1','$suggest2','$suggest3','$auction','$auction1','$auction2','$auction3','$lbox','$lbox1','$lbox2','$lbox3','$form','$form1','$form2','$form3','$form4','$proddate','$proddate11','$prodpic','$prodpic1','$prodpic2','$prodinfo3','$pds','$pds1','$pds2','$pds3','$pds4')";
$res2 = mysql_query($query2,$sock);
?>
<script>
window.alert("등록완료!! 주문,시안확인 왼쪽 메뉴를 이용해주십시요. ");
self.location="../../dmprint/body.htm"; <!-- self.location="../../body.htm"; -->
</script>
<?}else{?>
<script>
window.alert("등록 실패!! 이미 등록된 제품입니다.");
history.go(-1);
</script>
<?}//제품중복?>
<?}//mode?>
<?}//if $tbname=="prodt"?>
</div></td>
</tr>
</table>
|
