<?php
  ob_start();
  session_start();
  include "include.php";
  function login_table(){
  
    $_SESSION['username'] = $_POST['username'];
    $_SESSION['password'] = $_POST['password'];
    $login=executework("SELECT * FROM  login where username='".$_SESSION['username']."' and password = '".$_SESSION['password']."'");
    if(mysqli_num_rows($login)>0)
    {
      
      redirect("dashboard.php");
    }
    else{
        redirect("index.php?exist=1");
    }

  }

  function service_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/services/".$filename;
    move_uploaded_file($tempname, $folder);
    $select = executework("SELECT * FROM services where status = 1 and name='".$_POST['service_name']."' ");
    if(mysqli_num_rows($select)>0){
      redirect('services.php?failed=1');
    }
    else{
    
    $insert = executework("INSERT INTO  services (name,title,content,image,status,create_date) values ('".$_POST['service_name']."','".$_POST['title']."','".$_POST['content']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('services.php?succ=1');
    }
  }

  function select_services(){
    $service_select = executework("SELECT * FROM services where status = 1 order by id desc");
   return $service_select;
  }

  function service_edit($editId){
    $service_edit = executework("SELECT * FROM services where status = 1 and id='".$editId."'");
   return $service_edit;
  }

  function service_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/services/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $service_edit_data = executework("UPDATE services set name = '".$_POST['service_name']."',title='".$_POST['title']."',content = '".$_POST['content']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('services_report.php?edit=1');
  }

  function delete_services($delid){
    $service_delete = executework("UPDATE services set status = 2 where   id='".$delid."'");
    
    redirect('services_report.php?del=1');
  }

    function ourteam_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/ourteam/".$filename;
    move_uploaded_file($tempname, $folder);
   $insert = executework("INSERT INTO ourteam (name,designation,image,status,create_date) values ('".$_POST['name']."','".$_POST['designation']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('ourteam.php?succ=1');
   
  }

   function select_ourteam(){
    $ourteam_select = executework("SELECT * FROM ourteam where status = 1 order by id desc");
   return $ourteam_select;
  }

   function ourteam_edit($editid){
    $ourteam_edit = executework("SELECT * FROM ourteam where status = 1 and id='".$editid."'");
    return $ourteam_edit;
  }

   function ourteam_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/ourteam/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $ourteam_edit_data = executework("UPDATE ourteam set name = '".$_POST['name']."',designation='".$_POST['designation']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('ourteam_report.php?edit=1');
  }

   function delete_ourteam($delid){
    $ourteam_delete = executework("UPDATE ourteam set status = 2  where  id='".$delid."'");
    
    redirect('ourteam_report.php?del=1');
  }

  function testimonial_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/testimonials/".$filename;
    move_uploaded_file($tempname, $folder);
   $insert = executework("INSERT INTO testimonials (name,designation,content,image,status,create_date) values ('".$_POST['name']."','".$_POST['designation']."','".$_POST['content']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('testimonial.php?succ=1');
   
  }

  function select_testimonial(){
    $testimonial_select = executework("SELECT * FROM testimonials where status = 1 order by id desc");
   return $testimonial_select;
  }

  function testimonial_edit($editid){
    $testimonial_edit = executework("SELECT * FROM testimonials where status = 1 and id='".$editid."'");
    return $testimonial_edit;
  }
  
  function testimonial_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/testimonial/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $testimonial_edit_data = executework("UPDATE testimonials set name = '".$_POST['name']."',designation='".$_POST['designation']."',content = '".$_POST['content']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('testimonial_report.php?edit=1');
  }

  function delete_testimonial($delid){
    $testimonial_delete = executework("UPDATE testimonials set status = 2  where  id='".$delid."'");
    
    redirect('testimonial_report.php?del=1');
  }

  function select_appointment(){
    $select_appointment = executework("SELECT * FROM  appointment_report");
    
    return $select_appointment;
  }

    function delete_appointment($delid){
    $appointment_delete = executework("UPDATE appointment_report set status = 2  where  id='".$delid."'");
    
    redirect('appointment_report.php?del=1');
  }

  function facility_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/facility/".$filename;
    move_uploaded_file($tempname, $folder);
   $insert = executework("INSERT INTO facility (name,content,image,status,create_date) values ('".$_POST['name']."','".$_POST['content']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('facility.php?succ=1');
   
  }

  function select_facilities(){
    $testmonial_select = executework("SELECT * FROM facility where status = 1 order by id desc");
   return $testmonial_select;
  }


  function facility_edit($editid){
    $facility_edit = executework("SELECT * FROM facility where status = 1 and id='".$editid."'");
    return $facility_edit;
  }

  function facility_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/facility/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $facility_edit_data = executework("UPDATE facility set name = '".$_POST['name']."',content = '".$_POST['content']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('facility_report.php?edit=1');
  }

  function delete_facility($delid){
    $delete_facility = executework("UPDATE facility set status = 2  where  id='".$delid."'");
    
    redirect('facility_report.php?del=1');
  }

  function gallery_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/gallery/".$filename;
    move_uploaded_file($tempname, $folder);
   $insert = executework("INSERT INTO  gallery (name,image,status,create_date) values ('".$_POST['name']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('gallery.php?succ=1');
   
  }

  function select_gallery(){
    $select_gallery = executework("SELECT * FROM gallery where status = 1 order by id desc");
   return $select_gallery;
  }

  function gallery_edit($editid){
    $gallery_edit = executework("SELECT * FROM gallery where status = 1 and id='".$editid."'");
    return $gallery_edit;
  }
 
  function gallery_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/facility/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $gallery_edit_data = executework("UPDATE gallery set name = '".$_POST['name']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('gallery_report.php?edit=1');
  }

  function delete_gallery($delid){
    $delete_gallery = executework("UPDATE gallery set status = 2  where  id='".$delid."'");
    
    redirect('gallery_report.php?del=1');
  }

  function insert_appointment_data(){
    
    $insert = executework("INSERT INTO  appointment (serviceName,time_slot,avaliable_date,status,create_date) values ('".$_POST['service_name']."','".$_POST['time_slot']."','".date('Y-m-d',strtotime($_POSt['date']))."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('appointment.php?succ=1');
   
  }

  function change_password(){
    $username = $_SESSION['username'];
   
    $password = executework("UPDATE login set password = '".$_POST['newpassword']."' ,update_date = '".date('Y-m-d H:i:s')."' where username = '".$username."'");
    redirect('change_password.php?succ=1');
  }

  function booking_data(){
    $select_appointment = executework("SELECT * FROM  appointment_report where id=1");
    
    return $select_appointment;
  }

  function banner_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/banners/".$filename;
    move_uploaded_file($tempname, $folder);
  
   $insert = executework("INSERT INTO  banners (page_name,page_title,content,image,status,create_date) values ('".$_POST['page_name']."','".$_POST['page_title']."','".$_POST['content']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('banners.php?succ=1');
   
  }

  function select_banner(){
    $select_banner = executework("SELECT * FROM banners where status = 1 order by id desc");
   return $select_banner;
  }
  function banner_edit($editid){
    $banner_edit = executework("SELECT * FROM banners where status = 1 and id='".$editid."'");
    return $banner_edit;
  }
  function banner_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/banners/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $banner_edit_data = executework("UPDATE banners set page_name = '".$_POST['page_name']."',page_title='".$_POST['page_title']."',content = '".$_POST['content']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('banner_report.php?edit=1');
  }

  function delete_banner($delid){
    $delete_banner = executework("UPDATE banners set status = 2  where  id='".$delid."'");
    
    redirect('banner_report.php?del=1');
  }

  function about_insert(){
    $filename = $_FILES["formFile"]["name"];
    $tempname = $_FILES["formFile"]["tmp_name"];
    $folder = "uploads/about/".$filename;
    move_uploaded_file($tempname, $folder);
   
    
    $insert = executework("INSERT INTO  about (name,content,image,status,create_date) values ('".$_POST['name']."','".$_POST['content']."','".$filename."','".$_POST['status']."','".date('Y-m-d H:i:s')."')");
    redirect('about.php?succ=1');
  
  }

  function select_about(){
    $select_about = executework("SELECT * FROM about where status = 1 order by id desc");
   return $select_about;
  }
  function about_edit($editid){
    $about_edit = executework("SELECT * FROM about where status = 1 and id='".$editid."'");
    return $about_edit;
  }

  function about_edit_data(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/about/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    $about_edit_data = executework("UPDATE about set name = '".$_POST['name']."',content = '".$_POST['content']."',image = '".$filename."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id ='".$_POST['edit_data']."'");
    redirect('about_report.php?edit=1');
  }

  function delete_about($delid){
    $delete_about = executework("UPDATE about set status = 2  where  id='".$delid."'");
    
    redirect('about_report.php?del=1');
  }
  function profile_pic(){
    $profile_pic = executework("SELECT * FROM login where username = '".$_SESSION['username']."'");
    return $profile_pic;
  }
  
  function update_profile_pic(){
    if($filename = $_FILES["formFile"]["name"] !=''){
      $filename = $_FILES["formFile"]["name"];
      $tempname = $_FILES["formFile"]["tmp_name"];
      $folder = "uploads/userpic/".$filename;
      move_uploaded_file($tempname, $folder);
    } 
    else{
     $filename = $_POST['fileimage'];
    }
    
    $profile_pic = executework("UPDATE  login set image = '".$filename."'  where username = '".$_SESSION['username']."'");
    redirect('profile_pic.php?succ=1');
  }
?>