0';
else
echo '' . $result['result'] . '';
die();
}
/**
* get quantity goods by filter param in category
*/
add_action( 'wp_ajax_aliprice_total_goods_in_cat', 'aliprice_get_total_goods' );
function aliprice_get_total_goods( ) {
$result = aliprice_get_total_by_filter( );
if( isset($result['error']) ) {
?>
getTotalByCategory(
$category_id_for_request,
array(
'keywords' => sanitize_text_field($keywords),
'originalPriceFrom' => aliprice_floatvalue($priceFrom),
'originalPriceTo' => aliprice_floatvalue($priceTo),
'volumeFrom' => intval($promotionFrom),
'volumeTo' => intval($promotionTo),
'startCreditScore' => intval($creditScoreFrom),
'endCreditScore' => intval($creditScoreTo),
'ourcat' => sanitize_text_field($ourcat),
'status' => sanitize_text_field($status)
)
);
return $result;
}
/**
* Selective import
*/
add_action( 'wp_ajax_aliprice_advanced_show', 'aliprice_advanced_show' );
function aliprice_advanced_show( ) {
$categoryId = intval($_POST['categoryId']);
$keywords = sanitize_text_field($_POST['keywords']);
$priceFrom = intval($_POST['priceFrom']);
$priceTo = intval($_POST['priceTo']);
$promotionFrom = intval($_POST['promotionFrom']);
$promotionTo = intval($_POST['promotionTo']);
$creditScoreFrom = intval($_POST['creditScoreFrom']);
$creditScoreTo = intval($_POST['creditScoreTo']);
$page_no = intval($_POST['page_no']);
$sort = sanitize_text_field($_POST['sort']);
$result = array();
$obj = new AliExpressInsert();
$search = $obj->searchByCategory(
$categoryId,
$page_no,
array(
'keywords' => sanitize_text_field($keywords),
'originalPriceFrom' => aliprice_floatvalue($priceFrom),
'originalPriceTo' => aliprice_floatvalue($priceTo),
'volumeFrom' => intval($promotionFrom),
'volumeTo' => intval($promotionTo),
'startCreditScore' => intval($creditScoreFrom),
'endCreditScore' => intval($creditScoreTo),
'sort' => sanitize_text_field($sort)
)
);
if( isset($search['error']) ) {
$result['error'] = '' . $search['error'] . '
';
$result['before'] = '';
echo json_encode($result);
die();
}
$total = isset( $search['result']['totalResults'] ) ? $search['result']['totalResults'] : 0;
$result['title'] = __('Select Products to Import', 'aliprice');
$result['before'] = '';
$result['total'] = '' . __("Total number of Products available for importing", 'aliprice') . ':
' . $total . '
' . __('You can upload not more than 10,000 Products at once.', 'aliprice') . '
' . $search['error'] . '
';
$result['before'] = '';
echo json_encode($result);
die();
}
$result['totalResults'] = isset( $search['result'] ) ? count($search['result']) : 0;
$result['title'] = __('Select Products to Import', 'aliprice');
$result['before'] = '';
$result['total'] = '' . __("Total number of Products available for importing", 'aliprice') . ': ' . $result['totalResults'] . '
';
$result['header'] = array(
'',
__("Thumbnail", 'aliprice'),
__("Title", 'aliprice'),
__("Unit Price", 'aliprice'),
__("Rate", 'aliprice') .
' ',
__("Commission", 'aliprice') .
' ',
__("Volume", 'aliprice') .
' ',
__("Rating", 'aliprice') .
' '
);
$result['info'] = '';
$result['result'] = $search['result'];
echo json_encode( $result );
die();
}
/**
* Get count of products
*/
add_action( 'wp_ajax_aliprice_count_products', 'aliprice_count_products' );
function aliprice_count_products( ) {
global $wpdb;
$count = $wpdb->get_var("SELECT count(`id`) as `con` FROM `{$wpdb->prefix}aliprice_products` WHERE `post_id` <> 0");
echo intval($count);
die();
}
/**
* Update products one by one
*/
add_action( 'wp_ajax_aliprice_update_products', 'aliprice_update_products' );
function aliprice_update_products( ) {
global $wpdb;
$from = abs( intval($_POST['position']) ) * 20 - 20;
$delete = get_site_option('aliprice-delete');
$insert = new AliExpressInsert();
$pub = new AliExpressPublish();
$result = $insert->updateLinks( $from, 20 );
if( !$result ) { echo 0; die(); }
if( count($result) > 0 ) {
print_r($result);
foreach($result as $key => $val){
$pub->setId( $key );
$post = $pub->getDetails();
if( !empty($post) ) {
if( $delete == 1 ) {
wp_delete_post( $post->post_id, true );
$wpdb->delete( $wpdb->prefix . "aliprice_products", array( 'post_id' => $post->post_id ), array( '%d' ) );
print_r( " Delete product ID: " . $post->post_id );
}
else{
$wpdb->update(
$wpdb->prefix . "aliprice_products",
array( 'availability' => 0 ),
array( 'post_id' => $post->post_id ),
array( '%d' ),
array( '%d' )
);
}
}
}
die();
}
echo $_POST['position'];
die();
}
/**
* For Review
*/
add_action( 'wp_ajax_aliprice_review_show', 'aliprice_review_show' );
function aliprice_review_show( ) {
$categoryId = intval($_POST['categoryId']);
$keywords = sanitize_text_field($_POST['keywords']);
$priceFrom = intval($_POST['priceFrom']);
$priceTo = intval($_POST['priceTo']);
$promotionFrom = intval($_POST['promotionFrom']);
$promotionTo = intval($_POST['promotionTo']);
$creditScoreFrom = intval($_POST['creditScoreFrom']);
$creditScoreTo = intval($_POST['creditScoreTo']);
$page_no = intval($_POST['page_no']);
$result = array();
$obj = new AliExpressInsert();
$search = $obj->searchByCategory(
$categoryId,
$page_no,
array(
'keywords' => sanitize_text_field($keywords),
'originalPriceFrom' => aliprice_floatvalue($priceFrom),
'originalPriceTo' => aliprice_floatvalue($priceTo),
'volumeFrom' => intval($promotionFrom),
'volumeTo' => intval($promotionTo),
'startCreditScore' => intval($creditScoreFrom),
'endCreditScore' => intval($creditScoreTo)
)
);
if( isset($search['error']) ) {
$result['error'] = '' . $search['error'] . '
';
$result['before'] = '';
echo json_encode($result);
die();
}
$total = isset( $search['result']->totalResults ) ? $search['result']->totalResults : 0;
$result['before'] = '' . __('Total number of Products available for importing', 'aliprice') . ' ' . $total . '
';
$result['header'] = array(
__("Thumbnail", 'aliprice'),
__("Title", 'aliprice'),
__("Unit Price", 'aliprice'),
__("Rate", 'aliprice') .
' ',
__("Commission", 'aliprice') .
' ',
__("Volume", 'aliprice') .
' ',
__("Rating", 'aliprice') .
' '
);
$result['info'] = '' . __('Successfully imported', 'aliprice') . ': 0 ' . __('Could not be imported', 'aliprice') . ': 0
';
$result['result'] = $search['result'];
echo json_encode( $result );
die();
}
/**
* Bulk import
*/
add_action( 'wp_ajax_aliprice_bulk_import_step1', 'aliprice_bulk_import_step1' );
function aliprice_bulk_import_step1( ) {
$categoryId = intval($_POST['categoryId']);
$ourcat = isset($_POST['ourcat']) ? $_POST['ourcat']: '';
$status = sanitize_text_field($_POST['status']);
$keywords = sanitize_text_field($_POST['keywords']);
$priceFrom = intval($_POST['priceFrom']);
$priceTo = intval($_POST['priceTo']);
$promotionFrom = intval($_POST['promotionFrom']);
$promotionTo = intval($_POST['promotionTo']);
$creditScoreFrom = intval($_POST['creditScoreFrom']);
$creditScoreTo = intval($_POST['creditScoreTo']);
$page_no = intval($_POST['page_no']);
$size = sanitize_text_field($_POST['size']);
$unitType = (isset($_POST['unitType']) &&
in_array($_POST['unitType'], array('piece', 'lot'))
) ? $_POST['unitType'] : '';
$cc = absint($_POST['cc']);
$fs = absint($_POST['fs']);
$fs = ($fs == 1) ? true : false;
$result = array();
$pos = ceil($size/$cc);
$limit = $now = $size - $page_no * $cc;
if( $now < 0 )
$now = $cc - ($page_no * $cc - $size);
elseif( $now == 0 && $pos > $cc ) {
$result['end'] = '1';
echo json_encode($result);
die();
}
$obj = new AliExpressInsert();
$obj->set_frees($fs);
$obj->set_unit_type($unitType);
$search = $obj->searchByCategory(
$categoryId,
$page_no,
array(
'keywords' => sanitize_text_field($keywords),
'originalPriceFrom' => aliprice_floatvalue($priceFrom),
'originalPriceTo' => aliprice_floatvalue($priceTo),
'volumeFrom' => intval($promotionFrom),
'volumeTo' => intval($promotionTo),
'startCreditScore' => intval($creditScoreFrom),
'endCreditScore' => intval($creditScoreTo)
),
$cc
);
if( isset($search['error']) ) {
$result['error'] = 'Error: Page ' . $page_no . ' Category: ' . $categoryId . ' Message: ' . $search['error'];
$result['fail'] = $now;
$result['success'] = 0;
echo json_encode($result);
die();
}
$i = $fail = $success = 0;
$arguments = $search['result']->products;
$ddd = array();
foreach( $arguments as $data ) {
$i++;
if( $limit < 0 && $i > $now ) continue;
$args['lotNum'] = intval( $data->lotNum );
$args['packageType'] = sanitize_text_field( $data->packageType );
$args['imageUrl'] = sanitize_text_field( $data->imageUrl );
$args['productId'] = intval( $data->productId );
$args['price'] = sanitize_text_field( $data->originalPrice );
$args['validTime'] = aliprice_dbdate( $data->validTime );
$args['subject'] = sanitize_text_field( $data->productTitle );
$args['productUrl'] = sanitize_text_field( $data->productUrl );
$args['promotionVolume'] = intval( $data->volume );
$args['evaluateScore'] = sanitize_text_field( $data->evaluateScore );
$args['salePrice'] = sanitize_text_field( $data->salePrice );
$obj->insertOneItem( intval( $categoryId ), $args);
$details = $obj->getDetailById( $args['productId'] );
if( !$details || isset($details['error']) ){
$fail++;
}
else {
$pub = new AliExpressPublish($args['productId'], $ourcat, $status);
$published = $pub->Published();
if (!$published)
$fail++;
elseif (is_array($published) && isset($published['error']))
$fail++;
else
$success++;
}
}
$result = array( 'fail' => $fail, 'success' => $success );
echo json_encode( $result );
die();
}
/* publlish products */
add_action('wp_ajax_aliprice_publish_product', 'aliprice_publish_product');
function aliprice_publish_product( ) {
$args = array();
$category_id = intval( $_POST['categoryAE'] );
$args['lotNum'] = intval( $_POST['lotNum'] );
$args['packageType'] = sanitize_text_field( $_POST['packageType'] );
$args['imageUrl'] = sanitize_text_field( $_POST['imageUrl'] );
$args['productId'] = floatval( $_POST['productId'] );
$args['price'] = sanitize_text_field( $_POST['price'] );
$args['validTime'] = aliprice_dbdate( $_POST['actualTime'] );
$args['subject'] = sanitize_text_field( $_POST['subject'] );
$args['productUrl'] = sanitize_text_field( $_POST['productUrl'] );
$args['promotionVolume'] = intval( $_POST['promotionVolume'] );
$args['evaluateScore'] = sanitize_text_field( $_POST['evaluateScore'] );
$args['salePrice'] = sanitize_text_field( $_POST['salePrice'] );
$owncat = isset($_POST['owncat']) ? sanitize_text_field($_POST['owncat']) : '';
$args['owncat'] = sanitize_text_field($owncat);
$status = isset($_POST['status']) ? sanitize_text_field($_POST['status']) : 'draft';
$obj = new AliExpressInsert();
$obj->insertOneItem( $category_id, $args );
$details = $obj->getDetailById( $args['productId'] );
if( !$details || isset($details['error']) ){
echo json_encode( array('error' => __('Publish failed', 'aliprice')) );
die();
}
$pub = new AliExpressPublish( $args['productId'], $owncat, $status);
$result = $pub->Published( );
if( !$result )
echo json_encode( array('error' => __('Publish failed', 'aliprice')) );
elseif( is_array($result) && isset($result['error']) )
echo json_encode( array('error' => $result['error']) );
else
echo json_encode( array( 'success' => __('Publish success', 'aliprice'), 'post_id' => $result['id'],'url' => get_permalink($result['id'])) );
die();
}
/* publlish products by ID*/
add_action('wp_ajax_aliprice_publish_product_id', 'aliprice_publish_product_id');
function aliprice_publish_product_id( ) {
$args = array();
$args['lotNum'] = intval( $_POST['lotNum'] );
$args['packageType'] = sanitize_text_field( $_POST['packageType'] );
$args['imageUrl'] = sanitize_text_field( $_POST['imageUrl'] );
$args['productId'] = intval( $_POST['productId'] );
$args['price'] = sanitize_text_field( $_POST['price'] );
$args['validTime'] = aliprice_dbdate( $_POST['actualTime'] );
$args['subject'] = sanitize_text_field( $_POST['subject'] );
$args['productUrl'] = sanitize_text_field( $_POST['productUrl'] );
$args['promotionVolume'] = intval( $_POST['promotionVolume'] );
$args['evaluateScore'] = sanitize_text_field( $_POST['evaluateScore'] );
$args['salePrice'] = sanitize_text_field( $_POST['salePrice'] );
$args['owncat'] = isset($_POST['owncat']) ? sanitize_text_field($_POST['owncat']) : '';
$status = isset($_POST['status']) ? sanitize_text_field($_POST['status']) : 'draft';
$obj = new AliExpressInsert();
$obj->insertOneItemIds( $args );
$details = $obj->getDetailById( $args['productId'] );
if( !$details || isset($details['error']) ){
echo json_encode( array('error' => __('Publish failed', 'aliprice')) );
die();
}
$pub = new AliExpressPublish( $args['productId'], $args['owncat'], $status );
$result = $pub->Published( true );
if( !$result )
echo json_encode( array('error' => __('Publish failed', 'aliprice')) );
elseif( is_array($result) && isset($result['error']) )
echo json_encode( array('error' => $result['error']) );
else
echo json_encode(
array(
'success' => __('Publish success', 'aliprice'),
'post_id' => $result['id'],
'url' => get_permalink($result['id'])
)
);
die();
}
/**
* get permalink and short code
*/
add_action('wp_ajax_aliprice_permalink_import', 'aliprice_ajax_get_permalink');
function aliprice_ajax_get_permalink( ) {
$products = $_POST['products'];
if( count($products) == 0 ){
echo json_encode( array('not' => '') );
die();
}
$obj = new AliExpressPublish();
$foo = array();
foreach( $products as $product_id ) {
$obj->setId( $product_id );
$details = $obj->getDetails();
if( !empty($details) && !empty($details->post_id) )
$foo[] = array( 'id' => $product_id, 'url' => get_permalink($details->post_id), 'productUrl' => $details->productUrl, 'post_id' => $details->post_id );
}
if( count($foo) > 0 )
echo json_encode( $foo );
else
echo json_encode( array('not' => '') );
die();
}
add_action('wp_ajax_aliprice_review_form', 'aliprice_review_form');
function aliprice_review_form( ) {
include( dirname( __FILE__ ) . '/tmpl.review.php' );
die();
}
//restore english content
add_action('wp_ajax_aliprice_get_description', 'aliprice_get_description');
function aliprice_get_description(){
if( !isset($_POST['post_id']) || empty($_POST['post_id']) ){
echo 0;
die();
}
$obj = new AEProducts();
$obj->set( intval($_POST['post_id']) );
$content = $obj->getDescription();
$title = $obj->getTitle();
if( !$content || !$title ) {
echo 0;
die();
}
$foo = array( 'content' => aliprice_clean_html_style($content), 'title' => $title );
echo json_encode($foo);
die();
}
/**
* Show the Categories at dropdown menu
*/
add_action('wp_ajax_aliprice_get_dropdowncat', 'aliprice_get_dropdowncat');
function aliprice_get_dropdowncat( ) {
$obj = new AliExpressSettings();
$obj->tmplDropDownCat();
die();
}
/**
* Get promotion links
*/
add_action('wp_ajax_aliprice_get_promotion', 'aliprice_get_promotion_link');
function aliprice_get_promotion_link( ) {
if( !isset($_POST['link']) || empty($_POST['link']) ) {
echo json_encode( array('error' => __('Wrong Request!', 'aliprice')) );
die();
}
$obj = new AliExpressInsert();
try {
$urls = $obj->getPromotionLinks( array($_POST['link']) );
}
catch( Exception $e ) {
echo json_encode( array( 'error' => __('Link', 'aliprice') . ': ' . $e->getMessage() ) );
die();
}
if( is_array($urls) && isset($urls['notfound']) ) {
echo json_encode( array( 'error' => $urls['notfound'] ) );
die();
}
$urls = $urls->promotionUrls;
if( !isset($urls[0]) ) {
echo json_encode( array( 'error' => $urls['notfound'] ) );
die();
}
echo json_encode( array( 'success' => $urls[0]->promotionUrl ) );
die();
}
/**
* Set max price
*/
add_action('wp_ajax_aliprice_set_max_price', 'aliprice_set_max_price');
/**
* Test Connection
*/
add_action('wp_ajax_aliprice_test_connection', 'aliprice_test_connection');
function aliprice_test_connection( ) {
$obj = new AliExpressInsert();
$obj->test_connection();
die();
}
/**
*
*/
add_action('wp_ajax_aliprice_get_terms_id', 'aliprice_get_terms_id');
function aliprice_get_terms_id( ) {
$foo = array();
if( !current_user_can( 'activate_plugins' ) ){ echo json_encode($foo); die(); }
$terms = get_terms( 'shopcategory', array('orderby' => 'count', 'hide_empty' => 0) );
if ( !empty( $terms ) && !is_wp_error( $terms ) )
foreach ( $terms as $term )
$foo[] = $term->term_id;
echo json_encode($foo);
global $wpdb;
$wpdb->query("TRUNCATE TABLE `{$wpdb->prefix}aliprice_products`");
$wpdb->query("DELETE FROM `{$wpdb->options}` WHERE `option_name` like 'term_child-%' OR `option_name` like 'term_parent-%'");
die();
}
/**
* Delete products and categories
*/
add_action('wp_ajax_aliprice_delete_products_from_terms', 'aliprice_delete_products_from_terms');
function aliprice_delete_products_from_terms( ) {
global $wpdb;
if( !current_user_can( 'activate_plugins' ) ){ echo "0"; die(); }
if( !isset($_POST['term_id']) || empty($_POST['term_id']) ){ echo "0"; die(); }
$term_id = intval($_POST['term_id']);
$wpdb->query(
$wpdb->prepare(
"DELETE a,b,c,d
FROM `{$wpdb->prefix}posts` `a`
LEFT JOIN `{$wpdb->prefix}term_relationships` `b` ON ( `a`.`ID` = `b`.`object_id` )
LEFT JOIN `{$wpdb->prefix}postmeta` c ON ( `a`.`ID` = `c`.`post_id` )
LEFT JOIN `{$wpdb->prefix}term_taxonomy` `d` ON ( `d`.`term_taxonomy_id` = `b`.`term_taxonomy_id` )
LEFT JOIN `{$wpdb->prefix}terms` `e` ON ( `e`.`term_id` = `d`.`term_id` )
WHERE
`e`.`term_id` = '%d' AND
`a`.`post_type` = 'products'", $term_id
)
);
echo $term_id;
wp_delete_term( $term_id, 'shopcategory' );
die();
}
add_action('wp_ajax_aliprice_delete_products_remaining', 'aliprice_delete_products_remaining');
function aliprice_delete_products_remaining(){
global $wpdb;
if( !current_user_can( 'activate_plugins' ) ){ echo "0"; die(); }
$wpdb->query(
"DELETE p, pm, tr
FROM `{$wpdb->prefix}posts` `p`
JOIN `{$wpdb->prefix}term_relationships` `tr` ON ( `p`.`ID` = `tr`.`object_id` )
JOIN `{$wpdb->prefix}postmeta` `pm` ON ( `p`.`ID` = `pm`.`post_id` )
WHERE p.post_type = 'products'"
);
$wpdb->query(
"DELETE p, pm
FROM `{$wpdb->prefix}posts` `p`
JOIN `{$wpdb->prefix}postmeta` `pm` ON ( `p`.`ID` = `pm`.`post_id` )
WHERE p.post_type = 'products'"
);
$wpdb->query( "DELETE p FROM `{$wpdb->posts}` `p` WHERE p.post_type = 'products'" );
$wpdb->query(
"DELETE p FROM `{$wpdb->prefix}options` `p`
WHERE p.option_name LIKE 'aliprice_original_title_%' OR
p.option_name LIKE 'term_parent-%' OR
p.option_name LIKE 'term_child-%'"
);
$wpdb->query("TRUNCATE TABLE `{$wpdb->review}`");
die();
}
add_action('wp_ajax_aliprice_get_translate', 'aliprice_get_translate');
function aliprice_get_translate( ) {
$foo = array(
'bulk_count' => __("You did not indicate how many imported products", 'aliprice'),
'bulk_size' => __("You specified a value greater than can be import", 'aliprice'),
'pId' => __("Product ID", 'aliprice'),
'imNow' => __("Import Now", 'aliprice'),
'sAgain' => __("Search Again", 'aliprice'),
'progress' => __("Overall Progress", 'aliprice'),
'link' => __("Get link", 'aliprice'),
'preview' => __("Preview", 'aliprice'),
'prev' => __("Prev", 'aliprice'),
'next' => __("Next", 'aliprice'),
'notfound' => __("This product does not participate in the Affiliate Program", 'aliprice'),
'del' => __("Are you sure you want to delete all products?", 'aliprice')
);
echo json_encode( $foo );
die();
}
add_action('wp_ajax_aliprice_translate_item', 'aliprice_translate_item');
function aliprice_translate_item( ) {
if( !current_user_can( 'activate_plugins' ) ){ echo "0"; die(); }
$type = sanitize_text_field($_POST['type']);
$id = intval($_POST['item_id']);
$action = false;
$lang = sanitize_text_field($_POST['lang']);
if( $type == 'page' ) {
$title = get_the_title($id);
if( !empty($title) ) {
$orig = get_post_meta($id, 'aliprice_original_title', true);
if( empty($orig) ) {
update_post_meta($id, 'aliprice_original_title', $title);
$orig = $title;
}
$action = true;
}
}
elseif( $type == 'taxonomy' ) {
$term = get_term_by('id', $id, 'shopcategory');
if( $term ) {
$title = $term->name;
$orig = get_site_option('aliprice_original_title_' . $id);
if( !$orig ) {
update_site_option('aliprice_original_title_' . $id, $title);
$orig = $title;
}
$action = true;
}
}
if( !$action ) {
$foo = array('message' => $id . " " . __('Item not found', 'aliprice'));
}
else {
include_once __DIR__ . '/../libs/translate/GoogleTranslate.php';
$tr = new GoogleTranslate();
$tr->setFromLang($lang)->setToLang(ALIPRICE_LANG);
$translated = $tr->translate($title);
if( $tr->isError() )
$foo = $tr->getError();
else {
$foo = array('title' => $translated, 'o_title' => $orig);
if( $type == 'page' )
wp_update_post( array( 'ID' => $id, 'post_title' => $translated ) );
elseif( $type == 'taxonomy' )
wp_update_term( $id, 'shopcategory', array('name' => $translated ) );
}
}
echo json_encode( $foo );
die();
}
add_action('wp_ajax_aliprice_repair_translate_item', 'aliprice_repair_translate_item');
function aliprice_repair_translate_item( ) {
if (!current_user_can('activate_plugins')) {
echo "0";
die();
}
$type = sanitize_text_field($_POST['type']);
$id = intval($_POST['item_id']);
$action = false;
if( $type == 'page' ) {
$orig = get_post_meta($id, 'aliprice_original_title', true);
if( empty($orig) ) {
$title = get_the_title($id);
if( !empty($title) ) {
update_post_meta($id, 'aliprice_original_title', $title);
$orig = $title;
$action = true;
}
}
else {
wp_update_post( array( 'ID' => $id, 'post_title' => $orig ) );
$title = $orig;
$action = true;
}
}
elseif( $type == 'taxonomy' ) {
$orig = get_site_option('aliprice_original_title_' . $id);
if( !$orig ) {
$term = get_term_by('id', $id, 'shopcategory');
if( $term ) {
$title = $term->name;
update_site_option('aliprice_original_title_' . $id, $title);
$orig = $title;
$action = true;
}
}
else{
wp_update_term( $id, 'shopcategory', array('name' => $orig ) );
$title = $orig;
$action = true;
}
}
if( !$action )
$foo = array('message' => $id . " " . __('Item not found', 'aliprice'));
else
$foo = array('title' => $title, 'o_title' => $orig);
echo json_encode( $foo );
die();
}
add_action('wp_ajax_aliprice_save_new_title_item', 'aliprice_save_new_title_item');
function aliprice_save_new_title_item( ) {
if (!current_user_can('activate_plugins')) {
echo "0";
die();
}
$type = sanitize_text_field($_POST['type']);
$id = intval($_POST['item_id']);
$title = sanitize_text_field($_POST['title']);
$action = false;
if( $type == 'page' ) {
if( !empty($title) ) {
wp_update_post( array( 'ID' => $id, 'post_title' => $title ) );
$foo = array('success' => 'Page with ' . $id . ' updated');
$action = true;
}
}
elseif( $type == 'taxonomy' ) {
if( !empty($title) ) {
wp_update_term( $id, 'shopcategory', array('name' => $title ) );
$foo = array('success' => 'Category with ' . $id . ' updated');
$action = true;
}
}
if( !$action )
$foo = array('message' => 'Error: update failed, id: ' . $id . ' title: ' . $title);
echo json_encode( $foo );
die();
}
add_action('wp_ajax_aliprice_import_review', 'aliprice_import_review');
function aliprice_import_review(){
$pos = isset($_POST['pos']) && $_POST['pos'] > 0 ? absint($_POST['pos']) : 1;
$page = isset($_POST['page']) && $_POST['page'] > 0 ? absint($_POST['page']) : 1;
$star = isset($_POST['star']) && $_POST['star'] <= 5 && $_POST['star'] > 0 ? absint($_POST['star']) : 1;
global $wpdb;
$row = $wpdb->get_row(
$wpdb->prepare("SELECT * FROM `{$wpdb->products}` WHERE `post_id` <> 0 LIMIT %d, 1", $pos)
);
if( empty($row) ) {
echo 'end';
die();
}
require( dirname( __FILE__ ) . '/class.AliExpress.Review.php' );
$obj = new Review($row->productId);
$obj->setNewParams();
$obj->setPage($page);
$data = $obj->getReviews();
if( !$data ) {
echo json_encode(array(
'product' => $row->productId,
'status' => 'end'
));
die();
}
foreach( $data as $key => $val ) {
if( !aliprice_check_exists_review( $row->post_id, $val ) && $val['star'] >= $star ) {
$feedback = !empty($val['feedback']) ? $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'
)
);
}
}
$review = aliprice_review_stats( $row->post_id, $row );
aliprice_setTimeout(1);
echo json_encode($review);
die();
}
add_action('wp_ajax_aliprice_count_review', 'aliprice_count_review');
function aliprice_count_review(){
$reviews = aliprice_total_count_reviews();
echo $reviews;
die();
}
function aliprice_review_stats( $post_id, $product ) {
global $wpdb;
$row = $wpdb->get_row(
$wpdb->prepare("SELECT AVG(`star`) `ratings`, COUNT(`id`) `count` FROM `{$wpdb->review}` WHERE `post_id` = '%d'", $post_id)
);
$count = 0;
$rating = 0;
$img = "";
if( !empty($row) ) {
$th = !has_post_thumbnail($product->post_id);
if( !has_post_thumbnail($product->post_id) && !empty($product->imageUrl) )
$img = aliprice_get_thumb_ali( $product->imageUrl, 'thumb' );
elseif( $th ) {
$thumb_id = get_post_thumbnail_id( $post_id );
$url = wp_get_attachment_image_src( $thumb_id, 'thumbnail' );
$img = $url[0];
}
$wpdb->update(
$wpdb->products,
array('evaluateScore' => $row->ratings, 'countReview' => $row->count),
array('post_id' => $post_id),
array('%f', '%d'),
array('%d')
);
$rating = $row->ratings;
$count = $row->count;
}
return array(
'productId' => $product->productId,
'title' => get_the_title( $post_id ),
'rating' => $rating,
'count' => $count,
'thumb' => $img,
'status' => 'ok'
);
}
function aliprice_check_exists_review( $post_id, $args ) {
global $wpdb;
$var = $wpdb->get_var(
$wpdb->prepare(
"SELECT `id`
FROM `{$wpdb->review}`
WHERE `post_id` = '%d' AND
`date` = '%s' AND
`flag` = '%s'",
$post_id, $args['date'], $args['flag'])
);
if( empty($var) ) return false;
return true;
}
/**
* Count products
*/
function aliprice_update_all_products(){
$count = aliprice_total_count_products();
echo empty($count) ? 0 : $count;
die();
}
add_action('wp_ajax_aliprice_update_all_products', 'aliprice_update_all_products');
/**
* Update products
*/
function aliprice_update_step_product() {
global $wpdb;
$from = intval($_POST['step']); //
$count = intval($_POST['count']); //
$len = intval($_POST['len']); //
$len = $len <= 0 ? 1 : $len;
$delete = get_site_option('aliprice-delete');
$current = $len*$from - $len;
if( $current <= 0 ) { $current = 0; }
if( $current > $count ) { echo 0; die(); }
$insert = new AliExpressInsert();
$pub = new AliExpressPublish();
$result = $insert->updateProductsDetailsMini( $current, $len );
foreach( $result as $key => $productId ) {
if( isset($productId['error']) ){
if( isset($productId['id']) ) {
if( !empty($productId['post_id']) ) {
if( $delete == 1 ){
wp_delete_post($productId['post_id'], true);
$wpdb->delete( $wpdb->prefix . "aliprice_products", array( 'post_id' => $productId['post_id'] ), array( '%d' ) );
}
else{
$wpdb->update(
$wpdb->prefix . "aliprice_products",
array( 'availability' => 0, 'quantity' => 0 ),
array( 'post_id' => $productId['post_id'] ),
array( '%d', '%d' ),
array( '%d' )
);
}
}
}
}
else {
if ($productId) {
$pub->setId( $productId );
$pub->updateParametrs();
}
}
}
aliprice_set_max_price();
}
add_action('wp_ajax_aliprice_update_step_product', 'aliprice_update_step_product');
/**
* Return response with subcategories for ajax-request
* from js function aliprice_update_subcategories(category_value)
*/
function aliprice_update_subcategories( ) {
$category_ali_id = $_POST["category_ali_id"];
$subcategories = get_subcategories_list_by_category_ali_id($category_ali_id);
if($subcategories) {
echo json_encode($subcategories);
} else {
echo json_encode(array(
array("error" => 'subcategories not found'),
));
}
wp_die();
}
add_action('wp_ajax_aliprice_update_subcategories', 'aliprice_update_subcategories');