+global\WPS_Mass_List_Table::request()

Complexity

Conditions	13
Paths	1536

Size

Total Lines	169
Code Lines	108

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function request( $id_post = null ) {
		global $wpdb;
		$per_page = $this->get_items_per_page( $this->screen->get_option( 'per_page', 'option' ) );
		$include_states = array(
			'publish',
			'future',
			'draft',
			'pending',
			'private',
			'trash',
			'scheduled',
		);
		$include_states = implode( "','", $include_states );
		$post_types = implode( "','", $this->_post_types );
		$orderby = isset( $_REQUEST['orderby'] ) ? esc_sql( $_REQUEST['orderby'] ) : 'p.post_date'; // WPCS: CSRF ok.
		$order = isset( $_REQUEST['order'] ) ? esc_sql( strtoupper( $_REQUEST['order'] ) ) : 'DESC'; // WPCS: CSRF ok.
		$cast = isset( $_REQUEST['cast'] ) ? esc_sql( $_REQUEST['cast'] ) : ''; // WPCS: CSRF ok.
		$cast = strtoupper( $cast );
		$s = isset( $_REQUEST['s'] ) ? esc_sql( $_REQUEST['s'] ) : ''; // WPCS: CSRF ok.
		$exclude_attribute_codes = implode( "','", $this->exclude_attribute_codes );
		$items_count = $wpdb->prepare( "SELECT FOUND_ROWS() FROM {$wpdb->posts} WHERE 1 = %d", 1 );
		$true = true;
		if ( $true ) { // FOUND_ROWS incompatibilities ?
			$items_count = $wpdb->prepare(
				"SELECT COUNT(*)
				FROM {$wpdb->posts} p
				INNER JOIN {$wpdb->postmeta} AS PM ON PM.post_id = p.ID AND PM.meta_key = '_wpshop_product_attribute_set_id' AND PM.meta_value LIKE %s
				WHERE p.post_status IN ( '{$include_states}' )
				AND p.post_type IN ( '{$post_types}' )
				AND p.post_title LIKE %s",
				$this->request_current_view(),
				"%{$s}%"
			);
		}
		$wpsdb_attribute = WPSHOP_DBT_ATTRIBUTE;
		$wpsdb_attribute_set = WPSHOP_DBT_ATTRIBUTE_DETAILS;
		$wpsdb_unit = WPSHOP_DBT_ATTRIBUTE_UNIT;
		$wpsdb_values_decimal = WPSHOP_DBT_ATTRIBUTE_VALUES_DECIMAL;
		$wpsdb_values_datetime = WPSHOP_DBT_ATTRIBUTE_VALUES_DATETIME;
		$wpsdb_values_integer = WPSHOP_DBT_ATTRIBUTE_VALUES_INTEGER;
		$wpsdb_values_varchar = WPSHOP_DBT_ATTRIBUTE_VALUES_VARCHAR;
		$wpsdb_values_text = WPSHOP_DBT_ATTRIBUTE_VALUES_TEXT;
		$wpsdb_values_options = WPSHOP_DBT_ATTRIBUTE_VALUES_OPTIONS;
		$extra_select = '';
		if ( ! in_array( $orderby, apply_filters( 'wps_mass_list_custom_orderby', array( 'title', 'ID', 'thumbnail', 'p.post_date' ) ), true ) ) {
			$extra_select = "SELECT GROUP_CONCAT( IFNULL( val_dec1.value,
				IFNULL( val_dat1.value,
					IFNULL( val_tex1.value,
						IFNULL( val_var1.value,
							IFNULL( val_opt1.value,
								val_int1.value
							)
						)
					)
				)
			) SEPARATOR ' ' )
			FROM {$wpdb->posts} p1
			LEFT JOIN {$wpsdb_attribute} attr1 ON attr1.status = 'valid' AND attr1.code = '{$orderby}'
			LEFT JOIN {$wpsdb_values_decimal} val_dec1 ON val_dec1.attribute_id = attr1.id AND val_dec1.entity_id = p1.ID
			LEFT JOIN {$wpsdb_values_datetime} val_dat1 ON val_dat1.attribute_id = attr1.id AND val_dat1.entity_id = p1.ID
			LEFT JOIN {$wpsdb_values_integer} val_int1 ON val_int1.attribute_id = attr1.id AND val_int1.entity_id = p1.ID
			LEFT JOIN {$wpsdb_values_text} val_tex1 ON val_tex1.attribute_id = attr1.id AND val_tex1.entity_id = p1.ID
			LEFT JOIN {$wpsdb_values_varchar} val_var1 ON val_var1.attribute_id = attr1.id AND val_var1.entity_id = p1.ID
			LEFT JOIN {$wpsdb_values_options} val_opt1 ON val_opt1.attribute_id = attr1.id AND val_opt1.id = val_int1.value
			WHERE p1.ID = p.ID";
			$extra_select = "( {$extra_select} )";
			if ( ! empty( $cast ) ) {
				$extra_select = "CAST( {$extra_select} AS {$cast} )";
			}
			$extra_select = ",
			{$extra_select} AS {$orderby}";
		}
		if ( 'thumbnail' === $orderby ) {
			$ids = $wpdb->get_col( $wpdb->prepare(
				"SELECT CAST( pm.post_id AS SIGNED INTEGER ) as col
				FROM {$wpdb->postmeta} pm
				JOIN {$wpdb->posts} p ON pm.post_id = p.ID AND p.post_type IN ( '{$post_types}' )
				WHERE pm.meta_key = %s
				AND pm.meta_value != %d
				ORDER BY pm.meta_value {$order}",
				'_thumbnail_id',
				0
			) );
			$ids = implode( ', ', $ids );
			$orderby = "FIELD( p.ID, {$ids} )";
		}
		$orderby = apply_filters( 'wps_mass_list_custom_orderby_query', $orderby );
		$extra = "GROUP BY p.ID
		ORDER BY {$orderby} {$order}
		LIMIT %d, %d";
		if ( ! is_null( $id_post ) ) {
			$id_post = intval( $id_post );
			$extra = "AND p.ID = {$id_post}";
			$s = '';
		}
		$wpdb->query(
			$wpdb->prepare( 'SET SESSION group_concat_max_len = %d', 1000000 )
		);
		$datas = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT SQL_CALC_FOUND_ROWS
				p.ID,
				p.post_title as title,
				p.post_parent as parent,
				p.post_status as status,
				p.post_type as type,
				p.post_date as pdate,
				GROUP_CONCAT(
					CONCAT(
						attr.id, '&amp;',
						attr.code, '&amp;',
						attr.frontend_label, '&amp;',
						CONCAT(
							IFNULL( val_dec.value, '' ),
							IFNULL( val_dat.value, '' ),
							IFNULL( val_int.value, '' ),
							IFNULL( val_tex.value, '' ),
							IFNULL( val_var.value, '' )
						), '&amp;',
						attr.is_requiring_unit, '&amp;',
						IFNULL( unit.unit, '' ), '&amp;',
						attr.backend_input, '&amp;',
						attr.data_type
					) SEPARATOR '&data;'
				) as data{$extra_select}
				FROM {$wpdb->posts} p
				INNER JOIN {$wpdb->postmeta} postmeta ON postmeta.post_id = p.ID AND postmeta.meta_key = %s AND postmeta.meta_value = %d
				LEFT JOIN {$wpsdb_attribute_set} attr_set ON attr_set.status = 'valid' AND attr_set.entity_type_id = %d AND attr_set.attribute_set_id = %d
				LEFT JOIN {$wpsdb_attribute} attr ON attr.status = 'valid' AND attr.entity_id = %d AND attr.code NOT IN ( '{$exclude_attribute_codes}' ) AND attr.id = attr_set.attribute_id
				LEFT JOIN {$wpsdb_values_decimal} val_dec ON val_dec.attribute_id = attr.id AND val_dec.entity_id = p.ID
				LEFT JOIN {$wpsdb_values_datetime} val_dat ON val_dat.attribute_id = attr.id AND val_dat.entity_id = p.ID
				LEFT JOIN {$wpsdb_values_integer} val_int ON val_int.attribute_id = attr.id AND val_int.entity_id = p.ID
				LEFT JOIN {$wpsdb_values_text} val_tex ON val_tex.attribute_id = attr.id AND val_tex.entity_id = p.ID
				LEFT JOIN {$wpsdb_values_varchar} val_var ON val_var.attribute_id = attr.id AND val_var.entity_id = p.ID
				LEFT JOIN {$wpsdb_unit} unit ON (
					unit.id = val_dec.unit_id
					OR unit.id = val_dat.unit_id
					OR unit.id = val_int.unit_id
					OR unit.id = val_tex.unit_id
					OR unit.id = val_var.unit_id
				)
				WHERE p.post_status IN ( '{$include_states}' )
				AND p.post_type IN ( '{$post_types}' )
				AND p.post_title LIKE %s
				{$extra}",
				WPSHOP_PRODUCT_ATTRIBUTE_SET_ID_META_KEY,
				$this->request_current_view(),
				$this->entity_id,
				$this->request_current_view(),
				$this->entity_id,
				'%' . $s . '%',
				( $this->get_pagenum() -1 ) * $per_page,
				$per_page
			),
			ARRAY_A
		);
		if ( ! is_array( $datas ) ) {
			$datas = array();
		}
		if ( ! isset( $this->_pagination_args['total_items'] ) && ! isset( $this->_pagination_args['per_page'] ) ) {
			$this->set_pagination_args(
				array(
					'total_items' => (int) $wpdb->get_var( $items_count ),
					'per_page' => $this->get_items_per_page( $this->screen->get_option( 'per_page', 'option' ) ),
				)
			);
		}
		return array_map( array( $this, 'data_reorganize' ), $datas );
	}
	/**