You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
446 lines
19 KiB
446 lines
19 KiB
<?php
|
|
include "./header.php";
|
|
|
|
$BillNo = $_GET['BillNo'];
|
|
$RowCode = $_GET['RowCode'];
|
|
|
|
//取得計量單位
|
|
$sql_unit = "SELECT * FROM unit";
|
|
$unit_query = mysqli_query($link, $sql_unit);
|
|
$unit = mysqli_fetch_all($unit_query, MYSQLI_ASSOC);
|
|
$sql_rib_biz = "SELECT * FROM rib_business WHERE BillNo = '$BillNo'";
|
|
$rib = mysqli_query($link, $sql_rib_biz);
|
|
foreach ($rib as $rib) {
|
|
$TaxId = $rib['TaxId'];
|
|
$CurrId = $rib['CurrId'];
|
|
}
|
|
|
|
// 連線T8MASADA 取得供應商、合約跟作番號
|
|
|
|
$sql_Biz = "SELECT * FROM comBusinessPartner";
|
|
$BizPartner = $conn->query($sql_Biz);
|
|
$sql_Project = "SELECT * FROM comProject";
|
|
$projects = $conn->query($sql_Project);
|
|
$sql_Material = "SELECT * FROM comMaterialGroup";
|
|
$materials = $conn->query($sql_Material);
|
|
//取得人員名單與使用者的部門
|
|
|
|
$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);
|
|
$conn = null;
|
|
|
|
|
|
?>
|
|
<div style="width: 90%;">
|
|
|
|
<div style="padding-left: 2rem; padding-bottom: 1rem;">
|
|
<a href="rib-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="ribsubadd">
|
|
<div class="text-center">
|
|
<h3>新增費用單據 (廠商)</h3>
|
|
</div>
|
|
<form class="form-horizontal" name="ribsubform" id="ribsubform" method="POST" action="rib02-business-submit.php?rib_id=<?= $rib_id ?>&submit=add&<?= $token_link ?>" enctype="multipart/form-data">
|
|
|
|
|
|
<div class="form-group">
|
|
<div class="col-md-3" style="display: none;">
|
|
<label for="RowCode" style="color: red;">序號</label>
|
|
<input class="form-control" type="int" name="RowCode" id="RowCode" value="<?= $RowCode ?>" disabled>
|
|
|
|
</div>
|
|
|
|
<?php if ($user_id == "M0056") { ?>
|
|
<div class="col-md-3">
|
|
<label for="FeeTypeId" style="color: red;">費用項目代碼</label>
|
|
<select name="FeeTypeId" class="form-control" required>
|
|
<?php
|
|
foreach ($feetype as $key => $value) { ?>
|
|
<option value="<?php echo $value['FeeTypeId']; ?>"><?php echo $value['FeeTypeName']; ?></option>
|
|
<?php };
|
|
?>
|
|
</select>
|
|
</div>
|
|
<?php } else { ?>
|
|
<div class="col-md-3">
|
|
<label for="FeeTypeGen" style="color: red;">費用類別</label>
|
|
<select name="FeeTypeGen" id="FeeTypeGen" class="form-control" required>
|
|
<option value="">請選擇費用類別</option>
|
|
<option value=1>交通費</option>
|
|
<option value=2>出差旅費</option>
|
|
<option value=3>交際餐飲禮品</option>
|
|
<option value=4>文具用品</option>
|
|
<option value=5>郵資、電話/網路費、匯費</option>
|
|
<option value=6>水費</option>
|
|
<option value=7>電費</option>
|
|
<option value=8>瓦斯費</option>
|
|
<option value=9>運費/快遞</option>
|
|
<option value=10>堆高機費用</option>
|
|
<option value=11>五金材料工具</option>
|
|
<option value=12>汽車維修</option>
|
|
<option value=13>研發測試打樣</option>
|
|
<option value=14>繳稅</option>
|
|
<option value=15>其他費用</option>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="FeeTypeId" style="color: red;">費用項目代碼</label>
|
|
<select name="FeeTypeId" id="FeeTypeId" class="form-control" required>
|
|
|
|
</select>
|
|
</div>
|
|
|
|
|
|
<?php } ?>
|
|
|
|
</div>
|
|
<div class="form-group">
|
|
|
|
<div class="col-md-3">
|
|
<label for="FeeNoteShow" style="color: red;">費用說明</label>
|
|
<input class="form-control" type="text" name="FeeNoteShow" id="FeeNoteShow">
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="ProjectId">合約號</label>
|
|
<select name="ProjectId" id="ProjectId">
|
|
<option value=""></option>
|
|
<?php
|
|
foreach ($projects as $Project) {
|
|
?>
|
|
<option value="<?= $Project['ProjectId'] ?>"><?= $Project['ProjectId'] . $Project['ProjectName'] ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="CU_MaterialId">作番號</label>
|
|
<select name="CU_MaterialId" id="CU_MaterialId">
|
|
<option value=""></option>
|
|
<?php
|
|
foreach ($materials as $material) {
|
|
?>
|
|
<option value="<?= $material['MaterialId'] ?>"><?= $material['MaterialId'] . $material['MaterialName'] ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</select>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="UnitId" style="color: red;">計量單位</label>
|
|
<select name="UnitId" class="form-control" required>
|
|
<?php
|
|
foreach ($unit as $key => $value) { ?>
|
|
<option value="<?php echo $value['UnitId']; ?>"><?php echo $value['UnitName']; ?></option>
|
|
<?php };
|
|
?>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="Price" style="color: red;">單價 (原幣值含稅)</label>
|
|
<input class="form-control" type="number" step="any" name="Price" id="Price" required onchange="calOAmount(this.id)">
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="Quantity" style="color: red;">數量</label>
|
|
<input class="form-control" type="number" step="any" name="Quantity" id="Quantity" value="1" required>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="OAmount" style="color: red;">報銷金額 (原幣值含稅)</label>
|
|
<input class="form-control" type="number" step="any" name="OAmount" id="OAmount" placeholder="單價x數量" required disabled>
|
|
</div>
|
|
</div>
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="TaxId">稅碼</label>
|
|
<select name="TaxId" class="form-control">
|
|
<option value="ST005" selected>營業稅5%</option>
|
|
<option value="ST101">零稅</option>
|
|
<option value="ST102">免稅</option>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="IsCounteract">抵扣</label>
|
|
<select name="IsCounteract" class="form-control">
|
|
<option value=1 selected>可抵扣</option>
|
|
<option value=0>不可抵扣</option>
|
|
</select>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="VoucherCount">憑單張數</label>
|
|
<input class="form-control" type="number" name="VoucherCount" id="VoucherCount" max=5 value=1>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="VoucherType">憑單類型</label>
|
|
<select name="VoucherType" id="VoucherType" class="form-control">
|
|
<option value="0" selected>發票</option>
|
|
<option value="1">收據 </option>
|
|
<option value="2">支出證明</option>
|
|
<option value="3">其他</option>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3" id="NotInvoice1">
|
|
<label for="InvoiceId">發票聯式
|
|
<a onclick="ShowInvoice()">
|
|
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-info-circle" viewBox="0 0 16 16">
|
|
<path d="M8 15A7 7 0 1 1 8 1a7 7 0 0 1 0 14zm0 1A8 8 0 1 0 8 0a8 8 0 0 0 0 16z" />
|
|
<path d="m8.93 6.588-2.29.287-.082.38.45.083c.294.07.352.176.288.469l-.738 3.468c-.194.897.105 1.319.808 1.319.545 0 1.178-.252 1.465-.598l.088-.416c-.2.176-.492.246-.686.246-.275 0-.375-.193-.304-.533L8.93 6.588zM9 4.5a1 1 0 1 1-2 0 1 1 0 0 1 2 0z" />
|
|
</svg>
|
|
</a>
|
|
</label>
|
|
|
|
|
|
<select name="InvoiceId" id="InvoiceId" class="form-control">
|
|
<option value="">請選擇發票聯式</option>
|
|
<option value="25">一般電子發票-> 進項三聯式收銀機統一發票及一般稅額計算之電子發票</option>
|
|
<option value="21">三聯式手開發票-> 進項三聯式、電子計算機統一發票</option>
|
|
<option value="22">二聯式收銀機發票 -> 進項二聯式收銀機統一發票、載有稅額之其他憑證</option>
|
|
<?php if ($user_id == "M0056") { ?>
|
|
<option value="23">三聯式、電子計算機、三聯式收銀機統一發票及一般稅額計算之電子發票之進貨退出或折讓證明單</option>
|
|
<option value="24">二聯式收銀機統一發票及載有稅額之其他憑證之進貨退出或折讓證明單</option>
|
|
<option value="26">彙總登錄每張稅額伍佰元以下之進項三聯式、電子計算機統一發票</option>
|
|
<option value="27">彙總登錄每張稅額伍佰元以下之進項二聯式收銀機統一發票、載有稅額之其他憑證</option>
|
|
<option value="28">進項海關代徵營業稅繳納證</option>
|
|
<option value="29">進項海關退還溢繳營業稅申報單</option>
|
|
<?php } ?>
|
|
</select>
|
|
|
|
</div>
|
|
<div class="col-md-3" id="NotInvoice2">
|
|
<label for="InvoiceNo">發票號碼</label>
|
|
<input class="form-control" type="text" name="InvoiceNo" id="InvoiceNo">
|
|
</div>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="comSupplierName">供應商</label>
|
|
<select name="comSupplierName" id="comSupplierName">
|
|
<option value=""></option>
|
|
<option value="雜項請款用">V0001雜項請款用</option>
|
|
<?php
|
|
foreach ($BizPartner as $BizKey => $BizValue) { ?>
|
|
<option value="<?= $BizValue['BizPartnerName'] ?>"><?= $BizValue['BizPartnerId'] . $BizValue['BizPartnerName'] ?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
<div class="col-md-3" id="Tax">
|
|
<label for="TaxNo">統一編號 (供應商)</label>
|
|
<input type="text" name="TaxNo" id="TaxNo" class="form-control">
|
|
</div>
|
|
</div>
|
|
<div>
|
|
|
|
<input type="hidden" name="CurrId" value="<?= $CurrId ?>">
|
|
</div>
|
|
|
|
</div>
|
|
<div class="form-group">
|
|
<div class="col-md-7">
|
|
|
|
</div>
|
|
<div class="col-md-5" style="margin-top: 40px;">
|
|
<button onclick="senddata()" type="button" class="btn btn-primary btn-lg pull-right" style="margin-bottom: 110px;">新增費用單據</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>
|
|
var TempArr = [];
|
|
$(document).ready(function() {
|
|
$("#ProjectId").selectize();
|
|
$("#CU_MaterialId").selectize();
|
|
$("#comSupplierName").selectize();
|
|
})
|
|
$(function() {
|
|
$("#comSupplierName").change(function() {
|
|
if ($("#comSupplierName").val() == "雜項請款用") {
|
|
$("#Tax").show();
|
|
} else {
|
|
$("#Tax").hide();
|
|
}
|
|
})
|
|
$("#TaxNo").change(function() {
|
|
if ($("#TaxNo").val().length !== 8) {
|
|
alert("統一編號格式錯誤");
|
|
}
|
|
})
|
|
$("#VoucherType").change(function() {
|
|
if ($("#VoucherType").val() !== "0") {
|
|
$("#NotInvoice1").hide();
|
|
$("#NotInvoice2").hide();
|
|
} else {
|
|
$("#NotInvoice1").show();
|
|
$("#NotInvoice2").show();
|
|
}
|
|
})
|
|
$('#FeeTypeGen').change(function() {
|
|
console.log($('#FeeTypeGen').val());
|
|
var FeeTypeId = document.getElementById("FeeTypeId")
|
|
var FeeType = [{}, {
|
|
'400001': '交通費-捷利卡儲值',
|
|
'400002': '交通費-油資',
|
|
'400003': '交通費-ETC',
|
|
'400004': '交通費-停車費'
|
|
}, {
|
|
'130101': '差旅費-膳雜費',
|
|
'130102': '差旅費-住宿',
|
|
'130301': '差旅費-機票款',
|
|
'130302': '差旅費-高鐵車資',
|
|
'130303': '差旅費-台鐵車資',
|
|
'130304': '差旅費-客運車資',
|
|
'130305': '差旅費-捷運車資',
|
|
'130306': '差旅費-計程車車資',
|
|
'130307': '差旅費-國外交通費 ',
|
|
'130308': '差旅費-油資',
|
|
'130309': '差旅費-ETC',
|
|
'130310': '差旅費-停車費'
|
|
}, {
|
|
'200001': '交際便餐、飲品',
|
|
'200002': '交際禮品費',
|
|
'200003': '禮金'
|
|
}, {
|
|
'120001': '文具用品',
|
|
'120002': '影印紙',
|
|
'120003': '影印費',
|
|
'120004': '名片'
|
|
}, {
|
|
'150001': '郵資',
|
|
'150002': '電話費',
|
|
'150003': '匯款手續費'
|
|
}, {
|
|
'180101': '水費'
|
|
}, {
|
|
'180201': '電費'
|
|
}, {
|
|
'180301': '瓦斯費'
|
|
}, {
|
|
'140001': '運費/快遞'
|
|
}, {
|
|
'140002': '堆高機費用'
|
|
}, {
|
|
'390001': '材料費、五金用品'
|
|
}, {
|
|
'160002': '汽車維修'
|
|
}, {
|
|
'370004': '研發打樣費',
|
|
'370005': '研發測試費'
|
|
}, {
|
|
'220001': '牌照稅',
|
|
'220002': '燃料費',
|
|
'220005': '印花稅',
|
|
}, {
|
|
'880004': '其他雜項支出'
|
|
}];
|
|
for (var q = 0; q < (FeeType.length); q++) {
|
|
if ($('#FeeTypeGen').val() == (q)) {
|
|
$("#FeeTypeId").empty();
|
|
for (const key in FeeType[q]) {
|
|
FeeTypeId.add(new Option(FeeType[q][key], key));
|
|
}
|
|
}
|
|
}
|
|
})
|
|
$('#FeeDeptId').change(function() {
|
|
changeWriteOffId($('#FeeDeptId').val());
|
|
})
|
|
$("#Price").change(function() {
|
|
$("#OAmount").val($("#Quantity").val() * $("#Price").val());
|
|
});
|
|
$("#Quantity").change(function() {
|
|
$("#OAmount").val($("#Quantity").val() * $("#Price").val());
|
|
});
|
|
$("#FeeDate").change(function() {
|
|
if ($("#FeeDate").val().length != 8) {
|
|
alert("輸入格式錯誤");
|
|
$("#FeeDate").val('');
|
|
} else {
|
|
let year = $("#FeeDate").val().substr(0, 4);
|
|
let month = $("#FeeDate").val().substr(4, 2);
|
|
let day = $("#FeeDate").val().substr(6, 2);
|
|
let feedate = new Date(year, month, day);
|
|
feedate.setMonth(feedate.getMonth() - 1);
|
|
let now = new Date();
|
|
if (feedate > now) {
|
|
alert("費用日期不可大於今天");
|
|
$("#FeeDate").val('');
|
|
} else {
|
|
now.setMonth(now.getMonth() - 2);
|
|
now.setDate(1);
|
|
now.setDate(now.getDate() - 1)
|
|
if (feedate < now) {
|
|
alert("超過兩個月的費用無法進行報銷");
|
|
$("#FeeDate").val('');
|
|
}
|
|
}
|
|
}
|
|
})
|
|
|
|
})
|
|
|
|
function ShowInvoice() {
|
|
window.open('rib02-invoice.php', '發票範例', config = 'height=600, width=600');
|
|
|
|
}
|
|
|
|
function changeWriteOffId(SelectedDept) {
|
|
var SelectDeptId = 'WriteOff' + SelectedDept + '-';
|
|
for (var i = 0; i < WriteOffId.options.length; i++) {
|
|
WriteOffId.options[i].selected = false;
|
|
let thisid = WriteOffId.options[i].id
|
|
if (thisid.search(SelectDeptId) === 0) {
|
|
WriteOffId.options[i].style['display'] = '';
|
|
} else {
|
|
WriteOffId.options[i].style['display'] = 'none';
|
|
};
|
|
|
|
};
|
|
};
|
|
|
|
function senddata() {
|
|
if ($("#FeeDate").val() == "" || $("#FeeNoteShow").val() == "" || $("#Price").val() == "" || $("#Quantity").val() == "") {
|
|
alert("請確認紅字部分皆有填寫");
|
|
} else if ($("#OAmount").val() <= 0) {
|
|
alert("金額必須大於零");
|
|
|
|
} else {
|
|
$("#OAmount").prop("disabled", false);
|
|
$('#ribsubform').submit();
|
|
}
|
|
|
|
}
|
|
</script>
|