{"val":true,"info":{"products":{"drinks":{"type_product":[{"0":"1","id_type_product":"1","1":"Cerveza","type_product":"Cerveza","2":"drinks","table_name":"drinks","3":"id_drink","main_id":"id_drink","4":"1","estatus":"1","5":"2020-08-21 20:02:43","fecha_hora":"2020-08-21 20:02:43","6":"2021-07-29 11:19:23","last_update":"2021-07-29 11:19:23","7":"2","enum_code_app":"2"}],"sql":["SELECT gen.id_drink, gen.stock,gen.precio,gen.id_size_drink, (SELECT sec.nombre FROM drinks sec WHERE sec.id_drink=gen.id_drink) AS nombre,(SELECT sec.descripcion FROM drinks sec WHERE sec.id_drink=gen.id_drink) AS descripcion,(SELECT sec.position FROM drinks sec WHERE sec.id_drink=gen.id_drink) AS position,(SELECT sec.id_type_drink FROM drinks sec WHERE sec.id_drink=gen.id_drink) AS id_type_drink, (SELECT msd.size FROM merge_size_drink msd WHERE msd.id_drink=gen.id_drink AND gen.id_size_drink=msd.id_size_drink) AS size, (SELECT sec.url FROM merge_size_drink sec WHERE sec.id_drink=gen.id_drink AND gen.id_size_drink=sec.id_size_drink) AS url FROM price_stock_drinks gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"pomos":{"type_product":[{"0":"2","id_type_product":"2","1":"Botella","type_product":"Botella","2":"pomos","table_name":"pomos","3":"id_pomo","main_id":"id_pomo","4":"1","estatus":"1","5":"2020-08-21 20:02:43","fecha_hora":"2020-08-21 20:02:43","6":"2021-07-29 11:19:25","last_update":"2021-07-29 11:19:25","7":"8","enum_code_app":"8"}],"sql":["SELECT gen.id_pomo,gen.stock,gen.precio, (SELECT sec.nombre FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS nombre,(SELECT sec.position FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS position,(SELECT sec.descripcion FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS descripcion,(SELECT sec.size FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS size,(SELECT sec.descripcion FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS _size,(SELECT sec.url FROM pomos sec WHERE sec.id_pomo=gen.id_pomo) AS url FROM price_stock_pomos gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"snacks":{"type_product":[{"0":"3","id_type_product":"3","1":"Botanas","type_product":"Botanas","2":"snacks","table_name":"snacks","3":"id_snack","main_id":"id_snack","4":"1","estatus":"1","5":"2020-08-25 17:02:35","fecha_hora":"2020-08-25 17:02:35","6":"2021-07-29 11:19:28","last_update":"2021-07-29 11:19:28","7":"5","enum_code_app":"5"}],"sql":["SELECT gen.id_snack,gen.stock,gen.precio, (SELECT sec.nombre FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS nombre,(SELECT sec.position FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS position,(SELECT sec.descripcion FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS descripcion,(SELECT sec.size FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS size,(SELECT sec.descripcion FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS _size,(SELECT sec.url FROM snacks sec WHERE sec.id_snack=gen.id_snack) AS url FROM price_stock_snacks gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"sodas":{"type_product":[{"0":"4","id_type_product":"4","1":"Refrescos","type_product":"Refrescos","2":"sodas","table_name":"sodas","3":"id_soda","main_id":"id_soda","4":"1","estatus":"1","5":"2020-08-25 17:02:35","fecha_hora":"2020-08-25 17:02:35","6":"2021-07-29 11:19:29","last_update":"2021-07-29 11:19:29","7":"4","enum_code_app":"4"}],"sql":["SELECT gen.id_soda,gen.stock,gen.precio, (SELECT sec.nombre FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS nombre,(SELECT sec.position FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS position,(SELECT sec.descripcion FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS descripcion,(SELECT sec.size FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS size,(SELECT sec.descripcion FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS _size,(SELECT sec.url FROM sodas sec WHERE sec.id_soda=gen.id_soda) AS url FROM price_stock_sodas gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"foods":{"type_product":[{"0":"5","id_type_product":"5","1":"Alimentos","type_product":"Alimentos","2":"foods","table_name":"foods","3":"id_food","main_id":"id_food","4":"1","estatus":"1","5":"2020-08-25 17:03:13","fecha_hora":"2020-08-25 17:03:13","6":"2021-07-29 11:19:33","last_update":"2021-07-29 11:19:33","7":"6","enum_code_app":"6"}],"sql":["SELECT gen.id_food,gen.stock,gen.precio, (SELECT sec.nombre FROM foods sec WHERE sec.id_food=gen.id_food) AS nombre,(SELECT sec.position FROM foods sec WHERE sec.id_food=gen.id_food) AS position,(SELECT sec.descripcion FROM foods sec WHERE sec.id_food=gen.id_food) AS descripcion,(SELECT sec.size FROM foods sec WHERE sec.id_food=gen.id_food) AS size,(SELECT sec.descripcion FROM foods sec WHERE sec.id_food=gen.id_food) AS _size,(SELECT sec.url FROM foods sec WHERE sec.id_food=gen.id_food) AS url FROM price_stock_foods gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"packages":{"type_product":[{"0":"6","id_type_product":"6","1":"Paquetes","type_product":"Paquetes","2":"packages","table_name":"packages","3":"id_package","main_id":"id_package","4":"1","estatus":"1","5":"2020-08-26 11:25:43","fecha_hora":"2020-08-26 11:25:43","6":"2021-07-29 11:19:35","last_update":"2021-07-29 11:19:35","7":"7","enum_code_app":"7"}],"sql":["SELECT gen.id_package,gen.stock,gen.precio, (SELECT sec.nombre FROM packages sec WHERE sec.id_package=gen.id_package) AS nombre,(SELECT sec.position FROM packages sec WHERE sec.id_package=gen.id_package) AS position,(SELECT sec.descripcion FROM packages sec WHERE sec.id_package=gen.id_package) AS descripcion,(SELECT sec.size FROM packages sec WHERE sec.id_package=gen.id_package) AS size,(SELECT sec.descripcion FROM packages sec WHERE sec.id_package=gen.id_package) AS _size,(SELECT sec.url FROM packages sec WHERE sec.id_package=gen.id_package) AS url FROM price_stock_packages gen WHERE gen.estatus=1 AND gen.id_sucursal="]},"extras":{"type_product":[{"0":"7","id_type_product":"7","1":"Extras","type_product":"Extras","2":"extras","table_name":"extras","3":"id_extra","main_id":"id_extra","4":"1","estatus":"1","5":"2021-07-29 11:20:15","fecha_hora":"2021-07-29 11:20:15","6":"0000-00-00 00:00:00","last_update":"0000-00-00 00:00:00","7":"10","enum_code_app":"10"}],"sql":["SELECT gen.id_extra,gen.stock,gen.precio, (SELECT sec.nombre FROM extras sec WHERE sec.id_extra=gen.id_extra) AS nombre,(SELECT sec.position FROM extras sec WHERE sec.id_extra=gen.id_extra) AS position,(SELECT sec.descripcion FROM extras sec WHERE sec.id_extra=gen.id_extra) AS descripcion,(SELECT sec.size FROM extras sec WHERE sec.id_extra=gen.id_extra) AS size,(SELECT sec.descripcion FROM extras sec WHERE sec.id_extra=gen.id_extra) AS _size,(SELECT sec.url FROM extras sec WHERE sec.id_extra=gen.id_extra) AS url FROM price_stock_extras gen WHERE gen.estatus=1 AND gen.id_sucursal="]}},"type_products":[{"0":"1","id_type_product":"1","1":"Cerveza","type_product":"Cerveza","2":"drinks","table_name":"drinks","3":"id_drink","main_id":"id_drink","4":"1","estatus":"1","5":"2020-08-21 20:02:43","fecha_hora":"2020-08-21 20:02:43","6":"2021-07-29 11:19:23","last_update":"2021-07-29 11:19:23","7":"2","enum_code_app":"2"},{"0":"2","id_type_product":"2","1":"Botella","type_product":"Botella","2":"pomos","table_name":"pomos","3":"id_pomo","main_id":"id_pomo","4":"1","estatus":"1","5":"2020-08-21 20:02:43","fecha_hora":"2020-08-21 20:02:43","6":"2021-07-29 11:19:25","last_update":"2021-07-29 11:19:25","7":"8","enum_code_app":"8"},{"0":"3","id_type_product":"3","1":"Botanas","type_product":"Botanas","2":"snacks","table_name":"snacks","3":"id_snack","main_id":"id_snack","4":"1","estatus":"1","5":"2020-08-25 17:02:35","fecha_hora":"2020-08-25 17:02:35","6":"2021-07-29 11:19:28","last_update":"2021-07-29 11:19:28","7":"5","enum_code_app":"5"},{"0":"4","id_type_product":"4","1":"Refrescos","type_product":"Refrescos","2":"sodas","table_name":"sodas","3":"id_soda","main_id":"id_soda","4":"1","estatus":"1","5":"2020-08-25 17:02:35","fecha_hora":"2020-08-25 17:02:35","6":"2021-07-29 11:19:29","last_update":"2021-07-29 11:19:29","7":"4","enum_code_app":"4"},{"0":"5","id_type_product":"5","1":"Alimentos","type_product":"Alimentos","2":"foods","table_name":"foods","3":"id_food","main_id":"id_food","4":"1","estatus":"1","5":"2020-08-25 17:03:13","fecha_hora":"2020-08-25 17:03:13","6":"2021-07-29 11:19:33","last_update":"2021-07-29 11:19:33","7":"6","enum_code_app":"6"},{"0":"6","id_type_product":"6","1":"Paquetes","type_product":"Paquetes","2":"packages","table_name":"packages","3":"id_package","main_id":"id_package","4":"1","estatus":"1","5":"2020-08-26 11:25:43","fecha_hora":"2020-08-26 11:25:43","6":"2021-07-29 11:19:35","last_update":"2021-07-29 11:19:35","7":"7","enum_code_app":"7"},{"0":"7","id_type_product":"7","1":"Extras","type_product":"Extras","2":"extras","table_name":"extras","3":"id_extra","main_id":"id_extra","4":"1","estatus":"1","5":"2021-07-29 11:20:15","fecha_hora":"2021-07-29 11:20:15","6":"0000-00-00 00:00:00","last_update":"0000-00-00 00:00:00","7":"10","enum_code_app":"10"}]}}