<?php
/**
 *
 * Copyright (C) 2007,2008  Arie Nugraha (dicarve@yahoo.com)
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * some patches by hendro
 */

use SLiMS\DB;

// key to authenticate
if (!defined('INDEX_AUTH')) {
    define('INDEX_AUTH', '1');
}

if (basename($_SERVER['PHP_SELF']) == basename(__FILE__)) {
    include_once '../../sysconfig.inc.php';
}

// ============================================================
// TAMBAHAN: AMBIL DATA PERPUSTAKAAN DARI SESSION
// ============================================================
$library_id = isset($_SESSION['library_id']) ? (int)$_SESSION['library_id'] : 0;
$library_name = isset($_SESSION['library_name']) ? $_SESSION['library_name'] : 'Semua Perpustakaan';
$library_code = isset($_SESSION['library_code']) ? $_SESSION['library_code'] : 'ALL';
$library_color = isset($_SESSION['library_color']) ? $_SESSION['library_color'] : '#004db6';
// ============================================================
// AKHIR TAMBAHAN
// ============================================================
?>

<div class="menuBox adminHome">
    <div class="menuBoxInner">
        <div class="per_title">
            <h2><?php echo __('Library Administration'); ?></h2>
        </div>
    </div>
</div>

<!-- ============================================================
INFO PERPUSTAKAAN DI DASHBOARD
============================================================ -->
<div class="library-info" style="background: <?= $library_color ?>; color: white; padding: 15px; border-radius: 5px; margin: 0 15px 20px 15px;">
    <h3><i class="fa fa-building"></i> <?= htmlspecialchars($library_name) ?></h3>
    <p>Kode: <?= htmlspecialchars($library_code) ?> | Library ID: <?= $library_id ?></p>
</div>
<!-- ============================================================
AKHIR INFO PERPUSTAKAAN
============================================================ -->

<div id="backupProccess" style="display: none">
    <div class="alert alert-info">
        <strong><?= __('Database backup process is running, please wait') ?></strong>
    </div>
</div>
<div class="contentDesc">
    <div class="container-fluid">

        <div id="alert-new-version" class="alert alert-info border-0 mt-3 hidden">
            <strong>News!</strong> New version of SLiMS (<code id="new_version"></code>) available to <a class="notAJAX"
                                                                                                         target="_blank"
                                                                                                         href="https://github.com/slims/slims9_bulian/releases/latest">download</a>.
        </div>

        <?php
        // ============================================================
        // WARNINGS / PERINGATAN SISTEM (TETAP)
        // ============================================================
        $warnings = array();
        // check GD extension
        if (!extension_loaded('gd')) {
            $warnings[] = __('<strong>PHP GD</strong> extension is not installed. Please install it or application won\'t be able to create image thumbnail and barcode.');
        } else {
            // check GD Freetype
            if (!function_exists('imagettftext')) {
                $warnings[] = __('<strong>Freetype</strong> support is not enabled in PHP GD extension. Rebuild PHP GD extension with Freetype support or application won\'t be able to create barcode.');
            }
        }
        // check for overdue
        $overdue_q = $dbs->query('SELECT COUNT(loan_id) FROM loan AS l WHERE (l.is_lent=1 AND l.is_return=0 AND TO_DAYS(due_date) < TO_DAYS(\'' . date('Y-m-d') . '\')) GROUP BY member_id');
        $num_overdue = $overdue_q->num_rows;
        if ($num_overdue > 0) {
            $warnings[] = str_replace('{num_overdue}', $num_overdue, __('There are currently <strong>{num_overdue}</strong> library members having overdue. Please check at <b>Circulation</b> module at <b>Overdues</b> section for more detail')); //mfc
            $overdue_q->free_result();
        }
        // check if images dir is writable or not
        if (!is_writable(IMGBS) OR !is_writable(IMGBS . 'barcodes') OR !is_writable(IMGBS . 'persons') OR !is_writable(IMGBS . 'docs')) {
            $warnings[] = __('<strong>Images</strong> directory and directories under it is not writable. Make sure it is writable by changing its permission or you won\'t be able to upload any images and create barcodes');
        }
        // check if file repository dir is writable or not
        if (!is_writable(REPOBS)) {
            $warnings[] = __('<strong>Repository</strong> directory is not writable. Make sure it is writable (and all directories under it) by changing its permission or you won\'t be able to upload any bibliographic attachments.');
        }
        // check if file upload dir is writable or not
        if (!is_writable(UPLOAD)) {
            $warnings[] = __('<strong>File upload</strong> directory is not writable. Make sure it is writable (and all directories under it) by changing its permission or you won\'t be able to upload any file, create report files and create database backups.');
        }
        // check installer directory
        if (is_dir('../install/')) {
            $warnings[] = __('Installer folder is still exist inside your server. Please remove it or rename to another name for security reason.');
        }

        // check need to be repaired mysql database
        $query_of_tables = $dbs->query('SHOW TABLES');
        $num_of_tables = $query_of_tables->num_rows;
        $prevtable = '';
        $repair = '';
        $is_repaired = false;

        if ($_SESSION['uid'] === '1') {
            $warnings[] = __('<strong><i>You are logged in as Super User. With great power comes great responsibility.</i></strong>');
            if (isset ($_POST['do_repair'])) {
                if ($_POST['do_repair'] == 1) {
                    while ($row = $query_of_tables->fetch_row()) {
                        $sql_of_repair = 'REPAIR TABLE ' . $row[0];
                        $query_of_repair = $dbs->query($sql_of_repair);
                    }
                }
            }

            while ($row = $query_of_tables->fetch_row()) {
                $query_of_check = $dbs->query('CHECK TABLE `' . $row[0] . '`');
                if ($query_of_check) {
                    while ($rowcheck = $query_of_check->fetch_assoc()) {
                        if (!(($rowcheck['Msg_type'] == "status") && ($rowcheck['Msg_text'] == "OK"))) {
                            if ($row[0] != $prevtable) {
                                $repair .= '<li>' . __('Table') . ' ' . $row[0] . ' ' . __('might need to be repaired.') . '</li>';
                            }
                            $prevtable = $row[0];
                            $is_repaired = true;
                        }
                    }
                }
            }
            if (($is_repaired) && !isset($_POST['do_repair'])) {
                echo '<div class="message">';
                echo '<ul>';
                echo $repair;
                echo '</ul>';
                echo '</div>';
                echo ' <form method="POST" style="margin:0 10px;">
        <input type="hidden" name="do_repair" value="1">
        <input type="submit" value="' . __('Click Here To Repair The Tables') . '" class="button btn btn-block btn-default">
        </form>';
            }
        }

        if (utility::havePrivilege('system', 'r') && utility::havePrivilege('system', 'w'))
        {
            // info
            $backupConfigStatus = config('database_backup.reminder') || config('database_backup.auto');
            $backupIsNoAuto = config('database_backup.reminder') && !config('database_backup.auto');
            $alreadyBackup = DB::hasBackup(by: DB::BACKUP_BASED_ON_DAY);

            if ($alreadyBackup === false && $backupConfigStatus) 
                $_SESSION['token'] = utility::createRandomString(32);
            
            if ($alreadyBackup === false && $is_repaired === false && $backupIsNoAuto === true) {
                echo '<div class="alert alert-info border-0 mt-3">';
                echo '<span>' . __('It looks like today you haven\'t backup your database.') . 
                '.&nbsp;&nbsp;<a href="'.MWB.'system/backup_proc.php" id="backupproc" class="notAJAX btn btn-primary">' . __('Backup Now') . '</a>' .
                '</span>';
                echo '</div>';
            }
        }

        // if there any warnings
        if ($warnings) {
            echo '<div class="alert alert-warning border-0 mt-3">';
            foreach ($warnings as $warning_msg) {
                echo '<div>' . $warning_msg . '</div>';
            }
            echo '</div>';
        }
        // ============================================================
        // AKHIR WARNINGS
        // ============================================================

        // admin page content
        if ($sysconf['admin_home']['mode'] == 'default') {
            require LIB . 'content.inc.php';
            $content = new content();
            $content_data = $content->get($dbs, 'adminhome');
            if ($content_data) {
                echo '<div class="contentDesc">' . $content_data['Content'] . '</div>';
                unset($content_data);
            }
        }
        ?>
    </div>
</div>

<?php if (utility::havePrivilege('system', 'r') && utility::havePrivilege('system', 'w')): ?>
<script>
    <?php if (config('database_backup.reminder') && !config('database_backup.auto')): ?>
        // Backup process
        $('#backupproc').click(function(e) {
            e.preventDefault()
            let currentLabel = $(this).html()
            $(this).removeClass('btn-primary').addClass('btn-secondary disabled')
            $(this).html('<?= __('Please wait') ?>')
            backupDatabase($(this).attr('href'), function(result) {
                if (result.status) {
                    window.location.href = '<?= $_SERVER['PHP_SELF'] ?>'
                } else {
                    $(this).html(currentLabel)
                    console.error(result.message)
                    window.toastr.error(result.message, '<?= __('Error') ?>')
                }
            })
        })
    <?php endif; ?>

    function backupDatabase(href, callback) {
        $.post(href, {start:true,tkn:'<?= $_SESSION['token']??'' ?>',verbose:'no',response:'json'}, function(result, status, post){
            var result = JSON.parse(result)
            callback(result)
        });
    }

    <?php if (!$is_repaired && !$alreadyBackup && config('database_backup.auto')): ?>
        $('.contentDesc').slideUp();
        $('#backupProccess').slideDown();
        backupDatabase('<?= MWB.'system/backup_proc.php' ?>', function(result) {
            if (result.status) {
                window.location.href = '<?= $_SERVER['PHP_SELF'] ?>'
            } else {
                $(this).html(currentLabel)
                console.error(result.message)
                window.toastr.error(result.message, '<?= __('Error') ?>')
            }
        })
    <?php endif; ?>
</script>
<?php endif; ?>

<?php if ((int) $_SESSION['uid'] === 1) : ?>
<script>
    // get latest release
    fetch('https://api.github.com/repos/slims/slims9_bulian/releases/latest')
        .then(res => res.json())
        .then(res => {
            if (res.tag_name > '<?= SENAYAN_VERSION_TAG; ?>') {
                $('#new_version').text(res.tag_name);
                $('#alert-new-version').removeClass('hidden');
                $('#alert-new-version a').attr('href', res.html_url)
            }
        })
</script>
<?php endif; ?>