首页 > 解决方案 > 我必须在 html、php、javascript 中给出一些依赖字段

问题描述

我需要在这些领域给予一些依赖。例如:首先我有两个选项,即分支机构/员工,所以,如果我选择分支机构,它应该显示分支机构以选择他是否选择员工,那么我应该能够选择员工 ID,如果选择员工 ID,员工姓名应该显示以及更多用户需要提供数据的所有这些东西。那是主要类别的分支机构/员工应该是标准的,但在分支机构之后,员工编号和姓名所有这些用户需要提供的东西

<!DOCTYPE html>
<html>
 <head>
    <script type="text/javascript">
function updatePrice() {
      // Get the ex-GST price from its form element
var exPrice = document.getElementById("product_price").value;
var gstPrice = document.getElementById("cgst").value;

// Get the GST price
gstPrice = exPrice * 0.09;
var TPrice = parseInt(gstPrice) + parseInt(exPrice) + parseInt(gstPrice);

// Set the GST price in its form element
document.getElementById("cgst").value = gstPrice;
document.getElementById("igst").value = gstPrice;
document.getElementById("sgst").value = 0;
document.getElementById("total").value = TPrice;

}
</script>

</head>
<body>
<?php
public function addProduct($pro_name,$price,$stock,$date,$loc,$in_no,$gst_no,$cgst,$sgst,$igst,$total,$depre,$pur_from){
        $pre_stmt = $this->con->prepare("INSERT INTO `products`( `product_name`, `product_price`, `product_stock`, `added_date`, `p_status`, `loc`, `in_no`, `gst_no`, `cgst`, `sgst`, `igst`, `total`, `depre`, `pur_from`) 
             VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

            $status = 1;            

        $pre_stmt->bind_param("sdisisiiddddis",$cid,$bid,$pro_name,$price,$stock,$date,$status,$loc,$in_no,$gst_no,$cgst,$sgst,$igst,$total,$depre,$pur_from);
        $result = $pre_stmt->execute() or die($this->con->error);
        if ($result) {
            return "NEW_PRODUCT_ADDED";
        }else{
            return 0;
        }

    }
  if (isset($_POST["added_date"]) AND isset($_POST["product_name"]) ) {
    $obj = new DBOperation();
    $result = $obj->addProduct($_POST["select_cat"],
                            $_POST["select_brand"],
                            $_POST["product_name"],
                            $_POST["product_price"],
                            $_POST["product_qty"],
                            $_POST["added_date"],
                            $_POST["loc"],
                            $_POST["in_no"],
                            $_POST["gst_no"],
                            $_POST["cgst"],
                            $_POST["sgst"], 
                            $_POST["igst"],
                            $_POST["total"],
                            $_POST["depre"],                
                            $_POST["pur_from"]);
    echo $result;
    exit();
}
?>
<div class="modal fade" id="form_products" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Add new products</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <form id="product_form" onsubmit="return false">
        <div class="form-group">
            <label>Category</label>
            <select class="form-control" id="select_cat" name="select_cat" required/>



            </select>
          </div>
          <div class="form-group">
            <label>Brand</label>
            <select class="form-control" id="select_brand" name="select_brand" required/>



            </select>
          </div>
          <div class="form-row">

                    <div class="form-group col-md-6">
              <label>RHFL ID</label>
              <input type="text" class="form-control" name="product_name" id="product_name" placeholder="Enter RHFL ID" required>
            </div>
            <div class="form-group col-md-6">
              <label>Invoice No</label>
              <input type="text" class="form-control" name="in_no" id="in_no" placeholder="Enter Invoice No" required>
            </div> 
          </div>
          <div class="form-row">
          <div class="form-group col-md-6">

            <label>Location</label>
            <input type="text" class="form-control" id="loc" name="loc" placeholder="Enter Location" required/>
          </div>
          <div class="form-group col-md-6">
                    <label>Purchase Date</label>
            <input type="text" class="form-control" id="added_date" name="added_date" value="<?php echo date("Y-m-d"); ?>" readonly/>
                    </div>

          </div>
          <div class="form-row">
            <div class="form-group col-md-6">
            <label>Product Price</label>
            <input type="text" class="form-control" id="product_price" name="product_price" onChange="updatePrice()" />
          </div>
            <div class="form-group col-md-6">
              <label>GST No</label>
  <input type="text" class="form-control" id="gst_no" name="gst_no" placeholder="Enter GST No" required/>
            </div>


          </div>


          <div class="form-row">
              <div class="form-group col-md-6">
            <label>Purchased From</label>
            <input type="text" class="form-control" id="pur_from" name="pur_from" placeholder="Enter From Where you purchased" required/>
          </div> 
          <div class="form-group col-md-6">
            <label>IGST</label>
            <input type="text" class="form-control" id="igst" name="igst" onChange="updatePrice()" />
          </div>

           </div> 
           <div class="form-row">
           <div class="form-group col-md-6">
            <label for="cgst">CGST</label>
            <input type="text" class="form-control" id="cgst" name="cgst" readonly name="cgst" onChange="updatePrice()" />
          </div>






          <div class="form-group col-md-6">
            <label>SGST</label>
            <input type="text" class="form-control" id="sgst" name="sgst" onChange="updatePrice()" />
          </div>
          </div>
           <div class="form-row">

          <div class="form-group col-md-6">
            <label>Quantity</label>
            <input type="text" class="form-control" id="product_qty" name="product_qty" placeholder="Enter Quantity" required/>
          </div>
          <div class="form-group col-md-6">
            <label>Depreciation</label>
            <input type="text" class="form-control" id="depre" name="depre" placeholder="Enter Price of SGST" required/>
          </div>
          </div>
          <div class="form-group">

            <label>Total</label>
            <input type="text" class="form-control" id="total" name="total" onChange="updatePrice(this.form)" />

          </div>
          <button type="submit" class="btn btn-success">Add Product</button>
        </form>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>
</body>
//add product
    $("#product_form").on("submit",function(){
        $.ajax({
                url : DOMAIN+"/includes/process.php",
                method : "POST",
                data : $("#product_form").serialize(),
                success : function(data){
                    if (data == "NEW_PRODUCT_ADDED") {
                        alert("New Product Added Successfully..!");
                        $("#product_name").val("");
                        $("#select_cat").val("");
                        $("#select_brand").val("");
                        $("#product_price").val("");
                        $("#product_qty").val("");
                        calculate();
                    }else{
                        console.log(data);
                        alert(data);
                    }

                }
            })
    })

标签: javascriptphphtml

解决方案


推荐阅读