Kinnitamata broneeringud
| Aeg |
Pikkus |
Protseduur |
Nimi |
Telefon |
Email |
Loom |
Vanus |
Sugu |
Probleem |
Staatus |
';
echo '' . date( 'd', $reservation['start_time'] ) . '.'
. date( 'm', $reservation['start_time'] ) . '.'
. date( 'Y', $reservation['start_time'] ) . ' '
. date( 'H', $reservation['start_time'] ) . ':'
. date( 'i', $reservation['start_time'] ) . ' | ';
echo '' . $reservation['length'] . ' min | ';
echo '' . $reservation['procedure_name'] . ' | ';
echo '' . esc_attr( $reservation['client_name'] ) . ' | ';
echo '' . esc_attr( $reservation['client_telephone'] ) . ' | ';
echo '' . esc_attr( $reservation['client_email'] ) . ' | ';
echo '' . esc_attr( $reservation['animal'] ) . ' | ';
echo '' . esc_attr( $reservation['animal_age'] ) . ' | ';
echo '';
if( $reservation['animal_sex'] == 1 ){
echo 'Emane';
}else{
echo 'Isane';
}
echo ' | ';
echo '' . esc_attr( $reservation['problem'] ) . ' | ';
echo '';
if( $reservation['status'] == 0 ){
echo 'Kinnitamata';
}elseif( $reservation['status'] == 1 ){
echo 'Kinnitatud';
}elseif( $reservation['status'] == 2 ){
echo 'Tagasi lükatud';
}elseif( $reservation['status'] == 3 ){
echo 'Tühistatud';
}else{
echo 'Teadmata';
}
echo ' | ';
echo '';
echo '';
echo '|
Muuda
Kinnita
Lükka tagasi
Kustuta
| ';
echo '
';
}
?>
get_all_reservations(1);
?>
Kinnitatud broneeringud
| Aeg |
Pikkus |
Protseduur |
Nimi |
Telefon |
Email |
Loom |
Vanus |
Sugu |
Probleem |
Staatus |
';
echo '' . date( 'd', $reservation['start_time'] ) . '.'
. date( 'm', $reservation['start_time'] ) . '.'
. date( 'Y', $reservation['start_time'] ) . ' '
. date( 'H', $reservation['start_time'] ) . ':'
. date( 'i', $reservation['start_time'] ) . ' | ';
echo '' . $reservation['length'] . ' min | ';
echo '' . $reservation['procedure_name'] . ' | ';
echo '' . esc_attr( $reservation['client_name'] ) . ' | ';
echo '' . esc_attr( $reservation['client_telephone'] ) . ' | ';
echo '' . esc_attr( $reservation['client_email'] ) . ' | ';
echo '' . esc_attr( $reservation['animal'] ) . ' | ';
echo '' . esc_attr( $reservation['animal_age'] ) . ' | ';
echo '';
if( $reservation['animal_sex'] == 1 ){
echo 'Emane';
}else{
echo 'Isane';
}
echo ' | ';
echo '' . esc_attr( $reservation['problem'] ) . ' | ';
echo '';
if( $reservation['status'] == 0 ){
echo 'Kinnitamata';
}elseif( $reservation['status'] == 1 ){
echo 'Kinnitatud';
}elseif( $reservation['status'] == 2 ){
echo 'Tagasi lükatud';
}elseif( $reservation['status'] == 3 ){
echo 'Tühistatud';
}else{
echo 'Teadmata';
}
echo ' | ';
echo '';
echo '';
echo '|
Muuda
Kinnita
Lükka tagasi
Kustuta
| ';
echo '
';
}
?>
get_all_reservations(2);
?>
Tagasi lükatud broneeringud
| Aeg |
Pikkus |
Protseduur |
Nimi |
Telefon |
Email |
Loom |
Vanus |
Sugu |
Probleem |
Staatus |
';
echo '' . date( 'd', $reservation['start_time'] ) . '.'
. date( 'm', $reservation['start_time'] ) . '.'
. date( 'Y', $reservation['start_time'] ) . ' '
. date( 'H', $reservation['start_time'] ) . ':'
. date( 'i', $reservation['start_time'] ) . ' | ';
echo '' . $reservation['length'] . ' min | ';
echo '' . $reservation['procedure_name'] . ' | ';
echo '' . esc_attr( $reservation['client_name'] ) . ' | ';
echo '' . esc_attr( $reservation['client_telephone'] ) . ' | ';
echo '' . esc_attr( $reservation['client_email'] ) . ' | ';
echo '' . esc_attr( $reservation['animal'] ) . ' | ';
echo '' . esc_attr( $reservation['animal_age'] ) . ' | ';
echo '';
if( $reservation['animal_sex'] == 1 ){
echo 'Emane';
}else{
echo 'Isane';
}
echo ' | ';
echo '' . esc_attr( $reservation['problem'] ) . ' | ';
echo '';
if( $reservation['status'] == 0 ){
echo 'Kinnitamata';
}elseif( $reservation['status'] == 1 ){
echo 'Kinnitatud';
}elseif( $reservation['status'] == 2 ){
echo 'Tagasi lükatud';
}elseif( $reservation['status'] == 3 ){
echo 'Tühistatud';
}else{
echo 'Teadmata';
}
echo ' | ';
echo '';
echo '';
echo '|
Muuda
Kinnita
Lükka tagasi
Kustuta
| ';
echo '
';
}
?>
0 ){
echo $this->get_edit_reservation_page( $_GET['edit_reservation'] );
}
?>
get_day_reservations($date, $ignore_reservation_id);
$day_start = get_option( get_class($this) . '_day_start_time' );
$day_end = get_option( get_class($this) . '_day_end_time' );
$day_start_hour = split(':', $day_start);
$day_start_hour = (int)$day_start_hour[0];
$day_start_minute = split(':', $day_start);
$day_start_minute = (int)$day_start_hour[1];
$day_end_hour = split(':', $day_end);
$day_end_hour = (int)$day_end_hour[0];
$day_end_minute = split(':', $day_end);
$day_end_minute = (int)$day_end_hour[1];
$start_time = mktime( $day_start_hour, $day_start_minute, 0, date('m', $date), date('d', $date),date('Y', $date));
$end_time = mktime( $day_end_hour, $day_end_minute, 0, date('m', $date), date('d', $date),date('Y', $date));
$total_available_time = $end_time - $start_time; //in seconds
$total_available_time_left = $total_available_time;
foreach ($reservations as $reservation) {
$total_available_time_left -= $reservation['length']*60;
}
return ( 1 - (float)$total_available_time_left / (float)$total_available_time );
}
function get_month_days_business( $month, $year, $ignore_not_busy = true, $length_to_fit = false, $ignore_reservation_id = false ){
$days = array();
$number_of_days = date('t', mktime(0, 0, 0, $month, 1, $year));
for( $i = 1; $i <= $number_of_days; $i++){
$day = mktime( 0, 0, 0, $month, $i, $year );
if( $length_to_fit == false ){
$busyness = $this->get_day_busyness( $day, $ignore_reservation_id );
if( $busyness >= $this->lowest_busyness_to_report && $ignore_not_busy == true ){
$days[$month][$i] = $busyness;
}
}else{
$available_times = $this->get_available_times($day, $length_to_fit, $ignore_reservation_id);
if( count( $available_times ) == 0 ){
$days[$month][$i] = 1;
}elseif( count( $available_times ) == 1 ){
$days[$month][$i] = 0.5;
}
}
}
return $days;
}
function get_reservations_between( $start, $end, $ignore_reservation_id = false ){
global $wpdb;
$reservations = array();
$start_time = date('Y-m-d H:i:s', (int)$start);
$end_time = date('Y-m-d H:i:s', (int)$end);
$table_name = $wpdb->prefix . get_class( $this ) . "_reservations";
$ignore_reservation_id_sql_str = ( $ignore_reservation_id === false )?'':
" AND $table_name.id <> " . (int)$ignore_reservation_id;
$sql = "SELECT $table_name.id as id, $table_name.start_time as start_time,
$table_name.length as length, $table_name.procedure_id as procedure_id,
$table_name.client_name as client_name, $table_name.client_telephone as client_telephone,
$table_name.client_email as client_email, $table_name.animal as animal,
$table_name.animal_age as animal_age, $table_name.animal_sex as animal_sex,
$table_name.problem as problem, $table_name.status as status
FROM $table_name
WHERE ( ( '$end_time' > start_time AND '$end_time' <= start_time + INTERVAL length MINUTE )
OR ( '$start_time' >= start_time AND '$end_time' <= start_time + INTERVAL length MINUTE )
OR ( '$start_time' >= start_time AND '$start_time' < start_time + INTERVAL length MINUTE )
OR ( '$start_time' <= start_time AND '$end_time' >= start_time + INTERVAL length MINUTE ) )
$ignore_reservation_id_sql_str AND $table_name.status != 2
AND $table_name.status != 3";
$rows = $wpdb->get_results( $sql, OBJECT );
foreach ($rows as $row){
$reservation = array();
$reservation['id'] = (int)$row->id;
$reservation['start_time'] = strtotime( $row->start_time );
$reservation['length'] = (int)$row->length;
$reservation['procedure_id'] = (int)$row->procedure_id;
$reservation['client_name'] = $row->client_name;
$reservation['client_telephone'] = $row->client_telephone;
$reservation['client_email'] = $row->client_email;
$reservation['animal'] = $row->animal;
$reservation['animal_age'] = $row->animal_age;
$reservation['animal_sex'] = $row->animal_sex;
$reservation['problem'] = $row->problem;
$reservation['status'] = (int)$row->status;
array_push($reservations, $reservation);
}
return $reservations;
}
function add_reservation( $procedure_id, $time, $name, $telephone, $email, $animal, $age, $sex, $problem, $status = 0 ){
global $wpdb;
$procedure = $this->get_procedure((int)$procedure_id);
$start_time = date('Y-m-d H:i:s', (int)$time);
$name = $wpdb->escape( $name );
$telephone = $wpdb->escape( $telephone );
$email = $wpdb->escape( $email );
$animal = $wpdb->escape( $animal );
$age = $wpdb->escape( $age );
$sex = (int)$sex;
$problem = $wpdb->escape( $problem );
$status = (int)$status;
$table_name = $wpdb->prefix . get_class( $this ) . "_reservations";
$insert = "INSERT INTO " . $table_name .
" (start_time, length, procedure_id, client_name, client_telephone, client_email, animal, animal_age, animal_sex, problem, status ) " .
"VALUES ( '" . $start_time . "', " . (int)$procedure['length'] . ", " .
$procedure_id . ", '" . $name . "', '" . $telephone . "', '" . $email . "', '" .
$animal . "', '" . $age . "', " . $sex . ", '" . $problem . "', " . $status . ")";
$wpdb->query( $insert );
return $wpdb->insert_id;
}
function ajax_add_reservation(){
$response = array();
if( isset( $_POST['procedure'] ) && $_POST['procedure'] > 0
&& isset( $_POST['time'] ) && isset( $_POST['name'] )
&& isset( $_POST['telephone'] ) && isset( $_POST['email'] )
&& isset( $_POST['animal'] ) && isset( $_POST['age'] )
&& isset( $_POST['sex'] ) && isset( $_POST['problem'] ) ){
$reservation_id = $this->add_reservation($_POST['procedure'], $_POST['time'], $_POST['name'],
$_POST['telephone'], $_POST['email'], $_POST['animal'], $_POST['age'],
$_POST['sex'], $_POST['problem']);
$response['code'] = 1;
$response['message'] = 'Broneeritud. Kinnitus saadetakse teile emailile.';
$reservation = $this->get_reservation($reservation_id);
$subject = "Uus broneering";
$body = $this->replace_email_tags( get_option( get_class($this) . "_new_reservation_email" ), $reservation );
$headers = 'From: ' . get_option( get_class($this) . "_name_email_from" )
. ' <' . get_option( get_class($this) . "_email_reservation_from" ) . '>' . "\r\n\\";
wp_mail( get_option( get_class($this) . "_email_reservations_to" ), $subject, $body, $headers );
}else{
$response['code'] = 0;
$response['message'] = 'Kõik vajalikud väljad ei ole täidetud.';
}
echo json_encode($response);
die();
}
function get_add_reservation_page(){
if( isset ( $_POST['action'] ) && $_POST['action'] == 'add_new' ){
if( isset( $_POST['procedure'] ) && $_POST['procedure'] > 0
&& isset( $_POST['time'] ) && isset( $_POST['name'] )
&& isset( $_POST['telephone'] ) && isset( $_POST['email'] )
&& isset( $_POST['animal'] ) && isset( $_POST['age'] )
&& isset( $_POST['sex'] ) && isset( $_POST['problem'] )){
$procedure = $this->get_procedure( (int)$_POST['procedure'] );
if( count( $this->get_reservations_between( (int)$_POST['time'],
(int)$_POST['time'] + $procedure['length']*60 ) ) == 0 ){
$this->add_reservation( $_POST['procedure'], $_POST['time'], $_POST['name'],
$_POST['telephone'], $_POST['email'], $_POST['animal'], $_POST['age'],
$_POST['sex'], $_POST['problem'], $status = 1 );
//send email?
echo 'Protseduuride haldamine
';
echo '
';
echo '
';
echo '
';
$procedures = $this->get_all_procedures();
echo '
';
echo '
| Protseduuri nimi |
Pikkus |
Avalikult
nähtav |
|
';
foreach ($procedures as $procedure) {
echo '';
echo '| ' . $procedure['name'] . ' | ';
echo '' . $procedure['length'] . ' min | ';
echo '' . (($procedure['public'])?'Jah':'Ei') . ' | ';
echo 'Muuda | ';
echo 'Kustuta | ';
echo '
';
}
echo '
';
echo '
';
echo '
';
if( isset ( $_REQUEST['action'] ) && $_REQUEST['action'] == 'edit' && isset( $_REQUEST['id'] ) ){
//edit form
$procedure = $this->get_procedure($_REQUEST['id']);
?>
';
echo '
';
}
function get_options_page(){
if( isset ( $_POST['action'] ) && $_POST['action'] == 'save_options' ){
$email_to = $_POST['email_to'];
update_option( get_class($this) . '_email_reservations_to', $email_to );
$new_reservation_email = $_POST['new_reservation_email'];
update_option( get_class($this) . '_new_reservation_email', $new_reservation_email );
$email_from = $_POST['email_from'];
update_option( get_class($this) . '_email_reservation_from', $email_from );
$name_email_from = $_POST['name_email_from'];
update_option( get_class($this) . '_name_email_from', $name_email_from );
$day_start_time = $_POST['day_start_time'];
update_option( get_class($this) . '_day_start_time', $day_start_time );
$day_end_time = $_POST['day_end_time'];
update_option( get_class($this) . '_day_end_time', $day_end_time );
$reservation_time_step = $_POST['reservation_time_step'];
update_option( get_class($this) . '_reservation_time_step', $reservation_time_step );
$reservation_confirm_email_subject = $_POST['confirm_email_subject'];
update_option( get_class($this) . '_reservation_confirm_email_subject', $reservation_confirm_email_subject );
$reservation_confirm_email = $_POST['confirm_email'];
update_option( get_class($this) . '_reservation_confirm_email', $reservation_confirm_email );
$reservation_decline_email_subject = $_POST['decline_email_subject'];
update_option( get_class($this) . '_reservation_decline_email_subject', $reservation_decline_email_subject );
$reservation_decline_email = $_POST['decline_email'];
update_option( get_class($this) . '_reservation_decline_email', $reservation_decline_email );
}
?>
Seaded
Emaili pealkirja ja sisu võimalikud muutujad: {id}, {algus}, {pikkus}, {protseduuri_id}, {nimi}, {telefon}, {email}, {loom}, {vanus}, {sugu}, {probleem}, {protseduur}
prefix . get_class( $this ) . "_procedures";
$sql = "SELECT $table_name.id as id, $table_name.name as name,
$table_name.length as length, $table_name.public as public
FROM $table_name
WHERE $table_name.deleted = 0
ORDER BY name ASC";
$rows = $wpdb->get_results( $sql, OBJECT );
foreach ($rows as $row){
$procedure = array();
$procedure['id'] = (int)$row->id;
$procedure['name'] = $row->name;
$procedure['length'] = (int)$row->length;
$procedure['public'] = (int)$row->public;
array_push($procedures, $procedure);
}
return $procedures;
}
function get_all_public_procedures(){
global $wpdb;
$procedures = array();
$table_name = $wpdb->prefix . get_class( $this ) . "_procedures";
$sql = "SELECT $table_name.id as id, $table_name.name as name,
$table_name.length as length, $table_name.public as public
FROM $table_name
WHERE $table_name.deleted = 0 AND $table_name.public = 1
ORDER BY name ASC";
$rows = $wpdb->get_results( $sql, OBJECT );
foreach ($rows as $row){
$procedure = array();
$procedure['id'] = (int)$row->id;
$procedure['name'] = $row->name;
$procedure['length'] = (int)$row->length;
$procedure['public'] = (int)$row->public;
array_push($procedures, $procedure);
}
return $procedures;
}
function get_procedure( $id ){
global $wpdb;
$id = (int)$id;
$table_name = $wpdb->prefix . get_class( $this ) . "_procedures";
$sql = "SELECT $table_name.id as id, $table_name.name as name,
$table_name.length as length, $table_name.public as public
FROM $table_name
WHERE $table_name.id = $id
LIMIT 1";
if ( $row = $wpdb->get_row( $sql ) ){
$procedure = array();
$procedure['id'] = (int)$row->id;
$procedure['name'] = $row->name;
$procedure['length'] = (int)$row->length;
$procedure['public'] = (int)$row->public;
return $procedure;
}
return false;
}
function add_procedure( $name, $length, $public ){
global $wpdb;
$name = $wpdb->escape( $name );
$length = $wpdb->escape( $length );
$public = (int)$public;
$table_name = $wpdb->prefix . get_class( $this ) . "_procedures";
$insert = "INSERT INTO " . $table_name .
" (name, length, public) " .
"VALUES ( '" . $name . "', '" . $length . "', " . $public . ")";
$wpdb->query( $insert );
}
function edit_procedure( $id, $name, $length, $public ){
global $wpdb;
$id = (int)$id;
$name = $wpdb->escape( $name );
$length = $wpdb->escape( $length );
$public = (int)$public;
$table_name = $wpdb->prefix . get_class( $this ) . "_procedures";
$update = "UPDATE $table_name SET name='$name', length='$length', public=$public WHERE id=$id";
$wpdb->query( $update );
}
function edit_reservation( $reservation_id, $procedure_id, $time, $length, $name, $telephone, $email, $animal, $age, $sex, $problem, $status = 0 ){
global $wpdb;
$reservation_id = (int)$reservation_id;
$procedure_id = (int)$procedure_id;
$start_time = date('Y-m-d H:i:s', (int)$time);
$length = (int)$length;
$name = $wpdb->escape( $name );
$telephone = $wpdb->escape( $telephone );
$email = $wpdb->escape( $email );
$animal = $wpdb->escape( $animal );
$age = $wpdb->escape( $age );
$sex = (int)$sex;
$problem = $wpdb->escape( $problem );
$status = (int)$status;
$table_name = $wpdb->prefix . get_class( $this ) . "_reservations";
$update = "UPDATE $table_name SET start_time='$start_time', length=$length,
procedure_id=$procedure_id, client_name='$name', client_telephone='$telephone',
client_email='$email', animal='$animal', animal_age='$age', animal_sex=$sex,
problem='$problem', status='$status' WHERE id=$reservation_id";
$wpdb->query( $update );
}
function edit_reservation_status( $reservation_id, $status ){
global $wpdb;
$reservation_id = (int)$reservation_id;
$status = (int)$status;
$table_name = $wpdb->prefix . get_class( $this ) . "_reservations";
$update = "UPDATE $table_name SET status='$status' WHERE id=$reservation_id";
$wpdb->query( $update );
}
function delete_procedure( $id ){
/*actually wont delete from database, in fear of breaking old reservations, that may
* depend on this procedure.
*/
global $wpdb;
$id = (int)$id;
$table_name = $wpdb->prefix . get_class( $this ) . "_procedures";
$update = "UPDATE $table_name SET deleted=1 WHERE id=$id";
$wpdb->query( $update );
}
function get_widget_body( $id, $instance ){
$public_procedures = $this->get_all_public_procedures();
?>
get_field_id('body') .'>';
echo '';
echo $HtkLoomakliinik->get_widget_body( $this->id, $instance);
echo '