PHP FeMaterial::Execute Exemples

Exemple #1

Fichier : create.php Projet : adrianosilvareis/intranet

foreach ($FeAcoes->Execute()->getResult() as $acao) {
    extract((array) $acao);
    $select = $Dados['fe_acoes'] == $acao_id ? 'selected=true' : '';
    echo "<option value=\"{$acao_id}\" {$select}>{$acao_descricao}</option>";
}
?>
            </select>
        </div>

        <div class="form-group col-md-6">
            <label>Material:</label>
            <select  required="true" title="Material" name="fe_material" class="form-control">
                <option value="">Selecione um material</option>
                <?php 
$FeMaterial->setMat_status(1);
$FeMaterial->Execute()->Query("#mat_status#");
$FeMaterial->Execute()->FullRead("SELECT * FROM fe_material WHERE mat_status=:mat_status ORDER BY mat_descricao");
foreach ($FeMaterial->Execute()->getResult() as $material) {
    extract((array) $material);
    $select = $Dados['fe_material'] == $mat_id ? 'selected=true' : '';
    echo "<option value=\"{$mat_id}\" {$select}>{$mat_descricao}</option>";
}
?>
            </select>
        </div>

        <div class="form-group col-md-6">
            <label>Setor Solicitante:</label>
            <select  required="true" title="Setor Solicitante" name="ws_setor_soli" class="form-control">
                <option value="">Selecione um setor</option>
                <?php 

Exemple #2

Fichier : index.php Projet : adrianosilvareis/intranet

                    WSErro("Erro ao deletar", WS_ERROR);
                }
                break;
            default:
                WSErro("Opss! opção invalida.", WS_ERROR);
                break;
        }
    } else {
        WSErro("O material informada não pode ser encontrado!", WS_INFOR);
    }
}
$getPage = filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT);
$Pager = new Pager(FAST_INCLUDE . "admin/&exe=materiais/index&page=");
$Pager->ExePager($getPage, 15);
$FeMaterial = new FeMaterial();
$FeMaterial->Execute()->FullRead("SELECT * FROM fe_material ORDER BY mat_status LIMIT :limit OFFSET :offset", "limit={$Pager->getLimit()}&offset={$Pager->getOffset()}", true);
if (!$FeMaterial->Execute()->getResult()) {
    $Pager->ReturnPage();
    WSErro("Nenhum material cadastrado!", WS_INFOR);
} else {
    ?>
    <table class="table table-striped">
        <thead>
            <tr>
                <th>#</th>
                <th>Descrição</th>
                <th>Ação</th>
            </tr>
        </thead>
        <tbody>
            <?php 

Exemple #3

Fichier : user.php Projet : adrianosilvareis/intranet

foreach ($FeAcoes->Execute()->getResult() as $acao) {
    extract((array) $acao);
    $select = $Dados['fe_acoes'] == $acao_id ? 'selected=true' : '';
    echo "<option value=\"{$acao_id}\" {$select}>{$acao_descricao}</option>";
}
?>
                    </select>
                </div>

                <div class="form-group col-md-6">
                    <label>Material:</label>
                    <select  required="true" title="Material" name="fe_material" class="form-control">
                        <option value="">Selecione um material</option>
                        <?php 
$FeMaterial->setMat_status(1);
$FeMaterial->Execute()->Query("#mat_status#");
foreach ($FeMaterial->Execute()->getResult() as $material) {
    extract((array) $material);
    $select = $Dados['fe_material'] == $mat_id ? 'selected=true' : '';
    echo "<option value=\"{$mat_id}\" {$select}>{$mat_descricao}</option>";
}
?>
                    </select>
                </div>

                <div class="form-group col-md-6">
                    <label>Setor Solicitante:</label>
                    <select  required="true" title="Setor Solicitante" name="ws_setor_soli" class="form-control">
                        <option value="">Selecione um setor</option>
                        <?php 
$WsSetor->setSetor_status(1);