* Copyright (C) 2003 Jean-Louis Bergamo * Copyright (C) 2004-2011 Laurent Destailleur * Copyright (C) 2005-2017 Regis Houssin * Copyright (C) 2013 Florian Henry * Copyright (C) 2015 Alexandre Spangaro * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ /** * \file htdocs/adherents/type.php * \ingroup member * \brief Member's type setup */ require '../main.inc.php'; require_once DOL_DOCUMENT_ROOT.'/core/lib/member.lib.php'; require_once DOL_DOCUMENT_ROOT.'/adherents/class/adherent.class.php'; require_once DOL_DOCUMENT_ROOT.'/adherents/class/adherent_type.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; $langs->load("members"); $rowid = GETPOST('rowid','int'); $action = GETPOST('action','alpha'); $cancel = GETPOST('cancel','alpha'); $search_lastname = GETPOST('search_lastname','alpha'); $search_login = GETPOST('search_login','alpha'); $search_email = GETPOST('search_email','alpha'); $type = GETPOST('type','alpha'); $status = GETPOST('status','alpha'); $limit = GETPOST("limit")?GETPOST("limit","int"):$conf->liste_limit; $sortfield = GETPOST("sortfield",'alpha'); $sortorder = GETPOST("sortorder",'alpha'); $page = GETPOST("page",'int'); if ($page == -1) { $page = 0; } $offset = $limit * $page ; $pageprev = $page - 1; $pagenext = $page + 1; if (! $sortorder) { $sortorder="DESC"; } if (! $sortfield) { $sortfield="d.lastname"; } $label=GETPOST("label","alpha"); $subscription=GETPOST("subscription","int"); $vote=GETPOST("vote","int"); $comment=GETPOST("comment"); $mail_valid=GETPOST("mail_valid"); // Security check $result=restrictedArea($user,'adherent',$rowid,'adherent_type'); $extrafields = new ExtraFields($db); // fetch optionals attributes and labels $extralabels=$extrafields->fetch_name_optionals_label('adherent_type'); if (GETPOST("button_removefilter_x") || GETPOST("button_removefilter_x") || GETPOST("button_removefilter")) // All tests are required to be compatible with all browsers { $search_lastname=""; $search_login=""; $search_email=""; $type=""; $sall=""; } // Initialize technical object to manage hooks of thirdparties. Note that conf->hooks_modules contains array array $hookmanager->initHooks(array('membertypecard','globalcard')); /* * Actions */ if ($action == 'add' && $user->rights->adherent->configurer) { if (! $cancel) { $object = new AdherentType($db); $object->label = trim($label); $object->subscription = (int) trim($subscription); $object->note = trim($comment); $object->mail_valid = (boolean) trim($mail_valid); $object->vote = (boolean) trim($vote); // Fill array 'array_options' with data from add form $ret = $extrafields->setOptionalsFromPost($extralabels,$object); if ($ret < 0) $error++; if ($object->label) { $id=$object->create($user); if ($id > 0) { header("Location: ".$_SERVER["PHP_SELF"]); exit; } else { $mesg=$object->error; $action = 'create'; } } else { $mesg=$langs->trans("ErrorFieldRequired",$langs->transnoentities("Label")); $action = 'create'; } } } if ($action == 'update' && $user->rights->adherent->configurer) { if (! $cancel) { $object = new AdherentType($db); $object->id = $rowid; $object->label = trim($label); $object->subscription = (int) trim($subscription); $object->note = trim($comment); $object->mail_valid = (boolean) trim($mail_valid); $object->vote = (boolean) trim($vote); // Fill array 'array_options' with data from add form $ret = $extrafields->setOptionalsFromPost($extralabels,$object); if ($ret < 0) $error++; $object->update($user); header("Location: ".$_SERVER["PHP_SELF"]."?rowid=".$_POST["rowid"]); exit; } } if ($action == 'delete' && $user->rights->adherent->configurer) { $object = new AdherentType($db); $object->delete($rowid); header("Location: ".$_SERVER["PHP_SELF"]); exit; } /* * View */ llxHeader('',$langs->trans("MembersTypeSetup"),'EN:Module_Foundations|FR:Module_Adhérents|ES:Módulo_Miembros'); $form=new Form($db); // List of members type if (! $rowid && $action != 'create' && $action != 'edit') { //dol_fiche_head(''); $sql = "SELECT d.rowid, d.libelle as label, d.subscription, d.vote"; $sql.= " FROM ".MAIN_DB_PREFIX."adherent_type as d"; $sql.= " WHERE d.entity IN (".getEntity().")"; $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $nbtotalofrecords = $num; $i = 0; $param = ''; print '
'; if ($optioncss != '') print ''; print ''; print ''; print ''; print ''; print ''; print ''; print_barre_liste($langs->trans("MembersTypes"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'title_generic.png', 0, '', '', $limit); $moreforfilter = ''; print '
'; print ''."\n"; print ''; print ''; print ''; print ''; print ''; print ''; print "\n"; while ($i < $num) { $objp = $db->fetch_object($result); print ''; print ''; print ''; print ''; print ''; if ($user->rights->adherent->configurer) print ''; else print ''; print ""; $i++; } print "
'.$langs->trans("Ref").''.$langs->trans("Label").''.$langs->trans("SubscriptionRequired").''.$langs->trans("VoteAllowed").' 
'.img_object($langs->trans("ShowType"),'group').' '.$objp->rowid.''.dol_escape_htmltag($objp->label).''.yn($objp->subscription).''.yn($objp->vote).'rowid.'">'.img_edit().' 
"; print '
'; print '
'; } else { dol_print_error($db); } } /* ************************************************************************** */ /* */ /* Creation mode */ /* */ /* ************************************************************************** */ if ($action == 'create') { $object = new AdherentType($db); print load_fiche_titre($langs->trans("NewMemberType")); print '
'; print ''; print ''; dol_fiche_head(''); print ''; print ''; print ''; print ''; print ''; print ''; print ''; // Other attributes $parameters=array(); $reshook=$hookmanager->executeHooks('formObjectOptions',$parameters,$act,$action); // Note that $action and $object may have been modified by hook if (empty($reshook) && ! empty($extrafields->attribute_label)) { print $object->showOptionals($extrafields,'edit'); } print ''; print "
'.$langs->trans("Label").'
'.$langs->trans("SubscriptionRequired").''; print $form->selectyesno("subscription",1,1); print '
'.$langs->trans("VoteAllowed").''; print $form->selectyesno("vote",0,1); print '
'.$langs->trans("Description").''; print '
'.$langs->trans("WelcomeEMail").''; require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php'; $doleditor=new DolEditor('mail_valid',$object->mail_valid,'',280,'dolibarr_notes','',false,true,$conf->fckeditor->enabled,15,'90%'); $doleditor->Create(); print '
\n"; dol_fiche_end(); print '
'; print ''; print '     '; print ''; print '
'; print "
\n"; } /* ************************************************************************** */ /* */ /* View mode */ /* */ /* ************************************************************************** */ if ($rowid > 0) { if ($action != 'edit') { $object = new AdherentType($db); $object->fetch($rowid); $object->fetch_optionals($rowid,$extralabels); $head = member_type_prepare_head($object); dol_fiche_head($head, 'card', $langs->trans("MemberType"), -1, 'group'); $linkback = ''.$langs->trans("BackToList").''; dol_banner_tab($object, 'rowid', $linkback); print '
'; print '
'; print ''; print ''; print ''; print '"; print '"; // Other attributes $parameters=array(); $reshook=$hookmanager->executeHooks('formObjectOptions',$parameters,$act,$action); // Note that $action and $object may have been modified by hook if (empty($reshook) && ! empty($extrafields->attribute_label)) { // View extrafields print $object->showOptionals($extrafields); } print '
'.$langs->trans("SubscriptionRequired").''; print yn($object->subscription); print '
'.$langs->trans("VoteAllowed").''; print yn($object->vote); print '
'.$langs->trans("Description").''; print nl2br($object->note)."
'.$langs->trans("WelcomeEMail").''; print nl2br($object->mail_valid)."
'; print '
'; dol_fiche_end(); /* * Hotbar */ print '
'; // Edit if ($user->rights->adherent->configurer) { print ''; } // Add print ''; // Delete if ($user->rights->adherent->configurer) { print ''; } print "
"; // Show list of members (nearly same code than in page list.php) $membertypestatic=new AdherentType($db); $now=dol_now(); $sql = "SELECT d.rowid, d.login, d.firstname, d.lastname, d.societe, "; $sql.= " d.datefin,"; $sql.= " d.email, d.fk_adherent_type as type_id, d.morphy, d.statut,"; $sql.= " t.libelle as type, t.subscription"; $sql.= " FROM ".MAIN_DB_PREFIX."adherent as d, ".MAIN_DB_PREFIX."adherent_type as t"; $sql.= " WHERE d.fk_adherent_type = t.rowid "; $sql.= " AND d.entity IN (".getEntity().")"; $sql.= " AND t.rowid = ".$object->id; if ($sall) { $sql.=natural_search(array("f.firstname","d.lastname","d.societe","d.email","d.login","d.address","d.town","d.note_public","d.note_private"), $sall); } if ($status != '') { $sql.= " AND d.statut IN (".$status.")"; // Peut valoir un nombre ou liste de nombre separes par virgules } if ($action == 'search') { if (GETPOST('search')) { $sql.= natural_search(array("d.firstname","d.lastname"), GETPOST('search')); } } if (! empty($search_lastname)) { $sql.= natural_search(array("d.firstname","d.lastname"), $search_lastname); } if (! empty($search_login)) { $sql.= natural_search("d.login", $search_login); } if (! empty($search_email)) { $sql.= natural_search("d.email", $search_email); } if ($filter == 'uptodate') { $sql.=" AND datefin >= '".$db->idate($now)."'"; } if ($filter == 'outofdate') { $sql.=" AND datefin < '".$db->idate($now)."'"; } // Count total nb of records $nbtotalofrecords = ''; if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) { $resql = $db->query($sql); if ($resql) $nbtotalofrecords = $db->num_rows($result); else dol_print_error($db); } // Add order and limit $sql.= " ".$db->order($sortfield,$sortorder); $sql.= " ".$db->plimit($conf->liste_limit+1, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $titre=$langs->trans("MembersList"); if ($status != '') { if ($status == '-1,1') { $titre=$langs->trans("MembersListQualified"); } else if ($status == '-1') { $titre=$langs->trans("MembersListToValid"); } else if ($status == '1' && ! $filter) { $titre=$langs->trans("MembersListValid"); } else if ($status == '1' && $filter=='uptodate') { $titre=$langs->trans("MembersListUpToDate"); } else if ($status == '1' && $filter=='outofdate') { $titre=$langs->trans("MembersListNotUpToDate"); } else if ($status == '0') { $titre=$langs->trans("MembersListResiliated"); } } elseif ($action == 'search') { $titre=$langs->trans("MembersListQualified"); } if ($type > 0) { $membertype=new AdherentType($db); $result=$membertype->fetch($type); $titre.=" (".$membertype->label.")"; } $param="&rowid=".$rowid; if (! empty($status)) $param.="&status=".$status; if (! empty($search_lastname)) $param.="&search_lastname=".$search_lastname; if (! empty($search_firstname)) $param.="&search_firstname=".$search_firstname; if (! empty($search_login)) $param.="&search_login=".$search_login; if (! empty($search_email)) $param.="&search_email=".$search_email; if (! empty($filter)) $param.="&filter=".$filter; if ($sall) { print $langs->trans("Filter")." (".$langs->trans("Lastname").", ".$langs->trans("Firstname").", ".$langs->trans("EMail").", ".$langs->trans("Address")." ".$langs->trans("or")." ".$langs->trans("Town")."): ".$sall; } print '
'; print ''; print '
'; print_barre_liste('',$page,$_SERVER["PHP_SELF"],$param,$sortfield,$sortorder,'',$num,$nbtotalofrecords); $moreforfilter = ''; print '
'; print ''."\n"; print ''; print_liste_field_titre($langs->trans("Name")." / ".$langs->trans("Company"),$_SERVER["PHP_SELF"],"d.lastname",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Login"),$_SERVER["PHP_SELF"],"d.login",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Nature"),$_SERVER["PHP_SELF"],"d.morphy",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("EMail"),$_SERVER["PHP_SELF"],"d.email",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("Status"),$_SERVER["PHP_SELF"],"d.statut,d.datefin",$param,"","",$sortfield,$sortorder); print_liste_field_titre($langs->trans("EndSubscription"),$_SERVER["PHP_SELF"],"d.datefin",$param,"",'align="center"',$sortfield,$sortorder); print_liste_field_titre($langs->trans("Action"),$_SERVER["PHP_SELF"],"",$param,"",'width="60" align="center"',$sortfield,$sortorder); print "\n"; // Lignes des champs de filtre print ''; print ''; print ''; print ''; print ''; print ''; print ''; print "\n"; while ($i < $num && $i < $conf->liste_limit) { $objp = $db->fetch_object($resql); $datefin=$db->jdate($objp->datefin); $adh=new Adherent($db); $adh->lastname=$objp->lastname; $adh->firstname=$objp->firstname; // Lastname print ''; if ($objp->societe != '') { print ''."\n"; } else { print ''."\n"; } // Login print "\n"; // Type /*print ''; */ // Moral/Physique print "\n"; // EMail print "\n"; // Statut print '"; // Date end subscription if ($datefin) { print ''; } else { print ''; } // Actions print '"; print "\n"; $i++; } print "
'; print ''; print ' '; print ' '; print ''; print '  '; print ''; print '
'.img_object($langs->trans("ShowMember"),"user").' '.$adh->getFullName($langs,0,-1,20).' / '.dol_trunc($objp->societe,12).''.img_object($langs->trans("ShowMember"),"user").' '.$adh->getFullName($langs,0,-1,32).'".$objp->login."'; $membertypestatic->id=$objp->type_id; $membertypestatic->label=$objp->type; print $membertypestatic->getNomUrl(1,12); print '".$adh->getmorphylib($objp->morphy)."".dol_print_email($objp->email,0,0,1)."'; print $adh->LibStatut($objp->statut,$objp->subscription,$datefin,2); print "'; if ($datefin < dol_now() && $objp->statut > 0) { print dol_print_date($datefin,'day')." ".img_warning($langs->trans("SubscriptionLate")); } else { print dol_print_date($datefin,'day'); } print ''; if ($objp->subscription == 'yes') { print $langs->trans("SubscriptionNotReceived"); if ($objp->statut > 0) print " ".img_warning(); } else { print ' '; } print ''; if ($user->rights->adherent->creer) { print ''.img_edit().''; } print ' '; if ($user->rights->adherent->supprimer) { print ''.img_picto($langs->trans("Resiliate"),'disable.png').''; } print "
\n"; print '
'; print '
'; if ($num > $conf->liste_limit) { print_barre_liste('',$page,$_SERVER["PHP_SELF"],$param,$sortfield,$sortorder,'',$num,$nbtotalofrecords,''); } } else { dol_print_error($db); } } /* ************************************************************************** */ /* */ /* Edition mode */ /* */ /* ************************************************************************** */ if ($action == 'edit') { $object = new AdherentType($db); $object->id = $rowid; $object->fetch($rowid); $object->fetch_optionals($rowid,$extralabels); $head = member_type_prepare_head($object); print '
'; print ''; print ''; print ''; dol_fiche_head($head, 'card', $langs->trans("MemberType"), 0, 'group'); print ''; print ''; print ''; print ''; print ''; print ''; print '"; // Other attributes $parameters=array(); $reshook=$hookmanager->executeHooks('formObjectOptions',$parameters,$act,$action); // Note that $action and $object may have been modified by hook print '
'.$langs->trans("Ref").''.$object->id.'
'.$langs->trans("Label").'
'.$langs->trans("SubscriptionRequired").''; print $form->selectyesno("subscription",$object->subscription,1); print '
'.$langs->trans("VoteAllowed").''; print $form->selectyesno("vote",$object->vote,1); print '
'.$langs->trans("Description").''; print '
'.$langs->trans("WelcomeEMail").''; require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php'; $doleditor=new DolEditor('mail_valid',$object->mail_valid,'',280,'dolibarr_notes','',false,true,$conf->fckeditor->enabled,15,'90%'); $doleditor->Create(); print "
'; // Extra field if (empty($reshook) && ! empty($extrafields->attribute_label)) { print '

'; foreach($extrafields->attribute_label as $key=>$label) { if (isset($_POST["options_" . $key])) { if (is_array($_POST["options_" . $key])) { // $_POST["options"] is an array but following code expects a comma separated string $value = implode(",", $_POST["options_" . $key]); } else { $value = $_POST["options_" . $key]; } } else { $value = $adht->array_options["options_" . $key]; } print '\n"; } print '
'.$label.''; print $extrafields->showInputField($key,$value); print "


'; } dol_fiche_end(); print '
'; print ''; print '     '; print ''; print '
'; print "
"; } } llxFooter(); $db->close();