/********************************************************
Zdravo svima,
U tabeli ispod je suma koliko je svaki radnik nabrao nekog proizvoda.
Moze li se ovakav prikaz dobiti samo pomoću SQL-a, ako dođe još jedan proizvod da se automatski uključi, to također važi i za novog radnika
PS: inace radim nesto u php-u, i rijesio sam to kroz petlje i vise upita...
********************************************************/
| radnik | proizvod1 | proizvod2 | proizvod3 |itd |
+-----------+-----------+-----------+-------------------+
| ImePrezime| 12 | 21 | 1 | 68 |
+-----------+-----------+-----------+-----------+-------+
| ImePrezime| 23 | 16 | 44 | 18 |
+-----------+-----------+-----------+-----------+-------+
| ImePrezime| 17 | 19 | 33 | 28 |
+-----------+-----------+-----------+-----------+-------+
| ImePrezime| 17 | 33 | 4 | 18 |
+-----------+-----------+-----------+-----------+-------+
/*tabela radnik*/
CREATE TABLE `radnik` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naziv` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
INSERT INTO `radnik` VALUES ('1', 'ImePrezime1');
INSERT INTO `radnik` VALUES ('2', 'ImePrezime2');
INSERT INTO `radnik` VALUES ('3', 'ImePrezime3');
INSERT INTO `radnik` VALUES ('4', 'ImePrezime4');
INSERT INTO `radnik` VALUES ('6', 'ImePrezime5');
/*tabela proizvod*/
CREATE TABLE `proizvod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naziv` varchar(255) NOT NULL,
`tezina` double(7,3) NOT NULL DEFAULT '0.000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
INSERT INTO `proizvod` VALUES ('1', 'Proizvod 1', '0.350');
INSERT INTO `proizvod` VALUES ('2', 'Proizvod 2', '2.000');
INSERT INTO `proizvod` VALUES ('3', 'Proizvod 3', '0.350');
INSERT INTO `proizvod` VALUES ('4', 'Proizvod 4', '0.350');
/*tabela magacin*/
CREATE TABLE `magacin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`radnik_id` int(11) NOT NULL,
`proizvod_id` int(11) NOT NULL,
`kolicina` double(10,3) NOT NULL DEFAULT '0.000'
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
INSERT INTO `magacin` VALUES ('1', '1', '1', '0.350');
INSERT INTO `magacin` VALUES ('2', '1', '1', '0.350');
INSERT INTO `magacin` VALUES ('3', '1', '2', '2.000');
INSERT INTO `magacin` VALUES ('4', '1', '1', '0.350');
INSERT INTO `magacin` VALUES ('5', '1', '2', '2.000');
INSERT INTO `magacin` VALUES ('6', '1', '4', '0.350');
INSERT INTO `magacin` VALUES ('7', '2', '1', '0.350');
INSERT INTO `magacin` VALUES ('8', '2', '3', '0.350');
INSERT INTO `magacin` VALUES ('9', '2', '4', '0.700');
INSERT INTO `magacin` VALUES ('10', '2', '4', '0.350');
INSERT INTO `magacin` VALUES ('11', '3', '1', '0.350');
INSERT INTO `magacin` VALUES ('12', '3', '3', '0.350');
INSERT INTO `magacin` VALUES ('13', '3', '3', '0.350');
INSERT INTO `magacin` VALUES ('14', '3', '3', '0.350');
INSERT INTO `magacin` VALUES ('15', '3', '4', '1.050');
INSERT INTO `magacin` VALUES ('16', '3', '4', '0.700');
INSERT INTO `magacin` VALUES ('17', '4', '1', '0.350');
INSERT INTO `magacin` VALUES ('18', '4', '1', '0.350');
INSERT INTO `magacin` VALUES ('19', '4', '3', '0.350');
INSERT INTO `magacin` VALUES ('20', '4', '4', '0.350');
INSERT INTO `magacin` VALUES ('35', '2', '1', '0.350');
INSERT INTO `magacin` VALUES ('36', '3', '1', '0.350');
INSERT INTO `magacin` VALUES ('37', '4', '1', '0.350');