if (isset($_POST['ReqSerVer'])) { //Disponibles $db = new DB2(); $db1 = new DB2(); $var1 = $_POST['ReqSerVer']; $result = $db->select("CALL RequisitosNO_Servicio(" . $var1 . ");"); $res = "<table class=\"table table-striped\">"; $res .= "<thead><th>idRequisito</th><th>Nombre</th><th></th></thead>"; foreach ($result as $row) { $res .= "<tr><td class=\"col-md-2\">" . $row['idRequisito'] . "</td>"; $res .= "<td class=\"col-md-4\">" . $row['Nombre'] . "</td>"; $res .= "<td class=\"col-md-1\"><button type=\"submit\" name=\"Edit\" class=\"btn btn-default btn-xs\" onclick=\"Agregar(" . $row['idRequisito'] . "," . $var1 . ");\"> Agregar </button></td>"; $res .= '</tr>'; } $res .= "</table>"; $result1 = $db1->select("CALL Requisitos_Servicio(" . $var1 . ");"); $res1 = "<table class=\"table table-striped\">"; $res1 .= "<thead><th>idRequisito</th><th>Nombre</th><th></th></thead>"; foreach ($result1 as $row1) { $res1 .= "<tr><td class=\"col-md-2\">" . $row1['idRequisito'] . "</td>"; $res1 .= "<td class=\"col-md-4\">" . $row1['nombre'] . "</td>"; $res1 .= "<td class=\"col-md-1\"><button type=\"submit\" name=\"Edit\" class=\"btn btn-default btn-xs\" onclick=\"Quitar(" . $row1['idRequisito'] . "," . $var1 . ");\"> Quitar </button></td>"; $res1 .= '</tr>'; } $res1 .= "</table>"; echo ' <table class="table"> <tr><td class="col-md-6"> <div class="panel panel-default"> <div class="panel-heading">Requisitos Disponibles</div> <div class="panel-body">
public function repeats() { PHPWS_Core::initCoreClass('DB2.php'); $end_date = (int) $_GET['date']; $start_date = mktime(0, 0, 0, date('m', $end_date) - 1, date('d', $end_date)); $this->title = sprintf(dgettext('checkin', 'Multiple visits made between %s and %s'), strftime('%b %e', $start_date), strftime('%b %e', $end_date)); $limit = 2; if (isset($_GET['visit_query'])) { $limit = (int) $_GET['visit_query']; } if ($limit > 10 || $limit < 2) { $limit = 2; } try { $sub = new DB2(); $t1 = $sub->addTable('checkin_visitor', 't1'); $t1_id = $t1->addField('id'); $exp = $sub->addExpression('COUNT(' . $t1_id->__toString() . ')', 'num'); $t1_fn = $t1->addField('firstname'); $t1_ln = $t1->addField('lastname'); $t1->addWhere('arrival_time', $start_date, '>='); $t1->addWhere('arrival_time', $end_date, '<='); $t1->addOrderBy('lastname'); $sub->setGroupBy(array($t1_fn, $t1_ln)); $db2 = new DB2(); $t2 = $db2->addSubSelect($sub, 't2'); $t2->addWhere($exp, $limit, '>='); $result = $db2->select(); } catch (PEAR_Exception $e) { $this->content = dgettext('checkin', 'Sorry an error occurred.'); $db2->logError($e); return; } if (empty($result)) { $this->content = dgettext('checkin', 'No repeat visits within the last month.'); return; } $form = new PHPWS_Form(); $form->setMethod('get'); $form->addHidden('module', 'checkin'); $form->addHidden('aop', 'repeats'); $form->addHidden('date', $end_date); $form->addSelect('visit_query', array(2 => 2, 4 => 4, 6 => 6, 8 => 8, 10 => 10)); $form->setMatch('visit_query', $limit); $form->addSubmit('go', dgettext('checkin', 'Visits greater to or equal to')); $tpl = $form->getTemplate(); foreach ($result as $visit) { $rows['NAME'] = PHPWS_Text::moduleLink(sprintf('%s, %s', $visit['lastname'], $visit['firstname']), 'checkin', array('aop' => 'visitor_report', 'vis_id' => $visit['id'])); $rows['VISITS'] = $visit['num']; $tpl['visitors'][] = $rows; } $this->content = PHPWS_Template::process($tpl, 'checkin', 'repeats.tpl'); }