<?php
require_once "session.php";
require_once "header.php";
require_once "functions/create_schedule_function.php";
require_once 'functions/test_battery_functions.php';
$createscheduleFunction = new createscheduleFunction();
$testbattery = new testbatteryfunction();
?>
<div class="container">
<div class="container align_center align_height">
<span class="sports">CREATE SCHEDULE</span>
</div><!--end container-->
<div class="col-xs-12 col-md-11">
<div class="col-md-4 hidden-xs"></div>
<div class="col-xs-12 col-md-7 align_margin">
<form name="create_schedule_form" id="createschedule_form">
<input type="hidden" class="statesid" name="edit_schedule_id">
<div class="form-group">
<label>Schedule Name</label><br>
<input type="text" class="adjust_width" name="schedule_name" data-validation-error-msg="Please Enter the name of the Schedule" data-validation="required">
</div>
<div class="form-group">
<label for="battey_name">Select Test Battery Name</label>
<select class="form-control classic adjust_width" id="battey_name" name="schedule_testbattery" data-validation-error-msg="Please Select the name of the Test Battery Name" data-validation="required">
<option value="">Select Test Battery Name</option>
<?php
$query = $testbattery->testbatterySelect();
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
<?php
require_once "session.php";
require_once "functions/sports_function.php";
require_once "functions/category_function.php";
require_once "functions/test_functions.php";
require_once "functions/test_battery_functions.php";
require_once "header.php";
$test_battery = new testbatteryfunction();
$sports = new sportsfunction();
$category = new categoryfunction();
$test = new testfunction();
$url = $_SERVER['PHP_SELF'];
if (isset($_GET['update_success'])) {
echo "<script>alert('Test Battery update successfully');var url ='" . $url . "'; window.location = url ;</script>";
}
if (isset($_GET['insert_success'])) {
echo "<script>alert('Test Battery inserted successfully');var url ='" . $url . "'; window.location = url ;</script>";
}
if (isset($_GET['duplicate'])) {
echo "<script>alert('Test Battery already exist!');var url ='" . $url . "'; window.location = url ;</script>";
}
?>
<div class="container">
<div class="container align_center align_height">
<span class="sports">TEST BATTERY</span>
</div><!--end container-->
<div class="container">
<div class="col-xs-12 col-md-11">
<div class="col-md-4 hidden-xs"></div>
<div class="col-xs-12 col-md-7 align_margin">
<?php
require_once "session.php";
require_once "header.php";
require_once 'functions/range_function.php';
require_once "functions/test_battery_functions.php";
require_once "functions/category_function.php";
require_once "functions/test_functions.php";
$rangeFunction = new rangeFunction();
$testbatteryfunction = new testbatteryfunction();
$categoryfunction = new categoryfunction();
$testfunction = new testfunction();
?>
<div class="container">
<div class="container align_center align_height">
<span class="sports">RANGE</span>
</div><!--end container-->
<div class="container">
<div class="col-xs-12 col-md-11">
<div class="col-md-4 hidden-xs"></div>
<div class="col-xs-12 col-md-7 align_margin">
<form name="range_form" id="range_form_id">
<div class="form-group">
<label for="sel1">Select Test Battery Names</label>
<select class="form-control adjust_width classic" id="sel1" name="range_testbattery" data-validation-error-msg="Please Select the Name of Test Battery " data-validation="required">
<option value="">Select Test Battery Names</option>
<?php
$query = $testbatteryfunction->testbatterySelect();
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
}
if (isset($_GET['getcatedata'])) {
include "../dbconnect.php";
$test_battery_id = $_POST['id'];
$sql1 = mysql_query("SELECT * FROM wc_testbattery_category_attribute\n INNER JOIN wc_categories ON wc_categories.categories_id = wc_testbattery_category_attribute.testbattery_category_id where wc_testbattery_category_attribute.testbattery_id = '{$test_battery_id}'") or die(mysql_error());
$rows1 = array();
while ($r = mysql_fetch_assoc($sql1)) {
$row1[] = $r;
}
print json_encode($row1);
}
if (isset($_GET['gettestdata'])) {
include "../dbconnect.php";
$test_battery_id = $_POST['id'];
$sql2 = mysql_query("SELECT * FROM wc_testbattery_test_attribute\n INNER JOIN wc_test ON wc_testbattery_test_attribute.testbattery_test_id = wc_test.test_id where wc_testbattery_test_attribute.testbattery_id = '{$test_battery_id}'") or die(mysql_error());
$rows2 = array();
while ($r = mysql_fetch_assoc($sql2)) {
$row2[] = $r;
}
print json_encode($row2);
}
if (isset($_GET['deletedata'])) {
include "../dbconnect.php";
$test = new testbatteryfunction();
$test->testbatteryid = $_POST['delete_id'];
if ($test->testbatterydeletefunction()) {
echo $_POST['delete_id'];
} else {
echo "error";
}
}
