samedi 28 décembre 2019

How can i write query in laravel with where clause?

Store below json record in database table field 'contact_info'

{
  "invoice":{
    "number":"gthy",
    "invoiceDate":"2019-12-25 17:20:08",
    "invoiceDueDate":"2020-01-01 17:20:08",
    "paymentTerms":"7"
  },
  "company":{
    "name":"Test ",
    "address":"Test",
    "city":"Test",
    "state":"Test",
    "country":"Test",
    "pincode":"Test",
    "email":"Test@gmail.com",
    "currency_code":"USD"
  },
  "sender":{
    "name":"Test",
    "address":"Test",
    "city":"Test",
    "state":"Test",
    "country":"Test",
    "pincode":"Test",
    "email":"Test"
  }
}

I need to applied where condition with 'invoiceDueDate' this field in Laravel. So how can i write query for this? Please suggest me.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire