Ejemplo n.º 1
0
*/
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);
    }
}
Ejemplo n.º 3
0
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;
}