Sat, 15 Jun 2019 19:43:05 +0200
Merged with default
292
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | /***************************************************************************** |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | * Copyright (C) 2019 |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | * |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | * Michiel Broek <mbroek at mbse dot eu> |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | * |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | * This file is part of BMS |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | * |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | * This is free software; you can redistribute it and/or modify it |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | * under the terms of the GNU General Public License as published by the |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | * Free Software Foundation; either version 2, or (at your option) any |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | * later version. |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | * |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | * BrewCloud is distributed in the hope that it will be useful, but |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | * WITHOUT ANY WARRANTY; without even the implied warranty of |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | * General Public License for more details. |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | * |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | * You should have received a copy of the GNU General Public License |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | * along with ThermFerm; see the file COPYING. If not, write to the Free |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | * Software Foundation, 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | *****************************************************************************/ |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
24 | $(document).ready(function () { |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
25 | var source = { |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
26 | datatype: "json", |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | cache: false, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | datafields: [ |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | { name: 'record', type: 'number' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
30 | { name: 'name', type: 'string' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
31 | { name: 'code', type: 'string' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
32 | { name: 'date', type: 'string' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
33 | { name: 'style', type: 'string' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
34 | { name: 'og', type: 'float' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | { name: 'fg', type: 'float' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | { name: 'batch_size', type: 'float' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | ], |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | id: 'record', |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | url: "includes/db_product.php?select=archcode" |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | }; |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | var dataAdapter = new $.jqx.dataAdapter(source); |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | // initialize jqxGrid |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | $("#jqxgrid").jqxGrid({ |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | width: 1280, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | height: 630, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | source: dataAdapter, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
47 | theme: theme, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
48 | columns: [ |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
49 | { text: 'Code', datafield: 'code', width: 100 }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | { text: 'Naam', datafield: 'name' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
51 | { text: 'Stijl', datafield: 'style', width: 250 }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
52 | { text: 'OG', datafield: 'og', width: 80, cellsformat: 'f3' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
53 | { text: 'FG', datafield: 'fg', width: 80, cellsformat: 'f3' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | { text: 'Datum', datafield: 'date', width: 120 }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
55 | { text: 'Liters', datafield: 'batch_size', width: 80, align: 'right', cellsalign: 'right', cellsformat: 'f1' }, |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | { text: '', datafield: 'Edit', width: 80, align: 'center', columntype: 'button', cellsrenderer: function () { |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
57 | return "Bekijk"; |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | }, buttonclick: function (row) { |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | var datarecord = dataAdapter.records[row]; |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | var url= "prod_edit.php?record=" + datarecord.record + "&select=archcode&return=prod_archive_code.php"; |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
61 | window.location.href = url; |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | } |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
63 | } |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
64 | ], |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
65 | }); |
90cd3798edc2
Added archive view on date and code.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
66 | }); |