sam-kd/account_plan_juil/fetch_in.php

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/session.php");

$mode = isset($_POST['mode']) ? $_POST['mode'] : '';
$num = isset($_POST['num']) ? $_POST['num'] : '';
$tablename = isset($_POST['tablename']) ? $_POST['tablename'] : '';

require_once($_SERVER['DOCUMENT_ROOT'] . "/lib/mydb.php");
$pdo = db_connect();

if ($mode === 'update' && $num) {
    try {
        $sql = "SELECT * FROM " . $tablename . " WHERE num=?";
        $stmh = $pdo->prepare($sql);
        $stmh->bindValue(1, $num, PDO::PARAM_INT);
        $stmh->execute();
        $row = $stmh->fetch(PDO::FETCH_ASSOC);

        $content = $row['content'];  // 저장된 content 값을 가져옴
        include '_row.php';
		// 콤마 제거 후 숫자로 변환
		$amount = floatval(str_replace(',', '', $row['amount']));
    } catch (PDOException $Exception) {
        echo "오류: " . $Exception->getMessage();
        exit;
    }
} else {
    include '_request.php';
    $mode = 'insert';
    $registDate = date('Y-m-d');
    $inoutsep = '수입';
    $amount = 0;
    $content = '';  // 기본값 설정
}

$title_message = ($mode === 'update') ? '수입 (계산서발생) 수정' : '수입 (계산서발행) 신규 등록';

?>

<input type="hidden" id="update_log" name="update_log" value="<?=$update_log?>">
<input type="hidden" id="first_writer" name="first_writer" value="<?=$first_writer?>">
<input type="hidden" id="secondordnum" name="secondordnum" value="<?=$secondordnum?>">

<div class="container-fluid">
    <div class="d-flex align-items-center justify-content-center">
        <div class="card justify-content-center">
            <div class="card-header text-center">
                <span class="text-center fs-5"><?=$title_message?></span>
            </div>
            <div class="card-body">
                <div class="row justify-content-center text-center">
                    <div class="d-flex align-items-center justify-content-center m-2">
                        <table class="table table-bordered">
                            <tbody>
                                <tr>
                                    <td class="text-center fs-6 fw-bold" style="width:150px;">등록일자</td>
                                    <td class="text-center" style="width:200px;">
                                        <input type="date" class="form-control fs-6" id="registDate" name="registDate" style="width:130px;" value="<?=$registDate?>">
                                    </td>
                                    <td class="text-center fs-6 fw-bold" style="width:150px;">구분</td>
                                    <td class="text-center" style="width:200px;">
                                        <div>
                                            <input type="radio" class="form-check-input" id="expense" name="inoutsep" value="수입" <?= $inoutsep === '수입' ? 'checked' : '' ?>>
                                            <label for="expense" class="form-check-label fs-6">수입</label>
                                        </div>
                                    </td>
                                </tr>             
                                <tr>
                                    <td class="text-center fs-6 fw-bold"> 거래처 </td>
                                    <td class="text-start" colspan="3">
										<div class="d-flex align-items-center justify-content-start"> 
												<input type="text" id="content" name="content" value="<?=$content?>" class="form-control noborder-input text-start fs-6"  autocomplete="off"  style="width:70%;"  onkeydown="if(event.keyCode == 13) { phonebookBtn('content'); }"  placeholder="코드연동을 위해 검색해서 입력해주세요" > &nbsp;
											<button type="button" class="btn btn-dark-outline btn-sm restrictbtn" onclick="phonebookBtn('content');"> <i class="bi bi-gear"></i> </button>
										</div>							
                                    </td>
                                </tr>
                                <tr>
                                    <td class="text-center fs-6 fw-bold" style="width:150px;">금액</td>
                                    <td class="text-center">
                                        <input type="text" class="form-control fs-6  noborder-input  text-end" id="amount" name="amount" value="<?= isset($amount) ? number_format($amount) : '' ?>" autocomplete="off" onkeyup="inputNumberFormat(this)">
                                    </td>
                                    <td class="text-center" colspan="2">                                                                                
                                    </td>                                    
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="d-flex justify-content-center">
                    <button type="button" id="saveBtn" class="btn btn-dark btn-sm me-3">
                        <i class="bi bi-floppy-fill"></i> 저장
                    </button>
                    <?php if($mode != 'insert') { ?>
                    <button type="button" id="deleteBtn" class="btn btn-danger btn-sm me-3">
                        <i class="bi bi-trash"></i>  삭제 
                    </button>
                    <?php } ?>
                    <button type="button" id="closeBtn" class="btn btn-outline-dark btn-sm me-2">
                        &times; 닫기
                    </button>
                </div>
            </div>
        </div>
    </div>
</div>