-num"> 
@@ -0,0 +1,191 @@
1 
+;(function($, yl) {
2 
+    yl.forwardHandlerRegistry = yl.forwardHandlerRegistry || {};
3 
+
4 
+    yl.registerForwardHandler = function(name, handler) {
5 
+        yl.forwardHandlerRegistry[name] = handler;
6 
+    };
7 
+
8 
+    yl.getForwardHandler = function(name) {
9 
+        return yl.forwardHandlerRegistry[name];
10 
+    };
11 
+
12 
+    function getForwardStrategy(element) {
13 
+        var checkForCheckboxes = function() {
14 
+            var all = true;
15 
+            $.each(element, function(ix, e) {
16 
+                if ($(e).attr("type") !== "checkbox") {
17 
+                    all = false;
18 
+                }
19 
+            });
20 
+            return all;
21 
+        };
22 
+
23 
+        if (element.length === 1 &&
24 
+                element.attr("type") === "checkbox" &&
25 
+                element.attr("value") === undefined) {
26 
+            // Single checkbox without 'value' attribute
27 
+            // Boolean field
28 
+            return "exists";
29 
+        } else if (element.length === 1 &&
30 
+                element.attr("multiple") !== undefined) {
31 
+            // Multiple by HTML semantics. E. g. multiple select
32 
+            // Multiple choice field
33 
+            return "multiple";
34 
+        } else if (checkForCheckboxes()) {
35 
+            // Multiple checkboxes or one checkbox with 'value' attribute.
36 
+            // Multiple choice field represented by checkboxes
37 
+            return "multiple";
38 
+        } else {
39 
+            // Other cases
40 
+            return "single";
41 
+        }
42 
+    }
43 
+
44 
+    /**
45 
+     * Get fields with name `name` relative to `element` with considering form
46 
+     * prefixes.
47 
+     * @param element the element
48 
+     * @param name name of the field
49 
+     * @returns jQuery object with found fields or empty jQuery object if no
50 
+     * field was found
51 
+     */
52 
+    yl.getFieldRelativeTo = function(element, name) {
53 
+        var prefixes = $(element).getFormPrefixes();
54 
+
55 
+        for (var i = 0; i < prefixes.length; i++) {
56 
+            var fieldSelector = "[name=" + prefixes[i] + name + "]";
57 
+            var field = $(fieldSelector);
58 
+
59 
+            if (field.length) {
60 
+                return field;
61 
+            }
62 
+        }
63 
+
64 
+        return $();
65 
+    };
66 
+
67 
+    /**
68 
+     * Get field value which is put to forwarded dictionary
69 
+     * @param field the field
70 
+     * @returns forwarded value
71 
+     */
72 
+    yl.getValueFromField = function(field) {
73 
+        var strategy = getForwardStrategy(field);
74 
+        var serializedField = $(field).serializeArray();
75 
+
76 
+        if ((serializedField == false) && ($(field).prop('disabled'))) {
77 
+            $(field).prop('disabled', false);
78 
+            serializedField = $(field).serializeArray();
79 
+            $(field).prop('disabled', true);
80 
+        }
81 
+
82 
+        var getSerializedFieldElementAt = function (index) {
83 
+            // Return serializedField[index]
84 
+            // or null if something went wrong
85 
+            if (serializedField.length > index) {
86 
+                return serializedField[index];
87 
+            } else {
88 
+                return null;
89 
+            }
90 
+        };
91 
+
92 
+        var getValueOf = function (elem) {
93 
+            // Return elem.value
94 
+            // or null if something went wrong
95 
+            if (elem.hasOwnProperty("value") &&
96 
+                elem.value !== undefined
97 
+            ) {
98 
+                return elem.value;
99 
+            } else {
100 
+                return null;
101 
+            }
102 
+        };
103 
+
104 
+        var getSerializedFieldValueAt = function (index) {
105 
+            // Return serializedField[index].value
106 
+            // or null if something went wrong
107 
+            var elem = getSerializedFieldElementAt(index);
108 
+            if (elem !== null) {
109 
+                return getValueOf(elem);
110 
+            } else {
111 
+                return null;
112 
+            }
113 
+        };
114 
+
115 
+        if (strategy === "multiple") {
116 
+            return serializedField.map(
117 
+                function (item) {
118 
+                    return getValueOf(item);
119 
+                }
120 
+            );
121 
+        } else if (strategy === "exists") {
122 
+            return serializedField.length > 0;
123 
+        } else {
124 
+            return getSerializedFieldValueAt(0);
125 
+        }
126 
+    };
127 
+
128 
+    yl.getForwards = function(element) {
129 
+        var forwardElem,
130 
+            forwardList,
131 
+            forwardedData,
132 
+            divSelector,
133 
+            form;
134 
+        divSelector = "div.dal-forward-conf#dal-forward-conf-for-" +
135 
+                element.attr("id") + ", " +
136 
+                "div.dal-forward-conf#dal-forward-conf-for_" +
137 
+                element.attr("id");
138 
+        form = element.length > 0 ? $(element[0].form) : $();
139 
+
140 
+        forwardElem =
141 
+            form.find(divSelector).find('script');
142 
+        if (forwardElem.length === 0) {
143 
+            return;
144 
+        }
145 
+        try {
146 
+            forwardList = JSON.parse(forwardElem.text());
147 
+        } catch (e) {
148 
+            return;
149 
+        }
150 
+
151 
+        if (!Array.isArray(forwardList)) {
152 
+            return;
153 
+        }
154 
+
155 
+        forwardedData = {};
156 
+
157 
+        $.each(forwardList, function(ix, field) {
158 
+            var srcName, dstName;
159 
+            if (field.type === "const") {
160 
+                forwardedData[field.dst] = field.val;
161 
+            } else if (field.type === "self") {
162 
+                if (field.hasOwnProperty("dst")) {
163 
+                    dstName = field.dst;
164 
+                } else {
165 
+                    dstName = "self";
166 
+                }
167 
+                forwardedData[dstName] = yl.getValueFromField(element);
168 
+            } else if (field.type === "field") {
169 
+                srcName = field.src;
170 
+                if (field.hasOwnProperty("dst")) {
171 
+                    dstName = field.dst;
172 
+                } else {
173 
+                    dstName = srcName;
174 
+                }
175 
+                var forwardedField = yl.getFieldRelativeTo(element, srcName);
176 
+
177 
+                if (!forwardedField.length) {
178 
+                    return;
179 
+                }
180 
+
181 
+                forwardedData[dstName] = yl.getValueFromField(forwardedField);
182 
+            } else if (field.type === "javascript") {
183 
+                var handler = yl.getForwardHandler(field.handler);
184 
+                forwardedData[field.dst || field.handler] = handler(element);
185 
+            }
186 
+
187 
+        });
188 
+        return JSON.stringify(forwardedData);
189 
+    };
190 
+
191 
+})(yl.jQuery, yl);

+ 36 - 0
app/staticfile/autocomplete_light/jquery.init.js
Vedi File 

@@ -0,0 +1,36 @@
1 
+var yl = yl || {};
2 
+if (typeof django !== 'undefined' && typeof django.jQuery !== 'undefined') {
3 
+    // If django.jQuery is already defined, use it.
4 
+    yl.jQuery = django.jQuery;
5 
+}
6 
+else {
7 
+    // We include jquery itself in our widget's media, because we need it.
8 
+    // Normally, we expect our widget's reference to admin/js/vendor/jquery/jquery.js
9 
+    // to be skipped, because django's own code has already included it.
10 
+    // However, if django.jQuery is NOT defined, we know that jquery was not
11 
+    // included before we did it ourselves. This can happen if we're not being
12 
+    // rendered in a django admin form.
13 
+    // However, someone ELSE'S jQuery may have been included before ours, in
14 
+    // which case we must ensure that our jquery doesn't override theirs, since
15 
+    // it might be a newer version that other code on the page relies on.
16 
+    // Thus, we must run jQuery.noConflict(true) here to move our jQuery out of
17 
+    // the way.
18 
+    yl.jQuery = jQuery.noConflict(true);
19 
+}
20 
+
21 
+// In addition to all of this, we must ensure that the global jQuery and $ are
22 
+// defined, because Select2 requires that. jQuery will only be undefined at
23 
+// this point if only we or django included it.
24 
+if (typeof jQuery === 'undefined') {
25 
+    jQuery = yl.jQuery;
26 
+    $ = yl.jQuery;
27 
+}
28 
+else {
29 
+    // jQuery IS still defined, which means someone else also included jQuery.
30 
+    // In this situation, we need to store the old jQuery in a
31 
+    // temp variable, set the global jQuery to our yl.jQuery, then let select2
32 
+    // set itself up. We restore the global jQuery to its original value in
33 
+    // jquery.post-setup.js.
34 
+    dal_jquery_backup = jQuery.noConflict(true);
35 
+    jQuery = yl.jQuery;
36 
+}

+ 7 - 0
app/staticfile/autocomplete_light/jquery.post-setup.js
Vedi File 

@@ -0,0 +1,7 @@
1 
+if (typeof dal_jquery_backup !== 'undefined') {
2 
+    // We made a backup of the original global jQuery before forcing it to our
3 
+    // yl.jQuery value. Now that select2 has been set up, we need to restore
4 
+    // our backup to its rightful place.
5 
+    jQuery = dal_jquery_backup;
6 
+    $ = dal_jquery_backup;
7 
+}

+ 14 - 0
app/staticfile/autocomplete_light/select2.css
Vedi File 

@@ -0,0 +1,14 @@
1 
+.select2-container {
2 
+    min-width: 20em;
3 
+}
4 
+
5 
+ul li.select2-selection__choice,
6 
+ul li.select2-search {
7 
+    /* Cancel out django's style */
8 
+    list-style-type: none;
9 
+}
10 
+
11 
+.errors .select2-selection {
12 
+    /* Highlight select box with error */
13 
+    border-color: #ba2121;
14 
+}

+ 122 - 0
app/staticfile/autocomplete_light/select2.js
Vedi File 

@@ -0,0 +1,122 @@
1 
+;(function ($) {
2 
+    if (window.__dal__initListenerIsSet)
3 
+        return;
4 
+
5 
+    $(document).on('autocompleteLightInitialize', '[data-autocomplete-light-function=select2]', function() {
6 
+        var element = $(this);
7 
+
8 
+        // Templating helper
9 
+        function template(text, is_html) {
10 
+            if (is_html) {
11 
+                var $result = $('<span>');
12 
+                $result.html(text);
13 
+                return $result;
14 
+            } else {
15 
+                return text;
16 
+            }
17 
+        }
18 
+
19 
+        function result_template(item) {
20 
+            var text = template(item.text,
21 
+                element.attr('data-html') !== undefined || element.attr('data-result-html') !== undefined
22 
+            );
23 
+
24 
+            if (item.create_id) {
25 
+                return $('<span></span>').text(text).addClass('dal-create')
26 
+            } else {
27 
+                return text
28 
+            }
29 
+        }
30 
+
31 
+        function selected_template(item) {
32 
+            if (item.selected_text !== undefined) {
33 
+                return template(item.selected_text,
34 
+                    element.attr('data-html') !== undefined || element.attr('data-selected-html') !== undefined
35 
+                );
36 
+            } else {
37 
+                return result_template(item);
38 
+            }
39 
+            return
40 
+        }
41 
+
42 
+        var ajax = null;
43 
+        if ($(this).attr('data-autocomplete-light-url')) {
44 
+            ajax = {
45 
+                url: $(this).attr('data-autocomplete-light-url'),
46 
+                dataType: 'json',
47 
+                delay: 250,
48 
+
49 
+                data: function (params) {
50 
+                    var data = {
51 
+                        q: params.term, // search term
52 
+                        page: params.page,
53 
+                        create: element.attr('data-autocomplete-light-create') && !element.attr('data-tags'),
54 
+                        forward: yl.getForwards(element)
55 
+                    };
56 
+
57 
+                    return data;
58 
+                },
59 
+                processResults: function (data, page) {
60 
+                    if (element.attr('data-tags')) {
61 
+                        $.each(data.results, function(index, value) {
62 
+                            value.id = value.text;
63 
+                        });
64 
+                    }
65 
+
66 
+                    return data;
67 
+                },
68 
+                cache: true
69 
+            };
70 
+        }
71 
+
72 
+        $(this).select2({
73 
+            tokenSeparators: element.attr('data-tags') ? [','] : null,
74 
+            debug: true,
75 
+            containerCssClass: ':all:',
76 
+            placeholder: element.attr('data-placeholder') || '',
77 
+            language: element.attr('data-autocomplete-light-language'),
78 
+            minimumInputLength: element.attr('data-minimum-input-length') || 0,
79 
+            allowClear: ! $(this).is('[required]'),
80 
+            templateResult: result_template,
81 
+            templateSelection: selected_template,
82 
+            ajax: ajax,
83 
+            tags: Boolean(element.attr('data-tags')),
84 
+        });
85 
+
86 
+        $(this).on('select2:selecting', function (e) {
87 
+            var data = e.params.args.data;
88 
+
89 
+            if (data.create_id !== true)
90 
+                return;
91 
+
92 
+            e.preventDefault();
93 
+
94 
+            var select = $(this);
95 
+
96 
+            $.ajax({
97 
+                url: $(this).attr('data-autocomplete-light-url'),
98 
+                type: 'POST',
99 
+                dataType: 'json',
100 
+                data: {
101 
+                    text: data.id,
102 
+                    forward: yl.getForwards($(this))
103 
+                },
104 
+                beforeSend: function(xhr, settings) {
105 
+                    xhr.setRequestHeader("X-CSRFToken", document.csrftoken);
106 
+                },
107 
+                success: function(data, textStatus, jqXHR ) {
108 
+                    select.append(
109 
+                        $('<option>', {value: data.id, text: data.text, selected: true})
110 
+                    );
111 
+                    select.trigger('change');
112 
+                    select.select2('close');
113 
+                }
114 
+            });
115 
+        });
116 
+
117 
+    });
118 
+    window.__dal__initListenerIsSet = true;
119 
+    $('[data-autocomplete-light-function=select2]:not([id*="__prefix__"])').each(function() {
120 
+        window.__dal__initialize(this);
121 
+    });
122 
+})(yl.jQuery);

BIN
app/staticfile/img/heartbeat.png
Vedi File


+ 22 - 0
app/staticfile/import_export/action_formats.js
Vedi File 

@@ -0,0 +1,22 @@
1 
+(function($) {
2 
+  $(document).ready(function() {
3 
+    var $actionsSelect, $formatsElement;
4 
+    if ($('body').hasClass('grp-change-list')) {
5 
+        // using grappelli
6 
+        $actionsSelect = $('#grp-changelist-form select[name="action"]');
7 
+        $formatsElement = $('#grp-changelist-form select[name="file_format"]');
8 
+    } else {
9 
+        // using default admin
10 
+        $actionsSelect = $('#changelist-form select[name="action"]');
11 
+        $formatsElement = $('#changelist-form select[name="file_format"]').parent();
12 
+    }
13 
+    $actionsSelect.change(function() {
14 
+      if ($(this).val() === 'export_admin_action') {
15 
+        $formatsElement.show();
16 
+      } else {
17 
+        $formatsElement.hide();
18 
+      }
19 
+    });
20 
+    $actionsSelect.change();
21 
+  });
22 
+})(django.jQuery);

+ 81 - 0
app/staticfile/import_export/import.css
Vedi File 

@@ -0,0 +1,81 @@
1 
+.import-preview .errors {
2 
+  position: relative;
3 
+}
4 
+
5 
+.validation-error-count {
6 
+  display: inline-block;
7 
+  background-color: #e40000;
8 
+  border-radius: 6px;
9 
+  color: white;
10 
+  font-size: 0.9em;
11 
+  position: relative;
12 
+  font-weight: bold;
13 
+  margin-top: -2px;
14 
+  padding: 0.2em 0.4em;
15 
+}
16 
+
17 
+.validation-error-container {
18 
+  position: absolute;
19 
+  opacity: 0;
20 
+  pointer-events: none;
21 
+  background-color: #ffc1c1;
22 
+  padding: 14px 15px 10px;
23 
+  top: 25px;
24 
+  margin: 0 0 20px 0;
25 
+  width: 200px;
26 
+  z-index: 2;
27 
+}
28 
+
29 
+table.import-preview tr.skip {
30 
+  background-color: #d2d2d2;
31 
+}
32 
+
33 
+table.import-preview tr.new {
34 
+  background-color: #bdd8b2;
35 
+}
36 
+
37 
+table.import-preview tr.delete {
38 
+  background-color: #f9bebf;
39 
+}
40 
+
41 
+table.import-preview tr.update {
42 
+  background-color: #fdfdcf;
43 
+}
44 
+
45 
+.import-preview td:hover .validation-error-count {
46 
+  z-index: 3;
47 
+}
48 
+.import-preview td:hover .validation-error-container {
49 
+  opacity: 1;
50 
+  pointer-events: auto;
51 
+}
52 
+
53 
+.validation-error-list {
54 
+  margin: 0;
55 
+  padding: 0;
56 
+}
57 
+
58 
+.validation-error-list li {
59 
+  list-style: none;
60 
+  margin: 0;
61 
+}
62 
+
63 
+.validation-error-list > li > ul {
64 
+  margin: 8px 0;
65 
+  padding: 0;
66 
+}
67 
+
68 
+.validation-error-list > li > ul > li {
69 
+  padding: 0;
70 
+  margin: 0 0 10px;
71 
+  line-height: 1.28em;
72 
+}
73 
+
74 
+.validation-error-field-label {
75 
+  display: block;
76 
+  border-bottom: 1px solid #e40000;
77 
+  color: #e40000;
78 
+  text-transform: uppercase;
79 
+  font-weight: bold;
80 
+  font-size: 0.85em;
81 
+}

+ 15 - 0
app/staticfile/js/main.js
Vedi File 

@@ -0,0 +1,15 @@
1 
+$(function(){
2 
+    $("#currentLocationBtn").click(function(){
3 
+        if ("geolocation" in navigator){ //check geolocation available
4 
+            //try to get user current location using getCurrentPosition() method
5 
+            console.log("current location");
6 
+            navigator.geolocation.getCurrentPosition(function(position){
7 
+                console.log("xxxx");
8 
+                $("#geoText").val(position.coords.latitude+","+position.coords.longitude );
9 
+
10 
+            });
11 
+        }else{
12 
+            console.log("Browser doesn't support geolocation!");
13 
+        }
14 
+    });
15 
+});

+ 262 - 0
app/staticfile/vendor/select2/Gruntfile.js
Vedi File 

@@ -0,0 +1,262 @@
1 
+const sass = require('node-sass');
2 
+
3 
+module.exports = function (grunt) {
4 
+  // Full list of files that must be included by RequireJS
5 
+  includes = [
6 
+    'jquery.select2',
7 
+    'almond',
8 
+
9 
+    'jquery-mousewheel' // shimmed for non-full builds
10 
+  ];
11 
+
12 
+  fullIncludes = [
13 
+    'jquery',
14 
+
15 
+    'select2/compat/containerCss',
16 
+    'select2/compat/dropdownCss',
17 
+
18 
+    'select2/compat/initSelection',
19 
+    'select2/compat/inputData',
20 
+    'select2/compat/matcher',
21 
+    'select2/compat/query',
22 
+
23 
+    'select2/dropdown/attachContainer',
24 
+    'select2/dropdown/stopPropagation',
25 
+
26 
+    'select2/selection/stopPropagation'
27 
+  ].concat(includes);
28 
+
29 
+  var i18nModules = [];
30 
+  var i18nPaths = {};
31 
+
32 
+  var i18nFiles = grunt.file.expand({
33 
+    cwd: 'src/js'
34 
+  }, 'select2/i18n/*.js');
35 
+
36 
+  var testFiles = grunt.file.expand('tests/**/*.html');
37 
+  var testUrls = testFiles.map(function (filePath) {
38 
+    return 'http://localhost:9999/' + filePath;
39 
+  });
40 
+
41 
+  var testBuildNumber = "unknown";
42 
+
43 
+  if (process.env.TRAVIS_JOB_ID) {
44 
+    testBuildNumber = "travis-" + process.env.TRAVIS_JOB_ID;
45 
+  } else {
46 
+    var currentTime = new Date();
47 
+
48 
+    testBuildNumber = "manual-" + currentTime.getTime();
49 
+  }
50 
+
51 
+  for (var i = 0; i < i18nFiles.length; i++) {
52 
+    var file = i18nFiles[i];
53 
+    var name = file.split('.')[0];
54 
+
55 
+    i18nModules.push({
56 
+      name: name
57 
+    });
58 
+
59 
+    i18nPaths[name] = '../../' + name;
60 
+  }
61 
+
62 
+  var minifiedBanner = '/*! Select2 <%= package.version %> | https://github.com/select2/select2/blob/master/LICENSE.md */';
63 
+
64 
+  grunt.initConfig({
65 
+    package: grunt.file.readJSON('package.json'),
66 
+
67 
+    concat: {
68 
+      'dist': {
69 
+        options: {
70 
+          banner: grunt.file.read('src/js/wrapper.start.js'),
71 
+        },
72 
+        src: [
73 
+          'dist/js/select2.js',
74 
+          'src/js/wrapper.end.js'
75 
+        ],
76 
+        dest: 'dist/js/select2.js'
77 
+      },
78 
+      'dist.full': {
79 
+        options: {
80 
+          banner: grunt.file.read('src/js/wrapper.start.js'),
81 
+        },
82 
+        src: [
83 
+          'dist/js/select2.full.js',
84 
+          'src/js/wrapper.end.js'
85 
+        ],
86 
+        dest: 'dist/js/select2.full.js'
87 
+      }
88 
+    },
89 
+
90 
+    connect: {
91 
+      tests: {
92 
+        options: {
93 
+          base: '.',
94 
+          hostname: '127.0.0.1',
95 
+          port: 9999
96 
+        }
97 
+      }
98 
+    },
99 
+
100 
+    uglify: {
101 
+      'dist': {
102 
+        src: 'dist/js/select2.js',
103 
+        dest: 'dist/js/select2.min.js',
104 
+        options: {
105 
+          banner: minifiedBanner
106 
+        }
107 
+      },
108 
+      'dist.full': {
109 
+        src: 'dist/js/select2.full.js',
110 
+        dest: 'dist/js/select2.full.min.js',
111 
+        options: {
112 
+          banner: minifiedBanner
113 
+        }
114 
+      }
115 
+    },
116 
+
117 
+    qunit: {
118 
+      all: {
119 
+        options: {
120 
+          urls: testUrls
121 
+        }
122 
+      }
123 
+    },
124 
+
125 
+    jshint: {
126 
+      options: {
127 
+        jshintrc: true,
128 
+        reporterOutput: ''
129 
+      },
130 
+      code: {
131 
+        src: ['src/js/**/*.js']
132 
+      },
133 
+      tests: {
134 
+        src: ['tests/**/*.js']
135 
+      }
136 
+    },
137 
+
138 
+    sass: {
139 
+      dist: {
140 
+        options: {
141 
+          implementation: sass,
142 
+          outputStyle: 'compressed'
143 
+        },
144 
+        files: {
145 
+          'dist/css/select2.min.css': [
146 
+            'src/scss/core.scss',
147 
+            'src/scss/theme/default/layout.css'
148 
+          ]
149 
+        }
150 
+      },
151 
+      dev: {
152 
+        options: {
153 
+          implementation: sass,
154 
+          outputStyle: 'nested'
155 
+        },
156 
+        files: {
157 
+          'dist/css/select2.css': [
158 
+            'src/scss/core.scss',
159 
+            'src/scss/theme/default/layout.css'
160 
+          ]
161 
+        }
162 
+      }
163 
+    },
164 
+
165 
+    requirejs: {
166 
+      'dist': {
167 
+        options: {
168 
+          baseUrl: 'src/js',
169 
+          optimize: 'none',
170 
+          name: 'select2/core',
171 
+          out: 'dist/js/select2.js',
172 
+          include: includes,
173 
+          namespace: 'S2',
174 
+          paths: {
175 
+            'almond': require.resolve('almond').slice(0, -3),
176 
+            'jquery': 'jquery.shim',
177 
+            'jquery-mousewheel': 'jquery.mousewheel.shim'
178 
+          },
179 
+          wrap: {
180 
+            startFile: 'src/js/banner.start.js',
181 
+            endFile: 'src/js/banner.end.js'
182 
+          }
183 
+        }
184 
+      },
185 
+      'dist.full': {
186 
+        options: {
187 
+          baseUrl: 'src/js',
188 
+          optimize: 'none',
189 
+          name: 'select2/core',
190 
+          out: 'dist/js/select2.full.js',
191 
+          include: fullIncludes,
192 
+          namespace: 'S2',
193 
+          paths: {
194 
+            'almond': require.resolve('almond').slice(0, -3),
195 
+            'jquery': 'jquery.shim',
196 
+            'jquery-mousewheel': require.resolve('jquery-mousewheel').slice(0, -3)
197 
+          },
198 
+          wrap: {
199 
+            startFile: 'src/js/banner.start.js',
200 
+            endFile: 'src/js/banner.end.js'
201 
+          }
202 
+        }
203 
+      },
204 
+      'i18n': {
205 
+        options: {
206 
+          baseUrl: 'src/js/select2/i18n',
207 
+          dir: 'dist/js/i18n',
208 
+          paths: i18nPaths,
209 
+          modules: i18nModules,
210 
+          namespace: 'S2',
211 
+          wrap: {
212 
+            start: minifiedBanner + grunt.file.read('src/js/banner.start.js'),
213 
+            end: grunt.file.read('src/js/banner.end.js')
214 
+          }
215 
+        }
216 
+      }
217 
+    },
218 
+
219 
+    watch: {
220 
+      js: {
221 
+        files: [
222 
+          'src/js/select2/**/*.js',
223 
+          'tests/**/*.js'
224 
+        ],
225 
+        tasks: [
226 
+          'compile',
227 
+          'test',
228 
+          'minify'
229 
+        ]
230 
+      },
231 
+      css: {
232 
+        files: [
233 
+          'src/scss/**/*.scss'
234 
+        ],
235 
+        tasks: [
236 
+          'compile',
237 
+          'minify'
238 
+        ]
239 
+      }
240 
+    }
241 
+  });
242 
+
243 
+  grunt.loadNpmTasks('grunt-contrib-concat');
244 
+  grunt.loadNpmTasks('grunt-contrib-connect');
245 
+  grunt.loadNpmTasks('grunt-contrib-jshint');
246 
+  grunt.loadNpmTasks('grunt-contrib-qunit');
247 
+  grunt.loadNpmTasks('grunt-contrib-requirejs');
248 
+  grunt.loadNpmTasks('grunt-contrib-uglify');
249 
+  grunt.loadNpmTasks('grunt-contrib-watch');
250 
+
251 
+  grunt.loadNpmTasks('grunt-sass');
252 
+
253 
+  grunt.registerTask('default', ['compile', 'test', 'minify']);
254 
+
255 
+  grunt.registerTask('compile', [
256 
+    'requirejs:dist', 'requirejs:dist.full', 'requirejs:i18n',
257 
+    'concat:dist', 'concat:dist.full',
258 
+    'sass:dev'
259 
+  ]);
260 
+  grunt.registerTask('minify', ['uglify', 'sass:dist']);
261 
+  grunt.registerTask('test', ['connect:tests', 'qunit', 'jshint']);
262 
+};

+ 13 - 0
app/staticfile/vendor/select2/bower.json
Vedi File 

@@ -0,0 +1,13 @@
1 
+{
2 
+    "name": "select2",
3 
+    "description": "Select2 is a jQuery based replacement for select boxes. It supports searching, remote data sets, and infinite scrolling of results.",
4 
+    "main": [
5 
+        "dist/js/select2.js",
6 
+        "src/scss/core.scss"
7 
+    ],
8 
+    "license": "MIT",
9 
+    "repository": {
10 
+        "type": "git",
11 
+        "url": "git@github.com:select2/select2.git"
12 
+    }
13 
+}

+ 19 - 0
app/staticfile/vendor/select2/component.json
Vedi File 

@@ -0,0 +1,19 @@
1 
+{
2 
+  "name": "select2",
3 
+  "repo": "select/select2",
4 
+  "description": "Select2 is a jQuery based replacement for select boxes. It supports searching, remote data sets, and infinite scrolling of results.",
5 
+  "version": "4.0.7",
6 
+  "demo": "https://select2.org/",
7 
+  "keywords": [
8 
+    "jquery"
9 
+  ],
10 
+  "main": "dist/js/select2.js",
11 
+  "styles": [
12 
+    "dist/css/select2.css"
13 
+  ],
14 
+  "scripts": [
15 
+    "dist/js/select2.js",
16 
+    "dist/js/i18n/*.js"
17 
+  ],
18 
+  "license": "MIT"
19 
+}

+ 22 - 0
app/staticfile/vendor/select2/composer.json
Vedi File 

@@ -0,0 +1,22 @@
1 
+{
2 
+  "name": "select2/select2",
3 
+  "description": "Select2 is a jQuery based replacement for select boxes.",
4 
+  "type": "component",
5 
+  "homepage": "https://select2.org/",
6 
+  "license": "MIT",
7 
+  "extra": {
8 
+    "component": {
9 
+      "scripts": [
10 
+        "dist/js/select2.js"
11 
+      ],
12 
+      "styles": [
13 
+        "dist/css/select2.css"
14 
+      ],
15 
+      "files": [
16 
+        "dist/js/select2.js",
17 
+        "dist/js/i18n/*.js",
18 
+        "dist/css/select2.css"
19 
+      ]
20 
+    }
21 
+  }
22 
+}

+ 484 - 0
app/staticfile/vendor/select2/dist/css/select2.css
Vedi File 

@@ -0,0 +1,484 @@
1 
+.select2-container {
2 
+  box-sizing: border-box;
3 
+  display: inline-block;
4 
+  margin: 0;
5 
+  position: relative;
6 
+  vertical-align: middle; }
7 
+  .select2-container .select2-selection--single {
8 
+    box-sizing: border-box;
9 
+    cursor: pointer;
10 
+    display: block;
11 
+    height: 28px;
12 
+    user-select: none;
13 
+    -webkit-user-select: none; }
14 
+    .select2-container .select2-selection--single .select2-selection__rendered {
15 
+      display: block;
16 
+      padding-left: 8px;
17 
+      padding-right: 20px;
18 
+      overflow: hidden;
19 
+      text-overflow: ellipsis;
20 
+      white-space: nowrap; }
21 
+    .select2-container .select2-selection--single .select2-selection__clear {
22 
+      position: relative; }
23 
+  .select2-container[dir="rtl"] .select2-selection--single .select2-selection__rendered {
24 
+    padding-right: 8px;
25 
+    padding-left: 20px; }
26 
+  .select2-container .select2-selection--multiple {
27 
+    box-sizing: border-box;
28 
+    cursor: pointer;
29 
+    display: block;
30 
+    min-height: 32px;
31 
+    user-select: none;
32 
+    -webkit-user-select: none; }
33 
+    .select2-container .select2-selection--multiple .select2-selection__rendered {
34 
+      display: inline-block;
35 
+      overflow: hidden;
36 
+      padding-left: 8px;
37 
+      text-overflow: ellipsis;
38 
+      white-space: nowrap; }
39 
+  .select2-container .select2-search--inline {
40 
+    float: left; }
41 
+    .select2-container .select2-search--inline .select2-search__field {
42 
+      box-sizing: border-box;
43 
+      border: none;
44 
+      font-size: 100%;
45 
+      margin-top: 5px;
46 
+      padding: 0; }
47 
+      .select2-container .select2-search--inline .select2-search__field::-webkit-search-cancel-button {
48 
+        -webkit-appearance: none; }
49 
+
50 
+.select2-dropdown {
51 
+  background-color: white;
52 
+  border: 1px solid #aaa;
53 
+  border-radius: 4px;
54 
+  box-sizing: border-box;
55 
+  display: block;
56 
+  position: absolute;
57 
+  left: -100000px;
58 
+  width: 100%;
59 
+  z-index: 1051; }
60 
+
61 
+.select2-results {
62 
+  display: block; }
63 
+
64 
+.select2-results__options {
65 
+  list-style: none;
66 
+  margin: 0;
67 
+  padding: 0; }
68 
+
69 
+.select2-results__option {
70 
+  padding: 6px;
71 
+  user-select: none;
72 
+  -webkit-user-select: none; }
73 
+  .select2-results__option[aria-selected] {
74 
+    cursor: pointer; }
75 
+
76 
+.select2-container--open .select2-dropdown {
77 
+  left: 0; }
78 
+
79 
+.select2-container--open .select2-dropdown--above {
80 
+  border-bottom: none;
81 
+  border-bottom-left-radius: 0;
82 
+  border-bottom-right-radius: 0; }
83 
+
84 
+.select2-container--open .select2-dropdown--below {
85 
+  border-top: none;
86 
+  border-top-left-radius: 0;
87 
+  border-top-right-radius: 0; }
88 
+
89 
+.select2-search--dropdown {
90 
+  display: block;
91 
+  padding: 4px; }
92 
+  .select2-search--dropdown .select2-search__field {
93 
+    padding: 4px;
94 
+    width: 100%;
95 
+    box-sizing: border-box; }
96 
+    .select2-search--dropdown .select2-search__field::-webkit-search-cancel-button {
97 
+      -webkit-appearance: none; }
98 
+  .select2-search--dropdown.select2-search--hide {
99 
+    display: none; }
100 
+
101 
+.select2-close-mask {
102 
+  border: 0;
103 
+  margin: 0;
104 
+  padding: 0;
105 
+  display: block;
106 
+  position: fixed;
107 
+  left: 0;
108 
+  top: 0;
109 
+  min-height: 100%;
110 
+  min-width: 100%;
111 
+  height: auto;
112 
+  width: auto;
113 
+  opacity: 0;
114 
+  z-index: 99;
115 
+  background-color: #fff;
116 
+  filter: alpha(opacity=0); }
117 
+
118 
+.select2-hidden-accessible {
119 
+  border: 0 !important;
120 
+  clip: rect(0 0 0 0) !important;
121 
+  -webkit-clip-path: inset(50%) !important;
122 
+  clip-path: inset(50%) !important;
123 
+  height: 1px !important;
124 
+  overflow: hidden !important;
125 
+  padding: 0 !important;
126 
+  position: absolute !important;
127 
+  width: 1px !important;
128 
+  white-space: nowrap !important; }
129 
+
130 
+.select2-container--default .select2-selection--single {
131 
+  background-color: #fff;
132 
+  border: 1px solid #aaa;
133 
+  border-radius: 4px; }
134 
+  .select2-container--default .select2-selection--single .select2-selection__rendered {
135 
+    color: #444;
136 
+    line-height: 28px; }
137 
+  .select2-container--default .select2-selection--single .select2-selection__clear {
138 
+    cursor: pointer;
139 
+    float: right;
140 
+    font-weight: bold; }
141 
+  .select2-container--default .select2-selection--single .select2-selection__placeholder {
142 
+    color: #999; }
143 
+  .select2-container--default .select2-selection--single .select2-selection__arrow {
144 
+    height: 26px;
145 
+    position: absolute;
146 
+    top: 1px;
147 
+    right: 1px;
148 
+    width: 20px; }
149 
+    .select2-container--default .select2-selection--single .select2-selection__arrow b {
150 
+      border-color: #888 transparent transparent transparent;
151 
+      border-style: solid;
152 
+      border-width: 5px 4px 0 4px;
153 
+      height: 0;
154 
+      left: 50%;
155 
+      margin-left: -4px;
156 
+      margin-top: -2px;
157 
+      position: absolute;
158 
+      top: 50%;
159 
+      width: 0; }
160 
+
161 
+.select2-container--default[dir="rtl"] .select2-selection--single .select2-selection__clear {
162 
+  float: left; }
163 
+
164 
+.select2-container--default[dir="rtl"] .select2-selection--single .select2-selection__arrow {
165 
+  left: 1px;
166 
+  right: auto; }
167 
+
168 
+.select2-container--default.select2-container--disabled .select2-selection--single {
169 
+  background-color: #eee;
170 
+  cursor: default; }
171 
+  .select2-container--default.select2-container--disabled .select2-selection--single .select2-selection__clear {
172 
+    display: none; }
173 
+
174 
+.select2-container--default.select2-container--open .select2-selection--single .select2-selection__arrow b {
175 
+  border-color: transparent transparent #888 transparent;
176 
+  border-width: 0 4px 5px 4px; }
177 
+
178 
+.select2-container--default .select2-selection--multiple {
179 
+  background-color: white;
180 
+  border: 1px solid #aaa;
181 
+  border-radius: 4px;
182 
+  cursor: text; }
183 
+  .select2-container--default .select2-selection--multiple .select2-selection__rendered {
184 
+    box-sizing: border-box;
185 
+    list-style: none;
186 
+    margin: 0;
187 
+    padding: 0 5px;
188 
+    width: 100%; }
189 
+    .select2-container--default .select2-selection--multiple .select2-selection__rendered li {
190 
+      list-style: none; }
191 
+  .select2-container--default .select2-selection--multiple .select2-selection__placeholder {
192 
+    color: #999;
193 
+    margin-top: 5px;
194 
+    float: left; }
195 
+  .select2-container--default .select2-selection--multiple .select2-selection__clear {
196 
+    cursor: pointer;
197 
+    float: right;
198 
+    font-weight: bold;
199 
+    margin-top: 5px;
200 
+    margin-right: 10px; }
201 
+  .select2-container--default .select2-selection--multiple .select2-selection__choice {
202 
+    background-color: #e4e4e4;
203 
+    border: 1px solid #aaa;
204 
+    border-radius: 4px;
205 
+    cursor: default;
206 
+    float: left;
207 
+    margin-right: 5px;
208 
+    margin-top: 5px;
209 
+    padding: 0 5px; }
210 
+  .select2-container--default .select2-selection--multiple .select2-selection__choice__remove {
211 
+    color: #999;
212 
+    cursor: pointer;
213 
+    display: inline-block;
214 
+    font-weight: bold;
215 
+    margin-right: 2px; }
216 
+    .select2-container--default .select2-selection--multiple .select2-selection__choice__remove:hover {
217 
+      color: #333; }
218 
+
219 
+.select2-container--default[dir="rtl"] .select2-selection--multiple .select2-selection__choice, .select2-container--default[dir="rtl"] .select2-selection--multiple .select2-selection__placeholder, .select2-container--default[dir="rtl"] .select2-selection--multiple .select2-search--inline {
220 
+  float: right; }
221 
+
222 
+.select2-container--default[dir="rtl"] .select2-selection--multiple .select2-selection__choice {
223 
+  margin-left: 5px;
224 
+  margin-right: auto; }
225 
+
226 
+.select2-container--default[dir="rtl"] .select2-selection--multiple .select2-selection__choice__remove {
227 
+  margin-left: 2px;
228 
+  margin-right: auto; }
229 
+
230 
+.select2-container--default.select2-container--focus .select2-selection--multiple {
231 
+  border: solid black 1px;
232 
+  outline: 0; }
233 
+
234 
+.select2-container--default.select2-container--disabled .select2-selection--multiple {
235 
+  background-color: #eee;
236 
+  cursor: default; }
237 
+
238 
+.select2-container--default.select2-container--disabled .select2-selection__choice__remove {
239 
+  display: none; }
240 
+
241 
+.select2-container--default.select2-container--open.select2-container--above .select2-selection--single, .select2-container--default.select2-container--open.select2-container--above .select2-selection--multiple {
242 
+  border-top-left-radius: 0;
243 
+  border-top-right-radius: 0; }
244 
+
245 
+.select2-container--default.select2-container--open.select2-container--below .select2-selection--single, .select2-container--default.select2-container--open.select2-container--below .select2-selection--multiple {
246 
+  border-bottom-left-radius: 0;
247 
+  border-bottom-right-radius: 0; }
248 
+
249 
+.select2-container--default .select2-search--dropdown .select2-search__field {
250 
+  border: 1px solid #aaa; }
251 
+
252 
+.select2-container--default .select2-search--inline .select2-search__field {
253 
+  background: transparent;
254 
+  border: none;
255 
+  outline: 0;
256 
+  box-shadow: none;
257 
+  -webkit-appearance: textfield; }
258 
+
259 
+.select2-container--default .select2-results > .select2-results__options {
260 
+  max-height: 200px;
261 
+  overflow-y: auto; }
262 
+
263 
+.select2-container--default .select2-results__option[role=group] {
264 
+  padding: 0; }
265 
+
266 
+.select2-container--default .select2-results__option[aria-disabled=true] {
267 
+  color: #999; }
268 
+
269 
+.select2-container--default .select2-results__option[aria-selected=true] {
270 
+  background-color: #ddd; }
271 
+
272 
+.select2-container--default .select2-results__option .select2-results__option {
273 
+  padding-left: 1em; }
274 
+  .select2-container--default .select2-results__option .select2-results__option .select2-results__group {
275 
+    padding-left: 0; }
276 
+  .select2-container--default .select2-results__option .select2-results__option .select2-results__option {
277 
+    margin-left: -1em;
278 
+    padding-left: 2em; }
279 
+    .select2-container--default .select2-results__option .select2-results__option .select2-results__option .select2-results__option {
280 
+      margin-left: -2em;
281 
+      padding-left: 3em; }
282 
+      .select2-container--default .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option {
283 
+        margin-left: -3em;
284 
+        padding-left: 4em; }
285 
+        .select2-container--default .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option {
286 
+          margin-left: -4em;
287 
+          padding-left: 5em; }
288 
+          .select2-container--default .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option .select2-results__option {
289 
+            margin-left: -5em;
290 
+            padding-left: 6em; }
291 
+
292 
+.select2-container--default .select2-results__option--highlighted[aria-selected] {
293 
+  background-color: #5897fb;
294 
+  color: white; }
295 
+
296 
+.select2-container--default .select2-results__group {
297 
+  cursor: default;
298 
+  display: block;
299 
+  padding: 6px; }
300 
+
301 
+.select2-container--classic .select2-selection--single {
302 
+  background-color: #f7f7f7;
303 
+  border: 1px solid #aaa;
304 
+  border-radius: 4px;
305 
+  outline: 0;
306 
+  background-image: -webkit-linear-gradient(top, white 50%, #eeeeee 100%);
307 
+  background-image: -o-linear-gradient(top, white 50%, #eeeeee 100%);
308 
+  background-image: linear-gradient(to bottom, white 50%, #eeeeee 100%);
309 
+  background-repeat: repeat-x;
310 
+  filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#FFFFFFFF', endColorstr='#FFEEEEEE', GradientType=0); }
311 
+  .select2-container--classic .select2-selection--single:focus {
312 
+    border: 1px solid #5897fb; }
313 
+  .select2-container--classic .select2-selection--single .select2-selection__rendered {
314 
+    color: #444;
315 
+    line-height: 28px; }
316 
+  .select2-container--classic .select2-selection--single .select2-selection__clear {
317 
+    cursor: pointer;
318 
+    float: right;
319 
+    font-weight: bold;
320 
+    margin-right: 10px; }
321 
+  .select2-container--classic .select2-selection--single .select2-selection__placeholder {
322 
+    color: #999; }
323 
+  .select2-container--classic .select2-selection--single .select2-selection__arrow {
324 
+    background-color: #ddd;
325 
+    border: none;
326 
+    border-left: 1px solid #aaa;
327 
+    border-top-right-radius: 4px;
328 
+    border-bottom-right-radius: 4px;
329 
+    height: 26px;
330 
+    position: absolute;
331 
+    top: 1px;
332 
+    right: 1px;
333 
+    width: 20px;
334 
+    background-image: -webkit-linear-gradient(top, #eeeeee 50%, #cccccc 100%);
335 
+    background-image: -o-linear-gradient(top, #eeeeee 50%, #cccccc 100%);
336 
+    background-image: linear-gradient(to bottom, #eeeeee 50%, #cccccc 100%);
337 
+    background-repeat: repeat-x;
338 
+    filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#FFEEEEEE', endColorstr='#FFCCCCCC', GradientType=0); }
339 
+    .select2-container--classic .select2-selection--single .select2-selection__arrow b {
340 
+      border-color: #888 transparent transparent transparent;
341 
+      border-style: solid;
342 
+      border-width: 5px 4px 0 4px;
343 
+      height: 0;
344 
+      left: 50%;
345 
+      margin-left: -4px;
346 
+      margin-top: -2px;
347 
+      position: absolute;
348 
+      top: 50%;
349 
+      width: 0; }
350 
+
351 
+.select2-container--classic[dir="rtl"] .select2-selection--single .select2-selection__clear {
352 
+  float: left; }
353 
+
354 
+.select2-container--classic[dir="rtl"] .select2-selection--single .select2-selection__arrow {
355 
+  border: none;
356 
+  border-right: 1px solid #aaa;
357 
+  border-radius: 0;
358 
+  border-top-left-radius: 4px;
359 
+  border-bottom-left-radius: 4px;
360 
+  left: 1px;
361 
+  right: auto; }
362 
+
363 
+.select2-container--classic.select2-container--open .select2-selection--single {
364 
+  border: 1px solid #5897fb; }
365 
+  .select2-container--classic.select2-container--open .select2-selection--single .select2-selection__arrow {
366 
+    background: transparent;
367 
+    border: none; }
368 
+    .select2-container--classic.select2-container--open .select2-selection--single .select2-selection__arrow b {
369 
+      border-color: transparent transparent #888 transparent;
370 
+      border-width: 0 4px 5px 4px; }
371 
+
372 
+.select2-container--classic.select2-container--open.select2-container--above .select2-selection--single {
373 
+  border-top: none;
374 
+  border-top-left-radius: 0;
375 
+  border-top-right-radius: 0;
376 
+  background-image: -webkit-linear-gradient(top, white 0%, #eeeeee 50%);
377 
+  background-image: -o-linear-gradient(top, white 0%, #eeeeee 50%);
378 
+  background-image: linear-gradient(to bottom, white 0%, #eeeeee 50%);
379 
+  background-repeat: repeat-x;
380 
+  filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#FFFFFFFF', endColorstr='#FFEEEEEE', GradientType=0); }
381 
+
382 
+.select2-container--classic.select2-container--open.select2-container--below .select2-selection--single {
383 
+  border-bottom: none;
384 
+  border-bottom-left-radius: 0;
385 
+  border-bottom-right-radius: 0;
386 
+  background-image: -webkit-linear-gradient(top, #eeeeee 50%, white 100%);
387 
+  background-image: -o-linear-gradient(top, #eeeeee 50%, white 100%);
388 
+  background-image: linear-gradient(to bottom, #eeeeee 50%, white 100%);
389 
+  background-repeat: repeat-x;
390 
+  filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#FFEEEEEE', endColorstr='#FFFFFFFF', GradientType=0); }
391 
+
392 
+.select2-container--classic .select2-selection--multiple {
393 
+  background-color: white;
394 
+  border: 1px solid #aaa;
395 
+  border-radius: 4px;
396 
+  cursor: text;
397 
+  outline: 0; }
398 
+  .select2-container--classic .select2-selection--multiple:focus {
399 
+    border: 1px solid #5897fb; }
400 
+  .select2-container--classic .select2-selection--multiple .select2-selection__rendered {
401 
+    list-style: none;
402 
+    margin: 0;
403 
+    padding: 0 5px; }
404 
+  .select2-container--classic .select2-selection--multiple .select2-selection__clear {
405 
+    display: none; }
406 
+  .select2-container--classic .select2-selection--multiple .select2-selection__choice {
407 
+    background-color: #e4e4e4;
408 
+    border: 1px solid #aaa;
409 
+    border-radius: 4px;
410 
+    cursor: default;
411 
+    float: left;
412 
+    margin-right: 5px;
413 
+    margin-top: 5px;
414 
+    padding: 0 5px; }
415 
+  .select2-container--classic .select2-selection--multiple .select2-selection__choice__remove {
416 
+    color: #888;
417 
+    cursor: pointer;
418 
+    display: inline-block;
419 
+    font-weight: bold;
420 
+    margin-right: 2px; }
421 
+    .select2-container--classic .select2-selection--multiple .select2-selection__choice__remove:hover {
422 
+      color: #555; }
423 
+
424 
+.select2-container--classic[dir="rtl"] .select2-selection--multiple .select2-selection__choice {
425 
+  float: right;
426 
+  margin-left: 5px;
427 
+  margin-right: auto; }
428 
+
429 
+.select2-container--classic[dir="rtl"] .select2-selection--multiple .select2-selection__choice__remove {
430 
+  margin-left: 2px;
431 
+  margin-right: auto; }
432 
+
433 
+.select2-container--classic.select2-container--open .select2-selection--multiple {
434 
+  border: 1px solid #5897fb; }
435 
+
436 
+.select2-container--classic.select2-container--open.select2-container--above .select2-selection--multiple {
437 
+  border-top: none;
438 
+  border-top-left-radius: 0;
439 
+  border-top-right-radius: 0; }
440 
+
441 
+.select2-container--classic.select2-container--open.select2-container--below .select2-selection--multiple {
442 
+  border-bottom: none;
443 
+  border-bottom-left-radius: 0;
444 
+  border-bottom-right-radius: 0; }
445 
+
446 
+.select2-container--classic .select2-search--dropdown .select2-search__field {
447 
+  border: 1px solid #aaa;
448 
+  outline: 0; }
449 
+
450 
+.select2-container--classic .select2-search--inline .select2-search__field {
451 
+  outline: 0;
452 
+  box-shadow: none; }
453 
+
454 
+.select2-container--classic .select2-dropdown {
455 
+  background-color: white;
456 
+  border: 1px solid transparent; }
457 
+
458 
+.select2-container--classic .select2-dropdown--above {
459 
+  border-bottom: none; }
460 
+
461 
+.select2-container--classic .select2-dropdown--below {
462 
+  border-top: none; }
463 
+
464 
+.select2-container--classic .select2-results > .select2-results__options {
465 
+  max-height: 200px;
466 
+  overflow-y: auto; }
467 
+
468 
+.select2-container--classic .select2-results__option[role=group] {
469 
+  padding: 0; }
470 
+
471 
+.select2-container--classic .select2-results__option[aria-disabled=true] {
472 
+  color: grey; }
473 
+
474 
+.select2-container--classic .select2-results__option--highlighted[aria-selected] {
475 
+  background-color: #3875d7;
476 
+  color: white; }
477 
+
478 
+.select2-container--classic .select2-results__group {
479 
+  cursor: default;
480 
+  display: block;
481 
+  padding: 6px; }
482 
+
483 
+.select2-container--classic.select2-container--open .select2-dropdown {
484 
+  border-color: #5897fb; }

File diff suppressed because it is too large
+ 1 - 0
app/staticfile/vendor/select2/dist/css/select2.min.css


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/af.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/ar.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/az.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/bg.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/bn.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/bs.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/ca.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/cs.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/da.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/de.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/dsb.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/el.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/en.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/es.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/et.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/eu.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/fa.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/fi.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/fr.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/gl.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/he.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/hi.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/hr.js


File diff suppressed because it is too large
+ 3 - 0
app/staticfile/vendor/select2/dist/js/i18n/hsb.js


+ 0 - 0
app/staticfile/vendor/select2/dist/js/i18n/hu.js
Vedi File


Some files were not shown because too many files changed in this diff

tum/coi - Gogs: Simplico Git Service
Inicio Explorar Ayuda
Iniciar sesión
tum
/
coi
Seguir 1
Destacar 0
Fork 0
Código Incidencias 0 Pull Requests 0 Commits 67 Releases 0 Wiki

Sin descripción

Árbol: a01e843d91
Ramas Etiquetas
coi
/
app
/
report
/
measuremente...

measurementexcel.py 56KB
Histórico Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763 
  1. # -*- coding: utf-8 -*-
    2. 

  2. from openpyxl import load_workbook
    3. 

  3. import pyodbc
    4. 

  4. import time
    5. 

  5. import sys
    6. 

  6. from pprint import pprint
    7. 

  7. import datetime
    8. 

  8. from openpyxl.styles import NamedStyle, Font, colors, Border, Side
    9. 

  9. import  openpyxl.drawing.text as drawingText
    10. 

  10. from copy import deepcopy
    11. 

  11. from openpyxl.chart import LineChart, Reference, Series
    12. 

  12. from openpyxl.chart.text import RichText
    13. 

  13. from openpyxl.drawing.text import  RichTextProperties,Paragraph,ParagraphProperties, CharacterProperties
    14. 

  14. import openpyxl.utils as utils
    15. 

  15. from openpyxl.chart.text import RichText
    16. 

  16. from shutil import copyfile
    17. 

  17. from copy import copy
    18. 

  18. 

  19. dateStyle = NamedStyle(name='custom_datetime', number_format='DD/MM/YYYY HH:MM:MM')
    20. 

  20. from openpyxl.styles.numbers import FORMAT_DATE_DATETIME
    21. 

  21. stdSizeMapColumn = {
    22. 

  22. "D": "F",
    23. 

  23. "T": "G",
    24. 

  24. "H": "H",
    25. 

  25. "A": "I",
    26. 

  26. "B": "J",
    27. 

  27. "C": "K",
    28. 

  28. "E": "L",
    29. 

  29. "F": "M",
    30. 

  30. "G": "N",
    31. 

  31. "J": "O",
    32. 

  32. "K": "P",
    33. 

  33. "L": "Q",
    34. 

  34. "M": "R",
    35. 

  35. "N": "S",
    36. 

  36. "O": "T",
    37. 

  37. "P": "U",
    38. 

  38. "U": "V",
    39. 

  39. "Q": "W",
    40. 

  40. "R": "X",
    41. 

  41. "S": "Y",
    42. 

  42. "W": "Z",
    43. 

  43. "Y": "AA",
    44. 

  44. "Z": "AB",
    45. 

  45. "X1": "AC",
    46. 

  46. "X2": "AD",
    47. 

  47. "Thickness": "AE",
    48. 

  48. "Flatness": "AF",
    49. 

  49. "FLATNESS": "AF",
    50. 

  50. "Cen": "AG",
    51. 

  51. "Weight": "AH",
    52. 

  52. "Result": "AI",
    53. 

  53. }
    54. 

  54. codeMap = {
    55. 

  55.         "001": "D",
    56. 

  56.         "002": "T",
    57. 

  57.         "003": "H",
    58. 

  58.         "02": "P",
    59. 

  59.         "03": "E",
    60. 

  60.         "39": "E",
    61. 

  61.         "04": "W",
    62. 

  62.         "05": "JK",
    63. 

  63.         "06": "F",
    64. 

  64.         "51": "F",
    65. 

  65.         "07": "G",
    66. 

  66.         "B2": "G",
    67. 

  67.         "08": "U",
    68. 

  68.         "09": "M",
    69. 

  69.         "10": "A",
    70. 

  70.         "11": "N",
    71. 

  71.         "12": "J",
    72. 

  72.         "13": "X",
    73. 

  73.         "14": "Flatness",
    74. 

  74.         "15": "K",
    75. 

  75.         "16": "Thickness",
    76. 

  76.         "17": "Q",
    77. 

  77.         "18": "S",
    78. 

  78.         "72": "X",
    79. 

  79.         "61": "U"
    80. 

  80.         }
    81. 

  81. # Specifying the ODBC driver, server name, database, etc. directly
    82. 

  82. #cnxn = None
    83. 

  83. #cursor = None
    84. 

  84. '''cursor.execute('select * from data_wb')
    85. 

  85. rows = cursor.fetchall()
    86. 

  86. for row in rows:
    87. 

  87.     print(row)'''
    88. 

  88. 

  89. wb = load_workbook(filename = './measurement-temp.xlsx',read_only=False, keep_links=False, data_only=False)
    90. 

  90. #wb0 = load_workbook(filename = './testfile.xlsx', read_only=False, keep_links=False, data_only=False)
    91. 

  91. 

  92. #wb.save(filename = './createfrompy.xlsx');
    93. 

  93. def findCustomer(code):
    94. 

  94.     global cursor
    95. 

  95.     global env
    96. 

  96. 

  97.     tempResult = []
    98. 

  98.     views = []
    99. 

  99.     if env == "prod":
    100. 

  100.         views = ["bel_master_view", "e_master_view", "mg_master_view", "v_master_view"]
    101. 

  101.     else:
    102. 

  102.         views = ["bel_master_view_dev", "e_master_view_dev", "mg_master_view_dev", "v_master_view_dev"]
    103. 

  103. 

  104.     ts = []
    105. 

  105. 

  106.     select = "distinct MI24 as unbStd, PRO1C as customer, cast(PRO8 as varchar) + ' ' + cast(PRO9 as varchar) + cast(PRO10 as varchar)  +  'x' + cast(PRO11 as varchar ) + 'x' + cast(PRO12 as varchar) as sizestring, cast(PRO13 as varchar) + ' ' + cast(PRO14 as varchar) + ' ' + cast(PRO15 as varchar) + ' ' + cast(PRO16 as varchar) + ' ' + cast(PRO17 as varchar) + ' ' + cast(PRO18 as varchar) as spec"
    107. 

  107.     where = "PRO1 = '{0}'".format(code)
    108. 

  108.     for v in views:
    109. 

  109.         sqlQuery = "select {0} from {1} where {2}".format(select, v, where)
    110. 

  110.         ts.append(sqlQuery)
    111. 

  111.     merged = []
    112. 

  112.     for t in ts:
    113. 

  113.         merged += cursor.execute(t)
    114. 

  114.     return merged
    115. 

  115. def createWS(name, values, codeno, filters):
    116. 

  116.     global wb
    117. 

  117.     #wb.create_sheet(name)
    118. 

  118.     wo = wb['Data Measurement']
    119. 

  119.     ws = wb.copy_worksheet(wo)
    120. 

  120.     ws.title = name
    121. 

  121.     cust = findCustomer(codeno.replace("-", ""))
    122. 

  122.     ws["B2"] = cust[0].customer
    123. 

  123.     applyStyleName(ws["B2"], "blackborder")
    124. 

  124.     ws["B3"] = codeno.replace("-", "")
    125. 

  125.     applyStyleName(ws["B3"], "blackborder")
    126. 

  126.     ws["B4"] = cust[0].sizestring
    127. 

  127.     applyStyleName(ws["B4"], "blackborder")
    128. 

  128.     ws["B5"] = cust[0].spec
    129. 

  129.     applyStyleName(ws["B5"], "blackborder")
    130. 

  130. 

  131.     bcode = ord('B')
    132. 

  132.     ccode = 2
    133. 

  133.     for idx, val in enumerate(values):
    134. 

  134.         #print(idx)
    135. 

  135.         c = chr(bcode + idx)
    136. 

  136.         #print(val.lot_no)
    137. 

  137.         if  ( bcode + idx) > ord('Z'):
    138. 

  138.             r = bcode + idx - ord('Z')
    139. 

  139.             c = 'A' + chr(ord('A') + (r - 1))
    140. 

  140.             #print("c = "+c)
    141. 

  141. 

  142.         applyStyleName(ws.cell(column= ccode, row=45, value = val.lot_no), "blackborder")
    143. 

  143.         ms = findInMasterView('*', "PRO2 = '{0}'".format(val.lot_no))
    144. 

  144.         #pressInfo = findPressInfo(codeno.replace("-", ""),val.lot_no, filters)
    145. 

  145.         #print("master view")
    146. 

  146.         #print(ms)
    147. 

  147.         if ms:
    148. 

  148.             ws.cell(column = ccode, row=35, value = ms[0].MI24)
    149. 

  149.             #ws[c+'38'] = ms[0].STD_Balance
    150. 

  150.             ws.cell(column = ccode , row=37, value =  ms[0].PRO6)
    151. 

  151.             #ws[c+'44'] = ms[0].PRO5
    152. 

  152.             ws.cell(column = ccode, row = 43, value = ms[0].PRO10)
    153. 

  153.             ws.cell(column = ccode, row = 42, value = ms[0].PRO12)
    154. 

  154. 

  155.         #if pressInfo:
    156. 

  156.         ws.cell(column = ccode , row=39, value = val.Press_UserName)
    157. 

  157.         ws.cell(column = ccode, row = 40, value = val.Press_McName)
    158. 

  158.         #print(type(pressInfo[0].Insp_Date))
    159. 

  159.         #ws[c+'46'].number_format = "Short Date"
    160. 

  160.         ws.cell(column = ccode, row = 46 , value = val.Insp_Date.date())
    161. 

  161.         #print(type(ws[c+'46'].value))
    162. 

  162.         #ws[c+'46'].style = dateStyle
    163. 

  163.         #ws[c+'46'].value = datetime.datetime(2010, 7, 21)
    164. 

  164. 

  165.         #print(ws[c+'46'].number_format)
    166. 

  166. 

  167.         #ws[c+'46']. = datetime.datetime
    168. 

  168.         ws.cell(column = ccode , row = 44, value = val.FG_Qty)
    169. 

  169. 

  170.         dws = updateLength(val.lot_no)
    171. 

  171.         for j,v in enumerate(dws):
    172. 

  172.             ws.cell(column = ccode , row = 48+v.row_no , value  = v.weight)
    173. 

  173. 

  174.         dws = updateUb(val.lot_no)
    175. 

  175.         for j,v in enumerate(dws):
    176. 

  176.             ws.cell(column = ccode , row = 171+v.row_no , value  = v.weight)
    177. 

  177. 

  178.         ccode += 1
    179. 

  179. 

  180.     c1 = LineChart()
    181. 

  181.     c1.legend.position = "t";
    182. 

  182.     c1.title = "Graph of Result Cp Unbalance"
    183. 

  183.     c1.title.font = Font(underline=Font.UNDERLINE_SINGLE)
    184. 

  184.     c1.y_axis.title = "Unb Weight"
    185. 

  185.     c1.y_axis.number_format = "#,##0.00"
    186. 

  186.     c1.x_axis.title  = "Lot No"
    187. 

  187.     c1.width = 30
    188. 

  188.     c1.height = 10
    189. 

  189. 

  190. 

  191.     #print(len(values))
    192. 

  192.     lt = Reference(ws, min_col=2, max_col=len(values)+1, min_row=45, max_row=45)
    193. 

  193.     data = Reference(ws, min_col=1, max_col=len(values)+1, min_row=34, max_row=34)
    194. 

  194. 

  195.     maxUB = Reference(ws, min_col=1, max_col=len(values)+1, min_row=29, max_row=29)
    196. 

  196.     minUB = Reference(ws, min_col=1, max_col=len(values)+1, min_row=30, max_row=30)
    197. 

  197.     avgUB = Reference(ws, min_col=1, max_col=len(values)+1, min_row=31, max_row=31)
    198. 

  198.     vsStd = Reference(ws, min_col=1, max_col=len(values)+1, min_row=36, max_row=36)
    199. 

  199. 

  200. 

  201.     c1.add_data(data, from_rows=True, titles_from_data=True)
    202. 

  202.     c1.add_data(minUB, from_rows=True, titles_from_data=True)
    203. 

  203.     c1.add_data(avgUB, from_rows=True, titles_from_data=True)
    204. 

  204.     c1.add_data(vsStd, from_rows=True, titles_from_data=True)
    205. 

  205.     c1.add_data(maxUB, from_rows=True, titles_from_data=True)
    206. 

  206. 

  207. 

  208.     s1 = c1.series[0]
    209. 

  209.     s1.marker.symbol = "triangle"
    210. 

  210.     s1.graphicalProperties.line.noFill = True
    211. 

  211. 

  212.     s1 = c1.series[1]
    213. 

  213.     s1.marker.symbol = "circle"
    214. 

  214.     s1.graphicalProperties.line.noFill = True
    215. 

  215. 

  216.     s1 = c1.series[2]
    217. 

  217.     s1.marker.symbol = "square"
    218. 

  218.     s1.graphicalProperties.line.noFill = True
    219. 

  219. 

  220.     s1 = c1.series[4]
    221. 

  221.     s1.marker.symbol = "diamond"
    222. 

  222.     s1.graphicalProperties.line.noFill = True
    223. 

  223. 

  224.     c1.set_categories(lt)
    225. 

  225. 

  226.     c1.x_axis.txPr = RichText(bodyPr=RichTextProperties(anchor="ctr",anchorCtr="1",rot="-2700000",
    227. 

  227.                spcFirstLastPara="1",vertOverflow="ellipsis",wrap="square"),
    228. 

  228.             p=[Paragraph(pPr=ParagraphProperties(defRPr=CharacterProperties()), endParaRPr=CharacterProperties())])
    229. 

  229. 

  230.     ws.add_chart(c1, "A7")
    231. 

  231.     #newws.title = name
    232. 

  232.     #copy data cp ws
    233. 

  233.     #insert values in the sheet
    234. 

  234. def findInMasterView(select, where):
    235. 

  235.     global cursor
    236. 

  236.     global env
    237. 

  237. 

  238.     tempResult = []
    239. 

  239.     views = []
    240. 

  240.     if env == "prod":
    241. 

  241.         views = ["bel_master_view", "e_master_view", "mg_master_view", "v_master_view"]
    242. 

  242.     else:
    243. 

  243.         views = ["bel_master_view_dev", "e_master_view_dev", "mg_master_view_dev", "v_master_view_dev"]
    244. 

  244. 

  245. 

  246. 

  247.     ts = []
    248. 

  248.     for v in  views:
    249. 

  249.         sqlQuery = "select {0} from {1} where {2}".format(select, v, where)
    250. 

  250.         ts.append(sqlQuery);
    251. 

  251. 

  252.     qj = ';'.join(ts)
    253. 

  253.     #print(qj)
    254. 

  254.     merged = []
    255. 

  255.     for t in ts:
    256. 

  256.         merged += cursor.execute(t)
    257. 

  257.         if len(merged) > 0:
    258. 

  258.             return merged
    259. 

  259.     return merged
    260. 

  260. 

  261. def findPressInfo(code, lot, year):
    262. 

  262.     global cursor
    263. 

  263.     global env
    264. 

  264. 

  265.     fyear = year.replace("created_at", "Insp_Date")
    266. 

  266.     q = "select * from tb_fg_pressinfo_lotlist where ProductCode = '{0}' and LotNo = '{1}' and {2}" \
    267. 

  267.     .format(code, lot, fyear)
    268. 

  268. 

  269.     cursor.execute(q)
    270. 

  270.     return cursor.fetchall()
    271. 

  271. def findProductDimension(codeno):
    272. 

  272.     stdSizes = """
    273. 

  273.     select * from AllProduct_Dimension_ForInsProcess where ProductCode='{0}'""".format(codeno.replace("-", ""))
    274. 

  274.     #print(stdSizes)
    275. 

  275.     return stdSizes
    276. 

  276. 

  277. def generateSQLDataMS(codeno, filters):
    278. 

  278. 

  279.     if codeno.find('-') != -1:
    280. 

  280.         codeString = codeno
    281. 

  281.     else:
    282. 

  282.         codeString  = codeno[0] + "-" + codeno[1:5] + "-" + codeno[5:9] + "-" + codeno[9:10]
    283. 

  283. 

  284.     if filters is not None:
    285. 

  285.         qMsData = """
    286. 

  286.         select * from data_ms where code='{0}' and {1} order by lot_no asc, row_no asc
    287. 

  287.         """.format(codeString, filters)
    288. 

  288.     else:
    289. 

  289.         qMsData = """
    290. 

  290.         select * from data_ms where code='{0}' order by lot_no asc, row_no asc
    291. 

  291.         """.format(codeString)
    292. 

  292.     return qMsData
    293. 

  293. 

  294. def updateLength(lotno):
    295. 

  295.     global cursor
    296. 

  296.     global wb
    297. 

  297. 

  298.     q = "select * from data_wb where lot_no = '{0}' and judgement='OK' order by row_no asc".format(lotno)
    299. 

  299.     #print(q);
    300. 

  300.     return cursor.execute(q)
    301. 

  301. 

  302. def updateUb(lotno):
    303. 

  303.     global cursor
    304. 

  304.     global wb
    305. 

  305. 

  306.     q = "select * from data_wb where lot_no = '{0}' and judgement='NG' order by row_no asc".format(lotno)
    307. 

  307.     #print(q);
    308. 

  308.     return cursor.execute(q)
    309. 

  309. 

  310. def actualChart(ws, title, data, position_data, body_data, cat_pos, position):
    311. 

  311.     '''
    312. 

  312.     for row in rows:
    313. 

  313.         ws.append(row)
    314. 

  314.     '''
    315. 

  315.     if isinstance(position_data, str):
    316. 

  316.         rs = ws[position_data]
    317. 

  317.     else:
    318. 

  318.         rs = tuple(ws.iter_rows(**position_data))
    319. 

  319. 

  320.     for i in range(len(rs)):
    321. 

  321.         for j in range(len(rs[i])):
    322. 

  322.             print(rs[i][j])
    323. 

  323.             rs[i][j].value = data[i][j]
    324. 

  324.     #ws["A1"].value = rows
    325. 

  325.     #print(cells)
    326. 

  326.     #print(rs)
    327. 

  327.     #return
    328. 

  328.     c1 = LineChart()
    329. 

  329.     c1.width = 10
    330. 

  330.     #c1.height = 10
    331. 

  331.     c1.title = title
    332. 

  332.     c1.style = 13
    333. 

  333.     c1.y_axis.title = 'Size'
    334. 

  334.     c1.x_axis.title = 'Lot'
    335. 

  335.     #print(ws.title+"?"+position_data)
    336. 

  336.     if isinstance(body_data, str):
    337. 

  337.         rdata = Reference(range_string=ws.title+"!"+body_data)
    338. 

  338.     else:
    339. 

  339.         rdata = Reference(ws, **body_data)
    340. 

  340. 

  341.     c1.add_data(rdata, titles_from_data=True)
    342. 

  342. 

  343.     if isinstance(cat_pos, str):
    344. 

  344.         lots = Reference(range_string=ws.title+"!"+cat_pos)
    345. 

  345.     else:
    346. 

  346.         lots = Reference(ws, **cat_pos)
    347. 

  347. 

  348.     c1.set_categories(lots)
    349. 

  349.     # Style the lines
    350. 

  350.     s1 = c1.series[0]
    351. 

  351.     s1.marker.symbol = "triangle"
    352. 

  352.     s1.marker.graphicalProperties.solidFill = "FF0000" # Marker filling
    353. 

  353.     s1.marker.graphicalProperties.line.solidFill = "FF0000" # Marker outline
    354. 

  354. 

  355.     s1.graphicalProperties.line.noFill = True
    356. 

  356. 

  357.     s2 = c1.series[1]
    358. 

  358.     s2.graphicalProperties.line.solidFill = "00AAAA"
    359. 

  359.     s2.graphicalProperties.line.dashStyle = "sysDot"
    360. 

  360.     s2.graphicalProperties.line.width = 100050 # width in EMUs
    361. 

  361. 

  362.     s2 = c1.series[2]
    363. 

  363.     s2.smooth = True # Make the line smooth
    364. 

  364. 

  365.     if isinstance(position,str):
    366. 

  366.         ws.add_chart(c1, position)
    367. 

  367.     else:
    368. 

  368.         ptemp = get_column_letter(position[1])
    369. 

  369.         #print("ptemp = ", ptemp)
    370. 

  370.         ws.add_chart(c1, ptemp + str(position[0]))
    371. 

  371. 

  372. def createXBarChart(codeno, filters):
    373. 

  373.     global cursor
    374. 

  374.     global wb
    375. 

  375.     global dateStyle
    376. 

  376.     global codeMap
    377. 

  377.     ws = wb.create_sheet("X Bar,R Chart", 3)
    378. 

  378.     #find lot in a codeno
    379. 

  379.     sql = generateSQLDataMS(codeno, filters)
    380. 

  380.     sql2 = findProductDimension(codeno)
    381. 

  381. 

  382.     cursor.execute(sql)
    383. 

  383.     row = cursor.fetchall()
    384. 

  384. 

  385.     cursor.execute(sql2)
    386. 

  386.     row2 = cursor.fetchall()
    387. 

  387. 

  388.     temp =  {}
    389. 

  389.     #map data into lotno list
    390. 

  390. 

  391.     #find max, min
    392. 

  392.     sizes = {}
    393. 

  393.     stdSizes = {}
    394. 

  394.     num = 0
    395. 

  395.     for k in row2:
    396. 

  396.         if k.Size_Id in codeMap:
    397. 

  397.             sn = codeMap[k.Size_Id].lower()+"size"
    398. 

  398.             sizes[sn] = []
    399. 

  399.             stdSizes[sn] = k
    400. 

  400. 

  401.     for r in row:
    402. 

  402.         #print(r)
    403. 

  403.         if r.lot_no not in temp:
    404. 

  404.             temp[r.lot_no] = []
    405. 

  405. 

  406.         temp[r.lot_no].append(r)
    407. 

  407.         for k,v in sizes.items():
    408. 

  408.             sizes[k].append(getattr(r, k, None))
    409. 

  409.     #print("temp = ", temp)
    410. 

  410.     #print("temp keys = ", temp.keys());
    411. 

  411.     for k,v in temp.items():
    412. 

  412.         #print("k = ", k)
    413. 

  413.         num  = len(v)
    414. 

  414.         #break
    415. 

  415. 

  416.     #print("num = ", num)
    417. 

  417.     if num > 5:
    418. 

  418.         num = 5
    419. 

  419. 

  420. 

  421.     #filter only dimensions in master
    422. 

  422.     #print("TEMP == \n")
    423. 

  423.     #print(sizes)
    424. 

  424.     avgSize = {}
    425. 

  425.     minSize = {}
    426. 

  426.     maxSize = {}
    427. 

  427. 

  428.     data2 = []
    429. 

  429.     data2.append(["Lot No"])
    430. 

  430.     for k,v  in temp.items():
    431. 

  431.         data2[0].append(k)
    432. 

  432.     #print("data 2 = ", data2)
    433. 

  433. 

  434. 

  435.     #create maxtrix in form
    436. 

  436.     '''
    437. 

  437.     Lot, 1, 2, 3, 4, 5, max, min
    438. 

  438.     xxx, v, v, v, v, v, v, v
    439. 

  439.     '''
    440. 

  440.     bp = 1
    441. 

  441.     for keySize, keyValue in sizes.items():
    442. 

  442.         l = []
    443. 

  443.         n0 = 0
    444. 

  444. 

  445.         beginRow = 2
    446. 

  446.         #print("key size = %s\n" %(keySize) )
    447. 

  447.         for k,v in temp.items():
    448. 

  448.             a0 = []
    449. 

  449.             a0.append(k)
    450. 

  450.             sv = len(v)
    451. 

  451.             if sv > 5:
    452. 

  452.                 sv = 5
    453. 

  453.             n0 = sv
    454. 

  454.             for i in range(sv):
    455. 

  455.                 a0.append(getattr(v[i], keySize, 0))
    456. 

  456.             avg = sum(a0[1:]) / len(a0[1:])
    457. 

  457.             a0.append(avg)
    458. 

  458.             r = max(a0[1:]) - min(a0[1:])
    459. 

  459.             a0.append(r)
    460. 

  460.             #print("std size ", stdSizes[keySize])
    461. 

  461.             maxMaster = float(stdSizes[keySize].Std) + float(stdSizes[keySize].TolUp)
    462. 

  462.             minMaster = float(stdSizes[keySize].Std) + float(stdSizes[keySize].TolUn)
    463. 

  463.             a0.append(maxMaster)
    464. 

  464.             a0.append(minMaster)
    465. 

  465.             l.append(a0)
    466. 

  466.         #print("l = ", l)
    467. 

  467.         header = ["Lot No"] + [str(i+1) for i in range(n0)] + ["avg", "r", "max", "min"]
    468. 

  468.         #print("header =", header)
    469. 

  469.         l = [header] + l;
    470. 

  470.         #print("l = ", l)
    471. 

  471. 

  472.         '''
    473. 

  473.         tranpose above matrix into form:
    474. 

  474.         Lot,xxx, xxx, xxx,
    475. 

  475.         1, v, v, v
    476. 

  476.         2, v, v, v
    477. 

  477.         ...
    478. 

  478.         '''
    479. 

  479.         m, n = len(l), len(l[0])
    480. 

  480.         #print("mxn = ", m, n)
    481. 

  481.         ta = [ [0 for j in range(m)] for i in range(n)]
    482. 

  482.         #print("ta = ", ta)
    483. 

  483.         for i in range(len(l)):
    484. 

  484.             for j in range(len(l[i])):
    485. 

  485.                 try:
    486. 

  486.                     ta[j][i] = l[i][j]
    487. 

  487.                 except:
    488. 

  488.                     pass
    489. 

  489. 

  490.         #print("TA ", ta)
    491. 

  491. 

  492.         #print(len(ta), len(ta[0]))
    493. 

  493.         #print("===\n")
    494. 

  494.         #print(beginRow, beginRow + len(ta) - 1, bp, (bp-1) + len(ta[0]))
    495. 

  495.         wsRows = tuple(ws.iter_rows(min_row=beginRow, max_row=beginRow + len(ta) - 1, min_col=bp, max_col=(bp-1)+len(ta[0])))
    496. 

  496.         for  i in range(len(wsRows)):
    497. 

  497.             for j in range(len(wsRows[i])):
    498. 

  498.                 #print(i,j)
    499. 

  499.                 wsRows[i][j].value = ta[i][j]
    500. 

  500.                 wsRows[i][j].number_format = '0.00'
    501. 

  501.                 bd = Side(style='medium', color="000000")
    502. 

  502.                 wsRows[i][j].border = Border(left=bd, top=bd, right=bd, bottom=bd)
    503. 

  503.         ws.cell(1, bp, value = "%s-size (bar)" % (keySize.upper().replace("SIZE", "")))
    504. 

  504.         #bp += len(ta[0]) + 2
    505. 

  505.         #continue
    506. 

  506. 

  507.         cpos = utils.get_column_letter(bp) + "15"
    508. 

  508. 

  509. 

  510.         font_test = drawingText.Font(typeface='Calibri')
    511. 

  511.         cp = CharacterProperties(latin=font_test, sz=1000)
    512. 

  512. 

  513.         c1 = LineChart()
    514. 

  514.         pp = ParagraphProperties(defRPr=cp)
    515. 

  515. 

  516.         cp1 = CharacterProperties(latin=font_test, sz=1400)
    517. 

  517.         pp1 = ParagraphProperties(defRPr=cp1)
    518. 

  518. 

  519. 

  520.         minValues = Reference(ws, min_row=beginRow+9, min_col=bp+1, max_row=beginRow+9, max_col=(bp-1)+len(ta[0]) )
    521. 

  521.         minSerie = Series(minValues, title="Min")
    522. 

  522.         c1.append(minSerie)
    523. 

  523. 

  524.         maxValues = Reference(ws, min_row=beginRow+8, min_col=bp+1, max_row=beginRow+8, max_col=(bp-1)+len(ta[0]) )
    525. 

  525.         maxSerie = Series(maxValues, title="Max")
    526. 

  526.         c1.append(maxSerie)
    527. 

  527. 

  528.         avgValues = Reference(ws, min_row=beginRow+6, min_col=bp+1, max_row=beginRow+6, max_col=(bp-1)+len(ta[0]) )
    529. 

  529.         avgSerie = Series(avgValues, title="Avg")
    530. 

  530.         avgSerie.marker.symbol = "circle"
    531. 

  531.         avgSerie.marker.graphicalProperties.solidFill = "4f81bd" # Marker filling
    532. 

  532.         avgSerie.graphicalProperties.line.solidFill = "4f81bd"
    533. 

  533. 

  534.         c1.append(avgSerie)
    535. 

  535. 

  536. 

  537. 

  538.         lots = Reference(ws,min_row=beginRow, min_col=bp+1, max_row=beginRow, max_col=(bp-1)+len(ta[0]))
    539. 

  539.         c1.set_categories(lots)
    540. 

  540. 

  541. 

  542.         c1.width = len(ta[0])*2.7
    543. 

  543.         c1.title = "%s-size (X bar)" % (keySize.upper().replace("SIZE", ""))
    544. 

  544.         #c1.title.txPr = RichText(p=[Paragraph(pPr=ParagraphProperties(defRPr=cp), endParaRPr=cp)])
    545. 

  545.         c1.y_axis.title = "Value(mm.)"
    546. 

  546.         c1.x_axis.title = "Lot No."
    547. 

  547. 

  548.         c1.x_axis.title.tx.rich.p[0].pPr = pp# Works!
    549. 

  549.         c1.y_axis.title.tx.rich.p[0].pPr = pp# Works!
    550. 

  550.         c1.title.tx.rich.p[0].pPr = pp1# Works!
    551. 

  551.         c1.legend.position = "b"
    552. 

  552.         ws.add_chart(c1, cpos)
    553. 

  553. 

  554.         cpos = utils.get_column_letter(bp) + "30"
    555. 

  555. 

  556.         c2 = LineChart()
    557. 

  557. 

  558.         #c2.title.txPr = RichText(p=[Paragraph(pPr=ParagraphProperties(defRPr=cp), endParaRPr=cp)])
    559. 

  559. 

  560.         rValues = Reference(ws, min_row=beginRow+7, min_col=bp+1, max_row=beginRow+7, max_col=(bp-1)+len(ta[0]) )
    561. 

  561.         rSerie = Series(rValues, title="R")
    562. 

  562.         c2.append(rSerie)
    563. 

  563. 

  564.         lots = Reference(ws,min_row=beginRow, min_col=bp+1, max_row=beginRow, max_col=(bp-1)+len(ta[0]))
    565. 

  565.         c2.set_categories(lots)
    566. 

  566. 

  567.         c2.width = len(ta[0])*2.7
    568. 

  568.         c2.title = "%s-size (R)" % (keySize.upper().replace("SIZE", ""))
    569. 

  569.         c2.y_axis.title = "Value(mm.)"
    570. 

  570.         c2.x_axis.title = "Lot No."
    571. 

  571. 

  572.         c2.x_axis.title.tx.rich.p[0].pPr = pp# Works!
    573. 

  573.         c2.y_axis.title.tx.rich.p[0].pPr = pp# Works!
    574. 

  574.         c2.title.tx.rich.p[0].pPr = pp1# Works!
    575. 

  575. 

  576.         c2.legend.position = "b"
    577. 

  577.         ws.add_chart(c2, cpos)
    578. 

  578.         #move column cursor
    579. 

  579.         bp += len(ta[0]) + 5
    580. 

  580. 

  581. def createCp(codeno, filters):
    582. 

  582.     global cursor
    583. 

  583.     global wb
    584. 

  584.     global dateStyle
    585. 

  585.     global codeMap
    586. 

  586.     ws = wb.create_sheet("CP Press")
    587. 

  587.     #find lot in a codeno
    588. 

  588.     sql = generateSQLDataMS(codeno, filters)
    589. 

  589.     sql2 = findProductDimension(codeno)
    590. 

  590. 

  591.     cursor.execute(sql)
    592. 

  592.     row = cursor.fetchall()
    593. 

  593. 

  594.     cursor.execute(sql2)
    595. 

  595.     row2 = cursor.fetchall()
    596. 

  596. 

  597.     temp =  {}
    598. 

  598.     #map data into lotno list
    599. 

  599. 

  600.     #find max, min
    601. 

  601.     sizes = {}
    602. 

  602.     stdSizes = {}
    603. 

  603. 

  604.     for k in row2:
    605. 

  605.         if k.Size_Id in codeMap:
    606. 

  606.             sn = codeMap[k.Size_Id].lower()+"size"
    607. 

  607.             sizes[sn] = []
    608. 

  608.             stdSizes[sn] = k
    609. 

  609. 

  610.     for r in row:
    611. 

  611.         #print(r)
    612. 

  612.         if r.lot_no not in temp:
    613. 

  613.             temp[r.lot_no] = []
    614. 

  614. 

  615.         temp[r.lot_no].append(r)
    616. 

  616.         for k,v in sizes.items():
    617. 

  617.             sizes[k].append(getattr(r, k, None))
    618. 

  618.     #print("temp = ", temp)
    619. 

  619.     #print("temp keys = ", temp.keys());
    620. 

  620.     for k,v in temp.items():
    621. 

  621.         #print("k = ", k)
    622. 

  622.         num  = len(v)
    623. 

  623.         #break
    624. 

  624. 

  625.     #print("num = ", num)
    626. 

  626.     if num > 5:
    627. 

  627.         num = 5
    628. 

  628. 

  629. 

  630.     #filter only dimensions in master
    631. 

  631.     #print("TEMP == \n")
    632. 

  632.     #print(sizes)
    633. 

  633.     avgSize = {}
    634. 

  634.     minSize = {}
    635. 

  635.     maxSize = {}
    636. 

  636. 

  637.     data2 = []
    638. 

  638.     data2.append(["Lot No"])
    639. 

  639.     for k,v  in temp.items():
    640. 

  640.         data2[0].append(k)
    641. 

  641.     #print("data 2 = ", data2)
    642. 

  642. 

  643. 

  644.     #create maxtrix in form
    645. 

  645.     '''
    646. 

  646.     Lot, 1, 2, 3, 4, 5, max, min
    647. 

  647.     xxx, v, v, v, v, v, v, v
    648. 

  648.     '''
    649. 

  649.     bp = 1
    650. 

  650.     for keySize, keyValue in sizes.items():
    651. 

  651.         l = []
    652. 

  652.         n0 = 0
    653. 

  653. 

  654.         beginRow = 2
    655. 

  655.         #print("key size = %s\n" %(keySize) )
    656. 

  656.         for k,v in temp.items():
    657. 

  657.             a0 = []
    658. 

  658.             a0.append(k)
    659. 

  659.             sv = len(v)
    660. 

  660.             if sv > 5:
    661. 

  661.                 sv = 5
    662. 

  662.             n0 = sv
    663. 

  663.             for i in range(sv):
    664. 

  664.                 a0.append(getattr(v[i], keySize, 0))
    665. 

  665.             avg = sum(a0[1:]) / len(a0[1:])
    666. 

  666.             a0.append(avg)
    667. 

  667.             r = max(a0[1:]) - min(a0[1:])
    668. 

  668.             a0.append(r)
    669. 

  669.             #print("std size ", stdSizes[keySize])
    670. 

  670.             maxMaster = float(stdSizes[keySize].Std) + float(stdSizes[keySize].TolUp)
    671. 

  671.             minMaster = float(stdSizes[keySize].Std) + float(stdSizes[keySize].TolUn)
    672. 

  672.             a0.append(maxMaster)
    673. 

  673.             a0.append(minMaster)
    674. 

  674.             l.append(a0)
    675. 

  675.         #print("l = ", l)
    676. 

  676.         header = ["Lot No"] + [str(i+1) for i in range(n0)] + ["avg", "r", "max", "min"]
    677. 

  677.         #print("header =", header)
    678. 

  678.         l = [header] + l;
    679. 

  679.         #print("l = ", l)
    680. 

  680. 

  681.         '''
    682. 

  682.         tranpose above matrix into form:
    683. 

  683.         Lot,xxx, xxx, xxx,
    684. 

  684.         1, v, v, v
    685. 

  685.         2, v, v, v
    686. 

  686.         ...
    687. 

  687.         '''
    688. 

  688.         m, n = len(l), len(l[0])
    689. 

  689.         #print("mxn = ", m, n)
    690. 

  690.         ta = [ [0 for j in range(m)] for i in range(n)]
    691. 

  691.         #print("ta = ", ta)
    692. 

  692.         for i in range(len(l)):
    693. 

  693.             for j in range(len(l[i])):
    694. 

  694.                 ta[j][i] = l[i][j]
    695. 

  695. 

  696.         #print("TA ", ta)
    697. 

  697. 

  698.         #print(len(ta), len(ta[0]))
    699. 

  699.         #print("===\n")
    700. 

  700.         #print(beginRow, beginRow + len(ta) - 1, bp, (bp-1) + len(ta[0]))
    701. 

  701.         wsRows = tuple(ws.iter_rows(min_row=beginRow, max_row=beginRow + len(ta) - 1, min_col=bp, max_col=(bp-1)+len(ta[0])))
    702. 

  702.         for  i in range(len(wsRows)):
    703. 

  703.             for j in range(len(wsRows[i])):
    704. 

  704.                 #print(i,j)
    705. 

  705.                 wsRows[i][j].value = ta[i][j]
    706. 

  706.                 wsRows[i][j].number_format = '0.00'
    707. 

  707.                 bd = Side(style='medium', color="000000")
    708. 

  708.                 wsRows[i][j].border = Border(left=bd, top=bd, right=bd, bottom=bd)
    709. 

  709.         ws.cell(1, bp, value = "%s-size (bar)" % (keySize.upper().replace("SIZE", "")))
    710. 

  710.         #bp += len(ta[0]) + 2
    711. 

  711.         #continue
    712. 

  712. 

  713.         cpos = utils.get_column_letter(bp) + "15"
    714. 

  714. 

  715. 

  716.         font_test = drawingText.Font(typeface='Calibri')
    717. 

  717.         cp = CharacterProperties(latin=font_test, sz=1000)
    718. 

  718. 

  719.         c1 = LineChart()
    720. 

  720.         pp = ParagraphProperties(defRPr=cp)
    721. 

  721. 

  722.         cp1 = CharacterProperties(latin=font_test, sz=1400)
    723. 

  723.         pp1 = ParagraphProperties(defRPr=cp1)
    724. 

  724. 

  725. 

  726.         minValues = Reference(ws, min_row=beginRow+9, min_col=bp+1, max_row=beginRow+9, max_col=(bp-1)+len(ta[0]) )
    727. 

  727.         minSerie = Series(minValues, title="Min")
    728. 

  728.         c1.append(minSerie)
    729. 

  729. 

  730.         maxValues = Reference(ws, min_row=beginRow+8, min_col=bp+1, max_row=beginRow+8, max_col=(bp-1)+len(ta[0]) )
    731. 

  731.         maxSerie = Series(maxValues, title="Max")
    732. 

  732.         c1.append(maxSerie)
    733. 

  733. 

  734.         avgValues = Reference(ws, min_row=beginRow+6, min_col=bp+1, max_row=beginRow+6, max_col=(bp-1)+len(ta[0]) )
    735. 

  735.         avgSerie = Series(avgValues, title="Avg")
    736. 

  736.         avgSerie.marker.symbol = "circle"
    737. 

  737.         avgSerie.marker.graphicalProperties.solidFill = "4f81bd" # Marker filling
    738. 

  738.         avgSerie.graphicalProperties.line.solidFill = "4f81bd"
    739. 

  739. 

  740.         c1.append(avgSerie)
    741. 

  741. 

  742. 

  743. 

  744.         lots = Reference(ws,min_row=beginRow, min_col=bp+1, max_row=beginRow, max_col=(bp-1)+len(ta[0]))
    745. 

  745.         c1.set_categories(lots)
    746. 

  746. 

  747. 

  748.         c1.width = len(ta[0])*3.5
    749. 

  749.         c1.title = "%s-size (X bar)" % (keySize.upper().replace("SIZE", ""))
    750. 

  750.         #c1.title.txPr = RichText(p=[Paragraph(pPr=ParagraphProperties(defRPr=cp), endParaRPr=cp)])
    751. 

  751.         c1.y_axis.title = "Value(mm.)"
    752. 

  752.         c1.x_axis.title = "Lot No."
    753. 

  753. 

  754.         c1.x_axis.title.tx.rich.p[0].pPr = pp# Works!
    755. 

  755.         c1.y_axis.title.tx.rich.p[0].pPr = pp# Works!
    756. 

  756.         c1.title.tx.rich.p[0].pPr = pp1# Works!
    757. 

  757.         c1.legend.position = "b"
    758. 

  758.         ws.add_chart(c1, cpos)
    759. 

  759. 

  760.         cpos = utils.get_column_letter(bp) + "30"
    761. 

  761. 

  762.         c2 = LineChart()
    763. 

  763. 

  764.         #c2.title.txPr = RichText(p=[Paragraph(pPr=ParagraphProperties(defRPr=cp), endParaRPr=cp)])
    765. 

  765. 

  766.         rValues = Reference(ws, min_row=beginRow+7, min_col=bp+1, max_row=beginRow+7, max_col=(bp-1)+len(ta[0]) )
    767. 

  767.         rSerie = Series(rValues, title="R")
    768. 

  768.         c2.append(rSerie)
    769. 

  769. 

  770.         lots = Reference(ws,min_row=beginRow, min_col=bp+1, max_row=beginRow, max_col=(bp-1)+len(ta[0]))
    771. 

  771.         c2.set_categories(lots)
    772. 

  772. 

  773.         c2.width = len(ta[0])*3.5
    774. 

  774.         c2.title = "%s-size (R)" % (keySize.upper().replace("SIZE", ""))
    775. 

  775.         c2.y_axis.title = "Value(mm.)"
    776. 

  776.         c2.x_axis.title = "Lot No."
    777. 

  777. 

  778.         c2.x_axis.title.tx.rich.p[0].pPr = pp# Works!
    779. 

  779.         c2.y_axis.title.tx.rich.p[0].pPr = pp# Works!
    780. 

  780.         c2.title.tx.rich.p[0].pPr = pp1# Works!
    781. 

  781. 

  782.         c2.legend.position = "b"
    783. 

  783.         ws.add_chart(c2, cpos)
    784. 

  784.         #move column cursor
    785. 

  785.         bp += len(ta[0]) + 5
    786. 

  786. 

  787.     #create each size table and chart types
    788. 

  788.     # actual chart
    789. 

  789. def createChart(codeno, filters):
    790. 

  790.     global cursor
    791. 

  791.     global wb
    792. 

  792.     global dateStyle
    793. 

  793.     global codeMap
    794. 

  794.     #ws = wb.create_sheet("chart2")
    795. 

  795.     #find lot in a codeno
    796. 

  796.     sql = generateSQLDataMS(codeno, filters)
    797. 

  797.     #print(sql)
    798. 

  798.     sql2 = findProductDimension(codeno)
    799. 

  799. 

  800.     cursor.execute(sql)
    801. 

  801.     row = cursor.fetchall()
    802. 

  802. 

  803.     cursor.execute(sql2)
    804. 

  804.     row2 = cursor.fetchall()
    805. 

  805. 

  806.     temp =  {}
    807. 

  807.     #map data into lotno list
    808. 

  808. 

  809.     #find max, min
    810. 

  810.     sizes = {}
    811. 

  811.     stdSizes = {}
    812. 

  812. 

  813.     for k in row2:
    814. 

  814.         if k.Size_Id in codeMap:
    815. 

  815.             sn = codeMap[k.Size_Id].lower()+"size"
    816. 

  816.             sizes[sn] = []
    817. 

  817.             stdSizes[sn] = k
    818. 

  818. 

  819.     for r in row:
    820. 

  820.         #print(r)
    821. 

  821.         if r.lot_no not in temp:
    822. 

  822.             temp[r.lot_no] = []
    823. 

  823. 

  824.         temp[r.lot_no].append(r)
    825. 

  825.         for k,v in sizes.items():
    826. 

  826.             sizes[k].append(getattr(r, k, None))
    827. 

  827. 

  828. 

  829. 

  830. 

  831. 

  832.     #filter only dimensions in master
    833. 

  833.     #print("TEMP == \n")
    834. 

  834.     #print(sizes)
    835. 

  835.     avgSize = {}
    836. 

  836.     minSize = {}
    837. 

  837.     maxSize = {}
    838. 

  838. 

  839.     
    840. 

  840.     for k, v in sizes.items():
    841. 

  841.         #print(k, v)
    842. 

  842.         if len(v) > 0 and v[0] is not None:
    843. 

  843.             avgSize[k] = sum(v)/len(v)
    844. 

  844.             minSize[k] = min(v)
    845. 

  845.             maxSize[k] = max(v)
    846. 

  846. 

  847.     #print("avg size \n",avgSize)
    848. 

  848.     #print("min size \n",minSize)
    849. 

  849.     #print("max size \n",maxSize)
    850. 

  850. 

  851. 

  852. 

  853.     for k1,v1 in temp.items():
    854. 

  854.         #print("\nlot %s \n" %( k1))
    855. 

  855.         ws = wb.create_sheet("lot %s actual" %(k1))
    856. 

  856.         i = 0
    857. 

  857.         bp = 1
    858. 

  858.         for k,v in sizes.items():
    859. 

  859.             #print("%s actual" % (k))
    860. 

  860.             data = [
    861. 

  861.                 ["Max (%s) size" % (k) ],
    862. 

  862.                 ['Min'],
    863. 

  863.                 ['Actual'],
    864. 

  864.                 ['No.'],
    865. 

  865.                 ['Lot No.']
    866. 

  866.             ]
    867. 

  867.             nrow = len(data)
    868. 

  868.             for v2 in v1:
    869. 

  869.                     #print("std size ", stdSizes[keySize])
    870. 

  870.                 maxMaster = float(stdSizes[k].Std) + float(stdSizes[k].TolUp)
    871. 

  871.                 minMaster = float(stdSizes[k].Std) + float(stdSizes[k].TolUn)
    872. 

  872.                 data[0].append(maxMaster)
    873. 

  873.                 data[1].append(minMaster)
    874. 

  874.                 data[2].append(getattr(v2, k))
    875. 

  875.                 data[3].append(v2.row_no)
    876. 

  876.                 data[4].append(v2.lot_no)
    877. 

  877.             #print(data)
    878. 

  878. 

  879.             #gen chart
    880. 

  880.             #print("min col ", bp)
    881. 

  881.             wsRows = tuple(ws.iter_rows(min_row=1, max_row=len(data), min_col=bp, max_col= (bp - 1)+len(data[0])))
    882. 

  882. 

  883.             for i in range(len(wsRows)):
    884. 

  884.                 for j in range(len(wsRows[i])):
    885. 

  885.                     #print(i,j)
    886. 

  886.                     #data[i][j])
    887. 

  887.                     #print(wsRows[i][j])
    888. 

  888.                     wsRows[i][j].value = data[i][j]
    889. 

  889.                     if i != 3:
    890. 

  890.                         wsRows[i][j].number_format = '0.00'
    891. 

  891.                     bd = Side(style='medium', color="000000")
    892. 

  892.                     wsRows[i][j].border = Border(left=bd, top=bd, right=bd, bottom=bd)
    893. 

  893. 

  894.             cpos = utils.get_column_letter(bp) + "10"
    895. 

  895. 

  896.             font_test = drawingText.Font(typeface='Calibri')
    897. 

  897.             cp = CharacterProperties(latin=font_test, sz=1000)
    898. 

  898.             pp = ParagraphProperties(defRPr=cp)
    899. 

  899. 

  900.             cp1 = CharacterProperties(latin=font_test, sz=1400)
    901. 

  901.             pp1 = ParagraphProperties(defRPr=cp1)
    902. 

  902. 

  903.             c1 = LineChart()
    904. 

  904. 

  905.             maxValues = Reference(ws, min_row=1, min_col=bp+1, max_row=1, max_col=(bp-1)+len(data[0]) )
    906. 

  906.             maxSerie = Series(maxValues, title="Max")
    907. 

  907.             maxSerie.graphicalProperties.line.solidFill = "FF0000"
    908. 

  908.             c1.append(maxSerie)
    909. 

  909. 

  910.             minValues = Reference(ws, min_row=2, min_col=bp+1, max_row=2, max_col=(bp-1)+len(data[0]) )
    911. 

  911.             minSerie = Series(minValues, title="Min")
    912. 

  912.             minSerie.graphicalProperties.line.solidFill = "000000"
    913. 

  913.             c1.append(minSerie)
    914. 

  914. 

  915.             acValues = Reference(ws, min_row=3, min_col=bp+1, max_row=3, max_col=(bp-1)+len(data[0]) )
    916. 

  916.             acSerie = Series(acValues, title="Actual")
    917. 

  917.             acSerie.marker.graphicalProperties.solidFill = "4f81bd" # Marker filling
    918. 

  918.             acSerie.graphicalProperties.line.solidFill = "4f81bd"
    919. 

  919.             acSerie.marker.symbol = "circle"
    920. 

  920. 

  921.             c1.append(acSerie)
    922. 

  922. 

  923.             lots = Reference(ws,min_row=4, min_col=bp+1, max_row=4, max_col=(bp-1)+len(data[0]))
    924. 

  924.             c1.set_categories(lots)
    925. 

  925. 

  926. 

  927.             c1.width = len(data[0])*1.8
    928. 

  928.             c1.title = "%s-size (actual) " % (k.upper().replace("SIZE", ""))
    929. 

  929.             c1.y_axis.title = "Value(mm.)"
    930. 

  930.             c1.x_axis.title = "Item No."
    931. 

  931. 

  932.             c1.x_axis.title.tx.rich.p[0].pPr = pp# Works!
    933. 

  933.             c1.y_axis.title.tx.rich.p[0].pPr = pp# Works!
    934. 

  934.             c1.title.tx.rich.p[0].pPr = pp1# Works!
    935. 

  935. 

  936.             c1.legend.position = "b"
    937. 

  937.             ws.add_chart(c1, cpos)
    938. 

  938. 

  939.             bp += len(data[0]) + 2
    940. 

  940.             #print()
    941. 

  941. 

  942. 

  943. 

  944. 

  945.             #print("M"+str(bp))
    946. 

  946.             #bp += coEndCell[1]+1+10
    947. 

  947. 

  948.             #print(ws.calculate_dimension())
    949. 

  949. 

  950. 

  951. 

  952.     #create each size table and chart types
    953. 

  953.     # actual chart
    954. 

  954. 

  955. def createExcel(codeno, filters):
    956. 

  956.     global cursor
    957. 

  957.     global wb
    958. 

  958.     global dateStyle
    959. 

  959.     global stdSizeMapColumn
    960. 

  960. 

  961.     ws  = wb["Data Measurement"]
    962. 

  962.     codeString = ""
    963. 

  963. 

  964. 

  965.     if codeno.find('-') != -1:
    966. 

  966.         codeString = codeno
    967. 

  967.     else:
    968. 

  968.         codeString  = codeno[0] + "-" + codeno[1:5] + "-" + codeno[5:9] + "-" + codeno[9:10]
    969. 

  969. 

  970.     # std sizes
    971. 

  971.     stdSizes = """
    972. 

  972.     select * from AllProduct_Dimension_ForInsProcess where ProductCode='{0}'""".format(codeString.replace("-", ""))
    973. 

  973.     #print(stdSizes)
    974. 

  974.     cursor.execute(stdSizes)
    975. 

  975.     rows = cursor.fetchall()
    976. 

  976. 

  977. 

  978.     for k,v in stdSizeMapColumn.items():
    979. 

  979.         if k not in ["Weight", "Result"]:
    980. 

  980.             ws.column_dimensions[v].hidden = True
    981. 

  981. 

  982.     enableCols = []
    983. 

  983.     for r in rows:
    984. 

  984.         minv = float(r.Std) + float(r.TolUn)
    985. 

  985.         stdv = float(r.Std)
    986. 

  986.         maxv = float(r.Std) + float(r.TolUp)
    987. 

  987.         #print(r.Size_Name.replace("size", "").replace("Size", "").strip())
    988. 

  988.         #print(r.Size_Name.replace("size", "").replace("Size", "").strip() in stdSizeMapColumn)
    989. 

  989. 

  990.         if r.Size_Name.replace("size", "").replace("Size", "").strip() in stdSizeMapColumn:
    991. 

  991.             colName = stdSizeMapColumn[r.Size_Name.replace("size", "").replace("Size", "").strip()]
    992. 

  992.             #print(colName)
    993. 

  993.             #print(colName+"12")
    994. 

  994.             #print(min)
    995. 

  995.             ws.column_dimensions[colName].hidden = False
    996. 

  996.             ws.column_dimensions[colName].bestFit = True
    997. 

  997.             ws.column_dimensions[colName].width = 8
    998. 

  998. 

  999.             #print(colName)
    1000. 

  1000.             #print(ws.column_dimensions[colName].hidden)
    1001. 

  1001.             #print(ws.column_dimensions[colName].collapsed)
    1002. 

  1002.             #print(ws.column_dimensions[colName].bestFit)
    1003. 

  1003.             #print(ws.column_dimensions[colName].width)
    1004. 

  1004. 

  1005. 

  1006. 

  1007.             ws[colName+"12"] = minv #min
    1008. 

  1008.             applyStyleName(ws[colName+"12"], "border", "0.00")
    1009. 

  1009.             ws[colName+"11"] = stdv #std
    1010. 

  1010.             applyStyleName(ws[colName+"11"], "border", "0.00")
    1011. 

  1011.             ws[colName+"10"] = maxv #max
    1012. 

  1012.             applyStyleName(ws[colName+"10"], "border", "0.00")
    1013. 

  1013.             enableCols.append(r.Size_Name.replace("size", "").replace("Size", "").strip())
    1014. 

  1014. 

  1015.     #print(enableCols)
    1016. 

  1016.     maxQuery = [ "max(%ssize) as %s"% ( x.lower(), x.upper() )  for x in enableCols]
    1017. 

  1017.     #print(maxQuery)
    1018. 

  1018.     if filters is not None:
    1019. 

  1019.         if codeno != "undefined":
    1020. 

  1020.             qt = "select {2} from data_ms where code='{0}' and ( (size1 > 0) or (size2 > 0)) and {1}".format(codeString, filters, ",".join(maxQuery))
    1021. 

  1021.         else:
    1022. 

  1022.             qt = "select * from data_ms where  ( (size1 > 0) or (size2 > 0)) and {1}".format(codeString, filters, ",".join(maxQuery))
    1023. 

  1023. 

  1024. 

  1025.     else:
    1026. 

  1026.         if codeno != "undefined":
    1027. 

  1027.             qt = "select {1} from data_ms where code='{0}' and ( (size1 > 0 ) or (size2 > 0))".format(codeString, ",".join(maxQuery))
    1028. 

  1028.         else:
    1029. 

  1029.             qt = "select * from data_ms where ( (size1 > 0) or (size2 > 0))".format(codeString, ",".join(maxQuery))
    1030. 

  1030. 

  1031. 

  1032.     #print("qt = ", qt)
    1033. 

  1033.     cursor.execute(qt)
    1034. 

  1034.     rows = cursor.fetchall()
    1035. 

  1035.     for r in rows:
    1036. 

  1036.         #print(r.cursor_description)
    1037. 

  1037.         for c in r.cursor_description:
    1038. 

  1038.             #print(c)
    1039. 

  1039.             #print(getattr(r, c[0]))
    1040. 

  1040.             colName = stdSizeMapColumn[c[0]]
    1041. 

  1041.             ws[colName+"8"] = getattr(r, c[0])
    1042. 

  1042.             applyStyleName(ws[colName+"8"], "border")
    1043. 

  1043. 

  1044.     maxQuery = [ "min(%ssize) as %s"% ( x.lower(), x.upper() )  for x in enableCols]
    1045. 

  1045. 

  1046. 

  1047.     #print(maxQuery)
    1048. 

  1048.     if filters is not None:
    1049. 

  1049.         if codeno != "undefined":
    1050. 

  1050.             qt = "select {2} from data_ms where code='{0}' and {1}".format(codeString, filters, ",".join(maxQuery))
    1051. 

  1051.         else:
    1052. 

  1052.             qt = "select * from data_ms where  {1}".format(codeString, filters, ",".join(maxQuery))
    1053. 

  1053. 

  1054. 

  1055.     else:
    1056. 

  1056.         if codeno != "undefined":
    1057. 

  1057.             qt = "select {1} from data_ms where code='{0}'".format(codeString, ",".join(maxQuery))
    1058. 

  1058.         else:
    1059. 

  1059.             qt = "select * from data_ms".format(codeString, ",".join(maxQuery))
    1060. 

  1060.     '''
    1061. 

  1061.     if filters is not None:
    1062. 

  1062.         qt = "select {2} from data_ms where code='{0}' and {1}".format(codeString, filters, ",".join(maxQuery))
    1063. 

  1063.     else:
    1064. 

  1064.         qt = "select {1} from data_ms where code='{0}'".format(codeString, ",".join(maxQuery))
    1065. 

  1065.     '''
    1066. 

  1066. 

  1067.     #print(qt)
    1068. 

  1068. 

  1069. 

  1070.     cursor.execute(qt)
    1071. 

  1071.     rows = cursor.fetchall()
    1072. 

  1072.     for r in rows:
    1073. 

  1073.         #print(r.cursor_description)
    1074. 

  1074.         for c in r.cursor_description:
    1075. 

  1075.             #print(c)
    1076. 

  1076.             #print(getattr(r, c[0]))
    1077. 

  1077.             colName = stdSizeMapColumn[c[0]]
    1078. 

  1078.             ws[colName+"9"] = getattr(r, c[0])
    1079. 

  1079.             applyStyleName(ws[colName+"9"], "border")
    1080. 

  1080. 

  1081.     #query data
    1082. 

  1082.     if filters is not None:
    1083. 

  1083.         qMsData = """
    1084. 

  1084.         select * from data_ms where code='{0}' and {1} order by lot_no asc, row_no asc
    1085. 

  1085.         """.format(codeString, filters)
    1086. 

  1086.     else:
    1087. 

  1087.         qMsData = """
    1088. 

  1088.         select * from data_ms where code='{0}' order by lot_no asc, row_no asc
    1089. 

  1089.         """.format(codeString)
    1090. 

  1090. 

  1091.     cursor.execute(qMsData)
    1092. 

  1092.     rows = cursor.fetchall()
    1093. 

  1093.     startRow = 15
    1094. 

  1094. 

  1095. 

  1096.     for r in rows:
    1097. 

  1097.         isNG = False
    1098. 

  1098.         if r.dsize == 0 and r.hsize == 0 and r.tsize == 0:
    1099. 

  1099.             continue
    1100. 

  1100. 

  1101.         if int(r.row_no) == 1:
    1102. 

  1102.             ws.cell(column = 1, row = startRow, value = r.created_at).number_format = "m/d/yy"
    1103. 

  1103.             applyStyleName(ws.cell(column = 1, row = startRow), "border", "m/d/yy")
    1104. 

  1104. 

  1105.             ws.cell(column = 2, row = startRow, value = r.code)
    1106. 

  1106.             applyStyleName(ws.cell(column = 2, row = startRow), "border")
    1107. 

  1107. 

  1108.             ws.cell(column = 3, row = startRow, value=r.lot_no)
    1109. 

  1109.             applyStyleName(ws.cell(column = 3, row = startRow), "border")
    1110. 

  1110. 

  1111.             countLot = """
    1112. 

  1112.             select count(*) as c from data_ms where lot_no = '{0}'
    1113. 

  1113.             """.format(r.lot_no)
    1114. 

  1114.             cursor.execute(countLot)
    1115. 

  1115.             countResult =  cursor.fetchall()
    1116. 

  1116.             #print(countResult)
    1117. 

  1117.             ws.cell(column = 4, row = startRow, value = countResult[0].c).number_format = "0"
    1118. 

  1118.             applyStyleName(ws.cell(column = 4, row = startRow), "border")
    1119. 

  1119. 

  1120.         c = ws.cell(column=5, row = startRow, value = int(r.row_no))
    1121. 

  1121.         applyStyleName(ws.cell(column = 5, row = startRow), "border")
    1122. 

  1122.         c.number_format = "0"
    1123. 

  1123. 

  1124. 

  1125.         colstr = stdSizeMapColumn.get("D")
    1126. 

  1126.         ws[colstr + str(startRow)] = r.dsize
    1127. 

  1127.         applyStyleName(ws[colstr + str(startRow)], "border")
    1128. 

  1128. 

  1129.         if r.dsizeOk == "NG":
    1130. 

  1130.             isNG = True
    1131. 

  1131.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1132. 

  1132. 

  1133.         colstr = stdSizeMapColumn.get("T")
    1134. 

  1134.         ws[colstr + str(startRow)] = r.tsize
    1135. 

  1135.         applyStyleName(ws[colstr + str(startRow)], "border")
    1136. 

  1136. 

  1137.         if r.tsizeOk == "NG":
    1138. 

  1138.             isNG = True
    1139. 

  1139.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1140. 

  1140. 

  1141.         colstr = stdSizeMapColumn.get("H")
    1142. 

  1142.         applyStyleName(ws[colstr + str(startRow)], "border")
    1143. 

  1143. 

  1144.         if ( r.hdev is not None) and ( r.hsizeproxy is not None ) and (r.hsizeproxy != 'null')  and ( r.hdev.strip() != "") and (r.hdev.strip() != 'null'):
    1145. 

  1145.             ws[colstr + str(startRow)] = "%s/%s" % (r.hsizeproxy.strip(), r.hdev.strip())
    1146. 

  1146.         else:
    1147. 

  1147.             if ( r.hsizeproxy is not None ) and ( r.hsizeproxy.strip() != 'null'):
    1148. 

  1148.                 proxyStrip = r.hsizeproxy.strip()
    1149. 

  1149.                 if proxyStrip == "OK" or proxyStrip == "NG":
    1150. 

  1150.                     ws[colstr + str(startRow)] = proxyStrip
    1151. 

  1151.                 else:
    1152. 

  1152.                     try:
    1153. 

  1153.                         ws[colstr + str(startRow)] = float(proxyStrip.replace("+", ""))
    1154. 

  1154.                     except Exception as e:
    1155. 

  1155.                         pass
    1156. 

  1156. 

  1157. 

  1158. 

  1159.         if r.hsizeOk == "NG":
    1160. 

  1160.             isNG = True
    1161. 

  1161.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1162. 

  1162. 

  1163.         colstr = stdSizeMapColumn.get("C")
    1164. 

  1164.         ws[colstr + str(startRow)] = r.csize
    1165. 

  1165.         applyStyleName(ws[colstr + str(startRow)], "border")
    1166. 

  1166. 

  1167.         if r.csizeOk == "NG":
    1168. 

  1168.             isNG = True
    1169. 

  1169.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1170. 

  1170. 

  1171. 

  1172.         colstr = stdSizeMapColumn.get("E")
    1173. 

  1173.         ws[colstr + str(startRow)] = r.esize
    1174. 

  1174.         applyStyleName(ws[colstr + str(startRow)], "border")
    1175. 

  1175.         if r.esizeOk == "NG":
    1176. 

  1176.             isNG = True
    1177. 

  1177.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1178. 

  1178. 

  1179.         colstr = stdSizeMapColumn.get("F")
    1180. 

  1180.         ws[colstr + str(startRow)] = r.fsize
    1181. 

  1181.         applyStyleName(ws[colstr + str(startRow)], "border")
    1182. 

  1182.         if r.fsizeOk == "NG":
    1183. 

  1183.             isNG = True
    1184. 

  1184.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1185. 

  1185. 

  1186.         colstr = stdSizeMapColumn.get("G")
    1187. 

  1187.         ws[colstr + str(startRow)] = r.gsize
    1188. 

  1188.         applyStyleName(ws[colstr + str(startRow)], "border")
    1189. 

  1189.         if r.gsizeOk == "NG":
    1190. 

  1190.             isNG = True
    1191. 

  1191.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1192. 

  1192. 

  1193.         colstr = stdSizeMapColumn.get("J")
    1194. 

  1194.         ws[colstr+str(startRow)] = r.jsize
    1195. 

  1195.         applyStyleName(ws[colstr + str(startRow)], "border")
    1196. 

  1196. 

  1197.         if r.jsizeOk == "NG":
    1198. 

  1198.             isNG = True
    1199. 

  1199.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1200. 

  1200. 

  1201. 

  1202.         colstr = stdSizeMapColumn.get("K")
    1203. 

  1203.         ws[colstr+str(startRow)] = r.ksize
    1204. 

  1204.         applyStyleName(ws[colstr + str(startRow)], "border")
    1205. 

  1205. 

  1206.         if r.ksizeOk == "NG":
    1207. 

  1207.             isNG = True
    1208. 

  1208.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1209. 

  1209. 

  1210.         colstr = stdSizeMapColumn.get("M")
    1211. 

  1211.         ws[colstr+str(startRow)] = r.msize
    1212. 

  1212.         applyStyleName(ws[colstr + str(startRow)], "border")
    1213. 

  1213. 

  1214.         if r.msizeOk == "NG":
    1215. 

  1215.             isNG = True
    1216. 

  1216.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1217. 

  1217. 

  1218.         colstr = stdSizeMapColumn.get("N")
    1219. 

  1219.         ws[colstr+str(startRow)] = r.nsize
    1220. 

  1220.         applyStyleName(ws[colstr + str(startRow)], "border")
    1221. 

  1221. 

  1222.         if r.nsizeOk == "NG":
    1223. 

  1223.             isNG = True
    1224. 

  1224.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1225. 

  1225. 

  1226.         colstr = stdSizeMapColumn.get("P")
    1227. 

  1227.         ws[colstr+str(startRow)] = r.psize
    1228. 

  1228.         applyStyleName(ws[colstr + str(startRow)], "border")
    1229. 

  1229. 

  1230.         if r.psizeOk == "NG":
    1231. 

  1231.             isNG = True
    1232. 

  1232.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1233. 

  1233. 

  1234.         colstr = stdSizeMapColumn.get("U")
    1235. 

  1235.         ws[colstr+str(startRow)] = r.usize
    1236. 

  1236.         applyStyleName(ws[colstr + str(startRow)], "border")
    1237. 

  1237. 

  1238.         if r.usizeOk == "NG":
    1239. 

  1239.             isNG = True
    1240. 

  1240.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1241. 

  1241. 

  1242.         colstr = stdSizeMapColumn.get("W")
    1243. 

  1243.         ws[colstr+str(startRow)] = r.wsize
    1244. 

  1244.         applyStyleName(ws[colstr + str(startRow)], "border")
    1245. 

  1245. 

  1246.         if r.wsizeOk == "NG":
    1247. 

  1247.             isNG = True
    1248. 

  1248.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1249. 

  1249. 

  1250. 

  1251. 

  1252.         colstr = stdSizeMapColumn.get("Weight")
    1253. 

  1253.         ws[colstr+str(startRow)] = r.weight
    1254. 

  1254.         applyStyleName(ws[colstr + str(startRow)], "border")
    1255. 

  1255. 

  1256.         colstr = stdSizeMapColumn.get("Result")
    1257. 

  1257.         applyStyleName(ws[colstr + str(startRow)], "border")
    1258. 

  1258. 

  1259.         if isNG == True:
    1260. 

  1260.             ws[colstr+ str(startRow)] = "NG"
    1261. 

  1261.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1262. 

  1262.         else:
    1263. 

  1263.             ws[colstr+ str(startRow)] = "OK"
    1264. 

  1264. 

  1265. 

  1266.         '''
    1267. 

  1267.         colstr = stdSizeMapColumn.get("X")
    1268. 

  1268.         ws[colstr+str(startRow)].value = r.xsize
    1269. 

  1269.         if r.xsizeOk == "NG":
    1270. 

  1270.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1271. 

  1271. 

  1272.         '''
    1273. 

  1273. 

  1274. 

  1275.         #ws['U'+str(startRow)] = r.ysize or 0
    1276. 

  1276.         #ysize.font= Font(color = colors.Red)
    1277. 

  1277.         #ws['V'+str(startRow)] = r.zsize
    1278. 

  1278. 

  1279.         startRow += 1
    1280. 

  1280. 

  1281.     #print(ws._charts)
    1282. 

  1282.     if codeno != "undefined":
    1283. 

  1283.         cust = findCustomer(codeno.replace("-", ""))
    1284. 

  1284.         ws["B3"] = codeno.replace("-", "")
    1285. 

  1285.         applyStyleName(ws["B3"], "border")
    1286. 

  1286. 

  1287.         if cust:
    1288. 

  1288.             ws["B2"] = cust[0].customer
    1289. 

  1289.             applyStyleName(ws["B2"], "border")
    1290. 

  1290. 

  1291.             ws["B4"] = cust[0].sizestring
    1292. 

  1292.             applyStyleName(ws["B4"], "border")
    1293. 

  1293. 

  1294.             ws["B5"] = cust[0].spec
    1295. 

  1295.             applyStyleName(ws["B5"], "border")
    1296. 

  1296. 

  1297. def enableColFunc(ws, code, enableCols):
    1298. 

  1298.     global cursor
    1299. 

  1299.     global stdSizeMapColumn
    1300. 

  1300.     # std sizes
    1301. 

  1301.     stdSizes = """
    1302. 

  1302.     select * from AllProduct_Dimension_ForInsProcess where ProductCode='{0}'""".format(code.replace("-", ""))
    1303. 

  1303.     #print(stdSizes)
    1304. 

  1304.     cursor.execute(stdSizes)
    1305. 

  1305.     rows = cursor.fetchall()
    1306. 

  1306. 

  1307.     for r in rows:
    1308. 

  1308.         if r.Size_Name.replace("size", "").replace("Size", "").strip() in stdSizeMapColumn:
    1309. 

  1309.             colName = stdSizeMapColumn[r.Size_Name.replace("size", "").replace("Size", "").strip()]
    1310. 

  1310.             #print(colName+"12")
    1311. 

  1311.             #print(min)
    1312. 

  1312.             ws.column_dimensions[colName].hidden = False
    1313. 

  1313.             stripSize =  r.Size_Name.replace("size", "").replace("Size").strip()
    1314. 

  1314.             if stripSize not in enableCols:
    1315. 

  1315.                 enableCols.append(stripSize)
    1316. 

  1316. 

  1317. def applyStyleName(cell, styleName, format=None):
    1318. 

  1318.     cell.style = styleName
    1319. 

  1319.     if format is not None:
    1320. 

  1320.         #print(format)
    1321. 

  1321.         cell.number_format = format
    1322. 

  1322.     else:
    1323. 

  1323.         cell.number_format = "0.00"
    1324. 

  1324. 

  1325. def createExcelDaily(codeno, filters, segment):
    1326. 

  1326.     global cursor
    1327. 

  1327.     global wb
    1328. 

  1328.     global dateStyle
    1329. 

  1329.     #wb["Data Measurement"].sheet_state = 'hidden'
    1330. 

  1330.     ws  = wb["Daily"]
    1331. 

  1331.     codeString = ""
    1332. 

  1332. 

  1333. 

  1334. 

  1335.     for idx in range(1, 13):
    1336. 

  1336.         ws.row_dimensions[idx].hidden = True
    1337. 

  1337. 

  1338.     for k,v in stdSizeMapColumn.items():
    1339. 

  1339.         if k not in ["Weight", "Result"]:
    1340. 

  1340.             ws.column_dimensions[v].hidden = True
    1341. 

  1341. 

  1342.     enableCols = []
    1343. 

  1343. 

  1344.     if codeno != "" and codeno != "undefined":
    1345. 

  1345.         if codeno.find('-') != -1:
    1346. 

  1346.             codeString = codeno
    1347. 

  1347.         else:
    1348. 

  1348.             codeString  = codeno[0] + "-" + codeno[1:5] + "-" + codeno[5:9] + "-" + codeno[9:10]
    1349. 

  1349. 

  1350.         # std sizes
    1351. 

  1351.         stdSizes = """
    1352. 

  1352.         select * from AllProduct_Dimension_ForInsProcess where ProductCode='{0}'""".format(codeString.replace("-", ""))
    1353. 

  1353.         #print(stdSizes)
    1354. 

  1354.         cursor.execute(stdSizes)
    1355. 

  1355.         rows = cursor.fetchall()
    1356. 

  1356.         for r in rows:
    1357. 

  1357.             minv = float(r.Std) + float(r.TolUn)
    1358. 

  1358.             stdv = float(r.Std)
    1359. 

  1359.             maxv = float(r.Std) + float(r.TolUp)
    1360. 

  1360. 

  1361.             if r.Size_Name.replace("size", "").strip() in stdSizeMapColumn:
    1362. 

  1362.                 colName = stdSizeMapColumn[r.Size_Name.replace("size", "").strip()]
    1363. 

  1363.                 #print(colName+"12")
    1364. 

  1364.                 #print(min)
    1365. 

  1365.                 ws.column_dimensions[colName].hidden = False
    1366. 

  1366.                 #ws[colName+"12"] = minv #min
    1367. 

  1367.                 #ws[colName+"11"] = stdv #std
    1368. 

  1368.                 #ws[colName+"10"] = maxv #max
    1369. 

  1369.                 enableCols.append(r.Size_Name.replace("size", "").strip())
    1370. 

  1370. 

  1371. 

  1372. 

  1373. 

  1374.     if codeno ==  "undefined":
    1375. 

  1375.         distinct_qt = "select distinct(code) code from data_ms where  {1}".format(codeString, filters)
    1376. 

  1376.         cursor.execute(distinct_qt)
    1377. 

  1377.         rows = cursor.fetchall()
    1378. 

  1378. 

  1379.         #print("dist = ", distinct_qt)
    1380. 

  1380. 

  1381.         for r in rows:
    1382. 

  1382.             enableColFunc(ws, r.code, enableCols)
    1383. 

  1383. 

  1384.     maxQuery = [ "max(%ssize) as %s"% ( x.lower(), x.upper() )  for x in enableCols]
    1385. 

  1385.     #print(maxQuery)
    1386. 

  1386.     if filters is not None:
    1387. 

  1387.         if codeno != "undefined":
    1388. 

  1388.             qt = "select {2} from data_ms where code='{0}' and {1}".format(codeString, filters, ",".join(maxQuery))
    1389. 

  1389.         else:
    1390. 

  1390.             qt = "select {2} from data_ms where  {1}".format(codeString, filters, ",".join(maxQuery))
    1391. 

  1391. 

  1392. 

  1393.     else:
    1394. 

  1394.         if codeno != "undefined" and codeno != "":
    1395. 

  1395.             qt = "select {1} from data_ms where code='{0}'".format(codeString, ",".join(maxQuery))
    1396. 

  1396.         else:
    1397. 

  1397.             qt = "select {1} from data_ms".format(codeString, ",".join(maxQuery))
    1398. 

  1398. 

  1399. 

  1400.     #print("qt = ", qt)
    1401. 

  1401. 

  1402.     cursor.execute(qt)
    1403. 

  1403.     rows = cursor.fetchall()
    1404. 

  1404.     for r in rows:
    1405. 

  1405.         #print(r.cursor_description)
    1406. 

  1406.         #enableColFunc(ws, r.code, enableCols)
    1407. 

  1407.         for c in r.cursor_description:
    1408. 

  1408.             #print(c)
    1409. 

  1409.             #print(getattr(r, c[0]))
    1410. 

  1410.             if c[0] in stdSizeMapColumn:
    1411. 

  1411.                 colName = stdSizeMapColumn[c[0]]
    1412. 

  1412.                 #ws[colName+"8"] = getattr(r, c[0])
    1413. 

  1413. 

  1414.     maxQuery = [ "min(%ssize) as %s"% ( x.lower(), x.upper() )  for x in enableCols]
    1415. 

  1415. 

  1416. 

  1417.     #print(maxQuery)
    1418. 

  1418.     if filters is not None:
    1419. 

  1419.         if codeno != "undefined":
    1420. 

  1420.             qt = "select {2} from data_ms where code='{0}' and {1}".format(codeString, filters, ",".join(maxQuery))
    1421. 

  1421.         else:
    1422. 

  1422.             qt = "select {2} from data_ms where  {1}".format(codeString, filters, ",".join(maxQuery))
    1423. 

  1423. 

  1424. 

  1425.     else:
    1426. 

  1426.         if codeno != "undefined":
    1427. 

  1427.             qt = "select {1} from data_ms where code='{0}'".format(codeString, ",".join(maxQuery))
    1428. 

  1428.         else:
    1429. 

  1429.             qt = "select {1} from data_ms".format(codeString, ",".join(maxQuery))
    1430. 

  1430.     '''
    1431. 

  1431.     if filters is not None:
    1432. 

  1432.         qt = "select {2} from data_ms where code='{0}' and {1}".format(codeString, filters, ",".join(maxQuery))
    1433. 

  1433.     else:
    1434. 

  1434.         qt = "select {1} from data_ms where code='{0}'".format(codeString, ",".join(maxQuery))
    1435. 

  1435.     '''
    1436. 

  1436. 

  1437. 

  1438. 

  1439. 

  1440.     cursor.execute(qt)
    1441. 

  1441.     rows = cursor.fetchall()
    1442. 

  1442.     for r in rows:
    1443. 

  1443.         #print(r.cursor_description)
    1444. 

  1444.         for c in r.cursor_description:
    1445. 

  1445.             #print(c)
    1446. 

  1446.             #print(getattr(r, c[0]))
    1447. 

  1447.             if c[0] in stdSizeMapColumn:
    1448. 

  1448.                 colName = stdSizeMapColumn[c[0]]
    1449. 

  1449.                 #ws[colName+"9"] = getattr(r, c[0])
    1450. 

  1450. 

  1451.     #query data
    1452. 

  1452.     joinString = joinSelect = ""
    1453. 

  1453.     #print("segment = ", segment)
    1454. 

  1454.     if segment != None:
    1455. 

  1455.         joinSelect = ",lt.*"
    1456. 

  1456.         joinString = "inner join LotTracking lt on ms.id = lt.datams_id and lt.machineGroup = '{0}'" .format(segment)
    1457. 

  1457.         filters = "ms."+filters
    1458. 

  1458.     else:
    1459. 

  1459.         joinSelect = ",lt.*"
    1460. 

  1460.         joinString = "inner join LotTracking lt on ms.id = lt.datams_id" .format(segment)
    1461. 

  1461.         filters = "ms."+filters
    1462. 

  1462.     #print(joinString)
    1463. 

  1463.     if filters is not None:
    1464. 

  1464.         if codeno != "undefined":
    1465. 

  1465.             qMsData = """
    1466. 

  1466.             select ms.* {3} from data_ms ms {2} where code='{0}' and {1} order by lot_no asc, row_no asc
    1467. 

  1467.             """.format(codeString, filters, joinString, joinSelect)
    1468. 

  1468.         else:
    1469. 

  1469.             qMsData = """
    1470. 

  1470.             select ms.* {3} from data_ms ms {2} where  {1} order by lot_no asc, row_no asc
    1471. 

  1471.             """.format(codeString, filters, joinString, joinSelect)
    1472. 

  1472.     else:
    1473. 

  1473.         if codeno != "undefined":
    1474. 

  1474.             qMsData = """
    1475. 

  1475.             select ms.* {2} from data_ms ms {1} where code='{0}' order by lot_no asc, row_no asc
    1476. 

  1476.             """.format(codeString, joinString, joinSelect)
    1477. 

  1477.         else:
    1478. 

  1478.             qMsData = """
    1479. 

  1479.             select ms.* {2} from data_ms ms {1} order by lot_no asc, row_no asc
    1480. 

  1480.             """.format(codeString, joinString, joinSelect)
    1481. 

  1481. 

  1482.     #print(qMsData)
    1483. 

  1483.     cursor.execute(qMsData)
    1484. 

  1484.     rows = cursor.fetchall()
    1485. 

  1485.     startRow = 15
    1486. 

  1486. 

  1487.     styleName = "border"
    1488. 

  1488.     for r in rows:
    1489. 

  1489.         isNG = False
    1490. 

  1490. 

  1491.         '''
    1492. 

  1492.         if r.dsize == 0 and r.hsize == 0 and r.tsize == 0:
    1493. 

  1493.             continue
    1494. 

  1494.         '''
    1495. 

  1495. 

  1496.         if int(r.row_no) == 1:
    1497. 

  1497.             ws.cell(column = 1, row = startRow, value = r.created_at).number_format = "m/d/yy"
    1498. 

  1498.             ws.cell(column = 1, row = startRow).style = styleName
    1499. 

  1499. 

  1500.             ws.cell(column = 2, row = startRow, value = r.code)
    1501. 

  1501.             ws.cell(column = 2, row = startRow).style = styleName
    1502. 

  1502. 

  1503.             ws.cell(column = 3, row = startRow, value=r.lot_no)
    1504. 

  1504.             ws.cell(column = 3, row = startRow).style = styleName
    1505. 

  1505.             countLot = """
    1506. 

  1506.             select count(*) as c from data_ms where lot_no = '{0}'
    1507. 

  1507.             """.format(r.lot_no)
    1508. 

  1508.             cursor.execute(countLot)
    1509. 

  1509.             countResult =  cursor.fetchall()
    1510. 

  1510.             #print(countResult)
    1511. 

  1511.             ws.cell(column = 4, row = startRow, value = countResult[0].c).number_format = "0"
    1512. 

  1512.             ws.cell(column = 4, row = startRow).style = styleName
    1513. 

  1513. 

  1514.         c = ws.cell(column=5, row = startRow, value = int(r.row_no))
    1515. 

  1515.         c.style = styleName
    1516. 

  1516.         c.number_format = "0"
    1517. 

  1517. 

  1518.         ws["AJ"+str(startRow)] = r.emp_id
    1519. 

  1519.         ws["AJ"+str(startRow)].style = styleName
    1520. 

  1520. 

  1521.         ws["AK"+str(startRow)] = r.created_at
    1522. 

  1522.         applyStyleName(ws["AK"+str(startRow)], styleName, FORMAT_DATE_DATETIME)
    1523. 

  1523. 

  1524. 

  1525.         colstr = stdSizeMapColumn.get("D")
    1526. 

  1526.         ws[colstr + str(startRow)] = r.dsize
    1527. 

  1527.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1528. 

  1528.         if r.dsizeOk == "NG":
    1529. 

  1529.             isNG = True
    1530. 

  1530.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1531. 

  1531. 

  1532.         colstr = stdSizeMapColumn.get("T")
    1533. 

  1533.         ws[colstr + str(startRow)] = r.tsize
    1534. 

  1534.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1535. 

  1535.         if r.tsizeOk == "NG":
    1536. 

  1536.             isNG = True
    1537. 

  1537.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1538. 

  1538. 

  1539.         colstr = stdSizeMapColumn.get("H")
    1540. 

  1540.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1541. 

  1541.         if ( r.hdev is not None) and ( r.hsizeproxy is not None ) and (r.hsizeproxy != 'null')  and ( r.hdev.strip() != "") and (r.hdev.strip() != 'null'):
    1542. 

  1542.             ws[colstr + str(startRow)] = "%s/%s" % (r.hsizeproxy.strip(), r.hdev.strip())
    1543. 

  1543.         else:
    1544. 

  1544.             if ( r.hsizeproxy is not None ) and ( r.hsizeproxy.strip() != 'null'):
    1545. 

  1545.                 proxyStrip = r.hsizeproxy.strip()
    1546. 

  1546.                 if proxyStrip == "OK" or proxyStrip == "NG":
    1547. 

  1547.                     ws[colstr + str(startRow)] = proxyStrip
    1548. 

  1548.                 else:
    1549. 

  1549.                     try:
    1550. 

  1550.                         ws[colstr + str(startRow)] = float(proxyStrip.replace("+", ""))
    1551. 

  1551.                     except Exception as e:
    1552. 

  1552.                         pass
    1553. 

  1553. 

  1554. 

  1555. 

  1556.         if r.hsizeOk == "NG":
    1557. 

  1557.             isNG = True
    1558. 

  1558.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1559. 

  1559. 

  1560.         colstr = stdSizeMapColumn.get("C")
    1561. 

  1561.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1562. 

  1562.         ws[colstr + str(startRow)] = r.csize
    1563. 

  1563.         if r.csizeOk == "NG":
    1564. 

  1564.             isNG = True
    1565. 

  1565.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1566. 

  1566. 

  1567. 

  1568.         colstr = stdSizeMapColumn.get("E")
    1569. 

  1569.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1570. 

  1570.         ws[colstr + str(startRow)] = r.esize
    1571. 

  1571.         if r.esizeOk == "NG":
    1572. 

  1572.             isNG = True
    1573. 

  1573.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1574. 

  1574. 

  1575.         colstr = stdSizeMapColumn.get("F")
    1576. 

  1576.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1577. 

  1577.         ws[colstr + str(startRow)] = r.fsize
    1578. 

  1578.         if r.fsizeOk == "NG":
    1579. 

  1579.             isNG = True
    1580. 

  1580.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1581. 

  1581. 

  1582.         colstr = stdSizeMapColumn.get("G")
    1583. 

  1583.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1584. 

  1584.         ws[colstr + str(startRow)] = r.gsize
    1585. 

  1585.         if r.gsizeOk == "NG":
    1586. 

  1586.             isNG = True
    1587. 

  1587.             ws[colstr + str(startRow)].font = Font(color = colors.RED)
    1588. 

  1588. 

  1589.         colstr = stdSizeMapColumn.get("J")
    1590. 

  1590.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1591. 

  1591.         ws[colstr+str(startRow)] = r.jsize
    1592. 

  1592.         if r.jsizeOk == "NG":
    1593. 

  1593.             isNG = True
    1594. 

  1594.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1595. 

  1595. 

  1596. 

  1597.         colstr = stdSizeMapColumn.get("K")
    1598. 

  1598.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1599. 

  1599.         ws[colstr+str(startRow)] = r.ksize
    1600. 

  1600.         if r.ksizeOk == "NG":
    1601. 

  1601.             isNG = True
    1602. 

  1602.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1603. 

  1603. 

  1604.         colstr = stdSizeMapColumn.get("M")
    1605. 

  1605.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1606. 

  1606.         ws[colstr+str(startRow)] = r.msize
    1607. 

  1607.         if r.msizeOk == "NG":
    1608. 

  1608.             isNG = True
    1609. 

  1609.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1610. 

  1610. 

  1611.         colstr = stdSizeMapColumn.get("N")
    1612. 

  1612.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1613. 

  1613.         ws[colstr+str(startRow)] = r.nsize
    1614. 

  1614.         if r.nsizeOk == "NG":
    1615. 

  1615.             isNG = True
    1616. 

  1616.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1617. 

  1617. 

  1618.         colstr = stdSizeMapColumn.get("P")
    1619. 

  1619.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1620. 

  1620.         ws[colstr+str(startRow)] = r.psize
    1621. 

  1621.         if r.psizeOk == "NG":
    1622. 

  1622.             isNG = True
    1623. 

  1623.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1624. 

  1624. 

  1625.         colstr = stdSizeMapColumn.get("U")
    1626. 

  1626.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1627. 

  1627.         ws[colstr+str(startRow)] = r.usize
    1628. 

  1628.         if r.usizeOk == "NG":
    1629. 

  1629.             isNG = True
    1630. 

  1630.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1631. 

  1631. 

  1632.         colstr = stdSizeMapColumn.get("W")
    1633. 

  1633.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1634. 

  1634.         ws[colstr+str(startRow)] = r.wsize
    1635. 

  1635.         if r.wsizeOk == "NG":
    1636. 

  1636.             isNG = True
    1637. 

  1637.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1638. 

  1638. 

  1639. 

  1640. 

  1641.         colstr = stdSizeMapColumn.get("Weight")
    1642. 

  1642.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1643. 

  1643.         ws[colstr+str(startRow)] = r.weight
    1644. 

  1644. 

  1645.         colstr = stdSizeMapColumn.get("Result")
    1646. 

  1646.         applyStyleName(ws[colstr + str(startRow)], styleName)
    1647. 

  1647. 

  1648.         if isNG == True:
    1649. 

  1649.             ws[colstr+ str(startRow)] = "NG"
    1650. 

  1650.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1651. 

  1651.         else:
    1652. 

  1652.             ws[colstr+ str(startRow)] = "OK"
    1653. 

  1653. 

  1654. 

  1655.         '''
    1656. 

  1656.         colstr = stdSizeMapColumn.get("X")
    1657. 

  1657.         ws[colstr+str(startRow)].value = r.xsize
    1658. 

  1658.         if r.xsizeOk == "NG":
    1659. 

  1659.             ws[colstr+ str(startRow)].font = Font(color = colors.RED)
    1660. 

  1660. 

  1661.         '''
    1662. 

  1662. 

  1663. 

  1664.         #ws['U'+str(startRow)] = r.ysize or 0
    1665. 

  1665.         #ysize.font= Font(color = colors.Red)
    1666. 

  1666.         #ws['V'+str(startRow)] = r.
    1667. 

  1667.         #print(wb.style_names)
    1668. 

  1668.         #print(ws["AJ"+str(startRow)].style)
    1669. 

  1669.         ws["AJ"+str(startRow)] = r.emp_id
    1670. 

  1670.         ws["AJ"+str(startRow)].style = styleName
    1671. 

  1671. 

  1672.         ws["AK"+str(startRow)] = r.created_at
    1673. 

  1673.         applyStyleName(ws["AK"+str(startRow)], styleName, FORMAT_DATE_DATETIME)
    1674. 

  1674. 

  1675.         ws["AL"+str(startRow)] = "Dimension out of specs" if isNG else ""
    1676. 

  1676.         applyStyleName(ws["AL"+str(startRow)], styleName)
    1677. 

  1677. 

  1678.         ws["AN"+str(startRow)] = str(r.machineId)
    1679. 

  1679.         applyStyleName(ws["AN"+str(startRow)], styleName)
    1680. 

  1680. 

  1681.         ws["AO"+str(startRow)] = str(r.machineGroup)
    1682. 

  1682.         applyStyleName(ws["AO"+str(startRow)], styleName)
    1683. 

  1683. 

  1684.         startRow += 1
    1685. 

  1685. 

  1686. 

  1687.     #print(ws._charts)
    1688. 

  1688.     if codeno != "undefined":
    1689. 

  1689.         cust = findCustomer(codeno.replace("-", ""))
    1690. 

  1690.         ws["B3"] = codeno.replace("-", "")
    1691. 

  1691.         if cust:
    1692. 

  1692.             ws["B2"] = cust[0].customer
    1693. 

  1693.             ws["B4"] = cust[0].sizestring
    1694. 

  1694.             ws["B5"] = cust[0].spec
    1695. 

  1695. 

  1696. if __name__ == "__main__":
    1697. 

  1697.     env = sys.argv[1]
    1698. 

  1698.     code = sys.argv[2]
    1699. 

  1699. 

  1700.     #print(len(sys.argv))
    1701. 

  1701. 

  1702.     df = None
    1703. 

  1703.     segment = None
    1704. 

  1704.     #print(len(sys.argv))
    1705. 

  1705.     if len(sys.argv) > 3:
    1706. 

  1706.         filter = sys.argv[3]
    1707. 

  1707.         #import ast
    1708. 

  1708.         #df = ast.literal_eval(filter)
    1709. 

  1709.         #print(df['date'])
    1710. 

  1710.         df = filter
    1711. 

  1711.     if len(sys.argv) > 4:
    1712. 

  1712.         segment = sys.argv[4]
    1713. 

  1713. 

  1714.     global cnxn
    1715. 

  1715.     global cursor
    1716. 

  1716. 

  1717.     if env == "prod":
    1718. 

  1718.         cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=192.168.0.253;DATABASE=OB2011DB;UID=user1;PWD=1234')
    1719. 

  1719.         cursor = cnxn.cursor()
    1720. 

  1720.     else:
    1721. 

  1721.         cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=OB2011DB;UID=admin;PWD=1234')
    1722. 

  1722.         cursor = cnxn.cursor()
    1723. 

  1723.     #print("code is "+code)
    1724. 

  1724. 

  1725. 

  1726.     if code != "undefined"  and code != "":
    1727. 

  1727.         wb["Daily"].sheet_state = "hidden"
    1728. 

  1728.         createExcel(code, df)
    1729. 

  1729.         createChart(code, df)
    1730. 

  1730.         createXBarChart(code, df)
    1731. 

  1731.         #createCp(code, df)
    1732. 

  1732. 

  1733.     else:
    1734. 

  1734.         wb["Data Measurement"].sheet_state = "hidden"
    1735. 

  1735.         wb["Chart"].sheet_state = "hidden"
    1736. 

  1736.         createExcelDaily(code, df, segment);
    1737. 

  1737.     #createXRangeChart(code, df)
    1738. 

  1738. 

  1739. 

  1740.     '''
    1741. 

  1741.     thin_border = Border(left=Side(style='thick'),
    1742. 

  1742.                      right=Side(style='thick'),
    1743. 

  1743.                      top=Side(style='thick'),
    1744. 

  1744.                      bottom=Side(style='thick'))
    1745. 

  1745.     wtd['C1'].value = 1234
    1746. 

  1746.     wtd["C1"].border = thin_border
    1747. 

  1747.     wtd['D1'].value = "Hello"
    1748. 

  1748.     '''
    1749. 

  1749. 

  1750. 

  1751.     #print wb.get_sheet_names()
    1752. 

  1752.     #print wb0.get_sheet_names()
    1753. 

  1753. 

  1754.     ut = int(time.time())
    1755. 

  1755.     if code != "undefined":
    1756. 

  1756.         filename = "measurement{0}_{1}.xlsx".format(code.replace("-", ""), ut)
    1757. 

  1757.     else:
    1758. 

  1758.         filename = "measurement_{1}.xlsx".format(code.replace("-", ""), ut)
    1759. 

  1759.     outfile = './public/excel/'+filename
    1760. 

  1760.     wb.save(filename = outfile)
    1761. 

  1761.     wb.close()
    1762. 

  1762.     print(filename)
    1763. 

  1763.