Untitled

// add role js
let rep_gen_local_url = 'http://127.0.0.1:8002/';
//  let rep_gen_local_url = "https://uatcrmrg.mygainn.com/";



function saveRole() {
  var role_name = $("#role_name").val();
  var formData = {
    role_name: role_name,
  };
  $.ajax({
    type: "POST",
    url: "/save-role",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        location.reload();
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
      setTimeout(function () {
        location.reload();
        $('.alert').fadeOut("slow");
      }, 1000);
    },
  });
}

function editRole(id) {
  $.ajax({
    type: "POST",
    url: "/edit-role/" + id,

    success: function (res) {
      if (res.status == "success") {
        $("#role_name").val(res.data.role_name);
        $("#submit").html("Update");
        $("#h3").html("Edit Role");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", `updateRole('${res.data._id}')`);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateRole(id) {
  var role_name = $("#role_name").val();
  var formData = {
    role_name: role_name,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-role",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        location.reload();
        setTimeout(function () {
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteRole(id) {
  if (confirm("Are you sure you want to delete this?")) {
    $.ajax({
      type: "POST",
      url: `/delete-role/${id}`,
      success: function (data) {
        //console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          location.reload();
          setTimeout(function () {
            $(".alert").fadeOut("slow");
          }, 2000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

// ===============================================  end role js ==========================================

// ================================================ add menu js ================================================

function saveCategory() {
  var menu_name = $("#menu_name").val();
  var sp_name = $("#sp_name").val();
  var db_name = $("#db_name").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    menu_name: menu_name,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/save-menu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editMenu(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-menu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        $("#menu_name").val(res.data.menu_name);
        $("#sp_name").val(res.data.sp_name);
        $("#db_name").val(res.data.db_name);
        $("#Url_name").val(res.data.Url_name);
        $("#Sequence_Number").val(res.data.Sequence_Number);
        $("#submit").html("Update");
        $("#h2").html("Edit Menu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "updateCategory('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateCategory(id) {
  var menu_name = $("#menu_name").val();
  var sp_name = $("#sp_name").val();
  var db_name = $("#db_name").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    menu_name: menu_name,
    id: id,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/update-menu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteMenu(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-menu",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        //console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 2000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

//======================================== end add menu ===============================================

// ================================================ add submenu js ================================================

function saveSubmenu() {
  var sp_name = $("#sp_name").val();
  var db_name = $("#db_name").val();
  var submenu_name = $("#submenu_name").val();
  var menu_id = $("#menu_id").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    submenu_name: submenu_name,
    menu_id: menu_id,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/save-submenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        //window.location.reload();
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 600);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editSubmenu(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-submenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        // console.log(res);
        $("#menu_id").val(res.data.menu_id);
        $("#submenu_name").val(res.data.submenu_name);
        $("#sp_name").val(res.data.sp_name);
        $("#db_name").val(res.data.db_name);
        $("#Url_name").val(res.data.Url_name);
        $("#Sequence_Number").val(res.data.Sequence_Number);
        $("#submit").html("Update");
        $("#h2").html("Edit SubMenu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "updateSubmenu('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateSubmenu(id) {
  var submenu_name = $("#submenu_name").val();
  var sp_name = $("#sp_name").val();
  var menu_id = $("#menu_id").val();
  var db_name = $("#db_name").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    submenu_name: submenu_name,
    menu_id: menu_id,
    id: id,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/update-submenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteSubmenu(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-submenu",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        // console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 1000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

// ================================================ end submenu js ================================================

// ================================================ add subsubmenu js ================================================
function saveSubsubmenu() {
  var submenu_id = $("#submenu_id").val();
  var menu_id = $("#menu_id").val();
  var subsubmenu_name = $("#subsubmenu_name").val();
  var sp_name = $("#sp_name").val();
  var db_name = $("#db_name").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    submenu_id: submenu_id,
    menu_id: menu_id,
    subsubmenu_name: subsubmenu_name,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/save-subsubmenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        //window.location.reload();
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editSubsubmenu(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-subsubmenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      //console.log(res.data.submenu_id);
      if (res.status == "success") {
        $("#menu_id").val(res.data.menu_id);
        getSubmenu(res.data.submenu_id);

        $("#subsubmenu_name").val(res.data.subsubmenu_name);
        $("#sp_name").val(res.data.sp_name);
        $("#db_name").val(res.data.db_name),
          $("#Url_name").val(res.data.Url_name),
          $("#Sequence_Number").val(res.data.Sequence_Number),
          $("#submit").html("Update");
        $("#h2").html("Edit Subsub Menu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr(
          "onclick",
          "updateSubsubmenu('" + res.data._id + "')"
        );
        $("#submenu_id").val(res.data.submenu_id).trigger("change");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateSubsubmenu(id) {
  var submenu_id = $("#submenu_id").val();
  var menu_id = $("#menu_id").val();
  var subsubmenu_name = $("#subsubmenu_name").val();
  var db_name = $("#db_name").val();
  var sp_name = $("#sp_name").val();
  var Url_name = $("#Url_name").val();
  var Sequence_Number = $("#Sequence_Number").val();
  var formData = {
    submenu_id: submenu_id,
    menu_id: menu_id,
    id: id,
    subsubmenu_name: subsubmenu_name,
    sp_name: sp_name,
    db_name: db_name,
    Url_name: Url_name,
    Sequence_Number: Sequence_Number,
  };
  $.ajax({
    type: "POST",
    url: "/update-subsubmenu",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteSubsubmenu(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-subsubmenu",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        //  console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 1000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

function getSubmenu(submenu_id = null) {
  var menu_id = $("#menu_id").val();
  var formData = {
    menu_id: menu_id,
  };

  $.post("/getsubmenulist", formData, function (data) {
    var submenu = JSON.parse(JSON.stringify(data));

    $("#submenu_id").html("");
    var html = '<option value="">Select Sub menu</option>';
    // var html = '<option value="">  </option>';
    $.each(submenu.data, function (i, val) {
      html +=
        '<option value="' + val._id + '">' + val.submenu_name + "</option>";
    });
    $("#submenu_id").html(html);
    if (submenu_id != null) {
      $("#submenu_id").val(submenu_id).trigger("change");
    }
  });
}

// ================================================ end subsubmenu js ================================================

// ================================================ add table js ===================================================

function saveTableName() {
  var table_name = $("#table_name").val();
  var formData = {
    table_name: table_name,
  };
  $.ajax({
    type: "POST",
    url: "/save-table-name",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editTableName(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-table-name",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        $("#table_name").val(res.data.table_name);
        $("#submit").html("Update");
        $("#h2").html("Edit Menu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "updateTableName('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateTableName(id) {
  var table_name = $("#table_name").val();
  var formData = {
    table_name: table_name,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-table-name",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteTableName(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-table-name",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        // console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 2000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

// ================================================ end table js ===================================================

// ================================================ add table column js ===================================================

function saveTableColumn() {
  var column_name = $("#column_name").val();
  var table_id = $("#table_id").val();
  var formData = {
    column_name: column_name,
    table_id: table_id,
  };
  $.ajax({
    type: "POST",
    url: "/save-table-column",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        //window.location.reload();
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 600);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editTableColumn(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-table-column",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        $("#table_id").val(res.data.table_id);
        $("#column_name").val(res.data.column_name);

        $("#submit").html("Update");
        $("#h2").html("Edit TableColumn");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr(
          "onclick",
          "updateTableColumn('" + res.data._id + "')"
        );
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateTableColumn(id) {
  var column_name = $("#column_name").val();
  var table_id = $("#table_id").val();

  var formData = {
    column_name: column_name,
    table_id: table_id,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-table-column",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteTableColumn(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-table-column",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        // console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 1000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

// ================================================ end table column js ==================================================

// ================================================ add table subcolumn js ==================================================

function saveTableSubcolumn() {
  var column_id = $("#column_id").val();
  var table_id = $("#table_id").val();
  var sub_column = $("#sub_column").val();
  var column_value = $("#column_value").val();

  var formData = {
    column_id: column_id,
    table_id: table_id,
    sub_column: sub_column,
    column_value: column_value,
  };
  $.ajax({
    type: "POST",
    url: "/save-table-subcolumn",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        //window.location.reload();
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editSubcolumn(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-table-subcolumn",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      // console.log(res.data.column_id);
      if (res.status == "success") {
        $("#table_id").val(res.data.table_id);
        getColumn(res.data.column_id);

        $("#sub_column").val(res.data.sub_column);
        $("#column_value").val(res.data.column_value);
        $("#submit").html("Update");
        $("#h2").html("Edit Subsub Menu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr(
          "onclick",
          "updateTableSubsubmenu('" + res.data._id + "')"
        );
        $("#column_id").val(res.data.column_id).trigger("change");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateTableSubsubmenu(id) {
  var column_id = $("#column_id").val();
  var table_id = $("#table_id").val();
  var sub_column = $("#sub_column").val();
  var column_value = $("#column_value").val();
  var formData = {
    column_id: column_id,
    table_id: table_id,
    id: id,
    sub_column: sub_column,
    column_value: column_value,
  };
  $.ajax({
    type: "POST",
    url: "/update-table-subcolumn",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteSubcolumn(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-table-subcolumn",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        // console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 1000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

function getColumn(column_id = null) {
  var table_id = $("#table_id").val();
  var formData = {
    table_id: table_id,
  };

  $.post("/getcolumnlist", formData, function (data) {
    var submenu = JSON.parse(JSON.stringify(data));

    $("#column_id").html("");

    var html = '<option value="">Select column</option>';

    $.each(submenu.data, function (i, val) {
      html +=
        '<option value="' + val._id + '">' + val.column_name + "</option>";
    });
    $("#column_id").html(html);
    if (column_id != null) {
      $("#column_id").val(column_id).trigger("change");
    }
  });
}

// ================================================ end table subcolumn js ==================================================

// ================================================= map table columns to role js ===========================================
function saveMenuRelation() {
  // var table_id = $("input[name='table_id']:checked").val();
  var role_id = $("#role_id").val();

  var menu_id = [];
  $("input[name='menu_id[]']:checked").each(function () {
    menu_id.push($(this).val());
  });
  var submenu_id = [];
  $("input[name='submenu_id[]']:checked").each(function () {
    submenu_id.push($(this).val());
  });
  var subsubmenu_id = [];

  $("input[name='subsubmenu_id[]']:checked").each(function () {
    subsubmenu_id.push($(this).val());
  });

  var formData = {
    subsubmenu_id: subsubmenu_id,
    menu_id: menu_id,
    submenu_id: submenu_id,
    role_id: role_id,
  };
  //console.log(formData);
  $.ajax({
    type: "POST",
    url: "/save-menurelation",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function getRoleWiseTableColumns() {
  var role_id = $("#role_id").val();
  var formData = {
    role_id: role_id,
  };
  $.post("/get-rolewise-table-columns", formData, function (res) {
    var data = JSON.parse(JSON.stringify(res));
    // console.log(data);
    if (data.status == "failed") {
      $("#role_wise_table_columns").html(data);
    } else {
      $("#role_wise_table_columns").html(data);
    }
  });
}

// function to send report on mail
function getReport() {
  var from_date = $("#from_date").val();
  var to_date = $("#to_date").val();
  var report_name = $("#report_name").val();
  var file_format = $("#file_format").val();
  var send_request_type = $("#send_request_type").val();
  var client_code = [];
  $("input[name='client_code[]']:checked").each(function () {
    client_code.push($(this).val());
  });
  var formData = {
    from_date: from_date,
    to_date: to_date,
    report_name: report_name,
    client_code: client_code,
    send_request_type: send_request_type,
    file_format: file_format,
  };
  $.ajax({
    type: "POST",
    url: "/save-report-request",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function yyyymmdd(dateIn) {
  var yyyy = dateIn.getFullYear();
  var mm = dateIn.getMonth() + 1; // getMonth() is zero-based
  var dd = dateIn.getDate();
  return String(10000 * yyyy + dd + 100 * mm); // Leading zeros for mm and dd
}

function getTradeReport() {
  var from_date1 = $("#from_date").val();
  var to_date1 = $("#to_date").val();
  var bills_date1 = $("#bills_date").val();
  var as_on_date1 = $("#as_on_date").val();
  var report_name = $("#report_name").val();
  var file_format = $("#file_format").val();
  var send_request_type = $("#send_request_type").val();
  var client_code = $("#client_code").val();
  var report_name_id = $("#report_name_id").val();
  var bills_exch = $("#bills_exch").val();
  var bills_seg = $("#bills_seg").val();
  var settelment = $("#settelment").val();
  var bo_id = $("#bo_id").val();

  // var ledger_exchange = $("#ledger_exchange").val();
  // var document_name = $("#document_name").val();

  // validation

  // if(!client_code){
  // 	$("#client_code_err").html('Please enter Client Code')
  // 	return false
  // }else{
  // 	$("#client_code_err").html('')
  // }
  // if(!from_date1){
  // 	$("#from_date_err").html('Please select From Date')
  // 	return false
  // }else{
  // 	$("#from_date_err").html('')
  // }
  // if(!to_date1){
  // 	$("#to_date_err").html('Please select To Date')
  // 	return false
  // }else{
  // 	$("#to_date_err").html('')
  // }
  // if(!document_name){
  // 	$("#document_name_err").html('Please select document type')
  // 	return false
  // }else{
  // 	$("#document_name_err").html('')
  // }

  // if(!ledger_exchange){
  // 	$("#ledger_exchange_err").html('Please select exchange segment')
  // 	return false
  // }else{
  // 	$("#ledger_exchange_err").html('')
  // }

  // end validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  if (as_on_date1) {
    var datearray1 = as_on_date1.split("/");
    var newas_ondate =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  if (bills_date1) {
    var datearray1 = bills_date1.split("/");
    var newbills_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    bills_date1 = "";
  }

  // var datearray2 = to_date1.split("/");
  // var newto_date = datearray2[1] + '/' + datearray2[0] + '/' + datearray2[2];

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);
  var as_on_date = new Date(newas_ondate);
  var bills_date = new Date(newbills_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    as_on_date: yyyymmdd(as_on_date),
    bills_date: yyyymmdd(bills_date),
    report_name: report_name,
    client_code: client_code,
    send_request_type: send_request_type,
    file_format: file_format,
    report_name_id: report_name_id,
    bills_exch: bills_exch,
    bills_seg: bills_seg,
    settelment: settelment,
    bo_id: bo_id,
    // 'document_name': document_name,
    // 'ledger_exchange': ledger_exchange,
  };

  $.ajax({
    type: "POST",
    url: "/save-trade-report-request",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".btn-adv").html("Requesting...");
    },
    success: function (data) {
      //console.log(data);
      $("#get_api_response").html(data);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".btn-adv").html("Request");
    },
  });
}

function clientWiseReport(client_code) {
  var from_date = $("#from_date").val();
  var to_date = $("#to_date").val();
  var report_name = $("#report_name").val();
  var file_format = $("#file_format").val();
  var send_request_type = $("#send_request_type").val();

  var formData = {
    from_date: from_date,
    to_date: to_date,
    report_name: report_name,
    client_code: client_code,
    send_request_type: send_request_type,
    file_format: file_format,
  };
  $.post("/save-report-request", formData, function (data) {
    if (data.status == "success") {
      $(".alert-danger").css("display", "none");
      $(".alert-success").css("display", "block").text(data.message);
      setTimeout(function () {
        location.reload();
        $(".alert").fadeOut("slow");
      }, 1000);
    } else {
      $(".alert-success").css("display", "none");
      $(".alert-danger").css("display", "block").text(data.message);
    }
  });
}

function getLedgerDetailReport() {
  $("#ledger_response").html("");
  var from_date1 = $("#from_date").val();
  var to_date1 = $("#to_date").val();
  var client_type = $("#client_type").val();
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  // var filter = $("#filter").val();
  var report_name = $("#report_name").val();

  var filter = $('input[name="filter[]"]:checked')
    .map(function () {
      return this.value;
    })
    .get();

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }
  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
    filter: filter,
    client_type: client_type,
  };

  $.ajax({
    type: "POST",
    url: "/get-ledger-detail-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      // $('.btn-adv').html("Requesting...");
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#ledger_response").html("");
      } else {
        $("#ledger_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      // $('.btn-adv').html("Request");
      $(".ajax-loader").css("display", "none");
    },
  });
}

// ============================================ map menu to role =======================================================================================

function getRoleWiseMenu() {
  var role_id = $("#role_id").val();
  var formData = { role_id: role_id };
  $.post("/get-rolewise-menu", formData, function (res) {
    var data = JSON.parse(JSON.stringify(res));
    //console.log(data);
    if (data.status == "failed") {
      $("#role_wise_menu").html(data);
    } else {
      $("#role_wise_menu").html(data);
    }
  });
}

//  ============================================ menu relation ==================================================================

// =================================  add rejected reason js ==============================================================
function saveRejectedReason() {
  var rejected_reason = $("#rejected_reason").val();
  var formData = {
    rejected_reason: rejected_reason,
  };
  $.ajax({
    type: "POST",
    url: "/save-rejected-reason",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
      setTimeout(function () {
        location.reload();
        $(".alert").fadeOut("slow");
      }, 2000);
    },
  });
}

function editRejectedReason(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-rejected-reason",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        $("#rejected_reason").val(res.data.rejected_reason);
        $("#submit").html("Update");
        $("#h2").html("Edit Reason");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr(
          "onclick",
          "updateRejectedReason('" + res.data._id + "')"
        );
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateRejectedReason(id) {
  var rejected_reason = $("#rejected_reason").val();
  var formData = {
    rejected_reason: rejected_reason,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-rejected-reason",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteRejectedReason(id) {
  if (confirm("Are you sure you want to delete this?")) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-rejected-reason",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        //console.log(data);
        if (data.status == "success") {
          $(".alert-danger").css("display", "none");
          $(".alert-success").css("display", "block").text(data.message);
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 2000);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}
// ===============================================  end role js ==========================================

// ================================================ payout request =======================================

function savePayoutRequest() {
  var client_code = $("#client_coded").val();
  var available_balance = parseFloat($("#available_balance").val());
  let request_amount = parseFloat($("#request_amount").val());
  var source = $("#source").val();
  var logged_in_userid = $("#logged_in_userid").val();
  if (request_amount > available_balance) {
    $("#request_amount_err").html(
      "Request amount is greater than available balance"
    );
    return false;
  } else {
    $("#request_amount_err").html("");
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  }
  checkAvailableBalance();
  var formData = {
    client_code: client_code,
    available_balance: available_balance,
    request_amount: request_amount,
    source: source,
    logged_in_userid: logged_in_userid,
  };
  $.ajax({
    type: "POST",
    url: "/save-payout-request",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
      setTimeout(function () {
        location.reload();
        $(".alert").fadeOut("slow");
      }, 1000);
    },
  });
}

function getStatus(id) {
  var payout_request_status = $("#payout_request_status_" + id).val();

  if (payout_request_status == "1") {
    $("#reject_status_" + id).hide();
    $("#partially_approved_status_" + id).hide();
  }
  if (payout_request_status == "2") {
    $("#reject_status_" + id).hide();
    $("#partially_approved_status_" + id).show();
  }
  if (payout_request_status == "3") {
    $("#reject_status_" + id).show();
    $("#partially_approved_status_" + id).hide();
  }
}
function UpdatePayoutRequestStatus(id) {
  var payout_request_status = $("#payout_request_status_" + id).val();
  var rejected_reason = $("#rejected_reason_" + id).val();
  var partially_approved_amount = $("#partially_approved_amount_" + id).val();

  if (payout_request_status == null && payout_request_status != "") {
    $("#payout_request_status_err_" + id).html("please select status");
    return false;
  } else {
    $("#payout_request_status_err_" + id).html("");
  }
  if (payout_request_status == "2" && partially_approved_amount == "") {
    $("#partially_approved_amount_err_" + id).html(
      "please partiallyapproved amount"
    );
    return false;
  } else {
    $("#rejected_reason_err_" + id).html("");
  }
  if (payout_request_status == "3" && rejected_reason == null) {
    $("#rejected_reason_err_" + id).html("please select reason");
    return false;
  } else {
    $("#rejected_reason_err_" + id).html("");
  }

  var formData = {
    rejected_reason: rejected_reason,
    partially_approved_amount: partially_approved_amount,
    payout_request_status: payout_request_status,
    id: id,
  };
  //console.log(formData);
  $.ajax({
    type: "POST",
    url: "/update-payout-request-status",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
      setTimeout(function () {
        location.reload();
        $(".alert").fadeOut("slow");
      }, 2000);
    },
  });
}

function UpdatePayoutRequestStatusAcc(id) {
  var payout_request_status = $("#payout_request_status_" + id).val() || "";
  var rejected_reason = $("#rejected_reason_" + id).val() || "";
  var partially_approved_amount =
    $("#partially_approved_amount_" + id).val() || "";

  if (payout_request_status == "") {
    $("#payout_request_status_err_" + id).html("please select status");
    return false;
  } else {
    $("#payout_request_status_err_" + id).html("");
  }
  if (payout_request_status == "2" && partially_approved_amount == "") {
    $("#partially_approved_amount_err_" + id).html(
      "please partiallyapproved amount"
    );
    return false;
  } else {
    $("#rejected_reason_err_" + id).html("");
  }
  if (payout_request_status == "3" && rejected_reason == null) {
    $("#rejected_reason_err_" + id).html("please select reason");
    return false;
  } else {
    $("#rejected_reason_err_" + id).html("");
  }

  var formData = {
    rejected_reason: rejected_reason,
    partially_approved_amount: partially_approved_amount,
    payout_request_status: payout_request_status,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-payout-request-status-accounts",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
      setTimeout(function () {
        location.reload();
        $(".alert").fadeOut("slow");
      }, 2000);
    },
  });
}

// =================================  add rejected reason js ==============================================================
function saveRejectedReasonAjax(id) {
  var rejected_reason = $("#rejected_reason" + id).val();
  if (rejected_reason == "" && rejected_reason == null) {
    $("#rejected_reason_arr").html("enter reason");
  }
  var formData = {
    rejected_reason: rejected_reason,
  };
  $.ajax({
    type: "POST",
    url: "/save-rejected-reason",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-reject-succ").css("display", "block").text(data.message);
        $(".alert-reject-err").css("display", "none");
        setTimeout(function () {
          $("#exampleModal").modal("hide");
          $("#rejected_reason" + id).val("");
          //value='" + data.last_record[0]['_id'] + "'
          $("#rejected_reason_" + id).append(
            "<option value='" +
            data.last_record[0]["_id"] +
            "'>" +
            data.last_record[0]["rejected_reason"] +
            "</option>"
          );
          $("#rejected_reason_" + id)
            .val(data.last_record[0]["_id"])
            .trigger("change"); //val(data.last_record[0]['rejected_reason']).trigger("change");//added this line
        }, 1000);
      } else {
        $(".alert-reject-succ").css("display", "none");
        $(".alert-reject-err").css("display", "block").text(data.message);
      }
    },
  });
}

function SendDataToExcel() {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: $("#txt1").val() || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "",
  };

  $.ajax({
    type: "POST",
    url: "/download-trade-excel",
    data: JSON.stringify(formData),
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (data) {
      //console.log("Success");
      // console.log();
      if (data.data == 200) {
        window.location = "excel/report.xlsx"; // '/Reports/Download?file=' + returnValue;
      }
    },
    error: function (data) {
      console.log("Error");
      //console.log(data);
    },
  });
}
function SendDataToPDF() {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: $("#txt1").val() || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "",
  };

  $.ajax({
    type: "POST",
    url: "/download-trade-pdf",
    data: JSON.stringify(formData),
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (data) {
      if (data.data == 200) {
        var link = document.createElement("a");
        link.href = "excel/report.pdf";
        link.download = "excel/report.pdf";
        link.dispatchEvent(new MouseEvent("click")); // '/Reports/Download?file=' + returnValue;
      }
    },
    error: function (data) {
      console.log("Error");
      //console.log(data);
    },
  });
}

// sample ajax code
function SearchTradeData() {
  $("#search_data").html("");
  var client_code1 = $("#txt1").val() || "";
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var group1=$("#txt2").val()|| "";
  if (group1.indexOf("-") != -1) {
    var group = group1.substring(0, group1.indexOf("-"));
  } else {
    var group = group1;
  }
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: client_code || "",
    txt2: group || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "",
  };

  //console.log(formData);
  $.ajax({
    type: "POST",
    url: "/trades-search",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
      // $("#search_data").html(``);
      // $("#search_data").prop("disabled", true);
    },
    success: function (data) {
      $("#search_data").html(data);
      $("#collapse1").removeClass("in");
      $("#collapse2").addClass("in");
      if (client_code1 != "") {
        $("#clientdata").css("display", "flex");
      } else {
        $("#clientdata").css("display", "none");
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $("#fetch").html("Fetch");
      $("#fetch").prop("disabled", false);
      $(".ajax-loader").css("display", "none");
    },
  });
}

// Author : soyal
// Date (04/10/2022) :
// Last updated by :
// Last updated Date (dd-mmm-yy):
// Description : Reset Filter

function ResetData() {
  location.reload(true);
}

// 'mail','xlsx','<%= report_name_id %>','<%= LoginId %>','<%= RepNo %>','<%= FromDt %>','<%= ToDt %>','<%= txt1 %>','<%= txt2 %>','<%= txt3 %>','<%= Fil1Num %>','<%= Fil2Num %>','<%= Fil3Num %>','<%= Fil1LBL %>','<%= Fil2LBL %>','<%= Fil3LBL %>','<%= Fil1Cmb %>','<%= Fil2Cmb %>','<%= Fil3Cmb %>'
function sendExcelEmail(
  type,
  formate,
  report_name_id,
  LoginId,
  RepNo,
  FromDt,
  ToDt,
  txt1,
  txt2,
  txt3,
  Fil1Num,
  Fil2Num,
  Fil3Num,
  Fil1LBL,
  Fil2LBL,
  Fil3LBL,
  Fil1Cmb,
  Fil2Cmb,
  Fil3Cmb
) {
  var from_date = $("#from_date").val() || "2020/10/10";
  var to_date = $("#to_date").val() || "2020/10/10";

  // var file_format = $("#file_format").val();
  // var send_request_type = $("#send_request_type").val();

  var formData = {
    from_date: from_date,

    to_date: to_date,
    report_name: report_name_id,
    client_code: txt1,
    send_request_type: type,
    file_format: formate,
    LoginId: LoginId,
    RepNo: RepNo,
    FromDt: FromDt,
    ToDt: ToDt,
    txt1: txt1,
    txt2: txt2,
    txt3: txt3,
    Fil1Num: Fil1Num,
    Fil2Num: Fil2Num,
    Fil3Num: Fil3Num,
    Fil1LBL: Fil1LBL,
    Fil2LBL: Fil2LBL,
    Fil3LBL: Fil3LBL,
    Fil1Cmb: Fil1Cmb,
    Fil2Cmb: Fil2Cmb,
    Fil3Cmb: Fil3Cmb,
  };
  $.post("/save-report-request", formData, function (data) {
    //console.log(submenu_list);

    if (data.status == "success") {
      $(".alert-danger").css("display", "none");
      $(".alert-success").css("display", "block").text(data.message);
    } else {
      $(".alert-success").css("display", "none");
      $(".alert-danger").css("display", "block").text(data.message);
    }
  });
}

function excelbtnshow(id, data) {
  var formData = {
    excel: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function pdfbtnshow(id, data) {
  var formData = {
    pdf: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      //console.log("Success");
      //console.log(data);
      location.reload();
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function Emailpdf(id, data) {
  var formData = {
    Emailpdf: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function EmailexcelBtn(id, data) {
  var formData = {
    Emailexcel: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function whatsapppdf(id, data) {
  var formData = {
    whatsapppdf: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function whatsappexcel(id, data) {
  var formData = {
    whatsappexcel: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function Telegramexcel(id, data) {
  var formData = {
    Telegramexcel: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function Telegrampdf(id, data) {
  var formData = {
    Telegrampdf: data,
  };
  $.ajax({
    type: "POST",
    url: `/update-btn/${id}`,
    data: formData,
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function saveEmailCredentials() {
  var email = $("#email").val();
  var password = $("#password").val();

  var formData = { email: email, password: password };
  $.ajax({
    type: "POST",
    url: "/save-email-credentials",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function editEmailCredentials(id) {
  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-email-credentials",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        $("#email").prop("readonly", false);
        $("#password").prop("readonly", false);
        $("#email").val(res.data.email);
        $("#password").val(res.data.password);
        $("#submit").html("Update");
        $("#h3").html("Edit EMAIL CREDENTIALS");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr(
          "onclick",
          "updateEmailCredentials('" + res.data._id + "')"
        );
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}
function updateEmailCredentials(id) {
  var email = $("#email").val();
  var password = $("#password").val();
  var formData = {
    email: email,
    password: password,
    id: id,
  };
  $.ajax({
    type: "POST",
    url: "/update-email-credentials",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        location.reload();
        setTimeout(function () {
          $(".alert").fadeOut("slow");
        }, 3000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}
function getLedgerReportRequest() {
  var from_date1 = $("#from_date").val() || "";
  var as_on_date1 = $("#as_on_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var report_name = $("#report_name").val();

  
  var file_format = $('input[name="file_format"]:checked').val();
  var send_request_type = $('input[name="send_request_type"]:checked').val();
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  // var report_name_id = $("#report_name_id").val();
  var ledger_filter = $("#document_name").val() || "";
  var report_type = $("#report_type").val() || "";
  var exchange_segemnt =
    $('input[name="exchange_segment"]:checked').val() || "";
  var document_name = $("#document_name").val();
  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!document_name) {
    $("#document_name_err").html("Please select report");
    return false;
  } else {
    $("#document_name_err").html("");
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!file_format) {
    $("#file_format_err").html("Please select format");
    return false;
  } else {
    $("#file_format_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }
  console.log(rep_gen_local_url)
  if(report_name=="")
  {
    location.reload();
  }
  if (from_date1) {
    let from_daten = formatDate(from_date1);
    //console.log(from_daten);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }
  if (to_date1) {
    let to_daten = formatDate(to_date1);
    //console.log(to_daten);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }
  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    //console.log(as_on_daten);
    var datearray1 = as_on_daten.split("/");
    var newas_ondate =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }
  // if(bills_date1){
  // 	var datearray1 = bills_date1.split("/");
  // 	var newbills_date = datearray1[1] + '/' + datearray1[0] + '/' + datearray1[2];
  // }
  // else{
  // 	bills_date1 =''
  // }
  // var datearray2 = to_date1.split("/");
  // var newto_date = datearray2[1] + '/' + datearray2[0] + '/' + datearray2[2];
  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);
  var as_on_date = new Date(newas_ondate);
  // var bills_date = new Date(newbills_date);
  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    as_on_date: yyyymmdd(as_on_date),
    // 'bills_date': yyyymmdd(bills_date),
    report_name: report_name,
    client_code: client_code,
    send_request_type: send_request_type,
    file_format: file_format,
    ledger_filter: ledger_filter,
    report_type: report_type,
    exchange_segemnt: exchange_segemnt,
  };
  $("#submitBtn").html("Please wait...");
  $("#submitBtn").prop("disabled", true);
  $.ajax({
    type: "POST",
    url: "/save-and-get-trade-report-request",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    method: 'POST',
    data: JSON.stringify(formData),
    processData: false,
    contentType: 'application/json',
    xhrFields: {
      responseType: 'blob'
    },
    success: function (response, status, xhr) {
      if (xhr.status === 200) {
        if (send_request_type == "mail") {
          console.log("Successfully Mailed")
          return;
        }
        var blob = new Blob([response]);
        var downloadUrl = URL.createObjectURL(blob);
        console.log(downloadUrl)
        var a = document.createElement('a');
        a.href = downloadUrl;
        if(sent_format_type=="pdf"){
          a.download = 'ClientMaster.pdf';
        }
        else{
          a.download = 'ClientMaster.xlsx';
        }           
        a.click();
        URL.revokeObjectURL(downloadUrl);
      }
      else {
        console.error('Error downloading Excel file:', xhr.status);
      }
    },
    error: function (xhr, status, error) {
      console.error('Error downloading Excel file:', error);
    }
    // beforeSend: function () { 
    // },
    // success: function (data1) {
    //   if (data1 == "Created") {
    //     $("#client_code_err").html("invalid Client Code.");
    //   } else {
    //     let dat1 = JSON.parse(data1);
    //     if (dat1.send_request_type == "download") {
    //       setTimeout(function () {
    //         $.ajax({
    //           type: "POST",
    //           url: "/download-file",
    //           // beforeSend: function () {
    //           //   $("#fetch_btn").html("Please wait...");
    //           //   $("#fetch_btn").prop("disabled", true);
    //           // },
    //           success: function (data) {
    //             if (data.status == true && data.file_format == "xlsx") {
    //               var link = document.createElement("a");
    //               link.href = rep_gen_local_url + data.rname;
    //               link.download = "data" + ".xlsx";
    //               link.dispatchEvent(new MouseEvent("click"));
    //               setTimeout(function () {
    //                 $("#cform")[0].reset();
    //                 $(".alert").fadeOut("slow");
    //               }, 500);
    //             } else if (data.status == true && data.file_format == "pdf") {
    //               //console.log(data);
    //               var link = document.createElement("a");
    //               link.href = rep_gen_local_url + data.file_path; //data.rname;
    //               link.download = "LedgerDetail.pdf";
    //               link.click(new MouseEvent("click"));
    //               setTimeout(function () {
    //                 $("#cform")[0].reset();
    //                 $(".alert").fadeOut("slow");
    //               }, 500);
    //             }
    //           },
    //           error: function (err) {
    //             alert("errrr");
    //             console.log("Error");
    //             console.log(err);
    //           },
    //           complete: function () {
    //             $("#submitBtn").html("Submit");
    //             $("#submitBtn").prop("disabled", false);
    //           },
    //         });
    //       }, 2000);
    //     } else {
    //       $(".alert-adv")
    //         .css("display", "block")
    //         .html("Request Sent Successfully.");
    //       setTimeout(function () {
    //         location.reload();
    //         $(".alert").fadeOut("slow");
    //       }, 1000);
    //     }
    //   }
    // },
    // error: function (err) {
    //   console.log("Error");
    //   console.log(err);
    // },
    // complete: function () {
    //   $("#fetch_btn").html("Fetch");
    //   $("#fetch_btn").prop("disabled", false);
    // },
  });
}
function getOutstandingPositionReport() {
  $("#outstandingposition").html("");
  var as_on_date1 = $("#as_on_date").val();
  var client_type = $("#client_type").val();
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var exchange_segemnt =
    $('input[name="exchange_segment"]:checked').val() || "";

  // validation

  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!as_on_date1) {
    $("#as_on_date_err").html("Please select From Date");
    return false;
  } else {
    $("#as_on_date_err").html("");
  }

  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    //console.log(as_on_daten);
    var datearray1 = as_on_daten.split("/");
    var newas_on_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  var as_on_date = new Date(newas_on_date);

  var formData = {
    as_on_date: yyyymmdd(as_on_date),
    report_name: report_name,
    client_code: client_code,
    client_type: client_type,
    exchange_segemnt: exchange_segemnt,
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-outstanding-position-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      //$('.btn-adv').html("Requesting...");
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      //console.log("Success");

      //data = JSON.parse(data)
      //console.log(data);
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#outstandingposition").html("");
      } else {
        $("#outstandingposition").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      //$('.btn-adv').html("Request");
      $(".ajax-loader").css("display", "none");
    },
  });
}
function getInvestorReport() {
  //alert("Hello");
  $("#investor_report_reponse").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var investor_rep_filter = $("#investor_rep_filter").val();
  var scrip_settl_summery = $("#scrip_settl_summery").val();
  var f_n_o_filter = $("#f_n_o_filter").val() || "";

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    //console.log(from_daten);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    //console.log(to_daten);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
    scrip_settl_summery: scrip_settl_summery,
    investor_rep_filter: investor_rep_filter,
    f_n_o_filter: f_n_o_filter,
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-investor-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#investor_report_reponse").html("");
      } else {
        $("#investor_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function GetunpledgeReport() {
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  var formData = {
    client_code: client_code,
  };
  $.ajax({
    type: "POST",
    url: "/GetunpledgeReport",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#unpledge_response").html("");
      } else {
        $("#unpledge_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}
function GetstatusReport() {
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  var formData = {
    client_code: client_code,
  };
  $.ajax({
    type: "POST",
    url: "/GetstatusReport",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#unpledge_response").html("");
      } else {
        $("#status_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}
function statusdata() {
  var client_code = ""
  var client_code1 = $("#client_code").val();
  var client_code2 = $("#login_id1").val();
  var utype1 = $("#utype1").val();
  var client_code3 = client_code1.substring(0, client_code1.indexOf("-"));
  if (utype1 == "CL") {
    client_code = client_code2
  } else {
    client_code = client_code3
  }
  //console.log( client_code);
  $("#tech-companies-1").empty();
  $.ajax({
    url: "/GetpledgeUnpledgeStatus?client_code=" + client_code + "&id=2",
    type: "Get",
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text", // added data type
    success: function (data) {
      //alert(data)

      $("#tech-companies-1").html(data);
    },
  });

}
function GetpledgeReport() {
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  var formData = {
    client_code: client_code,
  };
  $.ajax({
    type: "POST",
    url: "/GetpledgeReport",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#pledge_response").html("");
      } else {
        $("#pledge_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getDividendReport() {
  $("#dividend_reponse").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
  };
  // console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-dividend-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#dividend_reponse").html("");
      } else {
        $("#dividend_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getDelStatementReport() {
  $("#delStatement_response").html("");
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var trade_date = $("#trade_date").val() || "";
  var settlement = $("#settlement").val();
  var report_name = $("#report_name").val();

  // validation

  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!trade_date) {
    $("#trade_date_err").html("Please select trade date");
    return false;
  } else {
    $("#trade_date_err").html("");
  }
  // if(!settlement){
  // 	$("#settlement_err").html('Please enter settlement')
  // 	return false
  // }else{
  // 	$("#settlement_err").html('')
  // }

  if (trade_date) {
    let trade_daten = formatDate(trade_date);
    var datearray1 = trade_daten.split("/");
    var newtrade_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    trade_date = "";
  }

  var trade_date = new Date(newtrade_date);

  var formData = {
    trade_date: yyyymmdd(trade_date),
    report_name: report_name,
    settlement: settlement || "",
    client_code: client_code,
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-delStatement-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#delStatement_response").html("");
      } else {
        $("#delStatement_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function formatDate(date) {
  var ndate = date.replaceAll("-", "/");
  return ndate;
}

function getTradeListingReport() {
  $("#trade_listing_report_reponse").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var segment_type = $("#segment_type").val();

  var selectedOptionName = $('#segment_type option:selected').attr('name');


  var exchange = $('input[name="exchange"]:checked').val() || "";
  var filter_type = "Scripwise";
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  // validation
  if (client_code == "") {
    $("#trade_listing_report_reponse").html("");
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }
  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }
  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);
  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
    segment_type: segment_type,
    exchange: exchange,
    filter_type: filter_type,
    selectedOptionName: selectedOptionName
  };
  $.ajax({
    type: "POST",
    url: "/get-trade-listing-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      // $('.ajax-loader').css("visibility", "visible");
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      //console.log("Success");
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#trade_listing_report_reponse").html("");
      } else {
        $("#trade_listing_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      // $('.ajax-loader').css("visibility", "hidden");
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getOutstandingBalanceReport() {
  $("#outstandingbalance").html("");
  var as_on_date1 = $("#as_on_date").val();
  var client_code1 = $("#client_code").val();

  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  console.log(client_code)
  var report_name = $("#report_name").val();
  var filter = $('input[name="filter[]"]:checked')
    .map(function () {
      return this.value;
    })
    .get();

  if (!as_on_date1) {
    $("#as_on_date_err").html("Please select From Date");
    return false;
  } else {
    $("#as_on_date_err").html("");
  }

  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    var datearray1 = as_on_daten.split("/");
    var newas_on_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  var as_on_date = new Date(newas_on_date);

  var formData = {
    as_on_date: yyyymmdd(as_on_date),
    report_name: report_name,
    client_code:client_code,
    group_name: client_code,
    filter: filter || "",
  };
  console.log(formData)
  $.ajax({
    type: "POST",
    url: "/get-outstanding-balance-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#outstandingbalance").html("");
      } else {
        $("#outstandingbalance").html(data);
      }
    },
    error: function (err) {
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function GetOutstandingBalanceFUP() {
  $("#outstandingbalance").html("");
  var as_on_date1 = $("#as_on_date").val();
  var client_code1 = $("#client_code").val();
   
 let checked= $('input[name="clientcoderadio"]:checked').val();
  
 if(checked==2 && !client_code1){
         $("#group_code_err").html("Please Enter Group Code");
         return false
  }
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var client_type = $("#client_type").val();

  if (!as_on_date1) {
    $("#as_on_date_err").html("Please select From Date");
    return false;
  } else {
    $("#as_on_date_err").html("");
  }
  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    var datearray1 = as_on_daten.split("/");
    var newas_on_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  var as_on_date = new Date(newas_on_date);

  var formData = {
    as_on_date: yyyymmdd(as_on_date),
    report_name: report_name,
    client_code: client_code || "",
    client_type: client_type,
    group_name:client_code
  };

  $.ajax({
    type: "POST",
    url: "/get-outstanding-balance-followup",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
      $("#group_code_err").html("");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#outstandingbalance").html("");
      } else {
        $("#outstandingbalance").html(data);
      }
    },
    error: function (err) {
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}
function getSqareupReportInReports() {
  $("#trade_listing_report_reponse").html("");
  var as_on_date1 = $("#as_on_date").val();

  var client_code1 = $("#client_code").val();
  var client_code1 = $("#client_code").val();

  let checked= $('input[name="rad"]:checked').val();
  
  if(checked==2 && !client_code1){
          $("#client_code_err").html("Please Enter Client Code");
          return false
   }

  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var period_type = $("#period_type").val();

  if (!as_on_date1) {
    $("#as_on_date_err").html("Please select From Date");
    return false;
  } else {
    $("#as_on_date_err").html("");
  }

  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    var datearray1 = as_on_daten.split("/");
    var newas_on_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  var as_on_date = new Date(newas_on_date);

  var formData = {
    as_on_date: yyyymmdd(as_on_date),
    report_name: report_name,
    client_code: client_code || "",
    period_type: period_type || "",
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-squareup-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#trade_listing_report_reponse").html("");
      } else {
        $("#trade_listing_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getDPHoldingReport() {
  $("#dp_holding_response").html("");
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();

  // validation

  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }

  var formData = {
    report_name: report_name,
    client_code: client_code,
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-dp-hoding-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#dp_holding_response").html("");
      } else {
        $("#dp_holding_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}
function getDP_TransactionReport() {
  $("#dp_transaction_report_reponse").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
  };

  $.ajax({
    type: "POST",
    url: "/get-dp-transaction-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#dp_transaction_report_reponse").html("");
      } else {
        $("#dp_transaction_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}
function getDP_BillReport() {
  $("#dp_bill_report_reponse").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }
  if (!client_code) {
    $("#client_code_err").html("Please enter Client Code");
    return false;
  } else {
    $("#client_code_err").html("");
  }
  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code,
  };

  $.ajax({
    type: "POST",
    url: "/get-dp-bill-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#dp_bill_report_reponse").html("");
      } else {
        $("#dp_bill_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getFilteredResponseOfClientMaster() {
  $("#client_master_reponse").html("");
  var clientFilter = $(".myclient:checked").val();
  var formData = {
    clientFilter: clientFilter,
  };
  $.ajax({
    type: "POST",
    url: "/get-clientMaster-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
      $("#submithanderbtn").attr("disabled",true)
    },
    success: function (data) {
      //console.log("Success");
      //console.log(data);
      $("#client_master_reponse").html(data);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
      $("#submithanderbtn").attr("disabled",false)
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}
function getSqareupReport() {
  $("#trade_listing_report_reponse").html("");
  var as_on_date1 = $("#as_on_date").val();
  var client_code1 = $("#client_code").val();
  let checked= $('input[name="clientcoderadio"]:checked').val();
  if(checked==2 && !client_code1){  
          $("#group_code_err").html("Please Enter Group Code");
          return false
  }
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();
  var period_type = $("#period_type").val();

  if (!as_on_date1) {
    $("#as_on_date_err").html("Please select From Date");
    return false;
  } else {
    $("#as_on_date_err").html("");
  }

  if (as_on_date1) {
    let as_on_daten = formatDate(as_on_date1);
    var datearray1 = as_on_daten.split("/");
    var newas_on_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    as_on_date1 = "";
  }

  var as_on_date = new Date(newas_on_date);

  var formData = {
    as_on_date: yyyymmdd(as_on_date),
    report_name: report_name,
    client_code: client_code || "",
    period_type: period_type || "",
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-squareup-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#trade_listing_report_reponse").html("");
      } else {
        $("#trade_listing_report_reponse").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

function getBrokerageReports() {
  $("#brokerage_response").html("");
  var from_date1 = $("#from_date").val() || "";
  var to_date1 = $("#to_date").val() || "";
  var client_code1 = $("#client_code").val();
  var client_detail = $('input[name="rad"]:checked').val() || "";

  if (client_detail == "client") {
    if (!client_code1) {
      $("#client_code_err").html("Please enter Client Code");
      return false;
    } else {
      $("#client_code_err").html("");
    }
  }
  if (client_code1.indexOf("-") != -1) {
    var client_code = client_code1.substring(0, client_code1.indexOf("-"));
  } else {
    var client_code = client_code1;
  }
  var report_name = $("#report_name").val();

  // validation
  if (Date.parse(from_date1) > Date.parse(to_date1)) {
    $("#to_date_err").html("To date must be greater than from date");
    return false;
  }

  if (!from_date1) {
    $("#from_date_err").html("Please select From Date");
    return false;
  } else {
    $("#from_date_err").html("");
  }
  if (!to_date1) {
    $("#to_date_err").html("Please select To Date");
    return false;
  } else {
    $("#to_date_err").html("");
  }

  if (from_date1) {
    let from_daten = formatDate(from_date1);
    var datearray1 = from_daten.split("/");
    var newfrom_date =
      datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    from_date1 = "";
  }

  if (to_date1) {
    let to_daten = formatDate(to_date1);
    var datearray1 = to_daten.split("/");
    var newto_date = datearray1[1] + "/" + datearray1[0] + "/" + datearray1[2];
  } else {
    to_date1 = "";
  }

  var from_date = new Date(newfrom_date);
  var to_date = new Date(newto_date);

  var formData = {
    from_date: yyyymmdd(from_date),
    to_date: yyyymmdd(to_date),
    report_name: report_name,
    client_code: client_code || "",
  };
  //console.log(formData);

  $.ajax({
    type: "POST",
    url: "/get-company-performance-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(".ajax-loader").css("display", "flex");
    },
    success: function (data) {
      if (data == "Created") {
        $("#client_code_err").html("invalid Client Code.");
        $("#brokerage_response").html("");
      } else {
        $("#brokerage_response").html(data);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $(".ajax-loader").css("display", "none");
    },
  });
}

// ================================================ Add New User js ===================================================
function AddNewUser() {
  var User_type = $("#User_type").val();
  var user_State = $("#user_State").val();
  var user_City = $("#user_City").val();
  var Branch_Id = $("#Branch_Id").val();
  var RMBranch_Id = $("#MLP_Branch_Id").val();

  var client_branch_id = $("#client_branch_id").val();
  var AP_Name = $("#AP_Name").val();
  var Group_Id = $("#Group_Id").val();
  var client_code = $("#client_code1").val();
  var user_name = $("#user_name").val();
  var email = $("#signup_email").val();
  var mobileNo = $("#mobile_number").val();
  var login_Id = $("#user_Id").val();

  var formData = {
    User_type: User_type,
    user_State: user_State,
    user_City: user_City,
    Branch_Id: Branch_Id,
    RMBranch_Id: RMBranch_Id,
    client_branch_id: client_branch_id,
    AP_Name: AP_Name,
    Group_Id: Group_Id,
    client_code: client_code.split('-')[0],
    user_name: user_name,
    email: email,
    mobileNo: mobileNo,
    login_Id: login_Id,
  };
  //console.log(formData)
  $.ajax({
    type: "POST",
    url: "/save-user",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {

      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
        setTimeout(function () {
          $(".alert").fadeOut("slow");
        }, 1000);
      }
    },
  });
}
function editNewUser(id) {
  var formData = {
    id: id,
  };

  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-user",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {

        //console.log(res.data);

        $("#User_type").val(res.data.role_id).attr("disabled", true);
        $("#user_State").val(res.data.user_State).attr("disabled", true);
        $("#user_City").val(res.data.user_City).attr("disabled", true);
        $("#Branch_Id").val(res.data.Branch_Id).attr("disabled", true);
        //$("#MLP_Branch_Id").val(res.data.Branch_Id).attr("disabled", true);
        $("#AP_Name").val(res.data.AP_Name).attr("disabled", true);
        $("#Group_Id").val(res.data.Group_Id).attr("disabled", true);
        $("#client_code1").val(res.data.client_code).attr("disabled", true);
        $("#user_name").val(res.data.user_name);
        $("#mobile_number").val(res.data.mobileNo);
        $("#signup_email").val(res.data.email);
        $("#user_Id").val(res.data.login_Id).attr("disabled", true);


        $("#submit").html(
          '<input type="submit" class="custom-primary-btn " value="update"  >'
        );
        $("#h4").html("Edit user");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "updateNewUser('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function updateNewUser(id) {
  var User_type = $("#User_type").val();
  var user_State = $("#user_State").val();
  var user_City = $("#user_City").val();
  var Branch_Id = $("#Branch_Id").val();
  var AP_Name = $("#AP_Name").val();
  var Group_Id = $("#Group_Id").val();
  var client_code = $("#client_code1").val();
  var user_name = $("#user_name").val();
  var email = $("#signup_email").val();
  var mobileNo = $("#mobile_number").val();
  var login_Id = $("#user_Id").val();
  var role = $("#role_id").val();

  var formData = {
    User_type: User_type,
    user_State: user_State,
    user_City: user_City,
    Branch_Id: Branch_Id,
    AP_Name: AP_Name,
    Group_Id: Group_Id,
    client_code: client_code,
    user_name: user_name,
    email: email,
    mobileNo: mobileNo,
    login_Id: login_Id,
    id: id,
    role: role,
  };
  $.ajax({
    type: "POST",
    url: "/update-user",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function deleteNewUser(id, type) {
  let msg = "";
  if (type == 1) {
    msg = "Are you sure you want to delete this user?";
  } else {
    msg = "Are you sure you want to active this user?";
  }
  if (confirm(msg)) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-user",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        if (data.statuscode == 200) {
          if (data.status == "success") {
            $(".alert-danger").css("display", "none");
            $(".alert-success").css("display", "block").text(data.message);
          } else {
            $(".alert-danger").css("display", "block").text(data.message);
            $(".alert-success").css("display", "none");
          }
          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 500);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

function gecity() {
  var user_State = $("#user_State").val();
  var formData = {
    s_id: user_State,
  };
  $.ajax({
    type: "POST",
    url: "/getCitylist",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        var city = JSON.parse(JSON.stringify(data));

        $("#user_City").html("");
        var html = '<option value="">SELECT CITY</option>';
        // var html = '<option value="">  </option>';
        $.each(city.data, function (i, val) {
          html += '<option value="' + val._id + '">' + val.city + "</option>";
        });
        $("#user_City").html(html);
        if (user_City != null) {
          $("#user_City").val(user_City).trigger("change");
        }
      } else {
      }
    },
  });
}


// ================================================ end Add New User js ================================================

// ================================================ Add Branch js ===================================================

function Add_branch() {
  var branchid = $("#Branch_Id").val();
  var branch_name = $("#branch_name").val();
  var email = $("#email").val();
  var mobileNo = $("#mobile_number").val();
  // var branch_Id = $("#branch_Id").val();

  var formData = {
    branchid: branchid,
    branch_name: branch_name,
    email: email,
    mobileNo: mobileNo,
  };
  $.ajax({
    type: "POST",
    url: "/save-branch",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 500);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}
function edit_branch(id) {
  var formData = {
    id: id,
  };

  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-branch",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        //console.log(res + "");

        //$("#User_type").val(res.data.role_id).attr('disabled', true);

        $("#Branch_Id").val(res.data.branchid).attr("disabled", true);

        $("#branch_name").val(res.data.branch_name);
        $("#mobile_number").val(res.data.mobileNo);
        $("#email").val(res.data.email);
        //$("#user_Id").val(res.data.login_Id)
        $("#submit").html("Update");
        $("#h2").html("Edit SubMenu");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "update_branch('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function update_branch(id) {
  var branchid = $("#Branch_Id").val();
  var branch_name = $("#branch_name").val();
  var email = $("#email").val();
  var mobileNo = $("#mobile_number").val();
  // var branch_Id = $("#branch_Id").val();

  var formData = {
    branchid: branchid,
    branch_name: branch_name,
    email: email,
    id: id,
    mobileNo: mobileNo,
  };
  $.ajax({
    type: "POST",
    url: "/update-branch",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function delete_branch(id, type) {
  let msg = "";
  if (type == 1) {
    msg = "Are you sure you want to delete this branch?";
  } else {
    msg = "Are you sure you want to active this branch?";
  }
  if (confirm(msg)) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-branch",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        if (data.statuscode == 200) {
          if (data.status == "success") {
            $(".alert-danger").css("display", "none");
            $(".alert-success").css("display", "block").text(data.message);
          } else {
            $(".alert-danger").css("display", "block").text(data.message);
            $(".alert-success").css("display", "none");
          }

          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 500);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

function getGroup_list() {
  var Branch_Id = $("#Branch_Id").val();
  const Usertype1 = $('#User_type').find(":selected").text();
  let Usertype = Usertype1.trim()
  var formData = {
    Branch_Id: Branch_Id,
  };
  if (Usertype == "AP") {
    $("#user_Id").val("")
    $("#user_name").val("")
    $("#mobile_number").val("")
    $("#signup_email").val("")

  } else {
    if (Branch_Id != "") {
      $.ajax({
        type: "POST",
        url: "/getgrouplist",
        data: JSON.stringify(formData),
        contentType: "application/json",
        dataType: "json",
        success: function (data) {
          //console.log(data);
          if (data.status == "success") {
            var Group_ID = JSON.parse(JSON.stringify(data));

            $("#Group_Id").html("");
            var html = '<option value="">SELECT GROUP</option>';
            // var html = '<option value="">  </option>';
            $.each(Group_ID.data, function (i, val) {
              html +=
                '<option value="' + val._id + '">' + val.Group_ID + "</option>";
            });
            $("#Group_Id").html(html);
            $("#user_Id").val("").attr("disabled", true);
            $("#user_name").val("").attr("disabled", true);
            $("#mobile_number").val("").attr("disabled", true);
            $("#signup_email").val("").attr("disabled", true);
            if (Group_Id != null) {
              $("#Group_Id").val(Group_Id).trigger("change");
            }
          } else {
          }
        },
      });
    } else {
      $("#Group_Id").html("<option value=''>SELECT GROUP</option>");
      $("#user_Id").val("").attr("disabled", true);
      $("#user_name").val("").attr("disabled", true);
      $("#mobile_number").val("").attr("disabled", true);
      $("#signup_email").val("").attr("disabled", true);
    }
  }
}

// ================================================ end Add Branch js ================================================

// ================================================ Group js ===================================================

function Add_Group() {
  var branchid = $("#Branch_Id").val();
  var Group_name = $("#Group_name").val();
  var email = $("#email").val();
  var mobileNo = $("#mobile_number").val();
  var Group_Id = $("#Group_Id").val();

  var formData = {
    branchid: branchid,
    Group_name: Group_name,
    email: email,
    Group_Id: Group_Id,
    mobileNo: mobileNo,
  };
  $.ajax({
    type: "POST",
    url: "/save-group",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 500);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}
function edit_Group(id) {
  var formData = {
    id: id,
  };

  var formData = {
    id: id,
  };

  $.ajax({
    type: "POST",
    url: "/edit-group",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (res) {
      if (res.status == "success") {
        //console.log(res);

        //$("#User_type").val(res.data.role_id).attr('disabled', true);

        $("#Branch_Id").val(res.data.branchid).attr("disabled", true);
        $("#Group_Id").val(res.data.Group_Id).attr("disabled", true);
        $("#Group_name").val(res.data.Group_name).attr("disabled", true);
        $("#mobile_number").val(res.data.mobileNo);
        $("#email").val(res.data.email);
        //$("#user_Id").val(res.data.login_Id)
        $("#submit").html("Update");
        $("#h4").html("Edit group");
        $("#reset").html(
          '<input type="reset" onclick="location.reload();" class="btn btn-default"value="Reset">'
        );
        $("#submit").attr("onclick", "update_Group('" + res.data._id + "')");
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

function update_Group(id) {
  var branchid = $("#Branch_Id").val();
  var Group_Id = $("#Group_Id").val();
  var Group_name = $("#Group_name").val();
  var email = $("#email").val();
  var mobileNo = $("#mobile_number").val();
  // var branch_Id = $("#branch_Id").val();

  var formData = {
    branchid: branchid,
    Group_Id: Group_Id,
    Group_name: Group_name,
    email: email,
    id: id,
    mobileNo: mobileNo,
  };
  $.ajax({
    type: "POST",
    url: "/update-group",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    success: function (data) {
      //console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.reload();
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}
function delete_Group(id, type) {
  let msg = "";
  if (type == 1) {
    msg = "Are you sure you want to delete this Group?";
  } else {
    msg = "Are you sure you want to active this Group?";
  }
  if (confirm(msg)) {
    var formData = {
      id: id,
    };
    $.ajax({
      type: "POST",
      url: "/delete-group",
      data: JSON.stringify(formData),
      contentType: "application/json",
      dataType: "json",
      success: function (data) {
        if (data.statuscode == 200) {
          if (data.status == "success") {
            $(".alert-danger").css("display", "none");
            $(".alert-success").css("display", "block").text(data.message);
          } else {
            $(".alert-danger").css("display", "block").text(data.message);
            $(".alert-success").css("display", "none");
          }

          setTimeout(function () {
            location.reload();
            $(".alert").fadeOut("slow");
          }, 500);
        } else {
          $(".alert-success").css("display", "none");
          $(".alert-danger").css("display", "block").text(data.message);
        }
      },
    });
  }
}

// ================================================ Group js ================================================

// ================================================ Reset password js ===================================================

function ResetPassword() {
  var New_Password = $("#New_Password").val();
  var email = $("#email").val();
  var Old_Password = $("#Old_Password").val();
  var Conform_New_Password = $("#Conform_New_Password").val();
  var formData = {
    email: email,
    Old_Password: Old_Password,
    New_Password: New_Password,
    Conform_New_Password: Conform_New_Password,
  };
  $.ajax({
    type: "POST",
    url: "/reset_pass",
    data: JSON.stringify(formData),
    contentType: "application/json",
    dataType: "json",
    error: function (xhr, status, error) {
      const message = (xhr.responseJSON.message);
      // console.log(message)
      $(".alert-danger").html(message).css("display", "block");
    },
    success: function (data) {
      // console.log(data);
      if (data.status == "success") {
        $(".alert-danger").css("display", "none");
        $(".alert-success").css("display", "block").text(data.message);
        setTimeout(function () {
          location.href = "/login";
          $(".alert").fadeOut("slow");
        }, 1000);
      } else {
        $(".alert-success").css("display", "none");
        $(".alert-danger").css("display", "block").text(data.message);
      }
    },
  });
}

// ================================================ end Reset password js ================================================

// DASHBOARD START TOP
function HomeLiveTrades(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "39",
  };
  $.ajax({
    type: "POST",
    url: "/home-live-trades",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $("#live-hide-show").addClass("d-block");
      $("#live_index_trade").html(``);
    },
    success: function (data) {
      // console.log(data)
      // console.log("Success");
      $("#live-hide-show").removeClass("d-block");
      $("#live_index_trade").html(data);
      $("#collapse1").removeClass("in");
      $("#collapse2").addClass("in");
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $("#fetch").html("Fetch");
      $("#fetch").prop("disabled", false);
    },
  });
}

function HomeHoldingValue(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "35",
  };
  $.ajax({
    type: "POST",
    url: "/home-holding-value",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $("#holding-hide-show").addClass("d-block");
      $("#home-holding-value").html(``);
    },
    success: function (data) {
      // console.log(data)
      // console.log("success")
      $("#holding-hide-show").removeClass("d-block");
      $(`#home-holding-value`).html(data);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $("#fetch").html("Fetch");
      $("#fetch").prop("disabled", false);
    },
  });
}

function HomeFOPosition(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "36",
  };
  $.ajax({
    type: "POST",
    url: "/home-fo-position",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $("#home-fo-value").html("Requesting...");
      $("#home-fo-value").prop("disabled", true);
    },
    success: function (data) {
      // console.log(data)
      // console.log("success")
      $(`#home-fo-value`).html(data);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $("#fetch").html("Fetch");
      $("#fetch").prop("disabled", false);
    },
  });
}
function HomeCurrPosition(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "37",
  };
  $.ajax({
    type: "POST",
    url: "/home-curr-position",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $("#home-curr-value").html("Requesting...");
      $("#home-curr-value").prop("disabled", true);
    },
    success: function (data) {
      $(`#home-curr-value`).html(data);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () {
      $("#fetch").html("Fetch");
      $("#fetch").prop("disabled", false);
    },
  });
}
function HomeCommPosition(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: $("#RepNo").val() || "38",
  };
  $.ajax({
    type: "POST",
    url: "/home-comm-position",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $("#home-comm-value").html("Requesting...");
      $("#home-comm-value").prop("disabled", true);
    },
    success: function (data) {
      // console.log(data,"COMM")
      // console.log("success")
      $(`#home-comm-value`).html(data);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
    complete: function () { },
  });
}

function HomeLedgerTopValue(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    clientFilter: "",
    client_code: "",
  };

  $.ajax({
    type: "POST",
    url: "/home-ledger-top-value",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#ledger-top-dashboard`)
        .html(`<div class="spinner-border text-danger" role="status">
             <span class="visually-hidden">Loading...</span>
        </div>`);
    },
    success: function (data) {
      let ledger_data = JSON.parse(data);
      //console.log(ledger_data, "HELLO LEDGER");
      if (ledger_data.ledgerStatus == 1) {
        $(`#ledger-top-dashboard`).html(
          new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
            ledger_data.ledger_balance
          )
        );
      } else {
        $(`#ledger-top-dashboard`).html(ledger_data.ledger_balance);
      }
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function HomeHoldingTop(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: "35",
  };
  $.ajax({
    type: "POST",
    url: "/home-holding-top",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#holding-top-dashboard`)
        .html(`<div class="spinner-border text-danger" role="status">
              <span class="visually-hidden">Loading...</span>
         </div>`);
    },
    success: function (data) {
      let data2 = JSON.parse(data);
      let data3 = data2.data;
      let total_value = 0;
      let total_pl = 0;
      let addClPL = "down-up";
      for (let i = 0; i < data3.recordsets.length; i++) {
        let dats = data3.recordsets[i];
        for (let a = 0; a < dats.length; a++) {
          total_value += Number(dats[a].LiqValue);
          total_pl +=
            (Number(dats[a].CMP) - Number(dats[a].BuyRate)) *
            Number(dats[a].BOD);
        }
      }
      if (total_pl < 0) {
        addClPL = "down-arrow";
      } else if (total_pl == 0) {
        addClPL = "";
      }
      $(`#holding-top-dashboard`).html(
        new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
          total_value
        )
      );
      pnl = new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
        Number(total_pl).toFixed(2)
      );
      $(`#holding-pl-dashboard`).html(pnl).addClass(addClPL);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function HomeFOTop(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: "36",
  };
  $.ajax({
    type: "POST",
    url: "/home-holding-top",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#home-fo-top-value`)
        .html(`<div class="spinner-border text-danger" role="status">
             <span class="visually-hidden">Loading...</span>
        </div>`);
    },
    success: function (data) {
      let data2 = JSON.parse(data);
      let data3 = data2.data;
      let total_value = 0;
      let total_pl = 0;
      let addClPL = "down-up";
      for (let i = 0; i < data3.recordsets.length; i++) {
        let dats = data3.recordsets[i];
        for (let a = 0; a < dats.length; a++) {
          total_value += Number(dats[a].LiqValue);
          total_pl +=
            (Number(dats[a].CMP) - Number(dats[a].BuyRate)) *
            Number(dats[a].BOD);
        }
      }
      if (total_pl < 0) {
        addClPL = "down-arrow";
      } else if (total_pl == 0) {
        addClPL = "";
      }
      $(`#home-fo-top-value`).html(
        new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
          total_value
        )
      );
      $(`#fo-pl-dashboard`)
        .html(
          new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
            total_pl
          )
        )
        .addClass(addClPL);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function HomeCurrTop(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: "37",
  };
  $.ajax({
    type: "POST",
    url: "/home-holding-top",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#home-curr-top-value`)
        .html(`<div class="spinner-border text-danger" role="status">
             <span class="visually-hidden">Loading...</span>
        </div>`);
    },
    success: function (data) {
      let data2 = JSON.parse(data);
      let data3 = data2.data;
      let total_value = 0;
      let total_pl = 0;
      let addClPL = "down-up";
      for (let i = 0; i < data3.recordsets.length; i++) {
        let dats = data3.recordsets[i];
        for (let a = 0; a < dats.length; a++) {
          total_value += Number(dats[a].LiqValue);
          total_pl +=
            (Number(dats[a].CMP) - Number(dats[a].BuyRate)) *
            Number(dats[a].BOD);
        }
      }
      if (total_pl < 0) {
        addClPL = "down-arrow";
      } else if (total_pl == 0) {
        addClPL = "";
      }
      $(`#home-curr-top-value`).html(
        new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
          total_value
        )
      );
      $(`#cp-pl-dashboard`)
        .html(
          new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
            total_pl
          )
        )
        .addClass(addClPL);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function HomeCommTop(clientdashboard = "") {
  var formData = {
    FromDt: $("#FromDt").val(),
    ToDt: $("#ToDt").val(),
    txt1: clientdashboard || "",
    txt2: $("#txt2").val() || "",
    txt3: $("#txt3").val() || "",
    Fil1Num: $("#Fil1Num").val() || 0,
    Fil2Num: $("#Fil2Num").val() || 0,
    Fil3Num: $("#Fil3Num").val() || 0,
    Fil1LBL: $("#Fil1LBL").val() || "",
    Fil2LBL: $("#Fil2LBL").val() || "",
    Fil3LBL: $("#Fil3LBL").val() || "",
    Fil1Cmb: $("#Fil1Cmb").val() || "",
    Fil2Cmb: $("#Fil2Cmb").val() || "",
    Fil3Cmb: $("#Fil3Cmb").val() || "",
    RepNo: "38",
  };
  $.ajax({
    type: "POST",
    url: "/home-holding-top",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#home-comm-top-value`)
        .html(`<div class="spinner-border text-danger" role="status">
             <span class="visually-hidden">Loading...</span>
        </div>`);
    },
    success: function (data) {
      let data2 = JSON.parse(data);
      let data3 = data2.data;
      let total_value = 0;
      let total_pl = 0;
      let addClPL = "down-up";
      for (let i = 0; i < data3.recordsets.length; i++) {
        let dats = data3.recordsets[i];
        for (let a = 0; a < dats.length; a++) {
          total_value += Number(dats[a].LiqValue);
          total_pl +=
            (Number(dats[a].CMP) - Number(dats[a].BuyRate)) *
            Number(dats[a].BOD);
        }
      }
      //console.log("D", total_pl);
      if (total_pl < 0) {
        addClPL = "down-arrow";
      } else if (total_pl == 0) {
        addClPL = "";
      }
      $(`#home-comm-top-value`).html(
        new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
          total_value
        )
      );
      $(`#co-pl-dashboard`)
        .html(
          new Intl.NumberFormat("en-IN", { minimumFractionDigits: 2 }).format(
            total_pl
          )
        )
        .addClass(addClPL);
    },
    error: function (err) {
      console.log("Error  ");
      console.log(err);
    },
  });
}

function HomeBalances() {
  const today = new Date();
  const year = today.getFullYear();
  const month = String(today.getMonth() + 1).padStart(2, "0"); // Months are zero-based
  const day = String(today.getDate()).padStart(2, "0");
  const currentDate = `${year}${month}${day}`;
  var formData = {
    as_on_date: currentDate,
    report_name: "OutstandingBalance",
    client_code: "",
    filter: "",
  };
  $.ajax({
    type: "POST",
    url: "/home-outstanding-balance-report",
    data: JSON.stringify(formData),
    contentType: "application/json",
    Accept: "application/text",
    dataType: "text",
    beforeSend: function () {
      $(`#home-balances-values`)
        .html(`<div class="spinner-border text-danger" role="status">
             <span class="visually-hidden">Loading...</span>
        </div>`);
    },
    success: function (data) {
      // console.log("success", data);
      $(`#home-balances-values`).html(data);
    },
    error: function (err) {
      console.log(err);
    },
  });
}

// DASHBOARD END TOP