<th align="left" nowrap="nowrap"> </th> </tr> <?php while ($attachmentrecord = $db->fetchArray($attchmentsquery)) { ?> <tr> <td nowrap="nowrap"><?php echo $attachmentrecord["displayname"]; ?> </td> <td><?php echo $attachmentrecord["recordid"]; ?> </td> <td align="right" nowrap="nowrap"><?php echo formatFromSQLDatetime($attachmentrecord["creationdate"]); ?> </td> <td> <button class="graphicButtons buttonEdit" type="button" onclick="document.location='<?php echo APP_PATH . $attachmentrecord["editfile"] . "?id=" . $attachmentrecord["recordid"]; ?> '"><span>edit</span></button> </td> </tr> <?php } ?> </table></div></div><?php } }
function showGeneralInfo($phpbms, $therecord) { ?> <div id="createmodifiedby" > <table> <tbody> <tr class="topRows"> <td class="cmTitles"> <input name="createdby" type="hidden" value="<?php $therecord["createdby"]; ?> " /> <input name="creationdate" type="hidden" value="<?php echo formatFromSQLDatetime($therecord["creationdate"]); ?> "/> created </td> <td><?php echo htmlQuotes($phpbms->getUserName($therecord["createdby"])); ?> </td> <td><?php echo formatFromSQLDatetime($therecord["creationdate"]); ?> </td> <td id="cmButtonContainer" rowspan="3"> <?php showSaveCancel(2); ?> </td> </tr> <tr class="topRows"> <td class="cmTitles"> <input name="modifiedby" type="hidden" value="<?php $therecord["modifiedby"]; ?> " /> <input id="cancelclick" name="cancelclick" type="hidden" value="0" /> <input name="modifieddate" type="hidden" value="<?php echo formatFromSQLDatetime($therecord["modifieddate"]); ?> "/> modified </td> <td><?php echo htmlQuotes($phpbms->getUserName($therecord["modifiedby"])); ?> </td> <td><?php echo formatFromSQLDatetime($therecord["modifieddate"]); ?> </td> </tr> <tr> <td class="cmTitles"> uuid / id <input name="uuid" id="uuid" type="hidden" value="<?php if (isset($therecord["uuid"])) { echo $therecord["uuid"]; } ?> " /> <input id="id" name="id" type="hidden" value="<?php echo $therecord["id"]; ?> " /> </td> <td colspan="2" id="cmIds"><span><?php echo isset($therecord["uuid"]) ? $therecord["uuid"] : ' '; ?> </span><span id="cmId"><?php echo $therecord["id"]; ?> </span></td> </tr> </tbody> </table> </div> <?php }
function formatVariable($value, $format = NULL) { switch ($format) { case "real": $value = number_format($value, 2); break; case "currency": $value = htmlQuotes(numberToCurrency($value)); break; case "boolean": $value = booleanFormat($value); break; case "date": $value = formatFromSQLDate($value); break; case "time": $value = formatFromSQLTime($value); break; case "datetime": $value = formatFromSQLDatetime($value); break; case "filelink": $value = "<button class=\"graphicButtons buttonDownload\" type=\"button\" onclick=\"document.location='" . APP_PATH . "servefile.php?i=" . $value . "'\"><span>download</span></button>"; //$value="<a href=\"".APP_PATH."servefile.php?i=".$value."\" style=\"display:block;\"><img src=\"".APP_PATH."common/stylesheet/".STYLESHEET."/image/button-download.png\" align=\"middle\" alt=\"view\" width=\"16\" height=\"16\" border=\"0\" /></a>"; break; case "invoice": if ($value > 0 and $value != 9999999) { $value = "<a href=\"" . APP_PATH . "modules/bms/invoices_addedit.php?id={$value}\">{$value}</a>"; } break; case "client": $value = "<a href=\"" . APP_PATH . "modules/bms/clients_addedit.php?id={$value}\">{$value}</a>"; break; case "noencoding": $value = $value; break; case "bbcode": $value = htmlQuotes($value); // This list needs to be expanded $bbcodelist["[b]"] = "<strong>"; $bbcodelist["[/b]"] = "</strong>"; $bbcodelist["[br]"] = "<br />"; $bbcodelist["[space]"] = " "; foreach ($bbcodelist as $bbcode => $translation) { $value = str_replace($bbcode, $translation, $value); } break; default: $value = htmlQuotes($value); } return $value; }
function getRecord($id = 0, $useUuid = false) { $therecord = parent::getRecord($id, $useUuid); if ($therecord["job"]) { $therecord["scripttype"] = "job"; } else { $therecord["scripttype"] = "pushrecord"; } $datearray = explode(" ", $therecord["startdatetime"]); $therecord["startdate"] = $datearray[0]; if (isset($datearray[1])) { $therecord["starttime"] = $datearray[1]; } else { $therecord["starttime"] = ""; } $datearray = explode(" ", $therecord["enddatetime"]); $therecord["enddate"] = $datearray[0]; if (isset($datearray[1])) { $therecord["endtime"] = $datearray[1]; } else { $therecord["endtime"] = ""; } $cronarray = explode("::", $therecord["crontab"]); if (isset($cronarray[0])) { $therecord["min"] = $cronarray[0]; } else { $therecord["min"] = "*"; } if (isset($cronarray[1])) { $therecord["hrs"] = $cronarray[1]; } else { $therecord["hrs"] = "*"; } if (isset($cronarray[2])) { $therecord["date"] = $cronarray[2]; } else { $therecord["date"] = "*"; } if (isset($cronarray[3])) { $therecord["mo"] = $cronarray[3]; } else { $therecord["mo"] = "*"; } if (isset($cronarray[4])) { $therecord["day"] = $cronarray[4]; } else { $therecord["day"] = "*"; } $therecord["lastrun"] = formatFromSQLDatetime($therecord["lastrun"]); return $therecord; }
echo formatFromSQLDatetime($therecord["creationdate"]); ?> </td> </tr> <tr> <td class="cmTitles"> <input name="modifiedby" type="hidden" value="<?php $therecord["modifiedby"]; ?> " /> <input id="cancelclick" name="cancelclick" type="hidden" value="0" /> <input name="modifieddate" type="hidden" value="<?php echo formatFromSQLDatetime($therecord["modifieddate"]); ?> "/> modified </td> <td><?php echo htmlQuotes($phpbms->getUserName($therecord["modifiedby"])); ?> </td> <td><?php echo formatFromSQLDatetime($therecord["modifieddate"]); ?> </td> </tr> </table> </div> <?php } //endif