' . __("AliPrice", 'aliprice') . '

'; wp_list_categories( $args ); echo '

Try again', 'aliprice'), $request->get_error_message()); } else { $res = unserialize($request['body']); if ($res === false) $res = new WP_Error('plugins_api_failed', __('An unknown error occurred', 'aliprice'), $request['body']); } return $res; } /** * Converter currency gy google */ function aliprice_convertCurrency( $amount = 1, $from = 'USD', $to ) { $url = "https://www.google.com/finance/converter?a=" . $amount . "&from=" . $from . "&to=" . $to; $obj = new AliExpressJSONAPI2(); $data = $obj->request_data($url); if( $data === false ) return false; preg_match("/(.*)<\/span>/",$data, $converted); $converted = preg_replace("/[^0-9.]/", "", $converted[1]); $converted = round($converted, 2); return $converted; } /** * Currency Codes */ function aliprice_currency_codes( ) { $too = array( 'AUD' => __('Australian Dollar (A$)', 'aliprice'), 'BRL' => __('Brazilian Real (R$)', 'aliprice'), 'BGN' => __('Bulgarian lev (BGN)', 'aliprice'), 'CAD' => __('Canadian Dollar (CA$)', 'aliprice'), 'CHF' => __('Swiss Franc (CHF)', 'aliprice'), 'CNY' => __('Chinese Yuan (CN¥)', 'aliprice'), 'CZK' => __('Czech Republic Koruna (CZK)', 'aliprice'), 'EUR' => __('Euro (€)', 'aliprice'), 'IDR' => __('Indonesian rupiah (Rp)', 'aliprice'), 'ILS' => __('Israeli New Sheqel (₪)', 'aliprice'), 'INR' => __('Indian Rupee (₹)', 'aliprice'), 'GBP' => __('British Pound Sterling (£)', 'aliprice'), 'KZT' => __('Kazakhstani tenge (₸)', 'aliprice'), 'JPY' => __('Japanese yen (¥)', 'aliprice'), 'NGN' => __('Nigerian naira (₦)', 'aliprice'), 'NZD' => __('New Zealand dollar (NZ$)', 'aliprice'), 'NOK' => __('Norwegian Krone (NOK)', 'aliprice'), 'MYR' => __('Malaysian Ringgit (MYR)', 'aliprice'), 'PKR' => __('Pakistan Rupee (PKR)', 'aliprice'), 'MXN' => __('Peso mexicano (MXN)', 'aliprice'), 'PHP' => __('Philippine peso (₱)', 'aliprice'), 'PLN' => __('Polish Zloty (PLN)', 'aliprice'), 'RUB' => __('Russian Ruble (RUB)', 'aliprice'), 'SAR' => __('Saudi Riyal (SAR)', 'aliprice'), 'SEK' => __('Swedish Krona (SEK)', 'aliprice'), 'THB' => __('Thailand Baht (THB)', 'aliprice'), 'TWD' => __('New Taiwan Dollar(NT$)', 'aliprice'), 'KRW' => __('South Korean Won (₩)', 'aliprice'), 'AED' => __('United Arab Emirates Dirham (AED)', 'aliprice'), 'USD' => __('US Dollar ($)', 'aliprice'), 'UAH' => __('Ukrainian hryvnia (₴)', 'aliprice'), 'ZAR' => __('South African Rand (ZAR)', 'aliprice'), ); asort($too); return $too; } /** * Get current currency value */ function aliprice_get_currency( ) { $args = get_site_option('aliprice-currency'); $args = ( !$args ) ? false : unserialize($args); if( !isset($args['currency']) || !isset($args['value']) || !isset($args['enabled']) || empty($args['currency']) || empty($args['value']) || $args['enabled'] == 0 ) return false; $currency = $args['currency']; $round = empty($args['round']) ? 0 : $args['round']; $foo = aliprice_currency_codes(); if( !isset($foo[$currency]) ) return false; if ( !defined('ALIPRICE_CV') ) define( 'ALIPRICE_CV', $args['value'] ); if ( !defined('ALIPRICE_RD') ) define( 'ALIPRICE_RD', $round ); return $currency; } /** * Get currency symbol */ function aliprice_get_currency_symbol( $cur ) { $foo = array( 'AED' => array( 'symbol' => 'AED', 'pos' => 'before' ), 'AUD' => array( 'symbol' => 'A$', 'pos' => 'before' ), 'BGN' => array( 'symbol' => 'BGN', 'pos' =>'after'), 'BRL' => array( 'symbol' => 'R$', 'pos' => 'before' ), 'CAD' => array( 'symbol' => 'CA$', 'pos' => 'before' ), 'CHF' => array( 'symbol' => 'CHF', 'pos' => 'after' ), 'CNY' => array( 'symbol' => '¥', 'pos' => 'after' ), 'CZK' => array( 'symbol' => 'Kč', 'pos' => 'after' ), 'EUR' => array( 'symbol' => '€', 'pos' => 'after' ), 'MXN' => array( 'symbol' => 'MXN', 'pos' => 'after' ), 'IDR' => array( 'symbol' => 'Rp', 'pos' => 'after' ), 'ILS' => array( 'symbol' => '₪', 'pos' => 'after' ), 'INR' => array( 'symbol' => '₹', 'pos' => 'after' ), 'JPY' => array( 'symbol' => '¥', 'pos' => 'before' ), 'GBP' => array( 'symbol' => '£', 'pos' => 'before' ), 'KZT' => array( 'symbol' => '₸', 'pos' => 'before' ), 'NGN' => array( 'symbol' => '₦', 'pos' => 'after' ), 'NZD' => array( 'symbol' => 'NZ$', 'pos' => 'after' ), 'NOK' => array( 'symbol' => 'kr', 'pos' => 'after' ), 'MYR' => array( 'symbol' => 'RM', 'pos' => 'before' ), 'PKR' => array( 'symbol' => '₨', 'pos' => 'before' ), 'PHP' => array( 'symbol' => '₱', 'pos' => 'before' ), 'PLN' => array( 'symbol' => 'zl', 'pos' => 'after' ), 'RUB' => array( 'symbol' => 'руб.', 'pos' => 'after' ), 'SAR' => array( 'symbol' => 'SR', 'pos' => 'after' ), 'SEK' => array( 'symbol' => 'SEK', 'pos' => 'after' ), 'THB' => array( 'symbol' => '฿', 'pos' => 'after' ), 'TWD' => array( 'symbol' => 'NT$', 'pos' => 'after' ), 'KRW' => array( 'symbol' => '₩', 'pos' => 'before' ), 'USD' => array( 'symbol' => '$', 'pos' => 'before' ), 'UAH' => array( 'symbol' => '₴', 'pos' => 'before' ), 'ZAR' => array( 'symbol' => 'R', 'pos' => 'before' ), ); if( isset($foo[$cur]) ) return $foo[$cur]; return $cur; } /** * Convert currency */ function aliprice_get_price( $price, $output = true ) { if( !ALIPRICE_CUR ) return $price; $foo = aliprice_get_currency_symbol( ALIPRICE_CUR ); if( !is_array($foo) ) return $price; $price = preg_replace("/[^0-9,.]/", "", $price); $price = aliprice_floatvalue($price); $to = (ALIPRICE_RD == 1) ? 0 : 2; $price = round( $price*ALIPRICE_CV, $to ); $price = aliprice_floatvalue($price); if( $output ) return ( $foo['pos'] == 'before' ) ? $foo['symbol'] . " " . $price : $price . ' ' . $foo['symbol']; return $price; } /** * Default price */ function aliprice_get_default_price( $price, $symbol = true ) { if( !ALIPRICE_CUR ) return $price; $foo = aliprice_get_currency_symbol( ALIPRICE_CUR ); if( !is_array($foo) ) return $price; $price = preg_replace("/[^0-9,.]/", "", $price); $price = aliprice_floatvalue($price); $to = (ALIPRICE_RD == 1) ? 0 : 2; $price = round( $price/ALIPRICE_CV, $to ); if( $symbol ) return ( $foo['pos'] == 'before' ) ? $foo['symbol'] . " " . $price : $price . ' ' . $foo['symbol']; else return $price; } /** * Set max price */ function aliprice_set_max_price( ) { global $wpdb; $var = $wpdb->get_var("SELECT MAX( CAST( SUBSTRING_INDEX(`price`, '$', -1) AS DECIMAL(10, 2) ) ) FROM `{$wpdb->prefix}aliprice_products`"); if( !empty($var) ) update_site_option( 'aliprice-max-price', $var ); } /** * List languages * @return bool */ function aliprice_list_lang() { return array( 'en' => __('English', 'aliprice'), 'ar' => __('Arabic', 'aliprice'), 'de' => __('German', 'aliprice'), 'es' => __('Spanish', 'aliprice'), 'fr' => __('French', 'aliprice'), 'it' => __('Italian', 'aliprice'), 'id' => __('Bahasa Indonesia', 'aliprice'), 'ja' => __('Japanese', 'aliprice'), 'ko' => __('Korean', 'aliprice'), 'nl' => __('Dutch', 'aliprice'), 'pt' => __('Portuguese (Brasil)', 'aliprice'), 'pl' => __('Polish', 'aliprice'), 'ru' => __('Russian', 'aliprice'), 'th' => __('Thai', 'aliprice'), 'tr' => __('Turkish', 'aliprice'), 'vi' => __('Vietnamese', 'aliprice'), 'he' => __('Hebrew', 'aliprice') ); } /** * Get current language * @return bool|mixed|string */ function aliprice_get_lang( ) { $foo = aliprice_list_lang(); $lang = get_site_option('aliprice-language'); $lang = ( $lang && isset($foo[$lang]) ) ? $lang : 'en'; if( $lang == 'en' ) return 'en'; return $lang; } /** * Get picture by post or page * @param $post_id * @param string $size * @return mixed */ function aliprice_get_thumb( $post_id, $size = 'thumbnail' ) { if( !has_post_thumbnail($post_id) ) { $args = array( 'post_type' => 'attachment', 'numberposts' => 1, 'post_status' => null, 'post_parent' => $post_id ); $attachments = get_posts( $args ); if ( $attachments ) { $img = wp_get_attachment_image_src( $attachments[0]->ID, $size, false ); return $img[0]; } } else { $thumb_id = get_post_thumbnail_id( $post_id ); $url = wp_get_attachment_image_src( $thumb_id, $size ); return $url[0]; } } /** * @param $text * @return mixed|string|void */ function aliprice_get_post_excerpt( $text ) { $text = strip_shortcodes( $text ); $text = apply_filters( 'the_content', $text ); $text = str_replace( ']]>', ']]>', $text ); $excerpt_length = apply_filters( 'excerpt_length', 55 ); $text = wp_trim_words( $text, $excerpt_length, ' ...' ); return $text; } /** * Get image from product * @param $original * @param string $size * @return bool|string * @todo допилить проверку на наличие у записи миниатюры, если нет, юрать ту что у али */ function aliprice_get_thumb_ali( $original, $size = '') { if( $original == '' ) return false; return aliprice_get_size_img( $original, $size ); } /** * List Image Size * @param $url * @param string $size * @return string */ function aliprice_get_size_img( $url, $size = 'medium' ) { $foo = array( 'thumb' => '_50x50.jpg', 'medium' => '_220x220.jpg', 'large' => '_350x350.jpg' ); if( !isset( $foo[$size] ) ) return $url; return $url . $foo[$size]; } /** * Count Products by All Products * @return int */ function aliprice_total_count_products( ) { global $wpdb; $var = $wpdb->get_var( "SELECT count(`id`) as `con` FROM `{$wpdb->products}` WHERE `post_id` <> 0" ); return empty($var) ? 0 : $var; } /** * Count Reviews by All Products * @return int */ function aliprice_total_count_reviews( ) { global $wpdb; $var = $wpdb->get_var( "SELECT sum(`countReview`) as `con` FROM `{$wpdb->products}`" ); return empty($var) ? 0 : $var; } /** * Get list Reviews by ID * * @param $post_id * @return bool|mixed */ function aliprice_Review( $post_id ) { require_once( dirname(__FILE__) . '/class.AliExpress.Review.php' ); $obj = new Review(); return $obj->listReviews( $post_id ); } /** * Get reviews star * * @param $post_id * @return bool|mixed */ function aliprice_getStat( $arrayOfObjs ) { $stat = array( 'positive' => 0, 'neutral' => 0, 'negative' => 0, 'stars' => array( '1' => array('count' => 0, 'percent' => 0 ), '2' => array('count' => 0, 'percent' => 0 ), '3' => array('count' => 0, 'percent' => 0 ), '4' => array('count' => 0, 'percent' => 0 ), '5' => array('count' => 0, 'percent' => 0 ), ) ); if( !$arrayOfObjs || empty($arrayOfObjs) ) return $stat; $count = 0; foreach( $arrayOfObjs as $review ){ if((int)$review->star > 0){ $stat['stars'][(int)$review->star]['count']++; $count++; } } foreach($stat['stars'] as $key => $value) $stat['stars'][$key]['percent'] = round( $value['count'] / $count * 100, 1); $stat['positive'] = round( ($stat['stars'][4]['percent'] + $stat['stars'][5]['percent']), 1); $stat['neutral'] = round( ($stat['stars'][3]['percent']), 1); $stat['negative'] = round( ($stat['stars'][1]['percent'] + $stat['stars'][2]['percent']), 1); return $stat; } function aliprice_averageStar( $arrayOfObjs ) { if( !$arrayOfObjs || empty($arrayOfObjs) ) return array(0,0); $star = array(); $count= 0; foreach( $arrayOfObjs as $review ){ if($review->star > 0){ $star[]= $review->star; $count++; } } $average = round( array_sum($star)/$count , 1); return array($average, $count); } function aliprice_renderStarRating( $rating ) { $full_stars = floor( $rating ); $half_stars = ceil( $rating - $full_stars ); $empty_stars = 5 - $full_stars - $half_stars; echo str_repeat( '', $full_stars ); echo str_repeat( '', $half_stars ); echo str_repeat( '', $empty_stars); } /* Sheduled Review */ function aliprice_schedule_review( $pos, $count, $count_settings, $star) { global $wpdb; $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `{$wpdb->products}` WHERE `post_id` <> 0 LIMIT %d, %d", $pos, $count) ); if( !$results ) { return false; } require_once( dirname( __FILE__ ) . '/class.AliExpress.Review.php' ); include_once __DIR__ . '/../libs/translate/GoogleTranslate.php'; require_once( dirname( __FILE__ ) . '/request.php' ); foreach( $results as $row ) { aliprice_set_review_by_product( $row, $count_settings, $star ); } } function aliprice_set_review_by_product( $row, $count_settings, $star ) { global $wpdb; $translate = new GoogleTranslate(); $translate->setFromLang('')->setToLang(ALIPRICE_LANG); $obj = new Review($row->productId); $obj->setNewParams(); $obj->setPage(1); $data = $obj->getReviews(); if( !$data ) { return false; } foreach( $data as $key => $val ) { if( !aliprice_check_exists_review( $row->post_id, $val ) && $val['star'] >= $star ) { $feedback = !empty($val['feedback']) ? $translate->translate($val['feedback']) : ''; $wpdb->insert( $wpdb->review, array( 'post_id' => $row->post_id, 'name' => $val['name'], 'feedback' => $feedback, 'date' => $val['date'], 'flag' => $val['flag'], 'star' => $val['star'] ), array( '%d', '%s', '%s', '%s', '%s', '%f' ) ); } $result = $wpdb->get_results($wpdb->prepare("SELECT count(`id`) as `con` FROM `{$wpdb->review}` WHERE `post_id`=%d", $row->post_id)); $result = current($result); $current_count = $result->con; if( $current_count > $count_settings){ $count_settings_corrective = $current_count - $count_settings; $wpdb->get_results($wpdb->prepare("DELETE FROM `{$wpdb->review}` WHERE `post_id`=%d ORDER BY `id` ASC LIMIT %d", $row->post_id, $count_settings_corrective)); } } } /** * Validate is URL * @param $url * @return int */ function aliprice_is_url($url) { return preg_match('|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i', $url); }