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

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

<?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_sedateFeatured
 */
class SERVICE_FINDER_jobconnectRequest extends SERVICE_FINDER_sedateManager{

/*Initial Function*/
	public function service_finder_index()
    {
        
		/*Rander providers template*/
		$this->service_finder_render( 'index','jobconnect-request' );
		
		/*Action for wp ajax call*/
		$this->service_finder_registerWpActions();
		
    }
	
	/*Actions for wp ajax call*/
	protected function service_finder_registerWpActions() {
       $_this = $this;
	   add_action(
                    'wp_ajax_get_jobconnect_requests',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_get_jobconnect_requests' ) );
                    }
						
                );
		add_action(
                    'wp_ajax_approve_jobconnect_request',
					function () use ( $_this ) {
						call_user_func( array( $_this, 'service_finder_approve_jobconnect_request' ) );
                    }
						
                );	
    }
	
	public function service_finder_get_jobconnect_requests(){
		global $wpdb, $service_finder_Tables, $service_finder_options;
		$requestData= $_REQUEST;

$requests = $wpdb->get_results('SELECT * FROM '.$wpdb->prefix.'usermeta WHERE `meta_key` = "job_connect_request_status"');
		
		$data = array();
		
		foreach($requests as $result){
			$nestedData=array(); 
			$userid = $result->user_id;
			$requestdata = get_user_meta($userid,'job_connect_request',true);
			$row = $wpdb->get_row('SELECT * FROM '.$service_finder_Tables->job_limits.' WHERE `provider_id` = "'.$userid.'"');
			
			$nestedData['requestid'] = $result->umeta_id;
			
			if(service_finder_getUserRole($userid) == 'Provider'){
				$nestedData['username'] = service_finder_getProviderFullName($userid);
				$nestedData['userrole'] = (!empty($service_finder_options['provider-replace-string'])) ? $service_finder_options['provider-replace-string'] : esc_html__('Provider', 'service-finder');
				$current_plan = $row->current_plan;
				$current_plan = (!empty($service_finder_options['plan'.$current_plan.'-name'])) ? $service_finder_options['plan'.$current_plan.'-name'] : '';
				
				$upgrade_plan = $requestdata['current_plan'];
				$upgrade_plan = (!empty($service_finder_options['plan'.$upgrade_plan.'-name'])) ? $service_finder_options['plan'.$upgrade_plan.'-name'] : '';
			}else{
				$nestedData['username'] = service_finder_getCustomerName($userid);
				$nestedData['userrole'] = (!empty($service_finder_options['customer-replace-string'])) ? $service_finder_options['customer-replace-string'] : esc_html__('Customer', 'service-finder');	
				$current_plan = $row->current_plan;
				$current_plan = (!empty($service_finder_options['job-post-plan'.$current_plan.'-name'])) ? $service_finder_options['job-post-plan'.$current_plan.'-name'] : '';
				
				$upgrade_plan = $requestdata['current_plan'];
				$upgrade_plan = (!empty($service_finder_options['job-post-plan'.$upgrade_plan.'-name'])) ? $service_finder_options['job-post-plan'.$upgrade_plan.'-name'] : '';
			}
			$nestedData['transactiondate'] = service_finder_date_format($requestdata['date']);
			$nestedData['currentplan'] = $current_plan;
			$nestedData['upgraderequestplan'] = $upgrade_plan;
			
			if($row->payment_type == 'woocommerce' && ($row->payment_method == 'bacs' || $row->payment_method == 'cheque')){
			$wiredinvoiceid = $row->txn_id;
			}elseif($row->payment_type == 'woocommerce' && $row->payment_method != 'bacs' && $row->payment_method != 'cheque'){
			$wiredinvoiceid = 'N/A';
			}elseif($row->payment_type == 'local' && $row->payment_method == 'wire-transfer'){
			$wiredinvoiceid = ($requestdata['wired_invoiceid'] != "") ? $requestdata['wired_invoiceid'] : '';
			}else{
			$wiredinvoiceid = 'N/A';
			}
			
			$paytype = ($row->payment_type == 'woocommerce') ? esc_html__('Woocommerce','service-finder') : esc_html__('Local','service-finder');
			$paymentmethod = ($row->payment_method != '') ? service_finder_translate_static_status_string($row->payment_method) : 'N/A';
			if($row->payment_status == 'on-hold' && $row->payment_type == 'woocommerce'){
				$nestedData['paymentstatus'] = '<a href="'.admin_url().'post.php?post='.$row->txn_id.'&action=edit" target="_blank">'.esc_html__('Approve', 'service-finder').'</a>';
			}elseif($result->meta_value == 'pending' && $row->payment_type != 'woocommerce'){
				$nestedData['paymentstatus'] = '<a href="javascript:;" data-id="'.esc_attr($userid).'" class="app_jobconnect_request">'.esc_html__('Approve', 'service-finder').'</a>';
			}else{
				if($row->payment_type == 'woocommerce'){
					$nestedData['paymentstatus'] = service_finder_translate_static_status_string($row->payment_status);
				}else{
					$nestedData['paymentstatus'] = esc_html__( 'Paid', 'service-finder' );
				}
			}
			
			$paymentinfo = '<span data-toggle="popover" data-container="body" data-placement="top" type="button" data-html="true" id="paymentinfo-'.$result->umeta_id.'" data-trigger="hover"><i class="fa fa-question-circle"></i></span>';
			$paymentinfo .= '<div id="popover-content-paymentinfo-'.$result->umeta_id.'" class="hide pop-full">
									<ul class="sf-popoverinfo-list">
										<li><span>'.esc_html__( 'Payment Type','service-finder' ).':</span> <span>'.$paytype.'</span></li>
										<li><span>'.esc_html__( 'Payment Method','service-finder' ).':</span> <span>'.$paymentmethod.'</span></li>
										<li><span>'.esc_html__( 'Invoice ID (Wire Transffer)','service-finder' ).':</span> <span>'.$wiredinvoiceid.'</span></li>
									</ul>
								</div>';
			
			$nestedData['amount'] = service_finder_currencysymbol().$requestdata['planprice'].' '.$paymentinfo;
			
			$actionbtns = '';
			if($row->payment_type == 'woocommerce'){
				$actionbtns .= '<li><a href="'.admin_url().'post.php?post='.$row->txn_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="'.esc_url(service_finder_get_author_url($userid)).'" target="_blank"><i class="fa fa-eye"></i> '.esc_html__('View Profile', '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;
	}
	
	public function service_finder_approve_jobconnect_request(){
	global $wpdb, $service_finder_Tables;
	
	$userid = (isset($_POST['uid'])) ? esc_html($_POST['uid']) : '';
	
	$row = $wpdb->get_row($wpdb->prepare('SELECT * FROM '.$service_finder_Tables->job_limits.' WHERE `provider_id` = %d',$userid));

$requestdata = get_user_meta($userid,'job_connect_request',true);
		
	$data = array(
			'paid_limits' => $requestdata['paid_limits'],
			'available_limits' => $requestdata['available_limits'],
			'payment_method' => 'wire-transfer',
			'payment_status' => 'paid',
			'current_plan' => $requestdata['current_plan'],
			);
	$where = array(
			'provider_id' => $userid
	);
	$res = $wpdb->update($service_finder_Tables->job_limits,wp_unslash($data),$where);
	
	if(!empty($row)){
	$paydate = date('Y-m-d h:i:s');
	$txndata = array(
			'provider_id' => $userid,
			'payment_date' => $paydate,
			'txn_id' => $requestdata['wired_invoiceid'],
			'plan' => $requestdata['current_plan'],
			'amount' => $requestdata['planprice'],
			'limit' => $requestdata['limit'],
			'payment_method' => 'wire-transfer',
			'payment_status' => 'paid',
			);
	$where = array(
			'txn_id' => $row->txn_id
	);
	$res = $wpdb->update($service_finder_Tables->transaction,wp_unslash($txndata),$where);
	}
	
	update_user_meta($userid, 'job_connect_request_status','approve');
	//delete_user_meta($userid, 'job_connect_request');
	
	if(service_finder_getUserRole($userid) == 'Provider'){
	send_mail_after_joblimit_connect_purchase( $userid );	
	}else{
	send_mail_after_jobpost_limit_connect_purchase( $userid );
	}
	
	$success = array(
			'status' => 'success',
			'suc_message' => esc_html__('Job connects upgrade successfully', 'service-finder'),
			);
	echo json_encode($success);
	
	exit(0);
	}
	
}

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