| | |
| | | </div> |
| | | |
| | | <div class="form-group mr-20"> |
| | | <label>日期范围</label> |
| | | <input autocomplete="off" name="beginTime" type="text" class="form-control datetimepicker" id="beginTime">- |
| | | <input autocomplete="off" name="endTime" type="text" class="form-control datetimepicker" id="endTime"> |
| | | <label>日期</label> |
| | | <input autocomplete="off" name="beginTime" type="text" class="form-control datetimepicker" id="beginTime"> |
| | | <!-- <input autocomplete="off" name="endTime" type="text" class="form-control datetimepicker" id="endTime">--> |
| | | </div> |
| | | |
| | | </form> |
| | |
| | | <tr> |
| | | <th data-formatter="MGrid.indexfn" data-align="center" |
| | | data-width="30px" data-footer-formatter="footCountTitle">序号</th> |
| | | <th data-field="time">日期</th> |
| | | <th data-field="cashPay" data-footer-formatter="countColumn">收现金额</th> |
| | | <th data-field="cardPay" data-footer-formatter="countColumn">实收余额支付</th> |
| | | <th data-field="consumePay" data-footer-formatter="countColumn">消耗金额</th> |
| | | <th data-field="freeConsumePay" data-footer-formatter="countColumn">赠送消耗</th> |
| | | <th data-field="dataTime">日期</th> |
| | | <th data-field="cashPay" data-footer-formatter="countColumn">现金收款</th> |
| | | <th data-field="arrearsPay" data-footer-formatter="countColumn">欠款</th> |
| | | <th data-field="" data-footer-formatter="countColumn">还款</th> |
| | | <th data-field="productAchieve" data-footer-formatter="countColumn">产品业绩</th> |
| | | <th data-field="cardAchieve" data-footer-formatter="countColumn">卡项业绩</th> |
| | | <th data-field="refundCashPay" data-footer-formatter="countColumn">现金退款</th> |
| | | <th data-field="refundCardPay" data-footer-formatter="countColumn">卡项退款</th> |
| | | <th data-field="arrearsPay" data-footer-formatter="countColumn">欠款</th> |
| | | <th data-field="cardAmount" data-footer-formatter="countColumn">储值卡本金扣款</th> |
| | | <th data-field="cardFreeAmount" data-footer-formatter="countColumn">储值卡赠送扣款</th> |
| | | <th data-field="consumePay" data-footer-formatter="countColumn">本金消耗</th> |
| | | <th data-field="freeConsumePay" data-footer-formatter="countColumn">赠送消耗</th> |
| | | <th data-field="peopleCnt" data-footer-formatter="countColumn">人头数</th> |
| | | <th data-field="projConsumeCnt" data-footer-formatter="countColumn">项目消耗数</th> |
| | | <th data-field="timeLength" data-footer-formatter="countColumn">服务时长</th> |
| | | <th data-field="perCustomCnt" data-footer-formatter="countColumn">客单数</th> |
| | | <th data-field="customGoodsCnt" data-footer-formatter="countColumn">客品数</th> |
| | | <th data-field="perCustomPrice" data-footer-formatter="countColumn">客单价</th> |
| | | <th data-field="cost" data-footer-formatter="countColumn">成本</th> |
| | | <th data-field="grossProfit" data-footer-formatter="countColumn">毛利</th> |
| | | <th data-field="grossProfitRate" data-footer-formatter="countColumn">毛利率</th> |
| | | </tr> |
| | | </thead> |
| | | </table> |
| | |
| | | $(function() { |
| | | MTools.autoFullSelect(); |
| | | myGrid = MGrid.initGrid({ |
| | | url : basePath+"/admin/sysBusinessData/showList", |
| | | url : basePath+"/admin/sysBusinessData/findShopBusinessesData", |
| | | showExport : true, |
| | | showFooter : true, |
| | | height:'', |
| | |
| | | return "<b>合计</b>"; |
| | | }; |
| | | function countColumn(data) { |
| | | console.log(data) |
| | | field = this.field; |
| | | var resultsumQuantity = parseFloat((data.reduce(function(sum, row) { |
| | | console.log(sum,row[field]); |
| | | return sum + (+row[field]); |
| | | }, 0)).toFixed(2));//保留有效数字 |
| | | return "<b>"+resultsumQuantity+"</b>"; |