PHP w2p_Database_Query::loadHash方法代码示例

 private static function loadHolidaysSettings()
 {
     global $AppUI;
     if (is_null(self::$holiday_manual)) {
         // Query database for settings
         $q = new w2p_Database_Query();
         $q->addTable("holiday_settings");
         $q->addQuery("holiday_manual, holiday_auto, holiday_driver, holiday_filter");
         $settings = $q->loadHash();
         self::$holiday_manual = $settings['holiday_manual'];
         self::$holiday_auto = $settings['holiday_auto'];
         self::$holiday_driver = $settings['holiday_driver'];
         self::$holiday_filter = $settings['holiday_filter'];
     }
     if (self::$holiday_auto && self::$holiday_filter >= 0 && is_null(self::$holiday_filter_instance)) {
         $filters_alloc = Date_Holidays::getInstalledFilters();
         require_once dirname(__FILE__) . "/PEAR/Holidays/Filter/" . str_replace("_", "/", $filters_alloc[self::$holiday_filter]['title']) . ".php";
         $filterclass = "Date_Holidays_Filter_" . $filters_alloc[self::$holiday_filter]['title'];
         self::$holiday_filter_instance = new $filterclass();
     }
     if (self::$holiday_auto && self::$holiday_driver >= 0 && is_null(self::$holiday_driver_instance)) {
         $drivers_alloc = Date_Holidays::getInstalledDrivers();
         self::$holiday_driver_instance = Date_Holidays::factory($drivers_alloc[self::$holiday_driver]['title'], null, $AppUI->user_locale);
     }
 }

 public function install()
 {
     $q = new w2p_Database_Query();
     $q->addTable('modules');
     $q->addQuery('mod_directory');
     $q->addWhere('mod_directory = \'' . $this->mod_directory . '\'');
     if ($temp = $q->loadHash()) {
         // the module is already installed
         // TODO: check for older version - upgrade
         return false;
     }
     // This arbitrarily places it at the end of the list.
     $this->mod_ui_order = 100;
     $this->store();
     $this->_compactModuleUIOrder();
     $perms =& $GLOBALS['AppUI']->acl();
     $perms->addModule($this->mod_directory, $this->mod_name);
     // Determine if it is an admin module or not, then add it to the correct set
     if (!isset($this->mod_admin)) {
         $this->mod_admin = 0;
     }
     if ($this->mod_admin) {
         $perms->addGroupItem($this->mod_directory, "admin");
     } else {
         $perms->addGroupItem($this->mod_directory, "non_admin");
     }
     if (isset($this->permissions_item_table) && $this->permissions_item_table) {
         $perms->addModuleSection($this->permissions_item_table);
     }
     return true;
 }

 public function getProject()
 {
     $q = new w2p_Database_Query();
     $q->addTable('projects');
     $q->addQuery('project_name, project_short_name, project_color_identifier');
     $q->addWhere('project_id = ' . (int) $this->task_project);
     $projects = $q->loadHash();
     $q->clear();
     return $projects;
 }

        $selection_string = 'Department';
        $dataId = $dept_id;
        $deptList = CDepartment::getDepartmentList(null, $company_id, null);
        foreach ($deptList as $dept) {
            $select_list[$dept['dept_id']] = $dept['dept_name'];
        }
        break;
}
$select_list = array('0' => '') + $select_list;
$myId = (int) w2PgetParam($_POST, $id_field, 0);
if ($myId) {
    $q = new w2p_Database_Query();
    $q->addTable($table_name);
    $q->addQuery('*');
    $q->addWhere($id_field . '=' . $myId);
    $r_data = $q->loadHash();
    $q->clear();
    $data_update_script = '';
    $update_address = isset($_POST['overwrite_address']);
    if ($table_name == 'companies') {
        $update_fields = array();
        if ($update_address) {
            $update_fields = array('company_address1' => 'contact_address1', 'company_address2' => 'contact_address2', 'company_city' => 'contact_city', 'company_state' => 'contact_state', 'company_zip' => 'contact_zip', 'company_phone1' => 'contact_phone', 'company_phone2' => 'contact_phone2', 'company_fax' => 'contact_fax');
        }
        if ($myId > 0) {
            $data_update_script = "opener.setCompany({$myId} , '" . $AppUI->__($r_data[$name_field], UI_OUTPUT_JS) . "');";
        } else {
            $data_update_script = "opener.setCompany({$myId}, '');";
        }
    } else {
        if ($table_name == 'departments') {

 public function w2Pacl_nuclear($userid, $module, $item, $mod_class = array())
 {
     global $AppUI;
     //This is a sensitive function so if the minimum permission request arguments are not provided don't permit anything to this item
     if (!$userid || !$module || !$item) {
         return array();
     }
     if (!count($mod_class)) {
         $q = new w2p_Database_Query();
         $q->addTable('modules');
         $q->addQuery('mod_main_class, permissions_item_table, permissions_item_field, permissions_item_label, mod_directory');
         $q->addWhere('mod_directory = \'' . $module . '\'');
         $q->addWhere('mod_active = 1');
         $mod_class = $q->loadHash();
     }
     //If we don't know what is the module we are dealing with lets deny
     if (!$mod_class['mod_directory']) {
         dprint(__FILE__, __LINE__, 2, 'user:' . $userid . 'module:' . $module . 'Item:' . $item . $AppUI->getModuleClass($mod_class['mod_directory']));
         return array();
     }
     $obj = new $mod_class['mod_main_class']();
     $allowedRecords = array();
     if ($module == 'projects') {
         $allowedRecords = $obj->getAllowedRecords($userid, $mod_class['permissions_item_table'] . '.' . $mod_class['permissions_item_field'] . ',' . $mod_class['permissions_item_label'], '', null, null, 'projects');
     } else {
         $allowedRecords = $obj->getAllowedRecords($userid, $mod_class['permissions_item_table'] . '.' . $mod_class['permissions_item_field'] . ',' . $mod_class['permissions_item_label']);
     }
     if (count($allowedRecords)) {
         if (isset($allowedRecords[(int) $item])) {
             return array('access' => 1, 'acl_id' => 'checked');
         } else {
             return array();
         }
     } else {
         return array();
     }
 }

        if ($action == 'add') {
            $q->clear();
        }
        $q->addTable('history');
        $q->addUpdate('history_item = history_id');
        $q->addWhere('history_table = \'history\'');
        $okMsg = 'History deleted';
    }
    $q->clear();
    $AppUI->redirect();
}
// pull the history
$q->addTable('history');
$q->addQuery('*');
$q->addWhere('history_id =' . $history_id);
$history = $q->loadHash();
$q->clear();
$titleBlock = new CTitleBlock($history_id ? 'Edit history' : 'New history', 'stock_book_blue_48.png', 'history', 'history.' . $a);
if ($canDelete) {
    $titleBlock->addCrumbDelete('delete history', $canDelete, $msg);
}
$titleBlock->show();
?>

<script language="javascript" type="text/javascript">
	function delIt() {
		document.AddEdit.action.value = 'del';
		document.AddEdit.submit();
	}

    function cancel() {

foreach ($avail_modules as $avail_module) {
    $modules[$avail_module['value']] = $avail_module['value'];
}
$modules = array(0 => 'All Modules') + $modules;
$actions = array(0 => 'All Actions', 'access' => 'access', 'add' => 'add', 'delete' => 'delete', 'edit' => 'edit', 'view' => 'view');
$table = '<table class="tbl" width="100%" cellspacing="1" cellpadding="2" border="0">';
$table .= '<tr><th colspan="9"><b>Permission Result Table</b></th></tr>';
$table .= '<tr><th>UserID</th><th>User</th><th>User Name</th><th>Module</th><th>Item</th><th>Item Name</th><th>Action</th><th>Allow</th><th>ACL_ID</th></tr>';
foreach ($permissions as $permission) {
    $item = '';
    if ($permission['item_id']) {
        $q = new w2p_Database_Query();
        $q->addTable('modules');
        $q->addQuery('permissions_item_field,permissions_item_label');
        $q->addWhere('mod_directory = \'' . $permission['module'] . '\'');
        $field = $q->loadHash();
        $q = new w2p_Database_Query();
        $q->addTable($permission['module']);
        $q->addQuery($field['permissions_item_label']);
        $q->addWhere($field['permissions_item_field'] . ' = \'' . $permission['item_id'] . '\'');
        $item = $q->loadResult();
    }
    if (!($permission['item_id'] && !$permission['acl_id'])) {
        $table .= '<tr>' . '<td style="text-align:right;">' . $permission['user_id'] . '</td>' . '<td>' . $permission['user_name'] . '</td>' . '<td>' . $users[$permission['user_id']] . '</td>' . '<td>' . $permission['module'] . '</td>' . '<td style="text-align:right;">' . ($permission['item_id'] ? $permission['item_id'] : '') . '</td>' . '<td>' . ($item ? $item : 'ALL') . '</td>' . '<td>' . $permission['action'] . '</td>' . '<td ' . (!$permission['access'] ? 'style="text-align:right;background-color:red"' : 'style="text-align:right;background-color:green"') . '>' . $permission['access'] . '</td>' . '<td ' . ($permission['acl_id'] ? '' : 'style="background-color:gray"') . '>' . ($permission['acl_id'] ? $permission['acl_id'] : 'soft-denial') . '</td>' . '</tr>';
    }
}
$table .= '</table>';
$users = array('' => '(' . $AppUI->_('Select User') . ')') + $users;
$user = isset($_POST['user']) && $_POST['user'] != '' ? $_POST['user'] : $AppUI->user_id;
$user_selector = arraySelect($users, 'user', 'class="text" onchange="javascript:document.pickUser.submit()"', $user);
$module = isset($_POST['module']) && $_POST['module'] != '' ? $_POST['module'] : '';

    echo '<br />';
    if (function_exists('styleRenderBoxTop')) {
        echo styleRenderBoxTop();
    }
    echo '<table cellspacing="0" cellpadding="4" border="0" width="100%" class="std">
<tr>
	<td>';
    echo '<table class="std" width="100%">';
    echo '<tr><th>' . $AppUI->_('Task name') . '</th><th>' . $AppUI->_('T.Owner') . '</th><th>' . $AppUI->_('H.Alloc.') . '</th><th>' . $AppUI->_('Task end date') . '</th><th>' . $AppUI->_('Last activity date') . '</th><th>' . $AppUI->_('Done') . '?</th></tr>';
    $hrs = $AppUI->_('hrs');
    // To avoid calling $AppUI each row
    foreach ($tasks as $task) {
        if ($actual_project_id != $task['task_project']) {
            echo '<tr><td colspan="6"><b>' . $task['project_name'] . '</b></td>';
            $actual_project_id = $task['task_project'];
        }
        $q->addTable('task_log');
        $q->addQuery('*');
        $q->addWhere('task_log_task = ' . (int) $task['task_id']);
        $q->addOrder('task_log_date DESC');
        $q->setLimit(1);
        $task_log = $q->loadHash();
        $q->clear();
        $done_img = $task['task_percent_complete'] == 100 ? 'Yes' : 'No';
        echo '<tr><td>&nbsp;&nbsp;&nbsp;' . $task['task_name'] . '</td><td>' . $task['user_username'] . '</td><td align="right">' . $task['task_duration'] * $task['task_duration_type'] . ' ' . $hrs . '</td><td align="center">' . $task['task_end_date'] . '</td><td align="center">' . $task_log['task_log_date'] . '</td><td align="center">' . $done_img . '</td></tr>';
    }
    echo '</table>';
    echo '</td>
</tr>
</table>';
}

    $q->addTable('contacts', 'con');
    $q->addQuery('con.*, company_id, company_name, dept_name');
    $q->addJoin('companies', 'com', 'contact_company = company_id');
    $q->addJoin('departments', 'dep', 'dept_id = contact_department');
    $q->addWhere('con.contact_id = ' . (int) $contact_id);
} else {
    $q = new w2p_Database_Query();
    $q->addTable('users', 'u');
    $q->addQuery('u.*');
    $q->addQuery('con.*, company_id, company_name, dept_name');
    $q->addJoin('contacts', 'con', 'user_contact = contact_id', 'inner');
    $q->addJoin('companies', 'com', 'contact_company = company_id');
    $q->addJoin('departments', 'dep', 'dept_id = contact_department');
    $q->addWhere('u.user_id = ' . (int) $user_id);
}
$user = $q->loadHash();
if (!$user && $user_id > 0) {
    $titleBlock = new CTitleBlock('Invalid User ID', 'helix-setup-user.png', $m, $m . '.' . $a);
    $titleBlock->addCrumb('?m=admin', 'users list');
    $titleBlock->show();
} else {
    if (!$user_id && !$contact_id) {
        $user['contact_id'] = 0;
    }
    // pull companies
    $company = new CCompany();
    $companies = $company->getAllowedRecords($AppUI->user_id, 'company_id,company_name', 'company_name');
    $companies = arrayMerge(array('0' => ''), $companies);
    // setup the title block
    $ttl = $user_id ? 'Edit User' : 'Add User';
    $titleBlock = new CTitleBlock($ttl, 'helix-setup-user.png', $m, $m . '.' . $a);

/**
 * @param $row
 *
 * @return array
 */
function getPermissionField($row)
{
    $q = new w2p_Database_Query();
    $q->addTable('modules');
    $q->addQuery('permissions_item_field,permissions_item_label');
    $q->addWhere('mod_directory = \'' . $row['module'] . '\'');
    $field = $q->loadHash();
    return $field;
}

 public function show_history($history)
 {
     global $AppUI;
     $id = $history['history_item'];
     $module = $history['history_table'];
     $secondary_key = '';
     if ($module == 'companies') {
         $table_id = 'company_id';
     } elseif ($module == 'modules') {
         $table_id = 'mod_id';
     } elseif ($module == 'departments') {
         $table_id = 'dept_id';
     } elseif ($module == 'forums') {
         $table_id = 'forum_id';
     } elseif ($module == 'forum_messages') {
         $table_id = 'message_id';
     } elseif ($module == 'task_log') {
         $table_id = (substr($module, -1) == 's' ? substr($module, 0, -1) : $module) . '_id';
         $secondary_key = ', task_log_task';
     } else {
         $table_id = (substr($module, -1) == 's' ? substr($module, 0, -1) : $module) . '_id';
     }
     if ($module == 'login') {
         return $AppUI->_('User') . ' "' . $history['history_description'] . '" ' . $AppUI->_($history['history_action']);
     }
     if ($history['history_action'] == 'add') {
         $msg = $AppUI->_('Added new') . ' ';
     } elseif ($history['history_action'] == 'update') {
         $msg = $AppUI->_('Modified') . ' ';
     } elseif ($history['history_action'] == 'delete') {
         return $AppUI->_('Deleted') . ' "' . $history['history_description'] . '" ' . $AppUI->_('from') . ' ' . $AppUI->_($module) . ' ' . $AppUI->_('module');
     }
     $q = new w2p_Database_Query();
     $q->addTable($module);
     $q->addQuery($table_id . $secondary_key);
     $q->addWhere($table_id . ' =' . $id);
     $result = $q->loadHash();
     if ($result) {
         switch ($module) {
             case 'history':
                 $link = '&a=addedit&history_id=';
                 break;
             case 'files':
                 $link = '&a=addedit&file_id=';
                 break;
             case 'tasks':
                 $link = '&a=view&task_id=';
                 break;
             case 'forums':
                 $link = '&a=viewer&forum_id=';
                 break;
             case 'projects':
                 $link = '&a=view&project_id=';
                 break;
             case 'companies':
                 $link = '&a=view&company_id=';
                 break;
             case 'contacts':
                 $link = '&a=view&contact_id=';
                 break;
             case 'task_log':
                 $module = 'tasks';
                 $link = '&a=view&task_id=' . $result['task_log_task'] . '&tab=0#tasklog';
                 break;
         }
     }
     $q->clear();
     if (!empty($link)) {
         $link = '<a href="?m=' . $module . $link . $id . '">' . $history['history_description'] . '</a>';
     } else {
         $link = $history['history_description'];
     }
     $msg .= $AppUI->_('item') . " '{$link}' " . $AppUI->_('in') . ' ' . $AppUI->_(ucfirst($module)) . ' ' . $AppUI->_('module');
     // . $history;
     return $msg;
 }

for ($i = 0; $drivers_alloc[$i]; $i++) {
    $drivers_available[$i] = $drivers_alloc[$i]['title'];
}
$filters_alloc = Date_Holidays::getInstalledFilters();
$filters_available = array(-1 => $AppUI->_("None"));
for ($i = 0; $filters_alloc[$i]; $i++) {
    list($country, $whitelist) = explode("_", $filters_alloc[$i]['title']);
    if ($whitelist) {
        $filters_available[$i] = $AppUI->_($country) . " >> " . $AppUI->_($whitelist);
    }
}
// Query database settings
$q = new w2p_Database_Query();
$q->addTable("holiday_settings");
$q->addQuery("holiday_manual, holiday_auto, holiday_driver, holiday_filter");
extract($q->loadHash());
// establish the focus 'date'
$date = w2PgetParam($_GET, 'date', null);
if (!$date) {
    $date = new w2p_Utilities_Date();
} else {
    $date = new w2p_Utilities_Date($date);
}
$date->setDay(1);
$date->setMonth(1);
$date->setTime(0, 0, 0);
$year = $date->getYear();
$prev_year = $date->format(FMT_TIMESTAMP_DATE);
$prev_year = (int) ($prev_year - 10000);
$next_year = $date->format(FMT_TIMESTAMP_DATE);
$next_year = (int) ($next_year + 10000);