ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / newrdv1 / wp-content / plugins / sf-booking / admin / modules / bookings

<?php
/*****************************************************************************
*
*	copyright(c) - aonetheme.com - Service Finder Team
*	More Info: http://aonetheme.com/
*	Coder: Service Finder Team
*	Email: contact@aonetheme.com
*
******************************************************************************/
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly

/**
 * Class SERVICE_FINDER_sedateBookingManager
 */
class SERVICE_FINDER_sedateBookingManager extends SERVICE_FINDER_sedateManager{

/*Initial Function*/
	public function service_finder_index()
    {
        
		$this->service_finder_render( 'index','bookings', $this->service_finder_getAllProvidersList() );
		
		$this->service_finder_registerWpActions();
		
    }
	
	/*Display bookings into datatable*/
	public function service_finder_get_admin_bookings(){
		global $wpdb, $service_finder_Tables, $service_finder_options;
		$requestData= $_REQUEST;
		$paymentstatus = '';

$sql = 'SELECT bookings.id, bookings.multi_date, bookings.created, bookings.jobid, bookings.provider_id, bookings.payment_type,bookings.order_id, bookings.charge_admin_fee_from, bookings.paid_to_provider, bookings.total, bookings.adminfee, bookings.stripe_token, bookings.payment_to, bookings.type, bookings.paypal_paykey, bookings.wired_invoiceid, bookings.date, bookings.start_time, bookings.end_time, bookings.end_time_no_buffer, bookings.status, bookings.txnid, providers.full_name as proname, providers.wp_user_id, providers.phone as prophone, providers.mobile as promobile, providers.email as proemail, customers.name as cusname, customers.phone as cusphone, customers.email as cusemail, customers.address as cusaddress, customers.city as cuscity FROM '.$service_finder_Tables->bookings.' as bookings INNER JOIN '.$service_finder_Tables->customers.' as customers INNER JOIN '.$service_finder_Tables->providers.' as providers on bookings.booking_customer_id = customers.id AND bookings.provider_id = providers.wp_user_id';
		
		if(service_finder_get_data($_POST,'filterbookings') != '')
		{
		
			switch (service_finder_get_data($_POST,'filterbookings')) {
				case 'today':
					$start_date = date('Y-m-d');
					$end_date = date('Y-m-d');
					break;
				case 'yesterday':
					$start_date = date('Y-m-d',strtotime('-1 days'));
					$end_date = date('Y-m-d',strtotime('-1 days'));
					break;
				case 'tomorrow':
					$start_date = date('Y-m-d',strtotime('1 days'));
					$end_date = date('Y-m-d',strtotime('1 days'));
					break;
				case 'last_7':
					$start_date = date('Y-m-d',strtotime('-7 days'));
					$end_date = date('Y-m-d');
					break;
				case 'last_30':
					$start_date = date('Y-m-d',strtotime('-30 days'));
					$end_date = date('Y-m-d');
					break;
				case 'next_7':
					$start_date = date('Y-m-d');
					$end_date = date('Y-m-d',strtotime('7 days'));
					break;
				case 'this_month':
					$start_date = date('Y-m-01',strtotime('this month'));
					$end_date = date('Y-m-t',strtotime('this month'));
					break;
				case 'next_month':
					$start_date = date('Y-m-01',strtotime('next month'));
					$end_date = date('Y-m-t',strtotime('next month'));
					break;
			}
		
		$sql.=" WHERE bookings.date BETWEEN '{$start_date}' AND '{$end_date}'";
		
		}
		
		$bookings = $wpdb->get_results($sql);
		
		$data = array();
		
		foreach($bookings as $result){
			$nestedData=array(); 
			
			if((strtotime($result->date) >= strtotime(date("Y-m-d")) && $result->multi_date != "yes") || ($result->status == "Pending" && $result->multi_date == "yes")){
				$status2 = esc_html__('Upcoming','service-finder');
				
			}else{
				$status2 = esc_html__('Past','service-finder');
				
			}
			
			if($result->status == 'Cancel'){
				$status = service_finder_translate_static_status_string($result->status);
			}elseif($result->status == 'Pending'){
				$status = esc_html__('Incomplete','service-finder');
			}else{
				$status = service_finder_translate_static_status_string($result->status);
			}
			
			if($result->jobid > 0){
				$type = esc_html__('Job','service-finder');
			}elseif($result->quoteid > 0){
				$type = esc_html__('Quotation','service-finder');
			}else{
				$type = esc_html__('Booking','service-finder');
			}
			
			if($result->type == 'wired' && $result->payment_to == 'admin'){
			if($result->status == 'Need-Approval'){
			$actions = '<button type="button" data-toggle="tooltip" data-bookingid="'.esc_attr($result->id).'" class="btn btn-primary btn-xs adminapprovewiredbooking" title="'.esc_html__('Approve Booking', 'service-finder').'">'.esc_html__('Approve Booking', 'service-finder').'</button>';
			}else{
			$actions = esc_html__('Approved', 'service-finder');
			}

}elseif(($result->type == 'bacs' || $result->type == 'cheque') && $result->payment_to == 'admin' && $result->payment_type == 'woocommerce'){
			if($result->status == 'Need-Approval'){
			$actions = '<a class="btn btn-primary btn-xs" href="'.admin_url().'post.php?post='.$result->order_id.'&action=edit" target="_blank">'.esc_html__('Approve Booking', 'service-finder').'</a>';
			}elseif($result->status == 'Pending'){
			$actions = esc_html__('Approved', 'service-finder');
			}elseif($result->status == 'Cancel'){
			$actions = esc_html__('Cancelled', 'service-finder');
			}elseif($result->status == 'Completed'){
			$actions = esc_html__('Completed', 'service-finder');
			}

}else{
			$actions = '';
			}
			
			if($result->type == 'free'){
				$paymentstatus = esc_html__('Free', 'service-finder');
			}else{
				if($result->status == 'Pending'){
				$paymentstatus = esc_html__('Paid', 'service-finder');
				}elseif($result->status == 'Need-Approval'){
				$paymentstatus = esc_html__('Pending', 'service-finder');
				}else{
				$paymentstatus = esc_html__('Paid', 'service-finder');
				}
			}
			
			$promobile = (!empty($result->promobile)) ? $result->promobile : '';
			$prophone = (!empty($result->prophone)) ? $result->prophone : '';
			
			if($prophone != "" && $promobile != ""){
			$contactnumber = $prophone.','.$promobile;
			}elseif($prophone != ""){
			$contactnumber = $prophone;
			}elseif($promobile != ""){
			$contactnumber = $promobile;
			}else{
			$contactnumber = '';
			}
			
			if($result->type == "mangopay"){
				$bookingamount = $result->total - $result->adminfee;
			}else{
			if($result->charge_admin_fee_from == 'provider'){
				$bookingamount = $result->total - $result->adminfee;
			}elseif($result->charge_admin_fee_from == 'customer'){
				$bookingamount = $result->total;
			}else{
				$bookingamount = $result->total;
			}
			}
			
			$time_format = (!empty($service_finder_options['time-format'])) ? $service_finder_options['time-format'] : '';
			
			if($time_format){
				$starttime = $result->start_time;
				$endtime = service_finder_get_booking_end_time($result->end_time,$result->end_time_no_buffer);
			}else{
				$starttime = date('h:i a',strtotime($result->start_time));
				$endtime = date('h:i a',strtotime(service_finder_get_booking_end_time($result->end_time,$result->end_time_no_buffer)));
			}
			
			$payment_methods = (!empty($service_finder_options['payment-methods'])) ? $service_finder_options['payment-methods'] : '';
			
			$invoicequery = $wpdb->get_results($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->invoice.' WHERE `booking_id` = "%d"',$result->id));			
			$totalinvoice = count($invoicequery);
			
			$payment_type = $result->payment_type;
			$payment_method = $result->type;
			$order_id = $result->order_id;
			
			if($payment_type == 'woocommerce' && ($payment_method == 'bacs' || $payment_method == 'cheque') && $result->payment_to == 'admin'){
			$invoiceid = $order_id;
			}elseif($payment_type == 'woocommerce' && $payment_method != 'bacs' && $payment_method != 'cheque'){
			$invoiceid = 'N/A';
			}elseif(($payment_type == 'local' || $payment_type == "") && $payment_method == 'wired' && $result->payment_to == 'admin'){
			$invoiceid = esc_html($result->wired_invoiceid);
			}else{
			$invoiceid = 'N/A';
			}
			
			$nestedData['bookingid'] = $result->id;
			$nestedData['delete'] = '<input type="checkbox" class="deleteAdminBookingRow" value="'.esc_attr($result->id).'"  />';
			
			if($result->multi_date == 'yes')
			{
			$bookingdatetime = $result->created;
			}else
			{
			$bookingdatetime = service_finder_date_format($result->date);
			$bookingdatetime .= '<br/>';
			$bookingdatetime .= $starttime.'-'.$endtime;
			}
			
			$nestedData['bookingrefid'] = $result->id;
			$nestedData['datetime'] = $bookingdatetime;
			
			$contactnumber = ($contactnumber != '') ? $contactnumber : 'N/A';
			$email = (service_finder_getProviderEmail($result->provider_id) != '') ? service_finder_getProviderEmail($result->provider_id) : 'N/A';
			
			$providerinfo = '<span data-toggle="popover" data-container="body" data-placement="top" type="button" data-html="true" id="providerinfo-'.$result->id.'" data-trigger="hover"><i class="fa fa-question-circle"></i></span>';
			$providerinfo .= '<div id="popover-content-providerinfo-'.$result->id.'" class="hide pop-full">
									<ul class="sf-popoverinfo-list">
										<li><span>'.esc_html__( 'Contact Number','service-finder' ).':</span> <span>'.$contactnumber.'</span></li>
										<li><span>'.esc_html__( 'Email','service-finder' ).':</span> <span>'.$email.'</span></li>
									</ul>
								</div>';
			
			$nestedData['providername'] = $result->proname.' '.$providerinfo;
			
			$cusphone = ($result->cusphone != '') ? $result->cusphone : 'N/A';
			$cusemail = ($result->cusemail != '') ? $result->cusemail : 'N/A';
			$cusaddress = ($result->cusaddress != '') ? $result->cusaddress : 'N/A';
			$cuscity = ($result->cuscity != '') ? $result->cuscity : 'N/A';
			
			$customerinfo = '<span data-toggle="popover" data-container="body" data-placement="top" type="button" data-html="true" id="customerinfo-'.$result->id.'" data-trigger="hover"><i class="fa fa-question-circle"></i></span>';
			$customerinfo .= '<div id="popover-content-customerinfo-'.$result->id.'" class="hide pop-full">
									<ul class="sf-popoverinfo-list">
										<li><span>'.esc_html__( 'Contact Number','service-finder' ).':</span> <span>'.$cusphone.'</span></li>
										<li><span>'.esc_html__( 'Email','service-finder' ).':</span> <span>'.$cusemail.'</span></li>
										<li><span>'.esc_html__( 'Address','service-finder' ).':</span> <span>'.$cusaddress.'</span></li>
										<li><span>'.esc_html__( 'City','service-finder' ).':</span> <span>'.$cuscity.'</span></li>
									</ul>
								</div>';
			
			$nestedData['customername'] = $result->cusname.' '.$customerinfo;
			$nestedData['upcomingpast'] = $status2;
			$nestedData['bookingstatus'] = $status;
			$nestedData['bookingtype'] = $type;
			
			$paytype = ($payment_type == 'woocommerce') ? esc_html__('Woocommerce','service-finder') : esc_html__('Local','service-finder');
			$txnid = ($result->txnid != '') ? $result->txnid : 'N/A';
			$payment_method = ($payment_method != '') ? service_finder_translate_static_status_string($payment_method) : 'N/A';
			
			$paymentinfo = '<span data-toggle="popover" data-container="body" data-placement="top" type="button" data-html="true" id="paymentinfo-'.$result->id.'" data-trigger="hover"><i class="fa fa-question-circle"></i></span>';
			$paymentinfo .= '<div id="popover-content-paymentinfo-'.$result->id.'" class="hide pop-full">
									<ul class="sf-popoverinfo-list">
										<li><span>'.esc_html__( 'Transaction ID','service-finder' ).':</span> <span>'.$txnid.'</span></li>
										<li><span>'.esc_html__( 'Payment Type','service-finder' ).':</span> <span>'.$paytype.'</span></li>
										<li><span>'.esc_html__( 'Payment Method','service-finder' ).':</span> <span>'.$payment_method.'</span></li>
										<li><span>'.esc_html__( 'Invoice ID (Wire Transffer)','service-finder' ).':</span> <span>'.$invoiceid.'</span></li>
									</ul>
								</div>';
			
			$nestedData['paymentstatus'] = $paymentstatus.' '.$paymentinfo;
			
			$adminfee = ($result->adminfee != '') ? $result->adminfee : 'N/A';
			$bookingamount = ($bookingamount != '') ? $bookingamount : 'N/A';
			
			$amountinfo = '<span data-toggle="popover" data-container="body" data-placement="top" type="button" data-html="true" id="amountinfo-'.$result->id.'" data-trigger="hover"><i class="fa fa-question-circle"></i></span>';
			$amountinfo .= '<div id="popover-content-amountinfo-'.$result->id.'" class="hide pop-full">
									<ul class="sf-popoverinfo-list">
										<li><span>'.esc_html__( 'Admin Fee','service-finder' ).':</span> <span>'.service_finder_money_format($adminfee).'</span></li>
										<li><span>'.esc_html__( 'Provider Fee','service-finder' ).':</span> <span>'.service_finder_money_format($bookingamount).'</span></li>
									</ul>
								</div>';
			
			$nestedData['bookingamout'] = service_finder_money_format($result->total).' '.$amountinfo;
			
			if($result->paid_to_provider == 'pending'){
				
				if($result->type == 'wired' && $result->payment_to == 'admin'){
				$nestedData['payviabanktransfer'] = '<button data-toggle="tooltip" type="button" data-bookingid="'.esc_attr($result->id).'" class="btn btn-table yellow statuspaytoprovider" title="'.esc_html__('Change Payment Status to Paid', 'service-finder').'">'.esc_html__('Change Status', 'service-finder').'</button>';
				}elseif(($result->type == 'bacs' || $result->type == 'cheque') && $result->payment_to == 'admin' && $result->payment_type == 'woocommerce'){
				$nestedData['payviabanktransfer'] = '<button data-toggle="tooltip" type="button" data-bookingid="'.esc_attr($result->id).'" class="btn btn-table yellow statuspaytoprovider" title="'.esc_html__('Change Payment Status to Paid', 'service-finder').'">'.esc_html__('Change Status', 'service-finder').'</button>';
				}else{
					$nestedData['payviabanktransfer'] = 'N/A';
				}
				
			}elseif($result->paid_to_provider == 'paid'){
				$nestedData['payviabanktransfer'] = esc_html__('Paid', 'service-finder');
			}else{
				$nestedData['payviabanktransfer'] = 'N/A';
			}
			
			if($result->status == 'Completed'){
			if($result->paid_to_provider == 'pending' && $result->type == "paypal"){
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" data-bookingid="'.esc_attr($result->id).'" data-providerid="'.esc_attr($result->wp_user_id).'" class="btn btn-table paytoprovider btn-status green" data-amount="'.esc_attr($bookingamount).'" title="'.esc_html__('Pay Now', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
			}elseif($result->paid_to_provider == 'pending' && $result->stripe_token != "" && $payment_methods['stripe']){
			
				$stripeconnecttype = (!empty($service_finder_options['stripe-connect-type'])) ? esc_html($service_finder_options['stripe-connect-type']) : '';
			
				if($stripeconnecttype == 'custom'){
				
				$acct_id = get_user_meta($result->wp_user_id,'stripe_connect_custom_account_id',true);
				}else{
				
				$acct_id = get_user_meta($result->wp_user_id,'stripe_connect_id',true);
				
				}
				
				if($acct_id != '')
				{
				if(service_finder_get_stripe_connect_avl_balance($result->wp_user_id) >= $bookingamount)
				{
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" data-bookingid="'.esc_attr($result->id).'" data-providerid="'.esc_attr($result->wp_user_id).'" data-amount="'.esc_attr($bookingamount).'" class="btn btn-table btn-status green paytoproviderviastripe" title="'.esc_html__('Pay Now', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
				}else
				{
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" data-bookingid="'.esc_attr($result->id).'" data-providerid="'.esc_attr($result->wp_user_id).'" data-amount="'.esc_attr($bookingamount).'" class="btn btn-table pay-disable" title="'.esc_html__('Payout balance not avialable yet.', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
				}
				}else{
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" class="btn btn-table pay-disable" title="'.esc_html__('This provider connect account is not connected to your stripe account yet.', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
				}
				
			}elseif($result->paid_to_provider == 'pending' && $result->type == "mangopay" && class_exists( 'WC_Vendors' ) && class_exists( 'WooCommerce' )){
				
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" data-orderid="'.esc_attr($result->order_id).'" data-bookingid="'.esc_attr($result->id).'" data-providerid="'.esc_attr($result->wp_user_id).'" data-amount="'.esc_attr($bookingamount).'" class="btn btn-table btn-status green paytoproviderviamangopay" title="'.esc_html__('Pay Now', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
			
			}elseif($result->paid_to_provider != 'pending' && $result->stripe_token != "" && $payment_methods['stripe']){
				$nestedData['payviabankpaypal'] = $result->paid_to_provider;
			}elseif($result->paid_to_provider == 'paid'){
				$nestedData['payviabankpaypal'] = esc_html__('Paid', 'service-finder');
			}elseif($result->paid_to_provider == 'in-process'){
				$nestedData['payviabankpaypal'] = esc_html__('In-process', 'service-finder');
			}else{
				$nestedData['payviabankpaypal'] = $result->paid_to_provider;
			}
			}else{
				$nestedData['payviabankpaypal'] = '<button data-toggle="tooltip" type="button" class="btn btn-table pay-disable" title="'.esc_html__('Booking is not completed yet.', 'service-finder').'">'.esc_html__('Pay Now', 'service-finder').'</button>';
			}
			
			$actionbtns = '';
			if($payment_type == 'woocommerce'){
				$actionbtns .= '<li><a href="'.admin_url().'post.php?post='.$order_id.'&action=edit" target="_blank"><i class="fa fa-shopping-cart"></i> '.esc_html__('View Order', 'service-finder').'</a></li>';
			}
			
			$actions = '<div class="dropdown action-dropdown dropdown-left">
						  <button class="action-button gray dropdown-toggle" type="button" data-toggle="dropdown"><i class="fa fa-ellipsis-v"></i></button>
						  <ul class="dropdown-menu">
							<li><a href="javascript:;" class="viewBookings" data-upcoming="'.esc_attr($upcoming).'" data-id="'.esc_attr($result->id).'"><i class="fa fa-eye"></i> '.esc_html__( 'View Booking','service-finder' ).'</a></li>
							'.$actionbtns.'
							<li><a href="javascript:;"><i class="fa fa-close"></i> '.esc_html__( 'Close','service-finder' ).'</a></li>
						  </ul>
						</div>';
			
			$nestedData['actions'] = $actions;
			
			$data[] = $nestedData;
		}
		
		$json_data = array( "data" => $data );
	
		echo json_encode($json_data);
	
		exit;
	}
	
	/*Delete Bookings*/
	public function service_finder_deleteAdminBookings(){
	global $wpdb, $service_finder_Tables;
			$data_ids = $_REQUEST['data_ids'];
			$data_id_array = explode(",", $data_ids); 
			if(!empty($data_id_array)) {
				foreach($data_id_array as $id) {
					$sql = $wpdb->prepare("DELETE FROM ".$service_finder_Tables->bookings." WHERE id = %d",$id);
					$query=$wpdb->query($sql);
					$sql = $wpdb->prepare("DELETE FROM ".$service_finder_Tables->booked_services." WHERE booking_id = %d",$id);
					$query=$wpdb->query($sql);
					$sql = $wpdb->prepare("DELETE FROM ".$service_finder_Tables->notifications." WHERE `topic` = 'Booking' AND `target_id` = %d",$id);
					$query=$wpdb->query($sql);
				}
			}
	exit(0);		
	}
	
	/*Approve wired booking*/
	public function service_finder_wired_booking_admin_approval(){
	global $wpdb, $service_finder_Tables;
	
	$bookingid = (!empty($_POST['bookingid'])) ? esc_html($_POST['bookingid']) : '';
	
		$data = array(
				'status' => 'Pending',
				);
		
		$where = array(
				'id' => $bookingid,
				);

$booking_id = $wpdb->update($service_finder_Tables->bookings,wp_unslash($data),$where);

if(is_wp_error($booking_id)){
			$error = array(
					'status' => 'error',
					'err_message' => $service_id->get_error_message()
					);
			echo json_encode($error);
		}else{
			
			$bookingdata = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->bookings.' WHERE `id` = %d',$bookingid),ARRAY_A);
			if(function_exists('service_finder_add_notices')) {
			$res = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->customers.' WHERE `id` = %d',$bookingdata['booking_customer_id']),ARRAY_A);
			$users = $wpdb->prefix . 'users';
			$row = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$users.' WHERE `user_email` = "%s"',$res['email']));
			
			
			$noticedata = array(
						'customer_id' => $row->ID,
						'target_id' => $bookingid, 
						'topic' => esc_html__('Approve Booking', 'service-finder'),
						'notice' => esc_html__('Booking have been approved after wired bank transffer', 'service-finder')
						);
				service_finder_add_notices($noticedata);
			
			}
			
			$senMail = new SERVICE_FINDER_sedateBookingManager();
			$senMail->service_finder_SendApproveBookingMailToProvider($bookingdata,$bookingdata['adminfee']);
			$senMail->service_finder_SendApproveBookingMailToCustomer($bookingdata,$bookingdata['adminfee']);
			$senMail->service_finder_SendApproveBookingMailToAdmin($bookingdata,$bookingdata['adminfee']);
			
			$success = array(
					'status' => 'success',
					'suc_message' => esc_html__('Booking approved successfully.', 'service-finder'),
					);
			echo json_encode($success);
		}
	exit(0);	
	}
	
	/*Send Booking Approval mail to provider*/
	public function service_finder_SendApproveBookingMailToProvider($bookingdata,$adminfee = '0.0'){
		global $service_finder_options, $service_finder_Tables, $wpdb;
		
		$providerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->providers.' WHERE `wp_user_id` = %d',$bookingdata['provider_id']));
		$customerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->customers.' WHERE `id` = %d',$bookingdata['booking_customer_id']));
		
		$bookingpayment_mode = (!empty($maildata['type'])) ? $maildata['type'] : '';
		
		$payent_mode = ($bookingpayment_mode != '') ? $bookingpayment_mode : 'free';
		
		$pay_booking_amount_to = (!empty($service_finder_options['pay_booking_amount_to'])) ? $service_finder_options['pay_booking_amount_to'] : '';
		
		if(!empty($service_finder_options['booking-approval-to-provider'])){
			$message = $service_finder_options['booking-approval-to-provider'];
		}else{
			$message = '
<h4>Booking Approved</h4>
Date: %DATE%
				
				Time: %STARTTIME% - %ENDTIME%
				
				Member Name: %MEMBERNAME%
<h4>Provider Details</h4>
Provider Name: %PROVIDERNAME%

Provider Email: %PROVIDEREMAIL%
				
				Phone: %PROVIDERPHONE%
<h4>Customer Details</h4>
Customer Name: %CUSTOMERNAME%

Customer Email: %CUSTOMEREMAIL%

Phone: %CUSTOMERPHONE%

Alternate Phone: %CUSTOMERPHONE2%

Address: %ADDRESS%

Apt/Suite: %APT%

City: %CITY%

State: %STATE%

Postal Code: %ZIPCODE%

Country: %COUNTRY%

Services: %SERVICES%

<h4>Payment Details</h4>
Pay Via: %PAYMENTMETHOD%
				
Amount: %AMOUNT%
				
Admin Fee: %ADMINFEE%';
}
			
			$tokens = array('%DATE%','%STARTTIME%','%ENDTIME%','%MEMBERNAME%','%PROVIDERNAME%','%PROVIDEREMAIL%','%PROVIDERPHONE%','%CUSTOMERNAME%','%CUSTOMEREMAIL%','%CUSTOMERPHONE%','%CUSTOMERPHONE2%','%ADDRESS%','%APT%','%CITY%','%STATE%','%ZIPCODE%','%COUNTRY%','%SERVICES%','%PAYMENTMETHOD%','%AMOUNT%','%ADMINFEE%');
			
			if($bookingdata['member_id'] > 0){
			$membername = service_finder_getMemberName($bookingdata['member_id']);
			}else{
			$membername = '-';
			}
			
			$services = service_finder_get_booking_services($bookingdata['id']);
			
			$charge_admin_fee = (!empty($service_finder_options['charge-admin-fee'])) ? $service_finder_options['charge-admin-fee'] : '';
			$charge_admin_fee_from = (!empty($service_finder_options['charge-admin-fee-from'])) ? $service_finder_options['charge-admin-fee-from'] : '';
			
			if($charge_admin_fee_from == 'provider' && $pay_booking_amount_to == 'admin' && $charge_admin_fee){
			$bookingamount = $bookingdata['total'] - $adminfee;
			}elseif($charge_admin_fee_from == 'customer' && $charge_admin_fee && $pay_booking_amount_to == 'admin'){
			$bookingamount = $bookingdata['total'];
			}else{
			$bookingamount = $bookingdata['total'];
			$adminfee = '0.0';
			}
			
			$replacements = array(service_finder_date_format($bookingdata['date']),$bookingdata['start_time'],service_finder_get_booking_end_time($bookingdata['end_time'],$bookingdata['end_time_no_buffer']),$membername,service_finder_get_providername_with_link($providerInfo->wp_user_id),$providerInfo->email,service_finder_get_contact_info($providerInfo->phone,$providerInfo->mobile),$customerInfo->name,$customerInfo->email,$customerInfo->phone,$customerInfo->phone2,$customerInfo->address,$customerInfo->apt,$customerInfo->city,$customerInfo->state,$customerInfo->zipcode,$customerInfo->country,$services,ucfirst($payent_mode),service_finder_money_format($bookingamount),service_finder_money_format($adminfee));
			$msg_body = str_replace($tokens,$replacements,$message);
			
			if($service_finder_options['booking-approval-to-provider-subject'] != ""){
				$msg_subject = $service_finder_options['booking-approval-to-provider-subject'];
			}else{
				$msg_subject = esc_html__('Booking Approval Notification', 'service-finder');
			}
			
			if(service_finder_wpmailer($providerInfo->email,$msg_subject,$msg_body)) {

$success = array(
						'status' => 'success',
						'suc_message' => esc_html__('Message has been sent', 'service-finder'),
						);
				$service_finder_Success = json_encode($success);
				return $service_finder_Success;
				
				
			} else {
					
				$error = array(
						'status' => 'error',
						'err_message' => esc_html__('Message could not be sent.', 'service-finder'),
						);
				$service_finder_Errors = json_encode($error);
				return $service_finder_Errors;
			}
		
	}
	
	/*Send Booking Approval mail to customer*/
	public function service_finder_SendApproveBookingMailToCustomer($bookingdata,$adminfee = '0.0'){
		global $service_finder_options, $service_finder_Tables, $wpdb;
		$providerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->providers.' WHERE `wp_user_id` = %d',$bookingdata['provider_id']));
		$customerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->customers.' WHERE `id` = %d',$bookingdata['booking_customer_id']));
		
		$bookingpayment_mode = (!empty($maildata['type'])) ? $maildata['type'] : '';
		
		$payent_mode = ($bookingpayment_mode != '') ? $bookingpayment_mode : 'free';
		
		$pay_booking_amount_to = (!empty($service_finder_options['pay_booking_amount_to'])) ? $service_finder_options['pay_booking_amount_to'] : '';
		
		if(!empty($service_finder_options['booking-approval-to-customer'])){
			$message = $service_finder_options['booking-approval-to-customer'];
		}else{
			$message = '
<h4>Booking Details</h4>
Date: %DATE%
				
				Time: %STARTTIME% - %ENDTIME%
				
				Member Name: %MEMBERNAME%
<h4>Provider Details</h4>
Provider Name: %PROVIDERNAME%

Provider Email: %PROVIDEREMAIL%
				
				Phone: %PROVIDERPHONE%
<h4>Customer Details</h4>
Customer Name: %CUSTOMERNAME%

Customer Email: %CUSTOMEREMAIL%

Phone: %CUSTOMERPHONE%

Alternate Phone: %CUSTOMERPHONE2%

Address: %ADDRESS%

Apt/Suite: %APT%

City: %CITY%

State: %STATE%

Postal Code: %ZIPCODE%

Country: %COUNTRY%

Services: %SERVICES%

<h4>Payment Details</h4>
Pay Via: %PAYMENTMETHOD%
				
				Amount: %AMOUNT%
				
				Admin Fee: %ADMINFEE%';
		}
		
			$tokens = array('%DATE%','%STARTTIME%','%ENDTIME%','%MEMBERNAME%','%PROVIDERNAME%','%PROVIDEREMAIL%','%PROVIDERPHONE%','%CUSTOMERNAME%','%CUSTOMEREMAIL%','%CUSTOMERPHONE%','%CUSTOMERPHONE2%','%ADDRESS%','%APT%','%CITY%','%STATE%','%ZIPCODE%','%COUNTRY%','%SERVICES%','%PAYMENTMETHOD%','%AMOUNT%','%ADMINFEE%');
			
			if($bookingdata['member_id'] > 0){
			$membername = service_finder_getMemberName($bookingdata['member_id']);
			}else{
			$membername = '-';
			}
			$services = service_finder_get_booking_services($bookingdata['id']);
			
			$charge_admin_fee_from = (!empty($service_finder_options['charge-admin-fee-from'])) ? $service_finder_options['charge-admin-fee-from'] : '';
			$charge_admin_fee = (!empty($service_finder_options['charge-admin-fee'])) ? $service_finder_options['charge-admin-fee'] : '';
			
			if($charge_admin_fee_from == 'provider' && $charge_admin_fee && $pay_booking_amount_to == 'admin'){
			$adminfee = '0.0';
			}
			
			$replacements = array(service_finder_date_format($bookingdata['date']),$bookingdata['start_time'],service_finder_get_booking_end_time($bookingdata['end_time'],$bookingdata['end_time_no_buffer']),$membername,service_finder_get_providername_with_link($providerInfo->wp_user_id),$providerInfo->email,service_finder_get_contact_info($providerInfo->phone,$providerInfo->mobile),$customerInfo->name,$customerInfo->email,$customerInfo->phone,$customerInfo->phone2,$customerInfo->address,$customerInfo->apt,$customerInfo->city,$customerInfo->state,$customerInfo->zipcode,$customerInfo->country,$services,ucfirst($payent_mode),service_finder_money_format($bookingdata['total']),service_finder_money_format($adminfee));
			$msg_body = str_replace($tokens,$replacements,$message);

if($service_finder_options['booking-approval-to-customer-subject'] != ""){
				$msg_subject = $service_finder_options['booking-approval-to-customer-subject'];
			}else{
				$msg_subject = esc_html__('Booking Approval Notification', 'service-finder');
			}
			
			if(service_finder_wpmailer($customerInfo->email,$msg_subject,$msg_body)) {

$success = array(
						'status' => 'success',
						'suc_message' => esc_html__('Message has been sent', 'service-finder'),
						);
				$service_finder_Success = json_encode($success);
				return $service_finder_Success;
				
				
			} else {
					
				$error = array(
						'status' => 'error',
						'err_message' => esc_html__('Message could not be sent.', 'service-finder'),
						);
				$service_finder_Errors = json_encode($error);
				return $service_finder_Errors;
			}
		
	}
	
	/*Send Booking Approval mail to admin*/
	public function service_finder_SendApproveBookingMailToAdmin($bookingdata,$adminfee = '0.0'){
		global $service_finder_options, $wpdb, $service_finder_Tables;
		$providerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->providers.' WHERE `wp_user_id` = %d',$bookingdata['provider_id']));
		$customerInfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->customers.' WHERE `id` = %d',$bookingdata['booking_customer_id']));
		
		$bookingpayment_mode = (!empty($bookingdata['type'])) ? $bookingdata['type'] : '';
		
		$payent_mode = ($bookingpayment_mode != '') ? $bookingpayment_mode : 'free';
		
		$pay_booking_amount_to = (!empty($service_finder_options['pay_booking_amount_to'])) ? $service_finder_options['pay_booking_amount_to'] : '';
		
		if(!empty($service_finder_options['booking-approval-to-admin'])){
			$message = $service_finder_options['booking-approval-to-admin'];
		}else{
			$message = '
<h4>Booking Details</h4>
Date: %DATE%
				
				Time: %STARTTIME% - %ENDTIME%
				
				Member Name: %MEMBERNAME%
<h4>Provider Details</h4>
Provider Name: %PROVIDERNAME%

Provider Email: %PROVIDEREMAIL%
				
				Phone: %PROVIDERPHONE%
<h4>Customer Details</h4>
Customer Name: %CUSTOMERNAME%

Customer Email: %CUSTOMEREMAIL%

Phone: %CUSTOMERPHONE%

Alternate Phone: %CUSTOMERPHONE2%

Address: %ADDRESS%

Apt/Suite: %APT%

City: %CITY%

State: %STATE%

Postal Code: %ZIPCODE%

Country: %COUNTRY%

Services: %SERVICES%

<h4>Payment Details</h4>
Pay Via: %PAYMENTMETHOD%
				
				Amount: %AMOUNT%
				
				Admin Fee: %ADMINFEE%';
		}
			
			$tokens = array('%DATE%','%STARTTIME%','%ENDTIME%','%MEMBERNAME%','%PROVIDERNAME%','%PROVIDEREMAIL%','%PROVIDERPHONE%','%CUSTOMERNAME%','%CUSTOMEREMAIL%','%CUSTOMERPHONE%','%CUSTOMERPHONE2%','%ADDRESS%','%APT%','%CITY%','%STATE%','%ZIPCODE%','%COUNTRY%','%SERVICES%','%PAYMENTMETHOD%','%AMOUNT%','%ADMINFEE%');
			
			if($bookingdata['member_id'] > 0){
			$membername = service_finder_getMemberName($bookingdata['member_id']);
			}else{
			$membername = '-';
			}
			$services = service_finder_get_booking_services($bookingdata['id']);
			
			$charge_admin_fee = (!empty($service_finder_options['charge-admin-fee'])) ? $service_finder_options['charge-admin-fee'] : '';
			$charge_admin_fee_from = (!empty($service_finder_options['charge-admin-fee-from'])) ? $service_finder_options['charge-admin-fee-from'] : '';
			
			if($charge_admin_fee_from == 'provider' && $charge_admin_fee && $pay_booking_amount_to == 'admin'){
			$bookingamount = $bookingdata['total'] - $adminfee;
			}elseif($charge_admin_fee_from == 'customer' && $charge_admin_fee && $pay_booking_amount_to == 'admin'){
			$bookingamount = $bookingdata['total'];
			}else{
			$bookingamount = $bookingdata['total'];
			$adminfee = '0.0';
			}
			
			$replacements = array(service_finder_date_format($bookingdata['date']),$bookingdata['start_time'],service_finder_get_booking_end_time($bookingdata['end_time'],$bookingdata['end_time_no_buffer']),$membername,service_finder_get_providername_with_link($providerInfo->wp_user_id),$providerInfo->email,service_finder_get_contact_info($providerInfo->phone,$providerInfo->mobile),$customerInfo->name,$customerInfo->email,$customerInfo->phone,$customerInfo->phone2,$customerInfo->address,$customerInfo->apt,$customerInfo->city,$customerInfo->state,$customerInfo->zipcode,$customerInfo->country,$services,ucfirst($payent_mode),service_finder_money_format($bookingamount),service_finder_money_format($adminfee));
			$msg_body = str_replace($tokens,$replacements,$message);
			
			if($service_finder_options['booking-approval-to-admin-subject'] != ""){
				$msg_subject = $service_finder_options['booking-approval-to-admin-subject'];
			}else{
				$msg_subject = esc_html__('Booking Approval Notification', 'service-finder');
			}
			
			if(service_finder_wpmailer(get_option('admin_email'),$msg_subject,$msg_body)) {

$success = array(
						'status' => 'success',
						'suc_message' => esc_html__('Message has been sent', 'service-finder'),
						);
				$service_finder_Success = json_encode($success);
				return $service_finder_Success;
				
				
			} else {
					
				$error = array(
						'status' => 'error',
						'err_message' => esc_html__('Message could not be sent.', 'service-finder'),
						);
				$service_finder_Errors = json_encode($error);
				return $service_finder_Errors;
			}
		
	}
	
	/*Pay to Provider via masspay paypal*/
	public function service_finder_pay_via_masspay(){
		global $wpdb,$service_finder_options, $service_finder_Tables;
		
		$providerid = (!empty($_POST['providerid'])) ? esc_html($_POST['providerid']) : '';
		$bookingid = (!empty($_POST['bookingid'])) ? esc_html($_POST['bookingid']) : '';
		
		$amount = (!empty($_POST['amount'])) ? esc_html($_POST['amount']) : '';
		$args = array( 
				'providerid'	=> $providerid,
				'bookingid'		=> $bookingid,
				'payoutamount'	=> $amount,
				'payouttype'	=> 'manual',
		);
		
		$payout = new service_finder_payment_masspay();
		$response = $payout->service_finder_process_payment($args);
		
		if($response['type'] == 'success')
		{
			$data = array(
					'paid_to_provider' => 'paid',
					);
			
			$where = array(
					'id' => $bookingid,
					);
			
			$booking_id = $wpdb->update($service_finder_Tables->bookings,wp_unslash($data),$where);
			
			if(function_exists('service_finder_add_notices')) {
				$noticedata = array(
						'provider_id' => $providerid,
						'target_id' => $bookingid, 
						'topic' => esc_html__('Booking Payment', 'service-finder'),
						'notice' => esc_html__('Site administrator paid you for your service via paypal masspay', 'service-finder')
						);
				service_finder_add_notices($noticedata);
			
			}
			
			$success = array(
					'status' => 'success',
					'suc_message' => $response['message']
					);
			echo json_encode($success);
		}else
		{
			$error = array(
					'status' => 'error',
					'err_message' => $response['message']
					);
			echo json_encode($error);
		}
		exit(0);
	}
	
	/*Pay to Provider via stripe connect*/
	public function service_finder_pay_via_stripe_connect(){
		global $wpdb,$service_finder_options, $service_finder_Tables;

$providerid = (!empty($_POST['providerid'])) ? esc_html($_POST['providerid']) : '';
		$bookingid = (!empty($_POST['bookingid'])) ? esc_html($_POST['bookingid']) : '';
		$amount = (!empty($_POST['amount'])) ? esc_html($_POST['amount']) : '';
		$order_id = (!empty($_POST['orderid'])) ? esc_html($_POST['orderid']) : '';
		$order_author_id = get_post_field( 'post_author', $order_id );
		
		$fees = 0;
		$currency	= get_woocommerce_currency();
		
		$mp_account_id = service_finder_get_mp_account_id($providerid);
		
		if(!$mp_account_id){
			$error = array(
					'status' => 'error',
					'err_message' => esc_html__('Vendor does not have a MANGOPAY bank account.', 'service-finder'),
					);
			echo json_encode($error);
			
			exit(0);
		}
		
		$result = service_finder_payout(  $order_author_id, $mp_account_id, $order_id, $currency, $amount, $fees );
		
		
		if(	isset( $result->Status ) && ( 'SUCCEEDED' == $result->Status || 'CREATED' == $result->Status )) {
			
			update_post_meta($order_id,'mp_payout_result',$result);
			update_post_meta($order_id,'mp_payout_status',$result->Status);
			update_post_meta($order_id,'mp_payout_id',$result->Id);
			update_post_meta($order_id,'mp_payout_due','yes');
			update_post_meta($order_id,'mp_booking_id',$bookingid);
			
			if('SUCCEEDED' == $result->Status){
				$payoutstatus = 'paid';
				$noticemsg = sprintf(esc_html__('Succeed: Payout has been paid to your bank account. Booking Ref id is #%d', 'service-finder'),$bookingid);
			}elseif('CREATED' == $result->Status){
				$payoutstatus = 'created';
				$noticemsg = sprintf(esc_html__('Created: The payout released by admin. Booking Ref id is #%d', 'service-finder'),$bookingid);
				
			}
			
			$data = array(
					'paid_to_provider' => $payoutstatus,
					);
			
			$where = array(
					'id' => $bookingid,
					);
			
			$booking_id = $wpdb->update($service_finder_Tables->bookings,wp_unslash($data),$where);
			
			$data = array(
					'status' => $payoutstatus,
					);
			
			$where = array(
					'order_id' => $order_id,
					);
			
			$commission_id = $wpdb->update($wpdb->prefix.'pv_commission',wp_unslash($data),$where);
			
			$data = array(
					'created' => date('Y-m-d h:i:s'),
					'payout_id' => $result->Id,
					'order_id' => $order_id,
					'mp_account_id' => $mp_account_id,
					'provider_id' => $providerid,
					'booking_id' => $bookingid,
					'amount' => $amount,
					'status' => $result->Status,
					);
					
			$wpdb->insert($service_finder_Tables->mp_payout_history,wp_unslash($data));
			
			if(function_exists('service_finder_add_notices')) {
				$row = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->bookings.' WHERE `id` = %d',$bookingid));	
				$noticedata = array(
						'provider_id' => $row->provider_id,
						'target_id' => $row->id, 
						'topic' => esc_html__('Booking Payment', 'service-finder'),
						'notice' => $noticemsg
						);
				service_finder_add_notices($noticedata);
			
			}
			
			$success = array(
					'status' => 'success',
					'suc_message' => esc_html__('Payout created for vendor successfully.', 'service-finder'),
					);
			echo json_encode($success);
		} else {
			
			$errmsg = esc_html__('Vendor MANGOPAY payout transaction failed.', 'service-finder');
			if($result->ResultMessage){
			$errmsg .= ': '.$result->ResultMessage;
			}
			
			$error = array(
					'status' => 'error',
					'err_message' => $errmsg
					);
			echo json_encode($error);
			
		}
		
		exit(0);
	}
	
	/*Change provider payment status from pending to paid*/
	public function service_finder_status_pay_to_provider(){
		global $wpdb, $service_finder_options, $service_finder_Tables;
		$receiver          = array();
		
		$bookingid = (!empty($_POST['bookingid'])) ? esc_html($_POST['bookingid']) : '';
		
		$data = array(
				'paid_to_provider' => 'paid',
				);
		
		$where = array(
				'id' => $bookingid,
				);
		
		$booking_id = $wpdb->update($service_finder_Tables->bookings,wp_unslash($data),$where);
				
		if(is_wp_error($booking_id)){
			$error = array(
					'status' => 'error',
					'err_message' => $booking_id->get_error_message()
					);
			echo json_encode($error);
		}else{
			
			if(function_exists('service_finder_add_notices')) {
				$row = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->bookings.' WHERE `id` = %d',$bookingid));	
				$noticedata = array(
						'provider_id' => $row->provider_id,
						'target_id' => $row->id, 
						'topic' => esc_html__('Booking Payment', 'service-finder'),
						'notice' => esc_html__('Site administrator paid you for your service via bank transfer', 'service-finder')
						);
				service_finder_add_notices($noticedata);
			
			}
			
			$success = array(
					'status' => 'success',
					'suc_message' => esc_html__('Payment status changed successfully.', 'service-finder'),
					);
			echo json_encode($success);
		}
		 
		exit(0);
	}
	
	/*Actions for wp ajax call*/
	public function service_finder_registerWpActions() {
       $_this = $this;
	   add_action(
                    'wp_ajax_get_admin_bookings',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_get_admin_bookings' ) );
                    }
						
                );
		add_action(
                    'wp_ajax_delete_admin_bookings',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_deleteAdminBookings' ) );
                    }
						
                );
				
		add_action(
                    'wp_ajax_wired_booking_admin_approval',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_wired_booking_admin_approval' ) );
                    }
						
                );
		add_action(
                    'wp_ajax_pay_via_masspay',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_pay_via_masspay' ) );
                    }
						
                );
		add_action(
                    'wp_ajax_pay_via_stripe_connect',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_pay_via_stripe_connect' ) );
                    }
						
                );
		add_action(
                    'wp_ajax_pay_via_mangopay',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_pay_via_mangopay' ) );
                    }
						
                );				
		add_action(
                    'wp_ajax_status_pay_to_provider',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_status_pay_to_provider' ) );
                    }
						
                );								
				
    }
	
}

[+] ..
[+] resources
[+] templates
[-] sedateBookingManager.php [edit]