} // Static objects $adherent = new Adherent($db); $accountstatic = new Account($db); /* * Actions */ /* * View */ llxHeader('', $langs->trans("ListOfSubscriptions"), 'EN:Module_Foundations|FR:Module_Adhérents|ES:Módulo_Miembros'); if ($msg) { print $msg . '<br>'; } if (!empty($date_select)) { $result = $adherent->getView('cotisationYear', array("key" => (int) $date_select)); } else { $result = $adherent->getView('cotisationYear'); } $title = $langs->trans("ListOfSubscriptions"); if (!empty($date_select)) { $title .= ' (' . $langs->trans("Year") . ' ' . $date_select . ')'; } print '<div class="row">'; print start_box($titre, "twelve", "16-Money.png"); $i = 0; $obj = new stdClass(); print '<div class="datatable">'; print '<table class="display dt_act" id="cotisation_datatable" >'; // Ligne des titres print '<thead>';
$langs->load("companies"); $langs->load("members"); /* * View */ llxHeader('', $langs->trans("Members"), 'EN:Module_Foundations|FR:Module_Adhérents|ES:Módulo_Miembros'); $staticmember = new Adherent($db); print_fiche_titre($langs->trans("MembersArea")); print '<table border="0" width="100%" class="notopnoleftnoright">'; $var = True; $Adherents = array(); $AdherentsAValider = array(); $MemberUpToDate = array(); $AdherentsResilies = array(); $AdherentType = array(); $result = $staticmember->getView('tag', array("group" => true)); if (count($result->rows)) { foreach ($result->rows as $aRow) { $AdherentType[$aRow->key] = $aRow->value; } } $now = dol_now(); $doc->_id = "_temp_view"; $doc->map = "function(doc) {\n var now = Math.round(+new Date()/1000);\n var status = 0;\n\n if(doc.class && doc.class==\"Adherent\"){\n if(doc.last_subscription_date_end && doc.Status == 1) {\n if(doc.last_subscription_date_end < now)\n status = \"expired\";\n else\n status = \"actived\";\n }\n else\n status= doc.Status;\n\n if(doc.Tag.length > 0) {\n for(var idx in doc.Tag) {\n emit([doc.Tag[idx],status], 1);\n }\n }\n\n }\n}"; $doc->reduce = "function(keys, values) {\n return sum(values)\n}"; $result = $staticmember->storeDoc($doc); if (count($result->rows)) { foreach ($result->rows as $aRow) { $Adherents[$aRow->key[0]][$aRow->key[1]] = $aRow->value; } }
$obj->aoColumns[$i]->bUseRendered = false; $obj->aoColumns[$i]->bSearchable = true; $obj->aoColumns[$i]->fnRender = $object->datatablesFnRender("tag", "url", array("url" => $_SERVER["PHP_SELF"] . '?id=')); $i++; print '<th class="essential">'; print $langs->trans('Total'); print '</th>'; $obj->aoColumns[$i]->mDataProp = "nb"; $obj->aoColumns[$i]->sDefaultContent = 0; $i++; print '</tr>'; print '</thead>'; print '<tfoot>'; print '</tfoot>'; print '<tbody>'; $result = $object->getView('tag', array("group" => true)); if (count($result->rows) > 0) { foreach ($result->rows as $aRow) { $nb = $aRow->value; $tmp_id = $aRow->key; print "<tr>"; print '<td>'; print $tmp_id; print '</td>'; print '<td>'; print $tmp_id . '</td>'; print '<td align="right">' . $nb . '</td>'; print "</tr>"; $i++; } }