<!--/**********************************************************************/
/*Program Name: historization_UI_hadoop_poc.PHP */
/*Purpose: Display parameters in the drop down menu */
/*Author: Ravindra Jadhav (Ellicium) */
/*Date developed: 03rd November 2014 */
/*Change log: 04:00:00 PM */
/**********************************************************************/-->
<!-- Code for Getting Parameter Name from database using ID of Model Parameter & PID of DPName-->
<?php
mysql_connect("192.168.10.110", "root", "root");
mysql_select_db("superaxi");
$dpname0 = $_POST['pid'];
$from0 = "(";
$to0 = ")";
function getStringBetween0($dpname0, $from0, $to0)
{
$sub0 = substr($dpname0, strpos($dpname0, $from0) + strlen($from0), strlen($dpname0));
return substr($sub0, 0, strpos($sub0, $to0));
}
$pid = getStringBetween0($dpname0, $from0, $to0);
$id = $_POST['id'];
$sql = "SELECT * FROM(SELECT MODELPARAMETERID, NAME,PARAMETERTYPENAME, Concat('>',C_NAME,'->',P_NAME) as CHINSTANCELIST FROM(SELECT DISTINCT * FROM\n (SELECT PARAM.PARAMETERID ,MODELPARAMETER.MODELPARAMETERID, PARAM.NAME ,PARAM.PARAMETERTYPEID, PARAMETERTYPE.PARAMETERTYPENAME,\n\tPARAM.DESCRIPTION,PARAM.ANALOG_MEASUREMENTUNITID,PARAM.ISACTIVE,CHINSTANCE.NAME AS P_NAME,CHILDINSTANCE.NAME AS C_NAME\n\tFROM CHILDMANODEINSTANCE CHINSTANCE\n\tINNER JOIN CHILDMANODEINSTANCE CHILDINSTANCE ON CHINSTANCE.PARENTMANID = CHILDINSTANCE.REFMANID\n\tINNER JOIN MANPARAMETERLINEAGE LINEAGE ON CHINSTANCE.CHILDMANODEINSTANCEID=LINEAGE.CHILDMANODEINSTANCEID\n\tINNER JOIN MODELPARAMETER ON LINEAGE.MODELPARAMETERID=MODELPARAMETER.MODELPARAMETERID\n\tINNER JOIN PARAMETER PARAM ON PARAM.PARAMETERID=MODELPARAMETER.PARAMETERID\n\tINNER JOIN PARAMETERTYPE ON PARAMETERTYPE.PARAMETERTYPEID = PARAM.PARAMETERTYPEID\n\tINNER JOIN MODELASSEMBLYNODE MANODE ON CHINSTANCE.REFMANID=MANODE.MANID\n\tINNER JOIN MODELASSEMBLYNODETYPE MANTYPE ON MANTYPE.MANTYPEID=MANODE.MANTYPEID\n\tWHERE MODELPARAMETER.MANMODELID='" . $id . "'\n\tAND MODELPARAMETER.MODELPARAMETERID != '" . $pid . "'\n\tGROUP BY PARAM.PARAMETERID,MODELPARAMETER.MODELPARAMETERID\n\tORDER BY MANTYPE.LEVELHIERARCHY ASC)X \n\tGROUP BY PARAMETERID,MODELPARAMETERID)Y \n\tGROUP BY PARAMETERID,MODELPARAMETERID)Z ORDER BY NAME";
$sql_result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($sql_result)) {
echo "<option title='" . $row["CHINSTANCELIST"] . "' value='" . $row["MODELPARAMETERID"] . '~ ' . $row["NAME"] . '!' . "'>" . $row["MODELPARAMETERID"] . ' ~ ' . $row["NAME"] . "</option>";
}
exit;
?>
die('Could not connect: ' . mysql_error());
}
$modelid = $_POST['select0'];
$ST = $_POST['starttime'];
$frequency = $_POST['freq'];
$dpname = $modelid;
/* Code for separating ID from DPNAME */
$dpname0 = $dpname;
$from0 = "(";
$to0 = ")";
function getStringBetween0($dpname0, $from0, $to0)
{
$sub0 = substr($dpname0, strpos($dpname0, $from0) + strlen($from0), strlen($dpname0));
return substr($sub0, 0, strpos($sub0, $to0));
}
$MODELPARAMETERID = getStringBetween0($dpname0, $from0, $to0);
/* Code for separating NAME from DPNAME*/
$dpname2 = $dpname;
$from2 = "[";
$to2 = "]";
function getStringBetween1($dpname2, $from2, $to2)
{
$sub2 = substr($dpname2, strpos($dpname2, $from2) + strlen($from2), strlen($dpname2));
return substr($sub2, 0, strpos($sub2, $to2));
}
$NAME2 = getStringBetween1($dpname2, $from2, $to2);
/* Code for separating MPID from Expression Viewer */
$str = $_POST['txt'];
$from = "~";
$to = "!";
function getStringBetween($str, $from, $to)
