insideout10 / wordlift-plugin

	 *

	 * @return string|null The post ID or NULL if there are no posts to synchronize.

	 */

	public function next() {

		global $wpdb;

		// Limit the query to the allowed post types.

		$post_type_in = implode( "','", array_map( 'esc_sql', \Wordlift_Entity_Service::valid_entity_post_types() ) );

		// Get the next post ID.

		return $wpdb->get_var( "

			SELECT p.ID

				FROM $wpdb->posts p

				LEFT JOIN $wpdb->postmeta pm

					ON pm.post_id = p.ID

						AND pm.meta_key = '_wl_synced_gmt'				

				WHERE p.post_status = 'publish'

					AND p.post_type IN ( '$post_type_in' )

					AND ( pm.meta_value IS NULL OR pm.meta_value < p.post_modified_gmt )

				ORDER BY p.post_modified_gmt DESC

				LIMIT 1

			" );

	}

	public function count() {

		global $wpdb;

			" );

	}

	public function count() {

		global $wpdb;

		$post_type_in = implode( "','", array_map( 'esc_sql', \Wordlift_Entity_Service::valid_entity_post_types() ) );

		return $wpdb->get_var( "

			SELECT COUNT( 1 )

				FROM $wpdb->posts p

				LEFT JOIN $wpdb->postmeta pm

					ON pm.post_id = p.ID

						AND pm.meta_key = '_wl_synced_gmt'				

				WHERE p.post_status = 'publish'

					AND p.post_type IN ( '$post_type_in' )

					AND ( pm.meta_value IS NULL OR pm.meta_value < p.post_modified_gmt )

			" );

	}

	public function info() {

		return Sync_Background_Process::get_state();