Posts by Vision Development • 191 points
21 posts
-
-4
votes1
answer45
viewsQ: Add input to an array loop
for($i=0; $i<count($produtos); $i++) { $itens = array(); for($j=0; $j<count($especificacao); $j++) { if ($produtos[$i]["produto_id"] === $especificacao[$j]["prod_espeficacao_produto_id"]) {…
-
0
votes1
answer53
viewsQ: Disable the unselected options of multiselect with jquery
$('#columns-selected').change(function(){ let menu = []; for (i=0; i < 5; i++){ let opcao = $('#columns-selected option:selected')[i]; if (opcao){ menu.push($(opcao).val()); }; } $.ajax({ method:…
-
0
votes2
answers75
viewsQ: Doubts on how to select a week using jquery
<div class="input-group" id="DateDemo"> <input type='text' id='weeklyDatePicker' placeholder="Select Week" /> </div> $(document).ready(function(){…
-
0
votes1
answer20
viewsQ: Error with prechimento and Submit of fields via ajax
$('#grupo_prod').blur(function(){ var grupo = $('#grupo_prod').val(); var filial = $('#filialAtual').val(); $.ajax({ method: "POST", url: base_url+"pdv2/selecionarProduto/", dataType: "html", data:…
-
0
votes1
answer18
viewsQ: Perform an external-based query in the Zend Framework
Model public function excluirFiliadosNaoEnviados($base) { $sql = "SELECT FROM " . $base . ".debito_automatico"; $acao = $this->conexao->prepare($sql); if($acao->execute()){ return true;…
-
-2
votes2
answers47
viewsQ: I a select where the same is starting to get too slow, Would you have any solution to improve your speed?
SELECT pessoafisica.PessoaFisica_Nome, filiados.`Filiado_MatriculaEmpresa`, filiados.`Filiado_RetornoSiape` AS observacoes, Filiado_MatriculaEmpresaDigito, lotacao.Lotacao_Descricao, (SELECT…
-
-2
votes1
answer41
viewsQ: Problems with events in JS
I am doing an event in js, but the same is not working properly by the following fact if the user does not select at least one radio he does not trigger the event, as he would for the event to…
-
1
votes1
answer39
viewsQ: How to make this condition correctly in Mysql?
I’m wondering which affiliates have repeated enrollment within a company until the exact moment I get to make this query: SELECT DISTINCT filiados.`Filiado_Id`, filiados.`Filiado_MatriculaEmpresa`…
-
0
votes1
answer53
viewsQ: Doubt how to mount a query in Mysql
SELECT `tab_banco`.`nome` AS `bancoNome`, `conta_bancaria`.`conta_apelido` AS `contaApelido`, `conta_bancaria`.`id` AS `idConta`, `movimento`.`conta_bancaria_id` AS `conta_bancaria_id`,…
-
2
votes3
answers140
viewsQ: GROUP BY last registration per month and year how to do?
I’m making an appointment at the bank, follow my table below id | valor | mes | ano | 1 39.69 3 2017 1 7.69 3 2018 3 9.69 4 2015 3 3.69 2 2016 2 5.89 3 2017 2 39.69 8 2018 need to bring the result…
-
0
votes1
answer59
viewsQ: How to assemble a consult to bring the latest value based on month and year?
SELECT DadosFinanceirosFiliado_Valor, Filiados_Filiado_Id, DadosFinanceirosFiliado_CompetenciaMes, DadosFinanceirosFiliado_CompetenciaAno FROM dadosfinanceirosfiliado t INNER JOIN filiados ON…
-
2
votes1
answer74
viewsQ: Problems with date transformation function
$data = $_POST["data"]; // Recebe a variável com a data, e cria um objeto DateTime a partir do formato especificado. $objetoData = DateTime::createFromFormat('d/m/Y', $data); // Reformata a data do…
-
0
votes1
answer46
viewsQ: How to make the result of a column?
if(($resultado_usuario) AND ($resultado_usuario->num_rows != 0)){ ?> <style> tr:nth-child(even) {background: #CCC} tr:nth-child(odd) {background: #CCC} </style> <table…
-
2
votes1
answer49
viewsQ: Problems with Mysql query
<form method="POST" class="w-100" action="pesquisa_diaria.php"> <div class="card-body"> <div class="row"> <div class="col-sm-3"> <label>Tipo de Venda</label>…
-
4
votes3
answers85
viewsQ: How do you adjust my query date?
$result_usuario = "SELECT * FROM vendas WHERE DATE(date_created) = '$data' AND tipo_venda = '$tipo_vendas' AND tipo = '$tipo_pagamento' ORDER BY 'id'"; I have this query, but it doesn’t work right…
-
0
votes1
answer115
viewsQ: How to make a beginTransaction in the Zend framework?
public function alterar($objDadosSindicato) { $this->conexao->beginTransaction(); try { $alterouSindicato = $this->repositorioDadosSindicato->alterar($objDadosSindicato); /** Filiação /…
-
0
votes3
answers179
viewsQ: Make an input receive a value less than another
<input type="number" name="total" value="25" required> <input type="number" name="valor-em-dinheiro" class="form-control text-right" required> I have two input where the first receive…
-
0
votes1
answer38
viewsQ: Doubts in the PHP float function
$valorBaixa = (float)$this->input->post('valorBaixa'); I have this float function where it turns a string into a float value, only it cuts the values. Example: if "8.75" is entered the…
-
2
votes3
answers76
viewsQ: How an array comes from the database in an input
<input type="text" class="form-control" name="lanches" id="lanches" value="<?php echo $resultado['lanches']; ?>" > I have that above input where it receives that array that is inside the…
-
0
votes1
answer33
viewsQ: How do I query the database 10 days ahead and 10 days behind the current date?
Today I can already do the consultation 10 days ago as shown in the query below, I’m just not able to deploy the 10 days ahead of the current date. SELECT `vw_saldobancario`.`contaApelido`,…
-
2
votes2
answers169
viewsQ: How to limit an input according to the variable?
I have 2 field as shown below : <div class="col-md-4"> <label for="descricao">Valor título </label> <div class="input-group"> <span…