MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.83
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/imyrqtmy/public_html/inventory/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/inventory/expense_edit.php
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
  header("Location: login.php");
}
include("include/db.php");;
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');

$bid  = $_GET['id'];

  $sql = "select * from tbl_expense where id='$bid'";
  $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
  $sql_row = mysqli_fetch_assoc($sql_res);

   $fe_img = $sql_row['image'];
?>
<!doctype html>
<html lang="en">


<!-- Mirrored from themesdesign.in/morvin/layouts/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:02 GMT -->
<head>


  <?php include 'include/head.php'; ?>
  <!-- twitter-bootstrap-wizard css -->
  <link rel="stylesheet" href="assets/libs/twitter-bootstrap-wizard/prettify.css">

  <!-- select2 css -->
  <link href="assets/libs/select2/css/select2.min.css" rel="stylesheet" type="text/css" />

         <!--  <style type="text/css">
            .twitter-bs-wizard .twitter-bs-wizard-nav .step-number {
    
    width: 100px;
   
}
</style> -->
</head>


<body>

  <!-- Begin page -->
  <div id="layout-wrapper">

   <?php include 'include/header.php'; ?>

   <!-- ========== Left Sidebar Start ========== -->
   <div class="vertical-menu">
    <?php include 'include/sidebar.php'; ?>
  </div>
  <!-- Left Sidebar End -->

  <!-- ============================================================== -->
  <!-- Start right Content here -->
  <!-- ============================================================== -->
  <div class="main-content">

    <div class="page-content">

      <!-- start page title -->
      <div class="page-title-box">
        <div class="container-fluid">
         <div class="row align-items-center">
           <div class="col-sm-6">
             <div class="page-title">
               <h4></h4>
                                         <!-- <ol class="breadcrumb m-0">
                                             <li class="breadcrumb-item"><a href="javascript: void(0);">Morvin</a></li>
                                             <li class="breadcrumb-item"><a href="javascript: void(0);">Tables</a></li>
                                             <li class="breadcrumb-item active">Data Tables</li>
                                           </ol> -->
                                         </div>
                                       </div>
                                       <div class="col-sm-6">

                                       </div>
                                     </div>
                                   </div>
                                 </div>
                                 <!-- end page title -->    


                                 <div class="container-fluid">

                                  <div class="page-content-wrapper">



                                   <div class="row">
                                    <div class="col-lg-12">
                                      <div class="card">
                                        <div class="card-body">


                                          <form method="POST" action="action/expense_edit.php?id=<?php echo $bid; ?>" enctype="multipart/form-data">
                                            <div class="row">



                                              <br><br>

                                              <div class="row">
                                                <div class="col-lg-12">
                                                  <div class="card">
                                                    <div class="card-body">

                                                      <div id="addproduct-nav-pills-wizard" class="twitter-bs-wizard">

                                                         <div class="row" style="margin-bottom: 25px;">


                                                              <div class="col-md-6">



                                                                <div class="row">

                                                                  <div class="col-md-3">
                                                                    <label class="form-check-label" for="formCheck1">
                                                                      Date
                                                                    </label>
                                                                  </div>

                                                                  <div class="col-md-8">

                                                                    <input class="form-control" type="date" name="ex_date"  value="<?php echo $date; ?>">

                                                                  </div>



                                                                </div>
                                                                <br>



                                                                <div class="row">

                                                                  <div class="col-md-3">
                                                                    <label class="form-check-label" for="formCheck1">
                                                                      Category Name
                                                                    </label>
                                                                  </div>

                                                                  <div class="col-md-8">

                                                                   <select class="form-select" id="validationCustom03" name="cat_name">

                                                                      <option value="Cost of Goods"<?=$sql_row['cat_name'] == 'Cost of Goods' ? ' selected="selected"' : '';?>>Cost of Goods</option>

                                                                      <option value="Cost of Goods"<?=$sql_row['cat_name'] == 'Cost of Goods' ? ' selected="selected"' : '';?>>Cost of Goods</option>

                                                                      <option value="Job Costing"<?=$sql_row['cat_name'] == 'Job Costing' ? ' selected="selected"' : '';?>>Job Costing</option>

                                                                      <option value="Job Costing"<?=$sql_row['cat_name'] == 'Job Costing' ? ' selected="selected"' : '';?>>Job Costing</option>

                                                                      <option value="Labor"<?=$sql_row['cat_name'] == 'Labor' ? ' selected="selected"' : '';?>>Labor</option>

                                                                      <option value="Materials"<?=$sql_row['cat_name'] == 'Materials' ? ' selected="selected"' : '';?>>Materials</option>

                                                                      <option value="Subcontractor"<?=$sql_row['cat_name'] == 'Subcontractor' ? ' selected="selected"' : '';?>>Subcontractor</option>

                                                                      <option value="Advertising And Marketing"<?=$sql_row['cat_name'] == 'Advertising And Marketing' ? ' selected="selected"' : '';?>>Advertising And Marketing</option>

                                                                      <option value="Automobile Expense"<?=$sql_row['cat_name'] == 'Automobile Expense' ? ' selected="selected"' : '';?>>Automobile Expense</option>

                                                                      <option value="Bad Debt"<?=$sql_row['cat_name'] == 'Bad Debt' ? ' selected="selected"' : '';?>>Bad Debt</option>

                                                                   

                                                                  </select>

                                                                </div>



                                                              </div>
                                                              <br>

                                                              <div class="row">

                                                                <div class="col-md-3">
                                                                  <label class="form-check-label" for="formCheck1">
                                                                    Amount
                                                                  </label>
                                                                </div>

                                                                <div class="col-md-4">

                                                                  <select class="form-select" id="validationCustom03" name="amt_cur" >
                                                                    <option selected="" disabled="" value=""></option>

                                                                    <option value="AED"<?=$sql_row['amt_cur'] == 'AED' ? ' selected="selected"' : '';?>>AED</option>

                                                                    <option value="AUD"<?=$sql_row['amt_cur'] == 'AUD' ? ' selected="selected"' : '';?>>AUD</option>

                                                                     <option value="CAD"<?=$sql_row['amt_cur'] == 'CAD' ? ' selected="selected"' : '';?>>CAD</option>

                                                                      <option value="CNY"<?=$sql_row['amt_cur'] == 'CNY' ? ' selected="selected"' : '';?>>CNY</option>

                                                                      <option value="EUR"<?=$sql_row['amt_cur'] == 'EUR' ? ' selected="selected"' : '';?>>EUR</option>

                                                                      <option value="GBP"<?=$sql_row['amt_cur'] == 'GBP' ? ' selected="selected"' : '';?>>GBP</option>

                                                                      <option value="INR"<?=$sql_row['amt_cur'] == 'INR' ? ' selected="selected"' : '';?>>INR</option>

                                                                      <option value="JPY"<?=$sql_row['amt_cur'] == 'JPY' ? ' selected="selected"' : '';?>>JPY</option>

                                                                      <option value="SAR"<?=$sql_row['amt_cur'] == 'SAR' ? ' selected="selected"' : '';?>>SAR</option>

                                                                      <option value="USD"<?=$sql_row['amt_cur'] == 'USD' ? ' selected="selected"' : '';?>>USD</option>

                                                                      <option value="ZAR"<?=$sql_row['amt_cur'] == 'ZAR' ? ' selected="selected"' : '';?>>ZAR</option>

                                                                    

                                                                  </select>

                                                                </div>

                                                                <div class="col-md-4">

                                                                  <input class="form-control" type="text"  id="example-text-input" name="amt" value="<?php echo $sql_row['amt']; ?>">

                                                                </div>



                                                              </div>

                                                              <br>

                                                              <div class="row">

                                                                <div class="col-md-3">
                                                                  <label class="form-check-label" for="formCheck1">
                                                                    Vendor
                                                                  </label>
                                                                </div>

                                                                <div class="col-md-8">

                                                                  <div class="input-group bootstrap-touchspin bootstrap-touchspin-injected">
                                                                    <select class="form-select" id="validationCustom03" name="vendor">

                                                                   

                                                                    <?php
                                                          $new_qu = "select * from tbl_vendor";
                                                          $new_res = mysqli_query($con, $new_qu) or die(mysqli_error($con));

                                                          while ($new_row = mysqli_fetch_assoc($new_res)) { ?>
                                                              <?php if ($new_row['c_name_dis'] == $sql_row['vendor']) { ?>
                                                                  <option value="<?php echo $new_row['c_name_dis']; ?>" selected><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } else { ?>
                                                                  <option value="<?php echo $new_row['c_name_dis']; ?>"><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } ?>
                                                          <?php } ?>
                                                                  </select>
                                                                  <span class="input-group-btn input-group-append"><button class="btn btn-primary bootstrap-touchspin-up" type="button"><i class="mdi mdi-magnify"></i></button></span></div>


                                                                </div>

                                                              </div>

                                                              <br>

                                                              <div class="row" style="margin-bottom: 25px;">

                                                                <div class="col-md-3">
                                                                  <label class="form-check-label" for="formCheck1">
                                                                    Invoice#
                                                                  </label>
                                                                </div>

                                                                <div class="col-md-8">

                                                                 <input class="form-control" type="text"  id="example-text-input" name="invoice" value="<?php echo $sql_row['invoice']; ?>">

                                                               </div>



                                                             </div>
                                                             <br>

                                                             <div class="row">

                                                              <div class="col-md-3">
                                                                <label class="form-check-label" for="formCheck1">
                                                                  Description
                                                                </label>
                                                              </div>

                                                              <div class="col-md-8">

                                                               <textarea placeholder="Max. 500 characters" id="ember1161" class="ember-text-area ember-view form-control" name="ex_desc"><?php echo $sql_row['ex_desc']; ?></textarea>

                                                             </div>



                                                           </div>
                                                           <br>

                                                           <div class="row">

                                                            <div class="col-md-3">
                                                              <label class="form-check-label" for="formCheck1">
                                                                Customer Name
                                                              </label>
                                                            </div>

                                                            <div class="col-md-8">

                                                              <div class="input-group bootstrap-touchspin bootstrap-touchspin-injected">
                                                               <select class="form-select" id="validationCustom03" name="customer">
                                                                <?php
                                                          $new_qu = "select * from tbl_customer";
                                                          $new_res = mysqli_query($con, $new_qu) or die(mysqli_error($con));

                                                          while ($new_row = mysqli_fetch_assoc($new_res)) { ?>
                                                              <?php if ($new_row['c_name_dis'] == $sql_row['customer']) { ?>
                                                                  <option value="<?php echo $new_row['c_name_dis']; ?>" selected><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } else { ?>
                                                                  <option value="<?php echo $new_row['c_name_dis']; ?>"><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } ?>
                                                          <?php } ?>

                                                                 
                                                              </select>
                                                              <span class="input-group-btn input-group-append"><button class="btn btn-primary bootstrap-touchspin-up" type="button"><i class="mdi mdi-magnify"></i></button></span></div>


                                                            </div>

                                                          </div>

                                                          <br>

                                                        </div>

                                                        <div class="col-md-6">

                                                         <div class="mb-3">
                                                          <label  class="form-label">Attach File</label>
                                                          <input type="file" name="do_photo" class="form-control "  id="images" onchange="readThumb(this, 'thumb-error')" class="" accept="image/*">
                                                             <span><?php echo $fe_img; ?></span>
                                                             <br>
                                                          <img id="thumb" src="expense/<?php echo $fe_img; ?>" alt=""  style="width: 100px;height: 100px;">
                                                          <div id="thumb-error" style="color: red; margin: 10px 0px 0 10px; display: none;">
                                                           Please upload file having extensions .jpeg / .jpg / .png only.</div>
                                                                  </div>

                                                        </div>

                                                      </div>


                                                    </div>
                                                      
                                                        <!-- ebd ul -->
                                                        
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>






                            <div>
                              <button class="btn btn-primary" type="submit">Save</button>
                              <button class="btn btn-info" type="submit">cancel</button>
                            </div>
                          </form>
                        </div>
                      </div>
                    </div>
                    <!-- end col -->
                  </div>
                  <!-- end row -->



                </div>


              </div> <!-- container-fluid -->
            </div>
            <!-- End Page-content -->



            <footer class="footer">
             <?php include 'include/footer.php'; ?>
           </footer>
         </div>
         <!-- end main content-->

       </div>
       <!-- END layout-wrapper -->

       <!-- Right Sidebar -->

       <!-- /Right-bar -->

       <!-- Right bar overlay-->
       <div class="rightbar-overlay"></div>

       <!-- JAVASCRIPT -->
       <?php include 'include/bscript.php'; ?>

       <!-- twitter-bootstrap-wizard js -->
       <script src="assets/libs/twitter-bootstrap-wizard/jquery.bootstrap.wizard.min.js"></script>

       <script src="assets/libs/twitter-bootstrap-wizard/prettify.js"></script>

       <!-- select 2 plugin -->
       <script src="assets/libs/select2/js/select2.min.js"></script>

       <!-- dropzone plugin -->
       <script src="assets/libs/dropzone/min/dropzone.min.js"></script>

       <!-- init js -->
       <script src="assets/js/pages/ecommerce-add-product.init.js"></script>


       <script type="text/javascript">
        function readThumb(input, error) {
          document.getElementById(error).style.display = "none";
          var filePath = input.value;
          var allowedExtensions = /(\.jpg|\.jpeg|\.png.|\.pdf)$/i;
          if(!allowedExtensions.exec(filePath)){
            document.getElementById(error).style.display = "block";
            input.value = '';
            document.getElementById("thumb").innerHTML = "";
            return false;
          } else if(input.files && input.files[0]) {
            document.getElementById("thumb").innerHTML = "";

            var total = input.files.length;
            for(i=0; i<total; i++ ) {
              var reader = new FileReader();
              reader.onload = function(e) {

                var newimg = document.createElement("img");
                newimg.setAttribute("src", e.target.result);
                newimg.setAttribute("height", "70px");
                document.getElementById("thumb").appendChild(newimg);
              }
              reader.readAsDataURL(input.files[i]);
            }
          }
        }
      </script>
      <script type="text/javascript">
        function readImages(input, errorClass) {
          document.getElementById(errorClass).style.display = "none";
          var len = input.files.length;
          var error = false;
          for(var i=0; i<len; i++) {
            var filePath = input.files[i].name;
            var allowedExtensions = /(\.jpg|\.jpeg|\.png|\.pdf)$/i;
            if(!allowedExtensions.exec(filePath)){
              document.getElementById(errorClass).style.display = "block";
              input.value = '';
              document.getElementById("img-container").innerHTML = "";
              error = true;
              break;
            }
          }
          if(error == true) {
            return false;
          } else if(input.files && input.files[0]) {
            document.getElementById("img-container").innerHTML = "";

            var total = input.files.length;
            for(i=0; i<total; i++ ) {
              var reader = new FileReader();
              reader.onload = function(e) {

                var newimg = document.createElement("img");
                newimg.setAttribute("src", e.target.result);
                newimg.setAttribute("height", "50px");
                document.getElementById("img-container").appendChild(newimg);
              }
              reader.readAsDataURL(input.files[i]);
            }
          }
        }
      </script>
    </body>


    <!-- Mirrored from themesdesign.in/morvin/layouts/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:42 GMT -->
    </html>

MMCT - 2023