| | |
|---|
| | | key: 'code', |
|---|
| | | type: 'code', |
|---|
| | | required: true, |
|---|
| | | value: "ar recs = args.querySQL(\n \" SELECT * FROM guangming_data.tc_hzl_v4\"\n + \" WHERE otime >={start_time}::timestamp + '-1 months' AND otime < {end_time}::timestamp + '1 days'\", {\n start_time : args.getArg(\"start_time\"),\n end_time : args.getArg(\"end_time\")\n});\n\nvar resultText = \"时间,水厂名，耗电量,出口流量\\n\";\nfor(var recIndex in recs)\n{\n var rec = recs[recIndex];\n resultText += rec[\"OTIME\"] + \",\" + rec[\"FACT_NAME\"] + \",\" + rec[\"VPOWER\"] + \",\" + rec[\"VFLOW\"] + \"\\n\";\n}\nargs.setArg(\"RECORD_LIST\", resultText);\n\nargs.sendTableToClent({\n title : \"流量\",\n columns : [\n {\"title\":\"时间\", \"name\":\"OTIME\"},\n {\"title\":\"水厂\", \"name\":\"FACT_NAME\"},\n {\"title\":\"流量\", \"name\":\"VFLOW\"}\n ],\n\n recs : recs\n});\n\nargs.sendChartToClient({\n title : \"电量\",\n col_time : \"OTIME\",\n col_name : \"FACT_NAME\",\n col_value: \"VPOWER\",\n recs : recs\n});\nargs.sendKnowledgeToClient({\n result : args.getArg(\"num1\") + \" + \" + args.getArg(\"num2\") + \"=\" + args.getArg(\"V\")\n});", |
|---|
| | | value: "var recs = args.querySQL(\n \" SELECT * FROM guangming_data.tc_hzl_v4\"\n + \" WHERE otime >={start_time}::timestamp + '-1 months' AND otime < {end_time}::timestamp + '1 days'\", {\n start_time : args.getArg(\"start_time\"),\n end_time : args.getArg(\"end_time\")\n});\n\nvar resultText = \"时间,水厂名，耗电量,出口流量\\n\";\nfor(var recIndex in recs)\n{\n var rec = recs[recIndex];\n resultText += rec[\"OTIME\"] + \",\" + rec[\"FACT_NAME\"] + \",\" + rec[\"VPOWER\"] + \",\" + rec[\"VFLOW\"] + \"\\n\";\n}\nargs.setArg(\"RECORD_LIST\", resultText);\n\nargs.sendTableToClent({\n title : \"流量\",\n columns : [\n {\"title\":\"时间\", \"name\":\"OTIME\"},\n {\"title\":\"水厂\", \"name\":\"FACT_NAME\"},\n {\"title\":\"流量\", \"name\":\"VFLOW\"}\n ],\n\n recs : recs\n});\n\nargs.sendChartToClient({\n title : \"电量\",\n col_time : \"OTIME\",\n col_name : \"FACT_NAME\",\n col_value: \"VPOWER\",\n recs : recs\n});\nargs.sendKnowledgeToClient({\n result : args.getArg(\"num1\") + \" + \" + args.getArg(\"num2\") + \"=\" + args.getArg(\"V\")\n});", |
|---|
| | | language: ['text', 'javascript'], |
|---|
| | | defaultLanguage: 'javascript', |
|---|
| | | }, |
|---|
