1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : view-manufacturer.php
back
<!DOCTYPE html>
<?php 
   session_start();
   $id = $_GET['id'];
   include 'config.php';
   $login = $_SESSION['login_email'];
   if($login == ''){
       echo '<script>location.replace("index.php")</script>';
   }
   
   if(isset($_SESSION["source_id"])){
       $source_id = $_SESSION['source_id'];
   }
   $contactId = ""; 
   $companyName = "";
   $contactPerson = "";
   $designation = "";
   $sql = "SELECT * FROM manufacturer where id = '$id'";
   $result = mysqli_query($conn,$sql);
   $rowGetAddress = mysqli_fetch_array($result);
   
   $manufacturerId = $rowGetAddress["id"];
   $manufacturer = $rowGetAddress["manufacturer"];
   $manufacturer_display_name = $rowGetAddress["manufacturer_display_name"];
   $contactPerson = $rowGetAddress["contact_person_name"];
   $contact_person_designation = $rowGetAddress["contact_person_designation"];
 
 
 
 
 
 $totalDebit = 0.00;
    $sqlGetDebit = "SELECT `amount_paind` FROM `purchase_order` where `manufacturer` = '$id' AND `data_delete` != 'yes'";
   $resultGetDebit = mysqli_query($conn,$sqlGetDebit);
   if(mysqli_num_rows($resultGetDebit) > 0){
       while($row = mysqli_fetch_array($resultGetDebit)){ 
           $totalDebit += $row["amount_paind"];
       }
   }
   
   $totalDebit = sprintf('%0.2f', $totalDebit);
   
   $totalCredit = 0.00;
   $sqlGetCredit = "SELECT `amount` FROM `purchase_order_payments` where `manufacturer_id` = '$id' AND `transaction_type` = 'Credit' AND `is_deleted` = 'no'";
   $resultGetCredit = mysqli_query($conn,$sqlGetCredit);
   if(mysqli_num_rows($resultGetCredit) > 0){
       while($row = mysqli_fetch_array($resultGetCredit)){ 
           $totalCredit += $row["amount"];
       }
   }
   $totalCredit = sprintf('%0.2f', $totalCredit);
   
   ?>
<html>
   <head>
      <meta charset="utf-8" />
      <title>Invoice Management | Invoice</title>
      <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
      <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
      <meta content="Coderthemes" name="author" />
      <meta http-equiv="X-UA-Compatible" content="IE=edge" />
      <!-- Font Awsome -->
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
      <!-- App favicon -->
      <link rel="shortcut icon" href="assets/images/favicon.png">
      <!-- Pie Chart Css -->
      <link href="assets/pie charts/style.css" rel="stylesheet" type="text/css" />
      <!-- App css -->
      <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/style.css" rel="stylesheet" type="text/css" />
      <!-- DataTables -->
      <link href="plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <link href="plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <!-- Responsive datatable examples -->
      <link href="plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <script src="assets/js/modernizr.min.js"></script>
      <link href="plugins/sweet-alert2/sweetalert2.min.css" rel="stylesheet" type="text/css">
      <link href="plugins/jquery-toastr/jquery.toast.min.css" rel="stylesheet" />
   </head>
   <body>
      <style>
         .tabcontent {
         display: none;
         padding: 6px 12px;
         border: 1px solid #ccc;
         border-top: none;
         }
      </style>
      <!-- Begin page -->
      <div id="wrapper">
      <!-- Top Bar Start -->
      <?php include 'top-header.php'; ?>
      <!-- Top Bar End -->
      <!-- ========== Left Sidebar Start ========== -->
      <?php include 'left-sidebar.php'; ?>
      <!-- Left Sidebar End -->
      <!-- ============================================================== -->
      <!-- Start right Content here -->
      <!-- ============================================================== -->
      <div class="content-page">
         <!-- Start content -->
         <div class="content">
            <div class="container-fluid">
               <div class="row">
                  <div class="col-12">
                     <div class="page-title-box">
                        <h4 class="page-title float-left">View Manufacturer</h4>
                        <ol class="breadcrumb float-right">
                           <li class="breadcrumb-item ">Manufacturer Manager</li>
                           <li class="breadcrumb-item active">View Manufacturer</li>
                        </ol>
                        <div class="clearfix"></div>
                     </div>
                  </div>
               </div>
               <!-- end row -->
               <div class="card-box">
                  <div class="row">
                     <div class="col-lg-6 brdr"> 
                              <div class="row">
                                 <div class="col-sm-6 col-lg-6 pd-10 bg-grey">Manufacturer </div>
                                 <div class="col-sm-6 col-lg-6 pd-10">
                                    <?php echo  $manufacturer  ?>
                                 </div>
                              </div>  
                     </div>
 
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           
                                 <div class="col-sm-6 col-lg-5 pd-10 bg-grey">Manufacturer Display Name </div>
                                 <div class="col-sm-6 col-lg-7 pd-10">
                                     <?php echo $manufacturer_display_name ?>
                                 </div>
                        
                        </div>
                     </div>
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Contact Person </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $contactPerson; ?>
                           </div>
                        </div>
                     </div>
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Designation </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $contact_person_designation; ?></div>
                        </div>
                     </div>
                  </div> 
               </div> 
               <div class="card-box">
                  <div class="row">
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Address </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['address'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-4 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">City </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['city'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">State </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['state'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-4 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Pin </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['pin'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Email </div>
                           <div class="col-sm-6 col-lg-4 pd-10"> <?php echo $rowGetAddress['email'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-4 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Phone </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['phone'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Country </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $country = $rowGetAddress['country'] ?></div>
                        </div>
                     </div> 
                     
                     <div class="col-lg-4 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Payment Terms & Conditions </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['payment_terms'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Currency</div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $currency = $rowGetAddress['currency'] ?></div>
                        </div>
                     </div> 
                  </div>
                  <div class="row">
                     <div class="col-lg-12 pt-20 text-right">
                        <?php if($access->getContactEdit($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <button type="button" class="btn btn-primary btn-sm"  data-toggle="modal" data-target="#myModal"> Edit</button>
                        <?php } ?>
                     </div>
                  </div>
               </div>
               <!--for payments-->
               <div class="card-box">
                  <div class="row">
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-red"> Total PO Amount </div>
                           <div class="col-sm-6 col-lg-9 pd-10"><?php echo $totalDebit; ?> </div>
                        </div>
                     </div>
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-green"> Paid </div>
                           <div class="col-sm-6 col-lg-9 pd-10"><?php echo $totalCredit; ?></div>
                        </div>
                     </div>
                  </div>
                  <div class="row">
                     <div class="col-lg-12 pt-20 text-right">
                         
                         <a target="_BLANK" href="view-manufacturer-payment-details.php?id=<?php echo $id; ?>"
                           class="btn btn-info btn-sm" data-toggle="tooltip"
                           data-placement="top" title="" data-original-title="View All Invoice Transaction Details"> View All Transactions Details</a> 
                           
                           
                        
                        <?php if($access->getFinanceAdd($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <a href="add-manufacturer-payments.php?id=<?php echo $id; ?>"
                           class="btn btn-danger btn-sm" data-toggle="tooltip"
                           data-placement="top" title="" data-original-title="Add Payment" target="_BLANK"> Add Payment</a> 
                        <?php } ?>
                     </div>
                  </div>
               </div>

            </div>
            <!-- container -->
         </div>
         
            <!-- content -->
            <?php include 'copyrignt.php' ?>
         </div>
         <!-- ============================================================== -->
         <!-- End Right content here -->
         <!-- ============================================================== -->
      </div>
 
         <!-- The Modal -->
        <div class="modal" id="myModal">
          <div class="modal-dialog modal-lg">
            <div class="modal-content">
        
              <!-- Modal Header -->
              <div class="modal-header">
                <h4 class="modal-title">Modal Heading</h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
              </div>
        
              <!-- Modal body -->
              <div class="modal-body">
              <form method="post" role="form">
                     <div class="card-box">
                        <input type="hidden" name="sourceId" value="<?php echo $source_id; ?>">
                        
 
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="exampleInputEmail1">Manufacturer</label>
                                  <input class="form-control" name="manufacture" placeholder="Manufacturer" value="<?php echo $manufacturer ?>">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label>Manufacturer Display Name</label>
                                 <input class="form-control" name="manufacture_display_name" placeholder="Enter Manufacturer Display Name" value="<?php echo $manufacturer_display_name ?>">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="exampleInputEmail1">Contact Person Name</label>
                                 <input type="text" class="form-control" name="contact_person" placeholder="Enter contact person name" value="<?php echo $contactPerson ?>" required>
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="exampleInputPassword1">Contact Person Designation</label>
                                 <input type="text" class="form-control" name="designation" placeholder="Enter designation" value="<?php echo $contact_person_designation ?>" required>
                              </div>
                           </div>
                        </div>
                     </div>
                     <div class="card-box">
                         <div class="row">
                             <div class="col-md-6">
                                  <div class="form-group">
                                        <label>Email</label>
                                        <input class="form-control" name="email" placeholder="Enter your email" value="<?php   echo $rowGetAddress['email']  ?>">
                                  </div>
                             </div>
                             <div class="col-md-6">
                                 <div class="form-group">
                                 <label>Phone</label>
                                 <input class="form-control" name="phone" placeholder="Enter your phone" value="<?php   echo $rowGetAddress['phone']  ?>">
                                 </div>
                             </div>
                         </div>
                        <div class="row">
                           <div class="col-lg-4">
                              <div class="form-group">
                                 <label for="exampleInputEmail1">Address</label>
                                 <input type="text" class="form-control" name="address"
                                    placeholder="Enter address" value="<?php echo  $rowGetAddress['address'] ?>" required>
                              </div>
                           </div>
                           <div class="col-lg-4">
                              <div class="form-group">
                                 <label for="exampleInputPassword1">City</label>
                                 <input type="text" class="form-control" name="city" placeholder="Enter city"
                                   value="<?php echo  $rowGetAddress['city'] ?>" required>
                              </div>
                           </div>
                           <div class="col-lg-4">
                              <div class="form-group">
                                 <label for="exampleInputPassword1">State</label>
                                 <input type="text" class="form-control" name="state" placeholder="Enter state" value="<?php echo  $rowGetAddress['state'] ?>"
                                    required>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-lg-4">
                              <div class="form-group">
                                 <label for="exampleInputPassword1">Country</label>
                                 <select class="form-control country" name="country" required>
                                     <?php if($country == ''){ ?> 
                                      <option value="">--Select--</option>
                                     <?php }else{ ?> 
                                      <option value="<?php echo $country ?>"><?php echo $country ?></option>
                                     <?php } ?>
                                    <option value="Afganistan">Afghanistan</option>
                                    <option value="Albania">Albania</option>
                                    <option value="Algeria">Algeria</option>
                                    <option value="American Samoa">American Samoa</option>
                                    <option value="Andorra">Andorra</option>
                                    <option value="Angola">Angola</option>
                                    <option value="Anguilla">Anguilla</option>
                                    <option value="Antigua & Barbuda">Antigua & Barbuda</option>
                                    <option value="Argentina">Argentina</option>
                                    <option value="Armenia">Armenia</option>
                                    <option value="Aruba">Aruba</option>
                                    <option value="Australia">Australia</option>
                                    <option value="Austria">Austria</option>
                                    <option value="Azerbaijan">Azerbaijan</option>
                                    <option value="Bahamas">Bahamas</option>
                                    <option value="Bahrain">Bahrain</option>
                                    <option value="Bangladesh">Bangladesh</option>
                                    <option value="Barbados">Barbados</option>
                                    <option value="Belarus">Belarus</option>
                                    <option value="Belgium">Belgium</option>
                                    <option value="Belize">Belize</option>
                                    <option value="Benin">Benin</option>
                                    <option value="Bermuda">Bermuda</option>
                                    <option value="Bhutan">Bhutan</option>
                                    <option value="Bolivia">Bolivia</option>
                                    <option value="Bonaire">Bonaire</option>
                                    <option value="Bosnia & Herzegovina">Bosnia & Herzegovina</option>
                                    <option value="Botswana">Botswana</option>
                                    <option value="Brazil">Brazil</option>
                                    <option value="British Indian Ocean Ter">British Indian Ocean Ter
                                    </option>
                                    <option value="Brunei">Brunei</option>
                                    <option value="Bulgaria">Bulgaria</option>
                                    <option value="Burkina Faso">Burkina Faso</option>
                                    <option value="Burundi">Burundi</option>
                                    <option value="Cambodia">Cambodia</option>
                                    <option value="Cameroon">Cameroon</option>
                                    <option value="Canada">Canada</option>
                                    <option value="Canary Islands">Canary Islands</option>
                                    <option value="Cape Verde">Cape Verde</option>
                                    <option value="Cayman Islands">Cayman Islands</option>
                                    <option value="Central African Republic">Central African Republic
                                    </option>
                                    <option value="Chad">Chad</option>
                                    <option value="Channel Islands">Channel Islands</option>
                                    <option value="Chile">Chile</option>
                                    <option value="China">China</option>
                                    <option value="Christmas Island">Christmas Island</option>
                                    <option value="Cocos Island">Cocos Island</option>
                                    <option value="Colombia">Colombia</option>
                                    <option value="Comoros">Comoros</option>
                                    <option value="Congo">Congo</option>
                                    <option value="Cook Islands">Cook Islands</option>
                                    <option value="Costa Rica">Costa Rica</option>
                                    <option value="Cote DIvoire">Cote DIvoire</option>
                                    <option value="Croatia">Croatia</option>
                                    <option value="Cuba">Cuba</option>
                                    <option value="Curaco">Curacao</option>
                                    <option value="Cyprus">Cyprus</option>
                                    <option value="Czech Republic">Czech Republic</option>
                                    <option value="Denmark">Denmark</option>
                                    <option value="Djibouti">Djibouti</option>
                                    <option value="Dominica">Dominica</option>
                                    <option value="Dominican Republic">Dominican Republic</option>
                                    <option value="East Timor">East Timor</option>
                                    <option value="Ecuador">Ecuador</option>
                                    <option value="Egypt">Egypt</option>
                                    <option value="El Salvador">El Salvador</option>
                                    <option value="Equatorial Guinea">Equatorial Guinea</option>
                                    <option value="Eritrea">Eritrea</option>
                                    <option value="Estonia">Estonia</option>
                                    <option value="Ethiopia">Ethiopia</option>
                                    <option value="Falkland Islands">Falkland Islands</option>
                                    <option value="Faroe Islands">Faroe Islands</option>
                                    <option value="Fiji">Fiji</option>
                                    <option value="Finland">Finland</option>
                                    <option value="France">France</option>
                                    <option value="French Guiana">French Guiana</option>
                                    <option value="French Polynesia">French Polynesia</option>
                                    <option value="French Southern Ter">French Southern Ter</option>
                                    <option value="Gabon">Gabon</option>
                                    <option value="Gambia">Gambia</option>
                                    <option value="Georgia">Georgia</option>
                                    <option value="Germany">Germany</option>
                                    <option value="Ghana">Ghana</option>
                                    <option value="Gibraltar">Gibraltar</option>
                                    <option value="Great Britain">Great Britain</option>
                                    <option value="Greece">Greece</option>
                                    <option value="Greenland">Greenland</option>
                                    <option value="Grenada">Grenada</option>
                                    <option value="Guadeloupe">Guadeloupe</option>
                                    <option value="Guam">Guam</option>
                                    <option value="Guatemala">Guatemala</option>
                                    <option value="Guinea">Guinea</option>
                                    <option value="Guyana">Guyana</option>
                                    <option value="Haiti">Haiti</option>
                                    <option value="Hawaii">Hawaii</option>
                                    <option value="Honduras">Honduras</option>
                                    <option value="Hong Kong">Hong Kong</option>
                                    <option value="Hungary">Hungary</option>
                                    <option value="Iceland">Iceland</option>
                                    <option value="Indonesia">Indonesia</option>
                                    <option value="India">India</option>
                                    <option value="Iran">Iran</option>
                                    <option value="Iraq">Iraq</option>
                                    <option value="Ireland">Ireland</option>
                                    <option value="Isle of Man">Isle of Man</option>
                                    <option value="Israel">Israel</option>
                                    <option value="Italy">Italy</option>
                                    <option value="Jamaica">Jamaica</option>
                                    <option value="Japan">Japan</option>
                                    <option value="Jordan">Jordan</option>
                                    <option value="Kazakhstan">Kazakhstan</option>
                                    <option value="Kenya">Kenya</option>
                                    <option value="Kiribati">Kiribati</option>
                                    <option value="Korea North">Korea North</option>
                                    <option value="Korea Sout">Korea South</option>
                                    <option value="Kuwait">Kuwait</option>
                                    <option value="Kyrgyzstan">Kyrgyzstan</option>
                                    <option value="Laos">Laos</option>
                                    <option value="Latvia">Latvia</option>
                                    <option value="Lebanon">Lebanon</option>
                                    <option value="Lesotho">Lesotho</option>
                                    <option value="Liberia">Liberia</option>
                                    <option value="Libya">Libya</option>
                                    <option value="Liechtenstein">Liechtenstein</option>
                                    <option value="Lithuania">Lithuania</option>
                                    <option value="Luxembourg">Luxembourg</option>
                                    <option value="Macau">Macau</option>
                                    <option value="Macedonia">Macedonia</option>
                                    <option value="Madagascar">Madagascar</option>
                                    <option value="Malaysia">Malaysia</option>
                                    <option value="Malawi">Malawi</option>
                                    <option value="Maldives">Maldives</option>
                                    <option value="Mali">Mali</option>
                                    <option value="Malta">Malta</option>
                                    <option value="Marshall Islands">Marshall Islands</option>
                                    <option value="Martinique">Martinique</option>
                                    <option value="Mauritania">Mauritania</option>
                                    <option value="Mauritius">Mauritius</option>
                                    <option value="Mayotte">Mayotte</option>
                                    <option value="Mexico">Mexico</option>
                                    <option value="Midway Islands">Midway Islands</option>
                                    <option value="Moldova">Moldova</option>
                                    <option value="Monaco">Monaco</option>
                                    <option value="Mongolia">Mongolia</option>
                                    <option value="Montserrat">Montserrat</option>
                                    <option value="Morocco">Morocco</option>
                                    <option value="Mozambique">Mozambique</option>
                                    <option value="Myanmar">Myanmar</option>
                                    <option value="Nambia">Nambia</option>
                                    <option value="Nauru">Nauru</option>
                                    <option value="Nepal">Nepal</option>
                                    <option value="Netherland Antilles">Netherland Antilles</option>
                                    <option value="Netherlands">Netherlands (Holland, Europe)</option>
                                    <option value="Nevis">Nevis</option>
                                    <option value="New Caledonia">New Caledonia</option>
                                    <option value="New Zealand">New Zealand</option>
                                    <option value="Nicaragua">Nicaragua</option>
                                    <option value="Niger">Niger</option>
                                    <option value="Nigeria">Nigeria</option>
                                    <option value="Niue">Niue</option>
                                    <option value="Norfolk Island">Norfolk Island</option>
                                    <option value="Norway">Norway</option>
                                    <option value="Oman">Oman</option>
                                    <option value="Pakistan">Pakistan</option>
                                    <option value="Palau Island">Palau Island</option>
                                    <option value="Palestine">Palestine</option>
                                    <option value="Panama">Panama</option>
                                    <option value="Papua New Guinea">Papua New Guinea</option>
                                    <option value="Paraguay">Paraguay</option>
                                    <option value="Peru">Peru</option>
                                    <option value="Phillipines">Philippines</option>
                                    <option value="Pitcairn Island">Pitcairn Island</option>
                                    <option value="Poland">Poland</option>
                                    <option value="Portugal">Portugal</option>
                                    <option value="Puerto Rico">Puerto Rico</option>
                                    <option value="Qatar">Qatar</option>
                                    <option value="Republic of Montenegro">Republic of Montenegro</option>
                                    <option value="Republic of Serbia">Republic of Serbia</option>
                                    <option value="Reunion">Reunion</option>
                                    <option value="Romania">Romania</option>
                                    <option value="Russia">Russia</option>
                                    <option value="Rwanda">Rwanda</option>
                                    <option value="St Barthelemy">St Barthelemy</option>
                                    <option value="St Eustatius">St Eustatius</option>
                                    <option value="St Helena">St Helena</option>
                                    <option value="St Kitts-Nevis">St Kitts-Nevis</option>
                                    <option value="St Lucia">St Lucia</option>
                                    <option value="St Maarten">St Maarten</option>
                                    <option value="St Pierre & Miquelon">St Pierre & Miquelon</option>
                                    <option value="St Vincent & Grenadines">St Vincent & Grenadines</option>
                                    <option value="Saipan">Saipan</option>
                                    <option value="Samoa">Samoa</option>
                                    <option value="Samoa American">Samoa American</option>
                                    <option value="San Marino">San Marino</option>
                                    <option value="Sao Tome & Principe">Sao Tome & Principe</option>
                                    <option value="Saudi Arabia">Saudi Arabia</option>
                                    <option value="Senegal">Senegal</option>
                                    <option value="Seychelles">Seychelles</option>
                                    <option value="Sierra Leone">Sierra Leone</option>
                                    <option value="Singapore">Singapore</option>
                                    <option value="Slovakia">Slovakia</option>
                                    <option value="Slovenia">Slovenia</option>
                                    <option value="Solomon Islands">Solomon Islands</option>
                                    <option value="Somalia">Somalia</option>
                                    <option value="South Africa">South Africa</option>
                                    <option value="Spain">Spain</option>
                                    <option value="Sri Lanka">Sri Lanka</option>
                                    <option value="Sudan">Sudan</option>
                                    <option value="Suriname">Suriname</option>
                                    <option value="Swaziland">Swaziland</option>
                                    <option value="Sweden">Sweden</option>
                                    <option value="Switzerland">Switzerland</option>
                                    <option value="Syria">Syria</option>
                                    <option value="Tahiti">Tahiti</option>
                                    <option value="Taiwan">Taiwan</option>
                                    <option value="Tajikistan">Tajikistan</option>
                                    <option value="Tanzania">Tanzania</option>
                                    <option value="Thailand">Thailand</option>
                                    <option value="Togo">Togo</option>
                                    <option value="Tokelau">Tokelau</option>
                                    <option value="Tonga">Tonga</option>
                                    <option value="Trinidad & Tobago">Trinidad & Tobago</option>
                                    <option value="Tunisia">Tunisia</option>
                                    <option value="Turkey">Turkey</option>
                                    <option value="Turkmenistan">Turkmenistan</option>
                                    <option value="Turks & Caicos Is">Turks & Caicos Is</option>
                                    <option value="Tuvalu">Tuvalu</option>
                                    <option value="Uganda">Uganda</option>
                                    <option value="United Kingdom">United Kingdom</option>
                                    <option value="Ukraine">Ukraine</option>
                                    <option value="United Arab Erimates">United Arab Emirates</option>
                                    <option value="United States of America">United States of America
                                    </option>
                                    <option value="Uraguay">Uruguay</option>
                                    <option value="Uzbekistan">Uzbekistan</option>
                                    <option value="Vanuatu">Vanuatu</option>
                                    <option value="Vatican City State">Vatican City State</option>
                                    <option value="Venezuela">Venezuela</option>
                                    <option value="Vietnam">Vietnam</option>
                                    <option value="Virgin Islands (Brit)">Virgin Islands (Brit)</option>
                                    <option value="Virgin Islands (USA)">Virgin Islands (USA)</option>
                                    <option value="Wake Island">Wake Island</option>
                                    <option value="Wallis & Futana Is">Wallis & Futana Is</option>
                                    <option value="Yemen">Yemen</option>
                                    <option value="Zaire">Zaire</option>
                                    <option value="Zambia">Zambia</option>
                                    <option value="Zimbabwe">Zimbabwe</option>
                                 </select>
                              </div>
                           </div>
                           <div class="col-md-4">
                              <div class="form-group">
                                 <label for="exampleInputPassword1">Pin</label>
                                 <input type="text" class="form-control" name="pin" placeholder="Enter pin"
                                   value="<?php echo $rowGetAddress['pin']  ?>"  required>
                              </div>
                           </div> 
                           <div class="col-lg-4">
                              <div class="form-group">
                                 <label>Currency</label>
                                 <select class="form-control" name="currency">
                                    <option>--select currency--</option>
                                    <option <?php if($currency == 'USD'){ echo "selected"; } ?> value="USD">USD</option>
                                    <option <?php if($currency == 'INR'){ echo "selected"; } ?> value="INR">INR</option>
                                    <option <?php if($currency == 'RMBB'){ echo "selected"; } ?> value="RMBB">RMB</option>
                                 </select>
                              </div>
                           </div>
                        </div> 
                        <div class="row">
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label>Payment Terms & Condition</label> 
                                 <textarea class="form-control" name="payment_terms"><?php echo $rowGetAddress['payment_terms'] ?></textarea>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <button type="submit" name="edit_manu" id="btnSubmit" class="btn btn-purple waves-effect waves-light w-100">Submit</button>
                           </div>
                        </div>
                     </div>
                  </form>
              </div>
        
              <!-- Modal footer -->
              <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
              </div>
        
            </div>
          </div>
        </div>
    

      <!-- END wrapper -->
      <!-- Chart Js -->
      <script src='https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.1.3/Chart.js'></script>
      <!-- jQuery  -->
      <script src="assets/js/jquery.min.js"></script>
      <script src="assets/js/popper.min.js"></script><!-- Popper for Bootstrap -->
      <script src="assets/js/bootstrap.min.js"></script>
      <script src="assets/js/metisMenu.min.js"></script>
      <script src="assets/js/waves.js"></script>
      <script src="assets/js/jquery.slimscroll.js"></script>
      <!-- Dashboard init -->
      <script src="assets/pages/jquery.dashboard.js"></script>
      <!-- App js -->
      <script src="assets/js/jquery.core.js"></script>
      <script src="assets/js/jquery.app.js"></script>
      <!-- Chart Js -->
      <!-- Required datatable js -->
      <script src="plugins/datatables/jquery.dataTables.min.js"></script>
      <script src="plugins/datatables/dataTables.bootstrap4.min.js"></script>
      <!-- Buttons examples -->
      <script src="plugins/datatables/dataTables.buttons.min.js"></script>
      <script src="plugins/datatables/buttons.bootstrap4.min.js"></script>
      <script src="plugins/datatables/jszip.min.js"></script>
      <script src="plugins/datatables/pdfmake.min.js"></script>
      <script src="plugins/datatables/vfs_fonts.js"></script>
      <script src="plugins/datatables/buttons.html5.min.js"></script>
      <script src="plugins/datatables/buttons.print.min.js"></script>
      <script src="plugins/datatables/buttons.colVis.min.js"></script>
      <!-- Responsive examples -->
      <script src="plugins/datatables/dataTables.responsive.min.js"></script>
      <script src="plugins/datatables/responsive.bootstrap4.min.js"></script>
      <script src="plugins/sweet-alert2/sweetalert2.min.js"></script>
      <script src="plugins/jquery-toastr/jquery.toast.min.js" type="text/javascript"></script>
 
   </body>
</html>

<?php

   if(isset($_POST['edit_manu'])){
       
       
       
       	
	$manufacture = addslashes(stripslashes($_POST['manufacture']));
	$manufacture_display_name = addslashes(stripslashes($_POST['manufacture_display_name']));
	$contact_person = addslashes(stripslashes($_POST['contact_person']));
	$designation = addslashes(stripslashes($_POST['designation']));
	$address = addslashes(stripslashes($_POST['address']));
	$city = addslashes(stripslashes($_POST['city']));
	$state = addslashes(stripslashes($_POST['state']));
	$country = addslashes(stripslashes($_POST['country']));
	$pin = addslashes(stripslashes($_POST['pin']));
	$currency = addslashes(stripslashes($_POST['currency']));
	$payment_terms = addslashes(stripslashes($_POST['payment_terms']));
	$email = addslashes(stripslashes($_POST['email']));
	$phone = addslashes(stripslashes($_POST['phone']));
	
	
	$sourceId = addslashes(stripslashes($_POST['sourceId']));
	
		
	 $sql = "UPDATE `manufacturer` SET `manufacturer`='$manufacture',`manufacturer_display_name`='$manufacture_display_name',`contact_person_name`='$contact_person',`contact_person_designation`='$designation',`address`='$address',`city`='$city',`state`='$state',`country`='$country',`pin`='$pin',`currency`='$currency',`payment_terms`='$payment_terms',`email`='$email',`phone`='$phone' WHERE id='$id'";
    if ($conn->query($sql) === TRUE) {
        echo '<script>localStorage.setItem("ManufacturerUpdate", "true");</script>' ;
        echo '<script>location.replace("manufacturer.php")</script>' ;
    } else {
        echo '<script>alert("Error !")</script>';
    }

       
       
   }


?>