PHP enqueue_updated_forms Examples

Example #1

File: lib_history.php Project: ayunah/opencorpora

function revert_dict($rev_id)
{
    if (!$rev_id) {
        throw new UnexpectedValueException();
    }
    check_permission(PERM_DICT);
    $res = sql_pe("SELECT lemma_id, rev_text FROM dict_revisions WHERE rev_id=? LIMIT 1", array($rev_id));
    $lemma_id = $res[0]['lemma_id'];
    $old_rev = sql_pe("SELECT rev_text FROM dict_revisions WHERE lemma_id=? and is_last=1 LIMIT 1", array($lemma_id));
    sql_begin();
    $new_set_id = create_revset("Отмена правки, возврат к версии d{$rev_id}");
    $new_rev_id = new_dict_rev($lemma_id, $res[0]['rev_text'], $new_set_id);
    // updated forms
    $pdr = parse_dict_rev($old_rev[0]['rev_text']);
    enqueue_updated_forms(calculate_updated_forms($pdr, parse_dict_rev($res[0]['rev_text'])), $new_rev_id);
    sql_commit();
}

Example #2

File: lib_dict.php Project: ayunah/opencorpora

function del_lemma($id)
{
    check_permission(PERM_DICT);
    //delete links (but preserve history)
    $res = sql_pe("SELECT link_id FROM dict_links WHERE lemma1_id=? OR lemma2_id=?", array($id, $id));
    sql_begin();
    $revset_id = create_revset("Delete lemma {$id}");
    foreach ($res as $r) {
        del_link($r['link_id'], $revset_id);
    }
    // create empty revision
    sql_pe("UPDATE dict_revisions SET is_last=0 WHERE lemma_id=?", array($id));
    sql_pe("INSERT INTO dict_revisions VALUES (NULL, ?, ?, '', 1, 1, 1)", array($revset_id, $id));
    $rev_id = sql_insert_id();
    //update `updated_forms`
    $res = sql_pe("SELECT rev_text FROM dict_revisions WHERE lemma_id=? ORDER BY `rev_id` DESC LIMIT 1, 1", array($id));
    $pdr = parse_dict_rev($res[0]['rev_text']);
    $updated_forms = array();
    foreach ($pdr['forms'] as $form) {
        $updated_forms[] = $form['text'];
    }
    enqueue_updated_forms($updated_forms, $rev_id);
    //delete forms from form2lemma
    sql_pe("DELETE FROM `form2lemma` WHERE lemma_id=?", array($id));
    //delete lemma
    sql_pe("UPDATE dict_lemmata SET deleted=1 WHERE lemma_id=? LIMIT 1", array($id));
    sql_commit();
}