1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : view_contact.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 contact where id = '$id'";
   $result = mysqli_query($conn,$sql);
   if(mysqli_num_rows($result) > 0){
       while($row = mysqli_fetch_array($result)){ 
           $contactId = $row["id"];
           $customer_type = $row["customer_type"];
           $bill_display_name = $row["bill_display_name"];
           $contactPerson = $row["contact_person_name"];
           $designation = $row["contact_person_designation"];
       }
   }
   
   
   $totalDebit = 0.00;
   $sqlGetDebit = "SELECT amount_paid FROM generate_invoice where bill_pay_name = '$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_paid"];
       }
   }
   
   $totalDebit = sprintf('%0.2f', $totalDebit);
   
   $totalCredit = 0.00;
   $sqlGetCredit = "SELECT amount FROM payment where company_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 Contact</h4>
                        <ol class="breadcrumb float-right">
                           <li class="breadcrumb-item ">Contact Manager</li>
                           <li class="breadcrumb-item active">View Contact</li>
                        </ol>
                        <div class="clearfix"></div>
                     </div>
                  </div>
               </div>
               <!-- end row -->
               <div class="card-box">
                 <div class="col-md-12 text-right pb-2">
                    <form action="invoice-report-download.php" method="post">
                         <input type="hidden" value="<?php echo $contactId ?>" name="bill_pay_name" class="form-control">    
                         <input type="hidden" value="Customer" name="report" class="form-control">    
                         <button class="btn btn-sm-secondary" type="submit">Download Report</button>
                    </form>
                 </div>
                  <div class="row">
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-lg-6 ">
                              <div class="row">
                                 <div class="col-sm-6 col-lg-4 pd-10 bg-grey">Customer Type </div>
                                 <div class="col-sm-6 col-lg-6 pd-10">
                                    <?php echo $customer_type; ?>
                                 </div>
                              </div>
                           </div>
                        </div>
                     </div>
                     <div class="col-lg-6 brdr">
                        <div class="row">
                           <div class="col-lg-6 ">
                              <div class="row">
                                 <div class="col-sm-6 col-lg-5 pd-10 bg-grey">Bill Display Name </div>
                                 <div class="col-sm-6 col-lg-7 pd-10">
                                    <?php echo $bill_display_name ?>
                                 </div>
                              </div>
                           </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 $designation; ?></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" id="editContact" onclick="openModalEditContact('<?php echo $contactId; ?>')" class="btn btn-info btn-sm" > Edit</button>
                        <?php } ?>
                        <?php if($access->getContactDelete($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <button type="button" id="deleteContact" onclick="deleteContact('<?php echo $contactId; ?>')" class="btn btn-danger btn-sm" > Delete</button>
                        <?php } ?>
                        <?php if($access->getContactAdd($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <button type="button" class="btn btn-success btn-sm" onclick="openModalAddAddress()">Add New Address</button>
                        <?php } ?>
                       
                     </div>
                  </div>
               </div>
               <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 Debit </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"> Total Credit </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-company-invoice-details.php?id=<?php echo $contactId; ?>"
                           class="btn btn-info btn-sm" data-toggle="tooltip"
                           data-placement="top" title="" data-original-title="View All Invoice Transaction Details"> View All Invoice Transaction Details</a> 
                           
                           
                           
                        <?php if($access->getFinanceView($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <a href="view-transaction.php?id=<?php echo $contactId; ?>"
                           class="btn btn-primary btn-sm" data-toggle="tooltip"
                           data-placement="top" title="" data-original-title="Transaction"> Transaction</a>
                        <?php } ?>
                        <?php if($access->getFinanceAdd($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <a href="add_payment.php?id=<?php echo $contactId; ?>"
                           class="btn btn-danger btn-sm" data-toggle="tooltip"
                           data-placement="top" title="" data-original-title="Add Payment"> Add Payment</a> 
                        <?php } ?>
                     </div>
                  </div>
               </div>
               <?php
                  $sqlGetAddress = "SELECT * FROM contact_address WHERE contact_id = '$contactId' AND is_deleted = 'NO'";
                  $resultGetAddress = mysqli_query($conn, $sqlGetAddress);
                  if($resultGetAddress){
                      if(mysqli_num_rows($resultGetAddress) > 0){
                          while($rowGetAddress = mysqli_fetch_array($resultGetAddress)){
                  ?>
               <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 $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">GSTIN </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['gstin'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">IEC No. </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['iecno'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-4 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Type</div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['type'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-8 brdr">
                        <div class="row">
                           <div class="col-sm-6 col-lg-3 pd-10 bg-grey">Pan No. </div>
                           <div class="col-sm-6 col-lg-9 pd-10"> <?php echo $rowGetAddress['panno'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-4 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 $rowGetAddress['currency'] ?></div>
                        </div>
                     </div>
                     <div class="col-lg-12">
                        <div class="row">
                           <div class="col-sm-6 col-lg-2 pd-10 bg-grey">Payment Terms & Condition</div>
                           <div class="col-sm-6 col-lg-10 pd-10"> <?php echo $rowGetAddress['terms_condtion'] ?></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" onclick="editAddress('<?php echo $rowGetAddress['id'] ?>')"> Edit</button>
                        <?php } ?>
                        <?php if($access->getContactDelete($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                        <button type="button" class="btn btn-danger btn-sm" onclick="deleteAddress('<?php echo $rowGetAddress['id'] ?>')"> Delete</button>
                        <?php } ?>
                     </div>
                     
                  </div>
               </div>
               <?php
                  }
                  }
                  }
                  ?>
            </div>
            <!-- container -->
         </div>
         <div id="con-close-modal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" data-backdrop="static" data-keyboard="false" aria-hidden="true">
            <form method="post" id="addEditAddress">
               <div class="modal-dialog modal-lg">
                  <div class="modal-content">
                     <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                        <h4 class="modal-title" id="addressTitle">Add New Address</h4>
                     </div>
                     <div class="modal-body">
                        <input type="hidden" class="form-control" id="actionType" name="actionType" value="add">
                        <input type="hidden" class="form-control" id="contactId" name="contactId" value="<?php echo $contactId; ?>">
                        <input type="hidden" class="form-control" id="addressId" name="addressId">
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label for="address" class="control-label">Address</label>
                                 <input type="text" class="form-control" id="address" name="address">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="country">Country</label>
                                 <select class="form-control" name="country" id="country">
                                    <option value="">--Select--</option>
                                    <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-6">
                              <div class="form-group">
                                 <label for="state" class="control-label">State</label>
                                 <div id="stateDiv">
                                    <input type="text" class="form-control" name="state" id="state">
                                 </div>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="city" class="control-label">City</label>
                                 <input type="text" class="form-control" id="city" name="city">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="pin" class="control-label">Pin</label>
                                 <input type="text" class="form-control" id="pin" name="pin">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="gstin" class="control-label" id="gstinLabel">GSTIN</label>
                                 <input type="text" class="form-control" id="gstin" name="gstin">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="email" class="control-label">Email</label>
                                 <input type="text" class="form-control" id="email" name="email">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label for="phone" class="control-label">Phone</label>
                                 <input type="text" class="form-control" id="phone" name="phone">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="control-label" for="iecno">IEC No.</label>
                                 <input type="text" class="form-control" id="iecno" name="iecno">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="control-label" for="type">Type</label>
                                 <select class="form-control" name="type" id="type">
                                    <option>--select type--</option>
                                    <option value="Export">Export</option>
                                    <option value="Import">Import</option>
                                    <option value="Domestic">Domestic</option>
                                 </select>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="control-label" for="panno">Pan No.</label>
                                 <input class="form-control" name="panno" id="panno" placeholder="Enter Your Pan No.">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="control-label" for="currency">Currency</label>
                                 <select class="form-control" name="currency" id="currency">
                                    <option>--select currency--</option>
                                    <option value="USD">USD</option>
                                    <option value="INR">INR</option>
                                 </select>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <label class="control-label" for="terms_condtion">Payment Terms & Condition</label>
                              <textarea name="terms_condtion" class="form-control" id="terms_condtion"></textarea>
                           </div>
                        </div>
                     </div>
                     <div class="modal-footer">
                        <button type="button" class="btn btn-secondary waves-effect"
                           data-dismiss="modal">Close</button>
                        <button type="button" id="btnAddEditAddress" class="btn btn-info waves-effect waves-light">Submit</button>
                     </div>
                  </div>
               </div>
            </form>
         </div>
         <!-- /.modal -->
         <div id="modalEditContact" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" data-backdrop="static" data-keyboard="false" aria-hidden="true">
            <form method="post" id="formUpdateContact">
               <div class="modal-dialog modal-lg">
                  <div class="modal-content">
                     <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                        <h4 class="modal-title">Edit Contact</h4>
                     </div>
                     <div class="modal-body">
                        <input type="hidden" class="form-control" id="contactIdMain" name = "contactIdMain">
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label for="field-3" class="control-label">Customer Type</label>
                                 <input type="text" class="form-control" id="customer_type" name = "customer_type">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="bill_display_name" class="control-label">Bill Display Name</label>
                                 <input type="text" class="form-control" id="bill_display_name" name = "bill_display_name">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="contact_person" class="control-label">Contact Person Name</label>
                                 <input type="text" class="form-control" id="contact_person" name="contact_person">
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label class="control-labrl" for="">Contact Person Designation</label>
                                 <input type="text" class="form-control" id="designation" name="designation">
                              </div>
                           </div>
                        </div>
                        <div class="modal-footer">
                           <button type="button" class="btn btn-secondary waves-effect" data-dismiss="modal">Close</button>
                           <button type="button" id="updateContactInfo"  class="btn btn-info waves-effect waves-light">Submit</button>
                        </div>
                     </div>
                  </div>
            </form>
            </div><!-- /.modal -->
            <!-- content -->
            <?php include 'copyrignt.php' ?>
         </div>
         <!-- ============================================================== -->
         <!-- End Right content here -->
         <!-- ============================================================== -->
      </div>
      <div class="modal fade" id="thankyouinsert2" tabindex="-1" role="dialog">
         <div class="modal-dialog">
            <div class="modal-content" style="padding:20px 10px">
               <!-- Modal body -->
               <div class="modal-body  text-center">
                  <h4 class="modal-title">Payment Successfully Added.</h4>
               </div>
               <div class="col-md-12 text-center">
                  <button type="button" class="btn btn-danger " data-dismiss="modal"
                     style="padding:10px 20px">Ok</button>
               </div>
            </div>
         </div>
      </div>
      <div class="modal fade" id="messageModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" data-backdrop="static" data-keyboard="false" aria-hidden="true">
         <div class="modal-dialog">
            <div class="modal-content" style="padding:20px 10px">
               <!-- Modal body -->
               <div class="modal-body  text-center">
                  <h4 class="modal-title" id="message">[message]</h4>
               </div>
               <div class="col-md-12 text-center">
                  <button type="button" class="btn btn-danger " data-dismiss="modal" onclick="location.reload()"
                     style="padding:10px 20px">Ok</button>
               </div>
            </div>
         </div>
      </div>
      <script>
         function openCity(evt, cityName) {
             var i, tabcontent, tablinks;
             tabcontent = document.getElementsByClassName("tabcontent");
             for (i = 0; i < tabcontent.length; i++) {
                 tabcontent[i].style.display = "none";
             }
             tablinks = document.getElementsByClassName("tablinks");
             for (i = 0; i < tablinks.length; i++) {
                 tablinks[i].className = tablinks[i].className.replace(" active", "");
             }
             document.getElementById(cityName).style.display = "block";
             evt.currentTarget.className += " active";
         }
      </script>
      <!-- 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>
      <script type="text/javascript">
         $(document).ready(function() {
             $('#datatable').DataTable();
         
             //Buttons examples
             var table = $('#datatable-buttons').DataTable({
                 lengthChange: false,
                 buttons: ['copy', 'excel', 'pdf', 'colvis']
             });
         
             table.buttons().container()
                 .appendTo('#datatable-buttons_wrapper .col-md-6:eq(0)');
         });
         
         
         $(document).ready(function(){
             if (localStorage.getItem("AddressUpdated") == "true") {
                 successMessage("Address Successfully Updated.");
                 localStorage.setItem("AddressUpdated", "false");
             }
             
             if (localStorage.getItem("AddressAdded") == "true") {
                 successMessage("Address Successfully Added.");
                 localStorage.setItem("AddressAdded", "false");
             }
             
             if (localStorage.getItem("AddressDeleted") == "true") {
                 successMessage("Address Successfully Deleted.");
                 localStorage.setItem("AddressDeleted", "false");
             }
         
             if (localStorage.getItem("ContactUpdated") == "true") {
                 successMessage("Contact Information successfully updated.");
                 localStorage.setItem("ContactUpdated", "false");
             }
         });
         
         
         function openModalAddAddress() {
             $("#actionType").val("add");
             $("#addressId").val("");
             $("#addressTitle").text("Add Address");
             $("#con-close-modal").modal("toggle");
         }
         
         function editAddress(addressId){
             $.ajax({
                 url : "PHP/response.php",
                 data : "addressId="+addressId+"&action=getAddressDetail",
                 async : false,
                 method : "post",
                 success : function(response){
                     var str = JSON.parse(response);
                     if(str != ""){
                         $("#actionType").val("edit");
                         $("#addressTitle").text("Update Address");
                         $("#addressId").val(str.id);
                         $("#address").val(str.address);
                         $("#country").val(str.country);
                         $("#country").trigger("change");
                         $("#state").val(str.state);
                         $("#city").val(str.city);
                         $("#pin").val(str.pin);
                         $("#phone").val(str.phone);
                         $("#email").val(str.email);
                         $("#gstin").val(str.gstin);
                         $("#bank_charges").val(str.bank_charges);
                         $("#iecno").val(str.iecno);
                         $("#type").val(str.type);
                         $("#panno").val(str.panno);
                         $("#currency").val(str.currency);
                         $("#opening_balance").val(str.opening_balance);
                         $("#terms_condtion").val(str.terms_condtion);
                         $("#con-close-modal").modal("toggle");
                     }
                 },
                 error:function(err){
                     
                 }
             }); 
             
         }
         
         function openModalEditContact(contactId){
             $.ajax({
                 url : "PHP/response.php",
                 data : "contactId="+contactId+"&action=getContactDetail",
                 async : false,
                 method : "post",
                 success : function(response){
                     var str = JSON.parse(response);
                     if(str != ""){
                         $("#contactIdMain").val(contactId);
                         $("#customer_type").val(str.customer_type);
                         $("#bill_display_name").val(str.bill_display_name);
                         $("#designation").val(str.contact_person_designation);
                         $("#contact_person").val(str.contact_person_name);
                         $("#modalEditContact").modal("toggle");
                     }
                 },
                 error:function(err){
                     
                 }
             }); 
         }
         
         $("#updateContactInfo").click(function(){
             $.ajax({
                 url : "PHP/response.php",
                 data : $("#formUpdateContact").serialize()+"&action=updateContactDetail",
                 async : false,
                 method : "post",
                 success : function(response){
                     if(response.trim() === "UPDATED"){
                         localStorage.setItem("ContactUpdated", "true");
                         location.replace("contact.php");
                         }else{
                         errorMessage("Could not update Contact info.");
                     }
                 },
                 error:function(err){
                     
                 }
             }); 
         });
         
         function deleteContact(contactId){
             swal({
                 title: 'Are you sure?',
                 text: "Do you really want to delete this Contact??",
                 type: 'warning',
                 showCancelButton: true,
                 confirmButtonColor: '#4fa7f3',
                 cancelButtonColor: '#d57171',
                 confirmButtonText: "Yes, I'm Sure!"
             }).then(function () {
                 $.ajax({
                     url : "PHP/response.php",
                     data : "contactId="+contactId+"&action=deleteContactDetail",
                     async : false,
                     method : "post",
                     success : function(response){
                         if(response.trim() === "DELETED"){
                             localStorage.setItem("ContactDeleted", "true");
                             location.replace("contact.php");
                         }
                         else{
                             errorMessage("Contact could not be deleted.");
                         }
                     },
                     error:function(err){
                         
                     }
                 }); 
             });
         }
         
         $("#country").change(function(){
             if($("#country").val() == "India"){
                 $("#stateDiv").html("<select class='form-control' name='state' id='state'><option value=''>--Select--</option><option value='Andaman and Nicobar Islands'>Andaman and Nicobar Islands</option><option value='Andhra Pradesh'>Andhra Pradesh</option><option value='Arunachal Pradesh'>Arunachal Pradesh</option><option value='Assam'>Assam</option><option value='Bihar'>Bihar</option><option value='Chandigarh'>Chandigarh</option><option value='Chhattisgarh'>Chhattisgarh</option><option value='Dadra and Nagar Haveli'>Dadra and Nagar Haveli</option><option value='Daman and Diu'>Daman and Diu</option><option value='Delhi'>Delhi</option><option value='Goa'>Goa</option><option value='Gujarat'>Gujarat</option><option value='Haryana'>Haryana</option><option value='Himachal Pradesh'>Himachal Pradesh</option><option value='Jammu and Kashmir'>Jammu and Kashmir</option><option value='Jharkhand'>Jharkhand</option><option value='Karnataka'>Karnataka</option><option value='Kerala'>Kerala</option><option value='Ladakh'>Ladakh</option><option value='Lakshadweep'>Lakshadweep</option><option value='Madhya Pradesh'>Madhya Pradesh</option><option value='Maharashtra'>Maharashtra</option><option value='Manipur'>Manipur</option><option value='Meghalaya'>Meghalaya</option><option value='Mizoram'>Mizoram</option><option value='Nagaland'>Nagaland</option<option value='Orissa'>Orissa</option><option value='Pondicherry'>Pondicherry</option><option value='Punjab'>Punjab</option><option value='Rajasthan'>Rajasthan</option><option value='Sikkim'>Sikkim</option><option value='Tamil Nadu'>Tamil Nadu</option><option value='Talengana'>Talengana</option><option value='Tripura'>Tripura</option><option value='Uttaranchal'>Uttaranchal</option><option value='Uttar Pradesh'>Uttar Pradesh</option><option value='West Bengal'>West Bengal</option></select>");
                 $("#gstinLabel").text("GSTIN");
             }
             else{
                 $("#stateDiv").html('<input type="text" class="form-control" name="state" id="state">');
                 $("#gstinLabel").text("Tax Number");
             }
         });
         
         $("#btnAddEditAddress").click(function(){
             if(validate()){
                 $.ajax({
                     url : "PHP/response.php",
                     data : $("#addEditAddress").serialize()+"&action=addEditAddress",
                     async: false,
                     method:"post",
                     success: function(response){
                        let result = response.trim();
                        if(result == "ADDED"){
                             localStorage.setItem("AddressAdded", "true");
                             location.reload();
                        }
                        else if(result == "UPDATED"){
                             localStorage.setItem("AddressUpdated", "true");
                             location.reload();
                        }
                        else{
                             errorMessage("Address could not be saved..");
                        }
                     },
                     error : function(err){
                         errorMessage("Address could not be saved..");
                     }
         
                 });
             }
         });
         
         function validate(){
             if($("#address").val() == ""){
                 errorToast("Please Enter Address");
                 return false;
             }
             if($("#country").val() == ""){
                 errorToast("Please Select Country");
                 return false;
             }
             if($("#country").val() == "India"){
                 if($("#state").val() == ""){
                     errorToast("Please Select State");
                     return false;
                 }
                 if($("#gstin").val() != ""){
                     var reg = /^([0-9]{2}[a-zA-Z]{4}([a-zA-Z]{1}|[0-9]{1})[0-9]{4}[a-zA-Z]{1}([a-zA-Z]|[0-9]){3}){0,15}$/;
                     var data = $("#gstin").val();
                     if (! data.match(reg)) {
                         errorToast("Please Enter valid GST Number");
                         return false;
                     }
                 }
                 
             }
             return true;
         }
         
         function deleteAddress(addressId){
             swal({
                 title: 'Are you sure?',
                 text: "Do you really want to delete this Address??",
                 type: 'warning',
                 showCancelButton: true,
                 confirmButtonColor: '#4fa7f3',
                 cancelButtonColor: '#d57171',
                 confirmButtonText: "Yes, I'm Sure!"
             }).then(function () {
                 $.ajax({
                 url : "PHP/response.php",
                 data : "addressId="+addressId+"&action=deleteAddressDetail",
                 async : false,
                 method : "post",
                 success : function(response){
                     if(response.trim() === "DELETED"){
                         localStorage.setItem("AddressDeleted", "true");
                         location.reload();
                     }
                     else{
                         errorMessage("Address could not be deleted.");
                     }
                 },
                 error:function(err){
                     errorMessage("Address could not be deleted.");
                 }
             }); 
             });
         }
         
         
         
         function errorToast(msg){
         $.toast({
             heading: 'Error!',
             text: msg,
             position: 'top-right',
             loaderBg: '#bf441d',
             icon: 'error',
             hideAfter: 3000,
             stack: 1
         });
         }
         
         function successMessage(msg){
         swal({
             title: 'Success!',
             text: msg,
             type: 'success',
             confirmButtonColor: '#4fa7f3'
         });
         }
         
         function errorMessage(msg){
         swal({
             title: 'Error!',
             text: msg,
             type: 'error',
             confirmButtonColor: '#4fa7f3'
         });
         }
         
      </script>
      <?php 
         if(isset($_SESSION['insert2']) && $_SESSION['insert2'] === "insert2" ){
            echo "<script>   $(window).load(function(){ $('#thankyouinsert2').modal('show');  });</script>";
            $_SESSION['insert2'] = '';
         }
         
         ?>
   </body>
</html>