|  |  |  | 
|---|
|  |  |  | </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>"; | 
|---|