User_Webshop

Introduction

Webshop is located on an old TERENA webserver

ssh godzilla.terena.org
cd /pub/www/www.terena.org/webshop

Invoicing is provided by GÉANT and the code for this is on:

/usr/local/share/php/Webshop

Payment is provided by DocData and the code to communicate to the DocData PSP can be found in the file:

/usr/local/share/php/DocData.class.php

Adding products

We only support INTERNAL GEANT Ltd users.

• Send users to this page first to collect the right information: Requesting a Webshop Product
• Sign in to the webshop server and connect to the db:

ssh godzilla.terena.org
sudo su - postgres
psql webshop

• Insert the new product into the database with a simple SQL statement: 

INSERT into products (product_name, unit_price, tax_rate, deadline, quantifiable, prereg_only) values ('TRANSITS I, 22-24 Nov 2017, Prague, nc, na', 925, 21, '2017-12-12 00:00:00', 'f', 't');

Replace the values with the values that you received from the person requesting the product.
• Check if products have been inserted and get their respective id's: select * from products order by inserted desc;