Never5\DownloadMonitor\Shop\Order\WordPressRepository::retrieve()

Complexity

Conditions	9
Paths	96

Size

Total Lines	89
Code Lines	49

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function retrieve( $filters = array(), $limit = 0, $offset = 0, $order_by = 'id', $order = 'DESC' ) {
		global $wpdb;

		// prep order
		$order_by = ( empty( $order_by ) ) ? 'id' : esc_sql( $order_by );

The function esc_sql was not found. Maybe you did not declare it correctly or list all dependencies?

		$order    = strtoupper( $order );
		if ( ! in_array( $order, array( 'ASC', 'DESC' ) ) ) {
			$order = 'DESC';
		}

		// prep where statement
		$where_str = $this->prep_where_statement( $filters );

		$sql = "
		SELECT O.*, C.* 
		FROM `" . $wpdb->prefix . "dlm_order` O
		INNER JOIN `" . $wpdb->prefix . "dlm_order_customer` C ON O.id=C.order_id
		" . $where_str . "
		ORDER BY O.`" . $order_by . "` " . $order;

		$limit  = absint( $limit );

The function absint was not found. Maybe you did not declare it correctly or list all dependencies?

		$offset = absint( $offset );

		if ( $limit > 0 ) {
			$sql .= " LIMIT " . $limit;
		}

		if ( $offset > 0 ) {
			$sql .= " OFFSET " . $offset;
		}

		$sql .= ";";

		// try to fetch session from database
		$results = $wpdb->get_results( $sql );

		// check if result if found
		if ( null === $results ) {
			throw new \Exception( 'SQL error while fetching order' );
		}

		// array that will hold all order objects
		$orders = array();

		foreach ( $results as $result ) {

			$order = new Order();

			$order->set_id( $result->id );
			$order->set_status( Services::get()->service( 'order_status_factory' )->make( $result->status ) );
			$order->set_currency( $result->currency );
			$order->set_hash( $result->hash );

			if ( ! empty( $result->date_created ) ) {
				$order->set_date_created( new \DateTimeImmutable( $result->date_created ) );
			}

			if ( ! empty( $result->date_modified ) ) {
				$order->set_date_modified( new \DateTimeImmutable( $result->date_modified ) );
			}

			// create and set customer
			$order->set_customer( new OrderCustomer(
				$result->first_name,
				$result->last_name,
				$result->company,
				$result->address_1,
				$result->address_2,
				$result->city,
				$result->state,
				$result->postcode,
				$result->country,
				$result->email,
				$result->phone,
				$result->ip_address
			) );

			// add order items to order object
			$order = $this->add_order_items_to_order( $order );

			// add transactions to order object
			$order = $this->add_transactions_to_order( $order );

			// add new order object to array
			$orders[] = $order;

		}

		return $orders;

}