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

PATH: home / letacommog / aacote / wp-content / plugins / dc-woocommerce-multi-vendor / classes

<?php
if (!defined('ABSPATH'))
    exit;

/**
 * @class 		WCMp Product QNA-
 *
 * @version		3.0.0
 * @package		WCMp
 * @author 		WC Marketplace
 */
class WCMp_Product_QNA {

private $question_table;
    private $answer_table;

public function __construct() {
        global $wpdb;
        $this->question_table = $wpdb->prefix.'wcmp_cust_questions';
        $this->answer_table = $wpdb->prefix.'wcmp_cust_answers';
        add_action( 'wcmp_product_qna_delete_question', array($this, 'wcmp_product_qna_delete_question'));
    }
    
    /**
     * Method to create a new question.
     *
     * @since 3.0.0
     * @param WCMp_Product_QNA question $data
     */
    public function createQuestion( $data ) {
        global $wpdb;
        $data = apply_filters( 'wcmp_product_qna_insert_question_data', $data );
        $wpdb->insert( $this->question_table, $data );
        return $wpdb->insert_id;
    }

/**
     * Update question in the database.
     *
     * @since 3.0.0
     * @param WCMp_Product_QNA question $ques_ID
     * @param WCMp_Product_QNA question $data
     */
    public function updateQuestion( $ques_ID, $data ) {
        global $wpdb;
        if ( $ques_ID ) {
            $data = apply_filters( 'wcmp_product_qna_update_question_data', $data, $ques_ID );
            return $wpdb->update( $this->question_table, $data, array( 'ques_ID' => $ques_ID ) );
        }
    }

/**
     * Delete a question from the database.
     *
     * @since  3.0.0
     * @param WCMp_Product_QNA question $ques_ID
     */
    public function deleteQuestion( $ques_ID ) {
        if ( $ques_ID ) {
            global $wpdb;
            $wpdb->delete( $this->question_table, array( 'ques_ID' => $ques_ID ) );
            do_action( 'wcmp_product_qna_delete_question', $ques_ID );
        }
    }
    
    /**
     * Delete all answers of a question from database.
     *
     * @since  3.0.4
     * @param WCMp_Product_QNA question $ques_ID
     */
    public function wcmp_product_qna_delete_question( $ques_ID ){
        if($ques_ID){
            $answers = $this->get_Answers($ques_ID);
            if($answers){
                foreach ($answers as $ans) {
                    $this->deleteAnswer($ans->ans_ID);
                }
            }
        }
    }

/**
     * Get a question.
     *
     * @since  3.0.0
     * @param  int   $ques_ID      Question ID
     * @return object               objects question
     */
    public function get_Question( $ques_ID ) {
        global $wpdb;
        $get_ques_sql = "SELECT * FROM {$this->question_table} WHERE ques_ID = %d ";
        return $wpdb->get_row( $wpdb->prepare( $get_ques_sql, $ques_ID ) );
    }

/**
     * Get a list of questions for a product.
     *
     * @since  3.0.0
     * @param  int   $product_ID      Product ID
     * @return array               Array of objects questions
     */
    public function get_Questions( $product_ID, $where = '' ) {
        global $wpdb;
        $get_ques_sql = "SELECT * FROM {$this->question_table} WHERE product_ID = %d ";
        if($where){
            $get_ques_sql .= $where;
        }   
        
        return $wpdb->get_results( $wpdb->prepare( $get_ques_sql, $product_ID ) );
    }
    
    /**
     * Get a list of questions for vendor products.
     *
     * @since  3.0.0
     * @param  object   $vendor      Vendor object
     * @return array               Array of objects questions
     */
    public function get_Vendor_Questions( $vendor, $unanswer = true ) {
        $vendor_questions = array();
        if($vendor && $vendor->get_products()){ 
            foreach ($vendor->get_products() as $product) { 
                $product_questions = $this->get_Questions($product->ID, "ORDER BY ques_created DESC");
                if($product_questions){
                    foreach ($product_questions as $question) {
                        if($unanswer){
                            $_is_answer_given = $this->get_Answers($question->ques_ID);
                            if(!$_is_answer_given){
                                $vendor_questions[$question->ques_ID] = $question;
                            }
                        }else{
                            $vendor_questions[$question->ques_ID] = $question;
                        }
                    }
                }  
            }
        }
        return $vendor_questions;
    }
    
    /**
     * Method to create a new answer.
     *
     * @since 3.0.0
     * @param WCMp_Product_QNA answer $data
     */
    public function createAnswer( $data ) {
        global $wpdb;
        $data = apply_filters( 'wcmp_product_qna_insert_answer_data', $data );
        $wpdb->insert( $this->answer_table, $data );
        return $wpdb->insert_id;
    }

/**
     * Update answer in the database.
     *
     * @since 3.0.0
     * @param WCMp_Product_QNA answer $ans_ID
     * @param WCMp_Product_QNA answer $data
     */
    public function updateAnswer( $ans_ID, $data ) {
        global $wpdb;
        if ( $ans_ID ) {
            $data = apply_filters( 'wcmp_product_qna_update_answer_data', $data, $ans_ID );
            return $wpdb->update( $this->answer_table, $data, array( 'ans_ID' => $ans_ID) );
        }
    }

/**
     * Delete a answer from the database.
     *
     * @since  3.0.0
     * @param WCMp_Product_QNA answer $ans_ID
     */
    public function deleteAnswer( $ans_ID ) {
        if ( $ans_ID ) {
            global $wpdb;
            $wpdb->delete( $this->answer_table, array( 'ans_ID' => $ans_ID ) );
            do_action( 'wcmp_product_qna_delete_answer', $ans_ID );
        }
    }
    
    /**
     * Get a answer.
     *
     * @since  3.0.0
     * @param  int   $ans_ID      Answer ID
     * @return object               objects answer
     */
    public function get_Answer( $ans_ID ) {
        global $wpdb;
        $get_ans_sql = "SELECT * FROM {$this->answer_table} WHERE ans_ID = %d ";
        return $wpdb->get_row( $wpdb->prepare( $get_ans_sql, $ans_ID ) );
    }

/**
     * Get a list of Answers.
     *
     * @since  3.0.0
     * @param  int   $ques_ID      Question ID
     * @return array               Array of objects questions
     */
    public function get_Answers( $ques_ID = 0, $where = '' ) {
        global $wpdb;
        $get_ans_sql = "SELECT * FROM {$this->answer_table}";
        if($ques_ID && $ques_ID != 0){
            $get_ans_sql .=  " WHERE ques_ID = {$ques_ID} ";
        } 
        if($where){
            $get_ans_sql .= $where;
        }   
        return $wpdb->get_results( $get_ans_sql );
    }
    
    /**
     * Get question answer list for a product.
     *
     * @since  3.0.0
     * @param  int   $product_ID      product ID
     * @return array               Array of objects questions
     */
    public function get_Product_QNA( $product_ID, $args = '' ) {
        global $wpdb;
        $default = array(
            'sortby'    => 'date',
            'sort'      => 'DESC',
            'where'     => ''
        );
        $args = wp_parse_args($args, $default);
        $get_qna_sql = "SELECT * FROM {$this->question_table} AS question INNER JOIN {$this->answer_table} AS answer ON question.ques_ID = answer.ques_ID WHERE product_ID = %d ";
        if($args['sortby'] == 'date'){
            $get_qna_sql .= "ORDER BY question.ques_created {$args['sort']} ";
        }
        if($args['where']){
            $get_qna_sql .= $args['where'];
        } 
        $product_QNAs = $wpdb->get_results( $wpdb->prepare( $get_qna_sql, $product_ID ) );
        if($args['sortby'] == 'vote' && $product_QNAs){
            $votes = array();
            foreach ($product_QNAs as $key => $qna) { 
                $count = 0;
                $ans_vote = maybe_unserialize($qna->ans_vote);
                if(is_array($ans_vote)){
                    $count = array_sum($ans_vote);
                }
                $product_QNAs[$key]->vote_count = $count;
                $votes[$key] = $count;
            }

if($args['sort']== 'ASC'){
                array_multisort($votes, SORT_ASC, $product_QNAs);
            }else{
                array_multisort($votes, SORT_DESC, $product_QNAs);
            }
            return $product_QNAs;
        }else{
            return $product_QNAs;
        }
    }

}

[+] ..
[-] class-wcmp-calculate-commission.php [edit]
[+] shipping-gateways
[+] gateways
[-] class-wcmp-ajax.php [edit]
[-] class-wcmp-cron-job.php [edit]
[-] class-wcmp-vendor-order-page.php [edit]
[-] class-wcmp-coupon.php [edit]
[+] widgets
[-] class-wcmp-vendor-dashboard.php [edit]
[-] class-wcmp-shipping-gateway.php [edit]
[-] class-wcmp-payment-gateways.php [edit]
[-] class-wcmp-email.php [edit]
[-] class-wcmp-user.php [edit]
[-] class-wcmp-shortcode.php [edit]
[-] class-wcmp-widget-init.php [edit]
[-] class-wcmp-endpoints.php [edit]
[-] class-wcmp.php [edit]
[-] class-wcmp-vendor-details.php [edit]
[-] class-wcmp-seller-review-rating.php [edit]
[-] class-wcmp-capabilities.php [edit]
[+] reports
[-] class-wcmp-post-commission.php [edit]
[+] coupons
[-] class-wcmp-post-notices.php [edit]
[+] products
[-] class-wcmp-payment-gateway.php [edit]
[-] class-wcmp-post-transaction.php [edit]
[-] class-wcmp-report.php [edit]
[-] class-wcmp-admin.php [edit]
[-] class-wcmp-product-qna.php [edit]
[+] emails
[-] class-wcmp-taxonomy.php [edit]
[-] class-wcmp-frontend.php [edit]
[-] class-wcmp-template.php [edit]
[-] class-wcmp-product.php [edit]
[-] class-wcmp-post-university.php [edit]
[-] class-wcmp-vendor-hooks.php [edit]
[-] class-wcmp-library.php [edit]
[+] shortcode