PHP Magento\Sales\Model\ResourceModel\Order\Grid Collection Examples

Example #1

File: QueryModifier.php Project: praxigento/mobi_mod_mage2_pv

 public function populateSelect(\Magento\Sales\Model\ResourceModel\Order\Grid\Collection $collection)
 {
     $select = $collection->getSelect();
     /* LEFT JOIN `prxgt_pv_sale` */
     $tbl = [self::AS_TBL_PV_SALES => $this->_resource->getTableName(Sale::ENTITY_NAME)];
     $on = self::AS_TBL_PV_SALES . '.' . Sale::ATTR_SALE_ID . '=main_table.' . Cfg::E_SALE_ORDER_A_ENTITY_ID;
     $cols = [self::AS_FLD_PV_TOTAL => Sale::ATTR_TOTAL, self::AS_FLD_PV_DISCOUNT => Sale::ATTR_DISCOUNT, self::AS_FLD_PV_SUBTOTAL => Sale::ATTR_SUBTOTAL];
     $select->joinLeft($tbl, $on, $cols);
 }

Example #2

File: QueryModifier.php Project: praxigento/mobi_mod_mage2_odoo

 public function populateSelect(\Magento\Sales\Model\ResourceModel\Order\Grid\Collection $collection)
 {
     $select = $collection->getSelect();
     /* LEFT JOIN `prxgt_odoo_sale` */
     $tbl = [self::AS_TBL_ODOO_SALE => $this->_resource->getTableName(SaleOrder::ENTITY_NAME)];
     $on = self::AS_TBL_ODOO_SALE . '.' . SaleOrder::ATTR_MAGE_REF . '=main_table.' . Cfg::E_SALE_ORDER_A_ENTITY_ID;
     $exp = new Expression('!ISNULL(' . self::AS_TBL_ODOO_SALE . '.' . SaleOrder::ATTR_MAGE_REF . ')');
     $cols = [self::AS_FLD_IS_IN_ODOO => $exp];
     $select->joinLeft($tbl, $on, $cols);
     return $select;
 }