HTML-Table für VIS oder Iqontrol (js und blockly)

[liv-in-sky]

@mrfloppy

ja paßt so

und ein default logo - wenn keine zuteilung gefunden wird

[mrfloppy]

@liv-in-sky

[liv-in-sky]

@mrfloppy

hast du noch avia und omv und turmöl?

[mrfloppy]

@liv-in-sky

[liv-in-sky]

@mrfloppy

kleiner zwischenstand:

die karte nimmt meinen standort (bayern) - daher ist die karte soweit gezogen - die farben der tabelle können eingestellt werden

telegram muss ich mal schauen, wann wieder zeit ist - evtl morgen

hoffe du nutzt die vis mit browser und nicht vis app - sonst funktioniert das widget nicht

[liv-in-sky]

@mrfloppy

zum testen - ist noch nicht fertig - aber evtl findest du schon fehler

für die widget muss das map- und inventwo widget-set installiert sein

das script wird zum ersten mal geschrieben, wenn die dp aktualisiert werden (also von der instanz abhängig - alle 0/20/40 min)

script

let anzahlAnzeige=7;
let mySprit="SUP"; //GAS, DIE

const config = getObject('system.config');
const mylat =  (config.common.latitude).replace(/(.*\..+?.+?.+?.+?.+?.+?).+/,"$1"); //*/"48.427656" //
const mylong = config.common.longitude.replace(/(.*\..+?.+?.+?.+?.+?.+?).+/,"$1");
const defaultPic="/vis.0/Tankstellen/default.png"
const pictures=[{"firma":"BP","pic":"/vis.0/Tankstellen/bp.png"},
               {"firma":"Genol","pic":"/vis.0/Tankstellen/genol.png"},
               {"firma":"eni","pic":"/vis.0/Tankstellen/bp.png"},
               {"firma":"Diskont","pic":"/vis.0/Tankstellen/diskont.png"},
               {"firma":"Turmöl","pic":"/vis.0/Tankstellen/turmoel.png"},
               {"firma":"paradies","pic":"/vis.0/Tankstellen/treibstoffparadies.png"},
               {"firma":"Lohberger","pic":"/vis.0/Tankstellen/lohberger.png"},
               {"firma":"SB-Tankstelle","pic":"/vis.0/Tankstellen/sb.jpg"},
               {"firma":"Hofer","pic":"/vis.0/Tankstellen/hofer.png"},
               {"firma":"AVIA","pic":"/vis.0/Tankstellen/avia.png"},
              ]

if(!existsState('0_userdata.0.FUELPRICEMONITOR.JsonAnzeige')) createState('0_userdata.0.FUELPRICEMONITOR.JsonAnzeige', "", { name: "JsonAnzeige", type:'string' }); 
if ( existsState("javascript." + instance + ".FUELPRICEMONITOR.Targets.home"))  setState("javascript." + instance + ".FUELPRICEMONITOR.Targets.home",mylat+','+mylong);
      else  createState("javascript." + instance + ".FUELPRICEMONITOR.Targets.home", mylat+','+mylong, {type: "string", name: "Koordinaten FPM HOME", role: "value", read: true, write: true, } ); 
on({id: "fuelpricemonitor.0.cheapestOverAll_"+mySprit+".0.amount", change: "any"}, async function (obj) {
 //var value = obj.state.val;
 //var oldValue = obj.oldState.val;
 //log(value);
let unserJsonArray=[];

$('fuelpricemonitor.*.cheapestOverAll_'+mySprit+'.*.address').each(function(id, i) {   
        let indexArr=id.split('.');
        let index=Number(indexArr[3]);
        let val0=getState(id).val; if(val0==null) val0="nicht angegeben"
        let val1=getState(id.replace("address","amount")).val;
        let val2=getState(id.replace("address","name")).val; if(val2==null) val2="nicht angegeben"
        let val3=getState(id.replace("address","id")).val;               
        let val4=searchLoc(val3);
    // hier noch die anderen dp


//jetzt das json schreiben
if(val1!=null && index<anzahlAnzeige){
unserJsonArray.push({ "Index":    index,
                     "Logo":     getPic(val2),
                     "Adresse":  val0,
                     "Preis":    val1,
                     "Name":     val2,
                     "ID":       val3,
                     "Koordinaten": val4  })


//if(existsState('0_userdata.0.FUELPRICEMONITOR.Targets.'+index+"er")) setState('0_userdata.0.FUELPRICEMONITOR.Targets.'+index+"er",val4.toString());
//        else createState('0_userdata.0.FUELPRICEMONITOR.Targets.'+index+"er", val4.toString(), {type: "string", name: "Koordinaten FPM "+ index, role: "value", read: true, write: true,  }); 

if ( existsState("javascript." + instance + ".FUELPRICEMONITOR.Targets."+index+"er"))  setState("javascript." + instance + ".FUELPRICEMONITOR.Targets."+index+"er",val4.toString());
      else  createState("javascript." + instance + ".FUELPRICEMONITOR.Targets."+index+"er", val4.toString(), {type: "string", name: "Koordinaten FPM "+ index, role: "value", read: true, write: true, } ); }



})

//log(JSON.stringify(unserJsonArray));

// in eigenen dp speichern - type zeichenkette
setState("0_userdata.0.FUELPRICEMONITOR.JsonAnzeige",JSON.stringify(unserJsonArray))
});

function searchLoc(theId){
let  ergebnis="";
$('fuelpricemonitor.0.*.*.location.latitude').each(function(id, i) {
   let indexArr=id.split('.');
   let indexId=indexArr[3];
   
  // log(theId +"  "+indexId )
   if(indexId==theId ){
                                                    //log(getState(id).val+","+getState(id.replace("latitude","longitude")).val)
                                                    ergebnis= (getState(id).val+","+getState(id.replace("latitude","longitude")).val).toString()
                                                    }
                                                    
})
//log (ergebnis)
return ergebnis;

}

function getPic(nameTanke){
let defaultTanke=defaultPic

for(let i=0;i<pictures.length;i++){//log(nameTanke+"   -  "+pictures[i].firma+"  -  "+nameTanke.indexOf(pictures[i].firma))
 // if(pictures[i].firma.includes(nameTanke)) {defaultTanke=pictures[i].pic }
  if(nameTanke.indexOf(pictures[i].firma)>-1) {defaultTanke=pictures[i].pic; break }
}
//log(defaultTanke)
return defaultTanke

}

widgets

Spoiler

[{"tpl":"i-vis-jsontable","data":{"g_fixed":false,"g_visibility":false,"g_css_font_text":true,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","iTblRowLimit":"20","iTableRefreshRate":"0","iTblSortOrder":"asc","iColCount":"6","iColShow1":false,"iTblHeadTextAlign1":"center","iTblTextAlign1":"center","iTblCellFormat1":"normal","iTblCellImageSize1":"200","iTblCellBooleanCheckbox1":"false","iTblCellBooleanColorFalse1":"#ff0000","iTblCellBooleanColorTrue1":"#00ff00","iTblCellNumberDecimals1":"2","iTblCellNumberDecimalSeperator1":".","iTblCellNumberThousandSeperator1":",","iTblCellThresholdsDp1":"","iTblCellThresholdsText1":"","iOpacityAll":"1","iTblRowEvenColor":"#479de6","iTblRowUnevenColor":"#8dadb9","iTblHeaderColor":"#204565","iRowSpacing":"3.8","iTblRowEvenTextColor":"#ffffff","iTblRowUnevenTextColor":"#ffffff","iTblHeaderTextColor":"#ffffff","iBorderSize":"0","iBorderStyleLeft":"none","iBorderStyleRight":"none","iBorderStyleUp":"none","iBorderStyleDown":"none","iBorderColor":"#ffffff","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"oid":"0_userdata.0.FUELPRICEMONITOR.JsonAnzeige","iTblShowHead":true,"iColShow2":"true","iTblHeadTextAlign2":"left","iTblTextAlign2":"left","iTblCellFormat2":"image","iTblCellImageSize2":"35","iTblCellBooleanCheckbox2":"false","iTblCellBooleanColorFalse2":"#ff0000","iTblCellBooleanColorTrue2":"#00ff00","iTblCellNumberDecimals2":"2","iTblCellNumberDecimalSeperator2":".","iTblCellNumberThousandSeperator2":",","iTblCellThresholdsDp2":"","iTblCellThresholdsText2":"","iColShow3":"true","iTblHeadTextAlign3":"center","iTblTextAlign3":"center","iTblCellFormat3":"normal","iTblCellImageSize3":"200","iTblCellBooleanCheckbox3":"false","iTblCellBooleanColorFalse3":"#ff0000","iTblCellBooleanColorTrue3":"#00ff00","iTblCellNumberDecimals3":"2","iTblCellNumberDecimalSeperator3":".","iTblCellNumberThousandSeperator3":",","iTblCellThresholdsDp3":"","iTblCellThresholdsText3":"","iColShow4":"true","iTblHeadTextAlign4":"left","iTblTextAlign4":"left","iTblCellFormat4":"normal","iTblCellImageSize4":"200","iTblCellBooleanCheckbox4":"false","iTblCellBooleanColorFalse4":"#ff0000","iTblCellBooleanColorTrue4":"#00ff00","iTblCellNumberDecimals4":"2","iTblCellNumberDecimalSeperator4":".","iTblCellNumberThousandSeperator4":",","iTblCellThresholdsDp4":"","iTblCellThresholdsText4":"","iColShow5":true,"iTblHeadTextAlign5":"center","iTblTextAlign5":"center","iTblCellFormat5":"normal","iTblCellImageSize5":"200","iTblCellBooleanCheckbox5":"false","iTblCellBooleanColorFalse5":"#ff0000","iTblCellBooleanColorTrue5":"#00ff00","iTblCellNumberDecimals5":"2","iTblCellNumberDecimalSeperator5":".","iTblCellNumberThousandSeperator5":",","iTblCellThresholdsDp5":"","iTblCellThresholdsText5":"","iColShow6":false,"iTblHeadTextAlign6":"center","iTblTextAlign6":"center","iTblCellFormat6":"normal","iTblCellImageSize6":"200","iTblCellBooleanCheckbox6":"false","iTblCellBooleanColorFalse6":"#ff0000","iTblCellBooleanColorTrue6":"#00ff00","iTblCellNumberDecimals6":"2","iTblCellNumberDecimalSeperator6":".","iTblCellNumberThousandSeperator6":",","iTblCellThresholdsDp6":"","iTblCellThresholdsText6":"","iColShow7":"true","iTblHeadTextAlign7":"center","iTblTextAlign7":"center","iTblCellFormat7":"normal","iTblCellImageSize7":"200","iTblCellBooleanCheckbox7":"false","iTblCellBooleanColorFalse7":"#ff0000","iTblCellBooleanColorTrue7":"#00ff00","iTblCellNumberDecimals7":"2","iTblCellNumberDecimalSeperator7":".","iTblCellNumberThousandSeperator7":",","iTblCellThresholdsDp7":"","iTblCellThresholdsText7":"","iColShow8":"true","iTblHeadTextAlign8":"center","iTblTextAlign8":"center","iTblCellFormat8":"normal","iTblCellImageSize8":"200","iTblCellBooleanCheckbox8":"false","iTblCellBooleanColorFalse8":"#ff0000","iTblCellBooleanColorTrue8":"#00ff00","iTblCellNumberDecimals8":"2","iTblCellNumberDecimalSeperator8":".","iTblCellNumberThousandSeperator8":",","iTblCellThresholdsDp8":"","iTblCellThresholdsText8":"","iColShow9":"true","iTblHeadTextAlign9":"center","iTblTextAlign9":"center","iTblCellFormat9":"normal","iTblCellImageSize9":"200","iTblCellBooleanCheckbox9":"false","iTblCellBooleanColorFalse9":"#ff0000","iTblCellBooleanColorTrue9":"#00ff00","iTblCellNumberDecimals9":"2","iTblCellNumberDecimalSeperator9":".","iTblCellNumberThousandSeperator9":",","iTblCellThresholdsDp9":"","iTblCellThresholdsText9":"","iTblFixedHead":true,"iTblSortAttr":"","iColName1":"","iColName2":"","iColWidth2":""},"style":{"left":"228px","top":"770px","width":"641px","height":"339px","font-size":"small","overflow-y":"scroll","z-index":"100"},"widgetSet":"vis-inventwo"},{"tpl":"tplOsm","data":{"g_fixed":false,"g_visibility":false,"g_css_font_text":false,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","mCount":"6","maxZoom":"0","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"hideControls":true,"markersSwap1":true,"markersLon-oid1":"javascript.0.FUELPRICEMONITOR.Targets.0er","markersLat-oid1":"","markersWidth1":"15","markersHeight1":"15","markersOffsetX1":"","markersOffsetY1":"","markersImage1":"/vis.0/armin/img/zahl/1-green.png","markersLon-oid2":"javascript.0.FUELPRICEMONITOR.Targets.1er","markersSwap2":true,"markersLon-oid3":"javascript.0.FUELPRICEMONITOR.Targets.2er","markersSwap3":true,"markersLon-oid4":"javascript.0.FUELPRICEMONITOR.Targets.3er","markersSwap4":true,"markersImage4":"/vis.0/armin/img/zahl/4-green.png","markersImage3":"/vis.0/armin/img/zahl/3-green.png","markersImage2":"/vis.0/armin/img/zahl/2-green.png","markersLon-oid6":"javascript.0.FUELPRICEMONITOR.Targets.home","markersSwap6":true,"markersImage6":"/vis.0/armin/img/haus2.png","g_markers_§4":false,"markersWidth2":"15","markersHeight2":"15","markersWidth3":"15","markersHeight3":"15","markersWidth4":"15","markersHeight4":"15","markersWidth6":"15","markersHeight6":"15"},"style":{"left":"907px","top":"856px","width":"380px","height":"273px"},"widgetSet":"map"}]

die bilder müssen unter /vis.0/Tankstellen/ gespeichert werden !! über den dateimanager und genau so heißen

bilder.7z

die bilder für die map kannst du selbst wählen im widget - ich kann dir auch gerne meine geben

[Negalein]

@liv-in-sky sagte in HTML-Table für VIS oder Iqontrol (js und blockly):

die karte nimmt meinen standort (bayern)

und die Tankstellen sind alles meine Nachbargemeinden!
Ich bin ca. mittig von denen!

[mrfloppy]

@liv-in-sky
thx mal werde ich später testen

[liv-in-sky]

@negalein dann weiß ich, wo ich dich suchen muss

[Chaot]

@liv-in-sky hast du eventuell noch Bilder für Aral, Ultsch und DEA

[liv-in-sky]

@chaot nee - habe ich nicht zusammengesucht - ich code nur

aber wenn jmd welche hat - bitte posten, damit ich die einbinden kann

[mrfloppy]

@liv-in-sky

[mrfloppy]

@liv-in-sky
Also die Liste haut mal hin. Sehr cool.
Aber das Map Widget funkt nicht bei mir.
Vis-map ist installiert. die Inventwo widgets auch.
Möglich weil im Json keine Koordinaten sind bei manchen Tankstellen?

[{"Index":0,"Logo":"/vis.0/Tankstellen/sefa.png","Adresse":"1210 WIEN, Donaufelder Strasse 128","Preis":1.528,"Name":"SE & FA Energy","ID":1474648,"Koordinaten":"null,null"},{"Index":1,"Logo":"/vis.0/Tankstellen/avanti.png","Adresse":"1210 WIEN, Wagramer Strasse 179","Preis":1.534,"Name":"avanti - Wien Wagramer Straße 179","ID":234,"Koordinaten":"48.25964,16.45031"},{"Index":2,"Logo":"/vis.0/Tankstellen/avanti.png","Adresse":"1210 WIEN, Julius Ficker Strasse 77","Preis":1.534,"Name":"avanti - Wien Julius Ficker Straße 77","ID":38026,"Koordinaten":"null,null"},{"Index":3,"Logo":"/vis.0/Tankstellen/jet.png","Adresse":"1210 WIEN, PRAGERSTRASSE 138","Preis":1.534,"Name":"JET TANKSTELLE","ID":1469406,"Koordinaten":"null,null"},{"Index":4,"Logo":"/vis.0/Tankstellen/diskont.png","Adresse":"1210 WIEN, Donaufelderstraße 137 (\"Hofer-Parkplatz\")","Preis":1.534,"Name":"Diskont Tankstelle","ID":1474472,"Koordinaten":"null,null"},{"Index":5,"Logo":"/vis.0/Tankstellen/turmoel.png","Adresse":"1210 WIEN, Pragerstraße 155","Preis":1.535,"Name":"Turmöl","ID":1473491,"Koordinaten":"48.27658,16.3881"},{"Index":6,"Logo":"/vis.0/Tankstellen/jet.png","Adresse":"1220 WIEN, RAUTENWEG 9","Preis":1.539,"Name":"JET TANKSTELLE","ID":1354660,"Koordinaten":"48.26365,16.4597"}]

Könntest du bitte deine Nummern Bilder anhängen.

[liv-in-sky]

@mrfloppy

evtl mußt du weitere 20 min warten und dann kommt die karte - sind den die dp unter javascript.0.FUELPRICEMONITOR.target gesetzt/gefüllt worden ?

wenn ja und dort null,null drinsteht, kopiere einfach von anderen koordinaten in den dp - ich werde morgen mal sehen, wie ich das verhindern kann - bisher hatte ich immer koordinaten

dienummern bildchen kann ich erst morgen liefern

[mrfloppy]

@liv-in-sky

sind tlw leer.
Hängt `vielleicht damit zusammen das ich mehr Tankstellenkoordinaten beim der Instanz definiert habe?
Keine Eile mit den Bildchen

[liv-in-sky]

@mrfloppy

Lösche das Bild raus - die Koordinaten sollte keiner wissen oder mache die letzten Koordinaten unleserlich

[liv-in-sky]

@mrfloppy

überprüfe bitte mal die orginal datenpunkte, ob die in den cheapest dp angegebenen id's auch koordinaten haben

wie hier im bild die id unter cheapest hat weiter oben dann einen id-ordner mit den koordinaten - hast du da was drinstehen ?

[liv-in-sky]

@mrfloppy

die zahlen

zahl.7z

[liv-in-sky]

@mrfloppy

wie sollen wir eigentlich zwei verschiedene kraftstoffe anzeigen ? wenn man DIe und SUP hat - zwei scripte definieren oder zwei tabellen erstellen oder alles in eine tabelle ?

[mrfloppy]

@liv-in-sky said in HTML-Table für VIS oder Iqontrol (js und blockly):

zwei scripte definieren oder zwei tabellen erstellen oder alles in eine

ich würde je ein eigenes Script für DIE und SUP machen.
Habe gestern kurz ins Script geschaut da müsste man halt einige Punkte darin ändern.

Ja aber nicht im 0_Home_.... sondern in einem der anderen Ordner