Magento 2 Documentation  2.3
Documentation for Magento 2 CMS v2.3 (December 2018)
NotSyncedOrderIdListProvider.php
Go to the documentation of this file.
1 <?php
7 
11 
16 {
20  private $caseEntity;
21 
25  public function __construct(
26  CaseEntity $caseEntity
27  ) {
28  $this->caseEntity = $caseEntity;
29  }
30 
34  public function getIds($mainTableName, $gridTableName)
35  {
36  $connection = $this->caseEntity->getConnection();
37  $select = $connection->select()
38  ->from($this->caseEntity->getMainTable(), ['order_id'])
39  ->joinLeft(
40  [$gridTableName => $connection->getTableName($gridTableName)],
41  sprintf(
42  '%s.%s = %s.%s',
43  $this->caseEntity->getMainTable(),
44  'order_id',
45  $gridTableName,
46  'entity_id'
47  ),
48  []
49  )
50  ->where('guarantee_disposition != signifyd_guarantee_status');
51 
52  return $connection->fetchAll($select, [], \Zend_Db::FETCH_COLUMN);
53  }
54 }
const FETCH_COLUMN
Definition: Db.php:147
$connection
Definition: bulk.php:13