<?php
ini_set("display_errors", 0);
session_start();
$random_alpha1 = md5(rand());
$captcha_code1 = substr($random_alpha1, 0, 20);
$_SESSION["captcha_code1"] = $captcha_code1;

//echo $captcha_code1;
include '../tcf.php';

if ($_SESSION['tcf_name'] !== '' && $_SESSION['tcf_name'] !== null){
    $tcf_name = $_SESSION['tcf_name'];
    $tcf_address = $_SESSION['tcf_address'];
    $tcf_suburb = $_SESSION['tcf_suburb'];    
    $tcf_city = $_SESSION['tcf_city'];  
    $tcf_country = $_SESSION['tcf_country'];  
    $tcf_tel = $_SESSION['tcf_tel'];  
    $tcf_email = $_SESSION['tcf_email'];  
    $tcf_facebook = $_SESSION['tcf_facebook'];  
    $tcf_instagram = $_SESSION['tcf_instagram'];  
    $tcf_twitter = $_SESSION['tcf_twitter'];  
    $tcf_pinterest = $_SESSION['tcf_pinterest'];  
    $tcf_youtube = $_SESSION['tcf_youtube'];  
    $tcf_googleplus = $_SESSION['tcf_googleplus'];  
    $tcf_linkedin = $_SESSION['tcf_linkedin'];  
    $tcf_lat = $_SESSION['tcf_lat'];  
    $tcf_long = $_SESSION['tcf_long'];  
    $tcf_trading_hours = $_SESSION['tcf_trading_hours'];  
    
}else{
    $sql0 = 'SELECT * from contact_details';		
    $query0 = mysqli_query($conn, $sql0);
    while ($row = mysqli_fetch_array($query0)){
        $tcf_name = $row['t_name'];
        $tcf_address = $row['t_address'];
        $tcf_suburb = $row['t_suburb'];
        $tcf_city = $row['t_city'];
        $tcf_country = $row['t_country'];
        $tcf_tel = $row['t_tel'];
        $tcf_email = $row['t_email'];
        $tcf_facebook = $row['t_facebook'];
        $tcf_instagram = $row['t_instagram'];
        $tcf_twitter = $row['t_twitter'];
        $tcf_pinterest = $row['t_pinterest'];
        $tcf_youtube = $row['t_youtube'];
        $tcf_googleplus = $row['t_googleplus'];
        $tcf_linkedin = $row['t_linkedin'];
        $tcf_lat = $row['t_lat'];
        $tcf_long = $row['t_long'];
        $tcf_trading_hours = $row['trading_hours'];
    }
        $_SESSION['tcf_name'] = $tcf_name;
        $_SESSION['tcf_address'] = $tcf_address;
        $_SESSION['tcf_suburb'] = $tcf_suburb;    
        $_SESSION['tcf_city'] = $tcf_city;  
        $_SESSION['tcf_country'] = $tcf_country;  
        $_SESSION['tcf_tel'] = $tcf_tel;  
        $_SESSION['tcf_email'] = $tcf_email;  
        $_SESSION['tcf_facebook'] = $tcf_facebook;  
        $_SESSION['tcf_instagram'] = $tcf_instagram;  
        $_SESSION['tcf_twitter'] = $tcf_twitter;  
        $_SESSION['tcf_pinterest'] = $tcf_pinterest;  
        $_SESSION['tcf_youtube'] = $tcf_youtube;  
        $_SESSION['tcf_googleplus'] = $tcf_googleplus;  
        $_SESSION['tcf_linkedin'] = $tcf_linkedin;  
        $_SESSION['tcf_lat'] = $tcf_lat;  
        $_SESSION['tcf_long'] = $tcf_long;  
        $_SESSION['tcf_trading_hours'] = $tcf_trading_hours;  
    
}



$sql1 = 'SELECT * from tcf_pricing where t_status = "A"';		
$query1 = mysqli_query($conn, $sql1);

$sql2 = 'SELECT * from tcf_pricing where t_status = "A"';		
$query2 = mysqli_query($conn, $sql2);

$dir    = 'images/gallery/';
$files1 = scandir($dir);
shuffle($files1);

$digit_one = rand(1,9);
$digit_two = rand(1,9);
$digit_total = $digit_one+$digit_two;
$tcf_otp = rand(10000,99999);
$_SESSION['tcf_otp'] = $tcf_otp;
//print_r($files1);

include '../visitlog.php';
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>Tsumeb Copper Festival <?php echo date('Y') ?> #TCF<?php echo date('Y') ?></title>
    <meta content="width=device-width, initial-scale=1.0" name="viewport">
    <meta content="Tsumeb Copper Festival" name="keywords">
    <meta content="Tsumeb Copper Festival" name="description">
    <link rel="apple-touch-icon" sizes="57x57" href="favicon/apple-icon-57x57.png">
    <link rel="apple-touch-icon" sizes="60x60" href="favicon/apple-icon-60x60.png">
    <link rel="apple-touch-icon" sizes="72x72" href="favicon/apple-icon-72x72.png">
    <link rel="apple-touch-icon" sizes="76x76" href="favicon/apple-icon-76x76.png">
    <link rel="apple-touch-icon" sizes="114x114" href="favicon/apple-icon-114x114.png">
    <link rel="apple-touch-icon" sizes="120x120" href="favicon/apple-icon-120x120.png">
    <link rel="apple-touch-icon" sizes="144x144" href="favicon/apple-icon-144x144.png">
    <link rel="apple-touch-icon" sizes="152x152" href="favicon/apple-icon-152x152.png">
    <link rel="apple-touch-icon" sizes="180x180" href="favicon/apple-icon-180x180.png">
    <link rel="icon" type="image/png" sizes="192x192"  href="favicon/android-icon-192x192.png">
    <link rel="icon" type="image/png" sizes="32x32" href="favicon/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="96x96" href="favicon/favicon-96x96.png">
    <link rel="icon" type="image/png" sizes="16x16" href="favicon/favicon-16x16.png">
    <link rel="manifest" href="favicon/manifest.json">
    <meta name="msapplication-TileImage" content="favicon/ms-icon-144x144.png">
<?php include 'styles.php'; ?>
    <style>
        .galimg {
          width: 100%;
          display: block;
          object-fit: cover;
          margin-top: 0px;
          margin-bottom: 20px;
          /*border: 1px solid black;*/
          box-shadow: 1px 3px 8px rgba(0,0,0,0.5);
        }
        .galul {
          columns: 200px;
          break-inside: avoid;
          margin-left: 20px;
          margin-right: 20px;
          padding: 0;
        }
        .galli {
          list-style-type:none;
        }
    </style>
</head>

<body>

    <?php include 'navmenu.php'; ?>

    <!-- Carousel Start -->
    <!--<div class="container-fluid p-0">
        <div id="header-carousel" class="carousel slide" data-ride="carousel">
            <div class="carousel-inner">
                <div class="carousel-item active">
                    <img class="w-100" src="images/banner_2024.png" alt="Image">
                    <div class="carousel-caption d-flex flex-column align-items-center justify-content-center">
                        <div class="p-3" style="max-width: 900px;">
                            <h4 class="text-white text-uppercase mb-md-3">Tsumeb Copper Festival</h4>
                            <h1 class="display-3 text-white mb-md-4">2024</h1>
                            <a href="#StallBooking" class="btn btn-primary py-md-3 px-md-5 mt-2">Book Your Stall Now</a>
                        </div>
                    </div>
                </div>
                <div class="carousel-item">
                    <img class="w-100" src="img/carousel-2.jpg" alt="Image">
                    <div class="carousel-caption d-flex flex-column align-items-center justify-content-center">
                        <div class="p-3" style="max-width: 900px;">
                            <h4 class="text-white text-uppercase mb-md-3">TCF</h4>
                            <h1 class="display-3 text-white mb-md-4">2024</h1>
                            <a href="" class="btn btn-primary py-md-3 px-md-5 mt-2">Book Now</a>
                        </div>
                    </div>
                </div>
            </div>
            <a class="carousel-control-prev" href="#header-carousel" data-slide="prev">
                <div class="btn btn-dark" style="width: 45px; height: 45px;">
                    <span class="carousel-control-prev-icon mb-n2"></span>
                </div>
            </a>
            <a class="carousel-control-next" href="#header-carousel" data-slide="next">
                <div class="btn btn-dark" style="width: 45px; height: 45px;">
                    <span class="carousel-control-next-icon mb-n2"></span>
                </div>
            </a>
        </div>
    </div>-->
    <!-- Carousel End -->





    <!-- About Start -->
    <div class="container-fluid py-5">
        <div class="container pt-5">
            <img src="images/banner120years.jpg" style="max-width: 100%; margin: auto;">
            <div class="row">
               <div class="col-lg-6">
                   <img class="position-absolute w-100 h-100" src="images/tsb_copperfest2025.png">
               </div>
            </div>
            <div class="row">
                <!--<div class="col-lg-6" style="min-height: 450px;">
                    <div class="position-relative h-100">
                        <img class="position-absolute w-100 h-100" src="images/tsb_copperfest2025.png">
                    </div>
                </div>-->
                <div class="col-lg-5 pt-5 pb-lg-5">
                    <div class="about-text bg-white p-4 p-lg-5 my-lg-5">
                        <h6 class="text-primary text-uppercase" style="letter-spacing: 5px;">About Us</h6>
                        <h1 class="mb-3">Tsumeb Copper Festival</h1>
                        <p>Tsumeb Municipality social event aiming at creating a platform for SMEs.</p>
                        <div class="row mb-4">
                            <div class="col-6">
                                <img class="img-fluid" src="images/gallery/IMG-20240708-WA0139.jpg" alt="" style="height: 200px; width: 200px; object-fit: cover;">
                            </div>
                            <div class="col-6">
                                <img class="img-fluid" src="images/gallery/IMG-20240708-WA0128.jpg" alt="" style="height: 200px; width: 200px; object-fit: cover;">
                            </div>
                        </div>
                        <a href="#StallBooking" class="btn btn-primary mt-1">Book Your Stall Now</a>
                    </div>
                </div>
                <div class="col-lg-1">
                    <!--<div class="position-relative h-100">
                        <img class="position-absolute w-100 h-100" src="images/tsb_copperfest2025.png">
                    </div>-->
                </div>
                
        <div class="col-lg-5 pt-5 pb-lg-5">
            <div class="text-center mb-3 pb-3">
                <h6 class="text-primary text-uppercase" style="letter-spacing: 5px;">Stands</h6>
                <h1>Our Stand Prices</h1>
            </div>
                                            <table style="max-width: 450px; margin: auto; border: 1px solid grey;" class="table table-sm">
                                                <thead>
                                                <th style="padding: 10px;">Stand type</th>
                                                <th style="padding: 10px;">Price</th>
                                                </thead>
                                                <tbody>
                                                    <?php
                                                    while ($row = mysqli_fetch_array($query1)){
                                                        echo '<tr>';
                                                        echo '<th style="font-weight: normal;">'.$row['t_desc'].'</th>';
                                                        echo '<td>'.$row['t_price'].'</td>';
                                                        echo '</tr>';
                                                    }
                                                    
                                                    ?>
                                                    <!--<tr>
                                                        <td>Food & Beverage Stalls</td>
                                                        <td style="width: 100px;">N$ 3,000.00</td>
                                                    </tr>
                                                    <tr>
                                                        <td>Food Stalls</td>
                                                        <td>N$ 2,000.00</td>
                                                    </tr>
                                                    <tr>
                                                        <td>SME Stalls</td>
                                                        <td>N$ 1,000.00</td>
                                                    </tr>
                                                    <tr>
                                                        <td>Commercial /Corporate Stalls</td>
                                                        <td>N$ 4,000.00</td>
                                                    </tr>
                                                    <tr>
                                                        <td>Industrial Stalls</td>
                                                        <td>N$ 4,500.00</td>
                                                    </tr>
                                                    <tr>
                                                        <td>Kiddies Stalls for jumping castles and games for kids</td>
                                                        <td>N$ 1,000.00</td>
                                                    </tr>-->
                                                </tbody>
                                            </table>
            <br>
                        <div style="max-width: 450px; margin: auto;">
                            <hr>
                            <b>For more information please contact:</b>
                            <br>
                            The chairperson: Mr. Julius Gaeseb
                            <br>
                            Tel: 067 221 056 | Cell: 0811460166
                            <br>
                            Email: jgaeseb@tsumebmun.org.na
                            <br>
                            <br>
                            <b>For enquiries about the booking of stalls please contact:</b>
                            <br>
                            Mr. Hofni Hamunyela | Cell: 0813513810
                            <br>
                            Email: hamunyelahofni@yahoo.com
                            <br>

                            <hr>
                        </div>
            <div style="max-width: 450px; margin: auto;">
                <h3><!--<img src="images/pdf_icon.png" height="50"> -->Application Forms</h3>
                <a href="pdf/TCF-sme.pdf" target="_blank">SME Stalls</a><br>
                <a href="pdf/TCF-commercial.pdf" target="_blank">Commercial /Corporate Stalls</a><br>
                <a href="pdf/TCF-foodbeverages.pdf" target="_blank">Food & Beverages Stalls</a><br>
                <a href="pdf/TCF-food.pdf" target="_blank">Food Stalls</a><br>
                <a href="pdf/TCF-kiddies.pdf" target="_blank">Kiddies Stalls</a><br>
                <a href="pdf/TCF-industrial.pdf" target="_blank">Industrial Stalls</a><br>
                <a href="pdf/TCF-Auditions.pdf" target="_blank">Auditions</a><br>
                <hr>
            </div>

        </div>
                
                
            </div>
        </div>
    </div>
    <!-- About End -->

    <!-- Registration Start -->
    <div class="container-fluid bg-registration py-5" style="margin: 90px 0;" id="StallBooking">
        <div class="container py-5">
            <div class="row align-items-center">
                <!--<div class="col-lg-7 mb-5 mb-lg-0">
                    <div class="mb-4">
                        <h6 class="text-primary text-uppercase" style="letter-spacing: 5px;">Mega Offer</h6>
                        <h1 class="text-white"><span class="text-primary">30% OFF</span> For Honeymoon</h1>
                    </div>
                    <p class="text-white">Invidunt lorem justo sanctus clita. Erat lorem labore ea, justo dolor lorem ipsum ut sed eos,
                        ipsum et dolor kasd sit ea justo. Erat justo sed sed diam. Ea et erat ut sed diam sea ipsum est
                        dolor</p>
                    <ul class="list-inline text-white m-0">
                        <li class="py-2"><i class="fa fa-check text-primary mr-3"></i>Labore eos amet dolor amet diam</li>
                        <li class="py-2"><i class="fa fa-check text-primary mr-3"></i>Etsea et sit dolor amet ipsum</li>
                        <li class="py-2"><i class="fa fa-check text-primary mr-3"></i>Diam dolor diam elitripsum vero.</li>
                    </ul>
                </div>-->
                <div class="col-lg-12">
                    <div class="card border-0">
                        <div class="card-header bg-primary text-center p-4">
                            <h1 class="text-white m-0">Book Your Stall</h1>
                        </div>
                        <div class="card-body rounded-bottom bg-white p-5">
                            <form method="POST" name="sentMessage" id="contactForm" enctype="multipart/form-data" action="stallbk.php">
                                <div class="row">
                                <div class="col-lg-5 mb-5 mb-lg-0">
                                <div class="form-group">
	                            <input type="text" class="form-control p-4" placeholder="Name of Exhibitor/Business *" id="reg_name" name="reg_name" required data-validation-required-message="Please enter your name.">
	                            <p class="help-block text-danger"></p>
                                </div>
                                <div class="form-group">
	                        <input type="text" class="form-control p-4" placeholder="Postal Address" id="reg_postal" name="reg_postal" data-validation-required-message="Please enter your postal address.">
	                        <p class="help-block text-danger"></p>
                                </div>
                                <div class="form-group">
                                            <select class="custom-select px-4" id="reg_postal_town" name="reg_postal_town" required class="form-control">
                                                <option value="">Please Select a Town</option>
                                                <option>Arandis</option>
                                                <option>Aranos</option>
                                                <option>Eenhana</option>
                                                <option>Gobabis</option>
                                                <option>Grootfontein</option>
                                                <option>Helao Nafidi</option>
                                                <option>Henties Bay</option>
                                                <option>Karasburg</option>
                                                <option>Karibib</option>
                                                <option>Katima Mulilo</option>
                                                <option>Keetmanshoop</option>
                                                <option>Khorixas</option>
                                                <option>Lüderitz</option>
                                                <option>Mariental</option>
                                                <option>Nkurenkuru</option>
                                                <option>Okahandja</option>
                                                <option>Okahao</option>
                                                <option>Okakarara</option>
                                                <option>Omaruru</option>
                                                <option>Omuthiya</option>
                                                <option>Ondangwa</option>
                                                <option>Ongwediva</option>
                                                <option>Oniipa</option>
                                                <option>Opuwo</option>
                                                <option>Oranjemund</option>
                                                <option>Oshakati</option>
                                                <option>Oshikuku</option>
                                                <option>Otavi</option>
                                                <option>Otjiwarongo</option>
                                                <option>Outapi</option>
                                                <option>Outjo</option>
                                                <option>Rehoboth</option>
                                                <option>Ruacana</option>
                                                <option>Rundu</option>
                                                <option>Swakopmund</option>
                                                <option>Tsumeb</option>
                                                <option>Usakos</option>
                                                <option>Walvis Bay</option>
                                                <option>Windhoek</option>
                                            </select>
	                                    <p class="help-block text-danger"></p>
                                </div>
	                                <div class="form-group">
	                                    <input type="email" class="form-control p-4" placeholder="Your Email Address*" id="reg_email" name="reg_email" required data-validation-required-message="Please enter your email address.">
	                                    <p class="help-block text-danger"></p>
	                                </div>
                                
                                
	                                <div class="form-group">
	                                    <input type="tel" class="form-control p-4" placeholder="Your Contact Number*" id="phone" name="reg_phone" required data-validation-required-message="Please enter your phone number.">
	                                    <p class="help-block text-danger"></p>
	                                </div>
                                        
	                                <div class="form-group">
	                                    <input type="tel" class="form-control p-4" placeholder="Your Mobile Number *" id="reg_cell" name="reg_cell" required data-validation-required-message="Please enter your phone number.">
	                                    <p class="help-block text-danger"></p>
	                                </div>

                                </div>
                                <div class="col-lg-5 mb-5 mb-lg-0">
	                                <div class="form-group">
	                                    <input type="tel" class="form-control p-4" placeholder="Your Fax Number" id="reg_fax" name="reg_fax" data-validation-required-message="Please enter your phone number.">
	                                    <p class="help-block text-danger"></p>
	                                </div>
	                                <div class="form-group">
                                            <!--<p>Stall Type</p>-->
                                            <select id="reg_stall_type" name="reg_stall_type" required class="custom-select px-4" data-validation-required-message="Please select your stall type.">
                                                <option value="">Please Select a Stall Type</option>
                                                <?php
                                                while ($row = mysqli_fetch_array($query2)){
                                                 echo '<option>'.$row['t_desc'].' ('.$row['t_price'].')</option>';
                                                }
                                                ?>
                                                <!--<option>Food & Beverage Stalls (N$3,000.00)</option>
                                                <option>Food Stalls (N$2,000)</option>
                                                <option>SME Stalls (N$1,000.00)</option>
                                                <option>Commercial / Corporate Stalls (N$4,000.00)</option>
                                                <option>Industrial Stalls (N$4,500.00)</option>
                                                <option>Kiddies Stalls for jumping castle and games for kids (N$1,000.00)</option>-->
                                            </select>
	                                </div>
                                
                                        <!--<p>Please Select Exhibition Category</p>-->
                                        <div class="form-group">
                                            <select name="reg_category" required class="custom-select px-4">
                                                <option value="">Please Select Exhibition Category</option>
                                                <option>Agriculture</option>
                                                <option>Art/Craft/Pottery</option>
                                                <option>Automobiles</option>
                                                <option>Banking/Insurance</option>
                                                <option>Beauty/Health Care</option>
                                                <option>Chemicals/Pharmaceuticals</option>
                                                <option>Clothing/Textiles</option>
                                                <option>Education</option>
                                                <option>Entertainment</option>
                                                <option>Food and Beverages</option>
                                                <option>Government/Parastatal</option>
                                                <option>Horticulture</option>
                                                <option>Industrial</option>
                                                <option>Information & Communication Technology</option>
                                                <option>Manufacturing</option>
                                                <option>Media</option>
                                                <option>Non-Governmental Organization</option>
                                                <option>Office Equipment</option>
                                                <option>Others /SME/Kiddies</option>
                                                <option>Property Real Estate Development</option>
                                                <option>Tourism/Hospitality</option>
                                            </select>
                                        </div>
                                        
	                                <div class="form-group">
	                                    <textarea class="form-control p-4" placeholder="Your Comments *" id="reg_comment" name="reg_comment" data-validation-required-message="Comment"></textarea>
	                                    <p class="help-block text-danger"></p>
	                                    <div id="success"></div>
                                            <input type="hidden" name="form_type" value="stall_booking">
                                            <input type="hidden" name="app_ref" value="<?php echo $captcha_code1 ?>">
                                        </div>
                                <div>
                                    <span>&nbsp;&nbsp; <?php echo $digit_one; ?> + <?php echo $digit_two; ?> = 
                                        <input class="p-2" type="number" name="formula_a" id="formula_a" required style="width: 75px;" onChange="chkAns();">
                                        
                                    </span>
                                    <br><br>
                                    <button class="btn btn-primary btn-block py-3" type="submit">Submit Booking</button>
                                </div>

                                </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Registration End -->

    <script type="text/javascript">
        function chkAns(){
            var digit_one = '<?php echo $digit_one ?>';
            var digit_two = '<?php echo $digit_two ?>';
            var digit_tt = '<?php echo $digit_total ?>';
            var answ = digit_one+digit_two;
            var user_answ = document.getElementById("formula_a").value;
            
            if (user_answ !== digit_tt){
                alert('Incorrect answer, please try again');
                document.getElementById("formula_a").value = '';
            }
                
        }
    </script>


    <!-- Gallery Start -->
    <div class="container-fluid py-5">
        <div class="container pt-5 pb-3">
            <div class="text-center mb-3 pb-3">
                <h6 class="text-primary text-uppercase" style="letter-spacing: 5px;">Gallery</h6>
                <h1>Explore our Photo Gallery</h1>
            </div>
<div class="gallery" style="border: 1px solid lightgrey; padding: 5px;">
  <ul class="galul">
      <?php
      $no_of_files = count($files1);
      //echo $no_of_files;
      for ($a = 0; $a < $no_of_files; $a++){
          if ($a > 2 && $a < 13){
              //echo $files1[$a];
              echo '<li class="galli"><img class="galimg" src="images/gallery/'.$files1[$a].'" /></li>';
          }
      }
      
      ?>

  </ul>
</div>
            <a href="gallery.php" class="btn btn-primary mt-1">View More</a>
        </div>
    </div>
    <!-- Gallery Start -->




<?php include 'footer.php'; ?>


    <!-- Back to Top -->
    <a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i class="fa fa-angle-double-up"></i></a>


<?php include 'js_lib.php'; ?>
</body>

</html>