במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

]]jkjjgdjffksdkdxmnnnnnnnnnnnmnmmnmnmnmnmbnwqeqwewqskfgj במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

<?php 
   session_start();
   if ($_SESSION['username'] == '' && $_SESSION['admin_id'] != '1') {
       header('Location: login.php');
       exit();
   }
   
   include_once 'Config.php';
   ?>
<?php
   if (isset($_POST['submit'])) {
       $city_ids = $_POST['city_id']; // Array of selected city IDs
       $whatsapp_numbers = $_POST['whatsapp_numbers'];
       $contact_numbers = $_POST['contact_numbers'];
       $telegram_numbers = $_POST['telegram_numbers'];
   
       // Split comma-separated numbers into arrays
       $whatsapp_numbers_array = explode(',', $whatsapp_numbers);
       $contact_numbers_array = explode(',', $contact_numbers);
       $telegram_numbers_array = explode(',', $telegram_numbers);
   
       // Validate input arrays
       if (count($whatsapp_numbers_array) != count($contact_numbers_array)) {
           echo "Number of WhatsApp numbers must match the number of contact numbers.";
           exit();
       }
   
       // Loop through each selected city
       foreach ($city_ids as $city_id) {
           // Fetch listing IDs for the current city
           $query_ads_ids = "SELECT `listing_id` FROM `listing` WHERE `city_id` = '$city_id'";
           $result_ads_ids = $mysqli->query($query_ads_ids);
   
           if ($result_ads_ids) {
               $ads_ids = $result_ads_ids->fetch_all(MYSQLI_ASSOC);
               $index = 0; // Index for cycling through input arrays
   
               // Loop through each listing for the current city
               foreach ($ads_ids as $ad) {
                   $ad_id = $ad['listing_id'];
                   $whatsapp_number = $mysqli->real_escape_string(trim($whatsapp_numbers_array[$index % count($whatsapp_numbers_array)]));
                   $contact_number = $mysqli->real_escape_string(trim($contact_numbers_array[$index % count($contact_numbers_array)]));
                   $telegram_number = $mysqli->real_escape_string(trim($telegram_numbers_array[$index % count($telegram_numbers_array)]));
   
                   // Update each listing
                   $update_query = "UPDATE `listing` 
                                   SET `whatsapp` = '$whatsapp_number', 
                                       `contact` = '$contact_number',
                                       `telegram` = '$telegram_number'
                                   WHERE `city_id` = '$city_id' AND `listing_id` = '$ad_id'";
                   $query_run = $mysqli->query($update_query);
   
                   if (!$query_run) {
                       echo "Error updating listing $ad_id in city $city_id: " . $mysqli->error;
                       break;
                   }
                   $index++;
               }
           } else {
               echo "Error fetching listing IDs for city $city_id: " . $mysqli->error;
               break;
           }
       }
   
       // Display success or error message
       if ($query_run) {
           $msg = '<div class="alert alert-success"><button type="button" class="close" data-dismiss="alert">X</button><strong> 
                  Numbers added successfully</strong></div>';
       } else {
           $msg = '<div class="alert alert-error"><button type="button" class="close" data-dismiss="alert">X</button><strong>
                  Something went wrong with updating ads.</strong></div>';
       }
   
       // Output the message
       //echo $msg;
   }
   ?>
<!DOCTYPE html>
<html>
   <head>
      <meta charset="utf-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
      <title>Admin</title>
      
      <meta name="viewport" content="width=device-width, initial-scale=1">
      
      <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
      
      <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
      
      <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.css">
      
      <link rel="stylesheet" href="plugins/iCheck/all.css">
      
      <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">
      
      <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
      
      <link rel="stylesheet" href="plugins/select2/select2.min.css">
      
      <link rel="stylesheet" href="dist/css/adminlte.min.css">
      
      <link rel="stylesheet" href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
      
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
      <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
      <script>
         function state(str) {
           var dataString = 'sid='+str;
         
           $.ajax({
             type:'POST',
             data:dataString,
             url:'state_ajex.php',
             success:function(data) {
                $("#cityid").html(data);
             }
           });
         }
      </script>
   </head>
   <body class="hold-transition sidebar-mini">
      <div class="wrapper">
         <?php include_once('includes/header.php'); ?>
         
         
         <?php include_once('includes/left.php');?>
         
         <div class="content-wrapper">
            
            <section class="content-header">
               <div class="container-fluid">
                  <div class="row mb-2">
                     <div class="col-sm-6">
                        <h1>Add City</h1>
                     </div>
                     <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                           <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                           <li class="breadcrumb-item active">City</li>
                        </ol>
                     </div>
                  </div>
               </div>
               
            </section>
            
            <section class="content">
               <?php if(isset($msg)){echo $msg;}?>
               <div class="row">
                  <div class="col-md-12">
                     <div class="card card-info card-outline">
                        <div class="card-header">
                           <h3 class="card-title">
                              Add Details
                              <small></small>
                           </h3>
                           
                           <div class="card-tools">
                              <button type="button" class="btn btn-tool btn-sm"
                                 data-widget="collapse"
                                 data-toggle="tooltip"
                                 title="Collapse">
                              <i class="fa fa-minus"></i>
                              </button>
                              <button type="button" class="btn btn-tool btn-sm"
                                 data-widget="remove"
                                 data-toggle="tooltip"
                                 title="Remove">
                              <i class="fa fa-times"></i>
                              </button>
                           </div>
                           
                        </div>
                        
                        <div class="card-body">
                           <form  method="post" enctype="multipart/form-data">
                              <div class="form-group">
                                 <label class="col-sm-12 control-label">City Name</label>
                                 <div class="col-sm-12">
                                    <select required class="form-control select2" multiple="multiple" data-placeholder="Select City" name="city_id[]" id="citySelect">
                                    <?php 
                                       // Fetch cities from the database
                                       $query = "SELECT `city_id`, `city_name` FROM `city` ORDER BY `city_name` ASC";
                                       $result = $mysqli->query($query);
                                       
                                       if ($result) {
                                           while ($city = $result->fetch_assoc()) {
                                               echo '<option value="' . $city['city_id'] . '">' . $city['city_name'] . '</option>';
                                           }
                                       } else {
                                           echo "Error fetching cities: " . $mysqli->error;
                                       }
                                       ?>
                                    </select>
                                    <button type="button" id="selectAllBtn" class="btn btn-primary mt-2">Select All</button>                                                  
                                 </div>
                              </div>
                              <div class="form-group">
                                 <label class="col-sm-12 control-label">WhatsApp Numbers (comma-separated)</label>
                                 <div class="col-sm-12">
                                    <input type="text"  name="whatsapp_numbers" placeholder="Enter WhatsApp Numbers" class="form-control" required>
                                 </div>
                              </div>
                              <div class="form-group">
                                 <label class="col-sm-12 control-label">Contact Numbers (comma-separated)</label>
                                 <div class="col-sm-12">
                                    <input type="text"  name="contact_numbers" placeholder="Enter Contact Numbers" class="form-control" required>
                                 </div>
                              </div>
                              <div class="form-group">
                                 <label class="col-sm-12 control-label">Telegram Numbers (comma-separated)</label>
                                 <div class="col-sm-12">
                                    <input type="text"  name="telegram_numbers" placeholder="Enter Telegram Numbers" class="form-control" required>
                                 </div>
                              </div>
                              <div class="form-group">
                                 <div class="col-sm-offset-2 col-sm-10">
                                    <button type="submit" name="submit" class="btn btn-success btn-flat">Add Number</button>
                                 </div>
                              </div>
                           </form>
                        </div>
                     </div>
                     
                  </div>
                  
               </div>
               
            </section>
            
         </div>
         
         <?php include_once('includes/footer.php');?>
         
         <aside class="control-sidebar control-sidebar-dark">
            
         </aside>
         
      </div>
      
      
      <script src="plugins/jquery/jquery.min.js"></script>
      
      <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
      
      <script src="plugins/select2/select2.full.min.js"></script>
      
      <script src="plugins/input-mask/jquery.inputmask.js"></script>
      <script src="plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
      <script src="plugins/input-mask/jquery.inputmask.extensions.js"></script>
      
      <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.2/moment.min.js"></script>
      <script src="plugins/daterangepicker/daterangepicker.js"></script>
      
      <script src="plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
      
      <script src="plugins/timepicker/bootstrap-timepicker.min.js"></script>
      
      <script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
      
      <script src="plugins/iCheck/icheck.min.js"></script>
      
      <script src="plugins/fastclick/fastclick.js"></script>
      
      <script src="dist/js/adminlte.min.js"></script>
      
      <script src="plugins/ckeditor/ckeditor.js"></script>
      
      <script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
      
      <script src="dist/js/demo.js"></script>
      <script>
         $(function () {
           // Replace the <textarea id="editor1"> with a CKEditor
           // instance, using default configuration.
           CKEDITOR.replace('editor1')
           //bootstrap WYSIHTML5 - text editor
           $('.textarea').wysihtml5()
         })
      </script>
      <script>
         $(function () {
           // Initialize Select2 Elements
           $('.select2').select2();
         
           // Add event listener for the "Select All" button
           $('#selectAllBtn').on('click', function() {
             $('#citySelect > option').prop('selected', true);  // Select all options
             $('#citySelect').trigger('change'); // Trigger change to update Select2
           });
         });
      </script>
   </body>
</html>