suryee-stat/application/index/view/commission/input.php

<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()">
                    &times;
                </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>