|
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog" style="width:800px">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" aria-hidden="true" onclick="cel()">
×
</button>
<button type="button" class="btn btn-default btn-sm" aria-hidden="true" onclick="updatecahce()" style="float:right;margin-right: 30px;">
刷新
</button>
<h4 class="modal-title" id="myModalLabel">
数据录入
</h4>
</div>
<div class="modal-body">
<form role="form" id="market-form">
<input type="hidden" name="id" id="id" value="0">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">计提月份</label>
<select name="month" id="month" class="form-control">
<?php
foreach ($maonth_picker->monarr as $value) {
if ($maonth_picker->cur_month == $value) {
echo "<option value='$value' selected>$value</option>";
} else {
echo "<option value='$value'>$value</option>";
}
}
?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">公司名称</label>
<select class="selectpicker form-control" data-live-search="true" name="company" id="company">
<option value="">公司名称</option>
<?php
foreach ($data_company as $company) {
?>
<option value="<?php echo $company['name'] ?>"><?php echo $company['name'] ?></option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label for="name">请选择要录入的数据</label>
<select class="form-control" name="conpany_sales_data" id="conpany_sales_data">
<option value="">请选择合同号</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">合同号</label>
<input type="text" class="form-control" name="contract_no" id="contract_no" placeholder="合同号">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">产品类别</label>
<input type="text" class="form-control" name="goods_category" id="goods_category" placeholder="产品类别">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">产品型号</label>
<input type="text" class="form-control" name="goods_type" id="goods_type" placeholder="产品型号">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">数量(KG)</label>
<input type="number" class="form-control val_change" name="amount" id="amount" placeholder="数量">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">单价</label>
<input type="number" class="form-control val_change" name="price" id="price" placeholder="单价">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">合同额</label>
<input type="number" class="form-control" name="contract_value" id="contract_value" placeholder="合同额">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">代理费</label>
<input type="number" class="form-control val_change" name="agency" id="agency" placeholder="代理费">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">运费</label>
<input type="number" class="form-control val_change" name="shipping" id="shipping" placeholder="运费">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">收款金额</label>
<input type="number" class="form-control val_change" name="receive_money" id="receive_money" placeholder="收款金额">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">上期余额</label>
<input type="number" class="form-control" name="period_balance" id="period_balance" placeholder="上期余额" disabled>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">实收金额</label>
<input type="number" class="form-control" name="actual_money" id="actual_money" placeholder="实收金额" disabled="true">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">本期结余</label>
<input type="number" class="form-control" name="current_balance" id="current_balance" placeholder="本期结余" disabled="true">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">提成类型</label>
<label class="radio-inline">
<input type="radio" name="type" id="type0" value="0" checked="checked" onclick="tcType(0)"> 一般
</label>
<label class="radio-inline">
<input type="radio" name="type" id="type1" value="1" onclick="tcType(1)"> 特批1
</label>
<label class="radio-inline">
<input type="radio" name="type" id="type2" value="2" onclick="tcType(2)"> 特批2
</label>
</div>
</div>
</div>
<div id="yiban" class="active bj">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">基准单价</label>
<input type="number" class="form-control val_change" name="base_price" id="base_price" placeholder="基准单价">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">合同基准价</label>
<input type="number" class="form-control" name="base_value" id="base_value" placeholder="合同基准价" disabled="true">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">工程费成本</label>
<input type="number" class="form-control val_change" name="project" id="project" placeholder="工程费成本">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">总利润</label>
<input type="number" class="form-control" name="total_profit" id="total_profit" placeholder="总利润" disabled="true">
</div>
</div>
</div>
</div>
<div id="tepi" class="bj">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">公司低价</label>
<input type="number" class="form-control val_change" name="base_price2" id="base_price2" placeholder="基准单价">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">实际合同额</label>
<input type="number" class="form-control" name="actual_value" id="actual_value" placeholder="实际合同额">
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label for="name">价格比例</label>
<input type="number" class="form-control" name="price_rate" id="price_rate" placeholder="价格比例" disabled="true">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="name">提成比例</label>
<input type="number" class="form-control" name="commission_rate" id="commission_rate" placeholder="提成比例" disabled="true">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="name">提成额</label>
<input type="number" class="form-control" name="commission_money" id="commission_money" placeholder="提成额" disabled="true">
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="name">销售员</label>
<input type="text" class="form-control" name="seller" id="seller" placeholder="销售员">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="name">备注</label>
<input type="text" class="form-control" name="remark" id="remark" placeholder="备注">
</div>
</div>
</div>
<div class="row">
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" onclick="cel()">关闭
</button>
<button type="button" class="btn btn-primary" id="tj">
提交
</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal -->
</div>
<script>
var dataForm = {
"id": 0,
"month": "",
"company": "",
"contract_no": "",
"goods_category": "",
"goods_type": "",
"amount": 0,
"price": 0,
"contract_value": 0,
"receive_money": 0,
"period_balance": 0,
"agency": 0,
"base_price": 0,
"shipping": 0,
"project": 0,
"type": 0,
"seller": "",
"remark": ""
};
// 销售数据
var salesData = getSalesData()
// console.log(salesData)
// 公司名称下的合同数据
var conpanySalesData = [];
// (从缓存读取)
function getSalesData() {
salesData = JSON.parse(window.localStorage.getItem('salesData'));
return salesData;
}
// 根据公司名选择数据条
function getContractNoByCompany(company) {
conpanySalesData = []; // 清空数组
var option = {};
for (i=1; i < salesData.length; i++) {
row = salesData[i];
if (row[3] == company) {
option.contract_no = row[12];
option.goods_category = row[6];
option.goods_type = row[7];
option.amount = row[8];
option.price = row[10];
option.contract_value = row[11];
option.seller = row[13];
option.shipping = row[15];
conpanySalesData.push(option);
option = {};
}
}
}
// 更新公司下的数据list
function updateCompanySalesData() {
let str = '<option value="">请选择合同数据</option>';
conpanySalesData.forEach((e, i) => {
// console.log(e);
str += '<option value="' + i + '">' + e.contract_no +','+e.goods_category+','+ e.goods_type+','+ e.amount+','+ e.price+','+ e.contract_value+'</option>';
});
$('#conpany_sales_data').html(str)
}
// update 上期结余
function updatePeriodBalance() {
$.post('/index/commission/perbalance', {
'company': dataForm.company
}, function(res) {
if (res.code == 0) {
dataForm.period_balance = res.data;
$("#period_balance").val(dataForm.period_balance)
}
}, 'json')
}
$("#company").change(function() {
dataForm.company = $(this).val();
getContractNoByCompany(dataForm.company);
updateCompanySalesData();
updatePeriodBalance();
})
$('#conpany_sales_data').change(function(){
// 销售表读取的数据
var i = $('#conpany_sales_data').val();
var data = conpanySalesData[i];
dataForm.contract_no = data.contract_no;
dataForm.goods_category = data.goods_category;
dataForm.goods_type = data.goods_type;
dataForm.amount = data.amount;
dataForm.price = data.price;
dataForm.seller = data.seller;
dataForm.shipping = data.shipping;
if (data.contract_value.indexOf('(') != -1) {
var contract_value = ltrim(data.contract_value, '(');
contract_value = rtrim(contract_value, ')');
dataForm.contract_value = Number(-contract_value);
} else {
dataForm.contract_value = Number(data.contract_value);
}
$("#contract_no").val(dataForm.contract_no)
$("#goods_category").val(dataForm.goods_category)
$("#goods_type").val(dataForm.goods_type)
$("#amount").val(Number(dataForm.amount))
$("#price").val(Number(dataForm.price))
if (dataForm.contract_value<0) {
$("#contract_value").css('color', 'red');
}
$("#contract_value").val(dataForm.contract_value);
$("#seller").val(dataForm.seller)
$("#shipping").val(Number(dataForm.shipping))
})
// 更新dataFrom
function updateDataFrom() {
dataForm.shipping = Number($("#shipping").val());
// 更新实收金额
var receive_money = Number($("#receive_money").val());
dataForm.receive_money = receive_money;
dataForm.actual_money = receive_money + dataForm.period_balance;
$("#actual_money").val(dataForm.actual_money) ;
// 本期结余
dataForm.current_balance = dataForm.actual_money - dataForm.contract_value;
$("#current_balance").val(dataForm.current_balance);
}
$(".val_change").change(function() {
updateDataFrom();
updateBaseValue();
updateTotalProfit();
updateTepi();
})
// 合同基准价
function updateBaseValue() {
var amount = $("#amount").val();
var base_price = $("#base_price").val();
$("#base_value").val(amount * base_price);
}
// 总利润
function updateTotalProfit() {
var contract_value = Number($("#contract_value").val());
var agency = Number($("#agency").val());
var base_value = Number($("#base_value").val());
var shipping = Number($("#shipping").val());
var total_profit = contract_value - agency - base_value - shipping;
$("#total_profit").val(total_profit);
}
//价格比例 & 提成比例 特批
function updateTepi() {
var base_price = Number($("#base_price2").val());
if (dataForm.type != 0) {
dataForm.base_price = base_price;
var price = $("#price").val();
var price_rate = price / base_price;
$("#price_rate").val(price_rate);
var contract_value = Number($("#contract_value").val());
var agency = Number($("#agency").val());
var actual_value = contract_value - agency;
$("#actual_value").val(actual_value);
var shipping = Number($("#shipping").val());
if (dataForm.type == 1) {
if (price_rate < 1.05) {
dataForm.commission_rate = 0.01;
} else if (price_rate < 1.1) {
dataForm.commission_rate = 0.015;
} else {
dataForm.commission_rate = 0.02;
}
} else {
dataForm.commission_rate = Math.floor((((price_rate - 1) / 0.1) * 0.01 + 0.01) * 100) / 100;
// console.log(dataForm.commission_rate)
}
$("#commission_rate").val(dataForm.commission_rate);
var commission_money = ((actual_value - shipping) * dataForm.commission_rate).toFixed(2);
$("#commission_money").val(commission_money);
}
}
function tcType(bj) {
dataForm.type = bj;
if (bj != 0) {
$('#yiban').removeClass('active');
$('#tepi').addClass('active');
} else {
$('#tepi').removeClass('active');
$('#yiban').addClass('active');
}
}
function updatecahce() {
window.location.href = "/index/index/index";
}
function cel() {
$('#myModal').modal('hide');
$("#market-form")[0].reset();
$('#company').selectpicker('deselectAll');
}
$("#tj").click(function() {
// dataForm.id = $("#id").val();
// dataForm.month = $("#month").val();
// dataForm.company = $("#company").val();
// dataForm.contract_no = $("#contract_no").val();
// dataForm.goods_category = $("#goods_category").val();
// dataForm.goods_type = $("#goods_type").val();
// dataForm.amount = $("#amount").val();
// dataForm.price = $("#price").val();
// dataForm.contract_value = $("#contract_value").val();
// dataForm.receive_money = $("#receive_money").val();
// dataForm.period_balance = $("#period_balance").val();
// dataForm.actual_money = $("#actual_money").val();
// dataForm.agency = $("#agency").val();
// dataForm.base_price = $("#base_price").val();
// dataForm.base_value = $("#base_value").val();
// dataForm.shipping = $("#shipping").val();
// dataForm.project = $("#project").val();
// dataForm.current_balance = $("#current_balance").val();
// dataForm.total_profit = $("#total_profit").val();
// dataForm.seller = $("#seller").val();
// dataForm.remark = $("#remark").val();
// var data = $("#market-form").serializeArray();
type = $('input[name="type"]:checked').val();
if (type != 0) {
base_price = Number($('#base_price2').val());
} else {
base_price = Number($('#base_price').val());
}
// console.log(type)
// console.log(base_price)
var data = {
'id': $('#id').val(),
'month': $('#month').val(),
'company': $('#company').val(),
'contract_no': $('#contract_no').val(),
'goods_category': $('#goods_category').val(),
'goods_type': $('#goods_type').val(),
'amount': $('#amount').val(),
'price': $('#price').val(),
'contract_value': $('#amount').val() * $('#price').val(),
'receive_money': $('#receive_money').val(),
'period_balance': $('#period_balance').val(),
'agency': $('#agency').val(),
'base_price': base_price,
'shipping': Number($('#shipping').val()),
'project': Number($('#project').val()),
'type': type,
'seller': $('#seller').val()
}
$.ajax({
url: "/domarket.php?action=save",
type: "POST",
data: data,
dataType: 'json',
success: function(res) {
if (res.code == 0) {
dataForm.id = 0;
$('#id').val(0)
$('#myModal').modal('hide');
$("#market-form")[0].reset();
window.location.reload();
} else {
alert(res.msg);
}
return false;
}
});
});
</script>
|