Jump to content

Creación de Web Service desde modulo y mostrar tabla en Web Service


carlosCardenas

Recommended Posts

Hola soy nuevo en lo de los modulos de prestashop y pues mi especialidad es en wp pero debido a un cliente que tenemos nos pidió la pareacion con wp a Prestashop en cuanto al manejo de una información. que solicito?

 

no solicita que los usuarios se logen desde wp con la información de la DB de prestashop, debido a que en mi caso nosotros no administramos la plataforma de prestashop to tengo aceso a la base de datos ni a usuario y contraseña, lo ucal los colegas que lo manejan indican que por razones de cuidado y por que la plataforma esta en periodo de prueba no suministran esa informacion("en lo personal me parese una culad"). entoses para alargar el proceso me indicaron que creara un modulo que se en ganchara con un hook y me daria el acceso, de eso no encontré información de como realizar este procedimiento, por lo cual me decidi por la segunda que era crear un web service y consumir el servicio des mi wp, pero para crear el ws("Web Service") no hay informacion dentro de un modulo revisando la DB encontre el punto donde se crean los ws y envie la informacion para crear mi ws y en efecto lo puede crear, pero mi problema persistio cuando no me mostraba una pequeña tabla que cree para poder almasenar la informacion de mi cookye_key el cual es vital para la autenticacion en mi wp neseciti validar como hacer para que pueda ver mi pequeña tabla y la informcaion que contiene aunque no este por default en el web service para consumir la informacion y proceguir en mi proyecto

 

perdomenen los errores de ortografia, pero no tengo mucho tiempo para esto, agradesco de su colaboracion.

 

mi codigo de cuando creo los permisos de mi web service:

 

 

Db::getInstance()->execute("INSERT INTO `ps_webservice_permission` ( `resource`, `method`, `id_webservice_account`) VALUES
( 'addresses', 'GET', ".$this->idLista."),
( 'addresses', 'POST', ".$this->idLista."),
( 'addresses', 'PUT', ".$this->idLista."),
( 'addresses', 'DELETE', ".$this->idLista."),
( 'addresses', 'HEAD', ".$this->idLista."),
( 'carriers', 'GET', ".$this->idLista."),
( 'carriers', 'POST', ".$this->idLista."),
( 'carriers', 'PUT', ".$this->idLista."),
( 'carriers', 'DELETE', ".$this->idLista."),
( 'carriers', 'HEAD', ".$this->idLista."),
( 'carts', 'GET', ".$this->idLista."),
( 'carts', 'POST', ".$this->idLista."),
( 'carts', 'PUT', ".$this->idLista."),
( 'carts', 'DELETE', ".$this->idLista."),
( 'carts', 'HEAD', ".$this->idLista."),
( 'cart_rules', 'GET', ".$this->idLista."),
( 'cart_rules', 'POST', ".$this->idLista."),
( 'cart_rules', 'PUT', ".$this->idLista."),
( 'cart_rules', 'DELETE', ".$this->idLista."),
( 'cart_rules', 'HEAD', ".$this->idLista."),
( 'categories', 'GET', ".$this->idLista."),
( 'categories', 'POST', ".$this->idLista."),
( 'categories', 'PUT', ".$this->idLista."),
( 'categories', 'DELETE', ".$this->idLista."),
( 'categories', 'HEAD', ".$this->idLista."),
( 'combinations', 'GET', ".$this->idLista."),
( 'combinations', 'POST', ".$this->idLista."),
( 'combinations', 'PUT', ".$this->idLista."),
( 'combinations', 'DELETE', ".$this->idLista."),
( 'combinations', 'HEAD', ".$this->idLista."),
( 'configurations', 'GET', ".$this->idLista."),
( 'configurations', 'POST', ".$this->idLista."),
( 'configurations', 'PUT', ".$this->idLista."),
( 'configurations', 'DELETE', ".$this->idLista."),
( 'configurations', 'HEAD', ".$this->idLista."),
( 'contacts', 'GET', ".$this->idLista."),
( 'contacts', 'POST', ".$this->idLista."),
( 'contacts', 'PUT', ".$this->idLista."),
( 'contacts', 'DELETE', ".$this->idLista."),
( 'contacts', 'HEAD', ".$this->idLista."),
( 'content_management_system', 'GET', ".$this->idLista."),
( 'content_management_system', 'POST', ".$this->idLista."),
( 'content_management_system', 'PUT', ".$this->idLista."),
( 'content_management_system', 'DELETE', ".$this->idLista."),
( 'content_management_system', 'HEAD', ".$this->idLista."),
( 'countries', 'GET', ".$this->idLista."),
( 'countries', 'POST', ".$this->idLista."),
( 'countries', 'PUT', ".$this->idLista."),
( 'countries', 'DELETE', ".$this->idLista."),
( 'countries', 'HEAD', ".$this->idLista."),
( 'currencies', 'GET', ".$this->idLista."),
( 'currencies', 'POST', ".$this->idLista."),
( 'currencies', 'PUT', ".$this->idLista."),
( 'currencies', 'DELETE', ".$this->idLista."),
( 'currencies', 'HEAD', ".$this->idLista."),
( 'customers', 'GET', ".$this->idLista."),
( 'customers', 'POST', ".$this->idLista."),
( 'customers', 'PUT', ".$this->idLista."),
( 'customers', 'DELETE', ".$this->idLista."),
( 'customers', 'HEAD', ".$this->idLista."),
( 'customer_messages', 'GET', ".$this->idLista."),
( 'customer_messages', 'POST', ".$this->idLista."),
( 'customer_messages', 'PUT', ".$this->idLista."),
( 'customer_messages', 'DELETE', ".$this->idLista."),
( 'customer_messages', 'HEAD', ".$this->idLista."),
( 'customer_threads', 'GET', ".$this->idLista."),
( 'customer_threads', 'POST', ".$this->idLista."),
( 'customer_threads', 'PUT', ".$this->idLista."),
( 'customer_threads', 'DELETE', ".$this->idLista."),
( 'customer_threads', 'HEAD', ".$this->idLista."),
( 'deliveries', 'GET', ".$this->idLista."),
( 'deliveries', 'POST', ".$this->idLista."),
( 'deliveries', 'PUT', ".$this->idLista."),
( 'deliveries', 'DELETE', ".$this->idLista."),
( 'deliveries', 'HEAD', ".$this->idLista."),
( 'employees', 'GET', ".$this->idLista."),
( 'employees', 'POST', ".$this->idLista."),
( 'employees', 'PUT', ".$this->idLista."),
( 'employees', 'DELETE', ".$this->idLista."),
( 'employees', 'HEAD', ".$this->idLista."),
( 'groups', 'GET', ".$this->idLista."),
( 'groups', 'POST', ".$this->idLista."),
( 'groups', 'PUT', ".$this->idLista."),
( 'groups', 'DELETE', ".$this->idLista."),
( 'groups', 'HEAD', ".$this->idLista."),
( 'guests', 'GET', ".$this->idLista."),
( 'guests', 'POST', ".$this->idLista."),
( 'guests', 'PUT', ".$this->idLista."),
( 'guests', 'DELETE', ".$this->idLista."),
( 'guests', 'HEAD', ".$this->idLista."),
( 'images', 'GET', ".$this->idLista."),
( 'images', 'POST', ".$this->idLista."),
( 'images', 'PUT', ".$this->idLista."),
( 'images', 'DELETE', ".$this->idLista."),
( 'images', 'HEAD', ".$this->idLista."),
( 'image_types', 'GET', ".$this->idLista."),
( 'image_types', 'POST', ".$this->idLista."),
( 'image_types', 'PUT', ".$this->idLista."),
( 'image_types', 'DELETE', ".$this->idLista."),
( 'image_types', 'HEAD', ".$this->idLista."),
( 'languages', 'GET', ".$this->idLista."),
( 'languages', 'POST', ".$this->idLista."),
( 'languages', 'PUT', ".$this->idLista."),
( 'languages', 'DELETE', ".$this->idLista."),
( 'languages', 'HEAD', ".$this->idLista."),
( 'manufacturers', 'GET', ".$this->idLista."),
( 'manufacturers', 'POST', ".$this->idLista."),
( 'manufacturers', 'PUT', ".$this->idLista."),
( 'manufacturers', 'DELETE', ".$this->idLista."),
( 'manufacturers', 'HEAD', ".$this->idLista."),
( 'orders', 'GET', ".$this->idLista."),
( 'orders', 'POST', ".$this->idLista."),
( 'orders', 'PUT', ".$this->idLista."),
( 'orders', 'DELETE', ".$this->idLista."),
( 'orders', 'HEAD', ".$this->idLista."),
( 'order_carriers', 'GET', ".$this->idLista."),
( 'order_carriers', 'POST', ".$this->idLista."),
( 'order_carriers', 'PUT', ".$this->idLista."),
( 'order_carriers', 'DELETE', ".$this->idLista."),
( 'order_carriers', 'HEAD', ".$this->idLista."),
( 'order_details', 'GET', ".$this->idLista."),
( 'order_details', 'POST', ".$this->idLista."),
( 'order_details', 'PUT', ".$this->idLista."),
( 'order_details', 'DELETE', ".$this->idLista."),
( 'order_details', 'HEAD', ".$this->idLista."),
( 'order_discounts', 'GET', ".$this->idLista."),
( 'order_discounts', 'POST', ".$this->idLista."),
( 'order_discounts', 'PUT', ".$this->idLista."),
( 'order_discounts', 'DELETE', ".$this->idLista."),
( 'order_discounts', 'HEAD', ".$this->idLista."),
( 'order_histories', 'GET', ".$this->idLista."),
( 'order_histories', 'POST', ".$this->idLista."),
( 'order_histories', 'PUT', ".$this->idLista."),
( 'order_histories', 'DELETE', ".$this->idLista."),
( 'order_histories', 'HEAD', ".$this->idLista."),
( 'order_invoices', 'GET', ".$this->idLista."),
( 'order_invoices', 'POST', ".$this->idLista."),
( 'order_invoices', 'PUT', ".$this->idLista."),
( 'order_invoices', 'DELETE', ".$this->idLista."),
( 'order_invoices', 'HEAD', ".$this->idLista."),
( 'order_payments', 'GET', ".$this->idLista."),
( 'order_payments', 'POST', ".$this->idLista."),
( 'order_payments', 'PUT', ".$this->idLista."),
( 'order_payments', 'DELETE', ".$this->idLista."),
( 'order_payments', 'HEAD', ".$this->idLista."),
( 'order_slip', 'GET', ".$this->idLista."),
( 'order_slip', 'POST', ".$this->idLista."),
( 'order_slip', 'PUT', ".$this->idLista."),
( 'order_slip', 'DELETE', ".$this->idLista."),
( 'order_slip', 'HEAD', ".$this->idLista."),
( 'order_states', 'GET', ".$this->idLista."),
( 'order_states', 'POST', ".$this->idLista."),
( 'order_states', 'PUT', ".$this->idLista."),
( 'order_states', 'DELETE', ".$this->idLista."),
( 'order_states', 'HEAD', ".$this->idLista."),
( 'price_ranges', 'GET', ".$this->idLista."),
( 'price_ranges', 'POST', ".$this->idLista."),
( 'price_ranges', 'PUT', ".$this->idLista."),
( 'price_ranges', 'DELETE', ".$this->idLista."),
( 'price_ranges', 'HEAD', ".$this->idLista."),
( 'products', 'GET', ".$this->idLista."),
( 'products', 'POST', ".$this->idLista."),
( 'products', 'PUT', ".$this->idLista."),
( 'products', 'DELETE', ".$this->idLista."),
( 'products', 'HEAD', ".$this->idLista."),
( 'product_features', 'GET', ".$this->idLista."),
( 'product_features', 'POST', ".$this->idLista."),
( 'product_features', 'PUT', ".$this->idLista."),
( 'product_features', 'DELETE', ".$this->idLista."),
( 'product_features', 'HEAD', ".$this->idLista."),
( 'product_feature_values', 'GET', ".$this->idLista."),
( 'product_feature_values', 'POST', ".$this->idLista."),
( 'product_feature_values', 'PUT', ".$this->idLista."),
( 'product_feature_values', 'DELETE', ".$this->idLista."),
( 'product_feature_values', 'HEAD', ".$this->idLista."),
( 'product_options', 'GET', ".$this->idLista."),
( 'product_options', 'POST', ".$this->idLista."),
( 'product_options', 'PUT', ".$this->idLista."),
( 'product_options', 'DELETE', ".$this->idLista."),
( 'product_options', 'HEAD', ".$this->idLista."),
( 'product_option_values', 'GET', ".$this->idLista."),
( 'product_option_values', 'POST', ".$this->idLista."),
( 'product_option_values', 'PUT', ".$this->idLista."),
( 'product_option_values', 'DELETE', ".$this->idLista."),
( 'product_option_values', 'HEAD', ".$this->idLista."),
( 'product_suppliers', 'GET', ".$this->idLista."),
( 'product_suppliers', 'HEAD', ".$this->idLista."),
( 'search', 'GET', ".$this->idLista."),
( 'search', 'HEAD', ".$this->idLista."),
( 'shops', 'GET', ".$this->idLista."),
( 'shops', 'POST', ".$this->idLista."),
( 'shops', 'PUT', ".$this->idLista."),
( 'shops', 'DELETE', ".$this->idLista."),
( 'shops', 'HEAD', ".$this->idLista."),
( 'shop_groups', 'GET', ".$this->idLista."),
( 'shop_groups', 'POST', ".$this->idLista."),
( 'shop_groups', 'PUT', ".$this->idLista."),
( 'shop_groups', 'DELETE', ".$this->idLista."),
( 'shop_groups', 'HEAD', ".$this->idLista."),
( 'shop_urls', 'GET', ".$this->idLista."),
( 'shop_urls', 'POST', ".$this->idLista."),
( 'shop_urls', 'PUT', ".$this->idLista."),
( 'shop_urls', 'DELETE', ".$this->idLista."),
( 'shop_urls', 'HEAD', ".$this->idLista."),
( 'specific_prices', 'GET', ".$this->idLista."),
( 'specific_prices', 'POST', ".$this->idLista."),
( 'specific_prices', 'PUT', ".$this->idLista."),
( 'specific_prices', 'DELETE', ".$this->idLista."),
( 'specific_prices', 'HEAD', ".$this->idLista."),
( 'specific_price_rules', 'GET', ".$this->idLista."),
( 'specific_price_rules', 'POST', ".$this->idLista."),
( 'specific_price_rules', 'PUT', ".$this->idLista."),
( 'specific_price_rules', 'DELETE', ".$this->idLista."),
( 'specific_price_rules', 'HEAD', ".$this->idLista."),
( 'states', 'GET', ".$this->idLista."),
( 'states', 'POST', ".$this->idLista."),
( 'states', 'PUT', ".$this->idLista."),
( 'states', 'DELETE', ".$this->idLista."),
( 'states', 'HEAD', ".$this->idLista."),
( 'stocks', 'GET', ".$this->idLista."),
( 'stocks', 'HEAD', ".$this->idLista."),
( 'stock_availables', 'GET', ".$this->idLista."),
( 'stock_availables', 'PUT', ".$this->idLista."),
( 'stock_availables', 'HEAD', ".$this->idLista."),
( 'stock_movements', 'GET', ".$this->idLista."),
( 'stock_movements', 'HEAD', ".$this->idLista."),
( 'stock_movement_reasons', 'GET', ".$this->idLista."),
( 'stock_movement_reasons', 'POST', ".$this->idLista."),
( 'stock_movement_reasons', 'PUT', ".$this->idLista."),
( 'stock_movement_reasons', 'DELETE', ".$this->idLista."),
( 'stock_movement_reasons', 'HEAD', ".$this->idLista."),
( 'stores', 'GET', ".$this->idLista."),
( 'stores', 'POST', ".$this->idLista."),
( 'stores', 'PUT', ".$this->idLista."),
( 'stores', 'DELETE', ".$this->idLista."),
( 'stores', 'HEAD', ".$this->idLista."),
( 'suppliers', 'GET', ".$this->idLista."),
( 'suppliers', 'POST', ".$this->idLista."),
( 'suppliers', 'PUT', ".$this->idLista."),
( 'suppliers', 'DELETE', ".$this->idLista."),
( 'suppliers', 'HEAD', ".$this->idLista."),
( 'supply_orders', 'GET', ".$this->idLista."),
( 'supply_orders', 'HEAD', ".$this->idLista."),
( 'supply_order_details', 'GET', ".$this->idLista."),
( 'supply_order_details', 'HEAD', ".$this->idLista."),
( 'supply_order_histories', 'GET', ".$this->idLista."),
( 'supply_order_histories', 'HEAD', ".$this->idLista."),
( 'supply_order_receipt_histories', 'GET', ".$this->idLista."),
( 'supply_order_receipt_histories', 'HEAD', ".$this->idLista."),
( 'supply_order_states', 'GET', ".$this->idLista."),
( 'supply_order_states', 'HEAD', ".$this->idLista."),
( 'tags', 'GET', ".$this->idLista."),
( 'tags', 'POST', ".$this->idLista."),
( 'tags', 'PUT', ".$this->idLista."),
( 'tags', 'DELETE', ".$this->idLista."),
( 'tags', 'HEAD', ".$this->idLista."),
( 'taxes', 'GET', ".$this->idLista."),
( 'taxes', 'POST', ".$this->idLista."),
( 'taxes', 'PUT', ".$this->idLista."),
( 'taxes', 'DELETE', ".$this->idLista."),
( 'taxes', 'HEAD', ".$this->idLista."),
( 'tax_rules', 'GET', ".$this->idLista."),
( 'tax_rules', 'POST', ".$this->idLista."),
( 'tax_rules', 'PUT', ".$this->idLista."),
( 'tax_rules', 'DELETE', ".$this->idLista."),
( 'tax_rules', 'HEAD', ".$this->idLista."),
( 'tax_rule_groups', 'GET', ".$this->idLista."),
( 'tax_rule_groups', 'POST', ".$this->idLista."),
( 'tax_rule_groups', 'PUT', ".$this->idLista."),
( 'tax_rule_groups', 'DELETE', ".$this->idLista."),
( 'tax_rule_groups', 'HEAD', ".$this->idLista."),
( 'translated_configurations', 'GET', ".$this->idLista."),
( 'translated_configurations', 'POST', ".$this->idLista."),
( 'translated_configurations', 'PUT', ".$this->idLista."),
( 'translated_configurations', 'DELETE', ".$this->idLista."),
( 'translated_configurations', 'HEAD', ".$this->idLista."),
( 'warehouses', 'GET', ".$this->idLista."),
( 'warehouses', 'POST', ".$this->idLista."),
( 'warehouses', 'PUT', ".$this->idLista."),
( 'warehouses', 'HEAD', ".$this->idLista."),
( 'warehouse_product_locations', 'GET', ".$this->idLista."),
( 'warehouse_product_locations', 'HEAD', ".$this->idLista."),
( 'weight_ranges', 'GET', ".$this->idLista."),
( 'weight_ranges', 'POST', ".$this->idLista."),
( 'weight_ranges', 'PUT', ".$this->idLista."),
( 'weight_ranges', 'DELETE', ".$this->idLista."),
( 'weight_ranges', 'HEAD', ".$this->idLista."),
( 'zones', 'GET', ".$this->idLista."),
( 'zones', 'POST', ".$this->idLista."),
( 'zones', 'PUT', ".$this->idLista."),
( 'zones', 'DELETE', ".$this->idLista."),
( 'zones', 'HEAD', ".$this->idLista."),
( 'aclienteswps', 'GET', ".$this->idLista."), esta es mi tabla
( 'aclienteswps', 'POST', ".$this->idLista."), esta es mi tabla
( 'aclienteswps', 'PUT', ".$this->idLista."), esta es mi tabla
( 'aclienteswps', 'DELETE', ".$this->idLista."), esta es mi tabla

( 'aclienteswps', 'HEAD', ".$this->idLista.");"); esta es mi tabla

Link to comment
Share on other sites

  • nadie locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...