function buildElements($multiArray) { /* * Element Attributes * 0-Label str * 1-NodeID str * 2-Node Attributes str * 3-Node Type int * 4-Value List array * 5-Default Value str * 6-DivID * 7-Text */ foreach ($multiArray as $pArray => $arrayName) { echo '<div class="frmrow" >'; foreach ($arrayName as $element) { $divID = isset($element[6]) ? "id='" . $element[6] . "'" : null; $default = isset($element[5]) ? $element[5] : null; switch ($element[3]) { case 0: /*text*/ if ($default != null) { $value = "value=\"" . $default . "\""; } else { $value = ""; } echo "<div class=\"frmcol\"><label>" . $element[0] . "</label><input " . $element[2] . " type=\"text\" id=\"" . $element[1] . "\" name=\"" . $element[1] . "\"" . $value . "/></div>"; break; case 1: /*list*/ echo "<div class=\"frmcol\"><label>" . $element[0] . "</label><span {$divID} >" . selList($element[4], $element[1], null, $element[2], null, null, $default) . "</span></div>"; break; case 2: /*button*/ echo '<div class="frmcol"><div> </div><input id="' . $element[1] . '" type="button" ' . $element[2] . ' value="' . $default . '" /></div>'; break; case 3: /*hidden*/ echo "<div class=\"frmcol\"><label>" . $element[0] . "</label><input " . $element[2] . " type=\"hidden\" id=\"" . $element[1] . "\" name=\"" . $element[1] . "\"/></div>"; break; case 4: /*radio*/ echo "<div class=\"frmcol\"><label>" . $element[0] . "</label>"; foreach ($element[4] as $radList => $radValue) { $selected = $element[5] == $radValue[0] ? "checked=\"checked\"" : ""; echo '<input type="radio" ' . $selected . ' name="' . $element[1] . '" value="' . $radValue[0] . '"/>' . $radValue[1]; } echo "</div>"; break; case 5: /*image*/ echo '<div class="frmcol"><img id="' . $element[1] . '"' . $element[2] . ' src="' . $element[0] . '"/></div>'; break; case 6: /*textarea*/ if ($default != null) { $value = hex2str($default); } else { $value = ""; } echo "<div class=\"frmcol\"><label>" . $element[0] . "</label><textarea " . $element[2] . " id=\"" . $element[1] . "\" name=\"" . $element[1] . "\">" . $value . "</textarea></div>"; break; case 7: /*password*/ if ($default != null) { $value = "value=\"" . $default . "\""; } else { $value = ""; } echo "<div class=\"frmcol\"><label>" . $element[0] . "</label><input " . $element[2] . " type=\"password\" id=\"" . $element[1] . "\" name=\"" . $element[1] . "\"" . $value . "/></div>"; break; case 8: /*checkbox*/ $element[7] = !isset($element[7]) ? '' : $element[7]; $selected = $element[5] == 1 ? "checked=\"checked\"" : ""; echo '<div ' . $divID . ' class="frmcol"><label>' . $element[0] . '</label><input type="checkbox" ' . $selected . ' name="' . $element[1] . '" value="1"/>' . $element[7] . '</div>'; break; } } echo '</div>'; } }
$requiredFields = "id_cust_department,srv_board"; ?> <form method="post" name="editBoard" action="javascript:submitFrmVals('content','/_mod/smod_09/insertSQL.php','<?php echo $requiredFields; ?> ','&id_srv_board=<?php echo $_POST["id_srv_board"]; ?> &edit=1','editBoard')"> <fieldset id="service_board_detail"> <legend>Service Board Detail</legend> <div class="frmrow"> <div class="frmcol"> <label>*Department</label> <?php echo selList($aDepartment, "id_cust_department", null, null, null, null, $aBoard[0][1]); ?> </div> <div class="frmcol"> <label>*Board Name</label> <input type="text" name="srv_board" id="srv_board" value="<?php echo $aBoard[0][2]; ?> "/> </div> </div> </fieldset> </form> <div class="cList"> <div id="list09-1" ><?php require "listServiceTickets.php";
$gdbo->getRec(); $sdList = $gdbo->dbData; foreach ($sdList as $key => $col) { $sch[$key] = $col[0]; $schLabel[$key] = $col[1]; $buttonAdd = '<div class="elementIconBox" onclick="arc(\'add\',\'' . $path . 'sqlResults.php\',\'table=\'+document.getElementById(\'schList\').options[document.getElementById(\'schList\').selectedIndex].value+\'&edit=1\',1,1)"><i class="fa fa-plus"></i></div>'; } array_multisort($schLabel, SORT_ASC, $sdList); ?> <script type="text/javascript">$(".icoadd").remove();</script> <fieldset> <legend>Manage System Tables</legend> <div class="frmrow"> <div class="frmcol-x"> <label>Tables</label> <?php echo selList($sdList, "schList", "arc('list12','" . $path . "sqlResults.php','table='+document.getElementById('schList').options[document.getElementById('schList').selectedIndex].value+'&edit=0',1,1);clearPop('add')", "style=\"width:300px !important\""); echo $buttonAdd; ?> </div> </div> <div id="add"></div> <div id="list12Nav"></div> <div id="list12"></div> <div id="status"></div> </fieldset> <script type="text/javascript"> $('#list12').css('width',($('fieldset').innerWidth()-20)+"px"); $('#list12').css('overflow','auto'); </script>
?> associated service records. What do you want to do to these records? </div> <div class="frmrow" style="margin-top:10px"> <div class="frmcol"> <input type="radio" name="srvConfirmation" value="1" onclick="delSrvBoardOption(1)"/>Remove </div> <div class="frmcol"> <input type="radio" name="srvConfirmation" value="2" onclick="delSrvBoardOption(2)"/>Do Nothing </div> <div class="frmcol"> <input type="radio" name="srvConfirmation" checked="checked" value="0" onclick="delSrvBoardOption(0)"/>Move </div> <div class="frmcol"> <?php echo selList($aSrvBoard, "id_srv_board_alt"); ?> </div> </div> <div id="delList" style="margin-top:10px"> <?php include $path . "dellist.php"; ?> </div> <?php } ?> <div class="frmrow"> <div class="flLeft"> <input type="button" onclick="clearPop()" value="Cancel"/> </div>
$e = str_replace("!squt!", "'", $e); $sql = "SELECT {$e} FROM {$d} WHERE {$k} {$l}"; if ($debug == 1) { echo $sql; } # test if MSSQL or MySQL if ($h == 0) { myRec($r, $con, $c, $sql); rec2arrayMY($array, $r); mysql_close($con); } else { msRec($r, $con, $c, $sql); rec2arrayMS($array, $r); mssql_close($con); } if ($m == "null") { $m = null; } else { $m = str_replace("x34", "\"", $m); } if (isset($a)) { $label = "<label>{$a}</label>"; } else { $label = ""; } if (count($array) > 0) { echo $label . selList($array, $f, $g, $m); printArray($a); } else { echo $label . "<select disabled=disabled id=\"{$f}\"><option>--</option></select>"; }
/* ********************************************************************** */ /* list.department */ /* ********************************************************************** */ $gdbo->sql = "SELECT id_cust_department,cust_department FROM _cust_department"; $gdbo->getRec(); $aDepartment = $gdbo->dbData; /* ********************************************************************** */ $requiredFields = "id_cust_department,srv_board"; ?> <script type="text/javascript">$(".icoadd").remove();</script> <form method="post" action="javascript:submitFrmVals('content','/_mod/smod_09/insertSQL.php','<?php echo $requiredFields; ?> ','&edit=0')"> <fieldset id="service_board_detail"> <legend>Service Board Detail</legend> <div class="frmrow"> <div class="frmcol"> <label>*Department</label> <?php echo selList($aDepartment, "id_cust_department"); ?> </div> <div class="frmcol"> <label>*Board Name</label> <input type="text" name="srv_board" id="srv_board"/> </div> </div> </fieldset> </form>
<div class="multimenu"> <input type="button" id="phonesAddButton" onclick="multiRowAddElement(this,'frmrow',null,null);hideMFControls(this,'cRemove');booCheck()" class="clAddButton" value="Add"> <input type="button" onclick="multiRowRemoveLastElement(this,'frmrow');" value="Remove Last"> </div> <div class="frmrow"> <div class="frmcol"> <label>Column</label> <?php echo selList($colFullArray, "x1_filtercol", "getSelFilter(this)", "class=\"mFilterCol\""); ?> </div> <div class="frmcol"> <label>Filter</label> <?php $placeholder = array(); echo selList($placeholder, "x1_filterby", "setFilterValue(this)", "disabled=\"disabled\" class=\"mFilterBy\""); ?> </div> <div class="frmcol"> <label>Value</label> <input type="text" id="x1_filterval" name="x1_filterval" class="mFilterVal" disabled="disabled"> </div> <div class="frmcol"> <label>Filter Group</label> <select name="x1_grpID" id="x1_grpID" class="mGrpBy"> <?php $i = 0; while ($i < 10) { echo "<option value='{$i}'>Group {$i}</option>"; $i++; }
} } $attributes = isset($dbo->attributes) ? $dbo->attributes : ""; $recID = isset($dbo->id) ? $dbo->id : ""; if (!empty($_POST["VAL"])) { $dbo->sql = $dbo->sql . " " . $dbo->dbFilter . hex2str($_POST["VAL"]); $dbo->getRec(); $results = $dbo->dbData; $count = $dbo->dbRows; $disabled = ""; } else { $results = array(); $disabled = 'disabled="disabled"'; } if ($count == 0) { $disabled = 'disabled="disabled"'; $first = null; $text = null; } else { $first = $results[0][0]; $text = $results[0][1]; } switch ($dbo->type) { case "list": echo selList($results, $recID, null, $attributes . ' ' . $disabled); break; case "text": echo '<input type="text" name="' . $recID . '" id="' . $recID . '" ' . $attributes . ' readonly="readonly" ' . $disabled . ' value="' . $text . '" />'; echo '<input type="hidden" name="' . rtrim($recID, "_") . '" id="' . rtrim($recID, "_") . '" value="' . $first . '" />'; break; }
} echo "</div>"; } } else { echo ""; } ?> </div> </fieldset> <fieldset id="resources"> <legend>Resources</legend> <div class="frmrow"> <div class="frmcol"> <label>Import from Group</label> <?php echo selList($listSystemGroup, "id_sys_group", "arc('fldUser','" . $path . "filterMembers.php','id='+this.options[this.selectedIndex].value,0,1)", "class='elementIcon'"); ?> <span class="elementIconBox" onClick="addResource(<?php echo $_POST["id_srv"]; ?> )"><i class="fa fa-check"></i></span> </div> </div> <div id="fldUser" style="display:none"> </div> <div id="listResource"> <?php include "listResources.php"; ?> </div> </fieldset> <fieldset id="time_entry">
echo "Period: ".$period[0]." ".$period[1]."<br/>"; } */ ?> <div class="cStatus<?php echo $status; ?> " id="tcStatusBlock"><i class="fa fa-info-circle"></i><strong>Status:</strong> <?php echo $status; ?> </div> <div class="cList"> <div class="frmrow"> <div class="frmcol"> <label>Year</label> <?php echo selList($years, "year", "arc('vpPayPeriod','" . $path . "payperiodfiltered.php','yearID='+this.options[this.selectedIndex].value,0,0)", null, null, null, $yearID, true); ?> </div> <div class="frmcol" id="vpPayPeriod"> <?php if ($payFrequency == "biweekly") { $periodLabel = $periodKey / 2 + 1; } else { $periodLabel = $periodKey + 1; } require_once "_mod/smod_11/inc_perioddropdown.php"; ?> </div> </div> <div id="timecard"> <table class="dataGrid" id="tblPayPeriod">