/** * @file guifi_funders.inc.php * Manage guifi_funders fieldssets, validations, etc... */ function guifi_funders_load($id, $subject_type, $ret = "txt") { $qsql = sprintf('SELECT * FROM {guifi_funders} ' . 'WHERE subject_id = %d ' . ' AND subject_type = "%s" ' . 'ORDER BY id', $id, $subject_type); $result = db_query($qsql); guifi_log(GUIFILOG_TRACE, 'function guifi_funders_load(sql)', $qsql); while ($m = db_fetch_array($result)) { switch ($ret) { case "txt": if (!empty($m['supplier_id'])) { $m['supplier'] = $m['supplier_id'] . '-' . budgets_supplier_get_suppliername($m['supplier_id']); } if (!empty($m['user_id'])) { $u = user_load($m['user_id']); $m['user'] = $m['user_id'] . '-' . $u->name . ' (' . $u->mail . ') '; } $funders[] = $m; break; case "uid": if (!empty($m['supplier_id'])) { $s = node_load($m['supplier_id']); $funders[] = $s->uid; } if (!empty($m['user_id'])) { $funders[] = $m['user_id']; } guifi_log(GUIFILOG_TRACE, 'function guifi_funders_load(funders)', $funders); break; } } return $funders; }
/** * @file guifi_maintainers.inc.php * Manage guifi_maintainers fieldssets, validations, etc... */ function guifi_maintainers_load($id, $subject_type, $ret = "maintainer") { $qsql = sprintf('SELECT * FROM {guifi_maintainers} ' . 'WHERE subject_id = %d ' . ' AND subject_type = "%s" ' . 'ORDER BY id', $id, $subject_type); $result = db_query($qsql); guifi_log(GUIFILOG_TRACE, 'function guifi_maintainers_load(sql)', $ret . ' - ' . $qsql); while ($m = db_fetch_array($result)) { switch ($ret) { case "maintainer": $m['maintainer'] = $m['supplier_id'] . '-' . budgets_supplier_get_suppliername($m['supplier_id']); $maintainers[] = $m; break; case "uid": $s = node_load(array('nid' => $m['supplier_id'])); $maintainers[] = $s->uid; break; } } guifi_log(GUIFILOG_TRACE, 'function guifi_maintainers_load(maintainers)', $maintainers); return $maintainers; }