/** * Returns all fields of the given class * * @param array $cids the class ids * @param int $pid the project-id (default = current) * @return array an array of PC_Obj_Field objects */ public function get_all($cids, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Array_Utils::is_integer($cids)) { FWS_Helper::def_error('intarray', 'cids', $cids); } if (count($cids) == 0) { return array(); } $stmt = $db->get_prepared_statement('SELECT * FROM ' . PC_TB_CLASS_FIELDS . ' WHERE project_id = :pid AND class IN (:cids)'); $stmt->bind(':pid', PC_Utils::get_project_id($pid)); $stmt->bind(':cids', $cids); $fields = array(); $rows = $db->get_rows($stmt->get_statement()); foreach ($rows as $row) { $field = new PC_Obj_Field($row['file'], $row['line'], $row['name'], unserialize($row['type']), $row['visibility'], $row['class']); $field->set_static($row['static']); $fields[] = $field; } return $fields; }
/** * Returns all functions * * @param array $cids the class ids (0 = free functions) * @param int $start the start-position (for the LIMIT-statement) * @param int $count the max. number of rows (for the LIMIT-statement) (0 = unlimited) * @param string $file the file-name to search for * @param string $name the function-name to search for * @param int $pid the project-id (current by default) * @return array all found functions */ public function get_list($cids, $start = 0, $count = 0, $file = '', $name = '', $pid = PC_PRoject::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Helper::is_integer($start) || $start < 0) { FWS_Helper::def_error('intge0', 'start', $start); } if (!FWS_Helper::is_integer($count) || $count < 0) { FWS_Helper::def_error('intge0', 'count', $count); } if (!FWS_Array_Utils::is_integer($cids)) { FWS_Helper::def_error('intarray', 'cids', $cids); } if (count($cids) == 0) { return array(); } $funcs = array(); $stmt = $db->get_prepared_statement('SELECT * FROM ' . PC_TB_FUNCTIONS . ' WHERE project_id = :pid AND class IN (:cids) ' . ($file ? ' AND file LIKE :file' : '') . ' ' . ($name ? ' AND name LIKE :name' : '') . ' ORDER BY name ' . ($count > 0 ? ' LIMIT :start,:count' : '')); $stmt->bind(':pid', PC_Utils::get_project_id($pid)); $stmt->bind(':cids', $cids); if ($file) { $stmt->bind(':file', '%' . $file . '%'); } if ($name) { $stmt->bind(':name', '%' . $name . '%'); } if ($count > 0) { $stmt->bind(':start', $start); $stmt->bind(':count', $count); } $rows = $db->get_rows($stmt->get_statement()); foreach ($rows as $row) { $funcs[] = $this->build_func($row); } return $funcs; }
/** * Deletes all given error-types for given project * * @param array $types an array of the types * @param int $pid the project-id (default = current) * @return int the number of affected rows */ public function delete_by_type($types, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Array_Utils::is_integer($types) || count($types) == 0) { FWS_Helper::def_error('intarray>0', 'types', $types); } $stmt = $db->get_prepared_statement('DELETE FROM ' . PC_TB_ERRORS . ' WHERE project_id = :id AND type IN (:types)'); $stmt->bind(':id', PC_Utils::get_project_id($pid)); $stmt->bind(':types', $types); $db->execute($stmt->get_statement()); return $db->get_affected_rows(); }