Gecko [ eachadeal.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2019-10-09 06:45
ajaxcall	[ DIR ]	drwxr-xr-x	2019-10-09 08:39
assets	[ DIR ]	drwxr-xr-x	2025-10-29 23:03
css	[ DIR ]	drwxr-xr-x	2019-10-25 02:53
js	[ DIR ]	drwxr-xr-x	2019-10-25 02:52
pdf	[ DIR ]	drwxr-xr-x	2019-10-15 12:31
phpMailer	[ DIR ]	drwxr-xr-x	2016-03-30 06:50
signatures	[ DIR ]	drwxr-xr-x	2016-03-20 05:27
.htaccess	279 B	-rw-r--r--	2020-12-01 10:37
calendar.php	12.63 KB	-rw-r--r--	2019-10-25 03:18
config.php	384 B	-rw-r--r--	2016-03-19 12:15
edit-customer.php	10.61 KB	-rw-r--r--	2019-10-25 03:52
email-reminder.php	1.88 KB	-rw-r--r--	2019-11-14 09:08
error_log	1.19 MB	-rw-r--r--	2025-10-31 00:51
footer.php	48 B	-rw-r--r--	2016-03-19 12:21
header.php	2.9 KB	-rw-r--r--	2020-12-01 10:45
index.php	62 B	-rw-r--r--	2019-10-09 06:47
maintenance-form-unique-key.php	12.55 KB	-rw-r--r--	2019-10-09 06:28
maintenance-form.php	11.19 KB	-rw-r--r--	2019-10-09 16:21
new-customer.php	1.3 KB	-rw-r--r--	2016-03-31 13:37
new-form.php	2.14 KB	-rw-r--r--	2019-10-09 09:32
phpinfo.php	69 B	-rw-r--r--	2019-10-08 09:21
post-maintenance.php	4.77 KB	-rw-r--r--	2019-10-25 09:33
uniquekey.php	964 B	-rw-r--r--	2019-10-09 06:49
wp.php	18 B	-rw-r--r--	2025-10-28 12:36

Rename

<?php require 'header.php'; ?>
<?php
$count = 0;

if (isset($_POST['submit'])) :
	$sql = "UPDATE customer SET name='".$_POST['name']."', address='".$_POST['address']."', email='".$_POST['email']."', phone='".$_POST['phone']."', contact_person='".$_POST['contact']."', type='".$_POST['type']."' WHERE id = ".$_POST['customer_id'];
	$result = mysqli_query($conn, $sql);
	
	$name = $_POST['name'];
	$address = $_POST['address'];
	$email = $_POST['email'];
	$phone = $_POST['phone'];
	$contact = $_POST['contact_person'];
	$type = $_POST['type'];	
	$times = $_POST['times'];
	$interval = $_POST['interval'];
	$active = $_POST['active'];

$input_date = strtotime($_POST['date']);
    if ($input_date) {
      $date = date("Y-m-d",$input_date);
      echo 'Date: ' . $date;
    } else {
       echo 'Invalid Date: ' . $_POST['date'];
      // fix it.
    }
    $sql = "delete from maintenance_period where customer_id=".$_POST['customer_id'];
    $result = mysqli_query($conn, $sql);
    $sql = "insert into maintenance_period (customer_id, start_date, recur_interval, recur_times, active) values ('".$_POST['customer_id']."', '".$date."', '".$_POST['interval']."', '".$_POST['times']."', '".$_POST['active']."')";
    $result = mysqli_query($conn, $sql);
	
	$equipments = $_POST['equipments'];
	if (isset($equipments)) {
		foreach ($equipments as $equipment) {
			if ($equipment['equipment_own_id'] != '')
				$sql = "UPDATE equipment_own SET equipment_type_id='".$equipment['equipment_type_id']."', name='".$equipment['equipment_name']."', serial='".$equipment['serial']."', remarks='".$equipment['remarks']."', active='".$equipment['active']."' WHERE id = ".$equipment['equipment_own_id'];
			else
				$sql = "INSERT into equipment_own (customer_id, equipment_type_id, date_added, name, serial, remarks, active) VALUES ('".$_POST['customer_id']."', '".$equipment['equipment_type_id']."', '".date('Y-m-d H:i:s')."', '".$equipment['equipment_name']."', '".$equipment['serial']."', '".$equipment['remarks']."', '".$equipment['active']."')";
			$result = mysqli_query($conn, $sql);
			echo 'Done';
		}
	}
	$equipments = [];
endif;

if (isset($_POST['amend'])) :
    $times = $_POST['times'];
	$interval = $_POST['interval'];
	$active = $_POST['active'];
    
    $input_date = strtotime($_POST['date']);
    if ($input_date) {
      $date = date("Y-m-d",$input_date);
      echo 'Date: ' . $date;
    } else {
       echo 'Invalid Date: ' . $_POST['date'];
      // fix it.
    }
    $sql = "delete from maintenance_period where customer_id=".$_POST['customer_id'];
    $result = mysqli_query($conn, $sql);
    $sql = "insert into maintenance_period (customer_id, start_date, recur_interval, recur_times, active) values ('".$_POST['customer_id']."', '".$date."', '".$_POST['interval']."', '".$_POST['times']."', '".$_POST['active']."')";
    $result = mysqli_query($conn, $sql); 
    $batch_id = mysqli_insert_id($conn);
    
    $sql = "delete from calendar where customer_id=".$_POST['customer_id']." and batch_id In (SELECT BID FROM (Select batch_id as BID From calendar Group By batch_id Having Sum(done) = 0) as c)";
    $result = mysqli_query($conn, $sql);

for ($a=0;$a<$_POST['times'];$a++) {
        $months = (int)$_POST['interval'] * 1;
        $date = date('Y-m-d', strtotime($date. ' + '.$months.' months'));

$sql = "insert into calendar (customer_id, date, done, batch_id) values ('".$_POST['customer_id']."', '".$date."', '0', '".$batch_id."')";
        $result = mysqli_query($conn, $sql); 
        
    }

endif;

if (isset($_POST['customer_id'])) :
	$sql = 'select * from customer where id='.$_POST['customer_id'];
	$result = mysqli_query($conn, $sql);
	while($row = mysqli_fetch_assoc($result)) {
		$name = $row['name'];
		$address = $row['address'];
		$email = $row['email'];
		$phone = $row['phone'];
		$contact = $row['contact_person'];
		$type = $row['type'];
	}
	
	$sql = 'select * from maintenance_period where customer_id='.$_POST['customer_id'];
	$result = mysqli_query($conn, $sql);
	while($row = mysqli_fetch_assoc($result)) {
		$date = new DateTime($row['date']);
		$date = $date->format('Y-m-d');
		$times = $row['recur_times'];
		$interval = $row['recur_interval'];
		$active = $row['active'];
	}
	
	
	$sql = 'select * from equipment_own where customer_id='.$_POST['customer_id'].' ORDER BY position ASC';
	$result = mysqli_query($conn, $sql);

$inc=0;
	while($row = mysqli_fetch_assoc($result)) {
		$equipments[$inc]['equipment_own_id'] = $row['id'];
		$equipments[$inc]['equipment_type_id'] = $row['equipment_type_id'];
		$equipments[$inc]['equipment_name'] = $row['name'];
		$equipments[$inc]['serial'] = $row['serial'];
		$equipments[$inc]['remarks'] = $row['remarks'];
		$equipments[$inc++]['active'] = $row['active'];
		
	}
	
endif;

<label for="address">Address</label>
<input id="address" name="address" class="form-control" value="<?php echo $address ?>">

<label for="email">Email</label>
<input id="email" name="email" class="form-control" value="<?php echo $email ?>">

<label for="phone">Telephone</label>
<input id="phone" name="phone" class="form-control" value="<?php echo $phone ?>">

<label for="contact">Contact Person</label>
<input id="contact" name="contact" class="form-control" value="<?php echo $contact ?>">

<label for="type">Type</label>
<select id="type" name="type" class="form-control">
<option value="0" <?php if ($type == 0) echo 'selected' ?>>Commercial</option>
<option value="1" <?php if ($type == 1) echo 'selected' ?>>Residential</option>
</select>

<label for="contact">Start Date</label>
<input id="date" type="date" name="date" class="form-control" value="<?php echo $date ?>">

<label for="times">Recurring times</label>
<select id="times" name="times" class="form-control">
<option value="1" <?php if ($times == 1) echo 'selected' ?>>1</option>
<option value="2" <?php if ($times == 2) echo 'selected' ?>>2</option>
<option value="3" <?php if ($times == 3) echo 'selected' ?>>3</option>
<option value="4" <?php if ($times == 4) echo 'selected' ?>>4</option>
<option value="5" <?php if ($times == 5) echo 'selected' ?>>5</option>
<option value="6" <?php if ($times == 6) echo 'selected' ?>>6</option>
<option value="7" <?php if ($times == 7) echo 'selected' ?>>7</option>
<option value="8" <?php if ($times == 8) echo 'selected' ?>>8</option>
<option value="9" <?php if ($times == 9) echo 'selected' ?>>9</option>
<option value="10" <?php if ($times == 10) echo 'selected' ?>>10</option>
</select>

<label for="interval">Recurring interval</label>
<select id="interval" name="interval" class="form-control">
<option value="3" <?php if ($interval == 3) echo 'selected' ?>>3 Months</option>
<option value="6" <?php if ($interval == 6) echo 'selected' ?>>6 Months</option>
</select>

<label for="active">Active</label>
<select id="active" name="active" class="form-control">
<option value="0" <?php if ($active == 0) echo 'selected' ?>>No</option>
<option value="1" <?php if ($active == 1) echo 'selected' ?>>Yes</option>
</select>
<input class="btn btn-default form-control" type="submit" value="Amend Maintenance Calendar" name="amend">
<br/ ><br/ >

<button class="btn btn-default add-equipment">Add Equipment</button>
<br /><br />
<div class="input_fields_wrap">
<?php
//preload equipment own
if (isset($equipments)) {
	foreach ($equipments as $equipment) {
		echo getInput($conn, $count++, $equipment['equipment_own_id'], $equipment['equipment_type_id'], $equipment['equipment_name'], $equipment['serial'], $equipment['remarks'], $equipment['active']);
	}
}
?>
</div>
<input class="btn btn-default form-control" type="submit" value="Submit" name="submit">

</form>
</div>
<script>
$(document).ready(function() {
    var wrapper         = $(".input_fields_wrap"); //Fields wrapper
    var add_button      = $(".add-equipment"); //Add button ID
    var count = 0;
    var x = 1; //initlal text box count

var newEquipment = '<?php echo getInput($conn = $conn, 'replaceKey'); ?>';

$(add_button).click(function(e){ //on add input button click
        e.preventDefault();
        x++; //text box increment
        $(wrapper).append(newEquipment.replace(/replaceKey/g, <?php echo $count ?>+count++)); //add input box
    });
    
    
    $(wrapper).on("click",".remove_field", function(e){ //user click on remove text
        e.preventDefault(); $(this).parent('div').remove(); x--;
    });
});
</script>

<?php

function getInput($conn, $count, $equipment_own_id = '', $equipment_type_id = 1, $equipment_name = '', $serial = '', $remarks = '', $active = 1) 
{
	$input = '<div class="equipment">';
	$input .= '<input type="hidden" name="equipments['.$count.'][equipment_own_id]" value="'.$equipment_own_id.'">';
	$input .= '<div class="col-xs-6">';
	$input .= '<label for="equipment_type_id'.$count.'">Type</label>';
	$input .= '<select id="equipment_type_id'.$count.'" name="equipments['.$count.'][equipment_type_id]" class="form-control">';
	$sql = "SELECT * from equipment_type";
	$result = mysqli_query($conn, $sql);
	while($row = mysqli_fetch_assoc($result)) {
		$input .= '<option value="'.$row['id'].'" '.($equipment_type_id == $row['id'] ? 'selected' : '').'>'.$row['value'].'</option>';
	}
	$input .= '</select>';
	$input .= '</div>';
	$input .= '<div class="col-xs-6">';
	$input .= '<label for="equipment_name'.$count.'">Name</label>';
	$input .= '<input id="equipment_name'.$count.'" name="equipments['.$count.'][equipment_name]" class="form-control" value="'.$equipment_name.'">';
	$input .= '</div>';
	$input .= '<div class="col-xs-6">';
	$input .= '<label for="serial'.$count.'">Serial #</label>';
	$input .= '<input id="serial'.$count.'" name="equipments['.$count.'][serial]" class="form-control" value="'.$serial.'">';
	$input .= '</div>';
	$input .= '<div class="col-xs-6">';
	$input .= '<label for="remarks'.$count.'">Remarks</label>';
	$input .= '<input id="remarks'.$count.'" name="equipments['.$count.'][remarks]" class="form-control" value="'.$remarks.'">';
	$input .= '</div>';
	$input .= '<div class="col-xs-12">';
	$input .= '<label for="active'.$count.'">Active</label>';
	$input .= '<select id="active'.$count.'" name="equipments['.$count.'][active]" class="form-control">';
	$input .= '<option value="1" '.($active == 1 ? 'selected' : '').'>Yes</option>';
	$input .= '<option value="0" '.($active == 0 ? 'selected' : '').'>No</option>';
	$input .= '</select>';
	$input .= '</div>';
	$input .= '<a href="#" class="remove_field">Remove</a><br /><br /></div>';

return $input;
	
}
?>

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