<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

include('header.php');
include('sidebar.php');
include_once('../wp-config.php');

$allplans = "SELECT plan_id, plan_name FROM wp_psy_plans";
$allplansData = $wpdb->get_results($allplans);
?>

<div class="page-wrapper">
    <div class="page-breadcrumb">
        <div class="row">
            <div class="col-12 align-self-center">
                <h4 class="page-title text-truncate text-dark font-weight-medium mb-1">Plan Request</h4>
                <div class="d-flex align-items-center">
                    <nav aria-label="breadcrumb">
                        <ol class="breadcrumb m-0 p-0">
                            <li class="breadcrumb-item"><a href="dashboard" class="text-muted">Home</a></li>
                            <li class="breadcrumb-item text-muted active" aria-current="page">Plan Request</li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>
    </div>
    <div class="container-fluid">
        <div class="row">
<?php

if (isset($_REQUEST['plan-request'])) {
    $plan_id = $_REQUEST['plan_id'];
    $plan_count = $_REQUEST['plan_count'];
    $USERID = $_SESSION['user_id'];
    $curDateTime = date('Y-m-d H:i:s');
    
    $a=0;;
   	foreach($plan_id as $pln){

    $wpdb->query("INSERT INTO  wp_psy_plan_request SET plan_id ='$pln', plan_count='$plan_count[$a]', date='$curDateTime'");  

    $errorMsg = '<span style="color:#1c700ed6;font-size:18px;text-align:center;"> your request has been sent </span>';

   	$a++;
   }


//print_r($plan_id);

   // $wpdb->query("UPDATE wp_psy_bulk_plan SET count='$remainingPlan' WHERE school_id='$USERID' AND plan_id='$Type'");

   // $wpdb->query("INSERT INTO wp_psy_bulk_plan_transactions SET school_id='$USERID',student_id='$user_id', plan_id='$Type', total_plan ='$TotalCount', remaining_plan='$remainingPlan', date='$curDateTime'");


 }
?>
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <h4 class="card-title">Plan Request</h4>
                        <?php if (isset($errorMsg)) {
                            echo $errorMsg;
                        }  ?>
                        <form name="myForm" action="#" method="post" onsubmit="return validateForm()">
                            <div class="form-body">
                            	<?php foreach($allplansData as $data){ ?>
                                <div class="form-group row">
                                    <label class="col-md-1"> 1. </label>
                                    <div class="col-md-5">
                                        <div class="row">
                                            <div class="col-md-12">
                                                <label class="col-md-12"><?php echo $data->plan_name ?></label>
                                            </div>
                                        </div>
                                    </div>	
                                    <div class="col-md-6">
                                        <div class="row">
                                            <div class="col-md-12">
                                                <div class="form-group">
                                                	<input type="hidden" value="<?php echo $data->plan_id ?>" name="plan_id[]">
                                                    <input type="text" name="plan_count[]" id="firstname" class="form-control" placeholder="Total Plan" required="required">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                 
                                <?php } ?>
                            </div>
                            <div class="form-actions">
                                <div class="text-right">
                                    <button type="submit" name="plan-request" class="btn btn-info">Submit</button>
                                    <button type="reset" class="btn btn-dark">Reset</button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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