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

PATH: home / letacommog / pymreception1 / wp-content / plugins / wc-frontend-manager / controllers / enquiry

<?php
/**
 * WCFM plugin controllers
 *
 * Plugin Enquiry Controller
 *
 * @author 		WC Lovers
 * @package 	wcfm/controllers/enquiry
 * @version 3.0.6
 */

class WCFM_Enquiry_Controller {
	
	public function __construct() {
		global $WCFM;
		
		if( !defined('WCFM_REST_API_CALL') ) {
			$this->processing();
		}
	}
	
	public function processing() {
		global $WCFM, $wpdb, $_POST;
		
		$length = $_POST['length'];
		$offset = $_POST['start'];
		
		$vendor_id = apply_filters( 'wcfm_current_vendor_id', get_current_user_id() );
		
		$enquiry_product = '';
		if ( ! empty( $_POST['enquiry_product'] ) ) {
			$enquiry_product = esc_sql( $_POST['enquiry_product'] );
		}
		
		$enquiry_vendor = '';
		if ( ! empty( $_POST['enquiry_vendor'] ) ) {
			$enquiry_vendor = esc_sql( $_POST['enquiry_vendor'] );
		}
		
		$is_private = '';
		if ( ! empty( $_POST['is_private'] ) ) {
			$is_private = esc_sql( $_POST['is_private'] );
		}
		
		$time_filter = '';
		
		$the_orderby = ! empty( $_POST['orderby'] ) ? sanitize_text_field( $_POST['orderby'] ) : 'ID';
		$the_order   = ( ! empty( $_POST['order'] ) && 'asc' === $_POST['order'] ) ? 'ASC' : 'DESC';
		
		$items_per_page = $length;
		
		$sql = "SELECT count(ID) FROM {$wpdb->prefix}wcfm_enquiries AS commission";
		$sql .= " WHERE 1 = 1";
		
		if( $enquiry_product ){
			$sql .= " AND `product_id` = {$enquiry_product}";
		}
		
		if( $is_private ){
			$sql .= " AND `is_private` = {$is_private}";
		}
		
		if( wcfm_is_vendor() ) { 
			$sql .= " AND `vendor_id` = {$vendor_id}";
		} elseif ( ! empty( $_POST['enquiry_vendor'] ) ) {
			$sql .= " AND `vendor_id` = {$enquiry_vendor}";
		}
		if ( ! empty( $_POST['filter_date_form'] ) && ! empty( $_POST['filter_date_to'] ) ) {
			$start_date = date( 'Y-m-d', strtotime( $_POST['filter_date_form'] ) );
			$end_date = date( 'Y-m-d', strtotime( $_POST['filter_date_to'] ) );
			$time_filter = " AND DATE( commission.posted ) BETWEEN '" . $start_date . "' AND '" . $end_date . "'";
			$sql .= $time_filter;
		}
		$sql = apply_filters( 'wcfm_enquery_count_query', $sql);
		
		$total_enquiries = $wpdb->get_var( $sql );
		
		$enquiry_query = "SELECT * FROM {$wpdb->prefix}wcfm_enquiries AS commission";
		$enquiry_query .= " WHERE 1 = 1";
		
		if( $enquiry_product ){
			$enquiry_query .= " AND `product_id` = {$enquiry_product}";
		}
		
		if( $is_private ){
			$enquiry_query .= " AND `is_private` = {$is_private}";
		}
		
		if( wcfm_is_vendor() ) { 
			$enquiry_query .= " AND `vendor_id` = {$vendor_id}";
		} elseif ( ! empty( $_POST['enquiry_vendor'] ) ) {
			$enquiry_query .= " AND `vendor_id` = {$enquiry_vendor}";
		}
		if ( ! empty( $_POST['filter_date_form'] ) && ! empty( $_POST['filter_date_to'] ) ) {
			$enquiry_query .= $time_filter;
		}
		$enquiry_query = apply_filters( 'wcfm_enquery_list_query', $enquiry_query );
		
		$enquiry_query .= " ORDER BY commission.`{$the_orderby}` {$the_order}";

$enquiry_query .= " LIMIT {$items_per_page}";

$enquiry_query .= " OFFSET {$offset}";
		
		$wcfm_enquirys_array = $wpdb->get_results( $enquiry_query );
		
		if(defined('WCFM_REST_API_CALL')){
 return $wcfm_enquirys_array;
 }
		
		// Generate Enquirys JSON
		$wcfm_enquirys_json = '';
		$wcfm_enquirys_json = '{
															"draw": ' . $_POST['draw'] . ',
															"recordsTotal": ' . $total_enquiries . ',
															"recordsFiltered": ' . $total_enquiries . ',
															"data": ';
		if(!empty($wcfm_enquirys_array)) {
			$index = 0;
			$wcfm_enquirys_json_arr = array();
			foreach($wcfm_enquirys_array as $wcfm_enquirys_single) {
				// Enquiry
				$wcfm_enquirys_json_arr[$index][] = '<a href="' . get_wcfm_enquiry_manage_url($wcfm_enquirys_single->ID) . '" class="wcfm_dashboard_item_title">' . $wcfm_enquirys_single->enquiry . '</a>';
				
				// Product
				if( $wcfm_enquirys_single->product_id ) {
					$wcfm_enquirys_json_arr[$index][] = '<a class="wcfm-enquiry-product" target="_blank" href="' . get_permalink($wcfm_enquirys_single->product_id) . '">' . get_the_title($wcfm_enquirys_single->product_id) . '</a>';
				} else {
					$wcfm_enquirys_json_arr[$index][] = '&ndash;';
				}
				
				// Customer
				if( apply_filters( 'wcfm_allow_order_customer_details', true ) ) {
					$wcfm_enquirys_json_arr[$index][] = apply_filters( 'wcfm_enquiry_customer_name_display', $wcfm_enquirys_single->customer_name . " " . $wcfm_enquirys_single->customer_email, $wcfm_enquirys_single->customer_id, $wcfm_enquirys_single );
				} else {
					$wcfm_enquirys_json_arr[$index][] = apply_filters( 'wcfm_enquiry_customer_name_display', $wcfm_enquirys_single->customer_name, $wcfm_enquirys_single->customer_id, $wcfm_enquirys_single );
				}
				
				
				// Vendor
				$vendor_name = '&ndash;';
				if( !$WCFM->is_marketplace || wcfm_is_vendor() ) {
					$wcfm_enquirys_json_arr[$index][] = $vendor_name;
				} elseif( $wcfm_enquirys_single->vendor_id ) {
					$store_name = $WCFM->wcfm_vendor_support->wcfm_get_vendor_store_by_vendor( $wcfm_enquirys_single->vendor_id );
					if( $store_name ) {
						$vendor_name = $store_name;
					}
					$wcfm_enquirys_json_arr[$index][] = $vendor_name;
				} else {
					$wcfm_enquirys_json_arr[$index][] = $vendor_name;
				}
				
				// Additional Info
				$additional_info = '';
				$wcfm_enquiry_meta_values = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}wcfm_enquiries_meta WHERE `enquiry_id` = " . $wcfm_enquirys_single->ID);
				if( !empty( $wcfm_enquiry_meta_values ) ) {
					foreach( $wcfm_enquiry_meta_values as $wcfm_enquiry_meta_value ) {
						$additional_info .= __( $wcfm_enquiry_meta_value->key, 'wc-frontend-manager' ) . ': ' . $wcfm_enquiry_meta_value->value . ' ';
					}
				} else {
					$additional_info = '&ndash;';
				}
				$wcfm_enquirys_json_arr[$index][] = $additional_info;
				
				// Reply
				if( $wcfm_enquirys_single->reply ) {
					$wcfm_enquirys_json_arr[$index][] = $wcfm_enquirys_single->reply;
				} else {
					$wcfm_enquirys_json_arr[$index][] = '&ndash;'; 
				}
				
				// Date
				$wcfm_enquirys_json_arr[$index][] = date_i18n( wc_date_format() . ' ' . wc_time_format(), strtotime( $wcfm_enquirys_single->posted ) );
				
				// Action
				$actions = '<a class="wcfm-action-icon" href="' . get_wcfm_enquiry_manage_url($wcfm_enquirys_single->ID) . '"></a>';
				
				if( apply_filters( 'wcfm_is_allow_eniquiry_dalate', true ) ) {
					$actions .= '<a class="wcfm_enquiry_delete wcfm-action-icon" href="#" data-enquiryid="' . $wcfm_enquirys_single->ID . '"></a>';
				}
				
				
				$wcfm_enquirys_json_arr[$index][] = apply_filters ( 'wcfm_enquiry_actions', $actions, $wcfm_enquirys_single );
				
				$index++;
			}												
		}
		if( !empty($wcfm_enquirys_json_arr) ) $wcfm_enquirys_json .= json_encode($wcfm_enquirys_json_arr);
		else $wcfm_enquirys_json .= '[]';
		$wcfm_enquirys_json .= '
													}';
													
		echo $wcfm_enquirys_json;
	}
}

[+] ..
[-] wcfm-controller-enquiry-tab.php [edit]
[-] wcfm-controller-enquiry.php [edit]
[-] wcfm-controller-enquiry-manage.php [edit]