Sandwich Order

Owned by svitlana (Deactivated)
Last updated: Jul 04, 2018
1 min read



Introduction





The sandwich order is an example where orders can be entered, using a list of possible menu choices.





Screenshots





Grid configuration



gd.columns=line, sandwich, requester,number gd.table=sandwichOrder ds.gridds.connection.type=mysql ds.gridds.connection.url=jdbc:mysql://charlie:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false ds.gridds.connection.username=igrid_tester ds.gridds.connection.password=igrid_tester col.line=Line col.line.type=sequence col.line.sequencePrefix=LINE- col.line.width=50 col.sandwich=What sandwich col.sandwich.type=list col.sandwich.query=select name from sandwich_menu order by name col.sandwich.query.ds=gridds col.sandwich.required=true col.sandwich.width=200 col.sandwich.autocomplete=false col.requester=For whom col.requester.type=string col.number=Count col.number.type=integer



SQL Setup



Use following sql to create a table and populate the sandwich menu table.



- -- Table structure for table `sandwich_menu` -- DROP TABLE IF EXISTS `sandwich_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sandwich_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(45) DEFAULT NULL, `Price` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sandwich_menu` -- LOCK TABLES `sandwich_menu` WRITE; /*!40000 ALTER TABLE `sandwich_menu` DISABLE KEYS */; INSERT INTO `sandwich_menu` VALUES (1,'Lemon pepper chicken',1.95),(2,'Chicken tikka with minted mayo',1.95),(3,'Chicken and bacon',1.95),(4,'Cajun chicken',1.95),(5,'Chinese chicken',1.95),(6,'BBQ chicken',1.95),(7,'Mexican chicken',1.95),(8,'Tuna mayo',1.65),(9,'Tuna crunch',1.85),(10,'Egg mayo',1.5),(11,'Egg mayo & crispy bacon',1.95),(12,'Prawn & marie rose sauce',2.2),(13,'Cheese',1.3),(14,'Cheese mix',1.6),(15,'Ham',1.8),(16,'Beef',1.8),(17,'Corned beef',1.8),(18,'Turkey',1.8); /*!40000 ALTER TABLE `sandwich_menu` ENABLE KEYS */; UNLOCK TABLES;



See also



//