"wheres": {
"condition": "AND",
"rules": [
{
"id": "tbl_locker_master.IsActive",
"field": "tbl_locker_master.IsActive",
"type": "double",
"operator": "equal",
"value": "1",
"data": {
"table": "tbl_locker_master",
"column": "IsActive",
"type": "number"
},
"operation": "="
},
{
"id": "tbl_locker_master.Cabinet",
"field": "tbl_locker_master.Cabinet",
"type": "string",
"operator": "equal",
"value": "CB1",
"data": {
"table": "tbl_locker_master",
"column": "Cabinet",
"type": "text"
},
"operation": "="
},
{
"condition": "OR",
"rules": [
{
"condition": "AND",
"rules": [
{
"id": "lkm.IsActive",
"field": "lkm.IsActive",
"type": "double",
"operator": "equal",
"value": "1",
"data": {
"table": "lkm",
"column": "IsActive",
"type": "number"
},
"operation": "="
},
{
"id": "lkm.ToSwap",
"field": "lkm.ToSwap",
"type": "double",
"operator": "equal",
"value": "0",
"data": {
"table": "lkm",
"column": "ToSwap",
"type": "number"
},
"operation": "="
}
],
"conditional": null
},
{
"condition": "AND",
"rules": [
{
"id": "lkm.IsActive",
"field": "lkm.IsActive",
"type": "double",
"operator": "equal",
"value": "0",
"data": {
"table": "lkm",
"column": "IsActive",
"type": "number"
},
"operation": "="
},
{
"id": "lkm.ToSwap",
"field": "lkm.ToSwap",
"type": "double",
"operator": "equal",
"value": "1",
"data": {
"table": "lkm",
"column": "ToSwap",
"type": "number"
},
"operation": "="
}
],
"conditional": ""
}
],
"conditional": null
}
],
"conditional": null,
"valid": true
}
PHP and MySQL - Yes.