{"id":45,"date":"2018-08-20T14:15:04","date_gmt":"2018-08-20T14:15:04","guid":{"rendered":"https:\/\/dapliw.wordpress.com\/?p=45"},"modified":"2018-08-20T14:15:04","modified_gmt":"2018-08-20T14:15:04","slug":"cakephp-3-pasar-un-array-de-opciones-a-una-consulta-de-la-base-de-datos","status":"publish","type":"post","link":"https:\/\/saemas.com\/sitio_web\/cakephp-3-pasar-un-array-de-opciones-a-una-consulta-de-la-base-de-datos\/","title":{"rendered":"Cakephp 3 – Pasar un array de opciones a una consulta de la base de datos"},"content":{"rendered":"

En el controlador, cuando se llama a la funci\u00f3n de consulta se agrega el array. Ejemplo:<\/p>\n

$query = $employeepayments->find('payroll', ['idPaysheet' => $idPaysheet]);<\/pre>\n
Y en table:<\/p>\n
public function findPayroll(Query $query, array $options)\n{\n   $query\n   ->where([['paysheet_id' => $options['idPaysheet']];\n\n   return $query;\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"
En el controlador, cuando se llama a la funci\u00f3n de consulta se agrega el array. Ejemplo: $query = $employeepayments->find(‘payroll’, [‘idPaysheet’ => $idPaysheet]); Y en table: public function findPayroll(Query $query, array $options) { $query ->where([[‘paysheet_id’ => $options[‘idPaysheet’]]; return $query; }<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"material-hide-sections":[],"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-45","post","type-post","status-publish","format-standard","hentry","category-cakephp","tag-cakephp"],"_links":{"self":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/comments?post=45"}],"version-history":[{"count":0,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/45\/revisions"}],"wp:attachment":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/media?parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/categories?post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/tags?post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}