1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / new / admin / pages / member /
Filename : update.php
back
<?php
    session_start();
    if(isset($_SESSION['id']) && $_SESSION['id']) {
       
    
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Community Directory</title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="../../bower_components/font-awesome/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="../../bower_components/Ionicons/css/ionicons.min.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="../../dist/css/AdminLTE.min.css">

    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="../../dist/css/skins/_all-skins.min.css">


    <!-- Google Font -->
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>
<body onload="viewdata()"  class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">


    <?php include "../../dist/resources/header.php" ?>

    <?php include "../../dist/resources/inner-sidebar.php" ?>

    <?php include "../../dist/resources/config.php" ?>

    <?php
 date_default_timezone_set("Africa/Nairobi");
    $id = $_GET['id'];

    $sql = "SELECT * FROM users WHERE id = '$id' ";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()) {
           $id = $row["id"];
           $first_name = $row["first_name"];
            $middle_name = $row["middle_name"];
            $nick_name = $row["nick_name"];
            $last_name = $row["last_name"];
            $status = $row["status"];
            $personal_email = $row["personal_email"];
            $work_email = $row["work_email"];
            $phone_number = $row["phone_number"];
            $work_phone_number = $row["work_phone_number"];
            $dob = $row["dob"];
            $organization = $row["organization"];
            $position = $row["position"];
            $address = $row["address"];
            $blood_group = $row["blood_group"];
            $password = $row["password"];
            $role = $row["role"];
        }
    } else {
        echo "0 results";
    }



    if(isset($_POST['update'])){

        $f_name = $_POST['f_name'];
        $l_name = $_POST['l_name'];
        $p_email = $_POST['p_email'];
        $p_number = $_POST['p_number'];
        $new_dob = $_POST['dob'];
        $new_address = $_POST['address'];
        $new_blood = $_POST['blood'];
        $al = $_POST['pass'];
        $m_name = $_POST['m_name'];
        $n_name = $_POST['n_name'];
        $w_email = $_POST['w_email'];
        $w_number = $_POST['w_number'];
        $new_organization = $_POST['organization'];
        $new_position = $_POST['position'];
        $new_status = $_POST['status'];
        
        $pass = sha1($al);

        $insert = "UPDATE users set first_name = '$f_name',
 middle_name = '$m_name', nick_name = '$n_name', last_name = '$l_name', status = '$new_status', 
  personal_email = '$p_email', work_email = '$w_email', phone_number = '$p_number', work_phone_number = '$w_number', 
   dob = '$new_dob', organization = '$new_organization', position = '$new_position', address = '$new_address', 
    blood_group = '$new_blood' where id = '$id'";

        if($conn->query($insert)== TRUE){
            ?>
            <script> alert(' <?php echo "Successfully Updated"?>'); </script>
            
        <?php
        

        }else{

        ?>
            <script> alert(' <?php echo "Error"?>'); </script>
            <?php
        }

    }
    if(isset($_POST['approve'])){
        date_default_timezone_set("Africa/Nairobi");
        $t = date("H:i:s");
        $t=date('H:i:s',strtotime('+0 hour',strtotime($t)));
        $d=date("Y/m/d");
        $dt=$d.' '.$t;

        $f_name = $_POST['f_name'];
        $l_name = $_POST['l_name'];
        $p_email = $_POST['p_email'];
        $p_number = $_POST['p_number'];
        $new_dob = $_POST['dob'];
        $new_address = $_POST['address'];
        $new_blood = $_POST['blood'];
        $al = $_POST['pass'];
        $m_name = $_POST['m_name'];
        $n_name = $_POST['n_name'];
        $w_email = $_POST['w_email'];
        $w_number = $_POST['w_number'];
        $new_organization = $_POST['organization'];
        $new_position = $_POST['position'];
        $new_status = "active";
        $al=rand(1001,9999);
        
        $pass = sha1($al);
        
        $res = $conn->query("select community from users where personal_email='$p_email'");
        while ($row = $res->fetch_assoc()) {
            $cid=$row['community'];
        }
        
        $ress = $conn->query("select prefix, community_name from community where id='$cid'");
        while ($roww = $ress->fetch_assoc()) {
            $pr=$roww['prefix'];
            $cmn=$roww['community_name'];
            
        }
        
        $resu = $conn->query("select max(mid) as r from users where community='$cid'");
        $rowww = $resu->fetch_assoc();
        $r=$rowww['r'];
        $mbn=$r+1;
        $num_p = sprintf("%04d", $mbn);
        $members=$pr.$num_p;
        $st='inactive';
        $re = $conn->query("select * from users where personal_email='$p_email' and membership_id !='' and community='$cid'");
        $ro = $re->num_rows;
        $r='rejected';
        $reje = $conn->query("select * from users where personal_email='$p_email' and status ='$r'");
        $rej = $reje->num_rows;

        $insert = "UPDATE users set first_name = '$f_name',
 middle_name = '$m_name', nick_name = '$n_name', last_name = '$l_name', status = '$new_status', 
  personal_email = '$p_email', work_email = '$w_email', phone_number = '$p_number', work_phone_number = '$w_number', 
   dob = '$new_dob', organization = '$new_organization', position = '$new_position', membership_id = '$members', mid='$mbn',password='$pass', address = '$new_address', 
    blood_group = '$new_blood', t_approved = '$dt' where id = '$id' and membership_id =''";

        if($rej<1)
        {
        if($ro<1){
        if($conn->query($insert)== TRUE){
            ?>
            <script> alert(' <?php echo "Applicant Approved"?>'); </script>

        <?php
        
        
        if($cid='7'){
        $subject = 'Business & Professionals by Hindu Council of Kenya Registration Approval';
        $message = 'Dear '.$f_name.', <br><br> Your application has been approved. <br><br> Your details for the app are: <br><br> Membership ID: <b> '.$members.' </b> <br> Your Password is: <b> '.$al.' </b> <br> You can download the app from: https://play.google.com/store/apps/details?id=io.biocard.hinducouncil <br><br> Thank you.<br> BioCard Team.<br>www.biocard.io<br><img src="https://biocard.io/m/community/images/logo.png" style="width:120px;height:57px;"/>';
        $headers = 'From: hck@biocard.io' . "\r\n" .
            'Reply-To: barot.bhavya@biocard.io' . "\r\n" .
            'X-Mailer: PHP/' . phpversion() .
            'charset=utf-8' . "\r\n" .
            'Content-type: text/html';
        
        mail($p_email, $subject, $message, $headers);
        
        $subject = $f_name.', do you need help on the Business & Professionals App?';
        $message = "Hi ".$f_name.", <br><br> I'm Bhavya Barot, Software Developer at BioCard. You've signed up for Hindu Council of Kenya App most likely in search of a better way to communicate. Trying a new product can be stressful and time consuming, but rest assured... I'm here to help! </b> <br><br>You can <a href='https://calendly.com/barot-bhavya'>schedule a call with me</a> where we can go through all your questions. I will show you how to best use the Community App based on your needs, plus some cool tips & tricks.<br><br>Or dont hesitate to just reply to this email and tell me any feedback you have. I like to hear everything: the <strong>good</strong>, the <strong>bad</strong>, and the <strong>ugly!</strong><br><br> Bhavya Barot<br>Software Developer<br>Contact <a href='linkedin.com/in/barot-bhavya/'>me</a> on Linkedin<br><a href='https://www.biocard.io'><img src='https://biocard.io/m/community/images/logo.png' style='width:120px;height:57px;'/></a>";
        $headers = 'From: barot.bhavya@biocard.io' . "\r\n" .
            'Reply-To: barot.bhavya@biocard.io' . "\r\n" .
            'X-Mailer: PHP/' . phpversion() .
            'charset=utf-8' . "\r\n" .
            'Content-type: text/html';
        
        mail($p_email, $subject, $message, $headers);
        }
        else
        {
        $subject = 'Community App Registration Approval';
        $message = 'Dear '.$f_name.', <br><br> Your application has been approved. <br><br> Your details for the app are: <br><br> Membership ID: <b> '.$members.' </b> <br> Your Password is: <b> '.$al.' </b> <br><br> Thank you.<br> BioCard Team.<br>www.biocard.io<br><img src="https://biocard.io/m/community/images/logo.png" style="width:120px;height:57px;"/>';
        $headers = 'From: community@biocard.io' . "\r\n" .
            'Reply-To: barot.bhavya@biocard.io' . "\r\n" .
            'X-Mailer: PHP/' . phpversion() .
            'charset=utf-8' . "\r\n" .
            'Content-type: text/html';
        
        mail($p_email, $subject, $message, $headers);
        
        
        $subject = $f_name.', do you need help on the Community App?';
        $message = "Hi ".$f_name.", <br><br> I'm Bhavya Barot, Software Developer at BioCard. You've signed up for Community App most likely in search of a better way to communicate. Trying a new product can be stressful and time consuming, but rest assured... I'm here to help! </b> <br><br>You can <a href='https://calendly.com/barot-bhavya'>schedule a call with me</a> where we can go through all your questions. I will show you how to best use the Community App based on your needs, plus some cool tips & tricks.<br><br>Or dont hesitate to just reply to this email and tell me any feedback you have. I like to hear everything: the <strong>good</strong>, the <strong>bad</strong>, and the <strong>ugly!</strong><br><br> Bhavya Barot<br>Software Developer<br>Contact <a href='linkedin.com/in/barot-bhavya/'>me</a> on Linkedin<br><a href='https://www.biocard.io'><img src='https://biocard.io/m/community/images/logo.png' style='width:120px;height:57px;'/></a>";
        $headers = 'From: barot.bhavya@biocard.io' . "\r\n" .
            'Reply-To: barot.bhavya@biocard.io' . "\r\n" .
            'X-Mailer: PHP/' . phpversion() .
            'charset=utf-8' . "\r\n" .
            'Content-type: text/html';
        
        mail($p_email, $subject, $message, $headers);}        

        }
        }
        else{

        ?>
            <script> alert(' <?php echo "Error: User has already been approved"?>'); </script>
            <?php
        }
        }else{
            ?>
            <script> alert(' <?php echo "Error: User has already been Rejected"?>'); </script>
            <?php
        }

    }
    
    if(isset($_POST['updatepassword'])){

        $al = $_POST['pass'];
        
        $pass = sha1($al);

        $insert = "UPDATE users SET password = '$pass' where id = '$id'";

        if($conn->query($insert)== TRUE){
            ?>
            <script> alert(' <?php echo "Successfully Updated"?>'); </script>

        <?php

        }else{

        ?>
            <script> alert(' <?php echo "Error"?>'); </script>
            <?php
        }

    }
    if(isset($_POST['reject'])){
        $f_name = $_POST['f_name'];
         $p_email = $_POST['p_email'];
         $status = "rejected";
        $reject = "UPDATE users SET status= '$status' where id = '$id'";

        if($conn->query($reject)== TRUE){
            ?>
            <script> alert(' <?php echo "Applicant has been Notified"?>'); </script>

        <?php
        $subject = 'App Registration Status';
        $message = 'Dear '.$f_name.', <br><br> Your application has been rejected. <br><br> Kindly contact your community for further details.</b> <br><br> Thank you.<br> BioCard Team.<br>www.biocard.io<br><img src="https://biocard.io/m/community/images/logo.png" style="width:125px;height:77px;"/>';
        $headers = 'From: community@biocard.io' . "\r\n" .
            'Reply-To: barot.bhavya@biocard.io' . "\r\n" .
            'X-Mailer: PHP/' . phpversion() .
            'charset=utf-8' . "\r\n" .
            'Content-type: text/html';
        
        mail($p_email, $subject, $message, $headers);

        }else{

        ?>
            <script> alert(' <?php echo "Error"?>'); </script>
            <?php
        }
    }

    ?>

    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <h1>
                Update Member
                <small>Community</small>
            </h1>
            <ol class="breadcrumb">
                <li><a href="index.php"><i class="fa fa-fw fa-users"></i> Members</a></li>
                <li class="active">Dashboard</li>
            </ol>
        </section>

        <!-- Main content -->
        <section class="content">
            <!-- Main row -->
            <div class="row">
                <div class="col-md-12">
                    <div class="box">
                        <div class="box-header with-border">
                            <h3 class="box-title">Update Member</h3>
                        </div>
                        <!-- /.box-header -->
                        <div class="box-body">
                            <div class="row">
                                <form method="post">
                                    <div class="col-md-6">

                                        <div class="form-group">
                                            <label>First Name</label>
                                            <input type="text" class="form-control" name="f_name" value="<?php echo $first_name; ?>">
                                        </div>
                                        <!-- /.form-group -->
                                        <div class="form-group">
                                            <label>Last Name</label>
                                            <input type="text" class="form-control" name="l_name" value="<?php echo $last_name; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Personal Email</label>
                                            <input type="email" class="form-control" name="p_email" value="<?php echo $personal_email; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Personal Number</label>
                                            <input type="text" class="form-control" name="p_number" value="<?php echo $phone_number; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>DOB</label>
                                            <input type="date" class="form-control" name="dob" value="<?php echo $dob; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Home Address</label>
                                            <input type="text" class="form-control" name="address" value="<?php echo $address; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Blood Group</label>
                                            <input type="text" class="form-control" name="blood" value="<?php echo $blood_group; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Password</label>
                                            <input type="password" class="form-control" name="pass" value="<?php echo $password; ?>">
                                        </div>
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label>Middle Name</label>
                                            <input type="text" class="form-control" name="m_name" value="<?php echo $middle_name; ?>">
                                        </div>
                                        <!-- /.form-group -->
                                        <div class="form-group">
                                            <label>Nick Name</label>
                                            <input type="text" class="form-control" name="n_name" value="<?php echo $nick_name; ?>">
                                        </div>
                                        <div class="form-group">
                                            <label>Work Email</label>
                                            <input type="email" class="form-control" name="w_email" value="<?php echo $work_email; ?>">
                                        </div>
                                        <div class="form-group">
                                            <label>Work Number</label>
                                            <input type="text" class="form-control" name="w_number" value="<?php echo $work_phone_number; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Organization</label>
                                            <input type="text" class="form-control" name="organization" value="<?php echo $organization; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Position</label>
                                            <input type="text" class="form-control" name="position" value="<?php echo $position; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label>Status</label>
                                            <select class="form-control" name="status">
                                                <option <?php if($status==$status){ ?> selected="selected" <?php }?> value='<?php echo $status; ?>' >
                                                    <?php echo $status; ?>
                                                </option>
                                                <option value="active">Active</option>
                                                <option value="inactive">Inactive</option>
                                            </select>
                                        </div>


                                        <!-- /.form-group -->
                                    </div>
                                    <!-- /.col -->
                            </div>
                            <!-- /.row -->
                        </div>
                        <div class="box-footer">
                            <button type="submit" name="update" class="btn btn-primary">Update Profile</button>
                            <button type="submit" name="updatepassword" class="btn btn-primary">Update Password</button>
                            <button type="submit" name="approve" class="btn btn-primary">Approve</button>
                            <button type="submit" name="reject" class="btn btn-primary">Reject</button>
                        </div>
                    </div>
                    </form>
                    <!-- /.box -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
    </div>
    <!-- /.row (main row) -->

    </section>
    <!-- /.content -->
</div>

<?php include "../../dist/resources/footer.php" ?>

</div>
<!-- ./wrapper -->

<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="js/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
</body>
</html>
<?php
} else if(!isset($_SESSION['id']) || (isset($_SESION['id']) && $_SESSION['id'] == 0)){
        //session is not set
        header('Location: ../../dist/resources/logout.php');
    }
?>