PHP Project::setDefaultDisplayFields Examples

Example #1

File: 33_set_required_fields.php Project: korusdipl/eventum

<?php

/**
 * Set required fields to match old default configuration
 */
$setup = Setup::load();
// check if the table has any entries. If so, update, otherwise create defaults.
// do this project by project in case additional projects were never setup
$projects = Project::getAll();
foreach ($projects as $prj_id => $prj_title) {
    if ($db->getOne('SELECT count(*) FROM {{%project_field_display}} WHERE pfd_prj_id = ?', array($prj_id)) > 0) {
        $db->query("UPDATE\n                        {{%project_field_display}}\n                    SET\n                        pfd_required = 1\n                    WHERE\n                      pfd_field IN('category', 'priority', 'severity') AND\n                      pfd_prj_id = ?", array($prj_id));
        if (isset($setup['allow_unassigned_issues']) && $setup['allow_unassigned_issues'] != 'yes') {
            $db->query("UPDATE\n                            {{%project_field_display}}\n                        SET\n                            pfd_required = 1\n                        WHERE\n                          pfd_field = 'assignment' AND\n                          pfd_prj_id = ?", array($prj_id));
        }
    } else {
        Project::setDefaultDisplayFields($prj_id);
    }
}