Magento2 ⋆ 100% Private Proxies - Fast, Anonymous, Quality, Unlimited USA Private Proxy!

Magento2: Google Slide Integration

I am new with google slides. I want to install/make use of google slides in magento2.

How to integrate google slides in magento2?

I refer to https://developers.google.com/slides/how-tos/overview but not able to get proper idea regarding installation in magento2. I am using Magento2.2.5.

Can you provide me some tutorial or guide ?

How to write a Conditional Selection SQL QUERY in Magento2?

$  collection->getSelect()->where($  getMainTableAlias.'.entity_id IN (SELECT catText.entity_id FROM '.$  catalogCategoryEntityTextTable.' as catText where catText.attribute_id="'.$  attributeId.'" AND  FIND_IN_SET("'.$  groupId.'", catText.value) GROUP BY   catText.entity_id)');

I have this query. I have to remove the first where clause so as to avoid any filters but the rest will remain same. How can I perform this task?

Magento2: Admin grid

How to create the grid and form in magento2?

I want to create the admin grid and form with button actions in magento2

How to do this?

Thanks.

Magento2: How to display most view product collection in home page?

I need to display product collection in home page in magento2.

Thanks.

How to get Geo IP of customer in magento2?

I want to get the customer geo IP in magento2. I used some third party calls but If I enable proxy means that thing is not working. How can I get the original customer IP in magento2 anybody has idea means please tell me.

I referred this one but in proxy, it’s not working, magento 2 : Track country with ip address

Magento2 How to query value in catalog_eav_attribute?

I’ve added a new value in catalog_eav_attribute, similar to Use for Promo Rule Conditions or Used in Product Listing. How do I call that property of the attribute in a phtml view template?

For example it’s called my_custom_field and I want to test for it to be true or false, like:

    <div class="additional-attributes-wrapper table-wrapper">         <table class="data table additional-attributes" id="product-attribute--specs-table">             <caption class="table-caption"><?= /* @escapeNotVerified */ __('More Information') ?></caption>             <tbody>             <?php foreach ($  _additional as $  _data): ?>                 <?php if($  _data['my_custom_field']): ?>  //this code is where I need to check if the attribute's property is true or false                     <tr>                         <th class="col label" scope="row"><?= $  block->escapeHtml(__($  _data['label'])) ?></th>                         <td class="col data" data-th="<?= $  block->escapeHtml(__($  _data['label'])) ?>">                           <?php echo  /* @escapeNotVerified */ $  _helper->productAttribute($  _product, $  _data['value'], $  _data['code']);?>                         </td>                     </tr>                 <?php endif;?>             <?php endforeach; ?>             </tbody>         </table>     </div> <?php endif;?>

I get an error of “Error filtering template: Notice: Undefined index: my_custom_field” when the template is called.

This is how I created the attribute property: Magento 2 Load database value to custom field in product attribute

How to get customer id , customer firstname with customer_account_edited event ? Magento2

event.xml

 <?xml version="1.0" encoding="UTF-8"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">     <event name="customer_account_edited">         <observer name="customer_customer_account_edited" instance="Customer\CustomerAccountEdit\Observer\CustomerAccountEdit"/>     </event> </config>

CustomerAccountEdit.php

<?php namespace Customer\CustomerAccountEdit\Observer;  use Magento\Framework\Event\Observer as EventObserver; use Magento\Framework\Event\ObserverInterface;   class CustomerAccountEdit implements ObserverInterface {     protected $  _request;     protected $  _layout;     protected $  _objectManager = null;     protected $  _customerGroup;      /**      * @param \Magento\Framework\ObjectManagerInterface $  objectManager      */     public function __construct(         \Magento\Framework\View\Element\Context $  context,         \Magento\Framework\ObjectManagerInterface $  objectManager     ) {         $  this->_layout = $  context->getLayout();         $  this->_request = $  context->getRequest();         $  this->_objectManager = $  objectManager;     }      /**      * @param \Magento\Framework\Event\Observer $  observer      * @return void      */     public function execute(EventObserver $  observer)     {         $  event = $  observer->getEvent();         $  customer = $  event->getCustomer();         $  email = $  customer->getEmail();         $  id = $  customer->getId();         print_r($  customer->debug());     } }

Result.

Fatal error: Uncaught Error: Call to a member function getEmail() on null in ...

Magento2 display sender name, recipient name,recipient email in admin gift card grid

I need to display sender name, recipient name, recipient email in admin gift card grid. This is default module of enterprise.

This sender name, recipient name, recipient email values are coming from product_options.

After adding sender name, recipient name, recipient email columns search filter should work in admin

Magento2: How can solve this error “{“error”:”invalid_grant”} ” on product save by admin?

When I am saving product by admin then it is showing error “{“error”:”invalid_grant”}” and product is not showing in frontend also. How can resolve this?

enter image description here

How to Customise Header for guest and logged in user in magento2 programmatically?

I want different top header section for guest and login user.

Guest user header option

“Hi Guest” + sign-in option

Login user header option

“Hi [User Name]”

How do I perform it programmatically?