$form1 = new UserForm("dataEntry", $usersEntity); $form1->addSection("User Management"); $form1->addText("username", "username", 20, MANDATORY); $form1->addSection("personal data"); $form1->addText("email", "Email", 50, MANDATORY); $form1->addText("name", "Name", 40, MANDATORY); $form1->addText("surname", "Surname", 40, MANDATORY); $form1->addSelectFromReference2($facultyRoleEntity, "id_role", "Position"); $form1->addSelectFromReference2($ssdEntity, "id_ssd", "SSD"); $form1->addSelectFromReference2($areaEntity, "id_area", "Macro Area"); $form1->addSelectFromReference2($resGroupEntity, "id_resgroup", "Research Group"); $form1->addText("phone", "Phone", 20); $form1->addSelectFromReference2($buildingEntity, "building_id", "Building"); $form1->addText("room", "Room", 15); #$form1->addText("fax", "Fax", 20); $form1->addFile("picture", "Picture"); $form1->addCheck("Active", ":active:*:CHECKED"); $form1->addCheck("Home", ":active_home:*:CHECKED"); $form1->addCheck("Newsletter", ":active_newsletter:*:CHECKED"); $form1->addEditor("research", "Research", 10, 60); $form1->addEditor("publications", "Publications", 10, 60); $form2 = new Form("dataEntry2", $usersGroupsRelation); $form1->addSection("usergroups"); $form2->addRelationManager("groups", "Groups"); $form1->triggers($form2); /* CUSTOMIZED PAGER BELOW */ $pager = new becontentPager(); $pager->setQuery("\n\tSELECT users.name, \n\t users.surname, \n\t users.username, \n\t users.email, \n\t users.active,\n\t\t users.active_home\n\t\t \n\t FROM users "); $pager->setFilter("(name LIKE '%[search]%' OR surname LIKE '%[search]%' OR username LIKE '%[search]%')"); $pager->setOrder("name, surname"); $pager->setTemplate("dtml/report-users.html");