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