8bf first comm 2 vuotta sitten css-sel3.js 77628cf8bf first comm 2 vuotta sitten css-selection.js 77628cf8bf first comm 2 vuotta sitten css-shapes.js 77628cf8bf first comm 2 vuotta sitten css-snappoints.js 77628cf8bf first comm 2 vuotta sitten css-sticky.js 77628cf8bf first comm 2 vuotta sitten css-subgrid.js 77628cf8bf first comm 2 vuotta sitten css-supports-api.js 77628cf8bf first comm 2 vuotta sitten css-table.js 77628cf8bf first comm 2 vuotta sitten css-text-align-last.js 77628cf8bf first comm 2 vuotta sitten css-text-box-trim.js 77628cf8bf first comm 2 vuotta sitten css-text-indent.js 77628cf8bf first comm 2 vuotta sitten css-text-justify.js 77628cf8bf first comm 2 vuotta sitten css-text-orientation.js 77628cf8bf first comm 2 vuotta sitten css-text-spacing.js 77628cf8bf first comm 2 vuotta sitten css-textshadow.js 77628cf8bf first comm 2 vuotta sitten css-touch-action.js 77628cf8bf first comm 2 vuotta sitten css-transitions.js 77628cf8bf first comm 2 vuotta sitten css-unicode-bidi.js 77628cf8bf first comm 2 vuotta sitten css-unset-value.js 77628cf8bf first comm 2 vuotta sitten css-variables.js 77628cf8bf first comm 2 vuotta sitten css-when-else.js 77628cf8bf first comm 2 vuotta sitten css-widows-orphans.js 77628cf8bf first comm 2 vuotta sitten css-width-stretch.js 77628cf8bf first comm 2 vuotta sitten css-writing-mode.js 77628cf8bf first comm 2 vuotta sitten css-zoom.js 77628cf8bf first comm 2 vuotta sitten css3-attr.js 77628cf8bf first comm 2 vuotta sitten css3-boxsizing.js 77628cf8bf first comm 2 vuotta sitten css3-colors.js 77628cf8bf first comm 2 vuotta sitten css3-cursors-grab.js 77628cf8bf first comm 2 vuotta sitten css3-cursors-newer.js 77628cf8bf first comm 2 vuotta sitten css3-cursors.js 77628cf8bf first comm 2 vuotta sitten css3-tabsize.js 77628cf8bf first comm 2 vuotta sitten currentcolor.js 77628cf8bf first comm 2 vuotta sitten custom-elements.js 77628cf8bf first comm 2 vuotta sitten custom-elementsv1.js 77628cf8bf first comm 2 vuotta sitten customevent.js 77628cf8bf first comm 2 vuotta sitten datalist.js 77628cf8bf first comm 2 vuotta sitten dataset.js 77628cf8bf first comm 2 vuotta sitten datauri.js 77628cf8bf first comm 2 vuotta sitten date-tolocaledatestring.js 77628cf8bf first comm 2 vuotta sitten declarative-shadow-dom.js 77628cf8bf first comm 2 vuotta sitten decorators.js 77628cf8bf first comm 2 vuotta sitten details.js 77628cf8bf first comm 2 vuotta sitten deviceorientation.js 77628cf8bf first comm 2 vuotta sitten devicepixelratio.js 77628cf8bf first comm 2 vuotta sitten dialog.js 77628cf8bf first comm 2 vuotta sitten dispatchevent.js 77628cf8bf first comm 2 vuotta sitten dnssec.js 77628cf8bf first comm 2 vuotta sitten do-not-track.js 77628cf8bf first comm 2 vuotta sitten document-currentscript.js 77628cf8bf first comm 2 vuotta sitten document-evaluate-xpath.js 77628cf8bf first comm 2 vuotta sitten document-execcommand.js 77628cf8bf first comm 2 vuotta sitten document-policy.js 77628cf8bf first comm 2 vuotta sitten document-scrollingelement.js 77628cf8bf first comm 2 vuotta sitten documenthead.js 77628cf8bf first comm 2 vuotta sitten dom-manip-convenience.js 77628cf8bf first comm 2 vuotta sitten dom-range.js 77628cf8bf first comm 2 vuotta sitten domcontentloaded.js 77628cf8bf first comm 2 vuotta sitten dommatrix.js 77628cf8bf first comm 2 vuotta sitten download.js 77628cf8bf first comm 2 vuotta sitten dragndrop.js 77628cf8bf first comm 2 vuotta sitten element-closest.js 77628cf8bf first comm 2 vuotta sitten element-from-point.js 77628cf8bf first comm 2 vuotta sitten element-scroll-methods.js 77628cf8bf first comm 2 vuotta sitten eme.js 77628cf8bf first comm 2 vuotta sitten eot.js 77628cf8bf first comm 2 vuotta sitten es5.js 77628cf8bf first comm 2 vuotta sitten es6-class.js 77628cf8bf first comm 2 vuotta sitten es6-generators.js 77628cf8bf first comm 2 vuotta sitten es6-module-dynamic-import.js 77628cf8bf first comm 2 vuotta sitten es6-module.js 77628cf8bf first comm 2 vuotta sitten es6-number.js 77628cf8bf first comm 2 vuotta sitten es6-string-includes.js 77628cf8bf first comm 2 vuotta sitten es6.js 77628cf8bf first comm 2 vuotta sitten eventsource.js 77628cf8bf first comm 2 vuotta sitten extended-system-fonts.js 77628cf8bf first comm 2 vuotta sitten feature-policy.js 77628cf8bf first comm 2 vuotta sitten fetch.js 77628cf8bf first comm 2 vuotta sitten fieldset-disabled.js 77628cf8bf first comm 2 vuotta sitten fileapi.js 77628cf8bf first comm 2 vuotta sitten filereader.js 77628cf8bf first comm 2 vuotta sitten filereadersync.js 77628cf8bf first comm 2 vuotta sitten filesystem.js 77628cf8bf first comm 2 vuotta sitten flac.js 77628cf8bf first comm 2 vuotta sitten flexbox-gap.js 77628cf8bf first comm 2 vuotta sitten flexbox.js 77628cf8bf first comm 2 vuotta sitten flow-root.js 77628cf8bf first comm 2 vuotta sitten focusin-focusout-events.js 77628cf8bf first comm 2 vuotta sitten font-family-system-ui.js 77628cf8bf first comm 2 vuotta sitten font-feature.js 77628cf8bf first comm 2 vuotta sitten font-kerning.js 77628cf8bf first comm 2 vuotta sitten font-loading.js 77628cf8bf first comm 2 vuotta sitten font-size-adjust.js 77628cf8bf first comm 2 vuotta sitten font-smooth.js 77628cf8bf first comm 2 vuotta sitten font-unicode-range.js 77628cf8bf first comm 2 vuotta sitten font-variant-alternates.js 77628cf8bf first comm 2 vuotta sitten font-variant-numeric.js 77628cf8bf first comm 2 vuotta sitten fontface.js 77628cf8bf first comm 2 vuotta sitten form-attribute.js 77628cf8bf first comm 2 vuotta sitten form-submit-attributes.js 77628cf8bf first comm 2 vuotta sitten form-validation.js 77628cf8bf first comm 2 vuotta sitten forms.js 77628cf8bf first comm 2 vuotta sitten fullscreen.js 77628cf8bf first comm 2 vuotta sitten gamepad.js 77628cf8bf first comm 2 vuotta sitten geolocation.js 77628cf8bf first comm 2 vuotta sitten getboundingclientrect.js 77628cf8bf first comm 2 vuotta sitten getcomputedstyle.js 77628cf8bf first comm 2 vuotta sitten getelementsbyclassname.js 77628cf8bf first comm 2 vuotta sitten getrandomvalues.js 77628cf8bf first comm 2 vuotta sitten gyroscope.js 77628cf8bf first comm 2 vuotta sitten hardwareconcurrency.js 77628cf8bf first comm 2 vuotta sitten hashchange.js 77628cf8bf first comm 2 vuotta sitten heif.js 77628cf8bf first comm 2 vuotta sitten hevc.js 77628cf8bf first comm 2 vuotta sitten hidden.js 77628cf8bf first comm 2 vuotta sitten high-resolution-time.js 77628cf8bf first comm 2 vuotta sitten history.js 77628cf8bf first comm 2 vuotta sitten html-media-capture.js 77628cf8bf first comm 2 vuotta sitten html5semantic.js 77628cf8bf first comm 2 vuotta sitten http-live-streaming.js 77628cf8bf first comm 2 vuotta sitten http2.js 77628cf8bf first comm 2 vuotta sitten http3.js 77628cf8bf first comm 2 vuotta sitten iframe-sandbox.js 77628cf8bf first comm 2 vuotta sitten iframe-seamless.js 77628cf8bf first comm 2 vuotta sitten iframe-srcdoc.js 77628cf8bf first comm 2 vuotta sitten imagecapture.js 77628cf8bf first comm 2 vuotta sitten ime.js 77628cf8bf first comm 2 vuotta sitten img-naturalwidth-naturalheight.js 77628cf8bf first comm 2 vuotta sitten import-maps.js 77628cf8bf first comm 2 vuotta sitten imports.js 77628cf8bf first comm 2 vuotta sitten indeterminate-checkbox.js 77628cf8bf first comm 2 vuotta sitten indexeddb.js 77628cf8bf first comm 2 vuotta sitten indexeddb2.js 77628cf8bf first comm 2 vuotta sitten inline-block.js 77628cf8bf first comm 2 vuotta sitten innertext.js 77628cf8bf first comm 2 vuotta sitten input-autocomplete-onoff.js 77628cf8bf first comm 2 vuotta sitten input-color.js 77628cf8bf first comm 2 vuotta sitten input-datetime.js 77628cf8bf first comm 2 vuotta sitten input-email-tel-url.js 77628cf8bf first comm 2 vuotta sitten input-event.js 77628cf8bf first comm 2 vuotta sitten input-file-accept.js 77628cf8bf first comm 2 vuotta sitten input-file-directory.js 77628cf8bf first comm 2 vuotta sitten input-file-multiple.js 77628cf8bf first comm 2 vuotta sitten input-inputmode.js 77628cf8bf first comm 2 vuotta sitten input-minlength.js 77628cf8bf first comm 2 vuotta sitten input-number.js 77628cf8bf first comm 2 vuotta sitten input-pattern.js 77628cf8bf first comm 2 vuotta sitten input-placeholder.js 77628cf8bf first comm 2 vuotta sitten input-range.js 77628cf8bf first comm 2 vuotta sitten input-search.js 77628cf8bf first comm 2 vuotta sitten input-selection.js 77628cf8bf first comm 2 vuotta sitten insert-adjacent.js 77628cf8bf first comm 2 vuotta sitten insertadjacenthtml.js 77628cf8bf first comm 2 vuotta sitten internationalization.js 77628cf8bf first comm 2 vuotta sitten intersectionobserver-v2.js 77628cf8bf first comm 2 vuotta sitten intersectionobserver.js 77628cf8bf first comm 2 vuotta sitten intl-pluralrules.js 77628cf8bf first comm 2 vuotta sitten intrinsic-width.js 77628cf8bf first comm 2 vuotta sitten jpeg2000.js 77628cf8bf first comm 2 vuotta sitten jpegxl.js 77628cf8bf first comm 2 vuotta sitten jpegxr.js 77628cf8bf first comm 2 vuotta sitten js-regexp-lookbehind.js 77628cf8bf first comm 2 vuotta sitten json.js 77628cf8bf first comm 2 vuotta sitten justify-content-space-evenly.js 77628cf8bf first comm 2 vuotta sitten kerning-pairs-ligatures.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-charcode.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-code.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-getmodifierstate.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-key.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-location.js 77628cf8bf first comm 2 vuotta sitten keyboardevent-which.js 77628cf8bf first comm 2 vuotta sitten lazyload.js 77628cf8bf first comm 2 vuotta sitten let.js 77628cf8bf first comm 2 vuotta sitten link-icon-png.js 77628cf8bf first comm 2 vuotta sitten link-icon-svg.js 77628cf8bf first comm 2 vuotta sitten link-rel-dns-prefetch.js 77628cf8bf first comm 2 vuotta sitten link-rel-modulepreload.js 77628cf8bf first comm 2 vuotta sitten link-rel-preconnect.js 77628cf8bf first comm 2 vuotta sitten link-rel-prefetch.js 77628cf8bf first comm 2 vuotta sitten link-rel-preload.js 77628cf8bf first comm 2 vuotta sitten link-rel-prerender.js 77628cf8bf first comm 2 vuotta sitten loading-lazy-attr.js 77628cf8bf first comm 2 vuotta sitten localecompare.js 77628cf8bf first comm 2 vuotta sitten magnetometer.js 77628cf8bf first comm 2 vuotta sitten matchesselector.js 77628cf8bf first comm 2 vuotta sitten matchmedia.js 77628cf8bf first comm 2 vuotta sitten mathml.js 77628cf8bf first comm 2 vuotta sitten maxlength.js 77628cf8bf first comm 2 vuotta sitten mdn-css-unicode-bidi-isolate-override.js 77628cf8bf first comm 2 vuotta sitten mdn-css-unicode-bidi-isolate.js 77628cf8bf first comm 2 vuotta sitten mdn-css-unicode-bidi-plaintext.js 77628cf8bf first comm 2 vuotta sitten mdn-text-decoration-color.js 77628cf8bf first comm 2 vuotta sitten mdn-text-decoration-line.js 77628cf8bf first comm 2 vuotta sitten mdn-text-decoration-shorthand.js 77628cf8bf first comm 2 vuotta sitten mdn-text-decoration-style.js 77628cf8bf first comm 2 vuotta sitten media-fragments.js 77628cf8bf first comm 2 vuotta sitten mediacapture-fromelement.js 77628cf8bf first comm 2 vuotta sitten mediarecorder.js 77628cf8bf first comm 2 vuotta sitten mediasource.js 77628cf8bf first comm 2 vuotta sitten menu.js 77628cf8bf first comm 2 vuotta sitten meta-theme-color.js 77628cf8bf first comm 2 vuotta sitten meter.js 77628cf8bf first comm 2 vuotta sitten midi.js 77628cf8bf first comm 2 vuotta sitten minmaxwh.js 77628cf8bf first comm 2 vuotta sitten mp3.js 77628cf8bf first comm 2 vuotta sitten mpeg-dash.js 77628cf8bf first comm 2 vuotta sitten mpeg4.js 77628cf8bf first comm 2 vuotta sitten multibackgrounds.js 77628cf8bf first comm 2 vuotta sitten multicolumn.js 77628cf8bf first comm 2 vuotta sitten mutation-events.js 77628cf8bf first comm 2 vuotta sitten mutationobserver.js 77628cf8bf first comm 2 vuotta sitten namevalue-storage.js 77628cf8bf first comm 2 vuotta sitten native-filesystem-api.js 77628cf8bf first comm 2 vuotta sitten nav-timing.js 77628cf8bf first comm 2 vuotta sitten netinfo.js 77628cf8bf first comm 2 vuotta sitten notifications.js 77628cf8bf first comm 2 vuotta sitten object-entries.js 77628cf8bf first comm 2 vuotta sitten object-fit.js 77628cf8bf first comm 2 vuotta sitten object-observe.js 77628cf8bf first comm 2 vuotta sitten object-values.js 77628cf8bf first comm 2 vuotta sitten objectrtc.js 77628cf8bf first comm 2 vuotta sitten offline-apps.js 77628cf8bf first comm 2 vuotta sitten offscreencanvas.js 77628cf8bf first comm 2 vuotta sitten ogg-vorbis.js 77628cf8bf first comm 2 vuotta sitten ogv.js 77628cf8bf first comm 2 vuotta sitten ol-reversed.js 77628cf8bf first comm 2 vuotta sitten once-event-listener.js 77628cf8bf first comm 2 vuotta sitten online-status.js 77628cf8bf first comm 2 vuotta sitten opus.js 77628cf8bf first comm 2 vuotta sitten orientation-sensor.js 77628cf8bf first comm 2 vuotta sitten outline.js 77628cf8bf first comm 2 vuotta sitten pad-start-end.js 77628cf8bf first comm 2 vuotta sitten page-transition-events.js 77628cf8bf first comm 2 vuotta sitten pagevisibility.js 77628cf8bf first comm 2 vuotta sitten passive-event-listener.js 77628cf8bf first comm 2 vuotta sitten passwordrules.js 77628cf8bf first comm 2 vuotta sitten path2d.js 77628cf8bf first comm 2 vuotta sitten payment-request.js 77628cf8bf first comm 2 vuotta sitten pdf-viewer.js 77628cf8bf first comm 2 vuotta sitten permissions-api.js 77628cf8bf first comm 2 vuotta sitten permissions-policy.js 77628cf8bf first comm 2 vuotta sitten picture-in-picture.js 77628cf8bf first comm 2 vuotta sitten picture.js 77628cf8bf first comm 2 vuotta sitten ping.js 77628cf8bf first comm 2 vuotta sitten png-alpha.js 77628cf8bf first comm 2 vuotta sitten pointer-events.js 77628cf8bf first comm 2 vuotta sitten pointer.js 77628cf8bf first comm 2 vuotta sitten pointerlock.js 77628cf8bf first comm 2 vuotta sitten portals.js 77628cf8bf first comm 2 vuotta sitten prefers-color-scheme.js 77628cf8bf first comm 2 vuotta sitten prefers-reduced-motion.js 77628cf8bf first comm 2 vuotta sitten progress.js 77628cf8bf first comm 2 vuotta sitten promise-finally.js 77628cf8bf first comm 2 vuotta sitten promises.js 77628cf8bf first comm 2 vuotta sitten proximity.js 77628cf8bf first comm 2 vuotta sitten proxy.js 77628cf8bf first comm 2 vuotta sitten publickeypinning.js 77628cf8bf first comm 2 vuotta sitten push-api.js 77628cf8bf first comm 2 vuotta sitten queryselector.js 77628cf8bf first comm 2 vuotta sitten readonly-attr.js 77628cf8bf first comm 2 vuotta sitten referrer-policy.js 77628cf8bf first comm 2 vuotta sitten registerprotocolhandler.js 77628cf8bf first comm 2 vuotta sitten rel-noopener.js 77628cf8bf first comm 2 vuotta sitten rel-noreferrer.js 77628cf8bf first comm 2 vuotta sitten rellist.js 77628cf8bf first comm 2 vuotta sitten rem.js 77628cf8bf first comm 2 vuotta sitten requestanimationframe.js 77628cf8bf first comm 2 vuotta sitten requestidlecallback.js 77628cf8bf first comm 2 vuotta sitten resizeobserver.js 77628cf8bf first comm 2 vuotta sitten resource-timing.js 77628cf8bf first comm 2 vuotta sitten rest-parameters.js 77628cf8bf first comm 2 vuotta sitten rtcpeerconnection.js 77628cf8bf first comm 2 vuotta sitten ruby.js 77628cf8bf first comm 2 vuotta sitten run-in.js 77628cf8bf first comm 2 vuotta sitten same-site-cookie-attribute.js 77628cf8bf first comm 2 vuotta sitten screen-orientation.js 77628cf8bf first comm 2 vuotta sitten script-async.js 77628cf8bf first comm 2 vuotta sitten script-defer.js 77628cf8bf first comm 2 vuotta sitten scrollintoview.js 77628cf8bf first comm 2 vuotta sitten scrollintoviewifneeded.js 77628cf8bf first comm 2 vuotta sitten sdch.js 77628cf8bf first comm 2 vuotta sitten selection-api.js 77628cf8bf first comm 2 vuotta sitten server-timing.js 77628cf8bf first comm 2 vuotta sitten serviceworkers.js 77628cf8bf first comm 2 vuotta sitten setimmediate.js 77628cf8bf first comm 2 vuotta sitten shadowdom.js 77628cf8bf first comm 2 vuotta sitten shadowdomv1.js 77628cf8bf first comm 2 vuotta sitten sharedarraybuffer.js 77628cf8bf first comm 2 vuotta sitten sharedworkers.js 77628cf8bf first comm 2 vuotta sitten sni.js 77628cf8bf first comm 2 vuotta sitten spdy.js 77628cf8bf first comm 2 vuotta sitten speech-recognition.js 77628cf8bf first comm 2 vuotta sitten speech-synthesis.js 77628cf8bf first comm 2 vuotta sitten spellcheck-attribute.js 77628cf8bf first comm 2 vuotta sitten sql-storage.js 77628cf8bf first comm 2 vuotta sitten srcset.js 77628cf8bf first comm 2 vuotta sitten stream.js 77628cf8bf first comm 2 vuotta sitten streams.js 77628cf8bf first comm 2 vuotta sitten stricttransportsecurity.js 77628cf8bf first comm 2 vuotta sitten style-scoped.js 77628cf8bf first comm 2 vuotta sitten subresource-bundling.js 77628cf8bf first comm 2 vuotta sitten subresource-integrity.js 77628cf8bf first comm 2 vuotta sitten svg-css.js 77628cf8bf first comm 2 vuotta sitten svg-filters.js 77628cf8bf first comm 2 vuotta sitten svg-fonts.js 77628cf8bf first comm 2 vuotta sitten svg-fragment.js 77628cf8bf first comm 2 vuotta sitten svg-html.js 77628cf8bf first comm 2 vuotta sitten svg-html5.js 77628cf8bf first comm 2 vuotta sitten svg-img.js 77628cf8bf first comm 2 vuotta sitten svg-smil.js 77628cf8bf first comm 2 vuotta sitten svg.js 77628cf8bf first comm 2 vuotta sitten sxg.js 77628cf8bf first comm 2 vuotta sitten tabindex-attr.js 77628cf8bf first comm 2 vuotta sitten template-literals.js 77628cf8bf first comm 2 vuotta sitten template.js 77628cf8bf first comm 2 vuotta sitten temporal.js 77628cf8bf first comm 2 vuotta sitten testfeat.js 77628cf8bf first comm 2 vuotta sitten text-decoration.js 77628cf8bf first comm 2 vuotta sitten text-emphasis.js 77628cf8bf first comm 2 vuotta sitten text-overflow.js 77628cf8bf first comm 2 vuotta sitten text-size-adjust.js 77628cf8bf first comm 2 vuotta sitten text-stroke.js 77628cf8bf first comm 2 vuotta sitten textcontent.js 77628cf8bf first comm 2 vuotta sitten textencoder.js 77628cf8bf first comm 2 vuotta sitten tls1-1.js 77628cf8bf first comm 2 vuotta sitten tls1-2.js 77628cf8bf first comm 2 vuotta sitten tls1-3.js 77628cf8bf first comm 2 vuotta sitten touch.js 77628cf8bf first comm 2 vuotta sitten transforms2d.js 77628cf8bf first comm 2 vuotta sitten transforms3d.js 77628cf8bf first comm 2 vuotta sitten trusted-types.js 77628cf8bf first comm 2 vuotta sitten ttf.js 77628cf8bf first comm 2 vuotta sitten typedarrays.js 77628cf8bf first comm 2 vuotta sitten u2f.js 77628cf8bf first comm 2 vuotta sitten unhandledrejection.js 77628cf8bf first comm 2 vuotta sitten upgradeinsecurerequests.js 77628cf8bf first comm 2 vuotta sitten url-scroll-to-text-fragment.js 77628cf8bf first comm 2 vuotta sitten url.js 77628cf8bf first comm 2 vuotta sitten urlsearchparams.js 77628cf8bf first comm 2 vuotta sitten use-strict.js 77628cf8bf first comm 2 vuotta sitten user-select-none.js 77628cf8bf first comm 2 vuotta sitten user-timing.js 77628cf8bf first comm 2 vuotta sitten variable-fonts.js 77628cf8bf first comm 2 vuotta sitten vector-effect.js 77628cf8bf first comm 2 vuotta sitten vibration.js 77628cf8bf first comm 2 vuotta sitten video.js 77628cf8bf first comm 2 vuotta sitten videotracks.js 77628cf8bf first comm 2 vuotta sitten viewport-unit-variants.js 77628cf8bf first comm 2 vuotta sitten viewport-units.js 77628cf8bf first comm 2 vuotta sitten wai-aria.js 77628cf8bf first comm 2 vuotta sitten wake-lock.js 77628cf8bf first comm 2 vuotta sitten wasm.js 77628cf8bf first comm 2 vuotta sitten wav.js 77628cf8bf first comm 2 vuotta sitten wbr-element.js 77628cf8bf first comm 2 vuotta sitten web-animation.js 77628cf8bf first comm 2 vuotta sitten web-app-manifest.js 77628cf8bf first comm 2 vuotta sitten web-bluetooth.js 77628cf8bf first comm 2 vuotta sitten web-serial.js 77628cf8bf first comm 2 vuotta sitten web-share.js 77628cf8bf first comm 2 vuotta sitten webauthn.js 77628cf8bf first comm 2 vuotta sitten webcodecs.js 77628cf8bf first comm 2 vuotta sitten webgl.js 77628cf8bf first comm 2 vuotta sitten webgl2.js 77628cf8bf first comm 2 vuotta sitten webgpu.js 77628cf8bf first comm 2 vuotta sitten webhid.js 77628cf8bf first comm 2 vuotta sitten webkit-user-drag.js 77628cf8bf first comm 2 vuotta sitten webm.js 77628cf8bf first comm 2 vuotta sitten webnfc.js 77628cf8bf first comm 2 vuotta sitten webp.js 77628cf8bf first comm 2 vuotta sitten websockets.js 77628cf8bf first comm 2 vuotta sitten webtransport.js 77628cf8bf first comm 2 vuotta sitten webusb.js 77628cf8bf first comm 2 vuotta sitten webvr.js 77628cf8bf first comm 2 vuotta sitten webvtt.js 77628cf8bf first comm 2 vuotta sitten webworkers.js 77628cf8bf first comm 2 vuotta sitten webxr.js 77628cf8bf first comm 2 vuotta sitten will-change.js 77628cf8bf first comm 2 vuotta sitten woff.js 77628cf8bf first comm 2 vuotta sitten woff2.js 77628cf8bf first comm 2 vuotta sitten word-break.js 77628cf8bf first comm 2 vuotta sitten wordwrap.js 77628cf8bf first comm 2 vuotta sitten x-doc-messaging.js 77628cf8bf first comm 2 vuotta sitten x-frame-options.js 77628cf8bf first comm 2 vuotta sitten xhr2.js 77628cf8bf first comm 2 vuotta sitten xhtml.js 77628cf8bf first comm 2 vuotta sitten xhtmlsmil.js 77628cf8bf first comm 2 vuotta sitten xml-serializer.js 77628cf8bf first comm 2 vuotta sitten tum/coi - Gogs: Simplico Git Service
Startseite Erkunden Hilfe
Anmelden
tum
/
coi
Beobachten 1
Favorit hinzufügen 0
Fork 0
Code Issues 0 Pull-Requests 0 Commits 62 Releases 0 Wiki

Keine Beschreibung

Struktur: 1f83987555
Branches Tags
coi
/
app
/
report
/
dailyreport.py

dailyreport.py 17KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547 
  1. from openpyxl import load_workbook
    2. 

  2. import pyodbc
    3. 

  3. import time
    4. 

  4. import sys
    5. 

  5. from pprint import pprint
    6. 

  6. import datetime
    7. 

  7. from openpyxl.styles import NamedStyle, Font
    8. 

  8. from copy import deepcopy
    9. 

  9. from openpyxl.chart import LineChart, Reference, Series
    10. 

  10. from openpyxl.chart.text import RichText
    11. 

  11. from openpyxl.drawing.text import  RichTextProperties,Paragraph,ParagraphProperties, CharacterProperties
    12. 

  12. 

  13. # Specifying the ODBC driver, server name, database, etc. directly
    14. 

  14. #cnxn = None
    15. 

  15. #cursor = None
    16. 

  16. '''cursor.execute('select * from data_wb')
    17. 

  17. rows = cursor.fetchall()
    18. 

  18. for row in rows:
    19. 

  19.     print(row)'''
    20. 

  20. 

  21. wb = load_workbook(filename = './dctemplate2.xlsx')
    22. 

  22. #wb.save(filename = './createfrompy.xlsx');
    23. 

  23. def findCustomer(code):
    24. 

  24.     global cursor
    25. 

  25.     global env
    26. 

  26. 

  27.     tempResult = []
    28. 

  28.     views = []
    29. 

  29.     if env == "prod":
    30. 

  30.         views = ["bel_master_view", "e_master_view", "mg_master_view", "v_master_view"]
    31. 

  31.     else:
    32. 

  32.         views = ["bel_master_view_dev", "e_master_view_dev", "mg_master_view_dev", "v_master_view_dev"]
    33. 

  33. 

  34.     ts = []
    35. 

  35. 

  36.     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"
    37. 

  37.     where = "PRO1 = '{0}'".format(code)
    38. 

  38.     for v in views:
    39. 

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

  40.         ts.append(sqlQuery)
    41. 

  41.     merged = []
    42. 

  42.     for t in ts:
    43. 

  43.         merged += cursor.execute(t)
    44. 

  44.     return merged
    45. 

  45. 

  46. def findInMasterView(select, where):
    47. 

  47.     global cursor
    48. 

  48.     global env
    49. 

  49. 

  50.     tempResult = []
    51. 

  51.     views = []
    52. 

  52.     if env == "prod":
    53. 

  53.         views = ["bel_master_view", "e_master_view", "mg_master_view", "v_master_view"]
    54. 

  54.     else:
    55. 

  55.         views = ["bel_master_view_dev", "e_master_view_dev", "mg_master_view_dev", "v_master_view_dev"]
    56. 

  56. 

  57. 

  58. 

  59.     ts = []
    60. 

  60.     for v in views:
    61. 

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

  62.         ts.append(sqlQuery);
    63. 

  63. 

  64.     qj = ';'.join(ts)
    65. 

  65.     #print(qj)
    66. 

  66.     merged = []
    67. 

  67.     for t in ts:
    68. 

  68.         merged += cursor.execute(t)
    69. 

  69.     return merged
    70. 

  70. 

  71. def updateLength(lotno):
    72. 

  72.     global cursor
    73. 

  73.     global wb
    74. 

  74. 

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

  76.     #print(q);
    77. 

  77.     return cursor.execute(q)
    78. 

  78. 

  79. def updateUb(lotno):
    80. 

  80.     global cursor
    81. 

  81.     global wb
    82. 

  82. 

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

  84.     #print(q);
    85. 

  85.     return cursor.execute(q)
    86. 

  86. 

  87. def getMachineName(machineId):
    88. 

  88.     global cursor
    89. 

  89.     q = "select * from machines_wb where id = {0}".format(machineId)
    90. 

  90.     #print(q)
    91. 

  91.     cursor.execute(q)
    92. 

  92.     rs = cursor.fetchall()
    93. 

  93.     return rs[0].name
    94. 

  94. 

  95. def getMachineDetail(machineId):
    96. 

  96.     global cursor
    97. 

  97.     q = "select * from machines_wb where id = {0}".format(machineId)
    98. 

  98.     #print(q)
    99. 

  99.     cursor.execute(q)
    100. 

  100.     rs = cursor.fetchall()
    101. 

  101.     return rs[0]
    102. 

  102. 

  103. def createDayChart(chartTitle):
    104. 

  104.     global wb
    105. 

  105.     ws = wb['Chart']
    106. 

  106.     wsd = wb['Daily Check']
    107. 

  107.     c1 = LineChart()
    108. 

  108.     c1.legend.position = "t";
    109. 

  109.     c1.title = chartTitle
    110. 

  110.     c1.title.font = Font(underline=Font.UNDERLINE_SINGLE)
    111. 

  111.     c1.y_axis.title = "Std. Weight(g)"
    112. 

  112.     c1.y_axis.number_format = "#,##0.00"
    113. 

  113.     c1.x_axis.title  = "Date"
    114. 

  114.     c1.width = 30
    115. 

  115.     c1.height = 10
    116. 

  116. 

  117. 

  118.     #print(len(values))
    119. 

  119.     MINDATACOL = 2
    120. 

  120.     MAXDATACOL = 2 + 31
    121. 

  121.     lt = Reference(wsd, min_col=3, max_col=33, min_row=5, max_row=5)
    122. 

  122. 

  123.     std = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=6, max_row=6)
    124. 

  124.     data = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=10, max_row=10)
    125. 

  125. 

  126.     maxUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=15, max_row=15)
    127. 

  127.     minUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=21, max_row=21)
    128. 

  128.     avgUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=26, max_row=26)
    129. 

  129.     vsStd = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=32, max_row=32)
    130. 

  130.     vsStd2 = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=37, max_row=37)
    131. 

  131. 

  132. 

  133.     c1.add_data(data, from_rows=True, titles_from_data=True)
    134. 

  134.     c1.add_data(maxUB, from_rows=True, titles_from_data=True)
    135. 

  135.     c1.add_data(minUB, from_rows=True, titles_from_data=True)
    136. 

  136.     c1.add_data(avgUB, from_rows=True, titles_from_data=True)
    137. 

  137.     c1.add_data(vsStd, from_rows=True, titles_from_data=True)
    138. 

  138.     c1.add_data(vsStd2, from_rows=True, titles_from_data=True)
    139. 

  139.     c1.add_data(std, from_rows=True, titles_from_data=True)
    140. 

  140. 

  141.     s1 = c1.series[0]
    142. 

  142.     s1.marker.symbol = "triangle"
    143. 

  143.     s1.graphicalProperties.line.noFill = True
    144. 

  144. 

  145.     s1 = c1.series[1]
    146. 

  146.     s1.marker.symbol = "circle"
    147. 

  147.     s1.graphicalProperties.line.noFill = True
    148. 

  148. 

  149.     s1 = c1.series[2]
    150. 

  150.     s1.marker.symbol = "square"
    151. 

  151.     s1.graphicalProperties.line.noFill = True
    152. 

  152. 

  153.     s1 = c1.series[3]
    154. 

  154.     s1.marker.symbol = "auto"
    155. 

  155.     s1.graphicalProperties.line.noFill = True
    156. 

  156. 

  157.     s1 = c1.series[4]
    158. 

  158.     s1.marker.symbol = "diamond"
    159. 

  159.     s1.graphicalProperties.line.noFill = True
    160. 

  160. 

  161.     s1 = c1.series[5]
    162. 

  162.     s1.marker.symbol = "auto"
    163. 

  163.     s1.graphicalProperties.line.noFill = True
    164. 

  164. 

  165.     s1 = c1.series[6]
    166. 

  166.     #s1.marker.symbol = "diamond"
    167. 

  167.     #s1.graphicalProperties.line.noFill = True
    168. 

  168. 

  169.     c1.set_categories(lt)
    170. 

  170. 

  171.     '''c1.x_axis.txPr = RichText(bodyPr=RichTextProperties(anchor="ctr",anchorCtr="1",rot="-2700000",
    172. 

  172.                spcFirstLastPara="1",vertOverflow="ellipsis",wrap="square"),
    173. 

  173.             p=[Paragraph(pPr=ParagraphProperties(defRPr=CharacterProperties()), endParaRPr=CharacterProperties())])'''
    174. 

  174. 

  175.     ws.add_chart(c1, "b3")
    176. 

  176.     #pass
    177. 

  177. def createNightChart(chartTitle):
    178. 

  178.     global wb
    179. 

  179.     ws = wb['Chart']
    180. 

  180.     wsd = wb['Daily Check']
    181. 

  181.     c1 = LineChart()
    182. 

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

  183.     c1.title = chartTitle
    184. 

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

  185.     c1.y_axis.title = "Std. Weight(g)"
    186. 

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

  187.     c1.x_axis.title  = "Date"
    188. 

  188.     c1.width = 30
    189. 

  189.     c1.height = 10
    190. 

  190. 

  191. 

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

  193.     MINDATACOL = 2
    194. 

  194.     MAXDATACOL = 2 + 31
    195. 

  195.     lt = Reference(wsd, min_col=3, max_col=33, min_row=5, max_row=5)
    196. 

  196. 

  197.     std = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=6, max_row=6)
    198. 

  198.     #begin data
    199. 

  199.     data = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=51, max_row=51)
    200. 

  200. 

  201.     maxUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=56, max_row=56)
    202. 

  202.     minUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=62, max_row=62)
    203. 

  203.     avgUB = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=67, max_row=67)
    204. 

  204.     vsStd = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=73, max_row=73)
    205. 

  205.     vsStd2 = Reference(wsd, min_col=MINDATACOL, max_col=MAXDATACOL, min_row=78, max_row=78)
    206. 

  206. 

  207. 

  208.     c1.add_data(data, from_rows=True, titles_from_data=True)
    209. 

  209.     c1.add_data(maxUB, from_rows=True, titles_from_data=True)
    210. 

  210.     c1.add_data(minUB, from_rows=True, titles_from_data=True)
    211. 

  211.     c1.add_data(avgUB, from_rows=True, titles_from_data=True)
    212. 

  212.     c1.add_data(vsStd, from_rows=True, titles_from_data=True)
    213. 

  213.     c1.add_data(vsStd2, from_rows=True, titles_from_data=True)
    214. 

  214.     c1.add_data(std, from_rows=True, titles_from_data=True)
    215. 

  215. 

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

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

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

  219. 

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

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

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

  223. 

  224.     s1 = c1.series[2]
    225. 

  225.     s1.marker.symbol = "square"
    226. 

  226.     s1.graphicalProperties.line.noFill = True
    227. 

  227. 

  228.     s1 = c1.series[3]
    229. 

  229.     s1.marker.symbol = "auto"
    230. 

  230.     s1.graphicalProperties.line.noFill = True
    231. 

  231. 

  232.     s1 = c1.series[4]
    233. 

  233.     s1.marker.symbol = "diamond"
    234. 

  234.     s1.graphicalProperties.line.noFill = True
    235. 

  235. 

  236.     s1 = c1.series[5]
    237. 

  237.     s1.marker.symbol = "auto"
    238. 

  238.     s1.graphicalProperties.line.noFill = True
    239. 

  239. 

  240.     s1 = c1.series[6]
    241. 

  241.     #s1.marker.symbol = "diamond"
    242. 

  242.     #s1.graphicalProperties.line.noFill = True
    243. 

  243. 

  244.     c1.set_categories(lt)
    245. 

  245. 

  246.     '''c1.x_axis.txPr = RichText(bodyPr=RichTextProperties(anchor="ctr",anchorCtr="1",rot="-2700000",
    247. 

  247.                spcFirstLastPara="1",vertOverflow="ellipsis",wrap="square"),
    248. 

  248.             p=[Paragraph(pPr=ParagraphProperties(defRPr=CharacterProperties()), endParaRPr=CharacterProperties())])'''
    249. 

  249. 

  250.     ws.add_chart(c1, "b22")
    251. 

  251. 

  252. def createExcel(codeno, filters):
    253. 

  253.     global cursor
    254. 

  254.     global wb
    255. 

  255.     ws  = wb["Daily Check"]
    256. 

  256. 

  257. 

  258.     machineName = getMachineName(codeno)
    259. 

  259.     machineDetail = getMachineDetail(codeno)
    260. 

  260. 

  261.     ws["C2"].value = machineName
    262. 

  262.     ws["C3"].value = filters.replace("created_at between", "").replace("and", "to").replace("'", "")
    263. 

  263. 

  264.     ws["C43"].value = machineName
    265. 

  265.     ws["C44"].value = filters.replace("created_at between", "").replace("and", "to").replace("'", "")
    266. 

  266. 

  267.     ws["C4"].value = machineDetail.machineStd;
    268. 

  268. 

  269.     if filters is not None:
    270. 

  270.         q = "select * from daily_checks_wb where machine_id = '{0}' and  {1}".format(codeno, filters)
    271. 

  271.     else:
    272. 

  272.         q = "select * from daily_checks_wb where machine_id = '{0}'".format(codeno)
    273. 

  273. 

  274. 

  275.     #print(q)
    276. 

  276.     cursor.execute(q)
    277. 

  277.     rows = cursor.fetchall()
    278. 

  278.     #print(rows)
    279. 

  279.     a0740 = [];
    280. 

  280.     a1230 = []
    281. 

  281.     a1700 = []
    282. 

  282.     a0030 = []
    283. 

  283.     a1940 = []
    284. 

  284.     a0500 = []
    285. 

  285. 

  286.     for i in range(31):
    287. 

  287.         a0740.append([])
    288. 

  288.         a1230.append([])
    289. 

  289.         a1700.append([])
    290. 

  290.         a0030.append([])
    291. 

  291.         a1940.append([])
    292. 

  292.         a0500.append([])
    293. 

  293. 

  294. 

  295.     for r in rows:
    296. 

  296.         i = r.created_at.day
    297. 

  297.         if r.shift == "07.40":
    298. 

  298.             a0740[i-1].append(r)
    299. 

  299.         if r.shift == "12.30":
    300. 

  300.             a1230[i-1].append(r)
    301. 

  301.         if r.shift == "17.00":
    302. 

  302.             #a1700.append(r)
    303. 

  303.             a1700[i-1].append(r)
    304. 

  304.         if r.shift == "00.30":
    305. 

  305.             a0030[i-1].append(r)
    306. 

  306.         if r.shift == "19.40":
    307. 

  307.             a1940[i-1].append(r)
    308. 

  308.         if r.shift == "05.00":
    309. 

  309.             a0500[i-1].append(r)
    310. 

  310. 

  311. 

  312.     #print(a0740)
    313. 

  313.     for idx, val in enumerate(a0740):
    314. 

  314.         j = 7
    315. 

  315.         k = 12
    316. 

  316.         users = []
    317. 

  317.         #print(val)
    318. 

  318.         ok = 0
    319. 

  319.         ng = 0
    320. 

  320.         for v in val:
    321. 

  321.             #print(j , idx + )
    322. 

  322.             #print(v.judgment)
    323. 

  323.             if v.judgement == "OK":
    324. 

  324.                 ok += 1
    325. 

  325.                 if ok > 3:
    326. 

  326.                     continue
    327. 

  327.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    328. 

  328.                 j += 1
    329. 

  329.             if v.judgement == "NG":
    330. 

  330.                 ng += 1
    331. 

  331.                 if ng > 3:
    332. 

  332.                     continue
    333. 

  333.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    334. 

  334.                 k += 1
    335. 

  335. 

  336.             #print(v.empid)
    337. 

  337.             if v.empid not in users:
    338. 

  338.                 #print("insert in users")
    339. 

  339.                 users.append(v.empid)
    340. 

  340. 

  341.         #print(val)
    342. 

  342.         if len(val) > 0:
    343. 

  343.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    344. 

  344.             #print(q)
    345. 

  345.             cursor.execute(q)
    346. 

  346.             us = cursor.fetchall()
    347. 

  347.             names = [x.fname + " " + x.lname for x in us]
    348. 

  348.             ws.cell(row = 17, column = idx + 3, value = ",".join(names))
    349. 

  349. 

  350.     for idx, val in enumerate(a1230):
    351. 

  351.         j = 18
    352. 

  352.         k = 23
    353. 

  353.         users = []
    354. 

  354.         ok = ng = 0
    355. 

  355.         for v in val:
    356. 

  356.             #print(j , idx)
    357. 

  357.             if v.judgement == "OK":
    358. 

  358.                 ok += 1
    359. 

  359.                 if ok > 3:
    360. 

  360.                     continue
    361. 

  361.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    362. 

  362.                 j += 1
    363. 

  363.             if v.judgement == "NG":
    364. 

  364.                 ng += 1
    365. 

  365.                 if ng > 3:
    366. 

  366.                     continue
    367. 

  367. 

  368.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    369. 

  369.                 k += 1
    370. 

  370. 

  371.             if v.empid not in users:
    372. 

  372.                 users.append(v.empid)
    373. 

  373. 

  374.         if len(val) > 0:
    375. 

  375.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    376. 

  376.             #print(q)
    377. 

  377.             cursor.execute(q)
    378. 

  378.             us = cursor.fetchall()
    379. 

  379.             names = [x.fname + " " + x.lname for x in us]
    380. 

  380.             ws.cell(row = 28, column = idx + 3, value = ",".join(names))
    381. 

  381. 

  382.     for idx, val in enumerate(a1700):
    383. 

  383.         j = 29
    384. 

  384.         k = 34
    385. 

  385.         users = []
    386. 

  386.         ok = ng = 0
    387. 

  387. 

  388.         for v in val:
    389. 

  389.             #print(j , idx)
    390. 

  390.             if v.judgement == "OK":
    391. 

  391.                 ok += 1
    392. 

  392.                 if ok > 3:
    393. 

  393.                     continue
    394. 

  394. 

  395.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    396. 

  396.                 j += 1
    397. 

  397.             if v.judgement == "NG":
    398. 

  398.                 ng += 1
    399. 

  399.                 if ng > 3:
    400. 

  400.                     continue
    401. 

  401. 

  402.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    403. 

  403.                 k += 1
    404. 

  404.             if v.empid not in users:
    405. 

  405.                 users.append(v.empid)
    406. 

  406. 

  407.         if len(val) > 0:
    408. 

  408.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    409. 

  409.             #print(q)
    410. 

  410.             cursor.execute(q)
    411. 

  411.             us = cursor.fetchall()
    412. 

  412.             names = [x.fname + " " + x.lname for x in us]
    413. 

  413.             ws.cell(row = 39, column = idx + 3, value = ",".join(names))
    414. 

  414. 

  415.     for idx, val in enumerate(a1940):
    416. 

  416.         j = 47
    417. 

  417.         k = 53
    418. 

  418.         users = []
    419. 

  419.         ok = ng = 0
    420. 

  420.         for v in val:
    421. 

  421.             #print(j , idx)
    422. 

  422.             if v.judgement == "OK":
    423. 

  423.                 ok += 1
    424. 

  424.                 if ok > 3:
    425. 

  425.                     continue
    426. 

  426. 

  427.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    428. 

  428.                 j += 1
    429. 

  429.             if v.judgement == "NG":
    430. 

  430.                 ng += 1
    431. 

  431.                 if ng > 3:
    432. 

  432.                     continue
    433. 

  433. 

  434.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    435. 

  435.                 k += 1
    436. 

  436.             if v.empid not in users:
    437. 

  437.                 users.append(v.empid)
    438. 

  438. 

  439.         if len(val) > 0:
    440. 

  440.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    441. 

  441. 

  442.             #print(q)
    443. 

  443.             cursor.execute(q)
    444. 

  444.             us = cursor.fetchall()
    445. 

  445.             names = [x.fname + " " + x.lname for x in us]
    446. 

  446.             ws.cell(row = 58, column = idx + 3, value = ",".join(names))
    447. 

  447. 

  448.     for idx, val in enumerate(a0030):
    449. 

  449.         j = 59
    450. 

  450.         k = 64
    451. 

  451.         users = []
    452. 

  452.         ok = ng = 0
    453. 

  453.         for v in val:
    454. 

  454.             #print(j , idx)
    455. 

  455.             if v.judgement == "OK":
    456. 

  456.                 ok += 1
    457. 

  457.                 if ok > 3:
    458. 

  458.                     continue
    459. 

  459. 

  460.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    461. 

  461.                 j += 1
    462. 

  462.             if v.judgement == "NG":
    463. 

  463.                 ng += 1
    464. 

  464.                 if ng > 3:
    465. 

  465.                     continue
    466. 

  466. 

  467.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    468. 

  468.                 k += 1
    469. 

  469.             if v.empid not in users:
    470. 

  470.                 users.append(v.empid)
    471. 

  471. 

  472.         if len(val) > 0:
    473. 

  473.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    474. 

  474. 

  475.             #print(q)
    476. 

  476.             cursor.execute(q)
    477. 

  477.             us = cursor.fetchall()
    478. 

  478.             names = [x.fname + " " + x.lname for x in us]
    479. 

  479.             ws.cell(row = 69, column = idx + 3, value = ",".join(names))
    480. 

  480. 

  481.     for idx, val in enumerate(a0500):
    482. 

  482.         j = 70
    483. 

  483.         k = 75
    484. 

  484.         users = []
    485. 

  485.         ok = ng = 0
    486. 

  486.         for v in val:
    487. 

  487.             #print(j , idx)
    488. 

  488.             if v.judgement == "OK":
    489. 

  489.                 ok += 1
    490. 

  490.                 if ok > 3:
    491. 

  491.                     continue
    492. 

  492. 

  493.                 ws.cell(row = j , column = idx + 3 , value = v.weight)
    494. 

  494.                 j += 1
    495. 

  495.             if v.judgement == "NG":
    496. 

  496.                 ng += 1
    497. 

  497.                 if ng > 3:
    498. 

  498.                     continue
    499. 

  499.                 ws.cell(row = k , column = idx + 3 , value = v.weight)
    500. 

  500.                 k += 1
    501. 

  501.             if v.empid not in users:
    502. 

  502.                 users.append(v.empid)
    503. 

  503. 

  504.         if len(val) > 0:
    505. 

  505.             q = "select * from users where empid  in ({0})".format(",".join("'{0}'".format(w) for w in users))
    506. 

  506.             #print(q)
    507. 

  507.             cursor.execute(q)
    508. 

  508.             us = cursor.fetchall()
    509. 

  509.             names = [x.fname + " " + x.lname for x in us]
    510. 

  510.             ws.cell(row = 80, column = idx + 3, value = ",".join(names))
    511. 

  511. 

  512.     createDayChart("Daily Check of Day Shift ({0})".format(machineName))
    513. 

  513. 

  514.     createNightChart("Daily Check of Night Shift ({0})".format(machineName))
    515. 

  515. 

  516.     ut = int(time.time())
    517. 

  517.     filename = "dc{0}.xlsx".format(str(ut))
    518. 

  518.     outfile = './public/excel/'+filename
    519. 

  519.     wb.save(filename = outfile)
    520. 

  520.     print(filename)
    521. 

  521. 

  522. if __name__ == "__main__":
    523. 

  523.     env = sys.argv[1]
    524. 

  524.     machine = sys.argv[2]
    525. 

  525.     #print(len(sys.argv))
    526. 

  526. 

  527.     df = None
    528. 

  528.     if len(sys.argv) == 4:
    529. 

  529.         filter = sys.argv[3]
    530. 

  530.         #import ast
    531. 

  531.         #df = ast.literal_eval(filter)
    532. 

  532.         #print(df['date'])
    533. 

  533.         df = filter
    534. 

  534. 

  535.     global cnxn
    536. 

  536.     global cursor
    537. 

  537. 

  538.     if env == "prod":
    539. 

  539.         cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=192.168.0.253;DATABASE=OB2011DB;UID=user1;PWD=1234')
    540. 

  540.         cursor = cnxn.cursor()
    541. 

  541.     else:
    542. 

  542.         cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=OB2011DB;UID=admin;PWD=1234')
    543. 

  543.         cursor = cnxn.cursor()
    544. 

  544.     #print("code is "+code)
    545. 

  545. 

  546.     createExcel(machine, df)
    547. 

  547.