You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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;




  • No labels