crm/app/sys/view/statistics/manage_statistics.html

{extend name="public/layout" /} {block name="title"}管理层统计{/block} {block
name="head"} {include file="public/head"}
<style>
  html,
  body {
    min-width: 1100px;
  }

  .layui-table th:last-child {
    border-right: none;
  }

  .layui-table-view .layui-table {
    /* width:100% */
  }

  .layui-table thead tr,
  .layui-table-header {
    background-color: #d8e6f1 !important;
  }

  .line-middle {
    width: 10px;
    height: 100%;
    margin: 0px 10px;
  }

  .line {
    width: 10px;
    height: 2px;
    background-color: #999999;
  }

  .mb0 {
    margin-bottom: 0px;
  }

  .layui-btn {
    background-color: #fff;
    color: #555;
    border: 1px solid #c9c9c9;
  }

  .layui-btn:hover {
    background-color: #fff;
    color: #555;
    border: 1px solid #249efb;
  }

  .layui-btn-primary,
  .sBtn {
    background-color: #249efb;
    color: #fff;
    border: 1px solid #249efb;
  }

  .layui-btn-primary:hover {
    background-color: #249efb;
    color: #fff;
    border: 1px solid #249efb;
  }

  .sBtn:hover {
    background-color: #249efb;
    color: #fff;
    border: 1px solid #249efb;
  }

  .flex-row,
  .row {
    display: flex;
  }

  .align-center {
    align-items: center;
  }

  .ml10 {
    margin-left: 10px;
  }

  .mt10 {
    margin-top: 10px;
  }

  .padding-tlr {
    padding: 15px 15px 0px;
  }

  .layui-input-block {
    margin-left: 0px;
  }

  .justify-between {
    justify-content: space-between;
  }

  table tr td a {
    color: #249efb;
  }

  .qdtj_m {
    padding: 0 15px;
    width: 100%;
    box-sizing: border-box;
    margin: 20px 0 10px;
  }

  .qdtj_ul {
    overflow: hidden;
    border: 1px solid #94d0ff;
    padding: 15px 0;
    background-color: #fbfdff;
  }

  .qdtj_ul li {
    float: left;
    position: relative;
    text-align: center;
    width: 10%;
  }

  .qdtj_1 {
    font-size: 20px;
    font-weight: 400;
  }

  .qdtj_2 {
    font-size: 14px;
    color: #888;
    margin-top: 5px;
  }

  .qdtj_r_x {
    height: 40px;
    width: 1px;
    background: #d8d8d9;
    position: absolute;
    right: 0;
    top: 50%;
    margin-top: -20px;
  }

  .layui-card-body .layui-table-body {
    overflow-y: auto !important;
    height: 75vh;
  }

  .layui-table td,
  .layui-table th,
  .layui-table-col-set,
  .layui-table-fixed-r,
  .layui-table-grid-down,
  .layui-table-header,
  .layui-table-page,
  .layui-table-tips-main,
  .layui-table-tool,
  .layui-table-total,
  .layui-table-view,
  .layui-table[lay-skin="line"],
  .layui-table[lay-skin="row"] {
    border-color: #ccc !important;
  }

  .layui-table-fixed-r .layui-table-body {
    overflow: hidden !important;
  }

  .relative {
    position: relative;
  }

  .lay-setting {
    position: absolute;
    right: 40px;
    top: 38px;
    z-index: 999 !important;
    cursor: pointer;
  }

  .selectDateBox {
    position: absolute;
    width: 330px;
    height: 100px;
    box-shadow: 0 2px 4px rgb(0 0 0 / 12%);
    background-color: #fff;
    z-index: 99999 !important;
    top: 45px;
    box-sizing: border-box;
    padding: 5px 8px;
  }

  .selecstDateBox {
    position: absolute;
    width: 330px;
    height: 100px;
    box-shadow: 0 2px 4px rgb(0 0 0 / 12%);
    background-color: #fff;
    z-index: 99999 !important;
    top: 45px;
    right: 0;
    box-sizing: border-box;
    padding: 5px 8px;
  }

  .date-flex,
  .date-flex1 {
    display: flex;
    align-items: center;
  }

  .date-box {
    padding: 15px 0px 10px;
  }

  #rangeDepart {
    width: 260px;
    height: 38px;
  }

  xm-select>.xm-body {
    z-index: 99999 !important;
  }
</style>
{/block} {block name="body"}
<div class="layui-fluid" style="background-color: #fff">
  <div class="layui-card">
    <div class="search-form layui-form padding-tlr">
      <div class="flex-row align-center justify-between">
        <div class="flex-row align-center">
          <div class="layui-input-block" style="margin-right: 10px">
            <button class="layui-btn ml10" id="tablebtn">导出</button>
          </div>
          <div class="layui-input-block" style="line-height:36px;">
            <a href="javascript:void(0)" id="manager-export-list" style="color:#249efb;">查看</a>
          </div>
        </div>
        <div class="flex-row align-center">
          <div class="layui-input-block">
            <input type="text" class="layui-input" id="keyword" autocomplete="off" name="keyword"
              placeholder="请输入员工名称" />
          </div>
          <div class="layui-input-inline layui-form ml10">
            <div id="rangeDepart"></div>
          </div>

          <div class="layui-input-inline layui-form ml10" style="display: inline-block;width:200px;">
            <!-- <label class="layui-form-label" style="width: 60px;">跟进时间</label> -->
            <div class="layui-input-inline select-date relative">
              <!-- 注意：这一层元素并不是必须的 -->
              <input type="text" class="layui-input" id="sDate" name="start_date" placeholder="开始日期 - 结束日期"
                autocomplete="off" />
              <div data-type="" class="selecstDateBox layui-hide">
                <div data-type="" class="date-flex1">
                  <div data-type="today" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    今日
                  </div>
                  <div data-type="yesterday" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    昨日
                  </div>
                  <div data-type="week" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    本周
                  </div>
                  <div data-type="lastWeek" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    上周
                  </div>
                  <div data-type="month" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    本月
                  </div>
                  <div data-type="lastMonth" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    上月
                  </div>
                  <div data-type="all" class="layui-btn layui-btn-primary layui-border-blue layui-btn-xs">
                    累计
                  </div>
                </div>
                <div data-type="" class="date-box">
                  <input data-type="" type="text" id="select_sDate" placeholder="选择开始时间 - 结束时间" readonly
                    autocomplete="off" class="layui-input" />
                </div>
              </div>
            </div>
          </div>
          <button class="layui-btn sBtn ml10 submitbtn" lay-submit lay-filter="table-search">
            筛选
          </button>
          <button class="layui-btn sBtn ml10" id="resetbtn">重置</button>
        </div>
      </div>
    </div>
    <div class="layui-card-body relative">
      <i class="layui-icon layui-icon-set-fill lay-setting"></i>
      <table lay-filter="datalist" id="list"></table>
    </div>
  </div>
</div>
{/block} {block name="js"}
<script src="__STATIC__/layui/layui/lay/modules/xm-select.js" type="text/javascript" charset="utf-8"></script>
<script type="text/html" id="dep">
  {{# if(d.dep){ }}
  <a href="javascript:void(0)" lay-event="dep" style="color:blue;">{{d.dep}}</a>
  {{# }else{ }}
  <span>{{d.dep}}</span>
  {{# } }}
</script>
<script type="text/html" id="existing_homes_count">
  {{# if(d.existing_homes_count){ }}
  <a
    href="javascript:void(0)"
    lay-event="existing_homes_count"
    style="color:blue;"
    >{{d.existing_homes_count}}</a
  >
  {{# }else{ }}
  <span>{{d.existing_homes_count}}</span>
  {{# } }}
</script>
<script type="text/html" id="forward_housing_count">
  {{# if(d.forward_housing_count){ }}
  <a
    href="javascript:void(0)"
    lay-event="forward_housing_count"
    style="color:blue;"
    >{{d.forward_housing_count}}</a
  >
  {{# }else{ }}
  <span>{{d.forward_housing_count}}</span>
  {{# } }}
</script>

<script type="text/html" id="square_0_80">
  {{# if(d.square_0_80){ }}
  <a href="javascript:void(0)" lay-event="square_0_80" style="color:blue;"
    >{{d.square_0_80}}</a
  >
  {{# }else{ }}
  <span>{{d.square_0_80}}</span>
  {{# } }}
</script>
<script type="text/html" id="square_80_100">
  {{# if(d.square_80_100){ }}
  <a href="javascript:void(0)" lay-event="square_80_100" style="color:blue;"
    >{{d.square_80_100}}</a
  >
  {{# }else{ }}
  <span>{{d.square_80_100}}</span>
  {{# } }}
</script>
<script type="text/html" id="square_100_120">
  {{# if(d.square_100_120){ }}
  <a href="javascript:void(0)" lay-event="square_100_120" style="color:blue;"
    >{{d.square_100_120}}</a
  >
  {{# }else{ }}
  <span>{{d.square_100_120}}</span>
  {{# } }}
</script>
<script type="text/html" id="square_120_200">
  {{# if(d.square_120_200){ }}
  <a href="javascript:void(0)" lay-event="square_120_200" style="color:blue;"
    >{{d.square_120_200}}</a
  >
  {{# }else{ }}
  <span>{{d.square_120_200}}</span>
  {{# } }}
</script>
<script type="text/html" id="square_200_500">
  {{# if(d.square_200_500){ }}
  <a href="javascript:void(0)" lay-event="square_200_500" style="color:blue;"
    >{{d.square_200_500}}</a
  >
  {{# }else{ }}
  <span>{{d.square_200_500}}</span>
  {{# } }}
</script>
<script type="text/html" id="square_500">
  {{# if(d.square_500){ }}
  <a href="javascript:void(0)" lay-event="square_500" style="color:blue;"
    >{{d.square_500}}</a
  >
  {{# }else{ }}
  <span>{{d.square_500}}</span>
  {{# } }}
</script>

<script type="text/html" id="drawing_date">
  {{# if(d.drawing_date){ }}
  <a href="javascript:void(0)" lay-event="drawing_date" style="color:blue;"
    >{{d.drawing_date}}</a
  >
  {{# }else{ }}
  <span>{{d.drawing_date}}</span>
  {{# } }}
</script>
<script type="text/html" id="sign_count">
  {{# if(d.sign_count){ }}
  <a href="javascript:void(0)" lay-event="sign_count" style="color:blue;"
    >{{d.sign_count}}</a
  >
  {{# }else{ }}
  <span>{{d.sign_count}}</span>
  {{# } }}
</script>
<script type="text/html" id="store1_dep">
  {{# if(d.store1_dep){ }}
  <a href="javascript:void(0)" lay-event="store1_dep" style="color:blue;"
    >{{d.store1_dep}}</a
  >
  {{# }else{ }}
  <span>{{d.store1_dep}}</span>
  {{# } }}
</script>

<script type="text/html" id="store2_dep">
  {{# if(d.store2_dep){ }}
  <a href="javascript:void(0)" lay-event="store2_dep" style="color:blue;"
    >{{d.store2_dep}}</a
  >
  {{# }else{ }}
  <span>{{d.store2_dep}}</span>
  {{# } }}
</script>
<script type="text/html" id="store3_dep">
  {{# if(d.store3_dep){ }}
  <a href="javascript:void(0)" lay-event="store3_dep" style="color:blue;"
    >{{d.store3_dep}}</a
  >
  {{# }else{ }}
  <span>{{d.store3_dep}}</span>
  {{# } }}
</script>
<script type="text/html" id="store1">
  {{# if(d.store1){ }}
  <a href="javascript:void(0)" lay-event="store1" style="color:blue;"
    >{{d.store1}}</a
  >
  {{# }else{ }}
  <span>{{d.store1}}</span>
  {{# } }}
</script>

<script type="text/html" id="store2">
  {{# if(d.store2){ }}
  <a href="javascript:void(0)" lay-event="store2" style="color:blue;"
    >{{d.store2}}</a
  >
  {{# }else{ }}
  <span>{{d.store2}}</span>
  {{# } }}
</script>
<script type="text/html" id="store3">
  {{# if(d.store3){ }}
  <a href="javascript:void(0)" lay-event="store3" style="color:blue;"
    >{{d.store3}}</a
  >
  {{# }else{ }}
  <span>{{d.store3}}</span>
  {{# } }}
</script>
<script type="text/html" id="room">
  {{# if(d.room){ }}
  <a href="javascript:void(0)" lay-event="room" style="color:blue;"
    >{{d.room}}</a
  >
  {{# }else{ }}
  <span>{{d.room}}</span>
  {{# } }}
</script>
<script type="text/html" id="add_wechat_count">
  {{# if(d.add_wechat_count){ }}
  <a href="javascript:void(0)" lay-event="add_wechat_count" style="color:blue;"
    >{{d.add_wechat_count}}</a
  >
  {{# }else{ }}
  <span>{{d.add_wechat_count}}</span>
  {{# } }}
</script>
<script type="text/html" id="valid_count">
  {{# if(d.valid_count){ }}
  <a href="javascript:void(0)" lay-event="valid_count" style="color:blue;"
    >{{d.valid_count}}</a
  >
  {{# }else{ }}
  <span>{{d.valid_count}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_visit_3">
  {{# if(d.no_visit_3){ }}
  <a href="javascript:void(0)" lay-event="no_visit_3" style="color:blue;"
    >{{d.no_visit_3}}</a
  >
  {{# }else{ }}
  <span>{{d.no_visit_3}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_visit_7">
  {{# if(d.no_visit_7){ }}
  <a href="javascript:void(0)" lay-event="no_visit_7" style="color:blue;"
    >{{d.no_visit_7}}</a
  >
  {{# }else{ }}
  <span>{{d.no_visit_7}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_visit_15">
  {{# if(d.no_visit_15){ }}
  <a href="javascript:void(0)" lay-event="no_visit_15" style="color:blue;"
    >{{d.no_visit_15}}</a
  >
  {{# }else{ }}
  <span>{{d.no_visit_15}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_visit_30">
  {{# if(d.no_visit_30){ }}
  <a href="javascript:void(0)" lay-event="no_visit_30" style="color:blue;"
    >{{d.no_visit_30}}</a
  >
  {{# }else{ }}
  <span>{{d.no_visit_30}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_visit_31">
  {{# if(d.no_visit_31){ }}
  <a href="javascript:void(0)" lay-event="no_visit_31" style="color:blue;"
    >{{d.no_visit_31}}</a
  >
  {{# }else{ }}
  <span>{{d.no_visit_31}}</span>
  {{# } }}
</script>
<script type="text/html" id="return_visit_count">
  {{# if(d.return_visit_count){ }}
  <a
    href="javascript:void(0)"
    lay-event="return_visit_count"
    style="color:blue;"
    >{{d.return_visit_count}}</a
  >
  {{# }else{ }}
  <span>{{d.return_visit_count}}</span>
  {{# } }}
</script>
<script type="text/html" id="no_assigned_personnel">
  {{# if(d.no_assigned_personnel){ }}
  <a
    href="javascript:void(0)"
    lay-event="no_assigned_personnel"
    style="color:blue;"
    >{{d.no_assigned_personnel}}</a
  >
  {{# }else{ }}
  <span>{{d.no_assigned_personnel}}</span>
  {{# } }}
</script>
<script>
  layui.use(["table", "form", "laydate", "element"], function () {
    let table = layui.table,
      laydate = layui.laydate,
      form = layui.form,
      element = layui.element,
      $ = layui.$,
      tableData = [];
    $("body").attr("layadmin-themealias", "default");
    var bodyH = $(".body-h").height() * 0.82;
    var istypes = 0;
    document.onkeydown = function (event) {
      var e = event || window.event || arguments.callee.caller.arguments[0];
      if (e && e.keyCode == 13) {
        $(".submitbtn").trigger("click");
      }
    };
    //执行一个laydate实例
    // laydate.render({
    //     elem: '#sDate' //指定元素
    // });
    // laydate.render({
    //     elem: '#eDate' //指定元素
    // });

    $("#addWechatTime").click(function () {
      $(".selectDateBox").toggleClass("layui-hide");
      $(".selecstDateBox").addClass("layui-hide");
    });
    $("#sDate").click(function () {
      $(".selecstDateBox").toggleClass("layui-hide");
      $(".selectDateBox").addClass("layui-hide");
    });
    laydate.render({
      elem: "#select_date",
      type: "date",
      range: true,
      format: "yyyy/MM/dd",
      trigger: "click", //呼出事件改成click
      done: function (value, date, endDate) {
        $(".selectDateBox").addClass("layui-hide");
        $("#addWechatTime").val(value);
      },
    });
    laydate.render({
      elem: "#select_sDate", //指定元素
      type: "date",
      format: "yyyy/MM/dd",
      range: true,
      trigger: "click", //呼出事件改成click
      done: function (value, date, endDate) {
        $(".selecstDateBox").addClass("layui-hide");
        $("#sDate").val(value);
      },
    });
    var dateObj = {};
    setDate();
    function setDate() {
      let date = new Date();
      let year = date.getFullYear();
      let month = date.getMonth() + 1;
      let day = date.getDate();
      let lastDate = new Date(new Date().getTime() - 1 * 24 * 60 * 60 * 1000);
      let lastYear = lastDate.getFullYear();
      let lastMonth = lastDate.getMonth() + 1;
      let lastDay = lastDate.getDate();

      let weekObj = getMondayAndSunday();
      let monthObj = getMonthFirstDayAndLastDay();
      dateObj = {
        today: `${year}/${month}/${day}`,
        yesterday: `${lastYear}/${lastMonth}/${lastDay}`,
        ...weekObj,
        ...monthObj,
      };
    }


    var departTree = xmSelect.render({
      el: "#rangeDepart",
      name: 'org_id',
      autoRow: true,
      filterable: true,
      tips: '请选择',
      radio: true,
      tree: {
        show: true,
        showFolderIcon: true,
        showLine: true,
        indent: 20,
        expandedKeys: [-3],
        //是否严格遵守父子模式
        strict: false,
      },
      height: "200px",
      data: [],
      //文本显示模式
      //处理方式
    });

    $.ajax({
      url: '{:url("statistics/get_person")}',
      type: "post",
      data: {},
      success: function (res) {
        departTree.update({ data: res })
      }
    })


    $(".date-flex div").click(function () {
      let type = $(this).prop("dataset").type;
      if (type == "today") {
        $("#select_date").val(`${dateObj.today} - ${dateObj.today}`);
        $("#addWechatTime").val(`${dateObj.today} - ${dateObj.today}`);
      } else if (type == "yesterday") {
        $("#select_date").val(`${dateObj.yesterday} - ${dateObj.yesterday}`);
        $("#addWechatTime").val(`${dateObj.yesterday} - ${dateObj.yesterday}`);
      } else if (type == "week") {
        $("#select_date").val(
          `${dateObj.thisWeekMonday} - ${dateObj.thisWeekSunday}`
        );
        $("#addWechatTime").val(
          `${dateObj.thisWeekMonday} - ${dateObj.thisWeekSunday}`
        );
      } else if (type == "lastWeek") {
        $("#select_date").val(
          `${dateObj.lastWeekMonday} - ${dateObj.lastWeekSunday}`
        );
        $("#addWechatTime").val(
          `${dateObj.lastWeekMonday} - ${dateObj.lastWeekSunday}`
        );
      } else if (type == "month") {
        $("#select_date").val(
          `${dateObj.thisMonthFirstDay} - ${dateObj.thisMonthLastDay}`
        );
        $("#addWechatTime").val(
          `${dateObj.thisMonthFirstDay} - ${dateObj.thisMonthLastDay}`
        );
      } else if (type == "lastMonth") {
        $("#select_date").val(
          `${dateObj.lastMonthFirstDay} - ${dateObj.lastMonthLastDay}`
        );
        $("#addWechatTime").val(
          `${dateObj.lastMonthFirstDay} - ${dateObj.lastMonthLastDay}`
        );
      } else {
        $("#select_date").val("");
        $("#sDate").val("");
        $("#addWechatTime").val("");
      }
      $(".selectDateBox").addClass("layui-hide");
    });

    $(".date-flex1 div").click(function () {
      let type = $(this).prop("dataset").type;
      if (type == "today") {
        itmesss = dateToYYYYMMDD(dateObj.today);
        itmesss2 = dateToYYYYMMDD(dateObj.today);
        $('#select_sDate').val(itmesss + ' - ' + itmesss2);
        $('#sDate').val(itmesss + ' - ' + itmesss2);
      } else if (type == "yesterday") {
        itmesss = dateToYYYYMMDD(dateObj.yesterday);
        itmesss2 = dateToYYYYMMDD(dateObj.yesterday);
        $('#select_sDate').val(itmesss + ' - ' + itmesss2);
        $('#sDate').val(itmesss + ' - ' + itmesss2);
      } else if (type == "week") {
        $("#select_sDate").val(
          `${dateObj.thisWeekMonday} - ${dateObj.thisWeekSunday}`
        );
        $("#sDate").val(
          `${dateObj.thisWeekMonday} - ${dateObj.thisWeekSunday}`
        );
      } else if (type == "lastWeek") {
        $("#select_sDate").val(
          `${dateObj.lastWeekMonday} - ${dateObj.lastWeekSunday}`
        );
        $("#sDate").val(
          `${dateObj.lastWeekMonday} - ${dateObj.lastWeekSunday}`
        );
      } else if (type == "month") {
        $("#select_sDate").val(
          `${dateObj.thisMonthFirstDay} - ${dateObj.thisMonthLastDay}`
        );
        $("#sDate").val(
          `${dateObj.thisMonthFirstDay} - ${dateObj.thisMonthLastDay}`
        );
      } else if (type == "lastMonth") {
        $("#select_sDate").val(
          `${dateObj.lastMonthFirstDay} - ${dateObj.lastMonthLastDay}`
        );
        $("#sDate").val(
          `${dateObj.lastMonthFirstDay} - ${dateObj.lastMonthLastDay}`
        );
      } else {
        $("#select_sDate").val("");
        $("#sDate").val("");
      }
      $(".selecstDateBox").addClass("layui-hide");
    });

    function getMondayAndSunday() {
      var today = new Date();

      //构建当前日期,格式：2022-08-22 00:00:00
      var year = today.getFullYear(); //本年
      var month = today.getMonth() + 1; //本月
      var day = today.getDate(); //本日
      var newDate = new Date(year + "/" + month + "/" + day + " 00:00:00"); //年月日拼接

      var nowTime = newDate.getTime(); //当前的时间戳
      var weekDay = newDate.getDay(); //当前星期 0.1.2.3.4.5.6 【0 = 周日】

      var oneDayTime = 24 * 60 * 60 * 1000; //一天的总ms

      // 当前星期减去天数，如今天为周五，则本周一为周五的时间戳减去4天的时间戳。但周日特殊，周一至周六是周几的到的weekDay就是几，但是周日的到的为0，需特殊处理
      var thisWeekMondayTime = (1 - weekDay) * oneDayTime + nowTime; //本周一的时间戳
      if (weekDay == 0) {
        // weekDay = 0 为周日，此时本周一时间为周日减去6天的时间
        thisWeekMondayTime = nowTime - 6 * oneDayTime;
      }

      var thisWeekSundayTime = thisWeekMondayTime + 6 * 24 * 60 * 60 * 1000; // 本周日

      var lastWeekMondayTime = thisWeekMondayTime - 7 * oneDayTime; // 上周一
      var lastWeekSundayTime = thisWeekMondayTime - oneDayTime; // 上周日

      var res = {
        thisWeekMonday: dateToYYYYMMDD(thisWeekMondayTime),
        thisWeekSunday: dateToYYYYMMDD(thisWeekSundayTime),
        lastWeekMonday: dateToYYYYMMDD(lastWeekMondayTime),
        lastWeekSunday: dateToYYYYMMDD(lastWeekSundayTime),
      };
      return res;
    }

    function getMonthFirstDayAndLastDay() {
      var date = new Date();
      // 值得注意的是，如果day取值为0，意味着取的是date时间的上一个月的最后一天，简单理解：date当前月的第一天，再减去一天
      var thisMonthFirstDay = date.setDate(1); // 本月第一天
      var thisMonthLastDay = new Date(
        date.getFullYear(),
        date.getMonth() + 1,
        0
      ); // 本月最后一天

      var lastMonthFirstDay = new Date(
        date.getFullYear(),
        date.getMonth() - 1,
        1
      ); // 上月第一天

      var lastMonthLastDay = date.setDate(0); // 上月最后一天
      // var day = new Date(date.getFullYear(), date.getMonth(), 0).getDate()
      // var lastMonthLastDay = new Date(date.getFullYear(), date.getMonth() - 1, day) // 上月最后一天
      var res = {
        thisMonthFirstDay: dateToYYYYMMDD(thisMonthFirstDay),
        thisMonthLastDay: dateToYYYYMMDD(thisMonthLastDay),
        lastMonthFirstDay: dateToYYYYMMDD(lastMonthFirstDay),
        lastMonthLastDay: dateToYYYYMMDD(lastMonthLastDay),
      };
      return res;
    }

    function dateToYYYYMMDD(date) {
      var time = new Date(date);
      var y = time.getFullYear();
      var m = time.getMonth() + 1;
      m = m > 9 ? m : "0" + m;
      var d = time.getDate();
      d = d > 9 ? d : "0" + d;

      return y + "/" + m + "/" + d;
    }

    var data = [];
    window.parent.ajaxslist = function () {
      ajaxlist();
    };
    ajaxlist();
    function ajaxlist() {
      $.ajax({
        type: "post",
        url: '{:url("statistics/fieldList")}',
        data: {
          type: 3,
        },
        success: function (res) {
          data = res.data;
          tableData = JSON.parse(JSON.stringify(data));
          renderTableHtml(data);
        },
      });
    }

    // var col2 = '{$field|raw}';
    // var col2 = JSON.parse(col2);

    // if (col2.length > 0) {
    //     for (let i = 0; i < col2.length; i++) {
    //         const element = col2[i];
    //         col1.push(element)
    //     }
    // }

    function renderTableHtml(data) {
      msgindex = layer.msg('加载中...', {
        icon: 16, time: -1
      })
      var col1 = [];
      var col2 = [];
      Object.keys(data).forEach((key) => {
        if (key == "return_visit_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#return_visit_count",
            ...data[key],
          });
        } else if (key == "no_assigned_personnel" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_assigned_personnel",
            ...data[key],
          });
        } else if (key == "no_visit_3" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_visit_3",
            ...data[key],
          });
        } else if (key == "no_visit_7" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_visit_7",
            ...data[key],
          });
        } else if (key == "no_visit_15" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_visit_15",
            ...data[key],
          });
        } else if (key == "no_visit_30" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_visit_30",
            ...data[key],
          });
        } else if (key == "no_visit_31" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#no_visit_31",
            ...data[key],
          });
        } else if (key == "valid_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#valid_count",
            ...data[key],
          });
        } else if (key == "add_wechat_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#add_wechat_count",
            ...data[key],
          });
        } else if (key == "room" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#room",
            ...data[key],
          });
        } else if (key == "store1" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store1",
            ...data[key],
          });
        } else if (key == "store2" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store2",
            ...data[key],
          });
        } else if (key == "store3" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store3",
            ...data[key],
          });
        } else if (key == "store1_dep" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store1_dep",
            ...data[key],
          });
        } else if (key == "store2_dep" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store2_dep",
            ...data[key],
          });
        } else if (key == "store3_dep" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#store3_dep",
            ...data[key],
          });
        } else if (key == "dep" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#dep",
            ...data[key],
          });
        } else if (key == "drawing_date" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#drawing_date",
            ...data[key],
          });
        } else if (key == "sign_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#sign_count",
            ...data[key],
          });
        } else if (key == "existing_homes_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#existing_homes_count",
            ...data[key],
          });
        } else if (key == "forward_housing_count" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            rowspan: 2,
            field: key,
            templet: "#forward_housing_count",
            ...data[key],
          });
        } else if (key == "area" && data[key].show == 1) {
          col1.push({
            title: data[key]["name"],
            align: "center",
            colspan: 6,
            field: key,
          });
          col2 = [
            {
              field: "square_0_80",
              title: "80以下",
              width: 100,
              align: "center",
              templet: "#square_0_80",
            },
            {
              field: "square_80_100",
              title: "81-100",
              width: 100,
              align: "center",
              templet: "#square_80_100",
            },
            {
              field: "square_100_120",
              title: "100-120",
              width: 100,
              align: "center",
              templet: "#square_100_120",
            },
            {
              field: "square_120_200",
              title: "121-200",
              width: 100,
              align: "center",
              templet: "#square_120_200",
            },
            {
              field: "square_200_500",
              title: "200-500",
              width: 100,
              align: "center",
              templet: "#square_200_500",
            },
            {
              field: "square_500",
              title: "500以上",
              width: 100,
              align: "center",
              templet: "#square_500",
            },
          ];
        } else {
          if (data[key].show == 1) {
            col1.push({
              title: data[key]["name"],
              align: "center",
              rowspan: 2,
              field: key,
              ...data[key],
            });
          }
        }
      });

      col1.push({
        title: "",
        width: 30,
        align: "center",
        fixed: "right",
        rowspan: 2,
      });

      let cols = [col1, col2];
      let url = '{:url("statistics/manageStatisticsData")}';

      table.render({
        elem: "#list",
        loading: true,
        url: url,
        page: true,
        height: bodyH,
        cols: cols,
        id: "tablelist",
        limit: 50,
        height: "full-90",
        done: function () {
          layer.close(msgindex);
        }
      });
    }

    $(".lay-setting").click(function () {
      let arr = [];
      $.each(data, function (key, val) {
        arr.push({ ...val, field: key });
      });
      localStorage.setItem('XQ$SORT', '3');
      window.parent.dialogFunc(arr, 3);
    });

    function setYMD(time) {
      let dateTime = new Date(time);
      let year = dateTime.getFullYear();
      let Month = dateTime.getMonth() + 1;
      let days = dateTime.getDate();
      return `${year}-${Month > 9 ? Month : "0" + Month}-${days > 9 ? days : "0" + days}`;
    }
    var dateArr = {};
    var today = new Date().getTime();
    var oneTime = 24 * 60 * 60 * 1000;
    var threeDay1 = today - 3 * oneTime;
    var sevenDay1 = today - 6 * oneTime;
    var oneMonth = today - 30 * oneTime;
    dateArr = {
      nowS: setYMD(today),
      nowE: setYMD(today),
      threeDayS: setYMD(threeDay1),
      threeDayE: setYMD(today),
      sevenDayS: setYMD(sevenDay1),
      sevenDayE: setYMD(today),
      oneMonthS: setYMD(oneMonth),
      oneMonthE: setYMD(today),
    };

    $("#timeBtn").on("click", function (e) {
      if (!!(e.target.localName != "input")) return;
      let o = document.querySelector("#timeBtn").children;
      if (e.target.classList.contains("layui-btn-primary") == true) {
        for (var i = 0; i < o.length; i++) {
          o[i].className = "layui-btn";
        }
        $("#sDate").val("");
        $("#eDate").val("");
        return;
      } else {
        for (var i = 0; i < o.length; i++) {
          o[i].className = "layui-btn";
        }
        e.target.className = "layui-btn layui-btn-primary";
        if (!!(e.target.className.indexOf("layui-btn-primary") > 0)) {
          if (e.target.value == "今日") {
            $("#sDate").val(dateArr.nowS);
            $("#eDate").val(dateArr.nowE);
          } else if (e.target.value == "3天") {
            $("#sDate").val(dateArr.threeDayS);
            $("#eDate").val(dateArr.threeDayE);
          } else if (e.target.value == "7天") {
            $("#sDate").val(dateArr.sevenDayS);
            $("#eDate").val(dateArr.sevenDayE);
          } else {
            $("#sDate").val(dateArr.oneMonthS);
            $("#eDate").val(dateArr.oneMonthE);
          }
        }
      }
    });

    form.on("submit(table-search)", function (data) {
      let field = data.field;
      let element = $(".layui-btn-primary");
      if (element && element[0]) {
        let el = element[0].value;
      }
      let option = {
        where: field,
        page: {
          curr: 1,
        },
      };
      //执行重载
      table.reload("tablelist", option);
    });
    //重置
    $("#resetbtn").click(function () {
      $("#keyword").val("");
      $("#sDate").val("");
      $("#eDate").val("");
      $("#timeBtn input").attr("class", "layui-btn");
      layui.form.render();
      departTree.setValue([]);
      let option = {
        where: { keyword: "", start_date: "", end_date: "", org_id: "" },
        page: {
          curr: 1,
        },
      };
      table.reload("tablelist", option);
    });

    //导出
    $("#tablebtn").click(function () {
      let sdate = $("#sDate").val();
      let edate = $("#eDate").val();
      let keyword = $("#keyword").val();
      // let org_id = $("#org_id").val();
      let org_id = departTree.getValue();
      orgid = org_id.length == 0 ? '' : org_id[0].id;
      let url =
        "{:url('statistics/export2',['m'=>'manageStatisticsData', 'type'=>'manager'])}"

      layer.confirm('确定要导出该查询结果么？', function () {
        $.post(url, { start_date: sdate, end_date: edate, keyword: keyword, org_id: orgid }, function (rs) {
          if (typeof rs == 'string') rs = JSON.parse(rs);
          layer.msg(rs.msg);
        })
      })
    });

    //调用内容
    table.on("tool(datalist)", function (obj) {
      let sdate = $("#sDate").val();
      let edate = $("#eDate").val();
      switch (obj.event) {
        case "return_visit_count":
          layer.open({
            type: 2,
            title: [
              "待回访客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_assigned_personnel":
          layer.open({
            type: 2,
            title: [
              "待指派客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=assign&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_visit_3":
          layer.open({
            type: 2,
            title: [
              "3天未跟进客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=v3&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_visit_7":
          layer.open({
            type: 2,
            title: [
              "7天未跟进客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=v7&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_visit_15":
          layer.open({
            type: 2,
            title: [
              "15天未跟进客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=v15&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_visit_30":
          layer.open({
            type: 2,
            title: [
              "30天未跟进客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=v30&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "no_visit_31":
          layer.open({
            type: 2,
            title: [
              "30天以上未跟进客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=v31&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "valid_count":
          layer.open({
            type: 2,
            title: ["有效线索列表", "color:#333333;background-color:#D8E6F1;"],
            content:
              '{:url("statistics/manageOpen")}?type=valid&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "add_wechat_count":
          layer.open({
            type: 2,
            title: ["加微客户列表", "color:#333333;background-color:#D8E6F1;"],
            content:
              '{:url("statistics/manageOpen")}?type=wechat&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "room":
          layer.open({
            type: 2,
            title: ["量房客户列表", "color:#333333;background-color:#D8E6F1;"],
            content:
              '{:url("statistics/manageOpen")}?type=room&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store1":
          layer.open({
            type: 2,
            title: [
              "一次到店客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store1&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store2":
          layer.open({
            type: 2,
            title: [
              "二次到店客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store2&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store3":
          layer.open({
            type: 2,
            title: [
              "三次及以上客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store3&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store1_dep":
          layer.open({
            type: 2,
            title: [
              "一次到店客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store1_dep&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store2_dep":
          layer.open({
            type: 2,
            title: [
              "二次到店客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store2_dep&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "store3_dep":
          layer.open({
            type: 2,
            title: [
              "三次及以上客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=store3_dep&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "drawing_date":
          layer.open({
            type: 2,
            title: [
              "出方案客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=drawing&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "dep":
          layer.open({
            type: 2,
            title: [
              "总签单客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=dep&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "sign_count":
          layer.open({
            type: 2,
            title: [
              "总签单客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=sign_count&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_0_80":
          layer.open({
            type: 2,
            title: [
              "房屋面积80平以下客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_0_80&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_80_100":
          layer.open({
            type: 2,
            title: [
              "房屋面积80-100平客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_80_100&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_100_120":
          layer.open({
            type: 2,
            title: [
              "房屋面积100-120平客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_100_120&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_120_200":
          layer.open({
            type: 2,
            title: [
              "房屋面积120-200平客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_120_200&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_200_500":
          layer.open({
            type: 2,
            title: [
              "房屋面积200-500平客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_200_500&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "square_500":
          layer.open({
            type: 2,
            title: [
              "房屋面积500平以上客户列表",
              "color:#333333;background-color:#D8E6F1;",
            ],
            content:
              '{:url("statistics/manageOpen")}?type=square_500&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "existing_homes_count":
          layer.open({
            type: 2,
            title: ["现房客户列表", "color:#333333;background-color:#D8E6F1;"],
            content:
              '{:url("statistics/manageOpen")}?type=existing_homes_count&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
        case "forward_housing_count":
          layer.open({
            type: 2,
            title: ["期房客户列表", "color:#333333;background-color:#D8E6F1;"],
            content:
              '{:url("statistics/manageOpen")}?type=forward_housing_count&eid=' +
              obj.data.id +
              "&start_date=" +
              sdate +
              "&end_date=" +
              edate,
            resize: false,
            area: ["80%", "80%"],
          });
          break;
      }
    });

    $('#manager-export-list').click(function () {
      layer.open({
        type: 2,
        area: ['600px', '600px'],
        content: '{:url("statistics/exportList2",array("type"=>"manageStatisticsData"))}'
      });
    });
  });
</script>
{/block}