GitLab

Bitte die Einheiten nicht mehr fix codiert sondern aus der Tabelle units übernehmen (in Produktion schon eingespielt). Es gibt auch 2 Produkttypen: Miete oder Ware

CREATE TABLE units (
 seq_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 utype VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci,
 # (PRODUCT,RENT)
 ftranslation_seq_id INT(11)
);
ALTER TABLE units ADD FOREIGN KEY (ftranslation_seq_id) REFERENCES translation(seq_id);

#$scope.rentunits = [
#{unit:'SM',name:'Mietstunde'},
#{unit:'TM',name:'Miettage'},
#{unit:'WM',name:'Mietwochen'},
#{unit:'MM',name:'Mietmonat'}];

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('SM', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Mietstunde',createdAt FROM translation WHERE keyword = 'SM'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'RENT',seq_id FROM translation WHERE keyword = 'SM';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('TM', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Miettage',createdAt FROM translation WHERE keyword = 'TM'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'RENT',seq_id FROM translation WHERE keyword = 'TM';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('WM', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Mietwochen',createdAt FROM translation WHERE keyword = 'WM'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'RENT',seq_id FROM translation WHERE keyword = 'WM';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('MM', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Mietmonate',createdAt FROM translation WHERE keyword = 'MM'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'RENT',seq_id FROM translation WHERE keyword = 'MM';

#$scope.productunits = [
#{unit:'l',name:'Liter'},{unit:'g',name:'Gramm'},
#{unit:'kg',name:'Kilogramm'},{unit:'stk',name:'Stueck'},
#{unit:'hB',name:'Beratungsstunde'},{unit:'hT',name:'Transportstunde'},
#{unit:'hA',name:'Ausfuehrungsstunde'},
#{unit: 'ml',name: 'Milliliter'}

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('l', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Liter',createdAt FROM translation WHERE keyword = 'l'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'l';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('ml', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Milliliter',createdAt FROM translation WHERE keyword = 'ml'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'ml';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('g', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Gramm',createdAt FROM translation WHERE keyword = 'g'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'g';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('kg', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Kiloramm',createdAt FROM translation WHERE keyword = 'kg'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'kg';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('stk', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Stueck',createdAt FROM translation WHERE keyword = 'stk'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'stk';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('hB', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Beratungsstunde',createdAt FROM translation WHERE keyword = 'hB'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'hB';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('hT', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Transportstunde',createdAt FROM translation WHERE keyword = 'hT'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'hT';

INSERT INTO translation(`keyword`, `createdAt`) VALUES ('hA', NOW());
INSERT INTO translation_lang(`ftranslation_seq_id`, `flang_seq_id`, `langword`, `createdAt`) 
SELECT seq_id,1,'Ausfuehrungsstunde',createdAt FROM translation WHERE keyword = 'hA'
;
INSERT INTO units(utype,ftranslation_seq_id) SELECT 'GOOD',seq_id FROM translation WHERE keyword = 'hA';