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.
724 lines
34 KiB
724 lines
34 KiB
<?php
|
|
include "./header.php";
|
|
|
|
$rib_id = isset($_GET['id']) ? $_GET['id'] : null;
|
|
$BillNo = isset($_GET['BillNo']) ? $_GET['BillNo'] : null;
|
|
$CurrId = isset($_GET['CurrId']) ? $_GET['CurrId'] : null;
|
|
$sql_rib = "";
|
|
if (empty($rib_id)) {
|
|
$sql_rib = "SELECT * FROM rib WHERE BillNo = '$BillNo' && CurrentState=0";
|
|
$sql_invoiceNo = "SELECT DISTINCT InvoiceNo FROM rib_sub LEFT JOIN rib ON rib.rib_id=rib_sub.rib_id WHERE (rib.CurrentState=2 || rib.CurrentState=4 ) AND rib.BillNo!='$BillNo'";
|
|
} else {
|
|
$sql_rib = "SELECT * FROM rib WHERE rib_id = $rib_id";
|
|
$sql_invoiceNo = "SELECT DISTINCT InvoiceNo FROM rib_sub LEFT JOIN rib ON rib.rib_id=rib_sub.rib_id WHERE (rib.CurrentState=2 || rib.CurrentState=4 ) AND rib.rib_id!=$rib_id";
|
|
}
|
|
$rib_query = mysqli_query($link, $sql_rib);
|
|
if (mysqli_num_rows($rib_query) > 0) {
|
|
while ($rib = mysqli_fetch_assoc($rib_query)) {
|
|
$rib_id = $rib['rib_id'];
|
|
$WrtieOffId = $rib['WriteOffId'];
|
|
$FeeDeptId = $rib['DeptId'];
|
|
$CurrId = $rib['CurrId'];
|
|
if ($rib['CurrentState'] == 1) {
|
|
// 爬蟲--匯率
|
|
function htmlContentGet($url)
|
|
{
|
|
$opts = [
|
|
"http" => [
|
|
"method" => "GET",
|
|
"header" => "User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36\r\n"
|
|
]
|
|
];
|
|
|
|
return file_get_contents($url, false, stream_context_create($opts));
|
|
}
|
|
|
|
$week = date("w");
|
|
$currency_day = date("Y-m-d", strtotime("-1 day"));
|
|
if ($week == 1) {
|
|
$currency_day = date("Y-m-d", strtotime("-3 day"));
|
|
} elseif ($week == 0) {
|
|
$currency_day = date("Y-m-d", strtotime("-2 day"));
|
|
}
|
|
$X = htmlContentGet('https://rate.bot.com.tw/xrt/all/' . $currency_day);
|
|
$string = strip_tags($X); // 先清掉 html tag, 以免 html tag 被破壞
|
|
//美金
|
|
$USD = explode(' ', stristr($string, '美金'))[298];
|
|
//人民幣
|
|
$RMB = explode(' ', stristr($string, '人民幣'))[298];
|
|
//歐元
|
|
$EUR = explode(' ', stristr($string, '歐元'))[298];
|
|
//港幣
|
|
$HKD = explode(' ', stristr($string, '港幣'))[298];
|
|
|
|
//整理要變更的數據 -表身
|
|
$CurrLAmount = 1;
|
|
if ($rib['CurrId'] == "CNY") {
|
|
$CurrLAmount = $RMB;
|
|
} elseif ($rib['CurrId'] == "EUR") {
|
|
$CurrLAmount = $EUR;
|
|
} elseif ($rib['CurrId'] == "HKD") {
|
|
$CurrLAmount = $HKD;
|
|
} elseif ($rib['CurrId'] == "USD") {
|
|
$CurrLAmount = $USD;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
$RowCode = $_GET['RowCode'];
|
|
|
|
//取得費用項目代碼
|
|
|
|
$sql_feetype = "SELECT FeeTypeId, FeeTypeName FROM comFeeType WHERE (FeeTypeId NOT LIKE 'A%') AND(FeeTypeId NOT LIKE 'Z%')";
|
|
$feetype = $conn->query($sql_feetype);
|
|
$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_unit = "SELECT * FROM unit";
|
|
$unit_query = mysqli_query($link, $sql_unit);
|
|
$unit = mysqli_fetch_all($unit_query, MYSQLI_ASSOC);
|
|
|
|
// 取得供應商、合約跟作番號
|
|
$BusinessPartner = array();
|
|
$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);
|
|
$bizcount = 0;
|
|
foreach ($BizPartner as $biz) {
|
|
$bizKey = $biz['BizPartnerId'];
|
|
$bizValue = $biz['BizPartnerName'];
|
|
array_push($BusinessPartner, $bizKey);
|
|
$bizcount += 1;
|
|
}
|
|
// 取得所有報銷過的發票號碼
|
|
|
|
$invoiceNo = mysqli_query($link, $sql_invoiceNo);
|
|
$invoiceNo_array = array();
|
|
if(is_iterable($invoiceNo)){
|
|
foreach ($invoiceNo as $invoice) {
|
|
array_push($invoiceNo_array, $invoice['InvoiceNo']);
|
|
}
|
|
}
|
|
|
|
$BizJSON = json_encode($BusinessPartner);
|
|
$InvoiceJSON = json_encode($invoiceNo_array);
|
|
$sql_Project = "SELECT * FROM comProject";
|
|
$projects = $conn->query($sql_Project);
|
|
$sql_Material = "SELECT * FROM comMaterialGroup";
|
|
$materials = $conn->query($sql_Material);
|
|
|
|
?>
|
|
<div style="width: 90%;">
|
|
|
|
<div style="padding-left: 2rem; padding-bottom: 1rem;">
|
|
<a href="rib01-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-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 ?>" required>
|
|
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="FeeDate" style="color: red;">費用日期</label>
|
|
<input class="form-control" type="int" name="FeeDate" id="FeeDate" placeholder="西元年(4碼)+月(2碼)+日(2碼)" required>
|
|
|
|
</div>
|
|
<?php if ($user_id == "M0056" || $user_id == "M0209") { ?>
|
|
<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 class="col-md-3">
|
|
<label for="FeeDeptId" style="color: red;">歸屬部門</label>
|
|
<select name="FeeDeptId" id="FeeDeptId" class="form-control" required>
|
|
<?php
|
|
foreach ($deptype as $dept) { ?>
|
|
<option value="<?php echo $dept['DeptId']; ?>" <?php
|
|
if ($dept['DeptId'] == $FeeDeptId) {
|
|
echo "selected";
|
|
} ?>><?php echo $dept['DeptName']; ?></option>
|
|
<?php };
|
|
?>
|
|
</select>
|
|
|
|
</div>
|
|
|
|
</div>
|
|
<div class="form-group">
|
|
|
|
<div class="col-md-3">
|
|
<label for="WriteOffId" style="color: red;">報銷人</label>
|
|
<select name="WriteOffId" id="WriteOffId" class="form-control" required>
|
|
<option value="">請選擇報銷人</option>
|
|
<?php
|
|
foreach ($member as $key => $value) { ?>
|
|
<option value="<?php echo $key; ?>" style="display:none" id="<?= 'WriteOff' . $value[1] . '-' . $value[0] ?>" <?php if ($key == $WrtieOffId) {
|
|
echo "selected";
|
|
} ?>> <?php echo $value[0]; ?> </option>
|
|
<?php }; ?>
|
|
</select>
|
|
</div>
|
|
|
|
<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="TaxId">稅碼</label>
|
|
<select name="TaxId" id="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" id="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="UnitId" style="color: red;">計量單位</label>
|
|
<select name="UnitId" id="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>
|
|
</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>
|
|
<?php
|
|
if ($user_id == "M0056" || $user_id == "M0209") {
|
|
?>
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="CurrId">幣別</label>
|
|
<input class="form-control" type="text" name="CurrId" id="CurrId" value="<?php if ($CurrId == "TWD") {
|
|
echo "台幣";
|
|
} elseif ($CurrId == "CNY") {
|
|
echo "人民幣";
|
|
} elseif ($CurrId == "EUR") {
|
|
echo "歐元";
|
|
} elseif ($CurrId == "HKD") {
|
|
echo "港幣";
|
|
} else {
|
|
echo "美元";
|
|
} ?>" disabled>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="CurrLAmount">匯率</label>
|
|
<input class="form-control" type="number" name="CurrLAmount" id="CurrLAmount" value="<?= $CurrLAmount ?>" disabled>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="OTax">稅金 (原幣值)</label>
|
|
<input class="form-control" type="number" name="OTax" id="OTax" value="<?= $ribsub['OTax'] ?>" disabled>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="LTax">本幣稅金</label>
|
|
<input class="form-control" type="number" step="any" name="LTax" id="LTax" value="<?= $ribsub['LTax'] ?>" disabled>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<div class="form-group">
|
|
<div class="col-md-3">
|
|
<label for="OAmountUnWithTax">未稅報銷金額 (原幣值)</label>
|
|
<input class="form-control" type="number" name="OAmountUnWithTax" id="OAmountUnWithTax" value="<?= $ribsub['OAmountUnWithTax'] ?>" disabled>
|
|
</div>
|
|
|
|
<div class="col-md-3">
|
|
<label for="LAmountUnWithTax">本幣未稅報銷金額</label>
|
|
<input class="form-control" type="number" step="any" name="LAmountUnWithTax" id="LAmountUnWithTax" value="<?= $ribsub['LAmountUnWithTax'] ?>" disabled>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<label for="LAmount">本幣報銷金額</label>
|
|
<input class="form-control" type="number" step="any" name="LAmount" id="LAmount" value="<?= $ribsub['LAmount'] ?>" disabled>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
} ?>
|
|
|
|
<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" || $user_id == "M0209") { ?>
|
|
<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" onblur="checkInvoice()">
|
|
</div>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<div class="col-md-3" id="Tax">
|
|
<label for="TaxNo">供應商統一編號</label>
|
|
<input type="text" name="TaxNo" id="TaxNo" class="form-control" onblur="checkBiz()">
|
|
</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 = [];
|
|
var CurrId = "<?= $CurrId ?>";
|
|
$(document).ready(function() {
|
|
$("#ProjectId").selectize();
|
|
$("#CU_MaterialId").selectize();
|
|
})
|
|
|
|
function checkBiz() {
|
|
if ($("#TaxNo").val().length !== 8) {
|
|
alert("統一編號格式錯誤");
|
|
} else {
|
|
var biz = $("#TaxNo").val();
|
|
var BizArray = <?php echo $BizJSON; ?>;
|
|
var answer = 0;
|
|
for (var partner = 0; partner < <?= $bizcount ?>; partner++) {
|
|
var value = BizArray[partner];
|
|
if (biz == value) {
|
|
answer += 1
|
|
}
|
|
}
|
|
if (answer == 1) {
|
|
alert("供應商認證成功")
|
|
} else {
|
|
alert("T8內無此供應商")
|
|
}
|
|
}
|
|
|
|
}
|
|
$(function() {
|
|
$("#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() {
|
|
if (CurrId === "TWD") {
|
|
$("#OAmount").val(Math.round($("#Quantity").val() * $("#Price").val()));
|
|
$("#LAmount").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(Math.round($("#OAmount").val() - ($("#OAmount").val() / 1.05)));
|
|
$("#LTax").val(Math.round($("#OTax").val() * $("#CurrLAmount").val()));
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val() / 1.05));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val()));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
}
|
|
} else {
|
|
$("#OAmount").val(($("#Quantity").val() * $("#Price").val()).toFixed(2));
|
|
$("#LAmount").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(($("#OAmount").val() - ($("#OAmount").val() / 1.05)).toFixed(2));
|
|
$("#LTax").val(($("#OTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val() / 1.05).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val()).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
}
|
|
}
|
|
|
|
});
|
|
$("#Quantity").change(function() {
|
|
if (CurrId === "TWD") {
|
|
$("#OAmount").val(Math.round($("#Quantity").val() * $("#Price").val()));
|
|
$("#LAmount").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(Math.round($("#OAmount").val() - ($("#OAmount").val() / 1.05)));
|
|
$("#LTax").val(Math.round($("#OTax").val() * $("#CurrLAmount").val()));
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val() / 1.05));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val()));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
}
|
|
} else {
|
|
$("#OAmount").val(($("#Quantity").val() * $("#Price").val()).toFixed(2));
|
|
$("#LAmount").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(($("#OAmount").val() - ($("#OAmount").val() / 1.05)).toFixed(2));
|
|
$("#LTax").val(($("#OTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val() / 1.05).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val()).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
}
|
|
}
|
|
|
|
});
|
|
$("#TaxId").change(function() {
|
|
if (CurrId === "TWD") {
|
|
$("#OAmount").val(Math.round($("#Quantity").val() * $("#Price").val()));
|
|
$("#LAmount").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(Math.round($("#OAmount").val() - ($("#OAmount").val() / 1.05)));
|
|
$("#LTax").val(Math.round($("#OTax").val() * $("#CurrLAmount").val()));
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val() / 1.05));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(Math.round($("#OAmount").val()));
|
|
$("#LAmountUnWithTax").val(Math.round($("#OAmount").val() * $("#CurrLAmount").val()));
|
|
}
|
|
} else {
|
|
$("#OAmount").val(($("#Quantity").val() * $("#Price").val()).toFixed(2));
|
|
$("#LAmount").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
if ($("#TaxId").val() === "ST005") {
|
|
$("#OTax").val(($("#OAmount").val() - ($("#OAmount").val() / 1.05)).toFixed(2));
|
|
$("#LTax").val(($("#OTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val() / 1.05).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmountUnWithTax").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
|
|
} else {
|
|
$("#OTax").val(0);
|
|
$("#LTax").val(0);
|
|
$("#OAmountUnWithTax").val(($("#OAmount").val()).toFixed(2));
|
|
$("#LAmountUnWithTax").val(($("#OAmount").val() * $("#CurrLAmount").val()).toFixed(2));
|
|
}
|
|
}
|
|
|
|
})
|
|
$("#FeeDate").change(function() {
|
|
if ($("#FeeDate").val().length != 8) {
|
|
alert("輸入格式錯誤");
|
|
$("#FeeDate").val('');
|
|
} else {
|
|
let year = $("#FeeDate").val().substr(0, 4);
|
|
let month = parseInt($("#FeeDate").val().substr(4, 2)) - 1;
|
|
let day = $("#FeeDate").val().substr(6, 2);
|
|
let feedate = new Date(year, month, day);
|
|
let now = new Date();
|
|
if (feedate.getMonth() != month) {
|
|
alert("請輸入正確格式的日期");
|
|
} else {
|
|
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 checkInvoice(){
|
|
var invoiceArray = <?= $InvoiceJSON ?>;
|
|
if($.inArray($("#InvoiceNo").val(),invoiceArray) !== -1) {
|
|
alert("此發票已報銷過");
|
|
$("#InvoiceNo").val('');}
|
|
}
|
|
|
|
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() == "" || $("#WriteOffId").val() == "") {
|
|
alert("請確認紅字部分皆有填寫");
|
|
} else if ($("#OAmount").val() <= 0) {
|
|
alert("金額必須大於零");
|
|
|
|
} else {
|
|
$("#OAmount").prop("disabled", false);
|
|
<?php
|
|
if ($user_id == "M0056" || $user_id == "M0209") { ?>
|
|
$("#OTax").prop("disabled", false);
|
|
$("#LTax").prop("disabled", false);
|
|
$("#CurrLAmount").prop("disabled", false);
|
|
$("#OAmountUnWithTax").prop("disabled", false);
|
|
$("#LAmountUnWithTax").prop("disabled", false);
|
|
$("#LAmount").prop("disabled", false);
|
|
$("#OAmount").prop("disabled", false);
|
|
<?php } ?>
|
|
$('#ribsubform').submit();
|
|
}
|
|
|
|
}
|
|
</script>
|