/*
 * Device Data Item Display
 *
 *  Licensed Virtual the Apache License, Version 2.0 (the "License"); you may not use this file except
 *  in compliance with the License. You may obtain a copy of the License at:
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software distributed under the License is distributed
 *  on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License
 *  for the specific language governing permissions and limitations under the License.
 *
 *  Change History:
 *
 *    Date        Who           What
 *    ----        ---           ----
 *    03Mar2022   thebearmay    JSON/CSV download
 *    11Mar2022   thebearmay    Add State Data option
 *                              Hub WriteFile option for JSON
 *    12Mar2022   thebearmay    Make ID the key for JSON
 *    01Apr2022   thebearmay    add optional tile device
 *    05Apr2022   thebearmay    split html > 1024
 *    06Apr2022   thebearmay    allow multiple instances via rename
 *    20Jun2022   thebearmay    embedded section correction
 *    10Jul2022   jtp10181      CSV changes
*/

import java.text.SimpleDateFormat
import java.net.URLEncoder
static String version()	{  return '1.3.4'  }


definition (
	name: 			"Device Data Item Display", 
	namespace: 		"thebearmay", 
	author: 		"Jean P. May, Jr.",
	description: 	"Display selected items out of the device data area for one or more devices.",
	category: 		"Utility",
	importUrl: "https://raw.githubusercontent.com/thebearmay/hubitat/main/apps/devDataDisp.groovy",
	oauth: 			false,
    iconUrl:        "",
    iconX2Url:      ""
) 

preferences {
   page name: "mainPage"
   page name: "deviceData"
   page name: "jsonDown"
   page name: "csvDown"

}

def installed() {
//	log.trace "installed()"
    state?.isInstalled = true
    initialize()
}

def updated(){
//	log.trace "updated()"
    if(!state?.isInstalled) { state?.isInstalled = true }
	if(debugEnable) runIn(1800,logsOff)
}

def initialize(){
}

void logsOff(){
     app.updateSetting("debugEnable",[value:"false",type:"bool"])
}

def mainPage(){
    dynamicPage (name: "mainPage", title: "", install: true, uninstall: true) {
      	if (app.getInstallationState() == 'COMPLETE') {   
//	    	section("Main")
//		    {
              section("Selection Criteria", hideable: true, hidden: true){
                input "qryDevice", "capability.*", title: "Devices of Interest:", multiple: true, required: true, submitOnChange: true
                if (qryDevice != null) {
                    dataList = buildDataList()
                    input "varList", "enum", title: "Select data items to display", options: dataList, multiple: true, required: false, submitOnChange: true
                    stateList = buildStateList()
                    input "stList", "enum", title: "Select states to display", options: stateList, multiple: true, required: false, submitOnChange: true
                }
              }
              section(""){
                  if(varList !=null || stateList!= null) {
                    href "deviceData", title: "Display Data", required: false
                    href "jsonDown", title: "Download JSON Data", required: false
                    href "csvDown", title: "Download CSV Data", required: false
                  }
              }
              section("Change Application Name", hideable: true, hidden: true){
               input "nameOverride", "text", title: "New Name for Application", multiple: false, required: false, submitOnChange: true, defaultValue: app.getLabel()
               if(nameOverride != app.getLabel) app.updateLabel(nameOverride)
              }   
//		    }
	    } else {
              section("Change Application Name", hideable: true, hidden: true){
               input "nameOverride", "text", title: "New Name for Application", multiple: false, required: false, submitOnChange: true, defaultValue: app.getLabel()
               if(nameOverride != app.getLabel) app.updateLabel(nameOverride)
              }   
		    section("") {
			    paragraph title: "Click Done", "Please click Done to install app before continuing"
		    }
	    }
    }
}

def buildDataList(){
    List dataList = []
    qryDevice.each {
        it.properties.data.each {
            dataList.add(it.key)
        }
    }
    dataList = dataList.sort().unique()
    return dataList
}

def buildStateList() {
    List stateList = []
    qryDevice.each {
        it.properties.currentStates.each {
            stateList.add(it.name)
        }
    }
    stateList = stateList.sort().unique()
    return stateList    
    
}

def deviceData(){
    dynamicPage (name: "deviceData", title: "", install: false, uninstall: false) {
	  section("Device Data"){
          qryDevice.sort({m1, m2 -> m1.displayName <=> m2.displayName})
          qryDevice.each{ x->
              paragraph "<span style='font-weight:bold;text-decoration:underline'>$x.displayName</span> ($x.name)"
              varOut = ""
              varList.each {
                  if(x.properties.data["$it"]) varOut+= "$it: ${x.properties.data["$it"]}<br>"
              }
              stList.each { s->
                 x.properties.currentStates.each {
                    if(it.name == s) varOut+= "$s: ${it.value}<br>"
                 }
              }
              paragraph varOut
            }
            input "createChild", "bool", title: "Create a child device for dashboard use", required: false, submitOnChange: true
            if (createChild) {
                if(getChildDevice("ddd${app.id}-01"))
                     return
                childDev = createChildDev()
                refreshDevice()
                subscribe(qryDevice, "refreshDevice", [filterEvents:true])
            } else if(getChildDevice("ddd${app.id}-01")){
                unsubscribe()
                deleteChildDevice("ddd${app.id}-01")
            }          
       }
    }
}

def refreshDevice(evt=null){
	inx = 0
	html = []
    qryDevice.sort({m1, m2 -> m1.displayName <=> m2.displayName})
    html[inx] = "<div id='devDataDisp'>"
    qryDevice.each{ x->
        varOut= "<p style='font-weight:bold;text-decoration:underline'>$x.displayName</p>"
        varList.each {
            if(x.properties.data["$it"]) varOut+= "<p>$it: ${x.properties.data["$it"]}</p>"
        }
        stList.each { s->
            x.properties.currentStates.each {
                if(it.name == s) varOut+= "<p>$s: ${it.value}</p>"
            }
        }
		if(varOut.length() + html[inx].length() + 6 > 1024){
			html[inx]+="</div>"
			inx++
			html[inx] = "<div id='devDataDisp'>"
		}
		html[inx]+=varOut
    }
    html[inx]+="</div>"
	
	chd = getChildDevice("ddd${app.id}-01")
	chd.sendEvent(name:"html",value:html[0].toString())
    if(debugEnabled) log.debug "inx = $inx"
	if(inx > 0) {
		for (int i = 1;i <= inx; i++){
            if(debugEnabled) log.debug "i=$i"
            chd.sendEvent(name:"html${i+1}",value:html[i].toString())
		}
	}
		
}

def createChildDev(){
    if(getChildDevice("ddd${app.id}-01"))
        return
    cd = addChildDevice("thebearmay", "Generic HTML Device", "ddd${app.id}-01", [name:"${app.label} Tile Device"])
    return cd
}

def jsonDown(){
    dynamicPage (name: "jsonDown", title: "", install: false, uninstall: false) {
	  section("<b><u>JSON Data</u></b>"){
        jData = "["
        qryDevice.sort({m1, m2 -> m1.displayName <=> m2.displayName})
        qryDevice.each{ x->
 //           jData += "{\"$x.displayName\": {"
            jData +=  "{\"$x.id\": {\"displayName\": \"$x.displayName\","
            varList.each {
                if(x.properties.data["$it"]) 
                    jData += "\"$it\": \"${x.properties.data["$it"]}\","
            }
            stList.each { s->
                x.properties.currentStates.each {
                    if(it.name == s) 
                    jData += "\"$s\": \"$it.value\","
                }
             }
            jData = jData.substring(0,jData.length()-1)
            jData += "}},"
      }
          jData = jData.substring(0,jData.length()-1)
          jData += "]"
          oData = "<script type='text/javascript'>function download() {var a = document.body.appendChild( document.createElement('a') );a.download = 'deviceData.json';a.href = 'data:text/json,' + encodeURIComponent(document.getElementById('jData').innerHTML);a.click();}</script>"
          oData +="<button onclick='download()'>Download JSON</button><hr /><div id='jData'>$jData</div><hr />"
          paragraph oData  
          input "lFileName", "string", title:"Hub File Name (optional)", submitOnChange: true
          if(lFileName != null) {
              atomicState.jData = jData
              input "wFile", "button", title:"Write to Hub File", submitOnChange:true
          }
      }        
        section("Hub Security", hideable: true, hidden: true){
            input "username", "string", title:"Hub User ID", submitOnChange: true
            input "password", "string", title:"Hub Password", submitOnChange: true
        }

  }
}

def csvDown(){
    dynamicPage (name: "csvDown", title: "", install: false, uninstall: false) {
      section("CSV Data"){
        jData="\"id\",\"displayName\",\"name\""
        varList.each { jData += ",\"$it\"" }
        stList.each { jData += ",\"$it\"" }
        jData += "\n"  

        qryDevice.sort({m1, m2 -> m1.displayName <=> m2.displayName})
        qryDevice.each{ x->
            jData += "\"$x.id\",\"$x.displayName\",\"$x.name\""
            varList.each {
                jData += (x.properties.data["$it"] ? ",\"${x.properties.data["$it"]}\"" : ",")
            }
            stList.each { s->
                x.properties.currentStates.each {
                    jData += (it.name == s ? ",\"$it.value\"" : ",")
                }
            }
            jData += "\n"
      }
      oData = "<script type='text/javascript'>function download() {var a = document.body.appendChild( document.createElement('a') );a.download = 'deviceData.csv';a.href = 'data:text/plain,' + encodeURIComponent(document.getElementById('jData').innerHTML);a.click();}</script>"
      oData +="<button onclick='download()'>Download CSV</button><hr /><div id='jData'>$jData</div><hr />"
      paragraph oData    
    }
  }
}

def appButtonHandler(btn) {
    switch(btn) {
        case "wFile":
            writeFile("$lFileName", "${atomicState.jData}")
            break
        default: 
            log.error "Undefined button $btn pushed"
            break
      }
}

def intialize() {

}

void uninstalled(){
    if(getChildDevice("ddd${app.id}-01")){
        unsubscribe()
        deleteChildDevice("ddd${app.id}-01")
    }          
}

HashMap securityLogin(){
    def result = false
    try{
        httpPost(
				[
					uri: "http://127.0.0.1:8080",
					path: "/login",
					query: 
					[
						loginRedirect: "/"
					],
					body:
					[
						username: username,
						password: password,
						submit: "Login"
					],
					textParser: true,
					ignoreSSLIssues: true
				]
		)
		{ resp ->
//			log.debug resp.data?.text
				if (resp.data?.text?.contains("The login information you supplied was incorrect."))
					result = false
				else {
					cookie = resp?.headers?.'Set-Cookie'?.split(';')?.getAt(0)
					result = true
		    	}
		}
    }catch (e){
			log.error "Error logging in: ${e}"
			result = false
            cookie = null
    }
	return [result: result, cookie: cookie]
}

Boolean writeFile(String fName, String fData) {
    now = new Date()
    String encodedString = "thebearmay$now".bytes.encodeBase64().toString();    
    
try {
		def params = [
			uri: 'http://127.0.0.1:8080',
			path: '/hub/fileManager/upload',
			query: [
				'folder': '/'
			],
			headers: [
				'Content-Type': "multipart/form-data; boundary=$encodedString"
			],
            body: """--${encodedString}
Content-Disposition: form-data; name="uploadFile"; filename="${fName}"
Content-Type: text/plain

${fData}

--${encodedString}
Content-Disposition: form-data; name="folder"


--${encodedString}--""",
			timeout: 300,
			ignoreSSLIssues: true
		]
		httpPost(params) { resp ->
		}
		return true
	}
	catch (e) {
		log.error "Error writing file $fName: ${e}"
	}
	return false
}