Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connect = mysqli_connect("localhost", "root", "", "omegadb");
- session_start();
- $staff_no = $_SESSION['staff_no'];
- ?>
- <?php
- if(isset($_POST['insert_btn']))
- {
- $cust_code = $_POST["cust_code"];
- $delivery_term = $_POST["delivery_term"];
- $sales_agent = $_POST["sales_agent"];
- $credit_term = $_POST["credit_term"];
- foreach ($_POST['item_code'] as $index => $item_code)
- {
- $a = mysqli_real_escape_string($connect,$_POST['item_code'][$index]);
- $b = mysqli_real_escape_string($connect,$_POST['unit_price'][$index]);
- $c = mysqli_real_escape_string($connect,$_POST['discount'][$index]);
- $d = mysqli_real_escape_string($connect,$_POST['sub_total'][$index]);
- $e = mysqli_real_escape_string($connect,$_POST['gst'][$index]);
- $f = mysqli_real_escape_string($connect,$_POST['total_exc'][$index]);
- $g = mysqli_real_escape_string($connect,$_POST['total_inc'][$index]);
- }
- $sql = "INSERT INTO quotation (cust_code, delivery_term, sales_agent, credit_term, item_code, unit_price, discount, sub_total, gst, total_exc, total_inc) VALUES
- ('".$a."','".$b."','".$c."','".$d."','".$e."','".$f."','".$g."')";
- $result = mysqli_query($connect, $sql);
- if($result)
- {
- echo '<script language="javascript">alert("Successfully registered !!")</script>';
- //print "<meta http-equiv='refresh' content='0;url=marco2.php'>";
- }
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
- <meta name="description" content="">
- <meta name="author" content="">
- <title>SB Admin 2 - Dashboard</title>
- <!-- Custom fonts for this template-->
- <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
- <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
- <!-- Custom styles for this template-->
- <link href="css/sb-admin-2.min.css" rel="stylesheet">
- <script language="javascript" src="js/jquery.min.js"></script>
- </head>
- <body id="page-top">
- <!-- Page Wrapper -->
- <div id="wrapper">
- <!-- Sidebar -->
- <ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion" id="accordionSidebar">
- <!-- Sidebar - Brand -->
- <a class="sidebar-brand d-flex align-items-center justify-content-center" href="index.html">
- <div class="sidebar-brand-icon">
- <img src="image/Omega-Logo.png" width="80%"></img>
- </div>
- <div class="sidebar-brand-text mx-3">OMS</div>
- </a>
- <!-- Nav Item - Dashboard -->
- <li class="nav-item active">
- <a class="nav-link" href="sales_index.php">
- <i class="fas fa-fw fa-tachometer-alt"></i>
- <span>Dashboard</span></a>
- </li>
- <!-- Nav Item - Pages Collapse Menu -->
- <li class="nav-item active">
- <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">
- <i class="fas fa-fw fa-cog"></i>
- <span>Marco</span>
- </a>
- <div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionSidebar">
- <div class="bg-white py-2 collapse-inner rounded">
- <a class="collapse-item" href="marco1.php">Register Drawing</a>
- <a class="collapse-item" href="marco_search.php">Update Drawing</a>
- </div>
- </div>
- </li>
- <!-- Nav Item - Utilities Collapse Menu -->
- <li class="nav-item active">
- <a class="nav-link collapsed" href="quotation.php">
- <i class="fas fa-fw fa-file-invoice"></i>
- <span>Quotation</span>
- </a>
- </li>
- <li class="nav-item active">
- <a class="nav-link collapsed" href="sales_order.php">
- <i class="fas fa-fw fa-money-check-alt"></i>
- <span>Sales Order</span>
- </a>
- </li>
- <!-- Divider -->
- <hr class="sidebar-divider">
- <!-- Heading -->
- <div class="sidebar-heading">
- Addons
- </div>
- <!-- Nav Item - Pages Collapse Menu -->
- <li class="nav-item">
- <a class="nav-link collapsed" href="#" data-toggle="collapse" data-target="#collapsePages" aria-expanded="true" aria-controls="collapsePages">
- <i class="fas fa-fw fa-folder"></i>
- <span>Pages</span>
- </a>
- <div id="collapsePages" class="collapse" aria-labelledby="headingPages" data-parent="#accordionSidebar">
- <div class="bg-white py-2 collapse-inner rounded">
- <h6 class="collapse-header">Login Screens:</h6>
- <a class="collapse-item" href="login.html">Login</a>
- <a class="collapse-item" href="register.html">Register</a>
- <a class="collapse-item" href="forgot-password.html">Forgot Password</a>
- <div class="collapse-divider"></div>
- <h6 class="collapse-header">Other Pages:</h6>
- <a class="collapse-item" href="404.html">404 Page</a>
- <a class="collapse-item" href="blank.html">Blank Page</a>
- </div>
- </div>
- </li>
- <!-- Nav Item - Charts -->
- <li class="nav-item">
- <a class="nav-link" href="charts.html">
- <i class="fas fa-fw fa-chart-area"></i>
- <span>Charts</span></a>
- </li>
- <!-- Nav Item - Tables -->
- <li class="nav-item">
- <a class="nav-link" href="tables.html">
- <i class="fas fa-fw fa-table"></i>
- <span>Tables</span></a>
- </li>
- <!-- Divider -->
- <hr class="sidebar-divider d-none d-md-block">
- <!-- Sidebar Toggler (Sidebar) -->
- <div class="text-center d-none d-md-inline">
- <button class="rounded-circle border-0" id="sidebarToggle"></button>
- </div>
- </ul>
- <!-- End of Sidebar -->
- <!-- Content Wrapper -->
- <div id="content-wrapper" class="d-flex flex-column">
- <!-- Main Content -->
- <div id="content">
- <!-- Topbar -->
- <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
- <!-- Sidebar Toggle (Topbar) -->
- <button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3">
- <i class="fa fa-bars"></i>
- </button>
- <!-- Topbar Search -->
- <form class="d-none d-sm-inline-block form-inline mr-auto ml-md-3 my-2 my-md-0 mw-100 navbar-search">
- <div class="input-group">
- <input type="text" class="form-control bg-light border-0 small" placeholder="Search for..." aria-label="Search" aria-describedby="basic-addon2">
- <div class="input-group-append">
- <button class="btn btn-primary" type="button">
- <i class="fas fa-search fa-sm"></i>
- </button>
- </div>
- </div>
- </form>
- <!-- Topbar Navbar -->
- <ul class="navbar-nav ml-auto">
- <!-- Nav Item - Search Dropdown (Visible Only XS) -->
- <li class="nav-item dropdown no-arrow d-sm-none">
- <a class="nav-link dropdown-toggle" href="#" id="searchDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
- <i class="fas fa-search fa-fw"></i>
- </a>
- <!-- Dropdown - Messages -->
- <div class="dropdown-menu dropdown-menu-right p-3 shadow animated--grow-in" aria-labelledby="searchDropdown">
- <form class="form-inline mr-auto w-100 navbar-search">
- <div class="input-group">
- <input type="text" class="form-control bg-light border-0 small" placeholder="Search for..." aria-label="Search" aria-describedby="basic-addon2">
- <div class="input-group-append">
- <button class="btn btn-primary" type="button">
- <i class="fas fa-search fa-sm"></i>
- </button>
- </div>
- </div>
- </form>
- </div>
- </li>
- <div class="topbar-divider d-none d-sm-block"></div>
- <!-- Nav Item - User Information -->
- <li class="nav-item dropdown no-arrow">
- <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
- <span class="mr-2 d-none d-lg-inline text-gray-600 small">Valerie Luna</span>
- <img class="img-profile rounded-circle" src="https://source.unsplash.com/QAB-WJcbgJk/60x60">
- </a>
- <!-- Dropdown - User Information -->
- <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in" aria-labelledby="userDropdown">
- <a class="dropdown-item" href="#">
- <i class="fas fa-user fa-sm fa-fw mr-2 text-gray-400"></i>
- Profile
- </a>
- <a class="dropdown-item" href="#">
- <i class="fas fa-cogs fa-sm fa-fw mr-2 text-gray-400"></i>
- Settings
- </a>
- <a class="dropdown-item" href="#">
- <i class="fas fa-list fa-sm fa-fw mr-2 text-gray-400"></i>
- Activity Log
- </a>
- <div class="dropdown-divider"></div>
- <a class="dropdown-item" href="#" data-toggle="modal" data-target="#logoutModal">
- <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i>
- Logout
- </a>
- </div>
- </li>
- </ul>
- </nav>
- <!-- End of Topbar -->
- <!-- Begin Page Content -->
- <div class="container-fluid">
- <div class="card shadow mb-4">
- <div class="card-header py-3">
- <h6 class="m-0 font-weight-bold text-primary">QUOTATION</h6>
- </div>
- <!-- Page Heading -->
- <form method="POST" action="">
- <div class="form-group row" style="margin-left: 30px; margin-right: 30px; margin-top: 30px">
- <div class="col-sm-4 mb-3 mb-sm-0">
- Debtor<input type="text" class="form-control form-control-user" id="name" name="name[]" required>
- </div>
- <div class="col-sm-4">
- </div>
- <div class="col-sm-4">
- </div>
- </div>
- <div class="form-group row" style="margin-left: 30px; margin-right: 30px">
- <div class="col-sm-4 mb-3 mb-sm-0">
- Customer Name<input type="text" class="form-control form-control-user" id="name" name="name[]" required>
- Customer Address<input type="text" class="form-control form-control-user" id="cust_add1" name="cust_add1[]" required>
- <input type="text" class="form-control form-control-user" id="cust_add2" name="cust_add2[]" required>
- <input type="text" class="form-control form-control-user" id="cust_add3" name="cust_add3[]" required>
- </div>
- <div class="col-sm-4">
- Tel No<input type="text" class="form-control form-control-user" id="cust_phone" name="cust_phone[]" required>
- Attention<input type="text" class="form-control form-control-user" id="attention_1" name="attention[]" required>
- Delivery Term<input type="text" class="form-control form-control-user" id="delivery_term" name="delivery_term" required>
- </div>
- <div class="col-sm-4">
- Fax No<input type="text" class="form-control form-control-user" id="cust_fax" name="cust_fax[]" required>
- Sales Agent<select class="form-control form-control-user" name="sales_agent" id="sales_agent" required>
- <option value=""><div>--Select Item--</div></option>
- <option value="ABX"><div align="center">ABX</div></option>
- <option value="ARIF"><div align="center">ARIF</div></option>
- <option value="CHAN"><div align="center">CHAN</div></option>
- <option value="CHIA WAI LUN"><div align="center">CHIA WAI LUN</div></option>
- <option value="LEE MENG CHOON"><div align="center">LEE MENG CHOON</div></option>
- <option value="DHL"><div align="center">DHL</div></option>
- <option value="FEDEX"><div align="center">FEDEX</div></option>
- <option value="LIOW JIN CHUAN"><div align="center">LIOW JIN CHUAN</div></option>
- <option value="CUSTOMER OWN COLLECT"><div align="center">CUSTOMER OWN COLLECT</div></option>
- <option value="SIM CHUN HENG"><div align="center">SIM CHUN HENG</div></option>
- <option value="TAN MENG TIAN"><div align="center">TAN MENG TIAN</div></option>
- <option value="TNT"><div align="center">TNT</div></option>
- <option value="TRANSMARINE UPS"><div align="center">TRANSMARINE UPS</div></option>
- <option value="UPS"><div align="center">UPS</div></option>
- </select>
- Credit Term<select class="form-control form-control-user" name="credit_term" id="credit_term" required>
- <option value=""><div>--Select Item--</div></option>
- <option value="COD"><div align="center">COD</div></option>
- <option value="Net 120 days"><div align="center">Net 120 days</div></option>
- <option value="Net 14 days"><div align="center">Net 14 days</div></option>
- <option value="Net 30 days"><div align="center">Net 30 days</div></option>
- <option value="Net 45 days"><div align="center">Net 45 days</div></option>
- <option value="Net 60 days"><div align="center">Net 60 days</div></option>
- <option value="Net 90 days"><div align="center">Net 90 days</div></option>
- </select>
- </div>
- </div>
- <div class="card-body">
- <div class="table-responsive">
- <table class="table table-bordered" id="tbl" width="100%" cellspacing="0">
- <thead style="text-align:center; height:10px">
- <tr>
- <th></th>
- <th>Item Code</th>
- <th>Description</th>
- <th>Further Description</th>
- <th>UOM</th>
- <th>Qty</th>
- <th>Unit Price</th>
- <th>Discount</th>
- <th>Subtotal</th>
- <th>GST</th>
- <th>Total(exc)</th>
- <th>Total(inc)</th>
- </tr>
- </thead>
- <tbody>
- <tr row="0">
- <td><input type="checkbox" name="chk" row="0"></td>
- <td><input type="text" class="form-control autocomplete_txt ui-autocomplete-input" id="item_code_1" name="item_code[]" row="0"></td>
- <td><input type="text" class="form-control autocomplete_txt ui-autocomplete-input" id="description_1" name="description[]" row="0"></td>
- <td><input type="text" class="form-control autocomplete_txt ui-autocomplete-input" id="f_desc_1" name="f_desc[]" row="0"></td>
- <td><input type="text" class="form-control autocomplete_txt ui-autocomplete-input" id="uom_1" name="uom[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="qty" name="qty[]" row="0"></td>
- <td><input type="text" class="form-control autocomplete_txt ui-autocomplete-input" id="std_selling_price_1" name="std_selling_price[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="discount" name="discount[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="sub_total" name="sub_total[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="gst" name="gst[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="total_exc" name="total_exc[]" row="0"></td>
- <td><input type="text" class="form-control form-control-user" id="total_inc" name="total_inc[]" row="0"></td>
- </tr>
- </tbody>
- </table>
- <p>
- <input type="button" value="Add Row" onclick="addRow('tbl')" />
- <input type="button" value="Delete Row" onclick="deleteRow('tbl')" />
- </p>
- </div>
- </div>
- <div style="text-align:right; margin-left:30px; margin-bottom-30px">
- <button type="submit" name="insert_btn" class="btn btn-primary btn-user">
- Save
- </button>
- </div>
- </form>
- <script>
- var currrow = 1;
- function addRow(tableID) {
- var table = document.getElementById(tableID);
- var rowCount = table.rows.length;
- var row = table.insertRow(rowCount);
- var colCount = table.rows[1].cells.length;
- //alert(row);
- for(var i=0; i<colCount; i++) {
- var newcell = row.insertCell(i);
- newcell.innerHTML = table.rows[1].cells[i].innerHTML;
- //alert(newcell.childNodes);
- //alert(newcell.childNodes[0].type);
- //newcell.childNodes[0].setAttribute("row", currrow);
- //var test123 = newcell.getElementById("item");
- //alert(newcell.FirstChild);
- switch(newcell.childNodes[0].type) {
- case "text":
- newcell.childNodes[0].value = "";
- newcell.childNodes[0].value = "";
- break;
- case "checkbox":
- newcell.childNodes[0].checked = false;
- newcell.childNodes[0].value = "";
- break;
- case "select-one":
- newcell.childNodes[0].selectedIndex = 0;
- newcell.childNodes[0].value = "";
- break;
- }
- }
- }
- function deleteRow(tableID) {
- try {
- var table = document.getElementById(tableID);
- var rowCount = table.rows.length;
- for(var i=1; i<rowCount; i++) {
- var row = table.rows[i];
- var chkbox = row.cells[0].childNodes[0];
- if(null != chkbox && true == chkbox.checked) {
- if(rowCount <= 2) {
- alert("Cannot delete all the rows.");
- break;
- }
- table.deleteRow(i);
- rowCount--;
- i--;
- }
- }
- }catch(e) {
- alert(e);
- }
- }
- var specialKeys = new Array();
- specialKeys.push(8); //Backspace
- function IsNumeric(e) {
- var keyCode = e.which ? e.which : e.keyCode
- var ret = ((keyCode >= 48 && keyCode <= 57) || specialKeys.indexOf(keyCode) != -1);
- document.getElementById("error").style.display = ret ? "none" : "inline";
- return ret;
- }
- var specialKeys = new Array();
- specialKeys.push(8); //Backspace
- function IsNumeric2(e) {
- var keyCode = e.which ? e.which : e.keyCode
- var ret = ((keyCode >= 48 && keyCode <= 57) || specialKeys.indexOf(keyCode) != -1);
- document.getElementById("error2").style.display = ret ? "none" : "inline";
- return ret;
- }
- $(document).on('focus','.autocomplete_txt', handleAutocomplete);
- function getId(element){
- var id, idArr;
- id = element.attr('id');
- idArr = id.split("_");
- return idArr[idArr.length - 1];
- }
- function getFieldNo(type){
- var fieldNo;
- switch (type) {
- case 'item_code':
- fieldNo = 0;
- break;
- case 'description':
- fieldNo = 1;
- break;
- case 'f_desc':
- fieldNo = 2;
- break;
- case 'uom':
- fieldNo = 3;
- break;
- case 'std_selling_price':
- fieldNo = 4;
- break;
- default:
- break;
- }
- return fieldNo;
- }
- function handleAutocomplete() {
- var type, fieldNo, currentEle;
- type = $(this).data('type');
- fieldNo = getFieldNo(type);
- currentEle = $(this);
- if(typeof fieldNo === 'undefined') {
- return false;
- }
- $(this).autocomplete({
- source: function( data, cb ) {
- $.ajax({
- url:'ajax.php',
- method: 'GET',
- dataType: 'json',
- data: {
- name: data.term,
- fieldNo: fieldNo
- },
- success: function(res){
- var result;
- result = [
- {
- label: 'There is matching record found for '+data.term,
- value: ''
- }
- ];
- if (res.length) {
- result = $.map(res, function(obj){
- var arr = obj.split("|");
- return {
- label: arr[fieldNo],
- value: arr[fieldNo],
- data : obj
- };
- });
- }
- cb(result);
- }
- });
- },
- autoFocus: true,
- minLength: 1,
- select: function( event, ui ) {
- var resArr, rowNo;
- rowNo = getId(currentEle);
- resArr = ui.item.data.split("|");
- $('#item_code_'+rowNo).val(resArr[0]);
- $('#description_'+rowNo).val(resArr[1]);
- $('#f_desc_'+rowNo).val(resArr[2]);
- $('#uom_'+rowNo).val(resArr[3]);
- $('#std_selling_price_'+rowNo).val(resArr[4]);
- }
- });
- }
- $('#tbl').on('keyup change ','#qty',function(){
- var row = $(this).closest('tr');
- var std_selling_price = row.find('#std_selling_price').val();
- var sub_total = row.find('#sub_total');
- var qty = $(this).val();
- var price = parseFloat(qty) * parseFloat(std_selling_price);
- sub_total.val(price);
- });
- </script>
- </div>
- </div>
- <!-- /.container-fluid -->
- </div>
- <!-- End of Main Content -->
- <!-- Footer -->
- <footer class="sticky-footer bg-white">
- <div class="container my-auto">
- <div class="copyright text-center my-auto">
- <span>Copyright © Your Website 2019</span>
- </div>
- </div>
- </footer>
- <!-- End of Footer -->
- </div>
- <!-- End of Content Wrapper -->
- </div>
- <!-- End of Page Wrapper -->
- <!-- Scroll to Top Button-->
- <a class="scroll-to-top rounded" href="#page-top">
- <i class="fas fa-angle-up"></i>
- </a>
- <!-- Logout Modal-->
- <div class="modal fade" id="logoutModal" 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">Ready to Leave?</h5>
- <button class="close" type="button" data-dismiss="modal" aria-label="Close">
- <span aria-hidden="true">×</span>
- </button>
- </div>
- <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
- <div class="modal-footer">
- <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
- <a class="btn btn-primary" href="index.php">Logout</a>
- </div>
- </div>
- </div>
- </div>
- <!-- Bootstrap core JavaScript-->
- <script src="vendor/jquery/jquery.min.js"></script>
- <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
- <!-- Core plugin JavaScript-->
- <script src="vendor/jquery-easing/jquery.easing.min.js"></script>
- <!-- Custom scripts for all pages-->
- <script src="js/sb-admin-2.min.js"></script>
- <!-- Page level plugins -->
- <script src="vendor/chart.js/Chart.min.js"></script>
- <!-- Page level custom scripts -->
- <script src="js/demo/chart-area-demo.js"></script>
- <script src="js/demo/chart-pie-demo.js"></script>
- <link rel="stylesheet" href="css/jquery-ui-1.10.3.custom.min.css" />
- <script src="js/jquery-1.10.2.min.js"></script>
- <script src="js/jquery-ui-1.10.3.custom.min.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement