Posts by Chefe Druida • 1,086 points
187 posts
-
8
votes3
answers2879
viewsQ: How to know how many Sundays have php mysql months
Let’s say the year is: 2016 I need to know how many Sundays have the months of the year and save and result in php variable. Reason: I need to pass a condition,: if ($dom_mes == 4 ) { //CONDIÇÃO A }…
-
0
votes1
answer29
viewsA: Add variables with date field equal if possible by editing date column
Final result: SELECT ifd_filial AS FILIAL, ifd_chapa AS CHAPA, ifd_nome AS NOME, DATE_FORMAT(ifd_dataa,'%m') AS MÊS, SUM(ifd_dias) AS DIAS, ifd_desc AS DESCRICAO FROM imp_folga_domingo WHERE…
-
0
votes1
answer29
viewsQ: Add variables with date field equal if possible by editing date column
I have the following variables:: $v_data = $row['DATA']; $v_filial = $row['FILIAL']; $v_chapa = $row['CHAPA']; $v_func = $row['FUNCIONARIO']; $v_dias = $row['DIAS']; $v_desc = $row['DESCRICAO'];…
-
2
votes1
answer356
viewsA: Migrate Firebird Delphi 7 Application to Postgresql
Have you tried using the ODBC Postgresql driver itself ? Product psqlODBC Description psqlODBC is the Official Postgresql ODBC Driver. Licence Open source Publisher Postgresql Global Development…
-
0
votes3
answers76
viewsA: Error using HAVING in date/time query
Final result: SELECT ROW_NUMBER() OVER(ORDER BY V.DATA ASC) AS ID, V.CHAPA AS CHAPA, F.NOME AS NOME, V.DATA AS DATA, isnull(V.BATIDA, 0 ) as TBATIDA FROM ARELBATIDATRANSITOVIEW AS V LEFT JOIN…
-
1
votes3
answers76
viewsQ: Error using HAVING in date/time query
I have the following appointment: SELECT ROW_NUMBER() OVER(ORDER BY V.DATA ASC) AS ID, V.CHAPA AS CHAPA, F.NOME AS NOME, V.DATA AS DATA, CASE WHEN V.BATIDA IS NULL THEN 0 ELSE V.BATIDA END AS…
-
0
votes2
answers4115
viewsQ: Query returning error in query between date period
Consultation: SELECT ROW_NUMBER() OVER(ORDER BY V.DATA ASC) AS ID, V.CHAPA AS CHAPA, F.NOME AS NOME, V.DATA AS DATA, CASE WHEN V.BATIDA IS NULL THEN 0 ELSE V.BATIDA END AS FOLGA FROM…
-
1
votes1
answer642
viewsA: Difference of days between records and display only results > that 14
Follows solution: -- código #1 with Consulta as ( SELECT V.CHAPA, F.NOME, V.DATA, DATENAME(dw,V.DATA) AS DIA, MAX(V.SEQUENCIALBATIDA) AS BATIDA FROM ARELBATIDATRANSITOVIEW AS V LEFT JOIN V_DADOSFUNC…
-
1
votes2
answers464
viewsA: Difference of hours query sql server
I tried to post in SQL Fiddle more ta giving error,follows my solution: TABLE EXAMPLE: create table #dados ( cpf int, data datetime , tipo int ) INSERT EXAMPLE: insert into #dados (cpf, data, tipo)…
-
1
votes1
answer642
viewsQ: Difference of days between records and display only results > that 14
I have the following appointment: SELECT V.CHAPA, F.NOME, V.DATA, DATENAME(dw,V.DATA) AS DIA, MAX(V.SEQUENCIALBATIDA) AS BATIDA FROM ARELBATIDATRANSITOVIEW AS V LEFT JOIN V_DADOSFUNC AS F ON V.CHAPA…
-
1
votes1
answer31
viewsQ: Check the difference between unlisted results and identify which day of the week is the date
I have the following appointment: SELECT V.CHAPA, F.NOME, V.DATA, MAX(V.SEQUENCIALBATIDA) AS BATIDA FROM ARELBATIDATRANSITOVIEW AS V LEFT JOIN V_DADOSFUNC AS F ON V.CHAPA = F.CHAPA WHERE V.CHAPA =…
-
1
votes2
answers785
viewsQ: How to show the result of a query based on the result of another?
Consultation A: SELECT V.CHAPA AS CHAPA, F.NOME AS NOME, V.DATA AS DATA, DATEDIFF(mi, MIN(BATIDA), MAX(BATIDA)) AS DIFF FROM V_BATIDASANTIGAS AS V LEFT JOIN V_DADOSFUNC AS F ON V.CHAPA = F.CHAPA…
-
0
votes1
answer79
viewsQ: Query with datiff returning 0 in sql server result
I have the following appointment: SELECT DATEDIFF(hh, MIN(BATIDA), MAX(BATIDA))AS HORAS FROM ARELBATIDATRANSITOVIEW WHERE CHAPA = 3187 AND BATIDA IS NOT NULL AND SEQUENCIALBATIDA IN (2,3) GROUP BY…
-
1
votes1
answer70
viewsQ: How to use having together with view in sql server
When trying to use the HAVING in an SQL query is returning the following error: Mensagem 8121, Nível 16, Estado 1, Linha 15 Column 'V_DADOSFUNC.FILIAL' is invalid in the HAVING clause because it is…
-
2
votes2
answers464
viewsQ: Difference of hours query sql server
I have the following data: 2016-10-13 09:04:00.000 1 2016-10-13 20:33:00.000 4 2016-10-14 09:10:00.000 1 2016-10-14 21:04:00.000 4 2016-10-17 09:04:00.000 1 2016-10-17 19:50:00.000 4 How to know the…
-
3
votes3
answers1100
viewsQ: Change the iframe (embed bootstrap) according to the navigation bar button
Example: Navigating: <ul > <li><a href="#"><span>INICIO</span></a></li> <li><a href="#"><span>FACEBOOK</span></a></li>…
-
0
votes1
answer46
viewsQ: Insertion of multiple GET lines automatically php
I have several lines like this: http://192.168.0.1/feed/data.json?id=71667&start=1426031940000&end=1426064520000&interval=30…
-
2
votes2
answers899
viewsQ: How to remove waste on printing screens
How to create a CSS to remove waste as in the attached image. I’m wearing a bootstrap.…
-
3
votes1
answer301
viewsQ: Error when connecting PHP to SQL Server via ODBC Linux
I am making a connection in no windowns via php to SQL SERVER and it is going normal, in a machine where the php server is linux this giving the following error: Fatal error: Uncaught exception…
-
1
votes2
answers815
viewsQ: Error summing 2 php values
I have that value: 250,59 and that other value: 20,19 when we both go,: 270 Follow my calculations: $mo = $vl_mobra ; //VALOR 1 250,59 $mt = $vl_mat; //VALOR 2 20,19 $vt = $mo + $mt; //SOMA See more…
-
1
votes3
answers434
viewsQ: Error converting php data
I am receiving the following date of a form: 26/09/2016 I need to convert it to: 2016-09-01 I am using the following command: $v_data= date('Y-m-d', strtotime($data)); only this giving the following…
-
0
votes1
answer104
viewsQ: How to create a loop between the records and the current php date
I have the following Chart combo: <div id="vendas_diarias" style="height: 500px;"></div> <script type="text/javascript"…
-
0
votes1
answer244
viewsQ: Select with MD5 password returning empty
I am using the query below to perform the login,it was working normal with normal passwords,more now I am migrating to the password Md5,only this giving only invalid password,I believe it is my…
-
1
votes1
answer512
viewsQ: How to add current record to previous record by creating a cumulative?
How to add current record to previous record,creating a cumulative? SELECT DAY(i.imp_data) AS DATA, m.mt_valor / m.mt_valor / CAST(DAY(LAST_DAY(NOW())) AS DECIMAL)* 100 AS META_DIARIA,…
-
0
votes1
answer193
viewsQ: Google charts returning empty php mysql
I’m creating a Chart with php mysql, but the same is not returning anything on the screen. Queries are working normally in mysql. <script type="text/javascript"…
-
6
votes3
answers1926
viewsQ: How do you know how many days are in the current month?
How to know how many days is the current month Mysql, example: setembro = 30dias Motive: I have a goal : exemplo: 1.000,000 I need to take the value of the goal and divide by the amount of days you…
-
-1
votes2
answers79
viewsQ: When giving the result of a query, this inserting only the first line
I am bringing a query from one bank and I will insert in another,this running the question and that is only inserting the first line and not all the results,see my script below: <?php…
-
2
votes1
answer305
viewsQ: Google Chats: Show total above column and grid show 1 to 1
I have the following Chart: I need to display row 1 to 1 and display the number also of the total at the top of the column. I know that the two will give the same result, and that I have 2 different…
-
0
votes1
answer275
viewsQ: Mysql query with last 30 day results showing totals per day
I have a query where you get results from the last few days, I need the results to be shown per day, I used the group by , but it hasn’t worked yet, as you can see below. resultado esperado:…
mysqlasked Chefe Druida 1,086 -
2
votes1
answer344
viewsQ: Pick up only the days of the current month
I have the query below where it is made on the current day, how could make the same query in the current month until today, example: 01/09 to 13/09, but so that tomorrow’s consultation is: 01/09 to…
-
0
votes1
answer53
viewsQ: Google charts returning null in mysql query and loop
If I perform the query in the database it returns values, already in Charts it is returning null, what I am doing wrong ? <?php require("conexao.php"); //chama o arquivo de conexão ao BD…
-
0
votes3
answers994
viewsQ: Query with connection to more than one mysql php database
I have 3 databases and I’m searching for information on the three, but in my first query I’ve come across an error: It is as if the query is searching in another database that is not what I…
-
1
votes1
answer1136
viewsQ: How to adjust the entire screen according to the resolution of the monitor?
How to adjust the entire screen according to the resolution of the monitor? See the image below: My Dashboard is getting like in the picture B how could I make to look like a To. I’m using php +…
-
1
votes2
answers234
viewsQ: Confirmation question before entering into database
I have the following page of Insert: <?php include("conn_sys.php"); $setor = $_POST ["setor"]; $fornec = $_POST ["fornec"]; $desc = $_POST ["desc"]; $id_usuario = $_POST ["id_usuario"]; $login =…
-
1
votes1
answer109
viewsQ: Limit the number of forms to be printed per page
I have the following code below that generates a form of information brought from the bank. If I print 2 forms of this per page is right on an A4 sheet, but the question is that I have tried to…
-
-2
votes2
answers59
viewsQ: Merge variables and include 0 to an 11 digit php field
I’m generating a bar code,: Number of the shop: $v_ficha_loja = $row['ficha_loja']; = (1)or (2)etc.. Number of the environment: $v_ficha_ambiente = $row['ficha_ambiente']; (1)or (2)etc.. And a…
-
1
votes1
answer100
viewsQ: Error while using while to generate barcode
First: I’m using the function below and am implementing a chile. Reason: need to generate several codes, example: 1 2 3 4 5 .... 98 99 100,follows code: <?php $i = 1; while ($i <= 100) {…
-
0
votes1
answer8826
viewsQ: Background with transparent image
As I make the background image transparent and responsive, responsive I managed with the code below, more now I need to put transparecia in the image. CSS body{ background: url(../img/bg.jpg)…
-
1
votes1
answer667
viewsQ: How to land % to integer on google Harts
I got this Chart: In the visible part this percentage, as I do to change the percentage by the whole quantity: Example: As shown in the attached image instead of showing 14.3% show 1. Follows my…
-
0
votes1
answer2180
viewsQ: Change the colors of google Charts
I’m using google Harts generating 4 pizzas. How do I change the colors that appear ? Follows my code: <?php include("conn_user.php"); include("conn_sys.php"); if (!isset($_SESSION))…
-
1
votes1
answer107
viewsQ: system with 2 databases , returning empty mysql php queries
I have a system where I have a user base which is a unified base in a bank, and another base in the system. In my pages I call them so: <?php include("conn_user.php"); include("conn_sys.php");…
-
1
votes1
answer375
viewsQ: Print only selected records at checkbox
I have the following table, but I’m not sure how to use the checkbox, ? And since he’s inside the table he’s showing up in print,. <table class='datatable table table-hover table-bordered…
-
0
votes1
answer79
viewsQ: How to make a select`Multiple` start with the first option already marked PHP Mysql
Follows my component: $query_menu = mysql_query("SELECT rm_id AS FUNCAO, rm_desc AS DESCRICAO, rm_obs AS OBSERVACAO, rm_status AS STATUS FROM radios_menu WHERE rm_status='0'"); echo"<div…
-
1
votes1
answer301
viewsQ: Is there a difference between Java platforms?
In: Java Desktop Java Mobile Java Web Languages are different, or is it standard changing only the environment?
-
1
votes1
answer64
viewsQ: Divide the first record of a column by the last record
I have a table showing data reported during the one month period: DATA REGISTRO 01/06/2016 02/06/2016 03/06/2016 04/06/2016 05/06/2016 50 06/06/2016 60 07/06/2016 10 08/06/2016 20 09/06/2016 50…
excelasked Chefe Druida 1,086 -
1
votes1
answer420
viewsQ: Disable virtual keyboard Cipherlab 9700 Collector via PHP
I created 2 pages in PHP, to run on the collector: Cipherlab 9700 He’s running normally and doing what I want, the only thing I’m not liking is that he keeps opening the digital keyboard and with…
-
0
votes1
answer93
viewsQ: Slider jquery and variable php
I have the following page: <?php ini_set('display_errors', 0 ); error_reporting(0); include"conn_imprep.php"; if (!isset($_SESSION)) session_start(); if (!isset($_SESSION['s_usu_login'])) {…
-
1
votes3
answers711
viewsQ: Split form with radios in 2 columns
I have the following form: <?php echo"<form class='form-horizontal' method='POST' action='reposicao.php'>"; echo"<fieldset>"; echo"<legend>OPÇÕES</legend>"; echo"<input…
-
1
votes2
answers188
viewsQ: Select with date returning empty
Good afternoon, What could be wrong in my query that is returning empty because of the date condition. Follows query: SELECT imp_loja AS LOJA, imp_item AS ITEM, imp_desc AS DESCRICAO, imp_dias_giro…
mysqlasked Chefe Druida 1,086 -
0
votes1
answer3187
viewsQ: Change colors from zebra bootstrap table
I’m using the bootstrap and a table with table-Striped and a zebra is getting very light, ?