private function process()
{
$this->commonProcess();
$config = services::getService('config');
$lang = services::getService('lang');
$params = services::getService('pageParams');
$mail = services::getService('mail');
$categories = services::getService('cats');
$pool = new pools();
if ($pool->get($params->getParam('pool_id'))) {
// become member
if ($params->getParam('action') == 'become_member') {
if ($params->getParam('become_member_submit') || $pool->is_public) {
$new_membership = new poolsUser();
$new_membership->user_id = $this->user->id;
$new_membership->pool_id = $pool->id;
if (!$pool->is_public) {
$new_membership->wait = 1;
} else {
$new_membership->res_to_free = 1;
$new_membership->wait = 0;
}
if ($params->getParam('become_member_comments')) {
$new_membership->comments = $params->getParam('become_member_comments');
}
$new_membership->insert();
// compose E-Mails
if (!$pool->is_public) {
$tos = $pool->getAdmins();
foreach ($tos as $to) {
$mail->send('new_member', $to, $pool, $this->user, $new_membership->comments);
}
} else {
$this->switchPage('mysite&new_pool=' . $pool->id);
}
} else {
$this->become_member_form = true;
}
}
// are you waiting?
if ($pool->isWaiting($this->user->id)) {
$this->user_is_waiting = true;
}
// loose membership
if ($params->getParam('action') == 'no_member') {
// the last admin can't leave the pool
if (!$pool->isLastAdmin($this->user->id)) {
$pool->removeMember($this->user->id);
$this->addMsg('msg_leave_pool');
} else {
$this->addMsg('msg_leave_pool_last_admin');
}
}
// build tabledata
if ($pool->isMember($this->user->id)) {
$showcats = $categories->getChildren(0);
foreach ($showcats as $cat_id => $cat_name) {
$show_res = new resFetcher();
$show_res->_cat = $cat_id;
$show_res->_pools = array($pool->id);
$rescounter = $show_res->count();
if ($rescounter > 0) {
$this->cats[$cat_id] = array("name" => $cat_name, "count" => $rescounter);
}
}
$allcount = 0;
foreach ($this->cats as $cat) {
$allcount += $cat['count'];
}
$this->cats[0] = array("name" => $lang->getMsg('cat_all'), "count" => $allcount);
} else {
if (!$pool->isMember($this->user->id, true)) {
$this->not_member = true;
}
$res_counter = new poolsResources();
$res_counter->pool_id = $pool->id;
$this->res_counter = 0;
$res_counter->find();
while ($res_counter->fetch()) {
++$this->res_counter;
}
}
// build forum-tabledata
if ($pool->isMember($this->user->id)) {
// new/change entry
if ($params->getParam('action') == 'new_entry') {
// formular
$form = new form('forum_entry');
$form->addElement('text', 'entryheader', $lang->getMsg('showpool_forum_headline'), array('size' => 30, 'maxlength' => 100));
$form->addElement('textarea', 'entrytext', $lang->getMsg('home_news_text'), array('rows' => 15, 'cols' => 70));
$form->addElement('hidden', 'action', 'new_entry');
$form->addElement('hidden', 'pool_id', $pool->id);
$form->addElement('hidden', 'thread', $thread->id);
$form->addElement('submit', 'entrysubmit', $lang->getMsg('home_news_submit'));
$form->addRule('entryheader', $lang->getMsg('showpool_forum_headline_required'), 'required');
$form->addRule('entrytext', $lang->getMsg('showpool_forum_text_required'), 'required');
// write entry
if ($form->validate()) {
$new_thread = new forumThreads();
$new_thread->pool_id = $pool->id;
$new_thread->title = $form->exportValue('entryheader');
$new_thread->act_date = time();
$new_thread->insert();
$new_thread->find(true);
$new_entry = new forumEntries();
$new_entry->thread_id = $new_thread->id;
$new_entry->text = $form->exportValue('entrytext');
$new_entry->user_id = $this->user->id;
$new_entry->date = $new_thread->act_date;
$new_entry->insert();
$this->switchPage('showpool&pool_id=' . $pool->id . '&msg=msg_forum_entry_made');
}
$this->form = $form;
}
$showthreads = new forumThreads();
$showthreads->pool_id = $pool->id;
$showthreads->find();
while ($showthreads->fetch()) {
$showthreads->fetchLastEntry();
$showthreads->last_entry->fetchUser();
$this->threads[] = array("id" => $showthreads->id, "title" => $showthreads->title, "act_date" => date('j. n. y, H:i', $showthreads->last_entry->date) . ' ' . $lang->getMsg('showpool_forum_lastentry_by') . ' ' . '<a href="./index.php?page=showmember&pool_id=' . $pool->id . '&showmember=' . $showthreads->last_entry->user->id . '">' . $showthreads->last_entry->user->name . '</a>');
}
}
// build userlist
if ($pool->id != 1) {
// assotiativ array with object and detail-flag
if ($pool->isMember($this->user->id)) {
$members = array();
$pool_users = new poolsUser();
$pool_users->pool_id = $pool->id;
$pool_users->wait = 0;
if ($pool_users->find()) {
$detail_id = $params->getParam('showmember');
$count = 1;
while ($pool_users->fetch()) {
if ($pool_users->user_id != $this->user->id) {
$pool_users->fetchUser();
$member = array("obj" => $pool_users->user, "detail" => $pool_users->user->id == $detail_id, "count" => $count, "admin" => $pool->isAdmin($pool_users->user->id));
if ($pool_users->user->name != "") {
$members[] = $member;
}
++$count;
}
}
$this->members = $members;
}
}
}
$this->pool = $pool;
} else {
$this->switchPage('mysite');
}
}
private function process()
{
$this->commonProcess();
$config = services::getService('config');
$lang = services::getService('lang');
$params = services::getService('pageParams');
$categories = services::getService('cats');
if ($params->getParam('res_id')) {
$this->header = $lang->getMsg('resdata_header_change');
$this->is_change = true;
} else {
$this->header = $lang->getMsg('resdata_header_new');
$this->is_change = false;
}
$aItems = $categories->getThisAndBelow(1);
$sJavaScriptArray = sprintf('new Array(%s)', implode(',', array_keys($aItems)));
$this->sJavaScriptArray = $sJavaScriptArray;
if ($_POST['resdata_isbn_submit'] && is_isbn($_POST['resdata_isbn'])) {
foreach ($_POST as $key => $value) {
if ($key != 'page' && $key != 'name' && $key != 'description' && $key != 'resdata_authors') {
$get .= $key . '=' . $value . '&';
}
}
$this->switchPage('resdata&' . $get);
}
// Instantiate the HTML_QuickForm object
$this->form = new formResData('ResDataForm', $params->getParam($res_id), $this->user);
$this->new_res_link = false;
// Try to validate a form
if ($this->form->validate() && $this->form->exportValue('submit')) {
$newres = new resources();
if ($params->getParam('res_id')) {
$newres->get($params->getParam('res_id'));
}
$newres->name = $this->form->exportValue('name');
$newres->description = $this->form->exportValue('description');
$newres->cat = $this->form->exportValue('resdata_cat');
$newres->type = in_array($newres->cat, array_keys($aItems)) ? $this->form->exportValue('type') : 0;
// insert/update in res-maintable
if ($params->getParam('res_id')) {
$newres->update();
} else {
$newres->since = time();
$newres->user_id = $this->user->id;
$newres->insert();
}
$newres->find(true);
// insert/update in attributes-tables
$attr_string = new attributesString();
$attr_string->res_id = $newres->id;
$attr_string->delete();
$attr_select = new attributesSelect();
$attr_select->res_id = $newres->id;
$attr_select->delete();
if ($params->getParam('cat')) {
$cat = $params->getParam('cat');
$attributes = new attributes();
$attributes->category_id = $cat;
if ($attributes->find()) {
while ($attributes->fetch()) {
if ($attributes->type == "string") {
$attr_string = new attributesString();
$attr_string->res_id = $newres->id;
$attr_string->attribute_id = $attributes->id;
// insert
$value = $this->form->exportValue('resdata_' . $attributes->name);
if ($value != "") {
$attr_string->value = $value;
$attr_string->insert();
}
}
if ($attributes->type == "select") {
$values = $this->form->getElementValue('resdata_' . $attributes->name);
if (!is_array($values)) {
$values = array($values);
}
foreach ($values as $value) {
if ($value[0] != 0) {
$attr_string = new attributesSelect();
$attr_string->res_id = $newres->id;
$attr_string->attribute_id = $attributes->id;
// insert
$attr_string->value = $value[0];
$attr_string->insert();
}
}
}
}
}
}
// add res to pools if given
$respools = new poolsResources();
$respools->res_id = $newres->id;
$respools->delete();
$res_pools = $this->form->exportValue('free_pools');
if (is_array($res_pools)) {
foreach ($res_pools as $pool_id => $bool) {
if ($bool) {
$newres->addPool($pool_id);
}
}
}
if ($params->getParam('res_id')) {
$params->addParam('msg', 'msg_data_change_success', 'page');
$this->switchPage('resmanager&function=all');
} else {
$this->form->removeElement('resdata_isbn_submit');
$this->form->freezeForm();
$this->addMsg('msg_res_insert_success');
$this->new_res_link = true;
}
}
if ($_POST['resdata_isbn_submit']) {
$this->form->addRule('name', $lang->getMsg('resdata_form_namenecessary'), 'required');
$this->form->addRule('resdata_cat', $lang->getMsg('resdata_form_catnecessary'), 'required');
}
}
private function process()
{
$this->commonProcess();
$config = services::getService('config');
$lang = services::getService('lang');
$params = services::getService('pageParams');
// for redirection
if ($params->getParam('refer') == 'mysite') {
$this->refer = 'mysite';
} else {
$this->refer = 'showpool';
}
// res_free_page
$userres = new resFetcher();
$userres->_order = "name";
$userres->_user = $this->user->id;
$userres->search();
$this->userres = $userres->getAsArray();
$user_new_pool = new pools();
$user_new_pool->id = $params->getParam('pool_id');
if ($user_new_pool->find(true)) {
$this->user_new_pool = $user_new_pool;
$user_new_pools = new poolsUser();
$user_new_pools->pool_id = $user_new_pool->id;
$user_new_pools->user_id = $this->user->id;
$user_new_pools->find(true);
if ($user_new_pools->res_to_free == 1) {
$this->new_pool = true;
}
if ($params->getParam('no_free_submit')) {
$user_new_pools->res_to_free = 0;
$user_new_pools->update();
// delete res
foreach ($this->userres as $res) {
$del_res = new poolsResources();
$del_res->pool_id = $params->getParam('pool_id');
$del_res->res_id = $res->id;
$del_res->find();
$del_res->delete();
$freed = true;
}
$this->switchPage($this->refer . '&pool_id=' . $user_new_pools->pool_id . '&msg=msg_freeres_alldeleted');
} else {
if ($params->getParam('res_free_submit')) {
// delete res
foreach ($this->userres as $res) {
$del_res = new poolsResources();
$del_res->pool_id = $params->getParam('pool_id');
$del_res->res_id = $res->id;
$del_res->find();
$del_res->delete();
$freed = true;
}
foreach ($_POST as $res_id => $doesnmatter) {
$free_res = new poolsResources();
$free_res->res_id = $res_id;
$free_res->pool_id = $params->getParam('pool_id');
// insert res
if ($doesnmatter == "check") {
if (!$free_res->find()) {
$free_res->insert();
$freed = true;
}
}
}
// set $msg
if ($freed) {
$this->switchPage($this->refer . '&pool_id=' . $user_new_pools->pool_id . '&msg=msg_free_res_success');
}
$user_new_pools->res_to_free = 0;
$user_new_pools->update();
} else {
if (is_array($this->userres)) {
$this->free_res = true;
} else {
$user_new_pools->res_to_free = 0;
$user_new_pools->update();
// switch page with msg
$this->switchPage('showpool&pool_id=' . $user_new_pools->pool_id . '&msg=msg_freeres_nores');
}
}
}
}
}
function formResData($name, $res_id = 0, $user)
{
$lang = services::getService('lang');
$params = services::getService('pageParams');
$cats = services::getService('cats');
$this->form($name);
if ($params->getParam('res_id')) {
$this->addElement('hidden', 'res_id', $params->getParam('res_id'));
// Categories
$this->addElement('select', 'resdata_cat', $lang->getMsg('resdata_form_category'), $cats->getAll(), array('onchange' => 'resdata_cat_change(this.value, document.ResDataForm.res_id.value)'));
} else {
$this->addElement('select', 'resdata_cat', $lang->getMsg('resdata_form_category'), $cats->getAll(), array('onchange' => 'resdata_cat_change_new(this.value)'));
}
$this->addElement('text', 'name', $lang->getMsg('resdata_form_name'), array('size' => 40, 'maxlength' => 255));
$this->addElement('textarea', 'description', $lang->getMsg('resdata_form_description'), array('rows' => 7, 'cols' => 40));
// fetch additional attributes e.g. form-fields for chosen category
if ($params->getParam('cat')) {
$cat = $params->getParam('cat');
$this->addElement('hidden', 'cat', $cat);
$attributes = new attributes();
$attributes->category_id = $cat;
if ($attributes->find()) {
while ($attributes->fetch()) {
if ($attributes->type == "string") {
if ($attributes->name == "isbn") {
$this->addElement('text', 'resdata_' . $attributes->name, $lang->getMsg('resdata_form_' . $attributes->name), array('size' => 30, 'maxlength' => 255));
$this->addElement('submit', 'resdata_' . $attributes->name . '_submit', $lang->getMsg('resdata_form_' . $attributes->name . '_submit'), "asd");
} else {
$this->addElement('text', 'resdata_' . $attributes->name, $lang->getMsg('resdata_form_' . $attributes->name), array('size' => 30, 'maxlength' => 255));
}
}
if ($attributes->type == "select") {
$keys = new attributesSelectKeys();
$keys->attribute_id = $attributes->id;
$keys->find();
$options = array();
$options[0] = "----";
while ($keys->fetch()) {
$options[$keys->key] = $lang->getMsg('resdata_form_select_' . $keys->value);
}
sort($options);
$select_elements = array();
for ($i = 1; $attributes->amount >= $i; ++$i) {
$select_elements[] =& HTML_QuickForm::createElement('select', $i, null, $options);
}
$this->addGroup($select_elements, 'resdata_' . $attributes->name, $lang->getMsg('resdata_form_' . $attributes->name), ' ');
}
}
}
}
$this->addElement('select', 'type', $lang->getMsg('resdata_form_type'), array("2" => $lang->getMsg('resdata_form_type_borrow'), "1" => $lang->getMsg('resdata_form_type_give')));
$free_pool = new poolsUser();
$free_pool->user_id = $user->id;
$free_pool->wait = 0;
$free_pool->find();
$free_pools = array();
while ($free_pool->fetch()) {
$free_pool->fetchPool();
$free_pools[] =& HTML_QuickForm::createElement('checkbox', $free_pool->pool->id, null, ' ' . $free_pool->pool->name, $free_pool->pool->id);
}
$this->addGroup($free_pools, 'free_pools', $lang->getMsg('resdata_form_pools'), '<br>');
$this->addElement('submit', 'submit', $lang->getMsg('resdata_form_submit'));
// rules
if (!$_POST['resdata_isbn_submit']) {
$this->addRule('name', $lang->getMsg('resdata_form_namenecessary'), 'required');
$this->addRule('resdata_cat', $lang->getMsg('resdata_form_catnecessary'), 'required');
}
// presets
if ($params->getParam('resdata_isbn_submit') && is_isbn($params->getParam('resdata_isbn'))) {
$lastletter = 0;
$isbnfound = 0;
$firstletter = substr($params->getParam('resdata_isbn'), 0, 1);
if ($firstletter == 0 || $firstletter == 1) {
$urlendings = array('com', 'co.uk', 'de', 'jp', 'fr', 'ca');
} else {
if ($firstletter == 2) {
$urlendings = array('fr', 'de', 'com', 'co.uk', 'jp', 'ca');
} else {
if ($firstletter == 3) {
$urlendings = array('de', 'com', 'co.uk', 'jp', 'fr', 'ca');
} else {
if ($firstletter == 4) {
$urlendings = array('jp', 'de', 'com', 'co.uk', 'fr', 'ca');
} else {
$urlendings = array('com', 'co.uk', 'de', 'fr', 'ca', 'jp');
}
}
}
}
$lastletters = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 'x');
foreach ($urlendings as $urlending) {
foreach ($lastletters as $lastletter) {
if ($isbnfound == 0) {
$url = "http://ecs.amazonaws." . $urlending . "/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=1WFW5KS6EFZ0M8690ZR2&Operation=ItemLookup&ItemId=" . substr($params->getParam('resdata_isbn'), 0, 9) . $lastletter . "&ResponseGroup=Medium&type=lite&f=xml";
$xml = file_get_contents($url);
if (!strpos($xml, 'is not a valid value for ItemId')) {
$isbnfound = true;
}
}
}
}
$first = strpos($xml, '<Item>') + 6;
$sec = strpos($xml, '</Item>');
$newxml = substr($xml, $first, $sec - $first);
$newxml = unhtmlentities($newxml);
// title
$first = strpos($newxml, '<Title>') + 7;
$sec = strpos($newxml, '</Title>');
$title = substr($newxml, $first, $sec - $first);
// binding
$first = strpos($newxml, '<Binding>') + 9;
$sec = strpos($newxml, '</Binding>');
$binding = substr($newxml, $first, $sec - $first);
// publisher
$first = strpos($newxml, '<Label>') + 7;
$sec = strpos($newxml, '</Label>');
$publisher = substr($newxml, $first, $sec - $first);
// publication date
$first = strpos($newxml, '<PublicationDate>') + 17;
$sec = strpos($newxml, '</PublicationDate>');
$publicationdate = substr($newxml, $first, $sec - $first);
// number of pages
$first = strpos($newxml, '<NumberOfPages>') + 15;
$sec = strpos($newxml, '</NumberOfPages>');
$numberofpages = substr($newxml, $first, $sec - $first);
// author(s)
$authors = array();
while (strstr($newxml, '<Author>')) {
$first = strpos($newxml, '<Author>') + 8;
$sec = strpos($newxml, '</Author>');
$authors[] = substr($newxml, $first, $sec - $first);
$newxml = substr($newxml, $sec + 9);
}
foreach ($authors as $key => $author) {
if ($key != 0) {
$authors_field .= "; ";
}
$authors_field .= $this->changeAuthor($author);
}
// description
$first = strpos($newxml, '<EditorialReviews><EditorialReview><Source>Aus der Amazon.de-Redaktion</Source><Content>') + 88;
$sec = strpos($newxml, '</Content></EditorialReview></EditorialReviews>');
$description = substr($newxml, $first, $sec - $first);
$description = substr($description, 0, strrpos($description, '--'));
// name
if ($authors_field) {
$name = $authors_field . ": " . $title;
} else {
$name = $title;
}
$this->setDefaults(array('resdata_title' => $title, 'name' => $name, 'description' => $description, 'resdata_authors' => $authors_field, 'resdata_binding' => $binding, 'resdata_number_of_pages' => $numberofpages, 'resdata_publication_date' => $publicationdate, 'resdata_publisher' => $publisher, 'resdata_isbn' => $params->getParam('resdata_isbn')));
}
if ($params->getParam('res_id')) {
$free_pool = new poolsResources();
$free_pool->res_id = $params->getParam('res_id');
$free_pool->find();
$free_pools_presets = array();
while ($free_pool->fetch()) {
$free_pools_presets[$free_pool->pool_id] = 1;
}
$changeform_res = new resources();
$changeform_res->get($params->getParam('res_id'));
$this->setDefaults(array('name' => $changeform_res->name, 'type' => $changeform_res->type, 'description' => $changeform_res->description, 'resdata_cat' => $changeform_res->cat, 'free_pools' => $free_pools_presets, 'public' => $changeform_res->is_public));
// presets for additional fields
if ($params->getParam('cat')) {
$cat = $params->getParam('cat');
$this->setDefaults(array('resdata_cat' => $cat));
$attributes = new attributes();
$attributes->category_id = $cat;
if ($attributes->find()) {
while ($attributes->fetch()) {
if ($attributes->type == "string") {
$attr_string_presets = new attributesString();
$attr_string_presets->res_id = $params->getParam('res_id');
$attr_string_presets->attribute_id = $attributes->id;
$attr_string_presets->find(true);
$this->setDefaults(array('resdata_' . $attributes->name => $attr_string_presets->value));
}
if ($attributes->type == "select") {
$attr_select_presets = new attributesSelect();
$attr_select_presets->res_id = $params->getParam('res_id');
$attr_select_presets->attribute_id = $attributes->id;
$attr_select_presets->find();
$i = 1;
while ($attr_select_presets->fetch()) {
$this->setDefaults(array("resdata_" . $attributes->name . "[" . $i . "]" => $attr_select_presets->value));
++$i;
}
}
}
}
}
} else {
if (isset($pool)) {
$free_pools_presets[$pool->id] = 1;
$this->setDefaults(array('type' => 2, 'public' => 0, 'free_pools' => $free_pools_presets));
}
}
if ($params->getParam('cat')) {
$this->setDefaults(array('resdata_cat' => $params->getParam('cat')));
}
}
function addPool($pool_id)
{
// add to relations-table
$new_membership = new poolsResources();
$new_membership->res_id = $this->id;
$new_membership->pool_id = $pool_id;
if (!$new_membership->insert()) {
$new_membership->update();
}
}
function addRes($res_id)
{
$add_res = new poolsResources();
$add_res->res_id = $res_id;
$add_res->pool_id = $this->id;
$add_res->insert();
}
