1
1
1
0
CASE
WHEN "Update Codes" IS NULL OR "Update Codes" = '' THEN 2
ELSE 1
END
0
0
1
0
0
tablayout
import QtQuick 2.0
Rectangle {
width: 350
height: 250
// Dynamically set color: yellow if 'Update Codes' is NULL or empty, lightgreen otherwise
color: expression.evaluate("if(\"Update Codes\" IS NULL OR \"Update Codes\" = '', 'yellow', 'lightgreen')")
border.color: "black"
border.width: 2
radius: 8 // Gives the rectangle nice rounded corners
Text {
textFormat: Text.RichText
wrapMode: Text.WordWrap // Ensures long addresses wrap to the next line
text: "<b>Domain:</b> " + expression.evaluate("\"Prov_name\"") + "<br>" +
"<b>Replicate:</b> " + expression.evaluate("lpad(\"Replicate_Number\",4,0)") + "<br>" +
"<b>PSU:</b> <u>" + expression.evaluate("lpad(\"PSU_Number\",4,0)") + " " + expression.evaluate("\"PSU_Name\"") + "</u><br>" +
"<b>BSN:</b> " + expression.evaluate("lpad(\"BSN\",4,0)") + "<br>" +
"<b>HUSN:</b> " + expression.evaluate("lpad(\"HUSN\",4,0)") + "<br>" +
"<b>HSN:</b> " + expression.evaluate("lpad(\"HSN\",4,0)") + "<br>" +
"<b>Household Head:</b> " + expression.evaluate("\"HH_Head\"") + "<br>" +
"<b>Address:</b> <i>" + expression.evaluate("\"Address\"") + "</i>"
font.pixelSize: 16
anchors.fill: parent
anchors.margins: 15
}
}
import QtQuick 2.0
import QtQuick.Controls 2.0
Rectangle {
width: 385
height: 50
TextInput {
id: myTextBox
anchors.fill: parent
text: expression.evaluate("CASE
WHEN \"Update Codes\" IN (3, 5) OR (\"Update Codes\" = 6 AND \"uc_6_ind\" = 1) THEN
CASE
WHEN maximum(to_int(\"n_hsn\"), \"PSU_number\") IS NULL
THEN 'Last 80k Series HSN used within the same PSU: No 80k series yet'
ELSE 'Last 80k Series HSN used within the same PSU: ' || maximum(\"n_hsn\", \"PSU_number\")
END
END")
enabled: false // Disable user interaction
wrapMode: Text.Wrap // Allow wrapping if text is long
font.pixelSize: 14 // Change font size (try 14, 16, 18 etc.)
}
}
import QtQuick 2.0
import QtQuick.Controls 2.0
Button {
width: 200
height: width/5
text: "Open in Maps"
onClicked: {
Qt.openUrlExternally(expression.evaluate("'geo:0,0?q=' || $y || ',' || $x"));
}
}
'\nPSU: '||PSU_Name||
'\nBSN: '||BSN||' HUSN:'||HUSN||' HSN: '||HSN||
'\nHH_Head:'||HH_Head||
'\nAddress: '||Address||'\n'||
CASE
WHEN "Update Codes" IS NULL THEN
'\nUpdate_Code: NULL'
ELSE
'\nUpdate_Code: ' || "Update Codes" || ' - ' ||
map(
0,'No Changes',
1,'Change of Household Head',
2,'Correction of Name and/or Address',
3,'Additional Household in the Housing Unit',
4,'Merged with Another Household in the Same Housing Unit',
5,'New Occupant in the Housing Unit',
6,'Household Permanently Move Out',
8,'No Longer Used as a Dwelling Unit',
9,'Not a Permanent Resident of the Housing Unit'
)[ "Update Codes" ]
END
0