
<?php

	//*************inserting a service 'Haircut'*************************
	global $wpdb;
	$today = date('Y-m-d');
	$table_name = $wpdb->prefix . "services";
	$insert_service = "INSERT INTO $table_name (
						`service_id` ,
						`service_name` ,
						`service_desc` ,
						`service_durationvalue` ,
						`service_durationunit` ,
						`service_cost` ,
						`service_availability`
						)
						VALUES (
						'1' , 'Haircut', 'Minimum 30min duration for this sevice.', '30', 'Minutes', '100', ''
						);";
	$wpdb->query($insert_service);
	
	//************inserting 3 Events 'Fullday', 'Everyday'****************
	
	
	// Every Day Event -'Lunch'
	$table_name = $wpdb->prefix . "calendar_event";
	$insert_lunch_event = "INSERT INTO $table_name (
						`ev_id` ,
						`ev_title` ,
						`ev_start_time` ,
						`ev_end_time` ,
						`ev_start_date` ,
						`ev_end_date` ,
						`ev_desc`
						)
						VALUES (
						'1' , 'Lunch', '13, 00', '14, 00', '2011-12-26', '2013-12-26', 'Lunch event for a week.'
						);";
	$wpdb->query($insert_lunch_event);
	
	
	/*// "Fullday Event" - on 14 feb 2012
	$insert_fullday_event = "INSERT INTO $table_name (
						`ev_id` ,
						`ev_title` ,
						`ev_start_time` ,
						`ev_end_time` ,
						`ev_start_date` ,
						`ev_end_date` ,
						`ev_desc`
						)
						VALUES (
						'2' , 'Velantine Day Holiday', '00, 00', '24, 00', '2012-02-14', '2012-02-14', 'Holiday For Velantine Day.'
						);";
	$wpdb->query($insert_fullday_event);
	
	// "Meeting Event" for 5 days
	$table_name = $wpdb->prefix . "calendar_event";

	$insert_meeting_event = "INSERT INTO $table_name (
						`ev_id` ,
						`ev_title` ,
						`ev_start_time` ,
						`ev_end_time` ,
						`ev_start_date` ,
						`ev_end_date` ,
						`ev_desc`
						)
						VALUES (
						'3' , 'Staff Meeting', '09, 00', '11, 00', '$today', '$today', '2Hr. Staff Meeting.'
						);";
	$wpdb->query($insert_meeting_event);*/
	
	//***************inserting 6 booking appointment with diffrent status***************
	
	$table_name = $wpdb->prefix . "booked_appointments";
	$insert_pen1 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'1' , 'FARAZ KHAN', 'farazfrank777@gmail.com', 'Haircut', '9887727687', '11:00AM', '12:00PM', '$today', '$today', 'i need 1hr appointment for this service.', 'pending'
					);";
	$wpdb->query($insert_pen1);


	/*$insert_pen2 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'2' , 'HS Maliya', 'hsmaliya@hotmail.com', 'Haircut', '9885475214', '12:00AM', '13:00PM', '$today', '$today', 'Book my appointment.', 'pending'
					);";
	$wpdb->query($insert_pen2);
	
	
	$insert_approve1 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'3' , 'Nalin Gahlot', 'nalin@ymail.com', 'Haircut', '9775845214', '10:00AM', '12:30PM', '2012-01-03', '2012-01-03', 'I need  this service immediately.', 'approved'
					);";
	$wpdb->query($insert_approve1);
	
	
	$insert_approve2 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'4' , 'Faisal Khan', 'fk_khan00786@msn.com', 'Haircut', '8812458752', '15:00AM', '16:30PM', '$today', '$today', 'I need more then 2hr booking.', 'approved'
					);";
	$wpdb->query($insert_approve2);
	
	
	$insert_cancel1 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'5' , 'Frank Darius', 'frank_darius@frank.org', 'Haircut', '6635214587', '15:00AM', '17:00PM', '$today', '$today', 'Book my aapointment', 'cancelled'
					);";
	$wpdb->query($insert_cancel1);
	
	
	$insert_cancel2 = "INSERT INTO $table_name (
					`bk_ap_id` ,
					`bk_ap_name` ,
					`bk_ap_email` ,
					`bk_ap_service` ,
					`bk_ap_cellno` ,
					`bk_ap_sttime` ,
					`bk_ap_edtime` ,
					`bk_ap_stdate` ,
					`bk_ap_eddate` ,
					`bk_ap_desc` ,
					`bk_ap_status`
					)
					VALUES (
					'6' , 'Amy Raid', 'amyraid@music.in', 'Haircut', '1102154785', '18:00AM', '20:00PM', '$today', '$today', 'i need more then 3hr booking.', 'cancelled'
					);";
	$wpdb->query($insert_cancel2);
	*/
	// Insert Calendar Settings
	$table_name = $wpdb->prefix . "calendar_setting"; 
	$cal_settings = "INSERT INTO $table_name (
					`cs_id` ,
					`time_slot` ,
					`day_start_time` ,
					`day_end_time` ,
					`cal_view`
					)
					VALUES (
					'1', '30', '6', '20', 'agendaDay'
					);";
	$wpdb->query($cal_settings);
?>