<?php
/**
 * Created by PhpStorm.
 * User: Christof
 * Date: 01.12.2018
 * Time: 11:35
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit;
} // Exit if accessed directly

class ATKPTools {

	public static function check_sslurl( $url ) {
		if ( is_ssl() && ATKPTools::startsWith( $url, 'http://' ) && ! ATKPTools::startsWith( $url, 'https://' ) ) {
			$url = 'https://' . substr( $url, 7 );
		}

		return $url;
	}

	public static function get_fieldgroups() {

		$args = array(
			'posts_per_page' => 25,
			'post_type'      => array( ATKP_FIELDGROUP_POSTTYPE ),
			'post_status'    => array( 'publish', 'draft' ),
		);

		$groups = get_posts( $args );

		return $groups;
	}

	public static function get_fieldgroups_with_taxonomy() {

		$args = array(
			'posts_per_page' => 25,
			'post_type'      => array( ATKP_FIELDGROUP_POSTTYPE ),
			'post_status'    => array( 'publish', 'draft' ),
			'meta_query'     => array(
				'key'     => ATKP_FIELDGROUP_POSTTYPE . '_hastaxonomy',
				'value'   => 1,
				'compare' => '=',
				'type'    => 'NUMERIC'
			)
		);

		$groups = get_posts( $args );

		return $groups;
	}

	public static function get_fieldgroups_by_productid( $postId ) {

		$category       = get_option( ATKP_PLUGIN_PREFIX . '_product_category_taxonomy', strtolower( __( 'Productcategory', ATKP_PLUGIN_PREFIX ) ) );
		$categoryvalues = array();

		$terms = get_the_terms( $postId, $category );

		if ( $terms == null || ! $terms || ! is_array( $terms ) ) {
			return array();
		}

		foreach ( $terms as $term ) {
			if ( is_object( $term ) ) {
				array_push( $categoryvalues, $term->term_id );
			}
		}

		$args = array(
			'posts_per_page' => 25,
			'post_type'      => array( ATKP_FIELDGROUP_POSTTYPE ),
			'post_status'    => array( 'publish', 'draft' ),
			'tax_query'      => array(
				array(
					'taxonomy' => $category, //or tag or custom taxonomy
					'field'    => 'id',
					'terms'    => $categoryvalues
				)
			)
		);

		$groups = get_posts( $args );

		return $groups;
	}

	public static function has_subshops( $shoptype ) {
		return $shoptype == '2' || $shoptype == '3' || $shoptype == '5' || $shoptype == '8' || $shoptype == '9' || $shoptype == '10';
	}

	public static function has_eanpricecompare( $shoptype ) {
		return $shoptype != '8';
	}

	public static function has_articlenumbersearch( $shoptype ) {
		return $shoptype == '1' || $shoptype == '2' || $shoptype == '4' || $shoptype == '10';
	}

	public static function create_list( $title, $shopid, $listtype, $searchterm, $department = '', $sortby = '', $loadmoreoffers = false ) {
		//throw new exception($listtype);

		if ( $title == '' ) {
			$title = $listtype . '-' . $searchterm . ( $department != '' ? '-' . $department : '' );
		}

		global $user_ID;
		$new_post = array(
			'post_title'  => $title,
			'post_status' => 'publish',
			'post_author' => $user_ID,
			'post_type'   => ATKP_LIST_POSTTYPE,
		);
		$post_id  = wp_insert_post( $new_post );

		ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_shopid', $shopid );
		ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_source', $listtype );


		ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_preferlocalproduct', true );
		ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_loadmoreoffers', $loadmoreoffers );
		ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_search_department', $department == '' ? 'All' : $department );
		if ( $listtype == '10' || $listtype == '11' ) {
			ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_node_id', $searchterm );
			ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_search_limit', 10 );

		} else {
			ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_search_keyword', $searchterm );
			ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_search_limit', 20 );
		}

		if ( $sortby != '' ) {
			ATKPTools::set_post_setting( $post_id, ATKP_LIST_POSTTYPE . '_search_orderby', $sortby );
		}

		return $post_id;
	}

	public static function get_current_utc() {
		$script_at = date_default_timezone_get();

		date_default_timezone_set( "UTC" );
		$time = time();
		date_default_timezone_set( $script_at );

		return $time;
	}


	public static function get_formatted_date( $updatedon ) {
		if ( $updatedon == '' ) {
			return '';
		}

		$utctime = date_i18n( get_option( 'date_format' ), $updatedon );
		//$localtime = get_date_from_gmt( $utctime, 'Y-m-d H:i:s' );

		$localtime = $utctime; //date_i18n(get_option( 'date_format' ), $utctime);

		return $localtime;
	}

	public static function get_formatted_time( $updatedon ) {
		if ( $updatedon == '' ) {
			return '';
		}

		$utctime   = date_i18n( 'Y-m-d H:i:s', $updatedon );
		$localtime = get_date_from_gmt( $utctime, get_option( 'time_format' ) );


		return $localtime;
	}

	private static $iscreating = false;

	public static function publish_product( $post_id, $posttitle = '' ) {

		$query = array(
			'ID'          => $post_id,
			'post_status' => 'publish'
		);
		wp_update_post( $query, true );

		if ( $posttitle != '' ) {
			global $wpdb;

			$wpdb->update( $wpdb->posts, array(
				'post_title' => $posttitle,
				'post_name'  => sanitize_title( $posttitle )
			), array( 'ID' => $post_id ) );
		}
	}

	public static function create_product( $title, $shopid, $asin, $status, $asintype = 'ASIN' ) {
		if ( self::$iscreating ) {
			return null;
		}
		self::$iscreating = true;

		$defaultproductstate = get_option( ATKP_PLUGIN_PREFIX . '_defaultproductstate', 'draft' );

		if ( $status == null || $status == '' ) {
			$status = $defaultproductstate;
		}

		//25.06.2018 -> $status == 'publish' ? 'publish' :  veröffentlich wird erst am ende
		global $user_ID;
		$new_post = array(
			'post_title'  => $title,
			'post_status' => 'draft',
			'post_author' => $user_ID,
			'post_type'   => ATKP_PRODUCT_POSTTYPE,
		);


		$post_id          = wp_insert_post( $new_post );
		self::$iscreating = false;

		if ( $status == 'woo' ) {
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_iswoocommerce', 1 );
		}

		ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_shopid', $shopid );
		ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshmoreoffersregulary', 1 );

		if ( $shopid == '' ) {

		} else {
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_asin', $asin );
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_asintype', $asintype );
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshreviewinforegulary', 1 );
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshpriceinforegulary', 1 );
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshproducturlregulary', 1 );
			ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshimagesregulary', 1 );
		}

		return $post_id;
	}

	public static function delete_image_attachment( $attach_id ) {
		//wenn thumbnail vorhanden dann nicht setzen
		if ( $attach_id != '' ) {
			delete_post_thumbnail( $attach_id );
			wp_delete_attachment( $attach_id, false );
		}
	}

	public static function upload_image( $image_url, $image_name, $post_id, $idx = 1 ) {
		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( '*** upload_image started (' . $image_url . ' / ' . $image_name . ' / ' . $post_id . ') ***' );
		}

		if ( ! function_exists( 'file_get_contents' ) ) {
			if ( ATKPLog::$logenabled ) {
				ATKPLog::LogDebug( 'function file_get_contents not exists' );
			}

			return false;
		}

		// Add Featured Image to Post
		$upload_dir = wp_upload_dir(); // Set upload folder

		$context = stream_context_create(
			array(
				'http' => array(
					'method' => "GET",
					'header' => "Accept-language: en\r\n" .
					            "Cookie: foo=bar\r\n" .  // check function.stream-context-create on php.net
					            "User-Agent: Mozilla/5.0 (iPad; U; CPU OS 3_2 like Mac OS X; en-us) AppleWebKit/531.21.10 (KHTML, like Gecko) Version/4.0.4 Mobile/7B334b Safari/531.21.102011-10-16 20:23:10\r\n"
					// i.e. An iPad
				)
			)
		);

		$image_data = file_get_contents( $image_url, false, $context ); // Get image data

		//wenn fehler beim lesen auftritt, wird false zurück gegeben
		if ( ! $image_data ) {
			if ( ATKPLog::$logenabled ) {
				ATKPLog::LogDebug( '$image_data is empty: ' . $image_url );
			}

			return false;
		}


		//find attachmentid
		$args = array(
			'post_status' => 'inherit',
			'post_type'   => 'attachment',
			'meta_query'  => array(
				array(
					'key'     => ATKP_PLUGIN_PREFIX . '_key',
					'compare' => '=',
					'value'   => $post_id . '-' . $idx
				)
			)
		);

		$attach_query = new WP_Query( $args );

		$posts_array = $attach_query->posts;

		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( 'attachment found: ' . serialize( $posts_array ) );
		}

		if ( isset( $posts_array ) && count( $posts_array ) > 0 ) {
			$attachmentid = $posts_array[0]->ID;

			$theurl = wp_get_attachment_image_src( $attachmentid, 'full' );
		}

		$basedir = $upload_dir['basedir'];
		$baseurl = $upload_dir['baseurl'];

		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( '$basedir: ' . serialize( $basedir ) );
			ATKPLog::LogDebug( '$baseurl: ' . serialize( $baseurl ) );
		}

		if ( isset( $theurl ) && $theurl ) {

			$file     = $basedir . str_replace( $baseurl, '', $theurl[0] );
			$filename = $posts_array[0]->post_name;

		} else {
			$ext = substr( strrchr( $image_url, '.' ), 1 );
			//dateiendung hat nur 3 stellen
			$ext = strlen( $ext ) <= 3 ? $ext : '';

			if ( $ext == '' || $ext == ' ' ) {
				$ext = 'jpg';
			}

			$image_name = strlen( $image_name ) > 30 ? substr( $image_name, 0, 30 ) : $image_name;

			$unique_file_name = sanitize_file_name( $post_id . '-' . $idx . '-' . sanitize_title( $image_name ) . '.' . $ext );
			//wp_unique_filename( $upload_dir['path'], $image_name.'.'.$ext ); // Generate unique name

			$filename = strtolower( basename( $unique_file_name ) ); // Create image file name
			$basedir  = '';

			// Check folder permission and define file location
			if ( wp_mkdir_p( $upload_dir['path'] ) ) {
				$basedir = $upload_dir['path'];
			} else {
				$basedir = $upload_dir['basedir'];
			}

			//$basedir = wp_upload_dir('2017/01')['basedir']. '/product-image';
			//wp_mkdir_p($basedir);

			$file = $basedir . '/' . $filename;


			$file = urldecode( $file );
		}


		/* Restore original Post Data */
		wp_reset_postdata();

		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( '$file: ' . serialize( $file ) );
			ATKPLog::LogDebug( '$filename: ' . serialize( $filename ) );
		}


		// Create the image  file on the server
		if ( ! file_put_contents( $file, $image_data ) ) {
			if ( ATKPLog::$logenabled ) {
				ATKPLog::LogDebug( 'image cannot be saved: ' . $file );
			}

			return false;
		}


		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( 'file saved: ' . $file );
		}

		//find attachmentid
		//$args = array(
		//    'post_per_page' => 1,
		//    'post_type'     => 'attachment',
		//    'name'          => $filename,
		//);
		//$posts_array = get_posts( $args );

		// Check image file type
		$wp_filetype = wp_check_filetype( $filename, null );

		if ( isset( $posts_array ) && count( $posts_array ) > 0 ) {
			$attach_id = $posts_array[0]->ID;

			$data = array(
				'post_mime_type' => $wp_filetype['type'],
				'post_title'     => $filename,
				'post_status'    => 'inherit'
			);

			//wp_update_attachment_metadata( $attach_id, $data );

			if ( ATKPLog::$logenabled ) {
				ATKPLog::LogDebug( '*** existing attachment updated: ' . $attach_id . '' );
				ATKPLog::LogDebug( serialize( $data ) );
			}


		} else {
			// Set attachment data
			$attachment = array(
				'post_mime_type' => $wp_filetype['type'],
				'post_title'     => $filename,
				'post_status'    => 'inherit'
			);

			// Create the attachment
			$attach_id = wp_insert_attachment( $attachment, $file, $post_id );

			if ( ATKPLog::$logenabled ) {
				ATKPLog::LogDebug( '*** attachment created: ' . $attach_id . '' );
				ATKPLog::LogDebug( serialize( $attachment ) );
			}

		}

		// Include image.php
		require_once( ABSPATH . 'wp-admin/includes/image.php' );


		// Assign metadata to attachment
		wp_update_attachment_metadata( $attach_id, wp_generate_attachment_metadata( $attach_id, $file ) );
		//set atkp key
		ATKPTools::set_post_setting( $attach_id, ATKP_PLUGIN_PREFIX . '_key', $post_id . '-' . $idx );


		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( '*** upload_image finished (' . $attach_id . ') ***' );
		}

		return $attach_id;
	}

	public static function set_featured_image( $image_url, $image_name, $post_id ) {
		$thumbnail = get_post_thumbnail_id( $post_id );

		$attach_id = ATKPTools::upload_image( $image_url, $image_name, $post_id, 1 );

		//lösche das alte thumbnail wenn der upload nicht erfolgreich war
		if ( $attach_id == false ) {
			//ATKPTools::delete_image_attachment($thumbnail);
			if ( has_post_thumbnail( $post_id ) ) {
				$attachment_id = get_post_thumbnail_id( $post_id );
				if ( $attachment_id ) {
					wp_delete_attachment( $attachment_id, true );
				}
			}
		}

		if ( ATKPLog::$logenabled ) {
			ATKPLog::LogDebug( 'existing thumbnailid: ' . $thumbnail . ', new thumbnailid: ' . $attach_id );
		}

		// And finally assign featured image to post
		set_post_thumbnail( $post_id, $attach_id );
	}

	public static function create_subshop( $title, $shopid, $programid, $parentid, $subshop ) {
		$args = array(
			'post_type'   => array( ATKP_SHOP_POSTTYPE ),
			'post_parent' => $parentid,
			'post_status' => array( 'publish', 'draft' ),
			'meta_query'  => array(
				'relation' => 'AND',
				array(
					'key'     => ATKP_SHOP_POSTTYPE . '_shopid',
					'value'   => $shopid,
					'compare' => '='
				),
				array(
					'key'     => ATKP_SHOP_POSTTYPE . '_programid',
					'value'   => $programid,
					'compare' => '='
				)
			)
		);

		$the_query = new WP_Query( $args );

		if ( $the_query->have_posts() ) {
			$the_query->the_post();
			$post_id = $the_query->post->ID;
			wp_reset_postdata();

			$my_post = array(
				'ID'          => $post_id,
				'post_title'  => $title,
				'post_status' => 'publish',
			);

			// Update the post into the database
			wp_update_post( $my_post );


			return $post_id;
		}

		global $user_ID;
		$new_post = array(
			'post_title'  => $title,
			'post_status' => 'publish',
			'post_author' => $user_ID,
			'post_type'   => ATKP_SHOP_POSTTYPE,
			'post_parent' => $parentid,
		);
		$post_id  = wp_insert_post( $new_post );

		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_shopid', $shopid );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_programid', $programid );

		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_access_webservice', ATKP_SUBSHOPTYPE );

		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customtitle', $subshop->customtitle );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customsmalllogourl', $subshop->customsmalllogourl );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customlogourl', $subshop->customlogourl );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customfield1', $subshop->customfield1 );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customfield2', $subshop->customfield2 );
		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_customfield3', $subshop->customfield3 );

		$subshops = array();
		array_push( $subshops, $subshop );

		ATKPTools::set_post_setting( $post_id, ATKP_SHOP_POSTTYPE . '_default_shops', $subshops );


		return $post_id;
	}

	public static function exists_cron_job( $hookParam = ATKP_EVENT, $output = false ) {
		//$cron = _get_cron_array();
		//$hook = wp_get_schedule( $hookParam );

		$crons  = _get_cron_array();
		$events = array();

		foreach ( $crons as $time => $cron ) {
			foreach ( $cron as $hook => $dings ) {
				foreach ( $dings as $sig => $data ) {
					if ( $hook == $hookParam ) {

						if ( $data['schedule'] ) {

							if ( $output ) {
								$localtime = get_date_from_gmt( date( 'Y-m-d H:i:s', $time ), get_option( 'time_format' ) );
								$localdate = get_date_from_gmt( date( 'Y-m-d H:i:s', $time ), get_option( 'date_format' ) );

								$text = '';
								$text .= ' ' . sprintf( __( 'Cronjob\'s next execution: %s %s', ATKP_PLUGIN_PREFIX ), $localdate, $localtime );
								$text .= ' (' . self::time_since( time(), $time ) . ')';
								$text .= ' Interval: ' . self::interval( isset( $data['interval'] ) ? $data['interval'] : null );

								echo $text;
							}

							return true;
						}
					}
				}
			}
		}

		if ( $output ) {
			echo __( 'cronjob is not running! Click the "Save Changes" button.', ATKP_PLUGIN_PREFIX );
		}

		return false;
	}

	public static function time_since( $older_date, $newer_date ) {
		return self::interval( $newer_date - $older_date );
	}

	public static function interval( $since ) {
		__( '%s years', ATKP_PLUGIN_PREFIX );
		__( '%s months', ATKP_PLUGIN_PREFIX );
		__( '%s weeks', ATKP_PLUGIN_PREFIX );
		__( '%s days', ATKP_PLUGIN_PREFIX );
		__( '%s hours', ATKP_PLUGIN_PREFIX );
		__( '%s minutes', ATKP_PLUGIN_PREFIX );
		__( '%s seconds', ATKP_PLUGIN_PREFIX );

		// array of time period chunks
		$chunks = array(
			array( 60 * 60 * 24 * 365, _n_noop( '%s year', '%s years', ATKP_PLUGIN_PREFIX ) ),
			array( 60 * 60 * 24 * 30, _n_noop( '%s month', '%s months', ATKP_PLUGIN_PREFIX ) ),
			array( 60 * 60 * 24 * 7, _n_noop( '%s week', '%s weeks', ATKP_PLUGIN_PREFIX ) ),
			array( 60 * 60 * 24, _n_noop( '%s day', '%s days', ATKP_PLUGIN_PREFIX ) ),
			array( 60 * 60, _n_noop( '%s hour', '%s hours', ATKP_PLUGIN_PREFIX ) ),
			array( 60, _n_noop( '%s minute', '%s minutes', ATKP_PLUGIN_PREFIX ) ),
			array( 1, _n_noop( '%s second', '%s seconds', ATKP_PLUGIN_PREFIX ) ),
		);

		if ( $since <= 0 ) {
			return __( 'now', ATKP_PLUGIN_PREFIX );
		}

		// we only want to output two chunks of time here, eg:
		// x years, xx months
		// x days, xx hours
		// so there's only two bits of calculation below:

		// step one: the first chunk
		for ( $i = 0, $j = count( $chunks ); $i < $j; $i ++ ) {
			$seconds = $chunks[ $i ][0];
			$name    = $chunks[ $i ][1];

			// finding the biggest chunk (if the chunk fits, break)
			if ( ( $count = floor( $since / $seconds ) ) != 0 ) {
				break;
			}
		}

		// set output var
		$output = sprintf( translate_nooped_plural( $name, $count, ATKP_PLUGIN_PREFIX ), $count );

		// step two: the second chunk
		if ( $i + 1 < $j ) {
			$seconds2 = $chunks[ $i + 1 ][0];
			$name2    = $chunks[ $i + 1 ][1];

			if ( ( $count2 = floor( ( $since - ( $seconds * $count ) ) / $seconds2 ) ) != 0 ) {
				// add to output var
				$output .= ' ' . sprintf( translate_nooped_plural( $name2, $count2, ATKP_PLUGIN_PREFIX ), $count2 );
			}
		}

		return $output;
	}


	public static function mix_colors( $basecolor, $mixcolor, $ratio, $addHash = true ) {
		if ( $basecolor == '' || $basecolor == null ) {
			return $basecolor;
		}


		$baseComponentOffset = strlen( $basecolor ) == 7 ? 1 : 0;
		$baseComponentRed    = hexdec( substr( $basecolor, $baseComponentOffset, 2 ) );
		$baseComponentGreen  = hexdec( substr( $basecolor, $baseComponentOffset + 2, 2 ) );
		$baseComponentBlue   = hexdec( substr( $basecolor, $baseComponentOffset + 4, 2 ) );

		$mixComponentOffset = strlen( $mixcolor ) == 7 ? 1 : 0;
		$mixComponentRed    = hexdec( substr( $mixcolor, $mixComponentOffset, 2 ) );
		$mixComponentGreen  = hexdec( substr( $mixcolor, $mixComponentOffset + 2, 2 ) );
		$mixComponentBlue   = hexdec( substr( $mixcolor, $mixComponentOffset + 4, 2 ) );

		$Rsum = $baseComponentRed + $mixComponentRed;
		$Gsum = $baseComponentGreen + $mixComponentGreen;
		$Bsum = $baseComponentBlue + $mixComponentBlue;

		$R = ( $baseComponentRed * ( 100 - $ratio ) + $mixComponentRed * $ratio ) / 100;
		$G = ( $baseComponentGreen * ( 100 - $ratio ) + $mixComponentGreen * $ratio ) / 100;
		$B = ( $baseComponentBlue * ( 100 - $ratio ) + $mixComponentBlue * $ratio ) / 100;

		$redPercentage   = max( $R, $G, $B ) > 255 ? $R / max( $Rsum, $Gsum, $Bsum ) : $R / 255;
		$greenPercentage = max( $R, $G, $B ) > 255 ? $G / max( $Rsum, $Gsum, $Bsum ) : $G / 255;
		$bluePercentage  = max( $R, $G, $B ) > 255 ? $B / max( $Rsum, $Gsum, $Bsum ) : $B / 255;

		$redRGB   = floor( 255 * $redPercentage );
		$greenRGB = floor( 255 * $greenPercentage );
		$blueRGB  = floor( 255 * $bluePercentage );

		$color = sprintf( "%02X%02X%02X", $redRGB, $greenRGB, $blueRGB );

		return $addHash ? '#' . $color : $color;
	}

	public static function check_taxonomy( $post_id, $taxonomyName, $taxonomyValue, $multimode = true ) {


		if ( $taxonomyValue == '' || $taxonomyValue == null ) {
			wp_set_object_terms( $post_id, null, $taxonomyName );

			return;
		}

		$taxonomyValues = array();

		if ( $multimode ) {
			$taxonomyValues = explode( ',', $taxonomyValue );
		} else if ( ! is_array( $taxonomyValue ) ) {
			array_push( $taxonomyValues, $taxonomyValue );
		} else {
			$taxonomyValues = $taxonomyValue;
		}

		$taxonomyValues = array_map( 'trim', $taxonomyValues );

		$cat_ids   = array();
		$parent_id = - 1;
		foreach ( $taxonomyValues as $taxonomyValue ) {
			if ( $taxonomyValue == '' ) {
				continue;
			}

			$termid = - 1;

			if ( ! term_exists( $taxonomyValue, $taxonomyName, $parent_id == - 1 ? null : $parent_id ) ) {

				if ( ! $multimode && $parent_id >= 0 ) {
					$term = wp_insert_term(
						$taxonomyValue, // the term
						$taxonomyName, // the taxonomy
						array( 'parent' => $parent_id )
					);
				} else {
					$term = wp_insert_term(
						$taxonomyValue, // the term
						$taxonomyName // the taxonomy
					);
				}

				if ( is_wp_error( $term ) ) {
					$error_string = $term->get_error_message();
					throw new Exception ( 'Term error: ' . $error_string );
				}

				$termid = intval( $term['term_id'] );
			} else {
				$term = null;
				if ( $parent_id >= 0 ) {
					$terms = get_term_children( $parent_id, $taxonomyName );

					foreach ( $terms as $termx ) {
						$termxf = get_term_by( 'id', $termx, $taxonomyName );


						if ( $termxf->name == $taxonomyValue || $taxonomyValue->slug == $taxonomyValue ) {
							$term = $termxf;
							break;
						}
					}

				}

				if ( $term == null ) {
					$term = get_term_by( 'name', $taxonomyValue, $taxonomyName );

					if ( ! $term ) {
						$term = get_term_by( 'slug', $taxonomyValue, $taxonomyName );
					}
				}

				if ( $term ) {
					$termid = $term->term_id;
				} //term_taxonomy_id

			}

			if ( $termid != - 1 ) {
				array_push( $cat_ids, $termid );
				$parent_id = $termid;
			}
		}

		$cat_ids = array_map( 'intval', $cat_ids );
		$cat_ids = array_unique( $cat_ids );

		$term_taxonomy_ids = wp_set_object_terms( $post_id, $cat_ids, $taxonomyName, false );

		if ( is_wp_error( $term_taxonomy_ids ) ) {
			$error_string = $term_taxonomy_ids->get_error_message();
			throw new Exception ( 'Term error: ' . $error_string );
			// There was an error somewhere and the terms couldn't be set.
			//TODO: logging
		} else {
			// Success! These categories were added to the post.
		}


	}


	public static function add_global_styles( $name ) {

		$output     = new atkp_output();
		$custom_css = $output->get_css_output();

		wp_add_inline_style( $name, $custom_css );
	}

	public static function add_global_scripts( $name ) {

		$output    = new atkp_output();
		$custom_js = $output->get_js_output();

		wp_add_inline_script( $name, $custom_js );
	}

	public static function write_global_scripts() {

		$output    = new atkp_output();
		$custom_js = $output->get_js_output();

		self::write_file( $custom_js, 'scripts.js' );
	}

	public static function write_global_styles() {

		$output    = new atkp_output();
		$custom_js = $output->get_css_output();

		self::write_file( $custom_js, 'styles.css' );
	}

	public static function get_global_style_url() {
		return self::get_file( 'styles.css' );
	}

	public static function get_global_script_url() {
		return self::get_file( 'scripts.js' );
	}

	public static function get_file( $name ) {
		$upload_dir = wp_upload_dir();

		if ( empty( $upload_dir['basedir'] ) ) {
			return null;
		}
		$user_dirname = $upload_dir['basedir'] . '/affiliate-toolkit';
		if ( ! file_exists( $user_dirname ) ) {
			return null;
		}

		$user_filename = $user_dirname . '/' . $name;

		if ( ! file_exists( $user_filename ) ) {
			return null;
		}

		return $upload_dir['baseurl'] . '/affiliate-toolkit' . '/' . $name;
	}

	public static function get_uploaddir() {
		$upload_dir = wp_upload_dir();

		if ( ! empty( $upload_dir['basedir'] ) ) {
			$user_dirname = $upload_dir['basedir'] . '/affiliate-toolkit';
			if ( ! file_exists( $user_dirname ) ) {
				wp_mkdir_p( $user_dirname );
			}
		}

		return $user_dirname;
	}

	public static function write_file( $content, $name ) {
		try {
			$user_dirname = self::get_uploaddir();

			file_put_contents( $user_dirname . '/' . $name, $content );
		} catch ( Exception $e ) {

		}
	}

	public static function add_column( $post_types, $label, $callback, $priority = 10 ) {
		if ( ! is_array( $post_types ) ) {
			$post_types = array( $post_types );
		}
		foreach ( $post_types as $post_type ) {
			$filter_name = 'manage_' . $post_type . '_posts_columns';

			add_filter( $filter_name, function ( $columns ) use ( $label, $priority ) {
				$key = sanitize_title( $label );
				$col = array( $key => $label );
				if ( $priority < 0 ) {
					return array_merge( $col, $columns );
				} else if ( $priority > count( $columns ) ) {
					return array_merge( $columns, $col );
				} else {
					$offset = $priority;
					$sorted = array_slice( $columns, 0, $offset, true ) + $col + array_slice( $columns, $offset, null, true );

					return $sorted;
				}
			}, $priority );

			add_action( 'manage_' . $post_type . '_posts_custom_column', function ( $col, $pid ) use ( $label, $callback ) {
				$key = sanitize_title( $label );
				if ( $col == $key ) {
					$callback( $pid );
				}
			}, $priority, 2 );
		}
	}

	public static function show_notice( $text, $class = 'updated' ) {
		if ( $class == 'yellow' ) {
			$class = 'updated';
		}
		if ( $class == 'red' ) {
			$class = 'error';
		}
		add_action( 'admin_notices', function () use ( $text, $class ) {
			echo '<div class="' . $class . '"><p>' . $text . '</p></div>';
		}, 1 );
	}


	public static function get_siteurl() {

		$url = 'unknown';

		if ( is_multisite() ) {
			$url = network_site_url();
		} else {
			$url = site_url();
		}

		return $url;
	}

	public static function get_endpointurl() {

		$url = admin_url( 'admin-ajax.php' );

		return $url;
	}

	public static function exists_get_parameter( $key ) {
		return isset( $_GET[ $key ] );
	}

	public static function get_get_parameter( $key, $type ) {
		$parametervalue = null;

		if ( isset( $_GET[ $key ] ) ) {
			$parametervalue = $_GET[ $key ];
		}

		return ATKPTools::get_casted_value( $parametervalue, $type );
	}

	public static function exists_post_parameter( $key ) {
		return isset( $_POST[ $key ] );
	}

	public static function get_post_parameter( $key, $type ) {
		$parametervalue = null;

		if ( isset( $_POST[ $key ] ) ) {
			$parametervalue = $_POST[ $key ];
		}

		return ATKPTools::get_casted_value( $parametervalue, $type );
	}

	public static function get_casted_value( $parametervalue, $type ) {

		switch ( $type ) {
			case 'bool':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return false;
				} else {
					//hack for older versions than 5.5
					if ( function_exists( 'boolval' ) ) {
						return boolval( $parametervalue );
					} else {
						return (bool) $parametervalue;
					}
				}
				break;
			case 'intarray':
				if ( $parametervalue == null || ! is_array( $parametervalue ) ) {
					return 0;
				} else {
					return array_map( 'intval', $parametervalue );
				}
				break;
			case 'int':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return 0;
				} else {
					return intval( $parametervalue );
				}
				break;
			case 'double':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return 0;
				} else {
					return floatval( $parametervalue );
				}
				break;
			case 'stringarray':
				if ( $parametervalue == null || ! is_array( $parametervalue ) ) {
					return 0;
				} else {
					return array_map( 'sanitize_text_field', $parametervalue );
				}
				break;
			case 'string':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return '';
				} else {
					return sanitize_text_field( $parametervalue );
				}
				break;
			case 'multistring2':
			case 'multistring':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return '';
				} else {
					return implode( "\n", array_map( 'sanitize_text_field', (array) explode( "\n", (string) $parametervalue ) ) );
				}
				break;
			case 'allhtml':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return '';
				} else {
					return ( $parametervalue );
				}
				break;
			case 'html':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return '';
				} else {
					return wp_kses_post( $parametervalue );
				}

				break;
			case 'url':
				if ( $parametervalue == null || $parametervalue == '' ) {
					return '';
				} else {
					return sanitize_text_field( $parametervalue );
				}
				break;
			default:
				throw new exception( 'type unkown: ' . $type );
		}
	}


	/**
	 * Lädt ein Metafield von einem Post nach Key/Feldname
	 *
	 * @param int $post_id Die Post-ID von welchem das Metafield geladen werden soll
	 * @param string $key Der Name des Metafields
	 *
	 * @return mixed|string Gibt entweder einen Leerstring oder das gespeicherte Objekt zurück
	 */
	public static function get_post_setting( $post_id, $key ) {
		$value = get_post_meta( $post_id, $key );

		if ( isset( $value ) && is_array( $value ) && count( $value ) > 0 ) {
			return $value[0];
		} else {
			return '';
		}
	}


	/**
	 * Schreibt ein Metafield von einem Post
	 *
	 * @param int $post_id Die Post-ID von welchem das Metafield geladen werden soll
	 * @param string $key Der Name des Metafields
	 * @param mixed $value Der Wert des Metafields
	 */
	public static function set_post_setting( $post_id, $key, $value ) {

		delete_post_meta( $post_id, $key );
		if ( $value != null ) {
			add_post_meta( $post_id, $key, $value );
		}

	}

	public static function set_setting( $key, $value ) {

		delete_option( $key );

		add_option( $key, $value );

	}

	public static function get_setting( $key, $defaultvalue = null ) {

		$value = get_option( $key );

		if ( isset( $value ) ) {
			return $value;
		} else {
			return $defaultvalue;
		}
	}

	public static function delete_all_options() {
		global $wpdb;

		$plugin_options = $wpdb->get_results( "SELECT option_name FROM $wpdb->options WHERE option_name LIKE '" . ATKP_PLUGIN_PREFIX . "_%'" );

		foreach ( $plugin_options as $option ) {
			delete_option( $option->option_name );
		}
	}

	public static function str_contains( $string, $searchstring, $caseSensitive = true ) {

		if ( $caseSensitive ) {
			if ( strpos( $string, $searchstring ) !== false ) {
				return true;
			} else {
				return false;
			}
		} else {
			if ( stripos( $string, $searchstring ) !== false ) {
				return true;
			} else {
				return false;
			}
		}
	}

	public static function startsWith( $haystack, $needle ) {
		// search backwards starting from haystack length characters from the end
		return $needle === "" || strrpos( $haystack, $needle, - strlen( $haystack ) ) !== false;
	}

	public static function price_to_float( $s ) {
		//$s = str_replace( ',', '.', $s );

		// remove everything except numbers and dot "."
		//$s = preg_replace( "/[^0-9\.]/", "", $s );

		// remove all seperators from first part and keep the end
		//$s = str_replace( '.', '', substr( $s, 0, - 3 ) ) . substr( $s, - 3 );

		$f = self::strToFloat( $s ); //(float) $s

		// return float
		return round( $f, 2 );
	}

	private static function strToFloat( $str ) {
		$str = preg_replace('[^0-9\,\.\-\+]', '', strval($str));
		$str = strtr($str, ',', '.');
		$pos = strrpos($str, '.');
		return ($pos===false ? floatval($str) : floatval(str_replace('.', '', substr($str, 0, $pos)) . substr($str, $pos)));
	}

	public static function clear_string( $string ) {
		if ( $string == '' ) {
			return '';
		}

		// Strip HTML Tags
		$clear = strip_tags( $string );
// Clean up things like &amp;
		$clear = html_entity_decode( $clear );
// Strip out any url-encoded stuff
		$clear = urldecode( $clear );
// Replace non-AlNum characters with space
		//$clear = preg_replace('/[^A-Za-z0-9(),]/', ' ', $clear);
// Replace Multiple spaces with single space
		$clear = preg_replace( '/ +/', ' ', $clear );
// Trim the string of leading/trailing space
		$clear = trim( $clear );

		return $clear;
	}

	public static function casttoclass( $class, $object ) {
		return unserialize( preg_replace( '/^O:\d+:"[^"]++"/', 'O:' . strlen( $class ) . ':"' . $class . '"', serialize( $object ) ) );
	}


}