Files
sam-kd/work/copy_data.php
hskwon aca1767eb9 초기 커밋: 5130 레거시 시스템
- URL 하드코딩 → .env APP_URL 기반 동적 URL로 변경
- DB 연결 하드코딩 → .env 기반으로 변경
- MySQL strict mode DATE 오류 수정
2025-12-10 20:14:31 +09:00

808 lines
44 KiB
PHP

<meta charset="utf-8">
<?php
session_start();
if(isset($_REQUEST["mode"])) //수정 버튼을 클릭해서 호출했는지 체크
$mode=$_REQUEST["mode"];
else
$mode="";
if(isset($_REQUEST["num"])) //수정 버튼을 클릭해서 호출했는지 체크
$num=$_REQUEST["num"];
else
$num="";
if(isset($_REQUEST["page"])) //수정 버튼을 클릭해서 호출했는지 체크
$page=$_REQUEST["page"];
else
$page=1;
if(isset($_REQUEST["search"])) //수정 버튼을 클릭해서 호출했는지 체크
$search=$_REQUEST["search"];
else
$search="";
if(isset($_REQUEST["find"])) //수정 버튼을 클릭해서 호출했는지 체크
$find=$_REQUEST["find"];
else
$find="";
if(isset($_REQUEST["process"])) //수정 버튼을 클릭해서 호출했는지 체크
$process=$_REQUEST["process"];
else
$process="전체";
$yearcheckbox=$_REQUEST["yearcheckbox"]; // 년도 체크박스
$year=$_REQUEST["year"]; // 년도 체크박스
require_once("../lib/mydb.php");
$pdo = db_connect();
if ($mode=="modify"){
try{
$sql = "select * from chandj.work where num = ? ";
$stmh = $pdo->prepare($sql);
$stmh->bindValue(1,$num,PDO::PARAM_STR);
$stmh->execute();
$count = $stmh->rowCount();
if($count<1){
print "검색결과가 없습니다.<br>";
}else{
$row = $stmh->fetch(PDO::FETCH_ASSOC);
$item_subject = $row["subject"];
$item_content = $row["content"];
$item_file_0 = $row["file_name_0"];
$item_file_1 = $row["file_name_1"];
$item_file_2 = $row["file_name_2"];
$copied_file_0 = $row["file_copied_0"];
$copied_file_1 = $row["file_copied_1"];
$copied_file_2 = $row["file_copied_2"];
$content="";
$content="";
$condate="";
$condate1="";
$condate2="";
$estimate1="";
$estimate2="";
$estimate3="";
$estimate4="";
$bill1="";
$bill2="";
$bill3="";
$bill4="";
$bill5="";
$bill6="";
$billdate1="";
$billdate2="";
$billdate3="";
$billdate4="";
$billdate5="";
$billdate6="";
$deposit1="";
$deposit2="";
$deposit3="";
$deposit4="";
$deposit5="";
$deposit6="";
$claimamount1="";
$claimamount2="";
$claimamount3="";
$claimamount4="";
$claimamount5="";
$claimamount6="";
$claimamount7="";
$claimdate1="";
$claimdate2="";
$claimdate3="";
$claimdate4="";
$claimdate5="";
$claimdate6="";
$claimbalance1="";
$claimbalance2="";
$claimbalance3="";
$claimbalance4="";
$claimbalance5="";
$claimbalance6="";
$claimbalance7="";
$claimfix1="";
$claimfix2="";
$claimfix3="";
$claimfix4="";
$claimfix5="";
$claimfix6="";
$claimfix7="";
$claimperson="";
$claimtel="";
$depositdate1="";
$depositdate2="";
$depositdate3="";
$depositdate4="";
$depositdate5="";
$depositdate6="";
$receivable="";
$workplacename=$row["workplacename"];
$chargedperson=$row["chargedperson"];
$address=$row["address"];
$firstord=$row["firstord"];
$firstordman=$row["firstordman"];
$firstordmantel=$row["firstordmantel"];
$secondord=$row["secondord"];
$secondordman=$row["secondordman"];
$secondordmantel=$row["secondordmantel"];
$worklist=$row["worklist"];
$motormaker=$row["motormaker"];
$power=$row["power"];
$workday=$row["workday"];
$worker=$row["worker"];
$endworkday=$row["endworkday"];
$cableday=$row["cableday"];
$cablestaff=$row["cablestaff"];
$endcableday=$row["endcableday"];
$asday="";
$asorderman="";
$asordermantel="";
$aslist="";
$asresult="";
$ashistory="";
$comment="";
$totalbill="";
$accountnote="";
$asproday="";
$asendday="";
$asman="";
$subject="";
$work_state="";
$as_state="";
$sum_bill=0;
$sum_receivable=0;
$sum_deposit=0;
$sum_claimamount=0;
$sum_estimate=0;
$as_refer="";
$change_worklist="";
$checkbox="";
$checkstep="없음";
$asfee="";
$asfee_estimate="";
$promiseday="";
$as_check="";
$outputmemo="";
$aswriter="";
$setdate="";
if($workday!="0000-00-00") $workday = date("Y-m-d", strtotime( $workday) );
else $workday="";
if($cableday!="0000-00-00") $cableday = date("Y-m-d", strtotime( $cableday) );
else $cableday="";
if($endworkday!="0000-00-00") $endworkday = date("Y-m-d", strtotime($endworkday) );
else $endworkday="";
if($endcableday!="0000-00-00") $endcableday = date("Y-m-d", strtotime($endcableday) );
else $endcableday="";
$subject=$workplacename;
}
}catch (PDOException $Exception) {
print "오류: ".$Exception->getMessage();
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<title> 주일기업 통합정보시스템 </title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="../css/common.css">
<link rel="stylesheet" type="text/css" href="../css/work.css">
</head>
<body>
<div id="wrap">
<?php
if($mode=="modify"){
?>
<form name="board_form" method="post" action="insert.php?mode=not" enctype="multipart/form-data">
<?php } else {
?>
<form name="board_form" method="post" action="insert.php?mode=not" enctype="multipart/form-data">
<?php
}
?>
<div id="header">
<?php include "../lib/top_login2.php"; ?>
</div>
<div id="menu">
<?php include "../lib/top_menu2.php"; ?>
</div>
<div id="content">
<div id="work_col2">
<div id="work_title"><img src="../img/title_work.gif"></div>
<div id="estimate_title">
<img src="../img/estimate_title.png">
</div>
<div id="estimate_text1">
<div class="sero1"> 계 약 일 :</div>
<div class="sero2"><input type="text" name="condate" value="<?=$condate?>" size="14" placeholder="계약 or 견적일자" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)" /></div> <br> <br>
<div class="sero1"> 최초 견적 : </div>
<div class="sero2"><input type="text" name="estimate1" value="<?=$estimate1?>" size="8" placeholder="최초금액" onkeyup="inputNumberFormat(this)" /></div> <br><br>
<div class="sero4444"><input type="file" name="upfile[]" multiple ></div>
<?php if ($mode=="modify" && $item_file_0)
{
?>
<div class="delete_ok">
<br> <br>
<a href="<?=$copied_file_0?>" onclick="window.open(this.href,'파일보기',width=800,height=600); return false;" style="color:blue;"> <b> <?=$item_file_0?> </b> </a>
등록
<input type="checkbox" name="del_file[]" value="0"> 삭제 </div>
<?php } ?>
<br> <br> <br>
<div class="sero1"> 1차 변경일: </div>
<div class="sero2"><input type="text" name="condate1" value="<?=$condate1?>" size="14" placeholder="1차변경일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)" /></div><br> <br>
<div class="sero1"> 1차 변경금액: </div>
<div class="sero2"><input type="text" name="estimate2" value="<?=$estimate2?>" size="8" placeholder="1차변경금액" onkeyup="inputNumberFormat(this)" /></div><br> <br>
<div class="sero4444"><input type="file" name="upfile[]" multiple ></div>
<?php if ($mode=="modify" && $item_file_1)
{
?>
<div class="delete_ok">
<br> <br>
<a href="<?=$copied_file_1?>" onclick="window.open(this.href,'파일보기',width=800,height=600); return false;" style="color:blue;"> <b> <?=$item_file_1?> </b> </a>
등록
<input type="checkbox" name="del_file[]" value="1"> 삭제 </div>
<?php } ?>
<br> <br> <br>
<div class="sero1"> 2차 변경일: </div>
<div class="sero2"><input type="text" name="condate2" value="<?=$condate2?>" size="14" placeholder="2차변경일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)" /></div><br> <br>
<div class="sero1"> 2차 변경금액: </div>
<div class="sero2"><input type="text" name="estimate3" value="<?=$estimate3?>" size="8" placeholder="2차변경금액" onkeyup="inputNumberFormat(this)" /></div><br> <br>
<div class="sero4444"><input type="file" name="upfile[]" multiple ></div>
<?php if ($mode=="modify" && $item_file_2)
{
?>
<div class="delete_ok">
<br> <br>
<a href="<?=$copied_file_2?>" onclick="window.open(this.href,'파일보기',width=800,height=600); return false;" style="color:blue;"> <b> <?=$item_file_2?> </b> </a>
등록
<input type="checkbox" name="del_file[]" value="2"> 삭제 </div>
<?php } ?>
<br> <br> <br>
<br>
VAT자동계산창 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type='text' id='test' size="8" value="" onkeyup="inputNumberFormat(this)" placeholder="VAT계산" />
<br> <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input type='button' onclick='input_Text()' value='VAT포함'>
<br>
<br>
<img src="../img/bill_title.png"> <br> <br> <!-- 세금계산서 -->
<div class="sero8"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;계산서발행일&nbsp;&nbsp;발행금액 &nbsp;&nbsp; 입금일자&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;입금액 </div> <br>
<div class="sero13"> 1차 : </div>
<div class="sero2"><input type="text" name="billdate1" value="<?=$billdate1?>" style="font-size:10px" size="8" placeholder="1차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill1" value="<?=$bill1?>" size="8" style="font-size:10px" placeholder="1차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate1" value="<?=$depositdate1?>" style="font-size:10px" size="8" placeholder="1차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit1" value="<?=$deposit1?>" size="8" style="font-size:10px" placeholder="1차입금액" onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero13"> 2차 : </div>
<div class="sero2"><input type="text" name="billdate2" value="<?=$billdate2?>" size="8" style="font-size:10px" placeholder="2차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill2" value="<?=$bill2?>" size="8" style="font-size:10px" placeholder="2차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate2" value="<?=$depositdate2?>" size="8" style="font-size:10px" placeholder="2차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit2" value="<?=$deposit2?>" size="8" style="font-size:10px" placeholder="2차입금액" onkeyup="inputNumberFormat(this)"/></div> <br> <br>
<div class="sero13"> 3차 : </div>
<div class="sero2"><input type="text" name="billdate3" value="<?=$billdate3?>" size="8" style="font-size:10px" placeholder="3차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill3" value="<?=$bill3?>" size="8" style="font-size:10px" placeholder="3차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate3" value="<?=$depositdate3?>" size="8" style="font-size:10px" placeholder="3차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit3" value="<?=$deposit3?>" size="8" style="font-size:10px" placeholder="3차입금액" onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero13"> 4차 : </div>
<div class="sero2"><input type="text" name="billdate4" value="<?=$billdate4?>" size="8" style="font-size:10px" placeholder="4차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill4" value="<?=$bill4?>" size="8" style="font-size:10px" placeholder="4차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate4" value="<?=$depositdate4?>" size="8" style="font-size:10px" placeholder="4차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit4" value="<?=$deposit4?>" size="8" style="font-size:10px" placeholder="4차입금액" onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero13"> 5차 : </div>
<div class="sero2"><input type="text" name="billdate5" value="<?=$billdate5?>" size="8" style="font-size:10px" placeholder="5차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill5" value="<?=$bill5?>" size="8" style="font-size:10px" placeholder="5차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate5" value="<?=$depositdate5?>" size="8" style="font-size:10px" placeholder="5차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit5" value="<?=$deposit5?>" size="8" style="font-size:10px" placeholder="5차입금액" onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero13"> 6차 : </div>
<div class="sero2"><input type="text" name="billdate6" value="<?=$billdate6?>" size="8" style="font-size:10px" placeholder="6차발행일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="bill6" value="<?=$bill6?>" size="8" style="font-size:10px" placeholder="6차계산서" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero2"><input type="text" name="depositdate6" value="<?=$depositdate6?>" size="8" style="font-size:10px" placeholder="6차입금일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero2"><input type="text" name="deposit6" value="<?=$deposit6?>" size="8" style="font-size:10px" placeholder="6차입금액" onkeyup="inputNumberFormat(this)"/></div> <br><br>
------------------------------------------------ <br>
<b> <p style="color:#FF0000";>&nbsp;&nbsp;&nbsp;&nbsp; 발행 합계 및 미수금 합계는 자동계산됩니다.</p> </b>
<br>
<div class="sero11" style="color:blue"> <b> 입금약속일 : </b> </div>
<div class="sero111"><input type="text" name="promiseday" value="<?=$promiseday?>" size="14" placeholder="입금약속일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)" /></div> <br> <br>
<div class="sero222"> 경리부 메모 : </div> <br>
<div class="memo"> <textarea rows="25" cols="32" name="accountnote" placeholder="경리부 메모/노트"
><?=$accountnote?></textarea></div>
</div>
</div>
<div id="estimate_text2">
<!-- 공사진행현황 -->
<div class="sero1"> <img src="../img/work_title.png"> </div>
<div class="sero111">
<?php
if($checkbox!="1") {
?>
<input type="checkbox" name=checkbox value="1" > 계약전 </div>
<?php
} ?>
<?php
if($checkbox=="1") {
?>
<input type="checkbox" name=checkbox checked value="1" > 계약전 </div>
<?php
} ?>
<div id="write_button_renew"><input type="image" src="../img/ok.png">&nbsp;&nbsp;&nbsp;&nbsp;
<a href="list.php?&page=<?=$page?>&search=<?=$search?>&find=<?=$find?>&process=<?=$process?>&yearcheckbox=<?=$yearcheckbox?>&year=<?=$year?>"><img src="../img/list.png"></a>
</div> <br>
<div id="title1">
요청사항 선택 : &nbsp;
<?php
if($checkstep==Null)
$checkstep="없음";
?>
<?php
if($checkstep=="없음") {
?>
없음 <input type="radio" checked name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="상담요청") {
?>
없음 <input type="radio" name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" checked name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="방문요청") {
?>
없음 <input type="radio"name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" checked name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="실측요청") {
?>
없음 <input type="radio"name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" checked name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="발주요청") {
?>
없음 <input type="radio"name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" checked name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="결선요청") {
?>
없음 <input type="radio" name=checkstep value="없음" >
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청" >
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청" >
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" checked name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" name=checkstep value="견적요청" >
<?php
} ?>
<?php
if($checkstep=="견적요청") {
?>
없음 <input type="radio" name=checkstep value="없음">
&nbsp; 상담요청<input type="radio" name=checkstep value="상담요청">
&nbsp; 방문요청<input type="radio" name=checkstep value="방문요청">
&nbsp; 실측요청<input type="radio" name=checkstep value="실측요청" >
&nbsp; 발주요청<input type="radio" name=checkstep value="발주요청" >
&nbsp; 결선요청<input type="radio" name=checkstep value="결선요청" >
&nbsp; 견적요청<input type="radio" checked name=checkstep value="견적요청" >
<?php
} ?>
</div> <!-- 화면상단 요청사항 나타내기 -->
<br>
<div class="sero1"> 현장명 : </div>
<div class="sero2"><input type="text" name="workplacename" value="<?=$workplacename?>" size="40" placeholder="현장명" required> </div>
<div class="sero11"> 공사담당 : </div>
<div class="sero12"><input type="text" name="chargedperson" value="<?=$chargedperson?>" size="10" placeholder="공사담당"> </div>
<br> <br>
<div class="sero1"> 현장주소 : </div>
<div class="sero2"><input type="text" name="address" value="<?=$address?>" size="50" placeholder="현장주소" ></div><br> <br> <br>
<div class="sero1"> 건 설 사 : </div>
<div class="sero2"><input type="text" name="firstord" value="<?=$firstord?>" size="15" placeholder="건설사" > </div>
<div class="sero33"> 담당 : </div>
<div class="sero4"> <input type="text" name="firstordman" value="<?=$firstordman?>" size="10" placeholder="원청담당"></div>
<div class="sero5"> 연락처 : </div>
<div class="sero6"> <input type="text" name="firstordmantel" value="<?=$firstordmantel?>" size="14" placeholder="연락번호"></div> <br> <br>
<div class="sero1"> 발주처 : </div>
<div class="sero2"><input type="text" name="secondord" value="<?=$secondord?>" size="15" placeholder="발주처" > </div>
<div class="sero33"> 담당 : </div>
<div class="sero4"> <input type="text" name="secondordman" value="<?=$secondordman?>" size="10" placeholder="발주처 담당자"></div>
<div class="sero5"> 연락처 : </div>
<div class="sero6"> <input type="text" name="secondordmantel" value="<?=$secondordmantel?>" size="14" placeholder="연락번호" ></div> <br> <br>
<div class="sero13"> 발주처 결재 공무담당 : </div>
<div class="sero4"> <input type="text" name="claimperson" value="<?=$claimperson?>" size="10" placeholder="공무담당"></div>
<div class="sero5"> 연락처 : </div>
<div class="sero6"> <input type="text" name="claimtel" value="<?=$claimtel?>" size="14" placeholder="공무전화"></div> <br> <br>
<br>
<div class="sero99"> 시공투입일: </div>
<div class="sero22"><input type="text" name="workday" value="<?=$workday?>" size="9" placeholder="투입일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/ > </div>
<div class="sero999"> 시공팀 : </div>
<div class="sero22"> <input type="text" name="worker" value="<?=$worker?>" size="9" placeholder="시공팀" ></div>
<div class="sero99"> 시공완료일 : </div>
<div class="sero22"><input type="text" name="endworkday" value="<?=$endworkday?>" size="9" placeholder="시공완료일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<br><br>
<div class="sero99"> 결선작업일: </div>
<div class="sero22"><input type="text" name="cableday" value="<?=$cableday?>" size="9" placeholder="투입일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)" /> </div>
<div class="sero999"> 결선팀 : </div>
<div class="sero22"> <input type="text" name="cablestaff" value="<?=$cablestaff?>" size="9" placeholder="결선팀" ></div>
<div class="sero99"> 결선완료일 : </div>
<div class="sero22"><input type="text" name="endcableday" value="<?=$endcableday?>" size="9" placeholder="결선완료일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<br><br> <br><br>
<div class="sero9"> 모터회사/용량 : </div>
<div class="sero2"><input type="text" name="motormaker" value="<?=$motormaker?>" size="15" placeholder="경동/인성/KST 등" > </div>
<div class="sero10"> 전원사양 : </div>
<div class="sero4"> <input type="text" name="power" value="<?=$power?>" size="8" placeholder="220v,380v" ></div>
<br><br>
<div class="sero7"> 시공내역 및 수량 : </div>
<div class="sero8"> <textarea rows="2" cols="62" name="worklist" placeholder="셔터종류,수량 등 구체적 기술" ><?=$worklist?></textarea></div> <br><br><br><br>
<div class="sero7" style="color:red" ><b> 설계변경 내역 :</b> </div>
<div class="sero8"> <textarea rows="2" cols="62" name="change_worklist" placeholder="설계변경 내역 기록" ><?=$change_worklist?></textarea></div> <br><br><br>
<img src="../img/comment_title.png"> <br><br>
<div class="sero8"> <textarea rows="10" cols="75" name="comment" placeholder="공사관련 메모를 남겨주세요."
><?=$comment?></textarea></div> <br><br><br><br><br><br><br><br><br><br><br><br><br>
<img src="../img/title_outputmemo.png"> <br><br>
<div class="sero8"> <textarea rows="8" cols="75" name="outputmemo" placeholder="자재 출고내역 정리(황규선차장님)"
><?=$outputmemo?></textarea></div> <br><br><br><br><br><br><br><br><br><br><br>
<img src="../img/claim_title.png"> <br> <br> <!-- 기성청구 -->
<div class="sero8_1"> <b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;청구일&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 청구금액 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;확정금액 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;잔 액</b> </div> <br>
<div class="sero14"> 1차 : </div>
<div class="sero22"><input type="text" name="claimdate1" value="<?=$claimdate1?>" style="font-size:12px" size="14" placeholder="1차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount1" value="<?=$claimamount1?>" size="14" style="font-size:12px" placeholder="1차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix1" value="<?=$claimfix1?>" size="14" style="font-size:12px" placeholder="1차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance1" value="<?=$claimbalance1?>" size="14" style="font-size:12px" placeholder="1차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero14"> 2차 : </div>
<div class="sero22"><input type="text" name="claimdate2" value="<?=$claimdate2?>" size="14" style="font-size:12px" placeholder="2차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount2" value="<?=$claimamount2?>" size="14" style="font-size:12px" placeholder="2차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix2" value="<?=$claimfix2?>" size="14" style="font-size:12px" placeholder="2차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance2" value="<?=$claimbalance2?>" size="14" style="font-size:12px" placeholder="2차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br> <br>
<div class="sero14"> 3차 : </div>
<div class="sero22"><input type="text" name="claimdate3" value="<?=$claimdate3?>" size="14" style="font-size:12px" placeholder="3차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount3" value="<?=$claimamount3?>" size="14" style="font-size:12px" placeholder="3차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix3" value="<?=$claimfix3?>" size="14" style="font-size:12px" placeholder="3차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance3" value="<?=$claimbalance3?>" size="14" style="font-size:12px" placeholder="3차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero14"> 4차 : </div>
<div class="sero22"><input type="text" name="claimdate4" value="<?=$claimdate4?>" size="14" style="font-size:12px" placeholder="4차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount4" value="<?=$claimamount4?>" size="14" style="font-size:12px" placeholder="4차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix4" value="<?=$claimfix4?>" size="14" style="font-size:12px" placeholder="4차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance4" value="<?=$claimbalance4?>" size="14" style="font-size:12px" placeholder="4차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero14"> 5차 : </div>
<div class="sero22"><input type="text" name="claimdate5" value="<?=$claimdate5?>" size="14" style="font-size:12px" placeholder="5차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount5" value="<?=$claimamount5?>" size="14" style="font-size:12px" placeholder="5차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix5" value="<?=$claimfix5?>" size="14" style="font-size:12px" placeholder="5차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance5" value="<?=$claimbalance5?>" size="14" style="font-size:12px" placeholder="5차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br><br>
<div class="sero14"> 6차 : </div>
<div class="sero22"><input type="text" name="claimdate6" value="<?=$claimdate6?>" size="14" style="font-size:12px" placeholder="6차청구일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/></div>
<div class="sero22"><input type="text" name="claimamount6" value="<?=$claimamount6?>" size="14" style="font-size:12px" placeholder="6차청구액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix6" value="<?=$claimfix6?>" size="14" style="font-size:12px" placeholder="6차확정액" onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance6" value="<?=$claimbalance6?>" size="14" style="font-size:12px" placeholder="6차잔액" disabled onkeyup="inputNumberFormat(this)"/></div> <br><br>
----------------------------------------------------------------------- <br><br>
<div class="sero14"> 누적계 : </div>
<div class="sero22">&nbsp;</div>
<div class="sero22"><input type="text" name="claimamount7" value="<?=$claimamount7?>" size="14" style="font-size:12px" placeholder="청구금누계" disabled onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimfix7" value="<?=$claimfix7?>" size="14" style="font-size:12px" placeholder="확정액누계" disabled onkeyup="inputNumberFormat(this)"/></div>
<div class="sero22"><input type="text" name="claimbalance7" value="<?=$claimbalance7?>" size="14" style="font-size:12px" placeholder="잔액누계" disabled onkeyup="inputNumberFormat(this)"/></div> <br>
<b> <p style="color:#FF0000";>&nbsp;&nbsp;&nbsp;&nbsp;기성청구 잔액 및 누적합계는 자동계산됩니다. </p> </b> <br>
<div class="sero1"> <img src="../img/as_title.png"> </div>
<div class="sero1111">
<?php
if($as_check!="1") {
?>
<input type="checkbox" name=as_check value="1" > AS 진행현황만 표시 </div>
<?php
} ?>
<?php
if($as_check=="1") {
?>
<input type="checkbox" name=as_check checked value="1" > AS 진행현황만 표시 </div>
<?php
} ?>
<div class="sero1_2"> <input type="button" onclick='copy_below()' value="AS기록으로 복사 이관" > </div> <div class="sero1_3"> <input type="button" onclick='del_below()' value="입력란 초기화" ></div>
<br><br><br><br>
<div class="sero1"> AS 접수일 : </div>
<div class="sero2"><input type="text" id="asday" name="asday" value="<?=$asday?>" size="10" placeholder="AS 접수일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<div class="sero3"> 접수자 : </div>
<div class="sero4"> <input type="text" id="aswriter" name="aswriter" value="<?=$aswriter?>" size="10" placeholder="AS접수자"></div>
<div class="sero3"> 요청인 : </div>
<div class="sero4"> <input type="text" id="asorderman" name="asorderman" value="<?=$asorderman?>" size="10" placeholder="AS의뢰자"></div><br> <br>
<div class="sero_as_step">
요청사항 선택 : &nbsp;
<?php
if($as_step==Null)
$as_step="없음";
?>
<?php
if($as_step=="없음") {
?>
없음 <input type="radio" checked name=as_step value="없음" >
&nbsp; AS<input type="radio" name=as_step value="AS" >
&nbsp; 결선<input type="radio" name=as_step value="결선" >
&nbsp; 입결선<input type="radio" name=as_step value="입결선" >
&nbsp; 셔터시공<input type="radio" name=as_step value="셔터시공" >
<?php
} ?>
<?php
if($as_step=="AS") {
?>
없음 <input type="radio" name=as_step value="없음" >
&nbsp; AS<input type="radio" checked name=as_step value="AS" >
&nbsp; 결선<input type="radio" name=as_step value="결선" >
&nbsp; 입결선<input type="radio" name=as_step value="입결선" >
&nbsp; 셔터시공<input type="radio" name=as_step value="셔터시공" >
<?php
} ?>
<?php
if($as_step=="결선") {
?>
없음 <input type="radio"name=as_step value="없음" >
&nbsp; AS<input type="radio" name=as_step value="AS" >
&nbsp; 결선<input type="radio" checked name=as_step value="결선" >
&nbsp; 입결선<input type="radio" name=as_step value="입결선" >
&nbsp; 셔터시공<input type="radio" name=as_step value="셔터시공" >
<?php
} ?>
<?php
if($as_step=="입결선") {
?>
없음 <input type="radio"name=as_step value="없음" >
&nbsp; AS<input type="radio" name=as_step value="AS" >
&nbsp; 결선<input type="radio" name=as_step value="결선" >
&nbsp; 입결선<input type="radio" checked name=as_step value="입결선" >
&nbsp; 셔터시공<input type="radio" name=as_step value="셔터시공" >
<?php
} ?>
<?php
if($as_step=="셔터시공") {
?>
없음 <input type="radio"name=as_step value="없음" >
&nbsp; AS<input type="radio" name=as_step value="AS" >
&nbsp; 결선<input type="radio" name=as_step value="결선" >
&nbsp; 입결선<input type="radio" name=as_step value="입결선" >
&nbsp; 셔터시공<input type="radio" checked name=as_step value="셔터시공" >
<?php
} ?>
</div>
<div class="sero5_1"> 연락처 : </div>
<div class="sero6"> <input type="text" id="asordermantel" name="asordermantel" value="<?=$asordermantel?>" size="14" placeholder="요청인 연락처"></div> <br> <br> <br>
<div class="sero6">
<?php
if($asfee==0) {
?>
무상 <input type="radio" id="asfee" checked name="asfee" value="0">
&nbsp;&nbsp; 유상 <input type="radio" id="asfee" name="asfee" value="1" style="color:red">
<?php
} ?>
<?php
if($asfee==1) {
?>
무상 <input type="radio" id="asfee" name="asfee" value="0">
&nbsp;&nbsp; 유상 <input type="radio" checked id="asfee" name="asfee" value="1" style="color:red">
<?php
} ?>
&nbsp;&nbsp; 유상일 경우 견적금액 : </div> <div class="sero66"> <input type="text" id="asfee_estimate" name="asfee_estimate" value="<?=$asfee_estimate?>" size="10" onkeyup="inputNumberFormat(this)" placeholder="유상 금액"></div>
<br><br> <br>
<div class="sero7"> AS 증상(구체적) : </div>
<div class="sero8"> <textarea rows="2" cols="63" id="aslist" name="aslist" placeholder="구체적 증상 설명"
><?=$aslist?></textarea></div> <br><br><br><br>
<div class="sero7"> 작업자 참조사항 : </div>
<div class="sero8"> <textarea rows="2" cols="63" id="as_refer" name="as_refer" placeholder="작업자 참조사항 기록"
><?=$as_refer?></textarea></div> <br><br><br><br>
<div class="sero1"> 처리 예정일 : </div>
<div class="sero2"><input type="text" id="asproday" name="asproday" value="<?=$asproday?>" size="10" placeholder="AS 예정일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<div class="sero1_1"> 세팅 예정일 : </div>
<div class="sero2_1"><input type="text" id="setdate" name="setdate" value="<?=$setdate?>" size="10" placeholder="세팅 예정일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<div class="sero3"> AS담당 : </div>
<div class="sero4"> <input type="text" id="asman" name="asman" value="<?=$asman?>" size="10" placeholder="AS처리담당"></div><br> <br> <br>
<div class="sero1"> 최종AS완료: </div>
<div class="sero2"><input type="text" id="asendday" name="asendday" value="<?=$asendday?>" size="10" placeholder="최종AS완료일" oninput="this.value = this.value.replace(/[^0-9\-]/g,'')" onkeyup="date_mask(this.form.name, this.name)"/> </div>
<div class="sero77"> 처 리 결 과 : </div>
<div class="sero8"> <textarea rows="2" cols="44" id="asresult" name="asresult" placeholder="처리결과 기록"
><?=$asresult?></textarea></div> <br><br><br><br>
<div class="sero7_1"> AS 기록 : </div>
<div class="sero8"> <textarea id="ashistory" rows="11" cols="71" name="ashistory" placeholder="지속적으로 기록을 남겨 보관"
><?=$ashistory?></textarea></div> <br><br><br>
</div>
</div>
</form>
</div>
<script>
function inputNumberFormat(obj) {
obj.value = comma(uncomma(obj.value));
}
function comma(str) {
str = String(str);
return str.replace(/(\d)(?=(?:\d{3})+(?!\d))/g, '$1,');
}
function uncomma(str) {
str = String(str);
return str.replace(/[^\d]+/g, '');
}
function date_mask(formd, textid) {
/*
input onkeyup에서
formd == this.form.name
textid == this.name
*/
var form = eval("document."+formd);
var text = eval("form."+textid);
var textlength = text.value.length;
if (textlength == 4) {
text.value = text.value + "-";
} else if (textlength == 7) {
text.value = text.value + "-";
} else if (textlength > 9) {
//날짜 수동 입력 Validation 체크
var chk_date = checkdate(text);
if (chk_date == false) {
return;
}
}
}
function checkdate(input) {
var validformat = /^\d{4}\-\d{2}\-\d{2}$/; //Basic check for format validity
var returnval = false;
if (!validformat.test(input.value)) {
alert("날짜 형식이 올바르지 않습니다. YYYY-MM-DD");
} else { //Detailed check for valid date ranges
var yearfield = input.value.split("-")[0];
var monthfield = input.value.split("-")[1];
var dayfield = input.value.split("-")[2];
var dayobj = new Date(yearfield, monthfield - 1, dayfield);
}
if ((dayobj.getMonth() + 1 != monthfield)
|| (dayobj.getDate() != dayfield)
|| (dayobj.getFullYear() != yearfield)) {
alert("날짜 형식이 올바르지 않습니다. YYYY-MM-DD");
} else {
//alert ('Correct date');
returnval = true;
}
if (returnval == false) {
input.select();
}
return returnval;
}
function input_Text(){
document.getElementById("test").value = comma(Math.floor(uncomma(document.getElementById("test").value)*1.1)); // 콤마를 계산해 주고 다시 붙여주고
var copyText = document.getElementById("test"); // 클립보드 복사
copyText.select();
document.execCommand("Copy");
}
function copy_below(){
var park = document.getElementsByName("asfee");
document.getElementById("ashistory").value = document.getElementById("ashistory").value + document.getElementById("asday").value + " " + document.getElementById("aswriter").value+ " " + document.getElementById("asorderman").value + " ";
document.getElementById("ashistory").value = document.getElementById("ashistory").value + document.getElementById("asordermantel").value + " " ;
if(park[1].checked) {
document.getElementById("ashistory").value = document.getElementById("ashistory").value +" 유상 " + document.getElementById("asfee").value + " ";
}
else
{
document.getElementById("ashistory").value = document.getElementById("ashistory").value +" 무상 "+ document.getElementById("asfee").value + " ";
}
document.getElementById("ashistory").value += document.getElementById("asfee_estimate").value + " " + document.getElementById("aslist").value+ " " + document.getElementById("as_refer").value + " ";
document.getElementById("ashistory").value += document.getElementById("asproday").value + " " + document.getElementById("setdate").value+ " " + document.getElementById("asman").value + " ";
document.getElementById("ashistory").value += document.getElementById("asendday").value + " " + document.getElementById("asresult").value+ " ";
// = text1.concat(" ", text2," ", text3, " ", text4);
// document.getElementById("asday").value . document.getElementById("aswriter").value;
//+ document.getElementById("aswriter").value ; // 콤마를 계산해 주고 다시 붙여주고붙여주고
// document.getElementById("test").value = comma(Math.floor(uncomma(document.getElementById("test").value)*1.1)); // 콤마를 계산해 주고 다시 붙여주고붙여주고
}
function del_below()
{
if(confirm("초기화한 자료는 복구할 방법이 없습니다.\n\n정말 초기화 하시겠습니까?")) {
document.getElementById("asday").value = "" ;
document.getElementById("aswriter").value = "" ;
document.getElementById("asorderman").value = "" ;
document.getElementById("asordermantel").value ="";
document.getElementById("asfee_estimate").value = "";
document.getElementById("aslist").value = "";
document.getElementById("as_refer").value ="";
document.getElementById("asproday").value ="";
document.getElementById("setdate").value =""
document.getElementById("asman").value = "";
document.getElementById("asendday").value = "";
document.getElementById("asresult").value = "";
}
}
</script>
</body>
</html>