public function listaDias()
{
$q = isset($_POST['q']) ? strval($_POST['q']) : '';
$dias = new Dia();
$row = $dias->find('all', array('conditions' => array('Dia.nombre like' => "%{$q}%"), 'order' => 'Dia.id'));
$this->set('result', $row);
$this->render('listaDias', 'ajax');
}
public function destroy($id)
{
$dia = Dia::find($id);
$dia->delete();
Session::flash('message', "El Dia Eliminado Correctamente...!");
Session::flash('class', 'success');
return Redirect::to('dia');
}
/**
* Store a newly created resource in storage.
* POST /lista/dia
*
* @return Response
*/
public function postDia()
{
//si la peticion es ajax
if (Request::ajax()) {
$dias = Dia::get(Input::all());
return Response::json(array('rst' => 1, 'datos' => $dias));
}
}
</button></th>
<th>Respons. <button class="btn btn-mini" onclick="return false;" data-original-title="Campo Responsable" data-content="Oprima sobre este campo para ordenar la lista por el atributo Responsable (nombre y apellido) del usuario que asignó el turno. Cada vez que se oprime cambiará entre forma ascendente y descendente.">
<i class="icon-question-sign"></i>
</button></th>
</tr>
</thead>
<tbody>
<?php
foreach ($result as $valor) {
?>
<?php
if ($valor['estado'] != 'cancelado') {
$idmedico = $valor['idmedico'];
$hora = $valor['hora'];
$fecha = $valor['fecha'];
$dia = new Dia($fecha);
$dianom = $dia->getNombre();
$con = "select id from horario where dia = '{$dianom}' and desde = '{$hora}' and id_med = '{$idmedico}'";
$aux = $db->query($con);
$array1 = $aux->fetch(PDO::FETCH_ASSOC);
$idhorario = $array1['id'];
?>
<tr>
<td><input type="checkbox" name="<?php
echo $valor['idturno'];
?>
" value="<?php
echo $valor['idturno'];
?>
" id="<?php
echo $valor['idturno'];
<?php
include_once './_conectDb.php';
$db = conectaDb();
require_once './Dia.php';
$hoy = new Dia();
$consulta = "update horario set activo=1 where dia = '" . $hoy->getNombre() . "' and activo = 0";
echo $consulta;
if ($db->query($consulta)) {
echo "todo bien";
} else {
echo "todo mal";
}
function criarprojeto()
{
$this->valida_sessao();
$nome_projeto = $this->escape("nomeproj");
$usuario = $this->escape("user");
$numero_profissionais = 10;
$custo_padrao_hora = 50;
$p_analise = 10;
$p_projeto = 25;
$p_implementacao = 50;
$p_testes = 15;
//cod: 10 - 20 - 55 - 15
//art: 30 - 27 - 15 - 28
$projeto = new Projeto();
$projeto->idUsuario = $usuario;
$projeto->nome = $nome_projeto;
$projeto->linhasDeCodigoPrevistas = rand(300000, 600000);
$projeto->artefatosPrevistos = $projeto->linhasDeCodigoPrevistas * (1 / 100);
//1% do codigo
$projeto->tempo = round($projeto->linhasDeCodigoPrevistas / ($numero_profissionais * 194 * 5));
$projeto->orcamento = $numero_profissionais * $custo_padrao_hora * 8 * 5 * $projeto->tempo * 1.12;
//custo esperado + 12%
$projeto->saldo = $projeto->orcamento;
$projeto->percentualErros = 1.5;
$projeto->idStatus = 0;
$projeto->save();
$meta1 = new Meta();
$meta1->nome = "Análise";
$meta1->idProjeto = $projeto->idProjeto;
$meta1->tempo = round($projeto->tempo * ($p_analise / 100));
$meta1->linhasDeCodigo = round($projeto->linhasDeCodigoPrevistas * (10 / 100));
$meta1->artefatos = round($projeto->artefatosPrevistos * (30 / 100));
$meta1->save();
$meta2 = new Meta();
$meta2->nome = "Projeto";
$meta2->idProjeto = $projeto->idProjeto;
$meta2->tempo = round($projeto->tempo * ($p_projeto / 100));
$meta2->linhasDeCodigo = round($projeto->linhasDeCodigoPrevistas * (20 / 100));
$meta2->artefatos = round($projeto->artefatosPrevistos * (27 / 100));
$meta2->save();
$meta3 = new Meta();
$meta3->nome = "Implementação";
$meta3->idProjeto = $projeto->idProjeto;
$meta3->tempo = round($projeto->tempo * ($p_implementacao / 100));
$meta3->linhasDeCodigo = round($projeto->linhasDeCodigoPrevistas * (55 / 100));
$meta3->artefatos = round($projeto->artefatosPrevistos * (15 / 100));
$meta3->save();
$meta4 = new Meta();
$meta4->nome = "Testes e Validação";
$meta4->idProjeto = $projeto->idProjeto;
$meta4->tempo = $projeto->tempo - $meta3->tempo - $meta2->tempo - $meta1->tempo;
$meta4->linhasDeCodigo = $projeto->linhasDeCodigoPrevistas - $meta3->linhasDeCodigo - $meta2->linhasDeCodigo - $meta1->linhasDeCodigo;
$meta4->artefatos = $projeto->artefatosPrevistos - $meta3->artefatos - $meta2->artefatos - $meta1->artefatos;
$meta4->save();
for ($i = 0; $i < $projeto->tempo; $i++) {
$semana = new Semana();
$semana->idProjeto = $projeto->idProjeto;
$semana->save();
for ($j = 0; $j < 5; $j++) {
$dia = new Dia();
$dia->idSemana = $semana->idSemana;
$dia->save();
}
}
$_SESSION["idprojeto"] = $projeto->idProjeto;
$_SESSION["projeto"] = true;
$apresentacao = $this->escape("apresentacao");
if ($apresentacao == true) {
$this->set("apresentacao", true);
} else {
$this->set("apresentacao", false);
}
$this->show("pages/interno/index.tpl");
}
$sort = getSortValue($colectionData, $_REQUEST["sort"]);
//get sort field to apply
} else {
$sort = getDefaultSort($colectionData, $q);
//get default sort
}
$output = isset($_REQUEST["output"]) && $_REQUEST["output"] != '' ? $_REQUEST["output"] : "json";
$format = $_REQUEST["format"];
$where = $_REQUEST["where"];
//select where search
$whereFilter = getWhereFilter($colectionData, $where);
$filter_chain = $_REQUEST["filter_chain"];
//user filter sequence (history)
$VARS["count"] = $count;
//DIA server connection object
$dia = new Dia($site, $col, $count, $output, $lang);
$page = new Page();
$initial_restricion = html_entity_decode($colectionData->restriction);
// filtro de pesquisa = restricao inicial E filtro where E filtro externo E filtro(s) selecionados
$filterSearch = array_merge((array) $initial_restricion, (array) $whereFilter, (array) $filter, (array) $filter_chain);
// set additiona parameters
$dia->setParam('fb', $fb);
$dia->setParam('fl', $fl);
$dia->setParam('sort', $sort);
// create a loop for export all citation
header("Content-type: application/x-Research-Info-Systems; charset=UTF-8");
header('Content-Disposition: attachment; filename="export.txt"');
// add BOM code
print pack("CCC", 0xef, 0xbb, 0xbf);
$diaResponse = $dia->search($q, $index, $filterSearch, $from);
$result = json_decode($diaResponse);
} else {
if ($backFilter == -2) {
//delete filter history and query
$filter_chain = null;
$q = null;
} else {
$reduceFilter = array_slice($filter_chain, 0, $backFilter + 1);
//delete filter history to position
$filter_chain = $reduceFilter;
}
}
}
$debug = $_REQUEST['debug'];
$detail = $_REQUEST['detail'];
//DIA server connection object
$dia = new Dia($site, $col, $count, $output, $lang);
$page = new Page();
$initial_restricion = html_entity_decode($colectionData->restriction);
// filtro de pesquisa = restricao inicial E filtro where E filtro externo E filtro(s) selecionados
$filterSearch = array_merge((array) $initial_restricion, (array) $whereFilter, (array) $filter, (array) $filter_chain);
// set additiona parameters
$dia->setParam('fb', $fb);
$dia->setParam('fl', $fl);
$dia->setParam('qt', $qt);
$dia->setParam('sort', $sort);
$diaResponse = $dia->search($q, $index, $filterSearch, $from);
$result = json_decode($diaResponse);
if ($output == "xml" || $output == "sol") {
header("Content-type: text/xml; charset=UTF-8");
print $diaResponse;
} else {
<div class="col-lg-12">
<!-- Horizontal Form -->
<div class="box box-success">
<div class="box-header with-border">
<h3 class="box-title">Cadastro de cardápios</h3>
</div><!-- /.box-header -->
<!-- form start -->
<form class="form-horizontal" name="cadcardapio" id="form" method="post" action="CrudCardapios.php">
<div class="box-body">
<div class="form-group">
<label for="dia" class="col-sm-2 control-label">Dia:</label>
<div class="col-sm-10">
<select class="form-control" id="dia" name="dia" style="width: 100%;" required>
<option value=""></option>
<?php
$diaSelect = new Dia();
$diaSelect->diaSelect();
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label" for="date">Data:</label>
<div class="col-sm-10">
<input type="text" class="form-control" name="data" id="date" placeholder="dd/mm/yyyy" data-inputmask="'alias': 'dd/mm/yyyy'" data-mask required>
</div>
</div>
<div class="form-group">
<?php
if (isset($_SESSION['alimento_edit'])) {
unset($_SESSION['alimento_edit']);
if ($tmp->rowCount() == 0) {
?>
<option value="-1" class="option3">No hay horarios libres</option>
<?php
} else {
?>
<option value="-1" class="option3" selected="selected">Seleccione un horario</option>
<?php
foreach ($tmp as $valor) {
?>
<?php
$diahoy = new Dia(date('d-m-Y'));
$nomdia = $diahoy->getNombre();
?>
<?php
if ($nomdia == $dia) {
?>
<?php
$ahora = strftime("%X", strtotime(date('H:m:s')));
$hora = strftime("%X", strtotime($valor['desde']));
?>
<?php
if ($hora > $ahora) {
?>
<option class="option3" name="horario" value="<?php
echo $valor['id'];
?>
foreach ($aux2 as $valaux2) {
$auxi = new Dia($valaux2['dia']);
//reviso el minimo de los dias
if ($auxi->getDia() <= $dia_min) {
$dia_nom = $auxi->getNombre();
//obtengo los horarios del dia actual del medico actual
$consulta3 = 'select id, min(desde) desde, min(hasta) hasta, dia, id_med
from horario where (id_med = "' . $valor2['idmedico'] . '")
and (dia = "' . $dia_nom . '") and (activo = 1)';
$res3 = $db->query($consulta3);
foreach ($res3 as $valaux3) {
//reviso el horario minimo de ese dia
if ($valaux3['desde'] <= $hs_min) {
$dia_min = $auxi->getDia();
$dia_nom = $auxi->getNombre();
$oDia = new Dia($valaux2['dia']);
$hs_min = $valaux3['desde'];
$id_hs_min = $valaux3['id'];
$id_med_min = $valor2['idmedico'];
$nom_med_min = $valor2['nombre'];
$ape_med_min = $valor2['apellido'];
}
}
}
}
}
?>
<?php
// de aca para abajo es lo que hay en turno alta y deberia imitarlo...
?>
echo $form->dropDownList($model, 'intervalo_id', $intHelper);
?>
<?php
//echo $form->textField($model,'intervalo_id');
?>
<?php
echo $form->error($model, 'intervalo_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'dia_id');
?>
<?php
echo $form->dropDownList($model, 'dia_id', CHtml::listData(Dia::model()->findAll(), 'dia_id', 'dia_nombre'));
?>
<?php
//echo $form->textField($model,'dia_id');
?>
<?php
echo $form->error($model, 'dia_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'sucursal_id');
?>
<?php
echo $form->dropDownList($model, 'sucursal_id', CHtml::listData(Sucursal::model()->findAll(), 'sucursal_id', 'sucursal_nombre'));
unset($semana[$valor['dia']]);
} else {
?>
<option class="option2" name="fecha" value="-1">
<?php
echo $valor['dia'] . '-Licencia-' . $aux->getDia();
?>
</option>
<?php
unset($semana[$valor['dia']]);
}
}
}
foreach ($semana as $d) {
$aux2 = new Dia($d);
?>
<option class="option2" name="fecha" value="-1">
<?php
echo $d . '-Lleno-' . $aux2->getDia();
?>
</option>
<?php
}
?>
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Dia the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Dia::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
$id = $_POST["id"];
if (isset($_POST["editar"])) {
$edit = new Cardapios();
$comp = $edit->EditarCardapios($id);
if ($edit != null) {
?>
<form class="form-horizontal" name="cadcardapio" id="form" method="post" action="CrudCardapios.php">
<div class="box-body">
<div class="form-group">
<label for="dia" class="col-sm-2 control-label" >Dia:</label>
<div class="col-sm-10">
<select class="form-control select2" id="dia" name="dia" style="width: 100%;">
<option value=""></option>
<?php
$diaSelect = new Dia();
$diaSelect->diaSelect($comp->dia);
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label" for="date">Data:</label>
<div class="col-sm-10">
<input type="text" class="form-control" name="data" id="date" placeholder="dd/mm/yyyy" value="<?php
echo date('d/m/Y', strtotime($comp->data));
?>
" data-inputmask="'alias': 'dd/mm/yyyy'" data-mask required>
</div>
</div>
<div class="form-group">
