<?php
/**
 * DokuWiki Plugin dataau (Admin Component)
 *
 * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html
 * @author  Andreas Gohr <gohr@cosmocode.de>
 */

// must be run within Dokuwiki
if (!defined('DOKU_INC')) die();

/**
 * Let admin remove non-existing pages from sqlite db
 */
class admin_plugin_dataau_clean extends DokuWiki_Admin_Plugin {

    /**
     * will hold the dataau helper plugin
     * @var helper_plugin_data
     */
    protected $dthlp = null;

    /**
     * Constructor. Load helper plugin
     */
    public function __construct(){
        $this->dthlp = plugin_load('helper', 'dataau');
    }

    /**
     * Determine position in list in admin window
     * Lower values are sorted up
     *
     * @return int
     */
    public function getMenuSort() {
        return 502;
    }

    /**
     * Return true for access only by admins (config:superuser) or false if managers are allowed as well
     *
     * @return bool
     */
    public function forAdminOnly() {
        return true;
    }

    /**
     * Return the text that is displayed at the main admin menu
     *
     * @param string $language lang code
     * @return string menu string
     */
    public function getMenuText($language) {
        return $this->getLang('menu_clean');
    }

    /**
     * Carry out required processing
     */
    public function handle() {
        if(!isset($_REQUEST['dataau_go']) || !checkSecurityToken()) return;

        $sqlite = $this->dthlp->_getDB();
        if(!$sqlite) return;

        $res  = $sqlite->query("SELECT pid, page FROM pages");
        $rows = $sqlite->res2arr($res);

        $count = 0;
        foreach($rows as $row){
            if(!page_exists($row['page'])){
                $sqlite->query('DELETE FROM dataau WHERE pid = ?',$row['pid']);
                $sqlite->query('DELETE FROM pages WHERE pid = ?',$row['pid']);
                $count++;
            }
        }

        msg(sprintf($this->getLang('pages_del'),$count),1);
    }

    /**
     * Render HTML output
     */
    public function html() {

        echo $this->locale_xhtml('intro_clean');

        $form = new Doku_Form(array('method'=>'post'));
        $form->addHidden('page','dataau_clean');
        $form->addHidden('dataau_go','go');

        $form->addElement(form_makeButton('submit','admin',$this->getLang('submit_clean')));
        $form->printForm();
    }

}

// vim:ts=4:sw=4:et:enc=utf-8: