gary_wms/wms/rib01-business-edit.php

<?php
include "./header.php";
$BillNo = $_GET['BillNo'];
$state = $_GET['state'];
//取得表頭數據
$date_sql = "SELECT * from rib_business WHERE (BillNo='$BillNo')";
$query_rib = mysqli_query($link, $date_sql);
foreach ($query_rib as $q) {
    $rib = $q;
}
// 連線T8MASADA 

$member = array();
//取得人員名單與使用者的部門
$sql_mydept =  "SELECT UserId, Username FROM capMembership";
$deptmem = $conn->query($sql_mydept);
foreach ($deptmem as $mem) {
    $userid = $mem['UserId'];
    $username = $mem['Username'];
    $member["$userid"] = [$username];
};
$sql_dept = "SELECT DeptId, PersonId FROM comPerson WHERE DeptId!='0001'";
$allpeople = $conn->query($sql_dept);
foreach ($allpeople as $man) {
    if ($man['PersonId'] == $user_id) {
        $mydepart = $man['DeptId'];
    }
    $personid = $man['PersonId'];
    $depart = $man['DeptId'];
    if (isset($member["$personid"])) {
        array_push($member["$personid"], "$depart");
    };
}
//取得部門代碼
$sql_department = "SELECT DeptId,DeptName FROM comDepartment WHERE DeptId!='0001'";
$deptype = $conn->query($sql_department);

//取得供應商
$sql_Biz = "SELECT comBusinessPartner.BizPartnerId, comBusinessPartner.BizPartnerName FROM comBusinessPartner INNER JOIN comSupplier ON comBusinessPartner.BizPartnerId=comSupplier.BizPartnerId WHERE comBusinessPartner.BizPartnerId !='V0001'";
$BizPartner = $conn->query($sql_Biz);
$conn = null;


?>
<div style="width: 90%;">

    <div style="padding-left: 2rem; padding-bottom: 1rem;">
        <a href="rib01-business-index.php?<?php echo $token_link; ?>" class="btn btn-default btn-lg">
            <span class="glyphicon glyphicon-home"></span>
        </a>
    </div>
</div>
<div class="container" id="ribadd">
    <div class="text-center">
        <h3>報銷單據 (廠商)</h3>
    </div>
    <form class="form-horizontal" name="ribbizadd" id="ribbizadd" method="POST" action="rib01-business-edit.php?submit=edit&state=0&<?= $token_link ?>" enctype="multipart/form-data">
        <div class="form-group">
            <div class="col-md-6">
                <label for="BillNo">單據編號</label>
                <input class="form-control" type="text" name="BillNo" id="BillNo" value="<?php echo $BillNo ?>" disabled>
            </div>
            <div class="col-md-6">
                <label for="BillDate">單據日期</label>
                <input class="form-control" type="text" name="BillDate" id="BillDate" value=<?= $rib['BillDate'] ?> disabled>
            </div>

        </div>
        <div class="form-group">
            <div class="col-md-6">
                <label for="DeptId" style="color: red;">採購部門</label>
                <select name="DeptId" id="DeptId" class="form-control">
                    <?php
                    foreach ($deptype as $dept) { ?>
                        <option value="<?php echo $dept['DeptId']; ?>" <?php
                                                                        if ($dept['DeptId'] == $rib['DeptId']) {
                                                                            echo "selected";
                                                                        } ?>><?php echo $dept['DeptName']; ?></option>
                    <?php };
                    ?>
                </select>
            </div>
            <div class="col-md-6">
                <label for="PersonId" style="color: red;">採購人員</label>
                <select name="PersonId" id="PersonId" class="form-control">
                    <option value="" style="display:flex" id="WriteOffoption">請選擇採購人員</option>
                    <?php
                    foreach ($member as $key => $value) { ?>
                        <option value="<?php echo $key; ?>" id="<?= 'WriteOff' . $value[1] . "-" . $value[0] ?>" <?php if ($key == $rib['PersonId']) {
                                                                                                                        echo "selected";
                                                                                                                    } ?>> <?php echo $value[0]; ?> </option>
                    <?php }
                    ?>
                </select>
            </div>
        </div>

        <div class="form-group">

            <div class="col-md-4">
                <label for="CurrId" style="color: red;">幣別</label>
                <select name="CurrId" id="CurrId" class="form-control">
                    <option value="TWD" <?php if ($rib['CurrId'] == 'TWD') {
                                            echo "selected";
                                        } ?>>台幣</option>
                    <option value="CNY" <?php if ($rib['CurrId'] == 'CNY') {
                                            echo "selected";
                                        } ?>>人民幣</option>
                    <option value="EUR" <?php if ($rib['CurrId'] == 'EUR') {
                                            echo "selected";
                                        } ?>>歐元</option>
                    <option value="HKD" <?php if ($rib['CurrId'] == 'HKD') {
                                            echo "selected";
                                        } ?>>港幣</option>
                    <option value="USD" <?php if ($rib['CurrId'] == 'USD') {
                                            echo "selected";
                                        } ?>>美元</option>
                </select>
            </div>
            <div class="col-md-4">
                <label for="TaxId" style="color: red;">稅碼</label>
                <select name="TaxId" class="form-control">
                    <option value="ST005" <?php if ($rib['TaxId'] == 'ST005') {
                                                echo "selected";
                                            } ?>>營業稅5%</option>
                    <option value="ST101" <?php if ($rib['TaxId'] == 'ST101') {
                                                echo "selected";
                                            } ?>>零稅</option>
                    <option value="ST102" <?php if ($rib['TaxId'] == 'ST102') {
                                                echo "selected";
                                            } ?>>免稅</option>
                </select>
            </div>
            <div class="col-md-4">
                <label for="BizPartnerId" style="color: red;">供應商統一編號</label>
                <input id="BizPartnerId" name="BizPartnerId" class="form-control" onblur="checkBiz()" value="<?= $rib['BizPartnerId'] ?>">
            </div>
        </div>

        <div class="form-group">


        </div>
        <hr>
        <div class="form-group">
            <div class="col-md-3">

            </div>
            <div class="col-md-9 ">
                <button type="submit" class="btn btn-primary btn-lg pull-right">修改</button>
            </div>
        </div>
    </form>
</div>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.15.2/css/selectize.default.min.css" integrity="sha512-pTaEn+6gF1IeWv3W1+7X7eM60TFu/agjgoHmYhAfLEU8Phuf6JKiiE8YmsNC0aCgQv4192s4Vai8YZ6VNM6vyQ==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.15.2/js/selectize.min.js" integrity="sha512-IOebNkvA/HZjMM7MxL0NYeLYEalloZ8ckak+NDtOViP7oiYzG5vn6WVXyrJDiJPhl4yRdmNAG49iuLmhkUdVsQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script>
    $(document).ready(function() {
        $("#comSupplierId").selectize();
    })
    $(function() {
        $("#DeptId").change(function() {
            changeWriteOffId($('#DeptId').val());
        })
    })

    function changeWriteOffId(SelectedDept) {
        var SelectDeptId = 'WriteOff' + SelectedDept + "-";
        for (var i = 0; i < PersonId.options.length; i++) {
            PersonId.options[i].selected = false;
            let thisid = PersonId.options[i].id
            if (thisid.search(SelectDeptId) === 0) {
                PersonId.options[i].style['display'] = '';
            } else {
                PersonId.options[i].style['display'] = 'none';
            };

        };
    };
</script>