*/ require_once dirname(__FILE__) . '/../../common/connect/applyCredentials.php'; require_once dirname(__FILE__) . '/../../common/php/dbMySqlWrappers.php'; require_once dirname(__FILE__) . '/../../common/php/getRecordInfoLibrary.php'; mysql_connection_select(DATABASE); require_once dirname(__FILE__) . '/../../common/php/utilsTitleMask.php'; $mask = @$_REQUEST['mask']; // $rt = @$_REQUEST['rtID']; // $recID = @$_REQUEST['recID']; // if (!$rt or !$mask) { echo "please pass in at least a mask and a rectype ID as mask=validMaskStringHere&rtID=# <br />"; echo "you may also padd in a record ID of rectype to calculate the title <br />"; echo "be sure to add the db=databaseName for the database you are working on.<br />"; exit; } echo ($ret = check_title_mask($mask, $rt)) ? $ret . "<br /><br /><br />" : "title mask\"<b>{$mask}</b>\"checks out to be valid for rectype {$rt}<br /><br /><br />"; echo "canonical form for mask is \"<b>" . make_canonical_title_mask($mask, $rt) . "</b>\"<br /><br /><br />"; if (!$ret && $recID) { echo "Title for record {$recID} : <b>" . fill_title_mask($mask, $recID, $rt) . "</b><br />"; } //echo json_format(_title_mask__get_rec_detail_types(),true)."<br><br><br>"; //echo json_format(_title_mask__get_rec_detail_requirements(),true)."<br><br><br>"; //echo json_format(getTermTree("reltype","prefix"),true).";\n"; //echo print_r(getTermSets('reltypevocab'),true)."<br><br><br>"; //require_once(dirname(__FILE__).'/../../hapi/php/loadHapiCommonInfo.php'); //echo json_format(getAllRectypeConstraint(),true)."<br>"; //require_once(dirname(__FILE__).'/../../common/php/loadCommonInfo.php');//echo print_r(getRectypeStructureFields("174"),true)."c14<br>"; //require_once(dirname(__FILE__).'/../../import/bookmarklet/getRectypesAsJSON.php');//echo print_r(getRectypeStructureFields("174"),true)."c14<br>";
function checkRectypeMask($rtID, $rtName, $mask, $coMask, $recID, $check) { if (!@$mask && @$rtID) { $mask = mysql__select_array("defRecTypes", "rty_TitleMask", "rty_ID={$rtID}"); $mask = $mask[0]; } if (!@$coMask && @$rtID) { $coMask = mysql__select_array("defRecTypes", "rty_CanonicalTitleMask", "rty_ID={$rtID}"); $coMask = $coMask[0]; } //echo print_r($_REQUEST,true); if ($check > 0 || !$recID) { ?> <div> <h3>Checking rectype "<b><i><?php echo $rtName; ?> </i></b>"[<?php echo $rtID; ?> ]</h3> </div> <?php $retMaskCheck = check_title_mask2($mask, $rtID, true); echo "<div class='resultsRow'><div class='statusCell " . ($retMaskCheck == "" ? "valid'>" : "invalid'>in") . "valid</div>"; echo "<div class='maskCell'>mask = <i>{$mask}</i></div>"; if ($retMaskCheck != "") { echo "<div class='errorCell'>" . $retMaskCheck . "</div>"; } echo "</div>"; $retCoMaskCheck = check_title_mask2($coMask, $rtID, true); echo "<div class='resultsRow'><div class='statusCell " . ($retCoMaskCheck == "" ? "valid'>" : "invalid'>in") . "valid</div>"; echo "<div class='maskCell'>canonical mask = <i>{$coMask}</i></div>"; if ($retCoMaskCheck != "") { echo "<div class='errorCell'>" . $retCoMaskCheck . "</div>"; } echo "</div>"; if ($retCoMaskCheck !== "" && $retMaskCheck == "") { $coMask = make_canonical_title_mask($mask, $rtID); if ($check != 2) { echo "<div class='resultsRow'><div class='statusCell'></div><div class='maskCell'>Correct canonical mask = <span class='valid'>{$coMask}</span></div></div>"; } else { // repair canonical mysql_query("update defRecTypes set rty_CanonicalTitleMask='{$coMask}' where rty_ID={$rtID}"); $error = mysql_error(); echo "<div class='resultsRow'><div class='statusCell " . ($error == "" ? "valid'>Update successful" : "invalid'>Failed to update") . "</div>"; echo "<div class='maskCell'>Correct canonical mask = <span class='valid'>{$coMask}</span></div>"; echo ($error ? "<div class='errorCell invalid'> Error : " . $error . "</div>" : "") . "</div>"; } } echo "<hr>\n"; } else { echo "checking type mask {$mask} for recType {$rtID} and rec {$recID} <br/>"; echo fill_title_mask($mask, $recID, $rtID); } }
function updateCanonicalTitleMask($rtyID, $mask) { global $rtyColumnNames, $db; $ret = 0; if ($mask) { $val = make_canonical_title_mask($mask, $rtyID); $colName = "rty_CanonicalTitleMask"; $parameters = array(""); $parameters[0] = $parameters[0] . $rtyColumnNames[$colName]; array_push($parameters, $val); $query = "update defRecTypes set {$colName} = ? where rty_ID = {$rtyID}"; $res = execSQL($db, $query, $parameters, true); if (!is_numeric($res)) { $ret = "SQL error updating record type {$rtyID} in updateRectype: " . $res; } } return $ret; }