$loanstatic->id = $links[$key]['url_id']; if (preg_match('/^\\((.*)\\)$/i', $links[$key]['label'], $reg)) { if ($reg[1] == 'loan') { $reg[1] = 'Loan'; } $loanstatic->label = $langs->trans($reg[1]); } else { $loanstatic->label = $links[$key]['label']; } $loanstatic->ref = $loanstatic->label; print $loanstatic->getLinkUrl(1, 16); } else { if ($links[$key]['type'] == 'member') { $memberstatic->id = $links[$key]['url_id']; $memberstatic->ref = $links[$key]['label']; print $memberstatic->getNomUrl(1, 16, 'card'); } } } } } } print '</td>'; // Amount if ($objp->amount < 0) { print '<td align="right" class="nowrap">' . price($objp->amount * -1) . '</td><td> </td>' . "\n"; $total_deb += $objp->amount; } else { print '<td> </td><td align="right" class="nowrap"> ' . price($objp->amount) . '</td>' . "\n"; $total_cred += $objp->amount; }
// Sales representative include(DOL_DOCUMENT_ROOT.'/societe/tpl/linesalesrepresentative.tpl.php'); // Module Adherent if ($conf->adherent->enabled) { $langs->load("members"); print '<tr><td width="25%" valign="top">'.$langs->trans("LinkedToDolibarrMember").'</td>'; print '<td colspan="3">'; $adh=new Adherent($db); $result=$adh->fetch('','',$object->id); if ($result > 0) { $adh->ref=$adh->getFullName($langs); print $adh->getNomUrl(1); } else { print $langs->trans("UserNotLinkedToMember"); } print '</td>'; print "</tr>\n"; } print '</table>'; dol_fiche_end(); /*
print "</tr>\n"; $var = True; $i = 0; while ($i < $num && $i < $conf->liste_limit) { $objp = $db->fetch_object($resql); $datefin = $db->jdate($objp->datefin); $memberstatic->id = $objp->rowid; $memberstatic->ref = $objp->rowid; $memberstatic->lastname = $objp->lastname; $memberstatic->firstname = $objp->firstname; $companyname = $objp->company; $var = !$var; print "<tr " . $bc[$var] . ">"; // Ref print "<td>"; print $memberstatic->getNomUrl(1); print "</td>\n"; // Lastname print "<td><a href=\"card.php?rowid={$objp->rowid}\">"; print !empty($objp->lastname) || !empty($objp->firstname) ? dol_trunc($memberstatic->getFullName($langs)) : ''; print (!empty($objp->lastname) || !empty($objp->firstname)) && !empty($companyname) ? ' / ' : ''; print !empty($companyname) ? dol_trunc($companyname, 32) : ''; print "</a></td>\n"; // Login print "<td>" . $objp->login . "</td>\n"; // Type $membertypestatic->id = $objp->type_id; $membertypestatic->libelle = $objp->type; print '<td class="nowrap">'; print $membertypestatic->getNomUrl(1, 32); print '</td>';
/** * Assign custom values for canvas (for example into this->tpl to be used by templates) * * @param string $action Type of action * @param string $id Id of object * @param string $ref Ref of object * @return void */ function assign_values(&$action, $id = 0, $ref = '') { global $conf, $langs, $user, $mysoc, $canvas; global $form, $formadmin, $formcompany; if ($action == 'add' || $action == 'update') { $this->assign_post($action); } if ($_GET["type"] == 'f') { $this->object->fournisseur = 1; } if ($_GET["type"] == 'c') { $this->object->client = 1; } if ($_GET["type"] == 'p') { $this->object->client = 2; } if ($_GET["type"] == 'cp') { $this->object->client = 3; } if ($_REQUEST["private"] == 1) { $this->object->particulier = 1; } foreach ($this->object as $key => $value) { $this->tpl[$key] = $value; } $this->tpl['error'] = get_htmloutput_errors($this->object->error, $this->object->errors); if (is_array($GLOBALS['errors'])) { $this->tpl['error'] = get_htmloutput_mesg('', $GLOBALS['errors'], 'error'); } if ($action == 'create') { if ($conf->use_javascript_ajax) { $this->tpl['ajax_selecttype'] = "\n" . '<script type="text/javascript" language="javascript"> $(document).ready(function () { $("#radiocompany").click(function() { document.formsoc.action.value="create"; document.formsoc.canvas.value="company"; document.formsoc.private.value=0; document.formsoc.submit(); }); $("#radioprivate").click(function() { document.formsoc.action.value="create"; document.formsoc.canvas.value="individual"; document.formsoc.private.value=1; document.formsoc.submit(); }); }); </script>' . "\n"; } } if ($action == 'create' || $action == 'edit') { if ($conf->use_javascript_ajax) { $this->tpl['ajax_selectcountry'] = "\n" . '<script type="text/javascript" language="javascript"> $(document).ready(function () { $("#selectcountry_id").change(function() { document.formsoc.action.value="' . $action . '"; document.formsoc.canvas.value="' . $canvas . '"; document.formsoc.submit(); }); }) </script>' . "\n"; } // Load object modCodeClient $module = !empty($conf->global->SOCIETE_CODECLIENT_ADDON) ? $conf->global->SOCIETE_CODECLIENT_ADDON : 'mod_codeclient_leopard'; if (substr($module, 0, 15) == 'mod_codeclient_' && substr($module, -3) == 'php') { $module = substr($module, 0, dol_strlen($module) - 4); } $dirsociete = array_merge(array('/core/modules/societe/'), $conf->modules_parts['societe']); foreach ($dirsociete as $dirroot) { $res = dol_include_once($dirroot . $module . '.php'); if ($res) { break; } } $modCodeClient = new $module($db); $this->tpl['auto_customercode'] = $modCodeClient->code_auto; // We verified if the tag prefix is used if ($modCodeClient->code_auto) { $this->tpl['prefix_customercode'] = $modCodeClient->verif_prefixIsUsed(); } // TODO create a function $this->tpl['select_customertype'] = '<select class="flat" name="client">'; $this->tpl['select_customertype'] .= '<option value="2"' . ($this->object->client == 2 ? ' selected="selected"' : '') . '>' . $langs->trans('Prospect') . '</option>'; $this->tpl['select_customertype'] .= '<option value="3"' . ($this->object->client == 3 ? ' selected="selected"' : '') . '>' . $langs->trans('ProspectCustomer') . '</option>'; $this->tpl['select_customertype'] .= '<option value="1"' . ($this->object->client == 1 ? ' selected="selected"' : '') . '>' . $langs->trans('Customer') . '</option>'; $this->tpl['select_customertype'] .= '<option value="0"' . ($this->object->client == 0 ? ' selected="selected"' : '') . '>' . $langs->trans('NorProspectNorCustomer') . '</option>'; $this->tpl['select_customertype'] .= '</select>'; // Customer $this->tpl['customercode'] = $this->object->code_client; if ((!$this->object->code_client || $this->object->code_client == -1) && $modCodeClient->code_auto) { $this->tpl['customercode'] = $modCodeClient->getNextValue($this->object, 0); } $this->tpl['ismodifiable_customercode'] = $this->object->codeclient_modifiable(); $s = $modCodeClient->getToolTip($langs, $this->object, 0); $this->tpl['help_customercode'] = $form->textwithpicto('', $s, 1); if (!empty($conf->fournisseur->enabled)) { $this->tpl['supplier_enabled'] = 1; // Load object modCodeFournisseur $module = $conf->global->SOCIETE_CODECLIENT_ADDON; if (substr($module, 0, 15) == 'mod_codeclient_' && substr($module, -3) == 'php') { $module = substr($module, 0, dol_strlen($module) - 4); } $dirsociete = array_merge(array('/core/modules/societe/'), $conf->modules_parts['societe']); foreach ($dirsociete as $dirroot) { $res = dol_include_once($dirroot . $module . '.php'); if ($res) { break; } } $modCodeFournisseur = new $module(); $this->tpl['auto_suppliercode'] = $modCodeFournisseur->code_auto; // We verified if the tag prefix is used if ($modCodeFournisseur->code_auto) { $this->tpl['prefix_suppliercode'] = $modCodeFournisseur->verif_prefixIsUsed(); } // Supplier $this->tpl['yn_supplier'] = $form->selectyesno("fournisseur", $this->object->fournisseur, 1); $this->tpl['suppliercode'] = $this->object->code_fournisseur; if ((!$this->object->code_fournisseur || $this->object->code_fournisseur == -1) && $modCodeFournisseur->code_auto) { $this->tpl['suppliercode'] = $modCodeFournisseur->getNextValue($this->object, 1); } $this->tpl['ismodifiable_suppliercode'] = $this->object->codefournisseur_modifiable(); $s = $modCodeFournisseur->getToolTip($langs, $this->object, 1); $this->tpl['help_suppliercode'] = $form->textwithpicto('', $s, 1); $this->object->LoadSupplierCateg(); $this->tpl['suppliercategory'] = $this->object->SupplierCategories; } // Zip $this->tpl['select_zip'] = $formcompany->select_ziptown($this->object->zip, 'zipcode', array('town', 'selectcountry_id', 'state_id'), 6); // Town $this->tpl['select_town'] = $formcompany->select_ziptown($this->object->town, 'town', array('zipcode', 'selectcountry_id', 'state_id')); // Country $this->object->country_id = $this->object->country_id ? $this->object->country_id : $mysoc->country_id; $this->object->country_code = $this->object->country_code ? $this->object->country_code : $mysoc->country_code; $this->tpl['select_country'] = $form->select_country($this->object->country_id, 'country_id'); $countrynotdefined = $langs->trans("ErrorSetACountryFirst") . ' (' . $langs->trans("SeeAbove") . ')'; if ($user->admin) { $this->tpl['info_admin'] = info_admin($langs->trans("YouCanChangeValuesForThisListFromDictionarySetup"), 1); } // State if ($this->object->country_id) { $this->tpl['select_state'] = $formcompany->select_state($this->object->state_id, $this->object->country_code); } else { $this->tpl['select_state'] = $countrynotdefined; } // Language if (!empty($conf->global->MAIN_MULTILANGS)) { $this->tpl['select_lang'] = $formadmin->select_language($this->object->default_lang ? $this->object->default_lang : $conf->global->MAIN_LANG_DEFAULT, 'default_lang', 0, 0, 1); } // VAT $this->tpl['yn_assujtva'] = $form->selectyesno('assujtva_value', $this->tpl['tva_assuj'], 1); // Assujeti par defaut en creation // Select users $this->tpl['select_users'] = $form->select_dolusers($this->object->commercial_id, 'commercial_id', 1); // Local Tax // TODO mettre dans une classe propre au pays if ($mysoc->country_code == 'ES') { $this->tpl['localtax'] = ''; if ($mysoc->localtax1_assuj == "1" && $mysoc->localtax2_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax1IsUsedES") . '</td><td>'; $this->tpl['localtax'] .= $form->selectyesno('localtax1assuj_value', $this->object->localtax1_assuj, 1); $this->tpl['localtax'] .= '</td><td>' . $langs->trans("LocalTax2IsUsedES") . '</td><td>'; $this->tpl['localtax'] .= $form->selectyesno('localtax2assuj_value', $this->object->localtax1_assuj, 1); $this->tpl['localtax'] .= '</td></tr>'; } elseif ($mysoc->localtax1_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax1IsUsedES") . '</td><td colspan="3">'; $this->tpl['localtax'] .= $form->selectyesno('localtax1assuj_value', $this->object->localtax1_assuj, 1); $this->tpl['localtax'] .= '</td><tr>'; } elseif ($mysoc->localtax2_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax2IsUsedES") . '</td><td colspan="3">'; $this->tpl['localtax'] .= $form->selectyesno('localtax2assuj_value', $this->object->localtax1_assuj, 1); $this->tpl['localtax'] .= '</td><tr>'; } } } else { $head = societe_prepare_head($this->object); $this->tpl['showhead'] = dol_get_fiche_head($head, 'card', '', 0, 'company'); $this->tpl['showend'] = dol_get_fiche_end(); $this->tpl['showrefnav'] = $form->showrefnav($this->object, 'socid', '', $user->societe_id ? 0 : 1, 'rowid', 'nom'); $this->tpl['checkcustomercode'] = $this->object->check_codeclient(); $this->tpl['checksuppliercode'] = $this->object->check_codefournisseur(); $this->tpl['address'] = dol_nl2br($this->object->address); $img = picto_from_langcode($this->object->country_code); if ($this->object->isInEEC()) { $this->tpl['country'] = $form->textwithpicto(($img ? $img . ' ' : '') . $this->object->country, $langs->trans("CountryIsInEEC"), 1, 0); } $this->tpl['country'] = ($img ? $img . ' ' : '') . $this->object->country; $this->tpl['phone'] = dol_print_phone($this->object->phone, $this->object->country_code, 0, $this->object->id, 'AC_TEL'); $this->tpl['fax'] = dol_print_phone($this->object->fax, $this->object->country_code, 0, $this->object->id, 'AC_FAX'); $this->tpl['email'] = dol_print_email($this->object->email, 0, $this->object->id, 'AC_EMAIL'); $this->tpl['url'] = dol_print_url($this->object->url); $this->tpl['tva_assuj'] = yn($this->object->tva_assuj); // Third party type $arr = $formcompany->typent_array(1); $this->tpl['typent'] = $arr[$this->object->typent_code]; if (!empty($conf->global->MAIN_MULTILANGS)) { require_once DOL_DOCUMENT_ROOT . '/core/lib/functions2.lib.php'; //$s=picto_from_langcode($this->default_lang); //print ($s?$s.' ':''); $langs->load("languages"); $this->tpl['default_lang'] = $this->default_lang ? $langs->trans('Language_' . $this->object->default_lang) : ''; } $this->tpl['image_edit'] = img_edit(); $this->tpl['display_rib'] = $this->object->display_rib(); // Sales representatives $this->tpl['sales_representatives'] = ''; $listsalesrepresentatives = $this->object->getSalesRepresentatives($user); $nbofsalesrepresentative = count($listsalesrepresentatives); if ($nbofsalesrepresentative > 3) { $this->tpl['sales_representatives'] .= '<a href="' . DOL_URL_ROOT . '/societe/commerciaux.php?socid=' . $this->object->id . '">'; $this->tpl['sales_representatives'] .= $nbofsalesrepresentative; $this->tpl['sales_representatives'] .= '</a>'; } else { if ($nbofsalesrepresentative > 0) { $userstatic = new User($this->db); $i = 0; foreach ($listsalesrepresentatives as $val) { $userstatic->id = $val['id']; $userstatic->lastname = $val['name']; $userstatic->firstname = $val['firstname']; $this->tpl['sales_representatives'] .= $userstatic->getNomUrl(1); $i++; if ($i < $nbofsalesrepresentative) { $this->tpl['sales_representatives'] .= ', '; } } } else { $this->tpl['sales_representatives'] .= $langs->trans("NoSalesRepresentativeAffected"); } } // Linked member if (!empty($conf->adherent->enabled)) { $langs->load("members"); $adh = new Adherent($this->db); $result = $adh->fetch('', '', $this->object->id); if ($result > 0) { $adh->ref = $adh->getFullName($langs); $this->tpl['linked_member'] = $adh->getNomUrl(1); } else { $this->tpl['linked_member'] = $langs->trans("ThirdpartyNotLinkedToMember"); } } // Local Tax // TODO mettre dans une classe propre au pays if ($mysoc->country_code == 'ES') { $this->tpl['localtax'] = ''; if ($mysoc->localtax1_assuj == "1" && $mysoc->localtax2_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax1IsUsedES") . '</td>'; $this->tpl['localtax'] .= '<td>' . yn($this->object->localtax1_assuj) . '</td>'; $this->tpl['localtax'] .= '<td>' . $langs->trans("LocalTax2IsUsedES") . '</td>'; $this->tpl['localtax'] .= '<td>' . yn($this->object->localtax2_assuj) . '</td></tr>'; } elseif ($mysoc->localtax1_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax1IsUsedES") . '</td>'; $this->tpl['localtax'] .= '<td colspan="3">' . yn($this->object->localtax1_assuj) . '</td></tr>'; } elseif ($mysoc->localtax2_assuj == "1") { $this->tpl['localtax'] .= '<tr><td>' . $langs->trans("LocalTax2IsUsedES") . '</td>'; $this->tpl['localtax'] .= '<td colspan="3">' . yn($this->object->localtax2_assuj) . '</td></tr>'; } } } }
/** * Load data into info_box_contents array to show array later. * * @param int $max Maximum number of records to load * @return void */ function loadBox($max = 5) { global $user, $langs, $db, $conf; $langs->load("boxes"); $this->max = $max; include_once DOL_DOCUMENT_ROOT . '/adherents/class/adherent.class.php'; $memberstatic = new Adherent($db); $this->info_box_head = array('text' => $langs->trans("BoxTitleLastModifiedMembers", $max)); if ($user->rights->adherent->lire) { $sql = "SELECT a.rowid, a.lastname, a.firstname, a.societe as company, a.fk_soc,"; $sql .= " a.datec, a.tms, a.statut as status, a.datefin as date_end_subscription,"; $sql .= " t.cotisation"; $sql .= " FROM " . MAIN_DB_PREFIX . "adherent as a, " . MAIN_DB_PREFIX . "adherent_type as t"; $sql .= " WHERE a.entity = " . $conf->entity; $sql .= " AND a.fk_adherent_type = t.rowid"; $sql .= " ORDER BY a.tms DESC"; $sql .= $db->plimit($max, 0); $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $line = 0; while ($line < $num) { $objp = $db->fetch_object($result); $datec = $db->jdate($objp->datec); $datem = $db->jdate($objp->tms); $memberstatic->lastname = $objp->lastname; $memberstatic->firstname = $objp->firstname; $memberstatic->id = $objp->rowid; $memberstatic->ref = $objp->rowid; if (!empty($objp->fk_soc)) { $memberstatic->socid = $objp->fk_soc; $memberstatic->fetch_thirdparty(); $memberstatic->name = $memberstatic->thirdparty->name; } else { $memberstatic->name = $objp->company; } $this->info_box_contents[$line][] = array('td' => 'align="left"', 'text' => $memberstatic->getNomUrl(1), 'asis' => 1); $this->info_box_contents[$line][] = array('td' => 'align="left"', 'text' => $memberstatic->getFullName($langs), 'url' => DOL_URL_ROOT . "/adherents/card.php?rowid=" . $objp->rowid); $this->info_box_contents[$line][] = array('td' => 'align="right"', 'text' => dol_print_date($datem, "day")); $this->info_box_contents[$line][] = array('td' => 'align="right" width="18"', 'text' => $memberstatic->LibStatut($objp->status, $objp->cotisation, $db->jdate($objp->date_end_subscription), 3)); $line++; } if ($num == 0) { $this->info_box_contents[$line][0] = array('td' => 'align="center"', 'text' => $langs->trans("NoRecordedCustomers")); } $db->free($result); } else { $this->info_box_contents[0][0] = array('td' => 'align="left"', 'maxlength' => 500, 'text' => $db->error() . ' sql=' . $sql); } } else { $this->info_box_contents[0][0] = array('align' => 'left', 'text' => $langs->trans("ReadPermissionNotAllowed")); } }
$var = !$var; print "<tr " . $bc[$var] . ">"; print '<td>' . $obj->email . '</td>'; print '<td>' . $obj->lastname . '</td>'; print '<td>' . $obj->firstname . '</td>'; print '<td>' . $obj->other . '</td>'; print '<td align="center">'; if (empty($obj->source_id) || empty($obj->source_type)) { print $obj->source_url; // For backward compatibility } else { if ($obj->source_type == 'member') { include_once DOL_DOCUMENT_ROOT . '/adherents/class/adherent.class.php'; $objectstatic = new Adherent($db); $objectstatic->fetch($obj->source_id); print $objectstatic->getNomUrl(2); } else { if ($obj->source_type == 'user') { include_once DOL_DOCUMENT_ROOT . '/user/class/user.class.php'; $objectstatic = new User($db); $objectstatic->fetch($obj->source_id); $objectstatic->id = $obj->source_id; print $objectstatic->getNomUrl(2); } else { if ($obj->source_type == 'thirdparty') { include_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; $objectstatic = new Societe($db); $objectstatic->fetch($obj->source_id); print $objectstatic->getNomUrl(2); } else { print $obj->source_url;
$obj = $db->fetch_object($resql); print "<tr " . $bc[$var] . ">"; $staticmember->id = $obj->rowid; $staticmember->lastname = $obj->lastname; $staticmember->firstname = $obj->firstname; if (!empty($obj->fk_soc)) { $staticmember->fk_soc = $obj->fk_soc; $staticmember->fetch_thirdparty(); $staticmember->name = $staticmember->thirdparty->name; } else { $staticmember->name = $obj->company; } $staticmember->ref = $staticmember->getFullName($langs); $statictype->id = $obj->typeid; $statictype->libelle = $obj->libelle; print '<td>' . $staticmember->getNomUrl(1, 32) . '</td>'; print '<td>' . $statictype->getNomUrl(1, 32) . '</td>'; print '<td>' . dol_print_date($db->jdate($obj->datem), 'dayhour') . '</td>'; print '<td align="right">' . $staticmember->LibStatut($obj->statut, $obj->cotisation == 'yes' ? 1 : 0, $db->jdate($obj->date_end_subscription), 5) . '</td>'; print '</tr>'; $i++; } } print "</table><br>"; } else { dol_print_error($db); } /* * Last modified subscriptions */ $max = 5;
while ($i < $num && $i < $conf->liste_limit) { $objp = $db->fetch_object($result); $total += $objp->cotisation; $cotisation->ref = $objp->crowid; $cotisation->id = $objp->crowid; $adherent->lastname = $objp->lastname; $adherent->firstname = $objp->firstname; $adherent->ref = $adherent->getFullName($langs); $adherent->id = $objp->rowid; $adherent->login = $objp->login; $var = !$var; print "<tr " . $bc[$var] . ">"; // Ref print '<td>' . $cotisation->getNomUrl(1) . '</td>'; // Lastname print '<td>' . $adherent->getNomUrl(1) . '</td>'; // Login print '<td>' . $adherent->login . '</td>'; // Libelle print '<td>'; print dol_trunc($objp->note, 32); print '</td>'; // Banque if (!empty($conf->banque->enabled)) { if ($objp->fk_account) { $accountstatic->id = $objp->fk_account; $accountstatic->fetch($objp->fk_account); //$accountstatic->label=$objp->label; print '<td>' . $accountstatic->getNomUrl(1) . '</td>'; } else { print "<td>";
$var = !$var; print "<tr " . $bc[$var] . ">"; print '<td>' . $obj->email . '</td>'; print '<td>' . $obj->lastname . '</td>'; print '<td>' . $obj->firstname . '</td>'; print '<td>' . $obj->other . '</td>'; print '<td align="center">'; if (empty($obj->source_id) || empty($obj->source_type)) { print $obj->source_url; // For backward compatibility } else { if ($obj->source_type == 'member') { include_once DOL_DOCUMENT_ROOT . '/adherents/class/adherent.class.php'; $m = new Adherent($db); $m->fetch($obj->source_id); print $m->getNomUrl(2); } else { if ($obj->source_type == 'user') { include_once DOL_DOCUMENT_ROOT . '/user/class/user.class.php'; $m = new User($db); $m->fetch($obj->source_id); $m->id = $obj->source_id; print $m->getNomUrl(2); } else { if ($obj->source_type == 'thirdparty') { include_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php'; $m = new Societe($db); $m->fetch($obj->source_id); print $m->getNomUrl(2); } else { print $obj->source_url;
print "<input type=\"hidden\" name=\"action\" value=\"update\">"; print "<input type=\"hidden\" name=\"rowid\" value=\"{$rowid}\">"; print "<input type=\"hidden\" name=\"fk_bank\" value=\"" . $subscription->fk_bank . "\">"; dol_fiche_head($head, 'general', $langs->trans("Subscription"), 0, 'payment'); print "\n"; print '<table class="border" width="100%">'; $linkback = '<a href="' . DOL_URL_ROOT . '/adherents/cotisations.php">' . $langs->trans("BackToList") . '</a>'; // Ref print '<tr><td width="20%">' . $langs->trans("Ref") . '</td>'; print '<td class="valeur" colspan="3">'; print $form->showrefnav($subscription, 'rowid', $linkback, 1); print '</td></tr>'; // Member $adh->ref = $adh->getFullName($langs); print '<tr>'; print '<td>' . $langs->trans("Member") . '</td><td class="valeur" colspan="3">' . $adh->getNomUrl(1, 0, 'subscription') . '</td>'; print '</tr>'; // Date start subscription print '<tr><td>' . $langs->trans("DateSubscription") . '</td><td class="valeur" colspan="2">'; $form->select_date($subscription->dateh, 'datesub', 1, 1, 0, 'update', 1); print '</td>'; print '</tr>'; // Date end subscription print '<tr><td>' . $langs->trans("DateEndSubscription") . '</td><td class="valeur" colspan="2">'; $form->select_date($subscription->datef, 'datesubend', 0, 0, 0, 'update', 1); print '</td>'; print '</tr>'; // Amount print '<tr><td>' . $langs->trans("Amount") . '</td><td class="valeur" colspan="2">'; print '<input type="text" class="flat" size="10" name="amount" value="' . price($subscription->amount) . '"></td></tr>'; // Label
$num = $db->num_rows($resql); if ($num) { $i = 0; $var = True; while ($i < $num) { $var=!$var; $obj = $db->fetch_object($resql); print "<tr $bc[$var]>"; $staticmember->id=$obj->rowid; $staticmember->ref=trim($obj->prenom.' '.$obj->nom); $statictype->id=$obj->typeid; $statictype->libelle=$obj->libelle; print '<td>'.$staticmember->getNomUrl(1,24).'</td>'; print '<td>'.$statictype->getNomUrl(1,16).'</td>'; print '<td>'.dol_print_date($db->jdate($obj->datem),'dayhour').'</td>'; print '<td align="right">'.$staticmember->LibStatut($obj->statut,($obj->cotisation=='yes'?1:0),$db->jdate($obj->date_end_subscription),5).'</td>'; print '</tr>'; $i++; } } print "</table><br>"; } else { dol_print_error($db); }