dataupdate_interval = atkp_options::$loader->get_cache_duration();
$this->datacheck_enabled = atkp_options::$loader->get_check_enabled();
$this->datacheck_interval = atkp_options::$loader->get_notification_interval();
$this->csvupdate_interval = atkp_options::$loader->get_access_csv_intervall();
add_filter( 'atkp_queue_collect_entries', array( $this, 'atkp_queue_collect_entries_product' ) );
add_filter( 'atkp_queue_collect_entries', array( $this, 'atkp_queue_collect_entries_list' ) );
add_filter( 'atkp_queue_collect_entries', array( $this, 'atkp_queue_collect_entries_listoffers' ) );
add_filter( 'atkp_queue_collect_entries', array( $this, 'atkp_queue_collect_entries_product_finished' ) );
add_filter( 'atkp_queue_process_entries_productupdate', array(
$this,
'atkp_queue_process_entries_productupdate'
), 10, 2 );
add_filter( 'atkp_queue_process_entries_listupdate', array(
$this,
'atkp_queue_process_entries_listupdate'
), 10, 2 );
add_filter( 'atkp_queue_process_entries_listproductupdate', array(
$this,
'atkp_queue_process_entries_listproductupdate'
), 10, 2 );
add_filter( 'atkp_queue_process_entries_productfinish', array(
$this,
'atkp_queue_process_entries_productfinish'
), 15, 1 );
add_action( 'atkp_datacheck_report', array( $this, 'atkp_datacheck_report' ), 10 );
}
public function atkp_queue_process_entries_productfinish( $entries ) {
/** @var atkp_queue_entry[] $entries */
foreach ( $entries as $entry ) {
try {
$atkp_producttable_helper = new atkp_producttable_helper();
$ids = $atkp_producttable_helper->get_sub_products( $entry->post_id, true );
$has_temp_product = false;
if ( count( $ids ) > 0 ) {
$atkp_producttable_helper->delete_unused_products( $entry->post_id );
} else {
//clean price/availabity
$atkp_producttable_helper->delete_old_productdata( $entry->post_id );
$has_temp_product = true;
}
$products = $atkp_producttable_helper->load_products( $entry->post_id );
if ( count( $products ) == 0 || $has_temp_product ) {
$message = __( 'Products not found for search request. Open Queue History for details.', 'affiliate-toolkit-starter' );
ATKPTools::set_post_setting( $entry->post_id, ATKP_PRODUCT_POSTTYPE . '_message', $message );
$message = sprintf(
/* translators: %1$d: number of products found, %2$s: whether temp product exists (true/false) */
__( 'Products not found for search request. Products count: %1$d, Has temp product: %2$s', 'affiliate-toolkit-starter' ),
count( $products ),
$has_temp_product ? 'true' : 'false'
);
} else {
$saleprice = 0;
foreach ( $products as $product ) {
if ( $product->salepricefloat > 0 ) {
$saleprice = $product->salepricefloat;
break;
}
}
if ( $saleprice == 0 ) {
ATKPTools::set_post_setting( $entry->post_id, ATKP_PRODUCT_POSTTYPE . '_message', __( 'Product found but salesprice is empty', 'affiliate-toolkit-starter' ) );
} else {
ATKPTools::set_post_setting( $entry->post_id, ATKP_PRODUCT_POSTTYPE . '_message', '' );
}
$this->update_eans( $entry->post_id, $products );
#region update title
$post_title = get_the_title( $entry->post_id );
$prd_title = $products[0]->title;
$prd_title = str_replace( " ", " ", $prd_title );
$prd_title = html_entity_decode( $prd_title );
//correct post title
if ( $post_title == '' || ( $post_title != $prd_title && atkp_options::$loader->get_update_producttitle_when_changed() ) ) {
$post_title = $prd_title;
$post_name = sanitize_title( $prd_title );
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Checking for duplicate post slugs.
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table name from $wpdb property.
$pageposts = $wpdb->get_results( $wpdb->prepare(
"SELECT {$wpdb->posts}.*
FROM {$wpdb->posts}
WHERE {$wpdb->posts}.post_type = %s
AND {$wpdb->posts}.post_name = %s
AND {$wpdb->posts}.ID <> %d",
ATKP_PRODUCT_POSTTYPE,
$post_name,
$entry->post_id
), OBJECT );
if ( $pageposts && count( $pageposts ) > 0 ) {
$post_name .= '-' . time();
}
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Updating post title directly for performance.
$wpdb->update( $wpdb->posts, array(
'post_title' => $post_title,
'post_name' => $post_name
), array( 'ID' => $entry->post_id ) );
}
do_action( 'atkp_product_finalization', $entry->post_id );
#endregion
}
$productservice = new atkp_productservice();
$productservice->update_product_categories( $entry->post_id );
$productservice->update_product_mainimage( $entry->post_id );
ob_start();
do_action( 'atkp_product_updated', $entry->post_id, $entry );
$content = ob_get_contents();
ob_end_clean();
if ( ATKPTools::str_contains( $content, 'WooCommerce' ) ) {
$entry->status = atkp_queue_entry_status::SUCCESSFULLY;
$entry->updatedmessage = $content . " updated";
} else if ( ATKPTools::str_contains( $content, 'ProductExport' ) ) {
$entry->status = atkp_queue_entry_status::SUCCESSFULLY;
$entry->updatedmessage = $content . " processed";
} else if ( $content != '' ) {
$entry->status = atkp_queue_entry_status::ERROR;
$entry->updatedmessage = $content;
} else {
$entry->status = atkp_queue_entry_status::SUCCESSFULLY;
}
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_finalization', '1' );
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_lockclear', '0' );
} catch ( Exception $ex ) {
$entry->status = atkp_queue_entry_status::ERROR;
$entry->updatedmessage = $ex->getMessage();
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_finalization', '1' );
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_lockclear', '0' );
}
}
return $entries;
}
public function update_eans( $product_id, $products ) {
$eanbase = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_ean' );
$isbnbase = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_isbn' );
$gtinbase = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_gtin' );
$eans = array();
$isbns = array();
$gtins = array();
$eanssplit = explode( ',', $eanbase );
foreach ( $eanssplit as $eanx ) {
if ( $eanx != '' ) {
$eans[ trim( $eanx ) ] = trim( $eanx );
}
}
$isbnsplit = explode( ',', $isbnbase );
foreach ( $isbnsplit as $isbnx ) {
if ( $isbnx != '' ) {
$isbns[ trim( $isbnx ) ] = trim( $isbnx );
}
}
$gtinsplit = explode( ',', $gtinbase );
foreach ( $gtinsplit as $gtinx ) {
if ( $gtinx != '' ) {
$gtins[ trim( $gtinx ) ] = trim( $gtinx );
}
}
foreach ( $products as $prd ) {
$eanssplit = explode( ',', $prd->ean );
foreach ( $eanssplit as $eanx ) {
if ( $eanx != '' ) {
$eans[ trim( $eanx ) ] = trim( $eanx );
}
}
$isbnsplit = explode( ',', $prd->isbn );
foreach ( $isbnsplit as $isbnx ) {
if ( $isbnx != '' ) {
$isbns[ trim( $isbnx ) ] = trim( $isbnx );
}
}
$gtinsplit = explode( ',', $prd->gtin );
foreach ( $gtinsplit as $gtinx ) {
if ( $gtinx != '' ) {
$gtins[ trim( $gtinx ) ] = trim( $gtinx );
}
}
}
$eanlock = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_ean_lock' );
$isbnlock = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_isbn_lock' );
$gtinlock = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_gtin_lock' );
if ( ! boolval( $eanlock ) ) {
ATKPTools::set_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_ean', implode( ',', $eans ) );
}
if ( ! boolval( $eanlock ) ) {
ATKPTools::set_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_isbn', implode( ',', $isbns ) );
}
if ( ! boolval( $eanlock ) ) {
ATKPTools::set_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_gtin', implode( ',', $gtins ) );
}
}
public function atkp_datacheck_report() {
$this->send_message( '*** data check cronjob started ***' );
$this->send_data_report();
$this->send_message( '*** data check cronjob finished ***' );
}
public function send_data_report( $manual = false ) {
$lastdatacheck = atkp_options::$loader->get_cron_lastdatacheck();
if ( $lastdatacheck != '' && ! $manual ) {
$mysqltime = gmdate( 'Y-m-d H:i:s', $lastdatacheck );
} else {
$mysqltime = gmdate( 'Y-m-d H:i:s', strtotime( '-1 week', time() ) );
}
//TODO: send datacheck mail
$report = atkp_queue::get_report( $mysqltime );
if ( $report && count( $report ) > 0 ) {
$atkp_queue_entry_table = new atkp_queue_entry_table();
$columns = $atkp_queue_entry_table->get_columns();
$tdhead = '';
foreach ( $columns as $name => $header ) {
$tdhead .= '
' . $header . '
';
}
$trbody = '';
foreach ( $report as $report_row ) {
$trbody .= '';
foreach ( $columns as $name => $header ) {
$val = $atkp_queue_entry_table->column_default( $report_row, $name );
$trbody .= '
' . wp_kses_post( $val ) . '
';
}
$trbody .= '
';
}
$report_template = file_get_contents( ATKP_PLUGIN_DIR . '/dist/report-template.html' ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_get_contents_file_get_contents -- Reading local template file.
$htmltable = '';
$report_template = str_replace( '{atkp-report-title}', __( 'affiliate-toolkit Report', 'affiliate-toolkit-starter' ), $report_template );
$htmltable = str_replace( '{atkp-report}', $htmltable, $report_template );
$recipient = ATKPSettings::$email_recipient;
if ( $recipient == '' ) {
$recipient = get_bloginfo( 'admin_email' );
}
$headers = array(
'From: ' . get_bloginfo( 'name' ) . ' <' . get_bloginfo( 'admin_email' ) . '>',
'Content-Type: text/html; charset=UTF-8'
);
if ( $htmltable != '' ) {
$dir = ATKPTools::get_uploaddir();
$filename = $dir . '/report.html';
file_put_contents( $filename, $htmltable ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_file_put_contents -- Writing report file to uploads directory.
wp_mail( $recipient, 'affiliate-toolkit Report for ' . get_bloginfo(), __( 'Attached you can find the report.', 'affiliate-toolkit-starter' ), $headers, $filename );
};
ATKPTools::set_setting( ATKP_PLUGIN_PREFIX . '_cron_lastdatacheck', time() );
}
}
public function atkp_queue_process_entries_productupdate( $entries, $shopid ) {
/** @var atkp_queue_entry[] $entries */
$productservice = new atkp_productservice();
$shop = $shopid == '' ? null : atkp_shop::load( $shopid );
$atkp_producttable_helper = new atkp_producttable_helper();
foreach ( $entries as $entry ) {
$lockclear = ATKPTools::get_post_setting( $entry->post_id, 'atkp_product_lockclear' );
if ( $lockclear != '1' ) {
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_lockclear', 1 );
$atkp_producttable_helper->clear_products( $entry->post_id );
}
}
$entries = $productservice->update_products_v3( $shop, $entries );
foreach ( $entries as $entry ) {
ATKPTools::set_post_setting( $entry->post_id, 'atkp_product_finalization', '0' );
}
return $entries;
}
public function atkp_queue_process_entries_listupdate( $entries, $shopid ) {
/** @var atkp_queue_entry[] $entries */
$listservice = new atkp_listservice();
$shop = $shopid == '' ? null : atkp_shop::load( $shopid );
$entries = $listservice->update_lists_v3( $shop, $entries );
return $entries;
}
public function atkp_queue_process_entries_listproductupdate( $entries, $shopid ) {
/** @var atkp_queue_entry[] $entries */
$listservice = new atkp_listservice();
$shop = $shopid == '' ? null : atkp_shop::load( $shopid );
$entries = $listservice->update_productlists_v3( $shop, $entries );
return $entries;
}
public function atkp_queue_collect_entries_product( $globallist ) {
/** @var atkp_queue_entry[] $list */
$list = array();
global $wpdb;
$updatetime = $this->get_datatime();
$packagesize = atkp_options::$loader->get_queue_package_size();
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table names are from $wpdb properties, values are cast to int.
$sql = $wpdb->prepare(
"SELECT {$wpdb->posts}.ID
FROM {$wpdb->posts}
LEFT JOIN {$wpdb->postmeta} AS mt3 ON ( {$wpdb->posts}.ID = mt3.post_id AND mt3.meta_key = 'atkp_product_updatedon')
WHERE {$wpdb->posts}.post_type = 'atkp_product' AND ({$wpdb->posts}.post_status = 'publish' OR {$wpdb->posts}.post_status = 'draft')
AND ( mt3.post_id IS NULL OR ( mt3.meta_value = '' ) OR ( CAST(mt3.meta_value AS SIGNED) < %d ) )
GROUP BY {$wpdb->posts}.ID
ORDER BY CAST(mt3.meta_value AS SIGNED) ASC
LIMIT 0, %d",
$updatetime,
$packagesize
);
$sql = apply_filters( 'atkp_queue_collect_product_sql', $sql, $updatetime, $packagesize );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Cron queue collection query.
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Query is prepared above or modified by filter.
$posts_found = $wpdb->get_results( $sql, OBJECT );
$shops = atkp_shop::get_list();
foreach ( $posts_found as $prod ) {
$lr = $this->generate_product_entries( $shops, $prod->ID );
foreach ( $lr as $l ) {
$list[] = $l;
}
}
//sort list by shopid, functionname
usort( $list, array( $this, 'sort_query_entry' ) );
return array_merge( $globallist, $list );
}
public function atkp_queue_collect_entries_product_finished( $list ) {
/** @var atkp_queue_entry[] $list */
global $wpdb;
$packagesize = atkp_options::$loader->get_queue_package_size();
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table names are from $wpdb properties.
$sql = $wpdb->prepare(
"SELECT SQL_CALC_FOUND_ROWS {$wpdb->posts}.ID
FROM {$wpdb->posts}
INNER JOIN {$wpdb->postmeta} AS mt1 ON ( {$wpdb->posts}.ID = mt1.post_id AND mt1.meta_key = 'atkp_product_finalization')
WHERE {$wpdb->posts}.post_type = 'atkp_product' AND ({$wpdb->posts}.post_status = 'publish' OR {$wpdb->posts}.post_status = 'draft')
AND ( (mt1.meta_value = '0' ) )
ORDER BY {$wpdb->posts}.ID ASC
LIMIT 0, %d",
$packagesize
);
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Cron queue collection query.
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Query is prepared above.
$posts_found = $wpdb->get_results( $sql, OBJECT );
foreach ( $posts_found as $prod ) {
$at = new atkp_queue_entry();
$at->post_id = $prod->ID;
$at->shop_id = '';
$at->post_type = 'atkp_product';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'productfinish';
$at->functionparameter = 'id' . ATKP_QUEUE_SEPARATOR . $prod->ID;
$list[] = $at;
}
return $list;
}
/**
* @param atkp_queue_entry $a
* @param atkp_queue_entry $b
*
* @return int
*/
public function sort_query_entry( $a, $b ) {
if ( $a->shop_id == $b->shop_id ) {
return strcasecmp( $a->functionname, $b->functionname );
}
return ( $a->shop_id < $b->shop_id ) ? - 1 : 1;
}
public function atkp_queue_collect_entries_list( $globallist ) {
/** @var atkp_queue_entry[] $list */
$list = array();
global $wpdb;
$updatetime = $this->get_datatime();
$packagesize = atkp_options::$loader->get_queue_package_size();
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table names are from $wpdb properties.
$sql = $wpdb->prepare(
"SELECT {$wpdb->posts}.ID
FROM {$wpdb->posts}
LEFT JOIN {$wpdb->postmeta} AS mt3 ON ( {$wpdb->posts}.ID = mt3.post_id AND mt3.meta_key = 'atkp_list_updatedon')
WHERE {$wpdb->posts}.post_type = 'atkp_list' AND ({$wpdb->posts}.post_status = 'publish' OR {$wpdb->posts}.post_status = 'draft')
AND ( mt3.post_id IS NULL OR ( mt3.meta_value = '' ) OR ( CAST(mt3.meta_value AS SIGNED) < %d ) )
GROUP BY {$wpdb->posts}.ID
ORDER BY CAST(mt3.meta_value AS SIGNED) ASC
LIMIT 0, %d",
$updatetime,
$packagesize
);
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Cron queue collection query.
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Query is prepared above.
$posts_found = $wpdb->get_results( $sql, OBJECT );
$shops = atkp_shop::get_list();
foreach ( $posts_found as $prod ) {
$selectedshopid = ATKPTools::get_post_setting( $prod->ID, ATKP_LIST_POSTTYPE . '_shopid' );
$loadmoreoffers = ATKPTools::get_post_setting( $prod->ID, ATKP_LIST_POSTTYPE . '_loadmoreoffers' );
$ltdh = new atkp_listtable_helper();
$listentries = $ltdh->load_list( $prod->ID, $selectedshopid );
//get entries by EAN
$eans = array();
foreach ( $listentries as $product ) {
$type = $product['type'];
if ( $type == 'product' ) {
/** @var atkp_product $value */
$value = $product['value'];
if ( $value->ean != '' ) {
$eanssplit = explode( ',', $value->ean );
foreach ( $eanssplit as $eanx ) {
$eans[] = $eanx;
}
}
}
}
$shopfound = false;
foreach ( $shops as $shophead ) {
/** @var atkp_shop[] $list */
$list2 = array();
$list2[] = $shophead;
if ( $shophead->type == atkp_shop_type::SUB_SHOPS || $shophead->type == atkp_shop_type::MULTI_SHOPS ) {
foreach ( $shophead->children as $xx ) {
$list2[] = $xx;
}
}
foreach ( $list2 as $shop ) {
if ( $selectedshopid == $shop->id ) {
$shopfound = true;
$at = new atkp_queue_entry();
$at->post_id = $prod->ID;
$at->shop_id = $shop->id;
$at->post_type = 'atkp_list';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'listupdate';
$list[] = $at;
}
}
}
if ( ! $shopfound ) {
$shopfound = true;
$at = new atkp_queue_entry();
$at->post_id = $prod->ID;
$at->shop_id = '';
$at->post_type = 'atkp_list';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'listupdate';
$list[] = $at;
}
}
//sort list by shopid, functionname (listupdate before listproductupdate)
usort( $list, array( $this, 'sort_query_entry' ) );
return array_merge( $globallist, $list );
}
public function atkp_queue_collect_entries_listoffers( $globallist ) {
/** @var atkp_queue_entry[] $list */
$list = array();
global $wpdb;
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Table names are from $wpdb properties.
$sql = "SELECT {$wpdb->posts}.ID
FROM {$wpdb->posts}
LEFT JOIN {$wpdb->postmeta} AS mt3 ON ( {$wpdb->posts}.ID = mt3.post_id AND mt3.meta_key = 'atkp_list_offerupdate')
WHERE {$wpdb->posts}.post_type = 'atkp_list' AND ({$wpdb->posts}.post_status = 'publish' OR {$wpdb->posts}.post_status = 'draft')
AND ( CAST(mt3.meta_value AS SIGNED) = 1 )
GROUP BY {$wpdb->posts}.ID
LIMIT 0, 150";
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Cron queue collection query.
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Query uses only $wpdb table properties, no user input.
$posts_found = $wpdb->get_results( $sql, OBJECT );
$shops = atkp_shop::get_list();
foreach ( $posts_found as $prod ) {
$selectedshopid = ATKPTools::get_post_setting( $prod->ID, ATKP_LIST_POSTTYPE . '_shopid' );
$loadmoreoffers = ATKPTools::get_post_setting( $prod->ID, ATKP_LIST_POSTTYPE . '_loadmoreoffers' );
if ( ! $loadmoreoffers )
continue;
$ltdh = new atkp_listtable_helper();
$listentries = $ltdh->load_list( $prod->ID, $selectedshopid );
//get entries by EAN
$eans = array();
foreach ( $listentries as $product ) {
$type = $product['type'];
if ( $type == 'product' ) {
/** @var atkp_product $value */
$value = $product['value'];
if ( $value->ean != '' ) {
$eanssplit = explode( ',', $value->ean );
foreach ( $eanssplit as $eanx ) {
if ( ATKPTools::validate_ean( $eanx ) ) {
$eans[] = $eanx;
}
}
}
}
}
//remove duplicate entries
$eans = array_unique( $eans );
$shopfound = false;
foreach ( $shops as $shophead ) {
/** @var atkp_shop[] $list */
$list2 = array();
$list2[] = $shophead;
foreach ( $shophead->children as $xx ) {
$list2[] = $xx;
}
foreach ( $list2 as $shop ) {
if ( $shop->type == atkp_shop_type::SUB_SHOPS || $shop->type == atkp_shop_type::SINGLE_SHOP ) {
if ( $selectedshopid != $shop->id ) {
foreach ( $eans as $ean ) {
if ( $ean == '' ) {
continue;
}
$at = new atkp_queue_entry();
$at->post_id = $prod->ID;
$at->shop_id = $shop->id;
$at->post_type = 'atkp_list';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'listproductupdate';
$at->functionparameter = 'ean' . ATKP_QUEUE_SEPARATOR . $ean;
$list[] = $at;
}
}
}
}
}
}
//sort list by shopid, functionname (listupdate before listproductupdate)
usort( $list, array( $this, 'sort_query_entry' ) );
return array_merge( $globallist, $list );
}
private function get_datatime( $datetimeformat = false ) {
$updatetime = time();
$dataupdateinterval = atkp_options::$loader->get_cache_duration();
if ( $dataupdateinterval > 60 ) {
$updatetime = strtotime( '-' . ( $dataupdateinterval / 60 ) . ' hours' );
} else {
$updatetime = strtotime( '-' . ( $dataupdateinterval ) . ' min' );
}
if ( $datetimeformat ) {
return gmdate( 'd.m.y H:m:s', $updatetime );
}
//$updatetime = ATKPTools::get_time( $updatetime, 'timestamp' );
return $updatetime;
}
public function generate_product_entries( $shops, $product_id, $generate_only_main_offers = false, $generate_only_price_compare = false ) {
// define filter for multipe options
$shoplist = array();
foreach ( $shops as $shophead ) {
/** @var atkp_shop $shop */
$shoplist[] = $shophead;
foreach ( $shophead->children as $xx ) {
$shoplist[] = $xx;
}
}
$filters = array();
$main_shop_ids = array();
for ( $x = 1; $x < ( ATKP_FILTER_COUNT + 1 ); $x ++ ) {
$asin = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_asin' . ( $x > 1 ? '_' . $x : '' ) );
$asintype = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_asintype' . ( $x > 1 ? '_' . $x : '' ) );
$shopid = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_shopid' . ( $x > 1 ? '_' . $x : '' ) );
if ( $asin == null && $asintype == null && $shopid == null ) {
continue;
}
$filter = array();
if ( $shopid == '' || $shopid == 0 ) {
continue;
}
$filtered_shops = array();
if ( $shopid == - 1 ) {
foreach ( $shoplist as $shop ) {
$parentshop = null;
if ( $shop->type == atkp_shop_type::CHILD_SHOP ) {
foreach ( $shoplist as $pshop ) {
if ( $pshop->id == $shop->parent_id ) {
$parentshop = $pshop;
break;
}
}
}
if ( $shop->enablepricecomparison && ( $shop->type == atkp_shop_type::MULTI_SHOPS || ( $shop->type == atkp_shop_type::CHILD_SHOP && $parentshop->type == atkp_shop_type::SUB_SHOPS ) || $shop->type == atkp_shop_type::SINGLE_SHOP ) ) {
$filtered_shops[] = $shop;
}
}
} else {
foreach ( $shoplist as $shop ) {
if ( $shop->id == $shopid ) {
$filtered_shops[] = $shop;
$main_shop_ids[] = $shopid;
break;
}
}
}
$filter['shop'] = $filtered_shops;
$filter['asintype'] = $asintype == '' ? 'asin' : strtolower( $asintype );
$filter['asin'] = $asin;
if ( $asin != '' ) {
$filters[] = $filter;
}
}
if ( ! $generate_only_main_offers ) {
$eans = array();
$eanfield = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_ean' );
if ( $eanfield != '' ) {
$eanssplit = explode( ',', $eanfield );
foreach ( $eanssplit as $eanx ) {
if ( ! in_array( $eanx, $eans ) ) {
if ( ATKPTools::validate_ean( $eanx ) ) {
$eans[] = $eanx;
}
}
}
}
foreach ( $eans as $ean ) {
$filtered_shops = array();
foreach ( $shoplist as $shop ) {
$parentshop = null;
if ( $shop->type == atkp_shop_type::CHILD_SHOP ) {
foreach ( $shoplist as $pshop ) {
if ( $pshop->id == $shop->parent_id ) {
$parentshop = $pshop;
break;
}
}
}
if ( ! in_array( $shop->id, $main_shop_ids ) && $shop->enablepricecomparison && ( $shop->type == atkp_shop_type::MULTI_SHOPS || ( $shop->type == atkp_shop_type::CHILD_SHOP && $parentshop->type == atkp_shop_type::SUB_SHOPS ) || $shop->type == atkp_shop_type::SINGLE_SHOP ) ) {
$filtered_shops[] = $shop;
}
}
$filter['shop'] = $filtered_shops;
$filter['asintype'] = 'ean';
$filter['asin'] = $ean;
$filters[] = $filter;
}
$isbns = array();
$isbnfield = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_isbn' );
if ( $isbnfield != '' ) {
$isbnsplit = explode( ',', $isbnfield );
foreach ( $isbnsplit as $isbnx ) {
if ( ! in_array( $isbnx, $isbns ) ) {
//TODO: Validate ISBN
if ( ATKPTools::validate_isbn( $isbnx ) ) {
$isbns[] = $isbnx;
}
}
}
}
foreach ( $isbns as $isbn ) {
$filtered_shops = array();
foreach ( $shoplist as $shop ) {
$parentshop = null;
if ( $shop->type == atkp_shop_type::CHILD_SHOP ) {
foreach ( $shoplist as $pshop ) {
if ( $pshop->id == $shop->parent_id ) {
$parentshop = $pshop;
break;
}
}
}
if ( ! in_array( $shop->id, $main_shop_ids ) && $shop->enablepricecomparison && ( $shop->type == atkp_shop_type::MULTI_SHOPS || ( $shop->type == atkp_shop_type::CHILD_SHOP && $parentshop->type == atkp_shop_type::SUB_SHOPS ) || $shop->type == atkp_shop_type::SINGLE_SHOP ) ) {
$supportisbn = apply_filters( 'atkp_shop_support_isbn_search', false, $shop );
if ( $supportisbn ) {
$filtered_shops[] = $shop;
}
}
}
$filter['shop'] = $filtered_shops;
$filter['asintype'] = 'isbn';
$filter['asin'] = $isbn;
$filters[] = $filter;
}
$gtins = array();
$gtinfield = ATKPTools::get_post_setting( $product_id, ATKP_PRODUCT_POSTTYPE . '_gtin' );
if ( $gtinfield != '' ) {
$gtinsplit = explode( ',', $gtinfield );
foreach ( $gtinsplit as $gtinx ) {
if ( ! in_array( $gtinx, $gtins ) ) {
//TODO: Validate GTIN
if ( ATKPTools::validate_gtin( $gtinx ) ) {
$gtins[] = $gtinx;
}
}
}
}
foreach ( $gtins as $gtin ) {
$filtered_shops = array();
foreach ( $shoplist as $shop ) {
$parentshop = null;
if ( $shop->type == atkp_shop_type::CHILD_SHOP ) {
foreach ( $shoplist as $pshop ) {
if ( $pshop->id == $shop->parent_id ) {
$parentshop = $pshop;
break;
}
}
}
if ( ! in_array( $shop->id, $main_shop_ids ) && $shop->enablepricecomparison && ( $shop->type == atkp_shop_type::MULTI_SHOPS || ( $shop->type == atkp_shop_type::CHILD_SHOP && $parentshop->type == atkp_shop_type::SUB_SHOPS ) || $shop->type == atkp_shop_type::SINGLE_SHOP ) ) {
$supportgtin = apply_filters( 'atkp_shop_support_gtin_search', false, $shop );
if ( $supportgtin ) {
$filtered_shops[] = $shop;
}
}
}
$filter['shop'] = $filtered_shops;
$filter['asintype'] = 'gtin';
$filter['asin'] = $gtin;
$filters[] = $filter;
}
}
$list = array();
foreach ( $filters as $filter ) {
foreach ( $filter['shop'] as $shop ) {
if ( $generate_only_price_compare && $filter['asintype'] == 'asin' ) {
continue;
}
$at = new atkp_queue_entry();
$at->post_id = $product_id;
$at->shop_id = $shop->id;
$at->post_type = 'atkp_product';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'productupdate';
$at->functionparameter = $filter['asintype'] . ATKP_QUEUE_SEPARATOR . $filter['asin'];
$found = false;
foreach ( $list as $e ) {
if ( $e->functionname == $at->functionname && $e->functionparameter == $at->functionparameter && $at->post_id == $e->post_id && $at->shop_id == $e->shop_id ) {
$found = true;
break;
}
}
if ( ! $found ) {
$list[] = $at;
}
}
}
return $list;
}
public function send_message( $message ) {
if ( class_exists( 'WP_CLI' ) ) {
WP_CLI::log( $message );
} else {
echo esc_html( $message ) . '
' . PHP_EOL;
}
if ( ATKPLog::$logenabled ) {
ATKPLog::LogDebug( $message );
}
}
public static function do_manual_list_update( $post_id, $queue_title = '' ) {
$shopid = ATKPTools::get_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_shopid' );
$loadmoreoffers = ATKPTools::get_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_loadmoreoffers' );
$shop = $shopid == '' ? null : atkp_shop::load( $shopid );
$entry = new atkp_queue_entry();
$entry->post_id = $post_id;
$entry->shop_id = $shopid;
$entry->post_type = ATKP_LIST_POSTTYPE;
$entry->status = atkp_queue_entry_status::PREPARED;
$entry->functionname = 'listupdate';
$queue = ATKPTools::create_queue( 'atkp_list', $queue_title, false, [ $entry ], atkp_queue_status::ERROR );
try {
$entries = apply_filters( 'atkp_queue_process_entries_listupdate', [ $entry ], $entry->shop_id );
foreach ( $entries as $entry ) {
$entry->save();
}
if ( $loadmoreoffers && $shopid != '' ) {
ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_updatedon', '' );
}
$queue->status = atkp_queue_status::SUCCESSFULLY;
$queue->updatedmessage = "updated";
$queue->save();
} catch ( Exception $e ) {
$queue->status = atkp_queue_status::ERROR;
$queue->updatedmessage = $e->getMessage();
$queue->save();
}
}
public static function do_manual_product_update( $post_id, $queue_title = '' ) {
$atkp_prodcttable_helper = new atkp_producttable_helper();
$atkp_prodcttable_helper->clear_products( $post_id );
$shops = atkp_shop::get_list();
$atkp_queueservices = new atkp_queueservices();
$lr = $atkp_queueservices->generate_product_entries( $shops, $post_id, true );
$newgroup = array();
foreach ( $lr as $x ) {
$s = atkp_shop::load( $x->shop_id );
$plugin_name = ATKPTools::get_plugin_name_from_object( $s->provider );
// Prüfe Lizenz
if ( ! ATKPTools::is_license_active_for_plugin( $plugin_name ) ) {
continue;
}
if ( ! isset( $newgroup[ $x->shop_id ] ) ) {
$newgroup[ $x->shop_id ] = array();
}
$newgroup[ $x->shop_id ][] = $x;
}
if ( count( $newgroup ) == 0 ) {
$atkp_prodcttable_helper->delete_unused_products( $post_id );
}
$queue = ATKPTools::create_queue( 'atkp_product', $queue_title, false, $lr, atkp_queue_status::SUCCESSFULLY );
atkp_timeouter::start( 20 );
try {
foreach ( $newgroup as $shopid => $list ) {
$entries = apply_filters( 'atkp_queue_process_entries_productupdate', $list, $shopid );
foreach ( $entries as $entry ) {
$entry->save();
}
}
$at = new atkp_queue_entry();
$at->post_id = $post_id;
$at->shop_id = 0;
$at->post_type = 'atkp_product';
$at->status = atkp_queue_entry_status::PREPARED;
$at->functionname = 'productfinish';
$at->functionparameter = 'id' . ATKP_QUEUE_SEPARATOR . $post_id;
apply_filters( 'atkp_queue_process_entries_productfinish', [ $at ] );
$queue->entries = [ $at ];
$queue->status = atkp_queue_status::SUCCESSFULLY;
$queue->updatedmessage = "updated";
$queue->save();
atkp_timeouter::end();
} catch ( Exception $e ) {
atkp_timeouter::end();
$queue->status = atkp_queue_status::ERROR;
$queue->updatedmessage = $e->getMessage();
$queue->save();
}
ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_updatedon', '' );
}
}