<h3 class="pagetitle"><?php eT("Check data integrity");?></h3>

<div class="row" style="margin-bottom: 100px">
    <div class="col-lg-12">
        <div class="jumbotron message-box">
                <h2><?php eT("Data consistency check"); ?></h2>
                <p class="lead"><?php eT("If errors are showing up you might have to execute this script repeatedly."); ?></p>
                <p>
            <ul class='data-consistency-list list-unstyled'>
                <?php
                    // TMSW Conditions->Relevance:  Update this to use relevance processing results
                    if (isset($conditions))
                    {?>
                    <li><?php eT("The following conditions should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($conditions as $condition) {?>
                                 <li>CID:<?php echo $condition['cid'].' '.gT("Reason:")." {$condition['reason']}";?></li><?php
                            }?>
                        </ul>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All conditions meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($questionattributes)) { ?>
                    <li><?php printf(gT("There are %s orphaned question attributes."),count($questionattributes)); ?> </li>
                    <?php }
                    else
                    { ?>
                    <li><?php eT("All question attributes meet consistency standards."); ?> </li> <?php
                } ?>

                <?php
                    if ($defaultvalues) { ?>
                    <li><?php printf(gT("There are %s orphaned default value entries which can be deleted."),$defaultvalues); ?> </li>
                    <?php }
                    else
                    { ?>
                    <li><?php eT("All default values meet consistency standards."); ?> </li> <?php
                } ?>

                <?php
                    if ($quotas) { ?>
                    <li><?php printf(gT("There are %s orphaned quota entries which can be deleted."),$quotas); ?> </li>
                    <?php }
                    else
                    { ?>
                    <li><?php eT("All quotas meet consistency standards."); ?> </li> <?php
                } ?>

                <?php
                    if ($quotals) { ?>
                    <li><?php printf(gT("There are %s orphaned quota language settings which can be deleted."),$quotals); ?> </li>
                    <?php }
                    else
                    { ?>
                    <li><?php eT("All quota language settings meet consistency standards."); ?> </li> <?php
                } ?>

                <?php
                    if ($quotamembers) { ?>
                    <li><?php printf(gT("There are %s orphaned quota members which can be deleted."),$quotamembers); ?> </li>
                    <?php }
                    else
                    { ?>
                    <li><?php eT("All quota quota members meet consistency standards."); ?> </li> <?php
                } ?>

                <?php
                    if (isset($assessments))
                    {?>
                    <li><?php eT("The following assessments should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($assessments as $assessment) {?>
                                <li>AID:<?php echo $assessment['id'];?> <?php eT("Assessment:");?> <?php eT("Reason:");?> <?php echo $assessment['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All assessments meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($answers))
                    {?>
                    <li><?php eT("The following answers should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($answers as $answer) {?>
                                <li>QID:<?php echo $answer['qid'];?> <?php eT("Code:");?> <?php eT("Reason:");?> <?php echo $answer['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All answers meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($surveys))
                    {?>
                    <li><?php eT("The following surveys should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($surveys as $survey) {?>
                                <li>SID:<?php echo $survey['sid'];?> <?php eT("Reason:");?> <?php echo $survey['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All surveys meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($surveylanguagesettings))
                    {?>
                    <li><?php eT("The following survey language settings should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($surveylanguagesettings as $surveylanguagesetting) {?>
                                <li>SLID:<?php echo $surveylanguagesetting['slid'];?> <?php eT("Reason:");?> <?php echo $surveylanguagesetting['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All survey language settings meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($questions))
                    {?>
                    <li><?php eT("The following questions should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($questions as $question) {?>
                                <li>QID:<?php echo $question['qid'];?> <?php eT("Reason:");?> <?php echo $question['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All questions meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($groups))
                    {?>
                    <li><?php eT("The following groups should be deleted:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($groups as $group) {?>
                                <li>GID:<?php echo $group['gid'];?> <?php eT("Reason:");?> <?php echo $group['reason'];?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All groups meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($orphansurveytables))
                    {?>
                    <li><?php eT("The following old survey tables should be deleted because they contain no records or their parent survey no longer exists:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($orphansurveytables as $surveytable) {?>
                                <li><?php echo $surveytable;?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All old survey tables meet consistency standards."); ?></li><?php
                } ?>

                <?php
                    if (isset($orphantokentables))
                    {?>
                    <li><?php eT("The following old token tables should be deleted because they contain no records or their parent survey no longer exists:"); ?>
                        <ul class="list-unstyled" >
                            <?php
                                foreach ($orphantokentables as $tokentable) {?>
                                <li><?php echo $tokentable;?></li><?php
                            }?>
                        </ul>
                    </li>
                    <?php
                    }
                    else
                    { ?>
                    <li><?php eT("All old token tables meet consistency standards."); ?></li><?php
                } ?>
            </ul>

            <?php if ($integrityok) { ?>
                <br /> <?php eT("No database action required!"); ?>
                <?php } else
                {?>
                <br /><?php eT("Should we proceed with the delete?"); ?> <br />
                <?php echo CHtml::form(array("admin/checkintegrity","sa"=>'fixintegrity'), 'post');?>
                    <button type='submit' value='Y' name='ok' class="btn btn-default" ><?php eT("Yes - Delete Them!"); ?></button>
                </form>
                <?php
            } ?>
        </div>



        <div class="jumbotron message-box">
                <h2><?php eT("Data redundancy check"); ?></h2>
                <p class="lead"><?php eT("The redundancy check looks for tables leftover after deactivating a survey. You can delete these if you no longer require them."); ?></p>
                <p>
            <?php if ($redundancyok) { ?>
                <br /> <?php eT("No database action required!"); ?>
                <?php } else
                {?>
                <?php echo CHtml::form(array("admin/checkintegrity/fixredundancy"), 'post');?>
                    <ul class='data-redundancy-list list-unstyled'>
                        <?php
                            if (isset($redundantsurveytables))
                            {?>
                            <li><?php eT("The following old survey response tables exist and may be deleted if no longer required:"); ?>
                                <ul class='response-tables-list list-unstyled'>
                                    <?php
                                        foreach ($redundantsurveytables as $surveytable) {?>
                                        <li><input type='checkbox' id='cbox_<?php echo $surveytable['table']?>' value='<?php echo $surveytable['table']?>' name='oldsmultidelete[]' /> <label for='cbox_<?php echo $surveytable['table']?>'><?php echo $surveytable['details']?></label></li><?php
                                    }?>
                                </ul>
                            </li>
                            <?php
                        } ?>

                        <?php
                            if (isset($redundanttokentables) && count($redundanttokentables)>0)
                            {?>
                            <li><?php eT("The following old token list tables exist and may be deleted if no longer required:"); ?>
                                <ul class='token-tables-list list-unstyled'>
                                    <?php
                                        foreach ($redundanttokentables as $tokentable) {?>
                                        <li><input type='checkbox' id='cbox_<?php echo $tokentable['table']?>' value='<?php echo $tokentable['table']?>' name='oldsmultidelete[]' /> <label for='cbox_<?php echo $tokentable['table']?>'><?php echo $tokentable['details']?></label></li><?php
                                    }?>
                                </ul>
                            </li>
                            <?php
                        } ?>
                    </ul><p>
                        <input type='hidden' name='ok' value='Y' />
                        <input type='submit' value='<?php eT("Delete checked items!"); ?>' class="btn btn-default" /> <br />
                        <span class='hint warning'><?php eT("Note that you cannot undo a delete if you proceed. The data will be gone."); ?></span></p>
                </form><?php
            } ?>
        </div>
    </div>
