<!--/**********************************************************************/ /*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)